/** * Run the database seeds. * * @return void */ public function run() { $systems = array(array('name' => 'ECW', 'primary_owner' => 'Abdul', 'secondary_support' => 'JM/Ebenezer'), array('name' => 'SDP', 'primary_owner' => 'Issa'), array('name' => 'CBS', 'primary_owner' => 'David', 'secondary_support' => 'Naivedya'), array('name' => 'Concierge', 'primary_owner' => 'David', 'secondary_support' => 'Naivedya'), array('name' => 'Smartapp', 'primary_owner' => 'David', 'secondary_support' => 'Naivedya'), array('name' => 'FLYTXT', 'primary_owner' => 'Gaurav_T'), array('name' => 'LCMS', 'primary_owner' => 'Gaurav_T'), array('name' => 'BIB', 'primary_owner' => 'Henry'), array('name' => 'SUBEX', 'primary_owner' => 'Henry'), array('name' => 'ICB', 'primary_owner' => 'JM'), array('name' => 'Roaming', 'primary_owner' => 'JM'), array('name' => 'MACH', 'primary_owner' => 'JM'), array('name' => 'NRTDE', 'primary_owner' => 'JM'), array('name' => 'IFS', 'primary_owner' => 'Henry'), array('name' => 'SAGE', 'primary_owner' => 'Henry'), array('name' => 'DMS', 'primary_owner' => 'David'), array('name' => 'SharePoint', 'primary_owner' => 'David'), array('name' => 'MPOS/ISL', 'primary_owner' => 'Gaurav_T'), array('name' => 'Aspect', 'primary_owner' => 'David', 'secondary_support' => 'JM'), array('name' => 'EMA', 'primary_owner' => 'Mirza/Guarva_S'), array('name' => 'EMM', 'primary_owner' => 'Mirza/Guarva_S'), array('name' => 'Tertial', 'primary_owner' => 'Mirza/Guarva_S'), array('name' => 'OCS', 'primary_owner' => 'Mirza/Guarva_S'), array('name' => 'DMS', 'primary_owner' => 'David', 'secondary_support' => 'Issa'), array('name' => 'SharePoint', 'primary_owner' => 'David', 'secondary_support' => 'Issa'), array('name' => 'ESF', 'primary_owner' => 'Issa'), array('name' => 'EVD', 'primary_owner' => 'Henry', 'secondary_support' => 'Jacob'), array('name' => 'PPMS', 'primary_owner' => 'Henry', 'secondary_support' => 'Jacob'), array('name' => 'VMS', 'primary_owner' => 'Henry', 'secondary_support' => 'Jacob'), array('name' => 'Remedy', 'primary_owner' => 'Naivedya'), array('name' => 'Qmatic', 'primary_owner' => 'Gaurav_T')); foreach ($systems as $system) { \App\System::create($system); } }
public function login() { $apps_key = Request::header('Application-Key'); $auth_key = Request::header('Authorization'); if (System::where('api_token', $apps_key)->get()->count() < 1) { return Response::json(['status' => 400, 'message' => http_codes(400)], 400); } if (!($credentials = array_filter(explode(" ", $auth_key)))) { return Response::json(['error' => 'invalid_credentials'], 401); } if (!($auth = array_filter(explode(":", base64_decode($credentials[1]))))) { return Response::json(['error' => 'invalid_credentials'], 401); } if (!Auth::attempt(['name' => $auth[0], 'password' => $auth[1]])) { return Response::json(['status' => 401, 'message' => http_codes(401)], 401); } try { $data = ['userId' => Auth::user()->id]; if (!($token = JWT::setToken($data))) { return Response::json(['error' => 'invalid_credentials'], 401); } } catch (Exception $e) { return Response::json(['error' => 'could_not_create_token'], 500); } return Response::json(['status' => 200, 'message' => http_codes(200), 'data' => $token], 200); }
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(); $user = User::find($id); /* echo "<pre>".$system['name']; print_r($system); echo "</pre>";*/ return \View::make('/admin/forms/editUser', compact('user', 'systems')); }
/** * Update the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function update(Request $request, $id) { $System = $this->System->findOrFail($id); if ($System->update($request->except(['_token', '_method']))) { Flash::success(trans('app.Successful operation')); return redirect()->route('dashboard.system.edit', $id); } else { Flash::error(trans('app.Operation failed')); return redirect()->back(); } }
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')); }
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; }
Route::get('admin/systems/delete/{id}', function ($id) { $selected = App\System::find($id); $selected->delete(); return Redirect::to('admin/systems'); }); Route::get('admin/systems/add', function () { return View::make('admin.add_system'); }); Route::post('admin/systems/add', function () { $input = Input::all(); $validity = Validator::make($input, array('name' => 'Required|Min:3|Max:80', 'description' => 'Max:80', 'tag' => 'Min:3', 'primary_owner' => 'Min:3|Max:30', 'secondary_support' => 'Min:3|Max:30')); if ($validity->fails()) { $messages = $validity->messages(); return Redirect::back()->withInput()->withErrors($validity); } else { \App\System::create(array('name' => $input['name'], 'description' => $input['description'], 'tag' => $input['tag'], 'primary_owner' => $input['primary_owner'], 'secondary_support' => $input['secondary_support'])); return Redirect::to('/admin/systems')->with('success', "Successfully added"); } }); Route::get('/admin/types/edit/{id}', function ($id) { $document_lists = App\DocumentList::find($id); return View::make('admin.edit_types', array('document_lists' => $document_lists)); }); Route::post('/admin/types/edit/{id}', function ($id) { $input = Input::all(); $validity = Validator::make($input, array('name' => 'Required|Min:3|Max:80', 'description' => 'Max:100')); if ($validity->fails()) { $messages = $validity->messages(); return Redirect::back()->withErrors($validity); } else { \App\DocumentList::where('id', $id)->update(array('name' => $input['name'], 'description' => $input['description']));
/** * 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(); }
<!DOCTYPE html> <html lang="zh"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <meta name="author" contents="dev4living.com"> <?php $systemDatas = \App\System::getSystemDatas(); ?> <meta name="keywords" contents="{{ $systemDatas->site_keywords }}"> <meta name="description" contents="{{ $systemDatas->site_description }}"> <title> @section('title') {{ $systemDatas->site_name }} @show </title> <link href="{{ asset('/bowerAssets/bootstrap/dist/css/bootstrap.min.css') }}" rel="stylesheet"> <link href="{{ asset('/bowerAssets/fontawesome/css/font-awesome.min.css') }}" rel="stylesheet"> <link href="{{ asset('/assets/style/style.min.css') }}" rel="stylesheet"> <script src="{{ asset('bowerAssets/jquery/dist/jquery.min.js') }}"></script> <script src="{{ asset('bowerAssets/bootstrap/dist/js/bootstrap.min.js') }}"></script> <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries --> <!-- WARNING: Respond.js doesn't work if you view the page via file:// --> <!--[if lt IE 9]> <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script> <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script> <![endif]--> </head>
/** * Display the specified resource. * * @param int $id * @return Response */ public function showTarget($article) { $href = $article->href; if (substr($article->href, 0, 7) !== 'http://') { $href = 'http://' . $href; } if ($article->target_type == Article::TYPE_TARGET_ORIGIN) { return redirect()->to($href); } else { if ($article->target_type == Article::TYPE_TARGET_IFRAME) { $article->href = $href; $siteName = \App\System::getSystemDatas()->site_name; return view('layouts.frame', ['content' => $article, 'siteName' => $siteName]); } } }
/** * 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(); }
public function store_home_set(Request $request) { $path = '/uploads/logo/'; if ($request->hasFile('logo')) { $logo = $request->file('logo'); if ($logo != null && $logo->isValid()) { $clientName = $logo->getClientOriginalName(); $extension = $logo->getClientOriginalExtension(); $fileName = md5(date('ymdhis') . $clientName) . "." . $extension; $destinationPath = public_path() . $path; $logo->move($destinationPath, $fileName); $logo_path = $path . $fileName; $title = Input::get('WebTitle'); $describtion = Input::get('Webdescription'); $System = new System(); $first = $System->first(); if ($first->count() == 0) { $System->title = $title; $System->webdescription = $describtion; $System->logo = $logo_path; $System->save(); return Redirect::back()->withErros(Null); } else { $first->title = $title; $first->webdescription = $describtion; $first->logo = $logo_path; $first->save(); return Redirect::back()->withErros(Null); } return Redirect::back()->withErros(Null); } } else { $title = Input::get('WebTitle'); $describtion = Input::get('Webdescription'); $System = new System(); $first = $System->first(); if ($first->count() == 0) { $System->title = $title; $System->webdescription = $describtion; $System->save(); return Redirect::back()->withErros(Null); } else { $first->title = $title; $first->webdescription = $describtion; $first->save(); return Redirect::back()->withErros(Null); } } }
public function index($id) { $systems = System::all(); $system = System::find($id); return view('admin/systemView', compact('systems', 'system')); }