TimbreService.php 9.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245
  1. <?php
  2. namespace App\Services\Timbre;
  3. use App\Consts\ErrorConst;
  4. use App\Facade\Site;
  5. use App\Libs\Utils;
  6. use GuzzleHttp\Client;
  7. use Illuminate\Support\Facades\DB;
  8. use Illuminate\Support\Facades\Redis;
  9. use OSS\Core\OssException;
  10. use OSS\OssClient;
  11. class TimbreService
  12. {
  13. public function __construct() {
  14. }
  15. public function addCategory($data) {
  16. $category_name = getProp($data, 'category_name');
  17. $pid = getProp($data, 'pid');
  18. if ($pid === '') Utils::throwError('20003:参数异常');
  19. $category = DB::table('mp_timbre_categories')->where('category_name', $category_name)->first();
  20. if ($category) {
  21. return Utils::throwError('20003:该分类已存在');
  22. }
  23. if ($pid) {
  24. $category = DB::table('mp_timbre_categories')->where('id', $pid)->first();
  25. if (!$category) {
  26. return Utils::throwError('20003:该分类不存在');
  27. }
  28. }
  29. $category_id = DB::table('mp_timbre_categories')->insertGetId([
  30. 'category_name' => $category_name,
  31. 'pid' => $pid,
  32. 'created_at' => date('Y-m-d H:i:s'),
  33. 'updated_at' => date('Y-m-d H:i:s'),
  34. ]);
  35. return [
  36. 'category_id' => $category_id,
  37. 'category_name' => $category_name,
  38. 'pid' => $pid,
  39. ];
  40. }
  41. public function editCategory($data) {
  42. $category_id = getProp($data, 'category_id');
  43. $category_name = getProp($data, 'category_name');
  44. $category = DB::table('mp_timbre_categories')->where('id', $category_id)->first();
  45. if (!$category) {
  46. return Utils::throwError('20003:该分类不存在');
  47. }
  48. $category = DB::table('mp_timbre_categories')->where('category_name', $category_name)->first();
  49. if ($category && $category->id != $category_id) {
  50. return Utils::throwError('20003:该分类已存在');
  51. }
  52. return DB::table('mp_timbre_categories')->where('id', $category_id)->update([
  53. 'category_name' => $category_name,
  54. 'updated_at' => date('Y-m-d H:i:s'),
  55. ]);
  56. }
  57. public function getCategoryList($data) {
  58. $category_type = getProp($data, 'category_type', 1);
  59. $category_id = getProp($data, 'category_id');
  60. $category_name = getProp($data, 'category_name');
  61. $pid = getProp($data, 'pid');
  62. $query = DB::table('mp_timbre_categories')->where('is_enable', 1)->select('*');
  63. switch ($category_type) {
  64. case 1:
  65. $query->where('pid', 0);
  66. break;
  67. case 2:
  68. $query->where('pid', $pid);
  69. break;
  70. case 3:
  71. $query->where('pid', $pid);
  72. break;
  73. default:
  74. break;
  75. }
  76. if ($category_id) {
  77. $query->where('id', $category_id);
  78. }
  79. if ($category_name) {
  80. $query->where('category_name', 'like', "%{$category_name}%");
  81. }
  82. return $query->orderBy('id')->paginate();
  83. }
  84. public function getTimbreList($data) {
  85. $timbre_name = getProp($data, 'voice_name');
  86. $language = getProp($data, 'language');
  87. $status = getProp($data, 'status');
  88. $dialect = getProp($data, 'dialect');
  89. $query = DB::table('mp_timbres')->where('is_enabled', 1)->select('*');
  90. if ($timbre_name) {
  91. $query->where('timbre_name', 'like', "%{$timbre_name}%");
  92. }
  93. if ($language) {
  94. $query->where('language', 'like', "%{$language}%");
  95. }
  96. if ($dialect) {
  97. $query->where('dialect', $dialect);
  98. }
  99. $result = $query->orderBy('id')->paginate();
  100. return $result;
  101. }
  102. public function timbreCategories($data) {
  103. $categories = DB::table('mp_timbre_categories')->where('is_enable', 1)->select('id as category_id', 'category_name', 'pid')->get()->map(function ($value) {
  104. return (array)$value;
  105. })->toArray();
  106. $result = buildCategoryTree($categories, 0);
  107. return $result;
  108. }
  109. public function editTimbre($data) {
  110. $timbre_id = getProp($data, 'voice_id');
  111. $timbre = DB::table('mp_timbres')->where('id', $timbre_id)->first();
  112. if (!$timbre) {
  113. return Utils::throwError('20003:该音色不存在');
  114. }
  115. return DB::table('mp_timbres')->where('id', $timbre_id)->update([
  116. 'first_category_id' => getProp($data, 'first_category_id'),
  117. 'first_category_name' => getProp($data, 'first_category_name'),
  118. 'second_category_id' => getProp($data, 'second_category_id'),
  119. 'second_category_name' => getProp($data, 'second_category_name'),
  120. 'third_category_id' => getProp($data, 'third_category_id'),
  121. 'third_category_name' => getProp($data, 'third_category_name'),
  122. 'label' => getProp($data, 'label'),
  123. 'updated_at' => date('Y-m-d H:i:s'),
  124. ]);
  125. }
  126. public function getAllBooks($data) {
  127. $bid = getProp($data, 'bid');
  128. $book_name = getProp($data, 'book_name');
  129. $query = DB::table('book_configs')->whereIn('is_on_shelf', [1,2])->select('bid', 'book_name');
  130. if ($bid) {
  131. $query->where('bid', $bid);
  132. }
  133. if ($book_name) {
  134. $query->where('book_name', 'like', "%{$book_name}%");
  135. }
  136. return $query->orderBy('bid', 'desc')->get()->map(function($value) {
  137. return (array)$value;
  138. })->toArray();
  139. }
  140. public function timbreGroupList($data) {
  141. $group_name = getProp($data, 'group_name');
  142. $label = getProp($data, 'label');
  143. $query = DB::table('mp_timbre_groups')->select('*');
  144. if ($group_name) {
  145. $query->where('group_name', 'like', "%{$group_name}%");
  146. }
  147. if ($label) {
  148. $query->where('label', 'like', $label);
  149. }
  150. return $query->orderBy('id')->paginate();
  151. }
  152. public function addTimbreGroup($data) {
  153. $group_name = getProp($data, 'group_name');
  154. $male_lead_voice_name = getProp($data, 'male_lead_voice_name');
  155. $male_lead_voice_type = getProp($data, 'male_lead_voice_type');
  156. $female_lead_voice_name = getProp($data, 'female_lead_voice_name');
  157. $female_lead_voice_type = getProp($data, 'female_lead_voice_type');
  158. $narration_voice_name = getProp($data, 'narration_voice_name');
  159. $narration_voice_type = getProp($data, 'narration_voice_type');
  160. if (!$group_name || !$male_lead_voice_type || !$female_lead_voice_type || !$narration_voice_type) Utils::throwError('20003:参数错误');
  161. $label = getProp($data, 'label');
  162. $other_roles = getProp($data, 'other_roles');
  163. if (DB::table('mp_timbre_groups')->where('group_name', $group_name)->value('id')) Utils::throwError('20003:该音色组已存在');
  164. return DB::table('mp_timbre_groups')->insert([
  165. 'group_name' => $group_name,
  166. 'male_lead_voice_name' => $male_lead_voice_name,
  167. 'male_lead_voice_type' => $male_lead_voice_type,
  168. 'female_lead_voice_name' => $female_lead_voice_name,
  169. 'female_lead_voice_type' => $female_lead_voice_type,
  170. 'narration_voice_name' => $narration_voice_name,
  171. 'narration_voice_type' => $narration_voice_type,
  172. 'label' => $label,
  173. 'other_roles' => $other_roles,
  174. 'created_at' => date('Y-m-d H:i:s'),
  175. 'updated_at' => date('Y-m-d H:i:s'),
  176. ]);
  177. }
  178. public function editTimbreGroup($data) {
  179. $group_id = getProp($data, 'group_id');
  180. $group_name = getProp($data, 'group_name');
  181. $male_lead_voice_name = getProp($data, 'male_lead_voice_name');
  182. $male_lead_voice_type = getProp($data, 'male_lead_voice_type');
  183. $female_lead_voice_name = getProp($data, 'female_lead_voice_name');
  184. $female_lead_voice_type = getProp($data, 'female_lead_voice_type');
  185. $narration_voice_name = getProp($data, 'narration_voice_name');
  186. $narration_voice_type = getProp($data, 'narration_voice_type');
  187. if (!$group_id || !$group_name || !$male_lead_voice_type || !$female_lead_voice_type || !$narration_voice_type) Utils::throwError('20003:参数错误');
  188. $label = getProp($data, 'label');
  189. $other_roles = getProp($data, 'other_roles');
  190. if (DB::table('mp_timbre_groups')->where('group_name', $group_name)->value('id') != $group_id) Utils::throwError('20003:该音色组已存在');
  191. return DB::table('mp_timbre_groups')->where('id', $group_id)->update([
  192. 'group_name' => $group_name,
  193. 'male_lead_voice_name' => $male_lead_voice_name,
  194. 'male_lead_voice_type' => $male_lead_voice_type,
  195. 'female_lead_voice_name' => $female_lead_voice_name,
  196. 'female_lead_voice_type' => $female_lead_voice_type,
  197. 'narration_voice_name' => $narration_voice_name,
  198. 'narration_voice_type' => $narration_voice_type,
  199. 'label' => $label,
  200. 'other_roles' => $other_roles,
  201. 'updated_at' => date('Y-m-d H:i:s'),
  202. ]);
  203. }
  204. }