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