[eluser]maria clara[/eluser]
hi to all,
i have a jqgrid with a detail list but the content don't show the item from a joined table. its not retrieving the $item for the details...here's my code:
Code:
function getDetailList() //Show the list of registered user with company details
{
$item = $this->input->post('item');
$page = $this->input->post('page');
$limit = $this->input->post('rows'); // get how many rows we want to have into the grid
$sidx = $this->input->post('sidx'); // get index row - i.e. user click to sort
$sord = $this->input->post('sord'); // get the direction
$query = $this->input->post('query');
$qtype = $this->input->post('qtype');
if (!$sidx) $sidx = 'sec_companyaccess.user_id'; // if we not pass at first time index use the first column for the index
if (!$sord) $sord = 'asc';
if (!$page) $page = 1;
if (!$limit) $limit = 25;
$start = (($page-1) * $limit);
$this->db->start_cache();
$this->db->join('maint_company','sec_companyaccess.company_id=maint_company.company_id','left');
$this->db->join('sec_users ','sec_companyaccess.user_id=sec_users.user_id','left');
$item = $this->input->post('sec_users.user.id');
$this->db->from('sec_companyaccess');
#$this->db->where("sec_companyaccess.user_id", $item);
$this->db->where("sec_companyaccess.user_id", $item);
$count = $this->db->count_all_results();
if( $count > 0 && $limit > 0) {
$total_pages = ceil($count/$limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) $page=$total_pages;
$start = $limit * $page - $limit;
if($start <0) $start = 0;
$this->db->select("sec_companyaccess.company_access_id as pkey,sec_companyaccess.company_access_id, maint_company.company_code, maint_company.company_name,sec_companyaccess.company_id ");
$this->db->order_by($sidx,$sord);
$this->db->limit($limit, $start);
$query = $this->db->get("sec_companyaccess");
$this->db->flush_cache();
$data['db'] = $query;
$data['page'] = $page;
$data['totalpages'] = $total_pages;
$data['totalrecords']=$count;
return $data;
}
this script wasn't working
$item = $this->input->post('item');
anyone could help??
thanks,