/**
* get results using the standard query handler
*
* @param string $querystring
* @param int $offset
* @param int $limit
* @param mixed $fields_constraints a string or a hash of the form $field => $constraint - ('model' => 'OppAtto')
* @param boolean $quotes_mode specifies wether terms should be only searched as quoted text (for Alerts)
* @param string $sort
* @return sfSolrPager
* @throws sfSolrException
* @author Guglielmo Celata
*/
public static function getSfStandardResults($querystring, $offset = 0, $limit = 10, $fields_constraints = array(), $quotes_mode = false, $sort_specification = '')
{
sfLogger::getInstance()->info(sprintf("{deppOppSolr::getSfStandardResults} using Standard query type for %s", $querystring));
$query = strip_tags(trim($querystring));
// opzioni aggiuntive per la ricerca
$query_options = array('fl' => '*,score');
// aggiunge specifica del sort, se presente
if ($sort_specification != '') {
$query_options['sort'] = $sort_specification;
}
$q_first = "";
$quoted = false;
if (strpos($query, '"') === false) {
// se utente non ha inserito esplicitamente le virgolette
// crea stringhe quoted e q_first
$words = split(" ", $query);
$q_first = $words[0];
$quoted = '"' . $query . '"';
} else {
// se utente ha inserito virgolette, entra in quotes_mode
// con la stringa quoted uguale alla query
$quotes_mode = true;
$quoted = $query;
}
// definizione dei boost (spostare in config??)
$nominativo_boost = 10.0;
$triple_value_boost = 6.0;
$titolo_boost = 6.0;
$testo_boost = 1.5;
$descrizioneWiki_boost = 1.0;
$quoted_boost = 5.0;
$qfirst_boost = 2.0;
// compone la query ponderata
$composed_query = "+(";
if ($quoted) {
$composed_query .= " nominativo: ({$quoted})^" . $nominativo_boost * $quoted_boost . " ";
$composed_query .= " triple_value: ({$quoted})^" . $triple_value_boost * $quoted_boost . " ";
$composed_query .= " titolo: ({$quoted})^" . $titolo_boost * $quoted_boost . " ";
$composed_query .= " testo: ({$quoted})^" . $testo_boost * $quoted_boost . " ";
$composed_query .= " descrizioneWiki: ({$quoted})^" . $descrizioneWiki_boost * $quoted_boost . " ";
}
// aggiunge ricerca per termini che iniziano come il primo termine e in OR su tutti i termini
if ($quotes_mode == false) {
if ($q_first) {
$composed_query .= " nominativo: ({$q_first}*)^" . $nominativo_boost * $qfirst_boost . " ";
$composed_query .= " triple_value: ({$q_first}*)^" . $triple_value_boost * $qfirst_boost . " ";
$composed_query .= " titolo: ({$q_first}*)^" . $titolo_boost * $qfirst_boost . " ";
$composed_query .= " testo: ({$q_first}*)^" . $testo_boost * $qfirst_boost . " ";
$composed_query .= " descrizioneWiki: ({$q_first}*)^" . $descrizioneWiki_boost * $qfirst_boost . " ";
}
$composed_query .= " nominativo:(" . $query . ")^" . $nominativo_boost;
$composed_query .= " triple_value:(" . $query . ")^" . $triple_value_boost;
$composed_query .= " titolo:(" . $query . ")^" . $titolo_boost;
$composed_query .= " testo:(" . $query . ")^" . $testo_boost;
$composed_query .= " descrizioneWiki:(" . $query . ")^" . $descrizioneWiki_boost;
}
$composed_query .= ") ";
// aggiunge i constraints (+ obbligatori)
if (is_string($fields_constraints)) {
$composed_query .= " " . $fields_constraints;
} else {
foreach ($fields_constraints as $field => $constraint) {
$composed_query .= " +{$field}:{$constraint} ";
}
}
# query debug
if (sfConfig::get('solr_query_debug_level', 1) > 0) {
// add debug query parameter
$query_options['debugQuery'] = 'true';
}
// returns the pager or trap the exception
try {
$results = deppOppSolr::getInstance()->friendlySearch($composed_query, $offset, $limit, $query_options);
return $results;
} catch (Exception $e) {
sfLogger::getInstance()->err('{sfSolrActions::getResults} ' . $e->getMessage());
throw new sfSolrException($e->getMessage());
}
}
/**
* Returns an instance of sfSolr configured for this environment.
*/
protected function getSolrInstance()
{
return deppOppSolr::getInstance();
}
/**
* Fetch news and show them, for each users
*/
function run_opp_test_alerts($task, $args, $options)
{
static $loaded;
// load application context
if (!$loaded) {
define('SF_ROOT_DIR', sfConfig::get('sf_root_dir'));
define('SF_APP', 'fe');
define('SF_ENVIRONMENT', 'task');
define('SF_DEBUG', true);
require_once SF_ROOT_DIR . DIRECTORY_SEPARATOR . 'apps' . DIRECTORY_SEPARATOR . SF_APP . DIRECTORY_SEPARATOR . 'config' . DIRECTORY_SEPARATOR . 'config.php';
sfContext::getInstance();
sfConfig::set('pake', true);
error_reporting(E_ALL);
$loaded = true;
}
$last_alert = null;
if (array_key_exists('last-alert', $options)) {
$last_alert = strftime("%Y-%m-%dT%H:%M:%SZ", strtotime($options['last-alert']));
}
// create a solr instance to read solr.yml config
$solr_instance = deppOppSolr::getInstance();
sfLoader::loadHelpers(array('Partial', 'sfSolr', 'DeppNews'));
$start_time = microtime(true);
echo pakeColor::colorize("Hi, there!\n", array('fg' => 'green', 'bold' => true));
$c = new Criteria();
$c->add(OppUserPeer::WANTS_OPP_ALERTS, 1);
$c->add(OppUserPeer::IS_ACTIVE, 1);
$c->add(OppUserPeer::N_ALERTS, 0, Criteria::GREATER_THAN);
if (count($args)) {
$c->add(OppUserPeer::ID, $args, Criteria::IN);
}
$users = OppUserPeer::doSelect($c);
$n_users = count($users);
echo pakeColor::colorize("{$n_users} users set alerts. Here are the notifications we would send them.\n", array('fg' => 'green'));
foreach ($users as $cnt => $user) {
$last_alert = $user->getLastAlertedAt("%Y-%m-%dT%H:%M:%SZ");
echo "{$cnt}/{$n_users} ";
opp_test_single_user_alerts($user, $last_alert);
}
$total_time = microtime(true) - $start_time;
echo pakeColor::colorize('All done! ', array('fg' => 'green', 'bold' => true));
echo 'Processed ';
echo pakeColor::colorize(count($users), array('fg' => 'cyan'));
echo ' users in ';
echo pakeColor::colorize(sprintf("%f", $total_time), array('fg' => 'cyan'));
echo " seconds\n";
}
