FM / Admin

/var/www/vhosts/ihelp.ro/httpdocs/src/Controller/Admin/

/var/www/vhosts/ihelp.ro/httpdocs/src/Controller/Admin

Name	Size	Mode	Actions
AdminController.php	5772	0644	edit dl rm
BankAccountsController.php	3144	0644	edit dl rm
BannersController.php	4540	0644	edit dl rm
CategoriesController.php	4498	0644	edit dl rm
CauseNewsController.php	2145	0644	edit dl rm
CausesController.php	8759	0644	edit dl rm
CronsController.php	1800	0644	edit dl rm
DashboardController.php	1062	0644	edit dl rm
DocumentsController.php	3649	0644	edit dl rm
DonationsController.php	559	0644	edit dl rm
GalleryImagesController.php	3246	0644	edit dl rm
OrdersController.php	4476	0644	edit dl rm
ProductsController.php	5642	0644	edit dl rm
ProposedCausesController.php	3339	0644	edit dl rm
SettingsController.php	3157	0644	edit dl rm
SponsorsActivitiesController.php	4003	0644	edit dl rm
SponsorsController.php	3647	0644	edit dl rm
TagsController.php	2652	0644	edit dl rm
UsersController.php	8244	0644	edit dl rm

Edit: /var/www/vhosts/ihelp.ro/httpdocs/src/Controller/Admin/CronsController.php (1800B)

<?php

declare(strict_types=1);

namespace App\Controller\Admin;

use App\Controller\AppController;

/**
 * Crons Controller
 */
class CronsController extends AppController
{
    public function exportDonorsSpreadsheet()
    {
        $conditions = [];
        $contain = ['Users', 'Causes', 'Transactions'];
        $dateFrom =   date('Y-m-d', strtotime("-30 day"));
        $dateUntil =   date('Y-m-d', strtotime("-15 day"));

$conditions['AND'][] = ["Donations.created >=" => $dateFrom];
        $conditions['AND'][] = ["Donations.created >=" => $dateUntil];

$data = $this->fetchTable('Donations')->find('all')->contain($contain)->toArray();
        $results = [];
        foreach ($data as $key => $value) {
            $results[] = [
                'id' => $value['id'],
                'f_name' => $value['first_name'],
                'l_name' => $value['last_name'],
                'nickname' => $value['nickname'],
                'email' => $value['email'],
                'value' => $value['value'],
                'transation' => isset($value['transation']) ? $value['transation']['bank_account_id'] : '',
                'cause' => $value['cause']['name'],
                'is_anonymus' => $value['is_anonymus'] ? 'true' : 'false',
                'is_visible' => $value['is_visible'] ? 'true' : 'false',
                'created' => !empty($value['created']) ? $value['created']->i18nFormat('yyyy-MM-dd HH:mm:ss') : '',
            ];
        }

if (empty($results)) {
            $results[] = [
                __('No results found') => ''
            ];
        }

$this->loadComponent('Spreadsheet');
        $this->Spreadsheet->export($results, 'Report', 'Donors', 'AdminCron', 'save', ['dateFrom'=>$dateFrom,'dateUntil'=>$dateUntil]);
    }
}

=" => $dateFrom]; $conditions['AND'][] = ["Donations.created >=" => $dateUntil]; $data = $this->fetchTable('Donations')->find('all')->contain($contain)->toArray(); $results = []; foreach ($data as $key => $value) { $results[] = [ 'id' => $value['id'], 'f_name' => $value['first_name'], 'l_name' => $value['last_name'], 'nickname' => $value['nickname'], 'email' => $value['email'], 'value' => $value['value'], 'transation' => isset($value['transation']) ? $value['transation']['bank_account_id'] : '', 'cause' => $value['cause']['name'], 'is_anonymus' => $value['is_anonymus'] ? 'true' : 'false', 'is_visible' => $value['is_visible'] ? 'true' : 'false', 'created' => !empty($value['created']) ? $value['created']->i18nFormat('yyyy-MM-dd HH:mm:ss') : '', ]; } if (empty($results)) { $results[] = [ __('No results found') => '' ]; } $this->loadComponent('Spreadsheet'); $this->Spreadsheet->export($results, 'Report', 'Donors', 'AdminCron', 'save', ['dateFrom'=>$dateFrom,'dateUntil'=>$dateUntil]); } }