<?php

/* $Revision: 1.19 $ */

$PageSecurity = 1;

include('includes/session.inc');

$title = _('Search All Quotation');

include('includes/header.inc');

echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/magnifier.png" title="' . _('Search') . '" alt="">' . ' ' . _('Search Quotation Orders') . '</p>';

echo "<form action='" . $_SERVER['PHP_SELF'] . '?' . SID ."' method=post>";

if (isset($_POST['completed'])) {
	$completed='=1';
	$ShowChecked='checked="checked"';
} else {
	$completed='>=0';
	$ShowChecked='';
}

if (isset($_GET['SelectedStockItem'])){
	$SelectedStockItem = $_GET['SelectedStockItem'];
} elseif (isset($_POST['SelectedStockItem'])){
	$SelectedStockItem = $_POST['SelectedStockItem'];
}
if (isset($_GET['OrderNumber'])){
	$OrderNumber = $_GET['OrderNumber'];
} elseif (isset($_POST['OrderNumber'])){
	$OrderNumber = $_POST['OrderNumber'];
}
if (isset($_GET['CustomerRef'])){
	$CustomerRef = $_GET['CustomerRef'];
} elseif (isset($_POST['CustomerRef'])){
	$CustomerRef = $_POST['CustomerRef'];
}
if (isset($_GET['SelectedCustomer'])){
	$SelectedCustomer = $_GET['SelectedCustomer'];
} elseif (isset($_POST['SelectedCustomer'])){
	$SelectedCustomer = $_POST['SelectedCustomer'];
}

if (isset($SelectedStockItem) and $SelectedStockItem==''){
	unset($SelectedStockItem);
}
if (isset($OrderNumber) and $OrderNumber==''){
	unset($OrderNumber);
}
if (isset($CustomerRef) and $CustomerRef==''){
	unset($CustomerRef);
}
if (isset($SelectedCustomer) and $SelectedCustomer==''){
	unset($SelectedCustomer);
}
if (isset($_POST['ResetPart'])) {
		unset($SelectedStockItem);
}

if (isset($OrderNumber)) {
	echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/sales.png" title="' . _('Quotation Order') . '" alt="">' . ' ' . _('Quotation  Number') . ' - ' . $OrderNumber . '</p>';
} elseif (isset($CustomerRef)) {
	echo _('Customer Ref') . ' - ' . $CustomerRef;
} else {
	if (isset($SelectedCustomer)) {
		echo _('For customer') . ': ' . $SelectedCustomer .' ' . _('and') . ' ';
		echo "<input type=hidden name='SelectedCustomer' value='$SelectedCustomer'>";
	}

	if (isset($SelectedStockItem)) {

		echo _('for the part') . ': ' . $SelectedStockItem . ' ' . _('and') . ' ' ."<input type=hidden name='SelectedStockItem' value='$SelectedStockItem'>";

	}
}


