<?php

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


	include_once("connectioni.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\">Ref No</font></td>
                              <td width=\"424\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Customer Ref</font></td>
                             <td width=\"176\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Cheque No</font></td>
							 <td width=\"176\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Date</font></td>
   							</tr>";
                           
						   		$letters = $_GET['invno'];
								
								$sql = mysqli_query($GLOBALS['dbinv'],"select * from s_cheq where CR_REFNO like  '$letters%'  ORDER BY CR_REFNO limit 50") or die(mysqli_error($GLOBALS['dbinv']));
								
						/*	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;
								$sql = mysqli_query($GLOBALS['dbinv'],"SELECT * from s_purmas where  REFNO like  '$letters%' order by id desc") or die(mysqli_error($GLOBALS['dbinv']));
							} else if ($_GET["mstatus"]=="customername"){
								$letters = $_GET['customername'];
								//$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
								$sql = mysqli_query($GLOBALS['dbinv'],"SELECT * from s_purmas where SUP_NAME like  '$letters%' order by id desc") or die(mysqli_error($GLOBALS['dbinv'])) or die(mysqli_error($GLOBALS['dbinv']));
							} else {
								$letters = $_GET['customername'];
								//$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
								$sql = mysqli_query($GLOBALS['dbinv'],"SELECT * from s_purmas where SUP_NAME like  '$letters%' order by id desc") or die(mysqli_error($GLOBALS['dbinv'])) or die(mysqli_error($GLOBALS['dbinv']));
							}
							
								*/					
						
							while($row = mysqli_fetch_array($sql)){
								$REF_NO = $row['REF_NO'];
								$stname = "inv_mast";
							$ResponseXML .= "<tr>               
                              <td onclick=\"ret_chq('".$row['CR_REFNO']."', '".$_GET['stname']."');\">".$row['CR_REFNO']."</a></td>
                              <td onclick=\"ret_chq('".$row['CR_REFNO']."', '".$_GET['stname']."');\">".$row['CR_REGEREF']."</a></td>
                              <td onclick=\"ret_chq('".$row['CR_REFNO']."', '".$_GET['stname']."');\">".$row['CR_CHNO']."</a></td>
							  <td onclick=\"ret_chq('".$row['CR_REFNO']."', '".$_GET['stname']."');\">".$row['CR_date']."</a></td>
                            </tr>";
							}
							  
                    $ResponseXML .= "   </table>";
		
										
					echo $ResponseXML;
}


