[ 'sql' => [ 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_.number AS number_6, k0_.budget AS budget_7, k0_.time_budget AS time_budget_8, k0_.budget_type AS budget_type_9, k0_.color AS color_10, k0_.created_at AS created_at_11, k1_.id AS id_12, k1_.name AS name_13, k1_.order_number AS order_number_14, k1_.order_date AS order_date_15, k1_.start AS start_16, k1_.end AS end_17, k1_.locked_until AS locked_until_18, k1_.timezone AS timezone_19, k1_.comment AS comment_20, k1_.visible AS visible_21, k1_.billable AS billable_22, k1_.invoice_text AS invoice_text_23, k1_.global_activities AS global_activities_24, k1_.number AS number_25, k1_.budget AS budget_26, k1_.time_budget AS time_budget_27, k1_.budget_type AS budget_type_28, k1_.color AS color_29, k1_.created_at AS created_at_30, k2_.id AS id_31, k2_.name AS name_32, k2_.number AS number_33, k2_.comment AS comment_34, k2_.visible AS visible_35, k2_.billable AS billable_36, k2_.company AS company_37, k2_.vat_id AS vat_id_38, k2_.contact AS contact_39, k2_.address AS address_40, k2_.country AS country_41, k2_.language AS language_42, k2_.currency AS currency_43, k2_.phone AS phone_44, k2_.fax AS fax_45, k2_.mobile AS mobile_46, k2_.email AS email_47, k2_.homepage AS homepage_48, k2_.timezone AS timezone_49, k2_.invoice_text AS invoice_text_50, k2_.address_line1 AS address_line1_51, k2_.address_line2 AS address_line2_52, k2_.address_line3 AS address_line3_53, k2_.postcode AS postcode_54, k2_.city AS city_55, k2_.invoice_email AS invoice_email_56, k2_.buyer_reference AS buyer_reference_57, k2_.budget AS budget_58, k2_.time_budget AS time_budget_59, k2_.budget_type AS budget_type_60, k2_.color AS color_61, k2_.created_at AS created_at_62, k0_.project_id AS project_id_63, k1_.customer_id AS customer_id_64, k2_.invoice_template_id AS invoice_template_id_65 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_.id IN (?) OR (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', 'number_6' => 'number', 'budget_7' => 'budget', 'time_budget_8' => 'timeBudget', 'budget_type_9' => 'budgetType', 'color_10' => 'color', 'created_at_11' => 'createdAt', 'id_12' => 'id', 'name_13' => 'name', 'order_number_14' => 'orderNumber', 'order_date_15' => 'orderDate', 'start_16' => 'start', 'end_17' => 'end', 'locked_until_18' => 'lockedUntil', 'timezone_19' => 'timezone', 'comment_20' => 'comment', 'visible_21' => 'visible', 'billable_22' => 'billable', 'invoice_text_23' => 'invoiceText', 'global_activities_24' => 'globalActivities', 'number_25' => 'number', 'budget_26' => 'budget', 'time_budget_27' => 'timeBudget', 'budget_type_28' => 'budgetType', 'color_29' => 'color', 'created_at_30' => 'createdAt', 'id_31' => 'id', 'name_32' => 'name', 'number_33' => 'number', 'comment_34' => 'comment', 'visible_35' => 'visible', 'billable_36' => 'billable', 'company_37' => 'company', 'vat_id_38' => 'vatId', 'contact_39' => 'contact', 'address_40' => 'address', 'country_41' => 'country', 'language_42' => 'language', 'currency_43' => 'currency', 'phone_44' => 'phone', 'fax_45' => 'fax', 'mobile_46' => 'mobile', 'email_47' => 'email', 'homepage_48' => 'homepage', 'timezone_49' => 'timezone', 'invoice_text_50' => 'invoiceText', 'address_line1_51' => 'addressLine1', 'address_line2_52' => 'addressLine2', 'address_line3_53' => 'addressLine3', 'postcode_54' => 'postCode', 'city_55' => 'city', 'invoice_email_56' => 'invoiceEmail', 'buyer_reference_57' => 'buyerReference', 'budget_58' => 'budget', 'time_budget_59' => 'timeBudget', 'budget_type_60' => 'budgetType', 'color_61' => 'color', 'created_at_62' => 'createdAt', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\Activity' => [ 'a' => [ 'id' => 'id_0', 'name' => 'name_1', 'comment' => 'comment_2', 'visible' => 'visible_3', 'billable' => 'billable_4', 'invoiceText' => 'invoice_text_5', 'number' => 'number_6', 'budget' => 'budget_7', 'timeBudget' => 'time_budget_8', 'budgetType' => 'budget_type_9', 'color' => 'color_10', 'createdAt' => 'created_at_11', ], ], 'App\\Entity\\Project' => [ 'p' => [ 'id' => 'id_12', 'name' => 'name_13', 'orderNumber' => 'order_number_14', 'orderDate' => 'order_date_15', 'start' => 'start_16', 'end' => 'end_17', 'lockedUntil' => 'locked_until_18', 'timezone' => 'timezone_19', 'comment' => 'comment_20', 'visible' => 'visible_21', 'billable' => 'billable_22', 'invoiceText' => 'invoice_text_23', 'globalActivities' => 'global_activities_24', 'number' => 'number_25', 'budget' => 'budget_26', 'timeBudget' => 'time_budget_27', 'budgetType' => 'budget_type_28', 'color' => 'color_29', 'createdAt' => 'created_at_30', ], ], 'App\\Entity\\Customer' => [ 'c' => [ 'id' => 'id_31', 'name' => 'name_32', 'number' => 'number_33', 'comment' => 'comment_34', 'visible' => 'visible_35', 'billable' => 'billable_36', 'company' => 'company_37', 'vatId' => 'vat_id_38', 'contact' => 'contact_39', 'address' => 'address_40', 'country' => 'country_41', 'language' => 'language_42', 'currency' => 'currency_43', 'phone' => 'phone_44', 'fax' => 'fax_45', 'mobile' => 'mobile_46', 'email' => 'email_47', 'homepage' => 'homepage_48', 'timezone' => 'timezone_49', 'invoiceText' => 'invoice_text_50', 'addressLine1' => 'address_line1_51', 'addressLine2' => 'address_line2_52', 'addressLine3' => 'address_line3_53', 'postCode' => 'postcode_54', 'city' => 'city_55', 'invoiceEmail' => 'invoice_email_56', 'buyerReference' => 'buyer_reference_57', 'budget' => 'budget_58', 'timeBudget' => 'time_budget_59', 'budgetType' => 'budget_type_60', 'color' => 'color_61', 'createdAt' => 'created_at_62', ], ], ], ], 'typeMappings' => [ 2 => [ 'project_id_63' => 'integer', 'customer_id_64' => 'integer', 'invoice_template_id_65' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'a' => null, ], ], 'metaMappings' => [ 2 => [ 'project_id_63' => 'project_id', 'customer_id_64' => 'customer_id', 'invoice_template_id_65' => 'invoice_template_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'a', 'name_1' => 'a', 'comment_2' => 'a', 'visible_3' => 'a', 'billable_4' => 'a', 'invoice_text_5' => 'a', 'number_6' => 'a', 'budget_7' => 'a', 'time_budget_8' => 'a', 'budget_type_9' => 'a', 'color_10' => 'a', 'created_at_11' => 'a', 'id_12' => 'p', 'name_13' => 'p', 'order_number_14' => 'p', 'order_date_15' => 'p', 'start_16' => 'p', 'end_17' => 'p', 'locked_until_18' => 'p', 'timezone_19' => 'p', 'comment_20' => 'p', 'visible_21' => 'p', 'billable_22' => 'p', 'invoice_text_23' => 'p', 'global_activities_24' => 'p', 'number_25' => 'p', 'budget_26' => 'p', 'time_budget_27' => 'p', 'budget_type_28' => 'p', 'color_29' => 'p', 'created_at_30' => 'p', 'id_31' => 'c', 'name_32' => 'c', 'number_33' => 'c', 'comment_34' => 'c', 'visible_35' => 'c', 'billable_36' => 'c', 'company_37' => 'c', 'vat_id_38' => 'c', 'contact_39' => 'c', 'address_40' => 'c', 'country_41' => 'c', 'language_42' => 'c', 'currency_43' => 'c', 'phone_44' => 'c', 'fax_45' => 'c', 'mobile_46' => 'c', 'email_47' => 'c', 'homepage_48' => 'c', 'timezone_49' => 'c', 'invoice_text_50' => 'c', 'address_line1_51' => 'c', 'address_line2_52' => 'c', 'address_line3_53' => 'c', 'postcode_54' => 'c', 'city_55' => 'c', 'invoice_email_56' => 'c', 'buyer_reference_57' => 'c', 'budget_58' => 'c', 'time_budget_59' => 'c', 'budget_type_60' => 'c', 'color_61' => 'c', 'created_at_62' => 'c', 'project_id_63' => 'a', 'customer_id_64' => 'p', 'invoice_template_id_65' => 'c', ], ], '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', 'number_6' => 'App\\Entity\\Activity', 'budget_7' => 'App\\Entity\\Activity', 'time_budget_8' => 'App\\Entity\\Activity', 'budget_type_9' => 'App\\Entity\\Activity', 'color_10' => 'App\\Entity\\Activity', 'created_at_11' => 'App\\Entity\\Activity', 'id_12' => 'App\\Entity\\Project', 'name_13' => 'App\\Entity\\Project', 'order_number_14' => 'App\\Entity\\Project', 'order_date_15' => 'App\\Entity\\Project', 'start_16' => 'App\\Entity\\Project', 'end_17' => 'App\\Entity\\Project', 'locked_until_18' => 'App\\Entity\\Project', 'timezone_19' => 'App\\Entity\\Project', 'comment_20' => 'App\\Entity\\Project', 'visible_21' => 'App\\Entity\\Project', 'billable_22' => 'App\\Entity\\Project', 'invoice_text_23' => 'App\\Entity\\Project', 'global_activities_24' => 'App\\Entity\\Project', 'number_25' => 'App\\Entity\\Project', 'budget_26' => 'App\\Entity\\Project', 'time_budget_27' => 'App\\Entity\\Project', 'budget_type_28' => 'App\\Entity\\Project', 'color_29' => 'App\\Entity\\Project', 'created_at_30' => 'App\\Entity\\Project', 'id_31' => 'App\\Entity\\Customer', 'name_32' => 'App\\Entity\\Customer', 'number_33' => 'App\\Entity\\Customer', 'comment_34' => 'App\\Entity\\Customer', 'visible_35' => 'App\\Entity\\Customer', 'billable_36' => 'App\\Entity\\Customer', 'company_37' => 'App\\Entity\\Customer', 'vat_id_38' => 'App\\Entity\\Customer', 'contact_39' => 'App\\Entity\\Customer', 'address_40' => 'App\\Entity\\Customer', 'country_41' => 'App\\Entity\\Customer', 'language_42' => 'App\\Entity\\Customer', 'currency_43' => 'App\\Entity\\Customer', 'phone_44' => 'App\\Entity\\Customer', 'fax_45' => 'App\\Entity\\Customer', 'mobile_46' => 'App\\Entity\\Customer', 'email_47' => 'App\\Entity\\Customer', 'homepage_48' => 'App\\Entity\\Customer', 'timezone_49' => 'App\\Entity\\Customer', 'invoice_text_50' => 'App\\Entity\\Customer', 'address_line1_51' => 'App\\Entity\\Customer', 'address_line2_52' => 'App\\Entity\\Customer', 'address_line3_53' => 'App\\Entity\\Customer', 'postcode_54' => 'App\\Entity\\Customer', 'city_55' => 'App\\Entity\\Customer', 'invoice_email_56' => 'App\\Entity\\Customer', 'buyer_reference_57' => 'App\\Entity\\Customer', 'budget_58' => 'App\\Entity\\Customer', 'time_budget_59' => 'App\\Entity\\Customer', 'budget_type_60' => 'App\\Entity\\Customer', 'color_61' => 'App\\Entity\\Customer', 'created_at_62' => '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' => [ 'activity' => [ 0, ], 'visible' => [ 1, ], 'is_visible' => [ 2, 3, ], 'project' => [ 4, ], ], ], ] ); } }];