detailfeed.php

			<?php
			@include('conn.php');
      $id=$_GET['id'];
			$strSQL = "SELECT * FROM `buymeterial`, `restaurant` WHERE buymeterial.res_name=restaurant.res_name and buymeterial.id_mat='$id'";
			$objQuery = mysql_query($strSQL, $connect1);
			while ($objReSult = mysql_fetch_array($objQuery)) {
			$username=$objReSult["user_name"];
      $resname=$objReSult["res_name"];
      $keeper=$objReSult["shopkeeper"];

			}
			 ?>
      <h4>&nbsp;&nbsp;&nbsp;รายละเอียดการสั่งซื้ออาหารทางสายยาง</h4>
            <?php
							  if(isset($_POST['submit2'])){
									$summ=$_POST['sum'];
									@include('conn.php');
		              $sql  = "update `cpa`.`buymeterial` set `total_mat`='".$summ."' where id_mat = '".$id."'";
		              $result  = mysql_query($sql);
		              if(!$result){
		                die('ไม่สามารแก้ไขข้อมูลได้ เกิดข้อผิิดพลาดบางประการ'.mysql_error());
		              }
		              else {
		                echo "<script>

		                    location='suc_buymat.php?id=$id';

		                </script>";
		              }

								}
              if(isset($_POST['submit'])){
              $idd=$_POST['idd'];
              $namemat=$_POST['namemat'];
              $count=$_POST['count'];
              $unit=$_POST['unit'];
              $price=$_POST['price'];
              @include('conn.php');
              $insert = "INSERT INTO detail_buymat  VALUES  ('".$idd."','".$namemat."','".$count."','".$unit."','".$count*$price."','".$id."')";
                    $query = mysql_query($insert,$connect1);



              if(!$insert){
                echo( "<script> alert('ไม่สามารถเพิ่มข้อมูลได้ เกิดข้อผิดพลาดบางประการ');
                    </script>");
              }

            }
            @include('conn.php');
            $strSQL = "SELECT MAX(id_detail) FROM detail_buymat";
            $objQuery = mysql_query($strSQL, $connect1);
            while ($objReSult = mysql_fetch_array($objQuery)) {
             $result= $objReSult["MAX(id_detail)"];
             $ina="";
               for($a=0;$a<Strlen($result);$a++){
               if($a>=2)$ina =$ina.intval($result[$a])  ;
               }
               $idd= "DT-".sprintf("%04d", $ina+1);
            }
             ?>
            <div class="modal-body">
              <table class="table table-striped table-bordered">
                <?php
        				@include('conn.php');
        				$strSQL = "SELECT SUM(price) AS sumprice FROM `detail_buymat` WHERE id_mat='$id'";
        				$objQuery = mysql_query($strSQL, $connect1);
        				while ($objReSult = mysql_fetch_array($objQuery)) {
        				 $sum= $objReSult["sumprice"];

        				}
        				 ?>


                 <tr class="warning">
                   <td align=center><b>ลำดับ</td>

                   <td align=center><b>ชื่ออาหารทางสายยาง</td>
                   <td align=center><b>จำนวน</td>
                   <td align=center><b>หน่วยนับ</td>
                   <td align=center colspan="2"><b>ราคาต่อหน่วย(บาท)</td>

                 </tr>
   							<?php
                 $no=1;
                 $strSQL = "SELECT * FROM detail_buymat a,feed b,unit c where a.mat_id=b.feed_id and a.unit_id=c.unit_id AND a.id_mat='$id'";

                 $objQuery = mysql_query($strSQL,$connect1) or die("Error Query [".$strSQL."]");
                 while ($objReSult = mysql_fetch_array($objQuery)) {
                   ?>
                   <tr class ="info">
                     <td align=center><?php echo $no ?></td>

                     <td align=center><?php echo $objReSult["feed_name"]; ?></td>
                     <td align=right><?php echo $objReSult["count"]; ?></td>
                     <td align=center><?php echo $objReSult["unit_name"]; ?></td>
                     <td align=right colspan="2"><?php echo number_format($objReSult["price"],2); ?></td>


                   </tr>

                   <?php

   $no++;

                 }


   							 ?>
                  <tr class ="info"><td colspan=5><div align="right">ราคารวม(บาท)</td>

                  <td><div align=right><?php echo number_format($sum,2); ?></td>
   							 </tr></div>

   							 </table>
            </div>
					</div>