Beispiel #1
0
 function userAccess()
 {
     // Pegando dados de ACESSO do cliente
     Q::db()->query('INSERT INTO access (REQUEST,METHOD,REMOTE,AGENT,ACCEPT,ENCODING,LANGUAGE,IDATE)
                         VALUES (:req,:met,:rem,:age,:acc,:enc,:lan,:idate)', [':req' => $_SERVER['REQUEST_URI'], ':met' => $_SERVER['REQUEST_METHOD'], ':rem' => $_SERVER['REMOTE_ADDR'], ':age' => $_SERVER['HTTP_USER_AGENT'], ':acc' => $_SERVER['HTTP_ACCEPT'], ':enc' => $_SERVER['HTTP_ACCEPT_ENCODING'], ':lan' => $_SERVER['HTTP_ACCEPT_LANGUAGE'], ':idate' => date('Y-m-d H:I:s')]);
     Q::db()->query('DELETE FROM access WHERE DATE(access.IDATE) <= DATE(DATE(NOW())-30)');
 }
Beispiel #2
0
 function getLogin($login, $passw)
 {
     //check login/md5(user)
     Q::db('sysuser')->query('SELECT CONCAT(primeiro_nome, " ", segundo_nome)NAME, id as ID
                                 FROM `erp_usuarios`
                                 WHERE email = :login
                                 AND   senha = :passw
                                 AND   ativo = 1', [':login' => $login, 'passw' => md5($passw)]);
     $res = Q::db('sysuser')->result();
     if ($res === false) {
         return false;
     } else {
         return $res[0];
     }
 }
Beispiel #3
0
 function getUserList()
 {
     Q::db()->query('SELECT * FROM users');
     $rs = Q::db()->result();
     if ($rs === false) {
         return false;
     }
     $o = [];
     foreach ($rs as $col) {
         $o[$col->ID]['id'] = $col->ID;
         $o[$col->ID]['name'] = $col->NAME;
         $o[$col->ID]['last'] = $col->LAST;
     }
     return $o;
 }
Beispiel #4
0
 function getUserList()
 {
     //Q::db()->query('SELECT * FROM users');
     //OR use a view
     Q::db()->query('SELECT * FROM view_msg_from_users');
     $rs = Q::db()->result();
     if ($rs === false) {
         return false;
     }
     $o = [];
     foreach ($rs as $col) {
         $o[$col->ID]['id'] = $col->ID;
         $o[$col->ID]['name'] = $col->NAME;
         $o[$col->ID]['last'] = $col->LAST;
         $o[$col->ID]['total'] = $col->TOTAL;
         $o[$col->ID]['type'] = $col->TYPE;
     }
     return $o;
 }