ApiController.php 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709
  1. <?php
  2. namespace App\Http\Controllers\WeChat;
  3. use App\Models\CheckCard;
  4. use App\Models\Content;
  5. use App\Models\FormData;
  6. use App\Models\FormSet;
  7. use App\Models\Leave;
  8. use App\Models\Order;
  9. use App\Models\Remark;
  10. use App\Models\RemarkDetail;
  11. use App\Models\RemarkTitle;
  12. use App\Models\Setting;
  13. use App\Models\Student;
  14. use App\Models\StudentCourse;
  15. use App\Models\StudentCourseTeacher;
  16. use App\Models\Teacher;
  17. use App\Models\WeChatUser;
  18. use Carbon\Carbon;
  19. use EasyWeChat\Factory;
  20. use GuzzleHttp\Client;
  21. use Illuminate\Http\Request;
  22. use App\Http\Controllers\Controller;
  23. use Illuminate\Support\Facades\Log;
  24. use Illuminate\Support\Facades\Storage;
  25. use Intervention\Image\Facades\Image;
  26. class ApiController extends Controller
  27. {
  28. public function login(Request $request)
  29. {
  30. if(empty($request->input('code'))) {
  31. return response()->json(['status' => 'error', 'info' => '参数错误']);
  32. }
  33. $app = app('wechat.mini_program');
  34. $res = $app->auth->session($request->input('code'));
  35. if(!isset($res['session_key'])) {
  36. return response()->json(['status' => 'error', 'info' => '接口错误']);
  37. }
  38. $res = WeChatUser::updateOrCreate([
  39. 'open_id' => $res['openid'],
  40. ], [
  41. 'code' => $request->input('code'),
  42. 'session_key' => $res['session_key'],
  43. ]);
  44. if(empty($res)) {
  45. return response()->json(['status' => 'error', 'info' => '数据库错误']);
  46. }
  47. return response()->json(['status' => 'success', 'id' => $res->id]);
  48. // if(empty($request->input('code')) || empty($request->input('iv')) || empty($request->input('encryptedData'))) {
  49. // return response()->json(['status' => 'error', 'info' => '参数错误']);
  50. // }
  51. // $code = $request->input('code');
  52. // $iv = $request->input('iv');
  53. // $encryptedData = $request->input('encryptedData');
  54. // $app = app('wechat.mini_program');
  55. // $res = $app->auth->session($code);
  56. //
  57. // if(!isset($res['session_key'])) {
  58. // return response()->json(['status' => 'error', 'info' => '接口错误']);
  59. // }
  60. //
  61. // $info = $app->encryptor->decryptData($res['session_key'], $iv, $encryptedData);
  62. //
  63. // if(!isset($info['openId'])) {
  64. // return response()->json(['status' => 'error', 'info' => '接口错误']);
  65. // }
  66. //
  67. // $student = Student::firstOrCreate([
  68. // 'open_id' => $info['openId']
  69. // ], [
  70. // 'nickname' => $info['nickName'],
  71. // 'gender' => $info['gender'],
  72. // 'city' => $info['city'],
  73. // 'province' => $info['province'],
  74. // 'country' => $info['country'],
  75. // 'avatar_url' => $info['avatarUrl'],
  76. // 'name' => $info['nickName'],
  77. // 'short_leave_times' => 0,
  78. // 'long_leave_times' => 0,
  79. // ]);
  80. //
  81. // $data = ['id' => $student->id, 'nickname' => $student->nickname, 'avatar_url' => $student->avatar_url];
  82. // return response()->json(['status' => 'success', 'info' => '操作成功', 'data' => $data]);
  83. }
  84. public function updateUserInfo(Request $request)
  85. {
  86. if(empty($request->input('id')) || empty($we_chat_user = WeChatUser::find($request->input('id'))) || empty($we_chat_user->session_key)) {
  87. return response()->json(['status' => 'error', 'info' => '参数错误11']);
  88. }
  89. if(empty($request->input('iv')) || empty($request->input('encryptedData'))) {
  90. return response()->json(['status' => 'error', 'info' => '参数错误']);
  91. }
  92. $iv = $request->input('iv');
  93. $encryptedData = $request->input('encryptedData');
  94. $session_key = $we_chat_user->session_key;
  95. $app = app('wechat.mini_program');
  96. $info = $app->encryptor->decryptData($session_key, $iv, $encryptedData);
  97. if(!isset($info['openId'])) {
  98. return response()->json(['status' => 'error', 'info' => '接口错误']);
  99. }
  100. $res = $we_chat_user->update([
  101. 'nickname' => $info['nickName'],
  102. 'gender' => $info['gender'],
  103. 'city' => $info['city'],
  104. 'province' => $info['province'],
  105. 'country' => $info['country'],
  106. 'avatar_url' => $info['avatarUrl']
  107. ]);
  108. if(empty($res)) {
  109. return response()->json(['status' => 'error', 'info' => '更新错误']);
  110. }
  111. // $student = Student::firstOrCreate([
  112. // 'open_id' => $info['openId']
  113. // ], [
  114. // 'nickname' => $info['nickName'],
  115. // 'gender' => $info['gender'],
  116. // 'city' => $info['city'],
  117. // 'province' => $info['province'],
  118. // 'country' => $info['country'],
  119. // 'avatar_url' => $info['avatarUrl'],
  120. // 'name' => $info['nickName'],
  121. // 'short_leave_times' => 0,
  122. // 'long_leave_times' => 0,
  123. // ]);
  124. $data = ['id' => $we_chat_user->id, 'nickname' => $we_chat_user->nickname, 'avatar_url' => $we_chat_user->avatar_url];
  125. return response()->json(['status' => 'success', 'info' => '操作成功', 'data' => $data]);
  126. }
  127. public function getPhone(Request $request)
  128. {
  129. if(empty($request->input('id')) || empty($we_chat_user = WeChatUser::find($request->input('id')))) {
  130. return response()->json(['status' => 'fail', 'info' => '找不到用户']);
  131. }
  132. if(empty($request->input('iv')) || empty($request->input('encryptedData'))) {
  133. return response()->json(['status' => 'error', 'info' => '参数错误']);
  134. }
  135. $iv = $request->input('iv');
  136. $encryptedData = $request->input('encryptedData');
  137. $session_key = $we_chat_user->session_key;
  138. $app = app('wechat.mini_program');
  139. $info = $app->encryptor->decryptData($session_key, $iv, $encryptedData);
  140. if(isset($info['purePhoneNumber'])) {
  141. return response()->json(['status' => 'success', 'info' => '操作成功', 'phone' => $info['purePhoneNumber']]);
  142. }
  143. return response()->json(['status' => 'fail', 'info' => '没有绑定手机']);
  144. }
  145. public function bindPhone(Request $request)
  146. {
  147. if(empty($request->input('id')) || empty($we_chat_user = WeChatUser::find($request->input('id')))) {
  148. return response()->json(['status' => 'fail', 'info' => '找不到用户']);
  149. }
  150. if(empty($request->input('phone')) || empty($student = Student::where('phone', $request->input('phone'))->first())) {
  151. return response()->json(['status' => 'fail', 'info' => '找不到学员']);
  152. }
  153. $res = $student->update([
  154. 'open_id' => $we_chat_user->open_id,
  155. 'nickname' => $we_chat_user->nickname,
  156. 'gender' => $we_chat_user->gender,
  157. 'city' => $we_chat_user->city,
  158. 'province' => $we_chat_user->province,
  159. 'country' => $we_chat_user->country,
  160. 'avatar_url' => $we_chat_user->avatar_url,
  161. 'bind_phone' => 2
  162. ]);
  163. if(empty($res)) {
  164. return response()->json(['status' => 'fail', 'info' => '数据更新失败']);
  165. }
  166. $data = ['id' => $student->id, 'nickname' => $student->nickname, 'avatar_url' => $student->avatar_url];
  167. return response()->json(['status' => 'success', 'info' => '操作成功', 'data' => $data]);
  168. }
  169. public function checkPosition(Request $request)
  170. {
  171. if(empty($request->input('latitude')) || empty($request->input('longitude'))) {
  172. return response()->json(['status' => 'fail', 'info' => '参数错误']);
  173. }
  174. $center_position = Setting::where('key', 'check_card_location')->first();
  175. if(empty($center_position) || empty($center_position->value) || count($tmp = explode(',', $center_position->value)) < 2) {
  176. $tmp = ['39.916527', '116.397128'];
  177. }
  178. $client = new Client();
  179. $from = $tmp[0] . ',' . $tmp[1];
  180. $to = $request->input('latitude') . ',' . $request->input('longitude');
  181. $url = 'https://apis.map.qq.com/ws/distance/v1/?from=' . $from . '&to=' . $to . '&key=' . env('TECENT_POSITION_KEY');
  182. $res = $client->get($url);
  183. $res = json_decode((string)$res->getBody());
  184. $result = 'no';
  185. if($res->status == 0) {
  186. $radius = Setting::where('key', 'check_card_radius')->first();
  187. $radius = empty($radius) ? 1000 : $radius->value;
  188. $distance = $res->result->elements[0]->distance;
  189. if($distance <= $radius) {
  190. $result = 'ok';
  191. }
  192. }
  193. $now = Carbon::today()->toDateTimeString();
  194. $checkCard = CheckCard::where([
  195. ['begin_date_time', '>', $now]
  196. ])->whereNull('end_date_time')->orderBy('begin_date_time', 'desc')->first();
  197. return response()->json(['status' => 'success', 'result' => $result, 'checkCard' => $checkCard]);
  198. }
  199. public function startCheckCard(Request $request)
  200. {
  201. if(empty($request->input('student_id')) || empty($student = Student::find($request->input('student_id')))) {
  202. return response()->json(['status' => 'fail', 'info' => '找不到学员']);
  203. }
  204. $student_course = StudentCourse::where('student_id', $student->id)->first();
  205. if(empty($student_course)) {
  206. return response()->json(['status' => 'fail', 'info' => '暂无课程']);
  207. }
  208. $res = CheckCard::create([
  209. 'student_id' => $student_course->student_id,
  210. 'course_id' => $student_course->course_id,
  211. 'student_course_id' => $student_course->id,
  212. 'begin_date_time' => Carbon::now()->toDateTimeString()
  213. ]);
  214. if(empty($res)) {
  215. return response()->json(['status' => 'fail', 'info' => '创建失败']);
  216. }
  217. return response()->json(['status' => 'success', 'check_card_id' => $res->id, 'info' => '操作成功']);
  218. }
  219. public function endCheckCard(Request $request)
  220. {
  221. if(empty($request->input('check_card_id')) || empty($item = CheckCard::find($request->input('check_card_id')))) {
  222. return response()->json(['status' => 'fail', 'info' => '找不到打卡记录']);
  223. }
  224. $item->end_date_time = Carbon::now()->toDateTimeString();
  225. if(!$item->save()) {
  226. return response()->json(['status' => 'fail', 'info' => '打卡失败']);
  227. }
  228. return response()->json(['status' => 'success', 'info' => '打卡成功']);
  229. }
  230. public function getShareInfo(Request $request)
  231. {
  232. $share_image = Setting::where('key', 'share_image')->first();
  233. if(empty($share_image) || empty($share_image->value) || !Storage::disk('upload')->exists($share_image->value)) {
  234. return response()->json(['status' => 'fail', 'info' => '没有分享图片的信息!']);
  235. }
  236. if(empty($request->input('student_id')) || empty($student = Student::find($request->input('student_id')))) {
  237. return response()->json(['status' => 'fail', 'info' => '找不到用户信息!']);
  238. }
  239. $image_url = url($share_image->value);
  240. $image = Image::make($image_url);
  241. $items = $student->getCheckCardDates();
  242. $share_text = Setting::where('key', 'share_text')->first();
  243. if(empty($share_text) || empty($share_text->value)) {
  244. return response()->json(['status' => 'fail', 'info' => '找不到分享的文字!']);
  245. }
  246. $now = Carbon::now()->toDateString();
  247. $count = $items->contains($now) ? $items->count() : $items->count() + 1;
  248. $text = str_replace_array('{days}', [$count], $share_text->value);
  249. $share_text_pos = Setting::where('key', 'share_text_pos')->first();
  250. if(empty($share_text_pos) || empty($share_text_pos->value) || count($pos = explode(',', $share_text_pos->value)) < 2) {
  251. return response()->json(['status' => 'fail', 'info' => '分享文字位置错误或未设置!']);
  252. }
  253. return response()->json(['status' => 'success', 'width' => $image->width(), 'height' => $image->height(), 'shareImage' => $image_url, 'shareText' => $text, 'shareTextPosX' => $pos[0], 'shareTextPosY' => $pos[1]]);
  254. }
  255. public function getMoreVideosAndArticles(Request $request)
  256. {
  257. $video_offset = $request->input('video_offset', 0);
  258. $article_offset = $request->input('article_offset', 0);
  259. if(empty($request->input('type')) || !in_array($request->input('type'), ['both', 'video', 'article'])) {
  260. return response()->json(['status' => 'fail', 'info' => '参数错误']);
  261. }
  262. if($request->input('type') == 'both') {
  263. $video_list = Content::where('type', 3)->orderBy('sort')->offset($video_offset)->limit(15)->get();
  264. foreach($video_list as $item) {
  265. if(empty($item->pic_url)) {
  266. $item->pic_url = 'https://u5.9026.com/addons/swdz_mall/core/web/uploads/image/f0/f0734ad93d46497483344846864596a4.jpg';
  267. } else {
  268. $item->pic_url = url($item->pic_url);
  269. }
  270. $item->url = url($item->content);
  271. }
  272. $article_list = Content::where('type', 4)->orderBy('sort')->offset($article_offset)->limit(15)->get();
  273. foreach($article_list as $item) {
  274. $item->publish_date = substr($item->updated_at, 0, 10);
  275. }
  276. return response()->json(['status' => 'success', 'video_list' => $video_list, 'article_list' => $article_list, 'type' => $request->input('type')]);
  277. } else if($request->input('type') == 'video') {
  278. $list = Content::where('type', 3)->orderBy('sort')->offset($video_offset)->limit(15)->get();
  279. foreach($list as $item) {
  280. if(empty($item->pic_url)) {
  281. $item->pic_url = 'https://u5.9026.com/addons/swdz_mall/core/web/uploads/image/f0/f0734ad93d46497483344846864596a4.jpg';
  282. } else {
  283. $item->pic_url = url($item->pic_url);
  284. }
  285. $item->url = url($item->content);
  286. }
  287. } else {
  288. $list = Content::where('type', 4)->orderBy('sort')->offset($article_offset)->limit(15)->get();
  289. foreach($list as $item) {
  290. $item->publish_date = substr($item->updated_at, 0, 10);
  291. }
  292. }
  293. return response()->json(['status' => 'success', 'list' => $list, 'type' => $request->input('type')]);
  294. }
  295. public function getAnnounces(Request $request)
  296. {
  297. $offset = $request->input('offset', 0);
  298. $list = Content::whereIn('type', [1])->orderBy('sort')->offset($offset)->limit(15)->get();
  299. foreach($list as $item) {
  300. $item->publish_date = substr($item->created_at, 0, 10);
  301. }
  302. return response()->json(['status' => 'success', 'list' => $list]);
  303. }
  304. public function getCourseInfo(Request $request)
  305. {
  306. if(empty($request->input('student_id')) || empty($student = Student::find($request->input('student_id')))) {
  307. return response()->json(['status' => 'fail', 'info' => '找不到用户信息!']);
  308. }
  309. $student_course = StudentCourse::where('student_id', $student->id)->first();
  310. if(empty($student_course)) {
  311. return response()->json(['status' => 'fail', 'info' => '找不到课程!']);
  312. }
  313. $student_course->course_name = $student_course->course->name;
  314. $student_course->teacher_names = $student_course->getTeacherNames();
  315. $student_course->end_date = Carbon::createFromTimestamp(strtotime($student_course->apply_date))->addDays($student_course->duration)->toDateString();
  316. $student_course->short_leave_times = $student->short_leave_times;
  317. $student_course->long_leave_times = $student->long_leave_times;
  318. $is_new = $student->getIsNew();
  319. return response()->json(['status' => 'success', 'courseInfo' => $student_course, 'is_new' => $is_new]);
  320. }
  321. public function getMyLearnInfo(Request $request)
  322. {
  323. if(empty($request->input('student_id')) || empty($student = Student::find($request->input('student_id')))) {
  324. return response()->json(['status' => 'fail', 'info' => '找不到用户信息!']);
  325. }
  326. if(empty($request->input('year')) || empty($request->input('month'))) {
  327. return response()->json(['status' => 'fail', 'info' => '参数错误!']);
  328. }
  329. $year = $request->input('year');
  330. $month = $request->input('month');
  331. $begin_date_time = Carbon::create($year, $month, 1)->toDateTimeString();
  332. $end_date_time = Carbon::create($year, $month, 1)->addMonth(1)->toDateTimeString();
  333. $thisMonthLearnTime = 0;
  334. $totalLearnTime = 0;
  335. $checkCardList = collect();
  336. $items = CheckCard::where('student_id', $student->id)->whereNotNull('begin_date_time')->whereNotNull('end_date_time')->get();
  337. foreach($items as $item) {
  338. $duration = strtotime($item->end_date_time) - strtotime($item->begin_date_time);
  339. $totalLearnTime += $duration;
  340. if($item->begin_date_time >= $begin_date_time && $item->begin_date_time < $end_date_time) {
  341. $thisMonthLearnTime += $duration;
  342. $day = Carbon::createFromTimestamp(strtotime($item->end_date_time))->day;
  343. $tmp = $checkCardList->where('day', $day);
  344. if($tmp->count() == 0) {
  345. $checkCardList->push(collect(['month' => 'current', 'day' => $day, 'background' => '#fb534b', 'color' => '#ffffff']));
  346. }
  347. }
  348. }
  349. // $today = $now->day;
  350. // for($i = 1; $i <= $today; ++$i) {
  351. // $tmp = $checkCardList->where('day', $i);
  352. // if($tmp->count() == 0) {
  353. // $checkCardList->push(collect(['month' => 'current', 'day' => $i, 'color' => '#f65556']));
  354. // }
  355. // }
  356. $thisMonthLearnTime = $this->getHumanTime($thisMonthLearnTime);
  357. $totalLearnTime = $this->getHumanTime($totalLearnTime);
  358. $checkCardDays = $student->getCheckCardDates()->count();
  359. return response()->json(['status' => 'success', 'checkCardList' => $checkCardList, 'thisMonthLearnTime' => $thisMonthLearnTime, 'totalLearnTime' => $totalLearnTime, 'checkCardDays' => $checkCardDays]);
  360. }
  361. public function getHumanTime($seconds)
  362. {
  363. $res = '';
  364. $tmp = floor($seconds / 3600);
  365. $diff_time = $seconds % 3600;
  366. if(!empty($tmp)) {
  367. $res .= $tmp . '小时';
  368. }
  369. $tmp = floor($diff_time / 3600);
  370. $diff_time = $diff_time % 60;
  371. if(!empty($tmp)) {
  372. $res .= $tmp . '分钟';
  373. }
  374. if(!empty($diff_time)) {
  375. $res .= $diff_time . '秒';
  376. }
  377. return $res;
  378. }
  379. public function applyLeave(Request $request)
  380. {
  381. if(empty($request->input('student_id')) || empty($student = Student::find($request->input('student_id')))) {
  382. return response()->json(['status' => 'fail', 'info' => '找不到学员']);
  383. }
  384. if(empty($request->input('type')) || !in_array($request->input('type'), [1, 2])) {
  385. return response()->json(['status' => 'fail', 'info' => '找不到学员']);
  386. }
  387. $student_course = StudentCourse::where('student_id', $student->id)->first();
  388. if(empty($student_course)) {
  389. return response()->json(['status' => 'fail', 'info' => '暂无课程']);
  390. }
  391. $res = Leave::create([
  392. 'student_id' => $student->id,
  393. 'course_id' => $student_course->course_id,
  394. 'student_course_id' => $student_course->id,
  395. 'type' => $request->input('type'),
  396. 'date' => $request->input('date'),
  397. 'days' => $request->input('days'),
  398. 'remark' => $request->input('remark')
  399. ]);
  400. if(!$res) {
  401. return response()->json(['status' => 'fail', 'info' => '保存失败']);
  402. }
  403. return response()->json(['status' => 'success', 'info' => '请假成功']);
  404. }
  405. public function getRemarkTitles(Request $request)
  406. {
  407. if(empty($request->input('id')) || empty($student = Student::find($request->input('id')))) {
  408. return response()->json(['status' => 'fail', 'info' => '找不到学员']);
  409. }
  410. if(empty($student_course = StudentCourse::where('student_id', $student->id)->first())) {
  411. return response()->json(['status' => 'fail', 'info' => '找不到课程']);
  412. }
  413. if($student_course->assign_teacher == 1) {
  414. $teachers = Teacher::all();
  415. } else {
  416. $teacher_ids = StudentCourseTeacher::where('student_course_id', $student_course->id)->get()->pluck('teacher_id')->unique();
  417. $teachers = Teacher::whereIn('id', $teacher_ids)->get();
  418. }
  419. $is_new = $student->getIsNew();
  420. if($is_new) {
  421. $titles = RemarkTitle::where('status', 2)->get();
  422. return response()->json(['status' => 'success', 'titles' => $titles, 'teachers' => $teachers, 'is_new' => $is_new]);
  423. }
  424. foreach($teachers as $teacher) {
  425. $remark = Remark::where([
  426. ['student_id', '=', $student->id],
  427. ['teacher_id', '=', $teacher->id],
  428. ])->first();
  429. if(!empty($remark)) {
  430. $remark_time = RemarkDetail::where([
  431. ['remark_id', '=', $remark->id],
  432. ['teacher_id', '=', $teacher->id],
  433. ])->orderBy('updated_at', 'desc')->first();
  434. $teacher->remark_time = empty($remark_time) ? '' : substr($remark_time->updated_at, 0, 10);
  435. $teacher->average_score = $student->getThisWeekAverageScore($remark);
  436. } else {
  437. $teacher->remark_time = '';
  438. $teacher->average_score = 0;
  439. }
  440. }
  441. return response()->json(['status' => 'success', 'titles' => [], 'teachers' => $teachers, 'is_new' => $is_new]);
  442. }
  443. public function remarkTeacher(Request $request)
  444. {
  445. if(empty($request->input('student_id')) || empty($student = Student::find($request->input('student_id')))) {
  446. return response()->json(['status' => 'fail', 'info' => '找不到学员']);
  447. }
  448. $student_course = $student->getStudentCourse();
  449. if(empty($student_course)) {
  450. return response()->json(['status' => 'fail', 'info' => '找不到课程']);
  451. }
  452. // $student_course_teacher = StudentCourseTeacher::where('student_id', $student->id)->first();
  453. // if(empty($student_course_teacher)) {
  454. // return response()->json(['status' => 'fail', 'info' => '找不到讲师']);
  455. // }
  456. // $remarks = $request->except(['student_id']);
  457. $data = $request->input('data');
  458. if(!is_array($data)) {
  459. return response()->json(['status' => 'fail', 'info' => '参数错误']);
  460. }
  461. foreach($data as $teacher_key => $teacher_value) {
  462. $teacher = Teacher::find($teacher_key);
  463. if(empty($teacher) || !is_array($teacher_value)) {
  464. continue;
  465. }
  466. $remark = Remark::firstOrCreate([
  467. 'teacher_id' => $teacher->id,
  468. 'student_id' => $student->id
  469. ], [
  470. 'course_id' => $student_course->course_id
  471. ]);
  472. $remark->updated_at = Carbon::now()->toDateTimeString();
  473. $remark->save();
  474. foreach($teacher_value as $title_key => $title_value) {
  475. $remark_title = RemarkTitle::find($title_key);
  476. if(!empty($remark_title)) {
  477. RemarkDetail::create([
  478. 'remark_id' => $remark->id,
  479. 'teacher_id' => $teacher->id,
  480. 'question' => $remark_title->name,
  481. 'score' => $title_value,
  482. ]);
  483. }
  484. }
  485. }
  486. return response()->json(['status' => 'success']);
  487. }
  488. public function getArticleContent(Request $request)
  489. {
  490. if(empty($request->input('id')) || empty($item = Content::find($request->input('id')))) {
  491. return response()->json(['status' => 'fail', 'info' => '找不到文章']);
  492. }
  493. $item->content = $this->replaceImageSrc($item->content);
  494. $item->publish_date = substr($item->created_at, 0, 10);
  495. return response()->json(['status' => 'success', 'article' => $item]);
  496. }
  497. public function replaceImageSrc($img_tag)
  498. {
  499. $doc = new \DOMDocument();
  500. $img_tag = '<meta http-equiv="Content-Type" content="text/html;charset=utf-8">' . $img_tag;
  501. $doc->loadHTML($img_tag);
  502. $tags = $doc->getElementsByTagName('img');
  503. foreach ($tags as $tag) {
  504. $old_src = $tag->getAttribute('src');
  505. $new_src_url = url($old_src);
  506. $tag->setAttribute('src', $new_src_url);
  507. }
  508. return $doc->saveHTML();
  509. }
  510. public function getFormSet(Request $request)
  511. {
  512. $form_set = FormSet::first();
  513. if(empty($form_set)) {
  514. return response()->json(['status' => 'fail', 'info' => '找不到数据']);
  515. }
  516. if(!empty($form_set->top_image)) {
  517. $form_set->top_image = url($form_set->top_image);
  518. }
  519. if(!empty($form_set->radio_value)) {
  520. $form_set->radio_value = explode(',', $form_set->radio_value);
  521. }
  522. if(!empty($form_set->checkbox_value)) {
  523. $form_set->checkbox_value = explode(',', $form_set->checkbox_value);
  524. }
  525. return response()->json(['status' => 'success', 'data' => $form_set]);
  526. }
  527. public function submitForm(Request $request)
  528. {
  529. if(empty($request->input('data')) || !is_array($request->input('data'))) {
  530. return response()->json(['status' => 'fail', 'info' => '参数错误11']);
  531. }
  532. $form_set = FormSet::first();
  533. if(empty($form_set)) {
  534. return response()->json(['status' => 'fail', 'info' => '参数错误']);
  535. }
  536. $data = $request->input('data');
  537. if(!isset($data['type']) || !in_array($data['type'], ['pay', 'form'])) {
  538. return response()->json(['status' => 'fail', 'info' => '参数错误']);
  539. }
  540. $type = $data['type'];
  541. $items = ['text_1', 'text_2', 'text_3', 'text_4', 'multi_text', 'radio'];
  542. foreach($items as $item) {
  543. if(isset($data[$item])) {
  544. $data[$item] = $form_set[$item] . ':' . $data[$item];
  545. }
  546. }
  547. if(isset($data['checkbox']) && is_array($data['checkbox'])) {
  548. $data['checkbox'] = implode(',', $data['checkbox']);
  549. $data['checkbox'] = $form_set['checkbox'] . ':' . $data['checkbox'];
  550. }
  551. unset($data['type']);
  552. $res = FormData::create($data);
  553. if(empty($res)) {
  554. return response()->json(['status' => 'fail', 'info' => '保存失败']);
  555. }
  556. $money = $form_set->money;
  557. if($type == 'pay' && !empty($money)) {
  558. return $this->makeOrder($request, $money, $res->id);
  559. }
  560. return response()->json(['status' => 'success', 'info' => '提交成功']);
  561. }
  562. public function makeOrder(Request $request, $money, $form_data_id)
  563. {
  564. if(empty($request->input('id')) || empty($we_chat_user = WeChatUser::find($request->input('id')))) {
  565. return response()->json(['status' => 'fail', 'info' => '找不到用户']);
  566. }
  567. // $student = Student::where('open_id', $we_chat_user->open_id);
  568. $app = app('wechat.payment');
  569. $out_trade_no = (new Order())->getOutTradeNo();
  570. $order = Order::create([
  571. 'out_trade_no' => $out_trade_no,
  572. 'pay_position' => $request->input('mode', 1),
  573. 'pay_status' => 1,
  574. 'pay_method' => 1,
  575. 'money' => $money,
  576. 'form_data_id' => $form_data_id
  577. ]);
  578. if(empty($order)) {
  579. return response()->json(['status' => 'fail', 'info' => '订单创建失败']);
  580. }
  581. $result = $app->order->unify([
  582. 'body' => '钢琴时间',
  583. 'out_trade_no' => $out_trade_no,
  584. // 'total_fee' => $request->input('money'),
  585. 'notify_url' => url('/wechat/payNotify'),
  586. 'total_fee' => $money,
  587. 'trade_type' => 'JSAPI',
  588. 'openid' => $we_chat_user->open_id,
  589. ]);
  590. if ($result['return_code'] == 'SUCCESS' && $result['result_code'] == 'SUCCESS'){
  591. $prepayId = $result['prepay_id'];
  592. $config = [
  593. // 前面的appid什么的也得保留哦
  594. 'app_id' => $result['appid'],
  595. 'mch_id' => $result['mch_id'],
  596. 'key' => env('WECHAT_PAYMENT_KEY', 'key-for-signature'),
  597. // 'device_info' => '013467007045764',
  598. // 'sub_app_id' => '',
  599. // 'sub_merchant_id' => '',
  600. // ...
  601. ];
  602. $payment = Factory::payment($config);
  603. $jssdk = $payment->jssdk;
  604. $json = $jssdk->bridgeConfig($prepayId);
  605. } else {
  606. return response()->json(['status' => 'fail', 'info' => '支付失败']);
  607. }
  608. return response()->json(['status' => 'success', 'data' => $json]);
  609. }
  610. public function payNotify(Request $request)
  611. {
  612. $app = app('wechat.payment');
  613. $response = $app->handlePaidNotify(function ($message, $fail) {
  614. // Log::info($message);
  615. if($message['return_code'] === 'SUCCESS' && $message['result_code'] === 'SUCCESS' ) {
  616. $order = Order::where('out_trade_no', $message['out_trade_no'])->first();
  617. if(!empty($order) && $order->money == $message['total_fee']) {
  618. $order->pay_status = 2;
  619. $order->save();
  620. if(!empty($order->form_data_id) && !empty($form_data = FormData::find($order->form_data_id))) {
  621. $order->pay_status = 2;
  622. $order->save();
  623. }
  624. }
  625. } else {
  626. return $fail('通信失败,请稍后再通知我');
  627. }
  628. return true;
  629. });
  630. return $response;
  631. }
  632. }