b7aac3c8-cf3d-44c4-af6c-df22116e37a4<?xml version="1.0" encoding="UTF-8"?>

<foxreport>
<locale name="zh_CN"/>
<title text="本日进住及在住客人报表(境内客为主)"/>
<parms>
<parm name="SYS_TRANSLATE_COLUMNS" text="系统翻译变量" class="java.lang.String" value="[{&quot;descript2&quot;:&quot;描述&quot;,&quot;descript1&quot;:&quot;描述&quot;,&quot;descript&quot;:&quot;描述&quot;,&quot;columnname&quot;:&quot;descript&quot;},{&quot;descript2&quot;:&quot;本日散客人次&quot;,&quot;descript1&quot;:&quot;本日散客人次&quot;,&quot;descript&quot;:&quot;本日散客人次&quot;,&quot;columnname&quot;:&quot;dtc&quot;},{&quot;descript2&quot;:&quot;本日团队人次&quot;,&quot;descript1&quot;:&quot;本日团队人次&quot;,&quot;descript&quot;:&quot;本日团队人次&quot;,&quot;columnname&quot;:&quot;dgc&quot;},{&quot;descript2&quot;:&quot;本日会议人次&quot;,&quot;descript1&quot;:&quot;本日会议人次&quot;,&quot;descript&quot;:&quot;本日会议人次&quot;,&quot;columnname&quot;:&quot;dmc&quot;},{&quot;descript2&quot;:&quot;本日散客人天&quot;,&quot;descript1&quot;:&quot;本日散客人天&quot;,&quot;descript&quot;:&quot;本日散客人天&quot;,&quot;columnname&quot;:&quot;dtt&quot;},{&quot;descript2&quot;:&quot;本日团队人天&quot;,&quot;descript1&quot;:&quot;本日团队人天&quot;,&quot;descript&quot;:&quot;本日团队人天&quot;,&quot;columnname&quot;:&quot;dgt&quot;},{&quot;descript2&quot;:&quot;本日会议人天&quot;,&quot;descript1&quot;:&quot;本日会议人天&quot;,&quot;descript&quot;:&quot;本日会议人天&quot;,&quot;columnname&quot;:&quot;dmt&quot;},{&quot;descript2&quot;:&quot;本月散客人次&quot;,&quot;descript1&quot;:&quot;本月散客人次&quot;,&quot;descript&quot;:&quot;本月散客人次&quot;,&quot;columnname&quot;:&quot;mtc&quot;},{&quot;descript2&quot;:&quot;本月团队人次&quot;,&quot;descript1&quot;:&quot;本月团队人次&quot;,&quot;descript&quot;:&quot;本月团队人次&quot;,&quot;columnname&quot;:&quot;mgc&quot;},{&quot;descript2&quot;:&quot;本月会议人次&quot;,&quot;descript1&quot;:&quot;本月会议人次&quot;,&quot;descript&quot;:&quot;本月会议人次&quot;,&quot;columnname&quot;:&quot;mmc&quot;},{&quot;descript2&quot;:&quot;本月散客人天&quot;,&quot;descript1&quot;:&quot;本月散客人天&quot;,&quot;descript&quot;:&quot;本月散客人天&quot;,&quot;columnname&quot;:&quot;mtt&quot;},{&quot;descript2&quot;:&quot;本月团队人天&quot;,&quot;descript1&quot;:&quot;本月团队人天&quot;,&quot;descript&quot;:&quot;本月团队人天&quot;,&quot;columnname&quot;:&quot;mgt&quot;},{&quot;descript2&quot;:&quot;本月会议人天&quot;,&quot;descript1&quot;:&quot;本月会议人天&quot;,&quot;descript&quot;:&quot;本月会议人天&quot;,&quot;columnname&quot;:&quot;mmt&quot;},{&quot;descript2&quot;:&quot;本年散客人次&quot;,&quot;descript1&quot;:&quot;本年散客人次&quot;,&quot;descript&quot;:&quot;本年散客人次&quot;,&quot;columnname&quot;:&quot;ytc&quot;},{&quot;descript2&quot;:&quot;本年团队人次&quot;,&quot;descript1&quot;:&quot;本年团队人次&quot;,&quot;descript&quot;:&quot;本年团队人次&quot;,&quot;columnname&quot;:&quot;ygc&quot;},{&quot;descript2&quot;:&quot;本年会议人次&quot;,&quot;descript1&quot;:&quot;本年会议人次&quot;,&quot;descript&quot;:&quot;本年会议人次&quot;,&quot;columnname&quot;:&quot;ymc&quot;},{&quot;descript2&quot;:&quot;本年散客人天&quot;,&quot;descript1&quot;:&quot;本年散客人天&quot;,&quot;descript&quot;:&quot;本年散客人天&quot;,&quot;columnname&quot;:&quot;ytt&quot;},{&quot;descript2&quot;:&quot;本年团队人天&quot;,&quot;descript1&quot;:&quot;本年团队人天&quot;,&quot;descript&quot;:&quot;本年团队人天&quot;,&quot;columnname&quot;:&quot;ygt&quot;},{&quot;descript2&quot;:&quot;本年会议人天&quot;,&quot;descript1&quot;:&quot;本年会议人天&quot;,&quot;descript&quot;:&quot;本年会议人天&quot;,&quot;columnname&quot;:&quot;ymt&quot;}]" fixed="true" visiable="false" index="0" refid="jtextfield"/>
<parm name="selectDate" text="" class="java.lang.String" value="$bdate$-1$" fixed="false" visiable="false" index="0" refid="jtextfield"/>
</parms>
<pramform store="class" builder="com.foxhis.report.DefaultReportParmBuilder" dialog="false">com.foxhis.maint.frame.reportcond.RoomRateDiversityPanel3</pramform>
<engine/>
<syntax>&lt;?xml version="1.0" encoding="UTF-8" standalone="no"?&gt;&lt;jatools Class="jatools.ReportDocument" Name="jatools report template"&gt;&lt;VariableContext&gt;&lt;Item0 Class="Parameter" Name="$color_even"&gt;&lt;Name&gt;$color_even&lt;/Name&gt;&lt;Type1&gt;java.lang.String&lt;/Type1&gt;&lt;DefaultValue&gt;#5599AA&lt;/DefaultValue&gt;&lt;Prompt&gt;#5599AA&lt;/Prompt&gt;&lt;/Item0&gt;&lt;Item1 Class="jatools.data.Formula" Name="cy_m"&gt;&lt;Text&gt;Object ts =index1.month{$.hotel}/10000;
t_cy_m=add(t_cy_m,todouble(ts));
return ts;



