$list=Db::name("admin")->alias('ad')

        ->where('ad.is_work',1)

         ->where('ad.zhandian_id','not null')

        ->group('ad.zhandian_id')

        ->field('ad.zhandian_id,sum(ad.integral) as shengyujifen,
                (
            select sum(order_price)
            from gczywxcx_order
            where site_id = ad.zhandian_id
                and `order_state` = 2
                AND `is_type` = 3
                AND `confirm_date` BETWEEN '.strtotime($k3.'00:00:00').'  AND '.strtotime($k4.'23:59:59').'
        ) as sumPrice,(
            select sum(fee)
            from gczyadmin_integlog
            where user_id in (select id from gczyc_admin where zhandian_id = ad.zhandian_id)
                AND `type` = 1
                AND `add_date` BETWEEN '.strtotime($k3.'00:00:00').' 
                  AND '.strtotime($k4.'23:59:59').'
        ) as chanfen)
               ->order('sumPrice','desc')
               ->select();

             $list=Db::name('admin_integlog')->alias('inte')
        ->join('admin ad','ad.id=inte.user_id')
        ->group('ad.zhandian_id')
        ->field('ad.zhandian_id,

            sum(if(type=1 and inte.add_date BETWEEN '.strtotime($k3.'00:00:00').' AND '.strtotime($k4.'24:00:00').' , inte.fee,0)) as chanfen,

            (SELECT sum( order_price ) FROM gczyc_wxcx_order WHERE site_id = ad.zhandian_id AND `order_state` = 2 AND `is_type` = 3    AND `confirm_date` BETWEEN '.strtotime($k3.'00:00:00').' AND '.strtotime($k4.'24:00:00').') as sumPrice ,

            sum(inte.fee) as leijifen,           

            sum(if(type=0, inte.fee,0)) as leijiyongfen,           

            sum(if(type=1, inte.fee,0)) as leijichan,

            sum(if(type=2, inte.fee,0)) as leijiyi,

            sum(if(type=3, inte.fee,0)) as cancelorder

            ,(select description from gczyc_jiayouzhan jia where id=ad.zhandian_id ) as description'

        )

        ->select();