PHP DB_free_result函數代碼示例

}
$SQL = "SELECT currabrev FROM currencies";
$result = DB_query($SQL);
require_once 'includes/CurrenciesArray.php';
echo '<table class="selection">';
echo '<tr><td>' . _('Currency') . ':</td>
	<td><select name="CurrAbrev">';
while ($myrow = DB_fetch_array($result)) {
    echo '<option';
    if ($myrow['currabrev'] == $_POST['CurrAbrev']) {
        echo ' selected="selected"';
    }
    echo ' value="' . $myrow['currabrev'] . '">' . $CurrencyName[$myrow['currabrev']] . '</option>';
}
// End while loop
DB_free_result($result);
echo '</select></td>';
$sql = "SELECT typeabbrev,\r\n\t\tsales_type\r\n\t\tFROM salestypes";
$result = DB_query($sql);
echo '<tr><td>' . _('Customer Price List') . ' (' . _('Sales Type') . '):</td><td>';
echo '<select tabindex="1" name="SalesType">';
while ($myrow = DB_fetch_array($result)) {
    if (isset($_POST['SalesType']) and $myrow['typeabbrev'] == $_POST['SalesType']) {
        echo '<option selected="selected" value="' . $myrow['typeabbrev'] . '">' . $myrow['sales_type'] . '</option>';
    } else {
        echo '<option value="' . $myrow['typeabbrev'] . '">' . $myrow['sales_type'] . '</option>';
    }
}
echo '</select></td></tr>';
if (isset($_GET['StockID'])) {
    $StockID = trim($_GET['StockID']);

 $Changes = 0;
 while ($myrow = DB_fetch_array($Result)) {
     if ($_SESSION['Items']->LineItems[$myrow['orderlineno']]->Quantity != $myrow['quantity'] or $_SESSION['Items']->LineItems[$myrow['orderlineno']]->QtyInv != $myrow['qtyinvoiced']) {
         echo '<br>' . _('Orig order for') . ' ' . $myrow['orderlineno'] . ' ' . _('has a quantity of') . ' ' . $myrow['quantity'] . ' ' . _('and an invoiced qty of') . ' ' . $myrow['qtyinvoiced'] . ' ' . _('the session shows quantity of') . ' ' . $_SESSION['Items']->LineItems[$myrow['orderlineno']]->Quantity . ' ' . _('and quantity invoice of') . ' ' . $_SESSION['Items']->LineItems[$myrow['orderlineno']]->QtyInv;
         prnMsg(_('This order has been changed or invoiced since this delivery was started to be confirmed') . ' ' . _('Processing halted.') . ' ' . _('To enter and confirm this dispatch, it must be re-selected and re-read again to update the changes made by the other user'), 'error');
         echo '<br>';
         echo '<div class="centre"><a href="' . $rootpath . '/SelectSalesOrder.php?' . SID . '">' . _('Select a sales order for confirming deliveries and invoicing') . '</a></div>';
         unset($_SESSION['Items']->LineItems);
         unset($_SESSION['Items']);
         unset($_SESSION['ProcessingOrder']);
         include 'includes/footer.inc';
         exit;
     }
 }
 /*loop through all line items of the order to ensure none have been invoiced since started looking at this order*/
 DB_free_result($Result);
 /*Now Get the next invoice number - function in SQL_CommonFunctions*/
 $InvoiceNo = GetNextTransNo(10, $db);
 $PeriodNo = GetPeriod($DefaultDispatchDate, $db);
 /*Start an SQL transaction */
 DB_Txn_Begin($db);
 if ($DefaultShipVia != $_SESSION['Items']->ShipVia) {
     $SQL = "UPDATE custbranch SET defaultshipvia ='" . $_SESSION['Items']->ShipVia . "' WHERE debtorno='" . $_SESSION['Items']->DebtorNo . "' AND branchcode='" . $_SESSION['Items']->Branch . "'";
     $ErrMsg = _('Could not update the default shipping carrier for this branch because');
     $DbgMsg = _('The SQL used to update the branch default carrier was');
     $result = DB_query($SQL, $db, $ErrMsg, $DbgMsg, true);
 }
 $DefaultDispatchDate = FormatDateForSQL($DefaultDispatchDate);
 /*Update order header for invoice charged on */
 $SQL = "UPDATE salesorders SET comments = CONCAT(comments,' Inv ','" . $InvoiceNo . "') WHERE orderno= " . $_SESSION['ProcessingOrder'];
 $ErrMsg = _('CRITICAL ERROR') . ' ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The sales order header could not be updated with the invoice number');

 $sql = "SELECT materialcost,\n\t\t\t\t\tlabourcost,\n\t\t\t\t\toverheadcost,\n\t\t\t\t\tmbflag,\n\t\t\t\t\tsum(quantity) as totalqoh\n\t\t\tFROM stockmaster INNER JOIN locstock\n\t\t\tON stockmaster.stockid=locstock.stockid\n\t\t\tWHERE stockmaster.stockid='" . $StockID . "'\n\t\t\tGROUP BY description,\n\t\t\t\t\tunits,\n\t\t\t\t\tlastcost,\n\t\t\t\t\tactualcost,\n\t\t\t\t\tmaterialcost,\n\t\t\t\t\tlabourcost,\n\t\t\t\t\toverheadcost,\n\t\t\t\t\tmbflag";
 $ErrMsg = _('The entered item code does not exist');
 $OldResult = DB_query($sql, $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 = $_POST['OldMaterialCost'] + $_POST['OldLabourCost'] + $_POST['OldOverheadCost'];
 $NewCost = filter_number_format($_POST['MaterialCost']) + filter_number_format($_POST['LabourCost']) + filter_number_format($_POST['OverheadCost']);
 $result = DB_query("SELECT * FROM stockmaster WHERE stockid='" . $StockID . "'");
 $myrow = DB_fetch_row($result);
 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();
     ItemCostUpdateGL($db, $StockID, $NewCost, $OldCost, $_POST['QOH']);
     $SQL = "UPDATE stockmaster SET\tmaterialcost='" . filter_number_format($_POST['MaterialCost']) . "',\n\t\t\t\t\t\t\t\t\t\tlabourcost='" . filter_number_format($_POST['LabourCost']) . "',\n\t\t\t\t\t\t\t\t\t\toverheadcost='" . filter_number_format($_POST['OverheadCost']) . "',\n\t\t\t\t\t\t\t\t\t\tlastcost='" . $OldCost . "',\n\t\t\t\t\t\t\t\t\t\tlastcostupdate ='" . Date('Y-m-d') . "'\n\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, $ErrMsg, $DbgMsg, true);
     $Result = DB_Txn_Commit();
     UpdateCost($db, $StockID);

if (isset($_POST['StockType']) and $_POST['StockType'] == 'L') {
    echo _('Labour Efficiency Variance GL Code');
} else {
    echo _('Usage Variance GL Code');
}
echo ':</td>
		<td><select name="MaterialUseageVarAc">';
while ($myrow = DB_fetch_array($PnLAccountsResult)) {
    if (isset($_POST['MaterialUseageVarAc']) and $myrow['accountcode'] == $_POST['MaterialUseageVarAc']) {
        echo '<option selected="selected" value="' . $myrow['accountcode'] . '">' . htmlspecialchars($myrow['accountname'], ENT_QUOTES, 'UTF-8', false) . ' (' . $myrow['accountcode'] . ')' . '</option>';
    } else {
        echo '<option value="' . $myrow['accountcode'] . '">' . htmlspecialchars($myrow['accountname'], ENT_QUOTES, 'UTF-8', false) . ' (' . $myrow['accountcode'] . ')' . '</option>';
    }
}
//end while loop
DB_free_result($PnLAccountsResult);
echo '</select></td>
		</tr>
		</table>';
if (!isset($SelectedCategory)) {
    $SelectedCategory = '';
}
if (isset($SelectedCategory)) {
    //editing an existing stock category
    $sql = "SELECT stkcatpropid,\n\t\t\t\t\tlabel,\n\t\t\t\t\tcontroltype,\n\t\t\t\t\tdefaultvalue,\n\t\t\t\t\tnumericvalue,\n\t\t\t\t\treqatsalesorder,\n\t\t\t\t\tminimumvalue,\n\t\t\t\t\tmaximumvalue\n\t\t\t   FROM stockcatproperties\n\t\t\t   WHERE categoryid='" . $SelectedCategory . "'\n\t\t\t   ORDER BY stkcatpropid";
    $result = DB_query($sql);
    /*		echo '<br />Number of rows returned by the sql = ' . DB_num_rows($result) .
    			'<br />The SQL was:<br />' . $sql;
    */
    echo '<br />
			<table class="selection">

include 'includes/header.inc';
include 'includes/SQL_CommonFunctions.inc';
$ModuleList = array(_('Orders'), _('Receivables'), _('Payables'), _('Purchasing'), _('Inventory'), _('Manufacturing'), _('General Ledger'), _('Asset Manager'), _('Petty Cash'), _('Setup'));
echo '<a href="' . $rootpath . '/SelectSupplier.php?">' . _('Back to Suppliers') . '</a><br />';
echo '<p class="page_title_text"><img src="' . $rootpath . '/css/' . $theme . '/images/supplier.png" title="' . _('Supplier') . '" alt="" />' . ' ' . _('Supplier') . ' : ' . $_SESSION['SupplierID'] . _(' has been selected') . '</p><br />';
//Make an array of the security roles where only one role is active and is ID 1
//For the security role selection box, we will only show roles that have:
//- Only one entry in securitygroups AND the tokenid of this entry == 1
//First get all available security role ID's'
$sql = "SELECT secroleid, secrolename FROM securityroles WHERE secrolename = 'Supplier Log On Only'";
$Sec_Result = DB_query($sql, $db);
// Now load it into an aray using Key/Value pairs
while ($Sec_row = DB_fetch_array($Sec_Result)) {
    $SecurityRoles[$Sec_row['secroleid']] = $Sec_row['secrolename'];
}
DB_free_result($Sec_Result);
if (isset($_GET['SelectedUser'])) {
    $SelectedUser = $_GET['SelectedUser'];
} elseif (isset($_POST['SelectedUser'])) {
    $SelectedUser = $_POST['SelectedUser'];
}
if (isset($_POST['submit'])) {
    //initialise no input errors assumed initially before we test
    $InputError = 0;
    /* actions to take once the user has clicked the submit button
    	ie the page has called itself with some user input */
    //first off validate inputs sensible
    if (mb_strlen($_POST['UserID']) < 3) {
        $InputError = 1;
        prnMsg(_('The user ID entered must be at least 4 characters long'), 'error');
    } elseif (ContainsIllegalCharacters($_POST['UserID'])) {

// $ForceConfigReload to true
if (isset($ForceConfigReload) or !isset($_SESSION['CompanyDefaultsLoaded'])) {
    $sql = 'SELECT confname, confvalue FROM config';
    // dont care about the order by
    $ConfigResult = DB_query($sql, $db);
    while ($myrow = DB_fetch_row($ConfigResult)) {
        if (is_numeric($myrow[1])) {
            //the variable name is given by $myrow[0]
            $_SESSION[$myrow[0]] = (double) $myrow[1];
        } else {
            $_SESSION[$myrow[0]] = $myrow[1];
        }
    }
    //end loop through all config variables
    $_SESSION['CompanyDefaultsLoaded'] = true;
    DB_free_result($ConfigResult);
    // no longer needed
    /* Also reads all the company data set up in the company record and returns an array */
    $sql = "SELECT\n\t\tcoyname,\n\t\tgstno,\n\t\tregoffice1,\n\t\tregoffice2,\n\t\tregoffice3,\n\t\tregoffice4,\n\t\tregoffice5,\n\t\tregoffice6,\n\t\ttelephone,\n\t\tfax,\n\t\temail,\n\t\tcurrencydefault,\n\t\tdebtorsact,\n\t\tpytdiscountact,\n\t\tcreditorsact,\n\t\tpayrollact,\n\t\tgrnact,\n\t\texchangediffact,\n\t\tpurchasesexchangediffact,\n\t\tretainedearnings,\n\t\tfreightact,\n\t\tgllink_debtors,\n\t\tgllink_creditors,\n\t\tgllink_stock\n\tFROM companies\n\tWHERE coycode=1";
    $ErrMsg = _('An error occurred accessing the database to retrieve the company information');
    $ReadCoyResult = DB_query($sql, $db, $ErrMsg);
    if (DB_num_rows($ReadCoyResult) == 0) {
        echo '<BR><B>';
        prnMsg(_('The company record has not yet been set up') . '</B><BR>' . _('From the system setup tab select company maintenance to enter the company infomation and system preferences'), 'error', _('CRITICAL PROBLEM'));
        exit;
    } else {
        $_SESSION['CompanyRecord'] = DB_fetch_array($ReadCoyResult);
    }
}
//end if force reload or not set already
/*	

 $sql = "SELECT  materialcost,\n                    labourcost,\n                    overheadcost,\n                    mbflag,\n                    sum(quantity) as totalqoh\n                FROM stockmaster INNER JOIN locstock\n                    ON stockmaster.stockid=locstock.stockid\n                WHERE stockmaster.stockid='" . $StockID . "'\n                GROUP BY description,\n                    units,\n                    lastcost,\n                    actualcost,\n                    materialcost,\n                    labourcost,\n                    overheadcost,\n                    mbflag";
 $ErrMsg = _('The entered item code does not exist');
 $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 = $_POST['OldMaterialCost'] + $_POST['OldLabourCost'] + $_POST['OldOverheadCost'];
 $NewCost = $_POST['MaterialCost'] + $_POST['LabourCost'] + $_POST['OverheadCost'];
 $result = DB_query("SELECT * FROM stockmaster WHERE stockid='{$StockID}'", $db);
 $myrow = DB_fetch_row($result);
 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\n\t\t\t\t\tmaterialcost=" . $_POST['MaterialCost'] . ",\n\t\t\t\t\tlabourcost=" . $_POST['LabourCost'] . ",\n\t\t\t\t\toverheadcost=" . $_POST['OverheadCost'] . ",\n\t\t\t\t\tlastcost=" . $OldCost . "\n\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);

            echo '<br />' . $SQL;
        }
        include 'includes/footer.inc';
        exit;
    }
    $CSVContent = stripcomma('stockid') . ',' . stripcomma('description') . ',' . stripcomma('barcode') . ',' . stripcomma('units') . ',' . stripcomma('mbflag') . ',' . stripcomma('taxcatid') . ',' . stripcomma('discontinued') . ',' . stripcomma('price') . ',' . stripcomma('qty') . ',' . stripcomma('categoryid') . ',' . stripcomma('categorydescription') . "\n";
    while ($PriceList = DB_fetch_array($PricesResult, $db)) {
        $Qty = 0;
        $sqlQty = "SELECT newqoh\n\t\t\tFROM stockmoves\n\t\t\tWHERE stockid = '" . $PriceList['stockid'] . "'\n\t\t\tAND loccode = '" . $_POST['Location'] . "'\n\t\t\tORDER BY stkmoveno DESC LIMIT 1";
        $resultQty = DB_query($sqlQty, $ErrMsg);
        if ($resultQty) {
            if (DB_num_rows($resultQty) > 0) {
                $Row = DB_fetch_row($resultQty);
                $Qty = $Row[0];
            }
            DB_free_result($resultQty);
        }
        $DisplayUnitPrice = $PriceList['price'];
        $CSVContent .= stripcomma($PriceList['stockid']) . ',' . stripcomma($PriceList['description']) . ',' . stripcomma($PriceList['barcode']) . ',' . stripcomma($PriceList['units']) . ',' . stripcomma($PriceList['mbflag']) . ',' . stripcomma($PriceList['taxcatid']) . ',' . stripcomma($PriceList['discontinued']) . ',' . stripcomma($DisplayUnitPrice) . ',' . stripcomma($Qty) . ',' . stripcomma($PriceList['categoryid']) . ',' . stripcomma($PriceList['categorydescription']) . "\n";
    }
    header('Content-type: application/csv');
    header('Content-Length: ' . mb_strlen($CSVContent));
    header('Content-Disposition: inline; filename=PriceList.csv');
    header('Expires: 0');
    header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
    header('Pragma: public');
    echo $CSVContent;
    exit;
} elseif (isset($_POST['custlist'])) {
    $SQL = "SELECT debtorsmaster.debtorno,\n\t\t\tcustbranch.branchcode,\n\t\t\tdebtorsmaster.name,\n\t\t\tcustbranch.contactname,\n\t\t\tdebtorsmaster.address1,\n\t\t\tdebtorsmaster.address2,\n\t\t\tdebtorsmaster.address3,\n\t\t\tdebtorsmaster.address4,\n\t\t\tdebtorsmaster.address5,\n\t\t\tdebtorsmaster.address6,\n\t\t\tdebtorsmaster.currcode,\n\t\t\tdebtorsmaster.clientsince,\n\t\t\tdebtorsmaster.creditlimit,\n\t\t\tdebtorsmaster.taxref,\n\t\t\tcustbranch.braddress1,\n\t\t\tcustbranch.braddress2,\n\t\t\tcustbranch.braddress3,\n\t\t\tcustbranch.braddress4,\n\t\t\tcustbranch.braddress5,\n\t\t\tcustbranch.braddress6,\n\t\t\tcustbranch.disabletrans,\n\t\t\tcustbranch.phoneno,\n\t\t\tcustbranch.faxno,\n\t\t\tcustbranch.email\n\t\tFROM debtorsmaster,\n\t\t\tcustbranch\n\t\tWHERE debtorsmaster.debtorno=custbranch.debtorno\n\t\tAND ((defaultlocation = '" . $_POST['Location'] . "') OR (defaultlocation = '') OR (defaultlocation IS NULL))";
    $CustResult = DB_query($SQL, '', '', false, false);

                    if ($j == 1) {
                        echo '<tr class="OddTableRows">';
                        $j = 0;
                    } else {
                        echo '<tr class="EvenTableRows">';
                        $j++;
                    }
                    echo '	<td>' . MonthAndYearFromSQLDate($TransRow['lastdate_in_period']) . '</td>
							<td>' . $TranDate . '</td>
							<td><a href="' . $URL . $DetailRow['otherpartycode'] . $FromDate . '">' . $TransRow['accountname'] . ' - ' . $DetailRow['otherparty'] . '</a></td>
							<td>' . $TransRow['narrative'] . '</td>
							<td class="number">' . $Debit . '</td>
							<td class="number">' . $Credit . '</td>
							<td>' . $Posted . '</td>
						</tr>';
                }
                DB_free_result($DetailResult);
                $AnalysisCompleted = 'Done';
            }
        }
        DB_free_result($TransResult);
        echo '<tr style="background-color:#FFFFFF">
				<td class="number" colspan="4"><b>' . _('Total') . '</b></td>
				<td class="number"><b>' . locale_number_format($DebitTotal, $_SESSION['CompanyRecord']['decimalplaces']) . '</b></td>
				<td class="number"><b>' . locale_number_format(-$CreditTotal, $_SESSION['CompanyRecord']['decimalplaces']) . '</b></td>
				<td>&nbsp;</td>
			</tr>
			</table>';
    }
}
include 'includes/footer.inc';

<?php

/* $Id: GetPaymentMethods.php 5768 2012-12-20 08:38:22Z daintree $*/
$PaytTypes = array();
$ReceiptTypes = array();
$sql = 'SELECT paymentname,
			paymenttype,
			receipttype
			FROM paymentmethods
			ORDER by paymentname';
$PMResult = DB_query($sql, $db);
while ($PMrow = DB_fetch_array($PMResult)) {
    if ($PMrow['paymenttype'] == 1) {
        $PaytTypes[] = $PMrow['paymentname'];
    }
    if ($PMrow['receipttype'] == 1) {
        $ReceiptTypes[] = $PMrow['paymentname'];
    }
}
DB_free_result($PMResult);
// no longer needed

        include 'includes/footer.inc';
        exit;
    }
    while ($GLRow = DB_fetch_array($GLTransResult)) {
        $LeftOvers = $pdf->addTextWrap($Left_Margin + 150, $YPos, 90, $FontSize, $GLRow['accountname'], 'left');
        $LeftOvers = $pdf->addTextWrap($Left_Margin + 245, $YPos, 60, $FontSize, locale_money_format($GLRow['amount'], $Currency), 'right');
        $LeftOvers = $pdf->addTextWrap($Left_Margin + 310, $YPos, 120, $FontSize, $GLRow['narrative'], 'left');
        $YPos -= $line_height;
        if ($YPos - 2 * $line_height < $Bottom_Margin) {
            /*Then set up a new page */
            $PageNumber++;
            include 'includes/PDFChequeListingPageHeader.inc';
        }
        /*end of new page header  */
    }
    DB_free_result($GLTransResult);
    $YPos -= $line_height;
    $TotalCheques = $TotalCheques - $myrow['amount'];
    if ($YPos - 2 * $line_height < $Bottom_Margin) {
        /*Then set up a new page */
        $PageNumber++;
        include 'includes/PDFChequeListingPageHeader.inc';
    }
    /*end of new page header  */
}
/* end of while there are customer receipts in the batch to print */
$YPos -= $line_height;
$LeftOvers = $pdf->addTextWrap($Left_Margin, $YPos, 60, $FontSize, locale_money_format($TotalCheques, $Currency), 'right');
$LeftOvers = $pdf->addTextWrap($Left_Margin + 65, $YPos, 300, $FontSize, _('TOTAL') . ' ' . $Currency . ' ' . _('CHEQUES'), 'left');
$ReportFileName = $_SESSION['DatabaseName'] . '_ChequeListing_' . date('Y-m-d') . '.pdf';
$pdf->OutputD($ReportFileName);

    $sql = "INSERT INTO chartdetails (accountcode, period)\n\t\t\tSELECT chartmaster.accountcode, periods.periodno\n\t\tFROM chartmaster CROSS JOIN periods\n\t\t\tLEFT JOIN chartdetails ON chartmaster.accountcode = chartdetails.accountcode\n\t\t\t\tAND periods.periodno = chartdetails.period\n\t\tWHERE (periods.periodno BETWEEN '" . $CreateFrom . "' AND '" . $CreateTo . "')\n\t\tAND chartdetails.accountcode IS NULL";
    $ErrMsg = _('Inserting new chart details records required failed because');
    $InsChartDetailsRecords = DB_query($sql, $db, $ErrMsg);
    while ($AccountRow = DB_fetch_array($ChartDetailsNotSetUpResult)) {
        /*Now run through each of the new chartdetail records created for each account and update them with the B/Fwd and B/Fwd budget no updates would be required where there were previously no chart details set up ie FirstPeriodPostedTo > 0 */
        $sql = "SELECT actual,\n\t\t\t\tbfwd,\n\t\t\t\tbudget,\n\t\t\t\tbfwdbudget,\n\t\t\t\tperiod\n\t\t\tFROM chartdetails\n\t\t\tWHERE period >='" . ($AccountRow['period'] - 1) . "'\n\t\t\tAND accountcode='" . $AccountRow['accountcode'] . "'\n\t\t\tORDER BY period";
        $ChartDetails = DB_query($sql, $db);
        DB_Txn_Begin($db);
        $BFwd = '';
        $BFwdBudget = '';
        $CFwd = 0;
        $CFwdBudget = 0;
        while ($myrow = DB_fetch_array($ChartDetails)) {
            if ($BFwd = '') {
                $BFwd = $myrow['bfwd'];
                $BFwdBudget = $myrow['bfwdbudget'];
            } else {
                $BFwd += $myrow['actual'];
                $BFwdBudget += $myrow['budget'];
                $sql = "UPDATE chartdetails SET bfwd ='" . $BFwd . "',\n\t\t\t\t\t\t\tbfwdbudget ='" . $BFwdBudget . "'\n\t\t\t\t\tWHERE accountcode = '" . $AccountRow['accountcode'] . "'\n\t\t\t\t\tAND period ='" . ($myrow['period'] + 1) . "'";
                $UpdChartDetails = DB_query($sql, $db, '', '', '', false);
            }
        }
        DB_Txn_Commit($db);
        DB_free_result($ChartDetailsCFwd);
    }
    prnMsg(_('Chart Details Created successfully'), 'success');
} else {
    prnMsg(_('No additional chart details were required to be added'), 'success');
}
include 'includes/footer.inc';

         }
     } else {
         // for a specific stock category
         if ($_POST['SupplierItemsOnly'] == 'on') {
             $sql = "SELECT stockmaster.stockid,\n\t\t\t\t\t\t\t\tstockmaster.description,\n\t\t\t\t\t\t\t\tstockmaster.units\n\t\t\t\t\t\tFROM stockmaster INNER JOIN stockcategory\n\t\t\t\t\t\tON stockmaster.categoryid=stockcategory.categoryid\n\t\t\t\t\t\tINNER JOIN purchdata\n\t\t\t\t\t\tON stockmaster.stockid=purchdata.stockid\n\t\t\t\t\t\tWHERE (stockmaster.mbflag<>'D' OR stockcategory.stocktype='L')\n\t\t\t\t\t\tAND stockmaster.mbflag<>'A'\n\t\t\t\t\t\tAND stockmaster.mbflag<>'K'\n\t\t\t\t\t\tAND stockmaster.mbflag<>'G'\n\t\t\t\t\t\tAND purchdata.supplierno='" . $_SESSION['PO' . $identifier]->SupplierID . "'\n\t\t\t\t\t\tAND stockmaster.discontinued<>1\n\t\t\t\t\t\tAND stockmaster.categoryid='" . $_POST['StockCat'] . "'\n\t\t\t\t\t\tORDER BY stockmaster.stockid ";
         } else {
             $sql = "SELECT stockmaster.stockid,\n\t\t\t\t\t\t\tstockmaster.description,\n\t\t\t\t\t\t\tstockmaster.units\n\t\t\t\t\tFROM stockmaster INNER JOIN stockcategory\n\t\t\t\t\tON stockmaster.categoryid=stockcategory.categoryid\n\t\t\t\t\tWHERE (stockmaster.mbflag<>'D' OR stockcategory.stocktype='L')\n\t\t\t\t\tAND stockmaster.mbflag<>'A'\n\t\t\t\t\tAND stockmaster.mbflag<>'K'\n\t\t\t\t\tAND stockmaster.mbflag<>'G'\n\t\t\t\t\tAND stockmaster.discontinued<>1\n\t\t\t\t\tAND stockmaster.categoryid='" . $_POST['StockCat'] . "'\n\t\t\t\t\tORDER BY stockmaster.stockid ";
         }
     }
 }
 $SQLCount = substr($sql, strpos($sql, "FROM"));
 $SQLCount = substr($SQLCount, 0, strpos($SQLCount, "ORDER"));
 $SQLCount = 'SELECT COUNT(*) ' . $SQLCount;
 $SearchResult = DB_query($SQLCount, $ErrMsg, $DbgMsg);
 $myrow = DB_fetch_array($SearchResult);
 DB_free_result($SearchResult);
 unset($SearchResult);
 $ListCount = $myrow[0];
 $ListPageMax = ceil($ListCount / $_SESSION['DisplayRecordsMax']) - 1;
 if ($ListPageMax < 0) {
     $ListPageMax = 0;
 }
 if (isset($_POST['Next'])) {
     $Offset = $_POST['currpage'] + 1;
 }
 if (isset($_POST['Prev'])) {
     $Offset = $_POST['currpage'] - 1;
 }
 if (!isset($Offset)) {
     $Offset = 0;
 }