Add new entries to the Missing piece management

With UDF skrpps_02.addd_defective_part_data(…), new entries can be added to the Missing piece management.

Several entries can be added with calling-up once.

Parameter	Type	Description
_iStateMode	smallint	Actions: 0 = Missing pieces were reported 1 = Re-knitting order locally at the machine 2 = Re-knitting order with ticket
_iTicketUid	bigint	Ticket UID
_tT imeS	imestamp without time zone	Timestamp of the entry
_sUserName	text	User, who added the entry
_iSkrMcId	integer	SKR Maschine ID may be == NULL if _sMcGuid != NULL
_sMcGuid	text	PPS Maschinen ID may be == NULL if _iSkrMcId != NULL
_sComment	text	Any comment
_iFlags	integer	Flags (for free use)
_sTicketProductionId	text	Ticket Production ID
_sTicketProductionSub1Id	text	Ticket Production Sub1 ID
_sTicketProductionSub2Id	text	Ticket Production Sub2 ID
_sTicketArticleId	text	Ticket Article ID
_sTicketCustomerId	text	Ticket Customer ID
_sSeqName	text	Sequence
_asPatternName	text[]	Pattern names
_aiPosInSeq	smallint[]	Positions of the pattern in the sequence
_aiCount	integer[]	Number of missing pieces (in case of cancellation it can also be < 0)

Code example `skrpps_02.add_defective_part_data (…)`

select skrpps_02.add_defective_part_data

(

0::smallint – Action of missing fabric pieces

, 12345678 -- Ticket UID

, now()::timestamp without time zone – Time and date of the message

, 'armes_wuerstchen'-- User

, NULL -- SKR Machine ID (*1)

,'42.43.44.45.46' -- PPS Machine ID

,'BlaBla...' – any desired comment

,42 -- any desired flags

,'Prod_Id-1321' -- Ticket Production ID

,'sub_1-32' -- Ticket Production Sub1 ID

,'sub_2_53425' -- Ticket Production Sub2 ID

,'artId-322143' -- Ticket Item ID

,'CustomerId-4343' -- Ticket Customer ID

,'My-Seq' -- Sequence

,ARRAY['Pattern1','Pattern2','PatternX'] – pattern name

,ARRAY[1::smallint,2::smallint,5::smallint] – Positions of the pattern within the sequence

,ARRAY[20,11,2] – Quantity of missing fabric pieces

);

The content of the arrays has the following meaning:

Todo