mobileDevice.js

Go to the documentation of this file.

/**
 * @file mobileDevice.js
 * @module routes/mobileDevice
 * @description Mobile device inventory management endpoint.
 * Provides paginated list of mobile devices with filtering and tenant isolation.
 * @requires express
 * @requires services/db
 * @requires middleware/auth
 * @requires middleware/tenant
 * @author RMM-PSA Development Team
 * @copyright 2026 RMM-PSA Platform
 * @license Proprietary
 */
 
/**
 * @apiDefine MobileDevice Mobile Devices
 * Mobile device inventory management
 */
 
const express = require('express');
const router = express.Router();
const pool = require('../services/db');
const authenticateToken = require('../middleware/auth');
const { getTenantFilter } = require('../middleware/tenant');
 
/**
 * @api {get} /api/mobile-device/list List mobile devices
 * @apiName ListMobileDevices
 * @apiGroup MobileDevice
 * @apiDescription Retrieve paginated list of mobile devices with filtering and search.
 * Supports filtering by customer, OS, and full-text search. Enforces tenant isolation.
 * Returns device inventory with customer/contract associations.
 * @apiParam {number} [page=1] Page number (query parameter)
 * @apiParam {number} [limit=20] Results per page (query parameter)
 * @apiParam {number} [customer_id] Filter by customer ID (query parameter)
 * @apiParam {string} [os] Filter by operating system (query parameter)
 * @apiParam {string} [search] Search device name, hostname, customer, or OS (query parameter)
 * @apiSuccess {object[]} devices Array of mobile devices
 * @apiSuccess {string} devices.device_uuid Device UUID
 * @apiSuccess {number} devices.device_id Device ID
 * @apiSuccess {number} devices.tenant_id Tenant ID
 * @apiSuccess {number} devices.customer_id Customer ID
 * @apiSuccess {string} devices.hostname Device hostname
 * @apiSuccess {string} devices.os Operating system (e.g., "iOS", "Android")
 * @apiSuccess {string} devices.os_version OS version
 * @apiSuccess {string} devices.version App version
 * @apiSuccess {DateTime} devices.last_seen Last contact timestamp
 * @apiSuccess {string} devices.name Device friendly name
 * @apiSuccess {string} devices.ip_address Device IP address
 * @apiSuccess {string} devices.user_list Associated users (comma-separated)
 * @apiSuccess {string} devices.customer_name Customer name
 * @apiSuccess {String} devices.contract_title Associated contract title
 * @apiSuccess {Number} total Total device count (for pagination)
 * 
 * @apiError (500) {String} error="Failed to list devices" Database query failed
 * 
 * @apiExample {curl} Example:
 *   curl -X GET "http://localhost:3000/api/mobile-device/list?page=1&limit=20&search=iPhone&customer_id=5" \\\\
 *     -H "Authorization: Bearer YOUR_TOKEN"
 * 
 * @apiSuccessExample {json} Success-Response:
 *   HTTP/1.1 200 OK
 *   {
 *     "devices": [
 *       {
 *         "device_uuid": "mobile-abc-123",
 *         "device_id": 42,
 *         "tenant_id": 2,
 *         "customer_id": 5,
 *         "hostname": "iPhone-John",
 *         "os": "iOS",
 *         "os_version": "17.3",
 *         "version": "1.0.5",
 *         "last_seen": "2026-03-12T10:30:00.000Z",
 *         "name": "John's iPhone",
 *         "ip_address": "192.168.1.150",
 *         "user_list": "john@acme.com",
 *         "customer_name": "Acme Corp",
 *         "contract_title": "Annual Support"
 *       }
 *     ],
 *     "total": 8
 *   }
 */
router.get('/list', authenticateToken, async (req, res) => {
  try {
    const { clause: tenantClause, params: tenantParams } = getTenantFilter(req, 'm');
    const conditions = [];
    const params = [...tenantParams];
    let paramIdx = tenantParams.length + 1;
    if (tenantClause) conditions.push(tenantClause);
    if (req.query.customer_id) {
      params.push(req.query.customer_id);
      conditions.push(`m.customer_id = $${paramIdx++}`);
    }
    if (req.query.search) {
      const search = `%${req.query.search}%`;
      params.push(search);
      conditions.push(`(m.name ILIKE $${paramIdx} OR m.hostname ILIKE $${paramIdx} OR c.name ILIKE $${paramIdx} OR m.os ILIKE $${paramIdx})`);
      paramIdx++;
    }
    if (req.query.os) {
      params.push(req.query.os);
      conditions.push(`m.os = $${paramIdx++}`);
    }
    const whereClause = conditions.length > 0 ? 'WHERE ' + conditions.join(' AND ') : '';
    const page = parseInt(req.query.page, 10) || 1;
    const limit = parseInt(req.query.limit, 10) || 20;
    const offset = (page - 1) * limit;
    const totalResult = await pool.query(`
      SELECT COUNT(*) AS total
      FROM mobile_devices m
      LEFT JOIN customers c ON c.customer_id = m.customer_id
      ${whereClause}
    `, params);
    const total = parseInt(totalResult.rows[0]?.total || '0', 10);
    const result = await pool.query(`
      SELECT 
        m.device_uuid,
        m.device_id,
        m.tenant_id,
        m.customer_id,
        m.hostname,
        m.os,
        m.os_version,
        m.version,
        m.last_seen,
        m.name,
        m.ip_address,
        m.user_list,
        c.name AS customer_name,
        ct.title AS contract_title
      FROM mobile_devices m
      LEFT JOIN customers c ON c.customer_id = m.customer_id
      LEFT JOIN contracts ct ON ct.contract_id = m.contract_id
      ${whereClause}
      ORDER BY m.hostname
      LIMIT $${paramIdx} OFFSET $${paramIdx + 1}
    `, [...params, limit, offset]);
    res.json({ devices: result.rows, total });
  } catch (err) {
    console.error('[MobileDevice] Failed to list devices:', err);
    res.status(500).json({ error: 'Failed to list devices' });
  }
});
 
module.exports = router;