public function show($directory) { $systems = System::all(); $files = self::buildFS(str_replace('-', '\\', $directory)); $directories = self::buildDS(str_replace('-', '\\', $directory)); return view('admin/filesys/directory', compact('files', 'directories', 'systems')); }
/** * Display a listing of the resource. * @return \Illuminate\Http\Response */ public function index() { if (AuthFacade::check()) { $systems = System::all(); return view('admin.administration', compact('systems')); } return view('home.index'); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $systems = System::all(); $system = System::find($id); /* echo "<pre>".$system['name']; print_r($system); echo "</pre>";*/ return \View::make('/admin/forms/editSystem', compact('system', 'systems')); }
public function index() { //test the dynamic connection with other databases seems successfull $systems = System::all(); $res = []; foreach ($systems as $system) { $query = "SELECT [states].eq_id, [states].time, [states].[state_OK],[states].[state_MaintRQ], [states].[state_InMaint], [states].[state_Fault], [equipment].eq_id, CAST(CAST([equipment].eq_name AS VARBINARY) AS VARCHAR) as eq_name FROM [states] LEFT JOIN [equipment] on states.eq_id = [equipment].eq_id"; if ($system['dbversion'] == '2000') { $port = '1434'; try { $connection = odbc_connect("Driver={SQL Server Native Client 10.0};Server=" . $system['host'] . "," . $port . ";Database=" . $system['dbname'], $system['dbuser'], Crypt::decrypt($system['dbuserpass'])); } catch (ErrorException $e) { $system->status = 'default'; $system->save(); $res[$system['name']] = ['error' => $e]; } if ($conn) { $results = odbc_exec($connection, $query); $realData = []; $i = 0; while ($row = json_decode(json_encode(odbc_fetch_object($results)), true)) { foreach ($row as $key => $item) { if ($key == "eq_name" && is_string($item)) { $row[$key] = iconv('UCS-2LE', 'UTF-8', $item); } } $realData[$i] = $row; $i++; } $res[$system['name']] = $realData; odbc_free_result($results); odbc_close($connection); } } else { try { $conn = new PDO("sqlsrv:Server=" . $system['host'] . ";Database=" . $system['dbname'], $system['dbuser'], Crypt::decrypt($system['dbuserpass'])); } catch (PDOException $e) { $system->status = 'default'; $system->save(); $res[$system['name']] = ['error' => $e]; } if ($conn) { $sql = $conn->prepare($query); $sql->execute(); $res[$system['name']] = $sql->fetchAll(); $conn = null; } } } return $res; }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $systems = System::all(); $users = User::all(); return view('admin.administration', compact('systems', 'users')); }
/** * Define the application's command schedule. * * @param \Illuminate\Console\Scheduling\Schedule $schedule * @return void */ protected function schedule(Schedule $schedule) { $schedule->call(function () { $systems = System::all(); foreach ($systems as $key => $system) { $queryMeas = "SELECT [meas].param_id, [meas].time, [meas].value, [param].param_name, [param].param_unit, [limit].ad_limit FROM [meas] LEFT JOIN [param] on meas.param_id = [param].param_id LEFT JOIN [limit] on meas.param_id = [limit].param_id"; $queryEquipment2000 = "SELECT [time] ,st.[eq_id],[state_OK],[state_MaintRQ],[state_InMaint],[state_Fault] ,CAST(CAST([eq_name] AS VARBINARY) AS VARCHAR) as eq_name FROM [states] st JOIN [equipment] eq ON st.eq_id = eq.eq_id"; $queryEquipment = "SELECT [time] ,st.[eq_id],[state_OK],[state_MaintRQ],[state_InMaint],[state_Fault], [eq_name] FROM [states] st JOIN [equipment] eq ON st.eq_id = eq.eq_id"; $meas; $eq; $conn = false; if ($system['dbversion'] == '2000') { $port = '1434'; try { $conn = odbc_connect("Driver={SQL Server Native Client 10.0};Server=" . $system['host'] . "," . $port . ";Database=" . $system['dbname'], $system['dbuser'], Crypt::decrypt($system['dbuserpass'])); } catch (ErrorException $e) { $system->status = 'default'; $system->save(); } if ($conn) { $sysStatus = 'success'; $results = odbc_exec($conn, $queryMeas); $realDataMeas = []; $i = 0; while ($row = odbc_fetch_object($results)) { $row->status = $row->param_name != "O2" && $row->ad_limit && $row->value > $row->ad_limit ? 'warning' : 'success'; $sysStatus = $sysStatus != $row->status && $row->status == 'warning' ? $row->status : $sysStatus; $realDataMeas[$i] = $row; $i++; } $meas = json_decode(json_encode($realDataMeas), true); odbc_free_result($results); $results = odbc_exec($conn, $queryEquipment2000); $realDataEq = []; $i = 0; while ($row = json_decode(json_encode(odbc_fetch_object($results)), true)) { if ($row['state_Fault'] == 1 && $sysStatus != 'error') { $sysStatus = 'error'; } if ($sysStatus != 'error' && ($row['state_InMaint'] == 1 || $row['state_MaintRQ'] == 1)) { $sysStatus = 'warning'; } if ($sysStatus != 'warning' && $sysStatus != 'error' && $row['state_OK'] == 1) { $sysStatus = 'success'; } foreach ($row as $key => $item) { if ($key == "eq_name" && is_string($item)) { $row[$key] = iconv('UCS-2LE', 'UTF-8', $item); } } $realDataEq[$i] = $row; $i++; } $system->status = $sysStatus; $system->save(); odbc_free_result($results); odbc_close($conn); } } else { try { $conn = new PDO("sqlsrv:Server=" . $system['host'] . ";Database=" . $system['dbname'], $system['dbuser'], Crypt::decrypt($system['dbuserpass'])); } catch (PDOException $e) { $system->status = 'default'; $system->save(); } if ($conn) { $sysStatus = 'success'; $sql = $conn->prepare($queryMeas); $sql->execute(); $meas = $sql->fetchAll(); foreach ($meas as $key => $row) { $row['status'] = $row['param_name'] != 'O2' && $row['ad_limit'] && $row['value'] > $row['ad_limit'] ? 'warning' : 'success'; $sysStatus = $sysStatus != $row['status'] && $row['status'] == 'warning' ? $row['status'] : $sysStatus; $meas[$key] = $row; } $sql = $conn->prepare($queryEquipment); $sql->execute(); $eq = $sql->fetchAll(); foreach ($eq as $key => $row) { if ($row['state_Fault'] == 1 && $sysStatus != 'error') { $sysStatus = 'error'; } if ($sysStatus != 'error' && ($row['state_InMaint'] == 1 || $row['state_MaintRQ'] == 1)) { $sysStatus = 'warning'; } if ($sysStatus != 'warning' && $sysStatus != 'error' && $row['state_OK'] == 1) { $sysStatus = 'success'; } $eq[$key] = $row; } $system->status = $sysStatus; $system->save(); $conn = null; } } } })->everyMinute(); }
public function index($id) { $systems = System::all(); $system = System::find($id); return view('admin/systemView', compact('systems', 'system')); }