问yii网桥表中具有类型列的多对多CDbCriteria

EN

Table AgentType:
agent_type_id
agent_type_name

Table Agent:
agent_id
agent_name

Table Talent:
talent_id
talent_name

Table TalentAgent:
talent_id
agent_id
agent_type_id

Table AgentType
agent_id
agent_type_id

public function relations() {
    return array(
       'talent_agent' => array(self::HAS_MANY, 'TalentAgent', 'talent_id'),
       'agent' => array(self::HAS_MANY, 'Agent', 'agent_id', 'through' => 'talent_agent'),
       'agents' => array(self::MANY_MANY, 'Agent', 'nca_talent_agent(talent_id,agent_id)'),
    );
}

public function relations()
{
    return array(
        'talent_agent' => array(self::HAS_MANY, 'TalentAgent', 'agent_id'),
        'talent' => array(self::HAS_MANY, 'Talent', 'talent_id', 'through' => 'talent_agent'),
        'agent_type' => array(self::MANY_MANY, 'AgentType', 'nca_agent_agent_type(agent_id,agent_type_id)'),
    );
}

public function relations()
{
    return array(
        'talent' => array(self::MANY_MANY, 'Talent', 'nca_talent_agent(talent_id,agent_id,agent_type_id)'),
        'agent' => array(self::MANY_MANY, 'Agent', 'nca_agent_agent_type(agent_id,agent_type_id)'),
    );
}

public function relations()
{
    return array(
        'talent' => array(self::BELONGS_TO, 'Talent', 'talent_id'),
        'agent' => array(self::BELONGS_TO, 'Agent', 'agent_id'),
        'agent_type' => array(self::BELONGS_TO, 'AgentType', 'agent_type_id'),
    );
}

array(
    'name'=>'agent_primary',
    'value'=>'$data->getPrimaryAgent($data->talent_id, false)',
    'filter'=>CHtml::activeDropDownList($model, 'agent_primary', CHtml::listData(Agent::model()->with('agent_type')->findAll(array('condition'=>'agent_type.agent_type_id = 1')),'agent_id', 'name')),
),
array(
    'name'=>'agent_voice',
    'value'=>'$data->getVoiceAgent($data->talent_id, false)',
    'filter'=>CHtml::activeDropDownList($model, 'agent_voice', CHtml::listData(Agent::model()->with('agent_type')->findAll(array('condition'=>'agent_type.agent_type_id = 2')),'agent_id', 'name')),
),
array(
    'name'=>'agent_commercial',
    'value'=>'$data->getCommercialAgent($data->talent_id, false)',
    'filter'=>CHtml::activeDropDownList($model, 'agent_commercial', CHtml::listData(Agent::model()->with('agent_type')->findAll(array('condition'=>'agent_type.agent_type_id = 3')),'agent_id', 'name')),
),

$criteria=new CDbCriteria;
$criteria->with = array('agent');
$criteria->together = true;
$criteria->compare('agent.agent_id',$this->agent_primary);