getCourseUnitinfoById PHP Code Examples

Example #1

0

Show file

File: courseUnit4course.php Project: Eidn/shanghai

 $arr = $mysql->fetch_array($res);
 //选出所有关于这个单元的版本记录
 $ids = substr($arr["courseunitversionids"], 1, -1);
 //这个单元版本号的字符串
 //die("select * from coursegroup_rel_courseunitversion where coursegroupid=".$_GET["catid"]);
 $res = $mysql->query("select * from courseunitversion_rel_attachment where deleted=0 and id in ({$ids}) order by time desc");
 //选出目录下所包含的所有课程单元版本
 $courseunitArr = array();
 while ($arr = $mysql->fetch_array($res)) {
     //得到courseunitversion_rel_attachment表中的一列
     //**获取lp_id**
     $lp_id = $arr["lpid"];
     //**获取附件信息，如果是普通文件，则供下载使用**
     $lesson_attachment = getAttachmentinfoById($arr["attachmentid"]);
     //获得课程单元名称**
     $lesson_courseunitInfo = getCourseUnitinfoById($arr["courseunitid"]);
     $lesson_courseunitName = $lesson_courseunitInfo["title"];
     //获得课程单元版本名称**
     $lesson_courseunitversionName = $arr["versionname"];
     //获得课程单元版本类型**
     $lesson_packageType = $arr["lpid"] ? "SCORM/AICC" : "普通文件";
     //获得各种学习过程信息
     if ($lesson_packageType != "SCORM/AICC") {
         //非"SCORM/AICC"课件，无学习过程
         $lesson_status = "无状态";
         //学习状态：无状态、未学习、进行中、已完成
         $lesson_total_time = 0;
         //学习时间
         $lesson_score = 0;
         //分数
         $lesson_view_count = 0;

Example #2

0

Show file

File: courseUnit_for_courseCategory.php Project: Eidn/shanghai

<!--   Begin Of script Output   -->
<div id="content" class="maxcontent">

	<div id="content_with_menu">
		<div id="container">
		
			<div class="info">课程单元列表 &nbsp; <a href="javascript:;" onclick="setIframeSrc(13);"><img src="../img/add.jpg" width="15" title="添加课程单元" alt="添加课程单元"></a></div>
			<div class="list_courseUnit">
			<ul>
			<?php 
$ids = substr($courseUnitVersionIds, 1, -1);
//die("select * from courseunit where deleted=0 and id in ($ids) order by time desc");
$res = $mysql->query("select * from courseunitversion_rel_attachment where deleted=0 and id in ({$ids}) order by time desc");
//$courseunitArr = Array();
while ($arr = $mysql->fetch_array($res)) {
    $courseunitinfo = getCourseUnitinfoById($arr["courseunitid"]);
    //通过版本获取课程单元的信息
    echo "<li><span><a href='javascript:;' onclick='if(confirm(\"确定要移除吗？\")){f_remove(341," . $arr["id"] . ",{$catid});\$(this).parent().parent().remove();}'><img src='../img/delete.png'></a></span><a href='courseUnitShow.php?id=" . $courseunitinfo["id"] . "'>" . $courseunitinfo["title"] . "(" . $arr["versionname"] . ")" . "</a></li>";
}
?>
			</ul>
			</div>			
		</div>
		<div class="actions" style="display:none">
			<a href="courseSetting.php?id=<?php 
echo $id;
?>
">设置</a>
		</div>
	</div>
</div> <div class="clear">&nbsp;</div> <!-- 'clearing' div to make sure that footer stays below the main and right column sections -->

Example #3

0

Show file

File: courseUnit_for_course.php Project: Eidn/shanghai

			<div class="info">【<?php 
echo $_GET["title"];
?>
】所含有的课程单元列表 &nbsp; <a href="javascript:;" onclick="setIframeSrc(13);"><img src="../img/add.jpg" width="15" title="添加课程单元" alt="添加课程单元"></a></div>
			<div class="list_courseUnit">
			<ul>
			<?php 
$ids = substr($courseUnitVersionIds, 1, -1);
//die("select * from courseunit where deleted=0 and id in ($ids) order by time desc");
$res = $mysql->query("select * from courseunitversion_rel_attachment where deleted=0 and id in ({$ids}) order by time desc");
echo "select * from courseunitversion_rel_attachment where deleted=0 and id in ({$ids}) order by time desc";
die;
$courseunitArr = array();
while ($arr = $mysql->fetch_array($res)) {
    if (@$courseunitArr[$arr["courseunitid"]]["id"] == "") {
        $courseunitArr[$arr["courseunitid"]] = getCourseUnitinfoById($arr["courseunitid"]);
    }
    if ($courseunitArr[$arr["courseunitid"]]["lpid"]) {
        echo "<li><span><a href='javascript:;' onclick='if(confirm(\"确定要移除吗？\")){f_remove(341," . $arr["id"] . ",{$_GET['id']});\$(this).parent().parent().remove();}'><img src='../img/delete.png'></a></span><a href='scormShow.php?id=" . $courseunitArr[$arr["courseunitid"]]["lpid"] . "' target='_blank'><img src='../img/scorm.png' width='25' title='Scorm'>" . $courseunitArr[$arr["courseunitid"]]["title"] . "</a></li>";
    } else {
        echo "<li><span><a href='javascript:;' onclick='if(confirm(\"确定要移除吗？\")){f_remove(341," . $arr["id"] . ",{$_GET['id']});\$(this).parent().parent().remove();}'><img src='../img/delete.png'></a></span><a href='courseUnitShow.php?id=" . $courseunitArr[$arr["courseunitid"]]["id"] . "'>" . $courseunitArr[$arr["courseunitid"]]["title"] . "</a></li>";
    }
}
?>
			</ul>
			</div>

			
			<div class="list_courseUnit">
			<ul>
			<?php

Example #4

0

Show file

File: getcoursetree.php Project: Eidn/shanghai

function getCourseUnitsByCategoryid($userid, $categoryid)
{
    //通过用户id和目录id获取目录下的带有状态的课程单元，返回课程单元数组
    $courseunits = array();
    global $mysql;
    //从该节点中选出所有课程单元版本
    $res = $mysql->query("select * from courseversion_rel_courseunitversion where coursecategoryid=" . $categoryid);
    $arr = $mysql->fetch_array($res);
    //选出所有关于这个单元的版本记录
    $ids = substr($arr["courseunitversionids"], 1, -1);
    //这个单元版本号的字符串
    //die("select * from coursegroup_rel_courseunitversion where coursegroupid=".$_GET["catid"]);
    $res = $mysql->query("select * from courseunitversion_rel_attachment where deleted=0 and id in ({$ids}) order by time desc");
    //选出目录下所包含的所有课程单元版本
    $courseunitArr = array();
    while ($arr = $mysql->fetch_array($res)) {
        //得到courseunitversion_rel_attachment表中的一列
        //**获取lp_id**
        $lp_id = $arr["lpid"];
        //**获取附件信息，如果是普通文件，则供下载使用**
        $lesson_attachment = getAttachmentinfoById($arr["attachmentid"]);
        //获得课程单元名称**
        $lesson_courseunitInfo = getCourseUnitinfoById($arr["courseunitid"]);
        $lesson_courseunitName = $lesson_courseunitInfo["title"];
        //获得课程单元版本名称**
        $lesson_courseunitversionName = $arr["versionname"];
        //获得课程单元版本类型**
        $lesson_packageType = $arr["lpid"] ? "SCORM/AICC" : "普通文件";
        //获得各种学习过程信息
        if ($lesson_packageType != "SCORM/AICC") {
            //非"SCORM/AICC"课件，无学习过程
            $lesson_status = "无状态";
            //学习状态：无状态、未学习、进行中、已完成
            $lesson_total_time = 0;
            //学习时间
            $lesson_score = 0;
            //分数
            $lesson_view_count = 0;
            //学习次数
            $lesson_lastview_time = 0;
            //最后访问日期
            $lesson_remarks = "";
            //备注
            $href = $lesson_attachment["indexfile"] == "" ? $lesson_attachment["path"] : $lesson_attachment["indexfile"];
            $courseunit["name"] = $lesson_courseunitName . "(" . $lesson_courseunitversionName . ")";
            $courseunit["status"] = $lesson_status;
            $courseunit["totaltime"] = vtime($lesson_total_time);
            $courseunit["score"] = $lesson_score;
            $courseunit["viewcount"] = $lesson_view_count;
            $courseunit["lasttime"] = $lesson_lastview_time;
            $courseunit["remark"] = $lesson_remarks;
            $courseunit["itemurl"] = "<a href='" . $href . "'><img src='../img/down.gif' alt='下载' title='下载'></a>";
            $courseunits[] = $courseunit;
        } else {
            //"SCORM/AICC"课件，可记录学习状态
            $lesson_status = "";
            //学习状态：无状态、未学习、进行中、已完成（lp_item_view表中参数）
            $lesson_total_time = 0;
            //学习时间（lp_item_view表中参数）
            $lesson_score = 0;
            //*分数*由于每个item里都有一个分数，故暂时不知道用哪个分数；分数是什么意思
            $lesson_view_count = 0;
            //学习次数（lp_view表中参数）
            $lesson_lastview_time = 0;
            //最后访问日期（lp_item_view表中参数）
            $lesson_remarks = "";
            //*备注*
            //根据userid和lp_id获得lp_view表中的id；
            $res_lp_view = $mysql->query("select * from lp_view where lp_id= {$lp_id} and user_id = {$userid} ");
            $arr_lp_view = $mysql->fetch_array($res_lp_view);
            $lp_view_id = $arr_lp_view["id"];
            if ($lp_view_id) {
                //已经学习过该lp，则开始获取所有lp_item_view的信息（一个或多个）
                //根据lp_view_id获得lp_item_view表中所有的lp_item_view信息
                $res_lp_item_view = $mysql->query("select * from lp_item_view where lp_view_id= {$lp_view_id} ");
                //根据每个lp_item_view的status判断lp中尚未完成的个数，如果存在尚未完成的item,则$lesson_status=incompeled
                $incompleted_count = 0;
                //该lp中status为尚未完成的item个数；
                while ($arr_lp_item_view = $mysql->fetch_array($res_lp_item_view)) {
                    //依次取出lp_item_view信息
                    //$lesson_status
                    $lesson_item_status = $arr_lp_item_view["status"];
                    //当前这个item的status
                    if ($lesson_item_status != 'completed' && $lesson_item_status != 'complete') {
                        //如果该item尚未完成
                        $incompleted_count++;
                    }
                    //$lesson_total_time
                    $lesson_total_time += $arr_lp_item_view["total_time"];
                    //当前这个item的total_time
                    //$lesson_view_count
                    $lesson_view_count = $arr_lp_item_view["view_count"];
                    //lp_view表中的view_count
                    //$lesson_lastview_time;
                    $lesson_lastview_time = date('Y-m-d H:i:s', $arr_lp_item_view["start_time"]);
                    //当前这个item的上次访问时间
                }
                if ($incompleted_count != 0) {
                    //如果存在尚未完成的item
                    $lesson_status = "进行中";
                } else {
                    //所有lp_item_view都达到completed状态
                    $lesson_status = "已完成";
                }
            } else {
                //尚未学习过该lp，则$lesson_status=尚未学习
                $lesson_status = "未学习";
            }
            $courseunit["name"] = $lesson_courseunitName . "(" . $lesson_courseunitversionName . ")";
            $courseunit["status"] = $lesson_status;
            $courseunit["totaltime"] = vtime($lesson_total_time);
            $courseunit["score"] = $lesson_score;
            $courseunit["viewcount"] = $lesson_view_count;
            $courseunit["lasttime"] = $lesson_lastview_time;
            $courseunit["remark"] = $lesson_remarks;
            $courseunit["itemurl"] = "<a href=\"javascript:void(0);\" onclick=\"LaunchDueItem({$arr['lpid']})\" target=\"_blank\"><img src=\"../img/look.gif\" alt=\"查看\" title=\"查看\"></a>";
            $courseunits[] = $courseunit;
        }
    }
    return $courseunits;
}

PHP getCourseUnitinfoById Examples