&lt;/Text&gt;&lt;/Item1&gt;&lt;/VariableContext&gt;&lt;Page&gt;&lt;Children ItemClass="PagePanel"&gt;&lt;Item0&gt;&lt;Width&gt;1366&lt;/Width&gt;&lt;Height&gt;955&lt;/Height&gt;&lt;Children ItemClass="Table"&gt;&lt;Item0&gt;&lt;Name&gt; tbl_body&lt;/Name&gt;&lt;NodePath&gt;hzq&lt;/NodePath&gt;&lt;Children ItemClass="RowPanel"&gt;&lt;Item0&gt;&lt;Cell&gt;&lt;Row&gt;7&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;ColSpan&gt;26&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;PrintStyle&gt;print-mode:everypage;visible:true;&lt;/PrintStyle&gt;&lt;Children ItemClass="Text"&gt;&lt;Item0&gt;&lt;Variable&gt;=rptno_1&lt;/Variable&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;7&lt;/Row&gt;&lt;Col&gt;21&lt;/Col&gt;&lt;ColSpan&gt;5&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item0&gt;&lt;Item1&gt;&lt;Variable&gt;=$totalPageNumber&lt;/Variable&gt;&lt;Cell&gt;&lt;Row&gt;7&lt;/Row&gt;&lt;Col&gt;12&lt;/Col&gt;&lt;ColSpan&gt;9&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item1&gt;&lt;Item2&gt;&lt;Variable&gt;=definedindex($pageIndex)&lt;/Variable&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;7&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;ColSpan&gt;12&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item2&gt;&lt;/Children&gt;&lt;NodePath&gt;hzq1&lt;/NodePath&gt;&lt;/Item0&gt;&lt;Item1&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;RowSpan&gt;6&lt;/RowSpan&gt;&lt;ColSpan&gt;26&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;PrintStyle&gt;print-mode:everypage;visible:true;&lt;/PrintStyle&gt;&lt;Children&gt;&lt;Item0 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;24&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item0&gt;&lt;Item1 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;23&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item1&gt;&lt;Item2 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;22&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item2&gt;&lt;Item3 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;21&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item3&gt;&lt;Item4 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;20&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item4&gt;&lt;Item5 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;19&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item5&gt;&lt;Item6 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;18&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item6&gt;&lt;Item7 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;17&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item7&gt;&lt;Item8 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;16&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item8&gt;&lt;Item9 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;15&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item9&gt;&lt;Item10 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;14&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item10&gt;&lt;Item11 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;13&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item11&gt;&lt;Item12 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;12&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item12&gt;&lt;Item13 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;11&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item13&gt;&lt;Item14 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;10&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item14&gt;&lt;Item15 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;9&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item15&gt;&lt;Item16 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;8&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item16&gt;&lt;Item17 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;7&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item17&gt;&lt;Item18 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;6&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item18&gt;&lt;Item19 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;5&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item19&gt;&lt;Item20 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;4&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item20&gt;&lt;Item21 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;3&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item21&gt;&lt;Item22 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;2&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item22&gt;&lt;Item23 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;1&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item23&gt;&lt;Item24 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item24&gt;&lt;Item25 Class="Text"&gt;&lt;Variable&gt;=fmtdt8(selectDate,null,"yyyy-MM-dd","yy-MM-dd")&lt;/Variable&gt;&lt;Cell&gt;&lt;Row&gt;3&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;ColSpan&gt;12&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item25&gt;&lt;Item26 Class="Text"&gt;&lt;Variable&gt;=printtime&lt;/Variable&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;3&lt;/Row&gt;&lt;Col&gt;12&lt;/Col&gt;&lt;ColSpan&gt;14&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item26&gt;&lt;Item27 Class="Text"&gt;&lt;Variable&gt;=reportname&lt;/Variable&gt;&lt;Font&gt;&lt;Face&gt;宋体&lt;/Face&gt;&lt;Style&gt;0&lt;/Style&gt;&lt;Size&gt;16&lt;/Size&gt;&lt;/Font&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;2&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;ColSpan&gt;26&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item27&gt;&lt;Item28 Class="Text"&gt;&lt;Variable&gt;=hoteldesc&lt;/Variable&gt;&lt;Font&gt;&lt;Face&gt;宋体&lt;/Face&gt;&lt;Style&gt;1&lt;/Style&gt;&lt;Size&gt;18&lt;/Size&gt;&lt;/Font&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;1&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;ColSpan&gt;26&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item28&gt;&lt;Item29 Class="Label"&gt;&lt;Text&gt;月&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;1&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item29&gt;&lt;Item30 Class="Label"&gt;&lt;Text&gt;同月&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;2&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item30&gt;&lt;Item31 Class="Label"&gt;&lt;Text&gt;同比率&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;3&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item31&gt;&lt;Item32 Class="Label"&gt;&lt;Text&gt;完成率&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;5&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item32&gt;&lt;Item33 Class="Label"&gt;&lt;Text&gt;酒店名称&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;4&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;RowSpan&gt;2&lt;/RowSpan&gt;&lt;/Cell&gt;&lt;/Item33&gt;&lt;Item34 Class="Label"&gt;&lt;Text&gt;客房收入（万元）&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;4&lt;/Row&gt;&lt;Col&gt;1&lt;/Col&gt;&lt;ColSpan&gt;5&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item34&gt;&lt;Item35 Class="Label"&gt;&lt;Text&gt;预算&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;4&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item35&gt;&lt;Item36 Class="Label"&gt;&lt;Text&gt;餐饮收入（万元）&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;4&lt;/Row&gt;&lt;Col&gt;6&lt;/Col&gt;&lt;ColSpan&gt;5&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item36&gt;&lt;Item37 Class="Label"&gt;&lt;Text&gt;出租率&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;4&lt;/Row&gt;&lt;Col&gt;11&lt;/Col&gt;&lt;ColSpan&gt;5&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item37&gt;&lt;Item38 Class="Label"&gt;&lt;Text&gt;ADR&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;4&lt;/Row&gt;&lt;Col&gt;16&lt;/Col&gt;&lt;ColSpan&gt;5&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item38&gt;&lt;Item39 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;25&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item39&gt;&lt;Item40 Class="Label"&gt;&lt;Text&gt;REVPAR&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;4&lt;/Row&gt;&lt;Col&gt;21&lt;/Col&gt;&lt;ColSpan&gt;5&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item40&gt;&lt;Item41 Class="Label"&gt;&lt;Text&gt;月&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;6&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item41&gt;&lt;Item42 Class="Label"&gt;&lt;Text&gt;同月&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;7&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item42&gt;&lt;Item43 Class="Label"&gt;&lt;Text&gt;同比率&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;8&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item43&gt;&lt;Item44 Class="Label"&gt;&lt;Text&gt;预算&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;9&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item44&gt;&lt;Item45 Class="Label"&gt;&lt;Text&gt;完成率&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;10&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item45&gt;&lt;Item46 Class="Label"&gt;&lt;Text&gt;月&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;11&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item46&gt;&lt;Item47 Class="Label"&gt;&lt;Text&gt;同月&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;12&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item47&gt;&lt;Item48 Class="Label"&gt;&lt;Text&gt;同比率&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;13&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item48&gt;&lt;Item49 Class="Label"&gt;&lt;Text&gt;预算&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;14&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item49&gt;&lt;Item50 Class="Label"&gt;&lt;Text&gt;完成率&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;15&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item50&gt;&lt;Item51 Class="Label"&gt;&lt;Text&gt;月&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;16&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item51&gt;&lt;Item52 Class="Label"&gt;&lt;Text&gt;同月&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;17&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item52&gt;&lt;Item53 Class="Label"&gt;&lt;Text&gt;同比率&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;18&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item53&gt;&lt;Item54 Class="Label"&gt;&lt;Text&gt;预算&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;19&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item54&gt;&lt;Item55 Class="Label"&gt;&lt;Text&gt;完成率&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;20&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item55&gt;&lt;Item56 Class="Label"&gt;&lt;Text&gt;月&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;21&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item56&gt;&lt;Item57 Class="Label"&gt;&lt;Text&gt;同月&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;22&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item57&gt;&lt;Item58 Class="Label"&gt;&lt;Text&gt;同比率&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;23&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item58&gt;&lt;Item59 Class="Label"&gt;&lt;Text&gt;预算&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;24&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item59&gt;&lt;Item60 Class="Label"&gt;&lt;Text&gt;完成率&lt;/Text&gt;&lt;BackColor&gt;-2631721&lt;/BackColor&gt;&lt;Border&gt;&lt;StyleText&gt;border-top:1.0px solid #000000;border-left:1.0px solid #000000;border-right:1.0px solid #000000;&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;25&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item60&gt;&lt;/Children&gt;&lt;/Item1&gt;&lt;Item2&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;ColSpan&gt;26&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;Children ItemClass="Text"&gt;&lt;Item0&gt;&lt;Name&gt;me&lt;/Name&gt;&lt;Variable&gt;=$.room_pmonth&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;4&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item0&gt;&lt;Item1&gt;&lt;Name&gt;me&lt;/Name&gt;&lt;Variable&gt;=$.room_wcl&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00%&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;5&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item1&gt;&lt;Item2&gt;&lt;Name&gt;me&lt;/Name&gt;&lt;Variable&gt;=$.room_yoy&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00%&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;3&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item2&gt;&lt;Item3&gt;&lt;Name&gt;me&lt;/Name&gt;&lt;Variable&gt;=$.room_lmonth&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;2&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item3&gt;&lt;Item4&gt;&lt;Name&gt;me&lt;/Name&gt;&lt;Variable&gt;=$.room_month&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;1&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item4&gt;&lt;Item5&gt;&lt;Name&gt;me&lt;/Name&gt;&lt;Variable&gt;=$.hotel&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}
&lt;/BeforePrint&gt;&lt;/Item5&gt;&lt;Item6&gt;&lt;Variable&gt;=$.occ_month&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00%&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;11&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item6&gt;&lt;Item7&gt;&lt;Variable&gt;=$.occ_yoy&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00%&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;13&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item7&gt;&lt;Item8&gt;&lt;Variable&gt;=$.occ_wcl&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00%&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;15&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item8&gt;&lt;Item9&gt;&lt;Variable&gt;=$.food_month&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;6&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item9&gt;&lt;Item10&gt;&lt;Variable&gt;=$.food_lmonth&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;7&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item10&gt;&lt;Item11&gt;&lt;Variable&gt;=$.food_yoy&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00%&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;8&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item11&gt;&lt;Item12&gt;&lt;Variable&gt;=$.food_pmonth&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;9&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item12&gt;&lt;Item13&gt;&lt;Variable&gt;=$.food_wcl&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00%&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;10&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item13&gt;&lt;Item14&gt;&lt;Variable&gt;=$.occ_lmonth&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00%&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;12&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item14&gt;&lt;Item15&gt;&lt;Variable&gt;=$.occ_pmonth&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00%&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;14&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item15&gt;&lt;Item16&gt;&lt;Variable&gt;=$.revpar_month&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;21&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item16&gt;&lt;Item17&gt;&lt;Variable&gt;=$.revpar_lmonth&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;22&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item17&gt;&lt;Item18&gt;&lt;Variable&gt;=$.revpar_yoy&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00%&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;23&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item18&gt;&lt;Item19&gt;&lt;Variable&gt;=$.revpar_pmonth&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;24&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item19&gt;&lt;Item20&gt;&lt;Variable&gt;=$.revpar_wcl&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00%&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;25&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item20&gt;&lt;Item21&gt;&lt;Variable&gt;=$.adr_month&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;16&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item21&gt;&lt;Item22&gt;&lt;Variable&gt;=$.adr_lmonth&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;17&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item22&gt;&lt;Item23&gt;&lt;Variable&gt;=$.adr_yoy&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00%&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;18&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item23&gt;&lt;Item24&gt;&lt;Variable&gt;=$.adr_pmonth&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;19&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item24&gt;&lt;Item25&gt;&lt;Variable&gt;=$.adr_wcl&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.00%&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;20&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item25&gt;&lt;/Children&gt;&lt;NodePath&gt;Row&lt;/NodePath&gt;&lt;BeforePrint&gt;if($.hotel=="合计"){
	
	me.backColor = new Color(215,215,215);
	me.font = new Font("宋体",Font.BOLD,12);
}else{
	me.backColor = null;
	me.font = new Font("宋体",Font.PLAIN,12);
}&lt;/BeforePrint&gt;&lt;/Item2&gt;&lt;/Children&gt;&lt;ColumnWidths&gt;142,37,37,52,37,53,37,37,52,37,53,53,53,53,53,53,52,52,52,52,53,52,52,52,52,53&lt;/ColumnWidths&gt;&lt;RowHeights&gt;20,40,20,20,20,20,20,20&lt;/RowHeights&gt;&lt;/Item0&gt;&lt;/Children&gt;&lt;Type&gt;102&lt;/Type&gt;&lt;/Item0&gt;&lt;/Children&gt;&lt;PageFormat&gt;&lt;Width&gt;1403&lt;/Width&gt;&lt;Height&gt;992&lt;/Height&gt;&lt;Left&gt;18&lt;/Left&gt;&lt;Top&gt;18&lt;/Top&gt;&lt;Right&gt;19&lt;/Right&gt;&lt;Bottom&gt;19&lt;/Bottom&gt;&lt;Orientation&gt;0&lt;/Orientation&gt;&lt;/PageFormat&gt;&lt;/Page&gt;&lt;NodeSource&gt;&lt;Children ItemClass="DatasetNodeSource"&gt;&lt;Item0&gt;&lt;Children ItemClass="RowNodeSource"&gt;&lt;Item0/&gt;&lt;/Children&gt;&lt;Reader Class="com.foxhis.data.reader.SelfReader"&gt;&lt;Name&gt;hzq&lt;/Name&gt;&lt;Sql&gt;with 
-- 基础数据：按酒店聚合各指标
hotel_data as (
    select 
        b.hotelid,
        b.descript as hotel,
        -- 客房收入 (cls='010110')
        max(case when a.cls = '010110' then a.month + a.month_rebate end) as room_month,
        max(case when a.cls = '010110' then a.lmonth + a.lmonth_rebate end) as room_lmonth,
        max(case when a.cls = '010110' then a.pmonth end) as room_pmonth,
        -- 餐饮收入 (cls='020299')
        max(case when a.cls = '020299' then a.month + a.month_rebate end) as food_month,
        max(case when a.cls = '020299' then a.lmonth + a.lmonth_rebate end) as food_lmonth,
        max(case when a.cls = '020299' then a.pmonth end) as food_pmonth,
        -- 已售间夜数 (cls='010030')
        max(case when a.cls = '010030' then a.month end) as sold_room_month,
        max(case when a.cls = '010030' then a.lmonth end) as sold_room_lmonth,
        max(case when a.cls = '010030' then a.pmonth end) as sold_room_pmonth,
        -- 可售间夜数 (cls='010020')
        max(case when a.cls = '010020' then a.month end) as avail_room_month,
        max(case when a.cls = '010020' then a.lmonth end) as avail_room_lmonth,
        max(case when a.cls = '010020' then a.pmonth end) as avail_room_pmonth
    from yjourrep a
    join hotelid b on a.hotelid = b.hotelid
    where a.date = '${selectDate}'
      and a.cls in ('010110', '020299', '010030', '010020')
    group by b.hotelid, b.descript
),

