Hi! It’s my beginning with AR and Yii. My ‘user’ table has such structure:
CREATE TABLE `user` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uid` VARCHAR(16) NOT NULL, ... `superior_uid` VARCHAR(16) NULL DEFAULT NULL, ... UNIQUE INDEX `uid` (`uid`), ... CONSTRAINT `FK_user_user` FOREIGN KEY (`superior_uid`) REFERENCES `user` (`uid`) ON UPDATE CASCADE ON DELETE SET NULL, )
relations in model:
'superior' => array(self::BELONGS_TO, 'User', 'superior_uid'), 'subordinates' => array(self::HAS_MANY, 'User', 'superior_uid'),
I’ve been sarching many forums for a few days and didn’t find statisfied solution. I need to do two things:
Find all children for UID and it’s relation level.
Compare two UIDs and check if they have parent<->children relation (on any level, not just straight).
Can you help, please?