server.js

require('dotenv').config();
const express = require('express');
const { createClient } = require('@supabase/supabase-js');
const cors = require('cors');
const app = express();
app.use(cors());
app.use(express.json());
app.use(express.static('public'));

app.get('/favicon.ico', (req, res) => res.status(204).end());
app.get('/api/maps-key', (req, res) => {
    res.json({ key: process.env.GOOGLE_MAPS_KEY });
});

const supabase = createClient(process.env.SUPABASE_URL, process.env.SUPABASE_KEY);

app.post('/save-bus-stop', async (req, res) => {
    try {
        const { error } = await supabase
            .from('bus_stops')
            .insert([{
                name: req.body.name,
                latitude: req.body.latitude,
                longitude: req.body.longitude,
                priority: req.body.priority,
            }]);

        if (error) {
            console.error("Error saving bus stop:", error);
            return res.status(500).json({ error: error.message });
        }

        res.status(200).json({ message: "Bus stop saved successfully" });
    } catch (err) {
        console.error("Error in /save-bus-stop:", err);
        res.status(500).json({ error: err.message });
    }
});

app.post('/save-depot', async (req, res) => {
    try {
        const { error } = await supabase
            .from('depots')
            .insert([{
                name: req.body.name,
                latitude: req.body.latitude,
                longitude: req.body.longitude,
            }]);

        if (error) {
            console.error("Error saving depot:", error);
            return res.status(500).send({ error: error.message });
        }

        res.send({ message: "Depot saved successfully" });
    } catch (err) {
        console.error("Error in /save-depot:", err);
        res.status(500).send({ error: err.message });
    }  
});

app.get('/optimized-routes', async (req, res) => {
    try {
        const { data, error } = await supabase
            .from('optimized_routes')
            .select('id, stops, distance, duration, buses, frequency');

        if (error) {
            console.error("Error fetching routes:", error);
            return res.status(500).json({ error: error.message });
        }

        res.status(200).json(data);
    } catch (err) {
        console.error("Error in /optimized-routes:", err);
        res.status(500).json({ error: err.message });
    }
});

const PORT = process.env.PORT || 3000;
app.listen(PORT, () => {
    console.log(`Server listening on port ${PORT}`);
});

app.get('/initial-location', (req, res) => {
    const initialLocation = {
        latitude: 28.7041, 
        longitude: 77.1025
    };
    res.json(initialLocation);
});

app.get('/bus-stops', async (req, res) => {
    try {
        const { data, error } = await supabase
            .from('bus_stops')
            .select('*');

        if (error) {
            console.error("Error fetching bus stops:", error);
            return res.status(500).json({ error: error.message });
        }

        res.status(200).json(data);
    } catch (err) {
        console.error("Error in /bus-stops:", err);
        res.status(500).json({ error: err.message });
    }
});

app.get('/depots', async (req, res) => {
    try {
        const { data, error } = await supabase
            .from('depots')
            .select('*');

        if (error) {
            console.error("Error fetching depots:", error);
            return res.status(500).json({ error: error.message });
        }

        res.status(200).json(data);
    } catch (err) {
        console.error("Error in /depots:", err);
        res.status(500).json({ error: err.message });
    }
});