BroadbandSaler/app/DataApiNew/Helper/AgentApiHelper.php

<?php
/*
 * @Description: 用户接口配置
 * @Version: *
 * @Autor: lexuan
 * @Date: 2024-12-06 08:43:11
 * @LastEditors: lexuan
 * @LastEditTime: 2024-12-06 08:43:11
 */

namespace App\DataApiNew\Helper;

use App\DataApiNew\Models\AgentApi;
use App\Models\Pages;
use App\Models\SpoutExport;
use App\Models\SpoutImport;
use App\DataApiNew\Models\AdminUsers;
use Illuminate\Http\Request;
use Vinkla\Hashids\Facades\Hashids;

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

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

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

        $result = $page->paginate();

        return $result;
    }

    // 导出
    public function export(Request $request)
    {
        $query = AgentApi::select(AgentApi::$selectFields);
        $query = $this->whens($query, $request);
        $query->orderBy('created_at', 'desc');
        $header = [
            '用户id' => 'user_id',
            '私钥' => 'private_key',
            '公钥' => 'public_key',
            '文档文件' => 'document_path',
            '状态 0禁止 1允许' => 'status',
            '创建时间' => 'created_at',
            '更新时间' => 'updated_at',
            '删除时间' => 'deleted_at',
            '备注' => 'remark',
        ];
        $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',
            '私钥' => 'private_key',
            '公钥' => 'public_key',
            '文档文件' => 'document_path',
            '状态 0禁止 1允许' => 'status',
            '创建时间' => 'created_at',
            '更新时间' => 'updated_at',
            '删除时间' => 'deleted_at',
            '备注' => 'remark',
        ];
        $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 = AgentApi::where(['id' => $request->id])->select(AgentApi::$selectFields)->first();
        return success($result);
    }

    // 添加
    public function insert(Request $request)
    {
        $request->validate([
            'user_id' => 'required|integer',
        ]);

        sys_log($request, '用户接口配置添加', '用户接口配置');

        $user = AdminUsers::find($request->user_id);
        if (empty($user)) {
            return error("用户不存在");
        }

        $exist = AgentApi::where(['user_id' => $request->user_id])->exists();
        if ($exist) {
            return ['code' => 0, 'msg' => "已存在"];
        }

        $data = $request->all();

        if (empty($data['private_key']) && empty($data['public_key'])) {
            $rsa = UtilsHelper::generateRSAKeys();
            $data['private_key'] = $rsa['privateKey'];
            $data['public_key'] = $rsa['publicKey'];
        }

        $data['user_key'] = Hashids::encode($data['user_id']);

        $result = AgentApi::create($data);

        if ($result) {
            return success();
        } else {
            return error();
        }
    }

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

        $result = AgentApi::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 = AgentApi::whereIn('id', $arr)->delete();
        if ($result) {
            return success();
        } else {
            return error();
        }
    }

    // 生成对接文档
    public function generateDoc(Request $request)
    {
        $request->validate([
            'id' => 'required|integer',
        ]);

        sys_log($request, '生成对接文档', '用户接口配置');

        // 获取信息
        $info = AgentApi::where(['id' => $request->id])->first();
        if (!$info) {
            return ['code' => 0, 'msg' => "生成失败"];
        }

        // 模板内容 (HTML格式)
        $content = '
        <!DOCTYPE html>
        <html lang="zh-CN">
        <head>
            <meta charset="UTF-8">
            <meta name="viewport" content="width=device-width, initial-scale=1.0">
            <title>分销对接文档</title>
            <style>
                body { font-family: Arial, sans-serif; line-height: 1.6; margin: 0; padding: 20px; }
                h1 { color: #333; text-align: center; }
                .content { max-width: 800px; margin: 0 auto; padding: 20px; border: 1px solid #ddd; border-radius: 8px; background-color: #f9f9f9; }
                .section { margin-bottom: 20px; }
                .label { font-weight: bold; color: #555; }
                .value { font-size: 14px; color: #333; }
                pre { white-space: pre-wrap; word-wrap: break-word; }
            </style>
        </head>
        <body>
            <h1>分销对接文档</h1>
            <div class="content">
                <div class="section">
                    <span class="label">接口文档：</span>
                    <span class="value">
                        <a href="%s" target="_blank" style="color: #007bff; text-decoration: none;">%s</a>
                    </span>
                </div>
                <div class="section">
                    <span class="label">用户秘钥：</span>
                    <span class="value">%s</span>
                </div>
                <div class="section">
                    <span class="label">私钥：</span>
                    <pre class="value">%s</pre>
                </div>
            </div>
        </body>
        </html>
        ';

        // 使用 sprintf 填充模板
        $api_document = "https://doc.apipost.net/docs/detail/376e060b3c06000?target_id=50c37c5";
        $document = sprintf($content, $api_document, $api_document, $info->user_key, $info->private_key);

        if($request->input('download',false)){
            // 设置响应头并输出文件
            return response($document)
            ->header('Content-Type', 'text/html')
            ->header('Content-Disposition', 'attachment; filename*=utf-8\'\''
                . urlencode('分销对接文档-'.$info->user_key.'.html'));
        }else{
            // 定义文件路径
            UtilsHelper::ensureDirectoryExists("api_doc");
            $fileName = "/api_doc/" . $info->user_key . '.html';
            $filePath = public_path() . $fileName;

            // 将内容写入文件
            file_put_contents($filePath, $document);

            return ['code' => 1, 'msg' => "Document generated successfully", 'path' => config('app.url') . $fileName];
        }
    }
}