if (isset($_POST['SearchParts']) and $_POST['SearchParts']!='')
{

		if ($_POST['Keywords']!='' AND $_POST['StockCode']!='') {
			echo _('Stock description keywords have been used in preference to the Stock code extract entered');
		}
		if ($_POST['Keywords']!='') {
			//insert wildcard characters in spaces
	
			$i=0;
			$SearchString = '%';
			while (strpos($_POST['Keywords'], ' ', $i)) {
				$wrdlen=strpos($_POST['Keywords'],' ',$i) - $i;
				$SearchString=$SearchString . substr($_POST['Keywords'],$i,$wrdlen) . '%';
				$i=strpos($_POST['Keywords'],' ',$i) +1;
			}
			$SearchString = $SearchString. substr($_POST['Keywords'],$i).'%';
		
		if (isset($_POST['completed'])) {
			$SQL = "SELECT stockmaster.stockid, 
				stockmaster.description, 
				SUM(locstock.quantity) AS qoh,  
				SUM(purchorderdetails.quantityord-purchorderdetails.quantityrecd) AS qoo,  
				stockmaster.units, 
				SUM(salesquotationdetails.quantity - salesquotationdetails.qtyinvoiced) AS qdem 
			FROM (((stockmaster LEFT JOIN salesquotationdetails on stockmaster.stockid = salesquotationdetails.stkcode) 
				 LEFT JOIN locstock ON stockmaster.stockid=locstock.stockid)
				 LEFT JOIN purchorderdetails on stockmaster.stockid = purchorderdetails.itemcode) 
			WHERE salesquotationdetails.completed =1 
			AND stockmaster.description " . LIKE . "'$SearchString' 
			AND stockmaster.categoryid='" . $_POST['StockCat'] . "' 
			GROUP BY stockmaster.stockid, 
				stockmaster.description, 
				stockmaster.units 
			ORDER BY stockmaster.stockid";
		} else {
			$SQL = "SELECT stockmaster.stockid, 
				stockmaster.description, 
				SUM(locstock.quantity) AS qoh,  
				SUM(purchorderdetails.quantityord-purchorderdetails.quantityrecd) AS qoo,  
				stockmaster.units, 
				SUM(salesquotationdetails.quantity - salesquotationdetails.qtyinvoiced) AS qdem 
			FROM (((stockmaster LEFT JOIN salesquotationdetails on stockmaster.stockid = salesquotationdetails.stkcode) 
				 LEFT JOIN locstock ON stockmaster.stockid=locstock.stockid)
				 LEFT JOIN purchorderdetails on stockmaster.stockid = purchorderdetails.itemcode) 
			WHERE stockmaster.description " . LIKE . "'$SearchString' 
			AND stockmaster.categoryid='" . $_POST['StockCat'] . "' 
			GROUP BY stockmaster.stockid, 
				stockmaster.description, 
				stockmaster.units 
			ORDER BY stockmaster.stockid";
		}

	} elseif ($_POST['StockCode']!=''){
		if (isset($_POST['completed'])) {
			$SQL = "SELECT stockmaster.stockid, 
				stockmaster.description, 
				SUM(locstock.quantity) AS qoh, 
				SUM(purchorderdetails.quantityord-purchorderdetails.quantityrecd) AS qoo,  
				SUM(salesquotationdetails.quantity - salesquotationdetails.qtyinvoiced) AS qdem, 
				stockmaster.units 
			FROM (((stockmaster LEFT JOIN salesquotationdetails on stockmaster.stockid = salesquotationdetails.stkcode) 
				 LEFT JOIN locstock ON stockmaster.stockid=locstock.stockid)
				 LEFT JOIN purchorderdetails on stockmaster.stockid = purchorderdetails.itemcode) 
			WHERE salesquotationdetails.completed =1 
			AND stockmaster.stockid " . LIKE . " '%" . $_POST['StockCode'] . "%' 
			AND stockmaster.categoryid='" . $_POST['StockCat'] . "' 
			GROUP BY stockmaster.stockid, 
				stockmaster.description, 
				stockmaster.units 
			ORDER BY stockmaster.stockid";
		} else {
			$SQL = "SELECT stockmaster.stockid, 
				stockmaster.description, 
				SUM(locstock.quantity) AS qoh, 
				SUM(purchorderdetails.quantityord-purchorderdetails.quantityrecd) AS qoo,  
				SUM(salesquotationdetails.quantity - salesquotationdetails.qtyinvoiced) AS qdem, 
				stockmaster.units 
			FROM (((stockmaster LEFT JOIN salesquotationdetails on stockmaster.stockid = salesquotationdetails.stkcode) 
				 LEFT JOIN locstock ON stockmaster.stockid=locstock.stockid)
				 LEFT JOIN purchorderdetails on stockmaster.stockid = purchorderdetails.itemcode) 
			WHERE stockmaster.stockid " . LIKE . " '%" . $_POST['StockCode'] . "%' 
			AND stockmaster.categoryid='" . $_POST['StockCat'] . "' 
			GROUP BY stockmaster.stockid, 
				stockmaster.description, 
				stockmaster.units 
			ORDER BY stockmaster.stockid";
		}

	} elseif ($_POST['StockCode']=='' AND $_POST['Keywords']=='' AND $_POST['StockCat']!='') {
		
		if (isset($_POST['completed'])) {
			$SQL = "SELECT stockmaster.stockid, 
				stockmaster.description, 
				SUM(locstock.quantity) AS qoh, 
				SUM(purchorderdetails.quantityord-purchorderdetails.quantityrecd) AS qoo,  
				SUM(salesquotationdetails.quantity - salesquotationdetails.qtyinvoiced) AS qdem, 
				stockmaster.units 
			FROM (((stockmaster LEFT JOIN salesquotationdetails on stockmaster.stockid = salesquotationdetails.stkcode) 
				 LEFT JOIN locstock ON stockmaster.stockid=locstock.stockid)
				 LEFT JOIN purchorderdetails on stockmaster.stockid = purchorderdetails.itemcode) 
			WHERE salesquotationdetails.completed=1 
			AND stockmaster.categoryid='" . $_POST['StockCat'] . "' 
			GROUP BY stockmaster.stockid, 
				stockmaster.description, 
				stockmaster.units 
			ORDER BY stockmaster.stockid";
		} else {
			$SQL = "SELECT stockmaster.stockid, 
				stockmaster.description, 
				SUM(locstock.quantity) AS qoh, 
				SUM(purchorderdetails.quantityord-purchorderdetails.quantityrecd) AS qoo,  
				SUM(salesquotationdetails.quantity - salesquotationdetails.qtyinvoiced) AS qdem, 
				stockmaster.units 
			FROM (((stockmaster LEFT JOIN salesquotationdetails on stockmaster.stockid = salesquotationdetails.stkcode) 
				 LEFT JOIN locstock ON stockmaster.stockid=locstock.stockid)
				 LEFT JOIN purchorderdetails on stockmaster.stockid = purchorderdetails.itemcode) 
			WHERE stockmaster.categoryid='" . $_POST['StockCat'] . "' 
			GROUP BY stockmaster.stockid, 
				stockmaster.description, 
				stockmaster.units 
			ORDER BY stockmaster.stockid";
		}

	}

	if (strlen($SQL)<2){
		prnMsg(_('No selections have been made to search for parts') . ' - ' . _('choose a stock category or enter some characters of the code or description then try again'),'warn');
	} else {
		
		$ErrMsg = _('No stock items were returned by the SQL because');
		$DbgMsg = _('The SQL used to retrieve the searched parts was');
		$StockItemsResult = DB_query($SQL,$db,$ErrMsg,$DbgMsg);
		
		if (DB_num_rows($StockItemsResult)==1){
		  	$myrow = DB_fetch_row($StockItemsResult);
		  	$SelectedStockItem = $myrow[0];
			$_POST['SearchOrders']='True';
		  	unset($StockItemsResult);
		  	echo '<br>' . _('For the part') . ': ' . $SelectedStockItem . ' ' . _('and') . " <input type=hidden name='SelectedStockItem' value='$SelectedStockItem'>";
		}
	}
} else if (isset($_POST['SearchOrders']) AND Is_Date($_POST['OrdersAfterDate'])==1) {

	//figure out the SQL required from the inputs available
	if (isset($OrderNumber)) {
			$SQL = "SELECT salesquotation.quotationorderno, 
					debtorsmaster.name, 
					custbranch.brname, 
					salesquotation.customerref, 
					salesquotation.orddate, 
					salesquotation.deliverto,salesquotation.confirmeddate, SUM(salesquotationdetails.unitprice*salesquotationdetails.quantity*(1-salesquotationdetails.discountpercent)) AS ordervalue 
				FROM salesquotation, 
					salesquotationdetails, 
					debtorsmaster, 
					custbranch 
				WHERE salesquotation.quotationorderno = salesquotationdetails.quotationorderno 
				AND salesquotation.branchcode = custbranch.branchcode 
				AND salesquotation.debtorno = debtorsmaster.debtorno 
				AND debtorsmaster.debtorno = custbranch.debtorno 
				AND salesquotation.quotationorderno=". $OrderNumber ." 
				AND salesquotation.quotation=1 
				AND salesquotationdetails.completed".$completed." 
				GROUP BY salesquotation.quotationorderno,
					debtorsmaster.name, 
					custbranch.brname, 
					salesquotation.customerref, 
					salesquotation.orddate, 
					salesquotation.deliverto
				ORDER BY salesquotation.quotationorderno";
	} elseif (isset($CustomerRef)) {
			$SQL = "SELECT salesquotation.quotationorderno, 
					debtorsmaster.name, 
					custbranch.brname, 
					salesquotation.customerref, 
					salesquotation.orddate, 
					salesquotation.deliverto,salesquotation.confirmeddate, SUM(salesquotationdetails.unitprice*salesquotationdetails.quantity*(1-salesquotationdetails.discountpercent)) AS ordervalue 
				FROM salesquotation, 
					salesquotationdetails, 
					debtorsmaster, 
					custbranch 
				WHERE salesquotation.quotationorderno = salesquotationdetails.quotationorderno 
				AND salesquotation.branchcode = custbranch.branchcode 
				AND salesquotation.debtorno = debtorsmaster.debtorno 
				AND debtorsmaster.debtorno = custbranch.debtorno 
				AND salesquotation.customerref like '%". $CustomerRef."%'
				AND salesquotation.quotation=1 
				AND salesquotationdetails.completed".$completed." 
				GROUP BY salesquotation.quotationorderno,
					debtorsmaster.name, 
					custbranch.brname, 
					salesquotation.customerref, 
					salesquotation.orddate, 
					salesquotation.deliverto
				ORDER BY salesquotation.quotationorderno";
	
	} else {
		$DateAfterCriteria = FormatDateforSQL($_POST['OrdersAfterDate']);

		if (isset($SelectedCustomer) AND !isset($OrderNumber) AND !isset($CustomerRef)) {

			if (isset($SelectedStockItem)) {
				$SQL = "SELECT salesquotation.quotationorderno, 
						debtorsmaster.name, 
						custbranch.brname, 
						salesquotation.customerref, 
						salesquotation.orddate, 
						salesquotation.deliverto,salesquotation.confirmeddate, SUM(salesquotationdetails.unitprice*salesquotationdetails.quantity*(1-salesquotationdetails.discountpercent)) AS ordervalue 
					FROM salesquotation, 
						salesquotationdetails, 
						debtorsmaster, 
						custbranch 
					WHERE salesquotation.quotationorderno = salesquotationdetails.quotationorderno 
					AND salesquotation.branchcode = custbranch.branchcode 
					AND salesquotation.debtorno = debtorsmaster.debtorno 
					AND debtorsmaster.debtorno = custbranch.debtorno 
					AND salesquotationdetails.stkcode='". $SelectedStockItem ."' 
					AND salesquotation.debtorno='" . $SelectedCustomer ."' 
					AND salesquotation.orddate >= '" . $DateAfterCriteria ."' 
					AND salesquotation.quotation=1 
					AND salesquotationdetails.completed".$completed." 
					GROUP BY salesquotation.quotationorderno, 
						debtorsmaster.name, 
						custbranch.brname, 
						salesquotation.customerref, 
						salesquotation.orddate, 
						salesquotation.deliverto
					ORDER BY salesquotation.quotationorderno";
			} else {
				$SQL = "SELECT salesquotation.quotationorderno, 
						debtorsmaster.name, 
						custbranch.brname, 
						salesquotation.customerref, 
						salesquotation.orddate, 
						salesquotation.deliverto,salesquotation.confirmeddate, 
						SUM(salesquotationdetails.unitprice*salesquotationdetails.quantity*(1-salesquotationdetails.discountpercent)) AS ordervalue 
					FROM salesquotation, 
						salesquotationdetails, 
						debtorsmaster, 
						custbranch 
					WHERE salesquotation.quotationorderno = salesquotationdetails.quotationorderno 
					AND salesquotation.debtorno = debtorsmaster.debtorno 
					AND salesquotation.branchcode = custbranch.branchcode 
					AND debtorsmaster.debtorno = custbranch.debtorno 
					AND salesquotation.debtorno='" . $SelectedCustomer . "' 
					AND salesquotation.orddate >= '" . $DateAfterCriteria . "' 
					AND salesquotation.quotation=1 
					AND salesquotationdetails.completed".$completed." 
					GROUP BY salesquotation.quotationorderno, 
						debtorsmaster.name, 
						custbranch.brname, 
						salesquotation.customerref, 
						salesquotation.orddate, 
						salesquotation.deliverto
					ORDER BY salesquotation.quotationorderno";
			}
		} else { //no customer selected
			if (isset($SelectedStockItem)) {
				$SQL = "SELECT salesquotation.quotationorderno, 
						debtorsmaster.name, 
						custbranch.brname, 
						salesquotation.customerref, 
						salesquotation.orddate, 
						salesquotation.deliverto,salesquotation.confirmeddate, 
						SUM(salesquotationdetails.unitprice*salesquotationdetails.quantity*(1-salesquotationdetails.discountpercent)) AS ordervalue 
					FROM salesquotation, 
						salesquotationdetails, 
						debtorsmaster, 
						custbranch 
					WHERE salesquotation.quotationorderno = salesquotationdetails.quotationorderno 
					AND salesquotation.debtorno = debtorsmaster.debtorno 
					AND salesquotation.branchcode = custbranch.branchcode 
					AND debtorsmaster.debtorno = custbranch.debtorno 
					AND salesquotationdetails.stkcode='". $SelectedStockItem ."'  
					AND salesquotation.orddate >= '" . $DateAfterCriteria . "' 
					AND salesquotation.quotation=1 
					AND salesquotationdetails.completed".$completed." 
					GROUP BY salesquotation.quotationorderno, 
						debtorsmaster.name, 
						custbranch.brname, 
						salesquotation.customerref, 
						salesquotation.orddate, 
						salesquotation.deliverto
					ORDER BY salesquotation.quotationorderno";
			} else {
				$SQL = "SELECT salesquotation.quotationorderno, 
						debtorsmaster.name, 
						custbranch.brname, 
						salesquotation.customerref, 
						salesquotation.orddate, 
						salesquotation.deliverto,salesquotation.confirmeddate, 
						SUM(salesquotationdetails.unitprice*salesquotationdetails.quantity*(1-salesquotationdetails.discountpercent)) AS ordervalue 
					FROM salesquotation, 
						salesquotationdetails, 
						debtorsmaster, 
						custbranch 
					WHERE salesquotation.quotationorderno = salesquotationdetails.quotationorderno 
					AND salesquotation.debtorno = debtorsmaster.debtorno 
					AND salesquotation.branchcode = custbranch.branchcode 
					AND debtorsmaster.debtorno = custbranch.debtorno 
					AND salesquotation.orddate >= '$DateAfterCriteria' 
					AND salesquotation.quotation=1 
					AND salesquotationdetails.completed".$completed." 
					GROUP BY salesquotation.quotationorderno, 
						debtorsmaster.name, 
						custbranch.brname, 
						salesquotation.customerref, 
						salesquotation.orddate, 
						salesquotation.deliverto
					ORDER BY salesquotation.quotationorderno";
			}
		} //end selected customer
	} //end not order number selected

	$salesquotationResult = DB_query($SQL,$db);

	if (DB_error_no($db) !=0) {
		echo '<br>' . _('No Quotation were returned by the SQL because') . ' ' . DB_error_msg($db);
		echo "<br>$SQL";
	}

}//end of which button clicked options

