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

        jonathan Jonathan Reissmueller created issue -
        jonathan Jonathan Reissmueller made changes -
        Field Original Value New Value
        Rank Ranked higher
        jonathan Jonathan Reissmueller made changes -
        Story Points 5
        jonathan Jonathan Reissmueller made changes -
        Sprint 4.11.0 Sprint 4 [ 111 ]
        jonathan Jonathan Reissmueller made changes -
        Rank Ranked lower
        jonathan Jonathan Reissmueller made changes -
        Epic Link CORE-3356 [ 14585 ]
        abdy Abdy Franco made changes -
        Assignee Abdy Franco [ abdy ]
        Automated transition triggered when Abdy Franco created a branch in Stash -
        Status Open [ 1 ] In Progress [ 3 ]
        Automated transition triggered when Abdy Franco created pull request #173 in Stash -
        Status In Progress [ 3 ] In Review [ 5 ]
        Resolution Fixed [ 1 ]
        abdy Abdy Franco made changes -
        Remaining Estimate 0 minutes [ 0 ]
        Time Spent 3 hours, 26 minutes [ 12360 ]
        Worklog Id 13752 [ 13752 ]
        abdy Abdy Franco made changes -
        Time Spent 3 hours, 26 minutes [ 12360 ] 3 hours, 48 minutes [ 13680 ]
        Worklog Id 13766 [ 13766 ]
        abdy Abdy Franco made changes -
        Time Spent 3 hours, 48 minutes [ 13680 ] 4 hours, 48 minutes [ 17280 ]
        Worklog Id 13770 [ 13770 ]
        Automated transition triggered when Jonathan Reissmueller merged pull request #173 in Stash -
        Status In Review [ 5 ] Closed [ 6 ]

          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