public static function getRestaurantUserName($id_user)
{
$objRestoUser = new RestaurantUserModel();
$arrRestoUser = $objRestoUser->getWhere("id_user='******'");
if (count($arrRestoUser) == 0) {
return "";
} else {
return $arrRestoUser[0]->name;
}
}
public function restoUserLogin()
{
if (Efiwebsetting::getData('checkOAuth') == 'yes') {
IMBAuth::checkOAuth();
}
$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;
}
$pin = isset($_POST['pin']) ? addslashes($_POST['pin']) : "";
if (!$pin) {
$json['status_code'] = 0;
$json['status_message'] = "No ID Found";
echo json_encode($json);
die;
}
$json = array();
$json['status_code'] = 1;
$objRestoUsers = new RestaurantUserModel();
$arrRestoUsers = $objRestoUsers->getWhere("id_restaurant = '{$id_restaurant}' AND pin_password='******' AND status='1'");
MasterDish::checkCount($arrRestoUsers);
$sem = array();
foreach ($arrRestoUsers as $val) {
$sem['user'] = RestaurantUser::getRestaurantUser($val->id_user);
}
$json['results'] = $sem;
echo json_encode($json);
die;
}
public function getMonthByMonthOrder()
{
if (Efiwebsetting::getData('checkOAuth') == 'yes') {
IMBAuth::checkOAuth();
}
$idResto = $this->mustCheck($_GET['id_restaurant'], "NO ID Restaurant");
$range = $_GET['range'] == null || $_GET['range'] == "" ? 0 : $_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'] . "'";
$r = new MasterRestaurantModel();
$r->getByID($idResto);
$result["name"] = $r->name;
$result['list_orders'] = array();
$result['sum_total_grand_total'] = 0;
$result['sum_total_order_count'] = 0;
$result['sum_disc_mr'] = 0;
$result['sum_disc_resto'] = 0;
$result['sum_disc_bank'] = 0;
$result['sum_disc_other'] = 0;
$result['sum_tax_pb1'] = 0;
$result['sum_service_charge'] = 0;
$result['sum_other_charge'] = 0;
$result['sum_other_charge'] = 0;
if (!isset($range) || $range == 999) {
$range = 4;
}
for ($i = 0; $i <= $range; $i++) {
$date = date('m', strtotime("-{$i} months"));
$o = new MasterOrderModel();
$q = "status='1' AND id_restaurant='{$idResto}' AND MONTH(datetime_order)='{$date}' {$extraQ} ORDER BY id_order DESC";
if ($_GET['is_debug']) {
echo $q . "<br>";
}
$arrO = $o->getWhere($q);
if (count($arrO) == 0) {
continue;
}
unset($b);
$b['date'] = $date;
$b['header_id'] = $i;
$b['order_count'] = 0;
$b['order_sum'] = 0;
$b['sum_disc_mr'] = 0;
$b['sum_disc_resto'] = 0;
$b['sum_disc_bank'] = 0;
$b['sum_disc_other'] = 0;
$b['sum_tax_pb1'] = 0;
$b['sum_service_charge'] = 0;
$b['sum_other_charge'] = 0;
$b['sum_mr_fee'] = 0;
$b['sum_cc_fee'] = 0;
foreach ($arrO as $order) {
unset($c);
if (!$order instanceof MasterOrderModel) {
return;
}
$c['date'] = $date;
// $b['order_sum'] += (double)$order->grand_total;
// $b['order_count']++;
//
// $b['sum_disc_mr'] += (double)$order->disc_mr;
// $b['sum_disc_resto'] += (double)$order->disc_resto;
// $b['sum_disc_bank'] += (double)$order->disc_bank;
// $b['sum_disc_other'] += (double)$order->disc_other;
// $b['sum_tax_pb1'] += (double)$order->tax_pb1;
// $b['sum_service_charge'] += (double)$order->service_charge;
// $b['sum_other_charge'] += (double)$order->other_charge;
$c['header_id'] = $i;
$c['id_order'] = $order->id_order;
$c['id_table'] = $order->id_table;
$c['id_server'] = $order->id_server;
$c['server_name'] = $order->server_name;
$c['type_order'] = $order->type_order;
$c['status_progress'] = $order->status_progress;
$c['datetime_order'] = $order->datetime_order;
$c['datetime_done'] = $order->datetime_done;
$c['grand_total'] = (double) $order->grand_total;
$c['status'] = $order->status;
$c['order_now'] = $order->order_now;
$c['voided'] = $order->voided;
$c['order_number'] = $order->order_number;
$c['mr_fee'] = (double) $order->mr_fee;
$c['cc_fee'] = (double) $order->cc_fee;
$b['order_count']++;
$b['order_sum'] += $order->grand_total;
$b['sum_disc_mr'] += $order->disc_mr;
$b['sum_disc_resto'] += $order->disc_resto;
$b['sum_disc_bank'] += $order->disc_bank;
$b['sum_disc_other'] += $order->disc_other;
$b['sum_tax_pb1'] += $order->tax_pb1;
$b['sum_service_charge'] += $order->service_charge;
$b['sum_other_charge'] += $order->other_charge;
$b['sum_mr_fee'] += $order->mr_fee;
$b['sum_cc_fee'] += $order->cc_fee;
if ($c['id_table'] == null || $c['id_table'] == 0) {
$c['table_number'] = "0";
} else {
$t = new MasterTableModel();
$t->getByID($c['id_table']);
$c['table_number'] = $t->table_number;
}
$b['Orders'][] = $c;
}
$result['list_orders'][] = $b;
$result['sum_total_grand_total'] += $b['order_sum'];
$result['sum_total_order_count'] += $b['order_count'];
$result['sum_disc_mr'] += $b['sum_disc_mr'];
$result['sum_disc_resto'] += $b['sum_disc_resto'];
$result['sum_disc_bank'] += $b['sum_disc_bank'];
$result['sum_disc_other'] += $b['sum_disc_other'];
$result['sum_tax_pb1'] += $b['sum_tax_pb1'];
$result['sum_service_charge'] += $b['sum_service_charge'];
$result['sum_other_charge'] += $b['sum_other_charge'];
$result['sum_mr_fee'] += $b['sum_mr_fee'];
$result['sum_cc_fee'] += $b['sum_cc_fee'];
}
$result['servers'] = array();
$s = new RestaurantUserModel();
$arrS = $s->getWhere("id_restaurant={$idResto} AND status='1' AND (role='Supervisor' OR role='Staff') ORDER BY role DESC");
foreach ($arrS as $server) {
unset($ss);
$ss['id_user'] = $server->id_user;
$ss['name'] = $server->name;
$ss['role'] = $server->role;
$result['servers'][] = $ss;
}
$json['status_code'] = 1;
$json['results'] = $result;
echo json_encode($json);
die;
}
public function checkRestoaktiv()
{
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;
}
$pwd = isset($_POST['pwd']) ? addslashes($_POST['pwd']) : "";
if (!$pwd) {
$json['status_code'] = 0;
$json['status_message'] = "No ID Found";
echo json_encode($json);
die;
}
$objUsr = new RestaurantUserModel();
$arrUsr = $objUsr->getWhere("role = 'Supervisor' AND id_restaurant='{$id_restaurant}' AND pin_password='******' AND status='1'");
if (count($arrUsr) == 0) {
$json['status_code'] = 0;
$json['status_message'] = "Username or Password unmatch";
echo json_encode($json);
die;
}
$rd = new RegDevice();
$_POST['acc_id'] = $id_restaurant;
$json['regDevice'] = $rd->saveOnly();
$objRestaurant = new MasterRestaurantModel();
$arrResto = $objRestaurant->getWhere("id_restaurant='{$id_restaurant}' AND aktiv ='1'");
$sem = array();
if (count($arrResto) == 0) {
$sem['status'] = false;
} else {
$sem['status'] = true;
$sem['new_set_table'] = $arrResto[0]->new_set_table == "1" && $arrResto[0]->table_column != "0" && $arrResto[0]->table_quantity != "0";
$sem['has_categories'] = isset($arrResto[0]->id_categories) && $arrResto[0]->id_categories != "0";
$dish = new MasterDishModel();
$arrDish = $dish->getWhere("id_restaurant = '{$id_restaurant}' AND status = '1'");
$sem['has_dish'] = count($arrDish) > 0;
}
$json['results'] = $sem;
echo json_encode($json);
die;
}
