/**
* retrieve list of stored sessions
* @param {array} data received data query parameters
* @param {boolean} ring: if true exclude "-- Sin asignar --" session 1
* @return {array} session list in easyui json expected format, or error string
*/
function select($data, $ring = false)
{
$this->myLogger->enter();
//needed to properly handle multisort requests from datagrid
$sort = getOrderString(http_request("sort", "s", ""), http_request("order", "s", ""), "Nombre ASC, Comentario ASC");
// search string
$search = isset($_GET['where']) ? strval($_GET['where']) : '';
// evaluate offset and row count for query
$page = http_request("page", "i", 1);
$rows = http_request("rows", "i", 50);
$limit = "";
if ($page != 0 && $rows != 0) {
$offset = ($page - 1) * $rows;
$limit = "" . $offset . "," . $rows;
}
// if hidden==0 hide console related sessions
$ringstr = " AND 1";
if ($ring) {
$ringstr = " AND (Sesiones.ID > 1)";
}
$searchstr = " AND 1";
if ($search !== "") {
$searchstr = "AND (Nombre LIKE '%{$search}%') AND ( ( Comentario LIKE '%{$search}%' ) OR ( Operador LIKE '%{$search}%') ) ";
}
$hiddenstr = " AND 1";
if ($data['Hidden'] == 0) {
$hiddenstr = "AND (Nombre != 'Console')";
}
$result = $this->__select("Sesiones.ID AS ID,Nombre,Comentario,Operador,Prueba,Jornada,Manga,Tanda,Login,Background,LiveStream,LiveStream2,LiveStream3", "Sesiones,Usuarios", "( Sesiones.Operador = Usuarios.ID ) {$hiddenstr} {$searchstr} {$ringstr}", $sort, $limit);
$this->myLogger->leave();
return $result;
}
function select()
{
$this->myLogger->enter();
//needed to properly handle multisort requests from datagrid
$sort = getOrderString(http_request("sort", "s", ""), http_request("order", "s", ""), "Login ASC");
// search string
$search = isset($_GET['where']) ? strval($_GET['where']) : '';
// evaluate offset and row count for query
$page = http_request("page", "i", 1);
$rows = http_request("rows", "i", 50);
$limit = "";
if ($page != 0 && $rows != 0) {
$offset = ($page - 1) * $rows;
$limit = "" . $offset . "," . $rows;
}
$where = "(Login != 'root') ";
// hide root user to app
if ($search !== '') {
$where = " AND ( (Login LIKE '%{$search}%') OR ( Gecos LIKE '%{$search}%' ) OR ( Email LIKE '%{$search}%') ) ";
}
$result = $this->__select("*", "Usuarios", $where, $sort, $limit);
$this->myLogger->leave();
return $result;
}
/**
* Enumerate all dogs that matches requested criteria and order
* @return null on error, else requested data
*/
function select()
{
$this->myLogger->enter();
// evaluate offset and row count for query
$sort = getOrderString(http_request("sort", "s", ""), http_request("order", "s", ""), "Nombre ASC");
$this->myLogger->debug("Sort order is: {$sort}");
$search = http_request("where", "s", "");
$page = http_request("page", "i", 1);
$rows = http_request("rows", "i", 50);
$federation = http_request("Federation", "i", -1);
$fed = "1";
if ($federation >= 0) {
$fed = "( Federation = {$federation} )";
}
$where = "1";
$limit = "";
if ($page != 0 && $rows != 0) {
$offset = ($page - 1) * $rows;
$limit = "" . $offset . "," . $rows;
}
if ($search !== "") {
$where = "( (Nombre LIKE '%{$search}%') OR ( NombreGuia LIKE '%{$search}%') OR ( Licencia LIKE '%{$search}%') OR ( NombreClub LIKE '%{$search}%') )";
}
$result = $this->__select("*", "PerroGuiaClub", "{$fed} AND {$where}", $sort, $limit);
$this->myLogger->leave();
return $result;
}
function select()
{
$this->myLogger->enter();
//needed to properly handle multisort requests from datagrid
$sort = getOrderString(http_request("sort", "s", ""), http_request("order", "s", ""), "ID ASC");
// evaluate if any search criteria
$search = http_Request("where", "s", "");
// evaluate offset and row count for query
$page = http_request("page", "i", 1);
$rows = http_request("rows", "i", 25);
$limit = "";
if ($page != 0 && $rows != 0) {
$offset = ($page - 1) * $rows;
$limit = "" . $offset . "," . $rows;
}
$where = "(Equipos.Prueba={$this->pruebaID}) AND (Equipos.Jornada={$this->jornadaID})";
if ($search !== '') {
$where = $where . " AND ( (Equipos.Nombre LIKE '%{$search}%') OR ( Equipos.Observaciones LIKE '%{$search}%') ) ";
}
$result = $this->__select("*", "Equipos", $where, $sort, $limit);
$this->myLogger->leave();
return $result;
}
function select()
{
$this->myLogger->enter();
//needed to properly handle multisort requests from datagrid
$sort = getOrderString(http_request("sort", "s", ""), http_request("order", "s", ""), "Nombre ASC");
// search string
$search = isset($_GET['where']) ? strval($_GET['where']) : '';
// evaluate offset and row count for query
$page = http_request("page", "i", 1);
$rows = http_request("rows", "i", 50);
$limit = "";
if ($page != 0 && $rows != 0) {
$offset = ($page - 1) * $rows;
$limit = "" . $offset . "," . $rows;
}
$fedstr = "1";
if ($this->curFederation != null) {
$fed = intval($this->curFederation->get('ID'));
$intlmask = Federations::getInternationalMask();
// select non-international fedmask
$natmask = ~$intlmask;
$fedstr = $this->curFederation->isInternational() ? "((Internacional!=0) OR (Federations & {$intlmask})!=0)" : "((Federations & {$natmask})!=0)";
}
$where = "1";
if ($search !== '') {
$where = "( (Nombre LIKE '%{$search}%') OR ( Email LIKE '%{$search}%') ) ";
}
$result = $this->__select("*", "Jueces", "{$fedstr} AND {$where}", $sort, $limit);
$this->myLogger->leave();
return $result;
}
/**
* Lista pruebas ordenando por los parametros especificados y con criterios de busqueda
* @return null on error, else array in jquery expected format
*/
function select()
{
$this->myLogger->enter();
$sort = getOrderString(http_request("sort", "s", ""), http_request("order", "s", ""), "Nombre ASC");
$search = http_Request("where", "s", "");
$closed = http_request("closed", "i", 0);
// si esta declarada, se incluyen las pruebas cerradas
$page = http_request("page", "i", 1);
$rows = http_request("rows", "i", 50);
$limit = "";
$where = "";
if ($page != 0 && $rows != 0) {
$offset = ($page - 1) * $rows;
$limit = "" . $offset . "," . $rows;
}
if ($search !== "" && $closed == 0) {
$where = "( (Pruebas.Club=Clubes.ID) && ( Pruebas.Cerrada=0 ) && \t( (Pruebas.Nombre LIKE '%{$search}%') OR ( Clubes.Nombre LIKE '%{$search}%') OR ( Ubicacion LIKE '%{$search}%' ) ) ) ";
}
if ($search !== "" && $closed != 0) {
$where = "( (Pruebas.Club=Clubes.ID) && ( (Pruebas.Nombre LIKE '%{$search}%') OR ( Clubes.Nombre LIKE '%{$search}%') OR ( Ubicacion LIKE '%{$search}%' ) ) )";
}
if ($search === "" && $closed == 0) {
$where = "( (Pruebas.Club=Clubes.ID) && ( Pruebas.Cerrada=0 ) )";
}
if ($search === "" && $closed != 0) {
$where = "(Pruebas.Club=Clubes.ID)";
}
// execute query to retrieve $rows starting at $offset
$result = $this->__select("Pruebas.ID AS ID, Pruebas.Nombre AS Nombre, Pruebas.Club AS Club,Clubes.Nombre AS NombreClub,\n\t\t\t\t\t\t\tPruebas.Ubicacion AS Ubicacion,Pruebas.Triptico AS Triptico, Pruebas.Cartel AS Cartel,\n\t\t\t\t\t\t\tPruebas.RSCE AS RSCE, Pruebas.Selectiva AS Selectiva,\n\t\t\t\t\t\t\tPruebas.Cerrada AS Cerrada, Pruebas.Observaciones AS Observaciones", "Pruebas,Clubes", $where, $sort, $limit);
$this->myLogger->leave();
return $result;
}
function inscritosByTeam($team)
{
$this->myLogger->enter();
// obtenemos los datos del equipo
$teamobj = $this->__getObject("Equipos", $team);
if (!is_object($teamobj)) {
return $this->error("No puedo obtener datos del equipo con ID: {$team}");
}
// vemos el numero de la jornada asociada
$jornadaobj = $this->__getObject("Jornadas", $teamobj->Jornada);
if (!is_object($jornadaobj)) {
return $this->error("No puedo obtener datos de la jornada: {$teamobj->Jornada} asociada al equipo: {$team}");
}
$order = getOrderString(http_request("sort", "s", ""), http_request("order", "s", ""), "NombreClub ASC, Categoria ASC, Grado ASC, Nombre ASC");
// extraemos la lista de inscritos
$tname = escapeString($teamobj->Nombre);
$lista = $this->__select("DISTINCT Resultados.Prueba,Resultados.Jornada, Resultados.Dorsal, Resultados.Perro,\n Resultados.Nombre, PerroGuiaClub.NombreLargo, PerroGuiaClub.Genero, Resultados.Raza, Resultados.Licencia, Resultados.Categoria, Resultados.Grado,\n Resultados.Celo,Resultados.NombreGuia,Resultados.NombreClub, Resultados.Equipo,\n PerroGuiaClub.Club AS Club, PerroGuiaClub.Guia AS Guia,PerroGuiaClub.LogoClub AS LogoClub,\n '{$tname}' AS NombreEquipo", "Resultados,PerroGuiaClub", "( PerroGuiaClub.ID = Resultados.Perro)\tAND ( Resultados.Jornada={$teamobj->Jornada} ) AND ( Resultados.Equipo={$team} )", $order, "");
$this->myLogger->leave();
return $lista;
}
function select()
{
$this->myLogger->enter();
$sort = getOrderString(http_request("sort", "s", ""), http_request("order", "s", ""), "Nombre ASC");
$search = http_Request("where", "s", "");
$page = http_request("page", "i", 1);
$rows = http_request("rows", "i", 50);
$limit = "";
if ($page != 0 && $rows != 0) {
$offset = ($page - 1) * $rows;
$limit = "" . $offset . "," . $rows;
}
$federation = http_request("Federation", "i", -1);
$fed = "1";
if ($federation >= 0) {
$fed = "( Federation = {$federation} )";
}
$where = "(Guias.Club=Clubes.ID)";
if ($search !== '') {
$where = "(Guias.Club=Clubes.ID) AND ( (Guias.Nombre LIKE '%{$search}%') OR ( Clubes.Nombre LIKE '%{$search}%') ) ";
}
$result = $this->__select("Guias.ID, Guias.Federation, Guias.Nombre, Telefono, Guias.Email, Club, Clubes.Nombre AS NombreClub, Guias.Observaciones", "Guias,Clubes", "{$fed} AND {$where}", $sort, $limit);
$this->myLogger->leave();
return $result;
}
/**
* retrieve all clubes from table, according sort, search and limit requested
* Also use current federation flag to filter national/international clubes
*/
function select()
{
$this->myLogger->enter();
// evaluate offset and row count for query
$sort = getOrderString(http_request("sort", "s", ""), http_request("order", "s", ""), "Nombre ASC");
$search = http_Request("where", "s", "");
$page = http_request("page", "i", 1);
$rows = http_request("rows", "i", 50);
// evaluate federation for club/country search according intl status
$fedstr = "1";
if ($this->curFederation != null) {
$fed = intval($this->curFederation->get('ID'));
$intlmask = Federations::getInternationalMask();
// select non-international fedmask
$natmask = ~$intlmask;
$fedstr = $this->curFederation->isInternational() ? "((Federations & {$intlmask})!=0)" : "((Federations & {$natmask})!=0)";
}
$limit = "";
if ($page != 0 && $rows != 0) {
$offset = ($page - 1) * $rows;
$limit = "" . $offset . "," . $rows;
}
$where = "1";
if ($search !== '') {
$where = "( (Nombre LIKE '%{$search}%') OR (Provincia LIKE '%{$search}%') OR (Pais LIKE '%{$search}%') ) ";
}
$result = $this->__select("*, Logo AS LogoClub", "Clubes", "{$fedstr} AND {$where}", $sort, $limit);
$this->myLogger->leave();
return $result;
}
