eyoucms支持多种按时间范围查询数量，支持无限递归查询子栏目

if(!function_exists(‘diy_typeids’)) {

    /**

     * 递归获取给定栏目及其所有子栏目的ID列表

     *

     */

    function diy_typeids($typeid)

    {

        $childIds = [$typeid];

        $data = db(‘arctype’)->field(‘id’)->where([

            ‘is_del’ => 0,

            ‘status’ => 1,

            ‘parent_id’ => $typeid

        ])->select();

if ($data instanceof \think\Collection) {

            $data = $data->toArray();

        }

        foreach ($data as $item) {

            $childIds = array_merge($childIds, diy_typeids($item[‘id’]));

        }

        return $childIds;

    }

}

if(!function_exists(‘diy_archive_count’)){

/**

     * 获取发布数量

*/

    function diy_archive_count($range = ‘1’,$typeid = ”)

    {

        $now = time();

        $where = [

‘arcrank’ => 0,

‘is_del’ => 0,

];

        if($typeid){

            $allChildIds = diy_typeids($typeid);

            $where[‘typeid’] = [‘in’, $allChildIds];

        }

//时间范围查询

        if(is_numeric($range)){

$startOfDay = strtotime(date(‘Y-m-d’, $now) . ‘ 00:00:00’);

$endOfDay = strtotime(date(‘Y-m-d’, $now) . ‘ 23:59:59’);

$where[‘add_time’] = [‘between’, [$startOfDay – ($range * 86400), $endOfDay]];

        }else{

            switch ($range) {

                case ‘lastweek’: //上周

$startTime = strtotime(‘last monday’, $now) – 7 * 86400;

$endTime = strtotime(‘last sunday’, $now) + 86399;

break;

                case ‘thisweek’: //本周

$startTime = strtotime(‘last sunday’, $now) + 86400;

$endTime = strtotime(‘next sunday’, $now) – 1;

                    break;

                case ‘thismonth’: //本月

$startTime = mktime(0, 0, 0, date(‘n’, $now), 1, date(‘Y’, $now));

$endTime = mktime(23, 59, 59, date(‘n’, $now), date(‘t’, $now), date(‘Y’, $now));

                    break;

                case ‘lastmonth’: //上个月

$startTime = mktime(0, 0, 0, date(‘n’, $now)-1, 1, date(‘Y’, $now));

$endTime = mktime(23, 59, 59, date(‘n’, $now)-1, date(‘t’, mktime(0, 0, 0, date(‘n’, $now)-1, 1, date(‘Y’, $now))), date(‘Y’, $now));

                    break;

case ‘thisyear’: //今年

$startTime = mktime(0, 0, 0, 1, 1, date(‘Y’, $now));

$endTime = mktime(23, 59, 59, 12, 31, date(‘Y’, $now));

break;

case ‘lastyear’: //去年

$startTime = mktime(0, 0, 0, 1, 1, date(‘Y’, $now) – 1);

$endTime = mktime(23, 59, 59, 12, 31, date(‘Y’, $now) – 1);

break;

                default:

                    return false;

            }

$where[‘add_time’] = [‘between’, [$startTime, $endTime]];

        }

        return db(‘archives’)->where($where)->count();

    }

}