WaitEntry::getRecentInfos

static function getRecentInfos($ownerTypeID, array $ownerIDs)
{
	$ownerStr = implode(',', $ownerIDs);
	$dbResult = Main\Application::getConnection()->query(
		"SELECT w1.ID, w1.OWNER_TYPE_ID, w1.OWNER_ID, w1.END_TIME FROM b_crm_wait w1 INNER JOIN (SELECT OWNER_ID, MAX(ID) ID FROM b_crm_wait WHERE OWNER_TYPE_ID = {$ownerTypeID} AND OWNER_ID IN ({$ownerStr}) and COMPLETED = 'N' GROUP BY OWNER_ID) w2 ON w1.ID = w2.ID"
	);

	$format = preg_replace('/:s$/', '', DateTime::getFormat());

	$results = array();
	while($fields = $dbResult->fetch())
	{
		$results[] = array(
			'ID' => $fields['ID'],
			'OWNER_TYPE_ID' => $fields['OWNER_TYPE_ID'],
			'OWNER_ID' => $fields['OWNER_ID'],
			'TITLE' => Loc::getMessage(
				'CRM_WAIT_INFO_TITLE',
				array('#END_TIME#' => isset($fields['END_TIME']) ? $fields['END_TIME']->format($format) : '-')
			)
		);
	}
	return $results;
}