Ejemplo n.º 1
0
 public function getTagsByTag()
 {
     $data['tags'] = null;
     $type = Input::get('type');
     if ($type == null) {
         return null;
     }
     try {
         $tag = Input::get('tag');
         if ($type == 1) {
             $data['tags'] = HashTag::join('hash_tagged_posts', 'hashtags.id', '=', 'hash_tagged_posts.tag_id')->whereIn('hash_tagged_posts.post_id', function ($query) {
                 $query->select('posts.id')->from('posts')->whereType('1');
             })->where('hashtags.tag', 'like', '%' . $tag . '%')->groupBy(['hashtags.id', 'hashtags.tag'])->get(['hashtags.id', 'hashtags.tag']);
         } elseif ($type == 2) {
             $data['tags'] = HashTag::join('hash_tagged_posts', 'hashtags.id', '=', 'hash_tagged_posts.tag_id')->whereIn('hash_tagged_posts.post_id', function ($query) {
                 $query->select('posts.id')->from('posts')->whereType('2')->whereCampusId(Session::get('campus'));
             })->where('hashtags.tag', 'like', '%' . $tag . '%')->groupBy(['hashtags.id', 'hashtags.tag'])->get(['hashtags.id', 'hashtags.tag']);
         }
         if ($type == 3) {
             $data['tags'] = HashTag::join('hash_tagged_posts', 'hashtags.id', '=', 'hash_tagged_posts.tag_id')->whereIn('hash_tagged_posts.post_id', function ($query) {
                 $query->select('posts.id')->from('posts')->whereType('3');
             })->where('hashtags.tag', 'like', '%' . $tag . '%')->groupBy(['hashtags.id', 'hashtags.tag'])->get(['hashtags.id', 'hashtags.tag']);
         }
     } catch (Exception $e) {
     }
     return json_encode($data);
 }
Ejemplo n.º 2
0
 public function testgetAndSetText()
 {
     $this->hashTag->setText('#thephpleague');
     $this->assertEquals('#thephpleague', $this->hashTag->getText());
 }