0 a1ee8aaf39afcb63cf7ba9363e48fb35 O:31:"Doctrine\ORM\Query\ParserResult":4:{s:44:"Doctrine\ORM\Query\ParserResultsqlExecutor";N;s:45:"Doctrine\ORM\Query\ParserResultsqlFinalizer";O:48:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizer":1:{s:53:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizersql";s:652:"SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.date AS date_1, o0_.length_hours AS length_hours_2, o0_.length_days AS length_days_3, o0_.status AS status_4, o0_.start_time AS start_time_5, o0_.end_time AS end_time_6, o0_.duration_type AS duration_type_7 FROM ohrm_leave o0_ LEFT JOIN hs_hr_employee h1_ ON o0_.emp_number = h1_.emp_number LEFT JOIN ohrm_leave_type o2_ ON o0_.leave_type_id = o2_.id WHERE o2_.deleted = ? AND o0_.date = ? AND (o0_.status = ? OR o0_.status = ? OR o0_.status = ?) AND h1_.termination_id IS NULL AND h1_.purged_at IS NULL ORDER BY h1_.emp_firstname ASC) dctrn_result) dctrn_table";}s:49:"Doctrine\ORM\Query\ParserResultresultSetMapping";O:35:"Doctrine\ORM\Query\ResultSetMapping":20:{s:7:"isMixed";b:0;s:8:"isSelect";b:1;s:8:"aliasMap";a:1:{s:9:"leaveList";s:22:"OrangeHRM\Entity\Leave";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:8:{s:4:"id_0";s:2:"id";s:6:"date_1";s:4:"date";s:14:"length_hours_2";s:11:"lengthHours";s:13:"length_days_3";s:10:"lengthDays";s:8:"status_4";s:6:"status";s:12:"start_time_5";s:9:"startTime";s:10:"end_time_6";s:7:"endTime";s:15:"duration_type_7";s:12:"durationType";}s:19:"columnAliasMappings";a:1:{s:22:"OrangeHRM\Entity\Leave";a:1:{s:9:"leaveList";a:8:{s:2:"id";s:4:"id_0";s:4:"date";s:6:"date_1";s:11:"lengthHours";s:14:"length_hours_2";s:10:"lengthDays";s:13:"length_days_3";s:6:"status";s:8:"status_4";s:9:"startTime";s:12:"start_time_5";s:7:"endTime";s:10:"end_time_6";s:12:"durationType";s:15:"duration_type_7";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:9:"leaveList";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:8:{s:4:"id_0";s:9:"leaveList";s:6:"date_1";s:9:"leaveList";s:14:"length_hours_2";s:9:"leaveList";s:13:"length_days_3";s:9:"leaveList";s:8:"status_4";s:9:"leaveList";s:12:"start_time_5";s:9:"leaveList";s:10:"end_time_6";s:9:"leaveList";s:15:"duration_type_7";s:9:"leaveList";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:8:{s:4:"id_0";s:22:"OrangeHRM\Entity\Leave";s:6:"date_1";s:22:"OrangeHRM\Entity\Leave";s:14:"length_hours_2";s:22:"OrangeHRM\Entity\Leave";s:13:"length_days_3";s:22:"OrangeHRM\Entity\Leave";s:8:"status_4";s:22:"OrangeHRM\Entity\Leave";s:12:"start_time_5";s:22:"OrangeHRM\Entity\Leave";s:10:"end_time_6";s:22:"OrangeHRM\Entity\Leave";s:15:"duration_type_7";s:22:"OrangeHRM\Entity\Leave";}s:18:"isIdentifierColumn";a:0:{}s:17:"newObjectMappings";a:0:{}s:24:"metadataParameterMapping";a:0:{}s:23:"discriminatorParameters";a:0:{}}s:50:"Doctrine\ORM\Query\ParserResultparameterMappings";a:5:{s:7:"deleted";a:1:{i:0;i:0;}s:4:"date";a:1:{i:0;i:1;}s:7:"pending";a:1:{i:0;i:2;}s:8:"approved";a:1:{i:0;i:3;}s:5:"taken";a:1:{i:0;i:4;}}}