private function getSytemIinfo($id)
{
$system = System::find($id);
$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";
$res;
$meas;
$eq;
$conn = false;
if ($system['status'] != 'default') {
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) {
$res[$system['name']] = ['error' => 'Connection Error'];
$res[$system['name']]['meas'] = [];
$res[$system['name']]['equipment'] = [];
}
if ($conn) {
$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';
$realDataMeas[$i] = $row;
$i++;
}
$meas = json_decode(json_encode($realDataMeas), true);
odbc_free_result($results);
$results = odbc_exec($conn, $queryEquipment2000);
$realDataEq = [];
$i = 0;
$state;
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);
}
}
$realDataEq[$i] = $row;
$i++;
}
$eq = $realDataEq;
odbc_free_result($results);
odbc_close($conn);
$res[$system['name']] = ['meas' => $meas, 'equipment' => $eq];
}
} else {
try {
$conn = new PDO("sqlsrv:Server=" . $system['host'] . ";Database=" . $system['dbname'], $system['dbuser'], Crypt::decrypt($system['dbuserpass']));
} catch (PDOException $e) {
$res[$system['name']] = ['error' => 'Connection Error'];
$res[$system['name']]['meas'] = [];
$res[$system['name']]['equipment'] = [];
}
if ($conn) {
$sql = $conn->prepare($queryMeas);
$sql->execute();
$meas = $sql->fetchAll();
foreach ($meas as $key => $result) {
$result['status'] = $result['param_name'] != 'O2' && $result['ad_limit'] && $result['value'] > $result['ad_limit'] ? 'warning' : 'success';
$meas[$key] = $result;
}
$sql = $conn->prepare($queryEquipment);
$sql->execute();
$eq = $sql->fetchAll();
$conn = null;
$res[$system['name']] = ['meas' => $meas, 'equipment' => $eq];
}
}
} else {
$res[$system['name']] = ['error' => 'Connection Error'];
$res[$system['name']]['meas'] = [];
$res[$system['name']]['equipment'] = [];
}
return $res;
}
/**
* Initialize data
*/
protected function initializeData($request)
{
// System
$System = System::find(1);
$System->site_name = $request->get('site_name');
$System->site_slogan = $request->get('site_slogan');
$System->contact_email = $request->get('contact_email');
$System->save();
// User
$User = User::find(1);
$User->name = $request->get('admin_name');
$User->email = $request->get('admin_email');
$User->password = bcrypt($request->get('admin_password'));
$User->save();
}
});
Route::get('welcome', ['middleware' => 'auth', function () {
global $system_document;
$document_list = \App\DocumentList::get();
$systems = \App\System::get();
$users = \App\User::get();
$system_document = \App\SystemDocument::get();
return View::make('dashboard.welcome', array('system_document' => $system_document, 'document_list' => $document_list, 'systems' => $systems, 'users' => $users));
}]);
Route::get('/document', ['middleware' => 'auth', function () {
//retrieve system id
$system_id = Input::get('system_id');
//retrieve document id
$doc_id = Input::get('doc_id');
//find system with particular system id
$system = \App\System::find($system_id);
//find document type with particular document-type id
$document_code = \App\DocumentList::find($doc_id);
//retrieve particular docs after filtering by sytem id and doc id
$system_documents = \App\SystemDocument::where('system_code', '=', $system_id)->where('document_code', '=', $doc_id)->get();
return View::make('dashboard.document', array('system_documents' => $system_documents, 'document_code' => $document_code, 'system' => $system));
}]);
Route::get('/upload', ['middleware' => 'auth', function () {
$document_list = \App\DocumentList::get();
$systems = \App\System::get();
/* if(Auth::guest()){
return Redirect::intended('/')->with('message','Please login to continue');
}*/
return View::make('dashboard.upload', array('document_list' => $document_list, 'systems' => $systems));
}]);
Route::get('/signup', function () {
public function index($id)
{
$systems = System::all();
$system = System::find($id);
return view('admin/systemView', compact('systems', 'system'));
}
