/** * function for send ajax request to view * * @return Response */ public function listingJson() { $query = DpBookedUnit::select('id', 'booked_unit_id', 'is_valid', 'dp_type', 'dp_amount', 'changed_by', 'created_at')->with('User')->with('BookedUnit')->get(); return Datatable::collection($query)->addColumn('booked_unit_id', function ($model) { return $model->id; })->addColumn('is_valid', function ($model) { $is_valid = $model->is_valid == '1' ? 'Yes' : 'No'; return $is_valid; })->addColumn('dp_type', function ($model) { return $model->dp_type; })->addColumn('dp_amount', function ($model) { return $model->dp_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('DpBookedUnitsController@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('DpBookedUnitsController@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('DpBookedUnitsController@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', 'dp_type', 'dp_amount', 'changed_by')->make(); }