| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642 | <template>  <div class="app-container">    <div class="search">      <el-date-picker v-model="table.getdataListParm.parammaps.inputDatetime" class="inputDatetime filter-item" type="daterange" range-separator="至" start-placeholder="开始日期" end-placeholder="结束日期" style="width: 250px;" />      <el-button class="el-icon-arrow-left elIconArrowLeft" @click="handleBefore" />      <el-button class="el-icon-arrow-right elIconArrowRight" @click="handleNext" />      <el-button class="successBorder" @click="handleSearch">查询</el-button>    </div>    <div class="operation">      <el-button v-if="isRoleEdit" class="success" icon="el-icon-plus" @click="handleCreate">新增盘点单</el-button>      <el-button class="success" icon="el-icon-upload2" @click="handleInventoryList">下载盘点单</el-button>      <el-upload style="float: right;" :headers="headers" :data="uploadData" :action="uploadExcelUrl" :show-file-list="false" :before-upload="beforeImport" :on-success="handleImportSuccess">        <el-button v-if="isRoleEdit" class="import" icon="el-icon-download" style="float: right;">导入</el-button>      </el-upload>      <el-button class="import" icon="el-icon-upload2" style="float: right;margin-right: 10px;" @click="handleExport(1)">导出</el-button>    </div>    <div class="table">      <el-table        :key="table.tableKey"        v-loading="table.listLoading"        element-loading-text="给我一点时间"        :data="table.list"        border        fit        highlight-current-row        style="width: 100%;"        :row-style="rowStyle"        :cell-style="cellStyle"        class="elTable table-fixed"      >        <el-table-column label="序号" align="center" type="index" width="50px">          <template slot-scope="scope">            <span>{{ scope.$index + (table.pageNum-1) * table.pageSize + 1 }}</span>          </template>        </el-table-column>        <el-table-column label="盘点日期" min-width="130px" align="center">          <template slot-scope="scope">            <span>{{ scope.row.inventorydate }}</span>          </template>        </el-table-column>        <el-table-column label="盘点人" min-width="130px" align="center">          <template slot-scope="scope">            <span>{{ scope.row.createuser }}</span>          </template>        </el-table-column>        <el-table-column label="盘盈库存(kg)" min-width="110px" align="center">          <template slot-scope="scope">            <span>{{ scope.row.moreWeight }}</span>          </template>        </el-table-column>        <el-table-column label="盘亏库存(kg)" min-width="110px" align="center">          <template slot-scope="scope">            <span>{{ scope.row.lessWeight }}</span>          </template>        </el-table-column>        <el-table-column label="盈亏净值(kg)" min-width="110px" align="center">          <template slot-scope="scope">            <span>{{ scope.row.differWeight }}</span>          </template>        </el-table-column>        <el-table-column label="备注" min-width="110px" align="center">          <template slot-scope="scope">            <span>{{ scope.row.remark }}</span>          </template>        </el-table-column>        <el-table-column label="操作" align="center" width="80" class-name="small-padding fixed-width" fixed="right">          <template slot-scope="scope">            <el-button class="miniSuccess" :disabled="isokDisable" icon="el-icon-search" @click="handleSee(scope.row)" />            <span v-if="scope.$index + (table.pageNum-1) * table.pageSize + 1 == 1 && isRoleEdit" class="centerSpan">|</span>            <el-button v-if="scope.$index + (table.pageNum-1) * table.pageSize + 1 == 1 && isRoleEdit" icon="el-icon-delete" class="miniDanger" @click="handleRowDelete(scope.row)" />          </template>        </el-table-column>      </el-table>      <pagination v-show="table.total>=0" :total="table.total" :page.sync="table.getdataListParm.offset" :limit.sync="table.getdataListParm.pagecount" @pagination="getList" />    </div>    <!-- 新增盘点单 -->    <el-dialog :title="textMap[create.dialogStatus]" :visible.sync="create.dialogFormVisible" :close-on-click-modal="false" width="90%">      <div class="app-add">        <el-form ref="createTemp" :rules="create.rules" :model="create.createTemp" label-position="right" label-width="160px" style="width: 90%;margin:0 auto">          <el-row>            <el-col :span="8">              <el-form-item label="盘点日期:" prop="inventorydate">                <!-- :picker-options="create.pickerOptions2" -->                <el-date-picker v-model="create.createTemp.inventorydate" class="filter-item" type="date" placeholder="盘点日期" :disabled="create.dialogStatus==='see'" :picker-options="create.pickerOptions1" :clearable="false" />              </el-form-item>            </el-col>            <el-col :span="8">              <el-form-item label="盘点人:" prop="createuser">                <el-input ref="createuser" v-model="create.createTemp.createuser" class="filter-item" placeholder="盘点人" type="text" disabled />              </el-form-item>            </el-col>            <el-col :span="8">              <el-form-item label="备注:" prop="remark">                <el-input ref="remark" v-model="create.createTemp.remark" class="filter-item" placeholder="备注" type="text" :disabled="create.dialogStatus==='see'" />              </el-form-item>            </el-col>          </el-row>        </el-form>        <el-table          :key="create.tableKey"          v-loading="create.listLoading"          element-loading-text="给我一点时间"          :data="create.list"          border          fit          highlight-current-row          style="width: 100%;margin-bottom: 50px;"          :row-style="rowStyle"          :cell-style="cellStyle"          class="elTable table-fixed"        >          <el-table-column label="饲料名称" min-width="130px" align="center">            <template slot-scope="scope">              <span>{{ scope.row.feedname }}</span>            </template>          </el-table-column>          <el-table-column label="库存重量(kg)" min-width="130px" align="center">            <template slot-scope="scope">              <span>{{ scope.row.stockweight }}</span>            </template>          </el-table-column>          <el-table-column label="实际重量(kg)" min-width="110px" align="center">            <template slot-scope="scope">              <el-input v-if="create.dialogStatus==='create'" ref="input" v-model="scope.row.factweight" style="width:80%;padding:10px 0;" @blur="blurFactweight(scope.row)" />              <span v-else> {{ scope.row.factweight }}</span>            </template>          </el-table-column>          <el-table-column label="差值(kg)" min-width="110px" align="center">            <template slot-scope="scope">              <span>{{ scope.row.differ }}</span>            </template>          </el-table-column>        </el-table>        <div slot="footer" class="dialog-footer">          <el-button v-if="create.dialogStatus==='see'" class="import" icon="el-icon-upload2" :disabled="isokDisable" @click="handleExport(2)">导出</el-button>          <el-button v-if="create.dialogStatus==='see'" class="cancelClose cancelClose1" @click="create.dialogFormVisible = false; ">关闭</el-button>          <el-button v-if="create.dialogStatus==='create'" class="cancelClose" @click="create.dialogFormVisible = false; ">关闭</el-button>          <el-button v-if="create.dialogStatus==='create'" class="save" :disabled="isokDisable" @click="createData()">确认</el-button>        </div>      </div>    </el-dialog>  </div></template><script>import { GetDataByName, ExecDataByConfig, failproccess, checkButtons, PostDataByName } from '@/api/common'import Pagination from '@/components/Pagination'import { parseTime, json2excel } from '@/utils/index.js'import { MessageBox } from 'element-ui'import Cookies from 'js-cookie'import axios from 'axios'import { getToken } from '@/utils/auth'export default {  name: 'InventoryList',  components: { Pagination },  data() {    return {      table: {        getdataListParm: {          name: 'getBigInventoryList',          page: 1,          offset: 1,          pagecount: parseInt(Cookies.get('pageCount')),          returntype: 'Map',          parammaps: {            pastureid: Cookies.get('pastureid'),            startTime: '',            stopTime: '',            inputDatetime: ''          }        },        tableKey: 0,        list: [],        total: 0,        listLoading: true      },      textMap: {        create: '新增',        see: '查看盘点单'      },      create: {        pickerOptions1: {          disabledDate: this.disabledDate        },        dialogFormVisible: false,        dialogStatus: '',        createTemp: {          pastureid: Cookies.get('pastureid'),          remark: '',          inventorydate: parseTime(new Date(), '{y}-{m}-{d}'),          createuser: Cookies.get('employename')        },        rules: {},        getdataListParm: {          name: 'getFeedstorageWeightList',          page: 1,          offset: 1,          pagecount: '',          returntype: 'Map',          parammaps: {            pastureid: Cookies.get('pastureid'),            emp: Cookies.get('employename')          }        },        tableKey: 0,        list: [],        total: 0,        listLoading: true,        getMaxdataParm: {          name: 'getInventoryMaxdate',          page: 1,          offset: 1,          pagecount: '',          returntype: 'Map',          parammaps: {            pastureid: Cookies.get('pastureid')          }        },        maxDate: ''      },      see: {        getdataListParm: {          name: 'getInventoryList',          page: 1,          offset: 1,          pagecount: '',          returntype: 'Map',          parammaps: {}        }      },      requestParam: {},      download: {        getdataListParm: {          name: 'getBigInventoryList',          page: 1,          offset: 1,          pagecount: 0,          returntype: 'Map',          parammaps: {            pastureid: Cookies.get('pastureid'),            startTime: '',            stopTime: '',            inputDatetime: ''          }        },        list: []      },      isokDisable: false,      isRoleEdit: [],      rowStyle: { maxHeight: 30 + 'px', height: 30 + 'px' },      cellStyle: { padding: 0 + 'px' }    }  },  computed: {    // 设置请求头    headers() {      return {        token: getToken()      }    },    uploadData() {      return {        name: 'checkFeed,insertBigInventoryUpload,insertInventoryUpload',        importParams: '盘点日期,盘点人,备注,饲料名称,库存重量(kg),实际重量(kg)',        sheetname: 'Sheet1',        // 登录牧场        pastureid: Cookies.get('pastureid'),        // 日期参数        dateParams: '盘点日期',        // 必填参数        requiredParams: '盘点日期,饲料名称,库存重量(kg),实际重量(kg)',        // 为数值的参数        numParams: '实际重量(kg)'      }    },    // 设置上传地址    uploadExcelUrl() {      return process.env.VUE_APP_BASE_API + 'authdata/ImportExcel'    }  },  created() {    this.getButtons()    this.getList()  },  methods: {    getButtons() {      const Edit = 'InventoryList'      const isRoleEdit = checkButtons(JSON.parse(sessionStorage.getItem('buttons')), Edit)      this.isRoleEdit = isRoleEdit    },    handleBefore() {      if (this.table.getdataListParm.parammaps.inputDatetime !== '' && this.table.getdataListParm.parammaps.inputDatetime !== null) {        var start = new Date(this.table.getdataListParm.parammaps.inputDatetime[0].setDate(this.table.getdataListParm.parammaps.inputDatetime[0].getDate() - 1))        var stop = new Date(this.table.getdataListParm.parammaps.inputDatetime[1].setDate(this.table.getdataListParm.parammaps.inputDatetime[1].getDate() - 1))        this.table.getdataListParm.parammaps.inputDatetime.length = 0        this.table.getdataListParm.parammaps.inputDatetime.push(start, stop)        this.table.getdataListParm.parammaps.startTime = parseTime(start, '{y}-{m}-{d}')        this.table.getdataListParm.parammaps.stopTime = parseTime(stop, '{y}-{m}-{d}')        this.$forceUpdate()      }    },    handleNext() {      if (this.table.getdataListParm.parammaps.inputDatetime !== '' && this.table.getdataListParm.parammaps.inputDatetime !== null) {        var start = new Date(this.table.getdataListParm.parammaps.inputDatetime[0].setDate(this.table.getdataListParm.parammaps.inputDatetime[0].getDate() + 1))        var stop = new Date(this.table.getdataListParm.parammaps.inputDatetime[1].setDate(this.table.getdataListParm.parammaps.inputDatetime[1].getDate() + 1))        this.table.getdataListParm.parammaps.inputDatetime.length = 0        this.table.getdataListParm.parammaps.inputDatetime.push(start, stop)        this.table.getdataListParm.parammaps.startTime = parseTime(start, '{y}-{m}-{d}')        this.table.getdataListParm.parammaps.stopTime = parseTime(stop, '{y}-{m}-{d}')        this.$forceUpdate()      }    },    handleSearch() {      console.log('点击了查询')      if (this.table.getdataListParm.parammaps.inputDatetime !== '' && this.table.getdataListParm.parammaps.inputDatetime !== null) {        this.table.getdataListParm.parammaps.startTime = parseTime(this.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')        this.table.getdataListParm.parammaps.stopTime = parseTime(this.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')      } else {        this.table.getdataListParm.parammaps.inputDatetime = ''        this.table.getdataListParm.parammaps.startTime = ''        this.table.getdataListParm.parammaps.stopTime = ''      }      this.table.getdataListParm.offset = 1      this.getList()    },    getList() {      this.table.listLoading = true      GetDataByName(this.table.getdataListParm).then(response => {        console.log('table数据', response.data.list)        if (response.data.list !== null) {          this.table.list = response.data.list          this.table.pageNum = response.data.pageNum          this.table.pageSize = response.data.pageSize          this.table.total = response.data.total        } else {          this.table.list = []        }        setTimeout(() => {          this.table.listLoading = false        }, 100)      })    },    resetCreateTemp() {      this.create.createTemp = { pastureid: Cookies.get('pastureid'), remark: '', inventorydate: parseTime(new Date(), '{y}-{m}-{d}'), createuser: Cookies.get('employename') }    },    handleCreate() {      console.log('点击了新增盘点单')      this.resetCreateTemp()      this.create.dialogStatus = 'create'      this.create.dialogFormVisible = true      this.getMaxDate()      this.getCreateList()    },    disabledDate(time) {      return time.getTime() < new Date(this.create.maxDate) || time.getTime() > Date.now()    },    getMaxDate() {      GetDataByName(this.create.getMaxdataParm).then(response => {        this.create.maxDate = response.data.list[0].maxdate        console.log(response.data.list[0])      })    },    getCreateList() {      this.create.listLoading = true      GetDataByName(this.create.getdataListParm).then(response => {        console.log('table数据', response.data.list)        if (response.data.list !== null) {          for (let i = 0; i < response.data.list.length; i++) {            this.$set(response.data.list[i], 'factweight', '')            this.$set(response.data.list[i], 'differ', '')          }          this.create.list = response.data.list          this.create.pageNum = response.data.pageNum          this.create.pageSize = response.data.pageSize          this.create.total = response.data.total        } else {          this.create.list = []        }        setTimeout(() => {          this.create.listLoading = false        }, 100)      })    },    // 实际重量    blurFactweight(row) {      if (row.factweight !== '' && row.stockweight !== '') {        row.differ = parseFloat(row.factweight) - parseFloat(row.stockweight)      }    },    createData() {      this.$refs['createTemp'].validate(valid => {        if (valid) {          this.isokDisable = true          setTimeout(() => {            this.isokDisable = false          }, 1000)          var createList = []          for (let i = 0; i < this.create.list.length; i++) {            if (this.create.list[i].factweight !== '') {              createList.push(this.create.list[i])            }          }          for (let i = 0; i < createList.length; i++) {            const keepTwoNum = /^\d+(\.\d{1,2})?$/            // 实际重量            if (!keepTwoNum.test(parseFloat(createList[i].factweight))) {              this.$message({ type: 'error', message: '实际重量请输入自然数并保留两位小数', duration: 2000 })              return false            }          }          this.requestParam.common = { 'returnmap': '0' }          this.requestParam.data = []          this.requestParam.data[0] = { 'name': 'insertBigInventory', 'type': 'e', 'parammaps': {            'pastureid': this.create.createTemp.pastureid,            'inventorydate': parseTime(this.create.createTemp.inventorydate, '{y}-{m}-{d}'),            'createuser': this.create.createTemp.createuser,            'remark': this.create.createTemp.remark          }}          this.requestParam.data[1] = { 'name': 'insertSpotList', 'resultmaps': { 'list': createList }}          this.requestParam.data[1].children = []          this.requestParam.data[1].children[0] = { 'name': 'insertInventory', 'type': 'e', 'parammaps': {            invid: '@insertBigInventory.LastInsertId',            pastureid: '@insertSpotList.pastureid',            feedname: '@insertSpotList.feedname',            feedid: '@insertSpotList.feedid',            stockweight: '@insertSpotList.stockweight',            factweight: '@insertSpotList.factweight'          }}          ExecDataByConfig(this.requestParam).then(response => {            if (response.msg === 'fail') {              const inventorydate = new RegExp("key 'inventorydate'")              if (inventorydate.test(response.data)) {                this.$message({ type: 'error', message: '当前日期已盘点,不可重复录入', duration: 2000 })              } else {                this.$notify({ title: '保存失败', message: response.data, type: 'warning', duration: 2000 })              }            } else {              this.$notify({ title: '', message: '成功', type: 'success', duration: 2000 })              this.create.dialogFormVisible = false              this.getList()            }          })        }      })    },    handleSee(row) {      console.log('点击了查看')      this.create.dialogStatus = 'see'      this.create.dialogFormVisible = true      this.create.createTemp = Object.assign({}, row)      this.see.getdataListParm.parammaps.pastureid = row.pastureid      this.see.getdataListParm.parammaps.id = row.id      this.getSeeList()    },    getSeeList() {      this.create.listLoading = true      GetDataByName(this.see.getdataListParm).then(response => {        console.log('table数据', response.data.list)        if (response.data.list !== null) {          this.create.list = response.data.list          this.create.pageNum = response.data.pageNum          this.create.pageSize = response.data.pageSize          this.create.total = response.data.total        } else {          this.create.list = []        }        setTimeout(() => {          this.create.listLoading = false        }, 100)      })    },    handleRowDelete(row) {      MessageBox.confirm('是否确认删除此信息?', {        confirmButtonText: '确认', cancelButtonText: '取消', type: 'warning'      }).then(() => {        this.requestParam.name = 'deleteBigInventory'        this.requestParam.parammaps = {}        this.requestParam.parammaps.pastureid = row.pastureid        this.requestParam.parammaps.id = row.id        PostDataByName(this.requestParam).then(response => {          if (response.msg === 'fail') {            this.$notify({ title: '删除失败', message: response.data, type: 'warning', duration: 2000 })          } else {            this.$notify({ title: '成功', message: '删除成功', type: 'success', duration: 2000 })            this.getList()          }        })      }).catch(() => {        this.$message({ type: 'info', message: '已取消删除' })      })    },    handleInventoryList() {      this.download.getdataListParm.name = 'getFeedstorageWeightList'      this.download.getdataListParm.parammaps = {}      this.download.getdataListParm.parammaps.pastureid = Cookies.get('pastureid')      this.download.getdataListParm.parammaps.emp = Cookies.get('employename')      GetDataByName(this.download.getdataListParm).then(response => {        if (response.data.list !== null) {          this.download.list = response.data.list        } else {          this.download.list = []        }        var downloadList = [          { 'obj1': '1、文件类型为xlsx类型,对应表格文件名格式为:文件名称.xlsx;' },          { 'obj1': '2、底部工作表名称不可更改,默认为:Sheet1;' },          { 'obj1': '3、盘点日期,饲料名称为必填;' },          { 'obj1': '4、饲料名称必须与系统基础数据-饲料表中匹配;' },          { 'obj1': '5、实际重量为非负数,至多保留俩位小数;' },          { 'obj1': '6、盘点日期为文本格式的年-月-日,例:2020-10-10,盘点日期不可与系统已存在日期重复;盘点日期需保持一致' },          { 'obj1': '7、库存重量仅做参考,不与系统现有库存做校验;' },          { 'obj1': '8、实际重量可仅填写部分,导入已填写实际重量的饲料生成盘点单。' },          { 'obj1': '9、若有备注则填写在表格内容中第一个饲料行内即可;' }        ]        var excelDatas = [          {            tHeader: ['盘点日期', '盘点人', '备注', '饲料名称', '库存重量(kg)', '实际重量(kg)'],            filterVal: ['nowdate', 'emp', '', 'feedname', 'stockweight', ''],            tableDatas: this.download.list,            sheetName: 'Sheet1'          }, {            tHeader: ['填写规范:'],            filterVal: ['obj1'],            tableDatas: downloadList,            sheetName: 'Sheet2'          }        ]        json2excel(excelDatas, '盘点单导入模板', true, 'xlsx')      })    },    handleExport(item) {      if (item == 1) {        this.download.getdataListParm.parammaps.inputDatetime = this.table.getdataListParm.parammaps.inputDatetime        if (this.download.getdataListParm.parammaps.inputDatetime !== '' && this.download.getdataListParm.parammaps.inputDatetime !== null) {          this.download.getdataListParm.parammaps.startTime = parseTime(this.download.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')          this.download.getdataListParm.parammaps.stopTime = parseTime(this.download.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')        } else {          this.download.getdataListParm.parammaps.inputDatetime = ''          this.download.getdataListParm.parammaps.startTime = ''          this.download.getdataListParm.parammaps.stopTime = ''        }        this.download.getdataListParm.name = 'getBigInventoryList'        GetDataByName(this.download.getdataListParm).then(response => {          if (response.data.list !== null) {            this.download.list = response.data.list          } else {            this.download.list = []          }          var excelDatas = [            {              tHeader: ['盘点日期', '盘点人', '盘盈库存(kg)', '盘亏库存(kg)', '盈亏净值(kg)', '备注'],              filterVal: ['inventorydate', 'createuser', 'moreWeight', 'lessWeight', 'differWeight', 'remark'],              tableDatas: this.download.list,              sheetName: 'Sheet1'            }          ]          json2excel(excelDatas, '盘点单', true, 'xlsx')        })      } else {        this.download.getdataListParm.name = 'getInventoryList'        this.download.getdataListParm.parammaps = this.see.getdataListParm.parammaps        GetDataByName(this.download.getdataListParm).then(response => {          for (let i = 0; i < response.data.list.length; i++) {            this.$set(response.data.list[i], 'inventorydate', this.create.createTemp.inventorydate)            this.$set(response.data.list[i], 'createuser', this.create.createTemp.createuser)            this.$set(response.data.list[i], 'remark', this.create.createTemp.remark)          }          if (response.data.list !== null) {            this.download.list = response.data.list          } else {            this.download.list = []          }          var excelDatas = [            {              tHeader: ['盘点日期', '盘点人', '备注', '饲料名称', '库存重量(kg)', '实际重量(kg)', '差值(kg)'],              filterVal: ['inventorydate', 'createuser', 'remark', 'feedname', 'stockweight', 'factweight', 'differ'],              tableDatas: this.download.list,              sheetName: 'Sheet1'            }          ]          json2excel(excelDatas, '盘点-查看', true, 'xlsx')        })      }    },    beforeImport(file) {      const isLt2M = file.size / 1024 / 1024 < 2      if (!isLt2M) {        this.$message.error('上传文件大小不能超过 2MB!')      }      return isLt2M    },    handleImportSuccess(res, file) {      this.getList()      if (res.msg === 'ok') {        this.$message({ title: '成功', message: '导入成功:' + res.data.success + '条!', type: 'success', duration: 2000 })        if (res.data.err_count > 0) {          this.$notify({ title: '失败', message: '导入失败:' + res.data.err_count + '条!', type: 'danger', duration: 2000 })           import('@/vendor/Export2Excel').then(excel => {             const list1 = res.data.result             const tHeader = [               '盘点日期', '盘点人', '备注', '饲料名称', '库存重量(kg)', '实际重量(kg)', '错误信息'             ]             const filterVal = [               '盘点日期', '盘点人', '备注', '饲料名称', '库存重量(kg)', '实际重量(kg)', 'error_msg'             ]             const data1 = this.formatJson(filterVal, list1)             excel.export_json_to_excel({ header: tHeader, data: data1, filename: '盘点单报错信息', autoWidth: true, bookType: 'xlsx' })           })        }      } else {        this.$notify({ title: '失败', message: '上传失败', type: 'danger', duration: 2000 })      }    },    formatJson(filterVal, jsonData) {      return jsonData.map(v =>        filterVal.map(j => {          if (j === 'timestamp') {            return parseTime(v[j])          } else {            return v[j]          }        })      )    }  }}</script><style lang="scss" scoped>  .search{margin-top:10px;}  .table{margin-top:10px;}</style><style>  .inputDatetime .el-range-separator{ padding: 0; margin: 0 10px; }</style>
 |