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