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

Ext.define('saas.view.money.othreceipts.QueryPanelController', {
    extend: 'saas.view.core.query.QueryPanelController',
    alias: 'controller.money-othreceipts-querypanel',
    init: function (form) {
        var me = this;
        this.control({
            //放大镜赋值关系 以及 tpl模板
            'dbfindtrigger[name=or_custname]':{
                beforerender:function(f){
                    Ext.apply(f,{
                        dataUrl:'/api/document/customer/dbfind',
                        addXtype: 'document-customer-formpanel',
                        addTitle: '客户资料',
                        dbfinds:[{
                            from:'id',to:'or_custid',ignore:true
                        },{
                            from:'cu_code',to:'or_custcode'
                        },{
                            from:'cu_name',to:'or_custname'
                        }],
                        dbtpls:[{
                            field:'cu_code',width:100
                        },{
                            field:'cu_name',width:100
                        }],
                        dbSearchFields: [{
                            emptyText: '输入客户编号或客户名称',
                            xtype: "textfield",
                            name: "search",
                            getCondition: function (v) {
                                return "(upper(cu_code) like '%"+v.toUpperCase()+"%' or upper(cu_name) like '%"+v.toUpperCase()+"%')";
                            },
                            allowBlank: true,
                            columnWidth: 0.25
                        }],
                        dbColumns:[
                            {
                                "text": "客户ID",
                                "flex": 0,
                                "dataIndex": "id",
                                "width": 0,
                                "xtype": "",
                                "items": null
                            },{
                                "text": "客户编号",
                                "flex": 1,
                                "dataIndex": "cu_code",
                                "width": 100,
                                "xtype": "",
                                "items": null
                            }, {
                                "text": "客户名称",
                                "flex": 1,
                                "dataIndex": "cu_name",
                                "xtype": "",
                                "items": null
                            }, {
                                "text": "客户类型",
                                "flex": 1,
                                "dataIndex": "cu_type",
                                "width": 200,
                                "xtype": "",
                                "items": null
                            }, {
                                "text": "业务员编号",
                                "flex": 1,
                                "dataIndex": "cu_sellercode",
                                "width": 100
                            }, {
                                "text": "业务员",
                                "flex": 1,
                                "dataIndex": "cu_sellername",
                                "width": 100
                            }, {
                                "text": "税率",
                                "flex": 1,
                                "dataIndex": "cu_taxrate",
                                "width": 100,
                                xtype: 'numbercolumn',
                            }, {
                                "text": "承付天数",
                                "flex": 1,
                                "dataIndex": "cu_promisedays",
                                align: 'end',
                                xtype: 'numbercolumn',
                                "width": 100, 
                                renderer : function(v) {
                                    return Ext.util.Format.number(v, '0');
                                }
                            }, {
                                "text": "额度",
                                "flex": 1,
                                "dataIndex": "cu_credit",
                                "width": 100,
                                xtype: 'numbercolumn',
                                renderer : function(v) {
                                    var arr = (v + '.').split('.');
                                    var xr = (new Array(arr[1].length)).fill('0');
                                    var format = '0,000.' + xr.join();
                                    return Ext.util.Format.number(v, format);
                                }
                            }, {
                                "text": "客户地址",
                                "flex": 1,
                                "dataIndex": "ca_address",
                                "width": 250
                            }]
                    }) ;   

                }
          },
            //放大镜赋值关系 以及 tpl模板
            'dbfindtrigger[name=or_bankname]':{
                beforerender:function(f){
                    Ext.apply(f,{
                        dataUrl:'/api/document/bankinformation/list',
                        addXtype: 'other-bankinformation',
                        addTitle: '资金账户',
                        dbfinds:[{
                            from:'bk_bankcode',to:'or_bankcode'
                        },{
                            from:'bk_bankname',to:'or_bankname'
                        },{
                            from:'id',to:'or_bankid',ignore:true
                        }],
                        dbtpls:[{
                            field:'bk_bankcode',width:100
                        },{
                            field:'bk_bankname',width:100
                        }],
                        dbSearchFields: [{
                            emptyText: '查找资金账户',
                            xtype: "textfield",
                            name: "search",
                            getCondition: function (v) {
                                return "(upper(bk_bankcode) like '%"+v.toUpperCase()+"%' or upper(bk_bankname) like '%"+v.toUpperCase()+"%')";
                            },
                            allowBlank: true,
                            columnWidth: 0.25
                        }],
                        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"
                        }]
                    });

                }
            }
        });

    }
});