b354bd29-d5b9-11ec-a48f-005056965405<?xml version="1.0" encoding="UTF-8"?>

<foxreport>
<locale name="zh_CN"/>
<title text="营业日报选择项"/>
<parms>
<parm name="r_bdate" text="开始时间" class="java.lang.String" value="$bdate$-1$" fixed="false" visiable="false" index="0" refid="reportDateTextField"/>
<parm name="r_edate" text="结束时间" class="java.lang.String" value="$bdate$-1$" fixed="false" visiable="false" index="1" refid="reportDateTextField"/>
<parm name="jourrepdes" text="" class="java.lang.String" value="" fixed="false" visiable="false" index="3" refid="jtextfield"/>
<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;date&quot;},{&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;cls&quot;},{&quot;descript2&quot;:&quot;数值&quot;,&quot;descript1&quot;:&quot;数值&quot;,&quot;descript&quot;:&quot;数值&quot;,&quot;columnname&quot;:&quot;day&quot;}]" fixed="true" visiable="false" index="0" refid="jtextfield"/>
<parm name="jourrep" text="项目" class="java.lang.String" value="" fixed="false" visiable="false" index="2" refid="commonDWHelpTextField"/>
</parms>
<pramform store="class" builder="com.foxhis.report.DefaultReportParmBuilder" dialog="false">com.foxhis.maint.frame.reportcond.JourrepSelectedReportPanel</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="getdes"&gt;&lt;Text&gt;return "项目："+jourrepdes;&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;NodePath&gt;jourr&lt;/NodePath&gt;&lt;PrintStyle&gt;print-mode:everypage;visible:true;repeat-flow-first:column;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;X&gt;40&lt;/X&gt;&lt;Children ItemClass="RowPanel"&gt;&lt;Item0&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;ColSpan&gt;11&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;Children ItemClass="Text"&gt;&lt;Item0&gt;&lt;Variable&gt;$.date&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;Hyperlink&gt;&lt;Url&gt;${return event2;}&lt;/Url&gt;&lt;Target&gt;_blank&lt;/Target&gt;&lt;/Hyperlink&gt;&lt;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;String ismarket = $.ismarket;
String ispccode = $.ispccode;
String impindex = $.impindex;
String cls_market = "";
String cls = $.cls;
String flag = cls1.type{cls};
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+=")";
	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;
	 me.foreColor = new Color(0,0,255); 
}else if("T".equals(flag)){
	String num = cls2.type{cls};
	String num2 = cls3.type{cls};
	if("3".equals(num)){
		 me.foreColor = new Color(0,0,255); 
	}else if("2".equals(num2)){
		 me.foreColor = new Color(0,0,255); 
	}else{
		 me.foreColor = new Color(0,0,255); 
	}
}else if(!"F".equals(ispccode)){
	if("".equals(impindex)){
		impindex="empty";
		}
	 me.foreColor = new Color(0,0,255); 
}else if("ooo".equals(impindex)){
	String table_os = "rm_ooo";
	String flag2 = "1";
	String flag1 = "0";
	String flag3 = selectDate;
	String flag4 = selectDate;
	 me.foreColor = new Color(0,0,255); 
}else{
	 me.foreColor = Color.black; 
}
&lt;/BeforePrint&gt;&lt;/Item0&gt;&lt;Item1&gt;&lt;Variable&gt;=format($.year_rebate,"###,##0.00")&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;Hyperlink&gt;&lt;Url&gt;${return event2;}&lt;/Url&gt;&lt;Target&gt;_blank&lt;/Target&gt;&lt;/Hyperlink&gt;&lt;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;9&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;String ismarket = $.ismarket;
String ispccode = $.ispccode;
String impindex = $.impindex;
String cls_market = "";
String cls = $.cls;
String flag = cls1.type{cls};
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+=")";
	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;
	 me.foreColor = new Color(0,0,255); 
}else if("T".equals(flag)){
	String num = cls2.type{cls};
	String num2 = cls3.type{cls};
	if("3".equals(num)){
		 me.foreColor = new Color(0,0,255); 
	}else if("2".equals(num2)){
		 me.foreColor = new Color(0,0,255); 
	}else{
		 me.foreColor = new Color(0,0,255); 
	}
}else if(!"F".equals(ispccode)){
	if("".equals(impindex)){
		impindex="empty";
		}
	 me.foreColor = new Color(0,0,255); 
}else if("ooo".equals(impindex)){
	String table_os = "rm_ooo";
	String flag2 = "1";
	String flag1 = "0";
	String flag3 = selectDate;
	String flag4 = selectDate;
	 me.foreColor = new Color(0,0,255); 
}else{
	if($.year_rebate&amp;lt;0){
		me.foreColor = Color.red; 
	}else{
		me.foreColor = Color.black; 
	}
}
&lt;/BeforePrint&gt;&lt;/Item1&gt;&lt;Item2&gt;&lt;Variable&gt;=format($.year,"###,##0.00")&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;Hyperlink&gt;&lt;Url&gt;${return event2;}&lt;/Url&gt;&lt;Target&gt;_blank&lt;/Target&gt;&lt;/Hyperlink&gt;&lt;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;8&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;String ismarket = $.ismarket;
String ispccode = $.ispccode;
String impindex = $.impindex;
String cls_market = "";
String cls = $.cls;
String flag = cls1.type{cls};
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+=")";
	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;
	 me.foreColor = new Color(0,0,255); 
}else if("T".equals(flag)){
	String num = cls2.type{cls};
	String num2 = cls3.type{cls};
	if("3".equals(num)){
		 me.foreColor = new Color(0,0,255); 
	}else if("2".equals(num2)){
		 me.foreColor = new Color(0,0,255); 
	}else{
		 me.foreColor = new Color(0,0,255); 
	}
}else if(!"F".equals(ispccode)){
	if("".equals(impindex)){
		impindex="empty";
		}
	 me.foreColor = new Color(0,0,255); 
}else if("ooo".equals(impindex)){
	String table_os = "rm_ooo";
	String flag2 = "1";
	String flag1 = "0";
	String flag3 = selectDate;
	String flag4 = selectDate;
	 me.foreColor = new Color(0,0,255); 
}else{
	 me.foreColor = Color.black; 
}
&lt;/BeforePrint&gt;&lt;/Item2&gt;&lt;Item3&gt;&lt;Variable&gt;=format($.month_rebate,"###,##0.00")&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;Hyperlink&gt;&lt;Url&gt;${return event2;}&lt;/Url&gt;&lt;Target&gt;_blank&lt;/Target&gt;&lt;/Hyperlink&gt;&lt;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;6&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;String ismarket = $.ismarket;
String ispccode = $.ispccode;
String impindex = $.impindex;
String cls_market = "";
String cls = $.cls;
String flag = cls1.type{cls};
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+=")";
	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;
	 me.foreColor = new Color(0,0,255); 
}else if("T".equals(flag)){
	String num = cls2.type{cls};
	String num2 = cls3.type{cls};
	if("3".equals(num)){
		 me.foreColor = new Color(0,0,255); 
	}else if("2".equals(num2)){
		 me.foreColor = new Color(0,0,255); 
	}else{
		 me.foreColor = new Color(0,0,255); 
	}
}else if(!"F".equals(ispccode)){
	if("".equals(impindex)){
		impindex="empty";
		}
	 me.foreColor = new Color(0,0,255); 
}else if("ooo".equals(impindex)){
	String table_os = "rm_ooo";
	String flag2 = "1";
	String flag1 = "0";
	String flag3 = selectDate;
	String flag4 = selectDate;
	 me.foreColor = new Color(0,0,255); 
}else{
	if($.month_rebate&amp;lt;0){
		 me.foreColor = Color.red; 
	}else{
		 me.foreColor = Color.black; 
	}
}
&lt;/BeforePrint&gt;&lt;/Item3&gt;&lt;Item4&gt;&lt;Variable&gt;=format($.month,"###,##0.00")&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;Hyperlink&gt;&lt;Url&gt;${return event2;}&lt;/Url&gt;&lt;Target&gt;_blank&lt;/Target&gt;&lt;/Hyperlink&gt;&lt;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;5&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;String ismarket = $.ismarket;
String ispccode = $.ispccode;
String impindex = $.impindex;
String cls_market = "";
String cls = $.cls;
String flag = cls1.type{cls};
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+=")";
	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;
	 me.foreColor = new Color(0,0,255); 
}else if("T".equals(flag)){
	String num = cls2.type{cls};
	String num2 = cls3.type{cls};
	if("3".equals(num)){
		 me.foreColor = new Color(0,0,255); 
	}else if("2".equals(num2)){
		 me.foreColor = new Color(0,0,255); 
	}else{
		 me.foreColor = new Color(0,0,255); 
	}
}else if(!"F".equals(ispccode)){
	if("".equals(impindex)){
		impindex="empty";
		}
	 me.foreColor = new Color(0,0,255); 
}else if("ooo".equals(impindex)){
	String table_os = "rm_ooo";
	String flag2 = "1";
	String flag1 = "0";
	String flag3 = selectDate;
	String flag4 = selectDate;
	 me.foreColor = new Color(0,0,255); 
}else{
	 me.foreColor = Color.black; 
}
&lt;/BeforePrint&gt;&lt;/Item4&gt;&lt;Item5&gt;&lt;Variable&gt;=format($.day_rebate,"###,##0.00")&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;Hyperlink&gt;&lt;Url&gt;${return event2;}&lt;/Url&gt;&lt;Target&gt;_blank&lt;/Target&gt;&lt;/Hyperlink&gt;&lt;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;3&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;String ismarket = $.ismarket;
String ispccode = $.ispccode;
String impindex = $.impindex;
String cls_market = "";
String cls = $.cls;
String flag = cls1.type{cls};
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+=")";
	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;
	 me.foreColor = new Color(0,0,255); 
}else if("T".equals(flag)){
	String num = cls2.type{cls};
	String num2 = cls3.type{cls};
	if("3".equals(num)){
		 me.foreColor = new Color(0,0,255); 
	}else if("2".equals(num2)){
		 me.foreColor = new Color(0,0,255); 
	}else{
		 me.foreColor = new Color(0,0,255); 
	}
}else if(!"F".equals(ispccode)){
	if("".equals(impindex)){
		impindex="empty";
		}
	 me.foreColor = new Color(0,0,255); 
}else if("ooo".equals(impindex)){
	String table_os = "rm_ooo";
	String flag2 = "1";
	String flag1 = "0";
	String flag3 = selectDate;
	String flag4 = selectDate;
	 me.foreColor = new Color(0,0,255); 
}else{
	if($.day_rebate&amp;lt;0){
		me.foreColor = Color.red; 
	}else{
		me.foreColor = Color.black; 
	}
}
&lt;/BeforePrint&gt;&lt;/Item5&gt;&lt;Item6&gt;&lt;Variable&gt;=format($.day,"###,##0.00")&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;Hyperlink&gt;&lt;Url&gt;${return event2;}&lt;/Url&gt;&lt;Target&gt;_blank&lt;/Target&gt;&lt;/Hyperlink&gt;&lt;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;2&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;String ismarket = $.ismarket;
String ispccode = $.ispccode;
String impindex = $.impindex;
String cls_market = "";
String cls = $.cls;
String flag = cls1.type{cls};
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+=")";
	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;
	 me.foreColor = new Color(0,0,255); 
}else if("T".equals(flag)){
	String num = cls2.type{cls};
	String num2 = cls3.type{cls};
	if("3".equals(num)){
		 me.foreColor = new Color(0,0,255); 
	}else if("2".equals(num2)){
		 me.foreColor = new Color(0,0,255); 
	}else{
		 me.foreColor = new Color(0,0,255); 
	}
}else if(!"F".equals(ispccode)){
	if("".equals(impindex)){
		impindex="empty";
		}
	 me.foreColor = new Color(0,0,255); 
}else if("ooo".equals(impindex)){
	String table_os = "rm_ooo";
	String flag2 = "1";
	String flag1 = "0";
	String flag3 = selectDate;
	String flag4 = selectDate;
	 me.foreColor = new Color(0,0,255); 
}else{
	 me.foreColor = Color.black; 
}
&lt;/BeforePrint&gt;&lt;/Item6&gt;&lt;Item7&gt;&lt;Variable&gt;=format(toDouble($.day) + toDouble($.day_rebate),"###,##0.00")&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;Hyperlink&gt;&lt;Url&gt;${return event2;}&lt;/Url&gt;&lt;Target&gt;_blank&lt;/Target&gt;&lt;/Hyperlink&gt;&lt;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;4&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;String ismarket = $.ismarket;
String ispccode = $.ispccode;
String impindex = $.impindex;
String cls_market = "";
String cls = $.cls;
String flag = cls1.type{cls};
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+=")";
	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;
	 me.foreColor = new Color(0,0,255); 
}else if("T".equals(flag)){
	String num = cls2.type{cls};
	String num2 = cls3.type{cls};
	if("3".equals(num)){
		 me.foreColor = new Color(0,0,255); 
	}else if("2".equals(num2)){
		 me.foreColor = new Color(0,0,255); 
	}else{
		 me.foreColor = new Color(0,0,255); 
	}
}else if(!"F".equals(ispccode)){
	if("".equals(impindex)){
		impindex="empty";
		}
	 me.foreColor = new Color(0,0,255); 
}else if("ooo".equals(impindex)){
	String table_os = "rm_ooo";
	String flag2 = "1";
	String flag1 = "0";
	String flag3 = selectDate;
	String flag4 = selectDate;
	 me.foreColor = new Color(0,0,255); 
}else{
	 me.foreColor = Color.black; 
}
&lt;/BeforePrint&gt;&lt;/Item7&gt;&lt;Item8&gt;&lt;Variable&gt;=format(toDouble($.month) + toDouble($.month_rebate),"###,##0.00")&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;Hyperlink&gt;&lt;Url&gt;${return event2;}&lt;/Url&gt;&lt;Target&gt;_blank&lt;/Target&gt;&lt;/Hyperlink&gt;&lt;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;7&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;String ismarket = $.ismarket;
String ispccode = $.ispccode;
String impindex = $.impindex;
String cls_market = "";
String cls = $.cls;
String flag = cls1.type{cls};
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+=")";
	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;
	 me.foreColor = new Color(0,0,255); 
}else if("T".equals(flag)){
	String num = cls2.type{cls};
	String num2 = cls3.type{cls};
	if("3".equals(num)){
		 me.foreColor = new Color(0,0,255); 
	}else if("2".equals(num2)){
		 me.foreColor = new Color(0,0,255); 
	}else{
		 me.foreColor = new Color(0,0,255); 
	}
}else if(!"F".equals(ispccode)){
	if("".equals(impindex)){
		impindex="empty";
		}
	 me.foreColor = new Color(0,0,255); 
}else if("ooo".equals(impindex)){
	String table_os = "rm_ooo";
	String flag2 = "1";
	String flag1 = "0";
	String flag3 = selectDate;
	String flag4 = selectDate;
	 me.foreColor = new Color(0,0,255); 
}else{
	 me.foreColor = Color.black; 
}
&lt;/BeforePrint&gt;&lt;/Item8&gt;&lt;Item9&gt;&lt;Variable&gt;=format(toDouble($.year) + toDouble($.year_rebate),"###,##0.00")&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;Hyperlink&gt;&lt;Url&gt;${return event2;}&lt;/Url&gt;&lt;Target&gt;_blank&lt;/Target&gt;&lt;/Hyperlink&gt;&lt;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;10&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;String ismarket = $.ismarket;
String ispccode = $.ispccode;
String impindex = $.impindex;
String cls_market = "";
String cls = $.cls;
String flag = cls1.type{cls};
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+=")";
	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;
	 me.foreColor = new Color(0,0,255); 
}else if("T".equals(flag)){
	String num = cls2.type{cls};
	String num2 = cls3.type{cls};
	if("3".equals(num)){
		 me.foreColor = new Color(0,0,255); 
	}else if("2".equals(num2)){
		 me.foreColor = new Color(0,0,255); 
	}else{
		 me.foreColor = new Color(0,0,255); 
	}
}else if(!"F".equals(ispccode)){
	if("".equals(impindex)){
		impindex="empty";
		}
	 me.foreColor = new Color(0,0,255); 
}else if("ooo".equals(impindex)){
	String table_os = "rm_ooo";
	String flag2 = "1";
	String flag1 = "0";
	String flag3 = selectDate;
	String flag4 = selectDate;
	 me.foreColor = new Color(0,0,255); 
}else{
	 me.foreColor = Color.black; 
}
&lt;/BeforePrint&gt;&lt;/Item9&gt;&lt;Item10&gt;&lt;Variable&gt;$.descript&lt;/Variable&gt;&lt;Border&gt;&lt;StyleText&gt;border:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;Hyperlink&gt;&lt;Url&gt;${return event2;}&lt;/Url&gt;&lt;Target&gt;_blank&lt;/Target&gt;&lt;/Hyperlink&gt;&lt;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;6&lt;/Row&gt;&lt;Col&gt;1&lt;/Col&gt;&lt;/Cell&gt;&lt;BeforePrint&gt;String ismarket = $.ismarket;
String ispccode = $.ispccode;
String impindex = $.impindex;
String cls_market = "";
String cls = $.cls;
String flag = cls1.type{cls};
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+=")";
	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;
	 me.foreColor = new Color(0,0,255); 
}else if("T".equals(flag)){
	String num = cls2.type{cls};
	String num2 = cls3.type{cls};
	if("3".equals(num)){
		 me.foreColor = new Color(0,0,255); 
	}else if("2".equals(num2)){
		 me.foreColor = new Color(0,0,255); 
	}else{
		 me.foreColor = new Color(0,0,255); 
	}
}else if(!"F".equals(ispccode)){
	if("".equals(impindex)){
		impindex="empty";
		}
	 me.foreColor = new Color(0,0,255); 
}else if("ooo".equals(impindex)){
	String table_os = "rm_ooo";
	String flag2 = "1";
	String flag1 = "0";
	String flag3 = selectDate;
	String flag4 = selectDate;
	 me.foreColor = new Color(0,0,255); 
}else{
	 me.foreColor = Color.black; 
}
&lt;/BeforePrint&gt;&lt;/Item10&gt;&lt;/Children&gt;&lt;NodePath&gt;Row&lt;/NodePath&gt;&lt;/Item0&gt;&lt;Item1&gt;&lt;Cell&gt;&lt;Row&gt;7&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;RowSpan&gt;2&lt;/RowSpan&gt;&lt;ColSpan&gt;11&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;8&lt;/Row&gt;&lt;Col&gt;9&lt;/Col&gt;&lt;ColSpan&gt;2&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;8&lt;/Row&gt;&lt;Col&gt;6&lt;/Col&gt;&lt;ColSpan&gt;3&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;8&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;ColSpan&gt;6&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item2&gt;&lt;Item3&gt;&lt;Cell&gt;&lt;Row&gt;7&lt;/Row&gt;&lt;Col&gt;10&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item3&gt;&lt;Item4&gt;&lt;Cell&gt;&lt;Row&gt;7&lt;/Row&gt;&lt;Col&gt;9&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item4&gt;&lt;Item5&gt;&lt;Cell&gt;&lt;Row&gt;7&lt;/Row&gt;&lt;Col&gt;8&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item5&gt;&lt;Item6&gt;&lt;Cell&gt;&lt;Row&gt;7&lt;/Row&gt;&lt;Col&gt;7&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item6&gt;&lt;Item7&gt;&lt;Cell&gt;&lt;Row&gt;7&lt;/Row&gt;&lt;Col&gt;6&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item7&gt;&lt;Item8&gt;&lt;Cell&gt;&lt;Row&gt;7&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;ColSpan&gt;6&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item8&gt;&lt;/Children&gt;&lt;/Item1&gt;&lt;Item2&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;11&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;Text&gt;Rebate&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;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;9&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item0&gt;&lt;Item1 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;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;8&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item1&gt;&lt;Item2 Class="Label"&gt;&lt;Text&gt;Rebate&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;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;6&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item2&gt;&lt;Item3 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;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;5&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item3&gt;&lt;Item4 Class="Label"&gt;&lt;Text&gt;Rebate&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;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;3&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item4&gt;&lt;Item5 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;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;2&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item5&gt;&lt;Item6 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;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;4&lt;/Row&gt;&lt;Col&gt;8&lt;/Col&gt;&lt;ColSpan&gt;3&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item6&gt;&lt;Item7 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;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;4&lt;/Row&gt;&lt;Col&gt;5&lt;/Col&gt;&lt;ColSpan&gt;3&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item7&gt;&lt;Item8 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;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;4&lt;/Row&gt;&lt;Col&gt;2&lt;/Col&gt;&lt;ColSpan&gt;3&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item8&gt;&lt;Item9 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;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&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;/Item9&gt;&lt;Item10 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;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;4&lt;/Col&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;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;7&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;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;10&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;0&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;2&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;3&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;4&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;5&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;7&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;8&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;9&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;10&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item22&gt;&lt;Item23 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;11&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item23&gt;&lt;Item24 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;11&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item24&gt;&lt;Item25 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;3&lt;/Row&gt;&lt;Col&gt;6&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item25&gt;&lt;Item26 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;3&lt;/Row&gt;&lt;Col&gt;7&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item26&gt;&lt;Item27 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;8&lt;/Col&gt;&lt;ColSpan&gt;3&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item27&gt;&lt;Item28 Class="Label"&gt;&lt;Cell&gt;&lt;Row&gt;0&lt;/Row&gt;&lt;Col&gt;1&lt;/Col&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:1.0px solid #000000&lt;/StyleText&gt;&lt;/Border&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;PrintStyle&gt;repeat-overflow:newpage;&lt;/PrintStyle&gt;&lt;Cell&gt;&lt;Row&gt;4&lt;/Row&gt;&lt;Col&gt;1&lt;/Col&gt;&lt;RowSpan&gt;2&lt;/RowSpan&gt;&lt;/Cell&gt;&lt;/Item29&gt;&lt;Item30 Class="Text"&gt;&lt;Variable&gt;=fmtdt8(r_bdate,r_edate,"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;6&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item30&gt;&lt;/Children&gt;&lt;/Item2&gt;&lt;/Children&gt;&lt;ColumnWidths&gt;90,250,100,100,100,100,100,100,120,120,120&lt;/ColumnWidths&gt;&lt;RowHeights&gt;20,40,20,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;InitPrint&gt;if(posted == "0"){
	table_model1.printStyle="visible:false";
	table_model1.height = 0;
	table_model2.printStyle="visible:false";
	table_model2.height = 0;	
}
else if(posted == "1"){
	table_model0.printStyle="visible:false";
	table_model0.height = 0;
	table_model2.printStyle="visible:false";
	table_model2.height = 0;	
}
else if(posted == "2"){
	table_model0.printStyle="visible:false";
	table_model0.height = 0;
	table_model1.printStyle="visible:false";
	table_model1.height = 0;	
}&lt;/InitPrint&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;jourr&lt;/Name&gt;&lt;Sql&gt;select a.date,a.hotelid,a.cls,a.descript,a.day,a.day_rebate,a.month,a.month_rebate, a.pmonth as pmonth,a.lmonth,a.year,a.year_rebate,a.lyear, a.pyear as pyear  from yjourrep a where a. date&amp;gt;='${r_bdate}' and a.date&amp;lt;='${r_edate}' and a.hotelid='${hotelid}'  and 
find_in_set (a.cls,'${jourrep}') and disp='T'  order by date,cls
&lt;/Sql&gt;&lt;Description&gt;select a.date,a.hotelid,a.cls,a.descript,a.day,a.day_rebate,a.month,a.month_rebate, a.pmonth as pmonth,a.lmonth,a.year,a.year_rebate,a.lyear, a.pyear as pyear  from yjourrep a where a. date&amp;gt;='${r_bdate}' and a.date&amp;lt;='${r_edate}' and a.hotelid='${hotelid}'  and 
find_in_set (a.cls,'${jourrep}') and disp='T'  order by date,cls
&lt;/Description&gt;&lt;/Reader&gt;&lt;TagName&gt;jourr&lt;/TagName&gt;&lt;/Item0&gt;&lt;/Children&gt;&lt;/NodeSource&gt;&lt;/jatools&gt;</syntax>
</foxreport>
