<?php session_start();
require_once ("new/connection_sql.php");
session_start(); 
$sql = "select * from  invpara where  COMCODE='".$_SESSION['company']."' "; 
$sql = $conn->query($sql);
if (!$row1 = $sql->fetch()) {
    exit('Network Error Please Login Again......!!!');
}
if($_SESSION["CURRENT_USER"]==""){ 
exit("Invalid Login");
}
if($_SESSION["company"]==""){
exit("Invalid Login");
}


?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />


<link href="admin_min.css" rel="stylesheet" type="text/css" media="screen" />



<title>Search Customer</title>

<script language="JavaScript" src="js/inv.js"></script>
<link rel="stylesheet" href="css/table_min.css" type="text/css"/>
<style type="text/css">

	/* START CSS NEEDED ONLY IN DEMO */
	html{
		height:100%;
	}
	
	
	#mainContainer{
		width:700px;
		margin:0 auto;
		text-align:left;
		height:100%;
		background-color:#FFF;
		border-left:3px double #000;
		border-right:3px double #000;
	}
	#formContent{
		padding:5px;
	}
	/* END CSS ONLY NEEDED IN DEMO */
	
	
	/* Big box with list of options */
	#ajax_listOfOptions{
		position:absolute;	/* Never change this one */
		width:175px;	/* Width of box */
		height:250px;	/* Height of box */
		overflow:auto;	/* Scrolling features */
		border:1px solid #317082;	/* Dark green border */
		background-color:#FFF;	/* White background color */
		text-align:left;
		font-size:0.9em;
		z-index:100;
	}
	#ajax_listOfOptions div{	/* General rule for both .optionDiv and .optionDivSelected */
		margin:1px;		
		padding:1px;
		cursor:pointer;
		font-size:0.9em;
	}
	#ajax_listOfOptions .optionDiv{	/* Div for each item in list */
		
	}
	#ajax_listOfOptions .optionDivSelected{ /* Selected item in the list */
		background-color:#317082;
		color:#FFF;
	}
	#ajax_listOfOptions_iframe{
		background-color:#F00;
		position:absolute;
		z-index:5;
	}
	
	form{
		display:inline;
	}

	#article {font: 12pt Verdana, geneva, arial, sans-serif;  background: white; color: black; padding: 10pt 15pt 0 5pt}
    </style>
	

</head>

<body>

 <table width="899" border="0">
 
<tr>					
						<?php 
	  				$stname = $_GET["stname"];
					?>
                             <td width="120"  background="images/headingbg.gif" ><input type="text" size="20" name="invno" id="invno" value="" class="txtbox"  onkeyup="<?php echo "update_list('$stname')"; ?>"/></td>
                             <td width="121"  background="images/headingbg.gif" ><input type="text" size="20" name="da_no" id="da_no" value="" class="txtbox"  onkeyup="<?php echo "update_list('$stname')"; ?>"/></td>
                             <td width="446"  background="images/headingbg.gif" ><input type="hidden" size="70" name="customername" id="customername" value="" class="txtbox" onkeyup="<?php echo "update_list('$stname')"; ?>"/></td>
                             <td width="196"  background="images/headingbg.gif" ><input type="hidden" size="29" name="invdate" id="invdate" value="" class="txtbox"/></td>
   </tr>  </table>   
