public function actionApprove($id)
{
$model = $this->findModel($id);
$data = array('Member' => array('approved_at' => date('Y-m-d h:i:s', time()), 'role_id' => 3));
$model->load($data);
$model->finance_fund -= System::loadConfig('annual_fee');
$outRecord = OutRecord::prepareYearlyFeeRecord($model->id, $model->finance_fund);
$connection = Yii::$app->db;
try {
$transaction = $connection->beginTransaction();
if ($model->save() && $outRecord->save()) {
$transaction->commit();
Yii::$app->session->setFlash('success', '会员(' . $model->username . ')审核成功');
return $this->redirect(['approvedindex']);
} else {
$transaction->rollBack();
Yii::$app->session->setFlash('danger', '会员(' . $model->username . ')审核失败, 请稍后再试或联系管理员');
return $this->redirect(['unapprovedindex']);
}
} catch (Exception $e) {
$transaction->rollBack();
Yii::$app->session->setFlash('danger', '会员(' . $model->username . ')审核失败, 请稍后再试或联系管理员');
return $this->redirect(['unapprovedindex']);
}
}
public function actionIndex()
{
$members = Member::findAll(array());
foreach ($members as $member) {
$member->finance_fund -= System::loadConfig('annual_fee');
$outRecord = OutRecord::prepareYearlyFeeRecord($member->id, $member->finance_fund);
$member->save();
$outRecord->save();
}
}
