index.js 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544
  1. const fs = require('fs')
  2. const path = require('path')
  3. const compressing = require('compressing')
  4. const rimrif = require('rimraf')
  5. const shell = require('shelljs');
  6. const crypto = require('crypto');
  7. // 文档模板生成
  8. const PizZip = require("pizzip");
  9. const Docxtemplater = require("docxtemplater");
  10. // 文档转换
  11. import { Chromiumly } from "chromiumly";
  12. // Chromiumly.configure({ endpoint: "http://8.140.98.43/docs" });
  13. Chromiumly.configure({ endpoint: "http://123.57.204.89/docs" });
  14. import { PDFEngines } from "chromiumly";
  15. const { LibreOffice } = require("chromiumly");
  16. // const { PDFEngines } = require("chromiumly");
  17. const tempDir = path.join(__dirname , "temp");
  18. if(!fs.existsSync(tempDir)){fs.mkdirSync(tempDir)};
  19. const OSS = require("ali-oss");
  20. const ALI_OSS_BUCKET = process.env.ALI_OSS_BUCKET || "hep-textbook"
  21. const ALI_OSS_ACCESS_KEY_ID = process.env.ALI_OSS_ACCESS_KEY_ID || "LTAI5t6AbTiAvXmeoVdJZhL3"
  22. const ALI_OSS_ACCESS_KEY_SECRET = process.env.ALI_OSS_ACCESS_KEY_SECRET || "KLtQRdIW69KLP7jnzHNUf7eKmdptxH"
  23. const bwipjs = require("bwip-js")
  24. export async function toBarCode(text){
  25. return new Promise(resolve=>{
  26. bwipjs.toBuffer({
  27. bcid:"code128",
  28. text:text,
  29. scale:1.5,
  30. height:3,
  31. includetext:false,
  32. textalign:"center"
  33. },(err,png)=>{
  34. if(err){
  35. console.error(err)
  36. resolve(null)
  37. }else{
  38. resolve(png)
  39. }
  40. })
  41. })
  42. }
  43. export async function uploadFileToOSS(filePath,uniqueId){
  44. uniqueId = uniqueId || ""
  45. let client = new OSS({
  46. // yourRegion填写Bucket所在地域。以华东1(杭州)为例,yourRegion填写为oss-cn-hangzhou。
  47. region: "oss-cn-beijing",
  48. accessKeyId: ALI_OSS_ACCESS_KEY_ID,
  49. accessKeySecret: ALI_OSS_ACCESS_KEY_SECRET,
  50. // 填写Bucket名称。
  51. bucket: ALI_OSS_BUCKET || "hep-textbook",
  52. timeout:5000*1000
  53. });
  54. let now = new Date();
  55. let fileName = getFileName(filePath);
  56. let fileKey = `export/report/${uniqueId}/${fileName}`;
  57. const r1 = await client?.put(fileKey, filePath);
  58. console.log('put success: %j', r1);
  59. return r1
  60. }
  61. export function getFileName(filePath) {
  62. // 使用 '/' 或 '\' 作为分隔符,分割路径
  63. const parts = filePath.split(/[/\\]/);
  64. // 返回最后一个部分,即文件名
  65. return parts.pop();
  66. }
  67. module.exports.uploadFileToOSS = uploadFileToOSS
  68. /**
  69. * 将给定的文件路径数组打包成指定名称的zip压缩包
  70. * @param {Array<string>} filePathList - 要打包的文件路径数组
  71. * @param {string} outputZipName - 输出的zip文件名称
  72. */
  73. export function createZip(filePathList, outputZipName,options) {
  74. let zipStream = new compressing.zip.Stream();
  75. return new Promise((resolve)=>{
  76. try {
  77. let outputPath = path.join(options?.tempDir||tempDir,outputZipName)
  78. // 遍历文件路径列表,将每个文件添加到zip流中
  79. for (const filePath of filePathList) {
  80. // 检查文件是否存在
  81. if (fs.existsSync(filePath)) {
  82. // 将文件添加到zip流中
  83. zipStream.addEntry(filePath);
  84. } else {
  85. console.error(`文件不存在: ${filePath}`);
  86. }
  87. }
  88. // 创建一个写入流
  89. const output = fs.createWriteStream(outputPath);
  90. // 使用 compressing 库的 zip 方法将文件打包
  91. // console.log(filePathList)
  92. // await compressing.zip.compressDir(filePathList, output);
  93. // 将zip流写入文件
  94. zipStream.pipe(output);
  95. output.on('finish', () => {
  96. // console.log(`成功创建压缩包: ${outputPath}`);
  97. resolve(outputPath)
  98. });
  99. output.on('error', (error) => {
  100. console.error('写入压缩包时出错:', error);
  101. resolve(null)
  102. });
  103. // console.log(`成功创建压缩包: ${outputPath}`);
  104. // return outputPath
  105. } catch (error) {
  106. console.error('创建压缩包时出错:', error);
  107. return null
  108. }
  109. })
  110. }
  111. module.exports.createZip = createZip
  112. const download = require('download')
  113. export async function downloadUrl(url,options) {
  114. if(!fs.existsSync(options?.tempDir)) fs.mkdirSync(options?.tempDir);
  115. // console.log(url)
  116. if(url?.startsWith("/")) {return url};
  117. // 保留文件名
  118. let filename = ""
  119. if(options?.keepFileName){
  120. filename = decodeURIComponent(path.basename(url));
  121. }else{
  122. // 文件名转MD5
  123. let md5 = crypto.createHash('md5');
  124. let extname = path.extname(url)?.toLocaleLowerCase();
  125. filename = md5.update(url).digest('hex') + extname;
  126. }
  127. let filepath = path.join(options?.tempDir||tempDir,filename)
  128. // console.log(filename,filepath)
  129. try{
  130. // if(fs.existsSync(filepath)){fs.rmSync(filepath)} // 存在则删除
  131. if(fs.existsSync(filepath)){return filepath} // 存在则直接返回(md5相同)
  132. fs.writeFileSync(filepath, await download(url));
  133. return filepath
  134. }catch(err){
  135. console.error(err)
  136. return null
  137. }
  138. }
  139. /**
  140. * 将 DOCX 文件转换为 PDF
  141. *
  142. * @param {string} docxPath - 要转换的 DOCX 文件的路径
  143. * @param {string} outputPath - 输出 PDF 文件的路径
  144. * @returns {Promise<void>}
  145. */
  146. export async function docxToPdf(docxPath, outputPath,options) {
  147. let mergeFiles = options?.mergeFiles || []
  148. let merge = false;
  149. let mergeFileMap = {};
  150. if(mergeFiles?.length){
  151. let plist = []
  152. for (let index = 0; index < mergeFiles.length; index++) {
  153. let filePath
  154. plist.push((async ()=>{
  155. try{
  156. filePath = await downloadUrl(mergeFiles[index],options);
  157. }catch(err){}
  158. if(filePath){
  159. mergeFileMap[index] = filePath // 按原有顺序整理
  160. // filePathList.push(filePath)
  161. }
  162. return
  163. })())
  164. }
  165. await Promise.all(plist);
  166. merge = true;
  167. }
  168. let filePathList = mergeFiles?.map((item,index)=>mergeFileMap[index]).filter(item=>item)
  169. // console.log("DOWNLOADED:",filePathList)
  170. filePathList = filePathList.map((filepath,index)=>{
  171. // 按顺序修改文件前缀数字为字母表顺序
  172. let fileDir = path.dirname(filepath);
  173. let abc = String.fromCharCode(96+(index+1)); // 字母顺序不会出现 把 1 10 11 12 放在一起的情况
  174. let num = index+110; // 数字顺序从百位开始,避免首数字排序错乱
  175. let md5 = crypto.createHash('md5');
  176. let outmd5 = md5.update(path.basename(filepath)).digest('hex');
  177. let fileName = num + "_" + outmd5 + path.extname(filepath);
  178. let orderPath = path.join(fileDir,fileName)
  179. fs.cpSync(filepath,orderPath);
  180. fs.readFileSync(filepath);
  181. return orderPath
  182. })
  183. try {
  184. let files = []
  185. if(docxPath){
  186. let docxBuffer = fs.readFileSync(docxPath);
  187. files.push({ data: docxBuffer, ext: "docx" })
  188. }
  189. files = [...files,...filePathList]
  190. // console.log("files",files)
  191. let convertOpts = {
  192. files,
  193. properties: {
  194. // 设置页面属性,例如纸张大小和方向
  195. pageSize: 'A4',
  196. // orientation: 'portrait',
  197. margin: {
  198. top: 0,
  199. right: 0,
  200. bottom: 0,
  201. left: 0
  202. }
  203. },
  204. pdfa: false, // 根据需要设置
  205. pdfUA: false, // 根据需要设置
  206. merge: merge, // 如果只转换一个文件,设置为false
  207. // metadata: {
  208. // // 你可以在这里添加元数据
  209. // },
  210. // losslessImageCompression: false,
  211. // reduceImageResolution: false,
  212. // quality: 90, // JPG 导出质量
  213. // maxImageResolution: 300 // 最大图像分辨率
  214. }
  215. // console.log("convertOpts",convertOpts)
  216. let pdfPath,pdfBuffer
  217. // 方式1:逐个合并
  218. // let pdfBuffer
  219. // for (let index = 1; index < files.length; index++) {
  220. // let file = files[index];
  221. // if(pdfBuffer){
  222. // convertOpts.files = [{data:pdfBuffer,ext:"pdf"},file]
  223. // }else{
  224. // convertOpts.files = [file]
  225. // }
  226. // pdfBuffer = await LibreOffice.convert(convertOpts);
  227. // }
  228. let mainPdfPath = docxPath
  229. if(docxPath){
  230. convertOpts.files = [files[0]];
  231. console.log(convertOpts)
  232. let mainPdfBuffer = await LibreOffice.convert(convertOpts);
  233. let md5 = crypto.createHash('md5');
  234. let outmd5 = md5.update(path.basename(docxPath)).digest('hex');
  235. mainPdfPath = path.dirname(docxPath)+"/109_"+outmd5+".pdf"
  236. fs.writeFileSync(mainPdfPath,mainPdfBuffer)
  237. }
  238. // 方式2:先合并pdf,后合并docx
  239. if(files?.length>=2){
  240. // console.log(files)
  241. let tmpFiles = files
  242. if(docxPath){
  243. tmpFiles = files.slice(1) // 携带首个docx时,从第二个开始
  244. }
  245. let pdfList = [mainPdfPath,...tmpFiles];
  246. pdfList = pdfList.filter(item=>item)
  247. let mergedFileList = await mergePdfListReduce(pdfList,convertOpts)
  248. pdfPath = mergedFileList[0];
  249. // convertOpts.files = [files[0],...mergedFileList]
  250. // console.log(convertOpts)
  251. // pdfBuffer = await LibreOffice.convert(convertOpts);
  252. }else{
  253. pdfBuffer = await LibreOffice.convert(convertOpts);
  254. }
  255. // 方式3:全部合并
  256. // let pdfBuffer = await LibreOffice.convert(convertOpts);
  257. if(pdfPath){
  258. fs.cpSync(pdfPath,outputPath);
  259. }
  260. // 将 Buffer 写入输出文件
  261. if(pdfBuffer){
  262. fs.writeFileSync(outputPath, pdfBuffer);
  263. console.log(`成功输出 ${outputPath}`);
  264. }
  265. return outputPath
  266. } catch (error) {
  267. console.error('转换失败:', error);
  268. return null
  269. }
  270. }
  271. module.exports.docxToPdf = docxToPdf
  272. const ImageModule = require("@slosarek/docxtemplater-image-module-free");
  273. const sizeOf = require("image-size");
  274. /**
  275. * 每三个pdf合并一次,直到合并为一个pdf为止
  276. * @param {} pdfList
  277. * @param {*} convertOpts
  278. * @returns
  279. */
  280. export async function mergePdfListReduce(pdfList,convertOpts){
  281. console.log("pdfList",pdfList)
  282. // 所有非PDF转PDF
  283. for (let index = 0; index < pdfList.length; index++) {
  284. let file = pdfList[index];
  285. if(typeof file == "string" && file?.toLocaleLowerCase()?.indexOf("pdf")==-1){
  286. convertOpts.files = [file];
  287. let pdfBuffer = await LibreOffice.convert(convertOpts);
  288. fs.writeFileSync(file+".pdf",pdfBuffer)
  289. pdfList[index] = file+".pdf"
  290. }
  291. }
  292. let mergeList = []
  293. let plist = []
  294. let length = pdfList.length
  295. for (let index = 0; index < length; index++) {
  296. let file = pdfList.shift();
  297. // console.log(file,index,length)
  298. if(!file) break;
  299. let files = [file,pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),
  300. pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),
  301. pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),
  302. pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),
  303. // pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),
  304. // pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),
  305. // pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),
  306. // ,pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift()
  307. // ,pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift()
  308. // ,pdfList.shift(),pdfList.shift(),pdfList.shift()
  309. // ,pdfList.shift(),pdfList.shift(),pdfList.shift()
  310. // ,pdfList.shift(),pdfList.shift(),pdfList.shift(),pdfList.shift()
  311. ]; // 每次合并四个
  312. files=files?.filter(item=>item);
  313. // console.log(files)
  314. plist.push(new Promise(async resolve=>{
  315. if(files?.length==1){ // 单文件直接加载 自动获取后缀
  316. let onefile = files[0]
  317. // if(!onefile?.ext){
  318. // let extname = path.extname(files[0]).slice(1)?.toLocaleLowerCase();
  319. // onefile = {data:fs.readFileSync(onefile),ext:extname}
  320. // }
  321. resolve(onefile);
  322. }else{ // 多文件合并
  323. convertOpts = {}
  324. convertOpts.files = files;
  325. // console.log("多文件合并",convertOpts)
  326. // pdfEngine合并
  327. if(false){
  328. let mergeBuffer = await PDFEngines.merge(convertOpts)
  329. let mergeFilePath = files[0]+".merge.pdf"
  330. fs.writeFileSync(mergeFilePath,mergeBuffer)
  331. resolve(mergeFilePath)
  332. }
  333. // pdfunite合并
  334. if(true){
  335. let mergeFilePath = files[0]+".merge.pdf"
  336. pdfUnite(files,mergeFilePath)
  337. resolve(mergeFilePath)
  338. }
  339. }
  340. }))
  341. }
  342. if(plist?.length){
  343. mergeList = await Promise.all(plist);
  344. }
  345. // console.log("mergeList",mergeList)
  346. if(mergeList?.length<=1){
  347. return mergeList;
  348. }else{
  349. // console.log("mergePdfListReduce continue:",mergeList)
  350. return await mergePdfListReduce(mergeList,convertOpts)
  351. }
  352. }
  353. function pdfUnite(pdfList,outputPath){
  354. let params = ["pdfunite",...pdfList,outputPath].join(" ")
  355. try{
  356. shell.exec(params)
  357. }catch(err){}
  358. if(fs.existsSync(outputPath)){
  359. return outputPath
  360. }else{
  361. throw "error: pdfunit merge error"
  362. }
  363. }
  364. export function renderDocx(inputDocxPath, outputDocxName, data,options){
  365. let imageOptions = {
  366. getImage(tagValue,tagName) {
  367. if(!fs.existsSync(tagValue)){
  368. throw new Error(`Image not found: ${tagValue}`);
  369. }
  370. return fs.readFileSync(tagValue);
  371. },
  372. getSize(img) {
  373. const sizeObj = sizeOf(img);
  374. console.log(sizeObj);
  375. return [sizeObj.width, sizeObj.height];
  376. },
  377. };
  378. let outputDocxPath = path.join(options?.tempDir||tempDir,outputDocxName)
  379. // Load the docx file as binary content
  380. let content = fs.readFileSync(
  381. inputDocxPath,
  382. "binary"
  383. );
  384. // Unzip the content of the file
  385. let zip = new PizZip(content);
  386. let doc = new Docxtemplater(zip, {
  387. paragraphLoop: true,
  388. linebreaks: true,
  389. modules: [new ImageModule(imageOptions)],
  390. });
  391. // Render the document (Replace {first_name} by John, {last_name} by Doe, ...)
  392. Object.keys(data).forEach(key=>{ // 除去空值
  393. if(data[key]==undefined){
  394. data[key] = ""
  395. }
  396. })
  397. doc.render(data);
  398. // Get the zip document and generate it as a nodebuffer
  399. let buf = doc.getZip().generate({
  400. type: "nodebuffer",
  401. // compression: DEFLATE adds a compression step.
  402. // For a 50MB output document, expect 500ms additional CPU time
  403. compression: "DEFLATE",
  404. });
  405. // buf is a nodejs Buffer, you can either write it to a
  406. // file or res.send it with express for example.
  407. fs.writeFileSync(outputDocxPath, buf);
  408. return outputDocxPath
  409. }
  410. /**
  411. * docx 替换模板字符串内容
  412. * @example
  413. // 要替换内容的模板
  414. let inputDocx = 'cs.docx'
  415. // 替换完成的docx文件
  416. let outputDocx = 'dd.docx'
  417. // {{xx}} 处要替换的内容
  418. let replaceData = {
  419. name: '替换name处的内容',
  420. age: '替换age处的内容',
  421. }
  422. replaceDocx(inputDocx, outputDocx, replaceData)
  423. */
  424. export function replaceDocx(inputDocxPath, outputDocxPath, options,eventMap) {
  425. return new Promise((resolve,reject)=>{
  426. // 解压出来的临时目录
  427. let md5 = crypto.createHash('md5');
  428. let outmd5 = md5.update(outputDocxPath).digest('hex')
  429. let tempDocxPath = path.join(options?.tempDir||tempDir , outmd5)
  430. // 要替换的xml文件位置
  431. let tempDocxXMLName = path.join(tempDocxPath,`word/document.xml`)
  432. // 压缩文件夹为文件
  433. let dir_to_docx = (inputFilePath, outputFilePath) => {
  434. outputFilePath = path.join(options?.tempDir||tempDir,outputFilePath)
  435. // 创建压缩流
  436. let zipStream = new compressing.zip.Stream()
  437. // 写出流
  438. let outStream = fs.createWriteStream(outputFilePath)
  439. fs.readdir(inputFilePath, null, (err, files) => {
  440. if (!err) {
  441. files.map(file => path.join(inputFilePath, file))
  442. .forEach(file => {
  443. zipStream.addEntry(file)
  444. })
  445. }
  446. })
  447. // 写入文件内容
  448. zipStream.pipe(outStream)
  449. .on('close', () => {
  450. // 打包完成后删除临时目录
  451. // console.log(tempDocxPath)
  452. eventMap["onDocxComplete"]&&eventMap["onDocxComplete"](outputFilePath)
  453. shell.rm("-r",tempDocxPath)
  454. // rimrif.rimrafSync(tempDocxPath)
  455. resolve(true)
  456. })
  457. }
  458. // 替换word/document.xml文件中{{xx}}处的内容
  459. let replaceXML = (data, text) => {
  460. Object.keys(data).forEach(key => {
  461. text = text.replaceAll(`{{${key}}}`, data[key])
  462. })
  463. return text
  464. }
  465. // 解压docx文件替换内容重新打包成docx文件
  466. compressing.zip.uncompress(inputDocxPath, tempDocxPath)
  467. .then(() => {
  468. // 读写要替换内容的xml文件
  469. fs.readFile(tempDocxXMLName, null, (err, data) => {
  470. if (!err) {
  471. let text = data.toString()
  472. text = replaceXML(options, text)
  473. fs.writeFile(tempDocxXMLName, text, (err) => {
  474. if (!err) {
  475. dir_to_docx(tempDocxPath, outputDocxPath)
  476. } else {
  477. reject(err)
  478. }
  479. })
  480. } else {
  481. reject(err)
  482. }
  483. })
  484. }).catch(err => {
  485. reject(err)
  486. })
  487. })
  488. }
  489. module.exports.replaceDocx = replaceDocx
  490. function generateObjectId(inputString) {
  491. inputString = inputString || ""
  492. inputString = String(inputString)
  493. const hash = crypto.createHash('sha256').update(inputString).digest('hex');
  494. const objectId = hash;
  495. return objectId;
  496. }