123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194 |
- <?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:my="http://www.comsquare.co.kr/example" xmlns:ms="urn:schemas-microsoft-com:xslt" 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="">
- <cond>
- <instcd/>
- <srchmm/>
- <deptcd/>
- <deptnm/>
- <fromacntcd/>
- <toacntcd/>
- <gubun>1</gubun>
- </cond>
- <main>
- <list>
- <deptstocmmlist/>
- <deptstocexcel/>
- </list>
- </main>
- <send>
- </send>
- <init>
- <acnt>
- <acntlist/>
- </acnt>
- </init>
- <hidden>
- <acnt>
- <acntlist/>
- </acnt>
- </hidden>
- <temp>
- </temp>
- </root>
- </instance>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
-
- //화면 Control을 초기화한다
- makeReportPreview(0,123,1195,637);
- model.removeNodeset( "/root/main/list/deptstocmmlist");
- model.removeNodeset( "/root/main/list/deptstocexcel"); //excel 출력용
- //misfComboComCdListMulti("Z0007","cmb_instcd"); //기관코드
- misfComboInstCdListMulti("cmb_instcd",getCurrentDate(),"","N");
-
-
- model.setValue("/root/cond/instcd" , getUserInfo("dutplceinstcd")); //기관 설정
- model.setValue("/root/cond/srchmm" , getCurrentDate().substr(0,6)); //청구일자 설정
-
- model.makeValue("/root/send/reqdata/instcd",getUserInfo("dutplceinstcd"));
- if(submit("TRRSO20602")){
- //model.removeNodeset("/root/hidden/acnt/acntlist");
- //model.makeNode();
- copyNodesetType("/root/hidden/acnt/acntlist", "/root/init/acnt/acntlist","replace");
- }
- model.refresh();
- ]]>
- </script>
- <submission id="TRRSO20701" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/cond" resultref="/root/main/list"/>
- <submission id="TRRSO20602" method="post" ref="/root/send/reqdata" resultref="/root/init/acnt"/>
- </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; "/>
- </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:48px; vertical-align:top; ">
- <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:40px; background-color:#fffbf2; border-color:#ffd799; "/>
- <button id="btn_search" class="btn1_letter2" navindex="7" style="left:1129px; top:9px; width:56px; height:22px; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
-
- if (submit("TRRSO20701") ){
- //exeReportPreview("RPRSO20701", "XMLSTR");//, "/root/main/payamt"); 가로양식
- exeReportPreview("RPRSO20702", "XMLSTR");//, "/root/main/payamt"); 세로양식
- }
-
- ]]>
- </script>
- </button>
- <select1 id="cmb_instcd" ref="/root/cond/instcd" class="combo_default" disabled="true" navindex="1" appearance="minimal" style="left:69px; 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:13px; top:10px; width:86px; height:17px; ">기관:</caption>
- <input id="ipt_reqdd" ref="/root/cond/srchmm" navindex="2" inputtype="date" format="yyyy-mm" style="left:257px; top:10px; width:74px; height:19px; text-align:left; "/>
- <caption id="caption20" class="search_name" style="left:346px; top:10px; width:59px; height:17px; vertical-align:middle; ">부서:</caption>
- <line id="line30" class="line_4" style="x1:1120px; y1:4px; x2:1120px; y2:36px; "/>
- <button id="btn_reqdeptcd" class="icon_search" navindex="4" style="left:473px; top:10px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var recv_list = "deptcd,deptnm";
- misfOpenPopUpList("02", ipt_deptcd,"", recv_list) ;
- ipt_deptcd.refresh();
- ipt_deptnm.refresh();
- ]]>
- </script>
- </button>
- <input id="ipt_deptcd" ref="/root/cond/deptcd" class="input_default" navindex="3" style="left:401px; top:10px; width:70px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- misfValidationCheck("02", "", "deptcd,deptnm" );
- ]]>
- </script>
- </input>
- <output id="ipt_deptnm" ref="/root/cond/deptnm" class="output_fix" appearance="output" style="left:491px; top:10px; width:109px; height:19px; "/>
- <caption id="caption9" class="search_name" style="left:215px; top:10px; width:69px; height:17px; ">월:</caption>
- <caption id="caption2" class="search_name" style="left:615px; top:10px; width:125px; height:17px; vertical-align:middle; ">계정:</caption>
- <select1 id="combo1" ref="/root/cond/fromacntcd" class="combo_default" navindex="5" appearance="minimal" editmode="search" itemcount="20" showvalue="true" style="left:670px; top:10px; width:145px; height:19px; ">
- <choices>
- <itemset nodeset="/root/init/acnt/acntlist">
- <label ref="acntnm"/>
- <value ref="acntcd"/>
- </itemset>
- </choices>
- </select1>
- <caption id="caption3" style="left:817px; top:10px; width:15px; height:20px; ">~</caption>
- <select1 id="combo2" ref="/root/cond/toacntcd" class="combo_default" navindex="6" appearance="minimal" editmode="search" itemcount="20" showvalue="true" style="left:830px; top:10px; width:145px; height:19px; ">
- <choices>
- <itemset nodeset="/root/hidden/acnt/acntlist">
- <label ref="acntnm"/>
- <value ref="acntcd"/>
- </itemset>
- </choices>
- </select1>
- <caption id="caption4" class="search_name" style="left:980px; top:10px; width:60px; height:17px; vertical-align:middle; ">구분:</caption>
- <select1 id="cmb_gubun" ref="/root/cond/gubun" appearance="minimal" style="left:1038px; top:10px; width:67px; height:19px; ">
- <choices>
- <item>
- <label>무산정+창고</label>
- <value>1</value>
- </item>
- <item>
- <label>전체</label>
- <value>2</value>
- </item>
- </choices>
- </select1>
- </group>
- <line id="line1" class="line_1" style="x1:0px; y1:78px; x2:1195px; y2:78px; "/>
- <caption id="caption1" class="tit_2" style="left:0px; top:63px; width:180px; height:14px; ">월 재고수불장(부서재고)</caption>
- <datagrid id="grd_deptstocexcel" nodeset="/root/main/list/deptstocexcel" visibility="hidden" caption="계정과목^품목코드^품목명^규격^전기이월^전기이월^당월입고^당월입고^당월출고^당월출고^당월재고^당월재고|계정과목^품목코드^품목명^규격^수량^금액^수량^금액^수량^금액^수량^금액" colsep="^" colwidth="138, 97, 239, 184, 90, 90, 90, 91, 90, 91, 90, 90" mergecellsfixedrows="bycolrec" rowsep="|" style="left:70px; top:110px; width:850px; height:105px; font-size:10pt; ">
- <col ref="acntnm" style="font-size:10pt; "/>
- <col ref="goodcd" style="font-size:10pt; text-align:center; "/>
- <col ref="goodnm" style="font-size:10pt; "/>
- <col ref="goodspec" style="font-size:10pt; "/>
- <col ref="transqty" format="#,###.##" style="font-size:10pt; text-align:right; "/>
- <col ref="transamt" format="#,###.##" style="font-size:10pt; text-align:right; "/>
- <col ref="winqty" format="#,###.##" style="font-size:10pt; text-align:right; "/>
- <col ref="winamt" format="#,###.##" style="font-size:10pt; text-align:right; "/>
- <col ref="deliveqty" format="#,###.##" style="font-size:10pt; text-align:right; "/>
- <col ref="deliveamt" format="#,###.##" style="font-size:10pt; text-align:right; "/>
- <col ref="stocqty" format="#,###.##" style="font-size:10pt; text-align:right; "/>
- <col ref="stocamt" format="#,###.##" style="font-size:10pt; text-align:right; "/>
- </datagrid>
- <button id="btn_excel" class="btn2_letter3" navindex="21" style="left:1138px; top:57px; width:53px; height:19px; ">
- <caption>엑셀</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- if (grd_deptstocexcel.rows == grd_deptstocexcel.fixedRows) return;
-
- misfSaveExcel(grd_deptstocexcel);
- ]]>
- </script>
- </button>
- </group>
- </xhtml:body>
- </xhtml:html>
|