123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634 |
- <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 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 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" class="centerSpan">|</span>
- <el-button v-if="scope.$index + (table.pageNum-1) * table.pageSize + 1 == 1" 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 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, 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: 10,
- 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: 10,
- 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,
- 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.getList()
- },
- methods: {
- 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>
|