/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = SinaRansom::find()->orderBy('id DESC'); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10]]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'uid' => $this->uid, 'money_sina' => $this->money_sina, 'status' => $this->status, 'create_at' => $this->create_at, 'update_at' => $this->update_at]); $query->andFilterWhere(['like', 'identity_id', $this->identity_id])->andFilterWhere(['like', 'out_trade_no', $this->out_trade_no])->andFilterWhere(['like', 'summary', $this->summary])->andFilterWhere(['like', 'trade_close_time', $this->trade_close_time])->andFilterWhere(['like', 'payer_id', $this->payer_id])->andFilterWhere(['like', 'payer_ip', $this->payer_ip])->andFilterWhere(['like', 'pay_method', $this->pay_method])->andFilterWhere(['like', 'payee_out_trade_no', $this->payee_out_trade_no])->andFilterWhere(['like', 'msg', $this->msg]); return $dataProvider; }
<?php use yii\helpers\Html; use yii\grid\GridView; /* @var $this yii\web\View */ /* @var $searchModel common\models\sinapay\SinaWithdrawSearch */ /* @var $dataProvider yii\data\ActiveDataProvider */ $this->title = Yii::t('app', '新浪提现操作'); $this->params['breadcrumbs'][] = $this->title; ?> <div class="sina-withdraw-index"> <?php echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'uid', 'out_trade_no', 'identity_id', 'card_id', 'site_balance', 'sina_balance', 'money', 'money_fund', 'money_site', 'money_sina', ['attribute' => 'status', 'format' => 'html', 'value' => function ($model) { if ($model->status === 5) { $class = 'label-success'; } elseif ($model->status === 4) { $class = 'label-warning'; } elseif ($model->status === 3) { $class = 'label-warning'; } else { $class = 'label-danger'; } return '<span class="label ' . $class . '">' . $model->statusLabel . '</span>'; }, 'filter' => Html::activeDropDownList($searchModel, 'status', \common\models\sinapay\SinaRansom::labels(), ['class' => 'form-control', 'prompt' => '请筛选'])], 'msg', ['attribute' => 'create_at', 'format' => ['date', 'php:Y-m-d H:i:s'], 'headerOptions' => ['width' => '100']]]]); ?> </div>
/** * 记录新浪赎回操作 * @param $uid * @param $identity_id * @param $out_trade_no * @param $summary * @param $trade_close_time * @param $payer_id * @param $payer_ip * @param $pay_method * @param $money_sina * @param $status * @param $msg * @return bool */ private static function ransomLog($uid, $identity_id, $out_trade_no, $summary, $trade_close_time, $payer_id, $payer_ip, $pay_method, $money_sina, $status, $msg, $payee_out_trade_no = '') { $log = new SinaRansom(); $log->uid = $uid; $log->identity_id = $identity_id; $log->out_trade_no = $out_trade_no; $log->summary = $summary; $log->trade_close_time = $trade_close_time; $log->payer_id = $payer_id; $log->payer_ip = $payer_ip; $log->pay_method = $pay_method; $log->money_sina = $money_sina; $log->status = $status; $log->msg = $msg; $log->payee_out_trade_no = $payee_out_trade_no; return $log->save(); }
/** * Finds the SinaRansom model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return SinaRansom the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = SinaRansom::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }