var gRptCd = ''; //ÇöÀç Åë°è¹øÈ£ //È­¸é ÃʱâÈ­ À̺¥Æ® function fInitialize() { model.resetInstanceNode("/root/send/reqdata"); //Åë°è±¸ºÐÁ¶°Ç ÃʱâÈ­ model.resetInstanceNode("/root/send/condition"); //°Ë»öÁ¶°Ç ÃʱâÈ­ model.resetInstanceNode("/root/main/statslist"); //ÇöȲ ÃʱâÈ­ fInitCond(); //Ãʱâ Á¶°Ç ¼³Á¤ var gScrParmL = getScreenMenuParameter().substr(0,2); //´ëºÐ·ù var gScrParmM = getScreenMenuParameter().substr(2,2); //Áߺзù var gScrParmS = getScreenMenuParameter().substr(4,2); //¼ÒºÐ·ù var gScrParmR = getScreenMenuParameter().substr(6,7); //È­¸é ID gRptCd = gScrParmR; model.setValue("root/send/reqdata/cdflag", '04'); // model.setValue("root/send/reqdata/lrgcd", gScrParmL ); model.setValue("root/send/reqdata/mdlcd", gScrParmM ); model.setValue("root/send/reqdata/smlcd", gScrParmS ); model.setValue("root/send/reqdata/rptcd", gScrParmR ); if (submit("TRMRH00700")) { //model.setValue("/root/main/title/rptnm", model.getValue("/root/hidden/rptinfo/rptnm" ) ); //È­¸é À̸§ //model.setValue("/root/main/title/listnm", model.getValue("/root/hidden/rptinfo/rptcd" )); //È­¸é CODE cap_title.text = model.getValue("/root/hidden/rptinfo/rptnm" ); //È­¸é À̸§ lbl_list.text = model.getValue("/root/hidden/rptinfo/mdlnm")+" "+model.getValue("/root/hidden/rptinfo/smlnm"); fProcGrid(gScrParmR); //±×¸®µå ó¸® } } /** * Á¶È¸Á¶°Ç ¼³Á¤ */ function fInitCond() { var currYear = (new Date()).getFullYear(); var yearsAgo = currYear-10; var nodeset = instance1.selectSingleNode(cmb_cond1.choices.itemset.attribute("nodeset")); for (var i = currYear; i > yearsAgo; i--) { var nodeLbl = instance1.createElement("lbl"); var nodeVal = instance1.createElement("val"); nodeLbl.value = i; nodeVal.value = i; nodeset.appendChild(nodeLbl); nodeset.appendChild(nodeVal); } model.refresh(); cmb_cond1.value = currYear; } /** * ±×¸®µå ó¸®(caption, width, align) */ function fProcGrid(rptCd) { var iCols = grd_stats.cols; var sCaption = model.getValue("/root/hidden/rptinfo/rpttitle"); var sWidth = model.getValue("/root/hidden/rptinfo/rptsize"); var sLeft = model.getValue("/root/hidden/rptinfo/left"); var sMiddle = model.getValue("/root/hidden/rptinfo/middle"); var arrCap = sCaption.split("^"); var arrLeft = sLeft.split("^"); var arrMid = sMiddle.split("^"); var iRest = iCols - arrCap.length; grd_stats.caption = sCaption; grd_stats.attribute("colwidth") = sWidth; grd_stats.mergecells = "bycol"; //ÇöÀç Åë°èÀåÇ¥ Ä÷³ º¸ÀÌ±â ¹× ±âº» alignÀ» right·Î for (var i = 0; i < arrCap.length; i++) { if (arrCap[i] == "¸ñǥġ") { grd_stats.colType(i) = "input"; } else { grd_stats.colType(i) = "output"; } grd_stats.mergecol(i) = false; grd_stats.colHidden(i) = false; grd_stats.colstyle(i, "data", "text-align") = "right"; grd_stats.colAttribute(i, "format") = "#,###.#"; grd_stats.colAttribute(i, "roundmode") = "round"; grd_stats.colAttribute(i, "roundposition") = "-2"; } switch (rptCd) { case 'RR00900': grd_stats.mergecol(0) = true; break; case 'RR00901': grd_stats.mergecol(0) = true; grd_stats.mergecol(1) = true; break; default: grd_stats.mergecol(0) = true; break; } //ÀÌ¿Ü Ä÷³ ¼û±â±â for (var i = arrCap.length; i < iCols; i++) { grd_stats.colHidden(i) = true; } //¿ÞÂÊÁ¤·Äó¸® for (var i = 0; i < arrLeft.length; i++) { if (arrLeft[i] == "") continue; grd_stats.colstyle(arrLeft[i], "data", "text-align") = "left"; grd_stats.colAttribute(arrLeft[i], "format") = ""; grd_stats.colAttribute(arrLeft[i], "roundmode") = ""; grd_stats.colAttribute(arrLeft[i], "roundposition") = ""; } //Áß¾ÓÁ¤·Äó¸® for (var i = 0; i < arrMid.length; i++) { if (arrMid[i] == "") continue; grd_stats.colstyle(arrMid[i], "data", "text-align") = "center"; grd_stats.colAttribute(arrMid[i], "format") = ""; grd_stats.colAttribute(arrMid[i], "roundmode") = ""; grd_stats.colAttribute(arrMid[i], "roundposition") = ""; } grd_stats.refresh(); } /** * */ function fSrchStatsList() { model.setValue("/root/send/condition/rptcd", model.getValue("/root/hidden/rptinfo/rptcd")); submit("TRMRH00701"); switch (gRptCd) { case 'RR00900': // break; case 'RR00901': // grd_stats.mergeByFree(9, 0, 12, 1); grd_stats.mergeByFree(25, 0, 28, 1); grd_stats.mergeByFree(29, 0, 32, 1); grd_stats.mergeByFree(33, 0, 36, 1); grd_stats.mergeByFree(37, 0, 40, 1); grd_stats.mergeByFree(41, 0, 44, 1); grd_stats.mergeByFree(45, 0, 48, 1); grd_stats.mergeByFree(57, 0, 57, 1); grd_stats.mergeByFree(58, 0, 58, 1); grd_stats.mergeByFree(59, 0, 59, 1); grd_stats.mergeByFree(60, 0, 60, 1); grd_stats.mergeByFree(61, 0, 61, 1); grd_stats.mergeByFree(64, 0, 64, 1); grd_stats.mergeByFree(85, 0, 86, 1); grd_stats.mergeByFree(87, 0, 88, 1); grd_stats.mergeByFree(89, 0, 89, 1); grd_stats.mergeByFree(90, 0, 90, 1); grd_stats.mergeByFree(91, 0, 91, 1); grd_stats.mergeByFree(92, 0, 92, 1); grd_stats.mergeByFree(93, 0, 96, 1); grd_stats.mergeByFree(97, 0, 97, 1); grd_stats.mergeByFree(98, 0, 98, 1); grd_stats.mergeByFree(99, 0, 99, 1); grd_stats.mergeByFree(100, 0, 100, 1); grd_stats.mergeByFree(101, 0, 101, 1); grd_stats.mergeByFree(112, 0, 112, 1); grd_stats.mergeByFree(113, 0, 113, 1); grd_stats.mergeByFree(114, 0, 114, 1); grd_stats.mergeByFree(115, 0, 115, 1); break; case 'RR00902': // break; case 'RR00903': // grd_stats.mergeByFree(17, 0, 17, 1); grd_stats.mergeByFree(18, 0, 18, 1); grd_stats.mergeByFree(19, 0, 19, 1); grd_stats.mergeByFree(20, 0, 20, 1); grd_stats.mergeByFree(21, 0, 21, 1); grd_stats.mergeByFree(22, 0, 22, 1); grd_stats.mergeByFree(23, 0, 23, 1); grd_stats.mergeByFree(24, 0, 27, 1); grd_stats.mergeByFree(28, 0, 31, 1); grd_stats.mergeByFree(32, 0, 32, 1); grd_stats.mergeByFree(33, 0, 33, 1); grd_stats.mergeByFree(34, 0, 34, 1); grd_stats.mergeByFree(35, 0, 35, 1); grd_stats.mergeByFree(36, 0, 36, 1); grd_stats.mergeByFree(37, 0, 37, 1); grd_stats.mergeByFree(38, 0, 38, 1); grd_stats.mergeByFree(39, 0, 39, 1); grd_stats.mergeByFree(40, 0, 40, 1); break; default: // break; } } /** * ExcelÆÄÀÏ ÀúÀå */ function fSaveExcel(){ var rptNm = model.getValue("/root/hidden/rptinfo/rptnm" )+"_"+getCurrentDate(); var file = window.fileDialog("save","","true", rptNm,"xls","All Files (*.*)|*.*|Excel Files(*.xls)|*.xls"); if(file != "") { grd_stats.saveExcel(file, "SheetName", true, true, "", "", false); } }