123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558 |
- <template>
- <div class="app-container">
- <div class="operation">
- <el-button class="success" @click="handleCreate">新增盘点单</el-button>
- <el-button class="success" @click="handleInventoryList">下载盘点单</el-button>
- <el-button class="import" style="float: right;" @click="handleExport(1)">导出</el-button>
- </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-button class="successBorder" @click="handleSearch">查询</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="320" class-name="small-padding fixed-width" fixed="right">
- <template slot-scope="scope">
- <el-button class="miniPrimary" :disabled="isokDisable" @click="handleSee(scope.row)">查看</el-button>
- <el-button v-if="scope.$index + (table.pageNum-1) * table.pageSize + 1 == 1" class="miniDanger" @click="handleRowDelete(scope.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="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="success" :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="success" :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: 50 + 'px', height: 45 + 'px' },
- cellStyle: { padding: 0 + 'px' }
- }
- },
- 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()
- }
- })
- }
- })
- },
- handleInventoryList() {
- console.log('点击了下载盘点单')
- const requestParam = this.requestParam
- const url = process.env.VUE_APP_BASE_API + 'file/导入导出模板/库存管理/盘点单导入模板.xlsx' // 请求下载文件的地址
- console.log(url)
- axios({
- method: 'GET',
- url: url,
- data: requestParam,
- headers: { token: getToken(), optname: 'insertcustomdoc' },
- responseType: 'blob'
- }).then(res => {
- if (!res) return
- this.percentage = 99
- setTimeout(() => {
- this.isPercentage = false
- }, 2000)
- const blob = new Blob([res.data], {
- type: 'application/octet-stream;charset=utf-8'
- })
- const url = window.URL.createObjectURL(blob)
- const aLink = document.createElement('a')
- aLink.style.display = 'none'
- aLink.href = url
- const docname = '盘点单导入模板.xlsx'
- aLink.setAttribute('download', docname) // 下载的文件
- document.body.appendChild(aLink)
- aLink.click()
- document.body.removeChild(aLink)
- window.URL.revokeObjectURL(url)
- })
- },
- 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: '已取消删除' })
- })
- },
- 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')
- })
- }
- }
- }
- }
- </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>
|