alimall.hdlkeji.com/application/admin/controller/community/Teachingvideo.php

<?php

namespace app\admin\controller\community;

use app\common\controller\Backend;
use think\exception\DbException;
use think\response\Json;

/**
 * 教学视频管理
 *
 * @icon fa fa-circle-o
 */
class Teachingvideo extends Backend
{

    /**
     * TeachingVideo模型对象
     * @var \app\common\model\TeachingVideo
     */
    protected $model = null;

    public function _initialize()
    {
        parent::_initialize();
        $this->model = new \app\common\model\TeachingVideo;
        $classify = config('site.goodstype');
        $this->view->assign('classify',$classify);
    }


    /**
     * 查看
     *
     * @return string|Json
     * @throws \think\Exception
     * @throws DbException
     */
    public function index()
    {
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if (false === $this->request->isAjax()) {
            return $this->view->fetch();
        }
        //如果发送的来源是 Selectpage，则转发到 Selectpage
        if ($this->request->request('keyField')) {
            return $this->selectpage();
        }
        [$where, $sort, $order, $offset, $limit] = $this->buildparams();
        $list = $this->model
            ->where($where)
            ->order($sort, $order)
            ->paginate($limit);

//        $duration = $this->model->field('duration,into')->select();
        $haoshigou_time = 0;
        $duoxiangshi_time = 0;
        $menshigou_time = 0;
        $haishigou_time = 0;
        $shizhishi_time = 0;
        $time_for_correct_ans = $this->model->field('type,TIME_TO_SEC(duration) as total')->select();

        foreach ($time_for_correct_ans as $v){
            switch ($v['type']){
                case '好柿购':
                    $haoshigou_time += $v['total'];
                    break;
                case '多享柿':
                    $duoxiangshi_time += $v['total'];
                    break;
                case '门柿购':
                    $menshigou_time += $v['total'];
                    break;
                case '海柿购':
                    $haishigou_time += $v['total'];
                    break;
                case '柿知识':
                    $shizhishi_time += $v['total'];
            }
        }

        $result = ['total' => $list->total(), 'rows' => $list->items(),"extend" => ['haoshigou_time' => $this->changeTimeType($haoshigou_time), 'duoxiangshi_time' => $this->changeTimeType($duoxiangshi_time), 'menshigou_time' => $this->changeTimeType($menshigou_time), 'haishigou_time' => $this->changeTimeType($haishigou_time), 'shizhishi_time' => $this->changeTimeType($shizhishi_time)]];
        return json($result);
    }
    /**
     * 计算视频总时长
     */
    public function changeTimeType($seconds){
        if ($seconds >3600){
            $hours =intval($seconds/3600);
            $minutes = $seconds % 3600;
            $time = $hours.":".gmstrftime('%M:%S',$minutes);
        }else{
            $time = gmstrftime('%H:%M:%S',$seconds);
        }
        return$time;
    }


}