历史运维需求

CREATE TABLE score_exchange_config (
  id VARCHAR(32) PRIMARY KEY,
  match_type VARCHAR(20) NOT NULL COMMENT '匹配类型：按渠道/按客户',
  channel_type VARCHAR(50) COMMENT '渠道商类型',
  customer_code VARCHAR(50) COMMENT '客户编码',
  customer_type VARCHAR(20) COMMENT '客户类型',
  period_start DATE NOT NULL COMMENT '周期开始日',
  period_end DATE NOT NULL COMMENT '周期结束日',
  exchange_start DATE NOT NULL COMMENT '兑换开始日',
  exchange_end DATE NOT NULL COMMENT '兑换截止日',
  exchange_rate DECIMAL(10,2) DEFAULT 1.00 COMMENT '兑换比例',
  exchange_method VARCHAR(20) NOT NULL COMMENT '兑现方式',
  INDEX idx_period (period_start, period_end),
  INDEX idx_match (match_type, channel_type, customer_code)
);

// 导入服务伪代码
async function importExchangeData(file: File) {
  const workbook = await readExcel(file);
  const rows = parseWorkbook(workbook);
  
  // 数据校验
  for (let row of rows) {
    if (!validatePeriodContinuity(row)) {
      throw new Error('积分周期存在断层');
    }
  }
  
  // 批量保存
  await batchInsert(rows);
}

// 动态表单组件
<DynamicForm matchType={matchType}>
  <FormField label="匹配类型" required>
    <Select 
      options={[
        { value: 'channel', label: '按渠道' },
        { value: 'customer', label: '按客户' }
      ]}
      onChange={handleMatchTypeChange}
    />
  </FormField>
  
  {matchType === 'channel' && (
    <FormField label="渠道商类型" required>
      <Select options={channelTypes} />
    </FormField>
  )}
  
  {matchType === 'customer' && (
    <FormField label="客户" required>
      <Select 
        options={customerList.map(c => ({
          value: c.code,
          label: `${c.code}/${c.name}/${c.type}`
        }))}
      />
    </FormField>
  )}
</DynamicForm>