public function modify($stateId, $name, $status)
{
global $STATUS;
if (!empty($stateId) && !empty($name)) {
$newData = array('name' => $name);
if (in_array($status, array(0, 1))) {
$newData['status'] = $STATUS[$status];
}
$where = array('state_id' => array('op' => '=', 'val' => $stateId));
return parent::update($newData, $where);
}
}
protected function __construct()
{
parent::__construct();
}
public function getById($jobId)
{
return parent::select(array('job_id' => array('op' => '=', 'val' => $jobId)));
}
public function getById($cityId)
{
return parent::select(array('city_id' => array('op' => '=', 'val' => $cityId)));
}
public function getById($stateId)
{
return parent::select(array('state_id' => array('op' => '=', 'val' => $stateId)));
}
public function getById($qualificationId)
{
return parent::select(array('qualification_id' => array('op' => '=', 'val' => $qualificationId)));
}
public function modify($employer_login_id, $login_type, $fullname, $phone, $passwd, $company_id, $status, $update_by)
{
return parent::update(array('login_type' => $login_type, 'fullname' => $fullname, 'phone' => $phone, 'passwd' => $passwd, 'last_update_date' => time(), 'status' => $status, 'update_by' => $update_by), array('employer_login_id' => array('op' => '=', 'val' => $employer_login_id)));
}
public function create($title, $description_1, $company_id, $job_id, $qualification_id, $current_job_id, $experience, $description_2, $keywords)
{
global $STATUS;
return parent::add(array('title' => $title, 'description_1' => $description_1, 'company_id' => $company_id, 'job_id' => $job_id, 'qualification_id' => $qualification_id, 'current_job_id' => $current_job_id, 'experience' => $experience, 'description_2' => $description_2, 'keywords' => $keywords, 'status' => $STATUS[0]));
}
public function modify($company_id, $name, $contact_persion, $contact_no, $email, $address1, $status, $update_by)
{
global $STATUS;
return parent::update(array('name' => $name, 'contact_person' => $contact_persion, 'contact_number' => $contact_no, 'email' => $email, 'address1' => $address1, 'last_update_date' => time(), 'status' => $STATUS[$status], 'update_by' => $update_by), array('company_id' => array('op' => '=', 'val' => $company_id)));
}
public function deleteByCompanyId($id)
{
return parent::delete(array('company_id' => array('op' => '=', 'val' => $id)));
}