Wrong data type when counting service count

[AhmadShamli]

my-idlers V2.3.2

on file app/Models/Home.php

    public static function servicesCount()
        {
            return Cache::remember('services_count', now()->addHours(6), function () {
                $count = DB::table('pricings')
                    ->select('service_type', DB::raw('COUNT(*) as amount'))
                    ->groupBy('service_type')
                    ->where('active', 1)
                    ->get();
                var_dump($count);
                return $count;
            });
        }

will produce

    object(Illuminate\Support\Collection)#1121 (2) { ["items":protected]=> array(2) { [0]=> object(stdClass)#1269 (2) { ["service_type"]=> string(1) "1" ["amount"]=> string(1) "3" } [1]=> object(stdClass)#1282 (2) { ["service_type"]=> string(1) "3" ["amount"]=> string(1) "1" } } ["escapeWhenCastingToString":protected]=> bool(false) }

notice that the service_type is string

while on the same file

    public static function doServicesCount($services_count): array
        {
            $services_count = json_decode($services_count, true);
            return Cache::remember('services_count_all', now()->addWeek(1), function () use ($services_count) {
                $servers_count = $domains_count = $shared_count = $reseller_count = $other_count = $seedbox_count = $total_services = 0;
                foreach ($services_count as $sc) {
                    $total_services += $sc['amount'];
                    if ($sc['service_type'] === 1) {
                        $servers_count = $sc['amount'];
                    } else if ($sc['service_type'] === 2) {
                        $shared_count = $sc['amount'];
                    } else if ($sc['service_type'] === 3) {
                        $reseller_count = $sc['amount'];
                    } else if ($sc['service_type'] === 4) {
                        $domains_count = $sc['amount'];
                    } else if ($sc['service_type'] === 5) {
                        $other_count = $sc['amount'];
                    } else if ($sc['service_type'] === 6) {
                        $seedbox_count = $sc['amount'];
                    }
                }
    
                return array(
                    'servers' => $servers_count,
                    'shared' => $shared_count,
                    'reseller' => $reseller_count,
                    'domains' => $domains_count,
                    'other' => $other_count,
                    'seedbox' => $seedbox_count,
                    'total' => $total_services
                );
            });
    
        }

it is try to match exact type of int value, this result in empty (0) value on Home page....

[AhmadShamli]

the same goes for breakdownPricing() in the same file

[AhmadShamli]

on file resources/views/home.blade.php

also require to change to @if(Session::get('timer_version_footer', 0) == 1) as the type didnt match

[cp6]

@AhmadShamli

Im not getting the string type when debugging and the counts work as expected, interested to see if others get this issue:

= Illuminate\Support\Collection {#5611 all: [ {#5609 +"service_type": 1, +"amount": 1, }, {#5605 +"service_type": 2, +"amount": 1, }, {#5607 +"service_type": 3, +"amount": 1, }, {#5606 +"service_type": 4, +"amount": 1, }, ], }

[AhmadShamli]

HI,

below would be the server information:

Host: Namecrane (BuyShared) server: lv-shared01.dapanel.net php: php 8.1.28 loaded ext: Array ( [0] => Core [1] => date [2] => libxml [3] => openssl [4] => pcre [5] => sqlite3 [6] => zlib [7] => bz2 [8] => calendar [9] => ctype [10] => curl [11] => hash [12] => filter [13] => ftp [14] => gettext [15] => json [16] => iconv [17] => SPL [18] => pcntl [19] => readline [20] => Reflection [21] => session [22] => standard [23] => mbstring [24] => shmop [25] => SimpleXML [26] => tokenizer [27] => xml [28] => litespeed [29] => i360 [30] => bcmath [31] => dom [32] => fileinfo [33] => gd [34] => imagick [35] => intl [36] => exif [37] => mysqlnd [38] => mysqli [39] => PDO [40] => pdo_mysql [41] => pdo_sqlite [42] => Phar [43] => posix [44] => soap [45] => sockets [46] => sodium [47] => xmlreader [48] => xmlwriter [49] => xsl [50] => zip )