/**
* 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.');
}
}
