SOLVED:[help]Jqgrid master detail list in another page!

#7
[eluser]cestaz18[/eluser]
MODEL (users_db.php)

Code:
function getDetailList($ids) //Show the list of registered user with company details
    {
          
        //$id = $this->input->post('rowid');
        
        //$item = $this->input->post('item');
        //print_r($_POST);
        $id = $this->input->post('ids');
        
        $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
        //$id =$this->input->post('id');

    /*    if (!$sortname) $sortname = 'sec_companyaccess.user_id';
        if (!$sortorder) $sortorder = 'DESC';*/
        
        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';    
        
        
        //$page = 1;
        
        if (!$page) $page = 1;
        if (!$limit) $limit = 25;
        
        $start = (($page-1) * $limit);
        
        $this->db->start_cache();
        
/*        if(isset ($_REQUEST["sec_companyaccess.user_id"]))
            $rowid = $_REQUEST["sec_companyaccess.user_id"];
        else
            $rowid = "";*/




        $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", 1);
        //$this->db->where("sec_companyaccess.user_id", $item);
        $this->db->where("sec_companyaccess.user_id", $ids);
        $count = $this->db->count_all_results(); //code added by cess
    
        
        // calculate the total pages for the query - code added by cess
        if( $count > 0 && $limit > 0) {
              $total_pages = ceil($count/$limit);
        } else {
              $total_pages = 0;
        }
        
        // if for some reasons the requested page is greater than the total
        // set the requested page to total page - code added by cess
        if ($page > $total_pages) $page=$total_pages;
        
        // calculate the starting position of the rows
        $start = $limit * $page - $limit; // do not put $limit*($page - 1)
        
        // if for some reasons start position is negative set it to 0
        // typical case is that the user type 0 for the requested page
        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($rp, $start);
        $query = $this->db->get("sec_companyaccess");
/*        $sql = ("SELECT erp_sec_companyaccess.company_access_id as pkey,erp_sec_companyaccess.company_access_id, erp_maint_company.company_code, erp_maint_company.company_name,erp_sec_companyaccess.company_id                
        FROM erp_sec_companyaccess
        INNER JOIN erp_sec_users
        ON erp_sec_companyaccess.user_id= erp_sec_users.user_id
        LEFT JOIN erp_maint_company
        ON erp_sec_companyaccess.company_id=erp_maint_company.company_id
        WHERE erp_sec_companyaccess.user_id= erp_sec_users.user_id");
        $query = $this->db->query($sql);
        $num = $this->db->count_all_results();*/
        $this->db->flush_cache();
        
        $data['db'] = $query;        
        $data['page'] = $page;
        $data['totalpages'] = $total_pages;//code added by cess^^
        $data['totalrecords']=$count; //- code added by cess
        return $data;            


    }


Messages In This Thread
SOLVED:[help]Jqgrid master detail list in another page! - by El Forum - 01-28-2010, 01:59 AM
SOLVED:[help]Jqgrid master detail list in another page! - by El Forum - 01-28-2010, 02:03 AM
SOLVED:[help]Jqgrid master detail list in another page! - by El Forum - 01-28-2010, 02:04 AM
SOLVED:[help]Jqgrid master detail list in another page! - by El Forum - 02-01-2010, 11:49 PM
SOLVED:[help]Jqgrid master detail list in another page! - by El Forum - 02-01-2010, 11:52 PM
SOLVED:[help]Jqgrid master detail list in another page! - by El Forum - 02-01-2010, 11:53 PM
SOLVED:[help]Jqgrid master detail list in another page! - by El Forum - 02-01-2010, 11:54 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.