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 product.php
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354<?php require_once 'php_action/db_connect.php' ?><?php require_once 'includes/header.php'; ?>
<div class="row"> <div class="col-md-12">
<ol class="breadcrumb"> <li><a href="dashboard.php">Home</a></li> <li class="active">Product</li> </ol>
<div class="panel panel-default"> <div class="panel-heading"> <div class="page-heading"> <i class="glyphicon glyphicon-edit"></i> Manage Product</div> </div> <!-- /panel-heading --> <div class="panel-body">
<div class="remove-messages"></div>
<div class="div-action pull pull-right" style="padding-bottom:20px;"> <button class="btn btn-default button1" data-toggle="modal" id="addProductModalBtn" data-target="#addProductModal"> <i class="glyphicon glyphicon-plus-sign"></i> Add Product </button> </div> <!-- /div-action --> <table class="table" id="manageProductTable"> <thead> <tr> <th style="width:10%;">Photo</th> <th>Product Name</th> <th>Rate</th> <th>Quantity</th> <th>Brand</th> <th>Category</th> <th>Status</th> <th style="width:15%;">Options</th> </tr> </thead> </table> <!-- /table -->
</div> <!-- /panel-body --> </div> <!-- /panel --> </div> <!-- /col-md-12 --></div> <!-- /row -->
<!-- add product --><div class="modal fade" id="addProductModal" tabindex="-1" role="dialog"> <div class="modal-dialog"> <div class="modal-content">
<form class="form-horizontal" id="submitProductForm" action="php_action/createProduct.php" method="POST" enctype="multipart/form-data"> <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="fa fa-plus"></i> Add Product</h4> </div>
<div class="modal-body" style="max-height:450px; overflow:auto;">
<div id="add-product-messages"></div>
<div class="form-group"> <label for="productImage" class="col-sm-3 control-label">Product Image: </label> <label class="col-sm-1 control-label">: </label> <div class="col-sm-8"> <!-- the avatar markup --> <div id="kv-avatar-errors-1" class="center-block" style="display:none;"></div> <div class="kv-avatar center-block"> <input type="file" class="form-control" id="productImage" placeholder="Product Name" name="productImage" class="file-loading" style="width:auto;"/> </div> </div> </div> <!-- /form-group-->
<div class="form-group"> <label for="productName" class="col-sm-3 control-label">Product Name: </label> <label class="col-sm-1 control-label">: </label> <div class="col-sm-8"> <input type="text" class="form-control" id="productName" placeholder="Product Name" name="productName" autocomplete="off"> </div> </div> <!-- /form-group-->
<div class="form-group"> <label for="quantity" class="col-sm-3 control-label">Quantity: </label> <label class="col-sm-1 control-label">: </label> <div class="col-sm-8"> <input type="text" class="form-control" id="quantity" placeholder="Quantity" name="quantity" autocomplete="off"> </div> </div> <!-- /form-group-->
<div class="form-group"> <label for="rate" class="col-sm-3 control-label">Rate: </label> <label class="col-sm-1 control-label">: </label> <div class="col-sm-8"> <input type="text" class="form-control" id="rate" placeholder="Rate" name="rate" autocomplete="off"> </div> </div> <!-- /form-group-->
<div class="form-group"> <label for="brandName" class="col-sm-3 control-label">Brand Name: </label> <label class="col-sm-1 control-label">: </label> <div class="col-sm-8"> <select class="form-control" id="brandName" name="brandName"> <option value="">~~SELECT~~</option> <?php $sql = "SELECT brand_id, brand_name, brand_active, brand_status FROM brands WHERE brand_status = 1 AND brand_active = 1"; $result = $connect->query($sql);
while($row = $result->fetch_array()) { echo "<option value='".$row[0]."'>".$row[1]."</option>"; } // while ?> </select> </div> </div> <!-- /form-group-->
<div class="form-group"> <label for="categoryName" class="col-sm-3 control-label">Category Name: </label> <label class="col-sm-1 control-label">: </label> <div class="col-sm-8"> <select type="text" class="form-control" id="categoryName" placeholder="Product Name" name="categoryName" > <option value="">~~SELECT~~</option> <?php $sql = "SELECT categories_id, categories_name, categories_active, categories_status FROM categories WHERE categories_status = 1 AND categories_active = 1"; $result = $connect->query($sql);
while($row = $result->fetch_array()) { echo "<option value='".$row[0]."'>".$row[1]."</option>"; } // while ?> </select> </div> </div> <!-- /form-group-->
<div class="form-group"> <label for="productStatus" class="col-sm-3 control-label">Status: </label> <label class="col-sm-1 control-label">: </label> <div class="col-sm-8"> <select class="form-control" id="productStatus" name="productStatus"> <option value="">~~SELECT~~</option> <option value="1">Available</option> <option value="2">Not Available</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="submit" class="btn btn-primary" id="createProductBtn" data-loading-text="Loading..." autocomplete="off"> <i class="glyphicon glyphicon-ok-sign"></i> Save Changes</button> </div> <!-- /modal-footer --> </form> <!-- /.form --> </div> <!-- /modal-content --> </div> <!-- /modal-dailog --></div> <!-- /add categories -->
<!-- edit categories brand --><div class="modal fade" id="editProductModal" tabindex="-1" role="dialog"> <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="fa fa-edit"></i> Edit Product</h4> </div> <div class="modal-body" style="max-height:450px; overflow:auto;">
<div class="div-loading"> <i class="fa fa-spinner fa-pulse fa-3x fa-fw"></i> <span class="sr-only">Loading...</span> </div>
<div class="div-result">
<!-- Nav tabs --> <ul class="nav nav-tabs" role="tablist"> <li role="presentation" class="active"><a href="#photo" aria-controls="home" role="tab" data-toggle="tab">Photo</a></li> <li role="presentation"><a href="#productInfo" aria-controls="profile" role="tab" data-toggle="tab">Product Info</a></li> </ul>
<!-- Tab panes --> <div class="tab-content">
<div role="tabpanel" class="tab-pane active" id="photo"> <form action="php_action/editProductImage.php" method="POST" id="updateProductImageForm" class="form-horizontal" enctype="multipart/form-data">
<br /> <div id="edit-productPhoto-messages"></div>
<div class="form-group"> <label for="editProductImage" class="col-sm-3 control-label">Product Image: </label> <label class="col-sm-1 control-label">: </label> <div class="col-sm-8"> <img src="" id="getProductImage" class="thumbnail" style="width:250px; height:250px;" /> </div> </div> <!-- /form-group--> <div class="form-group"> <label for="editProductImage" class="col-sm-3 control-label">Select Photo: </label> <label class="col-sm-1 control-label">: </label> <div class="col-sm-8"> <!-- the avatar markup --> <div id="kv-avatar-errors-1" class="center-block" style="display:none;"></div> <div class="kv-avatar center-block"> <input type="file" class="form-control" id="editProductImage" placeholder="Product Name" name="editProductImage" class="file-loading" style="width:auto;"/> </div> </div> </div> <!-- /form-group-->
<div class="modal-footer editProductPhotoFooter"> <button type="button" class="btn btn-default" data-dismiss="modal"> <i class="glyphicon glyphicon-remove-sign"></i> Close</button> <!-- <button type="submit" class="btn btn-success" id="editProductImageBtn" data-loading-text="Loading..."> <i class="glyphicon glyphicon-ok-sign"></i> Save Changes</button> --> </div> <!-- /modal-footer --> </form> <!-- /form --> </div> <!-- product image --> <div role="tabpanel" class="tab-pane" id="productInfo"> <form class="form-horizontal" id="editProductForm" action="php_action/editProduct.php" method="POST"> <br />
<div id="edit-product-messages"></div>
<div class="form-group"> <label for="editProductName" class="col-sm-3 control-label">Product Name: </label> <label class="col-sm-1 control-label">: </label> <div class="col-sm-8"> <input type="text" class="form-control" id="editProductName" placeholder="Product Name" name="editProductName" autocomplete="off"> </div> </div> <!-- /form-group-->
<div class="form-group"> <label for="editQuantity" class="col-sm-3 control-label">Quantity: </label> <label class="col-sm-1 control-label">: </label> <div class="col-sm-8"> <input type="text" class="form-control" id="editQuantity" placeholder="Quantity" name="editQuantity" autocomplete="off"> </div> </div> <!-- /form-group-->
<div class="form-group"> <label for="editRate" class="col-sm-3 control-label">Rate: </label> <label class="col-sm-1 control-label">: </label> <div class="col-sm-8"> <input type="text" class="form-control" id="editRate" placeholder="Rate" name="editRate" autocomplete="off"> </div> </div> <!-- /form-group-->
<div class="form-group"> <label for="editBrandName" class="col-sm-3 control-label">Brand Name: </label> <label class="col-sm-1 control-label">: </label> <div class="col-sm-8"> <select class="form-control" id="editBrandName" name="editBrandName"> <option value="">~~SELECT~~</option> <?php $sql = "SELECT brand_id, brand_name, brand_active, brand_status FROM brands WHERE brand_status = 1 AND brand_active = 1"; $result = $connect->query($sql);
while($row = $result->fetch_array()) { echo "<option value='".$row[0]."'>".$row[1]."</option>"; } // while ?> </select> </div> </div> <!-- /form-group-->
<div class="form-group"> <label for="editCategoryName" class="col-sm-3 control-label">Category Name: </label> <label class="col-sm-1 control-label">: </label> <div class="col-sm-8"> <select type="text" class="form-control" id="editCategoryName" name="editCategoryName" > <option value="">~~SELECT~~</option> <?php $sql = "SELECT categories_id, categories_name, categories_active, categories_status FROM categories WHERE categories_status = 1 AND categories_active = 1"; $result = $connect->query($sql);
while($row = $result->fetch_array()) { echo "<option value='".$row[0]."'>".$row[1]."</option>"; } // while ?> </select> </div> </div> <!-- /form-group-->
<div class="form-group"> <label for="editProductStatus" class="col-sm-3 control-label">Status: </label> <label class="col-sm-1 control-label">: </label> <div class="col-sm-8"> <select class="form-control" id="editProductStatus" name="editProductStatus"> <option value="">~~SELECT~~</option> <option value="1">Available</option> <option value="2">Not Available</option> </select> </div> </div> <!-- /form-group-->
<div class="modal-footer editProductFooter"> <button type="button" class="btn btn-default" data-dismiss="modal"> <i class="glyphicon glyphicon-remove-sign"></i> Close</button> <button type="submit" class="btn btn-success" id="editProductBtn" data-loading-text="Loading..."> <i class="glyphicon glyphicon-ok-sign"></i> Save Changes</button> </div> <!-- /modal-footer --> </form> <!-- /.form --> </div> <!-- /product info --> </div>
</div> </div> <!-- /modal-body --> </div> <!-- /modal-content --> </div> <!-- /modal-dailog --></div><!-- /categories brand -->
<!-- categories brand --><div class="modal fade" tabindex="-1" role="dialog" id="removeProductModal"> <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 Product</h4> </div> <div class="modal-body">
<div class="removeProductMessages"></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="removeProductBtn" data-loading-text="Loading..."> <i class="glyphicon glyphicon-ok-sign"></i> Save changes</button> </div> </div><!-- /.modal-content --> </div><!-- /.modal-dialog --></div><!-- /.modal --><!-- /categories brand -->
<script src="custom/js/product.js"></script>
<?php require_once 'includes/footer.php'; ?>