<?
include("include/dbconnect.php");
include("include/constants.php");
######### Admin Profile
			$cqry = "select * from ".ADMINPROFILE."";
			$cres = mysql_query($cqry)or die(db_error());
			$carr = mysql_fetch_array($cres);
			$adminid = $carr['intAdminId'];
			$com_logo = $carr['Logo'];
			
			$setqry = "select * from ".SETTINGS."";
			$setres = mysql_query($setqry)or die(db_error());
			$setarr = mysql_fetch_array($setres);
			$coupondisp = $setarr['HotTopics'];
		
	######### Get Restaurant Address
$dt=date("Y-m-d");
$page="coupon";

	$objGetResult = mysql_query("select * from ".CMS." where varMenutype='coupon'");
	$objGetRow = mysql_fetch_array($objGetResult);
	$CMSId = $objGetRow['intCMSId'];
	$heading = $objGetRow['varHeading'];
	$content = stripcslashes($objGetRow['varDetail']);
	$title=$objGetRow['varTitle'];
	
	
	############# Get Restaurant Name
	$res="select * from tb_merchant where intId = '".$_GET['resid']."'";
	$Disres=mysql_query($res) or die(mysql_error());
	$Resarr=mysql_fetch_array($Disres);
	
			$ResName	= $Resarr['varRestaurantName'];
			
			
#############Search Qry
if($_REQUEST['zipcode'] != "")
 $zipcode=$_REQUEST['zipcode'];
 $Zip=substr($zipcode,0,2);

if($_REQUEST['statename'] != "")
$state=$_REQUEST['statename'];

if($_REQUEST['cityname'] != "")
$city=$_REQUEST['cityname'];

if($_REQUEST['resname']!="")
$resname=$_REQUEST['resname'];

if($_REQUEST['cusinetype']!="")
$cusinetype=$_REQUEST['cusinetype'];


if($zipcode != "")
{  $Val="Zipcode like '$Zip%'"; }
else if($state != "" && $city == "")
{  $Val="varState = '$state'";  }
else if($state != "" && $city != "")
{  $Val="varState = '$state' and varCity = '$city'";  }
else if($resname != "" )
{  $Val="varRestaurantName = '$resname'" ;  }

else
{  }
//print $CUS_Id;
	//print $CUS_Id1=trim($CUS_Id,",");


if($zipcode != "" || $state != "" || $city != "" || $resname != "" || $cusinetype != "")
{
if($Val != "" ) {
	$zip_Qry="select * from tb_merchant where ".$Val." ";
	$SipRes=mysql_query($zip_Qry);
	$num=mysql_num_rows($SipRes);
	$i=1;
	if( $num > 0) {
		while($ZipArr=mysql_fetch_array($SipRes)) {
		$RID=$ZipArr['intId'];
		if($num == $i)
		$sep="";
		else
		$sep=",";
		$ZipId.=$RID.$sep;
		$i=$i+1;
		
		}
	}
}	
	
if($ZipId != "") {			
$ZIP_ID = " and coupon.MerchantId in ($ZipId)";
$set_val="Set";
}
else if($cusinetype != "" )
{  
	$CUS_Id="";
	$SELRES="select * from tb_restaruntinfo where intCusineId = '$cusinetype'";
	$RES_REST=mysql_query($SELRES) or die(mysql_error());
	while($ResARR=mysql_fetch_Array($RES_REST)) {
		$CUS_Id=$ResARR['MerchantId'];
		$CUS_Id.=",";
	}
	
	$CUS_Id1=trim($CUS_Id,",");
	
	if($CUS_Id1 != "") {
	$CUSINE=" and coupon.MerchantId in ($CUS_Id1)";
	$set_val="Set";
	}
	else 
	$set_val = "Null";
}
else
$set_val = "Null";
}

			
if($_GET['resid'] != "")
{
	 $pagqry="select * from tb_coupon coupon,tb_order orders  where coupon.dtStDate <= '$dt' and coupon.dtEndDate >= '$dt' and coupon.MerchantId = '".$_GET['resid']."' and coupon.CouponStatus = 'Active' and coupon.intCouponId = orders.CouponId GROUP BY coupon.MerchantId order by orders.intOrderNo asc  ";
	 $pagres="select * from tb_coupon coupon,tb_order orders  where coupon.dtStDate <= '$dt' and coupon.dtEndDate >= '$dt' and  coupon.MerchantId = '".$_GET['resid']."' and coupon.CouponStatus = 'Active' and coupon.intCouponId = orders.CouponId GROUP BY coupon.MerchantId order by orders.intOrderNo asc limit $start1, $coupon_per_page ";
	
}


