<div id="table" class="wrapper wrapper-content animated fadeInRight" xmlns:th="http://www.thymeleaf.org">
<meta charset="UTF-8">
<style type="text/css">
/* TABLES */
.excelTableHead{
color: black;
margin-bottom: 6px;
}
.excelTable {
width: auto;
font-size: 13px;
color: black;
border: 1px solid #333333;
}
.excelTable>thead>tr>th, .excelTable>thead>tr>td {
background-color: #333333;
border-bottom-width: 1px;
}
.excelTable>thead>tr>th, .excelTable>tbody>tr>th, .excelTable>tfoot>tr>th, .excelTable>thead>tr>td, .excelTable>tbody>tr>td, .excelTable>tfoot>tr>td {
border: 1px solid #333333;
}
.excelTableFoot{
color: black;
}
@media print {
#alert_danger{
display: none;
}
}
td {
white-space: nowrap;
}
.slash {
width: 100px;
height: 50px;
background-color: #000000;
position: relative;
padding: 0 !important;
}
.slash::before {
content: '';
display: block;
width: 100%;
height: 100%;
background-color: #ffffff;
clip-path: polygon(0px 0.5px, 0px 100%, calc(100% - 0.5px) calc(100% + 0.5px));
position: absolute;
top: 0;
}
.slash::after {
content: '';
display: block;
width: 100%;
height: 100%;
background-color: #ffffff;
clip-path: polygon(100% calc(100% - 0.5px), 100% 0px, 0px -0.5px);
position: absolute;
top: 0;
}
</style>
<table id="reportHead" class="excelTableHead" style="width: 100%">
<tr>
<td th:colspan="8" align="center" style="font-size: 26px; font-weight: 700; padding-bottom: 6px">测试表</td>
</tr>
<tr>
<td colspan="4">隶属单位(盖章):测试</td>
</tr>
</table>
<table id="report" class="table excelTable" billstandardborder="1" cellspacing="0" cellpadding="0" style="width: 100%">
<tr>
<td style="font-weight: 700;" align="center" rowspan="2">序号</td>
<td style="font-weight: 700;" align="center" rowspan="2">隶属</td>
<td style="font-weight: 700;" align="center" rowspan="2">供水单位</td>
<td style="font-weight: 700;" align="center" rowspan="2">水表编号</td>
<td style="font-weight: 700;" align="center" rowspan="2">用户姓名</td>
<td style="font-weight: 700;" align="center" rowspan="2">用户电话</td>
<td style="font-weight: 700;" align="center" rowspan="2">年份</td>
<td style="font-weight: 700;" align="center" colspan="4">年度用水计划指标</td>
<td style="font-weight: 700;" align="center" rowspan="2">实际用水量(m3)</td>
<td style="font-weight: 700;" align="center" rowspan="2">年度用水计划指标使用率</td>
</tr>
<tr>
<td style="font-weight: 700;" align="center" >种植结构</td>
<td style="font-weight: 700;" align="center" >种植面积(亩)</td>
<td style="font-weight: 700;" align="center" >定额(m3/亩)</td>
<td style="font-weight: 700;" align="center" >合计(m3)</td>
</tr>
<th:block th:each="item:${res}">
<tr th:if="${item.number} == 1" >
<td align="center" th:text="${itemStat.count}"></td>
<td align="center">a</td>
<td align="center">b</td>
<td align="center">c</td>
<td align="center">d</td>
<td align="center">e</td>
<td align="center">[[${item.bill_year}]]</td>
<th:block th:each="itemr:${item.records}">
<td align="center">f</td>
<td align="center">[[${itemr.get('item_num')}]]</td>
<td align="center">[[${itemr.get('item_quota')}]]</td>
<td align="center">[[${itemr.get('num')}]]</td>
</th:block>
<td align="right">[[${item.use_amount}]]</td>
<td align="right">[[${item.use_rate}]]%</td>
</tr>
<th:block th:if="${item.number} != 1">
<tr >
<td align="center" th:text="${itemStat.count}" th:rowspan="${item.number+1}"></td>
<td align="center" th:rowspan="${item.number+1}">a</td>
<td align="center" th:rowspan="${item.number+1}">b</td>
<td align="center" th:rowspan="${item.number+1}">c</td>
<td align="center" th:rowspan="${item.number+1}">d</td>
<td align="center" th:rowspan="${item.number+1}">e</td>
<td align="center" th:rowspan="${item.number+1}">[[${item.bill_year}]]</td>
<th:block th:each="itemr:${item.records}">
<th:block th:if="${itemrStat.index==0}">
<td align="center" >f</td>
<td align="center">[[${itemr.get('item_num')}]]</td>
<td align="center">[[${itemr.get('item_quota')}]]</td>
<td align="center">[[${itemr.get('num')}]]</td>
</th:block>
</th:block>
<td align="right" th:rowspan="${item.number+1}">[[${item.use_amount}]]</td>
<td align="right" th:rowspan="${item.number+1}">[[${item.use_rate}]]%</td>
</tr>
<th:block th:each="itemr:${item.records}">
<tr th:if="${itemrStat.index>0}">
<td align="center" >f</td>
<td align="center">[[${itemr.get('item_num')}]]</td>
<td align="center">[[${itemr.get('item_quota')}]]</td>
<td align="center">[[${itemr.get('num')}]]</td>
</tr>
</th:block>
<tr >
<td align="center" style="font-weight: bold;">小计</td>
<td align="center" style="font-weight: bold">[[${item.itemNumSum}]]</td>
<td class="slash"></td>
<td align="center" style="font-weight: bold">[[${item.quotaSum}]]</td>
</tr>
</th:block>
</th:block>
</table>
<br/>
</div>
效果图