<?php

class Rv_px extends MY_Controller
{
    var $db_smartone;

    public function index()
    {
        echo "RE Px API";
    }

    public function __construct()
    {
        parent::__construct();
        $this->db_smartone = $this->load->database("onedev", true);
    }

    public function multi_verification()
    {
        $prm = $this->sys_input;
        $od_id = $prm["order_id"];
        $userID = $this->sys_user["M_UserID"];
        if (!$this->isLogin) {
            echo json_encode(["status" => "ERR", "message" => "Invalid Token"]);
            exit();
        }
        $s_ids = "0 ";
        foreach ($od_id as $id) {
            $s_ids .= ",$id";
        }
        $sql = "update t_orderdetail 
         set T_OrderDetailVerification= 'Y'
         , T_OrderDetailVerUserID = ?
         , T_OrderDetailVerDate = now()
         where T_OrderDetailID in ($s_ids) 
         and T_OrderDetailResult <> ''";
        $this->db_smartone->query($sql, [$userID]);
        foreach ($od_id as $id) {
            $this->db_smartone->query("call sp_verif_parent(?)", [$id]);
            $this->clean_mysqli_connection($this->db_smartone->conn_id);
        }
        //log
        $sql = "insert into one_log.log_process(Log_ProcessCode, Log_ProcessOrderID, Log_ProcessOrderNumber,
         Log_ProcessJson,Log_ProcessUserID)
         select 'PROCESS.Result.Verification' , T_OrderDetailT_OrderHeaderID, T_OrderHeaderLabNumber,
         '',$userID
         from t_orderdetail
         join t_orderheader on T_OrderDetailT_OrderHeaderID = T_OrderHeaderID and T_OrderDetailID 
         in ( $s_ids ) and T_OrderDetailResult <> ''";

        $this->db_smartone->query($sql);

        $result = ["status" => "OK", "message" => ""];
        // update branch tx
        $sql = "select T_OrderDetailT_OrderHeaderID from t_orderdetail where T_OrderDetailID in ( $s_ids ) 
         limit 0,1";
        $qry = $this->db_smartone->query($sql);
        $orderHeaderID = 0;
        if ($qry) {
            $rows = $qry->result_array();
            if (count($rows) > 0) {
                $orderHeaderID = $rows[0]["T_OrderDetailT_OrderHeaderID"];
            }
        }
        $sql = "select 
         if(T_OrderHeaderAddOnLabNumberOrigin is null,'N','Y') isRujukan
            from 
            t_orderheaderaddon 
            where T_OrderHeaderAddOnT_OrderHeaderID = ?";
        $qry = $this->db->query($sql, [$orderHeaderID]);
        $flag_rujukan = false;
        if ($qry) {
            $rows = $qry->result_array();
            if (count($rows) > 0) {
                if ($rows[0]["isRujukan"] == "Y") {
                    $flag_rujukan = true;
                }
            }
        }
        if ($flag_rujukan) {
            $this->load->library("Txbranchstatus");
            $this->txbranchstatus->update(
                "VERIFY",
                $id,
                $this->sys_user["M_StaffName"]
            );
        }

