| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586 |
- <?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="150,15" size="-1,-1" output="//@wire.0"/>
- <child xsi:type="Glue:FinalState" id="1539" location="376,455" size="-1,-1" input="//@wire.6 //@wire.7 //@wire.10 //@wire.11"/>
- <child xsi:type="Glue:Activity" id="1567" location="48,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="913,-1" input="//@wire.1" output="//@wire.2 //@wire.4 //@wire.5 //@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="1575" location="49,261" size="223,-1" input="//@wire.2" output="//@wire.3" name="SearchSpecStlGrdLOV">
- <property key="dao" value="mesdao"/>
- <property key="sqlkey" value="UIA020020.LOV.SpecStlGrd.find"/>
- <property key="class" value="com.posdata.glue.biz.activity.PosSearch"/>
- <property key="param-count" value="0"/>
- <property key="resultkey" value="LOVResult_1"/>
- <property key="description" value="- 조회조건 및 결과내용 표시 시 LOV로 사용되는 표준강호 정보를 LOVResult_1에 담는다.
ex)
SELECT *
FROM TBZ00_COMMCD
WHERE LG_CD = 'A02001'"/>
- </child>
- <child xsi:type="Glue:SearchActivity" id="1581" location="48,348" size="224,-1" input="//@wire.3" output="//@wire.10" name="SearchDlvtGrpTpLOV">
- <property key="dao" value="mesdao"/>
- <property key="sqlkey" value="UIA020020.LOV.DlvtGrpTp.find"/>
- <property key="class" value="com.posdata.glue.biz.activity.PosSearch"/>
- <property key="param-count" value="0"/>
- <property key="resultkey" value="LOVResult_2"/>
- <property key="description" value="- 조회조건 및 결과 표시 시 LOV로 사용되는 납기분류 정보를 LOVResult_2에 담는다.
ex)
SELECT *
FROM TBZ00_COMMCD
WHERE LG_CD = 'A02002'

