View | Details | Raw Unified | Return to bug 6407 | Differences between
and this patch

Collapse All | Expand All

(-)a/classes/submission/common/Action.inc.php (+1 lines)
 Lines 31-36   define('SUBMISSION_FIELD_REVIEWER', 4); Link Here 
31
define('SUBMISSION_FIELD_COPYEDITOR', 5);
31
define('SUBMISSION_FIELD_COPYEDITOR', 5);
32
define('SUBMISSION_FIELD_LAYOUTEDITOR', 6);
32
define('SUBMISSION_FIELD_LAYOUTEDITOR', 6);
33
define('SUBMISSION_FIELD_PROOFREADER', 7);
33
define('SUBMISSION_FIELD_PROOFREADER', 7);
34
define('SUBMISSION_FIELD_ID', 8);
34
35
35
define('SUBMISSION_FIELD_DATE_SUBMITTED', 4);
36
define('SUBMISSION_FIELD_DATE_SUBMITTED', 4);
36
define('SUBMISSION_FIELD_DATE_COPYEDIT_COMPLETE', 5);
37
define('SUBMISSION_FIELD_DATE_COPYEDIT_COMPLETE', 5);
(-)a/classes/submission/copyeditor/CopyeditorSubmissionDAO.inc.php (+4 lines)
 Lines 162-167   class CopyeditorSubmissionDAO extends DAO { Link Here 
162
		$searchSql = '';
162
		$searchSql = '';
163
163
164
		if (!empty($search)) switch ($searchField) {
164
		if (!empty($search)) switch ($searchField) {
165
			case SUBMISSION_FIELD_ID:
166
				$params[] = (int) $search;
167
				$searchSql = ' AND a.article_id = ?';
168
				break;
165
			case SUBMISSION_FIELD_TITLE:
169
			case SUBMISSION_FIELD_TITLE:
166
				if ($searchMatch === 'is') {
170
				if ($searchMatch === 'is') {
167
					$searchSql = ' AND LOWER(atl.setting_value) = LOWER(?)';
171
					$searchSql = ' AND LOWER(atl.setting_value) = LOWER(?)';
(-)a/classes/submission/editor/EditorSubmissionDAO.inc.php (+4 lines)
 Lines 204-209   class EditorSubmissionDAO extends DAO { Link Here 
204
		$searchSql = '';
204
		$searchSql = '';
205
205
206
		if (!empty($search)) switch ($searchField) {
206
		if (!empty($search)) switch ($searchField) {
207
			case SUBMISSION_FIELD_ID:
208
				$params[] = (int) $search;
209
				$searchSql = ' AND a.article_id = ?';
210
				break;
207
			case SUBMISSION_FIELD_TITLE:
211
			case SUBMISSION_FIELD_TITLE:
208
				if ($searchMatch === 'is') {
212
				if ($searchMatch === 'is') {
209
					$searchSql = ' AND LOWER(COALESCE(atl.setting_value, atpl.setting_value)) = LOWER(?)';
213
					$searchSql = ' AND LOWER(COALESCE(atl.setting_value, atpl.setting_value)) = LOWER(?)';
(-)a/classes/submission/layoutEditor/LayoutEditorSubmissionDAO.inc.php (+4 lines)
 Lines 155-160   class LayoutEditorSubmissionDAO extends DAO { Link Here 
155
		$searchSql = '';
155
		$searchSql = '';
156
156
157
		if (!empty($search)) switch ($searchField) {
157
		if (!empty($search)) switch ($searchField) {
158
			case SUBMISSION_FIELD_ID:
159
				$params[] = (int) $search;
160
				$searchSql = ' AND a.article_id = ?';
161
				break;
158
			case SUBMISSION_FIELD_TITLE:
162
			case SUBMISSION_FIELD_TITLE:
159
				if ($searchMatch === 'is') {
163
				if ($searchMatch === 'is') {
160
					$searchSql = ' AND LOWER(atl.setting_value) = LOWER(?)';
164
					$searchSql = ' AND LOWER(atl.setting_value) = LOWER(?)';
(-)a/classes/submission/proofreader/ProofreaderSubmissionDAO.inc.php (+4 lines)
 Lines 157-162   class ProofreaderSubmissionDAO extends DAO { Link Here 
157
		$searchSql = '';
157
		$searchSql = '';
158
158
159
		if (!empty($search)) switch ($searchField) {
159
		if (!empty($search)) switch ($searchField) {
160
			case SUBMISSION_FIELD_ID:
161
				$params[] = (int) $search;
162
				$searchSql = ' AND a.article_id = ?';
163
				break;
160
			case SUBMISSION_FIELD_TITLE:
164
			case SUBMISSION_FIELD_TITLE:
161
				if ($searchMatch === 'is') {
165
				if ($searchMatch === 'is') {
162
					$searchSql = ' AND LOWER(atl.setting_value) = LOWER(?)';
166
					$searchSql = ' AND LOWER(atl.setting_value) = LOWER(?)';
(-)a/classes/submission/sectionEditor/SectionEditorSubmissionDAO.inc.php (+4 lines)
 Lines 355-360   class SectionEditorSubmissionDAO extends DAO { Link Here 
355
		$searchSql = '';
355
		$searchSql = '';
356
356
357
		if (!empty($search)) switch ($searchField) {
357
		if (!empty($search)) switch ($searchField) {
358
			case SUBMISSION_FIELD_ID:
359
				$params[] = (int) $search;
360
				$searchSql = ' AND a.article_id = ?';
361
				break;
358
			case SUBMISSION_FIELD_TITLE:
362
			case SUBMISSION_FIELD_TITLE:
359
				if ($searchMatch === 'is') {
363
				if ($searchMatch === 'is') {
360
					$searchSql = ' AND LOWER(atl.setting_value) = LOWER(?)';
364
					$searchSql = ' AND LOWER(atl.setting_value) = LOWER(?)';

Return to bug 6407