123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359 |
- <?xml version="1.0" encoding="EUC-KR"?>
- <?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.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>
- <list>
- <fixaset>
- <fixasetlist/>
- </fixaset>
- <fixasetmodel/>
- </list>
- <fixasetdet>
- <fixasettmplist/>
- </fixasetdet>
- </main>
- <send>
- <fixasetlist>
- <instcd_search/>
- <mngtdeptcd_search/>
- <mngtdeptnm_search/>
- <possnfrdd_search/>
- <possntodd_search/>
- <deptflag_search/>
- <mdlcd_search/>
- <smlcd_search/>
- <possndd_search/>
- <gubun_search/>
- </fixasetlist>
- </send>
- <init>
- <goodflag>
- <label>비품</label>
- <value>GE</value>
- <label>의료장비</label>
- <value>EQ</value>
- </goodflag>
- </init>
- <temp>
- <searchresult>
- <fixaset/>
- </searchresult>
- <fixcdinfo>
- <mdlcd/>
- <smlcd/>
- <possndd/>
- <gubun/>
- <mngtdeptcd/>
- <deptflag/>
- </fixcdinfo>
- </temp>
- </root>
- </instance>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- //화면 Control을 초기화한다
- fInitialize();
- ]]>
- </script>
- <submission id="TXRFC00919" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/fixasetlist" resultref="/root/temp"/>
- <submission id="TRRFC00919" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/fixasetlist" resultref="/root/main/list/fixaset"/>
- </model>
- <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" src="../../../mis/miscommonweb/js/RSZ001.js"/>
- <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
- <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
- <script type="javascript">
- <![CDATA[
- function fInitialize()
- {
- misfGridInit(grd_fixasetlist);
-
- misfComboComCdListMulti("C0048,R0480",
- "cmb_instcd_search,cmb_deptflag_search");
- addComboItem("cmb_deptflag_search", "전체", "", "above" );
- model.setValue("/root/send/fixasetlist/instcd_search", getUserInfo("dutplceinstcd")); // 기관 설정
- model.resetInstanceNode("/root/main/fixasetdet/fixasettmplist");
- model.resetInstanceNode("/root/main/list/fixasetdet/fixasettmplist");
-
- misfMsterDetailSet(grd_fixasetlist, null, "TRRFC00919", "Y" , "byrow");
-
- var curdate = getCurrentDate();
-
- model.setValue(ipt_possnfrdd_search.attribute("ref"),"20040101");
- model.setValue(ipt_possntodd_search.attribute("ref"),curdate);
-
- model.refresh();
-
- // makeReportPreview(0, 0, 1188, 550, "case_fixasetmodel");
- }
-
- function fDefaultSetting(prow)
- {
- model.setValue(grd_fixasetlist.nodeset +"[" + prow+ "]/instcd" ,model.getValue(cmb_instcd_search.attribute("ref")));
- model.setValue("/root/main/fixasetdet/fixasettmplist/instcd", model.getValue(cmb_instcd_search.attribute("ref"))); // 기관 설정
- model.setValue("/root/main/fixasetdet/fixasettmplist/goodqty", "1"); // 수량
- }
-
- function fDisableSetting() {
- var disValue = "";
- if(btn_fixasetlistcase.selected == true) {
- disValue = false;
- } else {
- disValue = true;
- }
-
- btn_excel.disabled = disValue;
- btn_print.disabled = disValue;
-
- model.refresh();
- }
-
- function fSubmitOnScroll() {
- if(grd_fixasetlist.vscroll.attribute("max") == grd_fixasetlist.vscroll.attribute("pos")) {
- // end of scroll
- model.makeValue("/root/send/fixasetlist/offset",grd_fixasetlist.rows-grd_fixasetlist.fixedRows); // grid의 header row는 제외
- submit("TRRFC00917");
- grd_fixasetlist.dispatch("onmouseup");
- }
- }
- ]]>
- </script>
- </xhtml:head>
- <xhtml:body pagewidth="1200" pageheight="800" guideline="1,-2;" 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:186px; height:15px; ">년도별 자산현황</caption>
- </group>
- <group id="group4" scroll="auto" style="left:0px; top:36px; width:1195px; height:738px; ">
- <group id="group5" style="left:0px; top:5px; width:1193px; height:70px; vertical-align:top; ">
- <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1190px; height:65px; background-color:#fffbf2; border-color:#ffd799; "/>
- <input id="ipt_mngtdeptcd_search" ref="/root/send/fixasetlist/mngtdeptcd_search" class="input_search" navindex="3" style="left:95px; top:33px; width:85px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- misfSearchDept(ipt_mngtdeptnm_search);
- ]]>
- </script>
- </input>
- <button id="btn_mngtdeptcd_search" class="icon_search" navindex="-1" style="left:184px; top:34px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- misfOpenPopUpList("02", ipt_mngtdeptcd_search,"","mngtdeptcd_search,mngtdeptnm_search");
- model.refresh();
- ]]>
- </script>
- </button>
- <input id="ipt_mngtdeptnm_search" ref="/root/send/fixasetlist/mngtdeptnm_search" class="input_search" navindex="4" appearance="input" style="left:203px; top:33px; width:197px; height:19px; ">
- <script type="javascript" ev:event="onkeyup">
- <![CDATA[
- inputEnterKey("btn_search", "DOMActivate");
- ]]>
- </script>
- </input>
- <caption id="cap_possndd_search" class="search_name" visibility="visible" style="left:507px; top:6px; width:94px; height:17px; ">취득일자 :</caption>
- <input id="ipt_possnfrdd_search" ref="/root/send/fixasetlist/possnfrdd_search" class="input_default" navindex="15" visibility="visible" inputtype="date" format="yyyy-mm-dd" style="left:597px; top:4px; width:90px; height:19px; text-align:center; "/>
- <button id="btn_search" class="btn1_letter2" navindex="20" style="left:1120px; top:26px; width:56px; height:22px; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var mngtdeptcd= model.getValue("/root/send/fixasetlist/mngtdeptcd_search");
- var deptflag = model.getValue("/root/send/fixasetlist/deptflag_search");
- if (mngtdeptcd == ""){
- model.setValue("/root/send/fixasetlist/mngtdeptcd_search",'%%');
- }
- if(deptflag == ""){
- model.setValue("/root/send/fixasetlist/deptflag_search",'%%');
- }
- misfGridInit(grd_fixasetlist);
- submit("TXRFC00919");
- submit("TRRFC00919"); //리스트 조회
-
- grd_fixasetlist.subtotalPosition = "below";
-
- grd_fixasetlist.subtotal("clear", -1, i, "format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#99ccff; font-weight:bold; text-align:center", 1, "총계" );
- for(var i=0; i < grd_fixasetlist.cols; i++){
- if(i >= grd_fixasetlist.colRef("com1_qty")){
- grd_fixasetlist.subtotal("sum", -1, i, "format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#99ccff; font-weight:bold; text-align:center", 1, "총계" );
- }
- }
-
- grd_fixasetlist.refresh();
- //
- if(grd_fixasetlist.rows - grd_fixasetlist.fixedRows > 0) {
- grd_fixasetlist.row = 1;
- grd_fixasetlist.dispatch("onrowchanged");
- }else{
- model.removenode("/root/main/fixasetdet/fixasettmplist");
- }
-
- ]]>
- </script>
- </button>
- <caption id="cap_instcd_search" class="search_name" style="left:3px; top:6px; width:117px; height:17px; ">기관코드 :</caption>
- <select1 id="cmb_instcd_search" ref="/root/send/fixasetlist/instcd_search" class="combo_s_essential" disabled="true" navindex="1" appearance="minimal" style="left:95px; top:4px; width:195px; height:19px; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <line id="line12" class="line_4" style="x1:1105px; y1:13px; x2:1105px; y2:59px; border-color:#ffd799; "/>
- <input id="ipt_possntodd_search" ref="/root/send/fixasetlist/possntodd_search" class="input_default" navindex="16" visibility="visible" inputtype="date" format="yyyy-mm-dd" style="left:704px; top:4px; width:90px; height:19px; text-align:center; "/>
- <caption id="caption2" visibility="visible" style="left:689px; top:5px; width:15px; height:20px; font-weight:bold; ">~</caption>
- <caption id="cap_installplcecd" class="search_name" style="left:3px; top:32px; width:92px; height:17px; ">운용부서 :</caption>
- <select1 id="cmb_deptflag_search" ref="/root/send/fixasetlist/deptflag_search" navindex="19" visibility="visible" appearance="minimal" style="left:937px; top:4px; width:80px; height:19px; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- </select1>
- <caption id="caption1" class="search_name" style="left:847px; top:6px; width:116px; height:17px; ">부서구분 :</caption>
- </group>
- <button id="btn_excel" class="btn5_letter5" navindex="21" style="left:1114px; top:74px; width:75px; height:19px; ">
- <caption>Excel 저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- if( grd_fixasetlist.rows - grd_fixasetlist.fixedRows > 0 ) {
- var fileName = "년도별 자산현황_" + getCurrentDate();
- var fileName = window.fileDialog("save", ",", false, fileName, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
- grd_fixasetlist.saveExcel(fileName, "Sheet");
- } else {
- messageBox("저장 데이터가","I004");
- }
- ]]>
- </script>
- </button>
- <line id="line16" class="line_1" style="x1:0px; y1:158px; x2:1190px; y2:157px; "/>
- <switch id="switch1" style="left:0px; top:95px; width:1190px; height:630px; ">
- <case id="case_fixasetlist">
- <datagrid id="grd_fixasetlist" nodeset="/root/main/list/fixaset/fixasetlist" class="datagrid2" caption="년도/분류^컴퓨터^컴퓨터^컴퓨터^컴퓨터^컴퓨터^컴퓨터^모니터^모니터^모니터^모니터^모니터^프린터^프린터^프린터^프린터^프린터|년도/분류^정리^정리^정리^미비^노트북^계^정리^정리^정리^미비^계^정리^정리^정리^미비^계|년도/분류^10.01(정상)^10.05(기금)^10.91(CDIS)^03.11^노트북^계^10.02(정상)^10.05(기금)^10.91(CDIS)^03.26^계^10.03(정상)^10.05(기금)^10.91(CDIS)^03.09^계" colsep="^" colwidth="70,70, 70, 75, 60, 45, 60, 70, 70, 75, 60, 60, 70, 70, 75, 60, 60" ellipsis="true" explorerbar="sortshow" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" selectionmode="byrow" navindex="22" style="left:0px; top:0px; width:1152px; height:625px; ">
- <col ref="year" style="height:35; text-align:center; "/>
- <col ref="com1_qty" style="text-align:center; "/>
- <col ref="com2_qty" style="text-align:center; "/>
- <col ref="com3_qty" style="text-align:center; "/>
- <col ref="com4_qty" style="text-align:center; "/>
- <col ref="com5_qty" style="text-align:center; "/>
- <col ref="comt_qty" format="#,###" style="text-align:center; "/>
- <col ref="mon1_qty" style="text-align:center; "/>
- <col ref="mon2_qty" style="text-align:center; "/>
- <col ref="mon3_qty" style="text-align:center; "/>
- <col ref="mon4_qty" style="text-align:center; "/>
- <col ref="mont_qty" format="#,###" style="text-align:center; "/>
- <col ref="prt1_qty" style="text-align:center; "/>
- <col ref="prt2_qty" style="text-align:center; "/>
- <col ref="prt3_qty" style="text-align:center; "/>
- <col ref="prt4_qty" style="text-align:center; "/>
- <col ref="prtt_qty" format="#,###" style="text-align:center; "/>
- <script type="javascript" ev:event="onaftersort">
- <![CDATA[
- grd_fixasetlist.gridToInstance();
- ]]>
- </script>
- <script type="javascript" ev:event="onentercell">
- <![CDATA[
- for ( i=0; i<grd_fixasetlist.selectedRows; i++ ) {
- var col = grd_fixasetlist.col;
- // var row = grd_fixasetlist.row;
- if(col == 2){ // 컴퓨터 정리 정상
- model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
- model.setValue("/root/send/fixasetlist/smlcd_search", "01");
- model.setValue("/root/send/fixasetlist/gubun_search", "컴퓨터");
-
- }else if(col == 3){
- model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
- model.setValue("/root/send/fixasetlist/smlcd_search", "05");
- model.setValue("/root/send/fixasetlist/gubun_search", "컴퓨터");
- }else if(col == 4){
- model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
- model.setValue("/root/send/fixasetlist/smlcd_search", "91");
- model.setValue("/root/send/fixasetlist/gubun_search", "컴퓨터");
- }else if(col == 5){
- model.setValue("/root/send/fixasetlist/mdlcd_search", "03");
- model.setValue("/root/send/fixasetlist/smlcd_search", "11");
- model.setValue("/root/send/fixasetlist/gubun_search", "컴퓨터");
- }else if(col == 6){
- model.setValue("/root/send/fixasetlist/mdlcd_search", "03");
- model.setValue("/root/send/fixasetlist/smlcd_search", "37");
- model.setValue("/root/send/fixasetlist/gubun_search", "노트북");
- }else if(col == 7){
- model.setValue("/root/send/fixasetlist/mdlcd_search", "");
- model.setValue("/root/send/fixasetlist/smlcd_search", "");
- }else if(col == 8){
- model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
- model.setValue("/root/send/fixasetlist/smlcd_search", "02");
- model.setValue("/root/send/fixasetlist/gubun_search", "모니터");
- }else if(col == 9){
- model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
- model.setValue("/root/send/fixasetlist/smlcd_search", "05");
- model.setValue("/root/send/fixasetlist/gubun_search", "모니터");
- }else if(col == 10){
- model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
- model.setValue("/root/send/fixasetlist/smlcd_search", "91");
- model.setValue("/root/send/fixasetlist/gubun_search", "모니터");
- }else if(col == 11){
- model.setValue("/root/send/fixasetlist/mdlcd_search", "03");
- model.setValue("/root/send/fixasetlist/smlcd_search", "26");
- model.setValue("/root/send/fixasetlist/gubun_search", "모니터");
- }else if(col == 12){
- model.setValue("/root/send/fixasetlist/mdlcd_search", "");
- model.setValue("/root/send/fixasetlist/smlcd_search", "");
- }else if(col == 13){
- model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
- model.setValue("/root/send/fixasetlist/smlcd_search", "03");
- model.setValue("/root/send/fixasetlist/gubun_search", "프린터");
- }else if(col == 14){
- model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
- model.setValue("/root/send/fixasetlist/smlcd_search", "05");
- model.setValue("/root/send/fixasetlist/gubun_search", "프린터");
- }else if(col == 15){
- model.setValue("/root/send/fixasetlist/mdlcd_search", "10");
- model.setValue("/root/send/fixasetlist/smlcd_search", "91");
- model.setValue("/root/send/fixasetlist/gubun_search", "프린터");
- }else if(col == 16){
- model.setValue("/root/send/fixasetlist/mdlcd_search", "03");
- model.setValue("/root/send/fixasetlist/smlcd_search", "09");
- model.setValue("/root/send/fixasetlist/gubun_search", "프린터");
- }
- // var mdlcd = model.getValue("/root/temp/fixcdinfo/mdlcd");
- // var smlcd = model.getValue("/root/temp/fixcdinfo/smlcd");
- var tt = parseInt(grd_fixasetlist.selectedRow(i))-2;
- var yeardd = model.getValue("/root/main/list/fixaset/fixasetlist["+ tt +"]/year");
-
- }
- model.setValue("/root/send/fixasetlist/possndd_search" , yeardd);
- // model.setValue("/root/temp/fixcdinfo/mngtdeptcd" , model.getValue("/root/send/fixasetlist/mngtdeptcd_search"));
- // model.setValue("/root/temp/fixcdinfo/deptflag" , model.getValue("/root/send/fixasetlist/deptflag_search"));
- window.load("SPRSD00919.xrw", "modal","", "", "/root/send/fixasetlist","/root/send/fixasetlist");
- //modal("SPRSD00919", 1, 0, 0 ,"SPRSD00919","/root/temp/fixcdinfo","/root/temp/fixcdinfo");
- ]]>
- </script>
- </datagrid>
- </case>
- <case id="case_fixasetmodel"/>
- </switch>
- </group>
- <group id="group1" style="left:0px; top:12; width:1195; height:27px; ">
- <button id="btn_init" class="btn4_letter3" navindex="24" style="left:1120px; top:4px; width:68px; height:22px; ">
- <caption>초기화</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- model.resetInstanceNode("/root/send");
- fInitialize();
- ]]>
- </script>
- </button>
- <line id="line14" class="line_6" style="x1:0; y1:25; x2:1194; y2:25; "/>
- </group>
- </xhtml:body>
- </xhtml:html>
|