<template>
  <div class="bank-report-table" style="height:80vh" @click="closeAllTooltips">
    <!-- 加载遮罩层 -->
    <div v-if="loading" class="loading-overlay">
      <div class="loading-spinner">
        <div class="spinner"></div>
        <div class="loading-text">加载中...</div>
      </div>
    </div>

    <vxe-toolbar>
      <template #button>
        <div class="toolbar-info">
          <span class="info-label">填报任务：{{ queryParam?.taskName }}</span>
          <span class="info-label">表格：{{ queryParam?.tplCode }} {{ queryParam?.tplName }}</span>
        </div>
      </template>
      <template #tools v-if="!queryParam.comfrom">
        <vxe-button status="primary" icon="vxe-icon-edit" @click="handleOpenHistoryDrawer()" :disabled="loading">近5年数据填报</vxe-button>
        <vxe-button status="primary" icon="vxe-icon-save" @click="checkData()">校验</vxe-button>
        <vxe-button status="primary" icon="vxe-icon-save" @click="saveBatch">保存</vxe-button>
      </template>
    </vxe-toolbar>

    <!-- 校验抽屉 -->
    <ValidationDrawer 
      ref="validationDrawerRef" 
      v-model="drawerVisible" 
      :tableFormData="tableFormData" 
      @validationResultClick="handleValidationResultClick"
    />
    
    <vxe-table
      border
      ref="tableRef"
      show-header-overflow
      :data="tableFormData"
      :column-config="{ resizable: true }"
      :row-config="{ resizable: true }"
      class="custom-table"
      height="auto"
      :merge-cells="mergeCells"
    >
      <vxe-column field="serialNumber" title="序号" width="80"></vxe-column>
      <vxe-column field="project" title="项目" width="50">
        <template #default="{ row }">
          <span class="project-title">{{ row.project }}</span>
        </template>
      </vxe-column>
      <vxe-column field="project2" title="" width="50">
        <template #default="{ row }">
          <span class="project-title">{{ row.project2 }}</span>
        </template>
      </vxe-column>
      <vxe-column field="content" title="内容" row-resize>
        <template #default="{ row }">
          <div class="content-cell">
            <template v-if="row.type === 'MultiColumnTable'">
              <MultiColumnTable
                :title="row.project"
                :columnsPerRow="6"
                :records="[]"
                :fields="row.content"
                :ref="(el) => setMultiColumnTableRef(el, row.code)"
                class="embedded-table"
              />
            </template>
            <template v-else-if="row.type === 'AttachTable'">
              <AttachTable
                :title="row.project"
                :records="row.datas"
                :fields="row.content"
                :pcode="row.code"
                :ref="(el) => setAttachTableRef(el, row.code)"
                class="embedded-table"
              />
            </template>
            <template v-else>
              <template v-for="(item, index) in row.content" :key="index">
                <span v-if="item.type === 'text'" v-html="item.value"></span>
                <span v-else-if="item.type === 'br'"><br></span>
                <span v-else-if="item.type === 'brspace'">
                  <br>
                  <template v-for="i in (item.value || 1)" :key="i">
                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                  </template>
                </span>

                <template v-else-if="item.type === 'AttachTable'">
                  <AttachTable
                    :title="item.project"
                    :records="item.datas"
                    :fields="item.content"
                    :pcode="item.code"
                    :ref="(el) => setAttachTableRef(el, item.code)"
                    class="embedded-table"
                  />
                </template>

                <template v-else-if="item.type === 'MultiColumnTable'">
                  <MultiColumnTable
                    :title="item.project"
                    :records="[]"
                    :fields="item.content"
                    :ref="(el) => setMultiColumnTableRef(el, item.code)"
                    class="embedded-table"
                  />
                </template>
                
                <template v-else-if="item.type === 'yesno'">
                  <vxe-radio-group v-model="formData[getFieldKey(row.code, item.field)]">
                    <vxe-radio label="是" content="是"></vxe-radio>
                    <vxe-radio label="否" content="否"></vxe-radio>
                  </vxe-radio-group>
                  <template v-if="item.extraField || item.extraFields">
                    <div v-if="formData[getFieldKey(row.code, item.field)] === '是'" class="extra-fields-container">
                      如是，
                      <template v-if="item.extraField">
                        {{ item.extraLabel }}：
                        <vxe-input v-model="formData[getFieldKey(row.code, item.extraField)]" class="extra-input"></vxe-input>
                        <span class="unit">{{ item.unit }}</span>
                      </template>
                      <template v-else-if="item.extraFields">
                        <template v-for="(ccopt, ccind) in item.extraFields" :key="ccind">
                          <span>{{ ccopt.label }}: </span>
                          <template v-if="ccopt.formType === 'input'">
                            <vxe-input v-model="formData[getFieldKey(row.code, ccopt.field)]" class="extra-input"></vxe-input>
                          </template>
                          <template v-else-if="ccopt.formType === 'number'">
                            <vxe-input v-model="formData[getFieldKey(row.code, ccopt.field)]" type="number" class="extra-input"></vxe-input>
                            <span class="unit">{{ ccopt.unit }}</span>
                          </template>
                          <template v-else-if="ccopt.formType === 'checkbox'">
                            <vxe-checkbox-group v-model="formData[getFieldKey(row.code, ccopt.field)]">
                              <vxe-checkbox v-for="(opt, optIndex) in ccopt.options" :key="optIndex" :label="opt" :content="opt"></vxe-checkbox>
                            </vxe-checkbox-group>
                          </template>
                          <template v-else-if="ccopt.formType === 'radio'">
                            <vxe-radio-group v-model="formData[getFieldKey(row.code, ccopt.field)]" :options="ccopt.options">
                              <vxe-radio v-for="(opt, optIndex) in ccopt.options" :key="optIndex" :label="opt" :content="opt"></vxe-radio>
                            </vxe-radio-group>
                          </template>
                          <template v-else>
                            <vxe-input v-model="formData[getFieldKey(row.code, ccopt.field)]" :type="ccopt.formType" class="extra-input"></vxe-input>
                          </template>
                          <br>
                          <template v-if="ccopt.otherOption">
                            其他：<vxe-input v-model="formData[getFieldKey(row.code, ccopt.otherField)]" class="extra-input"></vxe-input>
                          </template>
                          <br>
                        </template>
                      </template>
                    </div>
                  </template>
                </template>
                <span v-else-if="item.type === 'radio-group'" class="radio-group">
                    <vxe-radio-group v-model="formData[getFieldKey(row.code, item.field)]" style="margin-left: 20px;">
                      <vxe-radio v-for="(opt, optIndex) in item.options" :key="optIndex" :label="opt" style="width:100%">{{ opt }}</vxe-radio>
                    </vxe-radio-group>
                </span>
                <span v-else-if="item.type === 'radio-group-extraFields'" class="radio-group">
                    <vxe-radio-group v-model="formData[getFieldKey(row.code, item.field)]">
                      <vxe-radio v-for="(opt, optIndex) in item.options" :key="optIndex" :label="opt.label">
                        {{ opt.label }}
                        <template v-if="opt.extraField && formData[getFieldKey(row.code, item.field)] === opt.label">
                          <span>{{ opt.extraLabel }}</span>
                          <vxe-input v-model="formData[getFieldKey(row.code, opt.extraField)]" class="extra-input"></vxe-input>
                        </template>
                        <template v-if="opt.extraFields && formData[getFieldKey(row.code, item.field)] === opt.label">
                          <template v-for="(ccopt, ccind) in opt.extraFields" :key="ccind">
                            <span>{{ ccopt.label }}: </span>
                            <vxe-input v-model="formData[getFieldKey(row.code, ccopt.field)]" class="extra-input"></vxe-input>
                          </template>
                        </template>
                      </vxe-radio>
                    </vxe-radio-group>
                </span>
                <div v-else-if="item.type === 'checkbox-group'">
                  <div style="width:400px;margin-left:30px">
                    <vxe-checkbox-group v-model="formData[getFieldKey(row.code, item.field)]">
                      <vxe-checkbox v-for="(opt, optIndex) in item.options" :key="optIndex" :label="opt">
                        {{ opt }}
                      </vxe-checkbox>
                      <template v-if="item.otherOption" >
                        <vxe-checkbox  label="其他">
                          其他：
                          <vxe-input v-model="formData[getFieldKey(row.code, item.otherField)]" class="extra-input"
                           :disabled="!(formData[row.code+'_'+item.field]?.indexOf('其他')>-1)"
                          ></vxe-input>
                        </vxe-checkbox>
                      </template>
                    </vxe-checkbox-group>
                  </div>
                </div>
                <template v-else-if="item.type === 'textarea'">
                  <vxe-textarea v-model="formData[getFieldKey(row.code, item.field)]" :rows="item.rows" :style="{ width: item.width }"></vxe-textarea>
                </template>
                <template v-else>
                  <div class="input-wrapper">
                    <vxe-input
                      :type="item.type"
                      v-model="formData[getFieldKey(row.code, item.field)]"
                      size="mini"
                      class="table-input"
                      @blur="handleInputBlur(row.code, item.field, item.matchedFormula?.formula)"
                    />
                    <span v-if="item.unit" class="unit">{{ item.unit }}</span>
                    
                    <span
                      v-if="showHelpIcon(row.code, item.field, item)"
                      class="help-icon"
                      @click.stop="toggleTooltip(row.code, item.field)"
                      title="点击查看校验规则"
                    >
                      ?
                    </span>
                    
                    <span
                      v-if="inputErrors[getFieldKey(row.code, item.field)]"
                      class="error-icon"
                      @click.stop="toggleErrorTooltip(row.code, item.field)"
                      title="点击查看错误详情"
                    >
                      <i class="vxe-icon-error">✗</i>
                    </span>
                    
                    <div
                      v-if="showTooltip && hoveredKey === getFieldKey(row.code, item.field)"
                      class="tooltip"
                      @click.stop
                    >
                      {{ item.matchedFormula?.des || '暂无校验规则' }}
                    </div>
                    
                    <div
                      v-if="showErrorTooltip && hoveredErrorKey === getFieldKey(row.code, item.field)"
                      class="error-tooltip"
                      @click.stop
                    >
                      {{ inputErrors[getFieldKey(row.code, item.field)].message }}
                      <br>
                      <span style="color: #ffcccc;">
                        公式: {{ inputErrors[getFieldKey(row.code, item.field)].formula }}
                      </span>
                      <template v-if="inputErrors[getFieldKey(row.code, item.field)].error">
                        <br>
                        <span style="color: #ff9999; font-size: 11px;">
                          错误: {{ inputErrors[getFieldKey(row.code, item.field)].error }}
                        </span>
                      </template>
                    </div>
                  </div>
                </template>
              </template>
            </template>
          </div>
        </template>
      </vxe-column>
      <vxe-column field="remarks" title="备注" width="100">
        <template #default="{ row }"> 
            <vxe-textarea :rows="row.remarks.rows" v-model="formData[row.code+'_'+row.remarks.field]"  style="height:100%;">
            </vxe-textarea>
        </template>
      </vxe-column>
    </vxe-table>
    
    <!-- 历史填报检查组件 -->
    <HistoryFillCheck ref="historyFillCheckRef" v-model="historyDrawerVisible" @closeDrawer="closeHistoryDrawer"/>
  </div>
