| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542 | 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;};
 |