Janady13/oversize-route-builder / server/routes/routes.js

Source identity

Field	Recorded value
Source type	GitHub source
Original record	Janady13/oversize-route-builder / server/routes/routes.js
Date	Not specified in source
Repository	Janady13/oversize-route-builder
Revision	8630196cd162b68cf069cdabcc5487b49dcc625d
Branch	main
Path or archive member	server/routes/routes.js
Original SHA-256	a053fec23c9e002c47aef70a4f86fa56aeecb21a9fd643f51ecb9bb54c78d134
Git blob SHA	3f446a471a1de9d269dbbd48eff8e08594717abc
Reading-copy SHA-256	a053fec23c9e002c47aef70a4f86fa56aeecb21a9fd643f51ecb9bb54c78d134

Original source ↗

Recovered source transcript

Download complete source text ↓48 lines · 1.4 KB

const express = require('express');
const router = express.Router();
const db = require('../config/database');
const { authMiddleware } = require('../middleware/auth');

// Get all routes for user
router.get('/', authMiddleware, async (req, res) => {
  try {
    const result = await db.query(
      `SELECT r.*, p.permit_number, p.state
       FROM routes r
       JOIN permits p ON r.permit_id = p.id
       WHERE r.user_id = $1
       ORDER BY r.created_at DESC`,
      [req.user.id]
    );
    res.json({ routes: result.rows });
  } catch (error) {
    console.error('Get routes error:', error);
    res.status(500).json({ error: { message: 'Error fetching routes' } });
  }
});

// Get single route
router.get('/:id', authMiddleware, async (req, res) => {
  try {
    const result = await db.query(
      `SELECT r.*, p.permit_number, p.state, ls.*
       FROM routes r
       JOIN permits p ON r.permit_id = p.id
       LEFT JOIN load_specs ls ON p.id = ls.permit_id
       WHERE r.id = $1 AND r.user_id = $2`,
      [req.params.id, req.user.id]
    );
    
    if (result.rows.length === 0) {
      return res.status(404).json({ error: { message: 'Route not found' } });
    }
    
    res.json({ route: result.rows[0] });
  } catch (error) {
    console.error('Get route error:', error);
    res.status(500).json({ error: { message: 'Error fetching route' } });
  }
});

module.exports = router;