123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570 |
- <?xml version="1.0" encoding="EUC-KR"?>
- <?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/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>
- <list>
- <goodstokinfo>
- <goodstoklist/>
- </goodstokinfo>
- <goodstokfrminfo>
- <goodstokfrmlist/>
- </goodstokfrminfo>
- <goodstokbatsaveinfo>
- <goodstokbatsavelist/>
- </goodstokbatsaveinfo>
- <goodstokchkcertinfo>
- <goodstokchkcertlist/>
- <goodstokchkpsn>
- <chkmmfrom/>
- <chkmmto/>
- </goodstokchkpsn>
- </goodstokchkcertinfo>
- </list>
- </main>
- <send>
- <search>
- <instcd/>
- <goodflag>Y</goodflag>
- <lrgcd/>
- <mdlcd/>
- <goodcd/>
- <goodnm/>
- <stocmngtflag/>
- <stocdtfrom/>
- <stocdtto/>
- <stocmmfrom/>
- <stocmmto/>
- <pridcond>D</pridcond>
- <chkmmfrom/>
- <chkmmto/>
- <suppcustcd/>
- <suppcustnm/>
- </search>
- <goodstoklist/>
- <goodstokbatsavelist/>
- </send>
- <init>
- </init>
- <temp>
- </temp>
- </root>
- </instance>
- <submission id="TRRSG07501" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search" resultref="/root/main/list/goodstokinfo"/>
- <submission id="TRRSG07502" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search" resultref="/root/main/list/goodstokchkcertinfo"/>
- <submission id="TRRSG07511" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search" resultref="/root/main/list/goodstokfrminfo"/>
- <submission id="TXRSG07501" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/goodstoklist" resultref="/root/temp"/>
- <submission id="TXRSG07502" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/search" resultref="/root/temp"/>
- <submission id="TXRSG07521" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/goodstokbatsavelist" resultref="/root/temp"/>
- </model>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- //화면 Control을 초기화한다
- fInitialize();
- ]]>
- </script>
- <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/commonweb/js/dateHelper.js"/>
- <script type="javascript">
- <![CDATA[
- function fInitialize()
- {
- var curdate = getCurrentDate();
- var cvtdate = curdate.toDate("YYYYMMDD");
- cap_title.attribute("text") = cmb_goodflag.label +" 재고 관리";
-
- misfComboComCdListMulti("R0069,Z0007","cmb_stocmngtflag,cmb_instcd");
- model.setValue("/root/send/search/instcd", getUserInfo("dutplceinstcd")); // 기관 설정
- rszfLMSComboList(model.getValue(cmb_goodflag.attribute("ref")), "", "", "cmb_lrgcd", "", "L", "", "Y");
- addComboItem( "cmb_lrgcd" , "전체", "", "above");
- addComboItem( "cmb_stocmngtflag" , "전체", "", "above");
- grd_goodstok.colAttribute(3, "format") = "yyyy/mm/dd";
- fSearchDateSetting(rdo_pridcond.value);
- model.setValue(ipt_stocdtfrom.attribute("ref") ,cvtdate.getAddDate(-10,"D").getDateFormat("YYYYMMDD"));
- model.setValue(ipt_stocdtto.attribute("ref") , curdate);
- model.setValue(ipt_stocmmfrom.attribute("ref") ,cvtdate.getAddDate(-31,"D").getDateFormat("YYYYMM"));
- model.setValue(ipt_stocmmto.attribute("ref") , curdate);
- model.setValue(ipt_chkmmfrom.attribute("ref") ,cvtdate.getDateFormat("YYYYMM"));
- model.setValue(ipt_chkmmto.attribute("ref") , cvtdate.getDateFormat("YYYYMM"));
- model.removeNodeset("/root/main/list/goodstokinfo/goodstoklist");
- model.removeNodeset("/root/main/list/goodstokfrminfo/goodstokfrmlist");
- model.removeNodeset("/root/main/list/goodstokbatsaveinfo/goodstokbatsavelist");
- fSearch(0);
- model.refresh();
-
- }
- function fSearchDateSetting(val)
- {
- if (val == 'M') { // 재고월
-
- ipt_stocdtfrom.visible = false;
- ipt_stocdtto.visible = false;
- cap_stocdd.visible = false;
-
- ipt_stocmmfrom.visible = true;
- ipt_stocmmto.visible = true;
- cap_stocmm.visible = true;
-
- } else if (val == 'D') { // 재고일자
-
- ipt_stocdtfrom.visible = true;
- ipt_stocdtto.visible = true;
- cap_stocdd.visible = true;
-
- ipt_stocmmfrom.visible = false;
- ipt_stocmmto.visible = false;
- cap_stocmm.visible = false;
-
- }
- }
- function fSearch(idx)
- {
- if (idx == 0) {
- model.removeNodeset("/root/main/list/goodstokinfo/goodstoklist");
- submit("TRRSG07501");
- } else if (idx == 1) {
- model.removeNodeset("/root/main/list/goodstokfrminfo/goodstokfrmlist");
- submit("TRRSG07511");
- } else if (idx == 2) {
- model.removeNodeset("/root/main/list/goodstokbatsaveinfo/goodstokbatsavelist");
- }
- }
- function fLoadExcel()
- {
- var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
- grd_goodstokbatsave.loadExcel(fileName);
- grd_goodstokbatsave.deleteRow(grd_goodstokbatsave.fixedRows);
- grd_goodstokbatsave.rebuild();
-
- for(var fRow = grd_goodstokbatsave.fixedRows; fRow < grd_goodstokbatsave.rows; fRow++)
- {
- grd_goodstokbatsave.addStatus(fRow, "update");
- }
-
- model.refresh();
- }
- ]]>
- </script>
- </xhtml:head>
- <xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
- <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
- <caption id="cap_title" class="tit_1" style="left:0px; top:0px; width:230px; height:14px; ">수탁 물품 재고 관리</caption>
- <caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
- </group>
- <group id="group3" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
- <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:63px; background-color:#fffbf2; border-color:#ffd799; "/>
- <select1 id="cmb_lrgcd" ref="/root/send/search/lrgcd" appearance="minimal" style="left:414px; top:36px; width:121px; height:19px; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- rszfLMSComboList(model.getValue(cmb_goodflag.attribute("ref")), cmb_lrgcd.value, "", "cmb_mdlcd", "", "M", "", "Y");
- cmb_mdlcd.dispatch("xforms-value-changed");
- addComboItem( "cmb_mdlcd", "전체", "", "above");
- model.refresh();
- ]]>
- </script>
- </select1>
- <select1 id="cmb_stocmngtflag" ref="/root/send/search/stocmngtflag" visibility="hidden" appearance="minimal" style="left:896px; top:36px; width:209px; height:19px; ">
- <choices>
- <itemset nodeset="/root/init/stocmngtflag">
- <label ref="cdnm"/>
- <value ref="cdid"/>
- </itemset>
- </choices>
- </select1>
- <line id="line30" class="line_4" style="x1:1119px; y1:4px; x2:1119px; y2:58px; "/>
- <caption id="cap_goodcd" class="search_name" style="left:545px; top:10px; width:86px; height:17px; ">물품코드 :</caption>
- <input id="ipt_goodnm" ref="/root/send/search/goodnm" class="output_search" style="left:743px; top:10px; width:130px; height:19px; "/>
- <select1 id="cmb_instcd" ref="/root/send/search/instcd" class="combo_default" appearance="minimal" style="left:104px; top:10px; width:206px; height:19px; ">
- <choices>
- <itemset nodeset="/root/main/init">
- <label ref="cnstnm"/>
- <value ref="cnstcd"/>
- </itemset>
- </choices>
- </select1>
- <select1 id="cmb_mdlcd" ref="/root/send/search/mdlcd" appearance="minimal" style="left:639px; top:36px; width:126px; height:19px; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <input id="ipt_goodcd" ref="/root/send/search/goodcd" class="input_search" maxlength="10" appearance="input" style="left:639px; top:10px; width:81px; height:19px; "/>
- <button id="btn_goodcd" class="icon_search" style="left:724px; top:10px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- rszfOpenPopUpListByWndName(ipt_goodcd,"","goodcd,goodnm","SPRSD00210","instcd,goodflag","cmb_instcd,cmb_goodflag");
- model.refresh();
- ]]>
- </script>
- </button>
- <input id="ipt_stocdtfrom" ref="/root/send/search/stocdtfrom" class="input_default" inputtype="date" format="yyyy-mm-dd" appearance="input" style="left:104px; top:36px; width:91px; height:19px; "/>
- <caption id="cap_goodflag" class="search_name" style="left:320px; top:10px; width:86px; height:17px; ">물품구분 :</caption>
- <select1 id="cmb_goodflag" ref="/root/send/search/goodflag" class="combo_default" appearance="minimal" style="left:414px; top:10px; width:121px; height:19px; ">
- <choices>
- <item>
- <label>수리부품</label>
- <value>B</value>
- </item>
- <item>
- <label>의료비품</label>
- <value>U</value>
- </item>
- <item>
- <label>의료소모품</label>
- <value>Y</value>
- </item>
- <item>
- <label>공급실물품</label>
- <value>T</value>
- </item>
- <item>
- <label>일반소모품</label>
- <value>Z</value>
- </item>
- </choices>
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- cap_title.attribute("text") = cmb_goodflag.label +" 재고 관리";
- rszfLMSComboList(model.getValue(cmb_goodflag.attribute("ref")), "", "", "cmb_lrgcd", "", "L", "", "Y");
- addComboItem( "cmb_lrgcd", "전체", "", "above");
- cmb_mdlcd.value='';
-
- model.refresh();
- ]]>
- </script>
- </select1>
- <caption id="cap_instcd" class="search_name" style="left:10px; top:10px; width:86px; height:17px; ">기관코드 :</caption>
- <caption id="caption7" class="search_name" style="left:320px; top:36px; width:88px; height:17px; ">대 분 류 :</caption>
- <caption id="caption16" class="search_name" visibility="hidden" style="left:775px; top:36px; width:112px; height:17px; ">재고관리기준 :</caption>
- <caption id="caption8" class="search_name" style="left:543px; top:36px; width:88px; height:17px; ">중 분 류 :</caption>
- <caption id="cap_stocdd" class="search_name" style="left:10px; top:36px; width:86px; height:17px; ">재고기간 :</caption>
- <caption id="caption29" style="left:200px; top:37px; width:15px; height:17px; ">~</caption>
- <button id="btn_search" class="btn1_letter2" style="left:1129px; top:22px; width:56px; height:22px; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- if (swh_select.selectedIndex == 0) {
- fSearch(0);
- } else if (swh_select.selectedIndex == 1) {
- fSearch(1);
- } else if (swh_select.selectedIndex == 1) {
- fSearch(2);
- }
- ]]>
- </script>
- </button>
- <input id="ipt_stocdtto" ref="/root/send/search/stocdtto" class="input_default" inputtype="date" format="yyyy-mm-dd" appearance="input" style="left:220px; top:36px; width:91px; height:19px; "/>
- <input id="ipt_stocmmfrom" ref="/root/send/search/stocmmfrom" class="input_default" inputtype="date" format="yyyy-mm" appearance="input" style="left:104px; top:36px; width:91px; height:19px; "/>
- <input id="ipt_stocmmto" ref="/root/send/search/stocmmto" class="input_default" inputtype="date" format="yyyy-mm" appearance="input" style="left:220px; top:36px; width:91px; height:19px; "/>
- <caption id="cap_stocmm" class="search_name" style="left:10px; top:36px; width:86px; height:17px; ">재고 월 :</caption>
- <caption id="caption1" class="search_name" style="left:882px; top:10px; width:112px; height:17px; ">기간 조건 :</caption>
- <select1 id="rdo_pridcond" ref="/root/send/search/pridcond" appearance="full" cols="2" overflow="visible" style="left:976px; top:11px; width:135px; height:20px; border-style:solid; ">
- <choices>
- <item>
- <label>재고일자</label>
- <value>D</value>
- </item>
- <item>
- <label>재고월</label>
- <value>M</value>
- </item>
- </choices>
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- if (rdo_pridcond.value == "M"){
- grd_goodstok.colAttribute(3, "format") = "yyyy/mm";
- grd_goodstok.caption = "기관코드^물품구분^재고월^물품코드^물품코드^물품명^EDICD^물품 규격^모델^보조거래처코드^보조 거래처명^주거래처코드^주 거래처명^입고량^출고량^실재고량";
- }else{
- grd_goodstok.colAttribute(3, "format") = "yyyy/mm/dd";
- grd_goodstok.caption = "기관코드^물품구분^재고일자^물품코드^물품코드^물품명^EDICD^물품 규격^모델^보조거래처코드^보조 거래처명^주거래처코드^주 거래처명^입고량^출고량^실재고량";
- }
- fSearchDateSetting(rdo_pridcond.value);
- model.refresh();
- ]]>
- </script>
- </select1>
- <button id="btn_goodstokfrm" class="btn_sw" group="tab" style="left:143px; top:87px; width:125px; height:22px; ">
- <caption>재고 Upload 양식</caption>
- <toggle case="cse_goodstokfrm" ev:event="onclick"/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- fSearch(1);
- ]]>
- </script>
- </button>
- <button id="btn_goodstok" class="btn_sw" group="tab" selected="true" style="left:0px; top:87px; width:144px; height:22px; ">
- <caption>재고 조회</caption>
- <toggle case="cse_goodstok" ev:event="onclick"/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- fSearch(0);
- ]]>
- </script>
- </button>
- <switch id="swh_select" style="left:0px; top:110px; width:1190px; height:595px; ">
- <case id="cse_goodstok">
- <line id="line1" class="line_1" style="x1:0px; y1:34px; x2:1185px; y2:34px; "/>
- <caption id="caption21" class="tit_2" style="left:0px; top:17px; width:143px; height:14px; ">재고 조회</caption>
- <datagrid id="grd_goodstok" nodeset="/root/main/list/goodstokinfo/goodstoklist" caption="기관코드^물품구분^재고일자^물품코드^물품코드^물품명^EDICD^물품 규격^모델^보조거래처코드^보조 거래처명^주거래처코드^주 거래처명^입고량^출고량^실재고량" colsep="^" colwidth="11, 13, 80, 90, 25, 121, 99, 115, 111, 18, 119, 18, 116, 66, 67, 73" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="24" rowsep="|" style="left:0px; top:40px; width:1185px; height:550px; font-weight:normal; text-align:center; ">
- <col ref="instcd" visibility="hidden" style="text-align:center; "/>
- <col ref="goodflag" visibility="hidden" style="text-align:center; "/>
- <col ref="stocdd" format="yyyy/mm" style="text-align:center; "/>
- <col ref="goodcd" style="text-align:center; "/>
- <col ref="allsizespecid" style="text-align:center; "/>
- <col ref="goodnm" style="text-align:left; padding-left:10; "/>
- <col ref="edicd" style="text-align:left; padding-left:10; "/>
- <col ref="goodspec" style="text-align:left; padding-left:10; "/>
- <col ref="goodmodel" style="text-align:left; padding-left:10; "/>
- <col ref="suppcustcd" visibility="hidden" style="text-align:left; "/>
- <col ref="suppcustnm" style="text-align:left; padding-left:10; "/>
- <col ref="maincustlastsuplplce" visibility="hidden" style="text-align:left; "/>
- <col ref="maincustlastsuplplcenm" style="text-align:left; padding-left:10; "/>
- <col ref="winqty" format="#,###" style="text-align:right; "/>
- <col ref="delivedeptqty" format="#,###" style="text-align:right; "/>
- <col ref="stocqty" format="#,###" style="text-align:right; "/>
- <script type="javascript" ev:event="onaftersort">
- <![CDATA[
- grd_goodstok.gridToInstance();
- ]]>
- </script>
- </datagrid>
- <button id="btn_print" class="btn2_letter6" style="left:990px; top:10px; width:86px; height:19px; ">
- <caption>검수증 출력</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- submit("TRRSG07502");
- model.makeValue("/root/main/list/goodstokchkcertinfo/goodstokchkpsn/chkmmfrom", model.getValue(ipt_chkmmfrom.attribute("ref")));
- model.makeValue("/root/main/list/goodstokchkcertinfo/goodstokchkpsn/chkmmto" , model.getValue(ipt_chkmmto.attribute("ref")));
- model.refresh();
- exeReportPreview("RPRSG07501", "XMLSTR");
- ]]>
- </script>
- </button>
- <input id="ipt_chkmmfrom" ref="/root/send/search/chkmmfrom" class="input_default" inputtype="date" format="yyyy-mm" appearance="input" style="left:767px; top:9px; width:91px; height:19px; "/>
- <input id="ipt_chkmmto" ref="/root/send/search/chkmmto" class="input_default" inputtype="date" format="yyyy-mm" appearance="input" style="left:883px; top:9px; width:91px; height:19px; "/>
- <caption id="caption9" style="left:863px; top:13px; width:15px; height:17px; ">~</caption>
- <caption id="caption11" style="left:718px; top:7px; width:74px; height:23px; vertical-align:middle; ">검수월 :</caption>
- <button id="btn_suppcustcd" class="icon_search" style="left:516px; top:12px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- rszfOpenPopUpListByWndName(ipt_suppcustcd,"","suppcustcd,suppcustnm","SPRSD00220","instcd","cmb_instcd");
- model.refresh();
- ]]>
- </script>
- </button>
- <caption id="caption31" style="left:356px; top:11px; width:79px; height:17px; ">보조거래처 :</caption>
- <input id="ipt_suppcustnm" ref="/root/send/search/suppcustnm" class="input_essential" style="left:535px; top:10px; width:173px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- if(ipt_suppcustnm.value != "")
- {
- rszfValidationCheck("TRRSD00221", "reqcustomlist", "instcd,refcond,retrnm",
- model.getValue(cmb_instcd.attribute("ref")) +",custnm," + model.getValue(ipt_suppcustnm.attribute("ref")),
- "","suppcustcd,suppcustnm" ,ipt_suppcustcd,"SPRSD00220","instcd","cmb_instcd");
- }else{
- ipt_suppcustnm.value = "";
- ipt_suppcustcd.value = "";
- }
- model.refresh();
- ]]>
- </script>
- </input>
- <input id="ipt_suppcustcd" ref="/root/send/search/suppcustcd" class="input_essential" style="left:429px; top:10px; width:84px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- if ( model.getValue(ipt_suppcustcd.attribute("ref")).length == 0 ) model.setValue(ipt_suppcustnm.attribute("ref"),"");
- else rszfValidationCheck("TRRSD00221", "reqcustomlist", "instcd,refcond,retrnm", model.getValue(cmb_instcd.attribute("ref")) +",," + model.getValue(ipt_suppcustcd.attribute("ref")),"","suppcustcd,suppcustnm" ,ipt_suppcustcd,"SPRSD00220","instcd","cmb_instcd");
- model.refresh();
- ]]>
- </script>
- </input>
- <button id="btn_stocbrngfwrd" class="btn2_letter7" style="left:1082px; top:10px; width:97px; height:19px; ">
- <caption>재고 전월 이월</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- if (submit("TXRSG07502")){
- btn_search.dispatch("DOMActivate");
- }
- ]]>
- </script>
- </button>
- </case>
- <case id="cse_goodstokfrm">
- <caption id="caption2" class="tit_2" style="left:0px; top:17px; width:143px; height:14px; ">재고 Upload 양식</caption>
- <line id="line2" class="line_1" style="x1:0px; y1:34px; x2:1185px; y2:34px; "/>
- <button id="btn_frmdown" class="btn2_letter5" style="left:1100px; top:10px; width:75px; height:19px; ">
- <caption>양식 받기</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
-
- if (fileName != "") {
- grd_goodstokfrm.saveExcel(fileName, "sheetname:sheet1;colhiddenextend:true;rowhiddenextend:false;exportfalsecols:0,0;col_1:value;");
- }
- ]]>
- </script>
- </button>
- <datagrid id="grd_goodstokfrm" nodeset="/root/main/list/goodstokfrminfo/goodstokfrmlist" caption="기관코드^물품구분^재고일자^물품코드^물품코드^물품명^EDICD^물품 규격^모델^보조 거래처명^주 거래처명^단가^안전 재고량^적정 재고량^실재고량" colsep="^" colwidth="62, 63, 77, 90, 25, 121, 99, 115, 111, 119, 116, 88, 74, 77, 61" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="24" rowsep="|" style="left:0px; top:40px; width:1185px; height:550px; font-weight:normal; text-align:center; ">
- <col ref="instcd" visibility="visible" style="text-align:center; "/>
- <col ref="goodflag" visibility="visible" style="text-align:center; "/>
- <col ref="stocdd" format="yyyy/mm/dd" style="text-align:center; "/>
- <col ref="goodcd" style="text-align:center; "/>
- <col ref="allsizespecid" style="text-align:center; "/>
- <col ref="goodnm" style="text-align:left; padding-left:10; "/>
- <col ref="edicd" style="text-align:left; padding-left:10; "/>
- <col ref="goodspec" style="text-align:left; padding-left:10; "/>
- <col ref="goodmodel" style="text-align:left; padding-left:10; "/>
- <col ref="suppcustnm" style="text-align:left; padding-left:10; "/>
- <col ref="maincustlastsuplplcenm" style="text-align:left; padding-left:10; "/>
- <col ref="goodunitcost" format="#,###" style="text-align:right; "/>
- <col ref="safestocqty" format="#,###" style="text-align:right; "/>
- <col ref="prprtystocqty" format="#,###" style="text-align:right; "/>
- <col ref="stocqty" format="#,###" style="text-align:right; "/>
- <script type="javascript" ev:event="onaftersort">
- <![CDATA[
- grd_goodstokfrm.gridToInstance();
- ]]>
- </script>
- </datagrid>
- </case>
- <case id="cse_goodstokbatsave">
- <datagrid id="grd_goodstokbatsave" nodeset="/root/main/list/goodstokbatsaveinfo/goodstokbatsavelist" caption="기관코드^물품구분^재고일자^물품코드^물품코드^물품명^EDICD^물품 규격^모델^보조 거래처명^주 거래처명^단가^안전 재고량^적정 재고량^실재고량" colsep="^" colwidth="62, 63, 77, 90, 25, 121, 99, 115, 111, 119, 116, 88, 74, 77, 61" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="24" rowsep="|" style="left:0px; top:40px; width:1185px; height:550px; font-weight:normal; text-align:center; ">
- <col ref="instcd" visibility="visible" style="text-align:center; "/>
- <col ref="goodflag" visibility="visible" style="text-align:center; "/>
- <col ref="stocdd" format="yyyy/mm/dd" style="text-align:center; "/>
- <col ref="goodcd" style="text-align:center; "/>
- <col ref="allsizespecid" style="text-align:center; "/>
- <col ref="goodnm" style="text-align:left; padding-left:10; "/>
- <col ref="edicd" style="text-align:left; padding-left:10; "/>
- <col ref="goodspec" style="text-align:left; padding-left:10; "/>
- <col ref="goodmodel" style="text-align:left; padding-left:10; "/>
- <col ref="suppcustnm" style="text-align:left; padding-left:10; "/>
- <col ref="maincustlastsuplplcenm" style="text-align:left; padding-left:10; "/>
- <col ref="goodunitcost" format="#,###" style="text-align:right; "/>
- <col ref="safestocqty" format="#,###" style="text-align:right; "/>
- <col ref="prprtystocqty" format="#,###" style="text-align:right; "/>
- <col ref="stocqty" format="#,###" style="text-align:right; "/>
- <script type="javascript" ev:event="onaftersort">
- <![CDATA[
- grd_goodstokbatsave.gridToInstance();
- ]]>
- </script>
- </datagrid>
- <caption id="caption3" class="tit_2" style="left:0px; top:17px; width:143px; height:15px; ">재고 일괄 저장</caption>
- <line id="line3" class="line_1" style="x1:0px; y1:34px; x2:1185px; y2:34px; "/>
- <button id="btn_upload" class="btn2_letter6" style="left:1015px; top:10px; width:86px; height:19px; ">
- <caption>엑셀 Upload</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- misfGridInit(grd_goodstokbatsave);
- fLoadExcel();
-
- for (var i = grd_goodstokbatsave.fixedRows ; i < grd_goodstokbatsave.rows ; i++){
- grd_goodstokbatsave.rowStatus(i) = "3";
- }
- ]]>
- </script>
- </button>
- <button id="btn_excelsave" class="btn2_letter5" style="left:1105px; top:10px; width:42px; height:19px; ">
- <caption>엑셀 저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
-
- var retMes = messageBox("저장 하시겠습니까?", "Q999");
- if ( retMes != 6) {
- return;
- }
-
- var updtdata = getGridUpdateData(grd_goodstokbatsave);
-
- if (updtdata == "")
- {
- messageBox("변경된 데이터가","I004");
- return;
- }
- model.setValue("/root/send/goodstokbatsavelist", updtdata);
- submit("TXRSG07521");
- misfGridInit(grd_goodstokbatsave);
- messageBox("엑셀 저장이 ", "I002");
- ]]>
- </script>
- </button>
- </case>
- </switch>
- <button id="btn_batsave" class="btn_sw" group="tab" style="left:267px; top:87px; width:125px; height:22px; ">
- <caption>재고 일괄 저장</caption>
- <toggle case="cse_goodstokbatsave" ev:event="onclick"/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- fSearch(2);
- ]]>
- </script>
- </button>
- </group>
- <group id="group4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
- <line id="line7" class="line_6" style="x1:0px; y1:25; x2:1194px; y2:25; "/>
- <button id="btn_init" class="btn4_letter3" style="left:1126; top:3; width:68px; height:22px; ">
- <caption>초기화</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- fInitialize();
- ]]>
- </script>
- </button>
- </group>
- </xhtml:body>
- </xhtml:html>
|