-- 计算明细指标
detail as (
    select 
        hotel,
        -- 客房收入（万元）
        round(room_month / 10000, 2) as room_month,
        round(room_lmonth / 10000, 2) as room_lmonth,
        round(room_pmonth / 10000, 2) as room_pmonth,
        -- 客房收入同比率
        case when room_lmonth != 0 then (room_month - room_lmonth) / room_lmonth end as room_yoy,
        -- 客房收入完成率
        case when room_pmonth != 0 then room_month / room_pmonth end as room_wcl,
        
        -- 餐饮收入（万元）
        round(food_month / 10000, 2) as food_month,
        round(food_lmonth / 10000, 2) as food_lmonth,
        round(food_pmonth / 10000, 2) as food_pmonth,
        -- 餐饮收入同比率
        case when food_lmonth != 0 then (food_month - food_lmonth) / food_lmonth end as food_yoy,
        -- 餐饮收入完成率
        case when food_pmonth != 0 then food_month / food_pmonth end as food_wcl,
        
        -- 出租率 = 已售间夜 / 可售间夜（百分比数值，如 65 表示 65%）
        case when avail_room_month != 0 then round(sold_room_month / avail_room_month, 2) end as occ_month,
        case when avail_room_lmonth != 0 then round(sold_room_lmonth / avail_room_lmonth, 2) end as occ_lmonth,
        case when avail_room_pmonth != 0 then round(sold_room_pmonth / avail_room_pmonth, 2) end as occ_pmonth,
        -- 出租率同比率
        case when avail_room_lmonth != 0 and sold_room_lmonth != 0 
             then (sold_room_month / avail_room_month - sold_room_lmonth / avail_room_lmonth) / (sold_room_lmonth / avail_room_lmonth)
        end as occ_yoy,
        -- 出租率完成率
        case when avail_room_pmonth != 0 and sold_room_pmonth != 0
             then (sold_room_month / avail_room_month) / (sold_room_pmonth / avail_room_pmonth)
        end as occ_wcl,
        
        -- ADR = 客房收入 / 已售间夜
        case when sold_room_month != 0 then round(room_month / sold_room_month, 2) end as adr_month,
        case when sold_room_lmonth != 0 then round(room_lmonth / sold_room_lmonth, 2) end as adr_lmonth,
        case when sold_room_pmonth != 0 then round(room_pmonth / sold_room_pmonth, 2) end as adr_pmonth,
        -- ADR同比率
        case when sold_room_lmonth != 0 and room_lmonth != 0
             then (room_month / sold_room_month - room_lmonth / sold_room_lmonth) / (room_lmonth / sold_room_lmonth)
        end as adr_yoy,
        -- ADR完成率
        case when sold_room_pmonth != 0 and room_pmonth != 0
             then (room_month / sold_room_month) / (room_pmonth / sold_room_pmonth)
        end as adr_wcl,
        
        -- REVPAR = 客房收入 / 可售间夜
        case when avail_room_month != 0 then round(room_month / avail_room_month, 2) end as revpar_month,
        case when avail_room_lmonth != 0 then round(room_lmonth / avail_room_lmonth, 2) end as revpar_lmonth,
        case when avail_room_pmonth != 0 then round(room_pmonth / avail_room_pmonth, 2) end as revpar_pmonth,
        -- REVPAR同比率
        case when avail_room_lmonth != 0 and room_lmonth != 0
             then (room_month / avail_room_month - room_lmonth / avail_room_lmonth) / (room_lmonth / avail_room_lmonth)
        end as revpar_yoy,
        -- REVPAR完成率
        case when avail_room_pmonth != 0 and room_pmonth != 0
             then (room_month / avail_room_month) / (room_pmonth / avail_room_pmonth)
        end as revpar_wcl
    from hotel_data
),

