<?php
class R_api_tat extends MY_Controller
{
    var $db;
    var $load;
    public function __construct()
    {
        parent::__construct();
    }

    public function index()
    {
        // $cek = $this->db->query("select database() as current_db")->result();
        // print_r($cek);
        echo "API UPLOAD TAT";
    }

    public function upload()
    {
        try {
            $prm = $this->sys_input;

            $this->db->trans_begin();
            $data = $prm;

            $branchid =  $data["M_BranchID"];
            $branchcode = $data["M_BranchCode"];

            $ss_tat_v2 = $data["ss_tat_v2"];
            foreach ($ss_tat_v2 as $key => $tatv2) {
                $sql_tat_v2_del = "delete from one_dash.ss_tat_v2 where SsTatV2M_BranchID = ? and  SsTatV2ID = ? ";
                $qry = $this->db->query($sql_tat_v2_del, array(
                    $branchid,
                    $tatv2["SsTatV2ID"]
                ));
                if (!$qry) {
                    $error = array(
                        "message" => $this->db->error()["message"],
                        "qry" => $this->db->last_query()
                    );
                    $this->sys_error_db($error);
                    exit;
                }

                $sql_tat_v2 = "INSERT INTO one_dash.ss_tat_v2(
                    SsTatV2ID,
                    SsTatV2Date,
                    SsTatV2M_BranchID,
                    SsTatV2M_BranchCode,
                    SsTatV2Month,
                    SsTatV2FoTargetEntry,
                    SsTatV2FoVerif,
                    SsTatV2FoTotalData,
                    SsTatV2FoPctFo,
                    SsTatV2FoPctVerif,
                    SsTatV2SamplingData,
                    SsTatV2SamplingHasil,
                    SsTatV2SamplingPct,
                    SsTatV2VerifData,
                    SsTatV2VerifHasil,
                    SsTatV2VerifPct,
                    SsTatV2PengolahanData,
                    SsTatV2PengolahanHasil,
                    SsTatV2PengolahanPct,
                    SsTatV2ValidasiData,
                    SsTatV2ValidasiHasil,
                    SsTatV2ValidasiPct,
                    SsTatV2AdmLabData,
                    SsTatV2AdmLabHasil,
                    SsTatV2AdmLabPct,
                    SsTatV2FullLabData,
                    SsTatV2FullLabHasil,
                    SsTatV2FullLabPct
                    ) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
                $qry_tat_v2 = $this->db->query($sql_tat_v2, array(
                    $tatv2["SsTatV2ID"],
                    $tatv2["SsTatV2Date"],
                    $branchid,
                    $branchcode,
                    $tatv2["SsTatV2Month"],
                    $tatv2["SsTatV2FoTargetEntry"],
                    $tatv2["SsTatV2FoVerif"],
                    $tatv2["SsTatV2FoTotalData"],
                    $tatv2["SsTatV2FoPctFo"],
                    $tatv2["SsTatV2FoPctVerif"],
                    $tatv2["SsTatV2SamplingData"],
                    $tatv2["SsTatV2SamplingHasil"],
                    $tatv2["SsTatV2SamplingPct"],
                    $tatv2["SsTatV2VerifData"],
                    $tatv2["SsTatV2VerifHasil"],
                    $tatv2["SsTatV2VerifPct"],
                    $tatv2["SsTatV2PengolahanData"],
                    $tatv2["SsTatV2PengolahanHasil"],
                    $tatv2["SsTatV2PengolahanPct"],
                    $tatv2["SsTatV2ValidasiData"],
                    $tatv2["SsTatV2ValidasiHasil"],
                    $tatv2["SsTatV2ValidasiPct"],
                    $tatv2["SsTatV2AdmLabData"],
                    $tatv2["SsTatV2AdmLabHasil"],
                    $tatv2["SsTatV2AdmLabPct"],
                    $tatv2["SsTatV2FullLabData"],
                    $tatv2["SsTatV2FullLabHasil"],
                    $tatv2["SsTatV2FullLabPct"]
                ));
                if (!$qry_tat_v2) {
                    $error = array(
                        "message" => $this->db->error()["message"],
                        "qry" => $this->db->last_query()
                    );
                    $this->sys_error_db($error);
                    exit;
                }
            }

            $ss_tat_v2b = $data["ss_tat_v2b"];
            foreach ($ss_tat_v2b as $key => $tatv2b) {
                $sql_tat_v2b_del = "delete from one_dash.ss_tat_v2b where SsTatV2bM_BranchID = ? and  SsTatV2bID = ? ";
                $qry = $this->db->query($sql_tat_v2b_del, array(
                    $branchid,
                    $tatv2b["SsTatV2bID"]
                ));
                if (!$qry) {
                    $error = array(
                        "message" => $this->db->error()["message"],
                        "qry" => $this->db->last_query()
                    );
                    $this->sys_error_db($error);
                    exit;
                }
                $sql_tat_v2b = "INSERT INTO one_dash.ss_tat_v2b(
                    SsTatV2bID,
                    SsTatV2bDate,
                    SsTatV2bM_BranchID,
                    SsTatV2bM_BranchCode,
                    SsTatV2bNat_GroupID,
                    SsTatV2bT_SampleStationID,
                    SsTatV2bT_SampleStationName,
                    SsTatV2bTungguData,
                    SsTatV2bTunggu,
                    SsTatV2bTungguPct) VALUES(?,?,?,?,?,?,?,?,?,?)";
                $qry_tat_v2b = $this->db->query($sql_tat_v2b, array(
                    $tatv2b["SsTatV2bID"],
                    $tatv2b["SsTatV2bDate"],
                    $branchid,
                    $branchcode,
                    $tatv2b["SsTatV2bNat_GroupID"],
                    $tatv2b["SsTatV2bT_SampleStationID"],
                    $tatv2b["SsTatV2bT_SampleStationName"],
                    $tatv2b["SsTatV2bTungguData"],
                    $tatv2b["SsTatV2bTunggu"],
                    $tatv2b["SsTatV2bTungguPct"]
                ));
                if (!$qry_tat_v2b) {
                    $error = array(
                        "message" => $this->db->error()["message"],
                        "qry" => $this->db->last_query()
                    );
                    $this->sys_error_db($error);
                    exit;
                }
            }

