大佬教程收集整理的这篇文章主要介绍了javascript – 列表排序不能使用jQuery中使用datatable的ajax，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。
我在laravel中使用jQuery的Datatable来查看带有ajax的列表,但是当我点击排序按钮时,绘制参数会增加其值并根据页面对数据进行排序.
我的控制器：
/**
* listings of organizations table
*
* @param $request object of Request class
* @return response json
*/
public function apiListing(Request $request)
{
$request['page'] = $request['draw'];
$columns = $request->input('columns');
$order = $request->input('order');
$orderField = $columns[$order[0]['column']]['data'];
$orderDir = $order[0]['dir'];
$request['s'] = $orderField;
$request['o'] = $orderDir;
$request['limit'] = $request->input('length');
$offset = $request->input('start');
$request['page'] = $offset < $request['limit']="" 1="" :="" intval($offset/$request['limit'])+1;="" $utilities="$this->service->paginate($request);" $totalfiltered="$utilities->total();" $data="[];" foreach="" ($utilities="" as="" $key=">" $utility)="" {="" $data[]="[" 'utility_id'=">" $utility->utility_id,'name'=">" $utility->name,'street_address'=">" $utility->street_address,'city'=">" $utility->city,'state_code'=">" $utility->state_code,'zip'=">" $utility->zip,];="" }="" $json_data="array(" "draw"=">" intval($request->input('draw')),"recordstotal"=">" intval($totalfiltered),"recordsfiltered"=">" intval($totalfiltered),"data"=">" $data="" );="" return="" response()->json($json_data);="" }="">我的javascript：
function getUtilitiesListingObj()
{
return new function() {
this.$tableObj = $('.utilities-listing-table'),this.$searchForm = $('#utilitiesSearch'),this.$datatableObj = '',this.bind = function() {
var $obj = this;
$obj.filtering();
$obj.initiallizeDataTable();
},this.initiallizeDataTable = function() {
var $obj = this;
$.extend( $.fn.dataTableExt.oStdClasses,{
"sFilterInput": "form-control","sLengthSelect": "form-control"
});
$obj.$dataTableObj = $obj.$tableObj.DataTable( {
"pageLength": 100,"lengthMenu": [[10,25,50,100,500],[10,500]],"order": [[ 1,"asc" ]],"stateSave": true,"scrollY": "500px","serverSide": true,"processing": true,"oLanguage": {
"sProcessing": "
你也可以设置页面号d.page_no = d.start / d.length 1;在这样的请求中：
....
"ajax":{
"url": GLOBAL_SETTINGS.UTILITIES_LISTING_URL,"data": function(d) {
d.name = $('.name-filter').attr('value');
d.street_address = $('.address-filter').attr('value');
d.city = $('.city-filter').attr('value');
d.state_code = $('.state-filter').attr('value');
d.zip = $('.zip-filter').attr('value');
d.page_no = d.start / d.length + 1;
}
}
...
并且还可以在控制器中设置页面no,如下所示：
/**
* listings of organizations table
*
* @param $request object of Request class
* @return response json
*/
public function apiListing(Request $request)
{
$request['page'] = $request['page_no'];
$columns = $request->input('columns');
$order = $request->input('order');
$orderField = $columns[$order[0]['column']]['data'];
$orderDir = $order[0]['dir'];
$request['s'] = $orderField;
$request['o'] = $orderDir;
$request['limit'] = $request->input('length');
$offset = $request->input('start');
$request['page'] = $offset < $request['limit']="" 1="" :="" intval($offset/$request['limit'])+1;="" $utilities="$this->service->paginate($request);" $totalfiltered="$utilities->total();" $data="[];" foreach="" ($utilities="" as="" $key=">" $utility)="" {="" $data[]="[" 'utility_id'=">" $utility->utility_id,];="" }="" $json_data="array(" "page"=">" intval($request->input('page_no')),"data"=">" $data="" );="" return="" response()->json($json_data);="" }="">希望这可能对你有帮助.
以上是大佬教程为你收集整理的javascript – 列表排序不能使用jQuery中使用datatable的ajax全部内容，希望文章能够帮你解决javascript – 列表排序不能使用jQuery中使用datatable的ajax所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错，欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。