else {
	if($set_val == "Set") {
		$pagqry="select * from tb_coupon coupon,tb_order orders  where coupon.dtStDate <= '$dt' and coupon.dtEndDate >= '$dt' ".$ZIP_ID.$CUSINE." and coupon.CouponStatus = 'Active' and coupon.intCouponId = orders.CouponId GROUP BY coupon.MerchantId order by orders.intOrderNo asc ";
		$pagres="select * from tb_coupon coupon,tb_order orders  where coupon.dtStDate <= '$dt' and coupon.dtEndDate >= '$dt' ".$ZIP_ID.$CUSINE." and coupon.CouponStatus = 'Active' and coupon.intCouponId = orders.CouponId GROUP BY coupon.MerchantId order by orders.intOrderNo asc limit $start1, $coupon_per_page ";
	}
	else if($set_val == "Null") {
	 $pagqry="select * from tb_coupon coupon,tb_order orders  where coupon.dtStDate <= '$dt' and coupon.dtEndDate >= '$dt'  and coupon.CouponStatus = 'InActive' and coupon.intCouponId = orders.CouponId GROUP BY coupon.MerchantId order by orders.intOrderNo asc  ";
	 $pagres="select * from tb_coupon coupon,tb_order orders  where coupon.dtStDate <= '$dt' and coupon.dtEndDate >= '$dt'  and coupon.CouponStatus = 'InActive' and coupon.intCouponId = orders.CouponId GROUP BY coupon.MerchantId order by orders.intOrderNo asc limit $start1, $coupon_per_page ";
	}
	else {
	 $pagqry="select * from tb_coupon coupon,tb_order orders  where coupon.dtStDate <= '$dt' and coupon.dtEndDate >= '$dt' and  coupon.CouponStatus = 'Active' and coupon.intCouponId = orders.CouponId GROUP BY coupon.MerchantId order by orders.intOrderNo asc  ";
	 $pagres="select * from tb_coupon coupon,tb_order orders  where coupon.dtStDate <= '$dt' and coupon.dtEndDate >= '$dt' and coupon.CouponStatus = 'Active' and coupon.intCouponId = orders.CouponId GROUP BY coupon.MerchantId order by orders.intOrderNo asc limit $start1, $coupon_per_page ";
	
	 }
  }
  
  if($zipcode != "")
	{
	  $res1=" in the Zipcode '".$zipcode."'";
	}
	else if($resname != "")
	{
	  $res1=" in the name '".$resname."'";
	}
	else if($state != "")
	{
	  foreach($statearray as $statekey => $statevalue){
	  if($statekey == $state)
	  $st=$statevalue;
	  }
	  $res1.=" in the State '".$st."'";
	  
	############### Find City 
	
	if($city != "")  {
	$cityquery1="select * from ".CITY." where intCityId ='".$city."' ";
	$cityresult1=mysql_query($cityquery1);
	$cityarr1=mysql_fetch_array($cityresult1);
	$cityname1=$cityarr1['varCityName'];	  
	$res1.=" and the city '".$cityname1."'";
	 } 
	  
	 
	}
	else if($cusinetype != ""){
		$cusineQuery1="select varCusine from ".CUSINE." where intCusineId = '".$cusinetype."' ";
		$cusineResult1=mysql_query($cusineQuery1);
		$cusineArray1 = mysql_fetch_array($cusineResult1);
		$cusine_type = $cusineArray1['varCusine'];
		$res1=" in the cuisine type '".$cusine_type."'";
  //if($val != "")
  //$res.=" and Restaurant name begins with '".$val."'";
}

  
//print $pagqry;
	$pag_res = mysql_query($pagqry);
	$total_records = mysql_num_rows($pag_res);
	$pages = ceil($total_records / $coupon_per_page);
	$CouponRes = mysql_query($pagres)or die("Error".mysql_error());
	$CouponRow = mysql_num_rows($CouponRes);	
	$total_records = mysql_num_rows($CouponRes);		
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" >
<LINK href="css/style.css" type=text/css rel=stylesheet>
<script language="javascript" src="script/fr_script.js" type="text/javascript"></script>
<title><? print $title ?></title>
<style type="text/css">
.zebra td, .zebra th {
    padding: 10px;
    border-bottom: 1px solid #f2f2f2;    
}

.zebra tbody tr:nth-child(even) {
    background: #f5f5f5;
    -webkit-box-shadow: 0 1px 0 rgba(255,255,255,.8) inset; 
    -moz-box-shadow:0 1px 0 rgba(255,255,255,.8) inset;  
    box-shadow: 0 1px 0 rgba(255,255,255,.8) inset;        
}

.zebra th {
    text-align: left;
    text-shadow: 0 1px 0 rgba(255,255,255,.5); 
    border-bottom: 1px solid #ccc;
    background-color: #eee;
    background-image: -webkit-gradient(linear, left top, left bottom, from(#f5f5f5), to(#eee));
    background-image: -webkit-linear-gradient(top, #f5f5f5, #eee);
    background-image:    -moz-linear-gradient(top, #f5f5f5, #eee);
    background-image:     -ms-linear-gradient(top, #f5f5f5, #eee);
    background-image:      -o-linear-gradient(top, #f5f5f5, #eee); 
    background-image:         linear-gradient(top, #f5f5f5, #eee);
}

.zebra th:first-child {
    -moz-border-radius: 6px 0 0 0;
    -webkit-border-radius: 6px 0 0 0;
    border-radius: 6px 0 0 0;  
}

.zebra th:last-child {
    -moz-border-radius: 0 6px 0 0;
    -webkit-border-radius: 0 6px 0 0;
    border-radius: 0 6px 0 0;
}

.zebra th:only-child{
    -moz-border-radius: 6px 6px 0 0;
    -webkit-border-radius: 6px 6px 0 0;
    border-radius: 6px 6px 0 0;
}

.zebra tfoot td {
    border-bottom: 0;
    border-top: 1px solid #fff;
    background-color: #f1f1f1;  
}

.zebra tfoot td:first-child {
    -moz-border-radius: 0 0 0 6px;
    -webkit-border-radius: 0 0 0 6px;
    border-radius: 0 0 0 6px;
}

.zebra tfoot td:last-child {
    -moz-border-radius: 0 0 6px 0;
    -webkit-border-radius: 0 0 6px 0;
    border-radius: 0 0 6px 0;
}

.zebra tfoot td:only-child{
    -moz-border-radius: 0 0 6px 6px;
    -webkit-border-radius: 0 0 6px 6px;
    border-radius: 0 0 6px 6px;
}
</style>
</head>
<body>