AnimeService.php 57 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395
  1. <?php
  2. namespace App\Services\Anime;
  3. use App\Consts\ErrorConst;
  4. use App\Facade\Site;
  5. use App\Libs\Utils;
  6. use App\Models\MpGeneratePicTask;
  7. use App\Services\AIGeneration\AIImageGenerationService;
  8. use Dflydev\DotAccessData\Util;
  9. use GuzzleHttp\Client;
  10. use Illuminate\Support\Facades\DB;
  11. use Illuminate\Support\Facades\Log;
  12. use Illuminate\Support\Facades\Redis;
  13. use OSS\Core\OssException;
  14. use OSS\OssClient;
  15. class AnimeService
  16. {
  17. protected $aiImageGenerationService;
  18. private $url;
  19. private $api_key;
  20. private $headers;
  21. public function __construct(AIImageGenerationService $aiImageGenerationService) {
  22. $this->aiImageGenerationService = $aiImageGenerationService;
  23. $this->url = 'https://api.deepseek.com/chat/completions';
  24. $this->api_key = env('DEEPSEEK_API_KEY');
  25. $this->headers = [
  26. 'Authorization' => 'Bearer '.$this->api_key,
  27. 'Content-Type' => 'application/json; charset=UTF-8'
  28. ];
  29. }
  30. public function chatList($data) {
  31. $anime_name = getProp($data, 'anime_name');
  32. $query = DB::table('mp_animes')->where('is_deleted', 0);
  33. if ($anime_name) {
  34. $query->where('anime_name', 'like', "%$anime_name%");
  35. }
  36. return $query->orderBy('id', 'desc')->paginate();
  37. }
  38. public function chatHistory($data) {
  39. $anime_id = getProp($data, 'anime_id');
  40. $sequence = getProp($data, 'sequence', 0);
  41. if (!$anime_id) Utils::throwError('20003:请选择对话!');
  42. $query = DB::table('mp_anime_records')->where('anime_id', $anime_id)->where('sequence', $sequence)->select('role', 'content', 'created_at');
  43. return $query->orderBy('id')->get()->map(function ($value) {
  44. $value = (array)$value;
  45. $value['created_at'] = transDate($value['created_at']);
  46. return $value;
  47. })->toArray();
  48. }
  49. public function batchSetRoleImg($data) {
  50. $anime_id = getProp($data, 'anime_id');
  51. $episode_number = getProp($data, 'episode_number');
  52. if (!$anime_id) Utils::throwError('1002:请选择对话');
  53. $anime = DB::table('mp_animes')->where('id', $anime_id)->where('is_deleted', 0)->first();
  54. $roles = json_decode(getProp($anime, 'roles'), true);
  55. $art_style = getProp($anime, 'art_style');
  56. foreach ($roles as &$role) {
  57. $role_name = getProp($role, 'role');
  58. $description = getProp($role, 'description');
  59. if ($art_style) $description = "美术风格:\n$art_style\n主体描述:$description";
  60. // 参考图地址
  61. $ref_img_url = getProp($role, 'url');
  62. // 此处调用AIImageGenerationService的生成图片任务接口: createImageGenerationTask(注意使用默认参数,prompt使用角色描述),并返回任务id
  63. try {
  64. $params = [
  65. 'prompt' => $description,
  66. 'ref_img_urls' => !empty($ref_img_url) ? [$ref_img_url] : []
  67. ];
  68. $task = $this->aiImageGenerationService->createImageGenerationTask($params);
  69. $task_id = $task->id;
  70. if (!$task_id) {
  71. Utils::throwError("20003: 角色({$role_name})生成图片失败");
  72. }
  73. $role['task_id'] = $task_id;
  74. $role['task_status'] = 'processing';
  75. } catch (\Exception $e) {
  76. Utils::throwError("20003:" . $e->getMessage());
  77. }
  78. }
  79. // 保存角色信息
  80. // $boolen = DB::table('mp_animes')->where('anime_id', $anime_id)->where('episode_number', $episode_number)->where('is_default', 1)->update([
  81. $boolen = DB::table('mp_animes')->where('id', $anime_id)->update([
  82. 'roles' => json_encode($roles, 256),
  83. 'generate_status' => '执行中',
  84. 'generate_at' => date('Y-m-d H:i:s'),
  85. 'updated_at' => date('Y-m-d H:i:s')
  86. ]);
  87. if (!$boolen) {
  88. Utils::throwError('20003:保存角色信息失败');
  89. }
  90. return $boolen;
  91. }
  92. public function batchSetSceneImg($data) {
  93. $anime_id = getProp($data, 'anime_id');
  94. if (!$anime_id) Utils::throwError('1002:请选择对话');
  95. $episode_number = getProp($data, 'episode_number');
  96. $anime = DB::table('mp_animes')->where('id', $anime_id)->where('is_deleted', 0)->first();
  97. $scenes = json_decode(getProp($anime, 'scenes'), true);
  98. $art_style = getProp($anime, 'art_style');
  99. foreach ($scenes as &$scene) {
  100. $scene_name = getProp($scene, 'scene');
  101. $description = getProp($scene, 'description');
  102. if ($art_style) $description = "美术风格:\n$art_style\n\n场景描述:$description";
  103. // 参考图地址
  104. $ref_img_url = getProp($scene, 'url');
  105. // 此处调用AIImageGenerationService的生成图片任务接口: createImageGenerationTask(注意使用默认参数,prompt使用角色描述),并返回任务id
  106. try {
  107. $params = [
  108. 'prompt' => $description,
  109. 'ref_img_urls' => !empty($ref_img_url) ? [$ref_img_url] : []
  110. ];
  111. $task = $this->aiImageGenerationService->createImageGenerationTask($params);
  112. $task_id = $task->id;
  113. if (!$task_id) {
  114. Utils::throwError("20003: 角色({$scene_name})生成图片失败");
  115. }
  116. $scene['task_id'] = $task_id;
  117. $scene['task_status'] = 'processing';
  118. } catch (\Exception $e) {
  119. Utils::throwError("20003:" . $e->getMessage());
  120. }
  121. }
  122. // 保存角色信息
  123. // $boolen = DB::table('mp_anime_episodes')->where('anime_id', $anime_id)->where('episode_number', $episode_number)->where('is_default', 1)->update([
  124. $boolen = DB::table('mp_animes')->where('id', $anime_id)->update([
  125. 'scenes' => json_encode($scenes, 256),
  126. 'generate_status' => '执行中',
  127. 'generate_at' => date('Y-m-d H:i:s'),
  128. 'updated_at' => date('Y-m-d H:i:s')
  129. ]);
  130. if (!$boolen) {
  131. Utils::throwError('20003:保存角色信息失败');
  132. }
  133. return $boolen;
  134. }
  135. public function editAnime($data) {
  136. $script_arr =getProp($data, 'script', []);
  137. if (!$script_arr) Utils::throwError('20003:剧本内容不能为空');
  138. $start_episode_sequence = getProp($data, 'start_episode_sequence', 1);
  139. $anime_id = getProp($data, 'anime_id');
  140. try {
  141. DB::beginTransaction();
  142. $table_data = [
  143. 'intro' => isset($script_arr['intro']) ? $script_arr['intro'] : '',
  144. 'highlights' => isset($script_arr['highlights']) ? $script_arr['highlights'] : '',
  145. 'role_relationship' => isset($script_arr['role_relationship']) ? $script_arr['role_relationship'] : '',
  146. 'core_contradiction' => isset($script_arr['core_contradiction']) ? $script_arr['core_contradiction'] : '',
  147. 'roles' => isset($script_arr['roles']) ? json_encode($script_arr['roles'], 256) : '',
  148. 'art_style' => isset($script_arr['art_style']) ? $script_arr['art_style'] : '',
  149. 'scenes' => isset($script_arr['scenes']) ? json_encode($script_arr['scenes'], 256) : '',
  150. 'status' => 3,
  151. 'start_episode_sequence' => $start_episode_sequence,
  152. 'end_episode_sequence' => $start_episode_sequence + count($script_arr['episodes']) - 1,
  153. 'episode_num' => count($script_arr['episodes']),
  154. 'updated_at' => date('Y-m-d H:i:s')
  155. ];
  156. // 保存剧本内容
  157. if (!empty($anime_id)) {
  158. $boolen = DB::table('mp_animes')->where('id', $anime_id)->update($table_data);
  159. if (!$boolen) {
  160. dLog('deepseek')->info('对话保存失败', $table_data);
  161. Utils::throwError('20003:对话保存失败');
  162. }
  163. }else {
  164. $table['created_at'] = $table_data['updated_at'];
  165. $anime_id = DB::table('mp_animes')->insertGetId($table_data);
  166. if (!$anime_id) {
  167. dLog('deepseek')->info('对话保存失败', $table_data);
  168. Utils::throwError('20003:对话保存失败');
  169. }
  170. }
  171. // 保存分集内容
  172. // 删除历史分集内容
  173. $boolen1 = DB::table('mp_anime_episodes')->where('anime_id', $anime_id)->delete();
  174. $episodes = [];
  175. $sequence = 1;
  176. foreach ($script_arr['episodes'] as $episode) {
  177. $segment_number = 1;
  178. foreach($episode['segments'] as $segment) {
  179. $episodes[] = [
  180. 'anime_id' => $anime_id,
  181. 'episode_number' => $episode['episode_number'],
  182. 'title' => $episode['title'],
  183. // 'content' => $episode['content'],
  184. 'content' => '',
  185. 'segment_number' => $segment_number,
  186. 'segment_content' => $segment['segment_content'],
  187. 'sequence' => $sequence,
  188. 'created_at' => date('Y-m-d H:i:s'),
  189. 'updated_at' => date('Y-m-d H:i:s')
  190. ];
  191. $sequence++;
  192. $segment_number++;
  193. }
  194. }
  195. $boolen2 = DB::table('mp_anime_episodes')->insert($episodes);
  196. if (!$boolen2) {
  197. dLog('deepseek')->info('分集内容保存失败', $episodes);
  198. Utils::throwError('20003:分集内容保存失败');
  199. }
  200. } catch (\Exception $e) {
  201. DB::rollBack();
  202. Utils::throwError('20003:'.$e->getMessage());
  203. }
  204. DB::commit();
  205. return true;
  206. }
  207. public function animeDetail($data) {
  208. $anime_id = getProp($data, 'anime_id');
  209. $anime = DB::table('mp_animes')->where('id', $anime_id)->where('is_deleted', 0)
  210. ->selectRaw('id as anime_id, anime_name, intro, highlights, roles, role_relationship, core_contradiction, art_style, scenes, status, remark, generate_status, created_at')->first();
  211. if (!$anime) Utils::throwError('20003:该剧本不存在!');
  212. $anime = (array)$anime;
  213. $anime['roles'] = json_decode($anime['roles']);
  214. $anime['scenes'] = json_decode($anime['scenes']);
  215. // 获取分集信息
  216. $episodes = DB::table('mp_anime_episodes')->where('anime_id', $anime_id)->where('is_default', 1)
  217. ->select('id as episode_id', 'episode_number', 'title')
  218. ->orderBy('episode_number')->get()->map(function ($value) {
  219. return (array)$value;
  220. })->toArray();
  221. $anime['episodes'] = $episodes;
  222. return $anime;
  223. }
  224. public function episodeInfo($data) {
  225. $anime_id = getProp($data, 'anime_id');
  226. $episode_number = getProp($data, 'episode_number');
  227. if (!$anime_id || !$episode_number) {
  228. Utils::throwError('1002:请选择剧集');
  229. }
  230. $episode = DB::table('mp_anime_episodes')->where('anime_id', $anime_id)->where('episode_number', $episode_number)->where('is_default', 1)->select('id as episode_id', 'anime_id', 'episode_number', 'title', 'intro', 'art_style', 'roles', 'scenes')->first();
  231. if (!$episode) Utils::throwError('20003: 该剧集不存在!');
  232. $episode = (array)$episode;
  233. $episode['roles'] = json_decode($episode['roles'], true);
  234. $episode['scenes'] = json_decode($episode['scenes'], true);
  235. // 获取分镜信息
  236. $segments = DB::table('mp_episode_segments')->where('anime_id', $anime_id)->where('episode_id', getProp($episode, 'episode_id'))->orderBy('segment_number')->select('act_number', 'act_title', 'segment_id', 'segment_number', 'segment_content')->get()->map(function ($value) {
  237. return (array)$value;
  238. })->toArray();
  239. $acts = [];
  240. foreach($segments as $segment) {
  241. if (isset($acts[getProp($segment, 'act_number')])) {
  242. $acts[getProp($segment, 'act_number')]['segments'][] = [
  243. 'segment_id' => getProp($segment, 'segment_id'),
  244. 'segment_number' => getProp($segment, 'segment_number'),
  245. 'segment_content' => getProp($segment, 'segment_content'),
  246. ];
  247. }else {
  248. $acts[getProp($segment, 'act_number')]= [
  249. 'act_number' => getProp($segment, 'act_number'),
  250. 'act_title' => getProp($segment, 'act_title'),
  251. 'segments' => [
  252. [
  253. 'segment_id' => getProp($segment, 'segment_id'),
  254. 'segment_number' => getProp($segment, 'segment_number'),
  255. 'segment_content' => getProp($segment, 'segment_content'),
  256. ]
  257. ]
  258. ];
  259. }
  260. }
  261. $episode['acts'] = array_values($acts);
  262. return $episode;
  263. }
  264. public function copyEpisodeVersion($data) {
  265. $episode_id = getProp($data, 'episode_id');
  266. $episode = DB::table('mp_anime_episodes')->where('id', $episode_id)->first();
  267. if (!$episode) Utils::throwError('20003:该剧集不存在');
  268. $episode = (array)$episode;
  269. $count = DB::table('mp_anime_episodes')->where('anime_id', $episode['anime_id'])->where('episode_number', $episode['episode_number'])->count('id');
  270. $sequence = $count + 1;
  271. unset($episode['id']);
  272. $episode['sequence'] = $sequence;
  273. $episode['created_at'] = date('Y-m-d H:i:s');
  274. $episode['updated_at'] = date('Y-m-d H:i:s');
  275. $episode['is_default'] = 1;
  276. try {
  277. DB::beginTransaction();
  278. // 移除is_default标志
  279. $boolen = DB::table('mp_anime_episodes')->where('anime_id', $episode['anime_id'])->where('episode_number', $episode['episode_number'])->update(['is_default' => 0, 'updated_at'=>date('Y-m-d H:i:s')]);
  280. if (!$boolen) {
  281. Utils::throwError('20003:更新失败!');
  282. }
  283. // 新增副本
  284. $new_episode_id = DB::table('mp_anime_episodes')->insertGetId($episode);
  285. if (!$new_episode_id) {
  286. Utils::throwError('20003:创建副本失败!');
  287. }
  288. $episode['episode_id'] = $new_episode_id;
  289. // 获取分镜数据
  290. $segments = DB::table('mp_episode_segments')->where('episode_id', $episode_id)->get()->map(function($item) use ($new_episode_id) {
  291. $item = (array)$item;
  292. unset($item['id']);
  293. $item['episode_id'] = $new_episode_id;
  294. $item['segment_id'] = date('YmdHis').mt_rand(1000,9999).str_pad($item['segment_number'], 3, "0", STR_PAD_LEFT);
  295. $item['created_at'] = $item['updated_at'] = date('Y-m-d H:i:s');
  296. return $item;
  297. })->toArray();
  298. // 写入分镜数据
  299. $boolen2 = DB::table('mp_episode_segments')->insert($segments);
  300. if (!$boolen2) {
  301. Utils::throwError('20003:写入分镜数据失败!');
  302. }
  303. }catch (\Exception $e) {
  304. DB::rollBack();
  305. Utils::throwError('20003:'.$e->getMessage());
  306. }
  307. DB::commit();
  308. return $episode;
  309. }
  310. public function episodeVersions($data) {
  311. $anime_id = getProp($data, 'anime_id');
  312. $episode_number = getProp($data, 'episode_number');
  313. if (!$anime_id || !$episode_number) {
  314. Utils::throwError('1002:请选择剧集');
  315. }
  316. $episodes = DB::table('mp_anime_episodes')->where('anime_id', $anime_id)->where('episode_number', $episode_number)->select('anime_id', 'episode_number', 'sequence', 'title', 'intro', 'art_style', 'roles', 'scenes')->get()->map(function($value) {
  317. return (array)$value;
  318. })->toArray();
  319. if (!$episodes) Utils::throwError('20003: 该剧集不存在!');
  320. foreach($episodes as &$episode) {
  321. $episode['version'] = 'V'.$episode['sequence'];
  322. $episode['roles'] = json_decode($episode['roles'], true);
  323. $episode['scenes'] = json_decode($episode['scenes'], true);
  324. }
  325. return $episodes;
  326. }
  327. public function bindEpisodeVersion($data) {
  328. $episode_id = getProp($data, 'episode_id');
  329. $episode = DB::table('mp_anime_episodes')->where('id', $episode_id)->first();
  330. if (!$episode) Utils::throwError('20003:该剧集不存在');
  331. $episode = (array)$episode;
  332. if ((int)$episode['is_default'] === 1) return true;
  333. try {
  334. DB::beginTransaction();
  335. // 移除is_default标志
  336. $boolen = DB::table('mp_anime_episodes')->where('anime_id', $episode['anime_id'])->where('episode_number', $episode['episode_number'])->update(['is_default' => 0, 'updated_at'=>date('Y-m-d H:i:s')]);
  337. if (!$boolen) {
  338. Utils::throwError('20003:更新失败!');
  339. }
  340. // 绑定副本
  341. $boolen2 = DB::table('mp_anime_episodes')->where('id', $episode_id)->update(['is_default' => 1, 'updated_at'=>date('Y-m-d H:i:s')]);
  342. if (!$boolen2) {
  343. Utils::throwError('20003:绑定失败!');
  344. }
  345. }catch (\Exception $e) {
  346. DB::rollBack();
  347. Utils::throwError('20003:'.$e->getMessage());
  348. }
  349. DB::commit();
  350. return true;
  351. }
  352. public function chatChangeImg($data) {
  353. $segment_id = getProp($data, 'segment_id');
  354. $prompt = getProp($data, 'prompt');
  355. if (!$prompt || !$segment_id) {
  356. Utils::throwError('1002:请输入提示词,并且选择需修改的图片');
  357. }
  358. $segment = DB::table("mp_episode_segments")->where('segment_id', $segment_id)->first();
  359. if (!$segment) Utils::throwError('20003:该分镜不存在!');
  360. $ref_img_url = getProp($segment, 'img_url');
  361. if (empty($ref_img_url)) {
  362. $prompt = getProp($segment, 'segment_content');
  363. }
  364. try {
  365. $params = [
  366. 'alias_segment_id' => $segment_id,
  367. 'prompt' => $prompt,
  368. 'ref_img_urls' => !empty($ref_img_url) ? [$ref_img_url] : []
  369. ];
  370. $task = $this->aiImageGenerationService->createImageGenerationTask($params);
  371. $task_id = $task->id;
  372. if (!$task_id) {
  373. Utils::throwError("20003: 生成图片失败");
  374. }
  375. // 更新任务ID
  376. $boolen = DB::table('mp_episode_segments')->where('segment_id', $segment_id)->update(['pic_task_id' => $task_id, 'pic_task_status' => '生成中', 'updated_at' => date('Y-m-d H:i:s')]);
  377. if (!$boolen) Utils::throwError('20003:更新任务ID失败');
  378. } catch (\Exception $e) {
  379. Utils::throwError("20003:" . $e->getMessage());
  380. }
  381. $img_url = $this->loopGetPicTaskResult($task_id);
  382. if (!$img_url) Utils::throwError('20003:图片生成中,请稍后刷新');
  383. return $img_url;
  384. }
  385. public function batchSetSegmentPics($data) {
  386. $anime_id = getProp($data, 'anime_id');
  387. $episode_number = getProp($data, 'episode_number');
  388. $ratio = getProp($data, 'ratio');
  389. if (!in_array($ratio, ['1:1', '4:3', '3:2', '16:9', '21:9'])) {
  390. Utils::throwError('1002:画面比例选择不正确,只支持1:1、4:3、3:2、16:9、21:9');
  391. }
  392. if (!$anime_id || !$episode_number) {
  393. Utils::throwError('1002:请选择剧集');
  394. }
  395. // 获取剧集信息
  396. $episode = DB::table('mp_anime_episodes')
  397. ->where('anime_id', $anime_id)
  398. ->where('episode_number', $episode_number)
  399. ->where('is_default', 1)
  400. ->select('id as episode_id', 'anime_id', 'episode_number')
  401. ->first();
  402. if (!$episode) {
  403. Utils::throwError('20003:该剧集不存在');
  404. }
  405. // 根据画面比例给宽高赋值
  406. switch ($ratio) {
  407. case '1:1':
  408. $width = 2048;
  409. $height = 2048;
  410. break;
  411. case '4:3':
  412. $width = 2304;
  413. $height = 1728;
  414. break;
  415. case '3:2':
  416. $width = 2496;
  417. $height = 1664;
  418. break;
  419. case '16:9':
  420. $width = 2560;
  421. $height = 1440;
  422. break;
  423. case '21:9':
  424. $width = 3024;
  425. $height = 1296;
  426. break;
  427. default:
  428. $width = 2048;
  429. $height = 2048;
  430. }
  431. // 获取动漫的角色信息(包含参考图)
  432. $anime = DB::table('mp_animes')
  433. ->where('id', $anime_id)
  434. ->select('roles', 'scenes')
  435. ->first();
  436. if (!$anime || !$anime->roles) {
  437. Utils::throwError('20003:未找到角色信息');
  438. }
  439. $roles = json_decode($anime->roles, true);
  440. if (!$roles) {
  441. Utils::throwError('20003:角色信息格式错误');
  442. }
  443. // 构建角色名称到参考图的映射
  444. $role_map = [];
  445. foreach ($roles as $role) {
  446. $role_name = getProp($role, 'role');
  447. $role_url = getProp($role, 'url');
  448. if (!empty($role_name) && !empty($role_url)) {
  449. // // 处理角色名称,去除装扮后缀(如:许芸-校服装 -> 许芸)- 修复中文乱码问题(弃用,容易产生重复图片)
  450. // $base_name = preg_replace('/[--].*$/u', '', $role_name);
  451. // $role_map[$base_name] = $role_url;
  452. // 同时保存完整名称的映射
  453. $role_map[$role_name] = $role_url;
  454. }
  455. }
  456. $scenes = json_decode($anime->scenes, true);
  457. if (!$scenes) {
  458. Utils::throwError('20003:角色信息格式错误');
  459. }
  460. // 构建角色名称到参考图的映射
  461. $scene_map = [];
  462. foreach ($scenes as $scene) {
  463. $scene_name = getProp($scene, 'scene');
  464. $scene_url = getProp($scene, 'url');
  465. if (!empty($scene_name) && !empty($scene_url)) {
  466. $scene_map[$scene_name] = $scene_url;
  467. }
  468. }
  469. // 获取所有分镜信息
  470. $segments = DB::table('mp_episode_segments')
  471. ->where('anime_id', $anime_id)
  472. ->where('episode_id', $episode->episode_id)
  473. ->where('pic_task_status', '')
  474. ->orderBy('segment_number')
  475. ->select('episode_number', 'segment_id', 'segment_number', 'segment_content', 'scene', 'characters')
  476. ->limit(3)
  477. ->get()
  478. ->toArray();
  479. if (empty($segments)) {
  480. Utils::throwError('20003:未找到分镜信息');
  481. }
  482. $updated_segments = [];
  483. $failed_segments = [];
  484. // 批量为每个分镜生成图片任务
  485. foreach ($segments as $segment) {
  486. $segment_id = $segment->segment_id;
  487. $segment_content = $segment->segment_content;
  488. if (empty($segment_content)) {
  489. $failed_segments[] = [
  490. 'segment_id' => $segment_id,
  491. 'error' => '分镜内容为空'
  492. ];
  493. continue;
  494. }
  495. try {
  496. // 解析分镜内容,提取画面描述作为主要提示词
  497. $prompt = $segment_content;
  498. $ref_img_urls = [];
  499. // 分镜场景
  500. $scene = getProp($segment, 'scene');
  501. $matched_scene = '';
  502. if (isset($scene_map[$scene])) {
  503. $img_index = count($ref_img_urls) + 1;
  504. $prompt = "场景:$scene(图$img_index)\n$prompt";
  505. $ref_img_urls[] = $scene_map[$scene];
  506. $matched_scene = $scene;
  507. }
  508. // 分镜角色
  509. $characters = getProp($segment, 'characters');
  510. $characters = str_replace(['、', ',', ';'], ',', $characters);
  511. $roles = explode(',', $characters);
  512. // 从分镜内容中提取涉及的角色
  513. $segment_characters = $this->extractCharactersFromSegment($segment_content, array_keys($role_map), $roles);
  514. // 获取匹配角色的参考图
  515. foreach ($segment_characters as $character) {
  516. if (isset($role_map[$character])) {
  517. // 将$prompt中出现的角色替换成角色(图1、2、3,序号是$ref_img_urls的个数加1)
  518. $img_index = count($ref_img_urls) + 1;
  519. $prompt = str_replace($character, $character . '(图' . $img_index . ')', $prompt);
  520. $ref_img_urls[] = $role_map[$character];
  521. }
  522. }
  523. // 如果没有找到匹配的角色参考图,不使用参考图
  524. if (empty($ref_img_urls)) {
  525. $ref_img_urls = [];
  526. }
  527. // 准备生成任务参数
  528. $params = [
  529. 'alias_segment_id' => $segment_id,
  530. 'prompt' => $prompt,
  531. 'ref_img_urls' => $ref_img_urls,
  532. 'width' => $width,
  533. 'height' => $height,
  534. ];
  535. // $task_id = mt_rand(100000, 999999);
  536. // 调用AI图片生成服务
  537. $task = $this->aiImageGenerationService->createImageGenerationTask($params);
  538. $task_id = $task->id;
  539. if (!$task_id) {
  540. $failed_segments[] = [
  541. 'segment_id' => $segment_id,
  542. 'error' => '创建生成任务失败'
  543. ];
  544. continue;
  545. }
  546. // 更新分镜的任务信息
  547. $update_result = DB::table('mp_episode_segments')
  548. ->where('segment_id', $segment_id)
  549. ->update([
  550. 'pic_task_id' => $task_id,
  551. 'pic_task_status' => '生成中',
  552. 'updated_at' => date('Y-m-d H:i:s')
  553. ]);
  554. // 如果是第一集的首帧图片,则存入待更新数组
  555. if ($update_result && (int)getProp($segment, 'episode_number') === 1 && (int)getProp($segment, 'segment_number') === 1) {
  556. Redis::sadd('anime_first_frame_urls', $segment_id);
  557. }
  558. if ($update_result) {
  559. $updated_segments[] = [
  560. 'segment_id' => $segment_id,
  561. 'task_id' => $task_id,
  562. 'status' => '生成中',
  563. 'matched_scenes' => $matched_scene,
  564. 'matched_roles' => $segment_characters,
  565. 'ref_urls_count' => count($ref_img_urls)
  566. ];
  567. } else {
  568. $failed_segments[] = [
  569. 'segment_id' => $segment_id,
  570. 'error' => '更新分镜任务状态失败'
  571. ];
  572. }
  573. } catch (\Exception $e) {
  574. $failed_segments[] = [
  575. 'segment_id' => $segment_id,
  576. 'error' => $e->getMessage()
  577. ];
  578. }
  579. }
  580. // // 更新剧集生成状态
  581. // if (!empty($updated_segments)) {
  582. // DB::table('mp_anime_episodes')
  583. // ->where('id', $episode->episode_id)
  584. // ->update([
  585. // 'generate_status' => '执行中',
  586. // 'updated_at' => date('Y-m-d H:i:s')
  587. // ]);
  588. // }
  589. return [
  590. 'success_count' => count($updated_segments),
  591. 'failed_count' => count($failed_segments),
  592. 'success_segments' => $updated_segments,
  593. 'failed_segments' => $failed_segments,
  594. 'total_segments' => count($segments)
  595. ];
  596. }
  597. public function reGenerateSegment($data) {
  598. $segment_id = getProp($data, 'segment_id');
  599. $segment = DB::table('mp_episode_segments')->where('segment_id', $segment_id)->first();
  600. $anime_id = getProp($segment, 'anime_id');
  601. $episode_number = getProp($segment, 'episode_number');
  602. $segment_content = getProp($data, 'segment_content');
  603. $ratio = getProp($data, 'ratio');
  604. if (!in_array($ratio, ['1:1', '4:3', '3:2', '16:9', '21:9'])) {
  605. Utils::throwError('1002:画面比例选择不正确,只支持1:1、4:3、3:2、16:9、21:9');
  606. }
  607. if (!$anime_id || !$episode_number) {
  608. Utils::throwError('1002:请选择分镜');
  609. }
  610. // 根据画面比例给宽高赋值
  611. switch ($ratio) {
  612. case '1:1':
  613. $width = 2048;
  614. $height = 2048;
  615. break;
  616. case '4:3':
  617. $width = 2304;
  618. $height = 1728;
  619. break;
  620. case '3:2':
  621. $width = 2496;
  622. $height = 1664;
  623. break;
  624. case '16:9':
  625. $width = 2560;
  626. $height = 1440;
  627. break;
  628. case '21:9':
  629. $width = 3024;
  630. $height = 1296;
  631. break;
  632. default:
  633. $width = 2048;
  634. $height = 2048;
  635. }
  636. // 获取动漫的角色信息(包含参考图)
  637. $anime = DB::table('mp_animes')
  638. ->where('id', $anime_id)
  639. ->select('roles', 'scenes')
  640. ->first();
  641. if (!$anime || !$anime->roles) {
  642. Utils::throwError('20003:未找到角色信息');
  643. }
  644. $roles = json_decode($anime->roles, true);
  645. if (!$roles) {
  646. Utils::throwError('20003:角色信息格式错误');
  647. }
  648. // 构建角色名称到参考图的映射
  649. $role_map = [];
  650. foreach ($roles as $role) {
  651. $role_name = getProp($role, 'role');
  652. $role_url = getProp($role, 'url');
  653. if (!empty($role_name) && !empty($role_url)) {
  654. $role_map[$role_name] = $role_url;
  655. }
  656. }
  657. $scenes = json_decode($anime->scenes, true);
  658. if (!$scenes) {
  659. Utils::throwError('20003:角色信息格式错误');
  660. }
  661. // 构建角色名称到参考图的映射
  662. $scene_map = [];
  663. foreach ($scenes as $scene) {
  664. $scene_name = getProp($scene, 'scene');
  665. $scene_url = getProp($scene, 'url');
  666. if (!empty($scene_name) && !empty($scene_url)) {
  667. $scene_map[$scene_name] = $scene_url;
  668. }
  669. }
  670. $segment_id = $segment->segment_id;
  671. $segment_content = $segment->segment_content;
  672. if (empty($segment_content)) {
  673. Utils::throwError('20003:分镜内容不存在,请填写内容后重试');
  674. }
  675. try {
  676. // 分镜剧本数组
  677. $update_data = [
  678. 'segment_content' => $segment_content,
  679. 'pic_task_status' => '生成中',
  680. 'updated_at' => date('Y-m-d H:i:s')
  681. ];
  682. // 解析分镜内容,提取画面描述作为主要提示词
  683. $prompt = $segment_content;
  684. $ref_img_urls = [];
  685. // 分镜场景
  686. $scene = getProp($data, 'scene');
  687. if ($scene) {
  688. $matched_scene = '';
  689. if (isset($scene_map[$scene])) {
  690. $img_index = count($ref_img_urls) + 1;
  691. $prompt = "场景:$scene(图$img_index)\n$prompt";
  692. $ref_img_urls[] = $scene_map[$scene];
  693. $matched_scene = $scene;
  694. }
  695. $update_data['scene'] = $scene;
  696. }
  697. // 分镜角色
  698. $characters = getProp($data, 'characters');
  699. if ($characters) {
  700. $update_data['characters'] = $characters;
  701. $characters = str_replace(['、', ',', ';'], ',', $characters);
  702. $characters = explode(',', $characters);
  703. // 从分镜内容中提取涉及的角色
  704. $segment_characters = $this->extractCharactersFromSegment($segment_content, array_keys($role_map), $characters);
  705. // 获取匹配角色的参考图
  706. foreach ($segment_characters as $character) {
  707. if (isset($role_map[$character])) {
  708. // 将$prompt中出现的角色替换成角色(图1、2、3,序号是$ref_img_urls的个数加1)
  709. $img_index = count($ref_img_urls) + 1;
  710. $prompt = str_replace($character, $character . '(图' . $img_index . ')', $prompt);
  711. $ref_img_urls[] = $role_map[$character];
  712. }
  713. }
  714. }
  715. // 如果没有找到匹配的角色参考图,不使用参考图
  716. if (empty($ref_img_urls)) {
  717. $ref_img_urls = [];
  718. }
  719. // 准备生成任务参数
  720. $params = [
  721. 'alias_segment_id' => $segment_id,
  722. 'prompt' => $prompt,
  723. 'ref_img_urls' => $ref_img_urls,
  724. 'width' => $width,
  725. 'height' => $height,
  726. ];
  727. // 调用AI图片生成服务
  728. $task = $this->aiImageGenerationService->createImageGenerationTask($params);
  729. $task_id = $task->id;
  730. if (!$task_id) {
  731. Utils::throwError('20003:创建生成任务失败!');
  732. }
  733. $update_data['pic_task_id'] = $task_id;
  734. // 更新分镜剧本信息
  735. $this->handleEpisodeContent($update_data);
  736. $boolen = DB::table('mp_episode_segments')
  737. ->where('segment_id', $segment_id)
  738. ->update($update_data);
  739. // 如果是第一集的首帧图片,则存入待更新数组
  740. if ($boolen && (int)getProp($segment, 'episode_number') === 1 && (int)getProp($segment, 'segment_number') === 1) {
  741. Redis::sadd('anime_first_frame_urls', $segment_id);
  742. }
  743. } catch (\Exception $e) {
  744. $failed_segments[] = [
  745. 'segment_id' => $segment_id,
  746. 'error' => $e->getMessage()
  747. ];
  748. }
  749. $img_url = $this->loopGetPicTaskResult($task_id);
  750. if (!$img_url) Utils::throwError('20003:图片生成中,请稍后刷新');
  751. return $img_url;
  752. }
  753. public function addSegment($data) {
  754. $prev_segment_id = getProp($data, 'prev_segment_id');
  755. $segment = DB::table('mp_episode_segments')->where('segment_id', $prev_segment_id)->first();
  756. $anime_id = getProp($segment, 'anime_id');
  757. $episode_number = getProp($segment, 'episode_number');
  758. $segment_number = getProp($segment, 'segment_number');
  759. $segment_content = getProp($data, 'segment_content');
  760. $img_url = getProp($data, 'img_url');
  761. $video_url = getProp($data, 'video_url');
  762. $ratio = getProp($data, 'ratio');
  763. if (!in_array($ratio, ['1:1', '4:3', '3:2', '16:9', '21:9'])) {
  764. Utils::throwError('1002:画面比例选择不正确,只支持1:1、4:3、3:2、16:9、21:9');
  765. }
  766. if (!$anime_id || !$episode_number) {
  767. Utils::throwError('1002:请选择分镜');
  768. }
  769. // 根据画面比例给宽高赋值
  770. switch ($ratio) {
  771. case '1:1':
  772. $width = 2048;
  773. $height = 2048;
  774. break;
  775. case '4:3':
  776. $width = 2304;
  777. $height = 1728;
  778. break;
  779. case '3:2':
  780. $width = 2496;
  781. $height = 1664;
  782. break;
  783. case '16:9':
  784. $width = 2560;
  785. $height = 1440;
  786. break;
  787. case '21:9':
  788. $width = 3024;
  789. $height = 1296;
  790. break;
  791. default:
  792. $width = 2048;
  793. $height = 2048;
  794. }
  795. // 获取动漫的角色信息(包含参考图)
  796. $anime = DB::table('mp_animes')
  797. ->where('id', $anime_id)
  798. ->select('roles', 'scenes')
  799. ->first();
  800. if (!$anime || !$anime->roles) {
  801. Utils::throwError('20003:未找到角色信息');
  802. }
  803. $roles = json_decode($anime->roles, true);
  804. if (!$roles) {
  805. Utils::throwError('20003:角色信息格式错误');
  806. }
  807. // 构建角色名称到参考图的映射
  808. $role_map = [];
  809. foreach ($roles as $role) {
  810. $role_name = getProp($role, 'role');
  811. $role_url = getProp($role, 'url');
  812. if (!empty($role_name) && !empty($role_url)) {
  813. $role_map[$role_name] = $role_url;
  814. }
  815. }
  816. $scenes = json_decode($anime->scenes, true);
  817. if (!$scenes) {
  818. Utils::throwError('20003:角色信息格式错误');
  819. }
  820. // 构建角色名称到参考图的映射
  821. $scene_map = [];
  822. foreach ($scenes as $scene) {
  823. $scene_name = getProp($scene, 'scene');
  824. $scene_url = getProp($scene, 'url');
  825. if (!empty($scene_name) && !empty($scene_url)) {
  826. $scene_map[$scene_name] = $scene_url;
  827. }
  828. }
  829. $segment_id = $segment->segment_id;
  830. $segment_content = $segment->segment_content;
  831. if (empty($segment_content)) {
  832. Utils::throwError('20003:分镜内容不存在,请填写内容后重试');
  833. }
  834. try {
  835. DB::beginTransaction();
  836. $new_segment_number = $segment_number + 1;
  837. $segment_id = date('YmdHis') . mt_rand(1000, 9999) . str_pad($new_segment_number, 3, "0", STR_PAD_LEFT);
  838. // 分镜剧本数组
  839. $insert_data = [
  840. 'anime_id' => $anime_id,
  841. 'episode_id' => getProp($segment, 'episode_id'),
  842. 'episode_number' => $episode_number,
  843. 'act_number' => getProp($segment, 'act_number'),
  844. 'act_title' => getProp($segment, 'act_title'),
  845. 'segment_id' => $segment_id,
  846. 'segment_number' => $new_segment_number,
  847. 'segment_content' => $segment_content,
  848. 'img_url' => $img_url,
  849. 'video_url' => $video_url,
  850. 'created_at' => date('Y-m-d H:i:s'),
  851. 'updated_at' => date('Y-m-d H:i:s')
  852. ];
  853. // 更新分镜剧本信息
  854. $this->handleEpisodeContent($insert_data);
  855. // 如果没有上传图片则使用当前描述进行生成
  856. if (!$img_url) {
  857. // 解析分镜内容,提取画面描述作为主要提示词
  858. $prompt = $segment_content;
  859. $ref_img_urls = [];
  860. // 分镜场景
  861. $scene = getProp($insert_data, 'scene');
  862. if ($scene) {
  863. $matched_scene = '';
  864. if (isset($scene_map[$scene])) {
  865. $img_index = count($ref_img_urls) + 1;
  866. $prompt = "场景:$scene(图$img_index)\n$prompt";
  867. $ref_img_urls[] = $scene_map[$scene];
  868. $matched_scene = $scene;
  869. }
  870. $update_data['scene'] = $scene;
  871. }
  872. // 分镜角色
  873. $characters = getProp($insert_data, 'characters');
  874. if ($characters) {
  875. $update_data['characters'] = $characters;
  876. $characters = str_replace(['、', ',', ';'], ',', $characters);
  877. $characters = explode(',', $characters);
  878. // 从分镜内容中提取涉及的角色
  879. $segment_characters = $this->extractCharactersFromSegment($segment_content, array_keys($role_map), $characters);
  880. // 获取匹配角色的参考图
  881. foreach ($segment_characters as $character) {
  882. if (isset($role_map[$character])) {
  883. // 将$prompt中出现的角色替换成角色(图1、2、3,序号是$ref_img_urls的个数加1)
  884. $img_index = count($ref_img_urls) + 1;
  885. $prompt = str_replace($character, $character . '(图' . $img_index . ')', $prompt);
  886. $ref_img_urls[] = $role_map[$character];
  887. }
  888. }
  889. }
  890. // 如果没有找到匹配的角色参考图,不使用参考图
  891. if (empty($ref_img_urls)) {
  892. $ref_img_urls = [];
  893. }
  894. // 准备生成任务参数
  895. $params = [
  896. 'alias_segment_id' => $segment_id,
  897. 'prompt' => $prompt,
  898. 'ref_img_urls' => $ref_img_urls,
  899. 'width' => $width,
  900. 'height' => $height,
  901. ];
  902. // 调用AI图片生成服务
  903. $task = $this->aiImageGenerationService->createImageGenerationTask($params);
  904. $task_id = $task->id;
  905. // $task_id = 'whatever';
  906. if (!$task_id) {
  907. Utils::throwError('20003:创建生成任务失败!');
  908. }
  909. $insert_data['pic_task_status'] = '生成中';
  910. $insert_data['pic_task_id'] = $task_id;
  911. }
  912. // 先更新序号
  913. $boolen = DB::table('mp_episode_segments')->where('anime_id', $anime_id)->where('episode_number', $episode_number)->where('segment_number', '>', $segment_number)->increment('segment_number');
  914. if (!$boolen) {
  915. Utils::throwError('20003:更新序号失败');
  916. }
  917. $boolen2 = DB::table('mp_episode_segments')->insert($insert_data);
  918. if (!$boolen2) {
  919. Utils::throwError('20003:新增分镜失败!');
  920. }
  921. // 如果是第一集的首帧图片,则存入待更新数组
  922. if ($boolen2 && (int)$episode_number === 1 && (int)$new_segment_number === 1) {
  923. Redis::sadd('anime_first_frame_urls', $segment_id);
  924. }
  925. } catch (\Exception $e) {
  926. DB::rollBack();
  927. Utils::throwError('20003:'.$e->getMessage());
  928. }
  929. DB::commit();
  930. if (isset($task_id)) $img_url = $this->loopGetPicTaskResult($task_id);
  931. if (!$img_url) Utils::throwError('20003:图片生成中,请稍后刷新');
  932. $segment = DB::table('mp_episode_segments')->where('segment_id', $segment_id)->first();
  933. $segment = $segment ? (array)$segment : [];
  934. return $segment;
  935. }
  936. public function copySegment($data) {
  937. $segment_id = getProp($data, 'segment_id');
  938. $segment = DB::table('mp_episode_segments')->where('segment_id', $segment_id)->first();
  939. if (!$segment) Utils::throwError('20003:请选择分镜');
  940. $anime_id = getProp($segment, 'anime_id');
  941. $episode_number = getProp($segment, 'episode_number');
  942. $segment_number = getProp($segment, 'segment_number');
  943. try {
  944. DB::beginTransaction();
  945. $segment = (array)$segment;
  946. unset($segment['id']);
  947. $segment['segment_number'] += 1;
  948. $segment['segment_id'] = date('YmdHis') . mt_rand(1000, 9999) . str_pad($segment['segment_number'], 3, "0", STR_PAD_LEFT);
  949. $segment['pic_task_id'] = $segment['pic_task_status'] = $segment['video_task_id'] = $segment['video_task_status'] = '';
  950. $segment['created_at'] = $segment['updated_at'] = date('Y-m-d H:i:s');
  951. // 更新其他分镜序号
  952. $boolen2 = DB::table('mp_episode_segments')->where('anime_id', $anime_id)->where('episode_number', $episode_number)->where('segment_number', '>', $segment_number)->increment('segment_number');
  953. if (!$boolen2) {
  954. Utils::throwError('20003:更新其他分镜序号失败');
  955. }
  956. // 复制分镜
  957. $boolen = DB::table('mp_episode_segments')->insert($segment);
  958. if (!$boolen) {
  959. Utils::throwError('20003:复制分镜失败');
  960. }
  961. }catch (\Exception $e) {
  962. DB::rollBack();
  963. Utils::throwError('20003:'.$e->getMessage());
  964. }
  965. DB::commit();
  966. return true;
  967. }
  968. public function moveSegment($data) {
  969. $segment_id = getProp($data, 'segment_id');
  970. $target_segment_id = getProp($data, 'target_segment_id');
  971. // 获取源分镜信息
  972. $source_segment = DB::table('mp_episode_segments')->where('segment_id', $segment_id)->first();
  973. if (!$source_segment) Utils::throwError('20003:请选择分镜');
  974. // 获取目标分镜信息
  975. $target_segment = DB::table('mp_episode_segments')->where('segment_id', $target_segment_id)->first();
  976. if (!$target_segment) Utils::throwError('20003:目标分镜不存在');
  977. $anime_id = getProp($source_segment, 'anime_id');
  978. $episode_number = getProp($source_segment, 'episode_number');
  979. $source_segment_number = getProp($source_segment, 'segment_number');
  980. $target_segment_number = getProp($target_segment, 'segment_number');
  981. // 验证源分镜和目标分镜必须属于同一个动漫的同一集
  982. $target_anime_id = getProp($target_segment, 'anime_id');
  983. $target_episode_number = getProp($target_segment, 'episode_number');
  984. if ($anime_id != $target_anime_id || $episode_number != $target_episode_number) {
  985. Utils::throwError('20003:只能在同一动漫的同一集内移动分镜');
  986. }
  987. // 如果源分镜和目标分镜相同,无需移动
  988. if ($source_segment_number == $target_segment_number) {
  989. return true;
  990. }
  991. try {
  992. DB::beginTransaction();
  993. if ($source_segment_number < $target_segment_number) {
  994. // 向后移动:源分镜移动到目标分镜之后
  995. // 1. 将源分镜和目标分镜之间的所有分镜序号减1
  996. DB::table('mp_episode_segments')
  997. ->where('anime_id', $anime_id)
  998. ->where('episode_number', $episode_number)
  999. ->where('segment_number', '>', $source_segment_number)
  1000. ->where('segment_number', '<=', $target_segment_number)
  1001. ->decrement('segment_number');
  1002. // 2. 将源分镜移动到目标分镜之后
  1003. $new_segment_number = $target_segment_number;
  1004. } else {
  1005. // 向前移动:源分镜移动到目标分镜之后
  1006. // 1. 将目标分镜之后到源分镜之前的所有分镜序号加1
  1007. DB::table('mp_episode_segments')
  1008. ->where('anime_id', $anime_id)
  1009. ->where('episode_number', $episode_number)
  1010. ->where('segment_number', '>', $target_segment_number)
  1011. ->where('segment_number', '<', $source_segment_number)
  1012. ->increment('segment_number');
  1013. // 2. 将源分镜移动到目标分镜之后
  1014. $new_segment_number = $target_segment_number + 1;
  1015. }
  1016. // 3. 更新源分镜的序号
  1017. $update_result = DB::table('mp_episode_segments')
  1018. ->where('segment_id', $segment_id)
  1019. ->update([
  1020. 'segment_number' => $new_segment_number,
  1021. 'updated_at' => date('Y-m-d H:i:s')
  1022. ]);
  1023. if (!$update_result) {
  1024. Utils::throwError('20003:更新分镜序号失败');
  1025. }
  1026. DB::commit();
  1027. return true;
  1028. } catch (\Exception $e) {
  1029. DB::rollBack();
  1030. Utils::throwError('20003:' . $e->getMessage());
  1031. }
  1032. }
  1033. public function delSegment($data) {
  1034. $segment_id = getProp($data, 'segment_id');
  1035. $segment = DB::table('mp_episode_segments')->where('segment_id', $segment_id)->first();
  1036. if (!$segment) Utils::throwError('20003:请选择分镜');
  1037. $anime_id = getProp($segment, 'anime_id');
  1038. $episode_number = getProp($segment, 'episode_number');
  1039. $segment_number = getProp($segment, 'segment_number');
  1040. try {
  1041. DB::beginTransaction();
  1042. // 删除分镜
  1043. $boolen = DB::table('mp_episode_segments')->where('segment_id', $segment_id)->delete();
  1044. if (!$boolen) {
  1045. Utils::throwError('20003:删除分镜失败');
  1046. }
  1047. // 更新其他分镜序号
  1048. $boolen2 = DB::table('mp_episode_segments')->where('anime_id', $anime_id)->where('episode_number', $episode_number)->where('segment_number', '>', $segment_number)->decrement('segment_number');
  1049. if (!$boolen2) {
  1050. Utils::throwError('20003:更新其他分镜序号失败');
  1051. }
  1052. }catch (\Exception $e) {
  1053. DB::rollBack();
  1054. Utils::throwError('20003:'.$e->getMessage());
  1055. }
  1056. DB::commit();
  1057. return true;
  1058. }
  1059. public function segmentHistory($data) {
  1060. $segment_id = getProp($data, 'segment_id');
  1061. // 获取历史图片
  1062. $pics = [];
  1063. $pic_history = DB::table('mp_generate_pic_tasks')->where('alias_segment_id', $segment_id)->where('status', 'success')->orderBy('created_at', 'desc')->get();
  1064. foreach($pic_history as $task) {
  1065. $result_url = getProp($task, 'result_url');
  1066. if (is_json($result_url)) {
  1067. $pics = array_merge($pics, json_decode($result_url, true));
  1068. }else {
  1069. $pics[] = $result_url;
  1070. }
  1071. }
  1072. // 获取历史视频
  1073. $videos = [];
  1074. $video_history = DB::table('mp_generate_video_tasks')->where('alias_segment_id', $segment_id)->where('status', 'success')->orderBy('created_at', 'desc')->get();
  1075. foreach($video_history as $task) {
  1076. $result_url = getProp($task, 'result_url');
  1077. if (is_json($result_url)) {
  1078. $videos = array_merge($pics, json_decode($result_url, true));
  1079. }else {
  1080. $videos[] = $result_url;
  1081. }
  1082. }
  1083. return compact('pics', 'videos');
  1084. }
  1085. // 轮训获取图片任务结果
  1086. private function loopGetPicTaskResult($task_id) {
  1087. $start_count = 0;
  1088. $img_url = '';
  1089. while ($start_count <= 30) {
  1090. sleep(3);
  1091. $task = MpGeneratePicTask::where('id', $task_id)->first();
  1092. $statusInfo = $this->aiImageGenerationService->queryTaskStatus($task);
  1093. if ($statusInfo['status'] === 'success') {
  1094. $task->updateStatus('success', [
  1095. 'result_url' => $statusInfo['result_url'],
  1096. 'result_json' => $statusInfo['result_json'] ?? []
  1097. ]);
  1098. // 同步调整分镜图片状态和结果
  1099. if (getProp($task, 'alias_segment_id')) {
  1100. DB::table('mp_episode_segments')->where('segment_id', getProp($task, 'alias_segment_id'))->update([
  1101. 'img_url' => $statusInfo['result_url'][0],
  1102. 'pic_task_status' => '已完成',
  1103. ]);
  1104. }
  1105. $img_url = $statusInfo['result_url'][0];
  1106. break;
  1107. } elseif ($statusInfo['status'] === 'failed') {
  1108. $task->updateStatus('failed', [
  1109. 'error_message' => $statusInfo['error_message'],
  1110. 'result_json' => $statusInfo['result_json'] ?? []
  1111. ]);
  1112. if (getProp($task, 'alias_segment_id')) {
  1113. DB::table('mp_episode_segments')->where('segment_id', getProp($task, 'alias_segment_id'))->update([
  1114. 'pic_task_status' => '失败',
  1115. ]);
  1116. }
  1117. break;
  1118. }
  1119. $start_count+=3;
  1120. }
  1121. return $img_url;
  1122. }
  1123. /**
  1124. * 从分镜内容中提取涉及的角色
  1125. */
  1126. private function extractCharactersFromSegment($segment_content, $available_characters, $roles) {
  1127. $found_characters = [];
  1128. foreach ($available_characters as $character) {
  1129. // 检查角色名称是否在分镜内容中出现
  1130. if (strpos($segment_content, $character) !== false) {
  1131. $found_characters[] = $character;
  1132. }
  1133. }
  1134. if (!$found_characters) {
  1135. foreach ($roles as $character) {
  1136. // 检查角色名称是否在分镜内容中出现
  1137. if (strpos($segment_content, $character) !== false) {
  1138. $found_characters[] = $character;
  1139. }
  1140. }
  1141. }
  1142. return array_unique($found_characters);
  1143. }
  1144. // 从分镜剧本中提取关键字段
  1145. private function handleEpisodeContent(&$data) {
  1146. $segmentContent = getProp($data, 'segment_content');
  1147. // 解析分镜详细信息
  1148. $segmentData = [
  1149. 'description' => '',
  1150. 'composition' => '',
  1151. 'camera_movement' => '',
  1152. 'voice_actor' => '',
  1153. 'dialogue' => '',
  1154. 'frame_type' => '',
  1155. 'scene' => '', // 新增:场景
  1156. 'characters' => '' // 新增:出镜角色
  1157. ];
  1158. // 提取各个字段 - 兼容中文冒号和英文冒号,支持多种表达方式
  1159. if (preg_match('/(?:画面描述|镜头描述|场景描述)[::]\s*([^\n]+)/u', $segmentContent, $descMatch)) {
  1160. $segmentData['description'] = trim($descMatch[1]);
  1161. $data['description'] = trim($descMatch[1]);
  1162. }
  1163. if (preg_match('/(?:构图设计|构图|镜头构图)[::]\s*([^\n]+)/u', $segmentContent, $compMatch)) {
  1164. $segmentData['composition'] = trim($compMatch[1]);
  1165. $data['composition'] = trim($compMatch[1]);
  1166. }
  1167. if (preg_match('/(?:运镜调度|运镜|镜头运动|摄影机运动)[::]\s*([^\n]+)/u', $segmentContent, $cameraMatch)) {
  1168. $segmentData['camera_movement'] = trim($cameraMatch[1]);
  1169. $data['camera_movement'] = trim($cameraMatch[1]);
  1170. }
  1171. if (preg_match('/(?:配音角色|配音|角色|声优)[::]\s*([^\n]+)/u', $segmentContent, $voiceMatch)) {
  1172. $segmentData['voice_actor'] = trim($voiceMatch[1]);
  1173. $data['voice_actor'] = trim($voiceMatch[1]);
  1174. }
  1175. if (preg_match('/(?:台词内容|台词|对白|对话)[::]\s*([^\n]+)/u', $segmentContent, $dialogueMatch)) {
  1176. $segmentData['dialogue'] = trim($dialogueMatch[1]);
  1177. $data['dialogue'] = trim($dialogueMatch[1]);
  1178. }
  1179. if (preg_match('/(?:画面类型|镜头类型|类型)[::]\s*([^\n]+)/u', $segmentContent, $frameMatch)) {
  1180. $segmentData['frame_type'] = trim($frameMatch[1]);
  1181. $data['frame_type'] = trim($frameMatch[1]);
  1182. }
  1183. // 新增:场景字段
  1184. if (preg_match('/(?:场景|拍摄场景|背景场景|环境)[::]\s*([^\n]+)/u', $segmentContent, $sceneMatch)) {
  1185. $segmentData['scene'] = trim($sceneMatch[1]);
  1186. $data['scene'] = trim($sceneMatch[1]);
  1187. }
  1188. // 新增:出镜角色字段
  1189. if (preg_match('/(?:出镜角色|角色出镜|登场角色|人物)[::]\s*([^\n]+)/u', $segmentContent, $charactersMatch)) {
  1190. $segmentData['characters'] = trim($charactersMatch[1]);
  1191. $data['characters'] = trim($charactersMatch[1]);
  1192. }
  1193. return $segmentData;
  1194. }
  1195. public function createSegmentVideoTask($data) {
  1196. }
  1197. }