public function selectRandomTaggedFact($user_id, $tag_id) { $tagged_facts = TaggedFact::whereRaw("tag_id = {$tag_id}")->get(); foreach ($tagged_facts as $tagged_fact) { $facts[] = $tagged_fact->fact; } return $this->transformAndReturnFact($facts); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($fact_id, $tag_id) { $tagFactRow = TaggedFact::whereRaw("tag_id = '{$tag_id}' and fact_id = '{$fact_id}'")->first(); $tagFactRow->forceDelete(); }
/** * @param $user */ public function tagMockFacts($user) { // create two tags $tag_id = Tag::create(['tag_name' => 'Test Tag1'])->id; $tag_id2 = Tag::create(['tag_name' => 'Test Tag2'])->id; $facts = Fact::where('user_id', $user->id)->get(); foreach ($facts as $fact) { // Basically a 50/50 coin flip whether a tag is going to get tag 1 or tag 2 rand(0, 1) ? \App\Models\TaggedFact::create(['fact_id' => $fact->id, 'tag_id' => $tag_id]) : \App\Models\TaggedFact::create(['fact_id' => $fact->id, 'tag_id' => $tag_id2]); } }