<?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 send_to_adm() {
      $prm = $this->sys_input;
       if ( ! $this->isLogin ) {
         echo json_encode(
            array("status"=>"ERR", "message"=> "Invalid Token")
         );
         exit;
       }
      $userID = $this->sys_user["M_UserID"];

      $order_id = $prm["order_id"];
      $sql ="update t_orderheaderaddon set T_OrderHeaderAddOnReadyPrint = 'Y' ,
         T_OrderHeaderAddOnReadyPrintDate = now()
         where T_OrderHeaderAddOnT_OrderHeaderID = ?";
      $this->db_smartone->query($sql,array($order_id));
      $sql ="select * from t_orderdetail where T_OrderDetailValidation = 'Y'
         and T_OrderDetailT_OrderHeaderID = ?";
      $qry = $this->db_smartone->query($sql,array($order_id));
      $rows = [];
      if ($qry) {
         $rows =  $qry->result_array();
      }
      $j_data = json_encode($rows);
      //insert into log 
      $sql = "insert into one_log.log_printlab(Log_PrintLabT_OrderHeaderID,
         Log_PrintLabCode,
         Log_PrintLabDatetime, Log_PrintLabJson, Log_PrintLabUserID) 
         values(?,'SEND.TO.ADM',now(),?,$userID)";
      $this->db_smartone->query($sql,array($order_id,$j_data));
      echo $this->sys_ok( array("status" => "OK"));
   }   
   public function search()
   {
      $prm = $this->sys_input;
      $max_rst = 10;

      $sdate = $prm["start_date"] . '%';
      $search = '%' . $prm["search"] . '%';
      $page = $prm['page'];

      if ($page == null)
         $page = 1;

      $offset = ($page - 1) * $max_rst;

        // OVERRIDE
        $max_rst = 9999;
        $offset = 0;
         $q_company = "";
        $company_id = 0;
        if (isset($prm["company_id"])) $company_id = $prm["company_id"];
        if ($company_id > 0 ) $q_company = " and T_OrderHeaderM_CompanyID = $company_id ";
        
      // QUERY TOTAL
      $sql = "SELECT count(DISTINCT T_OrderHeaderID) total
                from t_orderheader
                JOIN t_orderheaderaddon ON T_OrderHeaderAddOnT_OrderHeaderID = T_OrderHeaderID
                JOIN t_orderpromise ON T_OrderPromiseT_OrderHeaderID = T_OrderHeadeRID
                JOIN t_orderdetail ON T_OrderHeaderID = T_OrderDetailT_OrderHeaderID 
                    AND T_OrderDetailIsActive= 'Y' AND T_OrderDetailVerification = 'Y'
                JOIN t_test ON T_OrderDetailT_TestID = T_TestID
                JOIN documentation_group_detail ON DocumentationGroupDetailNat_SubGroupID = T_TestNat_SubGroupID
                    AND DocumentationGroupDetailIsActive = 'Y'
                JOIN documentation_group ON DocumentationGroupDetailDocumentationGroupID = DocumentationGroupID
                    AND DocumentationGroupName = 'lab'
                join m_patient on T_OrderHeaderM_PatientID = M_PatientID
                left join m_doctor da on T_OrderHeaderPJM_DoctorID = da.M_DoctorID
                join m_doctor db on T_OrderHeaderSenderM_DoctorID = db.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_OrderHeaderDate LIKE ? OR T_OrderPromiseDateTime LIKE ?)
                and 
                  ( M_PatientName LIKE ?
                     or T_OrderHeaderLabNumber like ?
                  )
                order by T_OrderHeaderLabNumber DESC";
      /*
      $query = $this->db_smartone->query($sql, [$sdate, $sdate, $search, $search ]);

      if ($query) { 
         $tot_count = $query->result_array()[0]["total"]; 
      } 
      else {
         $this->sys_error_db("re count", $this->db_smartone);
         exit;
      }
       */

      $sql = "SELECT *,
                CONCAT('[', GROUP_CONCAT(DISTINCT CONCAT('\"', T_OrderPromiseDateTime, '\"') SEPARATOR ','), ']') order_promise FROM (
                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,
                db.M_DoctorID doctor_sender_id, fn_global_doctor_name(db.M_DoctorID) doctor_sender_name,
                M_MouID, M_MouName, M_CompanyID, M_CompanyName,
                T_OrderHeaderFoNote, T_OrderHeaderSamplingNote, T_OrderHeaderResultNote, 
                la.Nat_LangID M_LangID, la.Nat_LangCode M_LangCode, la.Nat_LangName M_LangName, T_OrderHeaderLangIsSI,
                lb.Nat_LangID SecondM_LangID, lb.Nat_LangCode SecondM_LangCode, lb.Nat_LangName SecondM_LangName, 
                T_OrderHeaderAddOnSecondLangIsSI,
                T_OrderHeaderIsCito, fn_global_delivery_items(T_OrderHeaderID) as deliveries,
                T_OrderPromiseDateTime, fn_process_history(T_OrderHeaderID) is_history,
                T_OrderHeaderLabNumberExt,
               T_OrderHeaderAddOnVerificationDone,
               T_OrderHeaderAddOnValidationDone,
               T_OrderHeaderAddOnReadyPrint
                from t_orderheader
                JOIN t_orderheaderaddon ON T_OrderHeaderAddOnT_OrderHeaderID = T_OrderHeaderID
                  {$q_company}
                left JOIN t_orderpromise ON T_OrderPromiseT_OrderHeaderID = T_OrderHeadeRID
                JOIN t_orderdetail ON T_OrderHeaderID = T_OrderDetailT_OrderHeaderID 
                    AND T_OrderDetailIsActive= 'Y' 
                -- AND T_OrderDetailVerification = 'Y'
                JOIN t_test ON T_OrderDetailT_TestID = T_TestID
                JOIN documentation_group_detail ON DocumentationGroupDetailNat_SubGroupID = T_TestNat_SubGroupID
                    AND DocumentationGroupDetailIsActive = 'Y'
                JOIN documentation_group ON DocumentationGroupDetailDocumentationGroupID = DocumentationGroupID
                    AND DocumentationGroupName = 'lab'
                join m_patient on T_OrderHeaderM_PatientID = M_PatientID
                left join m_doctor da on T_OrderHeaderPJM_DoctorID = da.M_DoctorID
                join m_doctor db on T_OrderHeaderSenderM_DoctorID = db.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 nat_lang la ON T_OrderHeaderM_LangID = la.Nat_LangID
                LEFT JOIN nat_lang lb ON T_OrderHeaderAddOnSecondM_LangID = lb.Nat_LangID
                  where T_OrderHeaderIsActive = 'Y'
                and (T_OrderHeaderDate LIKE ? OR T_OrderPromiseDateTime LIKE ?)
                and 
                  ( M_PatientName LIKE ?
                    or T_OrderHeaderLabNumber like ?
                    or T_OrderHeaderLabNumberExt like ?
                  )
                AND T_OrderHeaderAddOnFOVerification = 'Y'
                order by FIELD(T_OrderHeaderIsCito, 'Y', 'N') ASC, T_OrderPromiseDateTime 
               ) x
                GROUP BY T_OrderHeaderID
                order by FIELD(T_OrderHeaderIsCito, 'Y', 'N') ASC, T_OrderPromiseDateTime
                limit {$offset}, {$max_rst}";
      $query = $this->db_smartone->query($sql, [$sdate, $sdate, $search, $search,$search ]);

      if ($query) { 
         $rows = $query->result_array();
         foreach ($rows as $k => $v) {
            $rows[$k]['data'] = json_decode($v['data']);

            $rows[$k]['delivery'] = [];
            $r = $this->db_smartone->query("CALL sp_fo_payment_get_delivery('{$v['T_OrderHeaderID']}')");
            $this->clean_mysqli_connection($this->db_smartone->conn_id);
            if ($r) {
               $d = $r->row();
               $rows[$k]['delivery'] = json_decode($d->delivery);
            }

            $rows[$k]['deliveries'] = JSON_DECODE($v['deliveries']);
            $rows[$k]['order_promise'] = JSON_DECODE($v['order_promise']);
            foreach($rows[$k]['order_promise'] as $l => $w)
                $rows[$k]['order_promise'][$l] = date('d-m-Y H:i', strtotime($w));
         }
            
         $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;
      }
   }

    public function info_req()
    {
        $prm = $this->sys_input;

        $sql = "CALL sp_process_result_reqs(?)";
        $query = $this->db_smartone->query($sql, [$prm['order_id']]);
        if ($query)
        {
            $row = $query->row();
            $this->sys_ok(json_decode($row->data));
            exit;
        }

        $this->sys_error_db("RESULT REQ", $this->db_smartone);
    }
}