public function run() { $this->controller->_seoTitle = '交易记录 - ' . $this->controller->_setting['site_name']; $this->controller->loadModel(); $model = new UserTrade(); $criteria = new CDbCriteria(); //查询条件 $create_time_start = Yii::app()->request->getParam('create_time_start'); $create_time_end = Yii::app()->request->getParam('create_time_end'); $trade_type = Yii::app()->request->getParam('trade_type'); $trade_status = Yii::app()->request->getParam('trade_status'); $create_time_start && $criteria->addBetweenCondition('time_create', strtotime($create_time_start), strtotime($create_time_end)); if ($trade_type && $trade_type != 'all') { $criteria->addColumnCondition(['type' => $trade_type]); } if ($trade_status && $trade_status != 'all') { $criteria->addColumnCondition(['status' => $trade_status]); } $criteria->addColumnCondition(array('user_id' => Yii::app()->user->id)); $count = $model->count($criteria); $pages = new CPagination($count); $pages->pageSize = 10; $pages->applyLimit($criteria); $lists = $model->findAll($criteria); //加载css js Yii::app()->clientScript->registerScriptFile($this->controller->_static_public . "/js/jquery/jquery.js"); Yii::app()->clientScript->registerScriptFile($this->controller->_static_public . "/js/My97DatePicker/WdatePicker.js", CClientScript::POS_END); $this->controller->render('list_trade', array('lists' => $lists, 'pages' => $pages, 'create_time_start' => $create_time_start, 'create_time_end' => $create_time_end, 'trade_type' => $trade_type, 'trade_status' => $trade_status)); }
public function actionIncome() { $model = new UserTrade(); $criteria = new CDbCriteria(); //搜索 $username = trim(Yii::app()->request->getParam('username')); if ($username) { $criteria->addColumnCondition(['user.username' => $username]); } $criteria->addColumnCondition(['t.type' => UserTrade::TYPE_INCOME]); $criteria->with = ['withdraw', 'user']; $criteria->order = 't.id DESC'; $count = $model->count($criteria); $pages = new CPagination($count); $pages->pageSize = 13; $criteria->limit = $pages->pageSize; $criteria->offset = $pages->currentPage * $pages->pageSize; $result = $model->findAll($criteria); $this->render('income', array('datalist' => $result, 'pagebar' => $pages)); }