Ext.define('make.view.osmake.osMake.BenchQueryPanel', { extend: 'saas.view.core.bench.Query', xtype: 'osmake-osmake-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:'OsMake', items: [ { itemId: 'All', xtype: 'osmake-osmake-querypanel', defaultCondition:"ma_tasktype='OS'", importUploadPath: '/api/make/make/saveToFormal', }, { //待领料 itemId: 'osmake-osmake-benchpanel-1', xtype: 'osmake-osmake-querypanel-1', defaultCondition: "ma_tasktype='OS' 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) and ma_statuscode='AUDITED' ", _needCount: true, }, { //待完工 itemId: 'osmake-osmake-benchpanel-2', xtype: 'osmake-osmake-querypanel-2', defaultCondition: "ma_tasktype='OS' and ma_statuscode='AUDITED'",//AND ma_qty>ifnull(ma_madeqty,0) _needCount: true, caller:'OsMakeIn' }, { //已完工 itemId: 'osmake-osmake-benchpanel-3', xtype: 'osmake-osmake-querypanel-3', defaultCondition: "ma_tasktype='OS' AND ma_qty<=ifnull(ma_madeqty,0) ", _needCount:false, }, { //已结案 itemId: 'osmake-osmake-benchpanel-4', xtype: 'osmake-osmake-querypanel-4', defaultCondition: "ma_tasktype='OS' AND ma_statuscode='END'", _needCount: false, }, { //超期未结案 itemId: 'osmake-osmake-benchpanel-5', xtype: 'osmake-osmake-querypanel-5', defaultCondition: "ma_tasktype='OS' 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/osCount', addBtnText:'新增外协单', hiddenMe:true });