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 function repositionTables()
{
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) {
$json['status_code'] = 0;
$json['status_message'] = "No ID Found";
echo json_encode($json);
die;
}
$jsonTables = isset($_POST['tables']) ? $_POST['tables'] : "";
if (!$jsonTables) {
$json['status_code'] = 0;
$json['status_message'] = "No ID Found";
echo json_encode($json);
die;
}
$jsonArrayTables = json_decode($jsonTables);
// pr($jsonArrayTables);
$countjsonArrayTables = count($jsonArrayTables);
// pr($countTables);
$objResto = new MasterRestaurantModel();
$arrResto = $objResto->getWhere("id_restaurant='{$id_restaurant}'");
MasterDish::checkCount($arrResto);
$countTablesinResto = $arrResto[0]->table_quantity;
// pr($arrResto);
$objTable = new MasterTableModel();
$arrTable = $objTable->getWhere("id_restaurant='{$id_restaurant}'");
if ($countTablesinResto != $countjsonArrayTables) {
Generic::errorMsg("Wrong Quantity");
}
// $break = false;
// foreach ($jsonArrayTables as $key => $objTables) {
////
// $arrReposTable = $objTable->getWhere("id_restaurant='$id_restaurant' AND id_table='$objTables->table_id' ");
// if (count($arrReposTable) == 0) {
// $break = true;
// $msg = $msg . " $objTables->table_id can't find in database.";
// }
// }
// if ($break == false) {
// foreach ($jsonArrayTables as $key => $objTables) {
// $arrReposTable = $objTable->getWhere("id_restaurant='$id_restaurant' AND id_table='$objTables->table_id' ");
//// $arrReposTable[0]->table_position = $key + 1;
// $arrReposTable[0]->load = 1;
// $arrReposTable[0]->save();
// }
// }
$counter = 1;
foreach ($jsonArrayTables as $jsonObjTable) {
$table = new MasterTableModel();
$table->getByID($jsonObjTable->table_id);
$table->table_position = $counter;
$table->save();
$counter++;
}
$json['status_code'] = 1;
$json['results']['message'] = "success";
echo json_encode($json);
die;
}
public static function getRestaurantnyID($id_restaurant)
{
$objResto = new MasterRestaurantModel();
$arrResto = $objResto->getWhere("id_restaurant='{$id_restaurant}'");
return $arrResto;
}
public function setupFeeMenuRevolution()
{
$resto = new MasterRestaurantModel();
$arrResto = $resto->getWhere("id_restaurant!='0' ORDER BY name ASC");
?>
<div class="col-sm-12">
<h1>Setup Fee Menu Revolution</h1>
</div>
<div id="formgroup_restaurant" class="form-group">
<label for="restaurant_mr_fee_choices" class=" col-sm-2 control-label">restaurant</label>
<div class="col-sm-8">
<select class="form-control" name="restaurant_mr_fee_choices" id="restaurant_mr_fee_choices">
<option value="-1">Select Restaurant</option>
<option value="0">All Restaurant</option>
<?php
foreach ($arrResto as $r) {
if (Generic::IsNullOrEmptyString($r->name)) {
continue;
}
?>
<option value="<?php
echo $r->id_restaurant;
?>
"><?php
echo $r->name;
?>
</option>
<?php
}
?>
</select>
<span class="help-block" id="warning_voided"></span>
</div>
<div class="col-sm-2">
<button type="button" id="button_select_resto_mr_fee" class="btn btn-default" style="width: 100%;">Add
</button>
</div>
<div class="clearfix"></div>
</div>
<div id="formgroup_selected_restaurant" class="form-group">
<label for="selected_restaurant_mr_fee" class=" col-sm-2 control-label">selected_resto</label>
<div class="col-sm-10">
<input type="text" name="selected_restaurant_mr_fee" id="selected_restaurant_mr_fee"
class="form-control">
<span class="help-block" id="warning_id_user"></span>
</div>
<div class="clearfix"></div>
</div>
<div id="formgroup_fee_resto_mr" class="form-group">
<label for="fee_resto_mr" class=" col-sm-2 control-label">Fee</label>
<div class="col-sm-10">
<div class="input-group">
<input type="text" name="fee_resto_mr" value="0" id="fee_resto_mr" class="form-control">
<span class="input-group-addon"> % </span>
</div>
<span class="help-block" id="warning_id_user"></span>
</div>
<div class="clearfix"></div>
</div>
<div class="form-group">
<div class="col-sm-12">
<button id="submit_button_resto_mr_fee" class="btn btn-default">submit</button>
<button id="cancel_button_resto_mr_fee" class="btn btn-default">cancel</button>
</div>
</div>
<script>
$('#button_select_resto_mr_fee').click(
function () {
var restoChoice = $('select#restaurant_mr_fee_choices');
var selectedVal = restoChoice.val();
var selectedText = restoChoice.find('option:selected').text();
if (restoChoice.prop('disabled')) {
alert("All Restaurant Selected");
return;
}
if (selectedVal == '-1' || selectedVal == null || selectedVal == '') {
alert("Please Select Restaurant");
return;
} else if (selectedVal == '0') {
restoChoice.prop("disabled", true);
}
$("select#restaurant_mr_fee_choices option:selected").remove();
$('#selected_restaurant_mr_fee').tokenfield();
$('#selected_restaurant_mr_fee').tokenfield('createToken', {
value: selectedVal,
label: selectedText
});
restoChoice.val('');
}
);
$('#selected_restaurant_mr_fee')
.on('tokenfield:removedtoken', function (e) {
var value = e.attrs.value;
var label = e.attrs.label;
var restoChoice = $('select#restaurant_mr_fee_choices');
restoChoice
.append($("<option></option>")
.attr("value", value)
.text(label));
if (value == '0') {
restoChoice.prop("disabled", false);
}
var selectList = $('select#restaurant_mr_fee_choices option');
selectList.sort(function (a, b) {
a = a.value;
b = b.value;
return a - b;
});
restoChoice.html(selectList);
restoChoice.val(value);
});
$('#cancel_button_resto_mr_fee').click(function () {
clearFields();
});
$('#submit_button_resto_mr_fee').click(function () {
var arr = $('#selected_restaurant_mr_fee').tokenfield('getTokens');
if (!Array.isArray(arr) || arr.length <= 0) {
alert("No Restaurant Selected");
return;
}
var arrValue = [];
arr.forEach(function (e) {
console.log(e);
var value = e.value;
var label = e.label;
arrValue.push(value);
console.log(arrValue.join());
});
var fee = $('#fee_resto_mr').val();
updateMRFee(arrValue.join(), fee);
});
function updateMRFee(values, fee) {
$.ajax({
method: "POST",
url: _sppath + "Fee/updateRestoMRFee",
data: {id_restaurant: values, fee: fee}
})
.done(function (msg) {
// console.log(msg);
var json_obj = $.parseJSON(msg);//parse JSON
if (json_obj.status_code == 0) {
alert(json_obj.status_message);
}
if (json_obj.status_code == 1) {
alert(json_obj.status_message);
clearFields();
}
});
}
function clearFields() {
lwrefresh(window.selected_page);
}
</script>
<?php
}
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 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)) {
if ($o->{$attr} != "" and $o->{$attr} != 0) {
$sem[$attr] = _BPATH . _PHOTOURL . $o->{$attr};
} else {
$sem[$attr] = "";
}
} else {
$sem[$attr] = stripslashes($o->{$attr});
}
}
}
return $sem;
}
private function searchTypeDataSet($searchType, $identifier)
{
switch ($searchType) {
// case "0": {
// return new Leap\View\InputText("text", "search_term", "search_term", $this->search_term);
// }
case "1":
$rt = new MasterRestaurantTypeModel();
$arr = $rt->getWhere("name!=''");
$arrRestoType = array();
foreach ($arr as $restoType) {
$arrRestoType[$restoType->id_restaurant_type] = $restoType->name;
}
return new Leap\View\InputSelect($arrRestoType, "search_term{$identifier}", "search_term", $this->search_term);
case "2":
$r = new MasterCategoryModel();
$arr = $r->getWhere("name!=''");
$arrRestoTag = array();
foreach ($arr as $tag) {
$arrRestoTag[$tag->id_category] = $tag->name;
}
return new Leap\View\InputSelect($arrRestoTag, "search_term{$identifier}", "search_term", $this->search_term);
case "3":
$r = new CuisineModel();
$arrRC = $r->getWhere("name_cuisine!=''");
$arrRestoCuisine = array();
foreach ($arrRC as $cuisine) {
$arrRestoCuisine[$cuisine->id_cuisine] = $cuisine->name_cuisine;
}
return new Leap\View\InputSelect($arrRestoCuisine, "search_term{$identifier}", "search_term", $this->search_term);
// case "4": {
// return new Leap\View\InputText("text", "search_term", "search_term", $this->search_term);
// }
// case "5": {
// $r = new MasterDishTagModel();
// $arr = $r->getWhere("name!=''");
// $arrDishTag = array();
// foreach ($arr as $tag) {
// $arrDishTag[$tag->id_tag] = $tag->name;
// }
// return new Leap\View\InputSelect($arrDishTag, "search_term$identifier", "search_term", $this->search_term);
//
// }
// case "6": {
// return new Leap\View\InputText("text", "search_term", "search_term", $this->search_term);
// }
// case "4": {
// return new Leap\View\InputText("text", "search_term", "search_term", $this->search_term);
// }
// case "5": {
// $r = new MasterDishTagModel();
// $arr = $r->getWhere("name!=''");
// $arrDishTag = array();
// foreach ($arr as $tag) {
// $arrDishTag[$tag->id_tag] = $tag->name;
// }
// return new Leap\View\InputSelect($arrDishTag, "search_term$identifier", "search_term", $this->search_term);
//
// }
// case "6": {
// return new Leap\View\InputText("text", "search_term", "search_term", $this->search_term);
// }
case "7":
$rt = new MasterRestaurantModel();
$arr = $rt->getWhere("name!=''");
$arrResto = array();
foreach ($arr as $resto) {
$arrResto[$resto->id_restaurant] = $resto->name;
}
return new Leap\View\InputSelect($arrResto, "search_term{$identifier}", "search_term", $this->search_term);
case "8888":
return new Leap\View\InputSelect(array("8888" => "Not Available"), "search_term{$identifier}", "search_term", $this->search_term);
default:
return new Leap\View\InputSelect(array("8888" => "Not Available"), "search_term{$identifier}", "search_term", $this->search_term);
}
}
public static function getRestoNameByIDResto($id_restaurant)
{
$objResto = new MasterRestaurantModel();
$arrResto = $objResto->getWhere("id_restaurant = '{$id_restaurant}'");
if (count($arrResto) > 0) {
return $arrResto[0]->name;
} else {
return "";
}
}
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 searchTypeDataSet()
{
$searchType = $_GET['search_type'];
$json = array();
switch ($searchType) {
case "1":
$rt = new MasterRestaurantTypeModel();
$arr = $rt->getWhere("name!=''");
foreach ($arr as $restoType) {
$b['value'] = $restoType->id_restaurant_type;
$b['text'] = $restoType->name;
$json[] = $b;
}
break;
case "2":
$r = new MasterCategoryModel();
$arr = $r->getWhere("name!=''");
foreach ($arr as $tag) {
$b['value'] = $tag->id_category;
$b['text'] = $tag->name;
$json[] = $b;
}
break;
case "3":
$r = new CuisineModel();
$arrRC = $r->getWhere("name_cuisine!=''");
foreach ($arrRC as $cuisine) {
$b['value'] = $cuisine->id_cuisine;
$b['text'] = $cuisine->name_cuisine;
$json[] = $b;
}
break;
// case "5": {
// $r = new MasterDishTagModel();
// $arr = $r->getWhere("name!=''");
// foreach ($arr as $tag) {
// $b['value'] = $tag->id_tag;
// $b['text'] = $tag->name;
// $json[] = $b;
// }
// break;
// }
// case "5": {
// $r = new MasterDishTagModel();
// $arr = $r->getWhere("name!=''");
// foreach ($arr as $tag) {
// $b['value'] = $tag->id_tag;
// $b['text'] = $tag->name;
// $json[] = $b;
// }
// break;
// }
case "7":
$rt = new MasterRestaurantModel();
$arr = $rt->getWhere("name!=''");
foreach ($arr as $resto) {
$b['value'] = $resto->id_restaurant;
$b['text'] = $resto->name;
$json[] = $b;
}
break;
default:
$b['value'] = 8888;
$b['text'] = "Not Available";
$json[] = $b;
break;
}
echo json_encode($json);
die;
}
public function regroupCategories()
{
$idResto = Generic::getOrDefault($_GET['id_restaurant'], Keys::$EMPTY);
$catIdDefault = $this->createCategories("OTHERS");
echo "<h1>ID Others : {$catIdDefault}</h1>";
$r = new MasterRestaurantModel();
if (Generic::IsNullOrEmptyString($idResto)) {
$arrResto = $r->getAll();
} else {
$arrResto = $r->getWhere("id_restaurant='{$idResto}'");
}
foreach ($arrResto as $resto) {
if (!$resto instanceof MasterRestaurantModel) {
continue;
}
echo "<h2>{$resto->id_restaurant} - {$resto->name}</h2>";
$resto->load = 1;
if (Generic::IsNullOrEmptyString($resto->id_categories)) {
$resto->id_categories = $catIdDefault;
$resto->save();
continue;
}
$arrNewCats = array();
$arrCatIds = explode(',', $resto->id_categories);
foreach ($arrCatIds as $catId) {
if (!$this->isCategoryIdValid($catId)) {
$arrNewCats[] = $catId;
}
}
$arrNewCats = array_unique($arrNewCats);
if (count($arrNewCats) <= 0) {
$resto->id_categories = $catIdDefault;
$resto->save();
}
$resto->id_categories = implode(',', $arrNewCats);
$resto->save();
echo "<h3>{$resto->id_categories}</h3>";
}
$d = new MasterDishModel();
// $arrDish = $d->getAll();
$arrDish = $d->getWhere("id_restaurant='62'");
foreach ($arrDish as $dish) {
if (!$dish instanceof MasterDishModel) {
continue;
}
echo "<h2>{$dish->id_dish} - {$dish->name}-></h2>";
if (!$this->isCategoryIdValid($dish->id_category)) {
$dish->id_category = $catIdDefault;
$dish->load = 1;
$dish->save();
}
}
}
