123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337 |
- <?xml version="1.0" encoding="EUC-KR"?>
- <?xml-stylesheet ype="text/css" href="../../../com/commonweb/css/common.css" ?>
- <xhtml:html xmlns:ex="http://www.comsquare.co.kr/xforms/excel" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:ms="urn:schemas-microsoft-com:xslt" xmlns:my="http://www.comsquare.co.kr/example" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events" xmlns:cs="http://www.comsquare.co.kr/xforms">
- <xhtml:head>
- <xhtml:title>품목별 창고 출고 조회</xhtml:title>
- <model id="model1">
- <instance id="instance1">
- <root xmlns="">
- <main>
- <delivelist/>
- </main>
- <send>
- <search>
- <instcd/>
- <ddfrom/>
- <ddto/>
- <wareflag/>
- <wareflagnm/>
- <goodcdfrom/>
- <goodcdto/>
- <delivedeptcd/>
- <delivedeptnm/>
- </search>
- <save/>
- </send>
- <init>
- <acnt/>
- </init>
- <hidden/>
- <temp>
- <maxasset/>
- </temp>
- <popgood>
- <instcd/>
- <wareflag/>
- <goodcd/>
- <goodnm/>
- <returntype/>
- <selectyn/>
- </popgood>
- </root>
- </instance>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- //화면 Control을 초기화한다
- misfGridInit(grd_delive);
- misfMsterDetailSet(grd_delive, null, "TRRSO21201" ,"Y");
-
- //화면에 repor 형식으로 보여줄 경우
- //makeReportPreview(0,123,1195,637);
- //model.removenode( "/root/main/delivelist");
- //misfComboComCdListMulti("Z0007","cmb_instcd"); //기관코드
- misfComboInstCdListMulti("cmb_instcd",getCurrentDate(),"","N");
- //2012.08.14 박준범 - 창고에 전체 항목 추가
- misfComboComCdList("030M0001",cmb_wareflag, "Y"); //창고 (Y: 전체 item 추가시)
-
- model.setValue("/root/send/search/instcd", getUserInfo("dutplceinstcd")); //기관 설정
- model.setValue("/root/send/search/ddfrom" , getCurrentDate()) //기간 설정 //.substr(0,6));
- model.setValue("/root/send/search/ddto" , getCurrentDate()) //기간 설정 //.substr(0,6));
-
- //test -> 향후 삭제할 것
- //model.setValue("/root/send/search/reqdd", "20110816");
- model.refresh();
-
- cmb_wareflag.dispatch("xforms-value-changed"); //출력 버튼 setting을 위해
-
-
- ]]>
- </script>
- <submission id="TRRSO20602" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search" resultref="/root/init/acnt"/>
- <submission id="TRRSO20802" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search" resultref="/root/temp/maxasset"/>
- <submission id="TRRSO21201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search" resultref="/root/main/"/>
- </model>
- <script type="javascript" src="../../../com/commonweb/js/common.js"/>
- <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
- <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
- <script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
- <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
- <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
- <script type="javascript">
- <![CDATA[
- ]]>
- </script>
- </xhtml:head>
- <xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
- <group id="grp_tle" style="left:0px; top:0px; width:1195px; height:13px; ">
- <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:243px; height:14px; ">품목별 창고 출고 조회</caption>
- </group>
- <group id="group1" style="left:0px; top:12; width:1195px; height:27px; ">
- <line id="line17" class="line_6" style="x1:0px; y1:25; x2:1195px; y2:25px; "/>
- <button id="btn_cust" class="btn3_letter7" style="left:948px; top:3px; width:116px; height:22px; ">
- <caption>거래처별 출력</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
-
- //조회된 자료가 없으면 먼저 조회하라고 message
- if(grd_delive.rows < 2) {
- messageBox("조회된 결과가 존재하지 않습니다. \n\n먼저 조회 후 출력하십시요.", "E999", "");
- return;
- }
-
- //창고명을 report 에 넘겨주기 위해 instance에 setting한다.
- model.setValue("/root/send/search/wareflagnm", cmb_wareflag.label);
-
- exeReportPreview("RPRSO21201", "XMLSTR");//, "/root/main/payamt");
-
- ]]>
- </script>
- </button>
- <button id="btn_dd" class="btn3_letter6" style="left:843px; top:3px; width:104px; height:22px; ">
- <caption>일자별 출력</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
-
- //조회된 자료가 없으면 먼저 조회하라고 message
- if(grd_delive.rows < 2) {
- messageBox("조회된 결과가 존재하지 않습니다. \n\n먼저 조회 후 출력하십시요.", "E999", "");
- return;
- }
-
- //창고명을 report 에 넘겨주기 위해 instance에 setting한다.
- model.setValue("/root/send/search/wareflagnm", cmb_wareflag.label);
-
- exeReportPreview("RPRSO21202", "XMLSTR");//, "/root/main/payamt");
-
- ]]>
- </script>
- </button>
- <button id="btn_good" class="btn3_letter8" style="left:1065px; top:3px; width:128px; height:22px; ">
- <caption>품목별 합계 출력</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
-
- //조회된 자료가 없으면 먼저 조회하라고 message
- if(grd_delive.rows < 2) {
- messageBox("조회된 결과가 존재하지 않습니다. \n\n먼저 조회 후 출력하십시요.", "E999", "");
- return;
- }
-
- //창고명을 report 에 넘겨주기 위해 instance에 setting한다.
- model.setValue("/root/send/search/wareflagnm", cmb_wareflag.label);
-
- exeReportPreview("RPRSO21203", "XMLSTR");//, "/root/main/payamt");
-
- ]]>
- </script>
- </button>
- </group>
- <group id="group3" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
- <group id="grp_search" style="left:0px; top:9px; width:1195px; height:66px; vertical-align:top; ">
- <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:61px; background-color:#fffbf2; border-color:#ffd799; "/>
- <button id="btn_search" class="btn1_letter2" navindex="8" style="left:1069px; top:19px; width:56px; height:22px; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- //2012.08.14 박준범 - 창고 "전체" 를 추가하면서 comment처리
- /*
- //창고에 선택된 값이 없으면, 창고를 선택하라고 alert함
- if(cmb_wareflag.value == "") {
- messageBox("창고가 선택되지 않았습니다. \n\n먼저 창고를 선택하십시요.", "E999", "");
- model.setFocus("cmb_wareflag");
- return;
- }
- */
- //년월에 입력된 값이 올바르지 않으면, 년월을 선택하라고 alert함
- if(ipt_ddfrom.value.length < 8) {
- messageBox("출고일자가 올바로 선택되지 않았습니다. \n\n먼저 출고일자을 선택하십시요.", "E999", "");
- model.setFocus("ipt_ddfrom");
- return;
- }
- if(ipt_ddto.value.length < 8) {
- messageBox("출고일자가 올바로 선택되지 않았습니다. \n\n먼저 출고일자을 선택하십시요.", "E999", "");
- model.setFocus("ipt_ddto");
- return;
- }
-
- misfMsterDetailRetrieve();
-
- ]]>
- </script>
- </button>
- <select1 id="cmb_instcd" ref="/root/send/search/instcd" class="combo_default" disabled="true" navindex="1" appearance="minimal" style="left:137px; top:10px; width:136px; height:19px; ">
- <choices>
- <itemset nodeset="/root/main/init">
- <label ref="cnstnm"/>
- <value ref="cnstcd"/>
- </itemset>
- </choices>
- </select1>
- <caption id="cap_instcd" class="search_name" style="left:58px; top:10px; width:77px; height:17px; ">기관코드</caption>
- <input id="ipt_ddfrom" ref="/root/send/search/ddfrom" navindex="5" inputtype="date" format="yyyy-mm-dd" style="left:754px; top:33px; width:87px; height:19px; "/>
- <line id="line30" class="line_4" style="x1:1045px; y1:8px; x2:1045px; y2:53px; "/>
- <caption id="caption2" class="search_name" style="left:321px; top:10px; width:104px; height:17px; ">창 고</caption>
- <select1 id="cmb_wareflag" ref="/root/send/search/wareflag" class="combo_default" navindex="2" appearance="minimal" style="left:426px; top:10px; width:135px; height:19px; ">
- <choices>
- <itemset nodeset="/root/init/wareflag">
- <label ref="cdnm"/>
- <value ref="cdid"/>
- </itemset>
- </choices>
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- //2012.08.14 박준범 - 창고가 "전체" 인 경우에만 품목별 합계를 출력할 수 있도록 한다.
- if(cmb_wareflag.value == "") {
- btn_dd.disabled = true;
- btn_cust.disabled = true;
- } else {
- btn_dd.disabled = false;
- btn_cust.disabled = false;
- }
- ]]>
- </script>
- </select1>
- <caption id="caption9" class="search_name" style="left:674px; top:33px; width:79px; height:17px; ">출고일자</caption>
- <caption id="caption4" style="left:843px; top:33px; width:10px; height:20px; font-weight:bold; ">-</caption>
- <input id="ipt_ddto" ref="/root/send/search/ddto" navindex="6" inputtype="date" format="yyyy-mm-dd" style="left:855px; top:33px; width:87px; height:19px; "/>
- <input id="ipt_goodcdfrom" ref="/root/send/search/goodcdfrom" class="input_default" navindex="3" maxlength="12" style="left:753px; top:10px; width:88px; height:19px; "/>
- <button id="btn_goodcdto" class="icon_search" navindex="3" style="left:961px; top:10px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- //popup 에 전달할 parameter를 setting한다.
- model.setValue("/root/popgood/instcd", cmb_instcd.value);
- model.setValue("/root/popgood/wareflag", cmb_wareflag.value);
- model.setValue("/root/popgood/returntype", "2"); //goodnm도 함께 return 받고자 할때, returntype을 "2" 로 설정.
- //selectyn(popup 창에서 선택버튼을 click했는지 아닌지를 나타내는 구분값) 을 초기화함
- model.setValue("/root/popgood/selectyn", "");
-
- //popup 프로그램 호출
- window.load("SPRSO20300.xrw", "modal","", "", "/root/popgood","/root/popdata");
- //popup에서 특정 물품코드를 선택한 경우, 해당 물품코드에 대한 상세 사항을 조회해서 그리드에 보여준다.
- if(model.getValue("/root/popgood/selectyn") == "Y") { //popup 창에서 선택버튼을 click했는지 아닌지를 나타내는 구분값
- ipt_goodcdto.value = model.getValue("/root/popgood/goodcd");
- //2012.09.17 박준범 - 아래 comment처리
- //opt_goodnmto.value = model.getValue("/root/popgood/goodnm");
- }
- ]]>
- </script>
- </button>
- <input id="ipt_goodcdto" ref="/root/send/search/goodcdto" class="input_default" navindex="4" maxlength="12" style="left:870px; top:10px; width:88px; height:19px; "/>
- <caption id="caption13" class="search_name" style="left:674px; top:10px; width:80px; height:17px; vertical-align:middle; ">물품코드</caption>
- <caption id="caption14" style="left:858px; top:9px; width:13px; height:20px; font-weight:bold; ">-</caption>
- <button id="btn_goodcdfrom" class="icon_search" navindex="3" style="left:844px; top:10px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- //popup 에 전달할 parameter를 setting한다.
- model.setValue("/root/popgood/instcd", cmb_instcd.value);
- model.setValue("/root/popgood/wareflag", cmb_wareflag.value);
- model.setValue("/root/popgood/returntype", "2"); //goodnm도 함께 return 받고자 할때, returntype을 "2" 로 설정.
- //selectyn(popup 창에서 선택버튼을 click했는지 아닌지를 나타내는 구분값) 을 초기화함
- model.setValue("/root/popgood/selectyn", "");
-
- //popup 프로그램 호출
- window.load("SPRSO20300.xrw", "modal","", "", "/root/popgood","/root/popdata");
- //popup에서 특정 물품코드를 선택한 경우, 해당 물품코드에 대한 상세 사항을 조회해서 그리드에 보여준다.
- if(model.getValue("/root/popgood/selectyn") == "Y") { //popup 창에서 선택버튼을 click했는지 아닌지를 나타내는 구분값
- ipt_goodcdfrom.value = model.getValue("/root/popgood/goodcd");
- //2012.09.17 박준범 - 아래 comment처리
- //opt_goodnmfrom.value = model.getValue("/root/popgood/goodnm");
- }
-
- ]]>
- </script>
- </button>
- <input id="ipt_delivedeptcd" ref="/root/send/search/delivedeptcd" class="input_default" navindex="2" style="left:426px; top:33px; width:70px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- //2013.02.26 박준범 : 부서코드 변경시 부서코드명을 먼저 지워준다.
- opt_delivedeptnm.value = "";
-
- misfValidationCheck("02", "", "delivedeptcd,delivedeptnm" );
-
- ]]>
- </script>
- <script type="javascript" ev:event="onkeypress">
- <![CDATA[
- //if( event.keyCode == 13 ) {
- //btn_search.dispatch("DOMActivate");
- // --> 위의 코드를 사용하면 input에 입력된 값이 인식이 안됨. TrustForm bug 같습니다.
- // --> 대신, 아래 코드 사용하면 input의 값이 인식이 됨
-
- //input 에서 EnterKey 이벤트 인식시 아래 function을 사용하세요!!
- inputEnterKey("ipt_delivedeptcd", "xforms-value-changed");
- //}
- ]]>
- </script>
- </input>
- <button id="btn_delivedeptcd" class="icon_search" navindex="3" style="left:498px; top:33px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var recv_list = "delivedeptcd,delivedeptnm";
- misfOpenPopUpList("02", ipt_delivedeptcd,"", recv_list) ;
- ipt_delivedeptcd.refresh();
- opt_delivedeptnm.refresh();
- ]]>
- </script>
- </button>
- <output id="opt_delivedeptnm" ref="/root/send/search/delivedeptnm" class="output_fix" appearance="output" style="left:516px; top:33px; width:126px; height:19px; "/>
- <caption id="caption20" class="search_name" style="left:321px; top:33px; width:102px; height:17px; vertical-align:middle; ">물품받는부서</caption>
- </group>
- <line id="line1" class="line_1" style="x1:0px; y1:100px; x2:1195px; y2:100px; "/>
- <caption id="caption1" class="tit_2" style="left:0px; top:83px; width:180px; height:13px; ">품목별 창고 출고 내역</caption>
- <datagrid id="grd_delive" nodeset="/root/main/delivelist" caption="출고일자^번호^거래처^출고부서^물품코드^물품명^규격^Box당 수^수량^단위" colsep="^" colwidth="78, 39, 153, 179, 91, 311, 129, 60, 70, 63" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:105px; width:1195px; height:600px; ">
- <col ref="delivedd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="deliveno" style="text-align:center; "/>
- <col ref="custnm"/>
- <col ref="deptnm"/>
- <col ref="goodcd" style="text-align:center; "/>
- <col ref="goodnm"/>
- <col ref="goodspec"/>
- <col ref="exchqty" format="#,###" style="text-align:right; "/>
- <col ref="deliveqty" format="(-)#,###.##" style="text-align:right; "/>
- <col ref="purcunit" style="text-align:center; "/>
- </datagrid>
- <button id="btn_excel" class="btn2_letter3" navindex="21" style="left:1138px; top:77px; width:53px; height:19px; ">
- <caption>엑셀</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- misfSaveExcel(grd_delive);
- ]]>
- </script>
- </button>
- </group>
- </xhtml:body>
- </xhtml:html>
|