$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(); //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;