175 lines
9.4 KiB
PHP
175 lines
9.4 KiB
PHP
<?php
|
|
class Check_result extends MY_Controller
|
|
{
|
|
function __construct() {
|
|
parent::__construct();
|
|
}
|
|
function index() {
|
|
echo "<pre>";
|
|
echo "id [NOMOR LAB]\n Untuk check T_OrderHeaderID dari nomorlab itu\n\n";
|
|
echo "cek [T_OrderHeaderID]\n Untuk menampilkan sample dari T_OrderHeaderID yang terkait\n\n";
|
|
echo "cek [T_OrderHeaderID] true\n Untuk menampilkan sample dari T_OrderHeaderID yang terkait termasuk yg IsActive N\n\n";
|
|
echo "update_order_sample [T_OrderSampleID targetNya] [T_OrderSampleID sumbernya]\n Copy status T_OrderSample dari sumber ke target \n\n";
|
|
}
|
|
function update_order_sample($targetID, $sourceID) {
|
|
$sql = "update t_ordersample target
|
|
join t_ordersample source on
|
|
target.T_OrderSampleID = ?
|
|
and target.T_OrderSampleWorklistReceive = 'N'
|
|
and source.T_OrderSampleID = ?
|
|
set
|
|
target.T_OrderSampleSampling = if(target.T_OrderSampleSampling='Y',target.T_OrderSampleSampling, source.T_OrderSampleSampling),
|
|
target.T_OrderSampleSamplingDate = if(target.T_OrderSampleSampling='Y',target.T_OrderSampleSamplingDate, source.T_OrderSampleSamplingDate),
|
|
target.T_OrderSampleSamplingTime = if(target.T_OrderSampleSampling='Y',target.T_OrderSampleSamplingTime, source.T_OrderSampleSamplingTime),
|
|
target.T_OrderSampleSamplingUserID = if(target.T_OrderSampleSampling='Y',target.T_OrderSampleSamplingUserID, source.T_OrderSampleSamplingUserID),
|
|
|
|
target.T_OrderSampleReceive = if(target.T_OrderSampleReceive='Y',target.T_OrderSampleReceive, source.T_OrderSampleReceive),
|
|
target.T_OrderSampleReceiveDate = if(target.T_OrderSampleReceive='Y',target.T_OrderSampleReceiveDate, source.T_OrderSampleReceiveDate),
|
|
target.T_OrderSampleReceiveTime = if(target.T_OrderSampleReceive='Y',target.T_OrderSampleReceiveTime, source.T_OrderSampleReceiveTime),
|
|
target.T_OrderSampleReceiveUserID = if(target.T_OrderSampleReceive='Y',target.T_OrderSampleReceiveUserID, source.T_OrderSampleReceiveUserID),
|
|
|
|
target.T_OrderSampleVerification = if(target.T_OrderSampleVerification='Y',target.T_OrderSampleVerification, source.T_OrderSampleVerification),
|
|
target.T_OrderSampleVerificationDate =if(target.T_OrderSampleVerification='Y',target.T_OrderSampleVerificationDate, source.T_OrderSampleVerificationDate),
|
|
target.T_OrderSampleVerificationTime =if(source.T_OrderSampleVerification='Y',target.T_OrderSampleVerificationTime, source.T_OrderSampleVerificationTime),
|
|
target.T_OrderSampleVerificationUserID =if(source.T_OrderSampleVerification='Y',target.T_OrderSampleVerificationUserID, source.T_OrderSampleVerificationUserID),
|
|
|
|
target.T_OrderSampleProcessing = if(target.T_OrderSampleProcessing='Y',target.T_OrderSampleProcessing, source.T_OrderSampleProcessing),
|
|
target.T_OrderSampleProcessingDate= if(target.T_OrderSampleProcessing='Y',target.T_OrderSampleProcessingDate, source.T_OrderSampleProcessingDate),
|
|
target.T_OrderSampleProcessingTime= if(target.T_OrderSampleProcessing='Y',target.T_OrderSampleProcessingTime, source.T_OrderSampleProcessingTime),
|
|
target.T_OrderSampleProcessingUserID= if(target.T_OrderSampleProcessing='Y',target.T_OrderSampleProcessingUserID, source.T_OrderSampleProcessingUserID),
|
|
|
|
target.T_OrderSampleReceiveHandling =if(target.T_OrderSampleReceiveHandling='Y',target.T_OrderSampleReceiveHandling, source.T_OrderSampleReceiveHandling ),
|
|
target.T_OrderSampleReceiveHandlingDate =if(target.T_OrderSampleReceiveHandling='Y',target.T_OrderSampleReceiveHandlingDate, source.T_OrderSampleReceiveHandlingDate),
|
|
target.T_OrderSampleReceiveHandlingTime =if(target.T_OrderSampleReceiveHandling='Y',target.T_OrderSampleReceiveHandlingTime, source.T_OrderSampleReceiveHandlingTime),
|
|
target.T_OrderSampleReceiveHandlingUserID =if(target.T_OrderSampleReceiveHandling='Y',target.T_OrderSampleReceiveHandlingUserID, source.T_OrderSampleReceiveHandlingUserID),
|
|
|
|
target.T_OrderSampleHandling = if(target.T_OrderSampleHandling='Y',target.T_OrderSampleHandling, source.T_OrderSampleHandling),
|
|
target.T_OrderSampleHandlingDate = if(target.T_OrderSampleHandling='Y',target.T_OrderSampleHandlingDate, source.T_OrderSampleHandlingDate),
|
|
target.T_OrderSampleHandlingTime = if(target.T_OrderSampleHandling='Y',target.T_OrderSampleHandlingTime, source.T_OrderSampleHandlingTime),
|
|
target.T_OrderSampleHandlingUserID = if(target.T_OrderSampleHandling='Y',target.T_OrderSampleHandlingUserID, source.T_OrderSampleHandlingUserID),
|
|
|
|
target.T_OrderSampleWorklistReceive = source.T_OrderSampleWorklistReceive,
|
|
target.T_OrderSampleWorklistReceiveDatetime = source.T_OrderSampleWorklistReceiveDateTime,
|
|
target.T_OrderSampleWorklistReceiveUserID = source.T_OrderSampleWorklistReceiveUserID
|
|
";
|
|
$qry = $this->db->query($sql,array($targetID,$sourceID));
|
|
if(! $qry ) {
|
|
echo json_encode(array( "status" => "ERR" , "message" => print_r($this->db->error(),true)));
|
|
exit;
|
|
}
|
|
}
|
|
|
|
function id($order) {
|
|
echo "<pre>";
|
|
$sql = "select t_orderheader.* from t_orderheader join t_orderheaderaddon on T_OrderHeaderID = T_OrderHeaderAddOnT_OrderHeaderID
|
|
where T_OrderHeaderLabNumber like ? or T_OrderHeaderAddonLabNumberOrigin like ?";
|
|
$qry = $this->db->query($sql, array("%" . $order . "%", "%{$order}%"));
|
|
if (! $qry) {
|
|
echo "ERR : \n" ;
|
|
print_r($this->db->error());
|
|
exit;
|
|
}
|
|
$rows = $qry->result_array();
|
|
foreach($rows as $r) {
|
|
echo "{$r['T_OrderHeaderID']}\t{$r['T_OrderHeaderDate']}\t{$r['T_OrderHeaderLabNumber']}\n";
|
|
}
|
|
}
|
|
function cek($headerID, $all=false) {
|
|
echo "<pre>";
|
|
$sql ="select *
|
|
from t_ordersample
|
|
join t_sampletype on T_OrderSampleT_SampleTypeID = T_SampleTypeID
|
|
where T_OrderSampleIsActive = 'Y' and T_OrderSampleT_OrderHeaderID=? order by T_OrderSampleID";
|
|
if ($all) {
|
|
$sql ="select *
|
|
from t_ordersample
|
|
left join t_sampletype on T_OrderSampleT_SampleTypeID = T_SampleTypeID
|
|
where T_OrderSampleT_OrderHeaderID=? order by T_OrderSampleID";
|
|
}
|
|
$qry = $this->db->query($sql,array($headerID));
|
|
if (! $qry) {
|
|
echo "ERR : \n" ;
|
|
print_r($this->db->error());
|
|
exit;
|
|
}
|
|
$rows = $qry->result_array();
|
|
echo "T_OrderSampleID\tT_OrderSampleBarcode\tT_SampleTypeName\tT_OrderSampleWorklistReceive\tWl RcvDate\Wl RcvTime\tIsActive\n";
|
|
foreach($rows as $r) {
|
|
echo "{$r['T_OrderSampleID']}\t{$r['T_OrderSampleBarcode']}\t{$r['T_SampleTypeName']}\t{$r['T_OrderSampleWorklistReceive']}\t" .
|
|
"{$r['T_OrderSampleWorklistReceiveDatetime']}\t{$r['T_OrderSampleWorklistReceiveUserID']}\t{$r['T_OrderSampleIsActive']}\n";
|
|
}
|
|
}
|
|
function preanalytic($headerID) {
|
|
$sql ="select *
|
|
from t_orderdetailaddon
|
|
join t_orderdetail on T_OrderDetailID = T_OrderDetailAddOnT_OrderDetailID and T_OrderDetailIsActive = 'Y'
|
|
and T_OrderDetailAddOnIsActive = 'Y' and T_OrderDetailT_OrderHeaderID = ?";
|
|
$qry = $this->db->query($sql,array($headerID));
|
|
if (! $qry) {
|
|
echo "ERR : \n" ;
|
|
print_r($this->db->error());
|
|
exit;
|
|
}
|
|
$rows = $qry->result_array();
|
|
echo "T_OrderDetailID\tT_OrderDetailT_TestName\tT_OrderDetailAddOnPreAnalytic\tT_OrderDetailAddOnPreAnalyticDate\n";
|
|
foreach($rows as $r) {
|
|
echo "{$r['T_OrderDetailID']}\t{$r['T_OrderDetailT_TestName']}\t{$r['T_OrderDetailAddOnPreAnalytic']}\t{$r['T_OrderDetailAddOnPreAnalyticDate']}\n";
|
|
}
|
|
}
|
|
function pre_copy_from_to($fromID,$toID) {
|
|
$sql = "update
|
|
t_orderdetailaddon a
|
|
join t_orderdetailaddon b on a.T_OrderDetailAddOnT_OrderDetailID = ?
|
|
and b.T_OrderDetailAddOnT_OrderDetailID = ?
|
|
set b.T_OrderDetailAddOnPreAnalytic = a.T_OrderDetailAddOnPreAnalytic ,
|
|
b.T_OrderDetailAddOnPreAnalyticDate = a.T_OrderDetailAddOnPreAnalyticDate
|
|
";
|
|
$qry = $this->db->query($sql, array($fromID,$toID));
|
|
echo $this->db->last_query() . "\n";
|
|
if (! $qry) {
|
|
echo "ERR : \n" ;
|
|
print_r($this->db->error());
|
|
exit;
|
|
}
|
|
echo "Pre Analytic Update";
|
|
}
|
|
function cek_kuning($headerID) {
|
|
$sql ="select a.T_OrderSampleWorklistReceive , b.T_OrderSampleWorklistReceive bRcv,
|
|
a.T_OrderSampleWorklistReceiveDatetime, b.T_OrderSampleWorklistReceiveDatetime bDate,
|
|
a.T_OrderSampleWorklistReceiveUserID, b.T_OrderSampleWorklistReceiveUserID bUser
|
|
from t_ordersample a
|
|
join t_ordersample b on a.T_OrderSampleT_OrderHeaderID = b.T_OrderSampleT_OrderHeaderID
|
|
and a.T_OrderSampleBarcode like '%SK%' and b.T_OrderSampleBarcode like '%SP%' and b.T_OrderSampleWorklistReceive = 'Y'
|
|
and a.T_OrderSampleIsActive = 'Y' and b.T_OrderSampleIsActive = 'Y'
|
|
and a.T_OrderSampleT_OrderHeaderID = ?";
|
|
$qry = $this->db->query($sql,array($headerID));
|
|
if (! $qry) {
|
|
echo "ERR : \n" ;
|
|
print_r($this->db->error());
|
|
exit;
|
|
}
|
|
$rows = $qry->result_array();
|
|
print_r($rows);
|
|
}
|
|
|
|
function update_kuning($headerID) {
|
|
$sql = "update t_ordersample a
|
|
join t_ordersample b on a.T_OrderSampleT_OrderHeaderID = b.T_OrderSampleT_OrderHeaderID
|
|
and a.T_OrderSampleBarcode like '%SK%' and b.T_OrderSampleBarcode like '%SP%' and b.T_OrderSampleWorklistReceive = 'Y'
|
|
and a.T_OrderSampleIsActive = 'Y' and b.T_OrderSampleIsActive = 'Y'
|
|
and a.T_OrderSampleT_OrderHeaderID = ?
|
|
set
|
|
a.T_OrderSampleWorklistReceive = b.T_OrderSampleWorklistReceive ,
|
|
a.T_OrderSampleWorklistReceiveDatetime = b.T_OrderSampleWorklistReceiveDatetime ,
|
|
a.T_OrderSampleWorklistReceiveUserID = b.T_OrderSampleWorklistReceiveUserID
|
|
";
|
|
$qry = $this->db->query($sql,array($headerID));
|
|
if (! $qry) {
|
|
echo "ERR : \n" ;
|
|
print_r($this->db->error());
|
|
exit;
|
|
}
|
|
echo "Serum Kuning di update";
|
|
}
|
|
}
|