<?
include("../../../fonran.php");
include("../../../twinner.php");

//$PHPSESSID = $_REQUEST["PHPSESSID"];
//echo "-" . $PHPSESSID;

    $PHPSESSID = isset($_REQUEST["PHPSESSID"]) ? $_REQUEST["PHPSESSID"] : $PHPSESSID ;
	if ($Submitcart == "")
	{
		if (count($part_no) != 0)
		{
			for ($i=0;$i<count($part_no);$i++)
			{    	
				if(isset($checkG)){
					$SQL1 = "SELECT * FROM Temp_Storage WHERE PHPSESSID='$PHPSESSID' and Product_SN=$Product_SN and Product_Site_Classify_SN=$Product_Site_Classify_SN";
					}
				else{
					$SQL1 = "SELECT * FROM Temp_Storage WHERE PHPSESSID='$PHPSESSID' and Product_SN=$Product_SN and Product_NO='" . $part_no[$i] . "' ";
					}
			    	
			    $RS1 = new Recordset($SQL1); 	
			    	
			    if ($RS1->EOF)
				{
						$gSQL="select MinOrd, Product_Site_Classify_SN from Product where Product_SN=$Product_SN";	
						$gRS = new Recordset($gSQL);
						$gQ=$gRS->f("MinOrd");
						if($gQ>0){
							$ggQ=$gQ;
							}
						else{
							$ggQ=1;
							}
				
				   	$Temp_Storage_SN = GetSN("Temp_Storage");
				    $PSCSN=$gRS->f("Product_Site_Classify_SN");
				    		
				   	$SQL3 = "INSERT INTO Temp_Storage (Temp_Storage_SN, Company_SN, Product_SN, Product_NO, PHPSESSID, Quantity, Comment, Product_Site_Classify_SN,Inquiry_Template) ";
				   	$SQL3.= " VALUES ('$Temp_Storage_SN','$Company_SN','$Product_SN','" . $part_no[$i] . "','$PHPSESSID','$ggQ','$Comment','$PSCSN','$Inquiry_Template')" ;	      				
				}
				else 
				{
				   	$Quantity = $RS1->Field("Quantity") + 1;
				    		
				   	$Product_SN1 = $Product_SN[$i];
				    		
				   	$SQL3 = "Update Temp_Storage set Quantity = '$Quantity', Inquiry_Template = '$Inquiry_Template' WHERE Temp_Storage_SN =" . $RS1->Field("Temp_Storage_SN");      			
				}
				    	
				ExecuteSQL($SQL3);				    	
			
			}
		}	
		elseif (count($Product_NO) != 0 and $tdc_PP=="Yes")
		{
			$gSQL="select MinOrd, Product_Site_Classify_SN from Product where Product_SN=".$Product_SN;	
			$gRS = new Recordset($gSQL);
			$gQ=$gRS->f("MinOrd");
			if($gQ>0){
				$ggQ=$gQ;
				}
			else{
				$ggQ=1;
				}
			$PSCSN=$gRS->f("Product_Site_Classify_SN");
						
			for ($i=0;$i<count($Product_NO);$i++)
			{
			
				$SQL1 = "SELECT * FROM Temp_Storage WHERE PHPSESSID='$PHPSESSID' AND Product_SN= $Product_SN and Product_NO ='".$Product_NO[$i]."'";
			    
			    $RS1 = new Recordset($SQL1); 	
			    	
			    if ($RS1->EOF)
				{
				   	$Temp_Storage_SN = GetSN("Temp_Storage");
				    		
				   	$Product_NO1 = $Product_NO[$i];
				    		
				   	$SQL3 = "INSERT INTO Temp_Storage (Temp_Storage_SN, Company_SN, Product_SN, Product_NO, PHPSESSID, Quantity, Comment, Product_Site_Classify_SN,Inquiry_Template) ";
				   	$SQL3.= " VALUES ('$Temp_Storage_SN','$Company_SN','$Product_SN','$Product_NO1','$PHPSESSID','$ggQ','$Comment','$PSCSN','$Inquiry_Template')" ;	      				
				}
				else 
				{
				   	$Quantity = $RS1->Field("Quantity") + 1;
				    				    		
				   	$SQL3 = "Update Temp_Storage set Quantity = '$Quantity', Inquiry_Template = '$Inquiry_Template' WHERE Temp_Storage_SN =" . $RS1->Field("Temp_Storage_SN");      			
				}
				    	
				ExecuteSQL($SQL3);				    	
			
			}
		}
		elseif (count($Product_SN) != 0)
		{
			for ($i=0;$i<count($Product_SN);$i++)
			{    	
				
				$SQL1 = "SELECT * FROM Temp_Storage WHERE PHPSESSID='$PHPSESSID' AND Product_SN=" . $Product_SN[$i]." and Product_NO ='$word'";
			    	
			    $RS1 = new Recordset($SQL1); 	
			    	
			    if ($RS1->EOF)
				{
						$gSQL="select MinOrd from Product where Product_SN=".$Product_SN[$i];	
						$gRS = new Recordset($gSQL);
						$gQ=$gRS->f("MinOrd");
						if($gQ>0){
							$ggQ=$gQ;
							}
						else{
							$ggQ=1;
							}
				
				   	$Temp_Storage_SN = GetSN("Temp_Storage");
				    		
				   	$Product_SN1 = $Product_SN[$i];
				    		
				   	$SQL3 = "INSERT INTO Temp_Storage (Temp_Storage_SN, Company_SN, Product_SN, Product_NO, PHPSESSID, Quantity, Comment, Product_Site_Classify_SN,Inquiry_Template) ";
				   	$SQL3.= " VALUES ('$Temp_Storage_SN','$Company_SN','$Product_SN1','$word','$PHPSESSID','$ggQ','$Comment','$Product_Site_Classify_SN','$Inquiry_Template')" ;	      				
				}
				else 
				{
				   	$Quantity = $RS1->Field("Quantity") + 1;
				    		
				   	$Product_SN1 = $Product_SN[$i];
				    		
				   	$SQL3 = "Update Temp_Storage set Quantity = '$Quantity', Inquiry_Template = '$Inquiry_Template' WHERE Temp_Storage_SN =" . $RS1->Field("Temp_Storage_SN");      			
				}
				    	
				ExecuteSQL($SQL3);				    	
			
			}
		}	
	}	
	else 
	{	
		if ($Submitcart == "Update")
		{
			for ($i=0;$i<count($PART);$i++)
		    {
			   	$SQL2 = "SELECT * FROM Temp_Storage WHERE Temp_Storage_SN=" . $PART[$i];
			    	
			   	$RS2 = new Recordset($SQL2);
			  	
			   	if ($Quantity[$i] != 0)
			   	{
					$SQL3 = "Update Temp_Storage set Quantity = " . $Quantity[$i] . "  WHERE Temp_Storage_SN =" . $PART[$i];
			   	}
			   	else 
			   	{
			   		$SQL3 = "Delete FROM Temp_Storage WHERE Temp_Storage_SN =" . $PART[$i];
			   	}

				ExecuteSQL($SQL3);
			}
		}
				
		if ($Submitcart == "Del")
		{			    
			ExecuteSQL("Delete FROM Temp_Storage WHERE Temp_Storage_SN in($SN)");		   
		}	
	}	

	$Company_Site = new Recordset("SELECT Site_SN, Company_Image_5, Company_BackGround_Color_6,Company_BackGround_Color_7 FROM Company_Site WHERE Company_SN=$Company_SN");
	$sn = session_id();
if( $Submitcart != "Update"){
				$nmsg = "";
				$max = rand(3,6);
				for($i = 0; $i < $max; $i++)
												$nmsg .= dechex(rand(0,9));
				$_SESSION['auth_image3'] = $nmsg;
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Inquiry</title>
<?
        if ($Company_SN != "" or $Company_SN != 0)
        {
                $Company = new Recordset("SELECT Site_SN, analyzer_search FROM Company LEFT JOIN Company_Site ON Company_Site.Company_SN = Company.Company_SN WHERE Company.Company_SN=$Company_SN");

                if (!$Company->EOF)
                {
?>