12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273 |
- const express = require('express');
- const router = express.Router();
- const utils = require("../utils/index.js");
- const pools = require("../utils/pools.js");
- //添加文件
- router.post("/addFile", async (req, res) => {
- let sql = "INSERT INTO files(val,type) VALUES (?,?)",
- obj = req.body;
- await pools({sql,val:[obj.val, obj.type],run:false,res,req});
- });
- //查询图片
- router.post("/getImg", async (req, res) => {
- let sql = `SELECT id,val,update_time AS updateTime,create_time AS createTime FROM files WHERE type=1`,obj=req.body;
- let {total}=await utils.getSum({sql,name:"files",res,req});
- sql+=` ORDER BY id DESC`;
- sql=utils.pageSize(sql,obj.page,obj.size);
- let {result}=await pools({sql,res,req});
- res.send(utils.returnData({ data: result ,total}));
- });
- //查询文件
- router.post("/getFile", async (req, res) => {
- let sql = `SELECT id,val,update_time AS updateTime,create_time AS createTime FROM files WHERE type=2`,obj=req.body;
- let {total}=await utils.getSum({sql,name:"files",res,req});
- sql+=` ORDER BY id DESC`;
- sql=utils.pageSize(sql,obj.page,obj.size);
- let {result}=await pools({sql,res,req});
- res.send(utils.returnData({ data: result ,total}));
- });
- //修改文件
- router.post("/upFile", async (req, res) => {
- let sql = "UPDATE files SET val=? WHERE id=?",
- obj = req.body;
- await pools({sql,val:[obj.val,obj.id],run:false,res,req});
- });
- //删除文件
- router.post("/delFile", async (req, res) => {
- let sql = "DELETE FROM files WHERE id=?",
- obj = req.body;
- await pools({sql,val:[obj.id],run:false,res,req});
- });
- //添加富文本
- router.post("/addDitor", async (req, res) => {
- let sql = "INSERT INTO ditor(val) VALUES (?)",
- obj = req.body;
- await pools({sql,val:[obj.val],run:false,res,req});
- });
- //查询富文本
- router.post("/getDitor", async (req, res) => {
- let sql = `SELECT id,val,update_time AS updateTime,create_time AS createTime FROM ditor WHERE 1=1`,obj=req.body;
- let {total}=await utils.getSum({sql,name:"ditor",res,req});
- sql+=` ORDER BY id DESC`;
- sql=utils.pageSize(sql,obj.page,obj.size);
- let {result}=await pools({sql,res,req});
- res.send(utils.returnData({ data: result ,total}));
- });
- //修改富文本
- router.post("/upDitor", async (req, res) => {
- let sql = "UPDATE ditor SET val=? WHERE id=?",
- obj = req.body;
- await pools({sql,val:[obj.val,obj.id],run:false,res,req});
- });
- //删除富文本
- router.post("/delDitor", async (req, res) => {
- let sql = "DELETE FROM ditor WHERE id=?",
- obj = req.body;
- await pools({sql,val:[obj.id],run:false,res,req});
- });
- module.exports = router;
|