Answers

• thinkingman Posts: 3Questions: 1Answers: 0

  October 2020

  I should have added that this is my current script.

  <script type="text/javascript">
  
    $(document).ready(function () {
  
      var table = $('.data-table').DataTable({
        processing: true,
        serverSide: true,
        ajax: "{{ route('customers.index') }}",
        columns: [
          {data: 'id', name: 'id'},
          {data: 'cr_customer', name: 'Number'},
          {data: 'cr_name', name: 'Name'},
          {data: 'cr_area_code', name: 'Area Code'},
          {data: 'cr_phone', name: 'Phone'},
          {data: 'action', name: 'action', orderable: false, searchable: false},
        ]
      });
  
  
    });
  </script>
  
• colin Posts: 15,142Questions: 1Answers: 2,586

  October 2020

  That will be down to the server-side script. Can you post that here too, please,

  Colin
• thinkingman Posts: 3Questions: 1Answers: 0

  October 2020

  @colin here is the controller function.

  public function index(Request $request)
      {
  
          if ($request->ajax()) {
              $data = Customers::latest()->get();
              return Datatables::of($data)
                  ->addIndexColumn()
                  ->addColumn('action', function($row){
  
                      $action = '<a class="btn btn-info" id="show-customer" data-toggle="modal" data-id='.$row->id.'>Show</a>
  <a class="btn btn-success" id="edit-customer" data-toggle="modal" data-id='.$row->id.'>Edit </a>
  <meta name="csrf-token" content="{{ csrf_token() }}">
  <a id="delete-customer" data-id='.$row->id.' class="btn btn-danger delete-customer">Delete</a>';
  
                      return $action;
  
                  })
                  ->rawColumns(['action'])
                  ->make(true);
          }
  
          return view('admin.customers');
  
  
      }
  
• allan Posts: 61,650Questions: 1Answers: 10,093 Site admin

  October 2020 edited October 2020

  Thanks for the script. I'm afraid you'll need to contact the author of the Laravel server-side processing library though, as I'm not familiar with their API. At a guess it looks like the action column should be searchable, but I'm really not sure how their API is meant to work.

  Allan