        $this->sys_ok($result);
    }

    public function single_verification()
    {
        $prm = $this->sys_input;
        $od_id = $prm["order_id"];
        $sql = "select CriticalValueIsAdvised 
      from
      critical_value 
      where CriticalValueIsActive = 'Y' 
      and CriticalValueT_OrderDetailID = ?";
        $qry = $this->db->query($sql, [$od_id]);
        if (!$qry) {
            echo json_encode([
                "status" => "ERR",
                "message" =>
                    "Error check Criticalvalue : " +
                    $this->db->error()["message"],
            ]);
            exit();
        }
        $rows = $qry->result_array();
        if (count($rows) > 0) {
            if ($rows[0]["CriticalValueIsAdvised"] == "N") {
                echo json_encode([
                    "status" => "ERR",
                    "message" => "Criticalvalue no Advise",
                ]);
                exit();
            }
        }
        $validation = $prm["validation"];
        $userID = $this->sys_user["M_UserID"];
        if (!$this->isLogin) {
            echo json_encode(["status" => "ERR", "message" => "Invalid Token"]);
            exit();
        }
        if ($validation == "Y") {
            $sql = "update t_orderdetail 
            set T_OrderDetailVerification= 'Y'
            , T_OrderDetailVerUserID = ?
            , T_OrderDetailVerDate = now()
            where T_OrderDetailID = ?";
        } else {
            $sql = "update t_orderdetail 
            set T_OrderDetailVerification= 'N'
            , T_OrderDetailVerUserID= ?
            , T_OrderDetailVerDate= now()
            where T_OrderDetailID = ?";
        }
        $this->db_smartone->query($sql, [$userID, $od_id]);
        $this->db_smartone->query("call sp_verif_parent(?)", [$od_id]);
        $this->clean_mysqli_connection($this->db_smartone->conn_id);
        //log
        $order = $this->db_smartone
            ->select(
                'T_OrderDetailT_OrderHeaderID id, T_OrderHeaderLabNumber lab_number,
         T_OrderDetailT_TestName, T_OrderDetailID, T_OrderDetailResult',
                false
            )
            ->join(
                "t_orderheader",
                "T_OrderHeaderID = T_OrderDetailT_OrderHeaderID"
            )
            ->where("T_OrderDetailID", $od_id)
            ->get("t_orderdetail")
            ->row();
        $dblog = $this->load->database("onelog", true);
        if ($validation == "Y") {
            $dblog
                ->set("Log_ProcessCode", "PROCESS.Result.Verification")
                ->set("Log_ProcessOrderID", $order->id)
                ->set("Log_ProcessOrderNumber", $order->lab_number)
                ->set("Log_ProcessJson", json_encode($data))
                ->set("Log_ProcessUserID", $this->sys_user["M_UserID"])
                ->insert("log_process");
        } else {
            $dblog
                ->set("Log_ProcessCode", "PROCESS.Result.Unverification")
                ->set("Log_ProcessOrderID", $order->id)
                ->set("Log_ProcessOrderNumber", $order->lab_number)
                ->set("Log_ProcessJson", json_encode($data))
                ->set("Log_ProcessUserID", $this->sys_user["M_UserID"])
                ->insert("log_process");
        }
        $result = ["status" => "OK", "message" => ""];
        // update branch tx
        $sql = "select 
         if(T_OrderHeaderAddOnLabNumberOrigin is null,'N','Y') isRujukan
            from 
            t_orderheaderaddon 
            where T_OrderHeaderAddOnT_OrderHeaderID = ?";
        $qry = $this->db->query($sql, [$order->id]);
        $flag_rujukan = false;
        if ($qry) {
            $rows = $qry->result_array();
            if (count($rows) > 0) {
                if ($rows[0]["isRujukan"] == "Y") {
                    $flag_rujukan = true;
                }
            }
        }
        if ($flag_rujukan && $validation == "Y") {
            $this->load->library("Txbranchstatus");
            $this->txbranchstatus->update(
                "VERIFY",
                $od_id,
                $this->sys_user["M_StaffName"]
            );
        }

        $this->sys_ok($result);
    }
    // conndition 1 : L , 2 : N , 3 : H
    function result_is_normal($detail_id)
    {
        $sql = "select t_orderdetail.*
         from t_orderdetail 
         where 
         T_OrderDetailID = ?
";
        $qry = $this->db_smartone->query($sql, [$detail_id]);
        $flag_is_normal = false;
        $result = "";
        $patientID = 0;
        $headerID = 0;
        if ($qry) {
            $rows = $qry->result_array();
            if (count($rows) > 0) {
                $r = $rows[0];
                $result = $r["T_OrderDetailResult"];
                if ($r["T_OrderDetailNat_NormalValueID"] > 0) {
                    $minValue = $r["T_OrderDetailMinValue"];
                    $maxValue = $r["T_OrderDetailMaxValue"];
                    $minInclusive = $r["T_OrderDetailMinValueInclusive"];
                    $maxInclusive = $r["T_OrderDetailMaxValueInclusive"];
                    $value = $r["T_OrderDetailResult"];
                    if (is_numeric($value)) {
                        try {
                            $n_value = floatval($value);
                            $n_minValue = floatval($minValue);
                            $n_maxValue = floatval($maxValue);
                        } catch (Exception $e) {
                        }
                        if (
                            $d_value < $d_min_value ||
                            ($d_value <= $d_min_value &&
                                $d_min_inclusive == "N")
                        ) {
                            $flag_is_normal = false;
                        } elseif (
                            $d_value > $d_max_value ||
                            ($d_value >= $d_max_value &&
                                $d_max_inclusive == "N")
                        ) {
                            $flag_is_normal = false;
                        } else {
                            $flag_is_normal = true;
                        }
                    }
                }
            }
        }
        return $flag_is_normal;
    }

    function get_critical_value($headerID)
    {
        $sql = "select CriticalValueT_OrderDetailID,
    CriticalValueIsAdvised
    from 
    critical_value 
    where CriticalValueT_OrderHeaderID = ?
    and CriticalValueIsActive ='Y'
    and CriticalValueIsAdvised <> 'Y'";
        $qry = $this->db->query($sql, [$headerID]);
        if (!$qry) {
            return [];
        }
        $result = [];
        $rows = $qry->result_array();
        foreach ($rows as $r) {
            $result[$r["CriticalValueT_OrderDetailID"]] =
                $r["CriticalValueIsAdvised"];
        }
        return $result;
    }
    public function search()
    {
        $prm = $this->sys_input;
        $max_rst = 99;

        $id = $prm["order_id"];
        $lang = $this->lang_default_code;
        $lang_id = isset($prm["lang_id"]) ? $prm["lang_id"] : "0";
        $arr_cv = $this->get_critical_value($id);

        if ($lang_id != 0) {
            $l = $this->db_smartone
                ->where("Nat_LangID", $lang_id)
                ->get("nat_lang")
                ->row();
            $lang = $l->Nat_LangCode;
        }

        $tot_count = 0;
        $lq = "";
        $group_id = 0;
        if (isset($prm["group_id"])) {
            $group_id = $prm["group_id"];
        }
        if ($group_id != 0) {
            $sql = "select distinct T_WorklistDetailNat_TestID Nat_TestID
            from t_worklistdetailv2
            where T_WorklistDetailT_WorklistID = {$group_id}";
            $qry = $this->db_smartone->query($sql);
            $rows = $qry->result_array();
            $nat_test_ids = "0";
            foreach ($rows as $r) {
                $nat_test_ids .= ", " . $r["Nat_TestID"];
            }
            $q_group = "  ( $nat_test_ids ) ";

            $sql = "SELECT *, cOUNT(a2.T_OrderDetailID) level FROM (
            SELECT IFNULL(y.T_OrderDetailT_TestID, x.T_OrderDetailT_TestID) t_testid, 
            IFNULL(y.T_OrderDetailT_TestName, y.T_OrderDetailT_TestName) t_testname,
            y.T_OrderDetailResult result, y.T_OrderDetailResult result_old, y.T_OrderDetailNote note, y.T_OrderDetailNote note_old, y.T_OrderDetailID id,
            y.T_OrderDetailT_TestIsResult is_result, a.T_TestIsQuantitative is_quantitative,
            y.T_OrderDetailResultFlag result_flag,
            y.T_OrderDetailVerDeltaCheck delta_check,
            y.T_OrderDetailVerTrendAnalysis trend_analysis,
            y.T_OrderDetailVerification verification,
            y.T_OrderDetailVerification verification_old,
            y.T_OrderDetailValidation validation,
            y.T_OrderDetailReqStatus sample_handling_perfect,
            y.T_OrderDetailNat_NormalValueID normal_id,
            y.T_OrderDetailNormalValueNote normal_note, y.T_OrderDetailNat_UnitName unit_name,
            y.T_OrderdetailNat_MethodeID methode_id, y.T_OrderdetailNat_MethodeName methode_name,
            a.T_TestNat_TestID nattest_id, a.T_TestID tx_id, count(T_ResultInstrumentID) as result_instrument_n,
            y.T_OrderDetailVerification, T_OrderSampleReceive sample_receive,
            T_OrderSampleProcessing sample_processing, T_OrderSampleWorklistReceive sample_worklist_receive,
            IF(T_OrderDetailAddOnPreAnalytic = 'Y', T_OrderDetailAddOnPreAnalytic, PreAnalyticIsOk) pre_analytic,
            T_OrderHeaderID order_id, y.T_OrderDetailT_TestSasCode test_sas_code,
            tx.T_TestSasCode,
            T_OrderDetailAddOnResample `resample`, T_OrderDetailAddOnResampleStatus resample_status,
            T_OrderDetailAddOnRef ref,
            fn_process_group_result(x.T_OrderDetailT_TestID) ResultGroupName
            FROM t_orderdetail x

            JOIN t_test tx ON x.T_OrderDetailT_TestID = T_TestID
            JOIN t_test tcheck on  tcheck.T_TestNat_TestID in {$q_group} 
            and ( tx.T_TestID  = tcheck.T_TestID  or tx.T_TestSasCode like concat(tcheck.T_TestSasCode,'%'))
            JOIN documentation_group_detail ON DocumentationGroupDetailNat_SubGroupID = tx.T_TestNat_SubGroupID
            AND DocumentationGroupDetailIsActive = 'Y'
            JOIN documentation_group ON DocumentationGroupDetailDocumentationGroupID = DocumentationGroupID
            AND DocumentationGroupName = 'lab'

            LEFT JOIN t_orderdetail y ON x.T_OrderDetailT_TestSasCode LIKE CONCAT(y.T_OrderDetailT_TestSasCode, '%')
            AND x.T_OrderDetailT_OrderHeaderID = y.T_OrderDetailT_OrderHeaderID
            AND y.T_OrderDetailIsActive = 'Y'

            LEFT JOIN t_orderdetailaddon ON x.T_OrderDetailID = T_OrderDetailAddOnT_OrderDetailID

            JOIN t_orderheader ON y.T_OrderDetailT_OrderHeaderID = T_OrderHeaderID
            LEFT JOIN t_test a ON y.T_OrderDetailT_TestID = a.T_TestID
            AND a.T_TestIsNonLab = ''
            LEFT JOIN (SELECT T_OrderSampleT_SampleTypeID, T_OrderSampleReceive, T_OrderSampleProcessing, T_OrderSampleWorklistReceive
            FROM t_ordersample WHERE T_OrderSampleT_OrderHeaderID = ?
            AND T_OrderSampleIsactive = 'Y'
            GROUP BY T_OrderSampleT_SampleTypeID) os ON a.T_TestT_SampleTypeID = os.T_OrderSampleT_SampleTypeID
            or os.T_OrderSampleT_SampleTypeID  = fn_sampletype_from_local(a.T_TestNat_TestID)

            LEFT JOIN t_resultinstrument ON T_ResultInstrumentT_OrderDetailID = x.T_OrderDetailID
            LEFT JOIN pre_analytic ON PreAnalyticNat_TestID = a.T_TestNat_TestID AND PreAnalyticDate = date(now()) and PreAnalyticIsActive = 'Y'
            WHERE x.T_OrderDetailT_OrderHeaderID = ?
            AND x.T_OrderDetailIsActive = 'Y'
            GROUP BY y.T_OrderDetailT_TestID
            ORDER BY y.T_OrderDetailT_TestSasCode ASC) a1

            LEFT JOIN t_orderdetail a2 ON a2.T_OrderDetailT_OrderHeaderID = a1.order_id
            AND a2.T_OrderDetailIsActive = 'Y'
            AND a1.test_sas_code LIKE CONCAT(a2.T_OrderDetailT_testSasCode, '%')

            GROUP BY a1.t_testid
            order by a1.T_TestSasCode
";
            $query = $this->db_smartone->query($sql, [$id, $id]);
            $lq = $this->db_smartone->last_query();
        } else {
            $sql = "SELECT *, cOUNT(a2.T_OrderDetailID) level FROM (
            SELECT IFNULL(y.T_OrderDetailT_TestID, x.T_OrderDetailT_TestID) t_testid, 
            IFNULL(y.T_OrderDetailT_TestName, y.T_OrderDetailT_TestName) t_testname,
            y.T_OrderDetailResult result, y.T_OrderDetailResult result_old, y.T_OrderDetailNote note, y.T_OrderDetailNote note_old, y.T_OrderDetailID id,
            y.T_OrderDetailT_TestIsResult is_result, a.T_TestIsQuantitative is_quantitative,
            y.T_OrderDetailResultFlag result_flag,
            y.T_OrderDetailVerDeltaCheck delta_check,
            y.T_OrderDetailVerTrendAnalysis trend_analysis,
            y.T_OrderDetailVerification verification,
            y.T_OrderDetailVerification verification_old,
            y.T_OrderDetailValidation validation,
            y.T_OrderDetailReqStatus sample_handling_perfect,
            y.T_OrderDetailNat_NormalValueID normal_id,
            y.T_OrderDetailNormalValueNote normal_note, y.T_OrderDetailNat_UnitName unit_name,
            y.T_OrderdetailNat_MethodeID methode_id, y.T_OrderdetailNat_MethodeName methode_name,
            a.T_TestNat_TestID nattest_id, a.T_TestID tx_id, count(T_ResultInstrumentID) as result_instrument_n,
            y.T_OrderDetailVerification, T_OrderSampleReceive sample_receive,
            T_OrderSampleProcessing sample_processing, T_OrderSampleWorklistReceive sample_worklist_receive,
            IF(T_OrderDetailAddOnPreAnalytic = 'Y', T_OrderDetailAddOnPreAnalytic, PreAnalyticIsOk) pre_analytic,
            T_OrderHeaderID order_id, y.T_OrderDetailT_TestSasCode test_sas_code,
            tx.T_TestSasCode,
            T_OrderDetailAddOnResample `resample`, T_OrderDetailAddOnResampleStatus resample_status,
            T_OrderDetailAddOnRef ref,
            fn_process_group_result(x.T_OrderDetailT_TestID) ResultGroupName
            FROM t_orderdetail x

            JOIN t_test tx ON x.T_OrderDetailT_TestID = T_TestID
            JOIN documentation_group_detail ON DocumentationGroupDetailNat_SubGroupID = tx.T_TestNat_SubGroupID
            AND DocumentationGroupDetailIsActive = 'Y'
            JOIN documentation_group ON DocumentationGroupDetailDocumentationGroupID = DocumentationGroupID
            AND DocumentationGroupName = 'lab'

            LEFT JOIN t_orderdetail y ON x.T_OrderDetailT_TestSasCode LIKE CONCAT(y.T_OrderDetailT_TestSasCode, '%')
            AND x.T_OrderDetailT_OrderHeaderID = y.T_OrderDetailT_OrderHeaderID
            AND y.T_OrderDetailIsActive = 'Y'

            LEFT JOIN t_orderdetailaddon ON x.T_OrderDetailID = T_OrderDetailAddOnT_OrderDetailID

            JOIN t_orderheader ON y.T_OrderDetailT_OrderHeaderID = T_OrderHeaderID
            LEFT JOIN t_test a ON y.T_OrderDetailT_TestID = a.T_TestID
            AND a.T_TestIsNonLab = ''
            LEFT JOIN (SELECT T_OrderSampleT_SampleTypeID, T_OrderSampleReceive, T_OrderSampleProcessing, T_OrderSampleWorklistReceive
            FROM t_ordersample WHERE T_OrderSampleT_OrderHeaderID = ?
            AND T_OrderSampleIsactive = 'Y'
            GROUP BY T_OrderSampleT_SampleTypeID) os ON a.T_TestT_SampleTypeID = os.T_OrderSampleT_SampleTypeID
            or os.T_OrderSampleT_SampleTypeID  = fn_sampletype_from_local(a.T_TestNat_TestID)

            LEFT JOIN t_resultinstrument ON T_ResultInstrumentT_OrderDetailID = x.T_OrderDetailID
            LEFT JOIN pre_analytic ON PreAnalyticNat_TestID = a.T_TestNat_TestID AND PreAnalyticDate = date(now()) and PreAnalyticIsActive = 'Y'
            WHERE x.T_OrderDetailT_OrderHeaderID = ?
            AND x.T_OrderDetailIsActive = 'Y'
            GROUP BY y.T_OrderDetailT_TestID
            ORDER BY y.T_OrderDetailT_TestSasCode ASC) a1

            LEFT JOIN t_orderdetail a2 ON a2.T_OrderDetailT_OrderHeaderID = a1.order_id
            AND a2.T_OrderDetailIsActive = 'Y'
            AND a1.test_sas_code LIKE CONCAT(a2.T_OrderDetailT_testSasCode, '%')

            GROUP BY a1.t_testid
            order by a1.T_TestSasCode
