File Manager - BorneoXploit

← Back

Editing: AgencyExport.php

<?php

namespace App\Import;

use App\Entity\Agency;
use App\Entity\User;
use Doctrine\Common\Collections\Collection;
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Exception;
use Symfony\Component\HttpKernel\KernelInterface;

class AgencyExport
{
    private Spreadsheet $spreadsheet;

private string $cacheDir;

private Agency $agency;

/** @var Collection<int, User> */
    private Collection $managers;

/** @var Collection<int, User> */
    private Collection $agents;

public function __construct(KernelInterface $kernel)
    {
        $this->spreadsheet = IOFactory::load($kernel->getProjectDir().'/data/import.xlsx');
        $this->cacheDir = $kernel->getCacheDir();
    }

public function setAgency(Agency $agency): void
    {
        $this->agency = $agency;
        $this->fillManagers($this->agency->getUsers());
        $this->fillAgents($this->agency->getUsers());
    }

/**
     * @param Collection<int, User> $users
     */
    private function fillManagers(Collection $users): void
    {
        $this->managers = $users->filter(
            function ($user) {
                return in_array('ROLE_MANAGER', $user->getRoles());
            }
        );
    }

/**
     * @param Collection<int, User> $users
     */
    private function fillAgents(Collection $users): void
    {
        $this->agents = $users->filter(
            function ($user) {
                return in_array('ROLE_AGENT', $user->getRoles());
            }
        );
    }

/**
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     */
    public function run(): void
    {
        $this->fillAgencySheet();
        $this->fillManagers($this->agency->getUsers());
        $this->fillAgents($this->agency->getUsers());

$this->fillAgentSheet();
        $this->fillManagerSheet();
        $this->fillAddressesSheet();
        $this->fillPrestaSheet();
        $this->fillAffectationsSheet();
    }

/**
     * @throws Exception
     */
    public function export(): string
    {
        $writer = IOFactory::createWriter($this->spreadsheet, 'Xlsx');

$tmpName = uniqid().'.xlsx';
        $fullPath = $this->cacheDir.$tmpName;
        $writer->save($fullPath);

return $fullPath;
    }

/**
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     */
    private function fillAgencySheet(): void
    {
        $this->spreadsheet->setActiveSheetIndex(0);
        $currentLine = 2;
        $colOffset = 2;

for ($i = $colOffset; $i < (count(ExcelMapping::AGENCY) + $colOffset); ++$i) {
            $key = ExcelMapping::AGENCY[$i - $colOffset];
            $val = $this->getValueFromObjectAndKey($this->agency, $key);
            $this->spreadsheet->getActiveSheet()->setCellValueByColumnAndRow($i, $currentLine, $val);
        }
    }

/**
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     */
    private function fillAddressesSheet(): void
    {
        $this->spreadsheet->setActiveSheetIndex(2);
        $currentLine = 2;
        $colOffset = 2;

foreach ($this->agency->getAdresses() as $adresse) {
            for ($i = $colOffset; $i < (count(ExcelMapping::ADDRESSES) + $colOffset); ++$i) {
                $key = ExcelMapping::ADDRESSES[$i - $colOffset];
                $val = $this->getValueFromObjectAndKey($adresse, $key);
                $this->spreadsheet->getActiveSheet()->setCellValueByColumnAndRow($i, $currentLine, $val);
            }
            ++$currentLine;
        }
    }

/**
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     */
    private function fillPrestaSheet(): void
    {
        $this->spreadsheet->setActiveSheetIndex(4);
        $currentLine = 2;
        $colOffset = 2;

foreach ($this->agency->getPrestas() as $agencyPrestataire) {
            $presta = $agencyPrestataire->getPrestataire();
            for ($i = $colOffset; $i < (count(ExcelMapping::PRESTAS) + $colOffset); ++$i) {
                $key = ExcelMapping::PRESTAS[$i - $colOffset];
                $val = $this->getValueFromObjectAndKey($presta, $key);
                $this->spreadsheet->getActiveSheet()->setCellValueByColumnAndRow($i, $currentLine, $val);
            }
            ++$currentLine;
        }
    }

/**
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     */
    private function fillManagerSheet(): void
    {
        $this->spreadsheet->setActiveSheetIndex(1);
        $lineOffset = 2;
        $colOffset = 2;

foreach ($this->managers as $manager) {
            for ($i = $colOffset; $i < (count(ExcelMapping::MANAGERS) + $colOffset); ++$i) {
                $key = ExcelMapping::MANAGERS[$i - $colOffset];
                $val = $this->getValueFromObjectAndKey($manager, $key);
                $this->spreadsheet->getActiveSheet()->setCellValueByColumnAndRow($i, $lineOffset, $val);
            }
            ++$lineOffset;
        }
    }

/**
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     */
    private function fillAgentSheet(): void
    {
        $this->spreadsheet->setActiveSheetIndex(3);
        $lineOffset = 2;
        $colOffset = 2;

foreach ($this->agents as $agent) {
            for ($i = $colOffset; $i < (count(ExcelMapping::AGENTS) + $colOffset); ++$i) {
                $key = ExcelMapping::AGENTS[$i - $colOffset];
                $val = $this->getValueFromObjectAndKey($agent, $key);
                $this->spreadsheet->getActiveSheet()->setCellValueByColumnAndRow($i, $lineOffset, $val);
            }
            ++$lineOffset;
        }
    }

/**
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     */
    private function fillAffectationsSheet(): void
    {
        $this->spreadsheet->setActiveSheetIndex(5);
        $lineOffset = 2;

foreach ($this->agency->getAdresses() as $adresse) {
            $agentCursor = 1;
            foreach ($this->agents as $agent) {
                if ($agent->getId() === $adresse->getUserAddresses()->first()->getUser()->getId()) {
                    $this->spreadsheet->getActiveSheet()->setCellValueByColumnAndRow(
                        3,
                        $lineOffset,
                        'AGENT '.$agentCursor
                    );
                }

++$agentCursor;
            }

$prestaCursor = 1;
            foreach ($this->agency->getPrestas() as $presta) {
                if ($presta->getId() === $adresse->getPrestataires()[0]->getId()) {
                    $this->spreadsheet->getActiveSheet()->setCellValueByColumnAndRow(
                        2,
                        $lineOffset,
                        'PRESTATAIRE '.$prestaCursor
                    );
                }

++$prestaCursor;
            }

++$lineOffset;
        }
    }

private function getValueFromObjectAndKey(object $obj, string $key)
    {
        $method = 'get'.ucfirst($key);

$value = $obj->$method();

if ($value instanceof \DateTimeInterface) {
            $value = $value->format('d/m/Y');
        }

return $value;
    }
}