if ($_GET["Command"]=="pass_arr"){
	header('Content-Type: text/xml'); 
	echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
			
			$ResponseXML = "";
			$ResponseXML .= "<salesdetails>";
			
			//echo "Select * from s_cheq where CR_REFNO='".$_GET["invno"]."'";
			$sql = mysqli_query($GLOBALS['dbinv'],"Select * from s_cheq where CR_REFNO='".$_GET["invno"]."'") or die(mysqli_error($GLOBALS['dbinv']));
			if($row = mysqli_fetch_array($sql)){
				$ResponseXML .= "<lblReciptNo><![CDATA[".$row['CR_REFNO']."]]></lblReciptNo>";
				$ResponseXML .= "<txtRetChCha><![CDATA[".$row['CR_REPAY']."]]></txtRetChCha>";
				$ResponseXML .= "<DTPicker1><![CDATA[".$row['CR_DATE']."]]></DTPicker1>";
				$ResponseXML .= "<Txtcusco><![CDATA[".$row['CR_C_CODE']."]]></Txtcusco>";
				$ResponseXML .= "<cmbBankname><![CDATA[".$row['CR_BANK']."]]></cmbBankname>";
				if (is_null($row['CR_C_NAME'])==false){
					$ResponseXML .= "<txtcusname><![CDATA[".$row['CR_C_NAME']."]]></txtcusname>";
				} else {
					$ResponseXML .= "<txtcusname><![CDATA[]]></txtcusname>";	
				}	
				$ResponseXML .= "<txtremark><![CDATA[".$row['REMARK']."]]></txtremark>";
				$ResponseXML .= "<reason><![CDATA[".$row['reason']."]]></reason>";
				$ResponseXML .= "<DTPicker2><![CDATA[".$row['CR_CHDATE']."]]></DTPicker2>";
				$ResponseXML .= "<txtChequeNo><![CDATA[".$row['CR_CHNO']."]]></txtChequeNo>";
				$ResponseXML .= "<txtChequeAmount><![CDATA[".$row['CR_CHEVAL']."]]></txtChequeAmount>";
				$ResponseXML .= "<txtChequeNo><![CDATA[".$row['CR_CHNO']."]]></txtChequeNo>";
				
				if (is_null($row['DEPARTMENT'])==false){
					$ResponseXML .= "<com_dep><![CDATA[".$row['DEPARTMENT']."]]></com_dep>";
				}	
				$ResponseXML .= "<txtforwhat><![CDATA[".$row['FORwhat']."]]></txtforwhat>";
				$ResponseXML .= "<txtcrenoteno><![CDATA[".$row['crenoteno']."]]></txtcrenoteno>";
				$ResponseXML .= "<txtcrenoteamo><![CDATA[".$row['crenoteamo']."]]></txtcrenoteamo>";
				$ResponseXML .= "<dev><![CDATA[".$row['dev']."]]></dev>";
				$ResponseXML .= "<sal_ex><![CDATA[".$row['S_REF']."]]></sal_ex>";
				$ResponseXML .= "<depobank><![CDATA[".$row['depobank']."]]></depobank>";
				
				if (is_null($row["depobank"])){ 
					$com_cheq_dpo_bank = $row["depobank"]; 
      				$Txtacco = $row["DEBACC"];  
				}
				   
				$sql_INVCHEQ = mysqli_query($GLOBALS['dbinv'],"Select * from s_invcheq where cheque_no = '".trim($row['CR_CHNO'])."' and cus_code = '".trim($row['CR_C_CODE'])."'") or die(mysqli_error($GLOBALS['dbinv']));
				if($row_INVCHEQ = mysqli_fetch_array($sql_INVCHEQ)){
					if ($row_INVCHEQ["ch_count_ret"]=="1"){
						$ResponseXML .= "<Check1><![CDATA[1]]></Check1>";
					} else {
						$ResponseXML .= "<Check1><![CDATA[0]]></Check1>";
					}
				} else {
					$ResponseXML .= "<Check1><![CDATA[0]]></Check1>";
				}
				
				if (is_null($row['CR_C_NAME'])==true){
					$sql_VENDOR = mysqli_query($GLOBALS['dbinv'],"Select CODE, NAME from vendor where CODE='".trim($row['CR_C_CODE'])."'") or die(mysqli_error($GLOBALS['dbinv']));
					if($row_VENDOR = mysqli_fetch_array($sql_VENDOR)){
						$ResponseXML .= "<txtcusname><![CDATA[".$row_VENDOR['NAME']."]]></txtcusname>";
					}
				}
				
				if (is_null($row['DEPARTMENT'])==true){
					$sql_stomas = mysqli_query($GLOBALS['dbinv'],"Select CODE, DESCRIPTION from s_stomas where CODE='".$row_stomas['DESCRIPTION']."'") or die(mysqli_error($GLOBALS['dbinv']));
					if($row_stomas = mysqli_fetch_array($sql_stomas)){
						$ResponseXML .= "<com_dep><![CDATA[".$row_stomas['CODE']." - ".$row_stomas['DESCRIPTION']."]]></com_dep>";
					}
				}	
				
				if ($row["CR_FLAG"] == "0"){
       				
					$ResponseXML .= "<lab_cancel><![CDATA[]]></lab_cancel>";
				} else {
					
					$ResponseXML .= "<lab_cancel><![CDATA[Cancel]]></lab_cancel>";
					
				}	
      			
				$ResponseXML .= "<sales_table><![CDATA[ <table><tr>
                              <td width=\"100\"  background=\"images/headingbg.gif\" ><font color=\"#FFFFFF\">Inv No</font></td>
                              <td width=\"300\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Date</font></td>
                              <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Inv.Amt</font></td>
                              <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">St.Amt</font></td>
                              <td width=\"100\"  background=\"images/headingbg.gif\"><font color=\"#FFFFFF\">Pre.Ret.Qty</font></td>
							 
                            </tr>";
							
	  			$sql_rst = mysqli_query($GLOBALS['dbinv'],"Select * from ret_chq_history where Ref_no='".trim($row['CR_REFNO'])."'") or die(mysqli_error($GLOBALS['dbinv']));
				while ($row_rst = mysqli_fetch_array($sql_rst)){
					
						$ResponseXML .= "<tr><td >".$row_rst["Inv_no"]."</td>
										<td>".$row_rst['Inv_date']."</td>
										<td>".$row_rst['inv_Amt']."</td>
										<td>".$row_rst['st_amt']."</td></tr>";
				}	
				
	
				$ResponseXML .= "   </table>]]></sales_table>";
			}				
		  	
				
			
		
			
		$ResponseXML .= "</salesdetails>";	
		echo $ResponseXML; 
}	
?>
