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

Ext.define('make.view.osmake.osMakeCheckIn.BenchQueryPanel', {
    extend: 'saas.view.core.bench.Query',
    xtype: 'osmake-osmakecheckin-benchpanel',
    viewModel:'osmake-osmakecheckin-benchquery',
    caller: 'OsMakeIn',
    items: [
        {
            itemId: 'All',
            xtype: 'osmake-osmakecheckin-querypanel',
            addTitle: '外协验收',
            addXtype: 'osmake-osmakecheckin-formpanel',
            defaultCondition: ' pi_class = \'OSMAKEIN\' ',
            baseVastUrl: '/api/make/prodinout/'
        },
        {
            //待完工
            itemId: 'osmake-osmakecheckin-benchpanel-1',
            xtype: 'osmake-osmakecheckin-querypanel-1',
            addTitle: '外协验收',
            addXtype: 'osmake-osmakecheckin-formpanel',
            defaultCondition: ' pi_class = \'OSMAKEIN\' and pi_statuscode <> \'AUDITED\' ',
            baseVastUrl: '/api/make/prodinout/',
            countGroupFields:'pi_inoutno',
            _needCount: true
        },
        {
            //已完工
            itemId: 'osmake-osmakecheckin-benchpanel-2',
            xtype: 'osmake-osmakecheckin-querypanel-2',
            addTitle: '外协验收',
            addXtype: 'osmake-osmakecheckin-formpanel',
            defaultCondition: ' pi_class = \'OSMAKEIN\' AND PI_STATUS = \'已审核\'  ',
            baseVastUrl: '/api/make/prodinout/',
            //countGroupFields:'pu_vendname,pu_currency',
            _needCount: true
        },{
            //待对账
            itemId: 'osmake-osmakecheckin-benchpanel-3',
            xtype: 'osmake-osmakecheckin-querypanel-3',
            countGroupFields:'pi_vendcode,pi_currency',
            baseVastUrl: '/api/make/prodinout/',
            defaultCondition:"((pi_status='已审核' and pi_class in('OSMAKEIN','OSMAKEINBACK')) or (pi_class='ESTIMATE' and prodiodetail.pd_type in ('外协验收','外协验退'))) "
            +"and ifnull(prodiodetail.apcheckStatus,' ')=' ' and ifnull(prodiodetail.pd_ordertotal,0)>ifnull(prodiodetail.pd_recamount,0)",
            _needCount: true
        },{
            //待开票
            itemId: 'osmake-osmakecheckin-benchpanel-4',
            xtype: 'osmake-osmakecheckin-querypanel-5',
            countGroupFields:'pi_vendcode,pi_currency',
            baseVastUrl: '/api/make/prodinout/',
            defaultCondition:"((pi_status='已审核' and pi_class in('OSMAKEIN','OSMAKEINBACK')) or(pi_class='ESTIMATE' and prodiodetail.pd_type in('外协验收','外协验退')))  "
            +"and abs(round(ifnull(prodiodetail.pd_ordertotal,0),2))>abs(round(ifnull(prodiodetail.pd_billamount,0),2))",
            _needCount: true
        },{
            //待付款
            itemId: 'osmake-osmakecheckin-benchpanel-5',
            xtype: 'osmake-osmakecheckin-querypanel-4',
            countGroupFields:'pi_vendcode,pi_currency',
            baseVastUrl: '/api/make/prodinout/',
            defaultCondition:"pi_status='已审核' and pi_class in('OSMAKEIN','OSMAKEINBACK') and exists(select 1 from prodiodetail b where b.pd_piid=pi_id and ifnull(b.pd_ordertotal,0)>ifnull(pd_recamount,0))",
            _needCount: true
        }
    ],
    hiddenMe:true,
    countUrl:'make/prodinout/osMakeInCount',
    addBtnText:'新增外协验收单'
});