[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], 'parameterMappings' => [ [ 'idOrStrSearch' => [ 0, 1, 2, 3, ], 'company' => [ 4, ], 'agency_id' => [ 5, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.societe AS societe_2, f0_.source AS source_3, f0_.phone_indicatif AS phone_indicatif_4, f0_.phone AS phone_5, f0_.email AS email_6, f0_.civility AS civility_7, f0_.firstname AS firstname_8, f0_.extrabat_id AS extrabat_id_9, f0_.state AS state_10, f0_.deleted_at AS deleted_at_11, f0_.created_at AS created_at_12, f0_.updated_at AS updated_at_13, a1_.id AS id_14, a1_.civility AS civility_15, a1_.street AS street_16, a1_.street2 AS street2_17, a1_.postal_code AS postal_code_18, a1_.city AS city_19, a1_.country AS country_20, a1_.altitude AS altitude_21, a1_.longitude AS longitude_22, a1_.latitude AS latitude_23, a1_.temperature AS temperature_24, a1_.deleted_at AS deleted_at_25, a1_.created_at AS created_at_26, a1_.updated_at AS updated_at_27 FROM final_customer f0_ INNER JOIN project p2_ ON f0_.id = p2_.final_customer_id INNER JOIN agency a3_ ON p2_.agency_id = a3_.id LEFT JOIN address a1_ ON f0_.address_id = a1_.id WHERE ((f0_.name LIKE ? OR f0_.firstname LIKE ? OR f0_.societe LIKE ? OR p2_.project_name LIKE ?)) AND a3_.company_id = ? AND (a3_.shared_folder = 1 OR a3_.id = ?) ORDER BY f0_.name ASC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'f' => 'App\\Entity\\FinalCustomer', 'address' => 'App\\Entity\\Address', ], ], 'relationMap' => [ 2 => [ 'address' => 'address', ], ], 'parentAliasMap' => [ 2 => [ 'address' => 'f', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'name_1' => 'name', 'societe_2' => 'societe', 'source_3' => 'source', 'phone_indicatif_4' => 'phoneIndicatif', 'phone_5' => 'phone', 'email_6' => 'email', 'civility_7' => 'civility', 'firstname_8' => 'firstname', 'extrabat_id_9' => 'extrabatId', 'state_10' => 'state', 'deleted_at_11' => 'deletedAt', 'created_at_12' => 'createdAt', 'updated_at_13' => 'updatedAt', 'id_14' => 'id', 'civility_15' => 'civility', 'street_16' => 'street', 'street2_17' => 'street2', 'postal_code_18' => 'postalCode', 'city_19' => 'city', 'country_20' => 'country', 'altitude_21' => 'altitude', 'longitude_22' => 'longitude', 'latitude_23' => 'latitude', 'temperature_24' => 'temperature', 'deleted_at_25' => 'deletedAt', 'created_at_26' => 'createdAt', 'updated_at_27' => 'updatedAt', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\FinalCustomer' => [ 'f' => [ 'id' => 'id_0', 'name' => 'name_1', 'societe' => 'societe_2', 'source' => 'source_3', 'phoneIndicatif' => 'phone_indicatif_4', 'phone' => 'phone_5', 'email' => 'email_6', 'civility' => 'civility_7', 'firstname' => 'firstname_8', 'extrabatId' => 'extrabat_id_9', 'state' => 'state_10', 'deletedAt' => 'deleted_at_11', 'createdAt' => 'created_at_12', 'updatedAt' => 'updated_at_13', ], ], 'App\\Entity\\Address' => [ 'address' => [ 'id' => 'id_14', 'civility' => 'civility_15', 'street' => 'street_16', 'street2' => 'street2_17', 'postalCode' => 'postal_code_18', 'city' => 'city_19', 'country' => 'country_20', 'altitude' => 'altitude_21', 'longitude' => 'longitude_22', 'latitude' => 'latitude_23', 'temperature' => 'temperature_24', 'deletedAt' => 'deleted_at_25', 'createdAt' => 'created_at_26', 'updatedAt' => 'updated_at_27', ], ], ], ], 'entityMappings' => [ 2 => [ 'f' => null, ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'f', 'name_1' => 'f', 'societe_2' => 'f', 'source_3' => 'f', 'phone_indicatif_4' => 'f', 'phone_5' => 'f', 'email_6' => 'f', 'civility_7' => 'f', 'firstname_8' => 'f', 'extrabat_id_9' => 'f', 'state_10' => 'f', 'deleted_at_11' => 'f', 'created_at_12' => 'f', 'updated_at_13' => 'f', 'id_14' => 'address', 'civility_15' => 'address', 'street_16' => 'address', 'street2_17' => 'address', 'postal_code_18' => 'address', 'city_19' => 'address', 'country_20' => 'address', 'altitude_21' => 'address', 'longitude_22' => 'address', 'latitude_23' => 'address', 'temperature_24' => 'address', 'deleted_at_25' => 'address', 'created_at_26' => 'address', 'updated_at_27' => 'address', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\FinalCustomer', 'name_1' => 'App\\Entity\\FinalCustomer', 'societe_2' => 'App\\Entity\\FinalCustomer', 'source_3' => 'App\\Entity\\FinalCustomer', 'phone_indicatif_4' => 'App\\Entity\\FinalCustomer', 'phone_5' => 'App\\Entity\\FinalCustomer', 'email_6' => 'App\\Entity\\FinalCustomer', 'civility_7' => 'App\\Entity\\FinalCustomer', 'firstname_8' => 'App\\Entity\\FinalCustomer', 'extrabat_id_9' => 'App\\Entity\\FinalCustomer', 'state_10' => 'App\\Entity\\FinalCustomer', 'deleted_at_11' => 'App\\Entity\\FinalCustomer', 'created_at_12' => 'App\\Entity\\FinalCustomer', 'updated_at_13' => 'App\\Entity\\FinalCustomer', 'id_14' => 'App\\Entity\\Address', 'civility_15' => 'App\\Entity\\Address', 'street_16' => 'App\\Entity\\Address', 'street2_17' => 'App\\Entity\\Address', 'postal_code_18' => 'App\\Entity\\Address', 'city_19' => 'App\\Entity\\Address', 'country_20' => 'App\\Entity\\Address', 'altitude_21' => 'App\\Entity\\Address', 'longitude_22' => 'App\\Entity\\Address', 'latitude_23' => 'App\\Entity\\Address', 'temperature_24' => 'App\\Entity\\Address', 'deleted_at_25' => 'App\\Entity\\Address', 'created_at_26' => 'App\\Entity\\Address', 'updated_at_27' => 'App\\Entity\\Address', ], ], ], ], $o[0], [] ); } }];