datagrid - 如何从easyui datagrid获取所有数据

Question

我尝试使用 getData 例如

data = $("#dg").datagrid("getData");`
var total = data.total; (total is 100)`
var rows = data.rows; (rows.length is 25)`

结果是:总数正确，如 100 条记录但行返回仅获取当前页面行，例如 25 行。我需要获取所有记录(100 行)。

有什么我错过的吗？或者我们怎样才能做到这一点？请帮助我。

Answer 1

这是因为分页。让我用分页来描述在 php 中显示 100 行的模型。

function get_invoiceinfoList($search_keyword,$custID){

    $page = 1;
    $rows = 100;
    $sort = '';
    $order = 'asc';
    $offset = ($page - 1) * $rows;

        if($custID > 0  && $search_keyword == 0){ 
            $search = " and a.customer_id =$custID";  
        }else{  
         $search = "and (b.name like '%$search_keyword%' || a.inv_no like '%$search_keyword%')" ; 
        }

        $vQuery=$this->db->query("SELECT a.inv_id,a.inv_no,a.inv_org,a.inv_date,
            a.customer_id,a.heading,a.quot_id,a.total_cost as total_amount,
            a.paid_amount,(a.total_cost-a.paid_amount)as due_amount,b.name
            from  sales_invoice a,view_customer_info b
            where
            a.customer_id = b.customer_id $search order by a.inv_date DESC limit $offset, $rows");

        $result = $vQuery->result();
        $rows = array();

    foreach ($result as $rowData){
        array_push($rows, $rowData);
    }
    $data['rows'] = $rows;

    return $data;  
    }