/**
* @return Model_Kwalbum_Item
*/
public function getNextItem()
{
$where_query = Model_Kwalbum_Item::get_where_query();
if (!$where_query) {
$where_query = ' WHERE ';
} else {
$where_query .= ' AND ';
}
$sort_field = Model_Kwalbum_Item::$_sort_field;
$sort_direction = Model_Kwalbum_Item::$_sort_direction;
$gtlt = Model_Kwalbum_Item::$_gtlt == '<' ? '>' : '<';
$query = "SELECT id\n\t\t\tFROM kwalbum_items {$where_query}\n\t\t\t({$sort_field} {$gtlt} :sort_value\n\t\t\t\tOR ({$sort_field} = :sort_value AND id {$gtlt} :id))\n\t\t\tORDER BY {$sort_field} {$sort_direction}, id {$sort_direction}\n\t\t\tLIMIT 1";
$result = DB::query(Database::SELECT, $query)->param(':sort_value', $this->getSortValue())->param(':id', $this->id)->execute();
return Model::factory('kwalbum_item')->load((int) $result[0]['id']);
}
public function action_GetMapItems()
{
$zoom = (int) $_GET["z"];
if ($zoom == 17) {
$limit = 20;
} else {
$limit = 10;
}
$where = Model_Kwalbum_Item::get_where_query();
if (!$where) {
$where = ' WHERE 1=1 ';
}
$data = array();
Model_Kwalbum_Item::getMarkers((double) $_GET["l"], (double) $_GET["r"], (double) $_GET["t"], (double) $_GET["b"], $where, $data, $limit, 1);
echo "point\ttype\ttitle\tdescription";
foreach ($data as $d) {
echo "\n{$d['lon']},{$d['lat']}\t";
if ($d['group']) {
echo "g\t{$d['count']}\t{$zoom}";
} else {
echo "i\t{$d['id']}\t{$d['date']}";
}
}
}
