File Manager - BorneoXploit

← Back

Editing: ReportRepository.php

<?php

declare(strict_types=1);

namespace App\Repository;

use App\Entity\Report;
use App\Entity\ReportItem;
use App\Entity\User;
use App\Enum\ReportStatusType;
use App\Enum\ReportType;
use App\Service\SolutionService;
use App\Service\Utils;
use App\Session\Filter\Role\SupervisorSessionFilters;
use App\Session\Filter\SessionFiltersContainer;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\ORM\QueryBuilder;
use Doctrine\Persistence\ManagerRegistry;
use Symfony\Component\Form\FormInterface;
use Symfony\Component\Security\Core\User\UserInterface;

/**
 * @extends ServiceEntityRepository<Report>
 *
 * @method Report|null find($id, $lockMode = null, $lockVersion = null)
 * @method Report|null findOneBy(array $criteria, array $orderBy = null)
 * @method Report[]    findAll()
 * @method Report[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
 */
class ReportRepository extends ServiceEntityRepository
{
    public function __construct(
        ManagerRegistry $registry,
        private readonly SolutionService $solution,
        private readonly SessionFiltersContainer $sessionFiltersContainer
    ) {
        parent::__construct($registry, Report::class);
    }

public function save(Report $entity, bool $flush = false): void
    {
        $this->getEntityManager()->persist($entity);

if ($flush) {
            $this->getEntityManager()->flush();
        }
    }

public function remove(Report $entity, bool $flush = false): void
    {
        $this->getEntityManager()->remove($entity);

if ($flush) {
            $this->getEntityManager()->flush();
        }
    }

public function getReportsQueryBuilder(
        ?UserInterface $manager = null,
        ?FormInterface $filters = null,
        $type = ReportType::WRECK,
        array $agenciesId = []
    ): QueryBuilder {
        $qb = $this->createQueryBuilder('r')
            ->leftJoin('r.agent', 'a')
            ->innerJoin('a.solutions', 's');

if ($manager) {
            $qb->andWhere('r.manager = :manager')
                ->setParameter('manager', $manager);
        }

$qb->andWhere('r.type = :type')
            ->setParameter('type', $type);

$qb->andWhere('s = :solution')
            ->setParameter('solution', $this->solution->getCurrent())
            ->orderBy('r.createdAt', 'desc');

$this->filterReports($qb, $filters);

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

return $qb;
    }

public function getReportsForCart(?UserInterface $user): array
    {
        $qb = $this->createQueryBuilder('r')
            ->leftJoin('r.agent', 'a');

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

if (in_array('ROLE_SUPERVISOR', $user->getRoles())) {
            $qb->andWhere('a.agency = :agency')
                ->setParameter('agency', $user->getAgency());
        }

$qb->andWhere('r.status != :status')
            ->setParameter('status', ReportStatusType::REPORT_STATUS_CLOSED)
            ->orderBy('r.createdAt', 'desc');

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

public function getReportsForChart(?UserInterface $user, ?ReportType $reportType): array
    {
        $qb = $this->createQueryBuilder('r')
            ->select('ri.id, count(ri.id) as number, ri.label')
            ->leftJoin('r.agent', 'a')
            ->leftJoin('r.reportItem', 'ri');

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

if (in_array('ROLE_SUPERVISOR', $user->getRoles())) {
            $qb->andWhere('a.agency = :agency')
                ->setParameter('agency', $user->getAgency());
        }

if (null !== $reportType) {
            $qb->andWhere('r.type = :reportType')
                ->setParameter('reportType', $reportType);
        }

$qb->groupBy('ri.id');

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

public function countByMonth(
        ReportType $reportType,
        ?FormInterface $filter = null,
        bool $previous = false,
        ?ReportItem $parent = null,
        ?User $manager = null,
        ?User $supervisor = null
    ): array {
        $qb = $this->createQueryBuilder('r')
            ->select('COUNT(r.id) as cnt')
            ->addSelect('DATE_FORMAT(r.createdAt, \'%Y-%m\') as month')
            ->andWhere('r.type = :type')
            ->setParameter('type', $reportType)
            ->groupBy('month');

if (null !== $filter) {
            $this->filterReports($qb, $filter, $previous);
        }

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

if (null !== $supervisor) {
            $qb->andWhere('r.manager IN (:managers)')
                ->setParameter('managers', $supervisor->getAgency()->getManagers());
        }

if (null !== $parent) {
            $qb->leftJoin('r.reportItem', 'ri')
                ->andWhere($qb->expr()->orX('ri.parent = :parent', 'ri = :parent'))
                ->setParameter('parent', $parent);
        }

$utils = new Utils();
        $results = $qb->getQuery()->getResult();

$timeline = $utils->getMonthsTimeline(
            startDate: $this->sessionFiltersContainer->getCurrent()->getDateRange()->getDateStart(),
            endDate: $this->sessionFiltersContainer->getCurrent()->getDateRange()->getDateEnd(),
            format: 'Y-MM'
        );

$data = [];

foreach ($timeline as $monthKey => $month) {
            $cnt = array_reduce(
                $results,
                fn (int $carry, $result) => $result['month'] === $monthKey ? $result['cnt'] : $carry,
                0
            );

$data[$monthKey] = $cnt;
        }

return $data;
    }

public function countByMonthByAgencies(
        ReportType $reportType,
        ?FormInterface $filter = null,
        array $agenciesId = [],
        bool $previous = false,
        ?ReportItem $parent = null
    ): array {
        $qb = $this->createQueryBuilder('r')
            ->select('COUNT(r.id) as cnt')
            ->addSelect('DATE_FORMAT(r.createdAt, \'%Y-%m\') as month')
            ->leftJoin('r.agent', 'a')
            ->andWhere('r.type = :type')
            ->setParameter('type', $reportType)
            ->groupBy('month');

if (null !== $filter) {
            $this->filterReports($qb, $filter, $previous);
        }

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

$utils = new Utils();
        $results = $qb->getQuery()->getResult();

$data = [];

$data[$monthKey] = $cnt;
        }

return $data;
    }

public function filterReports(QueryBuilder $qb, ?FormInterface $filters, bool $previous = false): void
    {
        $sessionFilters = $this->sessionFiltersContainer->getCurrent();

if ($sessionFilters->getDateRange()) {
            $from = clone $sessionFilters->getDateRange()->getDateStart();
            $to = clone $sessionFilters->getDateRange()->getDateEnd();
            $to->add(new \DateInterval('P1D'));

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

// Apply session filters (from header filter form)
        if ($sessionFilters instanceof SupervisorSessionFilters) {
            $this->applySessionFilters($qb, $sessionFilters);
        }

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

if ($data['location']) {
                $qb->andWhere('r.location LIKE :location')
                    ->setParameter('location', '%'.$data['location'].'%');
            }

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

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

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

private function applySessionFilters(QueryBuilder $qb, SupervisorSessionFilters $sessionFilters): void
    {
        // Filter by agent from session
        if (null !== $sessionFilters->getAgent()) {
            $qb->andWhere('r.agent = :sessionAgent')
                ->setParameter('sessionAgent', $sessionFilters->getAgent());
        }

// Filter by sector (manager of the agent)
        if (null !== $sessionFilters->getSector()) {
            // Ensure 'a' alias exists for agent
            $aliases = $qb->getAllAliases();
            if (!in_array('a', $aliases)) {
                $qb->leftJoin('r.agent', 'a');
            }

$qb->andWhere('a.manager = :sector')
                ->setParameter('sector', $sessionFilters->getSector());
        }

// Filter by city (search in location text)
        if (null !== $sessionFilters->getCity()) {
            $qb->andWhere('r.location LIKE :sessionCity')
                ->setParameter('sessionCity', '%'.$sessionFilters->getCity().'%');
        }

// Filter by provider - find reports from agents who work on addresses with this provider
        if (null !== $sessionFilters->getProvider()) {
            $aliases = $qb->getAllAliases();
            if (!in_array('a', $aliases)) {
                $qb->leftJoin('r.agent', 'a');
            }

$qb->leftJoin('a.userAddresses', 'ua')
                ->leftJoin('ua.address', 'addr')
                ->leftJoin('addr.prestataires', 'p')
                ->andWhere('p.id = :providerId')
                ->setParameter('providerId', $sessionFilters->getProvider()->getId());
        }

// Filter by address - find reports from agents assigned to this address
        if (null !== $sessionFilters->getAddress()) {
            $aliases = $qb->getAllAliases();
            if (!in_array('a', $aliases)) {
                $qb->leftJoin('r.agent', 'a');
            }
            if (!in_array('ua', $aliases)) {
                $qb->leftJoin('a.userAddresses', 'ua');
            }

$qb->andWhere('ua.address = :sessionAddress')
                ->setParameter('sessionAddress', $sessionFilters->getAddress());
        }
    }
}

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