Файловый менеджер - Редактировать - /home/kckglobal/public_html/portal/Modules/Payroll/Entities/EmployeeMonthlySalary.php
Назад
<?php namespace Modules\Payroll\Entities; use App\Models\BaseModel; class EmployeeMonthlySalary extends BaseModel { protected $guarded = ['id']; protected $dates = ['date']; public static function employeeNetSalary($userId, $tillDate = null) { $initialSalary = EmployeeMonthlySalary::where('user_id', $userId) ->where('type', '=', 'initial') ->sum('amount'); $addSalary = EmployeeMonthlySalary::where('user_id', $userId) ->where('type', '=', 'increment'); if (! is_null($tillDate)) { $addSalary = $addSalary->where('date', '<=', $tillDate); } $addSalary = $addSalary->sum('amount'); $subtractSalary = EmployeeMonthlySalary::where('user_id', $userId) ->where('type', '=', 'decrement'); if (! is_null($tillDate)) { $subtractSalary = $subtractSalary->where('date', '<=', $tillDate); } $subtractSalary = $subtractSalary->sum('amount'); $netSalary = ($initialSalary + $addSalary - $subtractSalary); if ($netSalary < 0) { $netSalary = 0; } return [ 'netSalary' => $netSalary, 'initialSalary' => $initialSalary, ]; } public static function employeeIncrements($userId) { return EmployeeMonthlySalary::where('user_id', $userId) ->where('type', '=', 'increment') ->get(); } }
| ver. 1.4 |
Github
|
.
| PHP 8.2.28 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка