ChanceManage.js 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568
  1. Ext.define('erp.view.crm.chance.ChanceManage',{
  2. extend: 'Ext.grid.Panel',
  3. alias: 'widget.erpBatchDealGridPanel',
  4. id: 'batchDealGridPanel',
  5. columnLines : true,
  6. autoScroll : true,
  7. store: [],
  8. region: 'south',
  9. layout : 'fit',
  10. columns: new Array(),
  11. height:height,
  12. GridUtil: Ext.create('erp.util.GridUtil'),
  13. bodyStyle:'background-color:#f1f1f1;',
  14. selModel: Ext.create('Ext.selection.CheckboxModel',{
  15. headerWidth: 0
  16. }),
  17. /*enableLocking:true,*/
  18. /*lockable: true,*/
  19. GridUtil: Ext.create('erp.util.GridUtil'),
  20. BaseUtil: Ext.create('erp.util.BaseUtil'),
  21. plugins: [Ext.create('Ext.grid.plugin.CellEditing', {
  22. clicksToEdit: 1,
  23. listeners:{
  24. 'edit':function(editor,e,Opts){
  25. var record=e.record,data=null,qty=0;
  26. if(record){
  27. data=record.data;
  28. for(var property in data){
  29. if(!/^[a-zA-Z]/.test(property)){
  30. qty+=data[property];
  31. }
  32. }
  33. /* if(qty>(data.ma_qty-data.ma_madeqty)){
  34. showError('排产数不能超过未交数!请重新输入');
  35. e.record.reject();
  36. }*/
  37. }
  38. }
  39. }
  40. })],
  41. /* plugins: [Ext.create('Ext.ux.grid.GridHeaderFilters')],*/
  42. initComponent : function(){
  43. var condition = this.condition;
  44. if(!condition){
  45. var urlCondition = this.BaseUtil.getUrlParam('gridCondition');
  46. urlCondition = urlCondition == null || urlCondition == "null" ? "" : urlCondition;
  47. gridCondition = (gridCondition == null || gridCondition == "null") ? "" : gridCondition;
  48. gridCondition = gridCondition + urlCondition;
  49. gridCondition = gridCondition.replace(/IS/g, "=");
  50. if(gridCondition.search(/!/) != -1){
  51. gridCondition = gridCondition.substring(0, gridCondition.length - 4);
  52. }
  53. condition = gridCondition;
  54. }
  55. var gridParam = {caller: this.caller || caller, condition: condition};
  56. this.getGridColumnsAndStore(this, 'crm/Chance/singleGridPanel.action', gridParam, "");//从后台拿到gridpanel的配置及数据
  57. this.callParent(arguments);
  58. },
  59. loadNewStore:function(grid, url, param, no){
  60. Ext.Ajax.request({//拿到grid的columns
  61. url : basePath + url,
  62. params: param,
  63. method : 'post',
  64. callback : function(options,success,response){
  65. var res = new Ext.decode(response.responseText);
  66. if(res.exceptionInfo){
  67. showError(res.exceptionInfo);return;
  68. }
  69. var data = Ext.decode(res.data.replace(/,}/g, '}').replace(/,]/g, ']'));
  70. var data2 = Ext.decode(res.data2.replace(/,}/g, '}').replace(/,]/g, ']'));
  71. Ext.Array.each(data,function(item){
  72. Ext.Array.each(data2,function(item2){
  73. if(item.ch_code==item2.chcode){
  74. item[item2.name]=item2.result;
  75. }
  76. });
  77. });
  78. //对data 进行处理 必须要先取到主记录的开始时间和结束时间
  79. /*var Map={},arr=new Array();
  80. var len = data.length;
  81. for(var i=0;i<len;i++){
  82. if(Map[data[i].ch_code] == undefined){
  83. var smalldata=data[i];
  84. var startfield=Ext.Date.format(new Date(startdate),'Y-m-d');
  85. var endfield=Ext.Date.format(new Date(enddate),'Y-m-d');
  86. if(new Date(smalldata.ml_begindate)<new Date(startdate)){
  87. smalldata[startfield]=smalldata.ml_mrponhandlack;
  88. }else if(new Date(smalldata.ml_begindate)>new Date(enddate)) smalldata[endfield]=smalldata.ml_mrponhandlack;
  89. else smalldata[smalldata.ml_begindate.substring(0,10)]=smalldata.ml_mrponhandlack;
  90. Map[data[i].ml_makecode] =smalldata;
  91. }else{
  92. var smalldata=Map[data[i].ml_makecode];
  93. smalldata[data[i].ml_begindate.substring(0,10)]=data[i].ml_mrponhandlack;
  94. Map[data[i].ml_makecode]=smalldata;
  95. }
  96. }
  97. for(var property in Map){
  98. arr.push(Map[property]);
  99. }
  100. data=arr;
  101. console.log(data);*/
  102. grid.store.loadData(data);
  103. }
  104. });
  105. },
  106. getGridColumnsAndStore: function(grid, url, param, no){
  107. var me = this;
  108. patchurl=basePath+url;
  109. console.log();
  110. grid.setLoading(true);
  111. Ext.Ajax.request({//拿到grid的columns
  112. url : basePath + url,
  113. params: param,
  114. async:false,
  115. method : 'post',
  116. callback : function(options,success,response){
  117. grid.setLoading(false);
  118. var res = new Ext.decode(response.responseText);
  119. if(res.exceptionInfo){
  120. showError(res.exceptionInfo);return;
  121. }
  122. if(res.columns){
  123. var limits = res.limits, limitArr = new Array();
  124. if(limits != null && limits.length > 0) {//权限外字段
  125. limitArr = Ext.Array.pluck(limits, 'lf_field');
  126. }
  127. /*Ext.each(res.columns, function(column, y){
  128. //power
  129. if(limitArr.length > 0 && Ext.Array.contains(limitArr, column.dataIndex)) {
  130. column.hidden = true;
  131. }
  132. //renderer
  133. me.setRenderer(grid, column);
  134. //logictype
  135. me.setLogicType(grid, column);
  136. });*/
  137. //data
  138. var data = [];
  139. var gridfields=res.fields;
  140. var gridcolumns=res.columns;
  141. var hasadd=false,basecode=null;
  142. if(!res.data || res.data.length == 2){
  143. me.add10EmptyData(grid.detno, data);
  144. me.add10EmptyData(grid.detno, data);//添加20条空白数据
  145. } else {
  146. data = Ext.decode(res.data.replace(/,}/g, '}').replace(/,]/g, ']'));
  147. var data2=Ext.decode(res.data2.replace(/,}/g, '}').replace(/,]/g, ']'));
  148. Ext.Array.each(data,function(item){
  149. Ext.Array.each(data2,function(item2){
  150. if(item.ch_code==item2.chcode){
  151. item[item2.name]=item2.result;
  152. }
  153. basecode=basecode==null?item2.chcode:basecode;
  154. if(item2.chcode==basecode&&hasadd==false){
  155. gridcolumns.push({
  156. readOnly:false,
  157. header:item2.name,
  158. cls: "x-grid-header-1",
  159. dataIndex:item2.name,
  160. width : 60,
  161. align:'right',
  162. format:'0',
  163. renderer:'chancestatus'
  164. });
  165. gridfields.push({
  166. name:item2.name,
  167. type:'string'
  168. });
  169. }
  170. });
  171. hasadd=true;
  172. });
  173. Ext.each(res.columns, function(column, y){
  174. //power
  175. if(limitArr.length > 0 && Ext.Array.contains(limitArr, column.dataIndex)) {
  176. column.hidden = true;
  177. }
  178. //renderer
  179. me.setRenderer(grid, column);
  180. //logictype
  181. me.setLogicType(grid, column);
  182. });
  183. //对data 进行处理 必须要先取到主记录的开始时间和结束时间
  184. /*var Map={},arr=new Array();
  185. var len = data.length;
  186. for(var i=0;i<len;i++){
  187. if(Map[data[i].ml_makecode] == undefined){
  188. var smalldata=data[i];
  189. smalldata[smalldata.ml_begindate.substring(0,10)]=smalldata.ml_mrponhandlack;
  190. Map[data[i].ml_makecode] =smalldata;
  191. }else{
  192. var smalldata=Map[data[i].ml_makecode];
  193. smalldata[data[i].ml_begindate.substring(0,10)]=data[i].ml_mrponhandlack;
  194. smalldata.ml_mrponhandlack+=data[i].ml_mrponhandlack;
  195. Map[data[i].ml_makecode]=smalldata;
  196. }
  197. }
  198. for(var property in Map){
  199. arr.push(Map[property]);
  200. }
  201. data=arr;*/
  202. }
  203. //store
  204. //view
  205. if(grid.selModel.views == null){
  206. grid.selModel.views = [];
  207. }
  208. //dbfind
  209. if(res.dbfinds&&res.dbfinds.length > 0){
  210. grid.dbfinds = res.dbfinds;
  211. }
  212. //toolbar
  213. me.setToolbar(grid, res.columns, res.necessaryField, limitArr);
  214. var store = me.setStore(gridfields, data, grid.groupField, grid.necessaryField);
  215. grid.store=store;
  216. grid.columns=gridcolumns;
  217. var form = Ext.ComponentQuery.query('form')[0];
  218. if(form){
  219. if(form.readOnly){
  220. grid.readOnly = true;//grid不可编辑
  221. }
  222. }
  223. /*var lockedView = grid.view.lockedView;
  224. if(lockedView){
  225. var tableEl = lockedView.el;
  226. console.log(tableEl);
  227. if(tableEl){
  228. tableEl.dom.style.marginBottom = '27px';
  229. }
  230. }*/
  231. } else {
  232. grid.hide();
  233. var form = Ext.ComponentQuery.query('form')[0];
  234. me.updateFormPosition(form);//字段较少时,修改form布局
  235. }
  236. }
  237. });
  238. },
  239. setRenderer: function(grid, column){
  240. if(!column.haveRendered && column.renderer != null && column.renderer != ""){
  241. if(!grid.RenderUtil){
  242. grid.RenderUtil = Ext.create('erp.util.RenderUtil');
  243. }
  244. var renderName = column.renderer;
  245. if(contains(column.renderer, ':', true)){
  246. var args = new Array();
  247. Ext.each(column.renderer.split(':'), function(a, index){
  248. if(index == 0){
  249. renderName = a;
  250. } else {
  251. args.push(a);
  252. }
  253. });
  254. if(!grid.RenderUtil.args[renderName]){
  255. grid.RenderUtil.args[renderName] = new Object();
  256. }
  257. grid.RenderUtil.args[renderName][column.dataIndex] = args;
  258. }
  259. column.renderer = grid.RenderUtil[renderName];
  260. column.haveRendered = true;
  261. }
  262. },
  263. setLogicType: function(grid, column){
  264. var logic = column.logic;
  265. if(logic != null){
  266. if(logic == 'detno'){
  267. grid.detno = column.dataIndex;
  268. column.width = 40;
  269. column.renderer = function(val, meta) {
  270. meta.tdCls = Ext.baseCSSPrefix + 'grid-cell-special';
  271. return val;
  272. };
  273. } else if(logic == 'keyField'){
  274. grid.keyField = column.dataIndex;
  275. } else if(logic == 'mainField'){
  276. grid.mainField = column.dataIndex;
  277. } else if(logic == 'necessaryField'){
  278. grid.necessaryField = column.dataIndex;
  279. if(!grid.necessaryFields){
  280. grid.necessaryFields = new Array();
  281. }
  282. grid.necessaryFields.push(column.dataIndex);
  283. if(!column.haveRendered){
  284. column.renderer = function(val, meta, record, x, y, store, view){
  285. var c = this.columns[y];
  286. if(val != null && val.toString().trim() != ''){
  287. if(c.xtype == 'datecolumn'){
  288. val = Ext.Date.format(val, 'Y-m-d');
  289. }
  290. return val;
  291. } else {
  292. if(c.xtype == 'datecolumn'){
  293. val = '';
  294. }
  295. return '<img src="' + basePath + 'resource/images/icon/need.png" title="必填字段">' +
  296. '<span style="color:blue;padding-left:2px;" title="必填字段">' + val + '</span>';
  297. }
  298. };
  299. }
  300. } else if(logic == 'groupField'){
  301. grid.groupField = column.dataIndex;
  302. }
  303. }
  304. },
  305. setStore: function(fields, data, groupField, necessaryField){
  306. griddata=data;
  307. if(!Ext.isChrome){
  308. Ext.each(fields, function(f){
  309. if(f.type == 'date'){
  310. f.dateFormat = 'Y-m-d H:m:s';
  311. }
  312. });
  313. }
  314. return Ext.create('Ext.data.Store', {
  315. fields: fields,
  316. data: data,
  317. groupField: groupField,
  318. getSum: function(records, field) {
  319. if (arguments.length < 2) {
  320. return 0;
  321. }
  322. var total = 0,
  323. i = 0,
  324. len = records.length;
  325. if(necessaryField) {
  326. for (; i < len; ++i) {//重写getSum,grid在合计时,只合计填写了必要信息的行
  327. var necessary = records[i].get(necessaryField);
  328. if(necessary != null && necessary != ''){
  329. total += records[i].get(field);
  330. }
  331. }
  332. } else {
  333. for (; i < len; ++i) {
  334. total += records[i].get(field);
  335. }
  336. }
  337. return total;
  338. },
  339. getCount: function() {
  340. if(necessaryField) {
  341. var count = 0;
  342. Ext.each(this.data.items, function(item){//重写getCount,grid在合计时,只合计填写了必要信息的行
  343. if(item.data[necessaryField] != null && item.data[necessaryField] != ''){
  344. count++;
  345. }
  346. });
  347. return count;
  348. }
  349. return this.data.items.length;
  350. }
  351. });
  352. },
  353. setToolbar: function(grid, columns, necessaryField, limitArr){
  354. var items = [];
  355. var bool = true;
  356. if(!grid.dockedItems)
  357. return;
  358. Ext.each(grid.dockedItems.items, function(item){
  359. if(item.dock == 'bottom' && item.items){//bbar已存在
  360. bool = false;
  361. }
  362. });
  363. if(bool){
  364. Ext.each(columns, function(column){
  365. if(limitArr.length == 0 || !Ext.Array.contains(limitArr, column.dataIndex)) {
  366. if(column.summaryType == 'sum'){
  367. items.push('-',{
  368. id: column.dataIndex + '_sum',
  369. itemId: column.dataIndex,
  370. xtype: 'tbtext',
  371. text: column.header + '(sum):0'
  372. });
  373. } else if(column.summaryType == 'average') {
  374. items.push('-',{
  375. id: column.dataIndex + '_average',
  376. itemId: column.dataIndex,
  377. xtype: 'tbtext',
  378. text: column.header + '(average):0'
  379. });
  380. } else if(column.summaryType == 'count') {
  381. items.push('-',{
  382. id: column.dataIndex + '_count',
  383. itemId: column.dataIndex,
  384. xtype: 'tbtext',
  385. text: column.header + '(count):0'
  386. });
  387. }
  388. }
  389. if(column.dataIndex == necessaryField){
  390. column.renderer = function(val){
  391. if(val != null && val.toString().trim() != ''){
  392. return val;
  393. } else {
  394. return '<img src="' + basePath + 'resource/images/icon/need.png" title="必填字段">' +
  395. '<span style="color:blue;padding-left:2px;" title="必填字段">' + val + '</span>';
  396. }
  397. };
  398. }
  399. });
  400. grid.addDocked({
  401. xtype: 'toolbar',
  402. dock: 'bottom',
  403. items: items
  404. });
  405. } else {
  406. var bars = Ext.ComponentQuery.query('erpToolbar');
  407. if(bars.length > 0){
  408. Ext.each(columns, function(column){
  409. if(column.summaryType == 'sum'){
  410. bars[0].add('-');
  411. bars[0].add({
  412. id: column.dataIndex + '_sum',
  413. itemId: column.dataIndex,
  414. xtype: 'tbtext',
  415. text: column.header + '(sum):0'
  416. });
  417. } else if(column.summaryType == 'average') {
  418. bars[0].add('-');
  419. bars[0].add({
  420. id: column.dataIndex + '_average',
  421. itemId: column.dataIndex,
  422. xtype: 'tbtext',
  423. text: column.header + '(average):0'
  424. });
  425. } else if(column.summaryType == 'count') {
  426. bars[0].add('-');
  427. bars[0].add({
  428. id: column.dataIndex + '_count',
  429. itemId: column.dataIndex,
  430. xtype: 'tbtext',
  431. text: column.header + '(count):0'
  432. });
  433. }
  434. });
  435. }
  436. }
  437. },
  438. add10EmptyData: function(detno, data){
  439. if(detno){
  440. var index = data.length == 0 ? 0 : Number(data[data.length-1][detno]);
  441. for(var i=0;i<10;i++){
  442. var o = new Object();
  443. o[detno] = index + i + 1;
  444. data.push(o);
  445. }
  446. } else {
  447. for(var i=0;i<10;i++){
  448. var o = new Object();
  449. data.push(o);
  450. }
  451. }
  452. },
  453. checkGridDirty: function(grid){
  454. var s = grid.getStore().data.items;//获取store里面的数据
  455. var msg = '';
  456. for(var i=0;i<s.length;i++){
  457. if(s[i].dirty){//明细行被修改过哦
  458. msg = msg + '第' + (i+1) + '行:';
  459. var changed = Ext.Object.getKeys(s[i].modified);//拿到被修改了的字段
  460. for(var j = 0;j < changed.length;j++){
  461. Ext.each(grid.columns, function(c, index){
  462. if(index == 0){
  463. return;
  464. }
  465. if(c.dataIndex == changed[j] && c.logic != 'ignore'){//由字段dataindex匹配其text
  466. msg = msg + '<font color=blue>' + c.text + '</font>&nbsp;';
  467. }
  468. });
  469. }
  470. msg = msg + ";";
  471. }
  472. }
  473. if(msg != '' && msg != ';'){//明细行被修改过哦
  474. msg = "明细行<font color=green>" + msg.substring(0, msg.length-1) + "</font>已编辑过";
  475. }
  476. return msg;
  477. },
  478. getGridStore: function(grid){
  479. if(grid == null){
  480. grid = Ext.getCmp('grid');
  481. }
  482. var me = this,
  483. jsonGridData = new Array();
  484. var form = Ext.getCmp('form');
  485. var s = grid.getStore().data.items;//获取store里面的数据
  486. console.log(s);
  487. var dd;
  488. for(var i=0;i<s.length;i++){//将grid里面各行的数据获取并拼成jsonGridData
  489. var data = s[i].data;
  490. dd = new Object();
  491. if(s[i].dirty && !me.isBlank(grid, data)){
  492. Ext.each(gridcolumns, function(c){
  493. console.log(c.logic);
  494. if(c.logic != 'ignore'){//只需显示,无需后台操作的字段,自动略去
  495. if(c.dataIndex=='wd_date'){
  496. Ext.Array.each(c.columns,function(column){
  497. dd[column.dataIndex]=data[column.dataIndex];
  498. });
  499. }else {
  500. if(c.xtype == 'datecolumn'){
  501. c.format = c.format || 'Y-m-d';
  502. if(Ext.isDate(data[c.dataIndex])){
  503. dd[c.dataIndex] = Ext.Date.format(data[c.dataIndex], c.format);
  504. } else {
  505. if(c.editor){
  506. dd[c.dataIndex] = Ext.Date.format(new Date(), c.format);//如果用户没输入日期,或输入有误,就给个默认日期,
  507. }
  508. }
  509. } else if(c.xtype == 'datetimecolumn'){
  510. if(Ext.isDate(data[c.dataIndex])){
  511. dd[c.dataIndex] = Ext.Date.format(data[c.dataIndex], 'Y-m-d H:i:s');//在这里把GMT日期转化成Y-m-d H:i:s格式日期
  512. } else {
  513. if(c.editor){
  514. dd[c.dataIndex] = Ext.Date.format(new Date(), 'Y-m-d H:i:s');//默认日期,
  515. }
  516. }
  517. } else if(c.xtype == 'numbercolumn'){//赋个默认值0吧,不然不好保存
  518. if(data[c.dataIndex] == null || data[c.dataIndex] == ''){
  519. dd[c.dataIndex] = '0';//也可以从data里面去掉这些字段
  520. } else {
  521. dd[c.dataIndex] = s[i].data[c.dataIndex];
  522. }
  523. } else {
  524. dd[c.dataIndex] = s[i].data[c.dataIndex];
  525. }
  526. }
  527. }
  528. });
  529. if(grid.mainField && form && form.keyField){//例如,将pu_id的值赋给pd_puid
  530. dd[grid.mainField] = Ext.getCmp(form.keyField).value;
  531. }
  532. jsonGridData.push(Ext.JSON.encode(dd));
  533. }
  534. }
  535. return jsonGridData;
  536. },
  537. isBlank: function(grid, data) {
  538. var ff = grid.necessaryFields,bool = true;
  539. if(ff) {
  540. Ext.each(ff, function(f) {
  541. if(!Ext.isEmpty(data[f]) && data[f] != 0) {
  542. bool = false;
  543. }else {
  544. bool=true;
  545. return
  546. }
  547. });
  548. } else {
  549. if(!grid.necessaryField || !Ext.isEmpty(data[grid.necessaryField])) {
  550. bool = false;
  551. }
  552. }
  553. return bool;
  554. },
  555. });