public function getImageTag() { return ImageTag::get()->sort('Title', 'ASC'); }
public static function insertImageTagTb($results) { if ($results['data'] != null) { foreach ($results['data'] as $item) { $imagetag = new ImageTag(); $link_url = $item['link']; $tag_names = $item['tags']; $count_tag = sizeof($tag_names); $i = 0; while ($i < $count_tag) { $image = Image::where('link_url', $link_url)->first(); $tag = Tag::where('tag', $tag_names[$i])->first(); if (isset($image->image_id) && isset($tag->tag_id)) { $check_id1 = ImageTag::where('image_id', $image->image_id)->first(); $check_id2 = ImageTag::where('tag_id', $tag->tag_id)->first(); if ($check_id1 == null && $check_id2 == null) { ImageTag::insert(array('image_id' => $image->image_id, 'tag_id' => $tag->tag_id)); } else { ImageTag::insert(array('image_id' => $image->image_id, 'tag_id' => $tag->tag_id)); } } else { } $i++; } } } }