PHP filter_currency_input函数代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中filter_currency_input函数的典型用法代码示例。如果您正苦于以下问题：PHP filter_currency_input函数的具体用法？PHP filter_currency_input怎么用？PHP filter_currency_input使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了filter_currency_input函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: DB_query

    $OldResult = DB_query($sql, $db, $ErrMsg);
    $OldRow = DB_fetch_array($OldResult);
    $_POST['QOH'] = $OldRow['totalqoh'];
    $_POST['OldMaterialCost'] = $OldRow['materialcost'];
    if ($OldRow['mbflag'] == 'M') {
        $_POST['OldLabourCost'] = $OldRow['labourcost'];
        $_POST['OldOverheadCost'] = $OldRow['overheadcost'];
    } else {
        $_POST['OldLabourCost'] = 0;
        $_POST['OldOverheadCost'] = 0;
        $_POST['LabourCost'] = 0;
        $_POST['OverheadCost'] = 0;
    }
    DB_free_result($OldResult);
    $OldCost = filter_currency_input($_POST['OldMaterialCost'] + $_POST['OldLabourCost'] + $_POST['OldOverheadCost']);
    $NewCost = filter_currency_input($_POST['MaterialCost'] + $_POST['LabourCost'] + $_POST['OverheadCost']);
    $result = DB_query("SELECT stockid FROM stockmaster WHERE stockid='" . $StockID . "'", $db);
    if (DB_num_rows($result) == 0) {
        prnMsg(_('The entered item code does not exist'), 'error', _('Non-existent Item'));
    } elseif ($OldCost != $NewCost) {
        $Result = DB_Txn_Begin($db);
        ItemCostUpdateGL($db, $StockID, $NewCost, $OldCost, $_POST['QOH']);
        $SQL = "UPDATE stockmaster SET materialcost='" . $_POST['MaterialCost'] . "',\n\t\t\t\t\t\t\t\t\t\tlabourcost='" . $_POST['LabourCost'] . "',\n\t\t\t\t\t\t\t\t\t\toverheadcost='" . $_POST['OverheadCost'] . "',\n\t\t\t\t\t\t\t\t\t\tlastcost='" . $OldCost . "',\n\t\t\t\t\t\t\t\t\t\tlastcurcostdate='" . Date('Y-m-d') . "'\n\t\t\t\t\t\t\t\t\tWHERE stockid='" . $StockID . "'";
        $ErrMsg = _('The cost details for the stock item could not be updated because');
        $DbgMsg = _('The SQL that failed was');
        $Result = DB_query($SQL, $db, $ErrMsg, $DbgMsg, true);
        $Result = DB_Txn_Commit($db);
        UpdateCost($db, $StockID);
        //Update any affected BOMs
    }
}

开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:31，代码来源:StockCostUpdate.php

