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); }