public function loadHome()
{
if (Efiwebsetting::getData('checkOAuth') == 'yes') {
IMBAuth::checkOAuth();
}
$cmd = Generic::mustCheck($_GET['cmd'], "No CMD Found");
$page = addslashes($_GET['page']);
if ($page == "" || $page < 1) {
$page = 1;
}
$limit = addslashes($_GET['limit']);
if ($limit == "" || $limit < 1) {
$limit = 10;
}
$begin = ($page - 1) * $limit;
$json = array();
$sem = array();
$json['status_code'] = 1;
if ($cmd == "fav" || $cmd == "nearby") {
global $db;
$objRestaurant = new MasterRestaurantModel();
$exp = explode(",", str_replace(" ", "", $objRestaurant->crud_webservice_allowed));
$arrPicsToAddPhotoUrl = $objRestaurant->crud_add_photourl;
$currentLat = isset($_GET['latitude']) ? addslashes($_GET['latitude']) : "";
if (!$currentLat) {
Generic::errorMsg("No Lat");
}
$currentLong = isset($_GET['longitude']) ? addslashes($_GET['longitude']) : "";
if (!$currentLong) {
Generic::errorMsg("No Long");
}
if ($cmd == "fav") {
// $arr = $objRestaurant->getOrderBy("fav DESC LIMIT $begin,$limit", "*");
$q = "SELECT *, SQRT(POW(69.1 * (latitude - {$currentLat}), 2) + POW(69.1 * ({$currentLong} - longitude) * COS(latitude / 57.3), 2)) AS distance FROM {$objRestaurant->table_name} WHERE show_in_apps='1' HAVING distance < 1000000 ORDER by fav DESC, DISTANCE ASC LIMIT {$begin},{$limit}";
// echo $q;
$arr = $db->query($q, 2);
} elseif ($cmd == "nearby") {
$q = "SELECT *, SQRT(POW(69.1 * (latitude - {$currentLat}), 2) + POW(69.1 * ({$currentLong} - longitude) * COS(latitude / 57.3), 2)) AS distance FROM {$objRestaurant->table_name} WHERE show_in_apps='1' HAVING distance < 1000000 ORDER by DISTANCE ASC LIMIT {$begin},{$limit}";
$arr = $db->query($q, 2);
if (count($arr) == 0) {
Generic::errorMsg("No Count");
die;
}
}
} elseif ($cmd == "recommendation") {
$objRecommendation = new RecommendationModel();
$exp = explode(",", str_replace(" ", "", $objRecommendation->crud_webservice_allowed));
$arrPicsToAddPhotoUrl = $objRecommendation->crud_add_photourl;
$arr = $objRecommendation->getWhere("show_in_apps='1' AND DATE(end) >= DATE(NOW()) AND DATE(start)<= DATE(NOW()) LIMIT {$begin},{$limit}");
if (count($arr) == 0) {
$json['status_code'] = 0;
$json['status_message'] = "No ID Found";
echo json_encode($json);
die;
}
} else {
$json['status_code'] = 0;
$json['status_message'] = "No ID Found";
echo json_encode($json);
die;
}
$json["results"]['restaurant'] = array();
foreach ($arr as $o) {
foreach ($exp as $attr) {
if (in_array($attr, $arrPicsToAddPhotoUrl)) {
$sem[$attr] = Generic::insertImageUrl($o->{$attr});
} else {
$sem[$attr] = stripslashes($o->{$attr});
}
$sem['disc_mr'] = MasterOrder::getDiscountMR($o->id_restaurant);
}
if ($cmd == "fav" || $cmd == "nearby") {
$sem["distance"] = sqrt(pow(69.09999999999999 * ($o->latitude - $currentLat), 2) + pow(69.09999999999999 * ($currentLong - $o->longitude) * cos($o->latitude / 57.3), 2));
}
if ($cmd == "recommendation") {
$sem['restaurant'] = User::getRestaurant($o->id_restaurant);
}
$json["results"]['restaurant'][] = $sem;
}
echo json_encode($json);
die;
}
public static function getRestaurant($restaurant_id)
{
$objRestaurant = new MasterRestaurantModel();
$arr = $objRestaurant->getWhere("id_restaurant={$restaurant_id}");
$exp = explode(",", str_replace(" ", "", $objRestaurant->crud_webservice_allowed));
$arrPicsToAddPhotoUrl = $objRestaurant->crud_add_photourl;
$sem = array();
foreach ($arr as $o) {
foreach ($exp as $attr) {
if (in_array($attr, $arrPicsToAddPhotoUrl)) {
$sem[$attr] = Generic::insertImageUrl($o->{$attr});
} else {
$sem[$attr] = stripslashes($o->{$attr});
}
$sem['disc_mr'] = MasterOrder::getDiscountMR($restaurant_id);
}
}
return $sem;
}
public function loadHomeRecommendation()
{
if (Efiwebsetting::getData('checkOAuth') == 'yes') {
IMBAuth::checkOAuth();
}
$page = addslashes($_GET['page']);
if ($page == "" || $page < 1) {
Generic::errorMsg("No Page Found");
}
$limit = addslashes($_GET['limit']);
if ($limit == "" || $limit < 1) {
Generic::errorMsg("Limit Error");
}
$begin = ($page - 1) * $limit;
$json = array();
$sem = array();
$objRecommendation = new RecommendationModel();
$exp = explode(",", str_replace(" ", "", $objRecommendation->crud_webservice_allowed));
$arrPicsToAddPhotoUrl = $objRecommendation->crud_add_photourl;
$arr = $objRecommendation->getWhere("DATE(end) >= DATE(NOW()) AND DATE(start)<= DATE(NOW()) LIMIT {$begin},{$limit}");
if (count($arr) == 0) {
$json['status_code'] = 0;
$json['status_message'] = "No ID Found";
echo json_encode($json);
die;
}
$json["results"]['restaurant'] = array();
foreach ($arr as $o) {
foreach ($exp as $attr) {
if (in_array($attr, $arrPicsToAddPhotoUrl)) {
$sem[$attr] = Generic::insertImageUrl($o->{$attr});
} elseif ($attr == "time_open" || $attr == "time_close") {
$sem[$attr] = date('H:i', strtotime(stripslashes($o->{$attr})));
} else {
$sem[$attr] = stripslashes($o->{$attr});
}
$sem['disc_mr'] = MasterOrder::getDiscountMR($o->id_restaurant);
}
$sem['restaurant'] = User::getRestaurant($o->id_restaurant);
$json["results"]['restaurant'][] = $sem;
}
echo json_encode($json);
die;
}