Welcome Guest, Not a member yet? Register   Sign In
[SOLVED!] unable to retrieve detail list
#16

[eluser]maria clara[/eluser]
here's my controller:

Code:
function post()
    {
        $c = "";    
        $data['action'] = $this->input->post('action');    
        //$item = $this->input->post('item');        
        if ($data['action']=='view')
        {

            $dt['user_id'] = $this->input->post("item");
            $details = $this->User->getDetails($dt);

            if ($details)
            {
                $data['db'] = array('item'=>$dt['user_id'],
                                    'username'=>$details['username'],    
                                    'last_name'=>$details['last_name'],                                    
                                    'first_name'=>$details['first_name'],
                                    'middle_initial'=>$details['middle_initial'],
                                    'role_id'=>$details['role_id'],                                    
                                    'role_code'=>$details['role_code'],
                                    'role_desc'=>$details['role_desc'],                                        
                                    'dept_id'=>$details['dept_id'],                                    
                                    'dept_code'=>$details['dept_code'],
                                    'dept_desc'=>$details['dept_desc']
                            
                                
                                    );
                $data['count'] = $this->User->countDetailList($dt);                                    
                //$data['count'] = 0;
            }
    
            $data['response'] = $c;
            $json['json'] = $data;            
            $this->load->vars($data);
            $this->load->view('template/ajax',$json);    
        }

here's my model:

Code:
function getDetailList() //Show the list of registered user with company details
    {
        $item = $this->input->post("item");
        //print_r($_POST);

        $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 = 'desc';
                
        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", 1);
        $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; // do not put $limit*($page - 1)
        
        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;    
    
    }

hope anyone can help me..;(


Messages In This Thread
[SOLVED!] unable to retrieve detail list - by El Forum - 01-25-2010, 09:41 PM
[SOLVED!] unable to retrieve detail list - by El Forum - 01-26-2010, 04:52 PM
[SOLVED!] unable to retrieve detail list - by El Forum - 01-26-2010, 07:31 PM
[SOLVED!] unable to retrieve detail list - by El Forum - 01-26-2010, 07:37 PM
[SOLVED!] unable to retrieve detail list - by El Forum - 01-26-2010, 07:45 PM
[SOLVED!] unable to retrieve detail list - by El Forum - 01-26-2010, 07:49 PM
[SOLVED!] unable to retrieve detail list - by El Forum - 01-26-2010, 07:53 PM
[SOLVED!] unable to retrieve detail list - by El Forum - 01-26-2010, 07:55 PM
[SOLVED!] unable to retrieve detail list - by El Forum - 01-26-2010, 07:59 PM
[SOLVED!] unable to retrieve detail list - by El Forum - 01-26-2010, 08:19 PM
[SOLVED!] unable to retrieve detail list - by El Forum - 01-26-2010, 08:21 PM
[SOLVED!] unable to retrieve detail list - by El Forum - 01-26-2010, 08:26 PM
[SOLVED!] unable to retrieve detail list - by El Forum - 01-26-2010, 08:28 PM
[SOLVED!] unable to retrieve detail list - by El Forum - 01-26-2010, 08:35 PM
[SOLVED!] unable to retrieve detail list - by El Forum - 01-26-2010, 11:20 PM
[SOLVED!] unable to retrieve detail list - by El Forum - 01-27-2010, 08:02 PM
[SOLVED!] unable to retrieve detail list - by El Forum - 02-01-2010, 07:33 PM
[SOLVED!] unable to retrieve detail list - by El Forum - 02-01-2010, 09:56 PM



Theme © iAndrew 2016 - Forum software by © MyBB