b2620452-5fd1-4e7b-9595-5c7f6c879642<?xml version="1.0" encoding="UTF-8"?>

<foxreport>
<locale name="zh_CN"/>
<title text="营业日报表"/>
<parms>
<parm name="begindate" text="" class="java.lang.String" value="$bdate$-1$" fixed="false" visiable="false" index="0" refid="reportDateTextField"/>
<parm name="enddate" text="" class="java.lang.String" value="$bdate$-1$" fixed="false" visiable="false" index="1" refid="reportDateTextField"/>
<parm name="SYS_TRANSLATE_COLUMNS" text="系统翻译变量" class="java.lang.String" value="[{&quot;columnname&quot;:&quot;descript&quot;,&quot;descript&quot;:&quot;项目&quot;,&quot;descript2&quot;:&quot;项目&quot;,&quot;descript1&quot;:&quot;项目&quot;},{&quot;columnname&quot;:&quot;day&quot;,&quot;descript&quot;:&quot;本日发生&quot;,&quot;descript2&quot;:&quot;本日发生&quot;,&quot;descript1&quot;:&quot;本日发生&quot;},{&quot;columnname&quot;:&quot;day_rebate&quot;,&quot;descript&quot;:&quot;本日rebate&quot;,&quot;descript2&quot;:&quot;本日rebate&quot;,&quot;descript1&quot;:&quot;本日rebate&quot;},{&quot;columnname&quot;:&quot;month&quot;,&quot;descript&quot;:&quot;本月发生&quot;,&quot;descript2&quot;:&quot;本月发生&quot;,&quot;descript1&quot;:&quot;本月发生&quot;},{&quot;columnname&quot;:&quot;month_rebate&quot;,&quot;descript&quot;:&quot;本月rebate&quot;,&quot;descript2&quot;:&quot;本月rebate&quot;,&quot;descript1&quot;:&quot;本月rebate&quot;},{&quot;columnname&quot;:&quot;pmonth&quot;,&quot;descript&quot;:&quot;月计划&quot;,&quot;descript2&quot;:&quot;月计划&quot;,&quot;descript1&quot;:&quot;月计划&quot;},{&quot;columnname&quot;:&quot;lmonth&quot;,&quot;descript&quot;:&quot;月完成&quot;,&quot;descript2&quot;:&quot;月完成&quot;,&quot;descript1&quot;:&quot;月完成&quot;},{&quot;columnname&quot;:&quot;year&quot;,&quot;descript&quot;:&quot;本年发生&quot;,&quot;descript2&quot;:&quot;本年发生&quot;,&quot;descript1&quot;:&quot;本年发生&quot;},{&quot;columnname&quot;:&quot;year_rebate&quot;,&quot;descript&quot;:&quot;本年rebate&quot;,&quot;descript2&quot;:&quot;本年rebate&quot;,&quot;descript1&quot;:&quot;本年rebate&quot;},{&quot;columnname&quot;:&quot;lyear&quot;,&quot;descript&quot;:&quot;年完成&quot;,&quot;descript2&quot;:&quot;年完成&quot;,&quot;descript1&quot;:&quot;年完成&quot;},{&quot;columnname&quot;:&quot;pyear&quot;,&quot;descript&quot;:&quot;年计划&quot;,&quot;descript2&quot;:&quot;年计划&quot;,&quot;descript1&quot;:&quot;年计划&quot;},{&quot;columnname&quot;:&quot;lday&quot;,&quot;descript&quot;:&quot;天完成&quot;,&quot;descript2&quot;:&quot;天完成&quot;,&quot;descript1&quot;:&quot;天完成&quot;}]" fixed="true" visiable="false" index="0" refid="jtextfield"/>
</parms>
<pramform store="class" builder="com.foxhis.report.DefaultReportParmBuilder" dialog="false">com.foxhis.crs.reportcond.StandardMultPmsPanel</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="jatools.data.Formula" Name="m_getIncome_day"&gt;&lt;Text&gt;return format(toDouble($.day) + toDouble($.day_rebate),"###,##0.00");&lt;/Text&gt;&lt;/Item0&gt;&lt;Item1 Class="jatools.data.Formula" Name="m_getIncome_month"&gt;&lt;Text&gt;return format(toDouble($.month) + toDouble($.month_rebate),"###,##0.00");&lt;/Text&gt;&lt;/Item1&gt;&lt;Item2 Class="jatools.data.Formula" Name="m_getIncome_year"&gt;&lt;Text&gt;return format(toDouble($.year) + toDouble($.year_rebate),"###,##0.00");&lt;/Text&gt;&lt;/Item2&gt;&lt;Item3 Class="jatools.data.Formula" Name="m_getComp_month"&gt;&lt;Text&gt;double pmonth = toDouble($.pmonth);
if(pmonth == 0){
	return "0.00";
}else{
	return format((toDouble($.month) + toDouble($.month_rebate))/pmonth*100,"#####0.00");	
}
&lt;/Text&gt;&lt;/Item3&gt;&lt;Item4 Class="jatools.data.Formula" Name="m_getComp_year"&gt;&lt;Text&gt;double pyear = toDouble($.pyear);
if(pyear == 0){
	return "0.00";
}else{
	return format((toDouble($.year) + toDouble($.year_rebate))/pyear*100,"#####0.00");	
}&lt;/Text&gt;&lt;/Item4&gt;&lt;Item5 Class="jatools.data.Formula" Name="m_getContrast_day"&gt;&lt;Text&gt;double lday = toDouble($.lday);
if(lday == 0){
	return "0.00";
}else{
	return format((toDouble($.day) + toDouble($.day_rebate))/lday,"#####0.00");	
}&lt;/Text&gt;&lt;/Item5&gt;&lt;Item6 Class="jatools.data.Formula" Name="m_getContrast_month"&gt;&lt;Text&gt;double lmonth = toDouble($.lmonth);
if(lmonth == 0){
	return "0.00";
}else{
	return format((toDouble($.month) + toDouble($.month_rebate))/lmonth,"#####0.00");	
}&lt;/Text&gt;&lt;/Item6&gt;&lt;Item7 Class="jatools.data.Formula" Name="m_getContrast_year"&gt;&lt;Text&gt;double lyear = toDouble($.lyear);
if(lyear == 0){
	return "0.00";
}else{
	return format((toDouble($.year) + toDouble($.year_rebate))/lyear,"#####0.00");	
}&lt;/Text&gt;&lt;/Item7&gt;&lt;Item8 Class="jatools.data.Formula" Name="m_getSql_pyear"&gt;&lt;Text&gt;if(model == "3"){
	return " IFNULL((select sum(pmonth) from jourrep_plan as c where c.year=YEAR('" + selectDate + "') and c.cls=a.cls and c.hotelid=a.hotelid),0.00) ";
}else{
	return " a.pyear ";
}&lt;/Text&gt;&lt;/Item8&gt;&lt;Item9 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;/Item9&gt;&lt;Item10 Class="jatools.data.Formula" Name="event1"&gt;&lt;Text&gt;String ismarket = $.ismarket;
String ispccode = $.ispccode;
String impindex = $.impindex;
String cls_market = "";
if(length(impindex)&amp;gt;0) {
	cls_market = impindex;
} else {
	cls_market = $.cls;
}
String sql = " ";
if(!"F".equals(ismarket)){
	sql = " and market in (select code from basecode where exts2 in ('"+cls_market+"') and ((hotelid in ('"+groupid+"') and share in ('T')) or (hotelid in ('"+brandid+"') and share in ('T')) or hotelid in ('"+hotelid+"')))";
	print(sql);
	return "openreport?rptid=1047&amp;amp;toDate="+selectDate+"&amp;amp;fromDate="+selectDate+"&amp;amp;marketsql="+sql;
}else if(!"F".equals(ispccode)){
	String sql2=" and a.pccode in (select pccode from pccode where jierep in ('"+$.cls+"') and ((hotelid in ('"+groupid+"') and share in ('T')) or (hotelid in ('"+brandid+"') and share in ('T')) or hotelid in ('"+hotelid+"')))";
	String hsql2=" and h.pccode in (select pccode from pccode where jierep in ('"+$.cls+"') and ((hotelid in ('"+groupid+"') and share in ('T')) or (hotelid in ('"+brandid+"') and share in ('T')) or hotelid in ('"+hotelid+"')))";
	return "openreport?rptid=73&amp;amp;m_model=1&amp;amp;m_date="+selectDate+"&amp;amp;m_enddate="+selectDate+
					"&amp;amp;m_cash=all&amp;amp;m_emp=all&amp;amp;m_term="+sql2+"&amp;amp;hm_term="+hsql2;
}else {
	return "";
}
&lt;/Text&gt;&lt;/Item10&gt;&lt;Item11 Class="jatools.data.Formula" Name="event2"&gt;&lt;Text&gt;String ismarket = $.ismarket;
String ispccode = $.ispccode;
String impindex = $.impindex;
String cls_market = "";
if(length(impindex)&amp;gt;0) {
	cls_market = impindex;
} else {
	cls_market = $.cls;
}
String sql = " ";
if(!"F".equals(ismarket)){
	
	sql = " and market in (select code from basecode where exts2 in ('"+cls_market+"')";
	if(!(ifNull(groupid,"") == "")){
		sql+="and ((hotelid in ('"+groupid+"'))";
		if(!(ifNull(brandid,"") == "")){
			sql+="or (hotelid in ('"+brandid+"'))";
		}
		if(!(ifNull(hotelid,"") == "")){
			sql+="or (hotelid in ('"+hotelid+"'))";
		}
		sql+=")";
	}else{
		if(!(ifNull(brandid,"") == "")){
			sql+="and ((hotelid in ('"+brandid+"'))";
			if(!(ifNull(hotelid,"") == "")){
			sql+="or (hotelid in ('"+hotelid+"'))";
			}
			sql+=")";
		}else{
			if(!(ifNull(hotelid,"") == "")){
				sql+="and ((hotelid in ('"+brandid+"')))";
			}
		}	
	}
	sql+=")";
	print(sql);
	String ret="openreport?rptid=SYS102&amp;amp;week=(1,2,3,4,5,6,7)&amp;amp;m_hotels="+getSqlStr(selectedhotelid)+"&amp;amp;toDate="+selectDate+"&amp;amp;fromDate="+selectDate+"&amp;amp;marketsql="+sql;
	print(ret);
	return ret;
}else if(!"F".equals(ispccode)){
	if("".equals(impindex)){
		impindex="empty";
		}
	return "openreport?rptid=SYS156&amp;amp;m_model=1&amp;amp;m_date="+selectDate+"&amp;amp;m_enddate="+selectDate+
					"&amp;amp;m_cash=all&amp;amp;m_emp=all&amp;amp;m_pccode=empty&amp;amp;m_impindex="+impindex+"&amp;amp;m_cls="+$.cls+"&amp;amp;m_hotelid="+selectedhotelid;
}else if("ooo".equals(impindex)){
	String table_os = "rm_ooo";
	String flag2 = "1";
	String flag1 = "0";
	String flag3 = selectDate;
	String flag4 = selectDate;
	return "openreport?rptid=SYS425V4&amp;amp;table_os="+table_os+"&amp;amp;flag2="+flag2+"&amp;amp;flag1="+flag1+"&amp;amp;flag3="+flag3+"&amp;amp;flag4="+flag4+"&amp;amp;selectDate="+selectDate+"&amp;amp;m_hotelid="+selectedhotelid;
}else{
	return "";
}
&lt;/Text&gt;&lt;/Item11&gt;&lt;Item12 Class="jatools.data.Formula" Name="m_getSql_pmonth"&gt;&lt;Text&gt;if(model == "3"){
	return " IFNULL((select sum(pmonth) from jourrep_plan as c where c.month=MONTH('" + selectDate + "') and c.year=YEAR('" + selectDate + "') and c.cls=a.cls and c.hotelid=a.hotelid),0.00) ";
}else{
	return " a.pmonth ";
}&lt;/Text&gt;&lt;/Item12&gt;&lt;Item13 Class="jatools.data.Formula" Name="gczl"&gt;&lt;Text&gt;return format($.czl/100, "0.00%");

