123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406 |
- <?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>외상매입금 잔액 LIST</xhtml:title>
- <model id="model1">
- <instance id="instance1">
- <root xmlns="">
- <main>
- <balancesheet/>
- </main>
- <send>
- <condition>
- <instcd/>
- <acntcd4/>
- <acntcd/>
- <balamtflag>Y</balamtflag>
- <slipdeptcd/>
- <slipdepthngnm/>
- <costcntrdeptcd/>
- <costcntrdepthngnm/>
- <entrregno/>
- <custnm/>
- <fromdd/>
- <todd/>
- <seqflag>custcd</seqflag>
- <printflag/>
- </condition>
- <data>
- <instcd/>
- <mngtcd/>
- </data>
- <retrparams>
- <frdate/>
- <todate/>
- <acntnm4/>
- <acntnm/>
- <slipdeptcd/>
- <slipdepthngnm/>
- </retrparams>
- </send>
- <init>
- <code>
- <code>
- <acnt4/>
- </code>
- </code>
- </init>
- <temp/>
- <hidden>
- <balancesheet/>
- </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="TRRAD00321" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition" resultref="/root/main/balancesheet"/>
- <submission id="TRRAD00322" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition" resultref="/root/hidden/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:18px; width:56px; height:22px; text-align:left; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- radfRenewalBebtClos(getUserInfo("dutplceinstcd"), '', model.getValue(ipt_fromdd.attribute("ref")));
- submit("TRRAD00321");
- ]]>
- </script>
- </button>
- <line id="lin_5" class="line_4" style="x1:1107px; y1:18px; x2:1107px; y2:40px; border-color:#ffe4bb; border-left-style:solid; "/>
- <caption id="caption1" class="search_name" style="left:790px; 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:885px; top:10px; width:90px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
-
- ]]>
- </script>
- </input>
- <select1 id="rdo_balamtflag" ref="/root/send/condition/balamtflag" disabled="false" navindex="-1" appearance="full" cellspacing="75" cols="2" style="left:885px; top:35px; width:163px; height:17px; border-style:none; ">
- <choices>
- <item>
- <label>포함</label>
- <value>Y</value>
- </item>
- <item>
- <label>제외</label>
- <value>N</value>
- </item>
- </choices>
- </select1>
- <caption id="caption3" class="search_name" style="left:790px; top:35px; width:90px; height:17px; ">잔액없음 :</caption>
- <caption id="caption5" class="search_name" style="left:55px; top:35px; width:104px; height:17px; ">사업자번호 :</caption>
- <input id="ipt_regnm" ref="/root/send/condition/custnm" navindex="6" imemode="hangul" style="left:272px; top:35px; 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:254px; top:35px; 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:155px; top:35px; 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>
- <button id="btn_slipdepthelp" class="icon_search" navindex="-1" style="left:614px; top:9px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
-
- fOpenPopupDeptHelp(ipt_slipdeptcd, "slipdeptcd,slipdepthngnm"); //전체부서
- ]]>
- </script>
- </button>
- <button id="btn_costcntrdepthelp" class="icon_search" navindex="-1" style="left:614px; top:34px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
-
- fOpenPopupDeptHelp(ipt_costcntrdeptcd, "costcntrdeptcd,costcntrdepthngnm"); //전체부서
- ]]>
- </script>
- </button>
- <caption id="caption12" class="search_name" style="left:445px; top:10px; width:107px; height:17px; ">발의부서 :</caption>
- <caption id="caption13" class="search_name" style="left:445px; top:35px; width:107px; height:17px; ">귀속부서 :</caption>
- <input id="ipt_slipdeptcd" ref="/root/send/condition/slipdeptcd" class="input_essential" navindex="-1" maxlength="11" style="left:535px; top:8px; width:74px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
-
- racfDeptValidCheck("slipdeptcd,slipdepthngnm"); // 전체부서
-
- ]]>
- </script>
- <script type="javascript" ev:event="onkeypress">
- <![CDATA[
- if(event.keyCode == 13)
- {
- model.setFocus("btn_search");
- }
- ]]>
- </script>
- </input>
- <input id="ipt_costcntrdeptcd" ref="/root/send/condition/costcntrdeptcd" class="input_essential" navindex="-1" maxlength="11" style="left:535px; top:33px; width:74px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
-
- racfDeptValidCheck("costcntrdeptcd,costcntrdepthngnm"); // 전체부서
-
- ]]>
- </script>
- <script type="javascript" ev:event="onkeypress">
- <![CDATA[
- if(event.keyCode == 13)
- {
- model.setFocus("btn_search");
- }
- ]]>
- </script>
- </input>
- <input id="ipt_costcntrdepthngnm" ref="/root/send/condition/costcntrdepthngnm" class="input_essential" style="left:634px; top:33px; width:135px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
-
- racfDeptValidCheck("costcntrdeptcd,costcntrdepthngnm"); // 전체부서
-
- ]]>
- </script>
- <script type="javascript" ev:event="onkeypress">
- <![CDATA[
- if(event.keyCode == 13)
- {
- model.setFocus("btn_search");
- }
- ]]>
- </script>
- </input>
- <input id="ipt_slipdepthngnm" ref="/root/send/condition/slipdepthngnm" class="input_essential" style="left:634px; top:8px; width:135px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
-
- racfDeptValidCheck("slipdeptcd,slipdepthngnm"); // 전체부서
-
- ]]>
- </script>
- <script type="javascript" ev:event="onkeypress">
- <![CDATA[
- if(event.keyCode == 13)
- {
- model.setFocus("btn_search");
- }
- ]]>
- </script>
- </input>
- <input id="ipt_todd" ref="/root/send/condition/todd" class="input_s_essential" inputtype="date" style="left:997px; top:10px; width:90px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
-
- ]]>
- </script>
- </input>
- <caption id="caption6" style="left:980px; top:10px; width:20px; height:20px; ">~</caption>
- <caption id="caption7" class="search_name" style="left:790px; top:60px; width:90px; height:17px; ">정렬기준 :</caption>
- <select1 id="rdo_seqflag" ref="/root/send/condition/seqflag" disabled="false" navindex="-1" appearance="full" cellspacing="15" cols="2" style="left:885px; top:60px; width:215px; height:17px; border-style:none; ">
- <choices>
- <item>
- <label>사업자등록번호</label>
- <value>custcd</value>
- </item>
- <item>
- <label>거래처명</label>
- <value>custnm</value>
- </item>
- </choices>
- </select1>
- </group>
- <datagrid id="grd_balancesheet" nodeset="/root/main/balancesheet" backcoloralternate="#ffffff" caption="기관코드^회계년도^사업자등록번호^상 호^이월잔액^매 입^지 출^잔 액^비 고" colsep="^" colwidth="0, 0, 120, 330, 150, 150, 150, 150, 90" 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="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="prevbalamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
- <col ref="cramt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
- <col ref="dramt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
- <col ref="balamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
- <col ref="cmt"/>
- </datagrid>
- <caption id="caption2" class="tit_2" style="left:5px; top:101px; width:215px; height:13px; ">외상매입금 잔액 LIST</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="visible" style="left:0px; top:3px; width:56px; height:22px; ">
- <caption>출력</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- radfRenewalBebtClos(getUserInfo("dutplceinstcd"), '', model.getValue(ipt_fromdd.attribute("ref")));
- submit("TRRAD00322");
-
- if(instance1.selectNodes("/root/hidden/balancesheet").length == 0)
- {
- messageBox("출력할 내용이" ,"I004");
- return;
- }
- model.setValue("/root/send/retrparams/frdate", ipt_fromdd.value);
- model.setValue("/root/send/retrparams/todate", ipt_todd.value);
-
- model.setValue("/root/send/retrparams/acntnm4", cmb_supacntcd4.label);
- model.setValue("/root/send/retrparams/acntnm", cmb_acntcd.label);
-
- model.setValue("/root/send/retrparams/slipdeptcd", ipt_slipdeptcd.value);
- model.setValue("/root/send/retrparams/slipdepthngnm", ipt_slipdepthngnm.value);
-
- exeReportPreview("RPRAD00320", "XMLSTR", "/root/send/retrparams");
-
- ]]>
- </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_balancesheet);
- ]]>
- </script>
- </button>
- </xhtml:body>
- </xhtml:html>
|