File Manager - BorneoXploit

← Back

Editing: ControleRepository.php

<?php

namespace App\Repository;

use App\Entity\Adresse;
use App\Entity\Agency;
use App\Entity\Controle;
use App\Entity\Organization;
use App\Entity\Prestataire;
use App\Service\SolutionService;
use App\Service\Utils;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\Common\Collections\Collection;
use Doctrine\ORM\NonUniqueResultException;
use Doctrine\ORM\NoResultException;
use Doctrine\ORM\QueryBuilder;
use Doctrine\Persistence\ManagerRegistry;
use Symfony\Component\Form\FormInterface;
use Symfony\Component\Security\Core\User\UserInterface;

class ControleRepository extends ServiceEntityRepository
{
    use OptionsTrait;

public function __construct(
        ManagerRegistry $registry,
        private readonly Utils $utils,
        private readonly SolutionService $solution
    ) {
        parent::__construct($registry, Controle::class);
    }

public function getQueryByAgencies(array $agenciesId): QueryBuilder
    {
        $qb = $this->createQueryBuilder('c')
            ->leftJoin('c.adresse', 'a')
            ->where('a.agency IN ('.implode(',', $agenciesId).')')
            ->andWhere('c.valide = :valid')
            ->setParameter('valid', true);

return $this->addOptions($qb);
    }

/**
     * @throws \Exception
     */
    public function getControlesQueryBuilder(UserInterface $manager, ?FormInterface $filters = null): QueryBuilder
    {
        $qb = $this->createQueryBuilder('c');
        $qb
            ->leftJoin('c.agent', 'a')
            ->join('c.adresse', 'ad', 'WITH', 'ad.solution = :solution')
            ->where('c.valide = :valid')
            ->andWhere($qb->expr()->orX('a.manager = :manager', 'c.agent = :manager', 'ad.manager = :manager'))
            ->andWhere('c.solution = :solution')
            ->orderBy('c.dateRealisation', 'desc')
            ->setParameter('valid', true)
            ->setParameter('manager', $manager)
            ->setParameter('solution', $this->solution->getCurrent());

if ($filters && $filters->getData()) {
            $data = $filters->getData();

if ($data['dateRealisation']) {
                $dates = preg_replace(
                    '#^(\d+)/(\d+)/(\d+) - (\d+)/(\d+)/(\d+)$#',
                    '$3-$2-$1 - $6-$5-$4',
                    $data['dateRealisation']
                );
                $dates = explode(' - ', $dates);
                $from = new \DateTime($dates[0]);
                $to = new \DateTime($dates[1]);
                $to->add(new \DateInterval('P1D'));

$qb->andWhere(
                    $qb->expr()->between('c.dateRealisation', ':from', ':to')
                )
                    ->setParameter('from', $from)
                    ->setParameter('to', $to);
            }

if ($data['isContradictory']) {
                $qb->andWhere('c.isContradictory = :isContradictory')
                    ->setParameter('isContradictory', $data['isContradictory']);
            }

if ($data['address']) {
                $qb->andWhere('c.adresse = :address')
                    ->setParameter('address', $data['address']);
            }

if ($data['agent']) {
                $qb->andWhere('c.agent = :agent')
                    ->setParameter('agent', $data['agent']);
            }

if ($data['isTenant']) {
                $qb->andWhere('a.roles LIKE :roleTenant')
                    ->setParameter('roleTenant', '%ROLE_TENANT%');
            }
        }

return $qb;
    }

/**
     * @param int[] $agencies
     */
    public function incidenceByAgenciesByMonth(
        array $agencies = [],
        ?UserInterface $user = null,
        ?Adresse $adresse = null,
        bool $previous = false,
        array $options = []
    ): array {
        $qb = $this->createQueryBuilder('c')
            ->select('COUNT(al.id) / COUNT(c) as incidence')
            ->addSelect('DATE_FORMAT(c.dateRealisation, \'%Y-%m\') as month')
            ->leftJoin('c.adresse', 'a')
            ->leftJoin('c.alertes', 'al')
            ->andWhere('c.valide = :valide')
            ->setParameter('valide', true)
            ->groupBy('month');

if (!empty($agencies)) {
            $qb->andWhere('a.agency IN ('.implode(',', $agencies).')');
        }

if (null !== $adresse) {
            $qb->andWhere('a = :address')
                ->setParameter('address', $adresse);
        }

if ($user && in_array('ROLE_MANAGER', $user->getRoles())) {
            $qb->andWhere('a.manager = :manager');
            $qb->setParameter('manager', $user);
        }

if ($user && in_array('ROLE_AGENT', $user->getRoles())) {
            $qb->andWhere('c.agent = :agent');
            $qb->setParameter('agent', $user);
        }

$qb = $this->addOptions($qb, $previous, $options);

return $qb->getQuery()->getResult();
    }

/**
     * @return array<array-key, array{nbControls: int, month: string, nbAddresses: int}>
     */
    public function countControlesByAgenciesByMonth(
        array $agenciesId,
        bool $groupProvider = true,
        bool $previous = false,
        ?Adresse $address = null,
        array $options = []
    ): array {
        $qb = $this->createQueryBuilder('c')
            ->select('COUNT(c) as nbControls')
            ->addSelect('DATE_FORMAT(c.dateRealisation, \'%Y-%m\') as month')
            ->addSelect('COUNT(DISTINCT(a)) as nbAddresses')
            ->leftJoin('c.adresse', 'a')
            ->where('a.agency IN ('.implode(',', $agenciesId).')')
            ->andWhere('c.valide = 1')
            ->groupBy('month');

if ($groupProvider) {
            $qb
                ->addSelect('p.id as customId')
                ->addSelect('p.nom as name')
                ->leftJoin('a.prestataires', 'p')
                ->addGroupBy('p');
        }

if ($address instanceof Adresse) {
            $qb
                ->andWhere('c.adresse = :address')
                ->setParameter('address', $address);
        }

$qb = $this->addOptions($qb, $previous, $options);

return $qb->getQuery()->getResult();
    }

public function getSupervisorAverageNoteByAgencyByMonth(
        ?Organization $organization = null,
        ?Agency $agency = null,
        ?Adresse $address = null
    ): array {
        $qb = $this->createQueryBuilder('c')
            ->select('AVG(c.averageNote) as avgNote')
            ->addSelect('DATE_FORMAT(c.dateRealisation, \'%Y-%m\') as month')
            ->join('c.adresse', 'a')
            ->where('c.valide = 1')
            ->orderBy('c.dateRealisation');

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

if (null !== $organization) {
            $qb
                ->join('a.agency', 'ag')
                ->andWhere('ag.organization = :organization')
                ->setParameter('organization', $organization);
        }

if (null !== $address) {
            $qb->andWhere('a = :address')
                ->setParameter('address', $address);
        }

$qb = $this->addOptions($qb);

$qb->groupBy('month');

return $qb
            ->getQuery()
            ->getResult();
    }

public function fetchSupervisorDataByAgencyByMonth(Agency $agency): array
    {
        $qb = $this->createQueryBuilder('c');
        $qb
            ->select('AVG(c.averageNote) as avgNote')
            ->addSelect('COUNT(c) as cntControles')
            ->addSelect('COUNT(al.id) as cntAlertes')
            ->addSelect('DATE_FORMAT(c.dateRealisation, \'%Y-%m\') as month')
            ->join('c.adresse', 'a')
            ->leftJoin('c.alertes', 'al')
            ->where('a.agency = :agency')
            ->andWhere('c.valide = 1')
            ->orderBy('c.dateRealisation')
            ->setParameter('agency', $agency);

$qb = $this->addOptions($qb);

$qb->groupBy('month');

return $qb
            ->getQuery()
            ->getResult();
    }

public function fetchOrganizationDataByAgencyByMonth(array $agenciesId): array
    {
        $qb = $this->createQueryBuilder('c')
            ->select('AVG(c.averageNote) as avgNote')
            ->addSelect('COUNT(c) as cntControles')
            ->addSelect('COUNT(al.id) as cntAlertes')
            ->addSelect('DATE_FORMAT(c.dateRealisation, \'%Y-%m\') as month')
            ->join('c.adresse', 'a')
            ->leftJoin('c.alertes', 'al')
            ->where('a.agency IN ('.implode(',', $agenciesId).')')
            ->andWhere('c.valide = 1')
            ->orderBy('c.dateRealisation');

$qb = $this->addOptions($qb);

$qb->groupBy('month');

return $qb
            ->getQuery()
            ->getResult();
    }

/**
     * @return Controle[]
     */
    public function findPrestaAlerts(Prestataire $prestataire): array
    {
        return $this->createQueryBuilder('c')
            ->leftJoin('c.adresse', 'ad')
            ->leftJoin('c.alertes', 'al')
            ->leftJoin('ad.prestataires', 'p')
            ->andWhere('p = :prestataire')
            ->andWhere('COUNT(c.id) > 0')
            ->andWhere('al.prestataire = :prestataire')
            ->setParameter('prestataire', $prestataire)
            ->getQuery()
            ->getResult();
    }

public function getLastControlDoneByAdresse(Adresse $address): Collection
    {
        return $this->createQueryBuilder('c')
            ->where('c.adresse = :adress')
            ->andWhere('c.dateRealisation is not null')
            ->setParameter('adresse', $address)
            ->orderBy('c.dateRealisation', 'DESC')
            ->setMaxResults(1)
            ->getQuery()
            ->getResult();
    }

public function getControlsByAgenciesByDay(array $agenciesId): array
    {
        $qb = $this->createQueryBuilder('c')
            ->select('COUNT(c.id) as cnt')
            ->addSelect('DAYOFWEEK(c.dateRealisation) as day')
            ->leftJoin('c.adresse', 'a')
            ->where('c.valide = :valid')
            ->andWhere('a.agency IN ('.implode(',', $agenciesId).')')
            ->groupBy('day')
            ->orderBy('WEEKDAY(c.dateRealisation)')
            ->setParameter('valid', true);

$qb = $this->addOptions($qb);

return $qb->getQuery()->getResult();
    }

public function getControlsTimeByAgenciesByMonth(array $agenciesId, bool $previous = false): array
    {
        $qb = $this->createQueryBuilder('c')
            ->select('AVG(TIMEDIFF(c.dateRealisation, c.createdAt)) as doneTime')
            ->addSelect('DATE_FORMAT(c.dateRealisation, \'%Y-%m\') as month')
            ->leftJoin('c.adresse', 'a')
            ->where('a.agency IN ('.implode(',', $agenciesId).')')
            ->andWhere('c.valide = :valid')
            ->groupBy('month')
            ->setParameter('valid', true);

$qb = $this->addOptions($qb, $previous);

return $qb->getQuery()->getResult();
    }

/**
     * @return array<array-key, array{averageNote: float, numero: string, voie: string, codePostal: string, ville: string}>
     */
    public function getAverageNoteByAgencies(array $agenciesId, bool $previous = false, array $options = [])
    {
        $qb = $this->createQueryBuilder('c')
            ->select('AVG(c.averageNote) as averageNote, a.numero, a.voie, a.codePostal, a.ville')
            ->leftJoin('c.adresse', 'a')
            ->where('a.agency IN ('.implode(',', $agenciesId).')')
            ->andWhere('c.averageNote > 0')
            ->groupBy('c.adresse')
            ->orderBy('averageNote', 'ASC')
            ->setMaxResults(5);

$qb = $this->addOptions($qb, $previous, $options);

return $qb->getQuery()->getResult();
    }

/**
     * @return array<array-key, array{averageNote: float, numero: string, voie: string, codePostal: string, ville: string}>
     */
    public function getAverageNoteByManagerOrAgent(UserInterface $user, array $options = []): array
    {
        $qb = $this->createQueryBuilder('c')
            ->select('AVG(c.averageNote) as averageNote, a.numero, a.voie, a.codePostal, a.ville')
            ->leftJoin('c.adresse', 'a');

if (in_array('ROLE_MANAGER', $user->getRoles())) {
            $qb
                ->where('a.manager = :manager')
                ->setParameter('manager', $user);
        }

if (in_array('ROLE_AGENT', $user->getRoles())) {
            $qb
                ->where('c.agent = :agent')
                ->setParameter('agent', $user);
        }

$qb
            ->andWhere('c.averageNote > 0')
            ->groupBy('c.adresse')
            ->orderBy('averageNote', 'ASC')
            ->setMaxResults(5);

$qb = $this->addOptions($qb, false, $options);

return $qb->getQuery()->getResult();
    }

/**
     * @return array<array-key, array{avgNote: float, month: string}>
     */
    public function getAverageNoteByAddress(?Adresse $address = null): array
    {
        $qb = $this->createQueryBuilder('c');
        $qb
            ->select('AVG(c.averageNote) as avgNote')
            ->addSelect('DATE_FORMAT(c.dateRealisation, \'%Y-%m\') as month')
            ->join('c.adresse', 'a')
            ->andWhere('c.valide = 1')
            ->orderBy('c.dateRealisation');

if (null !== $address) {
            $qb->andWhere('a = :address')
                ->setParameter('address', $address);
        }

$qb = $this->addOptions($qb);

$qb->groupBy('month');

return $qb
            ->getQuery()
            ->getResult();
    }

/**
     * @return ?array{avgNote: float}
     *
     * @throws NonUniqueResultException
     */
    public function getTotalAverageNoteByAddress(Adresse $adresse): ?array
    {
        $qb = $this->createQueryBuilder('c');
        $qb
            ->select('AVG(c.averageNote) as avgNote')
            ->join('c.adresse', 'a')
            ->andWhere('c.valide = 1')
            ->andWhere('a = :address')
            ->setParameter('address', $adresse)
            ->orderBy('c.dateRealisation');

$qb = $this->addOptions($qb);

$qb->groupBy('c.adresse');

return $qb
            ->getQuery()
            ->getOneOrNullResult();
    }

/**
     * @throws NoResultException
     * @throws NonUniqueResultException
     * @throws \Exception
     */
    public function averageNoteByManager(
        UserInterface $manager,
        ?Adresse $adresse = null,
        array $options = []
    ) {
        $qb = $this->createQueryBuilder('c')
            ->select('AVG(c.averageNote)')
            ->leftJoin('c.adresse', 'ad')
            ->where('ad.manager = :manager')
            ->andWhere('c.valide = 1')
            ->setParameter('manager', $manager);

if ($adresse) {
            $qb->andWhere('ad = :adresse');
            $qb->setParameter('adresse', $adresse);
        }

$this->addOptions(
            qb: $qb,
            forceOptions: $options
        );

return $qb
            ->getQuery()
            ->getSingleScalarResult();
    }

/**
     * @throws \Exception
     */
    public function averageNoteByAgenciesByMonth(
        array $agenciesId,
        ?Adresse $address = null,
        bool $previous = false,
        array $options = []
    ): array {
        $qb = $this->createQueryBuilder('c')
            ->select('AVG(c.averageNote) as note')
            ->addSelect('DATE_FORMAT(c.dateRealisation, \'%Y-%m\') as month')
            ->leftJoin('c.adresse', 'a')
            ->where('a.agency IN ('.implode(',', $agenciesId).')')
            ->andWhere('c.valide = :valid')
            ->setParameter('valid', true)
            ->groupBy('month');

if (null !== $address) {
            $qb->andWhere('a = :address')
                ->setParameter('address', $address);
        }

$qb = $this->addOptions($qb, $previous, $options);

return $qb
            ->getQuery()
            ->getResult();
    }
}

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