}
$i++;
$TaxGLCodes[$FreightTaxLine->TaxAuthID] = $FreightTaxLine->TaxGLCode;
}
echo '</td>';
echo '<td class="number">' . locale_number_format($FreightTaxTotal, $_SESSION['CreditItems' . $identifier]->CurrDecimalPlaces) . '</td>
<td class="number">' . locale_number_format($FreightTaxTotal + $_SESSION['CreditItems' . $identifier]->FreightCost, $_SESSION['CreditItems' . $identifier]->CurrDecimalPlaces) . '</td>
</tr>';
$TaxTotal += $FreightTaxTotal;
$DisplayTotal = locale_number_format($_SESSION['CreditItems' . $identifier]->total + $_SESSION['CreditItems' . $identifier]->FreightCost, $_SESSION['CreditItems' . $identifier]->CurrDecimalPlaces);
echo '<tr>
<td colspan="7" class="number">' . _('Credit Totals') . '</td>
<td class="number"><b>' . $DisplayTotal . '</b></td>
<td colspan="2"></td>
<td class="number"><b>' . locale_number_format($TaxTotal, $_SESSION['CreditItems' . $identifier]->CurrDecimalPlaces) . '</td>
<td class="number"><b>' . locale_number_format($TaxTotal + ($_SESSION['CreditItems' . $identifier]->total + $_SESSION['CreditItems' . $identifier]->FreightCost), $_SESSION['CreditItems' . $identifier]->CurrDecimalPlaces) . '</b></td>
</tr>
</table>';
/*Now show options for the credit note */
echo '<br />
<table class="selection">
<tr>
<td>' . _('Credit Note Type') . ' :</td>
<td><select name="CreditType" onchange="ReloadForm(MainForm.Update)" >';
if (!isset($_POST['CreditType']) or $_POST['CreditType'] == 'Return') {
echo '<option selected="selected" value="Return">' . _('Goods returned to store') . '</option>
<option value="WriteOff">' . _('Goods written off') . '</option>
<option value="ReverseOverCharge">' . _('Reverse an Overcharge') . '</option>';
} elseif ($_POST['CreditType'] == 'WriteOff') {
echo '<option selected="selected" value="WriteOff">' . _('Goods written off') . '</option>
<option value="Return">' . _('Goods returned to store') . '</option>
if ($debug == 1 and abs($_SESSION['SuppTrans']->OvAmount / $_SESSION['SuppTrans']->ExRate - $LocalTotal) > 0.004) {
prnMsg(_('The total posted to the credit accounts is') . ' ' . $LocalTotal . ' ' . _('but the sum of OvAmount converted at ExRate') . ' = ' . $_SESSION['SuppTrans']->OvAmount / $_SESSION['SuppTrans']->ExRate, 'error');
}
foreach ($_SESSION['SuppTrans']->Taxes as $Tax) {
/* Now the TAX account */
if ($Tax->TaxOvAmount / $_SESSION['SuppTrans']->ExRate != 0) {
$SQL = "INSERT INTO gltrans (type,\n\t\t\t\t\t\t\t\t\ttypeno,\n\t\t\t\t\t\t\t\t\ttrandate,\n\t\t\t\t\t\t\t\t\tperiodno,\n\t\t\t\t\t\t\t\t\taccount,\n\t\t\t\t\t\t\t\t\tnarrative,\n\t\t\t\t\t\t\t\t\tamount)\n\t\t\t\t\t\t\tVALUES (21,\n\t\t\t\t\t\t\t\t'" . $CreditNoteNo . "',\n\t\t\t\t\t\t\t\t'" . $SQLCreditNoteDate . "',\n\t\t\t\t\t\t\t\t'" . $PeriodNo . "',\n\t\t\t\t\t\t\t\t'" . $Tax->TaxGLCode . "',\n\t\t\t\t\t\t\t\t'" . $_SESSION['SuppTrans']->SupplierID . ' - ' . _('Credit note') . ' ' . $_SESSION['SuppTrans']->SuppReference . ' ' . $_SESSION['SuppTrans']->CurrCode . $Tax->TaxOvAmount . ' @ ' . _('a rate of') . ' ' . $_SESSION['SuppTrans']->ExRate . "',\n\t\t\t\t\t\t\t\t'" . -$Tax->TaxOvAmount / $_SESSION['SuppTrans']->ExRate . "')";
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The general ledger transaction for the tax could not be added because');
$DbgMsg = _('The following SQL to insert the GL transaction was used');
$Result = DB_query($SQL, $db, $ErrMsg, $DbgMsg, True);
}
/* if the tax is not 0 */
}
/*end of loop to post the tax */
/* Now the control account */
$SQL = "INSERT INTO gltrans (type,\n\t\t\t\t\t\t\ttypeno,\n\t\t\t\t\t\t\ttrandate,\n\t\t\t\t\t\t\tperiodno,\n\t\t\t\t\t\t\taccount,\n\t\t\t\t\t\t\tnarrative,\n\t\t\t\t\t\t\tamount)\n\t\t\t\t\t VALUES (21,\n\t\t\t\t\t \t'" . $CreditNoteNo . "',\n\t\t\t\t\t\t'" . $SQLCreditNoteDate . "',\n\t\t\t\t\t\t'" . $PeriodNo . "',\n\t\t\t\t\t\t'" . $_SESSION['SuppTrans']->CreditorsAct . "',\n\t\t\t\t\t\t'" . $_SESSION['SuppTrans']->SupplierID . ' - ' . _('Credit Note') . ' ' . $_SESSION['SuppTrans']->SuppReference . ' ' . $_SESSION['SuppTrans']->CurrCode . locale_number_format($_SESSION['SuppTrans']->OvAmount + $_SESSION['SuppTrans']->OvGST, $_SESSION['SuppTrans']->CurrDecimalPlaces) . ' @ ' . _('a rate of') . ' ' . $_SESSION['SuppTrans']->ExRate . "',\n\t\t\t\t\t\t'" . ($LocalTotal + $TaxTotal / $_SESSION['SuppTrans']->ExRate) . "')";
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The general ledger transaction for the control total could not be added because');
$DbgMsg = _('The following SQL to insert the GL transaction was used');
$Result = DB_query($SQL, $db, $ErrMsg, $DbgMsg, True);
}
/*Thats the end of the GL postings */
/*Now insert the credit note into the SuppTrans table*/
$SQL = "INSERT INTO supptrans (transno,\n\t\t\t\t\t\ttype,\n\t\t\t\t\t\tsupplierno,\n\t\t\t\t\t\tsuppreference,\n\t\t\t\t\t\ttrandate,\n\t\t\t\t\t\tduedate,\n\t\t\t\t\t\tinputdate,\n\t\t\t\t\t\tovamount,\n\t\t\t\t\t\tovgst,\n\t\t\t\t\t\trate,\n\t\t\t\t\t\ttranstext)\n\t\t\t\tVALUES (\n\t\t\t\t\t'" . $CreditNoteNo . "',\n\t\t\t\t\t21,\n\t\t\t\t\t'" . $_SESSION['SuppTrans']->SupplierID . "',\n\t\t\t\t\t'" . $_SESSION['SuppTrans']->SuppReference . "',\n\t\t\t\t\t'" . $SQLCreditNoteDate . "',\n\t\t\t\t\t'" . FormatDateForSQL($_SESSION['SuppTrans']->DueDate) . "',\n\t\t\t\t\t'" . Date('Y-m-d H-i-s') . "',\n\t\t\t\t\t'" . -$_SESSION['SuppTrans']->OvAmount . "',\n\t\t\t\t\t'" . -$TaxTotal . "',\n\t\t\t\t\t'" . $_SESSION['SuppTrans']->ExRate . "',\n\t\t\t\t\t'" . $_SESSION['SuppTrans']->Comments . "')";
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The supplier credit note transaction could not be added to the database because');
$DbgMsg = _('The following SQL to insert the supplier credit note was used');
$Result = DB_query($SQL, $db, $ErrMsg, $DbgMsg, True);
$SuppTransID = DB_Last_Insert_ID($db, 'supptrans', 'id');
/* Insert the tax totals for each tax authority where tax was charged on the invoice */
foreach ($_SESSION['SuppTrans']->Taxes as $TaxTotals) {
$SQL = "INSERT INTO supptranstaxes (supptransid,\n\t\t\t\t\t\t\t\t\t\t\t\ttaxauthid,\n\t\t\t\t\t\t\t\t\t\t\t\ttaxamount)\n\t\t\t\t\t\t\t\t\tVALUES ('" . $SuppTransID . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . $TaxTotals->TaxAuthID . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . -$TaxTotals->TaxOvAmount . "')";
$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The supplier transaction taxes records could not be inserted because');
}
echo '<tr>
<td>';
echo '<input type="hidden" name="PropID' . $PropertyCounter . '" value="' . $PropertyRow['stkcatpropid'] . '" />';
echo '<input type="hidden" name="PropNumeric' . $PropertyCounter . '" value="' . $PropertyRow['numericvalue'] . '" />';
echo $PropertyRow['label'] . '</td>
<td>';
switch ($PropertyRow['controltype']) {
case 0:
//textbox
if ($PropertyRow['numericvalue'] == 1) {
echo '<input type="hidden" name="PropMin' . $PropertyCounter . '" value="' . $PropertyRow['minimumvalue'] . '" />';
echo '<input type="hidden" name="PropMax' . $PropertyCounter . '" value="' . $PropertyRow['maximumvalue'] . '" />';
echo '<input type="text" class="number" name="PropValue' . $PropertyCounter . '" size="20" maxlength="100" value="' . locale_number_format($PropertyValue, 'Variable') . '" />';
echo _('A number between') . ' ' . locale_number_format($PropertyRow['minimumvalue'], 'Variable') . ' ' . _('and') . ' ' . locale_number_format($PropertyRow['maximumvalue'], 'Variable') . ' ' . _('is expected');
} else {
echo '<input type="text" name="PropValue' . $PropertyCounter . '" size="20" maxlength="100" value="' . $PropertyValue . '" />';
}
break;
case 1:
//select box
$OptionValues = explode(',', $PropertyRow['defaultvalue']);
echo '<select name="PropValue' . $PropertyCounter . '">';
foreach ($OptionValues as $PropertyOptionValue) {
if ($PropertyOptionValue == $PropertyValue) {
echo '<option selected="selected" value="' . $PropertyOptionValue . '">' . $PropertyOptionValue . '</option>';
} else {
echo '<option value="' . $PropertyOptionValue . '">' . $PropertyOptionValue . '</option>';
}
}
if ($k == 1) {
echo '<tr class="EvenTableRows">';
$k = 0;
} else {
echo '<tr class="OddTableRows">';
$k = 1;
}
$OnOrder = $PurchQty + $WoQty;
$Available = $QOH - $DemandQty + $OnOrder;
echo '<td>' . $myrow['stockid'] . '</td>
<td>' . $myrow['description'] . '</td>
<td>' . $myrow['stockunits'] . '</td>
<td class="number">' . locale_number_format($QOH, $DecimalPlaces) . '</td>
<td class="number">' . locale_number_format($DemandQty, $DecimalPlaces) . '</td>
<td class="number">' . locale_number_format($OnOrder, $DecimalPlaces) . '</td>
<td class="number">' . locale_number_format($Available, $DecimalPlaces) . '</td>
<td><input class="number" tabindex="' . ($j + 7) . '" type="text" size="6" name="Quantity' . $i . '" value="0" />
<input type="hidden" name="StockID' . $i . '" value="' . $myrow['stockid'] . '" />
</td>
</tr>';
echo '<input type="hidden" name="DecimalPlaces' . $i . '" value="' . $myrow['decimalplaces'] . '" />';
echo '<input type="hidden" name="ItemDescription' . $i . '" value="' . $myrow['description'] . '" />';
echo '<input type="hidden" name="Units' . $i . '" value="' . $myrow['stockunits'] . '" />';
if ($j == 1) {
$jsCall = '<script type="text/javascript">if (document.SelectParts) {defaultControl(document.SelectParts.itm' . $myrow['stockid'] . ');}</script>';
}
$i++;
#end of page full new headings if
}
#end of while loop
echo '<tr><td><input type="hidden" name="Previous" value="' . ($Offset - 1) . '" />
$pdf->line($Left_Margin, $YPos + $line_height - 2, $Page_Width - $Right_Margin, $YPos + $line_height - 2);
$YPos -= 2 * $line_height;
}
$CatTot_Val = 0;
}
$LeftOvers = $pdf->addTextWrap($Left_Margin, $YPos, 260 - $Left_Margin, $FontSize, $InventoryValn['categoryid'] . " - " . $InventoryValn['categorydescription']);
$Category = $InventoryValn['categoryid'];
$CategoryName = $InventoryValn['categorydescription'];
}
if ($_POST['DetailedReport'] == 'Yes') {
$YPos -= $line_height;
$FontSize = 8;
$LeftOvers = $pdf->addTextWrap($Left_Margin, $YPos, 60, $FontSize, $InventoryValn['stockid']);
$LeftOvers = $pdf->addTextWrap(120, $YPos, 260, $FontSize, $InventoryValn['description']);
$DisplayUnitCost = locale_money_format($InventoryValn['unitcost'], $_SESSION['CompanyRecord']['currencydefault']);
$DisplayQtyOnHand = locale_number_format($InventoryValn['qtyonhand'], $InventoryValn['decimalplaces']);
$DisplayItemTotal = locale_money_format($InventoryValn['itemtotal'], $_SESSION['CompanyRecord']['currencydefault']);
$LeftOvers = $pdf->addTextWrap(380, $YPos, 60, $FontSize, $DisplayQtyOnHand, 'right');
$LeftOvers = $pdf->addTextWrap(440, $YPos, 60, $FontSize, $DisplayUnitCost, 'right');
$LeftOvers = $pdf->addTextWrap(500, $YPos, 60, $FontSize, $DisplayItemTotal, 'right');
}
$Tot_Val += $InventoryValn['itemtotal'];
$CatTot_Val += $InventoryValn['itemtotal'];
if ($YPos < $Bottom_Margin + $line_height) {
include 'includes/PDFInventoryValnPageHeader.inc';
}
}
/*end inventory valn while loop */
$FontSize = 10;
/*Print out the category totals */
if ($_POST['DetailedReport'] == 'Yes') {
<td class="number"><i>%s</i></td>
<td class="number"><i>%s</i></td>
<td class="number"><i>%s</i></td>
<td class="number"><i>%s</i></td>
</tr>', $ParentGroups[$Level], locale_number_format($GrpActual[$Level], $_SESSION['CompanyRecord']['decimalplaces']), locale_number_format($GrpBudget[$Level], $_SESSION['CompanyRecord']['decimalplaces']), locale_number_format($GrpPrdActual[$Level], $_SESSION['CompanyRecord']['decimalplaces']), locale_number_format($GrpPrdBudget[$Level], $_SESSION['CompanyRecord']['decimalplaces']));
$GrpActual[$Level] = 0;
$GrpBudget[$Level] = 0;
$GrpPrdActual[$Level] = 0;
$GrpPrdBudget[$Level] = 0;
$ParentGroups[$Level] = '';
} else {
$Level = 1;
}
}
}
printf('<tr style="background-color:#ffffff">
<td colspan="2"><b>' . _('Check Totals') . '</b></td>
<td class="number">%s</td>
<td class="number">%s</td>
<td class="number">%s</td>
<td class="number">%s</td>
</tr>', locale_number_format($CheckMonth, $_SESSION['CompanyRecord']['decimalplaces']), locale_number_format($CheckBudgetMonth, $_SESSION['CompanyRecord']['decimalplaces']), locale_number_format($CheckPeriodActual, $_SESSION['CompanyRecord']['decimalplaces']), locale_number_format($CheckPeriodBudget, $_SESSION['CompanyRecord']['decimalplaces']));
echo '</table><br />';
echo '<div class="centre">
<input type="submit" name="SelectADifferentPeriod" value="' . _('Select A Different Period') . '" />
</div>';
}
}
echo '</div>
</form>';
include 'includes/footer.inc';
$NumberMonths = $_POST['NumberMonthsHolding'] - 10;
$MaxMthSales = ($SalesRow['prd1'] + $SalesRow['prd2'] + $SalesRow['prd3'] + $SalesRow['prd4'] + $SalesRow['prd5']) / 5;
} else {
$NumberMonths = $_POST['NumberMonthsHolding'];
$MaxMthSales = max($SalesRow['prd1'], $SalesRow['prd2'], $SalesRow['prd3'], $SalesRow['prd4'], $SalesRow['prd5']);
}
$IdealStockHolding = ceil($MaxMthSales * $NumberMonths);
$LeftOvers = $pdf->addTextWrap(497, $YPos, 40, $FontSize, locale_number_format($IdealStockHolding, 0), 'right');
$LeftOvers = $pdf->addTextWrap(597, $YPos, 40, $FontSize, locale_number_format($InventoryPlan['qoh'], 0), 'right');
$LeftOvers = $pdf->addTextWrap(638, $YPos, 40, $FontSize, locale_number_format($TotalDemand, 0), 'right');
$LeftOvers = $pdf->addTextWrap(679, $YPos, 40, $FontSize, locale_number_format($QOO, 0), 'right');
$SuggestedTopUpOrder = $IdealStockHolding - $InventoryPlan['qoh'] + $TotalDemand - $QOO;
if ($SuggestedTopUpOrder <= 0) {
$LeftOvers = $pdf->addTextWrap(720, $YPos, 40, $FontSize, ' ', 'right');
} else {
$LeftOvers = $pdf->addTextWrap(720, $YPos, 40, $FontSize, locale_number_format($SuggestedTopUpOrder, 0), 'right');
}
if ($YPos < $Bottom_Margin + $line_height) {
$PageNumber++;
include 'includes/PDFInventoryPlanPageHeader.inc';
}
}
/*end inventory valn while loop */
$YPos -= 2 * $line_height;
$pdf->line($Left_Margin, $YPos + $line_height, $Page_Width - $Right_Margin, $YPos + $line_height);
if ($ListCount == 0) {
$Title = _('Print Inventory Planning Report Empty');
include 'includes/header.inc';
prnMsg(_('There were no items in the range and location specified'), 'error');
echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a>';
include 'includes/footer.inc';
$YPos -= $line_height;
}
$YPos -= $line_height;
$LeftOvers = $pdf->addTextWrap(20, $YPos, 60, $FontSize, $Customers['debtorno']);
$LeftOvers = $pdf->addTextWrap(80, $YPos, 150, $FontSize, $Customers['name']);
$LeftOvers = $pdf->addTextWrap(80, $YPos - 10, 150, $FontSize, $Customers['address1']);
$LeftOvers = $pdf->addTextWrap(80, $YPos - 20, 150, $FontSize, $Customers['address2']);
$LeftOvers = $pdf->addTextWrap(80, $YPos - 30, 150, $FontSize, $Customers['address3']);
$LeftOvers = $pdf->addTextWrap(140, $YPos - 30, 150, $FontSize, $Customers['address4']);
$LeftOvers = $pdf->addTextWrap(180, $YPos - 30, 150, $FontSize, $Customers['address5']);
$LeftOvers = $pdf->addTextWrap(210, $YPos - 30, 150, $FontSize, $Customers['address6']);
$LeftOvers = $pdf->addTextWrap(230, $YPos, 60, $FontSize, $Customers['branchcode']);
$LeftOvers = $pdf->addTextWrap(230, $YPos - 10, 60, $FontSize, _('Price List') . ': ' . $Customers['salestype']);
if ($_POST['Activity'] != 'All') {
$LeftOvers = $pdf->addTextWrap(230, $YPos - 20, 60, $FontSize, _('Turnover'), 'right');
$LeftOvers = $pdf->addTextWrap(230, $YPos - 30, 60, $FontSize, locale_number_format($LocalCurrencyTurnover, 0), 'right');
}
$LeftOvers = $pdf->addTextWrap(290, $YPos, 150, $FontSize, $Customers['brname']);
$LeftOvers = $pdf->addTextWrap(290, $YPos - 10, 150, $FontSize, $Customers['contactname']);
$LeftOvers = $pdf->addTextWrap(290, $YPos - 20, 150, $FontSize, _('Ph') . ': ' . $Customers['phoneno']);
$LeftOvers = $pdf->addTextWrap(290, $YPos - 30, 150, $FontSize, _('Fax') . ': ' . $Customers['faxno']);
$LeftOvers = $pdf->addTextWrap(440, $YPos, 150, $FontSize, $Customers['braddress1']);
$LeftOvers = $pdf->addTextWrap(440, $YPos - 10, 150, $FontSize, $Customers['braddress2']);
$LeftOvers = $pdf->addTextWrap(440, $YPos - 20, 150, $FontSize, $Customers['braddress3']);
$LeftOvers = $pdf->addTextWrap(500, $YPos - 20, 150, $FontSize, $Customers['braddress4']);
$LeftOvers = $pdf->addTextWrap(540, $YPos - 20, 150, $FontSize, $Customers['braddress5']);
$LeftOvers = $pdf->addTextWrap(570, $YPos - 20, 150, $FontSize, $Customers['braddress6']);
$LeftOvers = $pdf->addTextWrap(440, $YPos - 30, 150, $FontSize, $Customers['email']);
$pdf->line($Page_Width - $Right_Margin, $YPos - 32, $Left_Margin, $YPos - 32);
$YPos -= 40;
if ($YPos < $Bottom_Margin + 30) {
$CatTot_Val += $InventoryValn['itemtotal'];
$CatTot_Qty += $InventoryValn['qtyonhand'];
if ($YPos < $Bottom_Margin + $line_height) {
include 'includes/PDFInventoryValnPageHeader.inc';
}
}
/*end inventory valn while loop */
$FontSize = 10;
/*Print out the category totals */
if ($_POST['DetailedReport'] == 'Yes') {
$YPos -= 2 * $line_height;
$LeftOvers = $pdf->addTextWrap($Left_Margin, $YPos, 260 - $Left_Margin, $FontSize, _('Total for') . ' ' . $Category . ' - ' . $CategoryName, 'left');
}
$DisplayCatTotVal = locale_money_format($CatTot_Val, $_SESSION['CompanyRecord']['currencydefault']);
$LeftOvers = $pdf->addTextWrap(500, $YPos, 60, $FontSize, $DisplayCatTotVal, 'right');
$DisplayCatTotQty = locale_number_format($CatTot_Qty, 2);
$LeftOvers = $pdf->addTextWrap(360, $YPos, 60, $FontSize, $DisplayCatTotQty, 'right');
if ($_POST['DetailedReport'] == 'Yes') {
/*draw a line under the CATEGORY TOTAL*/
$YPos -= $line_height;
$pdf->line($Left_Margin, $YPos + $line_height - 2, $Page_Width - $Right_Margin, $YPos + $line_height - 2);
}
$YPos -= 2 * $line_height;
if ($YPos < $Bottom_Margin + $line_height) {
include 'includes/PDFInventoryValnPageHeader.inc';
}
/*Print out the grand totals */
$LeftOvers = $pdf->addTextWrap(80, $YPos, 260 - $Left_Margin, $FontSize, _('Grand Total Value'), 'right');
$DisplayTotalVal = locale_money_format($Tot_Val, $_SESSION['CompanyRecord']['currencydefault']);
$LeftOvers = $pdf->addTextWrap(500, $YPos, 60, $FontSize, $DisplayTotalVal, 'right');
$pdf->OutputD($_SESSION['DatabaseName'] . '_Inventory_Valuation_' . Date('Y-m-d') . '.pdf');
if (!isset($_POST['ReceivedDate'])) {
$_POST['ReceivedDate'] = Date($_SESSION['DefaultDateFormat']);
}
echo '<table cellpadding="2" class="selection">
<tr><td>' . _('Receive work order') . ':</td>
<td>' . $_POST['WO'] . '</td><td>' . _('Item') . ':</td>
<td>' . $_POST['StockID'] . ' - ' . $WORow['description'] . '</td></tr>
<tr><td>' . _('Manufactured at') . ':</td>
<td>' . $WORow['locationname'] . '</td>
<td>' . _('Required By') . ':</td>
<td>' . ConvertSQLDate($WORow['requiredby']) . '</td></tr>
<tr><td>' . _('Quantity Ordered') . ':</td>
<td class="number">' . locale_number_format($WORow['qtyreqd'], $WORow['decimalplaces']) . '</td>
<td colspan="2">' . $WORow['units'] . '</td></tr>
<tr><td>' . _('Already Received') . ':</td>
<td class="number">' . locale_number_format($WORow['qtyrecd'], $WORow['decimalplaces']) . '</td>
<td colspan="2">' . $WORow['units'] . '</td></tr>
<tr><td>' . _('Date Received') . ':</td>
<td>' . Date($_SESSION['DefaultDateFormat']) . '</td>
<td>' . _('Received Into') . ':</td><td>
<select name="IntoLocation">';
if (!isset($_POST['IntoLocation'])) {
$_POST['IntoLocation'] = $WORow['loccode'];
}
$LocResult = DB_query("SELECT loccode, locationname FROM locations", $db);
while ($LocRow = DB_fetch_array($LocResult)) {
if ($_POST['IntoLocation'] == $LocRow['loccode']) {
echo '<option selected="True" value="' . $LocRow['loccode'] . '">' . $LocRow['locationname'] . '</option>';
} else {
echo '<option value="' . $LocRow['loccode'] . '">' . $LocRow['locationname'] . '</option>';
}
echo '<tr>
<td colspan="2"></td>
<td colspan="6"><hr /></td>
</tr>';
printf('<tr>
<td colspan="2"><font size="2"><i>' . _('Gross Profit Percent') . '</i></font></td>
<td></td>
<td class="number"><i>%s</i></td>
<td></td>
<td class="number"><i>%s</i></td>
<td></td>
<td class="number"><i>%s</i></td>
</tr>
<tr>
<td colspan="6"> </td>
</tr>', locale_number_format($PrdGPPercent, 1) . '%');
$j++;
}
$SectionPrdActual = 0;
$Section = $myrow['sectioninaccounts'];
if ($_POST['Detail'] == 'Detailed' and isset($Sections[$myrow['sectioninaccounts']])) {
printf('<tr>
<th colspan="6" class="header" style="text-align: left;">%s</th>
</tr>', $Sections[$myrow['sectioninaccounts']]);
}
$j++;
}
echo '<tr>
<td colspan="2"></td>
<td colspan="6"><hr /></td>
</tr>';
</tr>';
echo '<tr>
<td class="select">' . _('Customer since:') . '</td>
<td class="select"> <b>' . ConvertSQLDate($myrow['clientsince']) . '</b> </td>
<td class="select">' . $myrow['customersincedays'] . ' ' . _('days') . '</td>
</tr>';
if ($row['total'] == 0) {
echo '<tr>
<td class="select">' . _('No Spend from this Customer.') . '</b></td>
<td class="select"></td>
<td class="select"></td>
</tr>';
} else {
echo '<tr>
<td class="select">' . _('Total Spend from this Customer (inc tax):') . ' </td>
<td class="select"><b>' . locale_number_format($row['total'], $myrow['currdecimalplaces']) . '</b></td>
<td class="select"></td>
</tr>';
}
echo '<tr>
<td class="select">' . _('Customer Type:') . ' </td>
<td class="select"><b>' . $CustomerTypeName . '</b></td>
<td class="select"></td>
</tr>';
echo '</table>';
}
//$_SESSION['CustomerID'] != ''
// Customer Contacts
$sql = "SELECT * FROM custcontacts\n\t\t\t\tWHERE debtorno='" . $_SESSION['CustomerID'] . "'\n\t\t\t\tORDER BY contid";
$result = DB_query($sql, $db);
if (DB_num_rows($result) != 0) {
$FontSize = 8;
}
$YPos -= $line_height;
$LeftOvers = $pdf->addTextWrap($Left_Margin, $YPos, 80, $FontSize, $PriceList['stockid']);
$LeftOvers = $pdf->addTextWrap($Left_Margin + 100, $YPos, 47, $FontSize, ConvertSQLDate($PriceList['startdate']));
if ($PriceList['enddate'] != '0000-00-00') {
$DisplayEndDate = ConvertSQLDate($PriceList['enddate']);
} else {
$DisplayEndDate = _('No End Date');
}
$LeftOvers = $pdf->addTextWrap($Left_Margin + 100 + 47, $YPos, 47, $FontSize, $DisplayEndDate);
$LeftOvers = $pdf->addTextWrap($Left_Margin + 130 + 47 + 47, $YPos, 130, $FontSize, $PriceList['description']);
$DisplayUnitPrice = locale_number_format($PriceList['price'], $PriceList['decimalplaces']);
$LeftOvers = $pdf->addTextWrap($Left_Margin + 110 + 47 + 47 + 130, $YPos, 180, $FontSize, $DisplayUnitPrice, 'right');
if ($PriceList['price'] != 0) {
$DisplayGPPercent = locale_number_format(($PriceList['price'] - $PriceList['standardcost']) * 100 / $PriceList['price'], 1) . '%';
} else {
$DisplayGPPercent = 0;
}
if ($_POST['ShowGPPercentages'] == 'Yes') {
$LeftOvers = $pdf->addTextWrap($Left_Margin + 135 + 47 + 47 + 130 + 65, $YPos, 20, $FontSize, $DisplayGPPercent, 'right');
}
if ($_POST['CustomerSpecials'] == 'Customer Special Prices Only') {
/*Need to show to which branch the price relates */
if ($PriceList['branchcode'] != '') {
$LeftOvers = $pdf->addTextWrap($Left_Margin + 80 + 47 + 47 + 130 + 65 + 25, $YPos, 60, $FontSize, $PriceList['brname'], 'left');
} else {
$LeftOvers = $pdf->addTextWrap($Left_Margin + 80 + 47 + 47 + 130 + 65 + 25, $YPos, 60, $FontSize, _('All'), 'left');
}
} else {
if ($_POST['CustomerSpecials'] == 'Full Description') {
</tr>';
echo $TableHeader;
/* show the GRNs outstanding to be invoiced that could be reversed */
$RowCounter = 0;
$k = 0;
while ($myrow = DB_fetch_array($result)) {
if ($k == 1) {
echo '<tr class="EvenTableRows">';
$k = 0;
} else {
echo '<tr class="OddTableRows">';
$k = 1;
}
$DisplayQtyRecd = locale_number_format($myrow['qtyrecd'], $myrow['decimalplaces']);
$DisplayQtyInv = locale_number_format($myrow['quantityinv'], $myrow['decimalplaces']);
$DisplayQtyRev = locale_number_format($myrow['qtytoreverse'], $myrow['decimalplaces']);
$DisplayDateDel = ConvertSQLDate($myrow['deliverydate']);
$LinkToRevGRN = '<a href="' . htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8') . '?GRNNo=' . $myrow['grnno'] . '">' . _('Reverse') . '</a>';
printf('<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td class="number">%s</td>
<td class="number">%s</td>
<td class="number">%s</td>
<td>%s</td>
</tr>', $myrow['grnno'], $myrow['itemcode'], $myrow['itemdescription'], $DisplayDateDel, $DisplayQtyRecd, $DisplayQtyInv, $DisplayQtyRev, $LinkToRevGRN);
$RowCounter++;
if ($RowCounter > 20) {
$RowCounter = 0;
echo $TableHeader;
}
}
}
echo '</select></td></tr>';
echo '<input type="hidden" name="Item" value="' . $Item . '" />';
echo '<tr><td>' . _('Decimal Places') . '<br />' . _('to display') . '</td>';
if (isset($_POST['DecimalPlaces'])) {
echo '<td><input type="text" class="number" name="DecimalPlaces" size="8" maxlength="8" value="' . $_POST['DecimalPlaces'] . '" /></td></tr>';
} else {
echo '<td><input type="text" class="number" name="DecimalPlaces" size="8" maxlength="8" value="0" /></td></tr>';
}
echo '<tr><td>' . _('Conversion Factor') . '<br />' . _('to stock units') . '</td>';
if (isset($_POST['ConversionFactor'])) {
echo '<td><input type="text" class="number" name="ConversionFactor" size="8" maxlength="8" value="' . locale_number_format($_POST['ConversionFactor'], 4) . '" /></td></tr>';
} else {
echo '<td><input type="text" class="number" name="ConversionFactor" size="8" maxlength="8" value="' . locale_number_format(1, 4) . '" /></td></tr>';
}
echo '<tr><td>' . _('Price') . ':</td>
<td><input type="text" class="number" name="Price" size="11" maxlength="10" value="' . locale_money_format($_POST['Price'], $CustomerCurrencyCode) . '" /></td>
</tr></table>';
echo '<br /><div class="centre"><button type="submit" name="submit">' . _('Enter Information') . '</button></div>';
echo '</form>';
include 'includes/footer.inc';
function ReSequenceEffectiveDates($Item, $PriceList, $CurrAbbrev, $CustomerID, $db)
{
/*This is quite complicated - the idea is that prices set up should be unique and there is no way two prices could be returned as valid - when getting a price in includes/GetPrice.inc the logic is to first look for a price of the salestype/currency within the effective start and end dates - then if not get the price with a start date prior but a blank end date (the default price). We would not want two prices where the effective dates fall between an existing price so it is necessary to update enddates of prices - with me - I am just hanging on here myself
Prices with no end date are default prices and need to be ignored in this resquence*/
$SQL = "SELECT branchcode,\n\t\t\t\t\t\tstartdate,\n\t\t\t\t\t\tenddate\n\t\t\t\t\t\tFROM prices\n\t\t\t\t\t\tWHERE debtorno='" . $CustomerID . "'\n\t\t\t\t\t\tAND stockid='" . $Item . "'\n\t\t\t\t\t\tAND currabrev='" . $CurrAbbrev . "'\n\t\t\t\t\t\tAND typeabbrev='" . $PriceList . "'\n\t\t\t\t\t\tAND enddate<>''\n\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\tbranchcode,\n\t\t\t\t\t\tstartdate,\n\t\t\t\t\t\tenddate";
$result = DB_query($SQL, $db);
unset($BranchCode);
while ($myrow = DB_fetch_array($result)) {
<td><input type="text" class="number" name="ConversionFactor' . $POLine->LineNo . '" size="8" value="' . $POLine->ConversionFactor . '" /></td>
<td><input type="text" class="number" name="SuppQty' . $POLine->LineNo . '" size="10" value="' . locale_number_format(round($POLine->Quantity / $POLine->ConversionFactor, $POLine->DecimalPlaces), $POLine->DecimalPlaces) . '" /></td>
<td>' . $POLine->SuppliersUnit . '</td>
<td><input type="text" class="number" name="SuppPrice' . $POLine->LineNo . '" size="10" value="' . locale_number_format(round($POLine->Price * $POLine->ConversionFactor, $_SESSION['PO' . $identifier]->CurrDecimalPlaces), $_SESSION['PO' . $identifier]->CurrDecimalPlaces) . '" /></td>
<td class="number">' . $DisplayLineTotal . '</td>
<td><input type="text" class="date" alt="' . $_SESSION['DefaultDateFormat'] . '" name="ReqDelDate' . $POLine->LineNo . '" size="10" value="' . $POLine->ReqDelDate . '" /></td>';
if ($POLine->QtyReceived != 0 and $POLine->Completed != 1) {
echo '<td><a href="' . htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8') . '?identifier=' . $identifier . '&Complete=' . $POLine->LineNo . '">' . _('Complete') . '</a></td>';
} elseif ($POLine->QtyReceived == 0) {
echo '<td><a href="' . htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8') . '?identifier=' . $identifier . '&Delete=' . $POLine->LineNo . '">' . _('Delete') . '</a></td>';
}
echo '</tr>';
$_SESSION['PO' . $identifier]->Total += $LineTotal;
}
}
$DisplayTotal = locale_number_format($_SESSION['PO' . $identifier]->Total, $_SESSION['PO' . $identifier]->CurrDecimalPlaces);
echo '<tr><td colspan="9" class="number">' . _('TOTAL') . _(' excluding Tax') . '</td>
<td class="number"><b>' . $DisplayTotal . '</b></td>
</tr></table>';
echo '<br />
<div class="centre">
<input type="submit" name="UpdateLines" value="' . _('Update Order Lines') . '" />';
echo ' <input type="submit" name="Commit" value="' . _('Process Order') . '" />
</div>';
}
/*Only display the order line items if there are any !! */
if (isset($_POST['NonStockOrder'])) {
echo '<br /><table class="selection"><tr>
<td>' . _('Item Description') . '</td>';
echo '<td><input type="text" name="ItemDescription" size="40" /></td></tr>';
echo '<tr>
<th>' . _('Currency') . '</th>
<th>' . _('Price') . '</th>
<th>' . _('Line Total') . '</th>
</tr>';
while ($LineRow = DB_fetch_array($LineResult)) {
if ($LineRow['decimalplaces'] != NULL) {
$DecimalPlaces = $LineRow['decimalplaces'];
} else {
$DecimalPlaces = 2;
}
echo '<tr>
<td>' . $LineRow['description'] . '</td>
<td class="number">' . locale_number_format($LineRow['quantityord'], $DecimalPlaces) . '</td>
<td>' . $myrow['currcode'] . '</td>
<td class="number">' . locale_number_format($LineRow['unitprice'], $myrow['currdecimalplaces']) . '</td>
<td class="number">' . locale_number_format($LineRow['unitprice'] * $LineRow['quantityord'], $myrow['currdecimalplaces']) . '</td>
</tr>';
}
// end while order line detail
echo '</table>
</td>
</tr>';
}
}
//end while header loop
echo '</table>';
echo '<br />
<div class="centre">
<input type="submit" name="UpdateAll" value="' . _('Update') . '" />
</div>
</div>
echo '<tr>
<td>' . _('Standard Material Cost Per Unit') . ':</td>
<td class="number"><input type="text" class="number" name="MaterialCost" value="' . locale_number_format($myrow['materialcost'], $_SESSION['StandardCostDecimalPlaces']) . '" /></td>
</tr>
<tr>
<td>' . _('Standard Labour Cost Per Unit') . ':</td>
<td class="number"><input type="text" class="number" name="LabourCost" value="' . locale_number_format($myrow['labourcost'], $_SESSION['StandardCostDecimalPlaces']) . '" /></td>
</tr>
<tr>
<td>' . _('Standard Overhead Cost Per Unit') . ':</td>
<td class="number"><input type="text" class="number" name="OverheadCost" value="' . locale_number_format($myrow['overheadcost'], $_SESSION['StandardCostDecimalPlaces']) . '" /></td>
</tr>';
} elseif ($myrow['mbflag'] == 'B' or $myrow['mbflag'] == 'D') {
echo '<tr>
<td>' . _('Standard Cost') . ':</td>
<td class="number"><input type="text" class="number" name="MaterialCost" value="' . locale_number_format($myrow['materialcost'], $_SESSION['StandardCostDecimalPlaces']) . '" /></td>
</tr>';
} else {
echo '<tr><td><input type="hidden" name="LabourCost" value="0" />';
echo '<input type="hidden" name="OverheadCost" value="0" /></td></tr>';
}
echo '</table>
<br />
<div class="centre">
<input type="submit" name="UpdateData" value="' . _('Update') . '" />
</div>
<br />
<br />';
}
if ($myrow['mbflag'] != 'D') {
echo '<div class="centre"><a href="' . $RootPath . '/StockStatus.php?StockID=' . $StockID . '">' . _('Show Stock Status') . '</a>';
} else {
if ($TrfLine->Controlled == 1) {
if (sizeOf($TrfLine->SerialItems) == 0) {
$Qty = 0;
} else {
$Qty = $TrfLine->Quantity;
}
} else {
$Qty = $TrfLine->Quantity;
}
}
echo '<td class="number">' . locale_number_format($TrfLine->PrevRecvQty, $TrfLine->DecimalPlaces) . '</td>';
if ($TrfLine->Controlled == 1) {
echo '<td class="number"><input type="hidden" name="Qty' . $i . '" value="' . locale_number_format($Qty, $TrfLine->DecimalPlaces) . '"><a href="' . $rootpath . '/StockTransferControlled.php?TransferItem=' . $i . '" />' . locale_number_format($Qty, $TrfLine->DecimalPlaces) . '</a></td>';
} else {
echo '<td><input type="text" class="number" name="Qty' . $i . '" maxlength="10" class="number" size="auto" value="' . locale_number_format($Qty, $TrfLine->DecimalPlaces) . '" /></td>';
}
echo '<td>' . $TrfLine->PartUnit . '</td>';
echo '<td><input type="checkbox" name="CancelBalance' . $i . '" value="1" /></td>';
if ($TrfLine->Controlled == 1) {
if ($TrfLine->Serialised == 1) {
echo '<td><a href="' . $rootpath . '/StockTransferControlled.php?TransferItem=' . $i . '">' . _('Enter Serial Numbers') . '</a></td>';
} else {
echo '<td><a href="' . $rootpath . '/StockTransferControlled.php?TransferItem=' . $i . '">' . _('Enter Batch Refs') . '</a></td>';
}
}
echo '</tr>';
$i++;
/* the array of TransferItem s is indexed numerically and i matches the index no */
}
/*end of foreach TransferItem */
if ($_POST['BelowReorderQuantity'] != 'NotZero') {
if ($k == 1) {
echo '<tr class="OddTableRows">';
$k = 0;
} else {
echo '<tr class="EvenTableRows">';
$k = 1;
}
printf('<td><a target="_blank" href="' . $RootPath . '/StockStatus.php?StockID=%s">%s</a></td>
<td>%s</td>
<td class="number">%s</td>
<td>%s</td>
<td class="number">%s</td>
<td class="number">%s</td>
<td class="number"><a target="_blank" href="' . $RootPath . '/SelectProduct.php?StockID=%s">%s</a></td>
<td class="number">%s</td>', mb_strtoupper($myrow['stockid']), mb_strtoupper($myrow['stockid']), $myrow['description'], locale_number_format($myrow['quantity'], $myrow['decimalplaces']), $myrow['bin'], locale_number_format($myrow['reorderlevel'], $myrow['decimalplaces']), locale_number_format($DemandQty, $myrow['decimalplaces']), mb_strtoupper($myrow['stockid']), locale_number_format($myrow['quantity'] - $DemandQty, $myrow['decimalplaces']), locale_number_format($QOO, $myrow['decimalplaces']));
if ($myrow['serialised'] == 1) {
/*The line is a serialised item*/
echo '<td><a target="_blank" href="' . $RootPath . '/StockSerialItems.php?Serialised=Yes&Location=' . $myrow['loccode'] . '&StockID=' . $StockID . '">' . _('Serial Numbers') . '</a></td></tr>';
} elseif ($myrow['controlled'] == 1) {
echo '<td><a target="_blank" href="' . $RootPath . '/StockSerialItems.php?Location=' . $myrow['loccode'] . '&StockID=' . $StockID . '">' . _('Batches') . '</a></td></tr>';
}
}
}
//end of page full new headings if
}
//end of if BelowOrderQuantity or all items
}
//end of while loop
echo '</table>';
}
$LeftOvers = $pdf->addTextWrap(220, $YPos, 60, $FontSize, $DisplayBalance, 'right');
$LeftOvers = $pdf->addTextWrap(280, $YPos, 60, $FontSize, $DisplayFXBalance, 'right');
$LeftOvers = $pdf->addTextWrap(350, $YPos, 100, $FontSize, $DebtorBalances['currency'], 'left');
$YPos -= $line_height;
if ($YPos < $Bottom_Margin + $line_height) {
include 'includes/PDFDebtorBalsPageHeader.inc';
}
}
}
/*end customer aged analysis while loop */
$YPos -= $line_height;
if ($YPos < $Bottom_Margin + 2 * $line_height) {
$PageNumber++;
include 'includes/PDFDebtorBalsPageHeader.inc';
}
$DisplayTotBalance = locale_number_format($TotBal, $_SESSION['CompanyRecord']['decimalplaces']);
$LeftOvers = $pdf->addTextWrap(50, $YPos, 160, $FontSize, _('Total balances'), 'left');
$LeftOvers = $pdf->addTextWrap(220, $YPos, 60, $FontSize, $DisplayTotBalance, 'right');
$pdf->OutputD($_SESSION['DatabaseName'] . '_DebtorBals_' . date('Y-m-d') . '.pdf');
$pdf->__destruct();
} else {
/*The option to print PDF was not hit */
$Title = _('Debtor Balances');
$ViewTopic = 'ARReports';
$BookMark = 'PriorMonthDebtors';
include 'includes/header.inc';
echo '<p class="page_title_text"><img src="' . $RootPath . '/css/' . $Theme . '/images/customer.png" title="' . _('Search') . '" alt="" />' . ' ' . $Title . '</p><br />';
if (!isset($_POST['FromCriteria']) or !isset($_POST['ToCriteria'])) {
/*if $FromCriteria is not set then show a form to allow input */
echo '<form action="' . htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8') . '" method="post">
<div>';
while ($InvRow = DB_fetch_array($InvoicesResult)) {
$ValueInvoiced = $InvRow['netprice'] * $InvRow['quantity'];
$LeftOvers = $pdf->addTextWrap($Left_Margin + 150, $YPos, 90, $FontSize, $InvRow['typename'] . ' ' . $InvRow['transno'], 'left');
$LeftOvers = $pdf->addTextWrap($Left_Margin + 240, $YPos, 60, $FontSize, locale_number_format($InvRow['quantity'], $myrow['decimalplaces']), 'right');
$LeftOvers = $pdf->addTextWrap($Left_Margin + 300, $YPos, 60, $FontSize, locale_number_format($InvRow['netprice'], $_SESSION['CompanyRecord']['decimalplaces']), 'right');
$LeftOvers = $pdf->addTextWrap($Left_Margin + 360, $YPos, 80, $FontSize, locale_number_format($ValueInvoiced, $_SESSION['CompanyRecord']['decimalplaces']), 'right');
$YPos -= $line_height;
if ($YPos - 2 * $line_height < $Bottom_Margin) {
/*Then set up a new page */
$PageNumber++;
include 'includes/PDFOrdersInvoicedPageHeader.inc';
}
/*end of new page header */
$AccumOrderTotal += $ValueInvoiced;
$AccumTotalInv += $ValueInvoiced;
}
$YPos -= $line_height;
if ($YPos - 2 * $line_height < $Bottom_Margin) {
/*Then set up a new page */
$PageNumber++;
include 'includes/PDFOrdersInvoicedPageHeader.inc';
}
/*end of new page header */
}
/* end of while there are invoiced orders to print */
$YPos -= $line_height;
$LeftOvers = $pdf->addTextWrap($Left_Margin + 260, $YPos, 100, $FontSize, _('GRAND TOTAL INVOICED'), 'right');
$LeftOvers = $pdf->addTextWrap($Left_Margin + 360, $YPos, 80, $FontSize, locale_number_format($AccumTotalInv, $_SESSION['CompanyRecord']['decimalplaces']), 'right');
$YPos -= $line_height;
$pdf->OutputD($_SESSION['DatabaseName'] . '_OrdersInvoiced_' . date('Y-m-d') . '.pdf');
$pdf->__destruct();
</tr>', $Sections[$Section], locale_number_format($SectionBalance, $_SESSION['CompanyRecord']['decimalplaces']), locale_number_format($SectionBalanceLY, $_SESSION['CompanyRecord']['decimalplaces']));
$Section = $myrow['sectioninaccounts'];
if (isset($myrow['sectioninaccounts']) and $_POST['Detail'] == 'Detailed') {
printf('<tr>
<td colspan="6"><h1>%s</h1></td>
</tr>', $Sections[$myrow['sectioninaccounts']]);
}
echo '<tr>
<td colspan="3"></td>
<td><hr /></td>
<td></td>
<td><hr /></td>
</tr>';
printf('<tr>
<td colspan="3"><h2>' . _('Check Total') . '</h2></td>
<td class="number">%s</td>
<td></td>
<td class="number">%s</td>
</tr>', locale_number_format($CheckTotal, $_SESSION['CompanyRecord']['decimalplaces']), locale_number_format($LYCheckTotal, $_SESSION['CompanyRecord']['decimalplaces']));
echo '<tr>
<td colspan="3"></td>
<td><hr /></td>
<td></td>
<td><hr /></td>
</tr>';
echo '</table>';
echo '</div>';
echo '<br /><div class="centre noPrint"><input type="submit" name="SelectADifferentPeriod" value="' . _('Select A Different Balance Date') . '" /></div>';
echo '</form>';
}
include 'includes/footer.inc';
/*Its a detailed report */
}
/*end Supplier aged analysis while loop */
$YPos -= $line_height;
if ($YPos < $Bottom_Margin + 2 * $line_height) {
$PageNumber++;
include 'includes/PDFAgedSuppliersPageHeader.inc';
} elseif ($_POST['DetailedReport'] == 'Yes') {
//dont do a line if the totals have to go on a new page
$pdf->line($Page_Width - $Right_Margin, $YPos + 10, 220, $YPos + 10);
}
$DisplayTotBalance = locale_number_format($TotBal, $CurrDecimalPlaces);
$DisplayTotDue = locale_number_format($TotDue, $CurrDecimalPlaces);
$DisplayTotCurrent = locale_number_format($TotCurr, $CurrDecimalPlaces);
$DisplayTotOverdue1 = locale_number_format($TotOD1, $CurrDecimalPlaces);
$DisplayTotOverdue2 = locale_number_format($TotOD2, $CurrDecimalPlaces);
$LeftOvers = $pdf->addTextWrap(220, $YPos, 60, $FontSize, $DisplayTotBalance, 'right');
$LeftOvers = $pdf->addTextWrap(280, $YPos, 60, $FontSize, $DisplayTotCurrent, 'right');
$LeftOvers = $pdf->addTextWrap(340, $YPos, 60, $FontSize, $DisplayTotDue, 'right');
$LeftOvers = $pdf->addTextWrap(400, $YPos, 60, $FontSize, $DisplayTotOverdue1, 'right');
$LeftOvers = $pdf->addTextWrap(460, $YPos, 60, $FontSize, $DisplayTotOverdue2, 'right');
$YPos -= $line_height;
$pdf->line($Page_Width - $Right_Margin, $YPos, 220, $YPos);
if ($ListCount == 0) {
$Title = _('Aged Supplier Analysis');
include 'includes/header.inc';
prnMsg(_('There are no results so the PDF is empty'));
include 'includes/footer.inc';
} else {
$pdf->OutputD($_SESSION['DatabaseName'] . '_AggedSupliers_' . date('Y-m-d') . '.pdf');
}
<th>' . _('Order Date') . '</th>
<th>' . _('Delivery Date') . '</th>
<th>' . _('Order Amount') . '</th>
<th>' . _('Currency') . '</th>
</tr> ';
$k = 0;
while ($row = DB_fetch_array($SalesOrdersResult)) {
if ($k == 1) {
echo '<tr class="EvenTableRows">';
$k = 0;
} else {
echo '<tr class="OddTableRows">';
$k++;
}
$FormatedOrderValue = locale_number_format($row['ordervalue'], $row['currdecimalplaces']);
$OrderDate = ConvertSQLDate($row['orddate']);
$DelDate = ConvertSQLDate($row['deliverydate']);
$TotalSalesOrders += $row['ordervalue'];
echo ' <td> ' . $row['orderno'] . ' </td>
<td> ' . $row['name'] . ' </td>
<td>' . $OrderDate . '</td>
<td>' . $DelDate . '</td>
<td class="number">' . $FormatedOrderValue . '</td>
<td>' . $row['currcode'] . '</td>
</tr>';
}
echo '<tr>
<td colspan=3>' . _('Total') . '</td>
<td colspan=3 class="number">' . locale_number_format($TotalSalesOrders, $row['currdecimalplaces']) . '</td>
</tr>';
echo '</table>';
if ($j < 0) {
$j = 11;
echo $tableheader;
}
if ($k == 1) {
echo '<tr class="EvenTableRows">';
$k = 0;
} else {
echo '<tr class="OddTableRows">';
$k = 1;
}
printf('<td>%s</td>
<td class="number">%s</td>
<td class="number">%s</td>
<td class="number">%s%%</td>
</tr>', $ph[0], locale_number_format($ph[1], $DecimalPlaces), locale_money_format($ph[2], $_SESSION['CompanyRecord']['currencydefault']), locale_number_format($ph[3] * 100, 2));
}
echo '</table>';
} else {
echo '<p>' . _('No history of sales of') . ' ' . $StockID . ' ' . _('to') . ' ' . $DebtorNo . '</p>';
}
}
//end of displaying price history for a debtor
echo '<div class="centre">';
echo '<br /><a href="' . $rootpath . '/StockMovements.php?StockID=' . $StockID . '">' . _('Show Movements') . '</a>';
echo '<br /><a href="' . $rootpath . '/StockUsage.php?StockID=' . $StockID . '">' . _('Show Usage') . '</a>';
echo '<br /><a href="' . $rootpath . '/SelectSalesOrder.php?SelectedStockItem=' . $StockID . '">' . _('Search Outstanding Sales Orders') . '</a>';
echo '<br /><a href="' . $rootpath . '/SelectCompletedOrder.php?SelectedStockItem=' . $StockID . '">' . _('Search Completed Sales Orders') . '</a>';
if ($Its_A_KitSet_Assembly_Or_Dummy == False) {
echo '<br /><a href="' . $rootpath . '/PO_SelectOSPurchOrder.php?SelectedStockItem=' . $StockID . '">' . _('Search Outstanding Purchase Orders') . '</a>';
}
<td>' . $LineRow['uom'] . '</td>
<td><input type="checkbox" name="' . $LineRow['dispatchid'] . 'Completed' . $LineRow['dispatchitemsid'] . '" /></td>
<td><select minlength="0" name="' . $LineRow['dispatchid'] . 'Tag' . $LineRow['dispatchitemsid'] . '">';
$SQL = "SELECT tagref,\n\t\t\t\t\t\t\ttagdescription\n\t\t\t\t\t\tFROM tags\n\t\t\t\t\t\tORDER BY tagref";
$TagResult = DB_query($SQL, $db);
echo '<option value=0>0 - None</option>';
while ($mytagrow = DB_fetch_array($TagResult)) {
if (isset($_SESSION['Adjustment']->tag) and $_SESSION['Adjustment']->tag == $mytagrow['tagref']) {
echo '<option selected="selected" value="' . $mytagrow['tagref'] . '">' . $mytagrow['tagref'] . ' - ' . $myrow['tagdescription'] . '</option>';
} else {
echo '<option value="' . $mytagrow['tagref'] . '">' . $mytagrow['tagref'] . ' - ' . $mytagrow['tagdescription'] . '</option>';
}
}
echo '</select></td>';
// End select tag
echo '</tr>';
echo '<input type="hidden" class="number" name="' . $LineRow['dispatchid'] . 'StockID' . $LineRow['dispatchitemsid'] . '" value="' . $LineRow['stockid'] . '" />';
echo '<input type="hidden" class="number" name="' . $LineRow['dispatchid'] . 'Location' . $LineRow['dispatchitemsid'] . '" value="' . $_POST['Location'] . '" />';
echo '<input type="hidden" class="number" name="' . $LineRow['dispatchid'] . 'RequestedQuantity' . $LineRow['dispatchitemsid'] . '" value="' . locale_number_format($LineRow['quantity'] - $LineRow['qtydelivered'], $LineRow['decimalplaces']) . '" />';
echo '<input type="hidden" class="number" name="' . $LineRow['dispatchid'] . 'Department' . $LineRow['dispatchitemsid'] . '" value="' . $myrow['description'] . '" />';
}
// end while order line detail
echo '</table></td></tr>';
}
//end while header loop
echo '</table>';
echo '<br /><div class="centre"><input type="submit" name="UpdateAll" value="' . _('Update') . '" /></div>
</div>
</form>';
}
include 'includes/footer.inc';
$OldProvince = '';
while ($myrow = DB_fetch_array($TaxRatesResult)) {
if ($OldProvince != $myrow['dispatchtaxprovince'] and $OldProvince != '') {
echo '<tr style="background-color:#555555"><td colspan="3"></td></tr>';
}
if ($k == 1) {
echo '<tr class="EvenTableRows">';
$k = 0;
} else {
echo '<tr class="OddTableRows">';
$k = 1;
}
printf('<td>%s</td>
<td>%s</td>
<td><input type="text" class="number" name="%s" required="required" minlength="1" maxlength="5" size="5" value="%s" /></td>
</tr>', $myrow['taxprovincename'], $myrow['taxcatname'], $myrow['dispatchtaxprovince'] . '_' . $myrow['taxcatid'], locale_number_format($myrow['taxrate'] * 100, 2));
$OldProvince = $myrow['dispatchtaxprovince'];
}
//end of while loop
echo '</table>';
echo '<div class="centre">
<input type="submit" name="UpdateRates" value="' . _('Update Rates') . '" />
</div>';
} else {
prnMsg(_('There are no tax rates to show - perhaps the dispatch tax province records have not yet been created?'), 'warn');
}
echo '<div class="centre">
<a href="' . $RootPath . '/TaxAuthorities.php">' . _('Tax Authorities') . '</a>
<br />
<a href="' . $RootPath . '/TaxGroups.php">' . _('Tax Groupings') . '</a>
<br />
<th>' . _('Price Effective To Date') . '</th>
<th>' . _('Quantity Break') . '</th>
<th>' . _('Sell Price') . '</th>
</tr>';
$k = 0;
//row colour counter
while ($myrow = DB_fetch_array($result)) {
if ($k == 1) {
echo '<tr class="EvenTableRows">';
$k = 0;
} else {
echo '<tr class="OddTableRows">';
$k = 1;
}
$DeleteURL = htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8') . '?Delete=yes&SalesType=' . $myrow['salestype'] . '&StockID=' . $myrow['stockid'] . '&QuantityBreak=' . $myrow['quantitybreak'] . '&Price=' . $myrow['price'] . '&currabrev=' . $myrow['currabrev'] . '&StartDate=' . $myrow['startdate'] . '&EndDate=' . $myrow['enddate'];
$EditURL = htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8') . '?Edit=yes&StockID=' . $myrow['stockid'] . '&TypeAbbrev=' . $myrow['salestype'] . '&CurrAbrev=' . $myrow['currabrev'] . '&Price=' . locale_number_format($myrow['price'], $myrow['currdecimalplaces']) . '&StartDate=' . $myrow['startdate'] . '&EndDate=' . $myrow['enddate'] . '&QuantityBreak=' . $myrow['quantitybreak'];
if (in_array(5, $_SESSION['AllowedPageSecurityTokens'])) {
printf('<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td class="number">%s</td>
<td class="number">%s</td>
<td><a href="%s" onclick="return confirm(\'' . _('Are you sure you wish to delete this discount matrix record?') . '\');">' . _('Delete') . '</a></td>
<td><a href="%s">' . _('Edit') . '</a></td>
</tr>', $myrow['currency'], $myrow['sales_type'], ConvertSQLDate($myrow['startdate']), ConvertSQLDate($myrow['enddate']), $myrow['quantitybreak'], $myrow['price'], $DeleteURL, $EditURL);
} else {
printf('<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
echo '<th>' . $Supplier . '<br />' . _('Price') . '</th>';
echo '<th>' . _('Delivery By') . '</th>';
$i = 0;
while ($MyItemRow = DB_fetch_array($ItemResult)) {
echo '<tr><td>' . $MyItemRow['stockid'] . '</td>';
echo '<td>' . $MyItemRow['description'] . '</td>';
echo '<input type="hidden" name="StockID' . $i . '" value="' . $MyItemRow['stockid'] . '" />';
echo '<input type="hidden" name="ItemDescription' . $i . '" value="' . $MyItemRow['description'] . '" />';
echo '<td>' . $MyItemRow['suppliers_partno'] . '</td>';
echo '<td class="number">' . locale_number_format($MyItemRow['quantity'], $MyItemRow['decimalplaces']) . '</td>';
echo '<td>' . $MyItemRow['units'] . '</td>';
echo '<td>' . ConvertSQLDate($MyItemRow['requiredbydate']) . '</td>';
if ($MyItemRow['suppliersuom'] == '') {
$MyItemRow['suppliersuom'] = $MyItemRow['units'];
}
echo '<td><input type="text" class="number" size="10" name="Qty' . $i . '" value="' . locale_number_format($MyItemRow['quantity'], $MyItemRow['decimalplaces']) . '" /></td>';
echo '<input type="hidden" name="UOM' . $i . '" value="' . $MyItemRow['units'] . '" />';
echo '<input type="hidden" name="DecimalPlaces' . $i . '" value="' . $MyItemRow['decimalplaces'] . '" />';
echo '<td>' . $MyItemRow['suppliersuom'] . '</td>';
echo '<td>' . $myrow['currcode'] . '</td>';
echo '<td><input type="text" class="number" size="10" name="Price' . $i . '" value="0.00" /></td>';
echo '<td><input type="text" class="date" alt="' . $_SESSION['DefaultDateFormat'] . '" name="RequiredByDate' . $i . '" size="11" value="' . ConvertSQLDate($MyItemRow['requiredbydate']) . '" /></td>';
$i++;
}
echo '</form>';
}
echo '</table>';
}
if (isset($_POST['Search'])) {
/*ie seach for stock items */
echo '<form method="post" action="' . htmlspecialchars($_SERVER['PHP_SELF'] . '?identifier=' . $identifier) . '">';
