本文整理汇总了PHP中EfrontLesson::countLessonUsers方法的典型用法代码示例。如果您正苦于以下问题:PHP EfrontLesson::countLessonUsers方法的具体用法?PHP EfrontLesson::countLessonUsers怎么用?PHP EfrontLesson::countLessonUsers使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类EfrontLesson
的用法示例。
在下文中一共展示了EfrontLesson::countLessonUsers方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: count
if (isset($infoLesson)) {
try {
$result = eF_getTableData("user_times ut join users_to_lessons ul on ut.users_LOGIN=ul.users_LOGIN and ut.lessons_ID=ul.lessons_ID", "sum(time) as sum, count(distinct ul.users_LOGIN) as count", "completed=1 and ul.archive=0 and ut.lessons_ID=" . $infoLesson->lesson['id'], "", "");
if ($result[0]['sum']) {
$smarty->assign("T_AVERAGE_COMPLETION_TIME", EfrontTimes::formatTimeForReporting($result[0]['sum'] / $result[0]['count']));
}
require_once $path . "includes/statistics/stats_filters.php";
$directionsTree = new EfrontDirectionsTree();
$directionsPaths = $directionsTree->toPathString();
$roles = EfrontLessonUser::getLessonsRoles(true);
$smarty->assign("T_ROLES_ARRAY", $roles);
$rolesBasic = EfrontLessonUser::getLessonsRoles();
$smarty->assign("T_BASIC_ROLES_ARRAY", $rolesBasic);
foreach ($rolesBasic as $key => $role) {
$constraints = array('archive' => false, 'table_filters' => $stats_filters, 'condition' => 'ul.user_type = "' . $key . '"');
$numUsers = $infoLesson->countLessonUsers($constraints);
if ($numUsers) {
$usersPerRole[$key] = $numUsers;
}
//$role == 'student' ? $studentRoles[] = $key : $professorRoles[] = $key;
}
$infoLesson->lesson['users_per_role'] = $usersPerRole;
$infoLesson->lesson['num_users'] = array_sum($usersPerRole);
/*
$constraints = array('archive' => false, 'table_filters' => $stats_filters, 'condition' => 'ul.user_type in ("'.implode('","', $studentRoles).'")');
$infoLesson -> lesson['num_students'] = ($infoLesson -> countLessonUsers($constraints));
$constraints = array('archive' => false, 'table_filters' => $stats_filters, 'condition' => 'ul.user_type in ("'.implode('","', $professorRoles).'")');
$infoLesson -> lesson['num_professors'] = ($infoLesson -> countLessonUsers($constraints));
*/
$infoLesson->lesson['category_path'] = $directionsPaths[$infoLesson->lesson['directions_ID']];
$smarty->assign("T_CURRENT_LESSON_INFO", $infoLesson);