<link rel="stylesheet" type="text/css" href="style_invoice.css"> <?php session_start(); //ini_set('display_errors', 1); //ini_set('display_startup_errors', 1); //error_reporting(E_ALL); include_once "db.php"; if(!empty($_GET['pg'])) {$pg=$_GET['pg'];} if(!empty($_POST['pg'])) {$pg=$_POST['pg'];} //echo $_GET['rec']; ?> <style> </style> <!-- Start Invoice Loop --> <?php $str="Select * From orders Where delivery_date = '0000-00-00' Order by `idorders`"; $qry = $pdo->prepare($str); $qry -> execute(); $rst = $qry->fetchAll(); //echo "ROWCOUNT='" . $qry ->rowCount() . "'"; //echo "TRAYS=" . $rst['order_date']; $cnt=1; foreach( $rst as $row ){ $str="Select * From customers Where idcustomers = " . $row['idcustomers']; $qry = $pdo->prepare($str); $qry -> execute(); $cst = $qry->fetch(); //echo "ROWCOUNT='" . $qry ->rowCount() . "'"; //echo "CST=" . $qry->rowCount() . "<br>"; //echo "CNT=" . $cnt; $cnt++; ?> <div class="logo">logo</div> <div class="gu"> Greens Unlimited <br> 1138 N Chestnut Ave. <br> Arlington Heights, Il 60004<br> (866) 512-2979 </div> <div class="container"> <div class="tbl_inv_list_hr"></div> <div style="text-align: right"></div> <div class="bill_to"> <span class="grays"><b>Bill To</b></span> <table class="tbl_bill_to"> <tr><td><?php echo $cst['business']; ?></td></tr> <tr><td><?php echo $cst['baddr']; ?></td></tr> <tr><td><?php echo $cst['bcity'] . ", " . $cst['bstate'] . " " . $cst['bzip']; ?></td></tr> <tr><td><?php echo "(" . substr($cst['bphone'],0,3) . ") " . substr($cst['bphone'],3,3) . " - " . substr($cst['bphone'],6,4); ?></td></tr> <tr><td><?php echo $cst['bemail']; ?></td></tr> </table> </div> <div class="invoice"> <table class="tbl_invoice"> <tr><td class="tbl_invoice_h">Invoice #:</td> <td class="tbl_invoice_l">123456789</td></tr> <tr><td class="tbl_invoice_h">Order Date:</td> <td class="tbl_invoice_l"><?php echo $row['order_date']; ?></td></tr> <tr><td class="tbl_invoice_h">Delivery Date:</td> <td class="tbl_invoice_l"><?php echo $row['delivery_date']; ?></td></tr> <tr><td class="tbl_invoice_h">Paid Date:</td> <td class="tbl_invoice_l"><?php echo $row['paid_date']; ?></td></tr> <tr><td class="tbl_invoice_h">Amount Due:</td> <td class="tbl_invoice_l">$<?php echo number_format($row['amount_due'],2); ?></td></tr> </table> </div> <div class="inv_list"> <table class="tbl_inv_list"> <tr><th class="inv_list_1" align=left >Items</th> <th class="inv_list_c">Quantity</th> <th class="inv_list_r">Price</th> <th class="inv_list_r">Amount</th></tr> <?php $total=0; if ($row['bibblettuce'] > 0) {?> <tr><td class="inv_list_1">Bibb Lettuce</td> <td class="inv_list_c"><?php echo $row['bibblettuce']; ?></td> <td class="inv_list_r">$<?php echo number_format($row['price_bibblettuce'],2); ?></td> <td class="inv_list_r">$<?php echo number_format($row['price_bibblettuce']*$row['bibblettuce'],2); ?></td></tr> <?php $total=$total + ($row['price_bibblettuce']*$row['bibblettuce']); } if ($row['wheatgrass'] > 0) {?> <tr><td class="inv_list_1">Wheatgrass</td> <td class="inv_list_c"><?php echo $row['wheatgrass']; ?></td> <td class="inv_list_r">$<?php echo number_format($row['price_wheatgrass'],2); ?></td> <td class="inv_list_r">$<?php echo number_format($row['price_wheatgrass']*$row['wheatgrass'],2); ?></td></tr> <?php $total=$total + ($row['price_wheatgrass']*$row['wheatgrass']); } if ($row['mg_hotandspicy'] > 0) {?> <tr><td class="inv_list_1">Microgreens: Hot & Spicy</td> <td class="inv_list_c"><?php echo $row['mg_hotandspicy']; ?></td> <td class="inv_list_r">$<?php echo number_format($row['price_mg_hotandspicy'],2); ?></td> <td class="inv_list_r">$<?php echo number_format($row['price_mg_hotandspicy']*$row['mg_hotandspicy'],2); ?></td></tr> <?php $total=$total + ($row['price_mg_hotandspicy']*$row['mg_hotandspicy']); }?> <tr><td colspan="4" class="tbl_inv_list_hr"></td></tr> <tr><td></td> <td class="inv_list_r">Tray Return:</td> <td class="inv_list_r"><?php echo $row['tray_returned']; ?></td> <td class="inv_list_r">$<?php echo $row['tray_returned']; ?> </td></tr> <?php $total = $total - $row['tray_returned']; ?> <tr><td colspan="3"></td><td class="tbl_inv_list_hr"></td></tr> <tr><td></td> <td class="inv_list_r"><b>Total Due:</b></td> <td></td> <td class="inv_list_r"><b>$<?php echo number_format($total, 2); ?></b></td></tr> </table> </div> <div style='page-break-before:always;'> </div> <?php flush(); } ?> <!-- End Invoice Loop -->