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'));
}
