<?php include "redirect.php"; include "../includes/db_lib.php"; /* echo "<pre>"; print_r($_POST); echo "</pre>"; */ putUILog('ret_tests', 'X', basename($_SERVER['REQUEST_URI'], ".php"), 'X', 'X', 'X'); $lid = $_SESSION['lab_config_id']; $sp = $_POST['specs']; $count = count($sp); for ($i = 0; $i < $count; $i++) { if (isset($_POST['category'])) { retrieve_specimens($lid, $sp[$i], $remarks[$i], $_POST['category']); retrieve_deleted_items($lid, $sp[$i], $_POST['category']); } else { retrieve_specimens($lid, $sp[$i]); retrieve_deleted_items($lid, $sp[$i]); } } /* if(isset($_POST['category'])){ echo $_POST['category']; } */ $url = "Location:../" . $_POST['url']; header($url);
<?php # # Deletes a patient profile from DB # Called via Ajax from lab_user_new.php # include "../includes/db_lib.php"; include "../includes/script_elems.php"; include "../includes/page_elems.php"; include "../includes/user_lib.php"; $item_id = $_REQUEST['item_id']; if (isset($_REQUEST['ret_cat'])) { $category = $_REQUEST['ret_cat']; } else { $category = "test"; } //$lab_config = LabConfig::getById($_SESSION['lab_config_id']); $lab_config = $_SESSION['lab_config_id']; $isSuccess = 0; //echo "Params ".$test_id." Test ".$test->testId; if (retrieve_deleted_items($lab_config, $item_id, $category)) { $isSuccess = 1; } echo $isSuccess;
function retrieve_deleted_items($lid, $sp, $category = "test") { $lab_config_id = $lid; $saved_db = DbUtil::switchToLabConfig($lab_config_id); if ($category == "patient") { $specimen_list = get_specimens_by_patient_id($sp); if (sizeof($specimen_list) > 0) { foreach ($specimen_list as $specimen) { retrieve_deleted_items($lid, $specimen->specimenId, "specimen"); } } } else { if ($category == "specimen") { $testsList = get_tests_by_specimen_id($sp); if (sizeof($testsList) > 0) { foreach ($testsList as $test) { retrieve_deleted_items($lid, $test->testId); } } } } $query_string = "UPDATE removal_record SET status = 0 WHERE r_id = {$sp} AND category='{$category}' AND status = 1 AND type = 1"; //."<br/>"; query_update($query_string); DbUtil::switchRestore($saved_db); return 1; }