123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186 |
- <?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>매각자산현황</xhtml:title>
- <model id="model1">
- <instance id="instance1">
- <root xmlns="">
- <main>
- <list>
- <detailist/>
- </list>
- </main>
- <send>
- <condition>
- <instcd/>
- <frdt/>
- <todt/>
- <repayflag/>
- </condition>
- </send>
- <init/>
- <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="../../../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/miscommonweb/js/RSZ001.js"/>
- <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- fOpenForm();
- //sCdGrupid = model.getValue("/root/init/comcode/cdgrupid");
- ]]>
- </script>
- <script type="javascript">
- <![CDATA[
-
- //========================================================================================
- //화면 로드시 초기화 함수
- //========================================================================================
- function fOpenForm() {
-
- //model.removenode("/root/main/notelist");
-
- var sToday = getCurrentDate().toString();
- var sFrday = sToday.substring(0,4) + "0301";
-
-
- model.setValue("/root/send/condition/todt",sToday);
- model.setValue("/root/send/condition/frdt",sFrday);
- var instcd = getUserInfo("dutplceinstcd");
- model.setValue("/root/send/condition/instcd",instcd);
- //misfComboComCdListMulti("R0025", "cmb_goodflag_search");
- // misfComboComCdListMulti("R0044", "cmb_goodflag_search");
-
- model.refresh();
-
- }
-
- //========================================================================================
- //관리대장 조회
- //========================================================================================
- function fRetrieve()
- {
-
-
- model.reset("/root/main/list/detailist");
- model.resetInstanceNode("/root/main/list/detailist");
- model.removenode("/root/main/list/detailist");
- model.refresh();
-
- submit("TRRAA00701");
-
- datagrid11.subtotalposition="below";
- datagrid11.multitotals=true;
- datagrid11.subtotal("sum", 1, 10, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 2, "합계", false);
- datagrid11.subtotal("sum", 1, 11, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 2, "합계", false);
- datagrid11.subtotal("sum", 1, 12, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 2, "합계", false);
- datagrid11.subtotal("sum", 1, 13, "format:#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 2, "합계", false);
- datagrid11.subtotal("sum", 1, 14, "format:(-)#,###; roundmode:round; roundpostion:2", "background-color:#ffff00; color:#0000ff; font-weight:bold; ", 2, "합계", false);
- model.refresh();
-
- }
-
-
- //========================================================================================
- //엑셀입력(excel file을 그리드에 입력)
- //========================================================================================
- function fInputExcel(pGrid) {
- var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
- if(fileName != "") {
- pGrid.loadExcel(fileName, 1, true);
- pGrid.deleteRow(1);
-
- for(i = 1; i < pGrid.rows; i++) {
- pGrid.rowStatus(i) = 1;
- }
- pGrid.refresh();
- }
- }
- ]]>
- </script>
- <submission id="TRRAA00701" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/detailist"/>
- </model>
- </xhtml:head>
- <xhtml:body guideline="1,1195;1,23;" 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:293px; height:14px; ">매각자산 현황</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:20px; width:1195px; height:730px; ">
- <line id="line3" class="line_1" style="x1:0px; y1:100px; x2:1195px; y2:100px; "/>
- <caption id="caption21" class="tit_2" style="left:5px; top:80px; width:134px; height:14px; ">매각자산현황</caption>
- <button id="btn_excadd" class="btn2_letter4" style="left:1115px; top:50px; width:64px; height:19px; text-align:left; ">
- <caption>엑셀입력</caption>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- fInputExcel(grd_notelist);
- ]]>
- </script>
- </button>
- <upload id="upload1" style="left:735px; top:415px; width:100px; height:20px; "/>
- <group id="group4" style="left:0px; top:10px; width:1195px; height:60px; vertical-align:top; ">
- <shape id="roundrect2" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:55px; background-color:#fffbf2; border-color:#ffd799; "/>
- <button id="btn_search" class="btn1_letter2" navindex="16" style="left:1124; top:19px; width:56px; height:22px; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- fRetrieve();
- ]]>
- </script>
- </button>
- <line id="line30" class="line_4" style="x1:1109; y1:8px; x2:1109; y2:51px; "/>
- <caption id="cap_goodflag_search" class="search_name" visibility="hidden" style="left:365px; top:20px; width:112px; height:17px; ">상태구분 :</caption>
- <caption id="caption2" class="search_name" style="left:15px; top:20px; width:91px; height:17px; ">매각 기간 :</caption>
- <select1 id="cmb_goodflag_search" ref="/root/send/condition/repayflag" class="combo_default" navindex="1" visibility="hidden" appearance="minimal" style="left:485px; top:20px; width:210px; height:19px; ">
- <choices>
- <itemset nodeset="/root/init/goodflag">
- <label ref="label"/>
- <value ref="value"/>
- </itemset>
- </choices>
- </select1>
- <caption id="caption7" style="left:213px; top:20px; width:15px; height:20px; ">~</caption>
- <input id="input2" ref="/root/send/condition/frdt" class="input_s_essential" inputtype="date" style="left:109px; top:20px; width:100px; height:19px; "/>
- <input id="input3" ref="/root/send/condition/todt" class="input_s_essential" inputtype="date" style="left:226px; top:20px; width:100px; height:19px; "/>
- </group>
- <datagrid id="datagrid11" nodeset="/root/main/list/detailist" caption="기관코드^자산분류^코드^자산명^수량^내용년수^취득일^처분일^처분구분^취득금액^감가상각충당금^미상각잔액^매각금액^차액" colsep="^" colwidth="0, 75, 0, 243, 39, 63, 77, 80, 64, 100, 100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:2px; top:110px; width:1183px; height:580px; ">
- <col ref="instcd" style="text-align:left; "/>
- <col ref="acntnm" style="text-align:left; "/>
- <col ref="fixasetcd" style="text-align:left; "/>
- <col ref="goodflaghngnm" style="text-align:left; "/>
- <col ref="goodqty" style="text-align:left; "/>
- <col ref="cntsyearno" style="text-align:left; "/>
- <col ref="possndd" format="yyyy-mm-dd" style="text-align:left; "/>
- <col ref="saledd" format="yyyy-mm-dd" style="text-align:left; "/>
- <col ref="saleflag" style="text-align:left; "/>
- <col ref="possnamt" format="#,###" style="text-align:right; "/>
- <col ref="redurepayamt" format="#,###" style="text-align:right; "/>
- <col ref="notdpramt" format="#,###" style="text-align:right; "/>
- <col ref="saleamt" format="#,###" style="text-align:right; "/>
- <col ref="diffamt" format="(-)#,###" style="text-align:right; "/>
- </datagrid>
- <button id="btn_excel" class="btn2_letter4" navindex="10" style="left:1115px; top:75px; width:64px; height:19px; text-align:left; ">
- <caption>엑셀출력</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- misfSaveExcel(datagrid11);
- ]]>
- </script>
- </button>
- </group>
- </xhtml:body>
- </xhtml:html>
|