[ '_sqlExecutor' => [ $o[1], ], '_resultSetMapping' => [ $o[2], ], '_parameterMappings' => [ [ 'teams' => [ 0, 1, 2, ], 'visible' => [ 3, ], 'is_visible' => [ 4, 5, ], 'project' => [ 6, ], 'activity' => [ 7, ], ], ], ], '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_.budget AS budget_4, k0_.time_budget AS time_budget_5, k0_.color AS color_6, k1_.id AS id_7, k1_.name AS name_8, k1_.order_number AS order_number_9, k1_.order_date AS order_date_10, k1_.start AS start_11, k1_.end AS end_12, k1_.timezone AS timezone_13, k1_.comment AS comment_14, k1_.visible AS visible_15, k1_.budget AS budget_16, k1_.time_budget AS time_budget_17, k1_.color AS color_18, k2_.id AS id_19, k2_.name AS name_20, k2_.number AS number_21, k2_.comment AS comment_22, k2_.visible AS visible_23, k2_.company AS company_24, k2_.vat_id AS vat_id_25, k2_.contact AS contact_26, k2_.address AS address_27, k2_.country AS country_28, k2_.currency AS currency_29, k2_.phone AS phone_30, k2_.fax AS fax_31, k2_.mobile AS mobile_32, k2_.email AS email_33, k2_.homepage AS homepage_34, k2_.timezone AS timezone_35, k2_.budget AS budget_36, k2_.time_budget AS time_budget_37, k2_.color AS color_38, k0_.project_id AS project_id_39, k1_.customer_id AS customer_id_40 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 ((SELECT COUNT(*) FROM kimai2_activities_teams k3_ WHERE k3_.activity_id = k0_.id) = 0 OR EXISTS (SELECT 1 FROM kimai2_activities_teams k3_ INNER JOIN kimai2_teams k4_ ON k3_.team_id = k4_.id WHERE k3_.activity_id = k0_.id AND k4_.id IN (?))) AND ((SELECT COUNT(*) FROM kimai2_projects_teams k5_ WHERE k5_.project_id = k1_.id) = 0 OR EXISTS (SELECT 1 FROM kimai2_projects_teams k5_ INNER JOIN kimai2_teams k4_ ON k5_.team_id = k4_.id WHERE k5_.project_id = k1_.id AND k4_.id IN (?))) AND ((SELECT COUNT(*) FROM kimai2_customers_teams k6_ WHERE k6_.customer_id = k2_.id) = 0 OR EXISTS (SELECT 1 FROM kimai2_customers_teams k6_ INNER JOIN kimai2_teams k4_ ON k6_.team_id = k4_.id WHERE k6_.customer_id = k2_.id AND k4_.id IN (?))) AND ((k0_.visible = ? AND (k0_.project_id IS NULL OR (k1_.visible = ? AND k2_.visible = ?)) AND (k0_.project_id IS NULL OR k0_.project_id IN (?))) OR k0_.id IN (?)) 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', 'budget_4' => 'budget', 'time_budget_5' => 'timeBudget', 'color_6' => 'color', 'id_7' => 'id', 'name_8' => 'name', 'order_number_9' => 'orderNumber', 'order_date_10' => 'orderDate', 'start_11' => 'start', 'end_12' => 'end', 'timezone_13' => 'timezone', 'comment_14' => 'comment', 'visible_15' => 'visible', 'budget_16' => 'budget', 'time_budget_17' => 'timeBudget', 'color_18' => 'color', 'id_19' => 'id', 'name_20' => 'name', 'number_21' => 'number', 'comment_22' => 'comment', 'visible_23' => 'visible', 'company_24' => 'company', 'vat_id_25' => 'vatId', 'contact_26' => 'contact', 'address_27' => 'address', 'country_28' => 'country', 'currency_29' => 'currency', 'phone_30' => 'phone', 'fax_31' => 'fax', 'mobile_32' => 'mobile', 'email_33' => 'email', 'homepage_34' => 'homepage', 'timezone_35' => 'timezone', 'budget_36' => 'budget', 'time_budget_37' => 'timeBudget', 'color_38' => 'color', ], ], 'typeMappings' => [ 2 => [ 'project_id_39' => 'integer', 'customer_id_40' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'a' => null, ], ], 'metaMappings' => [ 2 => [ 'project_id_39' => 'project_id', 'customer_id_40' => 'customer_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'a', 'name_1' => 'a', 'comment_2' => 'a', 'visible_3' => 'a', 'budget_4' => 'a', 'time_budget_5' => 'a', 'color_6' => 'a', 'id_7' => 'p', 'name_8' => 'p', 'order_number_9' => 'p', 'order_date_10' => 'p', 'start_11' => 'p', 'end_12' => 'p', 'timezone_13' => 'p', 'comment_14' => 'p', 'visible_15' => 'p', 'budget_16' => 'p', 'time_budget_17' => 'p', 'color_18' => 'p', 'id_19' => 'c', 'name_20' => 'c', 'number_21' => 'c', 'comment_22' => 'c', 'visible_23' => 'c', 'company_24' => 'c', 'vat_id_25' => 'c', 'contact_26' => 'c', 'address_27' => 'c', 'country_28' => 'c', 'currency_29' => 'c', 'phone_30' => 'c', 'fax_31' => 'c', 'mobile_32' => 'c', 'email_33' => 'c', 'homepage_34' => 'c', 'timezone_35' => 'c', 'budget_36' => 'c', 'time_budget_37' => 'c', 'color_38' => 'c', 'project_id_39' => 'a', 'customer_id_40' => 'p', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\Activity', 'name_1' => 'App\\Entity\\Activity', 'comment_2' => 'App\\Entity\\Activity', 'visible_3' => 'App\\Entity\\Activity', 'budget_4' => 'App\\Entity\\Activity', 'time_budget_5' => 'App\\Entity\\Activity', 'color_6' => 'App\\Entity\\Activity', 'id_7' => 'App\\Entity\\Project', 'name_8' => 'App\\Entity\\Project', 'order_number_9' => 'App\\Entity\\Project', 'order_date_10' => 'App\\Entity\\Project', 'start_11' => 'App\\Entity\\Project', 'end_12' => 'App\\Entity\\Project', 'timezone_13' => 'App\\Entity\\Project', 'comment_14' => 'App\\Entity\\Project', 'visible_15' => 'App\\Entity\\Project', 'budget_16' => 'App\\Entity\\Project', 'time_budget_17' => 'App\\Entity\\Project', 'color_18' => 'App\\Entity\\Project', 'id_19' => 'App\\Entity\\Customer', 'name_20' => 'App\\Entity\\Customer', 'number_21' => 'App\\Entity\\Customer', 'comment_22' => 'App\\Entity\\Customer', 'visible_23' => 'App\\Entity\\Customer', 'company_24' => 'App\\Entity\\Customer', 'vat_id_25' => 'App\\Entity\\Customer', 'contact_26' => 'App\\Entity\\Customer', 'address_27' => 'App\\Entity\\Customer', 'country_28' => 'App\\Entity\\Customer', 'currency_29' => 'App\\Entity\\Customer', 'phone_30' => 'App\\Entity\\Customer', 'fax_31' => 'App\\Entity\\Customer', 'mobile_32' => 'App\\Entity\\Customer', 'email_33' => 'App\\Entity\\Customer', 'homepage_34' => 'App\\Entity\\Customer', 'timezone_35' => 'App\\Entity\\Customer', 'budget_36' => 'App\\Entity\\Customer', 'time_budget_37' => 'App\\Entity\\Customer', 'color_38' => 'App\\Entity\\Customer', ], ], ], ], $o[0], [] ); }];