public function getClientCompanies(){
         if($this->_aUserCompanies === FALSE){
            //$this->_aUserCompanies = CcucUserCompany::model()->getUserCompnies(Yii::app()->getModule('user')->user()->id,$this->ccuc_status);
                 $sql = "
                        SELECT DISTINCT
                          ccmp_id,
                          ccmp_name 
                        FROM
                          ccuc_user_company 
                          INNER JOIN ccmp_company 
                            ON ccmp_id = ccuc_ccmp_id 
                        WHERE ccuc_person_id = ".Yii::app()->getModule('user')->user()->profile->person_id."
                          AND ccuc_status = '".$this->ccuc_status."' 
                        ORDER BY 
                          ccmp_name 
                    ";
            $this->_aUserCompanies = Yii::app()->db->createCommand($sql)->queryAll();            
         }
         return $this->_aUserCompanies;
     }