示例2: foreach

     if ($QuantityAlreadyDelivered == 0) {
         $_SESSION['Items' . $identifier]->remove_from_cart($_GET['Delete'], 'Yes');
         /*Do update DB */
     } else {
         $_SESSION['Items' . $identifier]->LineItems[$_GET['Delete']]->Quantity = $QuantityAlreadyDelivered;
     }
 }
 $AlreadyWarnedAboutCredit = false;
 foreach ($_SESSION['Items' . $identifier]->LineItems as $OrderLine) {
     if (isset($_POST['Quantity_' . $OrderLine->LineNumber])) {
         if (!isset($PropertiesArray[$OrderLine->LineNumber])) {
             $PropertiesArray[$OrderLine->LineNumber] = '';
         }
         $Quantity = filter_number_input($_POST['Quantity_' . $OrderLine->LineNumber]);
         if (ABS($OrderLine->Price - $_POST['Price_' . $OrderLine->LineNumber]) > 0.01) {
             $Price = filter_currency_input($_POST['Price_' . $OrderLine->LineNumber]);
             $_POST['GPPercent_' . $OrderLine->LineNumber] = ($Price * (1 - $_POST['Discount_' . $OrderLine->LineNumber] / 100) - $OrderLine->StandardCost * $ExRate) / ($Price * (1 - $_POST['Discount_' . $OrderLine->LineNumber]) / 100);
         } elseif (ABS($OrderLine->GPPercent - $_POST['GPPercent_' . $OrderLine->LineNumber]) >= 0.01) {
             //then do a recalculation of the price at this new GP Percentage
             $Price = $OrderLine->StandardCost * $ExRate / (1 - ($_POST['GPPercent_' . $OrderLine->LineNumber] + $_POST['Discount_' . $OrderLine->LineNumber]) / 100);
         } else {
             $Price = $_POST['Price_' . $OrderLine->LineNumber];
         }
         $DiscountPercentage = $_POST['Discount_' . $OrderLine->LineNumber];
         if ($_SESSION['AllowOrderLineItemNarrative'] == 1) {
             $Narrative = $_POST['Narrative_' . $OrderLine->LineNumber];
         } else {
             $Narrative = '';
         }
         if (!isset($OrderLine->DiscountPercent)) {
             $OrderLine->DiscountPercent = 0;

开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:31，代码来源:SelectOrderItems.php

示例3: _

 }
 if (Date1GreaterThanDate2($_POST['StartDate'], $_POST['EndDate']) and $_POST['EndDate'] != '') {
     $InputError = 1;
     $msg = _('The end date is expected to be after the start date, enter an end date after the start date for this price');
 }
 if (Date1GreaterThanDate2(Date($_SESSION['DefaultDateFormat']), $_POST['EndDate']) and $_POST['EndDate'] != '') {
     $InputError = 1;
     $msg = _('The end date is expected to be after today. There is no point entering a new price where the effective date is before today!');
 }
 if (isset($_POST['Editing']) and $_POST['Editing'] == 'Yes' and strlen($Item) > 1 and $InputError != 1) {
     //editing an existing price
     $sql = "UPDATE prices SET typeabbrev='" . $SalesType . "',\n\t\t                        currabrev='" . $CurrCode . "',\n\t\t\t\t\t\t\t\tprice='" . filter_currency_input($_POST['Price']) . "',\n\t\t\t\t\t\t\t\tunits='" . $_POST['Units'] . "',\n\t\t\t\t\t\t\t\tconversionfactor='" . filter_number_input($_POST['ConversionFactor']) . "',\n\t\t\t\t\t\t\t\tdecimalplaces='" . round($_POST['DecimalPlaces'], 0) . "',\n\t\t\t\t\t\t\t\tbranchcode='" . $_POST['Branch'] . "',\n\t\t\t\t\t\t\t\tstartdate='" . FormatDateForSQL($_POST['StartDate']) . "',\n\t\t\t\t\t\t\t\tenddate='" . FormatDateForSQL($_POST['EndDate']) . "'\n\t\t\t\tWHERE prices.stockid='" . $Item . "'\n\t\t\t\tAND prices.typeabbrev='" . $SalesType . "'\n\t\t\t\tAND prices.currabrev='" . $CurrCode . "'\n\t\t\t\tAND prices.startdate='" . $_POST['OldStartDate'] . "'\n\t\t\t\tAND prices.enddate='" . $_POST['OldEndDate'] . "'\n\t\t\t\tAND prices.debtorno='" . $_SESSION['CustomerID'] . "'";
     $msg = _('Price Updated');
 } elseif ($InputError != 1) {
     /*Selected price is null cos no item selected on first time round so must be adding a	record must be submitting new entries in the new price form */
     $sql = "INSERT INTO prices (stockid,\n\t\t                            typeabbrev,\n\t\t\t\t\t\t\t\t\tcurrabrev,\n\t\t\t\t\t\t\t\t\tdebtorno,\n\t\t\t\t\t\t\t\t\tprice,\n\t\t\t\t\t\t\t\t\tunits,\n\t\t\t\t\t\t\t\t\tconversionfactor,\n\t\t\t\t\t\t\t\t\tdecimalplaces,\n\t\t\t\t\t\t\t\t\tbranchcode,\n\t\t\t\t\t\t\t\t\tstartdate,\n\t\t\t\t\t\t\t\t\tenddate)\n\t\t\t\t\t\t\tVALUES (\n\t\t\t\t\t\t\t\t\t'" . $Item . "',\n\t\t\t\t\t\t\t\t\t'" . $SalesType . "',\n\t\t\t\t\t\t\t\t\t'" . $CurrCode . "',\n\t\t\t\t\t\t\t\t\t'" . $_SESSION['CustomerID'] . "',\n\t\t\t\t\t\t\t\t\t'" . filter_currency_input($_POST['Price']) . "',\n\t\t\t\t\t\t\t\t\t'" . $_POST['Units'] . "',\n\t\t\t\t\t\t\t\t\t'" . filter_number_input($_POST['ConversionFactor']) . "',\n\t\t\t\t\t\t\t\t\t'" . round($_POST['DecimalPlaces'], 0) . "',\n\t\t\t\t\t\t\t\t\t'" . $_POST['Branch'] . "',\n\t\t\t\t\t\t\t\t\t'" . FormatDateForSQL($_POST['StartDate']) . "',\n\t\t\t\t\t\t\t\t\t'" . FormatDateForSQL($_POST['EndDate']) . "'\n\t\t\t\t\t\t\t\t\t)";
     $msg = _('Price added') . '.';
 }
 //run the SQL from either of the above possibilites
 if ($InputError != 1) {
     $result = DB_query($sql, $db, '', '', false, false);
     if (DB_error_no($db) != 0) {
         if ($msg == _('Price Updated')) {
             $msg = _('The price could not be updated because') . ' - ' . DB_error_msg($db);
         } else {
             $msg = _('The price could not be added because') . ' - ' . DB_error_msg($db);
         }
     } else {
         ReSequenceEffectiveDates($Item, $SalesType, $CurrCode, $_SESSION['CustomerID'], $db);
         unset($_POST['EndDate']);
         unset($_POST['StartDate']);

开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:31，代码来源:Prices_Customer.php

示例4: DB_query

 $result = DB_query($sql, $db);
 if (DB_num_rows($result) > 0) {
     echo '<tr><td>' . _('Doctors Name') . ':</td>';
     echo '<td><select name="Doctor">';
     echo '<option value="">' . _('Select a doctor from list') . '</option>';
     while ($myrow = DB_fetch_array($result)) {
         if (isset($_POST['Doctor']) and $_POST['Doctor'] == $myrow['supplierid']) {
             echo '<option selected="selected" value="' . $myrow['supplierid'] . '">' . $myrow['supplierid'] . ' - ' . $myrow['suppname'] . '</option>';
         } else {
             echo '<option value="' . $myrow['supplierid'] . '">' . $myrow['supplierid'] . ' - ' . $myrow['suppname'] . '</option>';
         }
     }
     echo '</select></td></tr>';
     echo '<tr><td>';
     if (isset($_POST['DoctorsFee']) and $_POST['DoctorsFee'] != '') {
         echo _('Doctors Fee') . ':</td><td><input type="text" class="number" size="10" name="DoctorsFee" value="' . locale_money_format(filter_currency_input($_POST['DoctorsFee']), $_SESSION['CompanyRecord']['currencydefault']) . '" />';
     } else {
         echo _('Doctors Fee') . ':</td><td><input type="text" class="number" size="10" name="DoctorsFee" value="" />';
     }
     if (isset($_POST['AddDoctorFee'])) {
         echo '<input type="checkbox" checked="checked" name="AddDoctorFee" value="Add Doctors fee to balance" onChange="ReloadForm(ChangeItem)" />' . _('Add Doctors fee to balance') . '</td></tr>';
     } else {
         echo '<input type="checkbox" name="AddDoctorFee" value="Add Doctors fee to balance" onChange="ReloadForm(ChangeItem)" />' . _('Add Doctors fee to balance') . '</td></tr>';
     }
 }
 if ($Patient[1] == 'CASH') {
     if (!isset($Received)) {
         $Received = $_SESSION['Items']['Value'];
     }
     echo '<tr><td>' . _('Amount Received') . '</td>';
     echo '<td><input type="text" class="number" size="10" name="Received" value="' . locale_money_format($Received, $_SESSION['CompanyRecord']['currencydefault']) . '" /></td></tr>';

开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:31，代码来源:KCMCRadiology.php

示例5: filter_currency_input

     $i++;
 }
 if (isset($SelectedTab) and $InputError != 1) {
     $sql = "UPDATE pctabs\r\n\t\t\tSET usercode = '" . $_POST['SelectUser'] . "',\r\n\t\t\ttypetabcode = '" . $_POST['SelectTabs'] . "',\r\n\t\t\tcurrency = '" . $_POST['SelectCurrency'] . "',\r\n\t\t\ttablimit = '" . filter_currency_input($_POST['tablimit']) . "',\r\n\t\t\tassigner = '" . $_POST['SelectAssigner'] . "',\r\n\t\t\tauthorizer = '" . $_POST['SelectAuthorizer'] . "',\r\n\t\t\tglaccountassignment = '" . $_POST['glaccountcash'] . "',\r\n\t\t\tglaccountpcash = '" . $_POST['glaccountpcashtab'] . "'\r\n\t\t\tWHERE tabcode = '" . $SelectedTab . "'";
     $msg = _('The Petty Cash Tab') . ' ' . $SelectedTab . ' ' . _('has been updated');
 } elseif ($InputError != 1) {
     // First check the type is not being duplicated
     $checkSql = "SELECT count(*)\r\n\t\t\t\t FROM pctabs\r\n\t\t\t\t WHERE tabcode = '" . $_POST['tabcode'] . "'";
     $checkresult = DB_query($checkSql, $db);
     $checkrow = DB_fetch_row($checkresult);
     if ($checkrow[0] > 0) {
         $InputError = 1;
         prnMsg(_('The Tab ') . $_POST['tabcode'] . _(' already exist.'), 'error');
     } else {
         // Add new record on submit
         $sql = "INSERT INTO pctabs\r\n\t\t\t\t\t\t(tabcode,\r\n\t\t\t \t\t\t usercode,\r\n\t\t\t\t\t\t typetabcode,\r\n\t\t\t\t\t\t currency,\r\n\t\t\t\t\t\t tablimit,\r\n\t\t\t\t\t\t assigner,\r\n\t\t\t\t\t\t authorizer,\r\n\t\t\t\t\t\t glaccountassignment,\r\n\t\t\t\t\t\t glaccountpcash)\r\n\t\t\t\tVALUES ('" . $_POST['tabcode'] . "',\r\n\t\t\t\t\t'" . $_POST['SelectUser'] . "',\r\n\t\t\t\t\t'" . $_POST['SelectTabs'] . "',\r\n\t\t\t\t\t'" . $_POST['SelectCurrency'] . "',\r\n\t\t\t\t\t'" . filter_currency_input($_POST['tablimit']) . "',\r\n\t\t\t\t\t'" . $_POST['SelectAssigner'] . "',\r\n\t\t\t\t\t'" . $_POST['SelectAuthorizer'] . "',\r\n\t\t\t\t\t'" . $_POST['glaccountcash'] . "',\r\n\t\t\t\t\t'" . $_POST['glaccountpcashtab'] . "')";
         $msg = _('The Petty Cash Tab') . ' ' . $_POST['tabcode'] . ' ' . _('has been created');
     }
 }
 if ($InputError != 1) {
     //run the SQL from either of the above possibilites
     $result = DB_query($sql, $db);
     prnMsg($msg, 'success');
     unset($SelectedTab);
     unset($_POST['tabcode']);
     unset($_POST['SelectUser']);
     unset($_POST['SelectTabs']);
     unset($_POST['SelectCurrency']);
     unset($_POST['tablimit']);
     unset($_POST['SelectAssigner']);
     unset($_POST['SelectAuthorizer']);

开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:31，代码来源:PcTabs.php

示例6: Allocation

class Allocation
{
    var $TransID;
    var $Amount;
    function Allocation($TransID, $Amount)
    {
        $this->TransID = $TransID;
        $this->Amount = $Amount;
    }
}
include 'includes/session.inc';
include 'includes/SQL_CommonFunctions.inc';
include 'includes/GetPaymentMethods.php';
foreach ($_POST as $key => $value) {
    if (substr($key, 0, 6) == 'ExRate') {
        $_POST[$key] = filter_currency_input($value);
    }
}
if ((isset($_POST['PrintPDF']) or isset($_POST['PrintPDFAndProcess'])) and isset($_POST['FromCriteria']) and mb_strlen($_POST['FromCriteria']) >= 1 and isset($_POST['ToCriteria']) and mb_strlen($_POST['ToCriteria']) >= 1 and is_numeric($_POST['ExRate'])) {
    /*then print the report */
    $RefCounter = 0;
    include 'includes/PDFStarter.php';
    $pdf->addInfo('Title', _('Payment Run Report'));
    $pdf->addInfo('Subject', _('Payment Run') . ' - ' . _('suppliers from') . ' ' . $_POST['FromCriteria'] . ' to ' . $_POST['ToCriteria'] . ' in ' . $_POST['Currency'] . ' ' . _('and Due By') . ' ' . $_POST['AmountsDueBy']);
    $PageNumber = 1;
    $line_height = 12;
    /*Now figure out the invoice less credits due for the Supplier range under review */
    include 'includes/PDFPaymentRunPageHeader.inc';
    $sql = "SELECT suppliers.supplierid,\n\t\t\tSUM(supptrans.ovamount + supptrans.ovgst - supptrans.alloc) AS balance\n\t\tFROM suppliers,\n\t\t\tpaymentterms,\n\t\t\tsupptrans,\n\t\t\tsystypes\n\t\tWHERE systypes.typeid = supptrans.type\n\t\tAND suppliers.paymentterms = paymentterms.termsindicator\n\t\tAND suppliers.supplierid = supptrans.supplierno\n\t\tAND supptrans.ovamount + supptrans.ovgst - supptrans.alloc !=0\n\t\tAND supptrans.duedate <='" . FormatDateForSQL($_POST['AmountsDueBy']) . "'\n\t\tAND supptrans.hold=0\n\t\tAND suppliers.currcode = '" . $_POST['Currency'] . "'\n\t\tAND supptrans.supplierNo >= '" . $_POST['FromCriteria'] . "'\n\t\tAND supptrans.supplierno <= '" . $_POST['ToCriteria'] . "'\n\t\tGROUP BY suppliers.supplierid\n\t\tHAVING SUM(supptrans.ovamount + supptrans.ovgst - supptrans.alloc) > 0\n\t\tORDER BY suppliers.supplierid";
    $SuppliersResult = DB_query($sql, $db);
    $SupplierID = '';

开发者ID:patmark，项目名称:weberp-elct，代码行数:31，代码来源:SuppPaymentRun.php

示例7: _

     $ErrMsg = _('The supplier purchasing details could not be added to the database because');
     $DbgMsg = _('The SQL that failed was');
     $AddResult = DB_query($sql, $db, $ErrMsg, $DbgMsg);
     prnMsg(_('This supplier purchasing data has been added to the database'), 'success');
     /* If the new purchdata is the preferred one, the old ones from the same suppliers shouldn't be preferred.
     		Are kept only for historic information only */
     if ($_POST['Preferred'] == 1) {
         $sql = "UPDATE purchdata SET preferred='0'\n\t\t\t\t\t\t\t\tWHERE purchdata.stockid='" . $StockID . "'\n\t\t\t\t\t\t\t\t\tAND purchdata.supplierno='" . $SupplierID . "'\n\t\t\t\t\t\t\t\t\tAND purchdata.effectivefrom < '" . FormatDateForSQL($_POST['EffectiveFrom']) . "'";
         $ErrMsg = _('The preferred supplier details could not be update because');
         $DbgMsg = _('The SQL that failed was');
         $UpdResult = DB_query($sql, $db, $ErrMsg, $DbgMsg);
         prnMsg(_('Supplier preferred flag has been updated'), 'success');
     }
 }
 if ($InputError == 0 and isset($_POST['UpdateRecord'])) {
     $sql = "UPDATE purchdata SET price='" . filter_currency_input($_POST['Price']) . "',\n\t\t\t\t\t\t\t\t\teffectivefrom='" . FormatDateForSQL($_POST['EffectiveFrom']) . "',\n\t\t\t\t\t\t\t\t\tsuppliersuom='" . $_POST['SuppliersUOM'] . "',\n\t\t\t\t\t\t\t\t\tconversionfactor='" . $_POST['ConversionFactor'] . "',\n\t\t\t\t\t\t\t\t\tuomdecimalplaces='" . $_POST['DecimalPlaces'] . "',\n\t\t\t\t\t\t\t\t\tsupplierdescription='" . $_POST['SupplierDescription'] . "',\n\t\t\t\t\t\t\t\t\tsuppliers_partno='" . $_POST['SupplierCode'] . "',\n\t\t\t\t\t\t\t\t\tleadtime='" . $_POST['LeadTime'] . "',\n\t\t\t\t\t\t\t\t\tminorderqty='" . $_POST['MinOrderQty'] . "',\n\t\t\t\t\t\t\t\t\tpreferred='" . $_POST['Preferred'] . "'\n\t\t\t\t\t\t\tWHERE purchdata.stockid='" . $StockID . "'\n\t\t\t\t\t\t\t\tAND purchdata.supplierno='" . $SupplierID . "'\n\t\t\t\t\t\t\t\tAND purchdata.effectivefrom='" . $_POST['WasEffectiveFrom'] . "'";
     $ErrMsg = _('The supplier purchasing details could not be update because');
     $DbgMsg = _('The SQL that failed was');
     $UpdResult = DB_query($sql, $db, $ErrMsg, $DbgMsg);
     prnMsg(_('Supplier purchasing data has been updated'), 'success');
 }
 if ($InputError == 0 and (isset($_POST['UpdateRecord']) or isset($_POST['AddRecord']))) {
     /*update or insert took place and need to clear the form  */
     unset($SupplierID);
     unset($_POST['Price']);
     unset($CurrCode);
     unset($_POST['SuppliersUOM']);
     unset($_POST['EffectiveFrom']);
     unset($_POST['ConversionFactor']);
     unset($_POST['SupplierDescription']);
     unset($_POST['LeadTime']);

开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:31，代码来源:PurchData.php

示例8: _

            }
            $ErrMsg = _('The customer could not be updated because');
            $result = DB_query($sql, $db, $ErrMsg);
            prnMsg(_('Customer updated'), 'success');
            echo '<br />';
        } else {
            //it is a new customer
            /* set the DebtorNo if $AutoDebtorNo in config.php has been set to
            			something greater 0 */
            if ($_SESSION['AutoDebtorNo'] > 0) {
                /* system assigned, sequential, numeric */
                if ($_SESSION['AutoDebtorNo'] == 1) {
                    $_POST['DebtorNo'] = GetNextTransNo(500, $db);
                }
            }
            $sql = "INSERT INTO debtorsmaster (\n\t\t\t\t\t\t\tdebtorno,\n\t\t\t\t\t\t\tname,\n\t\t\t\t\t\t\taddress1,\n\t\t\t\t\t\t\taddress2,\n\t\t\t\t\t\t\taddress3,\n\t\t\t\t\t\t\taddress4,\n\t\t\t\t\t\t\taddress5,\n\t\t\t\t\t\t\taddress6,\n\t\t\t\t\t\t\tcurrcode,\n\t\t\t\t\t\t\tclientsince,\n\t\t\t\t\t\t\tholdreason,\n\t\t\t\t\t\t\tpaymentterms,\n\t\t\t\t\t\t\tdiscount,\n\t\t\t\t\t\t\tdiscountcode,\n\t\t\t\t\t\t\tpymtdiscount,\n\t\t\t\t\t\t\tcreditlimit,\n\t\t\t\t\t\t\tsalestype,\n\t\t\t\t\t\t\tinvaddrbranch,\n\t\t\t\t\t\t\ttaxref,\n\t\t\t\t\t\t\tcustomerpoline,\n\t\t\t\t\t\t\ttypeid)\n\t\t\t\tVALUES ('" . $_POST['DebtorNo'] . "',\n\t\t\t\t\t'" . $_POST['CustName'] . "',\n\t\t\t\t\t'" . $_POST['Address1'] . "',\n\t\t\t\t\t'" . $_POST['Address2'] . "',\n\t\t\t\t\t'" . $_POST['Address3'] . "',\n\t\t\t\t\t'" . $_POST['Address4'] . "',\n\t\t\t\t\t'" . $_POST['Address5'] . "',\n\t\t\t\t\t'" . $_POST['Address6'] . "',\n\t\t\t\t\t'" . $_POST['CurrCode'] . "',\n\t\t\t\t\t'" . $SQL_ClientSince . "',\n\t\t\t\t\t'" . $_POST['HoldReason'] . "',\n\t\t\t\t\t'" . $_POST['PaymentTerms'] . "',\n\t\t\t\t\t " . filter_number_input($_POST['Discount']) . "/100,\n\t\t\t\t\t'" . $_POST['DiscountCode'] . "',\n\t\t\t\t\t " . filter_number_input($_POST['PymtDiscount']) . "/100,\n\t\t\t\t\t'" . filter_currency_input($_POST['CreditLimit']) . "',\n\t\t\t\t\t'" . $_POST['SalesType'] . "',\n\t\t\t\t\t'" . $_POST['AddrInvBranch'] . "',\n\t\t\t\t\t'" . $_POST['TaxRef'] . "',\n\t\t\t\t\t'" . $_POST['CustomerPOLine'] . "',\n\t\t\t\t\t'" . $_POST['typeid'] . "'\n\t\t\t\t\t)";
            $ErrMsg = _('This customer could not be added because');
            $result = DB_query($sql, $db, $ErrMsg);
            $BranchCode = mb_substr($_POST['DebtorNo'], 0, 4);
            echo '<meta http-equiv="Refresh" content="0; url=' . $rootpath . '/CustomerBranches.php?DebtorNo=' . $_POST['DebtorNo'] . '">';
            echo '<div class="centre">' . _('You should automatically be forwarded to the entry of a new Customer Branch page') . '. ' . _('If this does not happen') . ' (' . _('if the browser does not support META Refresh') . ') ' . '<a href="' . $rootpath . '/CustomerBranches.php?DebtorNo=' . $_POST['DebtorNo'] . '"></a></div>';
            include 'includes/footer.inc';
            exit;
        }
    } else {
        prnMsg(_('Validation failed') . '. ' . _('No updates or deletes took place'), 'error');
    }
} elseif (isset($_POST['delete'])) {
    //the link to delete a selected record was clicked instead of the submit button
    $CancelDelete = 0;
    // PREVENT DELETES IF DEPENDENT RECORDS IN 'DebtorTrans'

开发者ID:patmark，项目名称:weberp-elct，代码行数:31，代码来源:Customers.php

示例9: DB_query

            $TagResult = DB_query($tagsql, $db);
            $TagMyrow = DB_fetch_row($TagResult);
            if ($PaymentItem->tag == 0) {
                $TagName = 'None';
            } else {
                $TagName = $TagMyrow[0];
            }
            echo '<tr>
					<td align=left>' . $PaymentItem->cheque . '</td>
					<td class="number">' . $PaymentItem->Amount . '</td>
					<td>' . $PaymentItem->GLCode . ' - ' . $PaymentItem->GLActName . '</td>
					<td>' . stripslashes($PaymentItem->Narrative) . '</td>
					<td>' . $PaymentItem->tag . ' - ' . $TagName . '</td>
					<td><a href="' . htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8') . '?Delete=' . $PaymentItem->ID . '" onclick="return confirm(\'' . _('Are you sure you wish to delete this payment analysis item?') . '\');">' . _('Delete') . '</a></td>
				</tr>';
            $PaymentTotal += filter_currency_input($PaymentItem->Amount);
        }
        echo '<tr><td></td><td class="number"><b>' . locale_money_format($PaymentTotal, $_SESSION['PaymentDetail' . $identifier]->AccountCurrency) . '</b></td><td colspan="3"></td></tr></table><br />';
        echo '<button type="submit" name="CommitBatch">' . _('Accept and Process Payment') . '</button>';
    }
} else {
    /*a supplier is selected or the GL link is not active then set out
    the fields for entry of receipt amt and disc */
    if ($_SESSION['PaymentDetail' . $identifier]->Amount == 0) {
        echo '<table class="selection"><tr><td>' . _('Amount of Payment') . ' ' . $_SESSION['PaymentDetail' . $identifier]->Currency . ':</td>
				<td><input class="number" type="text" name="Amount" maxlength="12" size="13" value="' . locale_money_format(0, $_SESSION['PaymentDetail' . $identifier]->Currency) . '" /></td></tr>';
    } else {
        echo '<table class="selection"><tr><td>' . _('Amount of Payment') . ' ' . $_SESSION['PaymentDetail' . $identifier]->Currency . ':</td>
				<td><input class="number" type="text" name="Amount" maxlength="12" size="13" value="' . locale_money_format($_SESSION['PaymentDetail' . $identifier]->Amount, $_SESSION['PaymentDetail' . $identifier]->Currency) . '" /></td></tr>';
    }
    if (isset($_SESSION['PaymentDetail' . $identifier]->SupplierID)) {

开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:31，代码来源:Payments.php

示例10: filter_currency_input

        /* Need to see if there is also a price entered that has an end date after the start date of this price and if
        		so we will need to update it so there is no ambiguity as to which price will be used*/
        //editing an existing price
        $sql = "UPDATE prices SET\n\t\t\t\t\ttypeabbrev='" . $_POST['TypeAbbrev'] . "',\n\t\t\t\t\tcurrabrev='" . $_POST['CurrAbrev'] . "',\n\t\t\t\t\tprice='" . filter_currency_input($_POST['Price']) . "',\n\t\t\t\t\tunits='" . $_POST['Units'] . "',\n\t\t\t\t\tconversionfactor='" . $_POST['ConversionFactor'] . "',\n\t\t\t\t\tdecimalplaces='" . $_POST['DecimalPlaces'] . "',\n\t\t\t\t\tstartdate='" . FormatDateForSQL($_POST['StartDate']) . "',\n\t\t\t\t\tenddate='" . $SQLEndDate . "'\n\t\t\t\tWHERE prices.stockid='" . $Item . "'\n\t\t\t\tAND startdate='" . $_POST['OldStartDate'] . "'\n\t\t\t\tAND enddate ='" . $_POST['OldEndDate'] . "'\n\t\t\t\tAND prices.typeabbrev='" . $_POST['OldTypeAbbrev'] . "'\n\t\t\t\tAND prices.currabrev='" . $_POST['OldCurrAbrev'] . "'\n\t\t\t\tAND prices.debtorno=''";
        $ErrMsg = _('Could not be update the existing prices');
        $result = DB_query($sql, $db, $ErrMsg);
        ReSequenceEffectiveDates($Item, $_POST['TypeAbbrev'], $_POST['CurrAbrev'], $db);
        prnMsg(_('The price has been updated'), 'success');
        echo '<br />';
    } elseif ($InputError != 1) {
        /*Selected price is null cos no item selected on first time round so must be adding a	record must be submitting new entries in the new price form */
        $sql = "UPDATE prices SET\n\t\t\t\t\tenddate='" . date('Y-m-d') . "'\n\t\t\t\tWHERE prices.stockid='" . $Item . "'\n\t\t\t\tAND startdate='" . FormatDateForSQL($_POST['StartDate']) . "'\n\t\t\t\tAND enddate ='" . $SQLEndDate . "'\n\t\t\t\tAND prices.typeabbrev='" . $_POST['TypeAbbrev'] . "'\n\t\t\t\tAND prices.currabrev='" . $_POST['CurrAbrev'] . "'\n\t\t\t\tAND prices.debtorno=''";
        $ErrMsg = _('Could not be update the existing prices');
        $result = DB_query($sql, $db, $ErrMsg);
        ReSequenceEffectiveDates($Item, $_POST['TypeAbbrev'], $_POST['CurrAbrev'], $db);
        $sql = "INSERT INTO prices (stockid,\n\t\t\t\t\t\t\t\t\ttypeabbrev,\n\t\t\t\t\t\t\t\t\tcurrabrev,\n\t\t\t\t\t\t\t\t\tunits,\n\t\t\t\t\t\t\t\t\tconversionfactor,\n\t\t\t\t\t\t\t\t\tdecimalplaces,\n\t\t\t\t\t\t\t\t\tstartdate,\n\t\t\t\t\t\t\t\t\tenddate,\n\t\t\t\t\t\t\t\t\tprice)\n\t\t\t\t\t\t\tVALUES ('" . $Item . "',\n\t\t\t\t\t\t\t\t'" . $_POST['TypeAbbrev'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['CurrAbrev'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['Units'] . "',\n\t\t\t\t\t\t\t\t'" . filter_number_input($_POST['ConversionFactor']) . "',\n\t\t\t\t\t\t\t\t'" . $_POST['DecimalPlaces'] . "',\n\t\t\t\t\t\t\t\t'" . FormatDateForSQL($_POST['StartDate']) . "',\n\t\t\t\t\t\t\t\t'" . $SQLEndDate . "',\n\t\t\t\t\t\t\t\t'" . filter_currency_input($_POST['Price']) . "')";
        $ErrMsg = _('The new price could not be added');
        $result = DB_query($sql, $db, $ErrMsg);
        ReSequenceEffectiveDates($Item, $_POST['TypeAbbrev'], $_POST['CurrAbrev'], $db);
        prnMsg(_('The new price has been inserted'), 'success');
        echo '<br />';
    }
    unset($_POST['Price']);
    unset($_POST['StartDate']);
    unset($_POST['EndDate']);
    unset($_POST['Units']);
    unset($_POST['ConversionFactor']);
    unset($_POST['DecimalPlaces']);
} elseif (isset($_GET['delete'])) {
    //the link to delete a selected record was clicked instead of the submit button
    $sql = "DELETE FROM prices\n\t\t\t\tWHERE prices.stockid = '" . $Item . "'\n\t\t\t\tAND prices.typeabbrev='" . $_GET['TypeAbbrev'] . "'\n\t\t\t\tAND prices.currabrev ='" . $_GET['CurrAbrev'] . "'\n\t\t\t\tAND  prices.startdate = '" . $_GET['StartDate'] . "'\n\t\t\t\tAND  prices.enddate = '" . $_GET['EndDate'] . "'\n\t\t\t\tAND prices.debtorno=''";

开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:31，代码来源:Prices.php

示例11: prnMsg

    } else {
        prnMsg(_('The other contract requirements cannot be altered because the customer has already placed the order'), 'warn');
    }
}
if (isset($_POST['EnterNewRequirement'])) {
    $InputError = false;
    if (!is_numeric(filter_number_input($_POST['Quantity']))) {
        prnMsg(_('The quantity of the new requirement is expected to be numeric'), 'error');
        $InputError = true;
    }
    if (!is_numeric(filter_currency_input($_POST['CostPerUnit']))) {
        prnMsg(_('The cost per unit of the new requirement is expected to be numeric'), 'error');
        $InputError = true;
    }
    if (!$InputError) {
        $_SESSION['Contract' . $identifier]->Add_To_ContractRequirements($_POST['RequirementDescription'], filter_number_input($_POST['Quantity']), filter_currency_input($_POST['CostPerUnit']));
        unset($_POST['RequirementDescription']);
        unset($_POST['Quantity']);
        unset($_POST['CostPerUnit']);
    }
}
/* This is where the other requirement as entered/modified should be displayed reflecting any deletions or insertions*/
echo '<form name="ContractReqtsForm" action="' . htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8') . '?identifier=' . $identifier . '" method="post">';
echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';
echo '<p class="page_title_text"><img src="' . $rootpath . '/css/' . $theme . '/images/contract.png" title="' . _('Contract Other Requirements') . '" alt="" />  ' . _('Contract Other Requirements') . ' - ' . $_SESSION['Contract' . $identifier]->CustomerName . '</p>';
if (count($_SESSION['Contract' . $identifier]->ContractReqts) > 0) {
    echo '<table cellpadding="2" class="selection">';
    if (isset($_SESSION['Contract' . $identifier]->ContractRef)) {
        echo '<tr><th colspan="5">' . _('Contract Reference:') . ' ' . $_SESSION['Contract' . $identifier]->ContractRef . '</th></tr>';
    }
    echo '<tr>

开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:31，代码来源:ContractOtherReqts.php

示例12: _

if (isset($_POST['Update']) and $_POST['RowCounter'] > 1) {
    for ($Counter = 1; $Counter <= $_POST['RowCounter']; $Counter++) {
        if (isset($_POST['Clear_' . $Counter]) and $_POST['Clear_' . $Counter] == True) {
            /*Get amount to be cleared */
            $sql = "SELECT amount,\n\t\t\t\t\t\t\texrate\n\t\t\t\t\t\tFROM banktrans\n\t\t\t\t\t\tWHERE banktransid='" . $_POST['BankTrans_' . $Counter] . "'";
            $ErrMsg = _('Could not retrieve transaction information');
            $result = DB_query($sql, $db, $ErrMsg);
            $myrow = DB_fetch_array($result);
            $AmountCleared = round($myrow[0] / $myrow[1], 2);
            /*Update the banktrans recoord to match it off */
            $sql = "UPDATE banktrans SET amountcleared= '" . $AmountCleared . "'\n\t\t\t\t\t\t\t\t\tWHERE banktransid='" . $_POST['BankTrans_' . $Counter] . "'";
            $ErrMsg = _('Could not match off this payment because');
            $result = DB_query($sql, $db, $ErrMsg);
        } elseif (isset($_POST['AmtClear_' . $Counter]) and filter_currency_input($_POST['AmtClear_' . $Counter]) < 0 and $Type == 'Payments' or $Type == 'Receipts' and isset($_POST['AmtClear_' . $Counter]) and filter_currency_input($_POST['AmtClear_' . $Counter]) > 0) {
            /*if the amount entered was numeric and negative for a payment or positive for a receipt */
            $sql = "UPDATE banktrans SET amountcleared=" . filter_currency_input($_POST['AmtClear_' . $Counter]) . "\n\t\t\t\t\t WHERE banktransid='" . $_POST['BankTrans_' . $Counter] . "'";
            $ErrMsg = _('Could not update the amount matched off this bank transaction because');
            $result = DB_query($sql, $db, $ErrMsg);
        } elseif (isset($_POST['Unclear_' . $Counter]) and $_POST['Unclear_' . $Counter] == True) {
            $sql = "UPDATE banktrans SET amountcleared = 0\n\t\t\t\t\t WHERE banktransid='" . $_POST['BankTrans_' . $Counter] . "'";
            $ErrMsg = _('Could not unclear this bank transaction because');
            $result = DB_query($sql, $db, $ErrMsg);
        }
    }
    /*Show the updated position with the same criteria as previously entered*/
    $_POST['ShowTransactions'] = True;
}
echo '<div class="page_help_text">' . _('Use this screen to match webERP Receipts and Payments to your Bank Statement.  Check your bank statement and click the check-box when you find the matching transaction.') . '</div><br />';
echo '<form action="' . htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8') . '" method="post">';
echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';
echo '<input type="hidden" name="Type" value="' . $Type . '" />';

开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:31，代码来源:BankMatching.php

示例13: VALUES

         if (!($Result = DB_query($SQL, $db))) {
             $error = 'Could not delete old allocation record';
         }
     }
     //			 if ($AllocnItem->OrigAlloc != $AllocnItem->AllocAmt) // has previous allocated amount changed?
     //			 {
     if ($AllocnItem->AllocAmt > 0) {
         $SQL = "INSERT INTO\n\t\t\t\t\t\t\t\tcustallocns (\n\t\t\t\t\t\t\t\tdatealloc,\n\t\t\t\t\t\t\t\tamt,\n\t\t\t\t\t\t\t\ttransid_allocfrom,\n\t\t\t\t\t\t\t\ttransid_allocto\n\t\t\t\t\t\t\t) VALUES (\n\t\t\t\t\t\t\t\t'" . date('Y-m-d') . "',\n\t\t\t\t\t\t\t\t'" . $AllocnItem->AllocAmt . "',\n\t\t\t\t\t\t\t\t'" . $_SESSION['Alloc']->AllocTrans . "',\n\t\t\t\t\t\t\t\t'" . $AllocnItem->ID . "'\n\t\t\t\t\t\t\t)";
         if (!($Result = DB_query($SQL, $db))) {
             $error = 'Could not change allocation record';
         }
     }
     $NewAllocTotal = $AllocnItem->PrevAlloc + $AllocnItem->AllocAmt;
     $AllAllocations = $AllAllocations + $AllocnItem->AllocAmt;
     $Settled = abs(filter_currency_input($NewAllocTotal - $AllocnItem->TransAmount)) < 0.005 ? 1 : 0;
     $SQL = "UPDATE debtortrans\n\t\t\t\t\t\tSET diffonexch='" . $AllocnItem->DiffOnExch . "',\n\t\t\t\t\t\talloc = '" . filter_currency_input($NewAllocTotal) . "',\n\t\t\t\t\t\tsettled = '" . $Settled . "'\n\t\t\t\t\t\tWHERE id = '" . $AllocnItem->ID . "'";
     if (!($Result = DB_query($SQL, $db))) {
         $error = 'Could not update difference on exchange';
     }
     //			 }
 }
 $Settled = abs($TotalAllocated + $_SESSION['Alloc']->TransAmt) < 0.01 ? 1 : 0;
 // Update the receipt or credit note
 $SQL = "UPDATE debtortrans\n\t\t\t\tSET alloc = '" . -$AllAllocations . "',\n\t\t\t\tdiffonexch = '" . -$TotalDiffOnExch . "',\n\t\t\t\tsettled='" . $Settled . "'\n\t\t\t\tWHERE id = '" . $_POST['AllocTrans'] . "'";
 if (!($Result = DB_query($SQL, $db))) {
     $error = 'Could not update receipt or credit note';
 }
 // If GLLink to debtors active post diff on exchange to GL
 $MovtInDiffOnExch = -$_SESSION['Alloc']->PrevDiffOnExch - $TotalDiffOnExch;
 if ($MovtInDiffOnExch != 0) {
     if ($_SESSION['CompanyRecord']['gllink_debtors'] == 1) {

开发者ID:patmark，项目名称:weberp-elct，代码行数:31，代码来源:CustomerAllocations.php

示例14: date

     }
     $SQLTestExists = "SELECT price FROM prices\n\t\t\t\t\t\t\t\t\t\tWHERE stockid = '" . $_POST['StockID_' . $PriceCounter] . "'\n\t\t\t\t\t\t\t\t\tAND prices.typeabbrev ='" . $_POST['SalesType'] . "'\n\t\t\t\t\t\t\t\t\tAND prices.currabrev ='" . $_POST['CurrCode'] . "'\n\t\t\t\t\t\t\t\t\tAND prices.debtorno ='" . $_POST['DebtorNo_' . $PriceCounter] . "'\n\t\t\t\t\t\t\t\t\tAND prices.branchcode ='" . $_POST['BranchCode_' . $PriceCounter] . "'\n\t\t\t\t\t\t\t\t\tAND prices.startdate<='" . date('Y-m-d') . "'\n\t\t\t\t\t\t\t\t\tAND prices.enddate>'" . date('Y-m-d') . "'";
     $TestExistsResult = DB_query($SQLTestExists, $db);
     if (DB_num_rows($TestExistsResult) == 1) {
         //then we are updating
         $SQLUpdate = "UPDATE prices\n\t\t\t\t\t\t\t\t\tSET price = '" . filter_currency_input($_POST['Price_' . $PriceCounter]) . "'\n\t\t\t\t\t\t\t\tWHERE stockid = '" . $_POST['StockID_' . $PriceCounter] . "'\n\t\t\t\t\t\t\t\t\tAND prices.typeabbrev ='" . $_POST['SalesType'] . "'\n\t\t\t\t\t\t\t\t\tAND prices.currabrev ='" . $_POST['CurrCode'] . "'\n\t\t\t\t\t\t\t\t\tAND prices.debtorno ='" . $_POST['DebtorNo_' . $PriceCounter] . "'\n\t\t\t\t\t\t\t\t\tAND prices.branchcode ='" . $_POST['BranchCode_' . $PriceCounter] . "'\n\t\t\t\t\t\t\t\t\tAND prices.units ='" . $_POST['Units_' . $PriceCounter] . "'\n\t\t\t\t\t\t\t\t\tAND prices.conversionfactor ='" . filter_number_input($_POST['ConversionFactor_' . $PriceCounter]) . "'\n\t\t\t\t\t\t\t\t\tAND prices.startdate<='" . date('Y-m-d') . "'";
         $ResultUpdate = DB_query($SQLUpdate, $db);
         if (DB_error_no($db) == 0) {
             prnMsg(_('The price for') . ' ' . $_POST['StockID_' . $PriceCounter] . ' ' . _('has been updated in the database'), 'success');
         } else {
             prnMsg(_('The price for') . ' ' . $_POST['StockID_' . $PriceCounter] . ' ' . _('could not be updated'), 'error');
         }
         echo '<br />';
     } else {
         //we need to add a new price from today
         $SQLInsert = "INSERT INTO prices (\n\t\t\t\t\t\t\tstockid,\n\t\t\t\t\t\t\tprice,\n\t\t\t\t\t\t\ttypeabbrev,\n\t\t\t\t\t\t\tcurrabrev,\n\t\t\t\t\t\t\tdebtorno,\n\t\t\t\t\t\t\tbranchcode,\n\t\t\t\t\t\t\tstartdate,\n\t\t\t\t\t\t\tenddate,\n\t\t\t\t\t\t\tunits,\n\t\t\t\t\t\t\tconversionfactor\n\t\t\t\t\t\t) VALUES (\n\t\t\t\t\t\t\t'" . $_POST['StockID_' . $PriceCounter] . "',\n\t\t\t\t\t\t\t'" . filter_currency_input($_POST['Price_' . $PriceCounter]) . "',\n\t\t\t\t\t\t\t'" . $_POST['SalesType'] . "',\n\t\t\t\t\t\t\t'" . $_POST['CurrCode'] . "',\n\t\t\t\t\t\t\t'" . $_POST['DebtorNo_' . $PriceCounter] . "',\n\t\t\t\t\t\t\t'" . $_POST['BranchCode_' . $PriceCounter] . "',\n\t\t\t\t\t\t\t'" . date('Y-m-d') . "',\n\t\t\t\t\t\t\t'2030-01-01',\n\t\t\t\t\t\t\t'" . $_POST['Units_' . $PriceCounter] . "',\n\t\t\t\t\t\t\t'" . filter_number_input($_POST['ConversionFactor_' . $PriceCounter]) . "'\n\t\t\t\t\t\t)";
         $ResultInsert = DB_query($SQLInsert, $db);
         if (DB_error_no($db) == 0) {
             prnMsg(_('The price for') . ' ' . $_POST['StockID_' . $PriceCounter] . ' ' . _('has been inserted in the database'), 'success');
         } else {
             prnMsg(_('The price for') . ' ' . $_POST['StockID_' . $PriceCounter] . ' ' . _('could not be inserted'), 'error');
         }
         echo '<br />';
     }
     $PriceCounter++;
 }
 DB_free_result($result);
 //clear the old result
 $result = DB_query($sql, $db);
 //re-run the query with the updated prices
 $numrow = DB_num_rows($result);

