123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156 |
- Partials.Reduce = function (params) {
- var tabs = [{ text: "전체" }, { text: "전기" }, { text: '가스' } ];
- var selectedTab = ko.observable(0);
- var dateBoxValue = ko.observable(new Date());
- var initialized = false;
- var dataSource;
- function createDataSource() {
- return new DevExpress.data.DataSource({
- store: Partials.api.RetrofitMonthly,
- paginate: false,
- map: function (item) {
- return item;
- },
- filter: [
- ["SiteId", "=", 1],
- ["BuildingId", "=", 1],
- ["Year", "=", dateBoxValue().getFullYear()]
- ]
- });
- }
- function load(result) {
- }
- dateBoxValue.subscribe(function (e) {
- handleViewShown();
- });
- selectedTab.subscribe(function (e) {
- //handleViewShown();
- });
- var linearRegression = function (data) {
- var sum = [0, 0, 0, 0, 0], n = 0, results = [];
- for (; n < data.length; n++) {
- if (data[n][1] != null) {
- sum[0] += data[n][0];
- sum[1] += data[n][1];
- sum[2] += data[n][0] * data[n][0];
- sum[3] += data[n][0] * data[n][1];
- sum[4] += data[n][1] * data[n][1];
- }
- }
- var gradient = (n * sum[3] - sum[0] * sum[1]) / (n * sum[2] - sum[0] * sum[0]);
- var intercept = (sum[1] / n) - (gradient * sum[0]) / n;
- for (var i = 0, len = data.length; i < len; i++) {
- var coordinate = [data[i][0], data[i][0] * gradient + intercept];
- results.push(coordinate);
- }
- var string = 'y = ' + Math.round(gradient * 100) / 100 + 'x + ' + Math.round(intercept * 100) / 100;
- return { equation: [gradient, intercept], points: results, string: string };
- };
- var handleViewShown = function () {
- if (initialized == false) {
- initialized = true;
- var dataGrid = $("#gridContainer").dxDataGrid("instance");
- dataGrid.option({
- "export": {
- enabled: true,
- fileName: "ReduceMonthly"
- },
- columns: [
- { dataField: 'Month', caption: '월', width: '3%', },
- { dataField: 'Baseyear.Measurement', caption: '사용량(kWh)', format: 'fixedPoint', cssClass: 'baseyear' },
- { dataField: 'Baseyear.Days', caption: '사용기간', format: 'fixedPoint', cssClass: 'baseyear' },
- { dataField: 'Baseyear.HDD', caption: 'HDD', format: 'fixedPoint', precision: 2, cssClass: 'baseyear' },
- { dataField: 'Baseyear.CDD', caption: 'CDD', format: 'fixedPoint', precision: 2, cssClass: 'baseyear' },
- { dataField: 'Regression', caption: 'Base(kWh)', format: 'fixedPoint', cssClass: 'baseyear' },
- { dataField: 'Estimate.Measurement', caption: '사용량(kWh)', format: 'fixedPoint', cssClass: 'estimate' },
- { dataField: 'Estimate.Days', caption: '사용기간', format: 'fixedPoint', cssClass: 'estimate' },
- { dataField: 'Estimate.HDD', caption: 'HDD', format: 'fixedPoint', precision: 2, cssClass: 'estimate' },
- { dataField: 'Estimate.CDD', caption: 'CDD', format: 'fixedPoint', precision: 2, cssClass: 'estimate' },
- { dataField: 'CommonReduce', caption: '단순 절감량', format: 'fixedPoint', cssClass: 'reduce' },
- { dataField: 'Normalization', caption: '정규화 절감량', format: 'fixedPoint', cssClass: 'reduce'},
- { dataField: 'ReduceRate', caption: '절감율(%)', format: 'fixedPoint', precision: 2, cssClass: 'reduce' },
- ]
- });
- $("#gaugeContainer").dxCircularGauge({
- value: viewModel.summary.reduce().rate,
- scale: {
- startValue: -100, endValue: 100,
- majorTick: { tickInterval: 10 }
- },
- rangeContainer: {
- ranges: [
- { startValue: -100, endValue: 0, color: '#92000A' },
- { startValue: 0, endValue: 100, color: '#00920A' },
- ],
- },
- geometry: {
- startAngle: 180, endAngle: 0
- },
- valueIndicator: {
- type: 'rectangleNeedle',
- color: '#9B870C'
- },
- });
- }
- Partials.api.get("RetrofitMonthly", { SiteId: 1, BuildingId: 1, Year: dateBoxValue().getFullYear() }).done(function (result) {
- $("#gridContainer").dxDataGrid("instance").option({ dataSource: result })
- var filter = result.filter(function (v) { if (v.Normalization && v.ReduceRate) { return v; } });
- viewModel.summary.reduce({
- amount: filter.reduce(function (p, c) { return p + c.Normalization; }, 0) / filter.length,
- rate: filter.reduce(function (p, c) { return p + c.ReduceRate; }, 0) / filter.length,
- });
- $("#gaugeContainer").dxCircularGauge("instance").value(viewModel.summary.reduce().rate);
- viewModel.rateText((viewModel.summary.reduce().rate > 0) ? '절감' : ((viewModel.summary.reduce().rate < 0) ? '증가' : ''));
- });
- };
- var viewModel = {
- dateBoxValue: dateBoxValue,
- dataSource: createDataSource(),
- tabs: tabs,
- selectedTab: selectedTab,
- viewShown: handleViewShown,
- rateText: ko.observable(''),
- summary : {
- reduce : ko.observable({
- amount : 0,
- rate: 0,
- }),
- },
- onPrevious: function (e) {
- var date = new Date(dateBoxValue());
- date.setFullYear(date.getFullYear() - 1);
- dateBoxValue(date);
- },
- onNext: function (e) {
- var date = new Date(dateBoxValue());
- date.setFullYear(date.getFullYear() + 1);
- dateBoxValue(date);
- }
- };
- return viewModel;
- };
|