wanyue_app/app/admin/service/card/CardService.php

<?php
/**
 * CardService.php
 * User: ZhouBenXu
 * Date: 2024/6/27
 * Time: 上午9:46
 * Notes: 卡管理
 */

namespace app\admin\service\card;

use support\Db;
use support\exception\BusinessException;
use app\model\Card;

class CardService
{

    /**
     * Notes: 添加卡信息
     * User: ZhouBenXu
     * DateTime: 2024/6/27 下午2:58
     * @param $join_card_batch_id 卡批次id
     * @param $card_info 卡信息
     * @return \support\Response
     */
    public static function insert($join_card_batch_id, $card_info)
    {
        Db::beginTransaction();
        try {
            $model = new Card();
            // 生成包含100到200的数组
            $card_sort = range($card_info['card_batch_serial_begin'], $card_info['card_batch_serial_end']);
            $insertData = [];
            if ($card_info['card_batch_validtimes'] != 0) { // 卡批次有效期 0=永久 天
                $card_info['card_batch_validtimes'] = (strtotime(date('Y-m-d 00:00:00')) + $card_info['card_batch_validtimes'] * 86400) - 1;
            }
            foreach ($card_sort as $value) {
                $info['join_card_batch_id'] = $join_card_batch_id;
                $info['join_card_category_id'] = $card_info['join_card_batch_category_id'];
                $info['card_status'] = $model::CARD_STATUS[1];
                $info['card_category'] = $card_info['card_batch_category'];
                $info['card_name'] = $card_info['card_batch_name'];
                $info['card_prefix'] = $card_info['card_batch_prefix'];
                $info['card_suffix'] = $card_info['card_batch_suffix'];
                $info['card_pass'] = mt_rand(10000000, 99999999);// 卡密
                $info['card_amount'] = $card_info['card_batch_amount'];
                $info['card_added'] = $card_info['card_batch_added'];
                $info['card_validtimes'] = $card_info['card_batch_validtimes']; // 卡批次有效期 0=永久 天
                $info['card_json'] = "{}";
                $info['card_assign_json'] = "{}";
                $info['card_process_json'] = "{}";
                $info['card_sort'] = $value;
                $info['card_remark'] = "";
                $info['card_extend_json'] = "{}";
                $info['card_addtimes'] = time();
                $insertData[] = $info;
            }
            $model->insert($insertData);
            Db::commit();
        } catch (\PDOException $e) {
            Db::rollBack();
            dump($e->getFile() . '(' . $e->getLine() . '):' . $e->getMessage());
            return json_fail('数据写入失败~');
        } catch (BusinessException $e) {
            Db::rollBack();
            dump($e->getFile() . '(' . $e->getLine() . '):' . $e->getMessage());
            return json_fail($e->getMessage());
        } catch (\Exception $e) {
            Db::rollBack();
            dump($e->getTrace());
            return json_fail('数据写入失败~');
        }
        _syslog("添加储值卡", "卡批次名称【" . $card_info['card_batch_name'] . "】", $insertData);
        return json_success('success');
    }

    /**
     * Notes: 根据卡批次修改卡信息
     * User: ZhouBenXu
     * DateTime: 2024/6/27 下午5:03
     * @param $join_card_batch_id
     * @param $save
     * @return \support\Response
     */
    public static function saveCardByCardBatchId($join_card_batch_id, $save)
    {

        Db::beginTransaction();
        try {
            $model = new Card();
            $data['card_name'] = $save['card_batch_name'];

            $card_status = array_values($model::CARD_STATUS);
            if (in_array($save['card_batch_status'], $card_status)) {
                $data['card_status'] = $save['card_batch_status']; // 卡批次状态
            }
            if ($save['validtimes_status'] == 0) { // 卡批次有效期 0 永久天  1 增加 2减少
                $data['card_validtimes'] = 0;
            } elseif ($save['validtimes_status'] == 1) {
                $data['card_validtimes'] = Db::raw('card_validtimes+' . $save['card_batch_validtimes'] * 86400);
            } elseif ($save['validtimes_status'] == 2) {
                $data['card_validtimes'] = Db::raw('card_validtimes-' . $save['card_batch_validtimes'] * 86400);
            }
            $model->where('join_card_batch_id', $join_card_batch_id)->update($data);
            Db::commit();
        } catch (\PDOException $e) {
            Db::rollBack();
            dump($e->getFile() . '(' . $e->getLine() . '):' . $e->getMessage());
            return json_fail('数据写入失败~');
        } catch (BusinessException $e) {
            Db::rollBack();
            dump($e->getFile() . '(' . $e->getLine() . '):' . $e->getMessage());
            return json_fail($e->getMessage());
        } catch (\Exception $e) {
            Db::rollBack();
            dump($e->getTrace());
            return json_fail('数据写入失败~');
        }
        _syslog("修改储值卡", "卡批次名称【" . $save['card_batch_name'] . "】");
        return json_success('success');
    }


