$tpl_file = "job.view";
$sql = "SELECT j.name,j.work_station,j.content,j.require_gender_id,j.peoples,j.require_education_id,j.require_age,j.salary_id,j.worktype_id,j.clicked,j.created,j.expire_time,c.name as cache_companyname,m.username as cache_username from {$tb_prefix}jobs as j LEFT JOIN {$tb_prefix}companies c ON j.company_id=c.id LEFT JOIN {$tb_prefix}members m ON j.member_id=m.id where j.id=" . $id;
$result = $pdb->GetRow($sql);
setvar("item", $result);
setvar("Genders", $typeoption->get_cache_type("gender"));
setvar("Educations", $typeoption->get_cache_type('education'));
setvar("Worktypes", $typeoption->get_cache_type('work_type'));
setvar("SalaryLevels", $typeoption->get_cache_type('salary'));
template($tpl_file);
exit;
}
}
if (isset($_POST['pb_action'])) {
if (!empty($_POST['id'])) {
if ($_POST['pb_action'] == "none" || array_key_exists($_POST['pb_action'], $job_status)) {
$result = $job->saveField("status", intval($_POST['pb_action']), $_POST['id']);
} elseif ($_POST['pb_action'] == "del") {
$result = $job->del($_POST['id']);
}
}
}
if (isset($_POST['del'])) {
if (!empty($_POST['id'])) {
$job->del($_POST['id']);
}
}
$fields = "Job.id,Job.name as jobname,Job.created,Job.status as jobstatus, c.name as companyname,m.username";
$sql = "SELECT count(id) AS Amount FROM {$tb_prefix}jobs";
$amount = $pdb->GetOne($sql);
$joins = "LEFT JOIN {$tb_prefix}companies c ON Job.company_id=c.id LEFT JOIN {$tb_prefix}members m ON Job.member_id=m.id";
$page->setPagenav($amount);
