...
Description
...
NEXT PLANNED ASSIGNMENT FOR THE NEXT 30 DAYS
...
Summary
...
| Table of Contents |
|---|
| minLevel | 1 |
|---|
| maxLevel | 1 |
|---|
| type | flat |
|---|
| separator | pipe |
|---|
|
| Page Properties |
|---|
Summary | The notification informs the crew of the next planned assignment for the next 30 days. |
|---|
|
...
Customer
...
Wilhelmsen
...
...
File / Script Link
...
Compatibility APM Version
...
N/A
...
Compatibility SQL Version
...
N/a
Setup
Go to Setup > Notification Service
Image RemovedAdd New, give the task a name, define time and date settings. For more details on the settings, please check Notification Service#ScheduleTask
Image RemovedUnder the Notification E-mails tab, define Sender email and name. Recipients will be picked up dynamically from the database. An example of a selection that can be used is shown below, please check with Adonis Support or Project Consultants if you can use the same selection.
Image RemovedInsert Email Subject and Body. Note that you can insert screenshots, links and signatures to the mail body.
| Cp panel macro |
|---|
| data | %7B%22components%22%3A%5B%22title%22%5D%2C%22titleAlignment%22%3A%22left%22%2C%22contentAlignment%22%3A%22left%22%2C%22title%22%3A%22Example%20mail%20body%22%2C%22titleColor%22%3A%22%23ffffff%22%2C%22titleContainerColor%22%3A%22%230052CC%22%2C%22background%22%3A%22%23ffffff%22%2C%22borderColor%22%3A%22%23FF8B00%22%2C%22borderRadius%22%3A4%2C%22borderType%22%3A%22solid%22%2C%22icon%22%3A%22%22%7D |
|---|
|
Hello Mr./Mrs. (depending on Gender) [#LASTNAME], Please note that your next planned assignment on [#PLATFORM] platforms is as follows: Platform name: [#VESSELNAME] Departure date: [#DATEFROM] "Go offshore" date: [#DATETO] Sign off date: [#EED]
Please let us know as soon as possible in case there is any concern regarding the abover planning. Best regards, |
Sample Output
N/A
...
Description
The notification informs the crew of the next planned assignment for the next 30 days.
Setup and Configuration
Task Settings
Schedule: Daily, every day.
Recipients: affected crew.
Can be set to a fixed email list.
Image Added Image Added SQL Statement
| Expand |
|---|
|
| Code Block |
|---|
| SELECT
P01.PIN as #PIN,
CASE
WHEN P01.SEX='M' THEN 'Mr. '+P01.LASTNAME
WHEN P01.SEX='F' THEN 'Mrs. '+P01.LASTNAME
ELSE 'Mr/Mrs. '+P01.LASTNAME
|
|
...
...
,
ves.[NAME] AS #VESSELNAME |
|
...
...
,
p03.DATEFROM AS #DATEFROM |
|
...
...
,
p03.TODATEESTIMATED AS #EED |
|
...
...
,
email.TELENO AS #EMAIL
FROM PW001P01 P01 |
|
...
...
...
...
...
AND ISNULL(P03.PLANNED ,'N') = 'Y'
|
|
...
AND P03.DATEFROM = DATEADD(DAY ,DATEDIFF(DAY ,0 ,GETDATE()) ,30)
|
|
...
AND P03.CODE IN (SELECT CODE |
|
...
...
...
...
WHERE OPTIONS LIKE '%S%') |
|
...
...
...
...
...
,dbo.ad_scanorgtree(NUMORGID ,3) AS VesselID |
|
...
...
...
ON ou.NUMORGID = p03.NUMORGID |
|
...
...
...
ON ves.NUMORGID = ou.VesselID |
|
...
...
...
ON pf.COMPANYID = ves.NUMORGID
|
|
...
...
...
email ON email.PIN = p01.PIN
AND email.TELETYPE = 6
AND email.TELEPRIORITY |
|
...
...
...
AND NOT EXISTS (SELECT 1 FROM PW001P0T t WHERE t.PIN = email.PIN |
|
...
...
...
email.TELETYPE AND t.TELEPRIORITY IS NOT NULL
AND (t.TELEPRIORITY < email.TELEPRIORITY OR t.TELEPRIORITY = email.TELEPRIORITY AND t.SEQUENCENO < email.SEQUENCENO))
|
|
Sample E-mail
Hello Mr./Mrs. (depending on Gender) [#LASTNAME],
Please note that your next planned assignment on [#PLATFORM] platforms is as follows:
Platform name: [#VESSELNAME]
Departure date: [#DATEFROM]
"Go offshore" date: [#DATETO]
Sign-off date: [#EED]
Please let us know as soon as possible in case there is any concern regarding the above planning.
Best regards,
