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: 200
    }, {
        text: '单据状态',
        align: 'center',
        dataIndex: 'sa_status',
        width: 120
    }, {
        text: '单据日期',
        dataIndex: 'sa_date',
        xtype: 'datecolumn',
        width: 200
    }, {
        text: '客户名称',
        dataIndex: 'sa_custname',
        width: 120
    }, {
        text: '明细序号',
        dataIndex: 'sd_detno',
        xtype: 'numbercolumn',
        width: 120,
        renderer: function (v) {
            return Ext.util.Format.number(v, '0');
        }
    }, {
        text: '物料编号',
        dataIndex: 'sd_prodcode',
        width: 120
    }, {
        text: '物料名称',
        dataIndex: 'pr_detail',
        width: 120
    }, {
        text: '物料规格',
        dataIndex: 'pr_spec',
        width: 120
    }, {
        text: '数量',
        dataIndex: 'sd_qty',
        xtype: 'numbercolumn',
        width: 120,
        renderer: function (v) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length > 3 ? 3 : arr[1].length)).fill('0');
            var format = '0.' + xr.join();
            return Ext.util.Format.number(v, format);
        },
    }, {
        text: '单价',
        dataIndex: 'sd_price',
        xtype: 'numbercolumn',
        width: 120,
        renderer: function (v) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length > 8 ? 8 : arr[1].length)).fill('0');
            var format = '0,000.' + xr.join();
            return Ext.util.Format.number(v, format);
        },
    }, {
        text: '已转数',
        dataIndex: 'sd_yqty',
        xtype: 'numbercolumn',
        width: 120,
        renderer: function (v) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length > 3 ? 3 : arr[1].length)).fill('0');
            var format = '0.' + xr.join();
            return Ext.util.Format.number(v, format);
        },
    }, {
        text: '已出货数',
        dataIndex: 'sd_sendqty',
        xtype: 'numbercolumn',
        width: 120,
        renderer: function (v) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length > 3 ? 3 : arr[1].length)).fill('0');
            var format = '0.' + xr.join();
            return Ext.util.Format.number(v, format);
        },
    }, {
        text: '已审核采购单数',
        dataIndex: 'sd_pdqty',
        xtype: 'numbercolumn',
        width: 180,
        renderer: function (v) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length > 3 ? 3 : arr[1].length)).fill('0');
            var format = '0.' + xr.join();
            return Ext.util.Format.number(v, format);
        },
    }, {
        text: '备注',
        dataIndex: 'sd_remark',
        width: 250
    }],

});