aa
aa
$payments = DB::table('payments')
->leftJoin('treatments' , 'payments.payment_treatment_id' ,'=', 'treatments.treatment_id')
->leftJoin('parts' , 'treatments.treatment_part_id' ,'=', 'parts.part_id')
->leftJoin('advices' , 'payments.payment_advice_id' ,'=', 'advices.advice_id')
->leftJoin('patient_analyzes' , 'payments.payment_analyze_id' ,'=', 'patient_analyzes.patient_analyze_id')
->leftJoin('patients as p1' , 'treatments.treatment_patient_id' ,'=', 'p1.patient_id')
->leftJoin('patients as p2' , 'patient_analyzes.patient_analyze_patient_id' ,'=', 'p2.patient_id')
->leftJoin('patients as p3' , 'advices.advice_patient_id' ,'=', 'p3.patient_id')
->select(
'payments.payment_fully_paid',
'payments.payment_id',
'payments.payment_sum',
'payments.payment_remaining_sum' ,
'payments.payment_treatment_id',
'payments.payment_analyze_id',
'payments.payment_date',
'payments.payment_taker_id',
'payments.transaction_type_id',
'payments.payment_backed_reason',
'payments.payment_backed',
'patient_analyzes.patient_analyze_id',
'patient_analyzes.patient_analyze_patient_id',
'patient_analyzes.patient_analyze_analyzes',
'treatments.treatment_part_id',
'treatments.treatment_id',
'parts.part_name',
'parts.part_location',
'p3.patient_name as p3Name' ,
'p3.patient_father_name as p3Father' ,
'p3.patient_family as p3Family',
'p2.patient_name as p2Name' ,
'p2.patient_father_name as p2Father' ,
'p2.patient_family as p2Family',
'p1.patient_name as p1Name' ,
'p1.patient_father_name as p1Father' ,
'p1.patient_family as p1Family'
)
->where('payments.paid' ,'=' ,1)
->where('payments.payment_date' ,'>=' ,Carbon::now()->startOfMonth())
->groupBy('payments.payment_date')
->orderBy('payments.payment_id' , 'desc')
->paginate(30);
$now = substr(new Carbon('first day of this month') , 0 , 10 );
$total = DB::table('payments')
->where('paid',1)
->where('payment_date' ,'>=' ,Carbon::now()->startOfMonth())
->sum('payment_sum')
-
DB::table('payments')
->where('paid',1)
->where('payment_date' ,'>=' ,Carbon::now()->startOfMonth())
->sum('payment_remaining_sum');
$total_admission = DB::table('payments')
->where('payment_date', '>=', Carbon::now()->startOfMonth())
->where('payment_date', '<', Carbon::now()->addDay())
->where('paid',1)
->count();