File Manager - BorneoXploit

← Back

Editing: initial.sql

SET NAMES 'utf8';
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET FOREIGN_KEY_CHECKS = 0;
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

INSERT INTO `adresse` (`id`, `client_id`, `agent_id`, `solution_id`, `voie`, `numero`, `repetition`, `code_postal`,
                       `ville`, `batiment`, `residence`, `ascenseur_is_active`, `start_date_inactive`)
VALUES (1, 2, 5, 1, 'rue de ponthieu', '34', NULL, '75008', 'Paris', NULL, NULL, 1, NULL),
       (2, 3, 8, 1, 'rue de Ponthieu', '1', NULL, '75008', 'Paris', '1L', NULL, 0, NULL),
       (3, 3, 8, 1, 'rue de Ponthieu', '2', NULL, '75008', 'Paris', '3Z', NULL, 0, NULL),
       (4, 3, 8, 1, 'rue de Ponthieu', '2', 'bis', '75008', 'Paris', '4D', NULL, 0, NULL),
       (5, 3, 8, 1, 'rue de Ponthieu', '3', NULL, '75008', 'Paris', '8X', NULL, 0, NULL),
       (6, 3, 8, 1, 'rue de Ponthieu', '4', NULL, '75008', 'Paris', '112Z', NULL, 0, NULL),
       (7, 3, 9, 1, 'rue du colonel Outdot', '1', NULL, '75012', 'Paris', '1A', NULL, 0, NULL),
       (8, 3, 9, 1, 'rue du colonel Outdot', '2', NULL, '75012', 'Paris', '1A', NULL, 0, NULL),
       (9, 3, 9, 1, 'rue du colonel Outdot', '3', NULL, '75012', 'Paris', '1A', NULL, 0, NULL),
       (10, 3, 9, 1, 'rue du colonel Outdot', '4', NULL, '75012', 'Paris', '1A', NULL, 0, NULL),
       (11, 3, 9, 1, 'rue du colonel Outdot', '5', NULL, '75012', 'Paris', '1A', NULL, 0, NULL);

INSERT INTO `client` (`id`, `nom`, `email`, `telephone_fixe`, `logo`, `date_debut_contrat`, `date_fin_contrat`,
                      `nombre_licence`, `nom_contact`, `prenom_contact`, `mail_contact`, `telephone_contact`,
                      `photo_obligatoire_contact`)
VALUES (2, 'Test Client', 'contact@numadream.com', '0685222757', NULL, '2020-06-19', '2034-01-01', 1, 'Doe', 'Phil',
        'contact@numadream.com', '0685222757', NULL),
       (3, 'Client Demo', 'demo@arithmetic.fr', '0611223344', NULL, '2020-10-02', '2025-03-31', 1, 'Demo', 'Richard',
        'demo@arithmetic.fr', '0611223344', NULL);

INSERT INTO `client_solution` (`client_id`, `solution_id`)
VALUES (2, 1),
       (3, 1);

INSERT INTO `solution` (`id`, `name`, `slug`, `email`, `domain`, `app_store_url`, `play_store_url`, `color`)
VALUES (1, 'Clean Manager', 'clean-manager', 'postmaster@mg.numadream.com', 'clean-manager.localhost',
        'https://apps.apple.com/fr/app/cleanmanager/id1522153602',
        'https://play.google.com/store/apps/details?id=com.arithmetic.cleanmanager', '#4fd1da'),
       (2, 'Lift Manager', 'lift-manager', 'postmaster@mg.numadream.com', 'lift-manager.localhost',
        'https://apps.apple.com/fr/app/lift=manager/id1522153602',
        'https://play.google.com/store/apps/details?id=com.arithmetic.liftmanager', '#717aba');

INSERT INTO `tl_adresse_item` (`adresse_id`, `item_id`)
VALUES (1, 1),
       (1, 2),
       (1, 3),
       (1, 4),
       (1, 5),
       (1, 6),
       (1, 7),
       (1, 8),
       (1, 9),
       (1, 10),
       (1, 11),
       (1, 12),
       (1, 13),
       (1, 14),
       (1, 15),
       (1, 16),
       (1, 17),
       (1, 18),
       (1, 19),
       (1, 20),
       (1, 21),
       (1, 22),
       (1, 23),
       (1, 24),
       (1, 25),
       (1, 26),
       (1, 27),
       (1, 28),
       (2, 1),
       (2, 2),
       (2, 3),
       (2, 4),
       (2, 5),
       (2, 6),
       (2, 7),
       (2, 8),
       (2, 9),
       (2, 10),
       (2, 11),
       (2, 12),
       (2, 13),
       (2, 14),
       (2, 15),
       (2, 16),
       (2, 17),
       (2, 18),
       (2, 19),
       (2, 20),
       (2, 21),
       (2, 22),
       (2, 23),
       (2, 24),
       (2, 25),
       (2, 26),
       (2, 27),
       (2, 28),
       (3, 1),
       (3, 2),
       (3, 3),
       (3, 4),
       (3, 5),
       (3, 6),
       (3, 7),
       (3, 8),
       (3, 9),
       (3, 10),
       (3, 11),
       (3, 12),
       (3, 13),
       (3, 14),
       (3, 15),
       (3, 16),
       (3, 17),
       (3, 18),
       (3, 19),
       (3, 20),
       (3, 21),
       (3, 22),
       (3, 23),
       (3, 24),
       (3, 25),
       (3, 26),
       (3, 27),
       (3, 28),
       (4, 1),
       (4, 2),
       (4, 3),
       (4, 4),
       (4, 5),
       (4, 6),
       (4, 7),
       (4, 8),
       (4, 9),
       (4, 10),
       (4, 11),
       (4, 12),
       (4, 13),
       (4, 14),
       (4, 15),
       (4, 16),
       (4, 17),
       (4, 18),
       (4, 19),
       (4, 20),
       (4, 21),
       (4, 22),
       (4, 23),
       (4, 24),
       (4, 25),
       (4, 26),
       (4, 27),
       (4, 28),
       (5, 1),
       (5, 2),
       (5, 3),
       (5, 4),
       (5, 5),
       (5, 6),
       (5, 7),
       (5, 8),
       (5, 9),
       (5, 10),
       (5, 11),
       (5, 12),
       (5, 13),
       (5, 14),
       (5, 15),
       (5, 16),
       (5, 17),
       (5, 18),
       (5, 19),
       (5, 20),
       (5, 21),
       (5, 22),
       (5, 23),
       (5, 24),
       (5, 25),
       (5, 26),
       (5, 27),
       (5, 28),
       (6, 1),
       (6, 2),
       (6, 3),
       (6, 4),
       (6, 5),
       (6, 6),
       (6, 7),
       (6, 8),
       (6, 9),
       (6, 10),
       (6, 11),
       (6, 12),
       (6, 13),
       (6, 14),
       (6, 15),
       (6, 16),
       (6, 17),
       (6, 18),
       (6, 19),
       (6, 20),
       (6, 21),
       (6, 22),
       (6, 23),
       (6, 24),
       (6, 25),
       (6, 26),
       (6, 27),
       (6, 28),
       (7, 1),
       (7, 2),
       (7, 3),
       (7, 4),
       (7, 5),
       (7, 6),
       (7, 7),
       (7, 8),
       (7, 9),
       (7, 10),
       (7, 11),
       (7, 12),
       (7, 13),
       (7, 14),
       (7, 15),
       (7, 16),
       (7, 17),
       (7, 18),
       (7, 19),
       (7, 20),
       (7, 21),
       (7, 22),
       (7, 23),
       (7, 24),
       (7, 25),
       (7, 26),
       (7, 27),
       (7, 28),
       (8, 1),
       (8, 2),
       (8, 3),
       (8, 4),
       (8, 5),
       (8, 6),
       (8, 7),
       (8, 8),
       (8, 9),
       (8, 10),
       (8, 11),
       (8, 12),
       (8, 13),
       (8, 14),
       (8, 15),
       (8, 16),
       (8, 17),
       (8, 18),
       (8, 19),
       (8, 20),
       (8, 21),
       (8, 22),
       (8, 23),
       (8, 24),
       (8, 25),
       (8, 26),
       (8, 27),
       (8, 28),
       (9, 1),
       (9, 2),
       (9, 3),
       (9, 4),
       (9, 5),
       (9, 6),
       (9, 7),
       (9, 8),
       (9, 9),
       (9, 10),
       (9, 11),
       (9, 12),
       (9, 13),
       (9, 14),
       (9, 15),
       (9, 16),
       (9, 17),
       (9, 18),
       (9, 19),
       (9, 20),
       (9, 21),
       (9, 22),
       (9, 23),
       (9, 24),
       (9, 25),
       (9, 26),
       (9, 27),
       (9, 28),
       (10, 1),
       (10, 2),
       (10, 3),
       (10, 4),
       (10, 5),
       (10, 6),
       (10, 7),
       (10, 8),
       (10, 9),
       (10, 10),
       (10, 11),
       (10, 12),
       (10, 13),
       (10, 14),
       (10, 15),
       (10, 16),
       (10, 17),
       (10, 18),
       (10, 19),
       (10, 20),
       (10, 21),
       (10, 22),
       (10, 23),
       (10, 24),
       (10, 25),
       (10, 26),
       (10, 27),
       (10, 28),
       (11, 1),
       (11, 2),
       (11, 3),
       (11, 4),
       (11, 5),
       (11, 6),
       (11, 7),
       (11, 8),
       (11, 9),
       (11, 10),
       (11, 11),
       (11, 12),
       (11, 13),
       (11, 14),
       (11, 15),
       (11, 16),
       (11, 17),
       (11, 18),
       (11, 19),
       (11, 20),
       (11, 21),
       (11, 22),
       (11, 23),
       (11, 24),
       (11, 25),
       (11, 26),
       (11, 27),
       (11, 28);

