public function createInvitationLink()
{
if (Efiwebsetting::getData('checkOAuth') == 'yes') {
IMBAuth::checkOAuth();
}
$json = array();
$json['status_code'] = 1;
$id_user = Generic::mustCheck($_GET['id_user'], "NO ID User found!");
$id_order = Generic::mustCheck($_GET['id_order'], "NO ID Order found!");
// check apakah id_order dgn id_user msh aktiv
$objOrder = new MasterOrderModel();
$arrOrder = $objOrder->getWhere("id_order='{$id_order}' AND id_user = '******' AND status_payment = '0'");
Generic::checkCountWithMsg($arrOrder, "Order is not activate");
$objInvitation = new InvitationModel();
$objInvitation->inv_id_resto = $arrOrder[0]->id_restaurant;
$objInvitation->inv_id_order = $id_order;
$objInvitation->inv_id_table = $arrOrder[0]->id_table;
$objInvitation->inv_from = $id_user;
$id = $objInvitation->save();
if ($id != "") {
$link = _BPATH . "Invitation/acceptInvitation?id_invitation={$id}";
$json['status_message'] = addslashes($link);
} else {
$json['status_code'] = 0;
$json['status_message'] = "Link can't create!";
}
echo json_encode($json);
die;
}
private function findOrder($idUser, $idDish, $qty, $idRestaurant)
{
$o = new MasterOrderModel();
$arrOrders = $o->getWhere("id_restaurant='{$idRestaurant}' AND status='1' AND status_payment='0'");
pr($arrOrders);
}
public static function getOrder($id_order)
{
$objOrder = new MasterOrderModel();
$arrOrder = $objOrder->getWhere("id_order = '{$id_order}' ORDER BY id_order asc");
MasterDish::checkCount($arrOrder);
$exp = explode(",", str_replace(" ", "", $objOrder->crud_webservice_allowed));
$sem = array();
foreach ($arrOrder as $o) {
foreach ($exp as $attr) {
$sem[$attr] = stripslashes($o->{$attr});
}
if ($o->id_table != 0) {
$table = new MasterTableModel();
$table->getByID($o->id_table);
$sem["table_number"] = $table->table_number;
}
}
return $sem;
}
public function emailExcelReportDayByDayOrder()
{
if (Efiwebsetting::getData('checkOAuth') == 'yes') {
IMBAuth::checkOAuth();
}
$idResto = $this->mustCheck($_GET['id_restaurant'], "NO ID Restaurant");
$range = $_GET['range'] == null || $_GET['range'] == "" ? 30 : $_GET['range'];
$extraQ = $this->selectTypeOrder($_GET['type_order']);
$idServer = $_GET['id_user'];
$extraQ .= $idServer == null || $idServer == "" || $idServer == "0" ? "" : "AND id_server='{$idServer}'";
$extraQ .= $_GET['voided'] == null || $_GET['voided'] == "" || $_GET['voided'] == "0" ? " AND status_progress='4' " : "AND status_progress='9' AND voided='1'";
$extraQ .= $_GET['status_payment'] == null || $_GET['status_payment'] == "" || $_GET['status_payment'] == "999" ? "" : "AND status_payment='" . $_GET['status_payment'] . "'";
///EXCEL
$ex = array();
$resto = new MasterRestaurantModel();
$resto->getByID($idResto);
$text = "Report\t" . $resto->name . "\t" . date('Y-m-d H:i:s') . "\n";
$text .= "Interval\t{$range} day(s)\n";
$text .= "Server\t";
if ($idServer == null || $idServer == "" || $idServer == "0") {
$text .= "All Server\n";
} else {
$sr = new RestaurantUserModel();
$sr->getByID($idServer);
$text .= $sr->name . "\n";
}
$text .= "Type Order\t" . Generic::selectStringTypeOrder($_GET['type_order']) . "\n";
$text .= "Order Status\t";
$text .= $_GET['voided'] == null || $_GET['voided'] == "" || $_GET['voided'] == "0" ? "Finished Order\n" : "Voided Order\n";
$text .= "Payment Method\t" . $this->selectTypePayment($_GET['status_payment']) . "\n\n";
for ($i = 0; $i <= $range; $i++) {
$date = date('Y-m-d', strtotime("-{$i} days"));
$o = new MasterOrderModel();
if ($range == 999) {
$arrO = $o->getWhere("id_restaurant='{$idResto}' {$extraQ}");
} else {
$arrO = $o->getWhere("id_restaurant='{$idResto}' AND DATE(datetime_order)='{$date}' {$extraQ}");
}
if (count($arrO) == 0) {
continue;
}
$text .= "Order ID " . $arrO[0]->id_order . "\n";
if ($arrO[0]->id_server != null || $arrO[0]->id_server != "" || $arrO[0]->id_server != "0") {
unset($sr);
$sr = new RestaurantUserModel();
$sr->getByID($idServer);
$text .= "Server\t" . $sr->name . "\n";
}
$text .= "Time Order\t" . leap_mysqldate_isi($arrO[0]->id_server) . "\n";
$text .= "Total\t" . $arrO[0]->total_cost . "\n";
$text .= $arrO[0]->disc_mr == 0 ? "" : "Disc MR\t" . $arrO[0]->disc_mr . "\n";
$text .= $arrO[0]->disc_resto == 0 ? "" : "Disc Resto\t" . $arrO[0]->disc_resto . "\n";
$text .= $arrO[0]->disc_bank == 0 ? "" : "Disc Bank\t" . $arrO[0]->disc_bank . "\n";
$text .= $arrO[0]->disc_other == 0 ? "" : "Disc Other\t" . $arrO[0]->disc_other . "\n";
$text .= $arrO[0]->tax_pb1 == 0 ? "" : "Tax PB 1\t" . $arrO[0]->tax_pb1 . "\n";
$text .= $arrO[0]->service_charge == 0 ? "" : "Service Charge\t" . $arrO[0]->service_charge . "\n";
$text .= $arrO[0]->other_charge == 0 ? "" : "Other Charge\t" . $arrO[0]->other_charge . "\n";
$text .= "Grand Total\t" . $arrO[0]->grand_total . "\n";
$text .= "ID Details\tDish Name\tQuantity\tPrice\tVoided\tNote\n";
foreach ($arrO as $or) {
$ex[] = $or;
$detailsOrder = OrderDetail::getOrderDetailsByIDOrder($or->id_order);
foreach ($detailsOrder as $dor) {
$text .= $dor['id_order_detail'] . "\t";
$text .= $dor['name'] . "\t";
$text .= $dor['quantity'] . "\t";
$text .= $dor['price'] . "\t";
$text .= $dor['voided'] == "1" ? "YES\t" : "NO\t";
$text .= $dor['note'] . "\t";
$text .= "\n";
}
}
$text .= "\n\n";
}
if (count($ex) <= 0) {
// Generic::errorMsg("Empty Record");
$text .= "EMPTY RECORD\n\n";
}
$title = "Report_" . $resto->name . "_" . 1000 * strtotime(date('Y-m-d H:i:s'));
header("Content-Disposition: attachment; filename=\"{$title}\".xls");
header("Content-Type: application/vnd.ms-excel");
$file = fopen($title, "w+");
fwrite($file, $text);
fclose($file);
die;
}
public function getUserReceipts()
{
if (Efiwebsetting::getData('checkOAuth') == 'yes') {
IMBAuth::checkOAuth();
}
$idUser = Generic::mustCheck($_GET['id_user'], "User ID not Found");
$page = $_GET['page'];
$limit = $_GET['limit'];
$page--;
$p = $page * $limit;
$q = "id_user='******' AND status_progress='4' ORDER BY datetime_order DESC";
$q .= Generic::IsNullOrEmptyString($page) || Generic::IsNullOrEmptyString($limit) ? "" : " LIMIT {$p},{$limit}";
$o = new MasterOrderModel();
$arrOrder = $o->getWhere($q);
$results['receipts'] = array();
foreach ($arrOrder as $order) {
unset($b);
$b['id_order'] = $order->id_order;
$b['datetime_order'] = $order->datetime_order;
$resto = new MasterRestaurantModel();
$resto->getByID($order->id_restaurant);
$b['id_restaurant'] = $order->id_restaurant;
$b['name'] = $resto->name;
$b['grand_total'] = $order->grand_total;
$b['type_order'] = $order->type_order;
$b['order_type'] = $order->type_order == "3" ? "Take Away" : "Dine In";
$results['receipts'][] = $b;
}
$this->finish($results);
}
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 scandinein()
{
if (Efiwebsetting::getData('checkOAuth') == 'yes') {
IMBAuth::checkOAuth();
}
$json = array();
$json['status_code'] = 1;
$id_user = isset($_GET['id_user']) ? addslashes($_GET['id_user']) : "";
if (!$id_user) {
Generic::errorMsg("Please login!");
}
if (!User::checkUserID($id_user)) {
Generic::errorMsg("ID User not found!");
}
$QR = isset($_GET['QR']) ? addslashes($_GET['QR']) : "";
if (!$QR) {
Generic::errorMsg("No QR found!");
}
$id_order = isset($_GET['id_order']) ? addslashes($_GET['id_order']) : "";
if (!id_order) {
Generic::errorMsg("id_order not found!");
}
if (!MasterOrder::isIdorderValid($id_order)) {
Generic::errorMsg("id_order not found!");
}
$objTableHlp = Mastertable::getTableBYQR($QR);
$objTable = new MasterTableModel();
$objTable->getByID($objTableHlp[0]->id_table);
$objTable->appOrder = "1";
$objTable->id_order = $id_order;
$objTable->status = "0";
$objTable->waitingOrder = "2";
$objTable->load = 1;
$objTable->save();
$objOrder = new MasterOrderModel();
$objOrder->getByID($id_order);
$objOrder->id_table = $objTableHlp[0]->id_table;
$objOrder->type_order = "1";
$objOrder->load = 1;
$objOrder->save();
$objOrderHlp = new MasterOrderModel();
$arrOrder = $objOrderHlp->getWhere("id_user='******' AND status_progress < 3 OR status_payment='0'");
Generic::checkCountWithMsg($arrOrder, "No ID Order from the ID User found");
$id_order = $arrOrder[0]->id_order;
$order = MasterOrder::getOrder($id_order);
$arrOrderDetails = OrderDetail::getOrderDetailsByIDOrderAndUserID($id_order, $id_user);
$order['Order_Details'] = $arrOrderDetails;
$order['restaurant'] = User::getRestaurant($order['id_restaurant']);
$json['results'][] = $order;
echo json_encode($json);
die;
}
public static function getOpenOrderbyUserID($id_user)
{
$objOrder = new MasterOrderModel();
$arrOrder = $objOrder->getWhere("id_user='******' AND status_payment = 0 AND order_now = 0");
return $arrOrder;
}
