public function execute()
{
//SESSION
$session = SessionFactory::create();
//PARAMETERS
$params = RequestParametersFactory::create();
$session = SessionFactory::create();
if (!$session->get("authenticated") and $params->get('public_key') == $session->get('randLogin')) {
//PARAMETERS:
$params = RequestParametersFactory::create();
$username = $params->get('user-name');
$userpassword = $params->get('user-password');
$filter = FilterFactory::create();
$filteredUsername = $filter->filters($username);
//DATAHANDLER
$datahandler = DatahandlerFactory::create('D_ReadUserByName');
$datahandler->setInData($filteredUsername);
$existingUser = $datahandler->getOutData();
//ENCRYPTOR
$isAuthenticate = crypt($userpassword, $existingUser['password']) === $existingUser['password'];
if ($isAuthenticate) {
//SET SESSION DATA
$session->set('session-user-name', $existingUser['name']);
$session->set('session-user-id', $existingUser['id']);
$session->set("authenticated", true);
} else {
$session->set("authenticated", false);
}
}
}
public function setInData($datafile)
{
//FOR ERROR Allowed memory size of 134217728
//bytes exhausted (tried to allocate 20 bytes):
ini_set('memory_limit', '-1');
ini_set('upload_max_filesize', '500M');
set_time_limit(100);
// ini_set('memory_limit', '100M');
$tmpdata = array();
$logfile = file($datafile);
foreach ($logfile as $linenumber => $line) {
array_push($tmpdata, explode(" ", $line));
}
foreach ($tmpdata as $key => $line) {
$newline = array();
foreach ($line as $key => $datum) {
if ($datum != null) {
array_push($newline, $datum);
}
}
array_push($this->data, $newline);
}
$db = DatabaseFactory::create("SquidDatabase")->connect();
$queries = array();
$query1 = "DELETE FROM SquidData";
array_push($queries, $query1);
$filter = FilterFactory::create();
foreach ($this->data as $key => $datum) {
$date = date('d-m-Y', $filter->filters($datum[0]));
$time = date('H:i:s', $filter->filters($datum[0]));
$transaction_time = $datum[1];
$client_ip = $filter->filters($datum[2]);
$squid_result_code = $filter->filters($datum[3]);
$client_data = $datum[4];
$request_method = $filter->filters($datum[5]);
$url = $filter->filters($datum[6]);
$mime_type = $filter->filters($datum[9]);
$query2 = "INSERT INTO SquidData\n \t\t\t\t\t (\n \t\t\t\t\t\t\tdate, time, transaction_time, \n \t\t\t\t\t\t\tclient_ip, squid_result_code,\n \t\t\t\t\t\t\tclient_data, request_method,\n \t\t\t\t\t\t\turl, mime_type\n \t\t\t\t\t ) \n\t\t\t\t\t\tVALUES (\n\t\t\t\t\t\t\t\t\t'{$date}', '{$time}', {$transaction_time},\n\t\t\t\t\t\t\t\t\t'{$client_ip}', '{$squid_result_code}',\n\t\t\t\t\t\t\t\t\t{$client_data}, '{$request_method}',\n\t\t\t\t\t\t\t\t\t'{$url}', '{$mime_type}'\n\t\t\t\t\t\t\t )";
array_push($queries, $query2);
}
$db->SQLTransaction($queries);
}
public function execute()
{
//PARAMETERS
$params = RequestParametersFactory::create();
$name = $params->get('role-name');
$description = $params->get('role-description');
//FILTERS
$filter = FilterFactory::create();
$filteredName = $filter->filters($name);
//VALIDATOR//VALIDO QUE EL ROLE YA NO EXISTA
$datahandler = DatahandlerFactory::create();
$datahandler['D_ReadRoleByName']->setInData($filteredName);
$existingRole = $datahandler['D_ReadRoleByName']->getOutData();
$validator = ValidatorFactory::create();
$validator->ifFalse($existingRole['name'] == null)->respond(EXISTING_ROLE);
//DATAHANDLER
$datahandler['D_CreateRole']->setInData(array("name" => "{$name}", "description" => "{$description}"));
//REDIRECTOR
$redirector = RedirectorFactory::create();
$redirector->redirectTo('index.php?A_ReadRolesPaginated');
}
public function execute()
{
//PARAMETERS
$params = RequestParametersFactory::create();
$name = $params->get('role-name');
$description = $params->get('role-description');
$session = SessionFactory::create();
$id = $session->get('role-id');
//FILTERS
$filter = FilterFactory::create();
$filteredName = $filter->filters($name);
$filteredDescription = $filter->filters($description);
//VALIDATOR
$validator = ValidatorFactory::create();
//DATASET
$datahandler = DatahandlerFactory::create('D_UpdateRole');
$datahandler->setInData(array("id" => "{$id}", "name" => "{$filteredName}", "description" => "{$filteredDescription}"));
//REDIRECTOR
$redirector = RedirectorFactory::create();
$redirector->redirectTo('index.php?A_ReadRolesPaginated');
}
public function execute()
{
//FILTERS
$filter = FilterFactory::create();
//PARAMETERS
$params = RequestParametersFactory::create();
$name = $filter->filters($params->get('user-name'));
$password = $params->get('user-password');
$passwordConfirmation = $params->get('password-confirmation');
$encryptPassword = crypt($password);
//VALIDATION
$datahandler = DatahandlerFactory::create();
$datahandler['D_ReadUserByName']->setInData($name);
$data = $datahandler['D_ReadUserByName']->getOutData();
$validator = ValidatorFactory::create();
$validator->ifTrue($data['name'] != null)->respond(EXISTING_USER);
$validator->ifFalse($password == $passwordConfirmation)->respond(PASSWORDS_NOT_MATCH);
//DATAHANDLER
$datahandler['D_CreateUser']->setInData(array("name" => "{$name}", "password" => "{$encryptPassword}"));
//REDIRECTOR
$redirector = RedirectorFactory::create();
$redirector->redirectTo('index.php?A_ReadUsersPaginated');
}
public function execute()
{
//PARAMETERS
$params = RequestParametersFactory::create();
$name = $params->get('user-name');
$password = $params->get('user-password');
$passwordConfirmation = $params->get('password-confirmation');
$encryptPassword = crypt($password);
$session = SessionFactory::create();
$id = $session->get('user-id');
//FILTERS
$filter = FilterFactory::create();
$filter->filters($name);
//VALIDATOR
$validator = ValidatorFactory::create();
$validator->ifFalse($password == $passwordConfirmation)->respond(PASSWORDS_NOT_MATCH);
//DATASET
$datahandler = DatahandlerFactory::create('D_UpdateUser');
$datahandler->setInData(array("id" => "{$id}", "name" => "{$name}", "password" => "{$encryptPassword}"));
//REDIRECTOR
$redirector = RedirectorFactory::create();
$redirector->redirectTo('index.php?A_ReadUsersPaginated');
}
