You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

1801 lines
59 KiB
JavaScript

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

Ext.namespace('Shipping');
Shipping.MsOpSeaeAuditTui = function (config) {
Ext.applyIf(this, config);
this.initUIComponents();
window.Shipping.MsOpSeaeAuditTui.superclass.constructor.call(this);
};
Ext.extend(Shipping.MsOpSeaeAuditTui, Ext.Panel, {
PageSize: 100,
OprationStatus: null, //仅当弹出界面时使用
SelectedRecord: null,
isShowAdvancedQuery: 0, //是否显示高级查询面板
sqlcontext: '',
editype: '',
selectbsno: '',
sortfield: '',
sortdire: '',
selectfee: '',
id: "MainPanel",
结费类型: '',
欠费超期: '',
累计欠费: '',
信用额度: '',
initUIComponents: function () {
this.formname = "formMsOpSeaeAuditTui"; //页面名称
//#region 定义数据集
this.storePLList = Ext.create('Ext.data.Store', {
model: 'MsOpSeaeModel'
});
this.storectndisp = Ext.create('DsExt.ux.RefTableStore', {
model: 'DsShipping.ux.CtnDispModel',
proxy: { url: '/CommMng/BasicDataRef/GetCtnDisp' }
});
this.storecodeservice = Ext.create('DsExt.ux.RefTableStore', {
model: 'MsCodeOpService',
proxy: { url: '/MvcShipping/MsCodeOpService/GetDataCtnList' }
});
this.storeList = Ext.create('Ext.data.Store', {
pageSize: this.PageSize,
model: 'MsOpSeaeModel',
remoteSort: true,
proxy: {
type: 'ajax',
url: '/MvcShipping/MsOpSeae/GetDataList',
reader: {
id: 'BSNO',
root: 'data',
totalProperty: 'totalCount'
}
}
});
//#endregion
//#region List列表显示信息
Ext.define('Ext.grid.column.Actiontextcolumn', {
extend: 'Ext.grid.column.Column',
alias: ['widget.actiontextcolumn'],
defaultRenderer: function (value) {
var me = this;
prefix = Ext.baseCSSPrefix;
scope = me.origScope || me;
// if (value == "") {
// }
// else
value = value + '<img role="button" src="' + (me.icon || Ext.BLANK_IMAGE_URL)
+ '" class="' + this.iconCls + ' x-action-col-icon"/>';
// value = '<label class="x-action-col-icon">' + value + '</label><img role="button" src="' + (me.icon || Ext.BLANK_IMAGE_URL)
// + '" class="' + this.iconCls + ' x-action-col-icon"/>';
return value;
},
processEvent: function (type, view, cell, recordIndex, cellIndex, e, record, row) {
var me = this;
if (type == 'click') {
me.handler.call(me.scope || me.origScope || me, view, recordIndex, cellIndex, e, record, row);
}
}
});
_this = this;
this.Pagenum = Ext.create('Ext.form.field.Number', {
name: 'bottles',
fieldLabel: Zi.LAN.bottles, //'每页记录数',
labelAlign: 'right',
value: this.PageSize,
maxValue: 100000,
width: 180,
minValue: 0,
listeners: {
specialkey: function (field, e) {
if (e.getKey() == e.ENTER) {
_this.onRefreshClick();
}
}
}
});
Ext.grid.RowNumberer = Ext.extend(Ext.grid.RowNumberer, {
width: 40
});
this.initgirdcolums = [{
sortable: true,
id: '',
dataIndex: '',
header: '',
width: 0
}, {
sortable: true,
id: '',
dataIndex: 'BSNO',
header: Zi.LAN.BSNO2, //'业务编号',
width: 0
}, {
sortable: true,
id: '',
dataIndex: 'CUSTNO',
header: Zi.LAN.CUSTNO, //'委托编号',
width: 120
}, {
sortable: true,
id: '',
dataIndex: 'ORDERNO',
header: Zi.LAN.ORDERNO, //'订舱编号',
width: 120
}, {
sortable: true,
id: '',
dataIndex: 'ORDERTYPE',
header: Zi.LAN.ORDERTYPE, //'订舱方式',
width: 120
},
{
sortable: true,
id: '',
dataIndex: 'BSSTATUSREF',
header: Zi.LAN.BSSTATUSREF, //'业务锁定',
align: 'center',
width: 60,
renderer: function (value, cellmeta) {
if (value == '锁定') {
return "<img src='../../../../TruckMng/Content/Images/Lock.png' />";
}
}
},
{
sortable: true,
id: '',
dataIndex: 'FEESTATUSREF',
header: Zi.LAN.FEESTATUSREF, //'费用锁定',
align: 'center',
width: 60,
renderer: function (value, cellmeta) {
if (value == '锁定') {
return "<img src='../../../../TruckMng/Content/Images/Lock.png' />";
}
}
},
{
sortable: true,
id: '',
dataIndex: 'DRFEESTATUS',
header: Zi.LAN.DRFEESTATUS, //'应收费用',
align: 'center',
width: 60,
renderer: function (value, meta) {
if (value == '审核通过') {
meta.tdCls = 'feestatus_pass';
} else if (value == '录入状态') {
} else if (value == '提交审核') {
meta.tdCls = 'feestatus_refer';
} else if (value == '部分结算') {
meta.tdCls = 'feestatus_refer';
} else if (value == '结算完毕') {
meta.tdCls = 'feestatus_settle';
} else if (value == '未录入') {
} else if (value == '部分结算') {
meta.tdCls = 'feestatus_settle';
} else if (value == '部分审核') {
meta.tdCls = 'feestatus_pass';
} else if (value == '部分提交') {
meta.tdCls = 'feestatus_refer';
}
return value;
}
},
{
sortable: true,
id: '',
dataIndex: 'CRFEESTATUS',
header: Zi.LAN.CRFEESTATUS, //'应付费用',
align: 'center',
width: 60,
renderer: function (value, meta) {
if (value == '审核通过') {
meta.tdCls = 'feestatus_pass';
} else if (value == '录入状态') {
} else if (value == '提交审核') {
meta.tdCls = 'feestatus_refer';
} else if (value == '部分结算') {
meta.tdCls = 'feestatus_refer';
} else if (value == '结算完毕') {
meta.tdCls = 'feestatus_settle';
} else if (value == '未录入') {
} else if (value == '部分结算') {
meta.tdCls = 'feestatus_settle';
} else if (value == '部分审核') {
meta.tdCls = 'feestatus_pass';
} else if (value == '部分提交') {
meta.tdCls = 'feestatus_refer';
}
return value;
}
},
{
sortable: true,
id: '',
dataIndex: 'DRINVSTATUS',
header: Zi.LAN.DRINVSTATUS, //'应收开票',
align: 'center',
width: 60,
renderer: function (value, meta) {
if (value == '已开票') {
meta.tdCls = 'feestatus_pass';
} else if (value == '部分开票') {
meta.tdCls = 'feestatus_refer';
}
return value;
}
}
,
{
sortable: true,
id: '',
dataIndex: 'OPSTATUS',
header: Zi.LAN.OPSTATUS, //'业务状态',
width: 60,
handler: function (grid, rowIndex, colIndex) {
alert(rowIndex);
}
},
{
sortable: true,
id: '',
dataIndex: 'BLTYPE',
header: Zi.LAN.BLTYPE, //'装运方式',
width: 60
},
{
sortable: true,
id: '',
dataIndex: 'ETD',
header: Zi.LAN.ETD2, //'开船日期',
width: 80
},
{
sortable: true,
id: '',
dataIndex: 'MBLNO',
header: Zi.LAN.MBLNO, //'主提单号',
width: 120,
filter: {
type: 'string'
// specify disabled to disable the filter menu
//, disabled: true
}
},
{
sortable: true,
id: '',
dataIndex: 'CUSTOMERNAME',
header: Zi.LAN.CUSTOMERNAME, //'委托单位',
width: 120
},
{
sortable: true,
id: '',
dataIndex: 'ETA',
header: Zi.LAN.ETA, //'预抵日期',
width: 80
},
{
sortable: true,
id: '',
dataIndex: 'BSDATE',
header: Zi.LAN.BSDATE, //'修改日期',
width: 80
},
{
sortable: true,
id: '',
dataIndex: 'GOODSNAME',
header: Zi.LAN.GOODSNAME, //'品名',
width: 120
},
{
sortable: true,
id: '',
dataIndex: 'PKGS',
header: Zi.LAN.PKGS, //'件数',
width: 80
},
{
sortable: true,
id: '',
dataIndex: 'KGS',
header: Zi.LAN.KGS2, //'毛重',
width: 80
},
{
sortable: true,
id: '',
dataIndex: 'CBM',
header: Zi.LAN.CBM2, //'尺码',
width: 80
},
{
sortable: true,
id: '',
dataIndex: 'CNTRTOTAL',
header: Zi.LAN.CNTRTOTAL2, //'集装箱',
width: 80
},
{
sortable: true,
id: '',
dataIndex: 'HBLNO',
header: Zi.LAN.HBLNO, //'分提单号',
width: 120
},
{
sortable: true,
id: '',
dataIndex: 'ACCDATE',
header: Zi.LAN.ACCDATE, //'会计期间',
width: 60
},
{
sortable: true,
id: '',
dataIndex: 'BSSOURCE',
header: Zi.LAN.BSSOURCE, //'业务来源',
width: 80
},
{
sortable: true,
id: '',
dataIndex: 'BSSOURCEDETAIL',
header: Zi.LAN.BSSOURCEDETAIL, //'来源明细',
width: 80
},
{
sortable: true,
id: '',
dataIndex: 'INPUTBY',
header: Zi.LAN.INPUTBY2, //'录入人',
width: 80
},
{
sortable: true,
id: '',
dataIndex: 'CREATETIME',
header: Zi.LAN.CREATETIME2, //'创建时间',
width: 120
},
{
sortable: true,
id: '',
dataIndex: 'OP',
header: Zi.LAN.OP, //'操作员',
width: 80
},
{
sortable: true,
id: '',
dataIndex: 'SALE',
header: Zi.LAN.SALE, //'揽货人',
width: 80
},
{
sortable: true,
id: '',
dataIndex: 'VESSEL',
header: Zi.LAN.VESSEL, //'船名',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'VOYNO',
header: Zi.LAN.VOYNO, //'航次',
width: 60
},
{
sortable: true,
id: '',
dataIndex: 'PORTLOAD',
header: Zi.LAN.PORTLOAD, //'装货港',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'PORTDISCHARGE',
header: Zi.LAN.PORTDISCHARGE, //'卸货港',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'DESTINATION',
header: Zi.LAN.DESTINATION, //'目的地',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'CNTR1',
header: Zi.LAN.CNTR1, //'箱型1',
width: 60
},
{
sortable: true,
id: '',
dataIndex: 'CNTR2',
header: Zi.LAN.CNTR2, //'箱型2',
width: 60
},
{
sortable: true,
id: '',
dataIndex: 'CNTR3',
header: Zi.LAN.CNTR3, //'箱型3',
width: 60
},
{
sortable: true,
id: '',
dataIndex: 'CNTR4',
header: Zi.LAN.CNTR4, //'箱型4',
width: 60
},
{
sortable: true,
id: '',
dataIndex: 'CNTR5',
header: Zi.LAN.CNTR5, //'箱型5',
width: 60
},
{
sortable: true,
id: '',
dataIndex: 'CNTR6',
header: Zi.LAN.CNTR6, //'箱型6',
width: 60
},
{
sortable: true,
id: '',
dataIndex: 'CNTR7',
header: Zi.LAN.CNTR7, //'箱型7',
width: 60
},
{
sortable: true,
id: '',
dataIndex: 'CNTR8',
header: Zi.LAN.CNTR8, //'箱型8',
width: 60
},
{
sortable: true,
id: '',
dataIndex: 'CNTR9',
header: Zi.LAN.CNTR9, //'箱型9',
width: 60
},
{
sortable: true,
id: '',
dataIndex: 'CNTR10',
header: Zi.LAN.CNTR10, //'箱型10',
width: 60
},
{
sortable: true,
id: '',
dataIndex: 'OTCNTR',
header: Zi.LAN.OTCNTR, //'其他箱型',
width: 60
},
{
sortable: true,
id: '',
dataIndex: 'TEU',
header: Zi.LAN.TEU, //'箱TEU',
width: 40
},
{
sortable: true,
id: '',
dataIndex: 'CUSTOMSER',
header: Zi.LAN.CUSTOMSER, //'报关行',
width: 80
},
{
sortable: true,
id: '',
dataIndex: 'KINDPKGS',
header: Zi.LAN.KINDPKGS, //'件数包装',
width: 60
},
{
sortable: true,
id: '',
dataIndex: 'CARRIER',
header: Zi.LAN.CARRIER, //'船公司',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'TRUCKER',
header: Zi.LAN.TRUCKER, //'承运车队',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'LANE',
header: Zi.LAN.LANE, //'航线',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'AGENTID',
header: Zi.LAN.AGENTID, //'代理',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'FORWARDER',
header: Zi.LAN.FORWARDER, //'订舱代理',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'PORTDISCHARGEID',
header: Zi.LAN.PORTDISCHARGEID, //'卸港代码',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'YARD',
header: Zi.LAN.YARD, //'场站',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'SERVICECONTRACTNO',
header: Zi.LAN.SERVICECONTRACTNO, //'服务合同号',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'CUSTSERVICE',
header: Zi.LAN.CUSTSERVICE, //'客服',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'DOC',
header: Zi.LAN.DOC, //'单证',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'VOUNO',
header: Zi.LAN.VOUNO, //'凭证号',
width: 60
}, {
sortable: true,
dataIndex: 'ISPRINTPR',
header: Zi.LAN.ISPRINTPR, //'打印核算单',
width: 80,
renderer: function (value, meta, record) {
if (value == '1')
return '√';
else
return '';
}
}, {
sortable: true,
dataIndex: 'ISFUMIGATION',
header: Zi.LAN.ISFUMIGATION, //'服务项目1',
hidden: true,
width: 100,
renderer: function (value, meta, record) {
if (value == true || value == '1')
return '√';
else
return '';
}
}, {
sortable: true,
dataIndex: 'ISSTORAGE',
header: Zi.LAN.ISSTORAGE, //'服务项目2',
hidden: true,
width: 100,
renderer: function (value, meta, record) {
if (value == true || value == '1')
return '√';
else
return '';
}
}, {
sortable: true,
dataIndex: 'ISLAND',
header: Zi.LAN.ISLAND, //'服务项目3',
hidden: true,
width: 100,
renderer: function (value, meta, record) {
if (value == true || value == '1')
return '√';
else
return '';
}
}, {
sortable: true,
dataIndex: 'ISCUSTOMS',
header: Zi.LAN.ISCUSTOMS, //'服务项目4',
hidden: true,
width: 100,
renderer: function (value, meta, record) {
if (value == true || value == '1')
return '√';
else
return '';
}
}, {
sortable: true,
dataIndex: 'ISINSPECTION',
header: Zi.LAN.ISINSPECTION, //'服务项目5',
hidden: true,
width: 100,
renderer: function (value, meta, record) {
if (value == true || value == '1')
return '√';
else
return '';
}
}, {
sortable: true,
dataIndex: 'ISBOOKING',
header: Zi.LAN.ISBOOKING, //'服务项目6',
hidden: true,
width: 100,
renderer: function (value, meta, record) {
if (value == true || value == '1')
return '√';
else
return '';
}
}, {
sortable: true,
dataIndex: 'ISAGENT',
header: Zi.LAN.ISAGENT, //'服务项目7',
hidden: true,
width: 100,
renderer: function (value, meta, record) {
if (value == true || value == '1')
return '√';
else
return '';
}
}, {
sortable: true,
dataIndex: 'ISHBLNO',
header: Zi.LAN.ISHBLNO, //'服务项目8',
hidden: true,
width: 100,
renderer: function (value, meta, record) {
if (value == true || value == '1')
return '√';
else
return '';
}
}, {
sortable: true,
dataIndex: 'SERVICE9',
header: Zi.LAN.SERVICE9, //'服务项目9',
hidden: true,
width: 100,
renderer: function (value, meta, record) {
if (value == true || value == '1')
return '√';
else
return '';
}
}, {
sortable: true,
dataIndex: 'SERVICE10',
header: Zi.LAN.SERVICE10, //'服务项目10',
hidden: true,
width: 100,
renderer: function (value, meta, record) {
if (value == true || value == '1')
return '√';
else
return '';
}
},
{
sortable: true,
id: '',
dataIndex: 'SHIPAGENCY',
header: Zi.LAN.SHIPAGENCY, //'船代',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'SHIPPER',
header: Zi.LAN.SHIPPER, //'SHIPPER',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'CONSIGNEE',
header: Zi.LAN.CONSIGNEE, //'CONSIGNEE',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'NOTIFYPARTY',
header: Zi.LAN.NOTIFYPARTY, //'NOTIFYPARTY',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'CONTRACTNO',
header: Zi.LAN.CONTRACTNO, //'运费协议号',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'ISSUETYPE',
header: Zi.LAN.ISSUETYPE, //'签单方式',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'OPERATOR',
header: Zi.LAN.OPERATOR2, //'委托单位联系人',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'CLOSINGDATE',
header: Zi.LAN.CLOSINGDATE, //'截港日期',
width: 100
},
{
sortable: true,
id: '',
dataIndex: 'CLOSEDOCDATE',
header: Zi.LAN.CLOSEDOCDATE, //'截单日期',
width: 100
}, {
sortable: true,
dataIndex: 'AMEND',
header: Zi.LAN.AMEND, //'更改单',
width: 80,
renderer: function (value, meta, record) {
if (value != '0')
return '√';
else
return '';
}
}, {
sortable: true,
dataIndex: 'ISAPPLY',
header: Zi.LAN.ISAPPLY, //'是否生成报关',
width: 80,
renderer: function (value, meta, record) {
if (value != '0')
return '√';
else
return '';
}
}, {
sortable: true,
dataIndex: 'STLNAME',
header: Zi.LAN.STLNAME, //'结算方式',
width: 80
}, {
sortable: true,
dataIndex: 'STLDATE',
header: Zi.LAN.STLDATE, //'结算日期',
width: 80
}, {
dataIndex: 'BLFRT',
header: Zi.LAN.BLFRT, //'付费方式',
width: 120
}, {
dataIndex: 'APPLYNO',
header: Zi.LAN.APPLYNO, //'申请放箱号',
width: 120
}, {
dataIndex: 'CARGOID',
header: '货物标示', //'货物标识',
width: 120
}, {
dataIndex: 'ISCANCEL',
header: '退舱', //'退舱',
width: 60,
renderer: function (value, meta, record) {
if (value == '1')
return '√';
else if (value == '2')
return '申请退舱';
else if (value == '4')
return '驳回申请';
else
return '';
}
}, {
dataIndex: 'ISTUI',
header: '推航次', //'推航次',
width: 70,
renderer: function (value, meta, record) {
if (value == '1')
return '√';
else if (value == '2')
return '申请推航次';
else if (value == '4')
return '驳回申请';
else
return '';
}
}];
this.girdcolums = this.initgirdcolums;
this.GridCheckBoxModel = Ext.create('Ext.selection.CheckboxModel');
// configure whether filter query is encoded or not (initially)
var encode = false;
// configure whether filtering is performed locally or remotely (initially)
var local = true;
//定义Grid
this.gridList = new Ext.grid.GridPanel({
store: this.storeList,
enableHdMenu: false,
region: 'center',
id: 'gridlist',
loadMask: {
msg: Zi.LAN.ShuJuJiaZaiZhongQingShaoDeng //"数据加载中,请稍等..."
},
trackMouseOver: true,
disableSelection: false,
selModel: this.GridCheckBoxModel,
viewConfig: {
enableTextSelection: true, //允许复制数据
autoFill: true,
getRowClass: function (record, rowIndex, rowParams, store) {
var ISCANCEL = record.get('ISCANCEL');
if (ISCANCEL == '1')
return 'feestatus_Del';
}
},
columns: this.girdcolums,
// paging bar on the bottom
bbar: [Ext.create('Ext.PagingToolbar', {
store: this.storeList,
displayInfo: true,
displayMsg: Zi.LAN.displayMsg, //'当前显示 {0} - {1}条记录 /共 {2}条记录',
emptyMsg: Zi.LAN.emptyMsg//'没有数据'
}), this.Pagenum]
});
/////////////以下部分为获取存储的gridpanel显示样式
this.girdcolums = DsTruck.GetGridPanel(USERID, this.formname, this.girdcolums, 1); //使用者id表名中间column数组跳过一开始的几列
this.gridList.reconfigure(this.storeList, this.girdcolums);
this.gridList.columns[1] = new Ext.grid.RowNumberer();
////////////////////////////////////////////////
this.gridList.addListener('itemdblclick', function (dataview, record, item, index, e, b) {
this.SelectedRecord = record;
this.OprationStatus = 'edit';
DsOpenEditWin('/MvcShipping/MsOpSeae/Edit', record.data.BSNO);
// var MainCenter = window.parent._this.MainCenter;
// DsOpenAtMain('/MvcShipping/MsOpSeae/Edit', '海运出口'+record.data.CUSTNO, MainCenter);
}, this);
var isloadfee = true;
// this.gridList.getSelectionModel().on('select', function (model, record, index) {
// if (!isloadfee) return;
// if (this.panelgridListEdiLog.isHidden() == true) return;
// var bsno = record.data.BSNO;
// var sql = "";
// sql = " BSNO='" + bsno + "'";
// isloadfee = false;
// this.storeListEdiLog.load({ params: { condition: sql },
// callback: function (r, options, success) {
// if (success) {
// isloadfee = true;
// }
// }
// });
// }, this);
this.gridList.addListener('sortchange', function (ct, column, direction, eOpts) {
this.sortfield = column.dataIndex;
this.sortdire = direction;
}, this);
//#endregion
//#region formSearch 下拉框信息加载
//权限范围
this.StoreOpRange = Ext.create('DsExt.ux.RefTableStore', {
model: 'MsOP',
proxy: { url: '/MvcShipping/MsBaseInfo/GetOpRang' }
});
this.StoreOpRange.load({ params: { optype: "modOrderManagement"} });
//人员信息加载
this.storeOpCode = Ext.create('DsExt.ux.RefTableStore', {
model: 'DsShipping.ux.UserRefModel',
proxy: { url: '/CommMng/BasicDataRef/GetUserRefList' }
});
this.storeSaleCode = Ext.create('DsExt.ux.RefTableStore', {
model: 'DsShipping.ux.UserRefModel',
proxy: { url: '/CommMng/BasicDataRef/GetUserRefList' }
});
this.storeOpCode.load({
callback: function (r, options, success) {
if (success) {
_this.storeSaleCode.add(r);
}
}
});
//客服
this.comboxCUSTSERVICE = Ext.create('DsExt.ux.RefTableCombox', {
fieldLabel: Zi.LAN.CUSTSERVICE, //'客服',
store: this.storeOpCode,
forceSelection: true,
name: 'CUSTSERVICE',
valueField: 'UserName',
displayField: 'CodeAndName'
});
//揽货人
this.comboxSALE = Ext.create('DsExt.ux.RefTableCombox', {
fieldLabel: Zi.LAN.SALE, //'揽货人',
store: this.storeSaleCode,
forceSelection: true,
name: 'SALE',
flex: 0.8,
valueField: 'UserName',
displayField: 'CodeAndName'
});
//操 作
this.comboxOP = Ext.create('DsExt.ux.RefTableCombox', {
fieldLabel: Zi.LAN.OP, //'操 作',
store: this.storeOpCode,
forceSelection: true,
name: 'OP',
flex: 0.8, valueField: 'UserName',
displayField: 'CodeAndName',
enableKeyEvents: true,
listeners: {
keyup: function (field, e) {
if (e.getKey() == e.ENTER) {
_this.onRefreshClick();
}
}
}
});
//录入人
this.comboxINPUTBY = Ext.create('DsExt.ux.RefTableCombox', {
fieldLabel: Zi.LAN.INPUTBY2, //'录入人',
store: this.storeOpCode,
forceSelection: true,
name: 'INPUTBY',
valueField: 'UserName',
displayField: 'CodeAndName',
enableKeyEvents: true,
listeners: {
keyup: function (field, e) {
if (e.getKey() == e.ENTER) {
_this.onRefreshClick();
}
}
}
});
//客户加载_委托单位
this.storeCustCode = Ext.create('DsExt.ux.RefTableStore', {
model: 'DsShipping.ux.CustomRefModel',
proxy: { url: '/CommMng/BasicDataRef/GetCustomRefList' }
});
this.storeCustCode.load({ params: { condition: "ISCONTROLLER='1'"} });
//委托单位
_this = this;
this.comboxCustCode = Ext.create('DsExt.ux.RefTableCombox', {
fieldLabel: Zi.LAN.CUSTOMERNAME, //'委托单位',
store: this.storeCustCode,
forceSelection: true,
name: 'CUSTOMERNAME',
valueField: 'CustName',
displayField: 'CodeAndName',
enableKeyEvents: true,
listeners: {
keyup: function (field, e) {
if (e.getKey() == e.ENTER) {
_this.onRefreshClick();
}
}
}
});
//#endregion
//#region formSearch 查询面板
_this = this;
this.formSearch = Ext.widget('form', {
frame: true,
region: 'center',
bodyPadding: 5,
fieldDefaults: {
margins: '2 2 2 2',
labelAlign: 'right',
flex: 1,
labelWidth: 60,
msgTarget: 'qtip'
},
items: [{//fieldset 1
xtype: 'container',
defaultType: 'textfield',
layout: 'anchor',
defaults: {
anchor: '100%'
},
items: [{
xtype: 'container',
layout: 'hbox',
defaultType: 'textfield',
items: [{
fieldLabel: Zi.LAN.MblNo2, //'编号',
name: 'MblNo',
enableKeyEvents: true,
listeners: {
specialkey: function (field, e) {
if (e.getKey() == e.ENTER) {
_this.onRefreshClick();
}
}
}
}, this.comboxCustCode, {
fieldLabel: Zi.LAN.ETD2, //'开船日期',
format: 'Y-m-d',
xtype: 'datefield',
name: 'ETDbgn',
enableKeyEvents: true,
listeners: {
specialkey: function (field, e) {
if (e.getKey() == e.ENTER) {
_this.onRefreshClick();
}
}
}
}, {
fieldLabel: Zi.LAN.ETDend, //'到',
format: 'Y-m-d',
xtype: 'datefield',
name: 'ETDend',
enableKeyEvents: true,
listeners: {
specialkey: function (field, e) {
if (e.getKey() == e.ENTER) {
_this.onRefreshClick();
}
}
}
}, this.comboxOP, this.comboxSALE, {
xtype: 'button',
width: 90,
text: Zi.LAN.btnrefresh, //"执行查询",
iconCls: "btnrefresh",
handler: function (button, event) {
this.onRefreshClick(button, event);
},
scope: this
}, {
xtype: 'button',
width: 90,
text: Zi.LAN.btnmore, //"高级查询",
iconCls: "btnmore",
handler: function (button, event) {
var sql = this.getCondition();
var winAccess = new Shipping.DsQuery({
});
winAccess.StoreList = this.storeList;
winAccess.formname = this.formname;
winAccess.condition = sql;
winAccess.show();
return;
},
scope: this
}]
}
//
// , {
// xtype: 'container',
// layout: 'hbox',
// defaultType: 'textfield',
// items: [this.comboxVoyVeg, {
// fieldLabel: '航次',
// name: 'VOYNO',
// enableKeyEvents: true,
// listeners: {
// specialkey: function (field, e) {
// if (e.getKey() == e.ENTER) {
// _this.onRefreshClick();
// }
// }
// }
// }, {
// fieldLabel: '会计期间',
// format: 'Y-m',
// xtype: 'datefield',
// name: 'ACCDATE',
// enableKeyEvents: true,
// listeners: {
// specialkey: function (field, e) {
// if (e.getKey() == e.ENTER) {
// _this.onRefreshClick();
// }
// }
// }
// }, this.comboxPORTLOAD]
// }, {
// xtype: 'container',
// layout: 'hbox',
// defaultType: 'textfield',
// items: [this.comboxCARRIER, this.comboxAgent, this.comboxPORTDISCHARGE, this.comboxFEESTATUS]
// }
]//end items(fieldset 1)
}]//end root items
});
//#endregion formSearch
_this = this;
//#region 按钮工具条
this.panelBtn = new Ext.Panel({
region: "north",
tbar: [{
text: "批准申请",
iconCls: "btnadd",
handler: function (button, event) {
this.onAuditPassClick();
},
scope: this
},
'-',
{
text: "驳回申请",
iconCls: "btndelete",
handler: function (button, event) {
this.onAuditBackClick();
},
scope: this
}, '-',
{
text: "执行查询",
iconCls: "btnrefresh",
handler: function (button, event) {
this.onRefreshClick(button, event);
},
scope: this
},
{
text: "重置条件",
iconCls: "btnreset",
handler: function (button, event) {
},
scope: this
}, '-',
{
text: "打印",
iconCls: 'btnprint',
menu: [
{ text: "全部",
handler: function (menu, event) {
_this.Print();
}
}, { text: "选择打印",
handler: function (menu, event) {
_this.PrintSelect();
}
}],
scope: this
}, '-', {
text: "保存列表样式",
id: "btntest",
menu: [
{ text: "保存",
handler: function (button, event) {
this.girdcolums = DsTruck.SaveGridPanel(USERID, _this.formname, _this.gridList.columns, _this.girdcolums, 1, true);
}
}, { text: "初始化",
handler: function (menu, event) {
_this.InitGrid(_this.initgirdcolums);
_this.girdcolums = DsTruck.SaveGridPanel(USERID, _this.formname, _this.gridList.columns, _this.initgirdcolums, 1, true);
}
}],
scope: this
}
]
});
//#endregion
this.DeleteFee = Ext.widget('form', {
frame: true,
region: 'east',
width: 260,
hidden: true,
title: '申请退舱或推航次原因',
trackResetOnLoad: true,
bodyPadding: 5,
fieldDefaults: {
margins: '2 2 2 2',
labelAlign: 'right',
flex: 1,
labelWidth: 50,
msgTarget: 'qtip'
},
items: [
{//fieldset 1
xtype: 'container',
defaultType: 'textfield',
layout: 'anchor',
defaults: {
anchor: '100%'
},
items: [{
xtype: 'container',
layout: 'hbox',
defaultType: 'textfield',
items: [{
fieldLabel: '原因', //'删除原因',
flex: 2,
height: 90,
xtype: 'textareafield',
grow: true,
name: 'REASON'
}
]
}
]//end items(fieldset 1)
}//end fieldset 1
]//end root items
});
this.panelTop = new Ext.Panel({
layout: "border",
region: "north",
height: 75,
items: [this.panelBtn, this.formSearch]
});
this.panelBody = new Ext.Panel({
layout: "border",
region: "center",
items: [this.gridList, this.DeleteFee]
});
Ext.apply(this, {
items: [this.panelTop, this.panelBody]
});
//#region 数据加载
this.storeCtnList = Ext.create('Ext.data.Store', {
pageSize: this.PageSize,
fields: [
{ name: 'CTNALL', type: 'string' }
],
remoteSort: true,
proxy: {
type: 'ajax',
url: '/MvcShipping/MsOpSeae/GetCtnList',
reader: {
id: '',
root: 'data',
totalProperty: 'totalCount'
}
}
});
this.InitGrid(this.girdcolums);
// this.onRefreshClick();
var myDate = new Date();
var mydatestr = Ext.util.Format.date(myDate, 'Y-m');
this.sqlcontext = " EXISTS (select 1 from workflow_using wu left join workflow_step st "
+ " on (st.WORKFLOWID=wu.WORKFLOWID and st.GROUPID=WU.CurrentID) where B.BSNO=wu.BSNO "
+ " and isnull((power(2,(ST.STEPNO)) & wu.stepno),0)>0 and st.AUDITOR='" + USERID + "' and (B.ISTUI='2' or B.ISCANCEL='2') ) ";
this.storeList.load({
params: { start: 0, limit: this.PageSize, sort: '', condition: _this.sqlcontext, load: 'true' },
waitMsg: Zi.LAN.ZhengZaiChaXunShuJu, //"正在查询数据...",
scope: this
});
this.storeList.on('beforeload', function (store) {
// var sql = this.getCondition();
Ext.apply(store.proxy.extraParams, { condition: _this.sqlcontext });
}, this);
this.gridList.getSelectionModel().on('select', function (model, record, index) {
var BSNO = record.data.BSNO;
var constr = " BSNO='"+BSNO+"' AND AUDITSTATUS<>'审核通过'";
this.DeleteFee.setVisible(true);
Ext.Ajax.request({
waitMsg: '正在查询', //'正在查询委托编号状态...',
url: '/MvcShipping/MsOpSeae/GetTuiShenData',
params: {
condition: constr
},
callback: function (options, success, response) {
if (success) {
var result = Ext.JSON.decode(response.responseText);
if (result.Success != true) {
this.DeleteFee.setVisible(false);
return;
}
data = result.data;
this.DeleteFee.getForm().reset();
this.DeleteFee.getForm().setValues(data);
} else {
Ext.MessageBox.alert('请求出现错误,请重试', response.responseText);
}
},
scope: this
});
}, this);
//#endregion
}, //end initUIComponents
//#region 加载函数
InitGrid: function (grid) {
//var agirdcolums = Ext.clone(this.gridList.columns);
var agirdcolums = grid;
this.storecodeservice.load({ params: { condition: "OPTYPE='1'" },
callback: function (r, options, success) {
if (success) {
if (r.length != 0) {
for (i = 0; i < this.storecodeservice.getCount(); i += 1) {
var itemindex = i + 1;
var memberyf = this.storecodeservice.getAt(i);
for (var j = 0; j < agirdcolums.length; j++) {
if (agirdcolums[j].dataIndex == memberyf.data.OPField) {
agirdcolums[j].header = memberyf.data.SERVICENAME;
agirdcolums[j].hidden = false;
}
}
};
}
this.gridList.reconfigure(this.storeList, agirdcolums);
}
},
scope: this
});
},
//#endregion
//#region 基本按钮函数
onRefreshClick: function (button, event) {
//var girdcolums = this.gridList.getColumnMode();
var sql = this.getCondition();
this.sqlcontext = sql;
this.PageSize = this.Pagenum.getValue();
this.storeList.pageSize = this.PageSize;
this.storeList.load({
params: { start: 0, limit: this.PageSize, sort: '', condition: sql },
waitMsg: Zi.LAN.ZhengZaiChaXunShuJu, //"正在查询数据...",
scope: this
});
},
onDsQuery: function () {
//var girdcolums = this.gridList.getColumnMode();
this.PageSize = this.Pagenum.getValue();
var sql = this.sqlcontext;
this.storeList.pageSize = this.PageSize;
var sortstr = '';
if (this.sortfield != '' && this.sortdire != '') {
sortstr = this.sortfield + ' ' + this.sortdire;
}
this.storeList.load({
params: { start: 0, limit: this.PageSize, sort: sortstr, condition: sql },
waitMsg: Zi.LAN.ZhengZaiChaXunShuJu, //"正在查询数据...",
scope: this
});
},
onAuditPassClick: function () {
var selections = this.gridList.getSelectionModel().getSelection();
if (selections.length == 0) {
Ext.Msg.show({ title: '提示', msg: '请先选择需批准的业务信息!', icon: Ext.Msg.INFO, buttons: Ext.Msg.OK });
return;
}
var bodyAddDatas = [];
for (var i = 0; i < selections.length; i++) {
var rec = selections[i];
var OPSTATUS = rec.data.OPSTATUS;
var ISTUI = rec.data.ISTUI;
var ISCANCEL = rec.data.ISCANCEL;
if (ISCANCEL == '2' || ISTUI == '2') {
bodyAddDatas.push(rec);
} else {
Ext.Msg.show({ title: '提示', msg: '当前状态不允许审核!', icon: Ext.Msg.INFO, buttons: Ext.Msg.OK });
return;
};
}
var jsonbodyAddDatas = ConvertRecordsToJsonAll(bodyAddDatas);
_this = this;
Ext.MessageBox.confirm('提示', '确定要批准的选中的业务吗?', function (btn) {
if (btn == 'yes') {
Ext.Msg.wait('正在审核数据...');
Ext.Ajax.request({
waitMsg: '正在审核数据...',
url: '/MvcShipping/MsOpSeae/AuditTuiShen',
params: {
data: jsonbodyAddDatas,
optype: '1'
},
callback: function (options, success, response) {
if (success) {
var jsonresult = Ext.JSON.decode(response.responseText);
if (jsonresult.Success) {
_this.onDsQuery();
Ext.Msg.show({ title: '提示', msg: '批准成功!', icon: Ext.Msg.INFO, buttons: Ext.Msg.OK });
}
else {
Ext.Msg.show({ title: '错误', msg: jsonresult.Message, icon: Ext.Msg.ERROR, buttons: Ext.Msg.OK });
}
}
},
failure: function (response, options) {
Ext.Msg.show({ title: '警告', msg: '服务器响应出错,请重试', icon: Ext.Msg.INFO, buttons: Ext.Msg.OK });
},
success: function (response, options) {
},
scope: this
}); //end Ext.Ajax.request
}
}, this);
},
onAuditBackClick: function () {
var selections = this.gridList.getSelectionModel().getSelection();
if (selections.length == 0) {
Ext.Msg.show({ title: '提示', msg: '请先选择需驳回的业务!', icon: Ext.Msg.INFO, buttons: Ext.Msg.OK });
return;
}
var bodyAddDatas = [];
for (var i = 0; i < selections.length; i++) {
var rec = selections[i];
var BILLSTATUS = rec.data.AUDITSTATUS;
var ISTUI = rec.data.ISTUI;
var ISCANCEL = rec.data.ISCANCEL;
if (ISCANCEL == '2' || ISTUI == '2') {
bodyAddDatas.push(rec);
} else {
Ext.Msg.show({ title: '提示', msg: '当前状态不允许驳回!', icon: Ext.Msg.INFO, buttons: Ext.Msg.OK });
return;
};
}
var jsonbodyAddDatas = ConvertRecordsToJsonAll(bodyAddDatas);
_this = this;
Ext.MessageBox.confirm('提示', '确定驳回选中的业务吗?', function (btn) {
if (btn == 'yes') {
Ext.Msg.wait('正在驳回数据...');
Ext.Ajax.request({
waitMsg: '正在驳回数据...',
url: '/MvcShipping/MsOpSeae/AuditTuiShen',
params: {
data: jsonbodyAddDatas,
optype: '0'
},
callback: function (options, success, response) {
if (success) {
var jsonresult = Ext.JSON.decode(response.responseText);
if (jsonresult.Success) {
_this.onDsQuery();
Ext.Msg.show({ title: '提示', msg: '驳回成功!', icon: Ext.Msg.INFO, buttons: Ext.Msg.OK });
}
else {
Ext.Msg.show({ title: '错误', msg: jsonresult.Message, icon: Ext.Msg.ERROR, buttons: Ext.Msg.OK });
}
}
},
failure: function (response, options) {
Ext.Msg.show({ title: '警告', msg: '服务器响应出错,请重试', icon: Ext.Msg.INFO, buttons: Ext.Msg.OK });
},
success: function (response, options) {
},
scope: this
}); //end Ext.Ajax.request
}
}, this);
},
onClearSql: function () {
var form = this.formSearch.getForm();
form.reset();
},
getCondition: function () {
var form = this.formSearch.getForm();
// var form2 = this.formSearch2.getForm();
if (!form.isValid()) {
Ext.Msg.alert(Zi.LAN.TiShi, '查询条件赋值错误,请检查。');
return '';
}
//隐藏查询面板
// this.panelSearch.hide();
this.isShowAdvancedQuery = 0;
//
var sql = " EXISTS (select 1 from workflow_using wu left join workflow_step st "
+ " on (st.WORKFLOWID=wu.WORKFLOWID and st.GROUPID=WU.CurrentID) where B.BSNO=wu.BSNO "
+ " and isnull((power(2,(ST.STEPNO)) & wu.stepno),0)>0 and st.AUDITOR='" + USERID + "' and (B.ISTUI='2' or B.ISCANCEL='2')) ";
//#region formSearch 查询面板
//编号包括(主提单号)
var MblNo = form.findField('MblNo').getValue();
sql = sql + getAndConSql(sql, MblNo, "(B.MblNo like '%" + MblNo + "%' or B.CONTRACTNO like '%" + MblNo + "%' or B.CUSTNO like '%" + MblNo + "%' or B.HBLNO like '%" + MblNo + "%' or B.ORDERNO like '%" + MblNo + "%' or B.APPLYNO like '%" + MblNo + "%')");
//客户名称
var CUSTOMERNAME = form.findField('CUSTOMERNAME').getValue();
sql = sql + getAndConSql(sql, CUSTOMERNAME, "B.CUSTOMERNAME='" + CUSTOMERNAME + "'");
//到港日期
var ETDbgn = form.findField('ETDbgn').getRawValue();
sql = sql + getAndConSql(sql, ETDbgn, "B.ETD >='" + ETDbgn + "'");
var ETDend = form.findField('ETDend').getRawValue();
sql = sql + getAndConSql(sql, ETDend, "B.ETD <='" + ETDend + "'");
//操作人
var OP = form.findField('OP').getValue();
sql = sql + getAndConSql(sql, OP, "B.OP='" + OP + "'");
//揽货人
var SALE = form.findField('SALE').getValue();
sql = sql + getAndConSql(sql, SALE, "B.SALE='" + SALE + "'");
//#endregion formSearch
return sql;
},
//#endregion
//#region 打印
Print: function () {
_this = this;
if (this.storeList.getCount() == 0) {
return;
}
var bsno = '11111';
var selections = this.gridList.getSelectionModel().getSelection();
if (selections.length != 0) {
var record = selections[0];
bsno = record.data.BSNO;
}
var sortstr = 'ETD,MBLNO ';
if (this.sortfield != '' && this.sortdire != '') {
sortstr = this.sortfield + ' ' + this.sortdire;
}
Ext.Msg.wait(Zi.LAN.ZhengZaiCaoZuoShuJu);
Ext.Ajax.request({
waitMsg: Zi.LAN.ZhengZaiCaoZuoShuJu,
url: '/MvcShipping/MsOpSeae/GetDataListStr',
scope: this,
params: {
condition: _this.sqlcontext,
printstr: 'true',
sort: sortstr
},
callback: function (options, success, response) {
if (success) {
Ext.MessageBox.hide();
var jsonresult = Ext.JSON.decode(response.responseText);
if (jsonresult.Success) {
var returnstr = jsonresult.data;
var condition = jsonresult.Message;
if (condition != '') condition = ' where ' + condition;
var printType = 'MSOPSEAELIST';
var sql1 = returnstr;
var sql2 = "select * from op_seae where BSNO='" + bsno + "'";
var sql3 = "select CUSTOMERNAME,COUNT(BSNO) BLCOUNT,SUM(TEU) TEU from op_seae B " + condition + " group by CUSTOMERNAME";
var sql4 = "select CARRIER,COUNT(BSNO) BLCOUNT,SUM(TEU) TEU from op_seae B " + condition + " group by CARRIER";
var sql5 = "select OP,COUNT(BSNO) BLCOUNT,SUM(TEU) TEU from op_seae B " + condition + " group by OP";
var sql6 = "select COUNT(BSNO) BLCOUNT,SUM(TEU) TEU from op_seae B " + condition;
PrintComm(printType, sql1, sql2, sql3, sql4, sql5, sql6);
} else {
Ext.Msg.show({ title: Zi.LAN.ChuoWu, msg: jsonresult.Message, icon: Ext.Msg.ERROR, buttons: Ext.Msg.OK });
}
} else {
Ext.Msg.show({ title: Zi.LAN.JingGao, msg: Zi.LAN.FuWuQiXiangYingChuCuo, icon: Ext.Msg.ERROR, buttons: Ext.Msg.OK });
}
}
});
},
PrintSelect: function () {
_this = this;
if (this.storeList.getCount() == 0) {
return;
}
var selectedRecords = [];
var storeadd = null;
selectedRecords = this.GridCheckBoxModel.selected.items;
if (selectedRecords.length == 0) {
Ext.Msg.show({ title: Zi.LAN.TiShi, msg: Zi.LAN.QingXianXuanZeYeWu, icon: Ext.Msg.INFO, buttons: Ext.Msg.OK });
return;
}
var sortstr = 'MBLNO desc';
if (this.sortfield != '' && this.sortdire != '') {
sortstr = this.sortfield + ' ' + this.sortdire;
}
var feeGidSql = '';
for (var i = 0; i < selectedRecords.length; i++) {
var record = selectedRecords[i];
var feeGId = "'" + record.get('BSNO') + "'";
if (feeGidSql == '') {
feeGidSql = feeGId;
} else {
feeGidSql = feeGidSql + "," + feeGId;
}
};
var bsno = '11111';
var mblno = '';
var selections = this.gridList.getSelectionModel().getSelection();
if (selections.length != 0) {
var record = selections[0];
bsno = record.data.BSNO;
mblno = record.data.MBLNO;
}
var printType = 'MSOPSEAELISTSELECT';
var sql1 = "select *,(SELECT TOP 1 STATUS FROM OP_STATUS WHERE BSNO=op_seae.BSNO ORDER BY COMPTIME DESC,INPUTTIME DESC) as OPSTATUS from op_seae WHERE MASTERNO IN (" + feeGidSql + ") order by " + sortstr;
var sql2 = "select *,(SELECT TOP 1 STATUS FROM OP_STATUS WHERE BSNO=op_seae.BSNO ORDER BY COMPTIME DESC,INPUTTIME DESC) as OPSTATUS from op_seae where BSNO='" + bsno + "'";
var sql3 = "";
var sql4 = "";
var sql5 = "";
var sql6 = "";
PrintComm(printType, sql1, sql2, sql3, sql4, sql5, sql6, mblno);
},
//#endregion
OprationSwap: function () {
var ret = new Array();
ret[0] = this.OprationStatus;
ret[1] = this.storeList;
ret[2] = this.SelectedRecord;
ret[3] = this.selectbsno;
ret[4] = 'op_seae';
ret[5] = this.storePLList;
ret[6] = this.selectfee;
return ret;
}
});