View source

== Cleaning symptoms ==

<sql>
 update bom set flag = NULL where flag in (21, 22, 23, 24, 25, 26, 27, 28, 29)
</sql>

== Import to BoM2 ==

 The BOM table is twofold: application OMS BoM and replication of the new BoM2 BOM from which data is transferred to the application BOM (BoM).(viz. web.xml).

== OMS client application lock ==

 Create a record in the table "app_lock"

== Create DIFF information ==

<java>
 setKeyColumnNames(new String[]{"MachineCPN", "Item"});
 setDiffColumnNames(new String[]{"MachineCPN", "Item", "Revision", "UnitOfMeasure", "Quantity"});
 setDisplayColumnNames(new String[]{"id", "ParentItemOrder", "other_id", "MachineCPN", "Item", "Revision", "UnitOfMeasure", "Quantity"});
 setWhereClause("where tag is null and manual_record is null");
</java>

== Redundancy analysis ==

<sql>
 UPDATE diff SET diff.parentitemorder = bom2.parentitemorder, diff.[order] = bom2.[order] FROM bom2 
 WHERE context_id = '-123' AND LHS IS NULL AND RHS IS NOT NULL AND bom_id = bom2.id
</sql>

<sql>
 UPDATE diff SET diff.parentitemorder = bom.parentitemorder, diff.[order] = bom.[order] FROM bom 
 WHERE context_id = '-123' AND LHS IS NOT NULL AND RHS IS NULL AND bom_id = bom.id AND bom.tag is NULL AND bom.manual_record is NULL
</sql>

<sql>
 UPDATE diff SET diff.parentitem = bom2.item FROM bom2 
 WHERE context_id = '-123' AND LHS IS NULL AND RHS IS NOT NULL AND bom2.machinecpn = machine_cpn AND bom2.[order] = diff.parentitemorder
</sql>

<sql>
 UPDATE diff SET diff.parentitem = bom.item FROM bom 
 WHERE context_id = '-123' AND LHS IS NOT NULL AND RHS IS NULL AND bom.machinecpn = machine_cpn AND bom.[order] = diff.parentitemorder 
 AND bom.tag is NULL AND bom.manual_record is NULL
</sql>

* analyzeDiffForReorder
* analyzeDiffForReorderAndUpdate
* updateDiffContextEndTime

== Merge ==

[[File:OMS-BoMImp.jpg]]

=== Logging ===

 Row_6000, IsINS:31, IsDEL:16, UPD:16, IsUPD:31, BoM2-ID:92946492, INS: 0

Legend (separated by comma):

* Number of processed line from table bom2
* Insert detection <sql>select TOP 1 ROW_STEP, RESULT from DIFF where BOM_ID = ' bom2Id ' and CONTEXT_ID = '-123' and RHS = '>' and KIND = '0' </sql>
* Detection of deletes without time marking the record as deleted <sql>select TOP 1 ROW_STEP, RESULT from DIFF where BOM_ID = ' bomId  ' and CONTEXT_ID = '-123' and LHS = '<' and KIND = '0' </sql>
* Update time
* Time to determine if it is an update <sql>select TOP 1 ROW_STEP from DIFF where BOM_ID like 'bomId:%' and CONTEXT_ID = '-123' </sql>
* The identifier (key) of the entry from the bom2 table
* Listing the insert result has one of three values as a result: 0, 1 or 2 (DIFF.RESULT = 'N')

== Unlock client application OMS ==

== Set visibility of BOM items and generate auxiliary data ==

== Create notifications ==

<sql>
SELECT bom_id, machine_cpn, item, [revision], unit, quantity, lhs, kind, parentitem  FROM diff 
WHERE CONTEXT_ID='-123' AND result is null  
UNION 
SELECT bom_id, machine_cpn, item, [revision], unit, quantity, lhs, kind, parentitem FROM diff_report_update
WHERE CONTEXT_ID='" + id + "' AND result is null 
ORDER BY machine_cpn, item, lhs, kind, parentitem
</sql>

== Send notifications by e-mail ==

<sql>
select * from message as m where m.id not in (select message_id from msg_delivery_status where email_delivered = 1) order by [from]
</sql>