| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657 |
- <?xml version="1.0" encoding="UTF-8"?>
- <Glue:GlueDiagram xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:Glue="http://www.glueframework.com/activitydiagram/" id="1" location="20,20" size="100,100">
- <child xsi:type="Glue:InitialState" id="1538" location="368,15" size="-1,-1" output="//@wire.0"/>
- <child xsi:type="Glue:FinalState" id="1539" location="370,615" size="-1,-1" input="//@wire.5"/>
- <child xsi:type="Glue:Activity" id="1567" location="272,88" size="224,-1" input="//@wire.0" output="//@wire.1" name="SetResultKeyList">
- <property key="class" value="com.posdata.glue.biz.trustform.PosSetResultKeyList"/>
- <property key="ResultKeyList" value="ListResult_1|ListResult_2|ListResult_3|LOVResult_1|LOVResult_2|LOVResult_3|LOVResult_4|LOVResult_5"/>
- <property key="description" value="1. ListResult_1 : 조회결과(상단)
2. ListResult_2 : 조회결과(하단)
2. LOV : 조회조건
 - LOVResult_1 : 표준강호(TBZ00_COMMCD's LG_CD = 'A02001')
 - LOVResult_2 : 납기분류(TBZ00_COMMCD's LG_CD = 'A02002')"/>
- </child>
- <child xsi:type="Glue:RouterActivity" id="1574" location="48,174" size="667,-1" input="//@wire.1" output="//@wire.2 //@wire.3 //@wire.8" name="EventRouter">
- <property key="class" value="com.posdata.glue.biz.activity.PosDefaultRouter"/>
- <property key="description" value="1.success : 최초 화면로딩
2.find : 조회
3.save : 저장"/>
- </child>
- <child xsi:type="Glue:SearchActivity" id="1588" location="271,348" size="223,-1" input="//@wire.2 //@wire.4" output="//@wire.6" name="SearchDlvtElementList">
- <property key="resultkey" value="ListResult_1"/>
- <property key="class" value="com.posdata.glue.biz.activity.PosSearch"/>
- <property key="dao" value="mesdao"/>
- <property key="sqlkey" value="UIA020010.List.DlvtElement.find"/>
- <property key="param-count" value="1"/>
- <property key="param0" value="ElmtDesc"/>
- <property key="description" value="- 사용자가 입력한 조회조건과 일치하는 정보를 납기요소테이블로부터 읽어와 ListResult_1에 담는다.
ex)
SELECT *
FROM TBA02_DLVT_ELMT
WHERE 1 = 1
AND ELMT_DESC LIKE :1||'%'"/>
- </child>
- <child xsi:type="Glue:SearchActivity" id="1595" location="269,437" size="223,-1" input="//@wire.6" output="//@wire.7" name="SearchDlvtDetailList">
- <property key="sqlkey" value="UIA020010.List.DlvtDetail.find"/>
- <property key="resultkey" value="ListResult_2"/>
- <property key="dao" value="mesdao"/>
- <property key="param0" value="ElmtDesc"/>
- <property key="class" value="com.posdata.glue.biz.activity.PosSearch"/>
- <property key="param-count" value="1"/>
- <property key="description" value="- 사용자가 입력한 조회조건과 일치하는 정보를 납기요소테이블로부터 읽어와 ListResult_2에 담는다.
ex)
SELECT A.ELMT_SEQ, B.SPEC_STL_GRD, B.DLVT_GRP_TP, B.ELMT_SEQ, B.TERM_DAYS, B.TERM_DAYS_DESC
 , B.REG_ID, TO_CHAR(TO_DATE(B.REG_DTIME,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS REG_DTIME
 , B.MOD_ID, TO_CHAR(TO_DATE(B.MOD_DTIME,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS MOD_DTIME
 , ROW_NUMBER() OVER (ORDER BY B.SPEC_STL_GRD, B.DLVT_GRP_TP) AS RN
 , Z.DLVT_GRP_TP_DESC
FROM TBA02_DLVT_ELMT A, TBA02_DLVT_DTL B
 ,(SELECT SM_CFNM AS DLVT_GRP_TP_DESC, SM_CD AS DLVT_GRP_TP
 FROM TBZ00_COMMCD
 WHERE LG_CD = 'A02002') Z
WHERE 1 = 1
AND B.DLVT_GRP_TP = Z.DLVT_GRP_TP(+)
AND A.ELMT_SEQ = B.ELMT_SEQ(+)
AND A.ELMT_DESC LIKE '%'||:1||'%'
ORDER BY A.ELMT_SEQ, B.SPEC_STL_GRD, B.DLVT_GRP_TP"/>
- </child>
- <child xsi:type="Glue:Activity" id="1598" location="495,261" size="222,-1" input="//@wire.3" output="//@wire.4" name="SaveDlvtElementList">
- <property key="class" value="xin.glue.ui.A.A02.SaveDlvtElementList"/>
- <property key="description" value="화면으로부터
추가,변경,삭제처리된 내용을 TBA02_DLVT_ELMT 테이블에 저장 처리한다."/>
- </child>
- <child xsi:type="Glue:SearchActivity" id="1603" location="49,523" size="445,-1" input="//@wire.7 //@wire.8" output="//@wire.5" name="SearchMaxPKValue">
- <property key="class" value="com.posdata.glue.biz.activity.PosSearch"/>
- <property key="resultkey" value="LOVResult_3"/>
- <property key="dao" value="mesdao"/>
- <property key="sqlkey" value="UIA020010.LOV.MaxPKValue.find"/>
- <property key="param-count" value="0"/>
- <property key="description" value="- 납기요소테이블의 PK(ELMT_SEQ)의 MAX값을 LOVResult_3에 담는다.
ex)
UIA020010.LOV.MaxPKValue.find
SELECT MAX(ELMT_SEQ) FROM TBA02_DLVT_ELMT"/>
- </child>
- <property key="tx1" value="true"/>
- <property key="description" value=""/>
- <wire id="684" guardcondition="success" firstRelativePoint="160,61" lastRelativePoint="160,115"/>
- <wire id="685" guardcondition="success" firstRelativePoint="378,118" lastRelativePoint="378,174"/>
- <wire id="689" guardcondition="find" firstRelativePoint="379,204" lastRelativePoint="379,348"/>
- <wire id="690" guardcondition="save" firstRelativePoint="607,231" lastRelativePoint="607,288"/>
- <wire id="692" guardcondition="success" firstRelativePoint="605,318" lastRelativePoint="494,389">
- <bendpoint weight="0.5" firstDimension="-1,86" secondDimension="223,-1"/>
- </wire>
- <wire id="699" guardcondition="success" firstRelativePoint="380,553" lastRelativePoint="380,614"/>
- <wire id="701" guardcondition="success" firstRelativePoint="380,378" lastRelativePoint="380,437"/>
- <wire id="702" guardcondition="success" firstRelativePoint="379,467" lastRelativePoint="379,523"/>
- <wire id="703" guardcondition="success" firstRelativePoint="165,204" lastRelativePoint="165,523"/>
- </Glue:GlueDiagram>
|