View source for FS 369552 MCS Allow Pallet Opening

<div class="noprint">
{{#vardefine:Client|DHLT}}
{{#vardefine:ClientName|DHL}}
{{#vardefine:System|''CALIDUS'' MCS}}
{{#vardefine:SystemCode|MCS}}
{{#vardefine:Doc_Title|Allow Pallet Opening}}
{{#vardefine:Version|1.0}}
{{#vardefine:Date|6th February 2020}}
{{#vardefine:Reference|369552}}
{{#vardefine:Year|2020}}
{{ #vardefine: Figure | 0 }}{{ #vardefine: Example | 0 }}
<!--
Sample Xref:
{{Xref
|Type=Figure
|Num={{ #vardefineecho: Figure| {{ #expr: {{ #var: Figure}} + 1 }} }}
|Text=Data Upload - Import screen.}}
-->
</div>
{{Doc_TitleNew
|Client={{#var:ClientName}}
|System={{#var:System}}
|Title={{#var:Doc_Title}}
|Reference=FS {{#var:Reference}}
|Version={{#var:Version}}
|Date={{#var:Date}}
|Year={{#var:Year}}
}} 

<!-- TOC --> 
<div class="noprint">
= FUNCTIONAL OVERVIEW  =
== Client Requirement  ==
At locations where built pallets are expected to be closed (e.g. C3), the user may notice at loading of a trip that a package has not been scanned to a pallet. All pallets for the trip are likely to already be closed, and therefore unavailable to have the package added to them. They may create a new pallet, but the package may be better located on an existing pallet.

The operation wants to be able to open a pallet using MCS, so that they can scan the package onto the pallet and re-seal it.


This is a function of the Pallet Closure option on MCS.

If a closed pallet is scanned, it currently says that the pallet is not known, because the process excludes closed pallets.

The process must now see closed pallets, and offer the user the option of opening them again.


== Solution Overview  ==
If a closed pallet is scanned, it currently says that the pallet is not known, because the DB procedure excludes closed pallets.

The procedure must be opened up to closed pallets, and return the status.

MCS must check this status and offer the user the option to re-open the pallet.

Confirming this would call a DB procedure to re-open the pallet, setting the status to open and removing any seal information.


== Scope  ==
This change will be applied to system version 2 of C-MCS linking to system version 11.35 on HCRTST and once approved will be promoted to HCRPRD.

This change to the functionality will ''not'' be controlled by a parameter, as only DHL use this option.


== Impact ==
Low to none - this is an optional process.


<!-- NEW PAGE --> 
= CONFIGURATION SET-UP  =
== Pre-requisites  ==
C-MCS must be configured and connected to a configured C-TMS system.


== Menu Structure  ==
N/A


== Data  ==
None.

== Implementation Advice ==
None.


<!-- NEW PAGE --> 
= FUNCTIONAL DESCRIPTION =
== MCS Pallet Closure ==
The pallet closure process will be modified.

If a closed pallet is scanned in this option, it currently says that the pallet is not known, because the DB procedure excludes closed pallets.

This will be modified to identify a closed pallet.

If closed, the device will then offer the user the option to re-open the pallet, through a pop-up confirmation dialogue.

If the user confirms that the pallet will be re-opened, C-TMS will re-open the pallet and removing any seal information.

The pallet will then be available for pallet building.


<gallery widths=200px heights=320px perrow=3>
Image:FS_369552_Pallet_Closure1.PNG|''Pallet closure - existing screen''
Image:FS_369552_Pallet_Closure2.PNG|''Pallet closure - new pop-up (prototype)''
</gallery>
{{Xref|Type=Figure|Num={{ #vardefineecho: Figure| {{ #expr: {{ #var: Figure}} + 1 }} }}|Text=Cherwell 3 Pallet Closure process}}


<!-- NEW PAGE --> 
= TECHNICAL NOTES =
== Modules Changed ==
<!-- List the modules or objects that will be changed by this development -->
{| class="wikitable" border="1" width="100%"
|-bgcolor="#FFFF99"
! width="20%" | Module Name || width="40%" | Module Type || width="40%" | Notes
|-
| DP_MCS_SCANNING || C-TMS Package || &nbsp;
|-
| (As required) || SQL || Database modification script.
|-
| m004a01t_uc_pallet_closure.js	|| MCS Device code	|| &nbsp;
|-
| m004a01t_uc_pallet_closure.ascx	|| MCS Device code	|| &nbsp;
|}


== Table Updates ==
None.


== Developer Notes ==
To achieve this, we must make the following changes:
*	Change MCS to check the pallet status and allow the user the choice to open the pallet.
*	New message from MCS to C-TMS to open a package.
*	New C-TMS procedure to re-open a pallet, deleting any seal information if present. 


=== C-TMS DP_MCS_SCANNING Changes ===
The existing procedure DP_MCS_SCANNING.FN_UPDATE_PALLET_STATUS will be modified to open a closed pallet. The procedure already achieves much of what is required, but the seal number processing must be modified.

Currently, the process does the following:
* Status requested must be a valid status i.e. OPEN or CLOSED.
* Checks seal.
* Checks status of despatching trip - not EN-ROUTE, COMPLETED, CONFIRMED.
* Create seal.
* Lock pallet record and change status.

The process will be modified as follows:
* Status requested must be a valid status i.e. OPEN or CLOSED.
* Check seal - only required if CLOSING a pallet. This is currently controlled by no seal parameter being present and can continue this way. 
* Checks status of despatching trip - not EN-ROUTE, COMPLETED, CONFIRMED.
* Create seal - only required if CLOSING a pallet. This is currently controlled by no seal parameter being present and can continue this way.
* Delete existing seal - only required if OPENING a pallet. The process should check that the required status is "OPEN" and, if so, check whether there is a seal for this pallet (checking on SCH_SHIP_AWB_CON_CONT). If found and type "S", delete the record. If there are no more records on the seal (i.e. SCH_SHIP_AWB_CON), delete the seal.
* Lock pallet record and change status.

Appropriate error messages will be returned if there are failures opening the pallet, through the same method that the package does when closing pallets.


=== MCS Pallet Closure Screen ===
The process for pallet closure will change to allow a pallet to be opened. The flow of the process is as follows:

On the device:
* Keying enter on pallet field calls 
* MCSUI.PalletClosure.funCheckPalletClick() (in m023a01t_uc_pallet_closure.js) which calls
* MCSWS.Requests.PalletRequest(strSiteId, strPalletId, MCSUI.PalletClosure.funCheckPalletRequestCallback) in webServiceRequests.js

On the server:
* PalletRequest is dealt with by PalletRequest in MCSService.cs.
* This selects the details of the pallet from V_MCS_PALLET, including the status.

On the device:
* MCSUI.PalletClosure.funCheckPalletRequestCallback in m023a01t_uc_pallet_closure.js
* This checks the status - if CLOSED it issues an error. 

This should no longer do that.

The process will now:
* display the details as per the following block, then within that block:
** if the status is not CLOSED, do as now
** if the status is CLOSED, 
*** do not display the seal number and Pallet Close button (i.e. hide them).
*** do not set the default button or default focus (i.e. do not call this code).
*** display a dialogue box:
**** message id, level and description as  "This pallet is already closed - do you want to open it?", options "Yes"/"No" (MCSUI.Messages.ButtonTypes.YesNo).
**** If No is clicked, close the dialogue box - no further actions required.
**** If Yes is clicked, close the dialogue box and call new function to open pallet and remove seals.


The required MCS development is as follows:

A dialogue will be added to the Pallet Closure process, if the pallet is considered to be status CLOSED.

Dialogue control code can be seen in MCS Damages function, when confirming marking an item as damaged (funConfirmMarkDamaged in m009a01t_uc_damages.js)

Dialogues may be shown with:
* MCSUI.Common.objScreen.MessageDialogue.showQuestion(strMessage)

A new dialogue will be configured - set in m023a01t_uc_pallet_closure.ascx, through common code:
* MCSUI.Common.objScreen.MessageDialogue.yesClicked = MCSUI.PalletClosure.funConfirmReopenPallet

This then links to a new function funConfirmReopenPallet in m023a01t_uc_pallet_closure.js when '''Yes''' is clicked. The process will:
* Close the dialogue box, 
* Calls MCSWS.Requests.PalletUpdate with status set to OPEN and no seal. Set callback as now, to MCSUI.PalletClosure.funPalletUpdateRequestCallback
* On successful result, display a toast message that the pallet is closed. Clear the pallet details

To be clear, when '''No''' is clicked, the dialogue box will be removed, but the pallet details will remain. The user can only click the '''Cancel Entry''' button to enter a pallet again.

Function MCSUI.PalletClosure.funPalletUpdateRequestCallback in m023a01t_uc_pallet_closure.js will be modified. It's a minor modification to what it already does, based on the status of the pallet being actioned:
* Check error status. 
** If OK, display message "Pallet X opened" and clear back to normal entry. 
** If not, display error message. Clear back to normal entry.
All pallet details should be removed.


Affected code modules:
*	m023a01t_uc_pallet_closure.js
*	m023a01t_uc_pallet_closure.ascx


<!-- MEDIA LANDSCAPE YES --> 
= TEST PLAN  =
{{TestPlan_Header
|Title={{#var:Doc_Title}}
|Log={{#var:Reference}}
|Description=Pallet Re-opening
|MenuAccess=Pallet Closure
|Prerequisites=A configured C-TMS and MCS.
|Objective=Test that pallets that are scanned again can be re-opened.
}} {{ #vardefine: Cycle | 0 }}{{ #vardefine: SubCycle | 0 }}
{{TestPlan_CycleHeader
|Cycle={{ #vardefineecho: Cycle | {{ #expr: {{ #var: Cycle }} + 1 }} }}{{ #vardefine: SubCycle | {{ #var: Cycle }} }}
|Title=MCS Pallet Closure
|Notes=Ensure that there are two locations configured, both with pallet closure enabled, one with Pallet Seal required and one without.
}} <!--INSERT TESTS HERE --> {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.01 }} }}
|Action=Location configured for seals at pallet closure. Scan pallet
|Result=The application displays a text box for seal number, a '''Close Pallet''' and '''Cancel Entry''' button.
|Remarks=
|PassFail=
}} {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.01 }} }}
|Action=Enter a seal number and click '''Close Pallet'''.
|Result=The pallet is closed and the device informs you so. The seal is created in C-TMS. The device is prompting for pallet again.
|Remarks=
|PassFail=
}} {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.01 }} }}
|Action=Scan the pallet again.
|Result=All pallet details are shown. No seal number text box nor '''Close Pallet''' button is displayed, just a '''Cancel Entry''' button. A dialogue is shown, asking the user to confirm opening the pallet, with Yes and No options.
|Remarks=
|PassFail=
}} {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.01 }} }}
|Action=Click '''No'''
|Result=The dialogue box is hidden.
|Remarks=
|PassFail=
}} {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.01 }} }}
|Action=Click '''Cancel Entry'''.
|Result=The device is prompting for pallet again. The pallet details are removed.
|Remarks=
|PassFail=
}} {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.01 }} }}
|Action=Scan the pallet again. Click '''Yes'''
|Result=The dialogue box is hidden. The pallet is opened and the device informs you so. The seal is deleted in C-TMS. The device is prompting for pallet again. Pallet details are no longer displayed.
|Remarks=
|PassFail=
}} {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.01 }} }}
|Action=Location configured for no seals at pallet closure. Scan pallet
|Result=The application displays a '''Close Pallet''' and '''Cancel Entry''' button.
|Remarks=
|PassFail=
}} {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.01 }} }}
|Action=Click '''Close Pallet'''.
|Result=The pallet is closed and the device informs you so. No seal is created in C-TMS. The device is prompting for pallet again.
|Remarks=
|PassFail=
}} {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.01 }} }}
|Action=Scan the pallet again.
|Result=All pallet details are shown. No seal number text box nor '''Close Pallet''' button is displayed, just a '''Cancel Entry''' button. A dialogue is shown, asking the user to confirm opening the pallet, with Yes and No options.
|Remarks=
|PassFail=
}} {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.01 }} }}
|Action=Click '''No'''
|Result=The dialogue box is hidden.
|Remarks=
|PassFail=
}} {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.01 }} }}
|Action=Click '''Cancel Entry'''.
|Result=The device is prompting for pallet again. The pallet details are removed.
|Remarks=
|PassFail=
}} {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.01 }} }}
|Action=Scan the pallet again. Click '''Yes'''
|Result=The dialogue box is hidden. The pallet is opened and the device informs you so. The device is prompting for pallet again. Pallet details are no longer displayed.
|Remarks=
|PassFail=
}} {{TestPlan_CycleFooter}} 

<!-- MEDIA LANDSCAPE NO --> 
{{Doc_AppendixNew
|Appendix=A
|Estimate=Y
|Glossary=MCS
|Ref1=&nbsp;
|RefV1=&nbsp;
|RefDate1=&nbsp;
|REQ=0
|EST=0.25
|FS=1.50
|TS=0.00
|DEV=6.25
|ST=2.00
|IMP=0.50
|PM=0.50
|Client={{#var:Client}}
|Year={{#var:Year}}
|FSEST=Y
|Rev1=Julie Scott
|Rev1Title=OBS Project Manager
|Rev2=Paul Kurze
|Rev2Title=Customer Representative
}}</div> 
[[Category:{{#var:Client}} FS]]
[[Category:{{#var:SystemCode}}]]