mes-sdai-admin-backend-ui/src/view/performance/yuangongrigongzi.vue

<template>
  <div>
    <!-- 左侧树形结构 -->
    <el-container>
      <!-- <el-aside width="250px">
        <div class="JKWTree-tree">
          <h3>包装工序产量维护</h3>
          <el-tree :data="treeData" :props="defaultProps" highlight-current="true"
            @node-click="handleNodeClick"></el-tree>
        </div>
      </el-aside> -->
	  
	  <layout-sider
	    :resize-directions="['right']"
	    :width="220"
	    style="margin-right: 10px;"
	  >
	    <div
	      class="JKWTree-tree"
	      style="height: 70vh;"
	    >
	      <h3>员工日工资查询</h3>
	      <el-tree
	        :data="treeData"
	        highlight-current
	        @node-click="handleNodeClick"
	      />
	    </div>
	  </layout-sider>

      <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" class="bt" @click="onSearch">搜索</el-button>
              <!-- <el-button type="primary" :icon="Refresh">重置</el-button> -->
			  <!-- <el-button type="primary" :icon="Search" class="bt" @click="onposition">定位</el-button> -->
			  <!-- <el-button type="primary" :icon="Search">查改</el-button> -->
			  <el-button type="primary"  class="bt" @click="handlePrint">员工计件明细</el-button>
              <div style="margin-left: auto;">
                <el-button type="primary" :icon="Download" class="bt" @click="exportExcel">导出到Excel(汇总)</el-button>
				<el-button type="primary" :icon="Download" class="bt" @click="exportExcel2">导出到Excel(明细)</el-button>
              </div>
            </div>
            <!-- 数据展示 -->
            <el-table ref="multipleTable" style="width: 100%;height: 40vh;" tooltip-effect="dark" :data="tableData" row-key="ID" 
              highlight-current-row="true" border @selection-change="handleSelectionChange" :show-overflow-tooltip="true"
			   :row-style="{ height: '20px' }" 
			   :cell-style="{ padding: '0px' }" :header-row-style="{ height: '20px' }"
			   :header-cell-style="{ padding: '0px' }" 
			   @row-click="ontable" @row-dblclick="doubleClick">
              <el-table-column type="selection" width="40" />
			  <el-table-column
			    v-for="column in tableCols1"
			    :key="column.prop"
			    :prop="column.prop"
			    :label="column.label"
			    :width="column.width"
			    show-overflow-tooltip="true"
			  				sortable
			  />  
            </el-table>
            <!-- 分页 -->
            <!-- <div class="gva-pagination">
              <el-pagination layout="total, sizes, prev, pager, next, jumper" :current-page="page" :page-size="limit"
                :page-sizes="[10, 30, 50, 100]" :total="total" @current-change="handleCurrentChange"
                @size-change="handleSizeChange" />
            </div> -->
          </div>
		  
		  
		  <div class="gva-table-box">
		    <!-- 数据展示 -->
		    <el-table ref="multipleTable2" style="width: 100%;height: 40vh;" tooltip-effect="dark" :data="tableData2" row-key="ID"
		      highlight-current-row="true" border 
			  :row-style="{ height: '20px' }"
			  :cell-style="{ padding: '0px' }" :header-row-style="{ height: '20px' }"
			  :header-cell-style="{ padding: '0px' }"
			  @selection-change="handleSelectionChange" 
			  :show-overflow-tooltip="true" 
			  @row-dblclick="doubleClick">
		      <el-table-column type="selection" width="40" />
		  	  <el-table-column
		  	    v-for="column in tableCols2"
		  	    :key="column.prop"
		  	    :prop="column.prop"
		  	    :label="column.label"
		  	    :width="column.width"
		  	    show-overflow-tooltip="true"
		  	  				sortable
		  	  />
		    </el-table>
		    <!-- 分页 -->
		    <!-- <div class="gva-pagination">
		      <el-pagination layout="total, sizes, prev, pager, next, jumper" :current-page="page" :page-size="limit"
		        :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="type === 'create' ? '添加' : '修改'"
            destroy-on-close width="1200px">
            <!-- <el-scrollbar height="500px"> -->
            <el-form :model="formData" label-position="left" ref="elFormRef" :rules="rule">

              <el-row :gutter="20">

                <el-col :span="6">
                  <el-form-item label="日期" prop="name">
                    <el-row :gutter="20">
                      <el-col :span="12">
                        <el-input v-model="formData.code" :clearable="true" placeholder="ZT01733" />
                      </el-col>
                    </el-row>
                  </el-form-item>
                </el-col>
              </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="9">
                                <span>印件名称</span>
                              </el-col>
                              <el-col :span="2">
                                <span>包装产量</span>
                              </el-col>
							  <el-col :span="2">
							    <span>每箱数量</span>
							  </el-col>
							  <el-col :span="2">
							    <span>零头</span>
							  </el-col>
                            </el-row>
              
                            <!-- 员工1 -->
                            <el-row :gutter="5" style="margin-top: 10px;">
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="ZI00401" />
                              </el-col>
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="瞿春生" />
                              </el-col>
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="11.0" />
                              </el-col>
                              <el-col :span="9">
                                <el-input v-model="formData.image" :clearable="true" placeholder="打包废纸" />
                              </el-col>
                              <el-col :span="2">
                                <el-input v-model="formData.image" :clearable="true" placeholder="是" />
                              </el-col>
							  <el-col :span="2">
							    <el-input v-model="formData.image" :clearable="true" placeholder="是" />
							  </el-col>
							  <el-col :span="2">
							    <el-input v-model="formData.image" :clearable="true" placeholder="是" />
							  </el-col>
                            </el-row>
              
                            <!-- 员工2 -->
                            <el-row :gutter="5" style="margin-top: 10px;">
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="ZI00401" />
                              </el-col>
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="瞿春生" />
                              </el-col>
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="11.0" />
                              </el-col>
                              <el-col :span="9">
                                <el-input v-model="formData.image" :clearable="true" placeholder="打包废纸" />
                              </el-col>
                              <el-col :span="2">
                                <el-input v-model="formData.image" :clearable="true" placeholder="是" />
                              </el-col>
							  <el-col :span="2">
							    <el-input v-model="formData.image" :clearable="true" placeholder="是" />
							  </el-col>
							  <el-col :span="2">
							    <el-input v-model="formData.image" :clearable="true" placeholder="是" />
							  </el-col>
                            </el-row>
              
                            <!-- 员工3 -->
                            <el-row :gutter="5" style="margin-top: 10px;">
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="ZI00401" />
                              </el-col>
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="瞿春生" />
                              </el-col>
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="11.0" />
                              </el-col>
                              <el-col :span="9">
                                <el-input v-model="formData.image" :clearable="true" placeholder="打包废纸" />
                              </el-col>
                              <el-col :span="2">
                                <el-input v-model="formData.image" :clearable="true" placeholder="是" />
                              </el-col>
							  <el-col :span="2">
							    <el-input v-model="formData.image" :clearable="true" placeholder="是" />
							  </el-col>
							  <el-col :span="2">
							    <el-input v-model="formData.image" :clearable="true" placeholder="是" />
							  </el-col>
                            </el-row>
              
                            <!-- 员工4 -->
                            <el-row :gutter="5" style="margin-top: 10px;">
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="ZI00401" />
                              </el-col>
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="瞿春生" />
                              </el-col>
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="11.0" />
                              </el-col>
                              <el-col :span="9">
                                <el-input v-model="formData.image" :clearable="true" placeholder="打包废纸" />
                              </el-col>
                              <el-col :span="2">
                                <el-input v-model="formData.image" :clearable="true" placeholder="是" />
                              </el-col>
							  <el-col :span="2">
							    <el-input v-model="formData.image" :clearable="true" placeholder="是" />
							  </el-col>
							  <el-col :span="2">
							    <el-input v-model="formData.image" :clearable="true" placeholder="是" />
							  </el-col>
                            </el-row>
              
                            <!-- 员工5 -->
                            <el-row :gutter="5" style="margin-top: 10px;">
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="ZI00401" />
                              </el-col>
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="瞿春生" />
                              </el-col>
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="11.0" />
                              </el-col>
                              <el-col :span="9">
                                <el-input v-model="formData.image" :clearable="true" placeholder="打包废纸" />
                              </el-col>
                              <el-col :span="2">
                                <el-input v-model="formData.image" :clearable="true" placeholder="是" />
                              </el-col>
							  <el-col :span="2">
							    <el-input v-model="formData.image" :clearable="true" placeholder="是" />
							  </el-col>
							  <el-col :span="2">
							    <el-input v-model="formData.image" :clearable="true" placeholder="是" />
							  </el-col>
                            </el-row>
              
                            <!-- 员工6 -->
                            <el-row :gutter="5" style="margin-top: 10px;">
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="ZI00401" />
                              </el-col>
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="瞿春生" />
                              </el-col>
                              <el-col :span="3">
                                <el-input v-model="formData.image" :clearable="true" placeholder="11.0" />
                              </el-col>
                              <el-col :span="9">
                                <el-input v-model="formData.image" :clearable="true" placeholder="打包废纸" />
                              </el-col>
                              <el-col :span="2">
                                <el-input v-model="formData.image" :clearable="true" placeholder="是" />
                              </el-col>
							  <el-col :span="2">
							    <el-input v-model="formData.image" :clearable="true" placeholder="是" />
							  </el-col>
							  <el-col :span="2">
							    <el-input v-model="formData.image" :clearable="true" placeholder="是" />
							  </el-col>
                            </el-row>
			  
            </el-form>
            <!-- </el-scrollbar> -->
            <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-dialog v-model="positioningVisibleshow" :before-close="closepositioningVisible" :title="type==='create'?'添加':'修改'" destroy-on-close>
            <el-card>
          				<el-form-item label="员工编号" prop="name">
          				  <el-row :gutter="20">
          				    <el-col :span="12">
          				      <el-input v-model="positionvalue" :clearable="true" placeholder="ZT01733" />
          				    </el-col>                      
          				  </el-row>
          				</el-form-item>
          			</el-card>
          			<el-button type="primary" @click="enterpositioning">确 定</el-button>
          </el-dialog>
         
        </el-main>
      </el-container>
    </el-container>


          <!-- 员工计件明细 -->
          <el-dialog
        v-model="dialogYgjjmx"
        title="员工计件明细"
        destroy-on-close
      >
        <Ygjjmx :ygbh="currentRow?.['bh']" />
      </el-dialog>

  </div>
