saas-one/frontend/saas-web/app-make/app/view/make/makeBase/BenchQueryPanel.js

Ext.define('make.view.make.makeBase.BenchQueryPanel', {
    extend: 'saas.view.core.bench.Query',
    xtype: 'make-makebase-benchpanel',
    viewModel: {
        extend: 'saas.view.core.bench.QueryModel',
        stores: {
            menus: {
                model: 'saas.model.core.benchMenu',
                data: [
                    {desc: '待领料',isCount: 1},
                    {desc: '待完工',isCount: 1},
                    {desc: '已完工',isCount: 0},
                    {desc: '已结案',isCount: 0},
                    {desc: '超期未结案',isCount: 1},
                  ]
            }
        }
    },
    caller:'Make',
    items: [
        {
            itemId: 'All',
            xtype: 'make-makebase-querypanel',
            defaultCondition:"ma_tasktype='MAKE'",
            importUploadPath: '/api/make/make/saveToFormal',
        },
        {
            //待领料
            itemId: 'make-makebase-benchpanel-1',
            xtype: 'make-makebase-querypanel-1',
            defaultCondition: "ma_tasktype='MAKE' and ma_statuscode='AUDITED' and ifnull(ma_getstatus,'未领料') in('未领料','部分领料') and exists(select 1 from makematerial where mm_maid=ma_id and mm_qty-ifnull(mm_havegetqty,0)+ifnull(mm_scrapqty,0)-ifnull(mm_turngetqty,0)>0)",
            _needCount: true
        },
        {
            //待完工
            itemId: 'make-makebase-benchpanel-2',
            xtype: 'make-makebase-querypanel-2',
            defaultCondition: "ma_tasktype='MAKE' and ma_statuscode='AUDITED'",//AND ifnull(ma_madeqty,0)<ma_qty
            _needCount: true,
            caller:'MakeIn'
        },
        {
            //已完工
            itemId: 'make-makebase-benchpanel-3',
            xtype: 'make-makebase-querypanel-3',
            defaultCondition: "ma_tasktype='MAKE' AND ifnull(ma_madeqty,0)>=ma_qty",
            _needCount: false,
        },
        {
            //已结案
            itemId: 'make-makebase-benchpanel-4',
            xtype: 'make-makebase-querypanel-4',
            defaultCondition: "ma_tasktype='MAKE' AND ma_statuscode='END'",
            _needCount: false,
        },
        {
            //超期未结案
            itemId: 'make-makebase-benchpanel-5',
            xtype: 'make-makebase-querypanel-5',
            defaultCondition: "ma_tasktype='MAKE' AND ma_statuscode='AUDITED' and date_format(DATE_SUB(now(),INTERVAL (case when ifnull(mk_reminddays,0)<=0 then 1 else mk_reminddays end) DAY),'%Y-%m-%d')>date_format(ma_planenddate,'%Y-%m-%d')", //工单状态“已审核”2、当前日期-计划完工日期>=工单类型的【未结案提醒天数】
            _needCount: true,
        },
    ],
    countUrl:'make/make/count',
    addBtnText:'新增制造单',
    hiddenMe:true
});