ApiController.php 32 KB

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