123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447 |
- <?xml version="1.0" encoding="EUC-KR"?>
- <?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.css" ?>
- <xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" 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">
- <xhtml:head>
- <xhtml:title>예산과목 관리</xhtml:title>
- <model id="model1">
- <instance id="instance1">
- <root xmlns="">
- <main>
- <condition>
- <acntflag/>
- <bugtuseyn>Y</bugtuseyn>
- <srhflag>1</srhflag>
- <srhtxt/>
- </condition>
- <list>
- <acntlist/>
- <bugtlist/>
- </list>
- </main>
- <send>
- <acntlist/>
- <bugtlist/>
- </send>
- <init/>
- <hidden/>
- <temp/>
- </root>
- </instance>
- <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" ev:event="xforms-ready">
- <![CDATA[
-
- fCheckAuth();
- fOpenForm();
- misfMsterDetailSet(grd_acntcd, null, "TRRBC90101", "Y");
- misfMsterDetailSet(grd_bugtcd, null, "TRRBC90101", "Y");
- ]]>
- </script>
- <script type="javascript">
- <![CDATA[
- //========================================================================================
- //버튼에 대한 화면 권한 체크(R : 읽기, X : 입력/수정/삭제, P : 출력)
- //========================================================================================
- function fCheckAuth() {
- btn_search.disabled = !checkAuth("R");
- btn_save.disabled = !checkAuth("X");
- btn_prt.disabled = !checkAuth("P");
- }
-
- //========================================================================================
- //화면 로드시 초기화 함수
- //========================================================================================
- function fOpenForm() {
- model.removenode("/root/main/list");
- model.refresh();
- }
-
- //========================================================================================
- //계정코드 조회
- //========================================================================================
- function fGetAcntList()
- {
- //기존 데이터 삭제
- // model.removenode("/root/main/acntcd/acntlist");
- // model.resetInstanceNode("/root/send/acntlist");
- model.copyNode("/root/send/acntlist","/root/main/condition");
- misfMsterDetailRetrieve();
-
- for(var i=1; i<grd_acntcd.rows; i++)
- {
- var sFlag = grd_acntcd.valueMatrix(i, grd_acntcd.colRef("flag"));
-
- if(sFlag == "M")
- {
- misfSetReadOnlyCol(grd_acntcd, "bugtcntryn,bugtcvrtpsblyn,bugtautoaprvyn,bugtearncostflag", true, i);
- }
- else
- {
- misfSetReadOnlyCol(grd_acntcd, "bugtcntryn,bugtcvrtpsblyn,bugtautoaprvyn,bugtearncostflag", false, i);
- }
- }
- //grd_acntcd.colDisabled(grd_acntcd.colRef("bugtautoaprvyn")) = true;
-
-
- }
-
- //========================================================================================
- // 저장버튼 클릭시 저장 수행 함수
- //========================================================================================
- function fClickSaveBtn()
- {
- if(!fIsValidForSave())//저장전 유효성 검사
- return;
-
- misfSave("TXRBC00101");
-
- btn_search.dispatch("DOMActivate");
-
- }
-
- //========================================================================================
- //저장전 유효성 검사
- //========================================================================================
- function fIsValidForSave() {
-
- var sAcntList = getGridUpdateData(grd_acntcd);
- var sBugtList = getGridUpdateData(grd_bugtcd);
- if(sAcntList == "" && sBugtList == "") {
- messageBox("변경된 데이터가","I004");
- return false;
- }else if(sAcntList != "" || sBugtList != "" ) {
- model.copyNode("/root/send/acntlist", sAcntList);
- model.copyNode("/root/send/bugtlist", sBugtList);
- return true;
- }
- }
-
- //========================================================================================
- //그리드 행 추가
- //========================================================================================
- function fAddGrid(pGrid) {
- var acnt_row = grd_acntcd.row;
- if ( acnt_row > 0 ) {
- pGrid.addRow();
- var sAcntCd = grd_acntcd.valueMatrix(acnt_row, grd_acntcd.colRef("acntcd"));
-
- model.setValue("/root/main/bugtcd/bugtlist["+ pGrid.row + "]/acntcd", sAcntCd);
- pGrid.editCell();
-
- model.refresh();
- }else {
- messageBox("계정코드를 선택하지 ","E007");
- }
- }
-
- //========================================================================================
- //그리드 행 삭제
- //========================================================================================
- function fDelGrid(pGrid)
- {
- var cur_row = pGrid.row;
- if(cur_row > -1)
- {
- deleteSelectedRows(pGrid, false); //true : 바로삭제, false : 상태만 삭제로 변경
- pGrid.refresh();
- }
- else if(cur_row == -1)
- {
- messageBox("삭제하려는 행을", "C002");
- }
- }
-
- function fSetDefaultValue()
- {
- if(grd_acntcd.col == grd_acntcd.colRef("bugtuseyn") && grd_acntcd.valueMatrix(grd_acntcd.row, grd_acntcd.colRef("flag")) == "M")
- {
- var sSupAcntCd3 = grd_acntcd.valueMatrix(grd_acntcd.row, grd_acntcd.colRef("supacntcd3"));
- var sSupAcntCd4 = grd_acntcd.valueMatrix(grd_acntcd.row, grd_acntcd.colRef("supacntcd4"));
- var sValue = grd_acntcd.valueMatrix(grd_acntcd.row, grd_acntcd.colRef("bugtuseyn"));
- for(var i=1; i<grd_acntcd.rows; i++)
- {
- if(grd_acntcd.valueMatrix(i, grd_acntcd.colRef("flag")) != "D") continue;
- var sCmpSupAcntCd3 = grd_acntcd.valueMatrix(i, grd_acntcd.colRef("supacntcd3"));
- var sCmpSupAcntCd4 = grd_acntcd.valueMatrix(i, grd_acntcd.colRef("supacntcd4"));
- if(sSupAcntCd3 == sCmpSupAcntCd3 && sSupAcntCd4 == sCmpSupAcntCd4)
- {
- if(sValue == "Y")
- {
- grd_acntcd.valueMatrix(i, grd_acntcd.colRef("bugtuseyn")) = "Y";
- grd_acntcd.valueMatrix(i, grd_acntcd.colRef("bugtcntryn")) = "Y";
- grd_acntcd.valueMatrix(i, grd_acntcd.colRef("bugtcvrtpsblyn")) = "Y";
- grd_acntcd.valueMatrix(i, grd_acntcd.colRef("bugtautoaprvyn")) = "Y";
- var iExistRow = grd_bugtcd.findRow(grd_acntcd.valueMatrix(i, grd_acntcd.colRef("acntcd")), 1, grd_bugtcd.colRef("acntcd"));
- if(iExistRow == -1)
- {
- grd_bugtcd.addRow();
- grd_bugtcd.valueMatrix(grd_bugtcd.row, grd_bugtcd.colRef("acntcd")) = grd_acntcd.valueMatrix(i, grd_acntcd.colRef("acntcd"));
- grd_bugtcd.valueMatrix(grd_bugtcd.row, grd_bugtcd.colRef("bugtcd")) = "01";
- grd_bugtcd.valueMatrix(grd_bugtcd.row, grd_bugtcd.colRef("bugtnm")) = grd_acntcd.valueMatrix(i, grd_acntcd.colRef("acntnm"));
- }
- else if(iExistRow != -1 && grd_bugtcd.rowStatus(iExistRow) == 4)
- {
- grd_bugtcd.removeStatus(iExistRow, "delete");
- }
- }
- else
- {
- grd_acntcd.valueMatrix(i, grd_acntcd.colRef("bugtuseyn")) = "N";
- grd_acntcd.valueMatrix(i, grd_acntcd.colRef("bugtcntryn")) = "N";
- grd_acntcd.valueMatrix(i, grd_acntcd.colRef("bugtcvrtpsblyn")) = "N";
- grd_acntcd.valueMatrix(i, grd_acntcd.colRef("bugtautoaprvyn")) = "N";
-
- var iRowIdx = grd_bugtcd.findRow(grd_acntcd.valueMatrix(i, grd_acntcd.colRef("acntcd")), 1, grd_bugtcd.colRef("acntcd"));
- var sRowStatus = grd_bugtcd.rowStatus(iRowIdx);
- if(sRowStatus == 1 || sRowStatus == 3)
- {
- grd_bugtcd.deleteRow(iRowIdx, false);
- }
- else if(sRowStatus == 0)
- {
- grd_bugtcd.addStatus(iRowIdx, "delete");
- }
- }
- grd_acntcd.addStatus(i, "update");
- }
- }
- grd_acntcd.removeStatus(grd_acntcd.row, "update");
- }
- else if(grd_acntcd.col == grd_acntcd.colRef("bugtuseyn") && grd_acntcd.valueMatrix(grd_acntcd.row, grd_acntcd.colRef("flag")) == "D")
- {
- var sValue = grd_acntcd.valueMatrix(grd_acntcd.row, grd_acntcd.colRef("bugtuseyn"));
- if(sValue == "Y")
- {
- grd_acntcd.valueMatrix(grd_acntcd.row, grd_acntcd.colRef("bugtcntryn")) = "Y";
- grd_acntcd.valueMatrix(grd_acntcd.row, grd_acntcd.colRef("bugtcvrtpsblyn")) = "Y";
- grd_acntcd.valueMatrix(grd_acntcd.row, grd_acntcd.colRef("bugtautoaprvyn")) = "Y";
- var iExistRow = grd_bugtcd.findRow(grd_acntcd.valueMatrix(grd_acntcd.row, grd_acntcd.colRef("acntcd")), 1, grd_bugtcd.colRef("acntcd"));
- if(iExistRow == -1)
- {
- grd_bugtcd.addRow();
- grd_bugtcd.valueMatrix(grd_bugtcd.row, grd_bugtcd.colRef("acntcd")) = grd_acntcd.valueMatrix(grd_acntcd.row, grd_acntcd.colRef("acntcd"));
- grd_bugtcd.valueMatrix(grd_bugtcd.row, grd_bugtcd.colRef("bugtcd")) = "01";
- grd_bugtcd.valueMatrix(grd_bugtcd.row, grd_bugtcd.colRef("bugtnm")) = grd_acntcd.valueMatrix(grd_acntcd.row, grd_acntcd.colRef("acntnm"));
- }
- else if(iExistRow != -1 && grd_bugtcd.rowStatus(iExistRow) == 4)
- {
- grd_bugtcd.removeStatus(iExistRow, "delete");
- }
- }
- else
- {
- grd_acntcd.valueMatrix(grd_acntcd.row, grd_acntcd.colRef("bugtcntryn")) = "N";
- grd_acntcd.valueMatrix(grd_acntcd.row, grd_acntcd.colRef("bugtcvrtpsblyn")) = "N";
- grd_acntcd.valueMatrix(grd_acntcd.row, grd_acntcd.colRef("bugtautoaprvyn")) = "N";
- var iRowIdx = grd_bugtcd.findRow(grd_acntcd.valueMatrix(grd_acntcd.row, grd_acntcd.colRef("acntcd")), 1, grd_bugtcd.colRef("acntcd"));
- var sRowStatus = grd_bugtcd.rowStatus(iRowIdx);
-
- if(sRowStatus == 1 || sRowStatus == 3)
- {
- grd_bugtcd.deleteRow(iRowIdx, false);
- }
- else if(sRowStatus == 0)
- {
- grd_bugtcd.addStatus(iRowIdx, "delete");
- }
- }
- }
- }
- ]]>
- </script>
- <submission id="TRRBC00102" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/bugtlist" resultref="/root/main/bugtcd/bugtlist"/>
- <submission id="TXRBC00101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/temp"/>
- <submission id="TRRBC90101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/acntlist" resultref="/root/main/list"/>
- </model>
- </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="caption6" class="tit_1" style="left:0px; top:0px; width:230px; height:13px; ">예산과목 관리</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; ">
- <datagrid id="grd_bugtcd" nodeset="/root/main/list/bugtlist" visibility="hidden" caption="계정코드^예산코드^예산명^예산코드(원본)" colsep="^" colwidth="70, 50, 110, 0" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="23" rowsep="|" style="left:925px; top:76px; width:270px; height:660px; ">
- <col ref="acntcd"/>
- <col ref="bugtcd" type="input" maxlength="2"/>
- <col ref="bugtnm" type="input"/>
- <col ref="orgbugtcd"/>
- </datagrid>
- <line id="line1" class="line_1" style="x1:0px; y1:73px; x2:1194px; y2:72px; "/>
- <caption id="caption35" class="tit_2" style="left:5px; top:55px; width:105px; height:13px; ">계정코드</caption>
- <group id="group6" style="left:0px; top:10; width:1194; height:35; vertical-align:top; ">
- <shape id="roundrect3" class="roundrect_search" appearance="roundrect" style="left:0px; top:0px; width:1194; height:35; "/>
- <select1 id="cmb_useyns" ref="/root/main/condition/bugtuseyn" class="combo_s_essential" navindex="2" appearance="minimal" style="left:377px; top:8px; width:100px; height:19px; ">
- <choices>
- <item>
- <label>전체</label>
- <value>%</value>
- </item>
- <item>
- <label>사용</label>
- <value>Y</value>
- </item>
- <item>
- <label>사용안함</label>
- <value>N</value>
- </item>
- </choices>
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- // fGetAcntList();
- ]]>
- </script>
- </select1>
- <caption id="caption3" class="search_name" style="left:285px; top:9px; width:90px; height:17px; ">예산사용 :</caption>
- <caption id="caption5" class="search_name" style="left:16px; top:9px; width:86px; height:17px; ">계정구분 :</caption>
- <caption id="caption7" class="search_name" style="left:510px; top:9px; width:89px; height:17px; ">계정코드 :</caption>
- <input id="ipt_srhtxt" ref="/root/main/condition/srhtxt" class="input_s_essential" navindex="4" style="left:731px; top:8px; width:240px; height:19px; "/>
- <select1 id="cmb_acntflag" ref="/root/main/condition/acntflag" class="combo_s_essential" navindex="1" appearance="minimal" style="left:107px; top:8px; width:145px; height:19px; ">
- <choices>
- <item>
- <label/>
- <value/>
- </item>
- <item>
- <label>자산</label>
- <value>1</value>
- </item>
- <item>
- <label>부채</label>
- <value>2</value>
- </item>
- <item>
- <label>자본</label>
- <value>3</value>
- </item>
- <item>
- <label>수익</label>
- <value>4</value>
- </item>
- <item>
- <label>비용</label>
- <value>5</value>
- </item>
- </choices>
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- model.setValue("/root/main/condition/srhflag","1");
- model.setValue("/root/main/condition/srhtxt","");
- fGetAcntList();
- ]]>
- </script>
- </select1>
- <select1 id="rdo_srhflag" ref="/root/main/condition/srhflag" class="radio_search" overflow="visible" appearance="full" cellspacing="15" cols="2" style="left:601px; top:8px; width:118px; height:19px; border-style:none; ">
- <choices>
- <item>
- <label>코드</label>
- <value>1</value>
- </item>
- <item>
- <label>코드명</label>
- <value>2</value>
- </item>
- </choices>
- </select1>
- <button id="btn_search" class="btn1_letter2" navindex="4" style="left:1123px; top:8px; width:56px; height:22px; text-align:left; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- fGetAcntList();
- ]]>
- </script>
- </button>
- <line id="line5" class="line_4" style="x1:1107px; y1:8px; x2:1107px; y2:30px; border-color:#ffe4bb; border-left-style:solid; "/>
- </group>
- <datagrid id="grd_acntcd" nodeset="/root/main/list/acntlist" caption="항코드^항^목코드^목^예산사용^세목^세목^예산통제^전용가능^자동승인^조회여부^예산구분^flag" colsep="^" colwidth="0, 155, 0, 180, 85, 90, 230, 70, 70, 70, 70, 105, 100, 100" ellipsis="true" mergecellsfixedcols="never" mergecellsfixedrows="never" rowheader="update" rowheight="23" rowsep="|" tooltip="true" style="left:0px; top:76px; width:1195px; height:663px; ">
- <col ref="supacntcd3" visibility="hidden"/>
- <col ref="supacntnm3"/>
- <col ref="supacntcd4" visibility="hidden"/>
- <col ref="supacntnm4"/>
- <col checkvalue="Y,N" ref="bugtuseyn" type="checkbox"/>
- <col ref="acntcd"/>
- <col ref="acntnm"/>
- <col checkvalue="Y,N" ref="bugtcntryn" type="checkbox"/>
- <col checkvalue="Y,N" ref="bugtcvrtpsblyn" type="checkbox"/>
- <col checkvalue="Y,N" ref="bugtautoaprvyn" type="checkbox"/>
- <col checkvalue="Y,N" ref="bugtselectyn" type="checkbox"/>
- <col ref="bugtearncostflag" type="combo" style="text-align:center; ">
- <choices>
- <item>
- <label>수입</label>
- <value>1</value>
- </item>
- <item>
- <label>비용</label>
- <value>2</value>
- </item>
- <item>
- <label>구매</label>
- <value>3</value>
- </item>
- <item>
- <label>자본</label>
- <value>4</value>
- </item>
- </choices>
- </col>
- <col ref="flag" visibility="hidden"/>
- <choices>
- <item>
- <label>Y</label>
- <value>Y</value>
- </item>
- <item>
- <label>N</label>
- <value>N</value>
- </item>
- </choices>
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- fSetDefaultValue();
- ]]>
- </script>
- </datagrid>
- <button id="button1" class="btn2_letter4" style="left:1125px; top:49px; width:64px; height:19px; ">
- <caption>엑셀출력</caption>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- misfSaveExcel(grd_acntcd);
- ]]>
- </script>
- </button>
- </group>
- <group id="group4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
- <line id="line3" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
- <button id="btn_save" class="btn4_letter2" style="left:1138px; top:3px; width:56px; height:22px; ">
- <caption>저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- fClickSaveBtn();
- ]]>
- </script>
- </button>
- <button id="btn_prt" class="btn6_letter2" visibility="hidden" style="left:0px; top:3px; width:56px; height:22px; ">
- <caption>출력</caption>
- </button>
- <caption id="caption1" style="left:75px; top:3px; width:615px; height:20px; font-weight:bold; color:#ff0000; text-align:left; vertical-align:middle; ">자산 계정은 수익으로 설정 할 수 없습니다. 자산 수익 반환 시 예산의 큰 문제점이 발생할 수 있습니다.</caption>
- </group>
- </xhtml:body>
- </xhtml:html>
|