Newarby cpn

<?php

require_once('config.php');
if($_SERVER['REQUEST_METHOD'] == "POST")
{

$cur_lat       =  mysqli_real_escape_string($conn,$_POST['current_lat']);

$cur_long      =  mysqli_real_escape_string($conn,$_POST['current_long']);

// $distance    =  $_POST['distance'];

$restaurant    =  mysqli_real_escape_string($conn,$_POST['restaurant_id']);

$category      =  mysqli_real_escape_string($conn,$_POST['category_id']);

$topcpn        =  mysqli_real_escape_string($conn,$_POST['top_coupons']);

$newcpn        =  mysqli_real_escape_string($conn,$_POST['new_coupons']);

$expiringcpn   =  mysqli_real_escape_string($conn,$_POST['expiring_coupons']);

$featured_cpn  =  mysqli_real_escape_string($conn,$_POST['featured_coupons']);

$user_id       =  mysqli_real_escape_string($conn,$_POST['user_id']);

$coupon_res=array();

if(!empty($restaurant) AND empty( $category))
{
$restIdArr=explode(",",$restaurant);

$restIdStr=implode(',',$restIdArr);

$get_rest="SELECT post_id FROM wp_postmeta WHERE meta_key='offer_store' AND meta_value IN($restaurant)";

$restres=$conn->query($get_rest);

$cpncnt=mysqli_num_rows($restres);

  if($cpncnt == 0)
  {
header('HTTP/1.0 404');

    $coupon_res['msg']="There is no coupon available";

    echo json_encode($coupon_res);die;
  }
else
{


$i=0;

while($restRow=$restres->fetch_assoc())
{
  $restId=$restRow['post_id'];

   $select_coupon="SELECT ID,post_title,post_content FROM wp_posts WHERE ID='$restId' AND post_type='offer' AND post_status='publish'";
   $coupon_result = $conn->query($select_coupon);

$cpnrow = $coupon_result->fetch_assoc();

$couponId=$cpnrow["ID"];


$getRating="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='ratings_average'";
$cpnReatingqry=$conn->query($getRating);

$cpnRatingRes=$cpnReatingqry->fetch_assoc();
$couponRat=$cpnRatingRes["meta_value"];
if(!empty($couponRat))
{
$couponAvgrate=$couponRat;
}
else
{
$couponAvgrate="";
}





$couponExpired="SELECT offer_start,offer_expire FROM wp_offers WHERE post_id='$couponId' ";
$cpnexpres=$conn->query($couponExpired);

$expiredRes=$cpnexpres->fetch_assoc();

$expdate=$expiredRes["offer_expire"];

$offerStart=$expiredRes["offer_start"];

$offerStartdate=date('Y-m-d',$offerStart);

if(!empty($expdate))
{
$expiredDate=date('Y-m-d', $expdate);
}
else
{
$expiredDate='unlimited';
}

$getcpnCatId="SELECT term_id FROM wp_term_taxonomy WHERE term_taxonomy_id IN(SELECT term_taxonomy_id FROM wp_term_relationships WHERE object_id='$couponId') AND taxonomy='offer_cat'";

$cpnCatIdqry=$conn->query($getcpnCatId);

$cpncatIdRes=$cpnCatIdqry->fetch_assoc();

$cpncatid=$cpncatIdRes["term_id"];

$getcatName="SELECT term_id,name FROM wp_terms WHERE term_id='$cpncatid'";

$cpncatNameqry=$conn->query($getcatName);

$cpncatNameRes=$cpncatNameqry->fetch_assoc();

$cpncat=$cpncatNameRes["name"];
if(!empty($cpncat))
{
$cpncatName=$cpncatNameRes["name"];
}
else
{
$cpncatName="";
}
$storeId="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='offer_store'";
$storeqry=$conn->query($storeId);

$storeRes=$storeqry->fetch_assoc();
$restId=$storeRes["meta_value"];

$storeEmail="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restEmail'";
$storeEmailqry=$conn->query($storeEmail);

$storeEmailres=$storeEmailqry->fetch_assoc();

$retEmail=$storeEmailres["meta_value"];


$storePhone="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restPhone'";
$storePhoneqry=$conn->query($storePhone);

$storePhoneres=$storePhoneqry->fetch_assoc();

$retPhone=$storePhoneres["meta_value"];


$storeWeb="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='store_link'";
$storewebqry=$conn->query($storeWeb);

$storewebres=$storewebqry->fetch_assoc();

$retweb=$storewebres["meta_value"];



$get_restimage="SELECT meta_value FROM wp_postmeta WHERE post_id IN(SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='_thumbnail_id') AND meta_key='_wp_attached_file'";
$storeImgqry=$conn->query($get_restimage);
$profilepiccnt=mysqli_num_rows($storeImgqry);

if($profilepiccnt > 0)
{
$propicRow=$storeImgqry->fetch_assoc();
$profilePic=$propicRow['meta_value'];

$pictureArr=explode("/",$profilePic);

$checkpic_from=$pictureArr[0];

if($checkpic_from=='mobile_pic')
{
$key=0;

if (($key = array_search('mobile_pic', $pictureArr)) !== false)
{
unset($pictureArr[$key]);
}
$picStr=implode("/",$pictureArr);


$profilePic=$picStr;


}
else
{
$profilePic='http://192.168.1.79/restaupons/wp-content/uploads/'.$propicRow['meta_value'];
}

}

else
{
$profilePic='';
}





$couponCode="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='coupon_code'";
$ccqry=$conn->query($couponCode);

$ccRes=$ccqry->fetch_assoc();
$ccode=$ccRes["meta_value"];


$storeName="SELECT post_title FROM wp_posts WHERE ID='$restId' AND post_status='publish'";
$storenameqry=$conn->query($storeName);

$storeNameRes=$storenameqry->fetch_assoc();

$retName=$storeNameRes["post_title"];

$rating="4.7";

if($retName=='Chola')
{
$rating="1.5";
}
if($retName=='Thalapas')
{
$rating="200k";
}
if($retName=='Leemaridian')
{
$rating="2.8";
}


$coupon_res['coupons'][$i]['coupon_id']=$cpnrow["ID"];

$coupon_res['coupons'][$i]['coupon_name']=$cpnrow["post_title"];

$coupon_res['coupons'][$i]['coupon_code']=$ccode;

$coupon_res['coupons'][$i]['coupon_description']=preg_replace("/[^a-zA-Z]/", "", $cpnrow["post_content"]);

$coupon_res['coupons'][$i]['coupon_startdate']=$offerStartdate;

$coupon_res['coupons'][$i]['coupon_expireddate']=$expiredDate;

$coupon_res['coupons'][$i]['restaurant_id']=$restId;

$coupon_res['coupons'][$i]['restaurant_name']=$retName;

$coupon_res['coupons'][$i]['contact_no']=$retPhone;

$coupon_res['coupons'][$i]['email_id']=$retEmail;

$coupon_res['coupons'][$i]['website']=$retweb;

$coupon_res['coupons'][$i]['coupon_image']=$profilePic;

$coupon_res['coupons'][$i]['coupon_rating']=$couponAvgrate;

$coupon_res['coupons'][$i]['coupon_category']=$cpncatName;

$i++;

}

}

echo json_encode($coupon_res);
}





if(!empty($user_id))
{

$get_userType="SELECT meta_value FROM wp_usermeta WHERE user_id='$user_id' AND meta_key='cxxl_account_type'";

$userTyperes=$conn->query($get_userType);

$userTypeRow=$userTyperes->fetch_assoc();

$userType=$userTypeRow['meta_value'];


if($userType=='vendor')
{

$select_coupon="SELECT ID,post_title,post_content FROM wp_posts WHERE post_author='$user_id' AND post_type='offer' AND post_status='publish'";

$coupon_result = $conn->query($select_coupon);

                $numRows=mysqli_num_rows($coupon_result);

if($numRows >0)
{
$i=0;

while($cpnrow=$coupon_result->fetch_assoc())
{

$couponId=$cpnrow["ID"];

$getRating="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='ratings_average'";
$cpnReatingqry=$conn->query($getRating);

$cpnRatingRes=$cpnReatingqry->fetch_assoc();
$couponRat=$cpnRatingRes["meta_value"];
if(!empty($couponRat))
{
$couponAvgrate=$couponRat;
}
else
{
$couponAvgrate="";
}


$couponExpired="SELECT offer_start,offer_expire FROM wp_offers WHERE post_id='$couponId' ";
$cpnexpres=$conn->query($couponExpired);

$expiredRes=$cpnexpres->fetch_assoc();

$expdate=$expiredRes["offer_expire"];

$offerStart=$expiredRes["offer_start"];

$offerStartdate=date('Y-m-d',$offerStart);

if(!empty($expdate))
{
$expiredDate=date('Y-m-d', $expdate);
}
else
{
$expiredDate='unlimited';
}

$getcpnCatId="SELECT term_id FROM wp_term_taxonomy WHERE term_taxonomy_id IN(SELECT term_taxonomy_id FROM wp_term_relationships WHERE object_id='$couponId') AND taxonomy='offer_cat'";

$cpnCatIdqry=$conn->query($getcpnCatId);

$cpncatIdRes=$cpnCatIdqry->fetch_assoc();

$cpncatid=$cpncatIdRes["term_id"];

$getcatName="SELECT term_id,name FROM wp_terms WHERE term_id='$cpncatid'";

$cpncatNameqry=$conn->query($getcatName);

$cpncatNameRes=$cpncatNameqry->fetch_assoc();

$cpncat=$cpncatNameRes["name"];
if(!empty($cpncat))
{
$cpncatName=$cpncatNameRes["name"];
}
else
{
$cpncatName="";
}
$storeId="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='offer_store'";
$storeqry=$conn->query($storeId);

$storeRes=$storeqry->fetch_assoc();
$restId=$storeRes["meta_value"];

$storeEmail="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restEmail'";
$storeEmailqry=$conn->query($storeEmail);

$storeEmailres=$storeEmailqry->fetch_assoc();

$retEmail=$storeEmailres["meta_value"];


$storePhone="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restPhone'";
$storePhoneqry=$conn->query($storePhone);

$storePhoneres=$storePhoneqry->fetch_assoc();

$retPhone=$storePhoneres["meta_value"];


$storeWeb="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='store_link'";
$storewebqry=$conn->query($storeWeb);

$storewebres=$storewebqry->fetch_assoc();

$retweb=$storewebres["meta_value"];









$get_restimage="SELECT meta_value FROM wp_postmeta WHERE post_id IN(SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='_thumbnail_id') AND meta_key='_wp_attached_file'";
$storeImgqry=$conn->query($get_restimage);
$profilepiccnt=mysqli_num_rows($storeImgqry);

if($profilepiccnt > 0)
{
$propicRow=$storeImgqry->fetch_assoc();
$profilePic=$propicRow['meta_value'];

$pictureArr=explode("/",$profilePic);

$checkpic_from=$pictureArr[0];

if($checkpic_from=='mobile_pic')
{
$key=0;

if (($key = array_search('mobile_pic', $pictureArr)) !== false)
{
unset($pictureArr[$key]);
}
$picStr=implode("/",$pictureArr);


$profilePic=$picStr;


}
else
{
$profilePic='http://192.168.1.79/restaupons/wp-content/uploads/'.$propicRow['meta_value'];
}

}

else
{
$profilePic='';
}



$couponCode="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='coupon_code'";
$ccqry=$conn->query($couponCode);

$ccRes=$ccqry->fetch_assoc();
$ccode=$ccRes["meta_value"];


$storeName="SELECT post_title FROM wp_posts WHERE ID='$restId' AND post_status='publish'";
$storenameqry=$conn->query($storeName);

$storeNameRes=$storenameqry->fetch_assoc();

$retName=$storeNameRes["post_title"];

$rating="4.7";

if($retName=='Chola')
{
$rating="1.5";
}
if($retName=='Thalapas')
{
$rating="200k";
}
if($retName=='Leemaridian')
{
$rating="2.8";
}


$coupon_res['coupons'][$i]['coupon_id']=$cpnrow["ID"];

$coupon_res['coupons'][$i]['coupon_name']=$cpnrow["post_title"];

$coupon_res['coupons'][$i]['coupon_code']=$ccode;

$coupon_res['coupons'][$i]['coupon_description']=preg_replace("/[^a-zA-Z]/", "", $cpnrow["post_content"]);

$coupon_res['coupons'][$i]['coupon_startdate']=$offerStartdate;

$coupon_res['coupons'][$i]['coupon_expireddate']=$expiredDate;

$coupon_res['coupons'][$i]['restaurant_id']=$restId;

$coupon_res['coupons'][$i]['restaurant_name']=$retName;

$coupon_res['coupons'][$i]['contact_no']=$retPhone;

$coupon_res['coupons'][$i]['email_id']=$retEmail;

$coupon_res['coupons'][$i]['website']=$retweb;

$coupon_res['coupons'][$i]['coupon_image']=$profilePic;

$coupon_res['coupons'][$i]['coupon_rating']=$couponAvgrate;

$coupon_res['coupons'][$i]['coupon_category']=$cpncatName;

$i++;


}
}
else
{
header('HTTP/1.0 404');
$coupon_res['msg']="There is no coupon available";

}
echo json_encode($coupon_res);

}

else
{

$select_coupon="SELECT ID,post_title,post_content FROM wp_posts WHERE post_type='offer' AND post_status='publish'";
$coupon_result = $conn->query($select_coupon);

if ($coupon_result->num_rows > 0)
{

    // output data of each row
$i=0;

while($cpnrow = $coupon_result->fetch_assoc())
{

$couponId=$cpnrow["ID"];

$getRating="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='ratings_average'";
$cpnReatingqry=$conn->query($getRating);

$cpnRatingRes=$cpnReatingqry->fetch_assoc();
$couponRat=$cpnRatingRes["meta_value"];
if(!empty($couponRat))
{
$couponAvgrate=$couponRat;
}
else
{
$couponAvgrate="";
}


$couponExpired="SELECT offer_start,offer_expire FROM wp_offers WHERE post_id='$couponId' ";
$cpnexpres=$conn->query($couponExpired);

$expiredRes=$cpnexpres->fetch_assoc();

$expdate=$expiredRes["offer_expire"];

$offerStart=$expiredRes["offer_start"];

$offerStartdate=date('Y-m-d',$offerStart);

if(!empty($expdate))
{
$expiredDate=date('Y-m-d', $expdate);
}

else
{
$expiredDate='unlimited';
}

$getcpnCatId="SELECT term_id FROM wp_term_taxonomy WHERE term_taxonomy_id IN(SELECT term_taxonomy_id FROM wp_term_relationships WHERE object_id='$couponId') AND taxonomy='offer_cat'";

$cpnCatIdqry=$conn->query($getcpnCatId);

$cpncatIdRes=$cpnCatIdqry->fetch_assoc();

$cpncatid=$cpncatIdRes["term_id"];


$getcatName="SELECT term_id,name FROM wp_terms WHERE term_id='$cpncatid'";

$cpncatNameqry=$conn->query($getcatName);

$cpncatNameRes=$cpncatNameqry->fetch_assoc();

$cpncat=$cpncatNameRes["name"];
if(!empty($cpncat))
{
$cpncatName=$cpncatNameRes["name"];
$couuponCatId=$cpncatNameRes["term_id"];
}
else
{
$cpncatName="";
$couuponCatId="";
}
$storeId="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='offer_store'";
$storeqry=$conn->query($storeId);

$storeRes=$storeqry->fetch_assoc();
$restId=$storeRes["meta_value"];

$storeEmail="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restEmail'";
$storeEmailqry=$conn->query($storeEmail);

$storeEmailres=$storeEmailqry->fetch_assoc();

$retEmail=$storeEmailres["meta_value"];


$storePhone="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restPhone'";
$storePhoneqry=$conn->query($storePhone);

$storePhoneres=$storePhoneqry->fetch_assoc();

$retPhone=$storePhoneres["meta_value"];


$storeWeb="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='store_link'";
$storewebqry=$conn->query($storeWeb);

$storewebres=$storewebqry->fetch_assoc();

$retweb=$storewebres["meta_value"];









$get_restimage="SELECT meta_value FROM wp_postmeta WHERE post_id IN(SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='_thumbnail_id') AND meta_key='_wp_attached_file'";
$storeImgqry=$conn->query($get_restimage);
$profilepiccnt=mysqli_num_rows($storeImgqry);

if($profilepiccnt > 0)
{
$propicRow=$storeImgqry->fetch_assoc();
$profilePic=$propicRow['meta_value'];

$pictureArr=explode("/",$profilePic);

$checkpic_from=$pictureArr[0];

if($checkpic_from=='mobile_pic')
{
$key=0;

if (($key = array_search('mobile_pic', $pictureArr)) !== false)
{
unset($pictureArr[$key]);
}
$picStr=implode("/",$pictureArr);


$profilePic=$picStr;


}
else
{
$profilePic='http://192.168.1.79/restaupons/wp-content/uploads/'.$propicRow['meta_value'];
}

}

else
{
$profilePic='';
}




$couponCode="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='coupon_code'";
$ccqry=$conn->query($couponCode);

$ccRes=$ccqry->fetch_assoc();
$ccode=$ccRes["meta_value"];


$storeName="SELECT post_title FROM wp_posts WHERE ID='$restId' AND post_status='publish'";
$storenameqry=$conn->query($storeName);

$storeNameRes=$storenameqry->fetch_assoc();

$retName=$storeNameRes["post_title"];



$post_id=$cpnrow["ID"];

$get_likes="SELECT count(meta_value) AS meta_value FROM wp_postmeta WHERE post_id='$post_id' AND meta_key='offer_thumbs_up'";

$getlikeres_result = $conn->query($get_likes);

$likcount=mysqli_num_rows($getlikeres_result);

if($likcount>0)
{
$numlikesRes = $getlikeres_result->fetch_assoc();
$input=$numlikesRes['meta_value'];


$k = pow(10,3);
$mil = pow(10,6);
$bil = pow(10,9);

if ($input >= $bil)
$likes= (int) ($input / $bil).'b';
else if ($input >= $mil)
$likes=  (int) ($input / $mil).'m';
else if ($input >= $k)
$likes=  (int) ($input / $k).'k';
else
$likes=  (int) $input;

}
else
{
$num_likes='0';
}
$faveted='0';
$saved='0';
if(!empty($user_id) )
{

$get_favExist="SELECT meta_value FROM wp_usermeta WHERE user_id='$user_id' AND meta_key='simplefavorites'";

$getfav_result = $conn->query($get_favExist);

$favcount=mysqli_num_rows($getfav_result);

$fav_res=array();

$responce=array();

if($favcount >0)
{
$row = $getfav_result->fetch_assoc();

$favorites=$row["meta_value"];

$unser = unserialize($favorites);

$favrestaturantId=$unser[0]['posts'];

$fav=in_array($restId,$favrestaturantId);
if($fav=='1')
{
$faveted='1';

}
else
{
$faveted='0';
}

}

$get_savedExist="SELECT meta_value FROM wp_usermeta WHERE user_id='$user_id' AND meta_key='wpfp_favorites'";

$getsavedcpn_result = $conn->query($get_savedExist);

$savecount=mysqli_num_rows($getsavedcpn_result);

if($savecount >0)
{

$row1 = $getsavedcpn_result->fetch_assoc();

$savedcpns=$row1["meta_value"];

$unser = unserialize($savedcpns);

$couponId=$unser;

$coupon_id=$couponId;

$sav=in_array($coupon_id,$couponId);

if($sav=='1')
{
$saved='1';
}
else
{
$saved='0';

}

}
}
else
{
$faveted='0';
$saved='0';
}

$coupon_res['coupons'][$i]['coupon_id']=$cpnrow["ID"];

$coupon_res['coupons'][$i]['coupon_name']=$cpnrow["post_title"];

$coupon_res['coupons'][$i]['coupon_code']=$ccode;

$cpndecres = preg_replace("/[^a-zA-Z]/", "", $cpnrow["post_content"]);

$coupon_res['coupons'][$i]['coupon_description']=$cpndecres ;

$coupon_res['coupons'][$i]['coupon_startdate']=$offerStartdate;

$coupon_res['coupons'][$i]['coupon_expireddate']=$expiredDate;

$coupon_res['coupons'][$i]['restaurant_id']=$restId;

$coupon_res['coupons'][$i]['restaurant_name']=$retName;

$coupon_res['coupons'][$i]['is_favorite']=$faveted;

$coupon_res['coupons'][$i]['contact_no']=$retPhone;

$coupon_res['coupons'][$i]['email_id']=$retEmail;

$coupon_res['coupons'][$i]['website']=$retweb;

$coupon_res['coupons'][$i]['coupon_image']=$profilePic;

$coupon_res['coupons'][$i]['coupon_rating']=$couponAvgrate;

$coupon_res['coupons'][$i]['is_saved']=$saved;

$coupon_res['coupons'][$i]['is_liked']="0";

$coupon_res['coupons'][$i]['coupon_category']=$cpncatName;


$i++;

}

echo json_encode($coupon_res);
}



}

}






















if(!empty($category) AND empty($restaurant))
{

$select_couponId="SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN(
SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE term_id IN($category) AND taxonomy='offer_cat'
)";

$select_couponIdqry = $conn->query($select_couponId);

$i=0;

while($cpnIdrow = $select_couponIdqry->fetch_assoc())
{

$objectId=$cpnIdrow['object_id'];

$select_coupon="SELECT ID,post_title,post_content FROM wp_posts WHERE ID='$objectId' AND post_type='offer' AND post_status='publish'";
$coupon_result = $conn->query($select_coupon);

$cpnrow = $coupon_result->fetch_assoc();

$couponId=$cpnrow["ID"];

$getRating="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='ratings_average'";
$cpnReatingqry=$conn->query($getRating);

$cpnRatingRes=$cpnReatingqry->fetch_assoc();
$couponRat=$cpnRatingRes["meta_value"];
if(!empty($couponRat))
{
$couponAvgrate=$couponRat;
}
else
{
$couponAvgrate="";
}



$couponExpired="SELECT offer_start,offer_expire FROM wp_offers WHERE post_id='$objectId' ";
$cpnexpres=$conn->query($couponExpired);

$expiredRes=$cpnexpres->fetch_assoc();

$expdate=$expiredRes["offer_expire"];

$offerStart=$expiredRes["offer_start"];

$offerStartdate=date('Y-m-d',$offerStart);

if(!empty($expdate))
{
$expiredDate=date('Y-m-d', $expdate);
}
else
{
$expiredDate='unlimited';
}

$getcpnCatId="SELECT term_id FROM wp_term_taxonomy WHERE term_taxonomy_id IN(SELECT term_taxonomy_id FROM wp_term_relationships WHERE object_id='$objectId') AND taxonomy='offer_cat'";

$cpnCatIdqry=$conn->query($getcpnCatId);

$cpncatIdRes=$cpnCatIdqry->fetch_assoc();

$cpncatid=$cpncatIdRes["term_id"];

$getcatName="SELECT term_id,name FROM wp_terms WHERE term_id='$cpncatid'";

$cpncatNameqry=$conn->query($getcatName);

$cpncatNameRes=$cpncatNameqry->fetch_assoc();

$cpncat=$cpncatNameRes["name"];
if(!empty($cpncat))
{
$cpncatName=$cpncatNameRes["name"];
}
else
{
$cpncatName="";
}

$storeId="SELECT meta_value FROM wp_postmeta WHERE post_id='$objectId' AND meta_key='offer_store'";
$storeqry=$conn->query($storeId);

$storeRes=$storeqry->fetch_assoc();
$restId=$storeRes["meta_value"];

$storeEmail="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restEmail'";
$storeEmailqry=$conn->query($storeEmail);

$storeEmailres=$storeEmailqry->fetch_assoc();

$retEmail=$storeEmailres["meta_value"];


$storePhone="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restPhone'";
$storePhoneqry=$conn->query($storePhone);

$storePhoneres=$storePhoneqry->fetch_assoc();

$retPhone=$storePhoneres["meta_value"];


$storeWeb="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='store_link'";
$storewebqry=$conn->query($storeWeb);

$storewebres=$storewebqry->fetch_assoc();

$retweb=$storewebres["meta_value"];









$get_restimage="SELECT meta_value FROM wp_postmeta WHERE post_id IN(SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='_thumbnail_id') AND meta_key='_wp_attached_file'";
$storeImgqry=$conn->query($get_restimage);
$profilepiccnt=mysqli_num_rows($storeImgqry);

if($profilepiccnt > 0)
{
$propicRow=$storeImgqry->fetch_assoc();
$profilePic=$propicRow['meta_value'];

$pictureArr=explode("/",$profilePic);

$checkpic_from=$pictureArr[0];

if($checkpic_from=='mobile_pic')
{
$key=0;

if (($key = array_search('mobile_pic', $pictureArr)) !== false)
{
unset($pictureArr[$key]);
}
$picStr=implode("/",$pictureArr);


$profilePic=$picStr;


}
else
{
$profilePic='http://192.168.1.79/restaupons/wp-content/uploads/'.$propicRow['meta_value'];
}

}

else
{
$profilePic='';
}






$couponCode="SELECT meta_value FROM wp_postmeta WHERE post_id='$objectId' AND meta_key='coupon_code'";
$ccqry=$conn->query($couponCode);

$ccRes=$ccqry->fetch_assoc();
$ccode=$ccRes["meta_value"];


$storeName="SELECT post_title FROM wp_posts WHERE ID='$restId' AND post_status='publish'";
$storenameqry=$conn->query($storeName);

$storeNameRes=$storenameqry->fetch_assoc();

$retName=$storeNameRes["post_title"];

$rating="4.7";

if($retName=='Chola')
{
$rating="1.5";
}
if($retName=='Thalapas')
{
$rating="200k";
}
if($retName=='Leemaridian')
{
$rating="2.8";
}


$coupon_res['coupons'][$i]['coupon_id']=$cpnrow["ID"];

$coupon_res['coupons'][$i]['coupon_name']=$cpnrow["post_title"];

$coupon_res['coupons'][$i]['coupon_code']=$ccode;

$cpndecres = preg_replace("/[^a-zA-Z]/", "", $cpnrow["post_content"]);

$coupon_res['coupons'][$i]['coupon_description']=$cpndecres;

$coupon_res['coupons'][$i]['coupon_startdate']=$offerStartdate;

$coupon_res['coupons'][$i]['coupon_expireddate']=$expiredDate;

$coupon_res['coupons'][$i]['restaurant_id']=$restId;

$coupon_res['coupons'][$i]['restaurant_name']=$retName;

$coupon_res['coupons'][$i]['contact_no']=$retPhone;

$coupon_res['coupons'][$i]['email_id']=$retEmail;

$coupon_res['coupons'][$i]['website']=$retweb;

$coupon_res['coupons'][$i]['coupon_image']=$profilePic;

$coupon_res['coupons'][$i]['coupon_rating']=$couponAvgrate;

$coupon_res['coupons'][$i]['coupon_category']=$cpncatName;

$i++;

}
echo json_encode($coupon_res);

}

