# 新增“教學總結”
## 新增“教學總結”功能
“教學總結”的功能點與“教學計劃”完全一樣，只是名字不同而已
## 教學計劃分析
http://ketang.test/index.php?r=teachingV3/teachingPlan
*D:\wamp\www\ketang.test\weike\protected\modules\teachingV3\controllers\TeachingPlanController.php*
```
public function actionIndex(){
$uid = Yii::app()->user->id;
$schoolMap = UserService::factory()->getSchoolMapByUserID($uid);
if(!$schoolMap)
$this->redirect_msgBox('/',array('msg'=>'請先設置所屬學校'));
$termList = V3SystemService::factory()->getSchoolTermList($schoolMap->fdSchoolID);
if(Yii::app()->user->fdTypeID == WK::TEACHER_TYPE_ID){
$userInfo = $this->_getUserGradeAndSubject($uid);
if(array_filter(array_unique($userInfo['grade']))){
$grades = array_intersect_key(Yii::app()->params['GRADE_LIST'],array_flip(array_filter(array_unique($userInfo['grade']))));
}else{
$grades = array();
}
if(array_filter(array_unique($userInfo['subject']))){
$subjects = array_intersect_key(Yii::app()->params['SUBJECT_ARR'],array_flip(array_filter(array_unique($userInfo['subject']))));;
}else{
$subjects = array();
}
}else{
$classMaps = ClassService::factory()->getAllClassByUserID($uid);
if($classMaps){
foreach ($classMaps as $classMap){
$grade[] = $classMap->fdGradeID;
}
}else{
$this->redirect_msgBox('/',array('msg'=>'請先加入班級'));
}
$grades = array_intersect_key(Yii::app()->params['GRADE_LIST'],array_flip($grade));
$subjects = Yii::app()->params['SUBJECT_ARR'];
}
$timestamp = time()*1000;
$this->render('index',array('data'=>CJSON::encode(array('termList'=>$termList,'grades'=>$grades,'subjects'=>$subjects,'timestamp'=>$timestamp))));
}
```
http://ketang.test/index.php?r=teachingV3/teachingPlan/GetPlanList&termID=&gradeID=&subjectID=&start=0&len=10&type=1
```
public function actionGetPlanList()
{
$params = RequestUtils::requestToArray(true);
$userID = Yii::app()->user->id;
$userInfo = $this->_getUserGradeAndSubject($userID);
if(Yii::app()->user->fdTypeID == WK::TEACHER_TYPE_ID){
$args['userID'] = $userID;
$args['subject'] = $params['subjectID']?:$userInfo['subject'];
}elseif(Yii::app()->user->fdTypeID == WK::STUDENT_TYPE_ID){
$args['userID'] = $userID;
$args['subject'] = $params['subjectID'];
}else{
$type = null;
$args['subject'] = $params['subjectID'];
}
$args['gradeID'] = $params['gradeID']?:$userInfo['grade'];
// $type = null;
$schoolMap = UserService::factory()->getSchoolMapByUserID($userID);
if(!$schoolMap)
ResponseUtils::json(null,21,"學校未設置");
$args['type'] = $params['type'];
$args['termID'] = $params['termID'];
$args['schoolID'] = $schoolMap->fdSchoolID;
$args['permission'] = $params['type'] == 0 ? WK::SHARING_OPEN : null;
$args['disabled'] = WK::CNT_ENABLE;
$count = PlanningService::factory()->countPlannings($args);
$args['length'] = $params['len']?:10;
$args['start'] = $params['start']?:0;
$plans = PlanningService::factory()->getPlannings($args);
$planData['list'] = $this->_getPlanData($plans);
$planData['total'] = $count;
ResponseUtils::json(array('data'=>$planData));
}
```
### 獲取教學計劃列表的criteria
```php
/**
* 獲取教學計劃列表的criteria
* @param array $args;
* $args['userID'] 老師ID
* $args['type'] 1:userID的原創 2:userID的收藏
* $args['startTime'] 開始時間
* $args['endTime'] 結束時間
* $args['length'] 獲取條目個數
* $args['start'] 開始的下標
* $args['keyword'] 關鍵字
* $args['seek'] （array）篩選條件
* $author Liuzhiqiang 2014年1月2日
*/
public function findPlannings($args)
{
$criteria = new CDbCriteria();
$withArr = array();
$criteria->alias = 'planing'; // 別名
CDbUtils::addCondition($criteria,"planing.id",$args['id']);
if ($args['keyword']) {
$criteria->addSearchCondition('planing.fdName',$args['keyword'],true); //支持模糊查找
$criteria->addSearchCondition("mainUser.fdRealName", $args['keyword'],true,'OR');
}
CDbUtils::addCondition($criteria,"planing.fdDisabled",$args['disabled']);
if ($args['type']) {
if ($args['type'] == 1) { //需用常量表示
$withArr[] = 'mainContribute';
$criteria->addCondition('mainContribute.fdUserID =' . $args['userID']);
} elseif ($args['type'] == 2) {
$withArr['favourite'] = array("together" => true);
$criteria->addCondition('favourite.fdUserID =' . $args['userID']);
}
}
if($args['textbook']){//教材
$withArr[] = 'textbook';
CDbUtils::addCondition($criteria,"textbook.fdValue",$args['textbook']);
}else if($args['version']){//版本
$withArr[] = 'version';
CDbUtils::addCondition($criteria,"version.fdValue",$args['version']);
}else{
if($args['schoolType']){//學段
$withArr[] = 'schoolType';
CDbUtils::addCondition($criteria,"schoolType.fdValue",$args['schoolType']);
}
if($args['subject']){//科目
$withArr[] = 'subtype';
CDbUtils::addCondition($criteria,"subtype.fdValue",$args['subject']);
}
}
if($args['gradeID']){//年級
$withArr[] = 'grdtype';
CDbUtils::addCondition($criteria,"grdtype.fdValue",$args['gradeID']);
}
if($args['termID']){//學期
$withArr[] = 'termtype';
CDbUtils::addCondition($criteria,"termtype.fdValue",$args['termID']);
}
if(isset($args['permission'])){//查看權限
$withArr[] = 'mainContribute';
CDbUtils::addCondition($criteria,"mainContribute.fdPermission",$args['permission']);
}
if(isset($args['schoolID'])){//查看權限
$withArr[] = 'mainUser.schoolMap';
CDbUtils::addCondition($criteria,"schoolMap.fdSchoolID",$args['schoolID']);
}
if($args['classes']){
$withArr[] = 'planningClass';
CDbUtils::addCondition($criteria,"planningClass.fdValue",$args['classes']);
}
if($args['length']){
$criteria->limit = $args['length'];
}
if($args['start']){
$criteria->offset = $args['start'];
}
if($args['timeStart']){
$criteria->addCondition("planing.fdCreate>=:start");
$criteria->params[":start"] = $args['timeStart'];
}
if($args['timeEnd']){
$criteria->addCondition("planing.fdCreate<:end");
$criteria->params[":end"] = $args['timeEnd'];
}
$criteria->addCondition('planing.fdTypeID =' . WK::PLAN_TYPE_ID); // 常量29
$criteria->order = 'UNIX_TIMESTAMP(planing.fdCreate) desc'; // 按創建的時間戳排序
$criteria->with = array_unique($withArr);
$criteria->group = 'planing.id';
return $criteria;
}
```
### D:\wamp\www\ketang.test\weike\protected\models\content\Content.php
```php
public function relations()
{
// NOTE: you may need to adjust the relation name and the related
// class name for the relations automatically generated below.
return array(
'contributes' => array(self::BELONGS_TO, 'Contribute', '', 'on' => 't.id=contributes.fdContentID', 'select' => array('contributes.fdContentID', 'contributes.fdUserID', 'contributes.fdStatus')),
'users' => array(self::BELONGS_TO, 'User', '', 'on' => 'users.id=contributes.fdUserID', 'select' => array('users.id', 'users.fdLogin', 'users.fdCardID', 'users.fdTypeID', 'users.fdName','users.fdRealName')),
//題目難度指數
'diff' => array(self::HAS_ONE, 'Integer', 'fdContentID', 'on' => 'diff.fdAttributeID=' . WK::DIFF_ATTR_ID, 'select' => array('diff.fdValue')),
//標簽
'tags' => array(self::HAS_MANY, 'Text', 'fdContentID', 'on' => 'tags.fdAttributeID=' . WK::TAG_ATTR_ID, 'order' => 'tags.id', 'select' => array('tags.id', 'tags.fdValue')),
//簡介
'intro' => array(self::HAS_ONE, 'Blob', 'fdContentID', 'on' => 'intro.fdAttributeID=' . WK::SUMMARY_ATTR_ID, 'select' => array('intro.fdValue')),
//@Deprecated 學段
'schtype' => array(self::HAS_ONE, 'Integer', 'fdContentID', 'on' => 'schtype.fdAttributeID=' . WK::SECTION_ATTR_ID, 'select' => array('schtype.fdValue')),
//科目
'subtype' => array(self::HAS_ONE, 'Integer', 'fdContentID', 'on' => 'subtype.fdAttributeID=' . WK::SUJT_ATTR_ID, 'select' => array('subtype.fdValue')),
//學期 add by zhangjsh 2013-8-2
'termtype' => array(self::HAS_ONE, 'Integer', 'fdContentID', 'condition' => 'termtype.fdAttributeID=' . WK::TERM_ATTR_ID, 'select' => array('termtype.fdValue')),
//知識點
'knowtype' => array(self::HAS_MANY, 'Integer', 'fdContentID', 'condition' => 't.fdAttributeID=' . WK::KONW_ATTR_ID, 'select' => array('t.fdValue'), 'alias' => 't', 'with' => array('tag'), 'order' => 't.id asc'),
'knowTypes' => array(self::HAS_MANY, 'Integer', 'fdContentID', 'condition' => 'knowTypes.fdAttributeID=' . WK::KONW_ATTR_ID),
//章
'edtiontype' => array(self::HAS_MANY, 'Integer', 'fdContentID', 'condition' => 't.fdAttributeID=' . WK::CHAPTER_ATTR_ID, 'select' => array('t.fdValue'), 'alias' => 't', 'with' => array('tag'), 'order' => 't.id asc'),
//版本
'version' => array(self::HAS_ONE, 'Integer', 'fdContentID', 'condition' => 't.fdAttributeID =' . WK::VER_ATTR_ID, 'select' => array('t.fdValue'), 'alias' => 't', 'with' => array('ver')),
'v2version' => array(self::HAS_ONE, 'Integer', 'fdContentID', 'condition' => 'v2version.fdAttributeID =' . WK::VER_ATTR_ID, 'select' => array('v2version.fdValue')),//add 2016-3-2 lpf
//教材
'textbook' => array(self::HAS_ONE, 'Integer', 'fdContentID', 'condition' => 't.fdAttributeID =' . WK::TEXTBOOK_ATTR_ID, 'select' => array('t.fdValue'), 'alias' => 't', 'with' => array('tag')),
//地區
'area' => array(self::HAS_MANY, 'Integer', 'fdContentID', 'condition' => 't.fdAttributeID =' . WK::AREA_ATTR_ID, 'select' => array('t.fdValue'), 'alias' => 't', 'with' => array('loca')),
// add bu 2013.6.18
//學段
'schoolType' => array(self::HAS_ONE, 'Integer', 'fdContentID', 'on' => 'schoolType.fdAttributeID=' . WK::SECTION_ATTR_ID, 'select' => array('schoolType.fdContentID,schoolType.fdValue')),
//播放次數
'playNum' => array(self::HAS_ONE, 'Integer', 'fdContentID', 'condition' => 'playNum.fdAttributeID=' . WK::VIDEO_PLAY_TOTAL),
//@Deprecated 播放次數 使用playNum
'wkPlayNum' => array(self::HAS_ONE, 'Integer', '', 'on' => 'wkPlayNum.fdContentID=id and wkPlayNum.fdAttributeID=' . WK::VIDEO_PLAY_TOTAL),
//@Deprecated 內容貢獻記錄 使用mainContribute
'wkContribute' => array(self::HAS_ONE, 'Contribute', '', 'on' => 'wkContribute.fdContentID=t.id and wkContribute.fdFileID=0 and wkContribute.fdStatus=1'),
//@Deprecated 內容貢獻者記錄 使用mainUser
'wkUser' => array(self::HAS_ONE, 'User', 'fdUserID', 'through' => 'wkContribute'),
//@Deprecated add by hecf 2013.5.21 查詢視頻播放次數 使用playNum
'videoPlay' => array(self::HAS_ONE, 'Integer', 'fdContentID', 'condition' => 'videoPlay.fdAttributeID=' . WK::VIDEO_PLAY_TOTAL, 'select' => array('videoPlay.fdValue')),
//題目
'exercises' => array(self::HAS_ONE, 'Exercise', 'fdContentID'),
//題目對應的類型
'exerciseType' => array(self::BELONGS_TO, 'ExerciseType', '', 'on' => 'exercises.fdExerciseTypeID=exerciseType.id'),
//題目對應的內容
'exerciseItem' => array(self::HAS_MANY, 'ExerciseItem', '', 'on' => 'exercises.id=exerciseItem.fdExerciseID'),
//@Deprecated 查找file對應的屬性relation
'file' => array(self::HAS_ONE, 'File', 'fdContentID'), //hecf 2013.5.25
//@Deprecated 查找integer對應的屬性relation
'integer' => array(self::HAS_ONE, 'Integer', 'fdContentID'),
//@Deprecated 科目 edit by chenxch
'subject' => array(self::HAS_ONE, 'Subject', 'fdValue', 'through' => 'integer', 'on' => 'integer.fdAttributeID=' . WK::SUJT_ATTR_ID),
//@Deprecated
'class' => array(self::HAS_ONE, 'Integer', 'fdContentID'),
//@Deprecated
'grade' => array(self::HAS_ONE, 'Grade', 'fdValue', 'through' => 'class'),
//@Deprecated 查找blob對應的屬性relation
'blob' => array(self::HAS_ONE, 'Blob', 'fdContentID'),
'blobs' => array(self::HAS_MANY, 'Blob', 'fdContentID'),
//@Deprecated 使用playNum
'play' => array(self::BELONGS_TO, 'Play', '', 'on' => 't.id=play.fdContentID'),
//專題是否分將次，0為不分，1為分 by chenzsh
'courseComp' => array(self::HAS_ONE, 'Integer', 'fdContentID', 'on' => 'courseComp.fdAttributeID=' . WK::COURSE_COMP_ID, 'select' => array('courseComp.fdValue')),
/*add by john 2013年6月5日*/
//查詢content年級屬性
'grdtype' => array(self::HAS_ONE, 'Integer', 'fdContentID', 'condition' => 'grdtype.fdAttributeID=' . WK::GRD_ATTR_ID, 'select' => array('grdtype.fdValue')),
//@Deprecated微課-知識點關聯
'ctntagindex' => array(self::HAS_MANY, 'wkeCtnTagIndex', '', 'on' => 'id=ctntagindex.fdContentID', 'joinType' => 'LEFT JOIN'),
//主內容 2013年6月7日
'mainContribute' => array(self::HAS_ONE, 'Contribute', 'fdContentID', 'on' => 'mainContribute.fdFileID = 0'),
'mainUser' => array(self::HAS_ONE, 'User', 'fdUserID', 'through' => 'mainContribute'),
//新relation，應對試卷的contribute.fdFileID 不等于 0 by dengjq 2015-2-6
'newContribute' => array(self::HAS_ONE, 'Contribute', "fdContentID"),
'newUser' => array(self::HAS_ONE, 'User', 'fdUserID', 'through' => 'newContribute'),
//專題 john 2013年6月22日 | modify by chenzsh 2014年6月10日
'course'=>array(self::HAS_MANY,'ctnSubject','fdSubjectID','order'=>'course.fdOrder ASC'),
//專題中的微課 john 2013年6月22日
'coursewk'=>array(self::HAS_MANY,'ctnSubject','fdContentID'),
//專題價錢 hecf 2013.6.27
'price'=>array(self::HAS_ONE,'Price','fdContentID'),
//好評 hecf 2013.6.28
'AGREENUM'=>array(self::HAS_ONE,'Integer','fdContentID','condition'=>'AGREENUM.fdAttributeID='.WK::GOOD_COMMENT_ATTR_ID),
//差評 hecf 2013.6.28
'OBJECTNUM'=>array(self::HAS_ONE,'Integer','fdContentID','condition'=>'OBJECTNUM.fdAttributeID='.WK::BAD_COMMENT_ATTR_ID),
//我收藏的
'favourite' =>array(self::HAS_MANY,'Favorite','fdContentID'), //我的收藏 hecf 2013-7-8
//收藏次數 by yemg 5/29/2014
'cntFavor' =>array(self::STAT,'Favorite','fdContentID'),
//班級日志
'clsCtnIndex'=>array(self::HAS_ONE,'wkeClsCtnIndex','fdContentID'),
'clsCtnIndexes'=>array(self::HAS_MANY,'wkeClsCtnIndex','fdContentID'),//by dengjq 2015-8-22 主題討論
//試卷 chengx 2013/7/18
'exam'=>array(self::HAS_ONE,'Exam','fdContentID'),
//真實姓名
'realName'=>array(self::HAS_ONE,'Card','fdCardID','through'=>'mainUser'),
'albumCover'=>array(self::HAS_ONE,'Text','fdContentID','on'=>'albumCover.fdAttribute='.WK::ALBUM_COVER), //相冊封面 author:cenyc
'photo'=>array(self::HAS_MANY,'File','fdContentID','on'=>'photo.fdTypeID='.WK::CLASS_ALBUM),//hecf 2013.5.25
'albumInfo'=>array(self::HAS_ONE,'Blob','fdContentID','on'=>'albumInfo.fdAttributeID='.WK::ALBUM_INFO),
//題目 標簽
'tag'=>array(self::BELONGS_TO,'Text','','on'=>'t.id=tag.fdContentID and tag.fdAttributeID='.WK::TAG_ATTR_ID),
'difficulty'=>array(self::HAS_ONE,'Integer','','on'=>'t.id=difficulty.fdContentID and difficulty.fdAttributeID='.WK::DIFF_ATTR_ID),
'other'=>array(self::BELONGS_TO,'Integer','','on'=>'t.id=other.fdContentID'),
//專題封面圖片
'coverImage'=>array(self::HAS_ONE,'Text','fdContentID','on'=>'coverImage.fdAttributeID='.WK::COURSE_ATTR_ID),
'courseSubject'=>array(self::HAS_ONE,'Subject','fdValue','select'=>array('courseSubject.fdName'),'on'=>'integer.fdAttributeID='.WK::SUJT_ATTR_ID,'through'=>'integer'),
//微課與tag關系 by john 2013年7月25日
'ctnTagIndex'=>array(self::HAS_MANY,'wkeCtnTagIndex','fdContentID'),
'tagIndexes1'=>array(self::HAS_MANY,"wkeCtnTagIndex","fdContentID","on"=>"tagIndexes1.fdType=1"),//教材-章-節
'tagIndexes2'=>array(self::HAS_MANY,"wkeCtnTagIndex","fdContentID","on"=>"tagIndexes2.fdType=2"),//各級知識點
//總評論數 hecf 2013.8.14
'wkCommentCount'=>array(self::HAS_ONE,'Integer','fdContentID','condition'=>'wkCommentCount.fdAttributeID='.WK::COMMENT_ATTR_ID),
//chengx 獲取科目
'subjects'=>array(self::HAS_ONE,'Integer','fdContentID','condition'=>'subjects.fdAttributeID='.WK::SUJT_ATTR_ID,'select'=>array('subjects.fdValue')),
'_subject'=>array(self::HAS_ONE,'Integer','fdContentID','on'=>'_subject.fdAttributeID='.WK::SUJT_ATTR_ID),
'wkfile'=>array(self::HAS_ONE,'File','fdContentID','condition'=>'wkfile.fdTypeID='.WK::VIDEO_TYPEID),
'logfile'=>array(self::HAS_MANY,'File','fdContentID','condition'=>'logfile.fdTypeID='.WK::FILE_TYPE_ATTACHMENT),
'wkIndex'=>array(self::HAS_ONE,'Indexs','fdContentID'),//微課關聯類型
//@Deprecated by john 2013年10月11日 使用version
'wkversion'=>array(self::HAS_ONE, 'Integer', '', 'on'=>'wkversion.fdContentID=t.id and wkversion.fdAttributeID='.WK::VER_ATTR_ID),
//by hecf 2013.10.17 內容權限設置類型(原創/轉載)
'wkType'=>array(self::HAS_ONE,'Integer','fdContentID','on'=>'wkType.fdAttributeID='.WK::AUTHORITY_ATTR_ID),
//by hecf 2013.10.23 收藏數
'collection'=>array(self::HAS_ONE,'Integer','fdContentID','on'=>'collection.fdAttributeID='.WK::COLLECTION_ATTR_ID),
//by chenzsh 2013.11.6 歷史播放
'hisPlay'=> array(self::HAS_ONE,'Play','fdContentID','condition'=>'hisPlay.fdExcluded is null','select'=>array('MAX(hisPlay.fdTime) as playTime'),'order'=>'playTime DESC'),
//by zhangxb 2013.12.10 微課參賽狀態
'wkeTourney'=>array(self::HAS_ONE,'wkeTourney','fdContentID','select'=>array('wkeTourney.fdStage')),
//by liuzhiqiang 2014年3月27日 學生學習計劃
'planningClass'=>array(self::HAS_ONE,'Integer','fdContentID','on'=>'planningClass.fdAttributeID = '.WK::CLASS_RETHINK_ATTR_ID),
//by yemg 4/15/2014 courseware file 課件
'cswFile'=>array(self::HAS_ONE,'File','fdContentID','condition'=>'cswFile.fdTypeID='.WK::REPOSITORY_COURSEWARE),
//by yemg 4/15/2014 solution file 教案
'solFile'=>array(self::HAS_ONE,'File','fdContentID','condition'=>'solFile.fdTypeID='.WK::REPOSITORY_SOLUTION),
//by yemg 4/15/2014 guide learn case file 導學案
'gdFile'=>array(self::HAS_ONE,'File','fdContentID','condition'=>'gdFile.fdTypeID='.WK::REPOSITORY_GUIDE),
//by tangjf微課和專題獲取評價平均分
'avgRark'=>array(self::HAS_ONE,'Integer','fdContentID','on'=>'avgRark.fdAttributeID='.WK::RANKEDAVG_ATTR_ID),
//by tangjf微課和專題獲取評價數量
'countRark'=>array(self::HAS_ONE,'Integer','fdContentID','on'=>'countRark.fdAttributeID='.WK::RANKEDTOTAL_ATTR_ID),
//微課封面 by yemg 6/5/2014
'wkCover'=>array(self::HAS_ONE,'Text','fdContentID','on'=>'wkCover.fdAttributeID='.WK::WK_ATTR_ID,'select'=>array('wkCover.fdValue')),
//資源庫模塊中微課為解題類型時的試題來源 by yemg 6/5/2014
'examSrc'=>array(self::HAS_ONE,'Text','fdContentID','on'=>'examSrc.fdAttributeID='.WK::EXAM_SOURCE_ATTR_ID,'select'=>array('examSrc.fdValue')),
//內容權限為轉載類型時的轉載來源 by yemg 6/5/2014
'reprintSrc'=>array(self::HAS_ONE,'Text','fdContentID','on'=>'reprintSrc.fdAttributeID='.WK::REPRINTED_ATTR_ID,'select'=>array('reprintSrc.fdValue')),
//試題知識類型 bytang tangf 2014-6-16
'knowType'=>array(self::HAS_ONE,'Integer','fdContentID','on'=>'knowType.fdAttributeID='.WK::RESOURCE_ST_KNOW),
//試題目標類型 bytang tangf 2014-6-16
'knowTarget'=>array(self::HAS_ONE,'Integer','fdContentID','on'=>'knowTarget.fdAttributeID='.WK::RESOURCE_ST_OBJECTIVES),
'textbooks'=>array(self::HAS_ONE,'Integer','fdContentID','condition'=>'textbooks.fdAttributeID ='.WK::TEXTBOOK_ATTR_ID,'select'=>array('textbooks.fdValue')),
//chenchy 2014/6/23
'year'=>array(self::HAS_ONE,'Integer','fdContentID','on'=>'year.fdAttributeID='.WK::EXAM_FOR_YEAR),
//andy 2014年6月24日 試卷適用年份
//課程進度，by dengjq/2014-7-9
'courseSchedules'=>array(self::HAS_MANY,'wkeCourseSchedule','fdCourseID','condition'=>'courseSchedules.fdTypeID='.WK::SCHEDULE_COURSE),
//資源下載次數 add tangjf 2014-7-16
'downloadsNum'=>array(self::HAS_ONE,'Integer','fdContentID','condition'=>'downloadsNum.fdAttributeID ='.WK::DOWNLOADS_NUM,'select'=>array('downloadsNum.fdValue')),
//根據資源下載次數排序 add by wuzhc 2015-08-13
'orderByDownNum'=>array(self::HAS_ONE,'Integer','fdContentID','on'=>'orderByDownNum.fdAttributeID ='.WK::DOWNLOADS_NUM,'select'=>array('orderByDownNum.fdValue')),
//內容關聯的所有文件 yemg 7/31/2014
'files' => array(self::HAS_MANY, 'File', 'fdContentID'),
//yemg 7/31/2014
'ctnMaps' => array(self::HAS_MANY, 'wkeCtnMap', 'fdContentID'),
'ctnMaps2' => array(self::HAS_MANY, 'wkeCtnMap', 'fdTargetID'),
//yemg 8/26/2014
'cntFile' =>array(self::STAT,'File','fdContentID'),
//by chenzsh 2014-9-9 14:33:57
'xtcourse'=>array(self::HAS_MANY,'ctnSubject','fdSubjectID','order'=>'xtcourse.fdOrder ASC','condition'=>'xtcourse.fdXtStatus = 0'),
'ktcourse'=>array(self::HAS_MANY,'ctnSubject','fdSubjectID','order'=>'ktcourse.fdOrder ASC','condition'=>'ktcourse.fdKtStatus = 0'),
//by dengjq/2014-10-13
'products'=>array(self::HAS_MANY,'payProduct','fdContentID'),//推送成產品
'newest_product'=>array(self::HAS_ONE,'payProduct','fdContentID','order'=>'newest_product.fdCreate DESC'),//獲取最新產品 by chenxch
'productXuetang'=>array(self::HAS_ONE,'payProduct','fdContentID','on'=>'productXuetang.fdSourceID='.WK::WEB_XUETANG,"order"=>"productXuetang.id desc"),//推送成產品,學堂
//for test by john 用于調試數據庫中content有內容而exercise沒有內容的題目
'exercise'=>array(self::HAS_ONE,'Exercise',"fdContentID"),
//by tangjf/2014-10-29
//版本
'versions'=>array(self::HAS_ONE,'Integer','fdContentID','condition'=>'versions.fdAttributeID ='.WK::VER_ATTR_ID,'select'=>array('versions.fdValue')),
//教材
'textbooks'=>array(self::HAS_ONE,'Integer','fdContentID','condition'=>'textbooks.fdAttributeID ='.WK::TEXTBOOK_ATTR_ID,'select'=>array('textbooks.fdValue')),
//--Text
"reviewReason"=>array(self::HAS_ONE,"Text","fdContentID","on"=>"reviewReason.fdAttributeID=".WK::TEXT_REVIEW_REASON),
//content對應使用數
'used' => array(self::HAS_ONE,"Integer","fdContentID","on"=>"used.fdAttributeID=".Yii::app()->params['USED_ATTR_ID']),
//音頻
'audiofile'=>array(self::HAS_ONE,'File','fdContentID','condition'=>'audiofile.fdTypeID='.WK::AUDIO_TYPEID),
//圖片
'imageFile'=>array(self::HAS_ONE,'File','fdContentID','condition'=>'imageFile.fdTypeID='.WK::IMAGE_TYPEID),
//題目點評 by dengjq 2015-6-12
'markTexts'=>array(self::HAS_MANY,"Text","fdContentID","on"=>"markTexts.fdAttributeID>=".WK::TEXT_EXERCISE_MARK1." and markTexts.fdAttributeID<=".WK::TEXT_EXERCISE_MARK4),
//題目關聯考點 by dengjq 2015-6-18
'pointInteger'=>array(self::HAS_ONE,"Integer","fdContentID","on"=>"pointInteger.fdAttributeID=".WK::XT_POINT_ID),
//外部應用ID by john 2015-08-12
'outSideHost'=>array(self::HAS_ONE,'Integer','fdContentID','on'=>'outSideHost.fdAttributeID='.WK::OUTSIDE_HOST),
'outSideWeiID'=>array(self::HAS_ONE,'Integer','fdContentID','on'=>'outSideWeiID.fdAttributeID='.WK::OUTSIDE_WKID),
//試卷的源試卷ID by john 2015-08-26
"sourceExam"=>array(self::HAS_ONE,"Integer",'fdContentID',"on"=>"sourceExam.fdAttributeID=".WK::SOURCEEXAM_ATTR_ID),
"quality"=>array(self::HAS_ONE,"Integer","fdContentID","on"=>"quality.fdAttributeID=".WK::INTEGER_QUALITY),//資源質量 by dengjq 2015-10-26
"subSubject"=>array(self::HAS_ONE,"Integer","fdContentID","on"=>"subSubject.fdAttributeID=".WK::INTEGER_SUB_SUBJECT),//子科目 by dengjq 2015-10-26
"exerciseAlias"=>array(self::HAS_ONE, "Integer", "fdContentID","on"=>"exerciseAlias.fdAttributeID=".WK::XT_TYPE_ID),//aliasID題型
"exerciseTag"=>array(self::HAS_ONE, "Integer", "fdContentID","on"=>"exerciseTag.fdAttributeID=".WK::XT_POINT_ID),//題目題型對應的考點
//試卷的難度構成 by tangjf 2016-5-12
"diffSituation"=>array(self::HAS_ONE,"Text","fdContentID","on"=>"diffSituation.fdAttributeID=".WK::EXAM_DIFF_SITUATION),
//試卷的試題總數
"exerciseCount"=>array(self::HAS_ONE,"Text","fdContentID","on"=>"exerciseCount.fdAttributeID=".WK::EXAM_EXERCISE_COUNT),
//學科網的題目ID
"exerciseXkID"=>array(self::HAS_ONE,"Integer","fdContentID","on"=>"exerciseXkID.fdAttributeID=".WK::EXERCISE_XUEKEWANG_ID),
//學科網資源ID
"xkwID"=>array(self::HAS_ONE,"Integer","fdContentID","on"=>"xkwID.fdAttributeID=".WK::XUEKEWANG_ID),
//資源推送到mongo的狀態值
"resourceMongo"=>array(self::HAS_ONE,"Integer","fdContentID","on"=>"resourceMongo.fdAttributeID=".WK::RESOURCE_MONGO),
// 第三版備課課時
'period' => array(self::HAS_ONE,'Integer','fdContentID','condition'=>'period.fdAttributeID ='.WK::PREPARE_ATTR_PERIOD,'select'=>array('period.fdValue')),
// 第三版備課課型
'prepareType' => array(self::HAS_ONE,'Integer','fdContentID','condition'=>'prepareType.fdAttributeID ='.WK::PREPARE_ATTR_TYPE,'select'=>array('prepareType.fdValue')),
// 第四版備課(是否在線提交作業)
'uploadHomework' => array(self::HAS_ONE,'Integer','fdContentID','condition'=>'uploadHomework.fdAttributeID ='.WK::INTEGER_V4PREPARE_UPLOAD_HOMEWORK,'select'=>array('uploadHomework.fdValue')),
// 第四版備課(需登記線下作業成績)
'registerScore' => array(self::HAS_ONE,'Integer','fdContentID','condition'=>'registerScore.fdAttributeID ='.WK::INTEGER_V4PREPARE_REGISTER_SCORE,'select'=>array('registerScore.fdValue')),
// @deprecated 第三版備課草稿狀態, 使用content字段disabled判斷 see WK::CNT_PREPARE_DRAFT
// 'prepareDraft'=>array(self::HAS_ONE,'Integer','fdContentID','condition'=>'prepareDraft.fdAttributeID='.WK::PREPARE_ATTR_DRAFT),
//多版本
'_versions' => array(self::HAS_MANY, 'Integer', 'fdContentID', 'condition' => '_versions.fdAttributeID=' . WK::VER_ATTR_ID),
//點贊 by tangjf 2016-12-6
'appraise' =>array(self::HAS_MANY,'svcAppraise','fdContentID'),
//點贊次數
'appraiseNum' =>array(self::STAT,'svcAppraise','fdContentID'),
'wktokt' => array(self::HAS_ONE, 'wkeWKTOKT', 'fdKTWKID', 'on' => 't.id=wktokt.fdKTWKID'),
'ctnAtagIndex'=>array(self::HAS_MANY,'wkeCtnAtagIndex','fdContentID'),
'coverFile'=>array(self::HAS_ONE,'File','fdContentID','on'=>'coverFile.fdTypeID='.WK::FILE_TYPE_PICTURE),
//微課播放生成推送的相關試題
'weikeExams' => array(self::HAS_MANY,'Integer','fdContentID','condition' => 'weikeExams.fdAttributeID=' . WK::WEIKE_ATTRIBUTE_TYPE),
'answerExams' => array(self::HAS_MANY,'AnswerExam','','on'=>'weikeExams.fdValue = answerExams.id','through' => 'weikeExams'),
'province' => array(self::HAS_ONE, 'Integer', 'fdContentID', 'on' => 'province.fdAttributeID =' . WK::AREA_ATTR_ID),
'courses'=>array(self::HAS_MANY,'ctnSubject','fdSubjectID'),
'explainWeike' => array(self::HAS_MANY,'Integer','fdContentID','condition' => 'explainWeike.fdAttributeID=' . WK::EXAM_EXPLAIN_WEIKE),
//獎項
'awards' => array(self::HAS_ONE,'Text','fdContentID','condition' => 'awards.fdAttributeID=' . WK::ATTRIBUTE_AWARDS),
//作品內容
'productionText' => array(self::HAS_ONE, 'Blob', 'fdContentID', 'on' => 'productionText.fdAttributeID=' . WK::BLOB_TEXT, 'select' => array('intro.fdValue')),
//地區關聯
'member' => array(self::HAS_ONE,'Member','','on'=>'t.fdUserID = member.fdUserID'),
//班級關聯
'classMapOne'=> array(self::HAS_ONE,'wkeClassMap','','on'=>'t.fdUserID = wkeClassMap.fdUserID'),
//公開分享審核
"openShareApprove"=>array(self::HAS_ONE,"Integer","fdContentID","on"=>"openShareApprove.fdAttributeID=".WK::OPEN_SHARING_APPROVING),
);
}
```
http://ketang.test/index.php?r=teachingV3/teachingPlan/edit&planID=2145371
```
```
- 說明
- 開發任務
- 星課-真光
- 課表
- Excel Down
- 調課
- 課表修改
- 課表代碼分析
- 課堂
- 課堂：應用商店通信管理協議
- 教師賬號強制綁定手機或郵箱
- 強制綁定手機和修改密碼的規則
- 學堂
- 課程學習：討論功能
- 后臺：課程討論管理
- 課程直播接口
- 學習統計功能(舊版)
- 學習統計功能(新版)
- 同步課程統計功能
- 同步課程編輯-新增視頻
- 第三方接口
- 學科網
- 安徽第三方
- 大賽
- 管控系統
- 日志管理
- 設備日志
- 平板接口
- 渝教
- 教學總結
- 空白目錄
- Yii 1.1
- 學堂架構
- Yii 1.1一些方法的解讀
- MVCS結構
- 基礎使用語法
- 創建1個新模塊
- 關聯模型
- CDbCriteria
- 學生-課堂記錄
- 學生端頁面展示
- 教師端頁面展示
- 編輯課程文檔
- SQL
- 課堂項目運行入口
- 上傳資源示意圖
- 行為
- PHPStorm
- 源碼閱讀
- 會診答卷頁面
- 考點練習
- 資源首頁
- 同步課程
- 同步課程：章節信息
- 升學復習
- 統計圖-范例
- 模塊
- 非法詞
- 服務層
- MongoDB類
- 學堂作答記錄從Mongo新集合獲取數據
- MongoYii
- 錯題集
- 小技巧
- 完善資料
- 郵件發送
- K12
- JSpang視頻課程
- MongoDB
- 創業
- 項目
- 包包