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