baseXX/application/admin/controller/user/MemberCard.php

<?php
// +----------------------------------------------------------------------
// | CRMEB [ CRMEB赋能开发者，助力企业发展 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2016~2020 https://www.crmeb.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed CRMEB并不是自由软件，未经许可不能去掉CRMEB相关版权
// +----------------------------------------------------------------------
// | Author: CRMEB Team <admin@crmeb.com>
// +----------------------------------------------------------------------

namespace app\admin\controller\user;

use app\admin\model\user\MemberCardBatch;
use app\admin\model\user\MemberCard as MemberCardModel;
use app\admin\controller\AuthController;
use service\JsonService as Json;
use service\FormBuilder as Form;
use think\Db;
use think\Url;

/**
 * 会员卡管理控制器
 * Class User
 * @package app\admin\controller\user
 */
class MemberCard extends AuthController
{
    public function batch_index()
    {
        $this->assign([
            'activity_type' => 1,
        ]);
        return $this->fetch();
    }

    public function batch_list()
    {
        $where = parent::getMore([
            ['title', ""],
            ['page', 1],
            ['limit', 20],
        ]);
        $batch_list = MemberCardBatch::getBatchList($where);
        return Json::successlayui($batch_list);
    }

    public function add_batch()
    {
        $id = $this->request->param('id',0);
        if ($id){
            $batch_data = MemberCardBatch::getBatchOne($id);
            $this->assign('batch', json_encode($batch_data));
        }
        $this->assign([
            'id' => $id,
        ]);
        return $this->fetch();
    }

    public function save_batch()
    {
        $id = $this->request->param('id',0);
        $data = parent::postMore([
            ['title', ''],
            ['use_day', 1],
            ['total_num', 1],
            ['status', 0],
        ]);
        if (!isset($data['use_day']) || $data['use_day'] <= 0 || !is_numeric( $data['use_day'])) return Json::fail('体验时间未填写或不合法');
        if (!isset($data['total_num']) || $data['total_num'] <= 0 || !is_numeric( $data['total_num'])) return Json::fail('制卡未填写或不合法');
        if ($data['total_num'] > 6000) return Json::fail('单次制卡数量最高不得超过6000张');

        try{
            MemberCardBatch::beginTrans();
            if ($id) {
                $data['update_time'] = time();
            }else{
                $data['create_time'] = time();
                $batch_id = MemberCardBatch::addBatch($data);
                $batch_card = MemberCardModel::addCard($batch_id, $data['total_num']);
                if($batch_id && $batch_card){
                    $qrcodeUrl=MemberCardBatch::qrcodes_url($batch_id,5);
                    MemberCardBatch::where('id',$batch_id)->update(['qrcode'=>$qrcodeUrl]);
                }
            }
            MemberCardBatch::commitTrans();
            return Json::successful('添加成功');
        }catch (\Exception $e) {
            MemberCardBatch::rollbackTrans();
            return Json::fail('添加失败');
        }
    }

    /**
     * 快速编辑
     * @param string $field 字段名
     * @param int $id 修改的主键
     * @param string value 修改后的值
     * @return json
     */
    public function set_value($field = '', $id, $value = '', $model_type)
    {
        if ($field == "use_day" && $id) {
            if (!$value || !is_numeric($value) || $value <= 0) return Json::fail('非法数值');
            $get_one = MemberCardModel::getCardOne(['card_batch_id' => $id, 'use_uid' => ['>',0]]);
            if ($get_one){
                return Json::fail('此批次卡片已经在使用当中，无法进行此非法操作');
            }
        }
        $use=MemberCardModel::where('card_batch_id',$id)->where('use_uid','>',0)->count();
        if($use) return Json::fail('此批次卡片已经在使用当中，无法进行此非法操作');
        if($model_type=='member_card' && $id){
            $card = MemberCardModel::where(['id' => $id, 'use_uid' => ['>',0]])->find();
            if($card) return Json::fail('此卡片已经在使用当中，无法进行此非法操作');
        }
        return  set_field_value([$field => $value], ['id' => $id], $value, $model_type);
    }

    public function card_index()
    {
        $data = parent::getMore([
            ['activity_type', 2],
            ['card_batch_id', 0],

        ]);
        $batch_list = MemberCardBatch::getBatchAll([]);
        $this->assign([
            'activity_type' => $data['activity_type'],
            'card_batch_id' => $data['card_batch_id'],
            'batch_list' => $batch_list ? $batch_list->toArray() : [],
        ]);
        return $this->fetch();
    }
    public function card_list()
    {
        $card_batch_id = $this->request->param('card_batch_id',0);
        $excel = $this->request->param('excel',0);
        $where = parent::getMore([
            ['card_number', ""],
            ['phone', ""],
            ['card_batch_id', $card_batch_id],
            ['is_use',""],
            ['is_status',""],
            ['page', 1],
            ['limit', 20],
            ['excel', $excel],
        ]);
        $card_list = MemberCardModel::getCardList($where);
        return Json::successlayui($card_list);
    }
}