</template>

<script lang="ts" setup>
import MultiColumnTable from '../tableComponents/MultiColumnTable.vue'
import AttachTable from '../tableComponents/AttachTable.vue'
import HistoryFillCheck from './check/historyFillCheck.vue'
import ValidationDrawer from './check/ValidationDrawer.vue'
import { tableFormData } from '../../data/tb10.data'
import { ref, reactive, nextTick, onMounted } from 'vue'
import { VxeUI,VxeTablePropTypes } from 'vxe-table'
import { batchSaveOrUpdateBeforeDelete, queryRecord } from '../../record/BaosongTaskRecord.api'
import { queryAllTplItemForUser, findUserRightForTplItem } from '../../alloc/BaosongTaskAlloc.api'
import { allTplItems } from '../../tpl/BaosongTplItem.api'
import { getTblvalidFormula } from '../../tpl/BaosongDataValid.api'
import { useRoute } from 'vue-router'

interface FormData {
  id: number | null
  taskid: number
  tplid: number
  itemid?: number
  itempid?: number
  content: string
  tplcode: string
  rind: number
}

const route = useRoute()
const tableRef = ref()
const tplItemMap = ref<Record<string, any>>({})
const historyFillCheckRef = ref<any>(null)
const validationDrawerRef = ref()
const loading = ref(false)
const formData = reactive<Record<string, any>>({})
const formValues = ref<FormData[]>([])
const childMultiTableRefs = ref<Record<string, any>>({})
const childAttachTableRefs = ref<Record<string, any>>({})