-- 合计行
total as (
    select 
        '合计' as hotel,
        
        -- 客房收入（万元）
        round(sum(room_month) / 10000, 2) as room_month,
        round(sum(room_lmonth) / 10000, 2) as room_lmonth,
        round(sum(room_pmonth) / 10000, 2) as room_pmonth,
        -- 客房收入同比率
        case when sum(room_lmonth) != 0 
             then (sum(room_month) - sum(room_lmonth)) / sum(room_lmonth) 
        end as room_yoy,
        -- 客房收入完成率
        case when sum(room_pmonth) != 0 
             then sum(room_month) / sum(room_pmonth) 
        end as room_wcl,
        
        -- 餐饮收入（万元）
        round(sum(food_month) / 10000, 2) as food_month,
        round(sum(food_lmonth) / 10000, 2) as food_lmonth,
        round(sum(food_pmonth) / 10000, 2) as food_pmonth,
        -- 餐饮收入同比率
        case when sum(food_lmonth) != 0 
             then (sum(food_month) - sum(food_lmonth)) / sum(food_lmonth) 
        end as food_yoy,
        -- 餐饮收入完成率
        case when sum(food_pmonth) != 0 
             then sum(food_month) / sum(food_pmonth) 
        end as food_wcl,
        
        -- 出租率合计（百分比数值）
        case when sum(avail_room_month) != 0 
             then round(sum(sold_room_month) / sum(avail_room_month), 2)
        end as occ_month,
        case when sum(avail_room_lmonth) != 0 
             then round(sum(sold_room_lmonth) / sum(avail_room_lmonth), 2)
        end as occ_lmonth,
        case when sum(avail_room_pmonth) != 0 
             then round(sum(sold_room_pmonth) / sum(avail_room_pmonth), 2)
        end as occ_pmonth,
        -- 出租率同比率
        case when sum(avail_room_lmonth) != 0 and sum(sold_room_lmonth) != 0
             then (sum(sold_room_month)/sum(avail_room_month) - sum(sold_room_lmonth)/sum(avail_room_lmonth)) 
                  / (sum(sold_room_lmonth)/sum(avail_room_lmonth))
        end as occ_yoy,
        -- 出租率完成率
        case when sum(avail_room_pmonth) != 0 and sum(sold_room_pmonth) != 0
             then (sum(sold_room_month)/sum(avail_room_month)) / (sum(sold_room_pmonth)/sum(avail_room_pmonth))
        end as occ_wcl,
        
        -- ADR合计
        case when sum(sold_room_month) != 0 
             then round(sum(room_month) / sum(sold_room_month), 2)
        end as adr_month,
        case when sum(sold_room_lmonth) != 0 
             then round(sum(room_lmonth) / sum(sold_room_lmonth), 2)
        end as adr_lmonth,
        case when sum(sold_room_pmonth) != 0 
             then round(sum(room_pmonth) / sum(sold_room_pmonth), 2)
        end as adr_pmonth,
        -- ADR同比率
        case when sum(sold_room_lmonth) != 0 and sum(room_lmonth) != 0
             then (sum(room_month)/sum(sold_room_month) - sum(room_lmonth)/sum(sold_room_lmonth))
                  / (sum(room_lmonth)/sum(sold_room_lmonth))
        end as adr_yoy,
        -- ADR完成率
        case when sum(sold_room_pmonth) != 0 and sum(room_pmonth) != 0
             then (sum(room_month)/sum(sold_room_month)) / (sum(room_pmonth)/sum(sold_room_pmonth))
        end as adr_wcl,
        
        -- REVPAR合计
        case when sum(avail_room_month) != 0 
             then round(sum(room_month) / sum(avail_room_month), 2)
        end as revpar_month,
        case when sum(avail_room_lmonth) != 0 
             then round(sum(room_lmonth) / sum(avail_room_lmonth), 2)
        end as revpar_lmonth,
        case when sum(avail_room_pmonth) != 0 
             then round(sum(room_pmonth) / sum(avail_room_pmonth), 2)
        end as revpar_pmonth,
        -- REVPAR同比率
        case when sum(avail_room_lmonth) != 0 and sum(room_lmonth) != 0
             then (sum(room_month)/sum(avail_room_month) - sum(room_lmonth)/sum(avail_room_lmonth))
                  / (sum(room_lmonth)/sum(avail_room_lmonth))
        end as revpar_yoy,
        -- REVPAR完成率
        case when sum(avail_room_pmonth) != 0 and sum(room_pmonth) != 0
             then (sum(room_month)/sum(avail_room_month)) / (sum(room_pmonth)/sum(avail_room_pmonth))
        end as revpar_wcl
        
    from hotel_data
)

