====================================================
 EASYCONF ENTERPRISE WORKFLOW INVENTORY
====================================================

===== UPDATE submissions =====
/home/shquier/easyconf.net/easychair/app/controllers/AdminAssignmentController.php:230:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/ChairDecisionController.php:152:    UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/ChairDecisionController.php:177:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AdminIssueController.php:278:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AdminIssueController.php:315:            UPDATE submissions s
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionWorkflowController.php:38:        $sql = "UPDATE submissions SET status=:st";
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionWorkflowController.php:462:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AuthorRevisionController.php:96:        $db->prepare("UPDATE submissions SET status='under_review' WHERE id=:id")->execute([':id'=>$submissionId]);
/home/shquier/easyconf.net/easychair/app/controllers/AdminDecisionBoardTenantController.php:107:          $db->prepare("UPDATE submissions SET status=:s WHERE id=:id")->execute([':s'=>$decision,':id'=>$sid]);
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceBusinessController.php:546:        $this->db()->prepare("UPDATE submissions SET status='galley', stage='galley', production_status='galley_uploaded', updated_at=NOW() WHERE id=?")
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceBusinessController.php:590:                UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceBusinessController.php:678:        $this->db()->prepare("UPDATE submissions SET status='assigned_to_issue', stage='issue', issue_id=?, doi=COALESCE(NULLIF(?,''),doi), updated_at=NOW() WHERE id=?")
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceBusinessController.php:696:            UPDATE submissions s
/home/shquier/easyconf.net/easychair/app/controllers/AuthorSubmissionController.php:694:                UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AuthorSubmissionController.php:1221:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AuthorSubmissionController.php:1830:        UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AuthorSubmissionController.php:2053:    UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionActionsTenantController.php:54:        $db->prepare("UPDATE submissions SET `$col`=:s WHERE id=:id")->execute([':s'=>$status,':id'=>$submissionId]);
/home/shquier/easyconf.net/easychair/app/controllers/AdminDecisionBoardController.php:76:        // 1) Update submissions.status if exists
/home/shquier/easyconf.net/easychair/app/controllers/AdminDecisionBoardController.php:91:                    $db->prepare("UPDATE submissions SET status=:s WHERE id=:id")->execute([':s'=>$status, ':id'=>$submissionId]);
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:70:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:408:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AdminDecisionEngine.php:33:        $db->prepare("UPDATE submissions SET decision=?,doi=? WHERE id=?")
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionsBoardController.php:109:            $db->prepare("UPDATE submissions SET status=:s WHERE id=:id")->execute([':s'=>$new, ':id'=>(int)$r['id']]);
/home/shquier/easyconf.net/easychair/app/controllers/AuthorSubmissionEditController.php:90:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AuthorWorkflowController.php:345:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AuthorWorkflowController.php:426:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4550:UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:7746:        UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:1100:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:13918:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:14127:        UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:17926:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/ProductionController.php:180:        UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/ProductionController.php:212:        UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/ProductionController.php:278:        UPDATE submissions
/home/shquier/easyconf.net/easychair/app/controllers/AuthorWorkController.php:62:            $db->prepare("UPDATE submissions SET ".implode(',', $updates)." WHERE id=:id AND author_id=:u")->execute($params);
/home/shquier/easyconf.net/easychair/app/controllers/AuthorWorkController.php:85:        $db->prepare("UPDATE submissions SET status='archived' WHERE id=:id AND author_id=:u")->execute([':id'=>$id, ':u'=>$uid]);
/home/shquier/easyconf.net/easychair/app/controllers/AuthorController.php:20:        $db->prepare("UPDATE submissions SET revision_file=? WHERE id=?")
/home/shquier/easyconf.net/easychair/app/services/WorkflowService.php:37:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/services/ReviewRoundService.php:51:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/services/WorkflowDecisionService.php:206:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/services/ReviewCompletionService.php:78:                UPDATE submissions
/home/shquier/easyconf.net/easychair/app/services/SubmissionWorkflowService.php:95:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/services/SubmissionWorkflowService.php:507:        UPDATE submissions
/home/shquier/easyconf.net/easychair/app/services/SubmissionWorkflowService.php:635:    UPDATE submissions
/home/shquier/easyconf.net/easychair/app/services/SubmissionWorkflowService.php:684:        UPDATE submissions
/home/shquier/easyconf.net/easychair/app/core/WorkflowEngine.php:37:                UPDATE submissions SET stage=? WHERE id=?
/home/shquier/easyconf.net/easychair/app/core/WorkflowEngine.php:60:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/core/WorkflowEngine.php:71:        UPDATE submissions
/home/shquier/easyconf.net/easychair/app/core/WorkflowEngine.php:112:            UPDATE submissions
/home/shquier/easyconf.net/easychair/app/models/ProceedingsModel.php:103:        $stmt = $this->db->prepare("UPDATE submissions SET status='published' WHERE id = :id");