&lt;/Text&gt;&lt;/Item13&gt;&lt;Item14 Class="jatools.data.Formula" Name="gsczl"&gt;&lt;Text&gt;double total =toDouble(safei.sczl.sum());
return format(total/100, "0.00%");&lt;/Text&gt;&lt;/Item14&gt;&lt;Item15 Class="jatools.data.Formula" Name="gspjfj"&gt;&lt;Text&gt;double total =toDouble(safei.spjfj.sum());
return format(total,"0.00");&lt;/Text&gt;&lt;/Item15&gt;&lt;/VariableContext&gt;&lt;Page&gt;&lt;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Children ItemClass="PagePanel"&gt;&lt;Item0&gt;&lt;PrintStyle&gt;print-mode:everypage;visible:true;&lt;/PrintStyle&gt;&lt;Width&gt;756&lt;/Width&gt;&lt;Height&gt;1085&lt;/Height&gt;&lt;Children ItemClass="Table"&gt;&lt;Item0&gt;&lt;NodePath&gt;afei&lt;/NodePath&gt;&lt;Children&gt;&lt;Item0 Class="RowPanel"&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;ColSpan&gt;5&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;Children ItemClass="Text"&gt;&lt;Item0&gt;&lt;Variable&gt;=$.xinq&lt;/Variable&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;6&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;me.backColor=null;
if (5==toDouble($.xq) || 6==toDouble($.xq)) {
	me.foreColor = Color.red;
	me.font=java.awt.Font.decode("宋体-BOLD-12");
}
else{
	me.foreColor = Color.black;
	me.font=java.awt.Font.decode("宋体-BOLD-12");
}
&lt;/BeforePrint&gt;&lt;/Item0&gt;&lt;Item1&gt;&lt;Variable&gt;=$.czzs&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;1&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;me.backColor=null;
if (5==toDouble($.xq) || 6==toDouble($.xq)) {
	me.foreColor = Color.red;
	me.font=java.awt.Font.decode("宋体-PLAIN-12");
}
else{
	me.foreColor = Color.black;
	me.font=java.awt.Font.decode("宋体-PLAIN-12");
}
&lt;/BeforePrint&gt;&lt;/Item1&gt;&lt;Item2&gt;&lt;Variable&gt;=$.fzsr&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;me.backColor=null;
if (5==toDouble($.xq) || 6==toDouble($.xq)) {
	me.foreColor = Color.red;
	me.font=java.awt.Font.decode("宋体-PLAIN-12");
}
else{
	me.foreColor = Color.black;
	me.font=java.awt.Font.decode("宋体-PLAIN-12");
}
&lt;/BeforePrint&gt;&lt;/Item2&gt;&lt;Item3&gt;&lt;Variable&gt;=$.pjfj&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;4&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;me.backColor=null;
if (5==toDouble($.xq) || 6==toDouble($.xq)) {
	me.foreColor = Color.red;
	me.font=java.awt.Font.decode("宋体-PLAIN-12");
}
else{
	me.foreColor = Color.black;
	me.font=java.awt.Font.decode("宋体-PLAIN-12");
}
&lt;/BeforePrint&gt;&lt;/Item3&gt;&lt;Item4&gt;&lt;Variable&gt;=gczl&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;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;2&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;me.backColor=null;
if (5==toDouble($.xq) || 6==toDouble($.xq)) {
	me.foreColor = Color.red;
	me.font=java.awt.Font.decode("宋体-PLAIN-12");
}
else{
	me.foreColor = Color.black;
	me.font=java.awt.Font.decode("宋体-PLAIN-12");
}
&lt;/BeforePrint&gt;&lt;/Item4&gt;&lt;/Children&gt;&lt;NodePath&gt;Row&lt;/NodePath&gt;&lt;/Item0&gt;&lt;Item1 Class="Label"&gt;&lt;Text&gt;合计&lt;/Text&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;Font&gt;&lt;Face&gt;宋体&lt;/Face&gt;&lt;Style&gt;1&lt;/Style&gt;&lt;Size&gt;12&lt;/Size&gt;&lt;/Font&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;7&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item1&gt;&lt;Item2 Class="Text"&gt;&lt;Variable&gt;=$.czzs.sum()&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;Font&gt;&lt;Face&gt;宋体&lt;/Face&gt;&lt;Style&gt;1&lt;/Style&gt;&lt;Size&gt;12&lt;/Size&gt;&lt;/Font&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;7&lt;/Row&gt;&lt;Col&gt;1&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item2&gt;&lt;Item3 Class="Text"&gt;&lt;Variable&gt;=$.fzsr.sum()&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;Font&gt;&lt;Face&gt;宋体&lt;/Face&gt;&lt;Style&gt;1&lt;/Style&gt;&lt;Size&gt;12&lt;/Size&gt;&lt;/Font&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;7&lt;/Row&gt;&lt;Col&gt;3&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item3&gt;&lt;Item4 Class="Text"&gt;&lt;Variable&gt;=gsczl&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;Font&gt;&lt;Face&gt;宋体&lt;/Face&gt;&lt;Style&gt;1&lt;/Style&gt;&lt;Size&gt;12&lt;/Size&gt;&lt;/Font&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;7&lt;/Row&gt;&lt;Col&gt;2&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item4&gt;&lt;Item5 Class="Text"&gt;&lt;Variable&gt;=gspjfj&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;Font&gt;&lt;Face&gt;宋体&lt;/Face&gt;&lt;Style&gt;1&lt;/Style&gt;&lt;Size&gt;12&lt;/Size&gt;&lt;/Font&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;7&lt;/Row&gt;&lt;Col&gt;4&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item5&gt;&lt;Item6 Class="RowPanel"&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;5&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;PrintStyle&gt;print-mode:everypage;&lt;/PrintStyle&gt;&lt;Children&gt;&lt;Item0 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;3&lt;/Row&gt;&lt;Col&gt;4&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item0&gt;&lt;Item1 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;3&lt;/Row&gt;&lt;Col&gt;3&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item1&gt;&lt;Item2 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;3&lt;/Row&gt;&lt;Col&gt;2&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item2&gt;&lt;Item3 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;3&lt;/Row&gt;&lt;Col&gt;1&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item3&gt;&lt;Item4 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;3&lt;/Row&gt;&lt;Col&gt;0&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;4&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;3&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;2&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;1&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;0&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item9&gt;&lt;Item10 Class="Text"&gt;&lt;Variable&gt;="统计日期："+begindate+ " 至 " +enddate&lt;/Variable&gt;&lt;Cell&gt;&lt;Row&gt;4&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;ColSpan&gt;3&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item10&gt;&lt;Item11 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;5&lt;/Row&gt;&lt;Col&gt;4&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item11&gt;&lt;Item12 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;5&lt;/Row&gt;&lt;Col&gt;3&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item12&gt;&lt;Item13 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;5&lt;/Row&gt;&lt;Col&gt;2&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item13&gt;&lt;Item14 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;5&lt;/Row&gt;&lt;Col&gt;1&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item14&gt;&lt;Item15 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;5&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item15&gt;&lt;Item16 Class="Text"&gt;&lt;Variable&gt;=printtime&lt;/Variable&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;4&lt;/Row&gt;&lt;Col&gt;3&lt;/Col&gt;&lt;ColSpan&gt;2&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item16&gt;&lt;Item17 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;16&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;5&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item17&gt;&lt;Item18 Class="Text"&gt;&lt;Variable&gt;=reportname&lt;/Variable&gt;&lt;Font&gt;&lt;Face&gt;宋体&lt;/Face&gt;&lt;Style&gt;1&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;5&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item18&gt;&lt;/Children&gt;&lt;/Item6&gt;&lt;/Children&gt;&lt;ColumnWidths&gt;160,90,90,100,90&lt;/ColumnWidths&gt;&lt;RowHeights&gt;20,22,22,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;793&lt;/Width&gt;&lt;Height&gt;1122&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;/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;afei&lt;/Name&gt;&lt;Sql&gt;select a.date,concat(date_format(a.date,'%Y年%m月%d日'),'-(',case weekday(a.date) when '0' then '周一' when '1' then '周二' when '2' then '周三' when '3' then '周四' when '4' then '周五' when '5' then '周六' else '周日' end,')') as xinq ,
(a.day+a.day_rebate) as czzs,(b.day+b.day_rebate) as czl,(c.day+c.day_rebate) as fzsr,(d.day+d.day_rebate) as pjfj,weekday(a.date) as xq from yjourrep a 
left join yjourrep b on a.date=b.date and a.hotelid=b.hotelid and b.cls='010200'
left join yjourrep c on a.date=c.date and a.hotelid=c.hotelid and c.cls='010300'
left join yjourrep d on a.date=d.date and a.hotelid=d.hotelid and d.cls='010400'
where a.cls='010100' and a.hotelid='${hotelid}' and a.date&amp;gt;='${begindate}' and a.date&amp;lt;='${enddate}';&lt;/Sql&gt;&lt;Description&gt;select a.date,concat(date_format(a.date,'%Y年%m月%d日'),'-(',case weekday(a.date) when '0' then '周一' when '1' then '周二' when '2' then '周三' when '3' then '周四' when '4' then '周五' when '5' then '周六' else '周日' end,')') as xinq ,
(a.day+a.day_rebate) as czzs,(b.day+b.day_rebate) as czl,(c.day+c.day_rebate) as fzsr,(d.day+d.day_rebate) as pjfj,weekday(a.date) as xq from yjourrep a 
left join yjourrep b on a.date=b.date and a.hotelid=b.hotelid and b.cls='010200'
left join yjourrep c on a.date=c.date and a.hotelid=c.hotelid and c.cls='010300'
left join yjourrep d on a.date=d.date and a.hotelid=d.hotelid and d.cls='010400'
where a.cls='010100' and a.hotelid='${hotelid}' and a.date&amp;gt;='${begindate}' and a.date&amp;lt;='${enddate}';&lt;/Description&gt;&lt;/Reader&gt;&lt;TagName&gt;afei&lt;/TagName&gt;&lt;/Item0&gt;&lt;Item1&gt;&lt;Children ItemClass="RowNodeSource"&gt;&lt;Item0/&gt;&lt;/Children&gt;&lt;Reader Class="com.foxhis.data.reader.SelfReader"&gt;&lt;Name&gt;safei&lt;/Name&gt;&lt;Sql&gt;select (a.day) as sczl,(select (a.day) as spjfj from 
 (select j.cls,(select sum(ifnull(day,0)+ifnull(day_rebate,0)) from yjourrep where hotelid = '${hotelid}' and date &amp;gt;= '${begindate}' and date &amp;lt;= '${enddate}' and cls = j.toclass1)/(select if(sum(ifnull(day,0)) = 0 , 1 , sum(day)) from yjourrep where hotelid = '${hotelid}' and date &amp;gt;= '${begindate}' and date &amp;lt;= '${enddate}' and cls = j.toclass2) as day
 from jourrep j where j.hotelid = '${hotelid}'  and j.toop = '/') a
right join (select cls,descript from jourrep where hotelid =  '${hotelid}' and disp='T') b on a.cls = b.cls
where a.cls  ='010400') as spjfj from 
 (select j.cls,(select sum(ifnull(day,0)) * 100 from yjourrep where hotelid = '${hotelid}' and date &amp;gt;= '${begindate}' and date &amp;lt;= '${enddate}' and cls = j.toclass1)/(select if(sum(ifnull(day,0)) = 0 , 1 , sum(day)) from yjourrep where hotelid = '${hotelid}' and date &amp;gt;= '${begindate}' and date &amp;lt;= '${enddate}' and cls = j.toclass2) as day
 from jourrep j where j.hotelid = '${hotelid}'  and j.toop = '%'
) a
right join (select cls,descript from jourrep where hotelid =  '${hotelid}' and disp='T') b on a.cls = b.cls
where a.cls  ='010200';&lt;/Sql&gt;&lt;Description&gt;select (a.day) as sczl,(select (a.day) as spjfj from 
 (select j.cls,(select sum(ifnull(day,0)+ifnull(day_rebate,0)) from yjourrep where hotelid = '${hotelid}' and date &amp;gt;= '${begindate}' and date &amp;lt;= '${enddate}' and cls = j.toclass1)/(select if(sum(ifnull(day,0)) = 0 , 1 , sum(day)) from yjourrep where hotelid = '${hotelid}' and date &amp;gt;= '${begindate}' and date &amp;lt;= '${enddate}' and cls = j.toclass2) as day
 from jourrep j where j.hotelid = '${hotelid}'  and j.toop = '/') a
right join (select cls,descript from jourrep where hotelid =  '${hotelid}' and disp='T') b on a.cls = b.cls
where a.cls  ='010400') as spjfj from 
 (select j.cls,(select sum(ifnull(day,0)) * 100 from yjourrep where hotelid = '${hotelid}' and date &amp;gt;= '${begindate}' and date &amp;lt;= '${enddate}' and cls = j.toclass1)/(select if(sum(ifnull(day,0)) = 0 , 1 , sum(day)) from yjourrep where hotelid = '${hotelid}' and date &amp;gt;= '${begindate}' and date &amp;lt;= '${enddate}' and cls = j.toclass2) as day
 from jourrep j where j.hotelid = '${hotelid}'  and j.toop = '%'
) a
right join (select cls,descript from jourrep where hotelid =  '${hotelid}' and disp='T') b on a.cls = b.cls
where a.cls  ='010200';&lt;/Description&gt;&lt;/Reader&gt;&lt;TagName&gt;safei&lt;/TagName&gt;&lt;/Item1&gt;&lt;/Children&gt;&lt;/NodeSource&gt;&lt;/jatools&gt;</syntax>
</foxreport>
