myems / myems-web

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

import {

  Breadcrumb,

  BreadcrumbItem,

  Row,

  Col,

  Card,

  CardBody,

  Button,

  ButtonGroup,

  Form,

  FormGroup,

  Input,

  Label,

  CustomInput

} from 'reactstrap';

import CountUp from 'react-countup';

import Datetime from 'react-datetime';

import moment from 'moment';

import Cascader from 'rc-cascader';

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

import SharePie from '../common/SharePie';

import LineChart from '../common/LineChart';

import loadable from '@loadable/component';

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

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

import { withTranslation } from 'react-i18next';

import { toast } from 'react-toastify';

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

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

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

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

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

const SpaceEnergyItem = ({ 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 [comparisonType, setComparisonType] = useState('month-on-month');

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

  const [basePeriodBeginsDatetime, setBasePeriodBeginsDatetime] = useState(current_moment.clone().subtract(1, 'months').startOf('month'));

  const [basePeriodEndsDatetime, setBasePeriodEndsDatetime] = useState(current_moment.clone().subtract(1, 'months'));

  const [basePeriodBeginsDatetimeDisabled, setBasePeriodBeginsDatetimeDisabled] = useState(true);

  const [basePeriodEndsDatetimeDisabled, setBasePeriodEndsDatetimeDisabled] = useState(true);

  const [reportingPeriodBeginsDatetime, setReportingPeriodBeginsDatetime] = useState(current_moment.clone().startOf('month'));

  const [reportingPeriodEndsDatetime, setReportingPeriodEndsDatetime] = useState(current_moment);

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

  const [isDisabled, setIsDisabled] = useState(true);

  //Results

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

  const [sharePieList, setSharePieList] = useState([]);

  const [spaceLineChartLabels, setSpaceLineChartLabels] = useState([]);

  const [spaceLineChartData, setSpaceLineChartData] = useState({});

  const [spaceLineChartOptions, setSpaceLineChartOptions] = 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 [childSpacesTableData, setChildSpacesTableData] = useState([]);

  const [childSpacesTableColumns, setChildSpacesTableColumns] = useState([{dataField: 'name', text: t('Child Spaces'), sort: true }]);

  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));

      } else {

        toast.error(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 onComparisonTypeChange = ({ target }) => {

    console.log(target.value);

    setComparisonType(target.value);

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

      setBasePeriodBeginsDatetimeDisabled(true);

      setBasePeriodEndsDatetimeDisabled(true);

      setBasePeriodBeginsDatetime(moment(reportingPeriodBeginsDatetime).subtract(1, 'years'));

      setBasePeriodEndsDatetime(moment(reportingPeriodEndsDatetime).subtract(1, 'years'));

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

      setBasePeriodBeginsDatetimeDisabled(true);

      setBasePeriodEndsDatetimeDisabled(true);

      setBasePeriodBeginsDatetime(moment(reportingPeriodBeginsDatetime).subtract(1, 'months'));

      setBasePeriodEndsDatetime(moment(reportingPeriodEndsDatetime).subtract(1, 'months'));

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

      setBasePeriodBeginsDatetimeDisabled(false);

      setBasePeriodEndsDatetimeDisabled(false);

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

      setBasePeriodBeginsDatetime(undefined);

      setBasePeriodEndsDatetime(undefined);

      setBasePeriodBeginsDatetimeDisabled(true);

      setBasePeriodEndsDatetimeDisabled(true);

    }

  }

  let onBasePeriodBeginsDatetimeChange = (newDateTime) => {

    setBasePeriodBeginsDatetime(newDateTime);

  }

  let onBasePeriodEndsDatetimeChange = (newDateTime) => {

    setBasePeriodEndsDatetime(newDateTime);

  }

  let onReportingPeriodBeginsDatetimeChange = (newDateTime) => {

    setReportingPeriodBeginsDatetime(newDateTime);

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

      setBasePeriodBeginsDatetime(newDateTime.clone().subtract(1, 'years'));

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

      setBasePeriodBeginsDatetime(newDateTime.clone().subtract(1, 'months'));

    }

  }

  let onReportingPeriodEndsDatetimeChange = (newDateTime) => {

    setReportingPeriodEndsDatetime(newDateTime);

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

      setBasePeriodEndsDatetime(newDateTime.clone().subtract(1, 'years'));

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

      setBasePeriodEndsDatetime(newDateTime.clone().subtract(1, 'months'));

    }

  }

  var getValidBasePeriodBeginsDatetimes = function (currentDate) {

    return currentDate.isBefore(moment(basePeriodEndsDatetime, 'MM/DD/YYYY, hh:mm:ss a'));

  }

  var getValidBasePeriodEndsDatetimes = function (currentDate) {

    return currentDate.isAfter(moment(basePeriodBeginsDatetime, 'MM/DD/YYYY, hh:mm:ss a'));

  }

  var getValidReportingPeriodBeginsDatetimes = function (currentDate) {

    return currentDate.isBefore(moment(reportingPeriodEndsDatetime, 'MM/DD/YYYY, hh:mm:ss a'));

  }

  var getValidReportingPeriodEndsDatetimes = function (currentDate) {

    return currentDate.isAfter(moment(reportingPeriodBeginsDatetime, 'MM/DD/YYYY, hh:mm:ss a'));

  }

  // Handler

  const handleSubmit = e => {

    e.preventDefault();

    console.log('handleSubmit');

    console.log(selectedSpaceID);

    console.log(comparisonType);

    console.log(periodType);

    console.log(basePeriodBeginsDatetime != null ? basePeriodBeginsDatetime.format('YYYY-MM-DDTHH:mm:ss') : undefined);

    console.log(basePeriodEndsDatetime != null ? basePeriodEndsDatetime.format('YYYY-MM-DDTHH:mm:ss') : undefined);

    console.log(reportingPeriodBeginsDatetime.format('YYYY-MM-DDTHH:mm:ss'));

    console.log(reportingPeriodEndsDatetime.format('YYYY-MM-DDTHH:mm:ss'));

    // Reinitialize tables

    setDetailedDataTableData([]);

    setChildSpacesTableData([]);

    let isResponseOK = false;

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

      'spaceid=' + selectedSpaceID +

      '&periodtype=' + periodType +

      '&baseperiodstartdatetime=' + (basePeriodBeginsDatetime != null ? basePeriodBeginsDatetime.format('YYYY-MM-DDTHH:mm:ss') : '') +

      '&baseperiodenddatetime=' + (basePeriodEndsDatetime != null ? basePeriodEndsDatetime.format('YYYY-MM-DDTHH:mm:ss') : '') +

      '&reportingperiodstartdatetime=' + reportingPeriodBeginsDatetime.format('YYYY-MM-DDTHH:mm:ss') +

      '&reportingperiodenddatetime=' + reportingPeriodEndsDatetime.format('YYYY-MM-DDTHH:mm:ss'), {

      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']['names'].forEach((currentValue, index) => {

          let cardSummaryItem = {}

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

          cardSummaryItem['energy_category_name'] = json['reporting_period']['energy_category_names'][index];

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

          cardSummaryItem['subtotal'] = json['reporting_period']['subtotals'][index];

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

          cardSummaryItem['subtotal_per_unit_area'] = json['reporting_period']['subtotals_per_unit_area'][index];

          cardSummaryArray.push(cardSummaryItem);

        });

        setCardSummaryList(cardSummaryArray);

        let sharePieDict = {}

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

          let sharePieSubItem = {}

          sharePieSubItem['id'] = index;

          sharePieSubItem['name'] = json['reporting_period']['names'][index];

          sharePieSubItem['value'] = json['reporting_period']['subtotals'][index];

          sharePieSubItem['color'] = "#"+((1<<24)*Math.random()|0).toString(16);

          let current_energy_category_id = json['reporting_period']['energy_category_ids'][index]

          if (current_energy_category_id in sharePieDict) {

            sharePieDict[current_energy_category_id].push(sharePieSubItem);

          } else {

            sharePieDict[current_energy_category_id] = [];

            sharePieDict[current_energy_category_id].push(sharePieSubItem);

          }

        });

        let sharePieArray = [];

        for (let current_energy_category_id in sharePieDict) {

          let sharePieItem = {}

          sharePieItem['data'] = sharePieDict[current_energy_category_id];

          sharePieItem['energy_category_name'] = json['reporting_period']['energy_category_names'][current_energy_category_id];

          sharePieItem['unit'] = json['reporting_period']['units'][current_energy_category_id];

          sharePieArray.push(sharePieItem);

        }

        setSharePieList(sharePieArray);

        let timestamps = {}

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

          timestamps['a' + index] = currentValue;

        });

        setSpaceLineChartLabels(timestamps);

        let values = {}

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

          values['a' + index] = currentValue;

        });

        setSpaceLineChartData(values);

        let names = Array();

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

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

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

        });

        setSpaceLineChartOptions(names);

        timestamps = {}

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

          timestamps['a' + index] = currentValue;

        });

        setParameterLineChartLabels(timestamps);

        values = {}

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

          values['a' + index] = currentValue;

        });

        setParameterLineChartData(values);

        names = Array();

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

          if (currentValue.startsWith('TARIFF-')) {

            currentValue = t('Tariff') + currentValue.replace('TARIFF-', '-');

          }

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

        });

        setParameterLineChartOptions(names);

        let detailed_value_list = [];

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

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

            let detailed_value = {};

            detailed_value['id'] = timestampIndex;

            detailed_value['startdatetime'] = currentTimestamp;

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

              detailed_value['a' + energyCategoryIndex] = json['reporting_period']['values'][energyCategoryIndex][timestampIndex].toFixed(2);

            });

            detailed_value_list.push(detailed_value);

          });

        };

        let detailed_value = {};

        detailed_value['id'] = detailed_value_list.length;

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

        json['reporting_period']['subtotals'].forEach((currentValue, index) => {

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

          });

        detailed_value_list.push(detailed_value);

        setDetailedDataTableData(detailed_value_list);

        let detailed_column_list = [];

        detailed_column_list.push({

          dataField: 'startdatetime',

          text: t('Datetime'),

          sort: true

        })

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

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

          detailed_column_list.push({

            dataField: 'a' + index,

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

            sort: true

          })

        });

        setDetailedDataTableColumns(detailed_column_list);

        let child_space_value_list = [];

        if (json['child_space']['child_space_names_array'].length > 0) {

          json['child_space']['child_space_names_array'][0].forEach((currentSpaceName, spaceIndex) => {

            let child_space_value = {};

            child_space_value['id'] = spaceIndex;

            child_space_value['name'] = currentSpaceName;

            json['child_space']['energy_item_names'].forEach((currentValue, energyItemIndex) => {

              child_space_value['a' + energyItemIndex] = json['child_space']['subtotals_array'][energyItemIndex][spaceIndex].toFixed(2);

            });

            child_space_value_list.push(child_space_value);

          });

        };

        setChildSpacesTableData(child_space_value_list);

        let child_space_column_list = [];

        child_space_column_list.push({

          dataField: 'name',

          text: t('Child Spaces'),

          sort: true

        });

        json['child_space']['energy_item_names'].forEach((currentValue, index) => {

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

          child_space_column_list.push({

            dataField: 'a' + index,

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

            sort: true

          });

        });

        setChildSpacesTableColumns(child_space_column_list);

      } else {

        toast.error(json.description)

      }

    }).catch(err => {

      console.log(err);

    });

  };

  return (

    <Fragment>

      <div>

        <Breadcrumb>

          <BreadcrumbItem>{t('Space Data')}</BreadcrumbItem><BreadcrumbItem active>{t('Energy Item Data')}</BreadcrumbItem>

        </Breadcrumb>

      </div>

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

        <CardBody className="p-3">

          <Form onSubmit={handleSubmit}>

            <Row form>

              <Col xs="auto">

                <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="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="auto">

                <FormGroup className="form-group">

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

                    {t('Base Period Begins')}{t('(Optional)')}

                  </Label>

                  <Datetime id='basePeriodBeginsDatetime'

                    value={basePeriodBeginsDatetime}

                    inputProps={{ disabled: basePeriodBeginsDatetimeDisabled }}

                    onChange={onBasePeriodBeginsDatetimeChange}

                    isValidDate={getValidBasePeriodBeginsDatetimes}

                    closeOnSelect={true} />

                </FormGroup>

              </Col>

              <Col xs="auto">

                <FormGroup className="form-group">

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

                    {t('Base Period Ends')}{t('(Optional)')}

                  </Label>

                  <Datetime id='basePeriodEndsDatetime'

                    value={basePeriodEndsDatetime}

                    inputProps={{ disabled: basePeriodEndsDatetimeDisabled }}

                    onChange={onBasePeriodEndsDatetimeChange}

                    isValidDate={getValidBasePeriodEndsDatetimes}

                    closeOnSelect={true} />

                </FormGroup>

              </Col>

              <Col xs="auto">

                <FormGroup className="form-group">

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

                    {t('Reporting Period Begins')}

                  </Label>

                  <Datetime id='reportingPeriodBeginsDatetime'

                    value={reportingPeriodBeginsDatetime}

                    onChange={onReportingPeriodBeginsDatetimeChange}

                    isValidDate={getValidReportingPeriodBeginsDatetimes}

                    closeOnSelect={true} />

                </FormGroup>

              </Col>

              <Col xs="auto">

                <FormGroup className="form-group">

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

                    {t('Reporting Period Ends')}

                  </Label>

                  <Datetime id='reportingPeriodEndsDatetime'

                    value={reportingPeriodEndsDatetime}

                    onChange={onReportingPeriodEndsDatetimeChange}

                    isValidDate={getValidReportingPeriodEndsDatetimes}

                    closeOnSelect={true} />

                </FormGroup>

              </Col>

              <Col xs="auto">

                <FormGroup>

                  <br></br>

                  <ButtonGroup id="submit">

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

                  </ButtonGroup>

                </FormGroup>

              </Col>

            </Row>

          </Form>

        </CardBody>

      </Card>

      <div className="card-deck">

        {cardSummaryList.map(cardSummaryItem => (

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

            rate={cardSummaryItem['increment_rate']}

            title={t('Reporting Period Consumption ITEM CATEGORY UNIT', { 'ITEM': cardSummaryItem['name'], 'CATEGORY': cardSummaryItem['energy_category_name'], 'UNIT': '(' + cardSummaryItem['unit'] + ')' })}

            color="success" 

            footnote={t('Per Unit Area')} 

            footvalue={cardSummaryItem['subtotal_per_unit_area']}

            footunit={"(" + cardSummaryItem['unit'] + "/M²)"} >

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

          </CardSummary>

        ))}

      </div>

      <Row noGutters>

        {sharePieList.map(sharePieItem => (

          <Col key={sharePieItem['energy_category_name']} className="mb-3 pr-lg-2 mb-3">

            <SharePie key={sharePieItem['energy_category_name']}

              data={sharePieItem['data']} 

              title={t('CATEGORY UNIT Consumption by Energy Items', { 'CATEGORY': sharePieItem['energy_category_name'], 'UNIT': '(' + sharePieItem['unit'] + ')' })} />

          </Col>

        ))}

      </Row>

      <LineChart reportingTitle={t('Reporting Period Consumption ITEM CATEGORY VALUE UNIT', { 'ITEM': null, 'CATEGORY': null, 'VALUE': null, 'UNIT': null })}

        baseTitle=''

        labels={spaceLineChartLabels}

        data={spaceLineChartData}

        options={spaceLineChartOptions}>

      </LineChart>

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

        baseTitle=''

        labels={parameterLineChartLabels}

        data={parameterLineChartData}

        options={parameterLineChartOptions}>

      </LineChart>

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

      </DetailedDataTable>

      <br />

      <ChildSpacesTable data={childSpacesTableData} title={t('Child Spaces Data')} columns={childSpacesTableColumns}>

      </ChildSpacesTable>

    </Fragment>

  );