baseXX/application/wap/model/live/LiveStudio.php

<?php
// +----------------------------------------------------------------------
// | CRMEB [ CRMEB赋能开发者，助力企业发展 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2016~2020 https://www.crmeb.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed CRMEB并不是自由软件，未经许可不能去掉CRMEB相关版权
// +----------------------------------------------------------------------
// | Author: CRMEB Team <admin@crmeb.com>
// +----------------------------------------------------------------------

namespace app\wap\model\live;

/**
 * 直播信息表
 */
use basic\ModelBasic;
use traits\ModelTrait;
use think\Db;

class LiveStudio extends ModelBasic
{

    use ModelTrait;

    public static function getLiveList($limit = 10)
    {
        return self::where(['l.is_del' => 0, 's.is_show' => 1, 's.is_del' => 0])->alias('l')
            ->join('special s', 's.id = l.special_id')
            ->field(['s.title', 's.image', 's.browse_count', 'l.is_play', 's.id', 'l.playback_record_id', 'l.start_play_time'])
            ->limit($limit)->order('s.sort DESC,l.sort DESC,l.add_time DESC')->select()->each(function ($item) {
                if ($item['playback_record_id'] && !$item['is_play']) {
                    $item['status'] = 2;
                } else if ($item['is_play']) {
                    $item['status'] = 1;
                } else if (!$item['playback_record_id'] && !$item['is_play'] && strtotime($item['start_play_time']) > time()) {
                    $item['status'] = 3;
                }
                if ($item['start_play_time']) {
                    $item['start_play_time'] = date('m-d H:i', strtotime($item['start_play_time']));
                }
                $uids=Db::name('learning_records')->where(['special_id'=>$item['id']])->column('uid');
                $uids=array_unique($uids);
                $item['records'] =count($uids);
            })->toArray();
    }
    public static function getLiveOne($live_one_id)
    {
        return self::where(['l.is_del' => 0, 's.is_show' => 1, 's.is_del' => 0])->alias('l')
            ->join('special s', 's.id = l.special_id')
            ->field(['s.title', 's.image','l.is_play', 's.id'])
            ->where('l.is_play',1)->where('s.id',$live_one_id)
            ->order('l.sort DESC,l.add_time DESC')->find();
    }

    public function getStartPlayTimeAttr($time)
    {
        return $time;//返回create_time原始数据，不进行时间戳转换。
    }


}