php/app/controller/admin/entropybarter/Reconciliation.php

<?php


namespace app\controller\admin\entropybarter;
use crmeb\basic\BaseController;
use think\facade\Db;

class Reconciliation extends BaseController
{
    public function lst()
    {
        //30%  笔数
        $params=$this->request->params(['start_time','end_time']);
        $start_time=strtotime($params['start_time']);
        $end_time=strtotime($params['end_time']);
      $thirty_num=Db::name('entropy_barter_bill')->where('ctime','>',$start_time)->where('ctime','<',$end_time)->where('mer_id',290)->where('commission_type',1)->where('commission_scale','30')->sum('number');
      $all_num=Db::name('store_order')->whereBetweenTime('create_time',$params['start_time'],$params['end_time'])->where('mer_id','290')->where('paid',1)->where('status','in','0,1,2,3')->sum('pay_price');
      $precipitate_num=bcsub($all_num,$thirty_num);
      $Withdrawal_num=Db::name('entropy_barter_bill')->where('ctime','>',$start_time)->where('ctime','<',$end_time)->where('mer_id',290)->where('pm',2)->where('pm2_msg','提现')->where('status','2')->sum('number');
      $surplus=Db::name('entropy_barter_user_290')->sum('wallet');
      return  app('json')->success(compact('thirty_num','all_num','precipitate_num','Withdrawal_num','surplus'));

    }
}