/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(PersonsRequest $request)
{
$person = Person::create($request->all());
$customer = Customer::findOrFail($person->customer_id);
$snippets = $customer->snippets;
$persons = Person::where('customerId', $customer->id);
return Redirect::action('CustomersController@show', [$customer->slug])->with([$snippets, $persons]);
//return view('customers.show', compact('customer', 'snippets', 'persons'));
}
public function prs($name)
{
$person = Person::where('name', $name);
if (!$person->count()) {
\Log::info("Person with name {$name} does not exist");
return null;
}
return $person->first()->id;
}
public function show($id)
{
try {
$person = \App\Person::where('id', $id)->take(1)->get()[0];
} catch (\ErrorException $e) {
return response()->json(['code' => $e->getCode(), 'message' => $e->getMessage()]);
}
return response()->json($person);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
// ПЕРЕПИСАТЬ
$persons = Person::where('user_id', Auth::user()->id)->orderBy('hide')->orderBy('name')->get();
$ps = $persons;
// $ps = [];
// foreach($persons as $k => $p) {
// $p->last_remains_date = Operation::get_last_remains_date($p->id);
// $ps[] = $p;
// }
// usort($ps, function($a, $b) {
// return strcmp($b->last_remains_date, $a->last_remains_date);
// });
return view('persons.index')->withPersons($ps);
}
/**
* AJAX поиск заказчика по номеру паспорта
*/
public function getSearchPerson(Request $request)
{
// Обрабатываем только AJAX запрос
if ($request->ajax()) {
try {
$person = Person::where('passport_num', '=', $request->input('passport_num'))->firstOrFail();
} catch (Exception $e) {
return response()->json(null, 404);
}
return response()->json($person->toArray());
} else {
return redirect()->back();
}
}
|--------------------------------------------------------------------------
|
| Here is where you can register all of the routes for an application.
| It's a breeze. Simply tell Laravel the URIs it should respond to
| and give it the controller to call when that URI is requested.
|
*/
Route::resource("profile", "ProfileController");
Route::resource("api/task", "api\\TaskController");
Route::post("api/authenticate", "api\\AuthenticateController@authenticate");
Route::get("/tasks", "TaskController@index");
Route::post('/task', 'TaskController@store');
Route::delete('/task/{task}', 'TaskController@destroy');
Route::get('/test', function () {
return view("test.index");
});
Route::get('user/view', "UserController@view");
// Authentication Routes...
Route::get('auth/login', 'Auth\\AuthController@getLogin');
Route::post('auth/login', 'Auth\\AuthController@postLogin');
Route::get('auth/logout', 'Auth\\AuthController@getLogout');
// Registration Routes...
Route::get('auth/register', 'Auth\\AuthController@getRegister');
Route::post('auth/register', 'Auth\\AuthController@postRegister');
Route::get('/', "UserController@index");
Route::resource('person', 'PersonController');
Route::resource('phone', 'PhoneController');
Route::resource('profile', 'ProfileController');
Route::bind('person', function ($name) {
return \App\Person::where('name', $name)->orWhere('id', $name)->first();
});
/**
* Get all of the persons by the keywords supplied.
*
* @param array $terms
*
* @return Collection
*/
public function byKeywords($request)
{
$keyword = $request->keywords;
$result = Person::where('expertise', 'LIKE', '%' . $keyword . '%')->orwhere('profile', 'LIKE', '%' . $keyword . '%')->orwhere('note', 'LIKE', '%' . $keyword . '%')->orwhere('first_name', 'LIKE', '%' . $keyword . '%')->orwhere('last_name', 'LIKE', '%' . $keyword . '%')->orwhere('cb_experience', 'LIKE', '%' . $keyword . '%')->orwhere('education', 'LIKE', '%' . $keyword . '%')->orwhere('employment', 'LIKE', '%' . $keyword . '%')->orwhere('academic_affiliation', 'LIKE', '%' . $keyword . '%');
//$result = $result->ofAppRole('8'); //future: take from AppRoleId
return $result->paginate(10)->appends(['keywords' => $keyword]);
}
public function search(Request $request)
{
Log::info("search request for persons");
$result = '';
$q = $request->q;
$persons = Person::where('searchname', 'like', '%' . $q . '%')->where('id', '!=', $request->active_id)->where('parent_id', '<=', 0)->orderBy('searchname')->limit(10)->get();
if (count($persons) > 0) {
foreach ($persons as $person) {
$result .= '{"key": ' . $person->id . ',"value": "' . $person->searchname . '"},';
}
$result = rtrim($result, ",");
}
return '[' . $result . ']';
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$app = Database::create(["name" => "LogosDB", 'description' => "Logos Production DB", "rpo" => "15 min", "rto" => "15 min", "dr_strategy" => "mirrored. synchronous. drlogos7sql", "ha_strategy" => "n/a", "server_id" => Server::where('name', 'logos7sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Jeremy Bloomstrom')->first()->id, Person::where('name', 'Davey Griffith')->first()->id]);
$app->applications()->attach([Application::where('name', 'Logos')->first()->id]);
$app->servers()->attach([Server::where('name', 'logos7sql')->first()->id]);
$app = Database::create(["name" => "govern_prod", 'description' => "Govern production database", "rpo" => "15 min", "rto" => "15 min", "dr_strategy" => "mirrored, synchronous, drgovsql", "ha_strategy" => "n/a", "upgrade_readiness" => "Vendor Approved : Unknown\n Vendor Assist : Unknown\n Upgrade Advisor : Yes\n Issues :\n Error : SQL Mail Has Been Discontinued. This affects usp_DiskFreeSpaceAlert.\n Mitigation : Rewrite the USP to use DB Mail instead\n\n Warning: Several views contain remote references to smalldatetime columns. Under compatibility level 110, remote smalldatetime columns are now returned to local servers as smalldatetime columns instead of as datetime columns. This may make the view unable to accept updates.\n Mitigation: Keep DBCL at 100 or change the datatype of the remote columns to datetime.\n\n Warning : The DB Mirroring feature is deprecated and will be removed in a future release.\n Mitigation : Implement another DR strategy.", "server_id" => Server::where('name', 'govsql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Jeremy Bloomstrom')->first()->id, Person::where('name', 'Matt Rykaczewski')->first()->id, Person::where('name', 'Davey Griffith')->first()->id, Person::where('name', 'Ed Bennett')->first()->id]);
$app->applications()->attach([Application::where('name', 'Govern')->first()->id]);
$app->servers()->attach([Server::where('name', 'govsql')->first()->id]);
$app = Database::create(["name" => "TrimProduction", 'description' => "Trim Production database", "rpo" => "15 min", "rto" => "1 hour", "dr_strategy" => "mirrored, synchronous, drmsb01sql", "ha_strategy" => "n/a", "upgrade_readiness" => "Vendor Approved : Yes\n Vendor Assist : N/A\n Upgrade Advisor : Yes\n Issues :\n Warning: DB Mirroring will be deprecated in a future version\n Mitigation: Implement another DR strategy", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Jeremy Bloomstrom')->first()->id, Person::where('name', 'Davey Griffith')->first()->id]);
$app->applications()->attach([Application::where('name', 'Trim')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "MSBDATA", 'description' => "Govern Reporting Database", "server_id" => Server::where('name', 'msbsqlrpt')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Jeremy Bloomstrom')->first()->id, Person::where('name', 'Matt Rykaczewski')->first()->id, Person::where('name', 'Davey Griffith')->first()->id, Person::where('name', 'Ed Bennett')->first()->id]);
$app->applications()->attach([Application::where('name', 'Govern')->first()->id]);
$app->servers()->attach([Server::where('name', 'msbsqlrpt')->first()->id]);
$app = Database::create(["name" => "eSuiteDB", 'description' => "eSuite Production DB", "rpo" => "15 min", "rto" => "1 hour", "dr_strategy" => "n/a", "ha_strategy" => "n/a", "server_id" => Server::where('name', 'logos7sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Jeremy Bloomstrom')->first()->id, Person::where('name', 'Davey Griffith')->first()->id]);
$app->applications()->attach([Application::where('name', 'eSuite')->first()->id]);
$app->servers()->attach([Server::where('name', 'logos7sql')->first()->id]);
$app = Database::create(["name" => "Monitor", 'description' => "Disk space reporting db.", "server_id" => Server::where('name', 'govsql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'govsql')->first()->id]);
$app = Database::create(["name" => "LogosMigrate", 'description' => "Logos Upgrade migration db", "server_id" => Server::where('name', 'logos7sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'logos7sql')->first()->id]);
$app = Database::create(["name" => "LogosConfig", 'description' => "Logos Upgrade Config DB", "dr_strategy" => "n/a", "ha_strategy" => "n/a", "server_id" => Server::where('name', 'logos7sql')->first()->id, "inactive_flag" => 1, "production_flag" => 0, "ignore_flag" => 1]);
$app->applications()->attach([Application::where('name', 'Logos')->first()->id]);
$app->servers()->attach([Server::where('name', 'logos7sql')->first()->id]);
$app = Database::create(["name" => "TrimTrain", 'description' => "Trim Training Database", "dr_strategy" => "n/a", "ha_strategy" => "n/a", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'Trim')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "TrimDevelopment", 'description' => "Trim Testing Database", "dr_strategy" => "n/a", "ha_strategy" => "n/a", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'Trim')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "wasteworks", 'description' => "WasteWorks Production DB", "rpo" => "15 min", "rto" => "1 hour", "dr_strategy" => "n/a", "ha_strategy" => "n/a", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Davey Griffith')->first()->id, Person::where('name', 'Elizabeth Grigsby')->first()->id, Person::where('name', 'Jeremy Bloomstrom')->first()->id]);
$app->applications()->attach([Application::where('name', 'WasteWorks')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "AbraHRMS_Live", 'description' => "Abra Production Database", "rpo" => "15 min", "rto" => "1 hour", "dr_strategy" => "n/a", "ha_strategy" => "n/a", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Davey Griffith')->first()->id, Person::where('name', 'Elizabeth Grigsby')->first()->id, Person::where('name', 'Jeremy Bloomstrom')->first()->id]);
$app->applications()->attach([Application::where('name', 'Abra')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "AbraEmployeeSelfService", 'description' => "Abra Employee Self Service Database", "rpo" => "15 min", "rto" => "1 hour", "dr_strategy" => "n/a", "ha_strategy" => "n/a", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Elizabeth Grigsby')->first()->id, Person::where('name', 'Jeremy Bloomstrom')->first()->id]);
$app->applications()->attach([Application::where('name', 'Abra')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "AbraHRMS_Sample", 'description' => "Abra Test Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'Abra')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "Actions", 'description' => "Search Actions Database", "rpo" => "1 hour", "rto" => "1 hour", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Davey Griffith')->first()->id, Person::where('name', 'Jack Horner')->first()->id, Person::where('name', 'Jeremy Bloomstrom')->first()->id]);
$app->applications()->attach([Application::where('name', 'Actions')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "Aimwin", 'description' => "Ambulance Billing Database", "rpo" => "1 hour", "rto" => "1 hour", "upgrade_readiness" => "Vendor Approved : Yes\n Vendor Assist : N/A\n Upgrade Advisor : No, incompatible with DBCL 80\n Issues :\n Error : The db is at DBCL 80 which is incompatible with SQL Server 2012.\n Mitigation : The vendor stated that the DBCL can be changed to 100 without a problem.", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Davey Griffith')->first()->id]);
$app->applications()->attach([Application::where('name', 'AIMS')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "Aimwin_Archive", 'description' => "Ambulance Billing Archive Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'AIMS')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "Animal", 'description' => "Chameleon (Animal Care) Database", "upgrade_readiness" => "Vendor Approved : Yes\n Vendor Assist : Vendor will be providing updated views to make the db compatible with DBCL 90.\n Upgrade Advisor : No, incompatible with DBCL 80\n Issues :\n Error : The db is at DBCL 80 which is incompatible with SQL Server 2012. Several views contain unsupported non-ANSI joins which do not work with DBCL > 80.\n Mitigation : The vendor will be providing updated views that will allow DBCL 90. This will allow us to migrate to 2012.\n\n The updated views and instructions are in the project folder.", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Elizabeth Grigsby')->first()->id, Person::where('name', 'Jeremy Bloomstrom')->first()->id]);
$app->applications()->attach([Application::where('name', 'Chameleon')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "BITDEV", 'description' => "BIT Development Db", "server_id" => Server::where('name', 'msbsqlrpt')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'msbsqlrpt')->first()->id]);
$app = Database::create(["name" => "ElectionsDB_2011copy", 'description' => "ElectionsDB_2011copy", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "Elections_2006_May", 'description' => "Elections_2006_May", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "Elections_2006_Oct", 'description' => "Elections_2006_Oct", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "Elections_2007_Oct", 'description' => "Elections_2007_Oct", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "Elections_2008_Oct", 'description' => "Elections_2008_Oct", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "Elections_2009_Mar", 'description' => "Elections_2009_Mar", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "Logos_DW", 'description' => "Logos Analytics Database", "server_id" => Server::where('name', 'logos7sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'Logos')->first()->id]);
$app->servers()->attach([Server::where('name', 'logos7sql')->first()->id]);
$app = Database::create(["name" => "ProjectBoardProd", 'description' => "Project Board Production Database", "rpo" => "1 day", "rto" => "1 day", "dr_strategy" => "n/a", "ha_strategy" => "n/a", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Jeremy Bloomstrom')->first()->id]);
$app->applications()->attach([Application::where('name', 'Project Board CMS')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "Monitor", 'description' => "Disk Space monitoring db", "server_id" => Server::where('name', 'logos7sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'logos7sql')->first()->id]);
$app = Database::create(["name" => "ReportServer", 'description' => "Logos Report Server Database", "server_id" => Server::where('name', 'logos7sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'Logos')->first()->id]);
$app->servers()->attach([Server::where('name', 'logos7sql')->first()->id]);
$app = Database::create(["name" => "ReportServerTempDB", 'description' => "ReportServerTempDB", "server_id" => Server::where('name', 'logos7sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'logos7sql')->first()->id]);
$app = Database::create(["name" => "LogosRuntimeServices", 'description' => "Logos Runtime Services Database", "server_id" => Server::where('name', 'logos7sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'Logos')->first()->id]);
$app->servers()->attach([Server::where('name', 'logos7sql')->first()->id]);
$app = Database::create(["name" => "Kodak_TRIM", 'description' => "Microfilm Archive Trim Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Davey Griffith')->first()->id, Person::where('name', 'Jeremy Bloomstrom')->first()->id]);
$app->applications()->attach([Application::where('name', 'Trim')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "MEdat2011", 'description' => "Max Solutions Ice Rink Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Elizabeth Grigsby')->first()->id]);
$app->applications()->attach([Application::where('name', 'Maximum Solutions')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "MEdat2011_Palmer", 'description' => "Max Solutions Palmer Pool Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Elizabeth Grigsby')->first()->id]);
$app->applications()->attach([Application::where('name', 'Maximum Solutions')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "MEdat2011_Wasilla", 'description' => "Max Solutions Wasilla Pool Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Elizabeth Grigsby')->first()->id]);
$app->applications()->attach([Application::where('name', 'Maximum Solutions')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "ReportServerTempDB", 'description' => "ReportServerTempDB", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "ReportServer", 'description' => "Reporting Services Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "cAsset", 'description' => "iSupport Asset Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Elizabeth Grigsby')->first()->id]);
$app->applications()->attach([Application::where('name', 'iSupport')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "cSupport", 'description' => "iSupport Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Elizabeth Grigsby')->first()->id]);
$app->applications()->attach([Application::where('name', 'iSupport')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "cSupport_Archive", 'description' => "iSupport Archive Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'iSupport')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "cSupport_Bomgar", 'description' => "iSupport Bomgar Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'iSupport')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "cSupport_Workflow", 'description' => "iSupport Workflow Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'iSupport')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "cSupportReporting", 'description' => "iSupport Reporting Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'iSupport')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "SolarWinds", 'description' => "SolarWinds Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'Solarwinds')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "TRIM_DEV", 'description' => "Trim Development Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'Trim')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "cSurvey", 'description' => "iSupport Survey Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'iSupport')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "MpulseAdmin", 'description' => "MPulse Administration Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'MPulse')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "MPulse_Test", 'description' => "MPulse Test Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'MPulse')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "MPulse_Facilities", 'description' => "MPulse Facilities Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'MPulse')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "MPulse_Fleet", 'description' => "MPulse Fleet Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'MPulse')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "MPulse_EMS", 'description' => "MPulse EMS Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'MPulse')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "PFD", 'description' => "PFD Garnishment Database", "upgrade_readiness" => "Vendor Approved : N/A\n Vendor Assist : N/A\n Upgrade Advisor : Yes\n Issues :\n Warning: UD CLR Objects may function differently in DBCL110.\n Mitigation: Keep DBCL at 100.", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'PFD Garnishment')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "PFD_Test", 'description' => "PFD Garnishment Testing Database", "upgrade_readiness" => "Vendor Approved : N/A\n Vendor Assist : N/A\n Upgrade Advisor : Yes\n Issues :\n Warning: UD CLR Objects may function differently in DBCL110.\n Mitigation: Keep DBCL at 100.", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'PFD Garnishment')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "ProjectBoardTest", 'description' => "Project Board CMS Development Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'Project Board CMS')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "OutageTracker", 'description' => "OutageTracker", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "MSB_Elections", 'description' => "Elections Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "MSB_Elections_Test", 'description' => "Elections Test Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "ePO4_MCAFEE-APP", 'description' => "McAfee AV Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Randy Jones')->first()->id, Person::where('name', 'Rod Hoskinson')->first()->id]);
$app->applications()->attach([Application::where('name', 'McAfee Enterprise AV')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "cartegraph_SQL_db01", 'description' => "Cartegraph Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Matt Rykaczewski')->first()->id]);
$app->applications()->attach([Application::where('name', 'Cartegraph')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "MSB_LandManagementDocBrowser", 'description' => "Land Management Document Browser Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'Land Management Doc Browser')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "TrimDeploy", 'description' => "Trim Deployment Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'Trim')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "TRIM_Upgrade", 'description' => "Trim Upgrade Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'Trim')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "MPulse_Facilities_restored", 'description' => "MPulse_Facilities_restored", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "MPulse_EMS_restored", 'description' => "MPulse_EMS_restored", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "MPulse_Fleet_restored", 'description' => "MPulse_Fleet_restored", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "SYMPRO_Matanuska", 'description' => "Sympro Production Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'Sympro')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "TRIM_reporting", 'description' => "Trim Reporting Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'Trim')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "ReportServer", 'description' => "Reporting Services Database", "server_id" => Server::where('name', 'msbsqlrpt')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->servers()->attach([Server::where('name', 'msbsqlrpt')->first()->id]);
$app = Database::create(["name" => "ReportServerTempDB", 'description' => "ReportServerTempDB", "server_id" => Server::where('name', 'msbsqlrpt')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'msbsqlrpt')->first()->id]);
$app = Database::create(["name" => "OutageTrackerDev", 'description' => "IT Dashboard Development Database", "server_id" => Server::where('name', 'msbsqlrpt')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'IT Dashboard')->first()->id]);
$app->servers()->attach([Server::where('name', 'msbsqlrpt')->first()->id]);
$app = Database::create(["name" => "OutageTracker", 'description' => "IT Dashboard Production Database", "server_id" => Server::where('name', 'msbsqlrpt')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->people()->attach([Person::where('name', 'Jeremy Bloomstrom')->first()->id]);
$app->applications()->attach([Application::where('name', 'IT Dashboard')->first()->id]);
$app->servers()->attach([Server::where('name', 'msbsqlrpt')->first()->id]);
$app = Database::create(["name" => "cSupport_Image_Store", 'description' => "iSupport Image Store Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 1, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'iSupport')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "cSupport_Archive_Purchase", 'description' => "iSupport Archive Purchase Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'iSupport')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "cSupport_Archive_Change", 'description' => "iSupport Archive Change Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'iSupport')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "cSupport_Archive_Problem", 'description' => "iSupport Archive Problem Database", "server_id" => Server::where('name', 'msb01sql')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->applications()->attach([Application::where('name', 'iSupport')->first()->id]);
$app->servers()->attach([Server::where('name', 'msb01sql')->first()->id]);
$app = Database::create(["name" => "ReportServerTempDB", 'description' => "ReportServerTempDB", "server_id" => Server::where('name', 'sdesql10edit')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'sdesql10edit')->first()->id]);
$app = Database::create(["name" => "ReportServerTempDB", 'description' => "ReportServerTempDB", "server_id" => Server::where('name', 'sdesql10')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 1]);
$app->servers()->attach([Server::where('name', 'sdesql10')->first()->id]);
$app = Database::create(["name" => "ReportServer", 'description' => "Report Server Db", "server_id" => Server::where('name', 'sdesql10')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->servers()->attach([Server::where('name', 'sdesql10')->first()->id]);
$app = Database::create(["name" => "MATSU_CAMA_GIS", 'description' => "GIS Cama DB", "server_id" => Server::where('name', 'sdesql10')->first()->id, "inactive_flag" => 0, "production_flag" => 0, "ignore_flag" => 0]);
$app->servers()->attach([Server::where('name', 'sdesql10')->first()->id]);
}
public function get_kids_of_family($family)
{
$kids = Person::where('family_of_origin', $family->id)->orderBy('sibling_seq')->get();
return $kids;
}