if(!empty($category) AND !empty($restaurant))
{

$restIdArr=explode(",",$restaurant);

$restIdStr=implode(',',$restIdArr);

$categoryArr=explode(",",$category);

$categoryStr=implode(',',$categoryArr);

$select_couponId="SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN(
SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE term_id IN($categoryStr) AND taxonomy='offer_cat'
)";

$select_couponIdqry = $conn->query($select_couponId);

while($categoryCpnId=$select_couponIdqry->fetch_assoc())
{

$catCpnId[]=$categoryCpnId["object_id"];

}


$get_rest="SELECT post_id FROM wp_postmeta WHERE meta_key='offer_store' AND meta_value IN($restaurant)";

$restres=$conn->query($get_rest);

$i=0;

while($restRow=$restres->fetch_assoc())
{
$restId=$restRow['post_id'];


if (in_array($restId, $catCpnId))
{


$select_coupon="SELECT ID,post_title,post_content FROM wp_posts WHERE ID='$restId' AND post_type='offer' AND post_status='publish'";
$coupon_result = $conn->query($select_coupon);

$cpnrow = $coupon_result->fetch_assoc();

$couponId=$cpnrow["ID"];

$getRating="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='ratings_average'";
$cpnReatingqry=$conn->query($getRating);

$cpnRatingRes=$cpnReatingqry->fetch_assoc();
$couponRat=$cpnRatingRes["meta_value"];
if(!empty($couponRat))
{
$couponAvgrate=$couponRat;
}
else
{
$couponAvgrate="";
}





$couponExpired="SELECT offer_start,offer_expire FROM wp_offers WHERE post_id='$couponId'";

$cpnexpres=$conn->query($couponExpired);

$expiredRes=$cpnexpres->fetch_assoc();

$expdate=$expiredRes["offer_expire"];

$offerStart=$expiredRes["offer_start"];

$offerStartdate=date('Y-m-d',$offerStart);

if(!empty($expdate))
{
$expiredDate=date('Y-m-d', $expdate);
}
else
{
$expiredDate='unlimited';
}

$getcpnCatId="SELECT term_id FROM wp_term_taxonomy WHERE term_taxonomy_id IN(SELECT term_taxonomy_id FROM wp_term_relationships WHERE object_id='$couponId') AND taxonomy='offer_cat'";

$cpnCatIdqry=$conn->query($getcpnCatId);

$cpncatIdRes=$cpnCatIdqry->fetch_assoc();

$cpncatid=$cpncatIdRes["term_id"];

$getcatName="SELECT term_id,name FROM wp_terms WHERE term_id='$cpncatid'";

$cpncatNameqry=$conn->query($getcatName);

$cpncatNameRes=$cpncatNameqry->fetch_assoc();

$cpncat=$cpncatNameRes["name"];

if(!empty($cpncat))
{
$cpncatName=$cpncatNameRes["name"];
}
else
{
$cpncatName="";
}

$storeId="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='offer_store'";
$storeqry=$conn->query($storeId);

$storeRes=$storeqry->fetch_assoc();
$restId=$storeRes["meta_value"];

$storeEmail="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restEmail'";
$storeEmailqry=$conn->query($storeEmail);

$storeEmailres=$storeEmailqry->fetch_assoc();

$retEmail=$storeEmailres["meta_value"];


$storePhone="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restPhone'";
$storePhoneqry=$conn->query($storePhone);

$storePhoneres=$storePhoneqry->fetch_assoc();

$retPhone=$storePhoneres["meta_value"];


$storeWeb="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='store_link'";
$storewebqry=$conn->query($storeWeb);

$storewebres=$storewebqry->fetch_assoc();

$retweb=$storewebres["meta_value"];









$get_restimage="SELECT meta_value FROM wp_postmeta WHERE post_id IN(SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='_thumbnail_id') AND meta_key='_wp_attached_file'";
$storeImgqry=$conn->query($get_restimage);
$profilepiccnt=mysqli_num_rows($storeImgqry);

if($profilepiccnt > 0)
{
$propicRow=$storeImgqry->fetch_assoc();
$profilePic=$propicRow['meta_value'];

$pictureArr=explode("/",$profilePic);

$checkpic_from=$pictureArr[0];

if($checkpic_from=='mobile_pic')
{
$key=0;

if (($key = array_search('mobile_pic', $pictureArr)) !== false)
{
unset($pictureArr[$key]);
}
$picStr=implode("/",$pictureArr);


$profilePic=$picStr;


}
else
{
$profilePic='http://192.168.1.79/restaupons/wp-content/uploads/'.$propicRow['meta_value'];
}

}

else
{
$profilePic='';
}







$couponCode="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='coupon_code'";
$ccqry=$conn->query($couponCode);

$ccRes=$ccqry->fetch_assoc();
$ccode=$ccRes["meta_value"];


$storeName="SELECT post_title FROM wp_posts WHERE ID='$restId' AND post_status='publish'";
$storenameqry=$conn->query($storeName);

$storeNameRes=$storenameqry->fetch_assoc();

$retName=$storeNameRes["post_title"];

$rating="4.7";

if($retName=='Chola')
{
$rating="1.5";
}
if($retName=='Thalapas')
{
$rating="200k";
}
if($retName=='Leemaridian')
{
$rating="2.8";
}

$coupon_res['coupons'][$i]['coupon_id']=$cpnrow["ID"];

$coupon_res['coupons'][$i]['coupon_name']=$cpnrow["post_title"];

$coupon_res['coupons'][$i]['coupon_code']=$ccode;

$coupon_res['coupons'][$i]['coupon_description']=preg_replace("/[^a-zA-Z]/", "", $cpnrow["post_content"]);

$coupon_res['coupons'][$i]['coupon_startdate']=$offerStartdate;

$coupon_res['coupons'][$i]['coupon_expireddate']=$expiredDate;

$coupon_res['coupons'][$i]['restaurant_id']=$restId;

$coupon_res['coupons'][$i]['restaurant_name']=$retName;

$coupon_res['coupons'][$i]['contact_no']=$retPhone;

$coupon_res['coupons'][$i]['email_id']=$retEmail;

$coupon_res['coupons'][$i]['website']=$retweb;

$coupon_res['coupons'][$i]['coupon_image']=$profilePic;

$coupon_res['coupons'][$i]['coupon_rating']=$couponAvgrate;

$coupon_res['coupons'][$i]['coupon_category']=$cpncatName;

$i++;

}
}

