01.<?php
02.session_start();
03.require_once 'connect.php';
04.
05.$query_cartdone = "SELECT * FROM ordera as o, order_detaila as d,product as p, customer as c WHERE "
06. . " o.order_id=d.order_id AND d.pro_id=p.pro_id AND o.cus_id = c.cus_id ORDER BY o.order_date ASC";
07.$cartdone = mysqli_query($con, $query_cartdone) or die(mysqli_error());
08.$row_cartdone = mysqli_fetch_assoc($cartdone);
09.?>
10.<form action="add_payslip_db.php" method="post" enctype="multipart/form-data" name="formpay" id="formpay">
11. <table width="700" border="1" align="center" class="table">
12. <tr>
13. <td colspan="5" align="center"><strong>รายการสั่งซื้อล่าสุด คุณ<?php echo $row_cartdone['cus_name']; ?> <br />
14. <font color="red"> สถานะ :
15. <?php
16. $status = $row_cartdone['order_status'];
17. ?>
18. </font></strong></td>
19. </tr>
20. <tr>
21. <td colspan="5" align="center">
22. <table width="100%" border="0" cellspacing="0" cellpadding="0">
23. <tr>
24. <td width="59%"><strong><font color="red"><img src="image/<?php echo $row_cartdone['order_pay_slip']; ?>" width="300px"/></font></strong></td>
25. </tr>
26. </table>
27. </td>
28. </tr>
29. <tr class="success">
30. <td width="99" align="center">รหัส</td>
31. <td width="120" align="center">สินค้า</td>
32. <td width="118" align="center">ราคา</td>
33. <td width="238" align="center">จำนวน</td>
34. <td width="100" align="center">รวม</td>
35. </tr>
36. <?php
37. while ($row_cartdone = mysqli_fetch_assoc($cartdone)) {
38. ?>
39. <tr>
40. <td align = "center"><?php echo $row_cartdone['orderd_id']; ?></td>
41. <td><?php echo $row_cartdone['pro_name']; ?></td>
42. <td align="center"><?php echo $row_cartdone['orderd_price']; ?></td>
43. <td align="center"><?php echo $row_cartdone['orderd_quantity']; ?></td>
44. <td align="center"><?php echo number_format($row_cartdone['order_total'], 2); ?></td>
45. </tr>
46. <?php
47. $sum = $row_cartdone['orderd_price'] * $row_cartdone['orderd_quantity'];
48. $order_total += $sum;
49. ?>
50. <?php
51. }
52. ?>
53. <tr>
54. <td colspan="4" align="center">รวม</td>
55. <td align="center"><b> <?php echo number_format($order_total, 2); ?></b></td>
56. </tr>
57. </table>
58. <?php
59. if ($status > 1) {
60. } else {
61. ?>
62. <br /><br />
63. <p align="center"><br />
64. <button type="submit" name="add" class="btn btn-success"> บันทึก </button>
65. </p>
66. </form>
67.<?php
68. }
69.?>
70.<p> </p>
71.<p> </p>
72.</div>
73.</div>
74.</div>
