CAllFormResult::GetDataByIDForHTML

static function GetDataByIDForHTML($RESULT_ID, $GET_ADDITIONAL="N")
{
	$err_mess = (CAllFormResult::err_mess())."
Function: GetDataByIDForHTML
Line: ";
	global $DB, $strError;
	$z = CFormResult::GetByID($RESULT_ID);
	if ($zr=$z->Fetch())
	{
		$arrResult = $zr;
		$additional = ($GET_ADDITIONAL=="Y") ? "ALL" : "N";

		$WEB_FORM_ID = CForm::GetDataByID($arrResult["FORM_ID"], $arForm, $arQuestions, $arAnswers, $arDropDown, $arMultiSelect, $additional);

		CForm::GetResultAnswerArray($WEB_FORM_ID, $arrResultColumns, $arrResultAnswers, $arrResultAnswersSID, array("RESULT_ID" => $RESULT_ID));
		$arrResultAnswers = $arrResultAnswers[$RESULT_ID];

		$DB_VARS = array();
		foreach ($arQuestions as $key => $arQuestion)
		{
			if ($arQuestion["ADDITIONAL"]!="Y")
			{
				$FIELD_SID = $arQuestion["SID"];
				if (is_array($arAnswers[$FIELD_SID]))
				{
					foreach ($arAnswers[$FIELD_SID] as $key => $arAnswer)
					{
						$arrResultAnswer = $arrResultAnswers[$arQuestion["ID"]][$arAnswer["ID"]];
						$FIELD_TYPE = $arAnswer["FIELD_TYPE"];
						switch ($FIELD_TYPE) :

							case "radio":
							case "dropdown":
								if (intval($arrResultAnswer["ANSWER_ID"])>0)
								{
									$fname = "form_".mb_strtolower($FIELD_TYPE)."_".$FIELD_SID;
									$DB_VARS[$fname] = $arrResultAnswer["ANSWER_ID"];
								}
							break;

							case "checkbox":
							case "multiselect":
								if (intval($arrResultAnswer["ANSWER_ID"])>0)
								{
									$fname = "form_".mb_strtolower($FIELD_TYPE)."_".$FIELD_SID;
									$DB_VARS[$fname][] = $arrResultAnswer["ANSWER_ID"];
								}
							break;

							case "date":
								if ($arrResultAnswer["USER_DATE"] <> '')
								{
									$arrResultAnswer["USER_TEXT"] = $DB->FormatDate(
										$arrResultAnswer["USER_DATE"],
										FORMAT_DATETIME,
										(MakeTimeStamp($arrResultAnswer["USER_TEXT"])+date('Z'))%86400 == 0 ? FORMAT_DATE : FORMAT_DATETIME
									);

									$fname = "form_".mb_strtolower($FIELD_TYPE)."_".$arAnswer["ID"];
									$DB_VARS[$fname] = $arrResultAnswer["USER_TEXT"];
								}

								break;

							case "text":
							case "password":
							case "textarea":
							case "email":
							case "url":
							case "hidden":
								if ($arrResultAnswer["USER_TEXT"] <> '')
								{
									$fname = "form_".mb_strtolower($FIELD_TYPE)."_".$arAnswer["ID"];
									$DB_VARS[$fname] = $arrResultAnswer["USER_TEXT"];
								}
							break;

							case "image":
							case "file":
								if (intval($arrResultAnswer["USER_FILE_ID"])>0)
								{
									$fname = "form_".mb_strtolower($FIELD_TYPE)."_".$arAnswer["ID"];
									$DB_VARS[$fname] = $arrResultAnswer["USER_FILE_ID"];
								}
							break;

						endswitch;
					} //endforeach;
				}
			}
			else
			{
				$FIELD_TYPE = $arQuestion["FIELD_TYPE"];
				$arrResultAnswer = $arrResultAnswers[$arQuestion["ID"]][0];
				switch ($FIELD_TYPE) :
					case "text":
						if ($arrResultAnswer["USER_TEXT"] <> '')
						{
							$fname = "form_textarea_ADDITIONAL_".$arQuestion["ID"];
							$DB_VARS[$fname] = $arrResultAnswer["USER_TEXT"];
						}
						break;
					case "integer":
						if ($arrResultAnswer["USER_TEXT"] <> '')
						{
							$fname = "form_text_ADDITIONAL_".$arQuestion["ID"];
							$DB_VARS[$fname] = $arrResultAnswer["USER_TEXT"];
						}
						break;
					case "date":
						$fname = "form_date_ADDITIONAL_".$arQuestion["ID"];
						$DB_VARS[$fname] = $arrResultAnswer["USER_TEXT"];
						break;
				endswitch;
			}
		}//endforeach
		return $DB_VARS;
	}
}