123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 |
- function NodeCode(x) {
- return {
- "301290000007":"交通银行",
- "308584000013":"招商银行",
- "305100000013":"民生银行",
- "104100000004":"中国银行",
- "103100000026":"农业银行",
- "102100099996":"工商银行",
- "105100000017":"建设银行"}[x] || x;
- }
- function ConvertToCSVFormat(objArray, typeformat) {
- var array = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;
- var headerset = {};
- var headerlist = [];
- for (var i = 0; i < array.length; i++) {
- for (var index in array[i]) {
- if (!headerset[index]) {
- headerset[index] = true;
- headerlist.push(index);
- }
- }
- }
- var str = '';
- for (var hi = 0; hi < headerlist.length; hi++) {
- str += hi == 0 ? '' : ',';
- str += headerlist[hi];
- }
- str += "\r\n";
- for (var i = 0; i < array.length; i++) {
- var a = array[i];
- if (a) {
- for (var hi = 0; hi < headerlist.length; hi++) {
- str += hi == 0 ? '' : ',';
- var k = headerlist[hi];
- var x = a[k];
- if (x != undefined && x != null) {
- if (typeformat && typeformat[k]) {
- if (typeof typeformat[k] == "function") {
- x = typeformat[k](x);
- } else if (typeformat[k] == "datetime") {
- x = new Date(x).toJSON().replace(/[TZ ]/mg, " ");
- }
- }
- str += x;
- }
- }
- str += "\r\n";
- }
- }
- return str;
- }
- function ConvertToCSV(objArray) {
- return ConvertToCSVFormat(objArray, {"NODECODE": NodeCode, "CALENDTIME": "datetime"});
- }
|