DealIdle::prepareInvoiceQuery

static function prepareInvoiceQuery($startDate, $endDate, $ownerFieldReference = '%s', $postfix = '')
{
	$query = new Query(DealInvoiceStatisticsTable::getEntity());
	if($postfix !== '')
	{
		$query->setTableAliasPostfix($postfix);
	}
	$query->addFilter('=IS_LOST', false);
	$query->addFilter('>=CREATED_DATE', $startDate);
	$query->addFilter('<=CREATED_DATE', $endDate);
	$query->addFilter('=OWNER_ID', new SqlExpression($ownerFieldReference));
	if(!(Main\Application::getConnection() instanceof Main\DB\OracleConnection))
	{
		$query->setLimit(1);
	}

	return $query;
}