PHP Indexer::generateIndex Examples

Example #1

File: search_index.php Project: a2call/commsy

		ON
			user.item_id = room.creator_id
		WHERE
			room.type = "grouproom" AND
			room.deletion_date IS NULL
	';
	$indexer->add(CS_GROUPROOM_TYPE, $query);
	
	////////////////////////////
	////// Annotations /////////
	////////////////////////////
	$query = '
		SELECT
			annotations.item_id AS item_id,
			annotations.linked_item_id AS index_id,
			NULL AS version_id,
			annotations.modification_date,
			CONCAT(annotations.title, " ", annotations.description, " ", user.firstname, " ", user.lastname) AS search_data
		FROM
			annotations
		LEFT JOIN
			user
		ON
			user.item_id = annotations.creator_id
		WHERE
			annotations.deletion_date IS NULL
	';
	$indexer->add(CS_ANNOTATION_TYPE, $query);
	
	$indexer->generateIndex();