saas-platform/frontend/saas-web/app/view/stock/appropriationInOut/FormPanelController.js

Ext.define('saas.view.stock.appropriationInOut.FormPanelController', {
    extend: 'saas.view.core.form.FormPanelController',
    alias: 'controller.stock-appropriationinout-formpanel',
    
    init: function (form) {
        var me = this;
        this.control({
            /**放大镜新增demo*/
            "field[name=combo]":{
                beforerender:function(f){
                    f.addHandler=me.addCombo;
                }
            },
            //放大镜赋值关系 以及 tpl模板
            'dbfindtrigger[name=pi_vendname]':{
                beforerender:function(f){
                    Ext.apply(f,{
                        dataUrl:'/api/document/vendor/list',
                        // dataUrl:'http://localhost:9480/vendor/list',
                        addXtype: 'document-vendor-formpanel',
                        addTitle: '供应商资料',
                        dbfinds:[{
                            from:'id',to:'pi_vendid'
                        },{
                            from:'ve_code',to:'pi_vendcode'
                        },{
                            from:'ve_name',to:'pi_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,
                            align:'right'
                        }, {
                            "text": "承付天数",
                            "dataIndex": "ve_promisedays",
                            "width": 100,
                            align:'right'
                        }, {
                            "text": "纳税人识别号",
                            "dataIndex": "ve_bankaccount",
                            "width": 150
                        }, {
                            "text": "开户银行",
                            "dataIndex": "ve_bankaccount",
                            "width": 100
                        }, {
                            "text": "银行账户",
                            "dataIndex": "ve_bankcode",
                            "width": 100
                        }]
                    }) ;   

                }
            },
            //放大镜赋值关系 以及 tpl模板
            'dbfindtrigger[name=pi_custname]':{
                beforerender:function(f){
                    Ext.apply(f,{
                        addXtype: 'document-customer-formpanel',
                        addTitle: '客户资料',
                        dataUrl:'/api/document/customer/list',
                        // dataUrl:'http://localhost:9480/customer/list',
                        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
                        }],
                        defaultCondition:"cu_statuscode='OPEN'",
                        //放大镜窗口字段
                        dbSearchFields:[{
                            emptyText:'输入客户编号或名称',
                            xtype : "textfield", 
                            name : "cu_name", 
                            allowBlank : true, 
                            columnWidth : 0.25,
                            getCondition:function(v){
                                return "upper(cu_name) like '%"+v.toUpperCase()+"%' or upper(cu_code) like '%"+v.toUpperCase()+"%'";
                            }
                        }],
                        dbColumns:[{
                            "text": "客户ID",
                            "hidden": true,
                            "dataIndex": "id",
                        },{
                            "text": "客户编号",
                            "dataIndex": "cu_code",
                            "width": 200,
                        }, {
                            "text": "客户名称",
                            "dataIndex": "cu_name",
                            "width": 200
                        },{
                            "text": "客户类型",
                            "dataIndex": "cu_name",
                            "width": 100
                        },{
                            "text": "业务员",
                            "dataIndex": "cu_sellername",
                            "width": 100
                        },{
                            "text": "税率",
                            "dataIndex": "cu_taxrate",
                            "width": 100,
                            align:'right'
                        },{
                            "text": "承付天数",
                            "dataIndex": "cu_promisedays",
                            "width": 100,
                            align:'right'
                        },{
                            "text": "额度",
                            "dataIndex": "cu_credit",
                            "width": 100,
                            align:'right'
                        }]
                    }) ;   

                }
            },            
            //放大镜赋值关系 以及 tpl模板
            'multidbfindtrigger[name=pd_prodcode]':{
                beforerender:function(f){
                    Ext.apply(f,{
                        dataUrl:'/api/document/product/list',
                        // dataUrl:'http://localhost:9480/product/list',
                        addXtype: 'document-product-formpanel',
                        addTitle: '物料资料',
                        dbfinds:[{
                            from:'id',to:'pd_prodid'                          
                        },{
                            from:'pr_code',to:'pd_prodcode'                          
                        },{
                            from:'pr_detail',to:'pr_detail'
                        },{
                            from:'pr_spec',to:'pr_spec'
                        },{
                            from:'pr_whid',to:'pd_whid'
                        },{
                            from:'pr_whcode',to:'pd_whcode'
                        },{
                            from:'pr_whname',to:'pd_whname'
                        }],
                        dbtpls:[{
                            field:'pr_code',width:100
                        },{
                            field:'pr_detail',width:100
                        },{
                            field:'pr_spec',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": "物料编号",       
                            "dataIndex": "pr_code",
                            "width": 200,
                        }, {
                            "text": "物料名称",
                            "width": 200,
                            "dataIndex": "pr_detail",
                        }, {
                            "text": "规格",
                            "dataIndex": "pr_spec",
                            "width": 100,
                        }, {
                            "text": "单位",
                            "dataIndex": "pr_unit",
                            "width": 100,
                        },{
                            "text": "仓库id",
                            "dataIndex": "pr_whid",
                            "hidden": true,
                        },{
                            "text": "仓库编号",
                            "dataIndex": "pr_whcode",
                            "hidden": true,
                        },{
                            "text": "仓库",
                            "dataIndex": "pr_whname",
                            "width": 200,
                        },{
                            "text": "总库存数",
                            "dataIndex": "po_onhand",
                            "width": 100,
                            align:'right'
                        },{
                            "text": "类型",
                            "dataIndex": "pr_kind",
                            "width": 100,
                        },{
                            "text": "型号",
                            "dataIndex": "pr_orispeccode",
                            "width": 100,
                        },{
                            "text": "品牌",
                            "dataIndex": "pr_brand",
                            "width": 100,
                        },{
                            "text": "供应商",
                            "dataIndex": "pr_vendname",
                            "width": 100,
                        },{
                            "text": "最小包装",
                            "dataIndex": "pr_zxbzs",
                            "width": 100,
                            align:'right'
                        },{
                            "text": "L/T",
                            "dataIndex": "pr_leadtime",
                            "width": 100,
                        }]
                    }) ;   

                }
            },
           //放大镜赋值关系 以及 tpl模板
           'dbfindtrigger[name=pd_whname]':{
            beforerender:function(f){
                Ext.apply(f,{
                    dataUrl:'/api/document/warehouse/list',
                    // dataUrl:'http://localhost:9480/warehouse/list',
                    addXtype: 'other-warehouse',
                    addTitle: '仓库资料',
                    defaultCondition:"wh_statuscode='OPEN'",
                    dbfinds:[{
                        from:'id',to:'pd_whid'                          
                    },{
                        from:'wh_code',to:'pd_whcode'                          
                    },{
                        from:'wh_description',to:'pd_whname'
                    }],
                    dbtpls:[{
                        field:'pd_whcode',width:100
                    },{
                        field:'pd_whname',width:100
                    }],
                    dbSearchFields:[{
                        emptyText:'输入仓库编号或名称',
                        xtype : "textfield", 
                        name : "wh_code", 
                        allowBlank : true, 
                        columnWidth : 0.25,
                        getCondition:function(v){
                            return "upper(wh_code) like '%"+v.toUpperCase()+"%' or upper(wh_description) like '%"+v.toUpperCase()+"%'";
                        }
                    }],                    
                    dbColumns:[{
                        "text": "仓库ID",
                        "flex": 0,
                        "dataIndex": "id",
                        "width": 0,
                        "xtype": "",
                        "items": null
                    },{
                        "text": "仓库编号",
                        "flex": 1,
                        "dataIndex": "wh_code",
                        "width": 100,
                        "xtype": "",
                        "items": null
                    }, {
                        "text": "仓库名称",
                        "flex": 1,
                        "dataIndex": "wh_description",
                        "xtype": "",
                        "items": null
                    }, ]
                }) ;   

            }
        },           
        //放大镜赋值关系 以及 tpl模板
        'dbfindtrigger[name=pd_inwhname]':{
         beforerender:function(f){
             Ext.apply(f,{
                 dataUrl:'/api/document/warehouse/list',
                //  dataUrl:'http://localhost:9480/warehouse/list',
                 addXtype: 'other-warehouse',
                 addTitle: '仓库资料',
                 defaultCondition:"wh_statuscode='OPEN'",
                 dbfinds:[{
                     from:'id',to:'pd_inwhid'                          
                 },{
                     from:'wh_code',to:'pd_inwhcode'                          
                 },{
                     from:'wh_description',to:'pd_inwhname'
                 }],
                 dbtpls:[{
                     field:'pd_inwhcode',width:100
                 },{
                     field:'pd_inwhname',width:100
                 }],
                 dbSearchFields:[{
                    emptyText:'输入仓库编号或名称',
                    xtype : "textfield", 
                    name : "wh_code", 
                    allowBlank : true, 
                    columnWidth : 0.25,
                    getCondition:function(v){
                        return "upper(wh_code) like '%"+v.toUpperCase()+"%' or upper(wh_description) like '%"+v.toUpperCase()+"%'";
                    }
                }],                 
                 dbColumns:[{
                     "text": "仓库ID",
                     "flex": 0,
                     "dataIndex": "id",
                     "width": 0,
                     "xtype": "",
                     "items": null
                 },{
                     "text": "仓库编号",
                     "flex": 1,
                     "dataIndex": "wh_code",
                     "width": 100,
                     "xtype": "",
                     "items": null
                 }, {
                     "text": "仓库名称",
                     "flex": 1,
                     "dataIndex": "wh_description",
                     "xtype": "",
                     "items": null
                 },{
                    "text": "仓库类型",
                    "flex": 1,
                    "dataIndex": "wh_type",
                    "xtype": "",
                    "items": null
                }]
             }) ;   

                }
            },
            //放大镜赋值关系 以及 tpl模板
            'dbfindtrigger[name=pd_inwhname]':{
                beforerender:function(f){
                    Ext.apply(f,{
                        dataUrl:'/api/document/warehouse/list',
                        // dataUrl:'http://localhost:9480/warehouse/list',
                        dbfinds:[{
                            from:'id',to:'pd_inwhid'                          
                        },{
                            from:'wh_code',to:'pd_inwhcode'                          
                        },{
                            from:'wh_description',to:'pd_inwhname'
                        }],
                        dbtpls:[{
                            field:'pd_inwhcode',width:100
                        },{
                            field:'pd_inwhname',width:100
                        }],
                        dbColumns:[{
                            "text": "仓库ID",
                            "flex": 0,
                            "dataIndex": "id",
                            "width": 0,
                            "xtype": "",
                            "items": null
                        },{
                            "text": "仓库编号",
                            "flex": 1,
                            "dataIndex": "wh_code",
                            "width": 100,
                            "xtype": "",
                            "items": null
                        }, {
                            "text": "仓库名称",
                            "flex": 1,
                            "dataIndex": "wh_description",
                            "xtype": "",
                            "items": null
                        }, ]
                    }) ;   

                }
            }            

        });

    },
    addCombo:function(){
        var combo=this.ownerCmp;
        Ext.create('Ext.window.Window',{
            layout:'vbox',
            bodyPadding: 15,
            width:500,
            items:[{
                fieldLabel:'实际值',
                xtype:'textfield'
            },{
                fieldLabel:'显示值',
                xtype:'textfield'
            }],
            buttons:[{
                text:'确认',
                handler:function(b){
                    combo.setValue('ok');
                    b.up('window').close();
                }
            }],
            renderTo:this.ownerCmp.ownerCt.getEl()
        }).show();

    }
});