public function Scan() { $userId = $_GET["user_id"]; $qr = $_GET["QR"]; $qrs = new QRModel(); //////validate QR Code $resQrs = $qrs->getWhere("textQR='{$qr}'"); if (count($resQrs) == 1) { if ($resQrs[0]->status == 0) { $this->error("Unasigned QR Code!"); } } else { $this->error("Wrong QR Code!"); } ///////fetch user details $user = new UserModel(); $user->getByID($userId); // pr($user); if ($user->user_name == null || $user->user_name == "") { $this->error("Who Are You ?!"); } ///////validate Table $ta = new MasterTableModel(); $arr = $ta->getWhere("QR='{$qr}'"); if (count($arr) == 1) { //status 0 = OCCUPIED if ($arr[0]->status == 0) { if ($arr[0]->id_order == 0) { $this->error("Empty Order ID"); } else { $this->requestJoinTable($user, $arr[0]->id_order); } } else { $this->requestRestoPermission($user, $arr[0]); } } else { $this->error("Wrong Table!"); } die; }
public static function updateTableAtrributByQR($QR, $attr, $value) { $objTable = new MasterTableModel(); $arr = $objTable->getWhere("QR='{$QR}'"); if (count($arr) > 0) { $arr[0]->{$attr} = $value; $arr[0]->load = 1; $arr[0]->save(); } }
public static function getTableModelByQR($QR) { $table = new MasterTableModel(); $arrTable = $table->getWhere("QR='{$QR}'"); if (count($arrTable) < 1) { return false; } else { $tableReturn = new MasterTableModel(); $tableReturn->getByID($arrTable[0]->id_table); return $tableReturn; } }
public static function getRestoIDByTable($id_table) { $objTable = new MasterTableModel(); $arrTable = $objTable->getWhere("id_table = '{$id_table}'"); pr($arrTable); }
private function checkTablePosition($id_restaurant, $position) { $return = false; $objTable = new MasterTableModel(); $arr = $objTable->getWhere("id_restaurant = {$id_restaurant} AND table_position = {$position}"); if (count($arr) == 0) { // echo "true"; $return = true; } return $return; }
public static function getAllTableIDNowNachRestoID($id_restaurant) { $objTables = new MasterTableModel(); $arrTables = $objTables->getWhere("id_restaurant='{$id_restaurant}' AND order_now ='1' ORDER BY id_order asc"); return $arrTables; }