from trytond.model import ModelView, ModelSQL, fields
from trytond.pool import Pool

__all__ = ['Player']


class Player(ModelSQL, ModelView):
    "Player"
    __name__ = "sports.player"
    name = fields.Char('Name')
    sex = fields.Selection([('m','Male'),('f','Female')],'Sex')
    team = fields.Function(fields.Many2One('sports.team','Team'),'get_team', searcher='search_team')

    def get_team(self, name):
        Transfer= Pool().get("sports.transfer")
        transfers = Transfer.search([('player','=',self.id)], order=[('id','DESC')])
        if transfers:
            return transfers[0].team_to.id
        else:
            return None
    @classmethod
    def search_team(cls, name, clause):
        return [('team.id',)+tuple(clause[1:])]