if (!isset($_POST['OrdersAfterDate']) OR $_POST['OrdersAfterDate'] == '' OR ! Is_Date($_POST['OrdersAfterDate'])){
	$_POST['OrdersAfterDate'] = Date($_SESSION['DefaultDateFormat'],Mktime(0,0,0,Date('m')-2,Date('d'),Date('Y')));
}
echo "<table>";
if (!isset($OrderNumber) or $OrderNumber==''){
	echo '<tr><td>' . _('Quotation  Number') . ':</td><td>' . "<input type='text' name='OrderNumber' maxlength =8 size=9></td><td>" . _('for all quotation placed after') .
			": </td><td><input type='text' name='OrdersAfterDate' maxlength =10 size=11 value=" . $_POST['OrdersAfterDate'] . "></td><td>" .
			"<input type='submit' name='SearchOrders' value='" . _('Search Quotation') . "'></td></tr>";
	echo '<tr><td>' . _('Customer Ref') . ':</td><td>' . "<input type='text' name='CustomerRef' maxlength =8 size=9></td>
			<td></td><td colspan=2><input type='checkbox' ".$ShowChecked." name='completed' />"._('Show Completed Quotation only') . "</td></tr>";
}
echo '</table>';

if (!isset($SelectedStockItem)) {
	$SQL='SELECT categoryid, categorydescription FROM stockcategory ORDER BY categorydescription';
	$result1 = DB_query($SQL,$db);

   echo '<hr>';
   echo '<div class="centre"><font size=1>' . _('To search for sales orders for a specific part use the part selection facilities below') . '   </font>';
   echo '<input type="submit" name="SearchParts" value="' . _('Search Parts Now') . '">';
   
   if (count($_SESSION['AllowedPageSecurityTokens'])>1){
   	echo '<input type=submit name="ResetPart" value="' . _('Show All') . '"></div>';
   }
   echo '<table>';
   echo '<tr><td><font size=1>' . _('Select a stock category') . ':</font>';
   echo '<select name="StockCat">';

	while ($myrow1 = DB_fetch_array($result1)) {
		if (isset($_POST['StockCat']) and $myrow1['categoryid'] == $_POST['StockCat']){
			echo "<option selected value='". $myrow1['categoryid'] . "'>" . $myrow1['categorydescription'];
		} else {
			echo "<option value='". $myrow1['categoryid'] . "'>" . $myrow1['categorydescription'];
		}
	}

   echo '</select>';
   echo '<td><font size=1>' . _('Enter text extracts in the description') . ':</font></td>';
   echo '<td><input type="text" name="Keywords" size=20 maxlength=25></td></tr>';
   echo '<tr><td></td>';
   echo '<td><font size=3><b> ' ._('OR') . ' </b></font><font size=1>' . _('Enter extract of the Stock Code') . ':</font></td>';
   echo '<td><input type="text" name="StockCode" size=15 maxlength=18></td>';
   echo '</tr>';
   echo '</table>';

   echo '<hr>';

}

