2026-08-14 18:02:25 +02:00
|
|
|
"""
|
|
|
|
|
Contracts Routes - GMAO College
|
|
|
|
|
Suivi des contrats d'entreprise.
|
|
|
|
|
"""
|
|
|
|
|
from flask import Blueprint, render_template, request, redirect, url_for, flash, jsonify
|
|
|
|
|
from flask_login import login_required, current_user
|
|
|
|
|
from ..extensions import db
|
2026-08-15 01:26:22 +02:00
|
|
|
from ..contracts.models import Contract, ContractVisit
|
2026-08-14 18:02:25 +02:00
|
|
|
from ..core.models.maintenance import Lot
|
|
|
|
|
from ..core.models.equipment import Equipment
|
|
|
|
|
from ..companies.routes import Company
|
2026-08-15 01:26:22 +02:00
|
|
|
from datetime import datetime, date, timedelta, timezone
|
2026-08-14 18:02:25 +02:00
|
|
|
|
2026-08-14 23:39:55 +02:00
|
|
|
def _optional_date(value):
|
|
|
|
|
return datetime.strptime(value, '%Y-%m-%d').date() if value else None
|
|
|
|
|
|
|
|
|
|
def _apply_visits(contract):
|
|
|
|
|
contract.visit_interval_days = request.form.get('visit_interval_days', type=int)
|
|
|
|
|
contract.last_visit_date = _optional_date(request.form.get('last_visit_date'))
|
|
|
|
|
contract.next_visit_date = _optional_date(request.form.get('next_visit_date'))
|
|
|
|
|
|
2026-08-15 01:26:22 +02:00
|
|
|
|
|
|
|
|
def _generate_visits(contract, horizon_days=365):
|
|
|
|
|
"""Matérialise le calendrier contractuel sans créer de doublons."""
|
|
|
|
|
if not contract.visit_interval_days or contract.visit_interval_days <= 0:
|
|
|
|
|
return 0
|
|
|
|
|
cursor = contract.next_visit_date or contract.start_date
|
|
|
|
|
if contract.last_visit_date and cursor <= contract.last_visit_date:
|
|
|
|
|
cursor = contract.last_visit_date + timedelta(days=contract.visit_interval_days)
|
|
|
|
|
horizon = min(date.today() + timedelta(days=horizon_days), contract.end_date) if contract.end_date else date.today() + timedelta(days=horizon_days)
|
|
|
|
|
existing = {visit.scheduled_date for visit in contract.visits}
|
|
|
|
|
created = 0
|
|
|
|
|
while cursor and cursor <= horizon:
|
|
|
|
|
if cursor >= contract.start_date and cursor not in existing:
|
|
|
|
|
db.session.add(ContractVisit(contract=contract, scheduled_date=cursor))
|
|
|
|
|
created += 1
|
|
|
|
|
cursor += timedelta(days=contract.visit_interval_days)
|
|
|
|
|
return created
|
|
|
|
|
|
2026-08-14 18:02:25 +02:00
|
|
|
contracts_bp = Blueprint('contracts', __name__, url_prefix='/contracts', template_folder='templates')
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
@contracts_bp.route('/')
|
|
|
|
|
@login_required
|
|
|
|
|
def index():
|
|
|
|
|
"""Liste de tous les contrats."""
|
|
|
|
|
contracts = Contract.query.order_by(
|
|
|
|
|
db.case((Contract.end_date.is_(None), 1), else_=0),
|
|
|
|
|
Contract.end_date.asc()
|
|
|
|
|
).all()
|
|
|
|
|
|
|
|
|
|
# Stats
|
|
|
|
|
active = sum(1 for c in contracts if c.is_active)
|
|
|
|
|
expiring = sum(1 for c in contracts if c.is_expiring_soon)
|
|
|
|
|
notice = sum(1 for c in contracts if c.must_send_notice_now)
|
|
|
|
|
expired = sum(1 for c in contracts if c.status == 'expire' or (c.end_date and c.end_date < date.today() and c.status == 'actif'))
|
|
|
|
|
|
|
|
|
|
return render_template('contracts/index.html',
|
|
|
|
|
contracts=contracts,
|
|
|
|
|
active_count=active,
|
|
|
|
|
expiring_count=expiring,
|
|
|
|
|
notice_count=notice,
|
|
|
|
|
expired_count=expired)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
@contracts_bp.route('/new', methods=['GET', 'POST'])
|
|
|
|
|
@login_required
|
|
|
|
|
def create():
|
|
|
|
|
"""Creer un contrat."""
|
|
|
|
|
lots = Lot.query.order_by(Lot.name).all()
|
|
|
|
|
equipments = Equipment.query.order_by(Equipment.name).all()
|
|
|
|
|
companies = Company.query.order_by(Company.name).all()
|
|
|
|
|
|
|
|
|
|
if request.method == 'POST':
|
|
|
|
|
contract = Contract(
|
|
|
|
|
name=request.form.get('name'),
|
|
|
|
|
contract_number=request.form.get('contract_number'),
|
|
|
|
|
lot_id=request.form.get('lot_id') or None,
|
|
|
|
|
equipment_id=request.form.get('equipment_id') or None,
|
|
|
|
|
company_id=request.form.get('company_id') or None,
|
|
|
|
|
signed_date=datetime.strptime(request.form.get('signed_date'), '%Y-%m-%d').date() if request.form.get('signed_date') else None,
|
|
|
|
|
start_date=datetime.strptime(request.form.get('start_date'), '%Y-%m-%d').date() if request.form.get('start_date') else date.today(),
|
|
|
|
|
end_date=datetime.strptime(request.form.get('end_date'), '%Y-%m-%d').date() if request.form.get('end_date') else None,
|
|
|
|
|
tacit_renewal=request.form.get('tacit_renewal') == '1',
|
|
|
|
|
renewal_period_days=int(request.form.get('renewal_period_days', 365)),
|
|
|
|
|
notice_period_days=int(request.form.get('notice_period_days')) if request.form.get('notice_period_days') else None,
|
|
|
|
|
notice_deadline=datetime.strptime(request.form.get('notice_deadline'), '%Y-%m-%d').date() if request.form.get('notice_deadline') else None,
|
|
|
|
|
annual_amount=float(request.form.get('annual_amount')) if request.form.get('annual_amount') else None,
|
|
|
|
|
status=request.form.get('status', 'actif'),
|
|
|
|
|
notes=request.form.get('notes', ''),
|
|
|
|
|
)
|
|
|
|
|
db.session.add(contract)
|
2026-08-14 23:39:55 +02:00
|
|
|
_apply_visits(contract)
|
2026-08-15 01:26:22 +02:00
|
|
|
db.session.flush()
|
|
|
|
|
_generate_visits(contract)
|
2026-08-14 18:02:25 +02:00
|
|
|
db.session.commit()
|
|
|
|
|
flash('Contrat cree avec succes.', 'success')
|
|
|
|
|
return redirect(url_for('contracts.detail', id=contract.id))
|
|
|
|
|
|
|
|
|
|
# Pre-remplir si lot_id ou equipment_id dans l'URL
|
|
|
|
|
pre_lot = request.args.get('lot_id', type=int)
|
|
|
|
|
pre_eq = request.args.get('equipment_id', type=int)
|
|
|
|
|
pre_company = request.args.get('company_id', type=int)
|
|
|
|
|
|
|
|
|
|
return render_template('contracts/form.html',
|
|
|
|
|
lots=lots, equipments=equipments, companies=companies,
|
|
|
|
|
pre_lot=pre_lot, pre_eq=pre_eq, pre_company=pre_company,
|
|
|
|
|
contract=None)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
@contracts_bp.route('/<int:id>')
|
|
|
|
|
@login_required
|
|
|
|
|
def detail(id):
|
|
|
|
|
"""Detail d'un contrat."""
|
|
|
|
|
contract = Contract.query.get_or_404(id)
|
|
|
|
|
return render_template('contracts/detail.html', contract=contract)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
@contracts_bp.route('/<int:id>/edit', methods=['GET', 'POST'])
|
|
|
|
|
@login_required
|
|
|
|
|
def edit(id):
|
|
|
|
|
"""Modifier un contrat."""
|
|
|
|
|
contract = Contract.query.get_or_404(id)
|
|
|
|
|
lots = Lot.query.order_by(Lot.name).all()
|
|
|
|
|
equipments = Equipment.query.order_by(Equipment.name).all()
|
|
|
|
|
companies = Company.query.order_by(Company.name).all()
|
|
|
|
|
|
|
|
|
|
if request.method == 'POST':
|
|
|
|
|
contract.name = request.form.get('name')
|
|
|
|
|
contract.contract_number = request.form.get('contract_number')
|
|
|
|
|
contract.lot_id = request.form.get('lot_id') or None
|
|
|
|
|
contract.equipment_id = request.form.get('equipment_id') or None
|
|
|
|
|
contract.company_id = request.form.get('company_id') or None
|
|
|
|
|
contract.signed_date = datetime.strptime(request.form.get('signed_date'), '%Y-%m-%d').date() if request.form.get('signed_date') else None
|
|
|
|
|
contract.start_date = datetime.strptime(request.form.get('start_date'), '%Y-%m-%d').date() if request.form.get('start_date') else date.today()
|
|
|
|
|
contract.end_date = datetime.strptime(request.form.get('end_date'), '%Y-%m-%d').date() if request.form.get('end_date') else None
|
|
|
|
|
contract.tacit_renewal = request.form.get('tacit_renewal') == '1'
|
|
|
|
|
contract.renewal_period_days = int(request.form.get('renewal_period_days', 365))
|
|
|
|
|
contract.notice_period_days = int(request.form.get('notice_period_days')) if request.form.get('notice_period_days') else None
|
|
|
|
|
contract.notice_deadline = datetime.strptime(request.form.get('notice_deadline'), '%Y-%m-%d').date() if request.form.get('notice_deadline') else None
|
|
|
|
|
contract.annual_amount = float(request.form.get('annual_amount')) if request.form.get('annual_amount') else None
|
|
|
|
|
contract.status = request.form.get('status', 'actif')
|
|
|
|
|
contract.notes = request.form.get('notes', '')
|
2026-08-14 23:39:55 +02:00
|
|
|
_apply_visits(contract)
|
2026-08-15 01:26:22 +02:00
|
|
|
_generate_visits(contract)
|
2026-08-14 18:02:25 +02:00
|
|
|
db.session.commit()
|
|
|
|
|
flash('Contrat modifie.', 'success')
|
|
|
|
|
return redirect(url_for('contracts.detail', id=contract.id))
|
|
|
|
|
|
|
|
|
|
return render_template('contracts/form.html',
|
|
|
|
|
contract=contract, lots=lots, equipments=equipments, companies=companies,
|
|
|
|
|
pre_lot=None, pre_eq=None, pre_company=None)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
@contracts_bp.route('/<int:id>/delete', methods=['POST'])
|
|
|
|
|
@login_required
|
|
|
|
|
def delete(id):
|
|
|
|
|
"""Supprimer un contrat."""
|
|
|
|
|
contract = Contract.query.get_or_404(id)
|
|
|
|
|
db.session.delete(contract)
|
|
|
|
|
db.session.commit()
|
|
|
|
|
flash('Contrat supprime.', 'success')
|
|
|
|
|
return redirect(url_for('contracts.index'))
|
|
|
|
|
|
|
|
|
|
|
2026-08-15 01:26:22 +02:00
|
|
|
@contracts_bp.route('/<int:id>/visits/generate', methods=['POST'])
|
|
|
|
|
@login_required
|
|
|
|
|
def generate_visits(id):
|
|
|
|
|
contract = Contract.query.get_or_404(id)
|
|
|
|
|
count = _generate_visits(contract)
|
|
|
|
|
db.session.commit()
|
|
|
|
|
flash(f'{count} visite(s) ajoutée(s) au calendrier.', 'success')
|
|
|
|
|
return redirect(url_for('contracts.detail', id=id))
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
@contracts_bp.route('/<int:id>/visits/<int:visit_id>/complete', methods=['POST'])
|
|
|
|
|
@login_required
|
|
|
|
|
def complete_visit(id, visit_id):
|
|
|
|
|
contract = Contract.query.get_or_404(id)
|
|
|
|
|
visit = ContractVisit.query.filter_by(id=visit_id, contract_id=id).first_or_404()
|
|
|
|
|
visit.status = 'realisee'
|
|
|
|
|
visit.completed_at = datetime.now(timezone.utc)
|
|
|
|
|
visit.report = (request.form.get('report') or '').strip() or None
|
|
|
|
|
contract.last_visit_date = visit.scheduled_date
|
|
|
|
|
contract.next_visit_date = visit.scheduled_date + timedelta(days=contract.visit_interval_days) if contract.visit_interval_days else None
|
|
|
|
|
_generate_visits(contract)
|
|
|
|
|
db.session.commit()
|
|
|
|
|
flash('Visite extérieure marquée comme réalisée.', 'success')
|
|
|
|
|
return redirect(url_for('contracts.detail', id=id))
|
|
|
|
|
|
|
|
|
|
|
2026-08-14 18:02:25 +02:00
|
|
|
@contracts_bp.route('/api/summary')
|
|
|
|
|
@login_required
|
|
|
|
|
def api_summary():
|
|
|
|
|
"""Resume des contrats pour le dashboard."""
|
|
|
|
|
contracts = Contract.query.filter_by(status='actif').all()
|
|
|
|
|
return jsonify({
|
|
|
|
|
'total': len(contracts),
|
|
|
|
|
'active': sum(1 for c in contracts if c.is_active),
|
|
|
|
|
'expiring_soon': sum(1 for c in contracts if c.is_expiring_soon),
|
|
|
|
|
'must_send_notice': sum(1 for c in contracts if c.must_send_notice_now),
|
|
|
|
|
'expired': sum(1 for c in contracts if c.end_date and c.end_date < date.today()),
|
2026-08-14 23:39:55 +02:00
|
|
|
})
|