query($sql);
$vendors = [];
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$vendors[$row['id']] = $row['party_name'];
}
}
// Fetch transactions
$query = "
SELECT 'Purchase' AS type, customer_id, receipt_no, receipt_date AS trans_date, transaction_id, bank_name, paid_amount AS amount
FROM ah_purchase_payment_out WHERE payment_type = 'bank'
UNION ALL
SELECT 'Sale' AS type, customer_id, receipt_no, date AS trans_date, transaction_id, bank_name, received_amonut AS amount
FROM ah_sales_payment_in WHERE payment_type = 'bank'
ORDER BY trans_date DESC
";
$result = $conn->query($query);
?>
| # |
Party Name |
Type |
Receipt No |
Transaction Date |
Transaction ID |
Bank Name |
Amount |
num_rows > 0) {
$count = 1;
while ($row = $result->fetch_assoc()) { ?>
|
|
|
|
|
|
|
|
| No transactions found |