| Server IP : 147.93.80.58 / Your IP : 216.73.216.195 Web Server : LiteSpeed System : Linux id-dci-web1866.main-hosting.eu 5.14.0-503.38.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 18 08:52:10 EDT 2025 x86_64 User : u939086737 ( 939086737) PHP Version : 8.2.28 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u939086737/domains/aakashsolution.in/public_html/reports/ |
Upload File : |
<?php
session_start();
if(isset($_SESSION['user'])){
$role=$_SESSION['role'];
$user=$_SESSION['user'];
$shop=$_SESSION['shop'];
}
else{
header("Location:../index.php");
echo "<script>location='../index.php'</script>";
}
include_once "../action/class.php";
$obj=new database();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Payment Report</title>
<link href="../bootstrap/css/bootstrap.min.css" rel="stylesheet" />
<link href="../bootstrap/font-awesome-4.6.3/css/font-awesome.min.css" rel="stylesheet" />
<link href="../bootstrap/css/bootstrap.css" rel="stylesheet" media="screen" />
<style>
.sections{
float:left;
position:relative;
padding:5px 10px;
}
</style>
<script src="../bootstrap/js/jquery.js" type="text/javascript"></script>
</head>
<body>
<?php include "../header.php";?>
<div class="container">
<div class="row">
<?php
if(isset($_SESSION['msg'])){echo "<h4 class='text-success text-center'>".$_SESSION['msg']."</h4>"; unset($_SESSION['msg']);}
if(isset($_SESSION['err'])){echo "<h4 class='text-danger text-center'>".$_SESSION['err']."</h4>"; unset($_SESSION['err']);}
?>
<div class="col-md-2" style="margin-top:50px;">
<?php include('sidebar.php'); ?>
</div><!-- end of col-md-3 -->
<div class="col-md-10">
<center><font size="+2">Ledger</font></center><hr />
<ul class="nav nav-pills">
<li <?php if(!isset($_GET['spage'])){ echo 'class="active"'; } ?>><a data-toggle="pill" href="#customerDiv">Customer</a></li>
<!-- <li <?php if(isset($_GET['spage'])){ echo 'class="active"'; } ?>><a data-toggle="pill" href="#supplierDiv">Supplier</a></li> -->
</ul>
<div class="tab-content">
<div id="customerDiv" class="tab-pane fade <?php if(!isset($_GET['spage'])){ echo 'in active'; } ?>"><br />
<div class="row">
<div class="col-md-4">
<select id="customer" class="form-control" onchange="getCustData()">
<option value="">Select Customer</option>
<?php
$arr=$obj->get_rows("`customer`","`id`,`name`","`shop`='$shop'","`name`");
if(is_array($arr)){
foreach($arr as $customer){
?>
<option value="<?php echo $customer['id']; ?>" <?php if(isset($_GET['customer']) && $_GET['customer']==$customer['id']){echo "selected";} ?>>
<?php echo $customer['name']; ?>
</option>
<?php
}
}
?>
</select>
</div>
<div class="col-md-3">
<input type="date" class="form-control" id="from" onchange="getCustData();" value="<?php if(isset($_GET['from']))echo $_GET['from']; ?>" >
</div>
<div class="col-md-3">
<input type="date" class="form-control" id="to" onchange="getCustData();" value="<?php if(isset($_GET['to']))echo $_GET['to']; ?>" >
</div>
<div class="col-md-1">
<button type="button" class="btn btn-primary btn-sm" id="cexport"
style="padding:9px 13px; <?php if(!(isset($_GET['from']) && isset($_GET['to']) && $_GET['from']!='' && $_GET['to']!='')){echo "display:none;";}?>">
<i class="fa fa-download"></i></button>
</div>
</div><br />
<div class="row">
<div class="col-md-12" id="custlist">
<?php if(isset($_GET['page']) && trim($_GET['page'])!='')include("paycustlist2.php"); ?>
</div>
</div>
</div>
</div>
</div>
</div><!-- end of row -->
</div><!-- end of container -->
<script language="javascript">
var shop='<?php echo $shop; ?>';
$(document).ready(function(e) {
$('#cexport').click(function(){
var from=$('#from').val();
var to=$('#to').val();
var customer=$('#customer').val();
window.location="exportbs.php?from="+from+"&to="+to+"&shop="+shop+"&customer="+customer;
});
$('#sexport').click(function(){
var from=$('#sfrom').val();
var to=$('#sto').val();
var supplier=$('#supplier').val();
window.location="exportbs.php?from="+from+"&to="+to+"&shop="+shop+"&supplier="+supplier;
});
});
function getCustData(){
var customer=$('#customer').val();
var from=$('#from').val();
var to=$('#to').val();
if(from!='' && to!=''){ $('#cexport').show(); }
else{ $('#cexport').hide(); }
$.ajax({
type:"GET",
url:"paycustlist2.php",
data:{shop:shop,customer:customer,from:from,to:to},
success: function(data){
$('#custlist').html(data);
}
});
}
function getSupData(){
var supplier=$('#supplier').val();
var from=$('#sfrom').val();
var to=$('#sto').val();
if(from!='' && to!=''){ $('#sexport').show(); }
else{ $('#sexport').hide(); }
$.ajax({
type:"GET",
url:"paysuplist.php",
data:{shop:shop,supplier:supplier,sfrom:from,sto:to},
success: function(data){
$('#suplist').html(data);
}
});
}
</script>
<script src="../bootstrap/js/bootstrap.min.js" type="text/javascript"></script>
</body>
</html>