/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$course = new Course();
$course->course_name = $request->course_name;
$course->grade_level = $request->grade_level;
//$course->school_id = '0';
$course->save();
return back()->with('status', sprintf("Successfully added %s", $request->course_name));
//Validation Goes here
/*
$validator = Validator::make($request->all(), [
'course_name' => 'required',
'grade_level' => 'required',
]);
var_dump($validator->fails());
if($validator->fails()):
return back()
->withErrors($validator->errors())
->withInput();
else:
$course = new Course;
$course->course_name = $request->course_name;
$course->grade_level = $request->grade_level;
//$course->school_id = '0';
//$course->save();
return back()->with('status', sprintf("Successfully added %s",$request->course_name));
endif;
*/
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(CourseFormRequest $request)
{
$course = new Course(array('course_name' => $request->get('course_name'), 'introduction' => $request->get('introduction'), 'objectives' => $request->get('objectives'), 'course_contents' => $request->get('course_contents'), 'training_methods' => $request->get('training_methods'), 'participants' => $request->get('participants'), 'duration' => $request->get('duration'), 'academic_staff' => $request->get('academic_staff'), 'course_fee' => $request->get('course_fee'), 'accommodation_and_food' => $request->get('accommodation_and_food'), 'library' => $request->get('library'), 'award' => $request->get('award'), 'address_for_correspondence' => $request->get('address_for_correspondence'), 'training_id' => $request->get('training_id')));
$course->save();
$id = $request->get('id');
return redirect('/courses')->with('Your course has been created!Its id is: ' . $id);
}
/**
* Handles creation of new courses
* @param Request $request
* @return mixed
*/
public function create(Request $request)
{
// Make sure that the all required fields are present
if ($request->has('title') && $request->has('description') && $request->has('start_date') && $request->has('start_time') && $request->has('end_date') && $request->has('end_time') && $request->has('price') && $request->has('total_slots')) {
// Make sure we have an active user
if (Auth::check()) {
// Retrieve the formdata from the request
$formdata = $request->all();
// Create a new course to fill with this info
$course = new Course();
// Apply the formdata to the new course
$course->title = $formdata['title'];
$course->description = $formdata['description'];
$course->start = $formdata['start_date'] . ' ' . $formdata['start_time'];
$course->end = $formdata['end_date'] . ' ' . $formdata['end_time'];
$course->price = $formdata['price'];
$course->total_slots = $formdata['total_slots'];
$course->instructor_id = Auth::id();
// Create the new course
$course->save();
// Redirect the user back to their homepage with a success message
return Redirect::to('/home')->with('success', 'Course created successfully');
}
}
// Redirect the user back to their homepage with a failure message
return Redirect::to('/home')->with('error', 'Please fill out all required fields and try again');
}
public function store(Request $request)
{
$inputs = $request->all();
$course = new Course();
$course->fill($inputs);
$course->save();
return $course->id;
}
public function store(CourseRequest $request)
{
$course = new Course($request->only(['name']));
$course->save();
$course->users()->sync($request->input('users'));
$course->teachers()->sync($request->input('teachers'));
session()->flash('success', 'El curso se ha creado.');
return redirect()->route('admin.course.edit', $course->id);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(saveCourseRequest $request)
{
$course = new Course($request->except(['department', 'semester']));
$department = Department::where('code', $request->input('department'))->first();
$semester = Semester::find($request->input('semester'));
$course->department()->associate($department);
$course->semester()->associate($semester);
$course->save();
$request->session()->flash('status', 'Course was saved successful!');
return back();
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
//dd($request->all());
$course = new Course();
$course->course_name = $request->input('course_name');
$course->course_instructor = $request->input('course_instructor');
$course->semester_id = $request->input('semester_id');
$course->course_time_id = $request->input('course_time_id');
$course->course_location = $request->input('course_location');
$course->save();
return redirect('courses');
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$crs = new Course();
$crs->name = $request['name'];
$crs->affiliateId = $request['affiliateId'];
$crs->streamId = $request['streamId'];
$crs->levelId = $request['levelId'];
$crs->courseType = $request['courseType'];
$crs->duration = $request['duration'];
$crs->save();
\Session::flash('sucess_message', 'Course is sucessfully created.');
return redirect('myAdmin/courses');
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(CourseFormRequest $request)
{
$input = $request->course_image;
if (isset($input)) {
$Image = $this->imageUpload($input);
} else {
$Image = "course_img/default.jpg";
}
$course = new Course(array('course_name' => $request->get('course_name'), 'introduction' => $request->get('introduction'), 'objectives' => $request->get('objectives'), 'course_contents' => $request->get('course_contents'), 'training_methods' => $request->get('training_methods'), 'participants' => $request->get('participants'), 'duration' => $request->get('duration'), 'academic_staff' => $request->get('academic_staff'), 'course_fee' => $request->get('course_fee'), 'accommodation_and_food' => $request->get('accommodation_and_food'), 'library' => $request->get('library'), 'award' => $request->get('award'), 'address_for_correspondence' => $request->get('address_for_correspondence'), 'training_id' => $request->get('training_id'), 'course_image' => $Image));
$course->save();
$id = $request->get('id');
return redirect('/create_course')->with('status', 'Your course has been created!');
}
public function store()
{
$request = json_decode(request()->getContent());
$rules = array('name' => 'required|unique:courses', 'attendants' => 'required');
$validation = Validator::make((array) $request, $rules);
if ($validation->fails()) {
return response()->json(array('error' => true, 'message' => $validation->errors()->all(), 200));
}
$course = new Course();
$course->name = $request->name;
$course->attendants = abs($request->attendants);
$saved = $course->save();
return response()->json(array('error' => !$saved, 'courses' => $course->toArray()), $saved ? 200 : 500);
}
public function registercourse()
{
$messages = array('course_code.required' => 'Code is required', 'course_code.unique' => 'This course is already registered', 'course_code.min' => 'Code must be at least 6 characters', 'course_code.max' => 'Code must be at most 8 characters', 'coursename.required' => 'Course name is required');
$validator = Validator::make(Input::all(), ['course_code' => 'required|min:6|max:8|unique:courses', 'coursename' => 'required'], $messages);
if ($validator->fails()) {
return redirect('addcourse')->withInput()->withErrors($validator);
}
$course = new Course();
$course->course_code = Input::get('course_code');
$course->course_title = Input::get('coursename');
$course->credit = Input::get('coursecredit');
$course->save();
return view('layouts.addcourse')->with('registermsg', "Course registered.");
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
$courses = new Course();
$courses->program_study_id = Input::get('program_study_id');
$courses->course_code = Input::get('course_code');
$courses->course_name = Input::get('course_name');
$courses->semester = Input::get('semester');
$courses->credits = Input::get('credits');
$courses->faculty_code = Input::get('faculty_code');
$courses->study_id = Input::get('study_id');
$courses->save();
Session::flash('message', 'You have successfully added course');
return Redirect::to('dashboard/admin/courses');
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function storeCourse(Request $request)
{
$data = Request::all();
if (Course::find($data['scourse'])) {
return back()->withInput();
} else {
$course = new Course();
$course->college = $data['college'];
$course->scourse = $data['scourse'];
$course->course = $data['course'];
$course->campus = $data['campus'];
$course->save();
return Redirect::to('/admin');
}
}
/**
* Save request info as new course in database.
*
* @param Request $request
* @return Response
*/
public function add_course(Request $request)
{
$check = DB::table('courses')->where('department', '=', '$request->department')->where('number', '=', '$request->number')->first();
if (!empty($check)) {
$data = array('old' => $request);
session()->put('error', 'Course with department and number already exists.');
return view('course_add', $data);
}
$course = new Course();
$course->department = $request->department;
$course->number = $request->number;
$course->description = $request->description;
$course->save();
session()->put('success', 'Course has been added.');
return redirect('/course/' . $course->id);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
//dd($request->all());
$this->validate($request, ['slug' => 'unique:courses,slug', 'name' => 'required', 'short_description' => 'required', 'description' => 'required', 'date_start' => 'required|date|after:today', 'date_end' => 'required|date|after:date_start', 'min_participants' => 'required|integer', 'max_participants' => 'required|integer', 'price' => 'required|integer']);
$course = new Course();
if ($request->hasFile('featured_image')) {
$featured_image = $course->uploadImage($request->featured_image);
}
$course->fill($request->all());
if (isset($featured_image)) {
$course->featured_image = $featured_image;
}
$course->save();
Session::flash('flash_message', 'Námskeiðið var vistað');
return redirect()->back();
}
/**
* Store a newly created resource in storage.
*
* @param CreateCourseRequest $request
* @return \Illuminate\Http\RedirectResponse
*/
public function store(CreateCourseRequest $request)
{
$course = new Course();
$course->fill($request->all());
$course->user_id = Auth::user()->id;
if ($request->hasFile('image')) {
$file = $request->file('image');
$patch = 'images/courses/';
$name = $course->id . '.' . $file->getClientOriginalExtension();
$image = $patch . $name;
Image::make($file)->fit(650, 360)->save($image);
$course->image = $image;
}
$course->save();
$message = trans('messages.course_successfully_started');
Flash::success($message);
return redirect()->route('teacher.courses.show', $course);
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(Request $request)
{
$this->validate($request, ['id' => 'required|unique:courses', 'id_1' => 'required', 'id_2' => 'required', 'id_3' => 'required', 'id_4' => 'required', 'name' => 'required', 'author' => 'required', 'introduction' => 'required', 'body' => 'required', 'pay_type' => 'required', 'score' => 'required', 'ava_dir' => 'required', 'vid_dir' => 'required']);
$course = new Course();
$course->id = Input::get('id');
$course->id_1 = Input::get('id_1');
$course->id_2 = Input::get('id_2');
$course->id_3 = Input::get('id_3');
$course->id_4 = Input::get('id_3');
$course->name = Input::get('name');
$course->author = Input::get('author');
$course->introduction = Input::get('introduction');
$course->body = Input::get('body');
$course->pay_type = Input::get('pay_type');
$course->score = Input::get('score');
$course->ava_dir = Input::get('ava_dir');
$course->vid_dir = Input::get('vid_dir');
if ($course->save()) {
return Redirect::to('admin');
} else {
return Redirect::back()->withInput()->withErrors('保存失败！');
}
}
public function import(Request $request)
{
$file = $request->file('excel');
//var_dump($filename);
Excel::load($file, function ($input) {
$results = $input->all();
foreach ($results as $result) {
// Search if a course exist
$course = Course::where('code', $result->codigo)->first();
// if doesn't exist we save it
if (!isset($course)) {
$area = Area::where('name', $result->area)->first();
$course = new Course();
$course->area_id = $area->id;
$course->code = $result->codigo;
$course->name = $result->nombre;
$course->section = $result->seccion;
$course->year = $result->year;
$course->semester = $result->semestre;
$course->branch = $result->sucursal;
$course->schedule = $result->horario;
$course->load = $result->carga;
$course->save();
}
}
});
return redirect()->route('courses.index')->with('message', 'Cursos creados Correctamente.');
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
$upload = new Course();
if (Request::hasFile('upload')) {
$file = Request::file('upload');
//$file = $file->move(public_path() . '/uploads/courses', time() .'-' . $file->getClientOriginalName());
$upload->file_path = $file->getRealPath();
//$upload->save();
$csvPath = $upload->file_path;
$reader = Reader::createFromPath($csvPath);
$reader->setFlags(SplFileObject::READ_AHEAD | SplFileObject::SKIP_EMPTY);
$reader->setOffset(1);
$pattern = '/([(A-Z)|A-Z]* - .+)/';
$paperPattern = '/\\b(ACCA|CIMA)\\b/';
$centres = DB::table('centres')->get();
$papers = DB::table('papers')->get();
foreach ($reader as $index => $row) {
if ($index != 0) {
$centreCode = $row[0];
$courseNo = $row[1];
$courseName = $row[2];
$startDate = $row[5];
$status = $row[8];
$price = $row[9];
/*foreach ($centres as $centre)
{
if($centreCode == $centre->centre_code)
{
$centreId = $centre->id;
preg_match($pattern, $courseName, $matches);
DB::table('courses')->insert(
array(
'course_no' => $courseNo,
'name' => $matches[0],
'start_date' => $startDate,
'price' => $price,
'status' => $status,
'centre_id' => $centreId,
)
);
}
}
*/
foreach ($papers as $paper) {
preg_match($paperPattern, $courseName, $paperMatch);
dd($paperMatch);
}
}
}
}
$upload->save();
return redirect('courses')->with('status', 'Courses Uploaded');
}
public function saveCourse(CreateCourseRequest $req)
{
$courseGuid = Uuid::uuid();
$course = new Course();
$course->course_guid = $courseGuid;
$course->abrr = $req->abrr;
$course->name = $req->name;
$course->college = $req->college;
$course->save();
$majors = json_decode($req->majors);
if (count($majors) != 0) {
foreach ($majors as $name) {
$major = new Major();
$major->major_guid = Uuid::uuid();
$major->name = $name;
$major->course = $courseGuid;
$major->save();
}
}
}
DB::table('stripes')->truncate();
foreach (CourseInstaller::all() as $course_installer) {
if (Course::where('name', '=', $course_installer->name)->first() != NULL) {
continue;
}
$course = new Course();
do {
$rnd = generateRandomString(5);
} while (Course::where('u_identifier', '=', $rnd)->first() != NULL);
$course->u_identifier = $rnd;
$course->name = $course_installer->name;
$course->description = $course_installer->description;
$course->maxStudentsPerStripe = $course_installer->maxStudentsPerStripe;
$course->single_stripe = $course_installer->single_stripe;
$course->referents = $course_installer->referents;
$course->save();
for ($c = 0; $c < 9; $c++) {
if (intval($course_installer->{itoa($c + 1)}) != 0) {
$stripe = new Stripe();
$stripe->stripe_number = $c + 1;
$stripe->stripe_call = $course_installer->{itoa($c + 1)};
$course->stripes()->save($stripe);
}
}
}
return redirect(route("admin"))->withSuccess("Corsi importati con successo.");
}]);
// ------
// Authentication routes
Route::get('/', ['as' => 'auth.getLogin', 'uses' => 'Auth\\AuthController@getLogin']);
Route::post('auth/login', ['as' => 'auth.postLogin', 'uses' => 'Auth\\AuthController@postLogin']);
/**
* @param $id
* @return \Illuminate\Http\RedirectResponse
*
*/
private function storeORUpdate(Request $request, Course $course)
{
$this->validate($request, ['institution' => 'required|integer', 'courseName' => 'required|max:64', 'description' => 'required|min:10', 'price' => 'numeric|required|min:0|max:9999', 'startDate' => 'required|date', 'duration' => 'required|min:0|max:480|integer', 'participantNum' => 'required|min:1|max:50|Integer']);
$institution = Institution::find($request->institution);
#TODO validate the institute here.
#$this->validator->after(function($validator) {
# if ($this->somethingElseIsInvalid()) {
# $validator->errors()->add('field', 'Something is wrong with this field!');
# }
#});
$course->institution()->associate($institution);
$course->courseName = $request->courseName;
$course->description = $request->description;
$course->price = $request->price;
$course->startDate = $request->startDate;
$course->duration = $request->duration;
$course->participantNum = $request->participantNum;
$course->user()->associate(Auth::user());
if ($course->save()) {
\Session::flash('flash_message', "Der Kurs wurde erfolgreich gespeichert");
\Session::flash('flash_message_type', "success");
return redirect()->action('CourseController@show', [$course->id]);
} else {
return Redirect::back()->withError("Der Kurs konnte leider nicht gespeichert werden.")->withInput();
}
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
//
$v = Validator::make(Request::all(), ['title' => 'required|max:30', 'control_category_id' => 'required', 'presenter_id' => 'required']);
if ($v->fails()) {
return redirect()->back()->withErrors($v->errors())->withInput();
} else {
$course = new Course();
$course->title = Request::get('title');
$course->desc = Request::get('desc');
$course->start_time = Request::get('start_time');
$course->duration = Request::get('duration');
$course->attendee_limit = Request::get('attendee_limit');
$course->language_culture_name = Request::get('language_culture_name');
$course->user_id = Request::get('presenter_id');
$course->category_id = Request::get('control_category_id');
$course->save();
return redirect('courses');
}
}
public function test()
{
// this url below contains 200 programs.
// it could be a huge performance concern if crawl it.
// so I just choose the "I" category of all programs insteaded.
// $url_main = "http://www.humber.ca/program";
set_time_limit(1000);
// $url_main = "http://www.humber.ca/program/listings/b?school=All&credential=All&campus=All&field_program_name_value_1=";
$html_main = file_get_contents($url_main);
$crawler = new Crawler($html_main);
$links = array();
// Simple XPath for this element, so I did not use CssSelector.
$crawler->filterXPath('//tbody/tr/td/a')->each(function ($node, $i) use(&$links) {
// the links in website are relative path, so I need to add a prefix to make it absolute.
$prefix = "http://humber.ca";
$existed_programs = Program::all();
$existed_program_names = array();
foreach ($existed_programs as $key => $value) {
$existed_program_names[] = $value['program_name'];
}
// get rid of the duplicated links, no idea why Humber make the program list a mess
if (strpos($node->text(), ',') === false) {
// get the full link
$link = $prefix . $node->attr('href');
$link = trim($link);
// get the text which is the program name
$text = trim($node->text());
// put associate name & link to key/value pair array
if (!in_array($text, $existed_program_names)) {
$links["{$text}"] = $link;
}
}
});
// an array to store all programs
$programs = array();
// use a loop to crawl individual program webpage by accessing its link in $links array
foreach ($links as $key => $value) {
$program_url = $value;
// use curl to get the webpage content
// it seems file_get_contents() has some issues for these webpage
// or it's just I made some mistakes
$curl_handle = curl_init();
curl_setopt($curl_handle, CURLOPT_URL, $program_url);
curl_setopt($curl_handle, CURLOPT_CONNECTTIMEOUT, 2);
curl_setopt($curl_handle, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curl_handle, CURLOPT_USERAGENT, 'Humber College');
$program_html = curl_exec($curl_handle);
curl_close($curl_handle);
if ($program_html) {
$program_crawler = new Crawler($program_html);
}
// $program is an array to store the program's information with key/value pair
$program = array();
// here I used CssSelector to help me translate the XPath.
// It made me address it without headache.
$program['program_name'] = trim($key);
$Code = $program_crawler->filterXPath(CssSelector::toXPath('div.container.clearfix>section>div.field-items>div.field-item.even'))->text();
$program['program_code'] = trim($Code);
$Credential = $program_crawler->filterXPath(CssSelector::toXPath('section.field-name-field-credential>div.field-item>a'))->text();
$program['program_credential'] = trim($Credential);
$School = $program_crawler->filterXPath(CssSelector::toXPath('section.field-name-field-school>div.field-item>a'))->text();
$program['program_school'] = trim($School);
// get all the schools from database
$schools = School::all();
// Because I used School table's id as the foreign key in Program table.
foreach ($schools as $key1 => $value1) {
if ($program['program_school'] == $value1['school_name']) {
$program['program_school_id'] = $value1['id'];
}
}
// getting each courses' name/code
$courses = array();
$courses = $program_crawler->filterXPath(CssSelector::toXPath('div.course'))->each(function ($node, $i) {
$course = array();
$course_code = $node->children()->first()->text();
$course_name = $node->children()->last()->text();
$course['course_code'] = $course_code;
$course['course_name'] = $course_name;
return $course;
});
$program['program_courses'] = $courses;
$programs[] = $program;
}
// store the information from array to database through loops
// just in case of accidents, I commented the inserting database code below.
foreach ($programs as $key => $value) {
$one_program = new Program();
$one_program->program_name = $value['program_name'];
$one_program->program_code = $value['program_code'];
$one_program->school_id = $value['program_school_id'];
$one_program->credential = $value['program_credential'];
$one_program->save();
echo "a program is saved to db" . "<br>";
foreach ($value['program_courses'] as $key2 => $value2) {
// Same reason as above, I used Program table's id as foreign key in Course table
$stored_programs = Program::all();
// $stored_programs = $programs;
$course_belongs_id = 0;
foreach ($stored_programs as $key3 => $value3) {
if ($value['program_name'] == $value3['program_name']) {
$course_belongs_id = $value3['id'];
}
}
$existed_courses = Course::where('program_name', '=', $value['program_name']);
$existed_course_name = array();
foreach ($existed_courses as $key => $value) {
$existed_course_name[] = $value['course_name'];
}
if (!in_array($value2['course_name'], $existed_course_name)) {
$one_course = new Course();
$one_course->course_name = $value2['course_name'];
$one_course->course_code = $value2['course_code'];
$one_course->program_id = $course_belongs_id;
$one_course->save();
echo "a course is saved to db ---- " . $one_course->program_id . "<br>";
}
}
echo "<br>======<br>";
}
}
