bibliotheca-php/webclient/view/default/advancedsearch/advancedsearch.php

<?php
/**
 * Bibliotheca
 *
 * Copyright 2018-2023 Johannes Keßler
 *
 * This program 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.
 *
 *  This program 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 this program.  If not, see http://www.gnu.org/licenses/gpl-3.0.
 */

require_once 'lib/trite.class.php';
$Trite = new Trite($DB,$Doomguy);
require_once 'lib/mancubus.class.php';
$Mancubus = new Mancubus($DB,$Doomguy);

$_collection = '';
if(isset($_GET['collection']) && !empty($_GET['collection'])) {
	$_collection = trim($_GET['collection']);
	$_collection = Summoner::validate($_collection,'digit') ? $_collection : '';
}

$TemplateData['pageTitle'] = 'Advanced search';
$TemplateData['loadedCollection'] = array();
$TemplateData['collections'] = array();
$TemplateData['collectionFields'] = array();
$TemplateData['search'] = false;
$TemplateData['searchResultStyle'] = 'grid';

if(!empty($_collection)) {
	$TemplateData['loadedCollection'] = $Trite->load($_collection);
	if(!empty($TemplateData['loadedCollection'])) {
		$TemplateData['collectionFields'] = $Trite->getCollectionFields();
		$Mancubus->setCollection($Trite->param('id'));
		$Mancubus->setQueryOptions(array('limit' => 60));

		$TemplateData['storagePath'] = PATH_WEB_STORAGE . '/' . $Trite->param('id');
		$TemplateData['entryLinkPrefix'] = "index.php?p=entry&collection=".$Trite->param('id');

		if(isset($_POST['submitForm'])) {
			$fdata = $_POST['fdata'];
			if (!empty($fdata)) {
				$_search = trim($fdata['search']);

				if(isset($fdata['tableView'])) {
					$TemplateData['searchResultStyle'] = 'table';
				}

				if (!empty($_search) && Summoner::validate($_search)) {
					if (str_contains($_search, ':')) { // field search
						$_matches = array();
						if(preg_match_all("/(\p{L}+:)(?(?!\p{L}+:).)*/u",$_search, $_matches) !== false && !empty($_matches[0])) {
							// $matches[0] has the identifier: and text
							// $matches[1] has only the identifier:
							// $matches[0][0] belongs to $matches[1][0] and so on

							$_sData = array();
							$_ms = count($_matches[0]);
							for($i=0;$i<$_ms;$i++) {
								$_cn = trim(str_replace(':','',$_matches[1][$i]));
								if(isset($TemplateData['collectionFields'][$_cn])) {
									$_sData[$i]['colName'] = $_cn;
									$_sData[$i]['colValue'] = trim(str_replace($_matches[1][$i],'',$_matches[0][$i]));
									$_sData[$i]['fieldData'] = $TemplateData['collectionFields'][$_cn];

									if(!isset($TemplateData['loadedCollection']['advancedSearchTableFields'][$_sData[$i]['fieldData']['id']])) {
										$TemplateData['loadedCollection']['advancedSearchTableFields'][$_sData[$i]['fieldData']['id']] = $_sData[$i]['fieldData']['id'];
									}
								}
							}

							$TemplateData['entries'] = $Mancubus->getEntries($_sData);
							$TemplateData['search'] = $_search;
						}
						else {
							$TemplateData['message']['content'] = $I18n->t('advsearch.message.wrongInputFormat');
							$TemplateData['message']['status'] = "error";
						}
					} else { // ordinary search within default field
						$TemplateData['entries'] = $Mancubus->getEntries(
							array(
								0 => array(
									'colName' => $Trite->param('defaultSearchField'),
									'colValue' => $_search,
									'fieldData' => $TemplateData['collectionFields'][$Trite->param('defaultSearchField')]
								)
							)
						);
						$TemplateData['search'] = $_search;
					}
				}
			}
		}
	}
	else {
		$TemplateData['message']['content'] = $I18n->t('global.message.couldNotLoadCollection');
		$TemplateData['message']['status'] = "error";
	}
}
else {
	$TemplateData['collections'] = $Trite->getCollections();
}