# 課程編輯器： 錄播課增加上傳重點片段視頻
http://tower.wm3dao.com:8880/browse/XUETANG-21
（1）上傳視頻：支持編輯視頻標題，上傳視頻文件。（都是必填）
（2）修改視頻：支持刪除當前視頻重新上傳，支持修改標題。
## 編輯課程頁面
http://tcourse.wmxuetang.com/index.php?r=courseCenter/course/EidtContent&courseID=6
*D:\wamp\www\xue.test\xuetang\protected\modules\courseCenter\views\course\_edit_content.php*
```
on("click", ".js_addReview", function() {
// 打開上傳課程視頻彈框
$(this).addClass("js_uploadOn");
tb_show(null, "<?php echo $this->createUrl('course/ReviewUploadBox');?>&width=602&height=286", null, null);
}
```
*D:\wamp\www\xue.test\xuetang\protected\modules\courseCenter\controllers\CourseController.php*
```
UPDATE `wkxuetang`.`tbCourseReview` SET `id`='34', `fdCourseID`='6', `fdCourseCatalogID`='84', `fdName`='1.mp4', `fdUrl`='http://qn.cnweike.cn/content/coursecenter/0/0/0/6/84/8503418145313132544.mp4', `fdDuration`='49', `fdThumb`=NULL, `fdPersistentId`='zhongzhi6-z0.5cf4eb9238b9f31ea67eea7f', `fdCreate`='2019-06-03 17:09:31' WHERE (`id`='34');
```
## 接口
http://tcourse.wmxuetang.com/index.php?r=courseCenter/course/getResource&type=26&from=2&tagID=17&tagType=1&start=0&len=8
```
{
"data": {
"list": [{
"type": 26,
"id": "3585186",
"title": "1",
"schoolName": "太陽島未名未來教室",
"author": "莊不懂",
"thumb": "http:\/\/tcourse.wmxuetang.com\/public\/ketang\/images\/weixin.png",
"date": 1559555858000,
"duration": 0,
"score": 0,
"appraisenum": 0,
"playnum": 0,
"downloadsNum": 0,
"tag": {
"assists": [{
"schoolTypeID": 2,
"schoolType": "初中",
"subjectID": 2,
"subject": "數學",
"versionID": 120,
"version": "其他",
"textbookID": 16,
"textbook": "數學中考總復習",
"tags": [{
"id": "16",
"level": "1",
"title": "數學中考總復習"
}, {
"id": "17",
"level": "2",
"title": "一、數與式"
}]
}],
"knows": null,
"editions": null
},
"diff": "1",
"weikeType": "講授",
"isFlash": 0
}, {
"type": 26,
"id": "3585185",
"title": "1",
"schoolName": "太陽島未名未來教室",
"author": "莊不懂",
"thumb": "http:\/\/qn.cnweike.cn\/content\/0\/54\/180\/3585185\/542651.m.jpg",
"date": 1559555719000,
"duration": "49",
"score": 0,
"appraisenum": 0,
"playnum": 0,
"downloadsNum": 0,
"tag": {
"assists": [{
"schoolTypeID": 2,
"schoolType": "初中",
"subjectID": 2,
"subject": "數學",
"versionID": 120,
"version": "其他",
"textbookID": 16,
"textbook": "數學中考總復習",
"tags": [{
"id": "16",
"level": "1",
"title": "數學中考總復習"
}, {
"id": "17",
"level": "2",
"title": "一、數與式"
}]
}],
"knows": null,
"editions": null
},
"diff": "1",
"weikeType": "講授",
"isFlash": 0
}],
"total": "2"
},
"status": 0,
"msg": "success",
"ssk": null
}
```
### 上傳任務視頻：
http://tcourse.wmxuetang.com/index.php?r=courseCenter/course/FileResourceSave
```json
{
"data": {
"id": "3585186"
},
"status": 0,
"msg": "success",
"ssk": null
}
```
```sql
INSERT INTO `wkxuetang`.`tbCourseTaskRecord` (`id`, `fdCourseID`, `fdCourseCatalogID`, `fdCourseTaskID`, `fdType`, `fdValue`, `fdOrder`, `fdUserID`, `fdCreate`, `fdStatus`) VALUES ('84', '6', '84', '19', '26', '3585185', '1', '451299', '2019-06-03 17:55:22', '0');
```
## 上傳課程視頻彈框 course/ReviewUploadBox
```php
public function actionReviewUploadBox()
{
$this->renderPartial("_review_upload_box");
}
```
*D:\wamp\www\xue.test\xuetang\protected\modules\courseCenter\views\course\_review_upload_box.php*
```php+HTML
<div class="w hidden pt20 pb20">
<div class="w mt20 clr">
<div class="fl w105 pr5 tr fb mt5"><span class="red vm mr3">*</span>視頻標題：</div>
<div class="fl">
<input type="text" class="w400 inputText" id="weike-name">
</div>
<div id="name-tip" class="fl ml10 f12 red mt5 none">名字不能為空</div>
</div>
<div class="w mt20 clr">
<div class="fl w105 pr5 tr fb mt4"><span class="red vm mr3">*</span>視頻文件：</div>
<div class="fl h100">
<?php echo $this->renderPartial('upload/upload_video_unit', array('idName' => "weike-name", 'maxSize' => 1024))?>
</div>
</div>
<div class="w tc"><a href="javaScript:void(0)" class="button_3 w100" id="upsubmit">確 定</a></div>
</div>
```
*點擊確定按鈕：*
```javascript
.on("click", "#review-upload-box #upsubmit", function() {
// 課程視頻彈框確定
if ($(this).hasClass("button_off")) return false;
$(this).addClass("button_off").text("正在上傳");
var $groups = $("#review-upload-box .js_resHiddenGroup");
if ($('#review-upload-box #weike-name').val().length == 0) {
$.showBoxs("請輸入視頻名稱！");
$(this).removeClass("button_off").text("確定");
return false;
}
if ($("#review-upload-box .upload-complete").length <= 0) {
$.showBoxs("請添加視頻文件！");
$(this).removeClass("button_off").text("確定");
return false;
}
if ($("#review-upload-box .res-uploading").length > 0) {
$.showBoxs("您還有未上傳完的文件！");
$(this).removeClass("button_off").text("確定");
return false;
}
var $first = $($groups[0]), $ps = $(".js_uploadOn").parent();
var data = {
courseID: $ps.data("cid"),
courseCatalogID: $ps.data("catalog"),
path: $first.find(".coverTempName").val(),
name: $first.find(".coverOriginName").val(),
}
var $self = $(this);
var iurl = "<?php echo $this->createUrl('course/reviewUpload');?>";
$.ajax({
url: iurl,
type: "POST",
data: {data: data},
success: function(result) {
$self.removeClass("button_off");
if (result.status == 0) {
$.showBox2("提交成功！");
var id = (result.data || {}).id || "", url = (result.data || {}).url || "";
$(".js_uploadOn").replaceWith('<div class="courseCenter-resourceView" style="margin-bottom:15px;">'
+ '<a href="javaScript:" class="delete js_reviewDel" title="刪除" data-id="' + id + '"></a>'
+ '<a href="javaScript:" class="js_reviewPlay" data-url="' + url + '" title="' + data.name + '">'
+ '<div><img src="<?php echo Yii::app()->request->baseUrl; ?>/public/ketang/images/weixin.png" class="loading-img" width="154" height="114" data-src="<?php echo Yii::app()->request->baseUrl; ?>/public/ketang/images/weixin.png"></div>'
+ '<div class="txt">' + data.name + '</div>'
+ '</a>'
+ '</div>');
outlineObj[$(".js_scItem.on").data("id")] = outlineObj[$(".js_scItem.on").data("id")] || {};
outlineObj[$(".js_scItem.on").data("id")].courseReview = {
duration: 0,
id: id,
name: data.name,
thumb: "<?php echo Yii::app()->request->baseUrl; ?>/public/ketang/images/weixin.png",
url: url,
};
tb_remove();
} else {
$.showBox2(result.msg);
}
},
error: function(error) {
$self.removeClass("button_off");
$.showBox2("服務器出錯，錯誤碼為" + error.status);
}
})
});
```
*D:\wamp\www\xue.test\xuetang\protected\modules\courseCenter\views\course\upload\upload_video_unit.php*
```php+HTML
<div class="w460 fl">
<div class="w clr">
<a id="weike-upload-btn" href="javascript:" >
<i class="glyphicon glyphicon-plus"></i>
<span class="button_1">選擇文件</span>
</a>
<span class="mt4 gray f13">（格式:mp4,flv,avi,rmvb,3gp,mpeg,swf 限制大小為：<?php echo ($maxSize ?: WK::WEIKE_MAXFILESIZE);?>MB）</span>
</div>
<div class="w" id="weike-upload-container">
<div class="w" id="res-container"></div>
</div>
<script type="text/javascript">
var idName = "<?php echo $idName?>";
function createProgressTep(file) {
var fname = (file.name || "");
fname = fname.slice(0, fname.lastIndexOf("."));
return '<div id="' + file.id + '" class="w450 box-sizing p10 clr mt15 bg4 lh14 template-upload res-uploading">'
+ '<div class="fl mr20 word-ellipsis f14 js_resTitle" title="' + fname + '" style="max-width:230px;">' + fname + '</div>'
+ '<a href="javaScript:" class="fr gray ml30 js_resCancel" title="刪除">刪除</a>'
+ '<div class="fr w120 h14 box-sizing border1 br6 bgcolor-white hidden js_resProgress">'
+ '<div class="h bg5 js_resProgressBar" style="width:0%;"></div>'
+ '</div>'
+ '<div class="js_resHiddenGroup hidden fl">'
+ '<input type="hidden" class="coverOriginName" value=""/>'
+ '<input type="hidden" class="coverTempName" value=""/>'
+ '</div>'
+ '</div>';
}
// 上傳視頻
var uploader = Qiniu.uploader({
runtimes: 'html5,flash,html4', //上傳模式,依次退化
browse_button: 'weike-upload-btn', //上傳選擇的點選按鈕，**必需**
uptoken_url: '', //Ajax請求upToken的Url，**必需**（服務端提供）
uptoken: '<?php echo $upToken; ?>',
domain: 'http://wmzz.qiniudn.com/', //bucket 域名，下載資源時用到，**必需**
container: 'weike-upload-container', //上傳區域DOM ID，默認是browser_button的父元素，
max_file_size: '<?php echo ($maxSize ?: WK::WEIKE_MAXFILESIZE);?>mb',
//最大文件體積限制
flash_swf_url: '/public/qiniu/js/plupload/Moxie.swf', //引入flash,相對路徑
max_retries: 3, //上傳失敗最大重試次數
dragdrop: false, //開啟可拖曳上傳
drop_element: 'weike-upload-container', //拖曳上傳區域元素的ID，拖曳文件或文件夾后可觸發上傳
chunk_size: '4mb', //分塊上傳時，每片的體積
auto_start: true, //選擇文件后自動上傳，若關閉需要自己綁定事件觸發上傳
mime_types: 'mp4,flv,avi,rmvb,3gp,mpeg,swf',
unique_names: true,
filters : [{
title : "視頻文件(.wmv.mp4.flv.avi.rmvb.3gp.mpeg.swf)",
extensions : "wmv,mp4,flv,avi,rmvb,3gp,mpeg,swf"
}],
multi_selection: false,
init: {
'FilesAdded': function(up, files) {
plupload.each(files, function(file) {
var progress = new FileProgress(file, 'res-container', createProgressTep, 1);
progress.bindUploadCancel(up);
if ($(".template-upload").length > 1) {
progress.fileProgressWrapper.find(".js_resCancel").click();
$.showBox("最多只能上傳1個文件");
} else if (idName) {
($('#' + idName).val().length == 0 || <?php echo $nameFlag;?> == 1) && $('#' + idName).val(file.name.substr(0, file.name.lastIndexOf('.')));
}
});
},
'BeforeUpload': function(up, file) {
var progress = new FileProgress(file, 'res-container', createProgressTep, 1);
var chunk_size = plupload.parseSize(this.getOption('chunk_size'));
if (up.runtime === 'html5' && chunk_size) {
progress.setChunkProgess(chunk_size);
}
},
'UploadProgress': function(up, file) {
var progress = new FileProgress(file, 'res-container', createProgressTep, 1);
var chunk_size = plupload.parseSize(this.getOption('chunk_size'));
progress.setProgress(file.percent + "%", up.total.bytesPerSec, chunk_size);
},
'UploadComplete': function() {
},
'FileUploaded': function(up, file, info) {
var progress = new FileProgress(file, 'res-container', createProgressTep, 1);
progress.setComplete(up, info);
},
'Error': function(up, err, errTip) {
var progress = new FileProgress(err.file, 'res-container', createProgressTep, 1);
progress.setError();
// err.errType = progress.fileProgressWrapper.data("type");
// errList.push(err);
}
}
});
uploader.bind('FileUploaded', function(up, files) {
window.console && console.log('hello man,a file is uploaded');
});
</script>
</div>
```
*上傳完成后的表單內容：*
```html
<div class="w" id="weike-upload-container" style="position: relative;">
<div class="w" id="res-container">
<div id="o_1dclq20k13vbtbto2sirrcfv9" class="w450 box-sizing p10 clr mt15 bg4 lh14 template-upload upload-complete" style="opacity: 1;">
<div class="fl mr20 word-ellipsis f14 js_resTitle" title="1" style="max-width:230px;">1</div>
<a href="javaScript:" class="fr gray ml30 js_resCancel" title="刪除">刪除</a>
<div class="fr w120 js_resProgress green tc">7.30MB</div>
<div class="js_resHiddenGroup hidden fl">
<input type="hidden" class="coverOriginName" value="1.mp4">
<input type="hidden" class="coverTempName" value="o_1dclq20k13vbtbto2sirrcfv9.mp4">
</div>
</div>
</div>
<div id="html5_1dclphonj1ji66mk1ri0lihb63_container" class="moxie-shim moxie-shim-html5" style="position: absolute; top: 168px; left: 602px; width: 74px; height: 19px; overflow: hidden; z-index: 0;"><input id="html5_1dclphonj1ji66mk1ri0lihb63" type="file" style="font-size: 999px; opacity: 0; position: absolute; top: 0px; left: 0px; width: 100%; height: 100%;" accept="video/x-ms-wmv,video/mp4,video/x-flv,video/avi,.rmvb,video/3gpp,video/mpeg,application/x-shockwave-flash"></div>
</div>
```
## 點擊確認>添加課程視頻：
http://tcourse.wmxuetang.com/index.php?r=courseCenter/course/reviewUpload
```
D:\wamp\www\xue.test\xuetang\protected\modules\courseCenter\controllers\CourseController.php:2264:
POST提交參數：
array (size=4)
'courseID' => string '53' (length=2)
'courseCatalogID' => string '246' (length=3)
'path' => string 'o_1dclr0h5k1cfg1eu019a4k4q11d89.mp4' (length=35)
'name' => string '2.mp4' (length=5)
```
```
{
"data": {
"id": "34",
"url": "http:\/\/qn.cnweike.cn\/content\/coursecenter\/0\/0\/0\/6\/84\/8657731716053471232.mp4",
"name": "1.mp4"
},
"status": 0,
"msg": "success",
"ssk": null
}
```
```
/**
* 上傳保存直播視頻回顧
* @author tangjf 2018-12-29
*/
public function actionReviewUpload()
{
$params = Yii::app()->request->getParam( "data" );
if ( !$params || !$params[ "courseID" ] || !$params[ "courseCatalogID" ] || !$params[ "path" ] || !$params[ "name" ] )
ResponseUtils::json( null, 21, ResponseUtils::$rmsg[ 21 ] );
$this->_isCourse( $params[ "courseID" ] );
$this->_isCourseTeacher( $params[ "courseID" ] );
$args = array(
"courseID" => $params[ "courseID" ],
"courseCatalogID" => $params[ "courseCatalogID" ],
"name" => $params[ "name" ],
"path" => $params[ "path" ],
);
if ( $reviewID = CourseCenterService::factory()->saveCourseReview( $args ) ) {
$review = xtCourseReview::model()->findByPk( $reviewID );
ResponseUtils::json( array( "data" => array( "id" => $reviewID, "url" => $review->fdUrl,"name"=>$review->fdName ) ) );
} else
ResponseUtils::json( null, 1, ResponseUtils::$rmsg[ 21 ] );
}
```
D:\wamp\www\xue.test\xuetang\protected\modules\courseCenter\views\course\_edit_content.php
```
.on("click", ".js_addReview", function() {
// 打開上傳課程視頻彈框
$(this).addClass("js_uploadOn");
tb_show(null, "<?php echo $this->createUrl('course/ReviewUploadBox');?>&width=602&height=286", null, null);
})
...
var $self = $(this);
var iurl = "<?php echo $this->createUrl('course/reviewUpload');?>";
$.ajax({
url: iurl,
type: "POST",
data: {data: data},
success: function(result) {
$self.removeClass("button_off");
if (result.status == 0) {
$.showBox2("提交成功！");
var id = (result.data || {}).id || "", url = (result.data || {}).url || "";
$(".js_uploadOn").replaceWith('<div class="courseCenter-resourceView" style="margin-bottom:15px;">'
+ '<a href="javaScript:" class="delete js_reviewDel" title="刪除" data-id="' + id + '"></a>'
+ '<a href="javaScript:" class="js_reviewPlay" data-url="' + url + '" title="' + data.name + '">'
+ '<div><img src="<?php echo Yii::app()->request->baseUrl; ?>/public/ketang/images/weixin.png" class="loading-img" width="154" height="114" data-src="<?php echo Yii::app()->request->baseUrl; ?>/public/ketang/images/weixin.png"></div>'
+ '<div class="txt">' + data.name + '</div>'
+ '</a>'
+ '</div>');
outlineObj[$(".js_scItem.on").data("id")] = outlineObj[$(".js_scItem.on").data("id")] || {};
outlineObj[$(".js_scItem.on").data("id")].courseReview = {
duration: 0,
id: id,
name: data.name,
thumb: "<?php echo Yii::app()->request->baseUrl; ?>/public/ketang/images/weixin.png",
url: url,
};
tb_remove();
} else {
$.showBox2(result.msg);
}
},
error: function(error) {
$self.removeClass("button_off");
$.showBox2("服務器出錯，錯誤碼為" + error.status);
}
})
// 保存課程
$("#course-save").click(function() {
var $this = $(this);
if ($this.hasClass("button_off")) {
return false;
}
var $confirm = $("#task-confirm"), beforeID = $(".js_scItem.on").data("id");
if ($confirm .length == 1 && !$confirm .hasClass("button_off")) {
$this.addClass("button_off");
packingTaskData($confirm , function($el, rd) {
$this.removeClass("button_off")
isClosed = true;
window.location.href = "<?php echo $this->createUrl('course/mycourse')?>";
});
} else {
isClosed = true;
window.location.href = "<?php echo $this->createUrl('course/mycourse')?>";
}
})
...
function packingTaskData($el, callback) {
var $item = $(".js_taskEditItem"), taskID = $item.data("id");
var data = {
courseID: courseID,
catalogID: $(".js_scItem.on").data("id"),
taskID: taskID,
name: $item.find(".js_taskTitle").val() || "",
intro: editors[$item.find(".js_teditor").attr("id")].getValue(),
order: $item.data("order") || 1,
resourses: []
}
$("#taskItemList .courseCenter-resourceView").each(function(i) {
var type = $(this).data("type"),
id = $(this).data("cid");
data.resourses.push({
resourseType: type,
resourseID: id,
order: i,
recordID: $(this).data('record')
});
});
if (data.name == "") {
$el.removeClass("button_off");
$.showBox2("請輸入任務名稱");
return false;
}
if (data.resourses.length == 0) {
$el.removeClass("button_off");
$.showBox2("請添加任務內容");
return false;
}
for (var i = 0, len = taskResourceDel.length; i < len; i++) {
data.resourses.push({
recordID: taskResourceDel[i]
});
}
globals.saveTask = $.Deferred();
ajaxDeal({
url: "<?php echo $this->createUrl('course/SaveTask');?>",
type: "POST",
data: {data: data},
}, function(result) {
if (callback) {
callback($el, result.data);
}
globals.saveTask.resolve(true);
}, function(error) {
globals.saveTask.resolve(false);
})
}
```
## 刪除視頻
http://xue.test/index.php?r=courseCenter/course/delReviewVideo&courseID=53&courseCatalogID=246&reviewID=9
```
參數：
r: courseCenter/course/delReviewVideo
courseID: 53
courseCatalogID: 246
reviewID: 9
返回信息：
{"status":0,"msg":"success","ssk":null}
```
## 設置 章節/知識點信息
http://xue.test/index.php?r=courseCenter/course/saveCatalogInfo
```
data[courseID]: 53
data[catalogID]: 246
data[tagTypeID]: 1
data[tagID]: 45607
```
http://xue.test/index.php?r=courseCenter/course/reviewUpload
```
data[courseID]: 53
data[courseCatalogID]: 246
data[path]: o_1dcg823qh8lk10m9om61aid1nkt9.mp4
data[name]: 1.mp4
{
"data": {
"id": "9",
"url": "http:\/\/qn.cnweike.cn\/content\/coursecenter\/0\/0\/0\/53\/246\/282741952.mp4",
"name": "1.mp4"
},
"status": 0,
"msg": "success",
"ssk": null
}
public function actionReviewUpload()
{
$params = Yii::app()->request->getParam( "data" );
if ( !$params || !$params[ "courseID" ] || !$params[ "courseCatalogID" ] || !$params[ "path" ] || !$params[ "name" ] )
ResponseUtils::json( null, 21, ResponseUtils::$rmsg[ 21 ] );
$this->_isCourse( $params[ "courseID" ] );
$this->_isCourseTeacher( $params[ "courseID" ] );
$args = array(
"courseID" => $params[ "courseID" ],
"courseCatalogID" => $params[ "courseCatalogID" ],
"name" => $params[ "name" ],
"path" => $params[ "path" ],
);
if ( $reviewID = CourseCenterService::factory()->saveCourseReview( $args ) ) {
$review = xtCourseReview::model()->findByPk( $reviewID );
ResponseUtils::json( array( "data" => array( "id" => $reviewID, "url" => $review->fdUrl,"name"=>$review->fdName ) ) );
} else
ResponseUtils::json( null, 1, ResponseUtils::$rmsg[ 21 ] );
}
D:\wamp\www\xue.test\xuetang\protected\service\CourseCenterService.php
public function saveCourseReview( $args )
{
if ( !$args[ "courseID" ] || !$args[ "courseCatalogID" ] )
return false;
$attributes = array();
$attributes[ "courseID" ] = $args[ "courseID" ];
$attributes[ "courseCatalogID" ] = $args[ "courseCatalogID" ];
$attributes[ "name" ] = $args[ "name" ];
$courseCenterHybrid = new CourseCenterHybrid();
if ( $reviewID = $courseCenterHybrid->saveCourseReview( $attributes ) ) {
if ( $args[ "courseCatalogID" ] && $args[ "path" ]) {
$this->_saveQinniu( $args[ "path" ], $args[ "courseID" ], $args[ "courseCatalogID" ] );
}
}
return $reviewID;
}
public function _saveQinniu( $fileName, $courseID, $courseCatalogID = null)
{
if ( !IS_QINIU_UPLOAD )
return false;
$newDir = "content/coursecenter/" . ( ( $courseID >> 24 ) & 0xff ) . "/" . ( ( $courseID >> 16 ) & 0xff ) . "/" .
( ( $courseID >> 8 ) & 0xff ) . "/" . $courseID;
if($courseCatalogID)
$newDir.="/".$courseCatalogID;
$newDir.="/" . abs( Uniq::id( 1, 1 ) ); // content/coursecenter/0/0/0/53/246/117539872
$fileExt = FileUtils::getExtension( $fileName ); // .mp4
$uniquePath = $newDir . '.' . $fileExt; // content/coursecenter/0/0/0/53/246/117539872.mp4
$qiniu = new QINIU();
$bucket = WK::QINIU_BUCKET;
$bucket_tmp = WK::QINIU_TMP_BUCKET;
Qiniu_setKeys( WK::QINIU_ACCESSKEY, WK::QINIU_SECRETKEY );
$client = new Qiniu_MacHttpClient( null );
$err = Qiniu_RS_Copy( $client, $bucket_tmp, $fileName, $bucket, $uniquePath );
if ( $err !== null ) {
return false;
} else {
if($courseCatalogID){
if($xtCourseReview = xtCourseReview::model()->findByAttributes(array("fdCourseID"=>$courseID,"fdCourseCatalogID"=>$courseCatalogID))){
$xtCourseReview->fdUrl = WK::QINIU_HOST . $uniquePath; // http://qn.cnweike.cn/content/coursecenter/0/0/0/53/246/166370560.mp4
$avInfo = QiniuService::factory()->getAvInfo(WK::QINIU_HOST.$uniquePath);
if($avInfo)
$xtCourseReview->fdDuration = floor($avInfo->format->duration);
$xtCourseReview->save();
}
}else
xtCourse::model()->updateByPk( $courseID, array( "fdVideo" => WK::QINIU_HOST . $uniquePath) );
if ( $fileExt != 'swf' )
$res = $this->_qiniuPfop( $uniquePath, $courseID,$courseCatalogID );
return $res ? true : false;
}
}
```
## 重點片段實現過程
1、彈出窗口，上傳視頻到七牛云；
2、點擊確認上傳按鈕，在頁面上生成一條添加記錄，寫入`tbCourseReview`表；
```sql
CREATE TABLE `tbCourseReview` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fdCourseID` int(11) DEFAULT NULL COMMENT '課程ID',
`fdCourseCatalogID` int(11) DEFAULT NULL COMMENT '課程章節id',
`fdName` varchar(255) DEFAULT NULL COMMENT '視頻名稱',
`fdUrl` varchar(255) DEFAULT NULL COMMENT '回放視頻地址',
`fdDuration` int(11) DEFAULT NULL COMMENT '回放視頻時長，單位是秒',
`fdThumb` varchar(255) DEFAULT NULL COMMENT '回放視頻封面截圖',
`fdPersistentId` varchar(255) DEFAULT NULL COMMENT '七牛轉碼隊列ID',
`fdCreate` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fdCourseID` (`fdCourseID`),
KEY `fdCourseCatalogID` (`fdCourseCatalogID`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='直播視頻回放';
```
參考方法 \courseCenter\controllers\CourseController->actionReviewUpload
每次上傳都新增1條記錄，排序值取最大的排序值+1
3、新增刪除重點片段的接口
4、新增排序接口
? 參數：
? 方向：1往下 0 往上
? 當前重點片段視頻 ID
? 被調整的片段視頻 ID
?
- 說明
- 開發任務
- 星課-真光
- 課表
- Excel Down
- 調課
- 課表修改
- 課表代碼分析
- 課堂
- 課堂：應用商店通信管理協議
- 教師賬號強制綁定手機或郵箱
- 強制綁定手機和修改密碼的規則
- 學堂
- 課程學習：討論功能
- 后臺：課程討論管理
- 課程直播接口
- 學習統計功能(舊版)
- 學習統計功能(新版)
- 同步課程統計功能
- 同步課程編輯-新增視頻
- 第三方接口
- 學科網
- 安徽第三方
- 大賽
- 管控系統
- 日志管理
- 設備日志
- 平板接口
- 渝教
- 教學總結
- 空白目錄
- Yii 1.1
- 學堂架構
- Yii 1.1一些方法的解讀
- MVCS結構
- 基礎使用語法
- 創建1個新模塊
- 關聯模型
- CDbCriteria
- 學生-課堂記錄
- 學生端頁面展示
- 教師端頁面展示
- 編輯課程文檔
- SQL
- 課堂項目運行入口
- 上傳資源示意圖
- 行為
- PHPStorm
- 源碼閱讀
- 會診答卷頁面
- 考點練習
- 資源首頁
- 同步課程
- 同步課程：章節信息
- 升學復習
- 統計圖-范例
- 模塊
- 非法詞
- 服務層
- MongoDB類
- 學堂作答記錄從Mongo新集合獲取數據
- MongoYii
- 錯題集
- 小技巧
- 完善資料
- 郵件發送
- K12
- JSpang視頻課程
- MongoDB
- 創業
- 項目
- 包包