Nexacro.Grid - cell을 area로 선택 시 cell의 sum,avg구하기

[ Nexacro.Grid - cell을 area로 선택 시 cell의 sum,avg구하기 ]

 

1. 정의

    - Grid.속성.seltype = area 인 경우  사용자가 grid에서 cell을 여러게 drag해서 선택 했을 경우

       해당 cell의 숫자cell들만 값을 추출해서 cell갯수, 평균, 합계를 보여준다.

 

2. 호출

  // 그리드 합계 툴팁
  objGrid.addEventHandler("oncellclick", this.gfn_oncellclick_clearDragPosition, this);
  objGrid.addEventHandler("onlbuttonup", this.gfn_onlbuttonup_popuptootip, this);

 

3. function

    this.gfn_oncellclick_clearDragPosition = function(obj, e) { obj.oldSelectstartcol = -1; obj.oldSelectendcol = -1; obj.oldSelectstartrow = -1; obj.oldSelectendrow = -1; }; this.gfn_onlbuttonup_popuptootip = function(obj, e) { var selectstartcol = obj.selectstartcol[0]; var selectendcol = obj.selectendcol[0]; var selectstartrow = obj.selectstartrow[0]; var selectendrow = obj.selectendrow[0]; if((selectstartcol != selectendcol || selectstartrow != selectendrow) // 한 셀 클릭시에는 수행 금지. && (obj.oldSelectstartcol != selectstartcol || obj.oldSelectendcol != selectendcol || obj.oldSelectstartrow != selectstartrow || obj.oldSelectendrow != selectendrow) ) // 선택영역이 변경되었을 때(스크롤바로 인한 Popup출력 방지) { var pDdivName = "PopupDivGirdSumToltip"; var objPopupDiv; // 팝업툴팁 생성 if(!this[pDdivName]) { objPopupDiv = new PopupDiv(pDdivName, "absolute", 0, 0, 130, 56, null, null); this.addChild(objPopupDiv.name, objPopupDiv); objPopupDiv.set_scrollbars("none"); objPopupDiv.style.set_background("#ffffccff"); objPopupDiv.style.set_border("1 solid #c6003dff,1 solid #c6003dff,1 solid #c6003dff,1 solid #c6003dff"); objPopupDiv.show(); var objStatic = new Static("sta_countT", "absolute", "5", "0", "45", "18", null, null, objPopupDiv); objStatic.set_text("Count"); objPopupDiv.addChild(objStatic.name, objStatic); objStatic.show(); objStatic = new MaskEdit("sta_count", "absolute", "50", "0", "78", "18", null, null, objPopupDiv); objStatic.style.set_align("right"); objStatic.set_type("number"); objStatic.style.set_background_color("#ffffccff"); objStatic.style.set_border("0px"); objStatic.set_readonly(true); objStatic.set_right(5); objStatic.set_mask("9,999.99"); objPopupDiv.addChild(objStatic.name, objStatic); objStatic.show(); objStatic = new Static("sta_averageT", "absolute", "5", "18", "45", "18", null, null, objPopupDiv); objStatic.set_text("Average"); objPopupDiv.addChild(objStatic.name, objStatic); objStatic.show(); objStatic = new MaskEdit("sta_average", "absolute", "50", "18", "78", "18", null, null, objPopupDiv); objStatic.style.set_align("right"); objStatic.set_type("number"); objStatic.style.set_background_color("#ffffccff"); objStatic.style.set_border("0px"); objStatic.set_readonly(true); objStatic.set_right(5); objStatic.set_mask("9,999.99"); objPopupDiv.addChild(objStatic.name, objStatic); objStatic.show(); objStatic = new Static("sta_sumT", "absolute", "5", "36", "45", "18", null, null, objPopupDiv); objStatic.set_text("Sum"); objPopupDiv.addChild(objStatic.name, objStatic); objStatic.show(); objStatic = new MaskEdit("sta_sum", "absolute", "50", "36", "78", "18", null, null, objPopupDiv); objStatic.style.set_align("right"); objStatic.set_type("number"); objStatic.style.set_background_color("#ffffccff"); objStatic.style.set_border("0px"); objStatic.set_readonly(true); objStatic.set_right(5); objStatic.set_mask("9,999.99"); objPopupDiv.addChild(objStatic.name, objStatic); objStatic.show(); objStatic = null; objPopupDiv = null; } var rPdv = this[pDdivName]; var ds = obj.getBindDataset(); var average = 0, sum = 0; var displaytype; var count = 0; for(var i = selectstartcol; i <= selectendcol; i++) { edittype = obj.getCellProperty("body", i, "displaytype"); //expr 일때 edittype 체크 var tag = edittype.substr(0, 4); tag = tag.toUpperCase(); if (tag == "EXPR" || tag == "BIND") { if (ds == null) { return undefined; } var bindexpr = edittype.substr(5); var val = edittype; var s = val.toLowerCase().indexOf("bind:"); if (s >= 0) { bindexpr = bindexpr.substring(s, bindexpr.length); bindexpr = ds.getColumn(j, bindexpr); } var exprfn = obj._exprcache[bindexpr]; if (exprfn == null) { exprfn = ds._createExprFunc(bindexpr); obj._exprcache[bindexpr] = exprfn; } if ((typeof exprfn) == "function") { edittype = exprfn.call(this, j, j, obj, ds); } } for(var j = selectstartrow; j <= selectendrow; j++) { if(edittype == "number" && obj.getFormatColSize(i) > 0) { sum+=parseFloat(obj.getCellValue(j, i)); count++; } } } sum = parseFloat(sum.toFixed(2)); average = nexacro.round(sum/count, 2); var nX = e.screenX - system.clientToScreenX(application.mainframe, 0); var nY = e.screenY - system.clientToScreenY(application.mainframe, 0); var font = rPdv["sta_sumT"].currentstyle.font; var nWidth1 = Math.round(nexacro.getTextSize( String(sum), font ).nx); var nWidth2 = Math.round(nexacro.getTextSize( String(average), font ).nx); var nWidth; var popWidth; nWidth = (nWidth1>nWidth2? nWidth1 : nWidth2) * 1.45; //팝업 크기 조율 nWidth = (nWidth > 70 ? nWidth : 70); //너무 작지 않게 디폴트 크기 유지 popWidth = rPdv["sta_sumT"].getOffsetWidth()+ nWidth + 10; sum = isNaN(sum) ? 0 : sum; average = isNaN(average) ? 0 : average; rPdv["sta_count"].set_value(count); rPdv["sta_count"].set_width(nWidth); rPdv["sta_sum"].set_value(sum); rPdv["sta_sum"].set_width(nWidth); rPdv["sta_average"].set_value(average); rPdv["sta_average"].set_width(nWidth); rPdv.trackPopup(nX+15, nY, popWidth, 56, "", false); obj.oldSelectstartcol = selectstartcol; obj.oldSelectendcol = selectendcol; obj.oldSelectstartrow = selectstartrow; obj.oldSelectendrow = selectendrow; } };