Client Report Scheduler

From UG

Revision as of 21:51, 22 November 2011

Info

Parent Mantis

• mantis 1586

Scope of this wiki

This feature is for the client application. To allow client users to be able to schedule their own reports and take the burden off of Jaguar Freight.

SOW 1

Mantis: 1892 (Client Reports) Schedule report feature for client app (client can schedule report on their own)

Core requirements:

• Schedule report feature is for the client application. To allow client users to be able to schedule their own reports and take the burden off of Jaguar Freight.

• Not all clients can schedule all reports

• Filters & Output - keep the same scheduling options, filters & output as it currently is on the internal app.

Solution

We need the following:

• 1) Add Report Scheduler Panel to Client App (same functionality as internal).
• 2) Add Admin section to Internal>Client App Admin so we can select what role can schedule reports (multiselect). Default: "client".
• 3) Add button or link to access Report Scheduler Panel from somewhere within the Client App reports menu Cybertrax > Reports.
• 4) Add options in Internal > Admin > Client Companies to:
  • Show/Hide Scheduler (default: hide)
  • Select what reports are available for scheduling.
    • Main & In Transit reports should be available as default schedule report for every "client" user in the Client App.
      • These 2 reports need to remove from the available list for scheduling since they are already available reports on the client application.
      • Also need to remove all other reports from the available list but keep only the daily reports listed below.
    • Add Daily report to client application:
      • Daily EA is used only for client users that have their client company set to 4 Pole in their Non Jag user profile.
      • Daily - this report should be for all other client users.
    • Filters & Output:
      • For Main & InTransit - keep the same scheduling options as internal, keep same filters & output as it currently is on the client app.
      • For Daily - keep the same scheduling options, filters & output as it currently is on the internal app.
  • NOTE: Above choices we should be able to apply per individual company or by selecting a group of companies and apply (to save time).
• 5) Display scheduled reports by Client users here: Internal Home > Reports > Saved/Scheduled.
  • Add Disable/Enable functionality.
  • Add filter so we can see reports scheduled by client users and internal separately.
• 6) Upon disabling a client user, the system should automatically disable any scheduled reports that were set up by that client user

SOW 2

Mantis: 3029 (Client Reports) Schedule report feature for client app (client can schedule report on their own) Tweaks

Core requirements:

A few different change requests were asked for by Marc in Jun of 2011.

• Client Companies Filter:
  • Client company filter should be a default setting, according to whatever client companies that non jaguar user has set in their profile, including client company visibility rights.
    • Non Jag user should not have to set the client company

• Hide the Report Tags: Client Company AND Trucking Company, as this is not needed.

• Make the already internal scheduled reports read only, allowing the client user to see the information that was already setup by Jag internal users, not allowing them make any changes.

• Clearly define or separate the Jag internal reports from the clients scheduled reports.

Impact on DB performance and speed

TBD