Ext.QuickTips.init();
Ext.define('erp.controller.common.Datalist', {
extend: 'Ext.app.Controller',
requires: ['erp.util.BaseUtil', 'erp.util.FormUtil', 'erp.util.RenderUtil'],
views:[
'common.datalist.Viewport','common.datalist.GridPanel','common.datalist.Toolbar','core.button.VastAudit','core.button.VastDelete',
'core.button.VastPrint','core.button.VastReply','core.button.VastSubmit','core.button.ResAudit','core.form.FtField',
'core.grid.TfColumn','core.grid.YnColumn','core.trigger.DbfindTrigger','core.form.FtDateField','core.form.FtFindField',
'core.form.FtNumberField', 'core.form.MonthDateField'
],
init:function(){
this.BaseUtil = Ext.create('erp.util.BaseUtil');
this.FormUtil = Ext.create('erp.util.FormUtil');
this.control({
'erpDatalistGridPanel': {
itemclick: this.onGridItemClick
},
'erpVastDeleteButton': {
click: function(btn){
var dlwin = new Ext.window.Window({
id : 'dlwin',
title: btn.text,
height: "100%",
width: "80%",
maximizable : true,
buttonAlign : 'center',
layout : 'anchor',
items: [{
tag : 'iframe',
frame : true,
anchor : '100% 100%',
layout : 'fit',
html : ''
}],
buttons : [{
text: btn.text,
iconCls: btn.iconCls,
cls: 'x-btn-gray-1',
handler: function(){
}
},{
text : '关 闭',
iconCls: 'x-button-icon-close',
cls: 'x-btn-gray',
handler : function(){
Ext.getCmp('dlwin').close();
}
}]
});
dlwin.show();
}
},
'button[id=searchlist]': {
click: function(){
this.showSearchListWin();
}
},
'dbfindtrigger[name=sl_label]': {
afterrender: function(t){
t.dbBaseCondition = 'sl_caller=\'' + caller + '\'';
}
}
});
},
onGridItemClick: function(selModel, record){//grid行选择
if(keyField != null && keyField != ''){//有些datalist不需要打开明细表，这些表在datalist表里面不用配dl_keyField
if(keyField.indexOf('+') > 0) {//多条件传入查询界面//vd_vsid@vd_id+vd_class@vd_class
this.openQueryUrl(record);
} else {
this.openUrl(record);
}
}
},
openUrl: function(record) {
var me = this, value = record.data[keyField];
var formCondition = keyField + "IS" + value ;
var gridCondition = pfField + "IS" + value;
var newmaster = record.data['CURRENTMASTER'];
if(!Ext.isEmpty(pfField) && pfField.indexOf('+') > -1) {//多条件传入维护界面//vd_vsid@vd_id+vd_class@vd_class
var arr = pfField.split('+'),ff = [],k = [];
Ext.Array.each(arr, function(r){
ff = r.split('@');
k.push(ff[0] + 'IS\'' + record.get(ff[1]) + '\'');
});
gridCondition = k.join(' AND ');
}
var panelId = caller + keyField + "_" + value + gridCondition;
var panel = Ext.getCmp(panelId);
var main = parent.Ext.getCmp("content-panel");
if(!main){
main = parent.parent.Ext.getCmp("content-panel");
}
if(!panel){
var title = "";
if (value.toString().length>4) {
title = value.toString().substring(value.toString().length-4);
} else {
title = value;
}
var myurl = '';
if(me.BaseUtil.contains(url, '?', true)){
myurl = url + '&formCondition='+formCondition+'&gridCondition='+gridCondition;
} else {
myurl = url + '?formCondition='+formCondition+'&gridCondition='+gridCondition;
}
myurl += "&datalistId=" + main.getActiveTab().id;
if( newmaster ){
// myurl += "&newMaster=" + newmaster;
var currentMaster = parent.window.sob;
if ( currentMaster && currentMaster != newmaster) {// 与当前帐套不一致
me.openModalWin(newmaster, currentMaster, myurl);return;
}
}
main.getActiveTab().currentStore = me.getCurrentStore(value);//用于单据翻页
main.getActiveTab().currentRecord=record;
if(main._mobile) {
main.addPanel(me.BaseUtil.getActiveTab().title+'('+title+')', myurl, panelId);
} else {
panel = {
title : me.BaseUtil.getActiveTab().title+'('+title+')',
tag : 'iframe',
tabConfig:{tooltip:me.BaseUtil.getActiveTab().tabConfig.tooltip+'('+keyField + "=" + value+')'},
border : false,
layout : 'fit',
iconCls : 'x-tree-icon-tab-tab1',
html : '',
closable : true,
listeners : {
close : function(){
if(!main){
main = parent.parent.Ext.getCmp("content-panel");
}
main.setActiveTab(main.getActiveTab().id);
}
}
};
this.openTab(panel, panelId);
}
}else{
main.setActiveTab(panel);
}
},
openQueryUrl: function(record) {
var me = this, arr = keyField.split('+'),ff = [],k = [];//vd_vsid@vd_id+vd_class@vd_class
Ext.Array.each(arr, function(r){
ff = r.split('@');
k.push(ff[0] + '=' + record.get(ff[1]));
});
var myurl = k.join('&');
var panelId = caller + "_" + myurl;
var panel = Ext.getCmp(panelId);
var main = parent.Ext.getCmp("content-panel");
if(!main){
main = parent.parent.Ext.getCmp("content-panel");
}
if(!panel){
var title = me.BaseUtil.getActiveTab().title + '-查询';
if(contains(url, '?', true)){
myurl = url + '&' + myurl;
} else {
myurl = url + '?' + myurl;
}
if (main._mobile) {
main.addPanel(title, myurl, panelId);
} else {
panel = {
title : title,
tag : 'iframe',
tabConfig: {tooltip: title},
border : false,
layout : 'fit',
iconCls : 'x-tree-icon-tab-tab1',
html : '',
closable : true,
listeners : {
close : function(){
if(!main){
main = parent.parent.Ext.getCmp("content-panel");
}
main.setActiveTab(main.getActiveTab().id);
}
}
};
this.openTab(panel, panelId);
}
} else {
main.setActiveTab(panel);
}
},
openTab : function (panel,id){
var o = (typeof panel == "string" ? panel : id || panel.id);
var main = parent.Ext.getCmp("content-panel");
/*var tab = main.getComponent(o); */
if(!main) {
main =parent.parent.Ext.getCmp("content-panel");
}
var tab = main.getComponent(o);
if (tab) {
main.setActiveTab(tab);
} else if(typeof panel!="string"){
panel.id = o;
var p = main.add(panel);
main.setActiveTab(p);
}
},
openModalWin: function(master, current, url) {
if (parent.Ext) {
Ext.Ajax.request({
url: basePath + 'common/changeMaster.action',
params: {
to: master
},
callback: function(opt, s, r) {
if (s) {
var win = parent.Ext.create('Ext.Window', {
width: '100%',
height: '100%',
draggable: false,
closable: false,
modal: true,
id:'modalwindow',
historyMaster:current,
title: '创建到帐套' + master + '的临时会话',
html : '',
buttonAlign: 'center',
buttons: [{
text: $I18N.common.button.erpCloseButton,
cls: 'x-btn-blue',
id: 'close',
handler: function(b) {
Ext.Ajax.request({
url: basePath + 'common/changeMaster.action',
params: {
to: current
},
callback: function(opt, s, r) {
if (s) {
b.up('window').close();
} else {
alert('切换到原帐套失败!');
}
}
});
}
}]
});
win.show();
} else {
alert('无法创建到帐套' + master + '的临时会话!');
}
}
});
}
},
getCurrentStore: function(value){
var grid = Ext.getCmp('grid');
var items = grid.store.data.items;
var array = new Array();
var o = null;
Ext.each(items, function(item, index){
o = new Object();
o.selected = false;
if(index == 0){
o.prev = null;
} else {
o.prev = items[index-1].data[keyField];
}
if(index == items.length - 1){
o.next = null;
} else {
o.next = items[index+1].data[keyField];
}
var v = item.data[keyField];
o.value = v;
if(v == value)
o.selected = true;
array.push(o);
});
return array;
},
showSearchListWin: function(){
var me = this, win = this.searchWin;
if (!win){
win = this.searchWin = Ext.create('Ext.window.Window', {
title: '高级查询',
height: screen.height*0.7*0.8,
width: screen.width*0.7*0.6,
maximizable : true,
closable: false,
buttonAlign : 'center',
layout : 'border',
bodyStyle: 'background:#f1f1f1;',
tools: [{
type: 'close',
handler: function(e, el, header, tool){
tool.ownerCt.ownerCt.down('grid').setEffectData();//保留已选择的条件
tool.ownerCt.ownerCt.hide();
}
}],
items: [{
xtype: 'form',
region: 'north',
layout: 'column',
bodyStyle: 'background:#f1f1f1;',
maxHeight: 100,
buttonAlign: 'center',
buttons: [{
name: 'query',
id: 'query',
text: $I18N.common.button.erpQueryButton,
iconCls: 'x-button-icon-query',
cls: 'x-btn-gray',
handler: function(btn){
Ext.getCmp('grid').getCount(caller);
btn.ownerCt.ownerCt.ownerCt.hide();
}
},{
cls: 'x-btn-gray',
text: $I18N.common.button.erpOffButton,
handler: function(btn){
btn.ownerCt.ownerCt.ownerCt.down('grid').setEffectData();
btn.ownerCt.ownerCt.ownerCt.hide();
}
},{
xtype: 'radio',
name: 'separator',
boxLabel: '与',
checked: true,
inputValue: 'AND',
getCheckValue: function(){
return this.checked ? 'AND' : 'OR';
}
},{
xtype: 'radio',
name: 'separator',
boxLabel: '或',
inputValue: 'OR'
}]
}, me.getSearchListGrid(), me.getTemplateForm() ]
});
Ext.getCmp('grid').searchGrid = win.down('grid');
Ext.getCmp('grid').tempalteForm = win.down('form[name=template]');
this.getTemplates(caller);
}
win.show();
win.down('grid').loadData();
},
getFilterCondition: function(){
var fields = Ext.getCmp('grid').plugins[0].fields;
var items = new Array();
Ext.each(Ext.Object.getKeys(fields), function(key){
var item = fields[key];
if(item.value != null && item.value.toString().trim() != ''){
items.push({
xtype: item.xtype,
id: item.itemId,
fieldLabel: item.fieldLabel,
fieldStyle: item.fieldStyle,
value: item.value,
columnWidth: 0.5,
cls: 'form-field-border',
listeners: {
change: function(f){
Ext.getCmp(item.id).setValue(f.value);
}
}
});
}
});
return items;
},
getGridColumns : function() {
var grid = Ext.getCmp('grid'), columns = grid.headerCt.getGridColumns(), data = [];
Ext.each(columns, function(){
if(this.dataIndex && this.getWidth() > 0) {
data.push({
display : this.text,
value : this.text,
column : this
});
}
});
return data;
},
getSearchListGrid: function(){
var data = this.getGridColumns();
var grid = Ext.create('Ext.grid.Panel', {
maxHeight: 350,
region: 'center',
store: Ext.create('Ext.data.Store', {
fields:[{
name: 'sl_label',
type: 'string'
},{
name: 'sl_field',
type: 'string'
},{
name: 'sl_type',
type: 'string'
},{
name: 'sl_dbfind',
type: 'string'
},{
name: 'union',
type: 'string'
},{
name: 'value'
}],
data: []
}),
columns: [{
text: '条件',
flex: 2,
dataIndex: 'sl_label',
editor: {
xtype: 'combo',
store : Ext.create('Ext.data.Store', {
fields : [ 'display', 'value', 'column' ],
data : data
}),
editable: false,
displayField : 'display',
valueField : 'value',
queryMode : 'local'
},
renderer : function(val, meta, record, x, y, store, view) {
if (val) {
var column = view.ownerCt.headerCt.getHeaderAtIndex(y);
if(column && typeof column.getEditor != 'undefined') {
var editor = column.getEditor(record);
if (editor && editor.lastSelection.length > 0) {
var cm = editor.lastSelection[0].get('column'),
field = cm.dataIndex;
if (record.get('sl_field') != field)
record.set('sl_field', field);
var t = 'S';
if(cm.xtype == 'datecolumn' || cm.xtype == 'datetimecolumn') {
t = 'D';
} else if(cm.xtype == 'numbercolumn') {
t = 'N';
}
if (record.get('sl_type') != t)
record.set('sl_type', t);
}
}
} else {
if (record.get('sl_field')) {
record.set('sl_field', null);
}
}
return val;
},
processEvent : function(type, view, cell, recordIndex, cellIndex, e) {
if (type == 'click' || type == 'dbclick') {
return true;
}
return false;
}
},{
text: '',
hidden: true,
dataIndex: 'sl_field',
processEvent : function(type, view, cell, recordIndex, cellIndex, e) {
return false;
}
},{
text: '',
hidden: true,
dataIndex: 'sl_type',
processEvent : function(type, view, cell, recordIndex, cellIndex, e) {
return false;
}
},{
text: '关系',
flex: 1,
dataIndex: 'union',
editor: {
xtype: 'combo',
store: Ext.create('Ext.data.Store', {
fields: ['display', 'value'],
data : [
{"display": 'Like', "value": 'like'},
{"display": '等于', "value": '='},
{"display": '大于', "value": '>'},
{"display": '大于等于', "value": '>='},
{"display": '小于', "value": '<'},
{"display": '小于等于', "value": '<='},
{"display": '不等于', "value": '<>'},
{"display": '介于', "value": 'Between And'}
]
}),
displayField: 'display',
valueField: 'value',
queryMode: 'local',
editable: false,
value: 'like'
},
renderer : function(v) {
var r = v;
switch(v) {
case 'like':
r = 'Like';break;
case '=':
r = '等于';break;
case '>':
r = '大于';break;
case '>=':
r = '大于等于';break;
case '<':
r = '小于';break;
case '<=':
r = '小于等于';break;
case '<>':
r = '不等于';break;
case 'Between And':
r = '介于';break;
}
return r;
},
processEvent : function(type, view, cell, recordIndex, cellIndex, e) {
if (type == 'click' || type == 'dbclick') {
return true;
}
return false;
}
},{
text: '值',
flex: 3,
dataIndex: 'value',
renderer: function(val){
if(Ext.isDate(val)){
return Ext.Date.format(val, 'Y-m-d');
}
return val;
},
processEvent : function(type, view, cell, recordIndex, cellIndex, e) {
if (type == 'click' || type == 'dbclick') {
var s = view.ownerCt.selModel, m = s.getSelection(), n = [];
Ext.Array.each(m, function(){
n.push(this);
});
n.push(view.ownerCt.store.getAt(recordIndex));
s.select(n);
return true;
}
return false;
}
}],
columnLines: true,
plugins: Ext.create('Ext.grid.plugin.CellEditing', {
clicksToEdit: 1,
listeners: {
beforeedit: function(e){
if(e.field == 'value'){
var record = e.record;
var column = e.column;
if(record.data['union'] == null || record.data['union'] == ''){
record.set('union', 'like');
}
var f = record.data['sl_field'];
switch(record.data['sl_type']){
case 'D':
switch(record.data['union']){
case 'Between And':
column.setEditor(new erp.view.core.form.FtDateField({
id: f,
name: f
}));break;
default:
column.setEditor(new Ext.form.field.Date({
id: f,
name: f
}));break;
}
break;
case 'S':
switch(record.data['union']){
case 'Between And':
column.setEditor(new erp.view.core.form.FtField({
id: f,
name: f,
value: e.value
}));break;
default:
column.setEditor(new Ext.form.field.Text({
id: f,
name: f
}));break;
}
break;
case 'N':
switch(record.data['union']){
case 'Between And':
column.setEditor(new erp.view.core.form.FtNumberField({
id: f,
name: f
}));break;
default:
column.setEditor(new Ext.form.field.Number({
id: f,
name: f
}));break;
}
break;
case 'T':
column.dbfind = record.get('sl_dbfind');
switch(record.data['union']){
case 'Between And':
column.setEditor(new erp.view.core.form.FtFindField({
id: f,
name: f
}));break;
default:
column.setEditor(new erp.view.core.trigger.DbfindTrigger({
id: f,
name: f
}));break;
}
break;
default:
column.setEditor(null);
}
}
}
}
}),
selModel: Ext.create('Ext.selection.CheckboxModel',{
}),
setEffectData: function(){
var me = this;
var datas = new Array();
Ext.each(me.selModel.getSelection(), function(item){
var data = item.data;
if(!Ext.isEmpty(data.sl_label) && !Ext.isEmpty(data.union) && !Ext.isEmpty(data.value)){
datas.push(data);
}
});
me.effectdata = datas;
},
getEffectData: function(){
return this.effectdata || new Array();
},
loadData: function(){
if(!this.effectdata) {
this.store.add([{},{},{},{},{},{},{},{},{}]);
}
},
/**
* 将数据拼成Sql条件语句
*/
getCondition: function(){
this.setEffectData();
var condition = '';
var separator = this.up('window').down('form').down('radio').getCheckValue();
Ext.each(this.effectdata, function(data){
if(data.union == 'Between And'){
var v1 = data.value.split('~')[0];
var v2 = data.value.split('~')[1];
if(data.sl_type == 'D'){
if(condition == ''){
condition = '(' + data.sl_field + " BETWEEN to_date('" + v1 + " 00:00:00','yyyy-MM-dd HH24:mi:ss') AND to_date('"
+ v2 + " 23:59:59','yyyy-MM-dd HH24:mi:ss')" + ') ';
} else {
condition += ' ' + separator + ' (' + data.sl_field + " BETWEEN to_date('" + v1 + " 00:00:00','yyyy-MM-dd HH24:mi:ss') AND to_date('"
+ v2 + " 23:59:59','yyyy-MM-dd HH24:mi:ss')" + ') ';
}
} else if(data.sl_type == 'N'){
if(condition == ''){
condition = '(' + data.sl_field + " BETWEEN " + v1 + ' AND ' + v2 + ') ';
} else {
condition += ' ' + separator + ' (' + data.sl_field + " BETWEEN " + v1 + ' AND ' + v2 + ') ';
}
} else{
if(condition == ''){
condition = '(' + data.sl_field + " BETWEEN '" + v1 + "' AND '" + v2 + "') ";
} else {
condition += ' ' + separator + ' (' + data.sl_field + " BETWEEN '" + v1 + "' AND '" + v2 + "') ";
}
}
} else {
if(data.sl_type == 'D'){
var v = data.value, field = data.sl_field;
if(Ext.isDate(v)) {
v = Ext.Date.format(v, 'Y-m-d');
}
if(data.union == '<' || data.union == '<='){
v = "to_date('" + v + " 00:00:00','yyyy-MM-dd HH24:mi:ss')";
} else if(data.union == '>' || data.union == '>='){
v = "to_date('" + v + " 23:59:59','yyyy-MM-dd HH24:mi:ss')";
} else {
v = Ext.Date.format(data.value, 'Ymd');
field = "to_char(" + field + ",'yyyymmdd')";
}
if(condition == ''){
condition = '(' + field + data.union + v + ') ';
} else {
condition += ' ' + separator +' (' + field + data.union + v + ') ';
}
} else {
var v = data.value;
if(data.union == 'like'){
v = " '%" + data.value + "%'";
} else {
v = " '" + data.value + "'";
}
if(condition == ''){
condition = '(' + data.sl_field + " " + data.union + v + ") ";
} else {
condition += ' ' + separator +' (' + data.sl_field + " " + data.union + v + ") ";
}
}
}
});
return condition;
}
});
return grid;
},
getTemplateForm : function() {
var me = this;
return Ext.create('Ext.form.Panel', {
minHeight : 150,
region : 'south',
layout : 'column',
name : 'template',
bodyStyle : 'background:#f1f2f5;',
items : [{
xtype : 'fieldcontainer',
columnWidth : .75,
defaults : {
xtype : 'radio',
flex : 1,
margin : '5 0 5 15',
labelAlign : 'right'
},
items : [{
name : 'export-type',
boxLabel : '全部列',
checked : true
}]
}, {
xtype : 'fieldcontainer',
columnWidth : .25,
items : [{
xtype : 'button',
cls : 'x-btn-gray',
iconCls : 'x-button-icon-excel',
flex : 1,
margin : '15 0 5 0',
width : 80,
text : '导 出',
handler : function(b) {
var grid = Ext.getCmp('grid'),
tb = grid.down('erpDatalistToolbar'),
r = b.ownerCt.ownerCt.down('radio[checked=true]');
if (r.fields)
tb.exportData(grid, b, r.boxLabel, r.fields);
else
tb.exportData(grid, b);
}
}, {
xtype : 'button',
cls : 'x-btn-gray',
flex : 1,
margin : '5 0 10 0',
width : 80,
text : '新建模板',
handler : function(b, e) {
var grid = Ext.getCmp('grid');
me.addTemplate(grid);
}
}]
}]
});
},
addTemplate : function(grid) {
var me = this, panel = grid.templatePanel;
if (!panel) {
var columns = grid.headerCt.getGridColumns(), data = [];
Ext.each(columns, function(){
if(this.dataIndex && this.getWidth() > 0) {
data.push({
boxLabel : this.text,
inputValue : this.dataIndex,
checked : true
});
}
});
data.push({
columnWidth : .8,
labelWidth : 60,
fieldLabel : '描述',
name : 'desc',
xtype : 'textfield',
allowBlank : false,
value : this.BaseUtil.getActiveTab().title + '(模板)-' + em_name
+ '-' + Ext.Date.format(new Date(),'Ymd')
});
panel = grid.templatePanel = Ext.create('Ext.panel.Panel', {
floating : true,
shadow : 'frame',
layout : 'column',
width : 700,
bodyStyle : 'background:#f1f2f5;z-index:9999;',
defaults : {
xtype : 'checkbox',
margin : '5 5 15 15',
columnWidth : .25
},
items : data,
buttonAlign : 'center',
buttons : [{
text : '确认',
handler : function(b) {
var items = panel.query('checkbox[checked=true]'), fs = [];
Ext.each(items, function(){
fs.push(this.inputValue);
});
me.onTemplateAdd(panel, caller, fs.join(','), panel.down('textfield[name=desc]').value);
}
},{
text : '取消',
handler : function() {
panel.hide();
}
}]
});
}
panel.show();
panel.center();
},
onTemplateAdd : function(panel, caller, fields, desc) {
warnMsg('确定添加新模板:' + desc + '?', function(b){
if (b == 'ok' || b == 'yes') {
Ext.Ajax.request({
url : basePath + 'common/template/save.action',
params : {
_noc : 1,
caller : caller,
fields : fields,
desc : desc
},
callback : function(opt, s, res) {
var r = Ext.decode(res.responseText);
if (r.success) {
alert('添加成功!');
panel.hide();
var form = Ext.getCmp('grid').tempalteForm;
form.down('radio[value=true]').setValue(false);
form.items.first().add({
name : 'export-type',
boxLabel : desc,
fields : fields,
checked : true
});
}
}
});
}
});
},
getTemplates : function(caller) {
Ext.Ajax.request({
url : basePath + 'common/getFieldsDatas.action',
async: false,
params: {
caller: 'DataTemplate',
fields: 'dt_desc,dt_fields',
condition: 'dt_caller=\'' + caller + '\''
},
method : 'post',
callback : function(opt, s, res){
var r = new Ext.decode(res.responseText);
if(r.exceptionInfo){
showError(r.exceptionInfo);return;
}
if (r.success && r.data) {
var f = [], dd = Ext.decode(r.data);
if(dd.length > 0) {
Ext.each(dd, function(){
f.push({
name : 'export-type',
boxLabel : this.DT_DESC,
fields : this.DT_FIELDS
});
});
var form = Ext.getCmp('grid').tempalteForm;
form.items.first().add(f);
}
}
}
});
}
});