Cancel

* Plugin Name: All in One SEO * Plugin URI: https://aioseo.com/ * Description: SEO for WordPress. Features like XML Sitemaps, SEO for custom post types, SEO for blogs, business sites, ecommerce sites, and much more. More than 100 million downloads since 2007. * Author: All in One SEO Team * Author URI: https://aioseo.com/ * Version: 4.9.10 * Text Domain: all-in-one-seo-pack * Domain Path: /languages * License: GPL-3.0+ * * All in One SEO is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 2 of the License, or * any later version. * * All in One SEO is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with AIOSEO. If not, see . * * @since 4.0.0 * @author All in One SEO Team * @package AIOSEO\Plugin * @license GPL-3.0+ * @copyright Copyright © 2025, All in One SEO */ // Exit if accessed directly. if ( ! defined( 'ABSPATH' ) ) { exit; } require_once dirname( __FILE__ ) . '/app/init/init.php'; // Check if this plugin should be disabled. if ( aioseoMaybePluginIsDisabled( __FILE__ ) ) { return; } if ( ! defined( 'AIOSEO_PHP_VERSION_DIR' ) ) { define( 'AIOSEO_PHP_VERSION_DIR', basename( dirname( __FILE__ ) ) ); } require_once dirname( __FILE__ ) . '/app/init/notices.php'; require_once dirname( __FILE__ ) . '/app/init/activation.php'; // We require PHP 7.1 or higher for the whole plugin to work. if ( version_compare( PHP_VERSION, '7.1', '<' ) ) { add_action( 'admin_notices', 'aioseo_php_notice' ); // Do not process the plugin code further. return; } // We require WordPress 5.7 or higher for the whole plugin to work. global $wp_version; // phpcs:ignore Squiz.NamingConventions.ValidVariableName if ( version_compare( $wp_version, '5.7', '<' ) ) { // phpcs:ignore Squiz.NamingConventions.ValidVariableName add_action( 'admin_notices', 'aioseo_wordpress_notice' ); // Do not process the plugin code further. return; } if ( ! defined( 'AIOSEO_DIR' ) ) { define( 'AIOSEO_DIR', __DIR__ ); } if ( ! defined( 'AIOSEO_FILE' ) ) { define( 'AIOSEO_FILE', __FILE__ ); } // Don't allow multiple versions to be active. if ( function_exists( 'aioseo' ) ) { add_action( 'activate_all-in-one-seo-pack/all_in_one_seo_pack.php', 'aioseo_lite_just_activated' ); add_action( 'deactivate_all-in-one-seo-pack/all_in_one_seo_pack.php', 'aioseo_lite_just_deactivated' ); add_action( 'activate_all-in-one-seo-pack-pro/all_in_one_seo_pack.php', 'aioseo_pro_just_activated' ); add_action( 'admin_notices', 'aioseo_lite_notice' ); // Do not process the plugin code further. return; } // We will be deprecating these versions of PHP in the future, so we'll let the user know. // We flag deprecated WP versions in the DeprecatedWordPress class. if ( version_compare( PHP_VERSION, '7.4', '<' ) ) { add_action( 'admin_notices', 'aioseo_php_notice_deprecated' ); } // Define the class and the function. // The AIOSEOAbstract class is required here because it can't be autoloaded. require_once dirname( __FILE__ ) . '/app/AIOSEOAbstract.php'; require_once dirname( __FILE__ ) . '/app/AIOSEO.php'; aioseo(); Arithmetic

Caractéristiques générales

Ce que nous proposons

Une application dédiée à l’entretien ménager des parties communes

Une interface agile et intuitive

Une totale maîtrise des informations collectées

Un contenu personnalisable

Une traçabilité maîtrisée

Des reportings réguliers et spécifiques

Dashboard

3 étapes clés pour améliorer la qualité de service :

01

Connectez-vous à l'application en profitant de ses nombreuses fonctionnalités
02
Analysez vos résultats avec une interface web personnalisée
03
Améliorez la propreté des parties communes