AccountUsers.php

Go to the documentation of this file.

<?php

class AccountUsers extends CActiveRecord
{
    const DEFAULT_ACCOUNT_TYPE = 'default';

    const DEFAULT_TEMP_ACCOUNT_TYPE = 'default_temp';

    public function tableName()
    {
        return 'account_users';
    }

    public function rules()
    {
        // NOTE: you should only define rules for those attributes that
        // will receive user inputs.
        return array(
            array('UserId, AccountTypeId', 'required'),
            array('UserId, AccountTypeId', 'length', 'max' => 20),
            // The following rule is used by search().
            // @todo Please remove those attributes that should not be searched.
            array('UserId, AccountTypeId', 'safe', 'on' => 'search'),
        );
    }

    public function relations()
    {
        // NOTE: you may need to adjust the relation name and the related
        // class name for the relations automatically generated below.
        return array(
            'AccountTypes' => array(self::BELONGS_TO, 'AccountTypes', 'AccountTypeId'),
            'User' => array(self::BELONGS_TO, 'User', 'UserId'),
        );
    }

    public function attributeLabels()
    {
        return array(
            'UserId' => 'User',
            'AccountTypeId' => 'Account Type',
        );
    }

    public function search()
    {
        // @todo Please modify the following code to remove attributes that should not be searched.

        $criteria = new CDbCriteria();

        $criteria->compare('UserId', $this->UserId, true);
        $criteria->compare('AccountTypeId', $this->AccountTypeId, true);

        return new CActiveDataProvider($this, array(
            'criteria' => $criteria,
        ));
    }

    public static function model($className = __CLASS__)
    {
        return parent::model($className);
    }

    public function setUserDefaultAccountType($userId, $defaultType = self::DEFAULT_ACCOUNT_TYPE)
    {
        if (empty($userId)) {
            return false;
        }

        return $this->setUserAccountType($userId, $defaultType);
    }

    public function setUserAccountType($userId, $accountType)
    {
        if (empty($userId) || empty($accountType)) {
            return false;
        }
        $AccountTypes = AccountTypes::model()->findByAttributes(array(
            'Type' => $accountType,
        ));
        if (empty($AccountTypes)) {
            return false;
        }
        
        $AccountUsers = AccountUsers::model()->findByPk($userId);
        if (empty($AccountUsers)) {
            $AccountUsers = new AccountUsers();
        }

        $AccountUsers->UserId = $userId;
        $AccountUsers->AccountTypeId = $AccountTypes->Id;

        return $AccountUsers->save();
    }

    public function setAllUsersDefaultAccountTypeByAccountTypeId($accountTypeId)
    {
        $AccountUsers = AccountUsers::model()->findAllByAttributes(array(
            'AccountTypeId' => $accountTypeId,
        ));
        foreach ($AccountUsers as $AccountUser) {
            VarDumper::dump($AccountUser->UserId);
            AccountUsers::model()->setUserDefaultAccountType($AccountUser->UserId);
        }
    }
}