function generate_worksheet_config($lab_config_id) { $lab_config = LabConfig::getById($lab_config_id); $test_ids = $lab_config->getTestTypeIds(); $saved_db = DbUtil::switchToLabConfig($lab_config_id); foreach ($test_ids as $test_id) { $test_entry = TestType::getById($test_id); $query_string = "SELECT * FROM report_config WHERE test_type_id={$test_id} LIMIT 1"; $record = query_associative_one($query_string); if ($record == null) { # Add new entry $query_string_add = "INSERT INTO report_config (" . "test_type_id, header, footer, margins, " . "p_fields, s_fields, t_fields, p_custom_fields, s_custom_fields " . ") VALUES (" . "'{$test_id}', 'Worksheet - " . $test_entry->name . "', '', '5,0,5,0', " . "'0,1,0,1,1,0,0', '0,0,1,1,0,0', '1,0,1,0,0,0,0,1', '', '' " . ")"; query_insert_one($query_string_add); } } DbUtil::switchRestore($saved_db); }
public function addToDb() { $infectionReportSettings = $this; $saved_db = DbUtil::switchToGlobal(); # Remove existing entry $query_string = "DELETE FROM infection_report_settings " . "WHERE user_id={$this->userId} " . "AND test_id={$this->testId} " . "AND measure_id={$this->measureId}"; query_blind($query_string); # Add updated entry $query_string = "INSERT INTO infection_report_settings( " . "id, " . "user_id, " . "test_id, " . "measure_id, " . "group_by_gender, " . "group_by_age, " . "age_groups, " . "measure_groups " . ") " . "VALUES ( " . "{$infectionReportSettings->id}, " . "{$infectionReportSettings->userId}, " . "{$infectionReportSettings->testId}, " . "{$infectionReportSettings->measureId}, " . "{$infectionReportSettings->groupByGender}, " . "{$infectionReportSettings->groupByAge}, " . "'{$infectionReportSettings->ageGroups}', " . "'{$infectionReportSettings->measureGroups}' " . ")"; query_insert_one($query_string); DbUtil::switchRestore($saved_db); }
<?php include "../includes/db_lib.php"; $userId = $_SESSION['user_id']; $testCategoryName = $_REQUEST['testCategoryName']; $labIdTestCategoryId = $_REQUEST['labIdTestCategoryId']; $saved_db = DbUtil::switchToGlobal(); $queryString = "SELECT MAX(test_category_id) AS test_category_id FROM test_category_mapping " . "WHERE user_id={$userId}"; $record = query_associative_one($queryString); $testCategoryId = intval($record['test_category_id']) + 1; $queryString = "INSERT INTO TEST_CATEGORY_MAPPING (user_id, test_category_name, lab_id_test_category_id, test_category_id) " . "VALUES (" . $userId . ",'" . $testCategoryName . "','" . $labIdTestCategoryId . "'," . $testCategoryId . ")"; query_insert_one($queryString) or die(mysql_error()); DbUtil::switchRestore($saved_db); echo "true";
<?php include "../includes/db_lib.php"; include "../includes/script_elems.php"; include "../includes/page_elems.php"; include "../includes/user_lib.php"; $equipment_id = $_REQUEST['equipment_id']; $equipment_name = $_REQUEST['equipment_name']; $equipment_version = $_REQUEST['equipment_version']; $lab_department = $_REQUEST['lab_department']; $comm_type = $_REQUEST['comm_type']; $feed_source = $_REQUEST['feed_source']; $config_file = $_REQUEST['config_file']; $prop_ids = $_REQUEST['prop_ids']; $propidarr = explode(",", $prop_ids); $prop_values = $_REQUEST['prop_values']; $propvaluesarr = explode(",", $prop_values); $saved_db = DbUtil::switchToGlobal(); $query_string = "update interfaced_equipment\r\n\tset equipment_name = '{$equipment_name}',\r\n\t\tequipment_version = '{$equipment_version}',\r\n\t\tlab_department = '{$lab_department}',\r\n\t\tcomm_type = '{$comm_type}',\r\n\t\tfeed_source = '{$feed_source}',\r\n\t\tconfig_file = '{$config_file}'\r\n\t\twhere id = {$equipment_id}"; query_insert_one($query_string); for ($i = 0; $i < count($propidarr); $i++) { $query_string = "update equip_config\r\n\tset prop_value = '{$propvaluesarr[$i]}'\r\n\twhere equip_id = {$equipment_id}\r\n\t\tand prop_id = {$propidarr[$i]}"; query_insert_one($query_string); } DbUtil::switchRestore($saved_db);
public function useStock($reagent_id, $lot, $quant, $u_date, $remarks) { $created_by = $_SESSION["user_id"]; $lab_config_id = $_SESSION["lab_config_id"]; $saved_db = DbUtil::switchToLabConfig($lab_config_id); $query_string = "INSERT INTO inv_usage (reagent_id, lot, quantity_used, date_of_use, user_id, remarks) " . "VALUES ({$reagent_id}, '{$lot}', {$quant}, '{$u_date}', {$created_by}, '{$remarks}')"; query_insert_one($query_string); DbUtil::switchRestore($saved_db); }
function add_patients_random($num_patients) { # Adds random patient entries global $MAX_NUM_PATIENTS, $NUM_PATIENTS; if ($num_patients > $MAX_NUM_PATIENTS) { $num_patients = $MAX_NUM_PATIENTS; } //$patient_sql_filename = "../data/patients.sql"; /* if(strpos($_SERVER['HTTP_REFERER'], "lab_config_home.php") !== false) { $patient_sql_filename = "../data/patients.sql"; } else { $patient_sql_filename = "../data/patients.sql"; } */ /*$patient_sql_file = fopen($patient_sql_filename, 'r'); $count = 0; while($count < $num_patients) { $sql = fgets($patient_sql_file); query_insert_one($sql); $count++; } */ $count = 1; $minDate = "1930-01-01"; $maxDate = "2011-01-01"; while ($count <= $num_patients) { $patientId = $count; $addl_id = $count + 5000; $surr_id = $count + 8500; $name = get_random_name(); $sex = get_random_gender(); $dob = get_random_date($minDate, $maxDate); $sql = "INSERT INTO `patient` (`patient_id`,`name`,`dob`,`sex`,`addl_id`,`surr_id`)" . "VALUES ({$patientId}, '{$name}' , '{$dob}' , '{$sex}', {$addl_id}, {$surr_id})"; query_insert_one($sql); $count++; } $NUM_PATIENTS = $num_patients; }