codeigniter get分页教程-PHP源码-PHP中文網

codeigniter get分页教程
PHP中文网
發布： 2016-05-25 17:05:40
原創
1064 人瀏覽過
php代码
 public function project_search(){
        $this->load->library(&#39;pagination&#39;);
        $this->load->model(&#39;depart_mdl&#39;);
        //获取搜索需要的信息
        $data = $this->get_project_data();
        $get_data = $this->input->get();
        $data = array_merge($data,$get_data);
        //get分页配置
        $name = $get_data[&#39;name&#39;];
        $username = $get_data[&#39;username&#39;];
        $budget = $get_data[&#39;budget&#39;];
        $type = $get_data[&#39;type&#39;];
        $posttime_start = $get_data[&#39;posttime_start&#39;];
        $posttime_end = $get_data[&#39;posttime_end&#39;];
        $purchase_type = $get_data[&#39;purchase_type&#39;];
        $depart_code = $get_data[&#39;depart_code&#39;];
        $project_status = $get_data[&#39;project_status&#39;];
        $bidder_way = $get_data[&#39;bidder_way&#39;];
        $suffix = "?name=$name&username=$username&budget=$budget&type=$type&posttime_start=$posttime_start&posttime_end=$posttime_end&purchase_type=$purchase_type&depart_code=$depart_code&project_status=$project_status&bidder_way=$bidder_way";
        $config[&#39;base_url&#39;] = site_url(&#39;project/project_search&#39;).$suffix;
        $config[&#39;total_rows&#39;] = $this->db->count_all($this->db->dbprefix(&#39;project&#39;));
        $config[&#39;per_page&#39;] = 10;
        $config[&#39;page_query_string&#39;] = TRUE;
        //偏移量
        $config[&#39;query_string_segment&#39;] = &#39;page&#39;;
        $config[&#39;uri_segment&#39;] = 3;
        $this->pagination->initialize($config);
        $user = $this->user_mdl->get_user_by_salary_no($this->session->userdata(&#39;salary_no&#39;));
        $this->db->from(&#39;ustc_project&#39;);
        $this->db->join(&#39;ustc_admins&#39;,&#39;ustc_admins.salary_no=ustc_project.salary_no&#39;);
        if($user->role!=1){
            $depart_code = explode(&#39;,&#39;,$user->grant_depart_code);
            $this->db->where_in(&#39;grant_depart_code&#39;,$depart_code);
            $this->db->or_where(&#39;ustc_project.salary_no =&#39;,$this->session->userdata(&#39;salary_no&#39;));
        }
        if($name != &#39;&#39;){
            $this->db->like(&#39;name&#39;,$name);
        }
        if($username != &#39;&#39;){
            $this->db->like(&#39;username&#39;,$get_data[&#39;username&#39;]);
        }
        if($budget != &#39;&#39;){
            $this->db->like(&#39;budget&#39;,$get_data[&#39;budget&#39;]);
        }
        if($type != &#39;&#39;){
            $this->db->where(&#39;type&#39;,$get_data[&#39;type&#39;]);
        }
        if($depart_code != &#39;&#39;){
            $this->db->where(&#39;depart_code&#39;,$get_data[&#39;depart_code&#39;]);
        }
        if($purchase_type != &#39;&#39;){
            $this->db->where(&#39;purchase_type&#39;,$get_data[&#39;purchase_type&#39;]);
        }
        if($project_status != &#39;&#39;){
            $this->db->where(&#39;project_status&#39;,$get_data[&#39;project_status&#39;]);
        }
        if($bidder_way != &#39;&#39;){
            $this->db->where(&#39;bidder_way&#39;,$get_data[&#39;bidder_way&#39;]);
        }
        //时间
        if($posttime_start != &#39;&#39;){
            $this->db->where(&#39;posttime > &#39;,strtotime($get_data[&#39;posttime_start&#39;]));
        }
        if($posttime_end != &#39;&#39;){
            $this->db->where(&#39;posttime < &#39;,strtotime($get_data[&#39;posttime_end&#39;]));
        }
        if(isset($get_data[&#39;page&#39;])){
            $page_from = $get_data[&#39;page&#39;];
        }else{
            $page_from = 0;
        }
        $this->db->order_by(&#39;posttime&#39;,&#39;desc&#39;);
        $projects = $this->db->limit($config[&#39;per_page&#39;],$page_from)->get()->result_array();    
        
        //处理
        for($i=0;$i<count($projects);$i++){
            $projects[$i][&#39;type&#39;] = $this->manage_info_mdl->get_value_by_id($projects[$i][&#39;type&#39;])->value;
            $projects[$i][&#39;purchase_type&#39;] = $this->manage_info_mdl->get_value_by_id($projects[$i][&#39;purchase_type&#39;])->value;
            $projects[$i][&#39;depart&#39;] = $this->depart_mdl->get_depart_by_code($projects[$i][&#39;depart_code&#39;])->name;
        }
        $data[&#39;projects&#39;] = $projects;
        //获取当前用户的角色
        $data[&#39;user_role&#39;] = $this->user_mdl->get_user_by_salary_no($this->session->userdata(&#39;salary_no&#39;))->role;    
        $this->_template(&#39;project_search&#39;,$data);
    }
登入後複製