IdentificationCodesDAO.inc.php

<?php

/**
 * @file plugins/generic/identificationCodes/IdentificationCodesDAO.inc.php
 *
 * Copyright (c) 2016 Language Science Press
 * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.  
 *
 * @class IdentificationCodesDAO
 *
 */

class IdentificationCodesDAO extends DAO {
	/**
	 * Constructor
	 */
	function IdentificationCodesDAO() {
		parent::DAO();
	}

	function getData() {

		$result = $this->retrieve("SELECT pf.publication_format_id, pfs.setting_value AS pfname, ic.code, ic.value, pf.submission_id,ss.setting_value AS btitle FROM identification_codes ic LEFT JOIN publication_formats pf ON pf.publication_format_id=ic.publication_format_id
LEFT JOIN publication_format_settings pfs ON pf.publication_format_id=pfs.publication_format_id 
LEFT JOIN submission_settings ss ON ss.submission_id=pf.submission_id WHERE ss.setting_name='title' AND ss.locale='en_US' ORDER BY pf.submission_id"
		);

		if ($result->RecordCount() == 0) {
			$result->Close();
			return null;
		} else {

			$identificationCodes = array();
			while (!$result->EOF) {
				$row = $result->getRowAssoc(false);

				$publicationFormatId = $this->convertFromDB($row['publication_format_id'],null);
				$codeId = $this->convertFromDB($row['code'],null); 

				$identificationCodes[$publicationFormatId]['subId'] = $this->convertFromDB($row['submission_id'],null);
				$identificationCodes[$publicationFormatId]['title'] = $this->convertFromDB($row['btitle'],null); 
				$identificationCodes[$publicationFormatId]['publicationFormat'] = $this->convertFromDB($row['pfname'],null);
				$identificationCodes[$publicationFormatId][$codeId] = $this->convertFromDB($row['value'],null);
				$result->MoveNext();
			}
			$result->Close();
			return $identificationCodes;
		}
	}

}

?>