[ '_sqlExecutor' => [ $o[1], ], '_resultSetMapping' => [ $o[2], ], '_parameterMappings' => [ [ 'project' => [ 0, ], 'visible' => [ 1, ], 'customer_visible' => [ 2, ], 'start' => [ 3, 4, ], 'end' => [ 5, 6, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\AbstractSqlExecutor' => [ '_sqlStatements' => [ 1 => 'SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.order_number AS order_number_2, k0_.order_date AS order_date_3, k0_.start AS start_4, k0_.end AS end_5, k0_.timezone AS timezone_6, k0_.comment AS comment_7, k0_.visible AS visible_8, k0_.billable AS billable_9, k0_.invoice_text AS invoice_text_10, k0_.global_activities AS global_activities_11, k0_.budget AS budget_12, k0_.time_budget AS time_budget_13, k0_.budget_type AS budget_type_14, k0_.color AS color_15, k1_.id AS id_16, k1_.name AS name_17, k1_.number AS number_18, k1_.comment AS comment_19, k1_.visible AS visible_20, k1_.billable AS billable_21, k1_.company AS company_22, k1_.vat_id AS vat_id_23, k1_.contact AS contact_24, k1_.address AS address_25, k1_.country AS country_26, k1_.currency AS currency_27, k1_.phone AS phone_28, k1_.fax AS fax_29, k1_.mobile AS mobile_30, k1_.email AS email_31, k1_.homepage AS homepage_32, k1_.timezone AS timezone_33, k1_.budget AS budget_34, k1_.time_budget AS time_budget_35, k1_.budget_type AS budget_type_36, k1_.color AS color_37, k0_.customer_id AS customer_id_38 FROM kimai2_projects k0_ LEFT JOIN kimai2_customers k1_ ON k0_.customer_id = k1_.id WHERE k0_.id IN (?) OR (k0_.visible = ? AND k1_.visible = ? AND (((k0_.start <= ? OR k0_.start IS NULL) AND (k0_.end >= ? OR k0_.end IS NULL)) AND ((k0_.end >= ? OR k0_.end IS NULL) AND (k0_.start <= ? OR k0_.start IS NULL)))) ORDER BY k1_.name ASC, k0_.name ASC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'p' => 'App\\Entity\\Project', 'c' => 'App\\Entity\\Customer', ], ], 'relationMap' => [ 2 => [ 'c' => 'customer', ], ], 'parentAliasMap' => [ 2 => [ 'c' => 'p', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'name_1' => 'name', 'order_number_2' => 'orderNumber', 'order_date_3' => 'orderDate', 'start_4' => 'start', 'end_5' => 'end', 'timezone_6' => 'timezone', 'comment_7' => 'comment', 'visible_8' => 'visible', 'billable_9' => 'billable', 'invoice_text_10' => 'invoiceText', 'global_activities_11' => 'globalActivities', 'budget_12' => 'budget', 'time_budget_13' => 'timeBudget', 'budget_type_14' => 'budgetType', 'color_15' => 'color', 'id_16' => 'id', 'name_17' => 'name', 'number_18' => 'number', 'comment_19' => 'comment', 'visible_20' => 'visible', 'billable_21' => 'billable', 'company_22' => 'company', 'vat_id_23' => 'vatId', 'contact_24' => 'contact', 'address_25' => 'address', 'country_26' => 'country', 'currency_27' => 'currency', 'phone_28' => 'phone', 'fax_29' => 'fax', 'mobile_30' => 'mobile', 'email_31' => 'email', 'homepage_32' => 'homepage', 'timezone_33' => 'timezone', 'budget_34' => 'budget', 'time_budget_35' => 'timeBudget', 'budget_type_36' => 'budgetType', 'color_37' => 'color', ], ], 'typeMappings' => [ 2 => [ 'customer_id_38' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'p' => null, ], ], 'metaMappings' => [ 2 => [ 'customer_id_38' => 'customer_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'p', 'name_1' => 'p', 'order_number_2' => 'p', 'order_date_3' => 'p', 'start_4' => 'p', 'end_5' => 'p', 'timezone_6' => 'p', 'comment_7' => 'p', 'visible_8' => 'p', 'billable_9' => 'p', 'invoice_text_10' => 'p', 'global_activities_11' => 'p', 'budget_12' => 'p', 'time_budget_13' => 'p', 'budget_type_14' => 'p', 'color_15' => 'p', 'id_16' => 'c', 'name_17' => 'c', 'number_18' => 'c', 'comment_19' => 'c', 'visible_20' => 'c', 'billable_21' => 'c', 'company_22' => 'c', 'vat_id_23' => 'c', 'contact_24' => 'c', 'address_25' => 'c', 'country_26' => 'c', 'currency_27' => 'c', 'phone_28' => 'c', 'fax_29' => 'c', 'mobile_30' => 'c', 'email_31' => 'c', 'homepage_32' => 'c', 'timezone_33' => 'c', 'budget_34' => 'c', 'time_budget_35' => 'c', 'budget_type_36' => 'c', 'color_37' => 'c', 'customer_id_38' => 'p', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\Project', 'name_1' => 'App\\Entity\\Project', 'order_number_2' => 'App\\Entity\\Project', 'order_date_3' => 'App\\Entity\\Project', 'start_4' => 'App\\Entity\\Project', 'end_5' => 'App\\Entity\\Project', 'timezone_6' => 'App\\Entity\\Project', 'comment_7' => 'App\\Entity\\Project', 'visible_8' => 'App\\Entity\\Project', 'billable_9' => 'App\\Entity\\Project', 'invoice_text_10' => 'App\\Entity\\Project', 'global_activities_11' => 'App\\Entity\\Project', 'budget_12' => 'App\\Entity\\Project', 'time_budget_13' => 'App\\Entity\\Project', 'budget_type_14' => 'App\\Entity\\Project', 'color_15' => 'App\\Entity\\Project', 'id_16' => 'App\\Entity\\Customer', 'name_17' => 'App\\Entity\\Customer', 'number_18' => 'App\\Entity\\Customer', 'comment_19' => 'App\\Entity\\Customer', 'visible_20' => 'App\\Entity\\Customer', 'billable_21' => 'App\\Entity\\Customer', 'company_22' => 'App\\Entity\\Customer', 'vat_id_23' => 'App\\Entity\\Customer', 'contact_24' => 'App\\Entity\\Customer', 'address_25' => 'App\\Entity\\Customer', 'country_26' => 'App\\Entity\\Customer', 'currency_27' => 'App\\Entity\\Customer', 'phone_28' => 'App\\Entity\\Customer', 'fax_29' => 'App\\Entity\\Customer', 'mobile_30' => 'App\\Entity\\Customer', 'email_31' => 'App\\Entity\\Customer', 'homepage_32' => 'App\\Entity\\Customer', 'timezone_33' => 'App\\Entity\\Customer', 'budget_34' => 'App\\Entity\\Customer', 'time_budget_35' => 'App\\Entity\\Customer', 'budget_type_36' => 'App\\Entity\\Customer', 'color_37' => 'App\\Entity\\Customer', ], ], ], ], $o[0], [] ); }];