const queryParam = ref({
  taskId: -1,
  taskName: '',
  tplId: -1,
  tplName: '',
  tplCode: '',
  comfrom: ''
})

// 权限相关状态
const userAllocItems = ref<string[]>([])
const validFormula = ref<any[]>([])
const drawerVisible = ref(false)
const historyDrawerVisible = ref(false)
const showTooltip = ref(false)
const hoveredKey = ref('')
const showErrorTooltip = ref(false)
const hoveredErrorKey = ref('')
const inputErrors = ref<Record<string, any>>({})
const isInitialized = ref(false)

interface FormulaItem {
  formula: string
  des: string
  [key: string]: any
}

interface InputError {
  message: string
  formula: string
  error?: string
}

onMounted(async () => {
  if (route.query.taskId) {
    queryParam.value.taskId = Number(route.query.taskId)
  }
  if (route.query.taskName) {
    queryParam.value.taskName = String(route.query.taskName)
  }
  if (route.query.tplId) {
    queryParam.value.tplId = Number(route.query.tplId)
  }
  if (route.query.tplName) {
    queryParam.value.tplName = String(route.query.tplName)
  }
  if (route.query.tplCode) {
    queryParam.value.tplCode = String(route.query.tplCode)
  }
  if (route.query.comfrom) {
    queryParam.value.comfrom = String(route.query.comfrom)
  }

  // 设置查询参数
  setQueryParams();

  // 获取权限和验证公式
  try {
    userAllocItems.value = await findUserRightForTplItem({
      tplid: queryParam.value.tplId,
      taskid: queryParam.value.taskId
    })

    validFormula.value = await getTblvalidFormula({
      tplid: queryParam.value.tplId,
    })
  } catch (error) {
    console.error('获取权限或验证公式失败:', error)
  }

  await setTplItemMap()
  setFormItemRight()
  await setData()
  
  isInitialized.value = true
  
  setTimeout(() => {
    refreshHelpIcons()
  }, 300)
})

