tp5按月统计金额，并显示该月的支付状态（如果该月有1条未支付信息，则该月显示未支付）

$year = $this->request->get('year');
        $FinanceModel = new FinanceModel();
        $where = [];
        $where[] = ['isDel', 'EQ', 0];
        if ($year && $year != '') {
            $where[] = ['date', 'like', $year . '%'];
        }
        $financeList = $FinanceModel
            ->field("count(id) as boxCount,sum(money) as money,sum(otherMoney) as otherMoney,sum(totalMoney) as totalMoney,sum(tax) as tax,sum(otherTax) as otherTax,sum(totalTax) as totalTax,sum(totalProfit) as totalProfit,DATE_FORMAT(date,'%m') as month")
            ->where($where)
            ->group('month')
            ->select();
        // 添加支付状态，如果该月有1条未支付信息，则该月显示未支付
        foreach($financeList as &$v){
            $count = $FinanceModel->where([['isDel', 'EQ', 0],['date', 'like', $year . '-' . $v['month'] . '%'],['payStatus','eq',0]])->count();
            if($count > 0){
                $v['payStatus'] = 0;
            }else{
                $v['payStatus'] = 1;
            }
        }