QueryPanel.js 5.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203
  1. Ext.define('saas.view.money.othspendings.QueryPanel', {
  2. extend: 'saas.view.core.query.QueryPanel',
  3. xtype: 'money-othspendings-querypanel',
  4. controller: 'money-othspendings-querypanel',
  5. viewModel: 'money-othspendings-querypanel',
  6. viewName: 'money-othspendings-querypanel',
  7. queryFormItems: [{
  8. xtype: 'textfield',
  9. name: 'os_code',
  10. emptyText:'请输入单号'
  11. },{
  12. xtype: 'condatefield',
  13. name: 'os_date',
  14. columnWidth: 0.5,
  15. fieldLabel: '日期'
  16. }, {
  17. xtype: 'vendorDbfindTrigger',
  18. name: 'os_vendname',
  19. fieldLabel: '供应商',
  20. emptyText :'请输入供应商编号或名称'
  21. }, {
  22. name: 'osd_type',
  23. fieldLabel: '支出类别',
  24. xtype : "remotecombo",
  25. emptyText :'全部',
  26. showDetail: true,
  27. storeUrl:'/api/document/fundinouttype/getCombo?condition=支出',
  28. hiddenBtn:true,//true 则会关闭新增按钮功能
  29. getCondition: function(value) {
  30. if(!value) {
  31. return '1=1';
  32. }else {
  33. return 'osd_type like \'%' + value + '%\'';
  34. }
  35. }
  36. }, {
  37. xtype : "bandinfoDbfindTrigger",
  38. name : "os_bankname",
  39. fieldLabel : "账户名称",
  40. emptyText:'请输入账户编号或名称'
  41. },{
  42. xtype: 'combobox',
  43. name: 'os_statuscode',
  44. fieldLabel: '单据状态',
  45. queryMode: 'local',
  46. displayField: 'os_status',
  47. valueField: 'os_statuscode',
  48. emptyText :'全部',
  49. editable:false,
  50. store: Ext.create('Ext.data.ArrayStore', {
  51. fields: ['os_statuscode', 'os_status'],
  52. data: [
  53. ["ALL", "全部"],
  54. ["AUDITED", "已审核"],
  55. ["UNAUDITED", "未审核"]
  56. ]
  57. }),
  58. getCondition: function(value) {
  59. if(value == 'ALL') {
  60. return '1=1';
  61. }else {
  62. return 'os_statuscode=\'' + value + '\'';
  63. }
  64. }
  65. }, {
  66. xtype: 'employeeDbfindTrigger',
  67. name: 'creatorName',
  68. fieldLabel: '录入人',
  69. emptyText:'请输入人员编号或名称',
  70. getCondition: function(value) {
  71. if(!value) {
  72. return '1=1';
  73. }else {
  74. return 'othspendings.creatorName like\'%' + value + '%\'';
  75. }
  76. }
  77. }, {
  78. xtype: 'employeeDbfindTrigger',
  79. name: 'os_auditman',
  80. fieldLabel: '审核人',
  81. emptyText:'请输入人员编号或名称'
  82. }],
  83. moreQueryFormItems: [],
  84. queryGridConfig: {
  85. idField: 'id',
  86. codeField: 'os_code',
  87. addTitle: '其它支出单',
  88. addXtype: 'money-othspendings-formpanel',
  89. defaultCondition:'',
  90. baseVastUrl: '/api/money/othspendings/',
  91. baseColumn: [{
  92. text: 'id',
  93. dataIndex: 'id',
  94. hidden:true,
  95. xtype: 'numbercolumn'
  96. }, {
  97. text: '单据编号',
  98. dataIndex: 'os_code',
  99. width: 150
  100. }, {
  101. text: '日期',
  102. dataIndex: 'os_date',
  103. xtype: 'datecolumn',
  104. width: 110
  105. }, {
  106. text: '供应商名称',
  107. dataIndex: 'os_vendname',
  108. width:250
  109. },{
  110. text: '结算账户',
  111. dataIndex: 'os_bankname',
  112. width: 150
  113. },{
  114. text: '付款金额',
  115. dataIndex: 'os_amount',
  116. width: 110,
  117. renderer : function(v) {
  118. var arr = (v + '.').split('.');
  119. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  120. var format = '0,000.' + xr.join();
  121. return Ext.util.Format.number(v, format);
  122. }
  123. }, {
  124. text: '单据状态',
  125. align: 'center',
  126. dataIndex: 'os_status',
  127. width: 90
  128. },{
  129. text: '录入人',
  130. dataIndex: 'creatorName',
  131. width: 110
  132. }, {
  133. text: '审核人',
  134. dataIndex: 'os_auditman',
  135. width: 110
  136. }, {
  137. text: '备注',
  138. dataIndex: 'os_remark',
  139. width: 250
  140. }],
  141. relativeColumn: [{
  142. text: 'id',
  143. dataIndex: 'id',
  144. hidden:true,
  145. xtype: 'numbercolumn'
  146. }, {
  147. text: '单据编号',
  148. dataIndex: 'os_code',
  149. width: 150
  150. }, {
  151. text: '日期',
  152. dataIndex: 'os_date',
  153. xtype: 'datecolumn',
  154. width: 110
  155. }, {
  156. text: '供应商名称',
  157. dataIndex: 'os_vendname',
  158. width:250
  159. },{
  160. text: '结算账户',
  161. dataIndex: 'os_bankname',
  162. width: 150
  163. },{
  164. text: '付款金额',
  165. dataIndex: 'os_amount',
  166. width: 110,
  167. renderer : function(v) {
  168. var arr = (v + '.').split('.');
  169. var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
  170. var format = '0,000.' + xr.join();
  171. return Ext.util.Format.number(v, format);
  172. }
  173. }, {
  174. text: '单据状态',
  175. align: 'center',
  176. dataIndex: 'os_status',
  177. width: 90
  178. },{
  179. text: '录入人',
  180. dataIndex: 'creatorName',
  181. width: 110
  182. }, {
  183. text: '审核人',
  184. dataIndex: 'os_auditman',
  185. width: 110
  186. }, {
  187. text: '支出类别',
  188. dataIndex: 'osd_type',
  189. width: 110
  190. }, {
  191. text: '明细金额',
  192. dataIndex: 'osd_nowbalance',
  193. width: 110
  194. },{
  195. text: '备注',
  196. dataIndex: 'osd_remark',
  197. width: 250
  198. }]
  199. }
  200. });