function GetProviders() { global $current_user; $db = DBManagerFactory::getInstance(); $locations = ""; $sql = ""; $providers = ""; if (isset($current_user) and $current_user->check_role_membership('PRESCRIBER_ONLY')) { $sql = "SELECT prov.name provname, prov.id provid FROM users_reg_provider_1_c provlink, reg_provider prov where prov.id = provlink.users_reg_provider_1reg_provider_idb\n\t\t\tAND users_reg_provider_1users_ida = '" . $current_user->id . "'"; } if (isset($current_user) and $current_user->check_role_membership('MULTI_LOCATION')) { $locations = GetLocations(); $sql = "SELECT prov.name provname, prov.id provid FROM reg_provider prov, reg_provider_cstm cstm where cstm.id_c = prov.id\n\t\t AND cstm.provider_location_c IN ({$locations})"; } if ($sql == "") { return "''"; } $sql = $db->query($sql); while (($a = $db->fetchByAssoc($sql)) != null) { //echo "<p>". $a["provname"] . "</p>"; if ($providers == "") { $providers = "'" . $a["provid"] . "'"; } else { $providers = "'" . $a["provid"] . "'," . $providers; } } //echo "list of providers: " . $providers; return $providers; }
function display() { $smarty = new Sugar_Smarty(); parent::display(); $db = DBManagerFactory::getInstance(); $restrict_query = ""; global $current_user; //var_dump(get_defined_vars()); //if(isset($current_user) AND $current_user->check_role_membership('WASSER_PATIENTS')) { echo "This user is in role"; $location_query = " AND location_c IN ('BMC_WALLEY') ";} //elseif (isset($current_user) AND $current_user->check_role_membership('ALL_PATIENTS')) { echo "Super user"; $location_query = " ";} //else { echo "This user is not in role"; $location_query = " AND location_c NOT IN ('BMC_WALLEY') ";} if (isset($current_user) and $current_user->check_role_membership('PRESCRIBER_ONLY')) { $provider = GetProviders(); //echo "GOT providers"; $restrict_query = " AND provpat.reg_provider_reg_patientreg_provider_ida IN (" . $provider . ") "; } if (isset($current_user) and $current_user->check_role_membership('MULTI_LOCATION')) { $location = GetLocations(); $restrict_query = " AND tab5.location_c IN ({$location}) "; } if (isset($current_user) and $current_user->check_role_membership('ALL_LOCATIONS')) { $restrict_query = " "; } echo "restrict is " . $restrict_query . "<<<<"; //$myquery = 'SELECT tab4.first_name fname, tab4.last_name lname, tab5.mrn_c mrn, tab4.id patid, tab5.location_c location, tab5.active_c active, ( SELECT tab1.reg_patient_reg_encounterreg_encounter_idb enclink FROM reg_patient_reg_encounter_c tab1 WHERE tab1.reg_patient_reg_encounterreg_patient_ida = patid AND tab1.date_modified = (SELECT max( date_modified ) dat FROM reg_patient_reg_encounter_c enc1 WHERE enc1.reg_patient_reg_encounterreg_patient_ida = patid) ) enclink, ( SELECT DATE_FORMAT(tab3.next_rx_refill_due_c,"%m/%d/%Y") ref1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) refill, ( SELECT DATE_FORMAT(tab3.last_uts_c,"%m/%d/%Y") uts1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) last_uts , ( SELECT DATE_FORMAT(tab3.next_uts_due_c,"%m/%d/%Y") uts11 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) uts , (SELECT DATE_FORMAT(tab3.next_pcp_visit_c,"%m/%d/%Y") pcp11 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) next_pcp, (SELECT p1b.name provname from reg_provider p1b, reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = patid) provname, ( SELECT risklvl_c risk1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) risk FROM reg_patient tab4, reg_patient_cstm tab5, reg_patient_reg_encounter_c tab1, ( SELECT max( date_modified ) dat, reg_patient_reg_encounterreg_patient_ida pat FROM reg_patient_reg_encounter_c GROUP BY reg_patient_reg_encounterreg_patient_ida) tab2, reg_encounter_cstm tab3 WHERE tab5.id_c = tab4.id AND tab1.date_modified = tab2.dat AND tab1.reg_patient_reg_encounterreg_patient_ida = tab2.pat AND tab3.id_c = tab1.reg_patient_reg_encounterreg_encounter_idb AND tab4.id = tab2.pat'; // <<<<<<< HEAD //02/25//$myquery = 'SELECT tab4.first_name fname, tab4.last_name lname, tab5.mrn_c mrn, tab4.id patid, tab5.location_c location, tab5.active_c active, ( SELECT tab1.reg_patient_reg_encounterreg_encounter_idb enclink FROM reg_patient_reg_encounter_c tab1 WHERE tab1.reg_patient_reg_encounterreg_patient_ida = patid AND tab1.date_modified = (SELECT max( date_modified ) dat FROM reg_patient_reg_encounter_c enc1 WHERE enc1.reg_patient_reg_encounterreg_patient_ida = patid) ) enclink, ( SELECT DATE_FORMAT(tab3.next_rx_refill_due_c,"%m/%d/%Y") ref1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) refill, ( SELECT DATE_FORMAT(tab3.last_uts_c,"%m/%d/%Y") uts1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) last_uts , ( SELECT DATE_FORMAT(tab3.next_uts_due_c,"%m/%d/%Y") uts11 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) uts , (SELECT DATE_FORMAT(tab3.next_pcp_visit_c,"%m/%d/%Y") pcp11 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) next_pcp, (SELECT p1b.name provname from reg_provider p1b, reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = patid AND p2b.deleted = 0) provname, ( SELECT risklvl_c risk1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) risk FROM reg_patient tab4, reg_patient_cstm tab5 WHERE tab5.id_c = tab4.id '; $myquery = 'SELECT tab4.first_name fname, tab4.last_name lname, DATE_FORMAT(tab4.dob,"%m/%d/%Y") dob, tab4.primary_address_postalcode zip, tab5.mrn_c mrn, tab5.audit_flag_c audit_flag, tab5.reg_patient_status_c status, tab4.id patid, tab5.location_c location, tab5.active_c active, DATE_FORMAT(tab5.pmp_date_c,"%m/%d/%Y") pmp_date, ( SELECT tab1.reg_patient_reg_encounterreg_encounter_idb enclink FROM reg_patient_reg_encounter_c tab1 WHERE tab1.reg_patient_reg_encounterreg_patient_ida = patid AND tab1.date_modified = (SELECT max( date_modified ) dat FROM reg_patient_reg_encounter_c enc1 WHERE enc1.reg_patient_reg_encounterreg_patient_ida = patid) LIMIT 1 ) enclink, ( SELECT DATE_FORMAT(tab3.next_rx_refill_due_c,"%m/%d/%Y") ref1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) refill, ( SELECT DATE_FORMAT(MAX(tabuts.test_date),"%m/%d/%Y") uts1 FROM reg_patient_uts_import tabuts where tabuts.patient_mrn = mrn ) last_uts, (SELECT p1b.name provname from reg_provider p1b, reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = patid AND p2b.deleted = 0) provname, ( SELECT finalscore from reg_patient_risk where pid = tab4.id LIMIT 1 ) risk FROM reg_patient tab4, reg_patient_cstm tab5, reg_provider_reg_patient_c provpat WHERE tab5.id_c = tab4.id AND provpat.reg_provider_reg_patientreg_patient_idb = tab4.id ' . $restrict_query; // ======= /* $myquery = 'SELECT tab4.first_name fname, tab4.last_name lname, tab5.mrn_c mrn, tab4.id patid, tab5.location_c location, tab5.active_c active, ( SELECT tab1.reg_patient_reg_encounterreg_encounter_idb enclink FROM reg_patient_reg_encounter_c tab1 WHERE tab1.reg_patient_reg_encounterreg_patient_ida = patid AND tab1.date_modified = (SELECT max( date_modified ) dat FROM reg_patient_reg_encounter_c enc1 WHERE enc1.reg_patient_reg_encounterreg_patient_ida = patid) ) enclink, ( SELECT DATE_FORMAT(tab3.next_rx_refill_due_c,"%m/%d/%Y") ref1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) refill, ( SELECT DATE_FORMAT(tab3.last_uts_c,"%m/%d/%Y") uts1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) last_uts , ( SELECT DATE_FORMAT(tab3.next_uts_due_c,"%m/%d/%Y") uts11 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) uts , (SELECT DATE_FORMAT(tab3.next_pcp_visit_c,"%m/%d/%Y") pcp11 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) next_pcp, (SELECT p1b.name provname from reg_provider p1b, reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = patid) provname, ( SELECT finalscore risk1 FROM reg_patient_risk where pid = patid ) risk FROM reg_patient tab4, reg_patient_cstm tab5 WHERE tab5.id_c = tab4.id '; */ // >>>>>>> 3097a71433de82fec730df252659026274347e46 $start = microtime(true); $result = $db->query($myquery); $mydata = null; while ($row = $db->fetchRow($result)) { $mydata[] = $row; } $smarty->assign("mydata", $mydata); $smarty->display($this->lv->tpl); printf("Total time cached query: %.6fs\n", microtime(true) - $start); }
if (isset($_GET['actid']) and isset($_GET['value'])) { $page = $_SERVER['PHP_SELF']; $page2 = $_SERVER["HTTP_REFERER"]; $sec = "1"; header("Refresh: {$sec}; url={$page2}"); $actID = $_GET['actid']; $value = $_GET['value']; $retour = LaunchActionOnOff($actID, $value, $address, $service_port); if ($retour != 0) { echo "ERROR :" . $retour . "<br><br>"; } } else { $page = $_SERVER['PHP_SELF']; $sec = "600"; header("Refresh: {$sec}; url={$page}"); $NHCLoc = GetLocations($address, $service_port); $NHCAct = GetActions($address, $service_port); include 'design.php'; headHTML(); echo '<section id="locations" class="wrapper alt style2">'; echo '<section id="allume"class="spotlight">'; echo '<div class="image"><img src="images/z0.jpg" alt="" /></div><div class="content">'; echo '<div class="box alt"> <div class="row center uniform 50%"> <div class="12u"><h2>allumé</h2></div>'; foreach ($NHCAct as $action) { if ($action['value1'] == 100 && $action['type'] == 1) { $v = ""; if ($action['type'] == 1 && $action['value1'] == 100) { $v = 0; } elseif ($action['type'] == 1 && $action['value1'] == 0) {