saas-platform/frontend/saas-web/app/view/purchase/purchase/QueryPanel.js

Ext.define('saas.view.purchase.purchase.QueryPanel', {
    extend: 'saas.view.core.query.QueryPanel',
    xtype: 'purchase-purchase-querypanel',

    controller: 'purchase-purchase-querypanel',
    viewModel: 'purchase-purchase-querypanel',

    viewName: 'purchase-purchase-querypanel',
    
    queryFormItems: [{
        xtype: 'textfield',
        name: 'pu_code',
        fieldLabel: ' ',
        labelSeparator:' ',
        emptyText:'请输入单号或供应商',
        getCondition: function(value) {
            return  ' (pu_code like\'%' + value + '%\' or pu_vendcode like \'%'+value+'%\' or pu_vendname like \'%'+value+'%\') ';
        }
    }, {
        xtype: 'condatefield',
        name: 'pu_date',
        fieldLabel: '日期',
        columnWidth: 0.5,
        operation: 'between'
    }, {
        xtype: 'productDbfindTrigger',
        name: 'pr_detail',
        fieldLabel: '物料',
        showDetail: true,
        emptyText:'输入物料编号或名称',
    }, {
        xtype: 'combobox',
        name: 'pu_statuscode',
        fieldLabel: '单据状态',
        queryMode: 'local',
        displayField: 'pu_status',
        valueField: 'pu_statuscode',
        emptyText :'全部',
        editable:false,
        store: Ext.create('Ext.data.ArrayStore', {
            fields: ['pu_statuscode', 'pu_status'],
            data: [
                ["ALL", "全部"],
                ["AUDITED", "已审核"],
                ["UNAUDITED", "未审核"]
            ]
        }),
        getCondition: function(value) {
            if(value == 'ALL') {
                return '1=1';
            }else {
                return 'pu_statuscode=\'' + value + '\'';
            }
        }
    }, {
        xtype: 'multicombo',
        name: 'pu_acceptstatuscode',
        fieldLabel: '业务状态',
        emptyText :'全部',
        datas: [
            ["TURNIN", "已入库"],
            ["UNTURNIN", "未入库"],
            ["PART2IN", "部分入库"],
            ["CLOSE", "已关闭"]
        ]
    }, {
        xtype: 'textfield',
        name: 'pu_sacode',
        fieldLabel: '关联销售单号',
        emptyText: '输入单号',
    }, {
        xtype: 'accountDbfindTrigger',
        name: 'creatorName',
        fieldLabel: '录入人',
        emptyText:'请输入账户名称或姓名',
        getCondition: function(value) {
            if(!value) {
                return '1=1';
            }else {
                return 'purchase.creatorName like\'%' + value + '%\'';
            }
        }
    }, {
        xtype: 'accountDbfindTrigger',
        name: 'pu_auditman',
        fieldLabel: '审核人',
        emptyText:'请输入账户名称或姓名'
    }],
    queryGridConfig: {
        idField: 'pu_id',
        codeField: 'pu_code',
        addTitle: '采购订单',
        addXtype: 'purchase-purchase-formpanel',
        defaultCondition:'',
        baseVastUrl: '/api/purchase/purchase/',
        caller:'Purchase',
        baseColumn: [
        {
            text: 'id',
            dataIndex: 'pu_id',
            width: 0,
            xtype: 'numbercolumn',
            hidden:true
        }, {
            text: '采购单号',
            dataIndex: 'pu_code',
            width: 150
        },{
            text: '单据日期',
            dataIndex: 'pu_date',
            xtype: 'datecolumn',
            width: 110
        },{
            text: '供应商名称',
            dataIndex: 'pu_vendname',
            width:200
        }, {
            text: '金额(元)',
            dataIndex: 'pu_taxtotal',
            xtype: 'numbercolumn',
            width: 110,
            renderer : function(v) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            }
        }, {
            text: '价税合计(元)',
            dataIndex: 'pu_total',
            xtype: 'numbercolumn',
            width: 110,
            renderer : function(v) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            }
        },{
            text: '币别',
            dataIndex: 'pu_currency',
            width: 65
        }, {
            text: '审核状态',
            align: 'center',
            dataIndex: 'pu_status',
            width: 80
        },{
            text: '业务状态',
            align: 'center',
            dataIndex: 'pu_acceptstatus',
            width: 80
        },{
            text: '采购员',
            dataIndex: 'pu_buyername',
            width: 80
        },{
            text: '关联销售单',
            dataIndex: 'pu_sacode',
            width: 150
        },{
            text: '备注',
            dataIndex: 'pu_remark',
            width: 250
        }],
        relativeColumn: [
        {
            text: 'id',
            dataIndex: 'pu_id',
            width: 0,
            hidden: true
        }, {
            text: '采购单号',
            dataIndex: 'pu_code',
            width: 150
        }, {
            text: '单据日期',
            dataIndex: 'pu_date',
            xtype: 'datecolumn',
            width: 110
        },{
            text: '供应商名称',
            dataIndex: 'pu_vendname',
            width: 200
        }, {
            text: '审核状态',
            align: 'center',
            dataIndex: 'pu_status',
            width: 80
        }, {
            text: '物料编号',
            dataIndex: 'pd_prodcode',
            width: 150
        },{
            text: '品牌',
            dataIndex: 'pr_brand',
            width: 100
        },{
            text: '物料名称',
            dataIndex: 'pr_detail',
            width: 150
        },{
            text: '型号',
            dataIndex: 'pr_orispeccode',
            width: 200
        },{
            text: '规格',
            dataIndex: 'pr_spec',
            width: 200
        },{
            text: '数量',
            dataIndex: 'pd_qty',
            xtype: 'numbercolumn',
            width: 110,
            renderer : function(v) {
                return saas.util.BaseUtil.numberFormat(v, 3, true);
            }
        }, {
            text: '单位',
            dataIndex: 'pr_unit',
            width: 65
        }, {
            text: '单价(元)',
            dataIndex: 'pd_taxprice',
            xtype: 'numbercolumn',
            width: 110,
            renderer : function(v) {
                return saas.util.BaseUtil.numberFormat(v, 4, true);
            }
        },{
            text: '金额(元)',
            dataIndex: 'pd_taxtotal',
            xtype: 'numbercolumn',
            width: 110,
            renderer : function(v) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            }
        },{
            text: '税额(元)',
            dataIndex: 'pd_taxamount',
            xtype: 'numbercolumn',
            width: 110,
            renderer : function(v,g,r) {
                v = (r.data["pd_total"]||0.0) - (r.data["pd_taxtotal"]||0.0);
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            }
        },{
            text: '价税合计(元)',
            dataIndex: 'pd_total',
            xtype: 'numbercolumn',
            width: 110,
            renderer : function(v) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            }
        }, {
            text: '关联销售单号',
            dataIndex: 'pd_salecode',
            width: 150
        }, {
            text: '备注',
            dataIndex: 'pd_remark',
            width: 250
        }]
    }
});