/** * 首页 * */ 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>'; }