Something went wrong. Try again.
Open source inventory management system with php and mysql Invoice generation and easy to download invoice in PDF format Lightweight and ea…
Something went wrong. Try again.
php-inventory-management-system orders.php
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617<?php require_once 'php_action/db_connect.php'; require_once 'includes/header.php';
if($_GET['o'] == 'add') { // add order echo "<div class='div-request div-hide'>add</div>";} else if($_GET['o'] == 'manord') { echo "<div class='div-request div-hide'>manord</div>";} else if($_GET['o'] == 'editOrd') { echo "<div class='div-request div-hide'>editOrd</div>";} // /else manage order
?>
<ol class="breadcrumb"> <li><a href="dashboard.php">Home</a></li> <li>Order</li> <li class="active"> <?php if($_GET['o'] == 'add') { ?> Add Order <?php } else if($_GET['o'] == 'manord') { ?> Manage Order <?php } // /else manage order ?> </li></ol>
<h4> <i class='glyphicon glyphicon-circle-arrow-right'></i> <?php if($_GET['o'] == 'add') { echo "Add Order"; } else if($_GET['o'] == 'manord') { echo "Manage Order"; } else if($_GET['o'] == 'editOrd') { echo "Edit Order"; } ?> </h4>
<div class="panel panel-default"> <div class="panel-heading">
<?php if($_GET['o'] == 'add') { ?> <i class="glyphicon glyphicon-plus-sign"></i> Add Order <?php } else if($_GET['o'] == 'manord') { ?> <i class="glyphicon glyphicon-edit"></i> Manage Order <?php } else if($_GET['o'] == 'editOrd') { ?> <i class="glyphicon glyphicon-edit"></i> Edit Order <?php } ?>
</div> <!--/panel--> <div class="panel-body"> <?php if($_GET['o'] == 'add') { // add order ?>
<div class="success-messages"></div> <!--/success-messages-->
<form class="form-horizontal" method="POST" action="php_action/createOrder.php" id="createOrderForm">
<div class="form-group"> <label for="orderDate" class="col-sm-2 control-label">Order Date</label> <div class="col-sm-10"> <input type="text" class="form-control" id="orderDate" name="orderDate" autocomplete="off" /> </div> </div> <!--/form-group--> <div class="form-group"> <label for="clientName" class="col-sm-2 control-label">Client Name</label> <div class="col-sm-10"> <input type="text" class="form-control" id="clientName" name="clientName" placeholder="Client Name" autocomplete="off" /> </div> </div> <!--/form-group--> <div class="form-group"> <label for="clientContact" class="col-sm-2 control-label">Client Contact</label> <div class="col-sm-10"> <input type="text" class="form-control" id="clientContact" name="clientContact" placeholder="Contact Number" autocomplete="off" /> </div> </div> <!--/form-group-->
<table class="table" id="productTable"> <thead> <tr> <th style="width:40%;">Product</th> <th style="width:20%;">Rate</th> <th style="width:10%;">Available Quantity</th> <th style="width:15%;">Quantity</th> <th style="width:25%;">Total</th> <th style="width:10%;"></th> </tr> </thead> <tbody> <?php $arrayNumber = 0; for($x = 1; $x < 2; $x++) { ?> <tr id="row<?php echo $x; ?>" class="<?php echo $arrayNumber; ?>"> <td style="margin-left:20px;"> <div class="form-group">
<select class="form-control" name="productName[]" id="productName<?php echo $x; ?>" onchange="getProductData(<?php echo $x; ?>)" > <option value="">~~SELECT~~</option> <?php $productSql = "SELECT * FROM product WHERE active = 1 AND status = 1 AND quantity != 0"; $productData = $connect->query($productSql);
while($row = $productData->fetch_array()) { echo "<option value='".$row['product_id']."' id='changeProduct".$row['product_id']."'>".$row['product_name']."</option>"; } // /while
?> </select> </div> </td> <td style="padding-left:20px;"> <input type="text" name="rate[]" id="rate<?php echo $x; ?>" autocomplete="off" disabled="true" class="form-control" /> <input type="hidden" name="rateValue[]" id="rateValue<?php echo $x; ?>" autocomplete="off" class="form-control" /> </td> <td style="padding-left:20px;"> <div class="form-group"> <p id="available_quantity<?php echo $x; ?>"></p> </div> </td> <td style="padding-left:20px;"> <div class="form-group"> <input type="number" name="quantity[]" id="quantity<?php echo $x; ?>" onkeyup="getTotal(<?php echo $x ?>)" autocomplete="off" class="form-control" min="1" /> </div> </td> <td style="padding-left:20px;"> <input type="text" name="total[]" id="total<?php echo $x; ?>" autocomplete="off" class="form-control" disabled="true" /> <input type="hidden" name="totalValue[]" id="totalValue<?php echo $x; ?>" autocomplete="off" class="form-control" /> </td> <td>
<button class="btn btn-default removeProductRowBtn" type="button" id="removeProductRowBtn" onclick="removeProductRow(<?php echo $x; ?>)"><i class="glyphicon glyphicon-trash"></i></button> </td> </tr> <?php $arrayNumber++; } // /for ?> </tbody> </table>
<div class="col-md-6"> <div class="form-group"> <label for="subTotal" class="col-sm-3 control-label">Sub Amount</label> <div class="col-sm-9"> <input type="text" class="form-control" id="subTotal" name="subTotal" disabled="true" /> <input type="hidden" class="form-control" id="subTotalValue" name="subTotalValue" /> </div> </div> <!--/form-group--> <!--/form-group--> <div class="form-group"> <label for="totalAmount" class="col-sm-3 control-label">Total Amount</label> <div class="col-sm-9"> <input type="text" class="form-control" id="totalAmount" name="totalAmount" disabled="true"/> <input type="hidden" class="form-control" id="totalAmountValue" name="totalAmountValue" /> </div> </div> <!--/form-group--> <div class="form-group"> <label for="discount" class="col-sm-3 control-label">Discount</label> <div class="col-sm-9"> <input type="text" class="form-control" id="discount" name="discount" onkeyup="discountFunc()" autocomplete="off" /> </div> </div> <!--/form-group--> <div class="form-group"> <label for="grandTotal" class="col-sm-3 control-label">Grand Total</label> <div class="col-sm-9"> <input type="text" class="form-control" id="grandTotal" name="grandTotal" disabled="true" /> <input type="hidden" class="form-control" id="grandTotalValue" name="grandTotalValue" /> </div> </div> <!--/form-group--> <div class="form-group"> <label for="vat" class="col-sm-3 control-label gst">GST 18%</label> <div class="col-sm-9"> <input type="text" class="form-control" id="vat" name="gstn" readonly="true" /> <input type="hidden" class="form-control" id="vatValue" name="vatValue" /> </div> </div> </div> <!--/col-md-6-->
<div class="col-md-6"> <div class="form-group"> <label for="paid" class="col-sm-3 control-label">Paid Amount</label> <div class="col-sm-9"> <input type="text" class="form-control" id="paid" name="paid" autocomplete="off" onkeyup="paidAmount()" /> </div> </div> <!--/form-group--> <div class="form-group"> <label for="due" class="col-sm-3 control-label">Due Amount</label> <div class="col-sm-9"> <input type="text" class="form-control" id="due" name="due" disabled="true" /> <input type="hidden" class="form-control" id="dueValue" name="dueValue" /> </div> </div> <!--/form-group--> <div class="form-group"> <label for="clientContact" class="col-sm-3 control-label">Payment Type</label> <div class="col-sm-9"> <select class="form-control" name="paymentType" id="paymentType"> <option value="">~~SELECT~~</option> <option value="1">Cheque</option> <option value="2">Cash</option> <option value="3">Credit Card</option> </select> </div> </div> <!--/form-group--> <div class="form-group"> <label for="clientContact" class="col-sm-3 control-label">Payment Status</label> <div class="col-sm-9"> <select class="form-control" name="paymentStatus" id="paymentStatus"> <option value="">~~SELECT~~</option> <option value="1">Full Payment</option> <option value="2">Advance Payment</option> <option value="3">No Payment</option> </select> </div> </div> <!--/form-group--> <div class="form-group"> <label for="clientContact" class="col-sm-3 control-label">Payment Place</label> <div class="col-sm-9"> <select class="form-control" name="paymentPlace" id="paymentPlace"> <option value="">~~SELECT~~</option> <option value="1">In Gujarat</option> <option value="2">Out Of Gujarat</option> </select> </div> </div> <!--/form-group--> </div> <!--/col-md-6-->
<div class="form-group submitButtonFooter"> <div class="col-sm-offset-2 col-sm-10"> <button type="button" class="btn btn-default" onclick="addRow()" id="addRowBtn" data-loading-text="Loading..."> <i class="glyphicon glyphicon-plus-sign"></i> Add Row </button>
<button type="submit" id="createOrderBtn" data-loading-text="Loading..." class="btn btn-success"><i class="glyphicon glyphicon-ok-sign"></i> Save Changes</button>
<button type="reset" class="btn btn-default" onclick="resetOrderForm()"><i class="glyphicon glyphicon-erase"></i> Reset</button> </div> </div> </form> <?php } else if($_GET['o'] == 'manord') { // manage order ?>
<div id="success-messages"></div> <table class="table" id="manageOrderTable"> <thead> <tr> <th>#</th> <th>Order Date</th> <th>Client Name</th> <th>Contact</th> <th>Total Order Item</th> <th>Payment Status</th> <th>Option</th> </tr> </thead> </table>
<?php // /else manage order } else if($_GET['o'] == 'editOrd') { // get order ?> <div class="success-messages"></div> <!--/success-messages-->
<form class="form-horizontal" method="POST" action="php_action/editOrder.php" id="editOrderForm">
<?php $orderId = $_GET['i'];
$sql = "SELECT orders.order_id, orders.order_date, orders.client_name, orders.client_contact, orders.sub_total, orders.vat, orders.total_amount, orders.discount, orders.grand_total, orders.paid, orders.due, orders.payment_type, orders.payment_status,orders.payment_place,orders.gstn FROM orders WHERE orders.order_id = {$orderId}";
$result = $connect->query($sql); $data = $result->fetch_row(); ?>
<div class="form-group"> <label for="orderDate" class="col-sm-2 control-label">Order Date</label> <div class="col-sm-10"> <input type="text" class="form-control" id="orderDate" name="orderDate" autocomplete="off" value="<?php echo $data[1] ?>" /> </div> </div> <!--/form-group--> <div class="form-group"> <label for="clientName" class="col-sm-2 control-label">Client Name</label> <div class="col-sm-10"> <input type="text" class="form-control" id="clientName" name="clientName" placeholder="Client Name" autocomplete="off" value="<?php echo $data[2] ?>" /> </div> </div> <!--/form-group--> <div class="form-group"> <label for="clientContact" class="col-sm-2 control-label">Client Contact</label> <div class="col-sm-10"> <input type="text" class="form-control" id="clientContact" name="clientContact" placeholder="Contact Number" autocomplete="off" value="<?php echo $data[3] ?>" /> </div> </div> <!--/form-group-->
<table class="table" id="productTable"> <thead> <tr> <th style="width:40%;">Product</th> <th style="width:20%;">Rate</th> <th style="width:15%;">Available Quantity</th> <th style="width:15%;">Quantity</th> <th style="width:15%;">Total</th> <th style="width:10%;"></th> </tr> </thead> <tbody> <?php
$orderItemSql = "SELECT order_item.order_item_id, order_item.order_id, order_item.product_id, order_item.quantity, order_item.rate, order_item.total FROM order_item WHERE order_item.order_id = {$orderId}"; $orderItemResult = $connect->query($orderItemSql); // $orderItemData = $orderItemResult->fetch_all(); // print_r($orderItemData); $arrayNumber = 0; // for($x = 1; $x <= count($orderItemData); $x++) { $x = 1; while($orderItemData = $orderItemResult->fetch_array()) { // print_r($orderItemData); ?> <tr id="row<?php echo $x; ?>" class="<?php echo $arrayNumber; ?>"> <td style="margin-left:20px;"> <div class="form-group">
<select class="form-control" name="productName[]" id="productName<?php echo $x; ?>" onchange="getProductData(<?php echo $x; ?>)" > <option value="">~~SELECT~~</option> <?php $productSql = "SELECT * FROM product WHERE active = 1 AND status = 1 AND quantity != 0"; $productData = $connect->query($productSql);
while($row = $productData->fetch_array()) { $selected = ""; if($row['product_id'] == $orderItemData['product_id']) { $selected = "selected"; } else { $selected = ""; }
echo "<option value='".$row['product_id']."' id='changeProduct".$row['product_id']."' ".$selected." >".$row['product_name']."</option>"; } // /while
?> </select> </div> </td> <td style="padding-left:20px;"> <input type="text" name="rate[]" id="rate<?php echo $x; ?>" autocomplete="off" disabled="true" class="form-control" value="<?php echo $orderItemData['rate']; ?>" /> <input type="hidden" name="rateValue[]" id="rateValue<?php echo $x; ?>" autocomplete="off" class="form-control" value="<?php echo $orderItemData['rate']; ?>" /> </td> <td style="padding-left:20px;"> <div class="form-group"> <?php $productSql = "SELECT * FROM product WHERE active = 1 AND status = 1 AND quantity != 0"; $productData = $connect->query($productSql);
while($row = $productData->fetch_array()) { $selected = ""; if($row['product_id'] == $orderItemData['product_id']) { echo "<p id='available_quantity".$row['product_id']."'>".$row['quantity']."</p>"; } else { $selected = ""; }
//echo "<option value='".$row['product_id']."' id='changeProduct".$row['product_id']."' ".$selected." >".$row['product_name']."</option>"; } // /while
?> </div> </td> <td style="padding-left:20px;"> <div class="form-group"> <input type="number" name="quantity[]" id="quantity<?php echo $x; ?>" onkeyup="getTotal(<?php echo $x ?>)" autocomplete="off" class="form-control" min="1" value="<?php echo $orderItemData['quantity']; ?>" /> </div> </td> <td style="padding-left:20px;"> <input type="text" name="total[]" id="total<?php echo $x; ?>" autocomplete="off" class="form-control" disabled="true" value="<?php echo $orderItemData['total']; ?>"/> <input type="hidden" name="totalValue[]" id="totalValue<?php echo $x; ?>" autocomplete="off" class="form-control" value="<?php echo $orderItemData['total']; ?>"/> </td> <td>
<button class="btn btn-default removeProductRowBtn" type="button" id="removeProductRowBtn" onclick="removeProductRow(<?php echo $x; ?>)"><i class="glyphicon glyphicon-trash"></i></button> </td> </tr> <?php $arrayNumber++; $x++; } // /for ?> </tbody> </table>
<div class="col-md-6"> <div class="form-group"> <label for="subTotal" class="col-sm-3 control-label">Sub Amount</label> <div class="col-sm-9"> <input type="text" class="form-control" id="subTotal" name="subTotal" disabled="true" value="<?php echo $data[4] ?>" /> <input type="hidden" class="form-control" id="subTotalValue" name="subTotalValue" value="<?php echo $data[4] ?>" /> </div> </div> <!--/form-group--> <div class="form-group"> <label for="totalAmount" class="col-sm-3 control-label">Total Amount</label> <div class="col-sm-9"> <input type="text" class="form-control" id="totalAmount" name="totalAmount" disabled="true" value="<?php echo $data[6] ?>" /> <input type="hidden" class="form-control" id="totalAmountValue" name="totalAmountValue" value="<?php echo $data[6] ?>" /> </div> </div> <!--/form-group--> <div class="form-group"> <label for="discount" class="col-sm-3 control-label">Discount</label> <div class="col-sm-9"> <input type="text" class="form-control" id="discount" name="discount" onkeyup="discountFunc()" autocomplete="off" value="<?php echo $data[7] ?>" /> </div> </div> <!--/form-group--> <div class="form-group"> <label for="grandTotal" class="col-sm-3 control-label">Grand Total</label> <div class="col-sm-9"> <input type="text" class="form-control" id="grandTotal" name="grandTotal" disabled="true" value="<?php echo $data[8] ?>" /> <input type="hidden" class="form-control" id="grandTotalValue" name="grandTotalValue" value="<?php echo $data[8] ?>" /> </div> </div> <!--/form-group--> <div class="form-group"> <label for="vat" class="col-sm-3 control-label gst"><?php if($data[13] == 2) {echo "IGST 18%";} else echo "GST 18%"; ?></label> <div class="col-sm-9"> <input type="text" class="form-control" id="vat" name="vat" disabled="true" value="<?php echo $data[5] ?>" /> <input type="hidden" class="form-control" id="vatValue" name="vatValue" value="<?php echo $data[5] ?>" /> </div> </div> <div class="form-group"> <label for="gstn" class="col-sm-3 control-label gst">G.S.T.IN</label> <div class="col-sm-9"> <input type="text" class="form-control" id="gstn" name="gstn" value="<?php echo $data[14] ?>" /> </div> </div><!--/form-group--> </div> <!--/col-md-6-->
<div class="col-md-6"> <div class="form-group"> <label for="paid" class="col-sm-3 control-label">Paid Amount</label> <div class="col-sm-9"> <input type="text" class="form-control" id="paid" name="paid" autocomplete="off" onkeyup="paidAmount()" value="<?php echo $data[9] ?>" /> </div> </div> <!--/form-group--> <div class="form-group"> <label for="due" class="col-sm-3 control-label">Due Amount</label> <div class="col-sm-9"> <input type="text" class="form-control" id="due" name="due" disabled="true" value="<?php echo $data[10] ?>" /> <input type="hidden" class="form-control" id="dueValue" name="dueValue" value="<?php echo $data[10] ?>" /> </div> </div> <!--/form-group--> <div class="form-group"> <label for="clientContact" class="col-sm-3 control-label">Payment Type</label> <div class="col-sm-9"> <select class="form-control" name="paymentType" id="paymentType" > <option value="">~~SELECT~~</option> <option value="1" <?php if($data[11] == 1) { echo "selected"; } ?> >Cheque</option> <option value="2" <?php if($data[11] == 2) { echo "selected"; } ?> >Cash</option> <option value="3" <?php if($data[11] == 3) { echo "selected"; } ?> >Credit Card</option> </select> </div> </div> <!--/form-group--> <div class="form-group"> <label for="clientContact" class="col-sm-3 control-label">Payment Status</label> <div class="col-sm-9"> <select class="form-control" name="paymentStatus" id="paymentStatus"> <option value="">~~SELECT~~</option> <option value="1" <?php if($data[12] == 1) { echo "selected"; } ?> >Full Payment</option> <option value="2" <?php if($data[12] == 2) { echo "selected"; } ?> >Advance Payment</option> <option value="3" <?php if($data[10] == 3) { echo "selected"; } ?> >No Payment</option> </select> </div> </div> <!--/form-group--> <div class="form-group"> <label for="clientContact" class="col-sm-3 control-label">Payment Place</label> <div class="col-sm-9"> <select class="form-control" name="paymentPlace" id="paymentPlace"> <option value="">~~SELECT~~</option> <option value="1" <?php if($data[13] == 1) { echo "selected"; } ?> >In Gujarat</option> <option value="2" <?php if($data[13] == 2) { echo "selected"; } ?> >Out Gujarat</option> </select> </div> </div> </div> <!--/col-md-6-->
<div class="form-group editButtonFooter"> <div class="col-sm-offset-2 col-sm-10"> <button type="button" class="btn btn-default" onclick="addRow()" id="addRowBtn" data-loading-text="Loading..."> <i class="glyphicon glyphicon-plus-sign"></i> Add Row </button>
<input type="hidden" name="orderId" id="orderId" value="<?php echo $_GET['i']; ?>" />
<button type="submit" id="editOrderBtn" data-loading-text="Loading..." class="btn btn-success"><i class="glyphicon glyphicon-ok-sign"></i> Save Changes</button> </div> </div> </form>
<?php } // /get order else ?>
</div> <!--/panel--> </div> <!--/panel-->
<!-- edit order --><div class="modal fade" tabindex="-1" role="dialog" id="paymentOrderModal"> <div class="modal-dialog modal-lg"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button> <h4 class="modal-title"><i class="glyphicon glyphicon-edit"></i> Edit Payment</h4> </div>
<div class="modal-body form-horizontal" style="max-height:500px; overflow:auto;" >
<div class="paymentOrderMessages"></div>
<div class="form-group"> <label for="due" class="col-sm-3 control-label">Due Amount</label> <div class="col-sm-9"> <input type="text" class="form-control" id="due" name="due" disabled="true" /> </div> </div> <!--/form-group--> <div class="form-group"> <label for="payAmount" class="col-sm-3 control-label">Pay Amount</label> <div class="col-sm-9"> <input type="text" class="form-control" id="payAmount" name="payAmount"/> </div> </div> <!--/form-group--> <div class="form-group"> <label for="clientContact" class="col-sm-3 control-label">Payment Type</label> <div class="col-sm-9"> <select class="form-control" name="paymentType" id="paymentType" > <option value="">~~SELECT~~</option> <option value="1">Cheque</option> <option value="2">Cash</option> <option value="3">Credit Card</option> </select> </div> </div> <!--/form-group--> <div class="form-group"> <label for="clientContact" class="col-sm-3 control-label">Payment Status</label> <div class="col-sm-9"> <select class="form-control" name="paymentStatus" id="paymentStatus"> <option value="">~~SELECT~~</option> <option value="1">Full Payment</option> <option value="2">Advance Payment</option> <option value="3">No Payment</option> </select> </div> </div> <!--/form-group--> </div> <!--/modal-body--> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal"> <i class="glyphicon glyphicon-remove-sign"></i> Close</button> <button type="button" class="btn btn-primary" id="updatePaymentOrderBtn" data-loading-text="Loading..."> <i class="glyphicon glyphicon-ok-sign"></i> Save changes</button> </div> </div><!-- /.modal-content --> </div><!-- /.modal-dialog --></div><!-- /.modal --><!-- /edit order-->
<!-- remove order --><div class="modal fade" tabindex="-1" role="dialog" id="removeOrderModal"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button> <h4 class="modal-title"><i class="glyphicon glyphicon-trash"></i> Remove Order</h4> </div> <div class="modal-body">
<div class="removeOrderMessages"></div>
<p>Do you really want to remove ?</p> </div> <div class="modal-footer removeProductFooter"> <button type="button" class="btn btn-default" data-dismiss="modal"> <i class="glyphicon glyphicon-remove-sign"></i> Close</button> <button type="button" class="btn btn-primary" id="removeOrderBtn" data-loading-text="Loading..."> <i class="glyphicon glyphicon-ok-sign"></i> Save changes</button> </div> </div><!-- /.modal-content --> </div><!-- /.modal-dialog --></div><!-- /.modal --><!-- /remove order-->
<script src="custom/js/order.js"></script>
<?php require_once 'includes/footer.php'; ?>