<?php

session_start();
if($HTTP_SESSION_VARS['dbName']==""){
header("location:../index.php");
}


include("config.inc.php");
set_time_limit(0);

$connection = mysql_connect($config['dbServer'],$config['dbUser'],$config['dbPass']) or die("Could not connect to DB");
mysql_select_db($HTTP_SESSION_VARS['dbName'],$connection) or die("Could not find DB");

$querylog=" select ifNull(FI_DeliveryApp,0) As FI_DeliveryApp, ifNull(login_belongstogrp,0) As FI_BelongsToGrp, ifNull(FI_DeliverySalesPrice,0) As FI_DeliverySalesPrice, ".
		  " ifNull(FI_sorderconfirmed,0) As FI_SalesOrderConfirm ".
          " from ".$HTTP_SESSION_VARS['dbLabel'].".login where user_account='".$HTTP_SESSION_VARS['useraccount']."' and Upper(Login_Schema) = Upper('".$HTTP_SESSION_VARS['dbName']."')  ";
$resultlog=mysql_query($querylog,$connection) or die(mysql_error());
while($rows=mysql_fetch_array($resultlog)){
	extract($rows);
}

$EditHint = '';
$EditMode = '';

$querysetup="select DecimalBase, DecimalBase1, DecimalBase2, base1, base2, grid_color1, grid_color2, ifNull(Setup_VatPercentage,0) As Setup_VatPercentage from setup";
$resultsetup=mysql_query($querysetup,$connection) or die(mysql_error());
while($rowsetup=mysql_fetch_array($resultsetup)){
	extract($rowsetup);
}

//Read From SalesSetup Table
$querySalesSetup="Select SalesTTC From SalesSetup";
$resultSalesSetup=mysql_query($querySalesSetup,$connection) or die(mysql_error());
while($rowSalesSetup=mysql_fetch_array($resultSalesSetup)){
	extract($rowSalesSetup);
}

//Read From Module Table
$querymodule=" Select ifNull(Module_AdditionalTaxes,0) As Module_AdditionalTaxes, ifNull(Module_Pack,0) As Module_Pack, ".
			 " ifNull(Module_Delivery,0) As Module_Delivery, ifNull(Module_TransferSorder,0) As Module_TransferSorder  From Module";
$resultmodule=mysql_query($querymodule,$connection) or die(mysql_error());
while($rowmodule=mysql_fetch_array($resultmodule)){
	extract($rowmodule);
}

$MainCompanyName=explode('_',$HTTP_SESSION_VARS['dbName']);

$queryperiod= " Select ifNull(LockViewPeriod,0) As LockViewPeriod, ViewPeriodDate, ifNull(ViewLockDaily,0) As ViewLockDaily, ViewNumberOfDays ".
              " From ".$HTTP_SESSION_VARS['dbLabel'].".ListUserDir  ".
			  " Where Usercode='".$HTTP_SESSION_VARS['useraccount']."' ".
			  " And Upper(CompanyName) = Upper('".$MainCompanyName[0]."') ".
			  " And Upper(Diryear) = Upper('".$MainCompanyName[1]."') ";
			  
$resultperiod = mysql_query($queryperiod,$connection) or die(mysql_error());
$rowsperiod   = mysql_num_rows($resultperiod);

while($rows=mysql_fetch_array($resultperiod)){
	extract($rows);
}	
			  
//echo $queryperiod;	

$queryproject=" select distinct project.project_code, project_name ".
              " from project left join ".$HTTP_SESSION_VARS['dbLabel'].".loginstk on project.project_code like concat(ifnull(loginstk.project_code,project.project_code),'%') ".
			  " where user_account='".$HTTP_SESSION_VARS['useraccount']."' ".
			  " and (loginstk.project_code is not null and loginstk.project_code != '') ".
			  " order by project.project_code";
$projectresult = mysql_query($queryproject,$connection) or die(mysql_error());
$projectexist  = mysql_num_rows($projectresult);		  

$querycostcent=" select distinct costcent.costcent_code, costcent_name ".
               " from costcent left join ".$HTTP_SESSION_VARS['dbLabel'].".loginstk on costcent.costcent_code like concat(ifnull(loginstk.costcent_code,costcent.costcent_code),'%') ".
			   " where user_account='".$HTTP_SESSION_VARS['useraccount']."' ".
			   " and (loginstk.costcent_code is not null and loginstk.costcent_code != '') ".
			   " order by costcent.costcent_code";
$costcentresult = mysql_query($querycostcent,$connection) or die(mysql_error());
$costcentexist  = mysql_num_rows($costcentresult);		  

