function get_discrete_value_test_types($lab_config) { # Returns test type IDs for tests that have explicit P/N results $saved_db = DbUtil::switchToLabConfigRevamp($lab_config->id); $retval = array(); $query_string = "SELECT DISTINCT test_type_id FROM test_type " . "WHERE test_type_id IN ( " . "SELECT test_type_id FROM lab_config_test_type " . "WHERE lab_config_id={$lab_config->id} " . " ) AND disabled=0"; $resultset = query_associative_all($query_string, $row_count); foreach ($resultset as $record) { $test_type_id = $record['test_type_id']; $query_string2 = "SELECT DISTINCT ttm.test_type_id FROM test_type_measure ttm " . "WHERE ttm.measure_id IN ( " . "SELECT measure_id FROM measure " . "WHERE ( " . "range LIKE '%/N%' OR range LIKE '%N/%' OR " . "range LIKE '%/negative%' OR range LIKE '%negative/%' OR " . "range LIKE '%/negatif%' OR range LIKE '%negatif/%' OR " . "range LIKE '%/négatif%' OR range LIKE '%négatif/%' " . " ) " . " ) " . "AND ttm.test_type_id={$test_type_id}"; $record2 = query_associative_one($query_string2); if ($record2 == null) { continue; } $retval[] = $record2['test_type_id']; } DbUtil::switchRestore($saved_db); return $retval; }
public static function getById($measure_id) { # Returns a test measure by ID $saved_db = DbUtil::switchToLabConfigRevamp(); if ($measure_id == null || $measure_id < 0) { return null; } $query_string = "SELECT * FROM global_measures WHERE measure_id={$measure_id} LIMIT 1"; $record = query_associative_one($query_string); DbUtil::switchRestore($saved_db); return GlobalMeasure::getObject($record); }
public function getSpecimenTypesCountryLevel() { # Returns specimen types available for aggregation $saved_db = DbUtil::switchToLabConfigRevamp(); $user_id = $_SESSION['user_id']; $query = "SELECT * FROM specimen_mapping where user_id =".$user_id; $resultset = query_associative_all($query, $count); if( count($resultset) > 0 ) { ?> <table class='hor-minimalist-b'> <tbody> <th>#</th> <?php echo "<th>".LangUtil::$generalTerms['NAME']."</th>"; foreach($resultset as $record) { echo "<tr><td>".$record['specimen_id']."</td><td>".$record['specimen_name']."</td></tr>"; } ?> </tbody> </table> <?php } else { echo "No Specimens Currently Added"; } DbUtil::switchRestore($saved_db); }
function remarks_db2xml($langdata_path, $lab_config_id) { # Creates XML file from existing test measures (indicators) in catalog global $VERSION; $new_version = $VERSION; $handle = fopen($langdata_path . "remarks.xml", "w"); $string_data = <<<EOF <?xml version="1.0"?> <measures version="{$new_version}"> EOF; fwrite($handle, $string_data); $saved_db = DbUtil::switchToLabConfigRevamp($lab_config_id); $query_string = "SELECT * FROM measure"; $resultset = query_associative_all($query_string, $row_count); foreach ($resultset as $record) { $curr_measure = Measure::getObject($record); $id = $curr_measure->measureId; $descr = $curr_measure->name; $string_data = <<<EOF \t<measure id="{$id}" descr="{$descr}"> EOF; fwrite($handle, $string_data); $range_type = $curr_measure->getRangeType(); $range_values = $curr_measure->getRangeValues(); if ($range_type == Measure::$RANGE_NUMERIC) { $lower_bound = htmlspecialchars($range_values[0]); $upper_bound = htmlspecialchars($range_values[1]); $string_data = <<<EOF \t\t<range> \t\t\t<key>{$range_values['0']}:{$range_values['1']}</key> \t\t\t<value></value> \t\t</range> EOF; fwrite($handle, $string_data); } else { if ($range_type == Measure::$RANGE_OPTIONS) { foreach ($range_values as $range_value) { $range_value_xml = htmlspecialchars($range_value); $string_data = <<<EOF \t\t<range> \t\t\t<key>{$range_value_xml}</key> \t\t\t<value></value> \t\t</range> EOF; fwrite($handle, $string_data); } } } $string_data = <<<EOF \t</measure> EOF; fwrite($handle, $string_data); } $string_data = <<<EOF </measures> EOF; fwrite($handle, $string_data); fclose($handle); DbUtil::switchRestore($saved_db); }
"AND t.result <> ''"; $test_records = query_associative_all($query_tests, $test_count); foreach($test_records as $test_record) { $test_entry = Test::getObject($test_record); $result_value = $test_entry->result.$patient_hash; $query_update = "UPDATE test SET result='$result_value' ". "WHERE test_id=$test_entry->testId"; query_update($query_update); } }*/ $saved_db = DbUtil::switchToLabConfigRevamp(127); $query_string = "ALTER TABLE `blis_revamp_127`.`measure` CHANGE COLUMN `range` `range` VARCHAR(1000) NOT NULL"; mysql_query($query_string); DbUtil::switchRestore($saved_db); $saved_db = DbUtil::switchToLabConfigRevamp(128); $query_string = "ALTER TABLE `blis_revamp_128`.`measure` CHANGE COLUMN `range` `range` VARCHAR(1000) NOT NULL"; mysql_query($query_string); DbUtil::switchRestore($saved_db); $saved_db = DbUtil::switchToLabConfigRevamp(129); $query_string = "ALTER TABLE `blis_revamp_129`.`measure` CHANGE COLUMN `range` `range` VARCHAR(1000) NOT NULL"; mysql_query($query_string); DbUtil::switchRestore($saved_db); $saved_db = DbUtil::switchToLabConfigRevamp(131); $query_string = "ALTER TABLE `blis_revamp_131`.`measure` CHANGE COLUMN `range` `range` VARCHAR(1000) NOT NULL"; mysql_query($query_string); DbUtil::switchRestore($saved_db); # Delete update.txt unlink($update_txt); $_SESSION['no_updates'] = 1;