<!--
//////////////////////////////////////////////////////////////////////////////
// SEARCH FEATURE WRITTEN BY SÉBASTIEN MARTIN (seb@50carleton.com)			//
// ---------------------------------------------------------------			//
// Basic function:																	//
//																						//
//   This search engine takes the keywords submitted by a form and			//
//   searches the database for matches. It looks through the following		//
//   fields:																			//
//																						//
//			products.name																//
//			products.description														//
//			manufacturers.name AS man_name											//
//			manufacturers.address1													//
//			manufacturers.address2													//
//			manufacturers.address3													//
//			manufacturers.city														//
//			manufacturers.postal_code												//
//			manufacturers.province													//
//			manufacturers.country													//
//			manufacturers.phone														//
//			manufacturers.fax															//
//			manufacturers.email														//
//			manufacturers.website													//
//			product_types.product_type	->corresponds to the product's typeID	//
//																						//
//   The search is based on the user's search options ("Exact Phrase", 		//
//   "All Words", "Any Words" and Whole Word Only) which is store in the 	//
//   session variables $SearchMethod and $Wholeword.  For the whole word 	//
//   only search the script looks at the characters before and after the 	//
//   keyword found.  If both the characters are NOT letters ('a' to 'z' or	//
//   'A' to 'Z'), the item is then added to the match list.  					//
//																						//
//	Form Fields:																		//
//																						//
//   The form fields are labeled	accordingly to the session variables 		//
//   except that the first letter is lowercase.  The keywords are stored 	//
//   in a session variable named $Keywords.  The reason this script uses 	//
//   session variables is in case the results are spread out over multiple 	//
//   pages.  This avoids having to resubmit the information for every page	//
//   change and also avoids re-searching the database on every page.			//
//																						//
// Options and QueryString Variables:												//
//																						//
//   The options for the paging system implemented in this script are		//
//   stored in variables called:													//
//																						//
//			$ITEMS_PER_PAGE - Number of items per page							//
//			$ITEMS_PER_ROW -  Number of items per row								//
//																						//
//   These variables are defined just after this comment block.				//
//																						//
//   The query string variable $page is used to specify which items to		//
//   display based on which page it is on.  										//
//																						//
//			ex: search.php?page=2													//
//																						//
//   The script should always refer to the variable named $CurrentPage 		//
//   instead of $page as the variable $page may not always be set. 			//
//   $CurrentPage will always have a value based on the value of $page.  	//
//   If $page is not set, $CurrentPage is assigned the value 1 (first page)	//
//																						//
//	NOTE:																				//
//																						//
//   If the query variable $page is not specified, the script erases the 	//
//   session variables and acts like it is the user's first visit to this	//
//   page.  This is done so that users don't see their previous searches	//
//   when they return to the search page.  For this reason, this script		//
//   *ALWAYS* passes the $page value through the query string even if they	//
//   are redirecting to the first page.											//
//////////////////////////////////////////////////////////////////////////////

session_start();

// Default(s) used for the search paging system
$ITEMS_PER_PAGE = 6;
$ITEMS_PER_ROW = 3;
$CurrentPage = 1;
if(isset($page))
	$CurrentPage = $page;

$ShowTable = false;
if(!isset($page) || !$page)
{
	session_unregister("Matches");
	session_unregister("Keywords");
	session_unregister("SearchMethod");
	session_unregister("Wholeword");
	$Matches = null;
	$Keywords = null;
	$SearchMethod = null;
	$Wholeword = null;
}

if(!isset($keywords) || !$keywords)
{
	$keywords = $Keywords;
	$searchMethod = $SearchMethod;
	$wholeword = $Wholeword;
}

