Passed
Push — master ( 6677f6...de33b9 )
by Guangyu
04:41 queued 10s
created

src/components/MyEMS/Space/SpaceEfficiency.js   A

Complexity

Total Complexity 19
Complexity/F 0

Size

Lines of Code 484
Function Count 0

Duplication

Duplicated Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
wmc 19
eloc 426
mnd 19
bc 19
fnc 0
dl 0
loc 484
rs 10
bpm 0
cpm 0
noi 0
c 0
b 0
f 0
1
import React, { Fragment, useEffect, useState } 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
} from 'reactstrap';
17
import CountUp from 'react-countup';
18
import Datetime from 'react-datetime';
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 LineChart from '../common/LineChart';
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 { APIBaseURL } from '../../../config';
29
import { periodTypeOptions } from '../common/PeriodTypeOptions';
30
import { comparisonTypeOptions } from '../common/ComparisonTypeOptions';
31
32
33
const DetailedDataTable = loadable(() => import('../common/DetailedDataTable'));
34
35
const SpaceEfficiency = ({ setRedirect, setRedirectUrl, t }) => {
36
  let current_moment = moment();
37
  useEffect(() => {
38
    let is_logged_in = getCookieValue('is_logged_in');
39
    let user_name = getCookieValue('user_name');
40
    let user_display_name = getCookieValue('user_display_name');
41
    let user_uuid = getCookieValue('user_uuid');
42
    let token = getCookieValue('token');
43
    if (is_logged_in === null || !is_logged_in) {
44
      setRedirectUrl(`/authentication/basic/login`);
45
      setRedirect(true);
46
    } else {
47
      //update expires time of cookies
48
      createCookie('is_logged_in', true, 1000 * 60 * 60 * 8);
49
      createCookie('user_name', user_name, 1000 * 60 * 60 * 8);
50
      createCookie('user_display_name', user_display_name, 1000 * 60 * 60 * 8);
51
      createCookie('user_uuid', user_uuid, 1000 * 60 * 60 * 8);
52
      createCookie('token', token, 1000 * 60 * 60 * 8);
53
    }
54
  });
55
  // State
56
  // Query Parameters
57
  const [selectedSpaceName, setSelectedSpaceName] = useState(undefined);
58
  const [selectedSpaceID, setSelectedSpaceID] = useState(undefined);
59
  const [comparisonType, setComparisonType] = useState('month-on-month');
60
  const [periodType, setPeriodType] = useState('daily');
61
  const [basePeriodBeginsDatetime, setBasePeriodBeginsDatetime] = useState(current_moment.clone().subtract(1, 'months').startOf('month'));
62
  const [basePeriodEndsDatetime, setBasePeriodEndsDatetime] = useState(current_moment.clone().subtract(1, 'months'));
63
  const [basePeriodBeginsDatetimeDisabled, setBasePeriodBeginsDatetimeDisabled] = useState(true);
64
  const [basePeriodEndsDatetimeDisabled, setBasePeriodEndsDatetimeDisabled] = useState(true);
65
  const [reportingPeriodBeginsDatetime, setReportingPeriodBeginsDatetime] = useState(current_moment.clone().startOf('month'));
66
  const [reportingPeriodEndsDatetime, setReportingPeriodEndsDatetime] = useState(current_moment);
67
  const [cascaderOptions, setCascaderOptions] = useState(undefined);
68
  
69
  //Results
70
  const [cardSummaryList, setCardSummaryList] = useState([]);
71
  const [spaceLineChartLabels, setSpaceLineChartLabels] = useState([]);
72
  const [spaceLineChartData, setSpaceLineChartData] = useState({});
73
  const [spaceLineChartOptions, setSpaceLineChartOptions] = useState([]);
74
  
75
  const [parameterLineChartLabels, setParameterLineChartLabels] = useState([]);
76
  const [parameterLineChartData, setParameterLineChartData] = useState({});
77
  const [parameterLineChartOptions, setParameterLineChartOptions] = useState([]);
78
  
79
  const [detailedDataTableData, setDetailedDataTableData] = useState([]);
80
  const [detailedDataTableColumns, setDetailedDataTableColumns] = useState([{dataField: 'startdatetime', text: t('Datetime'), sort: true}]);
81
  
82
83
  useEffect(() => {
84
    let isResponseOK = false;
85
    fetch(APIBaseURL + '/spaces/tree', {
86
      method: 'GET',
87
      headers: {
88
        "Content-type": "application/json",
89
        "User-UUID": getCookieValue('user_uuid'),
90
        "Token": getCookieValue('token')
91
      },
92
      body: null,
93
94
    }).then(response => {
95
      console.log(response);
96
      if (response.ok) {
97
        isResponseOK = true;
98
      }
99
      return response.json();
100
    }).then(json => {
101
      console.log(json);
102
      if (isResponseOK) {
103
        // rename keys 
104
        json = JSON.parse(JSON.stringify([json]).split('"id":').join('"value":').split('"name":').join('"label":'));
105
        setCascaderOptions(json);
106
        setSelectedSpaceName([json[0]].map(o => o.label));
107
        setSelectedSpaceID([json[0]].map(o => o.value));
108
      } else {
109
        toast.error(json.description);
110
      }
111
    }).catch(err => {
112
      console.log(err);
113
    });
114
115
  }, []);
116
117
  const labelClasses = 'ls text-uppercase text-600 font-weight-semi-bold mb-0';
118
  
119
  let onSpaceCascaderChange = (value, selectedOptions) => {
120
    console.log(value, selectedOptions);
121
    setSelectedSpaceName(selectedOptions.map(o => o.label).join('/'));
122
    setSelectedSpaceID(value[value.length - 1]);
123
  }
124
125
126
  let onComparisonTypeChange = ({ target }) => {
127
    console.log(target.value);
128
    setComparisonType(target.value);
129
    if (target.value === 'year-over-year') {
130
      setBasePeriodBeginsDatetimeDisabled(true);
131
      setBasePeriodEndsDatetimeDisabled(true);
132
      setBasePeriodBeginsDatetime(moment(reportingPeriodBeginsDatetime).subtract(1, 'years'));
133
      setBasePeriodEndsDatetime(moment(reportingPeriodEndsDatetime).subtract(1, 'years'));
134
    } else if (target.value === 'month-on-month') {
135
      setBasePeriodBeginsDatetimeDisabled(true);
136
      setBasePeriodEndsDatetimeDisabled(true);
137
      setBasePeriodBeginsDatetime(moment(reportingPeriodBeginsDatetime).subtract(1, 'months'));
138
      setBasePeriodEndsDatetime(moment(reportingPeriodEndsDatetime).subtract(1, 'months'));
139
    } else if (target.value === 'free-comparison') {
140
      setBasePeriodBeginsDatetimeDisabled(false);
141
      setBasePeriodEndsDatetimeDisabled(false);
142
    } else if (target.value === 'none-comparison') {
143
      setBasePeriodBeginsDatetime(undefined);
144
      setBasePeriodEndsDatetime(undefined);
145
      setBasePeriodBeginsDatetimeDisabled(true);
146
      setBasePeriodEndsDatetimeDisabled(true);
147
    }
148
  }
149
150
  let onBasePeriodBeginsDatetimeChange = (newDateTime) => {
151
    setBasePeriodBeginsDatetime(newDateTime);
152
  }
153
154
  let onBasePeriodEndsDatetimeChange = (newDateTime) => {
155
    setBasePeriodEndsDatetime(newDateTime);
156
  }
157
158
  let onReportingPeriodBeginsDatetimeChange = (newDateTime) => {
159
    setReportingPeriodBeginsDatetime(newDateTime);
160
    if (comparisonType === 'year-over-year') {
161
      setBasePeriodBeginsDatetime(newDateTime.clone().subtract(1, 'years'));
162
    } else if (comparisonType === 'month-on-month') {
163
      setBasePeriodBeginsDatetime(newDateTime.clone().subtract(1, 'months'));
164
    }
165
  }
166
167
  let onReportingPeriodEndsDatetimeChange = (newDateTime) => {
168
    setReportingPeriodEndsDatetime(newDateTime);
169
    if (comparisonType === 'year-over-year') {
170
      setBasePeriodEndsDatetime(newDateTime.clone().subtract(1, 'years'));
171
    } else if (comparisonType === 'month-on-month') {
172
      setBasePeriodEndsDatetime(newDateTime.clone().subtract(1, 'months'));
173
    }
174
  }
175
176
  var getValidBasePeriodBeginsDatetimes = function (currentDate) {
177
    return currentDate.isBefore(moment(basePeriodEndsDatetime, 'MM/DD/YYYY, hh:mm:ss a'));
178
  }
179
180
  var getValidBasePeriodEndsDatetimes = function (currentDate) {
181
    return currentDate.isAfter(moment(basePeriodBeginsDatetime, 'MM/DD/YYYY, hh:mm:ss a'));
182
  }
183
184
  var getValidReportingPeriodBeginsDatetimes = function (currentDate) {
185
    return currentDate.isBefore(moment(reportingPeriodEndsDatetime, 'MM/DD/YYYY, hh:mm:ss a'));
186
  }
187
188
  var getValidReportingPeriodEndsDatetimes = function (currentDate) {
189
    return currentDate.isAfter(moment(reportingPeriodBeginsDatetime, 'MM/DD/YYYY, hh:mm:ss a'));
190
  }
191
192
  // Handler
193
  const handleSubmit = e => {
194
    e.preventDefault();
195
    console.log('handleSubmit');
196
    console.log(selectedSpaceID);
197
    console.log(comparisonType);
198
    console.log(periodType);
199
    console.log(basePeriodBeginsDatetime != null ? basePeriodBeginsDatetime.format('YYYY-MM-DDTHH:mm:ss') : undefined);
200
    console.log(basePeriodEndsDatetime != null ? basePeriodEndsDatetime.format('YYYY-MM-DDTHH:mm:ss') : undefined);
201
    console.log(reportingPeriodBeginsDatetime.format('YYYY-MM-DDTHH:mm:ss'));
202
    console.log(reportingPeriodEndsDatetime.format('YYYY-MM-DDTHH:mm:ss'));
203
    
204
    // Reinitialize tables
205
    setDetailedDataTableData([]);
206
207
    let isResponseOK = false;
208
    fetch(APIBaseURL + '/reports/spaceefficiency?' +
209
      'spaceid=' + selectedSpaceID +
210
      '&periodtype=' + periodType +
211
      '&baseperiodstartdatetime=' + (basePeriodBeginsDatetime != null ? basePeriodBeginsDatetime.format('YYYY-MM-DDTHH:mm:ss') : '') +
212
      '&baseperiodenddatetime=' + (basePeriodEndsDatetime != null ? basePeriodEndsDatetime.format('YYYY-MM-DDTHH:mm:ss') : '') +
213
      '&reportingperiodstartdatetime=' + reportingPeriodBeginsDatetime.format('YYYY-MM-DDTHH:mm:ss') +
214
      '&reportingperiodenddatetime=' + reportingPeriodEndsDatetime.format('YYYY-MM-DDTHH:mm:ss'), {
215
      method: 'GET',
216
      headers: {
217
        "Content-type": "application/json",
218
        "User-UUID": getCookieValue('user_uuid'),
219
        "Token": getCookieValue('token')
220
      },
221
      body: null,
222
223
    }).then(response => {
224
      if (response.ok) {
225
        isResponseOK = true;
226
      }
227
      return response.json();
228
    }).then(json => {
229
      if (isResponseOK) {
230
        console.log(json)
231
        let cardSummaryArray = []
232
        json['reporting_period_efficiency']['names'].forEach((currentValue, index) => {
233
          let cardSummaryItem = {}
234
          cardSummaryItem['name'] = json['reporting_period_efficiency']['names'][index];
235
          cardSummaryItem['unit'] = json['reporting_period_efficiency']['units'][index];
236
          cardSummaryItem['cumulation'] = json['reporting_period_efficiency']['cumulations'][index];
237
          cardSummaryItem['increment_rate'] = parseFloat(json['reporting_period_efficiency']['increment_rates'][index] * 100).toFixed(2) + "%";
238
          cardSummaryArray.push(cardSummaryItem);
239
        });
240
        setCardSummaryList(cardSummaryArray);
241
      
242
        let timestamps = {}
243
        json['reporting_period_efficiency']['timestamps'].forEach((currentValue, index) => {
244
          timestamps['a' + index] = currentValue;
245
        });
246
        setSpaceLineChartLabels(timestamps);
247
        
248
        let values = {}
249
        json['reporting_period_efficiency']['values'].forEach((currentValue, index) => {
250
          values['a' + index] = currentValue;
251
        });
252
        setSpaceLineChartData(values);
253
        
254
        let names = Array();
255
        json['reporting_period_efficiency']['names'].forEach((currentValue, index) => {
256
          let unit = json['reporting_period_efficiency']['units'][index];
257
          names.push({ 'value': 'a' + index, 'label': currentValue + ' (' + unit + ')'});
258
        });
259
        setSpaceLineChartOptions(names);
260
       
261
        timestamps = {}
262
        json['parameters']['timestamps'].forEach((currentValue, index) => {
263
          timestamps['a' + index] = currentValue;
264
        });
265
        setParameterLineChartLabels(timestamps);
266
267
        values = {}
268
        json['parameters']['values'].forEach((currentValue, index) => {
269
          values['a' + index] = currentValue;
270
        });
271
        setParameterLineChartData(values);
272
      
273
        names = Array();
274
        json['parameters']['names'].forEach((currentValue, index) => {
275
          if (currentValue.startsWith('TARIFF-')) {
276
            currentValue = t('Tariff') + currentValue.replace('TARIFF-', '-');
277
          }
278
          
279
          names.push({ 'value': 'a' + index, 'label': currentValue });
280
        });
281
        setParameterLineChartOptions(names);
282
      
283
        let detailed_value_list = [];
284
        json['reporting_period_efficiency']['timestamps'][0].forEach((currentTimestamp, timestampIndex) => {
285
          let detailed_value = {};
286
          detailed_value['id'] = timestampIndex;
287
          detailed_value['startdatetime'] = currentTimestamp;
288
          json['reporting_period_efficiency']['values'].forEach((currentValue, energyCategoryIndex) => {
289
            if (json['reporting_period_efficiency']['values'][energyCategoryIndex][timestampIndex] != null) {
290
              detailed_value['a' + 2 * energyCategoryIndex] = json['reporting_period_efficiency']['values'][energyCategoryIndex][timestampIndex].toFixed(2);
291
            } else {
292
              detailed_value['a' + 2 * energyCategoryIndex] = '';
293
            };
294
          });
295
           
296
          detailed_value_list.push(detailed_value);
297
        });
298
299
        let detailed_value = {};
300
        detailed_value['id'] = detailed_value_list.length;
301
        detailed_value['startdatetime'] = t('Subtotal');
302
        json['reporting_period_efficiency']['cumulations'].forEach((currentValue, index) => {
303
            detailed_value['a' + index] = currentValue.toFixed(2);
304
          });
305
        detailed_value_list.push(detailed_value);
306
        setDetailedDataTableData(detailed_value_list);
307
        
308
        let detailed_column_list = [];
309
        detailed_column_list.push({
310
          dataField: 'startdatetime',
311
          text: t('Datetime'),
312
          sort: true
313
        })
314
        json['reporting_period_efficiency']['names'].forEach((currentValue, index) => {
315
          let unit = json['reporting_period_efficiency']['units'][index];
316
          detailed_column_list.push({
317
            dataField: 'a' + index,
318
            text: currentValue + ' (' + unit + ')',
319
            sort: true
320
          })
321
        });
322
        setDetailedDataTableColumns(detailed_column_list);
323
      } else {
324
        toast.error(json.description)
325
      }
326
    }).catch(err => {
327
      console.log(err);
328
    }); 
329
  
330
  };
331
332
  return (
333
    <Fragment>
334
      <div>
335
        <Breadcrumb>
336
          <BreadcrumbItem>{t('Space Data')}</BreadcrumbItem><BreadcrumbItem active>{t('Efficiency')}</BreadcrumbItem>
337
        </Breadcrumb>
338
      </div>
339
      <Card className="bg-light mb-3">
340
        <CardBody className="p-3">
341
          <Form onSubmit={handleSubmit}>
342
            <Row form>
343
              <Col xs="auto">
344
                <FormGroup className="form-group">
345
                  <Label className={labelClasses} for="space">
346
                    {t('Space')}
347
                  </Label>
348
                  <br />
349
                  <Cascader options={cascaderOptions}
350
                    onChange={onSpaceCascaderChange}
351
                    changeOnSelect
352
                    expandTrigger="hover">
353
                    <Input value={selectedSpaceName || ''} readOnly />
354
                  </Cascader>
355
                </FormGroup>
356
              </Col>
357
              
358
              <Col xs="auto">
359
                <FormGroup>
360
                  <Label className={labelClasses} for="comparisonType">
361
                    {t('Comparison Types')}
362
                  </Label>
363
                  <CustomInput type="select" id="comparisonType" name="comparisonType"
364
                    defaultValue="month-on-month"
365
                    onChange={onComparisonTypeChange}
366
                  >
367
                    {comparisonTypeOptions.map((comparisonType, index) => (
368
                      <option value={comparisonType.value} key={comparisonType.value} >
369
                        {t(comparisonType.label)}
370
                      </option>
371
                    ))}
372
                  </CustomInput>
373
                </FormGroup>
374
              </Col>
375
              <Col xs="auto">
376
                <FormGroup>
377
                  <Label className={labelClasses} for="periodType">
378
                    {t('Period Types')}
379
                  </Label>
380
                  <CustomInput type="select" id="periodType" name="periodType" defaultValue="daily" onChange={({ target }) => setPeriodType(target.value)}
381
                  >
382
                    {periodTypeOptions.map((periodType, index) => (
383
                      <option value={periodType.value} key={periodType.value} >
384
                        {t(periodType.label)}
385
                      </option>
386
                    ))}
387
                  </CustomInput>
388
                </FormGroup>
389
              </Col>
390
              <Col xs="auto">
391
                <FormGroup className="form-group">
392
                  <Label className={labelClasses} for="basePeriodBeginsDatetime">
393
                    {t('Base Period Begins')}{t('(Optional)')}
394
                  </Label>
395
                  <Datetime id='basePeriodBeginsDatetime'
396
                    value={basePeriodBeginsDatetime}
397
                    inputProps={{ disabled: basePeriodBeginsDatetimeDisabled }}
398
                    onChange={onBasePeriodBeginsDatetimeChange}
399
                    isValidDate={getValidBasePeriodBeginsDatetimes}
400
                    closeOnSelect={true} />
401
                </FormGroup>
402
              </Col>
403
              <Col xs="auto">
404
                <FormGroup className="form-group">
405
                  <Label className={labelClasses} for="basePeriodEndsDatetime">
406
                    {t('Base Period Ends')}{t('(Optional)')}
407
                  </Label>
408
                  <Datetime id='basePeriodEndsDatetime'
409
                    value={basePeriodEndsDatetime}
410
                    inputProps={{ disabled: basePeriodEndsDatetimeDisabled }}
411
                    onChange={onBasePeriodEndsDatetimeChange}
412
                    isValidDate={getValidBasePeriodEndsDatetimes}
413
                    closeOnSelect={true} />
414
                </FormGroup>
415
              </Col>
416
              <Col xs="auto">
417
                <FormGroup className="form-group">
418
                  <Label className={labelClasses} for="reportingPeriodBeginsDatetime">
419
                    {t('Reporting Period Begins')}
420
                  </Label>
421
                  <Datetime id='reportingPeriodBeginsDatetime'
422
                    value={reportingPeriodBeginsDatetime}
423
                    onChange={onReportingPeriodBeginsDatetimeChange}
424
                    isValidDate={getValidReportingPeriodBeginsDatetimes}
425
                    closeOnSelect={true} />
426
                </FormGroup>
427
              </Col>
428
              <Col xs="auto">
429
                <FormGroup className="form-group">
430
                  <Label className={labelClasses} for="reportingPeriodEndsDatetime">
431
                    {t('Reporting Period Ends')}
432
                  </Label>
433
                  <Datetime id='reportingPeriodEndsDatetime'
434
                    value={reportingPeriodEndsDatetime}
435
                    onChange={onReportingPeriodEndsDatetimeChange}
436
                    isValidDate={getValidReportingPeriodEndsDatetimes}
437
                    closeOnSelect={true} />
438
                </FormGroup>
439
              </Col>
440
              <Col xs="auto">
441
                <FormGroup>
442
                  <br></br>
443
                  <ButtonGroup id="submit">
444
                    <Button color="success" >{t('Submit')}</Button>
445
                  </ButtonGroup>
446
                </FormGroup>
447
              </Col>
448
            </Row>
449
          </Form>
450
        </CardBody>
451
      </Card>
452
      <div className="card-deck">
453
        {cardSummaryList.map(cardSummaryItem => (
454
          <CardSummary key={cardSummaryItem['name']}
455
            rate={cardSummaryItem['increment_rate']}
456
            title={t('Reporting Period Cumulative Efficiency NAME UNIT', { 'NAME': cardSummaryItem['name'], 'UNIT': '(' + cardSummaryItem['unit'] + ')' })}
457
            color="success" 
458
            >
459
            {cardSummaryItem['cumulation'] && <CountUp end={cardSummaryItem['cumulation']} duration={2} prefix="" separator="," decimal="." decimals={2} />}
460
          </CardSummary>
461
        ))}
462
      </div>
463
      <LineChart reportingTitle={t('Reporting Period Cumulative Efficiency VALUE UNIT', { 'VALUE': null, 'UNIT': null })}
464
        baseTitle=''
465
        labels={spaceLineChartLabels}
466
        data={spaceLineChartData}
467
        options={spaceLineChartOptions}>
468
      </LineChart>
469
      <LineChart reportingTitle={t('Related Parameters')}
470
        baseTitle=''
471
        labels={parameterLineChartLabels}
472
        data={parameterLineChartData}
473
        options={parameterLineChartOptions}>
474
      </LineChart>
475
      <DetailedDataTable data={detailedDataTableData} title={t('Detailed Data')} columns={detailedDataTableColumns} pagesize={50} >
476
      </DetailedDataTable>
477
      <br />
478
      
479
    </Fragment>
480
  );
481
};
482
483
export default withTranslation()(withRedirect(SpaceEfficiency));
484