<template> <div class="app-container"> <div class="operation"> <el-button v-if="isRoleEdit" class="success" style="float: left;margin-right:10px;" @click="handleCreate">新增</el-button> <el-button v-if="isRoleEdit" class="danger" style="float: left;margin-right:10px;" @click="handleDelete">删除</el-button> <el-button v-if="isRoleEdit" class="warning" style="float: left;margin-right:10px;" @click="handleCopy">复制</el-button> <el-upload v-if="isRoleEdit" style="float: right;" :headers="headers" :data="uploadData" :action="uploadExcelUrl" :show-file-list="false" :before-upload="beforeImport" :on-success="handleImportSuccess"> <el-button class="import" style="float: right;">导入</el-button> </el-upload> <el-dropdown style="float: right;margin-right: 10px;"> <el-button class="export">导出</el-button> <el-dropdown-menu slot="dropdown"> <el-dropdown-item @click.native="handleExport(1)">导出模板</el-dropdown-item> <el-dropdown-item @click.native="handleExport(2)">导出数据</el-dropdown-item> </el-dropdown-menu> </el-dropdown> </div> <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-select v-model="table.getdataListParm.parammaps.barid" placeholder="栏舍名称" class="filter-item" style="width: 120px;" clearable> <el-option v-for="item in houseNameList" :key="item.id" :label="item.bname" :value="item.id" /> </el-select> <el-button class="successBorder" @click="handleSearch">查询</el-button> <el-button class="successBorder" @click="handleRefresh">重置</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" @selection-change="handleSelectionChange" > <el-table-column type="selection" align="center" width="50" /> <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="150px" align="center"> <template slot-scope="scope"> <span>{{ scope.row.barname }}</span> </template> </el-table-column> <el-table-column label="剩料量(kg)" min-width="150px" align="center"> <template slot-scope="scope"> <span>{{ scope.row.remain }}</span> </template> </el-table-column> <el-table-column label="应用班次" min-width="90px" align="center"> <template slot-scope="scope"> <span>{{ scope.row.timesstr }}</span> </template> </el-table-column> <el-table-column label="处理时间" min-width="100px" align="center"> <template slot-scope="scope"> <span>{{ scope.row.operatetime }}</span> </template> </el-table-column> <el-table-column label="操作人" min-width="90px" align="center"> <template slot-scope="scope"> <span>{{ scope.row.emp }}</span> </template> </el-table-column> <el-table-column label="操作" align="center" width="250" class-name="small-padding fixed-width" fixed="right"> <template slot-scope="{row}"> <el-button v-if="isRoleEdit" class="miniSuccess" @click="handleUpdate(row)">编辑</el-button> <el-button v-if="isRoleEdit" class="miniDanger" @click="handleRowDelete(row)">删除</el-button> </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="40%"> <div class="app-add"> <el-form ref="temp" :rules="create.rules" :model="create.temp" label-position="right" label-width="135px" style="width: 90%;margin:0 auto 50px"> <el-row> <el-col :span="20"> <el-form-item label="栏舍名称:" prop="barid"> <el-select ref="barid" v-model="create.temp.barid" :disabled="create.dialogStatus=='update'" filterable placeholder="栏舍名称" class="filter-item" style="width: 100%;" @change="changeBar"> <el-option v-for="item in houseNameList" :key="item.id" :label="item.bname" :value="item.id" /> </el-select> </el-form-item> </el-col> </el-row> <el-row> <el-col :span="20"> <el-form-item label="剩料量:" prop="remain"> <el-input ref="remain" v-model="create.temp.remain" class="filter-item" placeholder="剩料量" type="number" /> </el-form-item> </el-col> </el-row> <el-row> <el-col :span="20"> <el-form-item label="班次:" prop="times"> <el-select ref="times" v-model="create.temp.times" filterable placeholder="班次" class="filter-item" style="width: 100%;"> <el-option v-for="item in frequencyList" :key="item.id" :label="item.name" :value="item.id" /> </el-select> </el-form-item> </el-col> </el-row> <el-row> <el-col :span="20"> <el-form-item label="处理时间:" prop="operatetime"> <el-date-picker v-model="create.temp.operatetime" :disabled="create.dialogStatus=='update'" type="datetime" placeholder="选择处理时间" format="yyyy-MM-dd HH:mm" value-format="yyyy-MM-dd HH:mm" style="width: 100%;" :clearable="false" /> </el-form-item> </el-col> </el-row> <el-row> <el-col :span="20"> <el-form-item label="操作人:" prop="emp"> <el-select ref="emp" v-model="create.temp.emp" filterable placeholder="操作人" class="filter-item" style="width: 100%;" @blur="blurEmp"> <el-option v-for="item in create.noteTakerList" :key="item.myId" :label="item.emp" :value="item.emp" /> </el-select> </el-form-item> </el-col> </el-row> </el-form> <div slot="footer" class="dialog-footer"> <el-button class="cancelClose" @click="create.dialogFormVisible = false;getList()">关闭</el-button> <el-button v-if="create.dialogStatus==='create'" class="success" :disabled="isokDisable" @click="createDataAgain()">确认新增</el-button> <el-button v-if="create.dialogStatus==='create' || create.dialogStatus==='update'" class="success" :disabled="isokDisable" @click="create.dialogStatus==='create'?createData():updateData()">确认</el-button> </div> </div> </el-dialog> </div> </template> <script> import { GetDataByName, PostDataByName, failproccess, ExecDataByConfig, GetDataByNames, checkButtons } from '@/api/common' import Cookies from 'js-cookie' import { parseTime, json2excel } from '@/utils/index.js' import Pagination from '@/components/Pagination' import { MessageBox } from 'element-ui' import { getToken } from '@/utils/auth' export default { name: 'MaterialRemainingRecord', components: { Pagination }, data() { return { isRoleEdit: [], requestParams: [ { name: 'getBarListEnable', offset: 0, pagecount: 0, parammaps: { 'pastureid': Cookies.get('pastureid') }}, { name: 'getSysoptEnable', offset: 0, pagecount: 0, parammaps: { 'pastureid': Cookies.get('pastureid'), 'inforname': 'times' }} ], houseNameList: [], // 栏舍名称 frequencyList: [], // 班次 table: { getdataListParm: { name: 'getBarfeedremainList', page: 1, offset: 1, pagecount: 10, returntype: 'Map', parammaps: { pastureid: Cookies.get('pastureid'), barid: '', startTime: '', stopTime: '', inputDatetime: '' } }, tableKey: 0, list: [], total: 0, listLoading: true, temp: {} }, // 新增/编辑 create: { dialogFormVisible: false, dialogStatus: '', temp: { pastureid: Cookies.get('pastureid'), operatetime: parseTime(new Date(), '{y}-{m}-{d} {h}:{i}'), emp: Cookies.get('employename'), barid: '', barname: '', remain: '', times: '' }, rules: { barid: [{ type: 'string', required: true, message: '必填', trigger: 'blur' }], remain: [{ type: 'string', required: true, message: '必填', trigger: 'blur' }], times: [{ type: 'string', required: true, message: '必填', trigger: 'blur' }] }, getdataListParm: { name: 'getBarfeedremainEmpHis', page: 1, offset: 1, pagecount: 10, returntype: 'Map', parammaps: { pastureid: Cookies.get('pastureid') } }, noteTakerList: [] // 记录人 }, textMap: { create: '新增', update: '编辑' }, requestParam: {}, download: { getdataListParm: { name: 'getBarfeedremainList', page: 1, offset: 1, pagecount: 0, returntype: 'Map', parammaps: { pastureid: Cookies.get('pastureid'), barid: '', startTime: '', stopTime: '', inputDatetime: '' } }, list: [] }, isokDisable: false, selectList: [], rowStyle: { maxHeight: 50 + 'px', height: 45 + 'px' }, cellStyle: { padding: 0 + 'px' } } }, computed: { // 设置请求头 headers() { return { token: getToken() } }, uploadData() { return { name: '颛孙洋洋-栏舍剩料记录', importParams: '栏舍名称,剩料量(kg),应用班次,处理时间 ,操作人', sheetname: 'SheetJS' } }, // 设置上传地址 uploadExcelUrl() { return process.env.VUE_APP_BASE_API + 'authdata/ImportExcel' } }, created() { this.getList() this.getDownList() this.getButtons() }, methods: { getButtons() { const Edit = 'MaterialRemainingRecord' const isRoleEdit = checkButtons(JSON.parse(sessionStorage.getItem('buttons')), Edit) this.isRoleEdit = isRoleEdit }, getDownList() { GetDataByNames(this.requestParams).then(response => { this.houseNameList = response.data.getBarListEnable.list if (response.data.getSysoptEnable.list !== null) { for (let i = 1; i <= response.data.getSysoptEnable.list[0].inforvalue; i++) { const obj = {} obj.id = String(i) if (i == 1) { obj.name = '第一班' } else if (i == 2) { obj.name = '第二班' } else if (i == 3) { obj.name = '第三班' } else if (i == 4) { obj.name = '第四班' } this.frequencyList.push(obj) } } else { this.frequencyList = [] } }) }, 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.$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.$forceUpdate() } }, 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) }) }, 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() }, handleRefresh() { console.log('点击了重置') this.table.getdataListParm.parammaps.barid = '' this.table.getdataListParm.parammaps.startTime = '' this.table.getdataListParm.parammaps.stopTime = '' this.table.getdataListParm.parammaps.inputDatetime = '' this.table.getdataListParm.offset = 1 this.getList() }, // 新增 resetTemp() { this.create.temp = { pastureid: Cookies.get('pastureid'), operatetime: parseTime(new Date(), '{y}-{m}-{d} {h}:{i}'), emp: Cookies.get('employename'), barid: '', barname: '', remain: '', times: '' } }, blurEmp(item) { this.create.temp.emp = item.target.value }, // 栏舍名称 changeBar(item) { this.create.temp.barname = this.houseNameList.find(obj => obj.id === item).bname }, getNoteTakerList() { GetDataByName(this.create.getdataListParm).then(response => { if (response.data.list !== null) { for (let i = 0; i < response.data.list.length; i++) { response.data.list[i].myId = i } this.create.noteTakerList = response.data.list console.log('记录人数据', response.data.list) console.log(this.create.noteTakerList) } else { this.create.noteTakerList = [] } }) }, handleCreate() { console.log('点击了新增') this.resetTemp() this.getNoteTakerList() this.create.dialogStatus = 'create' this.create.dialogFormVisible = true }, createData() { console.log('点击了新增保存') this.isokDisable = true setTimeout(() => { this.isokDisable = false }, 1000) this.$refs['temp'].validate(valid => { if (valid) { this.isokDisable = true setTimeout(() => { this.isokDisable = false }, 1000) const remain = /^\d+(\.\d{1,2})?$/ // 剩料量 if (!remain.test(parseFloat(this.create.temp.remain))) { this.$message({ type: 'error', message: '剩料量请输入自然数并保留两位小数', duration: 2000 }) return false } this.requestParam.name = 'insertBarfeedremain' this.requestParam.parammaps = this.create.temp if (this.create.temp.emp == '') { this.create.temp.emp = Cookies.get('employename') } PostDataByName(this.requestParam).then(response => { console.log('新增保存发送参数', this.requestParam) if (response.msg !== 'fail') { this.$notify({ title: '成功', message: '保存成功', type: 'success', duration: 2000 }) this.create.dialogFormVisible = false this.getList() } else { const barid = new RegExp("key 'barid'") if (barid.test(response.data)) { this.$message({ type: 'error', message: '该栏舍该班次今日剩料量已存在,不可重复生成', duration: 2000 }) } else { failproccess(response, this.$notify) } } }) } }) }, createDataAgain() { console.log('点击了新增保存') this.isokDisable = true setTimeout(() => { this.isokDisable = false }, 1000) this.$refs['temp'].validate(valid => { if (valid) { this.isokDisable = true setTimeout(() => { this.isokDisable = false }, 1000) const remain = /^\d+(\.\d{1,2})?$/ // 剩料量 if (!remain.test(parseFloat(this.create.temp.remain))) { this.$message({ type: 'error', message: '剩料量请输入自然数并保留两位小数', duration: 2000 }) return false } this.requestParam.name = 'insertBarfeedremain' this.requestParam.parammaps = this.create.temp if (this.create.temp.emp == '') { this.create.temp.emp = Cookies.get('employename') } PostDataByName(this.requestParam).then(response => { console.log('新增保存发送参数', this.requestParam) if (response.msg !== 'fail') { this.$notify({ title: '成功', message: '保存成功', type: 'success', duration: 2000 }) this.resetTemp() this.getList() this.getNoteTakerList() } else { const barid = new RegExp("key 'barid'") if (barid.test(response.data)) { this.$message({ type: 'error', message: '该栏舍该班次今日剩料量已存在,不可重复生成', duration: 2000 }) } else { failproccess(response, this.$notify) } } }) } }) }, // 编辑 handleUpdate(row) { console.log('点击了编辑', row) row.barid = String(row.barid) this.create.temp = Object.assign({}, row) this.create.temp.id = row.id this.getNoteTakerList() this.create.dialogStatus = 'update' this.create.dialogFormVisible = true }, updateData() { this.isokDisable = true setTimeout(() => { this.isokDisable = false }, 1000) this.$refs['temp'].validate(valid => { if (valid) { this.isokDisable = true setTimeout(() => { this.isokDisable = false }, 1000) const remain = /^\d+(\.\d{1,2})?$/ // 剩料量 if (!remain.test(parseFloat(this.create.temp.remain))) { this.$message({ type: 'error', message: '剩料量请输入自然数并保留两位小数', duration: 2000 }) return false } this.requestParam.name = 'updateBarfeedremain' this.requestParam.parammaps = this.create.temp if (this.create.temp.emp == '') { this.create.temp.emp = Cookies.get('employename') } PostDataByName(this.requestParam).then(response => { console.log('新增保存发送参数', this.requestParam) if (response.msg !== 'fail') { this.$notify({ title: '成功', message: '保存成功', type: 'success', duration: 2000 }) this.create.dialogFormVisible = false this.getList() } else { failproccess(response, this.$notify) } }) } }) }, // 删除 handleRowDelete(row) { console.log('点击了行内删除') MessageBox.confirm('是否确认删除此信息?', { confirmButtonText: '确认', cancelButtonText: '取消', type: 'warning' }).then(() => { this.selectList = [] this.requestParam.name = 'deleteBarfeedremain' 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: '已取消删除' }) }) }, handleSelectionChange(val) { console.log('勾选数据', val) this.selectList = val }, handleDelete() { console.log('点击了删除') if (this.selectList.length == 0) { this.$message({ type: 'error', message: '请选择栏舍剩料记录', duration: 2000 }) } else { MessageBox.confirm('当前选中' + this.selectList.length + '条信息,是否删除?', { confirmButtonText: '确认', cancelButtonText: '取消', type: 'warning' }).then(() => { console.log(this.selectList) this.requestParam.common = { 'returnmap': '0' } this.requestParam.data = [] this.requestParam.data[0] = { 'name': 'insertSpotList', 'resultmaps': { 'list': this.selectList }} this.requestParam.data[0].children = [] this.requestParam.data[0].children[0] = { 'name': 'deleteBarfeedremain', 'type': 'e', 'parammaps': { id: '@insertSpotList.id', pastureid: '@insertSpotList.pastureid' }} ExecDataByConfig(this.requestParam).then(response => { console.log('删除保存发送参数', this.requestParam) 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() } }) }) } }, // 复制 handleCopy() { console.log('点击了复制') if (this.selectList.length == 0) { this.$message({ type: 'error', message: '请选择栏舍剩料记录', duration: 2000 }) } else if (this.selectList.length == 1) { MessageBox.confirm('是否确认复制此信息?', { confirmButtonText: '确认', cancelButtonText: '取消', type: 'warning' }).then(() => { this.requestParam.name = 'copybarfeedremain' this.requestParam.parammaps = {} this.requestParam.parammaps.pastureid = this.selectList[0].pastureid this.requestParam.parammaps.id = this.selectList[0].id PostDataByName(this.requestParam).then(response => { if (response.msg === 'fail') { const barid = new RegExp("key 'barid'") if (barid.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.getList() } }) }).catch(() => { this.$message({ type: 'info', message: '已取消删除' }) }) } else { this.$message({ type: 'error', message: '请选择一条栏舍剩料记录', duration: 2000 }) } }, // 导出 handleExport(item) { if (item == 1) { console.log('点击了导出模板') } else { console.log('点击了导出数据') this.download.getdataListParm.parammaps = this.table.getdataListParm.parammaps 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 = '' } 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)', '应用班次', '处理时间', '操作人'], filterVal: ['barname', 'remain', 'timesstr', 'operatetime', 'emp'], 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)', '应用班次', '处理时间', '操作人', '错误信息'] const filterVal = ['栏舍名称', '剩料量(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{padding-top:10px;clear: both;} .table{margin-top:10px;} </style>