server.js

const express = require('express');
const path = require('path');

function createApp(db) {
    const app = express();
    app.set('view engine', 'ejs');
    app.set('views', path.join(__dirname, 'views'));
    app.use(express.urlencoded({ extended: true }));
    app.use(express.json());

    // Attach db to app for routes to access
    app.locals.db = db;

    // Register routes
    app.use('/', require('./routes/dashboard'));
    app.use('/freelancers', require('./routes/freelancers'));
    app.use('/projects', require('./routes/projects'));
    app.use('/invoices', require('./routes/invoices'));
    app.use('/reports', require('./routes/reports'));

    return app;
}

module.exports = { createApp };

// Start server only when run directly
if (require.main === module) {
    const fs = require('fs');
    const { createDb } = require('./db');

    // Ensure data directory exists
    const dataDir = path.join(__dirname, 'data');
    if (!fs.existsSync(dataDir)) fs.mkdirSync(dataDir);

    const db = createDb(path.join(dataDir, 'gigpay.db'));

    // Auto-seed if database is empty
    const count = db.prepare('SELECT COUNT(*) as c FROM freelancers').get().c;
    if (count === 0) {
        const { seedDb } = require('./seed');
        seedDb(db);
    }

    const app = createApp(db);
    const port = process.env.PORT || 3000;
    app.listen(port, () => console.log(`GigPay running at http://localhost:${port}`));
}