3c94f317-97ea-4064-9a4a-d6f69d0c3471<?xml version="1.0" encoding="UTF-8"?>

<foxreport>
<locale name="zh_CN"/>
<title text="营业日报表"/>
<parms>
<parm name="endDate" text="结束时间" class="java.lang.String" value="" fixed="false" visiable="false" index="1" refid="reportDateTextField"/>
<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;day&quot;},{&quot;descript2&quot;:&quot;本日rebate&quot;,&quot;descript1&quot;:&quot;本日rebate&quot;,&quot;descript&quot;:&quot;本日rebate&quot;,&quot;columnname&quot;:&quot;day_rebate&quot;},{&quot;descript2&quot;:&quot;本月发生&quot;,&quot;descript1&quot;:&quot;本月发生&quot;,&quot;descript&quot;:&quot;本月发生&quot;,&quot;columnname&quot;:&quot;month&quot;},{&quot;descript2&quot;:&quot;本月rebate&quot;,&quot;descript1&quot;:&quot;本月rebate&quot;,&quot;descript&quot;:&quot;本月rebate&quot;,&quot;columnname&quot;:&quot;month_rebate&quot;},{&quot;descript2&quot;:&quot;月计划&quot;,&quot;descript1&quot;:&quot;月计划&quot;,&quot;descript&quot;:&quot;月计划&quot;,&quot;columnname&quot;:&quot;pmonth&quot;},{&quot;descript2&quot;:&quot;月完成&quot;,&quot;descript1&quot;:&quot;月完成&quot;,&quot;descript&quot;:&quot;月完成&quot;,&quot;columnname&quot;:&quot;lmonth&quot;},{&quot;descript2&quot;:&quot;本年发生&quot;,&quot;descript1&quot;:&quot;本年发生&quot;,&quot;descript&quot;:&quot;本年发生&quot;,&quot;columnname&quot;:&quot;year&quot;},{&quot;descript2&quot;:&quot;本年rebate&quot;,&quot;descript1&quot;:&quot;本年rebate&quot;,&quot;descript&quot;:&quot;本年rebate&quot;,&quot;columnname&quot;:&quot;year_rebate&quot;},{&quot;descript2&quot;:&quot;年完成&quot;,&quot;descript1&quot;:&quot;年完成&quot;,&quot;descript&quot;:&quot;年完成&quot;,&quot;columnname&quot;:&quot;lyear&quot;},{&quot;descript2&quot;:&quot;年计划&quot;,&quot;descript1&quot;:&quot;年计划&quot;,&quot;descript&quot;:&quot;年计划&quot;,&quot;columnname&quot;:&quot;pyear&quot;},{&quot;descript2&quot;:&quot;天完成&quot;,&quot;descript1&quot;:&quot;天完成&quot;,&quot;descript&quot;:&quot;天完成&quot;,&quot;columnname&quot;:&quot;lday&quot;},{&quot;descript2&quot;:&quot;酒店&quot;,&quot;descript1&quot;:&quot;酒店&quot;,&quot;descript&quot;:&quot;酒店&quot;,&quot;columnname&quot;:&quot;hotelid&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;ispccode&quot;},{&quot;descript2&quot;:&quot;市场码&quot;,&quot;descript1&quot;:&quot;市场码&quot;,&quot;descript&quot;:&quot;市场码&quot;,&quot;columnname&quot;:&quot;ismarket&quot;},{&quot;descript2&quot;:&quot;imp&quot;,&quot;descript1&quot;:&quot;imp&quot;,&quot;descript&quot;:&quot;imp数据&quot;,&quot;columnname&quot;:&quot;impindex&quot;},{&quot;descript2&quot;:&quot;数据类&quot;,&quot;descript1&quot;:&quot;数据类&quot;,&quot;descript&quot;:&quot;数据类&quot;,&quot;columnname&quot;:&quot;rectype&quot;}]" fixed="true" visiable="false" index="0" refid="jtextfield"/>
<parm name="startDate" text="开始时间" class="java.lang.String" value="" fixed="false" visiable="false" index="0" refid="reportDateTextField"/>
</parms>
<pramform store="self" builder="com.foxhis.report.DefaultReportParmBuilder" dialog="false">&lt;?xml version="1.0" encoding="UTF-8"?&gt;

&lt;object classname="com.jeta.forms.store.memento.FormPackage"&gt;
 &lt;at name="fileversion"&gt;
  &lt;object classname="com.jeta.forms.store.memento.FormsVersion2"&gt;
   &lt;at name="major"&gt;2&lt;/at&gt;
   &lt;at name="minor"&gt;0&lt;/at&gt;
   &lt;at name="sub"&gt;0&lt;/at&gt;
  &lt;/object&gt;
 &lt;/at&gt;
 &lt;at name="form"&gt;
  &lt;object classname="com.jeta.forms.store.memento.FormMemento"&gt;
   &lt;super classname="com.jeta.forms.store.memento.ComponentMemento"&gt;
    &lt;at name="cellconstraints"&gt;
     &lt;object classname="com.jeta.forms.store.memento.CellConstraintsMemento"&gt;
      &lt;at name="column"&gt;1&lt;/at&gt;
      &lt;at name="row"&gt;1&lt;/at&gt;
      &lt;at name="colspan"&gt;1&lt;/at&gt;
      &lt;at name="rowspan"&gt;1&lt;/at&gt;
      &lt;at name="halign"&gt;fill&lt;/at&gt;
      &lt;at name="valign"&gt;fill&lt;/at&gt;
      &lt;at name="insets" object="insets"&gt;0,0,0,0&lt;/at&gt;
     &lt;/object&gt;
    &lt;/at&gt;
    &lt;at name="componentclass"&gt;com.jeta.forms.gui.form.FormComponent&lt;/at&gt;
   &lt;/super&gt;
   &lt;at name="id"&gt;reportparm&lt;/at&gt;
   &lt;at name="rowspecs"&gt;FILL:23PX:NONE,FILL:5PX:NONE,FILL:23PX:NONE,FILL:5PX:NONE,FILL:23PX:NONE&lt;/at&gt;
   &lt;at name="colspecs"&gt;FILL:120PX:NONE,FILL:5PX:NONE,FILL:120PX:NONE,FILL:5PX:NONE,FILL:120PX:NONE&lt;/at&gt;
   &lt;at name="components"&gt;
    &lt;object classname="java.util.LinkedList"&gt;
     &lt;item &gt;
      &lt;at name="value"&gt;
       &lt;object classname="com.jeta.forms.store.memento.BeanMemento"&gt;
        &lt;super classname="com.jeta.forms.store.memento.ComponentMemento"&gt;
         &lt;at name="cellconstraints"&gt;
          &lt;object classname="com.jeta.forms.store.memento.CellConstraintsMemento"&gt;
           &lt;at name="column"&gt;1&lt;/at&gt;
           &lt;at name="row"&gt;3&lt;/at&gt;
           &lt;at name="colspan"&gt;1&lt;/at&gt;
           &lt;at name="rowspan"&gt;1&lt;/at&gt;
           &lt;at name="halign"&gt;fill&lt;/at&gt;
           &lt;at name="valign"&gt;fill&lt;/at&gt;
           &lt;at name="insets" object="insets"&gt;0,0,0,0&lt;/at&gt;
          &lt;/object&gt;
         &lt;/at&gt;
         &lt;at name="componentclass"&gt;com.jeta.forms.gui.form.StandardComponent&lt;/at&gt;
        &lt;/super&gt;
        &lt;at name="jetabeanclass"&gt;com.jeta.forms.gui.beans.JETABean&lt;/at&gt;
        &lt;at name="beanclass"&gt;javax.swing.JLabel&lt;/at&gt;
        &lt;at name="beanproperties"&gt;
         &lt;object classname="com.jeta.forms.store.memento.PropertiesMemento"&gt;
          &lt;at name="classname"&gt;javax.swing.JLabel&lt;/at&gt;
          &lt;at name="properties"&gt;
           &lt;object classname="com.jeta.forms.store.support.PropertyMap"&gt;
            &lt;at name="name"&gt;&lt;/at&gt;
            &lt;at name="width"&gt;116&lt;/at&gt;
            &lt;at name="bindprop"&gt;
             &lt;object classname="com.jeta.forms.store.properties.StringProperty"&gt;
              &lt;at name="value"&gt;text&lt;/at&gt;
             &lt;/object&gt;
            &lt;/at&gt;
            &lt;at name="height"&gt;19&lt;/at&gt;
           &lt;/object&gt;
          &lt;/at&gt;
         &lt;/object&gt;
        &lt;/at&gt;
        &lt;at name="jetabeanid"&gt;jlabel_startDate&lt;/at&gt;
       &lt;/object&gt;
      &lt;/at&gt;
     &lt;/item&gt;
     &lt;item &gt;
      &lt;at name="value"&gt;
       &lt;object classname="com.jeta.forms.store.memento.BeanMemento"&gt;
        &lt;super classname="com.jeta.forms.store.memento.ComponentMemento"&gt;
         &lt;at name="cellconstraints"&gt;
          &lt;object classname="com.jeta.forms.store.memento.CellConstraintsMemento"&gt;
           &lt;at name="column"&gt;3&lt;/at&gt;
           &lt;at name="row"&gt;3&lt;/at&gt;
           &lt;at name="colspan"&gt;1&lt;/at&gt;
           &lt;at name="rowspan"&gt;1&lt;/at&gt;
           &lt;at name="halign"&gt;fill&lt;/at&gt;
           &lt;at name="valign"&gt;fill&lt;/at&gt;
           &lt;at name="insets" object="insets"&gt;0,0,0,0&lt;/at&gt;
          &lt;/object&gt;
         &lt;/at&gt;
         &lt;at name="componentclass"&gt;com.jeta.forms.gui.form.StandardComponent&lt;/at&gt;
        &lt;/super&gt;
        &lt;at name="jetabeanclass"&gt;com.jeta.forms.gui.beans.JETABean&lt;/at&gt;
        &lt;at name="beanclass"&gt;com.foxhis.maint.report.ReportDateTextField&lt;/at&gt;
        &lt;at name="beanproperties"&gt;
         &lt;object classname="com.jeta.forms.store.memento.PropertiesMemento"&gt;
          &lt;at name="classname"&gt;com.foxhis.maint.report.ReportDateTextField&lt;/at&gt;
          &lt;at name="properties"&gt;
           &lt;object classname="com.jeta.forms.store.support.PropertyMap"&gt;
            &lt;at name="bindorder"&gt;
             &lt;object classname="com.jeta.forms.store.properties.IntegerProperty"&gt;
              &lt;at name="value"&gt;1&lt;/at&gt;
             &lt;/object&gt;
            &lt;/at&gt;
            &lt;at name="bind"&gt;
             &lt;object classname="com.jeta.forms.store.properties.StringProperty"&gt;
              &lt;at name="value"&gt;formdata.startDate&lt;/at&gt;
             &lt;/object&gt;
            &lt;/at&gt;
            &lt;at name="name"&gt;&lt;/at&gt;
            &lt;at name="width"&gt;116&lt;/at&gt;
            &lt;at name="bindprop"&gt;
             &lt;object classname="com.jeta.forms.store.properties.StringProperty"&gt;
              &lt;at name="value"&gt;dateString&lt;/at&gt;
             &lt;/object&gt;
            &lt;/at&gt;
            &lt;at name="defaultDateTime"/&gt;
            &lt;at name="height"&gt;19&lt;/at&gt;
           &lt;/object&gt;
          &lt;/at&gt;
         &lt;/object&gt;
        &lt;/at&gt;
        &lt;at name="jetabeanid"&gt;startDate&lt;/at&gt;
       &lt;/object&gt;
      &lt;/at&gt;
     &lt;/item&gt;
     &lt;item &gt;
      &lt;at name="value"&gt;
       &lt;object classname="com.jeta.forms.store.memento.BeanMemento"&gt;
        &lt;super classname="com.jeta.forms.store.memento.ComponentMemento"&gt;
         &lt;at name="cellconstraints"&gt;
          &lt;object classname="com.jeta.forms.store.memento.CellConstraintsMemento"&gt;
           &lt;at name="column"&gt;1&lt;/at&gt;
           &lt;at name="row"&gt;5&lt;/at&gt;
           &lt;at name="colspan"&gt;1&lt;/at&gt;
           &lt;at name="rowspan"&gt;1&lt;/at&gt;
           &lt;at name="halign"&gt;fill&lt;/at&gt;
           &lt;at name="valign"&gt;fill&lt;/at&gt;
           &lt;at name="insets" object="insets"&gt;0,0,0,0&lt;/at&gt;
          &lt;/object&gt;
         &lt;/at&gt;
         &lt;at name="componentclass"&gt;com.jeta.forms.gui.form.StandardComponent&lt;/at&gt;
        &lt;/super&gt;
        &lt;at name="jetabeanclass"&gt;com.jeta.forms.gui.beans.JETABean&lt;/at&gt;
        &lt;at name="beanclass"&gt;javax.swing.JLabel&lt;/at&gt;
        &lt;at name="beanproperties"&gt;
         &lt;object classname="com.jeta.forms.store.memento.PropertiesMemento"&gt;
          &lt;at name="classname"&gt;javax.swing.JLabel&lt;/at&gt;
          &lt;at name="properties"&gt;
           &lt;object classname="com.jeta.forms.store.support.PropertyMap"&gt;
            &lt;at name="name"&gt;&lt;/at&gt;
            &lt;at name="width"&gt;116&lt;/at&gt;
            &lt;at name="bindprop"&gt;
             &lt;object classname="com.jeta.forms.store.properties.StringProperty"&gt;
              &lt;at name="value"&gt;text&lt;/at&gt;
             &lt;/object&gt;
            &lt;/at&gt;
            &lt;at name="height"&gt;19&lt;/at&gt;
           &lt;/object&gt;
          &lt;/at&gt;
         &lt;/object&gt;
        &lt;/at&gt;
        &lt;at name="jetabeanid"&gt;jlabel_endDate&lt;/at&gt;
       &lt;/object&gt;
      &lt;/at&gt;
     &lt;/item&gt;
     &lt;item &gt;
      &lt;at name="value"&gt;
       &lt;object classname="com.jeta.forms.store.memento.BeanMemento"&gt;
        &lt;super classname="com.jeta.forms.store.memento.ComponentMemento"&gt;
         &lt;at name="cellconstraints"&gt;
          &lt;object classname="com.jeta.forms.store.memento.CellConstraintsMemento"&gt;
           &lt;at name="column"&gt;3&lt;/at&gt;
           &lt;at name="row"&gt;5&lt;/at&gt;
           &lt;at name="colspan"&gt;1&lt;/at&gt;
           &lt;at name="rowspan"&gt;1&lt;/at&gt;
           &lt;at name="halign"&gt;fill&lt;/at&gt;
           &lt;at name="valign"&gt;fill&lt;/at&gt;
           &lt;at name="insets" object="insets"&gt;0,0,0,0&lt;/at&gt;
          &lt;/object&gt;
         &lt;/at&gt;
         &lt;at name="componentclass"&gt;com.jeta.forms.gui.form.StandardComponent&lt;/at&gt;
        &lt;/super&gt;
        &lt;at name="jetabeanclass"&gt;com.jeta.forms.gui.beans.JETABean&lt;/at&gt;
        &lt;at name="beanclass"&gt;com.foxhis.maint.report.ReportDateTextField&lt;/at&gt;
        &lt;at name="beanproperties"&gt;
         &lt;object classname="com.jeta.forms.store.memento.PropertiesMemento"&gt;
          &lt;at name="classname"&gt;com.foxhis.maint.report.ReportDateTextField&lt;/at&gt;
          &lt;at name="properties"&gt;
           &lt;object classname="com.jeta.forms.store.support.PropertyMap"&gt;
            &lt;at name="bindorder"&gt;
             &lt;object classname="com.jeta.forms.store.properties.IntegerProperty"&gt;
              &lt;at name="value"&gt;1&lt;/at&gt;
             &lt;/object&gt;
            &lt;/at&gt;
            &lt;at name="bind"&gt;
             &lt;object classname="com.jeta.forms.store.properties.StringProperty"&gt;
              &lt;at name="value"&gt;formdata.endDate&lt;/at&gt;
             &lt;/object&gt;
            &lt;/at&gt;
            &lt;at name="name"&gt;&lt;/at&gt;
            &lt;at name="width"&gt;116&lt;/at&gt;
            &lt;at name="bindprop"&gt;
             &lt;object classname="com.jeta.forms.store.properties.StringProperty"&gt;
              &lt;at name="value"&gt;dateString&lt;/at&gt;
             &lt;/object&gt;
            &lt;/at&gt;
            &lt;at name="defaultDateTime"/&gt;
            &lt;at name="height"&gt;19&lt;/at&gt;
           &lt;/object&gt;
          &lt;/at&gt;
         &lt;/object&gt;
        &lt;/at&gt;
        &lt;at name="jetabeanid"&gt;endDate&lt;/at&gt;
       &lt;/object&gt;
      &lt;/at&gt;
     &lt;/item&gt;
    &lt;/object&gt;
   &lt;/at&gt;
   &lt;at name="properties"&gt;
    &lt;object classname="com.jeta.forms.store.memento.PropertiesMemento"&gt;
     &lt;at name="classname"&gt;com.jeta.forms.gui.form.GridView&lt;/at&gt;
     &lt;at name="properties"&gt;
      &lt;object classname="com.jeta.forms.store.support.PropertyMap"&gt;
       &lt;at name="border"&gt;
        &lt;object classname="com.jeta.forms.store.properties.CompoundBorderProperty"&gt;
         &lt;super classname="com.jeta.forms.store.properties.BorderProperty"&gt;
          &lt;at name="name"&gt;border&lt;/at&gt;
         &lt;/super&gt;
         &lt;at name="borders"&gt;
          &lt;object classname="java.util.LinkedList"/&gt;
         &lt;/at&gt;
        &lt;/object&gt;
       &lt;/at&gt;
       &lt;at name="name"&gt;&lt;/at&gt;
       &lt;at name="fill"&gt;
        &lt;object classname="com.jeta.forms.store.properties.effects.PaintProperty"&gt;
         &lt;at name="name"&gt;fill&lt;/at&gt;
        &lt;/object&gt;
       &lt;/at&gt;
       &lt;at name="scollBars"&gt;
        &lt;object classname="com.jeta.forms.store.properties.ScrollBarsProperty"&gt;
         &lt;at name="name"&gt;scollBars&lt;/at&gt;
         &lt;at name="verticalpolicy"&gt;21&lt;/at&gt;
         &lt;at name="horizontalpolicy"&gt;31&lt;/at&gt;
        &lt;/object&gt;
       &lt;/at&gt;
      &lt;/object&gt;
     &lt;/at&gt;
    &lt;/object&gt;
   &lt;/at&gt;
   &lt;at name="cellpainters"&gt;
    &lt;object classname="com.jeta.forms.store.support.Matrix"&gt;
     &lt;at name="rows"&gt;
      &lt;object classname="[Ljava.lang.Object;" size="5"&gt;
       &lt;at name="item" index="0"&gt;
        &lt;object classname="[Ljava.lang.Object;" size="5"/&gt;
       &lt;/at&gt;
       &lt;at name="item" index="1"&gt;
        &lt;object classname="[Ljava.lang.Object;" size="5"/&gt;
       &lt;/at&gt;
       &lt;at name="item" index="2"&gt;
        &lt;object classname="[Ljava.lang.Object;" size="5"/&gt;
       &lt;/at&gt;
       &lt;at name="item" index="3"&gt;
        &lt;object classname="[Ljava.lang.Object;" size="5"/&gt;
       &lt;/at&gt;
       &lt;at name="item" index="4"&gt;
        &lt;object classname="[Ljava.lang.Object;" size="5"/&gt;
       &lt;/at&gt;
      &lt;/object&gt;
     &lt;/at&gt;
    &lt;/object&gt;
   &lt;/at&gt;
   &lt;at name="rowgroups"&gt;
    &lt;object classname="com.jeta.forms.store.memento.FormGroupSet"&gt;
     &lt;at name="groups"&gt;
      &lt;object classname="java.util.HashMap"/&gt;
     &lt;/at&gt;
    &lt;/object&gt;
   &lt;/at&gt;
   &lt;at name="colgroups"&gt;
    &lt;object classname="com.jeta.forms.store.memento.FormGroupSet"&gt;
     &lt;at name="groups"&gt;
      &lt;object classname="java.util.HashMap"/&gt;
     &lt;/at&gt;
    &lt;/object&gt;
   &lt;/at&gt;
   &lt;at name="classname"&gt;com.foxhis.report.RuntimePramPanel&lt;/at&gt;
  &lt;/object&gt;
 &lt;/at&gt;
&lt;/object&gt;
</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="event2"&gt;&lt;Text&gt;String ismarket = $.ismarket;
String ispccode = $.ispccode;
String impindex = $.impindex;
String cls = $.cls;
String cls_market = "";
String flag = cls1.type{cls};
if(length(impindex)&amp;gt;0) {
	cls_market = impindex;
} else {
	cls_market = cls;
}
String num4 = cls4.type{cls};
if(startsWith($.impindex,"rmsalerep")){
	return "openreport?rptid=SYS1239V6&amp;amp;m_date="+selectDate+"&amp;amp;m_enddate="+selectDate+
					"&amp;amp;m_cls="+$.cls+"&amp;amp;m_hotelid="+selectedhotelid;
} else if("T".equals(flag) &amp;amp;&amp;amp; "2".equals(num4)){
	return "openreport?rptid=SYS1239V6&amp;amp;m_date="+selectDate+"&amp;amp;m_enddate="+selectDate+
					"&amp;amp;m_cls="+$.cls+"&amp;amp;m_hotelid="+selectedhotelid;
} else if(!"F".equals(ismarket)){
	String 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=SYS1740V6&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;
	return ret;
}else if("T".equals(flag)){
	String num = cls2.type{cls};
	String num2 = cls3.type{cls};
	if("3".equals(num)){
		return "openreport?rptid=SYS1240V6&amp;amp;m_hotelid="+selectedhotelid;
	}else if("2".equals(num2)){
		return "openreport?rptid=SYS1239V6&amp;amp;m_date="+selectDate+"&amp;amp;m_enddate="+selectDate+
					"&amp;amp;m_cls="+$.cls+"&amp;amp;m_hotelid="+selectedhotelid;
	}else{
		return "openreport?rptid=SYS1238V6&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=empty&amp;amp;m_cls="+$.cls+"&amp;amp;m_hotelid="+selectedhotelid;
	}
}else if(!"F".equals(ispccode)){
	if("".equals(impindex)){
		impindex="empty";
		}
	return "openreport?rptid=SYS2114V6&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=SYS1857V6&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;/Item10&gt;&lt;Item11 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;/Item11&gt;&lt;Item12 Class="jatools.data.Formula" Name="mkt_codewhere"&gt;&lt;Text&gt;return getXcondition(selectedhotelid,"basecode","mktcode","","");&lt;/Text&gt;&lt;/Item12&gt;&lt;Item13 Class="jatools.data.Formula" Name="pccode_codewhere"&gt;&lt;Text&gt;String pccode_where = getXcondition(selectedhotelid,"basecode","pccode","","");
pccode_where = replaceAll(pccode_where,"code in","pccode in");
return pccode_where;&lt;/Text&gt;&lt;/Item13&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;main_sql&lt;/NodePath&gt;&lt;X&gt;78&lt;/X&gt;&lt;Y&gt;2&lt;/Y&gt;&lt;Children&gt;&lt;Item0 Class="Label"&gt;&lt;Text&gt;日期&lt;/Text&gt;&lt;Border/&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;3&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item0&gt;&lt;Item1 Class="Label"&gt;&lt;Text&gt;入住预订数&lt;/Text&gt;&lt;Border/&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;3&lt;/Row&gt;&lt;Col&gt;1&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item1&gt;&lt;Item2 Class="Label"&gt;&lt;Text&gt;入住间夜&lt;/Text&gt;&lt;Border/&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&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;Text&gt;平均入住间夜数&lt;/Text&gt;&lt;Border/&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;3&lt;/Row&gt;&lt;Col&gt;3&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item3&gt;&lt;Item4 Class="RowPanel"&gt;&lt;Cell&gt;&lt;Row&gt;4&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;ColSpan&gt;4&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;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;4&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item0&gt;&lt;Item1&gt;&lt;Variable&gt;=$.yds&lt;/Variable&gt;&lt;Border/&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;4&lt;/Row&gt;&lt;Col&gt;1&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item1&gt;&lt;Item2&gt;&lt;Variable&gt;=$.i_days&lt;/Variable&gt;&lt;Border/&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.0&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;4&lt;/Row&gt;&lt;Col&gt;2&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item2&gt;&lt;Item3&gt;&lt;Variable&gt;=$.i_days/$.yds&lt;/Variable&gt;&lt;Border/&gt;&lt;HorizontalAlignment&gt;1&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;4&lt;/Row&gt;&lt;Col&gt;3&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item3&gt;&lt;/Children&gt;&lt;NodePath&gt;Row&lt;/NodePath&gt;&lt;/Item4&gt;&lt;Item5 Class="Label"&gt;&lt;Text&gt;总计：&lt;/Text&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;/Item5&gt;&lt;Item6 Class="Text"&gt;&lt;Variable&gt;=$.yds.sum()&lt;/Variable&gt;&lt;Border/&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;1&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item6&gt;&lt;Item7 Class="Text"&gt;&lt;Variable&gt;=$.i_days.sum()&lt;/Variable&gt;&lt;Border/&gt;&lt;HorizontalAlignment&gt;1&lt;/HorizontalAlignment&gt;&lt;Format Class="DecimalFormat"&gt;&lt;Pattern&gt;0.0&lt;/Pattern&gt;&lt;/Format&gt;&lt;Cell&gt;&lt;Row&gt;5&lt;/Row&gt;&lt;Col&gt;2&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item7&gt;&lt;Item8 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;0&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;ColSpan&gt;4&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item8&gt;&lt;Item9 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;1&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;ColSpan&gt;4&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item9&gt;&lt;Item10 Class="Text"&gt;&lt;Variable&gt;=fmtdt8(startDate,endDate,"yyyy-MM-dd","yy-MM-dd")&lt;/Variable&gt;&lt;Cell&gt;&lt;Row&gt;2&lt;/Row&gt;&lt;Col&gt;0&lt;/Col&gt;&lt;ColSpan&gt;2&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item10&gt;&lt;Item11 Class="Text"&gt;&lt;Variable&gt;=printtime&lt;/Variable&gt;&lt;HorizontalAlignment&gt;2&lt;/HorizontalAlignment&gt;&lt;Cell&gt;&lt;Row&gt;2&lt;/Row&gt;&lt;Col&gt;2&lt;/Col&gt;&lt;ColSpan&gt;2&lt;/ColSpan&gt;&lt;/Cell&gt;&lt;/Item11&gt;&lt;Item12 Class="Text"&gt;&lt;Variable&gt;=$.i_days.sum()/$.yds.sum()&lt;/Variable&gt;&lt;Border/&gt;&lt;HorizontalAlignment&gt;1&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;5&lt;/Row&gt;&lt;Col&gt;3&lt;/Col&gt;&lt;/Cell&gt;&lt;/Item12&gt;&lt;/Children&gt;&lt;ColumnWidths&gt;150,150,150,150&lt;/ColumnWidths&gt;&lt;RowHeights&gt;31,30,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;main_sql&lt;/Name&gt;&lt;Sql&gt;select a.hotelid,a.date,sum(a.i_days) as i_days,(count(distinct b.resno)+count(distinct c.resno)) as yds
from ycus_xf a
left join master b on a.accnt =b.accnt and a.hotelid =b.hotelid and b.sta not in  ('X','D','H')
left join hmaster c on a.accnt =c.accnt and a.hotelid =c.hotelid and c.sta &amp;lt;&amp;gt;'X'
where a.hotelid ='${hotelid}' and a.date&amp;gt;='${startDate}' and a.date&amp;lt;='${endDate}' 
and (a.xf_rmrev&amp;lt;&amp;gt;0 or a.xf_tl&amp;lt;&amp;gt;0 or a.i_days&amp;lt;&amp;gt;0)  
group by a.date&lt;/Sql&gt;&lt;Description&gt;select a.hotelid,a.date,sum(a.i_days) as i_days,(count(distinct b.resno)+count(distinct c.resno)) as yds
from ycus_xf a
left join master b on a.accnt =b.accnt and a.hotelid =b.hotelid and b.sta not in  ('X','D','H')
left join hmaster c on a.accnt =c.accnt and a.hotelid =c.hotelid and c.sta &amp;lt;&amp;gt;'X'
where a.hotelid ='${hotelid}' and a.date&amp;gt;='${startDate}' and a.date&amp;lt;='${endDate}' 
and (a.xf_rmrev&amp;lt;&amp;gt;0 or a.xf_tl&amp;lt;&amp;gt;0 or a.i_days&amp;lt;&amp;gt;0)  
group by a.date&lt;/Description&gt;&lt;/Reader&gt;&lt;TagName&gt;main_sql&lt;/TagName&gt;&lt;/Item0&gt;&lt;/Children&gt;&lt;/NodeSource&gt;&lt;/jatools&gt;</syntax>
</foxreport>
