Projekt

Obecné

Profil

Stáhnout (2.81 KB) Statistiky
| Větev: | Tag: | Revize:
8baed187 Michal Kliment
<?php defined('SYSPATH') or die('No direct script access.');
/*
* This file is part of open source system FreenetIS
* and it is release under GPLv3 licence.
*
* More info about licence can be found:
* http://www.gnu.org/licenses/gpl-3.0.html
*
* More info about project can be found:
* http://www.freenetis.org/
*
*/

/**
* Town is part of address point, each contains many streets.
*
* @package Model
*
* @property string $town
* @property string $quarter
* @property integer $zip_code
* @property blob $gps
* @property ORM_Iterator $address_points
* @property ORM_Iterator $streets
*/
class Town_Model extends ORM
{
protected $has_many = array('address_points', 'streets');
/**
* @author Ondrej Fibich
* @return string reprezentation of town
*/
public function __toString()
{
if (!$this->id)
return '';
return (
$this->town . ($this->quarter ? ' - ' . $this->quarter : '') .
', ' . $this->zip_code
);
}

/**
* Check if town exists
* Exists - return it
* Not exists - create it a return it
*
* @author Michal Kliment
* @param string $zip_code zip code
* @param string $town town
* @param string $quarter quarter
* @return Town_Model
*/
public function get_town($zip_code = NULL, $town = NULL, $quarter = NULL)
{
$towns = $this->where(array
(
'zip_code' => $zip_code,
'town' => $town,
'quarter' => $quarter
))->find_all();

if (count($towns) == 0)
{
$this->clear();
$this->zip_code = $zip_code;
$this->town = $town;
$this->quarter = $quarter;
$this->save();
return $this;
}
else if (count($towns) == 1)
{
return $towns->current();
}
else
{
return NULL;
}
}

/**
*
* @param integer $limit_from
* @param integer $limit_results
* @param string $order_by
* @param string $order_by_direction
* @param array $filter_values
* @return Mysql_Result
*/
public function get_all_towns(
$limit_from = 0, $limit_results = 50,
$order_by = 'id', $order_by_direction = 'asc',
$filter_values = array())
{
// order by check
if (!$this->has_column($order_by))
{
$order_by = 'id';
}
// order by direction check
$order_by_direction = strtolower($order_by_direction);
if ($order_by_direction != 'desc')
{
$order_by_direction = 'asc';
}
// query
return $this->db->query("
SELECT t.id, t.town, t.quarter, t.zip_code
FROM towns t
ORDER BY $order_by $order_by_direction
LIMIT ".intval($limit_from).", ".intval($limit_results)."
");
}
/**
* Gets list of towns for select box
*
* @return array[string]
*/
public function select_list_with_quater()
{
$concat = "CONCAT(
COALESCE(town, ''),
COALESCE(IF(
quarter IS NULL OR quarter LIKE '',
NULL, CONCAT(' - ', quarter)
), ''), ', ', zip_code
)";
return $this->select_list('id', $concat);
}
}