mes-admin-backend-ui/src/view/performance/08-timesheet/index.vue

<template>
  <div>
    <el-container>

      <!-- 左侧树形结构 -->
      <el-scrollbar max-height="75vh">
        <el-aside>
          <div class="JKWTree-tree">
            <h3>计件工计时单维护</h3>
            <el-tree
              :data="treeData"
              :props="defaultProps"
              highlight-current="true"
              @node-click="handleNodeClick"
            />
          </div>
        </el-aside>
      </el-scrollbar>

      <el-container>
        <el-main>
          <!-- 按钮区域 -->
          <div class="gva-table-box">
            <div class="gva-btn-list">
              <el-row :span="6">
                <el-input
                  v-model="searchInfo"
                  placeholder="输入员工编号"
                />
              </el-row>
              <el-button
                type="primary"
                :icon="Search"
                @click="onSearch"
              >搜索</el-button>
              <el-button
                type="primary"
                :icon="Refresh"
              >重置</el-button>
              <div style="margin-left: auto;">
                <el-button
                  type="primary"
                  :icon="Download"
                  @click="exportExcel"
                >导出到Excel</el-button>
              </div>
            </div>
            <!-- 数据展示 -->
            <el-table
              ref="multipleTable"
              style="width: 100%"
              tooltip-effect="dark"
              :data="tableData"
              row-key="ID"
              highlight-current-row
              border
              :row-style="{ height: '20px' }"
              :cell-style="{ padding: '0px' }"
              :header-row-style="{ height: '20px' }"
              :header-cell-style="{ padding: '0px' }"
              @selection-change="handleSelectionChange"
              @row-dblclick="doubleClick"
            >
              <el-table-column
                type="selection"
                width="55"
              />
              <!-- 循环渲染列 -->
              <el-table-column
                v-for=" column in tableColumns "
                :key="column.prop"
                :prop="column.prop"
                :label="column.label"
                :width="column.width"
                show-overflow-tooltip="true"
              />

            </el-table>
            <!-- 分页 -->
            <div class="gva-pagination">
              <el-pagination
                v-model:current-page="page"
                v-model:page-size="limit"
                layout="total, sizes, prev, pager, next, jumper"
                :page-sizes="[10, 30, 50, 100]"
                :total="total"
                @current-change="handleCurrentChange"
                @size-change="handleSizeChange"
              />
            </div>
          </div>
          <!-- 弹出框 -->
          <el-dialog
            v-model="dialogFormVisible"
            :before-close="closeDialog"
            title="计件工计时单维护"
            destroy-on-close
            width="800px"
          >
            <!-- <el-scrollbar height="500px"> -->
            <el-form
              ref="elFormRef"
              :model="detailData"
              label-position="left"
              :rules="rule"
            >

              <!-- 日期 -->
              <el-row>
                <el-form-item
                  label="日期"
                  prop="name"
                >
                  <el-input
                    v-model="detailData.wgjs_rq"
                    :clearable="true"
                    style="width: 100px;"
                  />
                </el-form-item>
              </el-row>

              <!-- 标题栏 -->
              <el-row :gutter="10">
                <el-col :span="3">
                  <span>员工编号</span>
                </el-col>
                <el-col :span="3">
                  <span>员工姓名</span>
                </el-col>
                <el-col :span="3">
                  <span>计时</span>
                </el-col>
                <el-col :span="12">
                  <span>原因备注</span>
                </el-col>
                <el-col :span="3">
                  <span>冲月定额</span>
                </el-col>
              </el-row>

              <!-- 员工1 -->
              <el-row
                :gutter="5"
                style="margin-top: 10px;"
              >
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_bh1"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.name1"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_js1"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="12">
                  <el-input
                    v-model="detailData.wgjs_yy1"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_冲定额1"
                    :clearable="true"
                  />
                </el-col>
              </el-row>

              <!-- 员工2 -->
              <el-row
                :gutter="5"
                style="margin-top: 10px;"
              >
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_bh2"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.name2"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_js2"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="12">
                  <el-input
                    v-model="detailData.wgjs_yy2"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_冲定额2"
                    :clearable="true"
                  />
                </el-col>
              </el-row>

              <!-- 员工3 -->
              <el-row
                :gutter="5"
                style="margin-top: 10px;"
              >
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_bh3"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.name3"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_js3"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="12">
                  <el-input
                    v-model="detailData.wgjs_yy3"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_冲定额3"
                    :clearable="true"
                  />
                </el-col>
              </el-row>

              <!-- 员工4 -->
              <el-row
                :gutter="5"
                style="margin-top: 10px;"
              >
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_bh4"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.name4"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_js4"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="12">
                  <el-input
                    v-model="detailData.wgjs_yy4"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_冲定额4"
                    :clearable="true"
                  />
                </el-col>
              </el-row>

              <!-- 员工5 -->
              <el-row
                :gutter="5"
                style="margin-top: 10px;"
              >
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_bh5"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.name5"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_js5"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="12">
                  <el-input
                    v-model="detailData.wgjs_yy5"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_冲定额5"
                    :clearable="true"
                  />
                </el-col>
              </el-row>

              <!-- 员工6 -->
              <el-row
                :gutter="5"
                style="margin-top: 10px;"
              >
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_bh6"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.name6"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_js6"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="12">
                  <el-input
                    v-model="detailData.wgjs_yy6"
                    :clearable="true"
                  />
                </el-col>
                <el-col :span="3">
                  <el-input
                    v-model="detailData.wgjs_冲定额6"
                    :clearable="true"
                  />
                </el-col>
              </el-row>

            </el-form>

            <template #footer>
              <div class="dialog-footer">
                <el-button @click="closeDialog">取 消</el-button>
                <el-button
                  type="primary"
                  @click="enterDialog"
                >确 定</el-button>
              </div>
            </template>
          </el-dialog>

        </el-main>
      </el-container>
    </el-container>

  </div>
