public function actionContractor() { if (!Yii::app()->user->isGuest) { if (Yii::app()->user->role == 'contractor') { $this->pageTitle = 'Handyman.com - Contractor Dashboard'; $this->cities = Cities::model()->findAll(array('order' => 'RAND()', 'limit' => 10)); $contractor_id = Yii::app()->user->getId(); $model = Contractors::model()->findByPk($contractor_id); $param['page'] = "dashboard"; $param['model'] = $model; $criteria = new CDbCriteria(); $criteria->condition = "to_id={$contractor_id} and to_user_type='contractor'"; $param['message_count'] = Messages::model()->count($criteria); $criteria2 = new CdbCriteria(); $criteria2->condition = "contractor_id = {$contractor_id}"; $param['views_count'] = ContractorViews::model()->count($criteria2); $oneWeekAgo = date("Y-m-d H:i:s", strtotime("-1 months")); $criteria3 = new CdbCriteria(); $criteria3->addBetweenCondition('date_added', $oneWeekAgo, date("Y-m-d H:i:s")); $param['latest_project_count'] = Projects::model()->count($criteria3); $param['from'] = $oneWeekAgo; $param['to'] = date("Y-m-d H:i:s"); $param['points'] = 0; $points = ContractorPoints::model()->findByAttributes(array('contractor_id' => $contractor_id)); if (count($points) > 0) { $param['points'] = $points->points; } $team_invites = ContractorTeam::model()->findbyAttributes(array('invited_id' => $contractor_id, 'confirmed' => 0)); $param['team_invites'] = $team_invites; $this->render('contractor', $param); } else { $this->redirect(Yii::app()->homeUrl); } } else { $this->redirect(Yii::app()->homeUrl); } }