const getFieldKey = (pcode: string | undefined, field: string): string => {
  return pcode ? `${pcode}_${field}` : field
}

const saveBatch = async () => {
  try {
    loading.value = true
    formValues.value = []

    // Process main form data
    for (const strKey in formData) {
      const valData = formData[strKey]
      if (valData) {
        const [pcode, code] = strKey.split('_')
        await setFormValues(pcode, code, valData, 1)
      }
    }


    await getAttachTableFormData()
    await getAllMultiTableFormData()

    if (formValues.value.length > 0) {
      await batchSaveOrUpdateBeforeDelete(formValues.value)
      VxeUI.modal.message({ content: '保存成功', status: 'success' })
    } else {
      VxeUI.modal.message({ content: '没有需要保存的数据', status: 'warning' })
    }
  } catch (error) {
    console.error('保存失败:', error)
    VxeUI.modal.message({ content: `保存失败: ${error instanceof Error ? error.message : String(error)}`, status: 'error' })
  } finally {
    loading.value = false
  }
}

const setMultiColumnTableRef = (el: any, code: string) => {
  if (el) {
    childMultiTableRefs.value[code] = el
  }
}

const setAttachTableRef = (el: any, code: string) => {
  if (el) {
    childAttachTableRefs.value[code] = el
  }
}