</template>

<script setup>
import {
  getList,
  getTab,
  dailygetTab,
  dailygetList,
  dailygetAllList,
  dailygetDetail,
  dailysearch
} from '@/api/jixiaoguanli/jitairibaobiao'

// 全量引入格式化工具 请按需保留
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 { getPackingSideTable, getPackingTable } from '@/api/mes_api_gty/myapi'
import { Layout, LayoutContent, LayoutHeader, LayoutSider } from '@arco-design/web-vue'
import Ygjjmx from './printYgjjmx.vue'
import * as XLSX from "xlsx";
import { useUserStore } from '@/pinia/modules/user'
const userStore = useUserStore() 
const sys_id='['+userStore.userInfo.userName+'/'+userStore.userInfo.nickName+']'
defineOptions({
  name: '06-packingDocuments'
})
const tableCols1 = [
  { label: '员工编号', prop: 'bh', width: '105' },
  { label: '员工姓名', prop: '员工姓名', width: '105' },
  { label: '日期', prop: 'sczl_rq', width: '120' },
  { label: '计件工资', prop: '计件工资', width: '105' },
  { label: '加班工资', prop: '加班工资', width: '105' },
  { label: '计时时数', prop: '计时时数', width: '105' },
  { label: '计时工资', prop: '计时工资', width: '135' },
  { label: '日工资合计', prop: '日工资合计', width: '135' },
]
const tableCols2 = [
  { label: '日期', prop: 'sczl_rq', width: '105' },
  { label: '工单编号', prop: 'sczl_gdbh', width: '105' },
  { label: '产品名称', prop: 'Gd_cpmc', width: '120' },
  { label: '印件及工序', prop: 'sczl_type', width: '120' },
  { label: '机台编号', prop: 'sczl_jtbh', width: '105' },
  { label: '班组车头产量', prop: '班组车头产量', width: '135' },
  { label: '班组换算产量', prop: '班组换算产量', width: '135' },
  { label: '工序难度系数', prop: '工序难度系数', width: '135' },
  { label: '个人计件工资', prop: '个人计件工资', width: '135' },
  { label: '个人加班工资', prop: '个人加班工资', width: '135' },
  { label: '装版工时', prop: '装版工时', width: '120' },
  { label: '保养工时', prop: '保养工时', width: '105' },
  { label: '打样工时', prop: '打样工时', width: '105' },
  { label: '异常停机工时', prop: '异常停机工时', width: '145' },
  { label: '车头产量占用机时', prop: '车头产量占用机时', width: '175' },
  { label: '日定额', prop: '日定额', width: '135' },
  { label: '达标定额', prop: '达标定额', width: '105' },
  { label: '千件工价', prop: '千件工价', width: '105' },
  { label: '补产标准', prop: '补产标准', width: '120' },
  { label: '员工编号', prop: 'bh', width: '105' },
  { label: '姓名', prop: 'xm', width: '105' },
  { label: '比例', prop: 'Rate', width: '105' },
  { label: '班组换算产量', prop: '班组换算产量', width: '135' },
  { label: '工序难度系数', prop: '工序难度系数', width: '135' },
]
// 侧边栏数据请求
const treeData = reactive([]);
const multipleTable=ref()
const getTabdata = async () => {
    //接口调用函数
    const response  = await dailygetTab();
	
	const transformedData = response.data.map(item => ({
	      label: `${item.label}`,
	      children: item.children.map(sysItem => ({
	        label: `${sysItem.label}`,
	        params: {
	          date: item.label,
	          sys_id: sysItem.label,
	          total:'',
	        },
	      })),
	    }));
	    treeData.splice(0, treeData.length, ...transformedData);

	
	}
	

