[ 'sql' => [ 1 => 'SELECT k0_.id AS id_0, k0_.date_tz AS date_tz_1, k0_.start_time AS start_time_2, k0_.end_time AS end_time_3, k0_.timezone AS timezone_4, k0_.duration AS duration_5, k0_.break AS break_6, k0_.description AS description_7, k0_.rate AS rate_8, k0_.internal_rate AS internal_rate_9, k0_.fixed_rate AS fixed_rate_10, k0_.hourly_rate AS hourly_rate_11, k0_.exported AS exported_12, k0_.billable AS billable_13, k0_.category AS category_14, k0_.modified_at AS modified_at_15, k1_.id AS id_16, k1_.name AS name_17, k1_.comment AS comment_18, k1_.visible AS visible_19, k1_.billable AS billable_20, k1_.invoice_text AS invoice_text_21, k1_.number AS number_22, k1_.budget AS budget_23, k1_.time_budget AS time_budget_24, k1_.budget_type AS budget_type_25, k1_.color AS color_26, k1_.created_at AS created_at_27, k2_.id AS id_28, k2_.name AS name_29, k2_.order_number AS order_number_30, k2_.order_date AS order_date_31, k2_.start AS start_32, k2_.end AS end_33, k2_.timezone AS timezone_34, k2_.comment AS comment_35, k2_.visible AS visible_36, k2_.billable AS billable_37, k2_.invoice_text AS invoice_text_38, k2_.global_activities AS global_activities_39, k2_.number AS number_40, k2_.budget AS budget_41, k2_.time_budget AS time_budget_42, k2_.budget_type AS budget_type_43, k2_.color AS color_44, k2_.created_at AS created_at_45, k3_.id AS id_46, k3_.name AS name_47, k3_.number AS number_48, k3_.comment AS comment_49, k3_.visible AS visible_50, k3_.billable AS billable_51, k3_.company AS company_52, k3_.vat_id AS vat_id_53, k3_.contact AS contact_54, k3_.address AS address_55, k3_.country AS country_56, k3_.currency AS currency_57, k3_.phone AS phone_58, k3_.fax AS fax_59, k3_.mobile AS mobile_60, k3_.email AS email_61, k3_.homepage AS homepage_62, k3_.timezone AS timezone_63, k3_.invoice_text AS invoice_text_64, k3_.address_line1 AS address_line1_65, k3_.address_line2 AS address_line2_66, k3_.address_line3 AS address_line3_67, k3_.postcode AS postcode_68, k3_.city AS city_69, k3_.buyer_reference AS buyer_reference_70, k3_.budget AS budget_71, k3_.time_budget AS time_budget_72, k3_.budget_type AS budget_type_73, k3_.color AS color_74, k3_.created_at AS created_at_75, k0_.`user` AS user_76, k0_.activity_id AS activity_id_77, k0_.project_id AS project_id_78, k1_.project_id AS project_id_79, k2_.customer_id AS customer_id_80, k3_.invoice_template_id AS invoice_template_id_81 FROM kimai2_timesheet k0_ LEFT JOIN kimai2_activities k1_ ON k0_.activity_id = k1_.id LEFT JOIN kimai2_projects k2_ ON k0_.project_id = k2_.id LEFT JOIN kimai2_customers k3_ ON k2_.customer_id = k3_.id WHERE (k0_.date_tz BETWEEN ? AND ?) AND k0_.user = ? AND k0_.end_time IS NOT NULL', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 't' => 'App\\Entity\\Timesheet', 'a' => 'App\\Entity\\Activity', 'p' => 'App\\Entity\\Project', 'c' => 'App\\Entity\\Customer', ], ], 'relationMap' => [ 2 => [ 'a' => 'activity', 'p' => 'project', 'c' => 'customer', ], ], 'parentAliasMap' => [ 2 => [ 'a' => 't', 'p' => 't', 'c' => 'p', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'date_tz_1' => 'date', 'start_time_2' => 'begin', 'end_time_3' => 'end', 'timezone_4' => 'timezone', 'duration_5' => 'duration', 'break_6' => 'break', 'description_7' => 'description', 'rate_8' => 'rate', 'internal_rate_9' => 'internalRate', 'fixed_rate_10' => 'fixedRate', 'hourly_rate_11' => 'hourlyRate', 'exported_12' => 'exported', 'billable_13' => 'billable', 'category_14' => 'category', 'modified_at_15' => 'modifiedAt', 'id_16' => 'id', 'name_17' => 'name', 'comment_18' => 'comment', 'visible_19' => 'visible', 'billable_20' => 'billable', 'invoice_text_21' => 'invoiceText', 'number_22' => 'number', 'budget_23' => 'budget', 'time_budget_24' => 'timeBudget', 'budget_type_25' => 'budgetType', 'color_26' => 'color', 'created_at_27' => 'createdAt', 'id_28' => 'id', 'name_29' => 'name', 'order_number_30' => 'orderNumber', 'order_date_31' => 'orderDate', 'start_32' => 'start', 'end_33' => 'end', 'timezone_34' => 'timezone', 'comment_35' => 'comment', 'visible_36' => 'visible', 'billable_37' => 'billable', 'invoice_text_38' => 'invoiceText', 'global_activities_39' => 'globalActivities', 'number_40' => 'number', 'budget_41' => 'budget', 'time_budget_42' => 'timeBudget', 'budget_type_43' => 'budgetType', 'color_44' => 'color', 'created_at_45' => 'createdAt', 'id_46' => 'id', 'name_47' => 'name', 'number_48' => 'number', 'comment_49' => 'comment', 'visible_50' => 'visible', 'billable_51' => 'billable', 'company_52' => 'company', 'vat_id_53' => 'vatId', 'contact_54' => 'contact', 'address_55' => 'address', 'country_56' => 'country', 'currency_57' => 'currency', 'phone_58' => 'phone', 'fax_59' => 'fax', 'mobile_60' => 'mobile', 'email_61' => 'email', 'homepage_62' => 'homepage', 'timezone_63' => 'timezone', 'invoice_text_64' => 'invoiceText', 'address_line1_65' => 'addressLine1', 'address_line2_66' => 'addressLine2', 'address_line3_67' => 'addressLine3', 'postcode_68' => 'postCode', 'city_69' => 'city', 'buyer_reference_70' => 'buyerReference', 'budget_71' => 'budget', 'time_budget_72' => 'timeBudget', 'budget_type_73' => 'budgetType', 'color_74' => 'color', 'created_at_75' => 'createdAt', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\Timesheet' => [ 't' => [ 'id' => 'id_0', 'date' => 'date_tz_1', 'begin' => 'start_time_2', 'end' => 'end_time_3', 'timezone' => 'timezone_4', 'duration' => 'duration_5', 'break' => 'break_6', 'description' => 'description_7', 'rate' => 'rate_8', 'internalRate' => 'internal_rate_9', 'fixedRate' => 'fixed_rate_10', 'hourlyRate' => 'hourly_rate_11', 'exported' => 'exported_12', 'billable' => 'billable_13', 'category' => 'category_14', 'modifiedAt' => 'modified_at_15', ], ], 'App\\Entity\\Activity' => [ 'a' => [ 'id' => 'id_16', 'name' => 'name_17', 'comment' => 'comment_18', 'visible' => 'visible_19', 'billable' => 'billable_20', 'invoiceText' => 'invoice_text_21', 'number' => 'number_22', 'budget' => 'budget_23', 'timeBudget' => 'time_budget_24', 'budgetType' => 'budget_type_25', 'color' => 'color_26', 'createdAt' => 'created_at_27', ], ], 'App\\Entity\\Project' => [ 'p' => [ 'id' => 'id_28', 'name' => 'name_29', 'orderNumber' => 'order_number_30', 'orderDate' => 'order_date_31', 'start' => 'start_32', 'end' => 'end_33', 'timezone' => 'timezone_34', 'comment' => 'comment_35', 'visible' => 'visible_36', 'billable' => 'billable_37', 'invoiceText' => 'invoice_text_38', 'globalActivities' => 'global_activities_39', 'number' => 'number_40', 'budget' => 'budget_41', 'timeBudget' => 'time_budget_42', 'budgetType' => 'budget_type_43', 'color' => 'color_44', 'createdAt' => 'created_at_45', ], ], 'App\\Entity\\Customer' => [ 'c' => [ 'id' => 'id_46', 'name' => 'name_47', 'number' => 'number_48', 'comment' => 'comment_49', 'visible' => 'visible_50', 'billable' => 'billable_51', 'company' => 'company_52', 'vatId' => 'vat_id_53', 'contact' => 'contact_54', 'address' => 'address_55', 'country' => 'country_56', 'currency' => 'currency_57', 'phone' => 'phone_58', 'fax' => 'fax_59', 'mobile' => 'mobile_60', 'email' => 'email_61', 'homepage' => 'homepage_62', 'timezone' => 'timezone_63', 'invoiceText' => 'invoice_text_64', 'addressLine1' => 'address_line1_65', 'addressLine2' => 'address_line2_66', 'addressLine3' => 'address_line3_67', 'postCode' => 'postcode_68', 'city' => 'city_69', 'buyerReference' => 'buyer_reference_70', 'budget' => 'budget_71', 'timeBudget' => 'time_budget_72', 'budgetType' => 'budget_type_73', 'color' => 'color_74', 'createdAt' => 'created_at_75', ], ], ], ], 'typeMappings' => [ 2 => [ 'user_76' => 'integer', 'activity_id_77' => 'integer', 'project_id_78' => 'integer', 'project_id_79' => 'integer', 'customer_id_80' => 'integer', 'invoice_template_id_81' => 'integer', ], ], 'entityMappings' => [ 2 => [ 't' => null, ], ], 'metaMappings' => [ 2 => [ 'user_76' => 'user', 'activity_id_77' => 'activity_id', 'project_id_78' => 'project_id', 'project_id_79' => 'project_id', 'customer_id_80' => 'customer_id', 'invoice_template_id_81' => 'invoice_template_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 't', 'date_tz_1' => 't', 'start_time_2' => 't', 'end_time_3' => 't', 'timezone_4' => 't', 'duration_5' => 't', 'break_6' => 't', 'description_7' => 't', 'rate_8' => 't', 'internal_rate_9' => 't', 'fixed_rate_10' => 't', 'hourly_rate_11' => 't', 'exported_12' => 't', 'billable_13' => 't', 'category_14' => 't', 'modified_at_15' => 't', 'id_16' => 'a', 'name_17' => 'a', 'comment_18' => 'a', 'visible_19' => 'a', 'billable_20' => 'a', 'invoice_text_21' => 'a', 'number_22' => 'a', 'budget_23' => 'a', 'time_budget_24' => 'a', 'budget_type_25' => 'a', 'color_26' => 'a', 'created_at_27' => 'a', 'id_28' => 'p', 'name_29' => 'p', 'order_number_30' => 'p', 'order_date_31' => 'p', 'start_32' => 'p', 'end_33' => 'p', 'timezone_34' => 'p', 'comment_35' => 'p', 'visible_36' => 'p', 'billable_37' => 'p', 'invoice_text_38' => 'p', 'global_activities_39' => 'p', 'number_40' => 'p', 'budget_41' => 'p', 'time_budget_42' => 'p', 'budget_type_43' => 'p', 'color_44' => 'p', 'created_at_45' => 'p', 'id_46' => 'c', 'name_47' => 'c', 'number_48' => 'c', 'comment_49' => 'c', 'visible_50' => 'c', 'billable_51' => 'c', 'company_52' => 'c', 'vat_id_53' => 'c', 'contact_54' => 'c', 'address_55' => 'c', 'country_56' => 'c', 'currency_57' => 'c', 'phone_58' => 'c', 'fax_59' => 'c', 'mobile_60' => 'c', 'email_61' => 'c', 'homepage_62' => 'c', 'timezone_63' => 'c', 'invoice_text_64' => 'c', 'address_line1_65' => 'c', 'address_line2_66' => 'c', 'address_line3_67' => 'c', 'postcode_68' => 'c', 'city_69' => 'c', 'buyer_reference_70' => 'c', 'budget_71' => 'c', 'time_budget_72' => 'c', 'budget_type_73' => 'c', 'color_74' => 'c', 'created_at_75' => 'c', 'user_76' => 't', 'activity_id_77' => 't', 'project_id_78' => 't', 'project_id_79' => 'a', 'customer_id_80' => 'p', 'invoice_template_id_81' => 'c', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\Timesheet', 'date_tz_1' => 'App\\Entity\\Timesheet', 'start_time_2' => 'App\\Entity\\Timesheet', 'end_time_3' => 'App\\Entity\\Timesheet', 'timezone_4' => 'App\\Entity\\Timesheet', 'duration_5' => 'App\\Entity\\Timesheet', 'break_6' => 'App\\Entity\\Timesheet', 'description_7' => 'App\\Entity\\Timesheet', 'rate_8' => 'App\\Entity\\Timesheet', 'internal_rate_9' => 'App\\Entity\\Timesheet', 'fixed_rate_10' => 'App\\Entity\\Timesheet', 'hourly_rate_11' => 'App\\Entity\\Timesheet', 'exported_12' => 'App\\Entity\\Timesheet', 'billable_13' => 'App\\Entity\\Timesheet', 'category_14' => 'App\\Entity\\Timesheet', 'modified_at_15' => 'App\\Entity\\Timesheet', 'id_16' => 'App\\Entity\\Activity', 'name_17' => 'App\\Entity\\Activity', 'comment_18' => 'App\\Entity\\Activity', 'visible_19' => 'App\\Entity\\Activity', 'billable_20' => 'App\\Entity\\Activity', 'invoice_text_21' => 'App\\Entity\\Activity', 'number_22' => 'App\\Entity\\Activity', 'budget_23' => 'App\\Entity\\Activity', 'time_budget_24' => 'App\\Entity\\Activity', 'budget_type_25' => 'App\\Entity\\Activity', 'color_26' => 'App\\Entity\\Activity', 'created_at_27' => 'App\\Entity\\Activity', 'id_28' => 'App\\Entity\\Project', 'name_29' => 'App\\Entity\\Project', 'order_number_30' => 'App\\Entity\\Project', 'order_date_31' => 'App\\Entity\\Project', 'start_32' => 'App\\Entity\\Project', 'end_33' => 'App\\Entity\\Project', 'timezone_34' => 'App\\Entity\\Project', 'comment_35' => 'App\\Entity\\Project', 'visible_36' => 'App\\Entity\\Project', 'billable_37' => 'App\\Entity\\Project', 'invoice_text_38' => 'App\\Entity\\Project', 'global_activities_39' => 'App\\Entity\\Project', 'number_40' => 'App\\Entity\\Project', 'budget_41' => 'App\\Entity\\Project', 'time_budget_42' => 'App\\Entity\\Project', 'budget_type_43' => 'App\\Entity\\Project', 'color_44' => 'App\\Entity\\Project', 'created_at_45' => 'App\\Entity\\Project', 'id_46' => 'App\\Entity\\Customer', 'name_47' => 'App\\Entity\\Customer', 'number_48' => 'App\\Entity\\Customer', 'comment_49' => 'App\\Entity\\Customer', 'visible_50' => 'App\\Entity\\Customer', 'billable_51' => 'App\\Entity\\Customer', 'company_52' => 'App\\Entity\\Customer', 'vat_id_53' => 'App\\Entity\\Customer', 'contact_54' => 'App\\Entity\\Customer', 'address_55' => 'App\\Entity\\Customer', 'country_56' => 'App\\Entity\\Customer', 'currency_57' => 'App\\Entity\\Customer', 'phone_58' => 'App\\Entity\\Customer', 'fax_59' => 'App\\Entity\\Customer', 'mobile_60' => 'App\\Entity\\Customer', 'email_61' => 'App\\Entity\\Customer', 'homepage_62' => 'App\\Entity\\Customer', 'timezone_63' => 'App\\Entity\\Customer', 'invoice_text_64' => 'App\\Entity\\Customer', 'address_line1_65' => 'App\\Entity\\Customer', 'address_line2_66' => 'App\\Entity\\Customer', 'address_line3_67' => 'App\\Entity\\Customer', 'postcode_68' => 'App\\Entity\\Customer', 'city_69' => 'App\\Entity\\Customer', 'buyer_reference_70' => 'App\\Entity\\Customer', 'budget_71' => 'App\\Entity\\Customer', 'time_budget_72' => 'App\\Entity\\Customer', 'budget_type_73' => 'App\\Entity\\Customer', 'color_74' => 'App\\Entity\\Customer', 'created_at_75' => 'App\\Entity\\Customer', ], ], ], ], $o[0], [ [ "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'sqlExecutor' => null, "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'sqlFinalizer' => $o[1], "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'resultSetMapping' => $o[2], "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'parameterMappings' => [ 'begin' => [ 0, ], 'end' => [ 1, ], 'user' => [ 2, ], ], ], ] ); } }];