QueryPanel.js 5.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191
  1. Ext.define('saas.view.sale.saleout.QueryPanel', {
  2. extend: 'saas.view.core.query.QueryPanel',
  3. xtype: 'sale-saleout-querypanel',
  4. controller: 'sale-saleout-querypanel',
  5. viewModel: 'sale-saleout-querypanel',
  6. viewName: 'sale-saleout-querypanel',
  7. queryFormItems: [{
  8. xtype: 'hidden',
  9. name: 'pi_id',
  10. fieldLabel: 'ID',
  11. columnWidth: 0
  12. }, {
  13. xtype: 'textfield',
  14. name: 'pi_inoutno',
  15. fieldLabel: '单据编号'
  16. }, {
  17. xtype: 'condatefield',
  18. name: 'pi_recorddate',
  19. fieldLabel: '单据日期',
  20. allowBlank: true,
  21. columnWidth: 0.5
  22. }, {
  23. xtype: 'hidden',
  24. name: 'pi_custcode',
  25. fieldLabel: '客户编号'
  26. }, {
  27. xtype: 'dbfindtrigger',
  28. name: 'pi_custname',
  29. fieldLabel: '客户名称'
  30. }, {
  31. xtype: 'dbfindtrigger',
  32. name: 'pd_prodcode',
  33. fieldLabel: '物料编号',
  34. showDetail: true
  35. }, {
  36. xtype: 'textfield',
  37. name: 'pr_detail',
  38. fieldLabel: '物料名称',
  39. showDetail: true
  40. }, {
  41. xtype: 'combobox',
  42. name: 'pi_statuscode',
  43. fieldLabel: '审核状态',
  44. queryMode: 'local',
  45. displayField: 'pi_status',
  46. valueField: 'pi_statuscode',
  47. store: Ext.create('Ext.data.ArrayStore', {
  48. fields: ['pi_statuscode', 'pi_status'],
  49. data: [
  50. ["ALL", "全部"],
  51. ["AUDITED", "已审核"],
  52. ["UNAUDITED", "未审核"]
  53. ]
  54. }),
  55. getCondition: function(value) {
  56. if(value == 'ALL') {
  57. return '1=1';
  58. }else {
  59. return 'pi_statuscode=\'' + value + '\'';
  60. }
  61. }
  62. }],
  63. moreQueryFormItems: [],
  64. queryGridConfig: {
  65. idField:'id',
  66. codeField:'pi_inoutno',
  67. addTitle:'出货单',
  68. addXtype:'sale-saleout-formpanel',
  69. defaultCondition:' pi_class = \'出货单\'',
  70. baseVastUrl: '/api/sale/prodinout/',
  71. baseColumn: [{
  72. text: 'id',
  73. dataIndex: 'id',
  74. width: 0,
  75. xtype: 'numbercolumn'
  76. }, {
  77. text: '单据编号',
  78. dataIndex: 'pi_inoutno',
  79. width: 200
  80. }, {
  81. text: '审核状态',
  82. dataIndex: 'pi_status',
  83. width: 120
  84. },{
  85. text: '单据类型',
  86. dataIndex: 'pi_class',
  87. width: 120
  88. }, {
  89. text: '单据日期',
  90. dataIndex: 'pi_recorddate',
  91. xtype:'datecolumn',
  92. width: 200
  93. },{
  94. text: '销售单号',
  95. dataIndex: 'pi_sacode',
  96. width: 200
  97. },{
  98. text: '客户名称',
  99. dataIndex: 'pi_custname',
  100. width: 120
  101. },{
  102. text: '含税金额',
  103. dataIndex: 'pi_total',
  104. xtype:'numbercolumn',
  105. width: 120
  106. },{
  107. text: '未含税金额',
  108. dataIndex: 'pi_nettotal',
  109. xtype:'numbercolumn',
  110. width: 120
  111. }, {
  112. text: '备注',
  113. dataIndex: 'pi_remark',
  114. width: 250,
  115. flex:1
  116. }],
  117. relativeColumn: [{
  118. text: 'id',
  119. dataIndex: 'id',
  120. width: 0,
  121. xtype: 'numbercolumn'
  122. }, {
  123. text: '单据编号',
  124. dataIndex: 'pd_inoutno',
  125. width: 200
  126. }, {
  127. text: '单据状态',
  128. dataIndex: 'pi_status',
  129. width: 120
  130. }, {
  131. text: '单据日期',
  132. dataIndex: 'pi_recorddate',
  133. xtype:'datecolumn',
  134. width: 200
  135. } ,{
  136. text: '客户名称',
  137. dataIndex: 'pi_custname',
  138. width: 120
  139. }, {
  140. text: '明细序号',
  141. dataIndex: 'pd_detno',
  142. xtype: 'numbercolumn',
  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_outqty',
  160. xtype:'numbercolumn',
  161. width: 120
  162. }, {
  163. text: '销售单价',
  164. dataIndex: 'pd_sendprice',
  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. text: '备注',
  184. dataIndex: 'pd_remark',
  185. width: 250
  186. }]
  187. }
  188. });