Vendor Templates) - making, changing (the
* vendors made from it that still said what it did changing with it),
* copying, archiving, restoring and deleting them, saying who should have
* one, and taking them to and from a file (functions/vendor_template_transfer.php).
* The work is in functions/vendor_template.php; a vendor is made from
* one by add_vendor, add_vendor_from_template and
* add_vendor_template_to_clients, and brought in line with one, linked to one
* or unlinked by update_vendors_from_template, link_vendors_to_template and
* unlink_vendor_template (agent/post/vendor.php).
*/
defined('FROM_POST_HANDLER') || die("Direct file access is not allowed");
/* The template a request is for - or back to the list, saying it is gone. */
function vendorTemplateForRequest($vendor_template_id) {
$row = vendorTemplateInfo($vendor_template_id);
if (!$row) {
flashAlert('That vendor template no longer exists.', 'error');
redirect('vendor_templates.php');
}
return $row;
}
if (isset($_POST['add_vendor_template']) || isset($_POST['edit_vendor_template'])) {
validateCSRFToken();
$editing = isset($_POST['edit_vendor_template']);
$before = $editing ? vendorTemplateForRequest($_POST['vendor_template_id'] ?? 0) : null;
$vendor_template_id = $before ? intval($before['vendor_template_id']) : 0;
$fields = vendorTemplateFields($_POST, $error);
if (!$fields) {
flashAlert(escapeHtml($error), 'error');
redirect();
}
$vendor_template_id = vendorTemplateSave($vendor_template_id, $fields);
$name = $fields['name'];
if ($editing) {
$changed = vendorTemplateChanged(vendorTemplateRowFields($before), $fields);
$renamed = $before['vendor_template_name'] !== $name ? ' (was ' . $before['vendor_template_name'] . ')' : '';
logAudit("Vendor Template", "Edit", "$session_name edited vendor template " . escapeSql($name . $renamed) . ($changed ? ' - ' . escapeSql(mb_strtolower(implode(', ', $changed))) : ''), 0, $vendor_template_id);
// The vendors made from it that still said what it did follow it (vendorTemplateFollow())
$followed = !empty($_POST['follow']) ? vendorTemplateFollow($vendor_template_id, vendorTemplateRowFields($before), $fields) : [];
foreach ($followed as $vendor_id => $vendor) {
logAudit("Vendor", "Edit", "$session_name updated vendor " . escapeSql($vendor['name']) . " from template " . escapeSql($name) . " - " . escapeSql(mb_strtolower(implode(', ', $vendor['fields']))), $vendor['client_id'], $vendor_id);
}
$out_of_step = $followed || !empty($_POST['follow']) ? (vendorTemplateOutOfStep([$vendor_template_id])[$vendor_template_id] ?? 0) : 0;
flashAlert("Vendor template " . escapeHtml($name) . " saved" . ($followed ? ", and " . count($followed) . " vendor" . (count($followed) === 1 ? '' : 's') . " made from it changed with it" : '')
. ($out_of_step ? " - $out_of_step out of step" : ''));
redirect();
}
// Made from one of a client's vendors - that vendor is now made from it
$from_vendor = vendorRow($_POST['from_vendor'] ?? 0);
if ($from_vendor) {
mysqli_query($mysqli, "UPDATE vendors SET vendor_template_id = $vendor_template_id, vendor_updated_at = vendor_updated_at WHERE vendor_id = " . intval($from_vendor['vendor_id']));
}
logAudit("Vendor Template", "Create", "$session_name created vendor template " . escapeSql($name) . ($from_vendor ? " from vendor " . escapeSql($from_vendor['vendor_name']) . ($from_vendor['client_name'] !== null ? " of " . escapeSql($from_vendor['client_name']) : '') : ''), 0, $vendor_template_id);
flashAlert("Vendor template " . escapeHtml($name) . " created");
// A new one opens on its page
redirect("vendor_template.php?vendor_template_id=$vendor_template_id");
}
if (isset($_GET['copy_vendor_template'])) {
validateCSRFToken();
$row = vendorTemplateForRequest($_GET['copy_vendor_template']);
$new_id = vendorTemplateCopy($row['vendor_template_id']);
$new_name = (string) vendorTemplateInfo($new_id)['vendor_template_name'];
logAudit("Vendor Template", "Create", "$session_name copied vendor template " . escapeSql($row['vendor_template_name']) . " as " . escapeSql($new_name), 0, $new_id);
flashAlert("Vendor template " . escapeHtml($row['vendor_template_name']) . " copied as " . escapeHtml($new_name) . "");
redirect("vendor_template.php?vendor_template_id=$new_id");
}
if (isset($_GET['archive_vendor_template']) || isset($_GET['restore_vendor_template'])) {
validateCSRFToken();
$archive = isset($_GET['archive_vendor_template']);
$row = vendorTemplateForRequest($archive ? $_GET['archive_vendor_template'] : $_GET['restore_vendor_template']);
$vendor_template_id = intval($row['vendor_template_id']);
// Archived, it isn't offered for new vendors; the ones made from it stay
mysqli_query($mysqli, "UPDATE vendor_templates SET vendor_template_archived_at = " . ($archive ? 'NOW()' : 'NULL') . ", vendor_template_updated_at = vendor_template_updated_at
WHERE vendor_template_id = $vendor_template_id");
logAudit("Vendor Template", $archive ? "Archive" : "Restore", "$session_name " . ($archive ? 'archived' : 'restored') . " vendor template " . escapeSql($row['vendor_template_name']), 0, $vendor_template_id);
flashAlert("Vendor template " . escapeHtml($row['vendor_template_name']) . " " . ($archive ? 'archived' : 'restored'), $archive ? 'error' : 'success');
redirect();
}
if (isset($_GET['delete_vendor_template'])) {
validateCSRFToken();
$row = vendorTemplateForRequest($_GET['delete_vendor_template']);
// The vendors made from it stay, no longer linked to it
vendorTemplateDelete($row['vendor_template_id']);
logAudit("Vendor Template", "Delete", "$session_name deleted vendor template " . escapeSql($row['vendor_template_name']), 0, intval($row['vendor_template_id']));
flashAlert("Vendor template " . escapeHtml($row['vendor_template_name']) . " deleted", 'error');
// From its own page, back to the list
redirect(!empty($_GET['from_page']) ? 'vendor_templates.php' : null);
}
if (isset($_POST['save_vendor_template_required'])) {
// Who should have a vendor from it
validateCSRFToken();
$row = vendorTemplateForRequest($_POST['vendor_template_id'] ?? 0);
$vendor_template_id = intval($row['vendor_template_id']);
$required = intval($_POST['required'] ?? 0);
$tag_ids = array_map('intval', array_filter((array) ($_POST['tags'] ?? []), 'is_scalar'));
if ($required === VENDOR_TEMPLATE_REQUIRED_TAGGED && !array_filter($tag_ids)) {
flashAlert('Pick the client tags - or Every client.', 'error');
redirect();
}
vendorTemplateSetRequired($vendor_template_id, $required, $tag_ids);
$saved = vendorTemplateInfo($vendor_template_id);
$scope = vendorTemplateScopeText($saved['vendor_template_required'], vendorTemplateRequiredTags([$vendor_template_id])[$vendor_template_id]);
$said = $scope !== '' ? "required of " . lcfirst($scope) : 'not required of anyone';
logAudit("Vendor Template", "Edit", "$session_name set vendor template " . escapeSql($row['vendor_template_name']) . " " . escapeSql($said), 0, $vendor_template_id);
flashAlert("" . escapeHtml($row['vendor_template_name']) . " is " . escapeHtml($said));
redirect();
}
if (isset($_POST['export_vendor_templates']) || isset($_GET['export_vendor_template'])) {
// A file of templates to import into another ITFlow - every current one, the ones picked, or one
validateCSRFToken();
if (isset($_GET['export_vendor_template'])) {
$row = vendorTemplateForRequest($_GET['export_vendor_template']);
$export = vendorTemplatesExport([intval($row['vendor_template_id'])]);
} else {
$export = vendorTemplatesExport((array) ($_POST['vendor_template_ids'] ?? []), !empty($_POST['archived']), !empty($_POST['manager']));
}
if (!$export['templates']) {
flashAlert('There are no vendor templates to export.', 'error');
redirect();
}
$count = count($export['templates']);
logAudit("Vendor Template", "Export", "$session_name exported $count vendor template" . ($count === 1 ? ' ' . escapeSql($export['templates'][0]['name']) : 's')
. (!empty($_POST['manager']) ? ' with their account managers' : ''));
header('Content-Type: application/json; charset=utf-8');
header('Content-Disposition: attachment; filename="' . vendorTemplatesExportFileName($export) . '"');
header('Cache-Control: no-store');
echo json_encode($export, JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE);
exit;
}
if (isset($_POST['import_vendor_templates'])) {
// Templates from a file exported by ITFlow
validateCSRFToken();
$file = $_FILES['file'] ?? null;
if ($file && in_array($file['error'], [UPLOAD_ERR_INI_SIZE, UPLOAD_ERR_FORM_SIZE], true)) {
flashAlert('That file is bigger than this server takes in an upload - export a few at a time.', 'error');
redirect('vendor_templates.php');
}
if (!$file || $file['error'] !== UPLOAD_ERR_OK || !is_uploaded_file($file['tmp_name'])) {
flashAlert('Pick the file to import.', 'error');
redirect('vendor_templates.php');
}
if ($file['size'] > 10 * 1024 * 1024) {
flashAlert('That file is too big to be vendor templates.', 'error');
redirect('vendor_templates.php');
}
$templates = vendorTemplatesImportRead(file_get_contents($file['tmp_name']), $import_error);
if ($templates === null) {
flashAlert(escapeHtml($import_error), 'error');
redirect('vendor_templates.php');
}
$existing = in_array($_POST['existing'] ?? '', ['skip', 'copy', 'replace'], true) ? $_POST['existing'] : 'skip';
$counts = vendorTemplatesImport($templates, $existing);
vendorTemplatesImportLogFollowed($counts);
$followed = vendorTemplatesImportFollowedCount($counts);
logAudit("Vendor Template", "Import", "$session_name imported vendor templates from " . escapeSql(mb_substr((string) $file['name'], 0, 100)) . " - {$counts['added']} added, {$counts['replaced']} replaced, {$counts['skipped']} skipped"
. ($followed ? ", $followed vendors changed with them" : ''));
flashAlert(vendorTemplatesImportSummary($counts), $counts['added'] || $counts['replaced'] ? 'success' : 'info');
redirect('vendor_templates.php');
}