course/editCourse.php at master · domark0721/course · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
<?php
	//編輯課程內容、章節、影片與文字教材

	include_once('api/auth.php');
	include_once("mongodb.php");
	include_once("mysql.php");
	include_once('api/isLogin.php');

	session_start();
	$_SESSION['url'] = $_SERVER['REQUEST_URI'];

	$course_id = $_GET['course_id'];

	//metadata from mysql
	$sql = "SELECT * FROM course WHERE course_id='$course_id'";
	$result = mysql_query($sql);

	$courseMetadata = mysql_fetch_assoc($result);
	// var_dump($courseMetadata);

	$mongoQuery = array('course_id' => (int)$course_id);
	$mon = $collection -> find($mongoQuery);

	foreach($mon as $data){
		$courseData = $data;
		break;
	}

	$contentData = $courseData['content'];
	// var_dump($courseData);
	// exit;
?>
<!doctype html>
<html>
	<head>
		<?php require("meta_com.php"); ?>
		<link type="text/css" rel="stylesheet" href="css/editCourse.css">
		<title>課程內容編輯 - NUCourse</title>
	</head>
	<body>
		<div class="totalWrapper">
			<?php require("header.php"); ?>
			<div class="container">
				<div id="courseBar">
					<div id="courseBarPosition" class="clearfix">
						<div class="content-wrap">
							<div id="coursePic">
								<img src="<?php echo $courseMetadata['pic'];?>">
							</div>
							<div id="courseHeader">
								<div id="courseName"><?php echo $courseMetadata['course_name'];?></div>
								<div id="courseTeacher"><?php echo $courseMetadata['teacher_name'];?></div>
							</div>
						</div>
					</div>
				</div>
				<div class="edit-wrap clearfix">
					<div id="leftPanel">
						<a id="saveCouseBtn" class="panelBtn save">儲 存</a>
						<a class="panelBtn giveup" href="temode.php">離 開</a>
						<div id="saveStatus"></div>
						<a class="addChapterBtn"><i class="fa fa-plus"></i> 新增單元</a>
						<ul class="chapterList">
						<?php
						    $editWrapId = 0;
							foreach($contentData['chapters'] as $i => $chapter){
								$chapterNo = sprintf("CH%d: ", $i+1);
						?>
								<li class="chapter">
									<div class="chapterItem">
										<i class="fa fa-bookmark-o"></i>
										<span class="chapterNo"><?php echo $chapterNo;?></span>
										<span class="chapterName"><?php echo $chapter['name']; ?></span>
										<span class="chapter-btns">
											<a class="deleteChapterBtn"><i class="fa fa-trash-o"></i></a>
											<a class="addSectionBtn" data-chapter-id="<?php echo $i+1;?>"><i class="fa fa-plus-circle"></i></a>
											<a class="editChapterName"><i class="fa fa-pencil"></i></a>
										</span>
									</div>
									<ul class="sectionList">
									<?php
									foreach($chapter['sections'] as $j => $section){
										$sectionNo = sprintf("%d-%d: ", $i+1, $j+1);
									?>
										<li class="section">
											<a class="sectionItem" href="<?php echo '#editWrap' .($editWrapId++); ?>">
												<span class="sectionNo"><?php echo $sectionNo;?></span>
												<span class="leftSectionName"><?php echo $section['name'];?></span>
												<div class="chapter-btns">
													<span class="deleteSectionBtn"><i class="fa fa-trash-o"></i></span>
												</div>
											</a>
										</li>

									<?php } ?>
									</ul>
								<?php } ?>
								</li>

						</ul>
					</div>
					<div class="noSelectSection_wrap">
						<span class="noSelectSection">請點擊左側的章節或是新增一個章節</span>
					</div>
					<div id="rightPanel">
					<?php
					    $editWrapId = 0;
						foreach($contentData['chapters'] as $i => $chapter){
							foreach($chapter['sections'] as $j => $section){
					?>
						<div id="<?php echo "editWrap". ($editWrapId);?>" class="sectionEditWrap" >
							<div class="sectionName">
								<label for="sectionName">章節名稱</label>
								<input class="sectionNameInput section-name" name="sectionName" value="<?php echo $section['name'];?>">
							</div>
							<div class="sectionVideo">
								<label for="sectionVideo">章節影片</label>
								<form enctype="multipart/form-data" action="api/videoUpload.php" method="POST">
									<input type="file" name="uploadFile" class="section-video">
								</form>
								<div id="video">
									<video controls preload="none">
									<!-- <?php echo "videos/" . $section['video'];?>" -->
									<source src="<?php echo $section['video'];?>"  type="video/mp4">
									Your browser does not support the video tag.
									</video>
								</div>
							</div>
							<div class="sectionEditorWrap">
								<label for="sectionContent">文字教材內容</label>
								<textarea id="tinyMce_<?php echo $editWrapId++;?>" class="sectionEditor section-content" style="width:100%"><?php echo $section['content'];?></textarea>
							</div>
							<input type="hidden" class="section-uid" value="<?php echo $section['uid']?>">
						</div>
				    <?php
							}
						}
					?>
		<!-- 			    <div id="sec1-1" class="sectionEditWrap">
							<div class="sectionName">
								<label for="sectionName">章節名稱</label>
								<input class="sectionNameInput" name="sectionName" val="">
							</div>
							<div class="sectionVideo">
								<label for="sectionVideo">章節影片</label>
								<input type="file" name="sectionVideo">
								<div id="video">
								<video controls >
								  <source src="videos/" type="video/mp4">
								  Your browser does not support the video tag.
								</video>
							</div>
							</div>
							<div class="sectionEditorWrap">
								<label for="section1">章節內容</label>
								<textarea class="sectionEditor" name="section1" style="width:100%" val=""></textarea>
							</div>
						</div> -->

					</div>
				</div>
			</div>
			<?php require("footer.php"); ?>
		</div>
		<?php require("js/js_com.php"); ?>

        <!-- hidden param -->
        <input type="hidden" id="course_id" value="<?php echo $course_id;?>"/>
		<script type="text/javascript" src="js/tinymce/tinymce.min.js"></script>
		<script type="text/javascript" src="js/editCourse.js"></script>
	</body>
</html>