import('submission.author.AuthorSubmission'); // Bring in editor decision constants

// Bring in editor decision constants

import('submission.common.Action');

import('submission.author.AuthorSubmission');

		$result =& $this->getUnfilteredEditorSubmissions($journalId);

		// Fetch a count of unassigned submissions.

		// "e2" and "e" are used to fetch only a single assignment

		while (!$result->EOF) {

		// if several exist.

			$editorSubmission =& $this->_returnEditorSubmissionFromRow($result->GetRowAssoc(false));

		$result =& $this->retrieve(

			'SELECT	COUNT(*) AS unassigned_count

			// check if submission is still in review

			FROM	articles a

			$inReview = true;

				LEFT JOIN edit_assignments e ON (a.article_id = e.article_id)

			$notDeclined = true;

				LEFT JOIN edit_assignments e2 ON (a.article_id = e2.article_id AND e.edit_id < e2.edit_id)

			$decisions = $editorSubmission->getDecisions();

			WHERE	a.journal_id = ?

			$decision = array_pop($decisions);

				AND a.submission_progress = 0

			if (!empty($decision)) {

				AND a.status = ' . STATUS_QUEUED . '

				$latestDecision = array_pop($decision);

				AND e2.edit_id IS NULL

				import('submission.common.Action');

				AND e.edit_id IS NULL',

				if ($latestDecision['decision'] == SUBMISSION_EDITOR_DECISION_ACCEPT) {

			array((int) $journalId)

					$inReview = false;

		);

				}

		$submissionsCount[0] = $result->Fields('unassigned_count');

			}

		$result->Close();

			// used to check if editor exists for this submission

		// Fetch a count of submissions in review.

			$editAssignments = $editorSubmission->getEditAssignments();

		// "e2" and "e" are used to fetch only a single assignment

		// if several exist.

		// "d2" and "d" are used to fetch the single most recent

		// editor decision.

		$result =& $this->retrieve(

			'SELECT	COUNT(*) AS review_count

			FROM	articles a

				LEFT JOIN edit_assignments e ON (a.article_id = e.article_id)

				LEFT JOIN edit_assignments e2 ON (a.article_id = e2.article_id AND e.edit_id < e2.edit_id)

				LEFT JOIN edit_decisions d ON (a.article_id = d.article_id)

				LEFT JOIN edit_decisions d2 ON (a.article_id = d2.article_id AND d.date_decided < d2.date_decided)

			WHERE	a.journal_id = ?

				AND a.submission_progress = 0

				AND a.status = ' . STATUS_QUEUED . '

				AND e2.edit_id IS NULL

				AND e.edit_id IS NOT NULL

				AND d2.date_decided IS NULL

				AND d.decision <> ' . SUBMISSION_EDITOR_DECISION_ACCEPT,

			array((int) $journalId)

		);

		$submissionsCount[1] = $result->Fields('review_count');

		$result->Close();

			if (empty($editAssignments)) {

		// Fetch a count of submissions in editing.

				// unassigned submissions

		// "e2" and "e" are used to fetch only a single assignment

				$submissionsCount[0] += 1;

		// if several exist.

			} else {

		// "d2" and "d" are used to fetch the single most recent

				if ($inReview) {

		// editor decision.

					if ($notDeclined) {

		$result =& $this->retrieve(

						// in review submissions

			'SELECT	COUNT(*) AS editing_count

						$submissionsCount[1] += 1;

			FROM	articles a

					}

				LEFT JOIN edit_assignments e ON (a.article_id = e.article_id)

				} else {

				LEFT JOIN edit_assignments e2 ON (a.article_id = e2.article_id AND e.edit_id < e2.edit_id)

					// in editing submissions

				LEFT JOIN edit_decisions d ON (a.article_id = d.article_id)

					$submissionsCount[2] += 1;					

				LEFT JOIN edit_decisions d2 ON (a.article_id = d2.article_id AND d.date_decided < d2.date_decided)

				}

			WHERE	a.journal_id = ?

			}

				AND a.submission_progress = 0

			unset($editorSubmission);

				AND a.status = ' . STATUS_QUEUED . '

			$result->MoveNext();

				AND e2.edit_id IS NULL

		}

				AND e.edit_id IS NOT NULL

				AND d2.date_decided IS NULL

				AND d.decision = ' . SUBMISSION_EDITOR_DECISION_ACCEPT,

			array((int) $journalId)

		);

		$submissionsCount[2] = $result->Fields('editing_count');

		$result = $this->getUnfilteredSectionEditorSubmissions($sectionEditorId, $journalId);

		// Fetch a count of submissions in review.

		// "d2" and "d" are used to fetch the single most recent

		while (!$result->EOF) {

		// editor decision.

			$row = $result->GetRowAssoc(false);

		$result =& $this->retrieve(

			$sectionEditorSubmission =& $this->_returnSectionEditorSubmissionFromRow($row);

			'SELECT	COUNT(*) AS review_count

			FROM	articles a

			// check if submission is still in review

				LEFT JOIN edit_assignments e ON (a.article_id = e.article_id)

			$inReview = true;

				LEFT JOIN edit_decisions d ON (a.article_id = d.article_id)

			$decisions = $sectionEditorSubmission->getDecisions();

				LEFT JOIN edit_decisions d2 ON (a.article_id = d2.article_id AND d.date_decided < d2.date_decided)

			$decision = array_pop($decisions);

			WHERE	a.journal_id = ?

				AND e.editor_id = ?

			if (!empty($decision)) {

				AND a.submission_progress = 0

				$latestDecision = array_pop($decision);

				AND a.status = ' . STATUS_QUEUED . '

				if ($latestDecision['decision'] == SUBMISSION_EDITOR_DECISION_ACCEPT) {

				AND d2.date_decided IS NULL

					$inReview = false;

				AND d.decision <> ' . SUBMISSION_EDITOR_DECISION_ACCEPT,

				}

			array((int) $journalId, (int) $sectionEditorId)

			}

		);

		$submissionsCount[0] = $result->Fields('review_count');

			if ($inReview) {

		$result->Close();

				if ($row['can_review']) {

					// in review submissions

		// Fetch a count of submissions in editing.

					$submissionsCount[0] += 1;

		// "d2" and "d" are used to fetch the single most recent

				}

		// editor decision.

			} else {

		$result =& $this->retrieve(

				// in editing submissions

			'SELECT	COUNT(*) AS editing_count

				if ($row['can_edit']) {

			FROM	articles a

					$submissionsCount[1] += 1;

				LEFT JOIN edit_assignments e ON (a.article_id = e.article_id)

				}

				LEFT JOIN edit_decisions d ON (a.article_id = d.article_id)

			}

				LEFT JOIN edit_decisions d2 ON (a.article_id = d2.article_id AND d.date_decided < d2.date_decided)

			unset($sectionEditorSubmission);

			WHERE	a.journal_id = ?

			$result->MoveNext();

				AND e.editor_id = ?

		}

				AND a.submission_progress = 0

				AND a.status = ' . STATUS_QUEUED . '

				AND d2.date_decided IS NULL

				AND d.decision = ' . SUBMISSION_EDITOR_DECISION_ACCEPT,

			array((int) $journalId, (int) $sectionEditorId)

		);

		$submissionsCount[1] = $result->Fields('editing_count');