<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class SignLog extends Model
{
	protected $fillable = [];
    protected $guarded  = [];
	//元旦签到类型
    public const NEWYEARTYPE = 'NEWYEAR';

    public function scopeSignType($query, $type)
    {
        return $query->where('type', $type);
    }

    public function scopeOrder($query, $key, $order='asc')
    {
    	return $query->orderBy($key, $order);
    }

    public function scopeCurrentDay($query)
    {
    	$start_time = date('Y-m-d');
    	$end_time = date('Y-m-d 23:59:59');
    	return $query->whereBetween('sign_date', [$start_time, $end_time]);
    }

    
}