123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604 |
- <?xml version="1.0" encoding="EUC-KR"?>
- <!--
- * 제 목 : SMRSC08300_상한가 변경 물품내역비교
- * 설 명 : 보건복지부에서 고시된 EDI코드의 상한가 변경 품목 비교
- * 설 계 자 : 김금련
- * 작 성 자 : 김금련
- * 작 성 일 : 2014.07.22
- * 수정이력 : 2014.07.22
- * 기 타 :
- -->
- <?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>
- <upperlimitlst>
- <upperlimitinfo/>
- </upperlimitlst>
- <cmprlst>
- <cmprinfo/>
- </cmprlst>
- </main>
- <send>
- <srchgoodcd/>
- <srchwinacnt/>
- <srchwinacntnm/>
- <srchbasedd/>
- <srchmaincustlastsuplplce/>
- <srchmaincustlastsuplplcenm/>
- <ugoodcd/>
- <uwinacnt/>
- <uwinacntnm/>
- <ubasedd/>
- <umaincustlastsuplplce/>
- <umaincustlastsuplplcenm/>
- <sdata/>
- <entrregno/>
- <refcond/>
- <retrnm/>
- <custstat/>
- <list/>
- <instcd/>
- <ufromdd/>
- <utodd/>
- <srchfromdd/>
- <srchtodd/>
- <selectyn/>
- <save>
- <upperlimitinfo/>
- <keumcomparelst/>
- <exelist/>
- </save>
- <purccnsttndd/>
- <purccnsttnno/>
- <purccondd/>
- <purcconno/>
- <phflag/>
- </send>
- <init>
- <combobscdlst/>
- </init>
- <hidden/>
- <temp>
- <item/>
- </temp>
- <rexprnt>
- <benflist>
- <srchfromdd/>
- <srchtodd/>
- </benflist>
- </rexprnt>
- </root>
- </instance>
- <script type="javascript" src="../../../com/commonweb/js/common.js"/>
- <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
- <script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
- <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
- <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
- <script type="javascript" src="../../../mis/miscommonweb/js/RAC001.js"/>
- <script type="javascript" src="../../../mis/acntcommonweb/js/RAD001.js"/>
- <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- fGetScreenInit();
- var gDutplceinstcd = getUserInfo("dutplceinstcd"); // 사용자 기관코드
- model.setValue("/root/send/instcd", gDutplceinstcd);
- ]]>
- </script>
- <submission id="TXRSC08303" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/sdata" replace="instance" resultref="/root/temp"/>
- <submission id="TRRSC08303" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/upperlimitlst"/>
- <submission id="TRRAC90601" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/list"/>
- <submission id="TRRSC08304" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/cmprlst"/>
- <submission id="TXRSC08304" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save" replace="instance" resultref="/root/temp"/>
- <submission id="TXRSC08305" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save" replace="instance" resultref="/root/temp"/>
- <submission id="TXRSC08306" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save" replace="instance" resultref="/root/temp"/>
- </model>
- <script type="javascript">
- <![CDATA[
- // 화면 초기화
- function fGetScreenInit(){
- misfGridInit(grd_keumcomparelst);
- misfGridInit(grd_upperlimitupload);
-
- model.setValue("/root/send/instcd",getUserInfo("dutplceinstcd"));
- model.setValue("/root/send/srchbasedd" , getCurrentDate().substr(0,6));
- model.setValue("/root/send/ubasedd" , getCurrentDate().substr(0,6));
- btn_tabcompare.selected = true;
- model.refresh();
- }
- ]]>
- </script>
- </xhtml:head>
- <xhtml:body guideline="1,1194;2,783;1,1193;2,237;" 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:280px; height:15px; ">상한가 변경 물품 내역 비교</caption>
- </group>
- <group id="grp_biz" scroll="auto" style="left:0px; top:13px; width:1195px; height:762px; ">
- <shape id="rectangle1" appearance="rectangle" style="left:185px; top:8px; width:730px; height:20px; background-color:#ffffcc; "/>
- <caption id="caption9" style="left:251px; top:10px; width:700px; height:15px; ">- 선택클릭 , - Ctrl+클릭 , - 드래그 또는 Shift+클릭 , - 전체선택 또는 전체삭제 클릭</caption>
- <switch id="switch1" style="left:0px; top:31px; width:1194px; height:724px; ">
- <case id="case_compare" selected="true">
- <caption id="caption35" class="tit_2" style="left:5px; top:55px; width:265px; height:15px; ">상한가 변경 물품 내역 비교</caption>
- <line id="line2" class="line_1" style="x1:0px; y1:70px; x2:1190px; y2:70px; "/>
- <datagrid id="grd_keumcomparelst" nodeset="/root/main/cmprlst/cmprinfo" caption="^처리
여부^구분^물품코드^물품명^규격^EDI코드^제조회사명^변경전
상한가^변경전
계약가^변경후
상한가^변경후
계약가^거래처^단가계약
여부^기준일자^품의일자
품의번호^품의
순번^계약일자
계약번호^계약
순번^비고^변경계약사유^flag^^^^^|^처리
여부^구분^물품코드^물품명^규격^EDI코드^제조회사명^변경전
상한가^변경전
계약가^변경후
상한가^변경후
계약가^거래처^단가계약
여부^기준일자^품의일자
품의번호^품의
순번^계약일자
계약번호^계약
순번^비고^변경계약사유^flag^^^^^" colsep="^" colwidth="20, 35, 40, 87, 135, 79, 93, 90, 70, 70, 70, 70, 96, 55, 80, 100, 60, 100, 60, 200, 150,0,0,0,0,0.0" explorerbar="sort" frozencols="5" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" tooltip="true" navindex="7" style="left:0px; top:75px; width:1190px; height:640px; ">
- <col checkvalue="Y,N" ref="select" type="checkbox"/>
- <col ref="state" style="text-align:center; vertical-align:middle; padding-top:3; "/>
- <col ref="teamnm" style="text-align:center; vertical-align:middle; padding-right:3; "/>
- <col ref="goodcd" style="text-align:center; vertical-align:middle; padding-right:3; "/>
- <col ref="goodnm" style="text-align:center; vertical-align:middle; padding-right:3; "/>
- <col ref="goodspec" style="text-align:left; vertical-align:middle; padding-left:5; "/>
- <col ref="edicd" style="text-align:center; vertical-align:middle; padding-right:3; "/>
- <col ref="prodcmpynm" style="text-align:center; vertical-align:middle; padding-right:3; "/>
- <col ref="bfupperlimit" format="#,###" style="text-align:right; vertical-align:middle; padding-right:3; "/>
- <col ref="goodunitcost" format="#,###" style="text-align:right; vertical-align:middle; padding-right:3; "/>
- <col ref="afupperlimit" format="#,###" style="text-align:right; vertical-align:middle; padding-top:3; "/>
- <col ref="upperlimit" type="input" format="#,###" style="text-align:right; vertical-align:middle; padding-top:3; "/>
- <col ref="maincustlastsuplplce" style="text-align:center; vertical-align:middle; padding-top:3; "/>
- <col ref="costconyn" style="text-align:center; vertical-align:middle; padding-top:3; "/>
- <col ref="basedd" format="yyyy-mm-dd" style="text-align:center; vertical-align:middle; padding-top:3; "/>
- <col ref="purcnst" style="text-align:center; vertical-align:middle; padding-top:3; "/>
- <col ref="purccnsttnseq" style="text-align:center; vertical-align:middle; padding-top:3; "/>
- <col ref="aspurccon" style="text-align:center; vertical-align:middle; padding-top:3; "/>
- <col ref="purcconseq" style="text-align:center; vertical-align:middle; padding-top:3; "/>
- <col ref="remark" type="input" style="text-align:center; vertical-align:middle; padding-top:3; "/>
- <col ref="chngcmt" type="input" style="text-align:center; vertical-align:middle; padding-top:3; "/>
- <col ref="flag" visibility="hidden" style="text-align:center; vertical-align:middle; padding-top:3; "/>
- <col ref="purccnsttndd" visibility="hidden"/>
- <col ref="purccnsttnno" visibility="hidden"/>
- <col ref="purccondd" visibility="hidden"/>
- <col ref="purcconno" visibility="hidden"/>
- <col ref="cmt" visibility="hidden"/>
- <script type="javascript" ev:event="onmouseup">
- <![CDATA[
- if (isDataCell()) {
- for ( var i = 1; i <= grd_keumcomparelst.rows-2; i++) {
- model.setValue("/root/main/cmprlst/cmprinfo["+ i +"]/select" , "N");
- grd_keumcomparelst.rowStatus( i+1)= "0";
- }
-
- for ( var j = 0; j< grd_keumcomparelst.selectedRows;j++) {
- var k=grd_keumcomparelst.selectedRow(j)-1;
- var temp = model.getValue("/root/main/cmprlst/cmprinfo["+ k +"]/select");
- model.setValue("/root/main/cmprlst/cmprinfo["+ k +"]/select" , "Y");
- grd_keumcomparelst.rowStatus(k+1) = "2";
- }
- }
- model.refresh();
- ]]>
- </script>
- <script type="javascript" ev:event="ondblclick">
- <![CDATA[
- var instcd = getUserInfo("dutplceinstcd");
- var clickcol = grd_keumcomparelst.colAttribute(grd_keumcomparelst.col,"ref");
- var flag = grd_keumcomparelst.valueMatrix(grd_keumcomparelst.row, grd_keumcomparelst.colRef("flag"));
- var aspurccon = grd_keumcomparelst.valueMatrix(grd_keumcomparelst.row, grd_keumcomparelst.colRef("aspurccon"));
- var purccondd = aspurccon.substr(0,8);
- var purcconno = aspurccon.substr(11,4);
- model.makeValue("/root/popbattret/send/instcd", instcd);
- model.makeValue("/root/popbattret/send/purccondd", purccondd);
- model.makeValue("/root/popbattret/send/purcconno", purcconno);
-
- if(clickcol == "aspurccon"){ // 계약일자 / 번호
- // alert(purccondd);
- // alert(purcconno);
- if(flag == "PH") {
- window.load("SMRSP00800.xrw", "modal","", "left:100; top:100;", "/root/popbattret/send","/root/temp/callopen");
- } else {
- window.load("SMRSP00100.xrw", "modal","", "left:100; top:100;", "/root/popbattret/send","/root/temp/callopen");
- }
- }else if(clickcol == "purcconseq"){ // 총액품목 변경단가계약 조회 분기
- window.load("SMRSP00300.xrw", "modal","", "left:100; top:100;", "/root/popbattret/send","/root/temp/callopen");
- }
- ]]>
- </script>
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- var clickcol = grd_keumcomparelst.colAttribute(grd_keumcomparelst.col,"ref");
- if(clickcol == "chngcmt" ){
- var chngcmt = grd_keumcomparelst.valueMatrix(grd_keumcomparelst.row, grd_keumcomparelst.colRef("chngcmt"));
- var aspurccon = grd_keumcomparelst.valueMatrix(grd_keumcomparelst.row, grd_keumcomparelst.colRef("aspurccon"));
- for(i = 1 ; i<grd_keumcomparelst.rows-1 ; i++){
- var aspurccon1 = model.getValue("/root/main/cmprlst/cmprinfo["+ i +"]/aspurccon");
- if(aspurccon1 == aspurccon){
- model.setValue("/root/main/cmprlst/cmprinfo["+ i +"]/chngcmt" , chngcmt);
- model.setValue("/root/main/cmprlst/cmprinfo["+ i +"]/select" , "Y");
- grd_keumcomparelst.rowStatus(i+1) = "2";
- }
- }
- }
- if(clickcol == "remark" ){
- var remark = grd_keumcomparelst.valueMatrix(grd_keumcomparelst.row, grd_keumcomparelst.colRef("remark"));
-
- grd_keumcomparelst.valueMatrix(grd_keumcomparelst.selectedRow(0) , grd_keumcomparelst.colRef("select")) = "Y";
- grd_keumcomparelst.addStatus(grd_keumcomparelst.selectedRow(0) , "update");
- }
- model.refresh();
- ]]>
- </script>
- <script type="javascript" ev:event="onaftersort">
- <![CDATA[
- grd_keumcomparelst.gridToInstance();
- ]]>
- </script>
- </datagrid>
- <button id="btn_excel" class="btn2_letter4" style="left:1126px; top:-141px; width:64px; height:186px; ">
- <caption>엑셀저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- misfSaveExcel(grd_temp);
- ]]>
- </script>
- </button>
- <button id="button2" class="btn2_letter2" style="left:1082px; top:-141px; width:42px; height:186px; ">
- <caption>출력</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var flag = "본";
- fPrint(flag);
- ]]>
- </script>
- </button>
- <group id="grp_sea" style="left:0px; top:5px; width:1192px; height:35px; vertical-align:top; ">
- <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1190px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
- <caption id="caption2" class="search_name" style="left:203px; top:8px; width:86px; height:17px; ">계정과목 :</caption>
- <line id="line13" class="line_4" style="x1:1037px; y1:7px; x2:1037px; y2:29px; "/>
- <input id="ipt_srchbasedd" ref="/root/send/srchbasedd" class="input_default" navindex="3" inputtype="date" format="yyyy-mm" style="left:619px; top:7px; width:71px; height:19px; text-align:center; "/>
- <caption id="caption1" class="search_name" style="left:534px; top:8px; width:90px; height:17px; ">기준일자 :</caption>
- <button id="btn_regnohelp" class="icon_search" navindex="5" style="left:832px; top:9px; width:16px; height:16px; text-align:center; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var sinstcd = model.getValue("/root/send/instcd");
- rszfOpenPopUpListByWndName(ipt_maincustlastsuplplce,"","srchmaincustlastsuplplce,srchmaincustlastsuplplcenm","SPRSD00220","instcd",sinstcd);
- model.refresh();
- ]]>
- </script>
- </button>
- <input id="ipt_maincustlastsuplplcenm" ref="/root/send/srchmaincustlastsuplplcenm" class="output_fix" navindex="-1" editable="false" style="left:850px; top:7px; width:120px; height:19px; "/>
- <input id="ipt_maincustlastsuplplce" ref="/root/send/srchmaincustlastsuplplce" class="input_default" navindex="4" style="left:775px; top:7px; width:54px; height:19px; text-align:center; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- setInputNodeCurText();
- misfSearchCust(ipt_maincustlastsuplplcenm,cmb_instcd);
- ]]>
- </script>
- </input>
- <caption id="caption14" class="search_name" style="left:5px; top:9px; width:99px; height:17px; ">물품코드 :</caption>
- <input id="ipt_srchgoodcd" ref="/root/send/srchgoodcd" class="input_default" navindex="1" maxlength="12" showmask="true" style="left:90px; top:7px; width:105px; height:19px; text-align:center; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- model.setValue("/root/send/srchcustnm", "");
- if( model.getValue("/root/send/srchentrregno").length == 10 ){
- model.setValue("/root/send/custstat" , "1");
- model.setValue("/root/send/refcond" , "entrregno");
- model.setValue("/root/send/retrnm" , model.getValue("/root/send/srchentrregno"));
- if(submit("TRRAC90601")){
- model.setValue("/root/send/srchcustnm", model.getValue("/root/main/list/custlist/custnm"));
- }
- }
- model.refresh();
- ]]>
- </script>
- </input>
- <caption id="caption5" class="search_name" style="left:703px; top:8px; width:90px; height:17px; ">거래처 :</caption>
- <input id="ipt_srchwinacnt" ref="/root/send/srchwinacnt" class="input_essential" navindex="2" style="left:287px; top:7px; width:80px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- if(ipt_srchwinacnt.value == null || ipt_srchwinacnt.value == "") {
- opt_srchwinacntnm.value = "";
- } else {
- rszfValidationCheck("TRRAC00111", "acntlist", "acntflag,useyn,jobgb,srhtxt","1,,," + model.getValue(ipt_srchwinacnt.attribute("ref")) ,"","winacnt,winacntnm" ,ipt_srchwinacnt,"PPRAC00100","","");
- }
- ipt_srchwinacnt.refresh();
- opt_srchwinacntnm.refresh();
- ]]>
- </script>
- </input>
- <output id="opt_srchwinacntnm" ref="/root/send/srchwinacntnm" class="output_fix" appearance="output" style="left:390px; top:7px; width:115px; height:19px; "/>
- <button id="btn_srchwinacnt" class="icon_search" style="left:370px; top:13px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- rszfOpenPopUpListByWndName(ipt_srchwinacnt,"","srchwinacnt,srchwinacntnm","PPRAC00100","","");
- model.refresh();
- ]]>
- </script>
- </button>
- <button id="button6" class="btn1_letter1" navindex="6" visibility="hidden" style="left:1048px; top:7px; width:17px; height:22px; ">
- <caption>초기화</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- model.setValue("/root/send/srchwinacnt", "");
- model.setValue("/root/send/srchwinacntnm", "");
- model.setValue("/root/send/srchmaincustlastsuplplce", "");
- model.setValue("/root/send/srchmaincustlastsuplplcenm", "");
-
- model.refresh();
- ]]>
- </script>
- </button>
- <button id="button4" class="btn4_letter2" navindex="8" style="left:1123px; top:7px; width:56px; height:22px; ">
- <caption>저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- for(i = 2 ; i<grd_keumcomparelst.rows ; i++){
- var basedd = grd_keumcomparelst.valueMatrix(i, grd_keumcomparelst.colRef("basedd"));
- var edicd = grd_keumcomparelst.valueMatrix(i, grd_keumcomparelst.colRef("edicd"));
- var costconyn = grd_keumcomparelst.valueMatrix(i, grd_keumcomparelst.colRef("costconyn"));
- if(grd_keumcomparelst.rowStatus(i) == "2" && costconyn == "N") { //단가계약여부
- messageBox(i-1+"번째 [" + grd_keumcomparelst.valueMatrix(i, grd_keumcomparelst.colRef("goodnm")) + "]품목이 단가계약 되어있지", "I011", "");
- return false;
- }
- }
- updtdata = getGridUpdateData(grd_keumcomparelst);
-
- if(updtdata == ""){
- messageBox("저장할 데이터가 ","E014");
- return false;
- }else{
- model.setValue("/root/send/save/keumcomparelst", updtdata);
- if( submit("TXRSC08305") ) {
- messageBox("저장이","I002");
- btn_sea.dispatch("DOMActivate");
- } else {
- messageBox("저장","E009");
- return;
- }
- }
- ]]>
- </script>
- </button>
- <button id="btn_sea" class="btn1_letter2" navindex="6" style="left:1052px; top:7px; width:56px; height:22px; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var srchbasedd = model.getValue("/root/send/srchbasedd");
- model.setValue("/root/send/srchfromdd", srchbasedd +"01");
- model.setValue("/root/send/srchtodd", srchbasedd +"31");
- if( submit("TRRSC08304") ){
- var lstCnt = getNodesetCount("/root/main/cmprlst/cmprinfo");
- caption3.value = "(건수:" + lstCnt + "건)";
- }
-
- model.refresh();
-
- grd_keumcomparelst.row = 0;
- ]]>
- </script>
- </button>
- <caption id="caption15" style="left:982px; top:9px; width:30px; height:20px; ">약품</caption>
- <select id="checkbox1" ref="/root/send/phflag" overflow="visible" appearance="full" style="left:1010px; top:10px; width:20px; height:20px; border-style:none; ">
- <choices>
- <item>
- <label/>
- <value>PH</value>
- </item>
- </choices>
- </select>
- </group>
- <caption id="caption3" style="left:795px; top:50px; width:200px; height:20px; font-family:돋움체; font-size:10pt; font-weight:bold; color:#0000ff; text-align:right; "/>
- <button id="button5" class="btn5_letter5" navindex="21" style="left:1105px; top:50px; width:75px; height:19px; ">
- <caption>Excel 저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- if( grd_keumcomparelst.rows - grd_keumcomparelst.fixedRows > 0 ) {
- var fileName = "상한가변경 물품내역_" + getCurrentDate();
- var fileName = window.fileDialog("save", ",", false, fileName, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
- grd_keumcomparelst.saveExcel(fileName, "Sheet");
- } else {
- messageBox("저장 데이터가","I004");
- }
- ]]>
- </script>
- </button>
- <bool id="bol_selectall" overflow="visible" appearance="full" ref="/root/send/selectyn" style="left:21px; top:87px; width:20px; height:18px; font-weight:bold; border-style:none; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- var row = grd_keumcomparelst.rows;
-
- if( row > 1 ) {
- if(bol_selectall.value == "true") {
- for( var i = 1; i <= row-2 ; i++ ) {
- model.setValue("/root/main/cmprlst/cmprinfo["+ i +"]/select" , "Y");
- grd_keumcomparelst.rowStatus(i+1) = "2";
- }
- } else {
- for( var i = 1; i <= row-2 ; i++ ) {
- model.setValue("/root/main/cmprlst/cmprinfo["+ i +"]/select" , "N");
- grd_keumcomparelst.rowStatus(i+1) = "0";
- }
- }
- model.refresh();
- }
- ]]>
- </script>
- </bool>
- </case>
- <case id="case_upload">
- <caption id="caption7" class="tit_2" style="left:5px; top:50px; width:215px; height:13px; ">상한가 변경 물품 내역 업로드</caption>
- <line id="line3" class="line_1" style="x1:0px; y1:65px; x2:1192px; y2:65px; "/>
- <caption id="caption4" style="left:925px; top:45px; width:140px; height:18px; font-family:돋움체; font-size:10pt; font-weight:bold; color:#0000ff; "/>
- <datagrid id="grd_upperlimitupload" nodeset="/root/main/upperlimitlst/upperlimitinfo" caption="EDI 코드^변경전 상한가(숫자만)^변경후 상한가(숫자만)^기준일자(YYYYMMDD)^비고" colsep="^" colwidth="150, 200, 200, 150, 400" ellipsis="true" rowheader="update" rowheight="23" rowsep="|" selectionmode="listbox" tooltip="true" style="left:0px; top:70px; width:1192px; height:645px; ">
- <col ref="edicd" style="text-align:center; "/>
- <col ref="bfupperlimit" format="#,###" style="text-align:center; "/>
- <col ref="afupperlimit" format="#,###" style="text-align:center; "/>
- <col ref="basedd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="remark" style="text-align:center; "/>
- <script type="javascript" ev:event="onmouseup">
- <![CDATA[
- if (isDataCell()) {
- for ( var i = 1; i < grd_upperlimitupload.rows; i++) {
- grd_upperlimitupload.rowStatus(i) = 0;
- }
-
- for ( var j = 0 ; j< grd_upperlimitupload.selectedRows;j++) {
- // alert("선택:"+grd_upperlimitupload.selectedRow(j));
- grd_upperlimitupload.rowStatus(grd_upperlimitupload.selectedRow(j)) = 4;
- }
- }
- ]]>
- </script>
- </datagrid>
- <button id="button1" class="btn5_letter3" style="left:1136px; top:44px; width:53px; height:19px; ">
- <caption>업로드</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- model.removenode("/root/main/upperlimitlst/upperlimitinfo");
- var menu_cnt = grd_upperlimitupload.rows;
- var fileName = window.fileDialog("open", "", false);
- grd_upperlimitupload.loadExcel(fileName);
-
- for (i=grd_upperlimitupload.fixedRows; i<grd_upperlimitupload.rows; i++)
- {
- grd_upperlimitupload.rowStatus(i) = 1; //insert
- }
-
- model.setValue("/root/send/sdata", grd_upperlimitupload.getUpdateData());
- var lstCnt = getNodesetCount("/root/main/upperlimitlst/upperlimitinfo");
- if( lstCnt > 0 ){
- if( submit("TXRSC08303")){
- btn_search.dispatch("DOMActivate");
- messageBox("업로드되었습니다.", "I000");
- caption4.value = "(건수:" + lstCnt + "건)";
- }
- }
- model.refresh();
- ]]>
- </script>
- </button>
- <group id="group1" style="left:0px; top:5px; width:1192px; height:35px; vertical-align:top; ">
- <shape id="roundrect2" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1190px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
- <line id="line1" class="line_4" style="x1:1052px; y1:7px; x2:1052px; y2:29px; "/>
- <button id="btn_search" class="btn1_letter2" style="left:1061px; top:6px; width:56px; height:22px; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- caption4.value = "";
- var ubasedd = model.getValue("/root/send/ubasedd");
- model.setValue("/root/send/ufromdd", ubasedd +"01");
- model.setValue("/root/send/utodd", ubasedd +"31");
-
- if( submit("TRRSC08303") ) {
- var lstCnt = getNodesetCount("/root/main/upperlimitlst/upperlimitinfo");
- if( lstCnt > 0 ){
- caption4.value = "(건수:" + lstCnt + "건)";
- }
- }
- model.refresh();
- ]]>
- </script>
- </button>
- <button id="btn_save" class="btn4_letter2" style="left:1125px; top:6px; width:56px; height:22px; ">
- <caption>저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- if(grd_upperlimitupload.rows != "1") model.setValue("/root/send/save/upperlimitinfo" ,grd_upperlimitupload.getUpdateData());
-
- if( submit("TXRSC08304") ) {
- btn_search.dispatch("DOMActivate");
- messageBox(" ", "I001", "");
- }
- ]]>
- </script>
- </button>
- <caption id="caption8" class="search_name" style="left:19px; top:8px; width:90px; height:17px; ">기준일자 :</caption>
- <input id="ipt_ubasedd" ref="/root/send/ubasedd" class="input_default" navindex="3" inputtype="date" format="yyyy-mm" style="left:104px; top:7px; width:100px; height:19px; text-align:center; "/>
- </group>
- <button id="button3" class="btn5_letter4" style="left:1067px; top:44px; width:64px; height:19px; ">
- <caption>전체삭제</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- for ( var i = 1; i < grd_upperlimitupload.rows; i++) {
- grd_upperlimitupload.rowStatus(i) = 4;
- }
- ]]>
- </script>
- </button>
- </case>
- </switch>
- <button id="btn_tabcompare" class="btn_sw" group="tab" selected="true" style="left:0px; top:10px; width:95px; height:22px; ">
- <caption>내 역 비 교</caption>
- <toggle case="case_compare" ev:event="onclick"/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- ]]>
- </script>
- </button>
- <button id="btn_tabupload" class="btn_sw" group="tab" style="left:95px; top:10px; width:75px; height:22px; ">
- <caption>업 로 드</caption>
- <toggle case="case_upload" ev:event="onclick"/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- ]]>
- </script>
- </button>
- <caption id="caption10" style="left:195px; top:8px; width:60px; height:20px; font-weight:bold; color:#ff0000; ">단일선택</caption>
- <caption id="caption11" style="left:335px; top:7px; width:60px; height:20px; font-weight:bold; color:#ff0000; ">건별선택</caption>
- <caption id="caption12" style="left:474px; top:7px; width:60px; height:20px; font-weight:bold; color:#ff0000; ">구간선택</caption>
- <caption id="caption13" style="left:685px; top:8px; width:60px; height:20px; font-weight:bold; color:#ff0000; ">전체선택</caption>
- <button id="btn_exe" class="btn3_letter4" style="left:1100px; top:8px; width:80px; height:22px; ">
- <caption>일괄처리</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var btnchk = messageBox("변경계약 일괄처리", "S001");
- if(btnchk == "6"){
- var row = grd_keumcomparelst.rows;
- if( row > 1 ) {
- for( var i = 1; i <= row-1 ; i++ ) {
- var select = model.getValue("/root/main/cmprlst/cmprinfo["+ i +"]/select");
- var state = model.getValue("/root/main/cmprlst/cmprinfo["+ i +"]/state");
- var costconyn = model.getValue("/root/main/cmprlst/cmprinfo["+ i +"]/costconyn");
- if(select == "Y"){
- if(state == "Y"){ //처리완료
- messageBox(i+"번째 [" + grd_keumcomparelst.valueMatrix(i+1, grd_keumcomparelst.colRef("goodnm")) + "]품목이 이미 일괄처리되어", "I010", "");
- return false;
- }else{
- if(costconyn == "N"){
- messageBox(i+"번째 [" + grd_keumcomparelst.valueMatrix(i+1, grd_keumcomparelst.colRef("goodnm")) + "]품목이 단가계약 되어있지", "I011", "");
- return false;
- }
- }
- }
- }
- updtdata = getGridUpdateData(grd_keumcomparelst);
- if(updtdata == ""){
- messageBox("일괄처리할 데이터를","C002");
- return false;
- }else{
- model.setValue("/root/send/save/exelist", updtdata);
- if( submit("TXRSC08306") ) {
- messageBox("처리가","I002");
- btn_sea.dispatch("DOMActivate");
- } else {
- messageBox("처리","E009");
- return;
- }
- }
- }
- }
- ]]>
- </script>
- </button>
- </group>
- <select1 id="cmb_instcd" ref="/root/send/instcd" class="combo_default" navindex="1" visibility="hidden" appearance="minimal" style="left:515px; top:55px; width:20px; height:19px; ">
- <choices>
- <itemset nodeset="/root/init/instcd">
- <label ref="cdnm"/>
- <value ref="cdid"/>
- </itemset>
- </choices>
- </select1>
- </xhtml:body>
- </xhtml:html>
|