Файловый менеджер - Редактировать - /home/clickysoft/public_html/rgr.clickysoft.net/app/Http/Controllers/ReportsController.php
Назад
<?php namespace App\Http\Controllers; use App\Models\ReferralPatient; use Illuminate\Http\Request; use App\Models\Practice; use App\Models\Speciality; use App\Models\User; use DataTables; class ReportsController extends Controller { public function index(Request $request) { if ($request->ajax()) { if (!empty($request->from_date)) { // dd($request->from_date); $data = ReferralPatient::whereRaw('created_at > "' . $request->from_date . '" AND created_at < "' . $request->to_date . '"')->get(); } else { $data = ReferralPatient::latest()->get(); } return Datatables::of($data) ->addIndexColumn() ->addColumn('referral', function ($row) { $practiceFrom = Practice::find($row['from_practice_id']); $view = '<h6 class="tb-devonshire">' . $practiceFrom->name . '</h6>'; return $view; }) ->addColumn('referred_to', function ($row) { $practiceTo = Practice::find($row['to_practice_id']); $view = '<h6 class="tb-devonshire">' . $practiceTo->name . '</h6>'; return $view; }) ->addColumn('patient_name', function ($row) { return $row['first_name'] . ' ' . $row['last_name']; }) ->addColumn('user', function ($row) { $user = User::find($row['user_id']); return $user->first_name . ' ' . $user->last_name; }) ->addColumn('patient_id', function ($row) { return $row['id']; }) ->addColumn('date', function ($row) { return date('m/d/Y', strtotime($row['created_at'])); }) ->addColumn('action', function ($row) { return '<a class="btn btn-primary edit" href="/admin/reports/' . $row['id'] . '/view">View</a>'; }) ->addColumn('treatment_type', function ($row) { $job = Speciality::find($row['treatment_type']); return $job->title; }) ->rawColumns(['referral', 'referred_to', 'user', 'treatment_type', 'patient_name', 'patient_id', 'date', 'action']) ->make(true); } $reports = ReferralPatient::latest()->paginate(5); return view('admin.reports', compact('reports')) ->with('i', (request()->input('page', 1) - 1) * 5); } public function detail($id) { $report = ReferralPatient::find($id); return view('admin.report-detail', compact('report')); } }
| ver. 1.4 |
Github
|
.
| PHP 8.1.29 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка