MyEMS / myems

import React, { Fragment, useEffect, useState, useContext } from 'react';

import {

  Breadcrumb,

  BreadcrumbItem,

  Row,

  Col,

  Card,

  CardBody,

  Button,

  ButtonGroup,

  Form,

  FormGroup,

  Input,

  Label,

  CustomInput,

  Spinner

} from 'reactstrap';

import CountUp from 'react-countup';

import moment from 'moment';

import loadable from '@loadable/component';

import Cascader from 'rc-cascader';

import CardSummary from '../common/CardSummary';

import MultiTrendChart from '../common/MultiTrendChart';

import { getCookieValue, createCookie } from '../../../helpers/utils';

import withRedirect from '../../../hoc/withRedirect';

import { withTranslation } from 'react-i18next';

import { toast } from 'react-toastify';

import ButtonIcon from '../../common/ButtonIcon';

import { APIBaseURL } from '../../../config';

import { periodTypeOptions } from '../common/PeriodTypeOptions';

import { comparisonTypeOptions } from '../common/ComparisonTypeOptions';

import DateRangePickerWrapper from '../common/DateRangePickerWrapper';

import { endOfDay} from 'date-fns';

import AppContext from '../../../context/Context';

import MultipleLineChart from '../common/MultipleLineChart';

const DetailedDataTable = loadable(() => import('../common/DetailedDataTable'));

const AssociatedEquipmentTable = loadable(() => import('../common/AssociatedEquipmentTable'));