<div class="CSSTableGenerator" > 
                <div id="filt_table">  <table width="735" border="0" class=\"form-matrix-table\">
                            <tr>
                              <td width="100"  background="images/headingbg.gif" ><font color="#FFFFFF">Invoice No</font></td>
                              <td width="100"  background="images/headingbg.gif" ><font color="#FFFFFF">DA No</font></td>
                              <td width="424"  background="images/headingbg.gif"><font color="#FFFFFF">Customer</font></td>
                              <td width="424"  background="images/headingbg.gif"><font color="#FFFFFF">Invoice Date</font></td>
                              <td width="424"  background="images/headingbg.gif"><font color="#FFFFFF">Invoice Value</font></td>
   </tr>
                            <?php 
							
							require_once("config.inc.php");
							require_once("DBConnector.php");
							$db = new DBConnector();
                                                        
                                                        $phrase = " company = '" .$_SESSION['COMCODE']. "' and ";
                                                        $phrase1 = " company = '" .$_SESSION['COMCODE']. "' ";
							
							if ($_GET["stname"]=="crn"){
								if ($_SESSION["custno"]!=""){
									if (($_SESSION['COMCODE']=="A") or ($_SESSION['COMCODE']=="B") or ($_SESSION['COMCODE']=="R")){
										$sql="SELECT * FROM s_salma where $phrase C_CODE='".$_SESSION["custno"]."' and CANCELL='0' order by SDATE desc limit 50";
									
									} else {
										$sql="SELECT * FROM s_salma where C_CODE='".$_SESSION["custno"]."' and CANCELL='0' order by SDATE desc limit 50";
									} 	
								} else {
									if (($_SESSION['COMCODE']=="A") or ($_SESSION['COMCODE']=="B") or ($_SESSION['COMCODE']=="R")){
										$sql="SELECT * FROM s_salma where $phrase1 order by id desc limit 50";
									} else {
										$sql="SELECT * FROM s_salma where order by id desc limit 50";
									}	
								}
							} else if ($_GET["stname"]=="grn"){
								if ($_SESSION["custno"]!=""){
//									if (($_SESSION['COMCODE']=="A") or ($_SESSION['COMCODE']=="B") or ($_SESSION['COMCODE']=="R")){
										$sql="SELECT * FROM s_salma where $phrase C_CODE='".$_SESSION["custno"]."' order by id desc limit 50";
//									} else {
//										$sql="SELECT * FROM s_salma where C_CODE='".$_SESSION["custno"]."' and  order by id desc limit 50";
//									}	
								} else {
//									if (($_SESSION['COMCODE']=="A") or ($_SESSION['COMCODE']=="B") or ($_SESSION['COMCODE']=="R")){
										$sql="SELECT * FROM s_salma where $phrase1 order by id desc limit 50";
//									} else {
//										$sql="SELECT * FROM s_salma order by id desc limit 50";
//									}	
								}	
							}
                                                        else if ($_GET["stname"]=="caj"){
                                                                /*
                                                                $phrase = "and flg_caj = '0'";
								if ($_SESSION["custno"]!=""){
									if (($_SESSION['COMCODE']=="A") or ($_SESSION['COMCODE']=="B") or ($_SESSION['COMCODE']=="R")){
										$sql="SELECT * FROM s_salma where C_CODE='".$_SESSION["custno"]."' and mid(REF_NO, 1, 2)='".$_SESSION['INVC']."' $phrase order by id desc limit 50";
									} else {
										$sql="SELECT * FROM s_salma where C_CODE='".$_SESSION["custno"]."' $phrase order by id desc limit 50";
									}	
								} else {
									if (($_SESSION['COMCODE']=="A") or ($_SESSION['COMCODE']=="B") or ($_SESSION['COMCODE']=="R")){
										$sql="SELECT * FROM s_salma where mid(REF_NO, 1, 2)='".$_SESSION['INVC']."' $phrase order by id desc limit 50";
									} else {
										$sql="SELECT * FROM s_salma where flg_caj = '0' order by id desc limit 50";
									}	
								}	
                                                                */
							}else if ($_GET["stname"]=="search_grn"){
								if (($_SESSION['COMCODE']=="A") or ($_SESSION['COMCODE']=="B") or ($_SESSION['COMCODE']=="R")){
									$sql="SELECT * FROM s_crnma where $phrase1 order by id desc limit 50";	
								} else {
									$sql="SELECT * FROM s_crnma order by id desc limit 50";	
								}
							} else {	
//								if (($_SESSION['COMCODE']=="A") or ($_SESSION['COMCODE']=="B") or ($_SESSION['COMCODE']=="R")){
									$sql="SELECT * FROM s_salma where $phrase1 order by id desc limit 50";
									
//								} else {
//									$sql="SELECT * FROM s_salma order by id desc limit 50";
//								}	
							}
//							echo $sql;
							$result =$db->RunQuery($sql);
							while($row = mysql_fetch_array($result)){
							
							echo "<tr>               
                              <td onclick=\"invno('".$row['REF_NO']."', '".$_GET['stname']."');\">".$row['REF_NO']."</a></td>
							   <td onclick=\"invno('".$row['REF_NO']."', '".$_GET['stname']."');\">".$row['dele_no']."</a></td>
                              <td onclick=\"invno('".$row['REF_NO']."', '".$_GET['stname']."');\">".$row["CUS_NAME"]."</a></td>
                              <td onclick=\"invno('".$row['REF_NO']."', '".$_GET['stname']."');\">".$row['SDATE']."</a></td>
							  <td onclick=\"invno('".$row['REF_NO']."', '".$_GET['stname']."');\">".$row['GRAND_TOT']."</a></td>
                              
                            </tr>";
							}
							  ?>
                    </table>
                </div>
      </div>              

</body>
</html>
