$diag_obj->setDataArray($data); if ($diag_obj->insertDataFromInternalArray()) { //gjergji : new lab handlign code //sub values management $batch_nr = $db->Insert_ID(); $diag_obj_sub->useChemLabRequestSubTable(); $singleParam = explode("&", $paramlist); foreach ($singleParam as $key => $value) { $tmpParam = explode("=", $value); $parsedParamList['batch_nr'] = $batch_nr; $parsedParamList['encounter_nr'] = $pn; $parsedParamList['item_id'] = $pres_obj->GetItemIDByNumber($diag_obj->getItemNrByParamID($tmpParam[0])); $parsedParamList['paramater_name'] = $tmpParam[0]; $parsedParamList['parameter_value'] = $tmpParam[1]; $parsedParamList['status'] = 'pending'; $diag_obj_sub->setDataArray($parsedParamList); //echo 'Name: '.$tmpParam[0]; //echo $diag_obj_sub->getLastQuery(); $diag_obj_sub->insertDataFromInternalArray(); //echo 'z'.$diag_obj->getItemNrByParamName($tmpParam[0]).'z'; $item_id = $pres_obj->GetItemIDByNumber($diag_obj->getItemNrByParamName($tmpParam[0])); $diag_obj->setItemID($item_id, $batch_nr); //TODO : check if it works - gjergji // Get for each lab-request-id the item_id of this lab-test out of drugsandservices-table //$item_id = $drg_obj->GetItemIDByNumber('LAB'.$value); // TODO: Set here the function to store it as bill - element -> drug_class='lab' //$prescription_obj->insert_prescription($pn,$item_id); //new code: $sqlInner1 = "SELECT * from care_tz_laboratory_param WHERE id='" . $parsedParamList['paramater_name'] . "'"; $resultInner1 = $db->Execute($sqlInner1); $row1 = $resultInner1->FetchRow();
// end of case 'save' case 'update': if (prepareTestElements()) { //echo $sql; $data['room_nr'] = $room_nr; $data['dept_nr'] = $dept_nr; $data['parameters'] = $paramlist; $data['doctor_sign'] = $doctor_sign; $data['highrisk'] = $_highrisk_; $data['notes'] = $notes; $data['sample_time'] = $sample_time; $data['sample_weekday'] = $sday; $data['status'] = $status; $data['history'] = "CONCAT(history,'Update: " . date('Y-m-d H:i:s') . " = " . $_SESSION['sess_user_name'] . "\n')"; $data['modify_id'] = $_SESSION['sess_user_name']; $diag_obj->setDataArray($data); $diag_obj->setWhereCond(" batch_nr={$batch_nr}"); if ($diag_obj->updateDataFromInternalArray($batch_nr)) { // Load the visual signalling functions include_once $root_path . 'include/inc_visual_signalling_fx.php'; // Set the visual signal setEventSignalColor($pn, SIGNAL_COLOR_DIAGNOSTICS_REQUEST); header("location:" . $root_path . "modules/laboratory/labor_test_request_aftersave.php" . URL_REDIRECT_APPEND . "&edit={$edit}&saved=update&pn={$pn}&station={$station}&user_origin={$user_origin}&status={$status}&target=chemlabor&batch_nr={$batch_nr}&noresize={$noresize}"); exit; } else { echo "Woops: <p>{$sql}<p>{$LDDbNoSave}"; $mode = ""; } } //end of prepareTestElements() break;