alert("Invalid input.")'; exit; } // Sanitize input $clientregno = mysqli_real_escape_string($conn, $clientregno); $recptno = mysqli_real_escape_string($conn, $recptno); $recptdate = mysqli_real_escape_string($conn, $recptdate); $recamt = mysqli_real_escape_string($conn, $recamt); $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 $query = "INSERT INTO payhead (clientregno, recptno, recptdate, recamt, balamt, remark, createby) VALUES ('$clientregno','$recptno', '$recptdate', '$recamt', '$balamt', '$remark', '$createby')"; $result = mysqli_query($conn, $query); // Check for errors if (!$result) { echo ''; exit; } // Insert into tbl_bankin $query = "INSERT INTO bank_trn (accno, trndate, docno, amount, status, remark, recfrm) VALUES ('$accno', '$recptdate', '$recptno', '$recamt' , '$status', '$remark', '$clientregno')"; $result = mysqli_query($conn, $query); // Check for errors if (!$result) { echo ''; // Rollback the payment header $query = "DELETE FROM payhead WHERE recptno = '$recptno'"; $result = mysqli_query($conn, $query); exit; } // Insert into running receipt no $query = "INSERT INTO rundocno (docno) VALUES ('$recptno')"; $result = mysqli_query($conn, $query); // Check for errors if (!$result) { echo ''; // Rollback the payment header and bank transaction $query = "DELETE FROM payhead WHERE recptno = '$recptno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM bank_trn WHERE docno = '$recptno'"; $result = mysqli_query($conn, $query); exit; } // Get all open invoices for the client $query02 = "SELECT invno, totamt, totrec FROM invhead WHERE clientregno = '$clientregno' AND totamt > totrec"; $result02 = mysqli_query($conn, $query02); // Check for errors if (!$result02) { echo ''; // Rollback the payment header, bank transaction, and running receipt number $query = "DELETE FROM payhead WHERE recptno = '$recptno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM bank_trn WHERE docno = '$recptno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM rundocno WHERE docno = '$recptno'"; $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) { $invno = $invoice['invno']; $totamt = $invoice['totamt']; $totrec = $invoice['totrec']; $payamt = min($recamt, $totamt - $totrec); // Insert payment details $query = "INSERT INTO paydet (recptno, invno, payamt) VALUES ('$recptno', '$invno', '$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 payhead WHERE recptno = '$recptno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM bank_trn WHERE docno = '$recptno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM rundocno WHERE docno = '$recptno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM paydet WHERE recptno = '$recptno'"; $result = mysqli_query($conn, $query); exit; } // Update invoice header with total payment received $query = "UPDATE invhead SET totrec = totrec + '$payamt' WHERE invno = '$invno'"; $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 payhead WHERE recptno = '$recptno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM bank_trn WHERE docno = '$recptno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM rundocno WHERE docno = '$recptno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM paydet WHERE recptno = '$recptno'"; $result = mysqli_query($conn, $query); exit; } // Update payment header with balance amount $balamt = $recamt - $payamt; $query = "UPDATE payhead SET balamt = '$balamt' WHERE recptno = '$recptno'"; $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 payhead WHERE recptno = '$recptno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM bank_trn WHERE docno = '$recptno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM rundocno WHERE docno = '$recptno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM paydet WHERE recptno = '$recptno'"; $result = mysqli_query($conn, $query); $query = "UPDATE invhead SET totrec = totrec - '$payamt' WHERE invno = '$invno'"; $result = mysqli_query($conn, $query); exit; } $recamt -= $payamt; if ($recamt == 0) { break; // Payment fully processed } } // Check if payment was fully processed if ($recamt > 0) { echo ''; // Rollback the payment header, bank transaction, running receipt number, and previous payment details $query = "DELETE FROM payhead WHERE recptno = '$recptno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM bank_trn WHERE docno = '$recptno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM rundocno WHERE docno = '$recptno'"; $result = mysqli_query($conn, $query); $query = "DELETE FROM paydet WHERE recptno = '$recptno'"; $result = mysqli_query($conn, $query); foreach ($invoices as $invoice) { $invno = $invoice['invno']; $query = "UPDATE invhead SET totrec = totrec - '$payamt' WHERE invno = '$invno'"; $result = mysqli_query($conn, $query); } exit; } echo ''; } ?>

Rekod Penerimaan Bayaran