📄 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 + -