CTimeManReportFull::GetList

static function GetList($arOrder = array(), $arFilter = array(),$arSelect = array(),$arNavStartParams = Array())
{
	global $DB;

	$arFields = array(
		"ID" => array("FIELD_NAME" => "R.ID", "FIELD_TYPE" => "int"),
		"TIMESTAMP_X" => array("FIELD_NAME" => "R.TIMESTAMP_X", "FIELD_TYPE" => "datetime"),
		"ACTIVE" => array("FIELD_NAME" => "R.ACTIVE", "FIELD_TYPE" => "string"),
		"USER_ID" => array("FIELD_NAME" => "R.USER_ID", "FIELD_TYPE" => "int"),
		"USER_GENDER" => array("FIELD_NAME" => "U.PERSONAL_GENDER", "TYPE" => "string", "FROM" => "LEFT JOIN b_user U ON (R.USER_ID = U.ID)"),
		"REPORT_DATE" => array("FIELD_NAME" => "R.REPORT_DATE", "FIELD_TYPE" => "datetime"),
		"DATE_TO" => array("FIELD_NAME" => "R.DATE_TO", "FIELD_TYPE" => "date"),
		"DATE_FROM" => array("FIELD_NAME" => "R.DATE_FROM", "FIELD_TYPE" => "date"),
		"TASKS" => array("FIELD_NAME" => "R.TASKS", "FIELD_TYPE" => "string"),
		"EVENTS" => array("FIELD_NAME" => "R.EVENTS", "FIELD_TYPE" => "string"),
		"REPORT" => array("FIELD_NAME" => "R.REPORT", "TYPE" => "string"),
		"PLANS" => array("FIELD_NAME" => "R.PLANS", "TYPE" => "string"),
		"MARK" => array("FIELD_NAME" => "R.MARK", "FIELD_TYPE" => "string"),
		"APPROVE" => array("FIELD_NAME" => "R.APPROVE", "FIELD_TYPE" => "string"),
		"APPROVE_DATE" => array("FIELD_NAME" => "R.APPROVE_DATE", "FIELD_TYPE" => "datetime"),
		"APPROVER" => array("FIELD_NAME" => "R.APPROVER", "FIELD_TYPE" => "int"),
		"FORUM_TOPIC_ID" => array("FIELD_NAME" => "R.FORUM_TOPIC_ID", "FIELD_TYPE" => "int"),
		"FILES" => array("FIELD_NAME" => "R.FILES", "FIELD_TYPE" => "string"),
	);
	$arSqls = self::PrepareSql($arFields, $arOrder, $arFilter, $arSelect, $arNavStartParams);

	$strSql = "SELECT ".$arSqls["SELECT"]."
	FROM b_timeman_report_full R ".
	"	".$arSqls["FROM"]." ".
	($arSqls["WHERE"] == '' ? "" : "WHERE ".$arSqls["WHERE"]).
	($arSqls["ORDERBY"] == '' ? "" : " ORDER BY ".$arSqls["ORDERBY"]).
	($arSqls["LIMIT"] <> ''?" ".$arSqls["LIMIT"]:"");

	$res = $DB->Query($strSql, false, "FILE: ".__FILE__."
 LINE: ".__LINE__);

	return $res;
}