<?php

$PartID     = $_POST['PartID'];
$QtyRequest = $_POST['QtyRequest'];
$UnitID     = $_POST['UnitID'];
$LocationID = $_POST['LocationID'];
$MPROSector = $_POST['MPROSector'];
$Notes      = $_POST['Notes'];
$count      = count($PartID);

for ($i = 0; $i < $count; $i++) {
    /*VALIDASI CEK STOK*/
    $text = "SELECT SUM(Qty) as QtyStock FROM buku_stock201905 where PartID='$PartID[$i]' AND LocationID='$LocationID[$i]'";
    $q    = sqlsrv_query($conn, $text);
    while ($r = sqlsrv_fetch_array($q, SQLSRV_FETCH_ASSOC)) {
        $QtyStock = $r['QtyStock'];
    }

    if ($QtyRequest[$i] >= $QtyStock) {
        echo "<script>alert('Gagal Menyimpan MPRO, Stock Tidak Cukup');history.go(-1);</script>";
    } else {
        $queryhd               = sqlsrv_query($conn, $sqlhd);
        $query                 = sqlsrv_query($conn, $updatereq);
        $queryinsertdt         = sqlsrv_query($conn, $sqldt);
        $queryinsertobukustock = sqlsrv_query($conn, $sqlbukustock);
        echo "<script>alert('Berhasil Menyimpan MPRO');history.go(-1);</script>";
    }
}
?>