$queryledger= " select distinct ledger_number, ledger_include ".
              " from ".$HTTP_SESSION_VARS['dbLabel'].".ledgerstk  ".
			  " where user_account='".$HTTP_SESSION_VARS['useraccount']."' ".
			  " and (ledger_number is not null and ledger_number != '') ".
			  " order by ledger_number";
$ledgerresult = mysql_query($queryledger,$connection) or die(mysql_error());
$ledgerexist  = mysql_num_rows($ledgerresult);	
$rows=mysql_fetch_array($ledgerresult) ;
$ledgerinclude = $rows[1];


if ($PSaClientCode != '') {

	$queryitems = " Select Items.Item_Code, Items.Item_description From Items  ".
				  " Inner Join ( Select SorderDt.Item_Code, ".
				  "              (Sum(ifNull(QuantityDelivered,0)) + Sum(ifNull(QuantityDeliveredTemp,0))) As QuantityUsed, ".
				  "              Sum(ifNull(Sorderdt.SorderDt_Quantity,0)) As QuantityOrdered ".
				  "              From SorderDt ".
				  "              Left Join ".
				  "              ( Select DeliveryDt.RelatedDt_ID, DeliveryDt.Item_code, Sum(ifNull(DeliveryDt.DeliveryDt_Quantity,0)) As QuantityDelivered ".
				  "                From DeliveryDt ".
				  "                Where (DeliveryDt.RelatedDt_ID != '' or DeliveryDt.RelatedDt_ID Is Not Null) ".
				  "                Group By DeliveryDt.RelatedDt_ID, DeliveryDt.Item_code ".
				  "              ) Q1 on Q1.RelatedDt_ID = SorderDt.SorderDt_id and Q1.Item_code = SorderDt.Item_code ".
				  "              Left Join ".
				  "              ( Select Temp_DeliveryDt.RelatedDt_ID, Temp_DeliveryDt.Item_code, Sum(ifNull(Temp_DeliveryDt.DeliveryDt_Quantity,0)) As QuantityDeliveredTemp ".
				  "                From Temp_DeliveryDt ".
				  "                Where (Temp_DeliveryDt.RelatedDt_ID != '' or Temp_DeliveryDt.RelatedDt_ID Is Not Null) ".
				  "                Group By Temp_DeliveryDt.RelatedDt_ID, Temp_DeliveryDt.Item_code ".
				  "              ) Q2 on Q2.RelatedDt_ID = SorderDt.SorderDt_id and Q2.Item_code = SorderDt.Item_code ".
				  "	 Where ifNull(Sorderdt_OldData,0) = 0  ".
				  "  And (('".$PSaClientCode."' != '' and Sorderdt.Client_Code = '".$PSaClientCode."') or ('".$PSaClientCode."' = '' and 1 = 1)) ".
				  "	 Group by SorderDt.Item_Code ".
				  "	 Having QuantityOrdered > QuantityUsed ".
				  "	 ) As Q on Q.Item_Code = Items.Item_Code ".
				  "  Where ifNull(Item_Pack,0) = 0 ".
				  " Order By Items.Item_Code  ";
} else
{
	$queryitems = " Select Item_Code, Item_description From Items Where ifNull(Item_Pack,0) = 0 Order By Item_Code ";
}
	
$resultitems= mysql_query($queryitems,$connection) or die(mysql_error());

print <<<HERE
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" href="default.css" type="text/css" />
<title>Search Confirmed Preparation Order</title>
<script type="text/javascript" language="javascript">

function RefreshPage()
{
  document.search.submit();

}

function clearform()
{
  document.search.PRef.value='';
  document.search.action='Form_Transfer_LoadSorder.php';
  document.search.submit();

}



function PrintPreview(SorId)
{
	var str = '';

	str = 'Form_TransferSalesOrderPreview.php?SorderId='+SorId;
	window.open(str);
	
	self.close();

}


function LoadForm() 
{
	x=document.search;
	x.PRef.focus();
	
	ChangeLocation();
}

function SetNextPage(startrange,perpage){ 
	document.search.action='Form_transfer_LoadSorder.php?PRef=&startrange='+startrange+'&perpage='+perpage;
	document.search.submit();
}

function SetPrvPage(startrange,perpage){
	document.search.action='Form_Transfer_LoadSorder.php?PRef=&startrange='+startrange+'&perpage='+perpage;
	document.search.submit();
}



function SelectRecord(RecordId){
	
	document.search.PMode.value=1;	
	document.search.action="Form_Transfer_Actions.php?mainmode=confirmedsorder&SSaId="+RecordId;
	document.search.submit();


}

