352 lines
12 KiB
TypeScript
352 lines
12 KiB
TypeScript
import express from "express"
|
|
export const xlsxTemplateRoute = express.Router()
|
|
|
|
import { mimeToExtension, templateOption } from "./report-template"
|
|
import { ExcelTemplate } from "xlsx-template-next"
|
|
import fs from "fs"
|
|
import { LibreOfficeFileConverter } from "libreoffice-file-converter"
|
|
const TEMPLATE_FOLDER_NAME = "templates/xlsx"
|
|
|
|
/**
|
|
* xlsxTemplate Uses xlsx-template-next to convert input data and template to output buffer.
|
|
* You have to handle exception throw by function
|
|
* template keep in folder templates
|
|
* @param {Buffer|String} t template in buffer format or path to file
|
|
* @param {templateOption} tdata Template Information in JSON format
|
|
* @param {String} outputMediaType output extension
|
|
* @param {Number} tab tab page of spread sheet , default = 1
|
|
* @return {Promise<Uint8Array>} output buffer after apply template.
|
|
*/
|
|
export async function xlsxTemplateX(
|
|
t: Buffer | String,
|
|
tdata: templateOption,
|
|
outputMediaType: string = "xlsx",
|
|
tab: number = 1
|
|
): Promise<Uint8Array> {
|
|
try {
|
|
const templateBuff = Buffer.isBuffer(t)
|
|
? t
|
|
: await fs.promises.readFile(String(t))
|
|
const template = new ExcelTemplate()
|
|
await template.load(templateBuff)
|
|
await template.process(tab, tdata.data)
|
|
const buffer = (await template.build({ type: "uint8array" })) as Uint8Array
|
|
if (outputMediaType === "xlsx") return buffer
|
|
|
|
const libreOfficeFileConverter = new LibreOfficeFileConverter({
|
|
childProcessOptions: {
|
|
timeout: 60 * 1000,
|
|
},
|
|
})
|
|
//const lbuffer = await libreOfficeFileConverter.convertBuffer(Buffer.from(buffer as Uint8Array), outputMediaType)
|
|
|
|
const lbuffer = await libreOfficeFileConverter.convert({
|
|
buffer: Buffer.from(buffer),
|
|
format: outputMediaType,
|
|
input: "buffer",
|
|
output: "buffer",
|
|
})
|
|
|
|
return lbuffer
|
|
} catch (e) {
|
|
throw e
|
|
}
|
|
}
|
|
|
|
/** javascript-obfuscator:disable
|
|
* @swagger
|
|
* /api/v1/report-template/xlsx:
|
|
* get:
|
|
* summary: แสดงรายการ xlsx template
|
|
* tags: [report-template]
|
|
* responses:
|
|
* 200:
|
|
* description: array of template
|
|
* content:
|
|
* applicatin/json:
|
|
* schema:
|
|
* type: array
|
|
* items:
|
|
* type: string
|
|
* example: ["hello"]
|
|
* 500:
|
|
* description: Server error
|
|
*/
|
|
xlsxTemplateRoute.get("/", async function (req, res) {
|
|
try {
|
|
const fileList = await fs.promises.readdir(`./${TEMPLATE_FOLDER_NAME}`)
|
|
const templateList = fileList.map((f) => f.split(".xlsx")[0])
|
|
res.send(templateList)
|
|
} catch (ex) {
|
|
res.statusCode = 500
|
|
res.statusMessage = "Internal Server Error during get xlsx template list"
|
|
res.end(res.statusMessage)
|
|
console.error("Error during get template list: ", ex)
|
|
}
|
|
})
|
|
|
|
/** javascript-obfuscator:disable
|
|
* @swagger
|
|
* /api/v1/report-template/xlsx:
|
|
* post:
|
|
* summary: สร้างเอกสารจาก xlsx template แล้วส่งกลับมาเป็น xlsx pdf odt , ค่า template เป็นชื่อของ template ที่ใช้งาน, reportName เป็นชื่อไฟล์ที่ต้องการ
|
|
* tags: [report-template]
|
|
* parameters:
|
|
* - name: folder
|
|
* in: query
|
|
* description: ชื่อโฟลเดอร์
|
|
* required: false
|
|
* schema:
|
|
* type: string
|
|
* example: test
|
|
* requestBody:
|
|
* required: true
|
|
* content:
|
|
* application/json:
|
|
* schema:
|
|
* $ref: '#/components/schemas/templateOption'
|
|
* example:
|
|
* template: hello
|
|
* reportName: xlsx-report
|
|
* data: {"docNo": "๑๒๓๔๕","me": "กระผม","prefix": "นาย","name": "สรวิชญ์","surname": "พลสิทธิ์","position": "Chief Technology Officer","org": {"type": "บริษัท","name": "เฟรปเป้ที","url": "https://frappet.com"},"employees": [{"id":1,"name": "ภาวิชญ์","surname": "พลสิทธิ์","score":80},{"id":2,"name": "วิชญาภา","surname": "พลสิทธิ์","score":50},{"id":3,"name": "ฐิตาภา","surname": "พลสิทธิ์","score":90},{"id":4,"name": "สรวิชญ์ พลสิทธิ์","surname": "พลสิทธิ์","score":99}]}
|
|
* responses:
|
|
* 201:
|
|
* description: เอกสารถูกสร้างขึ้น created.
|
|
* content:
|
|
* application/vnd.openxmlformats-officedocument.spreadsheetml.sheet:
|
|
* schema:
|
|
* type: string
|
|
* format: binary
|
|
* application/pdf:
|
|
* schema:
|
|
* type: string
|
|
* format: binary
|
|
* application/vnd.ms-excel:
|
|
* schema:
|
|
* type: string
|
|
* format: binary
|
|
* application/vnd.oasis.opendocument.spreadsheet:
|
|
* schema:
|
|
* type: string
|
|
* format: binary
|
|
* image/png:
|
|
* schema:
|
|
* type: string
|
|
* format: binary
|
|
* image/jpeg:
|
|
* schema:
|
|
* type: string
|
|
* format: binary
|
|
* 500:
|
|
* description: Server error
|
|
*
|
|
*/
|
|
xlsxTemplateRoute.post("/", async function (req, res) {
|
|
try {
|
|
if (!req.headers["content-type"] || !req.headers["accept"])
|
|
throw new Error("Require header content-type, accept")
|
|
let inputType = mimeToExtension(req.headers["content-type"])
|
|
let outputMediaType = mimeToExtension(req.headers["accept"])
|
|
let template = null
|
|
// Save the converted file to disk
|
|
if (req.query["folder"]) {
|
|
template = await fs.promises.readFile(
|
|
`./${TEMPLATE_FOLDER_NAME}/${req.query["folder"]}/${req.body.template}.xlsx`
|
|
)
|
|
} else {
|
|
template = await fs.promises.readFile(
|
|
`./${TEMPLATE_FOLDER_NAME}/${req.body.template}.xlsx`
|
|
)
|
|
}
|
|
let buffer = await xlsxTemplateX(template, req.body, outputMediaType)
|
|
res.statusCode = 201
|
|
res.setHeader("Content-Type", req.headers["accept"])
|
|
res.setHeader(
|
|
"Content-Disposition",
|
|
`attachment;filename=${req.body.reportName}.${outputMediaType}`
|
|
)
|
|
res.setHeader("Content-Length", buffer.length)
|
|
res.end(buffer)
|
|
} catch (ex) {
|
|
if (ex instanceof SyntaxError) {
|
|
res.statusCode = 400
|
|
res.statusMessage = ex.message
|
|
res.end(res.statusMessage)
|
|
console.error("report-template/xlsx: ", ex)
|
|
} else {
|
|
res.statusCode = 500
|
|
res.statusMessage =
|
|
"Internal Server Error during POST report-template/xlsx"
|
|
res.end(res.statusMessage)
|
|
console.error("report-template/xlsx: ", ex)
|
|
}
|
|
}
|
|
})
|
|
|
|
/** javascript-obfuscator:disable
|
|
* @swagger
|
|
* /api/v1/report-template/xlsx/upload:
|
|
* post:
|
|
* summary: อัพไฟล์ xlsx
|
|
* tags: [report-template]
|
|
* parameters:
|
|
* - name: report_name
|
|
* in: query
|
|
* description: ชื่อไฟล์
|
|
* required: true
|
|
* schema:
|
|
* type: string
|
|
* example: report
|
|
* - name: folder
|
|
* in: query
|
|
* description: ชื่อโฟลเดอร์
|
|
* required: false
|
|
* schema:
|
|
* type: string
|
|
* example: test
|
|
* requestBody:
|
|
* required: true
|
|
* content:
|
|
* application/octet-stream:
|
|
* schema:
|
|
* type: string
|
|
* format: binary
|
|
* responses:
|
|
* 201:
|
|
* description: file was converted.
|
|
* content:
|
|
* application/octet-stream:
|
|
* schema:
|
|
* type: string
|
|
* format: binary
|
|
* 400:
|
|
* description: Invalid format
|
|
* 500:
|
|
* description: Server error
|
|
*
|
|
*/
|
|
xlsxTemplateRoute.post("/upload", async function (req, res) {
|
|
try {
|
|
if (
|
|
!req.headers["content-type"] ||
|
|
!req.headers["accept"] ||
|
|
!req.query["report_name"] ||
|
|
req.headers["content-type"] !== "application/octet-stream"
|
|
) {
|
|
res.statusCode = 400
|
|
res.statusMessage =
|
|
"Require header: content-type(application/octet-stream) accept"
|
|
res.end(res.statusMessage)
|
|
console.log(
|
|
req.headers["content-type"],
|
|
req.headers["accept"],
|
|
req.query["report_name"]
|
|
)
|
|
return
|
|
}
|
|
// Determine the output media type and report name from headers
|
|
let outputMediaType = mimeToExtension(req.headers["accept"])
|
|
let reportName = req.query["report_name"]
|
|
console.log("convert output: " + outputMediaType)
|
|
|
|
// Save the converted file to disk
|
|
if (req.query["folder"]) {
|
|
// Ensure the template folder exists
|
|
await fs.promises.mkdir(`TEMPLATE_FOLDER_NAME/${req.query["folder"]}`, {
|
|
recursive: true,
|
|
})
|
|
await fs.promises.writeFile(
|
|
`./${TEMPLATE_FOLDER_NAME}/${req.query["folder"]}/${reportName}.xlsx`,
|
|
req.body
|
|
)
|
|
} else {
|
|
// Ensure the template folder exists
|
|
await fs.promises.mkdir(TEMPLATE_FOLDER_NAME, { recursive: true })
|
|
await fs.promises.writeFile(
|
|
`./${TEMPLATE_FOLDER_NAME}/${reportName}.xlsx`,
|
|
req.body
|
|
)
|
|
}
|
|
|
|
// Send a response to the client
|
|
res.statusCode = 201
|
|
res.json({ message: "File converted and saved successfully" })
|
|
} catch (ex) {
|
|
res.statusCode = 500
|
|
res.statusMessage = "Internal Server Error"
|
|
res.end(res.statusMessage)
|
|
console.error(`Error during convert with soffice:`, ex)
|
|
}
|
|
})
|
|
|
|
/** javascript-obfuscator:disable
|
|
* @swagger
|
|
* /api/v1/report-template/xlsx/download:
|
|
* post:
|
|
* summary: โหลดไฟล์ xlsx
|
|
* tags: [report-template]
|
|
* parameters:
|
|
* - name: folder
|
|
* in: query
|
|
* description: ชื่อโฟลเดอร์
|
|
* required: false
|
|
* schema:
|
|
* type: string
|
|
* example: test
|
|
* requestBody:
|
|
* required: true
|
|
* content:
|
|
* application/json:
|
|
* schema:
|
|
* $ref: '#/components/schemas/templateOption'
|
|
* example:
|
|
* template: xlsx-report
|
|
* responses:
|
|
* 201:
|
|
* description: เอกสารถูกสร้างขึ้น
|
|
* content:
|
|
* application/vnd.openxmlformats-officedocument.spreadsheetml.sheet:
|
|
* schema:
|
|
* type: string
|
|
* format: binary
|
|
* 500:
|
|
* description: Server error
|
|
*
|
|
*/
|
|
xlsxTemplateRoute.post("/download", async function (req, res) {
|
|
try {
|
|
if (
|
|
!req.headers["content-type"] ||
|
|
!req.headers["accept"] ||
|
|
!req.body.template
|
|
)
|
|
throw new Error("Require header content-type, accept")
|
|
let inputType = mimeToExtension(req.headers["content-type"])
|
|
let outputMediaType = mimeToExtension(req.headers["accept"])
|
|
console.log("content-type: ", inputType)
|
|
console.log("accept: ", outputMediaType)
|
|
let buffer = null
|
|
if (req.query["folder"]) {
|
|
buffer = await fs.promises.readFile(
|
|
`./${TEMPLATE_FOLDER_NAME}/${req.query["folder"]}/${req.body.template}.xlsx`
|
|
)
|
|
} else {
|
|
buffer = await fs.promises.readFile(
|
|
`./${TEMPLATE_FOLDER_NAME}/${req.body.template}.xlsx`
|
|
)
|
|
}
|
|
res.statusCode = 201
|
|
res.setHeader("Content-Type", req.headers["accept"])
|
|
res.setHeader(
|
|
"Content-Disposition",
|
|
`attachment;filename=${req.body.template}.${outputMediaType}`
|
|
)
|
|
res.setHeader("Content-Length", buffer.length)
|
|
res.end(buffer)
|
|
} catch (ex) {
|
|
res.statusCode = 500
|
|
res.statusMessage = "Internal Server Error during get xlsx template list"
|
|
res.end(res.statusMessage)
|
|
console.error("Error during apply template: ", ex)
|
|
}
|
|
})
|