Purchase a dark character: Bellatrix is good as you're guaranteed to have her from completing the game.Ī strong character: Hagrid or Dudley work here but if you have the red brick this is technically not neededĪ key character: Okay unfortunately you'll have none. Having over 2 billion studs, I bought basically everyone I could but for those on a budget: These are also found in Diagon Alley, inside the Madam Watkins' building which is the closest on the left to the Leaky Cauldron (pub) and has a purple exterior. Use get()->first() it will return only one record, if not find, it will return null.With that said, let's get into it! You may notice a ghost in each level with a breakdown on what you're missing, super handy for finding those last few collectibles.Īlso, before we rock it, there are a few characters we'll need to purchase. >first() //get instead of first to show that that the progress row got displayed next to the wrong course. You have to try this function getVoortgang() I think you want to return the first result in the collection Do you need the collection of all the results (use get()), or do you just want the first result in the collection (use first())? Which method you use depends on what you need. That collection may have 0 or more objects in it, depending on the results of the query.įirst() calls get() under the hood, but instead of returning the collection of results, it returns the first entry in the collection (if there is one). Get() returns a collection of objects every time. >get() //get instead of first to show that that the progress row got displayed next to the wrong course.Įdit: This is the output of dd($cursus->getVoortgang()) >where('IsKlaar', 1) //only exercises that are finished >where('LeerlingID', 1) //get progress from student with ID 1 Return $this->hasManyThrough('App\Models\OpdrachtVoortgang', 'App\Models\Opdrachten', 'CursusNaam', 'OpdrachtVoortGangID', 'CursusNaam', 'OpdrachtID') This is how i display it in the view: ($cursussen as the Course model: //get the latest finished exercise by a student
Here's the course controller: $cursussen = Cursus::get() (1, 1, 1, b'1', 'Voldoende'),Įxercise table: INSERT INTO `opdrachten` (`OpdrachtID`, `Opdracht`, `CursusNaam`, `Deadline`) VALUES Different student with id 2 messes it up!Įxercise progress wrong #2: I just found out 'skipping' a primary key number has the same effect as having the progress of another student in between. Image of view where OpdrachtID 2 moved to wrong course INSERT INTO `opdrachtvoortgang` (`OpdrachtVoortgangID`, `LeerlingID`, `OpdrachtID`, `IsKlaar`, `Beoordeling`) VALUES Image of view where it shows right INSERT INTO `opdrachtvoortgang` (`OpdrachtVoortgangID`, `LeerlingID`, `OpdrachtID`, `IsKlaar`, `Beoordeling`) VALUESĮxercise progress wrong #1:Adding another student causes OpdrachtVoortgangID:2 (the last one of the course it belongs to) to display to the wrong course: However, when i add one more row with a different student in the Exercise progress table, it displays the last OpdrachtVoortgangID from a course to the wrong course!Įxercise progress: This works with one student, it shows right: This works fine when there's only one student in the table exercise progress. I did this with an hasManyThrough relation in the course Model. What i tried to do is to get and display the latest exercise finished by the student. Key OpdrachtID) and of course the exercise progress is linked to a student (so it has the foreign key LeerlingID. The progress of the exercises per student is stored in the exercise progress table (so it has the foreign One course can have many exercises (so exercises has the foreign key CursusNaam). Exercise progress: OpdrachtVoortgangID int.
This is about these 4 tables with the following primary keys.
0 kommentar(er)
