var StrSearch = "";
var SPID;
var SPName = "";


function USER_ALERT()
{
	DOCLICK(-1);	     	 
}



function DOCLICK(sValue , sACT)
{

    var Str = " עליך להירשם לאתר לצורך פעולה זו, לרישום לחץ על ";
    var Str2 = " OK ";
    if (confirm(Str2 + Str))
    {
	 
      document.location.href = "Register.asp?ACT=" + sACT + "&VT=" + sValue;
     
    }
    
}



function GetRealValue(StrValue , sField)
{


    /*

    var StrTmp = "";
    StrTmp = StrValue;
    StrTmp = StrTmp.substr(0 , 3);
    return StrTmp;

    */

    var StrTmp = "";
    var StrCrt = "";
    StrTmp = StrValue;
    StrTmp = StrTmp.replace("'" , " ");
    StrTmp = StrTmp.split(" ");
    

    for(i=0;i<StrTmp.length;i++)
    {
         
         if(StrCrt == "") StrCrt = " [@L] '%" + StrTmp[i] + "%'";
	 else StrCrt += " OR " + sField + " [@L] '%" + StrTmp[i] + "%'";
    }
         


         return StrCrt;

    


}








function GetIDFromSelection(CmbObject)
{
	
	var coll = CmbObject;
	if(coll == undefined) return;
	for (i=0; i<coll.options.length; i++)
	{
	   if(coll.options(i).selected)
	   {
	      
	      return coll.options(i).value;
	      
	   }
	   
	}
	
	
	return -1;
		
}


function IsNumeric(sText)
{
	var ValidChars = "0123456789.";
	var IsNumber=true;
	var Char;

			 
	for (i = 0; i < sText.length && IsNumber == true; i++) 
	   { 
	   Char = sText.charAt(i); 
	   if (ValidChars.indexOf(Char) == -1) 
	      {
	      IsNumber = false;
	      }
	   }
	return IsNumber;
		   
}
		
		
		
function BuildExpression(IntAction)
{

   
   var RGT = document.all;
   var sPT = "" , sPrice = "" , sField = "" , sLike = "" , SSQL = "" , SPName = " [@3] ";
   var sCriteria = "";
   

   sCriteria = " [@W] ";
   
   sPT = GetIDFromSelection(document.all.ObjSelectSearch);
   if(sPT == "") return;

   var iSWITCH = parseInt(sPT);
   document.all.formSearch.txtAction.value = 3;
   
   
	
	
	switch(iSWITCH)
	{
	
	   case 10:
	        
	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין מחיר לחיפוש");
			   return;
			}
							
			if(!IsNumeric(document.getElementById("txtSearch").value))
			{
			   alert("המחיר אינו חוקי");
			   return;
			}
							
					        
			sCriteria += " Cost <= " + document.getElementById("txtSearch").value;
			
			
			SSQL = SPName + sCriteria;
			
	   break;
	   
	   case 1:

	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			sCriteria += " Artist_Name " + GetRealValue(document.getElementById("txtSearch").value , "Artist_Name");
			SSQL = SPName + sCriteria;
			
	   break;
	   
	   case 2:
	       
	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			sCriteria += " ProductType_Id =  " + sPT;
			sCriteria += " And Product_Name " + GetRealValue(document.getElementById("txtSearch").value , "Product_Name");
			SSQL = SPName + sCriteria;
			
	   break;
	   
	   case 11:
	        
	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			sCriteria += " ProductType_Id =  " + sPT;
			sCriteria += " And Product_Name " + GetRealValue(document.getElementById("txtSearch").value , "Product_Name");
			SSQL = SPName + sCriteria;
			
	   break;
	   
	   case 12:
	        
	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			sCriteria += " ProductType_Id =  " + sPT;
			sCriteria += " And Product_Name " + GetRealValue(document.getElementById("txtSearch").value , "Product_Name");
			SSQL = SPName + sCriteria;
			
	   break;
	   
	   case 13:
	        
	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			
			sCriteria += " ProductType_Id =  " + sPT;
			sCriteria += " And Product_Name " + GetRealValue(document.getElementById("txtSearch").value , "Product_Name");
			SSQL = SPName + sCriteria;
			
	   break;
	   
	   
	   case 7:
	        
	        SPName = " [@2] ";
	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			
			
			sCriteria += " TrackTitle " + GetRealValue(document.getElementById("txtSearch").value , "TrackTitle");
			SSQL = SPName + sCriteria;
			document.all.formSearch.txtAction.value = 2;
			
			
	   break;
	   
	   
	   
	   case 8:
	        
	        SPName = " [@N] ";
	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			
			sCriteria += " id = 1";
			sCriteria += " And Nbody [@L] '%" + document.getElementById("txtSearch").value + "%'";
			SSQL = SPName + sCriteria;
			document.all.formSearch.txtAction.value = 5;
			
			
	   break;
	   
	   case 9:
	        
	        SPName = " [@N] ";
	        
	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			
			sCriteria += " id = 2 ";
			sCriteria += " And Nbody [@L] '%" + document.getElementById("txtSearch").value + "%'";
			SSQL = SPName + sCriteria;
			document.all.formSearch.txtAction.value = 5;
			
			
	   break;
	   
	   default:

	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			
			sCriteria += " ProductType_Id =  " + sPT;
			sCriteria += " And Product_Name " + GetRealValue(document.getElementById("txtSearch").value , "Product_Name");
			SSQL = SPName + sCriteria;
			
	   break;
	   
	   
	
	}
   

	document.all.formSearch.txtSwitch.value = iSWITCH;
	
	

	document.all.formSearch.txtResult.value = SSQL;
	if(IntAction == 1)
	{
	   document.all.formSearch.setAttribute("ACTION" , "Result.asp" , 0);
	   document.all.formSearch.submit();
        }
	
	
	


}




     


