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',
    caller: 'Purchase',
    importUploadPath: '/api/purchase/purchase/saveToFormal',

    initComponent: function () {
        Ext.apply(this, {
            queryFormItems: [{
                xtype: 'textfield',
                name: 'pu_code',
                labelSeparator: ' ',
                emptyText: '请输入单号或供应商名称',
                getCondition: function (value) {
                    return ' (pu_code like\'%' + value + '%\' or pu_vendcode like \'%' + value + '%\' or pu_vendname like \'%' + value + '%\') ';
                }
            }, {
                margin: '0 0 0 20',
                xtype: 'productDbfindTrigger',
                name: 'pr_detail',
                showDetail: true,
                emptyText: '输入物料编号、名称或型号',
            }, {
                xtype: 'condatefield',
                name: 'pu_date',
                fieldLabel: '日期',
                columnWidth: 0.5,
                operation: 'between'
            }, {
                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',
                    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, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 2, true);
                    }
                }, {
                    text: '价税合计(元)',
                    dataIndex: 'pu_total',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer: function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 2, true);
                    }
                }, {
                    text: '币别',
                    dataIndex: 'pu_currency',
                    align: 'center',
                    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: 'B2B上传状态',
                    dataIndex: 'b2bStatus',
                    textAlign: 'center',
                    width:120,
                    hidden: !Ext.getCmp('mainView').getViewModel().get('enableB2B'),
                    initHidden: !Ext.getCmp('mainView').getViewModel().get('enableB2B'),
                    renderer: function(v) {
                        return v ? v : '待上传'
                    }
                }, {
                    text: '备注',
                    dataIndex: 'pu_remark',
                    width: 250
                }],
                relativeColumn: [{
                    text: 'id',
                    dataIndex: 'pu_id',
                    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, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 3, false);
                    }
                }, {
                    text: '单位',
                    dataIndex: 'pr_unit',
                    width: 65
                }, {
                    text: '单价(元)',
                    dataIndex: 'pd_taxprice',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer: function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 4, true);
                    }
                }, {
                    text: '含税单价(元)',
                    dataIndex: 'pd_price',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer: function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 4, true);
                    }
                }, {
                    text: '金额(元)',
                    dataIndex: 'pd_taxtotal',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer: function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 2, true);
                    }
                }, {
                    text: '税率(%)',
                    dataIndex: 'pd_taxrate',
                    xtype: 'numbercolumn',
                    width: 80,
                    renderer : function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 0, 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_lastprice',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer: function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 4, true);
                    }
                },{
                    text: '价税合计(元)',
                    dataIndex: 'pd_total',
                    xtype: 'numbercolumn',
                    width: 110,
                    renderer: function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 2, true);
                    }
                }, {
                    text: '币别',
                    dataIndex: 'pu_currency',
                    align: 'center',
                    width: 65
                }, {
                    text: "汇率",
                    dataIndex: "pu_rate",
                    xtype: 'numbercolumn',
                    width: 80,
                    renderer: function(v, m, r) {
                        return saas.util.BaseUtil.numberFormat(v, 6, false);
                    }
                }, {
                    text: '关联销售单号',
                    dataIndex: 'pd_salecode',
                    width: 150
                }, {
                    text: '备注',
                    dataIndex: 'pd_remark',
                    width: 250
                }]
            }
        });
        this.callParent(arguments);
    },
});