BemsWebApplication.EnthalpyEnergyConsumption = function (params, viewInfo) { "use strict"; var BUILDING_DEPTH = 1, FLOOR_DEPTH = 2, ZONE_DEPTH = 3; var CODE = $Code, FuelType = CODE.FuelType, FT = CODE.FacilityType, FC = CODE.FacilityCode, F = CODE.Formula, TIT = CODE.TimeIntervalType; var visiblePopup = ko.observable(false); var initialized = false, shouldReload = false, dataSource; var pointHistoryGet = new BWA.Chart.PointHistoryGet(BWA.UserInfo.SiteId()), timeBoxForSearch = BWA.SearchView.createDateTimeBox(), formulaGet = new BWA.Chart.FormulaGet(BWA.UserInfo.SiteId()); var buildingDataSource = BemsWebApplication.db.createDataSource('CmBuilding', true), floorDataSource = BemsWebApplication.db.createDataSource('CmFloor'), zoneDataSource = BemsWebApplication.db.createDataSource('CmZone'), fuelTypesDataSource = BemsWebApplication.db.createDataSource('BemsFuelType'), buildings = ko.observableArray(), timeTypesForSearch = ko.observableArray(), timeTypeIdForSearch = ko.observable(0), floorsForSearch = ko.observableArray(), zonesForSearch = ko.observableArray(), fuelTypesForSearch = ko.observableArray(), buildingIdForSearch = ko.observable(), buildingNameForSearch = ko.observable(), floorIdForSearch = ko.observable(), floorNameForSearch = ko.observable(), zoneIdForSearch = ko.observable(), zoneNameForSearch = ko.observable(), fuelTypeIdForSearch = ko.observable(), deferredForSearch = new $.Deferred(); var deferredForLoadData = new $.Deferred(); var chart = BWA.Chart.Instance('chartEHPA', 'dxChart'); var locationEnableForSearch = ko.observable(false); var chartDataArray = ko.observableArray(); // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가 // 팝업창뷰 보이기 속성 제어용 변수 선언 var DataGridPopup_Visible = ko.observable(false); // 그래프 출력 이후 엑셀출력을 위한 팝업창을 위해 임시 저장용 배열 선언 var dataArrayresult = ko.observableArray(); // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가 chartDataArray([ { DateTime: new Date(2014, 11, 16, 0), OutdoorTemperature: -3.4, OutdoorHumidity: 40, Value: 30 }, { DateTime: new Date(2014, 11, 16, 0, 15), OutdoorTemperature: -1.1, OutdoorHumidity: 44, Value: 32 }, { DateTime: new Date(2014, 11, 16, 0, 30), OutdoorTemperature: 3, OutdoorHumidity: 48, Value: 33 }, { DateTime: new Date(2014, 11, 16, 0, 45), OutdoorTemperature: 4, OutdoorHumidity: 55, Value: 34 }, { DateTime: new Date(2014, 11, 16, 1), OutdoorTemperature: 8, OutdoorHumidity: 54, Value: 50 }, { DateTime: new Date(2014, 11, 16, 2), OutdoorTemperature: 10, OutdoorHumidity: 53, Value: 60 }, { DateTime: new Date(2014, 11, 16, 3), OutdoorTemperature: 11, Value: 80 }, { DateTime: new Date(2014, 11, 16, 4), OutdoorTemperature: 12, OutdoorHumidity: 48, Value: 100 }, { DateTime: new Date(2014, 11, 16, 5), OutdoorTemperature: 12, OutdoorHumidity: 40 }, { DateTime: new Date(2014, 11, 16, 6), Value: 120 } ]); var goalUpperBound = ko.observable(40); function SetPointer(values1, values2) { var len = 0; var tmpArray = new Array(); var values1MinMax = 0; var values2MinMax = 0; if (values1.length > values2.length) { len = values2.length; } else { len = values1.length; } if (len <= 1) { utils.toast.show("지표를 연산 할 데이터 범위가 적어도 하나 이상 존재해야 합니다."); $('#pointerText').text("상관성 지표 : 연산 데이터가 부족합니다."); } else { var values1Min = 9999; var values1Max = -9999; for (var i = 0; i < values1.length; i++) { if (values1[i].Value <= values1Min) values1Min = values1[i].Value; if (values1[i].Value >= values1Max) values1Max = values1[i].Value; } values1MinMax = values1Max - values1Min; var values2Min = 9999; var values2Max = -9999; for (var i = 0; i < values2.length; i++) { if (values2[i].Value <= values2Min) values2Min = values2[i].Value; if (values2[i].Value >= values2Max) values2Max = values2[i].Value; } values2MinMax = values2Max - values2Min; for (var i = 0; i < len - 1; i++) { //tmpArray.push({ value1: values1[i] - values1[i + 1], value2: values2[i] - values2[i + 1] }); tmpArray.push((((values1[i].Value - values1[i + 1].Value) / values1MinMax * 100) / ((values2[i].Value - values2[i + 1].Value) / values2MinMax * 100)).toFixed(2)); } var sum = 0; var cnt = 0; for (var j = 0; j < tmpArray.length; j++) { if (isFinite(tmpArray[j]) && !isNaN(tmpArray[j])) { //sum = sum + Math.abs(tmpArray[j]); sum = sum + parseFloat(tmpArray[j].toString()); cnt++; } } if (isFinite((sum / cnt).toFixed(2)) && !isNaN((sum / cnt).toFixed(2))) { $('#pointerText').text("상관성 지표 : " + (sum / cnt).toFixed(2).toString() + "%"); } else { $('#pointerText').text("상관성 지표 : 0%"); } } } function handleClickTreeItem(element, data) { var eq = BWA.DataUtil.constructEqualFilter; var depth = data.depth; //data = data.data; switch (depth) { case BUILDING_DEPTH: // building data = data.data; buildingIdForSearch(data.BuildingId()); buildingNameForSearch(data.Name()); floorIdForSearch(null); floorNameForSearch(''); zoneIdForSearch(null); zoneNameForSearch(''); break; case FLOOR_DEPTH: // floor buildingNameForSearch(data.parentData.data.Name()); data = data.data; buildingIdForSearch(data.BuildingId()); floorIdForSearch(data.FloorId()); floorNameForSearch(data.Name()); zoneIdForSearch(null); zoneNameForSearch(''); break; case ZONE_DEPTH: // zone floorNameForSearch(data.parentData.data.Name()); buildingNameForSearch(data.parentData.parentData.data.Name()); data = data.data; buildingIdForSearch(data.BuildingId()); floorIdForSearch(data.FloorId()); zoneIdForSearch(data.ZoneId()); zoneNameForSearch(data.Name()); break; } } function handleSearchViewInitializeUpdate() { //alert('handleSearchViewInitializeUpdate'); $('#locationTreeViewInSearchViewE').cwTreeView({ width: '40%', height: '480px', onClickTreeItem: handleClickTreeItem, delegateDataSource: BWA.DataUtil.getLocationDataSourceDelegateForTreeView( buildingDataSource, floorDataSource, zoneDataSource ) }); } function handleViewShown() { if (initialized === false) { chart = chart(BWA.ChartOptions.EnthalpyEnergyConsumption.getChartOptions(timeBoxForSearch.type(), goalUpperBound)); floorNameForSearch(''); zoneNameForSearch(''); initialized = true; } if (shouldReload) { } } function handleViewHidden() { $SearchView.visibleObservable(false); // hcLee 2015 03 23 visiblePopup(false); } function handleViewShowing() { $.when(fuelTypesDataSource.load(), buildingDataSource.load()).done(function (fuelTypes, dbBuildings) { fuelTypes = fuelTypes[0]; dbBuildings = dbBuildings[0]; fuelTypesForSearch(_.rest(fuelTypes)); deferredForSearch.resolve(); if (_.isEmpty(dbBuildings) === false) { buildingIdForSearch(dbBuildings[0].BuildingId()); buildingNameForSearch(dbBuildings[0].Name()); handleSearchInSearchView(); } }); } function refreshList() { } var searchViewOptions = { searchViewItems: [ { id: 'FuelTypeId', ignoreValue: 0, defaultValue: $Code.FuelType.ELECTRICITY, value: fuelTypeIdForSearch, dataSource: fuelTypesForSearch } ], promiseDataInSearchView: deferredForSearch.promise() }; function handleSearchInSearchView() { visiblePopup(true); $("#large-indicator").dxLoadIndicator({ height: 60, width: 60 }); var date = timeBoxForSearch.getDate(), timeType = timeBoxForSearch.type(); var commonParameters = { TimeIntervalType: timeBoxForSearch.type(), StartDate: date.startDate, EndDate: date.endDate }; var pointHistoryParameters = { BuildingId: buildingIdForSearch(), FloorId: floorIdForSearch(), ZoneId: zoneIdForSearch(), FuelTypeId: fuelTypeIdForSearch() }; var temperatureParameters = { FacilityTypeId: FT.OUTDOOR, FacilityCode: FC.OUTDOOR, FormulaId: F[FT.OUTDOOR].TEMPERATURE, }; var humidityParameters = _.extend({}, temperatureParameters, { FormulaId: F[FT.OUTDOOR].HUMIDITY, }); $.when( pointHistoryGet.apiGet(_.extend(pointHistoryParameters, commonParameters)), formulaGet.apiGet(_.extend(temperatureParameters, commonParameters)), formulaGet.apiGet(_.extend(humidityParameters, commonParameters))) .done(function (values, temperatures, humidities) { SetPointer(values[0], temperatures[0]); var dataArray = []; // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가 var dataArray_Temp = []; var dataArray_Temp1 = []; // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가 _.each(values[0], function (x) { dataArray_Temp.push({ DateTime: BWA.Chart.getCustermTimeArgumentAxisString(timeBoxForSearch.type(), moment(x.DateTime).toDate()), Value: x.Value }); }); for (var i = 0; i < temperatures[0].length; i++) { dataArray_Temp1.push({ DateTime: BWA.Chart.getCustermTimeArgumentAxisString(timeBoxForSearch.type(), moment(temperatures[0][i].DateTime).toDate()), enthalpy: BWA.Bems.refinegetENTHALPY(temperatures[0][i].Value, humidities[0][i].Value / 100) }); } // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가 // 배열을 하나로 합치자 var array_length_size = Math.max(dataArray_Temp.length, dataArray_Temp1.length); // 크기가 동일한 경우에만 허용함 (예외 방어용) if (dataArray_Temp.length == dataArray_Temp1.length) { for (var i = 0; i < array_length_size; i++) { dataArray.push( { DateTime: dataArray_Temp[i].DateTime, Value: dataArray_Temp[i].Value, enthalpy: dataArray_Temp1[i].enthalpy }); } } dataArrayresult = dataArray; // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가 var options = BWA.ChartOptions.EnthalpyEnergyConsumption.getSeriesOptions(timeBoxForSearch.type(), fuelTypeIdForSearch(), goalUpperBound()); options.dataSource = dataArray; chart().option(options); $('#st').text('' + "" + buildingNameForSearch() + " - " + floorNameForSearch() + " - " + zoneNameForSearch()); visiblePopup(false); }) .fail(function (error) { //alert(error); visiblePopup(false); }); //buildingNameForSearch } function handleMenuItemClick(e) { var chartIntance = chart(); var chartOptions = chartIntance._options; var series = chartIntance.getAllSeries(); var table = []; var columns = [chartOptions.argumentAxis.title]; var values = {}; _.each(chartOptions.valueAxis, function (a) { columns.push(a.title.text); }); _.each(series, function (s, i) { _.each(s.pointsByArgument, function (point, argument) { var array = values[argument]; if (_.isArray(array) === false) { array = values[argument] = []; } array[i] = point[0].value; }); }); var csvRows = [columns.join(',')]; _.each(values, function (values, argument) { csvRows.push([$G.dateTime(moment(Number(argument))), values.join(',')].join(',')); }); var csvContent = csvRows.join("\r\n"); var agent = navigator.userAgent.toLowerCase(); if (window.navigator.msSaveOrOpenBlob) { var fileData = ['\uFEFF' + csvContent]; var blobObject = new Blob(fileData); window.navigator.msSaveOrOpenBlob(blobObject, 'export.csv'); } else { var csvString = 'data:text/csv;utf-8,\uFEFF' + encodeURI(csvContent); var a = $('#csvExporter'); a.attr({ 'href': csvString, 'target': '_blank', 'download': 'export.csv' }); // a.trigger('click'); var aa = document.getElementById('csvExporter'); aa.click(); } } // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가 function DataGridPopup_ButtonClick() { DataGridPopup_Visible(true); } function handlePopupShown() { // 컬럼명 업데이트 var ColumnCaptionName = ""; switch (fuelTypeIdForSearch()) { case $Code.FuelType.ELECTRICITY: ColumnCaptionName = "전기"; break; case $Code.FuelType.GAS: ColumnCaptionName = "가스"; break; case $Code.FuelType.WATER: ColumnCaptionName = "수도"; break; } viewModel.EnthalpyEnergyConsumptionDataGridOptions.columns[1].caption = ColumnCaptionName; // 데이타소스 업데이트 $("#EnthalpyEnergyConsumptionDataGrid_Container").dxDataGrid("instance").option("dataSource", dataArrayresult); // 팝업창 갱신 DataGridPopup_Visible(true); } // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가 var viewModel = $.extend(BWA.CommonView.create( params, viewInfo, searchViewOptions, ko.observable(null), handleViewShown, null, handleSearchInSearchView, handleSearchViewInitializeUpdate), { refreshList: refreshList, viewShowing: handleViewShowing, viewHidden: handleViewHidden, // hcLee 2015 03 23 locationEnableForSearch: locationEnableForSearch, handleMenuItemClick: handleMenuItemClick, menuItems: [{ text: '엑셀(csv) 내보내기' }] // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가 , EnthalpyEnergyConsumptionDataGridPopup_ButtonClicked: DataGridPopup_ButtonClick // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가 }); viewModel.timeBoxForSearch = timeBoxForSearch; // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가 viewModel.EnthalpyEnergyConsumptionDataGridPopupOptions = { width: '480px', height: '750px', // cyim 2017.05.30 : 테스트 결과 Devextreme 버그임. px 로 지정하면 초기 출력시 정확하게 가운데에 있지만, auto 설정시 화면아래에 위치하게 됨 contentTemplate: "content", showTitle: true, title: "도표", visible: DataGridPopup_Visible, dragEnabled: true, closeOnOutsideClick: true, shownAction: handlePopupShown, animation: window.utils.popup.createAnimation() }; // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가 viewModel.popupOptions = { width: 300, height: 140, contentTemplate: "info", showTitle: false, title: "작업중", visible: visiblePopup, dragEnabled: false, shading: false, closeOnOutsideClick: false }; //대기압 var height = 101325 * Math.pow((1 - 2.25577 * Math.pow(10, -5) * 50), 5.2559); //alert(height); //포화공기 압력 function getSAP(temp) { var cl = new Array(-5674.5359, 6.3925247, -0.009677843, 6.22157E-07, 2.07478E-09, -9.48402E-13, 4.1635019); var ch = new Array(-5800.2206, 1.3914993, -0.048640239, 4.17648E-05, -1.44521E-08, 6.5459673); var at = temp + 273.15; if (temp < 0) return Math.exp(cl[0] / at + cl[1] + cl[2] * at + cl[3] * Math.pow(at, 2) + cl[4] * Math.pow(at, 3) + cl[5] * Math.pow(at, 4) + cl[6] * Math.log(at)); return Math.exp(ch[0] / at + ch[1] + ch[2] * at + ch[3] * Math.pow(at, 2) + ch[4] * Math.pow(at, 3) + ch[5] * Math.log(at)); } //var SAP = getSAP(80/100, 30.0); //alert(SAP); // 절대습도 function getAH(humi, temp) { return (0.62198 * humi * getSAP(temp)) / (height - humi * getSAP(temp)); } //var AH = getAH(80/100, 30); //alert(AH); function getENTHALPY(humi, temp) { return 1.006 * temp + (2501 + (1.86 * temp)) * getAH(humi, temp); } var e = getENTHALPY(80 / 100, 30); // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가 // 주석이 너무 없음. 나중에 변경 작업을 진행하는 누군가가 시간 소비를 하지 않기 위해...남김 // 시간 포맷은 그래프에 귀속해야 되므로 포맷은 변경하지 않는 것이 유리함 // 전기,가스,수도 와 같이 선택적으로 변경해야 된다면 아래와 같이 캡션은 고정하지 말것 viewModel.EnthalpyEnergyConsumptionDataGridOptions = { dataSource: dataArrayresult, paging: { pageSize: 17 }, columns: [ { dataField: 'DateTime', caption: "날짜", width: '33%', alignment: 'center', },// dataType: 'date', format: 'yyyy-MM-dd HH:mm' }, { dataField: 'Value', width: '33%', alignment: 'center', format: 'fixedPoint', precision: 2 }, { dataField: 'enthalpy', caption: "엔탈피", width: '33%', alignment: 'center', format: 'fixedPoint', precision: 2 } ], // 엑셀 출력 "export": { enabled: true, fileName: '에너지 사용량(엔탈피)' } }; // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가 return viewModel; };