CTasksReportHelper::getPeriodFilter

static function getPeriodFilter($date_from, $date_to)
{
	$filter = array('LOGIC' => 'AND');

	if (!is_null($date_from) && !is_null($date_to))
	{
		$filter[] = array(
			'LOGIC' => 'OR',
			array(
				'LOGIC' => 'AND',
				'>=CREATED_DATE' => $date_from,
				'<=CREATED_DATE' => $date_to
			),
			array(
				'LOGIC' => 'AND',
				'>=CLOSED_DATE' => $date_from,
				'<=CLOSED_DATE' => $date_to
			),
			array(
				'LOGIC' => 'AND',
				' $date_from,
				array(
					'LOGIC' => 'OR',
					'>CLOSED_DATE' => $date_to,
					'=CLOSED_DATE' => ''
				)
			)
		);
	}
	else if (!is_null($date_from))
	{
		$filter[] = array(
			'LOGIC' => 'OR',
			'>=CREATED_DATE' => $date_from,
			'>=CLOSED_DATE' => $date_from,
			'=CLOSED_DATE' => ''
		);
	}
	else if (!is_null($date_to))
	{
		$filter[] = array(
			'LOGIC' => 'OR',
			'<=CREATED_DATE' => $date_to,
			'<=CLOSED_DATE' => $date_to
		);
	}

	return $filter;
}