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 }