public function index()
{
$this->autoRender = false;
$data = $this->request->data;
if (empty($data)) {
$this->response->body(DTO\ClsErrorDto::prepareError(106));
\Cake\Log\Log::debug("Image data empty");
return;
}
if (!array_key_exists('userId', $data) or !array_key_exists('emailId', $data) or !array_key_exists('userName', $data)) {
$this->response->body(DTO\ClsErrorDto::prepareError(107));
\Cake\Log\Log::debug("Image data empty");
return;
}
$userTable = new Table\UserTable();
if (!$userTable->userCkeck($data['userId'], $data['emailId'], $data['userName'])) {
$this->response->body(DTO\ClsErrorDto::prepareError(112));
return;
}
if (array_key_exists('destId', $data)) {
$imagesController = new ImagesController();
$result = $imagesController->uploadDestinationImage($data);
if ($result) {
\Cake\Log\Log::debug("Destination image uploaded successfully");
} else {
\Cake\Log\Log::error("Invalid image extension");
}
} else {
$imagesController = new ImagesController();
$result = $imagesController->uploadProfileImage($data);
if ($result) {
\Cake\Log\Log::debug("profile image uploaded successfully");
} else {
\Cake\Log\Log::error("Invalid image extension");
}
}
}
<?php
// Ensure we have session
if (session_id() === "") {
session_start();
}
use App\Controller\ImagesController;
require_once "app/Controller/ImagesController.php";
$action = null;
if (isset($_GET['a'])) {
$action = $_GET['a'];
}
$imagesController = new ImagesController($action);
$fragment = $imagesController->dispatch();
require_once "app/View/fragments/header.html";
echo $fragment;
require_once "app/View/fragments/footer.html";
public function getDB($userId)
{
$this->autoRender = false;
$tableObject = new Table\SqliteTable();
if ($tableObject->Create($userId)) {
//Destination Table
$destinationController = new DestinationController();
$destinationPreparedStatement = $destinationController->prepareInsertStatement();
if ($tableObject->excutePreparedStatement($destinationPreparedStatement)) {
\Cake\Log\Log::info('Record is inserted into Destination SQLite table for id ' . $userId);
} else {
\Cake\Log\Log::error('Record is not inserted into Destination SQLite table');
}
//User Table
$userController = new UserController();
$userPreparedStatement = $userController->prepareInsertStatement();
if ($tableObject->excutePreparedStatement($userPreparedStatement)) {
\Cake\Log\Log::info('Record is inserted into User SQLite table for id ' . $userId);
} else {
\Cake\Log\Log::error('Record is not inserted into User SQLite table');
}
//Question Table
$questionController = new QuestionController();
$questionPreparedStatement = $questionController->prepareInsertStatement();
if ($tableObject->excutePreparedStatement($questionPreparedStatement)) {
\Cake\Log\Log::debug('Record is inserted into Question sQLite table for id' . $userId);
} else {
\Cake\Log\Log::debug('Record is not inserted into Question sQLite table for id');
}
//Options Table
$optionController = new OptionsController();
$optionPreparedStatement = $optionController->prepareInsertStatement();
if ($tableObject->excutePreparedStatement($optionPreparedStatement)) {
\Cake\Log\Log::debug('Record is inserted into Options sQLite table for id' . $userId);
} else {
\Cake\Log\Log::debug('Record is not inserted into Options sQLite table for id');
}
//Answer Table
$answerController = new AnswerController();
$answerPreparedStatement = $answerController->prepareInsertStatement();
if ($tableObject->excutePreparedStatement($answerPreparedStatement)) {
\Cake\Log\Log::debug('Record is inserted into Answer sQLite table for id' . $userId);
} else {
\Cake\Log\Log::debug('Record is not inserted into Answer sQLite table for id');
}
//Comment And Like Table
$commentAndLikeController = new CommentAndLikeController();
$commentAndLikePreparedStatement = $commentAndLikeController->prepareInsertStatement();
if ($tableObject->excutePreparedStatement($commentAndLikePreparedStatement)) {
\Cake\Log\Log::debug('Record is inserted into commentAndLike sQLite table for id' . $userId);
} else {
\Cake\Log\Log::debug('Record is not inserted into commentAndLike sQLite table for id');
}
//Images Table
$imagesController = new ImagesController();
$imagesPreparedStatement = $imagesController->prepareInsertStatement();
if ($tableObject->excutePreparedStatement($imagesPreparedStatement)) {
\Cake\Log\Log::debug('Record is inserted into Images sQLite table for id' . $userId);
} else {
\Cake\Log\Log::debug('Record is not inserted into Images sQLite table for id');
}
//Stat_Config Table
$statconfController = new StatConfController();
$statconfPreparedStatement = $statconfController->prepareInsertStatement();
if ($tableObject->excutePreparedStatement($statconfPreparedStatement)) {
\Cake\Log\Log::debug('Record is inserted into stat_conf sQLite table for id' . $userId);
} else {
\Cake\Log\Log::debug('Record is not inserted into stat_conf SQLite table for id');
}
$this->response->type('class');
$this->response->file(SQLITE_DB_DIR . 'TravelDb' . $userId . '.sqlite', ['download' => true]);
$this->response->send();
$retult = unlink(SQLITE_DB_DIR . 'TravelDb' . $userId . '.sqlite');
\Cake\Log\Log::info('TravelDb.' . $userId . '.sqlite File deleted successfully');
$userTable = new Table\UserTable();
//$userTable->update($userId);
}
}
