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();