public function setTableAttributes() { if (Efiwebsetting::getData('checkOAuth') == 'yes') { IMBAuth::checkOAuth(); } $json = array(); $json['status_code'] = 1; // param, table id, table number, availabilty, sama qr(dalam base 64) $id_table = isset($_POST['id_table']) ? addslashes($_POST['id_table']) : ""; // echo $id_table; if (!$id_table) { $json['status_code'] = 0; $json['status_message'] = "No ID Table Found"; echo json_encode($json); die; } $table_number = isset($_POST['table_number']) ? addslashes($_POST['table_number']) : ""; if (!$table_number) { $json['status_code'] = 0; $json['status_message'] = "No Table number Found"; echo json_encode($json); die; } $availability = isset($_POST['availability']) ? addslashes($_POST['availability']) : "0"; if (!$availability) { $json['status_code'] = 0; $json['status_message'] = "No availability Found"; echo json_encode($json); die; } $QR = isset($_POST['QR']) ? addslashes($_POST['QR']) : ""; if (!$QR) { $json['status_code'] = 0; $json['status_message'] = "No QR Found"; echo json_encode($json); die; } $objQR = new QRModel(); $arrQR = $objQR->getWhere("textQR='{$QR}' AND status = '0'"); Generic::checkCountWithMsg($arrQR, "QR has been used!"); $objTable = new MasterTableModel(); $arrTable = $objTable->getWhere("id_table='{$id_table}'"); Generic::checkCountWithMsg($arrTable, "Table not found!"); $arrTable[0]->table_number = $table_number; $arrTable[0]->QR = $QR; $arrTable[0]->availability = "1"; $arrTable[0]->load = 1; $arrTable[0]->save(); $arrQR[0]->status = "1"; $arrQR[0]->load = "1"; $arrQR[0]->save(); $json['status_code'] = 1; $json['results'] = Mastertable::getTableByTableID($arrTable[0]->id_table); echo json_encode($json); die; }