If (isset($StockItemsResult)) {

	echo '<table cellpadding=2 colspan=7 border=2>';

	$TableHeadings = "<tr><th>" . _('Code') . "</th>" .
				"<th>" . _('Description') . "</th>" .
				"<th>" . _('On Hand') . '</th>' .
				"<th>" . _('Purchase Orders') . '</th>' .
				"<th>" . _('Sales Orders') . "</th>" .
				"<th>" . _('Units') . '</th></tr>';

	echo $TableHeadings;

	$j = 1;
	$k=0; //row colour counter

	while ($myrow=DB_fetch_array($StockItemsResult)) {

		if ($k==1){
			echo '<tr class="EvenTableRows">';
			$k=0;
		} else {
			echo '<tr class="OddTableRows">';
			$k++;
		}

		printf("<td><font size=1><input type='submit' name='SelectedStockItem' value='%s'</font></td>
			<td><font size=1>%s</font></td>
			<td align=right><font size=1>%s</font></td>
			<td align=right><font size=1>%s</font></td>
			<td align=right><font size=1>%s</font></td>
			<td><font size=1>%s</font></td></tr>", 
			$myrow['stockid'], 
			$myrow['description'], 
			$myrow['qoh'], 
			$myrow['qoo'],
			$myrow['qdem'],
			$myrow['units']);

//end of page full new headings if
	}
//end of while loop

	echo '</table>';

}
//end if stock search results to show

