<?php

namespace app\admin\controller\video;

use app\admin\controller\Curd;

use support\spark\model\risk\Management;
use support\spark\model\video\Videotasks;
use support\spark\model\video\ManagementAnnotations;
use support\spark\model\system\AdminUser;
use support\spark\model\system\AdminOrg;
use support\Request;

use support\View;
use support\Db;

class AnnotationsController extends Curd
{

    /*
       * @Title: 我的批示
       * @Description: TODO
       */
    public function index(Request $request)
    {
        if (request()->isAjax()) {
            $param = request()->all();
            $where = [];
            $model = new Videotasks();
            # 风险点
            $project_id = isset($param['project_id']) ? $param['project_id'] : '';
            if (!empty($project_id)) {
                $where[] = ['risk_management_id', '=', $project_id];
            } else {
                $wherea1 = [['admin_id','=',admin_id()]];
                $project_id = ((new ManagementAnnotations())->findOne($wherea1,'risk_management_id'))['data']['risk_management_id'];
                if (!$project_id) {
                    # 查空
                    $where[] = ['risk_management_id', '<', 0];
                } else {
                    $where[] = ['risk_management_id', '=', $project_id];
                }

            }
            $list = $model->getPaginateList($where, ['*'], ['id' => 'asc'], [], $param['limit']);
            if($list['total']>0) {
                foreach ($list['data'] as $key => $item) {
                    $whereao = [['id','=',$item['project_org_id']]];
                    $nameData =  ((new AdminOrg())->findOne($whereao,'name'))['data'];
                    $list['data'][$key]['projectname'] = isset($nameData['name']) ? $nameData['name'] : '';
                    $AdminUserData = (new AdminUser)
                        ->where('id', $item['report_user_id'])
                        ->first('nickname');
                    $list['data'][$key]['user_name'] =$AdminUserData ? $AdminUserData['nickname'] : '';

                }
            }
            return sparkSuccess(dataReturn(0, 'success', $list));
        }

        return view('video/annotations/index');
    }

    public function add(Request $request){
        if ($request->isAjaxPost()) {
            $param = $request->post();
            $model = new ManagementAnnotations();
            $param['admin_id'] = admin_id();
            $param['add_time'] = date('Y-m-d H:i:s');
            $res = $model->insertOne($param);
            return sparkSuccess(dataReturn(0, '添加成功'));
        }
        return sparkSuccess(dataReturn(0, 'error'));
    }


    /**
     * 项目层级别树
     * @param Request $request
     * @return \support\Response
     */
    public function treeList(Request $request){
        $param = $request->all();
        $list = $this->getListorg();
        return sparKSuccess(dataReturn(0, 'success', $list));
    }
    /** 单位无分页列表 */
    public function getListorg(){
        $where = [['admin_id','=',admin_id()]];
        $model = new ManagementAnnotations();
        $res = $model->where($where)->select('risk_management_id')->groupBy('risk_management_id')->selectRaw('count(*) as num')->get()->toArray();
        $list = [];
        foreach ($res as $k=>$v){
            $list[$k]['value'] = $v['risk_management_id'];
            $list[$k]['label'] =  (new Management())->where(['id'=>$v['risk_management_id']])->value('name');
            $list[$k]['id']    = $v['risk_management_id'];
        }
        return $list;
    }


}