-- 合并明细和合计
select 
    hotel,
    -- 客房收入
    room_month,
    room_lmonth,
    room_yoy,
    room_pmonth,
    room_wcl,
    -- 餐饮收入
    food_month,
    food_lmonth,
    food_yoy,
    food_pmonth,
    food_wcl,
    -- 出租率
    occ_month,
    occ_lmonth,
    occ_yoy,
    occ_pmonth,
    occ_wcl,
    -- ADR
    adr_month,
    adr_lmonth,
    adr_yoy,
    adr_pmonth,
    adr_wcl,
    -- REVPAR
    revpar_month,
    revpar_lmonth,
    revpar_yoy,
    revpar_pmonth,
    revpar_wcl
from detail

union all

select 
    hotel,
    room_month,
    room_lmonth,
    room_yoy,
    room_pmonth,
    room_wcl,
    food_month,
    food_lmonth,
    food_yoy,
    food_pmonth,
    food_wcl,
    occ_month,
    occ_lmonth,
    occ_yoy,
    occ_pmonth,
    occ_wcl,
    adr_month,
    adr_lmonth,
    adr_yoy,
    adr_pmonth,
    adr_wcl,
    revpar_month,
    revpar_lmonth,
    revpar_yoy,
    revpar_pmonth,
    revpar_wcl
