mercredi 11 avril 2018

Display filter query based on date and another column in laravel 5.4

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