The open source simple and complete warehouse management system is derived from our many years of experience in implementing erp projects. We stripped the original commercial system wms function and opened it up for free, hoping to help the majority of small and medium-sized enterprises. At present, the system supports cross-platform。
<!-- UserManagement Setting Import Dialog -->
<template>
<v-dialog v-model="isShow" width="70%" transition="dialog-top-transition" :persistent="true">
<template #default>
<v-card>
<v-toolbar color="white" :title="`${$t('system.page.import')}`"></v-toolbar>
<v-card-text>
<div class="mb-4">
<tooltip-btn icon="mdi-plus" :tooltip-text="$t('system.page.chooseFile')" size="x-small" @click="method.chooseFile"></tooltip-btn>
<tooltip-btn
icon="mdi-export-variant"
:tooltip-text="$t('system.page.exportTemplate')"
size="x-small"
@click="method.exportTemplate"
></tooltip-btn>
<input v-show="false" id="open" ref="uploadExcel" type="file" accept=".xls, .xlsx" @change="method.readExcel" />
</div>
<vxe-table
ref="xTable"
:column-config="{ minWidth: '100px' }"
:data="data.importData"
:height="SYSTEM_HEIGHT.SELECT_TABLE"
:edit-config="{ trigger: 'click', mode: 'cell' }"
:edit-rules="data.validRules"
:export-config="{}"
align="center"
>
<template #empty>
{{ i18n.global.t('system.page.noData') }}
</template>
<vxe-column type="seq" width="60"></vxe-column>
<vxe-column field="operate" width="60" :title="$t('system.page.operate')" :resizable="false">
<template #default="{ row }">
<tooltip-btn
:flat="true"
icon="mdi-delete-outline"
:tooltip-text="$t('system.page.delete')"
:icon-color="errorColor"
@click="method.deleteRow(row)"
></tooltip-btn>
</template>
</vxe-column>
<vxe-column field="user_num" :title="$t('base.userManagement.user_num')"></vxe-column>
<vxe-column field="user_name" :title="$t('base.userManagement.user_name')"></vxe-column>
<vxe-column field="contact_tel" :title="$t('base.userManagement.contact_tel')"></vxe-column>
<vxe-column field="user_role" :title="$t('base.userManagement.user_role')"></vxe-column>
<vxe-column field="sex" :title="$t('base.userManagement.sex')"></vxe-column>
</vxe-table>
</v-card-text>
<v-card-actions class="justify-end">
<v-btn variant="text" @click="method.closeDialog">{{ $t('system.page.close') }}</v-btn>
<v-btn color="primary" variant="text" @click="method.submit">{{ $t('system.page.submit') }}</v-btn>
</v-card-actions>
</v-card>
</template>
</v-dialog>
</template>
<script lang="ts" setup>
import { reactive, computed, ref, watch } from 'vue'
import { VxeTablePropTypes } from 'vxe-table'
import * as XLSX from 'xlsx'
import i18n from '@/languages/i18n'
import { excelImport } from '@/api/base/userManagement'
import { hookComponent } from '@/components/system/index'
import { SYSTEM_HEIGHT, errorColor } from '@/constant/style'
import tooltipBtn from '@/components/tooltip-btn.vue'
import { ImportVO } from '@/types/Base/UserManagement'
import { exportData } from '@/utils/exportTable'
import { formatString } from '@/utils/format/formatSystem'
const emit = defineEmits(['close', 'saveSuccess'])
const uploadExcel = ref()
const xTable = ref()
const props = defineProps<{
showDialog: boolean
}>()
const isShow = computed(() => props.showDialog)
const data = reactive({
importData: ref<Array<ImportVO>>([]),
validRules: ref<VxeTablePropTypes.EditRules>({})
})
const method = reactive({
initForm: () => {
data.importData = []
},
closeDialog: () => {
emit('close')
},
submit: async () => {
const isValid = method.valid()
if (!isValid) {
return
}
const $table = xTable.value
// It must be use 'getTableData()' to get all datas with table because it will delete row sometimes.
const importData = JSON.parse(JSON.stringify($table.getTableData().fullData))
for (const item of importData) {
let sex = 'male'
if (['男', '女', 'Male', 'Female'].includes(item.sex)) {
switch (item.sex) {
case '男':
case 'Male':
sex = 'male'
break
case '女':
case 'Female':
sex = 'female'
break
}
}
item.sex = sex
}
const { data: res } = await excelImport(importData)
if (!res.isSuccess) {
hookComponent.$message({
type: 'error',
content: res.errorMessage
})
return
}
hookComponent.$message({
type: 'success',
content: `${ i18n.global.t('system.page.submit') }${ i18n.global.t('system.tips.success') }`
})
emit('saveSuccess')
},
valid: () => {
const $table = xTable.value
const importData = $table.getTableData().fullData
if (importData.length <= 0) {
hookComponent.$message({
type: 'error',
content: `${ i18n.global.t('system.tips.detailLengthIsZero') }`
})
return false
}
return true
},
chooseFile: async () => {
uploadExcel.value.value = ''
uploadExcel.value.click()
},
readExcel: async (evnt: any) => {
const files = evnt.target.files
if (files.length <= 0) {
return false
}
const file = files[0]
const fileReader = new FileReader()
fileReader.onload = (ev: ProgressEvent<FileReader>) => {
const fileData = ev?.target?.result
if (fileData) {
const workbook = XLSX.read(fileData, { type: 'binary' })
const wsname = workbook.SheetNames[0]
let ws = XLSX.utils.sheet_to_json(workbook.Sheets[wsname])
let str = JSON.stringify(ws)
str = str.replace(/(/g, '(')
str = str.replace(/)/g, ')')
ws = JSON.parse(str)
data.importData = []
ws.forEach((value: any, index: number, ws: any) => {
data.importData.push({
user_num: formatString(ws[index][i18n.global.t('base.userManagement.user_num')]),
user_name: formatString(ws[index][i18n.global.t('base.userManagement.user_name')]),
contact_tel: formatString(ws[index][i18n.global.t('base.userManagement.contact_tel')]),
user_role: formatString(ws[index][i18n.global.t('base.userManagement.user_role')]),
sex: formatString(ws[index][i18n.global.t('base.userManagement.sex')]),
is_valid: true
})
})
}
}
fileReader.readAsBinaryString(file)
},
exportTemplate: () => {
const $table = xTable.value
exportData({
table: $table,
filename: i18n.global.t('router.sideBar.userManagement'),
mode: 'header',
columnFilterMethod({ column }: any) {
return !['checkbox', 'seq'].includes(column?.type) && !['operate'].includes(column?.field)
}
})
},
deleteRow: (row: ImportVO) => {
hookComponent.$dialog({
content: i18n.global.t('system.tips.beforeDeleteDetailMessage'),
handleConfirm: async () => {
if (row) {
const $table = xTable.value
$table.remove(row)
}
}
})
}
})
watch(
() => isShow.value,
(val) => {
if (val) {
method.initForm()
}
}
)
</script>
<style scoped lang="less">
.v-form {
div {
margin-bottom: 7px;
}
}
</style>