public function address() { $address = ""; if (isset($this->address) && !empty($this->address)) { $address .= $this->address . ":"; } if (isset($this->address2) && !empty($this->address2)) { $address .= $this->address2 . ":"; } if (isset($this->city) && !empty($this->city)) { $city = City::find_by_code($this->country, $this->state_province, $this->county, $this->city); $address .= $city->name . ":"; } //county if (isset($this->county) && !empty($this->county)) { $county = County::find_by_code($this->country, $this->state_province, $this->county); $address .= $county->name . ":"; } //states if (isset($this->state_province) && !empty($this->state_province)) { $state_province = StateProvince::find_by_code($this->country, $this->state_province); $address .= $state_province->name . ":"; } //post code if (isset($this->post_code) && !empty($this->post_code)) { $address .= $this->post_code . ":"; } //country if (isset($this->country) && !empty($this->country)) { $country = Country::find_by_code($this->country); $address .= $country->name . ":"; } else { return ""; } return $address; }
//locations //country $country_arry = Country::find_by_code($jobs->country); //$country_a($country_arry) ? $country_arry->code : $country_a; $country_var_name = $country_arry->var_name; $country_name = $country_arry->name; $smarty->assign('country', $country_name); $smarty->assign('country_url', $country_var_name); //states $state = StateProvince::find_by_code($jobs->country, $jobs->state_province); $state_name = empty($state) ? $jobs->state_province : $state->name; $state_var_name = $state ? $state->var_name : $jobs->state_province; $smarty->assign('state', $state_name); $smarty->assign('state_url', $country_var_name . "/" . $state_var_name . "/"); //county $county = County::find_by_code($jobs->country, $jobs->state_province, $jobs->county); $county_name = empty($county) ? $jobs->county : $county->name; $county_var_name = $county ? $county->var_name : $jobs->county; $smarty->assign('county', $county_name); $smarty->assign('county_url', $country_var_name . "/" . $state_var_name . "/" . $county_var_name . "/"); $city = City::find_by_code($jobs->country, $jobs->state_province, $jobs->county, $jobs->city); $city_name = empty($city) ? $jobs->city : $city->name; $city_var_name = empty($city) ? $jobs->city : $city->var_name; $smarty->assign('city', $city_name); $smarty->assign('city_url', $country_var_name . "/" . $state_var_name . "/" . $county_var_name . "/" . $city_var_name . "/"); //educations $educations = Education::find_by_id($jobs->fk_education_id); $education_name = !empty($educations) ? $educations->education_name : format_lang('not_provided'); $smarty->assign('education_var_name', $educations->var_name); $smarty->assign('education', $education_name); //career
$job_types = $job_type_arr ? $job_type_arr->type_name : format_lang('none'); $smarty->assign('job_type', $job_types); //where do you wont to work //country $country_arry = Country::find_by_code($cv_details->country); $country_var_name = $country_arry->var_name; $country_name = $country_arry->name; $smarty->assign('country', $country_name); //states $state = StateProvince::find_by_code($cv_details->country, $cv_details->state_province); $state_name = empty($state) ? $cv_details->state_province : $state->name; $state_var_name = $state ? $state->var_name : $cv_details->state_province; $smarty->assign('state', $state_name); $smarty->assign('state_url', $country_var_name . "/" . $state_var_name . "/"); //county $county = County::find_by_code($cv_details->country, $cv_details->state_province, $cv_details->county); $county_name = empty($county) ? $cv_details->county : $county->name; $county_var_name = $county ? $county->var_name : $cv_details->county; $smarty->assign('county', $county_name); $smarty->assign('county_url', $country_var_name . "/" . $state_var_name . "/" . $county_var_name . "/"); $city = City::find_by_code($cv_details->country, $cv_details->state_province, $cv_details->county, $cv_details->city); $city_name = empty($city) ? $cv_details->city : $city->name; $city_var_name = empty($city) ? $cv_details->city : $city->var_name; $smarty->assign('city', $city_name); $smarty->assign('city_url', $country_var_name . "/" . $state_var_name . "/" . $county_var_name . "/" . $city_var_name . "/"); //end of location $authorised_to_work = format_lang('select', 'authorised_to_work'); $aya = !empty($cv_details->are_you_auth) ? $authorised_to_work[$cv_details->are_you_auth] : format_lang('none'); $smarty->assign('aya', $aya); $wtr = !empty($cv_details->willing_to_relocate) ? $get_NoYes[$cv_details->willing_to_relocate] : format_lang('none'); $smarty->assign('wtr', $wtr);
public static function recommendedJob($user_id = 0, $cvjob_title = null, $cvjob_title2 = null, $cvjob_city = null, $cvjob_county = null, $cvjob_state = null, $cvjob_country = null) { global $database, $db; $select = " SELECT job_title, city, county, state_province, country, fk_employer_id,var_name, created_at "; $select .= ", match( job.job_title, job.job_description ) against ('" . $cvjob_title . "' '+" . $cvjob_title2 . "' IN BOOLEAN MODE) as relevance "; $from = " FROM " . self::$table_name . " AS job "; $where = " WHERE job.id NOT IN ( SELECT job_h.fk_job_id from " . TBL_HISTORY . " as job_h WHERE job_h.fk_employee_id={$user_id}) "; $where .= " AND job.is_active='Y' AND job.job_status='approved' AND job.id > 0 "; //$where .= " AND var_name <> '".$old."' "; $where .= " AND match( job.job_title, job.job_description ) against ('" . $cvjob_title . "' '+" . $cvjob_title2 . "' IN BOOLEAN MODE)"; $where .= " AND DATE_ADD( job.created_at, INTERVAL " . JOBLASTFOR . " DAY ) > NOW() "; //$where .= " AND city='{$cvjob_city}' "; $where .= " AND county='{$cvjob_county}' "; $where .= " AND state_province='{$cvjob_state}'"; $where .= " AND country='{$cvjob_country}'"; $order = " ORDER BY relevance, created_at DESC "; $limit = " LIMIT 10 "; //SELECT job.job_title, job.city, job.county, job.state_province, job.country //FROM jobberland_job AS job //WHERE job.id NOT IN (SELECT job_h.fk_job_id from jobberland_job_history as job_h WHERE fk_employer_id = 1) $sql = $select . $from . $where . $order . $limit; //echo $sql; $result = $database->query($sql); $num_rows = $database->num_rows($result); if ($num_rows > 0) { $i = 1; $temp = array(); while ($row = $database->fetch_object($result)) { $temp[$i]['job_title'] = $row->job_title; $temp[$i]['var_name'] = $row->var_name; $temp[$i]['created_at'] = strftime(DATE_FORMAT, strtotime($row->created_at)); //country $country_arry = Country::find_by_code($row->country); $country_name = $country_arry->name; //states $state = StateProvince::find_by_code($row->country, $row->state_province); $state_name = empty($state) ? $row->state_province : $state->name; //county $county = County::find_by_code($row->country, $row->state_province, $row->county); $county_name = empty($county) ? $row->county : $county->name; //city $city = City::find_by_code($row->country, $row->state_province, $row->county, $row->city); $city_name = empty($city) ? $row->city : $city->name; $temp[$i]['location'] = $city_name . ", " . $county_name . ", " . $state_name . ", " . $country_name; $employer = Employer::find_by_id($row->fk_employer_id); $company_name = $employer->company_name; $temp[$i]['company_name'] = $company_name; //$temp[$i]['job_title'] = $row->job_title; //$temp[$i]['job_title'] = $row->job_title; $i++; } return $temp; } return false; }
//IT Manager at IT Lab in London EC1A 9PT if ($jobs) { $job_s = array(); $i = 1; $job_suggestions = Job::apply_suggestion($jobs->job_title, $var_name); foreach ($job_suggestions as $job_suggestion) { $employer = Employer::find_by_id($job_suggestion->fk_employer_id); //locations //country $country_arry = Country::find_by_code($job_suggestion->country); $country_name = $country_arry->name; //states $state = StateProvince::find_by_code($job_suggestion->country, $job_suggestion->state_province); $state_name = empty($state) ? $job_suggestion->state_province : $state->name; //county $county = County::find_by_code($job_suggestion->country, $job_suggestion->state_province, $job_suggestion->county); $county_name = empty($county) ? $job_suggestion->county : $county->name; //city $city = City::find_by_code($job_suggestion->country, $job_suggestion->state_province, $job_suggestion->county, $job_suggestion->city); $city_name = empty($city) ? $job_suggestion->city : $city->name; //end $job_s[$i]['id'] = $job_suggestion->id; $job_s[$i]['var_name'] = $job_suggestion->var_name; $job_s[$i]['job_title'] = $job_suggestion->job_title; $job_s[$i]['company_name'] = $employer->company_name; $job_s[$i]['created_at'] = strftime(DATE_FORMAT, strtotime($job_suggestion->created_at)); $job_s[$i]['location'] = $city_name . ", " . $county_name . ", " . $state_name . ", " . $country_name; $i++; } $smarty->assign('job_suggestion', $job_s); }
///jobs $job_by_locations = Job::list_job_by_location($country_code); if ($job_by_locations2) { $location = array(); $i = 1; foreach ($job_by_locations as $job_by_location) { //city $city_code = City::find_by_code($country_a, null, null, $job_by_location->city); $city_var_name = $city_code ? $city_code->var_name : $job_by_location->city; //states $state_code = $job_by_location->state_province; $state_ = StateProvince::find_by_code($country_a, $state_code); $state_var_name = $state_ ? $state_->var_name : $job_by_location->state_province; //county $county_code = $job_by_location->county; $county_ = County::find_by_code($country_a, $state_code, $county_code); $county_var_name = $county_ ? $county_->var_name : $job_by_location->county; if ($city_code) { /**check length of text */ $location_name = strlen($city_code->name) > 60 ? substr($city_code->name, 0, 30) . " ... " : $city_code->name; } else { /**check length of text */ $location_name = strlen($city_var_name) > 60 ? substr($city_var_name, 0, 30) . " ... " : $city_var_name; } $total_jobs = Job::get_total_job_by_location($country_a, null, null, $job_by_location->city); $location[$i]['total'] = $total_jobs; $location[$i]['name'] = $location_name; $location[$i]['location_id'] = $city->id; $location[$i]['var_name'] = $city_var_name; $location[$i]['url'] = $state_var_name . "/" . $county_var_name . "/"; $i++;