"/>
- </child>
- <child xsi:type="Glue:SearchActivity" id="1595" location="738,261" size="223,-1" input="//@wire.8" output="//@wire.9" name="SearchDlvtDetailList">
- <property key="sqlkey" value="UIA020020.List.DlvtDetail.find"/>
- <property key="resultkey" value="ListResult_2"/>
- <property key="dao" value="mesdao"/>
- <property key="param0" value="SpecStlGrd"/>
- <property key="param1" value="DlvtGrpType"/>
- <property key="class" value="com.posdata.glue.biz.activity.PosSearch"/>
- <property key="param-count" value="2"/>
- <property key="description" value="- 사용자가 입력한 조회조건과 일치하는 정보를 납기상세테이블로부터 읽어와 ListResult_2에 담는다.
ex)
UIA020020.List.DlvtDetail.find
SELECT A.SPEC_STL_GRD AS SPEC_STL_GRD
 , A.DLVT_GRP_TP AS DLVT_GRP_TP
 , A.ELMT_SEQ AS ELMT_SEQ
 , A.TERM_DAYS AS TERM_DAYS
 , A.TERM_DAYS_DESC AS TERM_DAYS_DESC
 , A.REG_ID AS REG_ID
 , TO_CHAR(TO_DATE(A.REG_DTIME,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS REG_DTIME
 , A.MOD_ID AS MOD_ID
 , TO_CHAR(TO_DATE(A.MOD_DTIME,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS MOD_DTIME
FROM TBA02_DLVT_DTL A
WHERE 1 = 1
AND A.SPEC_STL_GRD LIKE :1||'%'
AND A.DLVT_GRP_TP LIKE :2||'%'
ORDER BY A.SPEC_STL_GRD, A.DLVT_GRP_TP, A.ELMT_SEQ
"/>
- </child>
- <child xsi:type="Glue:Activity" id="1598" location="508,348" size="222,-1" input="//@wire.4" output="//@wire.11" name="SaveDlvtDetailList">
- <property key="class" value="xin.glue.ui.A.A02.SaveDlvtDetailList"/>
- <property key="description" value="화면으로부터
추가,변경,삭제처리된 내용을 TBA02_DLVT_DTL 테이블에 저장 처리한다."/>
- </child>
- <child xsi:type="Glue:SearchActivity" id="1603" location="278,348" size="223,-1" input="//@wire.5" output="//@wire.7" name="SearchDlvtGroupList">
- <property key="sqlkey" value="UIA020020.List.DlvtGroup.find"/>
- <property key="resultkey" value="ListResult_1"/>
- <property key="dao" value="mesdao"/>
- <property key="param0" value="SpecStlGrd"/>
- <property key="param2" value="SpecStlGrd"/>
- <property key="param3" value="DlvtGrpType"/>
- <property key="class" value="com.posdata.glue.biz.activity.PosSearch"/>
- <property key="parma1" value="DlvtGrpType"/>
- <property key="param-count" value="4"/>
- <property key="description" value="- 납기요소테이블의 PK(ELMT_SEQ)의 MAX값을 LOVResult_1에 담는다.
ex)
UIA020020.List.DlvtGroup.find
SELECT A.SPEC_STL_GRD
 , A.DLVT_GRP_TP
 , A.DSP_SEQ
 , NVL(B.SUM_TERM_DAYS,0) AS SUM_TERM_DAYS
 , A.REMARKS
FROM TBA02_DLVT_GRP A
 ,(SELECT X.SPEC_STL_GRD, X.DLVT_GRP_TP, SUM(X.TERM_DAYS) AS SUM_TERM_DAYS
 FROM TBA02_DLVT_DTL X
 WHERE X.SPEC_STL_GRD LIKE :1||'%'
 AND X.DLVT_GRP_TP LIKE :2||'%'
 GROUP BY X.SPEC_STL_GRD, X.DLVT_GRP_TP) B
WHERE A.SPEC_STL_GRD = B.SPEC_STL_GRD(+)
AND A.DLVT_GRP_TP = B.DLVT_GRP_TP(+)
AND A.SPEC_STL_GRD LIKE :3||'%'
AND A.DLVT_GRP_TP LIKE :4||'%'
"/>
- </child>
- <child xsi:type="Glue:SearchActivity" id="1621" location="738,348" size="223,-1" input="//@wire.9" output="//@wire.6" name="SearchDlvtOrderList">
- <property key="param-count" value="2"/>
- <property key="resultkey" value="ListResult_3"/>
- <property key="param0" value="SpecStlGrd"/>
- <property key="param1" value="DlvtGrpType"/>
- <property key="dao" value="mesdao"/>
- <property key="sqlkey" value="UIA020020.List.DlvtOrder.find"/>
- <property key="class" value="com.posdata.glue.biz.activity.PosSearch"/>
- <property key="description" value="- 사용자가 입력한 조회조건과 일치하는 정보를 주문행번납기테이블로부터 읽어와 ListResult_3에 담는다.
ex)
UIA020020.List.DlvtOrder.find
SELECT A.ORD_DLVT_SEQ AS ORD_DLVT_SEQ3
 , A.ORD_SEQ AS ORD_SEQ3
 , A.ORD_NO AS ORD_NO3
 , A.SPEC_STL_GRD AS ORD_SPEC_STL_GRD3
 , A.DLVT_GRP_TP AS ORD_DLVT_GRP_TP3
 , A.ELMT_SEQ AS ORD_ELMT_SEQ3
 , A.REG_ID AS ORD_REG_ID3
 , TO_CHAR(TO_DATE(A.REG_DTIME,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS ORD_REG_DTIME3
 , A.MOD_ID AS ORD_MOD_ID3
 , TO_CHAR(TO_DATE(A.MOD_DTIME,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS ORD_MOD_DTIME3
 , A.DLVT_DATE AS ORD_DLVT_DATE3
FROM TBA02_DLVT_ORD A
WHERE 1 = 1
AND A.SPEC_STL_GRD = :1
AND A.DLVT_GRP_TP = :2
AND A.ORD_NO LIKE :3||'%' AND A.ORD_SEQ LIKE :4||'%'
ORDER BY A.SPEC_STL_GRD, A.DLVT_GRP_TP, A.ORD_NO, A.ORD_SEQ
"/>
- </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="160,145" lastRelativePoint="160,201"/>
- <wire id="686" guardcondition="success" firstRelativePoint="160,231" lastRelativePoint="160,288"/>
- <wire id="687" guardcondition="success" firstRelativePoint="161,318" lastRelativePoint="161,375"/>
- <wire id="690" guardcondition="save" firstRelativePoint="619,204" lastRelativePoint="619,348"/>
- <wire id="707" guardcondition="find" firstRelativePoint="384,204" lastRelativePoint="384,348"/>
- <wire id="723" guardcondition="success" firstRelativePoint="851,378" lastRelativePoint="396,464">
- <bendpoint weight="0.5" firstDimension="2,101" secondDimension="465,-1"/>
- </wire>
- <wire id="725" guardcondition="success" firstRelativePoint="378,378" lastRelativePoint="378,619"/>
- <wire id="726" guardcondition="detail" firstRelativePoint="850,204" lastRelativePoint="850,261"/>
- <wire id="727" guardcondition="success" firstRelativePoint="852,291" lastRelativePoint="852,348"/>
- <wire id="730" guardcondition="success" firstRelativePoint="161,378" lastRelativePoint="375,464">
- <bendpoint weight="0.5" firstDimension="1,101" secondDimension="-225,-1"/>
- </wire>
- <wire id="731" guardcondition="success" firstRelativePoint="618,378" lastRelativePoint="396,464">
- <bendpoint weight="0.5" firstDimension="-1,101" secondDimension="232,-1"/>
- </wire>
- </Glue:GlueDiagram>
|
