prepare("SELECT * FROM db_modalities where persistent_id = ?;");
$sth->bindParam(1, $userid, PDO::PARAM_STR);
$sth->execute();
$sth->setFetchMode(PDO::FETCH_ASSOC);
$db_modalities_count = $sth->rowCount();
$db_mod_row = $sth->fetch();
$sth = $dbh->prepare("SELECT DISTINCT mods_in_study as name FROM study left join series on study.pk = series.study_fk WHERE src_aet=?;");
$sth->bindParam(1, $src_aet, PDO::PARAM_STR);
$sth->execute();
$sth->setFetchMode(PDO::FETCH_ASSOC);
// ---- If user id doctor and has filtered modalities
if($db_modalities_count > 0 && $db_mod_row['filter_user_modal'] != "all" && ($db_mod_row['filter_user_modal'] != "" || $db_mod_row['filter_user_modal'] != NULL)){
$temp = explode(",", $db_mod_row['filter_user_modal']);
foreach($temp as $tmp){
$modalities[] = array("name"=>$tmp);
}
}
else{
$modalities = $sth->fetchAll();
}
$modalityX = array();
foreach($modalities as $modx){
$arrMod = explode("\\", $modx['name']);
foreach($arrMod as $modpart){
$modalityX = array_merge($modalityX, array($modpart => '1'));
}
}
$modArrx = array();
foreach($modalityX as $keyx => $val){
$modArrx[] = $keyx;
}
sort($modArrx);
?>
Επιλογή / Αποεπιλογή Όλων
prepare("SELECT id FROM db_user WHERE persistent_id = ?;");
$sth_user_id->bindParam(1, $userid, PDO::PARAM_STR);
$sth_user_id->execute();
$sth_user_id->setFetchMode(PDO::FETCH_ASSOC);
$user_id_row = $sth_user_id->fetch();
$user_id = $user_id_row['id'];
$sth = $dbh_portal->prepare("SELECT * FROM db_modalities;");
$sth->execute();
$sth->setFetchMode(PDO::FETCH_ASSOC);
$flag = 0;
while ($row = $sth->fetch()){
if ($row['persistent_id'] == $userid)
$flag = 1;
}
if($flag == 1){
$sth = $dbh_portal->prepare("UPDATE db_modalities SET modalities = ? WHERE persistent_id = ? ;");
$sth->bindParam(1, $modal, PDO::PARAM_STR);
$sth->bindParam(2, $userid, PDO::PARAM_STR);
$sth->execute();
}
else{
$sth = $dbh_portal->prepare("INSERT INTO db_modalities (user_id, modalities, filter_user_modal, persistent_id) VALUES (?, ?, 'all', ?)");
$sth->bindParam(1, $user_id, PDO::PARAM_STR);
$sth->bindParam(2, $modal, PDO::PARAM_STR);
$sth->bindParam(3, $userid, PDO::PARAM_STR);
$sth->execute();
}
// --------- Get the selected Modalities ---------------------------------------
$sth = $dbh_portal->prepare("SELECT * FROM db_modalities where persistent_id = ?;");
$sth->bindParam(1, $userid, PDO::PARAM_STR);
$sth->execute();
$sth->setFetchMode(PDO::FETCH_ASSOC);
$db_mod_row = $sth->fetch();
?>
prepare("SELECT * FROM db_modalities where user_id = ?;");
$sth->bindParam(1, $_POST['user_id'], PDO::PARAM_STR);
$sth->execute();
$db_mod_row_count = $sth->rowCount();
$sth->setFetchMode(PDO::FETCH_ASSOC);
$db_mod_row = $sth->fetch();
$sth = $dbh->prepare("SELECT DISTINCT mods_in_study as name FROM study left join series on study.pk = series.study_fk WHERE src_aet = ?;");
$sth->bindParam(1, $src_aet, PDO::PARAM_STR);
$sth->execute();
$sth->setFetchMode(PDO::FETCH_ASSOC);
$modalities = $sth->fetchAll();
$modalityX = array();
foreach($modalities as $modx){
$arrMod = explode("\\", $modx['name']);
foreach($arrMod as $modpart){
$modalityX = array_merge($modalityX, array($modpart => '1'));
}
}
$modArrx = array();
foreach($modalityX as $keyx => $val){
$modArrx[] = $keyx;
}
sort($modArrx);
?>
Επιλογή / Αποεπιλογή Όλων