fixed customer report queries with order_types