123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306 |
- <?xml version="1.0" encoding="EUC-KR"?>
- <?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/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>외상매입금 잔액 LIST (결산)</xhtml:title>
- <model id="model1">
- <instance id="instance1">
- <root xmlns="">
- <main>
- <settlebalancesheet/>
- </main>
- <send>
- <condition>
- <instcd/>
- <acntcd4/>
- <acntcd>1</acntcd>
- <entrregno/>
- <custnm/>
- <fromdd/>
- <todd/>
- <custflag/>
- </condition>
- <data>
- <instcd/>
- <mngtcd/>
- </data>
- </send>
- <init>
- <code>
- <code>
- <acnt4/>
- </code>
- </code>
- </init>
- <temp/>
- <hidden>
- </hidden>
- </root>
- </instance>
- <script type="javascript" src="../../../com/commonweb/js/common.js"/>
- <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
- <script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
- <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
- <script type="javascript" src="../../../com/commonweb/js/utilHelper.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/RAM001.js"/>
- <script type="javascript" src="../../../mis/acntcommonweb/js/RAD001.js"/>
- <script type="javascript" src="../../../mis/miscommonweb/js/RAC001.js"/>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- fInitialize();
- ]]>
- </script>
- <script type="javascript">
- <![CDATA[
-
- function fInitialize()
- {
- model.removenode("/root/main/balancesheet");
-
- var instcd = getUserInfo("dutplceinstcd");
- model.setValue("/root/send/condition/instcd", instcd);
-
-
- model.setValue(ipt_fromdd.attribute("ref"), getCurrentDate().toString());
- model.setValue(ipt_todd.attribute("ref"), getCurrentDate().toString());
-
- model.setValue("/root/send/data/instcd", instcd);
- model.setValue("/root/send/data/mngtcd", "%");
- submit("TRRAZ00001");
-
- model.makeNode("/root/init/code/code/acnt4");
- model.makeValue("/root/init/code/code/acnt4[1]/cdnm", "전 체");
- model.makeValue("/root/init/code/code/acnt4[1]/cdid", "");
- // model.makeValue("/root/init/code/code/acnt4[1]/cdgbn", "R0010");
- var seq = 1;
- for (i=1; i<= instance1.selectNodes("root/init/code/code/codelist").length; i++)
- {
- cdgbn = model.getValue("/root/init/code/code/codelist[" + i + "]/cdgbn");
- seq++;
- //alert(i + " " + cdgbn)
- if (cdgbn == "R0010")
- {
- //alert(i + " " + cdgbn + " " + seq)
- model.makeNode( "/root/init/code/code/acnt4[" + seq + "]");
- model.makeValue( "/root/init/code/code/acnt4[" + seq + "]/cdid", model.getValue("/root/init/code/code/codelist[" + i + "]/cdid"));
- model.makeNode( "/root/init/code/code/acnt4[" + seq + "]");
- model.makeValue( "/root/init/code/code/acnt4[" + seq + "]/cdnm", model.getValue("/root/init/code/code/codelist[" + i + "]/cdnm"));
- }
- }
- cmb_supacntcd4.dispatch("xforms-value-changed");
- cmb_supacntcd4.select(0);
- }
-
-
- function fCheckAuth()
- {
- btn_search.disabled = !checkAuth("R");
- }
-
- //========================================================================================
- // 부서코드 조회
- //========================================================================================
- function fOpenPopupDeptHelp(pControl, pInstance)
- {
- misfOpenPopUpList("02", pControl, "", pInstance);
- model.refresh();
- }
-
- ]]>
- </script>
- <submission id="TRRAZ00001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/data" resultref="/root/init/code/codelist"/>
- <submission id="TRRAD00325" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition" resultref="/root/main/balancesheet"/>
- </model>
- </xhtml:head>
- <xhtml:body guideline="1,1195;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
- <group id="grp_1" style="left:0px; top:0px; width:1195px; height:13px; ">
- <caption id="cap_title" class="tit_1" style="left:0px; top:0px; width:293px; height:14px; ">외상매입금 잔액 LIST (결산)</caption>
- <caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
- </group>
- <group id="grp_3" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
- <group id="grp_sea" style="left:0px; top:10px; width:1195px; height:85px; vertical-align:top; ">
- <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:85px; background-color:#fffbf2; border-color:#ffd799; "/>
- <button id="btn_search" class="btn1_letter2" navindex="4" style="left:1123px; top:28px; width:56px; height:22px; text-align:left; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- model.removeNodeset(grd_settlebalancesheet.nodeset);
- submit("TRRAD00325");
- ]]>
- </script>
- </button>
- <line id="lin_5" class="line_4" style="x1:1107px; y1:18px; x2:1107px; y2:65px; border-color:#ffe4bb; border-left-style:solid; "/>
- <caption id="caption1" class="search_name" style="left:445px; top:10px; width:90px; height:17px; ">일 자 :</caption>
- <select1 id="cmb_acntcd" ref="/root/send/condition/acntcd" class="combo_s_essential" navindex="1" appearance="minimal" style="left:270px; top:9px; width:160px; height:19px; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <select1 id="cmb_supacntcd4" ref="/root/send/condition/acntcd4" class="combo_s_essential" navindex="1" appearance="minimal" style="left:156px; top:9px; width:109px; height:19px; ">
- <choices>
- <itemset nodeset="/root/init/code/code/acnt4">
- <label ref="cdnm"/>
- <value ref="cdid"/>
- </itemset>
- </choices>
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- racfGetSupAcntPrAcntListCombo(model.getValue("/root/send/condition/acntcd4"), cmb_acntcd, "Y");
- model.setValue(cmb_acntcd.choices.itemset.attribute("nodeset") + "[1]/acntnm", "전 체");
- cmb_acntcd.refresh();
- cmb_acntcd.select(0);
- ]]>
- </script>
- </select1>
- <caption id="caption37" class="search_name" style="left:55px; top:10px; width:100px; height:17px; ">계정과목 :</caption>
- <input id="ipt_fromdd" ref="/root/send/condition/fromdd" class="input_s_essential" inputtype="date" style="left:545px; top:10px; width:95px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
-
- ]]>
- </script>
- </input>
- <caption id="cap_regno" class="search_name" style="left:445px; top:40px; width:104px; height:17px; ">사업자번호 :</caption>
- <input id="ipt_regnm" ref="/root/send/condition/custnm" navindex="6" imemode="hangul" style="left:662px; top:40px; width:158px; height:19px; ">
- <script type="javascript" ev:event="onkeypress">
- <![CDATA[
- if(event.keyCode == 13)
- {
- racfCustValidCheck("entrregno,custnm", "name");
- }
- ]]>
- </script>
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- racfCustValidCheck("entrregno,custnm", "name");
- ]]>
- </script>
- </input>
- <button id="btn_entregnohelp" class="icon_search" style="left:643px; top:41px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
-
- misfOpenPopUpList("14", ipt_regno, "", "entrregno,custnm");
- model.refresh();
-
- ]]>
- </script>
- </button>
- <input id="ipt_regno" ref="/root/send/condition/entrregno" navindex="5" format="999-99-99999" style="left:545px; top:40px; width:95px; height:19px; text-align:center; ">
- <script type="javascript" ev:event="onkeypress">
- <![CDATA[
- if(event.keyCode == 13)
- {
- racfCustValidCheck("entrregno,custnm", "code");
- }
- ]]>
- </script>
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- racfCustValidCheck("entrregno,custnm", "code");
- ]]>
- </script>
- </input>
- <input id="ipt_todd" ref="/root/send/condition/todd" class="input_s_essential" inputtype="date" style="left:662px; top:10px; width:95px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
-
- ]]>
- </script>
- </input>
- <caption id="caption6" style="left:644px; top:10px; width:20px; height:20px; ">~</caption>
- <select1 id="cmb_custflag" ref="/root/send/condition/custflag" class="combo_s_essential" navindex="1" appearance="minimal" style="left:156px; top:40px; width:274px; height:19px; text-align:center; ">
- <choices>
- <item>
- <label>전체</label>
- <value/>
- </item>
- <item>
- <label>거래처</label>
- <value>1</value>
- </item>
- <item>
- <label>부서</label>
- <value>3</value>
- </item>
- <item>
- <label>교직원</label>
- <value>4</value>
- </item>
- <item>
- <label>소득자</label>
- <value>5</value>
- </item>
- <item>
- <label>기타</label>
- <value>9</value>
- </item>
- </choices>
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
-
- if(model.getValue(cmb_custflag.attribute("ref")) == "1")
- {
- ipt_regno.disabled = false;
- btn_entregnohelp.disabled = false;
- ipt_regnm.disabled = false;
- }
- else
- {
- model.setValue(ipt_regno.attribute("ref"), "");
- model.setValue(ipt_regnm.attribute("ref"), "");
- ipt_regno.disabled = true;
- btn_entregnohelp.disabled = true;
- ipt_regnm.disabled = true;
- model.refresh();
- }
-
- ]]>
- </script>
- </select1>
- <caption id="caption3" class="search_name" style="left:55px; top:40px; width:100px; height:17px; ">상대처구분 :</caption>
- </group>
- <datagrid id="grd_settlebalancesheet" nodeset="/root/main/settlebalancesheet" backcoloralternate="#ffffff" caption="기관코드^회계년도^상대처구분^상대처코드^상대처명^매 입^지 출^기간 잔액^이월 잔액^전체 잔액" colsep="^" colwidth="0, 0, 150, 130, 220, 120, 120, 120, 120, 120" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:1px; top:120px; width:1193px; height:620px; font-size:10pt; ">
- <col ref="instcd" visibility="hidden"/>
- <col ref="acntyy" visibility="hidden"/>
- <col ref="custflag"/>
- <col ref="custcd" format="999-99-99999" style="text-align:center; vertical-align:middle; "/>
- <col ref="custnm" style="text-align:left; vertical-align:middle; padding-left:10; "/>
- <col ref="cramt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
- <col ref="dramt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
- <col ref="currbalamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
- <col ref="prevbalamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
- <col ref="totbalamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
- </datagrid>
- <caption id="caption2" class="tit_2" style="left:5px; top:101px; width:215px; height:13px; ">외상매입금 잔액 LIST</caption>
- <caption id="caption9" style="left:165px; top:100px; width:950px; height:20px; font-weight:bold; color:#0000ff; ">결산데이터를 합산합니다. 마이그레이션 시 거래처별 부채 정보가 없다면 이월잔액은 정확하지 않습니다.</caption>
- </group>
- <group id="grp_4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
- <line id="lin_2" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
- <button id="btn_11" class="btn6_letter2" visibility="hidden" style="left:0px; top:3px; width:56px; height:22px; ">
- <caption>출력</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
-
-
- ]]>
- </script>
- </button>
- <caption id="caption8" style="left:65px; top:5px; width:1110px; height:20px; font-weight:bold; color:#0000ff; ">조회조건의 두 일자가 같은 회계년도 내의 날짜로 조회하세요</caption>
- </group>
- <button id="btn_9" class="btn2_letter4" style="left:1130px; top:138px; width:64px; height:19px; text-align:left; ">
- <caption>엑셀출력</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- radfSaveExcel(grd_settlebalancesheet);
- ]]>
- </script>
- </button>
- </xhtml:body>
- </xhtml:html>
|