/** * 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; }