getTabdata();

// 自动化生成的字典（可能为空）以及字段
const formData = ref({
  id: '',
  name: '',
  date: '',
  group: '',
  packingOutput: '',
  reworkOutput: '',
  pieceOutput: '',
  order: '',
  user: '',
  createTime: '',
  updateTime: '',
  uniqid: '',
})

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

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

// =========== 表格控制部分 ===========
const tableData = reactive([])
const tableData2 = reactive([])
const detailData = reactive([])
const total = ref(0)
const page = ref(1)
const limit = ref(10)
const searchInfo = ref('')
const params = {
  date: '',
  sys_id: '',
  page: page.value.toString(),
  limit: limit.value.toString(),
}

// 分页设置
const handleSizeChange = (val) => {
  limit.value = val;
  params.limit = val.toString();
  getTableData();
}

// 页面跳转
const handleCurrentChange = (val) => {
  page.value = val
  params.page = val.toString();
  getTableData()
}

// 查询
const getTableData = async () => {
	
	
  const response = await dailygetList({
	  date: params.date, department: params.sys_id,});
  // console.log(response)
  if (response.code === 0) {
	   const originalData = response.data;
	      const summaryData = generateSummaryData(originalData);
	      // 将合计数据插入到原始数据中
	      const combinedData = [];
	      originalData.forEach((item, index) => {
	        combinedData.push(item);
	        const nextItem = originalData[index + 1];
	        if (nextItem && nextItem['员工姓名'] !== item['员工姓名']) {
	          // 如果下一个员工姓名与当前不同，插入合计数据
	          const currentSummary = summaryData.shift();
	          combinedData.push(currentSummary);
			 
	        }
	      });
		  // console.log(combinedData)
	      // 更新表格数据
	      tableData.splice(0, tableData.length, ...combinedData);
  }
}

