saas-platform/frontend/saas-web/app/view/sale/saleIn/QueryPanelController.js

Ext.define('saas.view.sale.saleIn.QueryPanelController', {
    extend: 'saas.view.core.query.QueryPanelController',
    alias: 'controller.sale-salein-querypanel',
    init: function (form) {
        var me = this;
        this.control({
            // 客户名称
            'dbfindtrigger[name=pi_custname]':{
                beforerender:function(f){
                    Ext.apply(f,{
                        dataUrl:'/api/document/customer/dbfind',
                        addXtype: 'document-customer-formpanel',
                        addTitle: '客户资料',
                        dbfinds:[
                        {
                            from:'id',to:'pi_custid'
                        },{
                            from:'cu_code',to:'pi_custcode'
                        },{
                            from:'cu_name',to:'pi_custname'
                        }],
                        dbtpls:[
                        {
                            field:'cu_code',width:100
                        },{
                            field:'cu_name',width:100
                        }],
                        dbColumns:[
                        {
                            conditionCode:'id',
                            "text": "客户ID",
                            "flex": 0,
                            "dataIndex": "id",
                            "width": 100,
                            "xtype": "",
                            "items": null
                        },{
                            conditionCode:'cu_code',
                            "text": "客户编号",
                            "flex": 1,
                            "dataIndex": "cu_code",
                            "width": 100,
                            "xtype": "",
                            "items": null
                        }, {
                            conditionCode:'cu_name',
                            "text": "客户名称",
                            "flex": 1,
                            "dataIndex": "cu_name",
                            "xtype": "",
                            "items": null
                        }, {
                            conditionCode:'cu_type',
                            "text": "客户类型",
                            "flex": 0,
                            "dataIndex": "cu_type",
                            "width": 200,
                            "xtype": "",
                            "items": null
                        }]
                    }) ;   

                }
            },

            // 物料编号
            'dbfindtrigger[name=pd_prodcode]':{
                beforerender:function(f){
                    Ext.apply(f,{
                        dataUrl:'/api/document/product/list',
                        addXtype: 'document-product-formpanel',
                        addTitle: '物料资料',
                        dbfinds:[{
                            from:'pr_code',to:'pd_prodcode'
                        }, {
                            from:'pr_detail',to:'pr_detail'
                        }],
                        dbtpls:[
                        {
                            field:'pr_code',width:100
                        },{
                            field:'pr_detail',width:100
                        }],
                        defaultCondition: 'pr_statuscode="OPEN"',
                        dbSearchFields:[{
                            emptyText:'输入物料编号、名称或规格',
                            xtype : "textfield", 
                            name : "search", 
                            width: 200,
                            getCondition: function(v) {
                                return "upper(pr_spec) like '%" + v.toUpperCase()+"%' or upper(pr_code) like '%"+v.toUpperCase()+"%' or upper(pr_detail) like '%"+v.toUpperCase()+"%'";
                            },
                            allowBlank : true, 
                            columnWidth : 0.25
                        }],
                        dbColumns:[
                            {
                                "text": "物料ID",
                                "hidden": true,
                                "dataIndex": "id",
                            },{
                                "text": "物料编号",
                                "flex": 1,
                                "dataIndex": "pr_code",
                                "width": 100,
                                "xtype": "",
                                "items": null
                            }, {
                                "text": "物料名称",
                                "flex": 1,
                                "dataIndex": "pr_detail",
                                "xtype": "",
                                "items": null
                            }, {
                                "text": "规格",
                                "flex": 1,
                                "dataIndex": "pr_spec",
                                "width": 200,
                                "xtype": "",
                                "items": null
                            }, {
                                "text": "单位",
                                "flex": 1,
                                "dataIndex": "pr_unit",
                                "width": 200,
                                "xtype": "",
                                "items": null
                            }, {
                                "text": "品牌",
                                "flex": 1,
                                "dataIndex": "pr_brand",
                                "width": 200,
                                "xtype": "",
                                "items": null
                            }, {
                                "text": "供应商ID",
                                "flex": 0,
                                "dataIndex": "pr_vendid",
                                "width": 0,
                                "xtype": "",
                                "items": null
                            }, {
                                "text": "供应商编号",
                                "flex": 1,
                                "dataIndex": "pr_vendcode",
                                "width": 200,
                                "xtype": "",
                                "items": null
                            }, {
                                "text": "供应商名称",
                                "flex": 1,
                                "dataIndex": "pr_vendname",
                                "width": 200,
                                "xtype": "",
                                "items": null
                            }, {
                                "text": "最小包装量",
                                "flex": 1,
                                "dataIndex": "pr_zxbzs",
                                "width": 200,
                                "xtype": "",
                                "items": null
                            }]
                    }) ;   

                }
            }
        });

    }
});