feng-fu / code-fragment Goto Github PK

var tableBody = [{
  'name': 'aaa',
  'age': 11,
  'sex': '男'
}]

var tableHeader = {
  'name': '姓名',
  'age': '年龄',
  'sex': '性别'
}

function s2ab(s) { // 字符串转字符流
  var buf = new ArrayBuffer(s.length)
  var view = new Uint8Array(buf)
  for (var i = 0; i !== s.length; ++i) {
    view[i] = s.charCodeAt(i) & 0xFF
  }
  return buf
}
function getCharCol (n) {
  let s = ''
  let m = 0
  while (n > 0) {
    m = n % 26 + 1
    s = String.fromCharCode(m + 64) + s
    n = (n - m) / 26
  }
  return s
}

function fileTransDownload(json, merges) {
  
  let keyMap = []
  for (let k in json[0]) {
    keyMap.push(k)
  }
  let tmpdata = [] // 用来保存转换好的json
  json.map((v, i) => keyMap.map((k, j) => Object.assign({}, {
    v: v[k],
    position: (j > 25 ? getCharCol(j) : String.fromCharCode(65 + j)) + (i + 1),
    t: 't'
  }))).reduce((prev, next) => prev.concat(next)).forEach(function (v) {
    tmpdata[v.position] = {
      v: v.v,
      t: v.t || 'e'
    }
  })
  let outputPos = Object.keys(tmpdata)  // 设置区域,比如表格从A1到D10
  let tmpWB = {
    SheetNames: ['mySheet'], // 保存的表标题
    Sheets: {
      'mySheet': Object.assign({},
        tmpdata, // 内容
        {
          '!ref': outputPos[0] + ':' + outputPos[outputPos.length - 1], // 设置填充区域
        })
    }
  }
  let tmpDown = new Blob([s2ab(XLSX.write(tmpWB,
    {bookType: 'xlsx', bookSST: false, type: 'binary'} // 这里的数据是用来定义导出的格式类型
  ))], {
    type: ''
  })  // 创建二进制对象写入转换好的字节流
  var href = URL.createObjectURL(tmpDown)  // 创建对象超链接
  return {
    tmpDown,
    href
  }
}
function download() {
  const fileName = `表格a`
  downloadExl(tableBody.concat([tableHeader]).reverse(), fileName)
}
function downloadExl(json, downName) {  // 导出到excel
  const { href, tmpDown } = fileTransDownload(json)
  outputFile.download = downName + '.xlsx'  // 下载名称
  outputFile.href = href  // 绑定a标签
  outputFile.click()  // 模拟点击实现下载
  setTimeout(function () {  // 延时释放
    URL.revokeObjectURL(tmpDown) // 用URL.revokeObjectURL()来释放这个object URL
  }, 100)
}


outputBtn.addEventListener('click', download)

function Base() {}

Base.extend = function (methods, staticMethods) {
  var Base = this
  methods = methods || {}
  staticMethods = staticMethods || {}
  function S() {
    Base.call(this)
  }
  S.prototype = new Base // 原型链继承

  copy(S.prototype, methods) // 添加方法
  copy(S, Base) // 静态方法继承
  copy(S, staticMethods) // 添加静态方法
  return S
}

  // 用法
  Base.extend(methods, staticMethods)

function Carousel(obj) {
  this.element = obj.element;
  this.singleInstance = obj.instance;
  this.speed = obj.speed || 2000;
  this.childNode = this.element.querySelectorAll(obj.childNode || 'li');
  this.count = this.childNode.length;
  this.playPreTimer = null;
  this.playNextTimer = null;
  this.direction = obj.direction == 'left' ? 'left' : 'top';
}
Carousel.prototype.init = function () {
  var first = this.childNode[0];
  var last = this.childNode[this.count - 1];
  this.first = first.cloneNode(true);
  this.last = last.cloneNode(true);
  this.element.appendChild(this.first);
  this.element.insertBefore(this.last, first);
  this.element.style[this.direction] = -this.singleInstance + 'px';
  this.element.transition = 'all .5s';
};
Carousel.prototype.autoPlayNext = function () {
  var _this = this;
  this.playNextTimer = setInterval(function () {
      _this.playNext();
  }, this.speed);
};
Carousel.prototype.autoPlayPre = function () {
  var _this = this;
  this.playPreTimer = setInterval(function () {
      _this.playPre();
  }, this.speed);
};
Carousel.prototype.clearAutoPlay = function () {
  clearInterval(this.playNextTimer);
  clearInterval(this.playNextTimer);
  this.playNextTimer = null;
  this.playPreTimer = null;
};
Carousel.prototype.playNext = function () {
  var _this = this;
  var instance = parseInt(this.element.style[this.direction] || 0);
  var newInstnace = instance - this.singleInstance;
  this.element.style[this.direction] = newInstnace + 'px';
  if (newInstnace + this.singleInstance * (this.count + 1) <= 0) {
      setTimeout(function () {
          _this.element.style.transition = 'height .5s';
          _this.element.style[_this.direction] = -_this.singleInstance + 'px';
          setTimeout(function () {
              _this.element.style.transition = 'all .5s';
          }, 200);
      }, 500);
  }
};
Carousel.prototype.playNextOneDirection = function () {
  var _this = this;
  var instance = parseInt(this.element.style[this.direction] || 0);
  var newInstnace = instance - this.singleInstance;
  if(newInstnace + this.singleInstance * (this.count - 9) <= 0) return
  this.element.style[this.direction] = newInstnace + 'px';
};
Carousel.prototype.playPreOneDirection = function () {
  var _this = this;
  var instance = parseInt(this.element.style[this.direction] || 0);
  var newInstnace = instance + this.singleInstance;
  if (newInstnace >= this.singleInstance) return
  this.element.style[this.direction] = newInstnace + 'px';
};
Carousel.prototype.playPre = function () {
  var _this = this;
  var instance = parseInt(this.element.style[this.direction] || 0);
  var newInstnace = instance + this.singleInstance;
  this.element.style[this.direction] = newInstnace + 'px';
  if (newInstnace >= 0) {
      setTimeout(function () {
          _this.element.style.transition = 'height .5s';
          _this.element.style[_this.direction] = -_this.singleInstance * _this.count + 'px';
          setTimeout(function () {
              _this.element.style.transition = 'all .5s';
          }, 200);
      }, 500);
  }
};
Carousel.prototype.delete = function () { 
  var _this = this;
  _this.element.removeChild(this.first)
  _this.element.removeChild(this.last)
}

var deepFlatten = (arr) => {
  var result = []
  var stack = arr
  while(stack.length) {
    var last = stack.pop()
    if (Array.isArray(last)) {
      stack = stack.concat(last)
    } else {
      result.unshift(last)
    }
  }
  return result
}

function(element) {
  var textarea = document.createElement('textarea')
  textarea.textContent = document.querySelector(element).innerText
  textarea.style.opacity = 0
  textarea.style.top = 0
  textarea.style.left = 0
  textarea.style.position = 'fixed'
  document.body.appendChild(textarea)
  textarea.select()
  document.execCommand('copy')
  document.body.removeChild(textarea)
}