form_purchase_request page proses

<?php

session_start();
include "../secure/connect.php";

$q = "SELECT * FROM mst_user";
$e = mysqli_query($id_mysql, $q);

$user = @$_SESSION['email'];
$tanggal = date("Y-m-d H:i:s");
$status = "-";
$status_request  = $_REQUEST['status_request'];
$kode_ref = $_REQUEST['kode_ref'];
$kode_supplier = $_REQUEST['kode_supplier'];
$kode_gudang = $_REQUEST['kode_gudang'];
$nama_perusahaan = $_REQUEST['nama_perusahaan'];
$catatan = $_REQUEST['catatan'];
$tanggal_pemesanan = $_REQUEST['tanggal_pemesanan'];

//pembatas

$today = date("Ymd");
$query =mysqli_query($id_mysql, "SELECT max(kode_ref) as maxID FROM  purchase_request WHERE kode_ref LIKE '$today%'");
 $data = mysqli_fetch_array($query);
 $idMax = $data['maxID'];
 $NoUrut = (int) substr($idMax, 8, 4);
 $NoUrut++;
 $kode_ref = $today .sprintf('%04s', $NoUrut);
//pembatas

if (isset($_REQUEST['sku'])) {
    $sku = $_REQUEST['sku'];
    $nama_produk = $_REQUEST['nama_produk'];
    $kode_produk = $_REQUEST['kode_produk'];
    $jumlah = $_REQUEST['jumlah'];
    $harga = $_REQUEST['harga'];

    for ($count = 0; $count <count(0); $count++) {
      $sku_clean = mysqli_real_escape_string($id_mysql, $sku[$count]);
      $kode_produk_clean = mysqli_real_escape_string($id_mysql, $kode_produk[$count]);
      $nama_produk_clean = mysqli_real_escape_string($id_mysql, $nama_produk[$count]);
      $harga_clean = mysqli_real_escape_string($id_mysql, $harga[$count]);
      $jumlah_clean = mysqli_real_escape_string($id_mysql, $jumlah[$count]);

      if ($sku_clean !='' && $kode_produk_clean !='' && $nama_produk_clean !='' && $harga_clean !='' && $jumlah_clean !='') {

        $query = "INSERT INTO purchase_request(kode_ref,kode_supplier,kode_gudang,nama_perusahaan,createuser,createtime,catatan,tanggal_pemesanan,status,status_request) VALUES('$kode_ref','$kode_supplier','$kode_gudang','$nama_perusahaan','$user','$tanggal','$catatan','$tanggal_pemesanan','$status','$status_request') ;";

        $query .= "INSERT INTO item_purchase_request_teguh(sku,kode_produk,nama_produk,harga,jumlah,createtime,kode_ref,createuser,status)VALUES('$sku_clean','$kode_produk_clean','$nama_produk_clean','$harga_clean','$jumlah_clean','$tanggal','$kode_ref','$user','$status')";

      }
    }

    if ($query !='') {

      if (mysqli_multi_query($id_mysql, $query)) {
        ?>

          <img src='images/purrClose.png' onload ='swal({
    title: "Hey, Good job !!",
    text: "You Successfully Add A Purchase Request !!",
    type: "success",
    showCancelButton: false,
    confirmButtonColor: "#75B12E",
    closeOnConfirm: true,
    closeOnCancel: false
  },
  function(isConfirm){
    if (isConfirm) {
      window.location="purchase_request"
    }
  });'/>

        <?php
      }else{
  echo 'Error:'.$query."<br>". mysqli_error($id_mysql);
mysqli_close($id_mysql);
}

    }else{
      echo "All Fields Are Required";
    }
    //pembatas logika
}
?>