line("开始导入"); $list = json_decode($musicInfo,true); foreach ($list as $key=>$value){ $category_name = $value['name']; $category = PostMusicCategory::where('name',$category_name)->first(); if(!$category){ $category = PostMusicCategory::create(['name'=>$category_name])->toArray(); Log::debug('插入分类:'.json_encode($category)); } foreach ($value['music'] as $music){ $info['music_id'] = $music['music_id']; $info['name'] = $music['name']; $info['music_duration'] = $music['music_duration']; $info['md5sum'] = $music['md5sum']; $info['url'] = $music['url']; $info['img'] = $music['img']; $info['singer'] = $music['singer']; $musicRow = PostMusic::where('music_id',$info['music_id'])->first(); $this->line('musicrow:'.json_encode($musicRow)); if(!$musicRow){ $musicRow = PostMusic::create($info)->toArray(); $this->line('插入音乐:'.json_encode($musicRow)); } $rel['mid'] = $musicRow['id']; $rel['music_category_id'] = $category['id']; $relRow = PostMusicCategoryRel::where(['mid'=>$rel['mid'],'music_category_id'=>$rel['music_category_id']])->exists(); if(!$relRow){ PostMusicCategoryRel::create($rel); Log::debug('插入音乐关联:'.json_encode($musicRow)); } } } } }