123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646 |
- <template>
- <div class="app-container">
- <div class="operation">
- <el-button class="success" @click="handleCreate">新增合同</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" 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.providerid" filterable placeholder="请选择供应商" class="filter-item" style="width: 150px;" clearable>
- <el-option v-for="item in supplierList" :key="item.id" :label="item.providerName" :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"
- >
- <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.contractcode }}</span>
- </template>
- </el-table-column>
- <el-table-column label="供应商" min-width="130px" align="center">
- <template slot-scope="scope">
- <span>{{ scope.row.providername }}</span>
- </template>
- </el-table-column>
- <el-table-column label="录入日期" min-width="110px" align="center">
- <template slot-scope="scope">
- <span>{{ scope.row.operatetime }}</span>
- </template>
- </el-table-column>
- <el-table-column label="启用" min-width="110px" align="center">
- <template slot-scope="scope">
- <el-switch v-model="scope.row.enable" disabled active-color="#13ce66" inactive-color="#ff4949" :active-value="1" :inactive-value="0" />
- </template>
- </el-table-column>
- <el-table-column label="操作" align="center" width="320" class-name="small-padding fixed-width" fixed="right">
- <template slot-scope="{row}">
- <el-button class="miniPrimary" @click="handleSee(row)">查看</el-button>
- <el-button class="miniSuccess" @click="handleUpdate(row)">编辑</el-button>
- <el-button 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="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="contractcode">
- <el-input ref="contractcode" v-model="create.createTemp.contractcode" class="filter-item" placeholder="合同编号" type="text" :disabled="create.dialogStatus !== 'create'" />
- </el-form-item>
- </el-col>
- <el-col :span="8">
- <el-form-item label="供应商:" prop="providerid">
- <el-select v-model="create.createTemp.providerid" filterable placeholder="请选择供应商" class="filter-item" style="width: 100%;" :disabled="create.dialogStatus !== 'create'" @change="changeSupplier">
- <el-option v-for="item in supplierList" :key="item.id" :label="item.providerName" :value="item.id" />
- </el-select>
- </el-form-item>
- </el-col>
- <el-col :span="8">
- <el-form-item label="录入日期:" prop="operatetime">
- <el-date-picker v-model="create.createTemp.operatetime" class="filter-item" type="date" placeholder="录入日期" :disabled="create.dialogStatus==='see'" :clearable="false" />
- </el-form-item>
- </el-col>
- </el-row>
- <el-row>
- <el-col :span="8">
- <el-form-item label="添加饲料:" prop="feedid">
- <el-select v-model="create.createTemp.feedid" filterable placeholder="请选择饲料" class="filter-item" style="width: 100%;" :disabled="create.dialogStatus==='see'" @change="changeFeedNameAdd">
- <el-option v-for="item in feedNameAddList" :key="item.id" :label="item.fname" :value="item.id" />
- </el-select>
- </el-form-item>
- </el-col>
- <el-col :span="8">
- <el-form-item label="是否启用:" prop="enable">
- <el-switch v-model="create.createTemp.enable" :disabled="create.dialogStatus==='see'" active-color="#13ce66" inactive-color="#ff4949" :active-value="1" :inactive-value="0" />
- </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="饲料价格" min-width="130px" align="center">
- <template slot-scope="scope">
- <el-input v-if="create.dialogStatus !=='see'" ref="input" v-model="scope.row.price" type="number" :step="0.01" placeholder="最多两位小数" style="width:80%;padding:10px 0;" />
- <span v-else> {{ scope.row.price }}</span>
- </template>
- </el-table-column>
- <el-table-column v-if="create.dialogStatus !=='see'" label="操作" align="center" width="120" class-name="small-padding fixed-width" fixed="right">
- <template slot-scope="{row}">
- <a class="smallDanger" @click="handleFeedDelete(row)">删除</a>
- </template>
- </el-table-column>
- </el-table>
- <div slot="footer" class="dialog-footer">
- <el-button class="cancelClose" @click="create.dialogFormVisible = false; ">关闭</el-button>
- <el-button v-if="create.dialogStatus !== 'see'" class="success" :disabled="isokDisable" @click="create.dialogStatus==='create'?createData():updateData()">确认</el-button>
- </div>
- </div>
- </el-dialog>
- </div>
- </template>
- <script>
- import { GetDataByName, GetDataByNames, checkButtons, ExecDataByConfig, failproccess } 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 { getToken } from '@/utils/auth'
- export default {
- name: 'FeedContract',
- components: { Pagination },
- data() {
- return {
- isRoleEdit: [],
- requestParams: [
- { name: 'getProviderListEnable', offset: 0, pagecount: 0, parammaps: { pastureid: Cookies.get('pastureid') }},
- { name: 'getFeedListEnable', offset: 0, pagecount: 0, parammaps: { pastureid: Cookies.get('pastureid') }}
- ],
- supplierList: [], // 供应商
- feedNameAddList: [], // 饲料名称
- table: {
- getdataListParm: {
- name: 'getBigContractList',
- page: 1,
- offset: 1,
- pagecount: 10,
- returntype: 'Map',
- parammaps: {
- pastureid: Cookies.get('pastureid'),
- inputDatetime: '',
- startTime: '',
- stopTime: ''
- }
- },
- tableKey: 0,
- list: [],
- total: 0,
- listLoading: true
- },
- textMap: {
- create: '新增合同',
- update: '编辑合同',
- see: '查看合同'
- },
- create: {
- dialogFormVisible: false,
- dialogStatus: '',
- createTemp: {
- pastureid: Cookies.get('pastureid'), 'providerid': '', 'providername': '', 'emp': Cookies.get('employename'), 'enable': 1, 'operatetime': parseTime(new Date(), '{y}-{m}-{d}')
- },
- rules: {
- contractcode: [{ type: 'string', required: true, message: '必填', trigger: 'blur' }],
- providerid: [{ type: 'string', required: true, message: '必填', trigger: 'blur' }]
- },
- getdataListParm: {
- name: 'getContractList',
- page: 1,
- offset: 1,
- pagecount: 10,
- returntype: 'Map',
- parammaps: {}
- },
- listLoading: false,
- tableKey: 0,
- list: []
- },
- requestParam: {},
- download: {
- getdataListParm: {
- name: 'getBigContractList',
- page: 1,
- offset: 1,
- pagecount: 0,
- returntype: 'Map',
- parammaps: {
- pastureid: Cookies.get('pastureid'),
- inputDatetime: '',
- startTime: '',
- stopTime: ''
- }
- },
- list: []
- },
- isokDisable: false,
- rowStyle: { maxHeight: 50 + 'px', height: 45 + 'px' },
- cellStyle: { padding: 0 + 'px' }
- }
- },
- computed: {
- // 设置请求头
- headers() {
- return {
- token: getToken()
- }
- },
- uploadData() {
- return {
- name: '颛孙洋洋-饲料合同',
- importParams: '合同编号, 供应商, 饲料名称, 饲料价格(元), 录入日期',
- sheetname: 'SheetJS'
- }
- },
- // 设置上传地址
- uploadExcelUrl() {
- return process.env.VUE_APP_BASE_API + 'authdata/ImportExcel'
- }
- },
- created() {
- this.getButtons()
- this.getDownList()
- this.getList()
- },
- methods: {
- getButtons() {
- const Edit = 'FeedContract'
- const isRoleEdit = checkButtons(JSON.parse(sessionStorage.getItem('buttons')), Edit)
- this.isRoleEdit = isRoleEdit
- },
- getDownList() {
- GetDataByNames(this.requestParams).then(response => {
- this.supplierList = response.data.getProviderListEnable.list
- this.feedNameAddList = response.data.getFeedListEnable.list
- })
- },
- 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()
- this.getList()
- }
- },
- 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()
- }
- },
- 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() {
- 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() {
- this.table.getdataListParm.parammaps.inputDatetime = ''
- this.table.getdataListParm.parammaps.startTime = ''
- this.table.getdataListParm.parammaps.stopTime = ''
- this.table.getdataListParm.parammaps.providerid = ''
- },
- resetCreateTemp() {
- this.create.createTemp = {
- pastureid: Cookies.get('pastureid'), 'providerid': '', 'providername': '', 'emp': Cookies.get('employename'), 'enable': 1, 'operatetime': parseTime(new Date(), '{y}-{m}-{d}')
- }
- this.create.list = []
- },
- handleCreate() {
- console.log('点击了新增')
- this.resetCreateTemp()
- this.create.dialogStatus = 'create'
- this.create.dialogFormVisible = true
- },
- // 供应商
- changeSupplier(item) {
- this.create.createTemp.providername = this.supplierList.find(obj => obj.id == item).providerName
- },
- // 新增饲料
- changeFeedNameAdd(item) {
- var obj = {}
- obj.feedid = item
- obj.feedname = this.feedNameAddList.find(obj => obj.id == item).fname
- obj.pastureid = this.feedNameAddList.find(obj => obj.id == item).pastureid
- obj.price = ''
- obj.myId = (new Date()).valueOf()
- for (let i = 0; i < this.create.list.length; i++) {
- if (this.create.list[i].feedid == item) {
- this.$message({ type: 'warning', message: '添加饲料不可重复', duration: 2000 })
- return false
- }
- }
- this.create.list.push(obj)
- },
- handleFeedDelete(row) {
- for (let i = 0; i < this.create.list.length; i++) {
- console.log(this.create.list[i])
- if (this.create.list[i].myId === row.myId) {
- var listAddIndex = this.create.list.indexOf(this.create.list[i])
- }
- if (listAddIndex > -1) {
- this.create.list.splice(listAddIndex, 1)
- return
- }
- }
- },
- createData() {
- console.log('点击了新增保存')
- this.$refs['createTemp'].validate(valid => {
- if (valid) {
- this.isokDisable = true
- setTimeout(() => {
- this.isokDisable = false
- }, 1000)
- console.log(this.create.list.length)
- if (this.create.list.length == 0) {
- this.$message({ type: 'warning', message: '请添加饲料', duration: 2000 })
- return false
- }
- const rulesPrice = /^\d+(\.\d{1,2})?$/
- for (let i = 0; i < this.create.list.length; i++) {
- if (this.create.list[i].price == '') {
- this.$message({ type: 'warning', message: '饲料价格不可为空', duration: 2000 })
- return false
- }
- if (!rulesPrice.test(parseFloat(this.create.list[i].price))) {
- this.$message({ type: 'warning', message: '饲料价格最多保留两位小数', duration: 2000 })
- return false
- }
- }
- this.create.createTemp.operatetime = parseTime(this.create.createTemp.operatetime, '{y}-{m}-{d}')
- this.requestParam.common = { 'returnmap': '0' }
- this.requestParam.data = []
- this.requestParam.data[0] = { 'name': 'insertBigContract', 'type': 'e', 'parammaps': {
- 'pastureid': this.create.createTemp.pastureid,
- 'contractcode': this.create.createTemp.contractcode,
- 'providerid': this.create.createTemp.providerid,
- 'providername': this.create.createTemp.providername,
- 'emp': this.create.createTemp.emp,
- 'enable': this.create.createTemp.enable,
- 'operatetime': this.create.createTemp.operatetime
- }}
- this.requestParam.data[1] = { 'name': 'insertSpotList', 'resultmaps': { 'list': this.create.list }}
- this.requestParam.data[1].children = []
- this.requestParam.data[1].children[0] = { 'name': 'insertContract', 'type': 'e', 'parammaps': {
- pastureid: '@insertSpotList.pastureid',
- bigid: '@insertBigContract.LastInsertId',
- feedid: '@insertSpotList.feedid',
- feedname: '@insertSpotList.feedname',
- price: '@insertSpotList.price'
- }}
- ExecDataByConfig(this.requestParam).then(response => {
- if (response.msg == 'fail') {
- const contractcode = new RegExp("key 'contractcode'")
- if (contractcode.test(response.data)) {
- this.$message({ type: 'error', message: '该合同已存在,不可重复生成', duration: 2000 })
- } else {
- failproccess(response, this.$notify)
- }
- } else {
- this.$notify({ title: '', message: '成功', type: 'success', duration: 2000 })
- this.create.dialogFormVisible = false
- this.getList()
- }
- })
- }
- })
- },
- handleUpdate(row) {
- console.log('点击了编辑')
- this.create.dialogStatus = 'update'
- this.create.dialogFormVisible = true
- this.create.createTemp = Object.assign({}, row)
- this.create.getdataListParm.parammaps.pastureid = row.pastureid
- this.create.getdataListParm.parammaps.id = row.id
- this.getSeeList()
- },
- updateData() {
- console.log('点击了编辑保存')
- this.$refs['createTemp'].validate(valid => {
- if (valid) {
- this.isokDisable = true
- setTimeout(() => {
- this.isokDisable = false
- }, 1000)
- console.log(this.create.list.length)
- if (this.create.list.length == 0) {
- this.$message({ type: 'warning', message: '请添加饲料', duration: 2000 })
- return false
- }
- const rulesPrice = /^\d+(\.\d{1,2})?$/
- for (let i = 0; i < this.create.list.length; i++) {
- if (this.create.list[i].price == '') {
- this.$message({ type: 'warning', message: '饲料价格不可为空', duration: 2000 })
- return false
- }
- if (!rulesPrice.test(parseFloat(this.create.list[i].price))) {
- this.$message({ type: 'warning', message: '饲料价格最多保留两位小数', duration: 2000 })
- return false
- }
- }
- this.create.createTemp.operatetime = parseTime(this.create.createTemp.operatetime, '{y}-{m}-{d}')
- this.requestParam.common = { 'returnmap': '0' }
- this.requestParam.data = []
- this.requestParam.data[0] = { 'name': 'updateBigContract', 'type': 'e', 'parammaps': {
- 'pastureid': this.create.createTemp.pastureid,
- 'id': this.create.createTemp.id,
- 'operatetime': this.create.createTemp.operatetime,
- 'enable': this.create.createTemp.enable
- }}
- this.requestParam.data[1] = { 'name': 'deleteContract', 'type': 'e', 'parammaps': {
- 'pastureid': this.create.createTemp.pastureid,
- 'id': this.create.createTemp.id
- }}
- this.requestParam.data[2] = { 'name': 'insertSpotList', 'resultmaps': { 'list': this.create.list }}
- this.requestParam.data[2].children = []
- this.requestParam.data[2].children[0] = { 'name': 'insertContract', 'type': 'e', 'parammaps': {
- pastureid: '@insertSpotList.pastureid',
- bigid: this.create.createTemp.id,
- feedid: '@insertSpotList.feedid',
- feedname: '@insertSpotList.feedname',
- price: '@insertSpotList.price'
- }}
- ExecDataByConfig(this.requestParam).then(response => {
- if (response.msg === 'fail') {
- failproccess(response, this.$notify)
- } 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.create.getdataListParm.parammaps.pastureid = row.pastureid
- this.create.getdataListParm.parammaps.id = row.id
- this.getSeeList()
- },
- getSeeList() {
- this.create.listLoading = true
- GetDataByName(this.create.getdataListParm).then(response => {
- console.log('查看table数据', response.data.list)
- if (response.data.list !== null) {
- this.create.list = response.data.list
- } else {
- this.create.list = []
- }
- setTimeout(() => {
- this.create.listLoading = false
- }, 100)
- })
- },
- handleRowDelete(row) {
- MessageBox.confirm('是否确认删除此信息?', {
- confirmButtonText: '确认', cancelButtonText: '取消', type: 'warning'
- }).then(() => {
- console.log('点击了删除')
- this.requestParam.common = { 'returnmap': '0' }
- this.requestParam.data = []
- this.requestParam.data[0] = { 'name': 'deleteBigContract', 'type': 'e', 'parammaps': {
- 'pastureid': row.pastureid,
- 'id': row.id
- }}
- this.requestParam.data[1] = { 'name': 'deleteContract', 'type': 'e', 'parammaps': {
- 'pastureid': row.pastureid,
- 'id': row.id
- }}
- ExecDataByConfig(this.requestParam).then(response => {
- if (response.msg === 'fail') {
- failproccess(response, this.$notify)
- } else {
- this.$notify({ title: '', message: '成功', type: 'success', duration: 2000 })
- this.getList()
- }
- })
- }).catch(() => {
- this.$message({ type: 'info', message: '已取消删除' })
- })
- },
- 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: ['合同编号', '供应商', '饲料名称', '饲料价格(元)', '录入日期'],
- filterVal: ['contractcode', 'providername', 'feedname', 'price', 'operatetime'],
- 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 = [
- '合同编号', '供应商', '饲料名称', '饲料价格(元)', '录入日期', '错误信息'
- ]
- const filterVal = [
- '合同编号', '供应商', '饲料名称', '饲料价格(元)', '录入日期', '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>
|