mes-dacheng-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="Search"
			    @click="handleShowAdd"
			  >新增</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
              show-overflow-tooltip="true"
              :row-style="{ height: '20px' }"
              :cell-style="{ padding: '0px' }"
              :header-row-style="{ height: '20px' }"
              :header-cell-style="{ padding: '0px' }"
              @selection-change="handleSelectionChange"
              @row-dblclick="doubleClick"
			  @row-click="Click"
            >
              <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"
              />

            </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 ,createData} 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()
  }
}
// 新增数据
const handleShowAdd = async () => {
  const res = await getDetail({ wgjs_rq: value1.value, wgjs_bh1: value2.value });
  if (res.code === 0) {
	type.value='add'
    Object.assign(detailData, res.data);
	dialogFormVisible.value = true
  }
};
// 搜索
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 value1=ref()
const value2=ref()
// 单击表格操作
async function Click(row, column, event) {
  const { wgjs_rq, wgjs_bh1 } = row
  value1.value=wgjs_rq
  value2.value=wgjs_bh1
  // console.log(wgjs_rq)
  // console.log(wgjs_bh1)
  // const res = await getDetail({ wgjs_rq, wgjs_bh1 })
  // if (res.code === 0) {
  //   Object.assign(detailData, res.data)
  //   dialogFormVisible.value = true
  // }
}
// 更新数据
const enterDialog = async() => {
	
	if (type.value === 'update') {
	  updateDetailData()
	} else if (type.value === 'add') {
	  addDetailData()
	}
	
  
}
//新增
const addDetailData = async() => {
  const restoredData = {
    wgjs_rq: detailData.wgjs_rq,
	wgjs_bh1:detailData.wgjs_bh1,
	wgjs_js1:detailData.wgjs_js1,
	wgjs_yy1:detailData.wgjs_yy1,
	wgjs_冲定额1:detailData.wgjs_冲定额1,
	
	wgjs_bh2:detailData.wgjs_bh2,
	wgjs_js2:detailData.wgjs_js2,
	wgjs_yy2:detailData.wgjs_yy2,
	wgjs_冲定额2:detailData.wgjs_冲定额2,
	
	wgjs_bh3:detailData.wgjs_bh3,
	wgjs_js3:detailData.wgjs_js3,
	wgjs_yy3:detailData.wgjs_yy3,
	wgjs_冲定额3:detailData.wgjs_冲定额3,
	
	wgjs_bh4:detailData.wgjs_bh4,
	wgjs_js4:detailData.wgjs_js4,
	wgjs_yy4:detailData.wgjs_yy4,
	wgjs_冲定额4:detailData.wgjs_冲定额4,
	
	wgjs_bh5:detailData.wgjs_bh5,
	wgjs_js5:detailData.wgjs_js5,
	wgjs_yy5:detailData.wgjs_yy5,
	wgjs_冲定额5:detailData.wgjs_冲定额5,
	
	wgjs_bh6:detailData.wgjs_bh6,
	wgjs_js6:detailData.wgjs_js6,
	wgjs_yy6:detailData.wgjs_yy6,
	wgjs_冲定额6:detailData.wgjs_冲定额6,
  }
  console.log(restoredData)
  const res = await createData(restoredData)
  console.log(res)
  // console.log(res)
  // if (res.code === 0) {
  //   ElMessage({
  //     type: 'success',
  //     message: '新增成功',
  //   })
  //   dialogFormVisible.value = false
  // }
}
//修改
const updateDetailData = 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>