function getLogin($login, $passw)
{
//check login/md5(user)
App::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 = App::db('sysuser')->result();
if ($res === false) {
return false;
} else {
return $res[0];
}
}
function getUserList()
{
App::db()->query('SELECT * FROM view_msg_from_users');
$rs = App::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;
}
function getUserList()
{
App::db()->query('SELECT * FROM users');
$rs = App::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;
}
<?php use Model\App; use Model\Request; use Service\ConfigParams; include __DIR__ . '/../app/bootstrap.php'; $request = Request::createFromGlobals(); $configParams = new ConfigParams(APP_PATH, APP_URL_BASE, APP_INDEX, APP_TEMPLATE_PATH, APP_TITLE, APP_VERSION, APP_DATABASE_FILE); $app = new App($configParams); echo $app->run($request);
