wanyue_app/app/admin/controller/member/QuotaController.php

<?php

namespace app\admin\controller\member;

use app\admin\validate\member\RuleAddedValidate;
use app\admin\validate\member\RulePricingValidate;
use app\controller\Curd;
use app\model\Member;
use app\model\MemberQuota;
use app\model\RuleAdded;
use app\model\RuleAddedComponent;
use app\model\RulePricing;
use app\model\SysSerial;
use support\Db;
use support\Redis;
use support\exception\BusinessException;
use support\Request;
use support\Response;
use support\view\Raw;

class QuotaController extends Curd
{
    public function __construct()
    {
        $this->model = new MemberQuota();
//        $this->validate = true;
//        $this->validateClass = new RuleAddedValidate();
    }

    public function select(Request $request): Response
    {
        $page = $request->get('page', 1);
        $pageSize = $request->get('pageSize', 20);
        $keywords = $request->get('keywords', '');
        $memberId = $request->get('member_id', '');
        $memberIds = [];
        if (!empty($keywords)) {
            $memberIds = Member::leftJoin('member_cert', 'member_cert.join_cert_member_id', '=', 'member.member_id')
                ->where('member.member_mobile', 'like', '%' . $keywords . '%')
                ->orWhere('member_cert.member_cert_name', 'like', '%' . $keywords . '%')
                ->pluck('member.member_id')
                ->toArray();
            if (empty($memberIds)) {
                return json_success('', []);
            }
        }

        if (!empty($memberId)) {
            $memberIds = $memberId;
        }

        foreach ($memberIds as &$id){
            $id = "'".$id."'";
        }

        $rows = MemberQuota::select('join_quota_member_id', 'join_member_rule_added_component_id', Db::raw('MAX(member_quota_addtimes) as new_addtimes'))

//            ->when(!empty($memberIds), function ($query) use ($placeholders,$pars) {
//                $query->whereRaw("join_quota_member_id in ($placeholders))", $pars);
//            })
            ->when(!empty($memberIds), function ($query) use ($memberIds) {
                $query->whereIn('join_quota_member_id', $memberIds);
            })
            ->groupBy('join_member_rule_added_component_id', 'join_quota_member_id');

        $bindings = $rows->getBindings();
        $sql = str_replace('?', '%s', $rows->toSql());
        $sql = sprintf($sql, ...$bindings);
        $total = MemberQuota::from(Db::raw("({$sql}) t"))->count();

        $rows = MemberQuota::from(Db::raw("({$sql}) t"))->orderByDesc('new_addtimes')->forPage($page, $pageSize)
            ->get()
            ->toArray();
        foreach ($rows as &$row) {
            $quota = MemberQuota::with([
                'member' => function ($query) {
                    $query->select('member_id', 'member_mobile');
                },
                'cert' => function ($query) {
                    $query->select('join_cert_member_id', 'member_cert_name');
                },
                'component' => function ($query) {
                    $query->select('rule_added_component_id', 'rule_added_component_name');
                }
            ])->where('join_quota_member_id', $row['join_quota_member_id'])
                ->where('join_member_rule_added_component_id', $row['join_member_rule_added_component_id'])
                ->first()
                ->toArray();
            $quotaTotal = MemberQuota::where('join_quota_member_id', $row['join_quota_member_id'])
                ->where('join_member_rule_added_component_id', $row['join_member_rule_added_component_id'])
                ->count();
            $quotaUsed = MemberQuota::where('join_quota_member_id', $row['join_quota_member_id'])
                ->where('join_member_rule_added_component_id', $row['join_member_rule_added_component_id'])
                ->where('member_quota_status', 'USED')
                ->count();
            $quota['total'] = $quotaTotal;
            $quota['used'] = $quotaUsed;
            $quota['unused'] = $quotaTotal - $quotaUsed;

            $addedId = RuleAddedComponent::where('rule_added_component_id', $row['join_member_rule_added_component_id'])->value('join_component_rule_added_id');
            $addedName = RuleAdded::where('rule_added_id', $addedId)->value('rule_added_name');
            $quota['added_name'] = $addedName;

            $row = $quota;
        }

        return json_success('', compact('rows', 'page', 'pageSize', 'total'));
    }