            $ss_tat_v2b_n = $data["ss_tat_v2b_n"];
            foreach ($ss_tat_v2b_n as $key => $tatv2bn) {
                $sql_tat_v2bn_del = "delete from one_dash.ss_tat_v2b_n where SsTatV2bM_BranchID = ? and  SsTatV2bID = ? ";
                $qry = $this->db->query($sql_tat_v2bn_del, array(
                    $branchid,
                    $tatv2bn["SsTatV2bID"]
                ));
                if (!$qry) {
                    $error = array(
                        "message" => $this->db->error()["message"],
                        "qry" => $this->db->last_query()
                    );
                    $this->sys_error_db($error);
                    exit;
                }
                $sql_tat_v2b_n = "INSERT INTO one_dash.ss_tat_v2b_n(
                    SsTatV2bID,
                    SsTatV2bDate,
                    SsTatV2bM_BranchID,
                    SsTatV2bM_BranchCode,
                    SsTatV2bNat_GroupID,
                    SsTatV2bT_SampleStationID,
                    SsTatV2bT_SampleStationName,
                    SsTatV2bTungguData,
                    SsTatV2bTunggu,
                    SsTatV2bTungguPct) VALUES(?,?,?,?,?,?,?,?,?,?)";
                $qry_tat_v2b_n = $this->db->query($sql_tat_v2b_n, array(
                    $tatv2bn["SsTatV2bID"],
                    $tatv2bn["SsTatV2bDate"],
                    $branchid,
                    $branchcode,
                    $tatv2bn["SsTatV2bNat_GroupID"],
                    $tatv2bn["SsTatV2bT_SampleStationID"],
                    $tatv2bn["SsTatV2bT_SampleStationName"],
                    $tatv2bn["SsTatV2bTungguData"],
                    $tatv2bn["SsTatV2bTunggu"],
                    $tatv2bn["SsTatV2bTungguPct"]
                ));
                if (!$qry_tat_v2b_n) {
                    $error = array(
                        "message" => $this->db->error()["message"],
                        "qry" => $this->db->last_query()
                    );
                    $this->sys_error_db($error);
                    exit;
                }
            }

            $ss_tat_v2c = $data["ss_tat_v2c"];
            foreach ($ss_tat_v2c as $key => $tatv2c) {
                $sql_tat_v2c_del = "delete from one_dash.ss_tat_v2c where SsTatV2cM_BranchID = ? and  SsTatV2cID = ? ";
                $qry = $this->db->query($sql_tat_v2c_del, array(
                    $branchid,
                    $tatv2c["SsTatV2cID"]
                ));
                if (!$qry) {
                    $error = array(
                        "message" => $this->db->error()["message"],
                        "qry" => $this->db->last_query()
                    );
                    $this->sys_error_db($error);
                    exit;
                }
                $sql_tat_v2c = "INSERT INTO one_dash.ss_tat_v2c(
                    SsTatV2cID,
                    SsTatV2cDate,
                    SsTatV2cM_BranchID,
                    SsTatV2cM_BranchCode,
                    SsTatV2cNat_SubgroupID,
                    SsTatV2cNat_SubgroupName,
                    SsTatV2cVerifikasiData,
                    SsTatV2cVerifikasi,
                    SsTatV2cVerifikasiPct) VALUES(?,?,?,?,?,?,?,?,?)";
                $qry_tat_v2c = $this->db->query($sql_tat_v2c, array(
                    $tatv2c["SsTatV2cID"],
                    $tatv2c["SsTatV2cDate"],
                    $branchid,
                    $branchcode,
                    $tatv2c["SsTatV2cNat_SubgroupID"],
                    $tatv2c["SsTatV2cNat_SubgroupName"],
                    $tatv2c["SsTatV2cVerifikasiData"],
                    $tatv2c["SsTatV2cVerifikasi"],
                    $tatv2c["SsTatV2cVerifikasiPct"]
                ));
                if (!$qry_tat_v2c) {
                    $error = array(
                        "message" => $this->db->error()["message"],
                        "qry" => $this->db->last_query()
                    );
                    $this->sys_error_db($error);
                    exit;
                }
            }

            $ss_tat_v2c_n = $data["ss_tat_v2c_n"];
            foreach ($ss_tat_v2c_n as $key => $tatv2cn) {
                $sql_tat_v2cn_del = "delete from one_dash.ss_tat_v2c_n where SsTatV2cM_BranchID = ? and  SsTatV2cID = ? ";
                $qry = $this->db->query($sql_tat_v2cn_del, array(
                    $branchid,
                    $tatv2cn["SsTatV2cID"]
                ));
                if (!$qry) {
                    $error = array(
                        "message" => $this->db->error()["message"],
                        "qry" => $this->db->last_query()
                    );
                    $this->sys_error_db($error);
                    exit;
                }
                $sql_tat_v2c_n = "INSERT INTO one_dash.ss_tat_v2c_n(
                    SsTatV2cID,
                    SsTatV2cDate,
                    SsTatV2cM_BranchID,
                    SsTatV2cM_BranchCode,
                    SsTatV2cNat_SubgroupID,
                    SsTatV2cNat_SubgroupName,
                    SsTatV2cVerifikasiData,
                    SsTatV2cVerifikasi,
                    SsTatV2cVerifikasiPct) VALUES(?,?,?,?,?,?,?,?,?)";
                $qry_tat_v2c_n = $this->db->query($sql_tat_v2c_n, array(
                    $tatv2cn["SsTatV2cID"],
                    $tatv2cn["SsTatV2cDate"],
                    $branchid,
                    $branchcode,
                    $tatv2cn["SsTatV2cNat_SubgroupID"],
                    $tatv2cn["SsTatV2cNat_SubgroupName"],
                    $tatv2cn["SsTatV2cVerifikasiData"],
                    $tatv2cn["SsTatV2cVerifikasi"],
                    $tatv2cn["SsTatV2cVerifikasiPct"]
                ));
                if (!$qry_tat_v2c_n) {
                    $error = array(
                        "message" => $this->db->error()["message"],
                        "qry" => $this->db->last_query()
                    );
                    $this->sys_error_db($error);
                    exit;
                }
            }

            $ss_tat_v2_n = $data["ss_tat_v2_n"];
            foreach ($ss_tat_v2_n as $key => $tatv2n) {
                $sql_tat_v2n_del = "delete from one_dash.ss_tat_v2_n where SsTatV2M_BranchID = ? and  SsTatV2ID = ? ";
                $qry = $this->db->query($sql_tat_v2n_del, array(
                    $branchid,
                    $tatv2n["SsTatV2ID"]
                ));
                if (!$qry) {
                    $error = array(
                        "message" => $this->db->error()["message"],
                        "qry" => $this->db->last_query()
                    );
                    $this->sys_error_db($error);
                    exit;
                }
                $sql_tat_v2_n = "INSERT INTO one_dash.ss_tat_v2_n(
                    SsTatV2ID,
                    SsTatV2Date,
                    SsTatV2M_BranchID,
                    SsTatV2M_BranchCode,
                    SsTatV2Month,
                    SsTatV2FoTargetEntry,
                    SsTatV2FoVerif,
                    SsTatV2FoTotalData,
                    SsTatV2FoPctFo,
                    SsTatV2FoPctVerif,
                    SsTatV2SamplingData,
                    SsTatV2SamplingHasil,
                    SsTatV2SamplingPct,
                    SsTatV2VerifData,
                    SsTatV2VerifHasil,
                    SsTatV2VerifPct, 
                    SsTatV2PengolahanData,
                    SsTatV2PengolahanHasil,
                    SsTatV2PengolahanPct,
                    SsTatV2ValidasiData,
                    SsTatV2ValidasiHasil,
                    SsTatV2ValidasiPct,
                    SsTatV2AdmLabData,
                    SsTatV2AdmLabHasil,
                    SsTatV2AdmLabPct,
                    SsTatV2FullLabData,
                    SsTatV2FullLabHasil,
                    SsTatV2FullLabPct
                    ) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
                $qry_tat_v2_n = $this->db->query($sql_tat_v2_n, array(
                    $tatv2n["SsTatV2ID"],
                    $tatv2n["SsTatV2Date"],
                    $branchid,
                    $branchcode,
                    $tatv2n["SsTatV2Month"],
                    $tatv2n["SsTatV2FoTargetEntry"],
                    $tatv2n["SsTatV2FoVerif"],
                    $tatv2n["SsTatV2FoTotalData"],
                    $tatv2n["SsTatV2FoPctFo"],
                    $tatv2n["SsTatV2FoPctVerif"],
                    $tatv2n["SsTatV2SamplingData"],
                    $tatv2n["SsTatV2SamplingHasil"],
                    $tatv2n["SsTatV2SamplingPct"],
                    $tatv2n["SsTatV2VerifData"],
                    $tatv2n["SsTatV2VerifHasil"],
                    $tatv2n["SsTatV2VerifPct"],
                    $tatv2n["SsTatV2PengolahanData"],
                    $tatv2n["SsTatV2PengolahanHasil"],
                    $tatv2n["SsTatV2PengolahanPct"],
                    $tatv2n["SsTatV2ValidasiData"],
                    $tatv2n["SsTatV2ValidasiHasil"],
                    $tatv2n["SsTatV2ValidasiPct"],
                    $tatv2n["SsTatV2AdmLabData"],
                    $tatv2n["SsTatV2AdmLabHasil"],
                    $tatv2n["SsTatV2AdmLabPct"],
                    $tatv2n["SsTatV2FullLabData"],
                    $tatv2n["SsTatV2FullLabHasil"],
                    $tatv2n["SsTatV2FullLabPct"]
                ));
                if (!$qry_tat_v2_n) {
                    $error = array(
                        "message" => $this->db->error()["message"],
                        "qry" => $this->db->last_query()
                    );
                    $this->sys_error_db($error);
                    exit;
                }
            }

            $ss_tat_v2_nonlab = $data["ss_tat_v2_nonlab"];
            foreach ($ss_tat_v2_nonlab as $key => $tatv2nonlab) {
                $sql_tat_v2nonlab_del = "delete from one_dash.ss_tat_v2_nonlab where SsTatV2NonLabM_BranchID = ? and  SsTatV2NonLabID = ? ";
                $qry = $this->db->query($sql_tat_v2nonlab_del, array(
                    $branchid,
                    $tatv2nonlab["SsTatV2NonLabID"]
                ));
                if (!$qry) {
                    $error = array(
                        "message" => $this->db->error()["message"],
                        "qry" => $this->db->last_query()
                    );
                    $this->sys_error_db($error);
                    exit;
                }
                $sql_tat_v2_nonlab = "INSERT INTO one_dash.ss_tat_v2_nonlab(
                    SsTatV2NonLabID,
                    SsTatV2NonLabDate,
                    SsTatV2NonLabM_BranchID,
                    SsTatV2NonLabM_BranchCode,
                    SsTatV2NonLabNat_GroupID,
                    SsTatV2NonLabNat_GroupName,
                    SsTatV2NonLabHandlingData,
                    SsTatV2NonLabHandling,
                    SsTatV2NonLabHandlingPct,  
                    SsTatV2NonLabVerifikasiData,
                    SsTatV2NonLabVerifikasi,
                    SsTatV2NonLabVerifikasiPct,
                    SsTatV2NonLabHandlingImageData,
                    SsTatV2NonLabHandlingImage,
                    SsTatV2NonLabHandlingImagePct,
                    SsTatV2NonLabValidasiData,
                    SsTatV2NonLabValidasi,
                    SsTatV2NonLabValidasiPct,
                    SsTatV2NonLabTerimaFoData,
                    SsTatV2NonLabTerimaFo,
                    SsTatV2NonLabTerimaFoPct) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
                $qry_tat_v2_nonlab = $this->db->query($sql_tat_v2_nonlab, array(
                    $tatv2nonlab["SsTatV2NonLabID"],
                    $tatv2nonlab["SsTatV2NonLabDate"],
                    $branchid,
                    $branchcode,
                    $tatv2nonlab["SsTatV2NonLabNat_GroupID"],
                    $tatv2nonlab["SsTatV2NonLabNat_GroupName"],
                    $tatv2nonlab["SsTatV2NonLabHandlingData"],
                    $tatv2nonlab["SsTatV2NonLabHandling"],
                    $tatv2nonlab["SsTatV2NonLabHandlingPct"],
                    $tatv2nonlab["SsTatV2NonLabVerifikasiData"],
                    $tatv2nonlab["SsTatV2NonLabVerifikasi"],
                    $tatv2nonlab["SsTatV2NonLabVerifikasiPct"],
                    $tatv2nonlab["SsTatV2NonLabHandlingImageData"],
                    $tatv2nonlab["SsTatV2NonLabHandlingImage"],
                    $tatv2nonlab["SsTatV2NonLabHandlingImagePct"],
                    $tatv2nonlab["SsTatV2NonLabValidasiData"],
                    $tatv2nonlab["SsTatV2NonLabValidasi"],
                    $tatv2nonlab["SsTatV2NonLabValidasiPct"],
                    $tatv2nonlab["SsTatV2NonLabTerimaFoData"],
                    $tatv2nonlab["SsTatV2NonLabTerimaFo"],
                    $tatv2nonlab["SsTatV2NonLabTerimaFoPct"]
                ));
                if (!$qry_tat_v2_nonlab) {
                    $error = array(
                        "message" => $this->db->error()["message"],
                        "qry" => $this->db->last_query()
                    );
                    $this->sys_error_db($error);
                    exit;
                }
            }

            $ss_tat_v2_nonlab_n = $data["ss_tat_v2_nonlab_n"];
            foreach ($ss_tat_v2_nonlab_n as $key => $tatv2nonlabn) {
                $sql_tat_v2nonlabn_del = "delete from one_dash.ss_tat_v2_nonlab_n where SsTatV2NonLabM_BranchID = ? and  SsTatV2NonLabID = ? ";
                $qry = $this->db->query($sql_tat_v2nonlabn_del, array(
                    $branchid,
                    $tatv2nonlabn["SsTatV2NonLabID"]
                ));
                if (!$qry) {
                    $error = array(
                        "message" => $this->db->error()["message"],
                        "qry" => $this->db->last_query()
                    );
                    $this->sys_error_db($error);
                    exit;
                }
                $sql_tat_v2_nonlab_n = "INSERT INTO one_dash.ss_tat_v2_nonlab_n(
                    SsTatV2NonLabID,
                    SsTatV2NonLabDate,
                    SsTatV2NonLabM_BranchID,
                    SsTatT2NonLabM_BranchCode,
                    SsTatV2NonLabNat_GroupID,
                    SsTatV2NonLabNat_GroupName,
                    SsTatV2NonLabHandlingData,
                    SsTatV2NonLabHandling,
                    SsTatV2NonLabHandlingPct,
                    SsTatV2NonLabVerifikasiData,
                    SsTatV2NonLabVerifikasi,
                    SsTatV2NonLabVerifikasiPct,
                    SsTatV2NonLabHandlingImageData,
                    SsTatV2NonLabHandlingImage,
                    SsTatV2NonLabHandlingImagePct,
                    SsTatV2NonLabValidasiData,
                    SsTatV2NonLabValidasi,
                    SsTatV2NonLabValidasiPct,
                    SsTatV2NonLabTerimaFoData,
                    SsTatV2NonLabTerimaFo,
                    SsTatV2NonLabTerimaFoPct) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
                $qry_tat_v2_nonlab_n = $this->db->query($sql_tat_v2_nonlab_n, array(
                    $tatv2nonlabn["SsTatV2NonLabID"],
                    $tatv2nonlabn["SsTatV2NonLabDate"],
                    $branchid,
                    $branchcode,
                    $tatv2nonlabn["SsTatV2NonLabNat_GroupID"],
                    $tatv2nonlabn["SsTatV2NonLabNat_GroupName"],
                    $tatv2nonlabn["SsTatV2NonLabHandlingData"],
                    $tatv2nonlabn["SsTatV2NonLabHandling"],
                    $tatv2nonlabn["SsTatV2NonLabHandlingPct"],
                    $tatv2nonlabn["SsTatV2NonLabVerifikasiData"],
                    $tatv2nonlabn["SsTatV2NonLabVerifikasi"],
                    $tatv2nonlabn["SsTatV2NonLabVerifikasiPct"],
                    $tatv2nonlabn["SsTatV2NonLabHandlingImageData"],
                    $tatv2nonlabn["SsTatV2NonLabHandlingImage"],
                    $tatv2nonlabn["SsTatV2NonLabHandlingImagePct"],
                    $tatv2nonlabn["SsTatV2NonLabValidasiData"],
                    $tatv2nonlabn["SsTatV2NonLabValidasi"],
                    $tatv2nonlabn["SsTatV2NonLabValidasiPct"],
                    $tatv2nonlabn["SsTatV2NonLabTerimaFoData"],
                    $tatv2nonlabn["SsTatV2NonLabTerimaFo"],
                    $tatv2nonlabn["SsTatV2NonLabTerimaFoPct"]
                ));
                if (!$qry_tat_v2_nonlab_n) {
                    $error = array(
                        "message" => $this->db->error()["message"],
                        "qry" => $this->db->last_query()
                    );
                    $this->sys_error_db($error);
                    exit;
                }
            }

            $this->db->trans_commit();
            $result = array(
                "affected_rows" => $this->db->affected_rows()
            );
            $this->sys_ok($result);
        } catch (Exception $exc) {
            $message = $exc->getMessage();
            $this->sys_error($message);
        }
    }
}