Annotation of loncom/interface/londropadd.pm, revision 1.141
1.1 www 1: # The LearningOnline Network with CAPA
2: # Handler to drop and add students in courses
3: #
1.141 ! albertel 4: # $Id: londropadd.pm,v 1.140 2006/04/26 14:52:22 albertel Exp $
1.17 albertel 5: #
6: # Copyright Michigan State University Board of Trustees
7: #
8: # This file is part of the LearningOnline Network with CAPA (LON-CAPA).
9: #
10: # LON-CAPA is free software; you can redistribute it and/or modify
11: # it under the terms of the GNU General Public License as published by
12: # the Free Software Foundation; either version 2 of the License, or
13: # (at your option) any later version.
14: #
15: # LON-CAPA is distributed in the hope that it will be useful,
16: # but WITHOUT ANY WARRANTY; without even the implied warranty of
17: # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18: # GNU General Public License for more details.
19: #
20: # You should have received a copy of the GNU General Public License
21: # along with LON-CAPA; if not, write to the Free Software
22: # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
23: #
24: # /home/httpd/html/adm/gpl.txt
25: #
26: # http://www.lon-capa.org/
27: #
1.1 www 28: #
1.50 matthew 29: ###############################################################
1.82 www 30: ##############################################################
1.1 www 31:
32: package Apache::londropadd;
33:
34: use strict;
1.127 albertel 35: use Apache::lonnet;
1.24 albertel 36: use Apache::loncommon();
1.50 matthew 37: use Apache::lonhtmlcommon();
1.1 www 38: use Apache::Constants qw(:common :http REDIRECT);
1.60 matthew 39: use Spreadsheet::WriteExcel;
1.110 matthew 40: use Apache::lonstathelpers();
1.86 www 41: use Apache::lonlocal;
1.1 www 42:
1.50 matthew 43: ###############################################################
44: ###############################################################
1.10 www 45: sub header {
1.138 albertel 46: my $start_page=&Apache::loncommon::start_page('Enrollment Manager');
1.27 matthew 47: return(<<ENDHEAD);
1.138 albertel 48: $start_page
1.40 matthew 49: <form method="post" enctype="multipart/form-data"
50: action="/adm/dropadd" name="studentform">
1.1 www 51: ENDHEAD
1.10 www 52: }
53:
1.50 matthew 54: ###############################################################
55: ###############################################################
56: # Drop student from all sections of a course, except optional $csec
1.26 matthew 57: sub modifystudent {
1.33 matthew 58: my ($udom,$unam,$courseid,$csec,$desiredhost)=@_;
1.26 matthew 59: # if $csec is undefined, drop the student from all the courses matching
60: # this one. If $csec is defined, drop them from all other sections of
61: # this course and add them to section $csec
1.25 matthew 62: $courseid=~s/\_/\//g;
63: $courseid=~s/^(\w)/\/$1/;
1.26 matthew 64: my %roles = &Apache::lonnet::dump('roles',$udom,$unam);
65: my ($tmp) = keys(%roles);
66: # Bail out if we were unable to get the students roles
1.35 matthew 67: return "$1" if ($tmp =~ /^(con_lost|error|no_such_host)/i);
1.26 matthew 68: # Go through the roles looking for enrollment in this course
1.35 matthew 69: my $result = '';
1.26 matthew 70: foreach my $course (keys(%roles)) {
1.35 matthew 71: if ($course=~/^$courseid(?:\/)*(?:\s+)*(\w+)*\_st$/) {
1.26 matthew 72: # We are in this course
1.25 matthew 73: my $section=$1;
1.26 matthew 74: $section='' if ($course eq $courseid.'_st');
1.87 matthew 75: if (defined($csec) && $section eq $csec) {
1.71 matthew 76: $result .= 'ok:';
77: } elsif ( ((!$section) && (!$csec)) || ($section ne $csec) ) {
1.27 matthew 78: my (undef,$end,$start)=split(/\_/,$roles{$course});
1.25 matthew 79: my $now=time;
1.50 matthew 80: # if this is an active role
1.27 matthew 81: if (!($start && ($now<$start)) || !($end && ($now>$end))) {
1.25 matthew 82: my $reply=&Apache::lonnet::modifystudent
1.70 matthew 83: # dom name id mode pass f m l g
84: ($udom,$unam,'', '', '',undef,undef,undef,undef,
1.33 matthew 85: $section,time,undef,undef,$desiredhost);
1.35 matthew 86: $result .= $reply.':';
1.25 matthew 87: }
1.10 www 88: }
89: }
1.20 harris41 90: }
1.35 matthew 91: if ($result eq '') {
1.62 matthew 92: $result = 'Unable to find section for this student';
1.37 matthew 93: } else {
94: $result =~ s/(ok:)+/ok/g;
1.35 matthew 95: }
96: return $result;
1.10 www 97: }
98:
1.50 matthew 99: ###############################################################
100: ###############################################################
101: # build a domain and server selection form
1.31 matthew 102: sub domain_form {
103: my ($defdom) = @_;
104: # Set up domain and server selection forms
105: #
106: # Get the domains
107: my @domains = &Apache::loncommon::get_domains();
108: # build up the menu information to be passed to
109: # &Apache::loncommon::linked_select_forms
110: my %select_menus;
111: foreach my $dom (@domains) {
112: # set up the text for this domain
113: $select_menus{$dom}->{'text'}= $dom;
114: # we want a choice of 'default' as the default in the second menu
115: $select_menus{$dom}->{'default'}= 'default';
116: $select_menus{$dom}->{'select2'}->{'default'} = 'default';
117: # Now build up the other items in the second menu
1.45 matthew 118: my %servers = &Apache::loncommon::get_library_servers($dom);
1.31 matthew 119: foreach my $server (keys(%servers)) {
120: $select_menus{$dom}->{'select2'}->{$server}
121: = "$server $servers{$server}";
122: }
123: }
124: my $result = &Apache::loncommon::linked_select_forms
125: ('studentform',' with home server ',$defdom,
126: 'lcdomain','lcserver',\%select_menus);
127: return $result;
128: }
129:
1.50 matthew 130: ###############################################################
131: ###############################################################
132: # Menu Phase One
133: sub print_main_menu {
1.132 raeburn 134: my ($r,$enrl_permission,$view_permission,$grp_manage_permission,
135: $grp_view_permission)=@_;
1.121 matthew 136: #
1.127 albertel 137: my ($cdom,$cnum) = split/_/,$env{'request.course.id'};
1.121 matthew 138: my @menu =
139: (
1.122 matthew 140: { text => 'Upload a class list',
1.121 matthew 141: help => 'Course_Create_Class_List',
142: action => 'upload',
143: permission => $enrl_permission,
144: },
145: { text => 'Enroll a single student',
146: help => 'Course_Add_Student',
147: action => 'enrollstudent',
148: permission => $enrl_permission,
149: },
150: { text => 'Modify student data',
151: help => 'Course_Modify_Student_Data',
152: action => 'modifystudent',
153: permission => $enrl_permission,
154: },
155: { text => 'View Class List',
156: help => 'Course_View_Class_List',
157: action => 'classlist',
158: permission => $view_permission,
159: },
160: { text => 'Drop Students',
161: help => 'Course_Drop_Student',
162: action => 'drop',
163: permission => $enrl_permission,
164: },
165: { text => 'Automated Enrollment Manager',
166: permission => &Apache::lonnet::auto_run($cnum,$cdom),
167: url => '/adm/populate',
168: },
1.137 raeburn 169: { text => 'Create a new group',
170: help => 'Course_Create_Group',
171: permission => $grp_manage_permission,
172: url => '/adm/coursegroups?refpage=enrl&action=create',
173: },
174: { text => 'Modify an existing group',
175: help => 'Course_Modify_Group',
176: permission => $grp_manage_permission,
177: url => '/adm/coursegroups?refpage=enrl&action=modify',
178: },
179: { text => 'Delete an existing group',
180: help => 'Course_Delete_Group',
181: permission => $grp_manage_permission,
182: url => '/adm/coursegroups?refpage=enrl&action=delete',
183: },
184: { text => 'Enter an existing group',
185: help => 'Course_Display_Group',
186: permission => $grp_view_permission,
187: url => '/adm/coursegroups?refpage=enrl&action=view',
188: },
1.121 matthew 189: );
190: my $menu_html = '';
191: foreach my $menu_item (@menu) {
192: next if (! $menu_item->{'permission'});
193: $menu_html.='<p>';
194: $menu_html.='<font size="+1">';
195: if (exists($menu_item->{'url'})) {
196: $menu_html.=qq{<a href="$menu_item->{'url'}">};
197: } else {
198: $menu_html.=
199: qq{<a href="/adm/dropadd?action=$menu_item->{'action'}">};
200: }
201: $menu_html.= &mt($menu_item->{'text'}).'</a></font>';
202: if (exists($menu_item->{'help'})) {
203: $menu_html.=
204: &Apache::loncommon::help_open_topic($menu_item->{'help'});
205: }
206: $menu_html.='</p>'.$/;
1.113 raeburn 207: }
1.121 matthew 208: $r->print($menu_html);
209: return;
1.10 www 210: }
211:
1.50 matthew 212: ###############################################################
213: ###############################################################
1.89 matthew 214: sub hidden_input {
215: my ($name,$value) = @_;
216: return '<input type="hidden" name="'.$name.'" value="'.$value.'" />'."\n";
217: }
218:
1.50 matthew 219: sub print_upload_manager_header {
1.23 albertel 220: my ($r,$datatoken,$distotal,$krbdefdom)=@_;
1.24 albertel 221: my $javascript;
1.99 matthew 222: #
1.127 albertel 223: if (! exists($env{'form.upfile_associate'})) {
224: $env{'form.upfile_associate'} = 'forward';
1.50 matthew 225: }
1.127 albertel 226: if ($env{'form.associate'} eq 'Reverse Association') {
227: if ( $env{'form.upfile_associate'} ne 'reverse' ) {
228: $env{'form.upfile_associate'} = 'reverse';
1.50 matthew 229: } else {
1.127 albertel 230: $env{'form.upfile_associate'} = 'forward';
1.50 matthew 231: }
232: }
1.127 albertel 233: if ($env{'form.upfile_associate'} eq 'reverse') {
1.50 matthew 234: $javascript=&upload_manager_javascript_reverse_associate();
1.24 albertel 235: } else {
1.50 matthew 236: $javascript=&upload_manager_javascript_forward_associate();
1.24 albertel 237: }
1.99 matthew 238: #
239: # Deal with restored settings
240: my $password_choice = '';
1.127 albertel 241: if (exists($env{'form.ipwd_choice'}) &&
242: $env{'form.ipwd_choice'} ne '') {
1.99 matthew 243: # If a column was specified for password, assume it is for an
244: # internal password. This is a bug waiting to be filed (could be
245: # local or krb auth instead of internal) but I do not have the
246: # time to mess around with this now.
247: $password_choice = 'int';
248: }
249: #
250: my $javascript_validations=&javascript_validations('auth',$krbdefdom,
251: $password_choice);
1.127 albertel 252: my $checked=(($env{'form.noFirstLine'})?' checked="1"':'');
1.88 matthew 253: $r->print('<h3>'.&mt('Uploading Class List')."</h3>\n".
254: "<hr>\n".
255: '<h3>'.&mt('Identify fields')."</h3>\n");
256: $r->print("<p>\n".
257: &mt('Total number of records found in file: [_1].',$distotal).
258: "\n".
259: "</p><hr>\n");
1.94 sakharuk 260: $r->print(&mt('Enter as many fields as you can. The system will inform you and bring you back to this page if the data selected is insufficient to enroll students in your class.')."<hr>\n");
1.89 matthew 261: $r->print(&hidden_input('action','upload').
262: &hidden_input('state','got_file').
263: &hidden_input('associate','').
264: &hidden_input('datatoken',$datatoken).
1.127 albertel 265: &hidden_input('fileupload',$env{'form.fileupload'}).
266: &hidden_input('upfiletype',$env{'form.upfiletype'}).
267: &hidden_input('upfile_associate',$env{'form.upfile_associate'}));
1.89 matthew 268: $r->print('<input type="button" value="Reverse Association" '.
269: 'name="'.&mt('Reverse Association').'" '.
270: 'onClick="javascript:this.form.associate.value=\'Reverse Association\';submit(this.form);" />');
1.131 albertel 271: $r->print('<label><input type="checkbox" name="noFirstLine" $checked />'.
272: &mt('Ignore First Line').'</label>');
1.89 matthew 273: $r->print("<hr />\n".
274: '<script type="text/javascript" language="Javascript">'."\n".
275: $javascript."\n".$javascript_validations.'</script>');
1.24 albertel 276: }
277:
1.50 matthew 278: ###############################################################
279: ###############################################################
1.24 albertel 280: sub javascript_validations {
1.96 raeburn 281: my ($mode,$krbdefdom,$curr_authtype,$curr_authfield)=@_;
1.89 matthew 282: my $authheader;
283: if ($mode eq 'auth') {
284: my %param = ( formname => 'studentform',
1.99 matthew 285: kerb_def_dom => $krbdefdom,
286: curr_authtype => $curr_authtype);
1.89 matthew 287: $authheader = &Apache::loncommon::authform_header(%param);
1.91 raeburn 288: } elsif ($mode eq 'createcourse') {
289: my %param = ( formname => 'ccrs',
1.99 matthew 290: kerb_def_dom => $krbdefdom,
291: curr_authtype => $curr_authtype );
1.91 raeburn 292: $authheader = &Apache::loncommon::authform_header(%param);
1.96 raeburn 293: } elsif ($mode eq 'modifycourse') {
294: my %param = ( formname => 'cmod',
295: kerb_def_dom => $krbdefdom,
296: mode => 'modifycourse',
297: curr_authtype => $curr_authtype,
298: curr_autharg => $curr_authfield );
299: $authheader = &Apache::loncommon::authform_header(%param);
1.89 matthew 300: }
1.96 raeburn 301:
1.91 raeburn 302:
1.89 matthew 303: my %alert = &Apache::lonlocal::texthash
304: (username => 'You need to specify the username field.',
305: authen => 'You must choose an authentication type.',
306: krb => 'You need to specify the Kerberos domain.',
307: ipass => 'You need to specify the initial password.',
308: name => 'The optional name field was not specified.',
309: snum => 'The optional student number field was not specified.',
310: section => 'The optional section or group field was not specified.',
311: email => 'The optional email address field was not specified.',
312: continue => 'Continue enrollment?',
313: );
314:
315: # my $pjump_def = &Apache::lonhtmlcommon::pjump_javascript_definition();
316: my $function_name =(<<END);
1.73 www 317: function verify_message (vf,founduname,foundpwd,foundname,foundid,foundsec,foundemail) {
1.89 matthew 318: END
1.97 raeburn 319: my $auth_checks;
1.96 raeburn 320: if ($mode eq 'createcourse') {
321: $auth_checks .= (<<END);
1.97 raeburn 322: if (vf.autoadds[0].checked == true) {
1.96 raeburn 323: if (current.radiovalue == null || current.radiovalue == 'nochange') {
324: alert('$alert{'authen'}');
325: return;
326: }
327: }
328: END
329: } else {
1.91 raeburn 330: $auth_checks .= (<<END);
1.97 raeburn 331: var foundatype=0;
1.3 www 332: if (founduname==0) {
1.89 matthew 333: alert('$alert{'username'}');
1.3 www 334: return;
335: }
1.61 matthew 336: // alert('current.radiovalue = '+current.radiovalue);
1.119 albertel 337: if (current.radiovalue == null || current.radiovalue == '' || current.radiovalue == 'nochange') {
1.28 matthew 338: // They did not check any of the login radiobuttons.
1.89 matthew 339: alert('$alert{'authen'}');
1.28 matthew 340: return;
341: }
1.96 raeburn 342: END
343: }
1.97 raeburn 344: if ($mode eq 'createcourse') {
345: $auth_checks .= "
346: if ( (vf.autoadds[0].checked == true) &&
347: (vf.elements[current.argfield].value == null || vf.elements[current.argfield].value == '') ) {
348: ";
349: } elsif ($mode eq 'modifycourse') {
350: $auth_checks .= "
351: if (vf.elements[current.argfield].value == null || vf.elements[current.argfield].value == '') {
352: ";
353: }
1.96 raeburn 354: if ( ($mode eq 'createcourse') || ($mode eq 'modifycourse') ) {
1.97 raeburn 355: $auth_checks .= (<<END);
356: var alertmsg = '';
357: switch (current.radiovalue) {
358: case 'krb':
359: alertmsg = '$alert{'krb'}';
360: break;
361: default:
362: alertmsg = '';
1.96 raeburn 363: }
1.97 raeburn 364: if (alertmsg != '') {
365: alert(alertmsg);
366: return;
1.96 raeburn 367: }
368: }
369: END
370: } else {
371: $auth_checks .= (<<END);
1.28 matthew 372: foundatype=1;
1.29 matthew 373: if (current.argfield == null || current.argfield == '') {
1.28 matthew 374: var alertmsg = '';
1.29 matthew 375: switch (current.value) {
1.28 matthew 376: case 'krb':
1.89 matthew 377: alertmsg = '$alert{'krb'}';
1.28 matthew 378: break;
379: case 'loc':
380: case 'fsys':
1.89 matthew 381: alertmsg = '$alert{'ipass'}';
1.28 matthew 382: break;
383: case 'fsys':
384: alertmsg = '';
385: break;
386: default:
387: alertmsg = '';
1.3 www 388: }
1.28 matthew 389: if (alertmsg != '') {
390: alert(alertmsg);
1.3 www 391: return;
392: }
393: }
1.89 matthew 394: END
1.96 raeburn 395: }
1.91 raeburn 396: my $optional_checks = '';
1.96 raeburn 397: if ( ($mode eq 'createcourse') || ($mode eq 'modifycourse') ) {
1.91 raeburn 398: $optional_checks = (<<END);
399: vf.submit();
400: }
401: END
402: } else {
403: $optional_checks = (<<END);
1.89 matthew 404: var message='';
405: if (foundname==0) {
406: message='$alert{'name'}';
1.24 albertel 407: }
1.89 matthew 408: if (foundid==0) {
409: if (message!='') {
410: message+='\\n';
411: }
412: message+='$alert{'snum'}';
413: }
414: if (foundsec==0) {
415: if (message!='') {
416: message+='\\n';
417: }
418: message+='$alert{'section'}';
419: }
420: if (foundemail==0) {
421: if (message!='') {
422: message+='\\n';
423: }
424: message+='$alert{'email'}';
1.74 matthew 425: }
426: if (message!='') {
1.89 matthew 427: message+= '\\n$alert{'continue'}';
428: if (confirm(message)) {
429: vf.state.value='enrolling';
430: vf.submit();
431: }
1.74 matthew 432: } else {
1.89 matthew 433: vf.state.value='enrolling';
434: vf.submit();
1.74 matthew 435: }
436: }
1.89 matthew 437: END
1.91 raeburn 438: }
1.89 matthew 439: my $result = $function_name;
1.96 raeburn 440: if ( ($mode eq 'auth') || ($mode eq 'createcourse') || ($mode eq 'modifycourse') ) {
1.89 matthew 441: $result .= $auth_checks;
442: }
443: $result .= $optional_checks;
1.96 raeburn 444: if ( ($mode eq 'auth') || ($mode eq 'createcourse') || ($mode eq 'modifycourse') ) {
1.89 matthew 445: $result .= $authheader;
446: }
447: return $result;
1.74 matthew 448: }
449:
1.50 matthew 450: ###############################################################
451: ###############################################################
452: sub upload_manager_javascript_forward_associate {
1.24 albertel 453: return(<<ENDPICK);
454: function verify(vf) {
455: var founduname=0;
456: var foundpwd=0;
457: var foundname=0;
458: var foundid=0;
459: var foundsec=0;
1.73 www 460: var foundemail=0;
1.24 albertel 461: var tw;
462: for (i=0;i<=vf.nfields.value;i++) {
463: tw=eval('vf.f'+i+'.selectedIndex');
464: if (tw==1) { founduname=1; }
465: if ((tw>=2) && (tw<=6)) { foundname=1; }
466: if (tw==7) { foundid=1; }
467: if (tw==8) { foundsec=1; }
468: if (tw==9) { foundpwd=1; }
1.73 www 469: if (tw==10) { foundemail=1; }
1.24 albertel 470: }
1.73 www 471: verify_message(vf,founduname,foundpwd,foundname,foundid,foundsec,foundemail);
1.24 albertel 472: }
473:
1.49 matthew 474: //
475: // vf = this.form
476: // tf = column number
477: //
478: // values of nw
479: //
480: // 0 = none
481: // 1 = username
482: // 2 = names (lastname, firstnames)
483: // 3 = fname (firstname)
484: // 4 = mname (middlename)
485: // 5 = lname (lastname)
486: // 6 = gen (generation)
487: // 7 = id
488: // 8 = section
489: // 9 = ipwd (password)
1.73 www 490: // 10 = email address
491:
1.24 albertel 492: function flip(vf,tf) {
493: var nw=eval('vf.f'+tf+'.selectedIndex');
494: var i;
1.49 matthew 495: // make sure no other columns are labeled the same as this one
1.24 albertel 496: for (i=0;i<=vf.nfields.value;i++) {
497: if ((i!=tf) && (eval('vf.f'+i+'.selectedIndex')==nw)) {
498: eval('vf.f'+i+'.selectedIndex=0;')
499: }
500: }
1.49 matthew 501: // If we set this to 'lastname, firstnames', clear out all the ones
502: // set to 'fname','mname','lname','gen' (3,4,5,6) currently.
1.24 albertel 503: if (nw==2) {
504: for (i=0;i<=vf.nfields.value;i++) {
505: if ((eval('vf.f'+i+'.selectedIndex')>=3) &&
506: (eval('vf.f'+i+'.selectedIndex')<=6)) {
507: eval('vf.f'+i+'.selectedIndex=0;')
508: }
509: }
510: }
1.49 matthew 511: // If we set this to one of 'fname','mname','lname','gen' (3,4,5,6),
512: // clear out any that are set to 'lastname, firstnames' (2)
1.24 albertel 513: if ((nw>=3) && (nw<=6)) {
514: for (i=0;i<=vf.nfields.value;i++) {
515: if (eval('vf.f'+i+'.selectedIndex')==2) {
516: eval('vf.f'+i+'.selectedIndex=0;')
517: }
518: }
519: }
1.49 matthew 520: // If we set the password, make the password form below correspond to
521: // the new value.
1.24 albertel 522: if (nw==9) {
1.28 matthew 523: changed_radio('int',document.studentform);
524: set_auth_radio_buttons('int',document.studentform);
525: vf.intarg.value='';
526: vf.krbarg.value='';
1.24 albertel 527: vf.locarg.value='';
528: }
529: }
530:
531: function clearpwd(vf) {
532: var i;
533: for (i=0;i<=vf.nfields.value;i++) {
534: if (eval('vf.f'+i+'.selectedIndex')==9) {
535: eval('vf.f'+i+'.selectedIndex=0;')
536: }
537: }
538: }
539:
540: ENDPICK
541: }
542:
1.50 matthew 543: ###############################################################
544: ###############################################################
545: sub upload_manager_javascript_reverse_associate {
1.24 albertel 546: return(<<ENDPICK);
547: function verify(vf) {
548: var founduname=0;
549: var foundpwd=0;
550: var foundname=0;
551: var foundid=0;
552: var foundsec=0;
553: var tw;
554: for (i=0;i<=vf.nfields.value;i++) {
555: tw=eval('vf.f'+i+'.selectedIndex');
556: if (i==0 && tw!=0) { founduname=1; }
557: if (((i>=1) && (i<=5)) && tw!=0 ) { foundname=1; }
558: if (i==6 && tw!=0) { foundid=1; }
559: if (i==7 && tw!=0) { foundsec=1; }
560: if (i==8 && tw!=0) { foundpwd=1; }
561: }
562: verify_message(vf,founduname,foundpwd,foundname,foundid,foundsec);
563: }
564:
565: function flip(vf,tf) {
566: var nw=eval('vf.f'+tf+'.selectedIndex');
567: var i;
568: // picked the all one one name field, reset the other name ones to blank
569: if (tf==1 && nw!=0) {
570: for (i=2;i<=5;i++) {
571: eval('vf.f'+i+'.selectedIndex=0;')
572: }
573: }
574: //picked one of the piecewise name fields, reset the all in
575: //one field to blank
576: if ((tf>=2) && (tf<=5) && (nw!=0)) {
577: eval('vf.f1.selectedIndex=0;')
578: }
579: // intial password specified, pick internal authentication
580: if (tf==8 && nw!=0) {
1.28 matthew 581: changed_radio('int',document.studentform);
582: set_auth_radio_buttons('int',document.studentform);
583: vf.krbarg.value='';
584: vf.intarg.value='';
1.24 albertel 585: vf.locarg.value='';
586: }
587: }
588:
589: function clearpwd(vf) {
590: var i;
591: if (eval('vf.f8.selectedIndex')!=0) {
592: eval('vf.f8.selectedIndex=0;')
593: }
594: }
1.2 www 595: ENDPICK
1.23 albertel 596: }
1.10 www 597:
1.50 matthew 598: ###############################################################
599: ###############################################################
600: sub print_upload_manager_footer {
1.23 albertel 601: my ($r,$i,$keyfields,$defdom,$today,$halfyear)=@_;
1.64 albertel 602:
603: my ($krbdef,$krbdefdom) =
604: &Apache::loncommon::get_kerberos_defaults($defdom);
605: my %param = ( formname => 'document.studentform',
606: kerb_def_dom => $krbdefdom,
607: kerb_def_auth => $krbdef
608: );
1.127 albertel 609: if (exists($env{'form.ipwd_choice'}) &&
610: defined($env{'form.ipwd_choice'}) &&
611: $env{'form.ipwd_choice'} ne '') {
1.99 matthew 612: $param{'curr_authtype'} = 'int';
613: }
1.28 matthew 614: my $krbform = &Apache::loncommon::authform_kerberos(%param);
615: my $intform = &Apache::loncommon::authform_internal(%param);
616: my $locform = &Apache::loncommon::authform_local(%param);
1.31 matthew 617: my $domform = &domain_form($defdom);
1.68 matthew 618: my $date_table = &date_setting_table();
1.90 matthew 619: my $Str = "</table>\n";
620: $Str .= &hidden_input('nfields',$i);
621: $Str .= &hidden_input('keyfields',$keyfields);
622: $Str .= '<h3>'.&mt('Login Type')."</h3>\n";
623: $Str .= "<p>\n".
624: &mt('Note: this will not take effect if the user already exists').
1.130 www 625: &Apache::loncommon::help_open_topic('Auth_Options').
1.90 matthew 626: "</p><p>\n";
627: $Str .= $krbform."\n</p><p>\n".
628: $intform."\n</p><p>\n".
629: $locform."\n</p>\n";
630: $Str .= '<h3>'.&mt('LON-CAPA Domain for Students')."</h3>\n";
631: $Str .= "<p>\n".&mt('LON-CAPA domain: [_1]',$domform)."\n</p>\n";
632: $Str .= "<h3>".&mt('Starting and Ending Dates')."</h3>\n";
633: $Str .= "<p>\n".$date_table."</p>\n";
634: $Str .= "<h3>".&mt('Full Update')."</h3>\n";
1.131 albertel 635: $Str .= '<label><input type="checkbox" name="fullup" value="yes">'.
1.90 matthew 636: ' '.&mt('Full update (also print list of users not enrolled anymore)').
1.131 albertel 637: "</label></p>\n";
1.90 matthew 638: $Str .= "<h3>".&mt('Student Number')."</h3>\n";
1.131 albertel 639: $Str .= "<p>\n".'<label><input type="checkbox" name="forceid" value="yes">';
1.90 matthew 640: $Str .= &mt('Disable ID/Student Number Safeguard and Force Change '.
641: 'of Conflicting IDs (only do if you know what you are doing)').
1.131 albertel 642: "</label>\n</p><p>\n";
1.90 matthew 643: $Str .= '<input type="button" onClick="javascript:verify(this.form)" '.
1.95 albertel 644: 'value="Update Class List" />'."<br />\n";
1.90 matthew 645: $Str .= &mt('Note: for large courses, this operation may be time '.
646: 'consuming');
647: $r->print($Str);
648: return;
1.23 albertel 649: }
1.24 albertel 650:
1.90 matthew 651: ###############################################################
652: ###############################################################
1.50 matthew 653: sub print_upload_manager_form {
1.23 albertel 654: my $r=shift;
1.99 matthew 655:
1.82 www 656: my $firstLine;
1.24 albertel 657: my $datatoken;
1.127 albertel 658: if (!$env{'form.datatoken'}) {
1.90 matthew 659: $datatoken=&Apache::loncommon::upfile_store($r);
1.24 albertel 660: } else {
1.127 albertel 661: $datatoken=$env{'form.datatoken'};
1.90 matthew 662: &Apache::loncommon::load_tmp_file($r);
1.24 albertel 663: }
664: my @records=&Apache::loncommon::upfile_record_sep();
1.127 albertel 665: if($env{'form.noFirstLine'}){
1.90 matthew 666: $firstLine=shift(@records);
667: }
1.23 albertel 668: my $total=$#records;
669: my $distotal=$total+1;
670: my $today=time;
671: my $halfyear=$today+15552000;
1.99 matthew 672: #
673: # Restore memorized settings
674: &Apache::loncommon::restore_course_settings
675: ('enrollment_upload',{ 'username_choice' => 'scalar', # column settings
676: 'names_choice' => 'scalar',
677: 'fname_choice' => 'scalar',
678: 'mname_choice' => 'scalar',
679: 'lname_choice' => 'scalar',
680: 'gen_choice' => 'scalar',
681: 'id_choice' => 'scalar',
682: 'sec_choice' => 'scalar',
683: 'ipwd_choice' => 'scalar',
684: 'email_choice' => 'scalar',
685: });
686: #
687: # Determine kerberos parameters as appropriate
1.127 albertel 688: my $defdom=$env{'course.'.$env{'request.course.id'}.'.domain'};
1.64 albertel 689: my ($krbdef,$krbdefdom) =
690: &Apache::loncommon::get_kerberos_defaults($defdom);
1.99 matthew 691: #
1.50 matthew 692: &print_upload_manager_header($r,$datatoken,$distotal,$krbdefdom);
1.24 albertel 693: my $i;
694: my $keyfields;
1.23 albertel 695: if ($total>=0) {
1.99 matthew 696: my @field=
1.127 albertel 697: (['username',&mt('Username'), $env{'form.username_choice'}],
698: ['names',&mt('Last Name, First Names'),$env{'form.names_choice'}],
699: ['fname',&mt('First Name'), $env{'form.fname_choice'}],
700: ['mname',&mt('Middle Names/Initials'),$env{'form.mname_choice'}],
701: ['lname',&mt('Last Name'), $env{'form.lname_choice'}],
702: ['gen', &mt('Generation'), $env{'form.gen_choice'}],
703: ['id', &mt('ID/Student Number'),$env{'form.id_choice'}],
704: ['sec', &mt('Group/Section'), $env{'form.sec_choice'}],
705: ['ipwd', &mt('Initial Password'),$env{'form.ipwd_choice'}],
706: ['email',&mt('EMail Address'), $env{'form.email_choice'}]);
707: if ($env{'form.upfile_associate'} eq 'reverse') {
1.24 albertel 708: &Apache::loncommon::csv_print_samples($r,\@records);
1.90 matthew 709: $i=&Apache::loncommon::csv_print_select_table($r,\@records,
710: \@field);
711: foreach (@field) {
712: $keyfields.=$_->[0].',';
713: }
1.24 albertel 714: chop($keyfields);
715: } else {
1.90 matthew 716: unshift(@field,['none','']);
717: $i=&Apache::loncommon::csv_samples_select_table($r,\@records,
718: \@field);
1.24 albertel 719: my %sone=&Apache::loncommon::record_sep($records[0]);
720: $keyfields=join(',',sort(keys(%sone)));
1.23 albertel 721: }
722: }
1.50 matthew 723: &print_upload_manager_footer($r,$i,$keyfields,$defdom,$today,$halfyear);
1.10 www 724: }
725:
1.90 matthew 726: ###############################################################
727: ###############################################################
1.12 www 728: sub enroll_single_student {
729: my $r=shift;
1.80 matthew 730: # Remove non alphanumeric values from section
1.127 albertel 731: $env{'form.csec'}=~s/\W//g;
1.68 matthew 732: #
733: # We do the dates first because the action of making them the defaul
1.107 www 734: # in the course is entirely separate from the action of enrolling the
1.68 matthew 735: # student. Also, a failure in setting the dates as default is not fatal
736: # to the process of enrolling / modifying a student.
737: my ($startdate,$enddate) = &get_dates_from_form();
1.127 albertel 738: if ($env{'form.makedatesdefault'}) {
1.68 matthew 739: $r->print(&make_dates_default($startdate,$enddate));
740: }
741:
1.94 sakharuk 742: $r->print('<h3>'.&mt('Enrolling Student').'</h3>');
1.127 albertel 743: $r->print('<p>'.&mt('Enrolling').' '.$env{'form.cuname'}." \@ ".
744: $env{'form.lcdomain'}.'</p>');
745: if (($env{'form.cuname'})&&($env{'form.cuname'}!~/\W/)&&
746: ($env{'form.lcdomain'})&&($env{'form.lcdomain'}!~/\W/)) {
1.31 matthew 747: # Deal with home server selection
1.127 albertel 748: my $domain=$env{'form.lcdomain'};
749: my $desiredhost = $env{'form.lcserver'};
1.31 matthew 750: if (lc($desiredhost) eq 'default') {
751: $desiredhost = undef;
752: } else {
1.45 matthew 753: my %home_servers =&Apache::loncommon::get_library_servers($domain);
1.31 matthew 754: if (! exists($home_servers{$desiredhost})) {
1.94 sakharuk 755: $r->print('<font color="#ff0000">'.&mt('Error').':</font>'.
756: &mt('Invalid home server specified'));
1.31 matthew 757: return;
758: }
759: }
1.94 sakharuk 760: $r->print(" ".&mt('with server')." $desiredhost :") if (defined($desiredhost));
1.31 matthew 761: # End of home server selection logic
1.12 www 762: my $amode='';
763: my $genpwd='';
1.127 albertel 764: if ($env{'form.login'} eq 'krb') {
1.47 albertel 765: $amode='krb';
1.127 albertel 766: $amode.=$env{'form.krbver'};
767: $genpwd=$env{'form.krbarg'};
768: } elsif ($env{'form.login'} eq 'int') {
1.26 matthew 769: $amode='internal';
1.127 albertel 770: $genpwd=$env{'form.intarg'};
771: } elsif ($env{'form.login'} eq 'loc') {
1.15 albertel 772: $amode='localauth';
1.127 albertel 773: $genpwd=$env{'form.locarg'};
1.15 albertel 774: if (!$genpwd) { $genpwd=" "; }
775: }
1.127 albertel 776: my $home = &Apache::lonnet::homeserver($env{'form.cuname'},
777: $env{'form.lcdomain'});
1.34 matthew 778: if ((($amode) && ($genpwd)) || ($home ne 'no_host')) {
1.55 matthew 779: # Clean out any old roles the student has in this class.
1.127 albertel 780: &modifystudent($env{'form.lcdomain'},$env{'form.cuname'},
781: $env{'request.course.id'},$env{'form.csec'},
1.33 matthew 782: $desiredhost);
1.55 matthew 783: my $login_result = &Apache::lonnet::modifystudent
1.127 albertel 784: ($env{'form.lcdomain'},$env{'form.cuname'},
785: $env{'form.cstid'},$amode,$genpwd,
786: $env{'form.cfirst'},$env{'form.cmiddle'},
787: $env{'form.clast'},$env{'form.cgen'},
788: $env{'form.csec'},$enddate,
789: $startdate,$env{'form.forceid'},
790: $desiredhost,$env{'form.emailaddress'});
1.55 matthew 791: if ($login_result =~ /^ok/) {
792: $r->print($login_result);
1.94 sakharuk 793: $r->print("<p> ".&mt('If active, the new role will be available when the student next logs in to LON-CAPA.')."</p>");
1.55 matthew 794: } else {
1.94 sakharuk 795: $r->print(&mt('unable to enroll').": ".$login_result);
1.55 matthew 796: }
1.12 www 797: } else {
1.94 sakharuk 798: $r->print('<p><font color="#ff0000">'.&mt('ERROR').'</font> ');
1.79 matthew 799: if ($amode =~ /^krb/) {
1.94 sakharuk 800: $r->print(&mt('Missing Kerberos domain information.').' ');
1.79 matthew 801: } else {
1.94 sakharuk 802: $r->print(&mt('Invalid login mode or password.').' ');
1.79 matthew 803: }
1.127 albertel 804: $r->print('<b>'.&mt('Unable to enroll').' '.$env{'form.cuname'}.'.</b></p>');
1.79 matthew 805: }
1.12 www 806: } else {
1.94 sakharuk 807: $r->print(&mt('Invalid username or domain'));
1.26 matthew 808: }
1.12 www 809: }
810:
1.68 matthew 811: sub setup_date_selectors {
1.91 raeburn 812: my ($starttime,$endtime,$mode) = @_;
1.68 matthew 813: if (! defined($starttime)) {
814: $starttime = time;
1.114 raeburn 815: unless ($mode eq 'create_enrolldates' || $mode eq 'create_defaultdates') {
1.127 albertel 816: if (exists($env{'course.'.$env{'request.course.id'}.
1.68 matthew 817: '.default_enrollment_start_date'})) {
1.127 albertel 818: $starttime = $env{'course.'.$env{'request.course.id'}.
1.68 matthew 819: '.default_enrollment_start_date'};
1.91 raeburn 820: }
1.68 matthew 821: }
822: }
823: if (! defined($endtime)) {
824: $endtime = time+(6*30*24*60*60); # 6 months from now, approx
1.91 raeburn 825: unless ($mode eq 'createcourse') {
1.127 albertel 826: if (exists($env{'course.'.$env{'request.course.id'}.
1.68 matthew 827: '.default_enrollment_end_date'})) {
1.127 albertel 828: $endtime = $env{'course.'.$env{'request.course.id'}.
1.68 matthew 829: '.default_enrollment_end_date'};
1.91 raeburn 830: }
1.68 matthew 831: }
832: }
833: my $startdateform = &Apache::lonhtmlcommon::date_setter('studentform',
834: 'startdate',
835: $starttime);
836: my $enddateform = &Apache::lonhtmlcommon::date_setter('studentform',
837: 'enddate',
838: $endtime);
1.114 raeburn 839: if ($mode eq 'create_enrolldates') {
840: $startdateform = &Apache::lonhtmlcommon::date_setter('ccrs',
841: 'startenroll',
842: $starttime);
843: $enddateform = &Apache::lonhtmlcommon::date_setter('ccrs',
844: 'endenroll',
845: $endtime);
846: }
847: if ($mode eq 'create_defaultdates') {
1.91 raeburn 848: $startdateform = &Apache::lonhtmlcommon::date_setter('ccrs',
1.114 raeburn 849: 'startaccess',
1.91 raeburn 850: $starttime);
851: $enddateform = &Apache::lonhtmlcommon::date_setter('ccrs',
1.114 raeburn 852: 'endaccess',
1.91 raeburn 853: $endtime);
854: }
1.68 matthew 855: return ($startdateform,$enddateform);
856: }
857:
858: sub get_dates_from_form {
859: my $startdate = &Apache::lonhtmlcommon::get_date_from_form('startdate');
860: my $enddate = &Apache::lonhtmlcommon::get_date_from_form('enddate');
1.127 albertel 861: if ($env{'form.no_end_date'}) {
1.68 matthew 862: $enddate = 0;
863: }
864: return ($startdate,$enddate);
865: }
866:
867: sub date_setting_table {
1.91 raeburn 868: my ($starttime,$endtime,$mode) = @_;
869: my ($startform,$endform)=&setup_date_selectors($starttime,$endtime,$mode);
1.68 matthew 870: my $dateDefault = '<nobr>'.
1.131 albertel 871: '<label><input type="checkbox" name="makedatesdefault" /> '.
872: &mt('make these dates the default for future enrollment').'</label>';
1.114 raeburn 873: if ($mode eq 'create_enrolldates' || $mode eq 'create_defaultdates') {
1.91 raeburn 874: $dateDefault = ' ';
875: }
1.131 albertel 876: my $perpetual = '<nobr><label><input type="checkbox" name="no_end_date"';
1.68 matthew 877: if (defined($endtime) && $endtime == 0) {
878: $perpetual .= ' checked';
879: }
1.131 albertel 880: $perpetual.= ' /> '.&mt('no ending date').'</label></nobr>';
1.114 raeburn 881: if ($mode eq 'create_enrolldates') {
882: $perpetual = ' ';
883: }
1.68 matthew 884: my $result = '';
885: $result .= "<table>\n";
1.94 sakharuk 886: $result .= '<tr><td align="right">'.&mt('Starting Date').'</td>'.
1.68 matthew 887: '<td>'.$startform.'</td>'.
888: '<td>'.$dateDefault.'</td>'."</tr>\n";
1.94 sakharuk 889: $result .= '<tr><td align="right">'.&mt('Ending Date').'</td>'.
1.68 matthew 890: '<td>'.$endform.'</td>'.
891: '<td>'.$perpetual.'</td>'."</tr>\n";
892: $result .= "</table>\n";
893: return $result;
894: }
895:
896: sub make_dates_default {
897: my ($startdate,$enddate) = @_;
898: my $result = '';
1.127 albertel 899: my $dom = $env{'course.'.$env{'request.course.id'}.'.domain'};
900: my $crs = $env{'course.'.$env{'request.course.id'}.'.num'};
1.68 matthew 901: my $put_result = &Apache::lonnet::put('environment',
902: {'default_enrollment_start_date'=>$startdate,
903: 'default_enrollment_end_date' =>$enddate},$dom,$crs);
904: if ($put_result eq 'ok') {
905: $result .= "Set default start and end dates for course<br />";
1.69 matthew 906: #
907: # Refresh the course environment
1.140 albertel 908: &Apache::lonnet::coursedescription($env{'request.course.id'},
909: {'freshen_cache' => 1});
1.68 matthew 910: } else {
1.94 sakharuk 911: $result .= &mt('Unable to set default dates for course').":".$put_result.
1.68 matthew 912: '<br />';
913: }
914: return $result;
915: }
916:
1.74 matthew 917: ##
918: ## Single student enrollment routines (some of them)
919: ##
920: sub get_student_username_domain_form {
921: my $r = shift;
922: my $domform = &Apache::loncommon::select_dom_form
1.127 albertel 923: ($env{'course.'.$env{'request.course.id'}.'.domain'},'cudomain',0);
1.94 sakharuk 924: my %lt=&Apache::lonlocal::texthash(
925: 'eos' => "Enroll One Student",
926: 'usr' => "Username",
927: 'dom' => "Domain",
928: 'been' => "Begin Enrollment",
929: );
1.74 matthew 930: $r->print(<<END);
931: <input type="hidden" name="action" value="enrollstudent" />
932: <input type="hidden" name="state" value="gotusername" />
1.94 sakharuk 933: <h3>$lt{'eos'}</h3>
1.74 matthew 934: <table>
1.94 sakharuk 935: <tr><th>$lt{'usr'}:</th>
1.74 matthew 936: <td><input type="text" name="cuname" size="15" /></td></tr>
1.94 sakharuk 937: <tr><th>$lt{'dom'}:</th>
1.74 matthew 938: <td>$domform</td></tr>
939: <tr><th> </th>
940: <td>
1.94 sakharuk 941: <input type="submit" name="Begin Enrollment" value="$lt{'been'}" />
1.74 matthew 942: </td></tr>
943: </table>
1.120 albertel 944: <script type="text/javascript">
945: // the if prevents the script error if the browser can not handle this
946: if ( document.studentform.cuname ) { document.studentform.cuname.focus(); }
947: </script>
1.74 matthew 948: END
949: return;
950: }
951:
1.50 matthew 952: sub print_enroll_single_student_form {
1.10 www 953: my $r=shift;
1.94 sakharuk 954: $r->print("<h3>".&mt('Enroll One Student')."</h3>");
1.74 matthew 955: #
1.127 albertel 956: my $username = $env{'form.cuname'};
957: my $domain = $env{'form.cudomain'};
1.123 albertel 958: $username=~s/\W//gs;
959: $domain=~s/\W//gs;
1.74 matthew 960: my $home = &Apache::lonnet::homeserver($username,$domain);
961: # $new_user flags whether we are creating a new user or using an old one
962: my $new_user = 1;
963: if ($home ne 'no_host') {
964: $new_user = 0;
965: }
966: #
967: my $user_data_html = '';
968: my $javascript_validations = '';
969: if ($new_user) {
1.127 albertel 970: my $defdom=$env{'course.'.$env{'request.course.id'}.'.domain'};
1.74 matthew 971: # Set up authentication forms
972: my ($krbdef,$krbdefdom) =
1.75 matthew 973: &Apache::loncommon::get_kerberos_defaults($domain);
1.89 matthew 974: $javascript_validations=&javascript_validations('auth',$krbdefdom);
1.74 matthew 975: my %param = ( formname => 'document.studentform',
976: kerb_def_dom => $krbdefdom,
977: kerb_def_auth => $krbdef
978: );
979: my $krbform = &Apache::loncommon::authform_kerberos(%param);
980: my $intform = &Apache::loncommon::authform_internal(%param);
981: my $locform = &Apache::loncommon::authform_local(%param);
982: #
983: # Set up domain selection form
984: my $homeserver_form = '';
985: my %servers = &Apache::loncommon::get_library_servers($domain);
986: $homeserver_form = '<select name="lcserver" size="1">'."\n".
987: '<option value="default" selected>default</option>'."\n";
988: while (my ($servername,$serverdescription) = each (%servers)) {
989: $homeserver_form .= '<option value="'.$servername.'">'.
990: $serverdescription."</option>\n";
991: }
992: $homeserver_form .= "</select>\n";
993: #
994: #
1.94 sakharuk 995: my %lt=&Apache::lonlocal::texthash(
996: 'udf' => "User Data for",
997: 'fn' => "First Name",
998: 'mn' => "Middle Name",
999: 'ln' => "Last Name",
1000: 'gen' => "Generation",
1001: 'hs' => "Home Server",
1002: 'pswd' => "Password",
1003: 'psam' => "Please select an authentication mechanism",
1.124 www 1004: 'mail' => "Email Address"
1.94 sakharuk 1005: );
1.130 www 1006: my $authhelp=&Apache::loncommon::help_open_topic('Auth_Options');
1.74 matthew 1007: $user_data_html = <<END;
1.94 sakharuk 1008: <h3>$lt{'udf'} $username\@$domain</h3>
1.74 matthew 1009: <table>
1.94 sakharuk 1010: <tr><th>$lt{'fn'}:</th>
1.74 matthew 1011: <td><input type="text" name="cfirst" size="15"></td></tr>
1.94 sakharuk 1012: <tr><th>$lt{'mn'}:</th>
1.74 matthew 1013: <td><input type="text" name="cmiddle" size="15"></td></tr>
1.94 sakharuk 1014: <tr><th>$lt{'ln'}:</th>
1.74 matthew 1015: <td><input type="text" name="clast" size="15"></td></tr>
1.94 sakharuk 1016: <tr><th>$lt{'gen'}:</th>
1.74 matthew 1017: <td><input type="text" name="cgen" size="5"> </td></tr>
1.94 sakharuk 1018: <tr><th>$lt{'hs'}:</th>
1.74 matthew 1019: <td>$homeserver_form</td></tr>
1.124 www 1020: <tr><th>$lt{'mail'}:</th>
1021: <td><input type="text" name="emailaddress" size="20" /></td></tr>
1.74 matthew 1022: </table>
1.94 sakharuk 1023: <h3>$lt{'pswd'}</h3>
1.130 www 1024: $lt{'psam'}$authhelp
1.74 matthew 1025: <table>
1026: <p>
1027: $krbform
1.75 matthew 1028: <br />
1.74 matthew 1029: $intform
1.75 matthew 1030: <br />
1.74 matthew 1031: $locform
1032: </p>
1033: END
1034: } else {
1035: # User already exists. Do not worry about authentication
1036: my %uenv = &Apache::lonnet::dump('environment',$domain,$username);
1.89 matthew 1037: $javascript_validations = &javascript_validations('noauth');
1.94 sakharuk 1038: my %lt=&Apache::lonlocal::texthash(
1039: 'udf' => "User Data for",
1040: 'fn' => "First Name",
1041: 'mn' => "Middle Name",
1042: 'ln' => "Last Name",
1043: 'gen' => "Generation",
1.124 www 1044: 'mail' => "Email Address",
1.94 sakharuk 1045: );
1.74 matthew 1046: $user_data_html = <<END;
1.94 sakharuk 1047: <h3>$lt{'udf'} $username\@$domain</h3>
1.74 matthew 1048: <input type="hidden" name="lcserver" value="default" />
1049: <table>
1.94 sakharuk 1050: <tr><th>$lt{'fn'}:</th>
1.74 matthew 1051: <td>
1052: <input type="text" name="cfirst" value="$uenv{'firstname'}" size="15" />
1053: </td></tr>
1.94 sakharuk 1054: <tr><th>$lt{'mn'}:</th>
1.74 matthew 1055: <td>
1056: <input type="text" name="cmiddle" value="$uenv{'middlename'}" size="15" />
1057: </td></tr>
1.94 sakharuk 1058: <tr><th>$lt{'ln'}:</th>
1.74 matthew 1059: <td>
1060: <input type="text" name="clast"value="$uenv{'lastname'}" size="15" />
1061: </td></tr>
1.94 sakharuk 1062: <tr><th>$lt{'gen'}:</th>
1.74 matthew 1063: <td>
1064: <input type="text" name="cgen" value="$uenv{'generation'}" size="5" />
1065: </td></tr>
1.124 www 1066: <tr><th>$lt{'mail'}:</th>
1067: <td>
1068: <input type="text" name="emailaddress" value="$uenv{'permanentemail'}" size="20" />
1069: </td></tr>
1.74 matthew 1070: </table>
1071: END
1072: }
1.68 matthew 1073: my $date_table = &date_setting_table();
1.74 matthew 1074: # Print it all out
1.94 sakharuk 1075: my %lt=&Apache::lonlocal::texthash(
1076: 'cd' => "Course Data",
1077: 'gs' => "Group/Section",
1078: 'idsn' => "ID/Student Number",
1079: 'disn' => "Disable ID/Student Number Safeguard and Force Change of Conflicting IDs (only do if you know what you are doing)",
1080: 'eas' => "Enroll as student",
1081: );
1.50 matthew 1082: $r->print(<<END);
1.74 matthew 1083: <input type="hidden" name="action" value="enrollstudent" />
1084: <input type="hidden" name="state" value="done" />
1085: <input type="hidden" name="cuname" value="$username" />
1086: <input type="hidden" name="lcdomain" value="$domain" />
1.28 matthew 1087: <script type="text/javascript" language="Javascript">
1.12 www 1088: function verify(vf) {
1089: var founduname=0;
1090: var foundpwd=0;
1091: var foundname=0;
1092: var foundid=0;
1093: var foundsec=0;
1094: var tw;
1.26 matthew 1095: if ((typeof(vf.cuname.value) !="undefined") && (vf.cuname.value!='') &&
1.31 matthew 1096: (typeof(vf.lcdomain.value)!="undefined") && (vf.lcdomain.value!='')) {
1.12 www 1097: founduname=1;
1098: }
1.14 harris41 1099: if ((typeof(vf.cfirst.value)!="undefined") && (vf.cfirst.value!='') &&
1.26 matthew 1100: (typeof(vf.clast.value) !="undefined") && (vf.clast.value!='')) {
1.12 www 1101: foundname=1;
1102: }
1.14 harris41 1103: if ((typeof(vf.csec.value)!="undefined") && (vf.csec.value!='')) {
1.12 www 1104: foundsec=1;
1105: }
1.14 harris41 1106: if ((typeof(vf.cstid.value)!="undefined") && (vf.cstid.value!='')) {
1.12 www 1107: foundid=1;
1108: }
1109: if (founduname==0) {
1110: alert('You need to specify at least the username and domain fields');
1111: return;
1112: }
1.24 albertel 1113: verify_message(vf,founduname,foundpwd,foundname,foundid,foundsec);
1.12 www 1114: }
1115:
1.24 albertel 1116: $javascript_validations
1.12 www 1117:
1.24 albertel 1118: function clearpwd(vf) {
1119: //nothing else needs clearing
1.15 albertel 1120: }
1121:
1.12 www 1122: </script>
1.11 www 1123:
1.74 matthew 1124: $user_data_html
1.50 matthew 1125:
1.94 sakharuk 1126: <h3>$lt{'cd'}</h3>
1.50 matthew 1127:
1.94 sakharuk 1128: <p>$lt{'gs'}: <input type="text" name="csec" size="5" />
1.50 matthew 1129: <p>
1.68 matthew 1130: $date_table
1.50 matthew 1131: </p>
1.94 sakharuk 1132: <h3>$lt{'idsn'}</h3>
1.50 matthew 1133: <p>
1.94 sakharuk 1134: $lt{'idsn'}: <input type="text" name="cstid" size="10">
1.26 matthew 1135: </p><p>
1.131 albertel 1136: <label>
1.26 matthew 1137: <input type="checkbox" name="forceid" value="yes">
1.94 sakharuk 1138: $lt{'disn'}
1.131 albertel 1139: </label>
1.50 matthew 1140: </p><p>
1.94 sakharuk 1141: <input type="button" onClick="verify(this.form)" value="$lt{'eas'}">
1.26 matthew 1142: </p>
1.50 matthew 1143: END
1144: return;
1.10 www 1145: }
1146:
1147: # ========================================================= Menu Phase Two Drop
1.51 matthew 1148: sub print_drop_menu {
1.10 www 1149: my $r=shift;
1.92 sakharuk 1150: $r->print("<h3>".&mt('Drop Students')."</h3>");
1.127 albertel 1151: my $cid=$env{'request.course.id'};
1.56 matthew 1152: my ($classlist,$keylist) = &Apache::loncoursedata::get_classlist();
1153: if (! defined($classlist)) {
1.94 sakharuk 1154: $r->print(&mt('There are no students currently enrolled.')."\n");
1.51 matthew 1155: return;
1.25 matthew 1156: }
1.51 matthew 1157: # Print out the available choices
1.56 matthew 1158: &show_drop_list($r,$classlist,$keylist);
1.51 matthew 1159: return;
1.11 www 1160: }
1161:
1.40 matthew 1162: # ============================================== view classlist
1.50 matthew 1163: sub print_html_classlist {
1.103 matthew 1164: my ($r,$mode) = @_;
1.127 albertel 1165: if (! exists($env{'form.sortby'})) {
1166: $env{'form.sortby'} = 'username';
1.57 matthew 1167: }
1.127 albertel 1168: if ($env{'form.Status'} !~ /^(Any|Expired|Active)$/) {
1169: $env{'form.Status'} = 'Active';
1.57 matthew 1170: }
1171: my $status_select = &Apache::lonhtmlcommon::StatusOptions
1.127 albertel 1172: ($env{'form.Status'});
1173: my $cid=$env{'request.course.id'};
1174: my $cdom=$env{'course.'.$cid.'.domain'};
1175: my $cnum=$env{'course.'.$cid.'.num'};
1.103 matthew 1176: #
1177: # List course personnel
1.100 www 1178: my %coursepersonnel=&Apache::lonnet::get_course_adv_roles($cdom.'/'.$cnum);
1.110 matthew 1179: #
1.127 albertel 1180: if (! defined($env{'form.output'}) ||
1181: $env{'form.output'} !~ /^(csv|excel|html)$/ ) {
1182: $env{'form.output'} = 'html';
1.110 matthew 1183: }
1184: #
1.139 albertel 1185: $r->print('<br />'.&Apache::loncommon::start_data_table());
1.110 matthew 1186: foreach my $role (sort keys %coursepersonnel) {
1187: next if ($role =~ /^\s*$/);
1.139 albertel 1188: $r->print(&Apache::loncommon::start_data_table_row().
1189: '<td>'.$role.'</td><td>');
1.110 matthew 1190: foreach my $user (split(',',$coursepersonnel{$role})) {
1191: my ($puname,$pudom)=split(':',$user);
1.100 www 1192: $r->print(' '.&Apache::loncommon::aboutmewrapper(
1.110 matthew 1193: &Apache::loncommon::plainname($puname,
1194: $pudom),
1195: $puname,$pudom));
1.100 www 1196: }
1.139 albertel 1197: $r->print('</td>'.&Apache::loncommon::end_data_table_row());
1.100 www 1198: }
1.139 albertel 1199: $r->print(&Apache::loncommon::end_data_table());
1.103 matthew 1200: #
1201: # Interface output
1202: $r->print('<input type="hidden" name="action" value="'.
1.127 albertel 1203: $env{'form.action'}.'" />');
1.103 matthew 1204: $r->print("<p>\n");
1.127 albertel 1205: if ($env{'form.action'} ne 'modifystudent') {
1.103 matthew 1206: my %lt=&Apache::lonlocal::texthash('csv' => "CSV",
1207: 'excel' => "Excel",
1208: 'html' => 'HTML');
1.110 matthew 1209: my $output_selector = '<select size="1" name="output" >';
1.103 matthew 1210: foreach my $outputformat ('html','csv','excel') {
1211: my $option = '<option value="'.$outputformat.'" ';
1.127 albertel 1212: if ($outputformat eq $env{'form.output'}) {
1.104 matthew 1213: $option .= 'selected ';
1.103 matthew 1214: }
1215: $option .='>'.$lt{$outputformat}.'</option>';
1216: $output_selector .= "\n".$option;
1217: }
1218: $output_selector .= '</select>';
1219: $r->print(&mt('Output Format: [_1]',$output_selector).(' 'x3));
1.59 matthew 1220: }
1.103 matthew 1221: $r->print(&mt('Student Status: [_1]',$status_select)."\n");
1.105 matthew 1222: $r->print('<input type="submit" value="'.&mt('Update Display').'" />'.
1223: "\n</p>\n");
1.103 matthew 1224: #
1225: # Print the classlist
1226: $r->print('<h2>'.&mt('Current Class List').'</h2>');
1.56 matthew 1227: my ($classlist,$keylist)=&Apache::loncoursedata::get_classlist();
1228: if (! defined($classlist)) {
1.94 sakharuk 1229: $r->print(&mt('There are no students currently enrolled.')."\n");
1.40 matthew 1230: } else {
1231: # Print out the available choices
1.127 albertel 1232: if ($env{'form.action'} eq 'modifystudent') {
1.110 matthew 1233: &show_class_list($r,'view','modify',
1.127 albertel 1234: $env{'form.Status'},$classlist,$keylist);
1.110 matthew 1235: } else {
1.127 albertel 1236: &show_class_list($r,$env{'form.output'},'aboutme',
1237: $env{'form.Status'},$classlist,$keylist);
1.50 matthew 1238: }
1.41 matthew 1239: }
1240: }
1241:
1.40 matthew 1242: # =================================================== Show student list to drop
1243: sub show_class_list {
1.110 matthew 1244: my ($r,$mode,$linkto,$statusmode,$classlist,$keylist)=@_;
1.127 albertel 1245: my $cid=$env{'request.course.id'};
1.60 matthew 1246: #
1247: # Variables for excel output
1.104 matthew 1248: my ($excel_workbook, $excel_sheet, $excel_filename,$row,$format);
1.60 matthew 1249: #
1.103 matthew 1250: # Variables for csv output
1251: my ($CSVfile,$CSVfilename);
1252: #
1.127 albertel 1253: my $sortby = $env{'form.sortby'};
1.114 raeburn 1254: if ($sortby !~ /^(username|domain|section|fullname|id|start|end|type)$/) {
1.53 matthew 1255: $sortby = 'username';
1256: }
1.134 raeburn 1257: if (! exists($env{'form.displayphotos'})) {
1258: $env{'form.displayphotos'} = 'off';
1259: }
1260: my $displayphotos = $env{'form.displayphotos'};
1261:
1.42 matthew 1262: # Print out header
1.114 raeburn 1263: unless ($mode eq 'autoenroll') {
1264: $r->print(<<END);
1.127 albertel 1265: <input type="hidden" name="state" value="$env{'form.state'}" />
1.114 raeburn 1266: END
1267: }
1.103 matthew 1268: $r->print(<<END);
1269: <input type="hidden" name="sortby" value="$sortby" />
1.134 raeburn 1270: <input type="hidden" name="displayphotos" value="$displayphotos" />
1.103 matthew 1271: END
1.114 raeburn 1272: if ($mode eq 'html' || $mode eq 'view' || $mode eq 'autoenroll') {
1.50 matthew 1273: if ($linkto eq 'aboutme') {
1.94 sakharuk 1274: $r->print(&mt('Select a user name to view the users personal page.'));
1.50 matthew 1275: } elsif ($linkto eq 'modify') {
1.94 sakharuk 1276: $r->print(&mt('Select a user name to modify the students information'));
1.50 matthew 1277: }
1.94 sakharuk 1278: my %lt=&Apache::lonlocal::texthash(
1.110 matthew 1279: 'usrn' => "username",
1280: 'dom' => "domain",
1281: 'sn' => "student name",
1282: 'sec' => "section",
1283: 'start' => "start date",
1284: 'end' => "end date",
1.134 raeburn 1285: 'type' => "enroll type/action",
1286: 'photo' => "photo",
1.94 sakharuk 1287: );
1.114 raeburn 1288: unless ($mode eq 'autoenroll') {
1289: $r->print(<<END);
1.59 matthew 1290: <input type="hidden" name="sname" value="" />
1291: <input type="hidden" name="sdom" value="" />
1.114 raeburn 1292: END
1293: }
1.136 raeburn 1294: if ($env{'course.'.$env{'request.course.id'}.'.internal.showphoto'}) {
1.134 raeburn 1295: $r->print('
1296: <script type="text/javascript">
1297: function photowindow(photolink) {
1298: var title = "Photo_Viewer";
1299: var options = "scrollbars=1,resizable=1,menubar=0";
1300: options += ",width=240,height=240";
1301: stdeditbrowser = open(photolink,title,options,"1");
1302: stdeditbrowser.focus();
1303: }
1304: </script>
1305: ');
1306: }
1.115 raeburn 1307: $r->print("
1.40 matthew 1308: <p>
1.139 albertel 1309: ".&Apache::loncommon::start_data_table()."
1.115 raeburn 1310: <tr>
1311: ");
1312: if ($mode eq 'autoenroll') {
1313: $r->print("
1314: <th><a href=\"javascript:document.studentform.sortby.value='type';document.studentform.submit();\">$lt{'type'}</a></th>
1315: ");
1316: } else {
1317: $r->print("
1318: <th>Count</th>
1319: ");
1320: }
1321: $r->print(<<END);
1322: <th>
1.94 sakharuk 1323: <a href="javascript:document.studentform.sortby.value='username';document.studentform.submit();">$lt{'usrn'}</a>
1.53 matthew 1324: </th><th>
1.94 sakharuk 1325: <a href="javascript:document.studentform.sortby.value='domain';document.studentform.submit();">$lt{'dom'}</a>
1.53 matthew 1326: </th><th>
1.57 matthew 1327: <a href="javascript:document.studentform.sortby.value='id';document.studentform.submit();">ID</a>
1.53 matthew 1328: </th><th>
1.94 sakharuk 1329: <a href="javascript:document.studentform.sortby.value='fullname';document.studentform.submit();">$lt{'sn'}</a>
1.53 matthew 1330: </th><th>
1.94 sakharuk 1331: <a href="javascript:document.studentform.sortby.value='section';document.studentform.submit();">$lt{'sec'}</a>
1.110 matthew 1332: </th><th>
1333: <a href="javascript:document.studentform.sortby.value='start';document.studentform.submit();">$lt{'start'}</a>
1334: </th><th>
1335: <a href="javascript:document.studentform.sortby.value='end';document.studentform.submit();">$lt{'end'}</a>
1.53 matthew 1336: </th>
1.40 matthew 1337: END
1.136 raeburn 1338: if ($env{'course.'.$env{'request.course.id'}.'.internal.showphoto'}) {
1.135 albertel 1339: my %photo_options = &Apache::lonlocal::texthash(
1.134 raeburn 1340: 'on' => 'Show',
1341: 'off' => 'Hide',
1342: );
1343: my $photochg = 'on';
1344: if ($displayphotos eq 'on') {
1345: $photochg = 'off';
1346: }
1347: $r->print(' <th>'."\n".' '.
1348: '<a href="javascript:document.studentform.displayphotos.value='.
1349: "'".$photochg."'".';document.studentform.submit();">'.
1350: $photo_options{$photochg}.'</a> '.$lt{'photo'}."\n".
1351: ' </th>'."\n");
1352: }
1353: $r->print(" </tr>\n");
1.41 matthew 1354: } elsif ($mode eq 'csv') {
1.103 matthew 1355: #
1356: # Open a file
1357: $CSVfilename = '/prtspool/'.
1.127 albertel 1358: $env{'user.name'}.'_'.$env{'user.domain'}.'_'.
1.103 matthew 1359: time.'_'.rand(1000000000).'.csv';
1360: unless ($CSVfile = Apache::File->new('>/home/httpd'.$CSVfilename)) {
1361: $r->log_error("Couldn't open $CSVfilename for output $!");
1362: $r->print("Problems occured in writing the csv file. ".
1363: "This error has been logged. ".
1364: "Please alert your LON-CAPA administrator.");
1365: $CSVfile = undef;
1366: }
1367: #
1368: # Write headers and data to file
1.58 matthew 1369: if($statusmode eq 'Expired') {
1.103 matthew 1370: print $CSVfile '"'.&mt('Students with expired roles').'"'."\n";
1.58 matthew 1371: }
1372: if ($statusmode eq 'Any') {
1.103 matthew 1373: print $CSVfile '"'.join('","',map {
1374: &Apache::loncommon::csv_translate(&mt($_))
1375: } ("username","domain","ID","student name",
1.110 matthew 1376: "section","start date","end date","status")).'"'."\n";
1.58 matthew 1377: } else {
1.103 matthew 1378: print $CSVfile '"'.join('","',map {
1379: &Apache::loncommon::csv_translate(&mt($_))
1380: } ("username","domain","ID","student name",
1.110 matthew 1381: "section","start date","end date")).'"'."\n";
1.58 matthew 1382: }
1.60 matthew 1383: } elsif ($mode eq 'excel') {
1384: # Create the excel spreadsheet
1.126 matthew 1385: ($excel_workbook,$excel_filename,$format) =
1386: &Apache::loncommon::create_workbook($r);
1387: return if (! defined($excel_workbook));
1.60 matthew 1388: $excel_sheet = $excel_workbook->addworksheet('classlist');
1389: #
1.76 albertel 1390: my $description = 'Class List for '.
1.127 albertel 1391: $env{'course.'.$env{'request.course.id'}.'.description'};
1.104 matthew 1392: $excel_sheet->write($row++,0,$description,$format->{'h1'});
1.60 matthew 1393: #
1394: $excel_sheet->write($row++,0,["username","domain","ID",
1.110 matthew 1395: "student name","section",
1396: "start date","end date","status"],
1397: $format->{'bold'});
1.41 matthew 1398: }
1.56 matthew 1399: #
1400: # Sort the students
1401: my %index;
1402: my $i;
1403: foreach (@$keylist) {
1404: $index{$_} = $i++;
1405: }
1406: my $index = $index{$sortby};
1407: my $second = $index{'username'};
1408: my $third = $index{'domain'};
1.53 matthew 1409: my @Sorted_Students = sort {
1.56 matthew 1410: lc($classlist->{$a}->[$index]) cmp lc($classlist->{$b}->[$index])
1411: ||
1412: lc($classlist->{$a}->[$second]) cmp lc($classlist->{$b}->[$second])
1413: ||
1414: lc($classlist->{$a}->[$third]) cmp lc($classlist->{$b}->[$third])
1415: } (keys(%$classlist));
1.108 matthew 1416: my $studentcount = 0;
1.115 raeburn 1417: my $autocount = 0;
1418: my $manualcount = 0;
1419: my $unlockcount = 0;
1420: my $lockcount = 0;
1.53 matthew 1421: foreach my $student (@Sorted_Students) {
1.110 matthew 1422: my $sdata = $classlist->{$student};
1423: my $username = $sdata->[$index{'username'}];
1424: my $domain = $sdata->[$index{'domain'}];
1425: my $section = $sdata->[$index{'section'}];
1426: my $name = $sdata->[$index{'fullname'}];
1427: my $id = $sdata->[$index{'id'}];
1428: my $status = $sdata->[$index{'status'}];
1429: my $start = $sdata->[$index{'start'}];
1430: my $end = $sdata->[$index{'end'}];
1.115 raeburn 1431: my $type = $sdata->[$index{'type'}];
1.57 matthew 1432: next if (($statusmode ne 'Any') && ($status ne $statusmode));
1.114 raeburn 1433: if ($mode eq 'view' || $mode eq 'html' || $mode eq 'autoenroll') {
1434: if (! defined($start) || $start == 0) {
1435: $start = &mt('none');
1436: } else {
1437: $start = &Apache::lonlocal::locallocaltime($start);
1438: }
1439: if (! defined($end) || $end == 0) {
1440: $end = &mt('none');
1441: } else {
1442: $end = &Apache::lonlocal::locallocaltime($end);
1443: }
1.139 albertel 1444: $r->print(&Apache::loncommon::start_data_table_row());
1.115 raeburn 1445: if ($mode eq 'autoenroll') {
1446: my $lockedtype = $sdata->[$index{'lockedtype'}];
1447: $studentcount++;
1448: my $cellentry;
1449: if ($type eq 'auto') {
1.131 albertel 1450: $cellentry = '<b>'.&mt('auto').'</b> <label><input type="checkbox" name="chgauto" value="'.$username.':'.$domain.'" /> Change</label>';
1.115 raeburn 1451: $autocount ++;
1452: } else {
1.131 albertel 1453: $cellentry = '<table border="0" cellspacing="0"><tr><td rowspan="2"><b>'.&mt('manual').'</b></td><td><nobr><label><input type="checkbox" name="chgmanual" value="'.$username.':'.$domain.'" /> Change</label></nobr></td></tr><tr><td><nobr>';
1.115 raeburn 1454: $manualcount ++;
1455: if ($lockedtype) {
1.131 albertel 1456: $cellentry .= '<label><input type="checkbox" name="unlockchg" value="'.$username.':'.$domain.'" /> '.&mt('Unlock').'</label>';
1.115 raeburn 1457: $unlockcount ++;
1458: } else {
1.131 albertel 1459: $cellentry .= '<label><input type="checkbox" name="lockchg" value="'.$username.':'.$domain.'" /> '.&mt('Lock').'</label>';
1.115 raeburn 1460: $lockcount ++;
1461: }
1.118 raeburn 1462: $cellentry .= '</nobr></td></tr></table>';
1.115 raeburn 1463: }
1464: $r->print("<td>$cellentry<td>\n ");
1465: } else {
1466: $r->print("<td>".(++$studentcount)."</td><td>\n ");
1467: }
1.51 matthew 1468: if ($linkto eq 'nothing') {
1469: $r->print($username);
1470: } elsif ($linkto eq 'aboutme') {
1471: $r->print(&Apache::loncommon::aboutmewrapper($username,
1472: $username,
1473: $domain));
1474: } elsif ($linkto eq 'modify') {
1.59 matthew 1475: $r->print('<a href="'.
1476: "javascript:document.studentform.sname.value='".
1477: $username.
1478: "';document.studentform.sdom.value='".$domain.
1479: "';document.studentform.state.value='selected".
1480: "';document.studentform.submit();".'">'.
1.53 matthew 1481: $username."</a>\n");
1.50 matthew 1482: }
1.51 matthew 1483: $r->print(<<"END");
1.50 matthew 1484: </td>
1.51 matthew 1485: <td>$domain</td>
1486: <td>$id</td>
1487: <td>$name</td>
1488: <td>$section</td>
1.110 matthew 1489: <td>$start</td>
1490: <td>$end</td>
1.114 raeburn 1491: END
1.134 raeburn 1492: if ($env{'course.'.$env{'request.course.id'}.
1.136 raeburn 1493: '.internal.showphoto'}) {
1.134 raeburn 1494: if ($displayphotos eq 'on') {
1.135 albertel 1495: my $imgurl =
1496: &Apache::lonnet::retrievestudentphoto($domain,
1497: $username,'gif',
1498: 'thumbnail');
1.134 raeburn 1499:
1500: $r->print(' <td align="right"><a href="javascript:photowindow('."'".&Apache::lonnet::studentphoto($domain,$username,'jpg')."'".')"><img src="'.$imgurl.'" border="1"></a></td>');
1501: } else {
1502: $r->print(' <td> </td> ');
1503: }
1504: }
1.139 albertel 1505: $r->print(&Apache::loncommon::end_data_table_row());
1.51 matthew 1506: } elsif ($mode eq 'csv') {
1.103 matthew 1507: next if (! defined($CSVfile));
1.51 matthew 1508: # no need to bother with $linkto
1.114 raeburn 1509: if (! defined($start) || $start == 0) {
1510: $start = &mt('none');
1511: } else {
1512: $start = &Apache::lonlocal::locallocaltime($start);
1513: }
1514: if (! defined($end) || $end == 0) {
1515: $end = &mt('none');
1516: } else {
1517: $end = &Apache::lonlocal::locallocaltime($end);
1518: }
1.51 matthew 1519: my @line = ();
1.110 matthew 1520: foreach ($username,$domain,$id,$name,$section,$start,$end) {
1.51 matthew 1521: push @line,&Apache::loncommon::csv_translate($_);
1.58 matthew 1522: }
1523: if ($statusmode eq 'Any') {
1524: push @line,&Apache::loncommon::csv_translate($status);
1.41 matthew 1525: }
1.103 matthew 1526: print $CSVfile '"'.join('","',@line).'"'."\n";
1.60 matthew 1527: } elsif ($mode eq 'excel') {
1.110 matthew 1528: $excel_sheet->write($row,0,[$username,$domain,$id,
1529: $name,$section]);
1530: my $col = 5;
1531: foreach my $time ($start,$end) {
1.129 matthew 1532: if (defined($time) && $time != 0) {
1533: $excel_sheet->write($row,$col++,
1.110 matthew 1534: &Apache::lonstathelpers::calc_serial($time),
1535: $format->{'date'});
1.129 matthew 1536: } else {
1537: $excel_sheet->write($row,$col++,'none');
1538: }
1.110 matthew 1539: }
1540: $excel_sheet->write($row,$col++,$status);
1541: $row++;
1.40 matthew 1542: }
1543: }
1.114 raeburn 1544: if ($mode eq 'view' || $mode eq 'html' || $mode eq 'autoenroll') {
1.139 albertel 1545: $r->print(&Apache::loncommon::end_data_table().'<br />');
1.60 matthew 1546: } elsif ($mode eq 'excel') {
1547: $excel_workbook->close();
1548: $r->print('<p><a href="'.$excel_filename.'">'.
1.94 sakharuk 1549: &mt('Your Excel spreadsheet').'</a> '.&mt('is ready for download').'.</p>'."\n");
1.103 matthew 1550: } elsif ($mode eq 'csv') {
1551: close($CSVfile);
1552: $r->print('<a href="'.$CSVfilename.'">'.
1553: &mt('Your CSV file').'</a> is ready for download.'.
1554: "\n");
1555: $r->rflush();
1.60 matthew 1556: }
1.114 raeburn 1557: if ($mode eq 'autoenroll') {
1.115 raeburn 1558: return ($studentcount,$autocount,$manualcount,$lockcount,$unlockcount);
1.114 raeburn 1559: }
1.115 raeburn 1560: return;
1.40 matthew 1561: }
1562:
1.50 matthew 1563:
1564: #
1565: # print out form for modification of a single students data
1566: #
1567: sub print_modify_student_form {
1568: my $r = shift();
1569: &Apache::loncommon::get_unprocessed_cgi($ENV{'QUERY_STRING'},
1.59 matthew 1570: ['sdom','sname']);
1.127 albertel 1571: my $sname = $env{'form.sname'};
1572: my $sdom = $env{'form.sdom'};
1573: my $sortby = $env{'form.sortby'};
1.50 matthew 1574: # determine the students name information
1575: my %info=&Apache::lonnet::get('environment',
1576: ['firstname','middlename',
1.52 matthew 1577: 'lastname','generation','id'],
1.50 matthew 1578: $sdom, $sname);
1579: my ($tmp) = keys(%info);
1580: if ($tmp =~ /^(con_lost|error|no_such_host)/i) {
1.94 sakharuk 1581: $r->print('<font color="#ff0000" size="+2">'.&mt('Error').'</font>'.
1.50 matthew 1582: '<p>'.
1.94 sakharuk 1583: &mt('Unable to retrieve environment data for').' '.$sname.
1584: &mt('in domain').' '.$sdom.'</p><p>'.
1.138 albertel 1585: &mt('Please contact your LON-CAPA administrator regarding this situation.').'</p>'.&Apache::loncommon::end_page());
1.50 matthew 1586: return;
1587: }
1588: # determine the students starting and ending times and section
1589: my ($starttime,$endtime,$section) = &get_enrollment_data($sname,$sdom);
1.87 matthew 1590: if ($starttime =~ /^error/) {
1.94 sakharuk 1591: $r->print('<h2>'&mt('Error').'</h2>');
1.87 matthew 1592: $r->print('<p>'.$starttime.'</p>');
1593: return;
1594: }
1.101 matthew 1595: #
1.50 matthew 1596: # Deal with date forms
1.101 matthew 1597: my $current_date_description = '';
1598: my $textdate = '';
1599:
1600: if (! defined($starttime) || $starttime == 0) {
1601: $current_date_description = &mt('Current Starting Date: not set').
1602: '<br />';
1603: } else {
1604: $current_date_description =
1605: &mt('Current Starting Date: [_1]',
1606: &Apache::lonlocal::locallocaltime($starttime)).'<br />';
1607: }
1608: if (! defined($endtime) || $endtime == 0) {
1609: $current_date_description.= &mt('Current Ending Date: not set').
1610: '<br />';
1611: } else {
1612: $current_date_description.=
1613: &mt('Current Ending Date: [_1]',
1614: &Apache::lonlocal::locallocaltime($endtime)).'<br />';
1615:
1616: }
1.68 matthew 1617: my $date_table = &date_setting_table($starttime,$endtime);
1.59 matthew 1618: #
1.127 albertel 1619: if (! exists($env{'form.Status'}) ||
1620: $env{'form.Status'} !~ /^(Any|Expired|Active)$/) {
1621: $env{'form.Status'} = 'crap';
1.59 matthew 1622: }
1.94 sakharuk 1623: # Make sure student is enrolled in course
1624: my %lt=&Apache::lonlocal::texthash(
1625: 'mef' => "Modify Enrollment for",
1626: 'odcc' => "Only domain coordinators can change a users password.",
1627: 'sn' => "Student Name",
1628: 'fn' => "First",
1629: 'mn' => "Middle",
1630: 'ln' => "Last",
1631: 'gen' => "Generation",
1632: 'sid' => "Student ID",
1633: 'disn' => "Disable ID/Student Number Safeguard and Force Change of Conflicting IDs (only do if you know what you are doing)",
1634: 'sec' => "Section",
1635: 'sm' => "Submit Modifications",
1636: );
1.50 matthew 1637: $r->print(<<END);
1.52 matthew 1638: <p>
1639: <font size="+1">
1.94 sakharuk 1640: $lt{'odcc'}
1.52 matthew 1641: </font>
1642: </p>
1.50 matthew 1643: <input type="hidden" name="slogin" value="$sname" />
1644: <input type="hidden" name="sdomain" value="$sdom" />
1645: <input type="hidden" name="action" value="modifystudent" />
1.53 matthew 1646: <input type="hidden" name="state" value="done" />
1647: <input type="hidden" name="sortby" value="$sortby" />
1.127 albertel 1648: <input type="hidden" name="Status" value="$env{'form.Status'}" />
1.94 sakharuk 1649: <h2>$lt{'mef'} $info{'firstname'} $info{'middlename'}
1.50 matthew 1650: $info{'lastname'} $info{'generation'}, $sname\@$sdom</h2>
1651: <p>
1.94 sakharuk 1652: <b>$lt{'sn'}</b>
1.50 matthew 1653: <table>
1.94 sakharuk 1654: <tr><th>$lt{'fn'}</th><th>$lt{'mn'}</th><th>$lt{'ln'}</th><th>$lt{'gen'}</th></tr>
1.50 matthew 1655: <tr><td>
1656: <input type="text" name="firstname" value="$info{'firstname'}" /></td><td>
1657: <input type="text" name="middlename" value="$info{'middlename'}" /></td><td>
1658: <input type="text" name="lastname" value="$info{'lastname'}" /></td><td>
1659: <input type="text" name="generation" value="$info{'generation'}" /></td></tr>
1660: </table>
1661: </p><p>
1.94 sakharuk 1662: <b>$lt{'sid'}</b>: <input type="text" name="id" value="$info{'id'}" size="12"/>
1.52 matthew 1663: </p><p>
1.131 albertel 1664: <label>
1.53 matthew 1665: <input type="checkbox" name="forceid" >
1.94 sakharuk 1666: $lt{'disn'}
1.131 albertel 1667: </label>
1.53 matthew 1668: </p><p>
1.101 matthew 1669: <b>$lt{'sec'}</b>: <input type="text" name="section" value="$section" size="14"/>
1.50 matthew 1670: </p>
1.101 matthew 1671: <p>$current_date_description</p>
1.68 matthew 1672: <p>$date_table</p>
1.94 sakharuk 1673: <input type="submit" value="$lt{'sm'}" />
1.50 matthew 1674: END
1.138 albertel 1675: $r->print(&Apache::loncommon::end_page());
1.50 matthew 1676: return;
1677: }
1678:
1679: #
1680: # modify a single students section
1681: #
1682: sub modify_single_student {
1.138 albertel 1683: my ($r) = @_;
1.68 matthew 1684: #
1.80 matthew 1685: # Remove non alphanumeric values from the section
1.127 albertel 1686: $env{'form.section'} =~ s/\W//g;
1.77 matthew 1687: #
1.68 matthew 1688: # Do the date defaults first
1689: my ($starttime,$endtime) = &get_dates_from_form();
1.127 albertel 1690: if ($env{'form.makedatesdefault'}) {
1.68 matthew 1691: $r->print(&make_dates_default($starttime,$endtime));
1692: }
1.59 matthew 1693: # Get the 'sortby' and 'Status' variables so the user goes back to their
1694: # previous screen
1.127 albertel 1695: my $sortby = $env{'form.sortby'};
1696: my $status = $env{'form.Status'};
1.53 matthew 1697: #
1698: # We always need this information
1.127 albertel 1699: my $slogin = $env{'form.slogin'};
1700: my $sdom = $env{'form.sdomain'};
1.53 matthew 1701: #
1702: # Get the old data
1703: my %old=&Apache::lonnet::get('environment',
1704: ['firstname','middlename',
1705: 'lastname','generation','id'],
1706: $sdom, $slogin);
1.59 matthew 1707: $old{'section'} = &Apache::lonnet::getsection($sdom,$slogin,
1.127 albertel 1708: $env{'request.course.id'});
1.53 matthew 1709: my ($tmp) = keys(%old);
1710: if ($tmp =~ /^(con_lost|error|no_such_host)/i) {
1.94 sakharuk 1711: $r->print(&mt('There was an error determining the environment values for')." $slogin \@ $sdom.");
1.53 matthew 1712: return;
1713: }
1714: undef $tmp;
1715: #
1716: # Get the new data
1.127 albertel 1717: my $firstname = $env{'form.firstname'};
1718: my $middlename = $env{'form.middlename'};
1719: my $lastname = $env{'form.lastname'};
1720: my $generation = $env{'form.generation'};
1721: my $section = $env{'form.section'};
1722: my $courseid = $env{'request.course.id'};
1723: my $sid = $env{'form.id'};
1.50 matthew 1724: my $displayable_starttime = localtime($starttime);
1725: my $displayable_endtime = localtime($endtime);
1.53 matthew 1726: #
1727: # check for forceid override
1.63 matthew 1728: if ((defined($old{'id'})) && ($old{'id'} ne '') &&
1.127 albertel 1729: ($sid ne $old{'id'}) && (! exists($env{'form.forceid'}))) {
1.94 sakharuk 1730: $r->print("<font color=\"ff0000\">".&mt('You changed the students id but did not disable the ID change safeguard. The students id will not be changed.')."</font>");
1.53 matthew 1731: $sid = $old{'id'};
1732: }
1733: #
1.50 matthew 1734: # talk to the user about what we are going to do
1.94 sakharuk 1735: my %lt=&Apache::lonlocal::texthash(
1736: 'mdu' => "Modifying data for user",
1737: 'si' => "Student Information",
1738: 'fd' => "Field",
1739: 'ov' => "Old Value",
1740: 'nv' => "New Value",
1741: 'fn' => "First name",
1742: 'mn' => "Middle name",
1743: 'ln' => "Last name",
1744: 'gen' => "Generation",
1745: 'sec' => "Section",
1746: 'ri' => "Role Information",
1747: 'st' => "Start Time",
1748: 'et' => "End Time",
1749: );
1.50 matthew 1750: $r->print(<<END);
1.94 sakharuk 1751: <h2>$lt{'mdu'} $slogin \@ $sdom </h2>
1752: <h3>$lt{'si'}</h3>
1.53 matthew 1753: <table rules="rows" border="1" cellpadding="3" >
1754: <tr>
1.94 sakharuk 1755: <th> $lt{'fd'} </th>
1756: <th> $lt{'ov'} </th>
1757: <th> $lt{'nv'} </th>
1.53 matthew 1758: </tr>
1759: <tr>
1.94 sakharuk 1760: <td> <b>$lt{'fn'}</b> </td>
1.53 matthew 1761: <td> $old{'firstname'} </td>
1762: <td> $firstname </td>
1763: </tr><tr>
1.94 sakharuk 1764: <td> <b>$lt{'mn'}</b> </td>
1.53 matthew 1765: <td> $old{'middlename'} </td>
1766: <td> $middlename </td>
1767: </tr><tr>
1.94 sakharuk 1768: <td> <b>$lt{'ln'}</b> </td>
1.53 matthew 1769: <td> $old{'lastname'} </td>
1770: <td> $lastname </td>
1771: </tr><tr>
1.94 sakharuk 1772: <td> <b>$lt{'gen'}</b> </td>
1.53 matthew 1773: <td> $old{'generation'} </td>
1774: <td> $generation </td>
1775: </tr><tr>
1776: <td> <b>ID</b> </td>
1777: <td> $old{'id'} </td>
1778: <td> $sid </td>
1.59 matthew 1779: </tr><tr>
1.94 sakharuk 1780: <td> <b>$lt{'sec'}</b> </td>
1.59 matthew 1781: <td> $old{'section'} </td>
1782: <td> $section</td>
1.53 matthew 1783: </tr>
1.50 matthew 1784: </table>
1.94 sakharuk 1785: <h3>$lt{'ri'}</h3>
1.50 matthew 1786: <table>
1.94 sakharuk 1787: <tr><td align="right"><b>$lt{'st'}:</b></td><td> $displayable_starttime </td></tr>
1788: <tr><td align="right"><b>$lt{'et'}:</b></td><td> $displayable_endtime </td></tr>
1.50 matthew 1789: </table>
1.52 matthew 1790: <p>
1.50 matthew 1791: END
1.53 matthew 1792: #
1.63 matthew 1793: # Send request(s) to modify data (final undef is for 'desiredhost',
1794: # which is a moot point because the student already has an account.
1795: my $modify_section_results = &modifystudent($sdom,$slogin,
1.127 albertel 1796: $env{'request.course.id'},
1.63 matthew 1797: $section,undef);
1798: if ($modify_section_results !~ /^ok/) {
1.94 sakharuk 1799: $r->print(&mt('An error occured during the attempt to change the section for this student.')."<br />");
1.63 matthew 1800: }
1.52 matthew 1801: my $roleresults = &Apache::lonnet::modifystudent
1.53 matthew 1802: ($sdom,$slogin,$sid,undef,undef,$firstname,$middlename,$lastname,
1.127 albertel 1803: $generation,$section,$endtime,$starttime,$env{'form.forceid'});
1.53 matthew 1804: if ($roleresults eq 'refused' ) {
1.94 sakharuk 1805: $r->print(&mt('Your request to change the role information for this student was refused. You do not appear to have sufficient authority to change student information.'));
1.50 matthew 1806: } elsif ($roleresults !~ /ok/) {
1.94 sakharuk 1807: $r->print(&mt('An error occurred during the attempt to change the role information for this student.')." <br />".
1808: &mt('The error reported was')." ".
1.50 matthew 1809: $roleresults);
1.53 matthew 1810: &Apache::lonnet::logthis("londropadd:failed attempt to modify student".
1811: " data for ".$slogin." \@ ".$sdom." by ".
1.127 albertel 1812: $env{'user.name'}." \@ ".$env{'user.domain'}.
1.53 matthew 1813: ":".$roleresults);
1.50 matthew 1814: } else { # everything is okay!
1.94 sakharuk 1815: $r->print(&mt('Student information updated successfully.')." <br />".
1816: &mt('The student must log out and log in again to see these changes.'));
1.50 matthew 1817: }
1.94 sakharuk 1818: my $Masd=&mt('Modify another students data');
1.50 matthew 1819: $r->print(<<END);
1.52 matthew 1820: </p><p>
1.59 matthew 1821: <input type="hidden" name="action" value="modifystudent" />
1822: <input type="hidden" name="sortby" value="$sortby" />
1823: <input type="hidden" name="Status" value="$status" />
1.94 sakharuk 1824: <a href="javascript:document.studentform.submit();">$Masd</a>
1.50 matthew 1825: END
1.138 albertel 1826: $r->print(&Apache::loncommon::end_page());
1.50 matthew 1827: return;
1828: }
1829:
1830: sub get_enrollment_data {
1831: my ($sname,$sdomain) = @_;
1.127 albertel 1832: my $courseid = $env{'request.course.id'};
1.50 matthew 1833: $courseid =~ s:_:/:g;
1834: my %roles = &Apache::lonnet::dump('roles',$sdomain,$sname);
1835: my ($tmp) = keys(%roles);
1836: # Bail out if we were unable to get the students roles
1.87 matthew 1837: return ('error'.$tmp) if ($tmp =~ /^(con_lost|error|no_such_host)/i);
1.50 matthew 1838: # Go through the roles looking for enrollment in this course
1839: my ($end,$start) = (undef,undef);
1840: my $section = '';
1841: my $count = scalar(keys(%roles));
1842: while (my ($course,$role) = each(%roles)) {
1843: if ($course=~ /^\/$courseid\/*\s*(\w+)*_st$/ ) {
1844: #
1845: # Get active role
1846: $section=$1;
1847: (undef,$end,$start)=split(/\_/,$role);
1848: my $now=time;
1849: my $notactive=0;
1850: if ($start) {
1851: if ($now<$start) { $notactive=1; }
1852: }
1853: if ($end) {
1854: if ($now>$end) { $notactive=1; }
1855: }
1856: unless ($notactive) { return ($start,$end,$section); }
1857: }
1858: }
1859: return ($start,$end,$section);
1860: }
1861:
1.56 matthew 1862: #################################################
1863: #################################################
1864:
1865: =pod
1866:
1867: =item show_drop_list
1868:
1869: Display a list of students to drop
1870: Inputs:
1871:
1872: =over 4
1873:
1874: =item $r, Apache request
1875:
1876: =item $classlist, hash pointer returned from loncoursedata::get_classlist();
1877:
1878: =item $keylist, array pointer returned from loncoursedata::get_classlist()
1879: which describes the order elements are stored in the %$classlist values.
1880:
1881: =item $nosort, if true, sorting links are omitted.
1882:
1883: =back
1884:
1885: =cut
1886:
1887: #################################################
1888: #################################################
1.11 www 1889: sub show_drop_list {
1.56 matthew 1890: my ($r,$classlist,$keylist,$nosort)=@_;
1.127 albertel 1891: my $cid=$env{'request.course.id'};
1892: if (! exists($env{'form.sortby'})) {
1.59 matthew 1893: &Apache::loncommon::get_unprocessed_cgi($ENV{'QUERY_STRING'},
1894: ['sortby']);
1895: }
1.127 albertel 1896: my $sortby = $env{'form.sortby'};
1.110 matthew 1897: if ($sortby !~ /^(username|domain|section|fullname|id|start|end)$/) {
1.54 matthew 1898: $sortby = 'username';
1899: }
1.56 matthew 1900: #
1.54 matthew 1901: my $action = "drop";
1902: $r->print(<<END);
1903: <input type="hidden" name="sortby" value="$sortby" />
1904: <input type="hidden" name="action" value="$action" />
1.50 matthew 1905: <input type="hidden" name="state" value="done" />
1.32 matthew 1906: <script>
1.51 matthew 1907: function checkAll(field) {
1.32 matthew 1908: for (i = 0; i < field.length; i++)
1909: field[i].checked = true ;
1910: }
1911:
1.51 matthew 1912: function uncheckAll(field) {
1.32 matthew 1913: for (i = 0; i < field.length; i++)
1914: field[i].checked = false ;
1915: }
1916: </script>
1917: <p>
1.26 matthew 1918: <input type="hidden" name="phase" value="four">
1.56 matthew 1919: END
1920:
1.110 matthew 1921: my %lt=&Apache::lonlocal::texthash('usrn' => "username",
1922: 'dom' => "domain",
1923: 'sn' => "student name",
1924: 'sec' => "section",
1925: 'start' => "start date",
1926: 'end' => "end date",
1927: );
1.56 matthew 1928: if ($nosort) {
1.139 albertel 1929: $r->print(&Apache::loncommon::start_data_table());
1.56 matthew 1930: $r->print(<<END);
1931: <tr>
1932: <th> </th>
1.94 sakharuk 1933: <th>$lt{'usrn'}</th>
1934: <th>$lt{'dom'}</th>
1.56 matthew 1935: <th>ID</th>
1.94 sakharuk 1936: <th>$lt{'sn'}</th>
1937: <th>$lt{'sec'}</th>
1.110 matthew 1938: <th>$lt{'start'}</th>
1939: <th>$lt{'end'}</th>
1.56 matthew 1940: </tr>
1941: END
1942:
1943: } else {
1.139 albertel 1944: $r->print(&Apache::loncommon::start_data_table());
1.56 matthew 1945: $r->print(<<END);
1.54 matthew 1946: <tr><th> </th>
1947: <th>
1.94 sakharuk 1948: <a href="/adm/dropadd?action=$action&sortby=username">$lt{'usrn'}</a>
1.54 matthew 1949: </th><th>
1.94 sakharuk 1950: <a href="/adm/dropadd?action=$action&sortby=domain">$lt{'dom'}</a>
1.54 matthew 1951: </th><th>
1952: <a href="/adm/dropadd?action=$action&sortby=id">ID</a>
1953: </th><th>
1.94 sakharuk 1954: <a href="/adm/dropadd?action=$action&sortby=fullname">$lt{'sn'}</a>
1.54 matthew 1955: </th><th>
1.94 sakharuk 1956: <a href="/adm/dropadd?action=$action&sortby=section">$lt{'sec'}</a>
1.110 matthew 1957: </th><th>
1958: <a href="/adm/dropadd?action=$action&sortby=start">$lt{'start'}</a>
1959: </th><th>
1960: <a href="/adm/dropadd?action=$action&sortby=end">$lt{'end'}</a>
1.54 matthew 1961: </th>
1962: </tr>
1.26 matthew 1963: END
1.56 matthew 1964: }
1965: #
1966: # Sort the students
1967: my %index;
1968: my $i;
1969: foreach (@$keylist) {
1970: $index{$_} = $i++;
1971: }
1972: my $index = $index{$sortby};
1973: my $second = $index{'username'};
1974: my $third = $index{'domain'};
1.54 matthew 1975: my @Sorted_Students = sort {
1.56 matthew 1976: lc($classlist->{$a}->[$index]) cmp lc($classlist->{$b}->[$index])
1977: ||
1978: lc($classlist->{$a}->[$second]) cmp lc($classlist->{$b}->[$second])
1979: ||
1980: lc($classlist->{$a}->[$third]) cmp lc($classlist->{$b}->[$third])
1981: } (keys(%$classlist));
1.54 matthew 1982: foreach my $student (@Sorted_Students) {
1.52 matthew 1983: my $error;
1.110 matthew 1984: my $sdata = $classlist->{$student};
1985: my $username = $sdata->[$index{'username'}];
1986: my $domain = $sdata->[$index{'domain'}];
1987: my $section = $sdata->[$index{'section'}];
1988: my $name = $sdata->[$index{'fullname'}];
1989: my $id = $sdata->[$index{'id'}];
1990: my $start = $sdata->[$index{'start'}];
1991: my $end = $sdata->[$index{'end'}];
1992: if (! defined($start) || $start == 0) {
1993: $start = &mt('none');
1994: } else {
1995: $start = &Apache::lonlocal::locallocaltime($start);
1996: }
1997: if (! defined($end) || $end == 0) {
1998: $end = &mt('none');
1999: } else {
2000: $end = &Apache::lonlocal::locallocaltime($end);
2001: }
2002: my $status = $sdata->[$index{'status'}];
1.51 matthew 2003: next if ($status ne 'Active');
2004: #
1.139 albertel 2005: $r->print(&Apache::loncommon::start_data_table_row());
1.51 matthew 2006: $r->print(<<"END");
2007: <td><input type="checkbox" name="droplist" value="$student"></td>
2008: <td>$username</td>
2009: <td>$domain</td>
2010: <td>$id</td>
2011: <td>$name</td>
2012: <td>$section</td>
1.110 matthew 2013: <td>$start</td>
2014: <td>$end</td>
1.26 matthew 2015: END
1.139 albertel 2016: $r->print(&Apache::loncommon::end_data_table_row());
1.25 matthew 2017: }
1.139 albertel 2018: $r->print(&Apache::loncommon::end_data_table().'<br />');
1.111 matthew 2019: %lt=&Apache::lonlocal::texthash(
1.94 sakharuk 2020: 'dp' => "Drop Students",
2021: 'ca' => "check all",
2022: 'ua' => "uncheck all",
2023: );
1.32 matthew 2024: $r->print(<<"END");
2025: </p><p>
1.94 sakharuk 2026: <input type="button" value="$lt{'ca'}" onclick="javascript:checkAll(document.studentform.droplist)">
2027: <input type="button" value="$lt{'ua'}" onclick="javascript:uncheckAll(document.studentform.droplist)">
2028: <p><input type=submit value="$lt{'dp'}"></p>
1.32 matthew 2029: END
1.51 matthew 2030: return;
1.10 www 2031: }
2032:
1.48 matthew 2033: #
2034: # Print out the initial form to get the courselist file
2035: #
2036: sub print_first_courselist_upload_form {
2037: my $r=shift;
1.88 matthew 2038: my $str;
2039: $str = '<input type="hidden" name="phase" value="two">';
2040: $str .= '<input type="hidden" name="action" value="upload" />';
2041: $str .= '<input type="hidden" name="state" value="got_file" />';
2042: $str .= "<h3>".&mt('Upload a class list')."</h3>\n";
2043: $str .= &Apache::loncommon::upfile_select_html();
2044: $str .= "<p>\n";
2045: $str .= '<input type="submit" name="fileupload" value="'.
2046: &mt('Upload class list').'">'."\n";
1.131 albertel 2047: $str .= '<label><input type="checkbox" name="noFirstLine" /> '.
2048: &mt('Ignore First Line')."</label></p>\n";
1.88 matthew 2049: $str .= &Apache::loncommon::help_open_topic("Course_Create_Class_List",
1.92 sakharuk 2050: &mt("How do I create a class list from a spreadsheet")).
1.88 matthew 2051: "<br />\n";
2052: $str .= &Apache::loncommon::help_open_topic("Course_Convert_To_CSV",
1.92 sakharuk 2053: &mt("How do I create a CSV file from a spreadsheet")).
1.88 matthew 2054: "<br />\n";
1.138 albertel 2055: $str .= &Apache::loncommon::end_page();
1.88 matthew 2056: $r->print($str);
1.48 matthew 2057: return;
2058: }
2059:
1.10 www 2060: # ================================================= Drop/Add from uploaded file
2061: sub upfile_drop_add {
2062: my $r=shift;
1.24 albertel 2063: &Apache::loncommon::load_tmp_file($r);
2064: my @studentdata=&Apache::loncommon::upfile_record_sep();
1.127 albertel 2065: if($env{'form.noFirstLine'}){shift(@studentdata);}
2066: my @keyfields = split(/\,/,$env{'form.keyfields'});
2067: my $cid = $env{'request.course.id'};
1.25 matthew 2068: my %fields=();
1.127 albertel 2069: for (my $i=0; $i<=$env{'form.nfields'}; $i++) {
2070: if ($env{'form.upfile_associate'} eq 'reverse') {
2071: if ($env{'form.f'.$i} ne 'none') {
2072: $fields{$keyfields[$i]}=$env{'form.f'.$i};
1.25 matthew 2073: }
2074: } else {
1.127 albertel 2075: $fields{$env{'form.f'.$i}}=$keyfields[$i];
1.25 matthew 2076: }
2077: }
1.99 matthew 2078: #
2079: # Store the field choices away
2080: foreach my $field (qw/username names
2081: fname mname lname gen id sec ipwd email/) {
1.127 albertel 2082: $env{'form.'.$field.'_choice'}=$fields{$field};
1.99 matthew 2083: }
2084: &Apache::loncommon::store_course_settings('enrollment_upload',
2085: { 'username_choice' => 'scalar',
2086: 'names_choice' => 'scalar',
2087: 'fname_choice' => 'scalar',
2088: 'mname_choice' => 'scalar',
2089: 'lname_choice' => 'scalar',
2090: 'gen_choice' => 'scalar',
2091: 'id_choice' => 'scalar',
2092: 'sec_choice' => 'scalar',
2093: 'ipwd_choice' => 'scalar',
2094: 'email_choice' => 'scalar' });
2095:
1.26 matthew 2096: #
1.68 matthew 2097: my ($startdate,$enddate) = &get_dates_from_form();
1.127 albertel 2098: if ($env{'form.makedatesdefault'}) {
1.68 matthew 2099: $r->print(&make_dates_default($startdate,$enddate));
2100: }
1.31 matthew 2101: # Determine domain and desired host (home server)
1.127 albertel 2102: my $domain=$env{'form.lcdomain'};
2103: my $desiredhost = $env{'form.lcserver'};
1.31 matthew 2104: if (lc($desiredhost) eq 'default') {
2105: $desiredhost = undef;
2106: } else {
1.45 matthew 2107: my %home_servers = &Apache::loncommon::get_library_servers($domain);
1.31 matthew 2108: if (! exists($home_servers{$desiredhost})) {
1.88 matthew 2109: $r->print('<font color="#ff0000">'.&mt('Error').'</font>'.
2110: &mt('Invalid home server specified'));
1.138 albertel 2111: $r->print(&Apache::loncommon::end_page());
1.31 matthew 2112: return;
2113: }
2114: }
1.26 matthew 2115: # Determine authentication mechanism
2116: my $amode = '';
2117: my $genpwd = '';
1.127 albertel 2118: if ($env{'form.login'} eq 'krb') {
1.47 albertel 2119: $amode='krb';
1.127 albertel 2120: $amode.=$env{'form.krbver'};
2121: $genpwd=$env{'form.krbarg'};
2122: } elsif ($env{'form.login'} eq 'int') {
1.25 matthew 2123: $amode='internal';
1.127 albertel 2124: if ((defined($env{'form.intarg'})) && ($env{'form.intarg'})) {
2125: $genpwd=$env{'form.intarg'};
1.25 matthew 2126: }
1.127 albertel 2127: } elsif ($env{'form.login'} eq 'loc') {
1.25 matthew 2128: $amode='localauth';
1.127 albertel 2129: if ((defined($env{'form.locarg'})) && ($env{'form.locarg'})) {
2130: $genpwd=$env{'form.locarg'};
1.79 matthew 2131: }
2132: }
2133: if ($amode =~ /^krb/) {
2134: if (! defined($genpwd) || $genpwd eq '') {
2135: $r->print('<font color="red" size="+1">'.
1.88 matthew 2136: &mt('Unable to enroll students').'</font> '.
2137: &mt('No Kerberos domain was specified.').'</p>');
1.79 matthew 2138: $amode = ''; # This causes the loop below to be skipped
1.25 matthew 2139: }
2140: }
2141: unless (($domain=~/\W/) || ($amode eq '')) {
1.26 matthew 2142: #######################################
2143: ## Enroll Students ##
2144: #######################################
1.88 matthew 2145: $r->print('<h3>'.&mt('Enrolling Students')."</h3>\n<p>\n");
1.25 matthew 2146: my $count=0;
2147: my $flushc=0;
2148: my %student=();
1.26 matthew 2149: # Get new classlist
1.25 matthew 2150: foreach (@studentdata) {
2151: my %entries=&Apache::loncommon::record_sep($_);
1.26 matthew 2152: # Determine student name
1.25 matthew 2153: unless (($entries{$fields{'username'}} eq '') ||
2154: (!defined($entries{$fields{'username'}}))) {
1.26 matthew 2155: my ($fname, $mname, $lname,$gen) = ('','','','');
1.25 matthew 2156: if (defined($fields{'names'})) {
1.26 matthew 2157: ($lname,$fname,$mname)=($entries{$fields{'names'}}=~
2158: /([^\,]+)\,\s*(\w+)\s*(.*)$/);
1.25 matthew 2159: } else {
2160: if (defined($fields{'fname'})) {
2161: $fname=$entries{$fields{'fname'}};
2162: }
2163: if (defined($fields{'mname'})) {
2164: $mname=$entries{$fields{'mname'}};
2165: }
2166: if (defined($fields{'lname'})) {
2167: $lname=$entries{$fields{'lname'}};
2168: }
2169: if (defined($fields{'gen'})) {
2170: $gen=$entries{$fields{'gen'}};
2171: }
2172: }
2173: if ($entries{$fields{'username'}}=~/\W/) {
1.88 matthew 2174: $r->print('<br />'.
2175: &mt('<b>[_1]</b>: Unacceptable username for user [_2] [_3] [_4] [_5]',
2176: $entries{$fields{'username'}},$fname,$mname,$lname,$gen).
2177: '</b>');
1.25 matthew 2178: } else {
1.26 matthew 2179: # determine section number
1.25 matthew 2180: my $sec='';
2181: my $username=$entries{$fields{'username'}};
2182: if (defined($fields{'sec'})) {
2183: if (defined($entries{$fields{'sec'}})) {
2184: $sec=$entries{$fields{'sec'}};
2185: }
2186: }
1.80 matthew 2187: # remove non alphanumeric values from section
2188: $sec =~ s/\W//g;
1.26 matthew 2189: # determine student id number
1.25 matthew 2190: my $id='';
2191: if (defined($fields{'id'})) {
2192: if (defined($entries{$fields{'id'}})) {
2193: $id=$entries{$fields{'id'}};
2194: }
2195: $id=~tr/A-Z/a-z/;
2196: }
1.73 www 2197: # determine email address
2198: my $email='';
2199: if (defined($fields{'email'})) {
2200: if (defined($entries{$fields{'email'}})) {
2201: $email=$entries{$fields{'email'}};
2202: unless ($email=~/^[^\@]+\@[^\@]+$/) { $email=''; }
2203: }
2204: }
1.26 matthew 2205: # determine student password
1.25 matthew 2206: my $password='';
2207: if ($genpwd) {
2208: $password=$genpwd;
2209: } else {
2210: if (defined($fields{'ipwd'})) {
2211: if ($entries{$fields{'ipwd'}}) {
2212: $password=$entries{$fields{'ipwd'}};
2213: }
2214: }
2215: }
1.56 matthew 2216: # Clean up whitespace
2217: foreach (\$domain,\$username,\$id,\$fname,\$mname,
2218: \$lname,\$gen,\$sec) {
2219: $$_ =~ s/(\s+$|^\s+)//g;
2220: }
1.127 albertel 2221: if ($password || $env{'form.login'} eq 'loc') {
1.33 matthew 2222: &modifystudent($domain,$username,$cid,$sec,
2223: $desiredhost);
1.25 matthew 2224: my $reply=&Apache::lonnet::modifystudent
2225: ($domain,$username,$id,$amode,$password,
2226: $fname,$mname,$lname,$gen,$sec,$enddate,
1.127 albertel 2227: $startdate,$env{'form.forceid'},$desiredhost,
1.73 www 2228: $email);
1.26 matthew 2229: if ($reply ne 'ok') {
1.72 matthew 2230: $reply =~ s/^error://;
1.88 matthew 2231: $r->print('<br />'.
2232: &mt('<b>[_1]</b>: Unable to enroll: [_2]',$username,$reply));
1.10 www 2233: } else {
1.7 www 2234: $count++; $flushc++;
2235: $student{$username}=1;
1.6 www 2236: $r->print('. ');
1.7 www 2237: if ($flushc>15) {
2238: $r->rflush;
2239: $flushc=0;
2240: }
1.6 www 2241: }
1.25 matthew 2242: } else {
1.88 matthew 2243: $r->print('<br />'.
2244: &mt('<b>[_1]</b>: Unable to enroll. No password specified.',$username)
2245: );
1.25 matthew 2246: }
2247: }
1.26 matthew 2248: }
2249: } # end of foreach (@studentdata)
1.88 matthew 2250: $r->print("</p>\n<p>\n".&mt('Processed [_1] student(s).',$count).
2251: "</p>\n");
2252: $r->print("<p>\n".
2253: &mt('If active, the new role will be available when the '.
2254: 'students next log in to LON-CAPA.')."</p>\n");
1.26 matthew 2255: #####################################
2256: # Drop students #
2257: #####################################
1.127 albertel 2258: if ($env{'form.fullup'} eq 'yes') {
1.88 matthew 2259: $r->print('<h3>'.&mt('Dropping Students')."</h3>\n");
1.26 matthew 2260: # Get current classlist
1.56 matthew 2261: my ($classlist,$keylist)=&Apache::loncoursedata::get_classlist();
2262: if (! defined($classlist)) {
1.88 matthew 2263: $r->print(&mt('There are no students currently enrolled.').
2264: "\n");
1.56 matthew 2265: } else {
2266: # Remove the students we just added from the list of students.
1.25 matthew 2267: foreach (@studentdata) {
2268: my %entries=&Apache::loncommon::record_sep($_);
2269: unless (($entries{$fields{'username'}} eq '') ||
2270: (!defined($entries{$fields{'username'}}))) {
1.56 matthew 2271: delete($classlist->{$entries{$fields{'username'}}.
1.26 matthew 2272: ':'.$domain});
1.25 matthew 2273: }
2274: }
1.56 matthew 2275: # Print out list of dropped students.
2276: &show_drop_list($r,$classlist,$keylist,'nosort');
1.25 matthew 2277: }
2278: }
1.26 matthew 2279: } # end of unless
1.10 www 2280: }
2281:
1.11 www 2282: # ================================================================== Phase four
2283: sub drop_student_list {
2284: my $r=shift;
2285: my $count=0;
1.128 albertel 2286: my @droplist = &Apache::loncommon::get_env_multiple('form.droplist');
1.35 matthew 2287: foreach (@droplist) {
1.26 matthew 2288: my ($uname,$udom)=split(/\:/,$_);
1.56 matthew 2289: # drop student
1.127 albertel 2290: my $result = &modifystudent($udom,$uname,$env{'request.course.id'});
1.37 matthew 2291: if ($result eq 'ok' || $result eq 'ok:') {
1.88 matthew 2292: $r->print(&mt('Dropped [_1]',$uname.'@'.$udom).'<br>');
1.59 matthew 2293: $count++;
1.35 matthew 2294: } else {
1.88 matthew 2295: $r->print(
2296: &mt('Error dropping [_1]:[_2]',$uname.'@'.$udom,$result).
1.35 matthew 2297: '<br />');
2298: }
1.20 harris41 2299: }
1.88 matthew 2300: $r->print('<p><b>'.&mt('Dropped [_1] student(s).',$count).'</b></p>');
2301: $r->print('<p>'.&mt('Re-enrollment will re-activate data.')) if ($count);
1.11 www 2302: }
2303:
1.50 matthew 2304: ###################################################################
2305: ###################################################################
2306:
2307: =pod
2308:
2309: =item &handler
2310:
2311: The typical handler you see in all these modules. Takes $r, the
2312: http request, as an argument.
2313:
2314: The response to the request is governed by two form variables
2315:
2316: form.action form.state response
2317: ---------------------------------------------------
2318: undefined undefined print main menu
2319: upload undefined print courselist upload menu
2320: upload got_file deal with uploaded file,
2321: print the upload managing menu
2322: upload enrolling enroll students based on upload
2323: drop undefined print the classlist ready to drop
2324: drop done drop the selected students
1.74 matthew 2325: enrollstudent undefined print student username domain form
2326: enrollstudent gotusername print single student enroll menu
1.50 matthew 2327: enrollstudent enrolling enroll student
2328: classlist undefined print html classlist
2329: classlist csv print csv classlist
2330: modifystudent undefined print classlist to select student to modify
2331: modifystudent selected print modify student menu
2332: modifystudent done make modifications to student record
2333:
2334: =cut
2335:
2336: ###################################################################
2337: ###################################################################
1.10 www 2338: sub handler {
1.26 matthew 2339: my $r=shift;
2340: if ($r->header_only) {
1.86 www 2341: &Apache::loncommon::content_type($r,'text/html');
1.26 matthew 2342: $r->send_http_header;
2343: return OK;
2344: }
1.48 matthew 2345: &Apache::loncommon::get_unprocessed_cgi($ENV{'QUERY_STRING'},
1.50 matthew 2346: ['action','state']);
1.102 matthew 2347:
2348: &Apache::lonhtmlcommon::clear_breadcrumbs();
2349: &Apache::lonhtmlcommon::add_breadcrumb
2350: ({href=>"/adm/dropadd",
2351: text=>"Enrollment Manager",
2352: faq=>9,bug=>'Instructor Interface',});
1.26 matthew 2353: # Needs to be in a course
1.127 albertel 2354: if (! ($env{'request.course.fn'})) {
1.121 matthew 2355: # Not in a course
1.127 albertel 2356: $env{'user.error.msg'}=
1.132 raeburn 2357: "/adm/dropadd:cst:0:0:Cannot manage or view course groups, ".
2358: "or drop or add students";
1.50 matthew 2359: return HTTP_NOT_ACCEPTABLE;
2360: }
2361: #
1.121 matthew 2362: my $view_permission =
1.127 albertel 2363: &Apache::lonnet::allowed('vcl',$env{'request.course.id'});
1.121 matthew 2364: my $enrl_permission =
1.127 albertel 2365: &Apache::lonnet::allowed('cst',$env{'request.course.id'});
1.132 raeburn 2366:
2367: my $grp_view_permission =
2368: &Apache::lonnet::allowed('vcg',$env{'request.course.id'});
2369: my $grp_manage_permission =
2370: &Apache::lonnet::allowed('mdg',$env{'request.course.id'});
2371:
2372:
2373: if (! $grp_view_permission && ! $grp_manage_permission &&
2374: ! $view_permission && ! $enrl_permission) {
1.127 albertel 2375: $env{'user.error.msg'}=
1.132 raeburn 2376: "/adm/coursegroups:cst:0:0:Cannot manage or view course groups, ".
2377: "or drop or add students";
2378: return HTTP_NOT_ACCEPTABLE;
1.121 matthew 2379: }
1.132 raeburn 2380:
1.121 matthew 2381: #
1.50 matthew 2382: # Only output the header information if they did not request csv format
2383: #
1.103 matthew 2384: # Start page
2385: &Apache::loncommon::content_type($r,'text/html');
2386: $r->send_http_header;
2387: $r->print(&header());
1.50 matthew 2388: #
2389: # Main switch on form.action and form.state, as appropriate
1.127 albertel 2390: if (! exists($env{'form.action'})) {
1.141 ! albertel 2391: $r->print(&Apache::lonhtmlcommon::breadcrumbs('Enrollment Manager'));
1.132 raeburn 2392: &print_main_menu($r,$enrl_permission,$view_permission,$grp_manage_permission,
2393: $grp_view_permission);
1.127 albertel 2394: } elsif ($env{'form.action'} eq 'upload' && $enrl_permission) {
1.102 matthew 2395: &Apache::lonhtmlcommon::add_breadcrumb
2396: ({href=>'/adm/dropadd?action=upload&state=',
1.106 matthew 2397: text=>"Upload Classlist"});
1.141 ! albertel 2398: $r->print(&Apache::lonhtmlcommon::breadcrumbs('Upload Classlist',
! 2399: 'Course_Create_Class_List'));
1.127 albertel 2400: if (! exists($env{'form.state'})) {
1.50 matthew 2401: &print_first_courselist_upload_form($r);
1.127 albertel 2402: } elsif ($env{'form.state'} eq 'got_file') {
1.50 matthew 2403: &print_upload_manager_form($r);
1.127 albertel 2404: } elsif ($env{'form.state'} eq 'enrolling') {
2405: if ($env{'form.datatoken'}) {
1.26 matthew 2406: &upfile_drop_add($r);
1.50 matthew 2407: } else {
2408: # Hmmm, this is an error
1.26 matthew 2409: }
1.50 matthew 2410: } else {
2411: &print_first_courselist_upload_form($r);
1.26 matthew 2412: }
1.127 albertel 2413: } elsif ($env{'form.action'} eq 'drop' && $enrl_permission) {
1.102 matthew 2414: &Apache::lonhtmlcommon::add_breadcrumb
2415: ({href=>'/adm/dropadd?action=drop',
1.106 matthew 2416: text=>"Drop Students"});
1.141 ! albertel 2417: $r->print(&Apache::lonhtmlcommon::breadcrumbs('Drop Students',
! 2418: 'Course_Drop_Student'));
1.127 albertel 2419: if (! exists($env{'form.state'})) {
1.51 matthew 2420: &print_drop_menu($r);
1.127 albertel 2421: } elsif ($env{'form.state'} eq 'done') {
1.26 matthew 2422: &drop_student_list($r);
1.50 matthew 2423: } else {
1.55 matthew 2424: &print_drop_menu($r);
1.26 matthew 2425: }
1.127 albertel 2426: } elsif ($env{'form.action'} eq 'enrollstudent' && $enrl_permission) {
1.102 matthew 2427: &Apache::lonhtmlcommon::add_breadcrumb
2428: ({href=>'/adm/dropadd?action=enrollstudent',
1.106 matthew 2429: text=>"Enroll Student"});
1.141 ! albertel 2430: $r->print(&Apache::lonhtmlcommon::breadcrumbs('Enroll Student',
! 2431: 'Course_Add_Student'));
1.127 albertel 2432: if (! exists($env{'form.state'})) {
1.74 matthew 2433: &get_student_username_domain_form($r);
1.127 albertel 2434: } elsif ($env{'form.state'} eq 'gotusername') {
1.50 matthew 2435: &print_enroll_single_student_form($r);
1.127 albertel 2436: } elsif ($env{'form.state'} eq 'enrolling') {
1.26 matthew 2437: &enroll_single_student($r);
1.50 matthew 2438: } else {
1.74 matthew 2439: &get_student_username_domain_form($r);
1.26 matthew 2440: }
1.127 albertel 2441: } elsif ($env{'form.action'} eq 'classlist' && $view_permission) {
1.102 matthew 2442: &Apache::lonhtmlcommon::add_breadcrumb
2443: ({href=>'/adm/dropadd?action=classlist',
1.106 matthew 2444: text=>"View Classlist"});
1.141 ! albertel 2445: $r->print(&Apache::lonhtmlcommon::breadcrumbs('View Classlist',
! 2446: 'Course_View_Class_List'));
1.127 albertel 2447: if (! exists($env{'form.state'})) {
1.103 matthew 2448: &print_html_classlist($r,undef);
1.127 albertel 2449: } elsif ($env{'form.state'} eq 'csv') {
1.103 matthew 2450: &print_html_classlist($r,'csv');
1.127 albertel 2451: } elsif ($env{'form.state'} eq 'excel') {
1.103 matthew 2452: &print_html_classlist($r,'excel');
1.50 matthew 2453: } else {
1.103 matthew 2454: &print_html_classlist($r,undef);
1.50 matthew 2455: }
1.127 albertel 2456: } elsif ($env{'form.action'} eq 'modifystudent' && $enrl_permission) {
1.102 matthew 2457: &Apache::lonhtmlcommon::add_breadcrumb
2458: ({href=>'/adm/dropadd?action=modifystudent',
1.106 matthew 2459: text=>"Modify Student Data"});
1.141 ! albertel 2460: $r->print(&Apache::lonhtmlcommon::breadcrumbs('Modify Student Data',
! 2461: 'Course_Modify_Student_Data'));
1.127 albertel 2462: if (! exists($env{'form.state'})) {
1.50 matthew 2463: &print_html_classlist($r);
1.127 albertel 2464: } elsif ($env{'form.state'} eq 'selected') {
1.50 matthew 2465: &print_modify_student_form($r);
1.127 albertel 2466: } elsif ($env{'form.state'} eq 'done') {
1.50 matthew 2467: &modify_single_student($r);
2468: } else {
2469: &print_html_classlist($r);
2470: }
2471: } else {
2472: # We should not end up here, but I guess it is possible
2473: &Apache::lonnet::logthis("Undetermined state in londropadd.pm. ".
1.127 albertel 2474: "form.action = ".$env{'form.action'}.
1.50 matthew 2475: "Someone should fix this.");
1.141 ! albertel 2476: $r->print(&Apache::lonhtmlcommon::breadcrumbs('Enrollment Manager'));
1.121 matthew 2477: &print_main_menu($r,$enrl_permission,$view_permission);
1.50 matthew 2478: }
2479: #
2480: # Finish up
1.138 albertel 2481: $r->print('</form>'.&Apache::loncommon::end_page());
1.26 matthew 2482: return OK;
1.1 www 2483: }
2484:
1.50 matthew 2485: ###################################################################
2486: ###################################################################
2487:
1.1 www 2488: 1;
2489: __END__
1.50 matthew 2490:
1.1 www 2491:
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>
![[BACK]](/icons/back.gif){kind=icon}
Return to londropadd.pm CVS log ![[TXT]](/icons/text.gif){kind=icon}
![[DIR]](/icons/dir.gif){kind=icon}
Up to [LON-CAPA] / loncom / interface