Possible to do counts on attributes? Querybuilder | Laravel | Page 1

fiery adder Jan 31, 2023, 4:22 PM

#

Wanting to ask if its possible to use existing attributes in a model and use them for counts.

My repository is based off a Lead model and this model contains 2 attributes i want to count.

    /**
     * Checks to see if the lead is cold (no action for a few days)
     * 
     * @return bool
     */
    public function getColdLeadAttribute():bool
    {
        return $this->lead_last_action >= 2 && ($this->status == Status::INITIATION->value || $this->status == Status::QUALIFICATION->value || $this->status == Status::DEAL_BUILDING->value);
    }

    /**
     * Checks to see if the lead is warm (close to closing a deal)
     * 
     * @return bool
     */
    public function getWarmLeadAttribute():bool
    {
        if($this->offerApprovedApprovals()->exists()){
            return $this->status == Status::DEAL_BUILDING->value && $this->offer_approved_approvals_count;
        }else {
            return false;
        }
    }

stray sonnet Jan 31, 2023, 4:56 PM

#

It's not really clear from this code what you want to count

fiery adder Jan 31, 2023, 5:25 PM

#

@stray sonnet i would like to call this someone as a re-use of code to count the warm leads and cold leads.

#

    public function getLeadStats(array $filters): Lead
    {
        @['search' => $search] = $filters;

        $queryBuilder = $this->model;

        $queryBuilder->withCount('warm_leads');

stray sonnet Jan 31, 2023, 5:40 PM

#

Then I think the Query scopes is a better choice https://laravel.com/docs/9.x/eloquent#local-scopes

Laravel - The PHP Framework For Web Artisans

Laravel is a PHP web application framework with expressive, elegant syntax. We’ve already laid the foundation — freeing you to create without sweating the small things.

#

Once you create a local scope, you can do the following:

YourModel::warmLead()->count();

fiery adder Jan 31, 2023, 6:08 PM

#

thank you

stray sonnet Jan 31, 2023, 6:33 PM

#

You're very welcome 🙂

trail wren Jan 31, 2023, 8:15 PM

#

stray sonnet Once you create a local scope, you can do the following: ```php YourModel::warm...

I was struggling with this question the other day. Would you do:

Model::warmLead() singular or
Model::warmLeads() plural?

I ended up going with Singular::withPlural() for my scope

#Possible to do counts on attributes? Querybuilder