</template>

<script setup>
import {
  createCompany,
  deleteCompany,
  deleteCompanyByIds,
  updateCompany,
  findCompany,
  getCompanyList
} from '@/api/company'

// 全量引入格式化工具 请按需保留
import { getDictFunc, formatDate, formatBoolean, filterDict, ReturnArrImg, onDownloadFile } from '@/utils/format'
import { ElMessage, ElMessageBox } from 'element-plus'
import { Search, Refresh, Download } from '@element-plus/icons-vue'
import { ref, reactive, onMounted, onBeforeMount } from 'vue'
import { getSide, getTable, getDetail, updateData, getLocate } from '@/api/mes_api_gty/timesheet'

defineOptions({
  name: '08Timesheet'
})

// 侧边栏数据请求
const treeData = reactive([])
const getSideData = async() => {
  const response = await getSide()
  if (response.code === 0) {
    const transformedData = response.data.map(item => ({
      label: item.date,
      params: {
        date: item.date.substring(0, 4) + '-' + item.date.substring(4),
      },
    }))
    treeData.splice(0, treeData.length, ...transformedData)
  }
}
getSideData()

// 验证规则
const rule = reactive({
})

const elFormRef = ref()
const elSearchFormRef = ref()

// ============== 表格页面 ==============
const tableColumns = [
  { prop: 'wgjs_rq', label: '日期', width: 100 },
  { prop: 'wgjs_bh1', label: '员工编号1', width: 100 },
  { prop: 'name1', label: '姓名1', width: 100 },
  { prop: 'department', label: '所在部门', width: 100 },
  { prop: 'wgjs_js1', label: '计时1', width: 100 },
  { prop: 'wgjs_yy1', label: '原因1', width: 100 },
  { prop: 'wgjs_bh2', label: '员工编号2', width: 100 },
  { prop: 'name2', label: '姓名2', width: 100 },
  { prop: 'wgjs_js2', label: '计时2', width: 100 },
  { prop: 'wgjs_yy2', label: '原因2', width: 100 },
  { prop: 'wgjs_bh3', label: '员工编号3', width: 100 },
  { prop: 'name3', label: '姓名3', width: 100 },
  { prop: 'wgjs_js3', label: '计时3', width: 100 },
  { prop: 'wgjs_yy3', label: '原因3', width: 100 },
  { prop: 'wgjs_bh4', label: '员工编号4', width: 100 },
  { prop: 'name4', label: '姓名4', width: 100 },
  { prop: 'wgjs_js4', label: '计时4', width: 100 },
  { prop: 'wgjs_yy4', label: '原因4', width: 100 },
  { prop: 'wgjs_bh5', label: '员工编号5', width: 100 },
  { prop: 'name5', label: '姓名5', width: 100 },
  { prop: 'wgjs_js5', label: '计时5', width: 100 },
  { prop: 'wgjs_yy5', label: '原因5', width: 100 },
  { prop: 'wgjs_bh6', label: '员工编号6', width: 100 },
  { prop: 'name6', label: '姓名6', width: 100 },
  { prop: 'wgjs_js6', label: '计时6', width: 100 },
  { prop: 'wgjs_yy6', label: '原因6', width: 100 },
]
const tableData = reactive([])
const page = ref(1)
const total = ref(0)
const limit = ref(10)
const searchInfo = ref('')
const params = {
  date: '',
  search: '',
  type: '',
}

