function query__apply_permanent_queries()
{
global $settings;
$continue = true;
$target = '';
$num_queries = 0;
$num_p = 0;
$num_assigned = 0;
if ($continue) {
if ($settings['allow_permanent_queries'] != 'y') {
$continue = false;
}
}
if ($continue) {
$ppart = array();
$ppart = participant__get_permanent_query_participants();
if (count($ppart) == 0) {
$continue = false;
}
}
if ($continue) {
$pqu = array();
$pqu = query__get_permanent();
if (count($pqu) == 0) {
$continue = false;
} else {
$num_queries = count($pqu);
}
}
if ($continue) {
$json = new Services_JSON(SERVICES_JSON_LOOSE_TYPE);
$query_assigned = array();
foreach ($ppart as $p) {
$num_p++;
foreach ($pqu as $q) {
$experiment = orsee_db_load_array("experiments", $q['experiment_id'], "experiment_id");
if (!isset($experiment['experiment_id'])) {
$continue = false;
}
if ($continue) {
$posted_query = $json->decode($q['json_query']);
$query_array = query__get_query_array($posted_query['query']);
$active_clause = array('query' => participant_status__get_pquery_snippet("eligible_for_experiments"), 'pars' => array());
$exptype_clause = array('query' => "subscriptions LIKE (:experiment_ext_type)", 'pars' => array(':experiment_ext_type' => "%|" . $experiment['experiment_ext_type'] . "|%"));
$notyetassigned_clause = array('query' => "participant_id NOT IN (SELECT participant_id FROM " . table('participate_at') . " WHERE experiment_id= :experiment_id)", 'pars' => array(':experiment_id' => $experiment['experiment_id']));
$additional_clauses = array($active_clause, $exptype_clause, $notyetassigned_clause);
$query = query__get_query($query_array, time(), $additional_clauses, '');
$result = or_query($query['query'], $query['pars']);
$p_is_eligibe = false;
while ($pc = pdo_fetch_assoc($result)) {
if ($pc['participant_id'] = $p['participant_id']) {
$p_is_eligibe = true;
}
}
if (!$p_is_eligibe) {
$continue = false;
}
}
if ($continue) {
// assign participant
$pars = array(':participant_id' => $p['participant_id'], ':experiment_id' => $experiment['experiment_id']);
$query = "INSERT INTO " . table('participate_at') . " (participant_id,experiment_id)\n VALUES (:participant_id , :experiment_id)";
$done = or_query($query, $pars);
$num_assigned++;
if ($settings['permanent_queries_invite'] == 'y') {
// send invitation into mail queue
$pars = array(':experiment_id' => $experiment['experiment_id'], ':now' => time(), ':recipient' => $p['participant_id']);
$query = "INSERT INTO " . table('mail_queue') . "\n SET timestamp = :now,\n mail_type = 'invitation',\n mail_recipient = :recipient,\n experiment_id = :experiment_id ";
$done = or_query($query, $pars);
}
if (!isset($query_assigned[$q['query_id']])) {
$query_assigned[$q['query_id']] = 0;
}
$query_assigned[$q['query_id']]++;
}
}
// done with participant, reset permanent status
$pars = array(':participant_id' => $p['participant_id']);
$query = "UPDATE " . table('participants') . "\n SET apply_permanent_queries = 0\n WHERE participant_id = :participant_id";
$done = or_query($query, $pars);
}
// and now update permanent queries with assignment numbers
foreach ($pqu as $q) {
if (!isset($query_assigned[$q['query_id']])) {
$query_assigned[$q['query_id']] = 0;
}
$done = query__update_permanent_query($q['query_id'], $query_assigned[$q['query_id']]);
}
}
$target = 'Participants checked: ' . $num_p;
if ($num_p > 0) {
$target .= ', PermQueries found: ' . $num_queries;
}
if ($num_queries > 0) {
$target .= ', Assignments made: ' . $num_assigned;
}
return $target;
}
echo $pseudo_query_display;
echo '</TD><TD align="center">';
// permanent query button
if ($settings['allow_permanent_queries'] == 'y' && check_allow('experiment_assign_query_permanent_activate')) {
$cgivars = array();
$cgivars[] = "make_permanent=true";
if (isset($_REQUEST['search_sort'])) {
$cgivars[] = 'search_sort=' . urlencode($_REQUEST['search_sort']);
}
$cgivars[] = 'experiment_id=' . $experiment_id;
$link = thisdoc();
if (count($cgivars) > 0) {
$link .= '?' . implode("&", $cgivars);
}
echo button_link($link, lang('activate_query_permanently'), 'toggle-on');
$perm_queries = query__get_permanent($experiment_id);
if (count($perm_queries) > 0) {
echo '<BR>' . lang('found_active_permanent_query');
}
}
echo '</TD></TR></TABLE>';
echo '<BR><BR>';
$query_array = query__get_query_array($posted_query['query']);
$active_clause = array('query' => participant_status__get_pquery_snippet("eligible_for_experiments"), 'pars' => array());
$exptype_clause = array('query' => "subscriptions LIKE (:experiment_ext_type)", 'pars' => array(':experiment_ext_type' => "%|" . $experiment['experiment_ext_type'] . "|%"));
$notyetassigned_clause = array('query' => "participant_id NOT IN (SELECT participant_id FROM " . table('participate_at') . " WHERE experiment_id= :experiment_id)", 'pars' => array(':experiment_id' => $experiment_id));
$additional_clauses = array($active_clause, $exptype_clause, $notyetassigned_clause);
$query = query__get_query($query_array, $query_id, $additional_clauses, $sort);
//echo '<TABLE width="70%" border=0><TR><TD><B>Query:</B></TD></TR><TR><TD>';
//echo $query['query'];
//echo '</TD></TR></TABLE>';
