|
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
|
|
|
Spinner, |
|
17
|
|
|
} from 'reactstrap'; |
|
18
|
|
|
import CountUp from 'react-countup'; |
|
19
|
|
|
import Datetime from 'react-datetime'; |
|
20
|
|
|
import moment from 'moment'; |
|
21
|
|
|
import Cascader from 'rc-cascader'; |
|
22
|
|
|
import CardSummary from '../common/CardSummary'; |
|
23
|
|
|
import LineChart from '../common/LineChart'; |
|
24
|
|
|
import SharePie from '../common/SharePie'; |
|
25
|
|
|
import loadable from '@loadable/component'; |
|
26
|
|
|
import { getCookieValue, createCookie } from '../../../helpers/utils'; |
|
27
|
|
|
import withRedirect from '../../../hoc/withRedirect'; |
|
28
|
|
|
import { withTranslation } from 'react-i18next'; |
|
29
|
|
|
import { toast } from 'react-toastify'; |
|
30
|
|
|
import ButtonIcon from '../../common/ButtonIcon'; |
|
31
|
|
|
import { APIBaseURL } from '../../../config'; |
|
32
|
|
|
import { periodTypeOptions } from '../common/PeriodTypeOptions'; |
|
33
|
|
|
import { comparisonTypeOptions } from '../common/ComparisonTypeOptions'; |
|
34
|
|
|
|
|
35
|
|
|
|
|
36
|
|
|
const DetailedDataTable = loadable(() => import('../common/DetailedDataTable')); |
|
37
|
|
|
|
|
38
|
|
|
const StoreCost = ({ setRedirect, setRedirectUrl, t }) => { |
|
39
|
|
|
let current_moment = moment(); |
|
40
|
|
|
useEffect(() => { |
|
41
|
|
|
let is_logged_in = getCookieValue('is_logged_in'); |
|
42
|
|
|
let user_name = getCookieValue('user_name'); |
|
43
|
|
|
let user_display_name = getCookieValue('user_display_name'); |
|
44
|
|
|
let user_uuid = getCookieValue('user_uuid'); |
|
45
|
|
|
let token = getCookieValue('token'); |
|
46
|
|
|
if (is_logged_in === null || !is_logged_in) { |
|
47
|
|
|
setRedirectUrl(`/authentication/basic/login`); |
|
48
|
|
|
setRedirect(true); |
|
49
|
|
|
} else { |
|
50
|
|
|
//update expires time of cookies |
|
51
|
|
|
createCookie('is_logged_in', true, 1000 * 60 * 60 * 8); |
|
52
|
|
|
createCookie('user_name', user_name, 1000 * 60 * 60 * 8); |
|
53
|
|
|
createCookie('user_display_name', user_display_name, 1000 * 60 * 60 * 8); |
|
54
|
|
|
createCookie('user_uuid', user_uuid, 1000 * 60 * 60 * 8); |
|
55
|
|
|
createCookie('token', token, 1000 * 60 * 60 * 8); |
|
56
|
|
|
} |
|
57
|
|
|
}); |
|
58
|
|
|
// State |
|
59
|
|
|
// Query Parameters |
|
60
|
|
|
const [selectedSpaceName, setSelectedSpaceName] = useState(undefined); |
|
61
|
|
|
const [selectedSpaceID, setSelectedSpaceID] = useState(undefined); |
|
62
|
|
|
const [storeList, setStoreList] = useState([]); |
|
63
|
|
|
const [selectedStore, setSelectedStore] = useState(undefined); |
|
64
|
|
|
const [comparisonType, setComparisonType] = useState('month-on-month'); |
|
65
|
|
|
const [periodType, setPeriodType] = useState('daily'); |
|
66
|
|
|
const [basePeriodBeginsDatetime, setBasePeriodBeginsDatetime] = useState(current_moment.clone().subtract(1, 'months').startOf('month')); |
|
67
|
|
|
const [basePeriodEndsDatetime, setBasePeriodEndsDatetime] = useState(current_moment.clone().subtract(1, 'months')); |
|
68
|
|
|
const [basePeriodBeginsDatetimeDisabled, setBasePeriodBeginsDatetimeDisabled] = useState(true); |
|
69
|
|
|
const [basePeriodEndsDatetimeDisabled, setBasePeriodEndsDatetimeDisabled] = useState(true); |
|
70
|
|
|
const [reportingPeriodBeginsDatetime, setReportingPeriodBeginsDatetime] = useState(current_moment.clone().startOf('month')); |
|
71
|
|
|
const [reportingPeriodEndsDatetime, setReportingPeriodEndsDatetime] = useState(current_moment); |
|
72
|
|
|
const [cascaderOptions, setCascaderOptions] = useState(undefined); |
|
73
|
|
|
|
|
74
|
|
|
// buttons |
|
75
|
|
|
const [submitButtonDisabled, setSubmitButtonDisabled] = useState(true); |
|
76
|
|
|
const [spinnerHidden, setSpinnerHidden] = useState(true); |
|
77
|
|
|
const [exportButtonHidden, setExportButtonHidden] = useState(true); |
|
78
|
|
|
|
|
79
|
|
|
//Results |
|
80
|
|
|
const [timeOfUseShareData, setTimeOfUseShareData] = useState([]); |
|
81
|
|
|
const [costShareData, setCostShareData] = useState([]); |
|
82
|
|
|
|
|
83
|
|
|
const [cardSummaryList, setCardSummaryList] = useState([]); |
|
84
|
|
|
const [storeLineChartLabels, setStoreLineChartLabels] = useState([]); |
|
85
|
|
|
const [storeLineChartData, setStoreLineChartData] = useState({}); |
|
86
|
|
|
const [storeLineChartOptions, setStoreLineChartOptions] = useState([]); |
|
87
|
|
|
|
|
88
|
|
|
const [parameterLineChartLabels, setParameterLineChartLabels] = useState([]); |
|
89
|
|
|
const [parameterLineChartData, setParameterLineChartData] = useState({}); |
|
90
|
|
|
const [parameterLineChartOptions, setParameterLineChartOptions] = useState([]); |
|
91
|
|
|
|
|
92
|
|
|
const [detailedDataTableData, setDetailedDataTableData] = useState([]); |
|
93
|
|
|
const [detailedDataTableColumns, setDetailedDataTableColumns] = useState([{dataField: 'startdatetime', text: t('Datetime'), sort: true}]); |
|
94
|
|
|
const [excelBytesBase64, setExcelBytesBase64] = useState(undefined); |
|
95
|
|
|
|
|
96
|
|
|
useEffect(() => { |
|
97
|
|
|
let isResponseOK = false; |
|
98
|
|
|
fetch(APIBaseURL + '/spaces/tree', { |
|
99
|
|
|
method: 'GET', |
|
100
|
|
|
headers: { |
|
101
|
|
|
"Content-type": "application/json", |
|
102
|
|
|
"User-UUID": getCookieValue('user_uuid'), |
|
103
|
|
|
"Token": getCookieValue('token') |
|
104
|
|
|
}, |
|
105
|
|
|
body: null, |
|
106
|
|
|
|
|
107
|
|
|
}).then(response => { |
|
108
|
|
|
console.log(response); |
|
109
|
|
|
if (response.ok) { |
|
110
|
|
|
isResponseOK = true; |
|
111
|
|
|
} |
|
112
|
|
|
return response.json(); |
|
113
|
|
|
}).then(json => { |
|
114
|
|
|
console.log(json); |
|
115
|
|
|
if (isResponseOK) { |
|
116
|
|
|
// rename keys |
|
117
|
|
|
json = JSON.parse(JSON.stringify([json]).split('"id":').join('"value":').split('"name":').join('"label":')); |
|
118
|
|
|
setCascaderOptions(json); |
|
119
|
|
|
setSelectedSpaceName([json[0]].map(o => o.label)); |
|
120
|
|
|
setSelectedSpaceID([json[0]].map(o => o.value)); |
|
121
|
|
|
// get Stores by root Space ID |
|
122
|
|
|
let isResponseOK = false; |
|
123
|
|
|
fetch(APIBaseURL + '/spaces/' + [json[0]].map(o => o.value) + '/stores', { |
|
124
|
|
|
method: 'GET', |
|
125
|
|
|
headers: { |
|
126
|
|
|
"Content-type": "application/json", |
|
127
|
|
|
"User-UUID": getCookieValue('user_uuid'), |
|
128
|
|
|
"Token": getCookieValue('token') |
|
129
|
|
|
}, |
|
130
|
|
|
body: null, |
|
131
|
|
|
|
|
132
|
|
|
}).then(response => { |
|
133
|
|
|
if (response.ok) { |
|
134
|
|
|
isResponseOK = true; |
|
135
|
|
|
} |
|
136
|
|
|
return response.json(); |
|
137
|
|
|
}).then(json => { |
|
138
|
|
|
if (isResponseOK) { |
|
139
|
|
|
json = JSON.parse(JSON.stringify([json]).split('"id":').join('"value":').split('"name":').join('"label":')); |
|
140
|
|
|
console.log(json); |
|
141
|
|
|
setStoreList(json[0]); |
|
142
|
|
|
if (json[0].length > 0) { |
|
143
|
|
|
setSelectedStore(json[0][0].value); |
|
144
|
|
|
// enable submit button |
|
145
|
|
|
setSubmitButtonDisabled(false); |
|
146
|
|
|
} else { |
|
147
|
|
|
setSelectedStore(undefined); |
|
148
|
|
|
// disable submit button |
|
149
|
|
|
setSubmitButtonDisabled(true); |
|
150
|
|
|
} |
|
151
|
|
|
} else { |
|
152
|
|
|
toast.error(json.description) |
|
153
|
|
|
} |
|
154
|
|
|
}).catch(err => { |
|
155
|
|
|
console.log(err); |
|
156
|
|
|
}); |
|
157
|
|
|
// end of get Stores by root Space ID |
|
158
|
|
|
} else { |
|
159
|
|
|
toast.error(json.description); |
|
160
|
|
|
} |
|
161
|
|
|
}).catch(err => { |
|
162
|
|
|
console.log(err); |
|
163
|
|
|
}); |
|
164
|
|
|
|
|
165
|
|
|
}, []); |
|
166
|
|
|
|
|
167
|
|
|
const labelClasses = 'ls text-uppercase text-600 font-weight-semi-bold mb-0'; |
|
168
|
|
|
|
|
169
|
|
|
let onSpaceCascaderChange = (value, selectedOptions) => { |
|
170
|
|
|
setSelectedSpaceName(selectedOptions.map(o => o.label).join('/')); |
|
171
|
|
|
setSelectedSpaceID(value[value.length - 1]); |
|
172
|
|
|
|
|
173
|
|
|
let isResponseOK = false; |
|
174
|
|
|
fetch(APIBaseURL + '/spaces/' + value[value.length - 1] + '/stores', { |
|
175
|
|
|
method: 'GET', |
|
176
|
|
|
headers: { |
|
177
|
|
|
"Content-type": "application/json", |
|
178
|
|
|
"User-UUID": getCookieValue('user_uuid'), |
|
179
|
|
|
"Token": getCookieValue('token') |
|
180
|
|
|
}, |
|
181
|
|
|
body: null, |
|
182
|
|
|
|
|
183
|
|
|
}).then(response => { |
|
184
|
|
|
if (response.ok) { |
|
185
|
|
|
isResponseOK = true; |
|
186
|
|
|
} |
|
187
|
|
|
return response.json(); |
|
188
|
|
|
}).then(json => { |
|
189
|
|
|
if (isResponseOK) { |
|
190
|
|
|
json = JSON.parse(JSON.stringify([json]).split('"id":').join('"value":').split('"name":').join('"label":')); |
|
191
|
|
|
console.log(json) |
|
192
|
|
|
setStoreList(json[0]); |
|
193
|
|
|
if (json[0].length > 0) { |
|
194
|
|
|
setSelectedStore(json[0][0].value); |
|
195
|
|
|
// enable submit button |
|
196
|
|
|
setSubmitButtonDisabled(false); |
|
197
|
|
|
} else { |
|
198
|
|
|
setSelectedStore(undefined); |
|
199
|
|
|
// disable submit button |
|
200
|
|
|
setSubmitButtonDisabled(true); |
|
201
|
|
|
} |
|
202
|
|
|
} else { |
|
203
|
|
|
toast.error(json.description) |
|
204
|
|
|
} |
|
205
|
|
|
}).catch(err => { |
|
206
|
|
|
console.log(err); |
|
207
|
|
|
}); |
|
208
|
|
|
} |
|
209
|
|
|
|
|
210
|
|
|
|
|
211
|
|
|
let onComparisonTypeChange = ({ target }) => { |
|
212
|
|
|
console.log(target.value); |
|
213
|
|
|
setComparisonType(target.value); |
|
214
|
|
|
if (target.value === 'year-over-year') { |
|
215
|
|
|
setBasePeriodBeginsDatetimeDisabled(true); |
|
216
|
|
|
setBasePeriodEndsDatetimeDisabled(true); |
|
217
|
|
|
setBasePeriodBeginsDatetime(moment(reportingPeriodBeginsDatetime).subtract(1, 'years')); |
|
218
|
|
|
setBasePeriodEndsDatetime(moment(reportingPeriodEndsDatetime).subtract(1, 'years')); |
|
219
|
|
|
} else if (target.value === 'month-on-month') { |
|
220
|
|
|
setBasePeriodBeginsDatetimeDisabled(true); |
|
221
|
|
|
setBasePeriodEndsDatetimeDisabled(true); |
|
222
|
|
|
setBasePeriodBeginsDatetime(moment(reportingPeriodBeginsDatetime).subtract(1, 'months')); |
|
223
|
|
|
setBasePeriodEndsDatetime(moment(reportingPeriodEndsDatetime).subtract(1, 'months')); |
|
224
|
|
|
} else if (target.value === 'free-comparison') { |
|
225
|
|
|
setBasePeriodBeginsDatetimeDisabled(false); |
|
226
|
|
|
setBasePeriodEndsDatetimeDisabled(false); |
|
227
|
|
|
} else if (target.value === 'none-comparison') { |
|
228
|
|
|
setBasePeriodBeginsDatetime(undefined); |
|
229
|
|
|
setBasePeriodEndsDatetime(undefined); |
|
230
|
|
|
setBasePeriodBeginsDatetimeDisabled(true); |
|
231
|
|
|
setBasePeriodEndsDatetimeDisabled(true); |
|
232
|
|
|
} |
|
233
|
|
|
} |
|
234
|
|
|
|
|
235
|
|
|
let onBasePeriodBeginsDatetimeChange = (newDateTime) => { |
|
236
|
|
|
setBasePeriodBeginsDatetime(newDateTime); |
|
237
|
|
|
} |
|
238
|
|
|
|
|
239
|
|
|
let onBasePeriodEndsDatetimeChange = (newDateTime) => { |
|
240
|
|
|
setBasePeriodEndsDatetime(newDateTime); |
|
241
|
|
|
} |
|
242
|
|
|
|
|
243
|
|
|
let onReportingPeriodBeginsDatetimeChange = (newDateTime) => { |
|
244
|
|
|
setReportingPeriodBeginsDatetime(newDateTime); |
|
245
|
|
|
if (comparisonType === 'year-over-year') { |
|
246
|
|
|
setBasePeriodBeginsDatetime(newDateTime.clone().subtract(1, 'years')); |
|
247
|
|
|
} else if (comparisonType === 'month-on-month') { |
|
248
|
|
|
setBasePeriodBeginsDatetime(newDateTime.clone().subtract(1, 'months')); |
|
249
|
|
|
} |
|
250
|
|
|
} |
|
251
|
|
|
|
|
252
|
|
|
let onReportingPeriodEndsDatetimeChange = (newDateTime) => { |
|
253
|
|
|
setReportingPeriodEndsDatetime(newDateTime); |
|
254
|
|
|
if (comparisonType === 'year-over-year') { |
|
255
|
|
|
setBasePeriodEndsDatetime(newDateTime.clone().subtract(1, 'years')); |
|
256
|
|
|
} else if (comparisonType === 'month-on-month') { |
|
257
|
|
|
setBasePeriodEndsDatetime(newDateTime.clone().subtract(1, 'months')); |
|
258
|
|
|
} |
|
259
|
|
|
} |
|
260
|
|
|
|
|
261
|
|
|
var getValidBasePeriodBeginsDatetimes = function (currentDate) { |
|
262
|
|
|
return currentDate.isBefore(moment(basePeriodEndsDatetime, 'MM/DD/YYYY, hh:mm:ss a')); |
|
263
|
|
|
} |
|
264
|
|
|
|
|
265
|
|
|
var getValidBasePeriodEndsDatetimes = function (currentDate) { |
|
266
|
|
|
return currentDate.isAfter(moment(basePeriodBeginsDatetime, 'MM/DD/YYYY, hh:mm:ss a')); |
|
267
|
|
|
} |
|
268
|
|
|
|
|
269
|
|
|
var getValidReportingPeriodBeginsDatetimes = function (currentDate) { |
|
270
|
|
|
return currentDate.isBefore(moment(reportingPeriodEndsDatetime, 'MM/DD/YYYY, hh:mm:ss a')); |
|
271
|
|
|
} |
|
272
|
|
|
|
|
273
|
|
|
var getValidReportingPeriodEndsDatetimes = function (currentDate) { |
|
274
|
|
|
return currentDate.isAfter(moment(reportingPeriodBeginsDatetime, 'MM/DD/YYYY, hh:mm:ss a')); |
|
275
|
|
|
} |
|
276
|
|
|
|
|
277
|
|
|
// Handler |
|
278
|
|
|
const handleSubmit = e => { |
|
279
|
|
|
e.preventDefault(); |
|
280
|
|
|
console.log('handleSubmit'); |
|
281
|
|
|
console.log(selectedSpaceID); |
|
282
|
|
|
console.log(selectedStore); |
|
283
|
|
|
console.log(comparisonType); |
|
284
|
|
|
console.log(periodType); |
|
285
|
|
|
console.log(basePeriodBeginsDatetime != null ? basePeriodBeginsDatetime.format('YYYY-MM-DDTHH:mm:ss') : undefined); |
|
286
|
|
|
console.log(basePeriodEndsDatetime != null ? basePeriodEndsDatetime.format('YYYY-MM-DDTHH:mm:ss') : undefined); |
|
287
|
|
|
console.log(reportingPeriodBeginsDatetime.format('YYYY-MM-DDTHH:mm:ss')); |
|
288
|
|
|
console.log(reportingPeriodEndsDatetime.format('YYYY-MM-DDTHH:mm:ss')); |
|
289
|
|
|
|
|
290
|
|
|
// disable submit button |
|
291
|
|
|
setSubmitButtonDisabled(true); |
|
292
|
|
|
// show spinner |
|
293
|
|
|
setSpinnerHidden(false); |
|
294
|
|
|
// hide export buttion |
|
295
|
|
|
setExportButtonHidden(true) |
|
296
|
|
|
|
|
297
|
|
|
// Reinitialize tables |
|
298
|
|
|
setDetailedDataTableData([]); |
|
299
|
|
|
|
|
300
|
|
|
let isResponseOK = false; |
|
301
|
|
|
fetch(APIBaseURL + '/reports/storecost?' + |
|
302
|
|
|
'storeid=' + selectedStore + |
|
303
|
|
|
'&periodtype=' + periodType + |
|
304
|
|
|
'&baseperiodstartdatetime=' + (basePeriodBeginsDatetime != null ? basePeriodBeginsDatetime.format('YYYY-MM-DDTHH:mm:ss') : '') + |
|
305
|
|
|
'&baseperiodenddatetime=' + (basePeriodEndsDatetime != null ? basePeriodEndsDatetime.format('YYYY-MM-DDTHH:mm:ss') : '') + |
|
306
|
|
|
'&reportingperiodstartdatetime=' + reportingPeriodBeginsDatetime.format('YYYY-MM-DDTHH:mm:ss') + |
|
307
|
|
|
'&reportingperiodenddatetime=' + reportingPeriodEndsDatetime.format('YYYY-MM-DDTHH:mm:ss'), { |
|
308
|
|
|
method: 'GET', |
|
309
|
|
|
headers: { |
|
310
|
|
|
"Content-type": "application/json", |
|
311
|
|
|
"User-UUID": getCookieValue('user_uuid'), |
|
312
|
|
|
"Token": getCookieValue('token') |
|
313
|
|
|
}, |
|
314
|
|
|
body: null, |
|
315
|
|
|
|
|
316
|
|
|
}).then(response => { |
|
317
|
|
|
if (response.ok) { |
|
318
|
|
|
isResponseOK = true; |
|
319
|
|
|
} |
|
320
|
|
|
return response.json(); |
|
321
|
|
|
}).then(json => { |
|
322
|
|
|
if (isResponseOK) { |
|
323
|
|
|
console.log(json) |
|
324
|
|
|
|
|
325
|
|
|
let cardSummaryList = [] |
|
326
|
|
|
json['reporting_period']['names'].forEach((currentValue, index) => { |
|
327
|
|
|
let cardSummaryItem = {} |
|
328
|
|
|
cardSummaryItem['name'] = json['reporting_period']['names'][index]; |
|
329
|
|
|
cardSummaryItem['unit'] = json['reporting_period']['units'][index]; |
|
330
|
|
|
cardSummaryItem['subtotal'] = json['reporting_period']['subtotals'][index]; |
|
331
|
|
|
cardSummaryItem['increment_rate'] = parseFloat(json['reporting_period']['increment_rates'][index] * 100).toFixed(2) + "%"; |
|
332
|
|
|
cardSummaryItem['subtotal_per_unit_area'] = json['reporting_period']['subtotals_per_unit_area'][index]; |
|
333
|
|
|
cardSummaryList.push(cardSummaryItem); |
|
334
|
|
|
}); |
|
335
|
|
|
let cardSummaryItem = {} |
|
336
|
|
|
cardSummaryItem['name'] = t('Total'); |
|
337
|
|
|
cardSummaryItem['unit'] = json['reporting_period']['total_unit']; |
|
338
|
|
|
cardSummaryItem['subtotal'] = json['reporting_period']['total']; |
|
339
|
|
|
cardSummaryItem['increment_rate'] = parseFloat(json['reporting_period']['total_increment_rate'] * 100).toFixed(2) + "%"; |
|
340
|
|
|
cardSummaryItem['subtotal_per_unit_area'] = json['reporting_period']['total_per_unit_area']; |
|
341
|
|
|
cardSummaryList.push(cardSummaryItem); |
|
342
|
|
|
setCardSummaryList(cardSummaryList); |
|
343
|
|
|
|
|
344
|
|
|
let timeOfUseArray = []; |
|
345
|
|
|
json['reporting_period']['energy_category_ids'].forEach((currentValue, index) => { |
|
346
|
|
|
if(currentValue == 1) { |
|
347
|
|
|
// energy_category_id 1 electricity |
|
348
|
|
|
let timeOfUseItem = {} |
|
349
|
|
|
timeOfUseItem['id'] = 1; |
|
350
|
|
|
timeOfUseItem['name'] = t('Top-Peak'); |
|
351
|
|
|
timeOfUseItem['value'] = json['reporting_period']['toppeaks'][index]; |
|
352
|
|
|
timeOfUseItem['color'] = "#"+((1<<24)*Math.random()|0).toString(16); |
|
353
|
|
|
timeOfUseArray.push(timeOfUseItem); |
|
354
|
|
|
|
|
355
|
|
|
timeOfUseItem = {} |
|
356
|
|
|
timeOfUseItem['id'] = 2; |
|
357
|
|
|
timeOfUseItem['name'] = t('On-Peak'); |
|
358
|
|
|
timeOfUseItem['value'] = json['reporting_period']['onpeaks'][index]; |
|
359
|
|
|
timeOfUseItem['color'] = "#"+((1<<24)*Math.random()|0).toString(16); |
|
360
|
|
|
timeOfUseArray.push(timeOfUseItem); |
|
361
|
|
|
|
|
362
|
|
|
timeOfUseItem = {} |
|
363
|
|
|
timeOfUseItem['id'] = 3; |
|
364
|
|
|
timeOfUseItem['name'] = t('Mid-Peak'); |
|
365
|
|
|
timeOfUseItem['value'] = json['reporting_period']['midpeaks'][index]; |
|
366
|
|
|
timeOfUseItem['color'] = "#"+((1<<24)*Math.random()|0).toString(16); |
|
367
|
|
|
timeOfUseArray.push(timeOfUseItem); |
|
368
|
|
|
|
|
369
|
|
|
timeOfUseItem = {} |
|
370
|
|
|
timeOfUseItem['id'] = 4; |
|
371
|
|
|
timeOfUseItem['name'] = t('Off-Peak'); |
|
372
|
|
|
timeOfUseItem['value'] = json['reporting_period']['offpeaks'][index]; |
|
373
|
|
|
timeOfUseItem['color'] = "#"+((1<<24)*Math.random()|0).toString(16); |
|
374
|
|
|
timeOfUseArray.push(timeOfUseItem); |
|
375
|
|
|
} |
|
376
|
|
|
}); |
|
377
|
|
|
setTimeOfUseShareData(timeOfUseArray); |
|
378
|
|
|
|
|
379
|
|
|
let costDataArray = []; |
|
380
|
|
|
json['reporting_period']['names'].forEach((currentValue, index) => { |
|
381
|
|
|
let costDataItem = {} |
|
382
|
|
|
costDataItem['id'] = index; |
|
383
|
|
|
costDataItem['name'] = currentValue; |
|
384
|
|
|
costDataItem['value'] = json['reporting_period']['subtotals'][index]; |
|
385
|
|
|
costDataItem['color'] = "#"+((1<<24)*Math.random()|0).toString(16); |
|
386
|
|
|
costDataArray.push(costDataItem); |
|
387
|
|
|
}); |
|
388
|
|
|
setCostShareData(costDataArray); |
|
389
|
|
|
|
|
390
|
|
|
let timestamps = {} |
|
391
|
|
|
json['reporting_period']['timestamps'].forEach((currentValue, index) => { |
|
392
|
|
|
timestamps['a' + index] = currentValue; |
|
393
|
|
|
}); |
|
394
|
|
|
setStoreLineChartLabels(timestamps); |
|
395
|
|
|
|
|
396
|
|
|
let values = {} |
|
397
|
|
|
json['reporting_period']['values'].forEach((currentValue, index) => { |
|
398
|
|
|
values['a' + index] = currentValue; |
|
399
|
|
|
}); |
|
400
|
|
|
setStoreLineChartData(values); |
|
401
|
|
|
|
|
402
|
|
|
let names = Array(); |
|
403
|
|
|
json['reporting_period']['names'].forEach((currentValue, index) => { |
|
404
|
|
|
let unit = json['reporting_period']['units'][index]; |
|
405
|
|
|
names.push({ 'value': 'a' + index, 'label': currentValue + ' (' + unit + ')'}); |
|
406
|
|
|
}); |
|
407
|
|
|
setStoreLineChartOptions(names); |
|
408
|
|
|
|
|
409
|
|
|
timestamps = {} |
|
410
|
|
|
json['parameters']['timestamps'].forEach((currentValue, index) => { |
|
411
|
|
|
timestamps['a' + index] = currentValue; |
|
412
|
|
|
}); |
|
413
|
|
|
setParameterLineChartLabels(timestamps); |
|
414
|
|
|
|
|
415
|
|
|
values = {} |
|
416
|
|
|
json['parameters']['values'].forEach((currentValue, index) => { |
|
417
|
|
|
values['a' + index] = currentValue; |
|
418
|
|
|
}); |
|
419
|
|
|
setParameterLineChartData(values); |
|
420
|
|
|
|
|
421
|
|
|
names = Array(); |
|
422
|
|
|
json['parameters']['names'].forEach((currentValue, index) => { |
|
423
|
|
|
if (currentValue.startsWith('TARIFF-')) { |
|
424
|
|
|
currentValue = t('Tariff') + currentValue.replace('TARIFF-', '-'); |
|
425
|
|
|
} |
|
426
|
|
|
|
|
427
|
|
|
names.push({ 'value': 'a' + index, 'label': currentValue }); |
|
428
|
|
|
}); |
|
429
|
|
|
setParameterLineChartOptions(names); |
|
430
|
|
|
|
|
431
|
|
|
let detailed_value_list = []; |
|
432
|
|
|
if (json['reporting_period']['timestamps'].length > 0) { |
|
433
|
|
|
json['reporting_period']['timestamps'][0].forEach((currentTimestamp, timestampIndex) => { |
|
434
|
|
|
let detailed_value = {}; |
|
435
|
|
|
detailed_value['id'] = timestampIndex; |
|
436
|
|
|
detailed_value['startdatetime'] = currentTimestamp; |
|
437
|
|
|
let total_current_timstamp = 0.0; |
|
438
|
|
|
json['reporting_period']['values'].forEach((currentValue, energyCategoryIndex) => { |
|
439
|
|
|
detailed_value['a' + energyCategoryIndex] = json['reporting_period']['values'][energyCategoryIndex][timestampIndex].toFixed(2); |
|
440
|
|
|
total_current_timstamp += json['reporting_period']['values'][energyCategoryIndex][timestampIndex]; |
|
441
|
|
|
}); |
|
442
|
|
|
detailed_value['total'] = total_current_timstamp.toFixed(2); |
|
443
|
|
|
detailed_value_list.push(detailed_value); |
|
444
|
|
|
}); |
|
445
|
|
|
}; |
|
446
|
|
|
|
|
447
|
|
|
let detailed_value = {}; |
|
448
|
|
|
detailed_value['id'] = detailed_value_list.length; |
|
449
|
|
|
detailed_value['startdatetime'] = t('Subtotal'); |
|
450
|
|
|
let total_of_subtotals = 0.0; |
|
451
|
|
|
json['reporting_period']['subtotals'].forEach((currentValue, index) => { |
|
452
|
|
|
detailed_value['a' + index] = currentValue.toFixed(2); |
|
453
|
|
|
total_of_subtotals += currentValue |
|
454
|
|
|
}); |
|
455
|
|
|
detailed_value['total'] = total_of_subtotals.toFixed(2); |
|
456
|
|
|
detailed_value_list.push(detailed_value); |
|
457
|
|
|
setDetailedDataTableData(detailed_value_list); |
|
458
|
|
|
|
|
459
|
|
|
let detailed_column_list = []; |
|
460
|
|
|
detailed_column_list.push({ |
|
461
|
|
|
dataField: 'startdatetime', |
|
462
|
|
|
text: t('Datetime'), |
|
463
|
|
|
sort: true |
|
464
|
|
|
}); |
|
465
|
|
|
json['reporting_period']['names'].forEach((currentValue, index) => { |
|
466
|
|
|
let unit = json['reporting_period']['units'][index]; |
|
467
|
|
|
detailed_column_list.push({ |
|
468
|
|
|
dataField: 'a' + index, |
|
469
|
|
|
text: currentValue + ' (' + unit + ')', |
|
470
|
|
|
sort: true |
|
471
|
|
|
}); |
|
472
|
|
|
}); |
|
473
|
|
|
detailed_column_list.push({ |
|
474
|
|
|
dataField: 'total', |
|
475
|
|
|
text: t('Total') + ' (' + json['reporting_period']['total_unit'] + ')', |
|
476
|
|
|
sort: true |
|
477
|
|
|
}); |
|
478
|
|
|
setDetailedDataTableColumns(detailed_column_list); |
|
479
|
|
|
|
|
480
|
|
|
setExcelBytesBase64(json['excel_bytes_base64']); |
|
481
|
|
|
|
|
482
|
|
|
// enable submit button |
|
483
|
|
|
setSubmitButtonDisabled(false); |
|
484
|
|
|
// hide spinner |
|
485
|
|
|
setSpinnerHidden(true); |
|
486
|
|
|
// show export buttion |
|
487
|
|
|
setExportButtonHidden(false) |
|
488
|
|
|
|
|
489
|
|
|
} else { |
|
490
|
|
|
toast.error(json.description) |
|
491
|
|
|
} |
|
492
|
|
|
}).catch(err => { |
|
493
|
|
|
console.log(err); |
|
494
|
|
|
}); |
|
495
|
|
|
|
|
496
|
|
|
}; |
|
497
|
|
|
|
|
498
|
|
|
const handleExport = e => { |
|
499
|
|
|
e.preventDefault(); |
|
500
|
|
|
const mimeType='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' |
|
501
|
|
|
const fileName = 'storecost.xlsx' |
|
502
|
|
|
var fileUrl = "data:" + mimeType + ";base64," + excelBytesBase64; |
|
503
|
|
|
fetch(fileUrl) |
|
504
|
|
|
.then(response => response.blob()) |
|
505
|
|
|
.then(blob => { |
|
506
|
|
|
var link = window.document.createElement("a"); |
|
507
|
|
|
link.href = window.URL.createObjectURL(blob, { type: mimeType }); |
|
508
|
|
|
link.download = fileName; |
|
509
|
|
|
document.body.appendChild(link); |
|
510
|
|
|
link.click(); |
|
511
|
|
|
document.body.removeChild(link); |
|
512
|
|
|
}); |
|
513
|
|
|
}; |
|
514
|
|
|
|
|
515
|
|
|
|
|
516
|
|
|
return ( |
|
517
|
|
|
<Fragment> |
|
518
|
|
|
<div> |
|
519
|
|
|
<Breadcrumb> |
|
520
|
|
|
<BreadcrumbItem>{t('Store Data')}</BreadcrumbItem><BreadcrumbItem active>{t('Cost')}</BreadcrumbItem> |
|
521
|
|
|
</Breadcrumb> |
|
522
|
|
|
</div> |
|
523
|
|
|
<Card className="bg-light mb-3"> |
|
524
|
|
|
<CardBody className="p-3"> |
|
525
|
|
|
<Form onSubmit={handleSubmit}> |
|
526
|
|
|
<Row form> |
|
527
|
|
|
<Col xs="auto"> |
|
528
|
|
|
<FormGroup className="form-group"> |
|
529
|
|
|
<Label className={labelClasses} for="space"> |
|
530
|
|
|
{t('Space')} |
|
531
|
|
|
</Label> |
|
532
|
|
|
<br /> |
|
533
|
|
|
<Cascader options={cascaderOptions} |
|
534
|
|
|
onChange={onSpaceCascaderChange} |
|
535
|
|
|
changeOnSelect |
|
536
|
|
|
expandTrigger="hover"> |
|
537
|
|
|
<Input value={selectedSpaceName || ''} readOnly /> |
|
538
|
|
|
</Cascader> |
|
539
|
|
|
</FormGroup> |
|
540
|
|
|
</Col> |
|
541
|
|
|
<Col xs="auto"> |
|
542
|
|
|
<FormGroup> |
|
543
|
|
|
<Label className={labelClasses} for="storeSelect"> |
|
544
|
|
|
{t('Store')} |
|
545
|
|
|
</Label> |
|
546
|
|
|
<CustomInput type="select" id="storeSelect" name="storeSelect" onChange={({ target }) => setSelectedStore(target.value)} |
|
547
|
|
|
> |
|
548
|
|
|
{storeList.map((store, index) => ( |
|
549
|
|
|
<option value={store.value} key={store.value}> |
|
550
|
|
|
{store.label} |
|
551
|
|
|
</option> |
|
552
|
|
|
))} |
|
553
|
|
|
</CustomInput> |
|
554
|
|
|
</FormGroup> |
|
555
|
|
|
</Col> |
|
556
|
|
|
<Col xs="auto"> |
|
557
|
|
|
<FormGroup> |
|
558
|
|
|
<Label className={labelClasses} for="comparisonType"> |
|
559
|
|
|
{t('Comparison Types')} |
|
560
|
|
|
</Label> |
|
561
|
|
|
<CustomInput type="select" id="comparisonType" name="comparisonType" |
|
562
|
|
|
defaultValue="month-on-month" |
|
563
|
|
|
onChange={onComparisonTypeChange} |
|
564
|
|
|
> |
|
565
|
|
|
{comparisonTypeOptions.map((comparisonType, index) => ( |
|
566
|
|
|
<option value={comparisonType.value} key={comparisonType.value} > |
|
567
|
|
|
{t(comparisonType.label)} |
|
568
|
|
|
</option> |
|
569
|
|
|
))} |
|
570
|
|
|
</CustomInput> |
|
571
|
|
|
</FormGroup> |
|
572
|
|
|
</Col> |
|
573
|
|
|
<Col xs="auto"> |
|
574
|
|
|
<FormGroup> |
|
575
|
|
|
<Label className={labelClasses} for="periodType"> |
|
576
|
|
|
{t('Period Types')} |
|
577
|
|
|
</Label> |
|
578
|
|
|
<CustomInput type="select" id="periodType" name="periodType" defaultValue="daily" onChange={({ target }) => setPeriodType(target.value)} |
|
579
|
|
|
> |
|
580
|
|
|
{periodTypeOptions.map((periodType, index) => ( |
|
581
|
|
|
<option value={periodType.value} key={periodType.value} > |
|
582
|
|
|
{t(periodType.label)} |
|
583
|
|
|
</option> |
|
584
|
|
|
))} |
|
585
|
|
|
</CustomInput> |
|
586
|
|
|
</FormGroup> |
|
587
|
|
|
</Col> |
|
588
|
|
|
<Col xs="auto"> |
|
589
|
|
|
<FormGroup className="form-group"> |
|
590
|
|
|
<Label className={labelClasses} for="basePeriodBeginsDatetime"> |
|
591
|
|
|
{t('Base Period Begins')}{t('(Optional)')} |
|
592
|
|
|
</Label> |
|
593
|
|
|
<Datetime id='basePeriodBeginsDatetime' |
|
594
|
|
|
value={basePeriodBeginsDatetime} |
|
595
|
|
|
inputProps={{ disabled: basePeriodBeginsDatetimeDisabled }} |
|
596
|
|
|
onChange={onBasePeriodBeginsDatetimeChange} |
|
597
|
|
|
isValidDate={getValidBasePeriodBeginsDatetimes} |
|
598
|
|
|
closeOnSelect={true} /> |
|
599
|
|
|
</FormGroup> |
|
600
|
|
|
</Col> |
|
601
|
|
|
<Col xs="auto"> |
|
602
|
|
|
<FormGroup className="form-group"> |
|
603
|
|
|
<Label className={labelClasses} for="basePeriodEndsDatetime"> |
|
604
|
|
|
{t('Base Period Ends')}{t('(Optional)')} |
|
605
|
|
|
</Label> |
|
606
|
|
|
<Datetime id='basePeriodEndsDatetime' |
|
607
|
|
|
value={basePeriodEndsDatetime} |
|
608
|
|
|
inputProps={{ disabled: basePeriodEndsDatetimeDisabled }} |
|
609
|
|
|
onChange={onBasePeriodEndsDatetimeChange} |
|
610
|
|
|
isValidDate={getValidBasePeriodEndsDatetimes} |
|
611
|
|
|
closeOnSelect={true} /> |
|
612
|
|
|
</FormGroup> |
|
613
|
|
|
</Col> |
|
614
|
|
|
<Col xs="auto"> |
|
615
|
|
|
<FormGroup className="form-group"> |
|
616
|
|
|
<Label className={labelClasses} for="reportingPeriodBeginsDatetime"> |
|
617
|
|
|
{t('Reporting Period Begins')} |
|
618
|
|
|
</Label> |
|
619
|
|
|
<Datetime id='reportingPeriodBeginsDatetime' |
|
620
|
|
|
value={reportingPeriodBeginsDatetime} |
|
621
|
|
|
onChange={onReportingPeriodBeginsDatetimeChange} |
|
622
|
|
|
isValidDate={getValidReportingPeriodBeginsDatetimes} |
|
623
|
|
|
closeOnSelect={true} /> |
|
624
|
|
|
</FormGroup> |
|
625
|
|
|
</Col> |
|
626
|
|
|
<Col xs="auto"> |
|
627
|
|
|
<FormGroup className="form-group"> |
|
628
|
|
|
<Label className={labelClasses} for="reportingPeriodEndsDatetime"> |
|
629
|
|
|
{t('Reporting Period Ends')} |
|
630
|
|
|
</Label> |
|
631
|
|
|
<Datetime id='reportingPeriodEndsDatetime' |
|
632
|
|
|
value={reportingPeriodEndsDatetime} |
|
633
|
|
|
onChange={onReportingPeriodEndsDatetimeChange} |
|
634
|
|
|
isValidDate={getValidReportingPeriodEndsDatetimes} |
|
635
|
|
|
closeOnSelect={true} /> |
|
636
|
|
|
</FormGroup> |
|
637
|
|
|
</Col> |
|
638
|
|
|
<Col xs="auto"> |
|
639
|
|
|
<FormGroup> |
|
640
|
|
|
<br></br> |
|
641
|
|
|
<ButtonGroup id="submit"> |
|
642
|
|
|
<Button color="success" disabled={submitButtonDisabled} >{t('Submit')}</Button> |
|
643
|
|
|
</ButtonGroup> |
|
644
|
|
|
</FormGroup> |
|
645
|
|
|
</Col> |
|
646
|
|
|
<Col xs="auto"> |
|
647
|
|
|
<FormGroup> |
|
648
|
|
|
<br></br> |
|
649
|
|
|
<Spinner color="primary" hidden={spinnerHidden} /> |
|
650
|
|
|
</FormGroup> |
|
651
|
|
|
</Col> |
|
652
|
|
|
<Col xs="auto"> |
|
653
|
|
|
<br></br> |
|
654
|
|
|
<ButtonIcon icon="external-link-alt" transform="shrink-3 down-2" color="falcon-default" |
|
655
|
|
|
hidden={exportButtonHidden} |
|
656
|
|
|
onClick={handleExport} > |
|
657
|
|
|
{t('Export')} |
|
658
|
|
|
</ButtonIcon> |
|
659
|
|
|
</Col> |
|
660
|
|
|
</Row> |
|
661
|
|
|
</Form> |
|
662
|
|
|
</CardBody> |
|
663
|
|
|
</Card> |
|
664
|
|
|
<div className="card-deck"> |
|
665
|
|
|
{cardSummaryList.map(cardSummaryItem => ( |
|
666
|
|
|
<CardSummary key={cardSummaryItem['name']} |
|
667
|
|
|
rate={cardSummaryItem['increment_rate']} |
|
668
|
|
|
title={t('Reporting Period Costs CATEGORY UNIT', { 'CATEGORY': cardSummaryItem['name'], 'UNIT': '(' + cardSummaryItem['unit'] + ')' })} |
|
669
|
|
|
color="success" |
|
670
|
|
|
footnote={t('Per Unit Area')} |
|
671
|
|
|
footvalue={cardSummaryItem['subtotal_per_unit_area']} |
|
672
|
|
|
footunit={"(" + cardSummaryItem['unit'] + "/M²)"} > |
|
673
|
|
|
{cardSummaryItem['subtotal'] && <CountUp end={cardSummaryItem['subtotal']} duration={2} prefix="" separator="," decimal="." decimals={2} />} |
|
674
|
|
|
</CardSummary> |
|
675
|
|
|
))} |
|
676
|
|
|
</div> |
|
677
|
|
|
<Row noGutters> |
|
678
|
|
|
<Col className="mb-3 pr-lg-2 mb-3"> |
|
679
|
|
|
<SharePie data={timeOfUseShareData} title={t('Electricity Cost by Time-Of-Use')} /> |
|
680
|
|
|
</Col> |
|
681
|
|
|
<Col className="mb-3 pr-lg-2 mb-3"> |
|
682
|
|
|
<SharePie data={costShareData} title={t('Costs by Energy Category')} /> |
|
683
|
|
|
</Col> |
|
684
|
|
|
</Row> |
|
685
|
|
|
<LineChart reportingTitle={t('Reporting Period Costs CATEGORY VALUE UNIT', { 'CATEGORY': null, 'VALUE': null, 'UNIT': null })} |
|
686
|
|
|
baseTitle='' |
|
687
|
|
|
labels={storeLineChartLabels} |
|
688
|
|
|
data={storeLineChartData} |
|
689
|
|
|
options={storeLineChartOptions}> |
|
690
|
|
|
</LineChart> |
|
691
|
|
|
|
|
692
|
|
|
<LineChart reportingTitle={t('Related Parameters')} |
|
693
|
|
|
baseTitle='' |
|
694
|
|
|
labels={parameterLineChartLabels} |
|
695
|
|
|
data={parameterLineChartData} |
|
696
|
|
|
options={parameterLineChartOptions}> |
|
697
|
|
|
</LineChart> |
|
698
|
|
|
|
|
699
|
|
|
<br /> |
|
700
|
|
|
<DetailedDataTable data={detailedDataTableData} title={t('Detailed Data')} columns={detailedDataTableColumns} pagesize={50} > |
|
701
|
|
|
</DetailedDataTable> |
|
702
|
|
|
|
|
703
|
|
|
</Fragment> |
|
704
|
|
|
); |
|
705
|
|
|
}; |
|
706
|
|
|
|
|
707
|
|
|
export default withTranslation()(withRedirect(StoreCost)); |
|
708
|
|
|
|
myems /
myems-web
