/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$courses = ['CSCI E-15 Dynamic Web Applications' => ['Area of Concentration', 'Upper Level Courses'], 'DGMD E-42 Making the Short Film: Innovations and Practices for the Digital Age' => ['On Campus', 'Upper Level Courses'], 'EXPO E-25 Academic Writing and Critical Reading' => ['Harvard Instructor', 'Expo-25'], 'CSCI E-3: Introduction to Web Programming Using JavaScript' => ['Area of Concentration', 'Upper Level Courses'], 'CSCI E-7: Introduction to Programming with Python' => ['Area of Concentration', 'Upper Level Courses', 'On Campus'], 'CSCI E-8: Web GIS: Technologies and Applications' => ['Area of Concentration', 'Upper Level Courses'], 'CSCI E-10A: Introduction to Computer Science Using Java I' => ['Area of Concentration', 'Upper Level Courses', 'Harvard Instructor']];
foreach ($courses as $course_name => $requirements) {
# First get the course
$course = \App\Course::where('course_name', 'like', $course_name)->first();
# Now loop through each tag for this book, adding the pivot
foreach ($requirements as $requirement_name) {
$requirement = \App\Requirement::where('requirement_name', 'LIKE', $requirement_name)->first();
# Connect this req to this course
$course->requirements()->save($requirement);
}
}
}
public function index(Request $request)
{
$type = $request->input('type', 'nested');
$requirements = [];
if ($type == 'nested') {
$requirements = Requirement::where('project_id', $request->project_id)->where('requirement_id', null)->get();
} elseif ($type == 'list') {
$except = $request->input('except', []);
// 需要先new Eloquent才可以使用自定義的function
$requirementModel = new Requirement();
$requirementModel->clearWith();
$requirements = $requirementModel->where('project_id', $request->project_id)->whereNotIn('id', $except)->get();
}
return $requirements;
}
/**
* Get all of the tasks for a given user.
*
* @param User $user
* @return Collection
*/
public function forUser(User $user)
{
return Requirement::where('user_id', $user->id)->orderBy('created_at', 'asc')->get();
}
