看來我的選擇是錯誤的。我在數(shù)據(jù)表中想要的是每個主管名稱都可以有一個包含員工姓名的子行。但我得到的是:{ "id": "2", "name_supervisor": "Alex", "name": "testStaff4", "manager_id": "2", "role_id": "1"},{ "id": "1", "name_supervisor": "Andika", "name": "testStaff1", "manager_id": "1", "role_id": "1"}這是我的查詢:$supervisors = DB::table('supervisors')->join('users','users.manager_id','=','supervisors.id') ->select(['supervisors.id','supervisors.name_supervisor','users.name','users.manager_id','users.role_id']) ->where('users.role_id',1) ->orWhere('users.role_id',null) ->groupBy('supervisors.name_supervisor'); return Datatables::of($supervisors)->make(true);這是我的帶有子行的 js 數(shù)據(jù)表:function format ( d ) { // `d` is the original data object for the row return '<table cellpadding="5" cellspacing="0" border="0" style="padding-left:50px;">'+ '<tr>'+ '<td>Name:</td>'+ '<td>'+d.name+'</td>'+ '</tr>'+ '</table>'; } $(document).ready(function() { var table = $('#ajax_data').DataTable({ processing: true, serverSide: true, ajax: 'supervisor/json', dom: '<"top"f>rt<"bottom"lip><"clear">', columnDefs: [{"className": "text-center", "targets": "_all"}], columns: [ { "className": 'details-control', "orderable": false, "data": null, "defaultContent": '' }, { data: 'name_supervisor', name: 'supervisors.name_supervisor' } ] }); } );
在數(shù)據(jù)表子行中的經(jīng)理姓名中查詢選擇員工姓名
至尊寶的傳說
2021-08-20 14:24:25
