GridPanel2.js 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306
  1. Ext.require([
  2. 'erp.util.*'
  3. ]);
  4. Ext.define('erp.view.common.datalist.GridPanel2',{
  5. extend: 'Ext.grid.Panel',
  6. alias: 'widget.erpDatalistGridPanel2',
  7. layout : 'fit',
  8. emptyText : '无数据',
  9. columnLines : true,
  10. autoScroll : true,
  11. store: [],
  12. condition1:'',
  13. keyF:'',
  14. ur:'',
  15. page:'',
  16. codeF:'',
  17. pagesize:'',
  18. buttons: [
  19. {
  20. text: '编辑',
  21. handler:function(){
  22. if(!this.up('grid').getSelectionModel().selected.items[0]){
  23. alert("请选择要编辑的行");
  24. return;
  25. }
  26. var data=this.up('grid').getSelectionModel().selected.items[0].data;
  27. var s=this.up('grid').ur+'?formCondition='+this.up('grid').keyF+'IS'+data[this.up('grid').keyF];
  28. var html='<iframe width=100% height=100% src="'+s+'"/>';
  29. var grid=this.up('grid');
  30. var win=new Ext.window.Window({
  31. height:400,
  32. width:800,
  33. modal:true,
  34. listeners : {
  35. close : function(){
  36. grid.getColumnsAndStore();
  37. }
  38. },
  39. html:html});
  40. win.show();
  41. }
  42. },{
  43. text: '添加',
  44. handler:function(){
  45. var grid=this.up('grid');
  46. var u='';
  47. if(/\?/.test(grid.ur)){
  48. u+=grid.ur+'&dbfind='+grid.condition1;
  49. }else{
  50. u+=grid.ur+'?dbfind='+grid.condition1;
  51. }
  52. var win=new Ext.window.Window({
  53. height:400,
  54. width:800,
  55. modal:true,
  56. listeners : {
  57. close : function(){
  58. grid.getColumnsAndStore();
  59. }
  60. },
  61. html:'<iframe id="iframe_add" width=100% height=100% src="'+u+'"/>'});
  62. win.show();
  63. }
  64. }
  65. ],
  66. columns: new Array(),
  67. bodyStyle:'background-color:#f1f1f1;',
  68. BaseUtil: Ext.create('erp.util.BaseUtil'),
  69. //RenderUtil:Ext.create('erp.util.RenderUtil'),
  70. initComponent : function(){
  71. var con=this.BaseUtil.getUrlParam('formCondition');
  72. if(con){
  73. if(/IS/g.test(con)){//datalist页面跳转的参数是带'IS'的,query页面跳转的参数是用'='的
  74. if(/id/g.test(this.codeF)){
  75. con=this.codeF+'='+con.split('IS')[1];
  76. }else{
  77. con=this.codeF+"='"+con.split('IS')[1]+"'";
  78. }
  79. }else{
  80. if(/id/g.test(this.codeF)){
  81. con=this.codeF+'='+con.split('=')[1];
  82. }else{
  83. con=this.codeF+"='"+con.split('=')[1]+"'";
  84. }
  85. }
  86. }
  87. this.condition1=this.condition1==''?con:this.condition1;
  88. this.defaultCondition = this.condition1;//固定条件;从url里面获取
  89. this.caller=this.caller|| this.BaseUtil.getUrlParam('whoami');
  90. this.getCount(this.caller, this.condition1);
  91. this.callParent(arguments);
  92. this.addEvents({
  93. keydown: true
  94. });
  95. } ,
  96. getColumnsAndStore: function(c, d, g, s){
  97. c = c || this.caller;
  98. d = d || this.condition1;
  99. g = g || this.page;
  100. s = s || this.pageSize;
  101. var me = this;
  102. var f = d;
  103. if(me.filterCondition){
  104. if(d == null || d == ''){
  105. f = me.filterCondition;
  106. } else {
  107. f += ' AND ' + me.filterCondition;
  108. }
  109. }
  110. this.setLoading(true);//loading...
  111. Ext.Ajax.request({//拿到grid的columns
  112. url : basePath + 'common/datalist.action',
  113. params: {
  114. caller: c,
  115. condition: f,
  116. page: g,
  117. pageSize: s
  118. },
  119. method : 'post',
  120. callback : function(options,success,response){
  121. me.setLoading(false);
  122. var res = new Ext.decode(response.responseText);
  123. if(res.exception || res.exceptionInfo){
  124. showError(res.exceptionInfo);
  125. return;
  126. }
  127. var data = res.data != null ? Ext.decode(res.data.replace(/,}/g, '}').replace(/,]/g, ']')) : [];//一定要去掉多余逗号,ie对此很敏感
  128. if(me.columns && me.columns.length > 2){
  129. me.store.loadData(data);
  130. if(me.lastSelected && me.lastSelected.length > 0){//grid刷新后,仍然选中上次选中的record
  131. Ext.each(me.store.data.items, function(item){
  132. if(item.data[keyField] == me.lastSelected[0].data[keyField]){
  133. me.selModel.select(item);
  134. }
  135. });
  136. }
  137. } else {
  138. if(!Ext.isChrome){
  139. Ext.each(res.fields, function(f){
  140. if(f.type == 'date'){
  141. f.dateFormat = 'Y-m-d H:m:s';
  142. }
  143. });
  144. }
  145. var store = Ext.create('Ext.data.Store', {
  146. fields: res.fields,
  147. data: data,
  148. //模糊查询的结果在Ext.Array.filter()方法之后,部分数据被过滤掉,设置为false不调用该方法
  149. //yingp
  150. filterOnLoad: false
  151. });
  152. //处理render
  153. var width=0;
  154. var grid = this;
  155. Ext.Array.each(res.columns, function(column, y) {
  156. width+=column.width;
  157. if(!column.haveRendered && column.renderer != null && column.renderer != ""){
  158. if(!grid.RenderUtil){
  159. grid.RenderUtil = Ext.create('erp.util.RenderUtil');
  160. }
  161. var renderName = column.renderer;
  162. if(contains(column.renderer, ':', true)){
  163. var args = new Array();
  164. Ext.each(column.renderer.split(':'), function(a, index){
  165. if(index == 0){
  166. renderName = a;
  167. } else {
  168. args.push(a);
  169. }
  170. });
  171. if(!grid.RenderUtil.args[renderName]){
  172. grid.RenderUtil.args[renderName] = new Object();
  173. }
  174. grid.RenderUtil.args[renderName][column.dataIndex] = args;
  175. //这里只能用column.dataIndex来标志,不能用x,y,index等,
  176. //grid在render时,checkbox占一列
  177. }
  178. column.renderer = grid.RenderUtil[renderName];
  179. column.haveRendered = true;
  180. }
  181. });
  182. if(width<grid.innerWidth){
  183. Ext.Array.each(res.columns, function(column) {
  184. column.width=column.width*grid.innerWidth/width;
  185. });
  186. }
  187. me.reconfigure(store, res.columns);//用这个方法每次都会add一个checkbox列
  188. }
  189. //拿到datalist对应的单表的关键词
  190. keyField = res.keyField;//form表主键字段
  191. pfField = res.pfField;//grid表主键字段
  192. url = basePath + res.url;//grid行选择之后iframe嵌入的页面链接
  193. me.ur=url;
  194. relative = res.relative;
  195. }
  196. });
  197. },
  198. getCount: function(c, d){
  199. c = c || caller;
  200. d = d || condition;
  201. var me = this;
  202. var f = d;
  203. if(me.filterCondition){
  204. if(d == null || d == ''){
  205. f = me.filterCondition;
  206. } else {
  207. f += ' AND ' + me.filterCondition;
  208. }
  209. }
  210. Ext.Ajax.request({//拿到grid的数据总数count
  211. url : basePath + '/common/datalistCount.action',
  212. params: {
  213. caller: c,
  214. condition: f
  215. },
  216. method : 'post',
  217. callback : function(options,success,response){
  218. var res = new Ext.decode(response.responseText);
  219. if(res.exception || res.exceptionInfo){
  220. showError(res.exceptionInfo);
  221. return;
  222. }
  223. dataCount = res.count;
  224. me.getColumnsAndStore(c, d);
  225. }
  226. });
  227. },
  228. listeners: {
  229. 'headerfiltersapply': function(grid, filters) {
  230. if(this.allowFilter){
  231. var condition = null;
  232. for(var fn in filters){
  233. var value = filters[fn],f = grid.getHeaderFilterField(fn);
  234. if(!Ext.isEmpty(value)){
  235. if(f.filtertype) {
  236. if (f.filtertype == 'numberfield') {
  237. value = fn + "=" + value + " ";
  238. }
  239. } else {
  240. if(Ext.isDate(value)){
  241. value = Ext.Date.toString(value);
  242. value = fn + "=to_date('" + value + "','yyyy-MM-dd') ";
  243. } else {
  244. var exp_t = /^(\d{4})\-(\d{2})\-(\d{2}) (\d{2}):(\d{2}):(\d{2})$/,
  245. exp_d = /^(\d{4})\-(\d{2})\-(\d{2})$/;
  246. if(exp_d.test(value)){
  247. value = fn + "=to_date('" + value + "','yyyy-MM-dd') ";
  248. } else if(exp_t.test(value)){
  249. value = fn + "=to_date('" + value + "','yyyy-MM-dd HH24:mi:ss') ";
  250. } else{
  251. value = fn + " LIKE '%" + value + "%' ";
  252. }
  253. }
  254. }
  255. if(condition == null){
  256. condition = value;
  257. } else {
  258. condition = condition + " AND " + value;
  259. }
  260. }
  261. }
  262. this.filterCondition = condition;
  263. page = 1;
  264. this.getCount();
  265. } else {
  266. this.allowFilter = true;
  267. }
  268. return false;
  269. }
  270. },
  271. reconfigure: function(store, columns){
  272. //改写reconfigure方法
  273. var d = this.headerCt;
  274. if (this.columns.length <= 1 && columns) {//this.columns.length > 1表示grid的columns已存在,没必要remove再add
  275. d.suspendLayout = true;
  276. d.removeAll();
  277. d.add(columns);
  278. }
  279. if (store) {
  280. this.bindStore(store);
  281. } else {
  282. this.getView().refresh();
  283. }
  284. if (columns) {
  285. d.suspendLayout = false;
  286. this.forceComponentLayout();
  287. }
  288. this.fireEvent("reconfigure", this);
  289. },
  290. getCondition: function(){
  291. var condition = '';
  292. if(!Ext.isEmpty(this.defaultCondition)) {
  293. condition = this.defaultCondition;
  294. }
  295. if(!Ext.isEmpty(this.filterCondition)) {
  296. if(condition == '') {
  297. condition = this.filterCondition;
  298. } else {
  299. condition = '(' + condition + ') AND (' + this.filterCondition + ')';
  300. }
  301. }
  302. return condition.replace(/=/g, '%3D');
  303. }
  304. });