function BuildExpressionProduct(IntAction)
{


   var RGT = document.all;
   var sPT = "" , sPrice = "" , sField = "" , sLike = "" , SSQL = "" , SPName = " [@3] ";
   var sCriteria = "";
	
   sCriteria = " [@W] ";
   
   sPT = GetIDFromSelection(document.all.ObjSelectSearch);
   if(sPT == "") return;
   
   document.all.txtSelectSearch.value = sPT;
   var iSWITCH = parseInt(sPT);
   if(document.all.txtAction != undefined) document.all.txtAction.value = 3;
   document.all.txtPAction.value = 3;
   
   
	
	
	switch(iSWITCH)
	{
	
	   case 10:
	        
	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין מחיר לחיפוש");
			   return;
			}
							
			if(!IsNumeric(document.getElementById("txtSearch").value))
			{
			   alert("המחיר אינו חוקי");
			   return;
			}
							
					        
			sCriteria += " Cost <= " + document.getElementById("txtSearch").value;
			
			
			SSQL = SPName + sCriteria;
			
	   break;
	   
	   case 1:

	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			sCriteria += " Artist_Name " + GetRealValue(document.getElementById("txtSearch").value , "Artist_Name");
			SSQL = SPName + sCriteria;
			
	   break;
	   
	   case 2:
	       
	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			sCriteria += " ProductType_Id =  " + sPT;
			sCriteria += " And Product_Name " + GetRealValue(document.getElementById("txtSearch").value , "Product_Name");
			SSQL = SPName + sCriteria;
			
	   break;
	   
	   case 11:
	        
	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			sCriteria += " ProductType_Id =  " + sPT;
			sCriteria += " And Product_Name " + GetRealValue(document.getElementById("txtSearch").value , "Product_Name");
			SSQL = SPName + sCriteria;
			
	   break;
	   
	   case 12:
	        
	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			sCriteria += " ProductType_Id =  " + sPT;
			sCriteria += " And Product_Name " + GetRealValue(document.getElementById("txtSearch").value , "Product_Name");
			SSQL = SPName + sCriteria;
			
	   break;
	   
	   case 13:
	        
	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			
			sCriteria += " ProductType_Id =  " + sPT;
			sCriteria += " And Product_Name " + GetRealValue(document.getElementById("txtSearch").value , "Product_Name");
			SSQL = SPName + sCriteria;
			
	   break;
	   
	   
	   case 7:
	        
	        SPName = " [@2] ";
	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			
			
			sCriteria += " TrackTitle " + GetRealValue(document.getElementById("txtSearch").value , "TrackTitle");
			SSQL = SPName + sCriteria;
			document.all.txtAction.value = 2;
			document.all.txtPAction.value = 2;
			
			
	   break;
	   
	   
	   
	   case 8:
	        
	        SPName = " [@N] ";
	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			
			sCriteria += " id = 1";
			sCriteria += " And Nbody [@L] '%" + document.getElementById("txtSearch").value + "%'";
			SSQL = SPName + sCriteria;
			document.all.txtAction.value = 5;
			document.all.txtPAction.value = 5;
			
			
	   break;
	   
	   case 9:
	        
	        SPName = " [@N] ";
	        
	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			
			sCriteria += " id = 2 ";
			sCriteria += " And Nbody [@L] '%" + document.getElementById("txtSearch").value + "%'";
			SSQL = SPName + sCriteria;
			document.all.txtAction.value = 5;
			document.all.txtPAction.value = 5;
			
			
	   break;

	   default:

	        if(document.getElementById("txtSearch").value == "")
			{
			   alert("נא להזין ערך לחיפוש");
			   return;
			}
							
		        
			
			sCriteria += " ProductType_Id =  " + sPT;
			sCriteria += " And Product_Name " + GetRealValue(document.getElementById("txtSearch").value , "Product_Name");
			SSQL = SPName + sCriteria;
			
	   break;
	   
	   
	
	}
   

	
	
         

        if(document.all.txtResult != undefined) document.all.txtResult.value = SSQL;
	document.all.txtPResult.value = SSQL;
	document.all.formSearch.txtSwitch.value = iSWITCH;



	
	if(IntAction == 1)
	{
	   document.all.formSearch.setAttribute("ACTION" , "ResultProduct.asp" , 0);
	   document.all.formSearch.submit();
    }
	
	
	


}


function Search(IntSearch)
{

   if(IntSearch == -999) document.location.href = "Search.asp";

}