Login

01-25-2010, 09:41 PM

[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,