123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480 |
- <?xml version="1.0" encoding="EUC-KR"?>
- <?xml-stylesheet type="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="">
- <main>
- <mtaltotllist>
- <acntflagnm/>
- <trnsamt/>
- <inputamt/>
- <outputamt/>
- <endmonamt/>
- <instcd/>
- <winacnt/>
- </mtaltotllist>
- </main>
- <send>
- <goodreq>
- <instcd/>
- <inputmonth/>
- <purcflag/>
- </goodreq>
- <savedata/>
- </send>
- <init>
- </init>
- <temp/>
- <temp>
- <mtaltotllist>
- <acntflagnm/>
- <trnsamt/>
- <inputamt/>
- <outputamt/>
- <endmonamt/>
- <instcd/>
- <winacnt/>
- </mtaltotllist>
- </temp>
- </root>
- </instance>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- fInitialize();
- ]]>
- </script>
- <submission id="TRRST06001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/goodreq" resultref="/root/main/mtaltotllist"/>
- </model>
- <script type="javascript" src="../../../com/commonweb/js/common.js"/>
- <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
- <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
- <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
- <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
- <script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
- <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
- <script type="javascript">
- <![CDATA[
-
- // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
- function fInitialize()
- {
- rszfUserReqInstList(cmb_instcd,getUserInfo("userid"),"%","B");
- cmb_instcd.refresh();
-
- model.setValue(cmb_instcd.attribute("ref"), getUserInfo("dutplceinstcd"));
- cmb_instcd.refresh();
-
- model.setValue(ipt_inputmonth.attribute("ref"), getCurrentDate().substr(0, 6));
-
- ipt_inputmonth.refresh();
-
- }
-
- function fSetSumAmt() {
- var trnsamt = 0;
- var inputamt = 0;
- var outputamt = 0;
- var endmonamt = 0;
- var winacnt = "";
-
- //진료재료
- var trnsamt_11202 = 0;
- var inputamt_11202 = 0;
- var outputamt_11202 = 0;
- var endmonamt_11202 = 0;
- var idx_11202 = 0;
-
- //급식재료
- var trnsamt_11203 = 0;
- var inputamt_11203 = 0;
- var outputamt_11203 = 0;
- var endmonamt_11203 = 0;
- var idx_11203 =0;
-
- //저장품
- var trnsamt_11204 = 0;
- var inputamt_11204 = 0;
- var outputamt_11204 = 0;
- var endmonamt_11204 = 0;
- var idx_11204 = 0;
-
- //공기구비품
- var trnsamt_12207 = 0;
- var inputamt_12207 = 0;
- var outputamt_12207 = 0;
- var endmonamt_12207 = 0;
- var idx_12207 = 0;
-
- //기계장치
- var trnsamt_12204 = 0;
- var inputamt_12204 = 0;
- var outputamt_12204 = 0;
- var endmonamt_12204 = 0;
- var idx_12204 = 0;
-
- //의료장비
- var trnsamt_12205 = 0;
- var inputamt_12205 = 0;
- var outputamt_12205 = 0;
- var endmonamt_12205 = 0;
- var idx_12205 = 0;
-
- //차량운반구
- var trnsamt_12206 = 0;
- var inputamt_12206 = 0;
- var outputamt_12206 = 0;
- var endmonamt_12206 = 0;
- var idx_12206 = 0;
-
- var cnt_11202 = 0;
- var cnt_11203 = 0;
- var cnt_11204 = 0;
- var cnt_12204 = 0;
- var cnt_12205 = 0;
- var cnt_12206 = 0;
- var cnt_12207 = 0;
-
- var sumtrnsamt =0;
-
- var suminputamt = 0;
- var sumoutputamt = 0;
- var sumendmonamt =0;
-
-
- for(var i = grd_mtaltotllist.fixedRows; i < grd_mtaltotllist.rows; i++) {
- winacnt = grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("winacnt")).substr(0, 5);
- sumtrnsamt += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("trnsamt")));
- suminputamt += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputamt")));
- sumoutputamt += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("outputamt")));
- sumendmonamt += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("endmonamt")));
-
- if(winacnt == "11202") { //진료재료
- trnsamt_11202 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("trnsamt")));
- inputamt_11202 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputamt")));
- outputamt_11202 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("outputamt")));
- endmonamt_11202 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("endmonamt")));
- idx_11202 = i;
- cnt_11202++;
-
- } else if(winacnt == "11203") { //급식재료
- trnsamt_11203 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("trnsamt")));
- inputamt_11203 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputamt")));
- outputamt_11203 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("outputamt")));
- endmonamt_11203 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("endmonamt")));
- idx_11203 = i;
- cnt_11203++;
- } else if(winacnt =="11204") { //저장품
- trnsamt_11204 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("trnsamt")));
- inputamt_11204 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputamt")));
- outputamt_11204 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("outputamt")));
- endmonamt_11204 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("endmonamt")));
- idx_11204 = i;
- cnt_11204++;
- } else if(winacnt =="12204") { //기계장치
- trnsamt_12204 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("trnsamt")));
- inputamt_12204 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputamt")));
- outputamt_12204 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("outputamt")));
- endmonamt_12204 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("endmonamt")));
- idx_12204 = i;
- cnt_12204++;
- } else if(winacnt =="12205") { //의료장비
- trnsamt_12205 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("trnsamt")));
- inputamt_12205 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputamt")));
- outputamt_12205 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("outputamt")));
- endmonamt_12205 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("endmonamt")));
- idx_12205 = i;
- cnt_12205++;
- } else if(winacnt =="12206") { //차량운반구
- trnsamt_12206 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("trnsamt")));
- inputamt_12206 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputamt")));
- outputamt_12206 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("outputamt")));
- endmonamt_12206 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("endmonamt")));
-
- idx_12206 = i;
- cnt_12206++
- }else if(winacnt =="12207") { //공기구비품
- trnsamt_12207 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("trnsamt")));
- inputamt_12207 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputamt")));
- outputamt_12207 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("outputamt")));
- endmonamt_12207 += Number(grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("endmonamt")));
- idx_12207 = i;
- cnt_12207++;
- }
-
- }
-
- if(cnt_11202 != 0) {
-
- grd_mtaltotllist.insertRow(idx_11202 ,"below", "false", "true");
- grd_mtaltotllist.valueMatrix(idx_11202+1, grd_mtaltotllist.colRef("acntflagnm")) = "▶진료재료품";
- grd_mtaltotllist.valueMatrix(idx_11202+1, grd_mtaltotllist.colRef("trnsamt")) = trnsamt_11202;
- grd_mtaltotllist.valueMatrix(idx_11202+1, grd_mtaltotllist.colRef("inputamt")) = inputamt_11202;
- grd_mtaltotllist.valueMatrix(idx_11202+1, grd_mtaltotllist.colRef("outputamt")) = outputamt_11202;
- grd_mtaltotllist.valueMatrix(idx_11202+1, grd_mtaltotllist.colRef("endmonamt")) = endmonamt_11202;
-
- idx_11202 += 1;
- idx_11203 += 1;
- idx_11204 += 1;
- idx_12204 += 1;
- idx_12205 += 1;
- idx_12206 += 1;
- idx_12207 += 1;
-
- }
-
- if(cnt_11203 != 0) {
-
- grd_mtaltotllist.insertRow(idx_11203 ,"below", "false", "true");
- grd_mtaltotllist.valueMatrix(idx_11203+1, grd_mtaltotllist.colRef("acntflagnm")) = "▶급식재료품";
- grd_mtaltotllist.valueMatrix(idx_11203+1, grd_mtaltotllist.colRef("trnsamt")) = trnsamt_11203;
- grd_mtaltotllist.valueMatrix(idx_11203+1, grd_mtaltotllist.colRef("inputamt")) = inputamt_11203;
- grd_mtaltotllist.valueMatrix(idx_11203+1, grd_mtaltotllist.colRef("outputamt")) = outputamt_11203;
- grd_mtaltotllist.valueMatrix(idx_11203+1, grd_mtaltotllist.colRef("endmonamt")) = endmonamt_11203;
-
- idx_11202 += 1;
- idx_11203 += 1;
- idx_11204 += 1;
- idx_12204 += 1;
- idx_12205 += 1;
- idx_12206 += 1;
- idx_12207 += 1;
-
- }
- if(cnt_11204 != 0) {
-
- grd_mtaltotllist.insertRow(idx_11204 ,"below", "false", "true");
- grd_mtaltotllist.valueMatrix(idx_11204+1, grd_mtaltotllist.colRef("acntflagnm")) = "▶저장품";
- grd_mtaltotllist.valueMatrix(idx_11204+1, grd_mtaltotllist.colRef("trnsamt")) = trnsamt_11204;
- grd_mtaltotllist.valueMatrix(idx_11204+1, grd_mtaltotllist.colRef("inputamt")) = inputamt_11204;
- grd_mtaltotllist.valueMatrix(idx_11204+1, grd_mtaltotllist.colRef("outputamt")) = outputamt_11204;
- grd_mtaltotllist.valueMatrix(idx_11204+1, grd_mtaltotllist.colRef("endmonamt")) = endmonamt_11204;
-
- idx_11202 += 1;
- idx_11203 += 1;
- idx_11204 += 1;
- idx_12204 += 1;
- idx_12205 += 1;
- idx_12206 += 1;
- idx_12207 += 1;
-
- }
-
-
- if(cnt_12204 != 0) {
-
- grd_mtaltotllist.insertRow(idx_12204 ,"below", "false", "true");
- grd_mtaltotllist.valueMatrix(idx_12204+1, grd_mtaltotllist.colRef("acntflagnm")) = "[기계장치]";
- grd_mtaltotllist.valueMatrix(idx_12204+1, grd_mtaltotllist.colRef("trnsamt")) = trnsamt_12204;
- grd_mtaltotllist.valueMatrix(idx_12204+1, grd_mtaltotllist.colRef("inputamt")) = inputamt_12204;
- grd_mtaltotllist.valueMatrix(idx_12204+1, grd_mtaltotllist.colRef("outputamt")) = outputamt_12204;
- grd_mtaltotllist.valueMatrix(idx_12204+1, grd_mtaltotllist.colRef("endmonamt")) = endmonamt_12204;
-
- idx_11202 += 1;
- idx_11203 += 1;
- idx_11204 += 1;
- idx_12204 += 1;
- idx_12205 += 1;
- idx_12206 += 1;
- idx_12207 += 1;
-
- }
- if(cnt_12205 != 0) {
-
- grd_mtaltotllist.insertRow(idx_12205 ,"below", "false", "true");
- grd_mtaltotllist.valueMatrix(idx_12205+1, grd_mtaltotllist.colRef("acntflagnm")) = "[의료장비]";
- grd_mtaltotllist.valueMatrix(idx_12205+1, grd_mtaltotllist.colRef("trnsamt")) = trnsamt_12205;
- grd_mtaltotllist.valueMatrix(idx_12205+1, grd_mtaltotllist.colRef("inputamt")) = inputamt_12205;
- grd_mtaltotllist.valueMatrix(idx_12205+1, grd_mtaltotllist.colRef("outputamt")) = outputamt_12205;
- grd_mtaltotllist.valueMatrix(idx_12205+1, grd_mtaltotllist.colRef("endmonamt")) = endmonamt_12205;
-
- idx_11202 += 1;
- idx_11203 += 1;
- idx_11204 += 1;
- idx_12204 += 1;
- idx_12205 += 1;
- idx_12206 += 1;
- idx_12207 += 1;
-
- }
- if(cnt_12206 != 0) {
-
- grd_mtaltotllist.insertRow(idx_12206 ,"below", "false", "true");
- grd_mtaltotllist.valueMatrix(idx_12206+1, grd_mtaltotllist.colRef("acntflagnm")) = "[차량운반구]";
- grd_mtaltotllist.valueMatrix(idx_12206+1, grd_mtaltotllist.colRef("trnsamt")) = trnsamt_12206;
- grd_mtaltotllist.valueMatrix(idx_12206+1, grd_mtaltotllist.colRef("inputamt")) = inputamt_12206;
- grd_mtaltotllist.valueMatrix(idx_12206+1, grd_mtaltotllist.colRef("outputamt")) = outputamt_12206;
- grd_mtaltotllist.valueMatrix(idx_12206+1, grd_mtaltotllist.colRef("endmonamt")) = endmonamt_12206;
- //
- idx_11202 += 1;
- idx_11203 += 1;
- idx_11204 += 1;
- idx_12204 += 1;
- idx_12205 += 1;
- idx_12206 += 1;
- idx_12207 += 1;
-
- }
- if(cnt_12207 != 0) {
-
- grd_mtaltotllist.insertRow(idx_12207 ,"below", "false", "true");
- grd_mtaltotllist.valueMatrix(idx_12207+1, grd_mtaltotllist.colRef("acntflagnm")) = "[공기구비품]";
- grd_mtaltotllist.valueMatrix(idx_12207+1, grd_mtaltotllist.colRef("trnsamt")) = trnsamt_12207;
- grd_mtaltotllist.valueMatrix(idx_12207+1, grd_mtaltotllist.colRef("inputamt")) = inputamt_12207;
- grd_mtaltotllist.valueMatrix(idx_12207+1, grd_mtaltotllist.colRef("outputamt")) = outputamt_12207;
- grd_mtaltotllist.valueMatrix(idx_12207+1, grd_mtaltotllist.colRef("endmonamt")) = endmonamt_12207;
-
- idx_11202 += 1;
- idx_11203 += 1;
- idx_11204 += 1;
- idx_12204 += 1;
- idx_12205 += 1;
- idx_12206 += 1;
- idx_12207 += 1;
- }
-
- grd_mtaltotllist.addRow();
- grd_mtaltotllist.valueMatrix(grd_mtaltotllist.rows-1, grd_mtaltotllist.colRef("acntflagnm")) = "총계";
- grd_mtaltotllist.valueMatrix(grd_mtaltotllist.rows-1, grd_mtaltotllist.colRef("trnsamt")) = sumtrnsamt;
- grd_mtaltotllist.valueMatrix(grd_mtaltotllist.rows-1, grd_mtaltotllist.colRef("inputamt")) = suminputamt;
- grd_mtaltotllist.valueMatrix(grd_mtaltotllist.rows-1, grd_mtaltotllist.colRef("outputamt")) = sumoutputamt;
- grd_mtaltotllist.valueMatrix(grd_mtaltotllist.rows-1, grd_mtaltotllist.colRef("endmonamt")) = sumendmonamt;
-
-
- }
-
- ]]>
- </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:805px; height:13px; ">
- <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:243px; height:14px; ">자재재고총괄표</caption>
- </group>
- <group id="grp_biz" scroll="auto" style="left:0px; top:12px; width:805px; height:744px; ">
- <datagrid id="grd_mtaltotllist2" caption="품명^이월금액^입고금액^출고금액^재고금액^caption1^caption2^caption3^caption4" colsep="^" colwidth="166, 150, 150, 150, 150, 100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:80px; width:805px; height:660px; ">
- <col ref="acntflagnm" style="text-align:left; padding-left:10; "/>
- <col ref="trnsamt" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
- <col ref="inputamt" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
- <col ref="outputamt" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
- <col ref="endmonamt" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
- <col ref="inputmonth" visibility="hidden"/>
- <col ref="logurl" visibility="hidden"/>
- <col ref="instcd" visibility="hidden"/>
- <col ref="winacnt"/>
- <script type="javascript" ev:event="ondblclick">
- <![CDATA[
- model.property("acntflag") = grd_mtaltotllist
- ]]>
- </script>
- </datagrid>
- <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:804px; height:40px; "/>
- <select1 id="cmb_instcd" ref="/root/send/goodreq/instcd" class="combo_s_essential" appearance="minimal" style="left:95px; top:19px; width:120px; height:19px; ">
- <choices>
- <itemset nodeset="/root/init/instcd">
- <label ref="cdnm"/>
- <value ref="cdid"/>
- </itemset>
- </choices>
- </select1>
- <caption id="caption14" class="search_name" style="left:5px; top:19px; width:91px; height:17px; ">기관코드 :</caption>
- <line id="line14" class="line_4" style="x1:665px; y1:17px; x2:665px; y2:44px; "/>
- <button id="btn_search" class="btn1_letter2" navindex="7" style="left:675px; top:20px; width:56px; height:22px; text-align:left; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- grd_mtaltotllist2.visible = true;
- submit("TRRST06001");
- //
- fSetSumAmt();
- grd_mtaltotllist2.visible = false;
-
- ]]>
- </script>
- </button>
- <datagrid id="grd_mtaltotllist" nodeset="/root/main/mtaltotllist" caption="품명^이월금액^입고금액^출고금액^재고금액^수탁재고^가납재고^구매재고^caption1^caption2^caption3^caption4^caption5" colsep="^" colwidth="166, 150, 150, 150, 150, 100, 100, 100, 100, 100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:80px; width:805px; height:660px; ">
- <col ref="acntflagnm" style="text-align:left; "/>
- <col ref="trnsamt" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
- <col ref="inputamt" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
- <col ref="outputamt" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
- <col ref="endmonamt" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
- <col ref="endmonamt2" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
- <col ref="endmonamt3" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
- <col ref="endmonamt1" format="(-)#,###.###" roundmode="round" style="text-align:right; "/>
- <col ref="inputmonth" visibility="hidden"/>
- <col ref="logurl" visibility="hidden"/>
- <col ref="instcd" visibility="hidden"/>
- <col ref="winacnt" visibility="hidden"/>
- <col ref="acntflag" visibility="hidden"/>
- <script type="javascript" ev:event="ondblclick">
- <![CDATA[
- if(grd_mtaltotllist.valueMatrix(grd_mtaltotllist.row, grd_mtaltotllist.colRef("acntflag")) != "") {
- model.property("acntflag") = grd_mtaltotllist.valueMatrix(grd_mtaltotllist.row, grd_mtaltotllist.colRef("acntflag"))
- model.property("acntflagnm") = grd_mtaltotllist.valueMatrix(grd_mtaltotllist.row, grd_mtaltotllist.colRef("acntflagnm"))
- model.property("stkmonth") = model.getValue(ipt_inputmonth.attribute("ref"));
- model.property("instcd") = model.getValue(cmb_instcd.attribute("ref"));
- modal("SMRST06300");
- } else {
-
- messageBox("계정세부항목을 선택하여주세요.", "E");
- return;
- }
-
- ]]>
- </script>
- </datagrid>
- <caption id="caption5" class="tit_2" style="left:5px; top:60px; width:136px; height:14px; ">자재재고총괄표</caption>
- <line id="line1" class="line_1" style="x1:0px; y1:75px; x2:805px; y2:75px; "/>
- <caption id="caption1" class="search_name" style="left:230px; top:20px; width:91px; height:17px; ">입고년월 :</caption>
- <input id="ipt_inputmonth" ref="/root/send/goodreq/inputmonth" class="input_s_essential" inputtype="date" maxlength="6" format="yyyy-mm" style="left:318px; top:20px; width:75px; height:19px; "/>
- <button id="btn_print" class="btn1_letter2" style="left:735px; top:20px; width:56px; height:22px; ">
- <caption>출력</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- model.makeNode("/root/send/report/mtaltotllist");
-
- for(var i = grd_mtaltotllist.fixedRows; i < grd_mtaltotllist.rows; i++) {
- grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("inputmonth")) = model.getValue(ipt_inputmonth.attribute("ref"));
- grd_mtaltotllist.valueMatrix(i, grd_mtaltotllist.colRef("logurl")) = getImageURL("biglogo"+getUserInfo("dutplceinstcd"), "jpg");
- }
-
- copyNodesetType("/root/send/report/mtaltotllist", grd_mtaltotllist.nodeset);
-
- exeReportPreview("RPRST06001", "XMLSTR", "/root/send/report");
-
- ]]>
- </script>
- </button>
- <button id="button1" class="btn2_letter4" style="left:740px; top:55px; width:64px; height:19px; ">
- <caption>엑셀저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var fileName = window.fileDialog("save", ",", false, "자재재고총괄표", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
-
- if (fileName != "")
- {
- grd_mtaltotllist.saveExcel(fileName, "자재재고총괄표");
- }
- ]]>
- </script>
- </button>
- <select id="ckb_goodflagyn" ref="/root/send/goodreq/purcflag" overflow="visible" appearance="full" style="left:500px; top:56px; width:155px; height:15px; border-style:none; ">
- <choices>
- <item>
- <label>재고금액 수탁/가납 제외</label>
- <value>Y</value>
- </item>
- </choices>
- </select>
- </group>
- </xhtml:body>
- </xhtml:html>
|