public function index()
{
$this->per_page = 20;
$row = $this->general_model->QueryAll("\n select * from tools \n ");
$url = base_url() . 'manage_tools/index/';
parent::pagination($page, $url, count($row), $this->per_page, 3);
$data['list'] = $this->general_model->QueryAll("\n select * from tools t1 \n limit {$this->start_no}, {$this->per_page} \n ");
/* * pagination */
$view = 'core_' . $this->usertype . '_view';
parent::$view('manage_tools/index', $data);
//body
}
function list_pat($page = false)
{
/* * pagination */
$row = $this->general_model->get('patients', '', '', '', '', 'count');
$url = base_url() . 'patient/index/';
parent::pagination($page, $url, $row, $this->per_page, 3);
/* * pagination */
$data['patient'] = $this->general_model->get('patients', $this->start_no, $this->per_page, 'date', $group_by = false, '');
//echo $this->db->last_query();die();
$view = 'core_' . $this->usertype . '_view';
parent::$view('doctor/list_pat', $data);
}
public function list_tools_group()
{
$search = '';
$txt = $this->input->post('text');
if ($txt != '') {
$txt = str_replace(' ', '', trim($this->input->post('text')));
$search = " and (CONCAT(pat_name,pat_lname) like '%{$txt}%' or pat_id_card like '%{$txt}%' or hn like '%{$txt}%' ) ";
// var_dump($this->input->post('text'));die();
}
$tool_group = $this->general_model->get_field('tool_group_id,tool_group_name', 'tools_group');
$data['tool_group'] = $tool_group;
// $this->per_page = 2;
$row = $this->general_model->get('patients t1', '', '', '', '', '', "pat_id is not NULL {$search} ");
$url = base_url() . 'tools/list_tools_group/';
parent::pagination($page, $url, count($row), $this->per_page, 3);
/* * pagination */
$pat = $this->general_model->get('patients t1', $this->start_no, $this->per_page, '', $group_by = false, '', "pat_id is not NULL {$search} ");
$data_set = array();
foreach ($pat as $key => $value) {
$data_set[$value['pat_id']]['pat_name'] = $value['prefix'] . $value['pat_name'] . ' ' . $value['pat_lname'];
foreach ($tool_group as $k => $v) {
$sql = "SELECT count(t2.tool_group_id) as num \n FROM order_tools t1\n INNER JOIN tools_set t2\n on t1.tool_id = t2.tool_id\n RIGHT JOIN tools_group t3\n on t2.tool_group_id = t3.tool_group_id\n where \n pat_id = {$value['pat_id']}\n AND \n t3.tool_group_id = {$v['tool_group_id']}\n ";
$num = $this->general_model->Query1($sql);
$data_set[$value['pat_id']][$v['tool_group_id']] = $num[0]['num'];
}
}
$data['data_set'] = $data_set;
// var_dump( $data_set,$num);die();
// echo $this->db->last_query();die();
$view = 'core_' . $this->usertype . '_view';
parent::$view('tools/list_tool_group', $data);
}
public function history($id, $page = false)
{
$data['patient'] = $this->general_model->get_row('patients', "pat_id = {$id}");
$data['evol'] = $this->general_model->get_all('evolution', "pat_id = {$id} ");
##
//echo $this->db->last_query();die();
// /* * pagination */
$this->per_page = 20;
$row = $this->general_model->get_all('check_pat', "pat_id = {$id} ", '', 'check_date DESC , check_id DESC');
$url = base_url() . 'patient/history/' . $id . '/';
parent::pagination($page, $url, count($row), $this->per_page, 4);
/* * pagination */
$data['check'] = $this->general_model->get('check_pat', $this->start_no, $this->per_page, 'check_date DESC, check_id DESC', $group_by = false, '', "pat_id = {$id} ");
// echo $this->db->last_query();die();
$view = 'core_' . $this->usertype . '_view';
parent::$view('pat/history', $data);
}
function export_list_tool()
{
#tech
$search = $this->search_text();
$search_date = $this->search_date();
$this->pdf_list_tool();
/* * pagination */
$this->per_page = 20;
$row = $this->general_model->QueryAll("\n select t1.check_id,t1.tech_id,t1.tool_id,t1.order_type,t1.tool_type,t1.order_status,t1.order_id,\n t2.tech_name,t2.tech_lname,\n t4.prefix,t4.pat_name,t4.pat_lname,\n t3.check_date\n from order_tools t1 \n left join techs t2 on t1.tech_id = t2.user_id\n left join check_pat t3 on t1.check_id = t3.check_id\n left join patients t4 on t3.pat_id = t4.pat_id\n where \n t1.order_status not in ('ยกเลิก','กำลังจัดทำอุปกรณ์')\n {$search} {$search_date}\n order by t1.check_id ASC\n ");
$url = base_url() . 'admin/list_tech/';
parent::pagination($page, $url, count($row), $this->per_page, 3);
$list = $this->general_model->QueryAll("\n select t1.check_id,t1.tech_id,t1.tool_id,t1.order_type,t1.tool_type,t1.order_status,t1.order_id,\n t2.tech_name,t2.tech_lname,\n t4.prefix,t4.pat_name,t4.pat_lname,\n t3.check_date\n from order_tools t1 \n left join techs t2 on t1.tech_id = t2.user_id\n left join check_pat t3 on t1.check_id = t3.check_id\n left join patients t4 on t3.pat_id = t4.pat_id\n where \n t1.order_status not in ('ยกเลิก','กำลังจัดทำอุปกรณ์')\n {$search} {$search_date}\n order by t1.check_id ASC\n limit {$this->start_no}, {$this->per_page} \n ");
foreach ($list as $key => $value) {
$data['list'][] = array('pat_id' => $value['pat_id'], 'tech_name' => $value['tech_name'] . ' ' . $value['tech_lname'], 'pat_name' => $value['prefix'] . $value['pat_name'] . ' ' . $value['pat_lname'], 'tool_name' => _get_tools_name($value['tool_id']), 'order_id' => $value['order_id'], 'check_status' => _get_tools_name($value['tool_id']), 'date' => _set_date($value['check_date']));
}
$data['type_topic'] = "รายงานการจัดทำอุปรณ์";
// var_dump($row);die();
$view = 'core_' . $this->usertype . '_view';
parent::$view('admin/list_export', $data);
}
public function list_tools($tool_group_id)
{
$data['type'] = $tool_group_id;
$data['ref'] = base_url() . 'manage_tools_set/list_group/';
$this->per_page = 20;
$row = $this->general_model->QueryAll("\n select * from tools_set \n ");
$url = base_url() . 'manage_tools_set/list_tools/';
parent::pagination($page, $url, count($row), $this->per_page, 3);
$data['list'] = $this->general_model->QueryAll("\n select * from tools_set t1 \n where\n tool_group_id = {$tool_group_id}\n limit {$this->start_no}, {$this->per_page} \n ");
/* * pagination */
$view = 'core_' . $this->usertype . '_view';
parent::$view('manage_tools_set/list_tool', $data);
//body
}
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);
}
