I'm a newbie to develop my project using laravel. I have an issue to separate the pemandu_id column based on jadual_tarikh, and filter more data based on pemandu_id and jadual_tarikh, but the data not is not showing as I expected. This is a view that what I imagined in THIS VIEW
Here's my table 'jadual' CLICK HERE
Here's a blade
Date: <select class="form-control show-tick" name="jadual_tarikh">
<option value="">-- Please select --</option>
@foreach($date as $d)
<option value=""></option>
@endforeach
</select>
</div>
</div>
<!-- Nav tabs -->
<ul class="nav nav-tabs tab-nav-right" role="tablist" name="pemandu_id">
@foreach($driver_details as $a)
<li role="presentation" value="" class="active"><a onclick="changeData();" data-toggle="tab" data-target="#myTab"></a></li>
@endforeach
</ul>
and this my controller
public function list(){
$date = DB::table('jadual')->get();
$attendance_details = DB::table('pemandu_bas')
->join('jadual','jadual.pemandu_id', '=', 'pemandu_bas.pemandu_id')
->select('pemandu_bas.*','jadual.*')
->groupBy('jadual.jadual_tarikh')->get();;
return view('attendance.attendance_list', compact('date','attendance_details'));
}
I would really appreciate if you could help me solve this problem. Thank you in advance!
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire