0
a2a8255279cae5ddf51f300173c4b888
O:31:"Doctrine\ORM\Query\ParserResult":3:{s:44:" Doctrine\ORM\Query\ParserResult sqlExecutor";O:44:"Doctrine\ORM\Query\Exec\SingleSelectExecutor":2:{s:16:" * sqlStatements";s:1360:"SELECT d0_.id AS id_0, d0_.membre_communaute_local1 AS membre_communaute_local1_1, d0_.membre_communaute_local2 AS membre_communaute_local2_2, d0_.membre_organisation_communautaire1 AS membre_organisation_communautaire1_3, d0_.membre_organisation_communautaire2 AS membre_organisation_communautaire2_4, d0_.membre_operateur1 AS membre_operateur1_5, d0_.membre_operateur2 AS membre_operateur2_6, d0_.membre_autorite1 AS membre_autorite1_7, d0_.membre_autorite2 AS membre_autorite2_8, d0_.membre_fonds_national1 AS membre_fonds_national1_9, d0_.membre_fonds_national2 AS membre_fonds_national2_10, d0_.membre_direction1 AS membre_direction1_11, d0_.membre_direction2 AS membre_direction2_12, d0_.nom AS nom_13, d0_.date_creation AS date_creation_14, d0_.token AS token_15, d0_.domaine AS domaine_16, d0_.created_at AS created_at_17, d0_.updated_at AS updated_at_18, d0_.deleted_at AS deleted_at_19, d0_.operateur_id AS operateur_id_20, d0_.arrete_id AS arrete_id_21, d0_.user_id AS user_id_22 FROM dot d0_ INNER JOIN operateur o1_ ON d0_.operateur_id = o1_.id WHERE d0_.id NOT IN (SELECT DISTINCT d2_.id FROM dot d2_ INNER JOIN operateur o3_ ON d2_.operateur_id = o3_.id INNER JOIN information_financiere i4_ ON o3_.id = i4_.operateur_id INNER JOIN versement_dot v5_ ON i4_.id = v5_.information_financiere_id WHERE SUBSTRING(v5_.date_versement FROM 1 FOR 4) = ?)";s:20:" * queryCacheProfile";N;}s:49:" Doctrine\ORM\Query\ParserResult resultSetMapping";O:35:"Doctrine\ORM\Query\ResultSetMapping":19:{s:7:"isMixed";b:0;s:8:"isSelect";b:1;s:8:"aliasMap";a:1:{s:1:"d";s:30:"App\Entity\Emine\Operateur\Dot";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:20:{s:4:"id_0";s:2:"id";s:26:"membre_communaute_local1_1";s:22:"membreCommunauteLocal1";s:26:"membre_communaute_local2_2";s:22:"membreCommunauteLocal2";s:36:"membre_organisation_communautaire1_3";s:32:"membreOrganisationCommunautaire1";s:36:"membre_organisation_communautaire2_4";s:32:"membreOrganisationCommunautaire2";s:19:"membre_operateur1_5";s:16:"membreOperateur1";s:19:"membre_operateur2_6";s:16:"membreOperateur2";s:18:"membre_autorite1_7";s:15:"membreAutorite1";s:18:"membre_autorite2_8";s:15:"membreAutorite2";s:24:"membre_fonds_national1_9";s:20:"membreFondsNational1";s:25:"membre_fonds_national2_10";s:20:"membreFondsNational2";s:20:"membre_direction1_11";s:16:"membreDirection1";s:20:"membre_direction2_12";s:16:"membreDirection2";s:6:"nom_13";s:3:"nom";s:16:"date_creation_14";s:12:"dateCreation";s:8:"token_15";s:5:"token";s:10:"domaine_16";s:7:"domaine";s:13:"created_at_17";s:9:"createdAt";s:13:"updated_at_18";s:9:"updatedAt";s:13:"deleted_at_19";s:9:"deletedAt";}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:3:{s:15:"operateur_id_20";s:7:"integer";s:12:"arrete_id_21";s:7:"integer";s:10:"user_id_22";s:7:"integer";}s:14:"entityMappings";a:1:{s:1:"d";N;}s:12:"metaMappings";a:3:{s:15:"operateur_id_20";s:12:"operateur_id";s:12:"arrete_id_21";s:9:"arrete_id";s:10:"user_id_22";s:7:"user_id";}s:14:"columnOwnerMap";a:23:{s:4:"id_0";s:1:"d";s:26:"membre_communaute_local1_1";s:1:"d";s:26:"membre_communaute_local2_2";s:1:"d";s:36:"membre_organisation_communautaire1_3";s:1:"d";s:36:"membre_organisation_communautaire2_4";s:1:"d";s:19:"membre_operateur1_5";s:1:"d";s:19:"membre_operateur2_6";s:1:"d";s:18:"membre_autorite1_7";s:1:"d";s:18:"membre_autorite2_8";s:1:"d";s:24:"membre_fonds_national1_9";s:1:"d";s:25:"membre_fonds_national2_10";s:1:"d";s:20:"membre_direction1_11";s:1:"d";s:20:"membre_direction2_12";s:1:"d";s:6:"nom_13";s:1:"d";s:16:"date_creation_14";s:1:"d";s:8:"token_15";s:1:"d";s:10:"domaine_16";s:1:"d";s:13:"created_at_17";s:1:"d";s:13:"updated_at_18";s:1:"d";s:13:"deleted_at_19";s:1:"d";s:15:"operateur_id_20";s:1:"d";s:12:"arrete_id_21";s:1:"d";s:10:"user_id_22";s:1:"d";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:20:{s:4:"id_0";s:30:"App\Entity\Emine\Operateur\Dot";s:26:"membre_communaute_local1_1";s:30:"App\Entity\Emine\Operateur\Dot";s:26:"membre_communaute_local2_2";s:30:"App\Entity\Emine\Operateur\Dot";s:36:"membre_organisation_communautaire1_3";s:30:"App\Entity\Emine\Operateur\Dot";s:36:"membre_organisation_communautaire2_4";s:30:"App\Entity\Emine\Operateur\Dot";s:19:"membre_operateur1_5";s:30:"App\Entity\Emine\Operateur\Dot";s:19:"membre_operateur2_6";s:30:"App\Entity\Emine\Operateur\Dot";s:18:"membre_autorite1_7";s:30:"App\Entity\Emine\Operateur\Dot";s:18:"membre_autorite2_8";s:30:"App\Entity\Emine\Operateur\Dot";s:24:"membre_fonds_national1_9";s:30:"App\Entity\Emine\Operateur\Dot";s:25:"membre_fonds_national2_10";s:30:"App\Entity\Emine\Operateur\Dot";s:20:"membre_direction1_11";s:30:"App\Entity\Emine\Operateur\Dot";s:20:"membre_direction2_12";s:30:"App\Entity\Emine\Operateur\Dot";s:6:"nom_13";s:30:"App\Entity\Emine\Operateur\Dot";s:16:"date_creation_14";s:30:"App\Entity\Emine\Operateur\Dot";s:8:"token_15";s:30:"App\Entity\Emine\Operateur\Dot";s:10:"domaine_16";s:30:"App\Entity\Emine\Operateur\Dot";s:13:"created_at_17";s:30:"App\Entity\Emine\Operateur\Dot";s:13:"updated_at_18";s:30:"App\Entity\Emine\Operateur\Dot";s:13:"deleted_at_19";s:30:"App\Entity\Emine\Operateur\Dot";}s:18:"isIdentifierColumn";a:0:{}s:17:"newObjectMappings";a:0:{}s:24:"metadataParameterMapping";a:0:{}s:23:"discriminatorParameters";a:0:{}}s:50:" Doctrine\ORM\Query\ParserResult parameterMappings";a:1:{i:2;a:1:{i:0;i:0;}}}