<?
require('lib.php');

header('Content-Type: application/json');
//header('Content-Type: text/plain');

$term = mysqli_escape_data($_GET['term']);

$cross = html_entity_decode('&#x271D;', ENT_QUOTES, 'UTF-8');

$query = <<<EOT
SELECT * FROM (
SELECT ppl_id id, CONCAT(GROUP_CONCAT(DISTINCT
	CONCAT(firstname, ' ', IF(prefix != '', CONCAT(prefix, ' '), ''), surname)
	COLLATE utf8_unicode_ci
	ORDER BY fe.date, se.date
	SEPARATOR ', '), ' (', dob.date, ')', IF(dod.date <= NOW(), ' $cross'
, '')) name
FROM ppl
JOIN datenodes AS dob ON ppl.date_of_birth = dob.datenode_id
LEFT JOIN datenodes AS dod ON ppl.date_of_death = dod.datenode_id
LEFT JOIN firstnames2ppl USING (ppl_id)
LEFT JOIN surnames2ppl USING (ppl_id)
LEFT JOIN datenodes AS fe ON firstnames2ppl.established = fe.datenode_id
LEFT JOIN datenodes AS fd ON firstnames2ppl.disestablished = fd.datenode_id
LEFT JOIN datenodes AS se ON surnames2ppl.established = se.datenode_id
LEFT JOIN datenodes AS sd ON surnames2ppl.disestablished = sd.datenode_id
LEFT JOIN firstnames USING (firstname_id)
LEFT JOIN surnames USING (surname_id)
WHERE
	( sd.date > fe.date OR fe.date IS NULL OR sd.date IS NULL ) AND
	( fd.date > se.date OR se.date IS NULL OR fd.date IS NULL )
GROUP BY ppl_id
ORDER BY surname, firstname, prefix
) bla WHERE name LIKE '%%$term%%'
EOT;

$result = mysqli_query_safe($query);

while ($row = mysqli_fetch_array($result, MYSQL_NUM)) $return[] = array('value' => $row[0], 'label' => $row[1]);

echo(json_encode($return));

?>