5bf0ca2a9f9e57daf0e654f4b183abf06a1573aa.svn-base 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605
  1. <template>
  2. <div class="app-container">
  3. <div class="operation">
  4. <el-button class="success" @click="handleCreate">新增</el-button>
  5. <el-upload style="float: right;" :headers="headers" :data="uploadData" :action="uploadExcelUrl" :show-file-list="false" :before-upload="beforeImport" :on-success="handleImportSuccess">
  6. <el-button class="import" style="float: right;">导入</el-button>
  7. </el-upload>
  8. <el-dropdown style="float: right;margin-right: 10px;">
  9. <el-button class="export">导出</el-button>
  10. <el-dropdown-menu slot="dropdown">
  11. <el-dropdown-item @click.native="handleExport(1)">导出模板</el-dropdown-item>
  12. <el-dropdown-item @click.native="handleExport(2)">导出数据</el-dropdown-item>
  13. </el-dropdown-menu>
  14. </el-dropdown>
  15. </div>
  16. <div class="search">
  17. <el-date-picker v-model="table.getdataListParm.parammaps.inputDatetime" class="inputDatetime filter-item" type="daterange" range-separator="至" start-placeholder="开始日期" end-placeholder="结束日期" style="width: 250px;" />
  18. <el-button class="el-icon-arrow-left elIconArrowLeft" @click="handleBefore" />
  19. <el-button class="el-icon-arrow-right elIconArrowRight" @click="handleNext" />
  20. <el-select v-model="table.getdataListParm.parammaps.usetype" placeholder="操作类型" class="filter-item" style="width: 120px;" clearable>
  21. <el-option v-for="item in operationTypeList" :key="item.id" :label="item.label" :value="item.value" />
  22. </el-select>
  23. <el-autocomplete v-model="table.getdataListParm.parammaps.feedname" value-key="feedname" class="inline-input filter-item" :fetch-suggestions="tableFeedNameSearch" placeholder="饲料名称" style="width:250px" @select="handleSelectTableFeedName">
  24. <template slot-scope="{ item }">
  25. <span>{{ item.feedname }}</span>
  26. </template>
  27. </el-autocomplete>
  28. <el-select v-model="table.getdataListParm.parammaps.cowclassid" filterable placeholder="请选择牲畜类别" class="filter-item" style="width: 150px;" clearable>
  29. <el-option v-for="item in livestockList" :key="item.id" :label="item.mixname" :value="item.id" />
  30. </el-select>
  31. <el-button class="successBorder" @click="handleSearch">查询</el-button>
  32. <el-button class="successBorder" @click="handleRefresh">重置</el-button>
  33. </div>
  34. <div class="table">
  35. <el-table
  36. :key="table.tableKey"
  37. v-loading="table.listLoading"
  38. element-loading-text="给我一点时间"
  39. :data="table.list"
  40. border
  41. fit
  42. highlight-current-row
  43. style="width: 100%;"
  44. :row-style="rowStyle"
  45. :cell-style="cellStyle"
  46. class="elTable table-fixed"
  47. >
  48. <el-table-column label="序号" align="center" type="index" width="50px">
  49. <template slot-scope="scope">
  50. <span>{{ scope.$index + (table.pageNum-1) * table.pageSize + 1 }}</span>
  51. </template>
  52. </el-table-column>
  53. <el-table-column label="出库日期" min-width="130px" align="center">
  54. <template slot-scope="scope">
  55. <span>{{ scope.row.usedate }}</span>
  56. </template>
  57. </el-table-column>
  58. <el-table-column label="牲畜类别" min-width="130px" align="center">
  59. <template slot-scope="scope">
  60. <span>{{ scope.row.cowclass }}</span>
  61. </template>
  62. </el-table-column>
  63. <el-table-column label="饲料名称" min-width="110px" align="center">
  64. <template slot-scope="scope">
  65. <span>{{ scope.row.feedname }}</span>
  66. </template>
  67. </el-table-column>
  68. <el-table-column label="操作重量(kg)" min-width="110px" align="center">
  69. <template slot-scope="scope">
  70. <span>{{ scope.row.operateweight }}</span>
  71. </template>
  72. </el-table-column>
  73. <el-table-column label="操作类型" min-width="110px" align="center">
  74. <template slot-scope="scope">
  75. <span>{{ scope.row.usetype }}</span>
  76. </template>
  77. </el-table-column>
  78. <el-table-column label="备注" min-width="110px" align="center">
  79. <template slot-scope="scope">
  80. <span>{{ scope.row.remark }}</span>
  81. </template>
  82. </el-table-column>
  83. <el-table-column label="操作人" min-width="110px" align="center">
  84. <template slot-scope="scope">
  85. <span>{{ scope.row.createemp }}</span>
  86. </template>
  87. </el-table-column>
  88. <el-table-column label="操作" align="center" width="120" class-name="small-padding fixed-width" fixed="right">
  89. <template slot-scope="{row}">
  90. <el-button class="miniPrimary" @click="handleSee(row)">查看</el-button>
  91. </template>
  92. </el-table-column>
  93. </el-table>
  94. <pagination v-show="table.total>=0" :total="table.total" :page.sync="table.getdataListParm.offset" :limit.sync="table.getdataListParm.pagecount" @pagination="getList" />
  95. </div>
  96. <!-- 新增/编辑 -->
  97. <el-dialog :title="textMap[create.dialogStatus]" :visible.sync="create.dialogFormVisible" :close-on-click-modal="false" width="80%">
  98. <div class="app-add">
  99. <el-form ref="createTemp" :rules="create.rules" :model="create.createTemp" label-position="right" label-width="150px" style="width: 90%;height:300px;margin:0 auto 50px">
  100. <el-row>
  101. <el-col :span="12">
  102. <el-form-item label="操作类型:" prop="usetype">
  103. <el-select v-model="create.createTemp.usetype" placeholder="操作类型" class="filter-item" style="width: 100%;" :disabled="create.dialogStatus==='see'" @change="changeUsetype">
  104. <el-option v-for="item in operationTypeList" :key="item.id" :label="item.label" :value="item.value" />
  105. </el-select>
  106. </el-form-item>
  107. </el-col>
  108. <el-col :span="12">
  109. <el-form-item label="出库日期:" prop="usedate">
  110. <el-date-picker v-model="create.createTemp.usedate" :picker-options="create.pickerOptions1" :clearable="false" class="filter-item" format="yyyy-MM-dd" value-format="yyyy-MM-dd" style="width: 100%;" type="datetime" placeholder="出库日期" :disabled="create.dialogStatus==='see'" />
  111. </el-form-item>
  112. </el-col>
  113. </el-row>
  114. <el-row>
  115. <el-col :span="12">
  116. <el-form-item label="饲料名称:" prop="feedname">
  117. <el-autocomplete v-model="create.createTemp.feedname" :disabled="create.dialogStatus==='see'" value-key="feedname" class="inline-input" :fetch-suggestions="feedNameSearch" placeholder="请选择饲料名称" style="width:100%" @select="handleSelectFeedName" @blur="blurFeedName">
  118. <template slot-scope="{ item }">
  119. <span>{{ item.feedname }}</span>
  120. </template>
  121. </el-autocomplete>
  122. </el-form-item>
  123. </el-form-item>
  124. </el-col>
  125. <el-col :span="12">
  126. <el-form-item label="牲畜类别:" prop="cowclassid">
  127. <el-select v-model="create.createTemp.cowclassid" filterable placeholder="请选择牲畜类别" class="filter-item" style="width: 100%;" :disabled="create.dialogStatus==='see' || create.createTemp.usetype=='损耗'" @change="changeLivestock">
  128. <el-option v-for="item in livestockList" :key="item.id" :label="item.mixname" :value="item.id" />
  129. </el-select>
  130. </el-form-item>
  131. </el-col>
  132. </el-row>
  133. <el-row>
  134. <el-col :span="12">
  135. <el-form-item label="库存重量(kg):" prop="repertoryweight">
  136. <el-input ref="repertoryweight" v-model="create.createTemp.repertoryweight" class="filter-item" placeholder="最多两位小数" type="text" disabled />
  137. </el-form-item>
  138. </el-col>
  139. <el-col :span="12">
  140. <el-form-item label="操作重量(kg):" prop="operateweight">
  141. <el-input ref="operateweight" v-model="create.createTemp.operateweight" class="filter-item" placeholder="最多两位小数" type="text" :disabled="create.dialogStatus==='see'" />
  142. </el-form-item>
  143. </el-col>
  144. </el-row>
  145. <el-row>
  146. <el-col :span="12">
  147. <el-form-item label="备注:" prop="remark">
  148. <el-input ref="remark" v-model="create.createTemp.remark" class="filter-item" placeholder="1-255字符" type="text" :disabled="create.dialogStatus==='see'" />
  149. </el-form-item>
  150. </el-col>
  151. </el-row>
  152. </el-form>
  153. <div slot="footer" class="dialog-footer">
  154. <el-button class="cancelClose" @click="create.dialogFormVisible = false; ">关闭</el-button>
  155. <el-button v-if="create.dialogStatus==='create'" class="success" :disabled="isokDisable" @click="createData()">确认</el-button>
  156. </div>
  157. </div>
  158. </el-dialog>
  159. </div>
  160. </template>
  161. <script>
  162. import { GetDataByName, GetDataByNames, checkButtons, ExecDataByConfig, failproccess } from '@/api/common'
  163. import Pagination from '@/components/Pagination'
  164. import Cookies from 'js-cookie'
  165. import { parseTime, json2excel } from '@/utils/index.js'
  166. import { getToken } from '@/utils/auth'
  167. export default {
  168. name: 'LaborConsumption',
  169. components: { Pagination },
  170. data() {
  171. return {
  172. isRoleEdit: [],
  173. requestParams: [
  174. { name: 'getDictByName', offset: 0, pagecount: 0, params: ['人工用量操作类型'] },
  175. { name: 'getCowclassListEnable', offset: 0, pagecount: 0, parammaps: { 'pastureid': Cookies.get('pastureid') }}
  176. ],
  177. operationTypeList: [], // 操作类型
  178. feedNameList: [], // 饲料名称
  179. livestockList: [], // 牲畜类别
  180. table: {
  181. getdataListParm: {
  182. name: 'getFeeduseList',
  183. page: 1,
  184. offset: 1,
  185. pagecount: 10,
  186. returntype: 'Map',
  187. parammaps: {
  188. inputDatetime: '',
  189. pastureid: Cookies.get('pastureid'),
  190. startTime: '',
  191. stopTime: '',
  192. usetype: '',
  193. feedid: '',
  194. cowclassid: ''
  195. }
  196. },
  197. tableKey: 0,
  198. list: [],
  199. total: 0,
  200. listLoading: true
  201. },
  202. create: {
  203. pickerOptions1: {
  204. disabledDate(time) {
  205. return time.getTime() > Date.now()// 当天之前的时间可选
  206. }
  207. },
  208. dialogFormVisible: false,
  209. dialogStatus: '',
  210. createTemp: {
  211. pastureid: Cookies.get('pastureid'), usedate: parseTime(new Date(), '{y}-{m}-{d}'), feedid: '', feedname: '', cowclassid: '', cowclass: '', usetype: '', operateweight: '', repertoryweight: '', createemp: '', remark: '', price: ''
  212. },
  213. getfeedNameParm: {
  214. name: 'getFeedstorageuse',
  215. offset: 0,
  216. pagecount: '',
  217. parammaps: { pastureid: Cookies.get('pastureid') }
  218. },
  219. rules: {
  220. usetype: [{ type: 'string', required: true, message: '必填', trigger: 'blur' }],
  221. usedate: [{ type: 'string', required: true, message: '必填', trigger: 'blur' }],
  222. feedname: [{ type: 'string', required: true, message: '必填', trigger: 'change' }],
  223. operateweight: [{ type: 'string', required: true, message: '必填', trigger: 'blur' }]
  224. }
  225. },
  226. textMap: {
  227. create: '新增',
  228. see: '查看'
  229. },
  230. requestParam: {},
  231. download: {
  232. getdataListParm: {
  233. name: 'getFeeduseList',
  234. page: 1,
  235. offset: 1,
  236. pagecount: 0,
  237. returntype: 'Map',
  238. parammaps: {
  239. inputDatetime: '',
  240. pastureid: Cookies.get('pastureid'),
  241. startTime: '',
  242. stopTime: '',
  243. usetype: '',
  244. feedid: '',
  245. cowclassid: ''
  246. }
  247. },
  248. list: []
  249. },
  250. isokDisable: false,
  251. rowStyle: { maxHeight: 50 + 'px', height: 45 + 'px' },
  252. cellStyle: { padding: 0 + 'px' }
  253. }
  254. },
  255. computed: {
  256. // 设置请求头
  257. headers() {
  258. return {
  259. token: getToken()
  260. }
  261. },
  262. uploadData() {
  263. return {
  264. name: '颛孙洋洋-出库',
  265. importParams: '出库日期,操作类型,牲畜类别,饲料名称,操作重量(kg),备注,操作人',
  266. sheetname: 'SheetJS'
  267. }
  268. },
  269. // 设置上传地址
  270. uploadExcelUrl() {
  271. return process.env.VUE_APP_BASE_API + 'authdata/ImportExcel'
  272. }
  273. },
  274. created() {
  275. this.getList()
  276. this.getDownList()
  277. this.getButtons()
  278. },
  279. methods: {
  280. getButtons() {
  281. const Edit = 'SystemConsumption'
  282. const isRoleEdit = checkButtons(JSON.parse(sessionStorage.getItem('buttons')), Edit)
  283. this.isRoleEdit = isRoleEdit
  284. },
  285. getDownList() {
  286. GetDataByNames(this.requestParams).then(response => {
  287. this.operationTypeList = response.data.getDictByName.list
  288. this.livestockList = response.data.getCowclassListEnable.list
  289. })
  290. },
  291. handleBefore() {
  292. if (this.table.getdataListParm.parammaps.inputDatetime !== '' && this.table.getdataListParm.parammaps.inputDatetime !== null) {
  293. var start = new Date(this.table.getdataListParm.parammaps.inputDatetime[0].setDate(this.table.getdataListParm.parammaps.inputDatetime[0].getDate() - 1))
  294. var stop = new Date(this.table.getdataListParm.parammaps.inputDatetime[1].setDate(this.table.getdataListParm.parammaps.inputDatetime[1].getDate() - 1))
  295. this.table.getdataListParm.parammaps.inputDatetime.length = 0
  296. this.table.getdataListParm.parammaps.inputDatetime.push(start, stop)
  297. this.table.getdataListParm.parammaps.startTime = parseTime(start, '{y}-{m}-{d}')
  298. this.table.getdataListParm.parammaps.stopTime = parseTime(stop, '{y}-{m}-{d}')
  299. this.$forceUpdate()
  300. }
  301. },
  302. handleNext() {
  303. if (this.table.getdataListParm.parammaps.inputDatetime !== '' && this.table.getdataListParm.parammaps.inputDatetime !== null) {
  304. var start = new Date(this.table.getdataListParm.parammaps.inputDatetime[0].setDate(this.table.getdataListParm.parammaps.inputDatetime[0].getDate() + 1))
  305. var stop = new Date(this.table.getdataListParm.parammaps.inputDatetime[1].setDate(this.table.getdataListParm.parammaps.inputDatetime[1].getDate() + 1))
  306. this.table.getdataListParm.parammaps.inputDatetime.length = 0
  307. this.table.getdataListParm.parammaps.inputDatetime.push(start, stop)
  308. this.table.getdataListParm.parammaps.startTime = parseTime(start, '{y}-{m}-{d}')
  309. this.table.getdataListParm.parammaps.stopTime = parseTime(stop, '{y}-{m}-{d}')
  310. this.$forceUpdate()
  311. }
  312. },
  313. getList() {
  314. this.table.listLoading = true
  315. GetDataByName(this.table.getdataListParm).then(response => {
  316. console.log('table数据', response.data.list)
  317. if (response.data.list !== null) {
  318. this.table.list = response.data.list
  319. this.table.pageNum = response.data.pageNum
  320. this.table.pageSize = response.data.pageSize
  321. this.table.total = response.data.total
  322. } else {
  323. this.table.list = []
  324. }
  325. setTimeout(() => {
  326. this.table.listLoading = false
  327. }, 100)
  328. })
  329. },
  330. handleSearch() {
  331. console.log('点击了查询')
  332. if (this.table.getdataListParm.parammaps.inputDatetime !== '' && this.table.getdataListParm.parammaps.inputDatetime !== null) {
  333. this.table.getdataListParm.parammaps.startTime = parseTime(this.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  334. this.table.getdataListParm.parammaps.stopTime = parseTime(this.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  335. } else {
  336. this.table.getdataListParm.parammaps.inputDatetime = ''
  337. this.table.getdataListParm.parammaps.startTime = ''
  338. this.table.getdataListParm.parammaps.stopTime = ''
  339. }
  340. this.table.getdataListParm.offset = 1
  341. this.getList()
  342. },
  343. handleRefresh() {
  344. console.log('点击了重置')
  345. this.table.getdataListParm.parammaps.inputDatetime = ''
  346. this.table.getdataListParm.parammaps.startTime = ''
  347. this.table.getdataListParm.parammaps.stopTime = ''
  348. this.table.getdataListParm.parammaps.feedid = ''
  349. this.table.getdataListParm.parammaps.cowclassid = ''
  350. this.table.getdataListParm.parammaps.ischarge = ''
  351. this.table.getdataListParm.parammaps.usetype = ''
  352. this.table.getdataListParm.parammaps.feedname = ''
  353. this.table.getdataListParm.parammaps.cowclassid = ''
  354. },
  355. resetCreateTemp() {
  356. this.create.createTemp = {
  357. pastureid: Cookies.get('pastureid'), usedate: parseTime(new Date(), '{y}-{m}-{d}'), feedid: '', feedname: '', cowclassid: '', cowclass: '', usetype: '', operateweight: '', repertoryweight: '', createemp: Cookies.get('employename'), remark: '', price: ''
  358. }
  359. },
  360. // 操作类型
  361. changeUsetype(item) {
  362. console.log(item)
  363. if (item == '损耗') {
  364. console.log(item)
  365. this.create.createTemp.cowclassid = ''
  366. this.create.createTemp.cowclass = ''
  367. }
  368. },
  369. tableFeedNameSearch(queryString, cb) {
  370. this.create.getfeedNameParm.parammaps['feedname'] = queryString
  371. GetDataByName(this.create.getfeedNameParm).then(response => {
  372. console.log('模糊查询搜索data', response.data.list)
  373. if (response.data.list == null) {
  374. cb([])
  375. } else {
  376. cb(response.data.list)
  377. }
  378. })
  379. },
  380. handleSelectTableFeedName(item) {
  381. this.table.getdataListParm.parammaps.feedid = item.feedid
  382. },
  383. // 饲料名称
  384. feedNameSearch(queryString, cb) {
  385. this.create.getfeedNameParm.parammaps['feedname'] = queryString
  386. GetDataByName(this.create.getfeedNameParm).then(response => {
  387. console.log('模糊查询搜索data', response.data.list)
  388. if (response.data.list == null) {
  389. cb([])
  390. } else {
  391. cb(response.data.list)
  392. }
  393. })
  394. },
  395. handleSelectFeedName(item) {
  396. console.log(item)
  397. this.create.createTemp.feedname = item.feedname
  398. this.create.createTemp.feedid = item.feedid
  399. this.create.createTemp.price = item.price
  400. this.create.createTemp.pcpde = item.pcpde
  401. this.create.createTemp.repertoryweight = item.stockweight
  402. },
  403. blurFeedName() {
  404. this.create.createTemp.feedname = ''
  405. this.create.createTemp.feedid = ''
  406. this.create.createTemp.price = ''
  407. this.create.createTemp.pcpde = ''
  408. this.create.createTemp.repertoryweight = ''
  409. },
  410. // 牲畜类别
  411. changeLivestock(item) {
  412. this.create.createTemp.cowclass = this.livestockList.find(obj => obj.id == item).classname
  413. },
  414. handleCreate() {
  415. console.log('点击了新增')
  416. this.resetCreateTemp()
  417. this.create.dialogStatus = 'create'
  418. this.create.dialogFormVisible = true
  419. this.$nextTick(() => {
  420. this.$refs.createTemp.resetFields()
  421. })
  422. },
  423. createData() {
  424. console.log('点击了新增保存')
  425. this.$refs['createTemp'].validate(valid => {
  426. if (valid) {
  427. this.isokDisable = true
  428. setTimeout(() => {
  429. this.isokDisable = false
  430. }, 1000)
  431. if (this.create.createTemp.usetype == '人工用料') {
  432. if (this.create.createTemp.cowclassid == '') {
  433. this.$message({ type: 'error', message: '请选择牲畜类别', duration: 2000 })
  434. return false
  435. }
  436. }
  437. const keepTwoNum = /^\d+(\.\d{1,2})?$/
  438. // 操作重量
  439. if (this.create.createTemp.operateweight == 0) {
  440. this.$message({ type: 'error', message: '操作重量请输入自然数并保留两位小数', duration: 2000 })
  441. return false
  442. } else {
  443. if (!keepTwoNum.test(parseFloat(this.create.createTemp.operateweight))) {
  444. this.$message({ type: 'error', message: '操作重量请输入自然数并保留两位小数', duration: 2000 })
  445. return false
  446. }
  447. }
  448. this.requestParam.common = { 'returnmap': '0' }
  449. this.requestParam.data = []
  450. this.requestParam.data[0] = { 'name': 'insertFeeduse', 'type': 'e', 'parammaps': {
  451. 'pastureid': this.create.createTemp.pastureid,
  452. 'usedate': this.create.createTemp.usedate,
  453. 'feedid': this.create.createTemp.feedid,
  454. 'feedname': this.create.createTemp.feedname,
  455. 'cowclassid': this.create.createTemp.cowclassid,
  456. 'cowclass': this.create.createTemp.cowclass,
  457. 'usetype': this.create.createTemp.usetype,
  458. 'operateweight': this.create.createTemp.operateweight,
  459. 'repertoryweight': this.create.createTemp.repertoryweight,
  460. 'createemp': this.create.createTemp.createemp,
  461. 'remark': this.create.createTemp.remark,
  462. 'price': this.create.createTemp.price
  463. }}
  464. this.requestParam.data[1] = { 'name': 'insertFeedstorageUse', 'type': 'e', 'parammaps': {
  465. 'pastureid': this.create.createTemp.pastureid,
  466. 'feedid': this.create.createTemp.feedid,
  467. 'operateweight': this.create.createTemp.operateweight,
  468. 'fname': this.create.createTemp.feedname,
  469. 'pcpde': this.create.createTemp.pcpde,
  470. 'price': this.create.createTemp.price
  471. }}
  472. ExecDataByConfig(this.requestParam).then(response => {
  473. if (response.msg === 'fail') {
  474. failproccess(response, this.$notify)
  475. } else {
  476. this.$notify({ title: '', message: '成功', type: 'success', duration: 2000 })
  477. this.create.dialogFormVisible = false
  478. this.getList()
  479. }
  480. })
  481. }
  482. })
  483. },
  484. handleSee(row) {
  485. console.log('点击了查看')
  486. this.create.dialogStatus = 'see'
  487. this.create.dialogFormVisible = true
  488. this.create.createTemp = Object.assign({}, row)
  489. this.$nextTick(() => {
  490. this.$refs.createTemp.resetFields()
  491. })
  492. },
  493. handleRowDelete(row) {
  494. console.log('点击了行内删除')
  495. },
  496. // 导出
  497. handleExport(item) {
  498. if (item == 1) {
  499. console.log('点击了导出模板')
  500. var excelDatas = [
  501. {
  502. tHeader: ['出库日期', '操作类型', '牲畜类别', '饲料名称', '操作重量(kg)', '备注', '操作人'],
  503. filterVal: ['出库日期', '操作类型', '牲畜类别', '饲料名称', '操作重量(kg)', '备注', '操作人'],
  504. tableDatas: this.download.list,
  505. sheetName: 'Sheet1'
  506. }
  507. ]
  508. json2excel(excelDatas, '人工用量模板', true, 'xlsx')
  509. } else {
  510. console.log('点击了导出数据')
  511. this.download.getdataListParm.parammaps = this.table.getdataListParm.parammaps
  512. if (this.download.getdataListParm.parammaps.inputDatetime !== '' && this.download.getdataListParm.parammaps.inputDatetime !== null) {
  513. this.download.getdataListParm.parammaps.startTime = parseTime(this.download.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  514. this.download.getdataListParm.parammaps.stopTime = parseTime(this.download.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  515. } else {
  516. this.download.getdataListParm.parammaps.inputDatetime = ''
  517. this.download.getdataListParm.parammaps.startTime = ''
  518. this.download.getdataListParm.parammaps.stopTime = ''
  519. }
  520. GetDataByName(this.download.getdataListParm).then(response => {
  521. if (response.data.list !== null) {
  522. this.download.list = response.data.list
  523. } else {
  524. this.download.list = []
  525. }
  526. var excelDatas = [
  527. {
  528. tHeader: ['出库日期', '操作类型', '牲畜类别', '饲料名称', '操作重量(kg)', '备注', '操作人'],
  529. filterVal: ['usedate', 'usetype', 'cowclass', 'feedname', 'operateweight', 'remark', 'createemp'],
  530. tableDatas: this.download.list,
  531. sheetName: 'Sheet1'
  532. }
  533. ]
  534. json2excel(excelDatas, '人工用量', true, 'xlsx')
  535. })
  536. }
  537. },
  538. beforeImport(file) {
  539. const isLt2M = file.size / 1024 / 1024 < 2
  540. if (!isLt2M) {
  541. this.$message.error('上传文件大小不能超过 2MB!')
  542. }
  543. return isLt2M
  544. },
  545. handleImportSuccess(res, file) {
  546. this.getList()
  547. if (res.msg === 'ok') {
  548. this.$message({ title: '成功', message: '导入成功:' + res.data.success + '条!', type: 'success', duration: 2000 })
  549. if (res.data.err_count > 0) {
  550. this.$notify({ title: '失败', message: '导入失败:' + res.data.err_count + '条!', type: 'danger', duration: 2000 })
  551. import('@/vendor/Export2Excel').then(excel => {
  552. const list1 = res.data.result
  553. const tHeader = [
  554. '出库日期', '操作类型', '牲畜类别', '饲料名称', '操作重量(kg)', '备注', '操作人', '错误信息'
  555. ]
  556. const filterVal = [
  557. '出库日期', '操作类型', '牲畜类别', '饲料名称', '操作重量(kg)', '备注', '操作人', 'error_msg'
  558. ]
  559. const data1 = this.formatJson(filterVal, list1)
  560. excel.export_json_to_excel({ header: tHeader, data: data1, filename: '人工用量导入报错信息', autoWidth: true, bookType: 'xlsx' })
  561. })
  562. }
  563. } else {
  564. this.$notify({ title: '失败', message: '上传失败', type: 'danger', duration: 2000 })
  565. }
  566. },
  567. formatJson(filterVal, jsonData) {
  568. return jsonData.map(v =>
  569. filterVal.map(j => {
  570. if (j === 'timestamp') {
  571. return parseTime(v[j])
  572. } else {
  573. return v[j]
  574. }
  575. })
  576. )
  577. }
  578. }
  579. }
  580. </script>
  581. <style lang="scss" scoped>
  582. .search{margin-top:10px;}
  583. .table{margin-top:10px;}
  584. </style>
  585. <style lang="scss">
  586. .typeSelect span .el-popover__reference .el-input--suffix {
  587. .el-input__inner{
  588. height:40px !important;
  589. }
  590. }
  591. </style>