51 lines
1.3 KiB
PHP
51 lines
1.3 KiB
PHP
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use Illuminate\Database\Eloquent\Model;
|
|
|
|
class MedicalHistorySnapshot extends Model
|
|
{
|
|
protected $primaryKey = 'medical_history_snapshot_id';
|
|
|
|
protected $fillable = [
|
|
'rf_report_id',
|
|
'rf_medicalhistory_id',
|
|
'patient_type',
|
|
];
|
|
|
|
/**
|
|
* Типы пациентов
|
|
*/
|
|
const PATIENT_TYPE_DISCHARGED = 'discharged'; // Выписанные
|
|
const PATIENT_TYPE_CURRENT = 'current'; // Текущие
|
|
|
|
public function report()
|
|
{
|
|
return $this->belongsTo(Report::class, 'rf_report_id');
|
|
}
|
|
|
|
public function medicalHistory()
|
|
{
|
|
return $this->belongsTo(MisMedicalHistory::class, 'rf_medicalhistory_id', 'MedicalHistoryID');
|
|
}
|
|
|
|
// Скоупы для фильтрации
|
|
public function scopeForReport($query, $reportId)
|
|
{
|
|
return $query->where('rf_report_id', $reportId);
|
|
}
|
|
|
|
public function scopeByPatientType($query, $type)
|
|
{
|
|
return $query->where('patient_type', $type);
|
|
}
|
|
|
|
public function scopeByDepartment($query, $departmentId)
|
|
{
|
|
return $query->whereHas('medicalHistory.migrations.branch', function($q) use ($departmentId) {
|
|
$q->where('rf_DepartmentID', $departmentId);
|
|
});
|
|
}
|
|
}
|