
function genereMotsCles(Motsatraiter) {
	var sWhere = "" ;
	var sWhereEntre = "";

	if  (Motsatraiter != "")  {
	  if ((Motsatraiter.charAt(0)== '"') && (Motsatraiter.charAt(Motsatraiter.length-1)=='"'))
	  {
		  sWhere = "(MotsCles = %"+Motsatraiter+"%)";
	  }
	  else {
	   var tableau = Motsatraiter.split(" ");
	   for (var i = 0; i < tableau.length; i++) {
		  switch(tableau[i]) {
			  case "":
				  break;
			  case "et":
				  if (sWhere!="") {sWhereEntre = " AND "};
				  break;
			  case "ou":
				  if (sWhere!="") {sWhereEntre = " OR "};
				  break;
			  default :
				  if (sWhere!="" && sWhereEntre=="") {sWhereEntre = " AND "};
				  sWhere = sWhere + sWhereEntre + '(LibelleA =*"'+tableau[i]+'"*)';
				  sWhereEntre = "";
				  break;						
		  }
	   }
	   if (sWhere!="") { sWhere = "("+sWhere+")"};
	  }
   }
	return sWhere;
}

//old MotsCles

function RechercheTHEProduit() {



var sType = document.Recherche.ChronoTypeA.value ;
var sMarques = document.Recherche.ChronoMarqueA.value ;

var Refprod = document.forms[0].textelib2.value ;

var sWhere = "" ;



sWhere = genereMotsCles(document.Recherche.textelib.value);

if (Refprod =="") {} else {
      if (sWhere!="") {sWhere=sWhere+" AND" ; }
    sWhere=sWhere+' (RefOEMA Like "*'+Refprod+'*") ';
  }

		


if ((sType == "") || (sType=="0")) {} else {
 if (sWhere!="") {sWhere=sWhere+" AND" ; }
  sWhere= sWhere+" (ChronoTypeA="+sType+")" ;
 }

	//sMarques
	if ((sMarques == "") || (sMarques=="0")) {} else {
 if (sWhere!="") {sWhere=sWhere+" AND" ; }
  sWhere= sWhere+" (ChronoMarqueA="+sMarques+")" ;
 }

 return sWhere;
}

