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++;
}
}
}
}
