<?php

/* $Revision: 1.19 $ */

$PageSecurity = 1;

include('includes/session.inc');

$title = _('Search All Delivery Orders');

include('includes/header.inc');

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

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

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

/*$completed='=0';*/
/*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)) {
$_REQUEST['OrderNumber'] = trim($_REQUEST['OrderNumber']);
	if (!is_numeric($_REQUEST['OrderNumber'])){
		  echo '<br><b>' . _('The Order Number entered MUST be numeric') . '</b><br>';
		  unset ($_REQUEST['OrderNumber']);
		  include('includes/footer.inc');
		  exit;
	}
else {

	echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/sales.png" title="' . _('Sales Order') . '" alt="">' . ' ' . _('Order 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['SearchOrders']))
 {
							$today=(date("Y-m-d"));
							//echo $today;
							//$today ;
							
							//echo ConvertSQLDateFormatDateforSQL$DateAfterCriteria;
								//figure out the SQL required from the inputs available
				if (isset($OrderNumber))
				 {
						$SQL = "SELECT open_salesorders.orderno, 
								debtorsmaster.name, 
								custbranch.brname, 
								 
								open_salesorders.orddate, 
								  
								 open_salesorders.confirmeddate, 
								open_salesorders.deliverto, SUM(salesorderdetails.unitprice*salesorderdetails.quantity*(1-salesorderdetails.discountpercent)) AS ordervalue 
							FROM open_salesorders, 
								salesorderdetails, 
								debtorsmaster, 
								custbranch 
							WHERE open_salesorders.orderno = salesorderdetails.orderno 
							AND open_salesorders.branchcode = custbranch.branchcode 
							AND open_salesorders.debtorno = debtorsmaster.debtorno 
							AND debtorsmaster.debtorno = custbranch.debtorno 
							AND open_salesorders.orderno=". $OrderNumber ." 
							AND open_salesorders.quotation=0 
							GROUP BY open_salesorders.orderno,
								debtorsmaster.name, 
								custbranch.brname, 
								 
								open_salesorders.orddate, 
								open_salesorders.confirmeddate,   
								open_salesorders.deliverto
							ORDER BY open_salesorders.orderno";
				}  
				else 
				{
						//$DateAfterCriteria = FormatDateforSQL($_POST['OrdersAfterDate']);
							//$today=Date("Y-m-d");
					//echo $today;
					
					//SEARCHING IS DONE ON THE BASIS OF DATE EXPIRE
							if (!isset($OrderNumber))
										 {
														 $SQL = "SELECT open_salesorders.orderno, 
																debtorsmaster.name, 
																custbranch.brname, 
																 
																open_salesorders.orddate, 
																 open_salesorders.confirmeddate, 
								                                  open_salesorders.deliverto, 
																 SUM(salesorderdetails.unitprice*salesorderdetails.quantity*(1-salesorderdetails.discountpercent)) AS ordervalue 
															FROM open_salesorders, 
																salesorderdetails, 
																debtorsmaster, 
																custbranch 
															WHERE open_salesorders.orderno = salesorderdetails.orderno 
															AND open_salesorders.debtorno = debtorsmaster.debtorno 
															AND open_salesorders.branchcode = custbranch.branchcode 
															AND debtorsmaster.debtorno = custbranch.debtorno 
															AND open_salesorders.confirmeddate  >= '" . $today ."' 
															AND open_salesorders.quotation=0 
															 
															GROUP BY open_salesorders.orderno, 
																debtorsmaster.name, 
																custbranch.brname, 
																 
																open_salesorders.orddate, 
																 open_salesorders.confirmeddate, 
																open_salesorders.deliverto
															ORDER BY open_salesorders.orderno";
											}
							} //end selected customer
	//end not order number selected

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

	

}//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>' . _('Order Number') . ':</td><td>' . "<input type='text' name='OrderNumber' maxlength =8 size=9></td>
	<td>" .
			"<input type='submit' name='SearchOrders' value='" . _('Search Orders') . "'></td></tr>";
	/*echo "<tr>
			<td></td><td colspan=2><input type='checkbox' ".$ShowChecked." name='completed' />"._('Show Completed orders 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($SalesOrdersResult)) {

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


if (DB_num_rows($SalesOrdersResult)==0) {
		prnMsg (_('No orders were returned by the SQL ') ). ' ' ;
		echo "<br>";
	}
	else
	{
	echo '<table cellpadding=2 colspan=6 width=100%>';

	$tableheader = "<tr><th>" . _('Order') . " #</th>
			<th>" . _('Customer') . "</th>
			<th>" . _('Branch') . "</th>
			<th>" . _('Cust Refrence') . " #</th>
			<th>" . _('Order Date') . "</th>
			<th>" . _('Delivery Date') . "</th></tr>";

	echo $tableheader;

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


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

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

		printf("<td><a target='_blank' href='%s'>%s</a></td>
			<td>%s</td>
			<td>%s</td>
			<td>%s</td>
			<td>%s</td>
			<td>%s</td>
			<td>%s</td>
			</tr>", 
			$ViewPage, 
			$myrow['orderno'], 
			$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');

?>
