I have aplication with condition... when option division selected, then show modal form with datatable based on selected option , i'am using laravel8
My code in view..
<div class="form-group row"> <label for="divisi" class="col-sm-2 col-form-label"> Pilih
Divisi</label>
<select class="col-sm-5 form-control custom-select" name="divisi" id="divisi">
<option selected>-- Pilih --</option>
@foreach ($divisi as $key => $item)
<option value="{{ $key }}">{{ $item }}</option>
@endforeach
</select>
</div>
and My Code in Js
$('#divisi').change(function() {
var id_divisi = $('#divisi').val();
var tableCustomer;
var tableProduk;
let _token = $('meta[name="csrf-token"]').attr('content');
console.log(id_divisi);
$.ajax({
type: 'GET',
url: "{{ route('penjualand.getBarang') }}",
data: {
id_divisi: id_divisi
},
chache: false,
success: function(brg) {
console.log('SUCCESS', brg);
tableProduk = $('.table-produk').DataTable({
responsive: true,
processing: true,
serverSide: true,
retrieve: true,
autoWidth: false,
ajax: {
url: "{{ route('penjualand.getBarang') }}",
},
columns: [
{data: 'DT_RowIndex', searchable: false, sortable: false},
{data: 'kode'},
{data: 'nama'},
{data: 'hargaJual'},
]
});
My controller
public function getBarang(Request $request)
{
$selectedDiv = $request->id_divisi;
$barang = DB::table('barang')->where('divisi_id',$selectedDiv)->get();
return datatables()
->of($barang)
// ->addIndexColumn()
// ->addColumn('kode', function ($barang) {
// return ($barang->kode);
// })
->rawColumns([])
->make(true);
}
when combo box selected item change, my datatables dont return anything in modal form. Please advice...
thanks in advance