vwiki

Edit the page and hit Save. See syntax for Wiki syntax. Please edit the page only if you can improve it. If you want to test some things, learn to make your first steps on the playground.

====== rm24070 It is possible to create a DA for a Single-KIT-Header ======

https://cust-projects.seeburger.de/redmine/issues/24070

https://tasks.supplyon.de/browse/AIRS-226

===== TODO =====
  * **+** Analyze what is to do
  * **+** Create new branch topic/rm#24070_DaForSingleKitHeader
  * **-** Change SQL columns
    * **+** add column ''CISKIT''
    * **+** change column definition of ''CISKITWITHOUTCOMPS'' (declared in ''D:\dev\git\airsupply\airsupply-integration\src\test\resources\sqltestdata\airsupply\baseline\V0.0.0.0.1__baseline.fly.sql'')
    * **+** write an SQL script to calculate ''CISKIT''
  * **x** Change Model (POBaseModel?) -> not necessary
  * **-** Change ''POImportXMLHandler''
    * during the import calculate the flag ''header.isKit'' (at the moment it is the flag ''POImportXMLHandler.bIsKit''). It can be done during import of positions, because the first time this flag is read after the positions are processed.

===== SQL =====
Create column cKIT:
<code sql>
ALTER TABLE TAIRPOHEADER ADD CISKIT NUMBER(1,0) DEFAULT 0;
</code>

Fill cKIT with data:
<code sql>
update tAIRPOHEADER set CISKIT=1 where cHeaderID IN (select cRefHeaderId from TAIRPOSCHEDULE where CKITHEADER>0 OR CKITCOMPONENT>0 GROUP BY cRefHeaderId);
</code>

(Optional) Remove index, which uses column CISKITWITHOUTCOMPS:
<code sql>
DROP INDEX IDX_POHEAD_KITWITHOUTCOMP;
</code>

Modify column CISKITWITHOUTCOMPS:
<code sql>
ALTER TABLE TAIRPOHEADER MODIFY CISKITWITHOUTCOMPS NUMBER GENERATED ALWAYS AS (CASE  WHEN (CISKIT=1 AND CKITCOMPONENTCOUNT=0) THEN 1 ELSE 0 END) VIRTUAL VISIBLE; 
</code>

(Optional) After that create index again:
<code sql>
CREATE INDEX IDX_POHEAD_KITWITHOUTCOMP ON TAIRPOHEADER(CISKITWITHOUTCOMPS);
</code>

Edit summary

Note: By editing this page you agree to license your content under the following license: CC Attribution-Share Alike 4.0 International