static protected function action_lister() {
$request = new \Request();
// --> Pagination
$first = $request->first;
$rows = $request->rows;
// --> Sort criteria
$sortField = $request->sortfield;
$sortOrder = $request->sortorder;
$sortCriteria = is_null($sortField) ? 'Use_nombre' : $sortField . (is_null($sortOrder) ? ' ASC' : $sortOrder == 1 ? ' ASC' : ' DESC');
// --> Filter criteria
$criteria = $request->search_criteria;
$keyword = '%' . $criteria . '%';
// 2) Request rows from the database
$response = new \Response();
$jugadorDAO = new jugadorDAO();
$jugadorDAO->setKeywordAsFilter($keyword);
$jugadorFound = array();
try {
$response->total = $jugadorDAO->getCount();
$jugadorDAO->setSortCriteria($sortCriteria);
$jugadorDAO->setLimit($first, $rows);
while ($row = $jugadorDAO->getResult()) {
$jugadorFound[] = $row;
}
$response->rows = $jugadorFound;
$response->success = TRUE;
} catch (\PDOException $ex) {
$response->setFailedMessage(LA_ERROR_MSG_LIST, LA_INFO_MSG_LIST . $ex->getCode());
}
return $response;
}
static protected function action_lister() {
$request = new \Request();
// --> Pagination
$first = $request->first;
$rows = $request->rows;
// --> Sort criteria
$sortField = $request->sortfield;
$sortOrder = $request->sortorder;
$sortCriteria = is_null($sortField) ? 'user_name' : $sortField . (is_null($sortOrder) ? ' ASC' : $sortOrder == 1 ? ' ASC' : ' DESC');
// --> Filter criteria
$criteria = $request->search_criteria;
$filtro = '%' . $criteria . '%';
$response = new \Response();
$usuariosDAO = new usuariosDAO();
// $login = self::getUserlogin();
$usuariosDAO->setNameAsFilter($filtro);
$usuario = array();
try {
$response->total = self::getUsers($filtro, $usuario);
$usuariosDAO->setSortCriteria($sortCriteria);
$usuariosDAO->setLimit($first, $rows);
while ($row = $usuariosDAO->getResult()) {
$usuario[] = $row;
}
/* Réponse retournée au contrôleur principal */
$response->rows = $usuario;
$response->success = true;
} catch (\PDOException $ex) {
$response->setFailedMessage("Dato no encotrado", "No se ha podido encontrar el usuario (error '" . $ex->getCode() . "')");
}
return $response;
}
static public function getUsers($filtro, &$usuario) {
$usuariosDAO = new usuariosDAO();
$usuariosDAO->setNameAsFilter($filtro);
try {
while ($userRow = $usuariosDAO->getResult()) {
$profiles = array();
$profileIDs = array();
self::getUserProfiles($userRow['user_id'], $profiles, $profileIDs);
if (count($profileIDs)) {
$userRow['user_profiles'] = $profiles;
$userRow['profiles[]'] = $profileIDs;
}
// Original password is not provided, a dummy value is returned instead
$userRow['login_password'] = \General::getDummyPassword();
$userRow['login_password2'] = \General::getDummyPassword();
$usuario[] = $userRow;
}
} catch (\PDOException $e) {
$response = new \Response();
$response->setCriticalMessage("Dato no encotrado", "No se ha podido encontrar el usuario", $e, TRUE);
}
return $usuariosDAO->getCount();
}