# The LearningOnline Network with CAPA
# Handler to drop and add students in courses
#
# (Handler to set parameters for assessments
#
# (Handler to resolve ambiguous file locations
#
# (TeX Content Handler
#
# 05/29/00,05/30,10/11 Gerd Kortemeyer)
#
# 10/11,10/12,10/16 Gerd Kortemeyer)
#
# 11/20,11/21,11/22,11/23,11/24,11/25,11/27,11/28,
# 12/08,12/12 Gerd Kortemeyer)
#
# 12/26,12/27,12/28,
# 01/01/01,01/15 Gerd Kortemeyer
package Apache::londropadd;
use strict;
use Apache::lonnet;
use Apache::Constants qw(:common :http REDIRECT);
# ================================================================ Main Handler
sub handler {
my $r=shift;
if ($r->header_only) {
$r->content_type('text/html');
$r->send_http_header;
return OK;
}
# ----------------------------------------------------- Needs to be in a course
if (($ENV{'request.course.fn'}) &&
(&Apache::lonnet::allowed('cst',$ENV{'request.course.id'}))) {
# ------------------------------------------------------------------ Start page
$r->content_type('text/html');
$r->send_http_header;
$r->print(<<ENDHEAD);
<html>
<head>
<title>LON-CAPA Student Drop/Add</title>
</head>
<body bgcolor="#FFFFFF">
<img align=right src=/adm/lonIcons/lonlogos.gif>
<h1>Drop/Add Students</h1>
<form method="post" enctype="multipart/form-data"
action="/adm/dropadd" name="studentform">
<h2>Course: $ENV{'course.'.$ENV{'request.course.id'}.'.description'}</h2>
ENDHEAD
# --------------------------------------------------- Phase one, initial screen
unless ($ENV{'form.phase'}) {
$r->print(<<ENDUPFORM);
<input type=hidden name=phase value=two>
<hr>
<h3>Upload a courselist</h3>
<input type=file name=upfile size=50>
<br>Type: <select name=upfiletype>
<option value=csv>CSV (comma separated values, spreadsheet)</option>
<option value=space>Space separated</option>
<option value=tab>Tabulator separated</option>
<option value=xml>HTML/XML</option>
</select>
<p><input type=submit name=fileupload value="Upload Courselist">
<hr>
<h3>Enroll a single student</h3>
<p><input type=submit name=enroll value="Enroll Student">
<hr>
<h3>Drop a student</h3>
<p><input type=submit name=drop value="Drop Student">
ENDUPFORM
}
# ------------------------------------------------------------------- Phase two
if ($ENV{'form.phase'} eq 'two') {
if ($ENV{'form.fileupload'}) {
$ENV{'form.upfile'}=~s/\r/\n/gs;
$ENV{'form.upfile'}=~s/\f/\n/gs;
$ENV{'form.upfile'}=~s/\n+/\n/gs;
my $datatoken=$ENV{'user.name'}.'_'.$ENV{'user.domain'}.
'_enroll_'.$ENV{'request.course.id'}.'_'.time.'_'.$$;
{
my $fh=Apache::File->new('>'.$r->dir_config('lonDaemons').
'/tmp/'.$datatoken.'.tmp');
print $fh $ENV{'form.upfile'};
}
my $separator='';
my $remove='';
if ($ENV{'form.upfiletype'} eq 'csv') {
$separator='\"\,\s*\"';
$remove='"';
} elsif ($ENV{'form.upfiletype'} eq 'space') {
$separator='\s+';
} elsif ($ENV{'form.upfiletype'} eq 'tab') {
$separator='\t+';
} elsif ($ENV{'form.upfiletype'} eq 'xml') {
}
my @lines=split(/\n/,$ENV{'form.upfile'});
my $total=$#lines;
$ENV{'SERVER_NAME'}=~/(\w+\.\w+)$/;
my $krbdefdom=$1;
$krbdefdom=~tr/a-z/A-Z/;
my $today=time;
my $halfyear=$today+15552000;
my $defdom=$r->dir_config('lonDefDomain');
$r->print(<<ENDPICK);
<input type=hidden name=phase value=three>
<input type=hidden name=datatoken value="$datatoken">
<input type=hidden name=upfiletype value=$ENV{'form.upfiletype'}>
<hr>
<h3>Identify fields</h3>
Total number of records found in file: $total
<script>
function verify(vf) {
var founduname=0;
var foundpwd=0;
var foundname=0;
var foundid=0;
var foundsec=0;
var foundatype=0;
var tw;
var message='';
for (i=0;i<=vf.nfields.value;i++) {
tw=eval('vf.f'+i+'.selectedIndex');
if (tw==1) { founduname=1; }
if ((tw>=2) && (tw<=6)) { foundname=1; }
if (tw==7) { foundid=1; }
if (tw==8) { foundsec=1; }
if (tw==9) { foundpwd=1; }
}
if (founduname==0) {
alert('You need to specify at least the username field');
return;
}
if (vf.login[0].checked) {
foundatype=1;
if (vf.krbdom.value=='') {
alert('You need to specify the Kerberos domain');
return;
}
}
if (vf.login[1].checked) {
foundatype=1;
if ((vf.intpwd.value=='') && (foundpwd==0)) {
alert('You need to specify the initial password');
return;
}
}
if (foundatype==0) {
alert('You need to set the login type');
return;
}
if (foundname==0) { message='No name fields specified. '; }
if (foundid==0) { message+='No ID or student number field specified. '; }
if (foundsec==0) { message+='No section or group field specified. '; }
if (vf.startdate.value=='') {
message+='No starting date set. ';
}
if (vf.enddate.value=='') {
message+='No ending date set. ';
}
if ((vf.enddate.value!='') && (vf.startdate.value!='')) {
if (vf.enddate.value<vf.startdate.value) {
alert('Ending date is before starting date');
return;
}
}
if (message!='') {
message+='Continue enrollment?';
if (confirm(message)) {
pclose();
vf.submit();
}
} else {
pclose();
vf.submit();
}
}
function flip(vf,tf) {
var nw=eval('vf.f'+tf+'.selectedIndex');
var i;
for (i=0;i<=vf.nfields.value;i++) {
if ((i!=tf) && (eval('vf.f'+i+'.selectedIndex')==nw)) {
eval('vf.f'+i+'.selectedIndex=0;')
}
}
if (nw==2) {
for (i=0;i<=vf.nfields.value;i++) {
if ((eval('vf.f'+i+'.selectedIndex')>=3) &&
(eval('vf.f'+i+'.selectedIndex')<=6)) {
eval('vf.f'+i+'.selectedIndex=0;')
}
}
}
if ((nw>=3) && (nw<=6)) {
for (i=0;i<=vf.nfields.value;i++) {
if (eval('vf.f'+i+'.selectedIndex')==2) {
eval('vf.f'+i+'.selectedIndex=0;')
}
}
}
if (nw==9) {
vf.login[1].checked=true;
vf.intpwd.value='';
vf.krbdom.value='';
}
}
function clearpwd(vf) {
var i;
for (i=0;i<=vf.nfields.value;i++) {
if (eval('vf.f'+i+'.selectedIndex')==9) {
eval('vf.f'+i+'.selectedIndex=0;')
}
}
}
function setkrb(vf) {
if (vf.krbdom.value!='') {
clearpwd(vf);
vf.login[0].checked=true;
vf.krbdom.value=vf.krbdom.value.toUpperCase();
vf.intpwd.value='';
}
}
function setint(vf) {
if (vf.intpwd.value!='') {
clearpwd(vf);
vf.login[1].checked=true;
vf.krbdom.value='';
}
}
function clickkrb(vf) {
vf.krbdom.value='$krbdefdom';
clearpwd(vf);
vf.intpwd.value='';
}
function clickint(vf) {
vf.krbdom.value='';
}
function pclose() {
parmwin=window.open("/adm/rat/empty.html","LONCAPAparms",
"height=350,width=350,scrollbars=no,menubar=no");
parmwin.close();
}
function pjump(type,dis,value,marker,ret,call) {
parmwin=window.open("/adm/rat/parameter.html?type="+escape(type)
+"&value="+escape(value)+"&marker="+escape(marker)
+"&return="+escape(ret)
+"&call="+escape(call)+"&name="+escape(dis),"LONCAPAparms",
"height=350,width=350,scrollbars=no,menubar=no");
}
function dateset() {
if (document.studentform.pres_marker.value=='end') {
document.studentform.enddate.value=
document.studentform.pres_value.value;
}
if (document.studentform.pres_marker.value=='start') {
document.studentform.startdate.value=
document.studentform.pres_value.value;
}
pclose();
}
</script>
<table border=2><tr><th>Field</th><th>Samples</th></tr>
ENDPICK
my @sone; my @stwo; my @sthree; my $nfields=0;
if ($#lines>=0) {
$lines[0]=~s/^$remove//;
$lines[0]=~s/$remove$//;
@sone=split(/$separator/,$lines[0]);
$nfields=$#sone;
if ($#lines>=1) {
$lines[1]=~s/^$remove//;
$lines[1]=~s/$remove$//;
@stwo=split(/$separator/,$lines[1]);
$nfields=$#stwo;
}
if ($#lines>=2) {
$lines[2]=~s/^$remove//;
$lines[2]=~s/$remove$//;
@sthree=split(/$separator/,$lines[2]);
$nfields=$#sthree;
}
my $i;
for ($i=0;$i<=$nfields;$i++) {
$r->print('<tr><td><select name=f'.$i.
' onChange="flip(this.form,'.$i.');">');
map {
my ($value,$display)=split(/\:/,$_);
$r->print('<option value='.$value.'>'.$display.
'</option>');
} ('none: ','username:Username',
'names:Last Name, First Names',
'fname:First Name','mname:Middle Names/Initials',
'lname:Last Name','gen:Generation',
'id:ID/Student Number','sec:Group/Section',
'ipwd:Initial Password');
$r->print('</select></td><td>');
if (defined($sone[$i])) {
$r->print($sone[$i]."</br>\n");
}
if (defined($stwo[$i])) {
$r->print($stwo[$i]."</br>\n");
}
if (defined($sthree[$i])) {
$r->print($sthree[$i]."</br>\n");
}
$r->print('</td></tr>');
}
}
$r->print(<<ENDPICK);
</table>
<input type=hidden name=nfields value=$nfields>
<h3>Login Type</h3>
<input type=radio name=login value=krb onClick="clickkrb(this.form);">
Kerberos authenticated with domain
<input type=text size=10 name=krbdom onChange="setkrb(this.form);"><p>
<input type=radio name=login value=int onClick="clickint(this.form);">
Internally authenticated (with initial password
<input type=text size=10 name=intpwd onChange="setint(this.form);">)
<h3>LON-CAPA Domain for Students</h3>
LON-CAPA domain: <input type=text size=10 value=$defdom name=lcdomain><p>
<h3>Starting and Ending Dates</h3>
<input type="hidden" value='' name="pres_value">
<input type="hidden" value='' name="pres_type">
<input type="hidden" value='' name="pres_marker">
<input type="hidden" value='$today' name=startdate>
<input type="hidden" value='$halfyear' name=enddate>
<a
href="javascript:pjump('date_start','Enrollment Starting Date',document.studentform.startdate.value,'start','studentform.pres','dateset');"
>Set Starting Date</a><p>
<a
href="javascript:pjump('date_end','Enrollment Ending Date',document.studentform.enddate.value,'end','studentform.pres','dateset');"
>Set Ending Date</a><p>
<h3>Full Update</h3>
<input type=checkbox name=fullup value=yes> Full update
(also dropping students)<p>
<input type=button onClick="verify(this.form)" value="Update Courselist"><br>
Note: for large courses, this operation might be time consuming.
ENDPICK
} elsif ($ENV{'form.enroll'}) {
} elsif ($ENV{'form.drop'}) {
}
}
# ----------------------------------------------------------------- Phase three
if ($ENV{'form.phase'} eq 'three') {
if ($ENV{'form.datatoken'}) {
my $separator='';
my $remove='';
if ($ENV{'form.upfiletype'} eq 'csv') {
$separator='\"\,\s*\"';
$remove='"';
} elsif ($ENV{'form.upfiletype'} eq 'space') {
$separator='\s+';
} elsif ($ENV{'form.upfiletype'} eq 'tab') {
$separator='\t+';
} elsif ($ENV{'form.upfiletype'} eq 'xml') {
}
my %fields=();
for (my $i=0;$i<=$ENV{'form.nfields'};$i++) {
$fields{$ENV{'form.f'.$i}}=$i;
}
my $startdate=$ENV{'form.startdate'};
my $enddate=$ENV{'form.enddate'};
if ($startdate=~/\D/) { $startdate=''; }
if ($enddate=~/\D/) { $enddate=''; }
my $domain=$ENV{'form.lcdomain'};
my $amode='';
my $genpwd='';
if ($ENV{'form.login'} eq 'krb') {
$amode='krb4';
$genpwd=$ENV{'form.krbdom'};
} elsif ($ENV{'form.login'} eq 'int') {
$amode='internal';
if ((defined($ENV{'form.intpwd'})) && ($ENV{'form.intpwd'})) {
$genpwd=$ENV{'form.intpwd'};
}
}
unless (($domain=~/\W/) || ($amode eq '')) {
$r->print('<h3>Enrolling Students</h3>');
my $count=0;
my $flushc=0;
my %student=();
# ----------------------------------------------------------- Get new classlist
my @studentdata=();
{
my $fh;
if ($fh=Apache::File->new($r->dir_config('lonDaemons').
'/tmp/'.$ENV{'form.datatoken'}.'.tmp')) {
@studentdata=<$fh>;
}
}
# --------------------------------------------------------- Enroll new students
map {
my $line=$_;
chomp($line);
$line=~s/^$remove//;
$line=~s/$remove$//;
my @entries=split(/$separator/,$line);
unless (($entries[$fields{'username'}] eq '') ||
(!defined($entries[$fields{'username'}]))) {
my $fname=''; my $mname=''; my $lname=''; my $gen='';
if (defined($fields{'names'})) {
($lname,$fname,$mname)=
($entries[$fields{'names'}]=~/([^\,]+)\,\s*(\w+)\s*(.*)$/);
} else {
if (defined($fields{'fname'})) {
$fname=$entries[$fields{'fname'}];
}
if (defined($fields{'mname'})) {
$mname=$entries[$fields{'mname'}];
}
if (defined($fields{'lname'})) {
$lname=$entries[$fields{'lname'}];
}
if (defined($fields{'gen'})) {
$gen=$entries[$fields{'gen'}];
}
}
if ($entries[$fields{'username'}]=~/\W/) {
$r->print('<p><b>Unacceptable username: '.
$entries[$fields{'username'}].' for user '.
$fname.' '.$mname.' '.$lname.' '.$gen.'</b><p>');
} else {
my $sec='';
my $username=$entries[$fields{'username'}];
if (defined($fields{'sec'})) {
if (defined($entries[$fields{'sec'}])) {
$sec=$entries[$fields{'sec'}];
}
}
my $id='';
if (defined($fields{'id'})) {
if (defined($entries[$fields{'id'}])) {
$id=$entries[$fields{'id'}];
}
$id=~tr/A-Z/a-z/;
}
my $password='';
if ($genpwd) {
$password=$genpwd;
} else {
if (defined($fields{'ipwd'})) {
if ($entries[$fields{'ipwd'}]) {
$password=$entries[$fields{'ipwd'}];
}
}
}
if ($password) {
my $reply=&Apache::lonnet::modifystudent(
$domain,$username,$id,$amode,$password,
$fname,$mname,$lname,$gen,$sec,$enddate,$startdate);
unless ($reply eq 'ok') {
$r->print(
"<p><b>Error enrolling $username: $reply</b><p>");
} else {
$count++; $flushc++;
$student{$username}=1;
$r->print('. ');
if ($flushc>15) {
$r->rflush;
$flushc=0;
}
}
} else {
$r->print(
"<p><b>No password for $username</b><p>");
}
}
}
} @studentdata;
$r->print('<p>Processed Students: '.$count);
# --------------------------------------------------------------- Drop students
if ($ENV{'form.fullup'} eq 'yes') {
$r->print('<h3>Dropping Students</h3>');
# ------------------------------------------------------- Get current classlist
my $cid=$ENV{'request.course.id'};
my $classlst=&Apache::lonnet::reply
('dump:'.$ENV{'course.'.$cid.'.domain'}.':'.
$ENV{'course.'.$cid.'.num'}.':classlist',
$ENV{'course.'.$cid.'.home'});
my %currentlist=();
my $now=time;
unless ($classlst=~/^error\:/) {
map {
my ($name,$value)=split(/\=/,$_);
my ($end,$start)=split(/\:/,
&Apache::lonnet::unescape($value));
my $active=1;
if (($end) && ($now>$end)) { $active=0; }
if ($active) {
$currentlist{&Apache::lonnet::unescape($name)}=1;
}
} split(/\&/,$classlst);
} else {
$r->print(
'<font color=red><h3>Could not access classlist: '.$classlst.
'</h3></font>');
}
}
# ------------------------------------------------------------------------ Done
}
}
}
# ------------------------------------------------------------------------- End
$r->print('</form></body></html>');
} else {
# ----------------------------- Not in a course, or not allowed to modify parms
$ENV{'user.error.msg'}=
"/adm/dropadd:cst:0:0:Cannot drop or add students";
return HTTP_NOT_ACCEPTABLE;
}
return OK;
}
1;
__END__
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>