PHP database3::payment_voucher_purhcasing Exemples

Exemple #1

Fichier : addVouchers_purchasing1.php Projet : rickyx12/protacio

$wTax = $_GET['wTax'];
$netTotal = $_GET['netTotal'];
$payee = $_GET['payee'];
$date = $_GET['date'];
$username = $_GET['username'];
$vat = $_GET['vat'];
$voucherNo = $_GET['voucherNo'];
$ro = new database3();
for ($x = 0; $x < $count; $x++) {
    $invoiceTotal = $ro->purchasingPayablesTotal($siNo[$x]);
    $vattable = round($invoiceTotal / 1.12, 2);
    $vat = round($invoiceTotal - $vattable, 2);
    $wTax = round($vattable * 0.01, 2);
    $netTotal = round($invoiceTotal - $wTax, 2);
    echo $siNo[$x] . "......." . "Vattable: " . $vattable . "........Vat: " . $vat . "........wTax: " . $wTax . ".......Net: " . $netTotal . "<Br>";
    if ($paymentMode == "cash") {
        $voucherNo1 = "CA" . $voucherNo;
    } else {
        $voucherNo1 = "CH" . $voucherNo;
    }
    $ro->payment_voucher_purhcasing($ro->selectNow("salesInvoice", "invoiceNo", "siNo", $siNo[$x]), $checkNo, $bank, $orNo, $paymentMode, $description, $invoiceTotal, $vattable, $wTax, $vat, $payee, $date, $username, $voucherNo1);
    if ($paymentMode == "cash") {
        $ro->addToPurchaseJournal($voucherNo1, $invoiceNo, "INVENTORY", $invoiceTotal, "", $siNo[$x], date("Y-m-d"));
        $ro->addToPurchaseJournal($voucherNo1, $invoiceNo, "CASH", "", $netTotal, $siNo[$x], date("Y-m-d"));
        $ro->addToPurchaseJournal($voucherNo1, $invoiceNo, "WITHHOLDING TAX - EXPANDED", "", $wTax, $siNo[$x], date("Y-m-d"));
    } else {
        $ro->addToPurchaseJournal($voucherNo1, $invoiceNo, "ACCOUNTS PAYABLE", $invoiceTotal, "", $siNo[$x], date("Y-m-d"));
        $ro->addToPurchaseJournal($voucherNo1, $invoiceNo, "CASH IN BANK - {$bank}", "", $netTotal, $siNo[$x], date("Y-m-d"));
        $ro->addToPurchaseJournal($voucherNo1, $invoiceNo, "WITHHOLDING TAX - EXPANDED", "", $wTax, $siNo[$x], date("Y-m-d"));
    }
}