MySQL实战基础知识入门(10)：今天、昨天、近7天、近30天在一个筛选语句内实现的解决方案

完整代码：

        $sql = "select SUM(a.should_paid) AS totalPays,a.id,a.leader_id,b.userid,b.name,c.order_id,c.status from " . $db->table('orders');
        switch ($CR_days) {
            case -1;
                $sql .= "  AND TO_DAYS(curdate()) - TO_DAYS(date_format(a.paid_at,'%Y-%m-%d')) = 1";
                break;
            case 0;
                $sql .= "  AND date_format(a.paid_at,'%Y-%m-%d') = curdate()";
                break;
            case 7;
                $sql .= "  AND DATE_SUB(curdate(), INTERVAL 6 DAY)