$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;
$row2 = $resultInner2->FetchRow();
