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>';
//dump_array($query['pars'],"Parameters");
echo '<FORM name="part_list" method="POST" action="' . thisdoc() . '">
<INPUT type=hidden name=experiment_id value="' . $experiment_id . '">';
// show list of results
$assign_ids = query_show_query_result($query, "assign");
$_SESSION['assign_ids_' . $experiment_id] = $assign_ids;
echo '</FORM>';
} else {
if (!isset($_SESSION['lastquery_assign_' . $experiment_id])) {
$_SESSION['lastquery_assign_' . $experiment_id] = '';
}
$load_query = $_SESSION['lastquery_assign_' . $experiment_id];
if (!$load_query) {
$load_query = query__load_default_query('assign', $experiment_id);
}
$hide_modules = array('statusids');
$status_query = participant_status__get_pquery_snippet("eligible_for_experiments");
$saved_queries = query__load_saved_queries('assign', $settings['queryform_experimentassign_savedqueries_numberofentries'], $experiment_id);
$exptypes = load_external_experiment_types();
$active_clause = participant_status__get_pquery_snippet("eligible_for_experiments");
redirect("admin/participants_unconfirmed.php");
}
}
}
if ($proceed) {
echo '<center>';
echo '<FORM action="participants_unconfirmed.php" method="POST">';
$posted_query = array('query' => array(0 => array("statusids_multiselect" => array("not" => "", "ms_status" => "0"))));
$query_array = query__get_query_array($posted_query['query']);
$query = query__get_query($query_array, 0, array(), 'creation_time DESC', false);
echo '<BR>
<TABLE width="80%" border="0">
<TR><TD>
<TABLE width="100%" border="0">
<TR><TD width="50%" align="right">
<input class="button" type=submit name="deleteall" value="' . lang('delete_all') . '">
</TD><TD width="50%" align="right">
<input class="button" type=submit name="deletesel" value="' . lang('delete_selected') . '">
</TD></TR>
</TABLE>
</TD></TR>
<TR><TD colspan="2">';
$emails = query_show_query_result($query, "participants_unconfirmed", false);
echo '</FORM>';
echo '</TD></TR></TABLE>';
$emailstring = implode(",", $emails);
echo '<BR><BR>' . button_link('mailto:' . $settings['support_mail'] . '?bcc=' . $emailstring, lang('write_message_to_all_listed'), 'envelope');
echo '<BR><BR>' . button_link('participants_main.php', lang('back'), 'level-up') . '<BR><BR>';
echo '</CENTER>';
}
include "footer.php";
//echo $query['query'];
//echo '</TD></TR></TABLE>';
//dump_array($query['pars'],"Parameters");
//dump_array($_REQUEST);
// show list of results
echo '<form id="bulkactionform" action="participants_show.php" method="POST">';
if (isset($_REQUEST['search_sort'])) {
echo '<input type="hidden" name="search_sort" value="' . $_REQUEST['search_sort'] . '">';
}
if (isset($_REQUEST['active'])) {
echo '<input type="hidden" name="active" value="' . $_REQUEST['active'] . '">';
}
if ($active) {
$plist_ids = query_show_query_result($query, "participants_search_active");
} else {
$plist_ids = query_show_query_result($query, "participants_search_all");
}
echo '</form>';
} else {
//if (!isset($_SESSION['lastquery_'.$experiment_id])) $_SESSION['lastquery_'.$experiment_id]='';
//$load_query=$_SESSION['lastquery_'.$experiment_id];
if ($active) {
if (!isset($_SESSION['lastquery_participants_search_active'])) {
$_SESSION['lastquery_participants_search_active'] = '';
}
$load_query = $_SESSION['lastquery_participants_search_active'];
if (!$load_query) {
$load_query = query__load_default_query('participants_search_active');
}
$hide_modules = array('statusids');
$status_query = participant_status__get_pquery_snippet("eligible_for_experiments");
