public function validate() { $this->autoRender = false; if ($this->request->is('post')) { $data = $this->request->data; $credential = \appconfig::getAdminCredential(); //\Cake\Log\Log::debug("Admin credential from config table : ".$credential['username']); if ($data['username'] == $credential['username'] and $data['password'] == $credential['password']) { session_start(); $_SESSION['login'] = '******'; setcookie('Id', $credential['username'], time() + 60 * 60, "/"); $pass = md5($credential['password']); setcookie('pass', $pass, time() + 60 * 60, "/"); // \Cake\Log\Log::info("Cookie varible after created: ".$_SESSION['login']); // \Cake\Log\Log::debug("redirect to destiationform controller"); $this->redirect(['controller' => 'HomeForm', 'action' => 'adminPanel']); } else { session_start(); $_SESSION['message'] = 'Username and Password wrong !!'; $this->redirect(['controller' => 'LoginForm', 'action' => 'index']); } } else { die('Request error occured'); } }
function query($sql, $accion) { require_once 'appconfig.php'; $appconfig = new appconfig(); $datos = $appconfig->conexion(); $hostname = $datos['hostname']; $database = $datos['database']; $username = $datos['username']; $password = $datos['password']; /* $hostname = "localhost"; $database = "lacalder_diablo"; $username = "******"; $password = "******";*/ $conex = mysql_connect($hostname, $username, $password) or die("no se puede conectar" . mysql_error()); mysql_select_db($database); /* $result = mysql_query($sql,$conex); if ($accion && $result) { $result = mysql_insert_id(); } mysql_close($conex); return $result; */ $error = 0; mysql_query("BEGIN"); $result = mysql_query($sql, $conex); if ($accion && $result) { $result = mysql_insert_id(); } if (!$result) { $error = 1; } if ($error == 1) { mysql_query("ROLLBACK"); return false; } else { mysql_query("COMMIT"); return $result; } }
private function questionPagination($page = 1) { $questionTable = new Table\QuestionTable(); if (!$questionTable->connect()->find()->count()) { return NOT_FOUND; } $allquestions = array(); $i = 0; $limit = \appconfig::getPageSize(); $questions = $this->Paginator->paginate($questionTable->connect()->find(), ['limit' => $limit, 'page' => $page]); foreach ($questions as $question) { $questionDto = new DTO\ClsQuestionDto($question->QuestionId, $question->QuestionText, $question->Active); $allquestions[$i] = $questionDto; $i++; } return $allquestions; }
private function configurationPagination($page = 1) { $statconfTable = new Table\StatConfTable(); if (!$statconfTable->connect()->find()->count()) { return NOT_FOUND; } $allConfig = array(); $i = 0; $limit = \appconfig::getPageSize(); $configurations = $this->Paginator->paginate($statconfTable->connect()->find(), ['limit' => $limit, 'page' => $page]); foreach ($configurations as $configuration) { $statConfDto = new DTO\ClsStatConfigDto($configuration->ConfigKey, $configuration->ConfigValue); $allConfig[$i] = $statConfDto; $i++; } return $allConfig; }
private function createS3Client() { $this->autoRender = false; $s3FactoryArgs = \appconfig::getAwsDefaults(LOCAL_ENV); $s3Client = S3Client::factory($s3FactoryArgs); \Cake\Log\Log::info("S3Client instantiation completed"); return $s3Client; }
private function destinationPagination($page = 1) { $destinationTable = new Table\DestinationTable(); if (!$destinationTable->connect()->find()->count()) { return NOT_FOUND; } $allDest = array(); $i = 0; $limit = \appconfig::getPageSize(); $destination = $this->Paginator->paginate($destinationTable->connect()->find(), ['limit' => $limit, 'page' => $page]); foreach ($destination as $row) { $destDto = new DTO\ClsDestinationDto($row->DestId, $row->DestName, $row->Latitude, $row->Longitude, $row->Active); $allDest[$i] = $destDto; $i++; } return $allDest; }