123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419 |
- <?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: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>
- <rsthssstdifflist/>
- <rsthssstlist/>
- </main>
- <send>
- <instcd/>
- <goodflag/>
- <orginspdd/>
- <stocdeptcd/>
- <lrgcd/>
- <instcdnm/>
- <goodcd/>
- <rsthssstlist/>
- <orginspym/>
- <mngtcls/>
- </send>
- <init>
- </init>
- <temp>
- </temp>
- <hidden>
- <main/>
- </hidden>
- <cond/>
- <goodinfo>
- <goodcd/>
- <goodnm/>
- </goodinfo>
- </root>
- </instance>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- //화면 Control을 초기화한다
- fInitialize();
- ]]>
- </script>
- <submission id="TRRST01701" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/rsthssstdifflist"/>
- <submission id="TRRST00201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/rsthssstlist"/>
- <submission id="TXRST00201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/rsthssstlist" resultref="/root/temp"/>
- <submission id="TRRSD00192" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/cond/goodiolist" resultref="/root/hidden/main"/>
- </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/commonweb/js/dateHelper.js"/>
- <script type="javascript">
- <![CDATA[
-
- // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
- function fInitialize()
- {
-
- misfGridInit(grd_rsthssstdifflist);
- misfGridInit(grd_rsthssstlist);
- // [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH)
- misfComboComCdList("030M0003",cmb_mngtcls,"Y");
- rszfComboStockArthDeptcdList(cmb_stocdeptcd,getUserInfo("dutplceinstcd"),"PH" );
- misfMsterDetailSet(grd_rsthssstlist, null, "TRRST00201", "Y");
- model.setValue(opt_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));
- model.setValue(opt_instcdnm.attribute("ref") , getUserInfo("dutplceinstnm"));
- // [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH)
- model.setValue(opt_goodflag.attribute("ref"), "PH");
-
-
- var curdd = getCurrentDate();
-
- model.setValue(ipt_orginspdd.attribute("ref") ,curdd);
- model.setValue(ipt_orginspym.attribute("ref") ,curdd.substr(0,6) );
- // [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH)
- rszfGridComboLrgcdList("PH", cmb_lrgcd, "lrgcd","N");
- model.refresh();
- }
-
- function fCheckRetrieveData()
- {
- if(!isRequiredControls("opt_goodflag") )return false; // 물품구분
- if(!isRequiredControls("ipt_orginspdd") )return false; // 작업년월
- if(!isRequiredControls("cmb_stocdeptcd") )return false; // 부서코드
- //if(!isRequiredControls("cmb_lrgcd") )return false; // 대분류
- }
-
- ]]>
- </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="grp_biz" scroll="auto" style="left:0px; top:38; width:1195; height:744; ">
- <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1195px; height:61px; background-color:#fffbf2; border-color:#ffd799; "/>
- <line id="line1" class="line_1" style="x1:0px; y1:95px; x2:965px; y2:95px; "/>
- <datagrid id="grd_rsthssstdifflist" nodeset="/root/main/rsthssstdifflist" caption="약품코드^약품명칭^규격^단위^단가^재고량^재고금액^실사량^실사금액^차이수량^차이금액^기관코드^실사년월^부서^대분류" colsep="^" colwidth="78, 202, 98, 62, 51, 56, 72, 56, 74, 64, 78, 100, 100, 100, 100" dataheight="25" ellipsis="true" explorerbar="sortshow" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:100px; width:965px; height:634px; ">
- <col ref="goodcd" _key="true" style="left:161px; top:25px; width:115px; height:25px; text-align:left; "/>
- <col ref="goodnm" style="text-align:left; "/>
- <col ref="goodspec" style="text-align:left; "/>
- <col disabled="true" ref="deliveunit" style="text-align:center; "/>
- <col ref="goodunitcost" format="(-)#,###.#9" style="text-align:right; "/>
- <col ref="stocqty" format="(-)#,###.#9" style="text-align:right; "/>
- <col ref="stocamt" format="(-)#,###.#9" style="text-align:right; "/>
- <col ref="orginspqty" format="(-)#,###.#9" style="text-align:right; "/>
- <col ref="orginspamt" format="(-)#,###.#9" style="text-align:right; "/>
- <col ref="diffqty" format="(-)#,###.#9" style="text-align:right; "/>
- <col ref="diffamt" format="(-)#,###.#9" style="text-align:right; "/>
- <col visibility="hidden"/>
- <col visibility="hidden"/>
- <col visibility="hidden"/>
- <col visibility="hidden"/>
- <script type="javascript" ev:event="onrowchanged">
- <![CDATA[
-
- misfGridInit(grd_rsthssstlist);
- if (grd_rsthssstdifflist.rows <= grd_rsthssstdifflist.fixedRows) return;
- model.removeNodeset("/root/tmp/chkinfo/goodcd");
- model.makeValue("/root/tmp/chkinfo/goodcd",grd_rsthssstdifflist.valueMatrix(grd_rsthssstdifflist.row,grd_rsthssstdifflist.colRef("goodcd")));
-
- model.setValue("/root/send/goodcd",grd_rsthssstdifflist.valueMatrix(grd_rsthssstdifflist.row,grd_rsthssstdifflist.colRef("goodcd")) );
- submit("TRRST00201");
-
- grd_rsthssstdifflist.dispatch("onmouseup");
-
-
- ]]>
- </script>
- <script type="javascript" ev:event="onaftersort">
- <![CDATA[
- grd_rsthssstdifflist.gridToInstance();
- ]]>
- </script>
- </datagrid>
- <input id="ipt_orginspdd" ref="/root/send/orginspdd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:440px; top:18px; width:150px; height:19px; text-align:center; "/>
- <caption id="caption3" class="tit_2" style="left:5px; top:80px; width:183px; height:14px; ">실재고 전산재고 차이리스트</caption>
- <button id="btn_search" class="btn1_letter2" style="left:1125px; top:29px; width:56px; height:22px; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
-
-
- misfGridInit(grd_rsthssstdifflist);
- misfGridInit(grd_rsthssstlist);
-
- if(fCheckRetrieveData(false) == false)return;
- model.setValue("/root/send/goodcd",model.getValue("/root/goodinfo/goodcd"));
- submit("TRRST01701");
- if(model.getValue("/root/tmp/chkinfo/goodcd") ==""){
- grd_rsthssstdifflist.row = 1;
- }else{
-
- for(var i = 1; i <= grd_rsthssstdifflist.rows; i++) {
-
- if( grd_rsthssstdifflist.valueMatrix(i, grd_rsthssstdifflist.colRef("goodcd")) == model.getValue("/root/tmp/chkinfo/goodcd") ) {
- grd_rsthssstdifflist.row = i;
-
- break;
- }
- }
-
- btn_scroll.dispatch("DOMActivate");
- }
- grd_rsthssstdifflist.dispatch("onrowchanged");
-
-
- ]]>
- </script>
- </button>
- <line id="line13" class="line_4" style="x1:1110px; y1:16px; x2:1110px; y2:61px; "/>
- <caption id="cap_lrgcd" class="search_name" visibility="hidden" style="left:345px; top:75px; width:98px; height:17px; ">대 분 류 :</caption>
- <caption id="cap_instcd" class="search_name" style="left:15; top:19; width:86px; height:17px; ">기관코드 :</caption>
- <caption id="cap_orginspdd" class="search_name" style="left:345px; top:19px; width:101px; height:17px; ">실사 일자 :</caption>
- <caption id="cap_stocdeptcd" class="search_name" style="left:15px; top:45px; width:99px; height:17px; ">부 서 :</caption>
- <select1 id="cmb_stocdeptcd" ref="/root/send/stocdeptcd" class="combo_s_essential" appearance="minimal" style="left:101px; top:45px; width:150px; height:19px; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <select1 id="cmb_lrgcd" ref="/root/send/lrgcd" class="combo_s_essential" visibility="hidden" appearance="minimal" style="left:440px; top:75px; width:150px; height:19px; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <output id="opt_instcdnm" ref="/root/send/instcdnm" class="output_fix" style="left:100px; top:18px; width:150px; height:19px; text-align:center; "/>
- <output id="opt_instcd" ref="/root/send/instcd" class="output_fix" visibility="hidden" style="left:300px; top:40px; width:20px; height:19px; "/>
- <caption id="caption1" class="tit_2" style="left:970px; top:80px; width:183px; height:13px; ">실사내역</caption>
- <line id="line2" class="line_1" style="x1:970px; y1:95px; x2:1190px; y2:95px; "/>
- <datagrid id="grd_rsthssstlist" nodeset="/root/main/rsthssstlist" caption="실사자^실사량^기관코드^재고부서코드^실사년월^물품코드^입고단가^물품구분^대분류코드^재고수량^재고금액^재고조정처리여부^실사자ID^실사일자" colsep="^" colwidth="72, 60, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 18, 77" ellipsis="true" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" style="left:970px; top:100px; width:221px; height:635px; ">
- <col ref="orginspidnm" style="text-align:center; "/>
- <col ref="orginspqty" type="input" format="#,###" style="text-align:right; "/>
- <col ref="instcd" visibility="hidden"/>
- <col ref="stocdeptcd" visibility="hidden"/>
- <col ref="orginspym" visibility="hidden"/>
- <col ref="goodcd" visibility="hidden"/>
- <col ref="stocseqno" visibility="hidden"/>
- <col ref="goodflag" visibility="hidden"/>
- <col ref="lrgcd" visibility="hidden"/>
- <col ref="stocqty" visibility="hidden"/>
- <col ref="stocamt" visibility="hidden"/>
- <col ref="stocadjttretyn" visibility="hidden"/>
- <col ref="orginspid" visibility="hidden"/>
- <col ref="orginspdd" format="yyyy-mm-dd"/>
- </datagrid>
- <button id="btn_excel_all" class="btn2_letter4" style="left:900px; top:75px; 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_rsthssstdifflist.saveExcel(fileName, "실재고전산재고 차이리스트", true, true, "");
- }
- ]]>
- </script>
- </button>
- <output id="opt_goodflag" ref="/root/send/goodflag" visibility="hidden" style="left:280px; top:15px; width:50px; height:19px; "/>
- <button id="btn_save" class="btn2_letter2" style="left:1139px; top:75px; width:42px; height:19px; ">
- <caption>저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
-
- for(var fRow = grd_rsthssstlist.fixedRows; fRow < grd_rsthssstlist.rows; fRow++)
- {
- if(grd_rsthssstlist.valueMatrix(fRow, grd_rsthssstlist.colRef("orginspqty")) == "" )
- {
- messageBox("실사량은","I003");
- return;
- }
- }
- var data = getGridUpdateData(grd_rsthssstlist);
-
- if(data == "")
- {
- messageBox("저장할 내용이","I004");
- return;
- }
- //alert(data);
- misfSave("TXRST00201");
- btn_search.dispatch("DOMActivate");
- model.removeNodeset("/root/tmp/chkinfo/goodcd");
-
- ]]>
- </script>
- </button>
- <button id="btn_searchgoodcd" class="icon_search" style="left:825px; top:45px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
-
- model.makeValue("/root/cond/goodiolist/instcd" ,model.getValue("/root/send/instcd"));
- model.makeValue("/root/cond/goodiolist/goodflag","PH");
- model.makeValue("/root/cond/goodiolist/goodcd" ,model.getValue("/root/goodinfo/goodcd"));
-
- if (submit("TRRSD00192") == true) {
- var nodecnts = getNodesetCount("/root/hidden/main/goodlist");
- if (nodecnts >= "2") {
- group2.visible = true;
- } else if (nodecnts == "1") {
-
- var goodcd = model.getValue("/root/hidden/main/goodlist/goodcd");
- var goodnm = model.getValue("/root/hidden/main/goodlist/goodnm");
-
- model.setValue("/root/goodinfo/goodcd" , goodcd)
- model.setValue("/root/goodinfo/goodnm" , goodnm)
- } else {
- messageBox("검색된 코드가 없습니다.", "I");
- }
-
- }
- model.refresh();
- ]]>
- </script>
- </button>
- <input id="ipt_goodnm" ref="/root/goodinfo/goodnm" class="input_fix" appearance="input" style="left:844px; top:44px; width:215px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- if(ipt_goodnm.value.length == 0)
- {
- ipt_goodcd.value = "";
- }
- else {
- model.setValue("/root/goodinfo/goodcd", "")
- btn_searchgoodcd.dispatch("DOMActivate");
- }
- model.refresh();
- ]]>
- </script>
- <script type="javascript" ev:event="onkeydown">
- <![CDATA[
- if (event.keyCode == 13)
- {
- ipt_goodnm.value = ipt_goodnm.currentText;
- ipt_goodnm.refresh();
- ipt_goodnm.dispatch("xforms-value-changed");
- }
-
- ]]>
- </script>
- </input>
- <input id="ipt_goodcd" ref="/root/goodinfo/goodcd" class="input_s_essential" _chartype="upper" style="left:710px; top:44px; width:111px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
-
- if(ipt_goodcd.value.length == 0)
- {
- ipt_goodnm.value = "";
- }
- else {
- model.setValue("/root/goodinfo/goodnm" , "")
- btn_searchgoodcd.dispatch("DOMActivate");
- }
- model.refresh();
- ]]>
- </script>
- <script type="javascript" ev:event="onkeydown">
- <![CDATA[
- if (event.keyCode == 13)
- {
- ipt_goodcd.value = ipt_goodcd.currentText;
- ipt_goodcd.refresh();
- ipt_goodcd.dispatch("xforms-value-changed");
- }
-
- ]]>
- </script>
- </input>
- <caption id="caption2" class="search_name" style="left:625px; top:45px; width:95px; height:17px; ">약품코드 :</caption>
- <group id="group2" visibility="hidden" style="left:640px; top:65px; width:415px; height:165px; ">
- <datagrid id="grd_goodlist" nodeset="/root/hidden/main/goodlist" visibility="visible" caption="약품코드^약품명^기관코드^물품구분^작업년월^부서코드^대분류코드^재고조정처리여부" colsep="^" colwidth="102, 270, 0, 0" dataheight="25" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:0px; top:25px; width:410px; height:139px; ">
- <col imemode="alpha" ref="goodcd" type="output" _chartype="upper" _key="true" style="left:161px; top:25px; width:115px; height:25px; text-align:left; "/>
- <col ref="goodnm" type="output" style="text-align:left; "/>
- <col ref="instcd" visibility="hidden" _key="true"/>
- <col ref="goodflag" visibility="hidden" _key="true"/>
- <script type="javascript" ev:event="ondblclick">
- <![CDATA[
- if (isDataCell() == true) {
-
- var goodcd = model.getValue("/root/hidden/main/goodlist[" + grd_goodlist.row + "]/goodcd");
- var goodnm = model.getValue("/root/hidden/main/goodlist[" + grd_goodlist.row + "]/goodnm");
-
- model.setValue("/root/goodinfo/goodcd" , goodcd)
- model.setValue("/root/goodinfo//goodnm" , goodnm)
-
- group2.visible = false;
- }
- ipt_goodcd.refresh();
- ipt_goodnm.refresh();
- ]]>
- </script>
- </datagrid>
- <button id="button5" class="btn2_letter3" style="left:340px; top:4px; width:53px; height:19px; ">
- <caption>숨기기</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- group2.visible = false
- ]]>
- </script>
- </button>
- </group>
- <button id="btn_scroll" class="btn1_letter5" visibility="hidden" style="left:235px; top:73px; width:92px; height:22px; ">
- <caption>스크롤 버튼</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var iRow = grd_rsthssstdifflist.row - grd_rsthssstdifflist.fixedRows + 1;
- model.setFocus("grd_rsthssstdifflist");
- grd_rsthssstdifflist.row= iRow;
- ]]>
- </script>
- </button>
- <input id="ipt_orginspym" ref="/root/send/orginspym" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:710px; top:19px; width:111px; height:19px; text-align:center; "/>
- <caption id="cap_orginspym" class="search_name" style="left:625px; top:20px; width:102px; height:17px; ">재고년월 :</caption>
- <select1 id="cmb_mngtcls" ref="/root/send/mngtcls" class="combo_s_essential" appearance="minimal" style="left:440px; top:45px; width:150px; height:19px; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <caption id="caption4" class="search_name" style="left:345px; top:45px; width:88px; height:17px; ">관리분류 :</caption>
- </group>
- <group id="group1" style="left:0px; top:12; width:1195px; height:27px; ">
- <button id="btn_print" class="btn6_letter5" disabled="false" visibility="hidden" style="left:0px; top:3px; width:92px; height:22px; ">
- <caption>리스트출력</caption>
- </button>
- <button id="btn_init" class="btn4_letter3" style="left:1127px; top:3px; width:68px; height:22px; ">
- <caption>초기화</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- fInitialize();
- ]]>
- </script>
- </button>
- <line id="line17" class="line_6" style="x1:0px; y1:25px; x2:1195px; y2:25px; "/>
- </group>
- </xhtml:body>
- </xhtml:html>
|