";
            $query = $this->db_smartone->query($sql, [$id, $id]);
            $lq = $this->db_smartone->last_query();
        }

        if ($query) {
            $rst = [];
            $rows = $query->result_array();
            foreach ($rows as $k => $v) {
                if ($v["is_result"] == "") {
                    $v["is_result"] = "N";
                    if ($v["unit_name"] != "") {
                        $v["is_result"] = "Y";
                    }
                }
                if ($v["is_result"] == "Y" && $v["is_quantitative"] == "N") {
                    $v["template"] = [];
                    $x = $this->db_smartone->query(
                        "CALL sp_master_resulttemplate_get('{$v["t_testid"]}')"
                    );
                    $this->clean_mysqli_connection($this->db_smartone->conn_id);
                    if ($x) {
                        $v["template"] = $x->result_array();
                    }
                }

                $v["requirement"] = ["status" => "Y", "note" => ""];
                if ($v["is_result"] == "Y" && $v["is_quantitative"] == "Y") {
                    try {
                        $qry = $this->db_smartone->query(
                            "SELECT fn_process_re_trendanalysis_v2('{$v["id"]}') x"
                        );
                        if ($qry) {
                            $tmp = $qry->row();
                            $v["trend_analysis"] = json_decode($tmp->x);
                        }
                    } catch (Exception $e) {
                    }
                    try {
                        //conversi ke php
                        $qry = $this->db_smartone->query(
                            "SELECT fn_process_re_deltacheck('{$v["id"]}') x"
                        );
                        if ($qry) {
                            $tmp = $qry->row();
                            $v["delta_check"] = json_decode($tmp->x, true);
                            $v_id = $v["id"];
                            $last_id = $v["delta_check"]["lastID"];
                            if ($this->result_is_normal($v["id"])) {
                                if ($v["delta_check"]["lastID"] > 0) {
                                    if (
                                        $this->result_is_normal(
                                            $v["delta_check"]["lastID"]
                                        )
                                    ) {
                                        $isNormalNormal = true;
                                    }
                                }
                            }
                            $v["delta_check"][
                                "is_normal_normal"
                            ] = $isNormalNormal;
                            if ($isNormalNormal) {
                                $currentResult =
                                    $v["delta_check"]["currentResult"];
                                $lastResult = $v["delta_check"]["lastResult"];
                                $v["delta_check"]["status"] == "Y";
                                $v["delta_check"][
                                    "note"
                                ] = "Hasil {$currentResult} [Normal] , hasil sebelumnya {$lastResult} [Normal]";
                            }
                        }
                    } catch (Exception $e) {
                    }
                    //requirement
                    $orderHeaderID = $v["T_OrderDetailT_OrderHeaderID"];
                    $sql = "select d.*, Nat_PositionName 
                  from t_orderreq  d
                  join nat_position on T_OrderReqNat_PositionID = Nat_PositionID 
                  where T_OrderReqT_OrderHeaderID = ?";
                    $qry = $this->db_smartone->query($sql, [$orderHeaderID]);
                    if ($qry) {
                        $r_rows = $qry->result_array();
                        if (count($r_rows) > 0) {
                            $r_notes = "";
                            foreach ($r_rows as $r_r) {
                                $a_test = json_decode(
                                    $r_r["T_OrderReqT_TestID"],
                                    true
                                );
                                if (in_array($v["t_testid"], $a_test)) {
                                    $a_req = json_decode(
                                        $r_r["T_OrderReqs"],
                                        true
                                    );
                                    $s_req = implode(",", $a_req);
                                    if ($s_req == "") {
                                        $s_req = "0";
                                    }
                                    $sql = "select group_concat(Nat_RequirementName) reqs 
                              from nat_requirement where Nat_RequirementID in ( 0, $s_req )
                              and Nat_RequirementIsActive = 'Y'";
                                    $qry = $this->db_smartone->query($sql);
                                    if ($qry) {
                                        $r2_rows = $qry->result_array();
                                        foreach ($r2_rows as $r2_r) {
                                            if ($r_notes != "") {
                                                $r_notes .= "<br/>";
                                            }
                                            $r_notes .=
                                                $r_r["Nat_PositionName"] .
                                                " : " .
                                                $r2_r["reqs"];
                                        }
                                    } else {
                                        print_r($this->db_smartone->error());
                                    }
                                }
                            }
                            if ($r_notes != "") {
                                $v["requirement"] = [
                                    "status" => "X",
                                    "note" => $r_notes,
                                ];
                            }
                        }
                    }
                }
                // IF Rujukan, by pas Pre Analytik
                if ($v["ref"] == "Y") {
                    $v["pre_analytic"] = "Y";
                }

                $x_id = $v["id"];
                $v["CriticalValue"] = "N";
                if (isset($arr_cv[$x_id])) {
                    $v["CriticalValue"] = "Y";
                }
                $rst[] = $v;
            }

            $result = [
                "total" => $tot_count,
                "records" => $rst,
                "total_display" => sizeof($rows),
                "cv" => $arr_cv,
                "q" => $lq,
            ];
            $this->sys_ok($result);
        } else {
            $this->sys_error_db("RE Px rows", $this->db_smartone);
            exit();
        }
    }

    public function search_old_2()
    {
        $prm = $this->sys_input;
        $max_rst = 99;

        $id = $prm["order_id"];
        $lang = $this->lang_default_code;
        $lang_id = isset($prm["lang_id"]) ? $prm["lang_id"] : "0";

        if ($lang_id != 0) {
            $l = $this->db_smartone
                ->where("Nat_LangID", $lang_id)
                ->get("nat_lang")
                ->row();
            $lang = $l->Nat_LangCode;
        }

        $tot_count = 0;
        $group_id = 0;
        if (isset($prm["group_id"])) {
            $group_id = $prm["group_id"];
        }

        //   if ($lang == $this->lang_default_code)
        //   {
        if ($group_id != 0) {
            $sql = "SELECT IFNULL(z.T_TesTID, x.t_testid) t_testid, 
            IFNULL(z.T_TestName, x.t_testname) t_testname, 
            IFNULL(z.T_TestNat_TesTID, x.nattest_id) nattest_id,
            IFNULL(y.T_OrderDetailResult, x.result) result,
            IFNULL(y.T_OrderDetailResult, x.result_old) result_old,
            IFNULL(y.T_OrderDetailNote, x.note) note,
            IFNULL(y.T_OrderDetailNote, x.note_old) note_old,
            IFNULL(y.T_OrderDetailID, x.id) id,
            IFNULL(y.T_OrderDetailT_TestIsResult, x.is_result) is_result,
            IFNULL(z.T_TestIsQuantitative, x.is_quantitative) is_quantitative,
            IFNULL(y.T_OrderDetailVerDeltaCheck, x.delta_check) delta_check,
            IFNULL(y.T_OrderDetailVerTrendAnalysis, x.trend_analysis) trend_analysis,
            IFNULL(y.T_OrderDetailVerification, x.verification) verification,
            IFNULL(y.T_OrderDetailVerification, x.verification_old) verification_old,
            IFNULL(y.T_OrderDetailReqStatus, x.sample_handling_perfect) sample_handling_perfect,
            IFNULL(y.T_OrderDetailNat_NormalValueID, x.normal_id) normal_id,
            IFNULL(y.T_OrderDetailNormalValueNote, x.normal_note) normal_note,
            IFNULL(y.T_OrderDetailNat_UnitName, x.unit_name) unit_name,
            IFNULL(y.T_OrderdetailNat_MethodeID, x.methode_id) methode_id,
            IFNULL(y.T_OrderdetailNat_MethodeName, x.methode_name) methode_name,
            IFNULL(y.T_OrderDetailVerification, x.T_OrderDetailVerification) T_OrderDetailVerification,
            IFNULL(y.T_OrderDetailT_OrderHeaderID, x.T_OrderDetailT_OrderHeaderID) T_OrderDetailT_OrderHeaderID,
            IFNULL(y.T_OrderDetailT_TestSasCode, x.T_OrderDetailT_TestSasCode) T_OrderDetailT_TestSasCode,
            IFNULL(os1.T_OrderSampleReceive, x.T_OrderSampleReceive) sample_receive,
            IFNULL(os1.T_OrderSampleProcessing, x.T_OrderSampleProcessing) sample_processing,
            CAST( level + (LENGTH(y.T_OrderDetailT_TestSasCode) - LENGTH(x.T_OrderDetailT_TestSasCode))/2 as SIGNED) level
            FROM (
               SELECT IFNULL(a.t_testid, b.t_testid) t_testid, IFNULL(a.t_testname, b.t_testname) t_testname,
               T_OrderDetailResult result, T_OrderDetailResult result_old, T_OrderDetailNote note, T_OrderDetailNote note_old, T_OrderDetailID id,
               T_OrderDetailT_TestIsResult is_result, a.T_TestIsQuantitative is_quantitative,
               COUNT(b.T_TestID) level, 
               T_OrderDetailVerDeltaCheck delta_check,
               T_OrderDetailVerTrendAnalysis trend_analysis,
               T_OrderDetailVerification verification,
               T_OrderDetailVerification verification_old,
               T_OrderDetailReqStatus sample_handling_perfect,
               T_OrderDetailNat_NormalValueID normal_id,
               T_OrderDetailNormalValueNote normal_note, T_OrderDetailNat_UnitName unit_name,
               T_OrderdetailNat_MethodeID methode_id, T_OrderdetailNat_MethodeName methode_name,
               a.T_TestNat_TestID nattest_id, count(T_ResultInstrumentID) as result_instrument_n,
               T_OrderDetailVerification, T_OrderDetailT_OrderHeaderID, IFNULL(T_OrderDetailT_TestSasCode, b.T_TestSasCode) T_OrderDetailT_TestSasCode,
               T_OrderSampleReceive, T_OrderSampleProcessing
               FROM t_orderdetail
               JOIN t_test a ON T_OrderDetailT_TestID = a.T_TestID

               LEFT JOIN (SELECT T_OrderSampleT_SampleTypeID, T_OrderSampleReceive, T_OrderSampleProcessing
               FROM t_ordersample WHERE T_OrderSampleT_OrderHeaderID = ?
               AND T_OrderSampleIsactive = 'Y'
               GROUP BY T_OrderSampleT_SampleTypeID) os ON a.T_TestT_SampleTypeID = os.T_OrderSampleT_SampleTypeID

               LEFT JOIN t_test b ON a.T_TestSasCode LIKE CONCAT(b.T_TestSasCode, '%')

               LEFT JOIN t_resultinstrument ON T_ResultInstrumentT_OrderDetailID = T_OrderDetailID
               WHERE T_OrderDetailT_OrderHeaderID = ?
               AND T_OrderDetailIsActive = 'Y'
               AND T_OrderDetailT_TestID IN 
               ( SELECT T_WorklistDetailT_TestID 
               FROM t_worklistdetail
               WHERE T_WorklistDetailIsactive = 'Y' ANd T_WorklistDetailT_WorklistID = ?
            )
            GROUP BY a.T_TestID
            ORDER BY T_OrderDetailT_TestSasCode ASC) x

            LEFT JOIN t_orderdetail y ON x.T_OrderDetailT_OrderHeaderID = y.T_OrderDetailT_OrderHeaderID
            AND y.T_OrderDetailIsActive = 'Y'
            AND y.T_OrderDetailT_TestSasCode LIKE CONCAT(x.T_OrderDetailT_TestSasCode, '%')
            LEFT JOIN t_test z ON y.T_OrderDetailT_TestID = z.T_TestID

            LEFT JOIN (SELECT T_OrderSampleT_SampleTypeID, T_OrderSampleReceive, T_OrderSampleProcessing
            FROM t_ordersample WHERE T_OrderSampleT_OrderHeaderID = ?
            AND T_OrderSampleIsactive = 'Y'
            GROUP BY T_OrderSampleT_SampleTypeID) os1 ON z.T_TestT_SampleTypeID = os1.T_OrderSampleT_SampleTypeID";

            $query = $this->db_smartone->query($sql, [
                $id,
                $id,
                $group_id,
                $id,
            ]);
            $lq = $this->db_smartone->last_query();
        } else {
            $sql = "SELECT a.t_testid, a.t_testname,
            T_OrderDetailResult result, T_OrderDetailNote note, T_OrderDetailID id,
            T_OrderDetailT_TestIsResult is_result, COUNT(b.T_TestID) level,
            T_OrderDetailVerDeltaCheck delta_check,
            T_OrderDetailVerTrendAnalysis trend_analysis,
            T_OrderDetailVerification verification,
            T_OrderDetailVerification verification_old,
            T_OrderDetailReqStatus sample_handling_perfect, T_OrderDetailNat_NormalValueID normal_id,
            T_OrderDetailNormalValueNote normal_note, T_OrderDetailNat_UnitName unit_name,
            T_OrderdetailNat_MethodeID methode_id, T_OrderdetailNat_MethodeName methode_name,
            a.T_TestNat_TestID nattest_id, count(T_ResultInstrumentID) as result_instrument_n,
            T_OrderDetailVerification, T_OrderSampleReceive sample_receive,
            T_OrderSampleProcessing sample_processing

            FROM t_orderdetail
            JOIN t_test a ON T_OrderDetailT_TestID = a.T_TestID
            AND a.T_TestIsNonLab = ''
            JOIN (SELECT T_OrderSampleT_SampleTypeID, T_OrderSampleReceive, T_OrderSampleProcessing
            FROM t_ordersample WHERE T_OrderSampleT_OrderHeaderID = ?
            AND T_OrderSampleIsactive = 'Y'
            GROUP BY T_OrderSampleT_SampleTypeID) os ON a.T_TestT_SampleTypeID = os.T_OrderSampleT_SampleTypeID
            LEFT JOIN t_test b ON a.T_TestSasCode LIKE CONCAT(b.T_TestSasCode, '%')
            LEFT JOIN t_resultinstrument ON T_ResultInstrumentT_OrderDetailID = T_OrderDetailID
            WHERE T_OrderDetailT_OrderHeaderID = ?
            AND T_OrderDetailIsActive = 'Y'
            GROUP BY a.T_TestID
            ORDER BY T_OrderDetailT_TestSasCode ASC
";
            $query = $this->db_smartone->query($sql, [$id, $id]);
        }

        if ($query) {
            $rst = [];
            $rows = $query->result_array();

            foreach ($rows as $k => $v) {
                if ($v["is_result"] == "Y" && $v["is_quantitative"] == "N") {
                    $v["template"] = [];
                    $x = $this->db_smartone->query(
                        "CALL sp_master_resulttemplate_get('{$v["t_testid"]}')"
                    );
                    $this->clean_mysqli_connection($this->db_smartone->conn_id);
                    if ($x) {
                        $v["template"] = $x->result_array();
                    }
                }

                if ($v["delta_check"] == "X") {
                    $tmp = $this->db_smartone
                        ->query(
                            "SELECT fn_process_re_deltacheck('{$v["id"]}') x"
                        )
                        ->row();
                    $v["delta_check"] = $tmp->x;
                    $isNormalNormal = false;
                    $v_id = $v["id"];
                    echo " id : $v_id : " . $this->flag_is_normal($v_id) . "\n";
                    $last_id = $v["delta_check"]["lastID"];
                    echo " id : $last_id : " .
                        $this->flag_is_normal($last_id) .
                        "\n";
                    if ($this->flag_is_normal($v["id"])) {
                        if ($v["delta_check"]["lastID"] > 0) {
                            if (
                                $this->flag_is_normal(
                                    $v["delta_check"]["lastID"]
                                )
                            ) {
                                $isNormalNormal = true;
                            }
                        }
                    }
                    echo "HEREHERE --- ";
                    exit();
                    $v["delta_check"]["is_normal_normal"] = true;
                    if ($isNormalNormal) {
                        $currentResult = $v["delta_check"]["currentResult"];
                        $lastResult = $v["delta_check"]["lastResult"];
                        $v["delta_check"]["status"] == "Y";
                        $v["delta_check"][
                            "note"
                        ] = "Hasil {$currentResult} [Normal] , hasil sebelumnya {$lastResult} [Normal]";
                    }
                }

                $tmp = $this->db_smartone
                    ->query(
                        "SELECT fn_process_re_trendanalysis('{$v["id"]}') x"
                    )
                    ->row();
                $v["trend_analysis"] = $tmp->x;

                // Sample Handling & Verification Perfect
                if ($v["sample_handling_perfect"] == "X") {
                    $y = $this->db_smartone
                        ->query(
                            "SELECT fn_process_sample_handling_perfect('{$id}', '{$v["t_testid"]}') c"
                        )
                        ->row();
                    $v["sample_handling_perfect"] = $y->c;
                }

                // Override
                if ($y->c == "N") {
                    $v["delta_check"] = "N";
                    $v["trend_analysis"] = "N";
                }
                $rst[] = $v;
            }

            $result = [
                "total" => $tot_count,
                "records" => $rst,
                "total_display" => sizeof($rows),
                "q" => $this->db_smartone->last_query(),
            ];
            $this->sys_ok($result);
        } else {
            $this->sys_error_db("RE Px rows", $this->db_smartone);
            exit();
        }
    }

    public function confirm()
    {
        $prm = $this->sys_input;
        $data = json_decode($prm["id"]);

        if (sizeof($data) < 1) {
            $this->sys_error_db(
                "RE Verification Confirmation",
                $this->db_smartone
            );
            exit();
        } else {
            $ids = [];
            foreach ($data as $k => $v) {
                $this->db_smartone
                    ->set("T_OrderDetailVerDeltaCheck", $v->delta)
                    ->set("T_OrderDetailVerTrendAnalysis", $v->trend)
                    ->set("T_OrderDetailVerification", $v->verification)
                    ->set("T_OrderDetailVerDate", date("Y-m-d H:i:s"))
                    ->set("T_OrderDetailVerUserID", $this->sys_user->M_UserID)
                    ->where("T_OrderDetailID", $v->id)
                    ->update("t_orderdetail");
                $ids[] = $v->id;
            }

            $this->sys_ok($ids);
        }
    }

    public function search_group()
    {
        $prm = $this->sys_input;
        $max_rst = 100;

        // QUERY TOTAL
        $sql = "select count(*) total
         from t_worklist
         where T_WorklistIsActive = 'Y'
         order by T_WorklistName ASC";
        $query = $this->db_smartone->query($sql);

        if ($query) {
            $tot_count = $query->result_array()[0]["total"];
        } else {
            $this->sys_error_db("worklist count", $this->db_smartone);
            exit();
        }

        $sql = "select T_WorklistID group_id, T_WorklistName group_name
         from t_worklist
         where T_WorklistIsActive = 'Y'
         order by T_WorklistName ASC";
        //           limit 0, {$max_rst}";
        $query = $this->db_smartone->query($sql);

        if ($query) {
            $rows = $query->result_array();
            foreach ($rows as $k => $v) {
                $rows[$k]["data"] = json_decode($v["data"]);
            }
            $result = [
                "total" => $tot_count,
                "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();
        }
    }
}