CameraApiController.php 27 KB

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