@@ 763-775 (lines=13) @@ | ||
760 | result['base_period_cost']['values'] = list() |
|
761 | result['base_period_cost']['subtotals'] = list() |
|
762 | result['base_period_cost']['total'] = Decimal(0.0) |
|
763 | if energy_category_set is not None and len(energy_category_set) > 0: |
|
764 | for energy_category_id in energy_category_set: |
|
765 | result['base_period_cost']['names'].append( |
|
766 | energy_category_dict[energy_category_id]['name']) |
|
767 | result['base_period_cost']['units'].append( |
|
768 | energy_category_dict[energy_category_id]['unit_of_measure']) |
|
769 | result['base_period_cost']['timestamps'].append( |
|
770 | base_cost[energy_category_id]['timestamps']) |
|
771 | result['base_period_cost']['values'].append( |
|
772 | base_cost[energy_category_id]['values']) |
|
773 | result['base_period_cost']['subtotals'].append( |
|
774 | base_cost[energy_category_id]['subtotal']) |
|
775 | result['base_period_cost']['total'] += base_cost[energy_category_id]['subtotal'] |
|
776 | ||
777 | result['reporting_period_input'] = dict() |
|
778 | result['reporting_period_input']['names'] = list() |
|
@@ 917-928 (lines=12) @@ | ||
914 | result['child_space_input']['subtotals_array'] = list() # 2D array [energy category][child space] |
|
915 | result['child_space_input']['subtotals_in_kgce_array'] = list() # 2D array [energy category][child space] |
|
916 | result['child_space_input']['subtotals_in_kgco2e_array'] = list() # 2D array [energy category][child space] |
|
917 | if energy_category_set is not None and len(energy_category_set) > 0: |
|
918 | for energy_category_id in energy_category_set: |
|
919 | result['child_space_input']['energy_category_names'].append( |
|
920 | energy_category_dict[energy_category_id]['name']) |
|
921 | result['child_space_input']['units'].append( |
|
922 | energy_category_dict[energy_category_id]['unit_of_measure']) |
|
923 | result['child_space_input']['child_space_names_array'].append( |
|
924 | child_space_input[energy_category_id]['child_space_names']) |
|
925 | result['child_space_input']['subtotals_array'].append( |
|
926 | child_space_input[energy_category_id]['subtotals']) |
|
927 | result['child_space_input']['subtotals_in_kgce_array'].append( |
|
928 | child_space_input[energy_category_id]['subtotals_in_kgce']) |
|
929 | result['child_space_input']['subtotals_in_kgco2e_array'].append( |
|
930 | child_space_input[energy_category_id]['subtotals_in_kgco2e']) |
|
931 |
@@ 624-635 (lines=12) @@ | ||
621 | result['child_space']['subtotals_array'] = list() # 2D array [energy category][child space] |
|
622 | result['child_space']['subtotals_in_kgce_array'] = list() # 2D array [energy category][child space] |
|
623 | result['child_space']['subtotals_in_kgco2e_array'] = list() # 2D array [energy category][child space] |
|
624 | if energy_category_set is not None and len(energy_category_set) > 0: |
|
625 | for energy_category_id in energy_category_set: |
|
626 | result['child_space']['energy_category_names'].append(energy_category_dict[energy_category_id]['name']) |
|
627 | result['child_space']['units'].append(energy_category_dict[energy_category_id]['unit_of_measure']) |
|
628 | result['child_space']['child_space_names_array'].append( |
|
629 | child_space_data[energy_category_id]['child_space_names']) |
|
630 | result['child_space']['subtotals_array'].append( |
|
631 | child_space_data[energy_category_id]['subtotals']) |
|
632 | result['child_space']['subtotals_in_kgce_array'].append( |
|
633 | child_space_data[energy_category_id]['subtotals_in_kgce']) |
|
634 | result['child_space']['subtotals_in_kgco2e_array'].append( |
|
635 | child_space_data[energy_category_id]['subtotals_in_kgco2e']) |
|
636 | # export result to Excel file and then encode the file to base64 string |
|
637 | result['excel_bytes_base64'] = excelexporters.spaceenergycategory.export(result, |
|
638 | space['name'], |
@@ 762-773 (lines=12) @@ | ||
759 | result['child_space']['subtotals_saving_array'] = list() # 2D array [energy category][child space] |
|
760 | result['child_space']['subtotals_in_kgce_saving_array'] = list() # 2D array [energy category][child space] |
|
761 | result['child_space']['subtotals_in_kgco2e_saving_array'] = list() # 2D array [energy category][child space] |
|
762 | if energy_category_set is not None and len(energy_category_set) > 0: |
|
763 | for energy_category_id in energy_category_set: |
|
764 | result['child_space']['energy_category_names'].append(energy_category_dict[energy_category_id]['name']) |
|
765 | result['child_space']['units'].append(energy_category_dict[energy_category_id]['unit_of_measure']) |
|
766 | result['child_space']['child_space_names_array'].append( |
|
767 | child_space_data[energy_category_id]['child_space_names']) |
|
768 | result['child_space']['subtotals_saving_array'].append( |
|
769 | child_space_data[energy_category_id]['subtotals_saving']) |
|
770 | result['child_space']['subtotals_in_kgce_saving_array'].append( |
|
771 | child_space_data[energy_category_id]['subtotals_in_kgce_saving']) |
|
772 | result['child_space']['subtotals_in_kgco2e_saving_array'].append( |
|
773 | child_space_data[energy_category_id]['subtotals_in_kgco2e_saving']) |
|
774 | ||
775 | # export result to Excel file and then encode the file to base64 string |
|
776 | result['excel_bytes_base64'] = excelexporters.spacesaving.export(result, |