csv.js 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. function NodeCode(x) {
  2. return {
  3. "301290000007":"交通银行",
  4. "308584000013":"招商银行",
  5. "305100000013":"民生银行",
  6. "104100000004":"中国银行",
  7. "103100000026":"农业银行",
  8. "102100099996":"工商银行",
  9. "105100000017":"建设银行"}[x] || x;
  10. }
  11. function ConvertToCSVFormat(objArray, typeformat) {
  12. var array = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;
  13. var headerset = {};
  14. var headerlist = [];
  15. for (var i = 0; i < array.length; i++) {
  16. for (var index in array[i]) {
  17. if (!headerset[index]) {
  18. headerset[index] = true;
  19. headerlist.push(index);
  20. }
  21. }
  22. }
  23. var str = '';
  24. for (var hi = 0; hi < headerlist.length; hi++) {
  25. str += hi == 0 ? '' : ',';
  26. str += headerlist[hi];
  27. }
  28. str += "\r\n";
  29. for (var i = 0; i < array.length; i++) {
  30. var a = array[i];
  31. if (a) {
  32. for (var hi = 0; hi < headerlist.length; hi++) {
  33. str += hi == 0 ? '' : ',';
  34. var k = headerlist[hi];
  35. var x = a[k];
  36. if (x != undefined && x != null) {
  37. if (typeformat && typeformat[k]) {
  38. if (typeof typeformat[k] == "function") {
  39. x = typeformat[k](x);
  40. } else if (typeformat[k] == "datetime") {
  41. x = new Date(x).toJSON().replace(/[TZ ]/mg, " ");
  42. }
  43. }
  44. str += x;
  45. }
  46. }
  47. str += "\r\n";
  48. }
  49. }
  50. return str;
  51. }
  52. function ConvertToCSV(objArray) {
  53. return ConvertToCSVFormat(objArray, {"NODECODE": NodeCode, "CALENDTIME": "datetime"});
  54. }