query($sql);
$vendors = [];
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$vendors[$row['id']] = $row['party_name'];
}
}
// Get the date from POST, default to today
if(isset($_POST['date'])) {
$input_date = $_POST['date'];
$formatted_date = date("d-m-Y", strtotime($input_date)); // Convert to DD-MM-YYYY
} else {
$formatted_date = date("d-m-Y");
}
$output = '';
$totalIn = 0;
$totalOut = 0;
// Fetch data based on `created_date`
$query = "SELECT * FROM tbl_ah_items WHERE DATE_FORMAT(created_date, '%d-%m-%Y') = '$formatted_date'";
$result = mysqli_query($conn, $query);
if(mysqli_num_rows($result) > 0) {
$i = 1;
while($row = mysqli_fetch_assoc($result)) {
$moneyIn = ($row['type'] == 'Sale') ? $row['received_amount'] : 0;
$moneyOut = ($row['type'] == 'expences') ? $row['total_amt'] : 0;
$totalIn += $moneyIn;
$totalOut += $moneyOut;
// Generate table rows dynamically
$output .= "
| {$i}. |
" . ($vendors[$row['customer_id']] ?? 'Unknown') . " |
{$row['reference_no']} |
{$row['type']} |
₹ {$row['total_amt']} |
₹ {$moneyIn} |
₹ {$moneyOut} |
";
$i++;
}
} else {
$output = "| No records found for this date. |
";
}
// Calculate Total Money In and Out
$totals = "
| Total Money-In: ₹ {$totalIn} |
Total Money-Out: ₹ {$totalOut} |
Net Balance: ₹ " . ($totalIn - $totalOut) . " |
";
echo json_encode(['orders' => $output, 'totals' => $totals]);
?>