/**
* Update the specified resource in storage.
*
* @param Request $request
* @param int $id
* @return Response
*/
public function update(Request $request)
{
$subSubCategory = SubSubCategory::where('id', $request['subsubCategoryID'])->first();
$subSubCategory->name = $request['name'];
$subSubCategory->save();
\Session::flash('success', $request['name'] . ' has been successfully updated!');
return redirect()->back();
}
public function child_category($slug)
{
$category = SubSubCategory::where('slug', '=', $slug)->first();
$keyword = Input::has('keyword') ? Input::get('keyword') : null;
$cat_id = $category->category_id;
$sub_cat_id = $category->sub_category_id;
$main_cat = Category::where('id', '=', $cat_id)->first();
$sub_cat = SubCategory::where('id', '=', $sub_cat_id)->first();
if ($category === null) {
return redirect('/search');
} else {
$products = $this->searchProduct(null, null, $slug);
//$products = Product::where('sub_sub_category_id', $category->id)->paginate(12);
return view('search.search', compact('products', 'category', 'main_cat', 'sub_cat', 'keyword'));
}
}
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
if (\Schema::hasTable('positions')) {
$positions = Position::all();
$selectPositions = array();
$selectPositions[0] = "Select / All";
foreach ($positions as $position) {
$selectPositions[$position->slug] = $position->name;
}
\View::share('selectPositions', $selectPositions);
}
if (\Schema::hasTable('cases_priorities')) {
$priorities = CasePriority::all();
$selectPriorities = array();
$selectPriorities[0] = "Select / All";
foreach ($priorities as $priority) {
$selectPriorities[$priority->slug] = $priority->name;
}
\View::share('selectPriorities', $selectPriorities);
}
if (\Schema::hasTable('titles')) {
$titles = Title::all();
$selectTitles = array();
$selectTitles[0] = "Select / All";
foreach ($titles as $title) {
$selectTitles[$title->slug] = $title->name;
}
\View::share('selectTitles', $selectTitles);
}
if (\Schema::hasTable('languages')) {
$languages = Language::all();
$selectLanguages = array();
$selectLanguages[0] = "Select / All";
foreach ($languages as $language) {
$selectLanguages[$language->slug] = $language->name;
}
\View::share('selectLanguages', $selectLanguages);
}
if (\Schema::hasTable('departments')) {
$departments = Department::all();
$selectDepartments = array();
$selectDepartments[0] = "Select / All";
foreach ($departments as $department) {
$selectDepartments[$department->slug] = $department->name;
}
\View::share('selectDepartments', $selectDepartments);
}
if (\Schema::hasTable('users_roles')) {
$roles = UserRole::all();
$selectRoles = array();
$selectRoles[0] = "Select / All";
foreach ($roles as $role) {
$selectRoles[$role->slug] = $role->name;
}
\View::share('selectRoles', $selectRoles);
}
if (\Schema::hasTable('provinces')) {
$provinces = Province::all();
$selectProvinces = array();
$selectProvinces[0] = "Select / All";
foreach ($provinces as $Province) {
$selectProvinces[$Province->slug] = $Province->name;
}
\View::share('selectProvinces', $selectProvinces);
}
if (\Schema::hasTable('districts')) {
$districts = District::all();
$selectDistrict = array();
$selectDistricts[0] = "Select / All";
foreach ($districts as $district) {
$selectDistricts[$district->slug] = $district->name;
}
\View::share('selectDistricts', $selectDistricts);
}
if (\Schema::hasTable('municipalities')) {
$municipalities = Municipality::all();
$selectMunicipalities = array();
$selectMunicipalities[0] = "Select / All";
foreach ($municipalities as $municipality) {
$selectMunicipalities[$municipality->slug] = $municipality->name;
}
\View::share('selectMunicipalities', $selectMunicipalities);
}
if (\Schema::hasTable('wards')) {
$wards = Ward::all();
$selectWards = array();
$selectWards[0] = "Select / All";
foreach ($wards as $ward) {
$selectWards[$ward->slug] = $ward->name;
}
\View::share('selectWards', $selectWards);
}
if (\Schema::hasTable('categories')) {
$categories = Category::all();
$selectCategories = array();
$selectCategories[0] = "Select / All";
foreach ($categories as $category) {
$selectCategories[$category->slug] = $category->name;
}
\View::share('selectCategories', $selectCategories);
}
if (\Schema::hasTable('sub_categories')) {
$subCategories = SubCategory::all();
$selectSubCategories = array();
$selectSubCategories[0] = "Select / All";
foreach ($subCategories as $subCategory) {
$selectSubCategories[$subCategory->slug] = $subCategory->name;
}
\View::share('selectSubCategories', $selectSubCategories);
}
if (\Schema::hasTable('sub_sub_categories')) {
$subSubCategories = SubSubCategory::all();
$selectSubSubCategories = array();
$selectSubSubCategories[0] = "Select / All";
foreach ($subSubCategories as $subSubCategory) {
$selectSubSubCategories[$subSubCategory->slug] = $subSubCategory->name;
}
\View::share('selectSubSubCategories', $selectSubSubCategories);
}
if (\Schema::hasTable('relationships')) {
$relationships = Relationship::all();
$selectRelationships = array();
$selectRelationships[0] = "Select / All";
foreach ($relationships as $relationship) {
$selectRelationships[$relationship->id] = $relationship->name;
}
\View::share('selectRelationships', $selectRelationships);
}
if (\Schema::hasTable('cases')) {
$cases = \DB::table('cases')->join('users', 'cases.reporter', '=', 'users.id')->select(\DB::raw("\n IF(`cases`.`addressbook` = 1,(SELECT CONCAT(`first_name`, ' ', `surname`) FROM `addressbook` WHERE `addressbook`.`id`= `cases`.`reporter`), (SELECT CONCAT(users.`name`, ' ', users.`surname`) FROM `users` WHERE `users`.`id`= `cases`.`reporter`)) as reporterName\n\n "))->get();
$reporters = array();
$reporters[0] = "Select / All";
foreach ($cases as $case) {
$reporters[$case->reporterName] = $case->reporterName;
}
\View::share('selectReporters', $reporters);
}
View()->composer('master', function ($view) {
$view->with('addressBookNumber', addressbook::all());
if (\Auth::check()) {
$number = addressbook::where('user', '=', \Auth::user()->id)->get();
$view->with('addressBookNumber', $number);
$allUsers = User::where('id', '<>', \Auth::user()->id)->get();
$view->with('loggedInUsers', $allUsers);
$noPrivateMessages = Message::where('to', '=', \Auth::user()->id)->where('read', '=', 0)->where('message_type', '=', 0)->get();
$view->with('noPrivateMessages', $noPrivateMessages);
$noInboxMessages = Message::where('to', '=', \Auth::user()->id)->where('message_type', '=', 0)->get();
$view->with('noInboxMessages', $noInboxMessages);
$noDepartments = Department::all();
$view->with('noDepartments', $noDepartments);
$noUsers = User::all();
$view->with('noUsers', $noUsers);
$noRoles = UserRole::all();
$view->with('noRoles', $noRoles);
$noPositions = Position::all();
$view->with('noPositions', $noPositions);
$noRelationships = Relationship::all();
$view->with('noRelationships', $noRelationships);
$noProvinces = Province::all();
$view->with('noProvinces', $noProvinces);
$noCaseStatuses = CaseStatus::all();
$view->with('noCaseStatuses', $noCaseStatuses);
$userRole = UserRole::where('id', '=', \Auth::user()->role)->first();
$view->with('systemRole', $userRole);
$noCasesPriorities = CasePriority::all();
$view->with('noCasesPriorities', $noCasesPriorities);
}
});
}
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
if (\Schema::hasTable('positions')) {
$positions = Position::orderBy('name', 'ASC')->get();
$selectPositions = array();
$selectPositions[0] = "Select / All";
foreach ($positions as $position) {
$selectPositions[$position->slug] = $position->name;
}
\View::share('selectPositions', $selectPositions);
}
if (\Schema::hasTable('departments')) {
$departments = Department::orderBy('name', 'ASC')->get();
$selectDepartments = array();
$selectDepartments[0] = "Select / All";
foreach ($departments as $department) {
$selectDepartments[$department->slug] = $department->name;
}
\View::share('selectDepartments', $selectDepartments);
}
if (\Schema::hasTable('provinces')) {
$provinces = Province::all();
$selectProvinces = array();
$selectProvinces[0] = "Select / All";
foreach ($provinces as $Province) {
$selectProvinces[$Province->slug] = $Province->name;
}
\View::share('selectProvinces', $selectProvinces);
}
if (\Schema::hasTable('districts')) {
$districts = District::all();
$selectDistrict = array();
$selectDistricts[0] = "Select / All";
foreach ($districts as $district) {
$selectDistricts[$district->slug] = $district->name;
}
\View::share('selectDistricts', $selectDistricts);
}
if (\Schema::hasTable('municipalities')) {
$municipalities = Municipality::all();
$selectMunicipalities = array();
$selectMunicipalities[0] = "Select / All";
foreach ($municipalities as $municipality) {
$selectMunicipalities[$municipality->slug] = $municipality->name;
}
\View::share('selectMunicipalities', $selectMunicipalities);
}
if (\Schema::hasTable('categories')) {
$categories = Category::all();
$selectCategories = array();
$selectCategories[0] = "Select / All";
foreach ($categories as $category) {
$selectCategories[$category->slug] = $category->name;
}
\View::share('selectCategories', $selectCategories);
}
if (\Schema::hasTable('sub-categories')) {
$subCategories = SubCategory::all();
$selectSubCategories = array();
$selectSubCategories[0] = "Select / All";
foreach ($subCategories as $subCategory) {
$selectSubCategories[$subCategory->slug] = $subCategory->name;
}
\View::share('selectSubCategories', $selectSubCategories);
}
if (\Schema::hasTable('sub-sub-categories')) {
$subSubCategories = SubSubCategory::all();
$selectSubSubCategories = array();
$selectSubSubCategories[0] = "Select / All";
foreach ($subSubCategories as $subSubCategory) {
$selectSubSubCategories[$subSubCategory->slug] = $subSubCategory->name;
}
\View::share('selectSubSubCategories', $selectSubSubCategories);
}
if (\Schema::hasTable('relationships')) {
$relationships = Relationship::all();
$selectRelationships = array();
$selectRelationships[0] = "Select / All";
foreach ($relationships as $relationship) {
$selectRelationships[$relationship->id] = $relationship->name;
}
\View::share('selectRelationships', $selectRelationships);
}
if (\Schema::hasTable('cases')) {
$cases = \DB::table('cases')->join('users', 'cases.reporter', '=', 'users.id')->select(\DB::raw("\n IF(`cases`.`addressbook` = 1,(SELECT CONCAT(`FirstName`, ' ', `Surname`) FROM `addressbook` WHERE `addressbook`.`id`= `cases`.`reporter`), (SELECT CONCAT(users.`name`, ' ', users.`surname`) FROM `users` WHERE `users`.`id`= `cases`.`reporter`)) as reporterName\n\n "))->get();
$reporters = array();
$reporters[0] = "Select / All";
foreach ($cases as $case) {
$reporters[$case->reporterName] = $case->reporterName;
}
\View::share('selectReporters', $reporters);
}
View()->composer('master', function ($view) {
$view->with('addressBookNumber', addressbook::all());
if (\Auth::check()) {
$number = addressbook::where('user', '=', \Auth::user()->id)->get();
$view->with('addressBookNumber', $number);
$allUsers = User::where('id', '<>', \Auth::user()->id)->get();
$view->with('loggedInUsers', $allUsers);
$noPrivateMessages = Message::where('to', '=', \Auth::user()->id)->where('read', '=', 0)->where('online', '=', 0)->get();
$view->with('noPrivateMessages', $noPrivateMessages);
$noInboxMessages = Message::where('to', '=', \Auth::user()->id)->where('online', '=', 0)->get();
$view->with('noInboxMessages', $noInboxMessages);
}
});
}
public function getSubCategories($id)
{
$subcategories = SubSubCategory::where('sub_category_id', '=', $id)->get();
return $subcategories;
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function captureCase(Request $request)
{
$reporter = $request['caseReporter'];
$caseSeverity = $request['caseSeverity'];
$userObj = User::where('username', '=', $reporter)->first();
if (sizeof($userObj) <= 0) {
$userAddressbookObj = addressbook::where('email', '=', $reporter)->first();
}
$user = sizeof($userObj) <= 0 ? $userAddressbookObj->id : $userObj->id;
$addressbook = sizeof($userObj) <= 0 ? 1 : 0;
$userName = sizeof($userObj) <= 0 ? $userAddressbookObj->FirstName : $userObj->name;
$userSurname = sizeof($userObj) <= 0 ? $userAddressbookObj->Surname : $userObj->surname;
$userEmail = sizeof($userObj) <= 0 ? $userAddressbookObj->email : $userObj->username;
$cell = sizeof($userObj) <= 0 ? $userAddressbookObj->cellphone : $userObj->email;
$caseDescription = $request['caseDescription'];
$precinctObj = Municipality::where('slug', '=', $request['caseMunicipality'])->first();
$categoryObj = Category::where('slug', '=', $request['caseCategory'])->first();
$subCategoryObj = SubCategory::where('slug', '=', $request['caseSubCategory'])->first();
if ($request['caseSubSubCategory'] > 0) {
$subSubCategoryObj = SubSubCategory::where('slug', '=', $request['caseSubSubCategory'])->first();
$subSubCategory = $subSubCategoryObj->id;
} else {
$subSubCategory = 0;
}
$gps = explode(",", $request['GPS']);
$caseObj = new CaseReport();
$caseObj->description = htmlentities($caseDescription);
$caseObj->user = \Auth::user()->id;
$caseObj->reporter = $user;
$caseObj->addressbook = $addressbook;
$caseObj->precinct = $precinctObj->id;
$caseObj->category = $categoryObj->id;
$caseObj->sub_category = $subCategoryObj->id;
$caseObj->sub_sub_category = $subSubCategory;
$caseObj->gps_lat = $gps[0];
$caseObj->gps_lng = $gps[1];
$caseObj->severity = $caseSeverity;
$caseObj->status = "Pending";
$caseObj->save();
$data = array('name' => $userName, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description);
$caseOwner = new CaseOwner();
$caseOwner->user = $user;
$caseOwner->caseId = $caseObj->id;
$caseOwner->type = 0;
$caseOwner->active = 1;
$caseOwner->save();
\Mail::send('emails.sms', $data, function ($message) use($userEmail) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($userEmail)->subject("Siyaleader Notification - New Case Reported:");
});
if ($caseSeverity <= 4) {
$severityData = array('severity' => $caseObj->severity, 'name' => $userName . ' ' . $userSurname, 'cell' => $cell, 'category' => $categoryObj->name, 'caseId' => $caseObj->id);
\Mail::send('emails.severity', $severityData, function ($message) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to('*****@*****.**')->subject("SEVERE");
});
$criticalTeam = CriticalTeam::all();
foreach ($criticalTeam as $critical) {
$caseOwner = new CaseOwner();
$caseOwner->user = $critical->user;
$caseOwner->caseId = $caseObj->id;
$caseOwner->type = 5;
//Critical Team
$caseOwner->active = 1;
$caseOwner->save();
\Mail::send('emails.severity', $severityData, function ($message) use($critical) {
$userObj = User::find($critical->user);
$message->from('*****@*****.**', 'Siyaleader');
$message->to($userObj->username)->subject("Siyaleader Notification - New Severe Case Reported:");
});
}
}
if ($subSubCategory > 0) {
$subSubCatResponders = CaseResponder::where('sub_sub_category', '=', $subSubCategory)->first();
if (sizeof($subSubCatResponders) > 0) {
if ($subSubCatResponders->firstResponder) {
$firstResponderUser = User::find($subSubCatResponders->firstResponder);
$caseOwner = new CaseOwner();
$caseOwner->user = $subSubCatResponders->firstResponder;
$caseOwner->caseId = $caseObj->id;
$caseOwner->type = 1;
$caseOwner->active = 1;
$caseOwner->save();
$data = array('name' => $firstResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description);
\Mail::send('emails.responder', $data, function ($message) use($firstResponderUser) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($firstResponderUser->username)->subject("Siyaleader Notification - New Case Reported:");
});
}
if ($subSubCatResponders->secondResponder) {
$secondResponderUser = User::find($subSubCatResponders->secondResponder);
$caseOwner = new CaseOwner();
$caseOwner->user = $subSubCatResponders->secondResponder;
$caseOwner->caseId = $caseObj->id;
$caseOwner->type = 2;
$caseOwner->active = 1;
$caseOwner->save();
$data = array('name' => $secondResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description);
\Mail::send('emails.responder', $data, function ($message) use($secondResponderUser) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($secondResponderUser->username)->subject("Siyaleader Notification - New Case Reported:");
});
}
if ($subSubCatResponders->thirdResponder) {
$thirdResponderUser = User::find($subSubCatResponders->thirdResponder);
$caseOwner = new CaseOwner();
$caseOwner->user = $subSubCatResponders->thirdResponder;
$caseOwner->caseId = $caseObj->id;
$caseOwner->type = 3;
$caseOwner->active = 1;
$caseOwner->save();
$data = array('name' => $thirdResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description);
\Mail::send('emails.responder', $data, function ($message) use($thirdResponderUser) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($thirdResponderUser->username)->subject("Siyaleader Notification - New Case Reported:");
});
}
}
}
if ($subSubCategory == 0) {
$subCatResponders = CaseResponder::where('sub_category', '=', $subCategoryObj->id)->first();
if (sizeof($subCatResponders) > 0) {
if ($subCatResponders->firstResponder) {
$firstResponderUser = User::find($subCatResponders->firstResponder);
$caseOwner = new CaseOwner();
$caseOwner->user = $subCatResponders->firstResponder;
$caseOwner->caseId = $caseObj->id;
$caseOwner->type = 1;
$caseOwner->active = 1;
$caseOwner->save();
$data = array('name' => $firstResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description);
\Mail::send('emails.responder', $data, function ($message) use($firstResponderUser) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($firstResponderUser->username)->subject("Siyaleader Notification - New Case Reported:");
});
}
if ($subCatResponders->secondResponder) {
$secondResponderUser = User::find($subCatResponders->secondResponder);
$caseOwner = new CaseOwner();
$caseOwner->user = $subCatResponders->secondResponder;
$caseOwner->caseId = $caseObj->id;
$caseOwner->type = 2;
$caseOwner->active = 1;
$caseOwner->save();
$data = array('name' => $secondResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description);
\Mail::send('emails.responder', $data, function ($message) use($secondResponderUser) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($secondResponderUser->username)->subject("Siyaleader Notification - New Case Reported:");
});
}
if ($subCatResponders->thirdResponder) {
$thirdResponderUser = User::find($subCatResponders->thirdResponder);
$caseOwner = new CaseOwner();
$caseOwner->user = $subCatResponders->thirdResponder;
$caseOwner->caseId = $caseObj->id;
$caseOwner->type = 3;
$caseOwner->active = 1;
$caseOwner->save();
$data = array('name' => $thirdResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description);
\Mail::send('emails.responder', $data, function ($message) use($thirdResponderUser) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($thirdResponderUser->username)->subject("Siyaleader Notification - New Case Reported:");
});
}
}
}
return redirect()->back();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
// $this->call(UserTableSeeder::class);
Model::reguard();
# =========================================================================
# POSITIONS SEEDS
# =========================================================================
DB::table('positions')->delete();
$positions = [['name' => 'Acting Maintenance Manager', 'slug' => "Acting-Maintenance-Manager"], ['name' => 'Acting Technical Officer', 'slug' => 'Acting-Technical-Officer'], ['name' => 'Acting Technical supervisor repair line', 'slug' => 'Acting-Technical-supervisor-repair-line'], ['name' => 'Continuous improvement manager', 'slug' => 'Continuous-improvement-manager'], ['name' => 'Engineer In training', 'slug' => 'Engineer-In-training'], ['name' => 'Environment Manager', 'slug' => 'Environment-Manager'], ['name' => 'Environment Officer', 'slug' => 'Environment-Officer'], ['name' => 'Environmental Specialist', 'slug' => 'Environmental-Specialist'], ['name' => 'Fire Officer', 'slug' => 'Fire-Officer'], ['name' => 'Fire Services', 'slug' => 'Fire-Services'], ['name' => 'Human Environment Manager', 'slug' => 'Human-Environment-Manager'], ['name' => 'Maintenance manager roads & tracks', 'slug' => 'Maintenance-manager-roads-tracks'], ['name' => 'Manager: Safety, Health & Environment', 'slug' => 'Manager-Safety-Health-Environment'], ['name' => 'Operations centre manager', 'slug' => 'Operations-centre-manager'], ['name' => 'Port Security Officer', 'slug' => 'Port-Security-Officer'], ['name' => 'Real Estate Manager', 'slug' => 'Real-Estate-Manager'], ['name' => 'Risk ', 'slug' => 'Risk'], ['name' => 'Risk Control Officer', 'slug' => 'Risk-Control-Officer'], ['name' => 'Risk Manager', 'slug' => 'Risk-Manager'], ['name' => 'Risk Specialist', 'slug' => 'Risk-Specialist'], ['name' => 'Security Operations Manager', 'slug' => 'Security-Operations-Manager'], ['name' => 'Senior Electrical Engineer', 'slug' => 'Senior-Electrical-Engineer'], ['name' => 'Senior Engineer', 'slug' => 'Senior-Engineer'], ['name' => 'Senior Manager: Operations Cont', 'slug' => 'Senior-Manager-Operations-Cont'], ['name' => 'Senior Manager: Operations MW', 'slug' => 'Senior-Manager-Operations-MW'], ['name' => 'SHE Field Officer', 'slug' => 'SHE-Field-Officer'], ['name' => 'Supervisor', 'slug' => 'Supervisor'], ['name' => 'Supervisor [Earthworks]', 'slug' => 'Supervisor-Earthworks'], ['name' => 'Technical manager Power supplies', 'slug' => 'Technical-manager-Power-supplies'], ['name' => 'Technical Officer', 'slug' => 'Technical-Officer'], ['name' => 'Technical Supervisor', 'slug' => 'Technical-Supervisor'], ['name' => 'Technical Supervisor (Control Officer)', 'slug' => 'Technical-Supervisor-Control-Officer)'], ['name' => 'Technical Supervisor (Pier 1)', 'slug' => 'Technical-Supervisor-Pier-1'], ['name' => 'Technical Supervisor (Point)', 'slug' => 'Technical-Supervisor-Point'], ['name' => 'Technical Supervisor [Dockyard]', 'slug' => 'Technical-Supervisor-Dockyard'], ['name' => 'Technical Supervisor building & marine', 'slug' => 'Technical-Supervisor-building-marine'], ['name' => 'Technical Supervisor diving', 'slug' => 'Technical-Supervisor-diving'], ['name' => 'Technician', 'slug' => 'Technician'], ['name' => 'Track inspector', 'slug' => 'Track-inspector'], ['name' => 'Trackmaster', 'slug' => 'Trackmaster'], ['name' => 'Waste Management Officer', 'slug' => 'Waste-Management-Officer']];
foreach ($positions as $position) {
Position::create($position);
}
# =========================================================================
# DEPARTMENTS SEEDS
# =========================================================================
DB::table('departments')->delete();
$departments = [['name' => 'Bayhead Precinct', 'slug' => "Bayhead-Precinct"], ['name' => 'Container Precinct', 'slug' => "Container-Precinct"], ['name' => 'Continuous Improvement', 'slug' => "Continuous-Improvement"], ['name' => 'Corporate Affairs', 'slug' => "Corporate-Affairs"], ['name' => 'Customer Relations Management', 'slug' => "Customer-Relations-Management"], ['name' => 'Finance', 'slug' => "Finance"], ['name' => 'Harbour Master', 'slug' => "Harbour-Master"], ['name' => 'Human Resources', 'slug' => "Human-Resources"], ['name' => 'IMS/ICT', 'slug' => "IMS-ICT"], ['name' => 'Island view Precinct', 'slug' => "Island-view-Precinct"], ['name' => 'Legal & Compliance', 'slug' => "Legal-Compliance"], ['name' => 'Marine Operations', 'slug' => "Marine-Operations"], ['name' => 'Maydon Wharf Precinct', 'slug' => "Maydon-Wharf-Precinct"], ['name' => 'New Business Development', 'slug' => "New-Business-Development"], ['name' => 'Planning & Development', 'slug' => "Planning-Development"], ['name' => 'Point Precinct', 'slug' => "Point-Precinct"], ['name' => 'Port Engineer', 'slug' => "Port-Engineer"], ['name' => 'Port Management', 'slug' => "Port-Management"], ['name' => 'Procurement', 'slug' => "Procurement"], ['name' => 'Real Estate', 'slug' => "Real-Estate"], ['name' => 'Security', 'slug' => "Security"], ['name' => 'SHEQ & Fire', 'slug' => "SHEQ-Fire"]];
foreach ($departments as $department) {
Department::create($department);
}
# =========================================================================
# PROVINCES SEEDS
# =========================================================================
DB::table('provinces')->delete();
$provinces = [['name' => 'KZN', 'slug' => "KZN"], ['name' => 'EC', 'slug' => "EC"], ['name' => 'WC', 'slug' => "WC"]];
foreach ($provinces as $province) {
Province::create($province);
}
# =========================================================================
# DISTRICTS SEEDS
# =========================================================================
DB::table('districts')->delete();
$districts = [['name' => 'Richards Bay', 'slug' => "Richards-Bay", 'province' => 1], ['name' => 'Durban', 'slug' => "Durban", 'province' => 1], ['name' => 'East London', 'slug' => "East-London", 'province' => 2], ['name' => 'Ngqura', 'slug' => "Ngqura", 'province' => 2], ['name' => 'Port Elizabeth', 'slug' => "Port-Elizabeth", 'province' => 2], ['name' => 'Mossel Bay', 'slug' => "Mossel-Bay", 'province' => 2], ['name' => 'Cape Town', 'slug' => "Cape-Town", 'province' => 3], ['name' => 'Saldanha ', 'slug' => "Saldanha ", 'province' => 3]];
foreach ($districts as $district) {
District::create($district);
}
# =========================================================================
# MUNICIPALITIES SEEDS
# =========================================================================
DB::table('municipalities')->delete();
$municipalites = [['name' => 'Point', 'slug' => "Point", 'district' => 2], ['name' => 'Bayhead', 'slug' => "Bayhead", 'district' => 2], ['name' => 'Containers', 'slug' => "Containers", 'district' => 2], ['name' => 'Island view', 'slug' => "Island-view", 'district' => 2], ['name' => 'Maydon Wharf', 'slug' => "Maydon-Wharf", 'district' => 2]];
foreach ($municipalites as $municipality) {
Municipality::create($municipality);
}
# =========================================================================
# CATEGORIES SEEDS
# =========================================================================
DB::table('categories')->delete();
$categories = [['name' => 'Maintenance (Civil)', 'slug' => "Maintenance-Civil)", 'department' => 17], ['name' => 'Maintenance (Electrical)', 'slug' => "Maintenance-Electrical", 'department' => 17], ['name' => 'Maintenance (Mechanical)', 'slug' => "Maintenance-Mechanical", 'department' => 17], ['name' => 'Maintenance (Marine)', 'slug' => "Maintenance-Marine", 'department' => 17], ['name' => 'Security', 'slug' => "Security", 'department' => 21], ['name' => 'House Keeping', 'slug' => "House-Keeping", 'department' => 3], ['name' => 'Traffic Management', 'slug' => "Traffic-Management", 'department' => 21], ['name' => 'Property', 'slug' => "Property", 'department' => 20], ['name' => 'Environment', 'slug' => "Environment", 'department' => 22], ['name' => 'Safety-Risk-Fire', 'slug' => "Safety-Risk-Fire", 'department' => 22], ['name' => 'Health', 'slug' => "Health", 'department' => 22], ['name' => 'Port Operations Centre', 'slug' => "Port-Operations-Centre", 'department' => 13]];
foreach ($categories as $category) {
Category::create($category);
}
# =========================================================================
# SUB-CATEGORIES SEEDS
# =========================================================================
DB::table('sub-categories')->delete();
$subcategories = [['name' => 'Water Supply', 'slug' => "Water-Supply", 'category' => 1], ['name' => 'Plumbing', 'slug' => "Plumbing", 'category' => 1], ['name' => 'Building', 'slug' => "Building", 'category' => 1], ['name' => 'Civil projects', 'slug' => "Civil-projects", 'category' => 1], ['name' => 'Road', 'slug' => "Road", 'category' => 1], ['name' => 'Tracks', 'slug' => "Tracks", 'category' => 1], ['name' => 'Welding', 'slug' => "Welding", 'category' => 1], ['name' => 'Cables', 'slug' => "Cables", 'category' => 2], ['name' => 'Poles', 'slug' => "Poles", 'category' => 2], ['name' => 'Electrical box', 'slug' => "Electrical-box", 'category' => 2], ['name' => 'No supply', 'slug' => "No-supply", 'category' => 2], ['name' => 'aircon', 'slug' => "aircon", 'category' => 2], ['name' => 'pump stations', 'slug' => "pump-stations", 'category' => 3], ['name' => 'Marine', 'slug' => "Marine", 'category' => 4], ['name' => 'Cameras', 'slug' => "Cameras", 'category' => 5], ['name' => 'perimeter fences', 'slug' => "perimeter-fences", 'category' => 5], ['name' => 'lighting', 'slug' => "lighting", 'category' => 5], ['name' => 'Theft', 'slug' => "Theft", 'category' => 5], ['name' => 'damage fence', 'slug' => "damage-fence", 'category' => 5], ['name' => 'boom gates', 'slug' => "boom-gates", 'category' => 5], ['name' => 'biometric readers', 'slug' => "biometric-readers", 'category' => 5], ['name' => 'spikes', 'slug' => "spikes", 'category' => 5], ['name' => 'Guard rooms', 'slug' => "Guard-rooms", 'category' => 5], ['name' => 'Security Guards', 'slug' => "Security-Guards", 'category' => 5], ['name' => 'Trespassers', 'slug' => "Trespassers", 'category' => 5], ['name' => 'Trucks broken down', 'slug' => "Trucks-broken-down", 'category' => 5], ['name' => 'Accidents', 'slug' => "Accidents", 'category' => 5], ['name' => 'Congestion/buildup of trucks', 'slug' => "Congestion-buildup-of-trucks", 'category' => 5], ['name' => 'Unapproved work', 'slug' => "Unapproved-work", 'category' => 5], ['name' => 'Reckless driving', 'slug' => "Reckless-driving", 'category' => 5], ['name' => 'Unsafe act', 'slug' => "Unsafe-act", 'category' => 5], ['name' => 'illegal parking', 'slug' => "illegal-parking", 'category' => 5], ['name' => 'illegal hawking', 'slug' => "illegal-hawking", 'category' => 5], ['name' => 'vagrants', 'slug' => "vagrants", 'category' => 5], ['name' => 'informal settlements', 'slug' => "informal-settlements", 'category' => 5], ['name' => 'violence', 'slug' => "violence", 'category' => 5], ['name' => 'illegal fishing', 'slug' => "illegal fishing", 'category' => 5], ['name' => 'Quayside', 'slug' => "Quayside", 'category' => 6], ['name' => 'Cargo spillages', 'slug' => "Cargo-spillages", 'category' => 6], ['name' => 'Grass cutting', 'slug' => "Grass-cutting", 'category' => 6], ['name' => 'Debri & rubbish', 'slug' => "Debri-rubbish", 'category' => 6], ['name' => 'Signage', 'slug' => "Signage", 'category' => 6], ['name' => 'misplaced equipment', 'slug' => "misplaced-equipment", 'category' => 6], ['name' => 'poor demarcation', 'slug' => "poor-demarcation", 'category' => 6], ['name' => 'potholes', 'slug' => "potholes", 'category' => 6], ['name' => 'uneven road', 'slug' => "uneven-road", 'category' => 6], ['name' => 'Trucks broken down', 'slug' => "Trucks-broken-down-2", 'category' => 7], ['name' => 'Accidents', 'slug' => "Accidents-2", 'category' => 7], ['name' => 'Congestion/buildup of trucks', 'slug' => "Congestion-buildup-of-trucks-2", 'category' => 7], ['name' => 'damage to property', 'slug' => "damage-to-property", 'category' => 8], ['name' => 'informal settlements', 'slug' => "informal-settlements-2", 'category' => 8], ['name' => 'illegal vending', 'slug' => "illegal-vending", 'category' => 8], ['name' => 'Pollution Control', 'slug' => "Pollution-Control", 'category' => 9], ['name' => 'Floating Debris/Loggs', 'slug' => "Floating-Debris-Loggs", 'category' => 9], ['name' => 'potholes', 'slug' => "potholes-2", 'category' => 10], ['name' => 'illegal trading', 'slug' => "illegal-trading", 'category' => 10], ['name' => 'open fire', 'slug' => "open-fire", 'category' => 10], ['name' => 'contractors', 'slug' => "contractors", 'category' => 10], ['name' => 'unsafe transportation', 'slug' => "unsafe-transportation", 'category' => 10], ['name' => 'truck staging', 'slug' => "truck-staging", 'category' => 10], ['name' => 'railway safety', 'slug' => "railway-safety", 'category' => 10], ['name' => 'reckless driving', 'slug' => "reckless-driving-2", 'category' => 10], ['name' => 'speeding', 'slug' => "speeding", 'category' => 10], ['name' => 'lack of signage', 'slug' => "lack-of-signage", 'category' => 10], ['name' => 'alcohol consumption', 'slug' => "alcohol-consumption", 'category' => 10], ['name' => 'smoking in non designated areas', 'slug' => "smoking-in-non-designated-areas", 'category' => 10], ['name' => 'unsafe working conditions - quayside', 'slug' => "unsafe-working-conditions-quayside", 'category' => 10], ['name' => 'unsafe hotwork', 'slug' => "unsafe-hotwork", 'category' => 10], ['name' => 'unsafe trenching/no barricade', 'slug' => "unsafe-trenching-no-barricade", 'category' => 10], ['name' => 'breathylising', 'slug' => "breathylising", 'category' => 10], ['name' => 'reverse parking', 'slug' => "reverse-parking", 'category' => 10], ['name' => 'unidentifiable vehicles', 'slug' => "unidentifiable-vehicles", 'category' => 10], ['name' => 'No PPE', 'slug' => "No-PPE", 'category' => 10], ['name' => 'pedestrians', 'slug' => "pedestrians", 'category' => 10], ['name' => 'safety belts', 'slug' => "safety-belts", 'category' => 10], ['name' => 'cellphone use while driving', 'slug' => "cellphone-use-while-driving", 'category' => 10], ['name' => 'unsafe loading', 'slug' => "unsafe-loading", 'category' => 10], ['name' => 'unroad worthy trucks', 'slug' => "unroad-worthy-trucks", 'category' => 10], ['name' => 'no safety harness (working at heights)', 'slug' => "no-safety-harness-working-at-heights", 'category' => 10], ['name' => 'no life jacket/quayside safety', 'slug' => "no-life-jacket-quayside-safety", 'category' => 10], ['name' => 'IOD', 'slug' => "IOD", 'category' => 11], ['name' => 'PPE', 'slug' => "PEE", 'category' => 11], ['name' => 'First Aid Boxes', 'slug' => "First-Aid-Boxes", 'category' => 11], ['name' => 'Occupational Diseases', 'slug' => "Occupational-Diseases", 'category' => 11], ['name' => 'Fire Extinguisher', 'slug' => "Fire-Extinguisher", 'category' => 11], ['name' => 'OPS', 'slug' => "OPS", 'category' => 12]];
foreach ($subcategories as $subcategory) {
SubCategory::create($subcategory);
}
# =========================================================================
# SUB-SUB-CATEGORIES SEEDS
# =========================================================================
DB::table('sub-sub-categories')->delete();
$subSubcategories = [['name' => 'Burst Pipes', 'slug' => "Burst-Pipes", 'sub-category' => 1], ['name' => 'No water supply', 'slug' => "No-water-supply", 'sub-category' => 1], ['name' => 'Landing Valves', 'slug' => "Landing-Valves", 'sub-category' => 1], ['name' => 'Blocked toilets', 'slug' => "Blocked-toilets", 'sub-category' => 2], ['name' => 'leaking toilets', 'slug' => "leaking-toilets", 'sub-category' => 2], ['name' => 'leaking taps', 'slug' => "leaking-taps", 'sub-category' => 2], ['name' => 'Missing toilet seats', 'slug' => "Missing-toilet-seats", 'sub-category' => 2], ['name' => 'lockers', 'slug' => "lockers", 'sub-category' => 3], ['name' => 'doors', 'slug' => "doors", 'sub-category' => 3], ['name' => 'roof leakages', 'slug' => "roof-leakages", 'sub-category' => 3], ['name' => 'Tiles etc', 'slug' => "Tiles-etc", 'sub-category' => 3], ['name' => 'broken glass/windows', 'slug' => "broken-glass-windows", 'sub-category' => 3], ['name' => 'abandoned buildings', 'slug' => "abandoned-buildings", 'sub-category' => 3], ['name' => 'Big civil projects', 'slug' => "Big civil projects", 'sub-category' => 4], ['name' => 'Road marking', 'slug' => "Road-marking", 'sub-category' => 5], ['name' => 'Potholes', 'slug' => "Potholes", 'sub-category' => 5], ['name' => 'damaged manholes', 'slug' => "damaged-manholes", 'sub-category' => 5], ['name' => 'blocked manholes', 'slug' => "blocked-manholes", 'sub-category' => 5], ['name' => 'damaged tracks', 'slug' => "damaged-tracks", 'sub-category' => 6], ['name' => 'derailments', 'slug' => "derailments", 'sub-category' => 6], ['name' => 'other track issues', 'slug' => "other-track-issues", 'sub-category' => 6], ['name' => 'rail crossing', 'slug' => "rail-crossing", 'sub-category' => 6], ['name' => 'general & tracks', 'slug' => "general-tracks", 'sub-category' => 7], ['name' => 'Exposed cable', 'slug' => "Exposed cable", 'sub-category' => 8], ['name' => 'Damaged cable', 'slug' => "Damaged-cable", 'sub-category' => 8], ['name' => 'cable theft', 'slug' => "cable-theft", 'sub-category' => 8], ['name' => 'knocked poles', 'slug' => "knocked-poles", 'sub-category' => 9], ['name' => 'light off', 'slug' => "light-off", 'sub-category' => 9], ['name' => 'exposed wire', 'slug' => "exposed-wire", 'sub-category' => 9], ['name' => 'damaged', 'slug' => "damaged", 'sub-category' => 10], ['name' => 'unsecured', 'slug' => "unsecured", 'sub-category' => 10], ['name' => 'illegal dumping', 'slug' => "illegal-dumping", 'sub-category' => 10], ['name' => 'load shedding', 'slug' => "load-shedding", 'sub-category' => 11], ['name' => 'local power failure', 'slug' => "local-power-failure", 'sub-category' => 11], ['name' => 'lights', 'slug' => "lights", 'sub-category' => 11], ['name' => 'plugs', 'slug' => "plugs", 'sub-category' => 11], ['name' => 'Quay wall damaged', 'slug' => "Quay-wall-damaged", 'sub-category' => 14], ['name' => 'sinkholes', 'slug' => "sinkholes", 'sub-category' => 14], ['name' => 'High spot', 'slug' => "High-spot", 'sub-category' => 14], ['name' => 'expansion joints', 'slug' => "expansion-joints", 'sub-category' => 14], ['name' => 'Bollards', 'slug' => "Bollards", 'sub-category' => 14], ['name' => 'damaged fenders', 'slug' => "damaged-fenders", 'sub-category' => 14], ['name' => 'seawalls undermining', 'slug' => "seawalls undermining", 'sub-category' => 14], ['name' => 'Diving', 'slug' => "Diving", 'sub-category' => 14], ['name' => 'illegal dumping', 'slug' => "illegal-dumping-2", 'sub-category' => 56], ['name' => 'Oil Spillage', 'slug' => "Oil-Spillage", 'sub-category' => 56], ['name' => 'cargo spillage', 'slug' => "cargo-spillage", 'sub-category' => 56], ['name' => 'offensive odour', 'slug' => "offensive-odour", 'sub-category' => 57], ['name' => 'over flowing skips', 'slug' => "over-flowing-skips", 'sub-category' => 57], ['name' => 'unmarked skips', 'slug' => "unmarked-skips", 'sub-category' => 57], ['name' => 'overflowing wheely bins', 'slug' => "overflowing-wheely-bins", 'sub-category' => 57], ['name' => 'clogged storm water drains', 'slug' => "clogged-storm-water-drains", 'sub-category' => 57], ['name' => 'overflowing sewer', 'slug' => "overflowing-sewer", 'sub-category' => 57], ['name' => 'stagnant water', 'slug' => "stagnant-water ", 'sub-category' => 57], ['name' => 'Debris & accumulated litter', 'slug' => "Debris-accumulated-litter", 'sub-category' => 57], ['name' => 'Body', 'slug' => "Body", 'sub-category' => 84], ['name' => 'PPE', 'slug' => "PPE", 'sub-category' => 85], ['name' => 'Inspection', 'slug' => "Inspection", 'sub-category' => 86], ['name' => 'OCC Asthmas', 'slug' => "OCC-Asthmas", 'sub-category' => 87], ['name' => 'Noise induced hearing Loss', 'slug' => "Noise-induced-hearing-Loss", 'sub-category' => 87], ['name' => 'OCC Dermatitis', 'slug' => "OCC-Dermatitis", 'sub-category' => 87], ['name' => 'inspection', 'slug' => "inspection-2", 'sub-category' => 88], ['name' => 'ALL OPS ISSUES', 'slug' => "ALL-OPS-ISSUES", 'sub-category' => 89]];
foreach ($subSubcategories as $subSubcategory) {
SubSubCategory::create($subSubcategory);
}
}