function UnConfirmOrder(SorId, SorRef){

	var vMainMode = '';
	var vMsg = '';
	
	vMainMode = 'unconfirmorder';
	vMsg = 'Are you sure you want to Unconfirm order with reference = '+SorRef+' ?';
	
	if (SorId != '') {
		if (confirm (vMsg) )
		{
			document.search.action="Form_Transfer_Actions.php?mainmode="+vMainMode+"&SSaId="+SorId;
			document.search.submit();
		}
	}
	
}

function LoadData(){
	var vSelectedRows = document.search.SelectedRows.value;
	
	if (vSelectedRows != '') {
		var vSaID = document.search.PSaId.value;
		document.search.PMode.value=1;	
		document.search.action="Form_Transfer_Actions.php?mainmode=loadsorder&SSaId="+vSaID+"&SSaDtId="+vSelectedRows;
		document.search.submit();
	} else
		alert ('Please Select an Item.');
	
}


function ChangeLocation()
{
    if (document.search.PMode.value == 1) {
	    var GenId = document.search.GeneratedId.value;
		
		
		opener.document.transfer.transfer_id.value=GenId;
		
	    opener.document.transfer.actionmode.value='submitrecord';
		opener.document.transfer.message.value = document.search.message.value;
		opener.document.transfer.action='Form_Transfer.php';
		opener.document.transfer.submit();
		self.close();
	}	
}

function SelectMaster(vName) {

   
   var MasterCheckName, DetailCheckName, RecName;
   var x, y, z, t;
   
   for (var i=1; i <= document.search.i.value; i++)
  {
    MasterCheckName='M'+i;
	RecName = 'Rec'+MasterCheckName;
	
	x = document.getElementById(MasterCheckName);
	y = document.getElementById(RecName);
	t = document.getElementById(vName);
	
	if (x.checked && x.value == t.value) {
		for (var j=1; j <= y.value; j++)
		{
			DetailCheckName=MasterCheckName+'D'+j;
	
			z = document.getElementById(DetailCheckName);
			z.checked = true;
		}	
	} 
	else if (!(x.checked) &&  x.value == t.value){ 
		for (var j=1; j <= y.value; j++)
		{
			DetailCheckName=MasterCheckName+'D'+j;
	
			z = document.getElementById(DetailCheckName);
			z.checked = false;
		}
	
	}
    
  }
  
  SelectDetail();
  

}

function SelectDetail() {
	var MasterCheckName, DetailCheckName, RecName, vSelectedRows;
	var x, y, z;
	
	vSelectedRows = '';
	for (var i=1; i <= document.search.i.value; i++)
	{
		MasterCheckName='M'+i;
		RecName = 'Rec'+MasterCheckName;
		
		x = document.getElementById(MasterCheckName);
		y = document.getElementById(RecName);
		
		
		for (var j=1; j <= y.value; j++)
		{
			DetailCheckName=MasterCheckName+'D'+j;
		
			z = document.getElementById(DetailCheckName);
			
			if (z.checked)
				vSelectedRows = vSelectedRows + ',' + z.value;
		}	
		
		
	}
	
	vSelectedRows = vSelectedRows.substr(1);
	document.search.SelectedRows.value = vSelectedRows;
}

</script>

<style type="text/css">

