给表单自动合计

阿虎-cqh

已于 2023-02-01 16:26:36 修改

阅读量45

点赞数

文章标签： html5

于 2022-08-17 14:25:55 首次发布

本文链接：https://blog.csdn.net/chenqinghu98/article/details/126385407

版权

 <tr>
            <td style="font-weight: 700;" align="center">合计</td>
            <td align="right" sum="fwsl"></td>
            <td align="right" sum="dcmj"></td>
            <td align="right" sum="xxsl"></td>
            <td align="right" sum="xxmj"></td>
            <td align="right" sum="yysl"></td>
            <td align="right" sum="yymj"></td>
            <td align="right" sum="ggsl"></td>
            <td align="right" sum="ggmj"></td>
            <td align="right" sum="qtsl"></td>
            <td align="right" sum="qtmj"></td>
        </tr>
        <tr th:each="item:${list}">
            <td align="left">[[${@code.getLabel('sys_dept', 'dept_id', 'dept_name', item.get('dept_id'))}]]</td>
            <td align="right" data-sum="fwsl">[[${#numbers.formatDecimal(item.get('fwsltotal'),1,'COMMA',0,'POINT')}]]</td>
            <td align="right" data-sum="dcmj">[[${#numbers.formatDecimal(item.get('dcmjtotal'),1,'COMMA',0,'POINT')}]]</td>
            <td align="right" data-sum="xxsl">[[${#numbers.formatDecimal(item.get('xxsl'),1,'COMMA',0,'POINT')}]]</td>
            <td align="right" data-sum="xxmj">[[${#numbers.formatDecimal(item.get('xxmj'),1,'COMMA',0,'POINT')}]]</td>
            <td align="right" data-sum="yysl">[[${#numbers.formatDecimal(item.get('yysl'),1,'COMMA',0,'POINT')}]]</td>
            <td align="right" data-sum="yymj">[[${#numbers.formatDecimal(item.get('yymj'),1,'COMMA',0,'POINT')}]]</td>
            <td align="right" data-sum="ggsl">[[${#numbers.formatDecimal(item.get('ggsl'),1,'COMMA',0,'POINT')}]]</td>
            <td align="right" data-sum="ggmj">[[${#numbers.formatDecimal(item.get('ggmj'),1,'COMMA',0,'POINT')}]]</td>
            <td align="right" data-sum="qtsl">[[${#numbers.formatDecimal(item.get('qtsl'),1,'COMMA',0,'POINT')}]]</td>
            <td align="right" data-sum="qtmj">[[${#numbers.formatDecimal(item.get('qtmj'),1,'COMMA',0,'POINT')}]]</td>
        </tr>
    </table>

    <script type="text/javascript">
        $(function(){
            // 自动完成表格合计
            $("td[sum]").each((i,col)=>{
                var key = $(col).attr("sum");
                var sum = 0;
                $("td[data-sum="+key+"]").each((j,cell)=>{
                    var val = $(cell).text();
                    sum += parseFloat(val.replaceAll(",",""));
                });
                $(col).html(formatNumber(sum));
            })
        });
    </script>