数据汇总到表格

兰生秋水 2天前问答子表汇总收藏

6 / 136

各位大佬帮忙看看，我需要按规格去统计重量，用表格显示，有什么好方法吗

叶文洁报坐标 2天前回复

透视表

明道小杨 3天前回复

没隐藏前跟你表单一样，

字段隐藏了以后，就是这个效果

自定义字段自己编个代码就好了
// <free_field_name> 型号规格表格 </free_field_name>
// <file_name>ModelSpecTable_v1.jsx</file_name>
function ModelSpecTable({ formData }) {
// 定义型号数据配置
const modelConfigs = [
{
modelName: "8010",
weightControlId: "68eaf8d7e42c3406e3c56109",
lengthControlId: "68eaf8d7e42c3406e3c5610a"
},
{
modelName: "406",
weightControlId: "68eaf8d7e42c3406e3c5610b",
lengthControlId: "68eaf8d7e42c3406e3c5610c"
},
{
modelName: "206",
weightControlId: "68eaf8d7e42c3406e3c5610d",
lengthControlId: "68eaf8d7e42c3406e3c5610e"
},
{
modelName: "304",
weightControlId: "68eaf8d7e42c3406e3c5610f",
lengthControlId: "68eaf8d7e42c3406e3c56110"
}
];

return (

{modelConfigs.map((config, index) => { const weightValue = config.weightControlId ? formData[config.weightControlId]?.value : null; const lengthValue = config.lengthControlId ? formData[config.lengthControlId]?.value : null;

return (
          <tr key={config.modelName} className={index % 2 === 0 ? 'bg-white' : 'bg-gray-50'}>
            <td className="px-3 py-2 border-b border-gray-200 font-medium">{config.modelName}</td>
            <td className="px-3 py-2 border-b border-gray-200">
              {weightValue !== null && weightValue !== undefined ? weightValue : '-'}
            </td>
            <td className="px-3 py-2 border-b border-gray-200">
              {lengthValue !== null && lengthValue !== undefined ? lengthValue : '-'}
            </td>
          </tr>
        );
      })}
    </tbody>
  </table>
</div>

);
}