from total

order by  case when hotel = '合计' then 1 else 0 end, hotel&lt;/Sql&gt;&lt;Description&gt;with 
-- 基础数据：按酒店聚合各指标
hotel_data as (
    select 
        b.hotelid,
        b.descript as hotel,
        -- 客房收入 (cls='010110')
        max(case when a.cls = '010110' then a.month + a.month_rebate end) as room_month,
        max(case when a.cls = '010110' then a.lmonth + a.lmonth_rebate end) as room_lmonth,
        max(case when a.cls = '010110' then a.pmonth end) as room_pmonth,
        -- 餐饮收入 (cls='020299')
        max(case when a.cls = '020299' then a.month + a.month_rebate end) as food_month,
        max(case when a.cls = '020299' then a.lmonth + a.lmonth_rebate end) as food_lmonth,
        max(case when a.cls = '020299' then a.pmonth end) as food_pmonth,
        -- 已售间夜数 (cls='010030')
        max(case when a.cls = '010030' then a.month end) as sold_room_month,
        max(case when a.cls = '010030' then a.lmonth end) as sold_room_lmonth,
        max(case when a.cls = '010030' then a.pmonth end) as sold_room_pmonth,
        -- 可售间夜数 (cls='010020')
        max(case when a.cls = '010020' then a.month end) as avail_room_month,
        max(case when a.cls = '010020' then a.lmonth end) as avail_room_lmonth,
        max(case when a.cls = '010020' then a.pmonth end) as avail_room_pmonth
    from yjourrep a
    join hotelid b on a.hotelid = b.hotelid
    where a.date = '${selectDate}'
      and a.cls in ('010110', '020299', '010030', '010020')
    group by b.hotelid, b.descript
),

