/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = SinaMember::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, 'status' => $this->status, 'create_at' => $this->create_at, 'update_at' => $this->update_at]); $query->andFilterWhere(['like', 'identity_id', $this->identity_id])->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'idcard', $this->idcard])->andFilterWhere(['like', 'user_ip', $this->user_ip])->andFilterWhere(['like', 'phone', $this->phone])->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\SinaMemberSearch */ /* @var $dataProvider yii\data\ActiveDataProvider */ $this->title = Yii::t('app', '新浪会员记录'); $this->params['breadcrumbs'][] = $this->title; ?> <div class="sina-member-index"> <?php echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'identity_id', 'uid', 'name', 'idcard', 'user_ip', 'phone', ['attribute' => 'status', 'format' => 'html', 'value' => function ($model) { if ($model->status === 1) { $class = 'label-success'; } elseif ($model->status === 0) { $class = 'label-warning'; } else { $class = 'label-danger'; } return '<span class="label ' . $class . '">' . $model->statusLabel . '</span>'; }, 'filter' => Html::activeDropDownList($searchModel, 'status', \common\models\sinapay\SinaMember::labels(), ['class' => 'form-control', 'prompt' => '请筛选'])], 'msg', ['attribute' => 'create_at', 'format' => ['date', 'php:Y-m-d H:i:s'], 'headerOptions' => ['width' => '100']], ['class' => 'yii\\grid\\ActionColumn', 'header' => '操作', 'template' => '{view}', 'buttons' => ['view' => function ($url, $model, $key) { return $model->status == 1 ? Html::a('<span class="glyphicon glyphicon-eye-open"></span>', $url, ['title' => '查看新浪余额']) : ''; }]]]]); ?> </div>
/** * Finds the SinaMember model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return SinaMember the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = SinaMember::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/** * 创建纪录 * @param $uid * @param $identity_id * @param $name * @param $idcard * @param $user_ip * @param $phone * @param $status * @param $msg * @return bool */ private static function memberLog($uid, $identity_id, $name, $idcard, $user_ip, $phone, $status, $msg) { $log = new SinaMember(); $log->uid = $uid; $log->identity_id = $identity_id; $log->name = $name; $log->idcard = $idcard; $log->user_ip = $user_ip; $log->phone = $phone; $log->status = $status; $log->msg = $msg; return $log->save(); }
public function actionUnlock($id) { $model = $this->findModel($id); $sina = new sina(); $smember = SinaMember::find()->andWhere(['uid' => $model->member_id])->one(); if ($smember && $smember->status == 1) { //$sina = new sina(); $model->sinamoney = $sina->query_balance($smember->identity_id); } else { \Yii::$app->getSession()->setFlash('warning', '该用户没用绑定新浪账户'); } if (\App::$app->request->post()) { if (\App::$app->request->post()['Info']['freeze'] > $model->freeze) { return $this->render('unlock', ['model' => $model]); } else { $model->freeze -= \App::$app->request->post()['Info']['freeze']; $model->balance += \App::$app->request->post()['Info']['freeze']; $model->save(); return $this->redirect(['view', 'id' => $model->member_id]); } } else { return $this->render('unlock', ['model' => $model]); } }