echo json_encode($coupon_res);


}




if(!empty($topcpn) )
{

$get_top="SELECT post_id,offer_expire,sum(offer_clicks) AS ofc FROM wp_offers
   WHERE offer_type='coupon'
   GROUP BY post_id  ORDER BY ofc DESC LIMIT 40";

$topres=$conn->query($get_top);
while($topRow=$topres->fetch_assoc())
{
$topcpnId=$topRow['post_id'];
$topcpnIdarr[]=$topcpnId;
}

$cnttopId=count($topcpnIdarr);

if($cnttopId > 0)
{

$tocpnstr=implode(",",$topcpnIdarr);
$i=0;
$select_coupon="SELECT ID,post_title,post_content FROM wp_posts WHERE ID IN($tocpnstr) AND post_type='offer' AND post_status='publish'";
$coupon_result = $conn->query($select_coupon);

while($cpnrow=$coupon_result->fetch_assoc())
{



$couponId=$cpnrow["ID"];

$getRating="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='ratings_average'";
$cpnReatingqry=$conn->query($getRating);

$cpnRatingRes=$cpnReatingqry->fetch_assoc();
$couponRat=$cpnRatingRes["meta_value"];
if(!empty($couponRat))
{
$couponAvgrate=$couponRat;
}
else
{
$couponAvgrate="";
}




$couponExpired="SELECT offer_start,offer_expire FROM wp_offers WHERE post_id='$couponId' ";
$cpnexpres=$conn->query($couponExpired);

$expiredRes=$cpnexpres->fetch_assoc();

$expdate=$expiredRes["offer_expire"];

$offerStart=$expiredRes["offer_start"];

$offerStartdate=date('Y-m-d',$offerStart);

if(!empty($expdate))
{
$expiredDate=date('Y-m-d', $expdate);
}
else
{
$expiredDate='unlimited';
}

$getcpnCatId="SELECT term_id FROM wp_term_taxonomy WHERE term_taxonomy_id IN(SELECT term_taxonomy_id FROM wp_term_relationships WHERE object_id='$couponId') AND taxonomy='offer_cat'";

$cpnCatIdqry=$conn->query($getcpnCatId);

$cpncatIdRes=$cpnCatIdqry->fetch_assoc();

$cpncatid=$cpncatIdRes["term_id"];

$getcatName="SELECT term_id,name FROM wp_terms WHERE term_id='$cpncatid'";

$cpncatNameqry=$conn->query($getcatName);

$cpncatNameRes=$cpncatNameqry->fetch_assoc();

$cpncat=$cpncatNameRes["name"];
if(!empty($cpncat))
{
$cpncatName=$cpncatNameRes["name"];
}
else
{
$cpncatName="";
}
$storeId="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='offer_store'";
$storeqry=$conn->query($storeId);

$storeRes=$storeqry->fetch_assoc();
$restId=$storeRes["meta_value"];

$storeEmail="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restEmail'";
$storeEmailqry=$conn->query($storeEmail);

$storeEmailres=$storeEmailqry->fetch_assoc();

$retEmail=$storeEmailres["meta_value"];


$storePhone="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restPhone'";
$storePhoneqry=$conn->query($storePhone);

$storePhoneres=$storePhoneqry->fetch_assoc();

$retPhone=$storePhoneres["meta_value"];


$storeWeb="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='store_link'";
$storewebqry=$conn->query($storeWeb);

$storewebres=$storewebqry->fetch_assoc();

$retweb=$storewebres["meta_value"];









$get_restimage="SELECT meta_value FROM wp_postmeta WHERE post_id IN(SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='_thumbnail_id') AND meta_key='_wp_attached_file'";
$storeImgqry=$conn->query($get_restimage);
$profilepiccnt=mysqli_num_rows($storeImgqry);

if($profilepiccnt > 0)
{
$propicRow=$storeImgqry->fetch_assoc();
$profilePic=$propicRow['meta_value'];

$pictureArr=explode("/",$profilePic);

$checkpic_from=$pictureArr[0];

if($checkpic_from=='mobile_pic')
{
$key=0;

if (($key = array_search('mobile_pic', $pictureArr)) !== false)
{
unset($pictureArr[$key]);
}
$picStr=implode("/",$pictureArr);


$profilePic=$picStr;


}
else
{
$profilePic='http://192.168.1.79/restaupons/wp-content/uploads/'.$propicRow['meta_value'];
}

}

else
{
$profilePic='';
}



$couponCode="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='coupon_code'";
$ccqry=$conn->query($couponCode);

$ccRes=$ccqry->fetch_assoc();
$ccode=$ccRes["meta_value"];


$storeName="SELECT post_title FROM wp_posts WHERE ID='$restId' AND post_status='publish'";
$storenameqry=$conn->query($storeName);

$storeNameRes=$storenameqry->fetch_assoc();

$retName=$storeNameRes["post_title"];

$rating="4.7";

if($retName=='Chola')
{
$rating="1.5";
}
if($retName=='Thalapas')
{
$rating="200k";
}
if($retName=='Leemaridian')
{
$rating="2.8";
}


$coupon_res['coupons'][$i]['coupon_id']=$cpnrow["ID"];

$coupon_res['coupons'][$i]['coupon_name']=$cpnrow["post_title"];

$coupon_res['coupons'][$i]['coupon_code']=$ccode;

$coupon_res['coupons'][$i]['coupon_description']=preg_replace("/[^a-zA-Z]/", "", $cpnrow["post_content"]);

$coupon_res['coupons'][$i]['coupon_startdate']=$offerStartdate;

$coupon_res['coupons'][$i]['coupon_expireddate']=$expiredDate;

$coupon_res['coupons'][$i]['restaurant_id']=$restId;

$coupon_res['coupons'][$i]['restaurant_name']=$retName;

$coupon_res['coupons'][$i]['contact_no']=$retPhone;

$coupon_res['coupons'][$i]['email_id']=$retEmail;

$coupon_res['coupons'][$i]['website']=$retweb;

$coupon_res['coupons'][$i]['coupon_image']=$profilePic;

$coupon_res['coupons'][$i]['coupon_rating']=$couponAvgrate;

$coupon_res['coupons'][$i]['coupon_category']=$cpncatName;

$i++;


}
echo json_encode($coupon_res);
}
else
{
header('HTTP/1.0 404');
$coupon_res['msg']="there is no coupon available";
echo $coupon_res;

}
}




