| @@ 381-398 (lines=18) @@ | ||
| 378 | parameters_data['names'] = list() |
|
| 379 | parameters_data['timestamps'] = list() |
|
| 380 | parameters_data['values'] = list() |
|
| 381 | if energy_item_set is not None and len(energy_item_set) > 0: |
|
| 382 | for energy_item_id in energy_item_set: |
|
| 383 | energy_category_tariff_dict = \ |
|
| 384 | utilities.get_energy_category_tariffs(space['cost_center_id'], |
|
| 385 | energy_item_dict[energy_item_id]['energy_category_id'], |
|
| 386 | reporting_start_datetime_utc, |
|
| 387 | reporting_end_datetime_utc) |
|
| 388 | tariff_timestamp_list = list() |
|
| 389 | tariff_value_list = list() |
|
| 390 | for k, v in energy_category_tariff_dict.items(): |
|
| 391 | # convert k from utc to local |
|
| 392 | k = k + timedelta(minutes=timezone_offset) |
|
| 393 | tariff_timestamp_list.append(k.isoformat()[0:19][0:19]) |
|
| 394 | tariff_value_list.append(v) |
|
| 395 | ||
| 396 | parameters_data['names'].append('TARIFF-' + energy_item_dict[energy_item_id]['name']) |
|
| 397 | parameters_data['timestamps'].append(tariff_timestamp_list) |
|
| 398 | parameters_data['values'].append(tariff_value_list) |
|
| 399 | ||
| 400 | ################################################################################################################ |
|
| 401 | # Step 10: query associated sensors and points data |
|
| @@ 542-558 (lines=17) @@ | ||
| 539 | parameters_data['names'] = list() |
|
| 540 | parameters_data['timestamps'] = list() |
|
| 541 | parameters_data['values'] = list() |
|
| 542 | if energy_category_set is not None and len(energy_category_set) > 0: |
|
| 543 | for energy_category_id in energy_category_set: |
|
| 544 | energy_category_tariff_dict = utilities.get_energy_category_tariffs(space['cost_center_id'], |
|
| 545 | energy_category_id, |
|
| 546 | reporting_start_datetime_utc, |
|
| 547 | reporting_end_datetime_utc) |
|
| 548 | tariff_timestamp_list = list() |
|
| 549 | tariff_value_list = list() |
|
| 550 | for k, v in energy_category_tariff_dict.items(): |
|
| 551 | # convert k from utc to local |
|
| 552 | k = k + timedelta(minutes=timezone_offset) |
|
| 553 | tariff_timestamp_list.append(k.isoformat()[0:19][0:19]) |
|
| 554 | tariff_value_list.append(v) |
|
| 555 | ||
| 556 | parameters_data['names'].append('TARIFF-' + energy_category_dict[energy_category_id]['name']) |
|
| 557 | parameters_data['timestamps'].append(tariff_timestamp_list) |
|
| 558 | parameters_data['values'].append(tariff_value_list) |
|
| 559 | ||
| 560 | ################################################################################################################ |
|
| 561 | # Step 10: query associated sensors and points data |
|
| @@ 502-518 (lines=17) @@ | ||
| 499 | parameters_data['names'] = list() |
|
| 500 | parameters_data['timestamps'] = list() |
|
| 501 | parameters_data['values'] = list() |
|
| 502 | if energy_category_set is not None and len(energy_category_set) > 0: |
|
| 503 | for energy_category_id in energy_category_set: |
|
| 504 | energy_category_tariff_dict = utilities.get_energy_category_tariffs(space['cost_center_id'], |
|
| 505 | energy_category_id, |
|
| 506 | reporting_start_datetime_utc, |
|
| 507 | reporting_end_datetime_utc) |
|
| 508 | tariff_timestamp_list = list() |
|
| 509 | tariff_value_list = list() |
|
| 510 | for k, v in energy_category_tariff_dict.items(): |
|
| 511 | # convert k from utc to local |
|
| 512 | k = k + timedelta(minutes=timezone_offset) |
|
| 513 | tariff_timestamp_list.append(k.isoformat()[0:19][0:19]) |
|
| 514 | tariff_value_list.append(v) |
|
| 515 | ||
| 516 | parameters_data['names'].append('TARIFF-' + energy_category_dict[energy_category_id]['name']) |
|
| 517 | parameters_data['timestamps'].append(tariff_timestamp_list) |
|
| 518 | parameters_data['values'].append(tariff_value_list) |
|
| 519 | ||
| 520 | ################################################################################################################ |
|
| 521 | # Step 10: query associated sensors and points data |
|
| @@ 461-477 (lines=17) @@ | ||
| 458 | parameters_data['names'] = list() |
|
| 459 | parameters_data['timestamps'] = list() |
|
| 460 | parameters_data['values'] = list() |
|
| 461 | if energy_category_set_input is not None and len(energy_category_set_input) > 0: |
|
| 462 | for energy_category_id in energy_category_set_input: |
|
| 463 | energy_category_tariff_dict = utilities.get_energy_category_tariffs(space['cost_center_id'], |
|
| 464 | energy_category_id, |
|
| 465 | reporting_start_datetime_utc, |
|
| 466 | reporting_end_datetime_utc) |
|
| 467 | tariff_timestamp_list = list() |
|
| 468 | tariff_value_list = list() |
|
| 469 | for k, v in energy_category_tariff_dict.items(): |
|
| 470 | # convert k from utc to local |
|
| 471 | k = k + timedelta(minutes=timezone_offset) |
|
| 472 | tariff_timestamp_list.append(k.isoformat()[0:19][0:19]) |
|
| 473 | tariff_value_list.append(v) |
|
| 474 | ||
| 475 | parameters_data['names'].append('TARIFF-' + energy_category_dict[energy_category_id]['name']) |
|
| 476 | parameters_data['timestamps'].append(tariff_timestamp_list) |
|
| 477 | parameters_data['values'].append(tariff_value_list) |
|
| 478 | ||
| 479 | ################################################################################################################ |
|
| 480 | # Step 11: query associated sensors and points data |
|
| @@ 390-406 (lines=17) @@ | ||
| 387 | parameters_data['names'] = list() |
|
| 388 | parameters_data['timestamps'] = list() |
|
| 389 | parameters_data['values'] = list() |
|
| 390 | if energy_category_set is not None and len(energy_category_set) > 0: |
|
| 391 | for energy_category_id in energy_category_set: |
|
| 392 | energy_category_tariff_dict = utilities.get_energy_category_tariffs(space['cost_center_id'], |
|
| 393 | energy_category_id, |
|
| 394 | reporting_start_datetime_utc, |
|
| 395 | reporting_end_datetime_utc) |
|
| 396 | tariff_timestamp_list = list() |
|
| 397 | tariff_value_list = list() |
|
| 398 | for k, v in energy_category_tariff_dict.items(): |
|
| 399 | # convert k from utc to local |
|
| 400 | k = k + timedelta(minutes=timezone_offset) |
|
| 401 | tariff_timestamp_list.append(k.isoformat()[0:19][0:19]) |
|
| 402 | tariff_value_list.append(v) |
|
| 403 | ||
| 404 | parameters_data['names'].append('TARIFF-' + energy_category_dict[energy_category_id]['name']) |
|
| 405 | parameters_data['timestamps'].append(tariff_timestamp_list) |
|
| 406 | parameters_data['values'].append(tariff_value_list) |
|
| 407 | ||
| 408 | ################################################################################################################ |
|
| 409 | # Step 10: query associated sensors and points data |
|
| @@ 376-392 (lines=17) @@ | ||
| 373 | parameters_data['names'] = list() |
|
| 374 | parameters_data['timestamps'] = list() |
|
| 375 | parameters_data['values'] = list() |
|
| 376 | if energy_category_set is not None and len(energy_category_set) > 0: |
|
| 377 | for energy_category_id in energy_category_set: |
|
| 378 | energy_category_tariff_dict = utilities.get_energy_category_tariffs(space['cost_center_id'], |
|
| 379 | energy_category_id, |
|
| 380 | reporting_start_datetime_utc, |
|
| 381 | reporting_end_datetime_utc) |
|
| 382 | tariff_timestamp_list = list() |
|
| 383 | tariff_value_list = list() |
|
| 384 | for k, v in energy_category_tariff_dict.items(): |
|
| 385 | # convert k from utc to local |
|
| 386 | k = k + timedelta(minutes=timezone_offset) |
|
| 387 | tariff_timestamp_list.append(k.isoformat()[0:19][0:19]) |
|
| 388 | tariff_value_list.append(v) |
|
| 389 | ||
| 390 | parameters_data['names'].append('TARIFF-' + energy_category_dict[energy_category_id]['name']) |
|
| 391 | parameters_data['timestamps'].append(tariff_timestamp_list) |
|
| 392 | parameters_data['values'].append(tariff_value_list) |
|
| 393 | ||
| 394 | ################################################################################################################ |
|
| 395 | # Step 10: query associated sensors and points data |
|
| @@ 371-387 (lines=17) @@ | ||
| 368 | parameters_data['names'] = list() |
|
| 369 | parameters_data['timestamps'] = list() |
|
| 370 | parameters_data['values'] = list() |
|
| 371 | if energy_category_set is not None and len(energy_category_set) > 0: |
|
| 372 | for energy_category_id in energy_category_set: |
|
| 373 | energy_category_tariff_dict = utilities.get_energy_category_tariffs(space['cost_center_id'], |
|
| 374 | energy_category_id, |
|
| 375 | reporting_start_datetime_utc, |
|
| 376 | reporting_end_datetime_utc) |
|
| 377 | tariff_timestamp_list = list() |
|
| 378 | tariff_value_list = list() |
|
| 379 | for k, v in energy_category_tariff_dict.items(): |
|
| 380 | # convert k from utc to local |
|
| 381 | k = k + timedelta(minutes=timezone_offset) |
|
| 382 | tariff_timestamp_list.append(k.isoformat()[0:19][0:19]) |
|
| 383 | tariff_value_list.append(v) |
|
| 384 | ||
| 385 | parameters_data['names'].append('TARIFF-' + energy_category_dict[energy_category_id]['name']) |
|
| 386 | parameters_data['timestamps'].append(tariff_timestamp_list) |
|
| 387 | parameters_data['values'].append(tariff_value_list) |
|
| 388 | ||
| 389 | ################################################################################################################ |
|
| 390 | # Step 9: query associated sensors and points data |
|
| @@ 366-382 (lines=17) @@ | ||
| 363 | parameters_data['names'] = list() |
|
| 364 | parameters_data['timestamps'] = list() |
|
| 365 | parameters_data['values'] = list() |
|
| 366 | if energy_category_set is not None and len(energy_category_set) > 0: |
|
| 367 | for energy_category_id in energy_category_set: |
|
| 368 | energy_category_tariff_dict = utilities.get_energy_category_tariffs(space['cost_center_id'], |
|
| 369 | energy_category_id, |
|
| 370 | reporting_start_datetime_utc, |
|
| 371 | reporting_end_datetime_utc) |
|
| 372 | tariff_timestamp_list = list() |
|
| 373 | tariff_value_list = list() |
|
| 374 | for k, v in energy_category_tariff_dict.items(): |
|
| 375 | # convert k from utc to local |
|
| 376 | k = k + timedelta(minutes=timezone_offset) |
|
| 377 | tariff_timestamp_list.append(k.isoformat()[0:19][0:19]) |
|
| 378 | tariff_value_list.append(v) |
|
| 379 | ||
| 380 | parameters_data['names'].append('TARIFF-' + energy_category_dict[energy_category_id]['name']) |
|
| 381 | parameters_data['timestamps'].append(tariff_timestamp_list) |
|
| 382 | parameters_data['values'].append(tariff_value_list) |
|
| 383 | ||
| 384 | ################################################################################################################ |
|
| 385 | # Step 9: query associated sensors and points data |
|
| @@ 357-373 (lines=17) @@ | ||
| 354 | parameters_data['names'] = list() |
|
| 355 | parameters_data['timestamps'] = list() |
|
| 356 | parameters_data['values'] = list() |
|
| 357 | if energy_category_set is not None and len(energy_category_set) > 0: |
|
| 358 | for energy_category_id in energy_category_set: |
|
| 359 | energy_category_tariff_dict = utilities.get_energy_category_tariffs(space['cost_center_id'], |
|
| 360 | energy_category_id, |
|
| 361 | reporting_start_datetime_utc, |
|
| 362 | reporting_end_datetime_utc) |
|
| 363 | tariff_timestamp_list = list() |
|
| 364 | tariff_value_list = list() |
|
| 365 | for k, v in energy_category_tariff_dict.items(): |
|
| 366 | # convert k from utc to local |
|
| 367 | k = k + timedelta(minutes=timezone_offset) |
|
| 368 | tariff_timestamp_list.append(k.isoformat()[0:19][0:19]) |
|
| 369 | tariff_value_list.append(v) |
|
| 370 | ||
| 371 | parameters_data['names'].append('TARIFF-' + energy_category_dict[energy_category_id]['name']) |
|
| 372 | parameters_data['timestamps'].append(tariff_timestamp_list) |
|
| 373 | parameters_data['values'].append(tariff_value_list) |
|
| 374 | ||
| 375 | ################################################################################################################ |
|
| 376 | # Step 10: query associated sensors and points data |
|
| @@ 357-373 (lines=17) @@ | ||
| 354 | parameters_data['names'] = list() |
|
| 355 | parameters_data['timestamps'] = list() |
|
| 356 | parameters_data['values'] = list() |
|
| 357 | if energy_category_set is not None and len(energy_category_set) > 0: |
|
| 358 | for energy_category_id in energy_category_set: |
|
| 359 | energy_category_tariff_dict = utilities.get_energy_category_tariffs(space['cost_center_id'], |
|
| 360 | energy_category_id, |
|
| 361 | reporting_start_datetime_utc, |
|
| 362 | reporting_end_datetime_utc) |
|
| 363 | tariff_timestamp_list = list() |
|
| 364 | tariff_value_list = list() |
|
| 365 | for k, v in energy_category_tariff_dict.items(): |
|
| 366 | # convert k from utc to local |
|
| 367 | k = k + timedelta(minutes=timezone_offset) |
|
| 368 | tariff_timestamp_list.append(k.isoformat()[0:19][0:19]) |
|
| 369 | tariff_value_list.append(v) |
|
| 370 | ||
| 371 | parameters_data['names'].append('TARIFF-' + energy_category_dict[energy_category_id]['name']) |
|
| 372 | parameters_data['timestamps'].append(tariff_timestamp_list) |
|
| 373 | parameters_data['values'].append(tariff_value_list) |
|
| 374 | ||
| 375 | ################################################################################################################ |
|
| 376 | # Step 10: query associated sensors and points data |
|