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 = '
分销对接文档
分销对接文档
';
// 使用 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];
}
}
}