/** * This is the default 'index' action that is invoked * when an action is not explicitly requested by users. */ public function actionIndex() { $gridDataProvider = new CArrayDataProvider(array(), array('keyField' => 'id', 'id' => "id")); $gridDataProvider->pagination = false; $chartDataProvider = array(); $totalRevenue = number_format(0, 2); $cc001 = LiveRevD::getValue("cc001"); $cc002 = LiveRevD::getValue("cc002"); if (isset($_GET['searchListId'])) { /*check if user is allow to check this listid */ $_GET['searchListId'] = intval($_GET['searchListId']); $listId = ListId::model()->findByAttributes(array("list_id_value" => $_GET['searchListId'])); if (!$listId) { throw new CHttpException(404, "This list doesn't exists"); } $isAllowed = AssignedAllowedListId::model()->findByAttributes(array("list_id" => $listId->id, "user_id" => Yii::app()->user->id)); //test 1242015 if (!$isAllowed) { throw new CHttpException(403, "You are not allowed to search this list"); } /*search and return leads and reports*/ $fetcher = new LeadDataFetcher(); $leadDataCollection = $fetcher->getDataFromDialer($_GET['searchListId']); $startingDate = null; /*get starting date log using user_id*/ $criteria = new CDbCriteria(); $criteria->compare("user_id", Yii::app()->user->id); $criteria->order = "id DESC"; $startingDateMdl = StartingDateRevenueLog::model()->find($criteria); /* if cant find any use date starting from 10 years ago*/ if (!$startingDateMdl) { $startingDate = "2000-01-01"; } else { $startingDate = date("Y-m-d", strtotime($startingDateMdl->revert_date)); } $totalRevenue = sprintf("%2.2f", $fetcher->getTotalRevenue($_GET['searchListId'], $startingDate)); $leadRows = array(); foreach ($leadDataCollection as $key => $value) { /* @var $value LeadData*/ $leadRows[] = array('id' => $key, 'status' => $value->getLeadStatus(), 'lead' => $value->getLeadValue()); $chartDataProvider[] = array("name" => $value->getLeadStatus(), "y" => $value->getLeadValue()); } //re initialize value $gridDataProvider = new CArrayDataProvider($leadRows, array('keyField' => 'id', 'id' => "id")); $gridDataProvider->pagination = false; } $gridDataProvider->pagination = false; $this->render('index', compact('gridDataProvider', 'chartDataProvider', 'totalRevenue', 'cc001', 'cc002')); }
public function actionUndo($username) { /*get user model by username*/ $userModel = User::model()->findByAttributes(array('username' => $username)); if (!$userModel) { throw new CHttpException(404, "User doesn't exists"); } else { /*get the log from startingdaterevenue table and delete*/ $criteria = new CDbCriteria(); $criteria->compare("user_id", $userModel->id); $criteria->order = "user_id DESC"; $model = StartingDateRevenueLog::model()->find($criteria); if ($model) { $model->delete(); } Yii::app()->user->setFlash("success", "<strong>Success : </strong> Past action has been nullified."); $this->redirect(array('/manageUser')); } }
/** * 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 StartingDateRevenueLog the loaded model * @throws CHttpException */ public function loadModel($id) { $model = StartingDateRevenueLog::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }