gistfile1.php

<?php

		// Pagination
		$pagination = new Pagination(array(
				'query_string' => 'page',
				'items_per_page' => (int) Kohana::config('settings.items_per_page'),
				'total_items' => ORM::factory("incident")
					->where("incident_active", 1)
					->where($location_id_in)
					->where($incident_id_in)
					->count_all()
				));

		// Reports
		$incidents = ORM::factory("incident")
			->where("incident_active", 1)
			->where($location_id_in)
			->where($incident_id_in)
			->orderby("incident_date", "desc")
			->find_all((int) Kohana::config('settings.items_per_page_admin'), $pagination->sql_offset);