video_system/Modules/Mine/Http/Controllers/Api/MineApiController.php

<?php
/**
 * Created by PhpStorm.
 * User: qiuzijian
 * Date: 2021-04-25
 * Time: 11:15
 */

namespace Modules\Mine\Http\Controllers\Api;

use App\Enum\ApiEnum;
use App\Http\Controllers\Api\BaseController;
use Illuminate\Support\Facades\Input;
use Illuminate\Support\Facades\Log;
use Modules\Camera\Http\Controllers\Api\HaiKangController;
use Modules\Mine\Entities\MineListExt;
use Modules\Mine\Enum\MineEnum;
use Modules\Mine\Enum\SurfaceEnum;
use Modules\Mine\Services\MineServices;
use Modules\Mine\Services\SurfaceServices;
use DB;

class MineApiController extends BaseController
{

    /**
     * 作者: qiuzijian
     * 注释: 获取矿井列表
     * @return \App\Http\Controllers\Api\JsonResponse
     */
    public function getMineList()
    {
        $mine_code = Input::get('mine_code', '');

        $result = MineServices::getMineList($mine_code);

        return self::successResponse($result);
    }

    /**
     * 作者: qiuzijian
     * 注释: 获取矿区列表
     * @return \App\Http\Controllers\Api\JsonResponse
     */
    public function getAreaList()
    {
        $mine_code = Input::get('mine_code', '');
        $result = MineServices::getAreaList($mine_code);

//        foreach ($result['data'] as $key => $val) {
            //分矿区判断是否使用海康视频服务器
//            $is_hak = MineListExt::where('mine_id', $val['mine_id'])->value('is_hak');

//            if ($is_hak) {
//                $hk_result = MineServices::getHaiKangArea($val['mine_id']);
//                $result['data'][$key]['children'] = $hk_result['data'];
//            }
//        }

        return self::successResponse($result);
    }

    /**
     * 作者: qiuzijian
     * 注释: 获取工作面列表
     * @return \App\Http\Controllers\Api\JsonResponse
     */
    public function getSurfaceList()
    {
        $working_area = Input::get('area_type', SurfaceEnum::WORKING_AREA_WORK);

        $result = SurfaceServices::getApiSurfaceList($working_area);

        return self::successResponse($result);
    }

    public function getMineByCameraId(){
        $camera_id = Input::get('camera_id', '');

        if (!$camera_id) {
            return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY);
        }

        $result['status'] = true;
        $result['msg']    = ApiEnum::RETURN_SUCCESS;

        $degree = DB::table('mine_list')
            ->leftJoin('camera_list','camera_list.mine_id','mine_list.id')
            ->where('camera_list.id',$camera_id)
            ->value('mine_list.degree');

        if(explode('|',$degree)[0] == 968){
            $mine_name = DB::table('mine_list')->where('id',explode('|',$degree)[1])->value('title');
            if($mine_name == '宁夏煤业高风险作业点'){
                $result['data'] = DB::table('mine_list')->where('id',explode('|',$degree)[2])->value('title');
            }else{
                $result['data'] = DB::table('mine_list')->where('id',explode('|',$degree)[1])->value('title');
            }
        }else{
            $result['data'] = DB::table('mine_list')->where('id',explode('|',$degree)[0])->value('title');
        }

        return self::successResponse($result);
    }
}