duncanmcclean / simple-commerce

A simple, yet powerful e-commerce addon for Statamic.
https://statamic.com/simple-commerce
Other
143 stars 34 forks source link

Dashboard widgets report wrong data while using Eloquent #980

Closed sdussaut closed 5 months ago

sdussaut commented 5 months ago

Description

Hi!

I am using Simple Commerce with the Eloquent driver (sqlite database) for the orders and customers.

It seems there is something wrong with the widgets as:

Thanks!

Steps to reproduce

  1. Have the orders stored in an sqlite DB
  2. Make an order
  3. It should appear on the top widget

dashboard-widgets

Environment

Environment Application Name: Test site Laravel Version: 10.40.0 PHP Version: 8.3.1 Composer Version: 2.6.6 Environment: local Debug Mode: ENABLED URL: test-site.test Maintenance Mode: OFF

Cache Config: NOT CACHED Events: NOT CACHED Routes: NOT CACHED Views: CACHED

Drivers Broadcasting: log Cache: statamic Database: sqlite Logs: stack / single Mail: smtp Queue: sync Session: file

Simple Commerce Currencies: EUR Gateways: Dummy Repository: Customer: DoubleThreeDigital\SimpleCommerce\Customers\EloquentCustomerRepository Repository: Order: DoubleThreeDigital\SimpleCommerce\Orders\EloquentOrderRepository Repository: Product: DoubleThreeDigital\SimpleCommerce\Products\EntryProductRepository Shipping Methods: Free Shipping Tax Engine: DoubleThreeDigital\SimpleCommerce\Tax\BasicTaxEngine

Statamic Addons: 3 Antlers: runtime Stache Watcher: Enabled Static Caching: Disabled Version: 4.44.0 PRO

Statamic Addons doublethreedigital/sc-digital-products: 5.1.2 doublethreedigital/simple-commerce: 5.9.2 statamic-rad-pack/runway: 5.6.2

duncanmcclean commented 5 months ago

Hey 👋

I'm primarily working on Simple Commerce v6, which removes the Overview page and makes these "widgets" available as Control Panel Dashboard widgets instead. It also makes some improvements to how these queries are done behind the scenes.

This probably won't get fixed for v5 but for v6 instead.

sdussaut commented 5 months ago

Hi! Thanks for your answer!

I understand the focus on the next version. I'll see if I try to fix them on my own for now or simply just wait for v6. Aside question, do you happen to have a roadmap for the v6 version published?

duncanmcclean commented 5 months ago

No, the roadmap isn't public.

There's nothing too exciting in v6 - apart from the removal of the Overview page, reducing technical debt and introducing some necessary breaking changes.

The Digital Products addon may also be merged into the main Simple Commerce package too but I haven't made my mind up yet.

github-actions[bot] commented 5 months ago

Released as part of v6.0.3.