BroadbandSaler/app/DataApiNew/Helper/UserShopSettingHelper.php

<?php
/*
 * @Description: 用户小店设置
 * @Version: *
 * @Autor: lexuan
 * @Date: 2024-12-10 13:33:43
 * @LastEditors: lexuan
 * @LastEditTime: 2024-12-10 13:33:43
 */

namespace App\DataApiNew\Helper;

use App\DataApiNew\Models\UserShopSetting;
use App\Models\Pages;
use App\Models\SpoutExport;
use App\Models\SpoutImport;
use Illuminate\Http\Request;

class UserShopSettingHelper
{
    // 查询条件
    public function whens($query, $request)
    {
        return $query
            ->when($request->filled('id'), fn ($q) => $q->where('id', $request->id))
            ->when($request->filled('shop_name'), fn ($q) => $q->where('shop_name', $request->shop_name));
    }

    // 查询列表
    public function select(Request $request)
    {
        $page = new Pages($request, UserShopSetting::query());

        $page->before(function ($query) use ($request) {
            $query->select(UserShopSetting::$selectFields);
            return $this->whens($query, $request);
        });

        $result = $page->paginate();

        return $result;
    }

    // 导出
    public function export(Request $request)
    {
        $query = UserShopSetting::select(UserShopSetting::$selectFields);
        $query = $this->whens($query, $request);
        $query->orderBy('created_at', 'desc');
        $header = [
            '用户id' => 'user_id',
            '小店名称' => 'shop_name',
            '小店头像' => 'shop_avatar',
            '小店背景图' => 'shop_bg',
            '小店介绍' => 'shop_desc',
            '状态' => 'status',
            '创建时间' => 'created_at',
            '更新时间' => 'updated_at',
            '删除时间' => 'deleted_at',
            '客服联系方式' => 'kefu',
        ];
        $getEnValue = $this->getEnValue();

        $excel = new SpoutExport($header);
        $excel->setData($query->get());
        $result = $excel->setEnum($getEnValue)->spoutToExcel('excel_out');

        return $result ? success($result['url']) : error();
    }

    // 导入
    public function import(Request $request)
    {
        $header = [
            '用户id' => 'user_id',
            '小店名称' => 'shop_name',
            '小店头像' => 'shop_avatar',
            '小店背景图' => 'shop_bg',
            '小店介绍' => 'shop_desc',
            '状态' => 'status',
            '创建时间' => 'created_at',
            '更新时间' => 'updated_at',
            '删除时间' => 'deleted_at',
            '客服联系方式' => 'kefu',
        ];
        $SpoutImport = new SpoutImport($header);
        $dataList = $SpoutImport->setRequest($request)->getExcelData();
        return $dataList;
    }

    // 获取枚举值
    public function getEnValue()
    {
        $data = [];
        return $data;
    }

    // 查询一条
    public function find(Request $request)
    {
        $request->validate([
            'id' => 'required|integer',
        ]);
        $result = UserShopSetting::where(['id' => $request->id])->select(UserShopSetting::$selectFields)->first();
        return success($result);
    }

    // 添加
    public function insert(Request $request)
    {
        $request->validate([
            // 'name' => 'required',
        ]);
        $result = UserShopSetting::create($request->all());
        if ($result) {
            return success();
        } else {
            return error();
        }
    }

    // 修改
    public function update(Request $request)
    {
        $request->validate([
            'id' => 'required|integer',
        ]);

        $result = UserShopSetting::where(['id' => $request->id])->update($request->all());
        if ($result) {
            return success();
        } else {
            return error();
        }
    }

    // 删除
    public function delete(Request $request)
    {
        $request->validate([
            'ids' => 'required',
        ]);
        $id_str = $request->ids;
        $arr = explode(",", $id_str);
        // 查询是否存在子数据
        // $count = Shop::whereIn('tm_id',$arr)->count();
        // if($count > 0){
        //     return ['code'=>0,'msg'=>"存在子数据，禁止删除"];
        // }
        $result = UserShopSetting::whereIn('id', $arr)->delete();
        if ($result) {
            return success();
        } else {
            return error();
        }
    }

    // 用户设置小店配置
    public function userShopSetting(Request $request)
    {
        $user_id = $request->user()->id;
        $shopSetting = UserShopSetting::where(['user_id' => $user_id])->first();
        if (!$shopSetting) {
            $result = UserShopSetting::create([
                'user_id' => $user_id, // 用户id
                'shop_name' => $request->input('shop_name', null), // 小店名称
                'shop_avatar' => $request->input('shop_avatar', null), // 小店头像
                'shop_bg' => $request->input('shop_bg', null), // 小店背景图
                'shop_desc' => $request->input('shop_desc', null), // 小店介绍
                'kefu_phone' => $request->input('kefu_phone', null), // 客服电话
                'kefu_wechat' => $request->input('kefu_wechat', null), // 客服微信
            ]);
        } else {
            $result = $shopSetting->update([
                'shop_name' => $request->input('shop_name', $shopSetting->shop_name), // 小店名称
                'shop_avatar' => $request->input('shop_avatar', $shopSetting->shop_avatar), // 小店头像
                'shop_bg' => $request->input('shop_bg', $shopSetting->shop_bg), // 小店背景图
                'shop_desc' => $request->input('shop_desc', $shopSetting->shop_desc), // 小店介绍
                'kefu_phone' => $request->input('kefu_phone', $shopSetting->kefu_phone), // 客服电话
                'kefu_wechat' => $request->input('kefu_wechat', $shopSetting->kefu_wechat), // 客服微信
            ]);
        }

        return $result ? ['code' => 1, 'msg' => 'success'] : ['code' => 0, 'msg' => 'error'];
    }

    // 获取用户设置的小店配置
    public function getUserShopSetting(Request $request)
    {
        $user_id = $request->user()->id;
        $shopSetting = UserShopSetting::select([
            'shop_name', // 小店名称
            'shop_avatar', // 小店头像
            'shop_bg', // 小店背景图
            'shop_desc', // 小店介绍
            'kefu_phone', // 客服电话
            'kefu_wechat', // 客服微信
        ])->where(['user_id' => $user_id])->first();
        return ['code' => 1, 'msg' => 'success', 'data' => $shopSetting];
    }
}