[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.name AS name_2, c0_.start_date AS start_date_3, c0_.end_date AS end_date_4, c0_.max_users AS max_users_5, c0_.monthly_tokens AS monthly_tokens_6, c0_.is_active AS is_active_7, c0_.notes AS notes_8, c0_.price_per_license AS price_per_license_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.last_token_renewal_at AS last_token_renewal_at_12, c1_.id AS id_13, c1_.uuid AS uuid_14, c1_.name AS name_15, c1_.description AS description_16, c1_.siret AS siret_17, c1_.address AS address_18, c1_.city AS city_19, c1_.postal_code AS postal_code_20, c1_.email AS email_21, c1_.phone AS phone_22, c1_.website AS website_23, c1_.created_at AS created_at_24, c1_.updated_at AS updated_at_25, c1_.sam_last_cleaned_at AS sam_last_cleaned_at_26, c1_.is_active AS is_active_27, c1_.has_sam_access AS has_sam_access_28, c1_.moodle_url AS moodle_url_29, c1_.moodle_token AS moodle_token_30, c0_.company_id AS company_id_31, c0_.created_by_id AS created_by_id_32, c1_.created_by_id AS created_by_id_33, c1_.updated_by_id AS updated_by_id_34 FROM contract c0_ LEFT JOIN company c1_ ON c0_.company_id = c1_.id ORDER BY c0_.end_date DESC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'c' => 'App\\Entity\\Contract', 'co' => 'App\\Entity\\Company', ], ], 'relationMap' => [ 2 => [ 'co' => 'company', ], ], 'parentAliasMap' => [ 2 => [ 'co' => 'c', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'uuid_1' => 'uuid', 'name_2' => 'name', 'start_date_3' => 'startDate', 'end_date_4' => 'endDate', 'max_users_5' => 'maxUsers', 'monthly_tokens_6' => 'monthlyTokens', 'is_active_7' => 'isActive', 'notes_8' => 'notes', 'price_per_license_9' => 'pricePerLicense', 'created_at_10' => 'createdAt', 'updated_at_11' => 'updatedAt', 'last_token_renewal_at_12' => 'lastTokenRenewalAt', 'id_13' => 'id', 'uuid_14' => 'uuid', 'name_15' => 'name', 'description_16' => 'description', 'siret_17' => 'siret', 'address_18' => 'address', 'city_19' => 'city', 'postal_code_20' => 'postalCode', 'email_21' => 'email', 'phone_22' => 'phone', 'website_23' => 'website', 'created_at_24' => 'createdAt', 'updated_at_25' => 'updatedAt', 'sam_last_cleaned_at_26' => 'samLastCleanedAt', 'is_active_27' => 'isActive', 'has_sam_access_28' => 'hasSamAccess', 'moodle_url_29' => 'moodleUrl', 'moodle_token_30' => 'moodleToken', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\Contract' => [ 'c' => [ 'id' => 'id_0', 'uuid' => 'uuid_1', 'name' => 'name_2', 'startDate' => 'start_date_3', 'endDate' => 'end_date_4', 'maxUsers' => 'max_users_5', 'monthlyTokens' => 'monthly_tokens_6', 'isActive' => 'is_active_7', 'notes' => 'notes_8', 'pricePerLicense' => 'price_per_license_9', 'createdAt' => 'created_at_10', 'updatedAt' => 'updated_at_11', 'lastTokenRenewalAt' => 'last_token_renewal_at_12', ], ], 'App\\Entity\\Company' => [ 'co' => [ 'id' => 'id_13', 'uuid' => 'uuid_14', 'name' => 'name_15', 'description' => 'description_16', 'siret' => 'siret_17', 'address' => 'address_18', 'city' => 'city_19', 'postalCode' => 'postal_code_20', 'email' => 'email_21', 'phone' => 'phone_22', 'website' => 'website_23', 'createdAt' => 'created_at_24', 'updatedAt' => 'updated_at_25', 'samLastCleanedAt' => 'sam_last_cleaned_at_26', 'isActive' => 'is_active_27', 'hasSamAccess' => 'has_sam_access_28', 'moodleUrl' => 'moodle_url_29', 'moodleToken' => 'moodle_token_30', ], ], ], ], 'typeMappings' => [ 2 => [ 'company_id_31' => 'integer', 'created_by_id_32' => 'integer', 'created_by_id_33' => 'integer', 'updated_by_id_34' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'c' => null, ], ], 'metaMappings' => [ 2 => [ 'company_id_31' => 'company_id', 'created_by_id_32' => 'created_by_id', 'created_by_id_33' => 'created_by_id', 'updated_by_id_34' => 'updated_by_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'c', 'uuid_1' => 'c', 'name_2' => 'c', 'start_date_3' => 'c', 'end_date_4' => 'c', 'max_users_5' => 'c', 'monthly_tokens_6' => 'c', 'is_active_7' => 'c', 'notes_8' => 'c', 'price_per_license_9' => 'c', 'created_at_10' => 'c', 'updated_at_11' => 'c', 'last_token_renewal_at_12' => 'c', 'id_13' => 'co', 'uuid_14' => 'co', 'name_15' => 'co', 'description_16' => 'co', 'siret_17' => 'co', 'address_18' => 'co', 'city_19' => 'co', 'postal_code_20' => 'co', 'email_21' => 'co', 'phone_22' => 'co', 'website_23' => 'co', 'created_at_24' => 'co', 'updated_at_25' => 'co', 'sam_last_cleaned_at_26' => 'co', 'is_active_27' => 'co', 'has_sam_access_28' => 'co', 'moodle_url_29' => 'co', 'moodle_token_30' => 'co', 'company_id_31' => 'c', 'created_by_id_32' => 'c', 'created_by_id_33' => 'co', 'updated_by_id_34' => 'co', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\Contract', 'uuid_1' => 'App\\Entity\\Contract', 'name_2' => 'App\\Entity\\Contract', 'start_date_3' => 'App\\Entity\\Contract', 'end_date_4' => 'App\\Entity\\Contract', 'max_users_5' => 'App\\Entity\\Contract', 'monthly_tokens_6' => 'App\\Entity\\Contract', 'is_active_7' => 'App\\Entity\\Contract', 'notes_8' => 'App\\Entity\\Contract', 'price_per_license_9' => 'App\\Entity\\Contract', 'created_at_10' => 'App\\Entity\\Contract', 'updated_at_11' => 'App\\Entity\\Contract', 'last_token_renewal_at_12' => 'App\\Entity\\Contract', 'id_13' => 'App\\Entity\\Company', 'uuid_14' => 'App\\Entity\\Company', 'name_15' => 'App\\Entity\\Company', 'description_16' => 'App\\Entity\\Company', 'siret_17' => 'App\\Entity\\Company', 'address_18' => 'App\\Entity\\Company', 'city_19' => 'App\\Entity\\Company', 'postal_code_20' => 'App\\Entity\\Company', 'email_21' => 'App\\Entity\\Company', 'phone_22' => 'App\\Entity\\Company', 'website_23' => 'App\\Entity\\Company', 'created_at_24' => 'App\\Entity\\Company', 'updated_at_25' => 'App\\Entity\\Company', 'sam_last_cleaned_at_26' => 'App\\Entity\\Company', 'is_active_27' => 'App\\Entity\\Company', 'has_sam_access_28' => 'App\\Entity\\Company', 'moodle_url_29' => 'App\\Entity\\Company', 'moodle_token_30' => 'App\\Entity\\Company', ], ], ], ], $o[0], [] ); } }];