//按栏目归档
$data = Db::query("select count(a.catid) as num,c.column_name,c.id from hlgj_article a,hlgj_column c where a.catid=c.id group by c.id order by c.id desc");
// dump($data);
$data1 = Db::name('article')
    	->alias('a')
    	->join(PERFIX.'column c','c.id = a.catid')
    	->field('count(a.catid) as num,c.column_name,c.id')
    	->group('c.id')
    	->order(['c.id'=>'asc'])
    	->select();
// dump($data1);
		
//按时间归档
$data2 = Db::query("select count(itemid) as num,FROM_UNIXTIME(addtime,'%Y年%m月') as t ,FROM_UNIXTIME(addtime,'%Y-%m') as t1 from hlgj_article  group by t order by itemid desc");
//dump($data2);
$data3 = Db::name('article')
		->field("count(itemid) as num,FROM_UNIXTIME(addtime,'%Y年%m月') as t ,FROM_UNIXTIME(addtime,'%Y-%m') as t1")
		->group('t')
		->order(['itemid'=>'desc'])
		->select();
//dump($data3);
		
//搜索
		
		$tiem = '2019-10';
		$t = date('t', strtotime($tiem)); //获取当月天数
		$k = $tiem.'-1';//开始时间
		$j = $tiem.'-'.$t." 23:59:59";
		
		if($tiem){
			$where[] = ['addtime','between time',[$k,$j]];	
		}
		$data4 = Db::name('article')
				->where($where)
				->order(['itemid'=>'desc'])
				->select();
		dump($data4);