001.<?php
002.session_start();
003.require_once ('config/config.php');
004.date_default_timezone_set("Asia/Bangkok");
005.
006.require_once('./tool/mpdf/mpdf.php');
007.ob_start();
008.
009.?>
010.
011.
012.
013.<!DOCTYPE html>
015.<head>
016. <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
017. <meta name="viewport" content="width=device-width, initial-scale=1.0" />
018. <link href="assets/css/bootstrap.css" rel="stylesheet" />
019.
020.</head>
021.
022.<body>
023.
024.
025.<?php
026.
027.$sql1 = "SELECT * FROM batch_detail where sc_id='".$_GET["sc_id"]."' and id='".$_GET["id"]."' GROUP BY product_name";
028.$query1 = mysqli_query($conn,$sql1);
029.while($result1=mysqli_fetch_array($query1))
030.{
031. $id[]=$result1["b_id"];
032. $name[]=$result1["product_name"];
033. $pd_id[]=$result1["pd_id"];
034. $sum[] = $result1["mrp"];
035.
036.}
037.
038.$sql2 = "SELECT * FROM batch_detail where sc_id='".$_GET["sc_id"]."' and id='".$_GET["id"]."' GROUP BY date ";
039.$query2 = mysqli_query($conn,$sql2);
040.while($result2=mysqli_fetch_array($query2))
041.{
042. $bdate[]=$result2["date"];
043.}
044. ?>
045.
046. <table width="100%" border="1" cellpadding="0" cellspacing="0">
047. <thead>
048. <tr>
049. <th height="30" style=" text-align: center;">Item</th>
050. <?php for($i=0;$i<count($bdate);$i++){ ?>
051. <th class="text-center" width="10%"><?php echo date('d/m/Y',strtotime($bdate[$i])); ?></th>
052. <?php } ?>
053. <th width="5%" class="text-center">MRP</th>
054. </tr>
055. </thead>
056. <tbody>
057. <?php
058. for($i=0;$i<count($name);$i++){
059. ?>
060. <tr>
061. <td height="25"> <?php echo $pd_id[$i]; ?> <?php echo $name[$i]; ?></td>
062.
063.
064. <?php for($j=0;$j<count($bdate);$j++){
065.
066. $sql3 = "SELECT * FROM batch_detail WHERE `date`= '$bdate[$j]' AND `product_name` = '$name[$i]' AND sc_id='".$_GET["sc_id"]."' AND id='".$_GET["id"]."'";
067. $query3 = mysqli_query($conn,$sql3);
068. $result3 = mysqli_fetch_array($query3) ?>
069. <td height="25" style=" text-align: center;">
070. <?php echo number_format($result3['mrp']);?>
071. </td>
072.
073. <?php } ?>
074.
075. <td height="25" width="10%" style=" text-align: center;">
076. <?php echo $tot = $sum[$i] += $result3["mrp"];
077.
078. ?>
079.
080. </td>
081. </tr>
082. <?php } ?>
083.
084. <br>
085.
086.
087.
088.
089.
090.
091.
092.
093. <!--แสดงข้อมูลจากตารางที่2-->
094.<?php
095.$sqla1 = "SELECT * FROM batch_detail2 where sc_id='".$_GET["sc_id"]."' and id='".$_GET["id"]."' GROUP BY batch_name";
096.$querya1 = mysqli_query($conn,$sqla1);
097.while($result21 = mysqli_fetch_array($querya1))
098.{
099. $batch[]=$result21["batch_name"];
100. $pd_ida[]=$result21["pd_id"];
101. $sum2[] = $result21["mrp"];
102.}
103.
104.$sql21 = "SELECT * FROM batch_detail2 where sc_id='".$_GET["sc_id"]."' and id='".$_GET["id"]."' GROUP BY date ";
105.$query3 = mysqli_query($conn,$sql21);
106.while($result3=mysqli_fetch_array($query3))
107.{
108. $bdate1[]=$result3["date"];
109.}
110. ?>
111.
112.
113. <?php
114. for($i=0;$i<count($batch);$i++){
115. ?>
116. <tr>
117. <td height="25"> <?php echo $pd_ida[$i]; ?></td>
118. <?php for($j1=0;$j1<count($bdate1);$j1++){
119.
120. $sql31 = "SELECT * FROM batch_detail2 WHERE `date`= '$bdate1[$j1]' AND `batch_name` = '$batch[$i]' AND sc_id='".$_GET["sc_id"]."' AND id='".$_GET["id"]."'";
121. $query31 = mysqli_query($conn,$sql31);
122. $result31 = mysqli_fetch_array($query31) ?>
123. <td height="25" style=" text-align: center;">
124. <?php echo number_format($result31['mrp']);?>
125. </td>
126. <?php } ?>
127.
128. </tr>
129. <?php } ?>
130.
131. </tbody>
132.</table>
133.
134.
135.</body>
136.
137.</html>
138. <?php
139.$html = ob_get_contents();
140.ob_end_clean();
141.$pdf = new mPDF('th', 'A4', '7', 'THSaraban');
142.$pdf->SetAutoFont();
143.$pdf->SetDisplayMode('fullpage');
144.$pdf->WriteHTML($html, 2);
145.$pdf->Output();
146.?>
