275194
275194 - PA-83EGTU/ Login Pop Up should display text
Copyright OBS Logistics © 2010
The information contained herein is the property of OBS Logistics and is supplied without liability for errors or omissions. No part may be reproduced or used except as authorised by contract or other written permission. The copyright and foregoing restriction on reproduction and use extend to all media in which the information may be embodied
FUNCTIONAL OVERVIEW
Client Requirement
Amend the function of the Pop-Up info box developed by RIO PA-7T5KM9 to be capable of accepting Free Text messages created by specific, restricted users and displayed at Log-On to all selected User Groups, with the same basic control as the original RIO.
Solution
Pop Up Menu
A new tab will be added to the MSG_MAINT screen called LOGIN_MSG. The tab will consist of a list of user groups and a free text message field. By selecting a user group, the user will be able to type in a message to be displayed to all the users in the user group.
This information will be stored in a new table MSG_LOGIN which will contain 3 fields GROUP_NAME, MSG_TXT and APPLIED_TO_ALL. The APPLIED_TO_ALL field will be used to accommodate users who are in more than one group,where the same message is being sent to all groups.
The tab will include 2 buttons, ‘apply to all’ and ‘remove all’. When a user enters a message and selects ‘apply to all’, the message is added to each group and the ‘applied_to_all’ field is set to Y. When the user selects ‘remove all’ all the message fields are set to null and the ‘applied_to_all’ button is set to N.
When a user logs into the system, a cursor will identify which group(s) the user is in. A second cursor will check if there are any messages populated for the group(s). If there are messages, the message will be displayed on the login screen (ORI_STATS) and the Window size will be increased to show the text.
If the applied_to_all field is set to Yes, the cursor will return the first message only to the screen. If this field is not set, then the messages for each group that the user belongs to will be concatenated and displayed on screen.
ORI Stats
The block of schedules will be amended to only show those +- 7 days from the current date. A new check box will be available ‘Show All’ which when selected will allow the user to see all the schedules listed.
Currently the stats are displayed for all the trips/ orders in the system. This information will be amended to show the stats based on the users BASED_AT (trips) and SCHED_GROUP (orders) parameters. In addition to the stats which are currently on display, an extra block will be created to show the number of trips at each status.
The stats are currently calculated in the SCH.Sched_Stats procedure and this will be amended to generate the new stats and amend the existing stats.
ADM.get_mulitple_vachar will be used to return the parameter values and the value returned (‘ALL’, single or multiple values) will be manipulated to pass to the cursor.
Scope
This change will be applied to system version 10.5
FUNCTIONAL DESCRIPTION
Changes to the Message Maintenance screen
A new tab called LOGIN_MSG will be added to the Message Maintenance screen. The tab will consist of a list of user groups and a free text message box (see screen layout below). After selecting a user group, then user will be able to type in a message to be displayed to all the users in the user group.
This information will be stored in a new table MSG_LOGIN (see table definition in section 2.1) which will contain 3 fields GROUP_NAME, MSG_TXT and APPLIED_TO_ALL. The APPLIED_TO_ALL field will be used to accommodate users who are in more than one group, where the same message is being sent to all groups.
The tab will include 2 buttons, ‘apply to all’ and ‘remove all’. When a user enters a message and selects ‘apply to all’, the message is added to each group and the ‘applied_to_all’ field is set to Y. When the user selects ‘remove all’ all the message fields are set to null and the ‘applied_to_all’ field is set to N.
When a user logs into the system, a cursor will identify which group(s) the user is in. A second cursor will check if there are any messages populated for the group(s). If there are messages, the message will be displayed on the login screen (ORI_STATS) and the Window size will be increased to show the text.
If the applied_to_all field is set to Yes, the cursor will return the first message only to the screen. If this field is not set, then the messages for each group that the user belongs to will be concatenated and displayed on screen.
Changes to the ORI_STATS screen
The block of schedules will be amended to only show those +/- 7 days from the current date, i.e. it only shows the records from table sch_schdule where the start_date is greater than current system date - 7 and less than current date + 7. A new check box ‘Show All’ will be added to the screen to give user an option to see all the schedules listed.
Currently the stats are displayed for all the trips/ orders in the system. This information will be amended to show the stats based on the users BASED_AT (trips) and SCHED_GROUP (orders) parameters. In addition to the stats which are currently on display, an extra block will be created to show the number of trips at each status. A message box will also added to the screen to show the login message for the login user if it exists.
The stats are currently calculated in the SCH.Sched_Stats procedure and this will be amended to generate the new stats and amend the existing stats. ADM.get_mulitple_vachar will be used to return the parameter values and the value returned (‘ALL’, single or multiple values) will be manipulated to pass to the cursor.
REFERENCES
| EST-275194 PA-83EGTU Login Pop Up should display text v1.0.doc |
DOCUMENT HISTORY
| Initial version | ||||
| Changes made after review by sew |
AUTHORISED BY
| Matt Crisford | Development Manager | |
| Peter Greer | TMSCC MTS Product Manager |
