/**
* Run the migrations.
*
* @return void
*/
public function up()
{
// Create level 0 : member
Level::create(['level' => 0, 'name' => 'membre']);
// Create level 1 : band_creator
Level::create(['level' => 1, 'name' => 'manager']);
// Create level 2 : teacher
Level::create(['level' => 2, 'name' => 'professeur']);
// Create level 3 : admin
Level::create(['level' => 3, 'name' => 'admin']);
// Create level 10 : webmaster
Level::create(['level' => 10, 'name' => 'webmaster']);
// Create departement : "aucun"
Department::create(['name' => 'Aucun', 'short_name' => 'Aucun']);
// Create user : Webmaster (lvl 10)
User::create(['first_name' => 'Webmaster', 'last_name' => 'Webmaster', 'email' => 'webm@ster', 'school_year' => 0, 'department_id' => 1, 'password' => bcrypt('webmastercmt'), 'level_id' => 5, 'slug' => 'webmaster-webmaster-1']);
Category::create(['name' => 'Aucune']);
Category::create(['name' => 'Autre']);
Category::create(['name' => 'Présentation']);
Category::create(['name' => 'Création de groupe']);
Category::create(['name' => 'Recherche de groupe']);
Category::create(['name' => 'Échange/Vente']);
//Creation basic instruments :
$instruments = ['autre', 'guitare', 'piano', 'basse', 'chant', 'flûte', 'violon', 'contrebasse', 'clarinette', 'saxophone', 'batterie', 'violoncelle', 'guitare électrique', 'flûte traversière', 'trompette', 'cor', 'trombone', 'tuba'];
$this->create_instrument($instruments);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
//
$data = $request->except('_token');
Department::create($data);
return back();
}
public function importDept($destfile)
{
$this->count['dept->success'] = 0;
$this->count['dept->failed'] = 0;
Excel::load($destfile, function ($reader) {
$rules = ['name' => 'required|unique_with:departments,company_id,costcent', 'company_id' => 'required|exists:companies,id', 'costcent' => 'required'];
$sheetsCount = $reader->getSheetCount();
for ($i = 0; $i < $sheetsCount; $i++) {
$sheets = $reader->getSheet($i)->toArray();
$company_name = $reader->getSheet($i)->getTitle();
$dept['company_id'] = Company::where('name', $company_name)->value('id');
$sheetCount = count($sheets);
for ($j = 6; $j < $sheetCount; $j++) {
$dept['name'] = trim($sheets[$j][1]);
$dept['costcent'] = trim($sheets[$j][10]);
$dept['description'] = $dept['name'];
$dept_v = \Validator::make($dept, $rules);
if ($dept_v->passes()) {
Department::create($dept);
$this->count['dept->success'] += 1;
} else {
$this->count['dept->failed'] += 1;
}
}
}
//END
});
return $this->count;
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker\Factory::create();
foreach (range(1, 10) as $index) {
Department::create(['title' => $faker->company]);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('departments')->delete();
Department::create(['title' => 'Администрация']);
Department::create(['title' => 'Отдел 1']);
Department::create(['title' => 'Отдел 2']);
Department::create(['title' => 'Отдел 3']);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
DB::table('Departments')->delete();
$departments = array(['department_name' => 'department of electrical and power engineering', 'faculty_id' => '1'], ['department_name' => 'department of electrical and telcom engineering', 'faculty_id' => '1'], ['department_name' => 'department of computer science', 'faculty_id' => '2']);
foreach ($departments as $department) {
Department::create($department);
}
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(DepartmentRequest $request)
{
try {
Department::create($request->all());
Flash::success('The Department has been created.');
return redirect()->route('department.index');
} catch (Exception $e) {
Flash::error('The Department could not be created.');
}
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
if (Request::isMethod('get')) {
$this->data['items'] = Department::get();
return view('pages.department.create', $this->data);
} elseif (Request::isMethod('post')) {
$department = Department::create(Input::all());
return redirect('department');
}
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
if ($this->validator($request->all())->fails()) {
flash()->error('There is something wrong with the inputs.');
return redirect()->back();
} else {
Department::create($request->all());
flash()->success("Department successfully added!");
return redirect()->back();
}
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(Request $request)
{
$validator = $this->validator($request->all());
if ($validator->fails()) {
Flash::error('Impossible d\'ajouter ce département.');
return Redirect::back()->withErrors($validator->errors());
}
$dep = Department::create(['name' => $request->name, 'short_name' => $request->short_name]);
Modification::create(['table' => 'departments', 'user_id' => Auth::user()->id, 'message' => 'added department ' . $request->name . ' (' . $request->short_name . ')']);
Flash::success('Le département a bien été créé !');
return redirect('admin/departments');
}
/**
* Store a newly created resource in storage.
*
* @param \App\Http\Requests\DepartmentRequest $request
* @return \Illuminate\Http\Response
*/
public function store(Requests\DepartmentRequest $request)
{
DB::transaction(function () use($request) {
$department = Department::create(['keyword' => $request->get('keyword'), 'url' => $request->get('url'), 'image' => $request->file('image')->getClientOriginalName(), 'theme_background_color' => $request->get('theme_background_color'), 'theme_color' => $request->get('theme_color'), 'sort' => $request->get('sort'), 'active' => $request->get('active')]);
$this->addDepartmentLangs($request, $department);
$request->file('image')->move('images/', $request->file('image')->getClientOriginalName());
if (!File::exists('papers/' . $department->keyword)) {
File::makeDirectory('papers/' . $department->keyword);
}
Cache::forget('departments');
});
return redirect(action('Admin\\DepartmentController@index'))->with('success', 'saved');
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
Department::create($request->input());
foreach (BusinessPlan::lists('id') as $bid) {
$newGoal = new Goat();
$newGoal->type = 'G';
$newGoal->parent_id = null;
$newGoal->description = $request['name'] . " Goals";
$newGoal->priority = 0;
$newGoal->complete = false;
$newGoal->goal_type = 'D';
$newGoal->due_date = null;
$newGoal->budget = 0;
$newGoal->bid = $bid;
$newGoal->save();
}
return redirect('admin/depts');
}
/**
* Add a department
*
* @param Request $request
* @return \Illuminate\Http\RedirectResponse
*/
public function addDepartment(Request $request)
{
$dCode = $request['dCode'];
$dName = $request['dName'];
Department::create(['dCode' => $dCode, 'dName' => $dName]);
return redirect()->back()->with('status', 'Success');
}
public function store(DepartmentRequest $request, Department $department)
{
$department->create($request->all());
return redirect('/configuration#department')->withSuccess(config('constants.ADDED'));
}
/**
* Store a newly created department in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(SaveDepartmentRequest $request)
{
Department::create(['code' => $request->code, 'name' => $request->name]);
$departments = Department::all();
return view('layouts.viewDepartments', ['departments' => $departments]);
}
/**
* Store a csv created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function import(Request $request)
{
if ($request->file('csv-file')->isValid()) {
$csv_file = $request->file('csv-file');
if ("text/csv" == $csv_file->getClientMimeType()) {
$dest_path = storage_path('temp');
$file_name = time() . '_' . str_replace(" ", "_", $csv_file->getClientOriginalName());
$csv_file->move($dest_path, $file_name);
$fname = $dest_path . '/' . $file_name;
$file = fopen($fname, "r");
$flash_message = [];
$flash_error = 0;
while (!feof($file)) {
$tmp_data = fgetcsv($file);
$item['code'] = !empty($tmp_data[0]) ? $tmp_data[0] : '';
$item['name'] = !empty($tmp_data[1]) ? $tmp_data[1] : '';
$item['description'] = !empty($tmp_data[2]) ? $tmp_data[2] : '';
$v = Validator::make($item, ['code' => 'required|unique:departments|max:20', 'name' => 'required|max:254']);
if (!$v->fails()) {
Department::create($item);
$flash_message['success'][] = '[' . $item['code'] . '] ' . $item['name'];
} else {
$flash_error++;
$flash_message['error'] = $flash_error;
}
}
\Session::flash('flash_message', $flash_message);
fclose($file);
chmod($fname, 0777);
unlink($fname);
}
}
return redirect('/departments');
}
public function importDept($destfile)
{
Excel::load($destfile, function ($reader) {
$rules = ['name' => 'required|unique_with:departments,company_id,costcenter', 'company_id' => 'exists:companies,id', 'costcenter' => 'required'];
$sheetsCount = $reader->getSheetCount();
for ($i = 0; $i < $sheetsCount; $i++) {
$sheets = $reader->getSheet($i)->toArray();
$company_name = $reader->getSheet($i)->getTitle();
$dept['company_id'] = Company::where('name', $company_name)->value('id');
$sheetCount = count($sheets);
for ($j = 6; $j < $sheetCount; $j++) {
$dept['name'] = $sheets[$j][1];
$dept['costcenter'] = $sheets[$j][10];
$dept_v = \Validator::make($dept, $rules);
if ($dept_v->fails()) {
} else {
Department::create($dept);
}
}
}
//END
});
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
// Create departement : "autre"
Department::create(['name' => 'Autre', 'short_name' => 'PeiP']);
// Create departement : DI
Department::create(['name' => 'Département Informatique', 'short_name' => 'DI']);
// Create departement : DMS
Department::create(['name' => 'Département Mécanique', 'short_name' => 'DMS']);
// Create user : Admin (lvl 3)
User::create(['first_name' => 'Admin', 'last_name' => 'Admin', 'email' => 'admin@admin', 'school_year' => 0, 'department_id' => 1, 'password' => bcrypt('admincmt'), 'level_id' => 4, 'slug' => 'admin-admin-2']);
// Create user : Teacher (lvl 2)
User::create(['first_name' => 'Teacher', 'last_name' => 'Teacher', 'email' => 'teacher@teacher', 'school_year' => 0, 'department_id' => 1, 'password' => bcrypt('teachercmt'), 'level_id' => 3, 'slug' => 'teacher-teacher-3']);
// Create user : band_creator (lvl 1)
User::create(['first_name' => 'Band', 'last_name' => 'Creator', 'email' => 'band@creator', 'school_year' => 0, 'department_id' => 1, 'password' => bcrypt('membercmt'), 'level_id' => 2, 'slug' => 'band-creator-5,']);
// Create user : Member (lvl 0)
User::create(['first_name' => 'Member', 'last_name' => 'Member', 'email' => 'member@member', 'school_year' => 0, 'department_id' => 1, 'password' => bcrypt('membercmt'), 'level_id' => 1, 'slug' => 'member-member-4']);
// Create Article 'Cours de guitare'
Article::create(['title' => 'Cours de guitare', 'subtitle' => 'Article concernant le cours de guitare', 'content' => '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam purus tortor, efficitur ut iaculis ut,
tincidunt vel elit. Morbi malesuada ipsum eu fermentum consequat. Duis aliquam, massa et bibendum
facilisis, nulla nibh ultricies ante, a rutrum augue tellus quis erat. Curabitur aliquam ipsum gravida,
interdum mauris non, blandit justo. Donec non mollis orci, a accumsan ligula. Nullam quis sapien elementum
neque egestas lacinia</p>', 'user_id' => 2, 'slug' => 'cours-de-guitare-1', 'category_id' => 3, 'validated' => 1]);
// Create Article 'Cours de piano'
Article::create(['title' => 'Cours de piano', 'subtitle' => 'Article concernant le cours de piano', 'content' => '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam purus tortor, efficitur ut iaculis ut,
tincidunt vel elit. Morbi malesuada ipsum eu fermentum consequat. Duis aliquam, massa et bibendum
facilisis, nulla nibh ultricies ante, a rutrum augue tellus quis erat. Curabitur aliquam ipsum gravida,
interdum mauris non, blandit justo. Donec non mollis orci, a accumsan ligula. Nullam quis sapien elementum
neque egestas lacinia</p>', 'user_id' => 3, 'slug' => 'cours-de-piano-2', 'category_id' => 3, 'validated' => 1]);
// Create guitar course
Course::create(['name' => 'Cours de guitare', 'day' => 1, 'start' => '18:30:00', 'end' => '20:00:00', 'infos' => 'Cours de guitare du lundi soir.', 'slug' => 'cours-de-guitare-lundi-1', 'instrument_id' => 2, 'article_id' => 1, 'user_id' => 2]);
// Create piano course
Course::create(['name' => 'Cours de piano', 'day' => 3, 'start' => '18:30:00', 'end' => '20:00:00', 'infos' => 'Cours de piano du mardi soir.', 'slug' => 'cours-de-piano-mardi-2', 'instrument_id' => 3, 'article_id' => 2, 'user_id' => 3]);
// Create Band 'The Band'
Band::create(['name' => 'The Band', 'infos' => 'premier groupe de test', 'user_id' => 1, 'validated' => 1, 'slug' => 'the-band-1', 'article_id' => 2]);
// Create band 'Second Band'
Band::create(['name' => 'Second Band', 'infos' => 'deuxieme groupe de test', 'user_id' => 2, 'validated' => 1, 'slug' => 'second-band-2', 'article_id' => 1]);
// Create News 'test news'
News::create(['title' => 'test news', 'content' => '<p>Contenu de la première news de test</p>', 'user_id' => 1, 'slug' => 'test-news-1']);
// Create News 'test second news'
News::create(['title' => 'test seconde news', 'content' => '<p>Contenu de la deuxieme news de test</p>', 'user_id' => 2, 'slug' => 'test-seconde-news-1']);
// Create announcement 'test d'une annonce'
Announcement::create(['user_id' => 1, 'title' => 'test d\'une annonce', 'slug' => 'test-annonce-1', 'validated' => 1, 'subject' => 'Annonce pour tester', 'category_id' => 1, 'content' => '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque in malesuada leo.
Suspendisse ut dapibus urna. Nunc mattis velit vel varius luctus. Fusce ornare arcu nec odio
egestas, et lacinia sapien laoreet. Maecenas odio dui, fringilla non sapien euismod, volutpat
porta sapien. Suspendisse mauris quam, maximus quis tempus non, feugiat in tellus. Sed non quam aliquet,
sollicitudin risus nec, mollis turpis. Donec interdum tincidunt efficitur. Nam efficitur enim a leo
pellentesque, venenatis sollicitudin lacus suscipit. Ut eu nunc eget lacus vehicula gravida. Fusce
vitae ante bibendum, maximus nisl quis, lacinia metus. In pharetra placerat lacus, sed fringilla ex
imperdiet vel. Nulla mollis risus tellus, a ultricies tellus tempor cursus. Quisque viverra nunc ipsum,
a ullamcorper dui porttitor eu. Suspendisse nec nunc ut mi dignissim ultrices.</p>
<p>In libero sem, dictum in venenatis sit amet, dictum id quam. Aliquam id ligula luctus,
lobortis felis eget, sollicitudin nulla. Suspendisse tempus aliquet volutpat. Integer lacinia
sem ac libero faucibus cursus. Morbi mauris massa, interdum vel placerat sit amet, rutrum eget
turpis. Mauris convallis semper sem, eu pharetra tortor sagittis non. Praesent auctor justo nulla,
in rhoncus ipsum porta ut. Mauris bibendum fringilla accumsan. Proin bibendum eros eros. Aliquam
vulputate, nisi vitae tristique lacinia, leo risus volutpat augue, vel ultricies lorem urna vitae erat.
Vestibulum varius, libero eget sollicitudin luctus, lacus massa molestie purus, quis blandit felis sem at dui.</p>']);
// Create announcement 'test d'une seconde annonce'
Announcement::create(['user_id' => 2, 'content' => '<p>contenu de la deuxieme annonce</p>', 'title' => 'test d\'une seconde annonce', 'slug' => 'test-seconde-annonce-2', 'validated' => 1, 'subject' => 'Deuxieme annonce pour tester', 'category_id' => 1]);
// Create announcement unvalidated
Announcement::create(['user_id' => 3, 'content' => '<p>azre</p>', 'title' => 'azr', 'slug' => 'test-annonce-invalidee-3', 'validated' => 0, 'subject' => 'Annonce invalidée pour tester', 'category_id' => 1]);
// Create comment on announcement #1
Comment::create(['announcement_id' => 1, 'user_id' => 1, 'content' => '<p>Nam efficitur enim a leo pellentesque, venenatis sollicitudin lacus suscipit. Ut eu
nunc eget lacus vehicula gravida. Fusce vitae ante bibendum, maximus nisl quis, lacinia metus.
In pharetra placerat lacus, sed fringilla ex imperdiet vel. Nulla mollis risus tellus, a ultricies
tellus tempor cursus. Quisque viverra nunc ipsum, a ullamcorper dui porttitor eu. Suspendisse nec
nunc ut mi dignissim ultrices.</p>
<p>In libero sem, dictum in venenatis sit amet, dictum id quam. Aliquam id ligula luctus,
lobortis felis eget, sollicitudin nulla. Suspendisse tempus aliquet volutpat. Integer
lacinia sem ac libero faucibus cursus.</p>']);
// Create comment on announcement #1
Comment::create(['announcement_id' => 1, 'user_id' => 2, 'content' => '<p>In libero sem, dictum in venenatis sit amet, dictum id quam. Aliquam id ligula luctus,
lobortis felis eget, sollicitudin nulla. Suspendisse tempus aliquet volutpat. Integer
lacinia sem ac libero faucibus cursus.</p>
<p>Nam efficitur enim a leo pellentesque, venenatis sollicitudin lacus suscipit. Ut eu
nunc eget lacus vehicula gravida. Fusce vitae ante bibendum, maximus nisl quis, lacinia metus.
In pharetra placerat lacus, sed fringilla ex imperdiet vel. Nulla mollis risus tellus, a ultricies
tellus tempor cursus. Quisque viverra nunc ipsum, a ullamcorper dui porttitor eu. Suspendisse nec
nunc ut mi dignissim ultrices.</p>']);
// Create comment on announcement #2
Comment::create(['announcement_id' => 2, 'user_id' => 1, 'content' => '<p>commentaire annonce 2</p>']);
// Create Article 'premier article'
Article::create(['title' => 'premier article', 'subtitle' => 'test d\'un premier article', 'content' => '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam purus tortor, efficitur ut iaculis ut,
tincidunt vel elit. Morbi malesuada ipsum eu fermentum consequat. Duis aliquam, massa et bibendum
facilisis, nulla nibh ultricies ante, a rutrum augue tellus quis erat. Curabitur aliquam ipsum gravida,
interdum mauris non, blandit justo. Donec non mollis orci, a accumsan ligula. Nullam quis sapien elementum
neque egestas lacinia</p>', 'user_id' => 1, 'slug' => 'premier-article-3', 'category_id' => 2, 'validated' => 1]);
// Create Article 'deuxieme article'
Article::create(['title' => 'deuxieme article', 'subtitle' => 'test d\'un deuxieme article', 'content' => '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam purus tortor, efficitur ut iaculis ut,
tincidunt vel elit. Morbi malesuada ipsum eu fermentum consequat. Duis aliquam, massa et bibendum
facilisis, nulla nibh ultricies ante, a rutrum augue tellus quis erat. Curabitur aliquam ipsum gravida,
interdum mauris non, blandit justo. Donec non mollis orci, a accumsan ligula. Nullam quis sapien elementum
neque egestas lacinia</p>', 'user_id' => 2, 'slug' => 'deuxieme-article-4', 'category_id' => 1]);
// Create Event 'concert de The Band'
Event::create(['location' => '23 avenue de la Team Musique', 'day' => 6, 'start' => '18:00:00', 'end' => '00:00:00', 'infos' => 'infos du premier event', 'name' => 'Concert de The Band', 'slug' => 'concert-the-band', 'user_id' => 1, 'date' => '2016-03-27', 'article_id' => 1]);
// Create Event 'concert de ouf'
Event::create(['location' => '186 avenue de la Team Musique', 'day' => 5, 'start' => '17:00:00', 'end' => '23:00:00', 'infos' => 'infos du deuxieme event', 'name' => 'Concert de ouf', 'slug' => 'concert-de-ouf', 'user_id' => 2, 'date' => '2016-04-12', 'article_id' => 2]);
// Associate Band 1 to Event 1
BandEvent::create(['band_id' => 1, 'event_id' => 1]);
// Associate band 1 to event 2
BandEvent::create(['band_id' => 1, 'event_id' => 2]);
// Associate band 2 to event 2
BandEvent::create(['band_id' => 2, 'event_id' => 2]);
// Associate Members to Bands
BandUser::create(['user_id' => 1, 'band_id' => 1, 'instrument_id' => 1]);
BandUser::create(['user_id' => 2, 'band_id' => 1, 'instrument_id' => 2]);
BandUser::create(['user_id' => 3, 'band_id' => 1, 'instrument_id' => 3]);
BandUser::create(['user_id' => 2, 'band_id' => 2, 'instrument_id' => 5]);
BandUser::create(['user_id' => 3, 'band_id' => 2, 'instrument_id' => 10]);
// Associate Users to Courses as Students
CourseUser::create(['user_id' => '1', 'course_id' => 1, 'validated' => 1, 'level' => 0]);
CourseUser::create(['user_id' => '3', 'course_id' => 1, 'validated' => 1, 'level' => 0]);
CourseUser::create(['user_id' => '1', 'course_id' => 2, 'validated' => 1, 'level' => 0]);
CourseUser::create(['user_id' => '4', 'course_id' => 2, 'validated' => 0, 'level' => 0]);
// Associate Users to Courses as Teachers
CourseUser::create(['user_id' => '3', 'course_id' => 1, 'validated' => 1, 'level' => 1]);
CourseUser::create(['user_id' => '2', 'course_id' => 1, 'validated' => 1, 'level' => 1]);
CourseUser::create(['user_id' => '2', 'course_id' => 2, 'validated' => 1, 'level' => 1]);
CourseUser::create(['user_id' => '4', 'course_id' => 1, 'validated' => 0, 'level' => 1]);
// Course Modification tests
CourseModification::create(['author_id' => 1, 'user_id' => 1, 'course_id' => 1, 'value' => 0]);
CourseModification::create(['author_id' => 2, 'user_id' => 2, 'course_id' => 1, 'value' => 1]);
CourseModification::create(['author_id' => 1, 'user_id' => 3, 'course_id' => 2, 'value' => 2]);
CourseModification::create(['author_id' => 3, 'user_id' => 2, 'course_id' => 2, 'value' => 3]);
}
/**
* Create new employee department choice
*
* @param SaveDepartmentRequest $request
* @return mixed
*/
public function createDept(SaveDepartmentRequest $request)
{
Department::create($request->all());
}
/**
* 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);
}
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(Request $request)
{
$department = Department::create($request->all());
return redirect()->route('departments.index');
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(DepartmentRequest $request)
{
$newDepartment = $request->all();
Department::create($newDepartment);
return redirect('home/department');
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$this->validate($request, ['p_id' => 'required', 'dept_name' => 'required']);
$dept = Department::create(['p_id' => $request->get('p_id'), 'dept_name' => $request->get('dept_name')]);
return Response()->json($dept);
}