-- 计算明细指标
detail as (
    select 
        hotel,
        -- 客房收入（万元）
        round(room_month / 10000, 2) as room_month,
        round(room_lmonth / 10000, 2) as room_lmonth,
        round(room_pmonth / 10000, 2) as room_pmonth,
        -- 客房收入同比率
        case when room_lmonth != 0 then (room_month - room_lmonth) / room_lmonth end as room_yoy,
        -- 客房收入完成率
        case when room_pmonth != 0 then room_month / room_pmonth end as room_wcl,
        
        -- 餐饮收入（万元）
        round(food_month / 10000, 2) as food_month,
        round(food_lmonth / 10000, 2) as food_lmonth,
        round(food_pmonth / 10000, 2) as food_pmonth,
        -- 餐饮收入同比率
        case when food_lmonth != 0 then (food_month - food_lmonth) / food_lmonth end as food_yoy,
        -- 餐饮收入完成率
        case when food_pmonth != 0 then food_month / food_pmonth end as food_wcl,
        
        -- 出租率 = 已售间夜 / 可售间夜（百分比数值，如 65 表示 65%）
        case when avail_room_month != 0 then round(sold_room_month / avail_room_month, 2) end as occ_month,
        case when avail_room_lmonth != 0 then round(sold_room_lmonth / avail_room_lmonth, 2) end as occ_lmonth,
        case when avail_room_pmonth != 0 then round(sold_room_pmonth / avail_room_pmonth, 2) end as occ_pmonth,
        -- 出租率同比率
        case when avail_room_lmonth != 0 and sold_room_lmonth != 0 
             then (sold_room_month / avail_room_month - sold_room_lmonth / avail_room_lmonth) / (sold_room_lmonth / avail_room_lmonth)
        end as occ_yoy,
        -- 出租率完成率
        case when avail_room_pmonth != 0 and sold_room_pmonth != 0
             then (sold_room_month / avail_room_month) / (sold_room_pmonth / avail_room_pmonth)
        end as occ_wcl,
        
        -- ADR = 客房收入 / 已售间夜
        case when sold_room_month != 0 then round(room_month / sold_room_month, 2) end as adr_month,
        case when sold_room_lmonth != 0 then round(room_lmonth / sold_room_lmonth, 2) end as adr_lmonth,
        case when sold_room_pmonth != 0 then round(room_pmonth / sold_room_pmonth, 2) end as adr_pmonth,
        -- ADR同比率
        case when sold_room_lmonth != 0 and room_lmonth != 0
             then (room_month / sold_room_month - room_lmonth / sold_room_lmonth) / (room_lmonth / sold_room_lmonth)
        end as adr_yoy,
        -- ADR完成率
        case when sold_room_pmonth != 0 and room_pmonth != 0
             then (room_month / sold_room_month) / (room_pmonth / sold_room_pmonth)
        end as adr_wcl,
        
        -- REVPAR = 客房收入 / 可售间夜
        case when avail_room_month != 0 then round(room_month / avail_room_month, 2) end as revpar_month,
        case when avail_room_lmonth != 0 then round(room_lmonth / avail_room_lmonth, 2) end as revpar_lmonth,
        case when avail_room_pmonth != 0 then round(room_pmonth / avail_room_pmonth, 2) end as revpar_pmonth,
        -- REVPAR同比率
        case when avail_room_lmonth != 0 and room_lmonth != 0
             then (room_month / avail_room_month - room_lmonth / avail_room_lmonth) / (room_lmonth / avail_room_lmonth)
        end as revpar_yoy,
        -- REVPAR完成率
        case when avail_room_pmonth != 0 and room_pmonth != 0
             then (room_month / avail_room_month) / (room_pmonth / avail_room_pmonth)
        end as revpar_wcl
    from hotel_data
),

