Uploaded image for project: 'Blesta Core'
  1. Blesta Core
  2. CORE-3656

Order: Affiliate add table for daily visits and sales

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.11.0-b1
    • Component/s: None
    • Labels:
      None

      Description

      Update install/upgrade to add new table order_affiliate_daily_statistics with the following columns:

      • affiliate_id INT(10) UNSIGNED NOT NULL
      • visits INT(10) UNSIGNED NOT NULL
      • sales INT(10) UNSIGNED NOT NULL
      • date DATE NOT NULL

      Remove columns in the order_affiliates table for visits and sales

      Update locations that track visits and sales to use the new table, inserting a record for the current date (in the company's timezone) if it doesn't exist or updating it if it does

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            abdy Abdy Franco
            Reporter:
            jonathan Jonathan Reissmueller
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Fix Release Date:
              10/Jul/20

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 4 hours, 48 minutes
              4h 48m

                Agile