if(!empty($featured_cpn))
{

$get_feturedrest="SELECT ID FROM wp_posts WHERE post_type='store' AND post_status='publish' AND post_author IN(SELECT user_id FROM wp_usermeta WHERE meta_key='packageId' AND meta_value='4')";

$featuredrestres=$conn->query($get_feturedrest);
$restIdArr=array();
while($featrestRow=$featuredrestres->fetch_assoc())
{
$restid=$featrestRow['ID'];

$restIdArr[]=$restid;
}


$restIdStr=implode(',',$restIdArr);

$cntfeatId=count($restIdArr);

if($cntfeatId > 0)
{
$get_rest="SELECT post_id FROM wp_postmeta WHERE meta_key='offer_store' AND meta_value IN($restIdStr)";

$restres=$conn->query($get_rest);

$i=0;

while($restRow=$restres->fetch_assoc())
{
$restId=$restRow['post_id'];

$select_coupon="SELECT ID,post_title,post_content FROM wp_posts WHERE ID='$restId' AND post_type='offer' AND post_status='publish'";
$coupon_result = $conn->query($select_coupon);
$cpnrow = $coupon_result->fetch_assoc();

$couponId=$cpnrow["ID"];

$getRating="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='ratings_average'";
$cpnReatingqry=$conn->query($getRating);

$cpnRatingRes=$cpnReatingqry->fetch_assoc();
$couponRat=$cpnRatingRes["meta_value"];
if(!empty($couponRat))
{
$couponAvgrate=$couponRat;
}
else
{
$couponAvgrate="";
}










$couponExpired="SELECT offer_start,offer_expire FROM wp_offers WHERE post_id='$couponId' ";
$cpnexpres=$conn->query($couponExpired);

$expiredRes=$cpnexpres->fetch_assoc();

$expdate=$expiredRes["offer_expire"];

$offerStart=$expiredRes["offer_start"];

$offerStartdate=date('Y-m-d',$offerStart);

if(!empty($expdate))
{
$expiredDate=date('Y-m-d', $expdate);
}
else
{
$expiredDate='unlimited';
}

$getcpnCatId="SELECT term_id FROM wp_term_taxonomy WHERE term_taxonomy_id IN(SELECT term_taxonomy_id FROM wp_term_relationships WHERE object_id='$couponId') AND taxonomy='offer_cat'";

$cpnCatIdqry=$conn->query($getcpnCatId);

$cpncatIdRes=$cpnCatIdqry->fetch_assoc();

$cpncatid=$cpncatIdRes["term_id"];

$getcatName="SELECT term_id,name FROM wp_terms WHERE term_id='$cpncatid'";

$cpncatNameqry=$conn->query($getcatName);

$cpncatNameRes=$cpncatNameqry->fetch_assoc();

$cpncat=$cpncatNameRes["name"];
if(!empty($cpncat))
{
$cpncatName=$cpncatNameRes["name"];
}
else
{
$cpncatName="";
}

$storeId="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='offer_store'";
$storeqry=$conn->query($storeId);

$storeRes=$storeqry->fetch_assoc();
$restId=$storeRes["meta_value"];

$storeEmail="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restEmail'";
$storeEmailqry=$conn->query($storeEmail);

$storeEmailres=$storeEmailqry->fetch_assoc();

$retEmail=$storeEmailres["meta_value"];


$storePhone="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restPhone'";
$storePhoneqry=$conn->query($storePhone);

$storePhoneres=$storePhoneqry->fetch_assoc();

$retPhone=$storePhoneres["meta_value"];


$storeWeb="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='store_link'";
$storewebqry=$conn->query($storeWeb);

$storewebres=$storewebqry->fetch_assoc();

$retweb=$storewebres["meta_value"];









$get_restimage="SELECT meta_value FROM wp_postmeta WHERE post_id IN(SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='_thumbnail_id') AND meta_key='_wp_attached_file'";
$storeImgqry=$conn->query($get_restimage);
$profilepiccnt=mysqli_num_rows($storeImgqry);

if($profilepiccnt > 0)
{
$propicRow=$storeImgqry->fetch_assoc();
$profilePic=$propicRow['meta_value'];

$pictureArr=explode("/",$profilePic);

$checkpic_from=$pictureArr[0];

if($checkpic_from=='mobile_pic')
{
$key=0;

if (($key = array_search('mobile_pic', $pictureArr)) !== false)
{
unset($pictureArr[$key]);
}
$picStr=implode("/",$pictureArr);


$profilePic=$picStr;


}
else
{
$profilePic='http://192.168.1.79/restaupons/wp-content/uploads/'.$propicRow['meta_value'];
}

}

else
{
$profilePic='';
}






$couponCode="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='coupon_code'";
$ccqry=$conn->query($couponCode);

$ccRes=$ccqry->fetch_assoc();
$ccode=$ccRes["meta_value"];

$storeName="SELECT post_title FROM wp_posts WHERE ID='$restId' AND post_status='publish'";
$storenameqry=$conn->query($storeName);

$storeNameRes=$storenameqry->fetch_assoc();

$retName=$storeNameRes["post_title"];

$rating="4.7";

if($retName=='Chola')
{
$rating="1.5";
}
if($retName=='Thalapas')
{
$rating="200k";
}
if($retName=='Leemaridian')
{
$rating="2.8";
}


$coupon_res['coupons'][$i]['coupon_id']=$cpnrow["ID"];

$coupon_res['coupons'][$i]['coupon_name']=$cpnrow["post_title"];

$coupon_res['coupons'][$i]['coupon_code']=$ccode;

$coupon_res['coupons'][$i]['coupon_description']=preg_replace("/[^a-zA-Z]/", "", $cpnrow["post_content"]);

$coupon_res['coupons'][$i]['coupon_startdate']=$offerStartdate;

$coupon_res['coupons'][$i]['coupon_expireddate']=$expiredDate;

$coupon_res['coupons'][$i]['restaurant_id']=$restId;

$coupon_res['coupons'][$i]['restaurant_name']=$retName;

$coupon_res['coupons'][$i]['contact_no']=$retPhone;

$coupon_res['coupons'][$i]['email_id']=$retEmail;

$coupon_res['coupons'][$i]['website']=$retweb;

$coupon_res['coupons'][$i]['coupon_image']=$profilePic;

$coupon_res['coupons'][$i]['coupon_rating']=$couponAvgrate;

$coupon_res['coupons'][$i]['coupon_category']=$cpncatName;

$i++;

}
}
else
{
header('HTTP/1.0 404');
$coupon_res['msg']="there is no coupon available";
}

echo json_encode($coupon_res);
}












