PianoTime/app/Http/Controllers/Admin/CheckCardController.php

<?php

namespace App\Http\Controllers\Admin;

use App\Models\CheckCard;
use App\Models\Student;
use Carbon\Carbon;
use Illuminate\Http\Request;

class CheckCardController extends Controller
{
    protected $redirect_index = '/admin/CheckCard/index';

    protected $view_path = 'admin.check-cards.';

    protected $pre_uri = '/admin/CheckCard/';

    protected $model_name = '打卡';

    protected $model;

    public function __construct()
    {
        parent::__construct();
        $this->model = new CheckCard();
    }

    public function index(Request $request)
    {
        $list = $this->model->where('id', '>', 0)->orderBy('created_at', 'desc')->get();

        if(!empty($request->input('keyword')) && !empty(trim($request->input('keyword')))) {
            $keyword = trim($request->input('keyword'));

            $list = $list->filter(function ($value) use($keyword) {
                if(!empty($value->student) && !(strpos($value->student->name, $keyword) === false)) {
                    return true;
                }
                if(!empty($value->course) && !(strpos($value->course->name, $keyword) === false)) {
                    return true;
                }
                return false;
            });
        }

        if(!empty($request->input('begin_date'))) {
            $begin_date_time = Carbon::createFromTimestamp(strtotime($request->input('begin_date')))->toDateTimeString();
        } else {
            $begin_date_time = Carbon::now()->subYears(10)->toDateTimeString();
        }

        if(!empty($request->input('end_date'))) {
            $end_date_time = Carbon::createFromTimestamp(strtotime($request->input('end_date')))->addDay()->toDateTimeString();
        } else {
            $end_date_time = Carbon::now()->addYears(10)->toDateTimeString();
        }

        if(!empty($begin_date_time) || !empty($end_date_time)) {
            $list = $list->filter(function ($value) use($begin_date_time, $end_date_time) {
                return $value->begin_date_time >= $begin_date_time && $value->end_date_time < $end_date_time;
            });
        }

        $list = $this->paginate($list);

        foreach($list as $item) {
            $item->duration = $item->getDuration();
        }

        list($pre_uri, $model_name) = array($this->pre_uri, $this->model_name);
        return view($this->view_path . 'index', compact('list', 'pre_uri', 'model_name'));
    }

    public function rank(Request $request)
    {
        $students = Student::all();
        foreach($students as $student) {
            $tmp = $student->getCheckCardTime($request->input('begin_date'), $request->input('end_date'));
            $student->total = (int)$tmp['total'];
            $student->totalHuman = $tmp['totalHuman'];
            $student->courseName = $student->getCourseName();
        }

        $students = $students->sortByDesc('total');
        $rank = 0;
        foreach($students as $student) {
            $student->rank = ++$rank;
        }
        $list = $this->paginate($students);
        list($pre_uri, $model_name) = array($this->pre_uri, $this->model_name);
        return view($this->view_path . 'rank', compact('list', 'pre_uri', 'model_name'));
    }
}