Custom Reports Filter improvement

Create Feature flag in Beta section called “Improved Custom Reporting”

1) Create new filters for the custom reports:

LOGIC:

• in
  • Found all items that have a property value that is equal to one of the supplied list of values
• not in
  • Found all items that have a property value that is not equal to all of the supplied list of values

DESIGN:

https://www.screencast.com/t/VPxURiSmdzC

2) Provide the ability to select several secure zones (like on tags):

https://www.screencast.com/t/nLWIsnTY 

https://www.screencast.com/t/coZTiKynZ 

3) Order Status filtering improvement:

Rename current filter ‘Order Status’ to ‘Order Status Type’ (https://prnt.sc/hdByF4EMuxnC)

• It should search by type name as it did before

Create new filter ‘Order Status’

• It should search by status name

DESIGN:

https://invis.io/MQ12BUHBSXCF

4) Restrictions

Add following validation error messages:

On Saving filters if there is at least one ‘In’ or ‘Not In’ filter in filters list AND “Improved Custom Reporting” is disabled:

“Filters “In” and “Not in” are not allowed if feature flag “Improved Custom Reporting” is disabled.”

On Retrieving report results if there is at least one ‘In’ or ‘Not In’ filter in filters list AND “Improved Custom Reporting” is disabled:

“Results can’t be retrieved: Filters “In” and “Not in” are not allowed if feature flag “Improved Custom Reporting” is disabled.”

Custom Reports Generation Improvement

Improvements:

‘Report’ -> ‘Results’ tab

• Improve speed of report generation and pagination.
• Improved logic should be used only if feature flag is enabled

‘Report’ -> ‘Filters’ tab

• Date fields value (Type: "DateTime"):
  Replace current logic of showing all dates from all items (https://www.screencast.com/t/USYltiD1) with datepicker element (like https://www.screencast.com/t/OChM9GVksz)

Server monitoring inside dashboard

Provide the ability to manually set up server instances of the web farm to the CMS DB

If web-farm is enabled for the site - show charts of CPU Utilization for each server on the analytics dashboard

DESIGN:
https://invis.io/6T12DFCCWRGA

Server enabling by schedule inside dashboard + hours balance

Ability to schedule second server enabling for the period of time

Add/edit slot form fields:

• Each slot should be at least 3 hrs long (if you need more time - you can add more duration). Available durations:
  • 3
  • 6
  • 9
  • 12
  • 15
  • 18
  • 21
  • 24
• Allow to choose start time with 1hr step starting from 0:00 AM  till 11:00PM
• Allow to setup slot name

When adding/editing slot:

• do not allow to choose duration;
  • that overlap the next slot
  • if there is no gap (at least 1h) between current slot and next slot
• do not allow to choose time that is busy by another slot or if this time is 1hr gap between slots
• do not allow to decrease slot if it is currently active (only increase slot duration allowed)

Do not allow to delete past and currently active slots:

• Allow deleting of future slots

Show time when next server enabling will be performed

Show hours balance

• Buy more button should show popup with text:
  “Please contact us at support@treepl.co to schedule an extra server upgrade.”

DESIGN:
https://invis.io/6T12DFCCWRGA

Public API for Orders

Create public API endpoints:

• CRM ORDERS
  • [GET] Get Orders List
  • [GET] Get Single Order
  • [PUT] Update Order

See temporary API endpoint documentation here.

API Applications setup:

Add new page:

• Settings -> API Applications

Allow to:

• list applications
  • DESIGN
• create new application
  • Fields
    • Name [string] required
    • Enabled [boolean] default: true
  • DESIGN
• Edit application
  • Fields
    • Name [string] required
    • Enabled [boolean] default: true
  • Allow to
    • copy `ClientId` and `ClientSecret`
    • regenerate `ClientSecret`
      • once regenerated - revoke all existed access tokens for the public API
  • DESIGN
• Delete application
  • Show confirm dialog:
    “Are you sure you want to delete this app?”

Site Plan Restrictions:

Allow using Public API starting Pro plan

Admin User Restrictions:

Add restrictions

• API Applications
  • Can View
  • Can Add
  • Can Edit
  • Can Delete

Retrieve access token endpoint:

• URL
  • /api/v1/oauth/token
• Type
  • POST
• Content-Type
  • application/x-www-form-urlencoded
• POST params
  • grant_type
    • client_credentials
  • client_id
    • {{client_id}}
  • client_secret
    • {{client_secret}}
  • scope
    • public_api

On Success return bearer token (life time 4 hours):

{
"access_token": "tokenStringHere",
"expires_in": 14400,
"scope": "public_api",
"token_type": "Bearer"
 }

If an app is disabled - return error:

{
"ErrorCode" : 401001,
"Message"   : "The application is disabled"
}

If clientId/clientSecret pair wasn't found - return error:

{
"ErrorCode" : 401002,
"Message"   : "Invalid client_id and/or client_secret"
}

If site plan is less than Pro:

{
"ErrorCode" : 401003,
"Message"   : "Public API is restricted for your site plan"
}

If scope is invalid:

{
"ErrorCode" : 401006,
"Message"   : "Invalid Scope"
}

If grant_type is invalid

{
"ErrorCode" : 401007,
"Message"   : "Invalid Grant Type"
}

API version 1

All of the following endpoints requires Authorization header with the token retrieved by retrieve access token endpoint

​If any request doesn't contain access token or token can't be found in DB, show error:

{
"ErrorCode" : 401000,
"Message"   : "Invalid Access Token"
}

ElseIf any request contains access token but it has been expired, show error:

{
"ErrorCode" : 401004,
"Message"   : "Access Token expired"
}

ElseIf an app associated with the access token - is disabled:

{
"ErrorCode" : 401001,
"Message"   : "The application is disabled"
}

ElseIf access token - is revoked:

{
"ErrorCode" : 401005,
"Message"   : "The Access Token has been revoked"
}

Update item from front-end - rewrites ‘media’ type data

When user updates custom module item from front-end it rewrites data in any "Media" type properties.