1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677 |
- <?php
- // +----------------------------------------------------------------------
- // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
- // +----------------------------------------------------------------------
- // | Copyright (c) 2016~2022 https://www.crmeb.com All rights reserved.
- // +----------------------------------------------------------------------
- // | Licensed CRMEB并不是自由软件,未经许可不能去掉CRMEB相关版权
- // +----------------------------------------------------------------------
- // | Author: CRMEB Team <admin@crmeb.com>
- // +----------------------------------------------------------------------
- namespace app\merchant\model\live;
- /**
- * 直播间用户表
- */
- use basic\ModelBasic;
- use traits\ModelTrait;
- class LivePlayback extends ModelBasic
- {
- use ModelTrait;
- /**储存直播回放
- * @param $item
- * @param $record_id
- */
- public static function livePlaybackAdd($item)
- {
- if (!self::be(['RecordId' => $item['RecordId'], 'stream_name' => $item['StreamName']])) {
- $data = [
- 'stream_name' => $item['StreamName'],
- 'playback_url' => $item['RecordUrl'],
- 'start_time' => strtotime($item['StartTime']),
- 'end_time' => strtotime($item['EndTime']),
- 'RecordId' => $item['RecordId'],
- 'add_time' => time(),
- ];
- return self::set($data);
- } else {
- return true;
- }
- }
- /**
- * 设置查询条件
- */
- public static function setUserWhere($where, $model = null, $alias = 'a', $jsonField = 'u.nickname')
- {
- $model = is_null($model) ? new self() : $model;
- if ($alias) {
- $model = $model->alias($alias);
- $alias .= '.';
- }
- if ($where['start_time'] && $where['end_time']) $model = $model->where("{$alias}add_time", 'between', [strtotime($where['start_time']), strtotime($where['end_time'])]);
- return $model->order("{$alias}sort desc,{$alias}add_time desc")->where("{$alias}stream_name", $where['stream_name'])->where("{$alias}is_del", 0);
- }
- /**
- * 查询直播间用户列表
- * @param array $where
- */
- public static function getLivePlaybackList($where)
- {
- $data = self::setUserWhere($where)->page((int)$where['page'], (int)$where['limit'])->select();
- $data = count($data) ? $data->toArray() : [];
- foreach ($data as &$item) {
- $item['_add_time'] = date('Y-m-d H:i:s', $item['add_time']);
- $item['StartTime'] = date('Y-m-d H:i:s', $item['start_time']);
- $item['EndTime'] = date('Y-m-d H:i:s', $item['end_time']);
- }
- $count = self::setUserWhere($where)->count();
- return compact('data', 'count');
- }
- }
|