DojoOps: CRM Custom per
Agenzie Digitali

Supporto trasparente per SQLite (sviluppo) e PostgreSQL (produzione) con la stessa API.

// Unified database interface
export const db = {
  async query<T>(sql: string, params?: any[]) {
    if (shouldUsePostgres()) {
      return postgresQuery<T>(sql, params);
    }
    return sqliteQuery<T>(sql, params);
  }
};

// Usage is identical regardless of database
const clients = await db.query<Client[]>(
  'SELECT * FROM clients WHERE status = $1',
  ['active']
);

Calcolo automatico delle date basato su firma contratto e dipendenze tra fasi.

function calculatePhaseDate(
  step: TimelineStep,
  signatureDate: Date
): Date {
  if (step.dependency.type === 'signature') {
    return addDays(signatureDate, step.dependency.offsetDays);
  }

  if (step.dependency.type === 'end-of') {
    const parentEnd = getPhaseEndDate(step.dependency.stepId);
    return addDays(parentEnd, step.dependency.offsetDays);
  }

  return signatureDate;
}

Tracking granulare del tempo speso su ogni sezione della proposta.

// Track section view with time spent
await db.query(`
  INSERT INTO proposal_section_views
  (proposal_id, section_type, time_spent_ms, scroll_depth)
  VALUES ($1, $2, $3, $4)
  ON CONFLICT (proposal_id, section_id, view_session_id)
  DO UPDATE SET
    time_spent_ms = time_spent_ms + $3,
    last_updated_at = NOW()
`, [proposalId, sectionType, timeSpent, scrollDepth]);