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;
