123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138 |
- <?php
- namespace app\command;
- use app\model\Member;
- use app\model\MemberAccount;
- use app\model\Order;
- use app\model\PayDetail;
- use support\Db;
- use Symfony\Component\Console\Command\Command;
- use Symfony\Component\Console\Input\InputArgument;
- use Symfony\Component\Console\Input\InputInterface;
- use Symfony\Component\Console\Output\OutputInterface;
- class WelfareAccountCommand extends Command
- {
- protected static $defaultName = 'WelfareAccountCommand';
- protected static $defaultDescription = 'WelfareAccountCommand';
- /**
- * @return void
- */
- protected function configure()
- {
- // $this->addArgument('name', InputArgument::OPTIONAL, '余额账户转福利账户');
- $this->addArgument('name', InputArgument::OPTIONAL, '福利账户余额清空');
- }
- protected function execute(InputInterface $input, OutputInterface $output): int
- {
- $accounts = MemberAccount::where('member_account_classify','WELFARE')->get()->toArray();
- Db::beginTransaction();
- try{
-
- foreach($accounts as $account){
- if ($account['member_account_income'] == '0.00'){
- echo "会员【" . $account['join_account_member_id'] . "】跳过\n";
- continue;
- }
- // 更新余额账户
- MemberAccount::where('member_account_id',$account['member_account_id'])->update([
- 'member_account_expend' => $account['member_account_expend'] + $account['member_account_surplus'],
- 'member_account_surplus' => 0
- ]);
- // 插入清零记录
- $this->generatePayDetail($account);
- echo "会员【" . $account['join_account_member_id'] . "】已处理完成\n";
- }
- Db::commit();
- return self::SUCCESS;
- }catch(\Exception $e){
- dump($e->getMessage());
- Db::rollBack();
- }
- }
- /**
- * 生成清零记录
- */
- private function generatePayDetail($account)
- {
- $payDetailData = [
- 'join_pay_member_id'=>$account['join_account_member_id'],
- 'pay_status'=>'SUCCESS',
- 'pay_category'=>'CLEAR',
- 'pay_amount'=>$account['member_account_surplus'],
- 'pay_paytimes'=>date('Y-m-d H:i:s'),
- 'pay_prepayid'=>$account['member_account_nbr'],
- 'pay_addtimes'=>time()
- ];
-
- PayDetail::insert($payDetailData);
- }
- // protected function execute(InputInterface $input, OutputInterface $output): int
- // {
- // $members = Member::select('member_id', 'member_classify')->get()->toArray();
- // foreach ($members as $member) {
- // if (!MemberAccount::where('join_account_member_id', $member['member_id'])->where('member_account_classify', 'WELFARE')->exists()) {
- // if (!$this->generateWelfareAccount($member['member_id'])) {
- // echo "会员【" . $member['member_id'] . "】跳过\n";
- // continue;
- // }
- // }
- // if ($member['member_classify'] != 'EMPLOY') {
- // Member::where('member_id', $member['member_id'])->update(['member_classify' => 'EMPLOY']);
- // }
- // // 改所有的充值记录
- // PayDetail::where('join_pay_member_id', $member['member_id'])->where('pay_category', 'RECHARGE')->where('pay_amount','1000.00')->update(['pay_prepayid' => $member['member_id'] . '-WELFARE']);
- // // 改所有的付款记录
- // PayDetail::where('join_pay_member_id', $member['member_id'])->where('pay_prepayid', $member['member_id'] . '-CASH')->update(['pay_prepayid' => $member['member_id'] . '-WELFARE']);
- // // 余额账户清空
- // MemberAccount::where('join_account_member_id', $member['member_id'])->where('member_account_classify', 'CASH')->update([
- // 'member_account_income' => 0,
- // 'member_account_expend' => 0,
- // 'member_account_surplus' => 0,
- // 'member_account_added' => 0,
- // ]);
- // echo "会员【" . $member['member_id'] . "】已处理完成\n";
- // }
- // return self::SUCCESS;
- // }
- private function generateWelfareAccount($memberId)
- {
- $cashAccount = MemberAccount::where('join_account_member_id', $memberId)->where('member_account_classify', 'CASH')->first();
- if (!$cashAccount) {
- return false;
- }
- MemberAccount::insert([
- 'join_account_member_id' => $memberId,
- 'member_account_classify' => 'WELFARE',
- 'member_account_status' => 'ACTIVED',
- 'member_account_category' => 'NORMAL',
- 'member_account_nbr' => $memberId . '-WELFARE',
- 'member_account_name' => '福利账户',
- 'member_account_income' => $cashAccount->member_account_income,
- 'member_account_expend' => $cashAccount->member_account_expend,
- 'member_account_surplus' => $cashAccount->member_account_surplus,
- 'member_account_added' => $cashAccount->member_account_added,
- 'member_account_addtimes' => time()
- ]);
- return true;
- }
- }
|