INSERT INTO `tl_adresse_prestataire` (`adresse_id`, `prestataire_id`)
VALUES (1, 1),
       (2, 2),
       (3, 2),
       (4, 2),
       (5, 2),
       (6, 2),
       (7, 2),
       (8, 2),
       (9, 2),
       (10, 2),
       (11, 2);

INSERT INTO `tl_client_prestataire` (`id`, `prestataire_id`, `client_id`, `prenom_contact`, `nom_contact`,
                                     `mail_contact`, `telephone`, `numero_contrat`)
VALUES (1, 1, 2, NULL, NULL, NULL, NULL, NULL),
       (2, 2, 3, 'Demo', 'Presta', 'manager@clean-manager.com', '699887766', '234K');

INSERT INTO `tr_item` (`id`, `zone_id`, `nom`)
VALUES (1, 1, 'Les abords immédiats'),
       (2, 1, 'Interphone'),
       (3, 1, 'Les vitres'),
       (4, 1, 'Les boites aux lettres'),
       (5, 1, 'Les sols'),
       (6, 1, 'Les murs, plinthes et interrupteurs'),
       (7, 1, 'Le vidage des corbeilles'),
       (8, 1, 'Cabine(s)  ascenseur(s)'),
       (9, 2, 'Les sols'),
       (10, 2, 'Les murs, plinthes et interrupteurs'),
       (11, 3, 'Les sols'),
       (12, 3, 'Les murs, plinthes, interrupteurs et gardes corps'),
       (13, 4, 'Le local OM'),
       (14, 4, 'Local encombrant'),
       (15, 5, 'Contrôle d\'accès'),
       (16, 5, 'Portillon'),
       (17, 5, 'Portail véhicules'),
       (18, 5, 'Eclairage de secours'),
       (19, 5, 'Trappes d\'extraction'),
       (20, 5, 'Colonne sèche'),
       (21, 5, 'Echelle'),
       (22, 5, 'Affichage Réglementaire'),
       (23, 5, 'Tableau affichage'),
       (24, 6, 'Eclairage du hall'),
       (25, 6, 'Eclairage des paliers'),
       (26, 6, 'Eclairage des escaliers'),
       (27, 6, 'Eclairage de l\'ascenseur'),
       (28, 6, 'Eclairage des autres locaux'),
       (29, 7, 'Verrouillage sécurisé des portes'),
       (30, 7, 'Alignement cabine avec le palier'),
       (31, 7, 'Etat du bouton d\'appels exterieur'),
       (32, 7, 'Affichage extérieur des niveaux'),
       (33, 7, 'Présence de bruit inhabituel'),
       (34, 7, 'Etat des boutons d\'appels intérieurs de la cabine'),
       (35, 7, 'Etat de l\'éclairage de la cabine'),
       (36, 7, 'Etat des vitreries'),
       (37, 7, 'Affichage du numéro d\urgence'),
       (38, 7, 'Affichage réglementaire'),
       (39, 7, 'Test de la télésurveillance');

--
-- Déchargement des données de la table `tr_periode`
--

INSERT INTO `tr_periode` (`id`, `nom`, `active`)
VALUES (1, 'JOUR', 0),
       (2, 'SEMAINE', 1),
       (3, 'MOIS', 1),
       (4, 'ANNEE', 0);

INSERT INTO `tr_prestataire` (`id`, `solution_id`, `nom`, `short_desc`)
VALUES (1, 1, 'Presta', 'Lorem ipsum dolor si amet'),
       (2, 1, 'Demo Presta', 'Ceci est un préstataire de démonstration');

INSERT INTO `tr_zone` (`id`, `nom`, `solution_id`)
VALUES (1, 'PROPRETE - HALL', 1),
       (2, 'PROPRETE - PALIER', 1),
       (3, 'PROPRETE - ESCALIER', 1),
       (4, 'PROPRETE - AUTRES LOCAUX', 1),
       (5, 'CONTROLES D\'ACCES ET SECURITE INCENDIE', 1),
       (6, 'INFORMATION ET ECLAIRAGE', 1),
       (7, 'CONTRÔLES PREVENTIFS', 2);

