[ '_sqlExecutor' => [ $o[1], ], '_resultSetMapping' => [ $o[2], ], '_parameterMappings' => [ [ 'year' => [ 0, ], 'month' => [ 1, ], 'worker' => [ 2, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\AbstractSqlExecutor' => [ '_sqlStatements' => [ 1 => 'SELECT IF(r0_.newspapers > 0, 1, 2) AS sclr_0, r1_.id AS id_1, r1_.start AS start_2, r1_.end AS end_3, r1_.status AS status_4, r1_.pause AS pause_5, r1_.date AS date_6, r1_.bonus AS bonus_7, r1_.type AS type_8, r1_.is_signature_visible AS is_signature_visible_9, r1_.longitude_start AS longitude_start_10, r1_.longitude_end AS longitude_end_11, r1_.latitude_start AS latitude_start_12, r1_.latitude_end AS latitude_end_13, r1_.created_at AS created_at_14, m2_.number AS number_15, m2_.postcode AS postcode_16, m2_.city AS city_17, m2_.address AS address_18, m2_.manager AS manager_19, m2_.ordering_rate AS ordering_rate_20, m2_.team AS team_21, m2_.rila_number AS rila_number_22, m2_.newspapers AS newspapers_23, m2_.weekly_paper AS weekly_paper_24, m2_.km_district AS km_district_25, m2_.travel_cost AS travel_cost_26, r1_.worker_id AS worker_id_27, r1_.worker_data_id AS worker_data_id_28, r1_.market_number AS market_number_29, r1_.user_id AS user_id_30, m2_.district_manager_id AS district_manager_id_31, m2_.sales_manager_id AS sales_manager_id_32 FROM record_worker r1_ INNER JOIN market m2_ ON r1_.market_number = m2_.number LEFT JOIN record_market r0_ ON (r0_.date = r1_.date AND r0_.market_number = m2_.number) WHERE YEAR(r1_.date) = ? AND MONTH(r1_.date) = ? AND r1_.worker_id = ? ORDER BY r1_.date ASC, r1_.start ASC', ], ], 'stdClass' => [ 'isMixed' => [ 2 => true, ], 'aliasMap' => [ 2 => [ 'rw' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'm' => 'Emgmbh\\MarketBundle\\Entity\\Market', ], ], 'relationMap' => [ 2 => [ 'm' => 'market', ], ], 'parentAliasMap' => [ 2 => [ 'm' => 'rw', ], ], 'fieldMappings' => [ 2 => [ 'id_1' => 'id', 'start_2' => 'start', 'end_3' => 'end', 'status_4' => 'status', 'pause_5' => 'pause', 'date_6' => 'date', 'bonus_7' => 'bonus', 'type_8' => 'type', 'is_signature_visible_9' => 'isSignatureVisible', 'longitude_start_10' => 'longitudeStart', 'longitude_end_11' => 'longitudeEnd', 'latitude_start_12' => 'latitudeStart', 'latitude_end_13' => 'latitudeEnd', 'created_at_14' => 'createdAt', 'number_15' => 'number', 'postcode_16' => 'postcode', 'city_17' => 'city', 'address_18' => 'address', 'manager_19' => 'manager', 'ordering_rate_20' => 'orderingRate', 'team_21' => 'team', 'rila_number_22' => 'rilaNumber', 'newspapers_23' => 'newspapers', 'weekly_paper_24' => 'weeklyPaper', 'km_district_25' => 'kmDistrict', 'travel_cost_26' => 'travelCost', ], ], 'scalarMappings' => [ 2 => [ 'sclr_0' => 'newspaperBonusType', ], ], 'typeMappings' => [ 2 => [ 'sclr_0' => 'string', 'worker_id_27' => 'integer', 'worker_data_id_28' => 'integer', 'market_number_29' => 'string', 'user_id_30' => 'integer', 'district_manager_id_31' => 'integer', 'sales_manager_id_32' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'rw' => 'record', ], ], 'metaMappings' => [ 2 => [ 'worker_id_27' => 'worker_id', 'worker_data_id_28' => 'worker_data_id', 'market_number_29' => 'market_number', 'user_id_30' => 'user_id', 'district_manager_id_31' => 'district_manager_id', 'sales_manager_id_32' => 'sales_manager_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_1' => 'rw', 'start_2' => 'rw', 'end_3' => 'rw', 'status_4' => 'rw', 'pause_5' => 'rw', 'date_6' => 'rw', 'bonus_7' => 'rw', 'type_8' => 'rw', 'is_signature_visible_9' => 'rw', 'longitude_start_10' => 'rw', 'longitude_end_11' => 'rw', 'latitude_start_12' => 'rw', 'latitude_end_13' => 'rw', 'created_at_14' => 'rw', 'number_15' => 'm', 'postcode_16' => 'm', 'city_17' => 'm', 'address_18' => 'm', 'manager_19' => 'm', 'ordering_rate_20' => 'm', 'team_21' => 'm', 'rila_number_22' => 'm', 'newspapers_23' => 'm', 'weekly_paper_24' => 'm', 'km_district_25' => 'm', 'travel_cost_26' => 'm', 'worker_id_27' => 'rw', 'worker_data_id_28' => 'rw', 'market_number_29' => 'rw', 'user_id_30' => 'rw', 'district_manager_id_31' => 'm', 'sales_manager_id_32' => 'm', ], ], 'declaringClasses' => [ 2 => [ 'id_1' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'start_2' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'end_3' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'status_4' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'pause_5' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'date_6' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'bonus_7' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'type_8' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'is_signature_visible_9' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'longitude_start_10' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'longitude_end_11' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'latitude_start_12' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'latitude_end_13' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'created_at_14' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'number_15' => 'Emgmbh\\MarketBundle\\Entity\\Market', 'postcode_16' => 'Emgmbh\\MarketBundle\\Entity\\Market', 'city_17' => 'Emgmbh\\MarketBundle\\Entity\\Market', 'address_18' => 'Emgmbh\\MarketBundle\\Entity\\Market', 'manager_19' => 'Emgmbh\\MarketBundle\\Entity\\Market', 'ordering_rate_20' => 'Emgmbh\\MarketBundle\\Entity\\Market', 'team_21' => 'Emgmbh\\MarketBundle\\Entity\\Market', 'rila_number_22' => 'Emgmbh\\MarketBundle\\Entity\\Market', 'newspapers_23' => 'Emgmbh\\MarketBundle\\Entity\\Market', 'weekly_paper_24' => 'Emgmbh\\MarketBundle\\Entity\\Market', 'km_district_25' => 'Emgmbh\\MarketBundle\\Entity\\Market', 'travel_cost_26' => 'Emgmbh\\MarketBundle\\Entity\\Market', ], ], ], ], $o[0], [] ); }];