#!/usr/local/bin/php

<?php 

	/* page title, header H1 and footer H2 labels */
	$page_title = "Retail Store Directory"; 
	
	/* used in product ad inset and meta tags */
	$page_topic = "Warts"; 
	//$page_ailment = "Warts";  
	   
	/* whether to display google ads OPTIONS: TOP, BOTTOM, BOTH, OFF */
	$google_ad = "OFF";
		
	$state_list_file = $_SERVER["DOCUMENT_ROOT"]."_shared_files/data/state_list_with_full_names.txt";
	include ($_SERVER["DOCUMENT_ROOT"]."includes/page_header.php");
?>

<!-- start content -->	

This page is a list of retail stores that sell Forces of Nature products.&nbsp; We are adding more stores so check back frequently.

<p>If a store is listed here and you find that they are not carrying Forces of Nature products, please <a href="/contact-us.htm">contact us</a>.


<?php

################# STATE GRID #########################
$states = file($state_list_file);
$counts = getStateStoreCounts(); 

echo '<p align=center>
		<table width="500" cellspacing=0 border=0 cellpadding=0 style="border-collapse: collapse; border-width: 0px 1px 0px 0px; border-color: black; border-style: solid; padding: 0px">
			<tr>';
// table of 5 columns and 10 rows
for($cols=0; $cols < 5; $cols++){
	echo '<TD>
			<table style="border-collapse: collapse; " cellspacing="0" border="0" width="100%">';
	
	for($rows=0; $rows < 10; $rows++){
		$n = $cols*10 + $rows; // which state is this ? based on row and col
		$this_state = trim($states[$n]);
		
		## SHOW LINK TO ANCHOR OR MAIL TO ##
		if ( $counts[$this_state] > 0) {
		    #$link = $_SERVER['PHP_SELF']."#$this_state";
			$link = "#$this_state";
		} else {
			$link = "mailto:info@forces-of-nature.net?subject=We want FON in $this_state!";
			$link = "http://www.forces-of-nature.net/we_want_fon.htm";
		}
		
		echo "<TR><TD style='border-width: 1px 0px 1px 1px; border-style: solid; border-color: black; padding: 7px'><A HREF='$link'>$this_state</a></TD></TR>";
	}
	
	echo "</TABLE></TD>";
}
echo "</tr></table></p>";



########################## GET STORES ##############################
$query = "select retail_store_id, city, state, store_name, store_url, store_phone, 
			store_address 
			from retail_stores
		   where approved = 'APPROVED'
		  order by state ASC, city ASC, store_name ASC";
$result = mysql_query($query);

// open first state table
echo "<style>.grid{ border: 1px solid black; width:250px; padding: 5px}</style>";
echo '<P align="center"><table width="500" cellspacing=0 border=0 style="border-collapse: collapse;">';
while($result and ($row = mysql_fetch_assoc($result)) != FALSE){
	//friendly variable names
	foreach(array_keys($row) as $key){
		${$key} = $row[$key];
	}
	
	if ($state != $last_state) {
	    echo <<<EOF
		 <tr>
		  <TD style='border:0px' width='250'>&nbsp;</td>
		  <TD style='border:0px' width='250'>&nbsp;</td>
		 </tr>
		 
		 <tr>
		  <TD style='border:0px' width='250'><h3><A NAME="$state">$state</a></h3></td>
		  <TD style='border:0px' width='250'></td>
		 </tr>
EOF;
	}
	
	$etc = "";
	if ($store_address) {
	    $etc .= "<BR>$store_address";	    
	}
	if ($store_phone) {
	    $etc .= "<BR>$store_phone";
	}
	
	echo <<<EOF
	<tr>
	  <TD class=grid>$city</td>
	  <TD class=grid>$store_name $etc</td>
	</tr>
	
EOF;
	
	

	$last_state = $state;
	
} // while fetch

// close last table
echo "</table></p>";
?>


<!-- end content -->

<?php
	include ($_SERVER["DOCUMENT_ROOT"]."includes/page_footer.php");
	
	
###############################	
function getStateStoreCounts(){
###############################
	$query = "select state, count(*) as store_count 
				from retail_stores
			   where approved = 'APPROVED'	 
			   group by state";
	$result = mysql_query($query);
	// how many stores in each state
	while($result and ($row = mysql_fetch_assoc($result)) != FALSE){
		$state = trim($row[state]);
		$store_count = $row[store_count];
		$counts[$state] = $store_count;	
	} // while
	return $counts;
}	
	
?>