<?php

/*
	include_once("config.inc.php");
	include_once("DBConnector.php");
	$letters = $_GET['letters'];
	
	$sql="SELECT * FROM mast_family where name like '".$letters."%'";
		$result =$db->RunQuery($sql);
			
			
			while($row = $result->fetch())
			{
			
			echo $row["name"];
			
			}
			
		*/	
		
		
session_start();


	include_once("connection.php");

if ($_GET["Command"]=="search_inv"){
	
	$ResponseXML .= "";
		//$ResponseXML .= "<invdetails>";
			
	
	
		$ResponseXML .= "<table width=\"735\" border=\"0\" class=\"form-matrix-table\">
                            <tr>
                              <td width=\"121\"  background=\"images/headingbg.gif\" ><font color=\"#FFFFFF\">Order No</font></td>
                              <td width=\"424\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Customer</font></td>
                             <td width=\"176\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Order Date</font></td>
							 <td width=\"176\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Grand Total</font></td>
   							</tr>";
                           
						if ($_GET["Option1"]=="true"){
							if ($_GET["mstatus"]=="invno"){
						   		$letters = $_GET['invno'];
								//$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
								//$letters="/".$letters;
								//$a="SELECT * from s_salma where REF_NO like  '$letters%'";
								//echo $a;
								/*if ($_GET["stname"]=="ord"){
									$sql = $dbinv->query("SELECT * from s_cusordmas where REF_NO like  '$letters%' limit 50") or die("Error";
								} else {*/
									$sql = $dbinv->query("SELECT * from s_cusordmas where REF_NO like  '$letters%' and  INVNO='0' and CANCELL='0'  order by SDATE desc limit 50") or die("Error";
								//}	
							} else if ($_GET["mstatus"]=="customername"){
								$letters = $_GET['customername'];
								//$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
								/*if ($_GET["stname"]=="ord"){
									$sql = $dbinv->query("SELECT * from s_cusordmas where CUS_NAME like  '$letters%' limit 50 ") or die("Error";
								} else {*/
									$sql = $dbinv->query("SELECT * from s_cusordmas where CUS_NAME like  '$letters%' and  INVNO='0' and CANCELL='0'  order by SDATE desc limit 50") or die("Error";
								//}
							} else {
								$letters = $_GET['customername'];
								//$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
								/*if ($_GET["stname"]=="ord"){
									$sql = $dbinv->query("SELECT * from s_cusordmas where CUS_NAME like  '$letters%' limit 50") or die("Error";
								} else {*/
									$sql = $dbinv->query("SELECT * from s_cusordmas where CUS_NAME like  '$letters%' and  INVNO='0' and CANCELL='0'  order by SDATE desc limit 50") or die("Error";
								//}
							}
						}	
						
						
						if ($_GET["Option2"]=="true"){
							if ($_GET["mstatus"]=="invno"){
						   		$letters = $_GET['invno'];
								//$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
								//$letters="/".$letters;
								//$a="SELECT * from s_salma where REF_NO like  '$letters%'";
								//echo $a;
								/*if ($_GET["stname"]=="ord"){
									$sql = $dbinv->query("SELECT * from s_cusordmas where REF_NO like  '$letters%' limit 50 ") or die("Error";
								} else {*/
									$sql = $dbinv->query("SELECT * from s_cusordmas where REF_NO like  '$letters%' and  INVNO='0' and CANCELL='0'  and Result='OK' order by SDATE desc limit 50") or die("Error";
								//}	
							} else if ($_GET["mstatus"]=="customername"){
								$letters = $_GET['customername'];
								//$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
							/*	if ($_GET["stname"]=="ord"){
									$sql = $dbinv->query("SELECT * from s_cusordmas where CUS_NAME like  '$letters%' limit 50 ") or die("Error";
								} else {*/
									$sql = $dbinv->query("SELECT * from s_cusordmas where CUS_NAME like  '$letters%' and  INVNO='0' and CANCELL='0' and Result='OK'  order by SDATE desc limit 50") or die("Error";
								//}
							} else {
								$letters = $_GET['customername'];
								//$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
							/*	if ($_GET["stname"]=="ord"){
									$sql = $dbinv->query("SELECT * from s_cusordmas where CUS_NAME like  '$letters%' limit 50") or die("Error";
								} else {*/
									$sql = $dbinv->query("SELECT * from s_cusordmas where CUS_NAME like  '$letters%' and  INVNO='0' and CANCELL='0' and Result='OK'  order by SDATE desc limit 50") or die("Error";
									//echo "SELECT * from s_cusordmas where CUS_NAME like  '$letters%' and  INVNO='0' and CANCELL='0' and Result='OK'  order by SDATE desc limit 50";
								//}
							}
						}	
						
						if ($_GET["Option3"]=="true"){
							if ($_GET["mstatus"]=="invno"){
						   		$letters = $_GET['invno'];
								//$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
								//$letters="/".$letters;
								//$a="SELECT * from s_salma where REF_NO like  '$letters%'";
								//echo $a;
								/*if ($_GET["stname"]=="ord"){
									$sql = $dbinv->query("SELECT * from s_cusordmas where REF_NO like  '$letters%'  limit 50") or die("Error";
								} else {*/
									//echo "SELECT * from s_cusordmas where REF_NO like  '$letters%' and  INVNO!='0' and CANCELL='0'";
									$sql = $dbinv->query("SELECT * from s_cusordmas where REF_NO like  '$letters%' and  INVNO!='0' and CANCELL='0'  order by SDATE desc limit 50") or die("Error";
								//}	
							} else if ($_GET["mstatus"]=="customername"){
								$letters = $_GET['customername'];
								//$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
								/*if ($_GET["stname"]=="ord"){
									$sql = $dbinv->query("SELECT * from s_cusordmas where CUS_NAME like  '$letters%' limit 50 ") or die("Error";
								} else {*/
									//echo "SELECT * from s_cusordmas where CUS_NAME like  '$letters%' and  INVNO!='0' and CANCELL='0'";
									$sql = $dbinv->query("SELECT * from s_cusordmas where CUS_NAME like  '$letters%' and  INVNO!='0' and CANCELL='0'  order by SDATE desc limit 50") or die("Error";
							//	}
							} else {
								$letters = $_GET['customername'];
								//$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
							/*	if ($_GET["stname"]=="ord"){
									$sql = $dbinv->query("SELECT * from s_cusordmas where CUS_NAME like  '$letters%' limit 50") or die("Error";
								} else {*/
									//echo "SELECT * from s_cusordmas where CUS_NAME like  '$letters%' and  INVNO!='0' and CANCELL='0'";
									$sql = $dbinv->query("SELECT * from s_cusordmas where CUS_NAME like  '$letters%' and  INVNO!='0' and CANCELL='0'  order by SDATE desc limit 50") or die("Error";
									
							//	}
							}
						}	
						
						
						if ($_GET["Option4"]=="true"){
							if ($_GET["mstatus"]=="invno"){
						   		$letters = $_GET['invno'];
								//$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
								//$letters="/".$letters;
								//$a="SELECT * from s_salma where REF_NO like  '$letters%'";
								//echo $a;
								/*if ($_GET["stname"]=="ord"){
									$sql = $dbinv->query("SELECT * from s_cusordmas where REF_NO like  '$letters%' limit 50 ") or die("Error";
								} else {*/
									$sql = $dbinv->query("SELECT * from s_cusordmas where REF_NO like  '$letters%' and  INVNO='0' and Forward='WD' and CANCELL='0' and Result='P' order by SDATE desc limit 50") or die("Error";
								//}	
							} else if ($_GET["mstatus"]=="customername"){
								$letters = $_GET['customername'];
								//$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
								/*if ($_GET["stname"]=="ord"){
									$sql = $dbinv->query("SELECT * from s_cusordmas where CUS_NAME like  '$letters%' limit 50 ") or die("Error";
								} else {*/
									$sql = $dbinv->query("SELECT * from s_cusordmas where CUS_NAME like  '$letters%' and  INVNO='0' and Forward='WD' and CANCELL='0' and Result='P' order by SDATE desc limit 50") or die("Error";
								//}
							} else {
								$letters = $_GET['customername'];
								//$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
							/*	if ($_GET["stname"]=="ord"){
									$sql = $dbinv->query("SELECT * from s_cusordmas where CUS_NAME like  '$letters%' limit 50") or die("Error";
								} else {*/
									$sql = $dbinv->query("SELECT * from s_cusordmas where CUS_NAME like  '$letters%' and  INVNO='0' and Forward='WD' and CANCELL='0' and Result='P' order by SDATE desc limit 50") or die("Error";
									//echo "SELECT * from s_cusordmas where CUS_NAME like  '$letters%' and  INVNO='0' and Forward='WD' and CANCELL='0' and Result='P' order by SDATE desc limit 50";
								//}
							}
						}	
													
						
							while($row = $sql->fetch()){
								$REF_NO = $row['REF_NO'];
								$stname = $_SESSION["stname"];
							$ResponseXML .= "<tr>
                           	  <td onclick=\"invno('$REF_NO', '$stname');\">".$row['REF_NO']."</a></td>
                              <td onclick=\"invno('$REF_NO', '$stname');\">".$row['CUS_NAME']."</a></td>
                              <td onclick=\"invno('$REF_NO', '$stname');\">".$row['SDATE']."</a></td>
							  <td onclick=\"invno('$REF_NO', '$stname');\">".$row['GRAND_TOT']."</a></td>
                                                        	
                            </tr>";
							}
							  
                    $ResponseXML .= "   </table>";
		
										
					echo $ResponseXML;
}

if ($_GET["Command"]=="pass_invno_cus_ord"){
	$txt_stat = "OLD";
	
	header('Content-Type: text/xml'); 
	echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
			
			
			$ResponseXML = "";
			$ResponseXML .= "<salesdetails>";
			
	
	$sql = $dbinv->query("SELECT * FROM s_wcusordmas where REF_NO='" . $_GET["invno"] . "'") or die("Error";
	if($row_rssalma = $sql->fetch()){
		
		$ResponseXML .= "<invno><![CDATA[".$_GET["invno"]."]]></invno>";
		$ResponseXML .= "<DTappdate><![CDATA[".$row_rssalma["appdate"]."]]></DTappdate>";
		$ResponseXML .= "<txt_cuscode><![CDATA[".$row_rssalma["C_CODE"]."]]></txt_cuscode>";
		$ResponseXML .= "<txt_cusname><![CDATA[".$row_rssalma["CUS_NAME"]."]]></txt_cusname>";
		
		
		$sql_cus = $dbinv->query("select * from vendor where CODE='" . $row_rssalma["C_CODE"] . "'") or die("Error";
		if($row_cus = $sql_cus->fetch()){
			$ResponseXML .= "<lblvatno><![CDATA[".$row_rssalma["vatno"]."]]></lblvatno>";
			$ResponseXML .= "<txt_cusadd><![CDATA[".$row_rssalma["ADD1"]." ".$row_rssalma["ADD2"]."]]></txt_cusadd>";

       	}
	// Call setcus
	
		if ($row_rssalma["TYPE"]=="CA"){
			$ResponseXML .= "<Op_cash><![CDATA[true]]></Op_cash>";
			$ResponseXML .= "<Op_credit><![CDATA[false]]></Op_credit>";
		}
		if ($row_rssalma["TYPE"]=="CR"){
			$ResponseXML .= "<Op_cash><![CDATA[false]]></Op_cash>";
			$ResponseXML .= "<Op_credit><![CDATA[true]]></Op_credit>";
		}	
		
		$ResponseXML .= "<txt_dis><![CDATA[".$row_rssalma["DISCOU"]."]]></txt_dis>";
		$ResponseXML .= "<txt_subtot><![CDATA[".$row_rssalma["AMOUNT"]."]]></txt_subtot>";
		$ResponseXML .= "<txt_net><![CDATA[".$row_rssalma["GRAND_TOT"]."]]></txt_net>";
		$ResponseXML .= "<txt_ordno><![CDATA[".$row_rssalma["ORD_NO"]."]]></txt_ordno>";
		$ResponseXML .= "<dtdate><![CDATA[".$row_rssalma["SDATE"]."]]></dtdate>";
		
		$date = $row_rssalma["SDATE"];
		$date = strtotime(date("Y-m-d", strtotime($date)) . " +6 days");
		$caldate= date("Y-m-d", $date);
		
		$ResponseXML .= "<DTdateto><![CDATA[".$caldate."]]></DTdateto>";
		$ResponseXML .= "<DTREQ_DATE><![CDATA[".$row_rssalma["REQ_DATE"]."]]></DTREQ_DATE>";
		
		
		$ResponseXML .= "<DTappdate><![CDATA[".$row_rssalma["REQ_DATE"]."]]></DTappdate>";
		
    
    	
				$ResponseXML .= "<com_dep><![CDATA[".$row_rssalma["DEPARTMENT"]."]]></com_dep>";
        	
		
				$ResponseXML .= "<Com_rep><![CDATA[".$row_rssalma["SAL_EX"]."]]></Com_rep>";
        
    	
  		$ResponseXML .= "<cmbbrand><![CDATA[".$row_rssalma["Brand"]."]]></cmbbrand>";
			
    	if (is_null($row_rssalma["VAT"])==false) {
		   if ($row_rssalma["VAT"]=="1"){
        		$ResponseXML .= "<Op_vat><![CDATA[true]]></Op_vat>";
				$ResponseXML .= "<Op_nonvat><![CDATA[false]]></Op_nonvat>";
			} else {
				$ResponseXML .= "<Op_vat><![CDATA[false]]></Op_vat>";
				$ResponseXML .= "<Op_nonvat><![CDATA[true]]></Op_nonvat>";
			}	
    	} else {
			$ResponseXML .= "<Op_vat><![CDATA[false]]></Op_vat>";
			$ResponseXML .= "<Op_nonvat><![CDATA[true]]></Op_nonvat>";
        }
		
    	if (is_null($row_rssalma["CASH"])==false) { 
			$ResponseXML .= "<txt_cash><![CDATA[".$row_rssalma["CASH"]."]]></txt_cash>";
		}
		
		$mvatrate=12;
		
		$sql_del = $dbinv->query("SELECT * FROM tmp_cusord_data where str_invno='" . $_GET["invno"] . "'") or die("Error";	
		
		$ResponseXML .= "<sales_table><![CDATA[ <table><tr>
                              <td width=\"100\"  background=\"images/headingbg.gif\" ><font color=\"#FFFFFF\">Code</font></td>
                              <td width=\"300\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Description</font></td>
                              <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Rate</font></td>
                              <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Qty</font></td>
                              <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Discount</font></td>
                              <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Sub Total</font></td>
							  <td></td>
							  <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Qty In Hand</font></td>
                            </tr>";
					
				
		$sql_rsinv = $dbinv->query("SELECT * FROM s_cusordtrn where REF_NO='" . $_GET["invno"] . "'") or die("Error";	
        while($row_rsinv = $sql_rsinv->fetch()){
			
			if ($row_rssalma["VAT"]=="1"){
				$PRICE=$row_rsinv["PRICE"]/(1+$mvatrate/100);
			} else {
				$PRICE=$row_rsinv["PRICE"];
			}
		
			$sql = $dbinv->query("Insert into tmp_cusord_data (str_invno, str_code, str_description, cur_rate, cur_qty, dis_per, cur_discount, cur_subtot, brand, tmp_no)values 
			('".$_GET["invno"]."', '".$row_rsinv["STK_NO"]."', '".$row_rsinv["DESCRIPT"]."', ".$PRICE.", ".$row_rsinv["QTY"].", ".$row_rsinv["DIS_per"].", ".$row_rsinv["DIS_rs"].", ".($row_rsinv["QTY"]*$PRICE).", '".$row_rsinv["STK_NO"]."', '".$row_rsinv["STK_NO"]."')") or die("Error";	
			
			
			$ResponseXML .= "<tr>
                              
                             <td >".$row_rsinv["STK_NO"]."</td>
							 <td >".$row_rsinv["DESCRIPT"]."</a></td>
							 <td >".number_format($PRICE, 2, ".", ",")."</a></td>
							 <td >".number_format($row_rsinv["QTY"], 2, ".", ",")."</a></td>
							 <td >".number_format($row_rsinv["DIS_per"], 2, ".", ",")."</a></td>
							 <td >".number_format((($row_rsinv["QTY"]*$PRICE)-$row_rsinv["DIS_per"]), 2, ".", ",")."</a></td>
							 <td ><img src=\"images/delete_01.png\" width=\"20\" height=\"20\" id=".$row_rsinv["STK_NO"]."  name=".$row_rsinv["STK_NO"]." onClick=\"del_item('".$row_rsinv["STK_NO"]."');\"></td>";
						
						//include_once("connection.php");
						
							 
							 $sqlqty = $dbinv->query("select QTYINHAND from s_submas where STK_NO='".$row_rsinv["STK_NO"]."' AND STO_CODE='".$_GET["department"]."'") or die("Error";
					if($rowqty = $sqlqty->fetch()){
						$qty=$rowqty['QTYINHAND'];
					} else {
						$qty=0;
					}	
						
							$ResponseXML .= "<td >".$qty."</a></td>
						
                            </tr>";
							
		}			
							
        $ResponseXML .= "   </table>]]></sales_table>";
							 
           
    }
	
	$ResponseXML .= "</salesdetails>";		

	$_SESSION["print"]=1;

	echo $ResponseXML;
   
}

if ($_GET["Command"]=="pass_invno"){
	header('Content-Type: text/xml'); 
	echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
			
			$brand="";
			$salrep="";
			$cuscode="";
			
			$ResponseXML = "";
			$ResponseXML .= "<salesdetails>";
			$ResponseXML .= "<stname><![CDATA[".$_GET["stname"]."]]></stname>";
					$inv= $_GET['invno']; 
					$_SESSION["invno"]=$_GET['invno']; 
					$_SESSION["salesord1"]=$_GET['invno']; 
					
					$_SESSION["custno"]=$_GET['custno'];
					
			 		//$tmpinvno="0000".substr($_GET['invno'], 4, 7) ;
					//$lenth=strlen($tmpinvno);
					//$serial=substr($tmpinvno, $lenth-7);
					//$inv=substr($_GET['invno'], 0, 3).substr("\ ", 0, 1).$serial;
				$a="Select * from s_cusordmas where REF_NO='".$inv."'";
				
				$sql = $dbinv->query("Select * from s_cusordmas where REF_NO='".$inv."'") or die("Error";
				
				if($row = $sql->fetch()){
					$cuscode=$row['C_CODE'];
					$ResponseXML .= "<str_invoiceno><![CDATA[".$row['REF_NO']."]]></str_invoiceno>";
					$ResponseXML .= "<str_crecash><![CDATA[".$row['TYPE']."]]></str_crecash>";
					$ResponseXML .= "<sdate><![CDATA[".$row['SDATE']."]]></sdate>";
					$cuscode=$row['C_CODE'];
					$ResponseXML .= "<str_customecode><![CDATA[".$row['C_CODE']."]]></str_customecode>";
					$_SESSION["tmp_no_ord"]=$row['tmp_no'];
					//echo "Select * from vendor where CODE='".$row['C_CODE']."'";
					$sqlcustomer = $dbinv->query("Select * from vendor where CODE='".$row['C_CODE']."'") or die("Error";
					if($rowcustomer = $sqlcustomer->fetch()){
						$ResponseXML .= "<str_customername><![CDATA[".$rowcustomer['NAME']."]]></str_customername>";
						$ResponseXML .= "<str_address><![CDATA[".$rowcustomer['ADD1']." ".$rowcustomer['ADD2']."]]></str_address>";
						$ResponseXML .= "<str_vatno1><![CDATA[".$rowcustomer['vatno']."]]></str_vatno1>";
						$ResponseXML .= "<str_vatno2><![CDATA[".$rowcustomer['svatno']."]]></str_vatno2>";
					}
					
					//$ResponseXML .= "<str_vatno2><![CDATA[".$row['str_vatno2']."]]></str_vatno2>";
					$ResponseXML .= "<str_salesrep><![CDATA[".$row['SAL_EX']."]]></str_salesrep>";
					$salesrep=$row['SAL_EX'];
					//$ResponseXML .= "<str_salesorder1><![CDATA[".$row['str_salesorder1']."]]></str_salesorder1>";
					//$ResponseXML .= "<str_salesorder2><![CDATA[".$row['str_salesorder2']."]]></str_salesorder2>";
					$ResponseXML .= "<dte_deliverdate><![CDATA[".$row['REQ_DATE']."]]></dte_deliverdate>";
					//$ResponseXML .= "<str_orderno1><![CDATA[".$row['ORD_NO']."]]></str_orderno1>";
					//$ResponseXML .= "<str_orderno2><![CDATA[".$row['ORD_DA']."]]></str_orderno2>";
					//$ResponseXML .= "<cur_credit><![CDATA[".$row['cur_credit']."]]></cur_credit>";
					//$ResponseXML .= "<cur_balance><![CDATA[".$row['cur_balance']."]]></cur_balance>";
					
					$ResponseXML .= "<dis><![CDATA[".$row['DIS']."]]></dis>";
					$ResponseXML .= "<dis1><![CDATA[".$row['DIS1']."]]></dis1>";
					$ResponseXML .= "<dis2><![CDATA[".$row['DIS2']."]]></dis2>";
					
					$ResponseXML .= "<str_department><![CDATA[".$row['DEPARTMENT']."]]></str_department>";
					$department=$row['DEPARTMENT'];
					$_SESSION["department"]=$department;
					
					$ResponseXML .= "<str_brand><![CDATA[".$row['Brand']."]]></str_brand>";
					$brand=$row['Brand'];
					$_SESSION["brand"]=$brand;
					
					$ResponseXML .= "<str_vat><![CDATA[".$row['VAT']."]]></str_vat>";
					//$ResponseXML .= "<cur_discount1><![CDATA[".$row['cur_discount1']."]]></cur_discount1>";
					//$ResponseXML .= "<cur_discount2><![CDATA[".$row['cur_discount2']."]]></cur_discount2>";
					$ResponseXML .= "<cur_subtotal><![CDATA[".number_format($row['AMOUNT'], 2, ".", ",")."]]></cur_subtotal>";
					$ResponseXML .= "<cur_discount><![CDATA[".number_format($row['DISCOU'], 2, ".", ",")."]]></cur_discount>";
					$ResponseXML .= "<cur_tax><![CDATA[".number_format($row['VAT_VAL'], 2, ".", ",")."]]></cur_tax>";
					$ResponseXML .= "<cur_invoiceval><![CDATA[".number_format($row['GRAND_TOT'], 2, ".", ",")."]]></cur_invoiceval>";
						
				}				
		
				
			$ResponseXML .= "<sales_table><![CDATA[ <table><tr>
                              <td width=\"70\"  background=\"images/headingbg.gif\" ><font color=\"#FFFFFF\">Code</font></td>
                              <td width=\"350\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Description</font></td>
                              <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Rate</font></td>
                              <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Qty</font></td>
                              <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Discount</font></td>
                              <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Sub Total</font></td>
							   <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Qty In Hand</font></td>
                            </tr>";
							
			/*$sql_data = $dbinv->query("Select CAS_INV_NO_m from invpara") or die("Error";
			$row = $sql_data->fetch();
			$tmpinvno="000000".$row["CAS_INV_NO_m"];
			$lenth=strlen($tmpinvno);
			$invno=trim("CRI/ ").substr($tmpinvno, $lenth-7);*/
					
				$sql_data = $dbinv->query("delete from tmp_ord_data where tmp_no='".$_SESSION["tmp_no_ord"]."'") or die("Error";
				//echo "Select * from s_cusordtrn where REF_NO='".$inv."'";
				$sql_data = $dbinv->query("Select * from s_cusordtrn where REF_NO='".$inv."'") or die("Error";
				while($row = $sql_data->fetch()){
					$sql_itdata = $dbinv->query("Select * from s_mas where STK_NO='".$row['STK_NO']."' and BRAND_NAME='".$brand."'") or die("Error";
					$rowit = $sql_itdata->fetch();
							
					//$a="Insert into tmp_ord_data(str_invno, str_code, str_description, cur_rate, cur_qty, dis_per,cur_discount, cur_subtot, brand) values ( '".$row['REF_NO']."', '".$row['STK_NO']."', '".$row['DESCRIPT']."', ".$row['PRICE'].", ".$row['QTY'].", ".$row['DIS_per'].", ".$row['DIS_rs'].", ".$row["subtot"].", '".$row['BRAND']."')";
					//echo $a;	
				//	echo "Insert into tmp_ord_data(str_invno, str_code, str_description, cur_rate, cur_qty, dis_per,cur_discount, cur_subtot, brand, tmp_no) values ( '".$inv."', '".$row['STK_NO']."', '".$row['DESCRIPT']."', ".$row['PRICE'].", ".$row['QTY'].", ".$row['DIS_per'].", ".$row['DIS_rs'].", ".($row['PRICE']*$row['QTY']).", '".$row['BRAND']."', '".$_SESSION["tmp_no_ord"]."')";
					$sql_tmp = $dbinv->query("Insert into tmp_ord_data(str_invno, str_code, str_description, cur_rate, cur_qty, dis_per,cur_discount, cur_subtot, brand, tmp_no) values ( '".$inv."', '".$row['STK_NO']."', '".$row['DESCRIPT']."', ".$row['PRICE'].", ".$row['QTY'].", ".$row['DIS_per'].", ".$row['DIS_rs'].", ".($row['PRICE']*$row['QTY']).", '".$row['BRAND']."', '".$_SESSION["tmp_no_ord"]."')") or die("Error";
					
						
						
			
			 	$ResponseXML .= "<tr>
                              
                             <td >".$row['STK_NO']."</a></td>
  							 <td >".$row['DESCRIPT']."</a></td>
							 <td >".number_format($row['PRICE'], 2, ".", ",")."</a></td>
							 <td >".$row['QTY']."</a></td>
							 <td >".number_format($row['DIS_per'], 2, ".", ",")."</td>
							 <td >".number_format(($row['PRICE']*$row['QTY']), 2, ".", ",")."</a></td>";
							
							 
							 	include_once("connection.php");
							 
							 $sqlqty = $dbinv->query("select QTYINHAND from s_submas where STK_NO='".$row['STK_NO']."' AND STO_CODE='".$department."'") or die("Error";
					if($rowqty = $sqlqty->fetch()){
						$qty=$rowqty['QTYINHAND'];
					} else {
						$qty=0;
					}	
						
							$ResponseXML .= "<td >".$qty."</a></td>
                            </tr>";
							
							
            					
				}
			
			    $ResponseXML .= "   </table>]]></sales_table>";
	
	
	
	
	/*	$sql = $dbinv->query("DROP VIEW view_s_salma") or die("Error";
					$sql = mysql_query("CREATE VIEW view_s_salma
AS
SELECT     s_salma.*, brand_mas.class AS class
FROM         brand_mas RIGHT OUTER JOIN
                      s_salma ON brand_mas.barnd_name = s_salma.brand") or die("Error";*/
	

	
	
				
				$sql = $dbinv->query("Select * from vendor where CODE='".$cuscode."'") or die("Error";
				if($row = $sql->fetch()){
					
					$OldRefno = "";
					$NewRefNo = "";
					$sql1 = $dbinv->query("SELECT  * From ref_history WHERE NewRefNo = '".$salesrep."'") or die("Error";
					if($row1 = $sql1->fetch()){
						$OldRefno = trim($row1["OldRefno"]);
    					$NewRefNo = trim($row1["NewRefNo"]);	
					}
					
					$OutpDAMT = 0;
					$OutREtAmt = 0;
					$OutInvAmt = 0;
					

		
					$sql1 = $dbinv->query("select * from brand_mas where barnd_name='".trim($brand)."'") or die("Error";
					
					if($row1 = $sql1->fetch()){
						if (is_null($row1["class"])==false){ $InvClass = trim($row1["class"]); }
					}
					
					//$sql1 = $dbinv->query("select sum(grand_tot-totpay) as totOut from view_s_salma where ACCNAME <> 'NON STOCK' and grand_tot>totpay and cancell='0' and c_code='".trim($cuscode)."' and sal_ex='".trim($salesrep)."' and class='".$InvClass."'") or die("Error";
					
				if ($NewRefNo==$salesrep){
					$sqlview = $dbinv->query("select sum(grand_tot-totpay) as totout from view_s_salma where ACCNAME <> 'NON STOCK' and grand_tot>totpay and cancell='0' and c_code='".trim($cuscode)."' and (sal_ex='".$OldRefno."' or sal_ex='".trim($salesrep)."' and class='".$InvClass."'") or die("Error";
				} else {
					$sqlview = $dbinv->query("select sum(grand_tot-totpay) as totout from view_s_salma where ACCNAME <> 'NON STOCK' and grand_tot>totpay and cancell='0' and c_code='".trim($cuscode)."' and sal_ex='".trim($salesrep)."' and class='".$InvClass."'") or die("Error";
				}
				
					$rowview = $sqlview->fetch();
						if (is_null($rowview["totout"])==false) { $OutInvAmt = $rowview["totout"]; }



				if ($NewRefNo==$salesrep){
					$sqlinvcheq = $dbinv->query("SELECT * FROM s_invcheq WHERE che_date>'".$_GET["invdate"]."' AND cus_code='".trim($cuscode)."' and trn_type='REC' and (sal_ex='".$OldRefno."' or sal_ex='".trim($salesrep)."'") or die("Error";
				} else {	
					$sqlinvcheq = $dbinv->query("SELECT * FROM s_invcheq WHERE che_date>'".$_GET["invdate"]."' AND cus_code='".trim($cuscode)."' and trn_type='REC' and sal_ex='".trim($salesrep)."'") or die("Error";
				}
				while($rowinvcheq = $sqlinvcheq->fetch()){
					$sqlstr = $dbinv->query("select * from s_sttr where ST_REFNO='".trim($rowinvcheq["refno"])."' and ST_CHNO ='".trim($rowinvcheq["cheque_no"])."'") or die("Error";
						//echo "select * from s_sttr where st_refno='".trim($rowinvcheq["refno"])."' and st_chno ='".trim($rowinvcheq["cheque_no"])."'";
						while($rowstr = $sqlstr->fetch()){
						  	$sqltmp = $dbinv->query("select class from view_s_salma where Accname <> 'NON STOCK' and REF_NO='".trim($rowstr["ST_INVONO"])."' ") or die("Error";
                    		if($rowstmp = $sqltmp->fetch()){
								
                    			if (trim($rowstmp["class"] == $InvClass)) {
                   			 		$OutpDAMT = $OutpDAMT + $rowstr["ST_PAID"];
								}
               			     }
                		}
     				}	
	 
	 
	 	 $pend_ret_set = 0;
		 $sqlview = $dbinv->query("SELECT sum(che_amount) as  che_amount FROM s_invcheq WHERE CHE_DATE >'".$_GET["invdate"]."' AND CUS_CODE='".trim($cuscode)."' and trn_type='RET'") or die("Error";
          $rowsview = $sqlview->fetch();
			if( is_null($rowsview["che_amount"])==false){ $pend_ret_set = $rowsview["che_amount"]; }
							
     
	 	if ($NewRefNo==$salesrep){
		
     		$sqlcheq = $dbinv->query("Select sum(CR_CHEVAL-paid) as tot from s_cheq where CR_C_CODE='".trim($cuscode)."'  and CR_CHEVAL-PAID>0 and CR_FLAG='0' and (S_REF='".$salesrep."' or S_REF='" & $OldRefno & "') ") or die("Error";
		
		} else {
	 
	 		$sqlcheq = $dbinv->query("Select sum(CR_CHEVAL-paid) as tot from s_cheq where CR_C_CODE='".trim($cuscode)."'  and CR_CHEVAL-PAID>0 and CR_FLAG='0' and S_REF='".$salesrep."' ") or die("Error";
			
		}	
		$rowscheq = $sqlcheq->fetch();
		if (is_null($rowscheq["tot"])==false){ 
			$OutREtAmt=$rowscheq["tot"];
		} else {
			$OutREtAmt=0;
		}
 
   		 $d=date("Y-m-d");
		
			$date = date('Y-m-d',strtotime($d.' -60 days'));
		
		$sql_rssal = $dbinv->query("Select sum(GRAND_TOT - TOTPAY) as out1 from s_salma where C_CODE = '" . trim($cuscode) . "' and (SDATE < '" . $date . "') and GRAND_TOT - TOTPAY > 1 and CANCELL = '0'") or die("Error";
		
    	if ($row_rssal = $sql_rssal->fetch()){

			if (is_null($row_rssal["out1"])==false) { 
				$rtxover60 = number_format($row_rssal["out1"], 2, ".", ",");
			}
		}


		$ResponseXML .= "<sales_table_acc><![CDATA[ <table  border=0  cellspacing=0>
						<tr><td width=\"200\"><input type=\"text\"  class=\"label_purchase\" value=\"Outstanding Invoice Amount\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"label_purchase\" value=\"".number_format($OutInvAmt, 2, ".", ",")."\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"label_purchase\" value=\"Return Cheque Amount\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"label_purchase\" value=\"".number_format($OutREtAmt, 2, ".", ",")."\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"label_purchase\" value=\"Pending Cheque Amount\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"label_purchase\" value=\"".number_format($OutpDAMT, 2, ".", ",")."\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"label_purchase\" value=\"PSD Cheque Settlments\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"label_purchase\" value=\"".number_format($pend_ret_set, 2, ".", ",")."\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"label_purchase\" value=\"Over 60 Outstandings\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"label_purchase\" value=\"".$rtxover60."\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"label_purchase\" value=\"Total\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"label_purchase\" value=\"".number_format($OutInvAmt+$OutREtAmt+$OutpDAMT+$pend_ret_set, 2, ".", ",")."\" disabled=\"disabled\"/></td></tr>
						 </table></table>]]></sales_table_acc>";
						 
        
		$ResponseXML .= "<OutInvAmt><![CDATA[".$OutInvAmt."]]></OutInvAmt>";
		$ResponseXML .= "<OutREtAmt><![CDATA[".$OutREtAmt."]]></OutREtAmt>";
		$ResponseXML .= "<OutpDAMT><![CDATA[".$OutpDAMT."]]></OutpDAMT>";
		
        $sqlbrtrn = $dbinv->query("select * from br_trn where Rep='".trim($salesrep)."' and brand='".$InvClass."' and cus_code='".trim($cuscode)."' ") or die("Error";
       if( $rowsbrtrn = $sqlbrtrn->fetch()){
	   	if (is_null($rowsbrtrn["credit_lim"])==false){
			$crLmt = $rowsbrtrn["credit_lim"];
		} else {
			$crLmt =0;
		}
		
		if (is_null($rowsbrtrn["tmpLmt"])==false){
			$tmpLmt = $rowsbrtrn["tmpLmt"];
		} else {
			$tmpLmt =0;
		}
		
		if (is_null($rowsbrtrn["CAT"])==false){ $cuscat=$rowsbrtrn["CAT"]; }
		if ($cuscat="A") { $m=2.5; }
		if ($cuscat="B") { $m=2.5; }
		if ($cuscat="C") { $m=1; }
			
		$txt_crelimi="0";
		$txt_crebal="0";
		
		$txt_crelimi=number_format($crLmt, 2, ".", ",");
		
		$txt_crebal = number_format($crLmt * $m + $tmpLmt - $OutInvAmt - $OutREtAmt - $OutpDAMT - $pend_ret_set, 2, ".", ",");
			
		
		$ResponseXML .= "<txt_crelimi><![CDATA[".$txt_crelimi."]]></txt_crelimi>";
        $ResponseXML .= "<txt_crebal><![CDATA[".$txt_crebal."]]></txt_crebal>";
	   } else {
	   	$ResponseXML .= "<txt_crelimi><![CDATA[0.00]]></txt_crelimi>";
        $ResponseXML .= "<txt_crebal><![CDATA[0.00]]></txt_crebal>";
	   }
		
		$creditbalance = $OutInvAmt + $OutREtAmt + $OutpDAMT;
		
  		$ResponseXML .= "<creditbalance><![CDATA[".number_format($creditbalance, 2, ".", ",")."]]></creditbalance>";

				
				
		 			$sql = $dbinv->query("select dis from brand_mas where barnd_name = '".trim($brand)."'") or die("Error";
					if ($row = $sql->fetch()){	
						$ResponseXML .= "<dis><![CDATA[".$row["dis"]."]]></dis>";
					}
			
				}
				
		
		
			
		$ResponseXML .= "</salesdetails>";		

				$_SESSION["print"]=1;

				echo $ResponseXML;
				
				
	
}


if ($_GET["Command"]=="pass_invno_to_inv"){


	
header('Content-Type: text/xml'); 
	echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
			
			$brand="";
			$salrep="";
			$cuscode="";
			
			$ResponseXML = "";
			$ResponseXML .= "<salesdetails>";
			$ResponseXML .= "<stname><![CDATA[".$_GET["stname"]."]]></stname>";
					$inv= $_GET['invno']; 
					$_SESSION["invno"]=$_GET['invno']; 
					$_SESSION["salesord1"]=$_GET['invno']; 
					
					$vatrate=0.12;
				
				$vatmethod="";	
					//echo "Select * from s_cusordmas where REF_NO='".$inv."'";
				$sql = $dbinv->query("Select * from s_cusordmas where REF_NO='".$inv."'") or die("Error";
				$row = $sql->fetch();
				$SAL_EX=$row['SAL_EX'];
					
		if ($_SESSION['company']=="THT"){	
				 
				 $sql = $dbinv->query("Select SPINV from tmpinvpara") or die("Error";
				
				$row = $sql->fetch();
				
				
			
			//$_SESSION["tmp_no_salinv"]="CRI/".$row["SPINV"];
			//echo $_SESSION["tmp_no_salinv"];
			$sql = $dbinv->query("delete from tmp_inv_data where tmp_no='".$_SESSION["tmp_no_salinv"]."'") or die("Error";
			
			$sql = $dbinv->query("update tmpinvpara set SPINV=SPINV+1") or die("Error";
			
			
			
			
			
			$sql = $dbinv->query("Select SPINV, CRE_INV_NO, CAS_INV_NO from invpara") or die("Error";
			
			$row = $sql->fetch();
			if ($_SESSION['dev']=="1"){
				 				
				$tmpinvno="000000".($row["SPINV"]+1);
				$lenth=strlen($tmpinvno);
			
				$invno=trim("CRI/ ").substr($tmpinvno, $lenth-6)."/5";
				$_SESSION["invno"]=$invno;
				$txtdono=$row["CAS_INV_NO"]+1;
			} else {
				
				$tmpinvno="000000".($row["SPINV"]+1);
				$lenth=strlen($tmpinvno);
			
				$invno=trim("CRI/ ").substr($tmpinvno, $lenth-6)."/".$SAL_EX;
				$_SESSION["invno"]=$invno;
				$txtdono=$row["CRE_INV_NO"]+1;
			
			}
			
		} else 	 if ($_SESSION['company']=="BEN") {
		
			$sql = $dbinv->query("Select SPINV from tmpinvpara") or die("Error";
			$row = $sql->fetch();
			
			
			//$_SESSION["tmp_no_salinv"]="CRI/".$row["SPINV"];
			//echo $_SESSION["tmp_no_salinv"];
			
			//echo "delete from tmp_inv_data where tmp_no='".$_SESSION["tmp_no_salinv"]."'";
			$sql = $dbinv->query("delete from tmp_inv_data where tmp_no='".$_SESSION["tmp_no_salinv"]."'") or die("Error";
			
			
			$sql = $dbinv->query("update tmpinvpara set SPINV=SPINV+1") or die("Error";
			
			
			
			$sql = $dbinv->query("Select SPINV, SPINV1, CAS_INV_NO_m, CAS_INV_NO from invpara") or die("Error";
			
			$row = $sql->fetch();
			
			if ($_SESSION['dev']=="1"){
				
				$tmpinvno="000000".($row["SPINV1"]+1);
				$lenth=strlen($tmpinvno);
			
				$invno=trim("BEN/CR/ ").substr($tmpinvno, $lenth-6)."/2";
				$_SESSION["invno"]=$invno;
				$txtdono=$row["CAS_INV_NO_m"]+1;
   	
			} else {
				$tmpinvno="000000".($row["SPINV"]+1);
				$lenth=strlen($tmpinvno);
			
				$invno=trim("BEN/CR/ ").substr($tmpinvno, $lenth-6)."/".$SAL_EX;
				$_SESSION["invno"]=$invno;
				$txtdono=$row["CAS_INV_NO"]+1;
  
			}
		}	
					
					
					
			 		//$tmpinvno="0000".substr($_GET['invno'], 4, 7) ;
					//$lenth=strlen($tmpinvno);
					//$serial=substr($tmpinvno, $lenth-7);
					//$inv=substr($_GET['invno'], 0, 3).substr("\ ", 0, 1).$serial;
				//$a="Select * from s_cusordmas where REF_NO='".$inv."'";
				

				//echo "Select * from s_cusordmas where REF_NO='".$inv."'";
				$sql = $dbinv->query("Select * from s_cusordmas where REF_NO='".$inv."'") or die("Error";
				
				if($row = $sql->fetch()){
				
					$ResponseXML .= "<str_order_no><![CDATA[".$inv."]]></str_order_no>";
					$ResponseXML .= "<str_invoiceno><![CDATA[".$invno."]]></str_invoiceno>";
					$ResponseXML .= "<str_crecash><![CDATA[".$row['TYPE']."]]></str_crecash>";
					$ResponseXML .= "<sdate><![CDATA[".$row['SDATE']."]]></sdate>";
					$cuscode=$row['C_CODE'];
					$ResponseXML .= "<str_customecode><![CDATA[".$row['C_CODE']."]]></str_customecode>";
					$_SESSION["custno"]=$row['C_CODE'];
					//$_SESSION["tmp_no_salinv"]= $row['tmp_no'];
					
					
			//	echo "Select * from vendor where CODE='".$row['C_CODE']."'";
					$sqlcustomer = $dbinv->query("Select * from vendor where CODE='".$row['C_CODE']."'") or die("Error";
					if($rowcustomer = $sqlcustomer->fetch()){
						$ResponseXML .= "<str_customername><![CDATA[".$rowcustomer['NAME']."]]></str_customername>";
						$ResponseXML .= "<str_address><![CDATA[".$rowcustomer['ADD1']." ".$rowcustomer['ADD2']."]]></str_address>";
						$ResponseXML .= "<str_vatno1><![CDATA[".$rowcustomer['vatno']."]]></str_vatno1>";
						$ResponseXML .= "<str_vatno2><![CDATA[".$rowcustomer['svatno']."]]></str_vatno2>";
						$ResponseXML .= "<cur_balance><![CDATA[".$rowcustomer['CUR_BAL']."]]></cur_balance>";
						
						
						if (trim($rowcustomer['vatno'])!=""){
							$ResponseXML .= "<str_vat><![CDATA[1]]></str_vat>";
							$vatmethod="1";
						} else {
							$ResponseXML .= "<str_vat><![CDATA[0]]></str_vat>";
							$vatmethod="0";
						}
					}
					
					//$ResponseXML .= "<str_vatno2><![CDATA[".$row['str_vatno2']."]]></str_vatno2>";
					$ResponseXML .= "<str_salesrep><![CDATA[".$row['SAL_EX']."]]></str_salesrep>";
					$salrep=$row['SAL_EX'];
					//$ResponseXML .= "<str_salesorder1><![CDATA[".$row['str_salesorder1']."]]></str_salesorder1>";
					//$ResponseXML .= "<str_salesorder2><![CDATA[".$row['str_salesorder2']."]]></str_salesorder2>";
					$ResponseXML .= "<dte_deliverdate><![CDATA[".$row['REQ_DATE']."]]></dte_deliverdate>";
					//$ResponseXML .= "<str_orderno1><![CDATA[".$row['ORD_NO']."]]></str_orderno1>";
					//$ResponseXML .= "<str_orderno2><![CDATA[".$row['ORD_DA']."]]></str_orderno2>";
					//$ResponseXML .= "<cur_credit><![CDATA[".$row['cur_credit']."]]></cur_credit>";
					
					
					$ResponseXML .= "<dis><![CDATA[".$row['DIS']."]]></dis>";
					$ResponseXML .= "<dis1><![CDATA[".$row['DIS1']."]]></dis1>";
					$ResponseXML .= "<dis2><![CDATA[".$row['DIS2']."]]></dis2>";
					
					$ResponseXML .= "<str_department><![CDATA[".$row['DEPARTMENT']."]]></str_department>";
					$department=$row['DEPARTMENT'];
					$_SESSION["department"]=$row['DEPARTMENT'];
					$ResponseXML .= "<str_brand><![CDATA[".$row['Brand']."]]></str_brand>";
					$_SESSION["brand"]=$row['Brand'];
					$brand=$row['Brand'];
					
					//$ResponseXML .= "<cur_discount1><![CDATA[".$row['cur_discount1']."]]></cur_discount1>";
					//$ResponseXML .= "<cur_discount2><![CDATA[".$row['cur_discount2']."]]></cur_discount2>";
					
						
				}				
		
				
			$ResponseXML .= "<sales_table><![CDATA[ <table><tr>
                              <td width=\"50\"  background=\"images/headingbg.gif\" ><font color=\"#FFFFFF\">ID</font></td>
							  <td width=\"100\"  background=\"images/headingbg.gif\" ><font color=\"#FFFFFF\">Code</font></td>
                              <td width=\"300\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Description</font></td>
                              <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Rate</font></td>
							  <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Rate With VAT</font></td>
                              <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Qty</font></td>
                              <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Discount</font></td>
                              <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Sub Total</font></td>
							  <td></td>
							  <td width=\"50\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">AD</font></td>
							  <td width=\"70\">Qty In Hand</td>
                            </tr>";
							
			/*$sql_data = $dbinv->query("Select CAS_INV_NO_m from invpara") or die("Error";
			$row = $sql_data->fetch();
			$tmpinvno="000000".$row["CAS_INV_NO_m"];
			$lenth=strlen($tmpinvno);
			$invno=trim("CRI/ ").substr($tmpinvno, $lenth-7);*/
				$i=1;	
				
				//echo "delete from tmp_inv_data where tmp_no='".$_SESSION["tmp_no_salinv"]."'";
				$sql_data = $dbinv->query("delete from tmp_inv_data where tmp_no='".$_SESSION["tmp_no_salinv"]."'") or die("Error";
				//echo "Select * from s_cusordtrn where REF_NO='".$inv."'";
				//echo "Select * from s_cusordtrn where REF_NO='".$inv."'";
				$sql_data = $dbinv->query("Select * from s_cusordtrn where REF_NO='".$inv."'") or die("Error";
				while($row = $sql_data->fetch()){
					//echo "Select * from s_mas where STK_NO='".$row['STK_NO']."' and BRAND_NAME='".$brand."'";
					$sql_itdata = $dbinv->query("Select * from s_mas where STK_NO='".$row['STK_NO']."' and BRAND_NAME='".$brand."'") or die("Error";
					$rowit = $sql_itdata->fetch();
							
					//$a="Insert into tmp_ord_data(str_invno, str_code, str_description, cur_rate, cur_qty, dis_per,cur_discount, cur_subtot, brand) values ( '".$row['REF_NO']."', '".$row['STK_NO']."', '".$row['DESCRIPT']."', ".$row['PRICE'].", ".$row['QTY'].", ".$row['DIS_per'].", ".$row['DIS_rs'].", ".$row["subtot"].", '".$row['BRAND']."')";
					//echo $a;	
					//echo "Insert into tmp_inv_data(str_invno, str_code, str_description, cur_rate, cur_qty, dis_per,cur_discount, cur_subtot, brand, tmp_no) values ( '".$_GET["newinvno"]."', '".$row['STK_NO']."', '".$row['DESCRIPT']."', ".$row['PRICE'].", ".$row['QTY'].", ".$row['DIS_per'].", ".$row['DIS_rs'].", ".$row["subtot"].", '".$row['BRAND']."', '".$_SESSION["tmp_no_salinv"]."')";
					//$sql="Insert into tmp_ord_data (str_invno, str_code, str_description, cur_rate, cur_qty, dis_per, cur_discount, cur_subtot, brand, tmp_no, part_no)values 
			//('".$_GET['invno']."', '".$_GET['itemcode']."', '".$_GET['item']."', ".$rate.", ".$qty.", ".$_GET["discountper"].", ".$discount.", ".$subtotal.", '".$_GET["brand"]."', '".$_SESSION["tmp_no_ord"]."', '".$_GET["str_partno"]."') ";
			
					
					if ($vatmethod!="1"){
						$SELLING=$rowit['SELLING'];
					} else {
						$SELLING=$rowit['SELLING']/($vatrate+1);
					}
					
					$dis_val=$SELLING*$row['QTY']*$row['DIS_per']/100;
				//	echo "Insert into tmp_inv_data(str_invno, str_code, str_description, cur_rate, cur_qty, dis_per,cur_discount, cur_subtot, brand, actual_selling, ad, tmp_no) values ( '".$_GET["newinvno"]."', '".$row['STK_NO']."', '".$row['DESCRIPT']."', ".$SELLING.", ".$row['QTY'].", ".$row['DIS_per'].", ".$dis_val.", ".(($SELLING*$row['QTY'])-$dis_val).", '".$row['BRAND']."', ".$rowit["SELLING"].", '".$row["ad"]."', '".$_SESSION["tmp_no_salinv"]."')";
					$sql_tmp = $dbinv->query("Insert into tmp_inv_data(str_invno, str_code, str_description, cur_rate, cur_qty, dis_per,cur_discount, cur_subtot, brand, actual_selling, ad, tmp_no) values ( '".$_GET["newinvno"]."', '".$row['STK_NO']."', '".$row['DESCRIPT']."', ".$SELLING.", ".$row['QTY'].", ".$row['DIS_per'].", ".$dis_val.", ".(($SELLING*$row['QTY'])-$dis_val).", '".$row['BRAND']."', ".$rowit["SELLING"].", '".$row["ad"]."', '".$_SESSION["tmp_no_salinv"]."')") or die("Error";
				}
				
			$i=1;
			//$sql="Select * from tmp_inv_data where tmp_no='".$_SESSION["tmp_no_salinv"]."'";
			$sql = $dbinv->query("Select * from tmp_inv_data where tmp_no='".$_SESSION["tmp_no_salinv"]."' order by id") or die("Error";
			while($row = $sql->fetch()){
		
				$id="id".$i;		
				$code="code".$i;
				$itemd="itemd".$i;
				$rate="rate".$i;
				$actual_selling="actual_selling".$i;
				$qty="qty".$i;			
				$discountper="discountper".$i;			
				$subtotal="subtotal".$i;	
				$discount="discount".$i;	
				$ad="ad".$i;	
						
						//echo "Select * from s_mas where STK_NO='".$row['str_code']."' and BRAND_NAME='".$brand."'";
					$sql_mas = $dbinv->query("Select * from s_mas where STK_NO='".$row['str_code']."' and BRAND_NAME='".$brand."'") or die("Error";
						
					$rowmas = $sql_mas->fetch();
					
					if ($vatmethod!="1"){
						$SELLING=$rowit['SELLING'];
					} else {
						$SELLING=$rowit['SELLING']/($vatrate+1);
					}
						
             	$ResponseXML .= "<tr>  
				             <td onClick=\"disp_qty('".$row['str_code']."');\"><div id='".$id."'>".$row['id']."</div></td>                             <td onClick=\"disp_qty('".$row['str_code']."');\"><div id='".$code."'>".$row['str_code']."</div></td>
							 <td onClick=\"disp_qty('".$row['str_code']."');\"><div id='".$itemd."'>".$row['str_description']."</div></td>
							 <td align=right onClick=\"disp_qty('".$row['str_code']."');\"><input type=\"text\"  class=\"text_purchase3\" name=\"".$rate."\" id=\"".$rate."\" size=\"15\"  value=\"".number_format($row['cur_rate'], 2, ".", ",")."\"  disable  onkeypress=\"keyset('credper',event);\" /></td>
							 <td align=right ><input type=\"text\"  class=\"text_purchase3\" name=\"".$actual_selling."\" id=\"".$actual_selling."\" size=\"15\"  value=\"".number_format($rowmas['SELLING'], 2, ".", ",")."\" onblur=\"calc1_table('".$i."');\" /></td>
							  <td align=right onClick=\"disp_qty('".$row['str_code']."');\"><input type=\"text\"  class=\"text_purchase3\" name=\"".$qty."\" id=\"".$qty."\" size=\"15\"  value=\"".number_format($row['cur_qty'], 0, ".", ",")."\"  onblur=\"calc1_table('".$i."');\"  onkeypress=\"keyset('credper',event);\" />    </td>
							 <td align=right onClick=\"disp_qty('".$row['str_code']."');\"><div id='".$discountper."'>".$row['dis_per']."</div><input type=\"hidden\"  class=\"text_purchase3\" name=\"".$discount."\" id=\"".$discount."\" size=\"15\"  value=\"".number_format($row['cur_discount'], 2, ".", ",")."\"    /></td>
							 
							 <td align=right onClick=\"disp_qty('".$row['str_code']."');\"><div id='".$subtotal."'>".number_format($row['cur_subtot'], 2, ".", ",")."</div></td>";
							
							 $ResponseXML .= "<td ><img src=\"images/delete_01.png\" width=\"20\" height=\"20\" id=".$row['str_code']."  name=".$row['str_code']." onClick=\"del_item('".$row['id']."');\"></td>";
							 
							 
							if ($row['ad']=="1"){
							 	$ResponseXML .= "<td><input type=\"checkbox\" onClick=\"chk_ad('".$i."');\" name='".$ad."' id='".$ad."' checked></td>";
							} else {
								$ResponseXML .= "<td><input type=\"checkbox\" onClick=\"chk_ad('".$i."');\" name='".$ad."' id='".$ad."'></td>";
							}
							
							
							
							  include_once("connection.php");
							
							 $sqlqty = $dbinv->query("select QTYINHAND from s_submas where STK_NO='".$row['str_code']."' AND STO_CODE='".$department."'") or die("Error";
					if($rowqty = $sqlqty->fetch()){
						$qty=number_format($rowqty['QTYINHAND'], 0, ".", ",");
					} else {
						$qty=0;
					}	
					
						
						$ResponseXML .= "<td  >".$qty."</td>";
							
					      $ResponseXML .= "</tr>";
			
			 	
						$i=$i+1;	
							
            					
				}
			
			    $ResponseXML .= "   </table>]]></sales_table>";
				
				
			$ResponseXML .= "<item_count><![CDATA[".$i."]]></item_count>";
			//	echo "Select sum(cur_subtot) as tot_sub, sum(cur_discount) as tot_dis from tmp_inv_data where tmp_no='".$_SESSION["tmp_no_salinv"]."'";
				$sql = $dbinv->query("Select sum(cur_subtot) as tot_sub, sum(cur_discount) as tot_dis from tmp_inv_data where tmp_no='".$_SESSION["tmp_no_salinv"]."'") or die("Error";	
			
				//$result =$db->RunQuery($sql);
				$row = $sql->fetch();	
				$ResponseXML .= "<cur_subtotal><![CDATA[".number_format($row['tot_sub'], 2, ".", ",")."]]></cur_subtotal>";
				$ResponseXML .= "<cur_discount><![CDATA[".number_format($row['tot_dis'], 2, ".", ",")."]]></cur_discount>";
				
				$vatrate=0.12;
				
				if ($vatmethod=="1"){
					$tax=$row['tot_sub']*$vatrate;
					$taxf=number_format($tax, 2, ".", ",");
					
					$ResponseXML .= "<cur_tax><![CDATA[".$taxf."]]></cur_tax>";
					//$ResponseXML .= "<taxname><![CDATA[Tax (VAT 12%)]]></taxname>";
					
					$invtot=number_format($row['tot_sub']+$tax, 2, ".", ",");
					$ResponseXML .= "<cur_invoiceval><![CDATA[".$invtot."]]></cur_invoiceval>";
					
				
					
				} else {
					//$tax=number_format($row['tot_sub']*$vatrate, 2, ".", ",");
					$ResponseXML .= "<cur_tax><![CDATA[0.00]]></cur_tax>";
					//$ResponseXML .= "<taxname><![CDATA[Tax]]></taxname>";
					
					$invtot=number_format($row['tot_sub'], 2, ".", ",");
					$ResponseXML .= "<cur_invoiceval><![CDATA[".$invtot."]]></cur_invoiceval>";
				}
				
		//$ResponseXML .= "<item_count><![CDATA[".$i."]]></item_count>"; 

	//$cuscode=$_GET["custno"];	
	$RET_AMOUNT = 0;
	$PD_AMOUNT = 0;
	$OUT_AMOUNT = 0;

	//echo "select * from vendor where CODE = '".trim($cuscode)."'";
	$sql = $dbinv->query("select * from vendor where CODE = '".trim($cuscode)."'") or die("Error";
	if ($row = $sql->fetch()){	
		//echo "SELECT che_amount FROM s_invcheq WHERE che_date>'".$_GET["invdate"]."' AND cus_code='".$row["CODE"]."'";
		$sqlchq = $dbinv->query("SELECT che_amount FROM s_invcheq WHERE che_date>'".$_GET["invdate"]."' AND cus_code='".$row["CODE"]."'") or die("Error";
		
		while ($rowchq = $sqlchq->fetch()){
			$PD_AMOUNT = $PD_AMOUNT + $rowchq["che_amount"];
		}	
		
		if (is_null($row["AltMessage"])==false ){
           	if (trim($row["AltMessage"]) != ""){
		   		$ResponseXML .= "<AltMessage><![CDATA[".$row['AltMessage']."]]></AltMessage>"; 
			} else {
				$ResponseXML .= "<AltMessage><![CDATA[]]></AltMessage>"; 
			}
		} else {
			$ResponseXML .= "<AltMessage><![CDATA[]]></AltMessage>"; 
        }
		
		if ($row["chk_bangr"] == "1"){
			
           $dateDiff = $row["bank_gr_date"] - $_GET["invdate"];
		   $m_dates    = floor($dateDiff/(60*60*24));
		   if ($m_dates>30 and $m_dates<60)
		   {
		   	$ResponseXML .= "<bank_message><![CDATA[Please Re-New Bank Grantee Date]]></bank_message>"; 
			$_SESSION["inv_status"]=0;
		   } else if ($m_dates <= 30){
				$ResponseXML .= "<bank_message><![CDATA[No Permission For Invoice For This Customer Please Re-New Bank Grantee Date]]></bank_message>"; 	
			$_SESSION["inv_status"]=0;
		   }
		 } else {
		  	$ResponseXML .= "<bank_message><![CDATA[]]></bank_message>"; 
         }
		
	//echo "select SDATE from  s_salma where  C_CODE='".trim($cuscode)."' and GRAND_TOT-TOTPAY >1 and CANCELL=0  order by SDATE";
	$sql60 = $dbinv->query("select SDATE from  s_salma where  C_CODE='".trim($cuscode)."' and GRAND_TOT-TOTPAY >1 and CANCELL=0  order by SDATE") or die("Error";
	if ($row60 = $sql60->fetch()){		 
		//$mtmp = $_GET["invdate"] - $row60["SDATE"];
		
		//$mdays= floor($mtmp/(60*60*24));
		
		
		$date1 = $row60["SDATE"];
		$date2 = $_GET["invdate"]; 

		$diff = abs(strtotime($date2) - strtotime($date1));

		$years = floor($diff / (365*60*60*24));
	
		$months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));
	
		$mday = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));
		$mdays=$mday+($months*30)+($years*365);
		
		if ($mdays > 60){
			
			$_SESSION["inv_status"]="0";
			if (is_null($row["Over_DUE_IG_Date"])==false){
			
				if (strtotime($row["Over_DUE_IG_Date"])!=strtotime(date("Y-m-d"))){
					$ResponseXML .= "<over60_qst><![CDATA[No Permission For Invoice For This Customer Please Re-New LIMIT Grantee Date]]></over60_qst>";
					$ResponseXML .= "<over60_message><![CDATA[Over 60 Outsnding Avilabale]]></over60_message>"; 
					$ResponseXML .= "<over60_txt><![CDATA[60]]></over60_txt>"; 
		//echo "insert into tmpcrlmt (sdate, stime, tmpLmt, Class, Rep,cuscode, crLmt,  FLAG) values ('".$_GET["invdate"]."','".date("h:i:s")."' , ".$mdays." ,'NB','NR','".trim($cuscode)."','0', 'O60')";
					$sqltmpCrLmt = $dbinv->query("insert into tmpcrlmt (sdate, stime, tmpLmt, Class, Rep,cuscode, crLmt,  FLAG) values ('".$_GET["invdate"]."','".date("h:i:s")."' , ".$mdays." ,'NB','NR','".trim($cuscode)."','0', 'O60')") or die("Error";
					
				} else {
					//$ResponseXML .= "<over60_qst><![CDATA[You have approved for proceed]]></over60_qst>";
					$ResponseXML .= "<over60_qst><![CDATA[]]></over60_qst>";
					$ResponseXML .= "<over60_message><![CDATA[]]></over60_message>"; 
					$ResponseXML .= "<over60_txt><![CDATA[0]]></over60_txt>"; 
				}
			} else {
				$ResponseXML .= "<over60_qst><![CDATA[]]></over60_qst>";
				$ResponseXML .= "<over60_message><![CDATA[]]></over60_message>"; 
				$ResponseXML .= "<over60_txt><![CDATA[0]]></over60_txt>"; 
			}
		} else {
			$ResponseXML .= "<over60_message><![CDATA[]]></over60_message>"; 
			$ResponseXML .= "<over60_txt><![CDATA[0]]></over60_txt>"; 
			$ResponseXML .= "<over60_qst><![CDATA[]]></over60_qst>";
		}
	 } else {
		  	$ResponseXML .= "<over60_message><![CDATA[]]></over60_message>"; 
			$ResponseXML .= "<over60_qst><![CDATA[]]></over60_qst>";
			$ResponseXML .= "<over60_txt><![CDATA[0]]></over60_txt>"; 
    }
     
	 //echo "Select * from s_cheq where CR_CHEVAL-PAID>0 and CR_FLAG='0' and CR_C_CODE='".trim($cuscode)."'";
    $sqls_cheq = $dbinv->query("Select * from s_cheq where CR_CHEVAL-PAID>0 and CR_FLAG='0' and CR_C_CODE='".trim($cuscode)."'" ) or die("Error";
	if ($rows_cheq = $sqls_cheq->fetch()){
		$ResponseXML .= "<chq_message><![CDATA[Return Cheque]]></chq_message>";
		$_SESSION["inv_status"]=0;
		if (is_null($row["Over_DUE_IG_Date"])==false){
			if ($row["Over_DUE_IG_Date"]==date("Y-m-d")){
				$ResponseXML .= "<chq_message_que><![CDATA[Do You Want To Continue with Return Cheques]]></chq_message_que>";
				//echo "insert into tmpcrlmt (sdate, stime, tmpLmt, Class, Rep,cuscode, crLmt, FLAG) values ('".$_GET["invdate"]."', '".date("h:i:s")."', '0' ,'NB','NR','".trim($cuscode)."','0', 'RTN'";
				$sqltmpCrLmt = $dbinv->query("insert into tmpcrlmt (sdate, stime, tmpLmt, Class, Rep,cuscode, crLmt, FLAG) values ('".$_GET["invdate"]."', '".date("h:i:s")."', '0' ,'NB','NR','".trim($cuscode)."','0', 'RTN')") or die("Error";
			} else {
				$ResponseXML .= "<chq_message_que><![CDATA[]]></chq_message_que>";
			}
		}	
	} else {
		$ResponseXML .= "<chq_message><![CDATA[]]></chq_message>";
		$ResponseXML .= "<chq_message_que><![CDATA[]]></chq_message_que>";
	} 
	
		

		
        
        if (is_null($row["cLIMIT"])==false){
			//$ResponseXML .= "<txt_crelimi><![CDATA[".number_format($row['cLIMIT']+$row['temp_limit'], 2, ".", ",")."]]></txt_crelimi>"; 
		}
		
		if (is_null($row["CUR_BAL"])==false){
			$OUT_AMOUNT=$row["CUR_BAL"];
		}
        
        if (is_null($row["CAT"])==false) {
			$cuscat = $row["CAT"];
		}
 // 	echo "Select * from s_cheq where CR_C_CODE='".trim($cuscode)."' and CR_CHEVAL-PAID>0 and CR_FLAG='0'";
		$sqlretchq = $dbinv->query("Select * from s_cheq where CR_C_CODE='".trim($cuscode)."' and CR_CHEVAL-PAID>0 and CR_FLAG='0'") or die("Error";
		while ($rowretchq = $sqlretchq->fetch()){
			$RET_AMOUNT = $RET_AMOUNT + $rowretchq["CR_CHEVAL"] - $rowretchq["PAID"];
		}
	
  }     


       //Call SETLIMIT ====================================================================

	$OutpDAMT = 0;
	$OutREtAmt = 0;
	$OutInvAmt = 0;
	$InvClass="";
//	echo "select class from brand_mas where barnd_name='".trim($brand)."'";
	$sqlclass = $dbinv->query("select class from brand_mas where barnd_name='".trim($brand)."'") or die("Error";
	if ($rowclass = $sqlclass->fetch()){
		if (is_null($rowclass["class"])==false){
			$InvClass=$rowclass["class"];
		}
	}
	//echo $InvClass;
//	echo "select sum(GRAND_TOT-TOTPAY) as totout from view_s_salma where GRAND_TOT>TOTPAY and CANCELL='0' and C_CODE='".trim($cuscode)."' and SAL_EX='".trim($salrep)."' and class='".$InvClass."'";
	$sqloutinv = $dbinv->query("select sum(GRAND_TOT-TOTPAY) as totout from view_s_salma where GRAND_TOT>TOTPAY and CANCELL='0' and C_CODE='".trim($cuscode)."' and SAL_EX='".trim($salrep)."' and class='".$InvClass."'") or die("Error";
	if ($rowoutinv = $sqloutinv->fetch()){
		if (is_null($rowoutinv["totout"])==false){
			$OutInvAmt=$rowoutinv["totout"];
		}
	}
//echo $OutInvAmt;
$sqlinvcheq = $dbinv->query("SELECT * FROM s_invcheq WHERE che_date>'".$_GET["invdate"]."' AND cus_code='".trim($cuscode)."' and trn_type='REC' and sal_ex='".trim($salrep)."'") or die("Error";
	while($rowinvcheq = $sqlinvcheq->fetch()){
		$sqlsttr = $dbinv->query("select * from s_sttr where ST_REFNO='".trim($rowinvcheq["refno"])."' and ST_CHNO ='".trim($rowinvcheq["cheque_no"]) ."'") or die("Error";
		while($rowsttr = $sqlsttr->fetch()){
			$sqlview_s_salma = $dbinv->query("select class from view_s_salma where REF_NO='".trim($rowsttr["ST_INVONO"])."'") or die("Error";
			if($rowview_s_salma = $sqlview_s_salma->fetch()){
				if (trim($rowview_s_salma["class"]) == $InvClass){
                    $OutpDAMT = $OutpDAMT + $rowsttr["ST_PAID"];
                }
			}
		}
	}


    
        $pend_ret_set = 0;
		$sqlinvcheq = $dbinv->query("SELECT sum(che_amount) as  che_amount FROM s_invcheq WHERE che_date >'".$_GET["invdate"]."' AND cus_code='".trim($cuscode)."' and trn_type='RET'") or die("Error";
		if($rowinvcheq = $sqlinvcheq->fetch()){
			if (is_null($rowinvcheq["che_amount"])==false){
				$pend_ret_set=$rowinvcheq["che_amount"];
			}
		}
		
		$sqlcheq = $dbinv->query("Select sum(CR_CHEVAL-PAID) as tot from s_cheq where CR_C_CODE='".trim($cuscode)."'  and CR_CHEVAL-PAID>0 and CR_FLAG='0' and S_REF='".trim($salrep)."'") or die("Error";
		if($rowcheq = $sqlcheq->fetch()){
			if (is_null($rowcheq["tot"])==false){
				$OutREtAmt=$rowcheq["tot"];
				$ResponseXML .= "<msg_return><![CDATA[Return Cheques Available]]></msg_return>";
			} else {
				$OutREtAmt=0;
				$ResponseXML .= "<msg_return><![CDATA[]]></msg_return>";
			}
		} else {
			$ResponseXML .= "<msg_return><![CDATA[]]></msg_return>";	
		}
		
            
		$d=date("Y-m-d");
		
			$date = date('Y-m-d',strtotime($d.' -60 days'));
		
		$sql_rssal = $dbinv->query("Select sum(GRAND_TOT - TOTPAY) as out1 from s_salma where C_CODE = '" . trim($cuscode) . "' and (SDATE < '" . $date . "') and GRAND_TOT - TOTPAY > 1 and CANCELL = '0'") or die("Error";
		
    	if ($row_rssal = $sql_rssal->fetch()){

			if (is_null($row_rssal["out1"])==false) { 
				$rtxover60 = number_format($row_rssal["out1"], 2, ".", ",");
			}
		}
        
 $ResponseXML .= "<sales_table_acc><![CDATA[ <table  border=0  cellspacing=0>
						<tr><td><input type=\"text\"  class=\"label_purchase\" value=\"Outstanding Invoice Amount\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"label_purchase\" value=\"".number_format($OutInvAmt, 2, ".", ",")."\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"label_purchase\" value=\"Return Cheque Amount\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"label_purchase\" value=\"".number_format($OutREtAmt, 2, ".", ",")."\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"label_purchase\" value=\"Pending Cheque Amount\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"label_purchase\" value=\"".number_format($OutpDAMT, 2, ".", ",")."\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"label_purchase\" value=\"PSD Cheque Settlments\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"label_purchase\" value=\"".number_format($pend_ret_set, 2, ".", ",")."\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"label_purchase\" value=\"Over 60 Outstandings\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"label_purchase\" value=\"".$rtxover60."\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"label_purchase\" value=\"Total\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"label_purchase\" value=\"".number_format($OutInvAmt+$OutREtAmt+$OutpDAMT+$pend_ret_set, 2, ".", ",")."\" disabled=\"disabled\"/></td></tr>
						 </table></table>]]></sales_table_acc>";
						 		

      $sqlbr_trn = $dbinv->query("select * from br_trn where Rep='".trim($salrep)."' and brand='".trim($InvClass)."' and cus_code='" .trim($cuscode)."'") or die("Error";  
	 // echo "select * from br_trn where Rep='".trim($salrep)."' and brand='".trim($InvClass)."' and cus_code='" .trim($cuscode)."'";
	if($rowbr_trn = $sqlbr_trn->fetch()){
		if(is_null($rowbr_trn["credit_lim"]) == false){
			$crLmt=$rowbr_trn["credit_lim"];
		} else {	
			$crLmt=0;		
		}
	
		
		if(is_null($rowbr_trn["tmpLmt"]) == false){
			$tmpLmt=$rowbr_trn["tmpLmt"];
		} else {	
			$tmpLmt=0;		
		}
		
		if (is_null($rowbr_trn["CAT"])==false) {
			$cuscat = trim($rowbr_trn["CAT"]);
            if ($cuscat == "A"){ $m = 2.5; }
            if ($cuscat == "B"){ $m = 2.5; }
            if ($cuscat == "C"){ $m = 1; }
			if ($cuscat == "D"){ $m = 0; }
            $txt_crelimi = "0";
            $txt_crebal = "0";
            $txt_crelimi = number_format($crLmt, 2, ".", ",");
			//$crebal=$crLmt * $m + $tmpLmt - $OutInvAmt - $OutREtAmt - $OutpDAMT - $pend_ret_set;
           // $txt_crebal = number_format($crebal, "2", ",", "'");
		   	//$txt_crebal = $crLmt * $m - $OutInvAmt - $OutREtAmt - $OutpDAMT - $pend_ret_set;
            
          } else {
            $txt_crelimi = "0";
            $txt_crebal = "0";
          }
		 // echo "$crLmt-".$crLmt."/$m-".$m."/$tmpLmt-".$tmpLmt."/$OutInvAmt-".$OutInvAmt."/$OutREtAmt-".$OutREtAmt."/$OutpDAMT-".$OutpDAMT."/$pend_ret_set-".$pend_ret_set;
		  $crebal = $crLmt * $m + $tmpLmt - $OutInvAmt - $OutREtAmt - $OutpDAMT - $pend_ret_set;
		  $txt_crebal = $crLmt * $m - $OutInvAmt - $OutREtAmt - $OutpDAMT - $pend_ret_set;
         $creditbalance = $OutInvAmt + $OutREtAmt + $OutpDAMT;

	   			
			
			 
    }    
			$ResponseXML .= "<txt_crelimi><![CDATA[".$txt_crelimi."]]></txt_crelimi>";
			$ResponseXML .= "<txt_crebal><![CDATA[".$txt_crebal."]]></txt_crebal>";
			$ResponseXML .= "<crebal><![CDATA[".$crebal."]]></crebal>";
          	$ResponseXML .= "<creditbalance><![CDATA[".number_format($txt_crebal, "2", ".", ",")."]]></creditbalance>";
			
			

		$ResponseXML .= "</salesdetails>";
		
		$_SESSION["print"]=1;	
		echo $ResponseXML;
}



if ($_GET["Command"]=="assign_brand"){
	$_SESSION["brand"]=$_GET["brand"];
	//echo $_SESSION["brand"];
	
	$sql = $dbinv->query("DROP VIEW view_s_salma") or die("Error";
	
	
	$sql = mysql_query("CREATE VIEW view_s_salma
AS
SELECT     s_salma.*, brand_mas.class AS class
FROM         brand_mas RIGHT OUTER JOIN
                      s_salma ON brand_mas.barnd_name = s_salma.brand") or die("Error";
	

	
	header('Content-Type: text/xml'); 
		echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
			
		$ResponseXML = "";
		$ResponseXML .= "<salesdetails>";
		
	$OutpDAMT = 0;
	$OutREtAmt = 0;
	$OutInvAmt = 0;
	
	$InvClass=" ";
	
	
	$sql = $dbinv->query("select class from brand_mas where barnd_name = '".trim($_GET["brand"])."'") or die("Error";
	if($row = $sql->fetch()){
		if (is_null($row["class"])==false) {
			$InvClass = trim($row["class"]);		
		}
	}	

	/*If InvClass = "" Then
		MsgBox "Brand master file not complete"
	Exit Sub
	End If*/
	
	if ($InvClass!=""){
		$cmbrep=trim(substr($_GET["salesrep"], 0, 5));
		
		$sql = $dbinv->query("select sum(grand_tot-totpay) as totOut from view_s_salma where grand_tot>totpay and cancell='0' and c_code='".trim($cuscode)."' and sal_ex='".$cmbrep."' and class='".$InvClass."'") or die("Error";
		if($row = $sql->fetch()){
		
		   if (is_null($row["totOut"])==false){
		   	$OutInvAmt = $row["totOut"];
			
			}
		}
		
 		
		$sql = $dbinv->query("SELECT * FROM s_invcheq WHERE CHE_DATE>'".$_GET["invdate"]."' AND CUS_CODE='".trim($cuscode)."' and trn_type='REC' and sal_ex='".$cmbrep."'") or die("Error";
		while($row = $sql->fetch()){
		    $sql1 = $dbinv->query("select * from s_sttr where st_refno='".trim($row["REFNO"])."' and st_chno ='".trim($row["cheque_no"])."'") or die("Error";
			while($row1 = $sql1->fetch()){
				$sql2 = $dbinv->query("select class from view_s_salma where ref_no='".trim($row["ST_INVONO"])."' ") or die("Error";
				if ($row2 = $sql2->fetch()){
                    if (trim($row2["Class"]) == $InvClass) {
                    	$OutpDAMT = $OutpDAMT + $row1["ST_PAID"];
                    }
                }
			}
		}
		
		$pend_ret_set = 0;		
		$sql = $dbinv->query("SELECT sum(che_amount) as  che_amount FROM s_invcheq WHERE CHE_DATE >'".$_GET["invdate"]."' AND CUS_CODE='".trim($cuscode)."' and trn_type='RET' ") or die("Error";
				if ($row = $sql->fetch()){	
					if (is_null($row["che_amount"])==false){
						$pend_ret_set = $row["che_amount"];
					}
				}
						
        
 /*       $pend_ret_set = 0;
      	$sql = $dbinv->query("SELECT sum(che_amount) as  che_amount FROM s_invcheq WHERE CHE_DATE >'".$_GET["invdate"]."' AND CUS_CODE='".trim(txt_cuscode)."' and trn_type='RET' ") or die("Error";
		if ($row = $sql->fetch()){	
       
        	if (is_null($row["che_amount"]==false)) 
			{	
				$pend_ret_set = $row["che_amount"];
			}
		}	*/


       
		 $sql = $dbinv->query("Select sum(CR_CHEVAL-paid) as tot from s_cheq where CR_C_CODE='".trim(txt_cuscode). "'  and CR_CHEVAL-paid>0 and cr_flag='0' and s_ref='".trim($cmbrep)."' ") or die("Error";
		if ($row = $sql->fetch()){	
		
        	if (is_null($row["tot"]==false)){
           		$OutREtAmt = $row["tot"];
        	} else {
           		$OutREtAmt = 0;
        	}
        }
		
		
		
        $ResponseXML .= "<sales_table><![CDATA[ <table  bgcolor=\"#0000FF\" border=1  cellspacing=0>
						<tr><td>Outstanding Invoice Amount</td><td>".number_format($OutInvAmt, 2, ".", ",")."</td></tr>
						 <td>Return Cheqe Amount</td><td>".number_format($OutREtAmt, 2, ".", ",")."</td></tr>
						 <td>Pending Cheque Amount</td><td>".number_format($OutpDAMT, 2, ".", ",")."</td></tr>
						 <td>PSD Cheque Settlments</td><td>".number_format($pend_ret_set, 2, ".", ",")."</td></tr>
						 <td>Total</td><td>".number_format($OutInvAmt+$OutREtAmt+$OutpDAMT+$pend_ret_set, 2, ".", ",")."</td></tr>
						 </table></table>]]></sales_table>";
				

        
		  $sql = $dbinv->query("select * from br_trn where rep='".$cmbrep."' and brand='".trim($InvClass)."' and cus_code='".trim($cuscode)."' ") or die("Error";
		if ($row = $sql->fetch()){	
		           
            if (is_null($row["credit_lim"]==false)){
               $crLmt = $row["credit_lim"];
            } else {
               $crLmt = 0;
            }
			
			if (is_null($row["tmpLmt"]==false)){
               $tmpLmt = $row["tmpLmt"];
            } else {
               $tmpLmt = 0;
            }
			
			if (is_null($row["cat"]==false)){
               $cuscat = trim($row["cat"]);
            }
            
			if ($cuscat=="A"){ $m = 2.5; }
			if ($cuscat=="B"){ $m = 2.5; }
			if ($cuscat=="C"){ $m = 1; }
                      
            $txt_crelimi = "0";
            $txt_crebal = "0";
            $txt_crelimi =number_format($crLmt, 2, ".", ",");
            $txt_crebal = number_format($crLmt * $m + $tmpLmt - $OutInvAmt - $OutREtAmt - $OutpDAMT - $pend_ret_set, 2, ".", ",");
			
			$ResponseXML .= "<txt_crelimi><![CDATA[".$txt_crelimi."]]></txt_crelimi>";
			$ResponseXML .= "<txt_crebal><![CDATA[".$txt_crebal."]]></txt_crebal>";
          } else {
            $txt_crelimi = "0";
            $txt_crebal = "0";
			
			$ResponseXML .= "<txt_crelimi><![CDATA[".$txt_crelimi."]]></txt_crelimi>";
			$ResponseXML .= "<txt_crebal><![CDATA[".$txt_crebal."]]></txt_crebal>";
          }
          $creditbalance = $OutInvAmt + $OutREtAmt + $OutpDAMT;
          $ResponseXML .= "<creditbalance><![CDATA[".$creditbalance."]]></creditbalance>";
		  
		 $sql = $dbinv->query("select dis from brand_mas where barnd_name = '".trim($_GET["brand"])."'") or die("Error";
		if ($row = $sql->fetch()){	
			$ResponseXML .= "<dis><![CDATA[".$row["dis"]."]]></dis>";
		}
          $xx = 1;
 		}	
		
		
			
		$ResponseXML .= "</salesdetails>";	
		echo $ResponseXML;
}

// connection closed;	
?>

