/** * Get the patients registered by a user * * @return db resultset */ public static function getPatientsRegistered($from, $to, $userID = 0) { $patients = Patient::select(['id'])->whereBetween('created_at', [$from, $to]); if ($userID > 0) { $patients = $patients->where('created_by', '=', $userID); } return $patients->get(); }
public function index(Request $request) { if ($request->ajax()) { $patient = Patient::select(['id', 'name', 'mobile', 'date_of_birth', 'image'])->get(); return Datatables::of($patient)->addColumn('Image', function ($item) { return '<img src="' . $item->image . ' " alt="Smiley face" height="42" width="42">'; })->addColumn('Operations', function ($item) { $form = \Form::open(['method' => 'DELETE', 'url' => 'patient/' . $item->id, 'class' => 'table-form-inline', 'data-bb' => 'confirm']); $form .= \Form::hidden('id', $item->id); $form .= \Form::button('<i class="glyphicon glyphicon-trash"></i> Delete', ['class' => 'btn btn-danger btn-xs', 'type' => 'submit']); $form .= \Form::close(); $form .= ' ' . link_to('patient/' . $item->id . '/edit', $title = "Edit", $attributes = ['class' => 'btn btn-primary btn-xs glyphicon glyphicon-edit'], $secure = null); return $form; })->removeColumn('id')->removeColumn('image')->make(); } return view('patient.list'); }