VmQuery.js 7.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295
  1. Ext.QuickTips.init();
  2. Ext.define('erp.controller.fa.arp.VmQuery', {
  3. extend: 'Ext.app.Controller',
  4. GridUtil: Ext.create('erp.util.GridUtil'),
  5. condition:'',
  6. views:[
  7. 'fa.arp.vmQuery.Viewport','fa.arp.vmQuery.GridPanel','fa.arp.vmQuery.QueryForm','fa.arp.vmQuery.QueryWin',
  8. 'core.trigger.DbfindTrigger','core.form.FtField','core.form.ConDateField','core.form.YnField',
  9. 'core.form.FtDateField','core.form.FtFindField','core.grid.YnColumn','core.grid.TfColumn','core.form.ConMonthDateField',
  10. 'core.button.Refresh'
  11. ],
  12. refs: [{ref: 'grid', selector: '#vmquerygrid'}],
  13. init:function(){
  14. var me = this;
  15. this.control({
  16. 'erpQueryFormPanel button[name=confirm]': {
  17. },
  18. 'button[name=refresh]':{
  19. click: function(btn){
  20. me.getGrid().setLoading(true);
  21. Ext.Ajax.request({
  22. url: basePath + 'fa/arp/VmQueryController/refreshVmQuery.action',
  23. method: 'GET',
  24. callback: function(opt, s, r) {
  25. me.getGrid().setLoading(false);
  26. var rs = Ext.decode(r.responseText);
  27. if(rs.success) {
  28. //grid 刷新操作
  29. me.query(me.condition);
  30. }else{
  31. //grid 刷新操作
  32. me.query(me.condition);
  33. }
  34. }
  35. });
  36. }
  37. },
  38. 'button[name=query]':{
  39. afterrender: function(btn){
  40. var me = this;
  41. var filter = me.filter = me.createFilterPanel(btn);
  42. filter.show();
  43. },
  44. click: function(btn){
  45. var me = this;
  46. if (me.filter){
  47. me.filter.show();
  48. } else{
  49. var filter = me.filter = me.createFilterPanel(btn);
  50. filter.show();
  51. }
  52. }
  53. }
  54. });
  55. },
  56. createFilterPanel:function(btn){
  57. var me = this;
  58. var filter = Ext.create('Ext.Window', {
  59. id: btn.getId() + '-filter',
  60. style: 'background:#f1f1f1',
  61. title: '筛选条件',
  62. modal:true,
  63. width: 500,
  64. height: 385,
  65. layout: 'column',
  66. defaults: {
  67. margin: '2 2 2 10'
  68. },
  69. items: [{
  70. id: 'vm_yearmonth',
  71. name: 'vm_yearmonth',
  72. xtype: 'conmonthdatefield',
  73. fieldLabel: '期间',
  74. labelWidth: 80,
  75. margin: '10 2 2 10',
  76. columnWidth: .51,
  77. getValue: function() {
  78. if(!Ext.isEmpty(this.value)) {
  79. return {begin: this.firstVal, end: this.secondVal};
  80. }
  81. return null;
  82. },
  83. listeners:{
  84. afterrender:function(cmd){
  85. me.getCurrentYearmonth(cmd);
  86. }
  87. }
  88. },{
  89. xtype: 'dbfindtrigger',
  90. fieldLabel: '币别',
  91. height: 23,
  92. labelWidth: 80,
  93. id: 'vm_currency',
  94. name:'vm_currency',
  95. margin: '10 2 2 10',
  96. flex: 0.2,
  97. columnWidth: .51
  98. },{
  99. fieldLabel: '供应商编码',
  100. labelWidth: 80,
  101. height: 23,
  102. layout: 'hbox',
  103. columnWidth: 1,
  104. xtype: 'fieldcontainer',
  105. id: 'vmq_vendcode',
  106. defaults: {
  107. fieldStyle : "background:#FFFAFA;color:#515151;"
  108. },
  109. items: [{
  110. labelWidth: 35,
  111. xtype: 'dbfindtrigger',
  112. flex: 0.32,
  113. id: 'vm_vendcode',
  114. name: 'vm_vendcode'
  115. },{
  116. xtype: 'textfield',
  117. id: 'vm_vendname',
  118. name: 'vm_vendname',
  119. flex:0.32,
  120. readOnly: true,
  121. fieldStyle: 'background:#f1f1f1;'
  122. }],
  123. getValue: function() {
  124. var a = Ext.getCmp('vm_vendcode');
  125. if(!Ext.isEmpty(a.value)) {
  126. return {vm_vendcode: a.value};
  127. }
  128. return null;
  129. }
  130. },{
  131. xtype: 'checkbox',
  132. id: 'chkumio',
  133. name: 'chkumio',
  134. columnWidth: .51,
  135. boxLabel: '包含未开票未转应付暂估出货'
  136. },{
  137. xtype: 'checkbox',
  138. id: 'chkzerobalance',
  139. name: 'chkzerobalance',
  140. columnWidth: .51,
  141. boxLabel: '余额为零的不显示'
  142. },{
  143. xtype: 'checkbox',
  144. id: 'chknoamount',
  145. name: 'chknoamount',
  146. columnWidth: .51,
  147. boxLabel: '无发生额的不显示'
  148. },{
  149. xtype: 'checkbox',
  150. id: 'chkstatis',
  151. name: 'chkstatis',
  152. checked:true,
  153. columnWidth: .51,
  154. boxLabel: '是否显示汇总数'
  155. }
  156. /*{
  157. xtype: 'checkbox',
  158. id: 'chknopost',
  159. name: 'chknopost',
  160. columnWidth: .51,
  161. boxLabel: '包括未记账发票'
  162. },{
  163. xtype: 'checkbox',
  164. id: 'chknoturn',
  165. name: 'chknoturn',
  166. columnWidth: .51,
  167. boxLabel: '包括已出货未开票信息'
  168. },{
  169. xtype: 'checkbox',
  170. id: 'chkzerobalance',
  171. name: 'chkzerobalance',
  172. columnWidth: .51,
  173. boxLabel: '余额为零的不显示'
  174. },{
  175. xtype: 'checkbox',
  176. id: 'chknoamount',
  177. name: 'chknoamount',
  178. columnWidth: .51,
  179. boxLabel: '无发生额的不显示'
  180. },{
  181. xtype: 'checkbox',
  182. id: 'chkstatis',
  183. name: 'chkstatis',
  184. columnWidth: .51,
  185. boxLabel: '是否显示汇总数'
  186. }*/],
  187. buttonAlign: 'center',
  188. buttons: [{
  189. text: '确定',
  190. width: 60,
  191. cls: 'x-btn-blue',
  192. handler: function(btn) {
  193. var fl = btn.ownerCt.ownerCt;
  194. var con = me.getCondition(fl);
  195. var grid = Ext.getCmp('vmquerygrid');
  196. grid.chkumio = Ext.getCmp('chkumio').getValue();
  197. me.condition = con;
  198. me.query(con);
  199. fl.hide();
  200. }
  201. },{
  202. text: '关闭',
  203. width: 60,
  204. cls: 'x-btn-blue',
  205. handler: function(btn) {
  206. var fl = btn.ownerCt.ownerCt;
  207. fl.hide();
  208. }
  209. }]
  210. });
  211. return filter;
  212. },
  213. getCurrentYearmonth: function(f) {
  214. Ext.Ajax.request({
  215. url: basePath + 'fa/arp/getCurrentYearmonth.action',
  216. method: 'GET',
  217. callback: function(opt, s, r) {
  218. var rs = Ext.decode(r.responseText);
  219. if(rs.exceptionInfo) {
  220. showError(rs.exceptionInfo);
  221. } else if(rs.data) {
  222. f.setValue(rs.data);
  223. }
  224. }
  225. });
  226. },
  227. getCondition: function(pl) {
  228. var r = new Object(),v;
  229. Ext.each(pl.items.items, function(item){
  230. if(item.getValue !== undefined) {
  231. v = item.getValue();
  232. if(!Ext.isEmpty(v)) {
  233. r[item.id] = v;
  234. }
  235. }
  236. });
  237. var tb = Ext.getCmp('gl_info_ym');
  238. if(tb)
  239. tb.updateInfo(r);
  240. return r;
  241. },
  242. query: function(cond) {
  243. var me = this;
  244. cond = cond || me.getCondition(me.filter);
  245. var grid = me.getGrid();
  246. grid.setLoading(true);
  247. Ext.Ajax.request({
  248. url: basePath + 'fa/arp/VmQueryController/getVmQuery.action',
  249. params: {
  250. condition: Ext.encode(cond)
  251. },
  252. callback : function(options,success,response){
  253. grid.setLoading(false);
  254. var res = new Ext.decode(response.responseText);
  255. if(res.exceptionInfo){
  256. showError(res.exceptionInfo);return;
  257. }
  258. if(res.columns){
  259. //data
  260. var data = [];
  261. if(!res.data || res.data.length == 2){
  262. me.GridUtil.add10EmptyData(grid.detno, data);
  263. me.GridUtil.add10EmptyData(grid.detno, data);//添加20条空白数据
  264. } else {
  265. if(res.data instanceof Array) {
  266. data = res.data;
  267. } else {
  268. data = Ext.decode(res.data.replace(/,}/g, '}').replace(/,]/g, ']'));
  269. }
  270. }
  271. //view
  272. if(grid.selModel.views == null){
  273. grid.selModel.views = [];
  274. }
  275. grid.store.loadData(data);
  276. var lockedView = grid.view.lockedView;
  277. if(lockedView){
  278. var tableEl = lockedView.el.child('.x-grid-table');
  279. if(tableEl){
  280. tableEl.dom.style.marginBottom = '9px';
  281. }
  282. }
  283. }
  284. }
  285. });
  286. }
  287. });