public function takeawayInsert(UploadDTO\TakeawayUploadDto $takeawayRequest, $restaurantId) { try { $tableObj = $this->connect(); $newEntity = $tableObj->newEntity(); $newEntity->TakeawayId = $takeawayRequest->takeawayId; $newEntity->TakeawayNo = $takeawayRequest->takeawayNo; $newEntity->Discount = $takeawayRequest->discount; $newEntity->DeliveryCharges = $takeawayRequest->deliveryCharges; $newEntity->CustId = $takeawayRequest->custId; $newEntity->RestaurantId = $restaurantId; $newEntity->UserId = $takeawayRequest->userId; $newEntity->SourceId = $takeawayRequest->sourceId; $newEntity->CreatedDate = date(VB_DATE_TIME_FORMAT); $newEntity->UpdatedDate = date(VB_DATE_TIME_FORMAT); if ($tableObj->save($newEntity)) { Log::debug('Takeaway entry stored for custId :- ' . $takeawayRequest->custId); return $takeawayRequest->takeawayNo; } Log::error('Takeaway entry stored for custId :- ' . $takeawayRequest->custId); return FALSE; } catch (Exception $ex) { return FALSE; } }
public function index() { $this->autoRender = false; $userId = $this->request->query("userId"); $restaurantId = $this->request->query("restaurantId"); \Cake\Log\Log::debug("Download request come with userId :- " . $userId . ' restaurantId :- ' . $restaurantId); if (empty($userId) or empty($restaurantId)) { $this->response->body(DTO\ErrorDto::prepareError(101)); \Cake\Log\Log::error("userId or restaurantID is blank "); return; } $restaurantController = new RestaurantController(); if (!$restaurantController->isValidate($restaurantId)) { $this->response->body(DTO\ErrorDto::prepareError(100)); \Cake\Log\Log::error("request with incorrect restaurantId :- " . $restaurantId); return; } $userController = new UserController(); if (!$userController->isUserValid($userId, $restaurantId)) { $this->response->body(DTO\ErrorDto::prepareError(102)); \Cake\Log\Log::error("request with incorrect userId :- " . $userId); return; } \Cake\Log\Log::debug('Download request is validate successfully '); $syncController = new SyncController(); $syncController->download($userId, $restaurantId); }
public function saveNetworkDeviceInfo(DTO\ClsNetworkDeviceInfoDto $infoDto) { if ($infoDto and !$this->isPresent($infoDto->userId)) { $entity = $this->connect()->newEntity(); $entity->UserId = $infoDto->userId; $entity->Board = $infoDto->board; $entity->Brand = $infoDto->brand; $entity->Manufacturer = $infoDto->manufacturer; $entity->Model = $infoDto->model; $entity->Product = $infoDto->product; $entity->FmVersion = $infoDto->fmVersion; $entity->IpAddress = $infoDto->ip; $entity->City = $infoDto->city; $entity->Region = $infoDto->region; $entity->Country = $infoDto->country; if ($this->connect()->save($entity)) { \Cake\Log\Log::debug("User Network Device Info save in database for userid : " . $infoDto->userId); return SUCCESS; } \Cake\Log\Log::error("User Network Device Info not save in database for userid : " . $infoDto->userId); return FAIL; } \Cake\Log\Log::error(" userid : " . $infoDto->userId . " record exist in database"); return FAIL; }
public function customerVisitReport() { $this->autoRender = false; $restaurantId = $this->request->query('id'); \Cake\Log\Log::debug('Ajax request visited with RestaurantId :-' . $restaurantId); $customerVisitReportData = $this->getTableObj()->getdata($restaurantId); if (is_null($customerVisitReportData)) { $this->response->body(0); return; } $intermediate = []; foreach ($this->objKey as $key => $value) { $intermediate[$value] = 0; } foreach ($customerVisitReportData as $reportData) { for ($i = 0; $i < count($this->timeSlot); $i++) { $index = $this->objKey[$i]; $intermediate[$index] = $intermediate[$index] + $reportData->{$index}; } } $data[] = null; $ind = 0; foreach ($intermediate as $key => $value) { $data[$ind++] = new DownloadDTO\RushHourReportDto($value, $this->timeSlot[$key], $this->timeSlot[$key]); } $chartData = json_encode($data); $this->response->body($chartData); }
public function ajustabase() { $Usuario = TableRegistry::get("usuario"); $Categoria = TableRegistry::get("categoria"); $usuarios = $Usuario->find()->where(['usuario.historico' => 0, 'usuario.pendente' => 0, 'usuario.idUsuario is not' => 0]); $ldap = new LDAP(3); $res = array(); $res_ldap = array(); $cats = array(); foreach ($usuarios as $usuario) { $obj = $ldap->getUsers("(uid=*{$usuario->login}*)"); Log::debug($obj); $usuario->nomeUsuario = $obj[0]["cn"][0]; $usuario->dre = isset($obj[0]["smtdre"][0]) ? $obj[0]["smtdre"][0] : ''; $usuario->logradouro = isset($obj[0]["street"][0]) ? $obj[0]["street"][0] : ''; $usuario->complemento = isset($obj[0]["smtcomplemento"][0]) ? $obj[0]["smtcomplemento"][0] : ''; $usuario->cidade = isset($obj[0]["smtcidade"][0]) ? $obj[0]["smtcidade"][0] : ''; $usuario->bairro = isset($obj[0]["smtbairro"][0]) ? $obj[0]["smtbairro"][0] : ''; $usuario->pais = isset($obj[0]["smtpais"][0]) ? $obj[0]["smtpais"][0] : ''; $usuario->estado = isset($obj[0]["smtuf"][0]) ? $obj[0]["smtuf"][0] : ''; $usuario->codigoPostal = isset($obj[0]["homepostaladdress"][0]) ? $obj[0]["homepostaladdress"][0] : ''; $usuario->rg = isset($obj[0]['smtrg'][0]) ? $obj[0]['smtrg'][0] : ''; $usuario->cpf = isset($obj[0]['smtcpf'][0]) ? $this->formataCpf($obj[0]['smtcpf'][0]) : ''; $usuario->email = isset($obj[0]['mail'][0]) ? $obj[0]['mail'][0] : ''; $usuario->tel_fixo = isset($obj[0]['telephonenumber'][0]) ? $obj[0]['telephonenumber'][0] : ''; $usuario->tel_cel = isset($obj[0]['mobile'][0]) ? $obj[0]['mobile'][0] : ''; $nascimento = isset($obj[0]['smtnascimento'][0]) ? $obj[0]['smtnascimento'][0] : '19000101'; $usuario->data_nascimento = substr($nascimento, 6, 2) . '/' . substr($nascimento, 4, 2) . '/' . substr($nascimento, 0, 4); $usuario->data_exp = isset($obj[0]['smtdataexpiracao'][0]) ? $obj[0]['smtdataexpiracao'][0] : ''; $usuario->cadastro = isset($obj[0]['smtdatacadastro'][0]) ? $obj[0]['smtdatacadastro'][0] : ''; //$usuario->ativo = (isset($obj[0]['smtbool'][0])) ? ($obj[0]['smtbool'][0] == 'FALSE') ? false : true : ''; $loginResp = str_replace('uid=', '', explode(',', $obj[0]['smtprofresp'][0])[0]); $id = $Usuario->find()->where(['login' => $loginResp, 'idTipoUsuario' => 2]); if ($id->count() > 0) { $usuario->profResponsavel = $id->first()->idUsuario; } if (isset($obj[0]['smtgroups'])) { foreach ($obj[0]['smtgroups'] as $grupo) { $busca = $Usuario->Projeto->find('all', ['conditions' => ['grupo' => "{$grupo}"]]); $number = $busca->count(); if ($number > 0) { $proj = $Usuario->Projeto->find()->where(['grupo' => "{$grupo}"])->first(); $usuario->idProjeto = $proj->idprojeto; break; } } } if (isset($obj[0]['smtcategoria'])) { $cat = $Categoria->find('all')->where(['upper(nomeCategoria)' => strtoupper($obj[0]['smtcategoria'][0])])->first(); $usuario->idCategoria = $cat->idCategoria; } array_push($res_ldap, $obj); array_push($res, $usuario); array_push($cats, $cat); $Usuario->save($usuario); } $aviso = new Email('gmail'); $aviso->from(['*****@*****.**' => 'Controle de Usuarios'])->emailFormat('html')->to('*****@*****.**')->subject('JOB Realizado')->send('Job Ajuste Base executado com sucesso.'); $this->set(compact('res', 'res_ldap', 'cats')); }
public function userSignUp($userId) { if ($this->getTableObj()->insertUser($userId)) { \Cake\Log\Log::debug('temp Userid inserted'); return SUCCESS; } return FAIL; }
public function check($restaurantId) { $conditions = ['RestaurantId =' => $restaurantId, 'Active =' => ACTIVE]; $result = $this->connect()->find()->where($conditions); if ($result->count()) { \Cake\Log\Log::debug('restaurant checking result = ' . $result->count()); return true; } return false; }
/** * Hands authorization over to the AnnAuthorize class. * @param array $user * An array containing information about the user to authorize. * @param Request $request * Describes the request to authorize. */ public function authorize($user, Request $request) { $controller = $this->_registry->getController(); $action = $request->param('action'); $pass = $request->param('pass'); Log::debug(sprintf('Trying to authorize user %s for request %s/%s and parameters %s.', $user['username'], $controller->name, $action, json_encode($pass))); $annAuthorization = AnnAuthorization::getInstance(); $authorized = $annAuthorization->authorizeRequest($user['id'], $controller, $action, $pass, $request); Log::debug(sprintf('Authorization %s', $authorized ? 'was successful.' : 'failed.')); return $authorized; }
/** * @param $method * @param array $data * @return \Cake\Network\Http\Response */ protected function getData($method = '', $data = []) { $query = ['version' => 1.3, 'key' => $this->_API_KEY]; foreach ($data as $key => $value) { $query[$key] = $value; } Log::debug($query); $response = $this->http->get($this->_SERVER . $method, $query); Log::debug($response->body); return $response->json; }
public function isLogin() { $userName = $this->readCookie('un'); $password = $this->readCookie('pw'); $restaurantId = $this->readCookie('cri'); \Cake\Log\Log::debug('request come to check login'); if (isset($userName) and isset($password) and isset($restaurantId)) { return TRUE; } return FALSE; }
public function getPaymentOptions() { $this->autoRender = FALSE; if ($this->request->is('post')) { $data = $this->getPaymetModes(); Log::debug(json_encode($data)); $this->response->body(json_encode($data)); } else { $this->response->body(0); } }
public function getOrderDetails($orderDetailsId) { $conditions = ['OrderDetailsId =' => $orderDetailsId]; $orderDetails = $this->connect()->find()->where($conditions); if ($orderDetails->count()) { foreach ($orderDetails as $orderDetail) { $orderDetailDto = new DownloadDTO\OrderDetailsDownloadDto($orderDetail->OrderDetailsId, $orderDetail->OrderPrice, $orderDetail->OrderQuantity, $orderDetail->OrderId, $orderDetail->MenuId, $orderDetail->SubMenuId, $orderDetail->MenuTitle, $orderDetail->Note); Log::debug('OrderDetails goes in sync Table : Id -> ' . $orderDetailDto->orderDetailsId); } return $orderDetailDto; } }
public function editWhenAlways($id) { $entity = $this->Ips->get($id); /** @var IpBehavior $behavior */ $this->Ips->removeBehavior('Ip'); Log::debug($this->Ips->behaviors()->loaded()); $this->Ips->addBehavior('IpBehavior.Ip', ['fields' => ['ip' => 'always']]); if ($this->request->is(['post', 'put'])) { $entity = $this->Ips->patchEntity($entity, $this->request->data()); $this->Ips->save($entity); } }
public function takeawayView() { $data = explode('/', $this->request->url); Log::debug($data); $set = ['option' => $data[1]]; if (in_array('placeorder', $data)) { $takeawaySourceController = new TakeawaySourceController(); $set['source'] = $takeawaySourceController->getTakeawaySource(); $set['addNew'] = true; } $this->set($set); }
public function getSingleCategory($categoryId) { $condition = ['TableCategoryId' => $categoryId]; $tableCategories = $this->connect()->find()->where($condition); if (!$tableCategories->count()) { Log::debug('Table Categories are not found'); return false; } foreach ($tableCategories as $category) { $tableCategoryDto = new DownloadDTO\TableCategoryDownloadDto($category->TableCategoryId, $category->CategoryTitle, $category->Image); } return $tableCategoryDto; }
public function getStdRooms($restaurantId) { \Cake\Log\Log::debug('current restaurantId is :-' . $restaurantId); $allRooms = $this->getTableObj()->getRooms($restaurantId); if ($allRooms) { $mRoom = new \stdClass(); foreach ($allRooms as $room) { $key = $room->roomId; $mRoom->{$key} = $room->description; } return $mRoom; } return FALSE; }
/** * Authentication hook to authenticate a user against an LDAP server. * * @param \Cake\Network\Request $request The request that contains login information. * @param \Cake\Network\Response $response Unused response object. * @return mixed False on login failure. An array of User data on success. */ public function authenticate(Request $request, Response $response) { // This will probably be cn or an email field to search for Log::debug("[Yalp.authenticate] Authentication started", 'yalp'); $userField = $this->form_fields['username']; $passField = $this->form_fields['password']; $userModel = $this->config('userModel'); list($plugin, $model) = pluginSplit($userModel); // Definitely not authenticated if we haven't got the request data... if (!isset($request->data[$userModel])) { Log::error("[Yalp.authenticate] No request data, cannot authenticate", 'yalp'); return false; } // We need to know the username, or email, or some other unique ID $submittedDetails = $request->data[$userModel]; if (!isset($submittedDetails[$userField])) { //Log::write('yalp', "[Yalp.authenticate] No username supplied, cannot authenticate"); return false; } // Make sure it's a valid string... $username = $submittedDetails[$userField]; if (!is_string($username)) { Log::error("[Yalp.authenticate] Invalid username, cannot authenticate", 'yalp'); return false; } // Make sure they gave us a password too... $password = $submittedDetails[$passField]; if (!is_string($password) || empty($password)) { Log::error("[Yalp.authenticate] Invalid password, cannot authenticate", 'yalp'); return false; } // Check whether or not user exists on LDAP if (!$this->Yalp->validateUser($username, $password)) { Log::error("[Yalp.authenticate] User '{$username}' could not be found on LDAP", 'yalp'); return false; } else { Log::debug("[Yalp.authenticate] User '{$username}' was found on LDAP", 'yalp'); } // Check on DB $comparison = 'LOWER(' . $model . '.' . $userField . ')'; $conditions = array($comparison => strtolower($username)); $dbUser = TableRegistry::get($userModel)->find('all', array('conditions' => $conditions, 'recursive' => false))->first(); // If we couldn't find them in the database, warn and fail if (empty($dbUser)) { Log::warning("[Yalp.authenticate] Could not find a database entry for {$username}", 'yalp'); return false; } // ...and return the user object. return $dbUser->toArray(); }
public function deleteCustomer(UploadDTO\CustomerUploadDto $customerInfo, $userInfo) { $conditions = ['CustId =' => $customerInfo->custId, 'RestaurantId =' => $userInfo->restaurantId]; try { $delete = $this->connect()->deleteAll($conditions); if ($delete) { Log::debug('Waiting Customer' . $customerInfo->custName . ' deleted from customer table'); return true; } Log::error('Error Occured in customer table during customer deletion'); return false; } catch (Exception $ex) { return false; } }
public function Create($id) { $returnValue = false; $dbDir = new Folder(SQLITE_DB_DIR, true); \Cake\Log\Log::debug('folder created'); $this->sqliteFile = $dbDir->path . 'TravelDb' . $id . '.sqlite'; $db = new \SQLite3($this->sqliteFile); if ($db != NULL) { $fileContents = file_get_contents(__DIR__ . DS . 'CreateTableScripts.sql'); $db->exec($fileContents); $db->close(); $returnValue = true; } return $returnValue; }
public function getRestaurants($adminId) { $result = null; $counter = 0; if ($adminId) { $conditions = ['AdminUserId' => $adminId]; $restaurants = $this->connect()->find()->where($conditions); foreach ($restaurants as $restaurant) { $result[$counter] = $restaurant->RestaurantId; $counter++; } Log::debug('Admin information send'); } return $result; }
public function isStockClose($day, $month, $year, $restaurantId) { $condtions = ['Day =' => $day, 'Month' => $month, 'Year' => $year, 'RestaurantId =' => $restaurantId]; $fields = ['Closing']; try { $result = $this->connect()->find('all', array('fields' => $fields, 'conditions' => $condtions))->orderAsc('StockLevelId')->first()->toArray(); Log::debug($result); if (!is_null($result['Closing'])) { return True; } return FALSE; } catch (Exception $ex) { return false; } }
public function getTransactionReport() { $this->autoRender = FALSE; $restaurantId = $this->request->query('id'); if ($this->request->is('post')) { Log::debug('Thiis request is post'); } $transactionDetailsController = new TransactionDetailsController(); $reportData = $transactionDetailsController->generateReport($restaurantId); if (count($reportData)) { $response = json_encode($reportData); } else { $response = 0; } $this->response->body($response); }
public function updateConfig($key, $value) { try { $query = $this->connect()->query(); $update = $query->update(); $update->set(['ConfigValue' => $value]); $update->where(['ConfigKey =' => $key]); if ($update->execute()) { \Cake\Log\Log::debug("config updated key : " . $key); return SUCCESS; } return FAIL; } catch (Exception $ex) { echo 'Database Error Occured' . $ex->getMessage(); } }
public function getItems($restaurantId) { $joins = ['a' => ['table' => 'item_brand', 'type' => 'INNER', 'conditions' => 'a.BrandId = recipe_item_details.BrandId '], 'b' => ['table' => 'recipe_item_master', 'type' => 'INNER', 'conditions' => 'b.ItemId = recipe_item_details.ItemId'], 'c' => ['table' => 'unit_master', 'type' => 'INNER', 'conditions' => 'c.UnitId = b.UnitId ']]; $fields = ['BrandCode' => 'a.BrandId', 'BrandName' => 'a.BrandName', 'ItemName' => 'b.ItemName', 'Stock' => 'recipe_item_details.Quantity', 'UnitId' => 'b.UnitId', 'Unit' => 'c.UnitTitle', 'RStock' => 'recipe_item_details.RorderLevel']; $response = FALSE; $counter = 0; $conditions = array('recipe_item_master.RestaurantId =' => $restaurantId); $allRecipItems = $this->connect()->find('all', array('fields' => $fields, 'condition' => $conditions))->orderAsc('a.BrandId')->join($joins); if ($allRecipItems->count()) { foreach ($allRecipItems as $item) { $response[$counter++] = new DownloadDTO\RecipeItemDetailsDwldDto($item->BrandCode, $item->BrandName, $item->Stock, $item->RStock, $item->Unit, $item->ItemName); } } else { Log::debug('Records are not fount in recipe_item_details'); } return $response; }
public function insert(UploadDTO\BillTaxTransactionDto $billTaxTransactions) { $conn = ConnectionManager::get('default'); $tableObj = $this->connect(); $newBillTax = $tableObj->newEntity(); $newBillTax->BillNo = $billTaxTransactions->billNo; $newBillTax->TaxId = $billTaxTransactions->taxId; $newBillTax->TaxAmount = $billTaxTransactions->taxAmt; $newBillTax->CreatedDate = date(VB_DATE_TIME_FORMAT); if ($tableObj->save($newBillTax)) { Log::debug('Bill Tax Transactions has been created for BillNo :-' . $billTaxTransactions->billNo); return $billTaxTransactions->billNo; } $conn->rollback(); Log::error('error ocurred in Bill Tax Transactions creating for BillNo :-' . $billTaxTransactions->billNo); return 0; }
private function makeSyncEntry($billNo, $userId, $restaurantId) { $newBillDetailsEntryList = $this->getTableObj()->getNewDetails($billNo); if (!is_null($newBillDetailsEntryList)) { $syncController = new SyncController(); foreach ($newBillDetailsEntryList as $newBillDetails) { $syncResult = $syncController->billDetailsEntry($userId, json_encode($newBillDetails), INSERT_OPERATION, $restaurantId); if (!$syncResult) { return $syncResult; } } Log::debug(' New bill Details entry successfully place in sync table'); return $syncResult; } Log::error('Error occured in sync entry of new bill Details '); return; }
public function getMenuTag() { $menuTags = $this->connect()->find(); $count = $menuTags->count(); if (!$count) { Log::debug('Menu Tags are not found'); return false; } $allMenuTags[] = null; $i = 0; foreach ($menuTags as $tag) { $menuTagDto = new DownloadDTO\MenuTagDownloadDto($tag->TagId, $tag->TagTitle); $allMenuTags[$i] = $menuTagDto; $i++; } Log::debug('Menu Tags are successfully return'); return $allMenuTags; }
public function getSub($menuId, $restaurantId) { $joins = ['a' => ['table' => 'menu', 'type' => 'INNER', 'conditions' => 'a.MenuId = sub_menu.MenuId and a.RestaurantId =' . $restaurantId . ' and sub_menu.MenuId = ' . $menuId]]; $fields = ['SubMenuId' => 'sub_menu.SubMenuId', 'MenuId' => 'sub_menu.MenuId', 'SubMenuTitle' => 'sub_menu.SubMenuTitle', 'Price' => 'sub_menu.Price']; $allSubMenu = $this->connect()->find('all', array('field' => $fields))->join($joins); $count = $allSubMenu->count(); Log::debug('Number of sub menu are :- ' . $count); $SubMenu = null; if ($count) { $subMenuCounter = 0; foreach ($allSubMenu as $menu) { $SubMenu[$subMenuCounter++] = new DownloadDTO\SubMenuDownloadDto($menu->SubMenuId, $menu->MenuId, $menu->SubMenuTitle, $menu->Price); } return $SubMenu; } else { return false; } }
public function update(UploadDTO\CustomerVisitUpldDto $customerVIsitData) { $conditions = ['RestaurantId =' => $customerVIsitData->restaurantId, 'Month =' => $customerVIsitData->month, 'Year =' => $customerVIsitData->year, 'Day =' => $customerVIsitData->day]; $timeSlot = $customerVIsitData->timeSlot; try { $tableObj = $this->connect(); $entity = $tableObj->get($conditions); $entity->{$timeSlot} = $entity->{$timeSlot} + 1; if ($tableObj->save($entity)) { Log::debug('customer visit updated successfully'); return TRUE; } Log::error('customer visit error in update'); return false; } catch (Exception $ex) { return false; } }
public function prepareInsertStatements() { $allSource = $this->getTakeawaySource(); if (!$allSource) { return false; } $preparedStatements = ''; foreach ($allSource as $source) { $preparedStatements .= TAS_INS_QRY; $preparedStatements = str_replace('@SourceId', $source->sourceId, $preparedStatements); $preparedStatements = str_replace('@SourceName', $source->sourceName, $preparedStatements); $preparedStatements = str_replace('@SourceImg', $source->sourceImg, $preparedStatements); $preparedStatements = str_replace('@Discount', $source->discount, $preparedStatements); $preparedStatements = str_replace('@Active', $source->active, $preparedStatements); } \Cake\Log\Log::debug('Takeaway Insert script :-' . $preparedStatements); return $preparedStatements; }