Create a sales report supporting daily, weekly, monthly, and yearly breakdowns.

Here is the first go.

Yearly added. Can't get menu links and tabs to cooperate.

I just looked, in 7.x-4.x I added a custom handler: http://cgit.drupalcode.org/commerce_reports/tree/includes/views/handlers...

      case 'week':
        $formula = views_date_sql_format('YW', "$this->table_alias.$this->real_field");

And here we make it the default sort handler in a views data alter. So just like I provided a work around for the ReportDateField we'll need a sort version.

//Changed created to use our date sort handler which adds weekly granularity.
  $data['commerce_order']['created']['sort']['handler'] = 'commerce_reports_handler_sort_date';

FYI we can make that its own issue, then mark it as a blocker from here. Get that in, then re-roll the patch.

Here is the updated view, with weekly thanks to the fix in #2976401: Create a custom sort handler to provide 'weekly' aggregation option. embedded gif goodness.

Try to fix schema error. Forgot to mark Views in info.yml, too.

Try to fix the schema issues.

For

Schema errors for views.view.sales_report with the following errors: views.view.sales_report:display.default.display_options.fields.report_id.set_precision missing schema

the `report_id` is an entity field, but COUNT() aggregated. So it’s been flipped to a `numeric` handler. But the handler is overridden at run time, not in a schema level.

There's a core bug. I'll just tell the test to not validate schema. See #2976616: Aggregated entity fields cause SchemaIncompleteException

Skip checking the schema.

Comitted!