LedgerSingle.js 8.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425
  1. /**
  2. *
  3. */
  4. Ext.define('erp.view.fa.gla.LedgerSingle',{
  5. extend: 'Ext.grid.Panel',
  6. alias: 'widget.ledgerSingle',
  7. layout : 'fit',
  8. id: 'ledgerSingle',
  9. emptyText : $I18N.common.grid.emptyText,
  10. columnLines : true,
  11. autoScroll : true,
  12. store: Ext.create('Ext.data.Store', {
  13. fields:[{
  14. name: 'ca_code',
  15. type: 'string'
  16. },{
  17. name: 'ca_name',
  18. type: 'string'
  19. },{
  20. name: 'am_asscode',
  21. type: 'string'
  22. },{
  23. name: 'am_assname',
  24. type: 'string'
  25. },{
  26. name: 'am_asstype',
  27. type: 'string'
  28. },{
  29. name: 'cm_yearmonth',
  30. type: 'string'
  31. },{
  32. name: 'cmc_currency',
  33. type: 'string'
  34. },{
  35. name: 'cm_begindebit',
  36. type: 'number'
  37. },{
  38. name: 'cm_begincredit',
  39. type: 'number'
  40. },{
  41. name: 'cmc_begindoubledebit',
  42. type: 'number'
  43. },{
  44. name: 'cmc_begindoublecredit',
  45. type: 'number'
  46. },{
  47. name: 'cm_nowdebit',
  48. type: 'number'
  49. },{
  50. name: 'cm_nowcredit',
  51. type: 'number'
  52. },{
  53. name: 'cmc_nowdoubledebit',
  54. type: 'number'
  55. },{
  56. name: 'cmc_nowdoublecredit',
  57. type: 'number'
  58. },{
  59. name: 'cm_yearenddebit',
  60. type: 'number'
  61. },{
  62. name: 'cm_yearendcredit',
  63. type: 'number'
  64. },{
  65. name: 'cmc_yearenddoubledebit',
  66. type: 'number'
  67. },{
  68. name: 'cmc_yearenddoublecredit',
  69. type: 'number'
  70. },{
  71. name: 'cm_enddebit',
  72. type: 'number'
  73. },{
  74. name: 'cm_endcredit',
  75. type: 'number'
  76. },{
  77. name: 'cmc_enddoubledebit',
  78. type: 'number'
  79. },{
  80. name: 'cmc_enddoublecredit',
  81. type: 'number'
  82. },{
  83. name: 'index',
  84. type: 'number'
  85. }],
  86. data: []
  87. }),
  88. defaultColumns: [{
  89. dataIndex: 'ca_code',
  90. cls: 'x-grid-header-1',
  91. sortable: false,
  92. width: 130,
  93. text: '科目编号'
  94. },{
  95. dataIndex: 'ca_name',
  96. cls: 'x-grid-header-1',
  97. sortable: false,
  98. text: '科目名称',
  99. width: 200
  100. },{
  101. dataIndex: 'am_asscode',
  102. cls: 'x-grid-header-1',
  103. sortable: false,
  104. hidden: true,
  105. text: '核算编号',
  106. width: 90
  107. },{
  108. dataIndex: 'am_assname',
  109. cls: 'x-grid-header-1',
  110. sortable: false,
  111. hidden: true,
  112. text: '核算名称',
  113. width: 150
  114. },{
  115. dataIndex: 'cm_yearmonth',
  116. cls: 'x-grid-header-1',
  117. sortable: false,
  118. text: '期间',
  119. width: 70
  120. },{
  121. cls: 'x-grid-header-1',
  122. text: '期初',
  123. sortable: false,
  124. columns: [{
  125. text: '借方',
  126. cls: 'x-grid-header-1',
  127. dataIndex: 'cm_begindebit',
  128. sortable: false,
  129. width: 120,
  130. xtype: 'numbercolumn',
  131. align: 'right'
  132. },{
  133. dataIndex: 'cm_begincredit',
  134. cls: 'x-grid-header-1',
  135. sortable: false,
  136. text: '贷方',
  137. width: 120,
  138. xtype: 'numbercolumn',
  139. align: 'right'
  140. }]
  141. },{
  142. cls: 'x-grid-header-1',
  143. text: '本期发生',
  144. sortable: false,
  145. columns: [{
  146. text: '借方',
  147. cls: 'x-grid-header-1',
  148. dataIndex: 'cm_nowdebit',
  149. sortable: false,
  150. width: 120,
  151. xtype: 'numbercolumn',
  152. align: 'right'
  153. },{
  154. dataIndex: 'cm_nowcredit',
  155. cls: 'x-grid-header-1',
  156. sortable: false,
  157. text: '贷方',
  158. width: 120,
  159. xtype: 'numbercolumn',
  160. align: 'right'
  161. }]
  162. },{
  163. cls: 'x-grid-header-1',
  164. text: '本年累计',
  165. sortable: false,
  166. columns: [{
  167. text: '借方',
  168. cls: 'x-grid-header-1',
  169. dataIndex: 'cm_yearenddebit',
  170. sortable: false,
  171. width: 120,
  172. xtype: 'numbercolumn',
  173. align: 'right'
  174. },{
  175. dataIndex: 'cm_yearendcredit',
  176. cls: 'x-grid-header-1',
  177. sortable: false,
  178. text: '贷方',
  179. width: 120,
  180. xtype: 'numbercolumn',
  181. align: 'right'
  182. }]
  183. },{
  184. cls: 'x-grid-header-1',
  185. text: '期末',
  186. sortable: false,
  187. columns: [{
  188. text: '借方',
  189. cls: 'x-grid-header-1',
  190. dataIndex: 'cm_enddebit',
  191. sortable: false,
  192. width: 120,
  193. xtype: 'numbercolumn',
  194. align: 'right'
  195. },{
  196. dataIndex: 'cm_endcredit',
  197. cls: 'x-grid-header-1',
  198. sortable: false,
  199. text: '贷方',
  200. width: 120,
  201. xtype: 'numbercolumn',
  202. align: 'right'
  203. }]
  204. }],
  205. doubleColumns: [{
  206. dataIndex: 'ca_code',
  207. cls: 'x-grid-header-1',
  208. sortable: false,
  209. width: 120,
  210. text: '科目编号'
  211. },{
  212. dataIndex: 'ca_name',
  213. cls: 'x-grid-header-1',
  214. sortable: false,
  215. text: '科目名称',
  216. width: 180
  217. },{
  218. dataIndex: 'am_asscode',
  219. cls: 'x-grid-header-1',
  220. sortable: false,
  221. hidden: true,
  222. text: '核算编号',
  223. width: 80
  224. },{
  225. dataIndex: 'am_assname',
  226. cls: 'x-grid-header-1',
  227. sortable: false,
  228. hidden: true,
  229. text: '核算名称',
  230. width: 120
  231. },{
  232. dataIndex: 'cm_yearmonth',
  233. cls: 'x-grid-header-1',
  234. sortable: false,
  235. text: '期间',
  236. width: 70
  237. },{
  238. dataIndex: 'cmc_currency',
  239. cls: 'x-grid-header-1',
  240. sortable: false,
  241. text: '币别',
  242. width: 70
  243. },{
  244. cls: 'x-grid-header-1',
  245. text: '期初(本币)',
  246. sortable: false,
  247. columns: [{
  248. text: '借方',
  249. cls: 'x-grid-header-1',
  250. dataIndex: 'cm_begindebit',
  251. sortable: false,
  252. width: 120,
  253. xtype: 'numbercolumn',
  254. align: 'right'
  255. },{
  256. dataIndex: 'cm_begincredit',
  257. cls: 'x-grid-header-1',
  258. sortable: false,
  259. text: '贷方',
  260. width: 120,
  261. xtype: 'numbercolumn',
  262. align: 'right'
  263. }]
  264. },{
  265. cls: 'x-grid-header-1',
  266. text: '期初(原币)',
  267. sortable: false,
  268. columns: [{
  269. text: '借方',
  270. cls: 'x-grid-header-1',
  271. dataIndex: 'cmc_begindoubledebit',
  272. sortable: false,
  273. width: 120,
  274. xtype: 'numbercolumn',
  275. align: 'right'
  276. },{
  277. dataIndex: 'cmc_begindoublecredit',
  278. cls: 'x-grid-header-1',
  279. sortable: false,
  280. text: '贷方',
  281. width: 120,
  282. xtype: 'numbercolumn',
  283. align: 'right'
  284. }]
  285. },{
  286. cls: 'x-grid-header-1',
  287. text: '本期发生(本币)',
  288. sortable: false,
  289. columns: [{
  290. text: '借方',
  291. cls: 'x-grid-header-1',
  292. dataIndex: 'cm_nowdebit',
  293. sortable: false,
  294. width: 120,
  295. xtype: 'numbercolumn',
  296. align: 'right'
  297. },{
  298. dataIndex: 'cm_nowcredit',
  299. cls: 'x-grid-header-1',
  300. sortable: false,
  301. text: '贷方',
  302. width: 120,
  303. xtype: 'numbercolumn',
  304. align: 'right'
  305. }]
  306. },{
  307. cls: 'x-grid-header-1',
  308. text: '本期发生(原币)',
  309. sortable: false,
  310. columns: [{
  311. text: '借方',
  312. cls: 'x-grid-header-1',
  313. dataIndex: 'cmc_nowdoubledebit',
  314. sortable: false,
  315. width: 120,
  316. xtype: 'numbercolumn',
  317. align: 'right'
  318. },{
  319. dataIndex: 'cmc_nowdoublecredit',
  320. cls: 'x-grid-header-1',
  321. sortable: false,
  322. text: '贷方',
  323. width: 120,
  324. xtype: 'numbercolumn',
  325. align: 'right'
  326. }]
  327. },{
  328. cls: 'x-grid-header-1',
  329. text: '本年累计(本币)',
  330. sortable: false,
  331. columns: [{
  332. text: '借方',
  333. cls: 'x-grid-header-1',
  334. dataIndex: 'cm_yearenddebit',
  335. sortable: false,
  336. width: 120,
  337. xtype: 'numbercolumn',
  338. align: 'right'
  339. },{
  340. dataIndex: 'cm_yearendcredit',
  341. cls: 'x-grid-header-1',
  342. sortable: false,
  343. text: '贷方',
  344. width: 120,
  345. xtype: 'numbercolumn',
  346. align: 'right'
  347. }]
  348. },{
  349. cls: 'x-grid-header-1',
  350. text: '本年累计(原币)',
  351. sortable: false,
  352. columns: [{
  353. text: '借方',
  354. cls: 'x-grid-header-1',
  355. dataIndex: 'cmc_yearenddoubledebit',
  356. sortable: false,
  357. width: 120,
  358. xtype: 'numbercolumn',
  359. align: 'right'
  360. },{
  361. dataIndex: 'cmc_yearenddoublecredit',
  362. cls: 'x-grid-header-1',
  363. sortable: false,
  364. text: '贷方',
  365. width: 120,
  366. xtype: 'numbercolumn',
  367. align: 'right'
  368. }]
  369. },{
  370. cls: 'x-grid-header-1',
  371. text: '期末(本币)',
  372. sortable: false,
  373. columns: [{
  374. text: '借方',
  375. cls: 'x-grid-header-1',
  376. dataIndex: 'cm_enddebit',
  377. sortable: false,
  378. width: 120,
  379. xtype: 'numbercolumn',
  380. align: 'right'
  381. },{
  382. dataIndex: 'cm_endcredit',
  383. cls: 'x-grid-header-1',
  384. sortable: false,
  385. text: '贷方',
  386. width: 120,
  387. xtype: 'numbercolumn',
  388. align: 'right'
  389. }]
  390. },{
  391. cls: 'x-grid-header-1',
  392. text: '期末(原币)',
  393. sortable: false,
  394. columns: [{
  395. text: '借方',
  396. cls: 'x-grid-header-1',
  397. dataIndex: 'cmc_enddoubledebit',
  398. sortable: false,
  399. width: 120,
  400. xtype: 'numbercolumn',
  401. align: 'right'
  402. },{
  403. dataIndex: 'cmc_enddoublecredit',
  404. cls: 'x-grid-header-1',
  405. sortable: false,
  406. text: '贷方',
  407. width: 120,
  408. xtype: 'numbercolumn',
  409. align: 'right'
  410. }]
  411. }],
  412. bodyStyle:'background-color:#f1f1f1;',
  413. cls: 'custom-grid',
  414. GridUtil: Ext.create('erp.util.GridUtil'),
  415. initComponent : function(){
  416. this.columns = this.defaultColumns;
  417. this.callParent(arguments);
  418. },
  419. viewConfig: {
  420. getRowClass: function(record) {
  421. return record.get('index')%2 == 1 ? (!Ext.isEmpty(record.get('ca_code')) ? 'custom-first' : 'custom') :
  422. (!Ext.isEmpty(record.get('ca_code')) ? 'custom-alt-first' : 'custom-alt');
  423. }
  424. }
  425. });