const getAllMultiTableFormData = async () => {
  for (const pcode in childMultiTableRefs.value) {
    const child = childMultiTableRefs.value[pcode]
    if (child) {
      const datas = child.getFormData()
      let rind = 0
      for (const obj of datas) {
        rind++
        Object.keys(obj).forEach(code => {
          setFormValues(pcode, code, obj[code], rind)
        })
      }
    }
  }
}

const getAttachTableFormData = async () => {
  for (const pcode in childAttachTableRefs.value) {
    const child = childAttachTableRefs.value[pcode]
    if (child) {
      const datas = child.getFormData()
      for (const code in datas) {
        await setFormValues(pcode, code, datas[code], 1)
      }
    }
  }
}

const setFormValues = async (pcode: string, code: string, valData: any, rind: number) => {
  if (!valData) return

  if(Array.isArray(valData)&& valData.length==0) return
    
  const vals = Array.isArray(valData) ? valData.join(',') : valData
  const strKey = `${pcode}_${code}`
  const item = tplItemMap.value[strKey]
  const { pid, itemid } = item ?? {}

  const tempForm: FormData = {
    id: null,
    rind: rind,
    taskid: queryParam.value.taskId,
    tplid: queryParam.value.tplId,
    tplcode: code,
    itemid: itemid,
    itempid: pid,
    content: vals
  }

  formValues.value.push(tempForm)
}

async function setData() {
  try {
    loading.value = true;
    const taskId = queryParam.value.taskId;
    const tplid = queryParam.value.tplId;
    
    Object.keys(formData).forEach(key => delete formData[key]);
    
    await setTplItemMap();
    const recordData = await queryRecord({ taskid: taskId, tplid: tplid });
    
    const valueObj = {};
    for (const data of recordData) {
      const key = `${data.itempid}_${data.itemid}_${data.rind}`;
      valueObj[key] = data.content;
    }
    const shouldSkip = (key) => {
      const refsToCheck = [
        childMultiTableRefs.value,
        childAttachTableRefs.value,
      ];
      
      for (const refs of refsToCheck) {
        for (const pcode of Object.keys(refs)) {
          if (key.startsWith(pcode + '_')) {
            return true;
          }
        }
      }
      return false;
    };

    for (const strKey of Object.keys(tplItemMap.value)) {
      if (shouldSkip(strKey)) {
        continue; 
      }
      
      const item = tplItemMap.value[strKey];
      if (!item) continue;
      
      const { pid, itemid, formTp } = item;
      const dataVal = valueObj[`${pid}_${itemid}_1`];

      if (!dataVal) continue;
      
      if (formTp === 'checkbox') {
        formData[strKey] = dataVal?.split(",") || [];
      } else {
        formData[strKey] = dataVal || "";
      }
    }

    for (const pcode of Object.keys(childAttachTableRefs.value)) {
      const child = childAttachTableRefs.value[pcode];
      const matchingKeys = Object.keys(tplItemMap.value).filter(key => 
        key.startsWith(pcode + '_')
      );
      
      const attachTableData = {};
      for (const key of matchingKeys) {
        const tmpData = tplItemMap.value[key];
        if (!tmpData) continue;
        
        const { pid, itemid, formTp, code } = tmpData;
        const valueKey = `${pid}_${itemid}_1`;
        
        if (formTp === 'checkbox') {
          attachTableData[code] = valueObj[valueKey]?.split(",") || [];
        } else {
          attachTableData[code] = valueObj[valueKey] || "";
        }
      }
      
      child.setFormData(attachTableData);
    }

    for (const pcode of Object.keys(childMultiTableRefs.value)) {
      const child = childMultiTableRefs.value[pcode];
      const matchingKeys = Object.keys(tplItemMap.value).filter(key => 
        key.startsWith(pcode + '_')
      );
      
      const rowsMap = {};
      for (const key of matchingKeys) {
        const tmpData = tplItemMap.value[key];
        if (!tmpData) continue;
        
        const { pid, itemid, code } = tmpData;
        const valKeys = Object.keys(valueObj).filter(k => 
          k.startsWith(`${pid}_${itemid}_`)
        );
        
        for (const valKey of valKeys) {
          const parts = valKey.split('_');
          const rind = parts[2];
          
          if (!rowsMap[rind]) {
            rowsMap[rind] = {};
          }
          
          rowsMap[rind][code] = valueObj[valKey];
        }
      }
      
      const tableDatas = Object.values(rowsMap);
      nextTick();
      child.setFormData(tableDatas);
    }

  } catch (error) {
    VxeUI.modal.message({ 
      content: `加载数据失败: ${error.message}`, 
      status: 'error' 
    });
  } finally {
    loading.value = false;
  }
}


