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>';
}