if(!empty($newcpn))
{
$get_exp_cpnId="SELECT post_id FROM wp_offers ORDER BY offer_start DESC";
$expcoupon_qry = $conn->query($get_exp_cpnId);

$expcouponIdsarr=array();

while($expcpnrow = $expcoupon_qry->fetch_assoc())
{
$expcouponIdsarr[]=$expcpnrow["post_id"];
}

$expcouponIdsStr=implode(",",$expcouponIdsarr);

$select_coupon="SELECT ID,post_title,post_content FROM wp_posts WHERE post_type='offer' AND post_status='publish'
AND ID IN($expcouponIdsStr)";

$coupon_result = $conn->query($select_coupon);

if ($coupon_result->num_rows > 0)
{

// output data of each row

while($cpnrow = $coupon_result->fetch_assoc())
{

$couponIds=$cpnrow["ID"];
$couponIdarr[]=$couponIds;

}

$cpnIdstr=implode(",",$couponIdarr);
$expcoupon="SELECT post_id,offer_start,DATE( FROM_UNIXTIME( offer_start ) ) AS stdt,DATE( FROM_UNIXTIME(offer_expire)) AS ofExp FROM wp_offers WHERE post_id IN($cpnIdstr) ORDER BY stdt DESC";
$cpnexpresult=$conn->query($expcoupon);
$i=0;
while($expiredCpnidRes=$cpnexpresult->fetch_assoc())
{

$couponId=$expiredCpnidRes["post_id"];

$select_coupon1="SELECT ID,post_title,post_content FROM wp_posts WHERE post_type='offer' AND post_status='publish'
AND ID IN($couponId)";

$coupon_result1 = $conn->query($select_coupon1);
$cpnrow1 = $coupon_result1->fetch_assoc();


$expdate=$expiredCpnidRes["ofExp"];

$offerStartdate=$expiredCpnidRes["stdt"];

$getRating="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='ratings_average'";
$cpnReatingqry=$conn->query($getRating);

$cpnRatingRes=$cpnReatingqry->fetch_assoc();
$couponRat=$cpnRatingRes["meta_value"];
if(!empty($couponRat))
{
$couponAvgrate=$couponRat;
}
else
{
$couponAvgrate="";
}



if(!empty($expdate))
{
$expiredDate=$expdate;
}
else
{
$expiredDate='unlimited';
}

$getcpnCatId="SELECT term_id FROM wp_term_taxonomy WHERE term_taxonomy_id IN(SELECT term_taxonomy_id FROM wp_term_relationships WHERE object_id='$couponId') AND taxonomy='offer_cat'";

$cpnCatIdqry=$conn->query($getcpnCatId);

$cpncatIdRes=$cpnCatIdqry->fetch_assoc();

$cpncatid=$cpncatIdRes["term_id"];


$getcatName="SELECT term_id,name FROM wp_terms WHERE term_id='$cpncatid'";

$cpncatNameqry=$conn->query($getcatName);

$cpncatNameRes=$cpncatNameqry->fetch_assoc();

$cpncat=$cpncatNameRes["name"];
if(!empty($cpncat))
{
$cpncatName=$cpncatNameRes["name"];
}
else
{
$cpncatName="";
}
$storeId="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='offer_store'";
$storeqry=$conn->query($storeId);

$storeRes=$storeqry->fetch_assoc();
$restId=$storeRes["meta_value"];


$storeEmail="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restEmail'";
$storeEmailqry=$conn->query($storeEmail);

$storeEmailres=$storeEmailqry->fetch_assoc();

$retEmail=$storeEmailres["meta_value"];


$storePhone="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restPhone'";
$storePhoneqry=$conn->query($storePhone);

$storePhoneres=$storePhoneqry->fetch_assoc();

$retPhone=$storePhoneres["meta_value"];


$storeWeb="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='store_link'";
$storewebqry=$conn->query($storeWeb);

$storewebres=$storewebqry->fetch_assoc();

$retweb=$storewebres["meta_value"];









$get_restimage="SELECT meta_value FROM wp_postmeta WHERE post_id IN(SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='_thumbnail_id') AND meta_key='_wp_attached_file'";
$storeImgqry=$conn->query($get_restimage);
$profilepiccnt=mysqli_num_rows($storeImgqry);

if($profilepiccnt > 0)
{
$propicRow=$storeImgqry->fetch_assoc();
$profilePic=$propicRow['meta_value'];

$pictureArr=explode("/",$profilePic);

$checkpic_from=$pictureArr[0];

if($checkpic_from=='mobile_pic')
{
$key=0;

if (($key = array_search('mobile_pic', $pictureArr)) !== false)
{
unset($pictureArr[$key]);
}
$picStr=implode("/",$pictureArr);


$profilePic=$picStr;


}
else
{
$profilePic='http://192.168.1.79/restaupons/wp-content/uploads/'.$propicRow['meta_value'];
}

}

else
{
$profilePic='';
}






$couponCode="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='coupon_code'";
$ccqry=$conn->query($couponCode);

$ccRes=$ccqry->fetch_assoc();
$ccode=$ccRes["meta_value"];


$storeName="SELECT post_title FROM wp_posts WHERE ID='$restId' AND post_status='publish'";
$storenameqry=$conn->query($storeName);

$storeNameRes=$storenameqry->fetch_assoc();

$retName=$storeNameRes["post_title"];



$post_id=$cpnrow1["ID"];

$get_likes="SELECT count(meta_value) AS meta_value FROM wp_postmeta WHERE post_id='$post_id' AND meta_key='offer_thumbs_up'";

$getlikeres_result = $conn->query($get_likes);

$likcount=mysqli_num_rows($getlikeres_result);

if($likcount>0)
{
$numlikesRes = $getlikeres_result->fetch_assoc();
$input=$numlikesRes['meta_value'];


$k = pow(10,3);
$mil = pow(10,6);
$bil = pow(10,9);

if ($input >= $bil)
$likes= (int) ($input / $bil).'b';
else if ($input >= $mil)
$likes=  (int) ($input / $mil).'m';
else if ($input >= $k)
$likes=  (int) ($input / $k).'k';
else
$likes=  (int) $input;

}
else
{
$num_likes='0';
}
$faveted='0';
$saved='0';
if(!empty($user_id) )
{

$get_favExist="SELECT meta_value FROM wp_usermeta WHERE user_id='$user_id' AND meta_key='simplefavorites'";

$getfav_result = $conn->query($get_favExist);

$favcount=mysqli_num_rows($getfav_result);

$fav_res=array();

$responce=array();

if($favcount >0)
{
$row = $getfav_result->fetch_assoc();

$favorites=$row["meta_value"];

$unser = unserialize($favorites);

$favrestaturantId=$unser[0]['posts'];

$fav=in_array($restId,$favrestaturantId);
if($fav=='1')
{
$faveted='1';

}
else
{
$faveted='0';
}

}

$get_savedExist="SELECT meta_value FROM wp_usermeta WHERE user_id='$user_id' AND meta_key='wpfp_favorites'";

$getsavedcpn_result = $conn->query($get_savedExist);

$savecount=mysqli_num_rows($getsavedcpn_result);

if($savecount >0)
{

$row1 = $getsavedcpn_result->fetch_assoc();

$savedcpns=$row1["meta_value"];
$unser = unserialize($savedcpns);
$couponId=$unser;

$coupon_id=$couponId;

$sav=in_array($coupon_id,$couponId);

if($sav=='1')
{
$saved='1';
}
else
{
$saved='0';

}

}
}
else
{
$faveted='0';
$saved='0';
}

$coupon_res['coupons'][$i]['coupon_id']=$cpnrow1["ID"];

$coupon_res['coupons'][$i]['coupon_name']=$cpnrow1["post_title"];

$coupon_res['coupons'][$i]['coupon_code']=$ccode;

$cpndecres = preg_replace("/[^a-zA-Z]/", "", $cpnrow1["post_content"]);

$coupon_res['coupons'][$i]['coupon_description']=$cpndecres ;

$coupon_res['coupons'][$i]['coupon_startdate']=$offerStartdate;

$coupon_res['coupons'][$i]['coupon_expireddate']=$expiredDate;

$coupon_res['coupons'][$i]['restaurant_id']=$restId;

$coupon_res['coupons'][$i]['restaurant_name']=$retName;

$coupon_res['coupons'][$i]['is_favorite']=$faveted;

$coupon_res['coupons'][$i]['contact_no']=$retPhone;

$coupon_res['coupons'][$i]['email_id']=$retEmail;

$coupon_res['coupons'][$i]['website']=$retweb;

$coupon_res['coupons'][$i]['coupon_image']=$profilePic;

$coupon_res['coupons'][$i]['coupon_rating']=$couponAvgrate;

$coupon_res['coupons'][$i]['is_saved']=$saved;

$coupon_res['coupons'][$i]['is_liked']="0";

$coupon_res['coupons'][$i]['coupon_category']=$cpncatName;

$i++;

}

echo json_encode($coupon_res);
}
  else
{
header('HTTP/1.0 404');
$coupon_res['msg']="There is no coupon available";
echo json_encode($coupon_res);

}

}


