CameraApiController.php 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: qiuzijian
  5. * Date: 2021-04-25
  6. * Time: 09:53
  7. */
  8. namespace Modules\Camera\Http\Controllers\Api;
  9. use App\Enum\ApiEnum;
  10. use App\Http\Controllers\Api\BaseController;
  11. use Illuminate\Support\Facades\Input;
  12. use Illuminate\Support\Facades\Log;
  13. use Modules\Camera\Entities\CameraList;
  14. use Modules\Camera\Enum\CameraEnum;
  15. use Modules\Camera\Services\CameraServices;
  16. use Modules\Mine\Entities\MineList;
  17. use Modules\Mine\Entities\MineListExt;
  18. use DB;
  19. class CameraApiController extends BaseController
  20. {
  21. //通过摄像头类型获取摄像头
  22. public function getCameraByType(){
  23. $mine_code = Input::get('mine_code', '');
  24. $camera_type = Input::get('camera_type', '');
  25. if (!$mine_code || !$camera_type) {
  26. return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY);
  27. }
  28. $result['status'] = true;
  29. $result['msg'] = ApiEnum::RETURN_SUCCESS;
  30. $mine = DB::table('mine_list')->where('slug','like','%'.$mine_code.'%')->where('parent_id',0)->where('deleted_at',null)->first();
  31. if (!$mine) {
  32. $result['status'] = false;
  33. $result['msg'] = '矿区名称不存在';
  34. return $result;
  35. }
  36. $mine_list = DB::table('mine_list')->where('degree', 'like', $mine->id . '|' . '%')->where('deleted_at',null)->get();
  37. $mine_array = [];
  38. foreach($mine_list as $k=>$v){
  39. $mine_array[] = $v->id;
  40. }
  41. $query = CameraList::where('is_show', CameraEnum::IS_SHOW_YES)->where('deleted_at',null)->whereIn('mine_id',$mine_array)->where('camera_type',$camera_type)->orderBy('sort', 'desc')->get();
  42. if (!$query) {
  43. $result['status'] = false;
  44. $result['msg'] = '矿区下没有摄像头';
  45. return $result;
  46. }
  47. $result = [];
  48. foreach($query as $k=>$v){
  49. $result[$k]['id'] = $v->id;
  50. $result[$k]['mine_id'] = $v->mine_id;
  51. $result[$k]['camera_name'] = $v->camera_name;
  52. $result[$k]['cover_picture'] = $v->cover_picture;
  53. $result[$k]['camera_status'] = $v->camera_status;
  54. $result[$k]['playback'] = $v->playback;
  55. }
  56. return self::successResponse($result);
  57. }
  58. //宁煤摄像头统计
  59. public function getTotalNingmei(){
  60. $result['status'] = true;
  61. $result['msg'] = ApiEnum::RETURN_SUCCESS;
  62. //宁煤集团
  63. $ningmei = DB::table('mine_list')->where('title',config('mine_hls'))->get();
  64. $mine_all = DB::table('mine_list')->where('deleted_at',null)->get();//所有区域
  65. $mine_ningmei = [];//宁煤集团所有区域
  66. foreach($mine_all as $k=>$v){
  67. if(explode('|',$v->degree)[0] == $ningmei[0]->id){
  68. $mine_ningmei[] = $v->id;
  69. }
  70. }
  71. //宁煤在离线数量
  72. $data[0]['title'] = $ningmei[0]->title;
  73. $data[0]['mine_code'] = $ningmei[0]->slug;
  74. $data[0]['total'] = DB::table('camera_list')->whereIn('mine_id',$mine_ningmei)->where('deleted_at',null)->count();
  75. $data[0]['total_online'] = DB::table('camera_list')->whereIn('mine_id',$mine_ningmei)->where('camera_status',1)->where('deleted_at',null)->count();
  76. $data[0]['total_offline'] = $data[0]['total'] - $data[0]['total_online'];
  77. $data[0]['rate'] = round($data[0]['total_online'] / $data[0]['total'] * 100,2)."%";
  78. //宁煤下各矿在离线数量
  79. $mine_list = DB::table('mine_list')->where('parent_id',$ningmei[0]->id)->where('deleted_at',null)->get();
  80. foreach($mine_list as $k => $v){
  81. $mine_use = [];//宁煤下每个矿所有区域
  82. foreach($mine_all as $key=>$value){
  83. if(count(explode('|',$value->degree)) > 1){
  84. if(explode('|',$value->degree)[0] == $ningmei[0]->id && explode('|',$value->degree)[1] == $v->id){
  85. $mine_use[] = $value->id;
  86. }
  87. }
  88. }
  89. $total = DB::table('camera_list')->whereIn('mine_id',$mine_use)->where('deleted_at',null)->count();
  90. $total_online = DB::table('camera_list')->whereIn('mine_id',$mine_use)->where('camera_status',1)->where('deleted_at',null)->count();
  91. if($total == 0){
  92. $rate = "0%";
  93. }else{
  94. $rate = round($total_online / $total * 100,2)."%";
  95. }
  96. if($v->slug == 'NingXiaMeiYeTeShuZuoYeJianKongShiPin'){
  97. $res['title'] = $v->title;
  98. $res['mine_code'] = $v->slug."_jituan";
  99. $res['total'] = $total;
  100. $res['total_online'] = $total_online;
  101. $res['total_offline'] = $total - $total_online;
  102. $res['rate'] = $rate;
  103. }else{
  104. array_push($data,[
  105. 'title'=>$v->title,
  106. 'mine_code'=>$v->slug."_jituan",
  107. 'total'=>$total,
  108. 'total_online'=>$total_online,
  109. 'total_offline'=>$total - $total_online,
  110. 'rate'=>$rate
  111. ]);
  112. }
  113. }
  114. array_push($data,[
  115. 'title'=>$res['title'],
  116. 'mine_code'=>$res['mine_code'],
  117. 'total'=>$res['total'],
  118. 'total_online'=>$res['total_online'],
  119. 'total_offline'=>$res['total_offline'],
  120. 'rate'=>$res['rate']
  121. ]);
  122. return self::successResponse($data);
  123. }
  124. //宁煤高风险摄像头
  125. public function getRiskNingmei(){
  126. $mine_code = Input::get('mine_code', '');
  127. if (!$mine_code) {
  128. return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY);
  129. }
  130. $result['status'] = true;
  131. $result['msg'] = ApiEnum::RETURN_SUCCESS;
  132. //宁煤集团
  133. $ningmei = DB::table('mine_list')->where('title',config('mine_hls'))->get();
  134. //宁煤集团下级单位
  135. $mine = DB::table('mine_list')
  136. ->where('parent_id',$ningmei[0]->id)
  137. ->where('slug','like','%'.$mine_code.'%')
  138. ->where('deleted_at',null)
  139. ->get();
  140. //子区域树形列表
  141. $child_list = DB::table('mine_list')->where('parent_id',$mine[0]->id)->where('deleted_at',null)->orderBy('sort','desc')->get();
  142. $risk_id = null;
  143. if(count($child_list)>0){
  144. $risk_id = $this->mineTree($child_list);
  145. }
  146. $mine_list = [];
  147. if($risk_id != null){
  148. $risk = DB::table('mine_list')->where('parent_id',$risk_id)->where('deleted_at',null)->get();
  149. if(count($risk) > 0){
  150. //有子区域
  151. $mine_list = $this->riskTree($risk,[]);
  152. }else{
  153. //没有子区域
  154. $mine_list[] = $risk_id;
  155. }
  156. }
  157. $camera_list = DB::table('camera_list')
  158. ->select('camera_list.*','mine_list.title')
  159. ->leftJoin('mine_list','camera_list.mine_id','=','mine_list.id')
  160. ->where('camera_list.deleted_at',null)
  161. ->whereIn('camera_list.mine_id',$mine_list)
  162. ->orderBy('sort', 'desc')->get();
  163. $result = [];
  164. foreach($camera_list as $k=>$v){
  165. $result[$k]['parent_id'] = $ningmei[0]->id;
  166. $result[$k]['camera_id'] = $v->id;
  167. $result[$k]['mine_name'] = $v->title;
  168. $result[$k]['camera_name'] = $v->camera_name;
  169. $result[$k]['cover_picture'] = $v->cover_picture;
  170. $result[$k]['camera_status'] = $v->camera_status;
  171. $result[$k]['base64'] = $v->base64;
  172. }
  173. return self::successResponse($result);
  174. }
  175. public function mineTree($regions)
  176. {
  177. $arr = null;
  178. foreach ($regions as $key => $value) {
  179. $risk = explode('高风险作业',$value->title);
  180. if (count($risk)>1){
  181. return $value->id;
  182. }
  183. $mine_child = DB::table('mine_list')->where('parent_id', $value->id)->where('deleted_at',null)->get();
  184. if (count($mine_child) > 0) {
  185. $arr = self::mineTree($mine_child, $value->id);
  186. if($arr != null){
  187. return $arr;
  188. }
  189. }
  190. }
  191. return $arr;
  192. }
  193. public function riskTree($regions,$risk_list)
  194. {
  195. foreach ($regions as $key => $value) {
  196. $risk_child = DB::table('mine_list')->where('parent_id', $value->id)->where('deleted_at',null)->get();
  197. if (count($risk_child) > 0) {
  198. $risk_list = array_merge($risk_list,self::riskTree($risk_child,[]));
  199. }else{
  200. $risk_list[] = $value->id;
  201. }
  202. }
  203. return $risk_list;
  204. }
  205. //高风险区域摄像头
  206. public function getCameraByMinecode(){
  207. $mine_code = Input::get('mine_code', '');
  208. if (!$mine_code) {
  209. return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY);
  210. }
  211. $result['status'] = true;
  212. $result['msg'] = ApiEnum::RETURN_SUCCESS;
  213. $mine = DB::table('mine_list')->where('slug','like','%'.$mine_code.'%')->where('parent_id',0)->where('deleted_at',null)->first();
  214. if (!$mine) {
  215. $result['status'] = false;
  216. $result['msg'] = '矿区名称不存在';
  217. return $result;
  218. }
  219. $mine_list = DB::table('mine_list')->where('degree', 'like', $mine->id . '|' . '%')->where('title','like','%高风险%')->where('deleted_at',null)->get();
  220. $mine_array = [];
  221. foreach($mine_list as $k=>$v){
  222. $mine_child = DB::table('mine_list')->where('degree', 'like','%' . $v->id . '%')->where('deleted_at',null)->get();
  223. if(count($mine_child)>0){
  224. for($i=0;$i<count($mine_child);$i++){
  225. $mine_array[] = $mine_child[$i]->id;
  226. }
  227. }
  228. }
  229. $query = DB::table('camera_list')
  230. ->select('camera_list.*','mine_list.title')
  231. ->leftJoin('mine_list','camera_list.mine_id','=','mine_list.id')
  232. ->where('camera_list.deleted_at',null)
  233. ->whereIn('camera_list.mine_id',$mine_array)
  234. ->orderBy('sort', 'desc')->get();
  235. if (!$query) {
  236. $result['status'] = false;
  237. $result['msg'] = '矿区下没有摄像头';
  238. return $result;
  239. }
  240. $result = [];
  241. foreach($query as $k=>$v){
  242. $result[$k]['parent_id'] = $mine->id;
  243. $result[$k]['camera_id'] = $v->id;
  244. $result[$k]['mine_name'] = $v->title;
  245. $result[$k]['camera_name'] = $v->camera_name;
  246. $result[$k]['cover_picture'] = $v->cover_picture;
  247. $result[$k]['camera_status'] = $v->camera_status;
  248. }
  249. return self::successResponse($result);
  250. }
  251. /**
  252. * 作者: qiuzijian
  253. * 注释: 获取摄像头列表
  254. * @return \App\Http\Controllers\Api\JsonResponse
  255. */
  256. public function getCamerasList()
  257. {
  258. $parent_id = Input::get('parent_id', '');
  259. $mine_id = Input::get('mine_id', '');
  260. $camera_type = Input::get('camera_type', CameraEnum::CAMERA_TYPE_ALL);
  261. $surface_id = Input::get('surface_id', '');
  262. if (!$parent_id) {
  263. return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY);
  264. }
  265. if (!in_array($camera_type, [CameraEnum::CAMERA_TYPE_NORMAL, CameraEnum::CAMERA_TYPE_ALL]) && !$surface_id) {
  266. return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY);
  267. }
  268. //判断是否使用海康视频服务器
  269. // $is_hak = MineListExt::where('mine_id', $parent_id)->value('is_hak');
  270. // if ($is_hak) {
  271. // $result = CameraServices::getHaiKangCamera($parent_id, $mine_id, $camera_type);
  272. // } else {
  273. $result = CameraServices::getCameraListByMineId($mine_id, $camera_type, $parent_id, $surface_id);
  274. // }
  275. return self::successResponse($result);
  276. }
  277. /**
  278. * 作者: qiuzijian
  279. * 注释: 获取摄像头播放地址
  280. * @return \App\Http\Controllers\Api\JsonResponse
  281. */
  282. public function getCamerasUrl()
  283. {
  284. $parent_id = Input::get('parent_id', '');
  285. $camera_id = Input::get('camera_id', '');
  286. if (!$parent_id || !$camera_id) {
  287. return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY);
  288. }
  289. //判断摄像头来源是否为内网服务器
  290. $camera_source = CameraList::where('id', $camera_id)->value('camera_source');
  291. if ($camera_source == CameraEnum::CAMERA_SOURCE_3) {
  292. $result = CameraServices::getIntranetCameraUrl($camera_id);
  293. return self::successResponse($result);
  294. }
  295. //判断是否使用海康视频服务器
  296. $is_hak = MineListExt::where('mine_id', $parent_id)->value('is_hak');
  297. //判断是否生成摄像头请求链接
  298. $camera_url = CameraList::where('id', $camera_id)->value('camera_url');
  299. if ($is_hak && !$camera_url) {
  300. //判断是否是mine配置文件的矿区
  301. $mine_res = DB::table('mine_list')->where('id',$parent_id)->get();
  302. //天地伟业
  303. if(isset($mine_res[0]->title) && in_array($mine_res[0]->title,config('mine'))){
  304. $result = CameraServices::getRtspTianDi($camera_id,$parent_id);
  305. //宁煤集团
  306. }elseif(isset($mine_res[0]->title) && in_array($mine_res[0]->title,config('mine_hls'))){
  307. $result = CameraServices::getHkHls($camera_id,$parent_id);
  308. //信息技术中心测试ws协议
  309. }elseif($mine_res[0]-> slug == 'XinXiJiShuZhongXin'){
  310. $result = CameraServices::getHkWs($camera_id,$parent_id);
  311. //海康切片逻辑
  312. }else{
  313. $result = CameraServices::downloadCameraFiles($parent_id, $camera_id);
  314. }
  315. } else {
  316. //判断硬盘录像机的有没有封面图,有的走easydrawin,没有的走ffmpeg
  317. $cover_picture = CameraList::where('id', $camera_id)->value('cover_picture');
  318. // if(!$cover_picture){
  319. //ffmpeg拉流获取首帧图片
  320. // $result = CameraServices::getCameraUrlByFfmpeg($camera_id);
  321. // }else{
  322. $result = CameraServices::getCameraUrlByCameraId($camera_id);
  323. // }
  324. }
  325. return self::successResponse($result);
  326. }
  327. public function getCamerasLanUrl()
  328. {
  329. $parent_id = Input::get('parent_id', '');
  330. $camera_id = Input::get('camera_id', '');
  331. if (!$parent_id || !$camera_id) {
  332. return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY);
  333. }
  334. //判断摄像头来源是否为内网服务器
  335. $camera_source = CameraList::where('id', $camera_id)->value('camera_source');
  336. if ($camera_source == CameraEnum::CAMERA_SOURCE_3) {
  337. $result = CameraServices::getIntranetCameraUrl($camera_id);
  338. return self::successResponse($result);
  339. }
  340. //判断是否使用海康视频服务器
  341. $is_hak = MineListExt::where('mine_id', $parent_id)->value('is_hak');
  342. //判断是否生成摄像头请求链接
  343. $camera_url = CameraList::where('id', $camera_id)->value('camera_url');
  344. if ($is_hak && !$camera_url) {
  345. //判断是否是mine配置文件的矿区
  346. $mine_res = DB::table('mine_list')->where('id',$parent_id)->get();
  347. //天地伟业
  348. if(isset($mine_res[0]->title) && in_array($mine_res[0]->title,config('mine'))){
  349. $result = CameraServices::getRtspTianDi($camera_id,$parent_id);
  350. //宁煤集团
  351. }elseif(isset($mine_res[0]->title) && in_array($mine_res[0]->title,config('mine_hls'))){
  352. $result = CameraServices::getHkHls($camera_id,$parent_id);
  353. }else{
  354. $result = CameraServices::getLanCameraUrl($parent_id, $camera_id);
  355. }
  356. } else {
  357. //判断硬盘录像机的有没有封面图,有的走easydrawin,没有的走ffmpeg
  358. $cover_picture = CameraList::where('id', $camera_id)->value('cover_picture');
  359. // if(!$cover_picture){
  360. //ffmpeg拉流获取首帧图片
  361. // $result = CameraServices::getCameraUrlByFfmpeg($camera_id);
  362. // }else{
  363. $result = CameraServices::getCameraUrlByCameraId($camera_id);
  364. // }
  365. }
  366. return self::successResponse($result);
  367. }
  368. //获取海康rtsp流
  369. public function getHikRtsp(){
  370. $parent_id = Input::get('parent_id', '');
  371. $camera_id = Input::get('camera_id', '');
  372. if (!$parent_id || !$camera_id) {
  373. return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY);
  374. }
  375. //判断是否使用海康视频服务器
  376. $is_hak = MineListExt::where('mine_id', $parent_id)->value('is_hak');
  377. //判断是否生成摄像头请求链接
  378. $camera_url = CameraList::where('id', $camera_id)->value('camera_url');
  379. if ($is_hak == 1 && !$camera_url) {
  380. $result = CameraServices::getHkRtsp($camera_id,$parent_id);
  381. return self::successResponse($result);
  382. }else{
  383. return self::errorResponse(ApiEnum::HK_REQUEST_FAIL);
  384. }
  385. }
  386. //获取海康rtmp流
  387. public function getHikRtmp(){
  388. $parent_id = Input::get('parent_id', '');
  389. $camera_id = Input::get('camera_id', '');
  390. if (!$parent_id || !$camera_id) {
  391. return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY);
  392. }
  393. //判断是否使用海康视频服务器
  394. $is_hak = MineListExt::where('mine_id', $parent_id)->value('is_hak');
  395. //判断是否生成摄像头请求链接
  396. $camera_url = CameraList::where('id', $camera_id)->value('camera_url');
  397. if ($is_hak == 1 && !$camera_url) {
  398. $result = CameraServices::getHkRtmp($camera_id,$parent_id);
  399. return self::successResponse($result);
  400. }else{
  401. return self::errorResponse(ApiEnum::HK_REQUEST_FAIL);
  402. }
  403. }
  404. //海康摄像头easy_drawin方式获取url
  405. public function getCamerasRtsp()
  406. {
  407. $parent_id = Input::get('parent_id', '');
  408. $camera_id = Input::get('camera_id', '');
  409. if (!$parent_id || !$camera_id) {
  410. return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY);
  411. }
  412. //判断摄像头来源是否为内网服务器
  413. $camera_source = CameraList::where('id', $camera_id)->value('camera_source');
  414. if ($camera_source == CameraEnum::CAMERA_SOURCE_3) {
  415. $result = CameraServices::getIntranetCameraUrl($camera_id);
  416. return self::successResponse($result);
  417. }
  418. //判断是否使用海康视频服务器
  419. $is_hak = MineListExt::where('mine_id', $parent_id)->value('is_hak');
  420. //判断是否生成摄像头请求链接
  421. $camera_url = CameraList::where('id', $camera_id)->value('camera_url');
  422. if ($is_hak && !$camera_url) {
  423. //判断是否是mine配置文件的矿区
  424. $mine_res = DB::table('mine_list')->where('id',$parent_id)->get();
  425. if(isset($mine_res[0]->title) && in_array($mine_res[0]->title,config('mine'))){
  426. //天地伟业使用easy_drawin获取rtsp
  427. $result = CameraServices::getRtspTianDi($camera_id,$parent_id);
  428. }else{
  429. //海康使用easy_drawin获取rtsp
  430. $result = CameraServices::getRtspHaiKang($camera_id, $parent_id);
  431. }
  432. } else {
  433. //硬盘录像机使用easy_drawin获取rtsp
  434. $result = CameraServices::getRtspYingPan($camera_id);
  435. }
  436. return self::successResponse($result);
  437. }
  438. /**
  439. * 作者: qiuzijian
  440. * 注释: 停止摄像头推流
  441. * @return \App\Http\Controllers\Api\JsonResponse
  442. */
  443. public function stopCamerasStream()
  444. {
  445. $camera_id = Input::get('camera_id', '');
  446. $result = CameraServices::stopCameraStream();
  447. return self::successResponse($result);
  448. }
  449. //回放列表
  450. public function getPlaybackList(){
  451. $camera_id = Input::get('camera_id', '');
  452. $result['status'] = true;
  453. $result['msg'] = ApiEnum::RETURN_SUCCESS;
  454. if (!$camera_id) {
  455. $result['status'] = false;
  456. $result['msg'] = ApiEnum::STATUS_CODE_EMPTY;
  457. return $result;
  458. }
  459. $query = CameraList::where('id', $camera_id)->first();
  460. if (!$query) {
  461. $result['status'] = false;
  462. $result['msg'] = ApiEnum::NO_CAMERA_URL;
  463. return $result;
  464. }
  465. if($query->playback == 0){
  466. $result['status'] = false;
  467. $result['msg'] = ApiEnum::NO_SUPORT_PLAYBACK;
  468. return $result;
  469. }
  470. $playback = DB::table('playback')->where('camera_id',$query->id)->where('deleted_at',null)->get();
  471. if(count($playback)>0){
  472. for($i=0;$i<count($playback);$i++){
  473. $result['data'][$i]['title'] = $playback[$i]->title;
  474. $result['data'][$i]['start_time'] = $playback[$i]->start_time;
  475. $result['data'][$i]['end_time'] = $playback[$i]->end_time;
  476. $result['data'][$i]['camera_id'] = $playback[$i]->camera_id;
  477. }
  478. }else{
  479. $result['data'] = null;
  480. }
  481. return $result;
  482. }
  483. //回放URL
  484. public function getPlaybackUrl(){
  485. $time['start_time'] = explode(' ',Input::get('start_time', ''))[1];
  486. $time['end_time'] = explode(' ',Input::get('end_time', ''))[1];
  487. $camera_id = Input::get('camera_id', '');
  488. $start_time = Input::get('start_time', '');
  489. $end_time = Input::get('end_time', '');
  490. $result['status'] = true;
  491. $result['msg'] = ApiEnum::RETURN_SUCCESS;
  492. if (!$camera_id || !$start_time || !$end_time) {
  493. $result['status'] = false;
  494. $result['msg'] = ApiEnum::STATUS_CODE_EMPTY;
  495. return $result;
  496. }
  497. $query = CameraList::where('id', $camera_id)->first();
  498. if (!$query) {
  499. $result['status'] = false;
  500. $result['msg'] = ApiEnum::NO_CAMERA_URL;
  501. return $result;
  502. }
  503. if($query->playback == 0){
  504. $result['status'] = false;
  505. $result['msg'] = ApiEnum::NO_SUPORT_PLAYBACK;
  506. return $result;
  507. }
  508. $degree = MineList::where('id', $query->mine_id)->value('degree');
  509. $degree = explode('|', $degree)[0];
  510. $mine_res = DB::table('mine_list')->where('id',$degree)->get();
  511. //判断摄像头是否是洗选中心的时间+34分钟
  512. if($mine_res[0]->slug == 'XiXuanZhongXin'){
  513. $start_time = date('Y-m-d H:i:s',strtotime($start_time.'+34 minutes'));
  514. $end_time = date('Y-m-d H:i:s',strtotime($end_time.'+34 minutes'));
  515. }
  516. $str = '.000+';
  517. $start_time = date('c', strtotime($start_time));//2022-07-14T08:00:00.000+08:00
  518. $start_time = explode('+',$start_time);
  519. $start_time = $start_time[0].$str.$start_time[1];
  520. $end_time = date('c', strtotime($end_time));
  521. $end_time = explode('+',$end_time);
  522. $end_time = $end_time[0].$str.$end_time[1];
  523. //判断是否在配置文件里,在的不用走ffmpeg
  524. if(isset($mine_res[0]->title) && in_array($mine_res[0]->title,config('playback'))){
  525. $result = CameraServices::getPlaybackRtsp($camera_id,$start_time,$end_time);
  526. return self::successResponse($result);
  527. }else{
  528. $result = CameraServices::getPlaybackRtmp($camera_id,$start_time,$end_time,$time);
  529. return self::successResponse($result);
  530. }
  531. }
  532. //easydrawin回放URL
  533. public function getPlaybackUrlByEasy(){
  534. $time['start_time'] = explode(' ',Input::get('start_time', ''))[1];
  535. $time['end_time'] = explode(' ',Input::get('end_time', ''))[1];
  536. $camera_id = Input::get('camera_id', '');
  537. $start_time = Input::get('start_time', '');
  538. $end_time = Input::get('end_time', '');
  539. $result['status'] = true;
  540. $result['msg'] = ApiEnum::RETURN_SUCCESS;
  541. if (!$camera_id || !$start_time || !$end_time) {
  542. $result['status'] = false;
  543. $result['msg'] = ApiEnum::STATUS_CODE_EMPTY;
  544. return $result;
  545. }
  546. $query = CameraList::where('id', $camera_id)->first();
  547. if (!$query) {
  548. $result['status'] = false;
  549. $result['msg'] = ApiEnum::NO_CAMERA_URL;
  550. return $result;
  551. }
  552. if($query->playback == 0){
  553. $result['status'] = false;
  554. $result['msg'] = ApiEnum::NO_SUPORT_PLAYBACK;
  555. return $result;
  556. }
  557. $degree = MineList::where('id', $query->mine_id)->value('degree');
  558. $degree = explode('|', $degree)[0];
  559. $mine_res = DB::table('mine_list')->where('id',$degree)->get();
  560. //判断摄像头是否是洗选中心的时间+34分钟
  561. if($mine_res[0]->slug == 'XiXuanZhongXin'){
  562. $start_time = date('Y-m-d H:i:s',strtotime($start_time.'+34 minutes'));
  563. $end_time = date('Y-m-d H:i:s',strtotime($end_time.'+34 minutes'));
  564. }
  565. $str = '.000+';
  566. $start_time = date('c', strtotime($start_time));//2022-07-14T08:00:00.000+08:00
  567. $start_time = explode('+',$start_time);
  568. $start_time = $start_time[0].$str.$start_time[1];
  569. $end_time = date('c', strtotime($end_time));
  570. $end_time = explode('+',$end_time);
  571. $end_time = $end_time[0].$str.$end_time[1];
  572. //判断是否在配置文件里,在的不用走ffmpeg
  573. if(isset($mine_res[0]->title) && in_array($mine_res[0]->title,config('playback'))){
  574. $result = CameraServices::getPlaybackRtsp($camera_id,$start_time,$end_time);
  575. return self::successResponse($result);
  576. }else{
  577. $result = CameraServices::getPlaybackByEasy($camera_id,$start_time,$end_time,$time);
  578. return self::successResponse($result);
  579. }
  580. }
  581. /**
  582. * 作者: qiuzijian
  583. * 注释: 获取编码设备信息
  584. * @return \App\Http\Controllers\Api\JsonResponse
  585. */
  586. public function getTranscodeInfo()
  587. {
  588. $parent_id = Input::get('parent_id', '');
  589. if (!$parent_id) {
  590. return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY);
  591. }
  592. $result = CameraServices::getHaiKangTransCode($parent_id);
  593. return self::successResponse($result);
  594. }
  595. /**
  596. * 作者: qiuzijian
  597. * 注释: 获取大南湖摄像头列表
  598. * @return \App\Http\Controllers\Api\JsonResponse
  599. */
  600. public function getSouthLakeCamera()
  601. {
  602. $result = CameraServices::getLeChangeCamera();
  603. return self::successResponse($result);
  604. }
  605. public function pictureBase64(){
  606. $base64 = Input::get('base64', '');
  607. $camera_id = Input::get('camera_id', '');
  608. if (!$base64 || !$camera_id) {
  609. return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY);
  610. }
  611. $data['base64'] = $base64;
  612. DB::table('camera_list')->where('id',$camera_id)->update($data);
  613. return self::successResponse();
  614. }
  615. public function test(){
  616. // header("Access-Control-Allow-Origin: *");
  617. $data = DB::table('goods')->get();
  618. return $data;
  619. }
  620. }