alert("' . $error_message . '")'; exit; } // Sanitize input $supregno = mysqli_real_escape_string($conn, $supregno); $pvno = mysqli_real_escape_string($conn, $pvno); $pvdate = mysqli_real_escape_string($conn, $pvdate); $pvamt = mysqli_real_escape_string($conn, $pvamt); $balamt = mysqli_real_escape_string($conn, $balamt); $remark = mysqli_real_escape_string($conn, $remark); $createby = mysqli_real_escape_string($conn, $createby); $accno = mysqli_real_escape_string($conn, $accno); // Insert payment header $query01 = "INSERT INTO sup_payhead (supregno, pvno, pvdate, pvamt, balamt, remark, createby) VALUES ('$supregno','$pvno', '$pvdate', '$pvamt', '$balamt', '$remark', '$createby')"; $result01 = mysqli_query($conn, $query01); // Check for errors if (!$result) { echo ''; exit; } // Insert into tbl_bankout $query03 = "INSERT INTO bank_trn (accno, trndate, docno, amount, status, remark, recfrm) VALUES ('$accno', '$pvdate', '$pvno', '$bankout', '$remark', '$remark', '$supregno')"; $result03 = mysqli_query($conn, $query03); // Check for errors if (!$result) { echo ''; // Rollback the payment header $query = "DELETE FROM sup_payhead WHERE pvno = '$pvno'"; $result = mysqli_query($conn, $query); exit; } // Insert into running pv no $query03 = "INSERT INTO rundocno (docno) VALUES ('$pvno')"; $result03 = mysqli_query($conn, $query03); // Check for errors if (!$result) { echo ''; // Rollback the payment header and bank transaction $query = "DELETE FROM sup_payhead WHERE pvno = '$pvno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM bank_trn WHERE docno = '$pvno'"; $result = mysqli_query($conn, $query); exit; } // Get all open invoices for the client $query02 = "SELECT pono, totamt, totpay FROM sup_invhead WHERE supregno = '$supregno' AND totamt > totpay"; $result02 = mysqli_query($conn, $query02); // Check for errors if (!$result02) { echo ''; // Rollback the payment header, bank transaction, and running receipt number $query = "DELETE FROM sup_payhead WHERE pvno = '$pvno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM bank_trn WHERE docno = '$pvno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM rundocno WHERE docno = '$pvno'"; $result = mysqli_query($conn, $query); exit; } $invoices = array(); while ($row = mysqli_fetch_assoc($result02)) { $invoices[] = $row; } // Process the payment and update the invoices foreach ($invoices as $invoice) { $pono = $invoice['pono']; $totamt = $invoice['totamt']; $totpay = $invoice['totpay']; $payamt = min($pvamt, $totamt - $totpay); // Insert payment details $query = "INSERT INTO sup_paydet (pvno, pono, payamt) VALUES ('$pvno', '$pono', '$payamt')"; $result = mysqli_query($conn, $query); // Check for errors if (!$result) { echo ''; // Rollback the payment header, bank transaction, running receipt number, and previous payment details $query = "DELETE FROM sup_payhead WHERE pvno = '$pvno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM bank_trn WHERE docno = '$pvno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM rundocno WHERE docno = '$pvno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM sup_paydet WHERE pvno = '$pvno'"; $result = mysqli_query($conn, $query); exit; } // Update invoice header with total payment received $query = "UPDATE sup_invhead SET totpay = totpay + '$payamt' WHERE pono = '$pono'"; $result = mysqli_query($conn, $query); // Check for errors if (!$result) { echo ''; // Rollback the payment header, bank transaction, running receipt number, and previous payment details $query = "DELETE FROM sup_payhead WHERE pvno = '$pvno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM bank_trn WHERE docno = '$pvno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM rundocno WHERE docno = '$pvno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM sup_paydet WHERE pvno = '$pvno'"; $result = mysqli_query($conn, $query); exit; } // Update payment header with balance amount $balamt = $pvamt - $payamt; $query = "UPDATE sup_payhead SET balamt = '$balamt' WHERE pvno = '$pvno'"; $result = mysqli_query($conn, $query); // Check for errors if (!$result) { echo ''; // Rollback the payment header, bank transaction, running receipt number, and previous payment details $query = "DELETE FROM sup_payhead WHERE pvno = '$pvno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM bank_trn WHERE docno = '$pvno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM rundocno WHERE docno = '$pvno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM sup_paydet WHERE pvno = '$pvno'"; $result = mysqli_query($conn, $query); $query = "UPDATE sup_invhead SET totpay = totpay - '$payamt' WHERE pono = '$pono'"; $result = mysqli_query($conn, $query); exit; } $pvamt -= $payamt; if ($pvamt == 0) { break; // Payment fully processed } } // Check if payment was fully processed if ($pvamt > 0) { echo ''; // Rollback the payment header, bank transaction, running receipt number, and previous payment details $query = "DELETE FROM sup_payhead WHERE pvno = '$pvno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM bank_trn WHERE docno = '$pvno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM rundocno WHERE docno = '$pvno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM sup_paydet WHERE pvno = '$pvno'"; $result = mysqli_query($conn, $query); foreach ($pos as $po) { $pono = $po['pono']; $query = "UPDATE sup_invhead SET totpay = totpay - '$payamt' WHERE pono = '$pono'"; $result = mysqli_query($conn, $query); } exit; } echo ''; } ?>

Rekod Bayaran Pembekal