If (isset($salesquotationResult)) {

/*show a table of the orders returned by the SQL */

	echo '<table cellpadding=2 colspan=6 width=100%>';

	$tableheader = "<tr><th>" . _('Quotation') . " #</th>
			<th>" . _('Customer') . "</th>
			<th>" . _('Branch') . "</th>
			<th>" . _('Cust Ref') . " #</th>
			<th>" . _('Order Date') . "</th>
			<th>" . _('Validity Date') . "</th>
			<th>" . _('Delivery To') . "</th>
			<th>" . _('Order Total') . "</th></tr>";

	echo $tableheader;

	$j = 1;
	$k=0; //row colour counter
	while ($myrow=DB_fetch_array($salesquotationResult)) {


		if ($k==1){
			echo '<tr class="EvenTableRows">';
			$k=0;
		} else {
			echo '<tr class="OddTableRows">';
			$k=1;
		}

		$ViewPage = $rootpath . '/OrderDetails.php?' .SID . '&OrderNumber=' . $myrow['quotationorderno'];
		$FormatedDelDate = ConvertSQLDate($myrow['confirmeddate']);
		$FormatedOrderDate = ConvertSQLDate($myrow['orddate']);
		$FormatedOrderValue = number_format($myrow['ordervalue'],2);

		printf("<td>%s</td>
			<td>%s</td>
			<td>%s</td>
			<td>%s</td>
			<td>%s</td>
			<td>%s</td>
			<td>%s</td>
			<td align=right>%s</td>
			</tr>", 
			$myrow['quotationorderno'], 
			$myrow['name'], 
			$myrow['brname'], 
			$myrow['customerref'],
			$FormatedOrderDate,
			$FormatedDelDate, 
			$myrow['deliverto'], 
			$FormatedOrderValue);

//end of page full new headings if
	}
//end of while loop

	echo '</table>';

}

echo '</form>';
include('includes/footer.inc');

?>
