OpcDataController.php 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724
  1. <?php
  2. namespace Modules\OpcData\Http\Controllers\Api;
  3. use Illuminate\Contracts\Support\Renderable;
  4. use Illuminate\Http\Request;
  5. use Illuminate\Http\Response;
  6. use Illuminate\Routing\Controller;
  7. use Illuminate\Support\Facades\DB;
  8. use Modules\OpcData\Entities\OpcDataDict;
  9. use App\Http\Controllers\Api\BaseController;
  10. class OpcDataController extends BaseController
  11. {
  12. protected $opcConf = [
  13. 'ventilation_zb' => 1,
  14. 'ventilation_bb' => 2,
  15. 'pump_zy' => 3,
  16. 'pump_690' => 4,
  17. 'compressed_air' => 5,
  18. 'belt_13' => 6,
  19. 'hoist' => 7
  20. ];
  21. protected $localConf = [
  22. 'jinjiaqu' => [
  23. 'ventilation_zb' => 1, // 中部通风
  24. 'ventilation_bb' => 2, // 北部通风
  25. 'pump_zy' => 3, // 中央水泵房
  26. 'pump_690' => 4, // 690水泵
  27. 'compressed_air' => 5, // 空压机
  28. 'belt_13' => 6, // 13采区运输机
  29. 'hoist' => 7, // 中部副立井提升机
  30. 'hoist_1' => 8, // 13采区提升机
  31. 'hoist_2' => 9, // 北部副斜井
  32. 'belt_2' => 10, // 主斜井胶带运输机
  33. 'boiler' => 11, // 锅炉烟气
  34. 'mancar' => 12, // 13采区架空人车
  35. ],
  36. 'shicaocun' => [
  37. 'fan_1' => 1, // 1号回风(主通风)
  38. 'fan_2' => 2, // 2号回风
  39. 'pump_1' => 3, // 主泵房(900)
  40. 'pump_2' => 4, // 715水泵
  41. 'pump_3' => 5, // 630水泵
  42. 'compressed_air' => 6, // 空压
  43. 'nitrogen' => 7, // 制氮
  44. 'belt_1' => 8, // 22采区
  45. 'belt_2' => 9, // 西翼巷
  46. 'belt_3' => 10, // 集中巷
  47. ],
  48. 'renjiazhuang' => [
  49. 'fan_1' => 1, // 主通风
  50. 'belt_1' => 2, // 主井皮带
  51. 'compressed_air' => 3, // 压风
  52. 'pump_1' => 5, // 850水泵
  53. 'pump_2' => 6, // 650水泵
  54. 'life_water_1' => 7, // 矿区生活水
  55. 'life_water_2' => 8, // 副立井生活水
  56. 'hoist' => 9, // 副立井提升机
  57. 'water_point' => 10, // 供水站子系统
  58. ],
  59. 'qingshuiying' => [
  60. 'fan_1' => 1, // 主通风
  61. 'nitrogen' => 2, // 制氮
  62. 'compressed_air' => 3, // 压风
  63. 'pump_1' => 4, // 主泵房(768)
  64. 'pump_2' => 5, // 11采区水泵房
  65. 'compressed_air_1' => 6, // 副立井压风
  66. 'belt_1' => 7, // 主运输1号皮带
  67. ],
  68. ];
  69. public function getData(Request $request)
  70. {
  71. $getDataType = isset($request->system_type) ? $request->system_type : null; // 获取需要的数据
  72. $getMineCode = isset($request->mine_code) ? $request->mine_code : null; // 矿分类
  73. $dataArr = array(); // 返回数据数组
  74. if (isset($this->localConf[$getMineCode][$getDataType])) {
  75. $opcConnectName = 'mysql_opc_'.$getMineCode;
  76. $groupId = $this->localConf[$getMineCode][$getDataType];
  77. $sqlStr = "
  78. select t1.dev_type_id,
  79. t1.dev_type_name,
  80. t1.device_num,
  81. t1.device_name,
  82. case t.val
  83. when 'True' then 1
  84. when 'False' then 2
  85. else t.val
  86. end val,
  87. t1.json_key,
  88. t1.row_number,
  89. t1.unit,
  90. t1.group_name
  91. from equipment t
  92. join tb_dev_dict_list t1 on t.selItem = t1.selItem
  93. where t1.group_id = ".$groupId."
  94. and t1.is_show = 1
  95. order by t1.dev_type_id, t1.row_number, t1.device_num, t1.device_name
  96. ";
  97. // echo($sqlStr);
  98. try{
  99. $opcDB = DB::connection($opcConnectName);
  100. $dbResult = $opcDB->select($sqlStr);
  101. } catch (\Exception $e) {
  102. return $this->error(-1, '数据库配置错误');
  103. }
  104. // echo($sqlStr);
  105. switch($getDataType) {
  106. case 'compressed_air':
  107. case 'compressed_air_1':
  108. // 压风
  109. $result = $this->getCompressedAirData($dbResult, $getMineCode);
  110. break;
  111. case 'nitrogen':
  112. // 制氮
  113. $result = $this->getNitrogenData($dbResult, $getMineCode);
  114. break;
  115. case 'belt_13':
  116. case 'belt_1':
  117. case 'belt_2':
  118. case 'belt_3':
  119. // 运输机系统
  120. $result = $this->getBeltData($dbResult);
  121. break;
  122. case 'hoist':
  123. case 'hoist_1':
  124. case 'hoist_2':
  125. // 提升机
  126. $result = $this->getHoistData($dbResult);
  127. break;
  128. // 金家渠风机
  129. case 'ventilation_zb':
  130. case 'ventilation_bb':
  131. // 中部风机、北部风机
  132. case 'fan_1':
  133. case 'fan_2':
  134. // 通用风机1、2
  135. $result = $this->getFanData($dbResult);
  136. break;
  137. // 金家渠水泵
  138. case 'pump_zy':
  139. case 'pump_690':
  140. // 中央水泵、609水泵
  141. case 'pump_1':
  142. case 'pump_2':
  143. case 'pump_3':
  144. // 通用水泵1、2、3
  145. $result = $this->getPumpData($dbResult);
  146. break;
  147. case 'mancar':
  148. // 人车
  149. $result = $this->getMancarData($dbResult);
  150. break;
  151. case 'boiler':
  152. // 锅炉
  153. $result = $this->getBoilerData($dbResult);
  154. break;
  155. case 'life_water_1';
  156. case 'life_water_2';
  157. $result = $this->getLieWaterData($dbResult);
  158. break;
  159. case 'water_point';
  160. $result = $this->getLieWaterPointData($dbResult);
  161. break;
  162. }
  163. if (isset($result)) {
  164. return response()->json($result);
  165. }
  166. }
  167. return $this->error(-1, '未找到数据');;
  168. }
  169. // 风机
  170. public function getFanData($dbResult) {
  171. $dataArr = array();
  172. foreach ($dbResult as $key => $val) {
  173. $fanNum = $val->dev_type_id - 1; // 风机号
  174. $label = $val->device_name; // 设备名
  175. $devVal = $val->val; // 数值
  176. $jsonKey = $val->json_key; // json键值
  177. $unit = $val->unit; // 单位
  178. $dataArr[$fanNum]['title'] = $val->dev_type_name; // 风机名
  179. $valArr = [
  180. 'label' => $label, // 标题
  181. 'unit' => $unit // 单位
  182. ];
  183. // 状态与value
  184. if($jsonKey == 'state_list') {
  185. $valArr['state'] = $devVal;
  186. } else {
  187. $valArr['value'] = $devVal;
  188. }
  189. // 根据风量判断风机开关
  190. if($label == '风量') {
  191. if ($devVal <= 0 ) {
  192. $dataArr[$fanNum]['state'] = 2;
  193. } else {
  194. $dataArr[$fanNum]['state'] = 1;
  195. }
  196. }
  197. $dataArr[$fanNum][$jsonKey][] = $valArr;
  198. }
  199. return $dataArr;
  200. }
  201. // 水泵
  202. public function getPumpData($dbResult) {
  203. $dataArr = array();
  204. $timeArr = array(); // 用于拼接时分秒
  205. $timeJsonKey; // 记录time字段key名
  206. // dd($dbResult);
  207. foreach ($dbResult as $key => $val) {
  208. $devName = $val->dev_type_name; // 泵名
  209. $rowNumber = $val->row_number; // 排序
  210. $jsonKey = $val->json_key; // json键值
  211. $label = $val->device_name; // 设备名
  212. $devNum = $val->dev_type_id - 1; // 设备号
  213. $unit = $val->unit; // 单位
  214. $devVal = $val->val; // 数值
  215. if ($jsonKey == 'common') {
  216. // 公共数据
  217. $valArr = [
  218. 'label' => $label, // 标题
  219. 'value' => $devVal, // 值
  220. 'unit' => $unit // 单位
  221. ];
  222. $dataArr[$jsonKey][] = $valArr;
  223. } else if ($jsonKey == 'water_pump') {
  224. // 水泵、状态
  225. $dataArr[$jsonKey][$devNum]['label'] = $devName;
  226. if (isset($dataArr[$jsonKey][$devNum]['state'])) {
  227. $state = $dataArr[$jsonKey][$devNum]['state'];
  228. $dataArr[$jsonKey][$devNum]['state'] = max($devVal, $state);
  229. } else {
  230. $dataArr[$jsonKey][$devNum]['state'] = $devVal;
  231. }
  232. // dd($dataArr);
  233. } else if ($jsonKey == 'parameter' && ($unit == 'DD' || $unit == 'HH' || $unit == 'MM' || $unit == 'SS')) {
  234. // 处理时长
  235. $timeArr[$label][$devNum][$unit] = $devVal;
  236. $timeJsonKey = $jsonKey;
  237. } else {
  238. // 水泵参数
  239. $valArr = [
  240. 'label' => $label, // 标题
  241. 'value' => $devVal, // 值
  242. 'unit' => $unit // 单位
  243. ];
  244. $dataArr['water_pump'][$devNum][$jsonKey][] = $valArr;
  245. }
  246. }
  247. foreach ($timeArr as $key => $value) {
  248. for ($i=0; $i < count($value); $i++) {
  249. $day = isset($value[$i]['DD']) ? isset($value[$i]['DD']).'天' : '';
  250. $hour = isset($value[$i]['HH']) ? isset($value[$i]['HH']).'时' : '';
  251. $minute = isset($value[$i]['MM']) ? isset($value[$i]['MM']).'分' : '';
  252. $second = isset($value[$i]['SS']) ? isset($value[$i]['SS']).'秒' : '';
  253. $timeFormatStr = $day.$hour.$minute.$second;
  254. // $timeFormatStr = isset($value[$i]['DD']).'天'.$value[$i]['HH'].'时'.$value[$i]['MM'].'分'.isset($value[$i]['SS']).'秒';
  255. $valArr = [
  256. 'label' => $key, // 标题
  257. 'value' => $timeFormatStr, // 值
  258. 'unit' => '' // 单位
  259. ];
  260. $dataArr['water_pump'][$i][$timeJsonKey][] = $valArr;
  261. }
  262. }
  263. // dd($timeArr);
  264. return $dataArr;
  265. }
  266. // 压风
  267. public function getCompressedAirData($dbResult, $getMineCode) {
  268. $dataArr = array();
  269. $timeArr = array(); // 用于拼接时分秒
  270. $timeJsonKey; // 记录time字段key名
  271. // dd($dbResult);
  272. foreach ($dbResult as $key => $val) {
  273. $devName = $val->dev_type_name; // 泵名
  274. $rowNumber = $val->row_number; // 排序
  275. $jsonKey = $val->json_key; // json键值
  276. $label = $val->device_name; // 设备名
  277. $devNum = $val->dev_type_id - 1; // 设备号
  278. $unit = $val->unit; // 单位
  279. $devVal = $val->val; // 数值
  280. // $valArr[$jsonKey] = $devVal;
  281. if ($jsonKey == 'state') {
  282. $dataArr['compressed_air'][$devNum]['name'] = $devName;
  283. $dataArr['compressed_air'][$devNum]['state'] = $devVal;
  284. } else if ($jsonKey == 'run_parameter') {
  285. $valArr = [
  286. 'label' => $label, // 标题
  287. 'state' => $devVal, // 值
  288. 'unit' => $unit // 单位
  289. // ,'json' => $jsonKey
  290. ];
  291. $dataArr['compressed_air'][$devNum][$jsonKey][] = $valArr;
  292. } else if ($jsonKey == 'common') {
  293. $valArr = [
  294. 'label' => $label, // 标题
  295. 'value' => $devVal, // 值
  296. 'unit' => $unit // 单位
  297. ];
  298. $dataArr[$jsonKey][] = $valArr;
  299. } else if ($jsonKey == 'drain_value_state') {
  300. // 开关状态单独处理
  301. $dataArr['compressed_air'][$devNum][$jsonKey] = $devVal;
  302. if (array_key_exists($jsonKey, $dataArr['compressed_air'][$devNum])) {
  303. $state = $dataArr['compressed_air'][$devNum][$jsonKey];
  304. $dataArr['compressed_air'][$devNum][$jsonKey] = max($devVal, $state);
  305. } else {
  306. $dataArr['compressed_air'][$devNum][$jsonKey] = $devVal;
  307. }
  308. } else if ($jsonKey == 'compressed_air') {
  309. $valArr = [
  310. 'label' => $label, // 标题
  311. 'value' => $devVal, // 值
  312. 'unit' => $unit // 单位
  313. ];
  314. $dataArr['compressed_air'][$devNum][$jsonKey][] = $valArr;
  315. } else if ($jsonKey == 'warn_state') {
  316. if ($getMineCode == 'qingshuiying' && mb_substr($label, -1) == '阀') {
  317. $valArr = [
  318. 'label' => $label, // 标题
  319. 'state' => $devVal > 15 ? 1 : 2, // 值
  320. 'unit' => $unit // 单位
  321. ];
  322. $dataArr['compressed_air'][$devNum][$jsonKey][] = $valArr;
  323. } else {
  324. $valArr = [
  325. 'label' => $label, // 标题
  326. 'state' => $devVal, // 值
  327. 'unit' => $unit // 单位
  328. ];
  329. $dataArr['compressed_air'][$devNum][$jsonKey][] = $valArr;
  330. }
  331. }
  332. }
  333. if (isset($dataArr)) {
  334. return $dataArr;
  335. }
  336. }
  337. public function getBeltData($dbResult) {
  338. // dd($dbResult);
  339. $dataArr = array();
  340. $valDict = array();
  341. foreach ($dbResult as $key => $val) {
  342. $devName = $val->dev_type_name; // 泵名
  343. $rowNumber = $val->row_number; // 排序
  344. $jsonKey = $val->json_key; // json键值
  345. $label = $val->device_name; // 设备名
  346. $devTypeNum = $val->dev_type_id - 1; // 设备号
  347. $devNum = $val->device_num - 1; // 设备号
  348. $unit = $val->unit; // 单位
  349. $devVal = $val->val; // 数值
  350. // $valArr[$jsonKey] = $devVal;
  351. if ($jsonKey == 'common') {
  352. $valArr = [
  353. 'label' => $label, // 标题
  354. 'value' => $devVal, // 值
  355. 'unit' => $unit // 单位
  356. ];
  357. $dataArr[$jsonKey][] = $valArr;
  358. } else if ($jsonKey == 'state') {
  359. $dataArr['state'] = $devVal;
  360. $dataArr['name'] = $label;
  361. } else if ($jsonKey == 'electric_parameter' or $jsonKey == 'converter_parameter') {
  362. $valArr = [
  363. // 'devNum' => $devNum, // 标题
  364. 'value' => $devVal, // 值
  365. 'unit' => $unit // 单位
  366. // ,'label' => $label // 单位
  367. ];
  368. $valDict[$jsonKey][$label][] = $valArr;
  369. } else {
  370. $valArr = [
  371. 'label' => $label, // 标题
  372. 'state' => $devVal, // 值
  373. // 'unit' => $unit // 单位
  374. ];
  375. $dataArr[$jsonKey][] = $valArr;
  376. }
  377. }
  378. foreach ($valDict as $key => $val) {
  379. $i = 0;
  380. foreach ($val as $valKey => $valVal) {
  381. $dataArr[$key][$i]['label'] = $valKey;
  382. $dataArr[$key][$i]['value_list'] = $valVal;
  383. $i++;
  384. }
  385. }
  386. // dd($dataArr);
  387. return $dataArr;
  388. }
  389. public function getHoistData($dbResult) {
  390. $dataArr = array();
  391. $valDict = array();
  392. $state = 2;
  393. $dataArr['hoist'][0]['state'] = $state;
  394. // dd($dbResult);
  395. foreach ($dbResult as $key => $val) {
  396. $devName = $val->dev_type_name; // 泵名
  397. $rowNumber = $val->row_number; // 排序
  398. $jsonKey = $val->json_key; // json键值
  399. $label = $val->device_name; // 设备名
  400. $devTypeNum = $val->dev_type_id-1; // 设备号
  401. $devNum = $val->device_num - 1; // 设备号
  402. $unit = $val->unit; // 单位
  403. $devVal = $val->val; // 数值
  404. $group_name = $val->group_name; // 设备名
  405. $valArr = array();
  406. if ($jsonKey == 'state') {
  407. $dataArr['hoist'][0]['state'] = $state;
  408. } else if ($jsonKey == 'position') {
  409. $valArr = [
  410. 'label' => $label, // 标题
  411. 'value' => $devVal, // 值
  412. 'unit' => $unit // 单位
  413. ];
  414. $dataArr['common'][$jsonKey][] = $valArr;
  415. } else if ($jsonKey == 'direction') {
  416. $valArr = [
  417. 'label' => $label, // 标题
  418. 'state' => $devVal, // 值
  419. ];
  420. $dataArr['common'][$jsonKey][] = $valArr;
  421. if ($devVal == 1) {
  422. $state = 1;
  423. }
  424. } else if ($jsonKey == 'run_parameter') {
  425. $valArr = [
  426. 'label' => $label, // 标题
  427. 'value' => $devVal, // 值
  428. 'unit' => $unit // 单位
  429. ];
  430. $dataArr['hoist'][$devTypeNum][$jsonKey][] = $valArr;
  431. $dataArr['hoist'][$devTypeNum]['name'] = $group_name;
  432. // $dataArr['common']['direction']
  433. } else {
  434. $valArr = [
  435. 'label' => $label, // 标题
  436. 'state' => $devVal, // 值
  437. 'unit' => $unit // 单位
  438. ];
  439. $dataArr['hoist'][$devTypeNum][$jsonKey][] = $valArr;
  440. }
  441. }
  442. return $dataArr;
  443. }
  444. // 制氮
  445. public function getNitrogenData($dbResult, $getMineCode) {
  446. $dataArr = array();
  447. $valDict = array();
  448. $state = 2;
  449. // dd($dbResult);
  450. foreach ($dbResult as $key => $val) {
  451. $devName = $val->dev_type_name; // 设备名
  452. $rowNumber = $val->row_number; // 排序
  453. $jsonKey = $val->json_key; // json键值
  454. $label = $val->device_name; // 设备名
  455. $devTypeNum = $val->dev_type_id - 1; // 设备号
  456. $devNum = $val->device_num - 1; // 设备号
  457. $unit = $val->unit; // 单位
  458. $devVal = $val->val; // 数值
  459. if ($jsonKey == 'state') {
  460. if($getMineCode == 'qingshuiying') {
  461. if(isset($dataArr[$devTypeNum]['state'])) {
  462. $dataArr[$devTypeNum]['state'] = min($dataArr[$devTypeNum]['state'], $devVal);
  463. $dataArr[$devTypeNum]['name'] = $devName;
  464. } else {
  465. $dataArr[$devTypeNum]['state'] = 2;
  466. $dataArr[$devTypeNum]['name'] = $devName;
  467. }
  468. } else {
  469. $dataArr[$devNum]['state'] = $devVal;
  470. $dataArr[$devNum]['name'] = $devName;
  471. }
  472. } else if ($jsonKey == 'run_parameter' || $jsonKey == 'cold_dryer') {
  473. $valArr = [
  474. 'label' => $label, // 标题
  475. 'value' => $devVal, // 值
  476. 'unit' => $unit // 单位
  477. ];
  478. $dataArr[$devNum][$jsonKey][] = $valArr;
  479. } else if ($jsonKey == 'tap_state') {
  480. $valArr = [
  481. 'label' => $label, // 标题
  482. 'state' => $devVal, // 值
  483. ];
  484. $dataArr[$devNum][$jsonKey][] = $valArr;
  485. }
  486. }
  487. return $dataArr;
  488. }
  489. // 人车
  490. public function getMancarData($dbResult) {
  491. $dataArr = array();
  492. $valDict = array();
  493. $state = 2;
  494. foreach ($dbResult as $key => $val) {
  495. $devName = $val->dev_type_name; // 泵名
  496. $rowNumber = $val->row_number; // 排序
  497. $jsonKey = $val->json_key; // json键值
  498. $label = $val->device_name; // 设备名
  499. $devTypeNum = $val->dev_type_id; // 设备号
  500. $devNum = $val->device_num - 1; // 设备号
  501. $unit = $val->unit; // 单位
  502. $devVal = $val->val; // 数值
  503. $group_name = $val->group_name; // 设备名
  504. if ($jsonKey == 'common') {
  505. $valArr = [
  506. 'label' => $label, // 标题
  507. 'value' => $devVal, // 值
  508. 'unit' => $unit // 单位
  509. ];
  510. $dataArr[$jsonKey][] = $valArr;
  511. $dataArr['hoist']['name'] = $group_name;
  512. $dataArr['hoist']['state'] = 1;
  513. } if ($jsonKey == 'run_state' || $jsonKey == 'protect_state') {
  514. $valArr = [
  515. 'label' => $label, // 标题
  516. 'state' => $devVal, // 值
  517. ];
  518. $dataArr['hoist'][$jsonKey][] = $valArr;
  519. } else {
  520. $valArr = [
  521. 'label' => $label, // 标题
  522. 'value' => $devVal, // 值
  523. 'unit' => $unit // 单位
  524. ];
  525. $dataArr['hoist'][$jsonKey][] = $valArr;
  526. }
  527. }
  528. return $dataArr;
  529. }
  530. public function getBoilerData($dbResult) {
  531. $dataArr = array();
  532. $valDict = array();
  533. $state = 2;
  534. foreach ($dbResult as $key => $val) {
  535. $devName = $val->dev_type_name; // 泵名
  536. $rowNumber = $val->row_number; // 排序
  537. $jsonKey = $val->json_key; // json键值
  538. $label = $val->device_name; // 设备名
  539. $devTypeNum = $val->dev_type_id; // 设备号
  540. $devNum = $val->device_num - 1; // 设备号
  541. $unit = $val->unit; // 单位
  542. $devVal = $val->val; // 数值
  543. $group_name = $val->group_name; // 设备名
  544. $dataArr['name'] = $group_name;
  545. $dataArr['state'] = 1;
  546. if ($jsonKey == 'parameter') {
  547. $valArr = [
  548. 'label' => $label, // 标题
  549. 'value' => $devVal, // 值
  550. 'unit' => $unit // 单位
  551. ];
  552. $dataArr[$jsonKey][$rowNumber]['name'] = $devName;
  553. $dataArr[$jsonKey][$rowNumber]['data'][] = $valArr;
  554. }
  555. }
  556. return $dataArr;
  557. }
  558. // 矿区生活水
  559. public function getLieWaterData($dbResult) {
  560. $dataArr = array();
  561. $valDict = array();
  562. $state = 2;
  563. // dd($dbResult);
  564. foreach ($dbResult as $key => $val) {
  565. $devName = $val->dev_type_name; // 泵名
  566. $rowNumber = $val->row_number; // 排序
  567. $jsonKey = $val->json_key; // json键值
  568. $label = $val->device_name; // 设备名
  569. $devTypeNum = $val->dev_type_id - 1; // 设备号
  570. $devNum = $val->device_num - 1; // 设备号
  571. $unit = $val->unit; // 单位
  572. $devVal = $val->val; // 数值
  573. $group_name = $val->group_name; // 设备名
  574. $valArr = array();
  575. if ($jsonKey == 'trans_box') {
  576. $dataArr['cabinet'][$devTypeNum]['title'] = $devName;
  577. $dataArr['cabinet'][$devTypeNum]['data'][$devNum]['name'] = ($devNum + 1).'号供水泵';
  578. $valArr = [
  579. 'name' => $label, // 标题
  580. 'state' => $devVal, // 值
  581. ];
  582. $dataArr['cabinet'][$devTypeNum]['data'][$devNum]['state_list'][] = $valArr;
  583. } else if ($jsonKey == 'trans_box_state') {
  584. $dataArr['cabinet'][$devTypeNum]['state'] = $devVal;
  585. } else if ($jsonKey == 'state_list') {
  586. $valArr = [
  587. 'label' => $label, // 标题
  588. 'state' => $devVal, // 值
  589. ];
  590. $dataArr[$jsonKey][] = $valArr;
  591. } else if ($jsonKey == 'parameter') {
  592. $valArr = [
  593. 'label' => $label, // 标题
  594. 'value' => $devVal, // 值
  595. 'unit' => $unit // 单位
  596. ];
  597. $dataArr[$jsonKey][] = $valArr;
  598. }
  599. }
  600. return $dataArr;
  601. }
  602. // 供水站子系统
  603. public function getLieWaterPointData($dbResult) {
  604. $dataArr = array();
  605. $valDict = array();
  606. $state = 2;
  607. // dd($dbResult);
  608. foreach ($dbResult as $key => $val) {
  609. $devName = $val->dev_type_name; // 泵名
  610. $label = $val->device_name; // 设备名
  611. $rowNumber = $val->row_number; // 排序
  612. $jsonKey = $val->json_key; // json键值
  613. $devTypeNum = $val->dev_type_id - 1; // 设备号
  614. $devNum = $val->device_num - 1; // 设备号
  615. $unit = $val->unit; // 单位
  616. $devVal = $val->val; // 数值
  617. $group_name = $val->group_name; // 设备名
  618. $valArr = array();
  619. if ($jsonKey == 'common') {
  620. $valArr = [
  621. 'name' => $label, // 标题
  622. 'value' => $devVal, // 值
  623. 'unit' => $unit, // 单位
  624. ];
  625. $dataArr['common'][$devNum]['name'] = $devName;
  626. $dataArr['common'][$devNum]['data'][] = $valArr;
  627. } else if ($jsonKey == 'cabinet') {
  628. $valArr = [
  629. 'name' => $label, // 标题
  630. 'state' => $devVal, // 值
  631. ];
  632. $dataArr['cabinet']['title'] = '供水站变频柜参数';
  633. $dataArr['cabinet']['data'][$devNum]['name'] = $devName; // 供水泵名
  634. $dataArr['cabinet']['data'][$devNum]['state_list'][] = $valArr;
  635. } else if ($jsonKey == 'cabinet_statue') {
  636. $dataArr['cabinet']['data'][$devNum]['state'] = $devVal; // 供水泵名
  637. }
  638. }
  639. return $dataArr;
  640. }
  641. }