const generateSummaryData = (data) => {
  const summaryData = [];
  let currentName = null;
  let currentSummary = null;

  data.forEach((item) => {
    const name = item['员工姓名'].trim(); // 获取员工姓名并去除空格
    if (name !== currentName) {
      // 如果员工姓名发生改变，说明需要插入合计数据
      if (currentSummary) {
        // 将上一个员工的合计数据插入到数组中
        summaryData.push(currentSummary);
      }
      // 创建新的合计数据
      currentSummary = {
        '员工姓名': name,
		'日期': 0,
        '计件工资': 0,
        '加班工资': 0,
        '计时时数': 0,
        '计时工资': 0,
        '日工资合计': 0
      };
      currentName = name;
    }

    // 更新合计数据
	currentSummary['日期']++;
    currentSummary['计件工资'] += parseFloat(item['计件工资']);
    currentSummary['加班工资'] += parseFloat(item['加班工资']);
    currentSummary['计时时数'] += parseFloat(item['计时时数']);
    currentSummary['计时工资'] += parseFloat(item['计时工资']);
    currentSummary['日工资合计'] += parseFloat(item['日工资合计']);
	currentSummary['员工姓名']='合计（'+currentSummary['日期']+'天）';
  });

  // 将最后一个员工的合计数据插入到数组中
  if (currentSummary) {
    summaryData.push(currentSummary);
  }

  // 将日期填充到表格中
  summaryData.forEach((summary) => {
    summary['计件工资'] = summary['计件工资'].toFixed(2); // 保留两位小数
	summary['加班工资'] = summary['加班工资'].toFixed(2);
	summary['计时时数'] = summary['计时时数'].toFixed(2);
	summary['计时工资'] = summary['计时工资'].toFixed(2);
	summary['日工资合计'] = summary['日工资合计'].toFixed(2);
  });

  return summaryData;
};
const handleNodeClick = (node, check) => {
  //存放当前节点的nodeId
  if (node.params) {
    params.date = node.params.date;
    params.sys_id = node.params.sys_id;
    total.value = node.params.total;
    getTableData();
  }
}

