1167 lines
50 KiB
Plaintext
1167 lines
50 KiB
Plaintext
<?php
|
|
class Test extends CI_Controller
|
|
{
|
|
public function __construct()
|
|
{
|
|
parent::__construct();
|
|
$this->db_onedev = $this->load->database("onedev", true);
|
|
}
|
|
|
|
function index() {
|
|
$this->load->library("Resultcalc");
|
|
|
|
$id = 946;
|
|
$rows = $this->resultcalc->auto($id);
|
|
echo "<pre> $rows";
|
|
}
|
|
|
|
function generatessprice($mgmmcuid){
|
|
$this->load->library('SsPriceMou');
|
|
$this->sspricemou->create($mgmmcuid);
|
|
echo "selesai";
|
|
}
|
|
|
|
function genqrcode($nomorlab,$id){
|
|
$this->load->library('ciqrcode'); //pemanggilan library QR CODE
|
|
$home_dir = "/home/one/project/one/";
|
|
$target_dir = $home_dir . "one-media/one-qrcontrolcard/";
|
|
$config['cacheable'] = false; //boolean, the default is true
|
|
//$config['cachedir'] = './assets/'; //string, the default is application/cache/
|
|
//$config['errorlog'] = './assets/'; //string, the default is application/logs/
|
|
$config['imagedir'] = $target_dir; //direktori penyimpanan qr code
|
|
$config['quality'] = true; //boolean, the default is true
|
|
$config['size'] = '1024'; //interger, the default is 1024
|
|
$config['black'] = array(224,255,255); // array, default is array(255,255,255)
|
|
$config['white'] = array(70,130,180); // array, default is array(0,0,0)
|
|
$this->ciqrcode->initialize($config);
|
|
|
|
$image_name="qrcode_".$nomorlab.".png"; //buat name dari qr code sesuai dengan nim
|
|
|
|
$params['data'] = "http://devcpone.aplikasi.web.id/one-ui/test/vuex/cpone-control-card/?noreg=".$nomorlab."&id=".$id; //data yang akan di jadikan QR CODE
|
|
$params['level'] = 'H'; //H=High
|
|
$params['size'] = 10;
|
|
$params['savename'] = $config['imagedir'].$image_name; //simpan image QR CODE ke folder assets/images/
|
|
$this->ciqrcode->generate($params); // fungsi untuk generate QR CODE
|
|
echo "http://devcpone.aplikasi.web.id/one-api/assets/images/".$image_name;
|
|
|
|
|
|
}
|
|
|
|
function gen_kesimpulan_fisik($id){
|
|
$this->load->library('kesimpulanfisik');
|
|
$kesimpulan = $this->kesimpulanfisik->kesimpulan($id);
|
|
echo $kesimpulan;
|
|
|
|
}
|
|
|
|
function generate_kelainan_fisik_bydate($stardate,$endate){
|
|
$sql = "SELECT *
|
|
FROM so_resultentry
|
|
JOIN t_orderheader ON So_ResultEntryT_OrderHeaderID = T_OrderHeaderID AND T_OrderHeaderIsActive = 'Y' AND
|
|
( DATE(T_OrderHeaderDate) BETWEEN ? AND ? ) AND T_OrderHeaderIsActive = 'Y'
|
|
WHERE
|
|
So_ResultEntryNonlab_TemplateID = 27 AND So_ResultEntryIsActive = 'Y'
|
|
";
|
|
$query = $this->db_onedev->query($sql,array($stardate,$endate));
|
|
//echo $this->db_onedev->last_query();
|
|
$datas = $query->result_array();
|
|
foreach ($datas as $key => $value) {
|
|
$this->gen_kelainan_fisik($value['So_ResultEntryID']);
|
|
}
|
|
}
|
|
|
|
|
|
|
|
/*function gen_kelainan_fisik_all($mgmmcuid,$limit){
|
|
$this->load->library('kesimpulanfisik');
|
|
$kesimpulan = $this->kesimpulanfisik->generate_all_kelainan_fisik($mgmmcuid,$limit);
|
|
echo json_encode($kesimpulan);
|
|
|
|
}
|
|
|
|
function gen_kelainan_fisik($id){
|
|
$this->load->library('kesimpulanfisik');
|
|
$kesimpulan = $this->kesimpulanfisik->generate_kelainan_fisik($id);
|
|
echo json_encode($kesimpulan);
|
|
|
|
}
|
|
|
|
function gen_nonlab_template($id){
|
|
$this->load->library('nonlabtemplate');
|
|
$kesimpulan = $this->nonlabtemplate->generate($id);
|
|
print_r($kesimpulan);
|
|
|
|
}*/
|
|
|
|
|
|
function genpatientqrcode($nomorlab){
|
|
$this->load->library('ciqrcode'); //pemanggilan library QR CODE
|
|
$home_dir = "/home/one/project/one/";
|
|
$target_dir = $home_dir . "one-media/one-qrpatient/";
|
|
$config['cacheable'] = false; //boolean, the default is true
|
|
//$config['cachedir'] = './assets/'; //string, the default is application/cache/
|
|
//$config['errorlog'] = './assets/'; //string, the default is application/logs/
|
|
$config['imagedir'] = $target_dir; //direktori penyimpanan qr code
|
|
$config['quality'] = true; //boolean, the default is true
|
|
$config['size'] = '1024'; //interger, the default is 1024
|
|
$config['black'] = array(224,255,255); // array, default is array(255,255,255)
|
|
$config['white'] = array(70,130,180); // array, default is array(0,0,0)
|
|
$this->ciqrcode->initialize($config);
|
|
|
|
$image_name="patient_qr_".$nomorlab.".png"; //buat name dari qr code sesuai dengan nim
|
|
|
|
$params['data'] = $nomorlab; //data yang akan di jadikan QR CODE
|
|
$params['level'] = 'H'; //H=High
|
|
$params['size'] = 10;
|
|
$params['savename'] = $config['imagedir'].$image_name; //simpan image QR CODE ke folder assets/images/
|
|
$this->ciqrcode->generate($params); // fungsi untuk generate QR CODE
|
|
echo "https://devcpone.aplikasi.web.id/one-media/one-qrpatient/".$image_name;
|
|
//echo "selesai";
|
|
|
|
|
|
}
|
|
|
|
function truncatextable(){
|
|
$this->db = $this->load->database("onedev",true);
|
|
$xgroup= array('PRICE','ORDER');
|
|
$where_in = "";
|
|
foreach ($xgroup as $key => $value) {
|
|
if($where_in != "") $where_in .= " or ";
|
|
$where_in .= "X_TableTransactionGroupName = '".$value."'";
|
|
}
|
|
|
|
|
|
$sql = "SELECT * FROM x_table_transaction
|
|
WHERE
|
|
X_TableTransactionIsActive = 'Y' AND ( $where_in )";
|
|
//echo $sql;
|
|
$data_tables = $this->db->query($sql)->result_array();
|
|
foreach($data_tables as $k => $v){
|
|
$sql = "TRUNCATE TABLE {$v['X_TableTransactionTableName']}";
|
|
//echo $sql;
|
|
//$this->db->query($sql);
|
|
}
|
|
echo 'selesai';
|
|
}
|
|
|
|
function exporttoxls(){
|
|
$this->db = $this->load->database("onedev",true);
|
|
$sql = "SELECT * FROM xtable";
|
|
$data_asal = $this->db->query($sql)->result_array();
|
|
foreach($data_asal as $k => $v){
|
|
$xplode = explode(' ',$v['TANGGAL_LAHIR']);
|
|
$tgl = sprintf("%02d", $xplode[0]);
|
|
$bln = $this->monthtonumber($xplode[1]);
|
|
$thn = $xplode[2];
|
|
$xdate = $tgl.'-'.$bln.'-'.$thn;
|
|
$sql = "UPDATE xtable SET TANGGAL_LAHIR_INA = '{$xdate}' WHERE id = {$v['id']}";
|
|
$this->db->query($sql);
|
|
}
|
|
echo 'selesai';
|
|
}
|
|
|
|
function monthtonumber($xmonth){
|
|
$rst = 0;
|
|
if($xmonth == 'Januari')
|
|
$rst = '01';
|
|
if($xmonth == 'Februari')
|
|
$rst = '02';
|
|
if($xmonth == 'Maret')
|
|
$rst = '03';
|
|
if($xmonth == 'April')
|
|
$rst = '04';
|
|
if($xmonth == 'Mei')
|
|
$rst = '05';
|
|
if($xmonth == 'Juni')
|
|
$rst = '06';
|
|
if($xmonth == 'Juli')
|
|
$rst = '07';
|
|
if($xmonth == 'Agustus')
|
|
$rst = '08';
|
|
if($xmonth == 'September')
|
|
$rst = '09';
|
|
if($xmonth == 'Oktober')
|
|
$rst = '10';
|
|
if($xmonth == 'November')
|
|
$rst = '11';
|
|
if($xmonth == 'Desember')
|
|
$rst = '12';
|
|
return $rst;
|
|
}
|
|
|
|
function two() {
|
|
$this->db = $this->load->database("onedev",true);
|
|
|
|
$id = 946;
|
|
|
|
$sql = "select
|
|
T_TestCalculationID,T_TestCalculationFormula,
|
|
T_OrderDetailID, T_OrderDetailT_TestID, T_TestNat_TestID,
|
|
T_TestCalculationID,T_OrderDetailResult,
|
|
fn_global_age_count_day(M_PatientDOB, date(T_OrderHeaderDate)) / 365 AgeInYear,
|
|
T_TestCalculationNat_SexID
|
|
from t_orderdetail
|
|
join t_orderheader on T_OrderDetailT_OrderHeaderID = T_OrderHeaderID
|
|
and T_OrderHeaderID = ?
|
|
join m_patient on T_OrderHeaderM_PatientID = M_PatientID
|
|
join t_test on T_OrderDetailT_TestID = T_TestID
|
|
and T_OrderDetailIsActive = 'Y' and T_TestIsActive = 'Y'
|
|
join t_testcalculation on T_TestNat_TestID = T_TestCalculationNat_TestID
|
|
and T_TestCalculationIsActive = 'Y'
|
|
and (
|
|
T_TestCalculationNat_SexID = M_PatientM_SexID
|
|
or
|
|
T_TestCalculationNat_SexID = 0
|
|
)
|
|
";
|
|
|
|
$sql_det = "select T_TestCalculationDetailCode, T_OrderDetailResult
|
|
from
|
|
t_testcalculation_detail td
|
|
join t_testcalculation on T_TestCalculationID = T_TestCalculationDetailT_TestCalculationID
|
|
and T_TestCalculationID = ?
|
|
join t_test t on td.T_TestCalculationDetailNat_TestID = T_TestNat_TestID
|
|
left join t_orderdetail on T_TestID = T_OrderDetailT_TestID and T_OrderDetailIsActive = 'Y'
|
|
and T_OrderDetailT_OrderHeaderID = ?
|
|
where T_OrderDetailID is not null";
|
|
|
|
|
|
$qry = $this->db->query($sql, array($id));
|
|
$rows = $qry->result_array();
|
|
if ( count($rows) > 0 ) {
|
|
foreach($rows as $r) {
|
|
if (false && $r["T_OrderDetailResult"] != "") continue;
|
|
$tc_id = $r["T_TestCalculationID"];
|
|
$qry_det = $this->db->query($sql_det, array($tc_id, $id));
|
|
$drows = $qry_det->result_array();
|
|
$formula = $r["T_TestCalculationFormula"];
|
|
$have_all = true;
|
|
$have_one = false;
|
|
$formula = str_replace("AGE",$r["AgeInYear"], $formula);
|
|
foreach($drows as $dr) {
|
|
if($dr["T_OrderDetailResult"] == "" ) {
|
|
$have_all = false;
|
|
break;
|
|
}
|
|
$have_one = true;
|
|
$code = $dr["T_TestCalculationDetailCode"];
|
|
$value = $dr["T_OrderDetailResult"];
|
|
$formula = str_replace($code, $value,$formula);
|
|
}
|
|
if ($have_all && $have_one) {
|
|
echo "Formula : $formula <br/>";
|
|
eval("\$f_value = $formula;");
|
|
$od_id = $r["T_OrderDetailID"];
|
|
$sql = "update t_orderdetail set T_OrderDetailResult = ?
|
|
where T_OrderDetailID = ?";
|
|
$this->db->query($sql, array($f_value,$od_id));
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
|
|
function dynamic_comparison($varleft, $op, $varright)
|
|
{
|
|
|
|
switch ($op) {
|
|
case "=":
|
|
return $varleft == $varright;
|
|
case "!=":
|
|
return $varleft != $varright;
|
|
case ">=":
|
|
return $varleft >= $varright;
|
|
case "<=":
|
|
return $varleft <= $varright;
|
|
case ">":
|
|
return $varleft > $varright;
|
|
case "<":
|
|
return $varleft < $varright;
|
|
default:
|
|
return true;
|
|
}
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
function usg_abdomen(){
|
|
$rtn = [];
|
|
$this->load->library('nonlabtemplate');
|
|
$sql = "SELECT T_SamplingSoID, T_OrderDetailID, T_OrderDetailT_OrderHeaderID, So_ResultEntryID
|
|
FROM `t_orderdetail`
|
|
JOIN t_samplingso ON T_SamplingSoT_OrderHeaderID = T_OrderDetailT_OrderHeaderID AND
|
|
T_SamplingSoT_TestID = T_OrderDetailT_TestID
|
|
LEFT JOIN so_resultentry ON T_OrderDetailT_OrderHeaderID = So_ResultEntryT_OrderHeaderID AND
|
|
So_ResultEntryT_OrderDetailID = T_OrderDetailID AND so_resultentryIsActive = 'Y'
|
|
WHERE
|
|
`T_OrderDetailT_TestID` = '3385' AND So_ResultEntryID IS NULL AND
|
|
T_OrderDetailIsActive = 'Y'";
|
|
$query = $this->db_onedev->query($sql);
|
|
$datas = $query->result_array();
|
|
foreach ($datas as $key => $value) {
|
|
|
|
$kesimpulan = $this->nonlabtemplate->generate($value['T_SamplingSoID']);
|
|
$rtn[] = $kesimpulan['So_ResultEntryID'];
|
|
}
|
|
|
|
echo join(", ",$rtn);
|
|
}
|
|
|
|
|
|
function updatetotalheader(){
|
|
$rtn = [];
|
|
|
|
$sql = "SELECT T_OrderDetailT_OrderHeaderID
|
|
FROM `t_orderdetail`
|
|
JOIN t_orderdetailorder ON T_OrderDetailT_OrderDetailOrderID = T_OrderDetailOrderID AND T_OrderDetailOrderIsActive = 'Y' AND
|
|
`T_OrderDetailIsActive` = 'Y' AND T_OrderDetailIsActive = 'Y'
|
|
JOIN t_packet ON T_OrderDetailOrderT_PacketID = T_PacketID AND T_PacketSasCode IN ('PN2400170','PN2400169','PN2400168','PN2400167','PN2400166','PN2400165','PN2400164','PN2400163','PN2400162',
|
|
'PN2400161','PN2400160','PN2400159','PN2400158','PN2400157','PN2400156','PN2400155','PN2400154','PN2400175')
|
|
GROUP BY T_OrderDetailT_OrderHeaderID";
|
|
$query = $this->db_onedev->query($sql);
|
|
$datas = $query->result_array();
|
|
foreach ($datas as $key => $value) {
|
|
$sql = "SELECT SUM(T_OrderDetailPrice) as total
|
|
FROM `t_orderdetail`
|
|
WHERE `T_OrderDetailIsActive` = 'Y' AND
|
|
`T_OrderDetailT_OrderHeaderID` = {$value['T_OrderDetailT_OrderHeaderID']} AND
|
|
`T_OrderDetailPrice` > '0'
|
|
";
|
|
$query = $this->db_onedev->query($sql);
|
|
//echo $this->db_onedev->last_query();
|
|
$total = $query->row()->total;
|
|
|
|
$sql = "UPDATE t_orderheader SET T_OrderHeaderSubTotal = {$total}, T_OrderHeaderLastUpdatedUserID = 181024, T_OrderHeaderLastUpdated = NOW()
|
|
WHERE T_OrderHeaderID = {$value['T_OrderDetailT_OrderHeaderID']}
|
|
|
|
";
|
|
$query = $this->db_onedev->query($sql);
|
|
//echo $this->db_onedev->last_query();
|
|
|
|
$rtn[] = $value['T_OrderDetailT_OrderHeaderID'];
|
|
}
|
|
|
|
echo join(", ",$rtn);
|
|
}
|
|
|
|
function billirubin_total(){
|
|
$rtn = [];
|
|
$tests = [900,901,902];
|
|
foreach ($tests as $val) {
|
|
$sql = "SELECT *
|
|
FROM (
|
|
SELECT GROUP_CONCAT(T_OrderDetailT_TestID) as exist,
|
|
T_TestID,
|
|
T_TestCode,
|
|
T_TestName,
|
|
T_TestSasCode,
|
|
T_TestIsResult,
|
|
T_TestIsPrice,
|
|
T_OrderDetailT_OrderHeaderID,
|
|
T_OrderDetailT_OrderDetailOrderID
|
|
FROM `t_orderdetail`
|
|
JOIN t_test ON T_TestID = ?
|
|
WHERE
|
|
T_OrderDetailT_TestID IN (899,900,901,902) AND T_OrderDetailIsActive = 'Y'
|
|
GROUP BY T_OrderDetailT_OrderHeaderID
|
|
) x
|
|
WHERE
|
|
exist = '899'";
|
|
$query = $this->db_onedev->query($sql,[$val]);
|
|
//if($val == 900)
|
|
//echo $this->db_onedev->last_query();
|
|
$datas = $query->result_array();
|
|
foreach ($datas as $key => $value) {
|
|
$sql = "INSERT INTO t_orderdetail(
|
|
T_OrderDetailT_OrderHeaderID,
|
|
T_OrderDetailT_OrderDetailOrderID,
|
|
T_OrderDetailT_TestID,
|
|
T_OrderDetailT_TestCode,
|
|
T_OrderDetailT_TestSasCode,
|
|
T_OrderDetailT_TestName,
|
|
T_OrderDetailT_TestIsResult,
|
|
T_OrderDetailT_TestIsPrice,
|
|
T_OrderDetailCreatedUserID,
|
|
T_OrderDetailCreated
|
|
)
|
|
VALUES(?,?,?,?,?,?,?,?,?,NOW())";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$value['T_OrderDetailT_OrderHeaderID'],
|
|
$value['T_OrderDetailT_OrderDetailOrderID'],
|
|
$value['T_TestID'],
|
|
$value['T_TestCode'],
|
|
$value['T_TestSasCode'],
|
|
$value['T_TestName'],
|
|
$value['T_TestIsResult'],
|
|
$value['T_TestIsPrice'],
|
|
270924
|
|
));
|
|
//if($key == 0)
|
|
//echo $this->db_onedev->last_query();
|
|
|
|
$rtn[] = $this->db_onedev->insert_id();
|
|
}
|
|
}
|
|
|
|
echo json_encode($rtn);
|
|
}
|
|
|
|
|
|
function tonometri_remove(){
|
|
$rtn = [];
|
|
$sql = "SELECT So_ResultEntryID, So_ResultEntryT_OrderHeaderID
|
|
FROM `t_orderdetail`
|
|
JOIN so_resultentry ON So_ResultEntryT_OrderHeaderID = T_OrderDetailT_OrderHeaderID AND
|
|
So_ResultEntryNonlab_TemplateID = 27
|
|
WHERE `T_OrderDetailT_TestName` LIKE '%tonometri%' AND `T_OrderDetailIsActive` = 'Y'";
|
|
$query = $this->db_onedev->query($sql);
|
|
|
|
if (!$query) {
|
|
//$this->db_onedev->trans_rollback();
|
|
echo $this->db_onedev->last_query();
|
|
$this->sys_error_db('error', 'Error get order: ' . $this->db_onedev);
|
|
exit;
|
|
}
|
|
|
|
$datas = $query->result_array();
|
|
foreach ($datas as $key => $value) {
|
|
$sql = "SELECT * FROM so_resultentry_fisik_umum WHERE So_ResultEntryFisikUmumSo_ResultEntryID = ?";
|
|
$query = $this->db_onedev->query($sql,[$value['So_ResultEntryID']]);
|
|
$xcount = $query->result_array();
|
|
if(count($xcount) == 1 && $xcount[0]['So_ResultEntryFisikUmumFisikTemplateID'] == 41){
|
|
$sql = "UPDATE so_resultentry_fisik_umum SET So_ResultEntryFisikUmumIsActive = 'N', So_ResultEntryFisikUmumDeleted = NOW(), So_ResultEntryFisikUmumDeletedUserID = 240924
|
|
WHERE So_ResultEntryFisikUmumID = ?";
|
|
$query = $this->db_onedev->query($sql,[$xcount[0]['So_ResultEntryFisikUmumID']]);
|
|
$rtn[] = $xcount[0]['So_ResultEntryFisikUmumID'];
|
|
}
|
|
}
|
|
|
|
echo join(", ",$rtn);
|
|
|
|
|
|
}
|
|
|
|
function generate_kelainan_lab_all($mgmmcuid,$limit){
|
|
$this->load->library('Etlfisik');
|
|
$sql = "SELECT *
|
|
FROM t_orderheader
|
|
WHERE
|
|
T_OrderHeaderMgm_McuID = ? AND T_OrderHeaderIsActive = 'Y' LIMIT ? ";
|
|
$query = $this->db_onedev->query($sql,array($mgmmcuid,intval($limit)));
|
|
//echo $this->db_onedev->last_query();
|
|
$datas = $query->result_array();
|
|
foreach ($datas as $key => $value) {
|
|
//$this->generate_kelainan_lab($value['T_OrderHeaderID']);
|
|
$userID = 1;
|
|
$this->etlfisik->generate_kelainan_lab($value['T_OrderHeaderID'],$userID);
|
|
}
|
|
}
|
|
|
|
function generate_all_kelainan_by_order(){
|
|
|
|
}
|
|
|
|
function fix_panel_satuan_lemak(){
|
|
$id_updates = [];
|
|
$id_inserts = [];
|
|
$sql = "SELECT T_OrderHeaderID, T_OrderDetailOrderID
|
|
FROM t_orderheader
|
|
JOIN t_orderdetailorder ON T_OrderDetailOrderT_OrderHeaderID = T_OrderHeaderID AND
|
|
T_OrderHeaderIsActive = 'Y'
|
|
JOIN t_packet ON T_OrderDetailOrderT_PacketID = T_PacketID AND T_PacketSasCode IN (
|
|
'PN2400194', 'PN2400192', 'PN2400191', 'PN2400190', 'PN2400189', 'PN2400188', 'PN2400187', 'PN2400186', 'PN2400185', 'PN2400184', 'PN2400183'
|
|
)
|
|
GROUP BY T_OrderHeaderID
|
|
";
|
|
$query = $this->db_onedev->query($sql);
|
|
//echo $this->db_onedev->last_query();
|
|
$datas = $query->result_array();
|
|
foreach ($datas as $key => $value) {
|
|
/*" SELECT *
|
|
FROM `t_orderdetail` WHERE `T_OrderDetailT_OrderHeaderID` = '10880' AND
|
|
`T_OrderDetailIsActive` = 'Y' AND `T_OrderDetailT_TestSasCode` LIKE '10520200%' "*/
|
|
|
|
$sql = "UPDATE t_orderdetail SET T_OrderDetailIsActive = 'N', T_OrderDetailDeleted = NOW(), T_OrderDetailDeletedUserID = 221077
|
|
WHERE T_OrderDetailT_OrderHeaderID = ? AND `T_OrderDetailT_TestSasCode` LIKE '10520200%' AND T_OrderDetailIsActive = 'Y'";
|
|
$query = $this->db_onedev->query($sql,array($value['T_OrderHeaderID']));
|
|
if (!$query) {
|
|
//$this->db_onedev->trans_rollback();
|
|
echo $this->db_onedev->last_query();
|
|
$this->sys_error_db('error', 'Error update : ' . $this->db_onedev);
|
|
exit;
|
|
}
|
|
$id_updates[] = $value['T_OrderHeaderID'];
|
|
|
|
$sql = "INSERT INTO t_orderdetail (
|
|
T_OrderDetailT_OrderHeaderID,
|
|
T_OrderDetailT_OrderDetailOrderID,
|
|
T_OrderDetailT_TestID,
|
|
T_OrderDetailT_TestCode,
|
|
T_OrderDetailT_TestSasCode,
|
|
T_OrderDetailT_TestName,
|
|
T_OrderDetailT_TestIsResult,
|
|
T_OrderDetailT_TestIsPrice,
|
|
T_OrderDetailPrice,
|
|
T_OrderDetailPriceForDisc,
|
|
T_OrderDetailTotal,
|
|
T_OrderDetailCreatedUserID,
|
|
T_OrderDetailCreated
|
|
)
|
|
VALUES(?,?,?,?,?,?,?,?,?,?,?,5577,NOW())";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$value['T_OrderHeaderID'],
|
|
$value['T_OrderDetailOrderID'],
|
|
"955",
|
|
'10520800',
|
|
'10520800',
|
|
'Cholesterol/HDL Chol. Ratio',
|
|
'Y',
|
|
'Y',
|
|
0,
|
|
0,
|
|
0
|
|
));
|
|
if (!$query) {
|
|
//$this->db_onedev->trans_rollback();
|
|
echo $this->db_onedev->last_query();
|
|
$this->sys_error_db('error', 'Error insert : ' . $this->db_onedev);
|
|
exit;
|
|
}
|
|
$id_inserts[] = $this->db_onedev->insert_id();
|
|
|
|
}
|
|
$rtn = array(
|
|
"id_inserts" => join(", ",$id_inserts),
|
|
"header_id_update" => join(", ",$id_updates)
|
|
);
|
|
|
|
echo json_encode($rtn);
|
|
}
|
|
|
|
function generate_kelainan_fisik_all($mgmmcuid,$limit){
|
|
$this->load->library('Etlfisik');
|
|
$sql = "SELECT *
|
|
FROM t_orderheader
|
|
JOIN so_resultentry ON So_ResultEntryT_OrderHeaderID = T_OrderHeaderID AND So_ResultEntryNonlab_TemplateID = 27 AND
|
|
So_ResultEntryIsActive = 'Y'
|
|
WHERE
|
|
T_OrderHeaderMgm_McuID = ? AND T_OrderHeaderIsActive = 'Y' LIMIT ? ";
|
|
$query = $this->db_onedev->query($sql,array($mgmmcuid,intval($limit)));
|
|
//echo $this->db_onedev->last_query();
|
|
$datas = $query->result_array();
|
|
foreach ($datas as $key => $value) {
|
|
$userID = 1;
|
|
$this->generate_etl_fisik($value['T_OrderHeaderID']);
|
|
$this->generate_summaries($value['T_OrderHeaderID'], $value['So_ResultEntryID'], $userID);
|
|
}
|
|
}
|
|
|
|
function get_kelainan_order($orderID,$userID){
|
|
$this->load->library('Etlfisik');
|
|
$rtn = $this->etlfisik->generate_kelainan_by_order($orderID,$userID);
|
|
echo json_encode($rtn);
|
|
}
|
|
|
|
function generate_kelainan_non_lab_all($mgmmcuid,$limit){
|
|
$this->load->library('Etlfisik');
|
|
$sql = "SELECT *
|
|
FROM t_orderheader
|
|
WHERE
|
|
T_OrderHeaderMgm_McuID = ? AND T_OrderHeaderIsActive = 'Y' LIMIT ? ";
|
|
$query = $this->db_onedev->query($sql,array($mgmmcuid,intval($limit)));
|
|
//echo $this->db_onedev->last_query();
|
|
$datas = $query->result_array();
|
|
foreach ($datas as $key => $value) {
|
|
//$this->generate_kelainan_lab($value['T_OrderHeaderID']);
|
|
$userID = 1;
|
|
$this->etlfisik->generate_kelainan_nonlab($value['T_OrderHeaderID'],$userID);
|
|
}
|
|
}
|
|
|
|
function inject_fix_gol_darah(){
|
|
$sql = "SELECT *
|
|
FROM t_orderdetail
|
|
WHERE
|
|
T_OrderDetailT_TestID = 292 AND T_OrderDetailIsActive = 'N'; ";
|
|
$query = $this->db_onedev->query($sql,array($mgmmcuid,intval($limit)));
|
|
//echo $this->db_onedev->last_query();
|
|
$datas = $query->result_array();
|
|
foreach ($datas as $key => $value) {
|
|
$sql = "INSERT INTO t_orderdetail (
|
|
T_OrderDetailT_OrderHeaderID,
|
|
T_OrderDetailT_OrderDetailOrderID,
|
|
T_OrderDetailT_TestID,
|
|
T_OrderDetailT_TestCode,
|
|
T_OrderDetailT_TestSasCode,
|
|
T_OrderDetailT_TestName,
|
|
T_OrderDetailPrice,
|
|
T_OrderDetailPriceForDisc,
|
|
T_OrderDetailTotal,
|
|
T_OrderDetailCreatedUserID,
|
|
T_OrderDetailCreated
|
|
)
|
|
VALUES(?,?,?,?,?,?,?,?,?,555,NOW())";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$value['T_OrderDetailT_OrderHeaderID'],
|
|
$value['T_OrderDetailT_OrderDetailOrderID'],
|
|
"288",
|
|
'10130100',
|
|
'10130100',
|
|
'Golongan Darah',
|
|
35000,
|
|
35000,
|
|
35000
|
|
));
|
|
$sql = "INSERT INTO t_orderdetail (
|
|
T_OrderDetailT_OrderHeaderID,
|
|
T_OrderDetailT_OrderDetailOrderID,
|
|
T_OrderDetailT_TestID,
|
|
T_OrderDetailT_TestCode,
|
|
T_OrderDetailT_TestSasCode,
|
|
T_OrderDetailT_TestName,
|
|
T_OrderDetailPrice,
|
|
T_OrderDetailPriceForDisc,
|
|
T_OrderDetailTotal,
|
|
T_OrderDetailCreatedUserID,
|
|
T_OrderDetailCreated
|
|
)
|
|
VALUES(?,?,?,?,?,?,?,?,?,555,NOW())";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$value['T_OrderDetailT_OrderHeaderID'],
|
|
$value['T_OrderDetailT_OrderDetailOrderID'],
|
|
"289",
|
|
'10130200',
|
|
'1013010001',
|
|
'Golongan Darah ABO System',
|
|
0,
|
|
0,
|
|
0
|
|
));
|
|
|
|
if (!$query) {
|
|
//$this->db_onedev->trans_rollback();
|
|
echo $this->db_onedev->last_query();
|
|
$this->sys_error_db('error', 'Error update : ' . $this->db_onedev);
|
|
exit;
|
|
}
|
|
|
|
$sql = "INSERT INTO t_orderdetail (
|
|
T_OrderDetailT_OrderHeaderID,
|
|
T_OrderDetailT_OrderDetailOrderID,
|
|
T_OrderDetailT_TestID,
|
|
T_OrderDetailT_TestCode,
|
|
T_OrderDetailT_TestSasCode,
|
|
T_OrderDetailT_TestName,
|
|
T_OrderDetailPrice,
|
|
T_OrderDetailPriceForDisc,
|
|
T_OrderDetailTotal,
|
|
T_OrderDetailCreatedUserID,
|
|
T_OrderDetailCreated
|
|
)
|
|
VALUES(?,?,?,?,?,?,?,?,?,555,NOW())";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$value['T_OrderDetailT_OrderHeaderID'],
|
|
$value['T_OrderDetailT_OrderDetailOrderID'],
|
|
"290",
|
|
'10130300',
|
|
'1013010002',
|
|
'Golongan Darah Rhesus',
|
|
0,
|
|
0,
|
|
0
|
|
));
|
|
|
|
if (!$query) {
|
|
//$this->db_onedev->trans_rollback();
|
|
echo $this->db_onedev->last_query();
|
|
$this->sys_error_db('error', 'Error insert : ' . $this->db_onedev);
|
|
exit;
|
|
}
|
|
}
|
|
}
|
|
|
|
function generate_etl_fisik($orderID){
|
|
$this->load->library('Etlfisik');
|
|
$userID = 1;
|
|
$this->etlfisik->generate_all_fisik($orderID,$userID);
|
|
}
|
|
|
|
function generate_summaries($orderID,$soReID,$userID,$debugID=0){
|
|
$this->load->library('Etlfisik');
|
|
$userID = 1;
|
|
$this->etlfisik->generate_summaries($orderID,$soReID,$userID,$debugID=0);
|
|
}
|
|
|
|
|
|
function replace_packet($labnumber,$oldpacket_code,$newpacket_code, $userid){
|
|
|
|
|
|
$sql = " SELECT *
|
|
FROM t_packet
|
|
JOIN mgm_mcupacket ON Mgm_McuPacketT_PacketID = T_PacketID AND Mgm_McuPacketIsActive = 'Y'
|
|
JOIN t_orderheader ON T_OrderHeaderMgm_McuID = Mgm_McuPacketMgm_McuID AND T_OrderHeaderLabNumber = ?
|
|
WHERE
|
|
T_PacketSasCode = ? AND T_PacketIsActive = 'Y' LIMIT 1";
|
|
$query = $this->db_onedev->query($sql,array($labnumber,$newpacket_code));
|
|
|
|
if (!$query) {
|
|
//$this->db_onedev->trans_rollback();
|
|
echo $this->db_onedev->last_query();
|
|
$this->sys_error_db('error', 'Error get order: ' . $this->db_onedev);
|
|
exit;
|
|
}
|
|
|
|
$data_new_packet = $query->row_array();
|
|
|
|
if($data_new_packet){
|
|
$sql = " SELECT *
|
|
FROM t_orderheader
|
|
JOIN t_orderdetailorder ON T_OrderDetailOrderT_OrderHeaderID = T_OrderHeaderID AND T_OrderDetailOrderIsActive = 'Y' AND
|
|
T_OrderDetailOrderIsPacket = 'Y'
|
|
JOIN t_packet ON T_PacketSasCode = ? AND T_OrderDetailOrderT_PacketID = T_PacketID
|
|
WHERE
|
|
T_OrderHeaderLabNumber = ? LIMIT 1";
|
|
$query = $this->db_onedev->query($sql,array($oldpacket_code,$labnumber));
|
|
//echo $this->db_onedev->last_query();
|
|
if (!$query) {
|
|
//$this->db_onedev->trans_rollback();
|
|
echo $this->db_onedev->last_query();
|
|
$this->sys_error_db('error', 'Error get order: ' . $this->db_onedev);
|
|
exit;
|
|
}
|
|
//echo $this->db_onedev->last_query();
|
|
|
|
$order = $query->row_array();
|
|
|
|
if($order){
|
|
$this->db_onedev->trans_begin();
|
|
|
|
$new_packet_id = $data_new_packet['T_PacketID'];
|
|
$old_packet_id = $order['T_PacketID'];
|
|
|
|
//INSERT NEW PACKET INTO ORDER DETAIL ORDER
|
|
$sql = "INSERT INTO t_orderdetailorder (
|
|
T_OrderDetailOrderT_OrderHeaderID,
|
|
T_OrderDetailOrderIsPacket,
|
|
T_OrderDetailOrderPacketType,
|
|
T_OrderDetailOrderT_PacketID,
|
|
T_OrderDetailOrderT_PacketName,
|
|
T_OrderDetailOrderCreated,
|
|
T_OrderDetailOrderCreatedUserID
|
|
)
|
|
VALUES(?,'Y',?,?,?,NOW(),?)";
|
|
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$order['T_OrderHeaderID'],
|
|
$data_new_packet['T_PacketType'],
|
|
$data_new_packet['T_PacketID'],
|
|
$data_new_packet['T_PacketName'],
|
|
$userid
|
|
));
|
|
|
|
if (!$query) {
|
|
$this->db_onedev->trans_rollback();
|
|
echo $this->db_onedev->last_query();
|
|
$this->sys_error_db('error', 'Error insert new packet into orderdetail order: ' . $this->db_onedev);
|
|
exit;
|
|
}
|
|
|
|
$new_orderdetail_orderid = $this->db_onedev->insert_id();
|
|
|
|
$sql = "SELECT *
|
|
FROM t_packetdetail
|
|
JOIN t_test ON T_PacketDetailT_TestID = T_TestID
|
|
WHERE
|
|
T_PacketDetailT_PacketID = ? AND
|
|
T_PacketDetailIsActive = 'Y'";
|
|
|
|
$query = $this->db_onedev->query($sql,array($new_packet_id));
|
|
|
|
if (!$query) {
|
|
$this->db_onedev->trans_rollback();
|
|
echo $this->db_onedev->last_query();
|
|
$this->sys_error_db('error', 'Error get packet detail: ' . $this->db_onedev);
|
|
exit;
|
|
}
|
|
|
|
$packet_details = $query->result_array();
|
|
foreach ($packet_details as $key => $value) {
|
|
$data_detail = [];
|
|
$sql = "SELECT *
|
|
FROM t_orderdetail
|
|
WHERE
|
|
T_OrderDetailT_OrderHeaderID = ? AND
|
|
T_OrderDetailT_OrderDetailOrderID = ? AND
|
|
T_OrderDetailT_TestID = ? AND
|
|
T_OrderDetailIsActive = 'Y'";
|
|
$query = $this->db_onedev->query($sql,array($order['T_OrderHeaderID'],$order['T_OrderDetailOrderID'],$value['T_PacketDetailT_TestID']));
|
|
|
|
if (!$query) {
|
|
$this->db_onedev->trans_rollback();
|
|
echo $this->db_onedev->last_query();
|
|
$this->sys_error_db('error', 'Error get packet detail: ' . $this->db_onedev);
|
|
exit;
|
|
}
|
|
|
|
//echo $this->db_onedev->last_query();
|
|
|
|
$data_detail = $query->result_array();
|
|
$orderdetail_sascode = $value['T_TestSasCode']."%";
|
|
//echo "exist-order-lama-".count($data_detail);
|
|
if(count($data_detail) > 0){
|
|
// UPDATE order detail lama diganti orderdetailt_orderdetailorderid baru
|
|
$detail = $data_detail[0];
|
|
$sql = "UPDATE t_orderdetail SET
|
|
T_OrderDetailT_OrderDetailOrderID = ?,
|
|
T_OrderDetailLastUpdatedUserID = ?
|
|
WHERE
|
|
T_OrderDetailT_OrderDetailOrderID = ? AND
|
|
T_OrderDetailT_TestSasCode LIKE ?
|
|
";
|
|
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$new_orderdetail_orderid,
|
|
$userid,
|
|
$order['T_OrderDetailOrderID'],
|
|
$orderdetail_sascode
|
|
));
|
|
|
|
if (!$query) {
|
|
$this->db_onedev->trans_rollback();
|
|
echo $this->db_onedev->last_query();
|
|
$this->sys_error_db('error', 'Error update order detail: ' . $this->db_onedev);
|
|
exit;
|
|
}
|
|
|
|
|
|
}else{
|
|
//insert ke orderdetail jika tidak ditemukan
|
|
$sql = "INSERT INTO t_orderdetail (
|
|
T_OrderDetailT_OrderHeaderID,
|
|
T_OrderDetailT_OrderDetailOrderID,
|
|
T_OrderDetailT_TestID,
|
|
T_OrderDetailT_TestCode,
|
|
T_OrderDetailT_TestSasCode,
|
|
T_OrderDetailT_TestName,
|
|
T_OrderDetailT_TestIsResult,
|
|
T_OrderDetailT_TestIsPanel,
|
|
T_OrderDetailT_TestIsPrice,
|
|
T_OrderDetailPrice,
|
|
T_OrderDetailTotal,
|
|
T_OrderDetailCreated,
|
|
T_OrderDetailCreatedUserID
|
|
)
|
|
SELECT ?,
|
|
?,
|
|
T_TestID,
|
|
T_TestCode,
|
|
T_TestSasCode,
|
|
T_TestName,
|
|
T_TestIsResult,
|
|
'N',
|
|
T_TestIsPrice,
|
|
if(T_TestSasCode = ?, ?,0),
|
|
if(T_TestSasCode = ?, ?,0),
|
|
NOW(),
|
|
?
|
|
FROM t_test
|
|
WHERE
|
|
T_TestSasCode LIKE ?
|
|
";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$order['T_OrderHeaderID'],
|
|
$new_orderdetail_orderid,
|
|
$value['T_TestSasCode'],
|
|
$value['T_PacketDetailPrice'],
|
|
$value['T_TestSasCode'],
|
|
$value['T_PacketDetailPrice'],
|
|
$userid,
|
|
$orderdetail_sascode
|
|
));
|
|
|
|
//echo $this->db_onedev->last_query();
|
|
if (!$query) {
|
|
$this->db_onedev->trans_rollback();
|
|
echo $this->db_onedev->last_query();
|
|
$this->sys_error_db('error', 'Error insert order detail: ' . $this->db_onedev);
|
|
exit;
|
|
}
|
|
}
|
|
}
|
|
|
|
//update isactive = N test lama yg tdk ada di paket baru
|
|
$sql = "UPDATE t_orderdetail SET T_OrderDetailIsActive = 'N', T_OrderDetailDeleted = NOW(), T_OrderDetailDeletedUserID = ?
|
|
WHERE
|
|
T_OrderDetailT_OrderDetailOrderID = ? AND T_OrderDetailIsActive = 'Y'";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$userid,
|
|
$order['T_OrderDetailOrderID']
|
|
));
|
|
|
|
if (!$query) {
|
|
$this->db_onedev->trans_rollback();
|
|
echo $this->db_onedev->last_query();
|
|
$this->sys_error_db('error', 'Error update isactive N order detail: ' . $this->db_onedev);
|
|
exit;
|
|
}
|
|
|
|
$sql = "UPDATE t_orderdetailorder SET T_OrderDetailOrderIsActive = 'N', T_OrderDetailOrderDeleted = NOW(), T_OrderDetailOrderDeletedUserID = ?
|
|
WHERE
|
|
T_OrderDetailOrderID = ?";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$userid,
|
|
$order['T_OrderDetailOrderID']
|
|
));
|
|
|
|
if (!$query) {
|
|
$this->db_onedev->trans_rollback();
|
|
echo $this->db_onedev->last_query();
|
|
$this->sys_error_db('error', 'Error update isactive N order detail order: ' . $this->db_onedev);
|
|
exit;
|
|
}
|
|
|
|
$sql = "SELECT T_SampleStationID, M_LocationID
|
|
FROM t_orderdetail
|
|
JOIN t_test ON T_OrderDetailT_TestID = T_TestID AND T_TestIsActive = 'Y'
|
|
JOIN t_sampletype ON T_TestT_SampleTypeID = T_SampleTypeID
|
|
JOIN t_bahan ON T_SampleTypeT_BahanID = T_BahanID
|
|
JOIN t_samplestation ON T_BahanT_SampleStationID = T_SampleStationID AND T_SampleStationIsActive = 'Y'
|
|
JOIN m_location ON M_LocationT_SampleStationID = T_SampleStationID AND M_LocationIsActive = 'Y'
|
|
WHERE
|
|
T_OrderDetailT_OrderHeaderID = ? AND T_OrderDetailIsActive = 'Y'
|
|
GROUP BY T_SampleStationID ";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$order['T_OrderHeaderID']
|
|
));
|
|
|
|
if (!$query) {
|
|
$this->db_onedev->trans_rollback();
|
|
echo $this->db_onedev->last_query();
|
|
$this->sys_error_db('error', 'Error get station: ' . $this->db_onedev);
|
|
exit;
|
|
}
|
|
|
|
$order_locations = $query->result_array();
|
|
if(count($order_locations) > 0){
|
|
$sql = "UPDATE t_order_location SET T_OrderLocationIsActive = 'X' WHERE T_OrderLocationT_OrderHeaderID = ? AND T_OrderLocationIsActive = 'Y'";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$order['T_OrderHeaderID']
|
|
));
|
|
|
|
foreach ($order_locations as $k => $v) {
|
|
$exist_order_location = [];
|
|
$sql = " SELECT *
|
|
FROM t_order_location
|
|
WHERE
|
|
T_OrderLocationT_OrderHeaderID = ? AND
|
|
T_OrderLocationT_SampleStationID= ? AND
|
|
T_OrderLocationM_LocationID = ? AND
|
|
T_OrderLocationIsActive = 'X' LIMIT 1";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$order['T_OrderHeaderID'],
|
|
$v['T_SampleStationID'],
|
|
$v['M_LocationID']
|
|
));
|
|
$dt_exist_order_location = $query->result_array();
|
|
if(count($dt_exist_order_location) > 0){
|
|
$exist_order_location = $dt_exist_order_location[0];
|
|
$sql = "UPDATE t_order_location SET T_OrderLocationIsActive = 'Y' WHERE T_OrderLocationID = ? ";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$exist_order_location['T_OrderLocationID']
|
|
));
|
|
}else{
|
|
$sql = "INSERT INTO t_order_location (
|
|
T_OrderLocationT_OrderHeaderID,
|
|
T_OrderLocationM_LocationID,
|
|
T_OrderLocationT_SampleStationID,
|
|
T_OrderLocationCreated,
|
|
T_OrderLocationUserID
|
|
)
|
|
VALUES(?,?,?,NOW(),?)";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$order['T_OrderHeaderID'],
|
|
$v['M_LocationID'],
|
|
$v['T_SampleStationID'],
|
|
$userid
|
|
));
|
|
}
|
|
}
|
|
|
|
$sql = "UPDATE t_order_location SET T_OrderLocationIsActive = 'N', T_OrderLocationUserID = ? WHERE T_OrderLocationT_OrderHeaderID = ? AND T_OrderLocationIsActive = 'X'";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$userid,
|
|
$order['T_OrderHeaderID']
|
|
));
|
|
}
|
|
|
|
$sql = "SELECT T_OrderHeaderLabNumber, T_TestID, T_SampleTypeID , T_SampleTypeSuffix, T_SampleStationIsNonLab, T_SampleStationID
|
|
FROM t_orderheader
|
|
JOIN t_orderdetail ON t_orderheaderid = t_orderdetailt_orderheaderid AND t_orderdetailIsActive = 'Y'
|
|
JOIN t_test ON t_orderdetailt_testid = t_testid AND T_TestIsResult = 'Y'
|
|
JOIN group_resultdetail ON Group_ResultDetailT_TestID = T_TestID AND Group_resultDetailIsActive = 'Y'
|
|
JOIN group_result ON Group_ResultDetailGroup_ResultID = Group_ResultID AND Group_ResultFlagNonLab= 'N'
|
|
JOIN t_sampletype ON T_TestT_SampleTypeID = T_SampleTypeID
|
|
JOIN t_bahan ON T_SampleTypeT_BahanID = T_BahanID
|
|
JOIN t_samplestation ON T_BahanT_SampleStationID = T_SampleStationID
|
|
WHERE T_OrderHeaderID = ?
|
|
GROUP BY T_SampleTypeID";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$order['T_OrderHeaderID']
|
|
));
|
|
|
|
$order_samples = $query->result_array();
|
|
if($order_samples){
|
|
$sql = "UPDATE t_ordersample SET T_OrderSampleIsActive = 'X'
|
|
WHERE
|
|
T_OrderSampleT_OrderHeaderID = ? AND T_OrderSampleIsActive = 'Y'";
|
|
$this->db_onedev->query($sql,array(
|
|
$order['T_OrderHeaderID']
|
|
));
|
|
|
|
foreach ($order_samples as $sample) {
|
|
$exist_sample = [];
|
|
$sql = "SELECT *
|
|
FROM t_ordersample
|
|
WHERE
|
|
T_OrderSampleT_OrderHeaderID = ? AND
|
|
T_OrderSampleT_SampleTypeID = ? AND
|
|
T_OrderSampleIsActive = 'X'";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$order['T_OrderHeaderID'],
|
|
$sample['T_SampleTypeID']
|
|
));
|
|
//echo $this->db_onedev->last_query();
|
|
$dt_exist_sample = $query->result_array();
|
|
if(count($dt_exist_sample) > 0){
|
|
$exist_sample = $dt_exist_sample[0];
|
|
$sql = "UPDATE t_ordersample SET T_OrderSampleIsActive = 'Y' WHERE T_OrderSampleID = ?";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$exist_sample['T_OrderSampleID']
|
|
));
|
|
//echo $this->db_onedev->last_query();
|
|
}else{
|
|
$barcode = $labnumber . $sample['T_SampleTypeSuffix']."1";
|
|
|
|
$sql = "INSERT INTO t_barcodelab(
|
|
T_BarcodeLabT_OrderHeaderID,
|
|
T_BarcodeLabBarcode,
|
|
T_BarcodeLabT_SampleTypeID,
|
|
T_BarcodeLabCounter,
|
|
T_BarcodeLabCreated,
|
|
T_BarcodeLabCreatedUserID)
|
|
VALUES (?,?,?,?,NOW(),?)";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$order['T_OrderHeaderID'],
|
|
$barcode,
|
|
$sample['T_SampleTypeID'],
|
|
"1",
|
|
$userid
|
|
));
|
|
|
|
$last_id_barcode = $this->db_onedev->insert_id();
|
|
|
|
$sql = "INSERT INTO t_ordersample(
|
|
T_OrderSampleT_OrderHeaderID,
|
|
T_OrderSampleT_SampleTypeID,
|
|
T_OrderSampleT_BarcodeLabID,
|
|
T_OrderSampleBarcode,
|
|
T_OrderSampleT_SampleStationID,
|
|
T_OrderSampleCreated,
|
|
T_OrderSampleCreatedUserID)
|
|
VALUES(
|
|
?,?,?,?,?,NOW(),?
|
|
)";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$order['T_OrderHeaderID'],
|
|
$sample['T_SampleTypeID'],
|
|
$last_id_barcode,
|
|
$barcode,
|
|
$sample['T_SampleStationID'],
|
|
$userid
|
|
));
|
|
//echo $this->db_onedev->last_query();
|
|
}
|
|
}
|
|
|
|
$sql = "UPDATE t_ordersample SET T_OrderSampleIsActive = 'N'
|
|
WHERE
|
|
T_OrderSampleT_OrderHeaderID = ? AND T_OrderSampleIsActive = 'X'";
|
|
$this->db_onedev->query($sql,array(
|
|
$order['T_OrderHeaderID']
|
|
));
|
|
}
|
|
|
|
$sql = "SELECT *
|
|
FROM t_orderdetail
|
|
JOIN t_test ON T_OrderDetailT_TestID = T_TestID
|
|
JOIN nonlab_template_mapping ON NonlabTemplateMappingNat_TestID = T_TestNat_TestID AND NonlabTemplateMappingIsActive = 'Y'
|
|
JOIN nonlab_template ON NonlabTemplateMappingNonlabTemplateID = NonlabTemplateID AND NonlabTemplateIsActive = 'Y'
|
|
JOIN group_resultdetail ON Group_ResultDetailT_TestID = T_TestID
|
|
JOIN group_result ON Group_ResultDetailGroup_ResultID = Group_ResultID AND Group_ResultFlagNonLab = 'Y'
|
|
WHERE
|
|
T_OrderDetailT_OrderHeaderID = {$order['T_OrderHeaderID']} AND T_OrderDetailIsActive = 'Y'
|
|
GROUP BY T_TestID";
|
|
// echo $sql;
|
|
$query = $this->db_onedev->query($sql);
|
|
|
|
$order_nonlab = $query->result_array();
|
|
if(count($order_nonlab) > 0){
|
|
$sql = "UPDATE so_resultentry SET So_ResultEntryIsActive = 'X'
|
|
WHERE
|
|
So_ResultEntryT_OrderHeaderID = ? AND So_ResultEntryIsActive = 'Y'";
|
|
$this->db_onedev->query($sql,array(
|
|
$order['T_OrderHeaderID']
|
|
));
|
|
|
|
foreach ($order_nonlab as $nonlab) {
|
|
$exist_so = [];
|
|
$sql = "SELECT *
|
|
FROM so_resultentry
|
|
WHERE
|
|
So_ResultEntryT_OrderHeaderID = ? AND
|
|
So_ResultEntryT_OrderDetailID = ? AND
|
|
So_ResultEntryIsActive = 'X'";
|
|
$query = $this->db_onedev->query($sql,array(
|
|
$order['T_OrderHeaderID'],
|
|
$nonlab['T_OrderDetailID']
|
|
));
|
|
|
|
$dt_exist_so = $query->result_array();
|
|
if(count($dt_exist_so) > 0){
|
|
$exist_so = $dt_exist_so[0];
|
|
$sql = "UPDATE so_resultentry SET So_ResultEntryIsActive = 'Y'
|
|
WHERE
|
|
So_ResultEntryID = ? AND So_ResultEntryIsActive = 'X'";
|
|
$this->db_onedev->query($sql,array(
|
|
$exist_so['So_ResultEntryID']
|
|
));
|
|
}
|
|
}
|
|
|
|
$sql = "UPDATE so_resultentry SET So_ResultEntryIsActive = 'N'
|
|
WHERE
|
|
So_ResultEntryT_OrderHeaderID = ? AND So_ResultEntryIsActive = 'X'";
|
|
$this->db_onedev->query($sql,array(
|
|
$order['T_OrderHeaderID']
|
|
));
|
|
|
|
}
|
|
|
|
$results = ["status" => true, "msg" => "Ganti Paket Berhasil"];
|
|
|
|
|
|
}else{
|
|
$results = ["status" => false, "msg" => "Gagal ganti paket, kode paket tidak ditemukan"];
|
|
}
|
|
|
|
$this->db_onedev->trans_commit();
|
|
|
|
}
|
|
|
|
echo json_encode($results);
|
|
}
|
|
}
|