index.vue 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531
  1. <template>
  2. <div class="app-container">
  3. <!-- 搜索表单 -->
  4. <el-card shadow="never">
  5. <el-form :model="queryParams" inline>
  6. <TenantSelect v-model="queryParams.tenantIds" placeholder="请选择机构名称" prop="tenantIds" />
  7. <el-form-item label="出库状态" prop="status">
  8. <el-select v-model="queryParams.status" placeholder="请选择出库状态" clearable class="!w-160px">
  9. <el-option
  10. v-for="(item, index) in getStrDictOptions(DICT_TYPE.MATERIALS_TYPE_NANSHA)"
  11. :key="index"
  12. :label="item.label"
  13. :value="item.value"
  14. />
  15. </el-select>
  16. </el-form-item>
  17. <el-form-item label="出库日期" prop="dateRange">
  18. <el-date-picker
  19. v-model="queryParams.dateRange"
  20. type="daterange"
  21. range-separator="至"
  22. start-placeholder="开始日期"
  23. end-placeholder="结束日期"
  24. value-format="YYYY-MM-DD"
  25. :unlink-panels="true"
  26. />
  27. </el-form-item>
  28. <el-form-item label="出库单号" prop="orderNo">
  29. <el-input v-model="queryParams.orderNo" placeholder="请输入出库单号" clearable class="!w-240px" />
  30. </el-form-item>
  31. <el-form-item>
  32. <el-button type="primary" @click="handleSearch">搜索</el-button>
  33. <el-button @click="handleReset">重置</el-button>
  34. </el-form-item>
  35. </el-form>
  36. </el-card>
  37. <!-- 操作按钮和表格 -->
  38. <el-card shadow="never" class="mt-4">
  39. <div class="mb-4">
  40. <el-button v-hasPermi="['warehouses:materialsOut:add']" type="primary" plain @click="handleAdd"><Icon icon="ep:plus" class="mr-5px" />新增</el-button>
  41. <el-button v-hasPermi="['warehouses:materialsOut:import']" type="success" @click="openImport"><Icon icon="ep:download" class="mr-5px" />导入</el-button>
  42. <el-button v-hasPermi="['warehouses:materialsOut:export']" type="primary" plain @click="openBatchExport"><Icon icon="ep:upload" class="mr-5px" />批量导出</el-button>
  43. </div>
  44. <el-table :data="tableData" v-loading="loading" :header-cell-style="tableHeaderColor">
  45. <el-table-column prop="orderNo" label="出库单号" align="center" width="280" />
  46. <el-table-column prop="orderDate" label="出库日期" align="center" width="120" />
  47. <el-table-column prop="status" label="出库状态" align="center" width="110">
  48. <template #default="{ row }">
  49. <el-tag :type="getStrDictOptions(DICT_TYPE.MATERIALS_TYPE_NANSHA)?.find(item => item.value == row.status)?.colorType || 'info'">{{ getStrDictOptions(DICT_TYPE.MATERIALS_TYPE_NANSHA)?.find(item => item.value == row.status)?.label || '-' }}</el-tag>
  50. </template>
  51. </el-table-column>
  52. <el-table-column prop="outDeptName" label="领用部门" align="center" width="140" />
  53. <el-table-column prop="outUser" label="领用人" align="center" width="120" />
  54. <el-table-column prop="outReason" label="出库原因" align="center" />
  55. <el-table-column prop="remark" label="备注" align="center" />
  56. <el-table-column label="操作" align="center" width="200">
  57. <template #default="{ row }">
  58. <el-button link type="primary" @click="handleView(row)">查看</el-button>
  59. <el-button v-hasPermi="['warehouses:materialsOut:edit']" link type="primary" @click="handleEdit(row)">编辑</el-button>
  60. <el-button v-hasPermi="['warehouses:materialsOut:export']" link type="success" @click="handleExport(row)">导出</el-button>
  61. <el-button v-hasPermi="['warehouses:materialsOut:print']" link type="primary" @click="handlePrint(row)">打印</el-button>
  62. <el-button v-hasPermi="['warehouses:materialsOut:delete']" link type="danger" @click="handleDelete(row)">删除</el-button>
  63. </template>
  64. </el-table-column>
  65. </el-table>
  66. <el-pagination
  67. class="mt-4"
  68. :current-page="queryParams.pageNo"
  69. :page-size="queryParams.pageSize"
  70. :total="total"
  71. layout="total, sizes, prev, pager, next, jumper"
  72. @size-change="handleSizeChange"
  73. @current-change="handleCurrentChange"
  74. />
  75. </el-card>
  76. <MaterialsOutDialog
  77. v-model="dialogVisible"
  78. :mode="dialogMode"
  79. :form-data="form"
  80. :department-options="departmentOptions"
  81. :material-options="materialOptions"
  82. @refresh="getTableData"
  83. />
  84. <Print ref="printRef" />
  85. <!-- 导入弹窗(复用 system/user 的 ImportFile 组件) -->
  86. <Import ref="importRef" :config="importConfig" @success="handleImportSuccess" />
  87. <!-- 批量导出弹窗 -->
  88. <el-dialog v-model="batchExportVisible" title="批量导出" width="460px" append-to-body>
  89. <el-form label-width="90px">
  90. <el-form-item label="导出日期">
  91. <el-date-picker
  92. v-model="batchExportRange"
  93. type="daterange"
  94. range-separator="至"
  95. start-placeholder="开始日期"
  96. end-placeholder="结束日期"
  97. value-format="YYYY-MM-DD"
  98. :unlink-panels="true"
  99. class="!w-full"
  100. />
  101. </el-form-item>
  102. </el-form>
  103. <div class="text-12px text-gray-500">
  104. 默认导出本月数据,导出所选日期范围内的出库单明细(一条物资一行)。
  105. </div>
  106. <template #footer>
  107. <el-button @click="batchExportVisible = false">取消</el-button>
  108. <el-button type="primary" :loading="batchExportLoading" @click="handleBatchExport">导出</el-button>
  109. </template>
  110. </el-dialog>
  111. </div>
  112. </template>
  113. <script setup>
  114. import { onMounted, reactive, ref } from 'vue'
  115. import { ElMessage } from 'element-plus'
  116. import { useUserStore } from '@/store/modules/user'
  117. import { materialIoPage, materialIoInboundBatchList, getMaterialOutboundDetail, materialIoDelete, exportMaterialOutbound } from '@/api/material/stockInAndOut'
  118. import { handleTree } from '@/utils/tree'
  119. import * as DeptApi from '@/api/system/dept'
  120. import { getStrDictOptions, DICT_TYPE } from '@/utils/dict'
  121. import download from '@/utils/download'
  122. import Import from '@/components/ImportFile/index.vue'
  123. import { exportMaterialsOutBatch } from '../batchExportSheet'
  124. const MaterialsOutDialog = defineAsyncComponent(() => import('./components/MaterialsOutDialog.vue'))
  125. const Print = defineAsyncComponent(() => import('./components/Print.vue'))
  126. const userStore = useUserStore()
  127. const tableHeaderColor = () => {
  128. return {
  129. background: '#F5F7FA',
  130. color: '#606266',
  131. fontWeight: '600',
  132. }
  133. }
  134. // 搜索
  135. const queryParams = reactive({
  136. pageNo: 1,
  137. pageSize: 10,
  138. tenantIds: userStore.orgTenantId,
  139. status: '',
  140. dateRange: [new Date(new Date().setMonth(new Date().getMonth() - 1)).toISOString().split('T')[0], new Date().toISOString().split('T')[0]],
  141. orderNo: '',
  142. })
  143. const total = ref(0)
  144. // 部门下拉
  145. const departmentOptions = ref([])
  146. // 出库物资
  147. const materialOptions = ref([])
  148. // 表格
  149. const tableData = ref([])
  150. const loading = ref(false)
  151. // 弹窗
  152. const dialogVisible = ref(false)
  153. const dialogMode = ref('add')
  154. const printRef = ref(null)
  155. const initialForm = {
  156. id: null,
  157. bizType: 'OUT',
  158. orderDate: new Date().toISOString().split('T')[0],
  159. outDept:'',
  160. outDeptId:null,
  161. outUser:'',
  162. outReason:'',
  163. remark: '',
  164. auditResult: '',
  165. auditor: '',
  166. auditTime: '',
  167. auditRemark: '',
  168. items: [],
  169. }
  170. const form = reactive({ ...initialForm })
  171. // 导入(复用 ImportFile 组件)
  172. const importRef = ref()
  173. const importConfig = reactive({
  174. title: '物资出库导入',
  175. // TODO: 替换成你的真实导入接口
  176. importUrl: '/material-io/outbound/import',
  177. excelTempName: '物资出库导入模板',
  178. // TODO: 替换成你的真实模板下载接口
  179. downloadUrl: '/material-io/outbound/import-template',
  180. desc: '物资出库',
  181. // TODO: 如果后端支持失败信息导出,填真实接口;不支持可留空
  182. failExportUrl: '',
  183. })
  184. const openImport = () => {
  185. importRef.value?.open?.()
  186. }
  187. const handleImportSuccess = () => {
  188. // 导入成功后刷新列表
  189. getTableData()
  190. }
  191. const getMaterialIoInboundBatchList = async()=>{
  192. try {
  193. const res = await materialIoInboundBatchList({
  194. tenantId: queryParams.tenantIds && queryParams.tenantIds.length ? queryParams.tenantIds[0] : undefined
  195. })
  196. materialOptions.value = res || []
  197. } catch (e) {
  198. console.error(e)
  199. ElMessage.error(e?.message || '获取入库单(批次)列表失败')
  200. }
  201. }
  202. // 获取表格数据(分页接口,bizType=OUT)
  203. const getTableData = async () => {
  204. loading.value = true
  205. try {
  206. const params = {
  207. pageNo: queryParams.pageNo,
  208. pageSize: queryParams.pageSize,
  209. tenantIds: queryParams.tenantIds?.length ? queryParams.tenantIds : undefined,
  210. bizType: 'OUT',
  211. status: queryParams.status === '' ? undefined : queryParams.status,
  212. orderNo: queryParams.orderNo || undefined,
  213. orderDate:
  214. Array.isArray(queryParams.dateRange) && queryParams.dateRange.length === 2
  215. ? queryParams.dateRange
  216. : undefined,
  217. }
  218. const res = await materialIoPage(params)
  219. tableData.value = res.list || []
  220. total.value = res.total || 0
  221. } catch (e) {
  222. console.error(e)
  223. tableData.value = []
  224. total.value = 0
  225. } finally {
  226. loading.value = false
  227. }
  228. }
  229. onMounted(() => {
  230. getTableData()
  231. })
  232. const handleSearch = () => {
  233. queryParams.pageNo = 1
  234. getTableData()
  235. }
  236. const handleReset = () => {
  237. queryParams.status = ''
  238. queryParams.dateRange = [new Date(new Date().setMonth(new Date().getMonth() - 1)).toISOString().split('T')[0], new Date().toISOString().split('T')[0]]
  239. queryParams.orderNo = ''
  240. queryParams.tenantIds = userStore.orgTenantId
  241. queryParams.pageNo = 1
  242. getTableData()
  243. }
  244. const handleSizeChange = (size) => {
  245. queryParams.pageSize = size
  246. getTableData()
  247. }
  248. const handleCurrentChange = (page) => {
  249. queryParams.pageNo = page
  250. getTableData()
  251. }
  252. const handleAdd = async () => {
  253. // 只能选择一个机构
  254. if(queryParams.tenantIds.length == 0 || queryParams.tenantIds.length > 1){
  255. ElMessage.error('新增只能选择一个机构')
  256. return
  257. }
  258. getMaterialIoInboundBatchList()
  259. departmentOptions.value = handleTree(await DeptApi.getSimpleDeptList())
  260. dialogMode.value = 'add'
  261. Object.assign(form, { ...initialForm, orderDate: new Date().toISOString().split('T')[0], items: [], tenantId:queryParams.tenantIds ? queryParams.tenantIds[0] : undefined })
  262. dialogVisible.value = true
  263. }
  264. const handleView = async(row) => {
  265. dialogMode.value = 'view'
  266. try {
  267. const res = await getMaterialOutboundDetail(row.id)
  268. const data = res || {}
  269. const params = {
  270. id: data.id || undefined,
  271. bizType: 'OUT',
  272. orderDate: data.orderDate,
  273. outDept: data.outDept || undefined,
  274. outUser: data.outUser || undefined,
  275. outReason: data.outReason || undefined,
  276. outDept: data.outDeptName || undefined,
  277. outDeptId: data.outDeptId,
  278. remark: data.remark || undefined,
  279. tenantId: data.tenantId,
  280. orderNo: data.orderNo,
  281. items: (data.items || []).map(item => {
  282. return {
  283. ...item,
  284. inUnitPrice: item.inUnitPrice || 0,
  285. }
  286. }),
  287. auditResult: data.auditResult || undefined,
  288. auditor: data.auditor || undefined,
  289. auditTime: data.auditTime || undefined,
  290. auditRemark: data.auditRemark || undefined,
  291. }
  292. Object.assign(form, JSON.parse(JSON.stringify(params || {})))
  293. dialogVisible.value = true
  294. } catch (e) {
  295. console.error(e)
  296. ElMessage.error(e?.message || '获取详情失败')
  297. }
  298. dialogVisible.value = true
  299. }
  300. const handleEdit = async(row) => {
  301. // 只能选择一个机构
  302. if(queryParams.tenantIds.length == 0 || queryParams.tenantIds.length > 1){
  303. ElMessage.error('编辑只能选择一个机构')
  304. return
  305. }
  306. getMaterialIoInboundBatchList()
  307. departmentOptions.value = handleTree(await DeptApi.getSimpleDeptList())
  308. dialogMode.value = 'edit'
  309. try {
  310. const res = await getMaterialOutboundDetail(row.id)
  311. const data = res || {}
  312. const params = {
  313. id: data.id || undefined,
  314. bizType: 'OUT',
  315. orderDate: data.orderDate,
  316. outDept: data.outDeptName || undefined,
  317. outDeptId: data.outDeptId,
  318. outUser: data.outUser || undefined,
  319. outReason: data.outReason || undefined,
  320. remark: data.remark || undefined,
  321. tenantId: data.tenantId,
  322. orderNo: data.orderNo,
  323. items: (data.items || []).map(item => {
  324. return {
  325. ...item,
  326. inboundItemId:item.refInboundItemId,
  327. availableQty: item.latestAvailableQty || 0,
  328. inUnitPrice: item.inUnitPrice || 0,
  329. }
  330. }),
  331. }
  332. Object.assign(form, JSON.parse(JSON.stringify(params || {})))
  333. console.log(form)
  334. dialogVisible.value = true
  335. } catch (e) {
  336. console.error(e)
  337. ElMessage.error(e?.message || '获取详情失败')
  338. }
  339. dialogVisible.value = true
  340. }
  341. const handleExport = async(row) => {
  342. try {
  343. const res = await exportMaterialOutbound(row.id)
  344. download.excel(res, '出库单据明细.xls')
  345. } catch (e) {
  346. console.error(e)
  347. ElMessage.error(e?.message || '导出失败')
  348. }
  349. }
  350. /** 导出日期转字符串 */
  351. const formatDateStr = (date) => {
  352. const y = date.getFullYear()
  353. const m = String(date.getMonth() + 1).padStart(2, '0')
  354. const d = String(date.getDate()).padStart(2, '0')
  355. return `${y}-${m}-${d}`
  356. }
  357. /** 默认导出本月:本月 1 号 ~ 今天 */
  358. const currentMonthRange = () => {
  359. const now = new Date()
  360. return [`${now.getFullYear()}-${String(now.getMonth() + 1).padStart(2, '0')}-01`, formatDateStr(now)]
  361. }
  362. // 批量导出
  363. const BATCH_EXPORT_PAGE_SIZE = 10000
  364. const batchExportVisible = ref(false)
  365. const batchExportLoading = ref(false)
  366. const batchExportRange = ref(currentMonthRange())
  367. const openBatchExport = () => {
  368. batchExportRange.value = currentMonthRange()
  369. batchExportVisible.value = true
  370. }
  371. /** 按导出日期拉取出库单(pageSize 取大值,并按 total 兜底翻页) */
  372. const fetchOutboundOrders = async (orderDate) => {
  373. const all = []
  374. let pageNo = 1
  375. let total = 0
  376. while (pageNo <= 50) {
  377. const res = await materialIoPage({
  378. pageNo,
  379. pageSize: BATCH_EXPORT_PAGE_SIZE,
  380. tenantIds: queryParams.tenantIds?.length ? queryParams.tenantIds : undefined,
  381. bizType: 'OUT',
  382. orderDate,
  383. })
  384. const list = res?.list || []
  385. all.push(...list)
  386. total = res?.total || 0
  387. // 已取完(或后端单页有上限时继续翻页)
  388. if (!list.length || list.length < BATCH_EXPORT_PAGE_SIZE || all.length >= total) break
  389. pageNo++
  390. }
  391. return all
  392. }
  393. /** 列表未返回明细时,按单号补查详情 */
  394. const fetchOrderItems = async (orders) => {
  395. const itemsMap = new Map()
  396. const needIds = orders.filter((order) => !(order.items || []).length && order.id).map((order) => order.id)
  397. const CHUNK_SIZE = 5
  398. let failed = false
  399. for (let i = 0; i < needIds.length; i += CHUNK_SIZE) {
  400. if (failed) break
  401. const chunk = needIds.slice(i, i + CHUNK_SIZE)
  402. const details = await Promise.all(
  403. chunk.map(async (id) => {
  404. try {
  405. return await getMaterialOutboundDetail(id)
  406. } catch {
  407. failed = true
  408. return null
  409. }
  410. })
  411. )
  412. chunk.forEach((id, index) => itemsMap.set(id, details[index]?.items || []))
  413. }
  414. return itemsMap
  415. }
  416. /** 批量导出 */
  417. const handleBatchExport = async () => {
  418. const range = batchExportRange.value
  419. if (!range || range.length !== 2) {
  420. ElMessage.warning('请选择导出日期')
  421. return
  422. }
  423. batchExportLoading.value = true
  424. try {
  425. const orders = await fetchOutboundOrders(range)
  426. if (!orders.length) {
  427. ElMessage.warning('所选日期范围内没有出库单数据')
  428. return
  429. }
  430. const itemsMap = await fetchOrderItems(orders)
  431. const rows = []
  432. orders.forEach((order) => {
  433. const items = (order.items || []).length ? order.items : itemsMap.get(order.id) || []
  434. items.forEach((item) => {
  435. rows.push({
  436. orderNo: order.orderNo,
  437. orderDate: order.orderDate,
  438. outDeptName: order.outDeptName,
  439. outUser: order.outUser,
  440. outReason: order.outReason,
  441. remark: order.remark,
  442. storeName: item.refInStoreName || item.storeName,
  443. refInOrderNo: item.refInOrderNo,
  444. materialNumber: item.materialNumber,
  445. materialName: item.materialName,
  446. materialUnit: item.materialUnit,
  447. produceDate: item.produceDate,
  448. quantity: item.quantity ?? item.outQty,
  449. inUnitPrice: item.inUnitPrice,
  450. saleUnitPrice: item.saleUnitPrice,
  451. amount: item.amount,
  452. })
  453. })
  454. })
  455. if (!rows.length) {
  456. ElMessage.warning('所选日期范围内的出库单没有明细数据')
  457. return
  458. }
  459. exportMaterialsOutBatch(rows, `出库单明细_${range[0]}_${range[1]}`)
  460. batchExportVisible.value = false
  461. } catch (e) {
  462. console.error(e)
  463. ElMessage.error(e?.message || '导出失败')
  464. } finally {
  465. batchExportLoading.value = false
  466. }
  467. }
  468. // 删除
  469. const handleDelete = (row) => {
  470. ElMessageBox.confirm(`确定要删除入库单号为 "${row.orderNo}" 的入库单吗?`, '提示', {
  471. confirmButtonText: '确定',
  472. cancelButtonText: '取消',
  473. type: 'warning',
  474. })
  475. .then(async() => {
  476. // 使用materialIoDelete
  477. await materialIoDelete(row.id)
  478. ElMessage.success('删除成功')
  479. getTableData()
  480. })
  481. .catch(() => {})
  482. }
  483. const handlePrint = (row) => {
  484. printRef.value.open(row.id)
  485. }
  486. </script>
  487. <style scoped>
  488. .mt-4 {
  489. margin-top: 16px;
  490. }
  491. .mb-4 {
  492. margin-bottom: 16px;
  493. }
  494. </style>