public function list_approve($type = false)
{
$search = '';
$txt = $this->input->post('text');
if ($txt) {
$txt = str_replace(' ', '', trim($this->input->post('text')));
$search = " and CONCAT(t3.pat_name,t3.pat_lname) like '%{$txt}%' ";
// var_dump($this->input->post('text'));die();
}
$search_date = $this->search_date();
if ($type == false) {
$check_status = "กำลังจัดทำอุปกรณ์ กรอกข้อมูลแล้ว";
##แล้วยืนยันการจัดทำอุปกรณื
} elseif ($type == 'before') {
$check_status = "ตรวจก่อนทำสวยงามแล้ว";
} elseif ($type == 'after') {
$check_status = "ประเมิณหลังทำสวยงามแล้ว";
}
/* * pagination */
$this->per_page = 20;
$row = $this->general_model->QueryAll("\n select * from order_tools t1 \n inner join check_pat t2 on t1.check_id = t2.check_id\n inner join patients t3 on t3.pat_id = t2.pat_id \n where \n t1.tech_id={$this->user_id} \n and t2.check_status = '{$check_status}'\n {$search} {$search_date}\n group by t2.check_id\n order by t2.date\n ", 'count');
$url = base_url() . 'admin/list_doctors/';
parent::pagination($page, $url, count($row), $this->per_page, 3);
$list = $this->general_model->QueryAll("\n select * from order_tools t1 \n inner join check_pat t2 on t1.check_id = t2.check_id\n inner join patients t3 on t3.pat_id = t2.pat_id \n where \n t1.tech_id={$this->user_id} \n and t2.check_status = '{$check_status}'\n {$search} {$search_date}\n group by t2.check_id\n order by t2.date\n limit {$this->start_no}, {$this->per_page} \n ");
/* * pagination */
foreach ($list as $key => $value) {
$data['list'][] = array('check_id' => $value['check_id'], 'doc_id' => $value['doc_id'], 'name' => $value['pat_name'] . " " . $value['pat_lname']);
}
$data['type_topic'] = "ยืนยันหลังการตรวจ";
$view = 'core_' . $this->usertype . '_view';
parent::core_tech_view('tech/list_approve', $data);
}