开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:31，代码来源:PricesByCost.php

示例15: banktrans

     $SQL = "INSERT INTO banktrans (type,\n\t\t\t\t\t\t\t\t\t\ttransno,\n\t\t\t\t\t\t\t\t\t\tbankact,\n\t\t\t\t\t\t\t\t\t\tref,\n\t\t\t\t\t\t\t\t\t\texrate,\n\t\t\t\t\t\t\t\t\t\tfunctionalexrate,\n\t\t\t\t\t\t\t\t\t\ttransdate,\n\t\t\t\t\t\t\t\t\t\tbanktranstype,\n\t\t\t\t\t\t\t\t\t\tamount,\n\t\t\t\t\t\t\t\t\t\tcurrcode)\n\t\t\t\t\t\t\t\t\tVALUES (\n\t\t\t\t\t\t\t\t\t\t12,\n\t\t\t\t\t\t\t\t\t\t'" . $ReceiptNumber . "',\n\t\t\t\t\t\t\t\t\t\t'" . $_POST['BankAccount'] . "',\n\t\t\t\t\t\t\t\t\t\t'" . $_SESSION['Items' . $identifier]->LocationName . ' ' . _('Counter Sale') . ' ' . $InvoiceNo . "',\n\t\t\t\t\t\t\t\t\t\t'" . $ExRate . "',\n\t\t\t\t\t\t\t\t\t\t'" . $BankAccountExRate . "',\n\t\t\t\t\t\t\t\t\t\t'" . $DefaultDispatchDate . "',\n\t\t\t\t\t\t\t\t\t\t'" . $_POST['PaymentMethod'] . "',\n\t\t\t\t\t\t\t\t\t\t'" . filter_currency_input(filter_currency_input($_POST['AmountPaid']) * $BankAccountExRate) . "',\n\t\t\t\t\t\t\t\t\t\t'" . $_SESSION['Items' . $identifier]->DefaultCurrency . "')";
     $DbgMsg = _('The SQL that failed to insert the bank account transaction was');
     $ErrMsg = _('Cannot insert a bank transaction');
     $result = DB_query($SQL, $db, $ErrMsg, $DbgMsg, true);
     //insert a new debtortrans for the receipt
     $SQL = "INSERT INTO debtortrans (transno,\n\t\t\t\t\t\t\t\t\t\t\ttype,\n\t\t\t\t\t\t\t\t\t\t\tdebtorno,\n\t\t\t\t\t\t\t\t\t\t\ttrandate,\n\t\t\t\t\t\t\t\t\t\t\tinputdate,\n\t\t\t\t\t\t\t\t\t\t\tprd,\n\t\t\t\t\t\t\t\t\t\t\treference,\n\t\t\t\t\t\t\t\t\t\t\trate,\n\t\t\t\t\t\t\t\t\t\t\tovamount,\n\t\t\t\t\t\t\t\t\t\t\talloc,\n\t\t\t\t\t\t\t\t\t\t\tinvtext,\n\t\t\t\t\t\t\t\t\t\t\tsettled)\n\t\t\t\t\t\t\t\t\t\tVALUES (\n\t\t\t\t\t\t\t\t\t\t\t'" . $ReceiptNumber . "',\n\t\t\t\t\t\t\t\t\t\t\t12,\n\t\t\t\t\t\t\t\t\t\t\t'" . $_SESSION['Items' . $identifier]->DebtorNo . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . $DefaultDispatchDate . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . date('Y-m-d H-i-s') . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . $PeriodNo . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . $InvoiceNo . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . $ExRate . "',\n\t\t\t\t\t\t\t\t\t\t\t'-" . filter_currency_input($_POST['AmountPaid']) . "',\n\t\t\t\t\t\t\t\t\t\t\t'-" . filter_currency_input($_POST['AmountPaid']) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . $_SESSION['Items' . $identifier]->LocationName . ' ' . _('Counter Sale') . "',\n\t\t\t\t\t\t\t\t\t\t\t'1')";
     $DbgMsg = _('The SQL that failed to insert the customer receipt transaction was');
     $ErrMsg = _('Cannot insert a receipt transaction against the customer because');
     $result = DB_query($SQL, $db, $ErrMsg, $DbgMsg, true);
     $ReceiptDebtorTransID = DB_Last_Insert_ID($db, 'debtortrans', 'id');
     $SQL = "UPDATE debtorsmaster SET lastpaiddate = '" . $DefaultDispatchDate . "',\n\t\t\t\t\t\t\t\t\t\t\tlastpaid='" . filter_currency_input($_POST['AmountPaid']) . "'\n\t\t\t\t\t\t\t\t\tWHERE debtorsmaster.debtorno='" . $_SESSION['Items' . $identifier]->DebtorNo . "'";
     $DbgMsg = _('The SQL that failed to update the date of the last payment received was');
     $ErrMsg = _('Cannot update the customer record for the date of the last payment received because');
     $result = DB_query($SQL, $db, $ErrMsg, $DbgMsg, true);
     //and finally add the allocation record between receipt and invoice
     $SQL = "IN

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP filter_db_can_delete_filter函数代码示例发布时间：2022-05-15

