NN2020042801/app/index/service/NewsService.php

<?php
/**
 * 信息服务
 * @author wesmielr
 */
namespace app\index\service;
use think\Db;
class NewsService
{

    /**
     * 获取信息列表
     * @param $params 参数
     * @param int $pageSize 条数
     * @param string $field 字段
     * @return \think\Paginator
     * @throws \think\exception\DbException
     */
    public static function getList($params, $pageSize=10, $field=''){
        $field = $field? $field : 'id,title,thumb,keywords,hits,guanggaowei,description,create_time';
        return Db::name('news')
            ->field($field)
            ->where(function($query) use($params){
                $status = isset($params['status'])? $params['status'] : 0;
                if($status){
                    $query->where('status', $status);
                }

                $ncatid = isset($params['ncatid'])? $params['ncatid'] : 0;
                if($ncatid){
                    $query->where('ncatid', $ncatid);
                }

                $level = isset($params['level'])? intval($params['level']) : 0;
                if($level){
                    $query->where('level', $level);
                }

                $kw = isset($params['kw'])? trim($params['kw']) : '';
                if($kw){
                    $query->where('title', 'like', "%{$kw}%");
                }

            })
            ->order('id desc')
            ->paginate($pageSize);
    }

    /**
     * 获取热门信息
     * @param int $num 记录数
     * @param string $field 字段
     * @return array|\PDOStatement|string|\think\Collection
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public static function getHotList($num=6, $field=''){
        $field = $field? $field : 'id,title,thumb,keywords,description,create_time';
        return Db::name('news')
            ->where('status',1)
            ->field($field)
            ->order('hits desc')
            ->limit($num)
            ->select();
    }

    /**
     * 获最新发布信息
     * @param int $num 记录数
     * @param string $field 字段
     * @return array|\PDOStatement|string|\think\Collection
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public static function getNewList($num=6, $field=''){
        $field = $field? $field : 'id,title,thumb,keywords,description,create_time';
        $result = Db::name('news')
            ->where('status',1)
            ->field($field)
            ->order('update_time desc, create_time desc,id desc')
            ->limit($num)
            ->select();

        return $result? $result->toArray() : [];
    }

    /**
     * 获随机发布信息
     * @param int $num 记录数
     * @param string $field 字段
     * @return array|\PDOStatement|string|\think\Collection
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public static function getRandList($num=6, $field=''){
        $field = $field? $field : 'id,title,thumb,keywords,description,create_time';
        $result = Db::name('news')
            ->where('status',1)
            ->field($field)
            ->order(db()->raw('rand()'))
            ->limit($num)
            ->select();

        return $result? $result->toArray() : [];
    }

    /**
     * 获取分类对应的信息列表
     * @param $cateId 分类ID：数组则为多个分类
     * @param $num 记录数
     * @param string $field 字段
     * @return array|\PDOStatement|string|\think\Collection
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public static function getListByCate($cateId, $num=6, $field=''){
        $field = $field? $field : 'id,title,thumb,keywords,description';
        return Db::name('news')
            ->where(function($query) use($cateId){
                if(is_array($cateId)){
                    $query->whereIn('ncatid', $cateId);
                }else{
                    $query->where('ncatid', $cateId);
                }
            })
            ->where('status', 1)
            ->field($field)
            ->order('list_order')
            ->limit($num)
            ->select();
    }

    /**
     * 获取位置对应的信息列表
     * @param $level 位置等级
     * @param $num 记录数
     * @param string $field 字段
     * @return array|\PDOStatement|string|\think\Collection
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public static function getListByLevel($level, $num=6, $field=''){
        $field = $field? $field : 'id,title,thumb,keywords,description';
        return Db::name('news')
            ->where(function($query) use($level){
                if(is_array($level)){
                    $query->whereIn('level', $level);
                }else{
                    $query->where('level', $level);
                }
            })
            ->where('status', 1)
            ->field($field)
            ->order('list_order')
            ->limit($num)
            ->select();
    }
}