public function getOutData()
 {
     $id = $this->data;
     $query = "SELECT roles.*, 1 as status\n                  FROM roles \n                  LEFT JOIN users_roles\n                  ON users_roles.role_id = roles.id\n                  WHERE users_roles.user_id = {$id}\n\n\t\t\t\t  UNION\n\n\t\t\t\t  SELECT roles.*, 0 as status\n                  FROM roles \n                  WHERE roles.id NOT IN \n                  (\n                  \tSELECT roles.id\n\t\t\t      \tFROM roles\n\t\t    \t  \tLEFT JOIN users_roles\n\t\t          \tON users_roles.role_id = roles.id\n\t\t          \tWHERE users_roles.user_id = {$id}\n\t\t          )";
     $db = DatabaseFactory::create("AAADatabase")->connect();
     return $db->SQLFetchAllArray($query);
 }
 public function getOutData()
 {
     $id = $this->data;
     $query = "SELECT users.*, 1 as status\n                  FROM users \n                  LEFT JOIN users_roles\n                  ON users_roles.user_id = users.id\n                  WHERE users_roles.role_id = {$id}";
     $db = DatabaseFactory::create("AAADatabase")->connect();
     return $db->SQLFetchAllArray($query);
 }
 public function getOutData()
 {
     $actionName = $this->data;
     $query = "SELECT roles.*\n                  FROM roles\n                  LEFT JOIN roles_actions\n                  ON roles_actions.role_id = roles.id\n                  WHERE roles_actions.action_name = '{$actionName}'";
     $db = DatabaseFactory::create("AAADatabase")->connect();
     return $db->SQLFetchAllArray($query);
 }
 public function getOutData()
 {
     $id = $this->data;
     $query = "SELECT actions.*, 1 as status\n                  FROM actions \n                  LEFT JOIN roles_actions\n                  ON roles_actions.action_name = actions.name\n                  WHERE roles_actions.role_id = {$id}\n\n\t\t\t\t  UNION\n\n\t\t\t\t  SELECT actions.*, 0 as status\n                  FROM actions \n                  WHERE actions.name NOT IN \n                  (\n                  \tSELECT actions.name\n\t\t\t      \tFROM actions\n\t\t    \t  \tLEFT JOIN roles_actions\n\t\t          \tON roles_actions.action_name = actions.name\n\t\t          \tWHERE roles_actions.role_id = {$id}\n\t\t          ) ORDER BY actions.name DESC";
     $db = DatabaseFactory::create("AAADatabase")->connect();
     return $db->SQLFetchAllArray($query);
 }
 public function setInData($data)
 {
     $id = $data;
     $query = "DELETE FROM Users WHERE id={$id}";
     $db = DatabaseFactory::create("AAADatabase")->connect();
     $db->SQLQuery($query);
 }
 public function getOutData()
 {
     $name = $this->data;
     $query = "SELECT * FROM Users WHERE name LIKE '%{$name}%'";
     $db = DatabaseFactory::create("AAADatabase")->connect();
     return $db->SQLFetchAllArray($query);
 }
 public function getOutData()
 {
     $id = $this->data;
     $query = "SELECT * FROM Users WHERE id = {$id}";
     $db = DatabaseFactory::create("AAADatabase")->connect();
     return $db->SQLFetchArray($query);
 }
 public function getOutData()
 {
     $date = $this->data['date'];
     $db = DatabaseFactory::create("SquidDatabase")->connect();
     $rowsTotalNumberInArray = $db->SQLFetchArray("SELECT COUNT(*)\n                                                         FROM SquidData\n                                                         WHERE date = '{$date}' ");
     return (int) $rowsTotalNumberInArray['COUNT(*)'];
 }
 public function getOutData()
 {
     $date = $this->data['date'];
     $query = "SELECT client_ip, COUNT(client_ip) as frequency \n                    FROM SquidData \n        \t\t\tWHERE date = '{$date}'\n                    GROUP BY client_ip \n        \t\t\tORDER BY frequency DESC";
     $db = DatabaseFactory::create("SquidDatabase")->connect();
     return $db->SQLFetchAllArray($query);
 }
 public function getOutData()
 {
     $clientIp = $this->data['client-ip'];
     $date = $this->data['date'];
     $query = "SELECT client_data, time, url\n                    FROM SquidData \n                    WHERE client_ip = '{$clientIp}' AND date = '{$date}'\n                    ORDER BY time";
     $db = DatabaseFactory::create("SquidDatabase")->connect();
     return $db->SQLFetchAllArray($query);
 }
 public function setInData($data)
 {
     $name = $data['name'];
     $description = $data['description'];
     $query = "INSERT INTO Roles (name, description) VALUES ('{$name}', '{$description}')";
     $db = DatabaseFactory::create("AAADatabase")->connect();
     $db->SQLQuery($query);
 }
 public function getOutData()
 {
     $clientIp = $this->data['client-ip'];
     $date = $this->data['date'];
     $query = "SELECT url, date, time, COUNT(url) as frequency \n                    FROM SquidData \n                    WHERE client_ip = '{$clientIp}' AND date = '{$date}'\n                    GROUP BY url\n                    ORDER BY frequency DESC";
     $db = DatabaseFactory::create("SquidDatabase")->connect();
     return $db->SQLFetchAllArray($query);
 }
 public function setInData($data)
 {
     $name = $data['name'];
     $password = $data['password'];
     $query = "INSERT INTO Users (name, password) VALUES ('{$name}', '{$password}')";
     $db = DatabaseFactory::create("AAADatabase")->connect();
     $db->SQLQuery($query);
 }
 public function getOutData()
 {
     $clientIp = $this->data['client-ip'];
     $date = $this->data['date'];
     $db = DatabaseFactory::create("SquidDatabase")->connect();
     $rowsTotalNumberInArray = $db->SQLFetchArray("SELECT COUNT(client_data)\n                                                         FROM SquidData\n                                                         WHERE client_ip = '{$clientIp}' \n                                                         AND date = '{$date}'\n                                                         ORDER BY time");
     return (int) $rowsTotalNumberInArray['COUNT(client_data)'];
 }
 public function setInData($data)
 {
     $name = $data['name'];
     $password = $data['password'];
     $id = $data['id'];
     $query = "UPDATE Users SET\n                     name = '{$name}', \n                     password = '******' \n                     WHERE id = {$id}";
     $db = DatabaseFactory::create("AAADatabase")->connect();
     $db->SQLQuery($query);
 }
 public function getOutData()
 {
     $paginator = PaginatorFactory::create();
     $beginning = $paginator->beginning;
     $rowsPerPage = $paginator->rowsPerPage;
     $query = "SELECT client_ip, url, COUNT(client_ip) as frequency FROM SquidData \n        \t\t\tGROUP BY client_ip \n        \t\t\t\tORDER BY frequency DESC \n        \t\t\t\t\tLIMIT {$beginning}, {$rowsPerPage}";
     $db = DatabaseFactory::create("SquidDatabase")->connect();
     return $db->SQLFetchAllArray($query);
 }
 public function getOutData()
 {
     $paginator = PaginatorFactory::create();
     $beginning = $paginator->beginning;
     $rowsPerPage = $paginator->rowsPerPage;
     $query = "SELECT * FROM Roles ORDER BY name LIMIT {$beginning}, {$rowsPerPage}";
     $db = DatabaseFactory::create("AAADatabase")->connect();
     return $db->SQLFetchAllArray($query);
 }
 public function setInData($data)
 {
     $id = $data['id'];
     $name = $data['name'];
     $description = $data['description'];
     $query = "UPDATE Roles SET\n                     name = '{$name}', \n                     description = '{$description}' \n                     WHERE id = {$id}";
     $db = DatabaseFactory::create("AAADatabase")->connect();
     $db->SQLQuery($query);
 }
 public function getOutData()
 {
     $actionName = $this->data['action-name'];
     $userId = $this->data['user-id'];
     $adminRoleId = $this->data['admin-role-id'];
     $query = "SELECT roles.*\n                  FROM roles\n                  LEFT JOIN roles_actions\n                  ON roles_actions.role_id = roles.id\n                  WHERE roles_actions.action_name = '{$actionName}'\n\n        \t\t\t\t  INTERSECT\n\n        \t\t\t\t  SELECT roles.*\n                          FROM roles \n                          LEFT JOIN users_roles\n                          ON users_roles.role_id = roles.id\n                          WHERE users_roles.user_id = {$userId}\n\n                  UNION\n\n                  SELECT roles.*\n                          FROM roles \n                          LEFT JOIN users_roles\n                          ON users_roles.role_id = {$adminRoleId}\n                          WHERE users_roles.user_id = {$userId}";
     $db = DatabaseFactory::create("AAADatabase")->connect();
     return $db->SQLFetchAllArray($query);
 }
 public function getOutData()
 {
     $id = $this->data;
     $paginator = PaginatorFactory::create();
     $beginning = $paginator->beginning;
     $rowsPerPage = $paginator->rowsPerPage;
     $query = "SELECT actions.*, 1 as status\n                  FROM actions \n                  LEFT JOIN roles_actions\n                  ON roles_actions.action_name = actions.name\n                  WHERE roles_actions.role_id = {$id}\n\n\t\t\t\t  UNION\n\n\t\t\t\t  SELECT actions.*, 0 as status\n                  FROM actions \n                  WHERE actions.name NOT IN \n                  (\n                  \tSELECT actions.name\n\t\t\t      \tFROM actions\n\t\t    \t  \tLEFT JOIN roles_actions\n\t\t          \tON roles_actions.action_name = actions.name\n\t\t          \tWHERE roles_actions.role_id = {$id}\n\t\t          ) ORDER BY actions.name \n\t\t\t\t\tLIMIT {$beginning}, {$rowsPerPage}";
     $db = DatabaseFactory::create("AAADatabase")->connect();
     return $db->SQLFetchAllArray($query);
 }
