API tools faq
paste
Guest User

Untitled

a guest
Apr 19th, 2017
71
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 43.09 KB | None | 0 0
raw download clone embed print report
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
  3. <property name="createdBy">Eclipse BIRT Designer Version 4.5.0.v201506092134 Build &lt;@BUILD@></property>
  4. <list-property name="propertyBindings">
  5. <structure>
  6. <property name="name">rowFetchSize</property>
  7. <property name="id">8</property>
  8. <expression name="value" type="javascript">50</expression>
  9. </structure>
  10. <structure>
  11. <property name="name">queryText</property>
  12. <property name="id">130</property>
  13. </structure>
  14. <structure>
  15. <property name="name">queryTimeOut</property>
  16. <property name="id">130</property>
  17. </structure>
  18. <structure>
  19. <property name="name">rowFetchSize</property>
  20. <property name="id">130</property>
  21. </structure>
  22. </list-property>
  23. <property name="units">in</property>
  24. <property name="iconFile">/templates/blank_report.gif</property>
  25. <property name="bidiLayoutOrientation">ltr</property>
  26. <property name="imageDPI">96</property>
  27. <parameters>
  28. <scalar-parameter name="id_template" id="9">
  29. <property name="hidden">false</property>
  30. <property name="valueType">static</property>
  31. <property name="dataType">integer</property>
  32. <property name="distinct">true</property>
  33. <simple-property-list name="defaultValue">
  34. <value type="constant">1376</value>
  35. </simple-property-list>
  36. <list-property name="selectionList"/>
  37. <property name="paramType">simple</property>
  38. <property name="controlType">text-box</property>
  39. <structure name="format">
  40. <property name="category">Unformatted</property>
  41. </structure>
  42. </scalar-parameter>
  43. <scalar-parameter name="_currentUser" id="288">
  44. <property name="valueType">static</property>
  45. <property name="dataType">string</property>
  46. <property name="distinct">true</property>
  47. <list-property name="selectionList"/>
  48. <property name="paramType">simple</property>
  49. <property name="controlType">text-box</property>
  50. <structure name="format">
  51. <property name="category">Unformatted</property>
  52. </structure>
  53. </scalar-parameter>
  54. </parameters>
  55. <data-sources>
  56. <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="wlapp_u1@general" id="7">
  57. <list-property name="privateDriverProperties">
  58. <ex-property>
  59. <name>metadataBidiFormatStr</name>
  60. <value>ILYNN</value>
  61. </ex-property>
  62. <ex-property>
  63. <name>disabledMetadataBidiFormatStr</name>
  64. </ex-property>
  65. <ex-property>
  66. <name>contentBidiFormatStr</name>
  67. <value>ILYNN</value>
  68. </ex-property>
  69. <ex-property>
  70. <name>disabledContentBidiFormatStr</name>
  71. </ex-property>
  72. </list-property>
  73. <property name="odaDriverClass">oracle.jdbc.OracleDriver</property>
  74. <property name="odaURL">jdbc:oracle:thin:@//gdb1.miit.ru:1521/cgeneral.miit.ru</property>
  75. <property name="odaUser">wlapp_u1</property>
  76. <encrypted-property name="odaPassword" encryptionID="base64">anNoNWpqeA==</encrypted-property>
  77. <property name="odaJndiName">jdbc/ds_basic</property>
  78. </oda-data-source>
  79. </data-sources>
  80. <data-sets>
  81. <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="TemplateTree" id="8">
  82. <property name="nullsOrdering">nulls lowest</property>
  83. <list-property name="columnHints"/>
  84. <list-property name="parameters">
  85. <structure>
  86. <property name="name">id_template</property>
  87. <property name="paramName">id_template</property>
  88. <property name="nativeName"></property>
  89. <property name="dataType">integer</property>
  90. <property name="nativeDataType">0</property>
  91. <property name="position">1</property>
  92. <property name="isOptional">false</property>
  93. <property name="isInput">true</property>
  94. <property name="isOutput">false</property>
  95. </structure>
  96. </list-property>
  97. <structure name="cachedMetaData">
  98. <list-property name="resultSet">
  99. <structure>
  100. <property name="position">1</property>
  101. <property name="name">COMP_SORT</property>
  102. <property name="dataType">decimal</property>
  103. </structure>
  104. <structure>
  105. <property name="position">2</property>
  106. <property name="name">COMP_NAME</property>
  107. <property name="dataType">string</property>
  108. </structure>
  109. <structure>
  110. <property name="position">3</property>
  111. <property name="name">PAR_SORT</property>
  112. <property name="dataType">decimal</property>
  113. </structure>
  114. <structure>
  115. <property name="position">4</property>
  116. <property name="name">PAR_LVL</property>
  117. <property name="dataType">decimal</property>
  118. </structure>
  119. <structure>
  120. <property name="position">5</property>
  121. <property name="name">PAR_NAME</property>
  122. <property name="dataType">string</property>
  123. </structure>
  124. <structure>
  125. <property name="position">6</property>
  126. <property name="name">INDX_SORT</property>
  127. <property name="dataType">decimal</property>
  128. </structure>
  129. <structure>
  130. <property name="position">7</property>
  131. <property name="name">INDX_NAME</property>
  132. <property name="dataType">string</property>
  133. </structure>
  134. <structure>
  135. <property name="position">8</property>
  136. <property name="name">METHOD</property>
  137. <property name="dataType">string</property>
  138. </structure>
  139. <structure>
  140. <property name="position">9</property>
  141. <property name="name">TOP_PAR</property>
  142. <property name="dataType">decimal</property>
  143. </structure>
  144. <structure>
  145. <property name="position">10</property>
  146. <property name="name">DETAIL_PAR</property>
  147. <property name="dataType">decimal</property>
  148. </structure>
  149. <structure>
  150. <property name="position">11</property>
  151. <property name="name">DETAIL_INDX</property>
  152. <property name="dataType">decimal</property>
  153. </structure>
  154. </list-property>
  155. </structure>
  156. <property name="dataSource">wlapp_u1@general</property>
  157. <list-property name="resultSet">
  158. <structure>
  159. <property name="position">1</property>
  160. <property name="name">COMP_SORT</property>
  161. <property name="nativeName">COMP_SORT</property>
  162. <property name="dataType">decimal</property>
  163. </structure>
  164. <structure>
  165. <property name="position">2</property>
  166. <property name="name">COMP_NAME</property>
  167. <property name="nativeName">COMP_NAME</property>
  168. <property name="dataType">string</property>
  169. </structure>
  170. <structure>
  171. <property name="position">3</property>
  172. <property name="name">PAR_SORT</property>
  173. <property name="nativeName">PAR_SORT</property>
  174. <property name="dataType">decimal</property>
  175. </structure>
  176. <structure>
  177. <property name="position">4</property>
  178. <property name="name">PAR_LVL</property>
  179. <property name="nativeName">PAR_LVL</property>
  180. <property name="dataType">decimal</property>
  181. </structure>
  182. <structure>
  183. <property name="position">5</property>
  184. <property name="name">PAR_NAME</property>
  185. <property name="nativeName">PAR_NAME</property>
  186. <property name="dataType">string</property>
  187. </structure>
  188. <structure>
  189. <property name="position">6</property>
  190. <property name="name">INDX_SORT</property>
  191. <property name="nativeName">INDX_SORT</property>
  192. <property name="dataType">decimal</property>
  193. </structure>
  194. <structure>
  195. <property name="position">7</property>
  196. <property name="name">INDX_NAME</property>
  197. <property name="nativeName">INDX_NAME</property>
  198. <property name="dataType">string</property>
  199. </structure>
  200. <structure>
  201. <property name="position">8</property>
  202. <property name="name">METHOD</property>
  203. <property name="nativeName">METHOD</property>
  204. <property name="dataType">string</property>
  205. </structure>
  206. <structure>
  207. <property name="position">9</property>
  208. <property name="name">TOP_PAR</property>
  209. <property name="nativeName">TOP_PAR</property>
  210. <property name="dataType">decimal</property>
  211. </structure>
  212. <structure>
  213. <property name="position">10</property>
  214. <property name="name">DETAIL_PAR</property>
  215. <property name="nativeName">DETAIL_PAR</property>
  216. <property name="dataType">decimal</property>
  217. </structure>
  218. <structure>
  219. <property name="position">11</property>
  220. <property name="name">DETAIL_INDX</property>
  221. <property name="nativeName">DETAIL_INDX</property>
  222. <property name="dataType">decimal</property>
  223. </structure>
  224. </list-property>
  225. <xml-property name="queryText"><![CDATA[select comp_sort, comp_name
  226. , par_sort, par_lvl, decode(id_component, lag_id, null, par_name_hier) /*par_name*/ as par_name
  227. , indx_sort, indx_name
  228. , method
  229. /* styles */
  230. , case when par_lvl = 1 and id_component != lag_id then 1 else 0 end as TOP_PAR
  231. , case when par_lvl > 1 and id_component != lag_id then 1 else 0 end as DETAIL_PAR
  232. , case when id_component = lag_id then 1 else 0 end as DETAIL_INDX
  233. from (
  234. select inner_query_with_rn.*
  235. , nvl(lag(id_component) over (order by rn), 0) as lag_id
  236. from (
  237. select rownum as rn, inner_query.* from (
  238. select comp.name as comp_name
  239. , comp.sorting_index as comp_sort
  240. -- (select name from component_ba where id_component = pars.id_l2_root) as l1
  241. , pars.name as par_name
  242. , pars.name_hier as par_name_hier
  243. , pars.lvl as par_lvl
  244. , pars.p_sort
  245. , pars.sorting_index as par_sort
  246. , pars.id_component
  247. , indx.name as indx_name
  248. , indx.sorting_index as indx_sort
  249. , m.name as method
  250. from (
  251. select c.name
  252. /*, replace(lpad(' ', (level-1)*2), ' ', '-') || c.name as name_hier*/
  253. , lpad('• • • • • ', (level-1)*2) || c.name as name_hier
  254. , c.id_component, connect_by_root c.id_main_component as id_l2_root
  255. , level as lvl
  256. , rownum as p_sort
  257. , c.sorting_index
  258. from component_ba c
  259. where c.idk_component = 2
  260. and c.use_sign = 1
  261. connect by prior c.id_component = c.id_main_component
  262. start with (select idk_component from component_ba where id_component = c.id_main_component) = 1
  263.  
  264. and id_template = :id_template
  265. order siblings by c.sorting_index
  266. ) pars
  267. , component_ba indx
  268. , component_ba comp
  269. , method_ba m
  270. where comp.idk_component = 1
  271. and comp.use_sign = 1
  272. and comp.id_component = pars.id_l2_root
  273. /*and comp.id_template = :id_template*/
  274.  
  275. and indx.id_main_component (+)= pars.id_component
  276. and indx.idk_component (+) in (3,4)
  277. and indx.use_sign (+) = 1
  278. /*and indx.id_template (+) = :id_template*/
  279.  
  280. and indx.id_method = m.id_method (+)
  281.  
  282. order by (select sorting_index from component_ba where id_component = pars.id_l2_root)
  283. , p_sort-- p_lvl, p_sort
  284. , indx.sorting_index
  285.  
  286. ) inner_query
  287. ) inner_query_with_rn
  288. ) order by rn]]></xml-property>
  289. <property name="rowFetchSize">50</property>
  290. </oda-data-set>
  291. <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Template" id="130">
  292. <property name="nullsOrdering">nulls lowest</property>
  293. <list-property name="columnHints"/>
  294. <list-property name="parameters">
  295. <structure>
  296. <property name="name">id_template_1</property>
  297. <property name="paramName">id_template</property>
  298. <property name="nativeName"></property>
  299. <property name="dataType">integer</property>
  300. <property name="nativeDataType">0</property>
  301. <property name="position">1</property>
  302. <property name="isOptional">false</property>
  303. <property name="isInput">true</property>
  304. <property name="isOutput">false</property>
  305. </structure>
  306. <structure>
  307. <property name="name">id_template_2</property>
  308. <property name="paramName">id_template</property>
  309. <property name="nativeName"></property>
  310. <property name="dataType">integer</property>
  311. <property name="nativeDataType">0</property>
  312. <property name="position">2</property>
  313. <property name="isOptional">false</property>
  314. <property name="isInput">true</property>
  315. <property name="isOutput">false</property>
  316. </structure>
  317. <structure>
  318. <property name="name">currentUser</property>
  319. <property name="paramName">_currentUser</property>
  320. <property name="nativeName"></property>
  321. <property name="dataType">string</property>
  322. <property name="nativeDataType">0</property>
  323. <property name="position">3</property>
  324. <property name="isOptional">false</property>
  325. <property name="isInput">true</property>
  326. <property name="isOutput">false</property>
  327. </structure>
  328. </list-property>
  329. <structure name="cachedMetaData">
  330. <list-property name="resultSet">
  331. <structure>
  332. <property name="position">1</property>
  333. <property name="name">NAME</property>
  334. <property name="dataType">string</property>
  335. </structure>
  336. <structure>
  337. <property name="position">2</property>
  338. <property name="name">NOTE</property>
  339. <property name="dataType">string</property>
  340. </structure>
  341. <structure>
  342. <property name="position">3</property>
  343. <property name="name">NAME_LENGTH</property>
  344. <property name="dataType">decimal</property>
  345. </structure>
  346. <structure>
  347. <property name="position">4</property>
  348. <property name="name">IN_USE</property>
  349. <property name="dataType">decimal</property>
  350. </structure>
  351. </list-property>
  352. </structure>
  353. <property name="rowFetchLimit">1</property>
  354. <property name="dataSource">wlapp_u1@general</property>
  355. <list-property name="resultSet">
  356. <structure>
  357. <property name="position">1</property>
  358. <property name="name">NAME</property>
  359. <property name="nativeName">NAME</property>
  360. <property name="dataType">string</property>
  361. </structure>
  362. <structure>
  363. <property name="position">2</property>
  364. <property name="name">NOTE</property>
  365. <property name="nativeName">NOTE</property>
  366. <property name="dataType">string</property>
  367. </structure>
  368. <structure>
  369. <property name="position">3</property>
  370. <property name="name">NAME_LENGTH</property>
  371. <property name="nativeName">NAME_LENGTH</property>
  372. <property name="dataType">decimal</property>
  373. </structure>
  374. <structure>
  375. <property name="position">4</property>
  376. <property name="name">IN_USE</property>
  377. <property name="nativeName">IN_USE</property>
  378. <property name="dataType">decimal</property>
  379. </structure>
  380. </list-property>
  381. <xml-property name="queryText"><![CDATA[select t.name, t.note, length(t.name) as name_length
  382. , case when nvl(t.use_sign, 0) = 1
  383. and t.D_START <= sysdate
  384. and (t.D_END > sysdate or t.D_END is null) then 1 else 0 end
  385. as in_use
  386. from template_ba t
  387. where t.id_template = :id_template_1
  388. /*and t.use_sign = 1*/
  389.  
  390. --and :currentUser is not null
  391. --and :id_template_2 is not null
  392.  
  393. AND ID_TEMPLATE IN (
  394. select id
  395. from table(cast(user_generic_ba.get_au_template(
  396. A_id_app_user => (select user_generic_ba.get_id_app_user(A_User => :currentUser) from dual)
  397. , A_id_area => to_number((select id_area from template_ba where id_template = :id_template_2))
  398. , A_idk_app_role => '1000,1001,1006') as pt_meta_id_t_ba))
  399. )
  400.  
  401. ]]></xml-property>
  402. <property name="rowFetchSize">1</property>
  403. </oda-data-set>
  404. <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="CurrentUser" id="289">
  405. <list-property name="columnHints"/>
  406. <list-property name="parameters">
  407. <structure>
  408. <property name="name">currentUser</property>
  409. <property name="paramName">_currentUser</property>
  410. <property name="nativeName"></property>
  411. <property name="dataType">string</property>
  412. <property name="nativeDataType">0</property>
  413. <property name="position">1</property>
  414. <property name="isOptional">false</property>
  415. <property name="isInput">true</property>
  416. <property name="isOutput">false</property>
  417. </structure>
  418. </list-property>
  419. <structure name="cachedMetaData">
  420. <list-property name="resultSet">
  421. <structure>
  422. <property name="position">1</property>
  423. <property name="name">ID_APP_USER</property>
  424. <property name="dataType">decimal</property>
  425. </structure>
  426. </list-property>
  427. </structure>
  428. <property name="dataSource">wlapp_u1@general</property>
  429. <list-property name="resultSet">
  430. <structure>
  431. <property name="position">1</property>
  432. <property name="name">ID_APP_USER</property>
  433. <property name="nativeName">ID_APP_USER</property>
  434. <property name="dataType">decimal</property>
  435. </structure>
  436. </list-property>
  437. <xml-property name="queryText"><![CDATA[select user_generic_ba.get_id_app_user(A_User => :currentUser)
  438. as id_app_user
  439. from dual]]></xml-property>
  440. </oda-data-set>
  441. </data-sets>
  442. <styles>
  443. <style name="report" id="4">
  444. <property name="fontFamily">"Arial"</property>
  445. <property name="fontSize">10pt</property>
  446. </style>
  447. <style name="crosstab-cell" id="5">
  448. <property name="borderBottomColor">#CCCCCC</property>
  449. <property name="borderBottomStyle">solid</property>
  450. <property name="borderBottomWidth">1pt</property>
  451. <property name="borderLeftColor">#CCCCCC</property>
  452. <property name="borderLeftStyle">solid</property>
  453. <property name="borderLeftWidth">1pt</property>
  454. <property name="borderRightColor">#CCCCCC</property>
  455. <property name="borderRightStyle">solid</property>
  456. <property name="borderRightWidth">1pt</property>
  457. <property name="borderTopColor">#CCCCCC</property>
  458. <property name="borderTopStyle">solid</property>
  459. <property name="borderTopWidth">1pt</property>
  460. </style>
  461. <style name="crosstab" id="6">
  462. <property name="borderBottomColor">#CCCCCC</property>
  463. <property name="borderBottomStyle">solid</property>
  464. <property name="borderBottomWidth">1pt</property>
  465. <property name="borderLeftColor">#CCCCCC</property>
  466. <property name="borderLeftStyle">solid</property>
  467. <property name="borderLeftWidth">1pt</property>
  468. <property name="borderRightColor">#CCCCCC</property>
  469. <property name="borderRightStyle">solid</property>
  470. <property name="borderRightWidth">1pt</property>
  471. <property name="borderTopColor">#CCCCCC</property>
  472. <property name="borderTopStyle">solid</property>
  473. <property name="borderTopWidth">1pt</property>
  474. </style>
  475. <style name="TopParameter" id="127">
  476. <property name="fontFamily">"Arial"</property>
  477. <property name="color">#000000</property>
  478. <property name="borderTopStyle">solid</property>
  479. <property name="borderTopWidth">thin</property>
  480. </style>
  481. <style name="DetailParameter" id="128">
  482. <property name="fontFamily">"Arial"</property>
  483. <property name="borderTopStyle">dashed</property>
  484. <property name="borderTopWidth">thin</property>
  485. </style>
  486. <style name="DetailIndex" id="129">
  487. <property name="fontFamily">"Arial"</property>
  488. <property name="borderTopColor">#C0C0C0</property>
  489. <property name="borderTopStyle">dashed</property>
  490. <property name="borderTopWidth">thin</property>
  491. </style>
  492. <style name="ParamLevel2" id="267">
  493. <property name="fontFamily">"Arial"</property>
  494. <property name="marginLeft">0pt</property>
  495. <property name="paddingLeft">10pt</property>
  496. </style>
  497. <style name="ParamLevel3" id="268">
  498. <property name="fontFamily">"Arial"</property>
  499. <property name="marginLeft">0pt</property>
  500. <property name="paddingLeft">20pt</property>
  501. </style>
  502. <style name="DisplayInline" id="287">
  503. <property name="fontFamily">"Arial"</property>
  504. <property name="display">inline</property>
  505. </style>
  506. </styles>
  507. <page-setup>
  508. <simple-master-page name="Simple MasterPage" id="2">
  509. <property name="type">a4</property>
  510. <property name="headerHeight">20mm</property>
  511. <page-header>
  512. <grid id="213">
  513. <property name="width">7.635416666666667in</property>
  514. <column id="214">
  515. <property name="width">1.25in</property>
  516. </column>
  517. <column id="215"/>
  518. <column id="216">
  519. <property name="width">1.25in</property>
  520. </column>
  521. <row id="217">
  522. <cell id="218">
  523. <image id="210">
  524. <property name="width">100px</property>
  525. <list-property name="visibility">
  526. <structure>
  527. <property name="format">all</property>
  528. <expression name="valueExpr" type="javascript">true</expression>
  529. </structure>
  530. </list-property>
  531. <property name="source">url</property>
  532. <expression name="uri" type="constant">http://miit.ru/content/logo_miit_cropped.png?id_wm=721916&amp;SWidth=100</expression>
  533. </image>
  534. </cell>
  535. <cell id="219">
  536. <property name="textAlign">center</property>
  537. <text id="208">
  538. <property name="fontSize">14pt</property>
  539. <property name="fontWeight">bold</property>
  540. <property name="color">#000000</property>
  541. <property name="marginBottom">5pt</property>
  542. <property name="contentType">auto</property>
  543. <text-property name="content"><![CDATA[Система бизнес-анализа]]></text-property>
  544. </text>
  545. <data id="173">
  546. <property name="fontSize">12pt</property>
  547. <property name="fontWeight">bold</property>
  548. <list-property name="highlightRules">
  549. <structure>
  550. <property name="operator">gt</property>
  551. <property name="fontSize">10pt</property>
  552. <expression name="testExpr" type="javascript">row["NAME_LENGTH"]</expression>
  553. <simple-property-list name="value1">
  554. <value type="javascript">50</value>
  555. </simple-property-list>
  556. </structure>
  557. </list-property>
  558. <property name="dataSet">Template</property>
  559. <list-property name="boundDataColumns">
  560. <structure>
  561. <property name="name">NAME</property>
  562. <text-property name="displayName">NAME</text-property>
  563. <expression name="expression" type="javascript">dataSetRow["NAME"]</expression>
  564. <property name="dataType">string</property>
  565. </structure>
  566. <structure>
  567. <property name="name">NAME_LENGTH</property>
  568. <text-property name="displayName">NAME_LENGTH</text-property>
  569. <expression name="expression" type="javascript">dataSetRow["NAME_LENGTH"]</expression>
  570. <property name="dataType">decimal</property>
  571. </structure>
  572. </list-property>
  573. <property name="resultSetColumn">NAME</property>
  574. </data>
  575. </cell>
  576. <cell id="220">
  577. <property name="textAlign">right</property>
  578. <auto-text id="262">
  579. <property name="style">DisplayInline</property>
  580. <property name="type">page-number</property>
  581. </auto-text>
  582. <text id="264">
  583. <property name="display">inline</property>
  584. <property name="contentType">plain</property>
  585. <text-property name="content"><![CDATA[ / ]]></text-property>
  586. </text>
  587. <auto-text id="266">
  588. <property name="style">DisplayInline</property>
  589. <property name="textAlign">left</property>
  590. <property name="type">total-page</property>
  591. </auto-text>
  592. </cell>
  593. </row>
  594. </grid>
  595. </page-header>
  596. </simple-master-page>
  597. </page-setup>
  598. <body>
  599. <data id="209">
  600. <property name="marginBottom">10pt</property>
  601. <property name="dataSet">Template</property>
  602. <list-property name="visibility">
  603. <structure>
  604. <property name="format">all</property>
  605. <expression name="valueExpr" type="javascript">row["NOTE"] == null</expression>
  606. </structure>
  607. </list-property>
  608. <list-property name="boundDataColumns">
  609. <structure>
  610. <property name="name">NOTE</property>
  611. <text-property name="displayName">NOTE</text-property>
  612. <expression name="expression" type="javascript">dataSetRow["NOTE"]</expression>
  613. <property name="dataType">string</property>
  614. </structure>
  615. </list-property>
  616. <property name="resultSetColumn">NOTE</property>
  617. </data>
  618. <text-data id="291">
  619. <expression name="valueExpr">params["_currentUser"].value</expression>
  620. <property name="contentType">html</property>
  621. </text-data>
  622. <data id="290">
  623. <property name="dataSet">CurrentUser</property>
  624. <list-property name="boundDataColumns">
  625. <structure>
  626. <property name="name">ID_APP_USER</property>
  627. <text-property name="displayName">ID_APP_USER</text-property>
  628. <expression name="expression" type="javascript">dataSetRow["ID_APP_USER"]</expression>
  629. <property name="dataType">decimal</property>
  630. </structure>
  631. </list-property>
  632. <property name="resultSetColumn">ID_APP_USER</property>
  633. </data>
  634. <table id="95">
  635. <property name="borderBottomStyle">solid</property>
  636. <property name="borderBottomWidth">thin</property>
  637. <property name="borderLeftStyle">solid</property>
  638. <property name="borderLeftWidth">thin</property>
  639. <property name="borderRightStyle">solid</property>
  640. <property name="borderRightWidth">thin</property>
  641. <property name="borderTopStyle">solid</property>
  642. <property name="borderTopWidth">thin</property>
  643. <property name="width">7.739583333333333in</property>
  644. <property name="dataSet">TemplateTree</property>
  645. <list-property name="boundDataColumns">
  646. <structure>
  647. <property name="name">PAR_NAME</property>
  648. <text-property name="displayName">PAR_NAME</text-property>
  649. <expression name="expression" type="javascript">dataSetRow["PAR_NAME"]</expression>
  650. <property name="dataType">string</property>
  651. </structure>
  652. <structure>
  653. <property name="name">INDX_NAME</property>
  654. <text-property name="displayName">INDX_NAME</text-property>
  655. <expression name="expression" type="javascript">dataSetRow["INDX_NAME"]</expression>
  656. <property name="dataType">string</property>
  657. </structure>
  658. <structure>
  659. <property name="name">METHOD</property>
  660. <text-property name="displayName">METHOD</text-property>
  661. <expression name="expression" type="javascript">dataSetRow["METHOD"]</expression>
  662. <property name="dataType">string</property>
  663. </structure>
  664. <structure>
  665. <property name="name">COMP_NAME</property>
  666. <expression name="expression" type="javascript">dataSetRow["COMP_NAME"]</expression>
  667. <property name="dataType">string</property>
  668. <property name="allowExport">true</property>
  669. </structure>
  670. <structure>
  671. <property name="name">PAR_LVL</property>
  672. <expression name="expression" type="javascript">dataSetRow["PAR_LVL"]</expression>
  673. <property name="dataType">string</property>
  674. <property name="allowExport">true</property>
  675. </structure>
  676. <structure>
  677. <property name="name">TOP_PAR</property>
  678. <text-property name="displayName">TOP_PAR</text-property>
  679. <expression name="expression" type="javascript">dataSetRow["TOP_PAR"]</expression>
  680. <property name="dataType">decimal</property>
  681. </structure>
  682. <structure>
  683. <property name="name">DETAIL_PAR</property>
  684. <text-property name="displayName">DETAIL_PAR</text-property>
  685. <expression name="expression" type="javascript">dataSetRow["DETAIL_PAR"]</expression>
  686. <property name="dataType">decimal</property>
  687. </structure>
  688. <structure>
  689. <property name="name">DETAIL_INDX</property>
  690. <text-property name="displayName">DETAIL_INDX</text-property>
  691. <expression name="expression" type="javascript">dataSetRow["DETAIL_INDX"]</expression>
  692. <property name="dataType">decimal</property>
  693. </structure>
  694. <structure>
  695. <property name="name">COMP_SORT</property>
  696. <text-property name="displayName">COMP_SORT</text-property>
  697. <expression name="expression" type="javascript">dataSetRow["COMP_SORT"]</expression>
  698. <property name="dataType">decimal</property>
  699. </structure>
  700. <structure>
  701. <property name="name">PAR_LVL_1</property>
  702. <text-property name="displayName">PAR_LVL</text-property>
  703. <expression name="expression" type="javascript">dataSetRow["PAR_LVL"]</expression>
  704. <property name="dataType">decimal</property>
  705. </structure>
  706. </list-property>
  707. <column id="114">
  708. <property name="width">2.5833333333333335in</property>
  709. </column>
  710. <column id="115">
  711. <property name="width">3.0208333333333335in</property>
  712. </column>
  713. <column id="116">
  714. <property name="width">2.1354166666666665in</property>
  715. </column>
  716. <header>
  717. <row id="96">
  718. <cell id="97">
  719. <property name="borderRightStyle">solid</property>
  720. <property name="borderRightWidth">thin</property>
  721. <label id="98">
  722. <text-property name="text">Параметр</text-property>
  723. </label>
  724. </cell>
  725. <cell id="99">
  726. <property name="borderRightStyle">solid</property>
  727. <property name="borderRightWidth">thin</property>
  728. <label id="100">
  729. <text-property name="text">Показатель</text-property>
  730. </label>
  731. </cell>
  732. <cell id="101">
  733. <label id="102">
  734. <text-property name="text">Метод оценки</text-property>
  735. </label>
  736. </cell>
  737. </row>
  738. </header>
  739. <group id="117">
  740. <property name="groupName">ComponentGroup</property>
  741. <expression name="keyExpr" type="javascript">row["COMP_NAME"]</expression>
  742. <structure name="toc">
  743. <expression name="expressionValue" type="javascript">row["COMP_NAME"]</expression>
  744. </structure>
  745. <property name="hideDetail">false</property>
  746. <list-property name="sort">
  747. <structure>
  748. <expression name="key" type="javascript">row["COMP_SORT"]</expression>
  749. <property name="direction">asc</property>
  750. <property name="strength">-1</property>
  751. </structure>
  752. </list-property>
  753. <header>
  754. <row id="118">
  755. <cell id="119">
  756. <property name="colSpan">3</property>
  757. <property name="rowSpan">1</property>
  758. <property name="borderBottomStyle">solid</property>
  759. <property name="borderBottomWidth">thin</property>
  760. <property name="borderLeftStyle">solid</property>
  761. <property name="borderLeftWidth">thin</property>
  762. <property name="borderRightStyle">solid</property>
  763. <property name="borderRightWidth">thin</property>
  764. <property name="borderTopStyle">solid</property>
  765. <property name="borderTopWidth">thin</property>
  766. <property name="paddingTop">2pt</property>
  767. <property name="paddingBottom">2pt</property>
  768. <property name="textAlign">center</property>
  769. <data id="126">
  770. <property name="fontWeight">bold</property>
  771. <property name="resultSetColumn">COMP_NAME</property>
  772. </data>
  773. </cell>
  774. </row>
  775. </header>
  776. </group>
  777. <detail>
  778. <row id="103">
  779. <list-property name="highlightRules">
  780. <structure>
  781. <property name="operator">eq</property>
  782. <expression name="testExpr" type="javascript">row["TOP_PAR"]</expression>
  783. <simple-property-list name="value1">
  784. <value type="javascript">1</value>
  785. </simple-property-list>
  786. <property name="style">TopParameter</property>
  787. </structure>
  788. <structure>
  789. <property name="operator">eq</property>
  790. <expression name="testExpr" type="javascript">row["DETAIL_PAR"]</expression>
  791. <simple-property-list name="value1">
  792. <value type="javascript">1</value>
  793. </simple-property-list>
  794. <property name="style">DetailParameter</property>
  795. </structure>
  796. </list-property>
  797. <cell id="104">
  798. <data id="105">
  799. <property name="resultSetColumn">PAR_NAME</property>
  800. </data>
  801. </cell>
  802. <cell id="106">
  803. <property name="borderLeftStyle">solid</property>
  804. <property name="borderLeftWidth">thin</property>
  805. <list-property name="highlightRules">
  806. <structure>
  807. <property name="operator">eq</property>
  808. <expression name="testExpr" type="javascript">row["DETAIL_INDX"]</expression>
  809. <simple-property-list name="value1">
  810. <value type="javascript">1</value>
  811. </simple-property-list>
  812. <property name="style">DetailIndex</property>
  813. </structure>
  814. </list-property>
  815. <data id="107">
  816. <property name="resultSetColumn">INDX_NAME</property>
  817. </data>
  818. </cell>
  819. <cell id="108">
  820. <property name="borderLeftStyle">solid</property>
  821. <property name="borderLeftWidth">thin</property>
  822. <list-property name="highlightRules">
  823. <structure>
  824. <property name="operator">eq</property>
  825. <expression name="testExpr" type="javascript">row["DETAIL_INDX"]</expression>
  826. <simple-property-list name="value1">
  827. <value type="javascript">1</value>
  828. </simple-property-list>
  829. <property name="style">DetailIndex</property>
  830. </structure>
  831. </list-property>
  832. <data id="109">
  833. <property name="resultSetColumn">METHOD</property>
  834. </data>
  835. </cell>
  836. </row>
  837. </detail>
  838. </table>
  839. </body>
  840. </report>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!