saas-one/frontend/saas-web/app-make/app/view/osmake/osMakeCheckIn/QueryPanel3.js

Ext.define('make.view.osmake.osMakeCheckIn.QueryPanel_3', {
    extend: 'saas.view.core.query.QueryPanel',
    xtype: 'osmake-osmakecheckin-querypanel-3',

    controller: 'osmake-osmakecheckin-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:false,//单独显示反审核按钮
            cancelEnable:false, //单独显示取消
            openEnable:false, //显示开启  针对已取消列表
            configurable: true, // 允许列设置
            
        }
    },

    viewName: 'osmake-osmakecheckin-querypanel',
    caller: 'OsMakeIn',
    //importUploadPath: '/api/osmake/osmakecheckin/saveToFormal',

    initComponent: function () {
        var me = this;
        Ext.apply(me, {
            queryFormItems: [ {
                xtype: 'condatefield',
                name: 'pi_date',
                fieldLabel: '日期',
                columnWidth: 0.5,
                value: '7',
                operation: 'between',
            },{
                xtype: 'multiqueryField',
                columnWidth: 0.4,
                name: 'multi_query',
                querys: {
                    "Vend":{"field": "pi_vendname", "dbfinds": [{//仓库
                            from: 've_name',
                            to: 'pi_vendname'
                        }]},
                    "BillCode": {"field": "pi_inoutno" ,"desc": "验收单号"},
                    "MakeCode": {"field": "prodiodetail.pd_ordercode" ,"desc": "外协单号"},
                    "Prod": {"field": "pr_code", "dbfinds": [{//物料
                            from: 'pr_code',
                            to: 'pr_code'
                        },{
                            from: 'pr_detail',
                            to: 'pr_detail'
                        }]},
                    "Emp":{"field": "prodinout.creatorName", "dbfinds": [{
                            from: 'em_name',
                            to: 'prodinout.creatorName'
                        }]},
                },
                setShowDetail: function(v){
                    this.showDetail = (v == 'Prod' ||v=='MakeCode');
                },
            }],
            moreQueryFormItems: [{
                xtype: 'condatefield',
                name: 'pi_date',
                fieldLabel: '单据日期',
                columnWidth: 1
            },{
                xtype: 'vendorDbfindTrigger',
                name: 'pi_vendname',
                fieldLabel: '外协厂商'
            },{
                xtype: 'combobox',
                name: 'pi_currency',
                fieldLabel: '币别',
                queryMode: 'local',
                displayField: 'pi_currency',
                valueField: 'pi_currency',
                emptyText :'',
                editable:false,
                store: Ext.create('Ext.data.ArrayStore', {
                    fields: ['pi_currency', 'pi_currency'],
                    data: [
                        ["RMB", "RMB"],
                        ["USD", "USD"],
                        ["HKD", "HKD"]
                    ]
                }),
                getCondition: function(value) {
                    if(!value) {
                        return '1=1';
                    }else {
                        return 'pi_currency=\'' + value + '\'';
                    }
                }
            },{
                xtype: 'warehouseDbfindTrigger',
                name: 'pi_whname',
                fieldLabel: '仓库'
            },{
                xtype: 'productDbfindTrigger',
                name: 'prodiodetail.pd_prodcode',
                showDetail: true,
                fieldLabel: '物料编号'
            },{
                xtype: 'textfield',
                name: 'pr_detail',
                fieldLabel: '产品名称',
                readOnly: true,
            }, {
                xtype: 'textfield',
                name: 'pr_orispeccode',
                fieldLabel: '产品型号',
                readOnly: true,
            }, {
                editable: false,
                xtype: "remotecombo",
                storeUrl: '/api/document/productbrand/getCombo',
                name: "pr_brand",
                fieldLabel: "厂家/品牌",
                hiddenBtn:true
            },{
                xtype: 'combobox',
                name: 'pi_statuscode',
                fieldLabel: '审核状态',
                queryMode: 'local',
                displayField: 'pi_status',
                valueField: 'pi_statuscode',
                emptyText :'全部',
                editable:false,
                store: Ext.create('Ext.data.ArrayStore', {
                    fields: ['pi_statuscode', 'pi_status'],
                    data: [
                        ["ALL", "全部"],
                        ["AUDITED", "已审核"],
                        ["UNAUDITED", "未审核"]
                    ]
                }),
                getCondition: function(value) {
                    if(value == 'ALL') {
                        return '1=1';
                    }else {
                        return 'pi_statuscode=\'' + value + '\'';
                    }
                }
            }, {
                xtype: 'employeeDbfindTrigger',
                name: 'creatorName',
                fieldLabel: '录入人',
                emptyText:'请输入账户名称或姓名',
                getCondition: function(value) {
                    if(!value) {
                        return '1=1';
                    }else {
                        return 'prodinout.creatorName like\'%' + value + '%\'';
                    }
                }
            }, {
                xtype: 'employeeDbfindTrigger',
                name: 'pi_auditman',
                fieldLabel: '审核人',
                emptyText:'请输入账户名称或姓名',
            }],
            queryGridConfig: {
                idField: 'id',
                codeField: 'pi_inoutno',
                mainIdField:'_id',
                detailIdField:'pd_id',
                addTitle: me.addTitle,
                addXtype: me.addXtype,
                defaultCondition: me.defaultCondition,
                baseVastUrl: me.baseVastUrl,
                groupField: 'vendname_currency',
                groupHeaderTpl: Ext.create('Ext.XTemplate',
                    '<div  class="groupHeaderTpl" style="margin:0px 0px 0px 120px">',
                    '<span style="width:280px">供应商：{[values.rows[0].data.pi_vendname]}</span>',
                    '<span style="width:140px">币种：{[values.rows[0].data.pi_currency]}</span>',
                    '</div>'
                ),
                openTab:function(record,codeValue,idValue){
                    if(record.get('pi_class')=='OSMAKEIN'){
                        openXtype   =   'osmake-osmakecheckin-formpanel';
                        addTitle    =   '外协验收';
                    }else{
                        openXtype   =   'osmake-osmakecheckreturn-formpanel';
                        addTitle    =   '外协验退';
                    }
                    id = openXtype + '-' + idValue;
                    saas.util.BaseUtil.openTab(openXtype, addTitle+"("+codeValue+")", id, {
                        initId: idValue
                    });
                },
                onGroupClick: function(view, group, idx, e){
                },
                caller: 'OsMakeIn',
                toolBtns: [{
                    xtype: 'button',
                    text: '对账',
                    handler: 'turnApCheck'
                }],
                baseColumn: [{
                    text: 'id',
                    dataIndex: 'id',
                    hidden: true,
                    xtype: 'numbercolumn'
                }, {
                    text: '入库单号',
                    dataIndex: 'pi_inoutno',
                    width: 150
                },{
                    text: '供应商币别',
                    dataIndex: 'vendname_currency',
                    hidden:true
                }, {
                    text: '单据类型',
                    dataIndex: 'pi_class',
                    hidden: true
                }, {
                    text: '单据日期',
                    dataIndex: 'pi_date',
                    xtype: 'datecolumn',
                    width: 110
                }, {
                    text: '供应商名称',
                    dataIndex: 'pi_vendname',
                    width: 200
                }, {
                    text: '金额(元)',
                    xtype: 'numbercolumn',
                    dataIndex: 'pi_nettotal',
                    width: 110,
                    renderer: function(v, m, r) {
                        let inqty=r.get('pd_inqty');
                        
                        inqty=   inqty==null ? 0: inqty;
                        if(inqty>0){
                            return saas.util.BaseUtil.numberFixFormat(v,2, true);
                        }else{
                            return saas.util.BaseUtil.numberFixFormat((0-v),2, true);
                        }
                    }
                }, {
                    text: '价税合计(元)',
                    xtype: 'numbercolumn',
                    dataIndex: 'pi_total',
                    width: 110,
                    renderer: function(v, m, r) {
                        let inqty=r.get('pd_inqty');
                        
                        inqty=   inqty==null ? 0: inqty;
                        if(inqty>0){
                            return saas.util.BaseUtil.numberFixFormat(v,2, true);
                        }else{
                            return saas.util.BaseUtil.numberFixFormat((0-v),2, true);
                        }
                    }
                }, {
                    text: '币种',
                    dataIndex: 'pi_currency',
                    align: 'center',
                    width: 65
                }, {
                    text: '审核状态',
                    align: 'center',
                    dataIndex: 'pi_status',
                    width: 80
                }, {
                    text: '付款状态',
                    align: 'center',
                    dataIndex: 'pi_prstatus',
                    width: 80
                }, {
                    text: '关联委协工单号',
                    dataIndex: 'pd_ordercode',
                    width: 150
                }, {
                    text: '备注',
                    dataIndex: 'pi_remark',
                    width: 250
                }],
                relativeColumn: [{
                    text: 'id',
                    dataIndex: 'id',
                    xtype: 'numbercolumn',
                    hidden: true  
                },{
                    text: '供应商币别',
                    dataIndex: 'vendname_currency',
                    hidden:true
                },{
                    text: 'pd_id',
                    dataIndex: 'pd_id',
                    xtype: 'numbercolumn',
                    hidden: true                    
                }, {
                    text: '入库单号',
                    dataIndex: 'pi_inoutno',
                    width: 150,
                    exportStyle:{
                        width: 150
                    }
                }, {
                    text: '单据日期',
                    dataIndex: 'pi_date',
                    xtype: 'datecolumn',
                    hidden:true,
                    exportStyle:{
                        width: 110
                    }
                }, {
                    text: '供应商名称',
                    dataIndex: 'pi_vendname',
                    hidden:true,
                    exportStyle:{
                        width: 200
                    }
                    
                },{
                    text: '币种',
                    dataIndex: 'pi_currency',
                    align: 'center',
                    hidden:true,
                    exportStyle:{
                        width: 65
                    }
                },{
                    text: '序号',
                    dataIndex: 'pd_pdno',
                    xtype: 'numbercolumn',
                    align:'center',
                    width: 60,
                    renderer : function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 0, false);
                    },
                }, {
                    text: '物料名称',
                    dataIndex: 'pr_detail',
                    width: 150
                }, {
                    text: '型号',
                    dataIndex: 'pr_orispeccode',
                    width: 200,
                    renderer: saas.util.RenderUtil['renderer_prod']
                }, {
                    text: '入库数',
                    dataIndex: 'pd_inqty',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer: function(v, m, r) {
                        let outqty=r.get('pd_outqty'),
                        inqty=r.get('pd_inqty');
                        
                        inqty=   inqty==null ? 0: inqty;
                        outqty=   outqty==null ? 0: outqty;
                        return saas.util.BaseUtil.numberFormat((inqty-outqty), 6, true);
                    }
                },  {
                    text: '类型',
                    dataIndex: 'pi_class',
                    width: 110,
                    renderer: function(v) {
                        if(v=="OSMAKEIN"){
                            return "外协验收";
                        }else if(v=="OSMAKEINBACK"){
                            return "外协验退";
                        }else if(v=="ESTIMATE"){
                            return "应付暂估";
                        }else{
                            return v;
                        }
                    }
                }, {
                    text: '物料编号',
                    dataIndex: 'pr_code',
                    width: 150
                }, {
                    text: '厂家/品牌',
                    dataIndex: 'pr_brand',
                    width: 100
                }, {
                    text: '规格',
                    dataIndex: 'pr_spec',
                    width: 200
                }, {
                    text: '不含税单价(元)',
                    dataIndex: 'pd_netprice',
                    xtype: 'numbercolumn',
                    renderer: function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 8, true);
                    },
                    width: 110
                }, {
                    text: '含税单价(元)',
                    dataIndex: 'pd_orderprice',
                    xtype: 'numbercolumn',
                    renderer: function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 8, true);
                    },
                    width: 110
                }, {
                    text: '不含税金额(元)',
                    dataIndex: 'pd_nettotal',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer: function(v, m, r) {
                        let inqty=r.get('pd_inqty');
                        
                        inqty=   inqty==null ? 0: inqty;
                        if(inqty>0){
                            return saas.util.BaseUtil.numberFixFormat(v,2, true);
                        }else{
                            return saas.util.BaseUtil.numberFixFormat((0-v),2, true);
                        }
                    },
                }, {
                    text: '关联委协工单号',
                    dataIndex: 'pd_ordercode',
                    width: 150
                }, {
                    text: '备注',
                    dataIndex: 'pd_remark',
                    width: 250
                }]
            }
        });
        this.callParent(arguments);
    },
    getQueryMode: function () {
        return 'DETAIL';
    }
});