async function setTplItemMap() {
  try {
    const taskId = queryParam.value.taskId
    const tplid = queryParam.value.tplId
    const tplItem = await allTplItems({
      tplid: tplid
    })

    tplItemMap.value = tplItem.reduce((acc, item) => {
      const strKey = `${item.pcode}_${item.xmlcode}`
      acc[strKey] = {
        pid: item.pid,
        itemid: item.id,
        formTp: item.formTp,
        code: item.xmlcode
      }
      return acc
    }, {} as Record<string, any>)
  } catch (error) {
    console.error('加载数据失败:', error)
    VxeUI.modal.message({ content: `加载数据失败: ${error instanceof Error ? error.message : String(error)}`, status: 'error' })
  }
}

// 校验数据
const checkData = () => {
  drawerVisible.value = true
  validationDrawerRef.value.setValidateData(validFormula.value, formData)
}

const handleInputBlur = (rowCode: string, field: string, formula?: string) => {
  if (!formula) return;
  
  const key = getFieldKey(rowCode, field);
  const value = formData[key];
  
  if (!value || value === '') {
    delete inputErrors.value[key];
    return;
  }
  
  validateFieldFormula(rowCode, field, formula);
};

const validateFieldFormula = (rowCode: string, field: string, formula: string) => {
  const key = getFieldKey(rowCode, field);
  
  try {
    const expression = buildExpression(formula, rowCode);
    const isValid = eval(expression);
    if (!isValid) {
      inputErrors.value[key] = {
        message: "公式校验失败，请检查填写内容",
        formula
      };
    } else {
      delete inputErrors.value[key];
    }
  } catch (error: any) {
    inputErrors.value[key] = {
      message: "公式校验失败，请检查填写内容",
      formula,
      error: error.message
    };
  }
};

const buildExpression = (formula: string, rowCode: string): string => {
  const fieldNames = formula.match(/\b[A-Za-z][A-Za-z0-9_]*\b/g) || [];
  const uniqueFields = [...new Set(fieldNames.filter(f => 
    !['and', 'or', 'not', 'equal', 'less', 'greater', 'if', 'else', 'true', 'false']
      .includes(f.toLowerCase())
  ))];
  
  uniqueFields.sort((a, b) => b.length - a.length);
  
  let expression = formula;
  for (const fieldName of uniqueFields) {
    const key = getFieldKey(rowCode, fieldName);
    const value = formData[key];
    if (value !== undefined) {
      expression = expression.replace(
        new RegExp(`\\b${fieldName}\\b`, 'g'), 
        `Number(${value})`
      );
    }
  }
  
  return expression;
};

const toggleTooltip = (rowCode: string, field: string) => {
  const key = getFieldKey(rowCode, field);
  if (hoveredKey.value === key) {
    showTooltip.value = false;
    hoveredKey.value = '';
  } else {
    showTooltip.value = true;
    hoveredKey.value = key;
  }
};

const toggleErrorTooltip = (rowCode: string, field: string) => {
  const key = getFieldKey(rowCode, field);
  if (hoveredErrorKey.value === key) {
    showErrorTooltip.value = false;
    hoveredErrorKey.value = '';
  } else {
    showErrorTooltip.value = true;
    hoveredErrorKey.value = key;
  }
};

const closeAllTooltips = () => {
  showTooltip.value = false;
  hoveredKey.value = '';
  showErrorTooltip.value = false;
  hoveredErrorKey.value = '';
};

const showHelpIcon = (rowCode: string, field: string, item: any): boolean => {
  if (item.hasValidFormula !== undefined) {
    return item.hasValidFormula === true;
  }
  
  const key = getFieldKey(rowCode, field);
  const hasRight = userAllocItems.value.includes(key);
  
  if (!hasRight) return false;
  
  const formulaResult = findEarliestFormulaForField(validFormula.value, field);
  return !!formulaResult.formula;
};

