链接信息 | 统计自定义表格 |
1.有内容的直接统计(注意id位置,取id和对id赋值) 2.内容为填充的,设计隐藏表格列,统计求和(注意小数点和转换) 详细见GBMS 统计各个单据
$(function() { $("body").layout(); $("#tt").tabs(); var value = 0; $("#tbody tr").each(function(i, item) { var count = $(item).find("td:eq(3)").text(); var price = $(item).find("td:eq(6)").text(); value += count * price; }); $("#count").text(value); //统计入库表 var counthsj = 0; var countbhsj = 0; var countjs = 0; $("#tbody2 tr").each(function(i, item) { var count = parseFloat($(item).find("td:eq(8)").text()); var count2 = parseFloat($(item).find("td:eq(6)").text()); counthsj += count; //含税金 countbhsj += count2; //不含税金 }); countjs = counthsj - countbhsj; $("#countjs1").text(countjs.toFixed(2)); $("#countjs11").text(countjs.toFixed(2)); $("#countbhsj1").text(countbhsj.toFixed(2)); $("#countbhsj11").text(countbhsj.toFixed(2)); $("#counthsj1").text(counthsj.toFixed(2)); $("#counthsj11").text(counthsj.toFixed(2)); //统计出库表 var ck_counthsj = 0; var ck_countbhsj = 0; var ck_countjs = 0; $("#tbody3 tr").each(function(i, item) { var ck_count = parseFloat($(item).find("td:eq(11)").text()); var ck_count2 = parseFloat($(item).find("td:eq(9)").text()); ck_counthsj += ck_count; //含税金 ck_countbhsj += ck_count2; //不含税金 }); ck_countjs = ck_counthsj - ck_countbhsj; $("#countjs2").text(ck_countjs.toFixed(2)); $("#countjs21").text(ck_countjs.toFixed(2)); $("#countbhsj2").text(ck_countbhsj.toFixed(2)); $("#countbhsj21").text(ck_countbhsj.toFixed(2)); $("#counthsj2").text(ck_counthsj.toFixed(2)); $("#counthsj21").text(ck_counthsj.toFixed(2)); //导出申请表word $("#wordBtn").click(function() { $("#table4").attr("border", "1"); $("#content").val($("#div").html()); $("#export").submit(); return false; }); }); <tbody id='tbody3'> <#list buyList as item> <tr> <td class="td" style="text-align: left;border-color: #000000">${item_index+1}</td> <td class="td" style="text-align: left;border-color: #000000">${inStorage.gis_num}</td> <td class="td" style="text-align: left;border-color: #000000">${item.gb_level2belong}</td> <td class="td" style="text-align: left;border-color: #000000">${item.gb_property}</td> <td class="td" style="text-align: left;border-color: #000000">${inStorage.gis_supplier_name}</td> <td class="td" style="text-align: left;border-color: #000000">${inStorage.gis_contract_num}</td> <td class="td" style="text-align: center;border-color: #000000">${item.gb_count}</td> <td class="td" style="text-align: center;border-color: #000000">${item.gb_unit}</td> <td class="td" style="text-align: center;border-color: #000000">${item.gb_unit_price}</td> <td class="td" style="text-align: center;border-color: #000000">${item.gb_count*item.gb_unit_price}</td> <td class="td" style="text-align: center;border-color: #000000">${item.gb_tax}</td> <td class="td" style="text-align: left;border-color: #000000">${item.gb_count*item.gb_unit_price+item.gb_tax}</td> </tr> </#list> </tbody> </table> <table class="table-border" width="100%"> <tr> <td class="th" style="text-align: left;border-color: #000000;width:30px">本页进税小计</td> <td class="td" colspan="3" style="text-align: right;border-color: #000000" id="countjs2"></td> <td class="th" style="text-align: left;border-color: #000000;width:30px">本页不含税金额小计</td> <td class="td" colspan="3" style="text-align: right;border-color: #000000" id="countbhsj2"></td> <td class="th" style="text-align: left;border-color: #000000;width:30px">本页含税金额小计</td> <td class="td" colspan="3" style="text-align: right;border-color: #000000" id="counthsj2"></td> </tr> <tr> <td class="th" style="text-align: left;border-color: #000000;width:30px">本单进税小计</td> <td class="td" colspan="3" style="text-align: right;border-color: #000000" id="countjs21"></td> <td class="th" style="text-align: left;border-color: #000000;width:30px">本单不含税金额小计</td> <td class="td" colspan="3" style="text-align: right;border-color: #000000" id="countbhsj21"></td> <td class="th" style="text-align: left;border-color: #000000;width:30px">本单含税金额小计</td> <td class="td" colspan="3" style="text-align: right;border-color: #000000" id="counthsj21"></td> </tr> </table> =============================
function count(t){ var total = parseFloat($(t).closest("tr").find("td:eq(8) input[name=gb_total_price]").val()); //总价 var tax = parseFloat($(t).closest("tr").find("td:eq(7) input[name=gb_tax] ").val()); var price = (total/(1+tax)).toFixed(6); $(t).closest("tr").find("td:eq(6)").text(price); //金额 $(t).closest("tr").find("td:eq(12)").text(total); //金额 var count = $(t).closest("tr").find("td:eq(3)").text(); //数量 $(t).closest("tr").find("td:eq(5)").text(price/count); //单价 count2(t); } function count2(t){ //统计入库表 var counthsj = 0; var countbhsj = 0; var countjs = 0; $("#tbody2 tr").each(function(i, item) { var count2 = parseFloat($(item).find("td:eq(6)").text()); var count= parseFloat($(item).find("td:eq(12)").text()); if(count>0){ counthsj += count; //含税金 } if(count2>0) { countbhsj += count2; //不含税金 } }); if(counthsj>countbhsj){ countjs = counthsj - countbhsj; } $("#countjs1").text(countjs.toFixed(2)); $("#countjs11").text(countjs.toFixed(2)); $("#countbhsj1").text(countbhsj.toFixed(2)); $("#countbhsj11").text(countbhsj.toFixed(2)); $("#counthsj1").text(counthsj.toFixed(2)); $("#counthsj11").text(counthsj.toFixed(2)); } <tbody id="tbody2"> <#list buyList as item> <tr> <td class="td" style="text-align: left;">${item_index+1}<input type="hidden" name="ga_id" value="${ga_id}"></td> <td class="td" style="text-align: left;"><input type="hidden" name="gb_level2belong" value="${item.gb_level2belong}">${item.gb_level2belong}</td> <td class="td" style="text-align: left;"><input type="hidden" name="gb_property" value="${item.gb_property}">${item.gb_property}</td> <td class="td" style="text-align: center;">${item.gb_count}</td> <td class="td" style="text-align: center;">${item.gb_unit}</td> <td class="td" style="text-align: center;"></td> <td class="td" style="text-align: center;"><#if item.gb_unit_price??>${item.gb_count*item.gb_unit_price}</#if></td> <td class="td" style="text-align: center;"><input type="text" name="gb_tax" class="input" style="width: 100px;"></td> <td class="td" style="text-align: center;"> <input type="text" name="gb_total_price" required="true" value="${item.gb_total_price}" class="input easyui-numberbox" min="0" precision="2" οnchange="count(this)" style="width: 100px;"> <#--<#if item.gb_unit_price??&&item.gb_tax??>${item.gb_count*item.gb_unit_price+item.gb_tax}</#if>--></td> <td class="td" style="text-align: left;">${(project.gp_name)!}</td> <td class="td" style="text-align: left;">${(project.gp_num)!}</td> <td class="td" style="text-align: left;">${(project.gp_single_project)!}</td> <td style="display: none"></td> </tr> </#list> </tbody> </table> <table class="table-border" width="100%"> <tr> <td class="th" style="text-align: left; width:30px">本页进税小计</td> <td class="td" colspan="4" style="text-align: right; " id="countjs1"> </td> <td class="th" style="text-align: left; width:30px">本页不含税金额小计</td> <td class="td" colspan="4" style="text-align: right; " id="countbhsj1"> </td> <td class="th" style="text-align: left; width:30px">本页含税金额小计</td> <td class="td" colspan="4" style="text-align: right; " id="counthsj1"> </td> </tr> <tr> <td class="th" style="text-align: left; width: 30px;">本单进税小计</td> <td class="td" colspan="4" style="text-align: right; " id="countjs11"> </td> <td class="th" style="text-align: left; width: 30px;">本单不含税金额小计</td> <td class="td" colspan="4" style="text-align: right; " id="countbhsj11"> </td> <td class="th" style="text-align: left; width: 30px;">本单含税金额小计</td> <td class="td" colspan="4" style="text-align: right; " id="counthsj11"> </td> </tr> |
表格和统计
最新推荐文章于 2023-08-15 21:18:10 发布