ApiController.php 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743
  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. $check_position = Setting::where('key', 'check_position')->first();
  194. if(!empty($check_position) && $check_position->value == 2) {
  195. $result = 'ok';
  196. }
  197. $now = Carbon::today()->toDateTimeString();
  198. $checkCard = CheckCard::where([
  199. ['begin_date_time', '>', $now]
  200. ])->whereNull('end_date_time')->orderBy('begin_date_time', 'desc')->first();
  201. return response()->json(['status' => 'success', 'result' => $result, 'checkCard' => $checkCard]);
  202. }
  203. public function startCheckCard(Request $request)
  204. {
  205. if(empty($request->input('student_id')) || empty($student = Student::find($request->input('student_id')))) {
  206. return response()->json(['status' => 'fail', 'info' => '找不到学员']);
  207. }
  208. $student_course = StudentCourse::where('student_id', $student->id)->first();
  209. if(empty($student_course)) {
  210. return response()->json(['status' => 'fail', 'info' => '暂无课程']);
  211. }
  212. $res = CheckCard::create([
  213. 'student_id' => $student_course->student_id,
  214. 'course_id' => $student_course->course_id,
  215. 'student_course_id' => $student_course->id,
  216. 'begin_date_time' => Carbon::now()->toDateTimeString()
  217. ]);
  218. if(empty($res)) {
  219. return response()->json(['status' => 'fail', 'info' => '创建失败']);
  220. }
  221. return response()->json(['status' => 'success', 'check_card_id' => $res->id, 'info' => '操作成功']);
  222. }
  223. public function endCheckCard(Request $request)
  224. {
  225. if(empty($request->input('check_card_id')) || empty($item = CheckCard::find($request->input('check_card_id')))) {
  226. return response()->json(['status' => 'fail', 'info' => '找不到打卡记录']);
  227. }
  228. $item->end_date_time = Carbon::now()->toDateTimeString();
  229. if(!$item->save()) {
  230. return response()->json(['status' => 'fail', 'info' => '打卡失败']);
  231. }
  232. return response()->json(['status' => 'success', 'info' => '打卡成功']);
  233. }
  234. public function getShareInfo(Request $request)
  235. {
  236. $share_image = Setting::where('key', 'share_image')->first();
  237. if(empty($share_image) || empty($share_image->value) || !Storage::disk('upload')->exists($share_image->value)) {
  238. return response()->json(['status' => 'fail', 'info' => '没有分享图片的信息!']);
  239. }
  240. if(empty($request->input('student_id')) || empty($student = Student::find($request->input('student_id')))) {
  241. return response()->json(['status' => 'fail', 'info' => '找不到用户信息!']);
  242. }
  243. $image_url = url($share_image->value);
  244. $image = Image::make($image_url);
  245. $share_text = Setting::where('key', 'share_text')->first();
  246. if(empty($share_text) || empty($share_text->value)) {
  247. return response()->json(['status' => 'fail', 'info' => '找不到分享的文字!']);
  248. }
  249. $count = $student->getTodayCheckCardMinutes();
  250. $text = str_replace_array('{param}', [$count], $share_text->value);
  251. $share_text_pos = Setting::where('key', 'share_text_pos')->first();
  252. if(empty($share_text_pos) || empty($share_text_pos->value) || count($pos = explode(',', $share_text_pos->value)) < 2) {
  253. return response()->json(['status' => 'fail', 'info' => '分享文字位置错误或未设置!']);
  254. }
  255. return response()->json(['status' => 'success', 'width' => $image->width(), 'height' => $image->height(), 'shareImage' => $image_url, 'shareText' => $text, 'shareTextPosX' => $pos[0], 'shareTextPosY' => $pos[1]]);
  256. }
  257. public function getShareText(Request $request)
  258. {
  259. if(empty($request->input('student_id')) || empty($student = Student::find($request->input('student_id')))) {
  260. return response()->json(['status' => 'fail', 'info' => '找不到用户信息!']);
  261. }
  262. $share_text = Setting::where('key', 'share_text')->first();
  263. if(empty($share_text) || empty($share_text->value)) {
  264. return response()->json(['status' => 'fail', 'info' => '找不到分享的文字!']);
  265. }
  266. $count = $student->getTodayCheckCardMinutes();
  267. $text = str_replace_array('{param}', [$count], $share_text->value);
  268. return response()->json(['status' => 'success', 'shareText' => $text]);
  269. }
  270. public function getMoreVideosAndArticles(Request $request)
  271. {
  272. $video_offset = $request->input('video_offset', 0);
  273. $article_offset = $request->input('article_offset', 0);
  274. if(empty($request->input('type')) || !in_array($request->input('type'), ['both', 'video', 'article'])) {
  275. return response()->json(['status' => 'fail', 'info' => '参数错误']);
  276. }
  277. if($request->input('type') == 'both') {
  278. $video_list = Content::where('type', 3)->orderBy('sort')->offset($video_offset)->limit(15)->get();
  279. foreach($video_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. $article_list = Content::where('type', 4)->orderBy('sort')->offset($article_offset)->limit(15)->get();
  288. foreach($article_list as $item) {
  289. $item->publish_date = substr($item->updated_at, 0, 10);
  290. $item->pic_url = empty($item->pic_url) ? null : url($item->pic_url);
  291. }
  292. return response()->json(['status' => 'success', 'video_list' => $video_list, 'article_list' => $article_list, 'type' => $request->input('type')]);
  293. } else if($request->input('type') == 'video') {
  294. $list = Content::where('type', 3)->orderBy('sort')->offset($video_offset)->limit(15)->get();
  295. foreach($list as $item) {
  296. if(empty($item->pic_url)) {
  297. $item->pic_url = 'https://u5.9026.com/addons/swdz_mall/core/web/uploads/image/f0/f0734ad93d46497483344846864596a4.jpg';
  298. } else {
  299. $item->pic_url = url($item->pic_url);
  300. }
  301. $item->url = url($item->content);
  302. }
  303. } else {
  304. $list = Content::where('type', 4)->orderBy('sort')->offset($article_offset)->limit(15)->get();
  305. foreach($list as $item) {
  306. $item->publish_date = substr($item->updated_at, 0, 10);
  307. $item->pic_url = empty($item->pic_url) ? null : url($item->pic_url);
  308. }
  309. }
  310. return response()->json(['status' => 'success', 'list' => $list, 'type' => $request->input('type')]);
  311. }
  312. public function getAnnounces(Request $request)
  313. {
  314. $offset = $request->input('offset', 0);
  315. $list = Content::whereIn('type', [1])->orderBy('sort')->offset($offset)->limit(15)->get();
  316. foreach($list as $item) {
  317. $item->publish_date = substr($item->created_at, 0, 10);
  318. $item->pic_url = empty($item->pic_url) ? null : url($item->pic_url);
  319. }
  320. return response()->json(['status' => 'success', 'list' => $list]);
  321. }
  322. public function getCourseInfo(Request $request)
  323. {
  324. if(empty($request->input('student_id')) || empty($student = Student::find($request->input('student_id')))) {
  325. return response()->json(['status' => 'fail', 'info' => '找不到用户信息!']);
  326. }
  327. $student_course = StudentCourse::where('student_id', $student->id)->first();
  328. if(empty($student_course)) {
  329. return response()->json(['status' => 'fail', 'info' => '找不到课程!']);
  330. }
  331. $student_course->course_name = $student_course->course->name;
  332. $student_course->teacher_names = $student_course->getTeacherNames();
  333. $student_course->end_date = $student_course->computeEndDate();
  334. $student_course->short_leave_times = $student->short_leave_times;
  335. $student_course->long_leave_times = $student->long_leave_times;
  336. $is_new = $student->getIsNew();
  337. return response()->json(['status' => 'success', 'courseInfo' => $student_course, 'is_new' => $is_new]);
  338. }
  339. public function getMyLearnInfo(Request $request)
  340. {
  341. if(empty($request->input('student_id')) || empty($student = Student::find($request->input('student_id')))) {
  342. return response()->json(['status' => 'fail', 'info' => '找不到用户信息!']);
  343. }
  344. if(empty($request->input('year')) || empty($request->input('month'))) {
  345. return response()->json(['status' => 'fail', 'info' => '参数错误!']);
  346. }
  347. $year = $request->input('year');
  348. $month = $request->input('month');
  349. $begin_date_time = Carbon::create($year, $month, 1)->toDateTimeString();
  350. $end_date_time = Carbon::create($year, $month, 1)->addMonth(1)->toDateTimeString();
  351. $thisMonthLearnTime = 0;
  352. $totalLearnTime = 0;
  353. $checkCardList = collect();
  354. $items = CheckCard::where('student_id', $student->id)->whereNotNull('begin_date_time')->whereNotNull('end_date_time')->get();
  355. foreach($items as $item) {
  356. $duration = strtotime($item->end_date_time) - strtotime($item->begin_date_time);
  357. $totalLearnTime += $duration;
  358. if($item->begin_date_time >= $begin_date_time && $item->begin_date_time < $end_date_time) {
  359. $thisMonthLearnTime += $duration;
  360. $day = Carbon::createFromTimestamp(strtotime($item->end_date_time))->day;
  361. $tmp = $checkCardList->where('day', $day);
  362. if($tmp->count() == 0) {
  363. $checkCardList->push(collect(['month' => 'current', 'day' => $day, 'background' => '#fb534b', 'color' => '#ffffff']));
  364. }
  365. }
  366. }
  367. // $today = $now->day;
  368. // for($i = 1; $i <= $today; ++$i) {
  369. // $tmp = $checkCardList->where('day', $i);
  370. // if($tmp->count() == 0) {
  371. // $checkCardList->push(collect(['month' => 'current', 'day' => $i, 'color' => '#f65556']));
  372. // }
  373. // }
  374. $thisMonthLearnTime = $this->getHumanTime($thisMonthLearnTime);
  375. $totalLearnTime = $this->getHumanTime($totalLearnTime);
  376. $checkCardDays = $student->getCheckCardDates()->count();
  377. return response()->json(['status' => 'success', 'checkCardList' => $checkCardList, 'thisMonthLearnTime' => $thisMonthLearnTime, 'totalLearnTime' => $totalLearnTime, 'checkCardDays' => $checkCardDays]);
  378. }
  379. public function getHumanTime($seconds)
  380. {
  381. $res = '';
  382. $tmp = floor($seconds / 3600);
  383. $diff_time = $seconds % 3600;
  384. if(!empty($tmp)) {
  385. $res .= $tmp . '小时';
  386. }
  387. $tmp = floor($diff_time / 3600);
  388. $diff_time = $diff_time % 60;
  389. if(!empty($tmp)) {
  390. $res .= $tmp . '分钟';
  391. }
  392. if(!empty($diff_time)) {
  393. $res .= $diff_time . '秒';
  394. }
  395. return $res;
  396. }
  397. public function applyLeave(Request $request)
  398. {
  399. if(empty($request->input('student_id')) || empty($student = Student::find($request->input('student_id')))) {
  400. return response()->json(['status' => 'fail', 'info' => '找不到学员']);
  401. }
  402. if(empty($request->input('type')) || !in_array($request->input('type'), [1, 2])) {
  403. return response()->json(['status' => 'fail', 'info' => '找不到学员']);
  404. }
  405. if($request->input('type') == 1 && $student->short_leave_times <= 0) {
  406. return response()->json(['status' => 'fail', 'info' => '短假次数达到上限']);
  407. }
  408. if($request->input('type') == 2 && $student->long_leave_times <= 0) {
  409. return response()->json(['status' => 'fail', 'info' => '长假次数达到上限']);
  410. }
  411. $student_course = StudentCourse::where('student_id', $student->id)->first();
  412. if(empty($student_course)) {
  413. return response()->json(['status' => 'fail', 'info' => '暂无课程']);
  414. }
  415. $res = Leave::create([
  416. 'student_id' => $student->id,
  417. 'course_id' => $student_course->course_id,
  418. 'student_course_id' => $student_course->id,
  419. 'type' => $request->input('type'),
  420. 'date' => $request->input('date'),
  421. 'days' => $request->input('days'),
  422. 'remark' => $request->input('remark')
  423. ]);
  424. if(!$res) {
  425. return response()->json(['status' => 'fail', 'info' => '保存失败']);
  426. }
  427. if($request->input('type') == 1) {
  428. $student->short_leave_times -= 1;
  429. $student->save();
  430. }
  431. if($request->input('type') == 2) {
  432. $student->long_leave_times -= 1;
  433. $student->save();
  434. }
  435. return response()->json(['status' => 'success', 'info' => '请假成功']);
  436. }
  437. public function getRemarkTitles(Request $request)
  438. {
  439. if(empty($request->input('id')) || empty($student = Student::find($request->input('id')))) {
  440. return response()->json(['status' => 'fail', 'info' => '找不到学员']);
  441. }
  442. if(empty($student_course = StudentCourse::where('student_id', $student->id)->first())) {
  443. return response()->json(['status' => 'fail', 'info' => '找不到课程']);
  444. }
  445. if($student_course->assign_teacher == 1) {
  446. $teachers = Teacher::all();
  447. } else {
  448. $teacher_ids = StudentCourseTeacher::where('student_course_id', $student_course->id)->get()->pluck('teacher_id')->unique();
  449. $teachers = Teacher::whereIn('id', $teacher_ids)->get();
  450. }
  451. $is_new = $student->getIsNew();
  452. if($is_new) {
  453. $titles = RemarkTitle::where('status', 2)->get();
  454. return response()->json(['status' => 'success', 'titles' => $titles, 'teachers' => $teachers, 'is_new' => $is_new]);
  455. }
  456. foreach($teachers as $teacher) {
  457. $remark = Remark::where([
  458. ['student_id', '=', $student->id],
  459. ['teacher_id', '=', $teacher->id],
  460. ])->first();
  461. if(!empty($remark)) {
  462. $remark_time = RemarkDetail::where([
  463. ['remark_id', '=', $remark->id],
  464. ['teacher_id', '=', $teacher->id],
  465. ])->orderBy('updated_at', 'desc')->first();
  466. $teacher->remark_time = empty($remark_time) ? '' : substr($remark_time->updated_at, 0, 10);
  467. $teacher->average_score = $student->getThisWeekAverageScore($remark);
  468. } else {
  469. $teacher->remark_time = '';
  470. $teacher->average_score = 0;
  471. }
  472. }
  473. return response()->json(['status' => 'success', 'titles' => [], 'teachers' => $teachers, 'is_new' => $is_new]);
  474. }
  475. public function remarkTeacher(Request $request)
  476. {
  477. if(empty($request->input('student_id')) || empty($student = Student::find($request->input('student_id')))) {
  478. return response()->json(['status' => 'fail', 'info' => '找不到学员']);
  479. }
  480. $student_course = $student->getStudentCourse();
  481. if(empty($student_course)) {
  482. return response()->json(['status' => 'fail', 'info' => '找不到课程']);
  483. }
  484. // $student_course_teacher = StudentCourseTeacher::where('student_id', $student->id)->first();
  485. // if(empty($student_course_teacher)) {
  486. // return response()->json(['status' => 'fail', 'info' => '找不到讲师']);
  487. // }
  488. // $remarks = $request->except(['student_id']);
  489. $data = $request->input('data');
  490. if(!is_array($data)) {
  491. return response()->json(['status' => 'fail', 'info' => '参数错误']);
  492. }
  493. foreach($data as $teacher_key => $teacher_value) {
  494. $teacher = Teacher::find($teacher_key);
  495. if(empty($teacher) || !is_array($teacher_value)) {
  496. continue;
  497. }
  498. $remark = Remark::firstOrCreate([
  499. 'teacher_id' => $teacher->id,
  500. 'student_id' => $student->id
  501. ], [
  502. 'course_id' => $student_course->course_id
  503. ]);
  504. $remark->updated_at = Carbon::now()->toDateTimeString();
  505. $remark->save();
  506. foreach($teacher_value as $title_key => $title_value) {
  507. $remark_title = RemarkTitle::find($title_key);
  508. if(!empty($remark_title)) {
  509. RemarkDetail::create([
  510. 'remark_id' => $remark->id,
  511. 'teacher_id' => $teacher->id,
  512. 'question' => $remark_title->name,
  513. 'score' => $title_value,
  514. ]);
  515. }
  516. }
  517. }
  518. return response()->json(['status' => 'success']);
  519. }
  520. public function getArticleContent(Request $request)
  521. {
  522. if(empty($request->input('id')) || empty($item = Content::find($request->input('id')))) {
  523. return response()->json(['status' => 'fail', 'info' => '找不到文章']);
  524. }
  525. $item->content = $this->replaceImageSrc($item->content);
  526. $item->publish_date = substr($item->created_at, 0, 10);
  527. return response()->json(['status' => 'success', 'article' => $item]);
  528. }
  529. public function replaceImageSrc($img_tag)
  530. {
  531. $doc = new \DOMDocument();
  532. $img_tag = '<meta http-equiv="Content-Type" content="text/html;charset=utf-8">' . $img_tag;
  533. $doc->loadHTML($img_tag);
  534. $tags = $doc->getElementsByTagName('img');
  535. foreach ($tags as $tag) {
  536. $old_src = $tag->getAttribute('src');
  537. $new_src_url = url($old_src);
  538. $tag->setAttribute('src', $new_src_url);
  539. }
  540. return $doc->saveHTML();
  541. }
  542. public function getFormSet(Request $request)
  543. {
  544. $form_set = FormSet::first();
  545. if(empty($form_set)) {
  546. return response()->json(['status' => 'fail', 'info' => '找不到数据']);
  547. }
  548. if(!empty($form_set->top_image)) {
  549. $form_set->top_image = url($form_set->top_image);
  550. }
  551. if(!empty($form_set->radio_value)) {
  552. $form_set->radio_value = explode(',', $form_set->radio_value);
  553. }
  554. if(!empty($form_set->checkbox_value)) {
  555. $form_set->checkbox_value = explode(',', $form_set->checkbox_value);
  556. }
  557. return response()->json(['status' => 'success', 'data' => $form_set]);
  558. }
  559. public function submitForm(Request $request)
  560. {
  561. if(empty($request->input('data')) || !is_array($request->input('data'))) {
  562. return response()->json(['status' => 'fail', 'info' => '参数错误11']);
  563. }
  564. $form_set = FormSet::first();
  565. if(empty($form_set)) {
  566. return response()->json(['status' => 'fail', 'info' => '参数错误']);
  567. }
  568. $data = $request->input('data');
  569. if(!isset($data['type']) || !in_array($data['type'], ['pay', 'form'])) {
  570. return response()->json(['status' => 'fail', 'info' => '参数错误']);
  571. }
  572. $type = $data['type'];
  573. $items = ['text_1', 'text_2', 'text_3', 'text_4', 'multi_text', 'radio'];
  574. foreach($items as $item) {
  575. if(isset($data[$item])) {
  576. $data[$item] = $form_set[$item] . ':' . $data[$item];
  577. }
  578. }
  579. if(isset($data['checkbox']) && is_array($data['checkbox'])) {
  580. $data['checkbox'] = implode(',', $data['checkbox']);
  581. $data['checkbox'] = $form_set['checkbox'] . ':' . $data['checkbox'];
  582. }
  583. unset($data['type']);
  584. $res = FormData::create($data);
  585. if(empty($res)) {
  586. return response()->json(['status' => 'fail', 'info' => '保存失败']);
  587. }
  588. $money = $form_set->money;
  589. if($type == 'pay' && !empty($money)) {
  590. return $this->makeOrder($request, $money, $res->id);
  591. }
  592. return response()->json(['status' => 'success', 'info' => '提交成功']);
  593. }
  594. public function makeOrder(Request $request, $money, $form_data_id)
  595. {
  596. if(empty($request->input('id')) || empty($we_chat_user = WeChatUser::find($request->input('id')))) {
  597. return response()->json(['status' => 'fail', 'info' => '找不到用户']);
  598. }
  599. // $student = Student::where('open_id', $we_chat_user->open_id);
  600. $app = app('wechat.payment');
  601. $out_trade_no = (new Order())->getOutTradeNo();
  602. $order = Order::create([
  603. 'out_trade_no' => $out_trade_no,
  604. 'pay_position' => $request->input('mode', 1),
  605. 'pay_status' => 1,
  606. 'pay_method' => 1,
  607. 'money' => $money,
  608. 'form_data_id' => $form_data_id
  609. ]);
  610. if(empty($order)) {
  611. return response()->json(['status' => 'fail', 'info' => '订单创建失败']);
  612. }
  613. $result = $app->order->unify([
  614. 'body' => '钢琴时间',
  615. 'out_trade_no' => $out_trade_no,
  616. // 'total_fee' => $request->input('money'),
  617. 'notify_url' => url('/wechat/payNotify'),
  618. 'total_fee' => $money,
  619. 'trade_type' => 'JSAPI',
  620. 'openid' => $we_chat_user->open_id,
  621. ]);
  622. if ($result['return_code'] == 'SUCCESS' && $result['result_code'] == 'SUCCESS'){
  623. $prepayId = $result['prepay_id'];
  624. $config = [
  625. // 前面的appid什么的也得保留哦
  626. 'app_id' => $result['appid'],
  627. 'mch_id' => $result['mch_id'],
  628. 'key' => env('WECHAT_PAYMENT_KEY', 'key-for-signature'),
  629. // 'device_info' => '013467007045764',
  630. // 'sub_app_id' => '',
  631. // 'sub_merchant_id' => '',
  632. // ...
  633. ];
  634. $payment = Factory::payment($config);
  635. $jssdk = $payment->jssdk;
  636. $json = $jssdk->bridgeConfig($prepayId);
  637. } else {
  638. return response()->json(['status' => 'fail', 'info' => '支付失败']);
  639. }
  640. return response()->json(['status' => 'success', 'data' => $json]);
  641. }
  642. public function payNotify(Request $request)
  643. {
  644. $app = app('wechat.payment');
  645. $response = $app->handlePaidNotify(function ($message, $fail) {
  646. // Log::info($message);
  647. if($message['return_code'] === 'SUCCESS' && $message['result_code'] === 'SUCCESS' ) {
  648. $order = Order::where('out_trade_no', $message['out_trade_no'])->first();
  649. if(!empty($order) && $order->money == $message['total_fee']) {
  650. $order->pay_status = 2;
  651. $order->save();
  652. if(!empty($order->form_data_id) && !empty($form_data = FormData::find($order->form_data_id))) {
  653. $form_data->pay_status = 2;
  654. $form_data->save();
  655. }
  656. }
  657. } else {
  658. return $fail('通信失败,请稍后再通知我');
  659. }
  660. return true;
  661. });
  662. return $response;
  663. }
  664. }