Visit Tracking

# Registered user lookup
user = User.query.filter_by(document_id=document_id).first()
if user:
    name, role = user.full_name, user.role

# Unregistered visitor handling
if not user:
    if not manual_name:
        flash('Documento no registrado. Por favor ingrese su Nombre.', 'warning')
        return render_template('main/visit.html', form=form, pre_doc=document_id)
    name, role = manual_name, 'Visitante'

<form method="POST" action="{{ url_for('main.register_visit') }}">
  {{ form.hidden_tag() }}
  
  <div class="form-group">
    {{ form.document_id.label }}
    {{ form.document_id(class="form-control", 
                       placeholder="Ingrese su documento",
                       value=pre_doc if pre_doc else '') }}
  </div>
  
  <div class="form-group">
    {{ form.visitor_name.label }}
    {{ form.visitor_name(class="form-control", 
                        placeholder="Solo si no está registrado") }}
  </div>
  
  <div class="form-group">
    {{ form.activity.label }}
    {{ form.activity(class="form-control") }}
  </div>
  
  {{ form.submit(class="btn btn-primary") }}
</form>

{% with messages = get_flashed_messages(with_categories=true) %}
  {% for category, message in messages %}
    <div class="alert alert-{{ category }}" role="alert">
      {{ message }}
      {# e.g., "Bienvenido/a María García. Actividad: Estudio" #}
    </div>
  {% endfor %}
{% endwith %}

from sqlalchemy import func, Date

# Daily visit counts
daily_visits = db.session.query(
    func.date(LibraryLog.entry_time).label('date'),
    func.count(LibraryLog.id).label('count')
).group_by(func.date(LibraryLog.entry_time)).all()

# Activity distribution
activity_stats = db.session.query(
    LibraryLog.activity,
    func.count(LibraryLog.id).label('count')
).group_by(LibraryLog.activity).order_by(
    func.count(LibraryLog.id).desc()
).all()

# User type breakdown
role_distribution = db.session.query(
    LibraryLog.role,
    func.count(LibraryLog.id).label('count')
).group_by(LibraryLog.role).all()

from sqlalchemy import extract

# Hourly traffic patterns
hourly_traffic = db.session.query(
    extract('hour', LibraryLog.entry_time).label('hour'),
    func.count(LibraryLog.id).label('count')
).group_by(extract('hour', LibraryLog.entry_time)).order_by('hour').all()

Setup:
  - Touchscreen tablet mounted at entrance
  - Browser locked to /visit route
  - Large, simple UI for quick entry
  - Optional barcode scanner for document IDs

Workflow:
  - User scans ID card or enters manually
  - Taps activity button
  - Receives welcome message
  - Total time: < 10 seconds

Setup:
  - Desktop computer at reception
  - /visit route open in browser tab
  
Workflow:
  - Visitor states document ID
  - Librarian enters ID and activity
  - Librarian verifies welcome message shows correct name
  - Visitor proceeds into library

@bp.route('/admin/visit_stats')
@role_required('admin', 'bibliotecario')
def visit_statistics():
    # Get date range from request
    start_date = request.args.get('start', default_start)
    end_date = request.args.get('end', default_end)
    
    # Query visits in range
    visits = LibraryLog.query.filter(
        LibraryLog.entry_time >= start_date,
        LibraryLog.entry_time <= end_date
    ).all()
    
    # Calculate statistics
    total_visits = len(visits)
    unique_visitors = len(set(v.visitor_id for v in visits))
    activity_breakdown = {...}
    
    return render_template('admin/visit_stats.html', 
                         total=total_visits,
                         unique=unique_visitors,
                         activities=activity_breakdown)

from datetime import datetime, timedelta

@staticmethod
def purge_old_visits(days=365):
    """Delete visit logs older than specified days"""
    cutoff_date = datetime.utcnow() - timedelta(days=days)
    old_visits = LibraryLog.query.filter(
        LibraryLog.entry_time < cutoff_date
    ).delete()
    db.session.commit()
    return old_visits

# Optional: Add relationship to User model
class User(UserMixin, db.Model):
    # ... existing fields ...
    visits = db.relationship('LibraryLog', 
                            primaryjoin='User.document_id==LibraryLog.visitor_id',
                            foreign_keys='LibraryLog.visitor_id',
                            backref='registered_user',
                            lazy='dynamic')

# User profile showing both loans and visits
@bp.route('/profile')
@login_required
def profile():
    loans = Loan.query.filter_by(user_id=current_user.id).all()
    visits = LibraryLog.query.filter_by(visitor_id=current_user.document_id).all()
    
    return render_template('main/profile.html', 
                         loans=loans, 
                         visits=visits)

# Suggest resources based on visit activities
frequent_activities = db.session.query(LibraryLog.activity).filter(
    LibraryLog.visitor_id == user.document_id
).group_by(LibraryLog.activity).order_by(
    func.count(LibraryLog.activity).desc()
).limit(3).all()

if 'Computadores' in [a[0] for a in frequent_activities]:
    # Recommend computing equipment catalog
    recommendations = Catalog.query.filter_by(category='computo').all()

activity = SelectField(
    'Actividad', 
    choices=[
        ('Estudio', 'Estudio'),
        ('Lectura', 'Lectura'),
        ('Computadores', 'Uso de Computadores'),
        ('Investigación', 'Investigación'),
        ('Consulta', 'Consulta de Material'),
        ('Tutoría', 'Sesión de Tutoría'),  # Custom
        ('Grupo', 'Trabajo en Grupo'),      # Custom
        ('Impresión', 'Impresión/Escaneo'), # Custom
        ('Otro', 'Otro')
    ],
    validators=[DataRequired()]
)

class LibraryLog(db.Model):
    # ... existing fields ...
    exit_time = db.Column(db.DateTime, nullable=True)
    
    @property
    def duration_minutes(self):
        if self.exit_time and self.entry_time:
            delta = self.exit_time - self.entry_time
            return delta.total_seconds() / 60
        return None