PDQ/bin/jobs_add.php

<?php
require_once __DIR__ . '/../lib/identity.php';

[$actor, ] = resolve_request_actor();
if ($actor !== 'ICG') {
    http_response_code(403);
    echo 'Only ICG can add jobs';
    exit;
}

$vendor_slug = $_POST['vendor'] ?? 'bill';
$vendor = find_vendor_by_slug($vendor_slug);
if (!$vendor) {
    http_response_code(400);
    echo 'Unknown vendor';
    exit;
}

$pdo = db();
$stmt = $pdo->prepare(
    "INSERT INTO jobs(vendor_id, job, ack, status) VALUES(?, 'New', 'new', '')"
);
$stmt->execute([$vendor['id']]);
$new_id = (int) $pdo->lastInsertId();

$pdo->prepare(
    'INSERT INTO job_history(job_id, field, old_value, new_value, actor) VALUES (?, ?, ?, ?, ?)'
)->execute([$new_id, 'created', null, $vendor['slug'], $actor]);

if (!empty($_POST['ajax'])) {
    echo $new_id;
} else {
    header('Location: ../PDQ.php');
}