/home/shquier/easyconf.net/easychair/app/controllers/RegistrationController.php:178:            $status = trim((string) ($_POST['status'] ?? 'pending'));
/home/shquier/easyconf.net/easychair/app/controllers/RegistrationController.php:181:            $stmt = $db->prepare("UPDATE registration_submissions SET status = :status WHERE id = :id");
/home/shquier/easyconf.net/easychair/app/controllers/AdminJobsController.php:25:        $status = trim((string)($_GET['status'] ?? ''));
/home/shquier/easyconf.net/easychair/app/controllers/AdminJobsController.php:29:        if ($status !== '') { $where[]="status=:s"; $params[':s']=$status; }
/home/shquier/easyconf.net/easychair/app/controllers/AdminJobsController.php:44:                $x=$db->prepare("SELECT COUNT(*) FROM jobs WHERE status=:s");
/home/shquier/easyconf.net/easychair/app/controllers/AdminAssignmentController.php:93:                COUNT(DISTINCT CASE WHEN ra.status='completed' THEN ra.id END) AS completed_count
/home/shquier/easyconf.net/easychair/app/controllers/AdminAssignmentController.php:231:            SET status = 'under_review',
/home/shquier/easyconf.net/easychair/app/controllers/AdminAssignmentController.php:232:                stage = 'review',
/home/shquier/easyconf.net/easychair/app/controllers/ChairDecisionController.php:79:                AND s.stage = 'decision'
/home/shquier/easyconf.net/easychair/app/controllers/ChairDecisionController.php:129:        $status = 'under_review';
/home/shquier/easyconf.net/easychair/app/controllers/ChairDecisionController.php:130:        $stage  = 'production';
/home/shquier/easyconf.net/easychair/app/controllers/ChairDecisionController.php:136:                $status = 'accepted';
/home/shquier/easyconf.net/easychair/app/controllers/ChairDecisionController.php:137:                $stage  = 'production';
/home/shquier/easyconf.net/easychair/app/controllers/ChairDecisionController.php:144:                $status = 'revision_required';
/home/shquier/easyconf.net/easychair/app/controllers/ChairDecisionController.php:159:   //             $stage  = 'revision';
/home/shquier/easyconf.net/easychair/app/controllers/ChairDecisionController.php:165:                $status = 'rejected';
/home/shquier/easyconf.net/easychair/app/controllers/ChairDecisionController.php:166:                $stage  = 'decision';
/home/shquier/easyconf.net/easychair/app/controllers/ChairDecisionController.php:179:                status = ?,
/home/shquier/easyconf.net/easychair/app/controllers/ChairDecisionController.php:180:                stage  = ?,
/home/shquier/easyconf.net/easychair/app/controllers/AdminIssueController.php:139:  AND s.status='production'
/home/shquier/easyconf.net/easychair/app/controllers/AdminIssueController.php:140:  AND s.production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminIssueController.php:142:  AND g.status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminIssueController.php:239:      AND status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminIssueController.php:279:            SET status='assigned_to_issue',
/home/shquier/easyconf.net/easychair/app/controllers/AdminIssueController.php:280:                stage='issue',
/home/shquier/easyconf.net/easychair/app/controllers/AdminIssueController.php:303:            SET status='published',
/home/shquier/easyconf.net/easychair/app/controllers/AdminIssueController.php:317:            SET s.status='published',
/home/shquier/easyconf.net/easychair/app/controllers/AdminIssueController.php:318:                s.stage='published',
/home/shquier/easyconf.net/easychair/app/controllers/AdminIssueController.php:330:            SET g.status='published',
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:180:                    SUM(CASE WHEN status='completed' THEN 1 ELSE 0 END) AS completed_count,
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:212:                    SUM(CASE WHEN status='completed' THEN 1 ELSE 0 END) AS completed_count,
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:354:                        WHEN ra.status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionWorkflowController.php:30:        $status = $step;
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionWorkflowController.php:31:        if ($step === 'copyediting') $status = 'copyediting';
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionWorkflowController.php:32:        if ($step === 'galley') $status = 'galley';
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionWorkflowController.php:33:        if ($step === 'published') $status = 'published';
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionWorkflowController.php:34:        if ($step === 'minor_revision' || $step === 'major_revision') $status = 'revision';
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionWorkflowController.php:38:        $sql = "UPDATE submissions SET status=:st";
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionWorkflowController.php:39:        if ($status === 'revision') {
/home/shquier/easyconf.net/easychair/app/controllers/AdminUserController.php:646:    $status = strtolower(trim((string)($_POST['status'] ?? 'active')));
/home/shquier/easyconf.net/easychair/app/controllers/AdminUserController.php:648:    $isActive = ($status === 'active') ? 1 : 0;
/home/shquier/easyconf.net/easychair/app/controllers/AdminUserController.php:1456:        $status = strtolower(trim((string)($_POST['status'] ?? 'active')));
/home/shquier/easyconf.net/easychair/app/controllers/AdminUserController.php:1462:        $active = ($status === 'active') ? 1 : 0;
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionWorkflowController.php:370:        $status = trim($_POST['status'] ?? '');
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionWorkflowController.php:371:        $stage = trim($_POST['stage'] ?? '');
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionWorkflowController.php:372:        $productionStatus = trim($_POST['production_status'] ?? 'pending');
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionWorkflowController.php:400:        if ($status === '') {
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionWorkflowController.php:401:            $status = $stage;
/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:414:$workflowStage =
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionWorkflowController.php:421:    'production_status' => $productionStatus,
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionWorkflowController.php:425:    'workflow_stage' => $workflowStage
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionWorkflowController.php:434:        if ($stage === 'published' && $this->columnExists('submissions', 'published_at')) {
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionWorkflowController.php:470:        $body = "Status: {$submission['status']} -> {$status}\nStage: {$submission['stage']} -> {$stage}\nProduction: " . ($submission['production_status'] ?? '') . " -> {$productionStatus}\nNotes: {$notes}";
/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/NotificationController.php:38:        $status = trim((string)($_GET['status'] ?? ''));
/home/shquier/easyconf.net/easychair/app/controllers/NotificationController.php:43:        if ($status === 'unread') {
/home/shquier/easyconf.net/easychair/app/controllers/NotificationController.php:45:        } elseif ($status === 'read') {
/home/shquier/easyconf.net/easychair/app/controllers/AdminPublicationIntegrityController.php:44:              AND s.status='assigned_to_issue'
/home/shquier/easyconf.net/easychair/app/controllers/AdminTrackChairController.php:467:                $newStatus = ((int)$row['is_active'] === 1) ? 0 : 1;
/home/shquier/easyconf.net/easychair/app/controllers/AdminTrackChairController.php:479:                if ($newStatus === 0) {
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceController.php:108:        $status = trim((string)($_POST['status'] ?? $_GET['status'] ?? ''));
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceController.php:135:            SET status = ?,
/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/AdminEmailTestController.php:148:                SET status='sent',
/home/shquier/easyconf.net/easychair/app/controllers/AdminEmailTestController.php:159:                SET status='failed',
/home/shquier/easyconf.net/easychair/app/controllers/AdminEmailTestController.php:204:                SET status='sent',
/home/shquier/easyconf.net/easychair/app/controllers/AdminEmailTestController.php:215:                SET status='failed',
/home/shquier/easyconf.net/easychair/app/controllers/AdminEmailTestController.php:236:            SET status='sent',
/home/shquier/easyconf.net/easychair/app/controllers/SubmissionsController.php:40:        $status  = $this->pick($scols, ['status'], 'id');
/home/shquier/easyconf.net/easychair/app/controllers/PublicConferenceHomeController.php:83:            'accepted' => "SELECT COUNT(*) FROM submissions WHERE conference_id = ? AND status='accepted'",
/home/shquier/easyconf.net/easychair/app/controllers/PublicConferenceHomeController.php:84:            'under_review' => "SELECT COUNT(*) FROM submissions WHERE conference_id = ? AND status='under_review'",
/home/shquier/easyconf.net/easychair/app/controllers/PublicConferenceHomeController.php:85:            'published' => "SELECT COUNT(*) FROM submissions WHERE conference_id = ? AND status='published'",
/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/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:562:            SET status='approved',
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceBusinessController.php:591:                SET status='production',
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceBusinessController.php:592:                    stage='production',
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceBusinessController.php:593:                    production_status='approved',
/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:692:        $this->db()->prepare("UPDATE proceedings_issues SET status='published', updated_at=NOW() WHERE id=? AND conference_id=? AND org_id=?")
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceBusinessController.php:698:            SET s.status='published', s.stage='published', s.published_at=NOW()
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceBusinessController.php:822:        $stmt = $this->db()->prepare("UPDATE conference_certificates SET status='revoked' WHERE id=? AND conference_id=? AND org_id=?");
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionSearchController.php:86:        $status =
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionSearchController.php:94:        $stage =
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionSearchController.php:216:            AND s.status=?
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionSearchController.php:226:            AND s.stage=?
/home/shquier/easyconf.net/easychair/app/controllers/UserController.php:190:        $newStatus = ((int) $user['is_active'] === 1) ? 0 : 1;
/home/shquier/easyconf.net/easychair/app/controllers/UserController.php:195:        if (auth_id() === $id && $newStatus === 0) {
/home/shquier/easyconf.net/easychair/app/controllers/AdminOwnerController.php:26:            'failed_jobs'   => $db->query("SELECT COUNT(*) FROM system_jobs WHERE status='failed'")->fetchColumn()
/home/shquier/easyconf.net/easychair/app/controllers/AdminWorkflowController.php:140:                      AND stage = ?
/home/shquier/easyconf.net/easychair/app/controllers/SuperAdminMonitoringController.php:21:            'decision_stage' => $db->query("SELECT COUNT(*) FROM conferences WHERE status='decision'")->fetchColumn(),
/home/shquier/easyconf.net/easychair/app/controllers/SuperAdminMonitoringController.php:22:            'system_jobs_failed' => $db->query("SELECT COUNT(*) FROM system_jobs WHERE status='failed'")->fetchColumn()
/home/shquier/easyconf.net/easychair/app/controllers/AuthorSubmissionController.php:1832:            production_status = 'camera_ready_uploaded',
/home/shquier/easyconf.net/easychair/app/controllers/AuthorSubmissionController.php:1833:            stage = 'production',
/home/shquier/easyconf.net/easychair/app/controllers/AuthorSubmissionController.php:2055:        status = 'revised',
/home/shquier/easyconf.net/easychair/app/controllers/AuthorSubmissionController.php:2056:        stage  = 'review',
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionActionsTenantController.php:44:        $status=trim((string)($_POST['status'] ?? ''));
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionActionsTenantController.php:131:        $db->prepare("UPDATE conferences SET status='published' WHERE id=:id")->execute([':id'=>$confId]);
/home/shquier/easyconf.net/easychair/app/controllers/AdminDecisionBoardController.php:81:                    $status = $decisionRaw;
/home/shquier/easyconf.net/easychair/app/controllers/AdminDecisionBoardController.php:90:                    $status = $norm[strtolower($status)] ?? $status;
/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:71:            SET status=?,
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:72:                stage=?,
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:73:                production_status=?,
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:103:                s.production_status,
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:127:        s.status='accepted'
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:129:        COALESCE(s.production_status,'pending')
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:136:        s.production_status='camera_ready_uploaded'
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:142:        s.status='production'
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:166:    $status =
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:169:    $productionStatus =
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:170:        (string)($row['production_status'] ?? '');
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:172:    $galleyStatus =
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:176:        $status === 'accepted'
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:178:        $productionStatus === 'pending'
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:185:        $productionStatus ===
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:193:        $status === 'production'
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:206:        $galleyStatus === 'approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:215:        $status === 'assigned_to_issue'
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:222:        $status === 'published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:354:                SET status='approved',
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:409:            SET status='production',
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:410:                stage='production',
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:411:                production_status='approved',
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionController.php:528:            SET status='approved',
/home/shquier/easyconf.net/easychair/app/controllers/AdminEmailQueueController.php:27:        $status = trim((string)($_GET['status'] ?? ''));
/home/shquier/easyconf.net/easychair/app/controllers/AdminEmailQueueController.php:34:            $where[] = "status = :st";
/home/shquier/easyconf.net/easychair/app/controllers/AdminEmailQueueController.php:57:                $c = $db->prepare("SELECT COUNT(*) FROM email_queue WHERE status=:s");
/home/shquier/easyconf.net/easychair/app/controllers/AdminEmailQueueController.php:74:            $db->prepare("UPDATE email_queue SET status='queued', error_message=NULL, sent_at=NULL WHERE id=:id")
/home/shquier/easyconf.net/easychair/app/controllers/AdminEmailQueueController.php:91:        $db->exec("UPDATE email_queue SET status='queued', error_message=NULL, sent_at=NULL WHERE status='failed'");
/home/shquier/easyconf.net/easychair/app/controllers/AdminEmailQueueController.php:94:        header('Location: ' . base_path('admin/email-queue?status=failed'));
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:223:              AND s.status = 'under_review'
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:230:              AND s.status = 'accepted'
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:237:              AND s.status = 'rejected'
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:250:              AND ra.status = 'completed'
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:336:              AND ra.status = 'assigned'
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:343:              AND ra.status = 'accepted'
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:350:              AND ra.status = 'completed'
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:357:              AND ra.status = 'declined'
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:405:              AND s.status = 'draft'
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:412:              AND s.status = 'under_review'
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:419:              AND s.status = 'accepted'
/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/OperationsController.php:226:                $oldStatus = (string) ($old['workflow_status'] ?? '');
/home/shquier/easyconf.net/easychair/app/controllers/OperationsController.php:227:                $newStatus = (string) ($new['workflow_status'] ?? '');
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerController.php:89:        $stage = $db->query("SELECT status FROM conferences WHERE id=$conf")->fetchColumn();
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerController.php:106:        $db->prepare("UPDATE assignments SET status='completed' WHERE id=?")
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerController.php:366:        SET status = 'completed',completed_at = NOW()
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionsBoardController.php:42:        $status = trim((string)($_GET['status'] ?? ''));
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionsBoardController.php:50:        if ($status !== '') { $where[] = "s.status=:st"; $params[':st']=$status; }
/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/AdminOrgSmtpController.php:254:        $status = 'queued';
/home/shquier/easyconf.net/easychair/app/controllers/AdminOrgSmtpController.php:271:            $status = 'queued';
/home/shquier/easyconf.net/easychair/app/controllers/AdminOrgSmtpController.php:273:            $status = 'failed';
/home/shquier/easyconf.net/easychair/app/controllers/AdminOrgSmtpController.php:279:            SET last_test_status=?, last_test_error=?, last_test_at=NOW(), test_recipient=?
/home/shquier/easyconf.net/easychair/app/controllers/AdminOrgSmtpController.php:284:        $_SESSION['flash_success'] = $status === 'queued'
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionController.php:165:WHEN ra.status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminProductionTenantController.php:57:        $status=trim((string)($_GET['status'] ?? ''));
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceMailController.php:140:                SET status='sent',
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceMailController.php:161:            SET status='failed',
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceMailController.php:193:        $status = trim((string)($_GET['status'] ?? ''));
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceMailController.php:203:            $where .= " AND m.status=? ";
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceMailController.php:309:            SET status='cancelled',
/home/shquier/easyconf.net/easychair/app/controllers/RoleDashboardController.php:136:                ['key'=>'dashboard.kpi.under_review', 'label'=>'Under Review', 'value'=>$this->countTable('submissions', "conference_id=? AND org_id=? AND (stage='reviewing' OR status='under_review')", [$confId,$orgId]), 'icon'=>'fa-clipboard-check'],
/home/shquier/easyconf.net/easychair/app/controllers/RoleDashboardController.php:137:                ['key'=>'dashboard.kpi.accepted', 'label'=>'Accepted', 'value'=>$this->countTable('submissions', "conference_id=? AND org_id=? AND (stage='accepted' OR status='accepted')", [$confId,$orgId]), 'icon'=>'fa-circle-check'],
/home/shquier/easyconf.net/easychair/app/controllers/RoleDashboardController.php:138:                ['key'=>'dashboard.kpi.revision_required', 'label'=>'Revision Required', 'value'=>$this->countTable('submissions', "conference_id=? AND org_id=? AND (stage='revision_required' OR status='revision_required')", [$confId,$orgId]), 'icon'=>'fa-pen-to-square'],
/home/shquier/easyconf.net/easychair/app/controllers/RoleDashboardController.php:151:                ['key'=>'dashboard.kpi.pending_production', 'label'=>'Pending Production', 'value'=>$this->countTable('submissions', "conference_id=? AND org_id=? AND COALESCE(production_status,'pending')='pending'", [$confId,$orgId]), 'icon'=>'fa-industry'],
/home/shquier/easyconf.net/easychair/app/controllers/RoleDashboardController.php:230:            SELECT id, submission_no, title, title_ar, status, stage, production_status, updated_at
/home/shquier/easyconf.net/easychair/app/controllers/AuthorWorkflowController.php:94:        $stage = (string)($submission['stage'] ?? $submission['status'] ?? 'submitted');
/home/shquier/easyconf.net/easychair/app/controllers/AuthorWorkflowController.php:346:            SET status='revision_submitted',
/home/shquier/easyconf.net/easychair/app/controllers/AuthorWorkflowController.php:347:                stage='review',
/home/shquier/easyconf.net/easychair/app/controllers/AuthorWorkflowController.php:427:SET status='production',
/home/shquier/easyconf.net/easychair/app/controllers/AuthorWorkflowController.php:428:    stage='production',
/home/shquier/easyconf.net/easychair/app/controllers/AuthorWorkflowController.php:429:    production_status='camera_ready_uploaded',
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:663:        WHERE status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:938:    $status=
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:2266:        SET status='executed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:2398:        SET healing_status='executed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:2521:        execution_status='completed',
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:2677:        approval_status='approved',
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:2707:        approval_status='rejected',
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:3920:        AND prediction_status='safe'
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:3928:        AND prediction_status='at_risk'
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:3936:        AND prediction_status='critical'
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4274:        SET status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4327:            SET status='rejected'
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4552:    status='under_review',
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4553:    stage='review',
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4554:    workflow_stage='under_review',
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4558:AND status='submitted'
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4579:workflow_stage
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4840:        $status = 'queued';
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4857:            $status = 'failed';
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4929:status='sent'
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4945:status='queued'
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4974:status='failed',
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:7748:            status='under_review',
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:7749:            stage='review',
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:7750:            workflow_stage='under_review',
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:7754:          AND status='submitted'
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:7755:          AND stage='submission'
/home/shquier/easyconf.net/easychair/app/controllers/PublicConferenceBusinessController.php:414:            status = 'accepted'
/home/shquier/easyconf.net/easychair/app/controllers/PublicController.php:16:            WHERE stage='published'
/home/shquier/easyconf.net/easychair/app/controllers/DecisionController.php:56:            $newStatus = match ($decision) {
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:279:                    WHEN status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:342:        WHERE ra.status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:1102:                status='submitted',
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:1103:                stage='submission',
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:5858:release_status='published',
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:9808:$newStatus =
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:9844:$currentStatus =
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:9887:        SET status = ?
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:10502:        $status =
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:10515:                $status ===
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:10612:        $status =
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:10620:            $status === 'under_review'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:10705:        $status =
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:10737:            $status === 'published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:10743:            $status === 'archived'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:10798:        $status =
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:10803:        if($status === 'published')
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:10806:        if($status === 'accepted')
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:10809:        if($status === 'rejected')
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:10812:        if($status === 'withdrawn')
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:10895:        $status =
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:10905:            $status === 'under_review'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:10939:            if($status==='recommend_accept')
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:10948:            if($status==='recommend_revision')
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:10957:            if($status==='recommend_reject')
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:11043:        $status =
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:11194:                WHERE d.status=?
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:11803:        $status =
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:11808:        if($status==='published')
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:11813:        if($status==='under_review')
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:11818:        if($status==='production')
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:11962:    $newStatus =
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:11990:    $currentStatus =
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:12028:            SET status=?
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:12428:        $status =
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:12677:                status = 'success'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:12702:                status='failed',
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:13508:                    AND status=?
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:13517:                    AND status=?
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:14445:                    WHEN ra.status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:14687:                    WHEN ra.status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:15984:                    WHEN ra.status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:16234:                    WHEN ra.status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:16371:                    WHEN ra.status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:17552:        WHERE s.status='assigned_to_issue'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:17615:        WHERE g.status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:17659:              AND status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:17787:               AND g.status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18092:                production_status
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18103:            ($r['production_status'] ?? '') ===
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18232:                s.production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18343:               AND g.status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18346:                s.production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18378:            WHERE status='accepted'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18379:              AND COALESCE(production_status,'pending')='pending'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18386:            WHERE production_status='camera_ready_uploaded'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18393:            WHERE status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18400:            WHERE status='assigned_to_issue'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18407:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18423:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18458:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18471:            WHERE status='assigned_to_issue'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18484:            WHERE status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18497:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18514:                s.production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18537:                s.production_status,
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18543:                s.production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18577:                production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18578:                OR status='assigned_to_issue'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18587:                    production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18588:                    OR status='assigned_to_issue'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18609:                production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18631:                s.production_status
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18643:                s.production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18645:                s.status='assigned_to_issue'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18742:                s.production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18792:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18805:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18834:                s.production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18972:                status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19140:            WHERE status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19180:                    WHEN ra.status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19369:            WHERE status='submitted'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19376:            WHERE status='under_review'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19442:            WHERE status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19449:            WHERE status='assigned_to_issue'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19456:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19485:                s.production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19620:                production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19647:            WHERE production_status='camera_ready_uploaded'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19754:            WHERE production_status='camera_ready_uploaded'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19774:                production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19816:                production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19898:                    WHEN s.production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20070:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20083:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20591:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20605:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20950:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21126:            WHERE status='under_review'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21152:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21159:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21382:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21408:            WHERE production_status='camera_ready_uploaded'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21472:                    WHEN s.status='under_review'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21480:                    WHEN s.status='accepted'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21692:            WHERE status='submitted'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21705:            WHERE status='under_review'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21718:            WHERE status='revision_required'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21731:            WHERE status='accepted'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21744:            WHERE production_status='camera_ready_uploaded'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21757:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21770:            WHERE status='assigned_to_issue'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21783:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21898:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21911:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21937:            WHERE status='assigned_to_issue'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21950:            WHERE status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21963:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22019:                s.production_status,
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22041:                s.production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22104:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22334:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22347:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22443:                    WHEN s.status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22494:                ra.status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22572:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22586:            WHERE production_status='camera_ready_uploaded'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22736:                    WHEN s.status='under_review'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22744:                    WHEN s.status='revision_required'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23098:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23111:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23240:                    WHEN s.status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23300:            WHERE status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23455:                ra.status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23497:        WHERE status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23547:            SUM(CASE WHEN ra.status='completed' THEN 1 ELSE 0 END) completed_reviews,
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23603:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23610:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23617:            WHERE status='assigned_to_issue'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23624:            WHERE production_status='camera_ready_uploaded'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23637:            WHERE status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23814:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23843:                    WHEN s.status='accepted'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23851:                    WHEN s.status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23875:               AND g.status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24066:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24073:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24356:            WHERE status='accepted'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24369:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24493:                    WHEN s.status='accepted'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24501:                    WHEN s.status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24607:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24792:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25005:            WHERE production_status='camera_ready_uploaded'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25012:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25145:                s.production_status
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25229:            WHERE production_status='camera_ready_uploaded'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25236:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25434:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25478:            WHERE status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25593:                    WHEN s.status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25666:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25692:            WHERE status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25705:            WHERE status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25823:                    WHEN s.status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25897:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25904:            WHERE production_status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25948:            WHERE status='approved'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:26064:                    WHEN s.status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:26337:            WHERE status='published'
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:26518:                    WHEN s.status='published'
/home/shquier/easyconf.net/easychair/app/controllers/CopyeditorController.php:48:        $status = trim((string) ($_POST['status'] ?? 'in_progress'));
/home/shquier/easyconf.net/easychair/app/controllers/CopyeditorController.php:55:            SET status = :status,
/home/shquier/easyconf.net/easychair/app/controllers/ProductionController.php:90:    $stage =
/home/shquier/easyconf.net/easychair/app/controllers/ProductionController.php:181:        SET stage = ?
/home/shquier/easyconf.net/easychair/app/controllers/ProductionController.php:215:            stage = 'assigned_to_issue'
/home/shquier/easyconf.net/easychair/app/controllers/ProductionController.php:280:            stage = 'published',
/home/shquier/easyconf.net/easychair/app/controllers/ProductionController.php:281:            status = 'published',
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferencesTenantController.php:109:        $status=trim((string)($_POST['status']??'draft'));
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferencesTenantController.php:130:              status=:st, is_active=:ia, show_on_homepage=:sh
/home/shquier/easyconf.net/easychair/app/controllers/AuthorWorkController.php:79:        $status = (string)($st->fetchColumn() ?: '');
/home/shquier/easyconf.net/easychair/app/controllers/AuthorWorkController.php:80:        if ($status === '') { http_response_code(404); echo "Not found"; return; }
/home/shquier/easyconf.net/easychair/app/controllers/AuthorWorkController.php:83:        if ($status === 'published') { http_response_code(403); echo "Forbidden"; return; }
/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/AuthorDashboardController.php:76:        $status=
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:303:$status=
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:431:$status=
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:543:$status=
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:563:$status==='accepted'
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:672:$status=
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:778:$status=
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:883:$status=
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:906:$status==='accepted'
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:1411:$status=
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:1492:$status==='published'
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:1583:$status=
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:1760:$status=
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:1850:        $status = strtolower((string)($s['status'] ?? ''));
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:1853:        $accepted = ($status === 'accepted' || $decision === 'accept');
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:1897:$status=
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:2028:$status=
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:2059:$status==='accepted'
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:2157:$status=
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:2396:            $status = strtolower((string)($s['status'] ?? ''));
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:2406:            $stage = strtolower((string)($s['stage'] ?? ''));
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:2412:            if ($status === 'under_review') {
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:2416:            if ($status === 'revision_required') {
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:2424:            if ($status === 'published') {
/home/shquier/easyconf.net/easychair/app/controllers/AdminNotificationController.php:103:            SET status = 'sent',
/home/shquier/easyconf.net/easychair/app/controllers/AdminNotificationController.php:123:            SET status = 'cancelled'
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewMonitorController.php:143:                            ra.status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewMonitorController.php:208:                ra.status='completed'
/home/shquier/easyconf.net/easychair/app/controllers/PublicLandingController.php:36:        try { $stats['accepted'] = (int)($db->query("SELECT COUNT(*) FROM submissions WHERE status='accepted'")->fetchColumn() ?: 0); } catch (\Throwable $e) {}
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:508:            status='accepted',
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:528:            status='declined',
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:852:        SET status = 'completed'
