You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 

23 lines
640 B

<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class SubscriptionPause extends Model
{
use HasFactory;
protected $casts = [
'subscription_id'=>'integer',
];
public function scopeCheckdate($query, $start_date, $end_date)
{
$query->where(function($query)use($start_date){
$query->whereDate('from','<=', $start_date)->whereDate('to', '>=', $start_date);
})->orWhere(function($query)use($end_date){
$query->whereDate('from','<=', $end_date)->whereDate('to', '>=', $end_date);
});
}
}