MultiDbfindTrigger.js 8.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294
  1. /**
  2. * multi dbfind trigger
  3. *
  4. */
  5. Ext.define('erp.view.core.trigger.MultiDbfindTrigger', {
  6. extend: 'Ext.form.field.Trigger',
  7. alias: 'widget.multidbfindtrigger',
  8. triggerCls: 'x-form-search-trigger',
  9. initComponent: function() {
  10. var me = this;
  11. me.callParent(arguments);
  12. if(me.clearable) {
  13. me.trigger2Cls = 'x-form-clear-trigger';
  14. if(!me.onTrigger2Click) {
  15. me.onTrigger2Click = function(){
  16. this.setValue(null);
  17. };
  18. }
  19. }
  20. },
  21. onTriggerClick: function() {
  22. this.setFieldStyle('background:#C6E2FF;');
  23. var trigger = this,// 放大镜所在
  24. key = this.name,// name属性
  25. dbfind = '',// 需要dbfind的表和字段
  26. dbBaseCondition = '',
  27. dbCondition = '',
  28. dbGridCondition = '',
  29. dbKey = this.dbKey,
  30. mappingKey = this.mappingKey,
  31. mappinggirdKey = this.mappinggirdKey,
  32. gridKey = this.gridKey,
  33. gridErrorMessage = this.gridErrorMessage;
  34. window.onTriggerClick = this.id;
  35. // 存在查询条件的字段
  36. if(dbKey){
  37. var dbKeyValue = Ext.getCmp(dbKey).value;
  38. if(dbKeyValue){
  39. dbCondition = mappingKey + " IS '" + dbKeyValue + "'";
  40. } else {
  41. showError(this.dbMessage);
  42. return
  43. }
  44. }
  45. if(gridKey){
  46. var gridKeys = gridKey.split('|');
  47. var mappinggirdKeys;
  48. var gridErrorMessages;
  49. if(mappinggirdKey){
  50. mappinggirdKeys = mappinggirdKey.split('|');
  51. gridErrorMessages = this.gridErrorMessage.split('|');
  52. }
  53. for(var i=0;i<gridKeys.length;i++){
  54. var gridkeyvalue = Ext.getCmp(gridKeys[i]).value;
  55. if(i==0){
  56. if(gridkeyvalue){
  57. dbGridCondition = mappinggirdKeys[i] + " IS '"+gridkeyvalue+"' ";
  58. }else{
  59. showError(gridErrorMessages[i]);
  60. return
  61. }
  62. }else{
  63. if(gridkeyvalue){
  64. dbGridCondition =dbGridCondition+" AND "+ mappinggirdKeys[i] + " IS '"+gridkeyvalue+"' ";
  65. }else{
  66. showError(gridErrorMessages[i]);
  67. return
  68. }
  69. }
  70. }
  71. // console.log(gridKey);
  72. // var gridkeyvalue = Ext.getCmp(gridKey).value;
  73. // if(gridkeyvalue){
  74. // dbGridCondition = this.mappinggirdKey + " IS '" + gridkeyvalue + "'";
  75. // } else {
  76. // showError(this.gridErrorMessage);
  77. // return
  78. // }
  79. }
  80. if(this.dbBaseCondition){
  81. dbBaseCondition = this.dbBaseCondition;
  82. }
  83. if(!trigger.ownerCt){// 如果是grid的dbfind
  84. var grid = Ext.ComponentQuery.query('gridpanel');
  85. Ext.Array.each(grid, function(g, index){
  86. Ext.Array.each(g.columns,function(column){
  87. if(column.dataIndex == key) {
  88. dbfind = column.dbfind;
  89. trigger.owner = g;
  90. }
  91. });
  92. });
  93. if(trigger.owner.editingPlugin.activeEditor.field.id == trigger.id) {
  94. trigger.record = trigger.owner.editingPlugin.activeRecord;
  95. } else {
  96. trigger.record = trigger.owner.selModel.lastSelected;
  97. }
  98. }
  99. var keyValue = this.value;// 当前值
  100. keyValue = keyValue == null ? '' : keyValue;
  101. var dbwin = this.createWin();
  102. dbwin.show();
  103. if(this.multistore){
  104. this.showButtons();
  105. } else {
  106. trigger.multiValue = new Object();
  107. var iframe = dbwin.getEl().down('iframe');
  108. if(!iframe) {
  109. dbwin.add({
  110. tag : 'iframe',
  111. frame : true,
  112. anchor : '100% 100%',
  113. layout : 'fit',
  114. html : '<iframe src="#" height="100%" width="100%" frameborder="0" scrolling="auto"></iframe>'
  115. });
  116. iframe = dbwin.getEl().down('iframe');
  117. }
  118. iframe.dom.src = basePath + 'jsps/common/multidbfind.jsp?key=' +
  119. key + "&dbfind=" + dbfind +
  120. "&dbGridCondition=" + dbGridCondition + "&dbCondition=" + dbCondition +
  121. "&dbBaseCondition=" + dbBaseCondition + "&keyValue=&caller=" + caller +
  122. "&trigger=" + trigger.id;
  123. }
  124. },
  125. createWin: function() {
  126. var trigger = this;
  127. this.win = Ext.create('Ext.Window', {
  128. title: '查找',
  129. height: "100%",
  130. width: "80%",
  131. maximizable : true,
  132. buttonAlign : 'center',
  133. layout : 'anchor',
  134. items: [],
  135. dbtriggr: trigger,
  136. closeAction: 'hide',
  137. buttons : [{
  138. text : '确 认',
  139. iconCls: 'x-button-icon-save',
  140. id:'mutidbaffirm',
  141. cls: 'x-btn-gray',
  142. handler : function(){
  143. trigger.onConfirm();
  144. }
  145. },{
  146. text : '关 闭',
  147. iconCls: 'x-button-icon-close',
  148. cls: 'x-btn-gray',
  149. handler : function(btn){
  150. btn.ownerCt.ownerCt.close();
  151. }
  152. }]
  153. });
  154. return this.win;
  155. },
  156. showButtons: function() {
  157. var value = this.value, dbwin = this.win;
  158. dbwin.add({
  159. id: 'multigrid',
  160. xtype: 'gridpanel',
  161. height: '100%',
  162. autoScroll: true,
  163. columnLines : true,
  164. columns: [{
  165. header: 'Button',
  166. dataIndex: 'display' ,
  167. flex: 1
  168. }, {
  169. header: 'name',
  170. dataIndex: 'value',
  171. flex: 1
  172. }],
  173. store: this.multistore,
  174. selModel: Ext.create('Ext.selection.CheckboxModel',{
  175. ignoreRightMouseSelection : false,
  176. listeners:{
  177. selectionchange:function(selectionModel, selected, options){
  178. }
  179. },
  180. onRowMouseDown: function(view, record, item, index, e) {//改写的onRowMouseDown方法
  181. view.el.focus();
  182. var me = Ext.getCmp('multigrid');
  183. var checkbox = item.childNodes[0].childNodes[0].childNodes[0];
  184. if(contains(value, record.data['value'], true)){
  185. me.selModel.deselect(record);
  186. me.multiselected = me.multiselected.replace('#' + record.data['value'], '');
  187. value = value.replace(record.data['value'], '');
  188. checkbox.setAttribute('class','x-grid-row-checker');
  189. } else {
  190. if(checkbox.getAttribute('class') == 'x-grid-row-checker'){
  191. checkbox.setAttribute('class','x-grid-row-checker-checked');//只是修改了其样式,并没有将record加到selModel里面
  192. me.multiselected = me.multiselected + '#' + record.data['value'];
  193. } else {
  194. me.multiselected = me.multiselected.replace('#' + record.data['value'], '');
  195. checkbox.setAttribute('class','x-grid-row-checker');
  196. }
  197. }
  198. }
  199. }),
  200. listeners: {
  201. afterrender: function(){
  202. var me = this;
  203. var selected = new Array();
  204. me.multiselected = '';
  205. Ext.each(me.store.data.items, function(){
  206. if(contains(value, this.data['value'], true)){
  207. selected.push(this);
  208. me.multiselected = me.multiselected + '#' + this.data['value'];
  209. }
  210. });
  211. me.selModel.select(selected);
  212. }
  213. }
  214. });
  215. },
  216. onConfirm: function() {
  217. var trigger = this;
  218. if(trigger.multistore){
  219. var me = Ext.getCmp('multigrid');
  220. trigger.setValue(me.multiselected.substring(1));
  221. this.win.close();
  222. } else {
  223. if(!trigger.ownerCt){
  224. var grid = trigger.owner;
  225. var record = grid.lastSelectedRecord || trigger.record || grid.getSelectionModel().selected.items[0] || grid.selModel.lastSelected;//detailgrid里面selected
  226. // var record = grid.selModel.lastSelected;
  227. Ext.each(trigger.multiValue, function(item, index){
  228. if(index > 0){
  229. record = trigger.next(grid, record);
  230. }
  231. if(record) {
  232. if(item && item.data){
  233. Ext.Array.each(Ext.Object.getKeys(item.data), function(k){
  234. Ext.Array.each(grid.dbfinds,function(ds){
  235. if(Ext.isEmpty(ds.trigger) || ds.trigger == trigger.name) {
  236. if(Ext.Array.contains(ds.dbGridField.split(';'), k)) {
  237. record.set(ds.field, item.data[k]);
  238. }
  239. }
  240. });
  241. });
  242. }
  243. }
  244. });
  245. } else {
  246. var k = Ext.Object.getKeys(trigger.multiValue),cp;
  247. Ext.each(k, function(key){
  248. cp = Ext.getCmp(key);
  249. if(cp.setValue !== undefined)
  250. cp.setValue(trigger.multiValue[key]);
  251. });
  252. trigger.setValue(trigger.multiValue[trigger.name]);
  253. }
  254. trigger.fireEvent('aftertrigger', trigger, trigger.multiRecords);
  255. this.win.close();
  256. }
  257. },
  258. /**
  259. * 递归grid的下一条
  260. */
  261. next: function(grid, record){
  262. record = record || grid.selModel.lastSelected;
  263. if(record){
  264. //递归查找下一条,并取到数据
  265. var store = grid.store, idx = store.indexOf(record),
  266. d = store.getAt(idx + 1), len = store.data.items.length;
  267. if(d){
  268. return d;
  269. } else {
  270. if(idx + 1 < len){
  271. this.next(grid, d);
  272. } else {
  273. if (grid.GridUtil) {
  274. grid.GridUtil.add10EmptyItems(grid);
  275. return this.next(grid, record);
  276. }
  277. }
  278. }
  279. }
  280. }
  281. });