<?php
class Rujukan extends CI_Controller
{
   function __construct() {
      parent::__construct();
      $this->db = $this->load->database("onedev", true);
   }
   function index() {
      echo "Fix Rujukan";
   }
   function upload() {
      $sql = "select incomingRefChildNewT_OrderHeaderID,
         T_OrderDetailValUserID,
         T_OrderDetailID,
         M_StaffName, T_OrderDetailT_TestName,
         T_OrderHeaderAddOnLabNumberOrigin
         from incoming_ref_child
         join t_orderdetail on T_OrderDetailT_OrderHeaderID = incomingRefChildNewT_OrderHeaderID
            and T_OrderDetailT_TestID = incomingRefChildT_TestID
         join t_orderheaderaddon on T_OrderHeaderAddOnT_OrderHeaderID = T_OrderDetailT_OrderHeaderID
         join m_user on T_OrderDetailValUserID = M_UserID 
         join m_staff on M_StaffID = M_UserM_StaffID
         where date(incomingRefChildCreated) = date(now())
         and T_OrderHeaderAddOnLabNumberOrigin <> '00202630DC'
         order by incomingRefChildNewT_OrderHeaderID";
      $qry = $this->db->query($sql);
      $this->load->library("Txbranchstatus");
      if ($qry) {
         $rows = $qry->result_array();
         $prev_orderid = 0;
         $rows_id = array();
         foreach($rows as $r) {
            $orderid = $r["incomingRefChildNewT_OrderHeaderID"];
            $detail_id = $r["T_OrderDetailID"];
            $this->load->library("Txbranchstatus");
            $userID = $r["T_OrderDetailValUserID"];
            $noreg = $r["T_OrderHeaderAddOnLabNumberOrigin"];
            $userName = $r["M_StaffName"];
            $testName = $r["T_OrderDetailT_TestName"];
            $this->txbranchstatus->update("VALIDATION",$detail_id,$userName);
            echo "Process $noreg : $testName => $orderid : $detail_id : $userName  \n";
         }
      } else {
         print_r($this->db->error());
      }
   }
   function child_test() {
      $sql = "update incoming_ref_child, incoming_ref_detail
               set incomingRefChildNewT_OrderHeaderID = incomingRefDetailNewT_OrderHeaderID
               where incomingRefChildIncomingRefID = incomingRefDetailIncomingRefID
                  and incomingRefChildT_OrderHeaderID = incomingRefDetailT_OrderHeaderID
                  and incomingRefChildNewT_OrderHeaderID is null
                  and date(incomingRefDetailCreated) = date(now())
                  ";
      $qry = $this->db->query($sql);
      if ($qry) {
         $date = date("Y-m-d H:i:s ");
         echo "$date update rows : " . $this->db->affected_rows() . "\n";
      } else {
         $msg = print_r($this->db->error(),true);
         echo "$date err : $msg \n";
      }
   }
   function barcode_label() {
      $sql = "update incoming_ref_detail, t_test, t_barcodelab
         set T_BarcodeLabBarcodeOrigin = incomingRefDetailT_BarcodeLabBarcode
         where
         incomingRefDetailT_TestID = T_TestID 
         and incomingRefDetailNewT_OrderHeaderID = T_BarcodeLabT_OrderHeaderID
         and T_BarcodeLabT_SampleTypeID = json_extract(fn_worklist_get_info(incomingRefDetailNewT_OrderHeaderID,T_TestID), '$.sampleTypeID') 
         and date(incomingRefDetailCreated) = date(now())
         and T_TestT_SampleTypeID = 0
         and T_BarcodeLabBarcodeOrigin is null";
      $qry = $this->db->query($sql);
      if ($qry) {
         $date = date("Y-m-d H:i:s ");
         echo "$date update rows : " . $this->db->affected_rows() . "\n";
      } else {
         $msg = print_r($this->db->error(),true);
         echo "$date err : $msg \n";
      }
   }
}