Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MP_ExportShiftPatternsBroker
|
{
|
MDSDefinition: MacroPlan
|
EDIModelLink.Source InputShiftPatternsFromModel
|
{
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.inputshiftpatternsfrommodel'
|
EDIMLTable ShiftDay
|
{
|
PrimaryKeyColumns: ID
|
PrimaryKeyColumns: ShiftPatternName
|
TargetType: ShiftDay
|
TypeIndex: ShiftDayTypeIndex
|
EDIMLColumn Capacity { Attribute: Capacity ValueType: Duration }
|
EDIMLColumn Day { Attribute: Day ValueType: Number }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn ShiftPatternName { Attribute: ShiftPatternName ValueType: String }
|
}
|
EDIMLTable ShiftPattern
|
{
|
PrimaryKeyColumns: Name
|
TargetType: ShiftPattern
|
TypeIndex: ShiftPatternTypeIndex
|
EDIMLColumn MinimumDuration { Attribute: MinimumDuration ValueType: Duration }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
}
|
EDIMLTable UnitShiftPattern
|
{
|
PrimaryKeyColumns: ShiftPatternName
|
PrimaryKeyColumns: UnitID
|
TargetType: UnitShiftPattern
|
TypeIndex: UnitShiftPatternTypeIndex
|
EDIMLColumn IsAllowed { Attribute: IsAllowed ValueType: Boolean }
|
EDIMLColumn ShiftPatternName { Attribute: ShiftPatternName ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
}
|
EDITransformation.Transformation TransformShiftPatternsForExport
|
{
|
EDITableTransformation
|
{
|
InputTable: ShiftDay
|
OutputTable: ShiftDays_MP
|
EDIColumnMatch
|
{
|
InputColumn: Capacity
|
OutputColumn: Capacity
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DurationToString xmlns="http://www.quintiq.com/GEB/DurationToString" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<SingularDayString>day</SingularDayString>
|
<PluralDayString>days</PluralDayString>
|
</DurationToString>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Day
|
OutputColumn: Day
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ID
|
OutputColumn: ID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ShiftPatternName
|
OutputColumn: ShiftPatternName
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: ShiftPattern
|
OutputTable: ShiftPatterns_MP
|
EDIColumnMatch { InputColumn: MinimumDuration OutputColumn: MinimumDuration }
|
EDIColumnMatch
|
{
|
InputColumn: Name
|
OutputColumn: Name
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: UnitShiftPattern
|
OutputTable: UnitShiftPatterns_MP
|
EDIColumnMatch { InputColumn: IsAllowed OutputColumn: IsAllowed }
|
EDIColumnMatch { InputColumn: ShiftPatternName OutputColumn: ShiftPatternName }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
}
|
EDIXLSLink.Destination OutputShiftPatternsToExcel
|
{
|
FileName: 'MP_ShiftPatterns'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputshiftpatternstoexcel'
|
EDIXLSLinkTable ShiftDays_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn Capacity { ValueType: String }
|
EDIXLSLinkColumn Day { ValueType: Number }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn ShiftPatternName { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable ShiftPatterns_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn Name { ValueType: String }
|
EDIXLSLinkColumn MinimumDuration { ValueType: Duration }
|
]
|
}
|
EDIXLSLinkTable UnitShiftPatterns_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn IsAllowed { ValueType: Boolean }
|
EDIXLSLinkColumn ShiftPatternName { ValueType: String }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
]
|
}
|
}
|
}
|
