public function getUsers($restId) { $db = new Db(); $table = "rest" . $restId . "_users"; $checkRest = restExists($table); if ($checkRest != true) { return $checkRest; } $local_query = "SELECT * FROM `{$table}`"; $result = $db->select($local_query); $userCount = count($result); $configurationTable = "rest" . $restId . "_userConfigurations"; $configurationMappingTable = "rest" . $restId . "_userConfigurationMapping"; $userTable = "rest" . $restId . "_users"; $local_query = "SELECT M.`userID`,M.`configurationID`, C.`configurationName`,C.`configurationDisplayText`, C.`configurationType`, \n\t\tC.`configurationTag`, C.`configurationValueBinary`, C.`configurationValueText`, C.`configurationValueDecimal`, C.`comments`,M.`isAllowed` FROM \n\t\t`{$configurationMappingTable}` AS M INNER JOIN `{$configurationTable}` AS C ON `M`.`configurationID` = `C`.`configurationID` \n\t\tORDER BY M.`userID`, M.`configurationID`"; $resultConfiguration = $db->select($local_query); $configurationCount = count($resultConfiguration); for ($i = 0; $i < $userCount; $i++) { $result[$i]['Permissions'] = array(); for ($j = 0; $j < $configurationCount; $j++) { if ($result[$i]['ID'] == $resultConfiguration[$j]['userID']) { array_push($result[$i]['Permissions'], $resultConfiguration[$j]); } } } for ($i = 0; $i < $userCount; $i++) { for ($j = 0; $j <= count($result[$i]['Permissions']); $j++) { unset($result[$i]['Permissions'][$j]['userID']); } } $response = array(); $response["Users"] = $result; return $response; }
public function getDiscountInfo($restId) { $table = "rest" . $restId . "_discountMaster"; $checkRest = restExists($table); if ($checkRest != true) { return $checkRest; } $discountVoucherTable = "rest" . $restId . "_discountVoucher"; $discountSlotsTable = "rest" . $restId . "_discountSlots"; $db = new Db(); $local_query = "SELECT * FROM `{$table}`"; $result = $db->select($local_query); foreach ($result as $key => $value) { if ($value["isVoucherEnabled"]) { $temp = $value["discountID"]; $voucher_query = "SELECT `ID`, `voucherCode`, `validFromUTC`,\n \t\t\t `validFromLocal`, `validToUTC`, `validToLocal`, `timeZone`, `isUsed`,\n \t\t\t `orderIDUsedOn`, `customerID` FROM `{$discountVoucherTable}` WHERE discountID = '{$temp}'"; $voucher = $db->select($voucher_query); $result[$key]["Voucher Details"] = $voucher; } } foreach ($result as $key => $value) { if ($value["isSlotted"]) { $temp = $value["discountID"]; $slot_query = "SELECT * FROM `{$discountSlotsTable}` WHERE discountID = '{$temp}'"; $slot = $db->select($voucher_query); $result[$key]["Slot Details"] = $slot; } } return $result; }
public function getAC($restId) { $table = "rest" . $restId . "_additionalCharges"; $checkRest = restExists($table); if ($checkRest) { $local_query = "SELECT * FROM `{$table}` "; $db = new Db(); $resultArray = $db->select($local_query); if ($resultArray != false) { $endArray["AdditionalCharges"] = $resultArray; return $endArray; } else { $response = array(); $response["error"] = "Restaurant ID is correct.No Reference to the information."; return $response; } } else { return $checkRest; } }
public function deleteCustomerAddress($restId, $custId) { $db = new Db(); $table = "rest" . $restId . "_customers"; $checkRest = restExists($table); if ($checkRest) { $input_json = "{\"addressLine1\":\"\",\"addressLine2\":\"\",\"city\":\"Glasgfrfrfow Village\",\"state\":\"\",\"country\":\"\",\"pincode\":\"199444\"}"; $data = json_decode($input_json, true); foreach ($data as $key => $value) { if ($key == "pincode") { $local_query = "UPDATE `{$table}` SET `{$key}`= 0 WHERE customerID = '{$custId}';"; echo $local_query; // echo $local_query; $result = $db->query($local_query); if ($result == false) { echo "FAILED!"; } else { echo "DONE!"; } } else { if ($key != "customerID") { $local_query = "UPDATE `{$table}` SET `{$key}`=\"\" WHERE customerID = '{$custId}';"; echo $local_query; // echo $local_query; $result = $db->query($local_query); if ($result == false) { echo "FAILED!"; } else { echo "DELETED!"; } } } } } else { return $checkRest; } }
public function getOfficialTime($restId) { $db = new Db(); $table = "rest" . $restId . "_info"; $checkRest = restExists($table); if ($checkRest != true) { return $checkRest; } $local_query = "SELECT openingHoursUTc,openingHoursLocal,closingHoursUTc,closingHoursLocal FROM `{$table}` WHERE restaurantID = '{$restId}' "; $result = $db->select($local_query); return $result; }
public function deleteEmployee($restId, $userid) { $db = new Db(); $table = "rest" . $restId . "_users"; $checkRest = restExists($table); if ($checkRest != true) { return $checkRest; } $local_query = "UPDATE `{$table}` SET isActive = 0 WHERE ID ='{$userid}' "; $result = $db->query($local_query); if ($result == false) { return "FAILED!"; } else { return "DONE!"; } }
private function deleteTax($input_json) { $data = json_decode($input_json, true); $restId = $data['restId']; $taxId = $data['taxId']; $table = "rest" . $this->restId . "_taxes"; $checkRest = restExists($table); if ($checkRest != true) { return $checkRest; } $local_query = "DELETE FROM {$table} WHERE taxId = {$taxId}"; // Execute Atomically try { $dbh->beginTransaction(); $dbh->exec($local_query); $dbh->commit(); echo "New Record Successfully created!"; } catch (PDOException $e) { // Rollback transaction if not commit $dbh->rollback(); echo "Transaction Rolled! Couldn't create record!"; } }
public function getOrder($restId, $orderID) { $db = new Db(); $table = "rest" . $restId . "_orderSummary"; $local_query = "SELECT * FROM `{$table}` WHERE orderID = '{$orderID}';"; $result = $db->select($local_query); $response = array(); $count = count($result); $checkRest = restExists($table); if ($checkRest != true) { return $checkRest; } if ($result == false || $count != 1) { $response['error'] = "true"; $response['message'] = "Invalid input"; return $response; } else { // return $result; //create array for additional charges $additionalChargeIDs = my_explode(",", $result[0]['additionalChargeIDs']); $additionalChargeNames = my_explode(",", $result[0]['additionalChargeNames']); $additionalChargePrices = my_explode(",", $result[0]['additionalChargePrices']); $additionalChargeTotal = $result[0]['additionalChargeValue']; unset($result[0]['additionalChargeIDs']); unset($result[0]['additionalChargeNames']); unset($result[0]['additionalChargePrices']); unset($result[0]['additionalChargeValue']); $result[0]['additionalCharges'] = array(); $additionalChargeCount = count($additionalChargeIDs); $additionalChargeArray = array(); for ($i = 0; $i < $additionalChargeCount; $i++) { $additionalChargeArray['id'] = $additionalChargeIDs[$i]; $additionalChargeArray['name'] = $additionalChargeNames[$i]; $additionalChargeArray['price'] = $additionalChargePrices[$i]; array_push($result[0]['additionalCharges'], $additionalChargeArray); } //create array for discounts $discountIDs = my_explode(",", $result[0]['discountIDs']); $discountNames = my_explode(",", $result[0]['discountNames']); $discountValues = my_explode(",", $result[0]['discountValues']); $discountTotal = $result[0]['discountTotalValue']; unset($result[0]['discountIDs']); unset($result[0]['discountNames']); unset($result[0]['discountValues']); unset($result[0]['discountTotalValue']); $result[0]['discounts'] = array(); $result[0]['discounts']['totalDiscount'] = $discountTotal; $discountCount = count($discountIDs); $discountArray = array(); for ($i = 0; $i < $discountCount; $i++) { $discountArray['id'] = $discountIDs[$i]; $discountArray['name'] = $discountNames[$i]; $discountArray['value'] = $discountValues[$i]; array_push($result[0]['discounts'], $discountArray); } unset($result[0]['cardNumbers']); unset($result[0]['cardAmounts']); unset($result[0]['orderCreationTimeUTC']); unset($result[0]['tableOccupyTimeUTC']); unset($result[0]['billSettleTimeUTC']); unset($result[0]['voidTimeUTC']); unset($result[0]['refunds']); unset($result[0]['lastModifiedTimeUTC']); //Rename keys $result[0]['orderCreationTime'] = $result[0]['orderCreationTimeLocal']; $result[0]['tableOccupyTime'] = $result[0]['tableOccupyTimeLocal']; $result[0]['voidTime'] = $result[0]['voidTimeLocal']; unset($result[0]['orderCreationTimeLocal']); unset($result[0]['tableOccupyTimeLocal']); unset($result[0]['voidTimeLocal']); unset($result[0]['ID']); $response['Order'] = $result; return $response; } }
public function updateProducts($input_json, $productId, $restId) { $db = new Db(); $data = json_decode($input_json, true); $table = "rest" . $restId . "_products"; $checkRest = restExists($table); if ($checkRest != true) { return $checkRest; } foreach ($data as $key => $value) { if ($key != "restaurantID") { $local_query = "UPDATE `{$table}` SET {$key}='{$value}';"; // echo $local_query; $result = $db->query($local_query); if ($result == false) { echo "FAILED!"; } else { echo "DONE!"; } } } }