if(!empty($expiringcpn) )
{

$get_exp_cpnId="SELECT post_id FROM wp_offers ORDER BY offer_expire DESC";
$expcoupon_qry = $conn->query($get_exp_cpnId);

$expcouponIdsarr=array();

while($expcpnrow = $expcoupon_qry->fetch_assoc())
{
$expcouponIdsarr[]=$expcpnrow["post_id"];
}

$expcouponIdsStr=implode(",",$expcouponIdsarr);

$select_coupon="SELECT ID,post_title,post_content FROM wp_posts WHERE post_type='offer' AND post_status='publish'
AND ID IN($expcouponIdsStr)";

$coupon_result = $conn->query($select_coupon);

if ($coupon_result->num_rows > 0)
{

// output data of each row

while($cpnrow = $coupon_result->fetch_assoc())
{

$couponIds=$cpnrow["ID"];
$couponIdarr[]=$couponIds;

}

$cpnIdstr=implode(",",$couponIdarr);
$expcoupon="SELECT post_id,offer_start,DATE( FROM_UNIXTIME( offer_start ) ) AS stdt,DATE( FROM_UNIXTIME(offer_expire)) AS ofExp FROM wp_offers WHERE post_id IN($cpnIdstr) ORDER BY ofExp ASC";
$cpnexpresult=$conn->query($expcoupon);
$i=0;
while($expiredCpnidRes=$cpnexpresult->fetch_assoc())
{

$couponId=$expiredCpnidRes["post_id"];

$select_coupon1="SELECT ID,post_title,post_content FROM wp_posts WHERE post_type='offer' AND post_status='publish'
AND ID IN($couponId)";

$coupon_result1 = $conn->query($select_coupon1);
$cpnrow1 = $coupon_result1->fetch_assoc();
// $couponExpired="SELECT offer_start,DATE( FROM_UNIXTIME( offer_start ) ) AS stdt,DATE( FROM_UNIXTIME(offer_expire)) AS offer_expire FROM wp_offers WHERE post_id='$couponId' ORDER BY offer_expire ASC";
// $cpnexpres=$conn->query($couponExpired);
// $expiredRes=$cpnexpres->fetch_assoc();

$expdate=$expiredCpnidRes["ofExp"];

$offerStartdate=$expiredCpnidRes["stdt"];

$getRating="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='ratings_average'";
$cpnReatingqry=$conn->query($getRating);

$cpnRatingRes=$cpnReatingqry->fetch_assoc();
$couponRat=$cpnRatingRes["meta_value"];
if(!empty($couponRat))
{
$couponAvgrate=$couponRat;
}
else
{
$couponAvgrate="";
}

if(!empty($expdate))
{
$expiredDate=$expdate;
}
else
{
$expiredDate='unlimited';
}

$getcpnCatId="SELECT term_id FROM wp_term_taxonomy WHERE term_taxonomy_id IN(SELECT term_taxonomy_id FROM wp_term_relationships WHERE object_id='$couponId') AND taxonomy='offer_cat'";

$cpnCatIdqry=$conn->query($getcpnCatId);

$cpncatIdRes=$cpnCatIdqry->fetch_assoc();

$cpncatid=$cpncatIdRes["term_id"];


$getcatName="SELECT term_id,name FROM wp_terms WHERE term_id='$cpncatid'";

$cpncatNameqry=$conn->query($getcatName);

$cpncatNameRes=$cpncatNameqry->fetch_assoc();

$cpncat=$cpncatNameRes["name"];
if(!empty($cpncat))
{
$cpncatName=$cpncatNameRes["name"];
}
else
{
$cpncatName="";
}
$storeId="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='offer_store'";
$storeqry=$conn->query($storeId);

$storeRes=$storeqry->fetch_assoc();
$restId=$storeRes["meta_value"];



  $storeEmail="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restEmail'";
$storeEmailqry=$conn->query($storeEmail);

$storeEmailres=$storeEmailqry->fetch_assoc();

$retEmail=$storeEmailres["meta_value"];


$storePhone="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restPhone'";
$storePhoneqry=$conn->query($storePhone);

$storePhoneres=$storePhoneqry->fetch_assoc();

$retPhone=$storePhoneres["meta_value"];


$storeWeb="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='store_link'";
$storewebqry=$conn->query($storeWeb);

$storewebres=$storewebqry->fetch_assoc();

$retweb=$storewebres["meta_value"];

$get_restimage="SELECT meta_value FROM wp_postmeta WHERE post_id IN(SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='_thumbnail_id') AND meta_key='_wp_attached_file'";
$storeImgqry=$conn->query($get_restimage);
$profilepiccnt=mysqli_num_rows($storeImgqry);

if($profilepiccnt > 0)
{
$propicRow=$storeImgqry->fetch_assoc();
$profilePic=$propicRow['meta_value'];

$pictureArr=explode("/",$profilePic);

$checkpic_from=$pictureArr[0];

if($checkpic_from=='mobile_pic')
{
$key=0;

if (($key = array_search('mobile_pic', $pictureArr)) !== false)
{
unset($pictureArr[$key]);
}
$picStr=implode("/",$pictureArr);


$profilePic=$picStr;


}
else
{
$profilePic='http://192.168.1.79/restaupons/wp-content/uploads/'.$propicRow['meta_value'];
}

}

else
{
$profilePic='';
}

$couponCode="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='coupon_code'";
$ccqry=$conn->query($couponCode);

$ccRes=$ccqry->fetch_assoc();
$ccode=$ccRes["meta_value"];


$storeName="SELECT post_title FROM wp_posts WHERE ID='$restId' AND post_status='publish'";
$storenameqry=$conn->query($storeName);

$storeNameRes=$storenameqry->fetch_assoc();

$retName=$storeNameRes["post_title"];



$post_id=$cpnrow1["ID"];

$get_likes="SELECT count(meta_value) AS meta_value FROM wp_postmeta WHERE post_id='$post_id' AND meta_key='offer_thumbs_up'";

$getlikeres_result = $conn->query($get_likes);

$likcount=mysqli_num_rows($getlikeres_result);

if($likcount>0)
{
$numlikesRes = $getlikeres_result->fetch_assoc();
$input=$numlikesRes['meta_value'];


$k = pow(10,3);
$mil = pow(10,6);
$bil = pow(10,9);

if ($input >= $bil)
$likes= (int) ($input / $bil).'b';
else if ($input >= $mil)
$likes=  (int) ($input / $mil).'m';
else if ($input >= $k)
$likes=  (int) ($input / $k).'k';
else
$likes=  (int) $input;

}
else
{
$num_likes='0';
}
$faveted='0';
$saved='0';
if(!empty($user_id) )
{

$get_favExist="SELECT meta_value FROM wp_usermeta WHERE user_id='$user_id' AND meta_key='simplefavorites'";

$getfav_result = $conn->query($get_favExist);

$favcount=mysqli_num_rows($getfav_result);

$fav_res=array();

$responce=array();

if($favcount >0)
{
$row = $getfav_result->fetch_assoc();

$favorites=$row["meta_value"];

$unser = unserialize($favorites);

$favrestaturantId=$unser[0]['posts'];

$fav=in_array($restId,$favrestaturantId);
if($fav=='1')
{
$faveted='1';

}
else
{
$faveted='0';
}

}

$get_savedExist="SELECT meta_value FROM wp_usermeta WHERE user_id='$user_id' AND meta_key='wpfp_favorites'";

$getsavedcpn_result = $conn->query($get_savedExist);

$savecount=mysqli_num_rows($getsavedcpn_result);

if($savecount >0)
{

$row1 = $getsavedcpn_result->fetch_assoc();

$savedcpns=$row1["meta_value"];
$unser = unserialize($savedcpns);
$couponId=$unser;

$coupon_id=$couponId;

$sav=in_array($coupon_id,$couponId);

if($sav=='1')
{
$saved='1';
}
else
{
$saved='0';

}

}
}
else
{
$faveted='0';
$saved='0';
}

$coupon_res['coupons'][$i]['coupon_id']=$cpnrow1["ID"];

$coupon_res['coupons'][$i]['coupon_name']=$cpnrow1["post_title"];

$coupon_res['coupons'][$i]['coupon_code']=$ccode;

$cpndecres = preg_replace("/[^a-zA-Z]/", "", $cpnrow1["post_content"]);

$coupon_res['coupons'][$i]['coupon_description']=$cpndecres ;

$coupon_res['coupons'][$i]['coupon_startdate']=$offerStartdate;

$coupon_res['coupons'][$i]['coupon_expireddate']=$expiredDate;

$coupon_res['coupons'][$i]['restaurant_id']=$restId;

$coupon_res['coupons'][$i]['restaurant_name']=$retName;

$coupon_res['coupons'][$i]['is_favorite']=$faveted;

$coupon_res['coupons'][$i]['contact_no']=$retPhone;

$coupon_res['coupons'][$i]['email_id']=$retEmail;

$coupon_res['coupons'][$i]['website']=$retweb;

$coupon_res['coupons'][$i]['coupon_image']=$profilePic;

$coupon_res['coupons'][$i]['coupon_rating']=$couponAvgrate;

$coupon_res['coupons'][$i]['is_saved']=$saved;

$coupon_res['coupons'][$i]['is_liked']="0";

$coupon_res['coupons'][$i]['coupon_category']=$cpncatName;

$i++;

}

echo json_encode($coupon_res);
}
  else
{
header('HTTP/1.0 404');
$coupon_res['msg']="There is no coupon available";
echo json_encode($coupon_res);

}
}


