Projekt

Obecné

Profil

Stáhnout (10.6 KB) Statistiky
| Větev: | Tag: | Revize:

freenetis-github/application/controllers/towns.php @ 8e0933e3

8baed187 Michal Kliment
<?php defined('SYSPATH') or die('No direct script access.');
/*
* This file is part of open source system FreenetIS
* and it is released 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/
*
*/

/**
* Controller performs actions over towns.
*
* @package Controller
*/
class Towns_Controller extends Controller
{

/**
* Town ID for callback function
*
* @var integer
*/
private $town_id = 0;

/**
* Index redirects to show all
*/
public function index()
{
url::redirect('towns/show_all');
}

/**
* Function shows list of all towns.
*
* @author Michal Kliment
* @param integer $limit_results
* @param string $order_by
* @param string $order_by_direction
* @param integer $page_word
* @param integer $page
*/
public function show_all(
$limit_results = 50, $order_by = 'id', $order_by_direction = 'ASC',
$page_word = null, $page = 1)
{
// access control
if (!$this->acl_check_view('Address_points_Controller', 'town'))
Controller::error(ACCESS);

// gets new selector
c1bdc1c4 Michal Kliment
if (is_numeric($this->input->post('record_per_page')))
$limit_results = (int) $this->input->post('record_per_page');
8baed187 Michal Kliment
// parameters control
$allowed_order_type = array('id', 'town', 'quarter', 'zip_code');
if (!in_array(strtolower($order_by), $allowed_order_type))
$order_by = 'id';
if (strtolower($order_by_direction) != 'desc')
$order_by_direction = 'asc';

$town_model = new Town_Model();
$total_towns = $town_model->count_all();
if (($sql_offset = ($page - 1) * $limit_results) > $total_towns)
$sql_offset = 0;

$query = $town_model->get_all_towns(
$sql_offset, (int) $limit_results, $order_by, $order_by_direction
);

// it creates grid to view all address points
$grid = new Grid('address_points', '', array
(
'current' => $limit_results,
'selector_increace' => 50,
'selector_min' => 50,
'selector_max_multiplier' => 10,
'base_url' => Config::get('lang') . '/towns/show_all/'
. $limit_results . '/' . $order_by . '/' . $order_by_direction,
'uri_segment' => 'page',
'total_items' => $total_towns,
'items_per_page' => $limit_results,
'style' => 'classic',
'order_by' => $order_by,
'order_by_direction' => $order_by_direction,
'limit_results' => $limit_results,
));

if ($this->acl_check_new('Address_points_Controller', 'town'))
{
$grid->add_new_button('towns/add', __('Add new town'));
}

$grid->order_field('id')
->label('ID');
$grid->order_field('town')
->label(__('Town'));
$grid->order_field('quarter')
->label(__('Quarter'));
$grid->order_field('zip_code')
->label(__('zip code'));
$actions = $grid->grouped_action_field();

if ($this->acl_check_view('Address_points_Controller', 'town'))
{
$actions->add_action()
->icon_action('show')
->url('towns/show');
}
if ($this->acl_check_edit('Address_points_Controller', 'town'))
{
$actions->add_action()
->icon_action('edit')
->url('towns/edit');
}
if ($this->acl_check_delete('Address_points_Controller', 'town'))
{
$actions->add_action()
->icon_action('delete')
->url('towns/delete')
->class('delete_link');
}

$grid->datasource($query);

$links = array();
$links[] = html::anchor('address_points', __('Address points'));
$links[] = __('Towns');
$links[] = html::anchor('streets', __('Streets'));

$view = new View('main');
$view->breadcrumbs = __('Towns');
$view->title = __('List of all towns');
$view->content = new View('show_all');
$view->content->submenu = implode(' | ', $links);
$view->content->headline = __('List of all towns');
$view->content->table = $grid;
$view->render(TRUE);
}

/**
* Function shows town.
*
* @author Michal Kliment
* @param integer $town_id id of town to show
*/
public function show($town_id = NULL)
{
// no parameter
if (!$town_id)
Controller::warning(PARAMETER);

$town = new Town_Model($town_id);

// record doesn't exist
if (!$town->id)
Controller::error(RECORD);

// access control
if (!$this->acl_check_view('Address_points_Controller', 'town'))
Controller::error(ACCESS);
$grid_streets = new Grid('towns/show/' . $town_id, null, array
(
'separator' => '<br /><br />',
'use_paginator' => false,
'use_selector' => false,
));
$grid_streets->field('id');
$grid_streets->field('street');
$actions = $grid_streets->grouped_action_field();
$actions->add_action()
->icon_action('show')
->url('streets/show');
$actions->add_action()
->icon_action('edit')
->url('streets/edit');
$actions->add_action()
->icon_action('delete')
->url('streets/delete')
->class('delete_link');
$grid_streets->datasource($town->streets);

// breadcrumbs navigation
$breadcrumbs = breadcrumbs::add()
->link('towns/show_all', 'Towns',
$this->acl_check_view('Address_points_Controller', 'town'))
->disable_translation()
->text($town->__toString());

$view = new View('main');
$view->breadcrumbs = $breadcrumbs->html();
$view->title = __('Town detail');
$view->content = new View('towns/show');
$view->content->town = $town;
$view->content->grid_streets = $grid_streets;
$view->content->count_address_points = $town->address_points->count();
$view->render(TRUE);
}

/**
* Function adds new town.
*
* @author Michal Kliment
*/
public function add()
{
// access control
if (!$this->acl_check_new('Address_points_Controller', 'town'))
Controller::error(ACCESS);

// creates new form
$form = new Forge();

$form->input('town')
->label(__('Town') . ':')
->rules('required|length[1,50]')
->callback(array($this, 'check_town'));
$form->input('quarter')
->label(__('Quarter') . ':')
->rules('length[1,50]');
$form->input('zip_code')
->label(__('Zip code') . ':')
->rules('required|length[5,5]|valid_numeric');

$form->submit('Add');

// form is validate
if ($form->validate())
{
$form_data = $form->as_array();

$town = new Town_Model();
$town->town = $form_data["town"];
$town->quarter = $form_data["quarter"];
$town->zip_code = $form_data["zip_code"];

// success
if ($town->save())
{
status::success('Town has been successfully added.');
}
else
{
$town = NULL;
}
$this->redirect('show_all', $town->id);
}
else
{
// breadcrumbs navigation
$breadcrumbs = breadcrumbs::add()
->link('towns/show_all', 'Towns',
$this->acl_check_view('Address_points_Controller', 'town'))
->text('Add new town');


$view = new View('main');
$view->breadcrumbs = $breadcrumbs->html();
$view->title = __('Add new town');
$view->town = isset($town) && $town->id ? $town : NULL;
$view->content = new View('form');
$view->content->headline = __('Add new town');
$view->content->form = $form->html();
$view->render(TRUE);
}
}

/**
* Function edits town.
*
* @author Michal Kliment
* @param integer $town_id id of town to edit
*/
public function edit($town_id = NULL)
{
// no parameter
if (!$town_id)
Controller::warning(PARAMETER);

$town = new Town_Model($town_id);

// record doesn't exist
if (!$town->id)
Controller::error(RECORD);

// access control
if (!$this->acl_check_edit('Address_points_Controller', 'town'))
Controller::error(ACCESS);

// saving for callback function
$this->town_id = $town_id;

// creates new form
$form = new Forge('towns/edit/' . $town_id);

$form->input('town')
->label(__('Town') . ':')
->rules('required|length[1,50]')
->value($town->town)
->callback(array($this, 'check_town'));
$form->input('quarter')
->label(__('Quarter') . ':')
->rules('length[1,50]')
->value($town->quarter);
$form->input('zip_code')
->label(__('Zip code') . ':')
->rules('required|length[5,5]|valid_numeric')
->value($town->zip_code);

$form->submit('Edit');

// form is validate
if ($form->validate())
{
$form_data = $form->as_array();

$town = new Town_Model($town_id);
$town->town = $form_data["town"];
$town->quarter = $form_data["quarter"];
$town->zip_code = $form_data["zip_code"];

// success
if ($town->save())
{
status::success('Town has been successfully updated.');
}
url::redirect('towns/show_all');
}

$name = $town->town;
$name .= ( $town->quarter != '') ? ' - ' . $town->quarter : '';
$name .= ', ' . $town->zip_code;
// breadcrumbs navigation
$breadcrumbs = breadcrumbs::add()
->link('towns/show_all', 'Towns',
$this->acl_check_view('Address_points_Controller', 'town'))
->disable_translation()
->link('towns/show/' . $town->id, $name,
$this->acl_check_view('Address_points_Controller', 'town'))
->enable_translation()
->text('Edit');

$view = new View('main');
$view->breadcrumbs = $breadcrumbs->html();
$view->title = __('Edit town');
$view->content = new View('form');
$view->content->headline = __('Editing of town');
$view->content->form = $form->html();
$view->render(TRUE);
}

/**
* Function deletes town.
*
* @author Michal Kliment
* @param integer $town_id id of town to delete
*/
public function delete($town_id = NULL)
{
// no parameter
if (!$town_id)
Controller::warning(PARAMETER);

$town = new Town_Model($town_id);

// record doesn't exist
if (!$town->id)
Controller::error(RECORD);

// access control
if (!$this->acl_check_delete('Address_points_Controller', 'town'))
Controller::error(ACCESS);

$address_points = $town->address_points;

if (count($address_points) == 0)
{
if ($town->delete())
{
status::success('Town has been successfully deleted.');
}
else
{
status::error('Error - cant delete town.');
}
}
else
{
status::warning('At least one address point uses this town.');
}

url::redirect('towns/show_all');
}

/**
* Function checks if town already exist.
*
* @author Michal Kliment
* @param object $input
*/
public function check_town($input = NULL)
{
// validators cannot be accessed
if (empty($input) || !is_object($input))
{
self::error(PAGE);
}
$town = $this->input->post('town');
if (($quarter = $this->input->post('quarter')) == '')
$quarter = NULL;
$zip_code = $this->input->post('zip_code');

$town_model = new Town_Model();
$towns_count = $town_model->where(array
(
'town' => $town,
'quarter' => $quarter,
'zip_code' => $zip_code,
'id <>' => $this->town_id
))->count_all();

if ($towns_count)
{
$input->add_error('required', __('Town already exists.'));
}
}

}