// 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(); //echo 'id='.$row1['id']; $testname = str_replace("'", "\\'", $row1['name']); $sqlInner2 = "SELECT * from care_tz_laboratory_tests WHERE name='" . $testname . "'"; $resultInner2 = $db->Execute($sqlInner2); //echo $resultInner; $row2 = $resultInner2->FetchRow(); $pre_item_id = $row2['id']; $item_id = 'LAB' . $pre_item_id; $pres_obj = new Prescription(); $pres_obj->insert_prescription($pn, $item_id, 1); // echo 'x'.$item_id.'x'; while (list($u, $v) = each($param_array)) { // Get for each lab-request-id the item_id of this lab-test out of drugsandservices-table $item_id = $prescription_obj->GetItemIDByNumber('LAB' . $v); // TODO: Set here the function to store it as bill - element -> drug_class='lab' $prescription_obj->insert_prescription($pn, $item_id); } } // end of while (list($u,$v) = each ($param_array)) // 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); //print_r($data); //echo "The breakfile is :".$breakfile;