@H_301_0@DataTables 是一个 jQuery 的表格插件，记录一下在 Laravel 中使用的常用功能和用法，比如 ajax 获取数据，自定义搜索，效果展现，选项说明等等，有一些细节记录下来方便以后查看。

@H_301_0@

Laravel 控制器方法

@H_3010@接受 ajax get 请求，返回数据。

@H301_0@dataTables 会自带一些参数过来，需要按照格式返回数据，比如分页等。见 dataTables 官方文档说明。

@H_301_0@代码如下：

<div class="jb51code">
<pre class="brush:php;">
// ajax GET 获取列表数据
public function getList(Request $request)
{
$dynamicType = $request->get('dynamic_type');
$draw = $request->get('draw');
$start = $request->get('start');
$length = $request->get('length');
$groupId = $request->get('group_id');
$dynamicId = $request->get('dynamic_id');
$userid = $request->get('userid');
$isAudit = $request->get('is_audit',0);

if (!$dynamicType || !in_array($dynamicType,[1,2])) {
return response()->json(['error' => '缺少参数！']);
}

$builder = Dynamics::select(['id','userid','group_id','dynamic_id','dynamic_type','content','money','is_audit','audited_at'])->where('dynamic_type',$dynamicType);

//自定义搜索
if ($groupId) {
$builder->where('group_id',$groupId);
}

if ($dynamicId) {
$builder->where('dynamic_id',$dynamicId);
}

if ($userid) {
$builder->where('userid',$userid);
}

if (!is_null($isAudit)) {
$builder->where('is_audit',$isAudit);
}

$total = $builder->count();
$list = $builder->orderBy('id','desc')->offset($start)->take($length)->get()->toArray();

$imgInfo = [];
$dynamicIds = $this->getDynamicIds($list);
if ($dynamicIds) {
$imgInfo = DynamicImage::whereIn('dynamic_id',$dynamicIds)->pluck('images','dynamic_id');
}

$fillImages = function ($item) use ($imgInfo) {
if (isset($imgInfo[$item['dynamic_id']])) {
$item["images"] = json_decode($imgInfo[$item['dynamic_id']]);
} else {
$item["images"] = [];
}
return $item;
};
$list = array_map($fillImages,$list);

$data = [];
$data["draw"] = $draw;
$data["recordsTotal"] = $total;
$data["recordsFiltered"] = $total;
$data["data"] = $list;
return response()->json($data);
}

// ajax GET 获取列表数据
public function getList(Request $request)
{
$dynamicType = $request->get('dynamic_type');
$draw = $request->get('draw');
$start = $request->get('start');
$length = $request->get('length');
$groupId = $request->get('group_id');
$dynamicId = $request->get('dynamic_id');
$userid = $request->get('userid');
$isAudit = $request->get('is_audit',0);

if (!$dynamicType || !in_array($dynamicType,2])) {
return response()->json(['error' => '缺少参数！']);
}

$builder = Dynamics::select(['id',$dynamicType);

//自定义搜索
if ($groupId) {
$builder->where('group_id',$groupId);
}

if ($dynamicId) {
$builder->where('dynamic_id',$dynamicId);
}

if ($userid) {
$builder->where('userid',$userid);
}

if (!is_null($isAudit)) {
$builder->where('is_audit',$isAudit);
}

$total = $builder->count();
$list = $builder->orderBy('id','desc')->offset($start)->take($length)->get()->toArray();

$imgInfo = [];
$dynamicIds = $this->getDynamicIds($list);
if ($dynamicIds) {
$imgInfo = DynamicImage::whereIn('dynamic_id','dynamic_id');
}

$fillImages = function ($item) use ($imgInfo) {
if (isset($imgInfo[$item['dynamic_id']])) {
$item["images"] = json_decode($imgInfo[$item['dynamic_id']]);
} else {
$item["images"] = [];
}
return $item;
};
$list = array_map($fillImages,$list);

$data = [];
$data["draw"] = $draw;
$data["recordsTotal"] = $total;
$data["recordsFiltered"] = $total;
$data["data"] = $list;
return response()->json($data);
}