EHS Safety & Site Audit Software: Offline Tablet Inspections & Automated CAPA Escalation

// Local Offline Inspection Mutation Queue on Ruggedized Android Tablet
// Ensures zero data loss inside ATEX Zone 1 hazardous chemical plants
export async function queueAuditChecklistMutation(
  db: SQLiteDatabase,
  auditId: string,
  checkpointId: string,
  status: 'COMPLIANT' | 'NON_CONFORMANT' | 'CRITICAL_RISK',
  evidencePhotoPath: string,
  inspectorGps: { lat: number; lng: number }
): Promise<void> {
  const payloadHash = await crypto.subtle.digest(
    'SHA-256',
    new TextEncoder().encode(`${auditId}_${checkpointId}_${Date.now()}`)
  );

  await db.transactionAsync(async (tx) => {
    // 1. Write instant audit check to encrypted local SQLite storage
    await tx.executeSqlAsync(
      `INSERT INTO local_audit_records 
       (audit_id, checkpoint_id, status, photo_path, gps_lat, gps_lng, sync_status, hash)
       VALUES (?, ?, ?, ?, ?, ?, 'PENDING', ?)`,
      [auditId, checkpointId, status, evidencePhotoPath, inspectorGps.lat, inspectorGps.lng, payloadHash]
    );

    // 2. If critical risk, trigger instant local buzzer alert without waiting for cloud
    if (status === 'CRITICAL_RISK') {
      await tx.executeSqlAsync(
        `INSERT INTO emergency_lockout_queue (audit_id, checkpoint_id, status) VALUES (?, ?, 'PENDING')`,
        [auditId, checkpointId]
      );
    }
  });
}