func-tbook-export.js 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555
  1. import { replaceDocx, createZip, uploadFileToOSS, docxToPdf, renderDocx, toBarCode } from "../../lib/docs";
  2. // const Parse = global.Parse;
  3. const path = require("path")
  4. const fs = require("fs")
  5. var TemplateDocxDir = path.join(__dirname,"template")
  6. if(!fs.existsSync(TemplateDocxDir)){
  7. TemplateDocxDir = path.join(__dirname,"../../template")
  8. }
  9. const tempDir = path.join(__dirname , "temp");
  10. /**
  11. * 常用Word字符
  12. */
  13. // 圆圈选中未选 ○ 未选 ● 选中
  14. const circleCheck = ["○","●"];
  15. // 方块选中未选 ○ 未选 ● 选中
  16. const squareCheck = [`□`,String.fromCharCode(0xFE)];
  17. /**
  18. * 定义导出申报合集文档云函数
  19. * @example
  20. * Cloud Code test
  21. 导出流程
  22. curl -X POST -H "Content-Type: application/json" -H 'X-Parse-Application-Id: edu-textbook' -d '{ "processId": "FR7KZtefyR" }' http://127.0.0.1:61337/parse/functions/tbookExportReport
  23. curl -X POST -H "Content-Type: application/json" -H 'X-Parse-Application-Id: edu-textbook' -d '{ "processId": "FR7KZtefyR" }' http://8.140.98.43/parse/functions/tbookExportReport
  24. curl -X POST -H "Content-Type: application/json" -H 'X-Parse-Application-Id: edu-textbook' -d '{ "processId": "FR7KZtefyR" }' http://8.140.98.43/parse/api/tbook/export
  25. curl -X POST -H "Content-Type: application/json" -H 'X-Parse-Application-Id: edu-textbook' -d '{ "processId": "FR7KZtefyR" }' https://145.tbook.com.cn/parse/api/tbook/export
  26. 导出教材列表
  27. curl -X POST -H "Content-Type: application/json" -H 'X-Parse-Application-Id: edu-textbook' -d '{ "bookList": ["9V575dapEM","2YBKitpCJL","xLdiEaHGrX"] }' http://8.140.98.43/parse/functions/tbookExportReport
  28. */
  29. export function defineTbookExportReport(app){
  30. app.post("/parse/api/tbook/export",async (request,res)=>{
  31. let processId = request.body.processId;
  32. let bookList = request.body.bookList;
  33. console.log(request.body)
  34. try{
  35. let result
  36. if(processId){
  37. result = await exportProcessReportDocs(processId)
  38. }
  39. if(bookList?.length){
  40. result = await exportProcessReportDocs(null,bookList)
  41. }
  42. if(result?.docsList?.length==0){
  43. // throw new Parse.Error(404,"合集内无申报教材")
  44. res.json({
  45. code:400,
  46. err:"合集内无申报教材"
  47. })
  48. }
  49. // return result
  50. res.json({
  51. code:200,
  52. result:result
  53. })
  54. }catch(err){
  55. console.error(err)
  56. res.json({
  57. code:400,
  58. err:err
  59. })
  60. // throw new Parse.Error(404,"导出申报合集失败")
  61. }
  62. // throw new Parse.Error(404,"未找到该流程合集")
  63. })
  64. Parse.Cloud.define("tbookExportReport", async (request) => {
  65. let processId = request.params.processId;
  66. let bookList = request.params.bookList;
  67. try{
  68. let result
  69. if(processId){
  70. result = await exportProcessReportDocs(processId)
  71. }
  72. if(bookList?.length){
  73. result = await exportProcessReportDocs(null,bookList)
  74. }
  75. if(result?.docsList?.length==0){
  76. throw new Parse.Error(404,"合集内无申报教材")
  77. }
  78. return result
  79. }catch(err){
  80. console.error(err)
  81. throw new Parse.Error(404,"导出申报合集失败")
  82. }
  83. throw new Parse.Error(404,"未找到该流程合集")
  84. },{
  85. fields : {
  86. processId:{
  87. required:false
  88. },
  89. }
  90. });
  91. }
  92. /**
  93. * 导出流程教材申报文件
  94. * @returns
  95. * docsList
  96. * zipUrl
  97. */
  98. export async function exportProcessReportDocs(processId,bookList) {
  99. if(!processId && !bookList?.length) return {}
  100. let textbookList
  101. if(processId){ // 流程读取教材列表
  102. let query = new Parse.Query("EduTextbook")
  103. query.include("childrens","department")
  104. query.equalTo("recommend",true);
  105. query.equalTo("eduProcess",processId);
  106. textbookList = await query.find();
  107. }
  108. if(bookList?.length){ // 直接导出教材列表
  109. let query = new Parse.Query("EduTextbook")
  110. query.include("childrens","department")
  111. query.containedIn("objectId",bookList);
  112. textbookList = await query.find();
  113. }
  114. let docsList = []
  115. let plist = []
  116. for (let index = 0; index < textbookList.length; index++) {
  117. let textbook = textbookList[index];
  118. console.log("textbook",index)
  119. // 直接将异步调用的 Promise 添加到 plist
  120. plist.push(renderReportDocsByTextbook(textbook)); // 立即执行并返回 Promise
  121. }
  122. let presults = await Promise.all(plist);
  123. presults.forEach(result=>{
  124. if(result?.filePath){
  125. docsList.push(result)
  126. }
  127. })
  128. let zipPath,zipUrl
  129. if(docsList?.length){
  130. let now = new Date();
  131. let fileList = docsList?.map(item=>item?.pdfPath);
  132. let zipName = `申报书导出-${now.getFullYear()}${now.getMonth()+1}${now.getDate()}-${now.getHours()}${now.getMinutes()}${now.getSeconds()}.zip`
  133. zipPath = await createZip(fileList,zipName)
  134. if(zipPath){
  135. zipUrl = (await uploadFileToOSS(zipPath))?.url || null
  136. }
  137. docsList = docsList.map(item=>{return {code:item.code,title:item.title,url:item?.url}})
  138. }
  139. let result = {
  140. docsList,
  141. zipUrl
  142. }
  143. return result
  144. }
  145. module.exports.exportProcessReportDocs = exportProcessReportDocs
  146. function fixVolumeData(json,volumeData,index){
  147. json.index = index + 1;
  148. // 教材基本信息
  149. // 专业代码:前四位 majorPoniter
  150. let majorCode4 = volumeData?.majorPoniter?.code?.slice(0,4) || json?.majorPoniter?.code?.slice(0,4) || ""
  151. let majorName4 = volumeData?.majorPoniter?.name || json?.majorPoniter?.name || ""
  152. // 专业代码:前六位 major
  153. let majorCode6 = volumeData?.major?.code?.slice(0,6) || json?.major?.code?.slice(0,6) || ""
  154. let majorName6 = volumeData?.major?.name || json?.major?.name || ""
  155. // 初版时间
  156. let firstDate = new Date(volumeData?.editionFirst.iso);
  157. let firstYear = firstDate?.getFullYear();
  158. let firstMonth = firstDate?.getMonth()+1;
  159. // 本版时间印次
  160. let currentDate = new Date(volumeData?.editionDate.iso);
  161. let currentYear = currentDate?.getFullYear();
  162. let currentMonth = currentDate?.getMonth()+1;
  163. // 最新时间印次
  164. let latestDate = new Date(volumeData?.printDate.iso);
  165. let latestYear = latestDate?.getFullYear();
  166. let latestMonth = latestDate?.getMonth()+1;
  167. let latestNum = volumeData?.printNumber || "";
  168. let currentNum = volumeData?.editionNumber || "";
  169. let printSum = volumeData?.printSum?volumeData?.printSum+"万":"" || "";
  170. // 是否重点立项
  171. let importantProject = volumeData?.importantProject?.join();
  172. // 初版至今重点项目
  173. let isBSQT = !((importantProject?.indexOf("建设")>-1) || (importantProject?.indexOf("本科国家")>-1) || (importantProject?.indexOf("省级优秀")>-1) || (importantProject?.indexOf("省级规划")>-1))// 是否其他省级奖项
  174. let bsqtName = (volumeData?.importantProject || [])?.filter(item=>(item?.indexOf("建设")==-1&&item?.indexOf("本科国家")==-1&&item?.indexOf("省级优秀")==-1&&item?.indexOf("省级规划")==-1));
  175. json.importantProject = importantProject
  176. json.firstDate = firstDate
  177. json.firstYear = firstYear
  178. json.firstMonth = firstMonth
  179. json.currentDate = currentDate
  180. json.currentYear = currentYear
  181. json.currentMonth = currentMonth
  182. json.latestDate = latestDate
  183. json.latestYear = latestYear
  184. json.latestMonth = latestMonth
  185. json.currentNum = currentNum
  186. json.latestMonth = latestMonth
  187. json.latestNum = latestNum
  188. json.printSum = printSum
  189. json.isBSQT = isBSQT
  190. json.bsqtName = bsqtName
  191. json.uBS = circleCheck[(volumeData?.unitType?.indexOf("部属")>-1)?1:0];
  192. json.uHJ = circleCheck[(volumeData?.unitType?.indexOf("合建")>-1)?1:0];
  193. json.uGJ = circleCheck[(volumeData?.unitType?.indexOf("共建")>-1)?1:0];
  194. json.uQT = circleCheck[(volumeData?.unitType?.indexOf("其他")>-1)?1:0];
  195. json.mc4 = majorCode4;
  196. json.mn4 = majorName4;
  197. json.mc6 = majorCode6;
  198. json.mn6 = majorName6;
  199. json.lCN = circleCheck[(volumeData?.lang=="中文")?1:0];
  200. json.lEN = circleCheck[(volumeData?.lang=="英文")?1:0];
  201. json.lMW = circleCheck[(volumeData?.lang=="盲文")?1:0];
  202. json.lOT = circleCheck[(volumeData?.lang?.indexOf("其他")>-1)?1:0];
  203. json.lSS = circleCheck[(volumeData?.lang?.indexOf("少数")>-1)?1:0];
  204. json.publisher = volumeData?.editionUnit;
  205. json.isZZ = circleCheck[(volumeData?.carrierShape?.indexOf("纸质")>-1)?1:0];
  206. json.isDZ = circleCheck[(volumeData?.carrierShape?.indexOf("电子")>-1)?1:0];
  207. json.isSZ = circleCheck[(volumeData?.carrierShape?.indexOf("数字")>-1 || volumeData?.carrierShape?.indexOf("电子")>-1)?1:0];
  208. json.isQT = circleCheck[(volumeData?.carrierShape?.indexOf("附带")>-1)?1:0];
  209. json.isFD = circleCheck[(volumeData?.carrierShape?.indexOf("其他")>-1)?1:0];
  210. json.latestY = latestYear;
  211. json.latestM = latestMonth;
  212. json.currentY = currentYear;
  213. json.currentM = currentMonth;
  214. json.isGJS = circleCheck[(importantProject?.indexOf("建设")>-1)?1:0];
  215. json.isBGJ = circleCheck[(importantProject?.indexOf("本科国家")>-1)?1:0];
  216. json.isBSYX = circleCheck[(importantProject?.indexOf("省级优秀")>-1)?1:0];
  217. json.isBSGH = circleCheck[(importantProject?.indexOf("省级规划")>-1)?1:0];
  218. json.isBSQT = circleCheck[isBSQT?1:0];
  219. json.isFirstNot = circleCheck[volumeData?.importantProject?0:1];
  220. // 作者列表
  221. for (let index = 0; index < 6; index++) { // 补充空值
  222. if(!volumeData?.authorList?.[index]){
  223. volumeData.authorList.push({name:"",unit:"",birth:"",nationality:"",job:"",title:"",mobile:"",email:"",work:""})
  224. }
  225. }
  226. volumeData.authorList = volumeData?.authorList?.map((item,index)=>{ // 转换格式
  227. item.index = index + 1
  228. item.birth = toYearMonth(item?.birth)
  229. return item
  230. })
  231. json.authorList = volumeData?.authorList;
  232. // 成果列表
  233. // aclist[index] = [json?.achievementOptions?.[index]?.name||" ",json?.achievementOptions?.[index]?.unit||" ",toYearMonth(json?.achievementOptions?.[index]?.date)||" "]
  234. for (let index = 0; index < 5; index++) { // 补充空值
  235. if(!volumeData?.achievementOptions?.[index]){
  236. volumeData.achievementOptions.push({name:"",unit:"",date:""})
  237. }
  238. volumeData.achievementOptions = volumeData?.achievementOptions?.map((item,index)=>{ // 转换格式
  239. item.index = index + 1
  240. item.date = toYearMonth(item?.date)
  241. return item
  242. })
  243. }
  244. json.achievementOptions = volumeData?.achievementOptions;
  245. // 历程列表
  246. // clist[index] = [num,toYearMonth(json?.courses?.[index]?.date)||" ",json?.courses?.[index]?.wordage||" ",json?.courses?.[index]?.num||" ",json?.courses?.[index]?.sumNum||" ",json?.courses?.[index]?.accolade||" "]
  247. for (let index = 0; index < 4; index++) { // 补充空值
  248. if(!volumeData?.courses?.[index]){
  249. volumeData.courses.push({date:"",wordage:"",num:"",sumNum:"",accolade:""})
  250. }
  251. volumeData.courses = volumeData?.courses?.map((item,index)=>{ // 转换格式
  252. item.index = index + 1
  253. item.date = toYearMonth(item?.date)
  254. return item
  255. })
  256. }
  257. json.courses = volumeData?.courses;
  258. return json
  259. }
  260. function renderReportDocsByTextbook(textbook){
  261. console.log("renderReportDocsByTextbook")
  262. return new Promise(async (resolve)=>{
  263. let json = textbook.toJSON();
  264. let bookid = json.code || json?.objectId;
  265. // 默认单册为第一分册
  266. let book1Data = json?.childrens?.[0]
  267. if(book1Data){
  268. Object.keys(book1Data).forEach(key=>{
  269. json[key] = book1Data[key] || json[key] || ""
  270. })
  271. }
  272. // 联系电话:默认为作者首个存在的电话;
  273. let mobile = json?.authorList?.find(item => item.mobile)?.mobile || ""
  274. // 填报时间:默认为创建时间
  275. let createdAt = new Date(textbook?.createdAt);
  276. let createdDate = `${createdAt?.getFullYear()}年${createdAt?.getMonth()+1}月${createdAt?.getDate()}日`;
  277. // 教材适用
  278. let characteristic = (json?.characteristic?.filter(item=>item?.checked).map(item=>item.label) || [])?.join(",")
  279. json = fixVolumeData(json,book1Data,0)
  280. let volumeList = []
  281. for (let index = 0; index < 12; index++) {
  282. if(json?.childrens?.[index]){
  283. let volumeData = json?.childrens?.[index]
  284. volumeData = fixVolumeData(volumeData,volumeData,index)
  285. volumeList.push(volumeData)
  286. }
  287. }
  288. json.volumeList = volumeList
  289. // 作者列表 限6人
  290. let alist = []
  291. for (let index = 0; index < 9; index++) {
  292. alist[index] = [json?.authorList?.[index]?.name||" ",json?.authorList?.[index]?.unit||" ",toYearMonth(json?.authorList?.[index]?.birth)||" ",json?.authorList?.[index]?.nationality||" ",json?.authorList?.[index]?.job||" ",json?.authorList?.[index]?.title||" ",json?.authorList?.[index]?.mobile||" ",json?.authorList?.[index]?.email||" ",json?.authorList?.[index]?.work||" "]
  293. }
  294. // 相关成果 限5项
  295. let aclist = []
  296. for (let index = 0; index < 5; index++) {
  297. aclist[index] = [json?.achievementOptions?.[index]?.name||" ",json?.achievementOptions?.[index]?.unit||" ",toYearMonth(json?.achievementOptions?.[index]?.date)||" "]
  298. }
  299. // 申报历程 限4项
  300. let clist = []
  301. for (let index = 0; index < 4; index++) {
  302. let num = json?.courses?.[index]?(index+1):" ";
  303. clist[index] = [num,toYearMonth(json?.courses?.[index]?.date)||" ",json?.courses?.[index]?.wordage||" ",json?.courses?.[index]?.num||" ",json?.courses?.[index]?.sumNum||" ",json?.courses?.[index]?.accolade||" "]
  304. }
  305. // 附件信息
  306. let mergeFiles = []
  307. // 1.教材电子版(必须提供)
  308. // (教材出版单位配合按要求上传各地推荐的本单位出版的纸质教材最新印次的完整PDF电子版;数字教材上传全部教材内容电子版或填写能够查看全部教材内容的链接地址、账号;纸质教材附带数字资源的,上传纸质教材最新印次的完整PDF电子版,以及全部数字资源电子版或能够查看全部数字资源内容的链接地址、账号。)
  309. // 2.所有作者政治审查意见(必须提供)
  310. // (对应作者姓名上传“作者政治审查表”。作者单位党委对作者进行审查,对政治思想表现情况进行评价,确保作者的正确政治方向、价值取向,无违法违纪等记录。教材编写成员涉及多个不同单位时需要各单位分别出具意见,并由所在单位党委盖章,格式要求从申报平台下载。)
  311. // 3.图书编校质量自查结果记录表(必须提供)
  312. // (教材出版单位对申报教材的编校质量自查后,按要求提供图书编校质量自查结果记录表,并加盖出版社公章。全册教材的不同分册以不同文件分别上传。格式要求从申报平台下载。)
  313. if(json?.selfResults?.url){mergeFiles.push(json?.selfResults?.url)}
  314. // 4.专家审查意见表(必须提供)
  315. // (由第一主编所在单位和出版机构邀请校内外相关学科专业领域专家,对教材进行思想性、学术性审查。专家不少于3名,其中半数以上为校外专家,专家分别实名评价并签字,并注明所在单位及专业身份。评价人不得是本教材的作者。)
  316. if(json?.expertOpinion?.url){mergeFiles.push(json?.expertOpinion?.url)}
  317. // 5.教材使用情况证明材料(必须提供)
  318. // (教材出版单位提供教材主要使用高校名单及使用情况证明材料,并加盖公章。)
  319. if(json?.evidence?.url){mergeFiles.push(json?.evidence?.url)}
  320. // 6.版权信息及CIP数据(必须提供)
  321. // (版权页截图,中国版本图书馆CIP查询截图,如CIP数据中无“教材”字样的,须再上传内容提要或前言或后记中可以证明本书为教材的相关内容截图。)
  322. if(json?.CIPImgUrl){mergeFiles.push(json?.CIPImgUrl)}
  323. // 7.其他材料(可选提供)
  324. if(json?.moreMaterial?.length){
  325. json?.moreMaterial.forEach(doc=>{
  326. if(doc?.url){
  327. mergeFiles.push(doc?.url)
  328. }
  329. })
  330. }
  331. let codePngBuffer = await toBarCode(json?.code);
  332. let codePngPath = path.join(tempDir,bookid+"code.png")
  333. fs.writeFileSync(codePngPath,codePngBuffer)
  334. // let codeBarImg =
  335. // console.log(codeBarImg)
  336. // (其他佐证材料,限两份以内。)
  337. console.log(codePngPath)
  338. let isNotImpt = (json?.approval?.indexOf("101计划")==-1) && (json?.approval?.indexOf("中央")==-1) && (json?.approval?.indexOf("四新")==-1) && (json?.approval?.indexOf("建设")==-1);
  339. let fixData = {
  340. volumeList:volumeList,
  341. // 图片信息
  342. codeBarImg:codePngPath,
  343. // 封面信息
  344. titlePad:padString(json?.title,21),
  345. ISBNPad:padString(json?.ISBN,21),
  346. ISBN:json?.ISBN,
  347. inviteUnit:json?.inviteUnit||json?.department?.name||"",
  348. one:squareCheck[(json?.type=="单本"||json?.type=="单册")?1:0], // 单本/单册 方框
  349. full:squareCheck[json?.type=="全册"?1:0], // 全册
  350. oneCircle:circleCheck[(json?.type=="单本"||json?.type=="单册")?1:0], // 单本/单册 圆圈
  351. fullCircle:circleCheck[json?.type=="全册"?1:0], // 全册
  352. tn:json?.typeNumber,
  353. authorPad:padString(json?.author,21),
  354. mobile:padString(mobile,21),
  355. authorUnit:padString(json?.unit,21),
  356. publisherPad:padString(json?.editionUnit,21),
  357. createdDate:padString(createdDate,21),
  358. // 基本信息
  359. title:json?.title,
  360. isJC: circleCheck[(json?.approval?.indexOf("基础")>-1)?1:0],
  361. isZL: circleCheck[(json?.approval?.indexOf("战略")>-1)?1:0],
  362. is101: circleCheck[(json?.approval?.indexOf("101计划")>-1)?1:0], // 2024新重点
  363. isZY: circleCheck[(json?.approval?.indexOf("中央")>-1)?1:0],
  364. isSX: circleCheck[(json?.approval?.indexOf("四新")>-1)?1:0],
  365. isJS: circleCheck[(json?.approval?.indexOf("建设")>-1)?1:0],
  366. isNotImpt: circleCheck[isNotImpt?1:0],
  367. // 教材适用情况
  368. lessons:json?.lessons||[],
  369. period:json?.period||"", // 学时
  370. isBX:squareCheck[(characteristic?.indexOf("必修")>-1)?1:0],
  371. isXX:squareCheck[(characteristic?.indexOf("选修")>-1)?1:0],
  372. isTS:circleCheck[(characteristic?.indexOf("通识")>-1)?1:0],
  373. isGG:circleCheck[(characteristic?.indexOf("公共")>-1)?1:0],
  374. isZYK:circleCheck[(characteristic?.indexOf("专业")>-1)?1:0],
  375. isSXZZ:squareCheck[(characteristic?.indexOf("思想")>-1)?1:0],
  376. isSY:squareCheck[(characteristic?.indexOf("实验")>-1)?1:0],
  377. // 作者列表
  378. a11:alist[0][0],a12:alist[0][1],a13:alist[0][2],a14:alist[0][3],a15:alist[0][4],a16:alist[0][5],a17:alist[0][6],a18:alist[0][7],a19:alist[0][8],
  379. a21:alist[1][0],a22:alist[1][1],a23:alist[1][2],a24:alist[1][3],a25:alist[1][4],a26:alist[1][5],a27:alist[1][6],a28:alist[1][7],a29:alist[1][8],
  380. a31:alist[2][0],a32:alist[2][1],a33:alist[2][2],a34:alist[2][3],a35:alist[2][4],a36:alist[2][5],a37:alist[2][6],a38:alist[2][7],a39:alist[2][8],
  381. a41:alist[3][0],a42:alist[3][1],a43:alist[3][2],a44:alist[3][3],a45:alist[3][4],a46:alist[3][5],a47:alist[3][6],a48:alist[3][7],a49:alist[3][8],
  382. a51:alist[4][0],a52:alist[4][1],a53:alist[4][2],a54:alist[4][3],a55:alist[4][4],a56:alist[4][5],a57:alist[4][6],a58:alist[4][7],a59:alist[4][8],
  383. a61:alist[5][0],a62:alist[5][1],a63:alist[5][2],a64:alist[5][3],a65:alist[5][4],a66:alist[5][5],a67:alist[5][6],a68:alist[5][7],a69:alist[5][8],
  384. // 成果列表
  385. ac11:aclist[0][0],ac12:aclist[0][1],ac13:aclist[0][2],
  386. ac21:aclist[1][0],ac22:aclist[1][1],ac23:aclist[1][2],
  387. ac31:aclist[2][0],ac32:aclist[2][1],ac33:aclist[2][2],
  388. ac41:aclist[3][0],ac42:aclist[3][1],ac43:aclist[3][2],
  389. ac51:aclist[4][0],ac52:aclist[4][1],ac53:aclist[4][2],
  390. // 历程列表
  391. c11:clist[0][0],c12:clist[0][1],c13:clist[0][2],c14:clist[0][3],c15:clist[0][4],c16:clist[0][5],
  392. c21:clist[1][0],c22:clist[1][1],c23:clist[1][2],c24:clist[1][3],c25:clist[1][4],c26:clist[1][5],
  393. c31:clist[2][0],c32:clist[2][1],c33:clist[2][2],c34:clist[2][3],c35:clist[2][4],c36:clist[2][5],
  394. c41:clist[3][0],c42:clist[3][1],c43:clist[3][2],c44:clist[3][3],c45:clist[3][4],c46:clist[3][5],
  395. }
  396. let bookData = json;
  397. Object.keys(fixData).forEach(key=>{
  398. bookData[key] = fixData[key] || bookData[key] || ""
  399. })
  400. // console.log(bookData)
  401. // console.log(json)
  402. let tempFileName = path.join(`${bookid}${json.title}.docx`)
  403. // 开始文件合并导出
  404. let filePath,pdfPath,urlDocx,urlPdf
  405. let TemplateDocxPath
  406. if(json?.childrens?.length>1){
  407. TemplateDocxPath = path.join(TemplateDocxDir,"模板-本科教材申报书-全册.docx")
  408. }else{
  409. TemplateDocxPath = path.join(TemplateDocxDir,"模板-本科教材申报书-单册.docx")
  410. }
  411. try{
  412. // DOCX模板合成 速度2-3秒
  413. filePath = renderDocx(TemplateDocxPath,tempFileName,bookData)
  414. urlDocx = (await uploadFileToOSS(filePath))?.url || null
  415. console.log("DOCX CREATED:",filePath)
  416. // PDF文档拼接 速度10-30s 需要API支持
  417. pdfPath = filePath.replaceAll(".docx",".pdf")
  418. let options = {
  419. mergeFiles:mergeFiles
  420. }
  421. pdfPath = await docxToPdf(filePath,pdfPath,options) || filePath // 成功用pdf,失败继续用docx
  422. console.log("PDF CREATED:",filePath)
  423. if(pdfPath){
  424. urlPdf = (await uploadFileToOSS(pdfPath))?.url || null
  425. }
  426. }catch(err){
  427. console.error(err)
  428. }
  429. resolve({
  430. code:bookid,
  431. title:json?.title,
  432. filePath,
  433. pdfPath,
  434. urlDocx,
  435. urlPdf,
  436. })
  437. return
  438. replaceDocx(TemplateDocxPath,tempFileName,bookData,{onDocxComplete:async (filePath)=>{
  439. // 需要API支持
  440. let pdfPath = filePath.replaceAll(".docx",".pdf")
  441. filePath = await docxToPdf(filePath,pdfPath) || filePath // 成功用pdf,失败继续用docx
  442. let url = (await uploadFileToOSS(pdfPath))?.url || null
  443. resolve({
  444. code:bookid,
  445. title:json?.title,
  446. filePath,
  447. url
  448. })
  449. }})
  450. })
  451. }
  452. function toYearMonth(date){
  453. // console.log("toYearMonth",date)
  454. if(typeof date == "string" && date?.indexOf("年")>-1) return date
  455. if(!date) return ""
  456. let datestr = date?.iso||date
  457. if(!datestr) return ""
  458. date = new Date(datestr);
  459. return `${date.getFullYear()}年${date.getMonth()+1}月`
  460. }
  461. function padString(str,width) {
  462. str = str || ""
  463. return str
  464. str = String(str)
  465. width = width || 21 // 目标宽度为21个单位
  466. let spaceChar = " " // 占位符 render可用空格,但document.xml用&#160;
  467. // 计算字符串的宽度
  468. const charWidth = {
  469. 'space': 1, // 空格占用1个单位
  470. 'zh': 3, // 汉字占用3个单位
  471. 'en': 1, // 英文字母占用1个单位
  472. 'other': 1 // 其他字符(如标点符号)占用1个单位
  473. };
  474. let strWidth = 0;
  475. // console.log(str)
  476. // 遍历文本中的每个字符
  477. for (let char of str) {
  478. if (/\s/.test(char)) {
  479. strWidth += charWidth.space; // 空格
  480. } else if (/[\u4e00-\u9fa5]/.test(char)) {
  481. strWidth += charWidth.zh; // 汉字
  482. } else if (/[a-zA-Z]/.test(char)) {
  483. strWidth += charWidth.en; // 英文字母
  484. } else {
  485. strWidth += charWidth.other; // 其他字符
  486. }
  487. }
  488. // for (let char of str) {
  489. // // 判断字符是否为中文
  490. // if (char.match(/[\u4e00-\u9fa5]/)) {
  491. // strWidth += 2; // 中文字符占4个单位
  492. // } else {
  493. // strWidth += 1; // 英文字符占1个单位
  494. // }
  495. // }
  496. const totalPadding = width - strWidth;
  497. // 如果已经达到或超过目标宽度,直接返回原字符串
  498. if (totalPadding <= 0) {
  499. return str;
  500. }
  501. // 计算左右两侧的空格数
  502. const leftPadding = Math.floor(totalPadding / 2) * 3;
  503. const rightPadding = Math.ceil(totalPadding / 2) * 3;
  504. // 生成填充空格的字符串
  505. const leftSpaces = spaceChar.repeat(leftPadding);
  506. const rightSpaces = spaceChar.repeat(rightPadding);
  507. // 返回补充后的字符串
  508. return leftSpaces + str + rightSpaces;
  509. }