- Add import_batch_contexts table plus ImportBatchContext model so
per-batch data (e.g. Items CSV attribute definitions) is stored
once and referenced by context_id, instead of duplicated into
every queued row's job payload.
- Extend queue_jobs, queue_jobs_failed, and new queue_paused_jobs
tables with batch_id/context_id columns and FKs (ON DELETE
RESTRICT) back to import_batch_contexts, so context rows cannot
be purged while any job still references them.
- Introduce ImportBatchService.pushRow() to centralize queuing a
batch row with batch/context stamping and priority; update
Customers and Items controllers to use it instead of calling
importBatch->create() and queue->push() separately.
- Add queue_paused_jobs table and Jobs::postPauseJobs()/pauseQueues()
to move pending jobs out of queue_jobs into a paused table per
queue (all core queues or a selected subset), leaving in-flight
jobs untouched (issue #3833 pause/resume design).
- Change Jobs::getEditJob()/postSaveJob() routes to accept separate
source/id path segments instead of a combined uid string.
- Add test coverage for ImportBatchContext, ImportBatchService, and
ImportBatch (including purge-retains-while-referenced guards).
Signed-off-by: objecttothis <17935339+objecttothis@users.noreply.github.com>
Introduce new Jobs admin section to view and manage queued and
failed jobs from codeigniter4/queue tables (queue_jobs,
queue_jobs_failed).
- Add JobQueueManage model: unions queue_jobs (pending/reserved)
and queue_jobs_failed into one virtual grid, tagging each row
with a synthetic uid ("{source}:{id}") since the two tables
share no common identity; supports search, sort, and pagination
- Add manage_grid.php view: Bootstrap table grid listing jobs
across selectable queues, with per-row "process job" action
wired to jobs/processJob endpoint
- Add job_edit.php view: form for editing a single job's priority,
available_at, and payload, with client-side validation before
ajax submit to jobs/save
Signed-off-by: objecttothis <17935339+objecttothis@users.noreply.github.com>
objecttothis