public function overwriteRead($return) { $objs = $return['objs']; foreach ($objs as $obj) { if (isset($obj->id_restaurant)) { $resto = new MasterRestaurantModel(); $resto->getByID($obj->id_restaurant); $obj->id_restaurant = $resto->name; } if (isset($obj->id_bank)) { $bank = new BankModel(); $bank->getByID($obj->id_bank); $obj->id_bank = $bank->bank_name; } if (isset($obj->start_fee)) { $date = new DateTime($obj->start_fee); $obj->start_fee = $date->format('d.m.Y'); } if (isset($obj->end_fee)) { $dateEnd = new DateTime($obj->end_fee); $obj->end_fee = $dateEnd->format('d.m.Y'); } } return $return; }
public function overwriteRead($return) { $objs = $return['objs']; foreach ($objs as $obj) { $obj->removeAutoCrudClick = array("status"); if (isset($obj->status)) { $idR = $obj->id_request; if ($obj->status == "1") { $obj->status = '<button type="button" id="button' . $idR . '" onclick="updateStatusCashout(' . $obj->status . ',' . $idR . ')" style="width: 100%;" class="btn btn-success">Paid</button>'; } else { if ($obj->status == "0") { $obj->status = '<button type="button" id="button' . $idR . '" onclick="updateStatusCashout(' . $obj->status . ',' . $idR . ')" style="width: 100%;" class="btn btn-danger">Pay Now</button>'; } } } if (isset($obj->id_restaurant)) { if ($obj->id_restaurant != "") { $r = new MasterRestaurantModel(); $r->getByID($obj->id_restaurant); $obj->id_restaurant = $r->name; } } if (isset($obj->datetime_request)) { $d = strtotime("{$obj->datetime_request}"); $obj->datetime_request = date("d M, y h:m a", $d); } } ?> <script> function updateStatusCashout(status, id) { if (status == "1") { alert("ID " + id + " Already Paid"); return; } else { if (!confirm("Set Request to Paid?")) { return; } } $.ajax({ method: "GET", url: _sppath + "MasterCashOutRequest/setCashOutPaid", data: {id_request: id} }) .done(function (msg) { console.log(msg); var json_obj = $.parseJSON(msg);//parse JSON var statusCode = json_obj.status_code; if (statusCode == 0) { alert(json_obj.status_message); } else { alert(json_obj.status_message); } lwrefresh('CashOutRequest'); }); } </script> <?php return $return; }
public function overwriteForm($return, $returnfull) { $return['status'] = new Leap\View\InputSelect(array("1" => "Free", "0" => "Occupied"), "status", "status", $this->status); $return['availability'] = new Leap\View\InputSelect(array("1" => "Active", "0" => "Inactive"), "availability", "availability", $this->availability); $resto = new MasterRestaurantModel(); $resto->getByID($this->id_restaurant); $return['id_restaurant'] = new \Leap\View\InputText("hidden", "id_restaurant", "id_restaurant", $this->id_restaurant); $return['resto_name'] = new \Leap\View\InputText("text", "resto_name", "resto_name", $resto->name); $return['resto_name']->setReadOnly(true); return $return; }
public function overwriteForm($return, $returnfull) { $resto = new MasterRestaurantModel(); $res = $resto->getAll(); foreach ($res as $value) { $arrHelp[$value->id_restaurant] = $value->name; } $return['id_restaurant'] = new Leap\View\InputSelect($arrHelp, "id_restaurant", "id_restaurant", $this->id_restaurant); $return['status'] = new Leap\View\InputSelect(array("1" => "Active", "0" => "Inactive"), "status", "status", $this->status); return $return; }
public function overwriteRead($return) { $objs = $return['objs']; foreach ($objs as $obj) { if (isset($obj->id_restaurant)) { $resto = new MasterRestaurantModel(); $resto->getByID($obj->id_restaurant); $obj->id_restaurant = $resto->name; } } return $return; }
public function overwriteRead($return) { $objs = $return['objs']; foreach ($objs as $obj) { if (isset($obj->id_restaurant)) { $resto = new MasterRestaurantModel(); $resto->getByID($obj->id_restaurant); $obj->id_restaurant = $resto->name; } if (isset($obj->start)) { $date = new DateTime($obj->start); $obj->start = $date->format('d.m.Y'); } if (isset($obj->end)) { $dateEnd = new DateTime($obj->end); $obj->end = $dateEnd->format('d.m.Y'); } ?> <script> $(document).ready(function () { var date = new Date(); var i = 1; while ($('#id_MR_' + i).text().trim()) { var dateEndNow = $('#end_' + i).text().trim(); var dt1 = parseInt(dateEndNow.substring(0, 2)); var mon1 = parseInt(dateEndNow.substring(3, 5)); var yr1 = parseInt(dateEndNow.substring(6, 10)); var dateEnd = new Date(yr1, mon1 - 1, dt1); var diff = dateEnd - date, sign = diff < 0 ? -1 : 1, milliseconds, seconds, minutes, hours, days; diff = (diff - (milliseconds = diff % 1000)) / 1000; diff = (diff - (seconds = diff % 60)) / 60; diff = (diff - (minutes = diff % 60)) / 60; days = (diff - (hours = diff % 24)) / 24; if(days <2){ $("#MRDiscountModel_" + i).css("background-color", "red"); } else{ $("#MRDiscountModel_" + i).css("background-color", "yellow"); } i = i + 1; } }); </script> <?php } return $return; }
public function overwriteForm($return, $returnfull) { $return = parent::overwriteForm($return, $returnfull); $userModel = new UserModel(); $arrUser = $userModel->getAll(); foreach ($arrUser as $value) { $arrUserHelp[$value->id_user] = $value->user_name; } $return['inv_from'] = new Leap\View\InputSelect($arrUserHelp, "inv_from", "inv_from", $this->inv_from); $resto = new MasterRestaurantModel(); $res = $resto->getAll(); foreach ($res as $value) { $arrHelp[$value->id_restaurant] = $value->name; } $return['inv_id_resto'] = new Leap\View\InputSelect($arrHelp, "inv_id_resto", "inv_id_resto", $this->inv_id_resto); return $return; }
public function requestCashOut() { if (Efiwebsetting::getData('checkOAuth') == 'yes') { IMBAuth::checkOAuth(); } $idResto = Generic::mustCheck($_GET['id_restaurant'], "No ID Restaurant Found"); $amount = Generic::mustCheck($_GET['amount'], "No Amount Found"); if ($amount == "0") { Generic::errorMsg("Zero Amount not Allowed"); } $bankAcc = new RestoBankAccModel(); $arrBank = $bankAcc->getWhere("id_restaurant='{$idResto}'"); if (count($arrBank) <= 0) { Generic::errorMsg("You Have Not Set Your Cash Out Account"); } $req = new MasterCashOutRequestModel(); $arrReq = $req->getWhere("id_restaurant='{$idResto}' AND status='0'"); if (count($arrReq) > 0) { Generic::errorMsg("You Already Request Cash Out"); } $resto = new MasterRestaurantModel(); $resto->getByID($idResto); $cashOut = new MasterCashOutRequestModel(); $cashOut->id_restaurant = $idResto; $cashOut->datetime_request = leap_mysqldate(); $cashOut->amount = $amount; $cashOut->status = 0; $idNewRequest = $cashOut->save(); $tr = new MasterRestoTransactionModel(); $tr->id_request = $idNewRequest; $tr->id_restaurant = $idResto; $tr->gross_amount = (double) $amount * -1; $tr->net_amount = (double) $amount * -1; $tr->approved = "0"; $tr->type_transaction = "2"; $tr->datetime_transaction = leap_mysqldate(); $tr->mr_fee = 0; $tr->credit_card_fee = 0; $tr->other_fee = 0; $tr->bank_disc = 0; $tr->save(); $json['status_code'] = 1; $json['results']['messages'] = "success"; echo json_encode($json); die; }
public function unactivateTag($id_tag) { $r = new MasterRestaurantModel(); $arrResto = $r->getAll(); foreach ($arrResto as $resto) { if ($resto->restaurant_tags == null || $resto->restaurant_tags == "") { continue; } $arrTags = explode(",", $resto->restaurant_tags); for ($i = 0; $i < count($arrTags); $i++) { if ($arrTags[$i] == $id_tag) { unset($arrTags[$i]); $resto->restaurant_tags = implode(",", array_unique($arrTags)); $resto->save(); break; } } } }
public function requestRestoPermission($userModel, $tableModel, $paymentMethod) { $resto = new MasterRestaurantModel(); $resto->getByID($tableModel['id_restaurant']); //TODO CHECK RESTAURANT EMPTY, IF EMPTY goto ERROR() -> sdh di kerjakan if ($resto == null) { Generic::errorMsg("Restaurant is empty"); } $msg = $userModel->user_name . " want to open table no. " . $tableModel['table_number']; $j["user_id"] = $userModel->id_user; $j["user_name"] = $userModel->full_name; $j["user_pic"] = _BPATH . _PHOTOURL . $userModel->pic; $j["id_table"] = $tableModel['id_table']; $j["table_number"] = $tableModel['table_number']; $j["payment_method"] = $paymentMethod; $j['datetime'] = date('Y-m-d H:i:s'); $restoId = $tableModel['id_restaurant']; $this->pushToRestoCashier($tableModel['id_restaurant'], $msg, json_encode($j), Push::$typeRequestOpenTable); }
/** * Invoice constructor. */ public function __construct($idOrder, $calcPending = 1) { $this->calcPending = $calcPending; $this->idOrder = $idOrder; $order = new MasterOrderModel(); $order->getByID($idOrder); $restaurant = new MasterRestaurantModel(); $restaurant->getByID($order->id_restaurant); $this->idRestaurant = $order->id_restaurant; $this->restaurantName = $restaurant->name; $user = new UserModel(); $user->getByID($order->id_user); $this->idUser = $order->id_user; $this->userName = $user->full_name; $this->paymentMethod = $order->payment_method; $this->discRestaurant = $restaurant->disc_resto; $this->discMR = Util::getDiscountMR($order->id_restaurant); $this->feeMR = Util::getFeeMR($order->id_restaurant); if ($order->payment_method == Keys::$PAYMENT_TYPE_CREDIT_CARD) { $this->discBank = Util::getDiscountCreditCard($order->id_restaurant, $user->payment_bank_id); $this->feeNominalBank = Util::getFeeNominalCreditCard($order->id_restaurant, $user->payment_bank_id); $this->feePercentBank = Util::getFeePercentCreditCard($order->id_restaurant, $user->payment_bank_id); } else { if ($order->payment_method == Keys::$PAYMENT_TYPE_DOKU_WALLET) { $this->discBank = 0; $this->feeNominalBank = 0; $this->feePercentBank = 0; } else { $this->discBank = 0; $this->feeNominalBank = 0; $this->feePercentBank = 0; } } $this->serviceCharge = $restaurant->service_charge; $this->taxCharge = $restaurant->tax_pb_1; $this->otherCharge = $restaurant->other_charge; $this->updateSubTotal(); $this->assignValue(); }
public function overwriteRead($return) { $objs = $return['objs']; foreach ($objs as $obj) { if (isset($obj->id_restaurant)) { if ($obj->id_restaurant != "") { $r = new MasterRestaurantModel(); $r->getByID($obj->id_restaurant); $obj->id_restaurant = $r->name; } } if (isset($obj->type_transaction)) { if ($obj->type_transaction == "1") { $obj->type_transaction = "User Transaction"; } elseif ($obj->type_transaction == "2") { $obj->type_transaction = "Cash Out Request"; } else { $obj->type_transaction = "Error"; } } if (isset($obj->approved)) { if ($obj->approved == "1") { $obj->approved = "Yes"; } elseif ($obj->approved == "0") { $obj->approved = "No"; } else { $obj->approved = "Error"; } } if (isset($obj->datetime_transaction)) { $d = strtotime("{$obj->datetime_transaction}"); $obj->datetime_transaction = date("d M Y h:m a", $d); } } return $return; }
function formCreatedQR() { ?> <form class="form_crud" role="form" method="POST" action="<?php echo _SPPATH . "QR/createQRbyRestoID"; ?> "> <div class="form-group"> <label for="quantityQR" class="col-sm-2 control-label">ID-Restaurant</label> <div class="col-sm-10"> <?php $objResto = new MasterRestaurantModel(); $arrResto = $objResto->getAll(); foreach ($arrResto as $resto) { $arrRestoID[] = $resto->id_restaurant; $arrRestoName[] = $resto->name; } $t = time(); ?> <select id="selectresto_<?php echo $t; ?> " name ='id_restaurant' class="form-control"> <?php foreach ($arrRestoID as $n => $name) { ?> <option value="<?php echo $arrRestoID[$n]; ?> "><?php echo $arrRestoName[$n]; ?> </option> <?php } ?> </select> </div> <label for="quantityQR" class="col-sm-2 control-label">Quantity</label> <div class="col-sm-10"> <input type="text" class="form-control" id="quantityQR" name = "quantityQR" placeholder="Quantity" required> </div> </div> <div class="form-group"> <div class="col-sm-offset-2 col-sm-1"> <button type="submit" class="btn btn-default">Submit</button> </div> </div> </form> <?php }
public function getCategoriesByResto() { if (Efiwebsetting::getData('checkOAuth') == 'yes') { IMBAuth::checkOAuth(); } $idRestaurant = Generic::mustCheck($_GET['id_restaurant'], Keys::$ERR_NOT_FOUND_ID_RESTAURANT); $objResto = new MasterRestaurantModel(); $objResto->getByID($idRestaurant); if (!Generic::IsNullOrEmptyString($objResto->id_categories)) { $arrCategories = explode(",", $objResto->id_categories); } else { $arrCategories = array(); } $categories = array(); foreach ($arrCategories as $idCat) { $c = new MasterCategoryModel(); $c->getByID($idCat); if ($c->id_category) { $categories[] = $c->name; } } // pr($arrCategories); // pr($categories); $results['categories'] = $categories; $rawTags = array(); $id_dish = isset($_GET['id_dish']) ? addslashes($_GET['id_dish']) : ""; if ($id_dish) { $dish = new MasterDishModel(); $dish->getByID($id_dish); $tagsIds = explode(",", $dish->dish_tags); if (count($tagsIds) != 0) { foreach ($tagsIds as $tagsId) { if ($tagsId == null || $tagsId == "") { continue; } $dishTag = new MasterDishTagModel(); $dishTag->getByID($tagsId); $b["id_tag"] = $dishTag->id_tag; $b["name"] = $dishTag->name; $rawTags[] = $b; } } } $results['raw_tags'] = $rawTags; Generic::finish($results); }
public function loadHomeFav() { 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"); } $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"); } $begin = ($page - 1) * $limit; $json = array(); $sem = array(); global $db; $objRestaurant = new MasterRestaurantModel(); $exp = explode(",", str_replace(" ", "", $objRestaurant->crud_webservice_allowed)); $arrPicsToAddPhotoUrl = $objRestaurant->crud_add_photourl; $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} HAVING distance < 1000000 ORDER by fav DESC, DISTANCE ASC LIMIT {$begin},{$limit}"; $arr = $db->query($q, 2); $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["distance"] = sqrt(pow(69.09999999999999 * ($o->latitude - $currentLat), 2) + pow(69.09999999999999 * ($currentLong - $o->longitude) * cos($o->latitude / 57.3), 2)); $json["results"]['restaurant'][] = $sem; } echo json_encode($json); die; }
public function addDishToMyFavorite() { if (Efiwebsetting::getData('checkOAuth') == 'yes') { IMBAuth::checkOAuth(); } $idUser = Generic::mustCheck($_GET['id_user'], "User ID not Found"); $idDish = Generic::mustCheck($_GET['id_dish'], "Dish ID not Found"); $user = new UserModel(); $user->getByID($idUser); $arrFavDishIds = explode(',', $user->fav_dishes_ids); $alreadyInFavorite = count($arrFavDishIds) <= 0 ? false : in_array($idDish, $arrFavDishIds); if ($alreadyInFavorite) { Generic::errorMsg("Already Favorited"); } if (count($arrFavDishIds) <= 0) { $user->fav_dishes_ids = $idDish; } else { $arrFavDishIds[] = $idDish; $arrFavDishIds = array_unique($arrFavDishIds); $user->fav_dishes_ids = implode(',', $arrFavDishIds); } $dish = new MasterDishModel(); $dish->getByID($idDish); $dish->fav = $dish->fav + 1; $dish->save(); $resto = new MasterRestaurantModel(); $resto->getByID($dish->id_restaurant); $resto->fav = $resto->fav + 1; $resto->save(); $user->save(); $this->success(); }
public function createQRbyRestoID() { $id_restaurant = $_GET['id_restaurant']; $quantityQR = $_GET['quantityQR']; $id_request = $_GET['id_request']; $objResto = new MasterRestaurantModel(); $objResto->getByID($id_restaurant); $objResto->table_quantity = $objResto->table_quantity + $quantityQR; $objResto->load = 1; $objResto->save(); // pr($objResto); $objQRRequest = new QRRequestModel(); $objQRRequest->getByID($id_request); $objQRRequest->createdOn = leap_mysqldate(); // pr($objQRRequest); $objQRRequest->status = "1"; $objQRRequest->load = 1; $objQRRequest->save(); $objQR = new QRModel(); global $db; $qtydiDB = "SELECT max(id_qr) as max from menurevo__QR"; $arr = $db->query($qtydiDB, 1); for ($i = $arr->max + 1; $i <= $quantityQR + $arr->max; $i++) { $encode = addslashes(base64_encode($i)); $q = "INSERT INTO menurevo__QR (id_qr, textQR,status) VALUES({$i},'{$encode}',0)"; $id = $db->query($q, 1); } $pdf = new FPDF(); $myarray = array(1, 2, 3); $pdf->SetFont('Arial', 'B', 16); for ($i = $arr->max + 1; $i <= $quantityQR + $arr->max; $i++) { $pdf->AddPage(); $pdf->Image("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chld=L|0&chl=" . base64_encode($i), 60, 30, 90, 0, 'PNG'); $pdf->Text(85, 130, "Menu Revolution"); } $pdf->Output(); ?> <html> <head> <title>Print QR-Code</title> <style> body{ margin: 0; padding: 0; font-family: verdana;} </style> </head> <body> <?php for ($i = $arr->max + 1; $i <= $quantityQR + $arr->max; $i++) { ?> <!-- <div style="width:800px; border-bottom: 3px dashed #aaaaaa; margin-bottom: 20px;"> <img src="<?php echo _SPPATH; ?> images/headerleap.jpg" width="100%">--> <div style="padding:40px; text-align: center;"> <!--<div style="letter-spacing: 2px; font-size: 18px; font-weight: bold; padding-bottom: 20px;"> <?php echo $mur->admin_nama_depan; ?> </div>--> <img src="<?php echo "https://chart.googleapis.com/chart?chs=150x150&cht=qr&chld=L|0&chl=" . base64_encode($i); ?> "alt="QR"> </div> <!--</div>--> <?php } ?> </body> </html><?php die('finished'); }
public function updateRestoMRFee() { $idsResto = Generic::mustCheck($_POST['id_restaurant'], "No Restaurant IDs Found"); $fee = Generic::mustCheck($_POST['fee'], "No Fee Found"); if (!is_numeric($fee)) { Generic::errorMsg("Fee Must Numbers"); } if (doubleval($fee) > 100) { Generic::errorMsg("Fee Max 100%"); } $ids = explode(',', $idsResto); if (count($ids) <= 0) { Generic::errorMsg("Empty Id"); } $updateAll = in_array('0', $ids); if ($updateAll) { $r = new MasterRestaurantModel(); $arrR = $r->getAll(); foreach ($arrR as $singleR) { unset($resto); $resto = new MasterRestaurantModel(); $resto->getByID($singleR->id_restaurant); $log = new LogDiscFeeModel(); $log->id_reference = $singleR->id_restaurant; $log->change_type = "Fee MR"; $log->change_from = Generic::IsNullOrEmptyString($resto->mr_fee) ? "0" : $resto->mr_fee; $log->change_to = $fee; $log->change_date_time = leap_mysqldate(); $log->save(); $resto->mr_fee = $fee; $resto->save(); } } else { foreach ($ids as $id) { unset($resto); $resto = new MasterRestaurantModel(); $resto->getByID($id); $log = new LogDiscFeeModel(); $log->id_reference = $id; $log->change_type = "Fee MR"; $log->change_from = Generic::IsNullOrEmptyString($resto->mr_fee) ? "0" : $resto->mr_fee; $log->change_to = $fee; $log->change_date_time = leap_mysqldate(); $log->save(); $resto->mr_fee = $fee; $resto->save(); } } $json['status_code'] = 1; $json['status_message'] = "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 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 ""; } }
private function viewSearchTerm($searchType, $searchTerm) { switch ($searchType) { case "1": $rt = new MasterRestaurantTypeModel(); $rt->getByID($searchTerm); return $rt->name; case "2": $r = new MasterCategoryModel(); $r->getByID($searchTerm); return $r->name; case "3": $r = new CuisineModel(); $r->getByID($searchTerm); return $r->name_cuisine; // case "4": { // return new Leap\View\InputText("text", "search_term", "search_term", $this->search_term); // } // case "5": { // $r = new MasterDishTagModel(); // $r->getByID($searchTerm); // return $r->name; // } // 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(); // $r->getByID($searchTerm); // return $r->name; // } // case "6": { // return new Leap\View\InputText("text", "search_term", "search_term", $this->search_term); // } case "7": $r = new MasterRestaurantModel(); $r->getByID($searchTerm); return $r->name; case "8888": return "Not Available"; default: return "Not Available"; } }
public static function isRestaurantOpen($idResto) { $resto = new MasterRestaurantModel(); $resto->getByID($idResto); return $resto->now_open == "1"; }
public function sendwithreturn() { if (Efiwebsetting::getData('checkOAuth') == 'yes') { IMBAuth::checkOAuth(); } $json = array(); $json['status_code'] = 1; $idOrder = $_GET['id_order']; $toEmail = $_GET['email']; $order = new MasterOrderModel(); $order->getByID($idOrder); $resto = new MasterRestaurantModel(); $resto->getByID($order->id_restaurant); $subject = "Your receipt from " . $restoName . " , Receipt#" . $idOrder; $od = new OrderDetailModel(); $d = new MasterDishModel(); // $dompdf = new Dompdf\Dompdf(); global $db; $q = "SELECT {$od->table_name}.id_dish, {$d->table_name}.name, SUM(quantity) AS sum_qty, {$d->table_name}.price,\nSUM({$od->table_name}.price) AS sum_price, status_progress FROM `{$od->table_name}`\nRIGHT JOIN {$d->table_name} ON {$od->table_name}.id_dish = {$d->table_name}.id_dish WHERE id_order='{$idOrder}' GROUP BY id_dish"; $arrDetails = $db->query($q, 2); $css_boot = _BPATH . "themes/tbstheme_ori/css/bootstrap.min.css"; $image1 = _BPATH . _PHOTOURL . $resto->image_logo; if ($image1 == "") { $image1 = _BPATH . _PHOTOURL . "noimage.jpg"; } $head = "<html xmlns=\"http://www.w3.org/1999/xhtml\">"; $head = "<head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" /><title>Notification email</title>"; $head = $head . "<link href=" . $css_boot . " rel=\"stylesheet\">"; $head = $head . "<link href=\"https://fonts.googleapis.com/css?family=Roboto+Condensed:400,700&subset=latin,latin-ext\" rel=\"stylesheet\" type=\"text/css\">"; $head = $head . "</head>"; $html = "<div style=\"max-width: 800px; box-shadow: 0 0 10px rgba(0, 0, 0, .15); font-size: 16px; line-height: 24px; font-family: 'Helvetica Neue', 'Helvetica', Helvetica, Arial, sans-serif; color: #555; margin: auto; padding: 30px; border: 1px solid #eee;\">\n<table style=\"width: 100%; line-height: inherit; text-align: left;\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td style=\"vertical-align: top; padding: 5px;\" colspan=\"2\">\n<table style=\"width: 100%; line-height: inherit; text-align: left;\">\n<tbody>\n<tr>\n<td style=\"vertical-align: top; font-size: 45px; line-height: 45px; color: #333; width: 50%; display: block; text-align: left; padding: 5px 5px 20px;\" align=\"left\" valign=\"top\"><img style=\"width: 50%; max-width: 300px;\" src=" . $image1 . " alt=\"\" /></td>\n</tr>\n<tr>\n<td style=\"vertical-align: top; width: 100%; display: block; text-align: left; padding: 5px 5px 40px;\" align=\"center\" valign=\"top\">"; $html = $html . "<strong>" . $resto->name . "</strong><br />"; $html = $html . $resto->district . " - " . $resto->city . " <br>"; $html = $html . "Phone : " . $resto->phone_no . "</td>"; $html = $html . "</tr>\n</tbody>\n</table>\n</td>\n</tr>\n<tr>\n<td style=\"vertical-align: top; padding: 5px;\" colspan=\"2\" valign=\"top\">\n<table style=\"width: 100%; line-height: inherit; text-align: left;\">\n<tbody>\n<tr>\n<td style=\"vertical-align: top; text-align: left; t width: 50%; display: block; padding: 5px 5px 20px;\" align=\"left\" valign=\"top\">"; $html = $html . "</tr>"; $html = $html . "Receipt #: " . $idOrder; $html = $html . "<br/>"; $html = $html . " Server : "; if ($order->type_order == "1" || $order->type_order == "3") { $html = $html . "Apps Order"; } else { $html = $html . $order->server_name; } $html = $html . "<br/>"; $html = $html . " Time Order : " . date("d M, Y H:m", strtotime($order->datetime_order)); $html = $html . "<br/>"; $html = $html . " Payment Method : " . Generic::selectPaymentMethod($order->status_payment); $html = $html . "<br/>"; if ($order->type_order == "1" || $order->type_order == "3") { $html = $html . "Apps Order"; } else { $html = $html . "Manual Order"; } $html = $html . "<br/>"; $html = $html . "</td>"; $html = $html . "</tr> \n</tbody>\n</table>\n</td>\n</tr>\n<tr>\n<td style=\"vertical-align: top; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: #ddd; font-weight: bold; background-color: #eee; padding: 5px;\" valign=\"top\" bgcolor=\"#eee\">Item</td>\n<td style=\"vertical-align: top; text-align: right; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: #ddd; font-weight: bold; background-color: #eee; padding: 5px;\" align=\"center\" valign=\"top\" bgcolor=\"#eee\">#</td>\n<td style=\"vertical-align: top; text-align: right; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: #ddd; font-weight: bold; background-color: #eee; padding: 5px;\" align=\"right\" valign=\"top\" bgcolor=\"#eee\">Price</td>\n <td style=\"vertical-align: top; text-align: right; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: #ddd; font-weight: bold; background-color: #eee; padding: 5px;\" align=\"right\" valign=\"top\" bgcolor=\"#eee\">Total</td>\n</tr>"; foreach ($arrDetails as $details) { $void = ""; if ($details->status_progress == "9") { $void = "<strong> Voided </strong>"; $details->price = 0; $details->sum_price = 0; } $html = $html . "<tr><td style=\"vertical-align: top; border-bottom-width: 1px; border-bottom-color: #eee; border-bottom-style: solid; padding: 5px;\" valign=\"top\">" . $details->name . $void . "</td>"; $html = $html . "<td style=\"vertical-align: top; text-align: right; border-bottom-width: 1px; border-bottom-color: #eee; border-bottom-style: solid; padding: 5px;\" align=\"right\" valign=\"top\">" . $details->sum_qty . "</td>"; $html = $html . "<td style=\"vertical-align: top; text-align: right; border-bottom-width: 1px; border-bottom-color: #eee; border-bottom-style: solid; padding: 5px;\" align=\"right\" valign=\"top\">" . Generic::formatRupiah($details->price) . "</td>"; $html = $html . "<td style=\"vertical-align: top; text-align: right; border-bottom-width: 1px; border-bottom-color: #eee; border-bottom-style: solid; padding: 5px;\" align=\"right\" valign=\"top\">" . Generic::formatRupiah($details->sum_price) . "</td></tr>"; } $html = $html . "<tr>\n<td style=\"vertical-align: top; text-align: right; border-top-style: solid; border-top-width: 2px; border-top-color: #eee; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\"></td>\n<td style=\"vertical-align: top; text-align: right; border-top-style: solid; border-top-width: 2px; border-top-color: #eee; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\"></td>\n<td style=\"vertical-align: top; text-align: right; border-top-style: solid; border-top-width: 2px; border-top-color: #eee; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\">Total : </td>\n<td style=\"vertical-align: top; text-align: right; border-top-style: solid; border-top-width: 2px; border-top-color: #eee; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\">" . Generic::formatRupiah($order->total_cost) . "</td>\n</tr>\n<tr>\n<td style=\"vertical-align: top; text-align: right; border-top-style: solid; border-top-width: 2px; border-top-color: #eee; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\"></td>\n<td style=\"vertical-align: top; text-align: right; border-top-style: solid; border-top-width: 2px; border-top-color: #eee; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\"></td>\n<td style=\"vertical-align: top; text-align: right; border-top-style: solid; border-top-width: 2px; border-top-color: #eee; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\">Disc Resto : </td>\n<td style=\"vertical-align: top; text-align: right; border-top-style: solid; border-top-width: 2px; border-top-color: #eee; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\">" . Generic::formatRupiah($order->disc_resto) . "</td>\n</tr>\n<tr>\n<td style=\"vertical-align: top; text-align: right; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\"></td>\n<td style=\"vertical-align: top; text-align: right; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\"></td>\n<td style=\"vertical-align: top; text-align: right; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\">Disc Credit Card : </td>\n<td style=\"vertical-align: top; text-align: right; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\">" . Generic::formatRupiah($order->disc_bank) . "</td>\n</tr>\n<tr>\n<td style=\"vertical-align: top; text-align: right; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\"></td>\n<td style=\"vertical-align: top; text-align: right; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\"></td>\n<td style=\"vertical-align: top; text-align: right; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\">Disc MR : </td>\n<td style=\"vertical-align: top; text-align: right; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\">" . Generic::formatRupiah($order->disc_mr) . "</td>\n</tr>\n\n<tr>\n<td style=\"vertical-align: top; text-align: right; border-top-style: solid; border-top-width: 2px; border-top-color: #eee; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\"></td>\n<td style=\"vertical-align: top; text-align: right; border-top-style: solid; border-top-width: 2px; border-top-color: #eee; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\"></td>\n<td style=\"vertical-align: top; text-align: right; border-top-style: solid; border-top-width: 2px; border-top-color: #eee; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\">Tax PB1 : </td>\n<td style=\"vertical-align: top; text-align: right; border-top-style: solid; border-top-width: 2px; border-top-color: #eee; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\">" . Generic::formatRupiah($order->tax_pb1) . "</td>\n</tr>\n<tr>\n<td style=\"vertical-align: top; text-align: right; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\"></td>\n<td style=\"vertical-align: top; text-align: right; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\"></td>\n<td style=\"vertical-align: top; text-align: right; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\">Service Charge : </td>\n<td style=\"vertical-align: top; text-align: right; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\">" . Generic::formatRupiah($order->tax_pb1) . "</td>\n</tr>\n<tr>\n<td style=\"vertical-align: top; text-align: right; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\"></td>\n<td style=\"vertical-align: top; text-align: right; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\"></td>\n<td style=\"vertical-align: top; text-align: right; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\">Other Charge : </td>\n<td style=\"vertical-align: top; text-align: right; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\">" . Generic::formatRupiah($order->tax_pb1) . "</td>\n</tr>\n<tr>\n<td style=\"vertical-align: top; text-align: right; border-top-style: solid; border-top-width: 2px; border-top-color: #eee; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\"></td>\n<td style=\"vertical-align: top; text-align: right; border-top-style: solid; border-top-width: 2px; border-top-color: #eee; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\"></td>\n<td style=\"vertical-align: top; text-align: right; border-top-style: solid; border-top-width: 2px; border-top-color: #eee; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\">Grand Total :</td>\n<td style=\"vertical-align: top; text-align: right; border-top-style: solid; border-top-width: 2px; border-top-color: #eee; font-weight: bold; padding: 5px;\" align=\"right\" valign=\"top\">" . Generic::formatRupiah($order->grand_total) . "</td>\n</tr>\n\n</tbody>\n</table>\n</div></html>"; $html = $head . $html; $mail = new Leapmail(); $res = $mail->sendEmailHTML($toEmail, $subject, $html); return $res; }
public function reportFee() { $id_restaurant = isset($_GET['id_restaurant']) ? addslashes($_GET['id_restaurant']) : "0"; $type_order = isset($_GET['type_order']) ? addslashes($_GET['type_order']) : "8"; $dateVon = isset($_GET['dateVon']) ? addslashes($_GET['dateVon']) : date('Y-m-d', time()); $dateBis = isset($_GET['dateBis']) ? addslashes($_GET['dateBis']) : date('Y-m-d', time()); // $dateBis = isset($_GET['dateBis']) ? addslashes($_GET['dateBis']) : Generic::setCurrentDate(); $id_server = isset($_GET['id_server']) ? addslashes($_GET['id_server']) : "0"; $status_payment = isset($_GET['status_payment']) ? addslashes($_GET['status_payment']) : 0; $status_progress = isset($_GET['status_progress']) ? addslashes($_GET['status_progress']) : 4; $objResto = new MasterRestaurantModel(); $arrResto = $objResto->getAll(); $arrRestoIndex[0] = "All"; foreach ($arrResto as $resto) { if ($resto->name != "") { $arrRestoIndex[$resto->id_restaurant] = $resto->name; } } $objOrder = new MasterOrderModel(); $first_key = key($arrRestoIndex); $arrOrder = $objOrder->getWhere("id_restaurant='{$id_restaurant}'"); $arrRestoUserIndex[0] = "All"; foreach ($arrOrder as $val) { $user = RestaurantUser::getRestaurantUserName($val->id_server); if ($user != "") { $arrRestoUserIndex[$val->id_server] = $user; } } $arrTypeOrder[0] = "Dine In - Manual"; $arrTypeOrder[1] = "Dine In - Apps"; $arrTypeOrder[2] = "Take Away - Manual"; $arrTypeOrder[3] = "Take Away - Apps"; $arrTypeOrder[4] = "All Manual Order"; $arrTypeOrder[5] = "All Apps Order"; $arrTypeOrder[6] = "All Dine In Order"; $arrTypeOrder[7] = "All Take Away Order"; $arrTypeOrder[8] = "All Order Types"; $arrStatusPaymentMethod[1] = "Cash"; $arrStatusPaymentMethod[2] = "Credit Card"; $arrStatusPaymentMethod[3] = "Others"; $arrStatusPaymentMethod[0] = "All Payment Method"; $arrStatusProgress[4] = "Done"; $arrStatusProgress[9] = "Void"; $t = time(); $where = " "; if ($id_restaurant == 0) { $where = $where; } else { $allResto = false; $where = $where . " resto.id_restaurant='{$id_restaurant}' AND "; } if ($type_order == "8") { } else { $where = $where . " o.type_order='{$type_order}' AND "; } if ($dateVon == "") { ?> <?php $dateVon = Generic::setCurrentDate(); } else { $date = new DateTime($dateVon); // $dateVon = leap_mysqldate_isi(date('Y-m-d H:i:s')); // pr($dateVon); $where = $where . " o.datetime_order >='{$dateVon}' AND "; } if ($dateBis == "") { $dateBis = Generic::setCurrentDate(); } else { $date = new DateTime($dateVon); $where = $where . " o.datetime_order <= '{$dateBis}' AND "; } if ($id_server == "0") { $where = $where; } else { $where = $where . " o.id_server='{$id_server}' AND "; } if ($status_payment == "" | $status_payment == "0") { $where = $where; } else { $where = $where . " o.status_payment='{$status_payment}' AND "; } if ($status_progress == "") { } else { $where = $where . " o.status_progress='{$status_progress}' "; } $objOrder = new MasterOrderModel(); $objResto = new MasterRestaurantModel(); $objOrderDetail = new OrderDetailModel(); $objDish = new MasterDishModel(); global $db; $q = "SELECT o.datetime_order as dateOrder,o.datetime_order as timeOrder , resto.name, o.id_order, o.mr_fee, o.cc_fee, o.mr_fee+o.cc_fee as Total FROM {$objResto->table_name} resto INNER JOIN {$objOrder->table_name} o ON resto.id_restaurant = o.id_restaurant"; // $q = $q . " INNER JOIN {$objOrderDetail->table_name} orderdetail ON o.id_order = orderdetail.id_order "; // $q = $q . " INNER JOIN {$objDish->table_name} dish ON orderdetail.id_dish = dish.id_dish "; $q = $q . " WHERE " . $where; // pr($q); $arrQuery = $db->query($q, 2); // pr($arrQuery); // die(); // $data = json_encode($arrQuery); $data = $arrQuery; // pr($arrRestoIndex); ?> <div class="col-md-12"> <div class="col-sm-12"> <h1>Reporting Fee</h1> </div> <div id="formgroup_selected_restaurant" class="form-group"> <div class='col-sm-6'> <select id = "restoID_<?php echo $t; ?> " class="form-control"> <?php foreach ($arrRestoIndex as $key => $val) { if ($key == $_GET['id_restaurant']) { echo "<option selected='selected' value='" . $key . "'>" . $val . "</option>"; } else { echo "<option value='" . $key . "'>" . $val . "</option>"; } } ?> </select> </div> <div class='col-sm-6'> <select id = "type_order_<?php echo $t; ?> " class="form-control"> <?php foreach ($arrTypeOrder as $key => $val) { if ($key == $_GET['type_order']) { echo "<option selected='selected' value='" . $key . "'>" . $val . "</option>"; } else { echo "<option value='" . $key . "'>" . $val . "</option>"; } } ?> </select> </div> <div class="clearfix"></div> </div> <div id="formgroup_date" class="form-group"> <div class='col-sm-6'> <div class="form-group"> <div class='input-group date' id='datetimepickerFrom_<?php echo $t; ?> ' data-date-format="dd-mm-yyyy"> <input type='text' id= "dateVon_<?php echo $t; ?> "class="form-control" /> <span id = "cobaFrom" class="input-group-addon"> <span class="glyphicon glyphicon-calendar"></span> </span> </div> </div> </div> <div class='col-sm-6'> <div class="form-group"> <div class='input-group date' id='datetimepickerTo_<?php echo $t; ?> '> <input type='text' id= "dateBis_<?php echo $t; ?> " class="form-control" /> <span class="input-group-addon"> <span class="glyphicon glyphicon-calendar"></span> </span> </div> </div> </div> <div class="clearfix"></div> </div> <div id="formgroup_server" class="form-group"> <div class='col-sm-6'> <select id = "selectServer_<?php echo $t; ?> " class="form-control"> <?php foreach ($arrRestoUserIndex as $key => $val) { if ($key == $_GET['id_server']) { echo "<option selected='selected' value='" . $key . "'>" . $val . "</option>"; } else { echo "<option value='" . $key . "'>" . $val . "</option>"; } } ?> </select> </div> <div class='col-sm-6'> <select id = "status_payment_<?php echo $t; ?> " class="form-control"> <?php foreach ($arrStatusPaymentMethod as $key => $val) { if ($key == $_GET['status_payment']) { echo "<option selected='selected' value='" . $key . "'>" . $val . "</option>"; } else { echo "<option value='" . $key . "'>" . $val . "</option>"; } } ?> </select> </div> <div class="clearfix"></div> </div> <div id="formgroup_progress" class="form-group"> <div class='col-sm-6'> <select id = "status_progress_<?php echo $t; ?> " class="form-control"> <?php foreach ($arrStatusProgress as $key => $val) { if ($key == $_GET['status_progress']) { echo "<option selected='selected' value='" . $key . "'>" . $val . "</option>"; } else { echo "<option value='" . $key . "'>" . $val . "</option>"; } } ?> </select> </div> <div class="btn-group col-sm-4" role="group" aria-label="..."> <button type="button" class="btn btn-default" id="export_<?php echo $t; ?> ">Export</button> </div> <div class="clearfix"></div> </div> </div> <script type="text/javascript"> var dateFrom, dateTo; if (dateFrom == null) { var now = new Date(); var day = ("0" + now.getDate()).slice(-2); var month = ("0" + (now.getMonth() + 1)).slice(-2); var dateFrom = now.getFullYear() + "-" + (month) + "-" + (day); } if (dateTo == null) { var now = new Date(); var day = ("0" + now.getDate()).slice(-2); var month = ("0" + (now.getMonth() + 1)).slice(-2); var dateTo = now.getFullYear() + "-" + (month) + "-" + (day); } $('#restoID_<?php echo $t; ?> ').change(function () { var id_restaurant = $('#restoID_<?php echo $t; ?> ').val(); console.log("id_restaurant: " + id_restaurant); openLw("DiscountCC", "<?php echo _SPPATH; ?> Report/reportFee?id_server=0" + "&id_restaurant=" + id_restaurant + "&dateVon=" + dateFrom + "&dateBis=" + dateTo, "fade"); }); $('#type_order_<?php echo $t; ?> ').change(function () { var type_order = $('#type_order_<?php echo $t; ?> ').val(); console.log("type_order: " + type_order); var id_restaurant = $('#restoID_<?php echo $t; ?> ').val(); console.log("id_restaurant: " + id_restaurant); var server = $('#selectServer_<?php echo $t; ?> ').val(); console.log("server: " + server); var status_payment = $('#status_payment_<?php echo $t; ?> ').val(); var status_progress = $('#status_progress_<?php echo $t; ?> ').val(); openLw("DiscountCC", "<?php echo _SPPATH; ?> Report/reportFee?type_order=" + type_order + "&id_restaurant=" + id_restaurant + "&id_server=" + server + "&status_payment=" + status_payment + "&dateVon=" + dateFrom + "&dateBis=" + dateTo + "&status_progress=" + status_progress, "fade"); }); $('#selectServer_<?php echo $t; ?> ').change(function () { var type_order = $('#type_order_<?php echo $t; ?> ').val(); console.log("type_order: " + type_order); var id_restaurant = $('#restoID_<?php echo $t; ?> ').val(); console.log("id_restaurant: " + id_restaurant); var server = $('#selectServer_<?php echo $t; ?> ').val(); console.log("server: " + server); var status_payment = $('#status_payment_<?php echo $t; ?> ').val(); var status_progress = $('#status_progress_<?php echo $t; ?> ').val(); openLw("DiscountCC", "<?php echo _SPPATH; ?> Report/reportFee?type_order=" + type_order + "&id_restaurant=" + id_restaurant + "&id_server=" + server + "&status_payment=" + status_payment + "&dateVon=" + dateFrom + "&dateBis=" + dateTo + "&status_progress=" + status_progress, "fade"); }); $('#status_payment_<?php echo $t; ?> ').change(function () { var type_order = $('#type_order_<?php echo $t; ?> ').val(); console.log("type_order: " + type_order); var id_restaurant = $('#restoID_<?php echo $t; ?> ').val(); console.log("id_restaurant: " + id_restaurant); var server = $('#selectServer_<?php echo $t; ?> ').val(); console.log("server: " + server); var status_payment = $('#status_payment_<?php echo $t; ?> ').val(); var status_progress = $('#status_progress_<?php echo $t; ?> ').val(); openLw("DiscountCC", "<?php echo _SPPATH; ?> Report/reportFee?type_order=" + type_order + "&id_restaurant=" + id_restaurant + "&id_server=" + server + "&status_payment=" + status_payment + "&dateVon=" + dateFrom + "&dateBis=" + dateTo + "&status_progress=" + status_progress, "fade"); }); $('#status_progress_<?php echo $t; ?> ').change(function () { var type_order = $('#type_order_<?php echo $t; ?> ').val(); console.log("type_order: " + type_order); var id_restaurant = $('#restoID_<?php echo $t; ?> ').val(); console.log("id_restaurant: " + id_restaurant); var server = $('#selectServer_<?php echo $t; ?> ').val(); console.log("server: " + server); var status_payment = $('#status_payment_<?php echo $t; ?> ').val(); var status_progress = $('#status_progress_<?php echo $t; ?> ').val(); openLw("DiscountCC", "<?php echo _SPPATH; ?> Report/reportFee?type_order=" + type_order + "&id_restaurant=" + id_restaurant + "&id_server=" + server + "&status_payment=" + status_payment + "&dateVon=" + dateFrom + "&dateBis=" + dateTo + "&status_progress=" + status_progress, "fade"); }); var datetimepickerFrom = $('#datetimepickerFrom_<?php echo $t; ?> '); var datetimepickerTo = $('#datetimepickerTo_<?php echo $t; ?> '); $('#dateVon_<?php echo $t; ?> ').change(function () { var type_order = $('#type_order_<?php echo $t; ?> ').val(); console.log("type_order: " + type_order); var id_restaurant = $('#restoID_<?php echo $t; ?> ').val(); console.log("id_restaurant: " + id_restaurant); var server = $('#selectServer_<?php echo $t; ?> ').val(); console.log("server: " + server); var status_payment = $('#status_payment_<?php echo $t; ?> ').val(); var status_progress = $('#status_progress<?php echo $t; ?> ').val(); openLw("DiscountCC", "<?php echo _SPPATH; ?> Report/reportFee?type_order=" + type_order + "&id_restaurant=" + id_restaurant + "&id_server=" + server + "&status_payment=" + status_payment + "&dateVon=" + dateFrom + "&dateBis=" + dateTo + "&status_progress=" + status_progress, "fade"); }); $('#export_<?php echo $t; ?> ').click(function () { <?php $_SESSION["data"] = $data; ?> // initializes and invokes show immediately window.open('<?php echo _SPPATH; ?> Report/exportIt', "_blank "); }); // $(function () { datetimepickerFrom.datetimepicker({ format: 'DD/MM/YYYY', defaultDate: dateFrom //Im,portant! See issue #1075 }); datetimepickerTo.datetimepicker({ format: 'DD/MM/YYYY', defaultDate: dateTo }); datetimepickerFrom.on("dp.change", function (e) { datetimepickerTo.data("DateTimePicker").minDate(e.date); var type_order = $('#type_order_<?php echo $t; ?> ').val(); console.log("type_order: " + type_order); var id_restaurant = $('#restoID_<?php echo $t; ?> ').val(); console.log("id_restaurant: " + id_restaurant); var server = $('#selectServer_<?php echo $t; ?> ').val(); console.log("server: " + server); var status_payment = $('#status_payment_<?php echo $t; ?> ').val(); dateFrom = new Date(e.date); console.log(e); if (e.oldDate != null) { dateFrom = new Date(); dateFrom = moment().format('DD/MM/YYYY'); } if (e.oldDate != null) { var changed = false; if (e.date != e.oldDate) { changed = true; console.log("olddate: " + e.oldDate.format('Y-M-D')); console.log("Date: " + e.date.format('Y-M-D')); console.log("dateVon_: " + $('#dateVon_<?php echo $t; ?> ').val()); var type_order = $('#type_order_<?php echo $t; ?> ').val(); console.log("type_order: " + type_order); var id_restaurant = $('#restoID_<?php echo $t; ?> ').val(); console.log("id_restaurant: " + id_restaurant); var server = $('#selectServer_<?php echo $t; ?> ').val(); console.log("server: " + server); var status_payment = $('#status_payment_<?php echo $t; ?> ').val(); var tglFrom = e.date.format('Y-M-D'); dateFrom = e.date.format('Y-M-D'); $('#dateVon_<?php echo $t; ?> ').val(dateFrom); var status_progress = $('#status_progress_<?php echo $t; ?> ').val(); if (changed) { openLw("DiscountCC", "<?php echo _SPPATH; ?> Report/reportFee?type_order=" + type_order + "&id_restaurant=" + id_restaurant + "&id_server=" + server + "&status_payment=" + status_payment + "&dateVon=" + dateFrom + "&dateBis=" + dateTo, "fade"); changed = false; } } } }); datetimepickerTo.on("dp.change", function (e) { datetimepickerFrom.data("DateTimePicker").maxDate(e.date); if (e.oldDate != null) { var changed = false; if (e.date != e.oldDate) { changed = true; console.log("olddate: " + e.oldDate.format('Y-M-D')); console.log("Date: " + e.date.format('Y-M-D')); console.log("dateBis_: " + $('#dateBis_<?php echo $t; ?> ').val()); var type_order = $('#type_order_<?php echo $t; ?> ').val(); console.log("type_order: " + type_order); var id_restaurant = $('#restoID_<?php echo $t; ?> ').val(); console.log("id_restaurant: " + id_restaurant); var server = $('#selectServer_<?php echo $t; ?> ').val(); console.log("server: " + server); var status_payment = $('#status_payment_<?php echo $t; ?> ').val(); var tglFrom = e.date.format('Y-M-D'); dateTo = e.date.format('Y-M-D'); var status_progress = $('#status_progress_<?php echo $t; ?> ').val(); $('#dateBis_<?php echo $t; ?> ').val(dateTo); if (changed) { openLw("DiscountCC", "<?php echo _SPPATH; ?> Report/reportFee?type_order=" + type_order + "&id_restaurant=" + id_restaurant + "&id_server=" + server + "&status_payment=" + status_payment + "&dateVon=" + dateFrom + "&dateBis=" + dateTo, "fade"); changed = false; } } } }); }); // $("[name='status_progress_<?php echo $t; ?> ']").bootstrapSwitch('state', true, true); </script> <div class="col-md-12"> <div class="table-responsive"> <table id = "table_report_<?php echo $t; ?> " class="table table-bordered table-striped table-hover crud-table" style="background-color: white;"> <tbody><tr> <th id="h_id_date_<?php echo $t; ?> ">Date</th> <th id="h_id_time_<?php echo $t; ?> ">Time</th> <th id="h_id_restaurant_<?php echo $t; ?> ">Restaurant</th> <th id="h_id_order_<?php echo $t; ?> ">Order No.</th> <th id="h_total_<?php echo $t; ?> ">MR Fee</th> <th id="h_disc_<?php echo $t; ?> ">Credit Card Fee</th> <th id="h_charges_<?php echo $t; ?> ">Total Fee</th> </tr> <?php foreach ($arrQuery as $key => $val) { ?> <tr id="report_<?php echo $t; ?> "> <?php $date = new DateTime($val->datetime_order); ?> <td id="id_date_<?php echo $t . "_" . $val->id_order; ?> "> <?php echo $date->format('d.m.Y'); ?> </td> <td id="id_time_<?php echo $t . "_" . $val->id_order; ?> "> <?php echo $date->format('H:i:s'); ?> </td> <td id="id_restaurant_<?php echo $t . "_" . $val->id_order; ?> "> <?php echo $val->name; ?> </td> <td id="id_order_<?php echo $t . "_" . $val->id_order; ?> "><?php echo $val->id_order; ?> </td> <td id="total_<?php echo $t . "_" . $val->id_order; ?> "><?php echo Generic::formatRupiah($val->mr_fee); ?> </td> <td id="disc_<?php echo $t . "_" . $val->id_order; ?> "><?php echo Generic::formatRupiah($val->cc_fee); ?> </td> <td id="charges_<?php echo $t . "_" . $val->id_order; ?> "><?php echo Generic::formatRupiah($val->Total); ?> </td> </tr> <script> $('#id_order_<?php echo $t . "_" . $val->id_order; ?> ').click(function () { openLw("order_detail", "<?php echo _SPPATH; ?> Report/viewOrderDetail?id_order=" + <?php echo $val->id_order; ?> , "fade"); }); </script> <?php } ?> </tbody> </table> </div> </div> <?php }
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 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 updateStatusProgress() { $idDish = $_GET["id_dish"]; $idOrder = $_GET["id_order"]; $idResto = $_GET["id_restaurant"]; //TODO cek id_resto di order header apakah sama degan $Resto $resto = new MasterRestaurantModel(); $resto->getByID($resto); $od = new OrderDetailModel(); $arrOrDetails = $od->getWhere("id_order='{$idOrder}' AND id_dish='{$idDish}'"); foreach ($arrOrDetails as $oDetails) { if ($oDetails->status_progress < 2) { $oDetails->status_progress++; $sp = $oDetails->status_progress; } else { //TODO ERROR order already out } } $order = $this->updateOrderHeaderStatusProgress($idOrder); $ids = $order->user_guest_id + "," + $order->id_user; $msg = "Your "; if ($order->type_order == "0") { $msg .= "Dine In "; } elseif ($order->type_order == "3") { $msg .= "Take Away "; } else { $json["status_code"] = 1; $json["results"]["id_dish"] = $idDish; $json["results"]["id_order"] = $idDish; $json["results"]["id_restaurant"] = $idDish; $json["results"]["status_progress"] = $sp; $json["results"]["order_status_progress"] = $order->status_progress; die; } $msg .= "order's status at {$resto->name} has been updated"; $j["id_order"] = $idOrder; $json = json_encode($j); $_POST["ids"] = $ids; $_POST["msg"] = $msg; $_POST["json"] = $json; $_POST["type"] = 41; $p = new PushTo(); $p->users(); 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)) { if ($o->{$attr} != "" and $o->{$attr} != 0) { $sem[$attr] = _BPATH . _PHOTOURL . $o->{$attr}; } else { $sem[$attr] = ""; } } else { $sem[$attr] = stripslashes($o->{$attr}); } } } return $sem; }
public function overwriteRead($return) { $objs = $return['objs']; $dateNow = new DateTime('now'); foreach ($objs as $obj) { foreach ($obj as $key => $val) { if ($key == "end") { $datetimeEnd = new DateTime($val); $interval = $dateNow->diff($datetimeEnd); if ($dateNow->format("Y.m.d") > $datetimeEnd->format("Y.m.d")) { } if ($interval->format('%R%a') >= 1) { } else { } } } if (isset($obj->id_restaurant)) { $resto = new MasterRestaurantModel(); $resto->getByID($obj->id_restaurant); $obj->id_restaurant = $resto->name; } if (isset($obj->id_bank)) { $bank = new BankModel(); $bank->getByID($obj->id_bank); $obj->id_bank = $bank->bank_name; } if (isset($obj->start)) { $date = new DateTime($obj->start); $obj->start = $date->format('d.m.Y'); } if (isset($obj->end)) { $dateEnd = new DateTime($obj->end); $obj->end = $dateEnd->format('d.m.Y'); } ?> <script> $(document).ready(function () { var date = new Date(); var i = 1; while ($('#id_bank_discount_' + i).text().trim()) { var dateEndNow = $('#end_' + i).text().trim(); var dt1 = parseInt(dateEndNow.substring(0, 2)); var mon1 = parseInt(dateEndNow.substring(3, 5)); var yr1 = parseInt(dateEndNow.substring(6, 10)); var dateEnd = new Date(yr1, mon1 - 1, dt1); var diff = dateEnd - date, sign = diff < 0 ? -1 : 1, milliseconds, seconds, minutes, hours, days; diff = (diff - (milliseconds = diff % 1000)) / 1000; diff = (diff - (seconds = diff % 60)) / 60; diff = (diff - (minutes = diff % 60)) / 60; days = (diff - (hours = diff % 24)) / 24; if(days <2){ $("#BankDiscountModel_" + i).css("background-color", "red"); } else{ $("#BankDiscountModel_" + i).css("background-color", "yellow"); } i = i + 1; } }); </script> <?php } ?> <style> .table{ background-color: red; } #BankDiscountModel_1{ background-color: red; } #BankDiscountModel_{ background-color: greenyellow; } </style> <?php return $return; }
public static function getRestaurantnyID($id_restaurant) { $objResto = new MasterRestaurantModel(); $arrResto = $objResto->getWhere("id_restaurant='{$id_restaurant}'"); return $arrResto; }