-- 合计行
total as (
    select 
        '合计' as hotel,
        
        -- 客房收入（万元）
        round(sum(room_month) / 10000, 2) as room_month,
        round(sum(room_lmonth) / 10000, 2) as room_lmonth,
        round(sum(room_pmonth) / 10000, 2) as room_pmonth,
        -- 客房收入同比率
        case when sum(room_lmonth) != 0 
             then (sum(room_month) - sum(room_lmonth)) / sum(room_lmonth) 
        end as room_yoy,
        -- 客房收入完成率
        case when sum(room_pmonth) != 0 
             then sum(room_month) / sum(room_pmonth) 
        end as room_wcl,
        
        -- 餐饮收入（万元）
        round(sum(food_month) / 10000, 2) as food_month,
        round(sum(food_lmonth) / 10000, 2) as food_lmonth,
        round(sum(food_pmonth) / 10000, 2) as food_pmonth,
        -- 餐饮收入同比率
        case when sum(food_lmonth) != 0 
             then (sum(food_month) - sum(food_lmonth)) / sum(food_lmonth) 
        end as food_yoy,
        -- 餐饮收入完成率
        case when sum(food_pmonth) != 0 
             then sum(food_month) / sum(food_pmonth) 
        end as food_wcl,
        
        -- 出租率合计（百分比数值）
        case when sum(avail_room_month) != 0 
             then round(sum(sold_room_month) / sum(avail_room_month), 2)
        end as occ_month,
        case when sum(avail_room_lmonth) != 0 
             then round(sum(sold_room_lmonth) / sum(avail_room_lmonth), 2)
        end as occ_lmonth,
        case when sum(avail_room_pmonth) != 0 
             then round(sum(sold_room_pmonth) / sum(avail_room_pmonth), 2)
        end as occ_pmonth,
        -- 出租率同比率
        case when sum(avail_room_lmonth) != 0 and sum(sold_room_lmonth) != 0
             then (sum(sold_room_month)/sum(avail_room_month) - sum(sold_room_lmonth)/sum(avail_room_lmonth)) 
                  / (sum(sold_room_lmonth)/sum(avail_room_lmonth))
        end as occ_yoy,
        -- 出租率完成率
        case when sum(avail_room_pmonth) != 0 and sum(sold_room_pmonth) != 0
             then (sum(sold_room_month)/sum(avail_room_month)) / (sum(sold_room_pmonth)/sum(avail_room_pmonth))
        end as occ_wcl,
        
        -- ADR合计
        case when sum(sold_room_month) != 0 
             then round(sum(room_month) / sum(sold_room_month), 2)
        end as adr_month,
        case when sum(sold_room_lmonth) != 0 
             then round(sum(room_lmonth) / sum(sold_room_lmonth), 2)
        end as adr_lmonth,
        case when sum(sold_room_pmonth) != 0 
             then round(sum(room_pmonth) / sum(sold_room_pmonth), 2)
        end as adr_pmonth,
        -- ADR同比率
        case when sum(sold_room_lmonth) != 0 and sum(room_lmonth) != 0
             then (sum(room_month)/sum(sold_room_month) - sum(room_lmonth)/sum(sold_room_lmonth))
                  / (sum(room_lmonth)/sum(sold_room_lmonth))
        end as adr_yoy,
        -- ADR完成率
        case when sum(sold_room_pmonth) != 0 and sum(room_pmonth) != 0
             then (sum(room_month)/sum(sold_room_month)) / (sum(room_pmonth)/sum(sold_room_pmonth))
        end as adr_wcl,
        
        -- REVPAR合计
        case when sum(avail_room_month) != 0 
             then round(sum(room_month) / sum(avail_room_month), 2)
        end as revpar_month,
        case when sum(avail_room_lmonth) != 0 
             then round(sum(room_lmonth) / sum(avail_room_lmonth), 2)
        end as revpar_lmonth,
        case when sum(avail_room_pmonth) != 0 
             then round(sum(room_pmonth) / sum(avail_room_pmonth), 2)
        end as revpar_pmonth,
        -- REVPAR同比率
        case when sum(avail_room_lmonth) != 0 and sum(room_lmonth) != 0
             then (sum(room_month)/sum(avail_room_month) - sum(room_lmonth)/sum(avail_room_lmonth))
                  / (sum(room_lmonth)/sum(avail_room_lmonth))
        end as revpar_yoy,
        -- REVPAR完成率
        case when sum(avail_room_pmonth) != 0 and sum(room_pmonth) != 0
             then (sum(room_month)/sum(avail_room_month)) / (sum(room_pmonth)/sum(avail_room_pmonth))
        end as revpar_wcl
        
    from hotel_data
)

-- 合并明细和合计
select 
    hotel,
    -- 客房收入
    room_month,
    room_lmonth,
    room_yoy,
    room_pmonth,
    room_wcl,
    -- 餐饮收入
    food_month,
    food_lmonth,
    food_yoy,
    food_pmonth,
    food_wcl,
    -- 出租率
    occ_month,
    occ_lmonth,
    occ_yoy,
    occ_pmonth,
    occ_wcl,
    -- ADR
    adr_month,
    adr_lmonth,
    adr_yoy,
    adr_pmonth,
    adr_wcl,
    -- REVPAR
    revpar_month,
    revpar_lmonth,
    revpar_yoy,
    revpar_pmonth,
    revpar_wcl
from detail

union all

select 
    hotel,
    room_month,
    room_lmonth,
    room_yoy,
    room_pmonth,
    room_wcl,
    food_month,
    food_lmonth,
    food_yoy,
    food_pmonth,
    food_wcl,
    occ_month,
    occ_lmonth,
    occ_yoy,
    occ_pmonth,
    occ_wcl,
    adr_month,
    adr_lmonth,
    adr_yoy,
    adr_pmonth,
    adr_wcl,
    revpar_month,
    revpar_lmonth,
    revpar_yoy,
    revpar_pmonth,
    revpar_wcl
from total

order by  case when hotel = '合计' then 1 else 0 end, hotel&lt;/Description&gt;&lt;/Reader&gt;&lt;TagName&gt;hzq&lt;/TagName&gt;&lt;/Item0&gt;&lt;/Children&gt;&lt;/NodeSource&gt;&lt;/jatools&gt;</syntax>
</foxreport>