if($REQUEST_METHOD == "POST" && $keywords)
{
	// Unregister the array of matches from the session so that it can be modified
	session_unregister("Matches");
	session_unregister("Keywords");
	session_unregister("SearchMethod");
	session_unregister("Wholeword");

	
	// Set defaults if not set
	$ShowTable = true;
	if(!$wholeword) $wholeword = false; else $wholeword = true;
	if(!$searchMethod) $searchMethod = "all";			// possibilities: "all", "any", "exact"
	
	$Keywords = $keywords;
	$SearchMethod = $searchMethod;
	$Wholeword = $wholeword;
	session_register("Keywords", "SearchMethod", "Wholeword");
		
	// Connect to DB

   include("_includes/config.php");

	$DBlink = mssql_connect($DBserver, $DBuser, $DBpassword);
	mssql_select_db($DBname);
	
	// Query the database joining the products, manufacturers and product_types tables into one
	//$query = "SELECT * FROM products";
	$query = "SELECT distinct product_types.id from product_types inner join products on products.type_id = product_types.id inner join retailershowcase on retailershowcase.productid = products.id where retailershowcase.retailerid=$retailerID";
	
	



	$res = mssql_query(	"SELECT ".
								"products.id, ".
								"products.name, ".
								"products.thumbnailREF, ".
								"products.description, ".
								"products.collection, ".
								"manufacturers.name AS man_name, ".
								"manufacturers.address1, ".
								"manufacturers.address2, ".
								"manufacturers.address3, ".
								"manufacturers.city, ".
								"manufacturers.postal_code, ".
								"manufacturers.province, ".
								"manufacturers.country, ".
								"manufacturers.phone, ".
								"manufacturers.fax, ".
								"manufacturers.email, ".
								"manufacturers.website, ".
								"product_types.product_type ".
							"FROM products, manufacturers, product_types, retailershowcase ".
							"WHERE products.manufacturerID=manufacturers.id && products.type_id=product_types.id && retailershowcase.retailerid=$retailerID && retailershowcase.productid = products.id order by products.name", $DBlink)
		or die(mssql_error());

	if($res)
	{
		// Set things up for the search
		$NumFields = mssql_num_fields($res);
		$arKeywords = array();
		$Matches = array();
		
		// If the search method is specified as "Exact Phrase", make a single item keyword array with the entire
		// search string as the first item.  If it is specified as "All words" or "Any words", make a keyword array
		// with an item in the array for each word
		if($searchMethod != "exact")
			$arKeywords = explode(" ", $keywords);
		else
			$arKeywords[0] = $keywords;
	
		// Loop through database to find matches		
		while($row = mssql_fetch_array($res))
		{
			// Go through each column returned by the database query
			$KeywordsFound = "|";
			for($i=1; $i<$NumFields; $i++)		// Start at 1 to skip the product id field
			{
				// Search for each keyword in the keyword array arranged about 10-15 lines above
				for($j=0; $j<count($arKeywords); $j++)
				{
					if(!$wholeword) 
					{
						if(stristr($row[$i]."", $arKeywords[$j].""))
						{
							// The keyword was found in this field
							if(!stristr($KeywordsFound, $arKeywords[$j]."|"))
								$KeywordsFound .= $arKeywords[$j]."|";
						}
					}
					else {
						// The search is specified as "Whole Word Only"
						// Check the characters before and after the found keyword and check to see if they
						// are letters or not.
						$found = stristr($row[$i]."", $arKeywords[$j]."");
						while($found)
						{
							$BeforeGood = false;
							$AfterGood = false;
							
							// Check to see if it's the first word
							if(strlen($found) == strlen($row[$i]))
								$BeforeGood = true;
							else
							{
								// It's not the first word, so make sure that the character before the found keyword
								// is not a letter
								$BeginChar = substr($row[$i], strlen($row[$i])-strlen($found)-1, 1);
								$AsciiValue = ord($BeginChar);
								if(($AsciiValue < 65 || $AsciiValue > 90) && ($AsciiValue < 97 || $AsciiValue > 122))
								{
									// The beginning character is not a letter
									$BeforeGood = true;
								}
								else
									break;
							}
							
							// Check to see if it's the last word
							if(strlen($found) == strlen($arKeywords[$j]))
								$AfterGood = true;
							else
							{
								$EndChar = substr($found, strlen($arKeywords[$j]), 1);
								$AsciiValue = ord($EndChar);
								if(($AsciiValue < 65 || $AsciiValue > 90) && ($AsciiValue < 97 || $AsciiValue > 122))
								{
									// The ending character is not a letter
									$AfterGood = true;
								}
							}
							
							// If the characters before and after the found keyword are not letters,
							// add this item as a match.
							if($BeforeGood && $AfterGood)
							{
								if(!stristr($KeywordsFound, $arKeywords[$j]."|"))
									$KeywordsFound .= $arKeywords[$j]."|";
								break;
							}
							
							// Find next match
							$found = stristr(substr($found, strlen($arKeywords[$j]), strlen($found)-strlen($arKeywords[$j])), $arKeywords[$j]."");
						}
					}
				}
			}
			
			// Differentiate between the "All words" and "Any words" search method
			// Take take the appropriate course of action
			switch($searchMethod)
			{
				case "all":
				{
					// The search method is "All words", each keyword must
					// be found in order to list the item
					$numFoundKeywords=0;
					for($j=0; $j<count($arKeywords); $j++)
					{
						if(stristr($KeywordsFound, "|".$arKeywords[$j]."|"))
							$numFoundKeywords++;
					}

					if($numFoundKeywords == count($arKeywords))
					{
						$arItem = array();
						$arItem["id"] = $row["id"];
						$arItem["name"] = $row["name"];
						$arItem["thumbnailREF"] = $row["thumbnailREF"];
                  $arItem["man_name"] = $row["man_name"];
						$Matches[] = $arItem;
					}
					break;
				}
				case "any":
				case "exact":
				{
					// The search method is "Any words", at least one of the
					// keywords must have been found to list the item.
					if(strlen($KeywordsFound)>1)
					{
						$arItem = array();
						$arItem["id"] = $row["id"];
						$arItem["name"] = $row["name"];
						$arItem["thumbnailREF"] = $row["thumbnailREF"];
                  $arItem["man_name"] = $row["man_name"];
						$Matches[] = $arItem;
					}
					break;
				}
			}
		}
	}
	// Save the search results in a session variable to enable a paging system
	session_register("Matches");
	Header("Location: search_key.php?page=1");
}
-->

