public static function get_jobs($page, $query = "")
{
$select = DB::select('*')->from('jobs');
if (strlen($query)) {
$select = $select->where('job_title', 'LIKE', '%' . $query . '%');
}
$select = $select->order_by('created_at', 'desc')->limit(30)->offset(($page - 1) * 30)->execute()->as_array();
$result = array('total' => DB::count_last_query(), 'rows' => array());
foreach ($select as $s) {
$row = $s;
if ($s['employer_id']) {
$employer = Model_Employer::find($s['employer_id']);
$row['employer_name'] = $employer->employer_name;
} else {
$row['employer_name'] = "ไม่ระบุ";
}
$result['rows'][] = $row;
}
return $result;
}
public function action_view($id)
{
if (!$id) {
Response::redirect('payments');
}
$payment = Model_Payment::find($id);
if (!$payment) {
Response::redirect('payments');
}
$user = Model_User::find($payment->user_id);
$employer = Model_Employer::get_employer($payment->user_id);
$data['payment'] = $payment;
$data['user'] = $user;
$data['employer'] = $employer;
$confirm = Model_PaymentConfirm::get_payment_confirm($id);
$data['confirm'] = $confirm;
$this->theme->set_template('view');
$this->theme->get_template()->set_global('current_menu', "Payments", false);
$this->theme->get_template()->set_global('current_menu_desc', "จัดการรายการการชำระเงินของลูกค้าทั้งหมดในระบบ", false);
$this->theme->get_template()->set('breadcrumb', array(array('title' => "Home", 'icon' => "fa-home", 'link' => Uri::create('home'), 'active' => false), array('title' => "Payments", 'icon' => "fa-barcode", 'link' => Uri::create('payment'), 'active' => false), array('title' => "View", 'icon' => "fa-eye", 'link' => "", 'active' => true)));
$this->theme->set_partial('sidebar', 'common/sidebar');
$this->theme->set_partial('content', 'payment/view')->set($data);
}
public function action_edit($id = null)
{
try {
is_null($id) and Response::redirect('job');
$this->theme->set_template('edit');
$this->theme->get_template()->set_global('current_menu', "Jobs", false);
$this->theme->get_template()->set_global('current_menu_desc', "จัดการตำแหน่งงานทั้งหมดในระบบ", false);
$this->theme->get_template()->set('breadcrumb', array(array('title' => "Home", 'icon' => "fa-home", 'link' => Uri::create('home'), 'active' => false), array('title' => "Jobs", 'icon' => "fa-briefcase", 'link' => Uri::create('job/index'), 'active' => false), array('title' => "Edit", 'icon' => "", 'link' => "", 'active' => true)));
if (!($job = Model_Job::find($id))) {
Session::set_flash('error', 'Could not find job #' . $id);
Response::redirect('job');
}
// $employer = Model_Employer::find($job->employer_id);
if (Input::method() == 'POST') {
$val = Model_Job::validate('edit');
/*$val->add_field('employer_name', 'Employer Name', 'required|max_length[255]');
$val->add_field('employer_tel', 'Employer Tel', 'required');
$val->add_field('employer_email', 'Employer E-Mail', 'required|valid_email');*/
if (Input::post('job_type') == "fulltime") {
$val->add_field('job_title_fulltime', 'Job Title', 'required|max_length[255]');
$val->add_field('job_salary', 'Salary', 'required|is_numeric');
} else {
if (Input::post('job_type') == "project") {
$val->add_field('job_title_project', 'Job Title', 'required|max_length[255]');
$val->add_field('job_budget_type', 'Price offer', 'required');
$val->add_field('job_budget', 'Budget', 'required|is_numeric');
if (Input::post('job_budget_type') == "perunit") {
$val->add_field('job_budget_unit', 'Unit', 'required|max_length[255]');
}
} else {
if (Input::post('job_type') == "contest") {
$val->add_field('job_title_contest', 'Job Title', 'required|max_length[255]');
$val->add_field('job_prize', 'Prize', 'required|max_length[255]');
}
}
}
if ($val->run()) {
$error = false;
// $employer_photo = "";
$job_attachment = "";
/* upload employer logo */
/* $file = Input::file('employer_photo_file');
$allowList = array(".jpeg", ".jpg", ".png");
$path = realpath(DOCROOT."/../../uploads/profile_photo/employer/").DS;
if($file['size'] > 0){
$ext = strtolower(substr($file['name'],strrpos($file['name'],".")));
if(!in_array($ext,$allowList)){
Session::set_flash('error', 'ชนิดของไฟล์ภาพไม่ถูกต้อง');
$error = true;
}
$filename = md5(time());
if(@copy($file['tmp_name'],$path.$filename."-o".$ext)){
$employer_photo = $filename.$ext;
parent::create_cropped_thumbnail($path.$filename."-o".$ext, 466, 360,"@2x");
parent::create_cropped_thumbnail($path.$filename."-o".$ext, 466, 360);
} else {
Session::set_flash('error', 'ไม่สามารถอัพโหลดไฟล์ภาพได้ โปรดลองใหม่อีกครั้ง');
$error = true;
}
} */
/* */
/*if(strlen($employer_photo) && strlen($employer->employer_photo)){
$old_ext = strtolower(substr($employer->employer_photo,strrpos($employer->employer_photo,".")));
$old_filename = substr($employer->employer_photo,0,strrpos($employer->employer_photo,"."));
@unlink($path.$old_filename.$old_ext);
@unlink($path.$old_filename."@2x".$old_ext);
@unlink($path.$old_filename."-o".$old_ext);
}*/
/* upload job attachment */
$file = Input::file('job_attachment_file');
$allowList = array(".pdf", ".doc");
$path = realpath(DOCROOT . "/../../uploads/job_attachment/") . DS;
if ($file['size'] > 0) {
$ext = strtolower(substr($file['name'], strrpos($file['name'], ".")));
if (!in_array($ext, $allowList)) {
Session::set_flash('error', 'ชนิดของไฟล์แนบไม่ถูกต้อง');
$error = true;
}
$filename = md5(time()) . $ext;
if (@copy($file['tmp_name'], $path . $filename)) {
$job_attachment = $filename;
} else {
Session::set_flash('error', 'ไม่สามารถอัพโหลดไฟล์ได้ โปรดลองใหม่อีกครั้ง');
$error = true;
}
}
/* */
if (!$error) {
/*$employer->province_id = Input::post('province_id');
$employer->employer_name = Input::post('employer_name');
$employer->employer_desc = Input::post('employer_desc');
$employer->employer_addr = Input::post('employer_addr');
$employer->employer_tel = Input::post('employer_tel');
$employer->employer_fax = Input::post('employer_fax');
$employer->employer_email = Input::post('employer_email');
$employer->employer_website = Input::post('employer_website');
if(strlen($employer_photo)) $employer->employer_photo = $employer_photo;
$employer->save();*/
$job->employer_id = Input::post('employer_id');
$job->job_desc = Input::post('job_desc');
$job->job_type = Input::post('job_type');
$job->cat_id = Input::post('cat_id');
$job->subcat_id = Input::post('subcat_id');
$job->job_qualifications = Input::post('job_qualifications');
$job->job_skills = Input::post('job_skills');
$job->job_tags = Input::post('job_tags');
if (strlen($job_attachment)) {
$job->job_attachment = $job_attachment;
}
$job->job_is_featured = Input::post('job_is_featured');
$job->job_is_urgent = Input::post('job_is_urgent');
$job->job_is_active = Input::post('job_is_active');
if (Input::post('job_type') == "fulltime") {
$job->job_title = Input::post('job_title_fulltime');
$job->job_areas = Input::post('job_areas');
$job->job_position = Input::post('job_position');
$job->job_welfare = Input::post('job_welfare');
$job->job_salary = Input::post('job_salary');
} else {
if (Input::post('job_type') == "project") {
$job->job_title = Input::post('job_title_project');
$job->job_budget = Input::post('job_budget');
$job->job_budget_type = Input::post('job_budget_type');
$job->job_budget_unit = Input::post('job_budget_unit');
} else {
if (Input::post('job_type') == "contest") {
$job->job_title = Input::post('job_title_contest');
$job->job_prize = Input::post('job_prize');
}
}
}
if ($job->save()) {
/* generate tags */
$title = $job->job_title;
$title_tags = parent::split_tags($title);
if ($job->employer_id) {
$employer = Model_Employer::find($job->employer_id);
$company_tags = parent::split_tags($employer->employer_name);
} else {
$company_tags = array();
}
$tags = array_merge($title_tags, $company_tags);
foreach ($tags as $t) {
$t = strtolower(trim($t));
if (!strlen($t) || $t == " ") {
continue;
}
$tag = Model_JobTag::get_tag($job->id, $t);
if (!$tag) {
$tag = Model_JobTag::forge(array('job_id' => $job->id, 'tag_name' => $t, 'created_at' => time()));
$tag->save();
}
}
/* */
/* generate ref. no. */
if (!strlen($job->ref_no)) {
$job->job_tags = implode(",", Model_JobTag::get_tags_by_job($job->id));
$job->ref_no = "J" . str_pad($job->id, 7, "0", STR_PAD_LEFT);
$job->save();
}
$qualifications = explode(",", Input::post('job_qualifications'));
foreach ($qualifications as $q) {
if (!strlen(trim($q))) {
continue;
}
$qual = Model_JobQualification::get_qualification($job->id, trim($q));
if (!$qual) {
$qual = Model_JobQualification::forge(array('job_id' => $job->id, 'qualification_title' => trim($q), 'created_at' => time()));
$qual->save();
}
}
$skills = explode(",", Input::post('job_skills'));
foreach ($skills as $s) {
if (!strlen(trim($s))) {
continue;
}
$skill = Model_JobSkill::get_skill($job->id, trim($s));
if (!$skill) {
$skill = Model_JobSkill::forge(array('job_id' => $job->id, 'skill_title' => trim($s), 'created_at' => time()));
$skill->save();
}
}
Session::set_flash('success', 'Updated job #' . $id);
Response::redirect('job');
} else {
Session::set_flash('error', 'Could not update job #' . $id);
}
}
} else {
$msg = '<ul>';
foreach ($val->error() as $field => $error) {
$msg .= '<li>' . $error->get_message() . '</li>';
}
$msg .= '</ul>';
Session::set_flash('error', $msg);
}
}
$this->theme->get_template()->set_global('job', $job, false);
// $this->theme->get_template()->set_global('employer', $employer, false);
$this->theme->get_template()->set_global('cats', Model_Category::get_categories(), false);
$this->theme->get_template()->set_global('subcats', json_encode(Model_Subcategory::get_all_subcats()), false);
$current_subcats = Model_Subcategory::get_subcats_by_category($job->cat_id);
$this->theme->get_template()->set_global('current_subcats', $current_subcats, false);
$this->theme->get_template()->set_global('provinces', Model_Province::get_provinces("th"), false);
$this->theme->get_template()->set_global('employers', Model_Employer::get_employers_for_dropdown(), false);
$this->theme->get_template()->set_global('page_specific_js', "form_job.js", false);
$this->theme->set_partial('sidebar', 'common/sidebar');
$this->theme->set_partial('left', 'job/edit');
} catch (Exception $e) {
die($e->getMessage());
}
}
public function action_delete($id = null)
{
try {
is_null($id) and Response::redirect('employer');
if ($employer = Model_Employer::find($id)) {
$user = Model_User::find($employer->user_id);
// delete all user's record
DB::query("DELETE FROM buff_resume_views WHERE employer_id = " . $id)->execute();
DB::query("DELETE FROM buff_jobs WHERE employer_id = " . $id)->execute();
// delete user
$user->delete();
// delete employer
$employer->delete();
Session::set_flash('success', 'Deleted employer #' . $id);
} else {
Session::set_flash('error', 'Could not delete employer #' . $id);
}
Response::redirect('employer');
} catch (Exception $e) {
die($e->getMessage());
}
}
