/** * @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; }