示例#1
0
//print_r($am_type_name);

            switch($mid){
                case 1: section_activities($secid,$cid);break;
                case 2: set_activity_status($aid);break;
                case 3: set_activity_completiondate($aid);break;
                case 4: get_activity_status();break;
				case 5: get_student_sections($cid);break;
				case 6: add_student_to_watchlist($cid,$uid);break;
				case 7: get_loggedin_users_by_section($section);break;
				case 8: get_user_quiz_grade($aid,$uid);break;
				case 9: get_user_quiz_instance($aid);break;
				case 10: get_itemid_from_grade_table($aid,$am_type_name,$cid);break;
				case 11: get_course_absenties($cid);
				case 12: set_course_absenties($cid,$aid);
				case 13: getCntofAbsentActivities($sid,$cid);
				case 14:getStudentAttandanceofActivity($sid,$aid,$cid);
            }

            function section_activities($secid,$cid){
                $course=get_course($cid);
                $modinfo = get_fast_modinfo($course);
                $mods = $modinfo->get_cms();
                $sections = $modinfo->get_section_info_all();
                $sec_array = get_sections($sections);
                $arr = array();
                $cnt=0;

            //preparing an array which contains sections and activities
                foreach ($mods as $mod) {
                    $arr[$cnt++]=array('secid'=>$mod->section,'modid'=>$mod->id,'modname'=>$mod->name,'modcontent'=>$mod->content);
示例#2
0
function getWatchlistByCoursePdf($coursid){

    global $DB,$CFG; // Global Variables

    $context = get_context_instance(CONTEXT_COURSE, $coursid); // Getting Copurse context from courseid

    $students = get_role_users(5, $context); // Getting students of a course

    $course = $DB->get_record('course', array('id' => $coursid), '*', MUST_EXIST); // Getting course record

    $watlist= getAllWatchlistRecordByCourse($coursid,1); // calling lib method to get records of watchlisted



    $html='';

    $html .= "<table  class='watchlist-table1'><thead>
<tr><th>Roll No</th><th>Full Name</th><th>Rank</th><th>Department</th>
<th>Mean Grade</th><th>Todays Grade</th><th>Attendance</th></tr></thead><tbody id='wtbody'>";

    $html.= "<input  type='hidden' name='couid' value='$coursid'>";
    foreach ($watlist as $wlist) {

        $userobj = get_complete_user_data(id, $wlist->userid); // Getting User Object from userid
        $t=time(); //to get todays date time
        $yt=time()-86400; // to get yesterdays date
        $attandance=getCntofAbsentActivities($wlist->userid,$coursid);
        $sql="SELECT round(avg(finalgrade),2) as cumulativegrade FROM mdl_grade_grades where itemid in( select id from mdl_course_modules where course=$coursid and `completionexpected`<= $yt) and userid=$wlist->userid";
        $res=$DB->get_record_sql($sql); // to get all activies of a course till yesterday
        //var_dump($res);
        $sql1="SELECT  round(avg(finalgrade),2) as currentgrade , count(*) as reccount FROM mdl_grade_grades where itemid in(select id from mdl_course_modules where course=$coursid and `completionexpected`< $t and completionexpected >$yt) and userid=$wlist->userid ";
        $res1=$DB->get_record_sql($sql1); // todays completion courses

        // checking cumulative grade existance

            $pregrade=round(MeanGrade($coursid,$wlist->userid),2)+0.00;
        //$pregrade='A';


            $pragrade=round(TodaysGrade($coursid,$wlist->userid),2)+0.00;// checking Todays grade existance
        //$pragrade='B';

        $html.= "<tr>";
        $html.= "<td> <a href=" . $CFG->wwwroot . '/teacher/student_profile.php?sid=' . $wlist->userid . ">" . $userobj->profile['rollno'] . "</a></td><td><a href=" . $CFG->wwwroot . '/teacher/student_profile.php?sid=' . $wlist->userid . ">" . $userobj->firstname . "</a></td><td> " . $userobj->profile['eamcetrank'] . " </td><td> " . $userobj->profile['dept'] . " </td><td>$pregrade</td><td>$pragrade</td><td>".$attandance."</td></tr>";
    }
    $html .= "</tbody></table>";
    return $html;

}