/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = MUserAccount::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'create_time' => $this->create_time, 'amount' => $this->amount, 'status' => $this->status, 'cat' => $this->cat, 'scene_id' => $this->scene_id]); $query->andFilterWhere(['like', 'gh_id', $this->gh_id])->andFilterWhere(['like', 'openid', $this->openid])->andFilterWhere(['like', 'memo', $this->memo])->andFilterWhere(['like', 'oid', $this->oid])->andFilterWhere(['like', 'charge_mobile', $this->charge_mobile]); return $dataProvider; }
/** * This command export user account data. * @param string $filename the file to be exported to. */ public function actionUserAccount($filename = 'user-account.csv') { $file = Yii::$app->getRuntimePath() . DIRECTORY_SEPARATOR . 'exported_data' . DIRECTORY_SEPARATOR . $filename; $useraccount_records = \app\models\MUserAccount::find()->where(['cat' => \app\models\MUserAccount::CAT_CREDIT_CHARGE_MOBILE])->andWhere(['status' => \app\models\MUserAccount::STATUS_CHARGE_REQUEST])->all(); $fh = fopen($file, "w"); fprintf($fh, "充值手机号码,充值金额,申请时间\n"); foreach ($useraccount_records as $useraccount_record) { fprintf($fh, "%s,%s,%s\n", $useraccount_record->charge_mobile, intval($useraccount_record->amount / 100), $useraccount_record->create_time); $useraccount_record->updateAttributes(['status' => \app\models\MUserAccount::STATUS_CHARGE_PROCESSING]); } fclose($fh); echo "总共" . count($useraccount_records) . "条充值申请!" . PHP_EOL; }
<div class="muser-account-form"> <?php $form = ActiveForm::begin(); ?> <?php echo $form->field($model, 'amount')->textInput(); ?> <?php echo $form->field($model, 'memo')->textInput(['maxlength' => 512]); ?> <?php echo $form->field($model, 'cat')->dropDownList(MUserAccount::getCatOptionName()); ?> <?php echo $form->field($model, 'charge_mobile')->textInput(['maxlength' => 32]); ?> <div class="form-group"> <?php echo Html::submitButton($model->isNewRecord ? Yii::t('app', '新建') : Yii::t('app', '修改'), ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']); ?> </div> <?php ActiveForm::end(); ?>
public function actionUserAccountBalance() { \Yii::$app->db->createCommand("update wx_user set user_account_balance = 0")->execute(); $user_accounts = \app\models\MUserAccount::find()->all(); foreach ($user_accounts as $user_account) { // if ($user_account->cat == \app\models\MUserAccount::CAT_DEBIT_FAN) $user_account->user->updateCounters(['user_account_balance' => $user_account->amount]); } }
public static function addRecommendFanAmount($date_start, $date_end) { U::W(__METHOD__ . " BEGIN from {$date_start}, {$date_end}"); // $tableName = MSceneDay::tableName(); $ghs = MGh::find()->all(); foreach ($ghs as $gh) { if ($gh->gh_id !== MGh::GH_XIANGYANGUNICOM) { continue; } foreach ($gh->staffs as $staff) { if ($staff->scene_id != 0 && ($staff->cat == MStaff::SCENE_CAT_OUT || $staff->cat == MStaff::SCENE_CAT_FAN) && !empty($staff->openid)) { $real_score = MAccessLog::getRealScoreByRange($gh->gh_id, $staff->scene_id, $date_start, $date_end); if ($real_score > 0) { //$amount = intval($real_score) * 100; //$amount = intval($real_score/3) * 500; $amount = intval($real_score) * 500; if ($amount > 0) { $model = new MUserAccount(); $model->gh_id = $staff->gh_id; $model->openid = $staff->openid; $model->scene_id = $staff->scene_id; $model->cat = MUserAccount::CAT_DEBIT_FAN; $model->amount = $amount; $model->memo = '推荐有礼'; $model->save(false); // U::W("SAVE OK, scene_id={$staff->scene_id}, openid={$staff->openid}, amount={$model->amount}"); } } else { // U::W("scene_id={$staff->scene_id}, openid={$staff->openid}, realscore={$real_score}, "); } } else { // U::W("scene_id={$staff->scene_id}, openid={$staff->openid}"); } } } U::W(__METHOD__ . " END"); return; }
/** * Finds the MUserAccount model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param string $id * @return MUserAccount the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = MUserAccount::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
</p> --> <?php echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'options' => ['class' => 'table-responsive'], 'tableOptions' => ['class' => 'table table-striped'], 'columns' => [['label' => false, 'format' => 'html', 'value' => function ($model, $key, $index, $column) { if (empty($model->user->headimgurl)) { return ''; } $headimgurl = Html::img(U::getUserHeadimgurl($model->user->headimgurl, 46), ['style' => 'width:46px;']); return $headimgurl; }], ['label' => '微信昵称', 'value' => function ($model, $key, $index, $column) { return empty($model->user->nickname) ? '' : $model->user->nickname; }], 'create_time', ['attribute' => 'amount', 'value' => function ($model, $key, $index, $column) { return $model->getAmountInfo(); }], ['attribute' => 'status', 'label' => '状态', 'value' => function ($model, $key, $index, $column) { return MUserAccount::getStatusDesc($model->status); }, 'filter' => MUserAccount::getStatusDesc(), 'headerOptions' => array('style' => 'width:120px;')], ['attribute' => 'cat', 'value' => function ($model, $key, $index, $column) { return MUserAccount::getCatOptionName($model->cat); }, 'filter' => MUserAccount::getCatOptionName()], ['attribute' => 'memo', 'value' => function ($model, $key, $index, $column) { return $model->getMemoInfo(); }], 'scene_id', 'charge_mobile', ['class' => 'yii\\grid\\ActionColumn', 'template' => '{update} {delete}']]]); ?> </div> <?php /* <h2> 账户余额: <?= $user->getUserAccountBalanceInfo(); ?> </h2> */
public function actionQxchonghuafeiajax() { $uid = $_GET['uid']; $user_account = \app\models\MUserAccount::findOne(['id' => $uid]); if (empty($user_account)) { return json_encode(['code' => 0]); } if ($user_account->cat != \app\models\MUserAccount::CAT_CREDIT_CHARGE_MOBILE || $user_account->status != \app\models\MUserAccount::STATUS_CHARGE_REQUEST) { return json_encode(['code' => -1]); } $user_account->delete(); return json_encode(['code' => 0]); }
public function getUserAccounts() { return $this->hasMany(\app\models\MUserAccount::className(), ['gh_id' => 'gh_id', 'openid' => 'openid'])->orderBy('create_time DESC'); }