142 lines
5.3 KiB
PHP
142 lines
5.3 KiB
PHP
<?php
|
|
class Getorder extends MY_Controller
|
|
{
|
|
public function __construct()
|
|
{
|
|
parent::__construct();
|
|
}
|
|
|
|
public function index()
|
|
{
|
|
echo "GET RESULT";
|
|
}
|
|
|
|
public function getdata()
|
|
{
|
|
try {
|
|
$prm = $this->sys_input;
|
|
$limit = 10;
|
|
if (isset($prm['limit'])) {
|
|
$limit = trim($prm["limit"]);
|
|
$limit = $prm['limit'];
|
|
}
|
|
$sql = "SELECT
|
|
T_OrderHeaderID,
|
|
Mgm_McuID,
|
|
T_OrderHeaderLabNumber as no_reg,
|
|
T_OrderHeaderDate,
|
|
|
|
concat(M_TitleName, ' ',
|
|
ifnull(M_PatientPrefix,' '),
|
|
M_PatientName,
|
|
ifnull(M_PatientSuffix,'')
|
|
) as nama_pasien,
|
|
'' as test,
|
|
M_PatientIDNumber,
|
|
M_PatientHP,
|
|
IFNULL(Mcu_OrderStatus,'-') as Mcu_OrderStatus,
|
|
IFNULL(Mcu_OrderStatusLab,'-') as Mcu_OrderStatusLab,
|
|
IFNULL(Mcu_OrderStatusNonLab,'-') as Mcu_OrderStatusNonLab,
|
|
IFNULL(Mcu_OrderStatusFisik,'-') as Mcu_OrderStatusFisik,
|
|
IFNULL(Mcu_OrderStatusRiwayat,'-') as Mcu_OrderStatusRiwayat,
|
|
IFNULL(Mcu_OrderStatusFitness,'-') as Mcu_OrderStatusFitness,
|
|
Mcu_OrderRetry, Mcu_OrderStatus
|
|
from t_orderheader
|
|
join t_orderdetail
|
|
ON T_OrderHeaderID = T_OrderDetailT_OrderHeaderID
|
|
AND T_OrderDetailIsActive = 'Y'
|
|
AND T_OrderHeaderIsActive = 'Y'
|
|
join m_mou
|
|
ON T_OrderHeaderM_MouID = M_MouID
|
|
AND M_MouIsActive = 'Y'
|
|
AND M_MouIsReleased = 'Y'
|
|
AND M_MouIsBill = 'Y'
|
|
left join one_etl.mcu_order
|
|
ON T_OrderHeaderID = Mcu_OrderT_OrderHeaderID
|
|
left join one_etl.mgm_mcu
|
|
ON Mgm_McuID = Mcu_OrderMgm_McuID AND Mgm_McuIsActive = 'Y'
|
|
join m_patient
|
|
ON T_OrderHeaderM_PatientID = M_PatientID
|
|
join m_title
|
|
on M_PatientM_TitleID = M_TitleID
|
|
WHERE (
|
|
Mcu_OrderStatus = 'C'
|
|
OR Mcu_OrderStatus = 'R'
|
|
OR Mcu_OrderStatus = 'E'
|
|
) AND Mcu_OrderRetry <= 5
|
|
AND Mgm_McuID IS NOT NULL
|
|
group by T_OrderHeaderID
|
|
|
|
UNION
|
|
|
|
select
|
|
T_OrderHeaderID,
|
|
Mgm_McuID,
|
|
T_OrderHeaderLabNumber as no_reg,
|
|
T_OrderHeaderDate,
|
|
concat(M_TitleName, ' ',
|
|
ifnull(M_PatientPrefix,' '),
|
|
M_PatientName,
|
|
ifnull(M_PatientSuffix,'')
|
|
) as nama_pasien,
|
|
'' as test,
|
|
M_PatientIDNumber,
|
|
M_PatientHP,
|
|
IFNULL(Mcu_OrderStatus,'-') as Mcu_OrderStatus,
|
|
IFNULL(Mcu_OrderStatusLab,'-') as Mcu_OrderStatusLab,
|
|
IFNULL(Mcu_OrderStatusNonLab,'-') as Mcu_OrderStatusNonLab,
|
|
IFNULL(Mcu_OrderStatusFisik,'-') as Mcu_OrderStatusFisik,
|
|
IFNULL(Mcu_OrderStatusRiwayat,'-') as Mcu_OrderStatusRiwayat,
|
|
IFNULL(Mcu_OrderStatusFitness,'-') as Mcu_OrderStatusFitness,
|
|
Mcu_OrderRetry, Mcu_OrderStatus
|
|
from t_orderheader
|
|
join t_orderdetail
|
|
ON T_OrderHeaderID = T_OrderDetailT_OrderHeaderID
|
|
AND T_OrderDetailIsActive = 'Y'
|
|
AND T_OrderHeaderIsActive = 'Y'
|
|
join m_mou
|
|
ON T_OrderHeaderM_MouID = M_MouID
|
|
AND M_MouIsActive = 'Y'
|
|
AND M_MouIsReleased = 'Y'
|
|
left join one_etl.mcu_order
|
|
ON T_OrderHeaderID = Mcu_OrderT_OrderHeaderID
|
|
left join one_etl.mgm_mcu
|
|
ON Mgm_McuID = Mcu_OrderMgm_McuID AND Mgm_McuIsActive = 'Y'
|
|
join m_patient
|
|
ON T_OrderHeaderM_PatientID = M_PatientID
|
|
join m_title
|
|
on M_PatientM_TitleID = M_TitleID
|
|
join f_payment
|
|
ON t_orderheader.T_OrderHeaderID = F_PaymentT_OrderHeaderID
|
|
AND F_PaymentIsActive = 'Y'
|
|
join f_payment_orderheader
|
|
ON F_PaymentID = F_Payment_OrderHeaderF_PaymentID
|
|
AND F_Payment_OrderHeaderIsLunas = 'Y'
|
|
WHERE (
|
|
Mcu_OrderStatus = 'C'
|
|
OR Mcu_OrderStatus = 'R'
|
|
OR Mcu_OrderStatus = 'E'
|
|
) AND Mcu_OrderRetry <= 5
|
|
AND Mgm_McuID IS NOT NULL
|
|
group by T_OrderHeaderID
|
|
limit $limit";
|
|
|
|
$query = $this->db->query($sql);
|
|
$last_qry = $this->db->last_query();
|
|
if (!$query) {
|
|
$error = array(
|
|
"message" => $this->db->error()["message"],
|
|
"sql" => $last_qry
|
|
);
|
|
$this->sys_error_db($error);
|
|
exit;
|
|
}
|
|
$rows = $query->result_array();
|
|
$this->sys_ok($rows);
|
|
} catch (Exception $exc) {
|
|
$message = $exc->getMessage();
|
|
$this->sys_error($message);
|
|
}
|
|
}
|
|
}
|