PHP filter_configure函数代码示例发布时间：2022-05-15

PacktPublishing/Python-Machine-Learning-

1 dustinvtran/ml-videos: A collection of v

dustinvtran/ml-videos: A collection of video resources for machine learning

阅读：1354|2022-08-19

2 delphi中WMI的使用（二）

首先，来总结一下Win32_OperatingSystem，这个类里面常用的属性有：caption:操作系统

阅读：546|2022-07-18

3 ravikumar001/maven

ravikumar001/maven

阅读：789|2022-08-17

4 更的笔顺,体会更的笔画,理会更的部首

更的笔顺是什么?更的笔顺笔画顺序怎么写？还有更的拼音及意思是什么，好多初学练字者

阅读：681|2022-11-06

5 Delphi如何处理不同类型的文件

参考：http://www.cnblogs.com/railgunman/articles/1800318.html程序设计当中，我们

阅读：2172|2022-07-22

6 ceejbot/LOUDBOT: AUTOMATED SHOUTING FOR

ceejbot/LOUDBOT: AUTOMATED SHOUTING FOR MASTODON

阅读：1652|2022-08-18

7 kali-docs-cn/kali-linux-web-pentest-cook

kali-docs-cn/kali-linux-web-pentest-cookbook-zh: Kali Linux Web 渗透测试秘籍中

