exportRationItems.js 2.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980
  1. /**
  2. * Created by Tony on 2021/10/6.
  3. */
  4. // testRationData_1633422499669.js
  5. let fs = require('fs');
  6. // let data = fs.readFileSync('D:/GitHome/ConstructionOperation/tmp/testRationData_1633514079281.js');
  7. // let data = fs.readFileSync('D:/GitHome/YangHuOperation/tmp/testRationData_广西公路日常养护预算指标(2021).js');
  8. let data = fs.readFileSync('D:/GitHome/YangHuOperation/tmp/testRationData_广西公路养护预算定额(2021).js');
  9. //----------------------------------------
  10. let rationItemArr = JSON.parse(data);
  11. // console.log(rationItemArr);
  12. function _getIDCode(code) {
  13. let rst = '';
  14. if (code !== null && code !== undefined) {
  15. let codes = code.split('-');
  16. if (codes.length === 3) {
  17. let suppls = ['', '', ''];
  18. let regExp = new RegExp('D', "gm");
  19. codes[0] = codes[0].replace(regExp, '');
  20. if (codes[0].length < 2) {
  21. for (let idx = codes[0].length; idx < 2; idx++) {
  22. suppls[0] = suppls[0] + '0';
  23. }
  24. }
  25. if (codes[1].length < 2) {
  26. for (let idx = codes[1].length; idx < 2; idx++) {
  27. suppls[1] = suppls[1] + '0';
  28. }
  29. }
  30. if (codes[2].length < 3) {
  31. for (let idx = codes[2].length; idx < 3; idx++) {
  32. suppls[2] = suppls[2] + '0';
  33. }
  34. }
  35. for (let si = 0; si < codes.length; si++) {
  36. rst += (suppls[si] + codes[si]);
  37. }
  38. } else {
  39. //
  40. }
  41. }
  42. return rst;
  43. }
  44. let newSectionData = [];
  45. let firstStr = 'ID|IDCode|Code|Name|Unit|BasePrice|SectionID|Caption|FeeType|Name2|Unit2|UUID,';
  46. newSectionData.push(firstStr);
  47. for (let item of rationItemArr) {
  48. let str = `${item.ID}|${_getIDCode(item.code)}|${item.code}|${item.name}|${item.unit}|${item.basePrice}|${item.sectionId}|${item.caption}|${item.feeType}||||`;
  49. newSectionData.push(str);
  50. }
  51. // let ttlSQL = JSON.stringify(newSectionData);
  52. // let ttlSQL = newSectionData.join('');
  53. let ttlSQL = newSectionData.join('\n');
  54. let regExp = new RegExp('"', "gm");
  55. ttlSQL = ttlSQL.replace(regExp, '');
  56. // ttlSQL.replace()
  57. //fs.writeFile(`D:/GitHome/ConstructionOperation/tmp/章节树临时Data文件_${(new Date()).getTime()}.js`, ttlSQL, { 'flag': 'a', 'encoding': 'utf-8' }, function(err){
  58. // fs.writeFile(`D:/GitHome/ConstructionOperation/tmp/定额临时Data文件_${(new Date()).getTime()}.txt`, ttlSQL, { 'flag': 'a', 'encoding': 'utf-8' }, function(err){
  59. fs.writeFile(`D:/GitHome/YangHuOperation/tmp/定额临时Data文件_${(new Date()).getTime()}.txt`, ttlSQL, { 'flag': 'a', 'encoding': 'utf-8' }, function(err){
  60. if(err) throw err;
  61. });
  62. // */