body,td,th {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 11px;
}
body {
	margin-top: 2px;
	margin-left: 1px;
}
a:link {
	text-decoration: none;
	color: #0000FF;
}
a:visited {
	text-decoration: none;
	color: #0000FF;
}
a:hover {
	text-decoration: none;
	color: #0000FF;
}
a:active {
	text-decoration: none;
	color: #0000FF;
}
.style11 {color: #999999; font-weight: bold; }
.style12 {
	font-size: 9px;
	color: #999999;
	font-weight: bold;
}
.style15 {color: #5151FF; }
.style16 {
	font-size: 16px;
	color: #FF0000;
	font-weight: bold;
	font-family: "Times New Roman", Times, serif;
}
.style17 {font-size: 9px}
.style25 {color: #999999; font-weight: bold; font-size: 10px; }
.style26 {color: #FF0000}
.style27 {color: #999999 ;font-size: 10px;}
.style28 {color: #000000 ;font-size: 10px;}

</style>

</head>
<body onLoad='LoadForm();'>
<form name='search' method='post' action=''>
<input type='hidden' name='GeneratedId' value='$GeneratedId'>
<input type='hidden' name='SelectedRows' value='$SelectedRows'>

<input type='hidden' name='costcent' value='$costcent'>
<input type='hidden' name='tocostcent' value='$tocostcent'>
<input type='hidden' name='fromwarehouse' value='$fromwarehouse'>
<input type='hidden' name='towarehouse' value='$towarehouse'>
<input type='hidden' name='toproject' value='$toproject'>
<input type='hidden' name='fromproject' value='$fromproject'>
<input type='hidden' name='actionmode' value='$actionmode'>
<input type='hidden' name='transfer_id' value='$transfer_id'>
<input type='hidden' name='transfer_remark' value='$transfer_remark'>
<input type='hidden' name='transfer_date' value='$transfer_date'>
<input type='hidden' name='driver_name' value='$driver_name'>
<input type='hidden' name='vehicle_no' value='$vehicle_no'>
<input type='hidden' name='TransType' value='$TransType'>
<input type='hidden' name='documentrefno' value='$documentrefno'>
HERE;
echo "<input type='hidden' name='message' value='".htmlspecialchars($message, ENT_QUOTES)."'>";
echo "<input type='hidden' name='PSaRemark' value='".htmlspecialchars($PSaRemark, ENT_QUOTES)."' > 
	  <input type='hidden' name='PSaDriverName' value='".htmlspecialchars($PSaDriverName, ENT_QUOTES)."' >
	  <input type='hidden' name='PSaVehicleNumber' value='".htmlspecialchars($PSaVehicleNumber, ENT_QUOTES)."' >
	  <input type='hidden' name='PSaDAddress' value='".htmlspecialchars($PSaDAddress, ENT_QUOTES)."' > 
	  <input type='hidden' name='PSaIAddress' value='".htmlspecialchars($PSaIAddress, ENT_QUOTES)."'> ";


echo"<table border='0' cellspacing='1' style='table-layout:fixed'>
	  <col width=20>
	  <col width=20>
	  <col width=20>
	  <col width=65>
	  <col width=70>
	  <col width=80>
	  <col width=220>
	  <col width=80>
	  <col width=100>
	  <col width=55>
	  <col width=100>
		     
	  <tr bgcolor='#DDDDDD'>
	    <td align='center' colspan='10'><span class='style16'>List of Confirmed Preparation Order</span></td></tr>
	  <tr bgcolor='#DDDDDD'>
	    <td align='left' colspan='4'><span class='style11'>Search by Reference</span></td>
		<td align='left' colspan='3'><span class='style11'><input type='text' name='PRef' id='PRef' value='$PRef' size='15' maxlength='30'/><input type='hidden' name='PMode' id='PMode' value='$PMode' size='15' maxlength='30'/></span>
		    <input type='submit' name='Submit' value='Find' style=' background-color:#4069A7; color:#FFFFFF;font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px;'/>
			<input type='button' name='btnCancel' value='Cancel' onclick='clearform();'style=' background-color:#4069A7; color:#FFFFFF;font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px;'/></td>
		<td align='left' valign='center' colspan='3'><span class='style11'>Result per page </span><span class='style11'><select name='perpage' id='perpage' value='$perpage'>";
              

        if ($perpage==20)
			$s20 = 'selected';
		else if ($perpage==30)
			$s30 = 'selected';
		else if ($perpage==40)
			$s40 = 'selected';
		else if ($perpage==50)
			$s50 = 'selected';
			
				
        echo'<option '.$s20.' value="20">20</option>
			 <option '.$s30.' value="30">30</option>
			 <option '.$s40.' value="40">40</option>
			 <option '.$s50.' value="50">50</option>
			 </select></span></td>';	
echo" </tr>
      <tr bgcolor='#DDDDDD'>
	    <td align='left' colspan='4'><span class='style11'>Search by Item</span></td>
		<td align='left' colspan='6'>";
    echo"<select name='lstItems' id='lstItems' style='font-size:11px; width:350px; height:18px;' onchange='RefreshPage();' >";
			echo"<option></option>";
			while($itemf=mysql_fetch_row($resultitems)){
				echo"<option ";
				if ($lstItems==$itemf[0])
					echo " selected ";
				echo" value='$itemf[0]'>$itemf[0] - $itemf[1]</option>";
			}
			
			
	echo"</select></td>";
echo" </tr>	
	  <tr bgcolor='#DDDDDD'>
		<td height='15' align='center' colspan='10'><font size='1' color='#FF0000' face='Verdana'><b>".$message."</b></font></td>
	  </tr>	
	  <tr bgcolor='#CCD8E6'>
		<td  height='25' align='center'><span class='style25'>&nbsp;</span></td>
		<td  height='25' align='center'><span class='style25'>&nbsp;</span></td>
		<td  height='25' align='center'><span class='style25'>&nbsp;</span></td>
		<td  height='25' align='left'><span class='style25'>Reference </span></td>
		<td  height='25' align='center'><span class='style25'>Date </span></td>
		<td  height='25' align='center'><span class='style25'>Client</span></td>
		<td  height='25' align='center'><span class='style25'>&nbsp;</span></td>";
		
		if ($Module_Delivery == 0 && $FI_DeliverySalesPrice == 1) {
			echo"<td  height='25' align='center'><span class='style25'>Project</span></td>
				 <td  height='25' align='center'><span class='style25'>Salesman</span></td>
				 <td  height='25' align='center'><span class='style25'>Currency</span></td>
				 <td  height='25' align='center'><span class='style25'>Total</span></td>";
		} else {
			echo"<td  height='25' align='center' colspan='2'><span class='style25'>Project</span></td>
				 <td  height='25' align='center' colspan='2'><span class='style25'>Salesman</span></td>";
		}
		
echo" </tr>";
		



	
if (empty($PRef))   
   $PRef = 'Null';
else
   $PRef = "'".$PRef."'"; 

if (empty($ViewPeriodDate))
   $ViewPeriodDate = 'Null';
if (empty($ViewNumberOfDays))   
   $ViewNumberOfDays = 1;
			
$querysearch=" Select Distinct Sorder.Sorder_ID, Sorder.Sorder_Reference, Date_Format(Sorder.Sorder_Date,'%d-%m-%Y') As Sorder_Date, ".
             " Sorder.Client_Code As ClientCode, Clients.Ledger_name As ClientName, Sorder.Currency_code, ".
			 " Project.Project_Name As ProjectName, Salesmen.Ledger_Name As SalesmanName, ".
			 " Round((if($SalesTTC=1,ifNull(Sorder.Sorder_Taxable,0)*(1+$Setup_VatPercentage/100),ifNull(Sorder.Sorder_Taxable,0)) + ifNull(Sorder.Sorder_NoneTaxable,0) + if($SalesTTC=1,0,IfNull(Sorder.Sorder_VAT,0)) - ifNull(Sorder.Sorder_DiscountAmount,0) + ".
			 " (ifNull(Sorder.Sorder_Tax1,0) + ifNull(Sorder.Sorder_Tax2,0) + ifNull(Sorder.Sorder_Tax3,0) + ifNull(Sorder.Sorder_Tax4,0) + ifNull(Sorder.Sorder_Tax5,0))), ".$DecimalBase.") As NetTotal,  ".
			 " if(ifNull(Sorder.Sorder_disapproved,0)=1, 'Cancelled', if(ifNull(Sorder.Sorder_confirmed,0)=1, 'Confirmed', 'Unconfirmed')) As Sorder_Status ".
			 " ,ifNull(Temp_Sorder.Sorder_Id, -1) As TempSorderId ".
			 " From Sorder Inner Join Clients on Sorder.Client_Code = Clients.Ledger_Number ".
			 " Left Join Project on Sorder.Project_Code = Project.Project_Code ".
			 " Left Join Salesmen on Sorder.Salesman_Code = Salesmen.Ledger_Number ".
			 " Left Join Temp_Sorder on Temp_Sorder.Sorder_Id = Sorder.Sorder_Id ";		 
			 
			 
if ($projectexist >	0)
  $querysearch= $querysearch." left join ( select distinct project_code from ".$HTTP_SESSION_VARS['dbLabel'].".loginstk ".
							 "			   where loginstk.user_account='".$HTTP_SESSION_VARS['useraccount']."' ".
							 "             and (project_code is not null and project_code != '') ".
							 "			 ) Q1 on Sorder.project_code like concat(Q1.project_code,'%') ";
							 
if ($costcentexist > 0)
  $querysearch= $querysearch." left join ( select distinct costcent_code from ".$HTTP_SESSION_VARS['dbLabel'].".loginstk ".
							 "			   where loginstk.user_account='".$HTTP_SESSION_VARS['useraccount']."' ".
							 "             and (costcent_code is not null and costcent_code != '') ".
							 "			 ) Q2 on Sorder.costcent_code like concat(Q2.costcent_code,'%') ";							 

							 
if ($ledgerexist > 0)
  $querysearch= $querysearch." Inner join ( select distinct ledger_number from ".$HTTP_SESSION_VARS['dbLabel'].".ledgerstk ".
							 "			    where user_account='".$HTTP_SESSION_VARS['useraccount']."' ".
							 "              and (ledger_number is not null and ledger_number != '') ".
							 "			 )  Q3 on (($ledgerinclude = 1 and Sorder.Client_Code like concat(Q3.ledger_number,'%') ) or ($ledgerinclude = 0 and Sorder.Client_Code Not like concat(Q3.ledger_number,'%') ) or Sorder.Client_Code is null) ";							 	
							 
$querysearch= $querysearch.											 
			 " Where Sorder.Sorder_Reference = ifNull($PRef, Sorder.Sorder_Reference) ".
			 " And ( Sorder.Sorder_Type = 'SO' ".
			 " or Sorder.Sorder_Type = 'ST' )".			 
			 " And (($rowsperiod = 0 and 1 = 1) Or ($rowsperiod > 0 and (($LockViewPeriod = 1 and  Date_Format(Sorder.Sorder_Date,'%Y-%m-%d') >= Date_Format(ifNull('".$ViewPeriodDate."',Sorder.Sorder_Date),'%Y-%m-%d')) Or ($LockViewPeriod = 0 and 1=1 ))   ".
             "                                                      and (($ViewLockDaily = 1 and DateDiff(Date_Format(Now(),'%Y-%m-%d'),Date_Format(Sorder.Sorder_Date,'%Y-%m-%d')) <= $ViewNumberOfDays) Or ($ViewLockDaily = 0 and  1 = 1 ))) ) ".
             " And ifNull(Sorder.Sorder_confirmed,0) = 1 and ifNull(Sorder.Sorder_disapproved,0) = 0 And ifNull(Sorder.Sorder_Hide,0) = 0 ".
			 " And ifNull(Sorder.Sorder_BelongsToGrp,0) >= ifNull($FI_BelongsToGrp,0) ";
			 
if ($Module_TransferSorder == 1) {
	$querysearch= $querysearch." And ifNull(Clients.Client_DeliveryTransfer,0) = 2 ".
							   " And ifNull(Sorder.Sorder_Status,0) = 0 ";
}	
			 
if (!empty($PSaClientCode))			 
	$querysearch= $querysearch." And Sorder.Client_Code = ifNull('".$PSaClientCode."', Sorder.Client_Code) ";
	


/*  $querysearch= $querysearch." And (($ledgerinclude = 1 and Sorder.Client_Code In (select distinct ledger_number from ".$HTTP_SESSION_VARS['dbLabel'].".ledgerstk where user_account='".$HTTP_SESSION_VARS['useraccount']."') ) Or ".
                             "      ($ledgerinclude = 0 and Sorder.Client_Code Not In (select distinct ledger_number from ".$HTTP_SESSION_VARS['dbLabel'].".ledgerstk where user_account='".$HTTP_SESSION_VARS['useraccount']."') ) ) ";      
*/			 
$querysearch= $querysearch." Order By Sorder.Sorder_Reference Desc ";
			 
//echo $querysearch; exit;
if ($PMode != '1') {
$resultsearch=mysql_query($querysearch,$connection) or die(mysql_error());
$totalrows = mysql_num_rows($resultsearch);
	
if ($startrange=='' || $PRef != 'Null')
	$startrange = 0;
if ($perpage=='')
	$perpage = 20;
		
$querysearch = $querysearch." limit ".$startrange.",".$perpage;

$resultsearch=mysql_query($querysearch,$connection) or die(mysql_error());	
	

$i = 0;

while($rows=mysql_fetch_array($resultsearch)){
		
	extract($rows);
	$ct+=1;
	$i = $i + 1;

	if($ct%2==0)
		$Color="style='background-color:".$grid_color1."'";
	else			
		$Color="style='background-color:".$grid_color2."'";	
	
	
	if ($TempSorderId != -1) { $EditHint = 'Exists in Pending'; $EditMode = ' disabled '; }
	else { $EditHint = 'Select Record'; $EditMode = ''; }
	
	if ($FI_SalesOrderConfirm == 0)	$ConfMode = ' disabled '; 
	else if ($FI_SalesOrderConfirm == 1 && $TempSorderId != -1) {$ConfMode = ' disabled '; $UnconfHint = 'Exists in Pending';}
	else if ($FI_SalesOrderConfirm == 1 && $TempSorderId == -1) {$ConfMode = ''; $UnconfHint = 'Unconfirm Order';}
	
	echo'<tr '.$Color.'>';
			
		if (!empty($PSaClientCode)) {
				
		    $SelMaster  = 'M'.$i;
			$$SelMaster = $Sorder_ID;
			   
			echo"<td align='center'><span class='style15'><input type='checkbox' name='$SelMaster' id='$SelMaster' value='".$$SelMaster."' onclick='SelectMaster(this.name);' /></span></td>";
			
			
		} else
		{
		
		echo'<td align="center"><span class="style15"><img src="img/mag.jpg" onMouseOver="style.cursor=\'hand\'"  onclick="PrintPreview('.$Sorder_ID.');"  title="'.$PrevHint.'"  style="width: 15px; height: 15px; " '.$SorPrevMode.'></span></td>';
		
			echo'<td align="center"><span class="style15"><img src="img/button_edit.png" onMouseOver="style.cursor=\'hand\'" onclick="SelectRecord('.$Sorder_ID.');" title="'.$EditHint.'" '.$EditMode.'></span></td>';	
}
		if ($FI_SalesOrderConfirm == 1) {
			echo'<td align="center"><span class="style15"><img src="img/unconfirmorder.png" onMouseOver="style.cursor=\'hand\'" onclick="UnConfirmOrder('.$Sorder_ID.', \''.$Sorder_Reference.'\');" title="'.$UnconfHint.'" style="width: 15px; height: 15px; " '.$ConfMode.' ></span></td>';
		} else
			echo'<td align="center"><span class="style15">&nbsp;</span></td>';
			
		echo'<td align="left"><span class="style15">'.$Sorder_Reference.'</span></td>
			 <td align="center"><span class="style15">'.$Sorder_Date.'</span></td>
			 <td align="center"><span class="style15">'.$ClientCode.'</span></td>
			 <td align="left"><span class="style15">'.$ClientName.'</span></td>';
			 
		if ($Module_Delivery == 0 && $FI_DeliverySalesPrice == 1) {	 
			echo'<td align="left"><span class="style15">'.$ProjectName.'</span></td>
				 <td align="left"><span class="style15">'.$SalesmanName.'</span></td>
				 <td align="center"><span class="style15">'.$Currency_code.'</span></td>
				 <td align="right"><span class="style15">'.number_format($NetTotal, $DecimalBase).'</span></td>';
		} else {
			echo'<td align="left" colspan="2"><span class="style15">'.$ProjectName.'</span></td>
				 <td align="left" colspan="2"><span class="style15">'.$SalesmanName.'</span></td>';
		}
	
	echo'</tr>';
		
		if (!empty($PSaClientCode)) {
		
			echo" <tr><td colspan='10'><table border='0' style='table-layout:fixed'>
				   <col width=50>
				   <col width=123>
				   <col width=110>
				   <col width=347>
				   <col width=90>
				   <col width=50>
				   ";
				   
			$querydt = " Select SorderDt.SorderDt_id, SorderDt.Item_CodePacked, SorderDt.Item_code, Item_Description, SorderDt.Warehouse_Code, ".
					   " SorderDt.SorderDt_Remark, (ifNull(SorderDt.SorderDt_Quantity,0) - (ifNull(Q1.QuantityDelivered,0) + ifNull(Q2.QuantityDeliveredTemp,0))) As QuantityRemaining,  ".
					   " Round(SorderDt.SorderDt_Price, ".$DecimalBase."), SorderDt.SorderDt_PriceBase1, SorderDt.SroderDt_PriceBase2, ".
					   " Round(SorderDt.SorderDt_Discount, ".$DecimalBase."),  ".
					   " Round(((SorderDt.SorderDt_Quantity*SorderDt.SorderDt_Price)-((SorderDt.SorderDt_Quantity*SorderDt.SorderDt_Price*ifNull(SorderDt.SorderDt_Discount,0))/100)), ".$DecimalBase.") As Total, ".
					   " Round(SorderDt.SorderDt_PriceTTC, ".$DecimalBase."), ".
					   " Round(((SorderDt.SorderDt_Quantity*SorderDt.SorderDt_PriceTTC)-((SorderDt.SorderDt_Quantity*SorderDt.SorderDt_PriceTTC*ifNull(SorderDt.SorderDt_Discount,0))/100)), ".$DecimalBase.") As TotalTTC ".
					   " From SorderDt Left Join Items on SorderDt.Item_code = Items.Item_code ".
					   " Left Join ( Select DeliveryDt.RelatedDt_ID, DeliveryDt.Item_code, DeliveryDt.Item_CodePacked, Sum(ifNull(DeliveryDt.DeliveryDt_Quantity,0)) As QuantityDelivered ".
					   "             From DeliveryDt ".
					   "             Where (DeliveryDt.RelatedDt_ID != '' or DeliveryDt.RelatedDt_ID Is Not Null)  ".
					   "             And DeliveryDt.Delivery_Id != '".$PSaId."' ".
					   "             Group By DeliveryDt.RelatedDt_ID, DeliveryDt.Item_code, DeliveryDt.Item_CodePacked  ".
					   "            ) Q1 on Q1.Item_code = SorderDt.Item_code  and Q1.RelatedDt_ID = SorderDt.SorderDt_id ".
					   " Left Join ( Select Temp_DeliveryDt.RelatedDt_ID, Temp_DeliveryDt.Item_code, Temp_DeliveryDt.Item_CodePacked, Sum(ifNull(Temp_DeliveryDt.DeliveryDt_Quantity,0)) As QuantityDeliveredTemp ".
					   "             From Temp_DeliveryDt ".
					   "             Where (Temp_DeliveryDt.RelatedDt_ID != '' or Temp_DeliveryDt.RelatedDt_ID Is Not Null) ".
					   "             Group By Temp_DeliveryDt.RelatedDt_ID, Temp_DeliveryDt.Item_code, Temp_DeliveryDt.Item_CodePacked ".
					   "            ) Q2 on Q2.Item_code = SorderDt.Item_code  and Q2.RelatedDt_ID = SorderDt.SorderDt_id ".
					   " Where SorderDt.Sorder_ID = ".$Sorder_ID.
					   " And (('".$lstItems."' != '' and Sorderdt.Item_Code = '".$lstItems."') or ('".$lstItems."' = '' and 1 = 1)) ".
					   " And (ifNull(SorderDt.SorderDt_Quantity,0) - (ifNull(Q1.QuantityDelivered,0) + ifNull(Q2.QuantityDeliveredTemp,0))) > 0 ".
					   " Order By SorderDt.SorderDt_ID Desc ";
			
			//echo "<br>".$querydt;
			
			$j = 0;
			$resultdt=mysql_query($querydt,$connection) or die(mysql_error());
			while($rowsdt=mysql_fetch_array($resultdt)){
			    
				$ct+=1;
				$j = $j + 1;
				
				if($ct%2==0)
					$Color="style='background-color:".$grid_color1."'";
				else			
					$Color="style='background-color:".$grid_color2."'";	
						
				$SelDetail  = $SelMaster.'D'.$j;
				$$SelDetail = $rowsdt[0];
			   
				
				echo "<tr ".$Color." >";
				echo"   <td align='center'><span class='style15'><input type='checkbox' name='$SelDetail' id='$SelDetail' value='".$$SelDetail."' onclick='SelectDetail();' /></span></td>";
				echo "	<td align='left'><span class='style15'>".$rowsdt[1]."</span></td>";
				echo "	<td align='left'><span class='style15'>".$rowsdt[2]."</span></td>";
				echo "	<td align='left'><span class='style15'>".$rowsdt[3]."</span></td>";
				echo "	<td align='left'><span class='style15'>".$rowsdt[4]."</span></td>";
				echo "	<td align='right'><span class='style15'>".$rowsdt[6]."</span></td>";
				echo "</tr>";
								
			} 		

			$RecName  = 'Rec'.$SelMaster;
			
			echo "<input type='hidden' name='$RecName' id='$RecName' value='$j'>";	  
			echo "</table></td></tr>";
		}
}
							
echo "<input type='hidden' name='i' value='$i'>";

if (!empty($PSaClientCode)) {
	echo"   <tr bgcolor='#DDDDDD'><td colspan='10' align='center'><input type='button' name='btnLoad' value='Load' onclick='LoadData();'style=' background-color:#4069A7; color:#FFFFFF;font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px;'/></td></tr>";
}			
		
echo"   <tr><td colspan='10'>&nbsp;</td></tr>
		<tr><td colspan='10'><table width='100%' border=0><tr><td width='260'>&nbsp;</td><td width='150' align='center'>";
		
		$diff= $startrange - $perpage;
		
		if (($diff) >= 0 ){
			$prvstartrange = $startrange - $perpage;
			echo"<img src='img/arrowleft.jpg' title='Previous' onMouseOver=\"style.cursor='hand'\"  onclick=SetPrvPage('".$prvstartrange."','".$perpage."')>";
		}
		else
			echo "&nbsp;";
		
		echo"</td><td width='150' align='center'>";
		
		
		if ($startrange <= $totalrows){
			$startrange = $startrange + $perpage;
			if  ($startrange <= $totalrows)
				echo"<img src='img/arrowright.jpg' title='Next' onMouseOver=\"style.cursor='hand'\" onclick=SetNextPage('".$startrange."','".$perpage."')>";
		} else
			echo "&nbsp;";
			
		echo"</td><td width='170'>&nbsp;</td></tr>";
		echo"<table>";
		
}		

echo"</td></tr></table>";
	


          

		  

print <<<HERE

</form>
</body>

HERE;

?>