// 处理校验结果点击
const handleValidationResultClick = (result: any) => {
  const message = `字段 ${result.field} 的校验结果: ${result.isValid ? '通过' : '失败'}`
  const status = result.isValid ? 'success' : 'error'
  
  VxeUI.modal.message({ content: message, status })
}

// 打开历史填报抽屉
const handleOpenHistoryDrawer = () => {
  historyDrawerVisible.value = true
}

// 关闭历史填报抽屉
const closeHistoryDrawer = () => {
  historyDrawerVisible.value = false
}

const setFormItemRight = () => {
  console.log('开始设置表单权限...')
  console.log('userAllocItems 数量:', userAllocItems.value.length)
  console.log('validFormula 数量:', validFormula.value.length)
  
  tableFormData.forEach((row: any) => {
    if (row.content && Array.isArray(row.content)) {
      row.content.forEach((item: any) => {
        if (item.field) {
          const key = getFieldKey(row.code, item.field)
          item.hasRight = userAllocItems.value.includes(key)
          
          console.log(`字段 ${key}: hasRight = ${item.hasRight}`)
          
          if (item.hasRight) {
            const formulaResult = findEarliestFormulaForField(validFormula.value, item.field)
            
            item.hasValidFormula = !!formulaResult.formula
            item.matchedFormula = formulaResult.formula || null
            
            console.log(`字段 ${key}: hasValidFormula = ${item.hasValidFormula}`)
          } else {
            item.hasValidFormula = false
            item.matchedFormula = null
          }
        }
      })
    }
  })
  
  console.log('表单权限设置完成')
}

const findEarliestFormulaForField = (
  formulas: FormulaItem[], 
  field: string
): { formula: FormulaItem | null, index: number } => {
  let result = { formula: null, index: Infinity }
  
  formulas?.forEach((f: FormulaItem) => {
    const text = f.formula || ''
    const escapedField = field.replace(/[.*+?^${}()|[\]\\]/g, '\\$&')
    const regex = new RegExp(`\\b${escapedField}\\b(?!\\w)`, 'g')
    const match = regex.exec(text)
    
    if (match && match.index < result.index) {
      result = { formula: f, index: match.index }
    }
  })
  
  return result
}

const refreshHelpIcons = () => {
  console.log('刷新帮助图标...')
  tableFormData.forEach((row: any) => {
    if (row.content && Array.isArray(row.content)) {
      row.content.forEach((item: any) => {
        if (item.field) {
          const key = getFieldKey(row.code, item.field)
          const hasRight = userAllocItems.value.includes(key)
          
          if (hasRight) {
            const formulaResult = findEarliestFormulaForField(validFormula.value, item.field)
            item.hasValidFormula = !!formulaResult.formula
            item.matchedFormula = formulaResult.formula || null
          } else {
            item.hasValidFormula = false
            item.matchedFormula = null
          }
        }
      })
    }
  })
  
  nextTick(() => {
  })
}

const mergeCells = ref<VxeTablePropTypes.MergeCells>([
  { row: 0, col: 1, rowspan: 1, colspan: 2 },
  { row: 1, col: 1, rowspan: 1, colspan: 2 },
  { row: 2, col: 1, rowspan: 1, colspan: 2 },
  { row: 3, col: 1, rowspan: 6, colspan: 1 },

  { row: 9, col: 1, rowspan: 1, colspan: 2},
  { row: 10, col: 1, rowspan: 1, colspan: 2},
])
</script>

<style lang="less" scoped>
.bank-report-table {
  font-family: "SimSun", "宋体", serif;
  font-size: 12px;
  margin: 5px auto;
  width: 90%;
}

.toolbar-info {
  margin: 10px;
  
  .info-label {
    font-weight: bold;
    margin-left: 20px;
    
    &:first-child {
      margin-left: 0;
    }
  }
}

