index.vue 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819
  1. <template>
  2. <div id="demandSummary">
  3. <div v-if="isList">
  4. <el-card style="position: relative;">
  5. <el-form class="search_area" label-width="100px">
  6. <el-row :gutter="10">
  7. <el-col :span="1.5">
  8. <el-form-item label="行状态">
  9. <el-select multiple v-model="queryParams.rowStatus" size="mini" style="width: 200px" clearable>
  10. <el-option v-for="dict in dict.type.sys_row_status" :key="dict.value" :label="dict.label" :value="dict.value">
  11. </el-option>
  12. </el-select>
  13. </el-form-item>
  14. </el-col>
  15. <el-col :span="1.5">
  16. <el-form-item label="采购员">
  17. <el-select clearable size="mini" v-model="queryParams.buyer" @focus="chooseRefer('CONTACTS_PARAM', true, '采购员')" style="width: 200px">
  18. <el-option v-for="item in personOptions" :key="item.id" :label="item.name" :value="item.code" />
  19. </el-select>
  20. </el-form-item>
  21. </el-col>
  22. <el-col :span="1.5">
  23. <el-form-item label="品类">
  24. <el-select
  25. v-model="queryParams.materialClassifyFourName"
  26. size="mini"
  27. clearable
  28. @focus="chooseTreeRefer('MATERIALCLASSIFY_PARAM', false, '选择品类')"
  29. style="width: 200px"
  30. >
  31. <el-option v-for="item in classOptions" :key="item.id" :label="item.name" :value="item.name" />
  32. </el-select>
  33. </el-form-item>
  34. </el-col>
  35. <el-col :span="1.5">
  36. <el-form-item label="生产厂家">
  37. <el-input
  38. v-model.trim="queryParams.manufacturer"
  39. size="mini"
  40. clearable
  41. style="width: 200px"
  42. />
  43. </el-form-item>
  44. </el-col>
  45. <!-- <el-col :span="1.5"> -->
  46. <!-- <el-form-item label="" label-width="20px"> -->
  47. <div style="position: absolute;top: 3px;right: 10px;">
  48. <el-button type="primary" size="mini" icon="el-icon-search" @click="search">搜索</el-button>
  49. <el-button size="mini" icon="el-icon-refresh" plain @click="reset">重置</el-button>
  50. </div>
  51. <!-- </el-form-item> -->
  52. <!-- </el-col> -->
  53. </el-row>
  54. <CollapseTransition>
  55. <div v-show="expanded">
  56. <el-row :gutter="10">
  57. <el-col :span="1.5">
  58. <el-form-item label="预测分类">
  59. <el-select v-model="queryParams.forecastClassification" size="mini" style="width: 200px" clearable>
  60. <el-option
  61. v-for="dict in dict.type.predictive_classify" :key="dict.value" :label="dict.label" :value="dict.label">
  62. </el-option>
  63. </el-select>
  64. </el-form-item>
  65. </el-col>
  66. <el-col :span="1.5">
  67. <el-form-item label="审核人">
  68. <el-select clearable size="mini" v-model="queryParams.puManagerAuditor" @focus="chooseRefer('CONTACTS_PARAM', true, '审核人')" style="width: 200px">
  69. <el-option v-for="item in auditOptions" :key="item.id" :label="item.name" :value="item.code" />
  70. </el-select>
  71. </el-form-item>
  72. </el-col>
  73. <el-col :span="1.5">
  74. <el-form-item label="注册人">
  75. <el-input
  76. v-model.trim="queryParams.registrant"
  77. size="mini"
  78. clearable
  79. style="width: 200px"
  80. />
  81. </el-form-item>
  82. </el-col>
  83. <el-col :span="1.5">
  84. <el-form-item label="业务类型">
  85. <el-select v-model="queryParams.businessType" size="mini" style="width: 200px" clearable>
  86. <el-option
  87. v-for="dict in dict.type.sys_business" :key="dict.value" :label="dict.label" :value="dict.value">
  88. </el-option>
  89. </el-select>
  90. </el-form-item>
  91. </el-col>
  92. </el-row>
  93. <el-row :gutter="10">
  94. <el-col :span="1.5">
  95. <el-form-item label="单据来源">
  96. <el-select v-model="queryParams.billSource" size="mini" style="width: 200px" clearable>
  97. <el-option
  98. v-for="dict in dict.type.sys_bill_source" :key="dict.value" :label="dict.label" :value="dict.value">
  99. </el-option>
  100. </el-select>
  101. </el-form-item>
  102. </el-col>
  103. <el-col :span="1.5">
  104. <el-form-item label="需求客户">
  105. <el-select clearable size="mini" v-model="queryParams.customer" @focus="chooseRefer('CUSTOMER_PARAM', true, '需求客户')" style="width: 200px">
  106. <el-option v-for="item in customerOptions" :key="item.id" :label="item.name" :value="item.id" />
  107. </el-select>
  108. </el-form-item>
  109. </el-col>
  110. <el-col :span="1.5">
  111. <el-form-item label="供应仓库">
  112. <el-select clearable size="mini" v-model="queryParams.lastWarehouse" @focus="chooseRefer('WAREHOUSE_PARAM', true, '供应仓库')" style="width: 200px">
  113. <el-option v-for="item in lastWarehouseOptions" :key="item.id" :label="item.name" :value="item.id" />
  114. </el-select>
  115. </el-form-item>
  116. </el-col>
  117. <el-col :span="1.5">
  118. <el-form-item label="供应库位">
  119. <el-select clearable size="mini" v-model="queryParams.lastAllocation" @focus="chooseRefer('ALLOCATION_PARAM', true, '供应库位', queryParams.lastWarehouse)" style="width: 200px">
  120. <el-option v-for="item in lastAllocationOptions" :key="item.id" :label="item.name" :value="item.id" />
  121. </el-select>
  122. </el-form-item>
  123. </el-col>
  124. <!-- <el-col :span="1.5">
  125. <el-form-item label="转请购时间">
  126. <el-select v-model="queryParams.ywlx" size="mini" style="width: 200px" clearable>
  127. <el-option
  128. v-for="item in options"
  129. :key="item.value"
  130. :label="item.label"
  131. :value="item.value">
  132. </el-option>
  133. </el-select>
  134. </el-form-item>
  135. </el-col> -->
  136. </el-row>
  137. <el-row :gutter="10">
  138. <el-col :span="1.5">
  139. <el-form-item label="物料编码">
  140. <el-input clearable size="mini" v-model="queryParams.names" @clear="queryParams.materialCode = ''" @focus="chooseMaterial" style="width: 200px">
  141. <el-button size="mini" slot="append" icon="el-icon-more" @click="chooseMaterial"></el-button>
  142. </el-input>
  143. <el-input v-show="false" v-model="queryParams.materialCode"></el-input>
  144. </el-form-item>
  145. </el-col>
  146. <el-col :span="1.5">
  147. <el-form-item label="默认采购组织">
  148. <el-select clearable size="mini" v-model="queryParams.purchaseOrg" @focus="chooseRefer('ORG_PARAM', true, '默认采购组织')" style="width: 200px">
  149. <el-option v-for="item in orgOptions" :key="item.id" :label="item.name" :value="item.id" />
  150. </el-select>
  151. </el-form-item>
  152. </el-col>
  153. <el-col :span="1.5">
  154. <el-form-item label="需求日期">
  155. <el-date-picker
  156. v-model="queryParams.demandDate"
  157. type="date"
  158. value-format="yyyy-MM-dd"
  159. size="mini"
  160. style="width: 200px"
  161. >
  162. </el-date-picker>
  163. </el-form-item>
  164. </el-col>
  165. <el-col :span="1.5">
  166. <el-form-item label="采购需求单号">
  167. <el-input
  168. v-model.trim="queryParams.code"
  169. size="mini"
  170. clearable
  171. style="width: 200px"
  172. />
  173. </el-form-item>
  174. </el-col>
  175. </el-row>
  176. <el-row :gutter="10">
  177. <el-col :span="1.5">
  178. <el-form-item label="审批结束日期">
  179. <el-date-picker
  180. v-model="queryParams.approverFinishTime"
  181. type="date"
  182. clearable
  183. value-format="yyyy-MM-dd"
  184. size="mini"
  185. style="width: 200px"
  186. >
  187. </el-date-picker>
  188. </el-form-item>
  189. </el-col>
  190. </el-row>
  191. </div>
  192. </CollapseTransition>
  193. </el-form>
  194. <el-divider class="lines"><i style="cursor: pointer;" :class="expanded?'el-icon-arrow-up':'el-icon-arrow-down'" @click="drop"></i></el-divider>
  195. <div class="btn_grooup">
  196. <el-button type="primary" size="mini" @click="editList">编辑</el-button>
  197. <el-button type="danger" size="mini" v-if="!lineDisable" @click="cancelEdit">取消编辑</el-button>
  198. <el-button type="success" size="mini" v-if="!lineDisable" @click="saveList">保存</el-button>
  199. <el-button type="primary" size="mini" v-if="lineDisable" @click="confirms">确认</el-button>
  200. <el-button type="primary" size="mini" v-if="lineDisable" @click="cancels">取消</el-button>
  201. <el-button type="primary" size="mini" v-if="lineDisable" @click="audits">审核</el-button>
  202. <el-button type="primary" size="mini" v-if="lineDisable" @click="closeLine">行关闭</el-button>
  203. <el-dropdown size="mini" v-if="lineDisable" @command="handleCommand">
  204. <el-button size="mini" type="primary" style="margin: 0 10px;">
  205. 导出<i class="el-icon-arrow-down el-icon--right"></i>
  206. </el-button>
  207. <el-dropdown-menu slot="dropdown">
  208. <el-dropdown-item command="Excel导出">Excel导出</el-dropdown-item>
  209. <el-dropdown-item command="导出明细">导出明细</el-dropdown-item>
  210. </el-dropdown-menu>
  211. </el-dropdown>
  212. <!-- <el-button type="primary" size="mini">转请购</el-button> -->
  213. </div>
  214. <el-table
  215. :data="tableList"
  216. fit
  217. :cell-style="{ borderColor: '#c0c0c0' }"
  218. :header-cell-style="{ borderColor: '#c0c0c0' }"
  219. class="exporttable"
  220. border
  221. show-summary
  222. :summary-method="getSummaries"
  223. max-height="550"
  224. style="font-size: 12px;"
  225. @selection-change="handleSelectionChange"
  226. :key="isUpdate"
  227. >
  228. <el-table-column type="selection" width="60" />
  229. <!-- <el-table-column show-overflow-tooltip label="行号" align="center" prop="rowNo"/> -->
  230. <el-table-column show-overflow-tooltip label="行状态" align="center" prop="status" width="100px" :formatter="hangStatus"/>
  231. <el-table-column show-overflow-tooltip label="一级品类" align="center" prop="materialClassifyOneName" width="100px"/>
  232. <el-table-column show-overflow-tooltip label="物料编码" align="center" prop="materialCode" width="150px"/>
  233. <el-table-column show-overflow-tooltip label="品名" align="center" prop="materialName" width="150px"/>
  234. <el-table-column show-overflow-tooltip label="规格" align="center" prop="specification" width="150px"/>
  235. <el-table-column show-overflow-tooltip label="单位" align="center" prop="unit"/>
  236. <el-table-column show-overflow-tooltip label="生产厂家/代理人" align="center" prop="manufacturer" width="200px"/>
  237. <el-table-column show-overflow-tooltip label="需求单位数" align="center" prop="demandNum" width="100px"/>
  238. <el-table-column show-overflow-tooltip label="近1月月均需求" align="center" prop="evensalesforyear" width="120px"/>
  239. <el-table-column show-overflow-tooltip label="近3月月均需求" align="center" prop="evensalesforthrmonth" width="120px"/>
  240. <el-table-column show-overflow-tooltip label="总最终净需求量" align="center" prop="netDemandNum" width="120px"/>
  241. <el-table-column show-overflow-tooltip label="总月销量" align="center" prop="totalMonthlySales"/>
  242. <el-table-column show-overflow-tooltip label="需求可用周期" align="center" prop="demandCycle" width="120px"/>
  243. <el-table-column show-overflow-tooltip label="呆滞量" align="center" prop="dullQut"/>
  244. <el-table-column show-overflow-tooltip label="采购周期" align="center" prop="buyPeriod"/>
  245. <el-table-column show-overflow-tooltip label="中心公共库存" align="center" prop="centralPublicStock" width="120px"/>
  246. <el-table-column show-overflow-tooltip label="中心仓专属货位" align="center" prop="centralWarehouse" width="120px"/>
  247. <el-table-column show-overflow-tooltip label="区域分仓公共库存" align="center" prop="regionPublicStock" width="150px"/>
  248. <el-table-column show-overflow-tooltip label="各项目仓库存" align="center" prop="eachWarehouseStock" width="120px"/>
  249. <el-table-column show-overflow-tooltip label="电商仓库" align="center" prop="commerceWarehouse"/>
  250. <el-table-column show-overflow-tooltip label="采购在途" align="center" prop="buyTransit"/>
  251. <el-table-column show-overflow-tooltip label="借出在途" align="center" prop="lendTransit"/>
  252. <el-table-column show-overflow-tooltip label="调拨在途" align="center" prop="transferTransit"/>
  253. <el-table-column show-overflow-tooltip label="库存总计" align="center" prop="stockTotal"/>
  254. <el-table-column show-overflow-tooltip label="最小包装量" align="center" prop="minPackage" width="100px"/>
  255. <el-table-column show-overflow-tooltip label="最小订货量" align="center" prop="minOrder" width="100px"/>
  256. <el-table-column show-overflow-tooltip label="最小批量" align="center" prop="minBatch"/>
  257. <el-table-column show-overflow-tooltip label="人工调整数" align="center" prop="artificialAdjust" width="100px"/>
  258. <el-table-column show-overflow-tooltip label="修改原因" align="center" prop="modifyReason" width="150px">
  259. <template slot-scope="scope">
  260. <el-input :disabled="scope.row.status !== '1'|| lineDisable || scope.row.artificialAdjust == '0'" v-model="scope.row.modifyReason"/>
  261. </template>
  262. </el-table-column>
  263. <el-table-column show-overflow-tooltip label="建议采购量" align="center" prop="suggestionPurchase" width="100px"/>
  264. <!-- <el-table-column show-overflow-tooltip label="建议净采购量" align="center" prop="suggestBuyQty" width="100px"/> -->
  265. <el-table-column show-overflow-tooltip label="最终采购量" align="center" prop="finalBuyQty" width="100">
  266. <template slot-scope="scope">
  267. <el-input :disabled="scope.row.status !== '1' || lineDisable" v-model="scope.row.finalBuyQty"/>
  268. </template>
  269. </el-table-column>
  270. <el-table-column show-overflow-tooltip label="二级品类" align="center" prop="materialClassifyTwoName" width="120px"/>
  271. <el-table-column show-overflow-tooltip label="三级品类" align="center" prop="materialClassifyThreeName" width="120px"/>
  272. <el-table-column show-overflow-tooltip label="四级品类" align="center" prop="materialClassifyFourName" width="120px"/>
  273. <el-table-column show-overflow-tooltip label="采购员" align="center" prop="buyerName" width="150px">
  274. <template slot-scope="scope">
  275. <el-input readonly :disabled="scope.row.status !== '1' || lineDisable" size="mini" v-model="scope.row.buyerName">
  276. <el-button size="mini" :disabled="scope.row.status !== '1' || lineDisable" slot="append" icon="el-icon-more" @click="chooseSon(scope.$index, 'CONTACTS_PARAM', true, '明细采购员')"></el-button>
  277. </el-input>
  278. </template>
  279. </el-table-column>
  280. <el-table-column show-overflow-tooltip label="默认采购组织" align="center" prop="purchaseOrgName" width="230px">
  281. <!-- <template slot-scope="scope">
  282. <el-input readonly :disabled="scope.row.status !== '1' || lineDisable" size="mini" v-model="scope.row.purchaseOrgName">
  283. <el-button size="mini" :disabled="scope.row.status !== '1' || lineDisable" slot="append" icon="el-icon-more" @click="chooseSon(scope.$index, 'ORG_PARAM', true, '明细默认采购组织')"></el-button>
  284. </el-input>
  285. </template> -->
  286. </el-table-column>
  287. <el-table-column show-overflow-tooltip label="有效期" align="center" prop="validityPeriod"/>
  288. <el-table-column show-overflow-tooltip label="有效期单位" align="center" prop="validityPeriodUnit" width="100px"/>
  289. <el-table-column show-overflow-tooltip label="业务类型" align="center" prop="businessType" :formatter="formatterBusinessType"/>
  290. <el-table-column show-overflow-tooltip label="安全库存量" align="center" prop="safetyStock" width="100px"/>
  291. <el-table-column show-overflow-tooltip label="单据来源" align="center" prop="billSource" :formatter="formatterSource"/>
  292. <el-table-column show-overflow-tooltip label="注册人" align="center" prop="registrant" width="120px"/>
  293. <!-- <el-table-column label="可用量" align="center" prop="qty"/> -->
  294. <el-table-column show-overflow-tooltip label="总需与终采差异" align="center" prop="buyDiscrepancy" width="120px"/>
  295. <el-table-column show-overflow-tooltip label="集团预测分类" align="center" prop="forecastClassification" width="120px"/>
  296. <el-table-column show-overflow-tooltip label="中心仓占有量" align="center" prop="centerBinPossession" width="120px"/>
  297. <el-table-column show-overflow-tooltip label="中心仓可用量" align="center" prop="centralWarehouseAvailable" width="120px"/>
  298. <!-- <el-table-column label="物料类别" align="center" prop="materialCategory" width="150px"/> -->
  299. <!-- <el-table-column label="业务部门" align="center" prop="departmentName" width="150px"/> -->
  300. <!-- <el-table-column show-overflow-tooltip label="需求单位" align="center" prop="demandUnit"/> -->
  301. <el-table-column show-overflow-tooltip label="采购经理审核人" align="center" prop="puManagerAuditor" width="120px"/>
  302. <el-table-column
  303. fixed="right"
  304. label="操作"
  305. align="center"
  306. width="100"
  307. >
  308. <template slot-scope="scope">
  309. <el-button type="text" size="mini" @click="check(scope.row)">查看</el-button>
  310. </template>
  311. </el-table-column>
  312. </el-table>
  313. <el-pagination
  314. background
  315. @size-change="handleSizeChange"
  316. @current-change="handleCurrentChange"
  317. :current-page="queryParams.pageNum"
  318. :page-sizes="[10, 20, 50, 100]"
  319. :page-size="10"
  320. layout="total, sizes, prev, pager, next, jumper"
  321. :total=total>
  322. </el-pagination>
  323. </el-card>
  324. </div>
  325. <Add v-model="isList" v-if="!isList" :pageStu="page" :disable="disable" :row="rowDetail" :query="queryParams" @refresh="search"/>
  326. <Refers ref="refer" @doSubmit="selectionsToInput" :single="true"/>
  327. <TreeRefers ref="tree" @doSubmit="selectionsToInput2" :single="true"/>
  328. <popDialog ref="materialRefer" @doSubmit="selectMaterial" :single="true" />
  329. </div>
  330. </template>
  331. <script>
  332. import Add from './add.vue'
  333. import Refers from '@/components/Refers/refers.vue'
  334. import TreeRefers from '@/components/Refers/treeRefer.vue'
  335. import popDialog from '@/components/PopDialog/index.vue'
  336. import CollapseTransition from '@/components/MyCollapse/collapse.vue'
  337. import {getSummaryList, auditSummary, confirmSummary , cancelSummary , shutDownSummary, editSummaryList, exportList, exportItems } from '@/api/purchase/DemandSummary.js'
  338. export default {
  339. name: 'demandSummary',
  340. dicts: ['sys_row_status', 'predictive_classify', 'sys_period_unit', 'sys_business', 'sys_bill_source'],
  341. components: {
  342. Add,
  343. CollapseTransition,
  344. Refers,
  345. TreeRefers,
  346. popDialog
  347. },
  348. data() {
  349. return {
  350. hangStatus(row) {
  351. switch (row.status) {
  352. case '0':
  353. return '需补货'
  354. case '1':
  355. return '待计划确认'
  356. case '2':
  357. return '计划已确认'
  358. case '3':
  359. return '计划已审核'
  360. case '4':
  361. return '行关闭'
  362. case '5':
  363. return '总供应可满足'
  364. }
  365. },
  366. formatterBusinessType(row) {
  367. switch (row.businessType) {
  368. case 'ZQBH':
  369. return '周期备货'
  370. case 'FXXQ':
  371. return '分销需求'
  372. case 'TSXQ':
  373. return '特殊采购需求'
  374. case 'BDXQ':
  375. return '补单需求'
  376. case 'JJXQ':
  377. return '紧急需求单'
  378. case 'XPXQ':
  379. return '新品需求'
  380. case 'HZBM':
  381. return '合作部门需求'
  382. }
  383. },
  384. formatterSource(row) {
  385. switch (row.billSource) {
  386. case '1':
  387. return '手工导入'
  388. case '2':
  389. return '按客户计算'
  390. case '3':
  391. return '按仓库计算'
  392. case '4':
  393. return '手工新增'
  394. }
  395. },
  396. isUpdate: false,
  397. expanded: false,
  398. // 页面配置
  399. isList: true,
  400. // 页面状态
  401. page: '',
  402. queryParams: {
  403. rowStatus: ['1'],
  404. buyer: '',
  405. buyerName: '',
  406. materialClassifyFourName: '',
  407. manufacturer: '',
  408. forecastClassification: '',
  409. periodUnit: '',
  410. departmentName: '',
  411. puManagerAuditor: '',
  412. // zqgdh: '',
  413. code: '',
  414. registrant: '',
  415. businessType: '',
  416. billSource: '',
  417. customer: '',
  418. lastWarehouse: '',
  419. lastAllocation: '',
  420. materialCode: '',
  421. names: '',
  422. purchaseOrg: '',
  423. demandDate: '',
  424. approverFinishTime: '',
  425. pageNum: 1,
  426. pageSize: 10
  427. },
  428. personOptions: [],
  429. classOptions: [],
  430. deptOptions: [],
  431. auditOptions: [],
  432. customerOptions: [],
  433. lastWarehouseOptions: [],
  434. lastAllocationOptions: [],
  435. orgOptions: [],
  436. options: [{
  437. value: 'Y', label: '是',
  438. }, {
  439. value: 'N', label: '否'
  440. }],
  441. referCondition: {
  442. type: '',
  443. isPage: true,
  444. title: ''
  445. },
  446. tableList: [],
  447. total: 0,
  448. rowDetail: {},
  449. disable: false,
  450. lineDisable: true,
  451. ids: [],
  452. allSelection: [],
  453. // 子表index
  454. tableIndex: null,
  455. // referConditionMx: {
  456. // type: '',
  457. // isPage: true,
  458. // title: ''
  459. // }
  460. }
  461. },
  462. created() {
  463. this.getList(this.queryParams)
  464. },
  465. methods: {
  466. // 指定列合计
  467. getSummaries(param) {
  468. const { columns, data } = param;
  469. const sums = [];
  470. columns.forEach((column, index) => {
  471. if (index === 0) {
  472. sums[index] = '合计';
  473. return;
  474. }
  475. const values = data.map(item => Number(item[column.property]));
  476. if (column.property === 'demandNum' || column.property === 'netDemandNum' || column.property === 'artificialAdjust' || column.property === 'suggestBuyQty' || column.property === 'finalBuyQty') {
  477. sums[index] = values.reduce((prev, curr) => {
  478. const value = Number(curr);
  479. if (!isNaN(value)) {
  480. return prev + curr;
  481. } else {
  482. return prev;
  483. }
  484. }, 0);
  485. sums[index];
  486. }
  487. });
  488. return sums
  489. },
  490. // 搜索
  491. search() {
  492. this.getList(this.queryParams)
  493. },
  494. reset() {
  495. this.queryParams = {
  496. rowStatus: ['1'],
  497. buyer: '',
  498. buyerName: '',
  499. materialClassifyFourName: '',
  500. manufacturer: '',
  501. forecastClassification: '',
  502. periodUnit: '',
  503. departmentName: '',
  504. puManagerAuditor: '',
  505. // zqgdh: '',
  506. code: '',
  507. registrant: '',
  508. businessType: '',
  509. billSource: '',
  510. customer: '',
  511. lastWarehouse: '',
  512. lastAllocation: '',
  513. materialCode: '',
  514. names: '',
  515. purchaseOrg: '',
  516. demandDate: '',
  517. approverFinishTime: '',
  518. pageNum: 1,
  519. pageSize: 10
  520. }
  521. this.getList(this.queryParams)
  522. },
  523. getList(params){
  524. getSummaryList(params).then(res => {
  525. if (res.code === 200) {
  526. this.tableList = res.rows
  527. this.total = res.total
  528. }
  529. })
  530. },
  531. handleSelectionChange(selection) {
  532. console.log('选中', selection)
  533. this.allSelection = selection
  534. this.ids = selection.map(item => item.demandItemId)
  535. console.log('选中数组', this.ids.join())
  536. },
  537. handleCommand(command) {
  538. if(command == 'Excel导出') {
  539. if(this.allSelection.length == 0) {
  540. this.$modal.notifyWarning("请选中至少一条数据");
  541. } else {
  542. exportList(this.allSelection).then(res => {
  543. const blob = new Blob([res], {
  544. type: "application/vnd.ms-excel;charset=UTF-8",
  545. });// 创建一个类文件对象:Blob对象表示一个不可变的、原始数据的类文件对象
  546. const downloadElement = document.createElement("a"); //创建a标签
  547. const href = window.URL.createObjectURL(blob); // 创建下载的链接
  548. // var temp = res.headers["content-disposition"];
  549. // var fileName = decodeURIComponent(temp.split("filename=")[1]); // 中文需要转码 (前端乱码)
  550. // var name = fileName.split(";")[0]; //切割成文件名
  551. downloadElement.href = href; //下载地址
  552. downloadElement.download = '导出Excel'; // 下载后文件名
  553. document.body.appendChild(downloadElement);
  554. downloadElement.click(); // 点击下载
  555. document.body.removeChild(downloadElement); // 下载完成移除元素
  556. window.URL.revokeObjectURL(href); // 释放blob对象
  557. })
  558. }
  559. }
  560. if (command == '导出明细') {
  561. if (this.allSelection.length == 0 || this.allSelection.length > 1) {
  562. this.$modal.notifyWarning("明细只能进行单条导出!");
  563. } else {
  564. let param = this.queryParams
  565. param.sumFlag = this.allSelection[0].sumFlag
  566. exportItems(param).then(res => {
  567. const blob = new Blob([res], {
  568. type: "application/vnd.ms-excel;charset=UTF-8",
  569. });// 创建一个类文件对象:Blob对象表示一个不可变的、原始数据的类文件对象
  570. const downloadElement = document.createElement("a"); //创建a标签
  571. const href = window.URL.createObjectURL(blob); // 创建下载的链接
  572. // var temp = res.headers["content-disposition"];
  573. // var fileName = decodeURIComponent(temp.split("filename=")[1]); // 中文需要转码 (前端乱码)
  574. // var name = fileName.split(";")[0]; //切割成文件名
  575. downloadElement.href = href; //下载地址
  576. downloadElement.download = '导出明细'; // 下载后文件名
  577. document.body.appendChild(downloadElement);
  578. downloadElement.click(); // 点击下载
  579. document.body.removeChild(downloadElement); // 下载完成移除元素
  580. window.URL.revokeObjectURL(href); // 释放blob对象
  581. })
  582. }
  583. }
  584. },
  585. check(row) {
  586. this.isList = false
  587. this.page = 'check'
  588. this.rowDetail = row
  589. this.disable = true
  590. },
  591. handleSizeChange(val) {
  592. console.log(`每页 ${val} 条`);
  593. this.queryParams.pageSize = val
  594. this.getList(this.queryParams)
  595. },
  596. handleCurrentChange(val) {
  597. console.log(`当前页: ${val}`);
  598. this.queryParams.pageNum = val
  599. this.getList(this.queryParams)
  600. },
  601. drop() {
  602. this.expanded = !this.expanded
  603. },
  604. editList() {
  605. console.log('Lists`````',this.tableList)
  606. this.lineDisable = false
  607. },
  608. cancelEdit() {
  609. this.lineDisable = true
  610. this.getList(this.queryParams)
  611. },
  612. saveList() {
  613. editSummaryList(this.tableList).then(res => {
  614. if (res.code === 200) {
  615. this.$modal.notifySuccess("保存成功");
  616. this.lineDisable = true
  617. this.getList(this.queryParams)
  618. }
  619. })
  620. },
  621. confirms() {
  622. if (this.ids.length == 0) {
  623. this.$modal.notifyWarning("请选中至少一条数据");
  624. } else {
  625. confirmSummary(this.allSelection).then(res => {
  626. if (res.code === 200) {
  627. this.$modal.notifySuccess("确认成功");
  628. this.getList(this.queryParams)
  629. }
  630. })
  631. }
  632. },
  633. cancels() {
  634. if (this.ids.length == 0) {
  635. this.$modal.notifyWarning("请选中至少一条数据");
  636. } else {
  637. let param = this.ids.join()
  638. cancelSummary(param).then(res => {
  639. if (res.code === 200) {
  640. this.$modal.notifySuccess("取消成功");
  641. this.getList(this.queryParams)
  642. }
  643. })
  644. }
  645. },
  646. audits() {
  647. if(this.ids.length == 0) {
  648. this.$modal.notifyWarning("请选中至少一条数据");
  649. } else {
  650. let param = this.ids.join()
  651. auditSummary(param).then(res => {
  652. if (res.code === 200) {
  653. this.$modal.notifySuccess("审核成功");
  654. this.getList(this.queryParams)
  655. }
  656. })
  657. }
  658. },
  659. // 行关闭
  660. closeitem() {
  661. let param = this.ids.join()
  662. shutDownSummary(param).then(res => {
  663. if (res.code === 200) {
  664. this.$modal.notifySuccess("操作成功");
  665. this.getList(this.queryParams)
  666. }
  667. })
  668. },
  669. closeLine() {
  670. if (this.ids.length == 0) {
  671. this.$modal.notifyWarning("请选中至少一条数据");
  672. } else {
  673. console.log('选中数组', this.allSelection)
  674. let item = this.allSelection.some(item => {
  675. return item.demandNum >= 2
  676. })
  677. if (item) {
  678. this.$modal.confirm('选中项有多个需求单位,是否确定关闭?').then(function () {
  679. }).then(() => {
  680. this.closeitem()
  681. }).catch(() => {})
  682. } else {
  683. this.closeitem()
  684. }
  685. }
  686. },
  687. // 搜索区参照选择
  688. chooseRefer(type, isPage, title, stordocId) {
  689. this.referCondition.type = type
  690. this.referCondition.isPage = isPage
  691. this.referCondition.title = title
  692. this.referCondition.stordocId = stordocId
  693. this.$refs.refer.init(this.referCondition)
  694. },
  695. selectionsToInput(selection) {
  696. if (this.referCondition.title == '采购员') {
  697. this.personOptions = selection
  698. this.queryParams.buyer = selection[0].code
  699. this.queryParams.buyerName = selection[0].name
  700. }
  701. if (this.referCondition.title == '业务部门') {
  702. this.deptOptions = selection
  703. this.queryParams.departmentName = selection[0].id
  704. }
  705. if (this.referCondition.title == '审核人') {
  706. this.auditOptions = selection
  707. this.queryParams.puManagerAuditor = selection[0].code
  708. }
  709. if (this.referCondition.title == '需求客户') {
  710. this.customerOptions = selection
  711. this.queryParams.customer = selection[0].id
  712. }
  713. if (this.referCondition.title == '供应仓库') {
  714. this.lastWarehouseOptions = selection
  715. this.queryParams.lastWarehouse = selection[0].id
  716. }
  717. if (this.referCondition.title == '供应库位') {
  718. this.lastAllocationOptions = selection
  719. this.queryParams.lastAllocation = selection[0].id
  720. }
  721. if (this.referCondition.title == '默认采购组织') {
  722. this.orgOptions = selection
  723. this.queryParams.purchaseOrg = selection[0].id
  724. }
  725. if (this.referCondition.title == '明细采购员') {
  726. console.log('选择进了吗',this.tableList)
  727. this.tableList[this.tableIndex].buyer = selection[0].code
  728. this.tableList[this.tableIndex].buyerName = selection[0].name
  729. }
  730. // if (this.referCondition.title == '明细默认采购组织') {
  731. // console.log('选择进了吗',this.tableList)
  732. // this.tableList[this.tableIndex].purchaseOrg = selection[0].id
  733. // this.tableList[this.tableIndex].purchaseOrgName = selection[0].name
  734. // }
  735. },
  736. // 搜索区树形选择
  737. chooseTreeRefer(type, isPage, title) {
  738. this.referCondition.type = type
  739. this.referCondition.isPage = isPage
  740. this.referCondition.title = title
  741. this.$refs.tree.init(this.referCondition)
  742. },
  743. selectionsToInput2(selection) {
  744. this.classOptions.push(selection)
  745. this.queryParams.materialClassifyFourName = selection.name
  746. },
  747. // 搜索区物料编码
  748. chooseMaterial() {
  749. this.$refs.materialRefer.init()
  750. },
  751. selectMaterial(selection) {
  752. this.queryParams.materialCode = selection[0].code
  753. this.queryParams.names = selection[0].name
  754. },
  755. // 明细行选择业务部门参照带出业务部门数据
  756. chooseSon(index, type, isPage, title) {
  757. this.tableIndex = index
  758. this.referCondition.type = type
  759. this.referCondition.isPage = isPage
  760. this.referCondition.title = title
  761. this.$refs.refer.init(this.referCondition)
  762. }
  763. }
  764. }
  765. </script>
  766. <style lang="scss" scoped>
  767. #demandSummary {
  768. height: calc(100vh - 84px);
  769. padding: 12px;
  770. box-sizing: border-box;
  771. overflow-y: scroll;
  772. }
  773. .btn_grooup {
  774. margin-bottom: 10px;
  775. display: flex;
  776. justify-content: flex-end;
  777. }
  778. .lines {
  779. margin-top: 0;
  780. }
  781. .hang {
  782. margin: auto;
  783. }
  784. .hang ::v-deep .el-form-item__content{
  785. margin-left: 0px !important;
  786. }
  787. .el-pagination {
  788. margin-top: 10px;
  789. text-align: right;
  790. }
  791. ::v-deep .el-table__row > td {
  792. border: none;
  793. }
  794. ::v-deep .el-card .el-form-item {
  795. margin-bottom: 10px;
  796. }
  797. </style>
  798. <style>
  799. .exporttable {
  800. border: solid 1px #c0c0c0;
  801. }
  802. </style>