file missing
delete.php is missing from source friend
<h2 align="center">Simple Ordering System with Cash as Method of Payment and Receipt Report</h2><hr> <form action="incoming.php" method="post" align="right"> <input type="hidden" name="pt" value="<?php echo $_GET['id']; ?>" /> <input type="hidden" name="invoice" value="<?php echo $_GET['invoice']; ?>" /> <select name="product" style="width: 300px; height: 36px;"> <?php include('../connect.php'); $result = $db->prepare("SELECT * FROM products"); $result->bindParam(':userid', $res); $result->execute(); for($i=0; $row = $result->fetch(); $i++){ ?> <option value="<?php echo $row['product_code']; ?>"><?php echo $row['product_name']; ?></option> <?php } ?> </select> <input type="text" name="qty" value="" placeholder="Quantity" autocomplete="off" style="width: 68px; padding-top: 6px; padding-bottom: 6px; margin-right: 4px;" /> <input type="text" name="discount" value="" placeholder="Discount" autocomplete="off" style="width: 68px; padding-top: 6px; padding-bottom: 6px; margin-right: 4px;" /> <input type="submit" class="btn btn-primary" value="Save" /> </form> <table id="resultTable" data-responsive="table" class="table table-hover"> <thead> <tr> <th> Product Code </th> <th> Product Name </th> <th> Qty </th> <th> Price </th> <th> Discount </th> <th> Amount </th> <th> Action </th> </tr> </thead> <tbody> <?php $id=$_GET['invoice']; include('../connect.php'); $result = $db->prepare("SELECT * FROM sales_order WHERE invoice= :userid"); $result->bindParam(':userid', $id); $result->execute(); for($i=0; $row = $result->fetch(); $i++){ ?> <tr class="record"> <td><?php echo $row['product']; ?></td> <td><?php echo $row['name']; ?></td> <td><?php echo $row['qty']; ?></td> <td> <?php $ppp=$row['price']; echo formatMoney($ppp, true); ?> </td> <td> <?php $ddd=$row['discount']; echo formatMoney($ddd, true); ?> </td> <td> <?php $dfdf=$row['amount']; echo formatMoney($dfdf, true); ?> </td> <td><a href="delete.php?id=<?php echo $row['transaction_id']; ?>&invoice=<?php echo $_GET['invoice']; ?>&dle=<?php echo $_GET['id']; ?>&qty=<?php echo $row['qty'];?>&code=<?php echo $row['product'];?>" class="btn btn-primary">Delete</a></td> </tr> <?php } ?> <tr> <td colspan="5"><strong style="font-size: 20px; color: #222222;">Total:</strong></td> <td colspan="2"><strong style="font-size: 20px; color: #222222; background-color: bisque;"> <?php function formatMoney($number, $fractional=false) { if ($fractional) { } while (true) { if ($replaced != $number) { $number = $replaced; } else { break; } } return $number; } $sdsd=$_GET['invoice']; $resultas = $db->prepare("SELECT sum(amount) FROM sales_order WHERE invoice= :a"); $resultas->bindParam(':a', $sdsd); $resultas->execute(); for($i=0; $rowas = $resultas->fetch(); $i++){ $fgfg=$rowas['sum(amount)']; echo formatMoney($fgfg, true); } ?> </strong></td> </tr> </tbody> </table><br> <a rel="facebox" id="cccc" href="checkout.php?pt=<?php echo $_GET['id']?>&invoice=<?php echo $_GET['invoice']?>&total=<?php echo $fgfg ?>&cashier=<?php echo $_SESSION['SESS_FIRST_NAME']?>" class="btn btn-primary">Check Out</a>
<h2 align="center">Simple Ordering System with Cash as Method of Payment and Receipt Report</h2><hr> <form align="right"> <input type="text" name="filter" value="" id="filter" placeholder="Search Product..." autocomplete="off" style="width: 250px; padding-top: 6px; padding-bottom: 6px; margin-right: 4px;"/><a rel="facebox" id="addd" href="addproduct.php" class="btn btn-primary">Add Product</a><br><br> </form> <table id="resultTable" data-responsive="table" class="table table-hover"> <thead> <tr> <th> Code </th> <th> Name </th> <th> Cost </th> <th> Price </th> <th> Qty </th> <th> Action </th> </tr> </thead> <tbody> <?php function formatMoney($number, $fractional=false) { if ($fractional) { } while (true) { if ($replaced != $number) { $number = $replaced; } else { break; } } return $number; } include('../connect.php'); $result = $db->prepare("SELECT * FROM products ORDER BY product_id DESC"); $result->execute(); for($i=0; $row = $result->fetch(); $i++){ ?> <tr class="record"> <td><?php echo $row['product_code']; ?></td> <td><?php echo $row['product_name']; ?></td> <td><?php $pcost=$row['cost']; echo formatMoney($pcost, true); ?></td> <td><?php $pprice=$row['price']; echo formatMoney($pprice, true); ?></td> <td><?php echo $row['qty']; ?></td> <td><a rel="facebox" href="editproduct.php?id=<?php echo $row['product_id']; ?>" class="btn btn-primary">Edit</a> <a href="#" id="<?php echo $row['product_id']; ?>" class="delbutton" title="Click To Delete" style="margin-bottom: 0;border-radius: 4px;border: 1px solid transparent;padding: 6px 12px;display: inline-block;color: #fff; background-color: #337ab7; border-color: #2e6da4;">Delete</a></td> </tr> <?php } ?> </tbody> </table> </div> <script type="text/javascript"> $(function() { $(".delbutton").click(function(){ var element = $(this); var del_id = element.attr("id"); var info = 'id=' + del_id; if(confirm("Are you sure do you want to delete this product? There is no Undo.")) { $.ajax({ type: "GET", url: "deleteproduct.php", data: info, success: function(){ } }); $(this).parents(".record").animate({ backgroundColor: "#fbc7c7" }, "fast") .animate({ opacity: "hide" }, "slow"); } return false; }); }); </script>
<?php $id=$_GET['invoice']; $result = $db->prepare("SELECT * FROM sales_order WHERE invoice= :userid"); $result->bindParam(':userid', $id); $result->execute(); for($i=0; $row = $result->fetch(); $i++){ ?> <tr class="record"> <td><?php echo $row['product']; ?></td> <td><?php echo $row['name']; ?></td> <td><?php echo $row['qty']; ?></td> <td> <?php $ppp=$row['price']; echo formatMoney($ppp, true); ?> </td> <td> <?php $ddd=$row['discount']; echo formatMoney($ddd, true); ?> </td> <td> <?php $dfdf=$row['amount']; echo formatMoney($dfdf, true); ?> </td> </tr> <?php } ?> <tr> <td colspan="5"><strong style="font-size: 12px; color: #222222;">Total:</strong></td> <td colspan="2"><strong style="font-size: 12px; color: #222222;"> <?php $sdsd=$_GET['invoice']; $resultas = $db->prepare("SELECT sum(amount) FROM sales_order WHERE invoice= :a"); $resultas->bindParam(':a', $sdsd); $resultas->execute(); for($i=0; $rowas = $resultas->fetch(); $i++){ $fgfg=$rowas['sum(amount)']; echo formatMoney($fgfg, true); } ?> </strong></td> </tr> <?php if($pt=='cash'){ ?> <tr> <td colspan="5"><strong style="font-size: 12px; color: #222222;">Cash Tendered:</strong></td> <td colspan="2"><strong style="font-size: 12px; color: #222222;"> <?php echo formatMoney($cash, true); ?> </strong></td> </tr> <?php } ?> <tr> <td colspan="5"><strong style="font-size: 12px; color: #222222;"> <?php if($pt=='cash'){ echo 'Change:'; } ?> </strong></td> <td colspan="2"><strong style="font-size: 12px; color: #222222;"> <?php function formatMoney($number, $fractional=false) { if ($fractional) { } while (true) { if ($replaced != $number) { $number = $replaced; } else { break; } } return $number; } if($pt=='credit'){ echo $cash; } if($pt=='cash'){ echo formatMoney($amount, true); } ?>
<script language="javascript"> function Clickheretoprint() { var disp_setting="toolbar=yes,location=no,directories=yes,menubar=yes,"; disp_setting+="scrollbars=yes,width=800, height=400, left=100, top=25"; var content_vlue = document.getElementById("content").innerHTML; var docprint=window.open("","",disp_setting); docprint.document.open(); docprint.document.write('</head><body onLoad="self.print()" style="width: 800px; font-size: 13px; font-family: arial;">'); docprint.document.write(content_vlue); docprint.document.close(); docprint.focus(); } </script> <div align="center"> <a href="javascript:Clickheretoprint()" style="font-size:12px" class="btn btn-primary";>Print</a> <a href="index.php" style="font-size:12px" class="btn btn-primary";>Back</a> </div>