File Manager - BorneoXploit

← Back

Editing: AgencyImportMapper.php

<?php

namespace App\Import;

use App\Entity\AgencyPrestataire;
use App\Service\SolutionService;
use Doctrine\ORM\EntityManagerInterface;
use Doctrine\ORM\NonUniqueResultException;
use Doctrine\ORM\NoResultException;

class AgencyImportMapper
{
    public function __construct(
        private readonly EntityManagerInterface $entityManager,
        private readonly SolutionService $solutionService
    ) {
    }

/**
     * @param class-string $modelClass
     */
    public function __invoke(string $modelClass, array $values): object
    {
        $uniqueKeys = ExcelMapping::UNIQUE[$modelClass];
        $params = [];

$this->transformValues($modelClass, $values);

try {
            $qb = $this->entityManager->getRepository($modelClass)
                ->createQueryBuilder('obj');

foreach ($uniqueKeys as $uniqueKey) {
                if ('NULL' === gettype($values[$uniqueKey])) {
                    $qb->andWhere('obj.'.$uniqueKey.' IS NULL');
                } else {
                    $operand = $this->getOperand($values[$uniqueKey]);
                    $qb->andWhere('obj.'.$uniqueKey.' '.$operand.' :'.$uniqueKey);
                    $params[$uniqueKey] = trim($values[$uniqueKey]);
                }
            }

/* Handle solution */
            if (method_exists(new $modelClass(), 'getSolution')) {
                $params['solution'] = $this->solutionService->getCurrent();
                $qb->andWhere('obj.solution = :solution');
            }

$qb->setParameters($params);

return $qb->getQuery()->getSingleResult();
        } catch (NoResultException|NonUniqueResultException $e) {
            return new $modelClass();
        }
    }

private function transformValues(string $modelClass, array &$values): void
    {
        match ($modelClass) {
            AgencyPrestataire::class => $this->transformAgencyProviderValues($values),
            default => ''
        };
    }

private function getOperand($var): string
    {
        switch (gettype($var)) {
            case 'NULL':
                $operand = 'IS';
                break;
            case 'string':
                $operand = 'LIKE';
                break;
            default:
                $operand = '=';
                break;
        }

return $operand;
    }

private function transformAgencyProviderValues(array &$values): void
    {
        $emailContact = $values['mailContact'];
        $emailContacts = explode(';', $emailContact);

$values['mailContact'] = $emailContacts[0];
    }
}

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