# 同步課程 #  ## 用戶同步課程教材列表 http://t.wmxuetang.com/index.php?r=teachCourse/default/bookshelf ### 表 wkwke.tbTeachCourse 同步課程教材列表 ``` CREATE TABLE `tbTeachCourse` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdUserID` int(11) NOT NULL COMMENT '用戶ID', `fdTagID` int(11) NOT NULL COMMENT '教材ID', `fdSubjectID` int(11) NOT NULL COMMENT '科目ID', `fdSchoolTypeID` int(11) NOT NULL COMMENT '學段ID', `fdStatus` tinyint(4) DEFAULT NULL, `fdExpire` datetime DEFAULT NULL COMMENT '過期時間', `fdCreate` datetime NOT NULL, PRIMARY KEY (`id`), KEY `fdUserID` (`fdUserID`,`fdTagID`,`fdSubjectID`) ) ENGINE=MyISAM AUTO_INCREMENT=3869 DEFAULT CHARSET=utf8 COMMENT='同步課程'; ``` ### 表 wkwke.tbTeachCourseSche 章節、知識點進度表 ``` CREATE TABLE `tbTeachCourseSche` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdTeachCourseID` int(11) NOT NULL COMMENT '課程ID', `fdTagID` int(11) DEFAULT '0' COMMENT '教材章節ID', `fdPointID` int(11) DEFAULT '0' COMMENT '知識點ID', `fdStarNum` int(11) DEFAULT '0' COMMENT '獲得星星數', `fdCoinNum` int(11) DEFAULT '0' COMMENT '獲得學幣數', `fdCurrent` int(11) DEFAULT '0' COMMENT '最后更新時間戳', `fdType` tinyint(4) DEFAULT '0' COMMENT '類型 1:教材章節 2:知識點 3:單元測試', `fdParentID` int(11) DEFAULT '0', `fdFinish` tinyint(2) NOT NULL DEFAULT '0' COMMENT '0未完成,1已完成', PRIMARY KEY (`id`), KEY `fdTeachCourseID` (`fdTeachCourseID`,`fdTagID`) ) ENGINE=MyISAM AUTO_INCREMENT=18754 DEFAULT CHARSET=utf8 COMMENT='同步課程學習進度'; ``` ### 表 wkwke.tbTeachCourseRecord 同步課程學習記錄 ``` CREATE TABLE `tbTeachCourseRecord` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fdTeachCourseID` int(11) NOT NULL COMMENT '課程ID', `fdTagID` int(11) NOT NULL DEFAULT '0' COMMENT '章節ID', `fdPointID` int(11) NOT NULL DEFAULT '0' COMMENT '知識點ID', `fdAeid` int(11) DEFAULT '0' COMMENT '答卷ID', `fdScore` float NOT NULL DEFAULT '0' COMMENT '試卷得分', `fdScoreRate` float NOT NULL DEFAULT '0', `fdUsed` int(11) NOT NULL DEFAULT '0', `fdDifficulty` tinyint(4) DEFAULT '0' COMMENT '答題難度', `fdStatus` tinyint(4) DEFAULT '0' COMMENT '是否交卷', `fdPass` tinyint(4) DEFAULT '0' COMMENT '是否通關', `fdType` tinyint(4) DEFAULT '0' COMMENT '答題類型 2:知識點 3:單元測', `fdTeachCourseScheID` int(11) NOT NULL COMMENT '學習進度ID', PRIMARY KEY (`id`), KEY `fdTeachCourseID` (`fdTeachCourseID`,`fdTagID`,`fdPointID`) ) ENGINE=MyISAM AUTO_INCREMENT=63615 DEFAULT CHARSET=utf8 COMMENT='同步課程學習記錄'; ``` ## 獲取教材列表 http://t.wmxuetang.com/index.php?r=teachCourse/default/getTeachCourse  ### code ``` /** * 獲取同步課程 * @author: pengjch 18-7-9 下午2:26 */ public function actionGetTeachCourse(){ $args['userID'] = Yii::app()->user->id; $args['status'] = WK::CNT_ENABLE; $args['order'] = 't.id ASC'; $args['with'] = array('tag','tag.version'); $teachCourses = TeachCourseService::factory()->getTeachCourses($args); $datas = TeachCourseService::factory()->countUserStarAndCoin(Yii::app()->user->id); $datas['list'] = array(); if($teachCourses){ foreach ($teachCourses as $teachCourse){ $cover = RelevanceService::factory()->getTextbookCover($teachCourse->fdTagID); $versionObject = wkeVersion::model()->findByPk($teachCourse->tag->version->fdValue); $item = array(); $item['id'] = $teachCourse->id; $item['version'] = $versionObject->fdName; $item['subjectID'] = (int)$teachCourse->fdSubjectID; $item['subjectName'] = Yii::app()->params['SUBJECT_ARR'][$teachCourse->fdSubjectID]; $item['textBookID'] = (int)$teachCourse->fdTagID; $item['textBookName'] = $teachCourse->tag->fdName; $item['expire'] = strtotime($teachCourse->fdExpire)*1000; $item['expireStatus'] = $teachCourse->fdExpire ? (time() > strtotime($teachCourse->fdExpire) ? 1 : 0) : 2; //0未到期 1已到期 2未購買 $item['cover'] = $cover; $datas['list'][] = $item; } } ResponseUtils::json(array('data'=>$datas),0,"success"); } ``` *****