public function actionUser($username) { $userModel = User::model()->findByAttributes(array('username' => $username)); if (!$userModel) { throw new CHttpException(404, "Agent/user doesn't exists"); } /*get leads submitted by this user */ $leadModel = new MainLeadModel(); $leadModel->unsetAttributes(); $leadModel->user_id = $userModel->id; $dataprovider = $leadModel->search(); $this->render('user', compact('dataprovider', 'leadModel', 'userModel')); }
/** * @return array Returns array containing user and its submitted lead */ public function getReport() { $finalReport = []; /*get all agents*/ $agentsUsername = ["thomasgriffiths", "jamiemorris", "lukeperry", "Christhyers"]; foreach ($agentsUsername as $key => $currentUsername) { $userModel = User::model()->findByAttributes(array('username' => $currentUsername)); if ($userModel) { $criteria = new CDbCriteria(); $criteria->compare("user_id", $userModel->id); $count = MainLeadModel::model()->count($criteria); $finalReport[] = array($userModel, $count); } } return $finalReport; }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return MainLeadModel the loaded model * @throws CHttpException */ public function loadModel($id) { $model = MainLeadModel::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }