one_rule.cpt 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <WorkBook xmlVersion="20170720" releaseVersion="10.0.0">
  3. <TableDataMap>
  4. <TableData name="one_tule" class="com.fr.data.impl.DBTableData">
  5. <Parameters>
  6. <Parameter>
  7. <Attributes name="start_time"/>
  8. <O>
  9. <![CDATA[2010]]></O>
  10. </Parameter>
  11. <Parameter>
  12. <Attributes name="end_time"/>
  13. <O>
  14. <![CDATA[2018]]></O>
  15. </Parameter>
  16. <Parameter>
  17. <Attributes name="index_name"/>
  18. <O>
  19. <![CDATA[人口总数]]></O>
  20. </Parameter>
  21. <Parameter>
  22. <Attributes name="country_list"/>
  23. <O>
  24. <![CDATA[\'中国\',\'日本\']]></O>
  25. </Parameter>
  26. <Parameter>
  27. <Attributes name="table_name1"/>
  28. <O>
  29. <![CDATA[gei_app_data_wb]]></O>
  30. </Parameter>
  31. <Parameter>
  32. <Attributes name="index_id"/>
  33. <O>
  34. <![CDATA[]]></O>
  35. </Parameter>
  36. </Parameters>
  37. <Attributes maxMemRowCount="-1"/>
  38. <Connection class="com.fr.data.impl.NameDatabaseConnection">
  39. <DatabaseName>
  40. <![CDATA[dcp]]></DatabaseName>
  41. </Connection>
  42. <Query>
  43. <![CDATA[SELECT gs.EN_NAME as COUNTRY_CN_NAME,p.DATA_VALUE ,ifnull(p.INDEX_EN_NAME,'${index_name}') as INDEX_CN_NAME ,p.DATA_YEAR from gei_sys_country gs
  44. left JOIN (SELECT DATA_YEAR,COUNTRY_CN_NAME,INDEX_EN_NAME,DATA_VALUE FROM ${table_name1} WHERE DATA_YEAR >= '${start_time}' AND DATA_YEAR <= '${end_time}' AND INDEX_EN_NAME = '${index_name}' and INDEX_ID = ${index_id} AND COUNTRY_CN_NAME in(${country_list}))p on p.COUNTRY_CN_NAME = gs.CN_NAME
  45. WHERE gs.CN_NAME in (${country_list}) order by p.DATA_YEAR asc;]]></Query>
  46. <PageQuery>
  47. <![CDATA[]]></PageQuery>
  48. </TableData>
  49. </TableDataMap>
  50. <ElementCaseMobileAttr>
  51. <ElementCaseMobileAttrProvider horizontal="4" vertical="4" zoom="true" refresh="false" isUseHTML="false" isMobileCanvasSize="false" appearRefresh="false" allowFullScreen="false" allowDoubleClickOrZoom="true" functionalWhenUnactivated="false"/>
  52. </ElementCaseMobileAttr>
  53. <Report class="com.fr.report.worksheet.WorkSheet" name="sheet1">
  54. <ReportPageAttr>
  55. <HR/>
  56. <FR/>
  57. <HC/>
  58. <FC/>
  59. </ReportPageAttr>
  60. <ColumnPrivilegeControl/>
  61. <RowPrivilegeControl/>
  62. <RowHeight defaultValue="723900">
  63. <![CDATA[12725400,723900,723900,1066800,1447800,1066800,723900,723900,723900,723900,723900]]></RowHeight>
  64. <ColumnWidth defaultValue="2743200">
  65. <![CDATA[3695700,3848100,3848100,0,0,0,0,0,0,0,0,0,0,0,0,0,2743200]]></ColumnWidth>
  66. <CellElementList>
  67. <C c="0" r="0" cs="19">
  68. <O t="CC">
  69. <LayoutAttr selectedIndex="0"/>
  70. <ChangeAttr enable="false" changeType="button" timeInterval="5" buttonColor="-6710887" carouselColor="-8421505" showArrow="true">
  71. <TextAttr>
  72. <Attr alignText="0" predefinedStyle="false">
  73. <FRFont name="PingFangSC-Regular" style="0" size="96" foreground="-1"/>
  74. </Attr>
  75. </TextAttr>
  76. </ChangeAttr>
  77. <Chart name="默认" chartClass="com.fr.plugin.chart.vanchart.VanChart">
  78. <Chart class="com.fr.plugin.chart.vanchart.VanChart">
  79. <GI>
  80. <AttrBackground>
  81. <Background name="NullBackground"/>
  82. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
  83. </AttrBackground>
  84. <AttrBorder>
  85. <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
  86. <newColor borderColor="-1118482" autoColor="false" predefinedStyle="false"/>
  87. </AttrBorder>
  88. <AttrAlpha>
  89. <Attr alpha="1.0"/>
  90. </AttrAlpha>
  91. </GI>
  92. <ChartAttr isJSDraw="true" isStyleGlobal="false"/>
  93. <Title4VanChart>
  94. <Title>
  95. <GI>
  96. <AttrBackground>
  97. <Background name="NullBackground"/>
  98. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
  99. </AttrBackground>
  100. <AttrBorder>
  101. <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
  102. <newColor borderColor="-6908266" autoColor="false" predefinedStyle="false"/>
  103. </AttrBorder>
  104. <AttrAlpha>
  105. <Attr alpha="1.0"/>
  106. </AttrAlpha>
  107. </GI>
  108. <O t="XMLable" class="com.fr.base.Formula">
  109. <Attributes>
  110. <![CDATA[=$index_name]]></Attributes>
  111. </O>
  112. <TextAttr>
  113. <Attr alignText="0" predefinedStyle="false">
  114. <FRFont name="微软雅黑" style="0" size="128" foreground="-13421773"/>
  115. </Attr>
  116. </TextAttr>
  117. <TitleVisible value="true" position="0"/>
  118. </Title>
  119. <Attr4VanChart useHtml="false" floating="false" x="0.0" y="0.0" limitSize="false" maxHeight="15.0"/>
  120. </Title4VanChart>
  121. <Plot class="com.fr.plugin.chart.line.VanChartLinePlot">
  122. <VanChartPlotVersion version="20170715"/>
  123. <GI>
  124. <AttrBackground>
  125. <Background name="NullBackground"/>
  126. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
  127. </AttrBackground>
  128. <AttrBorder>
  129. <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
  130. <newColor/>
  131. </AttrBorder>
  132. <AttrAlpha>
  133. <Attr alpha="1.0"/>
  134. </AttrAlpha>
  135. </GI>
  136. <Attr isNullValueBreak="true" autoRefreshPerSecond="6" seriesDragEnable="false" plotStyle="4" combinedSize="50.0"/>
  137. <newHotTooltipStyle>
  138. <AttrContents>
  139. <Attr showLine="false" position="1" isWhiteBackground="true" isShowMutiSeries="false" seriesLabel="${VALUE}"/>
  140. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  141. <![CDATA[#.##]]></Format>
  142. <PercentFormat>
  143. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  144. <![CDATA[#0.##%]]></Format>
  145. </PercentFormat>
  146. </AttrContents>
  147. </newHotTooltipStyle>
  148. <ConditionCollection>
  149. <DefaultAttr class="com.fr.chart.chartglyph.ConditionAttr">
  150. <ConditionAttr name="">
  151. <AttrList>
  152. <Attr class="com.fr.plugin.chart.base.AttrTooltip">
  153. <AttrTooltip>
  154. <Attr enable="true" duration="4" followMouse="false" showMutiSeries="false" isCustom="false"/>
  155. <TextAttr>
  156. <Attr alignText="0" predefinedStyle="false"/>
  157. </TextAttr>
  158. <AttrToolTipContent>
  159. <TextAttr>
  160. <Attr alignText="0" predefinedStyle="false"/>
  161. </TextAttr>
  162. <richText class="com.fr.plugin.chart.base.AttrTooltipRichText">
  163. <AttrTooltipRichText>
  164. <Attr content="" isAuto="true" initParamsContent=""/>
  165. <params>
  166. <![CDATA[{}]]></params>
  167. </AttrTooltipRichText>
  168. </richText>
  169. <richTextValue class="com.fr.plugin.chart.base.format.AttrTooltipValueFormat">
  170. <AttrTooltipValueFormat>
  171. <Attr enable="true"/>
  172. </AttrTooltipValueFormat>
  173. </richTextValue>
  174. <richTextPercent class="com.fr.plugin.chart.base.format.AttrTooltipPercentFormat">
  175. <AttrTooltipPercentFormat>
  176. <Attr enable="false"/>
  177. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  178. <![CDATA[#.##%]]></Format>
  179. </AttrTooltipPercentFormat>
  180. </richTextPercent>
  181. <richTextCategory class="com.fr.plugin.chart.base.format.AttrTooltipCategoryFormat">
  182. <AttrToolTipCategoryFormat>
  183. <Attr enable="true"/>
  184. </AttrToolTipCategoryFormat>
  185. </richTextCategory>
  186. <richTextSeries class="com.fr.plugin.chart.base.format.AttrTooltipSeriesFormat">
  187. <AttrTooltipSeriesFormat>
  188. <Attr enable="true"/>
  189. </AttrTooltipSeriesFormat>
  190. </richTextSeries>
  191. <richTextChangedPercent class="com.fr.plugin.chart.base.format.AttrTooltipChangedPercentFormat">
  192. <AttrTooltipChangedPercentFormat>
  193. <Attr enable="false"/>
  194. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  195. <![CDATA[#.##%]]></Format>
  196. </AttrTooltipChangedPercentFormat>
  197. </richTextChangedPercent>
  198. <richTextChangedValue class="com.fr.plugin.chart.base.format.AttrTooltipChangedValueFormat">
  199. <AttrTooltipChangedValueFormat>
  200. <Attr enable="false"/>
  201. </AttrTooltipChangedValueFormat>
  202. </richTextChangedValue>
  203. <TableFieldCollection/>
  204. <Attr isCommon="true" isCustom="false" isRichText="false" richTextAlign="left" showAllSeries="false"/>
  205. <value class="com.fr.plugin.chart.base.format.AttrTooltipValueFormat">
  206. <AttrTooltipValueFormat>
  207. <Attr enable="true"/>
  208. </AttrTooltipValueFormat>
  209. </value>
  210. <percent class="com.fr.plugin.chart.base.format.AttrTooltipPercentFormat">
  211. <AttrTooltipPercentFormat>
  212. <Attr enable="false"/>
  213. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  214. <![CDATA[#.##%]]></Format>
  215. </AttrTooltipPercentFormat>
  216. </percent>
  217. <category class="com.fr.plugin.chart.base.format.AttrTooltipCategoryFormat">
  218. <AttrToolTipCategoryFormat>
  219. <Attr enable="true"/>
  220. </AttrToolTipCategoryFormat>
  221. </category>
  222. <series class="com.fr.plugin.chart.base.format.AttrTooltipSeriesFormat">
  223. <AttrTooltipSeriesFormat>
  224. <Attr enable="true"/>
  225. </AttrTooltipSeriesFormat>
  226. </series>
  227. <changedPercent class="com.fr.plugin.chart.base.format.AttrTooltipChangedPercentFormat">
  228. <AttrTooltipChangedPercentFormat>
  229. <Attr enable="false"/>
  230. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  231. <![CDATA[#.##%]]></Format>
  232. </AttrTooltipChangedPercentFormat>
  233. </changedPercent>
  234. <changedValue class="com.fr.plugin.chart.base.format.AttrTooltipChangedValueFormat">
  235. <AttrTooltipChangedValueFormat>
  236. <Attr enable="false"/>
  237. </AttrTooltipChangedValueFormat>
  238. </changedValue>
  239. <HtmlLabel customText="" useHtml="false" isCustomWidth="false" isCustomHeight="false" width="50" height="50"/>
  240. </AttrToolTipContent>
  241. <GI>
  242. <AttrBackground>
  243. <Background name="ColorBackground" color="-16777216"/>
  244. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="true" autoBackground="false" predefinedStyle="false"/>
  245. </AttrBackground>
  246. <AttrBorder>
  247. <Attr lineStyle="0" isRoundBorder="false" roundRadius="2"/>
  248. <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
  249. </AttrBorder>
  250. <AttrAlpha>
  251. <Attr alpha="0.5"/>
  252. </AttrAlpha>
  253. </GI>
  254. </AttrTooltip>
  255. </Attr>
  256. <Attr class="com.fr.plugin.chart.base.VanChartAttrMarker">
  257. <VanAttrMarker>
  258. <Attr isCommon="true" anchorSize="22.0" markerType="AutoMarker" radius="3.5" width="30.0" height="30.0"/>
  259. <Background name="NullBackground"/>
  260. </VanAttrMarker>
  261. </Attr>
  262. <Attr class="com.fr.plugin.chart.base.VanChartAttrLine">
  263. <VanAttrLine>
  264. <Attr lineType="solid" lineWidth="2.0" lineStyle="0" nullValueBreak="true"/>
  265. </VanAttrLine>
  266. </Attr>
  267. </AttrList>
  268. </ConditionAttr>
  269. </DefaultAttr>
  270. </ConditionCollection>
  271. <Legend4VanChart>
  272. <Legend>
  273. <GI>
  274. <AttrBackground>
  275. <Background name="NullBackground"/>
  276. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
  277. </AttrBackground>
  278. <AttrBorder>
  279. <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
  280. <newColor borderColor="-3355444" autoColor="false" predefinedStyle="false"/>
  281. </AttrBorder>
  282. <AttrAlpha>
  283. <Attr alpha="1.0"/>
  284. </AttrAlpha>
  285. </GI>
  286. <Attr position="4" visible="true" predefinedStyle="false"/>
  287. <FRFont name="Microsoft YaHei" style="0" size="88" foreground="-10066330"/>
  288. </Legend>
  289. <Attr4VanChart floating="false" x="0.0" y="0.0" layout="aligned" customSize="false" maxHeight="30.0" isHighlight="true"/>
  290. </Legend4VanChart>
  291. <DataSheet>
  292. <GI>
  293. <AttrBackground>
  294. <Background name="NullBackground"/>
  295. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
  296. </AttrBackground>
  297. <AttrBorder>
  298. <Attr lineStyle="1" isRoundBorder="false" roundRadius="0"/>
  299. <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
  300. </AttrBorder>
  301. <AttrAlpha>
  302. <Attr alpha="1.0"/>
  303. </AttrAlpha>
  304. </GI>
  305. <Attr isVisible="false" predefinedStyle="false"/>
  306. <FRFont name="SimSun" style="0" size="72"/>
  307. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  308. <![CDATA[#.##]]></Format>
  309. </DataSheet>
  310. <DataProcessor class="com.fr.base.chart.chartdata.model.NormalDataModel"/>
  311. <newPlotFillStyle>
  312. <AttrFillStyle>
  313. <AFStyle colorStyle="0"/>
  314. <FillStyleName fillStyleName=""/>
  315. <isCustomFillStyle isCustomFillStyle="false"/>
  316. <PredefinedStyle predefinedStyle="false"/>
  317. </AttrFillStyle>
  318. </newPlotFillStyle>
  319. <VanChartPlotAttr isAxisRotation="false" categoryNum="1"/>
  320. <GradientStyle>
  321. <Attr gradientType="gradual" startColor="-12146441" endColor="-9378161"/>
  322. </GradientStyle>
  323. <VanChartRectanglePlotAttr vanChartPlotType="normal" isDefaultIntervalBackground="true"/>
  324. <XAxisList>
  325. <VanChartAxis class="com.fr.plugin.chart.attr.axis.VanChartAxis">
  326. <Title>
  327. <GI>
  328. <AttrBackground>
  329. <Background name="NullBackground"/>
  330. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
  331. </AttrBackground>
  332. <AttrBorder>
  333. <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
  334. <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
  335. </AttrBorder>
  336. <AttrAlpha>
  337. <Attr alpha="1.0"/>
  338. </AttrAlpha>
  339. </GI>
  340. <O>
  341. <![CDATA[YEAR]]></O>
  342. <TextAttr>
  343. <Attr alignText="0" predefinedStyle="false">
  344. <FRFont name="Verdana" style="0" size="88" foreground="-10066330"/>
  345. </Attr>
  346. </TextAttr>
  347. <TitleVisible value="true" position="4"/>
  348. </Title>
  349. <newAxisAttr isShowAxisLabel="true"/>
  350. <AxisLineStyle AxisStyle="1" MainGridStyle="1"/>
  351. <newLineColor lineColor="-5197648" predefinedStyle="false"/>
  352. <AxisPosition value="3"/>
  353. <TickLine201106 type="2" secType="0"/>
  354. <ArrowShow arrowShow="false"/>
  355. <TextAttr>
  356. <Attr alignText="0" predefinedStyle="false">
  357. <FRFont name="Verdana" style="0" size="88" foreground="-10066330"/>
  358. </Attr>
  359. </TextAttr>
  360. <AxisLabelCount value="=1"/>
  361. <AxisRange/>
  362. <AxisUnit201106 isCustomMainUnit="false" isCustomSecUnit="false" mainUnit="=0" secUnit="=0"/>
  363. <ZoomAxisAttr isZoom="false"/>
  364. <axisReversed axisReversed="false"/>
  365. <VanChartAxisAttr mainTickLine="2" secTickLine="0" axisName="X轴" titleUseHtml="false" labelDisplay="interval" autoLabelGap="true" limitSize="false" maxHeight="15.0" commonValueFormat="true" isRotation="false" isShowAxisTitle="true" gridLineType="NONE"/>
  366. <HtmlLabel customText="function(){ return this; }" useHtml="false" isCustomWidth="false" isCustomHeight="false" width="50" height="50"/>
  367. <alertList/>
  368. <customBackgroundList/>
  369. </VanChartAxis>
  370. </XAxisList>
  371. <YAxisList>
  372. <VanChartAxis class="com.fr.plugin.chart.attr.axis.VanChartValueAxis">
  373. <Title>
  374. <GI>
  375. <AttrBackground>
  376. <Background name="NullBackground"/>
  377. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
  378. </AttrBackground>
  379. <AttrBorder>
  380. <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
  381. <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
  382. </AttrBorder>
  383. <AttrAlpha>
  384. <Attr alpha="1.0"/>
  385. </AttrAlpha>
  386. </GI>
  387. <O t="XMLable" class="com.fr.base.Formula">
  388. <Attributes>
  389. <![CDATA[=$unit_name1]]></Attributes>
  390. </O>
  391. <TextAttr>
  392. <Attr rotation="-90" alignText="0" predefinedStyle="false">
  393. <FRFont name="Verdana" style="0" size="88" foreground="-10066330"/>
  394. </Attr>
  395. </TextAttr>
  396. <TitleVisible value="true" position="1"/>
  397. </Title>
  398. <newAxisAttr isShowAxisLabel="true"/>
  399. <AxisLineStyle AxisStyle="0" MainGridStyle="1"/>
  400. <newLineColor mainGridColor="-3881788" mainGridPredefinedStyle="false" lineColor="-5197648" predefinedStyle="false"/>
  401. <AxisPosition value="2"/>
  402. <TickLine201106 type="2" secType="0"/>
  403. <ArrowShow arrowShow="false"/>
  404. <TextAttr>
  405. <Attr alignText="0" predefinedStyle="false">
  406. <FRFont name="Verdana" style="0" size="88" foreground="-10066330"/>
  407. </Attr>
  408. </TextAttr>
  409. <AxisLabelCount value="=1"/>
  410. <AxisRange/>
  411. <AxisUnit201106 isCustomMainUnit="false" isCustomSecUnit="false" mainUnit="=0" secUnit="=0"/>
  412. <ZoomAxisAttr isZoom="false"/>
  413. <axisReversed axisReversed="false"/>
  414. <VanChartAxisAttr mainTickLine="0" secTickLine="0" axisName="Y轴" titleUseHtml="false" labelDisplay="interval" autoLabelGap="true" limitSize="false" maxHeight="15.0" commonValueFormat="true" isRotation="false" isShowAxisTitle="true" gridLineType="solid"/>
  415. <HtmlLabel customText="function(){ return this; }" useHtml="false" isCustomWidth="false" isCustomHeight="false" width="50" height="50"/>
  416. <alertList/>
  417. <customBackgroundList/>
  418. <VanChartValueAxisAttr isLog="false" valueStyle="false" baseLog="=10"/>
  419. <ds>
  420. <RadarYAxisTableDefinition>
  421. <Top topCate="-1" topValue="-1" isDiscardOtherCate="false" isDiscardOtherSeries="false" isDiscardNullCate="false" isDiscardNullSeries="false"/>
  422. <attr/>
  423. </RadarYAxisTableDefinition>
  424. </ds>
  425. </VanChartAxis>
  426. </YAxisList>
  427. <stackAndAxisCondition>
  428. <ConditionCollection>
  429. <DefaultAttr class="com.fr.chart.chartglyph.ConditionAttr">
  430. <ConditionAttr name=""/>
  431. </DefaultAttr>
  432. </ConditionCollection>
  433. </stackAndAxisCondition>
  434. </Plot>
  435. <ChartDefinition>
  436. <OneValueCDDefinition seriesName="COUNTRY_CN_NAME" valueName="DATA_VALUE" function="com.fr.data.util.function.SumFunction">
  437. <Top topCate="-1" topValue="-1" isDiscardOtherCate="false" isDiscardOtherSeries="false" isDiscardNullCate="false" isDiscardNullSeries="false"/>
  438. <TableData class="com.fr.data.impl.NameTableData">
  439. <Name>
  440. <![CDATA[one_tule]]></Name>
  441. </TableData>
  442. <CategoryName value="DATA_YEAR"/>
  443. </OneValueCDDefinition>
  444. </ChartDefinition>
  445. </Chart>
  446. <UUID uuid="00703ed8-c691-4ce6-83a9-43692c415685"/>
  447. <tools hidden="true" sort="true" export="true" fullScreen="true"/>
  448. <VanChartZoom>
  449. <zoomAttr zoomVisible="false" zoomGesture="true" zoomResize="true" zoomType="xy" controlType="zoom" categoryNum="8" scaling="0.3"/>
  450. <from>
  451. <![CDATA[]]></from>
  452. <to>
  453. <![CDATA[]]></to>
  454. </VanChartZoom>
  455. <refreshMoreLabel>
  456. <attr moreLabel="false" autoTooltip="true"/>
  457. <AttrTooltip>
  458. <Attr enable="true" duration="4" followMouse="false" showMutiSeries="false" isCustom="false"/>
  459. <TextAttr>
  460. <Attr alignText="0" predefinedStyle="false"/>
  461. </TextAttr>
  462. <AttrToolTipContent>
  463. <TextAttr>
  464. <Attr alignText="0" predefinedStyle="false"/>
  465. </TextAttr>
  466. <richText class="com.fr.plugin.chart.base.AttrTooltipRichText">
  467. <AttrTooltipRichText>
  468. <Attr content="" isAuto="true" initParamsContent=""/>
  469. <params>
  470. <![CDATA[{}]]></params>
  471. </AttrTooltipRichText>
  472. </richText>
  473. <richTextValue class="com.fr.plugin.chart.base.format.AttrTooltipValueFormat">
  474. <AttrTooltipValueFormat>
  475. <Attr enable="true"/>
  476. </AttrTooltipValueFormat>
  477. </richTextValue>
  478. <richTextPercent class="com.fr.plugin.chart.base.format.AttrTooltipPercentFormat">
  479. <AttrTooltipPercentFormat>
  480. <Attr enable="false"/>
  481. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  482. <![CDATA[#.##%]]></Format>
  483. </AttrTooltipPercentFormat>
  484. </richTextPercent>
  485. <richTextCategory class="com.fr.plugin.chart.base.format.AttrTooltipCategoryFormat">
  486. <AttrToolTipCategoryFormat>
  487. <Attr enable="false"/>
  488. </AttrToolTipCategoryFormat>
  489. </richTextCategory>
  490. <richTextSeries class="com.fr.plugin.chart.base.format.AttrTooltipSeriesFormat">
  491. <AttrTooltipSeriesFormat>
  492. <Attr enable="false"/>
  493. </AttrTooltipSeriesFormat>
  494. </richTextSeries>
  495. <richTextChangedPercent class="com.fr.plugin.chart.base.format.AttrTooltipChangedPercentFormat">
  496. <AttrTooltipChangedPercentFormat>
  497. <Attr enable="false"/>
  498. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  499. <![CDATA[#.##%]]></Format>
  500. </AttrTooltipChangedPercentFormat>
  501. </richTextChangedPercent>
  502. <richTextChangedValue class="com.fr.plugin.chart.base.format.AttrTooltipChangedValueFormat">
  503. <AttrTooltipChangedValueFormat>
  504. <Attr enable="false"/>
  505. </AttrTooltipChangedValueFormat>
  506. </richTextChangedValue>
  507. <TableFieldCollection/>
  508. <Attr isCommon="true" isCustom="false" isRichText="false" richTextAlign="left" showAllSeries="false"/>
  509. <value class="com.fr.plugin.chart.base.format.AttrTooltipValueFormat">
  510. <AttrTooltipValueFormat>
  511. <Attr enable="true"/>
  512. </AttrTooltipValueFormat>
  513. </value>
  514. <percent class="com.fr.plugin.chart.base.format.AttrTooltipPercentFormat">
  515. <AttrTooltipPercentFormat>
  516. <Attr enable="false"/>
  517. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  518. <![CDATA[#.##%]]></Format>
  519. </AttrTooltipPercentFormat>
  520. </percent>
  521. <category class="com.fr.plugin.chart.base.format.AttrTooltipCategoryFormat">
  522. <AttrToolTipCategoryFormat>
  523. <Attr enable="true"/>
  524. </AttrToolTipCategoryFormat>
  525. </category>
  526. <series class="com.fr.plugin.chart.base.format.AttrTooltipSeriesFormat">
  527. <AttrTooltipSeriesFormat>
  528. <Attr enable="true"/>
  529. </AttrTooltipSeriesFormat>
  530. </series>
  531. <changedPercent class="com.fr.plugin.chart.base.format.AttrTooltipChangedPercentFormat">
  532. <AttrTooltipChangedPercentFormat>
  533. <Attr enable="false"/>
  534. <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
  535. <![CDATA[#.##%]]></Format>
  536. </AttrTooltipChangedPercentFormat>
  537. </changedPercent>
  538. <changedValue class="com.fr.plugin.chart.base.format.AttrTooltipChangedValueFormat">
  539. <AttrTooltipChangedValueFormat>
  540. <Attr enable="true"/>
  541. </AttrTooltipChangedValueFormat>
  542. </changedValue>
  543. <HtmlLabel customText="" useHtml="false" isCustomWidth="false" isCustomHeight="false" width="50" height="50"/>
  544. </AttrToolTipContent>
  545. <GI>
  546. <AttrBackground>
  547. <Background name="ColorBackground" color="-1"/>
  548. <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
  549. </AttrBackground>
  550. <AttrBorder>
  551. <Attr lineStyle="1" isRoundBorder="false" roundRadius="4"/>
  552. <newColor borderColor="-15395563" autoColor="false" predefinedStyle="false"/>
  553. </AttrBorder>
  554. <AttrAlpha>
  555. <Attr alpha="0.8"/>
  556. </AttrAlpha>
  557. </GI>
  558. </AttrTooltip>
  559. </refreshMoreLabel>
  560. <ThemeAttr>
  561. <Attr darkTheme="false" predefinedStyle="false"/>
  562. </ThemeAttr>
  563. </Chart>
  564. </O>
  565. <PrivilegeControl/>
  566. <Expand/>
  567. </C>
  568. <C c="0" r="1" cs="3" s="0">
  569. <O t="XMLable" class="com.fr.base.Formula">
  570. <Attributes>
  571. <![CDATA[="PS:The data comes from international organizations such as the world bank.(DATA SOURCE:" + (if(find("wb", $table_name1) > 0, "WORLD BANK", "") || if(find("iea", $table_name1) > 0, "IEA", "") || if(find("eia", $table_name1) > 0, "EIA)", "") || if(find("bp", $table_name1) > 0, "BP", "")) + ")"]]></Attributes>
  572. </O>
  573. <PrivilegeControl/>
  574. <Expand/>
  575. </C>
  576. <C c="0" r="3" s="1">
  577. <O t="XMLable" class="com.fr.base.Formula">
  578. <Attributes>
  579. <![CDATA[="YEAR(INDEX'S UNIT:" + $unit_name1 + ")"]]></Attributes>
  580. </O>
  581. <PrivilegeControl/>
  582. <Expand/>
  583. </C>
  584. <C c="1" r="3" s="1">
  585. <O t="DSColumn">
  586. <Attributes dsName="one_tule" columnName="COUNTRY_CN_NAME"/>
  587. <Condition class="com.fr.data.condition.ListCondition"/>
  588. <Complex/>
  589. <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
  590. <Result>
  591. <![CDATA[$$$]]></Result>
  592. <Parameters/>
  593. </O>
  594. <PrivilegeControl/>
  595. <Expand dir="1"/>
  596. </C>
  597. <C c="2" r="3" s="1">
  598. <O>
  599. <![CDATA[SUM]]></O>
  600. <PrivilegeControl/>
  601. <Expand/>
  602. </C>
  603. <C c="3" r="3" s="2">
  604. <PrivilegeControl/>
  605. <Expand/>
  606. </C>
  607. <C c="0" r="4" s="1">
  608. <O t="DSColumn">
  609. <Attributes dsName="one_tule" columnName="DATA_YEAR"/>
  610. <Condition class="com.fr.data.condition.ListCondition"/>
  611. <Complex/>
  612. <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
  613. <Result>
  614. <![CDATA[$$$]]></Result>
  615. <Parameters/>
  616. </O>
  617. <PrivilegeControl/>
  618. <HighlightList>
  619. <Highlight class="com.fr.report.cell.cellattr.highlight.DefaultHighlight">
  620. <Name>
  621. <![CDATA[条件属性1]]></Name>
  622. <Condition class="com.fr.data.condition.FormulaCondition">
  623. <Formula>
  624. <![CDATA[len(A5) = 0]]></Formula>
  625. </Condition>
  626. <HighlightAction class="com.fr.report.cell.cellattr.highlight.RowHeightHighlightAction"/>
  627. </Highlight>
  628. </HighlightList>
  629. <Expand dir="0"/>
  630. </C>
  631. <C c="1" r="4" s="3">
  632. <O t="DSColumn">
  633. <Attributes dsName="one_tule" columnName="DATA_VALUE"/>
  634. <Condition class="com.fr.data.condition.ListCondition"/>
  635. <Complex/>
  636. <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
  637. <Result>
  638. <![CDATA[$$$]]></Result>
  639. <Parameters/>
  640. </O>
  641. <PrivilegeControl/>
  642. <Expand/>
  643. </C>
  644. <C c="2" r="4" s="3">
  645. <O t="XMLable" class="com.fr.base.Formula">
  646. <Attributes>
  647. <![CDATA[=if(isnull(B5), "", SUM(B5))]]></Attributes>
  648. </O>
  649. <PrivilegeControl/>
  650. <Expand/>
  651. </C>
  652. <C c="3" r="4" s="2">
  653. <PrivilegeControl/>
  654. <Expand/>
  655. </C>
  656. <C c="0" r="5" s="1">
  657. <O>
  658. <![CDATA[SUM]]></O>
  659. <PrivilegeControl/>
  660. <Expand/>
  661. </C>
  662. <C c="1" r="5" s="3">
  663. <O t="XMLable" class="com.fr.base.Formula">
  664. <Attributes>
  665. <![CDATA[=if(ISNULL(B5), "", SUM(B5))]]></Attributes>
  666. </O>
  667. <PrivilegeControl/>
  668. <Expand/>
  669. </C>
  670. <C c="2" r="5" s="3">
  671. <O t="XMLable" class="com.fr.base.Formula">
  672. <Attributes>
  673. <![CDATA[=if(ISNULL(C5), "", SUM(C5))]]></Attributes>
  674. </O>
  675. <PrivilegeControl/>
  676. <Expand/>
  677. </C>
  678. <C c="3" r="5" s="2">
  679. <PrivilegeControl/>
  680. <Expand/>
  681. </C>
  682. </CellElementList>
  683. <ReportAttrSet>
  684. <ReportSettings headerHeight="0" footerHeight="0">
  685. <PaperSetting orientation="1">
  686. <Margin top="986400" left="2743200" bottom="986400" right="2743200"/>
  687. </PaperSetting>
  688. <Background name="ColorBackground" color="-1"/>
  689. </ReportSettings>
  690. <Header reportPageType="0">
  691. <Background name="NullBackground"/>
  692. <LeftList/>
  693. <CenterList/>
  694. <RightList/>
  695. </Header>
  696. <Footer reportPageType="0">
  697. <Background name="NullBackground"/>
  698. <LeftList/>
  699. <CenterList/>
  700. <RightList/>
  701. </Footer>
  702. </ReportAttrSet>
  703. <PrivilegeControl/>
  704. </Report>
  705. <ReportParameterAttr>
  706. <Attributes showWindow="true" delayPlaying="true" windowPosition="1" align="0" useParamsTemplate="true" currentIndex="0"/>
  707. <PWTitle>
  708. <![CDATA[参数]]></PWTitle>
  709. <Parameter>
  710. <Attributes name="index_name"/>
  711. <O>
  712. <![CDATA[外债总额]]></O>
  713. </Parameter>
  714. <Parameter>
  715. <Attributes name="start_time"/>
  716. <O>
  717. <![CDATA[2013]]></O>
  718. </Parameter>
  719. <Parameter>
  720. <Attributes name="end_time"/>
  721. <O>
  722. <![CDATA[2020]]></O>
  723. </Parameter>
  724. <Parameter>
  725. <Attributes name="country_list"/>
  726. <O>
  727. <![CDATA[\"中国\",\"法国\"]]></O>
  728. </Parameter>
  729. <Parameter>
  730. <Attributes name="table_name1"/>
  731. <O>
  732. <![CDATA[gei_app_data_iea]]></O>
  733. </Parameter>
  734. <Parameter>
  735. <Attributes name="unit_name1"/>
  736. <O>
  737. <![CDATA[]]></O>
  738. </Parameter>
  739. <Parameter>
  740. <Attributes name="index_id"/>
  741. <O>
  742. <![CDATA[223]]></O>
  743. </Parameter>
  744. </ReportParameterAttr>
  745. <StyleList>
  746. <Style imageLayout="1">
  747. <FRFont name="SimSun" style="0" size="72" foreground="-4144960"/>
  748. <Background name="NullBackground"/>
  749. <Border/>
  750. </Style>
  751. <Style horizontal_alignment="0" imageLayout="1">
  752. <FRFont name="SimSun" style="0" size="72"/>
  753. <Background name="ColorBackground" color="-3342337"/>
  754. <Border>
  755. <Top style="1" color="-16777216"/>
  756. <Bottom style="1" color="-16777216"/>
  757. <Left style="1" color="-16777216"/>
  758. <Right style="1" color="-16777216"/>
  759. </Border>
  760. </Style>
  761. <Style horizontal_alignment="0" imageLayout="1">
  762. <FRFont name="SimSun" style="0" size="72"/>
  763. <Background name="NullBackground"/>
  764. <Border/>
  765. </Style>
  766. <Style horizontal_alignment="0" imageLayout="1">
  767. <FRFont name="SimSun" style="0" size="72"/>
  768. <Background name="NullBackground"/>
  769. <Border>
  770. <Top style="1"/>
  771. <Bottom style="1"/>
  772. <Left style="1"/>
  773. <Right style="1"/>
  774. </Border>
  775. </Style>
  776. </StyleList>
  777. <DesignerVersion DesignerVersion="KAA"/>
  778. <PreviewType PreviewType="0"/>
  779. <TemplateCloudInfoAttrMark class="com.fr.plugin.cloud.analytics.attr.TemplateInfoAttrMark" pluginID="com.fr.plugin.cloud.analytics.v10" plugin-version="2.3.4.20211109">
  780. <TemplateCloudInfoAttrMark createTime="1630373918220"/>
  781. </TemplateCloudInfoAttrMark>
  782. <TemplateIdAttMark class="com.fr.base.iofile.attr.TemplateIdAttrMark">
  783. <TemplateIdAttMark TemplateId="1ecf4f93-3de0-447e-8e80-71d00ae175fa"/>
  784. </TemplateIdAttMark>
  785. </WorkBook>