public function setRestoCategories()
{
if (Efiwebsetting::getData('checkOAuth') == 'yes') {
IMBAuth::checkOAuth();
}
$idRestaurant = Generic::mustCheck($_POST['id_restaurant'], Keys::$ERR_NOT_FOUND_ID_RESTAURANT);
$category = Generic::mustCheck($_POST['categories'], Keys::$ERR_NOT_FOUND_CATEGORIES);
//category yang di passing harus berupa JSON ARRAY
$arrNewCategory = json_decode($category);
foreach ($arrNewCategory as $newCategory) {
echo $newCategory->category_name . "<br>";
}
die;
$json = array();
$json['status_code'] = 1;
$id_restaurant = isset($_POST['id_restaurant']) ? addslashes($_POST['id_restaurant']) : "";
if (!$id_restaurant) {
Generic::errorMsg("Restaurant ID not Found");
}
$category = isset($_POST['categories']) ? $_POST['categories'] : "";
if (!$category) {
Generic::errorMsg("Category ID not found!");
}
$resto = new MasterRestaurantModel();
$resto->getByID($id_restaurant);
$arrOldCategories = explode(",", $resto->id_categories);
$other = '[{"category_name":"OTHERS"}]';
$other = json_decode($other);
$jsonCategories = json_decode($category);
foreach ($jsonCategories as $cat) {
$jsonCategorieshlp[] = $cat->category_name;
}
if (!in_array("OTHERS", $jsonCategorieshlp)) {
$jsonCategories[]['category_name'] = "OTHERS";
}
$objCategory = new MasterCategoryModel();
$idCategories = array();
foreach ($jsonCategories as $category) {
$arrCategory = $objCategory->getWhere("name = '{$category->category_name}'");
if (count($arrCategory) == 0) {
if (strtoupper($category->category_name) != strtoupper("OTHERS")) {
$objCategory->name = strtoupper($category->category_name);
// echo $objCategory->name;
$objCategory->status = "1";
$objCategory->is_drink = "0";
$objCategory->save();
}
}
}
foreach ($jsonCategories as $category) {
$arrCategory = $objCategory->getWhere("name = '{$category->category_name}'");
foreach ($arrCategory as $val) {
$idCategories[] = $val->id_category;
}
}
//compare old categories to new categories
//cari yang dulu ada sekarang ga ada
//migrasi dish ke others
$missingCategories = array_diff($arrOldCategories, $idCategories);
foreach ($missingCategories as $category) {
$d = new MasterDishModel();
$arrDishes = $d->getWhere("id_category = '{$category}' AND id_restaurant = '{$id_restaurant}'");
foreach ($arrDishes as $dish) {
$dish->load = 1;
$dish->id_category = "0";
$dish->save();
}
}
$objRestaurant = new MasterRestaurantModel();
$arrResto = $objRestaurant->getWhere("id_restaurant = '{$id_restaurant}'");
if (count($arrResto) == 0) {
$json['status_code'] = 0;
$json['status_message'] = "No ID Found";
echo json_encode($json);
die;
}
$idCategories = implode(",", $idCategories);
$arrResto[0]->id_categories = $idCategories;
$arrResto[0]->load = 1;
$idSave = $arrResto[0]->save();
if (!$idSave) {
Generic::errorMsg(Lang::t('save failed'));
} else {
$json['status_code'] = 1;
$json['results'] = "Success";
}
echo json_encode($json);
die;
}
public static function checkDish($id_dish)
{
$objDish = new MasterDishModel();
$arrDish = $objDish->getWhere("id_dish='{$id_dish}'");
if (count($arrDish) > 0) {
return true;
} else {
return false;
}
}
public function loadDish()
{
if (Efiwebsetting::getData('checkOAuth') == 'yes') {
IMBAuth::checkOAuth();
}
$cmd = isset($_GET['cmd']) ? addslashes($_GET['cmd']) : "";
$json = array();
$json['status_code'] = 1;
if (!$cmd) {
$json['status_code'] = 0;
$json['status_message'] = "No ID Found";
echo json_encode($json);
die;
}
$id_user = isset($_GET['id']) ? addslashes($_GET['id']) : "";
if (!$id_user) {
$json['status_code'] = 0;
$json['status_message'] = "No ID Found";
echo json_encode($json);
die;
}
$user = new UserModel();
$arrUser = $user->getWhere("id_user={$id_user}");
if ($cmd == "fav") {
foreach ($arrUser as $o) {
$dishSearch['fav_dishes_ids'] = $o->fav_dishes_ids;
}
$objectDish = new MasterDishModel();
$objResto = new MasterRestaurantModel();
$arrdishSearch = explode(",", $dishSearch[fav_dishes_ids]);
foreach ($arrdishSearch as $val) {
if ($where == "") {
$where = "{$objectDish->table_name}.id_dish={$val}";
} else {
$where = $where . " or {$objectDish->table_name}.id_dish={$val}";
}
}
$where = $where . " ORDER BY {$objectDish->table_name}.fav DESC";
$where = $where;
global $db;
$arrDish = $objectDish->getWhere($where);
foreach ($arrDish as $key => $dish) {
$arrFavbyResto[] = $dish->id_restaurant;
$arrGesDish[$dish->id_restaurant][] = MasterDish::getDish($dish->id_dish);
}
$arrFavbyResto = array_unique($arrFavbyResto);
$sem = array();
foreach ($arrFavbyResto as $resto) {
$restoHelp = self::getRestaurant($resto);
foreach ($arrGesDish as $key => $valdish) {
$dishhelp = array();
if ($key == $resto) {
$dishhelp = $valdish;
break;
}
}
$restoHelp['dish'] = $dishhelp;
$sem['restaurant'][] = $restoHelp;
}
$json['results'] = $sem;
} elseif ($cmd == "his") {
foreach ($arrUser as $o) {
$dishSearch['history_dishes_ids'] = $o->history_dishes_ids;
}
$arrdishSearch = explode(",", $dishSearch[history_dishes_ids]);
$objectDish = new MasterDishModel();
$objectRestaurant = new MasterRestaurantModel();
$exp = explode(",", str_replace(" ", "", $objectDish->crud_webservice_allowed));
$arrPicsToAddPhotoUrl = $objectDish->crud_add_photourl;
foreach ($arrdishSearch as $val) {
$arr = $objectDish->getWhere("id_dish=" . $val, "*");
if (count($arr) != 0) {
$json['status_code'] = 1;
} else {
$json['status_code'] = 0;
$json['status_message'] = "No ID Found";
echo json_encode($json);
die;
}
$sem = array();
foreach ($arr as $o) {
foreach ($exp as $attr) {
// echo $attr;
if (in_array($attr, $arrPicsToAddPhotoUrl)) {
$sem[$attr] = _BPATH . _PHOTOURL . $o->{$attr};
} elseif ($attr == "id_restaurant") {
// echo "masuk";
// echo $o->$attr;
$sem[$attr] = stripslashes($o->{$attr});
$sem['restaurant'] = $this->getRestaurant($o->{$attr});
} else {
$sem[$attr] = stripslashes($o->{$attr});
}
}
//$sem['restaurant'] = $objectRestaurant->getRestaurant($val);
$json["results"][] = $sem;
}
}
} elseif ($cmd == "receipthis") {
} else {
$json['status_code'] = 0;
$json['status_message'] = "No ID Found";
echo json_encode($json);
die;
}
echo json_encode($json);
die;
}
public function setRestoCategories()
{
if (Efiwebsetting::getData('checkOAuth') == 'yes') {
IMBAuth::checkOAuth();
}
$json = array();
$json['status_code'] = 1;
$id_restaurant = isset($_POST['id_restaurant']) ? addslashes($_POST['id_restaurant']) : "";
if (!$id_restaurant) {
Generic::errorMsg("Restaurant ID not Found");
}
$category = isset($_POST['categories']) ? $_POST['categories'] : "";
if (!$category) {
Generic::errorMsg("Category ID not found!");
}
$resto = new MasterRestaurantModel();
$resto->getByID($id_restaurant);
$arrOldCategories = explode(",", $resto->id_categories);
$jsonCategories = json_decode($category);
$jsonCategorieshlp = array();
foreach ($jsonCategories as $cat) {
$jsonCategorieshlp[] = $cat->category_name;
}
if (!in_array("OTHERS", $jsonCategorieshlp)) {
$jsonCategorieshlp[] = "OTHERS";
}
$jsonCategorieshlp = array_unique($jsonCategorieshlp);
$objCategory = new MasterCategoryModel();
$idCategories = array();
foreach ($jsonCategorieshlp as $category) {
$arrCategory = $objCategory->getWhere("name = '{$category}'");
if (count($arrCategory) == 0 && !Generic::IsNullOrEmptyString($category)) {
$oc = new MasterCategoryModel();
$oc->name = strtoupper($category);
$oc->status = "1";
$oc->is_drink = "0";
$oc->save();
}
}
foreach ($jsonCategorieshlp as $category) {
$arrCategory = $objCategory->getWhere("name = '{$category}'");
foreach ($arrCategory as $val) {
$idCategories[] = $val->id_category;
}
}
//compare old categories to new categories
//cari yang dulu ada sekarang ga ada
//migrasi dish ke others
$missingCategories = array_diff($arrOldCategories, $idCategories);
foreach ($missingCategories as $category) {
$d = new MasterDishModel();
$arrDishes = $d->getWhere("id_category = '{$category}' AND id_restaurant = '{$id_restaurant}'");
foreach ($arrDishes as $dish) {
$dish->load = 1;
$dish->id_category = "0";
$dish->save();
}
}
$objRestaurant = new MasterRestaurantModel();
$arrResto = $objRestaurant->getWhere("id_restaurant = '{$id_restaurant}'");
if (count($arrResto) == 0) {
$json['status_code'] = 0;
$json['status_message'] = "No ID Found";
echo json_encode($json);
die;
}
$idCategories = implode(",", $idCategories);
$arrResto[0]->id_categories = $idCategories;
$arrResto[0]->load = 1;
$idSave = $arrResto[0]->save();
if (!$idSave) {
Generic::errorMsg(Lang::t('save failed'));
} else {
$json['status_code'] = 1;
$json['results'] = "Success";
}
echo json_encode($json);
die;
}
public function overwriteForm($return, $returnfull)
{
$r = new MasterRestaurantModel();
$arrR = $r->getWhere("aktiv='1'");
$arrHelp = array("0" => "Nothing Selected");
foreach ($arrR as $resto) {
$arrHelp[$resto->id_restaurant] = $resto->name;
}
$return['id_restaurant'] = new \Leap\View\InputSelect($arrHelp, "id_restaurant", "id_restaurant", $this->id_restaurant);
if (!isset($this->id_restaurant)) {
$this->id_restaurant = key($arrHelp);
}
$d = new MasterDishModel();
$arrD = $d->getWhere("id_restaurant='{$this->id_restaurant}' AND status='1'");
$arrHelpDish = array("0" => "Nothing Selected");
foreach ($arrD as $dish) {
$arrHelpDish[$dish->id_dish] = $dish->name;
}
$return['id_dish'] = new Leap\View\InputSelect($arrHelpDish, "id_dish", "id_dish", $this->id_dish);
?>
<script>
$("#id_restaurant").change(function () {
var selVal = $("select#id_restaurant option:selected").val();
if (selVal == 0 || selVal == "" || selVal == "0") {
$('#id_dish').empty();
$('#id_dish').append($("<option></option>")
.attr("value", 0)
.text("Nothing Selected"));
return;
}
$.ajax({
method: "GET",
url: _sppath + "RecommendationFood/getDishByRestoId",
data: {id_restaurant: selVal}
}).done(function (msg) {
// console.log(msg);
$('#id_dish').empty();
var json_obj = $.parseJSON(msg);//parse JSON
for (var i in json_obj) {
$('#id_dish')
.append($("<option></option>")
.attr("value", json_obj[i].value)
.text(json_obj[i].text));
console.log(json_obj[i].text);
}
});
});
</script>
<?php
if (!isset($this->start)) {
$dt = leap_mysqldate();
} else {
$dt = $this->start;
}
$return['start'] = new \Leap\View\InputText("date", "start", "start", $dt);
if (!isset($this->end)) {
$dt = leap_mysqldate();
} else {
$dt = $this->end;
}
$return['end'] = new \Leap\View\InputText("date", "end", "end", $dt);
return $return;
}
public function reinitiateCategories()
{
$idRestaurant = Generic::mustCheck($_GET['id_restaurant'], "BOOO!");
$catIdDefault = $this->createCategories("OTHERS");
$md = new MasterDishModel();
if ($idRestaurant == "all") {
$arrDishes = $md->getAll();
} else {
$arrDishes = $md->getWhere("id_restaurant='{$idRestaurant}'");
}
echo "<h1>Default cat id : {$catIdDefault}</h1>";
foreach ($arrDishes as $d) {
$dish = new MasterDishModel();
$dish->getByID($d->id_dish);
echo "<h2>{$dish->id_dish} - {$dish->name}</h2>";
echo "<h3>From {$dish->id_category}";
if (Generic::IsNullOrEmptyString($dish->id_category)) {
echo "changed to";
$dish->id_category = $catIdDefault;
$dish->save();
} else {
if (!$this->isCategoryIdValid($dish->id_category)) {
echo "changed to";
$dish->id_category = $catIdDefault;
$dish->save();
} else {
echo "stay at";
}
}
echo " {$dish->id_category}</h3>";
$resto = new MasterRestaurantModel();
$resto->getByID($dish->id_restaurant);
echo "<h2>{$resto->id_restaurant} - {$resto->name}</h2>";
echo "<h3>From {$resto->id_categories}";
if (Generic::IsNullOrEmptyString($resto->id_categories)) {
$resto->id_categories = $catIdDefault;
$resto->save();
} else {
$arrCats = explode(',', $resto->id_categories);
$arrCats[] = $dish->id_category;
$arrCats = array_unique($arrCats);
$resto->id_categories = implode(',', $arrCats);
$resto->save();
}
echo " To {$resto->id_categories}</h3>";
}
}