const CombinedEquipmentEfficiency = ({ setRedirect, setRedirectUrl, t }) => {

  let current_moment = moment();

  useEffect(() => {

    let is_logged_in = getCookieValue('is_logged_in');

    let user_name = getCookieValue('user_name');

    let user_display_name = getCookieValue('user_display_name');

    let user_uuid = getCookieValue('user_uuid');

    let token = getCookieValue('token');

    if (is_logged_in === null || !is_logged_in) {

      setRedirectUrl(`/authentication/basic/login`);

      setRedirect(true);

    } else {

      //update expires time of cookies

      createCookie('is_logged_in', true, 1000 * 60 * 60 * 8);

      createCookie('user_name', user_name, 1000 * 60 * 60 * 8);

      createCookie('user_display_name', user_display_name, 1000 * 60 * 60 * 8);

      createCookie('user_uuid', user_uuid, 1000 * 60 * 60 * 8);

      createCookie('token', token, 1000 * 60 * 60 * 8);

    }

  });

  // State

  // Query Parameters

  const [selectedSpaceName, setSelectedSpaceName] = useState(undefined);

  const [selectedSpaceID, setSelectedSpaceID] = useState(undefined);

  const [combinedEquipmentList, setCombinedEquipmentList] = useState([]);

  const [selectedCombinedEquipment, setSelectedCombinedEquipment] = useState(undefined);

  const [comparisonType, setComparisonType] = useState('month-on-month');

  const [periodType, setPeriodType] = useState('daily');

  const [cascaderOptions, setCascaderOptions] = useState(undefined);

  const [basePeriodDateRange, setBasePeriodDateRange] = useState([current_moment.clone().subtract(1, 'months').startOf('month').toDate(), current_moment.clone().subtract(1, 'months').toDate()]);

  const [basePeriodDateRangePickerDisabled, setBasePeriodDateRangePickerDisabled] = useState(true);

  const [reportingPeriodDateRange, setReportingPeriodDateRange] = useState([current_moment.clone().startOf('month').toDate(), current_moment.toDate()]);

  const dateRangePickerLocale = {

    sunday: t('sunday'),

    monday: t('monday'),

    tuesday: t('tuesday'),

    wednesday: t('wednesday'),

    thursday: t('thursday'),

    friday: t('friday'),

    saturday: t('saturday'),

    ok: t('ok'),

    today: t('today'),

    yesterday: t('yesterday'),

    hours: t('hours'),

    minutes: t('minutes'),

    seconds: t('seconds'),

    last7Days: t('last7Days'),

    formattedMonthPattern: 'yyyy-MM-dd'

  };

  const dateRangePickerStyle = { display: 'block', zIndex: 10};

  const { language } = useContext(AppContext);

  // buttons

  const [submitButtonDisabled, setSubmitButtonDisabled] = useState(true);

  const [spinnerHidden, setSpinnerHidden] = useState(true);

  const [exportButtonHidden, setExportButtonHidden] = useState(true);

  //Results

  const [cardSummaryList, setCardSummaryList] = useState([]);

  const [combinedEquipmentBaseAndReportingNames, setCombinedEquipmentBaseAndReportingNames] = useState({"a0":""});

  const [combinedEquipmentBaseAndReportingUnits, setCombinedEquipmentBaseAndReportingUnits] = useState({"a0":"()"});

  const [combinedEquipmentBaseLabels, setCombinedEquipmentBaseLabels] = useState({"a0": []});

  const [combinedEquipmentBaseData, setCombinedEquipmentBaseData] = useState({"a0": []});

  const [combinedEquipmentBaseSubtotals, setCombinedEquipmentBaseSubtotals] = useState({"a0": (0).toFixed(2)});

  const [combinedEquipmentReportingLabels, setCombinedEquipmentReportingLabels] = useState({"a0": []});

  const [combinedEquipmentReportingData, setCombinedEquipmentReportingData] = useState({"a0": []});

  const [combinedEquipmentReportingSubtotals, setCombinedEquipmentReportingSubtotals] = useState({"a0": (0).toFixed(2)});

  const [combinedEquipmentReportingRates, setCombinedEquipmentReportingRates] = useState({"a0": []});

  const [combinedEquipmentReportingOptions, setCombinedEquipmentReportingOptions] = useState([]);

  const [parameterLineChartLabels, setParameterLineChartLabels] = useState([]);

  const [parameterLineChartData, setParameterLineChartData] = useState({});

  const [parameterLineChartOptions, setParameterLineChartOptions] = useState([]);

  const [detailedDataTableData, setDetailedDataTableData] = useState([]);

  const [detailedDataTableColumns, setDetailedDataTableColumns] = useState([{dataField: 'startdatetime', text: t('Datetime'), sort: true}]);

  const [associatedEquipmentTableData, setAssociatedEquipmentTableData] = useState([]);

  const [associatedEquipmentTableColumns, setAssociatedEquipmentTableColumns] = useState([{dataField: 'name', text: t('Associated Equipment'), sort: true }]);

  const [excelBytesBase64, setExcelBytesBase64] = useState(undefined);

  useEffect(() => {

    let isResponseOK = false;

    fetch(APIBaseURL + '/spaces/tree', {

      method: 'GET',

      headers: {

        "Content-type": "application/json",

        "User-UUID": getCookieValue('user_uuid'),

        "Token": getCookieValue('token')

      },

      body: null,

    }).then(response => {

      console.log(response);

      if (response.ok) {

        isResponseOK = true;

      }

      return response.json();

    }).then(json => {

      console.log(json);

      if (isResponseOK) {

        // rename keys 

        json = JSON.parse(JSON.stringify([json]).split('"id":').join('"value":').split('"name":').join('"label":'));

        setCascaderOptions(json);

        setSelectedSpaceName([json[0]].map(o => o.label));

        setSelectedSpaceID([json[0]].map(o => o.value));

        // get CombinedEquipments by root Space ID

        let isResponseOK = false;

        fetch(APIBaseURL + '/spaces/' + [json[0]].map(o => o.value) + '/combinedequipments', {

          method: 'GET',

          headers: {

            "Content-type": "application/json",

            "User-UUID": getCookieValue('user_uuid'),

            "Token": getCookieValue('token')

          },

          body: null,

        }).then(response => {

          if (response.ok) {

            isResponseOK = true;

          }

          return response.json();

        }).then(json => {

          if (isResponseOK) {

            json = JSON.parse(JSON.stringify([json]).split('"id":').join('"value":').split('"name":').join('"label":'));

            console.log(json);

            setCombinedEquipmentList(json[0]);

            if (json[0].length > 0) {

              setSelectedCombinedEquipment(json[0][0].value);

              // enable submit button

              setSubmitButtonDisabled(false);

            } else {

              setSelectedCombinedEquipment(undefined);

              // disable submit button

              setSubmitButtonDisabled(true);

            }

          } else {

            toast.error(t(json.description))

          }

        }).catch(err => {

          console.log(err);

        });

        // end of get CombinedEquipments by root Space ID

      } else {

        toast.error(t(json.description));

      }

    }).catch(err => {

      console.log(err);

    });

  }, []);

  const labelClasses = 'ls text-uppercase text-600 font-weight-semi-bold mb-0';

  let onSpaceCascaderChange = (value, selectedOptions) => {

    console.log(value, selectedOptions);

    setSelectedSpaceName(selectedOptions.map(o => o.label).join('/'));

    setSelectedSpaceID(value[value.length - 1]);

    let isResponseOK = false;

    fetch(APIBaseURL + '/spaces/' + value[value.length - 1] + '/combinedequipments', {

      method: 'GET',

      headers: {

        "Content-type": "application/json",

        "User-UUID": getCookieValue('user_uuid'),

        "Token": getCookieValue('token')

      },

      body: null,

    }).then(response => {

      if (response.ok) {

        isResponseOK = true;

      }

      return response.json();

    }).then(json => {

      if (isResponseOK) {

        json = JSON.parse(JSON.stringify([json]).split('"id":').join('"value":').split('"name":').join('"label":'));

        console.log(json)

        setCombinedEquipmentList(json[0]);

        if (json[0].length > 0) {

          setSelectedCombinedEquipment(json[0][0].value);

          // enable submit button

          setSubmitButtonDisabled(false);

        } else {

          setSelectedCombinedEquipment(undefined);

          // disable submit button

          setSubmitButtonDisabled(true);

        }

        // hide export button

        setExportButtonHidden(true)

      } else {

        toast.error(t(json.description))

      }

    }).catch(err => {

      console.log(err);

    });

  }

  let onComparisonTypeChange = ({ target }) => {

    console.log(target.value);

    setComparisonType(target.value);

    if (target.value === 'year-over-year') {

      setBasePeriodDateRangePickerDisabled(true);

      setBasePeriodDateRange([moment(reportingPeriodDateRange[0]).subtract(1, 'years').toDate(),

        moment(reportingPeriodDateRange[1]).subtract(1, 'years').toDate()]);

    } else if (target.value === 'month-on-month') {

      setBasePeriodDateRangePickerDisabled(true);

      setBasePeriodDateRange([moment(reportingPeriodDateRange[0]).subtract(1, 'months').toDate(),

        moment(reportingPeriodDateRange[1]).subtract(1, 'months').toDate()]);

    } else if (target.value === 'free-comparison') {

      setBasePeriodDateRangePickerDisabled(false);

    } else if (target.value === 'none-comparison') {

      setBasePeriodDateRange([null, null]);

      setBasePeriodDateRangePickerDisabled(true);

    }

  };

  // Callback fired when value changed

  let onBasePeriodChange = (DateRange) => {

    if(DateRange == null) {

      setBasePeriodDateRange([null, null]);

    } else {

      if (moment(DateRange[1]).format('HH:mm:ss') == '00:00:00') {

        // if the user did not change time value, set the default time to the end of day

        DateRange[1] = endOfDay(DateRange[1]);

      }

      setBasePeriodDateRange([DateRange[0], DateRange[1]]);

    }

  };

  // Callback fired when value changed

  let onReportingPeriodChange = (DateRange) => {

    if(DateRange == null) {

      setReportingPeriodDateRange([null, null]);

    } else {

      if (moment(DateRange[1]).format('HH:mm:ss') == '00:00:00') {

        // if the user did not change time value, set the default time to the end of day

        DateRange[1] = endOfDay(DateRange[1]);

      }

      setReportingPeriodDateRange([DateRange[0], DateRange[1]]);

      if (comparisonType === 'year-over-year') {

        setBasePeriodDateRange([moment(DateRange[0]).clone().subtract(1, 'years').toDate(), moment(DateRange[1]).clone().subtract(1, 'years').toDate()]);

      } else if (comparisonType === 'month-on-month') {

        setBasePeriodDateRange([moment(DateRange[0]).clone().subtract(1, 'months').toDate(), moment(DateRange[1]).clone().subtract(1, 'months').toDate()]);

      }

    }

  };

  // Callback fired when value clean

  let onBasePeriodClean = event => {

    setBasePeriodDateRange([null, null]);

  };

  // Callback fired when value clean

  let onReportingPeriodClean = event => {

    setReportingPeriodDateRange([null, null]);

  };

  const isBasePeriodTimestampExists = (base_period_data) => {

    const timestamps = base_period_data['timestamps'];

    if (timestamps.length === 0) {

      return false;

    }

    for (let i = 0; i < timestamps.length; i++) {

      if (timestamps[i].length > 0) {

        return true;

      }

    }

    return false

  }

  const sortByNumber = (originalArr, key) => {

    let sortArr = Array();

    let index = 0;

    while (sortArr.length < originalArr.length) {

      for (let i = 0; i < originalArr.length; i++) {

        if (originalArr[i][key].substring(1) === index.toString()) {

          sortArr.push(originalArr[i])

        }

      }

      index += 1

    }

    return sortArr;

  }

  // Handler

  const handleSubmit = e => {

    e.preventDefault();

    console.log('handleSubmit');

    console.log(selectedSpaceID);

    console.log(selectedCombinedEquipment);

    console.log(comparisonType);

    console.log(periodType);

    console.log(basePeriodDateRange[0] != null ? moment(basePeriodDateRange[0]).format('YYYY-MM-DDTHH:mm:ss') : null)

    console.log(basePeriodDateRange[1] != null ? moment(basePeriodDateRange[1]).format('YYYY-MM-DDTHH:mm:ss') : null)

    console.log(moment(reportingPeriodDateRange[0]).format('YYYY-MM-DDTHH:mm:ss'))

    console.log(moment(reportingPeriodDateRange[1]).format('YYYY-MM-DDTHH:mm:ss'));

    // disable submit button

    setSubmitButtonDisabled(true);

    // show spinner

    setSpinnerHidden(false);

    // hide export button

    setExportButtonHidden(true)

    // Reinitialize tables

    setDetailedDataTableData([]);

    setAssociatedEquipmentTableData([]);

    let isResponseOK = false;

    fetch(APIBaseURL + '/reports/combinedequipmentefficiency?' +

      'combinedequipmentid=' + selectedCombinedEquipment +

      '&periodtype=' + periodType +

      '&baseperiodstartdatetime=' + (basePeriodDateRange[0] != null ? moment(basePeriodDateRange[0]).format('YYYY-MM-DDTHH:mm:ss') : '') +

      '&baseperiodenddatetime=' + (basePeriodDateRange[1] != null ? moment(basePeriodDateRange[1]).format('YYYY-MM-DDTHH:mm:ss') : '') +

      '&reportingperiodstartdatetime=' + moment(reportingPeriodDateRange[0]).format('YYYY-MM-DDTHH:mm:ss') +

      '&reportingperiodenddatetime=' + moment(reportingPeriodDateRange[1]).format('YYYY-MM-DDTHH:mm:ss') +

      '&language=' + language, {

      method: 'GET',

      headers: {

        "Content-type": "application/json",

        "User-UUID": getCookieValue('user_uuid'),

        "Token": getCookieValue('token')

      },

      body: null,

    }).then(response => {

      if (response.ok) {

        isResponseOK = true;

      };

      return response.json();

    }).then(json => {

      if (isResponseOK) {

        console.log(json);

        let cardSummaryArray = []

        json['reporting_period_efficiency']['names'].forEach((currentValue, index) => {

          let cardSummaryItem = {}

          cardSummaryItem['name'] = json['reporting_period_efficiency']['names'][index];

          cardSummaryItem['unit'] = json['reporting_period_efficiency']['units'][index];

          cardSummaryItem['cumulation'] = json['reporting_period_efficiency']['cumulations'][index];

          cardSummaryItem['increment_rate'] = parseFloat(json['reporting_period_efficiency']['increment_rates'][index] * 100).toFixed(2) + "%";

          cardSummaryItem['numerator_name'] = json['reporting_period_efficiency']['numerator_names'][index];

          cardSummaryItem['numerator_unit'] = json['reporting_period_efficiency']['numerator_units'][index];

          cardSummaryItem['numerator_cumulation'] = json['reporting_period_efficiency']['numerator_cumulations'][index];

          cardSummaryItem['increment_rates_num'] = parseFloat(json['reporting_period_efficiency']['increment_rates_num'][index] * 100).toFixed(2) + "%";

          cardSummaryItem['denominator_name'] = json['reporting_period_efficiency']['denominator_names'][index];

          cardSummaryItem['denominator_unit'] = json['reporting_period_efficiency']['denominator_units'][index];

          cardSummaryItem['denominator_cumulation'] = json['reporting_period_efficiency']['denominator_cumulations'][index];

          cardSummaryItem['increment_rates_den'] = parseFloat(json['reporting_period_efficiency']['increment_rates_den'][index] * 100).toFixed(2) + "%";

          cardSummaryArray.push(cardSummaryItem);

        });

        setCardSummaryList(cardSummaryArray);

        let base_timestamps = {}

        json['base_period_efficiency']['timestamps'].forEach((currentValue, index) => {

          base_timestamps['a' + index] = currentValue;

        });

        json['base_period_efficiency']['numerator_timestamps'].forEach((currentValue, index) => {

          base_timestamps['b' + index] = currentValue;

        });

        json['base_period_efficiency']['denominator_timestamps'].forEach((currentValue, index) => {

          base_timestamps['c' + index] = currentValue;

        });

        setCombinedEquipmentBaseLabels(base_timestamps)

        let base_values = {}

        json['base_period_efficiency']['values'].forEach((currentValue, index) => {

          base_values['a' + index] = currentValue;

        });

        json['base_period_efficiency']['numerator_values'].forEach((currentValue, index) => {

          base_values['b' + index] = currentValue;

        });

        json['base_period_efficiency']['denominator_values'].forEach((currentValue, index) => {

          base_values['c' + index] = currentValue;

        });

        setCombinedEquipmentBaseData(base_values)

        /*

        * Tip:

        *     base_names === reporting_names

        *     base_units === reporting_units

        * */

        let base_and_reporting_names = {}

        json['reporting_period_efficiency']['names'].forEach((currentValue, index) => {

          base_and_reporting_names['a' + index] = currentValue;

        });

        json['reporting_period_efficiency']['numerator_names'].forEach((currentValue, index) => {

          base_and_reporting_names['b' + index] = currentValue;

        });

        json['reporting_period_efficiency']['denominator_names'].forEach((currentValue, index) => {

          base_and_reporting_names['c' + index] = currentValue;

        });

        setCombinedEquipmentBaseAndReportingNames(base_and_reporting_names)

        let base_and_reporting_units = {}

        json['reporting_period_efficiency']['units'].forEach((currentValue, index) => {

          base_and_reporting_units['a' + index] = "("+currentValue+")";

        });

        json['reporting_period_efficiency']['numerator_units'].forEach((currentValue, index) => {

          base_and_reporting_units['b' + index] = "("+currentValue+")";

        });

        json['reporting_period_efficiency']['denominator_units'].forEach((currentValue, index) => {

          base_and_reporting_units['c' + index] = "("+currentValue+")";

        });

        setCombinedEquipmentBaseAndReportingUnits(base_and_reporting_units)

        let base_subtotals = {}

        json['base_period_efficiency']['cumulations'].forEach((currentValue, index) => {

          base_subtotals['a' + index] = currentValue.toFixed(2);

        });

        json['base_period_efficiency']['numerator_cumulations'].forEach((currentValue, index) => {

          base_subtotals['b' + index] = currentValue.toFixed(2);

        });

        json['base_period_efficiency']['denominator_cumulations'].forEach((currentValue, index) => {

          base_subtotals['c' + index] = currentValue.toFixed(2);

        });

        setCombinedEquipmentBaseSubtotals(base_subtotals)

        let reporting_timestamps = {}

        json['reporting_period_efficiency']['timestamps'].forEach((currentValue, index) => {

          reporting_timestamps['a' + index] = currentValue;

        });

        json['reporting_period_efficiency']['numerator_timestamps'].forEach((currentValue, index) => {

          reporting_timestamps['b' + index] = currentValue;

        });

        json['reporting_period_efficiency']['denominator_timestamps'].forEach((currentValue, index) => {

          reporting_timestamps['c' + index] = currentValue;

        });

        setCombinedEquipmentReportingLabels(reporting_timestamps);

        let reporting_values = {}

        json['reporting_period_efficiency']['values'].forEach((currentValue, index) => {

          reporting_values['a' + index] = currentValue;

        });

        json['reporting_period_efficiency']['numerator_values'].forEach((currentValue, index) => {

          reporting_values['b' + index] = currentValue;

        });

        json['reporting_period_efficiency']['denominator_values'].forEach((currentValue, index) => {

          reporting_values['c' + index] = currentValue;

        });

        setCombinedEquipmentReportingData(reporting_values);

        let reporting_subtotals = {}

        json['reporting_period_efficiency']['cumulations'].forEach((currentValue, index) => {

          reporting_subtotals['a' + index] = currentValue.toFixed(2);

        });

        json['reporting_period_efficiency']['numerator_cumulations'].forEach((currentValue, index) => {

          reporting_subtotals['b' + index] = currentValue.toFixed(2);

        });

        json['reporting_period_efficiency']['denominator_cumulations'].forEach((currentValue, index) => {

          reporting_subtotals['c' + index] = currentValue.toFixed(2);

        });

        setCombinedEquipmentReportingSubtotals(reporting_subtotals);

        let rates = {}

        json['reporting_period_efficiency']['rates'].forEach((currentValue, index) => {

          let currentRate = Array();

          currentValue.forEach((rate) => {

            currentRate.push(rate ? parseFloat(rate * 100).toFixed(2) : '0.00');

          });

          rates['a' + index] = currentRate;

        });

        json['reporting_period_efficiency']['numerator_rates'].forEach((currentValue, index) => {

          let currentRate = Array();

          currentValue.forEach((rate) => {

            currentRate.push(rate ? parseFloat(rate * 100).toFixed(2) : '0.00');

          });

          rates['b' + index] = currentRate;

        });

        json['reporting_period_efficiency']['denominator_rates'].forEach((currentValue, index) => {

          let currentRate = Array();

          currentValue.forEach((rate) => {

            currentRate.push(rate ? parseFloat(rate * 100).toFixed(2) : '0.00');

          });

          rates['c' + index] = currentRate;

        });

        setCombinedEquipmentReportingRates(rates)

        let options = Array();

        json['reporting_period_efficiency']['names'].forEach((currentValue, index) => {

          let unit = json['reporting_period_efficiency']['units'][index];

          options.push({ 'value': 'a' + index, 'label': currentValue + ' (' + unit + ')'});

        });

        json['reporting_period_efficiency']['numerator_names'].forEach((currentValue, index) => {

          let name = json['reporting_period_efficiency']['names'][index];

          let unit = json['reporting_period_efficiency']['numerator_units'][index];

          options.push({ 'value': 'b' + index, 'label': name + "-" + currentValue + ' (' + unit + ')'});

        });

        json['reporting_period_efficiency']['denominator_names'].forEach((currentValue, index) => {

          let name = json['reporting_period_efficiency']['names'][index];

          let unit = json['reporting_period_efficiency']['denominator_units'][index];

          options.push({ 'value': 'c' + index, 'label': name + "-" + currentValue + ' (' + unit + ')'});

        });

        setCombinedEquipmentReportingOptions(sortByNumber(options, "value"));

        let timestamps = {}

        json['parameters']['timestamps'].forEach((currentValue, index) => {

          timestamps['a' + index] = currentValue;

        });

        setParameterLineChartLabels(timestamps);

        let values = {}

        json['parameters']['values'].forEach((currentValue, index) => {

          values['a' + index] = currentValue;

        });

        setParameterLineChartData(values);

        let names = Array();

        json['parameters']['names'].forEach((currentValue, index) => {

          names.push({ 'value': 'a' + index, 'label': currentValue });

        });

        setParameterLineChartOptions(names);

        if(!isBasePeriodTimestampExists(json['base_period_efficiency'])) {

          let detailed_value_list = [];

          if (json['reporting_period_efficiency']['timestamps'].length > 0) {

            json['reporting_period_efficiency']['timestamps'][0].forEach((currentTimestamp, timestampIndex) => {

              let detailed_value = {};

              detailed_value['id'] = timestampIndex;

              detailed_value['startdatetime'] = currentTimestamp;

              json['reporting_period_efficiency']['values'].forEach((currentValue, parameterIndex) => {

                if (json['reporting_period_efficiency']['values'][parameterIndex][timestampIndex] != null) {

                  detailed_value['a' + parameterIndex] = json['reporting_period_efficiency']['values'][parameterIndex][timestampIndex];

                } else {

                  detailed_value['a' + parameterIndex] = null;

                }

                ;

              });

              json['reporting_period_efficiency']['numerator_values'].forEach((currentValue, parameterIndex) => {

                if (json['reporting_period_efficiency']['numerator_values'][parameterIndex][timestampIndex] != null) {

                  detailed_value['b' + parameterIndex] = json['reporting_period_efficiency']['numerator_values'][parameterIndex][timestampIndex];

                } else {

                  detailed_value['b' + parameterIndex] = null;

                }

                ;

              });

              json['reporting_period_efficiency']['denominator_values'].forEach((currentValue, parameterIndex) => {

                if (json['reporting_period_efficiency']['denominator_values'][parameterIndex][timestampIndex] != null) {

                  detailed_value['c' + parameterIndex] = json['reporting_period_efficiency']['denominator_values'][parameterIndex][timestampIndex];

                } else {

                  detailed_value['c' + parameterIndex] = null;

                }

                ;

              });

              detailed_value_list.push(detailed_value);

            });

          }

          ;

          let detailed_value = {};

          detailed_value['id'] = detailed_value_list.length;

          detailed_value['startdatetime'] = t('Subtotal');

          json['reporting_period_efficiency']['cumulations'].forEach((currentValue, index) => {

            detailed_value['a' + index] = currentValue;

          });

          json['reporting_period_efficiency']['numerator_cumulations'].forEach((currentValue, index) => {

            detailed_value['b' + index] = currentValue;

          });

          json['reporting_period_efficiency']['denominator_cumulations'].forEach((currentValue, index) => {

            detailed_value['c' + index] = currentValue;

          });

          detailed_value_list.push(detailed_value);

          setTimeout(() => {

            setDetailedDataTableData(detailed_value_list);

          }, 0)

          let detailed_column_list = [];

          detailed_column_list.push({

            dataField: 'startdatetime',

            text: t('Datetime'),

            sort: true

          })

          json['reporting_period_efficiency']['names'].forEach((currentValue, index) => {

            let unit = json['reporting_period_efficiency']['units'][index];

            let numerator_name = json['reporting_period_efficiency']['numerator_names'][index];

            let numerator_unit = json['reporting_period_efficiency']['numerator_units'][index];

            let denominator_name = json['reporting_period_efficiency']['denominator_names'][index];

            let denominator_unit = json['reporting_period_efficiency']['denominator_units'][index];

            detailed_column_list.push({

              dataField: 'a' + index,

              text: currentValue + ' (' + unit + ')',

              sort: true,

              formatter: function (decimalValue) {

                if (typeof decimalValue === 'number') {

                  return decimalValue.toFixed(2);

                } else {

                  return null;

                }

              }

            })

            detailed_column_list.push({

              dataField: 'b' + index,

              text: currentValue + '-' + numerator_name + ' (' + numerator_unit + ')',

              sort: true,

              formatter: function (decimalValue) {

                if (typeof decimalValue === 'number') {

                  return decimalValue.toFixed(2);

                } else {

                  return null;

                }

              }

            })

            detailed_column_list.push({

              dataField: 'c' + index,

              text: currentValue + '-' + denominator_name + ' (' + denominator_unit + ')',

              sort: true,

              formatter: function (decimalValue) {

                if (typeof decimalValue === 'number') {

                  return decimalValue.toFixed(2);

                } else {

                  return null;

                }

              }

            })

          });

          setDetailedDataTableColumns(detailed_column_list);

        }else {

          /*

          * Tip:

          *     json['base_period_efficiency']['names'] ===  json['reporting_period_efficiency']['names']

          *     json['base_period_efficiency']['units'] ===  json['reporting_period_efficiency']['units']

          * */

          let detailed_column_list = [];

          detailed_column_list.push({

            dataField: 'basePeriodDatetime',

            text: t('Base Period') + ' - ' + t('Datetime'),

            sort: true

          })

          let original_detailed_column_list = []

          json['reporting_period_efficiency']['names'].forEach((currentValue, index) => {

            let unit = json['reporting_period_efficiency']['units'][index];

            original_detailed_column_list.push({

              dataField: 'a' + index,

              text: t('Base Period') + ' - ' + currentValue + ' (' + unit + ')',

              sort: true,

              formatter: function (decimalValue) {

                if (typeof decimalValue === 'number') {

                  return decimalValue.toFixed(2);

                } else {

                  return null;

                }

              }

            })

          });

          json['reporting_period_efficiency']['numerator_names'].forEach((currentValue, index) => {

            let name = json['reporting_period_efficiency']['names'][index]

            let unit = json['reporting_period_efficiency']['numerator_units'][index];

            original_detailed_column_list.push({

              dataField: 'b' + index,

              text: t('Base Period') + ' - ' + name + '-' + currentValue + ' (' + unit + ')',

              sort: true,

              formatter: function (decimalValue) {

                if (typeof decimalValue === 'number') {

                  return decimalValue.toFixed(2);

                } else {

                  return null;

                }

              }

            })

          });

          json['reporting_period_efficiency']['denominator_names'].forEach((currentValue, index) => {

            let name = json['reporting_period_efficiency']['names'][index]

            let unit = json['reporting_period_efficiency']['denominator_units'][index];

            original_detailed_column_list.push({

              dataField: 'c' + index,

              text: t('Base Period') + ' - ' + name + '-' + currentValue + ' (' + unit + ')',

              sort: true,

              formatter: function (decimalValue) {

                if (typeof decimalValue === 'number') {

                  return decimalValue.toFixed(2);

                } else {

                  return null;

                }

              }

            })

          });

          detailed_column_list = [...detailed_column_list, ...sortByNumber(original_detailed_column_list, "dataField")];

          detailed_column_list.push({

            dataField: 'reportingPeriodDatetime',

            text: t('Reporting Period') + ' - ' + t('Datetime'),

            sort: true

          })

          original_detailed_column_list = []

          json['reporting_period_efficiency']['names'].forEach((currentValue, index) => {

            let unit = json['reporting_period_efficiency']['units'][index];

            original_detailed_column_list.push({

              dataField: 'd' + index,

              text: t('Reporting Period') + ' - ' + currentValue + ' (' + unit + ')',

              sort: true,

              formatter: function (decimalValue) {

                if (typeof decimalValue === 'number') {

                  return decimalValue.toFixed(2);

                } else {

                  return null;

                }

              }

            })

          });

          json['reporting_period_efficiency']['numerator_names'].forEach((currentValue, index) => {

            let name = json['reporting_period_efficiency']['names'][index]

            let unit = json['reporting_period_efficiency']['numerator_units'][index];

            original_detailed_column_list.push({

              dataField: 'e' + index,

              text: t('Reporting Period') + ' - ' + name + '-' + currentValue + ' (' + unit + ')',

              sort: true,

              formatter: function (decimalValue) {

                if (typeof decimalValue === 'number') {

                  return decimalValue.toFixed(2);

                } else {

                  return null;

                }

              }

            })

          });

          json['reporting_period_efficiency']['denominator_names'].forEach((currentValue, index) => {

            let name = json['reporting_period_efficiency']['names'][index]

            let unit = json['reporting_period_efficiency']['denominator_units'][index];

            original_detailed_column_list.push({

              dataField: 'f' + index,

              text: t('Reporting Period') + ' - ' + name + '-' + currentValue + ' (' + unit + ')',

              sort: true,

              formatter: function (decimalValue) {

                if (typeof decimalValue === 'number') {

                  return decimalValue.toFixed(2);

                } else {

                  return null;

                }

              }

            })

          });

          detailed_column_list = [...detailed_column_list, ...sortByNumber(original_detailed_column_list, "dataField")];

          setDetailedDataTableColumns(detailed_column_list);

          let detailed_value_list = [];

          if (json['base_period_efficiency']['timestamps'].length > 0 || json['reporting_period_efficiency']['timestamps'].length > 0) {

            const max_timestamps_length = json['base_period_efficiency']['timestamps'][0].length >= json['reporting_period_efficiency']['timestamps'][0].length ?

                json['base_period_efficiency']['timestamps'][0].length : json['reporting_period_efficiency']['timestamps'][0].length;

            for (let index = 0; index < max_timestamps_length; index++) {

              let detailed_value = {};

              detailed_value['id'] = index;

              detailed_value['basePeriodDatetime'] = index < json['base_period_efficiency']['timestamps'][0].length ? json['base_period_efficiency']['timestamps'][0][index] : null;

              json['base_period_efficiency']['values'].forEach((currentValue, energyCategoryIndex) => {

                detailed_value['a' + energyCategoryIndex] = index < json['base_period_efficiency']['values'][energyCategoryIndex].length ? json['base_period_efficiency']['values'][energyCategoryIndex][index] : null;

              });

              json['base_period_efficiency']['numerator_values'].forEach((currentValue, energyCategoryIndex) => {

                detailed_value['b' + energyCategoryIndex] = index < json['base_period_efficiency']['numerator_values'][energyCategoryIndex].length ? json['base_period_efficiency']['numerator_values'][energyCategoryIndex][index] : null;

              });

              json['base_period_efficiency']['denominator_values'].forEach((currentValue, energyCategoryIndex) => {

                detailed_value['c' + energyCategoryIndex] = index < json['base_period_efficiency']['denominator_values'][energyCategoryIndex].length ? json['base_period_efficiency']['denominator_values'][energyCategoryIndex][index] : null;

              });

              detailed_value['reportingPeriodDatetime'] = index < json['reporting_period_efficiency']['timestamps'][0].length ? json['reporting_period_efficiency']['timestamps'][0][index] : null;

              json['reporting_period_efficiency']['values'].forEach((currentValue, energyCategoryIndex) => {

                detailed_value['d' + energyCategoryIndex] = index < json['reporting_period_efficiency']['values'][energyCategoryIndex].length ? json['reporting_period_efficiency']['values'][energyCategoryIndex][index] : null;

              });

              json['reporting_period_efficiency']['numerator_values'].forEach((currentValue, energyCategoryIndex) => {

                detailed_value['e' + energyCategoryIndex] = index < json['reporting_period_efficiency']['numerator_values'][energyCategoryIndex].length ? json['reporting_period_efficiency']['numerator_values'][energyCategoryIndex][index] : null;

              });

              json['reporting_period_efficiency']['values'].forEach((currentValue, energyCategoryIndex) => {

                detailed_value['f' + energyCategoryIndex] = index < json['reporting_period_efficiency']['denominator_values'][energyCategoryIndex].length ? json['reporting_period_efficiency']['denominator_values'][energyCategoryIndex][index] : null;

              });

              detailed_value_list.push(detailed_value);

            }

            let detailed_value = {};

            detailed_value['id'] = detailed_value_list.length;

            detailed_value['basePeriodDatetime'] = t('Subtotal');

            json['base_period_efficiency']['cumulations'].forEach((currentValue, index) => {

              detailed_value['a' + index] = currentValue;

            });

            json['base_period_efficiency']['numerator_cumulations'].forEach((currentValue, index) => {

              detailed_value['b' + index] = currentValue;

            });

            json['base_period_efficiency']['denominator_cumulations'].forEach((currentValue, index) => {

              detailed_value['c' + index] = currentValue;

            });

            detailed_value['reportingPeriodDatetime'] = t('Subtotal');

            json['reporting_period_efficiency']['cumulations'].forEach((currentValue, index) => {

              detailed_value['d' + index] = currentValue;

            });

            json['reporting_period_efficiency']['numerator_cumulations'].forEach((currentValue, index) => {

              detailed_value['e' + index] = currentValue;

            });

            json['reporting_period_efficiency']['denominator_cumulations'].forEach((currentValue, index) => {

              detailed_value['f' + index] = currentValue;

            });

            detailed_value_list.push(detailed_value);

            setTimeout(() => {

              setDetailedDataTableData(detailed_value_list);

            }, 0)

          }

        }

        let associated_equipment_value_list = [];

        if (json['associated_equipment']['associated_equipment_names_array'].length > 0) {

          json['associated_equipment']['associated_equipment_names_array'][0].forEach((currentEquipmentName, equipmentIndex) => {

            let associated_equipment_value = {};

            associated_equipment_value['id'] = equipmentIndex;

            associated_equipment_value['name'] = currentEquipmentName;

            json['associated_equipment']['energy_category_names'].forEach((currentValue, energyCategoryIndex) => {

              associated_equipment_value['a' + energyCategoryIndex] = json['associated_equipment']['subtotals_array'][energyCategoryIndex][equipmentIndex].toFixed(2);

            });

            associated_equipment_value_list.push(associated_equipment_value);

          });

        };

        setAssociatedEquipmentTableData(associated_equipment_value_list);

        let associated_equipment_column_list = [];

        associated_equipment_column_list.push({

          dataField: 'name',

          text: t('Associated Equipment'),

          sort: true

        });

        json['associated_equipment']['energy_category_names'].forEach((currentValue, index) => {

          let unit = json['associated_equipment']['units'][index];

          associated_equipment_column_list.push({

            dataField: 'a' + index,

            text: currentValue + ' (' + unit + ')',

            sort: true

          });

        });

        setAssociatedEquipmentTableColumns(associated_equipment_column_list);

        setExcelBytesBase64(json['excel_bytes_base64']);

        // enable submit button

        setSubmitButtonDisabled(false);

        // hide spinner

        setSpinnerHidden(true);

        // show export button

        setExportButtonHidden(false);

      } else {

        toast.error(t(json.description))

      }

    }).catch(err => {

      console.log(err);

    });      

  };

  const handleExport = e => {

    e.preventDefault();

    const mimeType='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'

    const fileName = 'combinedequipmentefficiency.xlsx'

    var fileUrl = "data:" + mimeType + ";base64," + excelBytesBase64;

    fetch(fileUrl)

        .then(response => response.blob())

        .then(blob => {

            var link = window.document.createElement("a");

            link.href = window.URL.createObjectURL(blob, { type: mimeType });

            link.download = fileName;

            document.body.appendChild(link);

            link.click();

            document.body.removeChild(link);

        });

  };

  return (

    <Fragment>

      <div>

        <Breadcrumb>

          <BreadcrumbItem>{t('Combined Equipment Data')}</BreadcrumbItem><BreadcrumbItem active>{t('Efficiency')}</BreadcrumbItem>

        </Breadcrumb>

      </div>

      <Card className="bg-light mb-3">

        <CardBody className="p-3">

          <Form onSubmit={handleSubmit}>

            <Row form>

              <Col xs={6} sm={3}>

                <FormGroup className="form-group">

                  <Label className={labelClasses} for="space">

                    {t('Space')}

                  </Label>

                  <br />

                  <Cascader options={cascaderOptions}

                    onChange={onSpaceCascaderChange}

                    changeOnSelect

                    expandTrigger="hover">

                    <Input value={selectedSpaceName || ''} readOnly />

                  </Cascader>

                </FormGroup>

              </Col>

              <Col xs="auto">

                <FormGroup>

                  <Label className={labelClasses} for="combinedEquipmentSelect">

                    {t('Combined Equipment')}

                  </Label>

                  <CustomInput type="select" id="combinedEquipmentSelect" name="combinedEquipmentSelect" onChange={({ target }) => setSelectedCombinedEquipment(target.value)}

                  >

                    {combinedEquipmentList.map((combinedEquipment, index) => (

                      <option value={combinedEquipment.value} key={combinedEquipment.value}>

                        {combinedEquipment.label}

                      </option>

                    ))}

                  </CustomInput>

                </FormGroup>

              </Col>

              <Col xs="auto">

                <FormGroup>

                  <Label className={labelClasses} for="comparisonType">

                    {t('Comparison Types')}

                  </Label>

                  <CustomInput type="select" id="comparisonType" name="comparisonType"

                    defaultValue="month-on-month"

                    onChange={onComparisonTypeChange}

                  >

                    {comparisonTypeOptions.map((comparisonType, index) => (

                      <option value={comparisonType.value} key={comparisonType.value} >

                        {t(comparisonType.label)}

                      </option>

                    ))}

                  </CustomInput>

                </FormGroup>

              </Col>

              <Col xs="auto">

                <FormGroup>

                  <Label className={labelClasses} for="periodType">

                    {t('Period Types')}

                  </Label>

                  <CustomInput type="select" id="periodType" name="periodType" defaultValue="daily" onChange={({ target }) => setPeriodType(target.value)}

                  >

                    {periodTypeOptions.map((periodType, index) => (

                      <option value={periodType.value} key={periodType.value} >

                        {t(periodType.label)}

                      </option>

                    ))}

                  </CustomInput>

                </FormGroup>

              </Col>

              <Col xs={6} sm={3}>

                <FormGroup className="form-group">

                  <Label className={labelClasses} for="basePeriodDateRangePicker">{t('Base Period')}{t('(Optional)')}</Label>

                  <DateRangePickerWrapper 

                    id='basePeriodDateRangePicker'

                    disabled={basePeriodDateRangePickerDisabled}

                    format="yyyy-MM-dd HH:mm:ss"

                    value={basePeriodDateRange}

                    onChange={onBasePeriodChange}

                    size="md"

                    style={dateRangePickerStyle}

                    onClean={onBasePeriodClean}

                    locale={dateRangePickerLocale}

                    placeholder={t("Select Date Range")}

                   />

                </FormGroup>

              </Col>

              <Col xs={6} sm={3}>

                <FormGroup className="form-group">

                  <Label className={labelClasses} for="reportingPeriodDateRangePicker">{t('Reporting Period')}</Label>

                  <br/>

                  <DateRangePickerWrapper

                    id='reportingPeriodDateRangePicker'

                    format="yyyy-MM-dd HH:mm:ss"

                    value={reportingPeriodDateRange}

                    onChange={onReportingPeriodChange}

                    size="md"

                    style={dateRangePickerStyle}

                    onClean={onReportingPeriodClean}

                    locale={dateRangePickerLocale}

                    placeholder={t("Select Date Range")}

                  />

                </FormGroup>

              </Col>

              <Col xs="auto">

                <FormGroup>

                  <br></br>

                  <ButtonGroup id="submit">

                    <Button color="success" disabled={submitButtonDisabled} >{t('Submit')}</Button>

                  </ButtonGroup>

                </FormGroup>

              </Col>

              <Col xs="auto">

                <FormGroup>

                  <br></br>

                  <Spinner color="primary" hidden={spinnerHidden}  />

                </FormGroup>

              </Col>

              <Col xs="auto">

                  <br></br>

                  <ButtonIcon icon="external-link-alt" transform="shrink-3 down-2" color="falcon-default" 

                  hidden={exportButtonHidden}

                  onClick={handleExport} >

                    {t('Export')}

                  </ButtonIcon>

              </Col>

            </Row>

          </Form>

        </CardBody>

      </Card>

      {cardSummaryList.map(cardSummaryItem => (

        <div className="card-deck" key={cardSummaryItem['name']}>

          <CardSummary key={cardSummaryItem['name']}

            rate={cardSummaryItem['increment_rate']}

            title={t('Reporting Period Cumulative Efficiency NAME UNIT', { 'NAME': cardSummaryItem['name'], 'UNIT': '(' + cardSummaryItem['unit'] + ')' })}

            color="success" >

            {cardSummaryItem['cumulation'] && <CountUp end={cardSummaryItem['cumulation']} duration={2} prefix="" separator="," decimal="." decimals={2} />}

          </CardSummary>

          <CardSummary key={cardSummaryItem['numerator_name']}

            rate={cardSummaryItem['increment_rates_num']}

            title={t('Reporting Period Output CATEGORY UNIT', { 'CATEGORY': cardSummaryItem['name'] + '-' + cardSummaryItem['numerator_name'], 'UNIT': '(' + cardSummaryItem['numerator_unit'] + ')' })}

            color="success" >

            {cardSummaryItem['numerator_cumulation'] && <CountUp end={cardSummaryItem['numerator_cumulation']} duration={2} prefix="" separator="," decimal="." decimals={2} />}

          </CardSummary>

          <CardSummary key={cardSummaryItem['denominator_name']}

            rate={cardSummaryItem['increment_rates_den']}

            title={t('Reporting Period Consumption CATEGORY UNIT', { 'CATEGORY': cardSummaryItem['name'] + '-' + cardSummaryItem['denominator_name'], 'UNIT': '(' + cardSummaryItem['denominator_unit'] + ')' })}

            color="success" >

            {cardSummaryItem['denominator_cumulation'] && <CountUp end={cardSummaryItem['denominator_cumulation']} duration={2} prefix="" separator="," decimal="." decimals={2} />}

          </CardSummary>

        </div>

      ))}

      <MultiTrendChart reportingTitle = {{"name": "Reporting Period Cumulative Efficiency NAME VALUE UNIT", "substitute": ["NAME", "VALUE", "UNIT"], "NAME": combinedEquipmentBaseAndReportingNames, "VALUE": combinedEquipmentReportingSubtotals, "UNIT": combinedEquipmentBaseAndReportingUnits}}

        baseTitle = {{"name": "Base Period Cumulative Efficiency NAME VALUE UNIT", "substitute": ["NAME", "VALUE", "UNIT"], "NAME": combinedEquipmentBaseAndReportingNames, "VALUE": combinedEquipmentBaseSubtotals, "UNIT": combinedEquipmentBaseAndReportingUnits}}

        reportingTooltipTitle = {{"name": "Reporting Period Cumulative Efficiency NAME VALUE UNIT", "substitute": ["NAME", "VALUE", "UNIT"], "NAME": combinedEquipmentBaseAndReportingNames, "VALUE": null, "UNIT": combinedEquipmentBaseAndReportingUnits}}

        baseTooltipTitle = {{"name": "Base Period Cumulative Efficiency NAME VALUE UNIT", "substitute": ["NAME", "VALUE", "UNIT"], "NAME": combinedEquipmentBaseAndReportingNames, "VALUE": null, "UNIT": combinedEquipmentBaseAndReportingUnits}}

        reportingLabels={combinedEquipmentReportingLabels}

        reportingData={combinedEquipmentReportingData}

        baseLabels={combinedEquipmentBaseLabels}

        baseData={combinedEquipmentBaseData}

        rates={combinedEquipmentReportingRates}

        options={combinedEquipmentReportingOptions}>

      </MultiTrendChart>

      <MultipleLineChart reportingTitle={t('Related Parameters')}

        baseTitle=''

        labels={parameterLineChartLabels}

        data={parameterLineChartData}

        options={parameterLineChartOptions}>

      </MultipleLineChart>

      <br />

      <DetailedDataTable data={detailedDataTableData} title={t('Detailed Data')} columns={detailedDataTableColumns} pagesize={50} >

      </DetailedDataTable>

      <br />

      <AssociatedEquipmentTable data={associatedEquipmentTableData} title={t('Associated Equipment Data')} columns={associatedEquipmentTableColumns}>

      </AssociatedEquipmentTable>

    </Fragment>

  );

};