BE_IBL/application/controllers/one-dash/R_payment.php

<?php
class R_payment extends MY_Controller
{
    var $db;
    public function __construct()
    {
        parent::__construct();
        // db devnas
        // $this->db = $this->load->database("nas_report", true);
    }

    public function index()
    {
        echo "RECEIVER R_payment.php";
    }

    function get_param_z()
    {
        $body_z = file_get_contents("php://input");
        $body = gzuncompress($body_z);
        return json_decode($body, true);
    }

    function reply($resp)
    {
        echo json_encode($resp);
    }

    function reply_gz($resp)
    {
        //echo json_encode($resp);
        echo gzcompress(json_encode($resp));
    }

    function r_payment_upload_log()
    {
        $this->db->trans_begin();
        $param = $this->get_param_z();
        // print_r($param);
        // print_r;

        // echo json_decode($param);

        // print_r($prm);

        $prev_day = "";
        foreach ($param['data'] as $key) {
            $day = $key['orderDay'];
            $M_BranchID= $key['M_BranchID'];

            if ($day != $prev_day) {
                // query delete
                $sql_delete = "DELETE FROM one_dash.nat_payment
                WHERE Nat_PaymentM_BranchID = ?
                AND Nat_PaymentOrderDay = ?";

                $qry_delete = $this->db->query($sql_delete, [
                    $M_BranchID,
                    $day
                ]);

                if (!$qry_delete) {
                    // print_r($this->db->last_query());
                    $this->db->trans_rollback();
                    $this->sys_error_db(["status" => "ERR", "message" => "delete nat_payment | " .
                        $this->db->error()["message"], "debug" => $this->db->last_query()]);
                    exit;
                }
            }
            $prev_day = $day;
        }

        foreach ($param['data'] as $key) {
            $this->insert_nat_payment(
                $key['M_BranchID'],
                $key['M_BranchCode'],
                $key['T_OrderHeaderM_CompanyID'],
                $key['orderDay'],
                $key['orderMonth'],
                $key['orderQuarter'],
                $key['orderYear'],
                $key['paymentDay'],
                $key['month'],
                $key['year'],
                $key['quarter'],
                $key['piutang'],
                $key['paymentTotal'],
                $key['sisaPiutang']
            );
        }

        $this->db->trans_commit();
        $this->reply(
            [
                "status" => "OK",
                "message" => "Data berhasil ditambahkan ke nat_payment",
            ]
        );
    }

    function insert_nat_payment(
        $M_BranchID,
        $M_BranchCode,
        $T_OrderHeaderM_CompanyID,
        $orderDay,
        $orderMonth,
        $orderQuarter,
        $orderYear,
        $paymentDay,
        $month,
        $year,
        $quarter,
        $piutang,
        $paymentTotal,
        $sisaPiutang
    ) {
        // insert
        $sql_insert = "INSERT INTO one_dash.nat_payment(
            Nat_PaymentM_BranchID,
            Nat_PaymentM_BranchCode,
            Nat_PaymentM_CompanyID,
            Nat_PaymentOrderDay,
            Nat_PaymentOrderMonth,
            Nat_PaymentOrderQuarter,
            Nat_PaymentOrderYear,
            Nat_PaymentDay,
            Nat_PaymentMonth,
            Nat_PaymentYear,
            Nat_PaymentQuarter,
            Nat_PaymentPiutang,
            Nat_PaymentTotal,
            Nat_PaymentSisaPiutang,
            Nat_PaymentIsActive
        ) VALUES (?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?,?,?,?)";

        $qry_insert = $this->db->query($sql_insert, [
            $M_BranchID,
            $M_BranchCode,
            $T_OrderHeaderM_CompanyID,
            $orderDay,
            $orderMonth,
            $orderQuarter,
            $orderYear,
            $paymentDay,
            $month,
            $year,
            $quarter,
            $piutang,
            $paymentTotal,
            $sisaPiutang,
            'Y'
        ]);

        if (!$qry_insert) {
            // print_r($this->db->last_query());
            $this->db->trans_rollback();
            $this->sys_error_db(["status" => "ERR", "message" => "insert nat_payment | " .
                $this->db->error()["message"], "debug" => $this->db->last_query()]);
            exit;
        }
    }
}