if(empty( $restaurant) && empty($category) && empty($expiringcpn) && empty($topcpn) && empty($newcpn) && empty($featured_cpn) && empty($user_id))
{






$select_coupon="SELECT ID,post_title,post_content FROM wp_posts WHERE post_type='offer' AND post_status='publish'";
$coupon_result = $conn->query($select_coupon);

if ($coupon_result->num_rows > 0)
{

// output data of each row
$i=0;
while($cpnrow = $coupon_result->fetch_assoc())
{

$couponId=$cpnrow["ID"];


$getRating="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='ratings_average'";
$cpnReatingqry=$conn->query($getRating);

$cpnRatingRes=$cpnReatingqry->fetch_assoc();
$couponRat=$cpnRatingRes["meta_value"];
if(!empty($couponRat))
{
$couponAvgrate=$couponRat;
}
else
{
$couponAvgrate="";
}



$couponExpired="SELECT offer_start,offer_expire FROM wp_offers WHERE post_id='$couponId' ";
$cpnexpres=$conn->query($couponExpired);

$expiredRes=$cpnexpres->fetch_assoc();

$expdate=$expiredRes["offer_expire"];

$offerStart=$expiredRes["offer_start"];

$offerStartdate=date('Y-m-d',$offerStart);

if(!empty($expdate))
{
$expiredDate=date('Y-m-d', $expdate);
}
else
{
$expiredDate='unlimited';
}

$getcpnCatId="SELECT term_id FROM wp_term_taxonomy WHERE term_taxonomy_id IN(SELECT term_taxonomy_id FROM wp_term_relationships WHERE object_id='$couponId') AND taxonomy='offer_cat'";

$cpnCatIdqry=$conn->query($getcpnCatId);

$cpncatIdRes=$cpnCatIdqry->fetch_assoc();

$cpncatid=$cpncatIdRes["term_id"];


$getcatName="SELECT term_id,name FROM wp_terms WHERE term_id='$cpncatid'";

$cpncatNameqry=$conn->query($getcatName);

$cpncatNameRes=$cpncatNameqry->fetch_assoc();

$cpncat=$cpncatNameRes["name"];
if(!empty($cpncat))
{
$cpncatName=$cpncatNameRes["name"];
$couuponCatId=$cpncatNameRes["term_id"];
}
else
{
$cpncatName="";
$couuponCatId="";
}
$storeId="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='offer_store'";
$storeqry=$conn->query($storeId);

$storeRes=$storeqry->fetch_assoc();
$restId=$storeRes["meta_value"];


$couponCode="SELECT meta_value FROM wp_postmeta WHERE post_id='$couponId' AND meta_key='coupon_code'";
$ccqry=$conn->query($couponCode);

$ccRes=$ccqry->fetch_assoc();
$ccode=$ccRes["meta_value"];


$storeName="SELECT post_title FROM wp_posts WHERE ID='$restId' AND post_status='publish'";
$storenameqry=$conn->query($storeName);

$storeNameRes=$storenameqry->fetch_assoc();

$retName=$storeNameRes["post_title"];


$storeEmail="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restEmail'";
$storeEmailqry=$conn->query($storeEmail);

$storeEmailres=$storeEmailqry->fetch_assoc();

$retEmail=$storeEmailres["meta_value"];


$storePhone="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='restPhone'";
$storePhoneqry=$conn->query($storePhone);

$storePhoneres=$storePhoneqry->fetch_assoc();

$retPhone=$storePhoneres["meta_value"];


$storeWeb="SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='store_link'";
$storewebqry=$conn->query($storeWeb);

$storewebres=$storewebqry->fetch_assoc();

$retweb=$storewebres["meta_value"];









$get_restimage="SELECT meta_value FROM wp_postmeta WHERE post_id IN(SELECT meta_value FROM wp_postmeta WHERE post_id='$restId' AND meta_key='_thumbnail_id') AND meta_key='_wp_attached_file'";
$storeImgqry=$conn->query($get_restimage);
$profilepiccnt=mysqli_num_rows($storeImgqry);

if($profilepiccnt > 0)
{
$propicRow=$storeImgqry->fetch_assoc();
$profilePic=$propicRow['meta_value'];

$pictureArr=explode("/",$profilePic);

$checkpic_from=$pictureArr[0];

if($checkpic_from=='mobile_pic')
{
$key=0;

if (($key = array_search('mobile_pic', $pictureArr)) !== false)
{
unset($pictureArr[$key]);
}
$picStr=implode("/",$pictureArr);


$profilePic=$picStr;


}
else
{
$profilePic='http://192.168.1.79/restaupons/wp-content/uploads/'.$propicRow['meta_value'];
}

}

else
{
$profilePic='';
}

$post_id=$cpnrow["ID"];

$get_likes="SELECT count(meta_value) AS meta_value FROM wp_postmeta WHERE post_id='$post_id' AND meta_key='offer_thumbs_up'";

$getlikeres_result = $conn->query($get_likes);

$likcount=mysqli_num_rows($getlikeres_result);

if($likcount>0)
{
$numlikesRes = $getlikeres_result->fetch_assoc();
$input=$numlikesRes['meta_value'];


$k = pow(10,3);
$mil = pow(10,6);
$bil = pow(10,9);

if ($input >= $bil)
$likes= (int) ($input / $bil).'b';
else if ($input >= $mil)
$likes=  (int) ($input / $mil).'m';
else if ($input >= $k)
$likes=  (int) ($input / $k).'k';
else
$likes=  (int) $input;

}
else
{
$num_likes='0';
}
$faveted='0';
$saved='0';
if(!empty($user_id) )
{

$get_favExist="SELECT meta_value FROM wp_usermeta WHERE user_id='$user_id' AND meta_key='simplefavorites'";

$getfav_result = $conn->query($get_favExist);

$favcount=mysqli_num_rows($getfav_result);

$fav_res=array();

$responce=array();

if($favcount >0)
{
$row = $getfav_result->fetch_assoc();

$favorites=$row["meta_value"];

$unser = unserialize($favorites);

$favrestaturantId=$unser[0]['posts'];

$fav=in_array($restId,$favrestaturantId);
if($fav=='1')
{
$faveted='1';

}
else
{
$faveted='0';
}

}

$get_savedExist="SELECT meta_value FROM wp_usermeta WHERE user_id='$user_id' AND meta_key='wpfp_favorites'";

$getsavedcpn_result = $conn->query($get_savedExist);

$savecount=mysqli_num_rows($getsavedcpn_result);

if($savecount >0)
{

$row1 = $getsavedcpn_result->fetch_assoc();

$savedcpns=$row1["meta_value"];

$unser = unserialize($savedcpns);

$couponId=$unser;

$coupon_id=$couponId;

$sav=in_array($coupon_id,$couponId);

if($sav=='1')
{
$saved='1';
}
else
{
$saved='0';

}

}
}
else
{
$faveted='0';
$saved='0';
}

$coupon_res['coupons'][$i]['coupon_id']=$cpnrow["ID"];

$coupon_res['coupons'][$i]['coupon_name']=$cpnrow["post_title"];

$coupon_res['coupons'][$i]['coupon_code']=$ccode;

$cpndecres = preg_replace("/[^a-zA-Z]/", "", $cpnrow["post_content"]);

$coupon_res['coupons'][$i]['coupon_description']=$cpndecres ;

$coupon_res['coupons'][$i]['coupon_startdate']=$offerStartdate;

$coupon_res['coupons'][$i]['coupon_expireddate']=$expiredDate;

$coupon_res['coupons'][$i]['restaurant_id']=$restId;

$coupon_res['coupons'][$i]['restaurant_name']=$retName;

$coupon_res['coupons'][$i]['is_favorite']=$faveted;

$coupon_res['coupons'][$i]['contact_no']=$retPhone;

$coupon_res['coupons'][$i]['email_id']=$retEmail;

$coupon_res['coupons'][$i]['website']=$retweb;

$coupon_res['coupons'][$i]['coupon_image']=$profilePic;

$coupon_res['coupons'][$i]['coupon_rating']=$couponAvgrate;

$coupon_res['coupons'][$i]['is_saved']=$saved;

$coupon_res['coupons'][$i]['is_liked']="0";

$coupon_res['coupons'][$i]['coupon_category']=$cpncatName;


$i++;

}

echo json_encode($coupon_res);
}
else
{
header('HTTP/1.0 404');
$coupon_res['msg']="There is no coupon available";
echo json_encode($coupon_res);

}
}
}
else
{
$json = array("msg" => "Request method not accepted");
echo json_encode($json);
}


?>