<?php

namespace App\Services;

use App\Helper\CosHelper;
use App\Helper\Response;
use App\Models\Legal\Contract;
use App\Models\Legal\PropertyShare;
use App\Models\Legal\PropertyShareVerification;
use App\Models\Legal\PropertyTrack;
use App\Models\Legal\PropertyTrackFile;
use App\Models\Legal\StakeholderContract;
use App\Models\Legal\Treaty;
use App\Models\Musician\AppCompany;
use App\Models\Musician\AppCompanyUser;
use Carbon\Carbon;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Http\Request;
use Qcloud\Cos\Client;

/**
 * Class PropertyTrackService
 * @package App\Services
 */
class PropertyTrackService extends Service
{

    /**
     * 歌曲文件列表
     * @return \Illuminate\Http\JsonResponse
     */
    public function list()
    {
        $res = PropertyTrack::query()->where(['create_admin'=>$this->request->get('identifier')->company_id, 'from'=>1])
                    ->when(filled($this->request->input('upload_time')), function (Builder $builder){
                        list($start, $end) = explode(' - ', $this->request->input('upload_time'));
                        $builder->whereBetween('upload_time', [trim($start), trim($end)]);
                    })
                    ->when(filled($this->request->input('song_name')), function (Builder $builder){
                        $builder->where('song_name', 'like', "%{$this->request->input('song_name')}%");
                    })->orderByDesc('id')->paginate($this->pageSize);

        return Response::success($res);
    }

    /**
     * 歌曲文件详情
     * @return \Illuminate\Http\JsonResponse
     */
    public function show()
    {

        $data = [];

        //详情
        if ($track = PropertyTrack::query()->with('project:id,name')->where(['id'=>$this->request->input('track_id'), 'from'=>1])->first()) {
            $user  = AppCompany::query()->where(['company_id'=>$track->create_admin])->first();
            $track->setAttribute('submit_name', $user ? $user->company_name : '');
            $data = $track;
        }

        return Response::success($data);
    }

    /**
     * 待上传数据
     * @return \Illuminate\Http\JsonResponse
     */
    public function pending()
    {
        $count = PropertyTrack::query()->where(['create_admin'=>$this->request->get('identifier')->company_id])->whereNull('upload_time')->count();
        return Response::success(['count'=>$count]);
    }

    /**
     * 歌曲上传文件列表
     * @return \Illuminate\Http\JsonResponse
     */
    public function file()
    {
        $trackFiles = PropertyTrackFile::query()->with('ptfTypes.type:id,type_name,remark')->where(['pt_id'=>$this->request->input('track_id')])
                        ->paginate($this->pageSize);

        return Response::success($trackFiles);
    }

    /**
     * 资产歌曲-分享页面当前最新分享信息
     * @return \Illuminate\Http\JsonResponse
     */
    public function share()
    {
        $data = [
            'config'=>[
                'valid_day' =>  config('musician.property')['valid_day'], //有效期天数
            ],
            'phone'     =>  '',
            'share_url' =>  '',
            'expire_time'   =>  '',
        ];

        if ($share = PropertyShare::query()->where(['pf_id'=>$this->request->input('pf_id')])->orderByDesc('id')->first()) {
            $data['phone']      = $share->phone;
            $data['share_url']  = $share->share_url;
            $data['expire_time']= $share->expire_time;
        }

        return Response::success($data);
    }

    /**
     * 生成链接
     * @return \Illuminate\Http\JsonResponse
     */
    public function shareCreate()
    {
        $propertyConfig = config('musician.property');
        $share = $propertyConfig['base_url'].uniqid();
        $share_url_hash = crc64($share);
        $expire_time    = time() + $propertyConfig['token_valid'];

        if (PropertyShare::query()->insertGetId([
            'pf_id'         =>  $this->request->input('track_id'),
            'phone'         =>  $this->request->input('phone'),
            'share_url'     =>  $share,
            'share_url_hash'=>  $share_url_hash,
            'expire_time'   =>  date('Y-m-d H:i:s', $expire_time),
            'from'          =>  $this->request->input('from'),
            'create_admin'  =>  $this->request->input('user_id'), //用户
            'created_at'    =>  $this->now,
        ])) {
            return Response::success(['url'=>$share]);
        } else {
            return Response::error();
        }
    }

    /**
     * 验证分享登录有效期
     * @return \Illuminate\Http\JsonResponse
     */
    public function shareCheck()
    {


        return Response::success();
    }
}