saas-one/frontend/saas-web/app-make/app/view/make/makeBase/QueryPanel_1.js

Ext.define('make.view.make.makeBase.QueryPanel_1', {
    extend: 'saas.view.core.query.QueryPanel',
    xtype: 'make-makebase-querypanel-1',

    controller: 'make-makebase-querypanel',
    viewModel: {
        extend: 'saas.view.core.query.QueryPanelModel',
        data: {
            form: {}, // 查询字段记录
            addEnable: false, // 显示新增按钮
            auditEnable: false, // 显示审核按钮
            printEnable: false, // 显示打印按钮
            importEnable: false, // 显示导入按钮
            exportEnable: true, // 显示导出按钮
            closeEnable: false, // 显示关闭按钮
            deleteEnable: false, // 显示删除按钮
            deleteDisable:false, //删除按钮是否可使用
            
            openAudit:false,//单独显示审核按钮
            openUnAudit:true,//单独显示反审核按钮
            openEnable:false, //显示开启  针对已取消列表
            configurable: true, // 允许列设置
            
        }
    },

    viewName: 'make-makebase-querypanel',
    caller: 'MakeBase',
    //importUploadPath: '/api/purchse/makereturn/saveToFormal',

    initComponent: function () {
        var me = this;
        Ext.apply(this, {
            queryFormItems: [{
                xtype: 'condatefield',
                name: 'make.createTime',
                fieldLabel: '日期',
                columnWidth: 0.4,
                minWidth:430,
                value: '7',
                operation: 'between',
            },{
                xtype: 'multiqueryField',
                columnWidth: 0.4,
                name: 'multi_query',
                querys: {
                    "Prod": {"field": "ma_prodcode", "dbfinds": [{//物料
                        from: 'pr_code',
                        to: 'ma_prodcode'
                    },{
                        from: 'pr_detail',
                        to: 'pr_detail'
                    }]},
                    "MakeCode": {"field": "ma_code" ,"desc": "制造单号"},
                    "BillCode": {"field": "ma_salecode" ,"desc": "订单号"},
                    "Cust": {"field": "ma_custname", "dbfinds": [{
                        from: 'cu_name',
                        to: 'ma_custname'
                     }]},  
                    "Emp":{"field": "make.creatorName", "dbfinds": [{
                            from: 'em_name',
                            to: 'make.creatorName'
                        }]},
                },
                setShowDetail: function(v){
                    this.showDetail = false;
                }
            },{
                xtype: 'checkbox',
                boxLabel: '展开明细',
                name:'showDetail',
                showDetail: true,
                columnWidth: 0.1,
                minWidth:75,
                margin: '0 0 0 8',
                getCondition: function (value) {
                     return '1=1';
                },
                listeners:{
                    change:function(t,n,o){
                        if(n != o){
                            var grid = t.ownerCt.ownerCt.down('core-query-querygridpanel');
                            /*groupField:'ma_code',
                            groupHeaderTpl: Ext.create('Ext.XTemplate',
                            '<div  class="groupHeaderTpl" style="margin:0px 0px 0px 120px">',
                            '<span style="width:280px">制造单号：{[values.rows[0].data.ma_code]}</span>',
                            '<span style="width:140px">销售单号：{[values.rows[0].data.sa_currency]}</span>',
                            '<span style="width:140px">客户名称：{[values.rows[0].data.sa_currency]}</span>',
                            '<span style="width:140px">交货日期：{[values.rows[0].data.sa_currency]}</span>',
                            '<span style="width:140px">产品编号：{[values.rows[0].data.sa_currency]}</span>',
                            '<span style="width:140px">产品名称：{[values.rows[0].data.sa_currency]}</span>',
                            '<span style="width:140px">产品规格：{[values.rows[0].data.sa_currency]}</span>',
                            '<span style="width:140px">数量：{[values.rows[0].data.sa_currency]}</span>',
                            '<span style="width:140px">已完工数：{[values.rows[0].data.sa_currency]}</span>',
                            '</div>'
                            ),*/
                            grid.store.load();
                        }
                    }
                }
            }],
            moreQueryFormItems: [{
                xtype: 'saledetailDbfindTrigger',
                name: 'ma_salecode',
                fieldLabel: '订单编号'
            },{
                xtype: "customerDbfindTrigger",
                name: "ma_custname",
                fieldLabel: "客户名称",
            },{
                xtype: 'condatefield',
                name: 'ma_delivery',
                fieldLabel: '交货日期',
                value:7,
                columnWidth: 1
            },{
                xtype: 'productDbfindTrigger',
                name: 'ma_prodcode',
                fieldLabel: '物料编号'
            },{
                xtype: 'textfield',
                name: 'pr_detail',
                fieldLabel: '产品名称',
                readOnly: true,
            }, {
                xtype: 'textfield',
                name: 'pr_orispeccode',
                fieldLabel: '产品型号',
                readOnly: true,
            }, {
                xtype: "remotecombo",
                name: "pr_brand",
                fieldLabel: "厂家/品牌",
                storeUrl: '/api/document/productbrand/getCombo',
                editable: false,
                hiddenBtn:true
            },{
                xtype: "remotecombo",
                name: "ma_kind",
                fieldLabel: "制造类型",
                storeUrl:'/api/make/kind/list/make',
                valueField:'mk_name',
                displayField: 'mk_name',
                editable: false,
                hiddenBtn:true
            },{
                xtype: 'remotecombo',
                name: "ma_wcname",
                fieldLabel: "工作中心",
                storeUrl: '/api/document/workcenter/getCombo',
                editable: false,
                hiddenBtn:true
            },{
                xtype: 'combobox',
                name: 'ma_statuscode',
                fieldLabel: '审核状态',
                queryMode: 'local',
                displayField: 'ma_status',
                valueField: 'ma_statuscode',
                emptyText :'全部',
                editable:false,
                store: Ext.create('Ext.data.ArrayStore', {
                    fields: ['ma_statuscode', 'ma_status'],
                    data: [
                        ["ALL", "全部"],
                        ["AUDITED", "已审核"],
                        ["UNAUDITED", "未审核"]
                    ]
                }),
                getCondition: function(value) {
                    if(value == 'ALL') {
                        return '1=1';
                    }else {
                        return 'ma_statuscode=\'' + value + '\'';
                    }
                }
            }, {
                xtype: 'employeeDbfindTrigger',
                name: 'creatorName',
                fieldLabel: '录入人',
                emptyText:'请输入账户名称或姓名',
                getCondition: function(value) {
                    if(!value) {
                        return '1=1';
                    }else {
                        return 'make.creatorName like\'%' + value + '%\'';
                    }
                }
            },{
                xtype: 'condatefield',
                name: 'ma_planbegindate',
                fieldLabel: '计划开工日期',
                value:7,
                columnWidth: 1
            },{
                xtype: 'condatefield',
                name: 'ma_planenddate',
                fieldLabel: '计划完工日期',
                value:7,
                columnWidth: 1
            },{
                xtype: 'condatefield',
                name: 'make.createTime',
                fieldLabel: '录入日期',
                value:7,
                columnWidth: 1
            }, {
                xtype: 'employeeDbfindTrigger',
                name: 'ma_auditman',
                fieldLabel: '审核人',
                emptyText:'请输入账户名称或姓名',
            }],
            queryGridConfig: {
                idField: 'ma_id',
                codeField: 'ma_code',
                mainIdField:'ma_id',
                detailIdField:'mm_id',
                addTitle: '制造单',
                addXtype: 'make-makebase-formpanel',
                baseVastUrl: '/api/make/make/',
                caller: 'MakeBase',
                defaultCondition:me.defaultCondition,
                toolBtns: [{
                    text: '转领料',
                    xtype: 'button',
                    handler: 'onPick',
                },{
                    text: '结案',
                    xtype: 'button',
                    handler: 'onEnd',
                }],
                baseColumn: [{
                    text: 'id',
                    dataIndex: 'ma_id',
                    hidden: true,
                    xtype: 'numbercolumn'
                }, {
                    text: '制造单号',
                    dataIndex: 'ma_code',
                    width: 150
                }, {
                    text: '单据日期',
                    dataIndex: 'createTime',
                    xtype: 'datecolumn',
                    width: 110
                }, {
                    text: '销售单号',
                    dataIndex: 'ma_salecode',
                    width: 0
                }, {
                    text: '客户名称',
                    dataIndex: 'ma_custname',
                    width: 150
                }, {
                    text: '交货日期',
                    align: 'center',
                    dataIndex: 'ma_delivery',
                    width: 110,
                    xtype:'datecolumn'
                },{
                    text: '产品编号',
                    dataIndex: 'ma_prodcode',
                    width: 150
                },{
                    text: '产品名称',
                    dataIndex: 'ma_prdetail',
                    width: 150
                },{
                    text: '产品型号',
                    dataIndex: 'ma_prorispeccode',
                    width: 150,
                    renderer : saas.util.RenderUtil['renderer_makeprod']
                },{
                    text: '单位',
                    align: 'center',
                    dataIndex: 'ma_prunit',
                    width: 80
                },{
                    text: '数量',
                    align: 'center',
                    dataIndex: 'ma_qty',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer : function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 6, true);
                    },
                },{
                    text: '已完工数',
                    align: 'center',
                    dataIndex: 'ma_madeqty',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer : function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 6, true);
                    },
                },{
                    text: '已领齐套数',
                    align: 'center',
                    dataIndex: 'ma_setqty',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer : function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 0, true);
                    },
                },{
                    text: '可完工数',
                    align: 'center',
                    dataIndex: 'ma_canmadeqty',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer : function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 6, true);
                    },
                },{
                    text: '制造类型',
                    dataIndex: 'ma_kind',
                    width: 100,
                },{
                    text: '工作中心',
                    dataIndex: 'ma_wcname',
                    width: 100,
                },{
                    text: '审核状态',
                    dataIndex: 'ma_status',
                    align: 'center',
                    width: 100,
                },{
                    text: '领料状态',
                    dataIndex: 'ma_getstatus',
                    align: 'center',
                    width: 100,
                },{
                    text: '完工状态',
                    dataIndex: 'ma_finishstatus',
                    align: 'center',
                    width: 100,
                },{
                    text: '制单人',
                    dataIndex: 'creatorName',
                    align: 'center',
                    width: 100,
                },{
                    text: '计划开工日期',
                    dataIndex: 'ma_planbegindate',
                    width: 130,
                    xtype:'datecolumn'
                },{
                    text: '计划完工日期',
                    dataIndex: 'ma_planenddate',
                    width: 130,
                    xtype:'datecolumn'
                },{
                    text: '实际开工日期',
                    dataIndex: 'ma_actbegindate',
                    width: 130,
                    xtype:'datecolumn'
                },{
                    text: '实际完工日期',
                    dataIndex: 'ma_actenddate',
                    width: 130,
                    xtype:'datecolumn'
                },{
                    text: '结案日期',
                    dataIndex: 'ma_enddate',
                    width: 130,
                    xtype:'datecolumn'
                },{
                    text: '备注',
                    dataIndex: 'ma_remark',
                    width: 100
                }],
                relativeColumn: [{
                    text: 'id',
                    dataIndex: 'id',
                    hidden: true,
                    xtype: 'numbercolumn'
                },{
                    text: '本次数量',
                    align: 'center',
                    dataIndex: 'mm_thisqty',
                    xtype: 'widgetcolumn',  
                    width: 110,
                    widget: {
                        xtype: "numberfield",
                        cls:'widget-number',
                        bind: '{record.mm_thisqty}',
                        decimalPrecision: 6,
                        minValue: 0,
                        listeners:{
                            blur: function(f ,event, e){
                                var record = f.lookupViewModel().data.record,
                                    maxVal,nowVal;
                                if(record){
                                    if(!Ext.isEmpty(record.modified['mm_thisqty'])){  //若存在修改
                                        maxVal = record.modified['mm_thisqty'];
                                        nowVal = f.value;
                                        if(Ext.isEmpty(nowVal)){
                                            record.set('mm_thisqty', maxVal)
                                        }else if(nowVal>maxVal){
                                            record.set('mm_thisqty', maxVal)
                                            saas.util.BaseUtil.showErrorToast('请不要输入超过最大数量' + maxVal + "的值!");
                                        }
                                    }
                                }
                            }
                        }
                    }
                },{
                    text: '制造单号',
                    dataIndex: 'ma_code',
                    width: 150
                }, {
                    text: '单据日期',
                    dataIndex: 'createTime',
                    xtype: 'datecolumn',
                    width: 110
                },{
                    text: '工单序号',
                    dataIndex: 'mm_detno',
                    align: 'center',
                    width: 80
                },{
                    text: '物料编号',
                    dataIndex: 'mm_prodcode',
                    width: 150
                },{
                    text: '物料名称',
                    dataIndex: 'pr_detail',
                    width: 150
                },{
                    text: '物料规格',
                    dataIndex: 'pr_desc',
                    width: 150
                },{
                    text: '单位',
                    align: 'center',
                    dataIndex: 'pr_unit',
                    width: 80
                },{
                    text: '单位用量',
                    align: 'center',
                    dataIndex: 'mm_oneuseqty',
                    width: 80
                },{
                    text: '需求数',
                    align: 'center',
                    dataIndex: 'mm_qty',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer : function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 6, true);
                    },
                },{
                    text: '已领数',
                    align: 'center',
                    dataIndex: 'mm_havegetqty',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer : function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 6, true);
                    },
                },{
                    text: '已转领数',
                    align: 'center',
                    dataIndex: 'mm_turngetqty',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer : function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 6, true);
                    },
                },{
                    text: '未领数',
                    align: 'center',
                    dataIndex: 'mm_restgetqty',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer : function(v, m, r) {
                        v = r.get('mm_qty') + (r.get('mm_scrapqty')||0) - (r.get('mm_havegetqty')||0)-(r.get('mm_turngetqty')||0);
                        return saas.util.BaseUtil.numberFormat(v, 6, true);
                    }
                },{
                    text: '制程不良数',
                    align: 'center',
                    dataIndex: 'mm_returnmqty',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer : function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 6, true);
                    },
                },{
                    text: '报废数',
                    align: 'center',
                    dataIndex: 'mm_turnscrapqty',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer : function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 6, true);
                    },
                },{
                    text: '备注',
                    dataIndex: 'ma_remark',
                    width: 100
                }]
            }
        });
        this.callParent(arguments);
    },
});