NN2020042801/app/index/common.php

<?php
use think\Db;
error_reporting(E_ERROR | E_PARSE );
function get_mydate($table,$field='*',$map=[],$order='id',$limit='20'){
    $res = Db::name($table)->field($field)->where($map)->order($order)->limit($limit)->select();
    return $res;
}
/**
 * 获取最近的带图的新闻
 */
function get_last_news(){
    $res = Db::name('news')->where('thumb','not null')->orderRaw('rand()')->limit(1)->find();
    return $res;
}
function get_brand_cate($limit=35,$pagesize=12){
    //行业分类
    $brand_cate = Db::name('category')->where('parent_id',0)->order('list_order')->limit($pagesize)->select();
    foreach($brand_cate as $k=>$v){
        $son_cate = Db::name('category')->where('parent_id',$v['id'])->order('list_order')->select()->toArray();
        $v['son'] = $son_cate;
        //推荐的品牌
        $son_array = array();
        foreach($son_cate as $kk=>$vv){
        	$son_array[] = $vv['id'];
        }
        $tuijian_brand = Db::name('jiameng')->field('id,title,logo')->where('catid','in',$son_array)->order('list_order')->limit($limit)->select();
        $v['tuijian'] = $tuijian_brand;
        
        $brand_cate[$k] = $v;
    }
    return $brand_cate;
}
/**
 * 随机取数
 */
function get_random_data($limit=5){
    $res = Db::name('jiameng')->field('id,thumb,mendian,title,touzi_level,product')->orderRaw('rand()')->limit($limit)->select();
    return $res;
}
/**
 * 
 */
function get_link($catname='index'){
    $res = Db::name('link')->where('catname',$catname)->order('list_order')->select();
    return $res;
}
?>