<html>

<head>
<title>Search Keywords</title>
<link rel="stylesheet" href="includes/fontstyles.css" type="text/css">
</head>

<body topmargin="0" leftmargin="0" marginwidth="0" marginheight="0" background="images/colourbar.gif">
<table width="98%" border="0" cellspacing="0" cellpadding="0" align="center" height="98%">
  <tr> 
    <td> 
      <div align="center"> 
        <div align="center">
          <div align="center">
            <table width="400" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td bgcolor="004E62" width="26"><img src="images/drkBlue.gif" width="26" height="10" align="top"></td>
                <td bgcolor="004E62" width="460" align="left" valign="middle" class="bodytextYellow">ADVANTAGES</td>
              </tr>
            </table>
          </div>
          <div align="left"> 
            <table width="400" border="0" cellpadding="0" cellspacing="0" align="center">
              <tr> 
                <td width="13" align="left" valign="top" bgcolor="004E62">&nbsp;</td>
                <td width="10" align="left" valign="top" bgcolor="297B90"><img src="images/corner.gif" width="10" height="10"></td>
                <td width="460" align="left" valign="top" bgcolor="297B90" class="bodytextwhite"> 
                  <p><span class="bodytextwhite2"><img src="images/ltBlue.gif" width="9" height="5"></span><br>
                    <span class="BlueTitleCopy">30 Day Price Guarantee</span><br>
                    <span class="bodytextwhite2">We will gladly refund the difference 
                    if we feature your selections at a lower price within 30 days 
                    of purchase. Plus we match our competitors documented price 
                    with the same merchandise.<br>
                    <img src="images/ltBlue.gif" width="9" height="7"><br>
                    </span><span class="BlueTitleCopy">We Guarantee what we sell</span><span class="bodytextwhite2"><br>
                    Countrywide, in conjunction with the manufacturer's warranty, 
                    guarantees your purchase from coast to coast.<br>
                    </span><span class="bodytextwhite2"><img src="images/ltBlue.gif" width="9" height="7"></span><br>
                    <span class="BlueTitleCopy">Best Selection</span><span class="bodytextwhite2"><br>
                    We display the best merchandise from the top manufacturers. 
                    Our selection offers only quality products.<br>
                    <img src="images/ltBlue.gif" width="9" height="7"><br>
                    </span><span class="BlueTitleCopy">Courteous, Personalized 
                    Service</span><span class="bodytextwhite2"><br>
                    Service is more than a promise. It's the foundation of our 
                    business - before and after you buy!<br>
                    <img src="images/ltBlue.gif" width="9" height="7"><br>
                    </span><span class="BlueTitleCopy">Custom Orders are Welcome</span><span class="bodytextwhite2"><br>
                    We offer a wide range of products available in custom order 
                    fabrics and finishes.<br>
                    <img src="images/ltBlue.gif" width="9" height="7"><br>
                    &middot;</span><span class="BlueTitleCopy">Easy, Affordable 
                    Credit</span><span class="bodytextwhite2"><br>
                    A wide variety of payment options are available for you to 
                    choose from. Apply now for your Countrywide Charge Card.<br>
                    <img src="images/ltBlue.gif" width="9" height="7"><br>
                    </span><span class="BlueTitleCopy">Friendly and Knowledgeable 
                    Staff</span><span class="bodytextwhite2"><br>
                    </span><span class="bodytextwhite2"><img src="images/ltBlue.gif" width="9" height="7"></span><br>
                    <span class="BlueTitleCopy">500 Million Dollar Buying Power</span><span class="bodytextwhite2"><br>
                    We are joined with hundreds of stores across Canada to bring 
                    our customers the advantage of our huge buying power.<br>
                    <img src="images/ltBlue.gif" width="9" height="7"><br>
                    </span><span class="BlueTitleCopy">Quick Convenient Delivery</span><span class="bodytextwhite2"><br>
                    Friendly, professional delivery.<br>
                    <img src="images/ltBlue.gif" width="9" height="7"><br>
                    </span><span class="BlueTitleCopy">Complete Satisfaction Commitment</span><span class="bodytextwhite2"><br>
                    If any product you purchase from Countrywide does not live 
                    up to your expectations, we will make it right!<br>
                    <img src="images/ltBlue.gif" width="9" height="7"> 
                    </span></p>
                  </td>
              </tr>
              <tr> 
                <td width="483" align="left" valign="bottom" bgcolor="076178" colspan="3"><img src="images/thevalue.gif" width="364" height="46" align="top" alt="The Value keeps on getting better!"></td>
              </tr>
            </table>
          </div>
      </div>
        </div>
    </td>
  </tr>
</table>
</body>

</html>