<?php //%255B0ad5fffe3958f977a37375660b476f04%255D%255B1%255D

return [PHP_INT_MAX, static function () { return \Symfony\Component\VarExporter\Internal\Hydrator::hydrate(
    $o = [
        clone (($p = &\Symfony\Component\VarExporter\Internal\Registry::$prototypes)['Doctrine\\ORM\\Query\\ParserResult'] ?? \Symfony\Component\VarExporter\Internal\Registry::p('Doctrine\\ORM\\Query\\ParserResult')),
        clone ($p['Doctrine\\ORM\\Query\\Exec\\SingleSelectExecutor'] ?? \Symfony\Component\VarExporter\Internal\Registry::p('Doctrine\\ORM\\Query\\Exec\\SingleSelectExecutor')),
        clone ($p['Doctrine\\ORM\\Query\\ResultSetMapping'] ?? \Symfony\Component\VarExporter\Internal\Registry::p('Doctrine\\ORM\\Query\\ResultSetMapping')),
    ],
    null,
    [
        'Doctrine\\ORM\\Query\\ParserResult' => [
            '_sqlExecutor' => [
                $o[1],
            ],
            '_resultSetMapping' => [
                $o[2],
            ],
            '_parameterMappings' => [
                [
                    'rila' => [
                        0,
                        2,
                    ],
                    'typeRewe' => [
                        1,
                    ],
                    'typeRila' => [
                        3,
                    ],
                    'year' => [
                        4,
                        6,
                    ],
                    'month' => [
                        5,
                        7,
                    ],
                    'active' => [
                        8,
                    ],
                ],
            ],
        ],
        'Doctrine\\ORM\\Query\\Exec\\AbstractSqlExecutor' => [
            '_sqlStatements' => [
                1 => 'SELECT MAX(w0_.id) AS sclr_0, r1_.sickness_cash AS sickness_cash_1, r1_.holiday_cash AS holiday_cash_2, SUM(IF((r2_.status REGEXP \'^-?[0-9]+$\') = 1, r2_.status, 0)) / 60 AS sclr_3, SUM(IF(SUBSTRING(m3_.number FROM 1 FOR 1) <> ? AND r2_.type = ?, IF(w4_.position LIKE \'%zzt%\', r2_.bonus * IF(r5_.newspapers > 0, m3_.newspapers, m3_.weekly_paper), r2_.bonus), 0)) AS sclr_4, SUM(IF(SUBSTRING(m3_.number FROM 1 FOR 1) = ? AND r2_.type = ?, (r2_.bonus / w0_.hourly_rate_rila_carton - ((TIME_TO_SEC(TIMEDIFF(r2_.end, r2_.start)) - (r2_.pause) * 60) / 3600.0)) * w0_.hourly_rate, 0)) AS sclr_5, SUM((TIME_TO_SEC(TIMEDIFF(r2_.end, r2_.start)) - (r2_.pause) * 60) / 3600.0) AS sclr_6, SUM(IF(r2_.start < \'06:00\' AND r2_.market_number <> 9000, (TIME_TO_SEC(TIMEDIFF(\'06:00\', r2_.start)) - IF(r2_.end < \'06:00\', TIME_TO_SEC(TIMEDIFF(\'06:00\', r2_.end)), 0)) / 3600 * w0_.hourly_rate * 0.1, 0)) AS sclr_7, SUM(IF(r2_.start < \'06:00\' AND r2_.market_number <> 9000, (TIME_TO_SEC(TIMEDIFF(\'06:00\', r2_.start)) - IF(r2_.end < \'06:00\', TIME_TO_SEC(TIMEDIFF(\'06:00\', r2_.end)), 0)) / 3600.0, 0)) AS sclr_8, w4_.id AS id_9, w4_.first_name AS first_name_10, w4_.last_name AS last_name_11, w4_.birthday AS birthday_12, w4_.number AS number_13, w4_.team AS team_14, w4_.last_day AS last_day_15, w0_.id AS id_16, w0_.hourly_rate AS hourly_rate_17, w0_.holiday_length AS holiday_length_18, w0_.holiday_overdue AS holiday_overdue_19, w0_.holiday_used AS holiday_used_20, w0_.employment_type AS employment_type_21, w0_.execution_limit AS execution_limit_22, w0_.payment AS payment_23 FROM worker w4_ LEFT JOIN record_worker r2_ ON (r2_.worker_id = w4_.id AND YEAR(r2_.date) = ? AND MONTH(r2_.date) = ?) LEFT JOIN worker_data w0_ ON (w0_.id = r2_.worker_data_id) LEFT JOIN market m3_ ON r2_.market_number = m3_.number LEFT JOIN record_market r5_ ON (r5_.market_number = r2_.market_number AND r5_.date = r2_.date) LEFT JOIN report_worker r1_ ON (r1_.worker_id = w4_.id AND r1_.year = ? AND r1_.month = ?) WHERE w4_.is_active = ? AND w4_.team IN (\'0000\') GROUP BY w4_.id ORDER BY w4_.team DESC, w4_.number ASC',
            ],
        ],
        'stdClass' => [
            'isMixed' => [
                2 => true,
            ],
            'aliasMap' => [
                2 => [
                    'w' => 'Emgmbh\\UserBundle\\Entity\\Worker',
                    'wd' => 'Emgmbh\\UserBundle\\Entity\\WorkerData',
                ],
            ],
            'fieldMappings' => [
                2 => [
                    'id_9' => 'id',
                    'first_name_10' => 'firstName',
                    'last_name_11' => 'lastName',
                    'birthday_12' => 'birthday',
                    'number_13' => 'number',
                    'team_14' => 'team',
                    'last_day_15' => 'lastDay',
                    'id_16' => 'id',
                    'hourly_rate_17' => 'hourlyRate',
                    'holiday_length_18' => 'holidayLength',
                    'holiday_overdue_19' => 'holidayOverdue',
                    'holiday_used_20' => 'holidayUsed',
                    'employment_type_21' => 'employmentType',
                    'execution_limit_22' => 'executionLimit',
                    'payment_23' => 'payment',
                ],
            ],
            'scalarMappings' => [
                2 => [
                    'sclr_0' => 'lastWorkerDataId',
                    'sickness_cash_1' => 'sicknessCash',
                    'holiday_cash_2' => 'holidayCash',
                    'sclr_3' => 'travelTime',
                    'sclr_4' => 'bonus',
                    'sclr_5' => 'rilaCarton',
                    'sclr_6' => 'worktime',
                    'sclr_7' => 'nightWorktimeSum',
                    'sclr_8' => 'nightWorktimeSumHours',
                ],
            ],
            'typeMappings' => [
                2 => [
                    'sclr_0' => 'string',
                    'sickness_cash_1' => 'float',
                    'holiday_cash_2' => 'float',
                    'sclr_3' => 'string',
                    'sclr_4' => 'string',
                    'sclr_5' => 'string',
                    'sclr_6' => 'string',
                    'sclr_7' => 'string',
                    'sclr_8' => 'string',
                ],
            ],
            'entityMappings' => [
                2 => [
                    'w' => 'worker',
                    'wd' => 'workerData',
                ],
            ],
            'columnOwnerMap' => [
                2 => [
                    'id_9' => 'w',
                    'first_name_10' => 'w',
                    'last_name_11' => 'w',
                    'birthday_12' => 'w',
                    'number_13' => 'w',
                    'team_14' => 'w',
                    'last_day_15' => 'w',
                    'id_16' => 'wd',
                    'hourly_rate_17' => 'wd',
                    'holiday_length_18' => 'wd',
                    'holiday_overdue_19' => 'wd',
                    'holiday_used_20' => 'wd',
                    'employment_type_21' => 'wd',
                    'execution_limit_22' => 'wd',
                    'payment_23' => 'wd',
                ],
            ],
            'declaringClasses' => [
                2 => [
                    'id_9' => 'Emgmbh\\UserBundle\\Entity\\Worker',
                    'first_name_10' => 'Emgmbh\\UserBundle\\Entity\\Worker',
                    'last_name_11' => 'Emgmbh\\UserBundle\\Entity\\Worker',
                    'birthday_12' => 'Emgmbh\\UserBundle\\Entity\\Worker',
                    'number_13' => 'Emgmbh\\UserBundle\\Entity\\Worker',
                    'team_14' => 'Emgmbh\\UserBundle\\Entity\\Worker',
                    'last_day_15' => 'Emgmbh\\UserBundle\\Entity\\Worker',
                    'id_16' => 'Emgmbh\\UserBundle\\Entity\\WorkerData',
                    'hourly_rate_17' => 'Emgmbh\\UserBundle\\Entity\\WorkerData',
                    'holiday_length_18' => 'Emgmbh\\UserBundle\\Entity\\WorkerData',
                    'holiday_overdue_19' => 'Emgmbh\\UserBundle\\Entity\\WorkerData',
                    'holiday_used_20' => 'Emgmbh\\UserBundle\\Entity\\WorkerData',
                    'employment_type_21' => 'Emgmbh\\UserBundle\\Entity\\WorkerData',
                    'execution_limit_22' => 'Emgmbh\\UserBundle\\Entity\\WorkerData',
                    'payment_23' => 'Emgmbh\\UserBundle\\Entity\\WorkerData',
                ],
            ],
        ],
    ],
    $o[0],
    []
); }];
