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