from utils import SocialChannelUtils
from google.appengine.ext.ndb import Key
from blinkfire.user import SocialChannelOwners
from generic.models.sport_model import *

club = Organization.get_by_id('oo_fnatic_14576061487')
teams = club.get_teams

for t in teams:
  try:
    print '<table><tbody>'
    print '<tr><td colspan="3" bgcolor="#DDDDDD"><strong>'
    print t.name
    print '</strong></td></tr>'
    team = t.key.get()
    for player in team.players:
      channels = SocialChannelUtils.entity_channels_as_dict(player)
      p = player.get()
      print '<tr><td colspan="3" bgcolor="#EEEEEE"><strong>{}</strong></td></tr>'.format(p.name)
      if all(type(channel) == int for channel in channels.values()):
        print '<tr><td colspan="3">NO CHANNELS</td></tr>'
        continue
      owners = SocialChannelOwners.channel_owners_from_dict(channels)
      for key, channel in channels.iteritems():
        if not channel:
          continue
        has_credentials = key in owners
        print "<tr><td>{}</td><td>{}</td><td>{}</td></tr>".format(channel.medium, channel.username, has_credentials)
      print "<tr><td></td></tr>"
      print "<tr><td></td></tr>"
    print "</tbody></table>"
    print "<br> <br>"
  except Exception as e:
    print e