File Manager - BorneoXploit

← Back

Editing: OptionsTrait.php

<?php

namespace App\Repository;

use App\Entity\Adresse;
use App\Session\Filter\Role\OrganizationSessionFilters;
use App\Session\Filter\Role\SupervisorSessionFilters;
use App\Session\Filter\SessionFiltersContainer;
use Doctrine\ORM\Query\Expr\Join;
use Doctrine\ORM\QueryBuilder;
use Symfony\Contracts\Service\Attribute\Required;

trait OptionsTrait
{
    private ?SessionFiltersContainer $sessionFiltersContainer;

#[Required]
    public function setSessionFiltersContainer(SessionFiltersContainer $sessionFiltersContainer): void
    {
        $this->sessionFiltersContainer = $sessionFiltersContainer;
    }

private function addOptions(QueryBuilder $qb, bool $previous = false, array $forceOptions = []): QueryBuilder
    {
        $prevStartDate = $prevEndDate = null;

if (isset($forceOptions['limit'])) {
            $qb->setMaxResults($forceOptions['limit']);
            unset($forceOptions['limit']);
        }

if (isset($forceOptions['sort'])) {
            $order = $forceOptions['sort'][1] ?? 'asc';
            $qb->orderBy($forceOptions['sort'][0], $order);
            unset($forceOptions['sort']);
        }

$filters = $this->sessionFiltersContainer->clone();

$filters->override($forceOptions);

if (null !== $filters->getDateRange()) {
            [$prevStartDate, $prevEndDate] = $this->getPrevDateRangeFromDate(
                $filters->getDateRange()->getDateStart(),
                $filters->getDateRange()->getDateEnd()
            );
        }

if (false === $previous && null !== $filters->getDateRange()?->getDateStart() && !$qb->getParameter(
            'dateStart'
        )) {
            $qb->andWhere('c.dateRealisation >= :dateStart')
                ->setParameter('dateStart', $filters->getDateRange()->getDateStart());
        }

if (false === $previous && null !== $filters->getDateRange()?->getDateEnd() && !$qb->getParameter('dateEnd')) {
            $qb->andWhere('c.dateRealisation < :dateEnd')
                ->setParameter('dateEnd', $filters->getDateRange()->getDateEnd());
        }

if (true === $previous && null !== $prevStartDate && !$qb->getParameter('dateStart')) {
            $qb->andWhere('c.dateRealisation >= :dateStart')
                ->setParameter('dateStart', $prevStartDate);
        }

if (true === $previous && null !== $prevEndDate && !$qb->getParameter('dateEnd')) {
            $qb->andWhere('c.dateRealisation < :dateEnd')
                ->setParameter('dateEnd', $prevEndDate);
        }

if (null !== $filters->getSolution() && !$qb->getParameter('solution')) {
            $qb->andWhere('c.solution = :solution')
                ->setParameter('solution', $filters->getSolution());
        }

if ($filters instanceof SupervisorSessionFilters) {
            $this->addSupervisorOptions($qb, $filters);
        }

if ($filters instanceof OrganizationSessionFilters) {
            $this->addOrganizationOptions($qb, $filters);
        }

return $qb;
    }

private function addSupervisorOptions(QueryBuilder $qb, SupervisorSessionFilters $filters): void
    {
        if (null !== $filters->getCity()) {
            $qb->andWhere('a.ville LIKE :city')
                ->setParameter('city', $filters->getCity());
        }

if (null !== $filters->getSector()) {
            $qb
                ->andWhere('a.manager = :sector')
                ->setParameter('sector', $filters->getSector());
        }

if (null !== $filters->getProvider()) {
            $aliases = $qb->getAllAliases();

if (!in_array('p', $aliases)) {
                $qb->leftJoin('a.prestataires', 'p');
            }

$qb
                ->andWhere('p.id IN (:providers)')
                ->setParameter('providers', [$filters->getProvider()->getId()]);
        }

if (null !== $filters->getAddress()) {
            if ($filters->getAddress() instanceof Adresse) {
                $qb->andWhere('a = :address')
                    ->setParameter('address', $filters->getAddress());
            } else {
                $qb->andWhere('CONCAT(a.numero,  \' \', a.voie) LIKE :address')
                    ->setParameter('address', $filters->getAddress());
            }
        }

if (null !== $filters->getElevator()) {
            $qb->andWhere('a.numeroAscenseur LIKE :elevator')
                ->setParameter('elevator', $filters->getElevator());
        }

if (null !== $filters->getAgent()) {
            $aliases = $qb->getAllAliases();

if (!in_array('ag', $aliases)) {
                $qb
                    ->leftJoin('c.agent', 'ag');
            }

$qb
                ->andWhere('ag.id = :agent')
                ->setParameter('agent', $filters->getAgent());
        }
    }

private function addOrganizationOptions(QueryBuilder $qb, OrganizationSessionFilters $filters): void
    {
        // OrganizationSessionFilters extends SupervisorSessionFilters, so apply those filters too
        $this->addSupervisorOptions($qb, $filters);

if (null !== $filters->getAgency()) {
            $qb->andWhere('a.agency IN (:agency)')
                ->setParameter('agency', $filters->getAgency()->getId());
        }
    }

private function leftJoinControlsWithOptions(QueryBuilder $qb, string $alias, ?bool $previous = false): QueryBuilder
    {
        $filters = $this->sessionFiltersContainer->getCurrent();

$dateControlsCondition = $qb->expr()->andX(
            $qb->expr()->gte('c.dateRealisation', ':dateStart'),
            $qb->expr()->lte('c.dateRealisation', ':dateEnd'),
        );

$solutionCondition = $qb->expr()->andX(
            $qb->expr()->eq('c.solution', ':solution'),
            $dateControlsCondition
        );

$controlsCondition = $qb->expr()->andX(
            $qb->expr()->eq('c.valide', ':valid'),
            $solutionCondition
        );

$qb
            ->leftJoin($alias, 'c', Join::WITH, $controlsCondition)
            ->setParameter('solution', $filters->getSolution())
            ->setParameter('valid', true);

if (false === $previous) {
            $qb
                ->setParameter('dateStart', $filters->getDateRange()->getDateStart())
                ->setParameter('dateEnd', $filters->getDateRange()->getDateEnd());
        } else {
            $previousDateRange = $this->getPrevDateRangeFromDate(
                $filters->getDateRange()->getDateStart(),
                $filters->getDateRange()->getDateEnd()
            );

$qb
                ->setParameter('dateStart', $previousDateRange[0])
                ->setParameter('dateEnd', $previousDateRange[1]);
        }

return $qb;
    }

/**
     * @return array{\DateTimeInterface, \DateTimeInterface}
     */
    private function getPrevDateRangeFromDate(\DateTimeInterface $startDate, \DateTimeInterface $endDate): array
    {
        $prevStartDate = clone $startDate;
        $prevEndDate = clone $startDate;
        $interval = $startDate->diff($endDate);

return [$prevStartDate->sub($interval), $prevEndDate];
    }
}

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