===== INSERT review_assignments =====
/home/shquier/easyconf.net/easychair/app/controllers/AdminAssignmentController.php:214:            INSERT INTO review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentController.php:61:                    INSERT INTO review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1419:            INSERT INTO review_assignments
/home/shquier/easyconf.net/easychair/app/services/ReviewRoundService.php:93:                INSERT INTO review_assignments
/home/shquier/easyconf.net/easychair/app/models/Review.php:104:            INSERT INTO review_assignments (

===== UPDATE review_assignments =====
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerController.php:365:        UPDATE review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:13953:            UPDATE review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:506:            UPDATE review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:526:            UPDATE review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:851:        UPDATE review_assignments
/home/shquier/easyconf.net/easychair/app/models/Review.php:145:        $stmt = $this->db->prepare("UPDATE review_assignments SET status = 'completed' WHERE id = :id");

===== SubmissionWorkflowService =====
/home/shquier/easyconf.net/easychair/app/controllers/AdminAssignmentController.php:237:        SubmissionWorkflowService::log(
/home/shquier/easyconf.net/easychair/app/controllers/AdminAssignmentController.php:330:SubmissionWorkflowService::queueEmail(
/home/shquier/easyconf.net/easychair/app/controllers/AdminAssignmentController.php:336:SubmissionWorkflowService::submissionVars(
/home/shquier/easyconf.net/easychair/app/controllers/AdminTrackChairController.php:379:        \App\Services\SubmissionWorkflowService::queueEmail(
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4642:\App\Services\SubmissionWorkflowService::queueEmail(
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4656:\App\Services\SubmissionWorkflowService::submissionVars(
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:1119:        \App\Services\SubmissionWorkflowService::class
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:1123:        \App\Services\SubmissionWorkflowService::log(
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:1140:            \App\Services\SubmissionWorkflowService::queueEmail(

===== WorkflowDecisionService =====
/home/shquier/easyconf.net/easychair/app/controllers/AdminDecisionController.php:115:        WorkflowDecisionService::applyDecision(

===== workflow_stage =====
/home/shquier/easyconf.net/easychair/app/helpers/workflow_guard.php:19:workflow_stage,
/home/shquier/easyconf.net/easychair/app/views/admin/author_workflow/edit.php:17:        <label class="form-label"><?= e(trans('workflow_stage')) ?></label>
/home/shquier/easyconf.net/easychair/app/views/admin/author_workflow/edit.php:18:        <select name="workflow_stage" class="form-select rounded-3">
/home/shquier/easyconf.net/easychair/app/views/admin/author_workflow/edit.php:20:                <option value="<?= e($s) ?>" <?= (($workflow['workflow_stage'] ?? 'submission') === $s) ? 'selected' : '' ?>><?= e(trans($s . '_stage')) ?></option>
/home/shquier/easyconf.net/easychair/app/views/admin/author_workflow/index.php:16:                    <th><?= e(trans('workflow_stage')) ?></th>
/home/shquier/easyconf.net/easychair/app/views/admin/author_workflow/index.php:33:                        <td><?= e(trans(($wf['workflow_stage'] ?? 'submission') . '_stage')) ?></td>
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionWorkflowController.php:410:| Keep legacy status/stage and enterprise workflow_stage synchronized
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionWorkflowController.php:425:    'workflow_stage' => $workflowStage
/home/shquier/easyconf.net/easychair/app/controllers/PublicConferenceHomeController.php:105:                LEFT JOIN workflow_stages ws ON ws.stage_key = cw.stage
/home/shquier/easyconf.net/easychair/app/controllers/OperationsController.php:214:                'workflow_stage' => trim((string) ($_POST['workflow_stage'] ?? 'submission')),
/home/shquier/easyconf.net/easychair/app/controllers/OperationsController.php:224:                $oldStage = (string) ($old['workflow_stage'] ?? '');
/home/shquier/easyconf.net/easychair/app/controllers/OperationsController.php:225:                $newStage = (string) ($new['workflow_stage'] ?? '');
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4554:    workflow_stage='under_review',
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4579:workflow_stage
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:7750:            workflow_stage='under_review',
/home/shquier/easyconf.net/easychair/app/services/WorkflowService.php:28:        $q = $db->prepare("SELECT workflow_stage FROM submissions WHERE id=? LIMIT 1");
/home/shquier/easyconf.net/easychair/app/services/WorkflowService.php:38:            SET workflow_stage=?, workflow_updated_at=NOW()
/home/shquier/easyconf.net/easychair/app/services/WorkflowDictionary.php:117:    workflow_stage mirrors stage
/home/shquier/easyconf.net/easychair/app/models/OperationsModel.php:195:                submission_id, workflow_stage, workflow_status, notes_en, notes_ar, updated_by
/home/shquier/easyconf.net/easychair/app/models/OperationsModel.php:197:                :submission_id, :workflow_stage, :workflow_status, :notes_en, :notes_ar, :updated_by
/home/shquier/easyconf.net/easychair/app/models/OperationsModel.php:200:                workflow_stage = VALUES(workflow_stage),
/home/shquier/easyconf.net/easychair/app/models/OperationsModel.php:208:            ':workflow_stage' => $data['workflow_stage'],

====================================================
 END
====================================================
