SMAAA03300_학생봉사자통계.xrw 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.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. <cond>
  11. <year/>
  12. <vacflag/>
  13. </cond>
  14. <studvoluntr>
  15. <studsch>
  16. <schnm/>
  17. <man/>
  18. <woman/>
  19. <psnsum/>
  20. <servtm/>
  21. <percent/>
  22. <tot/>
  23. </studsch>
  24. <studdept>
  25. <vacatflag/>
  26. <actdeptcd/>
  27. <voluntractteamcd/>
  28. <psn/>
  29. <servtm/>
  30. <percent/>
  31. </studdept>
  32. </studvoluntr>
  33. </main>
  34. <init>
  35. <vacatflagcd>
  36. </vacatflagcd>
  37. <actdeptcd/>
  38. <voluntractteamcd/>
  39. </init>
  40. <send>
  41. <reqdata/>
  42. </send>
  43. <hidden>
  44. <excelflag/>
  45. </hidden>
  46. </root>
  47. </instance>
  48. <script type="javascript" ev:event="xforms-ready">
  49. <![CDATA[
  50. //grd_studvoluntrlist.fixedcellcheckbox(0,1) = "true";
  51. fInit();
  52. ]]>
  53. </script>
  54. <submission id="TRZBC00101" mediatype="application/x-www-form-urlencoded" method="post"/>
  55. <submission id="TRAAA03301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/reqdata" resultref="/root/main/studvoluntr"/>
  56. </model>
  57. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  58. <script type="javascript" src="../../../com/commonweb/js/utilHelper.js"/>
  59. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  60. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  61. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  62. <script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
  63. <script type="javascript" src="../../../com/zipcodeweb/js/ZBP001.js"/>
  64. </xhtml:head>
  65. <script type="javascript">
  66. <![CDATA[
  67. //초기화
  68. function fInit() {
  69. model.removeNodeset("/root/main/studvoluntr");
  70. var sYear = getCurrentDate().substr(0,4);
  71. model.setValue("/root/main/cond/year", sYear);
  72. addComboItem("cmb_vacatflagcd","전체","%","above");
  73. model.setValue("/root/main/cond/vacflag","%");
  74. zbcfGetCodeList(new Array("A0366", "A0503", "A0360"),new Array("/root/init/vacatflagcd", "/root/init/actdeptcd", "/root/init/voluntractteamcd"),true);
  75. model.makeValue("/root/hidden/excelflag","1");
  76. grd_dept.mergeCells = "bycol";
  77. grd_dept.mergeCol(0) = true;
  78. grd_dept.mergeCol(1) = true;
  79. grd_dept.mergeCol(2) = true;
  80. grd_dept.mergeCol(3) = false;
  81. grd_dept.mergeCol(4) = false;
  82. grd_dept.mergeCol(5) = false;
  83. grd_dept.mergeCol(6) = false;
  84. model.refresh();
  85. }
  86. function sum()
  87. {
  88. var insRows = grd_sch.rows;
  89. grd_sch.valueMatrix(insRows, grd_dept.colRef("percent")) = percent+"%";
  90. model.refresh();
  91. }
  92. //엑셀저장 버튼 클릭시
  93. function fExcel() {
  94. if(model.getValue("/root/hidden/excelflag") == "1" )
  95. {
  96. if (grd_sch.rows <= 2)
  97. {
  98. messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
  99. return;
  100. }
  101. var fileName = window.fileDialog("save", ",", false, "학생자원봉사자 학교별통계", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
  102. if (fileName != ""){
  103. grd_sch.saveExcel(fileName, "SheetName", false, false, "", "", false);
  104. }
  105. }
  106. else if(model.getValue("/root/hidden/excelflag") == "2")
  107. {
  108. if (grd_dept.rows <= 2)
  109. {
  110. messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
  111. return;
  112. }
  113. var fileName = window.fileDialog("save", ",", false, "학생자원봉사자 부서별통계", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
  114. if (fileName != ""){
  115. grd_dept.saveExcel(fileName, "SheetName", false, false, "", "", false);
  116. }
  117. }
  118. }//fExcel END
  119. //조회버튼클릭시
  120. function fStudVoluntr() {
  121. if (model.getValue("/root/main/cond/year") == "" ) {
  122. messageBox("조회년도는 ","I003");
  123. model.setFocus("ipt_year");
  124. return false;
  125. }
  126. model.removeNodeset("/root/main/studvoluntr");
  127. model.removenode("/root/send");
  128. model.makeNode("/root/send/reqdata");
  129. model.copyNode("/root/send/reqdata", "/root/main/cond");
  130. model.makeValue("/root/send/reqdata/excelflag", model.getValue("/root/hidden/excelflag"));
  131. submit("TRAAA03301");
  132. if(model.getValue("/root/hidden/excelflag") == '1')
  133. {
  134. //1.학교별 인원 합계계산
  135. var insRows = grd_sch.rows ;
  136. grd_sch.addRow(insRows, false);
  137. var totSum =0;
  138. grd_sch.valueMatrix(insRows, grd_sch.colRef("schnm")) = "합계";
  139. for(var i = grd_sch.colRef("man") ; i <= grd_sch.colRef("woman") ; i++){
  140. var sSum = 0 ;
  141. for(var j = grd_sch.fixedRows; j < eval(grd_sch.rows -1 ) ; j++){
  142. sSum = sSum + eval(grd_sch.valueMatrix(j, i));
  143. }
  144. grd_sch.valueMatrix(insRows, i) = sSum;
  145. totSum = totSum +sSum;
  146. }
  147. grd_sch.valueMatrix(insRows, grd_sch.colRef("psnsum")) = totSum; //마지막 row의 합계에 총인원
  148. //백분율
  149. var servtm =0; //합계row의 봉사시간
  150. for(i=1;i<insRows-1;i++)
  151. {
  152. //alert(model.getValue("/root/main/studvoluntr/studsch["+i+"]/psnsum"));
  153. percent = model.getValue("/root/main/studvoluntr/studsch["+i+"]/psnsum")/totSum *100 ; //백분율
  154. percent = Math.round(percent*10) /10;
  155. grd_sch.valueMatrix(i+1, grd_sch.colRef("percent")) = percent+"%";
  156. servtm = servtm + eval(model.getValue("/root/main/studvoluntr/studsch["+i+"]/servtm"));
  157. }
  158. grd_sch.valueMatrix(insRows, grd_sch.colRef("servtm")) = servtm;
  159. grd_sch.valueMatrix(insRows, grd_sch.colRef("percent")) = "100%";
  160. }
  161. else if(model.getValue("/root/hidden/excelflag") == '2')
  162. {
  163. var deptRows = grd_dept.rows;
  164. var tot = 0;
  165. var percent = 0;
  166. for(i=1;i<deptRows-1;i++)
  167. {
  168. if(model.getValue("/root/main/studvoluntr/studdept["+i+"]/actdeptcd") =="합계")
  169. {
  170. tot = tot + eval(model.getValue("/root/main/studvoluntr/studdept["+i+"]/psn"));
  171. }
  172. }
  173. for(i=1;i<deptRows-1;i++)
  174. {
  175. percent = model.getValue("/root/main/studvoluntr/studdept["+i+"]/psn")/tot *100 ; //백분율
  176. percent = Math.round(percent*10) /10;
  177. grd_dept.valueMatrix(i+1, grd_dept.colRef("percent")) = percent+"%";
  178. if(model.getValue("/root/main/studvoluntr/studdept["+i+"]/actdeptcd")=="합계") // 변수에 저장한 값중 합계와 소계인 값을 찾아 색을 넣어준다.
  179. {
  180. grd_dept.cellStyle("background-color",i+1,2, i+1, 6) = "#ccffff";
  181. }
  182. else if(model.getValue("/root/main/studvoluntr/studdept["+i+"]/voluntractteamcd")=="소계")
  183. {
  184. grd_dept.cellStyle("background-color",i+1,3, i+1, 6) = "#ccffcc";
  185. }
  186. else if(model.getValue("/root/main/studvoluntr/studdept["+i+"]/vacatflag")=="총계")
  187. {
  188. grd_dept.cellStyle("background-color",i+1,1, i+1, 6) = "#fccccc";
  189. }
  190. else // 변수에 저장한 값중 합계와 소계인 값을 찾아 색을 넣어준다.
  191. {
  192. grd_dept.cellStyle("background-color",i+1,1, i+1, 6) = "#ffffff";
  193. }
  194. }
  195. return;
  196. // //2.부서별통계 백분율
  197. // var deptRows = grd_dept.rows;
  198. // var psnsum = 0;
  199. //
  200. // for(i=1;i<deptRows-1;i++)
  201. // {
  202. // psnsum = psnsum + eval(model.getValue("/root/main/studvoluntr/studdept["+i+"]/psn")); //전체 인원 구하기
  203. // }
  204. // for(i=1;i<deptRows-1;i++)
  205. // {
  206. // percent = model.getValue("/root/main/studvoluntr/studdept["+i+"]/psn")/psnsum *100 ; //백분율
  207. // percent = Math.round(percent*10) /10;
  208. // grd_dept.valueMatrix(i+1, grd_dept.colRef("percent")) = percent+"%";
  209. // grd_dept.cellStyle("background-color",i,1, i+2, 6) = "#ffffff"; //색 초기화
  210. // }
  211. //
  212. // //부서별 소계/합계 row 처리
  213. // var psn = 0;
  214. // var servtm = 0;
  215. // var psn2=0;
  216. // var servtm2=0;
  217. // var psn3=0;
  218. // var servtm3=0;
  219. // var percent = 0;
  220. // for(i=1;i<deptRows-1;i++)
  221. // {
  222. // psn = psn + eval(model.getValue("/root/main/studvoluntr/studdept["+i+"]/psn")); //인원(소계)
  223. // servtm = servtm + eval(model.getValue("/root/main/studvoluntr/studdept["+i+"]/servtm")); //시간(소계)
  224. // psn2 = psn2 + eval(model.getValue("/root/main/studvoluntr/studdept["+i+"]/psn")); //인원(합계)
  225. // servtm2 = servtm2 + eval(model.getValue("/root/main/studvoluntr/studdept["+i+"]/servtm")); //시간(합계)
  226. // psn3 = psn3 + eval(model.getValue("/root/main/studvoluntr/studdept["+i+"]/psn")); //인원(총계)
  227. // servtm3 = servtm3 + eval(model.getValue("/root/main/studvoluntr/studdept["+i+"]/servtm")); //시간(총계)
  228. //
  229. //
  230. // if(model.getValue("/root/main/studvoluntr/studdept["+i+"]/vacatflag") == model.getValue("/root/main/studvoluntr/studdept["+(i+1)+"]/vacatflag"))
  231. // {
  232. // if (model.getValue("/root/main/studvoluntr/studdept["+i+"]/actdeptcd") == model.getValue("/root/main/studvoluntr/studdept["+(i+1)+"]/actdeptcd"))
  233. // {
  234. // continue;
  235. // }
  236. // else if(model.getValue("/root/main/studvoluntr/studdept["+i+"]/actdeptcd") != model.getValue("/root/main/studvoluntr/studdept["+(i+1)+"]/actdeptcd"))
  237. // {
  238. // grd_dept.insertRow(i+2, false);
  239. // grd_dept.valueMatrix(i+2, grd_dept.colRef("vacatflag")) = model.getValue("/root/main/studvoluntr/studdept["+i+"]/vacatflag"); //시즌
  240. // grd_dept.valueMatrix(i+2, grd_dept.colRef("actdeptcd")) = model.getValue("/root/main/studvoluntr/studdept["+i+"]/actdeptcd");//부서명
  241. // grd_dept.valueMatrix(i+2, grd_dept.colRef("voluntractteamcd")) = "소계"; //소속
  242. // grd_dept.cellStyle("background-color",i+2,2, i+2, 6) = "#ccffcc";
  243. // grd_dept.valueMatrix(i+2, grd_dept.colRef("psn")) = psn; //인원(소계)
  244. // grd_dept.valueMatrix(i+2, grd_dept.colRef("servtm")) = servtm; //봉사시간(소계)
  245. //
  246. // percent = psn/psnsum *100 ; //백분율
  247. // percent = Math.round(percent*10) /10;
  248. // grd_dept.valueMatrix(i+2, grd_dept.colRef("percent")) = percent+"%";
  249. //
  250. // psn = 0;
  251. // servtm =0;
  252. // i++; //insertRow하기때문.
  253. // deptRows++;
  254. // }
  255. // }
  256. // else if(model.getValue("/root/main/studvoluntr/studdept["+i+"]/vacatflag") != model.getValue("/root/main/studvoluntr/studdept["+(i+1)+"]/vacatflag"))
  257. // {
  258. //
  259. // if((i+2)==deptRows)
  260. // {
  261. // var rowsum = deptRows+2;
  262. //
  263. // grd_dept.addRow(i+2, false);
  264. //
  265. // grd_dept.valueMatrix(i+2, grd_dept.colRef("vacatflag")) = model.getValue("/root/main/studvoluntr/studdept["+i+"]/vacatflag"); //시즌
  266. // grd_dept.valueMatrix(i+2, grd_dept.colRef("actdeptcd")) = model.getValue("/root/main/studvoluntr/studdept["+i+"]/actdeptcd");//부서명
  267. // grd_dept.valueMatrix(i+2, grd_dept.colRef("voluntractteamcd")) = "소계"; //소속
  268. // grd_dept.cellStyle("background-color",i+2,2, i+2, 6) = "#ccffcc";
  269. // grd_dept.valueMatrix(i+2, grd_dept.colRef("psn")) = psn; //인원(소계)
  270. // grd_dept.valueMatrix(i+2, grd_dept.colRef("servtm")) = servtm; //봉사시간(소계)
  271. //
  272. // percent = psn/psnsum *100 ; //백분율
  273. // percent = Math.round(percent*10) /10;
  274. // grd_dept.valueMatrix(i+2, grd_dept.colRef("percent")) = percent+"%";
  275. //
  276. // psn = 0;
  277. // servtm =0;
  278. // i++; //insertRow하기때문.
  279. // deptRows++;
  280. //
  281. // grd_dept.addRow(i+2, false);
  282. // grd_dept.valueMatrix(i+2, grd_dept.colRef("vacatflag")) = model.getValue("/root/main/studvoluntr/studdept["+i+"]/vacatflag"); //시즌
  283. // grd_dept.valueMatrix(i+2, grd_dept.colRef("actdeptcd")) = "합계";
  284. // grd_dept.cellStyle("background-color",i+2,1, i+2, 6) = "#ccffff";
  285. // grd_dept.valueMatrix(i+2, grd_dept.colRef("psn")) = psn2; //인원(합계)
  286. // grd_dept.valueMatrix(i+2, grd_dept.colRef("servtm")) = servtm2; //봉사시간(합계)
  287. //
  288. // percent = psn2/psnsum *100 ; //백분율
  289. // percent = Math.round(percent*10) /10;
  290. // grd_dept.valueMatrix(i+2, grd_dept.colRef("percent")) = percent+"%";
  291. //
  292. // //deptRows++;
  293. // psn2 = 0;
  294. // servtm2 =0;
  295. // i++; //insertRow하기때문.
  296. // deptRows++;
  297. //
  298. // grd_dept.addRow(i+2, false);
  299. // grd_dept.valueMatrix(i+2, grd_dept.colRef("vacatflag")) = model.getValue("/root/main/studvoluntr/studdept["+i+"]/vacatflag"); //시즌
  300. // grd_dept.valueMatrix(i+2, grd_dept.colRef("vacatflag")) = "총계";
  301. // grd_dept.valueMatrix(i+2, grd_dept.colRef("psn")) = psn3; //인원(합계)
  302. // grd_dept.valueMatrix(i+2, grd_dept.colRef("servtm")) = servtm3; //봉사시간(합계)
  303. // grd_dept.valueMatrix(i+2, grd_dept.colRef("percent")) = "100%"; //백분율
  304. // //deptRows++;
  305. // psn2 = 0;
  306. // servtm2 =0;
  307. //
  308. // for(i=1;i<rowsum;i++)
  309. // {
  310. // model.removeNodeset("/root/main/studvoluntr["+i+"]/studdept2");
  311. // //
  312. // model.makeValue("/root/main/studvoluntr/studdept2["+i+"]/vacatflag", model.getValue("/root/main/studvoluntr/studdept["+i+"]/vacatflag"));
  313. // model.makeValue("/root/main/studvoluntr/studdept2["+i+"]/actdeptcd", model.getValue("/root/main/studvoluntr/studdept["+i+"]/actdeptcd"));
  314. // model.makeValue("/root/main/studvoluntr/studdept2["+i+"]/voluntractteamcd", model.getValue("/root/main/studvoluntr/studdept["+i+"]/voluntractteamcd"));
  315. // model.makeValue("/root/main/studvoluntr/studdept2["+i+"]/psn", model.getValue("/root/main/studvoluntr/studdept["+i+"]/psn"));
  316. // model.makeValue("/root/main/studvoluntr/studdept2["+i+"]/servtm", model.getValue("/root/main/studvoluntr/studdept["+i+"]/servtm"));
  317. // model.makeValue("/root/main/studvoluntr/studdept2["+i+"]/sum", model.getValue("/root/main/studvoluntr/studdept["+i+"]/sum"));
  318. // model.makeValue("/root/main/studvoluntr/studdept2["+i+"]/percent", model.getValue("/root/main/studvoluntr/studdept["+i+"]/percent"));
  319. //
  320. // if(model.getValue("/root/main/studvoluntr/studdept2["+i+"]/actdeptcd")=="합계") // 변수에 저장한 값중 합계와 소계인 값을 찾아 색을 넣어준다.
  321. // {
  322. // grd_dept2.cellStyle("background-color",i,1, i, 6) = "#ccffff";
  323. //
  324. // }
  325. // else if(model.getValue("/root/main/studvoluntr/studdept2["+i+"]/voluntractteamcd")=="소계")
  326. // {
  327. // grd_dept2.cellStyle("background-color",i,2, i, 6) = "#ccffcc";
  328. // }
  329. // else // 변수에 저장한 값중 합계와 소계인 값을 찾아 색을 넣어준다.
  330. // {
  331. // grd_dept2.cellStyle("background-color",i,1, i, 6) = "#ffffff";
  332. // }
  333. // }
  334. // model.refresh();
  335. // return;
  336. // }
  337. //
  338. //
  339. //
  340. // grd_dept.insertRow(i+2, false);
  341. // grd_dept.valueMatrix(i+2, grd_dept.colRef("vacatflag")) = model.getValue("/root/main/studvoluntr/studdept["+i+"]/vacatflag"); //시즌
  342. // grd_dept.valueMatrix(i+2, grd_dept.colRef("actdeptcd")) = model.getValue("/root/main/studvoluntr/studdept["+i+"]/actdeptcd");//부서명
  343. // grd_dept.valueMatrix(i+2, grd_dept.colRef("voluntractteamcd")) = "소계"; //소속
  344. // grd_dept.cellStyle("background-color",i+2,2, i+2, 6) = "#ccffcc";
  345. // grd_dept.valueMatrix(i+2, grd_dept.colRef("psn")) = psn; //인원(소계)
  346. // grd_dept.valueMatrix(i+2, grd_dept.colRef("servtm")) = servtm; //봉사시간(소계)
  347. //
  348. // percent = psn/psnsum *100 ; //백분율
  349. // percent = Math.round(percent*10) /10;
  350. // grd_dept.valueMatrix(i+2, grd_dept.colRef("percent")) = percent+"%";
  351. //
  352. // psn = 0;
  353. // servtm =0;
  354. // i++; //insertRow하기때문.
  355. // deptRows++;
  356. //
  357. // grd_dept.insertRow(i+2, false);
  358. // grd_dept.valueMatrix(i+2, grd_dept.colRef("vacatflag")) = model.getValue("/root/main/studvoluntr/studdept["+i+"]/vacatflag"); //시즌
  359. // grd_dept.valueMatrix(i+2, grd_dept.colRef("actdeptcd")) = "합계";
  360. // grd_dept.cellStyle("background-color",i+2,1, i+2, 6) = "#ccffff";
  361. // grd_dept.valueMatrix(i+2, grd_dept.colRef("psn")) = psn2; //인원(합계)
  362. // grd_dept.valueMatrix(i+2, grd_dept.colRef("servtm")) = servtm2; //봉사시간(합계)
  363. //
  364. // percent = psn2/psnsum *100 ; //백분율
  365. // percent = Math.round(percent*10) /10;
  366. // grd_dept.valueMatrix(i+2, grd_dept.colRef("percent")) = percent+"%";
  367. //
  368. // //deptRows++;
  369. // psn2 = 0;
  370. // servtm2 =0;
  371. // i++;
  372. // deptRows++;
  373. // }
  374. // }
  375. }
  376. model.refresh();
  377. }
  378. //초기화버튼클릭시
  379. function fReset(){
  380. var btn = messageBox("초기화를 ", "Q004");
  381. if (btn == '6') {
  382. model.removeNodeset("/root/main/studvoluntr");
  383. model.resetInstanceNode("/root/main/cond");
  384. var sYear = getCurrentDate().substr(0,4);
  385. model.setValue("/root/main/cond/year", sYear);
  386. model.setValue("/root/main/cond/vacflag", "%");
  387. model.refresh();
  388. } else if (btn == '7') {
  389. return;
  390. }
  391. }//fReset END
  392. ]]>
  393. </script>
  394. <xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  395. <group id="group1" style="left:0px; top:0px; width:815px; height:13px; ">
  396. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:207px; height:14px; ">학생자원봉사자통계</caption>
  397. </group>
  398. <group id="group3" scroll="auto" style="left:0px; top:13px; width:825px; height:744px; ">
  399. <group id="grp_sea" style="left:0px; top:10px; width:820px; height:35px; vertical-align:top; ">
  400. <shape id="roundrect1" class="roundrect_search" appearance="roundrect" style="left:0px; top:0px; width:820px; height:35px; "/>
  401. <button id="button1" class="btn1_letter2" style="left:753px; top:7px; width:56px; height:22px; ">
  402. <caption>조회</caption>
  403. <script type="javascript" ev:event="DOMActivate">
  404. <![CDATA[
  405. fStudVoluntr();
  406. ]]>
  407. </script>
  408. </button>
  409. <line id="line13" class="line_4" style="x1:742px; y1:7px; x2:742px; y2:29px; "/>
  410. <caption id="caption3" class="search_name" style="left:20px; top:10px; width:94px; height:17px; ">조회년도 :</caption>
  411. <select1 id="cmb_vacatflagcd" ref="/root/main/cond/vacflag" class="combo_search" appearance="minimal" style="left:354px; top:9px; width:85px; height:19px; ">
  412. <choices>
  413. <itemset nodeset="/root/init/vacatflagcd/A0366">
  414. <label ref="cdnm"/>
  415. <value ref="cdid"/>
  416. </itemset>
  417. </choices>
  418. </select1>
  419. <input id="ipt_year" ref="/root/main/cond/year" class="input_default" format="yyyy" appearance="minimal" style="left:114px; top:9px; width:86px; height:19px; "/>
  420. <caption id="caption2" class="search_name" style="left:260px; top:10px; width:90px; height:17px; ">방학구분 :</caption>
  421. </group>
  422. <button id="button3" class="btn2_letter4" disable.background-image="../../../com/commonweb/images/dis_btn2_letter4.gif" style="left:748px; top:51px; width:64px; height:19px; background-image:../../../com/commonweb/images/btn2_letter4.gif; ">
  423. <caption>엑셀저장</caption>
  424. <script type="javascript" ev:event="DOMActivate">
  425. <![CDATA[
  426. fExcel();
  427. ]]>
  428. </script>
  429. </button>
  430. <button id="btn_sch" class="btn_sw" group="tab" selected="true" style="left:0px; top:80px; width:88px; height:22px; ">
  431. <caption>학교별</caption>
  432. <script type="javascript" ev:event="DOMActivate">
  433. <![CDATA[
  434. //fStudSch();
  435. model.setValue("/root/hidden/excelflag","1");
  436. model.toggle("case_sch");
  437. fStudVoluntr();
  438. model.refresh();
  439. ]]>
  440. </script>
  441. </button>
  442. <button id="btn_dept" class="btn_sw" group="tab" style="left:88px; top:80px; width:88px; height:22px; ">
  443. <caption>부서별</caption>
  444. <script type="javascript" ev:event="DOMActivate">
  445. <![CDATA[
  446. //fStudDept();
  447. model.setValue("/root/hidden/excelflag","2");
  448. model.toggle("case_dept");
  449. fStudVoluntr();
  450. model.refresh();
  451. ]]>
  452. </script>
  453. </button>
  454. <switch id="swt_studstats" style="left:0px; top:100px; width:820px; height:640px; border-style:solid; ">
  455. <case id="case_sch" selected="true">
  456. <datagrid id="grd_sch" nodeset="/root/main/studvoluntr/studsch" caption="소속학교^인원^인원^인원^봉사시간^백분율(%)^tot|소속학교^남^여^합계^봉사시간^백분율(%)^tot" colsep="^" colwidth="180, 90, 90, 90, 170, 174, 100" dataheight="25" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:0px; width:815px; height:638px; ">
  457. <col ref="schnm" style="text-align:center; "/>
  458. <col ref="man" style="text-align:center; "/>
  459. <col ref="woman" style="text-align:center; "/>
  460. <col ref="psnsum" style="text-align:center; "/>
  461. <col ref="servtm" format="#,###" style="text-align:center; "/>
  462. <col ref="percent" style="text-align:center; "/>
  463. <col ref="tot" visibility="hidden"/>
  464. </datagrid>
  465. </case>
  466. <case id="case_dept">
  467. <datagrid id="grd_dept" nodeset="/root/main/studvoluntr/studdept" caption="시즌^부서명^소속^인원^봉사시간^백분율|시즌^부서명^소속^인원^봉사시간^백분율" colsep="^" colwidth="143, 130, 130, 130, 130, 130" dataheight="25" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:0px; width:815px; height:635px; ">
  468. <col disabled="true" ref="vacatflag" style="text-align:center; "/>
  469. <col disabled="true" ref="actdeptcd" format="yyyy-mm-dd" style="text-align:center; "/>
  470. <col disabled="true" ref="voluntractteamcd" format="yyyy-mm-dd" style="text-align:center; "/>
  471. <col ref="psn" style="text-align:center; "/>
  472. <col ref="servtm" format="#,###" style="text-align:center; "/>
  473. <col ref="percent" style="text-align:center; "/>
  474. </datagrid>
  475. </case>
  476. </switch>
  477. </group>
  478. <group id="group5" scroll="auto" style="left:0px; top:757px; width:820px; height:27px; ">
  479. <line id="line37" class="line_6" style="x1:0px; y1:0px; x2:820px; y2:0px; "/>
  480. </group>
  481. <caption id="caption1" class="tit_2" style="left:5px; top:71px; width:309px; height:14px; ">학생자원봉사자 학교별/부서별 통계</caption>
  482. <line id="line1" class="line_1" style="x1:0px; y1:86px; x2:820px; y2:86px; "/>
  483. <button id="button10" class="btn4_letter3" disable.background-image="../../../com/commonweb/images/dis_btn4_letter3.gif" style="left:743px; top:760px; width:68px; height:22px; background-image:../../../com/commonweb/images/btn4_letter3.gif; ">
  484. <caption>초기화</caption>
  485. <script type="javascript" ev:event="DOMActivate">
  486. <![CDATA[
  487. fReset();
  488. //조회
  489. ]]>
  490. </script>
  491. </button>
  492. </xhtml:body>
  493. </xhtml:html>