saas-platform/frontend/saas-web/app/view/money/othspendings/QueryPanelController.js

Ext.define('saas.view.money.othspendings.QueryPanelController', {
    extend: 'saas.view.core.query.QueryPanelController',
    alias: 'controller.money-othspendings-querypanel',
    init: function (form) {
        var me = this;
        this.control({
            //放大镜赋值关系 以及 tpl模板
            'dbfindtrigger[name=os_vendname]':{
                beforerender: function (f) {
                    Ext.apply(f, {
                        dataUrl: '/api/document/vendor/list',
                        addXtype: 'document-vendor-formpanel',
                        addTitle: '供应商资料',
                        dbfinds: [{
                            from: 'id',
                            to: 'os_vendid'
                        }, {
                            from: 've_code',
                            to: 'os_vendcode'
                        }, {
                            from: 've_name',
                            to: 'os_vendname'
                        }],
                        dbtpls: [{
                            field: 've_code',
                            width: 100
                        }, {
                            field: 've_name',
                            width: 100
                        }],
                        defaultCondition: "ve_statuscode='OPEN'",
                        dbSearchFields:[{
                            emptyText:'输入供应商编号或名称',
                            xtype : "textfield", 
                            name : "search", 
                            getCondition: function(v) {
                                return "(upper(ve_code) like '%"+v.toUpperCase()+"%' or upper(ve_name) like '%"+v.toUpperCase()+"%')";
                            },
                            allowBlank : true, 
                            columnWidth : 0.25
                        }],
                        dbColumns:[{
                            "text": "供应商ID",
                            "hidden": true,
                            "dataIndex": "id",
                            "width": 100,
                            "xtype": "numbercolumn"
                        },{
                            "text": "供应商编号",
                            "dataIndex": "ve_code",
                            "width": 200
                        }, {
                            "text": "供应商名称",
                            "dataIndex": "ve_name",
                            "width": 200
                        }, {
                            "text": "供应商类型",
                            "dataIndex": "ve_type",
                            "width": 180,
                            "items": null
                        }, {
                            "text": "税率",
                            "dataIndex": "ve_taxrate",
                            "width": 100,
                            xtype: 'numbercolumn',
                            align: 'end'
                        }, {
                            "text": "承付天数",
                            "dataIndex": "ve_promisedays",
                            "width": 100,
                            xtype: 'numbercolumn',
                            align: 'end'
                        }, {
                            "text": "纳税人识别号",
                            "dataIndex": "ve_bankaccount",
                            "width": 150
                        }, {
                            "text": "开户银行",
                            "dataIndex": "ve_bankaccount",
                            "width": 100
                        }, {
                            "text": "银行账户",
                            "dataIndex": "ve_bankcode",
                            "width": 100
                        }]
                    });

                }
            },
            //放大镜赋值关系 以及 tpl模板
            'dbfindtrigger[name=os_bankname]':{
                beforerender:function(f){
                    Ext.apply(f,{
                        conditionCode:'os_bankcode',
                        dataUrl:'/api/document/bankinformation/list',
                        dbfinds:[{
                            from:'bk_bankcode',to:'os_bankcode'
                        },{
                            from:'bk_bankname',to:'os_bankname'
                        },{
                            from:'id',to:'os_bankid'
                    }],
                        dbtpls:[{
                            field:'bk_bankcode',width:100
                        },{
                            field:'bk_bankname',width:100
                        }],
                        dbColumns:[{
                            "text": "账户ID",
                            "flex": 0,
                            "dataIndex": "id",
                            "width": 0,
                            "xtype": ""
                        },{
                            "text": "账户编号",
                            "flex": 1,
                            "dataIndex": "bk_bankcode",
                            "width": 120,
                            "xtype": ""
                        }, {
                            "text": "账户名称",
                            "flex": 1,
                            "dataIndex": "bk_bankname",
                            "width": 150,
                            "xtype": ""
                        }, {
                            "text": "账户类型",
                            "flex": 1,
                            "dataIndex": "bk_type",
                            "width": 120,
                            "xtype": ""
                        }, {
                            "text": "账户余额",
                            "flex": 1,
                            "dataIndex": "bk_thisamount",
                            "width": 120,
                            xtype: 'numbercolumn',
                        }, {
                            "text": "建帐日期",
                            "flex": 1,
                            "dataIndex": "bk_date",
                            "width": 120,
                            "xtype": "datecolumn"
                        }]
                    }) ;   

                }
            }
        });

    }
});