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));
}
