下面是我的代码
SzCharacterModel
class SzCharacterModel extends RelationModel
{
public $_link = array(
'SzPhrase' => array(
'mapping_type' => MANY_TO_MANY,
'class_name' => 'SzPhrase',
'mapping_name' => 'Phrases',
'foreign_key' => 'cid',
'relation_foreign_key' => 'phraseId',
'relation_table' => 'sz_character_phrase'
)
);
}关联表的模型class SzPhraseModel extends RelationModel
{
protected $_map = array(
'id' => 'Id',
'text' => 'Text',
);
}查询代码 $characterModel = D( "SzCharacter" );
$todayMap[ "id" ] = array( 'in', $taskData[ "TodayTask" ] );
$todayTask = $characterModel->field( $GLOBALS[ 'fieldConfig' ][ 'sz_character' ] )->relation(true)->where( $todayMap )->select();
$taskData[ "TodayTask" ] = $todayTask; 最佳答案
