123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175 |
- <?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>
- <list>
- <item>
- <emplno/>
- <name/>
- <dutplcedeptnm/>
- <deptnm/>
- <instnm/>
- <count/>
- <amount/>
- </item>
- </list>
- </main>
- <send>
- <fromdd/>
- <todd/>
- <fromdd2/>
- <todd2/>
- <globalinstance>
- <instance1/>
- </globalinstance>
- </send>
- <hidden/>
- </root>
- </instance>
- <script type="javascript" src="../../../com/commonweb/js/common.js"/>
- <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- var fromdd = getCurrentDate().substring(0, 6) + '0100'; // 적용일자 현재일자 셋팅
- var todd = getCurrentDate().substring(0, 6) + '3199'; // 적용일자 현재일자 셋팅
- model.removenode("/root/main/list/item");
- model.setValue("/root/send/fromdd", fromdd);
- model.setValue("/root/send/todd", todd);
-
- model.refresh();
- ]]>
- </script>
- <submission id="TRANS02001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/list"/>
- </model>
- </xhtml:head>
- <xhtml:body pagewidth="1211" pageheight="784" 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:209px; height:14px; ">중.야식 통합식수현황</caption>
- </group>
- <group id="grp_biz" scroll="auto" style="left:0px; top:13px; width:1195px; height:744px; ">
- <caption id="caption1" class="tit_2" style="left:5px; top:50px; width:200px; height:14px; ">월별 통합식수 리스트</caption>
- <line id="line1" class="line_1" style="x1:0px; y1:65px; x2:1183px; y2:65px; "/>
- <group id="grp_sea" style="left:0px; top:10px; width:1195px; height:30px; vertical-align:top; ">
- <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1193px; height:30px; background-color:#fffbf2; border-color:#ffd799; "/>
- <caption id="caption2" class="search_name" style="left:15px; top:7px; width:86px; height:17px; ">조회기간 :</caption>
- <line id="line13" class="line_4" style="x1:1110px; y1:4px; x2:1110px; y2:26px; "/>
- <button id="btn_sea" class="btn1_letter2" navindex="4" style="left:1120px; top:4px; width:56px; height:22px; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- if (model.getValue("/root/send/fromdd") == ""){
- messageBox("조회시작일자는", "I003");
- model.setFocus("ipt_fromdd");
- return;
- }
- if (model.getValue("/root/send/todd") == ""){
- messageBox("조회종료일자는", "I003");
- model.setFocus("ipt_todd");
- return;
- }
- if (model.getValue("/root/send/fromdd") > model.getValue("/root/send/todd")){
- messageBox("조회 시작일자는 종료일자 보다 클 수", "I004");
- model.setFocus("ipt_fromdd");
- return;
- }
- var fromdd = model.getValue("/root/send/fromdd"); // 적용일자 현재일자 셋팅
- var todd = model.getValue("/root/send/fromdd") ; // 적용일자 현재일자 셋팅
- var fromdd2 = fromdd.substring(0,6) + '010000';
- var todd2 = fromdd.substring(0,6) + '010000';
- model.setValue("/root/send/fromdd2", fromdd2);
- model.setValue("/root/send/todd2", todd2);
-
- submit("TRANS02001");
- grd_sicksulist.subtotalPosition = "below";
-
- grd_sicksulist.subtotal("clear", -1, i, "format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#99ff99; font-weight:bold; text-align:center", 2, "총계" );
- for(var i=0; i < grd_sicksulist.cols; i++){
- if(i >= grd_sicksulist.colRef("count")){
- grd_sicksulist.subtotal("sum", -1, i, "format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#99ff99; font-weight:bold; text-align:center", 2, "총계" );
- }
- }
-
- grd_sicksulist.refresh();
- ]]>
- </script>
- </button>
- <input id="ipt_todd" ref="/root/send/todd" class="input_default" navindex="2" visibility="hidden" inputtype="date" format="yyyy-mm" style="left:402px; top:6px; width:85px; height:19px; "/>
- <input id="ipt_fromdd" ref="/root/send/fromdd" format="yyyy-mm" style="left:106px; top:6px; width:85px; height:19px; text-align:center; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- var fromdd = model.getValue("/root/send/fromdd");
- var temp1 = fromdd+ '0100';
- var temp2 = fromdd+ '3199';
- model.setValue("/root/send/fromdd", temp1);
- model.setValue("/root/send/todd" , temp2);
- model.refresh();
- ]]>
- </script>
- </input>
- <button id="btn_next" class="icon_next" style="left:208px; top:8px; width:13px; height:15px; ">
- <caption/>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- var dd = model.getValue("/root/send/fromdd") + "01";
- dd = dd.toDate().getAddDate(1, "M");
- var dd1 = dd.getDateFormat("YYYYMM") + '0100';
- var dd2 = dd.getDateFormat("YYYYMM") + '3199';
- model.setValue("/root/send/fromdd", dd1);
- model.setValue("/root/send/todd" , dd2);
- model.refresh();
- ]]>
- </script>
- </button>
- <button id="btn_before" class="icon_pre" style="left:193px; top:8px; width:13px; height:15px; ">
- <caption/>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- var dd = model.getValue("/root/send/fromdd") + "01";
- dd = dd.toDate().getAddDate(-1, "M");
- var dd1 = dd.getDateFormat("YYYYMM")+ '0100';
- var dd2 = dd.getDateFormat("YYYYMM") + '3199';
- model.setValue("/root/send/fromdd", dd1);
- model.setValue("/root/send/todd" , dd2);
- model.refresh();
- ]]>
- </script>
- </button>
- </group>
- <button id="btn_excsave" class="btn2_letter4" style="left:1120px; top:45px; width:64px; height:19px; ">
- <caption>엑셀저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var fileName = window.fileDialog("save", ",", false, "", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
- if (fileName != "") {
- grd_sicksulist.saveExcel(fileName);
- }
- ]]>
- </script>
- </button>
- <datagrid id="grd_sicksulist" nodeset="/root/main/list/item" class="datagrid2" caption="사번^성명^본원부서^칠곡부서^소속^사용수^총금액" colsep="^" colwidth="70, 100, 300, 300, 100, 100, 100" explorerbar="sortshow" frozencols="7" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" selectionmode="free" style="left:0px; top:71px; width:1183px; height:669px; ">
- <col disabled="true" ref="emplno" style="text-align:center; "/>
- <col disabled="true" ref="name" style="text-align:center; "/>
- <col disabled="true" ref="dutplcedeptnm" style="text-align:center; "/>
- <col disabled="true" ref="deptnm" style="text-align:center; "/>
- <col disabled="true" ref="instnm" style="text-align:center; "/>
- <col disabled="true" ref="count" format="#,###" style="text-align:center; "/>
- <col disabled="true" ref="amount" format="#,###" style="text-align:center; "/>
- <script type="javascript" ev:event="onaftersort">
- <![CDATA[
- grd_sicksulist.gridtoinstance();
- ]]>
- </script>
- </datagrid>
- </group>
- </xhtml:body>
- </xhtml:html>
|