PHP Calendar::getSQLDateTime方法代碼示例

 public function registerJobSeeker($data)
 {
     $uDao = new UsersDao();
     $user = new stdClass();
     $user->email = $data->email;
     $user->password = md5($data->password);
     $user->firstname = $data->firstname;
     $user->lastname = $data->lastname;
     $user->fb_user_id = $data->fb_user_id;
     $user->birthday = $data->birthday;
     $user->gender = $data->gender;
     $user->location_name = $data->location_name;
     $user->location_id = $data->location_id;
     $user->country = $data->country;
     $user->locale = $data->locale;
     $user->date_created = Calendar::getSQLDateTime();
     $response = new stdClass();
     $response->success = false;
     $response->message = "Failed to register";
     if ($uDao->insert($user)) {
         $response->success = true;
         $response->message = "Registration Complete";
     }
     return $response;
 }

 public function insertRecords($records)
 {
     $urls = $this->jDao->retrieveURLByAPISourceId(2);
     foreach ($records->jobs as $record) {
         if (in_array($record->url, $urls)) {
             $record->jobtitle = $record->title;
             $record->location = $record->locations;
             $record->date_posted = Calendar::formatStringToSQLDateAndTime($record->date);
             $record->website = $record->site;
             $record->api_source_id = 2;
             $record->snippet = $record->description;
             $record->source = $record->company;
             $condition = array('url' => $record->url);
             unset($record->locations, $record->site, $record->salary, $record->description, $record->title, $record->date, $record->url);
             var_dump($this->jDao->updateRecord($record, $condition));
         } else {
             $record->date_created = Calendar::getSQLDateTime();
             $record->jobtitle = $record->title;
             $record->location = $record->locations;
             $record->date_posted = Calendar::formatStringToSQLDateAndTime($record->date);
             $record->website = $record->site;
             $record->api_source_id = 2;
             $record->snippet = $record->description;
             $record->source = $record->company;
             unset($record->locations, $record->site, $record->salary, $record->description, $record->title, $record->date);
             var_dump($this->jDao->insertRecord($record));
         }
     }
 }

 public function insertRecord($record)
 {
     $jobkeys = $this->getAllJobsKey();
     $cBom = new CompaniesBom();
     $companies = $cBom->getAllCompanyNames();
     $this->getConnection()->beginTransaction();
     $company = $cBom->getCompanyIDByCompanyName($record->company);
     if (is_null($company)) {
         $data = new stdClass();
         $data->name = $record->company;
         $cBom->insertRecord($data);
         $record->company_id = $this->getConnection()->getLastInsertID();
     } else {
         $record->company_id = $company->company_id;
     }
     unset($record->company);
     // checks if job key is already existing on our database
     if (in_array($record->jobkey, $jobkeys)) {
         $condition = array('jobkey' => $record->jobkey);
         echo "Update " . $record->jobkey . "<br>";
         unset($record->formattedlocation, $record->date, $record->onmousedown, $record->formattedlocationfull, $record->jobkey, $record->formattedrelativetime);
         var_dump($this->getConnection()->update("jobs", $record, $condition));
     } else {
         $record->date_posted = Calendar::formatStringToSQLDateAndTime($record->date);
         $record->date_created = Calendar::getSQLDateTime();
         echo "Insert " . $record->jobkey . "<br>";
         unset($record->formattedlocation, $record->date, $record->onmousedown, $record->formattedlocationfull, $record->formattedrelativetime);
         var_dump($this->getConnection()->insert("jobs", $record));
     }
     return $this->getConnection()->commitTransaction();
 }

 public function insertRecords($records)
 {
     $urls = $this->jDao->retrieveURLByAPISourceId(6);
     foreach ($records as $record) {
         $parse = $this->parseDescription($record->description);
         $record->company = $parse->company;
         $record->location = $parse->location;
         $record->jobkey = $parse->ref;
         $record->snippet = $parse->summary;
         $record->date_created = Calendar::getSQLDateTime();
         $record->jobtitle = $record->title;
         $record->url = $record->link;
         $record->country = strtoupper($this->getCountry());
         $record->date_posted = str_replace(":", ":", $record->pubdate);
         $record->api_source_id = 6;
         unset($record->title, $record->pubdate, $record->description, $record->guid, $record->link);
         if (in_array($record->url, $urls)) {
             $condition = array('url' => $record->url);
             echo "Update " . $record->jobkey;
             var_dump($this->jDao->updateRecord($record, $condition));
         } else {
             echo "Insert " . $record->jobkey;
             var_dump($this->jDao->insertRecord($record));
         }
     }
 }

 public function insertRecord($record)
 {
     $record->date_created = Calendar::getSQLDateTime();
     return $this->cDao->insertRecord($record);
 }