阅读：771|2022-08-15

8 liangtengyu/to_markdown: 一键解析Markdow

liangtengyu/to_markdown: 一键解析Markdown 目前支持: 微信公众号,知乎,知乎专栏,简

阅读：1008|2022-08-18

9 delphi 接口

http://blog.csdn.net/lailai186/article/details/7390397

阅读：734|2022-07-18

10 win7系统删除资源管理器里我们不想要的图标

win7系统电脑使用过程中有不少朋友表示遇到过win7系统删除资源管理器里我们不想要的图

阅读：720|2022-11-06

客服电话

电子邮件

PHP filter_currency_input函数代码示例

示例1: DB_query

示例2: foreach

示例3: _

示例4: DB_query

示例5: filter_currency_input

示例6: Allocation

示例7: _

示例8: _

示例9: DB_query

示例10: filter_currency_input

示例11: prnMsg

示例12: _

示例13: VALUES

示例14: date

示例15: banktrans

请发表评论

全部评论

上一篇：

下一篇：

bradtraversy/iweather: Ionic 3 mobile we

CVE-2022-34907

joaomh/curso-de-matlab

断牙刷新位置时间（断牙属性及刷新位置介绍

生死狙击账号密码真号（生死狙击账帐号好号

PacktPublishing/Python-Machine-Learning-

sussillo/hfopt-matlab: A parallel, cpu-b

鲁东大学一米网:Win7系统USB驱动器RAM的操

emersion/go-ostatus: An OStatus library

issus/altium-library: Open source Altium

微信小程序登录后实现数据绑定显示

关于我们

产品与服务

解决方案

139-2527-9053