exportGLJItem.js 1.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. /**
  2. * Created by Tony on 2021/10/6.
  3. */
  4. let fs = require('fs');
  5. // let data = fs.readFileSync('D:/GitHome/ConstructionOperation/tmp/testGLJData.js');
  6. // let mixedData = fs.readFileSync('D:/GitHome/YangHuOperation/tmp/testDataResult_广西公路日常养护预算指标(2021).js');
  7. let mixedData = fs.readFileSync('D:/GitHome/YangHuOperation/tmp/testDataResult_广西公路养护预算定额(2021).js');
  8. let data = JSON.parse(mixedData);
  9. let gljItemArr = data.gljList;
  10. //----------------------------------------
  11. // let gljItemArr = JSON.parse(data);
  12. // console.log(gljItemArr);
  13. let newData = [];
  14. let firstStr = 'ID\tCode\tName\tSpecs\tUnit\tBasePrice\tMain\tNew\tType\tDetailType\tShortName\tName2\tUnit2\tSortParam\tCalculateType\tUUID\t字段1\t字段2';
  15. newData.push(firstStr);
  16. for (let item of gljItemArr) {
  17. let str = `${item.ID}\t${item.code}\t${item.name}\t${item.specs}\t${item.unit}\t${(item.basePrice !== undefined)?item.basePrice:0}\t0\t0\t${item.gljType}\t${item.gljClass}\t${item.shortName}\t\t\t\t\t\t\t\t`;
  18. newData.push(str);
  19. }
  20. let ttlStr = newData.join('\n');
  21. let regExp = new RegExp('"', "gm");
  22. ttlStr = ttlStr.replace(regExp, '');
  23. let regExp1 = new RegExp('null', "gm");
  24. ttlStr = ttlStr.replace(regExp1, '');
  25. fs.writeFile(`D:/GitHome/YangHuOperation/tmp/工料机临时Data文件_${(new Date()).getTime()}.txt`, ttlStr, { 'flag': 'a', 'encoding': 'utf-8' }, function(err){
  26. if(err) throw err;
  27. });