include_once '../classes/PDOExt.php'; include_once '../classes/Utilities.php'; $dbConnection = new PDOExt(); $utilities = new Utilities(); $response = array(); $name = $utilities->clean($_POST['name']); $area = $utilities->clean($_POST['area']); $pincode = $utilities->clean($_POST['pincode']); $latitude = $utilities->replaceZero($_POST['latitude']); $longitude = $utilities->replaceZero($_POST['longitude']); $log_datetime = $utilities->replaceNow(); $kitchenId = -1; try { $insertQuery = "INSERT INTO " . " `kitchen` (name, area, pincode, latitude, longitude, log_datetime) " . " VALUES ('{$name}', '{$area}', '{$pincode}', '{$latitude}', '{$longitude}', '{$log_datetime}')"; $statement = $dbConnection->prepare($insertQuery); try { $dbConnection->beginTransaction(); if ($statement->execute()) { $kitchenId = $dbConnection->lastInsertId(); $dbConnection->commit(); $response = array('status' => $kitchenId, 'desc' => 'Success'); } else { $status = -99; $dbError = $statement->errorInfo(); $response = array('status' => $status, 'desc' => 'DB error occured' . $dbError[2]); } } catch (PDOExecption $e) { $status = -7; $error = "Exception: " . $e->getMessage(); $response = array('status' => $status, 'desc' => 'PDO exception occured' . $error);
if (isset($_POST['page_index'])) { $page_start = $_POST['page_index']; $page_position = ($page_start - 1) * $item_per_page; } else { $page_position = $utilities->replaceZero($_POST['page_start']); } $chef_id = $utilities->replaceDefault($_POST['chef_id']); $dateTime = $utilities->replaceNow(); //print_r($_POST); try { $query = " SELECT food_item.item_id,\n food_item.`name` AS food_name,\n food_item.description,\n food_item.ingredients,\n food_item.preparation_method,\n food_item.rating AS food_rating,\n category.category_id,\n category.category_name,\n food_item.price,\n currency.currency_id,\n currency.currency_name,\n currency.currency_symbol,\n chef.chef_id,\n CONCAT(chef.f_name, ' ', chef.l_name) AS chef_name,\n CONCAT(chef.country_code, chef.phone_number) AS chef_phone_number,\n chef.image_url AS chef_image,\n chef.rating AS chef_rating,\n food_item.nutrition,\n COALESCE(food_item.food_image_1, '') AS food_image_1,\n COALESCE(food_item.food_image_2, '') AS food_image_2,\n COALESCE(food_item.food_image_3, '') AS food_image_3,\n COALESCE(food_item.food_image_4, '') AS food_image_4,\n food_item.log_datetime\n FROM food_item INNER JOIN category ON food_item.category_id = category.category_id\n INNER JOIN currency ON food_item.currency_id = currency.currency_id\n INNER JOIN chef ON food_item.chef_id = chef.chef_id "; $query .= $chef_id > 0 ? " WHERE food_item.chef_id = {$chef_id} " : " "; $query .= " ORDER BY food_name ASC\n LIMIT {$page_position}, {$item_per_page};"; //echo $query; $log->info("Query:" . $query); $statement = $dbConnection->prepare($query); $sql = "SELECT * FROM food_item"; $result = $dbConnection->query($sql); $row = $result->fetchAll(); $numOfRows = count($row); try { if ($statement->execute($bindParams)) { $data = $statement->fetchAll(PDO::FETCH_ASSOC); $statement->closeCursor(); $log->arrayMultiLogger($data, 'Result for food items'); //$pagi = call_paginate(); $response = array('status' => 0, 'data' => $data, 'desc' => 'success', 'index' => $page_start, 'pages' => $numOfRows); } else { $errorCode = -99; $dbError = $statement->errorInfo(); $statement->closeCursor();
include_once '../classes/PDOExt.php'; include_once '../classes/Utilities.php'; $dbConnection = new PDOExt(); $utilities = new Utilities(); $response = array(); $userId = $utilities->clean($_POST['userId']); $push_reg_token = $utilities->clean($_POST['pushRegToken']); $device_imei = $utilities->clean($_POST['deviceIMEI']); $os_id = $utilities->clean($_POST['osId']); //1 - Android, 2 - iOS $os_name = $os_id == 1 ? 'Android' : 'iOS'; $dateTime = $utilities->replaceNow(); $pushRegId = -1; try { $queryRegPush = "SELECT COUNT(*) AS isPushReg FROM `push_reg` WHERE device_imei = '{$device_imei}' AND push_reg_token = '{$push_reg_token}';"; $statement = $dbConnection->prepare($queryRegPush); $statement->execute(); $dataRegPushArray = $statement->fetchAll(PDO::FETCH_ASSOC); $statement->closeCursor(); if ($dataRegPushArray[0]['isPushReg'] == 0) { $insertQuery = "INSERT INTO " . " `push_reg` (user_id, push_reg_token, device_imei, os_id, os_name, datetime) " . " VALUES (:user_id, :push_reg_token, :device_imei, :os_id, :os_name, :datetime);"; $statement = $dbConnection->prepare($insertQuery); $statement->bindParam(":user_id", $userId, PDO::PARAM_INT); $statement->bindParam(":push_reg_token", $push_reg_token, PDO::PARAM_STR); $statement->bindParam(":device_imei", $device_imei, PDO::PARAM_STR); $statement->bindParam(":os_id", $os_id, PDO::PARAM_INT); $statement->bindParam(":os_name", $os_name, PDO::PARAM_STR); $statement->bindParam(":datetime", $dateTime, PDO::PARAM_STR); try { $dbConnection->beginTransaction(); if ($statement->execute()) {