102 lines
4.0 KiB
PHP
102 lines
4.0 KiB
PHP
<?php
|
|
|
|
|
|
class Rv_patient extends MY_Controller
|
|
{
|
|
var $db_smartone;
|
|
|
|
public function index()
|
|
{
|
|
echo "RE Patient API";
|
|
}
|
|
|
|
public function __construct()
|
|
{
|
|
parent::__construct();
|
|
$this->db_smartone = $this->load->database("onedev", true);
|
|
}
|
|
|
|
public function search()
|
|
{
|
|
$prm = $this->sys_input;
|
|
$max_rst = 10;
|
|
|
|
$nolab = '%' . $prm["nolab"] . '%';
|
|
$search = '%' . $prm["search"] . '%';
|
|
$page = $prm['page'];
|
|
|
|
if ($prm['nolab'] != '')
|
|
$nolab = "%{$prm['nolab']}%";
|
|
|
|
if ($page == null)
|
|
$page = 1;
|
|
|
|
$offset = ($page - 1) * $max_rst;
|
|
|
|
// QUERY TOTAL
|
|
$sql = "select count(*) total
|
|
from t_orderheader
|
|
join m_patient on T_OrderHeaderM_PatientID = M_PatientID
|
|
join m_doctor da on T_OrderHeaderPJM_DoctorID = da.M_DoctorID
|
|
JOIN m_company on T_OrderHeaderM_CompanyID = M_CompanyID
|
|
JOIN m_mou on T_OrderHeaderM_MouID = M_MouID
|
|
JOIN helper_order ON Helper_OrderT_OrderHeaderID = T_OrderHeaderID
|
|
AND Helper_OrderIsLAB = 'Y'
|
|
where T_OrderHeaderIsActive = 'Y'
|
|
and T_OrderHeaderLabNumber like ?
|
|
and
|
|
( M_PatientName LIKE ?
|
|
or ((M_PatientHP LIKE ? and M_PatientHP IS NOT NULL))
|
|
or ((M_PatientDOB LIKE ? and M_PatientDOB IS NOT NULL))
|
|
)
|
|
order by T_OrderHeaderLabNumber DESC";
|
|
$query = $this->db_smartone->query($sql, [$nolab, $search, $search, $search ]);
|
|
|
|
if ($query) {
|
|
$tot_count = $query->result_array()[0]["total"];
|
|
}
|
|
else {
|
|
$this->sys_error_db("re count", $this->db_smartone);
|
|
exit;
|
|
}
|
|
|
|
$sql = "select T_OrderHeaderID, T_OrderHeaderLabNumber, T_OrderHeaderDate,
|
|
M_PatientID, M_PatientNoReg, fn_global_patient_name(M_PatientID) M_PatientName,
|
|
M_PatientDOB, T_OrderHeaderM_PatientAge, M_PatientHP, M_SexName,
|
|
da.M_DoctorID doctor_pj_id, fn_global_doctor_name(da.M_DoctorID) doctor_pj_name,
|
|
M_MouID, M_MouName, M_CompanyID, M_CompanyName,
|
|
T_OrderHeaderFoNote, T_OrderHeaderSamplingNote, T_OrderHeaderResultNote, M_LangCode,
|
|
T_OrderHeaderLangIsSI is_si
|
|
from t_orderheader
|
|
join m_patient on T_OrderHeaderM_PatientID = M_PatientID
|
|
join m_doctor da on T_OrderHeaderPJM_DoctorID = da.M_DoctorID
|
|
JOIN m_company on T_OrderHeaderM_CompanyID = M_CompanyID
|
|
JOIN m_mou on T_OrderHeaderM_MouID = M_MouID
|
|
JOIN m_sex on M_PatientM_SexID = M_SexID
|
|
JOIN helper_order ON Helper_OrderT_OrderHeaderID = T_OrderHeaderID
|
|
AND Helper_OrderIsLAB = 'Y'
|
|
JOIN m_lang ON T_OrderHeaderM_LangID = M_LangID
|
|
where T_OrderHeaderIsActive = 'Y'
|
|
and T_OrderHeaderLabNumber like ?
|
|
and
|
|
( M_PatientName LIKE ?
|
|
or ((M_PatientHP LIKE ? and M_PatientHP IS NOT NULL))
|
|
or ((M_PatientDOB LIKE ? and M_PatientDOB IS NOT NULL))
|
|
)
|
|
order by T_OrderHeaderLabNumber DESC
|
|
limit {$offset}, {$max_rst}";
|
|
$query = $this->db_smartone->query($sql, [$nolab, $search, $search, $search ]);
|
|
|
|
if ($query) {
|
|
$rows = $query->result_array();
|
|
foreach ($rows as $k => $v)
|
|
$rows[$k]['data'] = json_decode($v['data']);
|
|
$result = array("total" => $tot_count, "total_page" => ceil($tot_count/$max_rst), "cur_page" => $page, "records" => $rows, "total_display" => sizeof($rows), "q" => $this->db_smartone->last_query());
|
|
$this->sys_ok($result);
|
|
}
|
|
else {
|
|
$this->sys_error_db("worklist rows", $this->db_smartone);
|
|
exit;
|
|
}
|
|
}
|
|
} |