    /**
     * Notes: 储值卡列表
     * User: ZhouBenXu
     * DateTime: 2024/6/28 上午11:36
     * @param $params
     * @return \support\Response
     */
    public static function getList($params)
    {

        $cardModel = new Card();
        $page = $params['page'];
        $page_size = $params['pageSize'];
        $join_card_batch_id = $params['join_card_batch_id'] ?? "";
        $join_card_category_id = $params['join_card_category_id'] ?? "";
        $join_card_member_id = $params['join_card_member_id'] ?? "";
        $card_status = !empty($params['card_status']) ? Card::CARD_STATUS[$params['card_status']] : "";
        $card_category = $params['card_category'] ?? "";
        $card_name = $params['card_name'] ?? "";

        $rows = $cardModel::select('*')
            ->when(!empty($card_name) && $card_name != '', function ($query) use ($card_name) {
                $query->where('card_name', 'like', '%' . $card_name . '%');
            })->when(!empty($card_status), function ($query) use ($card_status) {
                $query->where('card_status', $card_status);
            })->when(!empty($join_card_batch_id), function ($query) use ($join_card_batch_id) {
                $query->where('join_card_batch_id', $join_card_batch_id);
            })->when(!empty($join_card_category_id), function ($query) use ($join_card_category_id) {
                $query->where('join_card_category_id', $join_card_category_id);
            })->when(!empty($join_card_member_id), function ($query) use ($join_card_member_id) {
                $query->where('join_card_member_id', $join_card_member_id);
            })->when(!empty($card_category), function ($query) use ($card_category) {
                $query->where('card_category', $card_category);
            })
            ->orderBy('card_id', 'DESC')
            ->forPage($page, $page_size)
            ->get()
            ->toArray();

        $total = $cardModel::select('card_id')
            ->when(!empty($card_name) && $card_name != '', function ($query) use ($card_name) {
                $query->where('card_name', 'like', '%' . $card_name . '%');
            })->when(!empty($card_status), function ($query) use ($card_status) {
                $query->where('card_status', $card_status);
            })->when(!empty($join_card_batch_id), function ($query) use ($join_card_batch_id) {
                $query->where('join_card_batch_id', $join_card_batch_id);
            })->when(!empty($join_card_category_id), function ($query) use ($join_card_category_id) {
                $query->where('join_card_category_id', $join_card_category_id);
            })->when(!empty($join_card_member_id), function ($query) use ($join_card_member_id) {
                $query->where('join_card_member_id', $join_card_member_id);
            })->when(!empty($card_category), function ($query) use ($card_category) {
                $query->where('card_category', $card_category);
            })
            ->count();
        if (!empty($rows)) {
            foreach ($rows as $key => &$value) {
                $value['card_status_value'] = $value['card_status'];
                $value['card_status'] = array_flip(Card::CARD_STATUS)[$value['card_status']];
                !empty($value['card_json']) && $value['card_json'] = json_decode($value['card_json'], true);
                !empty($value['card_assign_json']) && $value['card_assign_json'] = json_decode($value['card_assign_json'], true);
                !empty($value['card_process_json']) && $value['card_process_json'] = json_decode($value['card_process_json'], true);
                !empty($value['card_extend_json']) && $value['card_extend_json'] = json_decode($value['card_extend_json'], true);
            }

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


    /**
     * Notes: 储值卡详情
     * User: ZhouBenXu
     * DateTime: 2024/6/28 上午11:41
     * @param $card_id
     * @return \support\Response
     */
    public static function getInfo($card_id)
    {
        $cardInfo = Card::where('card_id', $card_id)->first() ?? [];
        if (!empty($cardInfo)) {
            $cardInfo['card_status_value'] = $cardInfo['card_status'];
            $cardInfo['card_status'] = array_flip(Card::CARD_STATUS)[$cardInfo['card_status']];
            !empty($cardInfo['card_json']) && $cardInfo['card_json'] = json_decode($cardInfo['card_json'], true);
            !empty($cardInfo['card_assign_json']) && $cardInfo['card_assign_json'] = json_decode($cardInfo['card_assign_json'], true);
            !empty($cardInfo['card_process_json']) && $cardInfo['card_process_json'] = json_decode($cardInfo['card_process_json'], true);
            !empty($cardInfo['card_extend_json']) && $cardInfo['card_extend_json'] = json_decode($cardInfo['card_extend_json'], true);
        }
        return json_success('', $cardInfo);
    }

}