public function getTotalBalance() { $group = $this->getDefaultTrackingGroup(Yii::app()->user->trackingGroupID); $groupMembers = $this->getTrackingGroupMembers($group->trackingGroupID); foreach ($groupMembers as $member) { $character = Characters::Model()->findByPk($member->characterID); if ($character->displayBalance) { $criteria = new CDbCriteria(); $criteria->condition = 'characterID = :characterID'; $criteria->order = 'balanceDateTime DESC'; $criteria->params = array(':characterID' => $character->characterID); $balanceRow = Balances::Model()->find($criteria); $balance = $balance + $balanceRow->balance; } } return $balance; }