cy
2022-06-21 129904537f66509f97b285e7eb4f42b3dc349dd0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
[#include "/component/excExport.html" /]
<style>
    .reportTable td{min-width:60px;white-space: nowrap;}
 
</style>
<div id="reportDiv">
<div class="check_btn clearfix"  style="margin-right: 27px;">
    [@excExp id="reportTable" name="备件明细报表" /]
</div>
<div id="printDiv">
 [#if ciList?? && ciList?size>0]
    <div style="width: 100%;overflow: auto;height:440px;">
    <table border="0" class="reportTable tablew" id="reportTable" style="width:auto;min-width:100%;">
 
 
       <tr class="titleTr">
            <td colspan="${props.commonProp?size+11}">备件明细报表</td>
        </tr>
       <tr class="nameTr">
          <td colspan="${props.commonProp?size+9}">&nbsp;</td>
          <td colspan="3" style="text-align:right;">统计日期:${DateUtil.format("yyyy/MM/dd",RequestParameters.beginTime)}-${DateUtil.format("yyyy/MM/dd",RequestParameters.endTime)}</td>
        </tr>
    <tr class="title" >
        <td nowrap class="tdbg" >备件分类</td>
        <td nowrap class="tdbg">实物编码</td>
        <td nowrap class="tdbg">备件名称</td>
        <td nowrap class="tdbg">资产编码</td>
        <td nowrap class="tdbg">型号</td>
        <td nowrap  class="tdbg">货位名称</td>
        <td nowrap class="tdbg">成本价(元)</td>
        <td nowrap class="tdbg">销售价(元)</td>
        <td nowrap class="tdbg">起保日期</td>
        <td nowrap class="tdbg">保质周期(天)</td>
        <td nowrap class="tdbg">出保日期</td>
        
        [#list props.commonProp as d]
            <td nowrap class="tdbg">${d.COLUMNNAME}</td>
        [/#list]
        [#if groupProps?? && groupProps?size>0]
            [#list groupProps as group]
                [#if (group.props?? && group.props?size>0) || (group.props1?? && group.props1?size>0)]
                    [#list group.props1 as d]
                        <td class="tdbg" nowrap>${d.COLUMNNAME}</td>
                    [/#list]
                [/#if]
            [/#list]
        [/#if]
    </tr>
    [#list ciList as ci]
        <tr>
            <td nowrap>${ci.CATENAME}</td>
            <td nowrap>${ci.ENTITY_NO}</td>
            <td nowrap>${ci.NAME}</td>
            <td nowrap>${ci.ASSET_NO}</td>
            <td nowrap>${ci.MODEL_NO}</td>
            <td nowrap>${ci.LOCATION}</td>
            <td nowrap>${ci.baseMsg.COST_PRICE}</td>
            <td nowrap>${ci.baseMsg.SALE_PRICE}</td>
            <td nowrap>${DateUtil.format("yyyy-MM-dd",ci.baseMsg.WARRANTY_START)}</td>
            <td nowrap>${ci.baseMsg.WARRANTY_CYCLE}</td>
            <td nowrap>${DateUtil.format("yyyy-MM-dd",ci.baseMsg.WARRANTY_END)}</td>
            [#list props.commonProp as d]
                <td nowrap>
                [#if d.DATATYPE==1 || d.DATATYPE==2]
                    ${ci.dataAll[d.ID]}
                [/#if]
                [#if d.DATATYPE==4]
                    ${DateUtil.format("yyyy-MM-dd",ci.dataAll[d.ID])}
                [/#if]
                [#if d.DATATYPE==5]    
                    [#if d.DATATYPE==5 ]
                        [#list d.items as item]
                            [#if item.ID == ci.dataAll[d.ID]]
                                ${item.ITEMVALUE}
                            [/#if]
                        [/#list]
                    [/#if]
                [/#if]
                [#if d.DATATYPE==6]    
                    [#if d.DATATYPE==6 ]
                         ${ci.labelAll[d.ID]}
                    [/#if]
                [/#if]
                </td>
            [/#list]
            [#if groupProps?? && groupProps?size>0]
                [#list groupProps as group]
                    [#if (group.props?? && group.props?size>0) || (group.props1?? && group.props1?size>0)]
                        [#list group.props1 as d]        
                               [#if d.DATATYPE==6]
                                  [#list d.items as item]
                                      [#if  item.ID == ci.dataAll[d.ID]]<td nowrap>${item.ITEMVALUE}</td>
                                      [#else]
                                      <td></td>
                                      [/#if]
                                  [/#list]
                            [#else]
                        <td nowrap>${ci.dataAll[d.ID]}</td>
                            [/#if] 
                           [/#list]
                    [/#if]
                [/#list]
            [/#if] 
        </tr>
    [/#list]
 
</table>
    </div>
    [/#if]
</div>