| 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();
include_once "../action/class.php";
$shop = $_SESSION['shop'];
$customer = $_GET['customer_id'];
$from = $_GET['from'];
$to = $_GET['to'];
$obj = new database();
$shop_details = $obj->get_details("`shop`", "*", "`id`='$shop'");
$cust = $obj->get_details("`customer`", "*", "`id`='$customer'");
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title><?= $cust['name'] . '-' . $from . '-' . $to ?></title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.css" integrity="sha512-5A8nwdMOWrSz20fDsjczgUidUBR8liPYU+WymTZP1lmY9G6Oc7HlZv156XqnsgNUzTyMefFTcsFH/tnJE/+xBg==" crossorigin="anonymous" referrerpolicy="no-referrer" />
<style>
@media print {
.no-print {
display: none;
}
}
</style>
</head>
<body>
<div class="container">
<div class="row">
<div class="col-12">
<center>
<font size="+3" style="letter-spacing:2px"><?php echo strtoupper($shop_details['name']); ?><br /></font>
<?php echo "Lower Chutia, Ranchi-834001 " ?><br />
Ph : <?php echo $shop_details['phone']; ?><br />
<?php if ($shop_details['gst'] != '') {
echo "GSTIN - " . $shop_details['gst'];
} ?>
</font><br />
</center>
<hr class="my-1 py-0">
</div>
<div class="col-12">
<center>
<h4><?= $cust['name'] ?></h4>
<p class="py-0 my-0"><?= $cust['address'] ?></p>
<p class="py-0 my-0"><?= $cust['phone'] . ', ' . $cust['email'] ?>, GSTIN: <?= $cust['gst'] ?></p>
</center>
</div>
<div class="col-12 text-center border ">
<span style="font-weight: 600; color: blue;">from: <?= date('d-m-Y', strtotime($from)) . ' to ' . date('d-m-Y', strtotime($to)) ?></span>
</div>
</div>
<table class="table" id="c_list" style="width:95%;">
<thead>
<tr>
<th style="text-align:center">Sl. No.</th>
<th style="text-align:center">Date</th>
<th style="text-align:center">Particulars</th>
<th style="text-align:center">Vch Type</th>
<th style="text-align:center">Vch No.</th>
<th style="text-align:center">Debit</th>
<th style="text-align:center">Credit</th>
</tr>
</thead>
<tbody>
<?php
$total_sale = $obj->get_sum("`invoice`", "`total_amount`", "`customer_id`='$customer' AND `date` BETWEEN '2021-01-01' AND DATE_SUB('$from', INTERVAL 1 DAY)");
$total_payment = $obj->get_sum("`cust_pay_details`", "`amount`", "`customer_id`='$customer' AND `date` BETWEEN '2021-01-01' AND DATE_SUB('$from', INTERVAL 1 DAY)");
$difference = $total_sale - $total_payment;
if ($difference > 0) {
echo "<tr>
<td align='center'>1</td>
<td align='center'>" . date('d-M-y', strtotime($from)) . "</td>
<td align='center'>By Opening Balance</td>
<td align='center'>Debit</td>
<td align='center'></td>
<td align='center'><i class='fa fa-inr fa-sm'></i>$difference</td>
<td align='center'></td>
</tr>";
} else {
echo "<tr>
<td align='center'>1</td>
<td align='center'>" . date('d-M-y', strtotime($from)) . "</td>
<td align='center'>By Opening Balance</td>
<td align='center'>Credit</td>
<td align='center'></td>
<td align='center'></td>
<td align='center'><i class='fa fa-inr fa-sm'></i> " . abs($difference) . "</td>
</tr>";
}
?>
<?php
$sl = 1;
$sale1 = $paid1 = 0;
$sql = "
SELECT 'sales' as type, date, total_amount as amount, payment_mode, prefix, invoice_no
FROM invoice
WHERE customer_id = '$customer' AND date BETWEEN '$from' AND '$to'
UNION
SELECT 'payment' as type, date, amount, payment_mode, '' as prefix, id as invoice_no
FROM cust_pay_details
WHERE customer_id = '$customer' AND date BETWEEN '$from' AND '$to'
ORDER BY date ASC
";
$qry = mysqli_query($con, $sql);
if (mysqli_num_rows($qry) > 0) {
while ($res = mysqli_fetch_array($qry)) {
?>
<tr>
<td align="center"><?php echo $sl++; ?></td>
<td align="center"><?php echo date('d-M-y', strtotime($res['date'])); ?></td>
<td align="center"><?php echo $res['type'] == 'sales' ? 'To GST Sales @ 18%' : 'By ' . strtoupper($res['payment_mode']); ?></td>
<td align="center"><?php echo $res['type'] == 'sales' ? 'Sales' : 'Receipt'; ?></td>
<td align="center"><?= $res['prefix'] . ' ' . $res['invoice_no'] ?></td>
<td align="center"><?php echo $res['type'] == 'sales' ? '<i class="fa fa-inr fa-sm"></i> ' . $res['amount'] : ''; ?></td>
<td align="center"><?php echo $res['type'] == 'payment' ? '<i class="fa fa-inr fa-sm"></i> ' . $res['amount'] : ''; ?></td>
</tr>
<?php
if ($res['type'] == 'payment') {
$paid1 += $res['amount'];
} else {
$sale1 += $res['amount'];
}
}
?>
<tr>
<td align="center" colspan="5"><b>Total</b></td>
<td align="center"><i class="fa fa-inr fa-sm"></i> <b><?= $sale1+$difference ?></b></td>
<td align="center"><i class="fa fa-inr fa-sm"></i> <b><?= $paid1 ?></b></td>
</tr>
<tr>
<td align="center" colspan="5"><b>By Closing Balance</b></td>
<td align="center"></td>
<td align="center"><i class="fa fa-inr fa-sm"></i> <b><?= $sale1 - $paid1 + $difference ?></b></td>
</tr>
<tr>
<td align="center" colspan="5"><b></b></td>
<td align="center"><i class="fa fa-inr fa-sm"></i> <b><?= $sale1 ?></b></td>
<td align="center"><i class="fa fa-inr fa-sm"></i> <b><?= $sale1 ?></b></td>
</tr>
<tr>
<td class="no-print" align="center" colspan="7"><button onclick="window.print()" class="btn btn-success btn-sm">print</button></td>
</tr>
<?php
} else {
?>
<tr>
<td align="center" class="text-danger" colspan="7">No Records Found!!</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<script src="../bootstrap/js/bootstrap.min.js" type="text/javascript"></script>
</body>
</html>