public function index($offset = 0)
{
$tax_list = new Tax_Employee();
switch ($this->input->get('c')) {
case "1":
$data['col'] = "sp_status";
break;
case "2":
$data['col'] = "sp_ptkp";
break;
case "3":
$data['col'] = "sp_id";
break;
default:
$data['col'] = "sp_id";
}
if ($this->input->get('d') == "1") {
$data['dir'] = "DESC";
} else {
$data['dir'] = "ASC";
}
$data['title'] = "Taxes Employees";
$data['btn_add'] = anchor('taxes_employees/add', 'Add New', array("class" => "btn btn-primary"));
$data['btn_home'] = anchor(base_url(), 'Home');
$uri_segment = 3;
$offset = $this->uri->segment($uri_segment);
if ($this->input->get('search_by')) {
$total_rows = $tax_list->like($_GET['search_by'], $_GET['q'])->count();
$tax_list->like($_GET['search_by'], $_GET['q'])->order_by($data['col'], $data['dir']);
} else {
$total_rows = $tax_list->count();
$tax_list->order_by($data['col'], $data['dir']);
}
$data['tax_list'] = $tax_list->get($this->limit, $offset)->all;
$config['base_url'] = site_url("taxes_employees/index");
$config['total_rows'] = $total_rows;
$config['per_page'] = $this->limit;
$config['uri_segment'] = $uri_segment;
$this->pagination->initialize($config);
$data['pagination'] = $this->pagination->create_links();
$this->load->view('taxes_employees/index', $data);
}
