/**
* 首页
*
*/
public function actionIndex()
{
parent::_acl('city_index');
$model = new City();
$criteria = new CDbCriteria();
$criteria->order = 'id ASC';
$count = $model->count($criteria);
$pages = new CPagination($count);
$pages->pageSize = 10;
$criteria->limit = $pages->pageSize;
$criteria->offset = $pages->currentPage * $pages->pageSize;
$result = $model->findAll($criteria);
$this->render('index', array('datalist' => $result, 'pagebar' => $pages));
}
public function insertCity()
{
$cre = ["city" => Input::get('city')];
$rules = ["city" => 'required'];
$validator = Validator::make($cre, $rules);
if ($validator->passes()) {
$city = new City();
$city->city_name = Input::get('city');
$city->save();
$count = City::count();
$data['success'] = 'true';
$data['message'] = html_entity_decode(View::make('admin.manage.cities.view', ["data" => $city, "count" => $count]));
} else {
$data["success"] = false;
$data["message"] = "All fields are not filled";
}
return json_encode($data);
}
public function filters($offset = 0)
{
$string = '%' . $this->input->post('ciudad') . '%';
$c = $this->input->post('country_id');
$prov = $this->input->post('state_id');
$condiciones = '';
$valores = array();
if ($string != '%%') {
$condiciones .= " nombre LIKE ?";
$valores['ciudad'] = $string;
}
if ($prov > 0) {
if ($condiciones != '') {
$condiciones .= " AND ";
}
$condiciones .= " state_id = ?";
$valores['prov'] = $prov;
}
if ($c > 0) {
if ($condiciones != '') {
$condiciones .= " AND ";
}
$condiciones .= " country_id = ?";
$valores['pais'] = $c;
}
$this->session->set_userdata('filtros_ciudades', $valores);
$conditions = array_merge(array($condiciones), $valores);
$config['base_url'] = site_url('ciudades/index');
$config['total_rows'] = City::count(array('joins' => array('state'), 'conditions' => $conditions));
$config['per_page'] = '10';
$config['num_links'] = '10';
$config['first_link'] = '← primero';
$config['last_link'] = 'último →';
$this->load->library('pagination', $config);
$ciudades = City::all(array('joins' => array('state'), 'conditions' => $conditions, 'limit' => $config['per_page'], 'offset' => $offset));
$this->table->set_heading('Orden', 'País', 'Provincia', 'Ciudad', 'Acciones');
foreach ($ciudades as $ciudad) {
$this->table->add_row($ciudad->id, $ciudad->state->country->pais, $ciudad->state->provincia, $ciudad->nombre, anchor('ciudades/editar/' . $ciudad->id, img('static/img/icon/pencil.png'), 'class="tipwe" title="Editar"') . ' ' . anchor('ciudades/eliminar/' . $ciudad->id, img('static/img/icon/trash.png'), 'class="tipwe eliminar" title="Eliminar"'));
}
echo $this->table->generate();
echo '<div class="pagination">';
echo $this->pagination->create_links();
echo '</div>';
}