    protected function doSelect(array $where, string $field = null, string $order = 'desc')
    {
        $model = $this->model->with([
            'member' => function ($query) {
                $query->select('member_id', 'member_mobile');
            },
            'cert' => function ($query) {
                $query->select('join_cert_member_id', 'member_cert_name');
            },
            'component' => function ($query) {
                $query->select('rule_added_component_id', 'rule_added_component_name');
            }
        ]);
        $model = $model->groupBy('join_member_rule_added_component_id');
        foreach ($where as $column => $value) {
            if (is_array($value)) {
                if ($value[0] === 'like' || $value[0] === 'not like') {
                    $model = $model->where($column, $value[0], "%$value[1]%");
                } elseif (in_array($value[0], ['>', '=', '<', '<>'])) {
                    $model = $model->where($column, $value[0], $value[1]);
                } elseif ($value[0] == 'in' && !empty($value[1])) {
                    $valArr = $value[1];
                    if (is_string($value[1])) {
                        $valArr = explode(",", trim($value[1]));
                    }
                    $model = $model->whereIn($column, $valArr);
                } elseif ($value[0] == 'not in' && !empty($value[1])) {
                    $valArr = $value[1];
                    if (is_string($value[1])) {
                        $valArr = explode(",", trim($value[1]));
                    }
                    $model = $model->whereNotIn($column, $valArr);
                } elseif ($value[0] == 'null') {
                    $model = $model->whereNull($column);
                } elseif ($value[0] == 'not null') {
                    $model = $model->whereNotNull($column);
                } elseif ($value[0] !== '' || $value[1] !== '') {
                    $model = $model->whereBetween($column, $value);
                }
            } else {
                $model = $model->where($column, $value);
            }
        }

        if ($field) {
            $model = $model->orderBy($field, $order);
        }
        return $model;
    }

//    protected function insertInput(Request $request): array
//    {
//        $data = $this->inputFilter($request->post());
//        $data['rule_added_id'] = "RA" . str_pad(SysSerial::getSerial(), 16, '0', STR_PAD_LEFT) . random_string(6, 'up');
//
//        return $data;
//    }

    protected function updateInput(Request $request): array
    {
        $primary_key = $this->model->getKeyName();
        $id = $request->post($primary_key);
        $data = $this->inputFilter($request->post());
//        if (!empty($data['rule_pricing_goods_json'])) {
//            $data['rule_pricing_goods_json'] = json_encode(explode(',', $data['rule_pricing_goods_json']));
//        } else {
//            $data['rule_pricing_goods_json'] = '[]';
//        }
        $model = $this->model->find($id);
        if (!$model) {
            throw new BusinessException('记录不存在', 2);
        }
        unset($data[$primary_key]);
        return [$id, $data];
    }

    public function writeOffList(Request $request)
    {
        $memberId = $request->get('member_id', '');
        $componentId = $request->get('component_id', '');

        $quotas = MemberQuota::with([
            'member' => function ($query) {
                $query->select('member_id', 'member_mobile');
            },
            'cert' => function ($query) {
                $query->select('join_cert_member_id', 'member_cert_name');
            },
            'component' => function ($query) {
                $query->select('rule_added_component_id', 'rule_added_component_name');
            }
        ])->where('join_quota_member_id', $memberId)
            ->where('join_member_rule_added_component_id', $componentId)
            ->where('member_quota_status', 'USED')
            ->get();

        return json_success('', $quotas);
    }

    /**
     * @Desc 额度核销
     * @Author Gorden
     * @Date 2024/6/4 8:32
     *
     * @param Request $request
     * @return Response
     */
    public function writeOff(Request $request)
    {
        $memberId = $request->post('member_id', []);
        $componentId = $request->post('component_id', []);
        $nbr = $request->post('nbr');
        $times = $request->post('times', '');
        $code = $request->post('sms_code', '');

        if (!$memberId || !$componentId) {
            return json_fail("参数异常");
        }

        $quotas = MemberQuota::where('join_quota_member_id', $memberId[0])
            ->where('join_member_rule_added_component_id', $componentId[0])
            ->where('member_quota_status', 'PENDING')
            ->limit($nbr)
            ->get()
            ->toArray();
        if (count($quotas) < intval($nbr)) {
            return json_fail("可核销数量不足");
        }

        $member = Member::find(current($memberId));
        $mobile = $member->member_mobile;
        $key = "SMS:CODE:QUOTA:" . $mobile;
        $redisCode = Redis::get($key);
        if ($redisCode != $code) {
            return json_fail("验证码错误，请重新输入");
        }
        Redis::del($key);

        if (!$times) {
            $times = date('Y-m-d H:i:s');
        } else {
            $times = date('Y-m-d H:i:s', strtotime($times));
        }

        try {
            foreach ($quotas as $quota) {
                $extend = [];
                if (!empty($quota['member_quota_extend_json'])) {
                    $extend = json_decode($quota['member_quota_extend_json'], true);
                }
                $extend['writeOffTime'] = $times;

                MemberQuota::where('member_quota_id', $quota['member_quota_id'])->update(['member_quota_status' => 'USED', 'member_quota_extend_json' => $extend]);
            }

        } catch (\Exception $e) {
            return json_fail("核销失败");
        }

        return json_success("核销成功");
    }

}