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: 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 });