[ '_sqlExecutor' => [ $o[1], ], '_resultSetMapping' => [ $o[2], ], '_parameterMappings' => [ [ 'company' => [ 0, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\AbstractSqlExecutor' => [ '_sqlStatements' => [ 1 => 'SELECT c0_.id AS id_0, c0_.number AS number_1, c0_.appointment_date AS appointment_date_2, c0_.signature_date AS signature_date_3, c0_.created_by AS created_by_4, c0_.updated_by AS updated_by_5, c0_.deleted_by AS deleted_by_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.uuid AS uuid_9, c0_.id AS id_10, c0_.number AS number_11, c0_.appointment_date AS appointment_date_12, c0_.signature_date AS signature_date_13, c0_.created_by AS created_by_14, c0_.updated_by AS updated_by_15, c0_.deleted_by AS deleted_by_16, c0_.created_at AS created_at_17, c0_.updated_at AS updated_at_18, c0_.uuid AS uuid_19, c1_.id AS id_20, c1_.due_date AS due_date_21, c1_.bound_date AS bound_date_22, c1_.created_by AS created_by_23, c1_.updated_by AS updated_by_24, c1_.deleted_by AS deleted_by_25, c1_.created_at AS created_at_26, c1_.updated_at AS updated_at_27, c2_.id AS id_28, c2_.number AS number_29, c2_.due_date AS due_date_30, c2_.reminder_date AS reminder_date_31, c2_.consumption AS consumption_32, c2_.created_by AS created_by_33, c2_.updated_by AS updated_by_34, c2_.deleted_by AS deleted_by_35, c2_.created_at AS created_at_36, c2_.updated_at AS updated_at_37, e3_.id AS id_38, e3_.enabled AS enabled_39, e3_.created_by AS created_by_40, e3_.updated_by AS updated_by_41, e3_.deleted_by AS deleted_by_42, e3_.created_at AS created_at_43, e3_.updated_at AS updated_at_44, e4_.id AS id_45, e4_.name AS name_46, e4_.description AS description_47, e4_.locale AS locale_48, u5_.id AS id_49, u5_.date_of_birth AS date_of_birth_50, u5_.firstname AS firstname_51, u5_.lastname AS lastname_52, u5_.username AS username_53, u5_.phone AS phone_54, u5_.gender AS gender_55, u5_.email AS email_56, u5_.password AS password_57, u5_.roles AS roles_58, u5_.is_verified AS is_verified_59, u5_.last_login AS last_login_60, u5_.social_security_number AS social_security_number_61, u5_.city_of_birth AS city_of_birth_62, u5_.avatar AS avatar_63, u5_.logged_in AS logged_in_64, u5_.session_id AS session_id_65, u5_.created_at AS created_at_66, u5_.updated_at AS updated_at_67, u5_.enabled AS enabled_68, u5_.deleted_at AS deleted_at_69, c6_.id AS id_70, c6_.first_name AS first_name_71, c6_.lastname AS lastname_72, c6_.cell_phone_number AS cell_phone_number_73, c6_.land_line_number AS land_line_number_74, c6_.gender AS gender_75, c6_.email AS email_76, c6_.siren AS siren_77, c6_.company_name AS company_name_78, s7_.id AS id_79, s7_.code AS code_80, s7_.instructions AS instructions_81, s7_.color AS color_82, s7_.created_by AS created_by_83, s7_.updated_by AS updated_by_84, s7_.deleted_by AS deleted_by_85, s7_.slug AS slug_86, s7_.created_at AS created_at_87, s7_.updated_at AS updated_at_88, s8_.id AS id_89, s8_.name AS name_90, s8_.description AS description_91, s8_.locale AS locale_92 FROM contract c0_ INNER JOIN contract_status c1_ ON c0_.id = c1_.contract LEFT JOIN contract_extra_option c2_ ON c0_.id = c2_.contract_id LEFT JOIN extra_option e3_ ON c2_.type_id = e3_.id LEFT JOIN extra_option_translation e4_ ON e3_.id = e4_.translatable_id INNER JOIN user u5_ ON c0_.author_id = u5_.id INNER JOIN contract_owner c6_ ON c0_.owner_id = c6_.id INNER JOIN status s7_ ON c1_.status = s7_.id LEFT JOIN status_translation s8_ ON s7_.id = s8_.translatable_id WHERE u5_.company_id = ? ORDER BY u5_.created_at ASC, c1_.created_at DESC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'c' => 'App\\Entity\\Contract', 'cc' => 'App\\Entity\\ContractStatus', 'ceo' => 'App\\Entity\\ContractExtraOption', 'ceot' => 'App\\Entity\\ExtraOption', 'ceott' => 'App\\Entity\\ExtraOptionTranslation', 'ca' => 'App\\Entity\\User', 'co' => 'App\\Entity\\ContractOwner', 'ccs' => 'App\\Entity\\Status', 'ccst' => 'App\\Entity\\StatusTranslation', ], ], 'relationMap' => [ 2 => [ 'cc' => 'contractStatusList', 'ceo' => 'extra_option', 'ceot' => 'type', 'ceott' => 'translations', 'ca' => 'author', 'co' => 'owner', 'ccs' => 'status', 'ccst' => 'translations', ], ], 'parentAliasMap' => [ 2 => [ 'cc' => 'c', 'ceo' => 'c', 'ceot' => 'ceo', 'ceott' => 'ceot', 'ca' => 'c', 'co' => 'c', 'ccs' => 'cc', 'ccst' => 'ccs', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'number_1' => 'number', 'appointment_date_2' => 'appointmentDate', 'signature_date_3' => 'signatureDate', 'created_by_4' => 'createdBy', 'updated_by_5' => 'updatedBy', 'deleted_by_6' => 'deletedBy', 'created_at_7' => 'createdAt', 'updated_at_8' => 'updatedAt', 'uuid_9' => 'uuid', 'id_10' => 'id', 'number_11' => 'number', 'appointment_date_12' => 'appointmentDate', 'signature_date_13' => 'signatureDate', 'created_by_14' => 'createdBy', 'updated_by_15' => 'updatedBy', 'deleted_by_16' => 'deletedBy', 'created_at_17' => 'createdAt', 'updated_at_18' => 'updatedAt', 'uuid_19' => 'uuid', 'id_20' => 'id', 'due_date_21' => 'dueDate', 'bound_date_22' => 'boundDate', 'created_by_23' => 'createdBy', 'updated_by_24' => 'updatedBy', 'deleted_by_25' => 'deletedBy', 'created_at_26' => 'createdAt', 'updated_at_27' => 'updatedAt', 'id_28' => 'id', 'number_29' => 'number', 'due_date_30' => 'dueDate', 'reminder_date_31' => 'reminderDate', 'consumption_32' => 'consumption', 'created_by_33' => 'createdBy', 'updated_by_34' => 'updatedBy', 'deleted_by_35' => 'deletedBy', 'created_at_36' => 'createdAt', 'updated_at_37' => 'updatedAt', 'id_38' => 'id', 'enabled_39' => 'enabled', 'created_by_40' => 'createdBy', 'updated_by_41' => 'updatedBy', 'deleted_by_42' => 'deletedBy', 'created_at_43' => 'createdAt', 'updated_at_44' => 'updatedAt', 'id_45' => 'id', 'name_46' => 'name', 'description_47' => 'description', 'locale_48' => 'locale', 'id_49' => 'id', 'date_of_birth_50' => 'dateOfBirth', 'firstname_51' => 'firstname', 'lastname_52' => 'lastname', 'username_53' => 'username', 'phone_54' => 'phone', 'gender_55' => 'gender', 'email_56' => 'email', 'password_57' => 'password', 'roles_58' => 'roles', 'is_verified_59' => 'isVerified', 'last_login_60' => 'lastLogin', 'social_security_number_61' => 'socialSecurityNumber', 'city_of_birth_62' => 'cityOfBirth', 'avatar_63' => 'avatar', 'logged_in_64' => 'loggedIn', 'session_id_65' => 'sessionId', 'created_at_66' => 'createdAt', 'updated_at_67' => 'updatedAt', 'enabled_68' => 'enabled', 'deleted_at_69' => 'deletedAt', 'id_70' => 'id', 'first_name_71' => 'firstName', 'lastname_72' => 'lastname', 'cell_phone_number_73' => 'cellPhoneNumber', 'land_line_number_74' => 'landLineNumber', 'gender_75' => 'gender', 'email_76' => 'email', 'siren_77' => 'siren', 'company_name_78' => 'companyName', 'id_79' => 'id', 'code_80' => 'code', 'instructions_81' => 'instructions', 'color_82' => 'color', 'created_by_83' => 'createdBy', 'updated_by_84' => 'updatedBy', 'deleted_by_85' => 'deletedBy', 'slug_86' => 'slug', 'created_at_87' => 'createdAt', 'updated_at_88' => 'updatedAt', 'id_89' => 'id', 'name_90' => 'name', 'description_91' => 'description', 'locale_92' => 'locale', ], ], 'entityMappings' => [ 2 => [ 'c' => null, ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'c', 'number_1' => 'c', 'appointment_date_2' => 'c', 'signature_date_3' => 'c', 'created_by_4' => 'c', 'updated_by_5' => 'c', 'deleted_by_6' => 'c', 'created_at_7' => 'c', 'updated_at_8' => 'c', 'uuid_9' => 'c', 'id_10' => 'c', 'number_11' => 'c', 'appointment_date_12' => 'c', 'signature_date_13' => 'c', 'created_by_14' => 'c', 'updated_by_15' => 'c', 'deleted_by_16' => 'c', 'created_at_17' => 'c', 'updated_at_18' => 'c', 'uuid_19' => 'c', 'id_20' => 'cc', 'due_date_21' => 'cc', 'bound_date_22' => 'cc', 'created_by_23' => 'cc', 'updated_by_24' => 'cc', 'deleted_by_25' => 'cc', 'created_at_26' => 'cc', 'updated_at_27' => 'cc', 'id_28' => 'ceo', 'number_29' => 'ceo', 'due_date_30' => 'ceo', 'reminder_date_31' => 'ceo', 'consumption_32' => 'ceo', 'created_by_33' => 'ceo', 'updated_by_34' => 'ceo', 'deleted_by_35' => 'ceo', 'created_at_36' => 'ceo', 'updated_at_37' => 'ceo', 'id_38' => 'ceot', 'enabled_39' => 'ceot', 'created_by_40' => 'ceot', 'updated_by_41' => 'ceot', 'deleted_by_42' => 'ceot', 'created_at_43' => 'ceot', 'updated_at_44' => 'ceot', 'id_45' => 'ceott', 'name_46' => 'ceott', 'description_47' => 'ceott', 'locale_48' => 'ceott', 'id_49' => 'ca', 'date_of_birth_50' => 'ca', 'firstname_51' => 'ca', 'lastname_52' => 'ca', 'username_53' => 'ca', 'phone_54' => 'ca', 'gender_55' => 'ca', 'email_56' => 'ca', 'password_57' => 'ca', 'roles_58' => 'ca', 'is_verified_59' => 'ca', 'last_login_60' => 'ca', 'social_security_number_61' => 'ca', 'city_of_birth_62' => 'ca', 'avatar_63' => 'ca', 'logged_in_64' => 'ca', 'session_id_65' => 'ca', 'created_at_66' => 'ca', 'updated_at_67' => 'ca', 'enabled_68' => 'ca', 'deleted_at_69' => 'ca', 'id_70' => 'co', 'first_name_71' => 'co', 'lastname_72' => 'co', 'cell_phone_number_73' => 'co', 'land_line_number_74' => 'co', 'gender_75' => 'co', 'email_76' => 'co', 'siren_77' => 'co', 'company_name_78' => 'co', 'id_79' => 'ccs', 'code_80' => 'ccs', 'instructions_81' => 'ccs', 'color_82' => 'ccs', 'created_by_83' => 'ccs', 'updated_by_84' => 'ccs', 'deleted_by_85' => 'ccs', 'slug_86' => 'ccs', 'created_at_87' => 'ccs', 'updated_at_88' => 'ccs', 'id_89' => 'ccst', 'name_90' => 'ccst', 'description_91' => 'ccst', 'locale_92' => 'ccst', ], ], 'indexByMap' => [ 2 => [ 'ceott' => 'locale_48', 'ccst' => 'locale_92', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\Contract', 'number_1' => 'App\\Entity\\Contract', 'appointment_date_2' => 'App\\Entity\\Contract', 'signature_date_3' => 'App\\Entity\\Contract', 'created_by_4' => 'App\\Entity\\Contract', 'updated_by_5' => 'App\\Entity\\Contract', 'deleted_by_6' => 'App\\Entity\\Contract', 'created_at_7' => 'App\\Entity\\Contract', 'updated_at_8' => 'App\\Entity\\Contract', 'uuid_9' => 'App\\Entity\\Contract', 'id_10' => 'App\\Entity\\Contract', 'number_11' => 'App\\Entity\\Contract', 'appointment_date_12' => 'App\\Entity\\Contract', 'signature_date_13' => 'App\\Entity\\Contract', 'created_by_14' => 'App\\Entity\\Contract', 'updated_by_15' => 'App\\Entity\\Contract', 'deleted_by_16' => 'App\\Entity\\Contract', 'created_at_17' => 'App\\Entity\\Contract', 'updated_at_18' => 'App\\Entity\\Contract', 'uuid_19' => 'App\\Entity\\Contract', 'id_20' => 'App\\Entity\\ContractStatus', 'due_date_21' => 'App\\Entity\\ContractStatus', 'bound_date_22' => 'App\\Entity\\ContractStatus', 'created_by_23' => 'App\\Entity\\ContractStatus', 'updated_by_24' => 'App\\Entity\\ContractStatus', 'deleted_by_25' => 'App\\Entity\\ContractStatus', 'created_at_26' => 'App\\Entity\\ContractStatus', 'updated_at_27' => 'App\\Entity\\ContractStatus', 'id_28' => 'App\\Entity\\ContractExtraOption', 'number_29' => 'App\\Entity\\ContractExtraOption', 'due_date_30' => 'App\\Entity\\ContractExtraOption', 'reminder_date_31' => 'App\\Entity\\ContractExtraOption', 'consumption_32' => 'App\\Entity\\ContractExtraOption', 'created_by_33' => 'App\\Entity\\ContractExtraOption', 'updated_by_34' => 'App\\Entity\\ContractExtraOption', 'deleted_by_35' => 'App\\Entity\\ContractExtraOption', 'created_at_36' => 'App\\Entity\\ContractExtraOption', 'updated_at_37' => 'App\\Entity\\ContractExtraOption', 'id_38' => 'App\\Entity\\ExtraOption', 'enabled_39' => 'App\\Entity\\ExtraOption', 'created_by_40' => 'App\\Entity\\ExtraOption', 'updated_by_41' => 'App\\Entity\\ExtraOption', 'deleted_by_42' => 'App\\Entity\\ExtraOption', 'created_at_43' => 'App\\Entity\\ExtraOption', 'updated_at_44' => 'App\\Entity\\ExtraOption', 'id_45' => 'App\\Entity\\ExtraOptionTranslation', 'name_46' => 'App\\Entity\\ExtraOptionTranslation', 'description_47' => 'App\\Entity\\ExtraOptionTranslation', 'locale_48' => 'App\\Entity\\ExtraOptionTranslation', 'id_49' => 'App\\Entity\\User', 'date_of_birth_50' => 'App\\Entity\\User', 'firstname_51' => 'App\\Entity\\User', 'lastname_52' => 'App\\Entity\\User', 'username_53' => 'App\\Entity\\User', 'phone_54' => 'App\\Entity\\User', 'gender_55' => 'App\\Entity\\User', 'email_56' => 'App\\Entity\\User', 'password_57' => 'App\\Entity\\User', 'roles_58' => 'App\\Entity\\User', 'is_verified_59' => 'App\\Entity\\User', 'last_login_60' => 'App\\Entity\\User', 'social_security_number_61' => 'App\\Entity\\User', 'city_of_birth_62' => 'App\\Entity\\User', 'avatar_63' => 'App\\Entity\\User', 'logged_in_64' => 'App\\Entity\\User', 'session_id_65' => 'App\\Entity\\User', 'created_at_66' => 'App\\Entity\\User', 'updated_at_67' => 'App\\Entity\\User', 'enabled_68' => 'App\\Entity\\User', 'deleted_at_69' => 'App\\Entity\\User', 'id_70' => 'App\\Entity\\ContractOwner', 'first_name_71' => 'App\\Entity\\ContractOwner', 'lastname_72' => 'App\\Entity\\ContractOwner', 'cell_phone_number_73' => 'App\\Entity\\ContractOwner', 'land_line_number_74' => 'App\\Entity\\ContractOwner', 'gender_75' => 'App\\Entity\\ContractOwner', 'email_76' => 'App\\Entity\\ContractOwner', 'siren_77' => 'App\\Entity\\ContractOwner', 'company_name_78' => 'App\\Entity\\ContractOwner', 'id_79' => 'App\\Entity\\Status', 'code_80' => 'App\\Entity\\Status', 'instructions_81' => 'App\\Entity\\Status', 'color_82' => 'App\\Entity\\Status', 'created_by_83' => 'App\\Entity\\Status', 'updated_by_84' => 'App\\Entity\\Status', 'deleted_by_85' => 'App\\Entity\\Status', 'slug_86' => 'App\\Entity\\Status', 'created_at_87' => 'App\\Entity\\Status', 'updated_at_88' => 'App\\Entity\\Status', 'id_89' => 'App\\Entity\\StatusTranslation', 'name_90' => 'App\\Entity\\StatusTranslation', 'description_91' => 'App\\Entity\\StatusTranslation', 'locale_92' => 'App\\Entity\\StatusTranslation', ], ], ], ], $o[0], [] ); }];