从URL获取数据并用于模型类筛选：一份详细教程

http://example.com/reports/lists?source=google&status=active

public function loadLeads($p=''){
    $leadsource = $this->input->get('status');
    // ... 你的其他控制器代码 ...
}

public function loadLeads($p=''){
    $leadsource = $this->input->get('status');

    // ... 你的其他控制器代码 ...

    $content['leads'] = $this->leads_model->get_pagination(
        $_POST['length'],
        $offset,
        $where,
        '',
        false,
        $sortQ?$sortQ:'l.assigned_date desc,',
        $all,
        $leadsource // 将$leadsource传递给模型
    );

    // ... 你的其他控制器代码 ...
}

function get_pagination($num, $offset, $cond='', $order='', $unlimit=false, $add_order='', $all='', $leadsource)
{
    $this->db->select("l.*");
    // ... 其他模型代码 ...

    if (!empty($leadsource)) {
        $this->db->where('lead_source', $leadsource);
    }

    // ... 其他模型代码 ...

    $query =  $this->db->get();
    return $query->result_array();
}

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Reports extends CI_Controller {

    public function __construct() {
        parent::__construct();
        $this->load->model('Leads_model'); // 确保模型被加载
    }

    public function lists($slug = '') {
        // ... 其他列表页面逻辑 ...
    }

    public function loadLeads() {
        $leadsource = $this->input->get('status');

        $offset = (int)$_POST['start'];

        $content['leads'] = $this->Leads_model->get_pagination(
            $_POST['length'],
            $offset,
            [], // 假设没有其他条件
            '',
            false,
            'l.assigned_date desc,', // 假设排序规则
            '',
            $leadsource
        );

        $output = array(
            "source" => $leadsource,
            "data" => $content['leads']
        );

        echo json_encode($output);
        exit();
    }
}

<?php
class Leads_model extends CI_Model {

    function get_pagination($num, $offset, $cond = [], $order = '', $unlimit = false, $add_order = '', $all = '', $leadsource = null) {
        $this->db->select("l.*");

        if (is_array($cond) && count($cond) > 0) {
            $this->db->where($cond);
        }

        if (!empty($leadsource)) {
            $this->db->where('lead_source', $leadsource);
        }

        $this->db->limit($num, $offset); // 添加分页限制
        $query = $this->db->get('leads l'); // 指定表名
        return $query->result_array();
    }
}

<script>
$(document).ready(function() {
    $('#item-list').DataTable({
        "processing": true,
        "serverSide": true,
        "ajax": {
            url: "<?php echo site_url('reports/loadLeads'); ?>",
            type: "GET", // 使用GET方法
            data: {status: "<?php echo $this->input->get('status'); ?>"} // 将 status 参数传递给 Ajax 请求
        },
        "columns": [
            {"data": "id"},
            {"data": "refno"},
            {"data": "source"}
        ]
    });
});
</script>