short-play-api/application/admin/controller/Skitchapter.php

<?php
namespace app\admin\controller;
use app\common\controller\Admin;
use think\Request;
use think\Loader;
use think\Db;
require_once('Audioupload.php');
//短剧章节管理
class Skitchapter extends Admin{
    
    public function index(){
        $id = input('id');
        
        $info = db('skits_library')->where('id',$id)->find();
        $directoryname = $info['directoryname'];
        $buytype = $info['buytype'];
        $allprice = $info['allprice'];
        
        $this->assign('name',$info['name']);
        $this->assign('allprice',$allprice);
        $this->assign('buytype',$buytype);
        $this->assign('directoryname', $directoryname); 
        $this->assign('id', $id); 
        $this->setMeta('章节管理');
		return $this->fetch();
    }
    
    public function refreshs(){
        
        $id = input('id');
        
        $list = db('skits_video')->field('*,FROM_UNIXTIME(addtime) as addtime')->where('sid',$id)->order('id asc')->select();
        
        foreach($list as $k=>$v){
            $list[$k]['price'] = strval($v['price']);
            $list[$k]['isvip'] = strval($v['isvip']);
            $list[$k]['status'] = strval($v['status']);
        }
        
	    exit(json_encode(array(
	        'status'=>1,
	        'data'=>$list
	        )));        
    }
    
    //上传视频
    public function uploadvideo(){
        $filename = input('filename');
        $id = input('id');
        $directoryname = db('skits_library')->where('id',$id)->value('directoryname');
        $videourl = "https://ytyss.oss-cn-beijing.aliyuncs.com/".$directoryname.'/'.$filename;
        $order = db('skits_video')->where('sid',$id)->order('id desc')->value('order');
        $order = empty($order)?1:$order+1;
        $arr = array(
            'sid'=>$id,
            'order'=>$order,
            'video_url'=>$videourl,
            'price'=>70,
            'addtime'=>time()
        );
        $r = db('skits_video')->insert($arr);
        if($r){
    	    exit(json_encode(array(
    	        'status'=>1
    	        )));                 
        }else{
    	    exit(json_encode(array(
    	        'status'=>2,
    	        'msg'=>"错误 文件:".$filename
    	        )));                
        }
        
    }
    
    //删除
    public function deleteRow(){
        $id = input('id');
        $oss = new Audioupload();
        $info = db('skits_video')->where('id',$id)->find();
        $vourl = parse_url($info['video_url']);
        $vourl = substr($vourl['path'],1,strlen($vourl['path']));
        $oss->delete($vourl);
        db('skits_video')->where('id',$id)->delete();
	    exit(json_encode(array(
	        'status'=>1
	        )));        
    }
    
    //编辑
    public function exitdataca(){
        $data = input('');
        $data = $data['data'];
        $id = $data['id'];
        unset($data['id']);
        unset($data['addtime']);
        $r = db('skits_video')->where('id',$id)->update($data);
        if($r){
    	    exit(json_encode(array(
    	        'status'=>1
    	        )));             
        }else{
    	    exit(json_encode(array(
    	        'status'=>2,
    	        'msg'=>"错误"
    	        )));            
        }
    }
    
    //批量修改
    public function upallconf(){
        $data = input('');
        if($data['selone']==1){
            if($data['start'] && $data['end']){
                if($data['allradio']==1){
                    $upd['status'] = 0;
                }elseif($data['allradio']==2){
                    $upd['status'] = 1;
                }elseif($data['allradio']==3){
                    if($data['bookone']){
                        $upd['isvip'] = 1;
                        $upd['price'] = $data['bookone'];
                    }
                }elseif($data['allradio']==4){
                    $upd['isvip'] = 0;
                }
                $list = db('skits_video')->field('id')->where('sid',$data['id'])->where('order', 'between', [$data['start'],$data['end']])->order('id asc')->select();
                foreach($list as $k=>$v){
                    db('skits_video')->where('id',$v['id'])->update($upd);
                }
                db('skits_library')->where('id',$data['id'])->update(['buytype'=>0]);
                exit(json_encode(array(
    	        'status'=>1
    	        )));
            }
        }elseif($data['selone']==2){
            if($data['allprice']){
                db('skits_library')->where('id',$data['id'])->update(['buytype'=>1,'allprice'=>$data['allprice']]);
                exit(json_encode(array(
    	        'status'=>1
    	        )));
            }
        }
    }
    
    public function getbuytype(){
        $id = input('id');
        $p = db('skits_library')->where('id',$id)->find();
        exit(json_encode(array(
        'status'=>1,
        'buytype'=>$p['buytype'],
        'allprice'=>$p['allprice']
        )));        
    }
    
    //生成推广链接
    public function addlink(){
        $id = input('id');
        $remark = input('remark');
        $vidinfo = db('skits_video')->where('id',$id)->find();
        //小程序链接
        $pageurl = '123';
        //管理员id
        $gid = session('user_auth.uid');
        $r = db('transfer')->insert([
           'novelId'=>$vidinfo['id'],
           'chapter'=>$vidinfo['order'],
           'remark'=>$remark,
           'pageurl'=>$pageurl,
           'addtime'=>time(),
           'gid'=>$gid
        ]);
        if($r){
    	    exit(json_encode(array(
    	        'status'=>1
    	        )));             
        }else{
    	    exit(json_encode(array(
    	        'status'=>2,
    	        'msg'=>"错误"
    	        )));            
        }        
    }
    
    
    
}