Passed
Push — master ( ad5689...ea18a2 )
by Guangyu
08:17 queued 13s
created

myems-web/src/components/MyEMS/Equipment/EquipmentStatistics.js   B

Complexity

Total Complexity 42
Complexity/F 0

Size

Lines of Code 856
Function Count 0

Duplication

Duplicated Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
wmc 42
eloc 726
mnd 42
bc 42
fnc 0
dl 0
loc 856
rs 8.914
bpm 0
cpm 0
noi 0
c 0
b 0
f 0

How to fix   Complexity   

Complexity

Complex classes like myems-web/src/components/MyEMS/Equipment/EquipmentStatistics.js often do a lot of different things. To break such a class down, we need to identify a cohesive component within that class. A common approach to find such a component is to look for fields/methods that share the same prefixes, or suffixes.

Once you have determined the fields that belong together, you can apply the Extract Class refactoring. If the component makes sense as a sub-class, Extract Subclass is also a candidate, and is often faster.

1
import React, { Fragment, useEffect, useState, useContext } from 'react';
2
import {
3
  Breadcrumb,
4
  BreadcrumbItem,
5
  Row,
6
  Col,
7
  Card,
8
  CardBody,
9
  Button,
10
  ButtonGroup,
11
  Form,
12
  FormGroup,
13
  Input,
14
  Label,
15
  CustomInput,
16
  Spinner
17
} from 'reactstrap';
18
import CountUp from 'react-countup';
19
import moment from 'moment';
20
import loadable from '@loadable/component';
21
import Cascader from 'rc-cascader';
22
import CardSummary from '../common/CardSummary';
23
import MultiTrendChart from '../common/MultiTrendChart';
24
import { getCookieValue, createCookie } from '../../../helpers/utils';
25
import withRedirect from '../../../hoc/withRedirect';
26
import { withTranslation } from 'react-i18next';
27
import { toast } from 'react-toastify';
28
import ButtonIcon from '../../common/ButtonIcon';
29
import { APIBaseURL } from '../../../config';
30
import { periodTypeOptions } from '../common/PeriodTypeOptions';
31
import { comparisonTypeOptions } from '../common/ComparisonTypeOptions';
32
import DateRangePickerWrapper from '../common/DateRangePickerWrapper';
33
import { endOfDay} from 'date-fns';
34
import AppContext from '../../../context/Context';
35
import MultipleLineChart from '../common/MultipleLineChart';
36
37
const DetailedDataTable = loadable(() => import('../common/DetailedDataTable'));
38
39
const EquipmentStatistics = ({ setRedirect, setRedirectUrl, t }) => {
40
  let current_moment = moment();
41
  useEffect(() => {
42
    let is_logged_in = getCookieValue('is_logged_in');
43
    let user_name = getCookieValue('user_name');
44
    let user_display_name = getCookieValue('user_display_name');
45
    let user_uuid = getCookieValue('user_uuid');
46
    let token = getCookieValue('token');
47
    if (is_logged_in === null || !is_logged_in) {
48
      setRedirectUrl(`/authentication/basic/login`);
49
      setRedirect(true);
50
    } else {
51
      //update expires time of cookies
52
      createCookie('is_logged_in', true, 1000 * 60 * 10 * 1);
53
      createCookie('user_name', user_name, 1000 * 60 * 10 * 1);
54
      createCookie('user_display_name', user_display_name, 1000 * 60 * 10 * 1);
55
      createCookie('user_uuid', user_uuid, 1000 * 60 * 10 * 1);
56
      createCookie('token', token, 1000 * 60 * 10 * 1);
57
    }
58
  });
59
60
  useEffect(() => {
61
    let timer = setInterval(() => {
62
      let is_logged_in = getCookieValue('is_logged_in');
63
      if (is_logged_in === null || !is_logged_in) {
64
        setRedirectUrl(`/authentication/basic/login`);
65
        setRedirect(true);
66
      }
67
    }, 1000);
68
    return () => clearInterval(timer);
69
  }, [])
70
71
72
  // State
73
  // Query Parameters
74
  const [selectedSpaceName, setSelectedSpaceName] = useState(undefined);
75
  const [selectedSpaceID, setSelectedSpaceID] = useState(undefined);
76
  const [equipmentList, setEquipmentList] = useState([]);
77
  const [selectedEquipment, setSelectedEquipment] = useState(undefined);
78
  const [comparisonType, setComparisonType] = useState('month-on-month');
79
  const [periodType, setPeriodType] = useState('daily');
80
  const [cascaderOptions, setCascaderOptions] = useState(undefined);
81
  const [basePeriodDateRange, setBasePeriodDateRange] = useState([current_moment.clone().subtract(1, 'months').startOf('month').toDate(), current_moment.clone().subtract(1, 'months').toDate()]);
82
  const [basePeriodDateRangePickerDisabled, setBasePeriodDateRangePickerDisabled] = useState(true);
83
  const [reportingPeriodDateRange, setReportingPeriodDateRange] = useState([current_moment.clone().startOf('month').toDate(), current_moment.toDate()]);
84
  const dateRangePickerLocale = {
85
    sunday: t('sunday'),
86
    monday: t('monday'),
87
    tuesday: t('tuesday'),
88
    wednesday: t('wednesday'),
89
    thursday: t('thursday'),
90
    friday: t('friday'),
91
    saturday: t('saturday'),
92
    ok: t('ok'),
93
    today: t('today'),
94
    yesterday: t('yesterday'),
95
    hours: t('hours'),
96
    minutes: t('minutes'),
97
    seconds: t('seconds'),
98
    last7Days: t('last7Days'),
99
    formattedMonthPattern: 'yyyy-MM-dd'
100
  };
101
  const dateRangePickerStyle = { display: 'block', zIndex: 10};
102
  const { language } = useContext(AppContext);
103
104
  // buttons
105
  const [submitButtonDisabled, setSubmitButtonDisabled] = useState(true);
106
  const [spinnerHidden, setSpinnerHidden] = useState(true);
107
  const [exportButtonHidden, setExportButtonHidden] = useState(true);
108
109
  //Results
110
  const [cardSummaryList, setCardSummaryList] = useState([]);
111
112
  const [equipmentBaseAndReportingNames, setEquipmentBaseAndReportingNames] = useState({"a0":""});
113
  const [equipmentBaseAndReportingUnits, setEquipmentBaseAndReportingUnits] = useState({"a0":"()"});
114
115
  const [equipmentBaseLabels, setEquipmentBaseLabels] = useState({"a0": []});
116
  const [equipmentBaseData, setEquipmentBaseData] = useState({"a0": []});
117
  const [equipmentBaseSubtotals, setEquipmentBaseSubtotals] = useState({"a0": (0).toFixed(2)});
118
119
  const [equipmentReportingLabels, setEquipmentReportingLabels] = useState({"a0": []});
120
  const [equipmentReportingData, setEquipmentReportingData] = useState({"a0": []});
121
  const [equipmentReportingSubtotals, setEquipmentReportingSubtotals] = useState({"a0": (0).toFixed(2)});
122
123
  const [equipmentReportingRates, setEquipmentReportingRates] = useState({"a0": []});
124
  const [equipmentReportingOptions, setEquipmentReportingOptions] = useState([]);
125
126
  const [parameterLineChartLabels, setParameterLineChartLabels] = useState([]);
127
  const [parameterLineChartData, setParameterLineChartData] = useState({});
128
  const [parameterLineChartOptions, setParameterLineChartOptions] = useState([]);
129
130
  const [detailedDataTableData, setDetailedDataTableData] = useState([]);
131
  const [detailedDataTableColumns, setDetailedDataTableColumns] = useState([{dataField: 'startdatetime', text: t('Datetime'), sort: true}]);
132
  const [excelBytesBase64, setExcelBytesBase64] = useState(undefined);
133
134
  useEffect(() => {
135
    let isResponseOK = false;
136
    fetch(APIBaseURL + '/spaces/tree', {
137
      method: 'GET',
138
      headers: {
139
        "Content-type": "application/json",
140
        "User-UUID": getCookieValue('user_uuid'),
141
        "Token": getCookieValue('token')
142
      },
143
      body: null,
144
145
    }).then(response => {
146
      console.log(response);
147
      if (response.ok) {
148
        isResponseOK = true;
149
      }
150
      return response.json();
151
    }).then(json => {
152
      console.log(json);
153
      if (isResponseOK) {
154
        // rename keys 
155
        json = JSON.parse(JSON.stringify([json]).split('"id":').join('"value":').split('"name":').join('"label":'));
156
        setCascaderOptions(json);
157
        setSelectedSpaceName([json[0]].map(o => o.label));
158
        setSelectedSpaceID([json[0]].map(o => o.value));
159
        // get Equipments by root Space ID
160
        let isResponseOK = false;
161
        fetch(APIBaseURL + '/spaces/' + [json[0]].map(o => o.value) + '/equipments', {
162
          method: 'GET',
163
          headers: {
164
            "Content-type": "application/json",
165
            "User-UUID": getCookieValue('user_uuid'),
166
            "Token": getCookieValue('token')
167
          },
168
          body: null,
169
170
        }).then(response => {
171
          if (response.ok) {
172
            isResponseOK = true;
173
          }
174
          return response.json();
175
        }).then(json => {
176
          if (isResponseOK) {
177
            json = JSON.parse(JSON.stringify([json]).split('"id":').join('"value":').split('"name":').join('"label":'));
178
            console.log(json);
179
            setEquipmentList(json[0]);
180
            if (json[0].length > 0) {
181
              setSelectedEquipment(json[0][0].value);
182
              // enable submit button
183
              setSubmitButtonDisabled(false);
184
            } else {
185
              setSelectedEquipment(undefined);
186
              // disable submit button
187
              setSubmitButtonDisabled(true);
188
            }
189
          } else {
190
            toast.error(t(json.description))
191
          }
192
        }).catch(err => {
193
          console.log(err);
194
        });
195
        // end of get Equipments by root Space ID
196
      } else {
197
        toast.error(t(json.description));
198
      }
199
    }).catch(err => {
200
      console.log(err);
201
    });
202
203
  }, []);
204
205
  const labelClasses = 'ls text-uppercase text-600 font-weight-semi-bold mb-0';
206
207
  let onSpaceCascaderChange = (value, selectedOptions) => {
208
    setSelectedSpaceName(selectedOptions.map(o => o.label).join('/'));
209
    setSelectedSpaceID(value[value.length - 1]);
210
211
    let isResponseOK = false;
212
    fetch(APIBaseURL + '/spaces/' + value[value.length - 1] + '/equipments', {
213
      method: 'GET',
214
      headers: {
215
        "Content-type": "application/json",
216
        "User-UUID": getCookieValue('user_uuid'),
217
        "Token": getCookieValue('token')
218
      },
219
      body: null,
220
221
    }).then(response => {
222
      if (response.ok) {
223
        isResponseOK = true;
224
      }
225
      return response.json();
226
    }).then(json => {
227
      if (isResponseOK) {
228
        json = JSON.parse(JSON.stringify([json]).split('"id":').join('"value":').split('"name":').join('"label":'));
229
        console.log(json)
230
        setEquipmentList(json[0]);
231
        if (json[0].length > 0) {
232
          setSelectedEquipment(json[0][0].value);
233
          // enable submit button
234
          setSubmitButtonDisabled(false);
235
        } else {
236
          setSelectedEquipment(undefined);
237
          // disable submit button
238
          setSubmitButtonDisabled(true);
239
        }
240
      } else {
241
        toast.error(t(json.description))
242
      }
243
    }).catch(err => {
244
      console.log(err);
245
    });
246
  }
247
248
249
  let onComparisonTypeChange = ({ target }) => {
250
    console.log(target.value);
251
    setComparisonType(target.value);
252
    if (target.value === 'year-over-year') {
253
      setBasePeriodDateRangePickerDisabled(true);
254
      setBasePeriodDateRange([moment(reportingPeriodDateRange[0]).subtract(1, 'years').toDate(),
255
        moment(reportingPeriodDateRange[1]).subtract(1, 'years').toDate()]);
256
    } else if (target.value === 'month-on-month') {
257
      setBasePeriodDateRangePickerDisabled(true);
258
      setBasePeriodDateRange([moment(reportingPeriodDateRange[0]).subtract(1, 'months').toDate(),
259
        moment(reportingPeriodDateRange[1]).subtract(1, 'months').toDate()]);
260
    } else if (target.value === 'free-comparison') {
261
      setBasePeriodDateRangePickerDisabled(false);
262
    } else if (target.value === 'none-comparison') {
263
      setBasePeriodDateRange([null, null]);
264
      setBasePeriodDateRangePickerDisabled(true);
265
    }
266
  };
267
268
  // Callback fired when value changed
269
  let onBasePeriodChange = (DateRange) => {
270
    if(DateRange == null) {
271
      setBasePeriodDateRange([null, null]);
272
    } else {
273
      if (moment(DateRange[1]).format('HH:mm:ss') == '00:00:00') {
274
        // if the user did not change time value, set the default time to the end of day
275
        DateRange[1] = endOfDay(DateRange[1]);
276
      }
277
      setBasePeriodDateRange([DateRange[0], DateRange[1]]);
278
    }
279
  };
280
281
  // Callback fired when value changed
282
  let onReportingPeriodChange = (DateRange) => {
283
    if(DateRange == null) {
284
      setReportingPeriodDateRange([null, null]);
285
    } else {
286
      if (moment(DateRange[1]).format('HH:mm:ss') == '00:00:00') {
287
        // if the user did not change time value, set the default time to the end of day
288
        DateRange[1] = endOfDay(DateRange[1]);
289
      }
290
      setReportingPeriodDateRange([DateRange[0], DateRange[1]]);
291
      if (comparisonType === 'year-over-year') {
292
        setBasePeriodDateRange([moment(DateRange[0]).clone().subtract(1, 'years').toDate(), moment(DateRange[1]).clone().subtract(1, 'years').toDate()]);
293
      } else if (comparisonType === 'month-on-month') {
294
        setBasePeriodDateRange([moment(DateRange[0]).clone().subtract(1, 'months').toDate(), moment(DateRange[1]).clone().subtract(1, 'months').toDate()]);
295
      }
296
    }
297
  };
298
299
  // Callback fired when value clean
300
  let onBasePeriodClean = event => {
301
    setBasePeriodDateRange([null, null]);
302
  };
303
304
  // Callback fired when value clean
305
  let onReportingPeriodClean = event => {
306
    setReportingPeriodDateRange([null, null]);
307
  };
308
309
  const isBasePeriodTimestampExists = (base_period_data) => {
310
    const timestamps = base_period_data['timestamps'];
311
312
    if (timestamps.length === 0) {
313
      return false;
314
    }
315
316
    for (let i = 0; i < timestamps.length; i++) {
317
      if (timestamps[i].length > 0) {
318
        return true;
319
      }
320
    }
321
    return false
322
  }
323
324
  // Handler
325
  const handleSubmit = e => {
326
    e.preventDefault();
327
    console.log('handleSubmit');
328
    console.log(selectedSpaceID);
329
    console.log(selectedEquipment);
330
    console.log(comparisonType);
331
    console.log(periodType);
332
    console.log(basePeriodDateRange[0] != null ? moment(basePeriodDateRange[0]).format('YYYY-MM-DDTHH:mm:ss') : null)
333
    console.log(basePeriodDateRange[1] != null ? moment(basePeriodDateRange[1]).format('YYYY-MM-DDTHH:mm:ss') : null)
334
    console.log(moment(reportingPeriodDateRange[0]).format('YYYY-MM-DDTHH:mm:ss'))
335
    console.log(moment(reportingPeriodDateRange[1]).format('YYYY-MM-DDTHH:mm:ss'));
336
337
    // disable submit button
338
    setSubmitButtonDisabled(true);
339
    // show spinner
340
    setSpinnerHidden(false);
341
    // hide export button
342
    setExportButtonHidden(true)
343
344
    // Reinitialize tables
345
    setDetailedDataTableData([]);
346
    
347
    let isResponseOK = false;
348
    fetch(APIBaseURL + '/reports/equipmentstatistics?' +
349
      'equipmentid=' + selectedEquipment +
350
      '&periodtype=' + periodType +
351
      '&baseperiodstartdatetime=' + (basePeriodDateRange[0] != null ? moment(basePeriodDateRange[0]).format('YYYY-MM-DDTHH:mm:ss') : '') +
352
      '&baseperiodenddatetime=' + (basePeriodDateRange[1] != null ? moment(basePeriodDateRange[1]).format('YYYY-MM-DDTHH:mm:ss') : '') +
353
      '&reportingperiodstartdatetime=' + moment(reportingPeriodDateRange[0]).format('YYYY-MM-DDTHH:mm:ss') +
354
      '&reportingperiodenddatetime=' + moment(reportingPeriodDateRange[1]).format('YYYY-MM-DDTHH:mm:ss') +
355
      '&language=' + language, {
356
      method: 'GET',
357
      headers: {
358
        "Content-type": "application/json",
359
        "User-UUID": getCookieValue('user_uuid'),
360
        "Token": getCookieValue('token')
361
      },
362
      body: null,
363
364
    }).then(response => {
365
      if (response.ok) {
366
        isResponseOK = true;
367
      };
368
      return response.json();
369
    }).then(json => {
370
      if (isResponseOK) {
371
        console.log(json)
372
373
        let cardSummaryArray = []
374
        json['reporting_period']['names'].forEach((currentValue, index) => {
375
          let cardSummaryItem = {}
376
          cardSummaryItem['name'] = json['reporting_period']['names'][index];
377
          cardSummaryItem['unit'] = json['reporting_period']['units'][index];
378
          cardSummaryItem['mean'] = json['reporting_period']['means'][index];
379
          cardSummaryItem['mean_increment_rate'] = parseFloat(json['reporting_period']['means_increment_rate'][index] * 100).toFixed(2) + "%";
380
          cardSummaryItem['median'] = json['reporting_period']['medians'][index];
381
          cardSummaryItem['median_increment_rate'] = parseFloat(json['reporting_period']['medians_increment_rate'][index] * 100).toFixed(2) + "%";
382
          cardSummaryItem['minimum'] = json['reporting_period']['minimums'][index];
383
          cardSummaryItem['minimum_increment_rate'] = parseFloat(json['reporting_period']['minimums_increment_rate'][index] * 100).toFixed(2) + "%";
384
          cardSummaryItem['maximum'] = json['reporting_period']['maximums'][index];
385
          cardSummaryItem['maximum_increment_rate'] = parseFloat(json['reporting_period']['maximums_increment_rate'][index] * 100).toFixed(2) + "%";
386
          cardSummaryItem['stdev'] = json['reporting_period']['stdevs'][index];
387
          cardSummaryItem['stdev_increment_rate'] = parseFloat(json['reporting_period']['stdevs_increment_rate'][index] * 100).toFixed(2) + "%";
388
          cardSummaryItem['variance'] = json['reporting_period']['variances'][index];
389
          cardSummaryItem['variance_increment_rate'] = parseFloat(json['reporting_period']['variances_increment_rate'][index] * 100).toFixed(2) + "%";
390
          cardSummaryArray.push(cardSummaryItem);
391
        });
392
        setCardSummaryList(cardSummaryArray);
393
394
        let base_timestamps = {}
395
        json['base_period']['timestamps'].forEach((currentValue, index) => {
396
          base_timestamps['a' + index] = currentValue;
397
        });
398
        setEquipmentBaseLabels(base_timestamps)
399
400
        let base_values = {}
401
        json['base_period']['values'].forEach((currentValue, index) => {
402
          base_values['a' + index] = currentValue;
403
        });
404
        setEquipmentBaseData(base_values)
405
406
        /*
407
        * Tip:
408
        *     base_names === reporting_names
409
        *     base_units === reporting_units
410
        * */
411
412
        let base_and_reporting_names = {}
413
        json['reporting_period']['names'].forEach((currentValue, index) => {
414
          base_and_reporting_names['a' + index] = currentValue;
415
        });
416
        setEquipmentBaseAndReportingNames(base_and_reporting_names)
417
418
        let base_and_reporting_units = {}
419
        json['reporting_period']['units'].forEach((currentValue, index) => {
420
          base_and_reporting_units['a' + index] = "("+currentValue+")";
421
        });
422
        setEquipmentBaseAndReportingUnits(base_and_reporting_units)
423
424
        let base_subtotals = {}
425
        json['base_period']['subtotals'].forEach((currentValue, index) => {
426
          base_subtotals['a' + index] = currentValue.toFixed(2);
427
        });
428
        setEquipmentBaseSubtotals(base_subtotals)
429
430
        let reporting_timestamps = {}
431
        json['reporting_period']['timestamps'].forEach((currentValue, index) => {
432
          reporting_timestamps['a' + index] = currentValue;
433
        });
434
        setEquipmentReportingLabels(reporting_timestamps);
435
436
        let reporting_values = {}
437
        json['reporting_period']['values'].forEach((currentValue, index) => {
438
          reporting_values['a' + index] = currentValue;
439
        });
440
        setEquipmentReportingData(reporting_values);
441
442
        let reporting_subtotals = {}
443
        json['reporting_period']['subtotals'].forEach((currentValue, index) => {
444
          reporting_subtotals['a' + index] = currentValue.toFixed(2);
445
        });
446
        setEquipmentReportingSubtotals(reporting_subtotals);
447
448
        let rates = {}
449
        json['reporting_period']['rates'].forEach((currentValue, index) => {
450
          let currentRate = Array();
451
          currentValue.forEach((rate) => {
452
            currentRate.push(rate ? parseFloat(rate * 100).toFixed(2) : '0.00');
453
          });
454
          rates['a' + index] = currentRate;
455
        });
456
        setEquipmentReportingRates(rates)
457
458
        let options = Array();
459
        json['reporting_period']['names'].forEach((currentValue, index) => {
460
          let unit = json['reporting_period']['units'][index];
461
          options.push({ 'value': 'a' + index, 'label': currentValue + ' (' + unit + ')'});
462
        });
463
        setEquipmentReportingOptions(options);
464
      
465
        let timestamps = {}
466
        json['parameters']['timestamps'].forEach((currentValue, index) => {
467
          timestamps['a' + index] = currentValue;
468
        });
469
        setParameterLineChartLabels(timestamps);
470
471
        let values = {}
472
        json['parameters']['values'].forEach((currentValue, index) => {
473
          values['a' + index] = currentValue;
474
        });
475
        setParameterLineChartData(values);
476
      
477
        let names = Array();
478
        json['parameters']['names'].forEach((currentValue, index) => {
479
          
480
          names.push({ 'value': 'a' + index, 'label': currentValue });
481
        });
482
        setParameterLineChartOptions(names);
483
484
        if(!isBasePeriodTimestampExists(json['base_period'])) {
485
          let detailed_value_list = [];
486
          if (json['reporting_period']['timestamps'].length > 0) {
487
            json['reporting_period']['timestamps'][0].forEach((currentTimestamp, timestampIndex) => {
488
              let detailed_value = {};
489
              detailed_value['id'] = timestampIndex;
490
              detailed_value['startdatetime'] = currentTimestamp;
491
              json['reporting_period']['values'].forEach((currentValue, energyCategoryIndex) => {
492
                detailed_value['a' + energyCategoryIndex] = json['reporting_period']['values'][energyCategoryIndex][timestampIndex];
493
              });
494
              detailed_value_list.push(detailed_value);
495
            });
496
          }
497
          ;
498
499
          let detailed_value = {};
500
          detailed_value['id'] = detailed_value_list.length;
501
          detailed_value['startdatetime'] = t('Subtotal');
502
          json['reporting_period']['subtotals'].forEach((currentValue, index) => {
503
            detailed_value['a' + index] = currentValue;
504
          });
505
          detailed_value_list.push(detailed_value);
506
          setTimeout(() => {
507
            setDetailedDataTableData(detailed_value_list);
508
          }, 0)
509
510
          let detailed_column_list = [];
511
          detailed_column_list.push({
512
            dataField: 'startdatetime',
513
            text: t('Datetime'),
514
            sort: true
515
          });
516
          json['reporting_period']['names'].forEach((currentValue, index) => {
517
            let unit = json['reporting_period']['units'][index];
518
            detailed_column_list.push({
519
              dataField: 'a' + index,
520
              text: currentValue + ' (' + unit + ')',
521
              sort: true,
522
              formatter: function (decimalValue) {
523
                if (typeof decimalValue === 'number') {
524
                  return decimalValue.toFixed(2);
525
                } else {
526
                  return null;
527
                }
528
              }
529
            });
530
          });
531
          setDetailedDataTableColumns(detailed_column_list);
532
        }else {
533
          /*
534
          * Tip:
535
          *     json['base_period']['names'] ===  json['reporting_period']['names']
536
          *     json['base_period']['units'] ===  json['reporting_period']['units']
537
          * */
538
          let detailed_column_list = [];
539
          detailed_column_list.push({
540
            dataField: 'basePeriodDatetime',
541
            text: t('Base Period') + ' - ' + t('Datetime'),
542
            sort: true
543
          })
544
545
          json['base_period']['names'].forEach((currentValue, index) => {
546
            let unit = json['base_period']['units'][index];
547
            detailed_column_list.push({
548
              dataField: 'a' + index,
549
              text: t('Base Period') + ' - ' + currentValue + ' (' + unit + ')',
550
              sort: true,
551
              formatter: function (decimalValue) {
552
                if (typeof decimalValue === 'number') {
553
                  return decimalValue.toFixed(2);
554
                } else {
555
                  return null;
556
                }
557
              }
558
            })
559
          });
560
561
          detailed_column_list.push({
562
            dataField: 'reportingPeriodDatetime',
563
            text: t('Reporting Period') + ' - ' + t('Datetime'),
564
            sort: true
565
          })
566
567
          json['reporting_period']['names'].forEach((currentValue, index) => {
568
            let unit = json['reporting_period']['units'][index];
569
            detailed_column_list.push({
570
              dataField: 'b' + index,
571
              text: t('Reporting Period') + ' - ' + currentValue + ' (' + unit + ')',
572
              sort: true,
573
              formatter: function (decimalValue) {
574
                if (typeof decimalValue === 'number') {
575
                  return decimalValue.toFixed(2);
576
                } else {
577
                  return null;
578
                }
579
              }
580
            })
581
          });
582
          setDetailedDataTableColumns(detailed_column_list);
583
584
          let detailed_value_list = [];
585
          if (json['base_period']['timestamps'].length > 0 || json['reporting_period']['timestamps'].length > 0) {
586
            const max_timestamps_length = json['base_period']['timestamps'][0].length >= json['reporting_period']['timestamps'][0].length ?
587
                json['base_period']['timestamps'][0].length : json['reporting_period']['timestamps'][0].length;
588
            for (let index = 0; index < max_timestamps_length; index++) {
589
              let detailed_value = {};
590
              detailed_value['id'] = index;
591
              detailed_value['basePeriodDatetime'] = index < json['base_period']['timestamps'][0].length ? json['base_period']['timestamps'][0][index] : null;
592
              json['base_period']['values'].forEach((currentValue, energyCategoryIndex) => {
593
                detailed_value['a' + energyCategoryIndex] = index < json['base_period']['values'][energyCategoryIndex].length ? json['base_period']['values'][energyCategoryIndex][index] : null;
594
              });
595
              detailed_value['reportingPeriodDatetime'] = index < json['reporting_period']['timestamps'][0].length ? json['reporting_period']['timestamps'][0][index] : null;
596
              json['reporting_period']['values'].forEach((currentValue, energyCategoryIndex) => {
597
                detailed_value['b' + energyCategoryIndex] = index < json['reporting_period']['values'][energyCategoryIndex].length ? json['reporting_period']['values'][energyCategoryIndex][index] : null;
598
              });
599
              detailed_value_list.push(detailed_value);
600
            }
601
602
            let detailed_value = {};
603
            detailed_value['id'] = detailed_value_list.length;
604
            detailed_value['basePeriodDatetime'] = t('Subtotal');
605
            json['base_period']['subtotals'].forEach((currentValue, index) => {
606
              detailed_value['a' + index] = currentValue;
607
            });
608
            detailed_value['reportingPeriodDatetime'] = t('Subtotal');
609
            json['reporting_period']['subtotals'].forEach((currentValue, index) => {
610
              detailed_value['b' + index] = currentValue;
611
            });
612
            detailed_value_list.push(detailed_value);
613
            setTimeout(() => {
614
              setDetailedDataTableData(detailed_value_list);
615
            }, 0)
616
          }
617
618
        }
619
        
620
        setExcelBytesBase64(json['excel_bytes_base64']);
621
622
        // enable submit button
623
        setSubmitButtonDisabled(false);
624
        // hide spinner
625
        setSpinnerHidden(true);
626
        // show export button
627
        setExportButtonHidden(false);
628
          
629
      } else {
630
        toast.error(t(json.description))
631
      }
632
    }).catch(err => {
633
      console.log(err);
634
    });
635
  };
636
637
  const handleExport = e => {
638
    e.preventDefault();
639
    const mimeType='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
640
    const fileName = 'equipmentstatistics.xlsx'
641
    var fileUrl = "data:" + mimeType + ";base64," + excelBytesBase64;
642
    fetch(fileUrl)
643
        .then(response => response.blob())
644
        .then(blob => {
645
            var link = window.document.createElement("a");
646
            link.href = window.URL.createObjectURL(blob, { type: mimeType });
647
            link.download = fileName;
648
            document.body.appendChild(link);
649
            link.click();
650
            document.body.removeChild(link);
651
        });
652
  };
653
  
654
655
656
  return (
657
    <Fragment>
658
      <div>
659
        <Breadcrumb>
660
          <BreadcrumbItem>{t('Equipment Data')}</BreadcrumbItem><BreadcrumbItem active>{t('Statistics')}</BreadcrumbItem>
661
        </Breadcrumb>
662
      </div>
663
      <Card className="bg-light mb-3">
664
        <CardBody className="p-3">
665
          <Form onSubmit={handleSubmit}>
666
            <Row form>
667
              <Col xs={6} sm={3}>
668
                <FormGroup className="form-group">
669
                  <Label className={labelClasses} for="space">
670
                    {t('Space')}
671
                  </Label>
672
                  <br />
673
                  <Cascader options={cascaderOptions}
674
                    onChange={onSpaceCascaderChange}
675
                    changeOnSelect
676
                    expandTrigger="hover">
677
                    <Input value={selectedSpaceName || ''} readOnly />
678
                  </Cascader>
679
                </FormGroup>
680
              </Col>
681
              <Col xs="auto">
682
                <FormGroup>
683
                  <Label className={labelClasses} for="equipmentSelect">
684
                    {t('Equipment')}
685
                  </Label>
686
                  <CustomInput type="select" id="equipmentSelect" name="equipmentSelect" onChange={({ target }) => setSelectedEquipment(target.value)}
687
                  >
688
                    {equipmentList.map((equipment, index) => (
689
                      <option value={equipment.value} key={equipment.value}>
690
                        {equipment.label}
691
                      </option>
692
                    ))}
693
                  </CustomInput>
694
                </FormGroup>
695
              </Col>
696
              <Col xs="auto">
697
                <FormGroup>
698
                  <Label className={labelClasses} for="comparisonType">
699
                    {t('Comparison Types')}
700
                  </Label>
701
                  <CustomInput type="select" id="comparisonType" name="comparisonType"
702
                    defaultValue="month-on-month"
703
                    onChange={onComparisonTypeChange}
704
                  >
705
                    {comparisonTypeOptions.map((comparisonType, index) => (
706
                      <option value={comparisonType.value} key={comparisonType.value} >
707
                        {t(comparisonType.label)}
708
                      </option>
709
                    ))}
710
                  </CustomInput>
711
                </FormGroup>
712
              </Col>
713
              <Col xs="auto">
714
                <FormGroup>
715
                  <Label className={labelClasses} for="periodType">
716
                    {t('Period Types')}
717
                  </Label>
718
                  <CustomInput type="select" id="periodType" name="periodType" defaultValue="daily" onChange={({ target }) => setPeriodType(target.value)}
719
                  >
720
                    {periodTypeOptions.map((periodType, index) => (
721
                      <option value={periodType.value} key={periodType.value} >
722
                        {t(periodType.label)}
723
                      </option>
724
                    ))}
725
                  </CustomInput>
726
                </FormGroup>
727
              </Col>
728
              <Col xs={6} sm={3}>
729
                <FormGroup className="form-group">
730
                  <Label className={labelClasses} for="basePeriodDateRangePicker">{t('Base Period')}{t('(Optional)')}</Label>
731
                  <DateRangePickerWrapper 
732
                    id='basePeriodDateRangePicker'
733
                    disabled={basePeriodDateRangePickerDisabled}
734
                    format="yyyy-MM-dd HH:mm:ss"
735
                    value={basePeriodDateRange}
736
                    onChange={onBasePeriodChange}
737
                    size="md"
738
                    style={dateRangePickerStyle}
739
                    onClean={onBasePeriodClean}
740
                    locale={dateRangePickerLocale}
741
                    placeholder={t("Select Date Range")}
742
                   />
743
                </FormGroup>
744
              </Col>
745
              <Col xs={6} sm={3}>
746
                <FormGroup className="form-group">
747
                  <Label className={labelClasses} for="reportingPeriodDateRangePicker">{t('Reporting Period')}</Label>
748
                  <br/>
749
                  <DateRangePickerWrapper
750
                    id='reportingPeriodDateRangePicker'
751
                    format="yyyy-MM-dd HH:mm:ss"
752
                    value={reportingPeriodDateRange}
753
                    onChange={onReportingPeriodChange}
754
                    size="md"
755
                    style={dateRangePickerStyle}
756
                    onClean={onReportingPeriodClean}
757
                    locale={dateRangePickerLocale}
758
                    placeholder={t("Select Date Range")}
759
                  />
760
                </FormGroup>
761
              </Col>
762
              <Col xs="auto">
763
                <FormGroup>
764
                  <br></br>
765
                  <ButtonGroup id="submit">
766
                    <Button color="success" disabled={submitButtonDisabled} >{t('Submit')}</Button>
767
                  </ButtonGroup>
768
                </FormGroup>
769
              </Col>
770
              <Col xs="auto">
771
                <FormGroup>
772
                  <br></br>
773
                  <Spinner color="primary" hidden={spinnerHidden}  />
774
                </FormGroup>
775
              </Col>
776
              <Col xs="auto">
777
                  <br></br>
778
                  <ButtonIcon icon="external-link-alt" transform="shrink-3 down-2" color="falcon-default" 
779
                  hidden={exportButtonHidden}
780
                  onClick={handleExport} >
781
                    {t('Export')}
782
                  </ButtonIcon>
783
              </Col>
784
            </Row>
785
          </Form>
786
        </CardBody>
787
      </Card>
788
      {cardSummaryList.map(cardSummaryItem => (
789
        <div className="card-deck" key={cardSummaryItem['name']}>
790
          <CardSummary key={cardSummaryItem['name'] + 'mean'}
791
            rate={cardSummaryItem['mean_increment_rate']}
792
            title={t('Reporting Period CATEGORY Mean UNIT', { 'CATEGORY': cardSummaryItem['name'], 'UNIT': '(' + cardSummaryItem['unit'] + ')' })}
793
            color="success" >
794
            {cardSummaryItem['mean'] && <CountUp end={cardSummaryItem['mean']} duration={2} prefix="" separator="," decimal="." decimals={2} />}
795
          </CardSummary>
796
          <CardSummary key={cardSummaryItem['name'] + 'median'}
797
            rate={cardSummaryItem['median_increment_rate']}
798
            title={t('Reporting Period CATEGORY Median UNIT', { 'CATEGORY': cardSummaryItem['name'], 'UNIT': '(' + cardSummaryItem['unit'] + ')' })}
799
            color="success" >
800
            {cardSummaryItem['median'] && <CountUp end={cardSummaryItem['median']} duration={2} prefix="" separator="," decimal="." decimals={2} />}
801
          </CardSummary>
802
          <CardSummary key={cardSummaryItem['name'] + 'minimum'}
803
            rate={cardSummaryItem['minimum_increment_rate']}
804
            title={t('Reporting Period CATEGORY Minimum UNIT', { 'CATEGORY': cardSummaryItem['name'], 'UNIT': '(' + cardSummaryItem['unit'] + ')' })}
805
            color="success" >
806
            {cardSummaryItem['minimum'] && <CountUp end={cardSummaryItem['minimum']} duration={2} prefix="" separator="," decimal="." decimals={2} />}
807
          </CardSummary>
808
          <CardSummary key={cardSummaryItem['name'] + 'maximum'}
809
            rate={cardSummaryItem['maximum_increment_rate']}
810
            title={t('Reporting Period CATEGORY Maximum UNIT', { 'CATEGORY': cardSummaryItem['name'], 'UNIT': '(' + cardSummaryItem['unit'] + ')' })}
811
            color="success" >
812
            {cardSummaryItem['maximum'] && <CountUp end={cardSummaryItem['maximum']} duration={2} prefix="" separator="," decimal="." decimals={2} />}
813
          </CardSummary>
814
          <CardSummary key={cardSummaryItem['name'] + 'stdev'}
815
            rate={cardSummaryItem['stdev_increment_rate']}
816
            title={t('Reporting Period CATEGORY Stdev UNIT', { 'CATEGORY': cardSummaryItem['name'], 'UNIT': '(' + cardSummaryItem['unit'] + ')' })}
817
            color="success" >
818
            {cardSummaryItem['stdev'] && <CountUp end={cardSummaryItem['stdev']} duration={2} prefix="" separator="," decimal="." decimals={2} />}
819
          </CardSummary>
820
          <CardSummary key={cardSummaryItem['name'] + 'variance'}
821
            rate={cardSummaryItem['variance_increment_rate']}
822
            title={t('Reporting Period CATEGORY Variance UNIT', { 'CATEGORY': cardSummaryItem['name'], 'UNIT': '(' + cardSummaryItem['unit'] + ')' })}
823
            color="success" >
824
            {cardSummaryItem['variance'] && <CountUp end={cardSummaryItem['variance']} duration={2} prefix="" separator="," decimal="." decimals={2} />}
825
          </CardSummary>
826
        </div>
827
      ))}
828
829
      <MultiTrendChart reportingTitle = {{"name": "Reporting Period Consumption CATEGORY VALUE UNIT", "substitute": ["CATEGORY", "VALUE", "UNIT"], "CATEGORY": equipmentBaseAndReportingNames, "VALUE": equipmentReportingSubtotals, "UNIT": equipmentBaseAndReportingUnits}}
830
        baseTitle = {{"name": "Base Period Consumption CATEGORY VALUE UNIT", "substitute": ["CATEGORY", "VALUE", "UNIT"], "CATEGORY": equipmentBaseAndReportingNames, "VALUE": equipmentBaseSubtotals, "UNIT": equipmentBaseAndReportingUnits}}
831
        reportingTooltipTitle = {{"name": "Reporting Period Consumption CATEGORY VALUE UNIT", "substitute": ["CATEGORY", "VALUE", "UNIT"], "CATEGORY": equipmentBaseAndReportingNames, "VALUE": null, "UNIT": equipmentBaseAndReportingUnits}}
832
        baseTooltipTitle = {{"name": "Base Period Consumption CATEGORY VALUE UNIT", "substitute": ["CATEGORY", "VALUE", "UNIT"], "CATEGORY": equipmentBaseAndReportingNames, "VALUE": null, "UNIT": equipmentBaseAndReportingUnits}}
833
        reportingLabels={equipmentReportingLabels}
834
        reportingData={equipmentReportingData}
835
        baseLabels={equipmentBaseLabels}
836
        baseData={equipmentBaseData}
837
        rates={equipmentReportingRates}
838
        options={equipmentReportingOptions}>
839
      </MultiTrendChart>
840
841
      <MultipleLineChart reportingTitle={t('Related Parameters')}
842
        baseTitle=''
843
        labels={parameterLineChartLabels}
844
        data={parameterLineChartData}
845
        options={parameterLineChartOptions}>
846
      </MultipleLineChart>
847
      <br />
848
      <DetailedDataTable data={detailedDataTableData} title={t('Detailed Data')} columns={detailedDataTableColumns} pagesize={50} >
849
      </DetailedDataTable>
850
851
    </Fragment>
852
  );
853
};
854
855
export default withTranslation()(withRedirect(EquipmentStatistics));
856