// 定位
function onposition() {
  positioningVisibleshow.value=true
}
const enterpositioning = async () => {
 let parts = params.date.split('-')
 
 // # 截取第一个"-"之前的内容并赋值给新变量1
 let new_variable1 = parts[0]
 
 // # 截取第一个"-"之后到第二个"-"之前的内容并赋值给新变量2
 let new_variable2 = parts[1]
 Getlocate(new_variable1+new_variable2)
 positioningVisibleshow.value=false
}
let positionvalue=ref()
const Getlocate = async (value) => {
  
  // const response = await locate(locatevalue);
  // console.log(locatevalue)
  // console.log(response)
  // if (response.code === 0) {
  //   tableData.splice(0, tableData.length, ...response.data.rows);
  // }
  const response = await dailysearch({
    date: value,
    search:positionvalue.value
  })
  if (response.code === 0) {
    tableData.splice(0, tableData.length, ...response.data)
  }
}
// 搜索
function onSearch() {
 let parts = params.date.split('-')
 
 // # 截取第一个"-"之前的内容并赋值给新变量1
 let new_variable1 = parts[0]
 
 // # 截取第一个"-"之后到第二个"-"之前的内容并赋值给新变量2
 let new_variable2 = parts[1]
 Getlocate(new_variable1+new_variable2)
 // positioningVisibleshow.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 type = ref('')

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

// 弹窗控制标记
const dialogFormVisible = ref(false)
const positioningVisibleshow = ref(false)
// 打开弹窗
const openDialog = () => {
  type.value = 'create'
  dialogFormVisible.value = true
}

// 关闭弹窗
const closeDialog = () => {
  dialogFormVisible.value = false
  formData.value = {
    address: '',
    image: '',
    name: '',
  }
}
// 弹窗确定
const enterDialog = async () => {
  elFormRef.value?.validate(async (valid) => {
    if (!valid) return
    let res
    switch (type.value) {
      case 'create':
        res = await createCompany(formData.value)
        break
      case 'update':
        res = await updateCompany(formData.value)
        break
      default:
        res = await createCompany(formData.value)
        break
    }
    if (res.code === 0) {
      ElMessage({
        type: 'success',
        message: '创建/更改成功'
      })
      closeDialog()
      getTableData()
    }
  })
}
// 单击表格操作
function ontable(row, column, event) {
  currentRow.value = row
  let parts = params.date.split('-')
  
  // # 截取第一个"-"之前的内容并赋值给新变量1
  let new_variable1 = parts[0]
  
  // # 截取第一个"-"之后到第二个"-"之前的内容并赋值给新变量2
  let new_variable2 = parts[1]
  Getundertable(new_variable1,row.bh)
}
//获取下列表
const Getundertable = (date,bh) => {
	if(bh == undefined) return
  dailygetAllList({date:date,code:bh}).then(response=>{
	  if(response.code==0){
	  	   tableData2.splice(0, tableData2.length, ...response.data);
	  	// console.log(response.data.num)
	  	// const rowIndex = tableData.findIndex(row => row.UniqId === lastCellValue);
	  	// console.log(rowIndex)
	  	// tableData[rowIndex].sczl_废品率系数 = response.data.num;
	  }
  })
  
  // console.log(response)
  // const rowIndex = tableData.findIndex(row => row.UniqId === 123);
}
// 双击表格操作
function doubleClick(row, column, event) {
  // updateCompanyFunc(row);
  type.value = 'update';
  // dialogFormVisible.value = true
}

// 导出excel

function exportExcel() {
 if(tableData.length<1){
 	ElMessage({
 	  type: 'error',
 	  message: '请确认上方表格内是否存在内容'
 	})
 }else{
 	exportExcelFile(tableData,tableCols1)
 }
};
function exportExcel2() {
if(tableData2.length<1){
		ElMessage({
		  type: 'error',
		  message: '请确认上方表格内是否存在内容'
		})
	}else{
		exportExcelFile(tableData2,tableCols2)
	}
};
const exportExcelFile = (tableData, tableCols) => {
  const data = tableData.map(row => {
    const rowData = {};
    tableCols.forEach(column => {
      rowData[column.label] = row[column.prop];
    });
    return rowData;
  });

  const worksheet = XLSX.utils.json_to_sheet(data);
  const workbook = XLSX.utils.book_new();
  XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');
  XLSX.writeFile(workbook, 'exported_table.xlsx');
};
const currentRow = ref()
const dialogYgjjmx = ref(false)
function handlePrint() {
  dialogYgjjmx.value = true
}

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

<style>
.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;
}

/* 选中某行时的背景色*/
.el-table__body tr.current-row>td {
  background: #ff80ff !important;
  /* 背景颜色 */
}
.bt {
  margin-left: 2px !important;
  padding: 3px !important;
  font-size: 12px;
}
</style>