QueryPanel.js 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205
  1. Ext.define('saas.view.sale.saleout.QueryPanel', {
  2. extend: 'saas.view.core.query.QueryPanel',
  3. xtype: 'sale-saleout-querypanel',
  4. controller: 'sale-saleout-queryformcontroller',
  5. viewModel: 'sale-saleout-queryformmodel',
  6. _baseVastUrl:'http://192.168.253.58:8800/sale/',
  7. _idField:'id',
  8. _codeField:'pi_inoutno',
  9. queryFormItems: [{
  10. xtype: 'hidden',
  11. name: 'id',
  12. bind: '{id}',
  13. fieldLabel: 'ID',
  14. allowBlank: true,
  15. columnWidth: 0
  16. }, {
  17. xtype: 'textfield',
  18. name: 'pi_inoutno',
  19. bind: '{pi_inoutno}',
  20. fieldLabel: '单据编号',
  21. allowBlank: true,
  22. columnWidth: 0.25
  23. }, {
  24. xtype: 'condatefield',
  25. name: 'pi_date',
  26. bind: '{pi_date}',
  27. fieldLabel: '单据日期',
  28. allowBlank: true,
  29. columnWidth: 0.5
  30. }, {
  31. xtype: 'textfield',
  32. name: 'pi_custcode',
  33. bind: '{pi_custcode}',
  34. fieldLabel: '客户编号',
  35. allowBlank: true,
  36. hidden:true,
  37. columnWidth: 0.25
  38. }, {
  39. xtype: 'textfield',
  40. name: 'pi_custname',
  41. bind: '{pi_custname}',
  42. fieldLabel: '客户名称',
  43. allowBlank: true,
  44. columnWidth: 0.25
  45. }, {
  46. xtype: 'dbfindtrigger',
  47. name: 'pd_prodcode',
  48. bind: '{pd_prodcode}',
  49. fieldLabel: '物料编号',
  50. fieldMode: 'DETAIL',
  51. queryType:'VAG',
  52. hidden:true,
  53. allowBlank: true,
  54. columnWidth: 0.25
  55. }, {
  56. xtype: 'dbfindtrigger',
  57. name: 'pr_detail#pd_prodcode',
  58. bind: '{pr_detail}',
  59. fieldLabel: '物料名称',
  60. allowBlank: true,
  61. columnWidth: 0.25
  62. }, {
  63. xtype: 'combobox',
  64. name: 'pi_statuscode',
  65. bind: '{pi_statuscode}',
  66. fieldLabel: '审核状态',
  67. allowBlank: true,
  68. columnWidth: 0.25,
  69. queryMode: 'local',
  70. displayField: 'pi_status',
  71. valueField: 'pi_statuscode',
  72. store: Ext.create('Ext.data.ArrayStore', {
  73. fields: ['pi_statuscode', 'pi_status'],
  74. data: [
  75. ["$ALL", "全部"],
  76. ["AUDITED", "已审核"],
  77. ["UNAUDITED", "未审核"]
  78. ]
  79. })
  80. }],
  81. moreQueryFormItems: [],
  82. queryGridConfig: {
  83. _idField:'id',
  84. _codeField:'pi_inoutno',
  85. _title:'销售出货单',
  86. _defaultCondition:' pi_class = \'销售出货单\'',
  87. _addXtype:'sale-saleout-formpanel',
  88. _baseVastUrl:'http://192.168.253.228:8800/prodinout/',
  89. _baseColumn: [{
  90. text: '序号',
  91. width: 80,
  92. xtype: 'rownumberer'
  93. }, {
  94. text: 'id',
  95. dataIndex: 'id',
  96. width: 100,
  97. xtype: 'numbercolumn'
  98. }, {
  99. text: '单据编号',
  100. dataIndex: 'pi_inoutno',
  101. width: 120
  102. }, {
  103. text: '单据状态',
  104. dataIndex: 'pi_status',
  105. width: 120
  106. },{
  107. text: '单据类型',
  108. dataIndex: 'pi_class',
  109. width: 120
  110. }, {
  111. text: '下单日期',
  112. dataIndex: 'pi_date',
  113. xtype:'datecolumn',
  114. width: 200
  115. },{
  116. text: '销售单号',
  117. dataIndex: 'pi_sacode',
  118. width: 200
  119. },{
  120. text: '客户名称',
  121. dataIndex: 'pi_custname',
  122. width: 120
  123. },{
  124. text: '含税金额',
  125. dataIndex: 'pi_total',
  126. xtype:'numbercolumn',
  127. width: 120
  128. },{
  129. text: '不含税金额',
  130. dataIndex: 'pi_nettotal',
  131. xtype:'numbercolumn',
  132. width: 120,
  133. flex: 1
  134. }],
  135. _relativeColumn: [{
  136. text : "序号",
  137. dataIndex : "pd_pdno",
  138. width : 100,
  139. xtype : "numbercolumn",
  140. align : 'center'
  141. }, {
  142. text: 'id',
  143. dataIndex: 'pu_id',
  144. width: 0,
  145. xtype: 'numbercolumn'
  146. }, {
  147. text: '单据编号',
  148. dataIndex: 'pd_inoutno',
  149. width: 120
  150. }, {
  151. text: '单据状态',
  152. dataIndex: 'pi_status',
  153. width: 120
  154. }, {
  155. text: '下单日期',
  156. dataIndex: 'pi_date',
  157. xtype:'datecolumn',
  158. width: 200
  159. },{
  160. text: '客户名称',
  161. dataIndex: 'pi_custname',
  162. width: 120
  163. },{
  164. text: '销售单号',
  165. dataIndex: 'pd_ordercode',
  166. width: 120
  167. },{
  168. text: '销售序号',
  169. dataIndex: 'pd_orderdetno',
  170. xtype:'numbercolumn',
  171. width: 120
  172. },{
  173. text: '物料编号',
  174. dataIndex: 'pd_prodcode',
  175. width: 120
  176. },{
  177. text: '出货数量',
  178. dataIndex: 'pd_outqty',
  179. xtype:'numbercolumn',
  180. width: 120
  181. },{
  182. text: '销售单价',
  183. dataIndex: 'pd_sendprice',
  184. xtype:'numbercolumn',
  185. width: 120
  186. },{
  187. text: '金额',
  188. dataIndex: 'pd_total',
  189. xtype:'numbercolumn',
  190. width: 120
  191. },{
  192. text: '税率',
  193. dataIndex: 'pd_taxrate',
  194. xtype:'numbercolumn',
  195. width: 120
  196. },{
  197. text: '成本单价',
  198. dataIndex: 'pd_price',
  199. xtype:'numbercolumn',
  200. width: 120,
  201. flex: 1
  202. }]
  203. }
  204. });