dailyloan1.r1-print 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494
  1. <DocRoot>
  2. <Parameters />
  3. <DataSources>
  4. <Reference name="bill" alias.zh_CN="借款单" alias.en="" alias.zh_TW="費用報銷單" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1" info="costOff.bos-query">
  5. <Sorts>
  6. <Sort field="number" type="ascend" />
  7. </Sorts>
  8. </Reference>
  9. <Reference name="approveInfo" alias.en="" alias.zh_TW="審批信息" alias="#1" desc.zh_TW="審批信息" desc.en="" desc.zh_CN="审批信息" desc="#1" info="approveInfo.bos-query">
  10. <Params>
  11. <Param name="billId">
  12. <Associate dataSourceID="bill">id</Associate>
  13. </Param>
  14. </Params>
  15. </Reference>
  16. </DataSources>
  17. <Styles version="1.0">
  18. <Style id="3">
  19. <Alignment horizontal="right" />
  20. </Style>
  21. <Style id="5">
  22. <Borders>
  23. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  24. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  25. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  26. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  27. </Borders>
  28. <Alignment horizontal="right" />
  29. </Style>
  30. <Style id="7">
  31. <Borders>
  32. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  33. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  34. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  35. <Border position="bottom" lineStyle="NullLine" />
  36. </Borders>
  37. <Alignment horizontal="left" />
  38. <NumberFormat>[rmb]0.00;[rmb](负数)0.00</NumberFormat>
  39. </Style>
  40. <Style id="2">
  41. <Alignment horizontal="left" />
  42. </Style>
  43. <Style id="0" />
  44. <Style id="4">
  45. <Borders>
  46. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  47. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  48. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  49. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  50. </Borders>
  51. </Style>
  52. <Style id="8">
  53. <Borders>
  54. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  55. <Border position="top" lineStyle="NullLine" />
  56. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  57. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  58. </Borders>
  59. </Style>
  60. <Style id="6">
  61. <Borders>
  62. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  63. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  64. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  65. <Border position="bottom" lineStyle="NullLine" />
  66. </Borders>
  67. </Style>
  68. <Style id="1">
  69. <Font size="14" bold="true" italic="false" />
  70. </Style>
  71. </Styles>
  72. <Report type="r1-print" version="6.2.0">
  73. <Page id="page1" width="1800" height="2670">
  74. <Sub-objects>
  75. <PrintDataGrid id="dataGrid1" styleId="0" x="0" y="0" horizontalFill="true">
  76. <Data dataSource="bill" />
  77. <Col width="300" id="column9" styleId="0" />
  78. <Col width="300" id="column10" styleId="0" />
  79. <Col width="300" id="column11" styleId="0" />
  80. <Col width="300" id="column12" styleId="0" />
  81. <Col width="300" id="column13" styleId="0" />
  82. <Col width="300" id="column14" styleId="0" />
  83. <TR height="703" type="group" group="g0" displayEveryPage="true" id="row14" styleId="0">
  84. <TD id="cell88" styleId="0">
  85. <Sub-objects>
  86. <PrintLayoutGrid id="layoutGrid3" styleId="0" x="0" y="0" horizontalFill="true" verticalFill="true">
  87. <Data />
  88. <Col width="167" id="column27" styleId="0" />
  89. <Col width="132" id="column1" styleId="0" />
  90. <Col width="297" id="column2" styleId="0" />
  91. <Col width="301" id="column3" styleId="0" />
  92. <Col width="302" id="column4" styleId="0" />
  93. <Col width="300" id="column5" styleId="0" />
  94. <Col width="54" id="column6" styleId="0" />
  95. <Col width="245" id="column7" styleId="0" />
  96. <TR height="80" id="row19" styleId="0">
  97. <TD id="cell129" styleId="1">
  98. <Value type="field" dataSource="bill">company.name</Value>
  99. </TD>
  100. <TD id="cell1" styleId="0" />
  101. <TD id="cell2" styleId="0" />
  102. <TD id="cell3" styleId="0" />
  103. <TD id="cell31" styleId="0" />
  104. <TD id="cell41" styleId="0" />
  105. <TD id="cell51" styleId="0" />
  106. <TD id="cell61" styleId="0" />
  107. </TR>
  108. <TR height="76" id="row1" styleId="0">
  109. <TD id="cell71" styleId="1">
  110. <Value type="text"><![CDATA[借款单]]></Value>
  111. </TD>
  112. <TD id="cell4" styleId="0" />
  113. <TD id="cell5" styleId="0" />
  114. <TD id="cell6" styleId="0" />
  115. <TD id="cell32" styleId="0" />
  116. <TD id="cell42" styleId="0" />
  117. <TD id="cell52" styleId="0" />
  118. <TD id="cell62" styleId="0" />
  119. </TR>
  120. <TR height="68" id="row2" styleId="0">
  121. <TD id="cell72" styleId="0">
  122. <Value type="text"><![CDATA[单据编号:]]></Value>
  123. </TD>
  124. <TD id="cell7" styleId="2">
  125. <Value type="field" dataSource="bill">number</Value>
  126. </TD>
  127. <TD id="cell8" styleId="0" />
  128. <TD id="cell9" styleId="0" />
  129. <TD id="cell33" styleId="0" />
  130. <TD id="cell43" styleId="3">
  131. <Value type="text"><![CDATA[日 期:]]></Value>
  132. </TD>
  133. <TD id="cell53" styleId="0">
  134. <Value type="text"><![CDATA[日 期:]]></Value>
  135. </TD>
  136. <TD id="cell63" styleId="2">
  137. <Value type="field" dataSource="bill">bizReqDate</Value>
  138. </TD>
  139. </TR>
  140. <TR height="68" id="row3" styleId="0">
  141. <TD id="cell73" styleId="4">
  142. <Value type="text"><![CDATA[借款人]]></Value>
  143. </TD>
  144. <TD id="cell10" styleId="0" />
  145. <TD id="cell11" styleId="4">
  146. <Value type="field" dataSource="bill">applier.name</Value>
  147. </TD>
  148. <TD id="cell12" styleId="4">
  149. <Value type="text"><![CDATA[借款人部门]]></Value>
  150. </TD>
  151. <TD id="cell34" styleId="4">
  152. <Value type="field" dataSource="bill">orgUnit.name</Value>
  153. </TD>
  154. <TD id="cell44" styleId="4">
  155. <Value type="text"><![CDATA[借款人公司]]></Value>
  156. </TD>
  157. <TD id="cell54" styleId="4">
  158. <Value type="field" dataSource="bill">applierCompanyName</Value>
  159. </TD>
  160. <TD id="cell64" styleId="0" />
  161. </TR>
  162. <TR height="68" id="row4" styleId="0">
  163. <TD id="cell74" styleId="4">
  164. <Value type="text"><![CDATA[申请人职位]]></Value>
  165. </TD>
  166. <TD id="cell13" styleId="0" />
  167. <TD id="cell14" styleId="4">
  168. <Value type="field" dataSource="bill">position.name</Value>
  169. </TD>
  170. <TD id="cell15" styleId="4">
  171. <Value type="text"><![CDATA[紧急程度]]></Value>
  172. </TD>
  173. <TD id="cell35" styleId="4">
  174. <Value type="field" dataSource="bill">prioralias</Value>
  175. </TD>
  176. <TD id="cell45" styleId="4">
  177. <Value type="text"><![CDATA[币种]]></Value>
  178. </TD>
  179. <TD id="cell55" styleId="4">
  180. <Value type="field" dataSource="bill">currencyType.name</Value>
  181. </TD>
  182. <TD id="cell65" styleId="0" />
  183. </TR>
  184. <TR height="69" id="row5" styleId="0">
  185. <TD id="cell75" styleId="4">
  186. <Value type="text"><![CDATA[电话]]></Value>
  187. </TD>
  188. <TD id="cell16" styleId="0" />
  189. <TD id="cell17" styleId="4">
  190. <Value type="field" dataSource="bill">tel</Value>
  191. </TD>
  192. <TD id="cell18" styleId="4">
  193. <Value type="text"><![CDATA[预计还款日期]]></Value>
  194. </TD>
  195. <TD id="cell36" styleId="5">
  196. <Value type="field" dataSource="bill">foreseeDate</Value>
  197. </TD>
  198. <TD id="cell46" styleId="4">
  199. <Value type="text"><![CDATA[业务类别]]></Value>
  200. </TD>
  201. <TD id="cell56" styleId="4">
  202. <Value type="field" dataSource="bill">operationType.name</Value>
  203. </TD>
  204. <TD id="cell66" styleId="0" />
  205. </TR>
  206. <TR height="69" id="row6" styleId="0">
  207. <TD id="cell76" styleId="4">
  208. <Value type="text"><![CDATA[承担公司]]></Value>
  209. </TD>
  210. <TD id="cell19" styleId="0" />
  211. <TD id="cell20" styleId="4">
  212. <Value type="field" dataSource="bill">company.name</Value>
  213. </TD>
  214. <TD id="cell21" styleId="4">
  215. <Value type="text"><![CDATA[联系电话]]></Value>
  216. </TD>
  217. <TD id="cell37" styleId="4">
  218. <Value type="field" dataSource="bill">tel</Value>
  219. </TD>
  220. <TD id="cell47" styleId="4">
  221. <Value type="text"><![CDATA[支付方式]]></Value>
  222. </TD>
  223. <TD id="cell57" styleId="4">
  224. <Value type="field" dataSource="bill">payMode.name</Value>
  225. </TD>
  226. <TD id="cell67" styleId="0" />
  227. </TR>
  228. <TR height="69" id="row7" styleId="0">
  229. <TD id="cell77" styleId="4">
  230. <Value type="text"><![CDATA[承担对象]]></Value>
  231. </TD>
  232. <TD id="cell22" styleId="0" />
  233. <TD id="cell23" styleId="4">
  234. <Value type="field" dataSource="bill">supportedObj.name</Value>
  235. </TD>
  236. <TD id="cell24" styleId="4">
  237. <Value type="text"><![CDATA[承担部门]]></Value>
  238. </TD>
  239. <TD id="cell38" styleId="4">
  240. <Value type="field" dataSource="bill">costedDept.name</Value>
  241. </TD>
  242. <TD id="cell48" styleId="4">
  243. <Value type="text"><![CDATA[申请总额]]></Value>
  244. </TD>
  245. <TD id="cell58" styleId="5">
  246. <Value type="field" dataSource="bill">amount</Value>
  247. </TD>
  248. <TD id="cell68" styleId="0" />
  249. </TR>
  250. <TR height="67" id="row8" styleId="0">
  251. <TD id="cell78" styleId="4">
  252. <Value type="text"><![CDATA[名称]]></Value>
  253. </TD>
  254. <TD id="cell25" styleId="0" />
  255. <TD id="cell26" styleId="4">
  256. <Value type="field" dataSource="bill">name</Value>
  257. </TD>
  258. <TD id="cell27" styleId="4" />
  259. <TD id="cell39" styleId="4" />
  260. <TD id="cell49" styleId="4">
  261. <Value type="text"><![CDATA[核定总金额]]></Value>
  262. </TD>
  263. <TD id="cell59" styleId="5">
  264. <Value type="field" dataSource="bill">amountApproved</Value>
  265. </TD>
  266. <TD id="cell69" styleId="0" />
  267. </TR>
  268. <TR height="67" id="row9" styleId="0">
  269. <TD id="cell79" styleId="6">
  270. <Value type="text"><![CDATA[事由]]></Value>
  271. </TD>
  272. <TD id="cell28" styleId="0" />
  273. <TD id="cell29" styleId="6">
  274. <Value type="field" dataSource="bill">cause</Value>
  275. </TD>
  276. <TD id="cell30" styleId="4" />
  277. <TD id="cell40" styleId="4" />
  278. <TD id="cell50" styleId="6">
  279. <Value type="text"><![CDATA[核定总金额大写]]></Value>
  280. </TD>
  281. <TD id="cell60" styleId="7">
  282. <Value type="field" dataSource="bill">amountCapital</Value>
  283. </TD>
  284. <TD id="cell70" styleId="0" />
  285. </TR>
  286. <MergeBlocks>
  287. <Block left="0" right="7" top="0" bottom="0" />
  288. <Block left="0" right="7" top="1" bottom="1" />
  289. <Block left="1" right="2" top="2" bottom="2" />
  290. <Block left="5" right="6" top="2" bottom="2" />
  291. <Block left="0" right="1" top="3" bottom="3" />
  292. <Block left="6" right="7" top="3" bottom="3" />
  293. <Block left="0" right="1" top="4" bottom="4" />
  294. <Block left="6" right="7" top="4" bottom="4" />
  295. <Block left="0" right="1" top="5" bottom="5" />
  296. <Block left="6" right="7" top="5" bottom="5" />
  297. <Block left="0" right="1" top="6" bottom="6" />
  298. <Block left="6" right="7" top="6" bottom="6" />
  299. <Block left="0" right="1" top="7" bottom="7" />
  300. <Block left="6" right="7" top="7" bottom="7" />
  301. <Block left="0" right="1" top="8" bottom="8" />
  302. <Block left="2" right="4" top="8" bottom="8" />
  303. <Block left="6" right="7" top="8" bottom="8" />
  304. <Block left="0" right="1" top="9" bottom="9" />
  305. <Block left="2" right="4" top="9" bottom="9" />
  306. <Block left="6" right="7" top="9" bottom="9" />
  307. </MergeBlocks>
  308. </PrintLayoutGrid>
  309. </Sub-objects>
  310. </TD>
  311. <TD id="cell90" styleId="0" />
  312. <TD id="cell91" styleId="0" />
  313. <TD id="cell92" styleId="0" />
  314. <TD id="cell94" styleId="0" />
  315. <TD id="cell97" styleId="0" />
  316. </TR>
  317. <TR height="50" type="group" group="g0" displayEveryPage="true" id="row18" styleId="0">
  318. <TD id="cell123" styleId="4">
  319. <Value type="text"><![CDATA[费用类型费用类型]]></Value>
  320. </TD>
  321. <TD id="cell124" styleId="4">
  322. <Value type="text"><![CDATA[借款用途]]></Value>
  323. </TD>
  324. <TD id="cell125" styleId="4">
  325. <Value type="text"><![CDATA[参与人员]]></Value>
  326. </TD>
  327. <TD id="cell126" styleId="4">
  328. <Value type="text"><![CDATA[申请金额]]></Value>
  329. </TD>
  330. <TD id="cell127" styleId="4">
  331. <Value type="text"><![CDATA[核定金额]]></Value>
  332. </TD>
  333. <TD id="cell128" styleId="4">
  334. <Value type="text"><![CDATA[备注]]></Value>
  335. </TD>
  336. </TR>
  337. <TR height="70" type="detail" repeatTimes="8" id="row12" styleId="0">
  338. <TD id="cell84" styleId="4">
  339. <Value type="field">expenseType1.typeName</Value>
  340. </TD>
  341. <TD id="cell85" styleId="4">
  342. <Value type="field">entries.purpose</Value>
  343. </TD>
  344. <TD id="cell86" styleId="4">
  345. <Value type="field">entries.participants</Value>
  346. </TD>
  347. <TD id="cell89" styleId="5">
  348. <Value type="field">entries.amount</Value>
  349. </TD>
  350. <TD id="cell95" styleId="5">
  351. <Value type="field">entries.amountApproved</Value>
  352. </TD>
  353. <TD id="cell98" styleId="4">
  354. <Value type="field">entries.comment</Value>
  355. </TD>
  356. </TR>
  357. <TR height="207" type="group" group="g0" displayEveryPage="true" id="row10" styleId="0">
  358. <TD id="cell80" styleId="0">
  359. <Sub-objects>
  360. <PrintLayoutGrid id="layoutGrid1" styleId="0" x="0" y="0" horizontalFill="true" verticalFill="true">
  361. <Data />
  362. <Col width="299" id="column8" styleId="0" />
  363. <Col width="299" id="column28" styleId="0" />
  364. <Col width="300" id="column29" styleId="0" />
  365. <Col width="300" id="column30" styleId="0" />
  366. <Col width="300" id="column31" styleId="0" />
  367. <Col width="300" id="column32" styleId="0" />
  368. <TR height="109" id="row20" styleId="0">
  369. <TD id="cell135" styleId="8">
  370. <Value type="text"><![CDATA[创建人]]></Value>
  371. </TD>
  372. <TD id="cell136" styleId="8">
  373. <Value type="field" dataSource="bill">creator.name</Value>
  374. </TD>
  375. <TD id="cell137" styleId="8">
  376. <Value type="text"><![CDATA[修改人]]></Value>
  377. </TD>
  378. <TD id="cell138" styleId="8">
  379. <Value type="field" dataSource="bill">lastUpdateUser.name</Value>
  380. </TD>
  381. <TD id="cell139" styleId="8">
  382. <Value type="text"><![CDATA[审核人]]></Value>
  383. </TD>
  384. <TD id="cell140" styleId="8">
  385. <Value type="field" dataSource="bill">auditor.name</Value>
  386. </TD>
  387. </TR>
  388. <TR height="96" id="row21">
  389. <TD id="cell141" styleId="4">
  390. <Value type="text"><![CDATA[创建时间]]></Value>
  391. </TD>
  392. <TD id="cell142" styleId="5">
  393. <Value type="field" dataSource="bill">createTime</Value>
  394. </TD>
  395. <TD id="cell143" styleId="4">
  396. <Value type="text"><![CDATA[修改时间]]></Value>
  397. </TD>
  398. <TD id="cell144" styleId="5">
  399. <Value type="field" dataSource="bill">lastUpdateTime</Value>
  400. </TD>
  401. <TD id="cell145" styleId="4">
  402. <Value type="text"><![CDATA[审核时间]]></Value>
  403. </TD>
  404. <TD id="cell146" styleId="5">
  405. <Value type="field" dataSource="bill">auditDate</Value>
  406. </TD>
  407. </TR>
  408. </PrintLayoutGrid>
  409. </Sub-objects>
  410. </TD>
  411. <TD id="cell130" styleId="0" />
  412. <TD id="cell131" styleId="0" />
  413. <TD id="cell132" styleId="0" />
  414. <TD id="cell133" styleId="0" />
  415. <TD id="cell134" styleId="0" />
  416. </TR>
  417. <MergeBlocks>
  418. <Block left="0" right="5" top="0" bottom="0" />
  419. <Block left="0" right="5" top="3" bottom="3" />
  420. </MergeBlocks>
  421. <Groups>
  422. <Group id="g0" according="field" dividePage="true">number</Group>
  423. </Groups>
  424. </PrintDataGrid>
  425. <PrintDataGrid id="dataGrid2" styleId="0" x="0" y="1564" horizontalFill="true">
  426. <PreScript><![CDATA[secondBirth();]]></PreScript>
  427. <Data dataSource="approveInfo" />
  428. <Col width="300" id="column15" styleId="0" />
  429. <Col width="300" id="column16" styleId="0" />
  430. <Col width="300" id="column17" styleId="0" />
  431. <Col width="300" id="column18" styleId="0" />
  432. <Col width="300" id="column19" styleId="0" />
  433. <Col width="300" id="column20" styleId="0" />
  434. <TR height="75" type="normal" displayEveryPage="true" id="row11" styleId="0">
  435. <TD id="cell81" styleId="4">
  436. <Value type="text"><![CDATA[审批人]]></Value>
  437. </TD>
  438. <TD id="cell82" styleId="4">
  439. <Value type="text"><![CDATA[任务名称]]></Value>
  440. </TD>
  441. <TD id="cell83" styleId="4">
  442. <Value type="text"><![CDATA[审批结果]]></Value>
  443. </TD>
  444. <TD id="cell102" styleId="4">
  445. <Value type="text"><![CDATA[处理策略]]></Value>
  446. </TD>
  447. <TD id="cell105" styleId="4">
  448. <Value type="text"><![CDATA[审批日期]]></Value>
  449. </TD>
  450. <TD id="cell108" styleId="4">
  451. <Value type="text"><![CDATA[审批意见]]></Value>
  452. </TD>
  453. </TR>
  454. <TR height="70" type="detail" repeatTimes="8" id="row13" styleId="0">
  455. <TD id="cell87" styleId="4">
  456. <Value type="field">personName</Value>
  457. </TD>
  458. <TD id="cell93" styleId="4">
  459. <Value type="field">taskName</Value>
  460. </TD>
  461. <TD id="cell96" styleId="4">
  462. <Value type="field">isPass</Value>
  463. </TD>
  464. <TD id="cell103" styleId="4">
  465. <Value type="field">handlerOpinion2</Value>
  466. </TD>
  467. <TD id="cell106" styleId="5">
  468. <Value type="field">createTime</Value>
  469. </TD>
  470. <TD id="cell109" styleId="4">
  471. <Value type="field">opinion</Value>
  472. </TD>
  473. </TR>
  474. </PrintDataGrid>
  475. </Sub-objects>
  476. </Page>
  477. </Report>
  478. <PrintInfo>
  479. <PaperSetup>
  480. <Paper>iso-a4</Paper>
  481. <Orientation>PORTRAIT</Orientation>
  482. <PageMargin left="200" right="100" top="150" bottom="150" />
  483. <Header height="150" margin="100" />
  484. <Footer height="150" margin="100" />
  485. </PaperSetup>
  486. <PrinterSetup>
  487. <DynamicPaper>false</DynamicPaper>
  488. <EconomizePaper>false</EconomizePaper>
  489. </PrinterSetup>
  490. <PreviewSetup>
  491. <BackgroundPicture>false</BackgroundPicture>
  492. </PreviewSetup>
  493. </PrintInfo>
  494. </DocRoot>