WordsController.class.php 58 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238
  1. <?php
  2. namespace Api\Controller;
  3. use Common\Controller\ApiController;
  4. class WordsController extends ApiController {
  5. public function __construct(){
  6. parent::__construct();
  7. }
  8. public function test2(){
  9. M('User')->where(array('user_id'=>0))->setInc('sys_notice');
  10. }
  11. //获取单词列表
  12. public function index(){
  13. $sort = I('sort',1);
  14. $lastId = I('last_id',0);
  15. $courseId = I('course_id');
  16. $pageSize = I('page_size',20);
  17. $keyword = I('keyword','');
  18. if (empty($courseId) || $courseId<1000000){
  19. $data = array('code'=>1,'msg'=>'课程ID错误');
  20. $this->returnData($data);exit;
  21. }
  22. $condition = array('is_delete'=>1,'course_id'=>$courseId);
  23. if (!empty($keyword)){
  24. $condition['words_name'] = array('LIKE','%'.$keyword.'%');
  25. }
  26. $orderby = '';
  27. if ($sort==1){
  28. $orderby = 'words_id asc';
  29. }else if($sort==2){
  30. $wordsSortInfo = M('WordsSort')->where(array('course_id'=>$courseId,'user_id'=>$this->userId,'sort_status'=>1))->field('word_ids')->find();
  31. if ($wordsSortInfo==NULL){
  32. $data = array('code'=>0,'msg'=>'占未设置乱序','data'=>array());
  33. $this->returnData($data);exit;
  34. }
  35. }
  36. if ($lastId>0 && $sort==1){
  37. $condition['words_id'] = array('LT',$lastId);
  38. }
  39. $courseInfo = M('Course')->where(array('course_id'=>$courseId,'is_show'=>1))->field('course_id,user_id,course_name,course_source,operate_dt')->find();
  40. if ($courseInfo['course_name']=='易错单词'){
  41. if ($lastId>0){
  42. $data = array('code'=>0,'msg'=>'无更多数据','data'=>array());
  43. $this->returnData($data);exit;
  44. }
  45. $errorInfo = M('Test')->where(array('user_id'=>$this->userId))->order('test_id desc')->field('words_error')->find();
  46. if ($errorInfo==NULL){
  47. $data = array('code'=>0,'msg'=>'暂无错误单词','data'=>array());
  48. $this->returnData($data);exit;
  49. }
  50. $res = M('Words')->where(array('words_id'=>array('IN',$errorInfo['words_error'])))->order($orderby)->select();
  51. }else{
  52. //$join = 'w LEFT JOIN t_words_notepad wn ON w.words_id=wn.words_id';
  53. if ($sort==1){
  54. $res = M('Words')->where($condition)->order($orderby)->limit($pageSize)->select();
  55. }else if($sort==2){
  56. $wordIdArr = explode(',', $wordsSortInfo['word_ids']);
  57. if ($lastId!=0){
  58. $key = array_search($lastId,$wordIdArr);
  59. $key = $key+1;
  60. }else{
  61. $key = 0;
  62. }
  63. $wordsIdPage = array_slice($wordIdArr,$key,$pageSize);
  64. if (empty($wordsIdPage)){
  65. $data = array('code'=>0,'msg'=>'无更多数据','data'=>array());
  66. $this->returnData($data);exit;
  67. }
  68. $wordsIdpageStr = implode(',', $wordsIdPage);
  69. $condition['words_id'] = array('IN',$wordsIdPage);
  70. $orderby = 'field(words_id,'. $wordsIdpageStr .')';
  71. $res = M('Words')->where($condition)->order($orderby)->select();
  72. //echo M('Words')->getLastSql();exit;
  73. }
  74. }
  75. $wordsList = array();
  76. foreach ($res as $row){
  77. $wnRes = M('WordsNotepad')->where(array('words_id'=>$row['words_id'],'user_id'=>$this->userId))->field('wn_content')->find();
  78. $wnContent = '';
  79. if ($wnRes!=NULL){
  80. $wnContent = $wnRes['wn_content'];
  81. }
  82. unset($row['is_delete']);
  83. unset($row['words_source']);
  84. $row['wn_content'] = $wnContent;
  85. $row['annotation_cn']=html_entity_decode($row['annotation_cn']);
  86. $row['words_name']=html_entity_decode($row['words_name']);
  87. $wordsList[] = $row;
  88. /* $wordsList[] = array(
  89. 'words_id' => $row['words_id'],
  90. 'course_id' => $row['course_id'],
  91. 'words_name' => $row['words_name'],
  92. 'wn_content'=>$wnContent,
  93. 'operate_dt' => $row['operate_dt'],
  94. 'words_text' => $this->getWordsText($row),
  95. ); */
  96. }
  97. if ($res==NULL&&$lastId>0){
  98. $data = array('code'=>0,'msg'=>'无更多数据','data'=>array());
  99. $this->returnData($data);exit;
  100. }
  101. if ($lastId==0){
  102. if ($courseInfo['user_id']!=$this->userId){
  103. $fansInfo = M('Fans')->where(array('user_id'=>$this->userId,'fans_user_id'=>$courseInfo['user_id']))->field('fans_id')->find();
  104. $courseInfo['is_fans'] = $fansInfo==NULL?0:1;
  105. /* if ($courseInfo['course_source']==1){
  106. $courseInfo['user_name'] = '系统课程';
  107. $courseInfo['user_icon'] = C('DOMAIN').'/Public/img/admin_icon.png';
  108. }else{
  109. $userInfo = M('User')->where(array('user_id'=>$courseInfo['user_id']))->field('user_name,user_icon,user_sex')->find();
  110. $courseInfo['user_name'] = $userInfo['user_name'];
  111. $courseInfo['user_icon'] = $userInfo['user_icon'];
  112. } */
  113. }else{
  114. $courseInfo['is_fans'] = 2;
  115. }
  116. $userInfo = M('User')->where(array('user_id'=>$courseInfo['user_id']))->field('user_id,user_name,user_icon,user_sex')->find();
  117. $courseInfo['user_id'] = $userInfo['user_id'];
  118. $courseInfo['user_sex'] = $userInfo['user_sex'];
  119. $courseInfo['user_icon'] = $userInfo['user_icon'];
  120. $courseInfo['user_name'] = $userInfo['user_name'];
  121. }else{
  122. $courseInfo = new \stdClass();
  123. }
  124. $data = array('code'=>0,'msg'=>'','data'=>$wordsList);
  125. if ($lastId==0){
  126. $data['info'] = $courseInfo;
  127. }
  128. $this->returnData($data);exit;
  129. }
  130. //获取指定章节单词列表
  131. public function part(){
  132. $sort = I('sort',1);
  133. $courseId = I('course_id');
  134. $partNum = I('part_num');
  135. if (empty($partNum) || $partNum<=0){
  136. $data = array('code'=>10,'msg'=>'章节ID错误');
  137. $this->returnData($data);exit;
  138. }
  139. if (empty($courseId) || $courseId<1000000){
  140. $data = array('code'=>1,'msg'=>'课程ID错误');
  141. $this->returnData($data);exit;
  142. }
  143. $partInfo = M('UserWords')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->field('uw_id,user_part,part_num')->find();
  144. if ($partInfo==NULL){
  145. $courseInfo = M('Course')->where(array('course_id'=>$courseId,'is_delete'=>1))->field('course_num')->find();
  146. $partInfo['user_part'] = 15;
  147. $partInfo['part_num'] = ceil($courseInfo['course_num']/$partInfo['user_part']);
  148. }
  149. if (empty($partInfo['part_num'])){
  150. $courseInfo = M('Course')->where(array('course_id'=>$courseId,'is_delete'=>1))->field('course_num')->find();
  151. $partInfo['user_part'] = 15;
  152. $partInfo['part_num'] = ceil($courseInfo['course_num']/$partInfo['user_part']);
  153. M('UserWords')->where(array('uw_id'=>$partInfo['uw_id']))->save(array('part_num'=>$partInfo['part_num']));
  154. }
  155. if ($partNum>$partInfo['part_num']){
  156. $data = array('code'=>10,'msg'=>'章节ID错误');
  157. $this->returnData($data);exit;
  158. }
  159. $wordsSortInfo = M('WordsSort')->where(array('course_id'=>$courseId,'user_id'=>$this->userId,'sort_status'=>1))->field('word_ids')->find();
  160. if ($wordsSortInfo==NULL){
  161. $condition = array('is_delete'=>1,'course_id'=>$courseId);
  162. $orderby = '';
  163. if ($sort==1){
  164. $orderby = 'words_id asc';
  165. }
  166. $condition['user_id'] = $this->userId;
  167. //$join = 'w LEFT JOIN t_words_notepad wn ON w.words_id=wn.words_id';
  168. $res =M('Words')->where($condition)->order($orderby)->limit(($partNum-1)*$partInfo['user_part'], $partInfo['user_part'])->select();
  169. }else{
  170. $wordIdArr = explode(',', $wordsSortInfo['word_ids']);
  171. $wordsIdPage = array_slice($wordIdArr,($partNum-1)*$partInfo['user_part'], $partInfo['user_part']);
  172. if (empty($wordsIdPage)){
  173. $data = array('code'=>0,'msg'=>'章节ID错误','data'=>array());
  174. $this->returnData($data);exit;
  175. }
  176. $wordsIdpageStr = implode(',', $wordsIdPage);
  177. $condition['words_id'] = array('IN',$wordsIdPage);
  178. $orderby = 'field(words_id,'. $wordsIdpageStr .')';
  179. $res = M('Words')->where($condition)->order($orderby)->select();
  180. }
  181. $wordsList = array();
  182. foreach ($res as $k=>$row){
  183. $wnRes = M('WordsNotepad')->where(array('words_id'=>$row['words_id'],'user_id'=>$this->userId))->field('wn_content')->find();
  184. $wnContent = '';
  185. if ($wnRes!=NULL){
  186. $wnContent = $wnRes['wn_content'];
  187. }
  188. unset($row['is_delete']);
  189. unset($row['words_source']);
  190. $row['wn_content'] = $wnContent;
  191. //判断读音是否空
  192. if (empty($row['words_read1'])){
  193. $row['words_read1'] = $row['words_read2'];
  194. $row['words_voice1'] = $row['words_voice2'];
  195. }
  196. $row['annotation_cn']=html_entity_decode($row['annotation_cn']);
  197. $row['words_name']=html_entity_decode($row['words_name']);
  198. $wordsList[] = $row;
  199. }
  200. $data = array('code'=>0,'msg'=>'','data'=>$wordsList);
  201. $this->returnData($data);exit;
  202. }
  203. //获取特殊课程指定章节单词列表
  204. public function specialPart(){
  205. $sort = I('sort',1);
  206. $courseId = I('course_id');
  207. $partNum = I('part_num');
  208. $wordsArr = array();
  209. $wordsRes = M('Words')->where(array('course_id'=>$courseId))->group('operate_dt')->order('operate_dt')->field('operate_dt')->select();
  210. if (function_exists('array_column')){
  211. $wordsArr = array_column($wordsRes, 'operate_dt');
  212. }else{
  213. foreach ($wordsRes as $row){
  214. $wordsArr[] = $row['operate_dt'];
  215. }
  216. }
  217. if (empty($partNum)){
  218. if ($wordsRes!=NULL){
  219. $partNum = $wordsArr[0];
  220. }else{
  221. $data = array('code'=>1,'msg'=>'章节ID错误');
  222. $this->returnData($data);exit;
  223. }
  224. }
  225. $partData = array('current_part'=>$partNum,'pre_part'=>'','next_part'=>'');
  226. $key = array_search($partNum,$wordsArr);
  227. //获取上一章
  228. if ($key-1>0){
  229. $partData['pre_part'] = isset($wordsArr[$key-1])?$wordsArr[$key-1]:'';
  230. }
  231. //下一章
  232. if (isset($wordsArr[$key+1])){
  233. $partData['next_part'] = $wordsArr[$key+1];
  234. }
  235. $wordsSortInfo = M('WordsSort')->where(array('course_id'=>$courseId,'user_id'=>$this->userId,'sort_status'=>1))->field('word_ids')->find();
  236. if ($wordsSortInfo==NULL){
  237. $orderby = '';
  238. if ($sort==1){
  239. $orderby = 'words_id asc';
  240. }
  241. //$join = 'w LEFT JOIN t_words_notepad wn ON w.words_id=wn.words_id';
  242. $res =M('Words')->where(array('course_id'=>$courseId,'operate_dt'=>$partNum))->order($orderby)->select();
  243. }else{
  244. $wordIdArr = explode(',', $wordsSortInfo['word_ids']);
  245. $wordsIdpageStr = implode(',', $wordIdArr);
  246. $condition['words_id'] = array('IN',$wordIdArr);
  247. $orderby = 'field(words_id,'. $wordsIdpageStr .')';
  248. $res = M('Words')->where($condition)->order($orderby)->select();
  249. }
  250. $wordsList = array();
  251. foreach ($res as $k=>$row){
  252. $wnRes = M('WordsNotepad')->where(array('words_id'=>$row['words_id'],'user_id'=>$this->userId))->field('wn_content')->find();
  253. $wnContent = '';
  254. if ($wnRes!=NULL){
  255. $wnContent = $wnRes['wn_content'];
  256. }
  257. unset($row['is_delete']);
  258. unset($row['words_source']);
  259. $row['wn_content'] = $wnContent;
  260. //判断读音是否空
  261. if (empty($row['words_read1'])){
  262. $row['words_read1'] = $row['words_read2'];
  263. $row['words_voice1'] = $row['words_voice2'];
  264. }
  265. $wordsList[] = $row;
  266. }
  267. $data = array('code'=>0,'msg'=>'','data'=>$wordsList,'partData'=>$partData);
  268. $this->returnData($data);exit;
  269. }
  270. //添加编辑单词
  271. public function edit(){
  272. $courseId = I('course_id');
  273. $wordsId = I('words_id','');
  274. $wordsName = I('words_name','');
  275. $Type = I('type','0');
  276. if (empty($courseId) || $courseId<1000000){
  277. $data = array('code'=>1,'msg'=>'课程ID错误');
  278. $this->returnData($data);exit;
  279. }
  280. //判断单词是否重复
  281. if (empty($wordsId)){
  282. $wordsInfo = M('Words')->where(array('course_id'=>$courseId,'words_name'=>$wordsName))->field('words_id,words_name')->find();
  283. if ($wordsInfo!=NUll){
  284. $data = array('code'=>1,'msg'=>'该课程已经添加过该单词,请勿重复添加!');
  285. $this->returnData($data);exit;
  286. }
  287. }
  288. if (!empty($wordsId)){
  289. $wordsInfo = M('Words')->where(array('course_id'=>$courseId,'words_name'=>$wordsName))->field('words_id,words_name')->find();
  290. if ($wordsInfo!=NUll && $wordsInfo['words_id']!=$wordsId){
  291. $data = array('code'=>1,'msg'=>'该课程已经添加过该单词,请勿重复添加!');
  292. $this->returnData($data);exit;
  293. }
  294. $wordsOldInfo = M('Words')->where(array('words_id'=>$wordsId))->field('course_id')->find();
  295. if($wordsOldInfo['course_id']!=$courseId){
  296. $data = array('code'=>1,'msg'=>'单词和课程不匹配!');
  297. $this->returnData($data);exit;
  298. }
  299. }
  300. $courseInfo = M('Course')->where(array('course_id'=>$courseId,'is_delete'=>1))->field('course_id,user_id,course_name,course_num,course_status,course_source,s_course_id')->find();
  301. if ($courseInfo==NULL){
  302. $data = array('code'=>1,'msg'=>'课程ID错误');
  303. $this->returnData($data);exit;
  304. }
  305. if (in_array($courseInfo['course_name'], array('易错单词','重点单词'))){
  306. $data = array('code'=>1,'msg'=>'不能编辑特殊课程单词');
  307. $this->returnData($data);exit;
  308. }
  309. $oldCourseInfo = $courseInfo;
  310. if ($courseInfo['course_status']==3 || $courseInfo['user_id']!=$this->userId){
  311. //创建新课程,并把就课程里面的所有的单词添加到新创建的课程中
  312. $userCourseInfo = M('Course')->where(array('user_id'=>$this->userId))->field('operate_dt')->find();
  313. if($userCourseInfo!=NULL){
  314. $time = time() - $userCourseInfo['operate_dt'];
  315. if ($time<C('COURSE_TIME')){
  316. $data = array('code'=>1,'msg'=>'3分钟内无法连续创建课程');
  317. $this->returnData($data);exit;
  318. }
  319. }
  320. $oldCourseId = $courseInfo['course_id'];
  321. if ($courseInfo['user_id']==$this->userId){
  322. M('Course')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->save(array('is_show'=>2));
  323. }else if($courseInfo['course_source']==1){
  324. //系统课程
  325. $sysCourse = M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->field('uw_id')->find();
  326. if ($sysCourse==NULL){
  327. $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
  328. if ($userInfo==NULL || empty($userInfo['user_part'])){
  329. $userPart = 15;
  330. $partNum =ceil($courseInfo['course_num']/15);
  331. }else{
  332. $userPart = $userInfo['user_part'];
  333. $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
  334. }
  335. $sysCourseInfo = array(
  336. 'user_id'=>$this->userId,
  337. 'course_id'=>$courseId,
  338. 'user_part'=>$userPart,
  339. 'part_num'=>$partNum,
  340. 'is_show'=>2,
  341. 'operate_dt'=>time(),
  342. );
  343. M('UserWords')->add($sysCourseInfo);
  344. }else{
  345. M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->save(array('is_show'=>2));
  346. }
  347. }
  348. //创建课程
  349. $courseInfo['s_course_id']=$courseInfo['course_id'];
  350. unset($courseInfo['course_id']);
  351. $courseInfo['course_status'] = 1;
  352. $courseInfo['operate_dt'] = time();
  353. $courseInfo['user_id'] = $this->userId;
  354. $courseInfo['course_source']=2;
  355. $courseInfo['course_name'] = $courseInfo['course_name'];//$this->getCourseName($courseInfo['course_name']);
  356. $courseId = M('Course')->add($courseInfo);
  357. $userWordsInfo = M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->field('uw_id')->find();
  358. if ($userWordsInfo==NULL){
  359. $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
  360. if ($userInfo==NULL || empty($userInfo['user_part'])){
  361. $userPart = 15;
  362. $partNum =ceil($courseInfo['course_num']/15);
  363. }else{
  364. $userPart = $userInfo['user_part'];
  365. $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
  366. }
  367. $saveCourseWordsInfo = array(
  368. 'user_id'=>$this->userId,
  369. 'course_id'=>$courseId,
  370. 'user_part'=>$userPart,
  371. 'part_num'=>$partNum,
  372. 'operate_dt'=>time(),
  373. );
  374. M('UserWords')->add($saveCourseWordsInfo);
  375. }else{
  376. M('UserWords')->where(array('uw_id'=>$userWordsInfo['uw_id']))->save(array('course_id'=>$courseId));
  377. //M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->save(array('course_id'=>$courseId));
  378. }
  379. //复制单词
  380. $this->copyWords($oldCourseId,$courseId);
  381. }else{
  382. $userWordsInfo = M('UserWords')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->field('uw_id')->find();
  383. if ($userWordsInfo==NULL){
  384. $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
  385. if ($userInfo==NULL || empty($userInfo['user_part'])){
  386. $userPart = 15;
  387. $partNum =ceil($courseInfo['course_num']/15);
  388. }else{
  389. $userPart = $userInfo['user_part'];
  390. $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
  391. }
  392. $saveCourseWordsInfo = array(
  393. 'user_id'=>$this->userId,
  394. 'course_id'=>$courseId,
  395. 'user_part'=>$userPart,
  396. 'part_num'=>$partNum,
  397. 'operate_dt'=>time(),
  398. );
  399. M('UserWords')->add($saveCourseWordsInfo);
  400. }
  401. }
  402. $wordsKeys = array('n'=>'words_n','pron'=>'words_pron','adj'=>'words_adj','num'=>'words_num','v'=>'words_v','adv'=>'words_adv','art'=>'words_art',
  403. 'prep'=>'words_prep','conj'=>'words_conj','int'=>'words_int','vt'=>'words_vt','vi'=>'words_vi','other'=>'words_other',);
  404. $saveData['course_id'] = $courseId;
  405. $saveData['words_name'] = I('words_name','');
  406. /* $wordsVoice = I('words_voice','');
  407. $wordsRead = I('words_read','');
  408. if (substr($wordsVoice,-1)==','){
  409. $wordsVoice = substr($wordsVoice, 0, -1);
  410. }
  411. $wordsVoiceArr = explode(',', $wordsVoice);
  412. $wordsReadArr = explode(',', $wordsRead);
  413. for ($i=0;$i<count($wordsVoiceArr);$i++){
  414. $j = $i+1;
  415. $saveData['words_read'.$j] = $wordsReadArr[$i];
  416. $saveData['words_voice'.$j] = $wordsVoiceArr[$i];
  417. } */
  418. if(I('words_voice1','')){
  419. $saveData['words_voice1'] = I('words_voice1','');
  420. }
  421. if(I('words_read1','')){
  422. $saveData['words_read1'] = I('words_read1','');
  423. }
  424. if(I('words_voice2','')){
  425. $saveData['words_voice2'] = I('words_voice2','');
  426. }
  427. if(I('words_read2','')){
  428. $saveData['words_read2'] = I('words_read2','');
  429. }
  430. if(I('words_voice3','')){
  431. $saveData['words_voice3'] = I('words_voice3','');
  432. }
  433. if(I('words_read3','')){
  434. $saveData['words_read3'] = I('words_read3','');
  435. }
  436. $wordsVals = array_values($wordsKeys);
  437. $checkWords = true;
  438. foreach ($wordsVals as $keys){
  439. $saveData[$keys] = I($keys,'');
  440. if (!empty($saveData[$keys])){
  441. $checkWords = false;
  442. }
  443. }
  444. if (empty($saveData['words_name'])){
  445. $data = array('code'=>1,'msg'=>'单词不能为空');
  446. $this->returnData($data);exit;
  447. }
  448. /*
  449. if (empty($saveData['words_voice1'])){
  450. $data = array('code'=>1,'msg'=>'读音不能为空');
  451. $this->returnData($data);exit;
  452. }
  453. if (empty($saveData['words_read1'])){
  454. $data = array('code'=>1,'msg'=>'音标不能为空');
  455. $this->returnData($data);exit;
  456. }
  457. */
  458. if ($checkWords){
  459. $data = array('code'=>1,'msg'=>'中文释义不能为空');
  460. $this->returnData($data);exit;
  461. }
  462. $saveData['jz_en1'] = I('jz_en1','');
  463. $saveData['jz_cn1'] = I('jz_cn1','');
  464. $saveData['jz_en2'] = I('jz_en2','');
  465. $saveData['jz_cn2'] = I('jz_cn2','');
  466. $saveData['jz_en3'] = I('jz_en3','');
  467. $saveData['jz_cn3'] = I('jz_cn3','');
  468. $saveData['words_img'] = I('words_img','');
  469. $saveData['similar_cn'] = I('similar_cn','');
  470. $saveData['similar_en'] = I('similar_en','');
  471. $saveData['words_similar'] = I('words_similar');
  472. $saveData['annotation_cn'] = I('annotation_cn','');
  473. if (!empty($saveData['jz_en1']) && strpos(strtolower($saveData['jz_en1']), strtolower($saveData['words_name']))===FALSE){
  474. $data = array('code'=>1,'msg'=>'您添加的例句1不包含对应单词,请仔细核对后提交');
  475. $this->returnData($data);exit;
  476. }
  477. if (!empty($saveData['jz_en2']) && strpos(strtolower($saveData['jz_en2']), strtolower($saveData['words_name']))===FALSE){
  478. $data = array('code'=>1,'msg'=>'您添加的例句2不包含对应单词,请仔细核对后提交交');
  479. $this->returnData($data);exit;
  480. }
  481. if (!empty($saveData['jz_en3']) && strpos(strtolower($saveData['jz_en3']), strtolower($saveData['words_name']))===FALSE){
  482. $data = array('code'=>1,'msg'=>'您添加的例句3不包含对应单词,请仔细核对后提交');
  483. $this->returnData($data);exit;
  484. }
  485. if (!empty($saveData['jz_en1']) && empty($saveData['jz_cn1'])){
  486. $data = array('code'=>1,'msg'=>'您添加的例句1释义不能为空,请仔细核对后提交');
  487. $this->returnData($data);exit;
  488. }
  489. if (!empty($saveData['jz_en2']) && empty($saveData['jz_cn2'])){
  490. $data = array('code'=>1,'msg'=>'您添加的例句1释义不能为空,请仔细核对后提交');
  491. $this->returnData($data);exit;
  492. }
  493. if (!empty($saveData['jz_en3']) && empty($saveData['jz_cn3'])){
  494. $data = array('code'=>1,'msg'=>'您添加的例句1释义不能为空,请仔细核对后提交');
  495. $this->returnData($data);exit;
  496. }
  497. if (!empty($saveData['words_similar']) && strlen($saveData['words_similar'])>50){
  498. $data = array('code'=>1,'msg'=>'近义词不能大于50个字节');
  499. $this->returnData($data);exit;
  500. }
  501. if (!empty($data['similar_cn']) && strlen($data['similar_cn'])>500){
  502. $data = array('code'=>1,'msg'=>'英文释义不能大于500个字节');
  503. $this->returnData($data);exit;
  504. }
  505. $saveData['operate_dt'] = time();
  506. if ($wordsId){
  507. if ($oldCourseInfo['course_status']==3 || $oldCourseInfo['user_id']!=$this->userId){
  508. //$wordsId = M('Words')->add($saveData);
  509. $wordsOldInfo = M('Words')->where(array('words_id'=>$wordsId,))->field('words_id,words_name')->find();
  510. $wordsNewInfo = M('Words')->where(array('course_id'=>$saveData['course_id'],'words_name'=>$wordsOldInfo['words_name'],))->field('words_id')->find();
  511. M('Words')->where(array('words_id'=>$wordsNewInfo['words_id']))->save($saveData);
  512. $returnWordsId = $wordsNewInfo['words_id'];
  513. }else{
  514. M('Words')->where(array('words_id'=>$wordsId))->save($saveData);
  515. $returnWordsId = $wordsId;
  516. }
  517. //提交审核
  518. if($Type){
  519. if($oldCourseInfo['s_course_id']){
  520. $oldCourseId=$oldCourseInfo['s_course_id'];
  521. $oldCourseInfo = M('Course')->where(array('course_id'=>$oldCourseInfo['s_course_id'],'is_delete'=>1))->field('course_id,user_id,course_name,course_num,course_status,course_source,s_course_id')->find();
  522. $wordsNewInfo = M('Words')->where(array('words_id'=>$wordsId,))->field('*')->find();
  523. if($wordsNewInfo['s_words_id']==0){
  524. $data = array('code'=>1,'msg'=>'原单词不存在');
  525. $this->returnData($data);exit;
  526. }
  527. $wordsId=$wordsNewInfo['s_words_id'];
  528. }
  529. $arr=array();
  530. $wc_text=I('msg','');
  531. $arr['user_id']=$this->userId;
  532. $arr['user_course_id']=$saveData['course_id'];
  533. $arr['course_id']=$oldCourseId;
  534. $arr['user_words_id']=$wordsNewInfo['words_id'];
  535. $arr['words_id']=$wordsId;
  536. $ttt=$saveData;
  537. unset($ttt['course_id']);
  538. $arr['wc_json']=json_encode($ttt);
  539. $arr['wc_text']=$wc_text;
  540. $arr['operate_dt'] = time();
  541. M('words_check')->add($arr);
  542. if($wordsNewInfo['words_id']){
  543. M('Words')->where(array('words_id'=>$wordsNewInfo['words_id']))->save($saveData);
  544. }
  545. $checkinfo=M('words_check')->where($arr)->field('wc_id')->find();
  546. //推送
  547. $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_name')->find();
  548. $temp=array();
  549. $temp['wc_id']=$checkinfo['wc_id'];
  550. $Content="您上传到单词广场的课程《".$oldCourseInfo['course_name']."》,用户".$userInfo['user_name']."提交修改审核,".($wc_text?"并留言:".$wc_text.",":'')."点击直接查看修改内容";
  551. M('Notice')->add(array('ref_user_id'=>$oldCourseInfo['user_id'],'user_id'=>$this->userId,'notice_flag'=>5,'notice_status'=>1,'notice_type'=>0,'notice_title'=>'课程修改审核','notice_content'=>$Content,'operate_dt'=>time(),'extra'=>json_encode($temp)));
  552. M('User')->where(array('user_id'=>$oldCourseInfo['user_id']))->setInc('sys_notice');
  553. $data = json_encode(array('type'=>0,'msg'=>$Content,'data'=>array('title'=>"课程修改审核",'wc_id'=>$checkinfo['wc_id'],'course_id'=>$saveData['course_id'],'words_id'=>$wordsId,'content'=>$Content)));
  554. $this->umengPush($oldCourseInfo['user_id'], $data);
  555. //$data = array('code'=>0,'msg'=>'单词提交审核成功','data'=>array());
  556. //$this->returnData($data);exit;
  557. }
  558. }else{
  559. $wordsId = M('Words')->add($saveData);
  560. $wordsSortInfo = M('WordsSort')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->field('sort_id,word_ids')->find();
  561. if ($wordsSortInfo != NULL){
  562. $wordsSortInfo['word_ids'] = $wordsSortInfo['word_ids'].','.$wordsId;
  563. M('WordsSort')->where(array('sort_id'=>$wordsSortInfo['sort_id']))->save(array('word_ids'=>$wordsSortInfo['word_ids']));
  564. }
  565. M('Course')->where(array('course_id'=>$courseId))->setInc('course_num');
  566. $returnWordsId = $wordsId;
  567. }
  568. //重新计算章节信息
  569. $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
  570. $courseInfo = M('Course')->where(array('course_id'=>$courseId,'is_delete'=>1))->field('course_id,user_id,course_name,course_num,course_status,course_source')->find();
  571. if ($userInfo==NULL || empty($userInfo['user_part'])){
  572. $userPart = 15;
  573. $partNum =ceil($courseInfo['course_num']/15);
  574. }else{
  575. $userPart = $userInfo['user_part'];
  576. $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
  577. }
  578. M('UserWords')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->save(array('part_num'=>$partNum));
  579. $join = 'uw LEFT JOIN t_course c ON uw.course_id=c.course_id';
  580. $resUserWords = M('UserWords')->join($join)->where(array('c.course_id'=>$saveData['course_id'],'uw.user_id'=>$this->userId,))->field('uw.course_id,uw.user_id,course_join,course_num,course_name,uw_id,uw.user_part,uw.part_num')->find();
  581. $resUserWords['words_id'] = $returnWordsId;
  582. $data = array('code'=>0,'msg'=>'单词操作成功','data'=>$resUserWords);
  583. $this->returnData($data);exit;
  584. /* $data = array('code'=>0,'msg'=>'单词操作成功','data'=>array('words_id'=>$wordsId,'course_id'=>$courseId));
  585. $this->returnData($data);exit; */
  586. }
  587. //把其他课程里面的单词添加到指定课程中
  588. public function addWordsToCourse(){
  589. $wordsId = I('words_id');
  590. $courseId = I('course_id');
  591. if (empty($wordsId)){
  592. $data = array('code'=>1,'msg'=>'单词ID错误');
  593. $this->returnData($data);exit;
  594. }
  595. if (empty($courseId) || $courseId<1000000){
  596. $data = array('code'=>1,'msg'=>'课程ID错误');
  597. $this->returnData($data);exit;
  598. }
  599. $wordsInfo = M('Words')->where(array('words_id'=>$wordsId,'is_delete'=>1))->find();
  600. if ($wordsInfo!=NULL && $wordsInfo['course_id']==$courseId){
  601. $data = array('code'=>1,'msg'=>'已是该课程单词');
  602. $this->returnData($data);exit;
  603. }
  604. $wordsCourseInfo = M('Words')->where(array('words_name'=>$wordsInfo['words_name'],'course_id'=>$courseId))->field('words_id')->find();
  605. if ($wordsCourseInfo!=NULL){
  606. $data = array('code'=>1,'msg'=>'已是该课程单词');
  607. $this->returnData($data);exit;
  608. }
  609. $courseInfo = M('Course')->where(array('course_id'=>$courseId,'is_delete'=>1))->field('course_id,user_id,course_name,course_num,course_status,course_source')->find();
  610. if ($courseInfo==NULL){
  611. $data = array('code'=>1,'msg'=>'课程ID错误');
  612. $this->returnData($data);exit;
  613. }
  614. if (in_array($courseInfo['course_name'], array('易错单词','重点单词'))){
  615. $data = array('code'=>1,'msg'=>'不能编辑特殊课程单词');
  616. $this->returnData($data);exit;
  617. }
  618. $oldCourseId = 0;
  619. if ($courseInfo['course_status']==3 || $courseInfo['user_id']!=$this->userId){
  620. //创建新课程,并把就课程里面的所有的单词添加到新创建的课程中
  621. $userCourseInfo = M('Course')->where(array('user_id'=>$this->userId))->field('operate_dt')->find();
  622. if($userCourseInfo!=NULL){
  623. $time = time() - $userCourseInfo['operate_dt'];
  624. if ($time<C('COURSE_TIME')){
  625. $data = array('code'=>1,'msg'=>'3分钟内无法连续创建课程');
  626. $this->returnData($data);exit;
  627. }
  628. }
  629. $oldCourseId = $courseInfo['course_id'];
  630. if ($courseInfo['user_id']==$this->userId){
  631. M('Course')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->save(array('is_show'=>2));
  632. }else if($courseInfo['course_source']==1){
  633. //系统课程
  634. $sysCourse = M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->field('uw_id')->find();
  635. if ($sysCourse==NULL){
  636. $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
  637. if ($userInfo==NULL || empty($userInfo['user_part'])){
  638. $userPart = 15;
  639. $partNum =ceil($courseInfo['course_num']/15);
  640. }else{
  641. $userPart = $userInfo['user_part'];
  642. $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
  643. }
  644. $sysCourseInfo = array(
  645. 'user_id'=>$this->userId,
  646. 'course_id'=>$courseId,
  647. 'user_part'=>$userPart,
  648. 'part_num'=>$partNum,
  649. 'is_show'=>2,
  650. 'operate_dt'=>time(),
  651. );
  652. M('UserWords')->add($sysCourseInfo);
  653. }else{
  654. M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->save(array('is_show'=>2));
  655. }
  656. }
  657. //创建课程
  658. unset($courseInfo['course_id']);
  659. $courseInfo['course_status'] = 1;
  660. $courseInfo['operate_dt'] = time();
  661. $courseInfo['user_id'] = $this->userId;
  662. $courseInfo['course_source']=2;
  663. $courseInfo['course_name'] = $this->getCourseName($courseInfo['course_name']);
  664. $courseId = M('Course')->add($courseInfo);
  665. //复制单词
  666. $this->copyWords($oldCourseId,$courseId);
  667. }
  668. $wordsInfo['operate_dt'] = time();
  669. $wordsInfo['course_id'] = $courseId;
  670. $wordsInfo['words_source'] = 2;
  671. unset($wordsInfo['words_id']);
  672. M('Words')->add($wordsInfo);
  673. M('Course')->where(array('course_id'=>$courseId))->setInc('course_num');
  674. $data = array('code'=>0,'msg'=>'单词添加成功','data'=>'');
  675. if (empty($oldCourseId)){
  676. $data['data']['new_course'] = 0;
  677. }else{
  678. $data['data']['new_course'] = 1;
  679. }
  680. $this->returnData($data);exit;
  681. }
  682. //删除单词
  683. public function del(){
  684. $wordsId = I('words_id');
  685. $courseId = I('course_id');
  686. if (empty($wordsId)){
  687. $data = array('code'=>1,'msg'=>'单词ID错误');
  688. $this->returnData($data);exit;
  689. }
  690. if (empty($courseId) || $courseId<1000000){
  691. $data = array('code'=>1,'msg'=>'课程ID错误');
  692. $this->returnData($data);exit;
  693. }
  694. $wordsInfo = M('Words')->where(array('words_id'=>$wordsId,'is_delete'=>1))->find();
  695. if ($wordsInfo!=NULL && $wordsInfo['course_id']!=$courseId){
  696. $data = array('code'=>1,'msg'=>'不是该课程单词');
  697. $this->returnData($data);exit;
  698. }
  699. $courseInfo = M('Course')->where(array('course_id'=>$courseId,'is_delete'=>1))->field('course_id,user_id,course_name,course_num,course_status,course_source')->find();
  700. if ($courseInfo==NULL){
  701. $data = array('code'=>1,'msg'=>'课程ID错误');
  702. $this->returnData($data);exit;
  703. }
  704. if (in_array($courseInfo['course_name'], array('易错单词','重点单词'))){
  705. $data = array('code'=>1,'msg'=>'不能编辑特殊课程单词');
  706. $this->returnData($data);exit;
  707. }
  708. $oldCourseInfo = $courseInfo;
  709. if ($courseInfo['course_status']==3 || $courseInfo['user_id']!=$this->userId){
  710. //创建新课程,并把就课程里面的所有的单词添加到新创建的课程中
  711. $userCourseInfo = M('Course')->where(array('user_id'=>$this->userId))->field('operate_dt')->find();
  712. if($userCourseInfo!=NULL){
  713. $time = time() - $userCourseInfo['operate_dt'];
  714. if ($time<C('COURSE_TIME')){
  715. $data = array('code'=>1,'msg'=>'3分钟内无法连续创建课程');
  716. $this->returnData($data);exit;
  717. }
  718. }
  719. $oldCourseId = $courseInfo['course_id'];
  720. if ($courseInfo['user_id']==$this->userId){
  721. M('Course')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->save(array('is_show'=>2));
  722. }else if($courseInfo['course_source']==1){
  723. //系统课程
  724. $sysCourse = M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId,'is_show'=>1))->field('uw_id')->find();
  725. if ($sysCourse==NULL){
  726. $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
  727. if ($userInfo==NULL || empty($userInfo['user_part'])){
  728. $userPart = 15;
  729. $partNum =ceil($courseInfo['course_num']/15);
  730. }else{
  731. $userPart = $userInfo['user_part'];
  732. $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
  733. }
  734. $sysCourseInfo = array(
  735. 'user_id'=>$this->userId,
  736. 'course_id'=>$courseId,
  737. 'user_part'=>$userPart,
  738. 'part_num'=>$partNum,
  739. 'is_show'=>2,
  740. 'operate_dt'=>time(),
  741. );
  742. M('UserWords')->add($sysCourseInfo);
  743. }else{
  744. M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->save(array('is_show'=>2));
  745. }
  746. }
  747. //创建课程
  748. unset($courseInfo['course_id']);
  749. $courseInfo['course_status'] = 1;
  750. $courseInfo['operate_dt'] = time();
  751. $courseInfo['user_id'] = $this->userId;
  752. $courseInfo['course_source']=2;
  753. $courseInfo['course_name'] = $courseInfo['course_name'];//$this->getCourseName($courseInfo['course_name']);
  754. $courseId = M('Course')->add($courseInfo);
  755. $userWordsInfo = M('UserWords')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->field('uw_id')->find();
  756. if ($userWordsInfo==NULL){
  757. $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
  758. if ($userInfo==NULL || empty($userInfo['user_part'])){
  759. $userPart = 15;
  760. $partNum =ceil($courseInfo['course_num']/15);
  761. }else{
  762. $userPart = $userInfo['user_part'];
  763. $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
  764. }
  765. $userOldWordsInfo = M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->field('current_course')->find();
  766. $saveCourseWordsInfo = array(
  767. 'user_id'=>$this->userId,
  768. 'course_id'=>$courseId,
  769. 'user_part'=>$userPart,
  770. 'part_num'=>$partNum,
  771. 'operate_dt'=>time(),
  772. );
  773. if ($userOldWordsInfo!=NULL && $userOldWordsInfo['current_course']==2){
  774. $saveCourseWordsInfo['current_course'] = 2;
  775. }
  776. M('UserWords')->add($saveCourseWordsInfo);
  777. }else{
  778. M('UserWords')->where(array('uw_id'=>$userWordsInfo['uw_id']))->save(array('course_id'=>$courseId));
  779. //M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->save(array('course_id'=>$courseId));
  780. }
  781. //复制单词
  782. $this->copyWords($oldCourseId,$courseId,$wordsId);
  783. }else{
  784. $userWordsInfo = M('UserWords')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->field('uw_id')->find();
  785. if ($userWordsInfo==NULL){
  786. $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
  787. if ($userInfo==NULL || empty($userInfo['user_part'])){
  788. $userPart = 15;
  789. $partNum =ceil($courseInfo['course_num']/15);
  790. }else{
  791. $userPart = $userInfo['user_part'];
  792. $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
  793. }
  794. $saveCourseWordsInfo = array(
  795. 'user_id'=>$this->userId,
  796. 'course_id'=>$courseId,
  797. 'user_part'=>$userPart,
  798. 'part_num'=>$partNum,
  799. 'operate_dt'=>time(),
  800. );
  801. M('UserWords')->add($saveCourseWordsInfo);
  802. }
  803. M('Words')->where(array('words_id'=>array('IN',$wordsId)))->delete();
  804. }
  805. $wordsIdArr = explode(',', $wordsId);
  806. $num = count($wordsIdArr);
  807. M('Course')->where(array('course_id'=>$courseId))->setDec('course_num',$num);
  808. $wordsSortInfo = M('WordsSort')->where(array('course_id'=>$oldCourseInfo['course_id'],'user_id'=>$this->userId))->field('sort_id,word_ids')->find();
  809. if ($wordsSortInfo != NULL){
  810. $wordsSortIdArr = explode(',', $wordsSortInfo['word_ids']);
  811. $wordsSortInfo['word_ids'] = array_shift($wordsSortIdArr,$wordsIdArr);
  812. M('WordsSort')->where(array('sort_id'=>$wordsSortInfo['sort_id']))->save(array('word_ids'=>$wordsSortInfo['word_ids']));
  813. }
  814. //重新计算章节信息
  815. $userWordsInfo = M('UserWords')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->field('uw_id')->find();
  816. $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
  817. $courseInfo = M('Course')->where(array('course_id'=>$courseId,'is_delete'=>1))->field('course_id,user_id,course_name,course_num,course_status,course_source')->find();
  818. if ($userInfo==NULL || empty($userInfo['user_part'])){
  819. $userPart = 15;
  820. $partNum =ceil($courseInfo['course_num']/15);
  821. }else{
  822. $userPart = $userInfo['user_part'];
  823. $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
  824. }
  825. M('UserWords')->where(array('uw_id'=>$userWordsInfo['uw_id']))->save(array('part_num'=>$partNum));
  826. $join = 'uw LEFT JOIN t_course c ON uw.course_id=c.course_id';
  827. $resUserWords = M('UserWords')->join($join)->where(array('c.course_id'=>$courseId,'uw.user_id'=>$this->userId,))->field('uw.course_id,uw.user_id,course_join,course_num,course_name,uw_id,uw.user_part,uw.part_num')->find();
  828. $data = array('code'=>0,'msg'=>'单词删除成功','data'=>$resUserWords);
  829. $this->returnData($data);exit;
  830. /*$data = array('code'=>0,'msg'=>'单词删除成功','data'=>'');
  831. $this->returnData($data);exit;*/
  832. }
  833. //添加单词笔记
  834. public function notepad(){
  835. $wordsId = I('words_id');
  836. $courseId = I('course_id');
  837. $wnContent = I('wn_content');
  838. if(empty($wordsId)){
  839. $data = array('code'=>1,'msg'=>'单词ID错误');
  840. $this->returnData($data);exit;
  841. }
  842. if(empty($courseId)){
  843. $data = array('code'=>1,'msg'=>'课程ID错误');
  844. $this->returnData($data);exit;
  845. }
  846. if (mb_strlen($wnContent,'UTF8')<2 || mb_strlen($wnContent,'UTF8')>300){
  847. $data = array('code'=>1,'msg'=>'单词笔记2到300个汉字');
  848. $this->returnData($data);exit;
  849. }
  850. $res = M('WordsNotepad')->where(array('words_id'=>$wordsId,'user_id'=>$this->userId))->field('wn_id')->find();
  851. if ($res==NULL){
  852. $saveData = array('user_id'=>$this->userId,'words_id'=>$wordsId,'course_id'=>$courseId,'wn_content'=>$wnContent,'operate_dt'=>time());
  853. $wnId = M('WordsNotepad')->add($saveData);
  854. $msg = '单词笔记添加成功';
  855. }else{
  856. $wnId = $res['wn_id'];
  857. M('WordsNotepad')->where(array('wn_id'=>$wnId))->save(array('wn_content'=>$wnContent));
  858. $msg = '单词笔记修改成功';
  859. }
  860. $info = M('WordsNotepad')->where(array('wn_id'=>$wnId))->field('user_id,words_id,course_id,wn_content')->find();
  861. $data = array('code'=>0,'msg'=>$msg,'data'=>$info);
  862. $this->returnData($data);exit;
  863. }
  864. //添加错误单词到易错单词课程中
  865. private function addErrorWords($wordsId){
  866. $wordsId = rtrim(I('words_id'),',');
  867. if (empty($wordsId)){
  868. return false;
  869. }
  870. $courseInfo = M('Course')->where(array('user_id'=>$this->userId,'course_name'=>'易错单词','course_flag'=>1))->field('course_id,course_name')->find();
  871. if ($courseInfo==NULL){
  872. $courseId = M('Course')->add(array('course_type'=>0,'course_name'=>'易错单词','course_source'=>2,'user_id'=>$this->userId,'operate_dt'=>time()));
  873. }else if($courseInfo['course_name']=='易错单词'){
  874. return false;
  875. }else{
  876. $courseId = $courseInfo['course_id'];
  877. }
  878. $wordsList = M('Words')->where(array('words_id'=>array('IN',$wordsId),'is_delete'=>1))->order('words_id asc')->select();
  879. //var_dump($wordsList);exit;
  880. foreach ($wordsList as $words){
  881. unset($words['words_id']);
  882. $words['course_id'] = $courseId;
  883. $words['words_source'] = 2;
  884. //$words['operate_dt'] = time();
  885. $words['operate_dt'] = strtotime(date('Y-m-d'));
  886. M('Words')->add($words);
  887. }
  888. return false;
  889. }
  890. //测试模式上报
  891. public function test(){
  892. $testType = I('test_type');
  893. $wordsId = rtrim(I('words_id'),',');
  894. //$wordsTotal = I('words_total');
  895. $wordsError = rtrim(I('words_error'),',');
  896. //$wordsSuccess = rtrim(I('words_success'));
  897. //$testNum = I('test_num');
  898. //$testScore = I('test_score');
  899. if (!in_array($testType, array(1,2,3,4,5,6))){
  900. $data = array('code'=>1,'msg'=>'测试模式错误');
  901. $this->returnData($data);exit;
  902. }
  903. if (empty($wordsId)){
  904. $data = array('code'=>1,'msg'=>'测试单词id错误');
  905. $this->returnData($data);exit;
  906. }
  907. $wordsTotal = substr_count($wordsId,',')+1;
  908. if (empty($wordsError)){
  909. $wordsErrLen = 0;
  910. }else{
  911. $wordsErrLen = substr_count($wordsError,',')+1;
  912. }
  913. $wordsSucLen = $wordsTotal-$wordsErrLen;
  914. $score = round($wordsSucLen/$wordsTotal*100);
  915. $wordsIdArr = explode(',', $wordsId);
  916. $wordsErrorArr = explode(',', $wordsError);
  917. $wordsSuccess = implode(',', array_diff($wordsIdArr, $wordsErrorArr));
  918. //var_dump($wordsId,$wordsError,$wordsSuccess,$wordsSucLen,$wordsTotal);exit;
  919. $saveData = array(
  920. 'user_id'=>$this->userId,'test_type'=>$testType,'words_ids'=>$wordsId,
  921. 'words_total'=>$wordsTotal,'words_error'=>$wordsError,'words_success'=>$wordsSuccess,
  922. 'test_num'=>$wordsTotal,'test_score'=>$score,'operate_dt'=>time(),
  923. );
  924. M('Test')->add($saveData);
  925. $this->addErrorWords($wordsError);
  926. $data = array('code'=>0,'msg'=>'单词测试上报成功','data'=>array('score'=>$score));
  927. $this->returnData($data);exit;
  928. }
  929. //获取单词信息接口
  930. public function dict(){
  931. $wordsName = I('words_name','');
  932. if (empty($wordsName)){
  933. $data = array('code'=>1,'msg'=>'单词不能为空');
  934. $this->returnData($data);exit;
  935. }
  936. $wordsKeys = array('n'=>'words_n','pron'=>'words_pron','adj'=>'words_adj','num'=>'words_num','v'=>'words_v','adv'=>'words_adv','art'=>'words_art','prep'=>'words_prep','conj'=>'words_conj','int'=>'words_int','vt'=>'words_vt','vi'=>'words_vi',);
  937. $httpCurl = new \Org\Net\HttpCurl();
  938. $url = C('TRANS').'&w='.$wordsName;
  939. $res = $httpCurl->get($url,'xml');
  940. $res = json_decode(json_encode(simplexml_load_string($res, 'SimpleXMLElement', LIBXML_NOCDATA)), true);
  941. /* $url = C('TRANS').'&type=json&w='.$wordsName;
  942. $res = $httpCurl->get($url); */
  943. if (!isset($res['key'])){
  944. $data = array('code'=>1,'msg'=>'单词翻译出错');
  945. echo json_encode($data);
  946. }
  947. $saveData = array();
  948. if (isset($res['ps'])){
  949. if (is_array($res['ps'])){
  950. for ($i=0;$i<count($res['ps']);$i++){
  951. $j = $i+1;
  952. $saveData['words_read'.$j] = $res['ps'][$i];
  953. $saveData['words_voice'.$j] = $res['pron'][$i];
  954. }
  955. }else{
  956. $saveData['words_read1'] = $res['ps'];
  957. $saveData['words_voice1'] = $res['pron'];
  958. }
  959. }else{
  960. $saveData['words_read1'] = '';
  961. $saveData['words_voice1'] = '';
  962. }
  963. if (isset($res['pos'])){
  964. if (is_array($res['pos'])){
  965. foreach ($res['pos'] as $k=>$v){
  966. if (isset($wordsKeys[str_replace('.', '', $v)])){
  967. $saveData[$wordsKeys[str_replace('.', '', $v)]] = trim($res['acceptation'][$k]);
  968. }
  969. }
  970. }else{
  971. if (isset($wordsKeys[str_replace('.', '', $res['pos'])])){
  972. $saveData[$wordsKeys[str_replace('.', '', $res['pos'])]] = trim($res['acceptation']);
  973. }else{
  974. $saveData['words_other'] = trim($res['acceptation']);
  975. }
  976. }
  977. }
  978. if (isset($res['sent'])){
  979. for ($i=0;$i<count($res['sent']);$i++){
  980. $j = $i+1;
  981. if ($j>3){
  982. continue;
  983. }
  984. $saveData['jz_en'.$j] = trim($res['sent'][$i]['orig']);
  985. $saveData['jz_cn'.$j] = trim($res['sent'][$i]['trans']);
  986. }
  987. }
  988. $data = array('code'=>0,'msg'=>'','data'=>$saveData);
  989. $this->returnData($data);exit;
  990. }
  991. //删除单词笔记
  992. public function delNote(){
  993. $wordsId = I('words_id','');
  994. if (empty($wordsId)){
  995. $data = array('code'=>1,'msg'=>'单词ID出错');
  996. echo json_encode($data);
  997. }
  998. M('WordsNotepad')->where(array('words_id'=>$wordsId,'user_id'=>$this->userId))->delete();
  999. $data = array('code'=>0,'msg'=>'删除成功','data'=>'');
  1000. $this->returnData($data);exit;
  1001. }
  1002. //单词乱序
  1003. public function sort(){
  1004. $courseId = I('course_id');
  1005. if (empty($courseId) || $courseId<1000000){
  1006. $data = array('code'=>1,'msg'=>'课程ID错误');
  1007. $this->returnData($data);exit;
  1008. }
  1009. //1:乱序,0:取消乱序
  1010. $type = I('type',1);
  1011. if (!in_array($type, array(0,1))){
  1012. $data = array('code'=>0,'msg'=>'类型错误');
  1013. $this->returnData($data);exit;
  1014. }
  1015. $info = M('WordsSort')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->find();
  1016. if ($type==1){
  1017. if ($info!=NULL){
  1018. if ($info['sort_status']==2){
  1019. M('WordsSort')->where(array('sort_id'=>$info['sort_id']))->save(array('sort_status'=>1));
  1020. }
  1021. $data = array('code'=>0,'msg'=>'设置乱序成功');
  1022. echo json_encode($data);
  1023. }else{
  1024. $wordsInfo = M('Words')->where(array('course_id'=>$courseId))->order('RAND()')->field('words_id')->select();
  1025. if (function_exists('array_column')){
  1026. $wordsIdArr = array_column($wordsInfo, 'words_id');
  1027. }else{
  1028. foreach ($wordsInfo as $row){
  1029. $wordsIdArr[] = $row['words_id'];
  1030. }
  1031. }
  1032. $saveData = array(
  1033. 'user_id'=>$this->userId,
  1034. 'course_id'=>$courseId,
  1035. 'word_ids'=>implode(',', $wordsIdArr),
  1036. 'operate_dt'=>time(),
  1037. );
  1038. M('WordsSort')->add($saveData);
  1039. $data = array('code'=>0,'msg'=>'设置乱序成功');
  1040. echo json_encode($data);
  1041. }
  1042. }else if($type==0){
  1043. if ($info==NULL){
  1044. $data = array('code'=>0,'msg'=>'设置默认排序成功');
  1045. $this->returnData($data);exit;
  1046. }else{
  1047. M('WordsSort')->where(array('sort_id'=>$info['sort_id']))->save(array('sort_status'=>2));
  1048. $data = array('code'=>0,'msg'=>'设置默认排序成功');
  1049. $this->returnData($data);exit;
  1050. }
  1051. }
  1052. }
  1053. //添加重点单词课程
  1054. public function addImportantWords(){
  1055. $wordsId = rtrim(I('words_id'),',');
  1056. if (empty($wordsId)){
  1057. return false;
  1058. }
  1059. $courseInfo = M('Course')->where(array('user_id'=>$this->userId,'course_name'=>'重点单词','course_flag'=>1))->field('course_id')->find();
  1060. if ($courseInfo==NULL){
  1061. $courseId = M('Course')->add(array('course_type'=>0,'course_name'=>'重点单词','course_source'=>2,'user_id'=>$this->userId,'operate_dt'=>time()));
  1062. }else{
  1063. $courseId = $courseInfo['course_id'];
  1064. }
  1065. $wordsList = M('Words')->where(array('words_id'=>array('IN',$wordsId),'is_delete'=>1))->order('words_id asc')->select();
  1066. foreach ($wordsList as $words){
  1067. $wordsInfo = M('Words')->where(array('words_name'=>$words['words_name'],'course_id'=>$courseId))->field('words_id')->find();
  1068. if ($wordsInfo){
  1069. continue;
  1070. }
  1071. unset($words['words_id']);
  1072. $words['course_id'] = $courseId;
  1073. $words['words_source'] = 2;
  1074. $words['operate_dt'] = strtotime(date('Y-m-d'));
  1075. M('Words')->add($words);
  1076. M('Course')->where(array('course_id'=>$courseId))->setInc('course_num');
  1077. }
  1078. $data = array('code'=>0,'msg'=>'添加成功');
  1079. $this->returnData($data);exit;
  1080. }
  1081. //获得单词审核信息
  1082. public function check_info(){
  1083. $words_id = I('words_id','0');
  1084. $course_id = I('course_id','0');
  1085. $wc_id = I('wc_id','0');
  1086. if($wc_id||($words_id&&$course_id)){
  1087. }else{
  1088. return;
  1089. }
  1090. $where=array();
  1091. if($wc_id){
  1092. $where['wc_id']=$wc_id;
  1093. }else{
  1094. $where['course_id']=$course_id;
  1095. $where['words_id']=$words_id;
  1096. }
  1097. $checkinfo = M('words_check')->where($where)->field('*')->select();
  1098. if ($checkinfo==NULL){
  1099. $data = array('code'=>1,'msg'=>'获取信息错误');
  1100. $this->returnData($data);exit;
  1101. }
  1102. $data = array('code'=>0,'msg'=>'信息获取成功','data'=>$checkinfo);
  1103. $this->returnData($data);exit;
  1104. }
  1105. //审核数量
  1106. public function check_num(){
  1107. $words_id = I('words_id','0');
  1108. $course_id = I('course_id','0');
  1109. if($words_id&&$course_id){
  1110. }else{
  1111. return;
  1112. }
  1113. $where=array();
  1114. $where['course_id']=$course_id;
  1115. $where['words_id']=$words_id;
  1116. $where['wc']=$words_id;
  1117. $checkinfo = M('words_check')->where("course_id=".$course_id." and words_id=".$words_id." and wc_status=0")->field('count(*) as num')->find();
  1118. if ($checkinfo==NULL){
  1119. $data = array('code'=>1,'msg'=>'获取信息错误');
  1120. $this->returnData($data);exit;
  1121. }
  1122. $data = array('code'=>0,'msg'=>'信息获取成功','data'=>$checkinfo);
  1123. $this->returnData($data);exit;
  1124. }
  1125. //审核信息
  1126. public function check_done(){
  1127. $wc_id = I('wc_id','0');
  1128. $wc_status = I('wc_status','0');
  1129. $wc_content = I('wc_content','');
  1130. if(!$wc_id||!$wc_status){
  1131. $data = array('code'=>1,'msg'=>'传参错误');
  1132. $this->returnData($data);exit;
  1133. }
  1134. $checkinfo = M('words_check')->where(array('wc_id'=>$wc_id))->field('*')->find();
  1135. if ($checkinfo==NULL){
  1136. $data = array('code'=>1,'msg'=>'获取信息错误');
  1137. $this->returnData($data);exit;
  1138. }
  1139. M('words_check')->where(array('wc_id'=>$wc_id))->save(array('wc_status'=>$wc_status,'wc_content'=>$wc_content));
  1140. $saveData=json_decode($checkinfo['wc_json'],1);
  1141. $courseInfo = M('Course')->where(array('course_id'=>$checkinfo['course_id'],'is_delete'=>1))->field('course_id,user_id,course_name,course_num,course_status,course_source')->find();
  1142. if($wc_status==1){
  1143. if($checkinfo['words_id']){
  1144. M('Words')->where(array('words_id'=>$checkinfo['words_id']))->save($saveData);
  1145. }
  1146. $Content="亲爱的小主,您提交的关于课程《".$courseInfo['course_name']."》的修改,作者已同意修改,并已更新课程内容";
  1147. $temp=array();
  1148. $temp['wc_id']=$checkinfo['wc_id'];
  1149. M('Notice')->add(array('ref_user_id'=>$checkinfo['user_id'],'user_id'=>$this->userId,'notice_flag'=>6,'notice_status'=>1,'notice_type'=>0,'notice_title'=>'课程修改审核通过','notice_content'=>$Content,'operate_dt'=>time(),'extra'=>json_encode($temp)));
  1150. M('User')->where(array('user_id'=>$checkinfo['user_id']))->setInc('sys_notice');
  1151. $data = json_encode(array('type'=>0,'msg'=>$Content,'data'=>array('title'=>"课程修改审核通过",'wc_id'=>$checkinfo['wc_id'],'course_id'=>$saveData['course_id'],'words_id'=>$saveData['words_id'],'content'=>$Content)));
  1152. $this->umengPush($checkinfo['user_id'], $data);
  1153. }else{
  1154. $Content="亲爱的小主,您提交的关于课程《".$courseInfo['course_name']."》的修改,作者拒绝修改,拒绝原因:".$wc_content;
  1155. $temp=array();
  1156. $temp['wc_id']=$checkinfo['wc_id'];
  1157. M('Notice')->add(array('ref_user_id'=>$checkinfo['user_id'],'user_id'=>$this->userId,'notice_flag'=>7,'notice_status'=>1,'notice_type'=>0,'notice_title'=>'课程修改审核不通过','notice_content'=>$Content,'operate_dt'=>time(),'extra'=>json_encode($temp)));
  1158. M('User')->where(array('user_id'=>$checkinfo['user_id']))->setInc('sys_notice');
  1159. $data = json_encode(array('type'=>0,'msg'=>$Content,'data'=>array('title'=>"课程修改审核不通过",'wc_id'=>$checkinfo['wc_id'],'course_id'=>$saveData['course_id'],'words_id'=>$saveData['words_id'],'content'=>$Content)));
  1160. $this->umengPush($checkinfo['user_id'], $data);
  1161. }
  1162. $data = array('code'=>0,'msg'=>'审核成功','data'=>array());
  1163. $this->returnData($data);exit;
  1164. }
  1165. //获得单词审核信息
  1166. public function words_info(){
  1167. $words_id = I('words_id','0');
  1168. $course_id = I('course_id','0');
  1169. if(($words_id&&$course_id)){
  1170. }else{
  1171. return;
  1172. }
  1173. $where=array();
  1174. $where['course_id']=$course_id;
  1175. $where['words_id']=$words_id;
  1176. $checkinfo = M('Words')->where($where)->field('*')->select();
  1177. if ($checkinfo==NULL){
  1178. $data = array('code'=>1,'msg'=>'获取信息错误');
  1179. $this->returnData($data);exit;
  1180. }
  1181. $data = array('code'=>0,'msg'=>'信息获取成功','data'=>$checkinfo);
  1182. $this->returnData($data);exit;
  1183. }
  1184. }