public function saveAction()
{
$values = Zend_Json::decode($this->getParam("data"));
// convert all special characters to their entities so the xml writer can put it into the file
$values = array_htmlspecialchars($values);
try {
$sphinx_config = new SphinxSearch_Config();
$sphinx_config->writeSphinxConfig();
$plugin_config = new SphinxSearch_Config_Plugin();
$config_data = $plugin_config->getData();
$config_data["path"]["pid"] = $values["sphinxsearch.path_pid"];
$config_data["path"]["querylog"] = $values["sphinxsearch.path_querylog"];
$config_data["path"]["log"] = $values["sphinxsearch.path_logfile"];
$config_data["path"]["indexer"] = $values["sphinxsearch.path_indexer"];
$config_data["path"]["phpcli"] = $values["sphinxsearch.path_phpcli"];
$config_data["path"]["searchd"] = $values["sphinxsearch.path_searchd"];
$config_data["indexer"]["period"] = $values["sphinxsearch.indexer_period"];
$config_data["indexer"]["runwithmaintenance"] = $values["sphinxsearch.indexer_maintenance"] == "true" ? "true" : "false";
$config_data["indexer"]["onchange"] = $values["sphinxsearch.indexer_onchange"];
$config_data["documents"]["use_i18n"] = $values["sphinxsearch.documents_i18n"] == "true" ? "true" : "false";
$config_data["searchd"]["port"] = $values["sphinxsearch.searchd_port"];
$plugin_config->setData($config_data);
$plugin_config->save();
$this->_helper->json(array("success" => true));
} catch (Exception $e) {
$this->_helper->json(false);
}
}
/**
* SphinxSearch_Backend Constructor
*
* @param SphinxSearch_Config $config
* @return SphinxSearch_Backend
*/
function SphinxSearch_Backend($config)
{
$this->config = $config;
$this->view = $config->get_view();
if (!empty($_GET['menu']) && !empty($_REQUEST['action'])) {
if ('terms_editor' == $_GET['menu'] && $_REQUEST['action'] == 'export') {
$terms_editor = new TermsEditorController($this->config);
$terms_editor->_export_keywords();
}
}
}
private function getDocumentIds()
{
if ($this->search_result_ids === null) {
$sphinx_config = SphinxSearch_Config::getInstance();
$documents_config = $sphinx_config->getDocumentsAsArray();
$query = $this->query;
if (!$this->getUnpublished()) {
$query = $query . " @o_published 1";
}
$language = "all";
if ($this->plugin_config->documents->use_i18n == "true") {
$locale = Zend_Registry::get("Zend_Locale");
$language = $locale->getLanguage();
}
foreach ($documents_config as $document_name => $document_properties) {
$indexes[] = "idx_document_" . $document_name . "_" . $language;
}
$search_result = $this->SphinxClient->Query($query, implode(", ", $indexes));
if ($search_result === false) {
throw new Exception($this->SphinxClient->GetLastError());
}
if ($search_result["total_found"] > 0) {
$this->search_result_ids = array_keys($search_result["matches"]);
} else {
$this->search_result_ids = array();
}
}
return $this->search_result_ids;
}
/**
* Returns an instance of SphinxSearch_Config
*
* Singleton pattern implementation
*
* @return SphinxSearch_Config
*/
public static function getInstance()
{
if (null === self::$_instance) {
self::$_instance = new self();
}
return self::$_instance;
}
public function __construct($query, $class_name)
{
parent::__construct($query);
$class_name = strtolower($class_name);
$this->class_name = $class_name;
$sphinx_config = SphinxSearch_Config::getInstance();
$class_config = $sphinx_config->getClassesAsArray();
// The configuration
$field_weights = array();
foreach ($class_config[$this->class_name] as $field_name => $field_config) {
if (array_key_exists("weight", $field_config)) {
$field_weights[$field_name] = $field_config["weight"];
}
}
if (sizeof($field_weights) > 0) {
$this->SphinxClient->setFieldWeights($field_weights);
}
}
function _get_stat_keywords($page, $period_param)
{
$start = ($page - 1) * $this->_keywords_per_page;
if ($period_param > 0) {
$this->_sphinx->SetFilterRange("date_added", strtotime("-{$period_param} days"), time());
}
$sort_order = 'desc';
if (!empty($_REQUEST['sort_order']) && strtolower($_REQUEST['sort_order']) == 'asc') {
$sort_order = 'asc';
}
$sort_by_param = !empty($_REQUEST['sort_by']) ? $_REQUEST['sort_by'] : 'date';
switch (strtolower($sort_by_param)) {
case 'cnt':
$sort_by = '@count';
break;
case 'date':
default:
$sort_by = 'date_added';
break;
}
$this->_sphinx->SetGroupBy("keywords_crc", SPH_GROUPBY_ATTR, "{$sort_by} {$sort_order}");
if ('asc' == $sort_order) {
$this->_sphinx->SetSortMode(SPH_SORT_ATTR_ASC, "date_added");
} else {
$this->_sphinx->SetSortMode(SPH_SORT_ATTR_DESC, "date_added");
}
$this->_sphinx->SetLimits($start, $this->_keywords_per_page);
$res = $this->_sphinx->Query("", $this->_config->get_option('sphinx_index') . 'stats');
if (empty($res['matches'])) {
return array();
}
$this->_results = $res;
$ids = array_keys($res['matches']);
$sql = 'select id, keywords, date_added
from ' . $this->_table_prefix . 'sph_stats
where id in (' . implode(',', $ids) . ')
order by FIELD(id, ' . implode(',', $ids) . ')';
$keywords = $this->_wpdb->get_results($sql, OBJECT_K);
foreach ($res['matches'] as $index => $match) {
$keywords[$index]->cnt = $match['attrs']['@count'];
}
return $keywords;
}
function _get_new_keywords($page, $status)
{
$sterm_value = !empty($_REQUEST['sterm']) ? $_REQUEST['sterm'] : '';
switch ($status) {
case 'approved':
$status_filter = array(1);
$sort_order = "@count desc";
break;
case 'ban':
$status_filter = array(2);
$sort_order = "@count desc";
break;
case 'new':
default:
$status_filter = array(0);
$sort_order = "date_added desc";
break;
}
$start = ($page - 1) * $this->_keywords_per_page;
$this->_sphinx->SetFilter('status', $status_filter);
$this->_sphinx->SetGroupBy("keywords_crc", SPH_GROUPBY_ATTR, $sort_order);
$this->_sphinx->SetSortMode(SPH_SORT_ATTR_DESC, 'date_added');
$this->_sphinx->SetLimits($start, $this->_keywords_per_page);
$res = $this->_sphinx->Query($sterm_value, $this->_config->get_option('sphinx_index') . 'stats');
if (empty($res['matches'])) {
return array();
}
$this->_results = $res;
$ids = array_keys($res['matches']);
$sql = 'select id, keywords, date_added
from ' . $this->_table_prefix . 'sph_stats
where id in (' . implode(',', $ids) . ')
order by FIELD(id, ' . implode(',', $ids) . ')';
$keywords = $this->_wpdb->get_results($sql, OBJECT_K);
foreach ($res['matches'] as $index => $match) {
$keywords[$index]->cnt = $match['attrs']['@count'];
}
return $keywords;
}
/**
* @access private
* @return void
*/
function _set_sphinx_detected($searchd, $indexer)
{
$options['sphinx_searchd'] = $searchd;
$options['sphinx_indexer'] = $indexer;
$this->_config->update_admin_options($options);
}
ini_set('memory_limit', '2048M');
set_time_limit(-1);
date_default_timezone_set("Europe/Berlin");
include_once dirname(__FILE__) . "/../../../pimcore/config/startup.php";
Pimcore::initAutoloader();
Pimcore::initConfiguration();
Pimcore::initLogger();
Pimcore::initPlugins();
$opts = new Zend_Console_Getopt(array('language|l=s' => "language", 'document|d=s' => "document"));
try {
$opts->parse();
} catch (Exception $e) {
Logger::critical($e->getMessage());
die("Error: " . $e->getMessage());
}
$sphinx_config = SphinxSearch_Config::getInstance();
$documents = $sphinx_config->getDocumentsAsArray();
if (!array_key_exists($opts->document, $documents)) {
SphinxSearch_Logger::err("Unknown document: " . $opts->document . "\n");
print "Unknown document: " . $opts->document . "\n";
print "Possible documents are:\n";
foreach ($documents as $document_name => $document_config) {
print $document_name . "\n";
}
die;
}
$document_config = $documents[$opts->document];
$controller = $document_config["controller"];
$action = $document_config["action"];
$template = $document_config["template"];
$db = Pimcore_Resource::get();
public static function queryDocument($query, $params = array())
{
if (trim($query) == "") {
return array();
}
$sphinx_config = SphinxSearch_Config::getInstance();
$documents_config = $sphinx_config->getDocumentsAsArray();
$SphinxClient = new SphinxClient();
$entries = array();
$language = "all";
if (SphinxSearch_Config_Plugin::getValue("documents", "use_i18n") == "true") {
if (array_key_exists("language", $params)) {
$language = $params["language"];
} else {
$locale = Zend_Registry::get("Zend_Locale");
$language = $locale->getLanguage();
}
}
$field_weights = array();
$indexes = array();
foreach ($documents_config as $document_name => $document_properties) {
$indexes[] = "idx_document_" . $document_name . "_" . $language;
foreach ($document_properties["elements"] as $field_name => $field_config) {
if (array_key_exists("weight", $field_config) && intval($field_config["weight"]) > 0) {
$field_weights[$field_name] = intval($field_config["weight"]);
}
}
}
if (sizeof($field_weights) > 0) {
$SphinxClient->setFieldWeights($field_weights);
}
$search_result = $SphinxClient->Query($query, implode(", ", $indexes));
if ($search_result === false) {
throw new Exception($SphinxClient->GetLastError());
}
if ($search_result["total_found"] > 0) {
foreach ($search_result["matches"] as $id => $meta) {
$entries[] = array("result" => Document::getById($id), "id" => $id, "meta" => $meta, "type" => "document");
}
}
return $entries;
}
public static function isSearchdRunning()
{
$config = SphinxSearch_Config::getInstance();
$pid_file = PIMCORE_DOCUMENT_ROOT . DIRECTORY_SEPARATOR . SphinxSearch_Config_Plugin::getValue("path", "pid");
if (!file_exists($pid_file)) {
//die("PIDFILE ".$pid_file." nicht gefunden");
return false;
}
$pid = trim(file_get_contents($pid_file));
exec("ps {$pid}", $output, $result);
return count($output) >= 2;
}