saas-platform/frontend/saas-web/app/view/stock/report/ProdinoutCountController.js

Ext.define('saas.view.stock.report.ProdinoutCountController', {
    extend: 'saas.view.core.report.ReportPanelController',
    alias: 'controller.stock-report-prodinoutCount',
    init: function (form) {
        this.control({
           //放大镜赋值关系 以及 tpl模板
           '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'
                        }, {
                            from:'pr_spec',to:'pr_spec'
                        }],
                        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": "物料编号",       
                            "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,
                            xtype: 'numbercolumn',
                            align:'end'
                        },{
                            "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,
                            xtype: 'numbercolumn',
                            align:'end'
                        },{
                            "text": "L/T",
                            "dataIndex": "pr_leadtime",
                            "width": 100,
                        }]
                    }) ;   

                }
            },
            'dbfindtrigger[name=wh_description]':{
                beforerender:function(f){
                    Ext.apply(f,{
                        conditionCode:'wh_code',
                        dataUrl:'/api/document/warehouse/list',
                        addXtype: 'other-storeinformation',
                        addTitle: '仓库资料',
                        dbfinds:[{
                            from:'id',to:'id',ignore:true 
                        }, { 
                            from:'wh_code',to:'wh_code'
                        }, {
                            from:'wh_description',to:'wh_description'
                        }],
                        dbtpls:[{
                            field:'wh_code',width:100
                        },{
                            field:'wh_description',width:100
                        }],
                        defaultCondition: "wh_statuscode='OPEN'",
                        dbSearchFields:[{
                            emptyText:'输入物料编号、名称或规格',
                            xtype : "textfield", 
                            name : "search", 
                            width: 200,
                            getCondition: function(v) {
                                return "(upper(wh_code) like '%" + v.toUpperCase()+"%' or upper(wh_description) like '%"+v.toUpperCase()+"%')";
                            },
                            allowBlank : true, 
                            columnWidth : 0.25
                        }],
                        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": 0,
                            "dataIndex": "wh_type",
                            "width": 200,
                            "xtype": "",
                            "items": null
                        }, {
                            "text": "仓库状态",
                            "flex": 0,
                            "dataIndex": "wh_status",
                            "width": 200,
                            "xtype": "",
                            "items": null
                        }]
                    }) ;   

                }
            }
         });
        }
});