<?php 
include 'core/init.php';
//$connect_error = 'Sorry, we\'re experiencing connection problem.  Please try again later...  Thank you!';
//mysql_connect('localhost','root','aee1024') or die ($connect_error);
//mysql_select_db('db_vts') or die($connect_error);
//error_reporting(1);
 
	//if submit/ save to databasevar  	
	if(isset($_POST['display'])){
		//$searchString = mysql_escape_string($_POST['searchString']);
		//exit();
	}
	//display from database
	if(isset($_POST['done'])){
	$done =  $_POST['done'];
	switch($done){
		case '1':
			$searchString = mysql_escape_string($_POST['filterDataString']);
			if($searchString==='NA'){
				$result = mysql_query("SELECT * FROM `vts_customers` WHERE `cust_region` !=''  ORDER BY `cust_region` ASC");
			}else{
				$result = mysql_query("SELECT * FROM `vts_customers` WHERE `cust_region` LIKE '%$searchString%'  ORDER BY `cust_region` ASC");
			}
			break;
		case '2':
			$searchString = mysql_escape_string($_POST['filterDataString']);
			$filterMunicipality = mysql_escape_string($_POST['filterMunicipality']);
			if($filterMunicipality==='Select All'){
				$result = mysql_query("SELECT * FROM `vts_customers` WHERE `cust_region` LIKE '%$searchString%' && `cust_municipality` !='' ORDER BY `cust_region`, `cust_municipality` ASC");
			}else{
				$result = mysql_query("SELECT * FROM `vts_customers` WHERE `cust_region` LIKE '%$searchString%' && `cust_municipality` LIKE '%$filterMunicipality%' ORDER BY `cust_region`, `cust_municipality` ASC");
			}
			break;
		case '3':
			$searchString = mysql_escape_string($_POST['filterDataString']);
			$filterMunicipality = mysql_escape_string($_POST['filterMunicipality']);
			$filterCity = mysql_escape_string($_POST['filterCity']);
			if($filterCity==='Select All'){
				$result = mysql_query("SELECT * FROM `vts_customers` WHERE `cust_region` LIKE '%$searchString%' && `cust_municipality` LIKE '%$filterMunicipality%' && `cust_city` !='' ORDER BY `cust_region`, `cust_municipality` ASC");
			}else{
				$result = mysql_query("SELECT * FROM `vts_customers` WHERE `cust_region` LIKE '%$searchString%' && `cust_municipality` LIKE '%$filterMunicipality%' && `cust_city` LIKE '%$filterCity%' ORDER BY `cust_region`, `cust_municipality` ASC");
			}
			break;
		case '4':
			$searchString = mysql_escape_string($_POST['filterDataString']);
			$filterBarangay = mysql_escape_string($_POST['filterBarangay']);
			$filterMunicipality = mysql_escape_string($_POST['filterMunicipality']);
			$filterCity = mysql_escape_string($_POST['filterCity']);
			if($filterBarangay==='Select All'){
				$result = mysql_query("SELECT * FROM `vts_customers` WHERE `cust_city` LIKE '%$filterCity%' && `brgy_name` !='' ORDER BY `cust_region`, `cust_municipality` ASC");
			}else{
				$result = mysql_query("SELECT * FROM `vts_customers` WHERE `cust_region` LIKE '%$searchString%' && `cust_municipality` LIKE '%$filterMunicipality%' && `cust_city` LIKE '%$filterCity%' && `brgy_name` LIKE '%$filterBarangay%' ORDER BY `cust_region`, `cust_municipality` ASC");
			}
			break;
		case '5':
			$searchTextName = mysql_escape_string($_POST['searchTextName']);
			$searchString = mysql_escape_string($_POST['filterDataString']);
			$filterBarangay = mysql_escape_string($_POST['filterBarangay']);
			$filterMunicipality = mysql_escape_string($_POST['filterMunicipality']);
			$filterCity = mysql_escape_string($_POST['filterCity']);
			if($filterBarangay==='Select All'){
				$result = mysql_query("SELECT * FROM `vts_customers` WHERE `cust_city` LIKE '%$filterCity%' && `brgy_name` !='' && `cust_fname` LIKE '%$searchTextName%' || `cust_city` LIKE '%$filterCity%' && `brgy_name` !='' && `cust_lname` LIKE '%$searchTextName%' ORDER BY `cust_lname` ASC");
			}else{
				$result = mysql_query("SELECT * FROM `vts_customers` WHERE `brgy_name` LIKE '%$filterBarangay%' && `cust_fname` LIKE '%$searchTextName%'  || `brgy_name` LIKE '%$filterBarangay%' && `cust_lname` LIKE '%$searchTextName%'ORDER BY `cust_lname` ASC");
			}
			break;
			case '6':			 
				$result = mysql_query("SELECT * FROM `vts_customers` WHERE `cust_gender`='FEMALE'  ORDER BY `cust_lname` ASC");
			break;
			case '7':			 
				$result = mysql_query("SELECT * FROM `vts_customers` WHERE `cust_gender`='MALE'  ORDER BY `cust_lname` ASC");
			break;
			case '8':			 
				$result = mysql_query("SELECT * FROM `vts_customers` WHERE `cust_gender`!=''  ORDER BY `cust_gender`, `cust_city` ASC");
			break;
		
	}
		
		if(mysql_num_rows($result) > 1){
			$textMsg = "Search Results";
		}else{
			$textMsg = "Search Result";
		}
		echo "<div class='bgColor' style='background:lightgray;vertical-align:top;height:30px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-weight:normal;font-size:14px;color:#043062'>
					&#10011; ".$textMsg." (".mysql_num_rows($result).")
						<div style='float:right;font-family:Verdana;font-size:15px;'>
						  </div>
					</div>";						 
						echo "<div style='width:100%;height:640px;border:0px solid red;overflow:auto'>";
							echo "<div style='width:2000px;height:440px;border:0px solid red'>";
							echo "<table style='width:100%;'>";
								 echo "<thead>
									<tr>
										<th>CUST. ID</th>
										<th>FIRST NAME</th>
										<th>LAST NAME</th>
										<th>M. I</th>
										<th>GENDER</th>
										<th>BIRTH DATE</th>
										<th>MOBILE</th> 
										<th>E-MAIL</th>
										<th>Facebook</th>
										<th>Tweeter</th>
										<th>InstaGram</th>
										<th>Viber</th>
										<th>Address</th>
										<th>Region</th>
										<th>Municipality</th>
										<th>City/Locality</th>
										<th>Barangay</th>
												 
									</tr>
								</thead>"; 
								while($row=mysql_fetch_array($result)){
									?><tr onclick="javascript:showCustDetails(this);" ondblclick="viewCustTable()"><?php
										echo "<td>".$row['c_id']."</td>";
										echo "<td>".$row['cust_fname']."</td>";
										echo "<td>".$row['cust_lname']."</td>";
										echo "<td>".$row['cust_middle_name']."</td>";	
										echo "<td>".$row['cust_gender']."</td>";
										echo "<td>".$row['cust_bday']."</td>";
										echo "<td>".$row['cust_mobile']."</td>";
										echo "<td>".$row['cust_email']."</td>";		
										echo "<td>".$row['cust_fb']."</td>";		
										echo "<td>".$row['cust_tweet']."</td>";		
										echo "<td>".$row['cust_InstaG']."</td>";		
										echo "<td>".$row['cust_viber']."</td>";		
										echo "<td>".$row['cust_home_add']."</td>";
										echo "<td>".$row['cust_region']."</td>";
										echo "<td>".$row['cust_municipality']."</td>";	
										echo "<td>".$row['cust_city']."</td>";
										echo "<td>".$row['brgy_name']."</td>";
										//echo "<td style='padding:5px;'>
										//<a href='#' onclick='viewCustTable()'><b style='padding:3px;border:1px solid gray;background: #defbfc;margin:2px;'>&#9998;</b></a>									 
										//</td>"; 
									 
									echo "</tr>";
								}
								echo "</table>";
							echo"</dvi>";			
						echo"</dvi>";	
				 
		exit();
	}
?>