const getTableData = async(params) => {
  const response = await getTable(params)
  if (response.code === 0) {
    total.value = response.data.total
    tableData.splice(0, tableData.length, ...response.data.rows)
  }
}

// 搜索
const getLocateData = async(params) => {
  const res = await getLocate(params)
  if (res.code === 0) {
    total.value = res.data.total
    tableData.splice(0, tableData.length, ...res.data.rows)
  }
}

// 分页设置
const handleSizeChange = () => {
  switch (params.type) {
    case 'getTableData':
      getTableData({ date: params.date, page: page.value.toString(), limit: limit.value.toString() })
      break
    case 'getLocateData':
      getLocateData({ date: params.date.replace('-', ''),
        search: params.search,
        page: page.value.toString(),
        limit: limit.value.toString() })
      break
    default:
      break
  }
}

// 页面跳转
const handleCurrentChange = () => {
  switch (params.type) {
    case 'getTableData':
      getTableData({ date: params.date, page: page.value.toString(), limit: limit.value.toString() })
      break
    case 'getLocateData':
      getLocateData({ date: params.date.replace('-', ''),
        search: params.search,
        page: page.value.toString(),
        limit: limit.value.toString() })
      break
    default:
      break
  }
}

const handleNodeClick = (node, check) => {
  if (node.params) {
    params.date = node.params.date
    params.type = 'getTableData'
    page.value = 1
    handleCurrentChange()
  }
}

// 搜索
function onSearch() {
  params.search = searchInfo.value
  params.type = 'getLocateData'
  page.value = 1
  handleCurrentChange()
}

// ============== 详情页面 ==============
const detailData = reactive({})

// 行为控制标记（弹窗内部需要增还是改）
const type = ref('')
// 弹窗控制标记
const dialogFormVisible = ref(false)

// 双击表格操作
async function doubleClick(row, column, event) {
  type.value = 'update'
  const { wgjs_rq, wgjs_bh1 } = row
  const res = await getDetail({ wgjs_rq, wgjs_bh1 })
  if (res.code === 0) {
    Object.assign(detailData, res.data)
    dialogFormVisible.value = true
  }
}

// 更新数据
const enterDialog = async() => {
  const obj = detailData
  for (let i = 1; i <= 6; i++) {
    delete obj[`name${i}`]
  }
  const res = await updateData(obj)
  if (res.code === 0) {
    ElMessage({
      type: 'success',
      message: '更新成功'
    })
    params.type = 'getTableData'
    // page.value = 1
    handleCurrentChange()
    dialogFormVisible.value = false
  }
}

// 获取需要的字典 可能为空 按需保留
const setOptions = async() => {
}

// 获取需要的字典 可能为空 按需保留
setOptions()

// 多选数据
const multipleSelection = ref([])
// 多选
const handleSelectionChange = (val) => {
  multipleSelection.value = val
}

// 批量删除控制标记
const deleteVisible = ref(false)

// 多选删除
const onDelete = async() => {
  const ids = []
  if (multipleSelection.value.length === 0) {
    ElMessage({
      type: 'warning',
      message: '请选择要删除的数据'
    })
    return
  }
  multipleSelection.value &&
    multipleSelection.value.map(item => {
      ids.push(item.ID)
    })
  const res = await deleteCompanyByIds({ ids })
  if (res.code === 0) {
    ElMessage({
      type: 'success',
      message: '删除成功'
    })
    if (tableData.value.length === ids.length && page.value > 1) {
      page.value--
    }
    deleteVisible.value = false
    getTableData()
  }
}

// 更新行
const updateCompanyFunc = async(row) => {
  const res = await findCompany({ ID: row.ID })
  type.value = 'update'
  if (res.code === 0) {
    detailData.value = res.data.recompany
    dialogFormVisible.value = true
  }
}

// 关闭弹窗
const closeDialog = () => {
  dialogFormVisible.value = false
}

// 导出excel
function exportExcel() {
  console.log('导出到excel')
}

// 生命周期钩子
onMounted(() => {
})
</script>

<style scoped>
.JKWTree-container {
  display: flex;
}

.JKWTree-tree {
  width: 300px;
  background-color: #fff;
  padding: 10px;
  margin-right: 20px;
}

.JKWTree-tree h3 {
  font-size: 15px;
  font-weight: 700;
  margin: 10px 0;
}

.JKWTree-content {
  flex: 1;
}

/* 选中某行时的背景色 */
:deep(.el-table__body tr.current-row) > td {
  background: #ff80ff !important;
}
</style>