SMRPA02400_학력별분기별최고금액.xrw 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
  3. <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">
  4. <xhtml:head>
  5. <xhtml:title>학력별,분기별 최고금액</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <masterscholexp>
  11. <scholexplist>
  12. <emplno/>
  13. <emplnm/>
  14. <dutdeptnm/>
  15. <chldrnnm/>
  16. <payappmm/>
  17. <scholflagnm/>
  18. <schoolnm/>
  19. <schoolyy/>
  20. <scholexppayamt/>
  21. </scholexplist>
  22. </masterscholexp>
  23. <send>
  24. <payyy/>
  25. <qurtyy/>
  26. <payappmm_s/>
  27. <dutplceinst/>
  28. <payappmm_e/>
  29. <scholflag/>
  30. <selectinstnm/>
  31. <workgbn/>
  32. <schoolyy/>
  33. </send>
  34. <temp/>
  35. <init>
  36. <scholflaglist>
  37. <label>전체</label>
  38. <value/>
  39. <label>중학교</label>
  40. <value>02</value>
  41. <label>고등학교</label>
  42. <value>03</value>
  43. <label>대학교</label>
  44. <value>05</value>
  45. </scholflaglist>
  46. <workgbnlist>
  47. <label>전체</label>
  48. <value>01</value>
  49. <label>최고금액</label>
  50. <value>02</value>
  51. </workgbnlist>
  52. </init>
  53. </main>
  54. </root>
  55. </instance>
  56. <script type="javascript" ev:event="xforms-ready">
  57. <![CDATA[
  58. fInitialize()
  59. misfGridInit(grd_scholexplist);
  60. misfComboComCdList('Z0007', cmb_instcd_s,"Y");
  61. misfComboComCdList('R0165', ipt_schoolyy,"Y");
  62. var dutplceinstcd = getUserInfo("dutplceinstcd");
  63. cmb_instcd_s.value=dutplceinstcd;
  64. var curDate = getCurrentDate().toDate();
  65. var curyymm=curDate.getDateFormat('YYYYMM')
  66. model.setValue("/root/main/send/payyy", curDate.getDateFormat('YYYY'));
  67. ipt_payappmm_s.value=ipt_payappmm.value;
  68. ipt_payappmm_e.value=ipt_payappmm.value;
  69. cmb_workgbn.value='01';
  70. ]]>
  71. </script>
  72. <submission id="TRRPA02401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/main/send" resultref="/root/main/masterscholexp"/>
  73. </model>
  74. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  75. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  76. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  77. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  78. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  79. <script type="javascript" src="../../../mis/pubwelfmngtweb/js/RPS001.js"/>
  80. <script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
  81. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  82. <script type="javascript">
  83. <![CDATA[
  84. // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
  85. function fInitialize() {
  86. model.removeNodeset("/root/main/masterscholexp/scholexplist");
  87. model.removeNodeset("/root/main/gvnoffcorddetl/gvnoffcorddetllist");
  88. model.resetInstanceNode("/root/main/send");
  89. model.resetInstanceNode("/root/main/gvnoffcorddetldata/gvnoffcorddetllist");
  90. model.refresh();
  91. }
  92. function fDeleteSelectedRows(grd,markonly) {
  93. var rowIdx;
  94. if (grd.selectedRows > 0) {
  95. var selectedRows = Array(grd.selectedRows);
  96. for(i=0;i<grd.selectedRows;i++) {
  97. selectedRows[i] = grd.selectedRow(i);
  98. }
  99. if (markonly != null && markonly == true) { // mark delete
  100. for(i=selectedRows.length-1;i>=0;i--) {
  101. rowIdx = selectedRows[i];
  102. if(grd.rowstatus(rowIdx) == 1 ) { // just inserted row
  103. grd.deleterow(rowIdx,false);
  104. } else {
  105. grd.addStatus(rowIdx,"delete");
  106. }
  107. }
  108. } else {
  109. for(i=selectedRows.length-1;i>=0;i--) {
  110. rowIdx = selectedRows[i];
  111. grd.deleterow(rowIdx,false);
  112. }
  113. }
  114. }
  115. }
  116. function fPrint() {
  117. exeReportPreview("RPRPA02400", "XMLSTR", "/root/main/send");
  118. }
  119. ]]>
  120. </script>
  121. </xhtml:head>
  122. <xhtml:body guideline="1,1350;1,1349;" style="margin-left:8; margin-right:8; ">
  123. <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
  124. <caption id="caption6" class="tit_1" style="left:0px; top:5px; width:800px; height:13px; ">학력별,분기별 최고금액</caption>
  125. </group>
  126. <group id="group2" scroll="auto" style="left:0px; top:38px; width:1195px; height:744px; ">
  127. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1195px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
  128. <line id="line13" class="line_4" style="x1:1110px; y1:17px; x2:1110px; y2:39px; "/>
  129. <button id="button19" class="btn2_letter4" style="left:1131px; top:48px; width:64px; height:19px; ">
  130. <caption>엑셀저장</caption>
  131. <script type="javascript" ev:event="DOMActivate">
  132. <![CDATA[
  133. var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  134. if (fileName != "")
  135. {
  136. grd_scholexplist.saveExcel(fileName, "SheetName", true, true, "", "");
  137. }
  138. ]]>
  139. </script>
  140. </button>
  141. <caption id="caption14" class="tit_2" style="left:5px; top:54px; width:335px; height:13px; ">학력별,분기별 최고금액(특수목적학교,해외유학제외)</caption>
  142. <line id="line4" class="line_1" style="x1:0px; y1:69px; x2:1195px; y2:69px; "/>
  143. <datagrid id="grd_scholexplist" nodeset="/root/main/masterscholexp/scholexplist" caption="사원번호^사원명^근무기관^근무부서^자녀명^학력구분^학년^학과^학교명^금액" colsep="^" colwidth="118, 88, 128, 152, 110, 105, 47, 100, 181, 114" dataheight="25" ellipsis="true" explorerbar="sortshow" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" tooltip="true" style="left:0px; top:74px; width:1195px; height:660px; text-align:center; ">
  144. <col ref="emplno" style="text-align:center; "/>
  145. <col ref="emplnm" style="text-align:center; "/>
  146. <col ref="dutplceinst"/>
  147. <col ref="dutdeptnm"/>
  148. <col ref="chldrnnm" style="text-align:center; "/>
  149. <col ref="scholflagnm"/>
  150. <col ref="schoolyy" style="text-align:center; "/>
  151. <col ref="sbjnm"/>
  152. <col ref="schoolnm"/>
  153. <col ref="scholexppayamt" format="#,###" style="text-align:right; "/>
  154. </datagrid>
  155. <button id="btn_search" class="btn1_letter2" navindex="8" style="left:1125px; top:17px; width:56px; height:22px; text-align:left; ">
  156. <caption>조회</caption>
  157. <script type="javascript" ev:event="DOMActivate">
  158. <![CDATA[
  159. var payappmm=ipt_payappmm.value;
  160. if(payappmm =="") {
  161. messageBox("지급년월은","I003");
  162. return;
  163. }else if(cmb_qurtyy.value==""){
  164. messageBox("분기는","I003");
  165. return;
  166. }
  167. submit("TRRPA02401");
  168. ]]>
  169. </script>
  170. </button>
  171. <select1 id="cmb_instcd_s" ref="/root/main/send/dutplceinst" class="combo_default" appearance="minimal" style="left:100px; top:18; width:151px; height:19px; ">
  172. <choices>
  173. <itemset nodeset="/root/main/init">
  174. <label ref="cnstnm"/>
  175. <value ref="cnstcd"/>
  176. </itemset>
  177. </choices>
  178. </select1>
  179. <caption id="caption2" class="search_name" style="left:15px; top:19; width:85px; height:17px; ">기 관 :</caption>
  180. <select1 id="cmb_qurtyy" ref="/root/main/send/qurtyy" class="combo_default" appearance="minimal" style="left:516px; top:18px; width:85px; height:19px; ">
  181. <choices>
  182. <item>
  183. <label>1분기</label>
  184. <value>1</value>
  185. </item>
  186. <item>
  187. <label>2분기</label>
  188. <value>2</value>
  189. </item>
  190. <item>
  191. <label>3분기</label>
  192. <value>3</value>
  193. </item>
  194. <item>
  195. <label>4분기</label>
  196. <value>4</value>
  197. </item>
  198. </choices>
  199. <script type="javascript" ev:event="xforms-value-changed">
  200. <![CDATA[
  201. var qurtyy=cmb_qurtyy.value;
  202. if(qurtyy=='1'){
  203. ipt_payappmm_s.value=ipt_payappmm.value+"01";
  204. ipt_payappmm_e.value=ipt_payappmm.value+"03";
  205. }else if(qurtyy=='2'){
  206. ipt_payappmm_s.value=ipt_payappmm.value+"04";
  207. ipt_payappmm_e.value=ipt_payappmm.value+"06";
  208. }else if(qurtyy=='3'){
  209. ipt_payappmm_s.value=ipt_payappmm.value+"07";
  210. ipt_payappmm_e.value=ipt_payappmm.value+"09";
  211. }else if(qurtyy=='4'){
  212. ipt_payappmm_s.value=ipt_payappmm.value+"10";
  213. ipt_payappmm_e.value=ipt_payappmm.value+"12";
  214. }
  215. ]]>
  216. </script>
  217. </select1>
  218. <caption id="caption1" class="search_name" style="left:267px; top:19px; width:93px; height:17px; ">지급년도 :</caption>
  219. <caption id="caption3" class="search_name" style="left:447px; top:19px; width:86px; height:17px; ">분 기 :</caption>
  220. <input id="ipt_payappmm" ref="/root/main/send/payyy" class="input_s_essential" inputtype="date" format="yyyy" style="left:362px; top:18px; width:68px; height:19px; ">
  221. <script type="javascript" ev:event="xforms-value-changed">
  222. <![CDATA[
  223. ipt_payappmm_s.value=ipt_payappmm.value;
  224. ipt_payappmm_e.value=ipt_payappmm.value;
  225. var qurtyy=cmb_qurtyy.value;
  226. if(qurtyy=='1'){
  227. ipt_payappmm_s.value=ipt_payappmm.value+"01";
  228. ipt_payappmm_e.value=ipt_payappmm.value+"03";
  229. }else if(qurtyy=='2'){
  230. ipt_payappmm_s.value=ipt_payappmm.value+"04";
  231. ipt_payappmm_e.value=ipt_payappmm.value+"06";
  232. }else if(qurtyy=='3'){
  233. ipt_payappmm_s.value=ipt_payappmm.value+"07";
  234. ipt_payappmm_e.value=ipt_payappmm.value+"09";
  235. }else if(qurtyy=='4'){
  236. ipt_payappmm_s.value=ipt_payappmm.value+"10";
  237. ipt_payappmm_e.value=ipt_payappmm.value+"12";
  238. }
  239. var instcd = cmb_instcd_s.value;
  240. if( getStringLength(ipt_payappmm.value) == "4" ) {
  241. model.removeNodeset(cmb_instcd_s.attribute("ref"));
  242. model.makeNode("/root/main/send/dutplceinst");
  243. misfComboInstCdListMulti("cmb_instcd_s",ipt_payappmm.value,"","Y");
  244. cmb_instcd_s.value = instcd;
  245. model.refresh();
  246. }
  247. ]]>
  248. </script>
  249. </input>
  250. <input id="ipt_payappmm_s" ref="/root/main/send/payappmm_s" visibility="hidden" style="left:450px; top:40px; width:86px; height:19px; "/>
  251. <input id="ipt_payappmm_e" ref="/root/main/send/payappmm_e" visibility="hidden" style="left:360px; top:40px; width:86px; height:19px; "/>
  252. <select1 id="cmb_scholflag" ref="/root/main/send/scholflag" class="combo_default" appearance="minimal" style="left:675px; top:18px; width:105px; height:19px; ">
  253. <choices>
  254. <itemset nodeset="/root/main/init/scholflaglist">
  255. <label ref="label"/>
  256. <value ref="value"/>
  257. </itemset>
  258. </choices>
  259. </select1>
  260. <caption id="caption4" class="search_name" style="left:612px; top:19px; width:86px; height:17px; ">학력 :</caption>
  261. <caption id="caption5" class="search_name" style="left:917px; top:20px; width:86px; height:17px; ">조회구분 :</caption>
  262. <select1 id="cmb_workgbn" ref="/root/main/send/workgbn" class="combo_default" appearance="minimal" style="left:1005px; top:18px; width:75px; height:19px; ">
  263. <choices>
  264. <itemset nodeset="/root/main/init/workgbnlist">
  265. <label ref="label"/>
  266. <value ref="value"/>
  267. </itemset>
  268. </choices>
  269. </select1>
  270. <caption id="caption7" class="search_name" style="left:785px; top:20px; width:60px; height:17px; ">학년 :</caption>
  271. <select1 id="ipt_schoolyy" ref="/root/main/send/schoolyy" class="combo_default" appearance="minimal" style="left:845px; top:18px; width:55px; height:19px; ">
  272. <choices>
  273. <itemset>
  274. <label/>
  275. <value/>
  276. </itemset>
  277. </choices>
  278. </select1>
  279. </group>
  280. <group id="grp_btn" scroll="auto" style="left:0px; top:12px; width:1195px; height:27px; ">
  281. <button id="button9" class="btn3_letter4" visibility="hidden" style="left:58px; top:3px; width:80px; height:22px; ">
  282. <caption>화면이동</caption>
  283. </button>
  284. <line id="line11" class="line_6" style="x1:0; y1:25; x2:1195; y2:25; "/>
  285. <button id="button10" class="btn4_letter3" style="left:1127px; top:3px; width:68px; height:22px; ">
  286. <caption>초기화</caption>
  287. <script type="javascript" ev:event="DOMActivate">
  288. <![CDATA[
  289. var updtdata = getGridUpdateData(grd_scholexplist);
  290. if (updtdata != "" ) {
  291. var ret = messageBox("그리드에 작업 중인 내용이 있습니다. 초기화 작업을","Q003");
  292. if (ret != 6) { // not OK
  293. return;
  294. }
  295. }
  296. fInitialize();
  297. ]]>
  298. </script>
  299. </button>
  300. <button id="button1" class="btn6_letter2" visibility="hidden" style="left:0px; top:3px; width:56px; height:22px; ">
  301. <caption>출력</caption>
  302. <script type="javascript" ev:event="DOMActivate">
  303. <![CDATA[
  304. exeReportPreview("RPRPA02400", "XMLSTR", "", "", "", "true", "", "", "", "");
  305. ]]>
  306. </script>
  307. </button>
  308. <button id="button2" class="btn4_letter5" style="left:1033px; top:3px; width:92px; height:22px; ">
  309. <caption>내역서출력</caption>
  310. <script type="javascript" ev:event="DOMActivate">
  311. <![CDATA[
  312. fPrint();
  313. ]]>
  314. </script>
  315. </button>
  316. </group>
  317. </xhtml:body>
  318. </xhtml:html>