Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/syn.corals.io/Corals/modules/Syndicate/Widgets/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

namespace Corals\Modules\Syndicate\Widgets;


use Corals\Modules\Syndicate\Models\Pharmacist;
use Corals\User\Models\User;

class PharmacistWidget
{

    function __construct()
    {
    }

    function run($args)
    {
        $countPharmacist = Pharmacist::count();


        $pharmacist = User::where([
            ['gender_code', '=', 'Syndicate::gender.female'],
        ])->count();


        $loan = User::join('syndicate_loans', function ($join) {
            $join->on('users.id', '=', 'syndicate_loans.user_id');
//                    ->where('syndicate_loans.user_id', '=', 6);
        })
            ->count();
        return view('Syndicate::widgets.pharmacist', [
            'countPharmacist' => $countPharmacist,
            'pharmacist' => $pharmacist,
            'loan' => $loan

        ]);
    }

}