QueryPanel.js 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212
  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. bind: '{id}',
  11. fieldLabel: 'ID',
  12. allowBlank: true,
  13. columnWidth: 0
  14. }, {
  15. xtype: 'textfield',
  16. name: 'pi_inoutno',
  17. bind: '{pi_inoutno}',
  18. fieldLabel: '单据编号',
  19. allowBlank: true,
  20. columnWidth: 0.25
  21. }, {
  22. xtype: 'condatefield',
  23. name: 'pi_date',
  24. bind: '{pi_date}',
  25. fieldLabel: '采购日期',
  26. allowBlank: true,
  27. columnWidth: 0.5
  28. }, {
  29. xtype: 'dbfindtrigger',
  30. name: 'pu_vendcode',
  31. bind: '{pu_vendcode}',
  32. fieldLabel: '供应商编号',
  33. allowBlank: true,
  34. columnWidth: 0.25
  35. }, {
  36. xtype: 'textfield',
  37. name: 'pu_vendname',
  38. bind: '{pu_vendname}',
  39. fieldLabel: '供应商名称',
  40. allowBlank: true,
  41. columnWidth: 0.25
  42. }, {
  43. xtype: 'dbfindtrigger',
  44. name: 'pd_prodcode#pd_prodcode',
  45. //#pr_detail
  46. bind: '{pd_prodcode}',
  47. fieldLabel: '物料编号',
  48. fieldMode: 'DETAIL',
  49. queryType: 'VAG',
  50. allowBlank: true,
  51. columnWidth: 0.25
  52. }, {
  53. xtype: 'textfield',
  54. name: 'pr_detail',
  55. bind: '{pr_detail}',
  56. fieldLabel: '物料名称',
  57. allowBlank: true,
  58. columnWidth: 0.25
  59. }, {
  60. xtype: 'combobox',
  61. name: 'pu_statuscode',
  62. // bind: '{pu_statuscode}',
  63. fieldLabel: '审核状态',
  64. allowBlank: true,
  65. columnWidth: 0.25,
  66. queryMode: 'local',
  67. displayField: 'pu_status',
  68. valueField: 'pu_statuscode',
  69. editable:false,
  70. store: Ext.create('Ext.data.ArrayStore', {
  71. fields: ['pu_statuscode', 'pu_status'],
  72. data: [
  73. ["$ALL", "全部"],
  74. ["AUDITED", "已审核"],
  75. ["UNAUDITED", "未审核"]
  76. ]
  77. })
  78. }, {
  79. xtype: 'multicombo',
  80. name: 'pu_acceptstatuscode',
  81. bind: '{pu_acceptstatuscode}',
  82. fieldLabel: '入库状态',
  83. allowBlank: true,
  84. columnWidth: 0.25,
  85. datas: [
  86. ["TURNIN", "已入库"],
  87. ["UNTURNIN", "未入库"],
  88. ["PARTIN", "部分入库"]
  89. ]
  90. }],
  91. moreQueryFormItems: [{
  92. xtype: 'textfield',
  93. name: 'pu_buyername',
  94. bind: '{pu_buyername}',
  95. fieldLabel: '采购员',
  96. allowBlank: true
  97. }, {
  98. xtype: 'textfield',
  99. name: 'pu_total',
  100. bind: '{pu_total}',
  101. fieldLabel: '金额',
  102. allowBlank: true
  103. }, {
  104. xtype: 'condatefield',
  105. name: 'pu_delivery',
  106. bind: '{pu_delivery}',
  107. fieldLabel: '交货日期',
  108. allowBlank: true,
  109. columnWidth: 1
  110. }],
  111. queryGridConfig: {
  112. idField: 'id',
  113. codeField: 'pi_inoutno',
  114. addTitle: '其它入库单',
  115. addXtype: 'stock-appropriationinout-formpanel',
  116. defaultCondition:' pi_class = \'其它入库单\'',
  117. baseVastUrl: 'http://localhost:9000/prodinout/',
  118. baseColumn: [{
  119. text: '序号',
  120. width: 80,
  121. xtype: 'rownumberer'
  122. }, {
  123. text: 'id',
  124. dataIndex: 'id',
  125. width: 100,
  126. xtype: 'numbercolumn'
  127. }, {
  128. text: '单据编号',
  129. dataIndex: 'pi_inoutno',
  130. width: 120
  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: 'pu_vendname',
  143. width: 120
  144. }, {
  145. text: '含税金额',
  146. dataIndex: 'pu_taxtotal',
  147. xtype: 'numbercolumn',
  148. width: 120
  149. }, {
  150. text: '金额',
  151. dataIndex: 'pu_total',
  152. xtype: 'numbercolumn',
  153. width: 120,
  154. flex: 1
  155. }],
  156. relativeColumn: [{
  157. text: '序号',
  158. width: 80,
  159. xtype: 'rownumberer'
  160. }, {
  161. text: 'id',
  162. dataIndex: 'id',
  163. width: 100,
  164. xtype: 'numbercolumn'
  165. }, {
  166. text: '单据编号',
  167. dataIndex: 'pu_code',
  168. width: 120
  169. }, {
  170. text: '单据状态',
  171. dataIndex: 'pu_status',
  172. width: 120
  173. }, {
  174. text: '下单日期',
  175. dataIndex: 'pu_indate',
  176. xtype: 'datecolumn',
  177. width: 200
  178. }, {
  179. text: '供应商名称',
  180. dataIndex: 'pu_vendname',
  181. width: 120
  182. }, {
  183. text: '采购序号',
  184. dataIndex: 'pd_detno',
  185. xtype: 'numbercolumn',
  186. width: 120
  187. }, {
  188. text: '物料编号',
  189. dataIndex: 'pd_prodcode',
  190. width: 120
  191. }, {
  192. text: '数量',
  193. dataIndex: 'pd_qty',
  194. xtype: 'numbercolumn',
  195. width: 120
  196. }, {
  197. text: '单价',
  198. dataIndex: 'pd_price',
  199. xtype: 'numbercolumn',
  200. width: 120
  201. }, {
  202. text: '已转数',
  203. dataIndex: 'pd_ytqy',
  204. xtype: 'numbercolumn',
  205. width: 120,
  206. flex: 1
  207. }]
  208. }
  209. });