<?php
/*
**************************************************************************************************************************
** CORAL Licensing Module v. 1.0
**
** Copyright (c) 2010 University of Notre Dame
**
** This file is part of CORAL.
**
** CORAL is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
**
** CORAL is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
**
** You should have received a copy of the GNU General Public License along with CORAL.  If not, see <http://www.gnu.org/licenses/>.
**
**************************************************************************************************************************
*/


class Signature extends DatabaseObject {

	protected function defineRelationships() {}

	protected function overridePrimaryKeyName() {}


	//search used for the autocomplete
	public function search($q){
		$signArray = array();
		$result = mysqli_query($this->db->getDatabase(), "SELECT distinct signerName FROM Signature WHERE upper(signerName) like upper('%" . $q . "%') ORDER BY 1;");

		while ($row = mysqli_fetch_assoc($result)){
			$signArray[] = $row['signerName'] . "|" . $row['signerName'];
		}

		return $signArray;
	}

}

?>
