[ '_sqlExecutor' => [ $o[1], ], '_resultSetMapping' => [ $o[2], ], '_parameterMappings' => [ [ 'firstDay' => [ 0, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\AbstractSqlExecutor' => [ '_sqlStatements' => [ 1 => 'SELECT GROUP_CONCAT(DISTINCT m0_.number ORDER BY m0_.number ASC) AS sclr_0, SUM((TIME_TO_SEC(r1_.end) - TIME_TO_SEC(r1_.start) - r1_.pause * 60) / 3600) AS sclr_1, r1_.id AS id_2, r1_.start AS start_3, r1_.end AS end_4, r1_.status AS status_5, r1_.pause AS pause_6, r1_.date AS date_7, r1_.bonus AS bonus_8, r1_.type AS type_9, r1_.is_signature_visible AS is_signature_visible_10, r1_.longitude_start AS longitude_start_11, r1_.longitude_end AS longitude_end_12, r1_.latitude_start AS latitude_start_13, r1_.latitude_end AS latitude_end_14, r1_.created_at AS created_at_15, w2_.id AS id_16, w2_.first_name AS first_name_17, w2_.last_name AS last_name_18, w2_.salutation AS salutation_19, w2_.position AS position_20, w2_.first_aid AS first_aid_21, w2_.first_aid_limited_to AS first_aid_limited_to_22, w2_.postcode AS postcode_23, w2_.city AS city_24, w2_.address AS address_25, w2_.birthday AS birthday_26, w2_.birthday_city AS birthday_city_27, w2_.social_security_number AS social_security_number_28, w2_.pensioner AS pensioner_29, w2_.pension_type AS pension_type_30, w2_.number AS number_31, w2_.team AS team_32, w2_.first_day AS first_day_33, w2_.last_day AS last_day_34, w2_.term_contract_amount AS term_contract_amount_35, w2_.phone AS phone_36, w2_.email AS email_37, w2_.is_active AS is_active_38, w2_.pin AS pin_39, w2_.limited_to AS limited_to_40, w2_.activated_at AS activated_at_41, r1_.worker_id AS worker_id_42, r1_.worker_data_id AS worker_data_id_43, r1_.market_number AS market_number_44, r1_.user_id AS user_id_45, w2_.country_id AS country_id_46 FROM record_worker r1_ INNER JOIN worker w2_ ON r1_.worker_id = w2_.id INNER JOIN market m0_ ON r1_.market_number = m0_.number WHERE r1_.status NOT IN (\'U\', \'K\', \'F\', \'H\') AND r1_.date >= ? GROUP BY r1_.date, r1_.worker_id HAVING sclr_1 > 10', ], ], 'stdClass' => [ 'isMixed' => [ 2 => true, ], 'aliasMap' => [ 2 => [ 'rw' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'w' => 'Emgmbh\\UserBundle\\Entity\\Worker', ], ], 'relationMap' => [ 2 => [ 'w' => 'worker', ], ], 'parentAliasMap' => [ 2 => [ 'w' => 'rw', ], ], 'fieldMappings' => [ 2 => [ 'id_2' => 'id', 'start_3' => 'start', 'end_4' => 'end', 'status_5' => 'status', 'pause_6' => 'pause', 'date_7' => 'date', 'bonus_8' => 'bonus', 'type_9' => 'type', 'is_signature_visible_10' => 'isSignatureVisible', 'longitude_start_11' => 'longitudeStart', 'longitude_end_12' => 'longitudeEnd', 'latitude_start_13' => 'latitudeStart', 'latitude_end_14' => 'latitudeEnd', 'created_at_15' => 'createdAt', 'id_16' => 'id', 'first_name_17' => 'firstName', 'last_name_18' => 'lastName', 'salutation_19' => 'salutation', 'position_20' => 'position', 'first_aid_21' => 'firstAid', 'first_aid_limited_to_22' => 'firstAidLimitedTo', 'postcode_23' => 'postcode', 'city_24' => 'city', 'address_25' => 'address', 'birthday_26' => 'birthday', 'birthday_city_27' => 'birthdayCity', 'social_security_number_28' => 'socialSecurityNumber', 'pensioner_29' => 'pensioner', 'pension_type_30' => 'pensionType', 'number_31' => 'number', 'team_32' => 'team', 'first_day_33' => 'firstDay', 'last_day_34' => 'lastDay', 'term_contract_amount_35' => 'termContractAmount', 'phone_36' => 'phone', 'email_37' => 'email', 'is_active_38' => 'isActive', 'pin_39' => 'pin', 'limited_to_40' => 'limitedTo', 'activated_at_41' => 'activatedAt', ], ], 'scalarMappings' => [ 2 => [ 'sclr_0' => 'markets', 'sclr_1' => 'worktime', ], ], 'typeMappings' => [ 2 => [ 'sclr_0' => 'string', 'sclr_1' => 'string', 'worker_id_42' => 'integer', 'worker_data_id_43' => 'integer', 'market_number_44' => 'string', 'user_id_45' => 'integer', 'country_id_46' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'rw' => 'record', ], ], 'metaMappings' => [ 2 => [ 'worker_id_42' => 'worker_id', 'worker_data_id_43' => 'worker_data_id', 'market_number_44' => 'market_number', 'user_id_45' => 'user_id', 'country_id_46' => 'country_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_2' => 'rw', 'start_3' => 'rw', 'end_4' => 'rw', 'status_5' => 'rw', 'pause_6' => 'rw', 'date_7' => 'rw', 'bonus_8' => 'rw', 'type_9' => 'rw', 'is_signature_visible_10' => 'rw', 'longitude_start_11' => 'rw', 'longitude_end_12' => 'rw', 'latitude_start_13' => 'rw', 'latitude_end_14' => 'rw', 'created_at_15' => 'rw', 'id_16' => 'w', 'first_name_17' => 'w', 'last_name_18' => 'w', 'salutation_19' => 'w', 'position_20' => 'w', 'first_aid_21' => 'w', 'first_aid_limited_to_22' => 'w', 'postcode_23' => 'w', 'city_24' => 'w', 'address_25' => 'w', 'birthday_26' => 'w', 'birthday_city_27' => 'w', 'social_security_number_28' => 'w', 'pensioner_29' => 'w', 'pension_type_30' => 'w', 'number_31' => 'w', 'team_32' => 'w', 'first_day_33' => 'w', 'last_day_34' => 'w', 'term_contract_amount_35' => 'w', 'phone_36' => 'w', 'email_37' => 'w', 'is_active_38' => 'w', 'pin_39' => 'w', 'limited_to_40' => 'w', 'activated_at_41' => 'w', 'worker_id_42' => 'rw', 'worker_data_id_43' => 'rw', 'market_number_44' => 'rw', 'user_id_45' => 'rw', 'country_id_46' => 'w', ], ], 'declaringClasses' => [ 2 => [ 'id_2' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'start_3' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'end_4' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'status_5' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'pause_6' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'date_7' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'bonus_8' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'type_9' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'is_signature_visible_10' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'longitude_start_11' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'longitude_end_12' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'latitude_start_13' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'latitude_end_14' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'created_at_15' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'id_16' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'first_name_17' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'last_name_18' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'salutation_19' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'position_20' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'first_aid_21' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'first_aid_limited_to_22' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'postcode_23' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'city_24' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'address_25' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'birthday_26' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'birthday_city_27' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'social_security_number_28' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'pensioner_29' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'pension_type_30' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'number_31' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'team_32' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'first_day_33' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'last_day_34' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'term_contract_amount_35' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'phone_36' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'email_37' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'is_active_38' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'pin_39' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'limited_to_40' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'activated_at_41' => 'Emgmbh\\UserBundle\\Entity\\Worker', ], ], ], ], $o[0], [] ); }];