Create Energy Efficiency Improvement Costs page

• Create a map UI for showing costs
• Create bar graph separating data by Dwelling Type
• Create bar graph separating data by Boiler Type
• Create list of checkbox LADs that filters data shown in both the bar graphs including search bar for convenience

app/api/data/energyCost/filter/route.js

+import { PrismaClient } from '@prisma/client';
+// api/data/energyCost/filter route: get all energy efficiency costs by LAD (local authority district)
+
+export async function GET(request) {
+  const type = request.nextUrl.searchParams.get('type');
+  const prisma = new PrismaClient();
+
+  try {
+    const records = await prisma.heatingCost.findMany({
+      include: {
+        lad19: true
+      }
+    });
+    let aggregatedData = [];
+    let totalData;
+    if (type == 'dwelling') {
+      totalData = [
+        { name: 'Detached', value: 0 },
+        { name: 'Flats', value: 0 },
+        { name: 'Semi-Detached', value: 0 },
+        { name: 'Terraced', value: 0 }
+      ];
+      records.map((lad) => {
+        let detached =
+          parseFloat(lad.detached_Biomass) +
+          parseFloat(lad.detached_Gas) +
+          parseFloat(lad.detached_Oil) +
+          parseFloat(lad.detached_Resistance);
+        let flats =
+          parseFloat(lad.flats_Biomass) +
+          parseFloat(lad.flats_Gas) +
+          parseFloat(lad.flats_Oil) +
+          parseFloat(lad.flats_Resistance);
+        let semi =
+          parseFloat(lad.semi_detached_Biomass) +
+          parseFloat(lad.semi_detached_Gas) +
+          parseFloat(lad.semi_detached_Oil) +
+          parseFloat(lad.semi_detached_Resistance);
+        let terraced =
+          parseFloat(lad.terraced_Biomass) +
+          parseFloat(lad.terraced_Gas) +
+          parseFloat(lad.terraced_Oil) +
+          parseFloat(lad.terraced_Resistance);
+        aggregatedData.push({
+          Detached: detached,
+          Flats: flats,
+          'Semi-Detached': semi,
+          Terraced: terraced,
+          lad19cd: lad.lad19.lad19cd,
+          lad19nm: lad.lad19nm
+        });
+        totalData.find((v) => v.name == 'Detached').value += detached;
+        totalData.find((v) => v.name == 'Flats').value += flats;
+        totalData.find((v) => v.name == 'Semi-Detached').value += semi;
+        totalData.find((v) => v.name == 'Terraced').value += terraced;
+      });
+    } else if (type == 'boiler') {
+      totalData = [
+        { name: 'Biomass', value: 0 },
+        { name: 'Gas', value: 0 },
+        { name: 'Oil', value: 0 },
+        { name: 'Resistance', value: 0 }
+      ];
+      records.map((lad) => {
+        let biomass =
+          parseFloat(lad.detached_Biomass) +
+          parseFloat(lad.flats_Biomass) +
+          parseFloat(lad.semi_detached_Biomass) +
+          parseFloat(lad.terraced_Biomass);
+        let gas =
+          parseFloat(lad.flats_Gas) +
+          parseFloat(lad.detached_Gas) +
+          parseFloat(lad.semi_detached_Gas) +
+          parseFloat(lad.terraced_Gas);
+        let oil =
+          parseFloat(lad.detached_Oil) +
+          parseFloat(lad.flats_Oil) +
+          parseFloat(lad.semi_detached_Oil) +
+          parseFloat(lad.terraced_Oil);
+        let resistance =
+          parseFloat(lad.detached_Resistance) +
+          parseFloat(lad.flats_Resistance) +
+          parseFloat(lad.semi_detached_Resistance) +
+          parseFloat(lad.terraced_Resistance);
+        aggregatedData.push({
+          Biomass: biomass,
+          Gas: gas,
+          Oil: oil,
+          Resistance: resistance,
+          lad19cd: lad.lad19.lad19cd,
+          lad19nm: lad.lad19nm
+        });
+        totalData.find((v) => v.name == 'Biomass').value += biomass;
+        totalData.find((v) => v.name == 'Gas').value += gas;
+        totalData.find((v) => v.name == 'Oil').value += oil;
+        totalData.find((v) => v.name == 'Resistance').value += resistance;
+      });
+    }
+    return Response.json({ total: totalData, aggregate: aggregatedData });
+  } catch (error) {
+    console.error('Prisma error: ', error);
+    return Response.json({ error: 'Something went wrong' });
+  }
+}