public function filters($offset = 0) { $string = '%' . $this->input->post('concepto') . '%'; $ciclo = '%' . $this->input->post('ciclo') . '%'; $condiciones = ''; $valores = array(); if ($string != '%%') { $condiciones .= " concepto LIKE ?"; $valores['concepto'] = $string; } if ($ciclo != '%%') { $condiciones .= " ciclo_lectivo LIKE ?"; $valores['ciclo_lectivo'] = $ciclo; } $conditions = array_merge(array($condiciones), $valores); $config['base_url'] = site_url('conceptos/index'); $config['total_rows'] = Concept::count(array('conditions' => $conditions)); $config['per_page'] = '10'; $config['num_links'] = '10'; $config['first_link'] = '← primero'; $config['last_link'] = 'último →'; $this->load->library('pagination', $config); $conceptos = Concept::all(array('conditions' => $conditions, 'limit' => $config['per_page'], 'offset' => $offset)); $this->table->set_heading('Orden', 'Concepto', 'Pagos Parciales', 'Ciclo Lectivo', 'Acciones'); foreach ($conceptos as $concepto) { $this->table->add_row($concepto->id, $concepto->concepto, $concepto->pago_parcial ? 'Si' : 'No', $concepto->ciclo_lectivo, anchor('conceptos/ver/' . $concepto->id, img('static/img/icon/doc_lines.png'), 'class="tipwe" title="Ver detalles"') . ' ' . anchor('conceptos/editar/' . $concepto->id, img('static/img/icon/pencil.png'), 'class="tipwe" title="Editar"') . ' ' . anchor('conceptos/eliminar/' . $concepto->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>'; }