/ var / www / html / greenpreneurs / api / controllers / [ HOME SHELL ]

Name	Size	Permission
admin.dashboard.controller.js	12.23 KB	-rw-r--r--
auth.controller.js	5.83 KB	-rw-r--r--
blog.controller.js	5.49 KB	-rw-r--r--
event.controller.js	1.43 KB	-rw-r--r--
homePage.controller.js	1.33 KB	-rw-r--r--
individualBlog.controller.js	4.96 KB	-rw-r--r--
user.controller.js	4.33 KB	-rw-r--r--
user.dashboard.controller.js	6.88 KB	-rw-r--r--

Code Editor : homePage.controller.js

import pool from "../config/db.js";

export const editorial = async (req, res) => {
    const query = `
        SELECT * FROM Editorial
        ORDER BY Date DESC, Time DESC
        LIMIT 1;
    `;

try {
        const [rows] = await pool.query(query); // Await the query result
        if (rows.length > 0) {
            res.status(200).json(rows[0]); // Send the latest editorial as JSON
        } else {
            res.status(404).json({ message: 'No editorials found' });
        }
    } catch (err) {
        console.error("Error fetching editorial:", err);
        res.status(500).json({ error: 'An error occurred while retrieving the latest editorial' });
    }
};

export const getentrepreneurs = async (req, res) => {
    const query = `
        SELECT 
            CONCAT(FirstName, ' ', LastName) AS FullName, 
            LinkedinProfileURL, 
            Website, 
            ProfileImage,
            Description
        FROM 
            verifiedEnt 
        WHERE 
            IsVerified = 1
    `;

try {
        const [results] = await pool.query(query); // Await the query result
        res.status(200).json(results);
    } catch (err) {
        console.error("Failed to retrieve entrepreneurs:", err);
        res.status(500).json({ error: "Failed to retrieve entrepreneurs" });
    }
};

Urban Research Lab

The Urban Research Lab (URL) at IIIT-Delhi was established in 2020, during a time when the pandemic brought the complexities of urban life more visible than ever. What started as an initiative by faculty and students has grown into a collaborative space for critically exploring and reimagining the urban questions through research, dialogue, and interdisciplinary engagement.

${this.title}

Code Editor : homePage.controller.js

Urban Research Lab