123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278 |
- Ext.define('erp.view.ma.MyDetail',{
- extend: 'Ext.grid.Panel',
- alias: 'widget.mydetail',
- layout : 'fit',
- emptyText : $I18N.common.grid.emptyText,
- columnLines : true,
- autoScroll : true,
- store: [],
- columns: [],
- plugins: Ext.create('Ext.grid.plugin.CellEditing', {
- clicksToEdit: 1
- }),
- GridUtil: Ext.create('erp.util.GridUtil'),
- bbar: {
- xtype: 'erpToolbar',
- allowExtraButtons: false
- },
- initComponent : function(){
- this.whoami = this.whoami || getUrlParam('whoami');
- this.getGridColumnsAndStore();
- this.callParent(arguments);
- },
- detno: 'dg_sequence',
- caller: 'DetailGrid',
- getGridColumnsAndStore: function(){
- if(em_type!='admin'){
- showError('ERR_POWER_025:您没有修改页面配置的权限!');return;
- }
- var grid = this;
- var main = parent.Ext.getCmp("content-panel");
- if(!main)
- main = parent.parent.Ext.getCmp("content-panel");
- if(main){
- main.getActiveTab().setLoading(true);//loading...
- }
- Ext.Ajax.request({//拿到grid的columns
- url : basePath + 'common/singleGridPanel.action',
- async: false,
- params: {
- caller: grid.caller,
- condition: "dg_caller='" + grid.whoami + "'",
- _m: 0
- },
- method : 'post',
- callback : function(options,success,response){
- if(main){
- main.getActiveTab().setLoading(false);
- }
- var res = new Ext.decode(response.responseText);
- if(res.exceptionInfo){
- showError(res.exceptionInfo);return;
- }
- if(res.columns){
- grid.columns = res.columns;
- grid.fields = res.fields;
- grid.columns.push({
- xtype: 'checkcolumn',
- text: '配置',
- width: 60,
- dataIndex: 'deploy',
- cls: "x-grid-header-1",
- locked: true,
- editor: {
- xtype: 'checkbox',
- cls: "x-grid-checkheader-editor"
- }
- });
- grid.fields.push({name: 'deploy', type: 'bool'});
- //renderer
- grid.getRenderer();
- var data = Ext.decode(res.data.replace(/,}/g, '}').replace(/,]/g, ']'));
- Ext.each(data, function(d){
- d.deploy = true;
- d.dg_modify = d.dg_modify == 'T';
- });
- grid.data = data;
- if(res.dbfinds.length > 0){
- grid.dbfinds = res.dbfinds;
- }
- //取数据字典配置
- if(data && data.length > 0) {
- var tab = data[0].dg_table;
- if(tab) {
- grid.getDataDictionaryData(tab.split(' ')[0]);
- }
- }
- grid.reconfigureGrid();
- }
- }
- });
- },
- getRenderer: function(){
- var grid = this;
- Ext.each(grid.columns, function(column, y){
- //logictype
- var logic = column.logic;
- if(logic != null){
- if(logic == 'detno'){
- grid.detno = column.dataIndex;
- } else if(logic == 'keyField'){
- grid.keyField = column.dataIndex;
- } else if(logic == 'mainField'){
- grid.mainField = column.dataIndex;
- } else if(logic == 'necessaryField'){
- grid.necessaryField = column.dataIndex;
- if(!grid.necessaryFields){
- grid.necessaryFields = new Array();
- }
- grid.necessaryFields.push(column.dataIndex);
- if(!column.haveRendered){
- column.renderer = function(val, meta, item){
- if(item.data['dg_id'] != null && item.data['dg_id'] != '' && item.data['dg_id'] != '0'
- && item.data['dg_id'] != 0) {
- return '<img src="' + basePath + 'resource/images/renderer/finishrecord.png">' +
- '<span style="color:blue;" title="已配置">' + val + '</span>';
- } else {
- return '<img src="' + basePath + 'resource/images/renderer/important.png">' +
- '<span style="color:red;" title="未配置">' + val + '</span>';
- }
- };
- }
- } else if(logic == 'groupField'){
- grid.groupField = column.dataIndex;
- }
- }
- });
- },
- reconfigureGrid: function(){
- var grid = this;
- grid.store = Ext.create('Ext.data.Store', {
- fields: grid.fields,
- data: grid.data,
- sorters: [{
- property: 'dg_sequence'
- }]
- });
- },
- getDataDictionaryData: function(tablename){
- var me = this, mGrid = Ext.getCmp('grid');
- if(mGrid && mGrid.dictionary && mGrid.dictionary[tablename]) {
- me.parseDictionary(mGrid.dictionary[tablename]);
- } else {
- Ext.Ajax.request({
- url : basePath + 'ma/getDataDictionary.action',
- async: false,
- params: {
- table: tablename
- },
- method : 'post',
- callback : function(options,success,response){
- var res = new Ext.decode(response.responseText);
- if(res.exceptionInfo){
- showError(res.exceptionInfo);return;
- } else if(res.success) {
- me.parseDictionary(res.datadictionary);
- }
- }
- });
- }
- },
- parseDictionary: function(dictionary) {
- var me = this, data = this.data;
- //取Max(序号)
- var det = Ext.Array.max(Ext.Array.pluck(data, me.detno));
- //data里面包含的字段
- var sel = [];
- Ext.Array.each(data, function(d){
- sel.push(d.dg_field.toLowerCase());
- });
- var o = null;
- Ext.each(dictionary, function(d, index){
- //将DataDictionary的数据转化成FormDetail数据
- if(sel.indexOf(d.column_name) == -1){
- o = new Object();
- o.dg_table = d.table_name;
- o.dg_field = d.column_name;
- o.dg_caption = d.comments;
- o.dg_captionfan = d.comments;
- o.dg_captionen = d.comments;
- o.dg_editable = false;
- o.dg_width = 80;
- o.dg_dbbutton = '0';
- o.dg_visible = true;
- o.deploy = false;
- o.dg_caller = me.whoami;
- if(contains(d.data_type, 'VARCHAR2', true)){
- o.dg_type = 'text';
- o.dg_maxlength=d.data_length;
- } else if(contains(d.data_type, 'TIMESTAMP', true)){
- o.dg_type = 'datetimecolumn';
- } else if(d.data_type == 'DATE'){
- o.dg_type = 'datecolumn';
- } else if(d.data_type == 'NUMBER'){
- o.dg_type = 'numbercolumn';
- } else if(d.data_type == 'FLOAT'){
- o.dg_type = 'floatcolumn';
- } else {
- o.dg_type = 'text';
- o.dg_maxlength=d.data_length||100;
- }
- o.dg_sequence = ++det;
- data.push(o);
- }
- });
- me.dictionary = dictionary;
- },
- getDeleted: function(){
- var grid = this,items = grid.store.data.items,key = grid.keyField,deleted = new Array(),d = null;
- Ext.each(items, function(item){
- d = item.data;
- if(item.dirty && !Ext.isEmpty(d[key]) && d['deploy'] == false) {
- deleted.push(grid.removeKey(d, 'deploy'));
- }
- });
- return deleted;
- },
- getAdded: function(){
- var grid = this,items = grid.store.data.items,key = grid.keyField,added = new Array(),d = null;
- Ext.each(items, function(item){
- d = item.data;
- if(item.dirty && d[key] == 0 && d['deploy'] == true) {
- added.push(grid.removeKey(d, 'deploy'));
- }
- });
- return added;
- },
- getUpdated: function(){
- var grid = this,items = grid.store.data.items,key = grid.keyField,updated = new Array(),d = null;
- Ext.each(items, function(item){
- d = item.data;
- if(item.dirty && !Ext.isEmpty(d[key]) && d[key] != 0 && d['deploy'] == true) {
- updated.push(grid.removeKey(d, 'deploy'));
- }
- });
- return updated;
- },
- removeKey: function(d, key){
- var a = new Object(),keys = Ext.Object.getKeys(d);
- Ext.each(keys, function(k){
- if(k != key) {
- a[k] = d[k];
- if(k == 'dg_modify') {
- a[k] = a[k] ? 'T' : 'F';
- }
- if(k == 'dg_editable' || k == 'dg_visible') {
- a[k] = a[k] ? -1 : 0;
- }
- if(k == 'dg_check')
- a[k] = a[k] ? 1 : 0;
- }
- });
- return a;
- },
- getChange: function(){
- var grid = this,items = grid.store.data.items,key = grid.keyField,
- added = new Array(),updated = new Array(),deleted = new Array(),d = null,e = null;
- Ext.each(items, function(item){
- d = item.data;
- if (item.dirty) {
- e = grid.removeKey(d, 'deploy');
- if(d[key] == 0 && d['deploy'] == true) {
- added.push(e);
- }
- if(!Ext.isEmpty(d[key]) && d[key] != 0 && d['deploy'] == true) {
- updated.push(e);
- }
- if(!Ext.isEmpty(d[key]) && d[key] != 0 && d['deploy'] == false) {
- deleted.push(e);
- }
- }
- });
- return {
- added: added,
- updated: updated,
- deleted: deleted
- };
- }
- });
|