aa
aa
$analyzes =
DB::table('patient_analyzes')
->join('patients','patient_analyzes.patient_analyze_patient_id','=','patients.patient_id')
->select(
'patient_analyzes.patient_analyze_patient_id',
'patient_analyzes.patient_analyze_analyzes',
'patient_analyzes.checked_level',
'patient_analyzes.patient_analyze_id',
'patient_analyzes.created_at as cdate',
'patient_analyzes.patient_analyze_part_count',
'patients.*'
)
->where('patient_analyzes.checked_level' , '!=', 1) // faqat tolovi amalga oshirilgan analizlar
->orderBy('patient_analyzes.patient_analyze_id' , 'desc')
->paginate(30);