public function index($offset = 0)
{
$this->breadcrumb->append_crumb('Home', base_url());
$this->breadcrumb->append_crumb('Staff Detail', base_url() . 'index.php/staffs/show/' . $this->staff_id);
$this->breadcrumb->append_crumb('Families', base_url() . '');
$family = new Family();
switch ($this->input->get('c')) {
case "1":
$data['col'] = "staff_fam_order";
break;
case "2":
$data['col'] = "staff_fam_name";
break;
case "3":
$data['col'] = "staff_fam_birthdate";
break;
case "4":
$data['col'] = "staff_fam_birthplace";
break;
case "5":
$data['col'] = "staff_fam_sex";
break;
case "6":
$data['col'] = "staff_fam_relation";
break;
case "7":
$data['col'] = "staff_fam_id";
break;
default:
$data['col'] = "staff_fam_id";
}
if ($this->input->get('d') == "1") {
$data['dir'] = "DESC";
} else {
$data['dir'] = "ASC";
}
$data['staff_id'] = $this->staff_id;
$family->where('staff_fam_staff_id', $this->staff_id)->order_by($data['col'], $data['dir']);
$total_rows = $family->count();
$data['title'] = "Family";
$data['btn_add'] = anchor('staffs/' . $this->staff_id . '/families/add', 'Add New', array('class' => 'btn btn-primary'));
$data['btn_home'] = anchor('staffs', 'Home');
$offset = $this->uri->segment($this->uri_segment);
$data['families'] = $family->where('staff_fam_staff_id', $this->staff_id)->order_by($data['col'], $data['dir'])->get($this->limit, $offset)->all;
$config['base_url'] = site_url('staffs/' . $this->staff_id . '/families/index');
$config['total_rows'] = $total_rows;
$config['per_page'] = $this->limit;
$config['uri_segment'] = $this->uri_segment;
$this->pagination->initialize($config);
$data['pagination'] = $this->pagination->create_links();
$data['breadcrumb'] = $this->breadcrumb->output();
$this->load->view('staff_family/index', $data);
}
/**
* 首页
*
*/
public function actionIndex()
{
parent::_acl();
$model = new Family();
$criteria = new CDbCriteria();
$criteria->condition = $condition;
$criteria->order = 't.id DESC';
//$criteria->with = array ( 'catalog' );
$count = $model->count($criteria);
$pages = new CPagination($count);
$pages->pageSize = 13;
//$pageParams = XUtils::buildCondition( $_GET, array ( 'title' , 'catalogId','titleAlias' ) );
//$pages->params = is_array( $pageParams ) ? $pageParams : array ();
$criteria->limit = $pages->pageSize;
$criteria->offset = $pages->currentPage * $pages->pageSize;
$result = $model->findAll($criteria);
$this->render('family_index', array('datalist' => $result, 'pagebar' => $pages));
}
