saas-platform/frontend/saas-web/app/view/home/infoCardList/SaleOut.js

/**
 * 待出货销售
 */
Ext.define('saas.view.home.infoCardList.SaleOut', {
    extend: 'saas.view.home.infoCardList.InfoList',
    xtype: 'home-infocardlist-saleout',

    listUrl: '/api/sale/sale/list',
    idField: 'sa_id',
    codeField: 'sa_code',
    detailTitle: '销售订单',
    detailXType: 'sale-sale-formpanel',
    condition: 'sale.companyid=#{companyId} and sa_statuscode=\'AUDITED\' and exists (select 1 from saledetail detail where sd_id=saledetail.sd_id and  IFNULL(sd_sendqty,0)<ifnull(sd_qty,0) and TO_DAYS(sd_delivery)-TO_DAYS(now())<= 7)',
    listColumns: [{
        text: 'id',
        dataIndex: 'sa_id',
        hidden: true,
        xtype: 'numbercolumn'
    }, {
        text: '单据编号',
        dataIndex: 'sa_code',
        width: 150
    }, {
        text: '单据状态',
        align: 'center',
        dataIndex: 'sa_status',
        width: 90
    }, {
        text: '业务状态',
        align: 'center',
        dataIndex: 'sa_sendstatus',
        width: 90
    }, {
        text: '单据日期',
        dataIndex: 'sa_date',
        xtype: 'datecolumn',
        width: 110
    }, {
        text: '客户名称',
        dataIndex: 'sa_custname',
        width: 200
    }, {
        text: '明细序号',
        dataIndex: 'sd_detno',
        xtype: 'numbercolumn',
        width: 100,
        renderer: function(v, m, r) {
            return Ext.util.Format.number(v, '0');
        }
    }, {
        text: '物料编号',
        dataIndex: 'sd_prodcode',
        width: 150
    }, {
        text: '品牌',
        dataIndex: 'pr_brand',
        width: 200
    }, {
        text: '物料名称',
        dataIndex: 'pr_detail',
        width: 200
    }, {
        text: '型号',
        dataIndex: 'pr_orispeccode',
        width: 200
    }, {
        text: '规格',
        dataIndex: 'pr_spec',
        width: 150
    }, {
        text: '规格',
        dataIndex: 'pr_spec',
        width: 150
    }, {
        text: '数量',
        dataIndex: 'sd_qty',
        xtype: 'numbercolumn',
        width: 110,
        renderer: function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 3, false);
        },
    }, {
        text: '单位',
        dataIndex: 'pr_unit',
        width: 80
    }, {
        text: '单价(元)',
        dataIndex: 'sd_price',
        xtype: 'numbercolumn',
        width: 110,
        renderer: function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 4, true);
        },
    }, {
        text: '已出货数',
        dataIndex: 'sd_sendqty',
        xtype: 'numbercolumn',
        width: 110,
        renderer: function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 3, false);
        },
    }, {
        text: '备注',
        dataIndex: 'sd_remark',
        width: 250
    }],

});