/** * Lists all models. */ public function actionIndex() { $pageSize = CommonService::getPageSize(); $criteria = new CDbCriteria(); $name = ''; if (isset($_GET['name'])) { $name = $_GET['name']; $criteria->addSearchCondition('option_name', $name); } $dataProvider = new CActiveDataProvider('TestOption', array('criteria' => $criteria, 'sort' => array('defaultOrder' => array('id' => true)), 'pagination' => array('pageSize' => $pageSize))); $this->render('index', array('dataProvider' => $dataProvider, 'name' => $name)); }
/** * Lists all models. */ public function actionIndex() { $pageSize = CommonService::getPageSize(); $criteria = new CDbCriteria(); $name = ''; if (isset($_GET['name'])) { $name = $_GET['name']; $userArr = TestUserService::getUserList($name, 'id'); $criteria->addInCondition('created_by', array_keys($userArr)); $criteria->addSearchCondition('ip', $name, true, 'OR'); } $dataProvider = new CActiveDataProvider('UserLog', array('criteria' => $criteria, 'sort' => array('defaultOrder' => array('id' => true)), 'pagination' => array('pageSize' => $pageSize))); $this->render('index', array('dataProvider' => $dataProvider, 'name' => $name)); }
/** * Lists all models. */ public function actionIndex() { $pageSize = CommonService::getPageSize(); $criteria = new CDbCriteria(); if (CommonService::$TrueFalseStatus['FALSE'] == Yii::app()->user->getState('system_admin')) { $managedgroups = UserGroupService::getManagedGroup(Yii::app()->user->id); $criteria->addInCondition('id', $managedgroups); } $name = ''; if (isset($_GET['name'])) { $name = $_GET['name']; $criteria->addSearchCondition('name', $name); } $dataProvider = new CActiveDataProvider('UserGroup', array('criteria' => $criteria, 'sort' => array('defaultOrder' => array('id' => true)), 'pagination' => array('pageSize' => $pageSize))); $this->render('index', array('dataProvider' => $dataProvider, 'name' => $name)); }
/** * Lists all models. */ public function actionIndex() { $pageSize = CommonService::getPageSize(); $criteria = new CDbCriteria(); $name = ''; if (isset($_GET['name'])) { $name = $_GET['name']; $criteria->addSearchCondition('target_id', $name); } $targetTable = ''; if (isset($_GET['target_table']) && !empty($_GET['target_table'])) { $targetTable = $_GET['target_table']; $criteria->addCondition('target_table=' . Yii::app()->db->quoteValue($targetTable)); } $targetTableOption = CHtml::dropDownList('target_table', $targetTable, array('' => Yii::t('AdminCommon', 'All'), 'product' => Yii::t('AdminCommon', 'product'), 'product_module' => Yii::t('AdminCommon', 'product_module'), 'field_config' => Yii::t('AdminCommon', 'field_config'), 'test_user' => Yii::t('AdminCommon', 'test_user'), 'user_group' => Yii::t('AdminCommon', 'user_group'), 'test_option' => Yii::t('AdminCommon', 'test_option'))); $dataProvider = new CActiveDataProvider('AdminAction', array('criteria' => $criteria, 'sort' => array('defaultOrder' => array('id' => true)), 'pagination' => array('pageSize' => $pageSize))); $this->render('index', array('dataProvider' => $dataProvider, 'name' => $name, 'targetTableOption' => $targetTableOption)); }
private function getGridShowContent($searchFieldConfig, $showFieldArr, $infoType, $productId, $filterColumn, $whereStr, $isAllBasicField = false) { $pageSize = CommonService::getPageSize(); $viewColumnArr = SearchService::getViewColumnArr($searchFieldConfig, $showFieldArr, $infoType, $productId, $filterColumn); $totalNum = SqlService::getTotalFoundNum($infoType, $productId, $whereStr, $isAllBasicField); $sql = SqlService::getRawDataSql($searchFieldConfig, $infoType, $productId, $this->getSqlSelectFieldArr($infoType, $showFieldArr), $whereStr, $isAllBasicField); $dataProvider = new CSqlDataProvider($sql, array('totalItemCount' => $totalNum, 'sort' => array('defaultOrder' => array('id' => true), 'multiSort' => true, 'attributes' => array_merge($showFieldArr, array(Info::MARK))), 'pagination' => array('pageSize' => $pageSize))); $sortArr = $dataProvider->getSort()->getDirections(); Yii::app()->user->setState($productId . '_' . $infoType . '_sortArr', $sortArr); $preNextSessionSql = SqlService::getPreNextSql($searchFieldConfig, $infoType, $productId, $whereStr, Yii::app()->user->getState($productId . '_' . $infoType . '_sortArr', $isAllBasicField)); Yii::app()->user->setState($productId . '_' . $infoType . '_prenextsql', $preNextSessionSql); return array('viewColumnArr' => $viewColumnArr, 'dataProvider' => $dataProvider, 'totalNum' => $totalNum); }
/** * Lists all models. */ public function actionIndex() { $name = ''; $pageSize = CommonService::getPageSize(); $productIdNameArr = ProductService::getActiveProductIdNameArr(); $criteria = new CDbCriteria(); if (CommonService::$TrueFalseStatus['FALSE'] == Yii::app()->user->getState('system_admin')) { $managedProducts = TestUserService::getManagedProduct(Yii::app()->user->id); $criteria->addInCondition('id', $managedProducts); $criteria->addCondition('is_dropped="0"'); } if (isset($_GET['name'])) { $name = $_GET['name']; $criteria->addSearchCondition('name', $name); } $dataProvider = new CActiveDataProvider('Product', array('criteria' => $criteria, 'sort' => array('defaultOrder' => array('is_dropped' => false, 'display_order' => true)), 'pagination' => array('pageSize' => $pageSize))); $this->render('index', array('dataProvider' => $dataProvider, 'name' => $name, 'productIdNameArr' => $productIdNameArr)); }
public function actionIndex() { $pageSize = CommonService::getPageSize(); $criteria = new CDbCriteria(); $name = ''; if (isset($_GET['name'])) { $name = $_GET['name']; $criteria->addCondition("realname like " . Yii::app()->db->quoteValue('%' . $_GET['name'] . '%') . " or username like " . Yii::app()->db->quoteValue('%' . $_GET['name'] . '%') . " or email like " . Yii::app()->db->quoteValue('%' . $_GET['name'] . '%')); } $dataProvider = new CActiveDataProvider('TestUser', array('criteria' => $criteria, 'sort' => array('defaultOrder' => array('id' => true)), 'pagination' => array('pageSize' => $pageSize))); $this->render('index', array('dataProvider' => $dataProvider, 'name' => $name)); }
/** * Lists all models. */ public function actionIndex() { self::checkEditable(); $pageSize = CommonService::getPageSize(); $productId = $_GET['product_id']; $productInfo = Product::model()->findByPk($productId); $this->breadcrumbs = array(Yii::t('Product', 'Back To Product List') => array('/product/index'), $productInfo->name . ' [' . ucfirst($_GET['type']) . Yii::t('Common', 'Manage Fields') . ']'); $dataProvider = new CActiveDataProvider('FieldConfig', array('criteria' => array('condition' => "product_id = :productId and type = :type", 'params' => array(':productId' => $productId, ':type' => Yii::app()->request->getParam('type'))), 'pagination' => array('pageSize' => $pageSize))); $productInfo = Product::model()->findByPk($_GET['product_id']); if ($productInfo !== null) { $this->render('index', array('dataProvider' => $dataProvider, 'productId' => $productInfo->id, 'productName' => $productInfo->name, 'type' => Yii::app()->request->getParam('type'))); } else { throw new CHttpException(404, 'The requested page does not exist.'); } }