<?php
declare(strict_types=1);

Auth::requireRole('analyst');
Csrf::check();

$companyId = (int) post('company_id', 0);

if (Database::scalar('SELECT 1 FROM companies WHERE id = :id', ['id' => $companyId]) === null) {
    Flash::add('warn', 'That company no longer exists.');
    redirect('companies', 'list');
}

$visitDate = (string) post('visit_date', date('Y-m-d'));
$d = DateTimeImmutable::createFromFormat('Y-m-d', $visitDate);
if ($d === false || $d->format('Y-m-d') !== $visitDate) {
    Flash::add('error', 'That date is not valid.');
    redirect('companies', 'view', ['id' => $companyId]);
}
if ($d > new DateTimeImmutable('today')) {
    Flash::add('error', 'A check cannot be dated in the future.');
    redirect('companies', 'view', ['id' => $companyId]);
}

$significance = in_array(post('significance'), ['none', 'minor', 'major'], true)
    ? (string) post('significance') : 'none';
$findings = trim((string) post('findings', '')) ?: null;

Database::transaction(static function () use ($companyId, $visitDate, $significance, $findings) {
    Database::run(
        'INSERT INTO visits (company_id, user_id, visit_date, found_change, significance, findings)
         VALUES (:c, :u, :d, :ch, :s, :f)',
        [
            'c'  => $companyId,
            'u'  => Auth::id(),
            'd'  => $visitDate,
            'ch' => $significance === 'none' ? 0 : 1,
            's'  => $significance,
            'f'  => $findings,
        ]
    );

    // The schedule follows the newest check, never an older backfilled one.
    Database::run(
        'INSERT INTO watches (company_id, last_visit_date) VALUES (:c, :d)
         ON DUPLICATE KEY UPDATE last_visit_date =
            CASE WHEN last_visit_date IS NULL OR last_visit_date < VALUES(last_visit_date)
                 THEN VALUES(last_visit_date) ELSE last_visit_date END',
        ['c' => $companyId, 'd' => $visitDate]
    );
});

Audit::log('create', 'visit', $companyId, ['date' => $visitDate, 'significance' => $significance]);
Flash::add('ok', t('visit_saved'));
redirect('companies', 'view', ['id' => $companyId]);
