?? mng_course_edit.php
字號:
<?php session_start(); if(!$_SESSION['teacher']) {echo '<SCRIPT LANGUAGE="JavaScript">location.replace(\'mng.php\');</script>';exit;}?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>EasyTeacher信息技術課堂教學助手(ItAssis)-課程資源編輯</title>
<link href="et.css" rel="stylesheet" type="text/css">
<style type="text/css">body,td,th {font-size: 14px;}</style>
</head>
<body>
<p align="center">課程資源編輯</p>
<?php
include "conn.inc.php";
include "config.inc.php";
include "ItAssisFC/FLib.php";
$db=Connect_db($CFG_DB_ADDRESS,$CFG_DB_PORT,$CFG_DB_NAME,$CFG_DB_OWNER,$CFG_DB_PWD);
$course_type=array("教材","章","節","課程");
//數據操縱部分___________________________________
//若位置標志不為空，則表明要操縱數據庫
//操作類型：添加、刪除、修改
if(isset($_POST['action'])){
if($_POST['action']=="添加"){
list($adjust_cid,$adjust_turn)=split(",",$_POST['adjust_pos']);
$type=$_POST['type'];
$suit=$_POST['suit'];
$title=trim($_POST['title']);
$intruduce=trim($_POST['intruduce']);
if(!$title) $title="空標題";
if(!$intruduce) $intruduce="";
if(!trim($_POST['url_tch'])) $url_tch="";else $url_tch=trim($_POST['url_tch']);
if(!trim($_POST['url_stu'])) $url_stu="";else $url_stu=trim($_POST['url_stu']);
//將所有順序號大于指定順序的記錄增加1（即顯示順序向后調）
$sql="UPDATE course SET turn=turn+1 WHERE turn>$adjust_turn";
mysql_query($sql,$db) or die($sql."<br>".mysql_error());
$sql="INSERT INTO course(type,suit,title,turn,url_tch,url_stu,intruduce)";
$sql.=" VALUES($type,$suit,\"$title\",$adjust_turn+1,\"$url_tch\",\"$url_stu\",\"$intruduce\")";
mysql_query($sql,$db) or die($sql."<br>".mysql_error());
if($type==3){//創建課程目錄
@chdir($CFG_TASK_DIR) or die("<span class=red>生成課程目錄失敗！原因是權限不夠，請手工修改目錄權限{$CFG_TASK_DIR}為0777。</span>");
if(!is_dir(mysql_insert_id())) mkdir(mysql_insert_id(),0777) or die(error_reporting(E_ALL));
}
echo "<h3 align=center>“".$title."”添加成功！</h3>";
Auto_close_page(2);
Refresh_parent_page();
exit;
}else if($_POST['action']=="修改"){
list($cid,$turn)=split(",",$_POST['current_pos']);
list($adjust_cid,$adjust_turn)=split(",",$_POST['adjust_pos']);
$type=$_POST['type'];
$suit=$_POST['suit'];
$title=trim($_POST['title']);
$intruduce=trim($_POST['intruduce']);
if(!$title) $title="空標題";
if(!$intruduce) $intruduce="";
if(!trim($_POST['url_tch'])) $url_tch=""; else $url_tch=trim($_POST['url_tch']);
if(!trim($_POST['url_stu'])) $url_stu=""; else $url_stu=trim($_POST['url_stu']);
//生成課程目錄***********************************************
$sql="select type,cid,title from course where cid=$cid";
$result=mysql_query($sql,$db) or die($sql."<br>".mysql_error());
$array=mysql_fetch_array($result);
$old_type=$array['type'];
$old_dir_name=$array['cid'];
$old_title=$array['title'];
if($old_type==3 && $type!=3){//若由課程資源調整為非課程資源,則需要刪除原目錄
@chdir($CFG_TASK_DIR) or die("生成課程目錄失敗！原因是權限不夠，請手工修改目錄權限{$CFG_TASK_DIR}為0777。");
if(is_dir($old_dir_name))
if(!rmdir($old_dir_name)){//空目錄就刪除
echo "
<p>失敗：為保護系統，課程“".$title."”對應目錄 $old_dir_name 不能直接刪除,因為里面還有學生作業。</p>
<p>你只能將“ $old_title ”課程下所有作業刪除后才能刪除該課程。</p>
<p>(如果該課程下有作業未改，還必須改完后才可以刪除該課程下文件)。</p>";
exit;
}
}else if($old_type!=3 && $type==3){//若調整后為課程資源,則需要建立新目錄
@chdir($CFG_TASK_DIR) or die("生成課程目錄失敗！原因是權限不夠，請手工修改目錄權限{$CFG_TASK_DIR}為0777。");
if(is_dir($cid))
echo "<p>提醒：“ $title ”需要的對應 $cid 目錄已存在。不過不影響系統運行。</p>";
else{
if(mkdir($cid,0777))
echo "<p align=center>報告：建立“ $title ”對應目錄 $cid 成功！請檢查權限</p>";
else
echo "<p align=center>失敗：建立“ $title ”對應目錄 $cid 失敗！請檢查權限</p>";
}
}
//有位置變化則調整其他記錄位置*****************************開始
//位置無變化有兩中情況：調整后位置是依然是自身或者選擇不作調整
if($adjust_cid!="NONE" && $adjust_cid!=$cid){
if($turn>$adjust_turn){
$sql="UPDATE course SET turn=turn+1 WHERE turn>=$adjust_turn+1 and turn<=$turn";//向前調整
$turn=$adjust_turn+1;
}else{
$sql="UPDATE course SET turn=turn-1 WHERE turn>=$turn and turn<=$adjust_turn";//向后調整
$turn=$adjust_turn;
}
mysql_query($sql,$db) or die($sql."<br>".mysql_error());
}
//插入位為頂端位置需修正 (為0，所以要加1)
if(!$adjust_cid) $turn=$adjust_turn+1;
$sql="UPDATE course";
$sql.=" SET type=$type,suit=$suit,title=\"$title\",url_tch=\"$url_tch\",url_stu=\"$url_stu\",turn=$turn,intruduce=\"$intruduce\"";
$sql.=" WHERE cid=$cid";
mysql_query($sql,$db) or die($sql."<br>".mysql_error());
//有位置變化則調整其他記錄位置*****************************結束
echo "<h3 align=center>“ $title ”修改成功！</h3>";
Auto_close_page(2);
Refresh_parent_page();
exit;
}else if($_POST['action']=="刪除"){
$title=$_POST['title'];
list($cid,$turn)=split(",",$_POST['current_pos']);
//刪除空的課程目錄
@chdir($CFG_TASK_DIR) or die("<span class=red>刪除課程目錄失敗！原因是權限不夠，請手工修改目錄權限{$CFG_TASK_DIR}為0777。</span>");
if(is_dir($cid))
if(@!rmdir($cid) && !isset($_POST['sure_del'])){
echo "
<div align=center><p class=red>警告：課程“ $title ”中有作業<br><br>
而且<strong>課程刪除后將永遠不能恢復</strong>,與課程關聯的作業也將丟失課程標題</class></p>
<a href=\"\" onClick=\"javascript:self.close();\">取消操作</a>
<a href={$_SERVER['PHP_SELF']}?{$_SERVER['QUERY_STRING']}&sure_del=Y>確認刪除</a>
</div>";
exit;
}
$sql="DELETE FROM course";
$sql.=" WHERE cid=$cid";
mysql_query($sql,$db) or die($sql."<br>".mysql_error());
$sql="UPDATE course SET turn=turn-1 WHERE turn>$turn";
mysql_query($sql,$db) or die($sql."<br>".mysql_error());
echo "<h3 align=\"center\">“".$_POST['title']."”刪除成功！</h3>";
Auto_close_page(2);
Refresh_parent_page();
exit;
}
}
//界面數據部分___________________________________
if(isset($_GET['current_pos'])) list($cid,$turn)=split(",",$_GET['current_pos']);
if(isset($_POST['current_pos']))list($cid,$turn)=split(",",$_POST['current_pos']);
$sql="SELECT * FROM course WHERE cid=$cid";
$result = mysql_query($sql,$db) or die($sql."<br>".mysql_error());
$array=mysql_fetch_array($result);
$cid=$array['cid'];
$type=$array['type'];
$suit=$array['suit'];
$title=$array['title'];
$turn=$array['turn'];
$url_tch=$array['url_tch'];
$url_stu=$array['url_stu'];
$intruduce=$array['intruduce'];
if(isset($_GET['action']) && $_GET['action']=="new") $type=$_GET['type'];
?>
<?php //界面顯示___________________________________?>
<form name="form1" method="POST" action="">
<table width="446" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#DEE3EF">
<tr>
<td><div align="right">教學資源類型：</div></td>
<td><select name="type">
<option value="<?php echo $type?>"><?php echo $course_type[$type] ?></option>
<?php
while(list($type,$type_name)=each($course_type))
echo "<option value=$type>$type_name</option>";?>
</select>
</td>
</tr>
<tr>
<td><div align="right">資源適用年級：</div></td>
<td><select name="suit">
<?php if($suit)echo "<option value=$suit>$suit 年級</option>"; ?>
<?php for($i=$CFG_USER_START_GRADE;$i<=$CFG_USER_END_GRADE;$i++) echo "<option value=$i>$i 年級</option>";?>
</select></td>
</tr>
<tr>
<td width="138"><div align="right">教學資源名稱：</div></td>
<td width="284"><input name="title" type="text" size="40" value="<?php echo $title ?>"></td>
</tr>
<tr valign="top">
<td><div align="right">教案鏈接地址<span class="red">http://</span></div></td>
<td><input name="url_tch" type="text" size="40" value="<?php echo $url_tch ?>">
<span class="樣式1"><br>
注：多個地址用西文逗號格開。</span></td>
</tr>
<tr valign="top">
<td><div align="right">學案鏈接地址<span class="red">http://</span></div></td>
<td><input name="url_stu" type="text" size="40" value="<?php echo $url_stu ?>">
<br>
<span class="樣式1">注：多個地址用西文逗號格開。</span></td>
</tr>
<tr>
<td><div align="right">將順序安排到：</div></td>
<td><select name="adjust_pos">
<?php
if(isset($_GET['action'])&&$_GET['action']=="adjust" || isset($_POST['submit']))
echo "<option value=NONE,NONE>**不作調整**</option>";
else
{if($cid!=0 && $turn!=0)echo "<option value=$cid,$turn>$title</option>";}
echo "<option value=0,0>**頂端**</option>";
$rsc_array=Read_course_List2($db);
while($array=array_shift($rsc_array)){
$cid=$array['cid'];
$type=$array['type'];
$title=$array['title'];
$turn=$array['turn'];
if($type==0) echo"<option value=$cid,$turn>$title</option>";
else if($type==1) echo"<option value=$cid,$turn> ¶$title</option>";
else if($type==2) echo"<option value=$cid,$turn> ¶¶$title</option>";
else if($type==3) echo"<option value=$cid,$turn> ¶¶¶$title</option>";
}?>
</select>
后</td>
</tr>
<tr>
<td><div align="right">簡介：</div></td>
<td><textarea name="intruduce" cols="38" rows="6"><?php echo $intruduce ?></textarea></td>
</tr>
</table>
<p align="center">
<?php
if($_GET['action']=="new")
echo "<input type=\"submit\" name=\"action\" value=\"添加\">";
else
echo "
<input type=submit name=action value=修改>
<input type=submit name=action value=刪除>";
?>
<input type=hidden name="current_pos" value="<?php echo $_GET['current_pos'] ?>">
<input type=button value="關閉" onClick="javascript:self.close();">
<p>
</form>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -