/**
* Districts
*
* @param string $search search query
* @param boolean $pagination limit query by page
* @param string $where additional conditions
* @return object $results array of districts objects, $pagination pagination object, $query executed query
*/
function api_world_districts($search = NULL, $pagination = FALSE, $where = NULL)
{
// definitions
$return = new stdClass();
$return->results = array();
// build query
$query_table = "world_districts";
// fields
$query_fields = "world_districts.*";
// where
$query_where = "1";
// search
if (strlen($search) > 0) {
$query_where .= " AND ( world_districts.name LIKE '%" . $search . "%' )";
}
// conditions
if (strlen($where) > 0) {
$query_where = "( " . $query_where . " ) AND ( " . $where . " )";
}
// order
$query_order = api_queryOrder("name ASC");
// pagination
if ($pagination) {
$return->pagination = new str_pagination($query_table, $query_where, $GLOBALS['navigation']->filtersGet());
// limit
$query_limit = $return->pagination->queryLimit();
}
// build query
$return->query = "SELECT " . $query_fields . " FROM " . $query_table . " WHERE " . $query_where . $query_order . $query_limit;
// execute query
$results = $GLOBALS['db']->query($return->query);
while ($result = $GLOBALS['db']->fetchNextObject($results)) {
$return->results[$result->id] = api_world_district($result);
}
// return districts objects
return $return;
}
/**
* Trainings
*
* @param string $search search query
* @param boolean $pagination limit query by page
* @param string $where additional conditions
* @return object $results array of address objects, $pagination pagination object, $query executed query
*/
function api_moduleDiary_trainings($search = NULL, $pagination = FALSE, $where = NULL)
{
// definitions
$return = new stdClass();
$return->results = array();
// generate query
$query_table = "`module-diary_trainings`";
// fields
$query_fields = "*";
// where
$query_where = $GLOBALS['navigation']->filtersQuery(1);
// search
if (strlen($search) > 0) {
$query_where .= " AND ";
$query_where .= "( `sport` LIKE '%" . $search . "%'";
$query_where .= " OR `sort` LIKE '%" . $search . "%' )";
}
// conditions
if (strlen($where) > 0) {
$query_where = "( " . $query_where . " ) AND ( " . $where . " )";
}
// order
$query_order = api_queryOrder("`datetraining` DESC");
// pagination
if ($pagination) {
$return->pagination = new str_pagination($query_table, $query_where, $GLOBALS['navigation']->filtersGet());
// limit
$query_limit = $return->pagination->queryLimit();
}
// build query
$return->query = "SELECT " . $query_fields . " FROM " . $query_table . " WHERE " . $query_where . $query_order . $query_limit;
// execute query
$results = $GLOBALS['db']->query($return->query);
while ($result = $GLOBALS['db']->fetchNextObject($results)) {
$return->results[$result->id] = api_moduleDiary_training($result);
}
// return objects
return $return;
}
