prosesInput

<html>

<head>
  <title>Purchasing Product From Supplier</title>

  </SCRIPT>
</head>

<body>

<?php

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

    $bulan = date("F");
    $tanggal = date("d-Y");
    $date = date("Y-m-d");

    $totalItem = $_POST['listItem'];

//start formating id_pembelian

    $sqlSelect = "SELECT max(id_pembelian) as idMax from detail_pembelian";
    $resultSelect = mysql_query($sqlSelect);

    $data = mysql_fetch_array($resultSelect);
    $dataId = $data['idMax'];

    $reqId = (int) substr($dataId, 2,4);
    $reqId++;

    $idpembelian = 'PR' . sprintf("%04s", $reqId);

//end of format

//start formating id_detail_pembelian

    $sqlSelectDetail = "SELECT max(id_detail_pembelian) as idDetailMax from detail_pembelian";
    $resultSelectDetail = mysql_query($sqlSelectDetail);

    $dataDetail = mysql_fetch_array($resultSelectDetail);
    $dataDetailNew = $dataDetail['idDetailMax'];

    $reqIdDetail = (int) substr($dataDetailNew, 2,4);

    $iddetail = 'DP' . sprintf("%04s", $reqIdDetail);

//end of format

    echo "<form method='POST' action='../proses/doInsertFormPurchase.php' >";
     echo "<table align='center'>";
      echo "<tr bgcolor='iceblue'>";
       echo "<td align='center' colspan='5' width='450' ><font face='calibri' size='6' color='white' >SKY NET POS SYSTEM
             </br> Purchasing Form </td>";
      echo "</tr>";
      echo "<tr bgcolor='iceblue'>";
       echo "<td align='left' colspan='3'><font face='calibri' size='4' color='white' >No Form:</br>
             $idpembelian</td>";
       echo "<td align='right' colspan='2'><font face='calibri' size='4' color='white' >$bulan </br> $tanggal </td>";
      echo "</tr>";
      echo "<tr bgcolor='iceblue'>";
       echo "<td align='center' ><font face='calibri' size='4' color='white' >No</td>";
       echo "<td align='center' ><font face='calibri' size='4' color='white' >Merk Product </td>";
       echo "<td align='center' ><font face='calibri' size='4' color='white' >Purchase Price </td>";
       echo "<td align='center' ><font face='calibri' size='4' color='white' >Sold Price </td>";
       echo "<td align='center' ><font face='calibri' size='4' color='white' >QTY </td>";
      echo "</tr>";

//select data list

      $nomor=0;

      for ($i=0; $i<$totalItem; $i++){

      $nomor++;
      $iddetail++;

      echo "<input type='hidden' name='iddetail[]' value='$iddetail'>";
      echo "<input type='hidden' name='idpembelian[]' value='$idpembelian'>";
      echo "<input type='hidden' name='date[]' value='$date'>";
      echo "<input type='hidden' name='nomor[]' value='$nomor'>";
      echo "<tr bgcolor='iceblue'>";
       echo "<td align='center'><font face='calibri' size='4' color='white' >$nomor</td>";
       echo "<td align='center'><font face='calibri' size='4' color='white' ><SELECT name='nameID[]'>";

                $sqlSelectId = "SELECT id_produk, merk_produk from master_produk";
                $resultSelectId = mysql_query($sqlSelectId, $conn)or
                    die(mysql_error()."An error occure in SQL Query <br> Query: $sqlSelectId");

                while ($line = mysql_fetch_row($resultSelectId)) {
                    $idproduk = $line[0];
                    $merk = $line[1];

                    echo "<option value='$idproduk, $merk'>$merk</option>";
                }

       echo "</td>";
       echo "<td align='center'><input type='text' name='hargabeli[]' size='14'></td>";
       echo "<td align='center'><input type='text' name='hargajual[]' size='14'> </td>";
       echo "<td align='center'><input type='text' name='qty[]' size='1'> </td>";
      echo "</tr>";
      }

//end of select data

      echo "<tr bgcolor='iceblue'>";
       echo "<td align='center' colspan='5'><input type='submit' value='Save' ></td>";
      echo "</tr>";
     echo "</table>";
    echo "</form>";

?>

</body>
</html>