.custom-table {
  width: 100%;
  border: 1px solid #000;
  border-collapse: collapse;
  
  :deep(.vxe-header--column),
  :deep(.vxe-body--column) {
    border-right: 1px solid #000;
    border-bottom: 1px solid #000;
    padding: 5px;
  }
}

/* 加载遮罩层样式 */
.loading-overlay {
  position: absolute;
  top: 0;
  left: 0;
  width: 100%;
  height: 100%;
  background-color: rgba(255, 255, 255, 0.8);
  display: flex;
  justify-content: center;
  align-items: center;
  z-index: 1000;
}

.loading-spinner {
  display: flex;
  flex-direction: column;
  align-items: center;
}

.spinner {
  width: 40px;
  height: 40px;
  border: 3px solid #f3f3f3;
  border-top: 3px solid #3498db;
  border-radius: 50%;
  animation: spin 2s linear infinite;
}

@keyframes spin {
  0% { transform: rotate(0deg); }
  100% { transform: rotate(360deg); }
}

.loading-text {
  margin-top: 10px;
  color: #666;
  font-size: 14px;
}

.content-cell {
  line-height: 1.8;
  padding: 5px;
}

.project-title {
  font-weight: bold;
  font-size: 14px;
}

.table-input,
.vxe-input {
  height: 24px;
  line-height: 24px;
  min-width: 150px;
  margin: 0 2px;
  padding: 0 5px;
  border: none;
  border-bottom: 1px solid #333;
  background: transparent;
  text-align: center;
}

.extra-input {
  width: 200px;
  margin-left: 5px;
}

.extra-fields-container {
  margin-left: 40px;
  margin-top: 5px;
}

.vxe-radio-group,
.vxe-checkbox-group {
  display: inline-block;
  margin-right: 5px;
  max-width: 99%;
}

.radio-group,
.checkbox-group {
  display: inline-block;
  max-width: 99%;
}

.vxe-radio,
.vxe-checkbox {
  margin: 10px;
  white-space: nowrap;
}

.unit {
  margin-left: 3px;
  color: #666;
}

.embedded-table {
  margin: 0;
  padding: 0;
  border: none;
}

.input-wrapper {
  position: relative;
  display: inline-block;
}

.help-icon {
  margin-left: 5px;
  cursor: pointer;
  color: #1890ff;
  font-weight: bold;
  font-size: 14px;
  display: inline-block;
  width: 20px;
  height: 20px;
  line-height: 20px;
  text-align: center;
  background: #e6f7ff;
  border-radius: 50%;
  transition: all 0.3s;
  opacity: 0;
  animation: fadeIn 0.5s forwards;
  animation-delay: 0.3s;
  
  &:hover {
    background: #bae7ff;
    transform: scale(1.1);
  }
}

@keyframes fadeIn {
  from {
    opacity: 0;
    transform: scale(0.8);
  }
  to {
    opacity: 1;
    transform: scale(1);
  }
}

.error-icon {
  margin-left: 5px;
  cursor: pointer;
  color: #ff4d4f;
  font-size: 16px;
  display: inline-block;
  width: 20px;
  height: 20px;
  line-height: 20px;
  text-align: center;
  transition: all 0.3s;
  
  &:hover {
    transform: scale(1.1);
  }
}

.tooltip, .error-tooltip {
  position: absolute;
  top: 100%;
  left: 0;
  margin-top: 5px;
  padding: 10px;
  font-size: 12px;
  border-radius: 4px;
  z-index: 1000;
  white-space: pre-wrap;
  max-width: 300px;
  box-shadow: 0 2px 8px rgba(0, 0, 0, 0.15);
}

.tooltip {
  background: #333;
  color: #fff;
  
  &::before {
    content: '';
    position: absolute;
    bottom: 100%;
    left: 10px;
    border-width: 5px;
    border-style: solid;
    border-color: transparent transparent #333 transparent;
  }
}

.error-tooltip {
  background: #8b0000;
  color: #fff;
  
  &::before {
    content: '';
    position: absolute;
    bottom: 100%;
    left: 10px;
    border-width: 5px;
    border-style: solid;
    border-color: transparent transparent #8b0000 transparent;
  }
}
</style>