[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], 'parameterMappings' => [ [ 'type' => [ 0, ], 'project' => [ 1, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.number AS number_2, c0_.status AS status_3, c0_.prospection_version AS prospection_version_4, c0_.issue_date AS issue_date_5, c0_.due_date AS due_date_6, c0_.amount_ht AS amount_ht_7, c0_.vat_rate AS vat_rate_8, c0_.amount_ttc AS amount_ttc_9, c0_.content_snapshot AS content_snapshot_10, c0_.generated_document_id AS generated_document_id_11, c0_.created_at AS created_at_12, c0_.sent_at AS sent_at_13, p1_.id AS id_14, p1_.venue AS venue_15, p1_.refused_date AS refused_date_16, p1_.city AS city_17, p1_.department AS department_18, p1_.capacity AS capacity_19, p1_.contact_name AS contact_name_20, p1_.contact_function AS contact_function_21, p1_.email AS email_22, p1_.phone AS phone_23, p1_.website AS website_24, p1_.informal_address AS informal_address_25, p1_.first_contact_date AS first_contact_date_26, p1_.follow_up1_custom_date AS follow_up1_custom_date_27, p1_.follow_up1_sent_date AS follow_up1_sent_date_28, p1_.follow_up2_custom_date AS follow_up2_custom_date_29, p1_.follow_up2_sent_date AS follow_up2_sent_date_30, p1_.last_response_date AS last_response_date_31, p1_.postpone_until AS postpone_until_32, p1_.future_recontact_date AS future_recontact_date_33, p1_.next_action AS next_action_34, p1_.next_action_date AS next_action_date_35, p1_.proposed_fee AS proposed_fee_36, p1_.travel_fee AS travel_fee_37, p1_.meal_planned AS meal_planned_38, p1_.hat_planned AS hat_planned_39, p1_.accommodation_planned AS accommodation_planned_40, p1_.hospitality_type AS hospitality_type_41, p1_.audio_sent AS audio_sent_42, p1_.press_kit_sent AS press_kit_sent_43, p1_.confirmed_date AS confirmed_date_44, p1_.agreement_date AS agreement_date_45, p1_.proposal_sent_date AS proposal_sent_date_46, p1_.performed_date AS performed_date_47, p1_.notes AS notes_48, p1_.cancelled_at AS cancelled_at_49, p1_.cancellation_reason AS cancellation_reason_50, p1_.active_slot AS active_slot_51, p1_.created_at AS created_at_52, p1_.updated_at AS updated_at_53, c0_.prospection_id AS prospection_id_54, c0_.source_document_id AS source_document_id_55, c0_.created_by_id AS created_by_id_56, c0_.sent_by_id AS sent_by_id_57, p1_.artistic_project_id AS artistic_project_id_58, p1_.venue_entity_id AS venue_entity_id_59, p1_.target_contact_id AS target_contact_id_60, p1_.created_by_id AS created_by_id_61, p1_.first_contact_by_id AS first_contact_by_id_62, p1_.follow_up1_by_id AS follow_up1_by_id_63, p1_.follow_up2_by_id AS follow_up2_by_id_64, p1_.proposal_by_id AS proposal_by_id_65, p1_.decision_by_id AS decision_by_id_66, p1_.agreement_by_id AS agreement_by_id_67, p1_.cancelled_by_id AS cancelled_by_id_68, p1_.performed_by_id AS performed_by_id_69, p1_.venue_type_id AS venue_type_id_70, p1_.priority_id AS priority_id_71, p1_.initial_channel_id AS initial_channel_id_72, p1_.status_id AS status_id_73 FROM commercial_document c0_ INNER JOIN prospection p1_ ON c0_.prospection_id = p1_.id WHERE c0_.type = ? AND c0_.generated_document_id IS NOT NULL AND p1_.artistic_project_id = ? ORDER BY c0_.issue_date DESC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'd' => 'App\\Entity\\CommercialDocument', 'p' => 'App\\Entity\\Prospection', ], ], 'relationMap' => [ 2 => [ 'p' => 'prospection', ], ], 'parentAliasMap' => [ 2 => [ 'p' => 'd', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'type_1' => 'type', 'number_2' => 'number', 'status_3' => 'status', 'prospection_version_4' => 'prospectionVersion', 'issue_date_5' => 'issueDate', 'due_date_6' => 'dueDate', 'amount_ht_7' => 'amountHt', 'vat_rate_8' => 'vatRate', 'amount_ttc_9' => 'amountTtc', 'content_snapshot_10' => 'contentSnapshot', 'generated_document_id_11' => 'generatedDocumentId', 'created_at_12' => 'createdAt', 'sent_at_13' => 'sentAt', 'id_14' => 'id', 'venue_15' => 'venue', 'refused_date_16' => 'refusedDate', 'city_17' => 'city', 'department_18' => 'department', 'capacity_19' => 'capacity', 'contact_name_20' => 'contactName', 'contact_function_21' => 'contactFunction', 'email_22' => 'email', 'phone_23' => 'phone', 'website_24' => 'website', 'informal_address_25' => 'informalAddress', 'first_contact_date_26' => 'firstContactDate', 'follow_up1_custom_date_27' => 'followUp1CustomDate', 'follow_up1_sent_date_28' => 'followUp1SentDate', 'follow_up2_custom_date_29' => 'followUp2CustomDate', 'follow_up2_sent_date_30' => 'followUp2SentDate', 'last_response_date_31' => 'lastResponseDate', 'postpone_until_32' => 'postponeUntil', 'future_recontact_date_33' => 'futureRecontactDate', 'next_action_34' => 'nextAction', 'next_action_date_35' => 'nextActionDate', 'proposed_fee_36' => 'proposedFee', 'travel_fee_37' => 'travelFee', 'meal_planned_38' => 'mealPlanned', 'hat_planned_39' => 'hatPlanned', 'accommodation_planned_40' => 'accommodationPlanned', 'hospitality_type_41' => 'hospitalityType', 'audio_sent_42' => 'audioSent', 'press_kit_sent_43' => 'pressKitSent', 'confirmed_date_44' => 'confirmedDate', 'agreement_date_45' => 'agreementDate', 'proposal_sent_date_46' => 'proposalSentDate', 'performed_date_47' => 'performedDate', 'notes_48' => 'notes', 'cancelled_at_49' => 'cancelledAt', 'cancellation_reason_50' => 'cancellationReason', 'active_slot_51' => 'activeSlot', 'created_at_52' => 'createdAt', 'updated_at_53' => 'updatedAt', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\CommercialDocument' => [ 'd' => [ 'id' => 'id_0', 'type' => 'type_1', 'number' => 'number_2', 'status' => 'status_3', 'prospectionVersion' => 'prospection_version_4', 'issueDate' => 'issue_date_5', 'dueDate' => 'due_date_6', 'amountHt' => 'amount_ht_7', 'vatRate' => 'vat_rate_8', 'amountTtc' => 'amount_ttc_9', 'contentSnapshot' => 'content_snapshot_10', 'generatedDocumentId' => 'generated_document_id_11', 'createdAt' => 'created_at_12', 'sentAt' => 'sent_at_13', ], ], 'App\\Entity\\Prospection' => [ 'p' => [ 'id' => 'id_14', 'venue' => 'venue_15', 'refusedDate' => 'refused_date_16', 'city' => 'city_17', 'department' => 'department_18', 'capacity' => 'capacity_19', 'contactName' => 'contact_name_20', 'contactFunction' => 'contact_function_21', 'email' => 'email_22', 'phone' => 'phone_23', 'website' => 'website_24', 'informalAddress' => 'informal_address_25', 'firstContactDate' => 'first_contact_date_26', 'followUp1CustomDate' => 'follow_up1_custom_date_27', 'followUp1SentDate' => 'follow_up1_sent_date_28', 'followUp2CustomDate' => 'follow_up2_custom_date_29', 'followUp2SentDate' => 'follow_up2_sent_date_30', 'lastResponseDate' => 'last_response_date_31', 'postponeUntil' => 'postpone_until_32', 'futureRecontactDate' => 'future_recontact_date_33', 'nextAction' => 'next_action_34', 'nextActionDate' => 'next_action_date_35', 'proposedFee' => 'proposed_fee_36', 'travelFee' => 'travel_fee_37', 'mealPlanned' => 'meal_planned_38', 'hatPlanned' => 'hat_planned_39', 'accommodationPlanned' => 'accommodation_planned_40', 'hospitalityType' => 'hospitality_type_41', 'audioSent' => 'audio_sent_42', 'pressKitSent' => 'press_kit_sent_43', 'confirmedDate' => 'confirmed_date_44', 'agreementDate' => 'agreement_date_45', 'proposalSentDate' => 'proposal_sent_date_46', 'performedDate' => 'performed_date_47', 'notes' => 'notes_48', 'cancelledAt' => 'cancelled_at_49', 'cancellationReason' => 'cancellation_reason_50', 'activeSlot' => 'active_slot_51', 'createdAt' => 'created_at_52', 'updatedAt' => 'updated_at_53', ], ], ], ], 'typeMappings' => [ 2 => [ 'prospection_id_54' => 'integer', 'source_document_id_55' => 'integer', 'created_by_id_56' => 'integer', 'sent_by_id_57' => 'integer', 'artistic_project_id_58' => 'integer', 'venue_entity_id_59' => 'integer', 'target_contact_id_60' => 'integer', 'created_by_id_61' => 'integer', 'first_contact_by_id_62' => 'integer', 'follow_up1_by_id_63' => 'integer', 'follow_up2_by_id_64' => 'integer', 'proposal_by_id_65' => 'integer', 'decision_by_id_66' => 'integer', 'agreement_by_id_67' => 'integer', 'cancelled_by_id_68' => 'integer', 'performed_by_id_69' => 'integer', 'venue_type_id_70' => 'integer', 'priority_id_71' => 'integer', 'initial_channel_id_72' => 'integer', 'status_id_73' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'd' => null, ], ], 'metaMappings' => [ 2 => [ 'prospection_id_54' => 'prospection_id', 'source_document_id_55' => 'source_document_id', 'created_by_id_56' => 'created_by_id', 'sent_by_id_57' => 'sent_by_id', 'artistic_project_id_58' => 'artistic_project_id', 'venue_entity_id_59' => 'venue_entity_id', 'target_contact_id_60' => 'target_contact_id', 'created_by_id_61' => 'created_by_id', 'first_contact_by_id_62' => 'first_contact_by_id', 'follow_up1_by_id_63' => 'follow_up1_by_id', 'follow_up2_by_id_64' => 'follow_up2_by_id', 'proposal_by_id_65' => 'proposal_by_id', 'decision_by_id_66' => 'decision_by_id', 'agreement_by_id_67' => 'agreement_by_id', 'cancelled_by_id_68' => 'cancelled_by_id', 'performed_by_id_69' => 'performed_by_id', 'venue_type_id_70' => 'venue_type_id', 'priority_id_71' => 'priority_id', 'initial_channel_id_72' => 'initial_channel_id', 'status_id_73' => 'status_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'd', 'type_1' => 'd', 'number_2' => 'd', 'status_3' => 'd', 'prospection_version_4' => 'd', 'issue_date_5' => 'd', 'due_date_6' => 'd', 'amount_ht_7' => 'd', 'vat_rate_8' => 'd', 'amount_ttc_9' => 'd', 'content_snapshot_10' => 'd', 'generated_document_id_11' => 'd', 'created_at_12' => 'd', 'sent_at_13' => 'd', 'id_14' => 'p', 'venue_15' => 'p', 'refused_date_16' => 'p', 'city_17' => 'p', 'department_18' => 'p', 'capacity_19' => 'p', 'contact_name_20' => 'p', 'contact_function_21' => 'p', 'email_22' => 'p', 'phone_23' => 'p', 'website_24' => 'p', 'informal_address_25' => 'p', 'first_contact_date_26' => 'p', 'follow_up1_custom_date_27' => 'p', 'follow_up1_sent_date_28' => 'p', 'follow_up2_custom_date_29' => 'p', 'follow_up2_sent_date_30' => 'p', 'last_response_date_31' => 'p', 'postpone_until_32' => 'p', 'future_recontact_date_33' => 'p', 'next_action_34' => 'p', 'next_action_date_35' => 'p', 'proposed_fee_36' => 'p', 'travel_fee_37' => 'p', 'meal_planned_38' => 'p', 'hat_planned_39' => 'p', 'accommodation_planned_40' => 'p', 'hospitality_type_41' => 'p', 'audio_sent_42' => 'p', 'press_kit_sent_43' => 'p', 'confirmed_date_44' => 'p', 'agreement_date_45' => 'p', 'proposal_sent_date_46' => 'p', 'performed_date_47' => 'p', 'notes_48' => 'p', 'cancelled_at_49' => 'p', 'cancellation_reason_50' => 'p', 'active_slot_51' => 'p', 'created_at_52' => 'p', 'updated_at_53' => 'p', 'prospection_id_54' => 'd', 'source_document_id_55' => 'd', 'created_by_id_56' => 'd', 'sent_by_id_57' => 'd', 'artistic_project_id_58' => 'p', 'venue_entity_id_59' => 'p', 'target_contact_id_60' => 'p', 'created_by_id_61' => 'p', 'first_contact_by_id_62' => 'p', 'follow_up1_by_id_63' => 'p', 'follow_up2_by_id_64' => 'p', 'proposal_by_id_65' => 'p', 'decision_by_id_66' => 'p', 'agreement_by_id_67' => 'p', 'cancelled_by_id_68' => 'p', 'performed_by_id_69' => 'p', 'venue_type_id_70' => 'p', 'priority_id_71' => 'p', 'initial_channel_id_72' => 'p', 'status_id_73' => 'p', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\CommercialDocument', 'type_1' => 'App\\Entity\\CommercialDocument', 'number_2' => 'App\\Entity\\CommercialDocument', 'status_3' => 'App\\Entity\\CommercialDocument', 'prospection_version_4' => 'App\\Entity\\CommercialDocument', 'issue_date_5' => 'App\\Entity\\CommercialDocument', 'due_date_6' => 'App\\Entity\\CommercialDocument', 'amount_ht_7' => 'App\\Entity\\CommercialDocument', 'vat_rate_8' => 'App\\Entity\\CommercialDocument', 'amount_ttc_9' => 'App\\Entity\\CommercialDocument', 'content_snapshot_10' => 'App\\Entity\\CommercialDocument', 'generated_document_id_11' => 'App\\Entity\\CommercialDocument', 'created_at_12' => 'App\\Entity\\CommercialDocument', 'sent_at_13' => 'App\\Entity\\CommercialDocument', 'id_14' => 'App\\Entity\\Prospection', 'venue_15' => 'App\\Entity\\Prospection', 'refused_date_16' => 'App\\Entity\\Prospection', 'city_17' => 'App\\Entity\\Prospection', 'department_18' => 'App\\Entity\\Prospection', 'capacity_19' => 'App\\Entity\\Prospection', 'contact_name_20' => 'App\\Entity\\Prospection', 'contact_function_21' => 'App\\Entity\\Prospection', 'email_22' => 'App\\Entity\\Prospection', 'phone_23' => 'App\\Entity\\Prospection', 'website_24' => 'App\\Entity\\Prospection', 'informal_address_25' => 'App\\Entity\\Prospection', 'first_contact_date_26' => 'App\\Entity\\Prospection', 'follow_up1_custom_date_27' => 'App\\Entity\\Prospection', 'follow_up1_sent_date_28' => 'App\\Entity\\Prospection', 'follow_up2_custom_date_29' => 'App\\Entity\\Prospection', 'follow_up2_sent_date_30' => 'App\\Entity\\Prospection', 'last_response_date_31' => 'App\\Entity\\Prospection', 'postpone_until_32' => 'App\\Entity\\Prospection', 'future_recontact_date_33' => 'App\\Entity\\Prospection', 'next_action_34' => 'App\\Entity\\Prospection', 'next_action_date_35' => 'App\\Entity\\Prospection', 'proposed_fee_36' => 'App\\Entity\\Prospection', 'travel_fee_37' => 'App\\Entity\\Prospection', 'meal_planned_38' => 'App\\Entity\\Prospection', 'hat_planned_39' => 'App\\Entity\\Prospection', 'accommodation_planned_40' => 'App\\Entity\\Prospection', 'hospitality_type_41' => 'App\\Entity\\Prospection', 'audio_sent_42' => 'App\\Entity\\Prospection', 'press_kit_sent_43' => 'App\\Entity\\Prospection', 'confirmed_date_44' => 'App\\Entity\\Prospection', 'agreement_date_45' => 'App\\Entity\\Prospection', 'proposal_sent_date_46' => 'App\\Entity\\Prospection', 'performed_date_47' => 'App\\Entity\\Prospection', 'notes_48' => 'App\\Entity\\Prospection', 'cancelled_at_49' => 'App\\Entity\\Prospection', 'cancellation_reason_50' => 'App\\Entity\\Prospection', 'active_slot_51' => 'App\\Entity\\Prospection', 'created_at_52' => 'App\\Entity\\Prospection', 'updated_at_53' => 'App\\Entity\\Prospection', ], ], ], ], $o[0], [] ); } }];