}
}
$assign_ids = $selected_ids;
unset($selected_ids);
}
if (count($assign_ids) > 0) {
$values_clause = array();
$pars = array();
foreach ($assign_ids as $id) {
$pars[] = array(':participant_id' => $id, ':experiment_id' => $experiment_id);
}
$query = "INSERT INTO " . table('participate_at') . " (participant_id,experiment_id)\n VALUES (:participant_id , :experiment_id)";
$done = or_query($query, $pars);
$assigned_count = count($assign_ids);
log__admin("experiment_assign_participants", "experiment:" . $experiment['experiment_name'] . ", count:" . $assigned_count);
$done = query__save_query($_SESSION['lastquery_assign_' . $experiment_id], 'assign', $experiment_id, array('assigned_count' => $assigned_count, 'selected' => $selected, 'totalcount' => $totalcount));
} else {
$assigned_count = 0;
}
$_SESSION['assign_ids_' . $experiment_id] = array();
message($assigned_count . ' ' . lang('xxx_participants_assigned'));
redirect('admin/' . thisdoc() . '?experiment_id=' . $experiment_id);
} elseif (isset($_REQUEST['search_submit']) || isset($_REQUEST['search_sort'])) {
$json = new Services_JSON(SERVICES_JSON_LOOSE_TYPE);
if (isset($_REQUEST['search_sort'])) {
$posted_query_json = $_SESSION['lastquery_assign_' . $experiment_id];
$query_id = $_SESSION['lastqueryid_assign_' . $experiment_id];
$posted_query = $json->decode($posted_query_json);
$sort = query__get_sort('assign', $_REQUEST['search_sort']);
// sanitize sort
} else {
$only_eligible = isset($_REQUEST['only_eligible']) && $_REQUEST['only_eligible'] ? $_REQUEST['only_eligible'] : false;
if (isset($_REQUEST['active']) && $_REQUEST['active']) {
$active = true;
} else {
$active = false;
}
// to encode: $json->encodeUnsafe($_REQUEST['form']).'<BR>';
// do decode: $json->decode($_SESSION['lastquery']);
if (isset($_REQUEST['save_query'])) {
// get old query
if ($active) {
$posted_query_json = $_SESSION['lastquery_participants_search_active'];
$done = query__save_query($posted_query_json, 'participants_search_active');
} else {
$posted_query_json = $_SESSION['lastquery_participants_search_all'];
$done = query__save_query($posted_query_json, 'participants_search_all');
}
$cgivars = array();
if (isset($_REQUEST['search_sort'])) {
$cgivars[] = 'search_sort=' . urlencode($_REQUEST['search_sort']);
}
if ($active) {
$cgivars[] = 'active=true';
}
if (count($cgivars) > 0) {
$cgivarst = '?' . implode("&", $cgivars);
} else {
$cgivarst = '';
}
redirect('admin/' . thisdoc() . $cgivarst);
}
