class NotificationServiceImpl implements NotificationService,Constants {

	@Override
	public List<Map<String,Object>> getAllAssetGroupOwnerEmailDetails() {
		String query = "SELECT displayName AS ownerName, groupName AS assetGroup, ownerEmailId AS ownerEmail FROM cf_AssetGroupDetails LEFT JOIN cf_AssetGroupOwnerDetails ON (groupName = assetGroupName) WHERE groupType = 'Director' AND ownerEmailId NOT IN (SELECT emailId FROM PacmanSubscriptions WHERE subscriptionValue=0) GROUP BY groupName";
		return jdbcTemplate.queryForList(query); 
	}

}