QueryPanel.js 5.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187
  1. Ext.define('saas.view.stock.appropriationInOut.QueryPanel', {
  2. extend: 'saas.view.core.query.QueryPanel',
  3. xtype: 'stock-appropriationinout-querypanel',
  4. controller: 'stock-appropriationinout-querypanel',
  5. viewModel: 'stock-appropriationinout-querypanel',
  6. viewName: 'stock-appropriationinout-querypanel',
  7. queryFormItems: [{
  8. xtype: 'hidden',
  9. name: 'id',
  10. fieldLabel: 'ID',
  11. allowBlank: true,
  12. columnWidth: 0
  13. }, {
  14. xtype: 'textfield',
  15. name: 'pi_inoutno',
  16. fieldLabel: '单据编号',
  17. allowBlank: true,
  18. columnWidth: 0.25
  19. }, {
  20. xtype: 'condatefield',
  21. name: 'pi_date',
  22. fieldLabel: '单据日期',
  23. allowBlank: true,
  24. columnWidth: 0.5
  25. }, {
  26. xtype: 'textfield',
  27. name: 'pi_vendcode',
  28. fieldLabel: '供应商编号',
  29. allowBlank: true,
  30. hidden:true,
  31. columnWidth: 0.25
  32. }, {
  33. xtype: 'textfield',
  34. name: 'pi_vendname',
  35. fieldLabel: '供应商名称',
  36. allowBlank: true,
  37. columnWidth: 0.25
  38. }, {
  39. xtype: 'dbfindtrigger',
  40. name: 'pd_prodcode',
  41. fieldLabel: '物料编号',
  42. showDetail: true
  43. }, {
  44. xtype: 'textfield',
  45. name: 'pr_detail',
  46. fieldLabel: '物料名称',
  47. showDetail: true
  48. }, {
  49. xtype: 'combobox',
  50. name: 'pi_statuscode',
  51. fieldLabel: '审核状态',
  52. allowBlank: true,
  53. columnWidth: 0.25,
  54. queryMode: 'local',
  55. displayField: 'pi_status',
  56. valueField: 'pi_statuscode',
  57. store: Ext.create('Ext.data.ArrayStore', {
  58. fields: ['pi_statuscode', 'pi_status'],
  59. data: [
  60. ["ALL", "全部"],
  61. ["AUDITED", "已审核"],
  62. ["UNAUDITED", "未审核"]
  63. ]
  64. }),
  65. getCondition: function(value) {
  66. if(value == 'ALL') {
  67. return '1=1';
  68. }else {
  69. return 'pi_statuscode=\'' + value + '\'';
  70. }
  71. }
  72. }],
  73. moreQueryFormItems: [],
  74. queryGridConfig: {
  75. idField:'id',
  76. codeField:'pi_inoutno',
  77. addTitle:'调拨单',
  78. addXtype:'stock-appropriationinout-formpanel',
  79. defaultCondition:' pi_class = \'调拨单\'',
  80. baseVastUrl:'/api/storage/prodinout/',
  81. baseColumn: [{
  82. text: 'id',
  83. dataIndex: 'id',
  84. width: 0,
  85. xtype: 'numbercolumn'
  86. }, {
  87. text: '单据编号',
  88. dataIndex: 'pi_inoutno',
  89. width: 200
  90. }, {
  91. text: '单据状态',
  92. dataIndex: 'pi_status',
  93. width: 120
  94. }, {
  95. text: '单据类型',
  96. dataIndex: 'pi_class',
  97. width: 120
  98. }, {
  99. text: '单据日期',
  100. dataIndex: 'pi_date',
  101. xtype:'datecolumn',
  102. width: 200
  103. },{
  104. text: '采购单号',
  105. dataIndex: 'pi_pucode',
  106. width: 200
  107. },{
  108. text: '供应商名称',
  109. dataIndex: 'pi_vendname',
  110. width: 120
  111. },{
  112. text: '含税金额',
  113. dataIndex: 'pi_total',
  114. xtype:'numbercolumn',
  115. width: 120
  116. },{
  117. text: '未税金额',
  118. dataIndex: 'pi_nettotal',
  119. xtype:'numbercolumn',
  120. width: 120,
  121. }],
  122. relativeColumn: [{
  123. text: 'id',
  124. dataIndex: 'pu_id',
  125. width: 0,
  126. xtype: 'numbercolumn'
  127. }, {
  128. text: '单据编号',
  129. dataIndex: 'pd_inoutno',
  130. width: 200
  131. }, {
  132. text: '单据状态',
  133. dataIndex: 'pi_status',
  134. width: 120
  135. }, {
  136. text: '单据日期',
  137. dataIndex: 'pi_date',
  138. xtype:'datecolumn',
  139. width: 200
  140. },{
  141. text: '供应商名称',
  142. dataIndex: 'pi_vendname',
  143. width: 120
  144. },{
  145. text: '采购单号',
  146. dataIndex: 'pd_ordercode',
  147. width: 120
  148. },{
  149. text: '采购序号',
  150. dataIndex: 'pd_orderdetno',
  151. xtype:'numbercolumn',
  152. width: 120
  153. },{
  154. text: '物料编号',
  155. dataIndex: 'pd_prodcode',
  156. width: 120
  157. },{
  158. text: '验收数量',
  159. dataIndex: 'pd_inqty',
  160. xtype:'numbercolumn',
  161. width: 120
  162. },{
  163. text: '采购单价',
  164. dataIndex: 'pd_orderprice',
  165. xtype:'numbercolumn',
  166. width: 120
  167. },{
  168. text: '金额',
  169. dataIndex: 'pd_total',
  170. xtype:'numbercolumn',
  171. width: 120
  172. },{
  173. text: '税率',
  174. dataIndex: 'pd_taxrate',
  175. xtype:'numbercolumn',
  176. width: 120
  177. },{
  178. text: '成本单价',
  179. dataIndex: 'pd_price',
  180. xtype:'numbercolumn',
  181. width: 120,
  182. }]
  183. }
  184. });