[ '_sqlExecutor' => [ $o[1], ], '_resultSetMapping' => [ $o[2], ], '_parameterMappings' => [ [ 'visible' => [ 0, ], 'is_visible' => [ 1, 2, ], 'project' => [ 3, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\AbstractSqlExecutor' => [ '_sqlStatements' => [ 1 => 'SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.comment AS comment_2, k0_.visible AS visible_3, k0_.billable AS billable_4, k0_.invoice_text AS invoice_text_5, k0_.budget AS budget_6, k0_.time_budget AS time_budget_7, k0_.budget_type AS budget_type_8, k0_.color AS color_9, k1_.id AS id_10, k1_.name AS name_11, k1_.order_number AS order_number_12, k1_.order_date AS order_date_13, k1_.start AS start_14, k1_.end AS end_15, k1_.timezone AS timezone_16, k1_.comment AS comment_17, k1_.visible AS visible_18, k1_.billable AS billable_19, k1_.invoice_text AS invoice_text_20, k1_.global_activities AS global_activities_21, k1_.budget AS budget_22, k1_.time_budget AS time_budget_23, k1_.budget_type AS budget_type_24, k1_.color AS color_25, k2_.id AS id_26, k2_.name AS name_27, k2_.number AS number_28, k2_.comment AS comment_29, k2_.visible AS visible_30, k2_.billable AS billable_31, k2_.company AS company_32, k2_.vat_id AS vat_id_33, k2_.contact AS contact_34, k2_.address AS address_35, k2_.country AS country_36, k2_.currency AS currency_37, k2_.phone AS phone_38, k2_.fax AS fax_39, k2_.mobile AS mobile_40, k2_.email AS email_41, k2_.homepage AS homepage_42, k2_.timezone AS timezone_43, k2_.budget AS budget_44, k2_.time_budget AS time_budget_45, k2_.budget_type AS budget_type_46, k2_.color AS color_47, k0_.project_id AS project_id_48, k1_.customer_id AS customer_id_49 FROM kimai2_activities k0_ LEFT JOIN kimai2_projects k1_ ON k0_.project_id = k1_.id LEFT JOIN kimai2_customers k2_ ON k1_.customer_id = k2_.id WHERE k0_.visible = ? AND (k0_.project_id IS NULL OR (k1_.visible = ? AND k2_.visible = ?)) AND (k0_.project_id IN (?) OR k0_.project_id IS NULL) ORDER BY k0_.project_id DESC, k0_.name ASC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'a' => 'App\\Entity\\Activity', 'p' => 'App\\Entity\\Project', 'c' => 'App\\Entity\\Customer', ], ], 'relationMap' => [ 2 => [ 'p' => 'project', 'c' => 'customer', ], ], 'parentAliasMap' => [ 2 => [ 'p' => 'a', 'c' => 'p', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'name_1' => 'name', 'comment_2' => 'comment', 'visible_3' => 'visible', 'billable_4' => 'billable', 'invoice_text_5' => 'invoiceText', 'budget_6' => 'budget', 'time_budget_7' => 'timeBudget', 'budget_type_8' => 'budgetType', 'color_9' => 'color', 'id_10' => 'id', 'name_11' => 'name', 'order_number_12' => 'orderNumber', 'order_date_13' => 'orderDate', 'start_14' => 'start', 'end_15' => 'end', 'timezone_16' => 'timezone', 'comment_17' => 'comment', 'visible_18' => 'visible', 'billable_19' => 'billable', 'invoice_text_20' => 'invoiceText', 'global_activities_21' => 'globalActivities', 'budget_22' => 'budget', 'time_budget_23' => 'timeBudget', 'budget_type_24' => 'budgetType', 'color_25' => 'color', 'id_26' => 'id', 'name_27' => 'name', 'number_28' => 'number', 'comment_29' => 'comment', 'visible_30' => 'visible', 'billable_31' => 'billable', 'company_32' => 'company', 'vat_id_33' => 'vatId', 'contact_34' => 'contact', 'address_35' => 'address', 'country_36' => 'country', 'currency_37' => 'currency', 'phone_38' => 'phone', 'fax_39' => 'fax', 'mobile_40' => 'mobile', 'email_41' => 'email', 'homepage_42' => 'homepage', 'timezone_43' => 'timezone', 'budget_44' => 'budget', 'time_budget_45' => 'timeBudget', 'budget_type_46' => 'budgetType', 'color_47' => 'color', ], ], 'typeMappings' => [ 2 => [ 'project_id_48' => 'integer', 'customer_id_49' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'a' => null, ], ], 'metaMappings' => [ 2 => [ 'project_id_48' => 'project_id', 'customer_id_49' => 'customer_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'a', 'name_1' => 'a', 'comment_2' => 'a', 'visible_3' => 'a', 'billable_4' => 'a', 'invoice_text_5' => 'a', 'budget_6' => 'a', 'time_budget_7' => 'a', 'budget_type_8' => 'a', 'color_9' => 'a', 'id_10' => 'p', 'name_11' => 'p', 'order_number_12' => 'p', 'order_date_13' => 'p', 'start_14' => 'p', 'end_15' => 'p', 'timezone_16' => 'p', 'comment_17' => 'p', 'visible_18' => 'p', 'billable_19' => 'p', 'invoice_text_20' => 'p', 'global_activities_21' => 'p', 'budget_22' => 'p', 'time_budget_23' => 'p', 'budget_type_24' => 'p', 'color_25' => 'p', 'id_26' => 'c', 'name_27' => 'c', 'number_28' => 'c', 'comment_29' => 'c', 'visible_30' => 'c', 'billable_31' => 'c', 'company_32' => 'c', 'vat_id_33' => 'c', 'contact_34' => 'c', 'address_35' => 'c', 'country_36' => 'c', 'currency_37' => 'c', 'phone_38' => 'c', 'fax_39' => 'c', 'mobile_40' => 'c', 'email_41' => 'c', 'homepage_42' => 'c', 'timezone_43' => 'c', 'budget_44' => 'c', 'time_budget_45' => 'c', 'budget_type_46' => 'c', 'color_47' => 'c', 'project_id_48' => 'a', 'customer_id_49' => 'p', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\Activity', 'name_1' => 'App\\Entity\\Activity', 'comment_2' => 'App\\Entity\\Activity', 'visible_3' => 'App\\Entity\\Activity', 'billable_4' => 'App\\Entity\\Activity', 'invoice_text_5' => 'App\\Entity\\Activity', 'budget_6' => 'App\\Entity\\Activity', 'time_budget_7' => 'App\\Entity\\Activity', 'budget_type_8' => 'App\\Entity\\Activity', 'color_9' => 'App\\Entity\\Activity', 'id_10' => 'App\\Entity\\Project', 'name_11' => 'App\\Entity\\Project', 'order_number_12' => 'App\\Entity\\Project', 'order_date_13' => 'App\\Entity\\Project', 'start_14' => 'App\\Entity\\Project', 'end_15' => 'App\\Entity\\Project', 'timezone_16' => 'App\\Entity\\Project', 'comment_17' => 'App\\Entity\\Project', 'visible_18' => 'App\\Entity\\Project', 'billable_19' => 'App\\Entity\\Project', 'invoice_text_20' => 'App\\Entity\\Project', 'global_activities_21' => 'App\\Entity\\Project', 'budget_22' => 'App\\Entity\\Project', 'time_budget_23' => 'App\\Entity\\Project', 'budget_type_24' => 'App\\Entity\\Project', 'color_25' => 'App\\Entity\\Project', 'id_26' => 'App\\Entity\\Customer', 'name_27' => 'App\\Entity\\Customer', 'number_28' => 'App\\Entity\\Customer', 'comment_29' => 'App\\Entity\\Customer', 'visible_30' => 'App\\Entity\\Customer', 'billable_31' => 'App\\Entity\\Customer', 'company_32' => 'App\\Entity\\Customer', 'vat_id_33' => 'App\\Entity\\Customer', 'contact_34' => 'App\\Entity\\Customer', 'address_35' => 'App\\Entity\\Customer', 'country_36' => 'App\\Entity\\Customer', 'currency_37' => 'App\\Entity\\Customer', 'phone_38' => 'App\\Entity\\Customer', 'fax_39' => 'App\\Entity\\Customer', 'mobile_40' => 'App\\Entity\\Customer', 'email_41' => 'App\\Entity\\Customer', 'homepage_42' => 'App\\Entity\\Customer', 'timezone_43' => 'App\\Entity\\Customer', 'budget_44' => 'App\\Entity\\Customer', 'time_budget_45' => 'App\\Entity\\Customer', 'budget_type_46' => 'App\\Entity\\Customer', 'color_47' => 'App\\Entity\\Customer', ], ], ], ], $o[0], [] ); }];