How to delete Model Condition?

136 Views Asked by At

I wrote a function which is supposed to return an array of clubs for userId. I don't know why by when I add where(Model_ClubUsers::$USERS_ID,$userId) to dsql() it doesn't set the condition and I have to use addCondition(), but I need it only in this function. Is there a way to delete the condition before function returns?

function getUserClubs($userId){
    $columns = array('id',self::$NAME,self::$LOGO_NAME,self::$DESC);
    $this->addRelatedEntity('club_users', 'club_users', Model_ClubUsers::$CLUBS_ID, 'inner', 'related');
    $this->addField(Model_ClubUsers::$USERS_ID)->relEntity('club_users');
    $aAliasedColumns = $this->getAliasedColumns($columns, $this->entity_code);
    $this->addCondition(Model_ClubUsers::$USERS_ID,$userId);
    $rows = $this->dsql()->field($aAliasedColumns)->do_getAll();
    $aResult = array() ;
    foreach($rows as $key => $value){
        foreach($value as $vKey => $vVal){
            if($columns[$vKey]=='id'){
                $aRow['key'] = $vVal;
            }else if($columns[$vKey]==self::$LOGO_NAME){
                $aRow[$columns[$vKey]] = self::$CLUBS_LOGO_PATH.$vVal;
            }
            else {
                $aRow[$columns[$vKey]] = $vVal;
            }
        }
        $aResult[] = $aRow;
    }
    return $aResult;
}
1

There are 1 best solutions below

0
On

Please upgrade to 4.2 where the problem is no longer present:

$x=clone $this;
$x->addCondition();

also your syntax can be probably improved with the new 4.2 features.