LoanInterest.r1-print 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587
  1. <DocRoot>
  2. <Parameters />
  3. <DataSources>
  4. <Reference name="LoanInterestHeaderTDQuery" alias.zh_CN="借款利息单单据头套打Query" alias="#1" desc.zh_CN="借款利息单单据头套打Query" desc="#1" info="::/com/kingdee/eas/fm/fin/app/LoanInterestHeaderTDQuery.bos-query" />
  5. <Reference name="LoanInterestEntryTDQuery" alias.zh_CN="借款利息单分录套打Query" alias="#1" desc.zh_CN="借款利息单分录套打Query" desc="#1" info="::/com/kingdee/eas/fm/fin/app/LoanInterestEntryTDQuery.bos-query">
  6. <Params>
  7. <Param name="parentID">
  8. <Associate dataSourceID="LoanInterestHeaderTDQuery">id</Associate>
  9. </Param>
  10. </Params>
  11. </Reference>
  12. </DataSources>
  13. <Styles version="1.0">
  14. <Style id="3">
  15. <Borders>
  16. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  17. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  18. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  19. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  20. </Borders>
  21. <Alignment wrapText="true" />
  22. </Style>
  23. <Style id="2">
  24. <Borders>
  25. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  26. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  27. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  28. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  29. </Borders>
  30. </Style>
  31. <Style id="10">
  32. <Borders>
  33. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  34. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  35. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  36. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  37. </Borders>
  38. <Alignment horizontal="left" />
  39. </Style>
  40. <Style id="1">
  41. <Font size="12" bold="true" italic="false" />
  42. </Style>
  43. <Style id="0" />
  44. <Style id="7">
  45. <Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  46. <Borders>
  47. <Border position="left" lineStyle="NullLine" />
  48. <Border position="top" lineStyle="NullLine" />
  49. <Border position="right" lineStyle="NullLine" />
  50. <Border position="bottom" lineStyle="NullLine" />
  51. <Border position="diagonalleft" lineStyle="NullLine" />
  52. <Border position="diagonalright" lineStyle="NullLine" />
  53. </Borders>
  54. <Interior color="#ffffff00" pattern="None" patternColor="#000000" />
  55. <Alignment horizontal="right" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
  56. <Protection hidden="false" locked="false" />
  57. <NumberFormat>0.00;-0.00</NumberFormat>
  58. </Style>
  59. <Style id="6">
  60. <Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  61. <Borders>
  62. <Border position="left" lineStyle="NullLine" />
  63. <Border position="top" lineStyle="NullLine" />
  64. <Border position="right" lineStyle="NullLine" />
  65. <Border position="bottom" lineStyle="NullLine" />
  66. <Border position="diagonalleft" lineStyle="NullLine" />
  67. <Border position="diagonalright" lineStyle="NullLine" />
  68. </Borders>
  69. <Interior color="#ffffff00" pattern="None" patternColor="#000000" />
  70. <Alignment horizontal="left" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
  71. <Protection hidden="false" locked="false" />
  72. </Style>
  73. <Style id="5">
  74. <Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  75. <Borders>
  76. <Border position="left" lineStyle="NullLine" />
  77. <Border position="top" lineStyle="NullLine" />
  78. <Border position="right" lineStyle="NullLine" />
  79. <Border position="bottom" lineStyle="NullLine" />
  80. <Border position="diagonalleft" lineStyle="NullLine" />
  81. <Border position="diagonalright" lineStyle="NullLine" />
  82. </Borders>
  83. <Interior color="#ffffff00" pattern="None" patternColor="#000000" />
  84. <Alignment horizontal="right" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
  85. <Protection hidden="false" locked="false" />
  86. <NumberFormat>0.00;-0.00</NumberFormat>
  87. </Style>
  88. <Style id="4">
  89. <Borders>
  90. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  91. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  92. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  93. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  94. </Borders>
  95. <Alignment wrapText="true" />
  96. <NumberFormat>yyyy年m月d日;@</NumberFormat>
  97. </Style>
  98. <Style id="9">
  99. <Borders>
  100. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  101. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  102. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  103. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  104. </Borders>
  105. <Alignment wrapText="true" />
  106. <NumberFormat>G/通用格式</NumberFormat>
  107. </Style>
  108. <Style id="8">
  109. <Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  110. <Borders>
  111. <Border position="left" lineStyle="NullLine" />
  112. <Border position="top" lineStyle="NullLine" />
  113. <Border position="right" lineStyle="NullLine" />
  114. <Border position="bottom" lineStyle="NullLine" />
  115. <Border position="diagonalleft" lineStyle="NullLine" />
  116. <Border position="diagonalright" lineStyle="NullLine" />
  117. </Borders>
  118. <Interior color="#ffffff00" pattern="None" patternColor="#000000" />
  119. <Alignment horizontal="left" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
  120. <Protection hidden="false" locked="false" />
  121. </Style>
  122. <Style id="11">
  123. <Alignment wrapText="true" />
  124. </Style>
  125. </Styles>
  126. <Report type="r1-print" version="7.0.1">
  127. <Page id="page1" width="1720" height="2470">
  128. <Sub-objects>
  129. <PrintLayoutGrid id="layoutGrid1" styleId="0" x="0" y="0" horizontalFill="true">
  130. <Data />
  131. <Col width="287" id="column1" styleId="0" />
  132. <Col width="287" id="column2" styleId="0" />
  133. <Col width="287" id="column3" styleId="0" />
  134. <Col width="287" id="column4" styleId="0" />
  135. <Col width="286" id="column5" styleId="0" />
  136. <Col width="286" id="column6" styleId="0" />
  137. <TR height="140" id="row1" styleId="0">
  138. <TD id="cell1" styleId="1">
  139. <Value type="text"><![CDATA[借款利息单]]></Value>
  140. </TD>
  141. <TD id="cell2" styleId="0" />
  142. <TD id="cell3" styleId="0" />
  143. <TD id="cell46" styleId="0" />
  144. <TD id="cell61" styleId="0" />
  145. <TD id="cell76" styleId="0" />
  146. </TR>
  147. <TR height="70" id="row2" styleId="0">
  148. <TD id="cell4" styleId="2">
  149. <Value type="text"><![CDATA[编号]]></Value>
  150. </TD>
  151. <TD id="cell5" styleId="3">
  152. <Value type="field" dataSource="LoanInterestHeaderTDQuery">number</Value>
  153. </TD>
  154. <TD id="cell6" styleId="2">
  155. <Value type="text"><![CDATA[日期]]></Value>
  156. </TD>
  157. <TD id="cell47" styleId="4">
  158. <Value type="field" dataSource="LoanInterestHeaderTDQuery">bizDate</Value>
  159. </TD>
  160. <TD id="cell62" styleId="2">
  161. <Value type="text"><![CDATA[类别]]></Value>
  162. </TD>
  163. <TD id="cell77" styleId="3">
  164. <Value type="field" dataSource="LoanInterestHeaderTDQuery">interestType</Value>
  165. </TD>
  166. </TR>
  167. <TR height="70" id="row3" styleId="0">
  168. <TD id="cell7" styleId="2">
  169. <Value type="text"><![CDATA[源贷款编号]]></Value>
  170. </TD>
  171. <TD id="cell8" styleId="3">
  172. <Value type="field" dataSource="LoanInterestHeaderTDQuery">loan.number</Value>
  173. </TD>
  174. <TD id="cell9" styleId="2">
  175. <Value type="text"><![CDATA[债权人]]></Value>
  176. </TD>
  177. <TD id="cell48" styleId="3">
  178. <Value type="field" dataSource="LoanInterestHeaderTDQuery">creditorAsBank.name</Value>
  179. </TD>
  180. <TD id="cell63" styleId="2">
  181. <Value type="text"><![CDATA[付息账户]]></Value>
  182. </TD>
  183. <TD id="cell78" styleId="3">
  184. <Value type="field" dataSource="LoanInterestHeaderTDQuery">account.name</Value>
  185. </TD>
  186. </TR>
  187. <TR height="70" id="row4" styleId="0">
  188. <TD id="cell10" styleId="2">
  189. <Value type="text"><![CDATA[计息开始日]]></Value>
  190. </TD>
  191. <TD id="cell11" styleId="3">
  192. <Value type="field" dataSource="LoanInterestHeaderTDQuery">beginDate</Value>
  193. </TD>
  194. <TD id="cell12" styleId="2">
  195. <Value type="text"><![CDATA[计息结束日]]></Value>
  196. </TD>
  197. <TD id="cell49" styleId="3">
  198. <Value type="field" dataSource="LoanInterestHeaderTDQuery">endDate</Value>
  199. </TD>
  200. <TD id="cell64" styleId="2">
  201. <Value type="text"><![CDATA[计息天数]]></Value>
  202. </TD>
  203. <TD id="cell79" styleId="3">
  204. <Value type="field" dataSource="LoanInterestHeaderTDQuery">days</Value>
  205. </TD>
  206. </TR>
  207. <TR height="70" id="row5" styleId="0">
  208. <TD id="cell13" styleId="2">
  209. <Value type="text"><![CDATA[逾期天数]]></Value>
  210. </TD>
  211. <TD id="cell14" styleId="3">
  212. <Value type="field" dataSource="LoanInterestHeaderTDQuery">daysOverdue</Value>
  213. </TD>
  214. <TD id="cell15" styleId="2">
  215. <Value type="text"><![CDATA[利率表示]]></Value>
  216. </TD>
  217. <TD id="cell50" styleId="3">
  218. <Value type="field" dataSource="LoanInterestHeaderTDQuery">intRateTypeExpression</Value>
  219. </TD>
  220. <TD id="cell65" styleId="2">
  221. <Value type="text"><![CDATA[利率]]></Value>
  222. </TD>
  223. <TD id="cell80" styleId="3">
  224. <Sub-objects>
  225. <PrintLayoutGrid id="layoutGrid2" styleId="0" x="0" y="0" horizontalFill="true" verticalFill="true">
  226. <Data />
  227. <Col width="220" id="column19" />
  228. <Col width="64" id="column20" />
  229. <TR height="68" id="row17">
  230. <TD id="cell109" styleId="5">
  231. <Value type="field" dataSource="LoanInterestHeaderTDQuery">intRate</Value>
  232. </TD>
  233. <TD id="cell110" styleId="6">
  234. <Script><![CDATA[var intRateTypeExpression = getFieldValue("LoanInterestHeaderTDQuery","intRateTypeExpression");
  235. if(intRateTypeExpression == "year" || intRateTypeExpression == "年" ){
  236. setValue("%");
  237. }
  238. else if(intRateTypeExpression == "month" || intRateTypeExpression == "day" || intRateTypeExpression == "月" || intRateTypeExpression == "日" ){
  239. setValue("‰");
  240. }]]></Script>
  241. </TD>
  242. </TR>
  243. </PrintLayoutGrid>
  244. </Sub-objects>
  245. </TD>
  246. </TR>
  247. <TR height="70" id="row6" styleId="0">
  248. <TD id="cell16" styleId="2">
  249. <Value type="text"><![CDATA[币别]]></Value>
  250. </TD>
  251. <TD id="cell17" styleId="3">
  252. <Value type="field" dataSource="LoanInterestHeaderTDQuery">currency.name</Value>
  253. </TD>
  254. <TD id="cell18" styleId="2">
  255. <Value type="text"><![CDATA[汇率]]></Value>
  256. </TD>
  257. <TD id="cell51" styleId="3">
  258. <Value type="field" dataSource="LoanInterestHeaderTDQuery">exchange</Value>
  259. </TD>
  260. <TD id="cell66" styleId="2">
  261. <Value type="text"><![CDATA[计息本金]]></Value>
  262. </TD>
  263. <TD id="cell81" styleId="3">
  264. <Value type="field" dataSource="LoanInterestHeaderTDQuery">amount</Value>
  265. </TD>
  266. </TR>
  267. <TR height="70" id="row7" styleId="0">
  268. <TD id="cell19" styleId="2">
  269. <Value type="text"><![CDATA[应计利息]]></Value>
  270. </TD>
  271. <TD id="cell20" styleId="3">
  272. <Value type="field" dataSource="LoanInterestHeaderTDQuery">interest</Value>
  273. </TD>
  274. <TD id="cell21" styleId="2">
  275. <Value type="text"><![CDATA[实计利息]]></Value>
  276. </TD>
  277. <TD id="cell52" styleId="3">
  278. <Value type="field" dataSource="LoanInterestHeaderTDQuery">realInterest</Value>
  279. </TD>
  280. <TD id="cell67" styleId="2">
  281. <Value type="text"><![CDATA[罚息方式]]></Value>
  282. </TD>
  283. <TD id="cell82" styleId="3">
  284. <Value type="field" dataSource="LoanInterestHeaderTDQuery">punishIntType</Value>
  285. </TD>
  286. </TR>
  287. <TR height="70" id="row8" styleId="0">
  288. <TD id="cell22" styleId="2">
  289. <Value type="text"><![CDATA[罚息率]]></Value>
  290. </TD>
  291. <TD id="cell23" styleId="3">
  292. <Script><![CDATA[var punishIntType = getFieldValue("LoanInterestHeaderTDQuery","punishIntType");
  293. if(punishIntType == "addPercent"){
  294. setValue("%");
  295. }
  296. else if(punishIntType == "addaccrual"){
  297. setValue("‰");
  298. }]]></Script>
  299. <Sub-objects>
  300. <PrintLayoutGrid id="layoutGrid4" styleId="0" x="0" y="0" horizontalFill="true" verticalFill="true">
  301. <Data />
  302. <Col width="212" id="column23" />
  303. <Col width="73" id="column24" />
  304. <TR height="68" id="row19">
  305. <TD id="cell113" styleId="7">
  306. <Value type="field" dataSource="LoanInterestHeaderTDQuery">punishIntRate</Value>
  307. </TD>
  308. <TD id="cell114" styleId="8">
  309. <Script><![CDATA[var punishIntType = getFieldValue("LoanInterestHeaderTDQuery","punishIntType");
  310. if(punishIntType == "addPercent" || punishIntType == "加点"){
  311. setValue("%");
  312. }
  313. else if(punishIntType == "addaccrual" || punishIntType == "加息"){
  314. setValue("‰");
  315. }]]></Script>
  316. </TD>
  317. </TR>
  318. </PrintLayoutGrid>
  319. </Sub-objects>
  320. </TD>
  321. <TD id="cell24" styleId="2">
  322. <Value type="text"><![CDATA[应计罚息]]></Value>
  323. </TD>
  324. <TD id="cell53" styleId="3">
  325. <Value type="field" dataSource="LoanInterestHeaderTDQuery">punishInterest</Value>
  326. </TD>
  327. <TD id="cell68" styleId="2">
  328. <Value type="text"><![CDATA[实计罚息]]></Value>
  329. </TD>
  330. <TD id="cell83" styleId="3">
  331. <Value type="field" dataSource="LoanInterestHeaderTDQuery">realPunishInterest</Value>
  332. </TD>
  333. </TR>
  334. <TR height="70" id="row9" styleId="0">
  335. <TD id="cell25" styleId="2">
  336. <Value type="text"><![CDATA[冲账金额]]></Value>
  337. </TD>
  338. <TD id="cell26" styleId="9">
  339. <Value type="field" dataSource="LoanInterestHeaderTDQuery">strikeAmount</Value>
  340. </TD>
  341. <TD id="cell27" styleId="2">
  342. <Value type="text"><![CDATA[预算项目]]></Value>
  343. </TD>
  344. <TD id="cell54" styleId="3">
  345. <Value type="field" dataSource="LoanInterestHeaderTDQuery">outBgItemName</Value>
  346. </TD>
  347. <TD id="cell69" styleId="2">
  348. <Value type="text"><![CDATA[利息费用科目]]></Value>
  349. </TD>
  350. <TD id="cell84" styleId="3">
  351. <Value type="field" dataSource="LoanInterestHeaderTDQuery">intFeeAcctView.name</Value>
  352. </TD>
  353. </TR>
  354. <TR height="70" id="row10" styleId="0">
  355. <TD id="cell28" styleId="2">
  356. <Value type="text"><![CDATA[出纳]]></Value>
  357. </TD>
  358. <TD id="cell29" styleId="3">
  359. <Value type="field" dataSource="LoanInterestHeaderTDQuery">cashier.name</Value>
  360. </TD>
  361. <TD id="cell30" styleId="2">
  362. <Value type="text"><![CDATA[摘要]]></Value>
  363. </TD>
  364. <TD id="cell55" styleId="3">
  365. <Value type="field" dataSource="LoanInterestHeaderTDQuery">description</Value>
  366. </TD>
  367. <TD id="cell70" styleId="2" />
  368. <TD id="cell85" styleId="2" />
  369. </TR>
  370. <TR height="70" id="row11" styleId="0">
  371. <TD id="cell31" styleId="2">
  372. <Value type="text"><![CDATA[项目]]></Value>
  373. </TD>
  374. <TD id="cell32" styleId="3">
  375. <Value type="field" dataSource="LoanInterestHeaderTDQuery">project.name</Value>
  376. </TD>
  377. <TD id="cell33" styleId="2" />
  378. <TD id="cell56" styleId="2" />
  379. <TD id="cell71" styleId="2" />
  380. <TD id="cell86" styleId="2" />
  381. </TR>
  382. <TR height="70" id="row12" styleId="0">
  383. <TD id="cell34" styleId="10">
  384. <Value type="text"><![CDATA[ 分段计息明细]]></Value>
  385. </TD>
  386. <TD id="cell35" styleId="2" />
  387. <TD id="cell36" styleId="2" />
  388. <TD id="cell57" styleId="2" />
  389. <TD id="cell72" styleId="2" />
  390. <TD id="cell87" styleId="2" />
  391. </TR>
  392. <TR height="140" id="row13" styleId="0" autoAdjustHeight="true">
  393. <TD id="cell37" styleId="0">
  394. <Sub-objects>
  395. <PrintDataGrid id="dataGrid1" styleId="0" x="0" y="0" horizontalFill="true">
  396. <Data dataSource="LoanInterestEntryTDQuery" />
  397. <Col width="144" id="column7" styleId="0" />
  398. <Col width="144" id="column8" styleId="0" />
  399. <Col width="143" id="column9" styleId="0" />
  400. <Col width="143" id="column10" styleId="0" />
  401. <Col width="143" id="column11" styleId="0" />
  402. <Col width="192" id="column12" styleId="0" />
  403. <Col width="94" id="column13" styleId="0" />
  404. <Col width="143" id="column14" styleId="0" />
  405. <Col width="143" id="column15" styleId="0" />
  406. <Col width="143" id="column16" styleId="0" />
  407. <Col width="177" id="column17" styleId="0" />
  408. <Col width="109" id="column18" styleId="0" />
  409. <TR height="70" type="normal" id="row15" styleId="11">
  410. <TD id="cell43" styleId="3">
  411. <Value type="text"><![CDATA[单据分录序列号]]></Value>
  412. </TD>
  413. <TD id="cell44" styleId="3">
  414. <Value type="text"><![CDATA[计息开始日]]></Value>
  415. </TD>
  416. <TD id="cell45" styleId="3">
  417. <Value type="text"><![CDATA[计息结束日]]></Value>
  418. </TD>
  419. <TD id="cell91" styleId="3">
  420. <Value type="text"><![CDATA[计息天数]]></Value>
  421. </TD>
  422. <TD id="cell93" styleId="3">
  423. <Value type="text"><![CDATA[计息本金]]></Value>
  424. </TD>
  425. <TD id="cell95" styleId="3">
  426. <Value type="text"><![CDATA[利率]]></Value>
  427. </TD>
  428. <TD id="cell97" styleId="3">
  429. <Value type="text"><![CDATA[利率表示]]></Value>
  430. </TD>
  431. <TD id="cell99" styleId="3">
  432. <Value type="text"><![CDATA[折算天数]]></Value>
  433. </TD>
  434. <TD id="cell101" styleId="3">
  435. <Value type="text"><![CDATA[应计利息]]></Value>
  436. </TD>
  437. <TD id="cell103" styleId="3">
  438. <Value type="text"><![CDATA[逾期天数]]></Value>
  439. </TD>
  440. <TD id="cell105" styleId="3">
  441. <Value type="text"><![CDATA[罚息率/日加息率]]></Value>
  442. </TD>
  443. <TD id="cell107" styleId="3">
  444. <Value type="text"><![CDATA[应计罚息]]></Value>
  445. </TD>
  446. </TR>
  447. <TR height="70" type="detail" autoAdjustHeight="true" id="row16" styleId="11">
  448. <TD id="cell60" styleId="3">
  449. <Value type="field">seq</Value>
  450. </TD>
  451. <TD id="cell75" styleId="3">
  452. <Value type="field">beginDate</Value>
  453. </TD>
  454. <TD id="cell90" styleId="3">
  455. <Value type="field">endDate</Value>
  456. </TD>
  457. <TD id="cell92" styleId="3">
  458. <Value type="field">days</Value>
  459. </TD>
  460. <TD id="cell94" styleId="3">
  461. <Value type="field">amount</Value>
  462. </TD>
  463. <TD id="cell96" styleId="3">
  464. <Sub-objects>
  465. <PrintLayoutGrid id="layoutGrid3" styleId="0" x="0" y="0" horizontalFill="true" verticalFill="true">
  466. <Data />
  467. <Col width="143" id="column21" />
  468. <Col width="47" id="column22" />
  469. <TR height="68" id="row18">
  470. <TD id="cell111" styleId="7">
  471. <Value type="field" dataSource="LoanInterestEntryTDQuery">intRate</Value>
  472. </TD>
  473. <TD id="cell112" styleId="8">
  474. <Script><![CDATA[var intRateTypeExpression = getFieldValue("LoanInterestEntryTDQuery","intRateTypeExpression");
  475. if(intRateTypeExpression == "year" || intRateTypeExpression == "年"){
  476. setValue("%");
  477. }
  478. else if(intRateTypeExpression == "month" || intRateTypeExpression == "day"|| intRateTypeExpression == "月" || intRateTypeExpression == "日"){
  479. setValue("‰");
  480. }
  481. ]]></Script>
  482. </TD>
  483. </TR>
  484. </PrintLayoutGrid>
  485. </Sub-objects>
  486. </TD>
  487. <TD id="cell98" styleId="3">
  488. <Script><![CDATA[switch(getValue()){
  489. case "year":setValue("年");break;
  490. case "month":setValue("月");break;
  491. case "day":setValue("日");break;
  492. }]]></Script>
  493. <Value type="field">intRateTypeExpression</Value>
  494. </TD>
  495. <TD id="cell100" styleId="3">
  496. <Value type="field">yearDays</Value>
  497. </TD>
  498. <TD id="cell102" styleId="3">
  499. <Value type="field">interest</Value>
  500. </TD>
  501. <TD id="cell104" styleId="3">
  502. <Value type="field">daysOverdue</Value>
  503. </TD>
  504. <TD id="cell106" styleId="3">
  505. <Sub-objects>
  506. <PrintLayoutGrid id="layoutGrid5" styleId="0" x="0" y="0" horizontalFill="true" verticalFill="true">
  507. <Data />
  508. <Col width="120" id="column25" />
  509. <Col width="55" id="column26" />
  510. <TR height="68" id="row20">
  511. <TD id="cell115" styleId="7">
  512. <Value type="field" dataSource="LoanInterestEntryTDQuery">punishIntRate</Value>
  513. </TD>
  514. <TD id="cell116" styleId="8">
  515. <Script><![CDATA[var punishIntType = getFieldValue("LoanInterestHeaderTDQuery","punishIntType");
  516. if(punishIntType == "addPercent" || punishIntType == "加点" ){
  517. setValue("%");
  518. }
  519. else if(punishIntType == "addaccrual" || punishIntType == "加息"){
  520. setValue("‰");
  521. }]]></Script>
  522. </TD>
  523. </TR>
  524. </PrintLayoutGrid>
  525. </Sub-objects>
  526. </TD>
  527. <TD id="cell108" styleId="3">
  528. <Value type="field">punishInterest</Value>
  529. </TD>
  530. </TR>
  531. </PrintDataGrid>
  532. </Sub-objects>
  533. </TD>
  534. <TD id="cell38" styleId="0" />
  535. <TD id="cell39" styleId="0" />
  536. <TD id="cell58" styleId="0" />
  537. <TD id="cell73" styleId="0" />
  538. <TD id="cell88" styleId="0" />
  539. </TR>
  540. <TR height="70" id="row14" styleId="0">
  541. <TD id="cell40" styleId="2">
  542. <Value type="text"><![CDATA[制单]]></Value>
  543. </TD>
  544. <TD id="cell41" styleId="3">
  545. <Value type="field" dataSource="LoanInterestHeaderTDQuery">creator.name</Value>
  546. </TD>
  547. <TD id="cell42" styleId="2">
  548. <Value type="text"><![CDATA[会计]]></Value>
  549. </TD>
  550. <TD id="cell59" styleId="3">
  551. <Value type="field" dataSource="LoanInterestHeaderTDQuery">accountant.name</Value>
  552. </TD>
  553. <TD id="cell74" styleId="2">
  554. <Value type="text"><![CDATA[制单组织]]></Value>
  555. </TD>
  556. <TD id="cell89" styleId="3">
  557. <Value type="field" dataSource="LoanInterestHeaderTDQuery">company.name</Value>
  558. </TD>
  559. </TR>
  560. <MergeBlocks>
  561. <Block left="0" right="5" top="0" bottom="0" />
  562. <Block left="3" right="5" top="9" bottom="9" />
  563. <Block left="1" right="5" top="10" bottom="10" />
  564. <Block left="0" right="5" top="11" bottom="11" />
  565. <Block left="0" right="5" top="12" bottom="12" />
  566. </MergeBlocks>
  567. </PrintLayoutGrid>
  568. </Sub-objects>
  569. </Page>
  570. </Report>
  571. <PrintInfo>
  572. <PaperSetup>
  573. <Paper>iso-a4</Paper>
  574. <Orientation>PORTRAIT</Orientation>
  575. <PageMargin left="190" right="190" top="250" bottom="250" />
  576. <Header height="150" margin="100" />
  577. <Footer height="150" margin="100" />
  578. </PaperSetup>
  579. <PrinterSetup>
  580. <DynamicPaper>false</DynamicPaper>
  581. <EconomizePaper isVerEconomizePaper="false" verSpace="0" isHorEconomizePaper="false" horSpace="0" />
  582. </PrinterSetup>
  583. <PreviewSetup>
  584. <BackgroundPicture>false</BackgroundPicture>
  585. </PreviewSetup>
  586. </PrintInfo>
  587. </DocRoot>