prepare("SELECT institution FROM db_user WHERE id = ?;"); $sth->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth->execute(); $sth->setFetchMode(PDO::FETCH_ASSOC); $row = $sth->fetch(); if($row['institution'] == $institution){ //----------------INSERT REFERRING PHYSICIANS-----------------// $sth_ref = $dbh_portal->prepare("SELECT * FROM db_ref_phys WHERE user_id = ?;"); $sth_ref->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth_ref->execute(); if($sth_ref->rowCount() > 0){ $sth_ref = $dbh_portal->prepare("DELETE FROM db_ref_phys WHERE user_id=?;"); $sth_ref->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth_ref_complete = $sth_ref->execute(); }else{ $sth_ref_complete = true; } if($sth_ref_complete){ if(isset($_POST['ref_names'])){ foreach($_POST['ref_names'] as $item){ $sth_ref = $dbh_portal->prepare("INSERT into db_ref_phys (user_id, ref_name, persistent_id) VALUES (?, ?, ?) ;"); $sth_ref->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth_ref->bindParam(2, $item, PDO::PARAM_STR); $sth_ref->bindParam(3, $_POST['persistent_id'], PDO::PARAM_STR); $sth_complete = $sth_ref->execute(); } } } //--------------------INSERT STATIONS---------------------// $sth_stations = $dbh_portal->prepare("SELECT * FROM db_stations WHERE user_id = ?;"); $sth_stations->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth_stations->execute(); if($sth_stations->rowCount() > 0){ $sth_stations = $dbh_portal->prepare("DELETE FROM db_stations WHERE user_id=?;"); $sth_stations->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth_stations_complete = $sth_stations->execute(); }else{ $sth_stations_complete = true; } if($sth_stations_complete){ if(isset($_POST['station_names'])){ foreach($_POST['station_names'] as $item1){ $sth_stations = $dbh_portal->prepare("INSERT into db_stations (user_id, station_name, persistent_id) VALUES (?, ?, ?) ;"); $sth_stations->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth_stations->bindParam(2, $item1, PDO::PARAM_STR); $sth_stations->bindParam(3, $_POST['persistent_id'], PDO::PARAM_STR); $sth_complete = $sth_stations->execute(); } } } //--------------------INSERT BODY PART---------------------// $sth_body_part = $dbh_portal->prepare("SELECT * FROM db_body_part WHERE user_id = ?;"); $sth_body_part->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth_body_part->execute(); if($sth_body_part->rowCount() > 0){ $sth_body_part = $dbh_portal->prepare("DELETE FROM db_body_part WHERE user_id=?;"); $sth_body_part->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth_body_part_complete = $sth_body_part->execute(); }else{ $sth_body_part_complete = true; } if($sth_body_part_complete){ if(isset($_POST['body_part'])){ foreach($_POST['body_part'] as $item1){ $sth_body_part = $dbh_portal->prepare("INSERT into db_body_part (user_id, body_part, persistent_id) VALUES (?, ?, ?) ;"); $sth_body_part->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth_body_part->bindParam(2, $item1, PDO::PARAM_STR); $sth_body_part->bindParam(3, $_POST['persistent_id'], PDO::PARAM_STR); $sth_complete = $sth_body_part->execute(); } } } //--------------------INSERT DEPARTMENT---------------------// $sth_department = $dbh_portal->prepare("SELECT * FROM db_department WHERE user_id = ?;"); $sth_department->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth_department->execute(); if($sth_department->rowCount() > 0){ $sth_department = $dbh_portal->prepare("DELETE FROM db_department WHERE user_id=?;"); $sth_department->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth_department_complete = $sth_department->execute(); }else{ $sth_department_complete = true; } if($sth_department_complete){ if(isset($_POST['department'])){ foreach($_POST['department'] as $item1){ $sth_department = $dbh_portal->prepare("INSERT into db_department (user_id, department, persistent_id) VALUES (?, ?, ?) ;"); $sth_department->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth_department->bindParam(2, $item1, PDO::PARAM_STR); $sth_department->bindParam(3, $_POST['persistent_id'], PDO::PARAM_STR); $sth_complete = $sth_department->execute(); } } } //----------- Update Modalities filter for Doctor user ----------------------// $sth_mods = $dbh_portal->prepare("SELECT * FROM db_modalities WHERE user_id = ?;"); $sth_mods->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth_mods->execute(); $modal=''; foreach($_POST['modality'] as $item){ if ($modal=='') $modal = $item; else $modal = $modal.",".$item; } if($sth_mods->rowCount() > 0){ $sth_mods = $dbh_portal->prepare("UPDATE db_modalities SET filter_user_modal = ? WHERE user_id = ?;"); $sth_mods->bindParam(1, $modal, PDO::PARAM_STR); $sth_mods->bindParam(2, $_POST['user_id'], PDO::PARAM_STR); $sth_complete = $sth_mods->execute(); } else{ $sth_mods = $dbh_portal->prepare("INSERT into db_modalities (user_id, filter_user_modal, persistent_id) VALUES (?, ?, ?) ;"); $sth_mods->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth_mods->bindParam(2, $modal, PDO::PARAM_STR); $sth_mods->bindParam(3, $_POST['persistent_id'], PDO::PARAM_STR); $sth_complete = $sth_mods->execute(); } } } } if($sth_complete){ //-----------------------UPDATE DATABASE THAT USER IS NOW AUTHORIZED---------------------------// $sth = $dbh_portal->prepare("UPDATE db_user SET authorized = '1' WHERE id = ?;"); $sth->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth_update = $sth->execute(); if($sth_update){ ?>
Επιστροφή
Επιστροφή
prepare("SELECT * FROM db_user WHERE id = ? AND institution = ? ;"); $sth->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth->bindParam(2, $institution, PDO::PARAM_STR); $sth->execute(); $sth->setFetchMode(PDO::FETCH_ASSOC); $user_results = $sth->rowCount(); $row = $sth->fetch(); ?>
Επεξεργασία Χρήστη
0) { ?>
Ονοματεπώνυμο:
ΑΜΚΑ:
Ρόλος:
Ίδρυμα:
Ενεργός Χρήστης:
'>
'>
Περιορισμοί
Επιλογή Όλων
!
Επιλογή παραπεμπόντων ιατρών
Επιλογή διαγνωστικών μονάδων
Επιλογή Όλων
!
Εξαίρεση μηχανημάτων διαγνωστικών μονάδων
Επιλογή Όλων
!
Επιλογή μερών του σώματος
Επιλογή Όλων
!
Επιλογή τμήματος
Αποθήκευση
prepare("SELECT filter_user_modal FROM db_modalities WHERE user_id=?;"); $sth4->bindParam(1, $_POST['user_id'], PDO::PARAM_STR); $sth4->execute(); $sth4->setFetchMode(PDO::FETCH_ASSOC); $row4 =$sth4->fetch(); $row4 = explode(",", $row4['filter_user_modal']); foreach($row4 as $keyx){ ?>
Δεν έχετε δικαίωμα επεξεργασίας του συγκεκριμένου χρήστη.
"name", "surname" => "surname", "usergroup" => "usergroup", "amka" => "amka" ); foreach ($col_array as $key => $col) { if($key == $col_name){ return $col; } } return 'surname'; } ?>
Χρήστες
Επώνυμο
Όνομα
ΑΜΚΑ
Αναζήτηση
prepare($sql); $sql .= "order by ".$order_by." ".$limit.";"; $sth = $dbh_portal->prepare($sql); $sth->bindParam(':institution', $institution, PDO::PARAM_STR); $sth_size->bindParam(':institution', $institution, PDO::PARAM_STR); if (isset($_GET['surname']) && $_GET['surname'] != ''){ $sth->bindParam(':surname', $temp_surname, PDO::PARAM_STR); $sth_size->bindParam(':surname', $temp_surname, PDO::PARAM_STR); } if (isset($_GET['name']) && $_GET['name'] != ''){ $sth->bindParam(':name', $temp_name, PDO::PARAM_STR); $sth_size->bindParam(':name', $temp_name, PDO::PARAM_STR); } if (isset($_GET['amka']) && $_GET['amka'] != ''){ $sth->bindParam(':amka', $_GET['amka'], PDO::PARAM_STR); $sth_size->bindParam(':amka', $_GET['amka'], PDO::PARAM_STR); } $sth->execute(); $sth->setFetchMode(PDO::FETCH_ASSOC); $sth_size->execute(); $sth_size->setFetchMode(PDO::FETCH_ASSOC); $row_count = $sth_size->fetch(); //var_dump($row_count); $row_count['row_count'] = $sth_size->rowCount(); ?>
αποτελέσματα,
>10
>20
>50
>100
ανα σελίδα
Προηγούμενο
Επόμενο
Μετάβαση σε σελίδα:
".$i.""); } ?>
Επώνυμο
Όνομα
AMKA
Ομάδα Χρήστη
Επεξεργασία Δικαιωμάτων
Ενεργός Χρήστης
Απενεργοποίηση Χρήστη
fetch()) { ?>
">
"):print("
") ) ?>
"):print("") ) ?>
αποτελέσματα,
>10
>20
>50
>100
ανα σελίδα
Προηγούμενο
Επόμενο
Μετάβαση σε σελίδα:
".$i.""); } ?>