[ '_sqlExecutor' => [ $o[1], ], '_resultSetMapping' => [ $o[2], ], '_parameterMappings' => [ [ 'firstDay' => [ 0, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\AbstractSqlExecutor' => [ '_sqlStatements' => [ 1 => 'SELECT CONCAT(m0_.number, \',\', m1_.number) AS sclr_0, CONCAT(r2_.date, \' \', MAX(r2_.end)) AS sclr_1, CONCAT(r3_.date, \' \', MIN(r3_.start)) AS sclr_2, TIME_TO_SEC(TIMEDIFF(CONCAT(r3_.date, \' \', MIN(r3_.start)), CONCAT(r2_.date, \' \', MAX(r2_.end)))) / 3600 AS sclr_3, r2_.id AS id_4, r2_.start AS start_5, r2_.end AS end_6, r2_.status AS status_7, r2_.pause AS pause_8, r2_.date AS date_9, r2_.bonus AS bonus_10, r2_.type AS type_11, r2_.is_signature_visible AS is_signature_visible_12, r2_.longitude_start AS longitude_start_13, r2_.longitude_end AS longitude_end_14, r2_.latitude_start AS latitude_start_15, r2_.latitude_end AS latitude_end_16, r2_.created_at AS created_at_17, w4_.id AS id_18, w4_.first_name AS first_name_19, w4_.last_name AS last_name_20, w4_.salutation AS salutation_21, w4_.position AS position_22, w4_.first_aid AS first_aid_23, w4_.first_aid_limited_to AS first_aid_limited_to_24, w4_.postcode AS postcode_25, w4_.city AS city_26, w4_.address AS address_27, w4_.birthday AS birthday_28, w4_.birthday_city AS birthday_city_29, w4_.social_security_number AS social_security_number_30, w4_.pensioner AS pensioner_31, w4_.pension_type AS pension_type_32, w4_.number AS number_33, w4_.team AS team_34, w4_.first_day AS first_day_35, w4_.last_day AS last_day_36, w4_.term_contract_amount AS term_contract_amount_37, w4_.phone AS phone_38, w4_.email AS email_39, w4_.is_active AS is_active_40, w4_.pin AS pin_41, w4_.limited_to AS limited_to_42, w4_.activated_at AS activated_at_43, r2_.worker_id AS worker_id_44, r2_.worker_data_id AS worker_data_id_45, r2_.market_number AS market_number_46, r2_.user_id AS user_id_47, w4_.country_id AS country_id_48 FROM record_worker r2_ INNER JOIN worker w4_ ON r2_.worker_id = w4_.id INNER JOIN market m0_ ON r2_.market_number = m0_.number INNER JOIN record_worker r3_ ON (DATEDIFF(r3_.date, r2_.date) = 1 AND r2_.worker_id = r3_.worker_id AND r3_.status NOT IN (\'U\', \'K\', \'F\', \'H\')) INNER JOIN market m1_ ON r3_.market_number = m1_.number WHERE r2_.status NOT IN (\'U\', \'K\', \'F\', \'H\') AND r2_.date >= ? GROUP BY r2_.date, r2_.worker_id HAVING sclr_3 < 11 AND sclr_3 > 0.02', ], ], 'stdClass' => [ 'isMixed' => [ 2 => true, ], 'aliasMap' => [ 2 => [ 'rw1' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'w' => 'Emgmbh\\UserBundle\\Entity\\Worker', ], ], 'relationMap' => [ 2 => [ 'w' => 'worker', ], ], 'parentAliasMap' => [ 2 => [ 'w' => 'rw1', ], ], 'fieldMappings' => [ 2 => [ 'id_4' => 'id', 'start_5' => 'start', 'end_6' => 'end', 'status_7' => 'status', 'pause_8' => 'pause', 'date_9' => 'date', 'bonus_10' => 'bonus', 'type_11' => 'type', 'is_signature_visible_12' => 'isSignatureVisible', 'longitude_start_13' => 'longitudeStart', 'longitude_end_14' => 'longitudeEnd', 'latitude_start_15' => 'latitudeStart', 'latitude_end_16' => 'latitudeEnd', 'created_at_17' => 'createdAt', 'id_18' => 'id', 'first_name_19' => 'firstName', 'last_name_20' => 'lastName', 'salutation_21' => 'salutation', 'position_22' => 'position', 'first_aid_23' => 'firstAid', 'first_aid_limited_to_24' => 'firstAidLimitedTo', 'postcode_25' => 'postcode', 'city_26' => 'city', 'address_27' => 'address', 'birthday_28' => 'birthday', 'birthday_city_29' => 'birthdayCity', 'social_security_number_30' => 'socialSecurityNumber', 'pensioner_31' => 'pensioner', 'pension_type_32' => 'pensionType', 'number_33' => 'number', 'team_34' => 'team', 'first_day_35' => 'firstDay', 'last_day_36' => 'lastDay', 'term_contract_amount_37' => 'termContractAmount', 'phone_38' => 'phone', 'email_39' => 'email', 'is_active_40' => 'isActive', 'pin_41' => 'pin', 'limited_to_42' => 'limitedTo', 'activated_at_43' => 'activatedAt', ], ], 'scalarMappings' => [ 2 => [ 'sclr_0' => 'markets', 'sclr_1' => 'start_date', 'sclr_2' => 'end_date', 'sclr_3' => 'resttime', ], ], 'typeMappings' => [ 2 => [ 'sclr_0' => 'string', 'sclr_1' => 'string', 'sclr_2' => 'string', 'sclr_3' => 'string', 'worker_id_44' => 'integer', 'worker_data_id_45' => 'integer', 'market_number_46' => 'string', 'user_id_47' => 'integer', 'country_id_48' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'rw1' => 'record', ], ], 'metaMappings' => [ 2 => [ 'worker_id_44' => 'worker_id', 'worker_data_id_45' => 'worker_data_id', 'market_number_46' => 'market_number', 'user_id_47' => 'user_id', 'country_id_48' => 'country_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_4' => 'rw1', 'start_5' => 'rw1', 'end_6' => 'rw1', 'status_7' => 'rw1', 'pause_8' => 'rw1', 'date_9' => 'rw1', 'bonus_10' => 'rw1', 'type_11' => 'rw1', 'is_signature_visible_12' => 'rw1', 'longitude_start_13' => 'rw1', 'longitude_end_14' => 'rw1', 'latitude_start_15' => 'rw1', 'latitude_end_16' => 'rw1', 'created_at_17' => 'rw1', 'id_18' => 'w', 'first_name_19' => 'w', 'last_name_20' => 'w', 'salutation_21' => 'w', 'position_22' => 'w', 'first_aid_23' => 'w', 'first_aid_limited_to_24' => 'w', 'postcode_25' => 'w', 'city_26' => 'w', 'address_27' => 'w', 'birthday_28' => 'w', 'birthday_city_29' => 'w', 'social_security_number_30' => 'w', 'pensioner_31' => 'w', 'pension_type_32' => 'w', 'number_33' => 'w', 'team_34' => 'w', 'first_day_35' => 'w', 'last_day_36' => 'w', 'term_contract_amount_37' => 'w', 'phone_38' => 'w', 'email_39' => 'w', 'is_active_40' => 'w', 'pin_41' => 'w', 'limited_to_42' => 'w', 'activated_at_43' => 'w', 'worker_id_44' => 'rw1', 'worker_data_id_45' => 'rw1', 'market_number_46' => 'rw1', 'user_id_47' => 'rw1', 'country_id_48' => 'w', ], ], 'declaringClasses' => [ 2 => [ 'id_4' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'start_5' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'end_6' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'status_7' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'pause_8' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'date_9' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'bonus_10' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'type_11' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'is_signature_visible_12' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'longitude_start_13' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'longitude_end_14' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'latitude_start_15' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'latitude_end_16' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'created_at_17' => 'Emgmbh\\RecordBundle\\Entity\\RecordWorker', 'id_18' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'first_name_19' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'last_name_20' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'salutation_21' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'position_22' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'first_aid_23' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'first_aid_limited_to_24' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'postcode_25' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'city_26' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'address_27' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'birthday_28' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'birthday_city_29' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'social_security_number_30' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'pensioner_31' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'pension_type_32' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'number_33' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'team_34' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'first_day_35' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'last_day_36' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'term_contract_amount_37' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'phone_38' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'email_39' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'is_active_40' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'pin_41' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'limited_to_42' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'activated_at_43' => 'Emgmbh\\UserBundle\\Entity\\Worker', ], ], ], ], $o[0], [] ); }];