QueryPanel.js 5.5 KB

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