diff --git a/classes/submission/common/Action.inc.php b/classes/submission/common/Action.inc.php index 936f10d..2425809 100644 --- a/classes/submission/common/Action.inc.php +++ b/classes/submission/common/Action.inc.php @@ -31,6 +31,7 @@ define('SUBMISSION_FIELD_REVIEWER', 4); define('SUBMISSION_FIELD_COPYEDITOR', 5); define('SUBMISSION_FIELD_LAYOUTEDITOR', 6); define('SUBMISSION_FIELD_PROOFREADER', 7); +define('SUBMISSION_FIELD_ID', 8); define('SUBMISSION_FIELD_DATE_SUBMITTED', 4); define('SUBMISSION_FIELD_DATE_COPYEDIT_COMPLETE', 5); diff --git a/classes/submission/copyeditor/CopyeditorSubmissionDAO.inc.php b/classes/submission/copyeditor/CopyeditorSubmissionDAO.inc.php index 9ca58d1..0991819 100644 --- a/classes/submission/copyeditor/CopyeditorSubmissionDAO.inc.php +++ b/classes/submission/copyeditor/CopyeditorSubmissionDAO.inc.php @@ -162,6 +162,10 @@ class CopyeditorSubmissionDAO extends DAO { $searchSql = ''; if (!empty($search)) switch ($searchField) { + case SUBMISSION_FIELD_ID: + $params[] = (int) $search; + $searchSql = ' AND a.article_id = ?'; + break; case SUBMISSION_FIELD_TITLE: if ($searchMatch === 'is') { $searchSql = ' AND LOWER(atl.setting_value) = LOWER(?)'; diff --git a/classes/submission/editor/EditorSubmissionDAO.inc.php b/classes/submission/editor/EditorSubmissionDAO.inc.php index d254362..eeb2561 100644 --- a/classes/submission/editor/EditorSubmissionDAO.inc.php +++ b/classes/submission/editor/EditorSubmissionDAO.inc.php @@ -204,6 +204,10 @@ class EditorSubmissionDAO extends DAO { $searchSql = ''; if (!empty($search)) switch ($searchField) { + case SUBMISSION_FIELD_ID: + $params[] = (int) $search; + $searchSql = ' AND a.article_id = ?'; + break; case SUBMISSION_FIELD_TITLE: if ($searchMatch === 'is') { $searchSql = ' AND LOWER(COALESCE(atl.setting_value, atpl.setting_value)) = LOWER(?)'; diff --git a/classes/submission/layoutEditor/LayoutEditorSubmissionDAO.inc.php b/classes/submission/layoutEditor/LayoutEditorSubmissionDAO.inc.php index f9bee15..975d6b4 100644 --- a/classes/submission/layoutEditor/LayoutEditorSubmissionDAO.inc.php +++ b/classes/submission/layoutEditor/LayoutEditorSubmissionDAO.inc.php @@ -155,6 +155,10 @@ class LayoutEditorSubmissionDAO extends DAO { $searchSql = ''; if (!empty($search)) switch ($searchField) { + case SUBMISSION_FIELD_ID: + $params[] = (int) $search; + $searchSql = ' AND a.article_id = ?'; + break; case SUBMISSION_FIELD_TITLE: if ($searchMatch === 'is') { $searchSql = ' AND LOWER(atl.setting_value) = LOWER(?)'; diff --git a/classes/submission/proofreader/ProofreaderSubmissionDAO.inc.php b/classes/submission/proofreader/ProofreaderSubmissionDAO.inc.php index 16b4bcc..b836362 100644 --- a/classes/submission/proofreader/ProofreaderSubmissionDAO.inc.php +++ b/classes/submission/proofreader/ProofreaderSubmissionDAO.inc.php @@ -157,6 +157,10 @@ class ProofreaderSubmissionDAO extends DAO { $searchSql = ''; if (!empty($search)) switch ($searchField) { + case SUBMISSION_FIELD_ID: + $params[] = (int) $search; + $searchSql = ' AND a.article_id = ?'; + break; case SUBMISSION_FIELD_TITLE: if ($searchMatch === 'is') { $searchSql = ' AND LOWER(atl.setting_value) = LOWER(?)'; diff --git a/classes/submission/sectionEditor/SectionEditorSubmissionDAO.inc.php b/classes/submission/sectionEditor/SectionEditorSubmissionDAO.inc.php index 4e30f39..ad443cb 100644 --- a/classes/submission/sectionEditor/SectionEditorSubmissionDAO.inc.php +++ b/classes/submission/sectionEditor/SectionEditorSubmissionDAO.inc.php @@ -355,6 +355,10 @@ class SectionEditorSubmissionDAO extends DAO { $searchSql = ''; if (!empty($search)) switch ($searchField) { + case SUBMISSION_FIELD_ID: + $params[] = (int) $search; + $searchSql = ' AND a.article_id = ?'; + break; case SUBMISSION_FIELD_TITLE: if ($searchMatch === 'is') { $searchSql = ' AND LOWER(atl.setting_value) = LOWER(?)';