index.vue 57 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051
  1. <template>
  2. <div class="app-container">
  3. <el-tabs v-model="activeName" @tab-click="handleTabClick">
  4. <el-tab-pane label="库存统计" name="first">
  5. <div class="search">
  6. <el-date-picker v-model="tab.table.getdataListParm.parammaps.inputDatetime" :clearable="false" class="inputDatetime filter-item" type="daterange" range-separator="至" start-placeholder="开始日期" end-placeholder="结束日期" style="float: left;width: 250px;margin-bottom:10px;" :picker-options="pickerOptions" />
  7. <el-button class="el-icon-arrow-left elIconArrowLeft" :disabled="Beforedisabled" style="float: left;" @click="handleBefore" />
  8. <el-button class="el-icon-arrow-right elIconArrowRight" :disabled="Nextdisabled" style="float: left;" @click="handleNext" />
  9. <el-input v-model="tab.table.getdataListParm.parammaps.feedname" class="filter-item" style="float: left;width: 245px;margin-bottom:10px;" placeholder="饲料名称" />
  10. <el-button class="successBorder" style="float: left;margin-left: 10px;margin-bottom:10px;" @click="form_search('first')">查询</el-button>
  11. <el-button class="export" style="float: right;margin-right: 10px;margin-bottom:10px;" icon="el-icon-upload2" @click="handleExport('tab1')">导出</el-button>
  12. </div>
  13. <div class="table">
  14. <el-table
  15. :key="tab.table.tableKey"
  16. v-loading="tab.table.listLoading"
  17. element-loading-text="给我一点时间"
  18. :data="tab.table.list"
  19. border
  20. fit
  21. highlight-current-row
  22. style="width: 100%;"
  23. :row-style="rowStyle"
  24. :cell-style="cellStyle"
  25. class="elTable table-fixed"
  26. >
  27. <el-table-column sortable label="饲料名称" min-width="130px" align="center">
  28. <template slot-scope="scope">
  29. <span>{{ scope.row.feedname }}</span>
  30. </template>
  31. </el-table-column>
  32. <el-table-column label="期初" min-width="130px" align="center">
  33. <el-table-column sortable prop="startsum" align="center" label="期初库存(kg)" min-width="120" />
  34. <el-table-column sortable prop="startprice" align="center" label="期初金额(元)" min-width="120" />
  35. </el-table-column>
  36. <el-table-column label="用量" min-width="110px" align="center">
  37. <el-table-column sortable prop="laidsum" align="center" label="入库重量(kg)" min-width="120" />
  38. <el-table-column sortable prop="usesumXT" align="center" label="系统出库重量(kg)" min-width="120" />
  39. <el-table-column sortable prop="usesumRG" align="center" label="人工用料重量(kg)" min-width="120" />
  40. <el-table-column sortable prop="usesumXH" align="center" label="损耗重量(kg)" min-width="120" />
  41. </el-table-column>
  42. <el-table-column label="期末" min-width="130px" align="center">
  43. <el-table-column sortable prop="stopsum" align="center" label="期末库存(kg)" min-width="120" />
  44. <el-table-column sortable prop="stopprice" align="center" label="期末金额(元)" min-width="120" />
  45. </el-table-column>
  46. </el-table>
  47. <pagination v-show="tab.table.total>=0" :total="tab.table.total" :page.sync="tab.table.getdataListParm.offset" :limit.sync="tab.table.getdataListParm.pagecount" @pagination="getTabList" />
  48. </div>
  49. </el-tab-pane>
  50. <el-tab-pane label="用料分析" name="second">
  51. <div class="search">
  52. <el-date-picker v-model="tab2.table.getdataListParm.parammaps.inputDatetime" :clearable="false" class="inputDatetime filter-item" type="daterange" range-separator="至" start-placeholder="开始日期" end-placeholder="结束日期" style="width: 245px;" :picker-options="pickerOptions2" />
  53. <el-button class="el-icon-arrow-left elIconArrowLeft" :disabled="Beforedisabled2" @click="handleBefore2" />
  54. <el-button class="el-icon-arrow-right elIconArrowRight" :disabled="Nextdisabled2" @click="handleNext2" />
  55. <span style="margin-left: 10px;">统计类型:</span>
  56. <el-select v-model="tab2.radio" placeholder="统计类型" class="filter-item" style="width: 120px;" @change="changeRadio2">
  57. <el-option v-for="item in statisticalTypeList2" :key="item.id" :label="item.name" :value="item.id" />
  58. </el-select>
  59. <el-checkbox v-model="tab2.table.getdataListParm.checked" :true-label="1" :false-label="0" style="margin-right:10px;" @change="changeChecked">误差</el-checkbox>
  60. <el-select v-model="tab2.table.getdataListParm.parammaps.ftType" placeholder="是否拆分小料" class="filter-item" style="width: 130px;">
  61. <el-option v-for="item in isSplitsmallmaterialsList" :key="item.id" :label="item.name" :value="item.id" />
  62. </el-select>
  63. <el-input v-if="tab2.isRadio1" v-model="tab2.table.getdataListParm.parammaps.fname" class="filter-item filter-item1" style="width: 200px;" placeholder="牲畜类别" />
  64. <el-input v-if="tab2.isRadio2" v-model="tab2.table.getdataListParm.parammaps.fname" class="filter-item filter-item1" style="width: 200px;" placeholder="栏舍名称" />
  65. <el-input v-if="tab2.isRadio3" v-model="tab2.table.getdataListParm.parammaps.fname" class="filter-item filter-item1" style="width: 200px;" placeholder="日期" />
  66. <el-input v-if="tab2.isRadio4" v-model="tab2.table.getdataListParm.parammaps.fname" class="filter-item filter-item1" style="width: 200px;" placeholder="TMR设备编号" />
  67. <el-input v-if="tab2.isRadio5" v-model="tab2.table.getdataListParm.parammaps.fname" class="filter-item filter-item1" style="width: 200px;" placeholder="班次" />
  68. <el-input v-if="tab2.isRadio6" v-model="tab2.table.getdataListParm.parammaps.fname" class="filter-item filter-item1" style="width: 200px;" placeholder="车次" />
  69. <el-select v-model="tab2.table.getdataListParm.parammaps.typea" clearable placeholder="列表显示" class="filter-item" style="width: 120px;">
  70. <el-option v-for="item in displayList" :key="item.id" :label="item.name" :value="item.id" />
  71. </el-select>
  72. <el-select v-model="tab2.table.getdataListParm.parammaps.times" clearable filterable placeholder="班次" class="filter-item" style="width: 120px;">
  73. <el-option v-for="item in frequencyList" :key="item.id" :label="item.name" :value="item.id" />
  74. </el-select>
  75. <el-button class="successBorder" @click="form_search('second')">查询</el-button>
  76. <el-button class="export" style="float: right;margin-right: 5px;margin-top:10px;" icon="el-icon-upload2" @click="handleExport('tab2')">导出</el-button>
  77. </div>
  78. <div v-if="tab2.table.tableConfig.length > 8">
  79. <u-table v-if="isDispayTable2" ref="plTable2" v-loading="tab2.table.listLoading" :row-style="rowStyle" :cell-style="cellStyle" :max-height="myHeight2" use-virtual :row-height="rowHeight" border class="elTable table-fixed plTable2">
  80. <!-- 第一个表头 -->
  81. <u-table-column v-for="(header1, index1) in tab2.table.tableConfig" :key="'header1-' + index1" :label="header1.label" align="center" :fixed="index1==0" :show-overflow-tooltip="header1.showOverflow" >
  82. <!-- 第二个表头 -->
  83. <u-table-column v-for="(header2, index2) in header1.children" :key="'header2-' + index2" :label="header2.label" align="center" :fixed="index2==0" :show-overflow-tooltip="header2.showOverflow">
  84. <!-- 第三个表头 -->
  85. <u-table-column v-for="(header3, index3) in header2.children" :key="'header3-' + index3" :label="header3.label" :prop="header3.prop" align="center">
  86. </u-table-column>
  87. </u-table-column>
  88. </u-table-column>
  89. </u-table>
  90. <!-- <u-table v-if="isDispayTable2" ref="plTable2" v-loading="tab2.table.listLoading" :row-style="rowStyle" :cell-style="cellStyle" :max-height="myHeight2" use-virtual :row-height="rowHeight" border class="elTable table-fixed plTable2">
  91. <u-table-column v-for="(item,index) in tab2.table.tableConfig" :key="index" :label="item.label" :show-overflow-tooltip="item.showOverflow" :prop="item.prop" align="center" :fixed="index==0">
  92. <u-table-column v-for="(item1,key1) in item.children" v-if="item.children || item.children.length>0" :key="key1" :label="item1.label" :prop="item1.prop" align="center">
  93. <u-table-column v-for="(item2,key2) in item1.children" v-if="item1.children || item1.children.length>0" :key="key2" :label="item2.label" :prop="item2.prop" />
  94. </u-table-column>
  95. </u-table-column>
  96. </u-table> -->
  97. </div>
  98. <div v-else>
  99. <u-table v-if="isDispayTable2" ref="plTable2" v-loading="tab2.table.listLoading" :row-style="rowStyle" :cell-style="cellStyle" :max-height="myHeight2" use-virtual :row-height="rowHeight" border class="elTable table-fixed plTable2">
  100. <!-- 第一个表头 -->
  101. <u-table-column v-for="(header1, index1) in tab2.table.tableConfig" :key="'header1-' + index1" :label="header1.label" align="center" :fixed="index1==0" :show-overflow-tooltip="header1.showOverflow">
  102. <!-- 第二个表头 -->
  103. <u-table-column v-for="(header2, index2) in header1.children" :key="'header2-' + index2" :label="header2.label" align="center" :fixed="index2==0" :show-overflow-tooltip="header2.showOverflow">
  104. <!-- 第三个表头 -->
  105. <u-table-column v-for="(header3, index3) in header2.children" :key="'header3-' + index3" :label="header3.label" :prop="header3.prop" align="center">
  106. </u-table-column>
  107. </u-table-column>
  108. </u-table-column>
  109. </u-table>
  110. <!-- <u-table v-if="isDispayTable2" ref="plTable2" v-loading="tab2.table.listLoading" :row-style="rowStyle" :cell-style="cellStyle" :max-height="myHeight2" use-virtual :row-height="rowHeight" border class="elTable table-fixed plTable2">
  111. <u-table-column v-for="(item,index) in tab2.table.tableConfig" :key="index" :label="item.label" :show-overflow-tooltip="item.showOverflow" :prop="item.prop" align="center">
  112. <u-table-column v-for="(item1,key1) in item.children" v-if="item.children || item.children.length>0" :key="key1" :label="item1.label" :prop="item1.prop" align="center">
  113. <u-table-column v-for="(item2,key2) in item1.children" v-if="item1.children || item1.children.length>0" :key="key2" :label="item2.label" :prop="item2.prop" />
  114. </u-table-column>
  115. </u-table-column>
  116. </u-table> -->
  117. </div>
  118. <span v-if="tab2.table.listLoading == false && tab2.table.list.length>0" style="margin-right: 30px;margin-top: 10px;font-size: 14px;">共{{ tab2.table.total }}条</span>
  119. </el-tab-pane>
  120. <el-tab-pane label="价格分析" name="third">
  121. <div class="search">
  122. <el-date-picker v-model="tab3.table.getdataListParm.parammaps.inputDatetime" class="inputDatetime filter-item" type="daterange" range-separator="至" start-placeholder="开始日期" end-placeholder="结束日期" :clearable="false" style="width: 250px;" :picker-options="pickerOptions" />
  123. <el-button class="el-icon-arrow-left elIconArrowLeft" :disabled="Beforedisabled3" @click="handleBefore3" />
  124. <el-button class="el-icon-arrow-right elIconArrowRight" :disabled="Nextdisabled3" @click="handleNext3" />
  125. <span style="margin-left: 10px;">统计类型:</span>
  126. <el-select v-model="tab3.radio" placeholder="统计类型" class="filter-item" style="width: 120px;" @change="changeRadio3">
  127. <el-option v-for="item in statisticalTypeList3" :key="item.id" :label="item.name" :value="item.id" />
  128. </el-select>
  129. <!-- <el-radio v-model="tab3.radio" label="1" @change="changeRadio3">牲畜类别</el-radio>
  130. <el-radio v-model="tab3.radio" label="2" @change="changeRadio3">栏舍名称</el-radio>
  131. <el-radio v-model="tab3.radio" label="3" @change="changeRadio3">日期</el-radio>
  132. <el-radio v-model="tab3.radio" label="4" @change="changeRadio3">TMR设备编号</el-radio> -->
  133. <el-input v-if="tab3.isRadio1" v-model="tab3.table.getdataListParm.parammaps.fname" class="filter-item" style="width: 185px;" placeholder="牲畜类别" />
  134. <el-input v-if="tab3.isRadio2" v-model="tab3.table.getdataListParm.parammaps.fname" class="filter-item" style="width: 185px;" placeholder="栏舍名称" />
  135. <el-input v-if="tab3.isRadio3" v-model="tab3.table.getdataListParm.parammaps.fname" class="filter-item" style="width: 185px;" placeholder="日期" />
  136. <el-input v-if="tab3.isRadio4" v-model="tab3.table.getdataListParm.parammaps.fname" class="filter-item" style="width: 185px;" placeholder="TMR设备编号" />
  137. <el-button class="successBorder" @click="form_search('third')">查询</el-button>
  138. <el-button class="export filter-item1" style="float: right;margin-right: 5px;" icon="el-icon-upload2" @click="handleExport('tab3')">导出</el-button>
  139. </div>
  140. <div v-if="tab3.table.tableConfig.length>2">
  141. <u-table v-if="isDispayTable3" ref="plTable3" v-loading="tab3.table.listLoading" :row-style="rowStyle" :cell-style="cellStyle" :max-height="myHeight2" use-virtual :row-height="rowHeight" border class="elTable table-fixed plTable3">
  142. <u-table-column v-for="(item,key) in tab3.table.tableConfig" :key="key" :label="item.label" :show-overflow-tooltip="item.showOverflow" align="center" :prop="item.prop" :fixed="key==0">
  143. <u-table-column v-for="(item1,key1) in item.children" v-if="item.children || item.children.length>0" :key="key1" align="center" :label="item1.label" :prop="item1.prop" :min-width="item1.width">
  144. <u-table-column v-for="(item2,key2) in item1.children" v-if="item1.children || item1.children.length>0" :key="key2" :label="item2.label" :prop="item2.prop" />
  145. </u-table-column>
  146. </u-table-column>
  147. </u-table>
  148. </div>
  149. <div v-else>
  150. <u-table v-if="isDispayTable3" ref="plTable3" v-loading="tab3.table.listLoading" :row-style="rowStyle" :cell-style="cellStyle" :max-height="myHeight2" use-virtual :row-height="rowHeight" border class="elTable table-fixed plTable3">
  151. <u-table-column v-for="(item,key) in tab3.table.tableConfig" :key="key" :label="item.label" :show-overflow-tooltip="item.showOverflow" align="center" :prop="item.prop">
  152. <u-table-column v-for="(item1,key1) in item.children" v-if="item.children || item.children.length>0" :key="key1" align="center" :label="item1.label" :prop="item1.prop" :min-width="item1.width">
  153. <u-table-column v-for="(item2,key2) in item1.children" v-if="item1.children || item1.children.length>0" :key="key2" :label="item2.label" :prop="item2.prop" />
  154. </u-table-column>
  155. </u-table-column>
  156. </u-table>
  157. </div>
  158. <span v-if="tab3.table.listLoading == false && tab3.table.list.length>0" style="margin-right: 30px;margin-top: 10px;font-size: 14px;">共{{ tab3.table.total }}条</span>
  159. </el-tab-pane>
  160. </el-tabs>
  161. </div>
  162. </div>
  163. </template>
  164. <script>
  165. import { GetDataByName, GetReportform,postJson } from '@/api/common'
  166. import Cookies from 'js-cookie'
  167. import { parseTime } from '@/utils/index.js'
  168. import Pagination from '@/components/Pagination'
  169. import { json2excel, export_json_to_excel } from '@/utils/index.js'
  170. export default {
  171. name: 'PastureInventoryManagement',
  172. components: { Pagination },
  173. data() {
  174. return {
  175. Beforedisabled: false,
  176. Nextdisabled: false,
  177. Beforedisabled2: false,
  178. Nextdisabled2: false,
  179. Beforedisabled3: false,
  180. Nextdisabled3: false,
  181. pickerMinDate: '',
  182. pickerOptions: {
  183. onPick: ({ maxDate, minDate }) => {
  184. this.pickerMinDate = minDate.getTime()
  185. if (maxDate) {
  186. this.pickerMinDate = ''
  187. }
  188. },
  189. // 限制不能选择今天之后的日期
  190. disabledDate: (time) => {
  191. if (this.pickerMinDate !== '') {
  192. const one = 31 * 24 * 3600 * 1000
  193. const minTime = this.pickerMinDate - one
  194. let maxTime = this.pickerMinDate + one
  195. if (maxTime > new Date()) {
  196. maxTime = new Date()
  197. }
  198. return time.getTime() < minTime || time.getTime() > maxTime
  199. }
  200. return time.getTime() > Date.now()
  201. }
  202. },
  203. pickerOptions2: {
  204. onPick: ({ maxDate, minDate }) => {
  205. this.pickerMinDate = minDate.getTime()
  206. if (maxDate) {
  207. this.pickerMinDate = ''
  208. }
  209. },
  210. // 限制不能选择今天之后的日期
  211. disabledDate: (time) => {
  212. if (this.pickerMinDate !== '') {
  213. const one = 31 * 24 * 3600 * 1000
  214. const minTime = this.pickerMinDate - one
  215. let maxTime = this.pickerMinDate + one
  216. // if (maxTime > new Date()) {
  217. // maxTime = new Date()
  218. // }
  219. return time.getTime() < minTime || time.getTime() > maxTime
  220. }
  221. // return time.getTime() > Date.now()
  222. }
  223. },
  224. fileComment: [{ 'label': '商务文件评分', 'children': [{ 'label': '1' }, { 'label': '2' }, { 'label': '管理员' }] }],
  225. displayList:[{id:'1',name:'理论'},{id:'2',name:'实际'}],//列表显示
  226. isSplitsmallmaterialsList:[{id:'0',name:'拆分'},{id:'1',name:'不拆分'}],
  227. activeName: 'first',
  228. tab: {
  229. chartDate: [],
  230. table: {
  231. getdataListParm: {
  232. name: 'getfsStaticlist',
  233. page: 1,
  234. offset: 1,
  235. pagecount: parseInt(Cookies.get('pageCount')),
  236. returntype: 'Map',
  237. parammaps: {
  238. pastureid: Cookies.get('pastureid'),
  239. startTime: parseTime(new Date(), '{y}-{m}-{d}'),
  240. stopTime: parseTime(new Date(), '{y}-{m}-{d}'),
  241. inputDatetime: [new Date(), new Date()],
  242. feedname: ''
  243. }
  244. },
  245. tableKey: 1,
  246. list: [],
  247. total: 0,
  248. listLoading: false
  249. }
  250. },
  251. tab2: {
  252. chartDate: [],
  253. display:'',
  254. table: {
  255. getdataListParm: {
  256. name: 'getMaterialAnalysisSC',
  257. page: 1,
  258. offset: 1,
  259. pagecount: '',
  260. returntype: 'Map',
  261. checked: 0,
  262. parammaps: {
  263. pastureid: Cookies.get('pastureid'),
  264. startTime: parseTime(new Date(), '{y}-{m}-{d}'),
  265. stopTime: parseTime(new Date(), '{y}-{m}-{d}'),
  266. inputDatetime: [new Date(), new Date()],
  267. fname: '',
  268. typea:'',
  269. times:'',
  270. ftType:'1'
  271. }
  272. },
  273. tableKey: 1,
  274. list: [],
  275. tableConfig: [],
  276. data: [],
  277. total: 0,
  278. listLoading: false
  279. },
  280. radio: '1',
  281. isRadio1: true,
  282. isRadio2: false,
  283. isRadio3: false,
  284. isRadio4: false,
  285. isRadio5: false,
  286. isRadio6: false
  287. },
  288. tab3: {
  289. chartDate: [],
  290. table: {
  291. getdataListParm: {
  292. name: 'getPriceAnalysisSC',
  293. page: 1,
  294. offset: 1,
  295. pagecount: parseInt(Cookies.get('pageCount')),
  296. returntype: 'Map',
  297. parammaps: {
  298. pastureid: Cookies.get('pastureid'),
  299. startTime: parseTime(new Date(), '{y}-{m}-{d}'),
  300. stopTime: parseTime(new Date(), '{y}-{m}-{d}'),
  301. inputDatetime: [new Date(), new Date()],
  302. fname: ''
  303. }
  304. },
  305. tableKey: 1,
  306. list: [],
  307. tableConfig: [],
  308. total: 0,
  309. listLoading: false
  310. },
  311. radio: '1',
  312. isRadio1: true,
  313. isRadio2: false,
  314. isRadio3: false,
  315. isRadio4: false
  316. },
  317. downLoad: {},
  318. rowStyle: { maxHeight: 30 + 'px', height: 30 + 'px' },
  319. cellStyle: { padding: 0 + 'px' },
  320. myHeight2: document.documentElement.clientHeight - 95 - 150,
  321. rowHeight: 30,
  322. isDispayTable2:false,
  323. isDispayTable3:false,
  324. statisticalTypeList2: [{ id: '1', name: '牲畜类别' }, { id: '2', name: '栏舍名称' }, { id: '3', name: '日期' }, { id: '4', name: 'TMR设备编号' }, { id: '5', name: 'TMR班次' }, { id: '6', name: '车次' }],
  325. statisticalTypeList3: [{ id: '1', name: '牲畜类别' }, { id: '2', name: '栏舍名称' }, { id: '3', name: '日期' }, { id: '4', name: 'TMR设备编号' }],
  326. frequencyList: [], // 班次
  327. }
  328. },
  329. created() {
  330. this.getTimeFn()
  331. this.getIsDisplay()
  332. },
  333. methods: {
  334. getIsDisplay() {
  335. const url = 'authdata/GetDataByName'
  336. const data = {
  337. name: 'getSysoptEnable',
  338. page: 1,
  339. offset: 1,
  340. pagecount: 1,
  341. returntype: 'Map',
  342. parammaps: {
  343. pastureid: Cookies.get('pastureid'),
  344. inforname: 'times'
  345. }
  346. }
  347. postJson(url, data).then(response => {
  348. console.log(response.data.list[0].inforvalue)
  349. if (response.data.list[0].inforvalue == 1) {
  350. this.frequencyList = [{ id: 1, name: '第一班' }]
  351. } else if (response.data.list[0].inforvalue == 2) {
  352. this.frequencyList = [
  353. { id: 1, name: '第一班' }, { id: 2, name: '第二班' }
  354. ]
  355. } else if (response.data.list[0].inforvalue == 3) {
  356. this.frequencyList = [
  357. { id: 1, name: '第一班' }, { id: 2, name: '第二班' }, { id: 3, name: '第三班' }
  358. ]
  359. } else if (response.data.list[0].inforvalue == 4) {
  360. this.frequencyList = [
  361. { id: 1, name: '第一班' }, { id: 2, name: '第二班' }, { id: 3, name: '第三班' }, { id: 4, name: '第四班' }
  362. ]
  363. }else if (response.data.list[0].inforvalue == 5) {
  364. this.frequencyList = [
  365. { id: 1, name: '第一班' }, { id: 2, name: '第二班' }, { id: 3, name: '第三班' }, { id: 4, name: '第四班' }, { id: 5, name: '第五班' }
  366. ]
  367. }else if (response.data.list[0].inforvalue == 6) {
  368. this.frequencyList = [
  369. { id: 1, name: '第一班' }, { id: 2, name: '第二班' }, { id: 3, name: '第三班' }, { id: 4, name: '第四班' }, { id: 5, name: '第五班' }, { id: 6, name: '第六班' },
  370. ]
  371. }
  372. })
  373. },
  374. getTimeFn() {
  375. const that = this
  376. const start = new Date()
  377. const end = new Date()
  378. start.setTime(start.getTime() - 3600 * 1000 * 24 * 7)
  379. end.setTime(end.getTime() - 3600 * 1000 * 24 * 1)
  380. that.tab.table.getdataListParm.parammaps.startTime = parseTime(start, '{y}-{m}-{d}')
  381. that.tab.table.getdataListParm.parammaps.stopTime = parseTime(end, '{y}-{m}-{d}')
  382. that.tab.table.getdataListParm.parammaps.inputDatetime = [start, end]
  383. that.tab2.table.getdataListParm.parammaps.startTime = parseTime(end, '{y}-{m}-{d}')
  384. that.tab2.table.getdataListParm.parammaps.stopTime = parseTime(end, '{y}-{m}-{d}')
  385. that.tab2.table.getdataListParm.parammaps.inputDatetime = [end, end]
  386. that.tab3.table.getdataListParm.parammaps.startTime = parseTime(end, '{y}-{m}-{d}')
  387. that.tab3.table.getdataListParm.parammaps.stopTime = parseTime(end, '{y}-{m}-{d}')
  388. that.tab3.table.getdataListParm.parammaps.inputDatetime = [end, end]
  389. this.getTabList()
  390. },
  391. handleTabClick() {
  392. if (this.activeName == 'first') {
  393. const start = new Date()
  394. const end = new Date()
  395. start.setTime(start.getTime() - 3600 * 1000 * 24 * 7)
  396. end.setTime(end.getTime() - 3600 * 1000 * 24 * 1)
  397. this.tab.table.getdataListParm.parammaps.inputDatetime = [start, end]
  398. this.getTabList()
  399. } else if (this.activeName == 'second') {
  400. const start2 = new Date()
  401. const end2 = new Date()
  402. start2.setTime(start2.getTime() - 3600 * 1000 * 24 * 1)
  403. end2.setTime(end2.getTime() - 3600 * 1000 * 24 * 1)
  404. this.tab2.table.getdataListParm.parammaps.inputDatetime = [start2, end2]
  405. this.tab2.radio = '1'
  406. this.tab2.table.getdataListParm.parammaps.ftType = '1'
  407. this.tab2.table.getdataListParm.parammaps.startTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  408. this.tab2.table.getdataListParm.parammaps.stopTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  409. this.getTab2List()
  410. } else if (this.activeName == 'third') {
  411. const start3 = new Date()
  412. const end3 = new Date()
  413. start3.setTime(start3.getTime() - 3600 * 1000 * 24 * 1)
  414. end3.setTime(end3.getTime() - 3600 * 1000 * 24 * 1)
  415. this.tab3.table.getdataListParm.parammaps.inputDatetime = [start3, end3]
  416. this.tab3.radio = '1'
  417. this.tab3.table.getdataListParm.parammaps.startTime = parseTime(this.tab3.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  418. this.tab3.table.getdataListParm.parammaps.stopTime = parseTime(this.tab3.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  419. this.getTab3List()
  420. }
  421. },
  422. getTabList() {
  423. this.tab.table.listLoading = true
  424. GetDataByName(this.tab.table.getdataListParm).then(response => {
  425. if (response.data.list !== null) {
  426. console.log('库存统计table数据', response.data.list)
  427. this.tab.table.list = response.data.list
  428. this.tab.table.total = response.data.total
  429. } else {
  430. this.tab.table.list = []
  431. }
  432. setTimeout(() => {
  433. this.tab.table.listLoading = false
  434. }, 100)
  435. })
  436. },
  437. form_search(item) {
  438. if (item == 'first') {
  439. if (this.tab.table.getdataListParm.parammaps.inputDatetime !== '' && this.tab.table.getdataListParm.parammaps.inputDatetime !== null) {
  440. this.tab.table.getdataListParm.parammaps.startTime = parseTime(this.tab.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  441. this.tab.table.getdataListParm.parammaps.stopTime = parseTime(this.tab.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  442. } else {
  443. this.tab.table.getdataListParm.parammaps.inputDatetime = ''
  444. this.tab.table.getdataListParm.parammaps.startTime = ''
  445. this.tab.table.getdataListParm.parammaps.stopTime = ''
  446. }
  447. this.getTabList()
  448. } else if (item == 'second') {
  449. if (this.tab2.table.getdataListParm.parammaps.inputDatetime !== '' && this.tab2.table.getdataListParm.parammaps.inputDatetime !== null) {
  450. this.tab2.table.getdataListParm.parammaps.startTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  451. this.tab2.table.getdataListParm.parammaps.stopTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  452. } else {
  453. this.tab2.table.getdataListParm.parammaps.inputDatetime = ''
  454. this.tab2.table.getdataListParm.parammaps.startTime = ''
  455. this.tab2.table.getdataListParm.parammaps.stopTime = ''
  456. }
  457. this.getTab2List()
  458. } else if (item == 'third') {
  459. if (this.tab3.table.getdataListParm.parammaps.inputDatetime !== '' && this.tab3.table.getdataListParm.parammaps.inputDatetime !== null) {
  460. this.tab3.table.getdataListParm.parammaps.startTime = parseTime(this.tab3.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  461. this.tab3.table.getdataListParm.parammaps.stopTime = parseTime(this.tab3.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  462. } else {
  463. this.tab3.table.getdataListParm.parammaps.inputDatetime = ''
  464. this.tab3.table.getdataListParm.parammaps.startTime = ''
  465. this.tab3.table.getdataListParm.parammaps.stopTime = ''
  466. }
  467. this.getTab3List()
  468. }
  469. },
  470. // 用料分析
  471. getTab2List() {
  472. this.tab2.table.listLoading = true
  473. this.isDispayTable2 = false
  474. setTimeout(()=>{
  475. this.isDispayTable2 = true
  476. this.$nextTick(() => {
  477. let myList = []
  478. GetReportform(this.tab2.table.getdataListParm).then(response => {
  479. if (response.data !== null && response.data.data !== null && response.data.data1 !== null) {
  480. this.tab2.table.data = response.data.data
  481. response.data.feedcode.push('')
  482. response.data.feedcode.unshift('饲料编码')
  483. for (let i = 0; i < response.data.list.data2.length; i++) {
  484. console.log(response.data.list.data2[i],'===label')
  485. for (let j = 0; j < response.data.list.data1.length; j++) {
  486. for (let a = 0; a < response.data.list.data2[i].children.length; a++) {
  487. if (response.data.list.data1[j][response.data.list.data2[i].children[a].prop] == undefined || response.data.list.data1[j][response.data.list.data2[i].children[a].prop] == null || response.data.list.data1[j][response.data.list.data2[i].children[a].prop] == '') {
  488. response.data.list.data1[j][response.data.list.data2[i].children[a].prop] = 0
  489. }
  490. }
  491. }
  492. if (response.data.list.data2[i].children.length > 1) {
  493. for (let j = 0; j < response.data.list.data2[i].children.length; j++) {
  494. if (response.data.list.data2[i].children[j].label == '理论' || response.data.list.data2[i].children[j].label == '实际') {
  495. this.$set(response.data.list.data2[i].children[j], 'width', '80px')
  496. } else {
  497. this.$set(response.data.list.data2[i].children[j], 'width', '80px')
  498. }
  499. }
  500. } else {
  501. this.$set(response.data.list.data2[i].children[0], 'width', '80px')
  502. }
  503. }
  504. let list = response.data.list.data2
  505. let code = response.data.feedcode
  506. const headers = []
  507. for(let i=0;i<list.length;i++){
  508. for(let j=0;j<code.length;j++){
  509. if(i== j){
  510. let obj = {
  511. label:code[j],
  512. children:[
  513. list[i]
  514. ]
  515. }
  516. headers.push(obj)
  517. }
  518. }
  519. }
  520. myList = response.data.list.data1
  521. this.tab2.table.list = response.data.list.data1
  522. this.tab2.table.tableConfig = headers
  523. this.tab2.table.total = response.data.list.data1.length
  524. console.log('库存统计-用料分析this.tab2.table.data', response.data.data)
  525. console.log('库存统计-用料分析this.tab2.table.feedcode', response.data.feedcode)
  526. console.log('库存统计-用料分析this.tab2.table.list', response.data.list.data1)
  527. console.log('库存统计-用料分析this.tab2.table.tableConfig',response.data.list.data2)
  528. } else {
  529. myList = []
  530. this.tab2.table.list = []
  531. this.tab2.table.tableConfig = []
  532. }
  533. console.log(this.tab2.table.list.length)
  534. this.$refs.plTable2.reloadData(myList)
  535. setTimeout(() => {
  536. this.tab2.table.listLoading = false
  537. }, 100)
  538. })
  539. })
  540. })
  541. },
  542. changeRadio2() {
  543. console.log(this.tab2.radio)
  544. if (this.tab2.radio == '1') {
  545. this.tab2.isRadio1 = true,
  546. this.tab2.isRadio2 = false,
  547. this.tab2.isRadio3 = false,
  548. this.tab2.isRadio4 = false,
  549. this.tab2.isRadio5 = false,
  550. this.tab2.isRadio6 = false,
  551. this.tab2.table.getdataListParm.name = 'getMaterialAnalysisSC'
  552. this.tab2.table.getdataListParm.offset = 1
  553. this.tab2.table.getdataListParm.parammaps.startTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  554. this.tab2.table.getdataListParm.parammaps.stopTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  555. this.getTab2List()
  556. } else if (this.tab2.radio == '2') {
  557. this.tab2.isRadio1 = false,
  558. this.tab2.isRadio2 = true,
  559. this.tab2.isRadio3 = false,
  560. this.tab2.isRadio4 = false,
  561. this.tab2.isRadio5 = false,
  562. this.tab2.isRadio6 = false,
  563. this.tab2.table.getdataListParm.name = 'getMaterialAnalysisLS'
  564. this.tab2.table.getdataListParm.offset = 1
  565. this.tab2.table.getdataListParm.parammaps.startTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  566. this.tab2.table.getdataListParm.parammaps.stopTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  567. this.getTab2List()
  568. } else if (this.tab2.radio == '3') {
  569. this.tab2.isRadio1 = false,
  570. this.tab2.isRadio2 = false,
  571. this.tab2.isRadio3 = true,
  572. this.tab2.isRadio4 = false,
  573. this.tab2.isRadio5 = false,
  574. this.tab2.isRadio6 = false,
  575. this.tab2.table.getdataListParm.name = 'getMaterialAnalysisRQ'
  576. this.tab2.table.getdataListParm.offset = 1
  577. this.tab2.table.getdataListParm.parammaps.startTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  578. this.tab2.table.getdataListParm.parammaps.stopTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  579. this.getTab2List()
  580. } else if (this.tab2.radio == '4') {
  581. this.tab2.isRadio1 = false,
  582. this.tab2.isRadio2 = false,
  583. this.tab2.isRadio3 = false,
  584. this.tab2.isRadio4 = true,
  585. this.tab2.isRadio5 = false,
  586. this.tab2.isRadio6 = false,
  587. this.tab2.table.getdataListParm.name = 'getMaterialAnalysisTMR'
  588. this.tab2.table.getdataListParm.offset = 1
  589. this.tab2.table.getdataListParm.parammaps.startTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  590. this.tab2.table.getdataListParm.parammaps.stopTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  591. this.getTab2List()
  592. } else if (this.tab2.radio == '5') {
  593. this.tab2.isRadio1 = false,
  594. this.tab2.isRadio2 = false,
  595. this.tab2.isRadio3 = false,
  596. this.tab2.isRadio4 = false,
  597. this.tab2.isRadio5 = true,
  598. this.tab2.isRadio6 = false,
  599. this.tab2.table.getdataListParm.name = 'getMaterialAnalysisBC'
  600. this.tab2.table.getdataListParm.offset = 1
  601. this.tab2.table.getdataListParm.parammaps.startTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  602. this.tab2.table.getdataListParm.parammaps.stopTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  603. this.getTab2List()
  604. } else if (this.tab2.radio == '6') {
  605. this.tab2.isRadio1 = false,
  606. this.tab2.isRadio2 = false,
  607. this.tab2.isRadio3 = false,
  608. this.tab2.isRadio4 = false,
  609. this.tab2.isRadio5 = false,
  610. this.tab2.isRadio6 = true,
  611. this.tab2.table.getdataListParm.name = 'getMaterialAnalysisCC'
  612. this.tab2.table.getdataListParm.offset = 1
  613. this.tab2.table.getdataListParm.parammaps.startTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  614. this.tab2.table.getdataListParm.parammaps.stopTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  615. this.getTab2List()
  616. }
  617. },
  618. // 价格分析
  619. getTab3List() {
  620. this.tab3.table.listLoading = true
  621. this.isDispayTable3 = false
  622. setTimeout(()=>{
  623. this.isDispayTable3 = true
  624. this.$nextTick(() => {
  625. let myList = []
  626. GetReportform(this.tab3.table.getdataListParm).then(response => {
  627. if (response.data !== null && response.data.list.data1 !== null && response.data.list.data2 !== null) {
  628. console.log('库存统计-价格分析', response.data.list)
  629. for (let i = 0; i < response.data.list.data2.length; i++) {
  630. for (let j = 0; j < response.data.list.data1.length; j++) {
  631. for (let a = 0; a < response.data.list.data2[i].children.length; a++) {
  632. if (response.data.list.data1[j][response.data.list.data2[i].children[a].prop] == undefined || response.data.list.data1[j][response.data.list.data2[i].children[a].prop] == null || response.data.list.data1[j][response.data.list.data2[i].children[a].prop] == '') {
  633. response.data.list.data1[j][response.data.list.data2[i].children[a].prop] = 0
  634. }
  635. }
  636. }
  637. if (response.data.list.data2[i].children.length > 1) {
  638. for (let j = 0; j < response.data.list.data2[i].children.length; j++) {
  639. if (response.data.list.data2[i].children[j].label == '理论' || response.data.list.data2[i].children[j].label == '实际') {
  640. this.$set(response.data.list.data2[i].children[j], 'width', '80px')
  641. } else {
  642. this.$set(response.data.list.data2[i].children[j], 'width', '80px')
  643. }
  644. }
  645. } else {
  646. this.$set(response.data.list.data2[i].children[0], 'width', '80px')
  647. }
  648. }
  649. myList = response.data.list.data1
  650. this.tab3.table.list = response.data.list.data1
  651. this.tab3.table.tableConfig = response.data.list.data2
  652. this.tab3.table.total = response.data.list.data1.length
  653. } else {
  654. this.tab3.table.tableConfig = []
  655. this.tab3.table.list = []
  656. myList = []
  657. }
  658. setTimeout(() => {
  659. this.$refs.plTable3.reloadData(myList)
  660. this.tab3.table.listLoading = false
  661. }, 100)
  662. })
  663. })
  664. })
  665. },
  666. handleBefore() {
  667. if (this.tab.table.getdataListParm.parammaps.inputDatetime !== '' && this.tab.table.getdataListParm.parammaps.inputDatetime !== null) {
  668. var start = new Date(this.tab.table.getdataListParm.parammaps.inputDatetime[0].setDate(this.tab.table.getdataListParm.parammaps.inputDatetime[0].getDate() - 1))
  669. var stop = new Date(this.tab.table.getdataListParm.parammaps.inputDatetime[1].setDate(this.tab.table.getdataListParm.parammaps.inputDatetime[1].getDate() - 1))
  670. if (stop > Date.now() - 8.64e7) {
  671. this.Nextdisabled = true
  672. this.Beforedisabled = false
  673. } else {
  674. this.Nextdisabled = false
  675. this.Beforedisabled = false
  676. }
  677. this.tab.table.getdataListParm.parammaps.inputDatetime.length = 0
  678. this.tab.table.getdataListParm.parammaps.inputDatetime.push(start, stop)
  679. this.$forceUpdate()
  680. }
  681. this.tab.table.getdataListParm.parammaps.startTime = parseTime(this.tab.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  682. this.tab.table.getdataListParm.parammaps.stopTime = parseTime(this.tab.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  683. this.getTabList()
  684. },
  685. handleNext() {
  686. if (this.tab.table.getdataListParm.parammaps.inputDatetime !== '' && this.tab.table.getdataListParm.parammaps.inputDatetime !== null) {
  687. var start2 = new Date(this.tab.table.getdataListParm.parammaps.inputDatetime[0].setDate(this.tab.table.getdataListParm.parammaps.inputDatetime[0].getDate() + 1))
  688. var stop2 = new Date(this.tab.table.getdataListParm.parammaps.inputDatetime[1].setDate(this.tab.table.getdataListParm.parammaps.inputDatetime[1].getDate() + 1))
  689. if (stop2 > Date.now() - 8.64e7) {
  690. this.Nextdisabled = true
  691. this.Beforedisabled = false
  692. } else {
  693. this.Nextdisabled = false
  694. this.Beforedisabled = false
  695. }
  696. this.tab.table.getdataListParm.parammaps.inputDatetime.length = 0
  697. this.tab.table.getdataListParm.parammaps.inputDatetime.push(start2, stop2)
  698. this.$forceUpdate()
  699. }
  700. this.tab.table.getdataListParm.parammaps.startTime = parseTime(this.tab.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  701. this.tab.table.getdataListParm.parammaps.stopTime = parseTime(this.tab.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  702. this.getTabList()
  703. },
  704. handleBefore2() {
  705. if (this.tab2.table.getdataListParm.parammaps.inputDatetime !== '' && this.tab2.table.getdataListParm.parammaps.inputDatetime !== null) {
  706. var start3 = new Date(this.tab2.table.getdataListParm.parammaps.inputDatetime[0].setDate(this.tab2.table.getdataListParm.parammaps.inputDatetime[0].getDate() - 1))
  707. var stop3 = new Date(this.tab2.table.getdataListParm.parammaps.inputDatetime[1].setDate(this.tab2.table.getdataListParm.parammaps.inputDatetime[1].getDate() - 1))
  708. if (stop3 > Date.now() - 8.64e7) {
  709. this.Nextdisabled2 = true
  710. this.Beforedisabled2 = false
  711. } else {
  712. this.Nextdisabled2 = false
  713. this.Beforedisabled2 = false
  714. }
  715. this.tab2.table.getdataListParm.parammaps.inputDatetime.length = 0
  716. this.tab2.table.getdataListParm.parammaps.inputDatetime.push(start3, stop3)
  717. this.$forceUpdate()
  718. }
  719. this.tab2.table.getdataListParm.parammaps.startTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  720. this.tab2.table.getdataListParm.parammaps.stopTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  721. this.getTab2List()
  722. },
  723. handleNext2() {
  724. if (this.tab2.table.getdataListParm.parammaps.inputDatetime !== '' && this.tab2.table.getdataListParm.parammaps.inputDatetime !== null) {
  725. var start4 = new Date(this.tab2.table.getdataListParm.parammaps.inputDatetime[0].setDate(this.tab2.table.getdataListParm.parammaps.inputDatetime[0].getDate() + 1))
  726. var stop4 = new Date(this.tab2.table.getdataListParm.parammaps.inputDatetime[1].setDate(this.tab2.table.getdataListParm.parammaps.inputDatetime[1].getDate() + 1))
  727. if (stop4 > Date.now() - 8.64e7) {
  728. this.Nextdisabled2 = true
  729. this.Beforedisabled2 = false
  730. } else {
  731. this.Nextdisabled2 = false
  732. this.Beforedisabled2 = false
  733. }
  734. this.tab2.table.getdataListParm.parammaps.inputDatetime.length = 0
  735. this.tab2.table.getdataListParm.parammaps.inputDatetime.push(start4, stop4)
  736. this.$forceUpdate()
  737. }
  738. this.tab2.table.getdataListParm.parammaps.startTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  739. this.tab2.table.getdataListParm.parammaps.stopTime = parseTime(this.tab2.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  740. this.getTab2List()
  741. },
  742. handleBefore3() {
  743. if (this.tab3.table.getdataListParm.parammaps.inputDatetime !== '' && this.tab3.table.getdataListParm.parammaps.inputDatetime !== null) {
  744. var start5 = new Date(this.tab3.table.getdataListParm.parammaps.inputDatetime[0].setDate(this.tab3.table.getdataListParm.parammaps.inputDatetime[0].getDate() - 1))
  745. var stop5 = new Date(this.tab3.table.getdataListParm.parammaps.inputDatetime[1].setDate(this.tab3.table.getdataListParm.parammaps.inputDatetime[1].getDate() - 1))
  746. if (stop5 > Date.now() - 8.64e7) {
  747. this.Nextdisabled3 = true
  748. this.Beforedisabled3 = false
  749. } else {
  750. this.Nextdisabled3 = false
  751. this.Beforedisabled3 = false
  752. }
  753. this.tab3.table.getdataListParm.parammaps.inputDatetime.length = 0
  754. this.tab3.table.getdataListParm.parammaps.inputDatetime.push(start5, stop5)
  755. this.$forceUpdate()
  756. }
  757. this.tab3.table.getdataListParm.parammaps.startTime = parseTime(this.tab3.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  758. this.tab3.table.getdataListParm.parammaps.stopTime = parseTime(this.tab3.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  759. this.getTab3List()
  760. },
  761. handleNext3() {
  762. if (this.tab3.table.getdataListParm.parammaps.inputDatetime !== '' && this.tab2.table.getdataListParm.parammaps.inputDatetime !== null) {
  763. var start6 = new Date(this.tab3.table.getdataListParm.parammaps.inputDatetime[0].setDate(this.tab3.table.getdataListParm.parammaps.inputDatetime[0].getDate() + 1))
  764. var stop6 = new Date(this.tab3.table.getdataListParm.parammaps.inputDatetime[1].setDate(this.tab3.table.getdataListParm.parammaps.inputDatetime[1].getDate() + 1))
  765. if (stop6 > Date.now() - 8.64e7) {
  766. this.Nextdisabled3 = true
  767. this.Beforedisabled3 = false
  768. } else {
  769. this.Nextdisabled3 = false
  770. this.Beforedisabled3 = false
  771. }
  772. this.tab3.table.getdataListParm.parammaps.inputDatetime.length = 0
  773. this.tab3.table.getdataListParm.parammaps.inputDatetime.push(start6, stop6)
  774. this.$forceUpdate()
  775. }
  776. this.tab3.table.getdataListParm.parammaps.startTime = parseTime(this.tab3.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  777. this.tab3.table.getdataListParm.parammaps.stopTime = parseTime(this.tab3.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  778. this.getTab3List()
  779. },
  780. changeRadio3() {
  781. console.log(this.tab3.radio)
  782. if (this.tab3.radio == '1') {
  783. this.tab3.isRadio1 = true,
  784. this.tab3.isRadio2 = false,
  785. this.tab3.isRadio3 = false,
  786. this.tab3.isRadio4 = false,
  787. this.tab3.table.getdataListParm.name = 'getPriceAnalysisSC'
  788. this.tab3.table.getdataListParm.offset = 1
  789. this.tab3.table.getdataListParm.parammaps.startTime = parseTime(this.tab3.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  790. this.tab3.table.getdataListParm.parammaps.stopTime = parseTime(this.tab3.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  791. this.getTab3List()
  792. } else if (this.tab3.radio == '2') {
  793. this.tab3.isRadio1 = false,
  794. this.tab3.isRadio2 = true,
  795. this.tab3.isRadio3 = false,
  796. this.tab3.isRadio4 = false,
  797. this.tab3.table.getdataListParm.name = 'getPriceAnalysisLS'
  798. this.tab3.table.getdataListParm.offset = 1
  799. this.tab3.table.getdataListParm.parammaps.startTime = parseTime(this.tab3.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  800. this.tab3.table.getdataListParm.parammaps.stopTime = parseTime(this.tab3.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  801. this.getTab3List()
  802. } else if (this.tab3.radio == '3') {
  803. this.tab3.isRadio1 = false,
  804. this.tab3.isRadio2 = false,
  805. this.tab3.isRadio3 = true,
  806. this.tab3.isRadio4 = false,
  807. this.tab3.table.getdataListParm.name = 'getPriceAnalysisRQ'
  808. this.tab3.table.getdataListParm.offset = 1
  809. this.tab3.table.getdataListParm.parammaps.startTime = parseTime(this.tab3.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  810. this.tab3.table.getdataListParm.parammaps.stopTime = parseTime(this.tab3.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  811. this.getTab3List()
  812. } else if (this.tab3.radio == '4') {
  813. this.tab3.isRadio1 = false,
  814. this.tab3.isRadio2 = false,
  815. this.tab3.isRadio3 = false,
  816. this.tab3.isRadio4 = true,
  817. this.tab3.table.getdataListParm.name = 'getPriceAnalysisTMR'
  818. this.tab3.table.getdataListParm.offset = 1
  819. this.tab3.table.getdataListParm.parammaps.startTime = parseTime(this.tab3.table.getdataListParm.parammaps.inputDatetime[0], '{y}-{m}-{d}')
  820. this.tab3.table.getdataListParm.parammaps.stopTime = parseTime(this.tab3.table.getdataListParm.parammaps.inputDatetime[1], '{y}-{m}-{d}')
  821. this.getTab3List()
  822. }
  823. },
  824. changeChecked(item) {
  825. this.form_search('second')
  826. },
  827. handleExport(item) {
  828. if (item == 'tab1') {
  829. console.log('库存统计导出')
  830. this.downLoad.getdataListParm = {}
  831. this.downLoad.getdataListParm.name = 'getfsStaticlist'
  832. this.downLoad.getdataListParm.pagecount = ''
  833. this.downLoad.getdataListParm.parammaps = this.tab.table.getdataListParm.parammaps
  834. GetDataByName(this.downLoad.getdataListParm).then(response => {
  835. if (response.data.list !== null) {
  836. this.$nextTick(() => {
  837. this.downLoad.list = response.data.list
  838. })
  839. } else {
  840. this.downLoad.list = []
  841. }
  842. import('@/vendor/Export5Excel').then(excel => {
  843. const multiHeader = [['饲料名称', '期初', '', '用量', '', '', '', '期末', '']]
  844. const multiHeader2 = [['', '期初库存(kg)', '期初金额(元)', '入库重量(kg)', '系统出库重量(kg)', '人工用料重量(kg)', '损耗重量', '期末库存(kg)', '期末金额(元)']]
  845. const filterVal = ['feedname', 'startsum', 'startprice', 'laidsum', 'usesumXT', 'usesumRG', 'usesumXH', 'stopsum', 'stopprice']
  846. const data = this.downLoad.list.map((v) => filterVal.map((j) => v[j]))
  847. const merges = ['A1:A2', 'B1:C1', 'D1:G1', 'H1:I1']
  848. excel.export_json_to_excel({ multiHeader, multiHeader2, data, filename: '库存统计', merges })
  849. })
  850. })
  851. } else if (item == 'tab2') {
  852. console.log('用料分析导出数据', this.tab2.table.list)
  853. console.log('用料分析导出表头', this.tab2.table.tableConfig)
  854. console.log(this.tab2.table.getdataListParm.checked, 'checked')
  855. console.log(this.tab2.table.getdataListParm)
  856. var startTime = this.tab2.table.getdataListParm.parammaps.startTime
  857. var stopTime = this.tab2.table.getdataListParm.parammaps.stopTime
  858. var exportData = []
  859. var exportTitle1 = [] // 一级标题
  860. var exportTitle2 = [] // 二级标题
  861. var exportTitle3 = [] // 一级标题
  862. var filterValArr = []
  863. for (let i = 0; i < this.tab2.table.tableConfig.length; i++) {
  864. exportTitle1.push(this.tab2.table.tableConfig[i].label)
  865. for (let j = 0; j < this.tab2.table.tableConfig[i].children.length; j++) {
  866. exportTitle2.push(this.tab2.table.tableConfig[i].children[j].label)
  867. for(let a = 0;a<this.tab2.table.tableConfig[i].children[j].children.length;a++){
  868. exportTitle3.push(this.tab2.table.tableConfig[i].children[j].children[a].label)
  869. filterValArr.push(this.tab2.table.tableConfig[i].children[j].children[a].prop)
  870. }
  871. // filterValArr.push(this.tab2.table.tableConfig[i].children[j].prop)
  872. }
  873. }
  874. console.log('一级标题exportTitle1', exportTitle1)
  875. console.log('二级标题exportTitle2', exportTitle2)
  876. console.log('三级标题exportTitle3', exportTitle3)
  877. console.log('对应字段filterValArr', filterValArr)
  878. var headerArr = []// 处理一级标题
  879. var headerArr2 = []// 处理一级标题
  880. if (this.tab2.table.getdataListParm.checked == 1) {
  881. for (let i = 0; i < exportTitle1.length; i++) {
  882. if (i > 0) {
  883. headerArr.push(exportTitle1[i], '', '', '')
  884. } else {
  885. headerArr.push(exportTitle1[i])
  886. }
  887. if (i > 0) {
  888. headerArr2.push(exportTitle2[i], '', '', '')
  889. } else {
  890. headerArr2.push(exportTitle2[i])
  891. }
  892. }
  893. } else {
  894. if(this.tab2.table.getdataListParm.parammaps.typea == ''){
  895. for (let i = 0; i < exportTitle1.length; i++) {
  896. if (i > 0) {
  897. headerArr.push(exportTitle1[i], '')
  898. } else {
  899. headerArr.push(exportTitle1[i])
  900. }
  901. if (i > 0) {
  902. headerArr2.push(exportTitle2[i], '')
  903. } else {
  904. headerArr2.push(exportTitle2[i])
  905. }
  906. }
  907. }else{
  908. headerArr = exportTitle1
  909. headerArr2 = exportTitle2
  910. }
  911. }
  912. console.log('headerArr', headerArr)
  913. console.log('exportTitle2', exportTitle2)
  914. console.log('filterValArr', filterValArr)
  915. if (headerArr.length > 0) {
  916. import('@/vendor/Export3Excel').then((excel) => {
  917. const multiHeader = [
  918. headerArr
  919. ]
  920. const multiHeader2 = [
  921. headerArr2
  922. ]
  923. const tHeader = exportTitle3
  924. const filterVal = filterValArr
  925. const data = this.tab2.table.list.map(v => filterVal.map(j => v[j]))
  926. // const data = []
  927. const merges = ['A1:A1']
  928. excel.export_json_to_excel({ multiHeader, multiHeader2, header: tHeader, data, filename: '用料分析-'+startTime+'-' +stopTime , merges })
  929. })
  930. }else{
  931. import('@/vendor/Export3Excel').then((excel) => {
  932. const multiHeader = [
  933. headerArr
  934. ]
  935. const multiHeader2 = []
  936. const tHeader = exportTitle2
  937. const filterVal = filterValArr
  938. const data = this.tab2.table.list.map(v => filterVal.map(j => v[j]))
  939. // const data = []
  940. // const merges = ['A1:A1']
  941. const merges = []
  942. excel.export_json_to_excel({ multiHeader, multiHeader2, header: tHeader, data, filename: '用料分析', merges })
  943. })
  944. }
  945. } else if (item == 'tab3') {
  946. console.log('价格分析导出')
  947. console.log('价格分析导出数据', this.tab3.table.list)
  948. console.log('价格分析导出表头', this.tab3.table.tableConfig)
  949. var exportData = []
  950. var exportTitle1 = [] // 一级标题
  951. var exportTitle2 = [] // 二级标题
  952. for (let i = 0; i < this.tab3.table.tableConfig.length; i++) {
  953. exportTitle1.push(this.tab3.table.tableConfig[i].label)
  954. for (let j = 0; j < this.tab3.table.tableConfig[i].children.length; j++) {
  955. exportTitle2.push(this.tab3.table.tableConfig[i].children[j].label)
  956. }
  957. }
  958. console.log('一级标题exportTitle1', exportTitle1)
  959. console.log('二级标题exportTitle2', exportTitle2)
  960. var headerArr = []// 处理一级标题
  961. for (let i = 0; i < exportTitle1.length; i++) {
  962. if (i > 0) {
  963. headerArr.push(exportTitle1[i], '')
  964. } else {
  965. headerArr.push(exportTitle1[i])
  966. }
  967. }
  968. console.log('一级表头处理后', headerArr)
  969. var valueArr = [] // 对应字段
  970. for (let i = 0; i < exportTitle2.length; i++) {
  971. if (i == 0) {
  972. valueArr.push('A')
  973. } else {
  974. valueArr.push('a' + [i - 1])
  975. }
  976. }
  977. console.log('对应字段valueArr', valueArr)
  978. if (headerArr.length > 0) {
  979. import('@/vendor/Export3Excel').then((excel) => {
  980. const multiHeader = [
  981. headerArr
  982. ]
  983. const multiHeader2 = []
  984. const tHeader = exportTitle2
  985. const filterVal = valueArr// 表头所对应的字段,这里未填写
  986. const data = this.tab3.table.list.map(v => filterVal.map(j => v[j]))
  987. // const data = [];
  988. // 进行所有表头的单元格合并
  989. // const merges = ['A1:A1', 'B1:E1','F1:J1' ];
  990. const merges = ['A1:A1']
  991. excel.export_json_to_excel({ multiHeader, multiHeader2, header: tHeader, data, filename: '价格分析', merges })
  992. })
  993. }
  994. }
  995. },
  996. format(jsonData) { // 数据处理
  997. const dataList = []
  998. for (let i = 0; i < jsonData.length; i++) {
  999. const list = []
  1000. list.push(jsonData[i].index)
  1001. list.push(jsonData[i].Personel)
  1002. list.push(jsonData[i].address)
  1003. for (let j = 0; j < jsonData[0]['time'].length; j++) {
  1004. list.push(jsonData[i]['time'][j].morning)
  1005. list.push(jsonData[i]['time'][j].afternoon)
  1006. }
  1007. dataList.push(list)
  1008. }
  1009. return dataList
  1010. }
  1011. }
  1012. }
  1013. </script>
  1014. <style lang="scss" scoped>
  1015. .search{
  1016. margin-bottom:10px;
  1017. .el-radio{margin-right: 10px;}
  1018. .filter-item1{margin-top: 10px;}
  1019. }
  1020. /deep/ .el-table th>.cell{
  1021. padding-left: 0 !important;;
  1022. padding-right: 0 !important;;
  1023. }
  1024. /deep/ .el-table td>.cell{
  1025. padding-left: 0 !important;;
  1026. padding-right: 0 !important;;
  1027. }
  1028. // .el-radio{margin-right: 20px;}
  1029. </style>
  1030. <style lang="scss">
  1031. .el-tooltip__popper{
  1032. max-width: 60% !important;
  1033. }
  1034. .plTableBox .el-table td.is-hidden>*, .plTableBox .el-table th.is-hidden>*{
  1035. visibility:inherit;
  1036. }
  1037. .plTableBox .el-table th>.cell{
  1038. white-space: pre-wrap;
  1039. }
  1040. </style>