INSERT INTO `user` (`id`, `client_id`, `frequence_controle`, `manager_id`, `username`, `username_canonical`, `email`,
                    `email_canonical`, `enabled`, `salt`, `password`, `last_login`, `confirmation_token`,
                    `password_requested_at`, `roles`, `nom`, `prenom`, `super_admin`, `giroupy`, `objectif_controle`,
                    `rappel`, `updated_at`)
VALUES (1, NULL, NULL, NULL, 'manager@cleanmanager.com', 'manager@cleanmanager.com', 'manager@cleanmanager.com',
        'manager@cleanmanager.com', 1, NULL, '$2y$13$mhzo3Ome.76099X0Xgn2..x3K8hWNH37LHcN91PZwIdj3BE1HDwOq', NULL, NULL,
        NULL, 'a:1:{i:0;s:10:\"ROLE_ADMIN\";}', 'DOE', 'John', 1, NULL, NULL, NULL, '2020-10-02 10:23:27'),
       (4, 2, NULL, NULL, 'manager@arithmetic.com', 'manager@arithmetic.com', 'manager@arithmetic.com',
        'manager@arithmetic.com', 1, NULL, '$2y$13$CIE2TpqbxXW2FFRXQnJsKedan8zYH0YO.lj3VTBS8Kar0KqLm1fHO', NULL, NULL,
        NULL, 'a:1:{i:0;s:12:\"ROLE_MANAGER\";}', 'Doe', 'John', NULL, NULL, NULL, NULL, '2020-10-02 10:23:28'),
       (5, 2, 1, NULL, 'testagent@arithmetic.com', 'testagent@arithmetic.com', 'testagent@arithmetic.com',
        'testagent@arithmetic.com', 1, NULL, '$2y$13$Qc647RMi9sVK0a9l5JYTGeS7fFqDmp6a4A9kJQeASi7Fiyi5iy.Zu', NULL, NULL,
        NULL, 'a:1:{i:0;s:10:\"ROLE_AGENT\";}', 'Doe', 'Peter', NULL, NULL, 3, 1, '2020-10-02 10:23:28'),
       (6, 3, NULL, NULL, 'superadmin-demo@arithmetic.fr', 'superadmin-demo@arithmetic.fr',
        'superadmin-demo@arithmetic.fr', 'superadmin-demo@arithmetic.fr', 1, NULL,
        '$2y$13$gxbJgo35uUYCiMN9hyMzR.eXH03RPf4GTHPK4dVu1tu9y/V7/iMpS', NULL, NULL, NULL,
        'a:1:{i:0;s:10:\"ROLE_ADMIN\";}', 'SuperAdmin', 'Demo', NULL, NULL, NULL, NULL, '2020-10-02 12:25:32'),
       (7, 3, NULL, NULL, 'manager-demo@cleanmanager.com', 'manager-demo@cleanmanager.com',
        'manager-demo@cleanmanager.com', 'manager-demo@cleanmanager.com', 1, NULL,
        '$2y$13$RrzYzBlciepMGD6fE2xFnOYA55YZOKaUFPjkTNCsjn3KE/6sO1UVq', NULL, NULL, NULL,
        'a:1:{i:0;s:12:\"ROLE_MANAGER\";}', 'Manager', 'Demo', NULL, NULL, NULL, NULL, '2020-10-02 12:25:32'),
       (8, 3, 2, 7, 'agent1-demo@arithmetic.fr', 'agent1-demo@arithmetic.fr', 'agent1-demo@arithmetic.fr',
        'agent1-demo@arithmetic.fr', 1, NULL, '$2y$13$7elA7UN/9hklqsjDLOwdNOFUzqUdW0vcUyNhkO/en/lhW4rC.yA46', NULL,
        NULL, NULL, 'a:1:{i:0;s:10:\"ROLE_AGENT\";}', 'Lefèvre', 'Guislain', NULL, NULL, 5, 1, '2020-10-02 12:25:33'),
       (9, 3, 3, 7, 'agent2-demo@arithmetic.fr', 'agent2-demo@arithmetic.fr', 'agent2-demo@arithmetic.fr',
        'agent2-demo@arithmetic.fr', 1, NULL, '$2y$13$BZgUpeiM.72Br3XbZTusfeFjAVyu7Mi.nP.GHPbGB5.xHSc95U.QO', NULL,
        NULL, NULL, 'a:1:{i:0;s:10:\"ROLE_AGENT\";}', 'Dupont', 'Nicolas', NULL, NULL, 8, 1, '2020-10-02 12:25:33');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;

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