/** * function for send ajax request to view * * @return Response */ public function listingJson() { $query = AkadBookedUnit::select('id', 'booked_unit_id', 'is_valid', 'bank_id', 'akad_amount', 'created_at', 'changed_by')->with('User')->with('BookedUnit')->get(); return Datatable::collection($query)->addColumn('id', function ($model) { return $model->id; })->addColumn('is_valid', function ($model) { $is_valid = $model->is_valid == '1' ? 'Yes' : 'No'; return $is_valid; })->addColumn('bank_id', function ($model) { //return $model->bank->name; return '<a href="' . action('BanksController@detail', $model->bank_id) . '">' . ucfirst($model->bank->name) . '</a>'; })->addColumn('akad_amount', function ($model) { return $model->akad_amount; // return $model->project->name . $model->project_id; })->addColumn('created_at', function ($model) { return $model->created_at->format('d-m-Y'); })->addColumn('changed_by', function ($model) { return $model->user->name; })->addColumn('show', function ($model) { return '<a href="' . action('AkadBookedUnitsController@detail', $model->id) . '" class="btn btn-small btn-primary btn-constant"><i class="fa fa-eye fa-fw"></i></a>'; })->addColumn('edit', function ($model) { return '<a href="' . action('AkadBookedUnitsController@edit', $model->id) . '" class="btn btn-small btn-success btn-constant"><i class="fa fa-edit fa-fw"></i></a>'; })->addColumn('delete', function ($model) { return '<form action="' . action('AkadBookedUnitsController@delete', $model->id) . '" method="POST"><button type="submit" class="btn btn-small btn-danger btn-constant" onclick = "return confirm(\'Are you sure?\')"><i class="fa fa-times fa-fw"></i></button></form>'; })->searchColumns('id', 'booked_unit_id', 'is_valid')->orderColumns('id', 'booked_unit_id', 'is_valid', 'bank_id', 'akad_amount', 'changed_by')->make(); }