invisio v2.0

<?php
session_start();
include('../../../config/main_function.php');
$secure = "cAh3DrJACzw4RbU";
$connection = connectDB($secure);

$certification_lot_id = getRandomID(10, 'tbl_certification_lot', 'certification_lot_id');
$create_note = mysqli_real_escape_string($connection, $_POST['create_note']);

$cer_date = explode('/', $_POST['certification_date']);
$certification_date = date('Y-m-d', strtotime($cer_date['0'] . "-" . $cer_date['1'] . "-" . $cer_date['2']));

$eff_date = explode('/', $_POST['effective_date']);
$effective_date = date('Y-m-d', strtotime($eff_date['0'] . "-" . $eff_date['1'] . "-" . $eff_date['2']));

$admin_id = mysqli_real_escape_string($connection, $_POST['admin_id']);
$temp_id = explode(".", $admin_id);
$admin_id = bigsara_decode($temp_id[0], $temp_id[1]);

// $member_id = mysqli_real_escape_string($connection, $_POST['member_id']);

if ($connection) {

// $list_order = 1;
    // while ($row_id = mysqli_fetch_assoc($res_memberid)) {
    //     $member_id = $row_id['member_id'];
    //     // เช็คว่า member_id มีใน tbl_certification_lot_member หรือไม่
    //     $sql_check = "SELECT * FROM tbl_certification_lot_member WHERE member_id = '$member_id'";
    //     $res_check = mysqli_query($connection, $sql_check);
    //     $num_check = mysqli_num_rows($res_check);

//     if ($num_check < 1) {
    //         $sql_cer_member = "INSERT INTO `tbl_certification_lot_member` 
    //         SET certification_lot_id = '$certification_lot_id',
    //         member_id = '$member_id',
    //         list_order = '$list_order'";
    //         $res_cer_member = mysqli_query($connection, $sql_cer_member);
    //     }
    //     $list_order++;
    // }
    ////

$sql_cer = "INSERT INTO tbl_certification_lot 
    SET certification_lot_id  = '$certification_lot_id',
    create_admin_id = '$admin_id',
    create_note = '$create_note',
    certification_date = '$certification_date',
    effective_date = '$effective_date'
    ";

$res_cer = mysqli_query($connection, $sql_cer);
    if ($res_cer) {
      
        // insert member ที่ approver = 1 / member_code ว่าง  / reject_status ว่าง / storage_no ไม่ว่าง
        // $sql_memberid = "SELECT member_id FROM tbl_member WHERE approve_status = '1' AND member_code IS NULL AND storage_no IS NOT NULL AND reject_status IS NULL";
        $sql_memberid = "SELECT member_id FROM tbl_member WHERE approve_status = '1' AND member_code IS NULL AND reject_status IS NULL";
        $res_memberid = mysqli_query($connection, $sql_memberid);

$list_order = 1;
        while ($row_id = mysqli_fetch_assoc($res_memberid)) {
            $member_id = $row_id['member_id'];
            // เช็คว่า member_id มีใน tbl_certification_lot_member หรือไม่
            $sql_check = "SELECT * FROM tbl_certification_lot_member WHERE member_id = '$member_id'";
            $res_check = mysqli_query($connection, $sql_check);
            $num_check = mysqli_num_rows($res_check);

if ($num_check < 1) {
                $sql_cer_member = "INSERT INTO `tbl_certification_lot_member` 
                        SET certification_lot_id = '$certification_lot_id',
                        member_id = '$member_id',
                        list_order = '$list_order'";
                $res_cer_member = mysqli_query($connection, $sql_cer_member);
            }
            $list_order++;
        }

// $res_cer_member = mysqli_query($connection, $sql_cer_member);
        $arr['result'] = 1;
        // if ($res_cer_member) {
        //     $arr['result'] = 1;
        // } else {
        //     $arr['result'] = 0;
        // }
    } else {
        $arr['result'] = 0;
    }
} else {
    $arr['result'] = 9;
}

echo json_encode($arr);