PayableBillBatchNoTD.r1-print 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357
  1. <DocRoot>
  2. <Parameters />
  3. <DataSources>
  4. <Reference name="PayableBillBatchNoTDQuery" alias.zh_CN="应付票据按批套打查询" alias="#1" info="::/com/kingdee/eas/fm/nt/app/PayableBillBatchNoTDQuery.bos-query">
  5. <Sorts>
  6. <Sort field="OutBankAccount.name" type="ascend" />
  7. </Sorts>
  8. </Reference>
  9. <Reference name="R1Print_SystemDefine_Approve" alias.zh_TW="" alias.zh_CN="单据审批信息" alias.en="" alias="#1" info="special://approve">
  10. <Params>
  11. <Param name="billId">
  12. <Associate dataSourceID="PayableBillBatchNoTDQuery">billId</Associate>
  13. </Param>
  14. </Params>
  15. <Sorts>
  16. <Sort field="id" type="ascend" />
  17. </Sorts>
  18. </Reference>
  19. </DataSources>
  20. <Styles version="1.0">
  21. <Style id="11">
  22. <Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  23. <Borders>
  24. <Border position="left" lineStyle="NullLine" />
  25. <Border position="top" lineStyle="NullLine" />
  26. <Border position="right" lineStyle="NullLine" />
  27. <Border position="bottom" lineStyle="NullLine" />
  28. <Border position="diagonalleft" lineStyle="NullLine" />
  29. <Border position="diagonalright" lineStyle="NullLine" />
  30. </Borders>
  31. <Interior color="#ffffff00" pattern="None" patternColor="#000000" />
  32. <Alignment horizontal="left" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
  33. <Protection hidden="false" locked="false" />
  34. </Style>
  35. <Style id="12">
  36. <Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  37. <Borders>
  38. <Border position="left" lineStyle="NullLine" />
  39. <Border position="top" lineStyle="NullLine" />
  40. <Border position="right" lineStyle="NullLine" />
  41. <Border position="bottom" lineStyle="NullLine" />
  42. <Border position="diagonalleft" lineStyle="NullLine" />
  43. <Border position="diagonalright" lineStyle="NullLine" />
  44. </Borders>
  45. <Interior color="#ffffff00" pattern="None" patternColor="#000000" />
  46. <Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
  47. <Protection hidden="false" locked="false" />
  48. </Style>
  49. <Style id="3">
  50. <Borders>
  51. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  52. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  53. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  54. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  55. </Borders>
  56. <Alignment wrapText="true" />
  57. </Style>
  58. <Style id="2">
  59. <Borders>
  60. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  61. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  62. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  63. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  64. </Borders>
  65. </Style>
  66. <Style id="1" />
  67. <Style id="10">
  68. <Alignment wrapText="true" />
  69. </Style>
  70. <Style id="0">
  71. <Font fontName="宋体" size="14" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  72. <Borders>
  73. <Border position="left" lineStyle="NullLine" />
  74. <Border position="top" lineStyle="NullLine" />
  75. <Border position="right" lineStyle="NullLine" />
  76. <Border position="bottom" lineStyle="NullLine" />
  77. <Border position="diagonalleft" lineStyle="NullLine" />
  78. <Border position="diagonalright" lineStyle="NullLine" />
  79. </Borders>
  80. <Interior color="#ffffff00" pattern="None" patternColor="#000000" />
  81. <Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
  82. <Protection hidden="false" locked="false" />
  83. </Style>
  84. <Style id="7">
  85. <Borders>
  86. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  87. <Border position="top" lineStyle="NullLine" />
  88. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  89. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  90. </Borders>
  91. <Alignment wrapText="true" />
  92. <NumberFormat>G/通用格式</NumberFormat>
  93. </Style>
  94. <Style id="6">
  95. <Borders>
  96. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  97. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  98. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  99. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  100. </Borders>
  101. <NumberFormat>¥#,##0.00;¥-#,##0.00</NumberFormat>
  102. </Style>
  103. <Style id="5">
  104. <Borders>
  105. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  106. <Border position="top" lineStyle="NullLine" />
  107. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  108. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  109. </Borders>
  110. <NumberFormat>G/通用格式</NumberFormat>
  111. </Style>
  112. <Style id="4">
  113. <NumberFormat>¥#,##0.00;¥-#,##0.00</NumberFormat>
  114. </Style>
  115. <Style id="9">
  116. <Borders>
  117. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  118. <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  119. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  120. <Border position="bottom" lineStyle="NullLine" />
  121. </Borders>
  122. </Style>
  123. <Style id="8">
  124. <Borders>
  125. <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  126. <Border position="top" lineStyle="NullLine" />
  127. <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  128. <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  129. </Borders>
  130. <Alignment wrapText="true" />
  131. <NumberFormat>¥#,##0.00;¥-#,##0.00</NumberFormat>
  132. </Style>
  133. </Styles>
  134. <Report type="r1-print" version="6.3.0">
  135. <Page id="page1" width="1720" height="2470">
  136. <Sub-objects>
  137. <Text id="text1" styleId="0" x="296" y="104" width="1128" height="159">
  138. <Data><![CDATA[应付票据批量新增套打结果]]></Data>
  139. </Text>
  140. <PrintDataGrid id="dataGrid1" styleId="1" x="21" y="294">
  141. <Data dataSource="PayableBillBatchNoTDQuery" />
  142. <Col width="169" id="column1" />
  143. <Col width="153" id="column8" />
  144. <Col width="129" id="column7" />
  145. <Col width="292" id="column6" />
  146. <Col width="236" id="column5" />
  147. <Col width="289" id="column4" />
  148. <Col width="188" id="column2" />
  149. <Col width="223" id="column3" />
  150. <TR height="266" type="normal" displayEveryPage="true" id="row1" styleId="1">
  151. <TD id="cell1" styleId="2">
  152. <Value type="text"><![CDATA[序号]]></Value>
  153. </TD>
  154. <TD id="cell22" styleId="2">
  155. <Value type="text"><![CDATA[申请公司]]></Value>
  156. </TD>
  157. <TD id="cell19" styleId="2">
  158. <Value type="text"><![CDATA[汇票编号]]></Value>
  159. </TD>
  160. <TD id="cell16" styleId="2">
  161. <Value type="text"><![CDATA[付款账户名称]]></Value>
  162. </TD>
  163. <TD id="cell13" styleId="2">
  164. <Value type="text"><![CDATA[收款单位]]></Value>
  165. </TD>
  166. <TD id="cell10" styleId="2">
  167. <Value type="text"><![CDATA[票据金额]]></Value>
  168. </TD>
  169. <TD id="cell2" styleId="2">
  170. <Value type="text"><![CDATA[出票日期]]></Value>
  171. </TD>
  172. <TD id="cell3" styleId="2">
  173. <Value type="text"><![CDATA[到期日]]></Value>
  174. </TD>
  175. </TR>
  176. <TR height="3" type="normal" id="row5" styleId="1" hide="true">
  177. <TD id="cell33" styleId="2" />
  178. <TD id="cell34" styleId="3">
  179. <Value type="field">ApplyUnit.name</Value>
  180. </TD>
  181. <TD id="cell35" styleId="2" />
  182. <TD id="cell36" styleId="3">
  183. <Value type="field">OutBankAccount.name</Value>
  184. </TD>
  185. <TD id="cell37" styleId="2" />
  186. <TD id="cell38" styleId="2" />
  187. <TD id="cell39" styleId="2" />
  188. <TD id="cell40" styleId="2" />
  189. </TR>
  190. <TR height="116" type="detail" repeatTimes="5" id="row2" styleId="4">
  191. <TD id="cell4" styleId="5">
  192. <Script><![CDATA[if(get("seq") == null)
  193. {
  194. set("seq",0);
  195. }
  196. set("seq", get("seq") + 1);
  197. setValue(get("seq"));]]></Script>
  198. <Value type="text" />
  199. </TD>
  200. <TD id="cell23" styleId="6" />
  201. <TD id="cell20" styleId="7">
  202. <Value type="field">number</Value>
  203. </TD>
  204. <TD id="cell17" styleId="6">
  205. <Value type="field">OutBankAccount.name</Value>
  206. </TD>
  207. <TD id="cell14" styleId="7">
  208. <Value type="field">payeeName</Value>
  209. </TD>
  210. <TD id="cell11" styleId="8">
  211. <Value type="field">Amount</Value>
  212. </TD>
  213. <TD id="cell5" styleId="5">
  214. <Value type="field">IssueDate</Value>
  215. </TD>
  216. <TD id="cell6" styleId="5">
  217. <Value type="field">ExpiredDate</Value>
  218. </TD>
  219. </TR>
  220. <TR height="2" type="normal" id="row4" styleId="1" hide="true">
  221. <TD id="cell25" styleId="9" />
  222. <TD id="cell26" styleId="2" />
  223. <TD id="cell27" styleId="9" />
  224. <TD id="cell28" styleId="2" />
  225. <TD id="cell29" styleId="9" />
  226. <TD id="cell30" styleId="9" />
  227. <TD id="cell31" styleId="9" />
  228. <TD id="cell32" styleId="9" />
  229. </TR>
  230. <TR height="116" type="normal" displayEveryPage="true" id="row3" styleId="4">
  231. <TD id="cell7" styleId="6">
  232. <Value type="text"><![CDATA[金额总计]]></Value>
  233. </TD>
  234. <TD id="cell24" styleId="6" />
  235. <TD id="cell21" styleId="6" />
  236. <TD id="cell18" styleId="6" />
  237. <TD id="cell15" styleId="6" />
  238. <TD id="cell12" styleId="6">
  239. <Value type="stat" stat="sum" range="group">Amount</Value>
  240. </TD>
  241. <TD id="cell8" styleId="6" />
  242. <TD id="cell9" styleId="6" />
  243. </TR>
  244. <MergeBlocks>
  245. <Block left="1" right="1" top="1" bottom="3" />
  246. <Block left="3" right="3" top="1" bottom="3" />
  247. </MergeBlocks>
  248. </PrintDataGrid>
  249. <PrintDataGrid id="dataGrid2" styleId="1" x="18" y="1284">
  250. <Script><![CDATA[dataGrid2.secondBirth()]]></Script>
  251. <Data dataSource="R1Print_SystemDefine_Approve" />
  252. <Col width="169" id="column9" />
  253. <Col width="153" id="column10" />
  254. <Col width="132" id="column11" />
  255. <Col width="286" id="column16" />
  256. <Col width="239" id="column15" />
  257. <Col width="289" id="column14" />
  258. <Col width="191" id="column13" />
  259. <Col width="220" id="column12" />
  260. <TR height="96" type="normal" displayEveryPage="true" id="row8" styleId="1">
  261. <TD id="cell57" styleId="2">
  262. <Value type="text"><![CDATA[审批人名称]]></Value>
  263. </TD>
  264. <TD id="cell58" styleId="2">
  265. <Value type="text"><![CDATA[任务名称]]></Value>
  266. </TD>
  267. <TD id="cell59" styleId="2">
  268. <Value type="text"><![CDATA[审批结果]]></Value>
  269. </TD>
  270. <TD id="cell78" styleId="2">
  271. <Value type="text"><![CDATA[处理策略]]></Value>
  272. </TD>
  273. <TD id="cell75" styleId="2" />
  274. <TD id="cell72" styleId="2">
  275. <Value type="text"><![CDATA[审批时间]]></Value>
  276. </TD>
  277. <TD id="cell69" styleId="2" />
  278. <TD id="cell66" styleId="2">
  279. <Value type="text"><![CDATA[审批意见]]></Value>
  280. </TD>
  281. </TR>
  282. <TR height="96" type="detail" repeatTimes="3" id="row9" styleId="1">
  283. <TD id="cell60" styleId="3">
  284. <Value type="field">creator.name</Value>
  285. </TD>
  286. <TD id="cell61" styleId="3">
  287. <Value type="field">AssignView.subject</Value>
  288. </TD>
  289. <TD id="cell62" styleId="3">
  290. <Value type="field">isPass</Value>
  291. </TD>
  292. <TD id="cell79" styleId="3">
  293. <Value type="field">handlerOpinion</Value>
  294. </TD>
  295. <TD id="cell76" styleId="3" />
  296. <TD id="cell73" styleId="3">
  297. <Value type="field">createTime</Value>
  298. </TD>
  299. <TD id="cell70" styleId="3" />
  300. <TD id="cell67" styleId="3">
  301. <Value type="field">opinion</Value>
  302. </TD>
  303. </TR>
  304. <TR height="96" type="normal" displayEveryPage="true" id="row10" styleId="10">
  305. <TD id="cell63" styleId="3" />
  306. <TD id="cell64" styleId="3">
  307. <Sub-objects>
  308. <Text id="text2" styleId="11" x="0" y="0" width="151" height="94" horizontalFill="true" verticalFill="true">
  309. <Data><![CDATA[制单人]]></Data>
  310. </Text>
  311. </Sub-objects>
  312. </TD>
  313. <TD id="cell65" styleId="3">
  314. <Sub-objects>
  315. <Text id="text4" styleId="11" x="0" y="0" width="130" height="94" horizontalFill="true" verticalFill="true">
  316. <Data dataSource="PayableBillBatchNoTDQuery" bindField="creator.name" />
  317. </Text>
  318. </Sub-objects>
  319. </TD>
  320. <TD id="cell80" styleId="3" />
  321. <TD id="cell77" styleId="3">
  322. <Value type="text"><![CDATA[制单单位]]></Value>
  323. </TD>
  324. <TD id="cell74" styleId="3">
  325. <Sub-objects>
  326. <Text id="text3" styleId="12" x="0" y="0" width="698" height="94" horizontalFill="true" verticalFill="true">
  327. <Data dataSource="PayableBillBatchNoTDQuery" bindField="company.name" />
  328. </Text>
  329. </Sub-objects>
  330. </TD>
  331. <TD id="cell71" styleId="3" />
  332. <TD id="cell68" styleId="3" />
  333. </TR>
  334. <MergeBlocks>
  335. <Block left="5" right="7" top="2" bottom="2" />
  336. </MergeBlocks>
  337. </PrintDataGrid>
  338. </Sub-objects>
  339. </Page>
  340. </Report>
  341. <PrintInfo>
  342. <PaperSetup>
  343. <Paper>iso-a4</Paper>
  344. <Orientation>PORTRAIT</Orientation>
  345. <PageMargin left="190" right="190" top="250" bottom="250" />
  346. <Header height="150" margin="100" />
  347. <Footer height="150" margin="100" />
  348. </PaperSetup>
  349. <PrinterSetup>
  350. <DynamicPaper>false</DynamicPaper>
  351. <EconomizePaper isVerEconomizePaper="false" verSpace="0" isHorEconomizePaper="false" horSpace="0" />
  352. </PrinterSetup>
  353. <PreviewSetup>
  354. <BackgroundPicture>false</BackgroundPicture>
  355. </PreviewSetup>
  356. </PrintInfo>
  357. </DocRoot>