public function actionCheck()
{
$dt = new \DateTime();
echo 'Current date/time: ' . $dt->format('Y-m-d H:i:s');
echo '<br/>';
echo 'Current timezone: ' . $dt->getTimezone()->getName();
echo '<br/>';
}
public function scopeMonthly($query)
{
$dt = new \DateTime();
$month = intval($dt->format('n'));
$year = intval($dt->format('Y'));
$target_year_month = null;
if ($month == '1') {
$target_year_month = $year - 1 . '12';
} else {
$target_year_month = $year . ($month - 1 < 10 ? "0" . ($month - 1) : $month - 1);
}
$query->Join('projects', function ($join) {
$join->on('claims.project_id', '=', 'projects.id')->where('projects.reports_type', '=', \DB::raw('monthly'));
})->whereRaw('EXTRACT(YEAR_MONTH FROM claims.created_at)=' . $target_year_month);
return $query;
}