Beispiel #21
0
 public function __construct()
 {
     $site_path = realpath(dirname(__FILE__)) . DIRECTORY_SEPARATOR . '../lib/config.ini';
     try {
         $this->db = DatabaseFactory::create($site_path);
         $this->exec = DatabaseFactory::getExecute($site_path);
         $_SESSION['namebd'] = strtoupper($this->db->getAttribute(PDO::ATTR_DRIVER_NAME));
     } catch (PDOException $e) {
         $error = 'Conexion Fallada: ' . $e->getMessage();
         header("Location:index.php?controller=BaseDatos&action=orror&str=" . $error);
     }
 }
 public function setInData($data)
 {
     $actions = $data;
     $queries = array();
     $query1 = "DELETE FROM actions";
     array_push($queries, $query1);
     foreach ($actions as $actionKey => $actionValue) {
         $query2 = "INSERT OR REPLACE INTO actions (name) VALUES \n\t\t\t        ('{$actionKey}')";
         array_push($queries, $query2);
     }
     $db = DatabaseFactory::create("AAADatabase")->connect();
     $db->SQLTransaction($queries);
 }
 public function setInData($data)
 {
     $this->data = $data;
     $actionsNames = $this->data['selected-actions-names'];
     $roleId = $this->data['selected-role-id'];
     $queries = array();
     $query1 = "DELETE FROM roles_actions WHERE role_id='{$roleId}'";
     array_push($queries, $query1);
     foreach ($actionsNames as $actionName) {
         $query2 = "INSERT OR REPLACE INTO roles_actions (role_id, action_name) VALUES \n\t\t\t        ('{$roleId}', '{$actionName}')";
         array_push($queries, $query2);
     }
     $db = DatabaseFactory::create("AAADatabase")->connect();
     $db->SQLTransaction($queries);
 }
 public function setInData($data)
 {
     $this->data = $data;
     $rolesIds = $this->data['selected-roles-ids'];
     $userId = $this->data['selected-user-id'];
     $queries = array();
     $query1 = "DELETE FROM users_roles WHERE user_id='{$userId}'";
     array_push($queries, $query1);
     foreach ($rolesIds as $roleId) {
         $query2 = "INSERT OR REPLACE INTO users_roles (user_id, role_id) VALUES \n\t\t\t        ('{$userId}', '{$roleId}')";
         array_push($queries, $query2);
     }
     $db = DatabaseFactory::create("AAADatabase")->connect();
     $db->SQLTransaction($queries);
 }
 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 getOutData()
 {
     $query = "SELECT client_ip FROM SquidData \n        \t\t\tGROUP BY client_ip \n        \t\t\t\tORDER BY client_ip";
     $db = DatabaseFactory::create("SquidDatabase")->connect();
     return $db->SQLFetchAllArray($query);
 }
 public function getOutData()
 {
     $db = DatabaseFactory::create("AAADatabase")->connect();
     return $db->SQLFetchAllArray("SELECT * FROM Users ORDER BY name");
 }
 public function getOutData()
 {
     $db = DatabaseFactory::create("AAADatabase")->connect();
     $rowsTotalNumberInArray = $db->SQLFetchArray("SELECT COUNT(*) FROM Users");
     return (int) $rowsTotalNumberInArray['COUNT(*)'];
 }