FM / Cell

/var/www/vhosts/ihelp.ro/httpdocs/src/View/Cell/

/var/www/vhosts/ihelp.ro/httpdocs/src/View/Cell

Name	Size	Mode	Actions
Admin/	-	0755	rm
AchievementsCell.php	1422	0644	edit dl rm
AddAddressCell.php	1949	0644	edit dl rm
CountFavoritesCell.php	1596	0644	edit dl rm
CountItemsCartCell.php	1845	0644	edit dl rm
ListCategoriesCell.php	510	0644	edit dl rm
ListCausesCell.php	544	0644	edit dl rm
ListProductsCell.php	3475	0644	edit dl rm

Edit: /var/www/vhosts/ihelp.ro/httpdocs/src/View/Cell/AchievementsCell.php (1422B)

<?php

declare(strict_types=1);

namespace App\View\Cell;

use Cake\View\Cell;

/**
 * Counters cell
 */
class AchievementsCell extends Cell
{
    /**
     * List of valid options that can be passed into this
     * cell's constructor.
     *
     * @var array<string, mixed>
     */
    protected $_validCellOptions = [];

/**
     * Initialization logic run at the end of object construction.
     *
     * @return void
     */
    public function initialize(): void
    {
    }

/**
     * Default display method.
     *
     * @return void
     */
    public function display()
    {
        $queryDonations = $this->fetchTable('Donations')->find()->where(['Donations.is_active' => true]);
        $donations = $queryDonations->select([
            'totalDonations' => $queryDonations->func()->sum('value'),
            'nrDonations' => $queryDonations->func()->count('*'),
        ])->first();

$queryUsers = $this->fetchTable('Users')->find()->where(['Users.is_active' => true]);
        $donors = $queryDonations->select([
            'nrDonors' => $queryUsers->func()->count('*'),
        ])->first();

$queryCauses = $this->fetchTable('Causes')->find()->where(['Causes.is_active' => true]);
        $causes = $queryCauses->select([
            'organizations' => $queryCauses->func()->count('*'),
        ])->first();

$this->set(compact('donations', 'donors', 'causes'));
    }
}

*/ protected $_validCellOptions = []; /** * Initialization logic run at the end of object construction. * * @return void */ public function initialize(): void { } /** * Default display method. * * @return void */ public function display() { $queryDonations = $this->fetchTable('Donations')->find()->where(['Donations.is_active' => true]); $donations = $queryDonations->select([ 'totalDonations' => $queryDonations->func()->sum('value'), 'nrDonations' => $queryDonations->func()->count('*'), ])->first(); $queryUsers = $this->fetchTable('Users')->find()->where(['Users.is_active' => true]); $donors = $queryDonations->select([ 'nrDonors' => $queryUsers->func()->count('*'), ])->first(); $queryCauses = $this->fetchTable('Causes')->find()->where(['Causes.is_active' => true]); $causes = $queryCauses->select([ 'organizations' => $queryCauses->func()->count('*'), ])->first(); $this->set(compact('donations', 'donors', 'causes')); } }