function getAll($courseId)
{
$tblSection = new DB_Haodu_CourseSection();
$where = "where course_id={$courseId}";
$orderby = "order by seq asc";
return $tblSection->fetchAll("*", $where, $orderby);
}
/**
* 章节列表array('chapter_id'=> array(array(节信息))
*/
public function getSectionList($cid)
{
$tblSection = new DB_Haodu_CourseSection();
$list = $tblSection->fetchAll("id, video_id, course_id, parent_id as chapter_id, name, seq", "where course_id = {$cid} and parent_id > 0", "order by seq asc");
$tblVideo = new DB_Haodu_CourseVideo();
foreach ($list as &$section) {
$video = $tblVideo->fetchRow($section['video_id'], "duration");
$section['duration'] = $video['duration'];
$section['duration_fmt'] = sprintf("%'.02d", floor($video['duration'] / 60)) . ":" . sprintf("%'.02d", $video['duration'] % 60);
}
$list = $tblSection->map($list, "chapter_id");
return $list;
}
