File:  [LON-CAPA] / loncom / interface / Attic / londropadd.pm
Revision 1.59: download - view: text, annotated - select for diffs
Wed Oct 16 18:45:10 2002 UTC (21 years, 8 months ago) by matthew
Branches: MAIN
CVS tags: HEAD
Many changes to deal well with the new status field.
The routine &show_class_list was modified to use javascript to set a few
hidden parameter values and submit the form in order to take you to the next
page when modifying a students information.  This is in contrast to the
previous method which passed parameters in a link.
&show_drop_list is now a little brighter about the 'sortby' parameter, for
what it's worth (not much, really).
&drop_student_list acts more intelligent on errors - the errors are still
reported and other information is now suppressed if it is not relevant.
Specifically, if no students were successfully dropped you needn't tell
the user about re-enrollment.

    1: # The LearningOnline Network with CAPA
    2: # Handler to drop and add students in courses 
    3: #
    4: # $Id: londropadd.pm,v 1.59 2002/10/16 18:45:10 matthew Exp $
    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: #
   28: # (Handler to set parameters for assessments
   29: #
   30: # (Handler to resolve ambiguous file locations
   31: #
   32: # (TeX Content Handler
   33: #
   34: ###############################################################
   35: ###############################################################
   36: 
   37: package Apache::londropadd;
   38: 
   39: use strict;
   40: use Apache::lonnet();
   41: use Apache::loncommon();
   42: use Apache::lonhtmlcommon();
   43: use Apache::Constants qw(:common :http REDIRECT);
   44: 
   45: ###############################################################
   46: ###############################################################
   47: sub header {
   48:     my $bodytag=&Apache::loncommon::bodytag('Enrollment Manager');
   49:     return(<<ENDHEAD);
   50: <html>
   51: <head>
   52: <title>LON-CAPA Enrollment Manager</title>
   53: </head>
   54: $bodytag
   55: <form method="post" enctype="multipart/form-data"  
   56:       action="/adm/dropadd" name="studentform">
   57: ENDHEAD
   58: }
   59: 
   60: ###############################################################
   61: ###############################################################
   62: # Drop student from all sections of a course, except optional $csec
   63: sub modifystudent {
   64:     my ($udom,$unam,$courseid,$csec,$desiredhost)=@_;
   65:     # if $csec is undefined, drop the student from all the courses matching
   66:     # this one.  If $csec is defined, drop them from all other sections of 
   67:     # this course and add them to section $csec
   68:     $courseid=~s/\_/\//g;
   69:     $courseid=~s/^(\w)/\/$1/;
   70:     my %roles = &Apache::lonnet::dump('roles',$udom,$unam);
   71:     my ($tmp) = keys(%roles);
   72:     # Bail out if we were unable to get the students roles
   73:     return "$1" if ($tmp =~ /^(con_lost|error|no_such_host)/i);
   74:     # Go through the roles looking for enrollment in this course
   75:     my $result = '';
   76:     foreach my $course (keys(%roles)) {
   77:         if ($course=~/^$courseid(?:\/)*(?:\s+)*(\w+)*\_st$/) {
   78:             # We are in this course
   79:             my $section=$1;
   80:             $section='' if ($course eq $courseid.'_st');
   81:             if ( ((!$section) && (!$csec)) || ($section ne $csec) ) {
   82:                 my (undef,$end,$start)=split(/\_/,$roles{$course});
   83:                 my $now=time;
   84:                 # if this is an active role 
   85:                 if (!($start && ($now<$start)) || !($end && ($now>$end))) {
   86:                     my $reply=&Apache::lonnet::modifystudent
   87:                         ($udom,$unam,'','','','','','','',
   88:                          $section,time,undef,undef,$desiredhost);
   89:                     $result .= $reply.':';
   90:                 }
   91:             }
   92:         }
   93:     }
   94:     if ($result eq '') {
   95:         $result eq 'Unable to find section for this student';
   96:     } else {
   97:         $result =~ s/(ok:)+/ok/g;
   98:     }
   99:     return $result;
  100: }
  101: 
  102: ###############################################################
  103: ###############################################################
  104: # build a domain and server selection form
  105: sub domain_form {
  106:     my ($defdom) = @_;
  107:     # Set up domain and server selection forms
  108:     #
  109:     # Get the domains
  110:     my @domains = &Apache::loncommon::get_domains();
  111:     # build up the menu information to be passed to 
  112:     # &Apache::loncommon::linked_select_forms
  113:     my %select_menus;
  114:     foreach my $dom (@domains) {
  115:         # set up the text for this domain
  116:         $select_menus{$dom}->{'text'}= $dom;
  117:         # we want a choice of 'default' as the default in the second menu
  118:         $select_menus{$dom}->{'default'}= 'default';
  119:         $select_menus{$dom}->{'select2'}->{'default'} = 'default';
  120:         # Now build up the other items in the second menu
  121:         my %servers = &Apache::loncommon::get_library_servers($dom);
  122:         foreach my $server (keys(%servers)) {
  123:             $select_menus{$dom}->{'select2'}->{$server} 
  124:                                             = "$server $servers{$server}";
  125:         }
  126:     }
  127:     my $result  = &Apache::loncommon::linked_select_forms
  128:         ('studentform',' with home server ',$defdom,
  129:          'lcdomain','lcserver',\%select_menus);
  130:     return $result;
  131: }
  132: 
  133: ###############################################################
  134: ###############################################################
  135: #  Menu Phase One
  136: sub print_main_menu {
  137:     my $r=shift;
  138:     $r->print(<<END);
  139: <p>
  140: <font size="+1">
  141:     <a href="/adm/dropadd?action=upload">Upload a course list</a>
  142: </font>
  143: </p><p>
  144: <font size="+1">
  145:     <a href="/adm/dropadd?action=enrollstudent">Enroll a single student</a>
  146: </font>
  147: </p><p>
  148: <font size="+1">
  149:     <a href="/adm/dropadd?action=modifystudent">Modify student data</a>
  150: </font>
  151: </p><p>
  152: <font size="+1">
  153:     <a href="/adm/dropadd?action=classlist">View Classlist</a>
  154: </font>
  155: </p><p>
  156: <font size="+1">
  157:     <a href="/adm/dropadd?action=drop">Drop Students</a>
  158: </font>
  159: </p>
  160: END
  161: }
  162: 
  163: ###############################################################
  164: ###############################################################
  165: sub print_upload_manager_header {
  166:     my ($r,$datatoken,$distotal,$krbdefdom)=@_;
  167:     my $javascript;
  168:     if (! exists($ENV{'form.upfile_associate'})) {
  169:         $ENV{'form.upfile_associate'} = 'forward';
  170:     }
  171:     if ($ENV{'form.associate'} eq 'Reverse Association') {
  172:         if ( $ENV{'form.upfile_associate'} ne 'reverse' ) {
  173:             $ENV{'form.upfile_associate'} = 'reverse';
  174:         } else {
  175:             $ENV{'form.upfile_associate'} = 'forward';
  176:         }
  177:     }
  178:     if ($ENV{'form.upfile_associate'} eq 'reverse') {
  179: 	$javascript=&upload_manager_javascript_reverse_associate();
  180:     } else {
  181: 	$javascript=&upload_manager_javascript_forward_associate();
  182:     }
  183:     my $javascript_validations=&javascript_validations($krbdefdom);
  184:     $r->print(<<ENDPICK);
  185: <h3>Uploading Class List</h3>
  186: <hr>
  187: <h3>Identify fields</h3>
  188: Total number of records found in file: $distotal <hr />
  189: Enter as many fields as you can. The system will inform you and bring you back
  190: to this page if the data selected is insufficient to run your class.<hr />
  191: <input type="button" value="Reverse Association" onClick="javascript:this.form.associate.value='Reverse Association';submit(this.form);" />
  192: <input type="hidden" name="action"     value="upload" />
  193: <input type="hidden" name="state"      value="got_file" />
  194: <input type="hidden" name="associate"  value="" />
  195: <input type="hidden" name="datatoken"  value="$datatoken" />
  196: <input type="hidden" name="fileupload" value="$ENV{'form.fileupload'}" />
  197: <input type="hidden" name="upfiletype" value="$ENV{'form.upfiletype'}" />
  198: <input type="hidden" name="upfile_associate" 
  199:                                        value="$ENV{'form.upfile_associate'}" />
  200: <hr />
  201: <script type="text/javascript" language="Javascript">
  202: $javascript
  203: $javascript_validations
  204: </script>
  205: ENDPICK
  206: }
  207: 
  208: ###############################################################
  209: ###############################################################
  210: sub javascript_validations {
  211:     my ($krbdefdom)=@_;
  212:     my %param = ( formname => 'studentform',
  213:                   kerb_def_dom => $krbdefdom );
  214:     my $authheader = &Apache::loncommon::authform_header(%param);
  215:     return (<<ENDPICK);
  216: function verify_message (vf,founduname,foundpwd,foundname,foundid,foundsec) {
  217:     var foundatype=0;
  218:     var message='';
  219:     if (founduname==0) {
  220: 	alert('You need to specify the username field');
  221:         return;
  222:     }
  223:     if (current.radiovalue == null || current.radiovalue == 'nochange') {
  224:         // They did not check any of the login radiobuttons.
  225:         alert('You must choose an authentication type');
  226:         return;
  227:     }
  228:     foundatype=1;
  229:     if (current.argfield == null || current.argfield == '') {
  230:         var alertmsg = '';
  231:         switch (current.value) {
  232:             case 'krb': 
  233:                 alertmsg = 'You need to specify the Kerberos domain';
  234:                 break;
  235:             case 'loc':
  236:             case 'fsys':
  237:                 alertmsg = 'You need to specify the initial password';
  238:                 break;
  239:             case 'fsys':
  240:                 alertmsg = '';
  241:                 break;
  242:             default: 
  243:                 alertmsg = '';
  244:         }
  245:         if (alertmsg != '') {
  246:             alert(alertmsg);
  247:             return;
  248:         }
  249:     }
  250: 
  251:     if (foundname==0) { message='No name fields specified. '; }
  252:     if (foundid==0) { message+='No ID or student number field specified. '; }
  253:     if (foundsec==0) { message+='No section or group field specified. '; }
  254:     if (vf.startdate.value=='') {
  255: 	message+='No starting date set. ';
  256:     }
  257:     if (vf.enddate.value=='') {
  258:         message+='No ending date set. ';
  259:     }
  260:     if ((vf.enddate.value!='') && (vf.startdate.value!='')) {
  261:        if (Math.round(vf.enddate.value)<Math.round(vf.startdate.value)) {
  262:           alert('Ending date is before starting date');
  263:           return;
  264:        }
  265:     }
  266:     if (message!='') {
  267:        message+='Continue enrollment?';
  268:        if (confirm(message)) {
  269: 	  pclose();
  270:           vf.state.value='enrolling';
  271: 	  vf.submit();
  272:        }
  273:     } else {
  274:       pclose();
  275:       vf.state.value='enrolling';
  276:       vf.submit();
  277:     }
  278: }
  279: 
  280: 
  281:     function pclose() {
  282:         parmwin=window.open("/adm/rat/empty.html","LONCAPAparms",
  283:                  "height=350,width=350,scrollbars=no,menubar=no");
  284:         parmwin.close();
  285:     }
  286: 
  287:     function pjump(type,dis,value,marker,ret,call) {
  288:         parmwin=window.open("/adm/rat/parameter.html?type="+escape(type)
  289:                  +"&value="+escape(value)+"&marker="+escape(marker)
  290:                  +"&return="+escape(ret)
  291:                  +"&call="+escape(call)+"&name="+escape(dis),"LONCAPAparms",
  292:                  "height=350,width=350,scrollbars=no,menubar=no");
  293: 
  294:     }
  295: 
  296:     function dateset() {
  297:         if (document.studentform.pres_marker.value=='end') {
  298:            document.studentform.enddate.value=
  299: 	       document.studentform.pres_value.value;
  300:         }
  301:         if (document.studentform.pres_marker.value=='start') {
  302:            document.studentform.startdate.value=
  303: 	       document.studentform.pres_value.value;
  304:         }
  305:         pclose();
  306:     }
  307: 
  308: $authheader
  309: ENDPICK
  310: 
  311: }
  312: 
  313: ###############################################################
  314: ###############################################################
  315: sub upload_manager_javascript_forward_associate {
  316:     return(<<ENDPICK);
  317: function verify(vf) {
  318:     var founduname=0;
  319:     var foundpwd=0;
  320:     var foundname=0;
  321:     var foundid=0;
  322:     var foundsec=0;
  323:     var tw;
  324:     for (i=0;i<=vf.nfields.value;i++) {
  325:         tw=eval('vf.f'+i+'.selectedIndex');
  326:         if (tw==1) { founduname=1; }
  327:         if ((tw>=2) && (tw<=6)) { foundname=1; }
  328:         if (tw==7) { foundid=1; }
  329:         if (tw==8) { foundsec=1; }
  330:         if (tw==9) { foundpwd=1; }
  331:     }
  332:     verify_message(vf,founduname,foundpwd,foundname,foundid,foundsec);
  333: }
  334: 
  335: //
  336: // vf = this.form
  337: // tf = column number
  338: //
  339: // values of nw
  340: //
  341: // 0 = none
  342: // 1 = username
  343: // 2 = names (lastname, firstnames)
  344: // 3 = fname (firstname)
  345: // 4 = mname (middlename)
  346: // 5 = lname (lastname)
  347: // 6 = gen   (generation)
  348: // 7 = id
  349: // 8 = section
  350: // 9 = ipwd  (password)
  351: //
  352: function flip(vf,tf) {
  353:    var nw=eval('vf.f'+tf+'.selectedIndex');
  354:    var i;
  355:    // make sure no other columns are labeled the same as this one
  356:    for (i=0;i<=vf.nfields.value;i++) {
  357:       if ((i!=tf) && (eval('vf.f'+i+'.selectedIndex')==nw)) {
  358:           eval('vf.f'+i+'.selectedIndex=0;')
  359:       }
  360:    }
  361:    // If we set this to 'lastname, firstnames', clear out all the ones
  362:    // set to 'fname','mname','lname','gen' (3,4,5,6) currently.
  363:    if (nw==2) {
  364:       for (i=0;i<=vf.nfields.value;i++) {
  365:          if ((eval('vf.f'+i+'.selectedIndex')>=3) &&
  366:              (eval('vf.f'+i+'.selectedIndex')<=6)) {
  367:              eval('vf.f'+i+'.selectedIndex=0;')
  368:          }
  369:       }
  370:    }
  371:    // If we set this to one of 'fname','mname','lname','gen' (3,4,5,6),
  372:    // clear out any that are set to 'lastname, firstnames' (2)
  373:    if ((nw>=3) && (nw<=6)) {
  374:       for (i=0;i<=vf.nfields.value;i++) {
  375:          if (eval('vf.f'+i+'.selectedIndex')==2) {
  376:              eval('vf.f'+i+'.selectedIndex=0;')
  377:          }
  378:       }
  379:    }
  380:    // If we set the password, make the password form below correspond to 
  381:    // the new value.
  382:    if (nw==9) {
  383:        changed_radio('int',document.studentform);
  384:        set_auth_radio_buttons('int',document.studentform);
  385:        vf.intarg.value='';
  386:        vf.krbarg.value='';
  387:        vf.locarg.value='';
  388:    }
  389: }
  390: 
  391: function clearpwd(vf) {
  392:     var i;
  393:     for (i=0;i<=vf.nfields.value;i++) {
  394:         if (eval('vf.f'+i+'.selectedIndex')==9) {
  395:             eval('vf.f'+i+'.selectedIndex=0;')
  396:         }
  397:     }
  398: }
  399: 
  400: ENDPICK
  401: }
  402: 
  403: ###############################################################
  404: ###############################################################
  405: sub upload_manager_javascript_reverse_associate {
  406:     return(<<ENDPICK);
  407: function verify(vf) {
  408:     var founduname=0;
  409:     var foundpwd=0;
  410:     var foundname=0;
  411:     var foundid=0;
  412:     var foundsec=0;
  413:     var tw;
  414:     for (i=0;i<=vf.nfields.value;i++) {
  415:         tw=eval('vf.f'+i+'.selectedIndex');
  416:         if (i==0 && tw!=0) { founduname=1; }
  417:         if (((i>=1) && (i<=5)) && tw!=0 ) { foundname=1; }
  418:         if (i==6 && tw!=0) { foundid=1; }
  419:         if (i==7 && tw!=0) { foundsec=1; }
  420:         if (i==8 && tw!=0) { foundpwd=1; }
  421:     }
  422:     verify_message(vf,founduname,foundpwd,foundname,foundid,foundsec);
  423: }
  424: 
  425: function flip(vf,tf) {
  426:    var nw=eval('vf.f'+tf+'.selectedIndex');
  427:    var i;
  428:    // picked the all one one name field, reset the other name ones to blank
  429:    if (tf==1 && nw!=0) {
  430:       for (i=2;i<=5;i++) {
  431:          eval('vf.f'+i+'.selectedIndex=0;')
  432:       }
  433:    }
  434:    //picked one of the piecewise name fields, reset the all in
  435:    //one field to blank
  436:    if ((tf>=2) && (tf<=5) && (nw!=0)) {
  437:       eval('vf.f1.selectedIndex=0;')
  438:    }
  439:    // intial password specified, pick internal authentication
  440:    if (tf==8 && nw!=0) {
  441:        changed_radio('int',document.studentform);
  442:        set_auth_radio_buttons('int',document.studentform);
  443:        vf.krbarg.value='';
  444:        vf.intarg.value='';
  445:        vf.locarg.value='';
  446:    }
  447: }
  448: 
  449: function clearpwd(vf) {
  450:     var i;
  451:     if (eval('vf.f8.selectedIndex')!=0) {
  452:         eval('vf.f8.selectedIndex=0;')
  453:     }
  454: }
  455: ENDPICK
  456: }
  457: 
  458: ###############################################################
  459: ###############################################################
  460: sub print_upload_manager_footer {
  461:     my ($r,$i,$keyfields,$defdom,$today,$halfyear)=@_;
  462:     my %param = ( formname => 'document.studentform');
  463:     my $krbform = &Apache::loncommon::authform_kerberos(%param);
  464:     my $intform = &Apache::loncommon::authform_internal(%param);
  465:     my $locform = &Apache::loncommon::authform_local(%param);
  466:     my $domform = &domain_form($defdom);
  467:     $r->print(<<ENDPICK);
  468: </table>
  469: <input type=hidden name=nfields value=$i>
  470: <input type=hidden name=keyfields value="$keyfields">
  471: <h3>Login Type</h3>
  472: <p>Note: this will not take effect if the user already exists</p>
  473: <p>
  474: $krbform
  475: </p>
  476: <p>
  477: $intform
  478: </p>
  479: <p>
  480: $locform
  481: </p>
  482: <h3>LON-CAPA Domain for Students</h3>
  483: LON-CAPA domain: $domform <p>
  484: <h3>Starting and Ending Dates</h3>
  485: <input type="hidden" value=''          name="pres_value"  >
  486: <input type="hidden" value=''          name="pres_type"   >
  487: <input type="hidden" value=''          name="pres_marker" >
  488: <input type="hidden" value='$today'    name="startdate"   >
  489: <input type="hidden" value='$halfyear' name="enddate"     >
  490: <a 
  491:  href="javascript:pjump('date_start','Enrollment Starting Date',document.studentform.startdate.value,'start','studentform.pres','dateset');"
  492: >Set Starting Date</a><p>
  493: 
  494: <a 
  495:  href="javascript:pjump('date_end','Enrollment Ending Date',document.studentform.enddate.value,'end','studentform.pres','dateset');"
  496: >Set Ending Date</a><p>
  497: <h3>Full Update</h3>
  498: <input type=checkbox name=fullup value=yes> Full update 
  499: (also print list of users not enrolled anymore)<p>
  500: <h3>ID/Student Number</h3>
  501: <input type=checkbox name=forceid value=yes> 
  502: Disable ID/Student Number Safeguard and Force Change of Conflicting IDs
  503: (only do if you know what you are doing)<p>
  504: <input type="button" onClick="javascript:verify(this.form)" value="Update Courselist" /><br />
  505: Note: for large courses, this operation may be time consuming.
  506: ENDPICK
  507: }
  508: 
  509: # ======================================================= Menu Phase Two Upload
  510: sub print_upload_manager_form {
  511:     my $r=shift;
  512: 
  513:     my $datatoken;
  514:     if (!$ENV{'form.datatoken'}) {
  515:       $datatoken=&Apache::loncommon::upfile_store($r);
  516:     } else {
  517:       $datatoken=$ENV{'form.datatoken'};
  518:       &Apache::loncommon::load_tmp_file($r);
  519:     }
  520:     my @records=&Apache::loncommon::upfile_record_sep();
  521:     my $total=$#records;
  522:     my $distotal=$total+1;
  523:     $ENV{'SERVER_NAME'}=~/(\w+\.\w+)$/;
  524:     my $krbdefdom=$1;
  525:     $krbdefdom=~tr/a-z/A-Z/;
  526:     my $today=time;
  527:     my $halfyear=$today+15552000;
  528:     my $defdom=$r->dir_config('lonDefDomain');
  529:     &print_upload_manager_header($r,$datatoken,$distotal,$krbdefdom);
  530:     my $i;
  531:     my $keyfields;
  532:     if ($total>=0) {
  533: 	my @d=(['username','Username'],
  534:                ['names','Last Name, First Names'],
  535: 	       ['fname','First Name'],
  536:                ['mname','Middle Names/Initials'],
  537: 	       ['lname','Last Name'],
  538:                ['gen','Generation'],
  539: 	       ['id','ID/Student Number'],
  540:                ['sec','Group/Section'],
  541: 	       ['ipwd','Initial Password']);
  542: 	if ($ENV{'form.upfile_associate'} eq 'reverse') {	
  543: 	    &Apache::loncommon::csv_print_samples($r,\@records);
  544: 	    $i=&Apache::loncommon::csv_print_select_table($r,\@records,\@d);
  545: 	    foreach (@d) { $keyfields.=$_->[0].','; }
  546: 	    chop($keyfields);
  547: 	} else {
  548: 	    unshift(@d,['none','']);
  549: 	    $i=&Apache::loncommon::csv_samples_select_table($r,\@records,\@d);
  550: 	    my %sone=&Apache::loncommon::record_sep($records[0]);
  551: 	    $keyfields=join(',',sort(keys(%sone)));
  552: 	}
  553:     }
  554:     &print_upload_manager_footer($r,$i,$keyfields,$defdom,$today,$halfyear);
  555: }
  556: 
  557: # ======================================================= Enroll single student
  558: sub enroll_single_student {
  559:     my $r=shift;
  560:     $r->print('<h3>Enrolling Student</h3>');
  561:     $r->print('<p>Enrolling '.$ENV{'form.cuname'}." \@ ".
  562:               $ENV{'form.lcdomain'}.'</p>');
  563:     if (($ENV{'form.cuname'})&&($ENV{'form.cuname'}!~/\W/)&&
  564:         ($ENV{'form.lcdomain'})&&($ENV{'form.lcdomain'}!~/\W/)) {
  565:         # Deal with home server selection
  566:         my $domain=$ENV{'form.lcdomain'};
  567:         my $desiredhost = $ENV{'form.lcserver'};
  568:         if (lc($desiredhost) eq 'default') {
  569:             $desiredhost = undef;
  570:         } else {
  571:             my %home_servers =&Apache::loncommon::get_library_servers($domain);
  572:             if (! exists($home_servers{$desiredhost})) {
  573:                 $r->print('<font color="#ff0000">Error:</font>'.
  574:                           'Invalid home server specified');
  575:                 return;
  576:             }
  577:         }
  578:         $r->print(" with server $desiredhost :") if (defined($desiredhost));
  579:         # End of home server selection logic
  580: 	my $amode='';
  581:         my $genpwd='';
  582:         if ($ENV{'form.login'} eq 'krb') {
  583:            $amode='krb';
  584: 	   $amode.=$ENV{'form.krbver'};
  585:            $genpwd=$ENV{'form.krbarg'};
  586:         } elsif ($ENV{'form.login'} eq 'int') {
  587:            $amode='internal';
  588:            $genpwd=$ENV{'form.intarg'};
  589:         }  elsif ($ENV{'form.login'} eq 'loc') {
  590: 	    $amode='localauth';
  591: 	    $genpwd=$ENV{'form.locarg'};
  592: 	    if (!$genpwd) { $genpwd=" "; }
  593: 	}
  594:         my $home = &Apache::lonnet::homeserver($ENV{'form.cuname'},
  595:                                                    $ENV{'form.lcdomain'});
  596:         if ((($amode) && ($genpwd)) || ($home ne 'no_host')) {
  597:             # Clean out any old roles the student has in this class.
  598:             &modifystudent($ENV{'form.lcdomain'},$ENV{'form.cuname'},
  599:                            $ENV{'request.course.id'},$ENV{'form.csec'},
  600:                             $desiredhost);
  601:             my $login_result = &Apache::lonnet::modifystudent
  602:                 ($ENV{'form.lcdomain'},$ENV{'form.cuname'},
  603:                  $ENV{'form.cstid'},$amode,$genpwd,
  604:                  $ENV{'form.cfirst'},$ENV{'form.cmiddle'},
  605:                  $ENV{'form.clast'},$ENV{'form.cgen'},
  606:                  $ENV{'form.csec'},$ENV{'form.enddate'},
  607:                  $ENV{'form.startdate'},$ENV{'form.forceid'},
  608:                  $desiredhost);
  609:             if ($login_result =~ /^ok/) {
  610:                 $r->print($login_result);
  611:                 $r->print("<p> If active, the new role will be available ".
  612:                           "when the student next logs in to LON-CAPA.</p>");
  613:             } else {
  614:                 $r->print("unable to enroll: ".$login_result);
  615:             }
  616: 	} else {
  617:             $r->print('<p><font color="#ff0000">ERROR</font>&nbsp;'.
  618:                       'Invalid login mode or password.  '.
  619:                       'Unable to enroll '.$ENV{'form.cuname'}.'.</p>');
  620:         }          
  621:     } else {
  622:         $r->print('Invalid username or domain');
  623:     }    
  624: }
  625: 
  626: # ======================================================= Menu Phase Two Enroll
  627: sub print_enroll_single_student_form {
  628:     my $r=shift;
  629:     $r->print("<h3>Enroll One Student</h3>");
  630:     my ($krbdefdom) = $ENV{'SERVER_NAME'}=~/(\w+\.\w+)$/;
  631:     $krbdefdom=~tr/a-z/A-Z/;
  632:     my $today    = time;
  633:     my $halfyear = $today+15552000;
  634:     my $defdom=$r->dir_config('lonDefDomain');
  635:     my $javascript_validations=&javascript_validations($krbdefdom);
  636:     # Set up authentication forms
  637:     my %param = ( formname => 'document.studentform');
  638:     my $krbform = &Apache::loncommon::authform_kerberos(%param);
  639:     my $intform = &Apache::loncommon::authform_internal(%param);
  640:     my $locform = &Apache::loncommon::authform_local(%param);
  641:     # Set up domain selection form
  642:     my $domform = &domain_form($defdom);
  643:     # Print it all out
  644:     $r->print(<<END);
  645: <input type="hidden" name="action" value="enrollstudent">
  646: <input type="hidden" name="state"  value="done">
  647: 
  648: <script type="text/javascript" language="Javascript">
  649: function verify(vf) {
  650:     var founduname=0;
  651:     var foundpwd=0;
  652:     var foundname=0;
  653:     var foundid=0;
  654:     var foundsec=0;
  655:     var tw;
  656:     if ((typeof(vf.cuname.value) !="undefined") && (vf.cuname.value!='') && 
  657: 	(typeof(vf.lcdomain.value)!="undefined") && (vf.lcdomain.value!='')) {
  658:         founduname=1;
  659:     }
  660:     if ((typeof(vf.cfirst.value)!="undefined") && (vf.cfirst.value!='') &&
  661: 	(typeof(vf.clast.value) !="undefined") && (vf.clast.value!='')) {
  662:         foundname=1;
  663:     }
  664:     if ((typeof(vf.csec.value)!="undefined") && (vf.csec.value!='')) {
  665:         foundsec=1;
  666:     }
  667:     if ((typeof(vf.cstid.value)!="undefined") && (vf.cstid.value!='')) {
  668: 	foundid=1;
  669:     }
  670:     if (founduname==0) {
  671: 	alert('You need to specify at least the username and domain fields');
  672:         return;
  673:     }
  674:     verify_message(vf,founduname,foundpwd,foundname,foundid,foundsec);
  675: }
  676: 
  677: $javascript_validations
  678: 
  679: function clearpwd(vf) {
  680:     //nothing else needs clearing
  681: }
  682: 
  683: </script>
  684: <h3>Personal Data</h3>
  685: <table>
  686: <tr><td>First Name:</td><td> <input type="text" name="cfirst"  size="15"></td></tr>
  687: <tr><td>Middle Name:</td><td> <input type="text" name="cmiddle" size="15"></td></tr>
  688: <tr><td>Last Name: </td><td><input type="text" name="clast"   size="15"></td></tr>
  689: <tr><td>Generation: </td><td><input type="text" name="cgen"    size="5"> </td></tr>
  690: </table>
  691: 
  692: <h3>Login Data</h3>
  693: <p>Username: <input type="text" name="cuname"  size="15"></p>
  694: <p>Domain:   $domform</p>
  695: <p>Note: login settings below  will not take effect if the user already exists
  696: </p><p>
  697: $krbform
  698: </p><p>
  699: $intform
  700: </p><p>
  701: $locform
  702: </p><p>
  703: 
  704: <h3>Course Data</h3>
  705: 
  706: <p>Group/Section: <input type="text" name="csec" size="5" />
  707: <p>
  708: <!-- Date setting form elements -->
  709: <input type="hidden" name="pres_value"  value='' />
  710: <input type="hidden" name="pres_type"   value='' />
  711: <input type="hidden" name="pres_marker" value='' />
  712: <input type="hidden" name="startdate"   value='$today'    />
  713: <input type="hidden" name="enddate"     value='$halfyear' />
  714: </p><p>
  715: <a 
  716:  href="javascript:pjump('date_start','Enrollment Starting Date',document.studentform.startdate.value,'start','studentform.pres','dateset');"
  717: >Set Starting Date</a>
  718: </p><p>
  719: <a 
  720:  href="javascript:pjump('date_end','Enrollment Ending Date',document.studentform.enddate.value,'end','studentform.pres','dateset');"
  721: >Set Ending Date</a>
  722: </p>
  723: <h3>ID/Student Number</h3>
  724: <p>
  725: ID/Student Number: <input type="text" name="cstid" size="10">
  726: </p><p>
  727: <input type="checkbox" name="forceid" value="yes"> 
  728: Disable ID/Student Number Safeguard and Force Change of Conflicting IDs
  729: (only do if you know what you are doing)
  730: </p><p>
  731: <input type="button" onClick="verify(this.form)" value="Enroll as student">
  732: </p>
  733: END
  734:     return;
  735: }
  736: 
  737: # ========================================================= Menu Phase Two Drop
  738: sub print_drop_menu {
  739:     my $r=shift;
  740:     $r->print("<h3>Drop Students</h3>");
  741:     my $cid=$ENV{'request.course.id'};
  742:     my ($classlist,$keylist) = &Apache::loncoursedata::get_classlist();
  743:     if (! defined($classlist)) {
  744:         $r->print("There are no students currently enrolled.\n");
  745:         return;
  746:     }
  747:     # Print out the available choices
  748:     &show_drop_list($r,$classlist,$keylist);
  749:     return;
  750: }
  751: 
  752: # ============================================== view classlist
  753: sub print_html_classlist {
  754:     my $r=shift;
  755:     if (! exists($ENV{'form.sortby'})) {
  756:         $ENV{'form.sortby'} = 'username';
  757:     }
  758:     if ($ENV{'form.Status'} !~ /^(Any|Expired|Active)$/) {
  759:         $ENV{'form.Status'} = 'Active';
  760:     }
  761:     my $status_select = &Apache::lonhtmlcommon::StatusOptions
  762:         ($ENV{'form.Status'},'studentform');
  763:     $r->print(<<END);
  764: <input type="hidden" name="action" value="$ENV{'form.action'}" />
  765: <input type="hidden" name="state"  value="" />
  766: <p>
  767: <font size="+1">Current Classlist</font>
  768: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  769: END
  770:     if ($ENV{'form.action'} ne 'modifystudent') {
  771:         $r->print(<<END);
  772: <font size="+1">
  773: <a href="javascript:document.studentform.state.value='csv';document.studentform.submit();">CSV format</a>
  774: </font>
  775: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  776: END
  777:     }
  778:     $r->print($status_select."</p>\n");
  779:     my $cid=$ENV{'request.course.id'};
  780:     my ($classlist,$keylist)=&Apache::loncoursedata::get_classlist();
  781:     if (! defined($classlist)) {
  782:         $r->print("There are no students currently enrolled.\n");
  783:     } else {
  784:         # Print out the available choices
  785:         if ($ENV{'form.action'} eq 'modifystudent') {
  786:             &show_class_list($r,'view','modify','modifystudent',
  787:                              $ENV{'form.Status'},$classlist,$keylist);
  788:         } else {
  789:             &show_class_list($r,'view','aboutme','classlist',
  790:                              $ENV{'form.Status'},$classlist,$keylist);
  791:         }
  792:     }
  793: }
  794: 
  795: # ============================================== view classlist
  796: sub print_csv_classlist {
  797:     my $r=shift;
  798:     my $cid=$ENV{'request.course.id'};
  799:     my ($classlist,$keylist)=&Apache::loncoursedata::get_classlist();
  800:     if (! defined($classlist)) {
  801:         $r->print("There are no students currently enrolled.\n");
  802:     } else {
  803:         &show_class_list($r,'csv','nolink','csv',
  804:                          $ENV{'form.Status'},$classlist,$keylist);
  805:     }
  806: }
  807: 
  808: # =================================================== Show student list to drop
  809: sub show_class_list {
  810:     my ($r,$mode,$linkto,$action,$statusmode,$classlist,$keylist)=@_;
  811:     my $cid=$ENV{'request.course.id'};
  812: #    &Apache::loncommon::get_unprocessed_cgi($ENV{'QUERY_STRING'},
  813: #                                            ['sortby']);
  814:     my $sortby = $ENV{'form.sortby'};
  815:     if ($sortby !~ /^(username|domain|section|fullname|id)$/) {
  816:         $sortby = 'username';
  817:     }
  818:     # Print out header 
  819:     if ($mode eq 'view') {
  820:         if ($linkto eq 'aboutme') {
  821:             $r->print('Select a user name to view the users personal page.');
  822:         } elsif ($linkto eq 'modify') {
  823:             $r->print('Select a user name to modify the students information');
  824:         }
  825:         $r->print(<<END);
  826: 
  827: <input type="hidden" name="sortby" value="$sortby" />
  828: <input type="hidden" name="sname"  value="" />
  829: <input type="hidden" name="sdom"   value="" />
  830: <p>
  831: <table border=2>
  832: <tr><th>
  833:        <a href="javascript:document.studentform.sortby.value='username';document.studentform.submit();">username</a>
  834:     </th><th>
  835:        <a href="javascript:document.studentform.sortby.value='domain';document.studentform.submit();">domain</a>
  836:     </th><th>
  837:        <a href="javascript:document.studentform.sortby.value='id';document.studentform.submit();">ID</a>
  838:     </th><th>
  839:        <a href="javascript:document.studentform.sortby.value='fullname';document.studentform.submit();">student name</a>
  840:     </th><th>
  841:        <a href="javascript:document.studentform.sortby.value='section';document.studentform.submit();">section</a>
  842:     </th>
  843: </tr>
  844: END
  845:     } elsif ($mode eq 'csv') {
  846:         if($statusmode eq 'Expired') {
  847:             $r->print('"Students with expired roles"');
  848:         }
  849:         if ($statusmode eq 'Any') {
  850:             $r->print('"'.join('","',("username","domain","ID","student name",
  851:                                       "section","status")).'"'."\n");
  852:         } else {
  853:             $r->print('"'.join('","',("username","domain","ID","student name",
  854:                                       "section")).'"'."\n");
  855:         }
  856:     }
  857:     #
  858:     # Sort the students
  859:     my %index;
  860:     my $i;
  861:     foreach (@$keylist) {
  862:         $index{$_} = $i++;
  863:     }
  864:     my $index  = $index{$sortby};
  865:     my $second = $index{'username'};
  866:     my $third  = $index{'domain'};
  867:     my @Sorted_Students = sort {
  868:         lc($classlist->{$a}->[$index])  cmp lc($classlist->{$b}->[$index])
  869:             ||
  870:         lc($classlist->{$a}->[$second]) cmp lc($classlist->{$b}->[$second])
  871:             ||
  872:         lc($classlist->{$a}->[$third]) cmp lc($classlist->{$b}->[$third])
  873:         } (keys(%$classlist));
  874:     foreach my $student (@Sorted_Students) {
  875:         my $username = $classlist->{$student}->[$index{'username'}];
  876:         my $domain   = $classlist->{$student}->[$index{'domain'}];
  877:         my $section  = $classlist->{$student}->[$index{'section'}];
  878:         my $name     = $classlist->{$student}->[$index{'fullname'}];
  879:         my $id       = $classlist->{$student}->[$index{'id'}];
  880:         my $status   = $classlist->{$student}->[$index{'status'}];
  881:         next if (($statusmode ne 'Any') && ($status ne $statusmode));
  882:         if ($mode eq 'view') {
  883:             $r->print("<tr>\n    <td>\n        ");
  884:             if ($linkto eq 'nothing') {
  885:                 $r->print($username);
  886:             } elsif ($linkto eq 'aboutme') {
  887:                 $r->print(&Apache::loncommon::aboutmewrapper($username,
  888:                                                              $username,
  889:                                                              $domain));
  890:             } elsif ($linkto eq 'modify') {
  891:                 $r->print('<a href="'.
  892:                           "javascript:document.studentform.sname.value='".
  893:                           $username.
  894:                           "';document.studentform.sdom.value='".$domain.
  895:                           "';document.studentform.state.value='selected".
  896:                           "';document.studentform.submit();".'">'.
  897:                           $username."</a>\n");
  898:             }
  899:             $r->print(<<"END");
  900:     </td>
  901:     <td>$domain</td>
  902:     <td>$id</td>
  903:     <td>$name</td>
  904:     <td>$section</td>
  905: </tr>
  906: END
  907:         } elsif ($mode eq 'csv') {
  908:             # no need to bother with $linkto
  909:             my @line = ();
  910:             foreach ($username,$domain,$id,$name,$section) {
  911:                 push @line,&Apache::loncommon::csv_translate($_);
  912:             }
  913:             if ($statusmode eq 'Any') {
  914:                 push @line,&Apache::loncommon::csv_translate($status);
  915:             }
  916:             my $tmp = $";
  917:             $" = '","';
  918:             $r->print("\"@line\"\n");
  919:             $" = $tmp;
  920:         }
  921:     }
  922:     $r->print('</table><br>') if ($mode eq 'view');
  923: }
  924: 
  925: 
  926: #
  927: # print out form for modification of a single students data
  928: #
  929: sub print_modify_student_form {
  930:     my $r = shift();
  931:     &Apache::loncommon::get_unprocessed_cgi($ENV{'QUERY_STRING'},
  932:                                             ['sdom','sname']);    
  933:     my $sname  = $ENV{'form.sname'};
  934:     my $sdom   = $ENV{'form.sdom'};
  935:     my $sortby = $ENV{'form.sortby'};
  936:     # determine the students name information
  937:     my %info=&Apache::lonnet::get('environment',
  938:                                   ['firstname','middlename',
  939:                                    'lastname','generation','id'],
  940:                                   $sdom, $sname);
  941:     my ($tmp) = keys(%info);
  942:     if ($tmp =~ /^(con_lost|error|no_such_host)/i) {
  943:         $r->print('<font color="#ff0000" size="+2">Error</font>'.
  944:                   '<p>'.
  945:                   'Unable to retrieve environment data for '.$sname.
  946:                   'in domain '.$sdom.'</p><p>'.
  947:                   'Please contact your LON-CAPA administrator '.
  948:                   'regarding this situation.</p></body></html>');
  949:         return;
  950:     }
  951:     # determine the students starting and ending times and section
  952:     my ($starttime,$endtime,$section) = &get_enrollment_data($sname,$sdom);
  953:     # Deal with date forms
  954:     my $startdateform = &Apache::lonhtmlcommon::date_setter('studentform',
  955:                                                             'startdate',
  956:                                                             $starttime);
  957:     my $enddateform = &Apache::lonhtmlcommon::date_setter('studentform',
  958:                                                           'enddate',
  959:                                                           $endtime);
  960:     #
  961:     if (! exists($ENV{'form.Status'}) || 
  962:         $ENV{'form.Status'} !~ /^(Any|Expired|Active)$/) {
  963:         $ENV{'form.Status'} = 'crap';
  964:     }
  965:     # Make sure student is enrolled in course    
  966:     $r->print(<<END);
  967: <p>
  968: <font size="+1">
  969: Only domain coordinators can change a users password.
  970: </font>
  971: </p>
  972: <input type="hidden" name="slogin"  value="$sname"  />
  973: <input type="hidden" name="sdomain" value="$sdom" />
  974: <input type="hidden" name="action"  value="modifystudent" />
  975: <input type="hidden" name="state"   value="done" />
  976: <input type="hidden" name="sortby"  value="$sortby" />
  977: <input type="hidden" name="Status"  value="$ENV{'form.Status'}" />
  978: 
  979: <h2>Modify Enrollment for $info{'firstname'} $info{'middlename'} 
  980: $info{'lastname'} $info{'generation'}, $sname\@$sdom</h2>
  981: <p>
  982: <b>Student Name</b>
  983: <table>
  984: <tr><th>First</th><th>Middle</th><th>Last</th><th>Generation</th></tr>
  985: <tr><td>
  986: <input type="text" name="firstname"  value="$info{'firstname'}"  /></td><td>
  987: <input type="text" name="middlename" value="$info{'middlename'}" /></td><td>
  988: <input type="text" name="lastname"   value="$info{'lastname'}"   /></td><td>
  989: <input type="text" name="generation" value="$info{'generation'}" /></td></tr>
  990: </table>
  991: </p><p>
  992: <b>Student ID</b>: <input type="text" name="id" value="$info{'id'}" size="12"/>
  993: </p><p>
  994: <input type="checkbox" name="forceid" > 
  995: Disable ID/Student Number Safeguard and Force Change of Conflicting IDs
  996: (only do if you know what you are doing)
  997: </p><p>
  998: <b>Section</b>: <input type="text" name="section" value="$section" size="4"/>
  999: </p><p>
 1000: <table>
 1001: <tr><td align="right"><b>Starting Date:</b></td><td>$startdateform</td></tr>
 1002: <tr><td align="right"><b>Ending Date:</b></td><td>$enddateform</td></tr>
 1003: </table>
 1004: </p>
 1005: <input type="submit" value="Submit Modifications" />
 1006: </body></html>
 1007: END
 1008:     return;
 1009: }
 1010: 
 1011: #
 1012: # modify a single students section 
 1013: #
 1014: sub modify_single_student {
 1015:     my $r = shift;
 1016:     # Get the 'sortby' and 'Status' variables so the user goes back to their
 1017:     # previous screen
 1018:     my $sortby = $ENV{'form.sortby'};
 1019:     my $status = $ENV{'form.Status'};
 1020:     #
 1021:     # We always need this information
 1022:     my $slogin     = $ENV{'form.slogin'};
 1023:     my $sdom       = $ENV{'form.sdomain'};
 1024:     #
 1025:     # Get the old data
 1026:     my %old=&Apache::lonnet::get('environment',
 1027:                                  ['firstname','middlename',
 1028:                                   'lastname','generation','id'],
 1029:                                  $sdom, $slogin);
 1030:     $old{'section'} = &Apache::lonnet::getsection($sdom,$slogin,
 1031:                                                   $ENV{'request.course.id'});
 1032:     my ($tmp) = keys(%old);
 1033:     if ($tmp =~ /^(con_lost|error|no_such_host)/i) {
 1034:         $r->print("There was an error determining the environment values ".
 1035:                   " for $slogin \@ $sdom.");
 1036:         return;
 1037:     }
 1038:     undef $tmp;
 1039:     #
 1040:     # Get the new data
 1041:     my $firstname  = $ENV{'form.firstname'};
 1042:     my $middlename = $ENV{'form.middlename'};
 1043:     my $lastname   = $ENV{'form.lastname'};
 1044:     my $generation = $ENV{'form.generation'};
 1045:     my $section    = $ENV{'form.section'};
 1046:     my $courseid   = $ENV{'request.course.id'};
 1047:     my $sid        = $ENV{'form.id'};
 1048:     my $starttime = &Apache::lonhtmlcommon::get_date_from_form('startdate',
 1049:                                                                time);
 1050:     my $endtime   = &Apache::lonhtmlcommon::get_date_from_form('enddate',
 1051:                                                                time);
 1052:     my $displayable_starttime = localtime($starttime);
 1053:     my $displayable_endtime   = localtime($endtime);
 1054:     # 
 1055:     # check for forceid override
 1056:     if (($sid ne $old{'id'}) && (! exists($ENV{'form.forceid'}))) {
 1057:         $r->print("<font color=\"ff0000\">You changed the students id ".
 1058:                   " but did not disable the ID change safeguard.".
 1059:                   "  The students id will not be changed.</font>");
 1060:         $sid = $old{'id'};
 1061:     }
 1062:     #
 1063:     # talk to the user about what we are going to do
 1064:     $r->print(<<END);
 1065:     <h2>Modifying data for user $slogin \@ $sdom </h2>
 1066: <h3>Student Information</h3>
 1067: <table rules="rows" border="1" cellpadding="3" >
 1068: <tr>
 1069:     <th> Field </th>
 1070:     <th> Old Value </th>
 1071:     <th> New Value </th>
 1072: </tr>
 1073: <tr>
 1074:     <td> <b>First name</b> </td>
 1075:     <td> $old{'firstname'} </td>
 1076:     <td> $firstname </td>
 1077: </tr><tr>
 1078:     <td> <b>Middle name</b> </td>
 1079:     <td> $old{'middlename'} </td>
 1080:     <td> $middlename </td>
 1081: </tr><tr>
 1082:     <td> <b>Last name</b> </td>
 1083:     <td> $old{'lastname'} </td>
 1084:     <td> $lastname </td>
 1085: </tr><tr>
 1086:     <td> <b>Generation</b> </td>
 1087:     <td> $old{'generation'} </td>
 1088:     <td> $generation </td>
 1089: </tr><tr>
 1090:     <td> <b>ID</b> </td>
 1091:     <td> $old{'id'} </td>
 1092:     <td> $sid </td>
 1093: </tr><tr>
 1094:     <td> <b>Section</b> </td>
 1095:     <td> $old{'section'} </td>
 1096:     <td> $section</td>
 1097: </tr>
 1098: </table>
 1099: <h3>Role Information</h3>
 1100: <table>
 1101: <tr><td>Start Time  </td><td> $displayable_starttime </td></tr>
 1102: <tr><td>End Time    </td><td> $displayable_endtime   </td></tr>
 1103: </table>
 1104: <p>
 1105: END
 1106:     #
 1107:     # Send request(s) to modify data
 1108:     my $roleresults = &Apache::lonnet::modifystudent
 1109:         ($sdom,$slogin,$sid,undef,undef,$firstname,$middlename,$lastname,
 1110:          $generation,$section,$endtime,$starttime,$ENV{'form.forceid'});
 1111:     if ($roleresults eq 'refused' ) {
 1112:         $r->print("Your request to change the role information for this ".
 1113:                   "student was refused.  You do not appear to have ".
 1114:                   "sufficient authority to change student information.");
 1115:     } elsif ($roleresults !~ /ok/) {
 1116:         $r->print("An error occurred during the attempt to change the role".
 1117:                   " information for this student.  <br />".
 1118:                   "The error reported was ".
 1119:                   $roleresults);
 1120:         &Apache::lonnet::logthis("londropadd:failed attempt to modify student".
 1121:                                  " data for ".$slogin." \@ ".$sdom." by ".
 1122:                                  $ENV{'user.name'}." \@ ".$ENV{'user.domain'}.
 1123:                                  ":".$roleresults);
 1124:     } else { # everything is okay!
 1125:         $r->print("Student information updated successfully. <br />".
 1126:                   "The student must log out and log in again to see ".
 1127:                   "these changes.");
 1128:     }
 1129:     $r->print(<<END);
 1130: </p><p>
 1131: <input type="hidden" name="action" value="modifystudent" />
 1132: <input type="hidden" name="sortby" value="$sortby" />
 1133: <input type="hidden" name="Status" value="$status" />
 1134: <a href="javascript:document.studentform.submit();">Modify another students data</a>
 1135: </body></html>
 1136: END
 1137:     return;
 1138: }
 1139: 
 1140: sub get_enrollment_data {
 1141:     my ($sname,$sdomain) = @_;
 1142:     my $courseid = $ENV{'request.course.id'};
 1143:     $courseid =~ s:_:/:g;
 1144:     my %roles = &Apache::lonnet::dump('roles',$sdomain,$sname);
 1145:     my ($tmp) = keys(%roles);
 1146:     # Bail out if we were unable to get the students roles
 1147:     return "666" if ($tmp =~ /^(con_lost|error|no_such_host)/i);
 1148:     # Go through the roles looking for enrollment in this course
 1149:     my ($end,$start) = (undef,undef);
 1150:     my $section = '';
 1151:     my $count = scalar(keys(%roles));
 1152:     while (my ($course,$role) = each(%roles)) {
 1153:         &Apache::lonnet::logthis('course = '.$course.' role = '.$role);
 1154:         if ($course=~ /^\/$courseid\/*\s*(\w+)*_st$/ ) {
 1155:             #
 1156:             # Get active role
 1157:             $section=$1;
 1158:             (undef,$end,$start)=split(/\_/,$role);
 1159:             my $now=time;
 1160:             my $notactive=0;
 1161:             if ($start) {
 1162:                 if ($now<$start) { $notactive=1; }
 1163:             }
 1164:             if ($end) {
 1165:                 if ($now>$end) { $notactive=1; }
 1166:             } 
 1167:             unless ($notactive) { return ($start,$end,$section); }
 1168:         }
 1169:     }
 1170:     return ($start,$end,$section);
 1171: }
 1172: 
 1173: #################################################
 1174: #################################################
 1175: 
 1176: =pod
 1177: 
 1178: =item show_drop_list
 1179: 
 1180: Display a list of students to drop
 1181: Inputs: 
 1182: 
 1183: =over 4
 1184: 
 1185: =item $r, Apache request
 1186: 
 1187: =item $classlist, hash pointer returned from loncoursedata::get_classlist();
 1188: 
 1189: =item $keylist, array pointer returned from loncoursedata::get_classlist() 
 1190: which describes the order elements are stored in the %$classlist values.
 1191: 
 1192: =item $nosort, if true, sorting links are omitted.
 1193: 
 1194: =back
 1195: 
 1196: =cut
 1197: 
 1198: #################################################
 1199: #################################################
 1200: sub show_drop_list {
 1201:     my ($r,$classlist,$keylist,$nosort)=@_;
 1202:     my $cid=$ENV{'request.course.id'};
 1203:     if (! exists($ENV{'form.sortby'})) {
 1204:         &Apache::loncommon::get_unprocessed_cgi($ENV{'QUERY_STRING'},
 1205:                                                 ['sortby']);
 1206:     }
 1207:     my $sortby = $ENV{'form.sortby'};
 1208:     if ($sortby !~ /^(username|domain|section|fullname|id)$/) {
 1209:         $sortby = 'username';
 1210:     }
 1211:     #
 1212:     my $action = "drop";
 1213:     $r->print(<<END);
 1214: <input type="hidden" name="sortby" value="$sortby" />
 1215: <input type="hidden" name="action" value="$action" />
 1216: <input type="hidden" name="state"  value="done" />
 1217: <script>
 1218: function checkAll(field) {
 1219:     for (i = 0; i < field.length; i++)
 1220:         field[i].checked = true ;
 1221: }
 1222: 
 1223: function uncheckAll(field) {
 1224:     for (i = 0; i < field.length; i++)
 1225:         field[i].checked = false ;
 1226: }
 1227: </script>
 1228: <p>
 1229: <input type="hidden" name="phase" value="four">
 1230: END
 1231: 
 1232:     if ($nosort) {
 1233:         $r->print(<<END);
 1234: <table border=2>
 1235: <tr>
 1236:     <th>&nbsp;</th>
 1237:     <th>username</th>
 1238:     <th>domain</th>
 1239:     <th>ID</th>
 1240:     <th>student name</th>
 1241:     <th>section</th>
 1242: </tr>
 1243: END
 1244: 
 1245:     } else  {
 1246:         $r->print(<<END);
 1247: <table border=2>
 1248: <tr><th>&nbsp;</th>
 1249:     <th>
 1250:        <a href="/adm/dropadd?action=$action&sortby=username">username</a>
 1251:     </th><th>
 1252:        <a href="/adm/dropadd?action=$action&sortby=domain">domain</a>
 1253:     </th><th>
 1254:        <a href="/adm/dropadd?action=$action&sortby=id">ID</a>
 1255:     </th><th>
 1256:        <a href="/adm/dropadd?action=$action&sortby=fullname">student name</a>
 1257:     </th><th>
 1258:        <a href="/adm/dropadd?action=$action&sortby=section">section</a>
 1259:     </th>
 1260: </tr>
 1261: END
 1262:     }
 1263:     #
 1264:     # Sort the students
 1265:     my %index;
 1266:     my $i;
 1267:     foreach (@$keylist) {
 1268:         $index{$_} = $i++;
 1269:     }
 1270:     my $index  = $index{$sortby};
 1271:     my $second = $index{'username'};
 1272:     my $third  = $index{'domain'};
 1273:     my @Sorted_Students = sort {
 1274:         lc($classlist->{$a}->[$index])  cmp lc($classlist->{$b}->[$index])
 1275:             ||
 1276:         lc($classlist->{$a}->[$second]) cmp lc($classlist->{$b}->[$second])
 1277:             ||
 1278:         lc($classlist->{$a}->[$third]) cmp lc($classlist->{$b}->[$third])
 1279:         } (keys(%$classlist));
 1280:     foreach my $student (@Sorted_Students) {
 1281:         my $error;
 1282:         my $username = $classlist->{$student}->[$index{'username'}];
 1283:         my $domain   = $classlist->{$student}->[$index{'domain'}];
 1284:         my $section  = $classlist->{$student}->[$index{'section'}];
 1285:         my $name     = $classlist->{$student}->[$index{'fullname'}];
 1286:         my $id       = $classlist->{$student}->[$index{'id'}];
 1287:         my $status   = $classlist->{$student}->[$index{'status'}];
 1288:         next if ($status ne 'Active');
 1289:         #
 1290:         $r->print(<<"END");
 1291: <tr>
 1292:     <td><input type="checkbox" name="droplist" value="$student"></td>
 1293:     <td>$username</td>
 1294:     <td>$domain</td>
 1295:     <td>$id</td>
 1296:     <td>$name</td>
 1297:     <td>$section</td>
 1298: </tr>
 1299: END
 1300:     }
 1301:     $r->print('</table><br>');
 1302:     $r->print(<<"END");
 1303: </p><p>
 1304: <input type="button" value="check all" onclick="javascript:checkAll(document.studentform.droplist)"> &nbsp;
 1305: <input type="button" value="uncheck all" onclick="javascript:uncheckAll(document.studentform.droplist)"> 
 1306: <p><input type=submit value="Drop Students"></p>
 1307: END
 1308:     return;
 1309: }
 1310: 
 1311: #
 1312: # Print out the initial form to get the courselist file
 1313: #
 1314: sub print_first_courselist_upload_form {
 1315:     my $r=shift;
 1316:     my $upfile_select=&Apache::loncommon::upfile_select_html();
 1317:     my $create_classlist_help = 
 1318: 	&Apache::loncommon::help_open_topic("Course_Create_Class_List",
 1319:            "How do I create a class list from a spreadsheet");
 1320:     my $create_csv_help =
 1321: 	&Apache::loncommon::help_open_topic("Course_Convert_To_CSV",
 1322:            "How do I create a CSV file from a spreadsheet");
 1323:     $r->print(<<ENDUPFORM);
 1324: <input type=hidden name=phase value=two>
 1325: <h3>Upload a courselist</h3>
 1326: $upfile_select
 1327: <p>
 1328: <input type=submit name="fileupload" value="Upload Courselist">
 1329: <input type="hidden" name="action" value="upload" />
 1330: <input type="hidden" name="state"  value="got_file" />
 1331: </p>
 1332: $create_classlist_help <br />
 1333: $create_csv_help
 1334: </body></html>
 1335: ENDUPFORM
 1336:     return;
 1337: }
 1338: 
 1339: # ================================================= Drop/Add from uploaded file
 1340: sub upfile_drop_add {
 1341:     my $r=shift;
 1342:     &Apache::loncommon::load_tmp_file($r);
 1343:     my @studentdata=&Apache::loncommon::upfile_record_sep();
 1344:     my @keyfields = split(/\,/,$ENV{'form.keyfields'});
 1345:     my $cid = $ENV{'request.course.id'};
 1346:     my %fields=();
 1347:     for (my $i=0; $i<=$ENV{'form.nfields'}; $i++) {
 1348:         if ($ENV{'form.upfile_associate'} eq 'reverse') {
 1349:             if ($ENV{'form.f'.$i} ne 'none') {
 1350:                 $fields{$keyfields[$i]}=$ENV{'form.f'.$i};
 1351:             }
 1352:         } else {
 1353:             $fields{$ENV{'form.f'.$i}}=$keyfields[$i];
 1354:         }
 1355:     }
 1356:     #
 1357:     my $startdate = $ENV{'form.startdate'};
 1358:     my $enddate   = $ENV{'form.enddate'};
 1359:     if ($startdate=~/\D/) { $startdate=''; }
 1360:     if ($enddate=~/\D/)   { $enddate=''; }
 1361:     # Determine domain and desired host (home server)
 1362:     my $domain=$ENV{'form.lcdomain'};
 1363:     my $desiredhost = $ENV{'form.lcserver'};
 1364:     if (lc($desiredhost) eq 'default') {
 1365:         $desiredhost = undef;
 1366:     } else {
 1367:         my %home_servers = &Apache::loncommon::get_library_servers($domain);
 1368:         if (! exists($home_servers{$desiredhost})) {
 1369:             $r->print('<font color="#ff0000">Error:</font>'.
 1370:                       'Invalid home server specified');
 1371:             return;
 1372:         }
 1373:     }
 1374:     # Determine authentication mechanism
 1375:     my $amode  = '';
 1376:     my $genpwd = '';
 1377:     if ($ENV{'form.login'} eq 'krb') {
 1378:         $amode='krb';
 1379: 	$amode.=$ENV{'form.krbver'};
 1380:         $genpwd=$ENV{'form.krbarg'};
 1381:     } elsif ($ENV{'form.login'} eq 'int') {
 1382:         $amode='internal';
 1383:         if ((defined($ENV{'form.intarg'})) && ($ENV{'form.intarg'})) {
 1384:             $genpwd=$ENV{'form.intarg'};
 1385:         }
 1386:     } elsif ($ENV{'form.login'} eq 'loc') {
 1387:         $amode='localauth';
 1388:         if ((defined($ENV{'form.locarg'})) && ($ENV{'form.locarg'})) {
 1389:             $genpwd=$ENV{'form.locarg'};
 1390:         }
 1391:     }
 1392:     unless (($domain=~/\W/) || ($amode eq '')) {
 1393:         #######################################
 1394:         ##         Enroll Students           ##
 1395:         #######################################
 1396:         $r->print('<h3>Enrolling Students</h3>');
 1397:         my $count=0;
 1398:         my $flushc=0;
 1399:         my %student=();
 1400:         # Get new classlist
 1401:         foreach (@studentdata) {
 1402:             my %entries=&Apache::loncommon::record_sep($_);
 1403:             # Determine student name
 1404:             unless (($entries{$fields{'username'}} eq '') ||
 1405:                     (!defined($entries{$fields{'username'}}))) {
 1406:                 my ($fname, $mname, $lname,$gen) = ('','','','');
 1407:                 if (defined($fields{'names'})) {
 1408:                     ($lname,$fname,$mname)=($entries{$fields{'names'}}=~
 1409:                                             /([^\,]+)\,\s*(\w+)\s*(.*)$/);
 1410:                 } else {
 1411:                     if (defined($fields{'fname'})) {
 1412:                         $fname=$entries{$fields{'fname'}};
 1413:                     }
 1414:                     if (defined($fields{'mname'})) {
 1415:                         $mname=$entries{$fields{'mname'}};
 1416:                     }
 1417:                     if (defined($fields{'lname'})) {
 1418:                         $lname=$entries{$fields{'lname'}};
 1419:                     }
 1420:                     if (defined($fields{'gen'})) {
 1421:                         $gen=$entries{$fields{'gen'}};
 1422:                     }
 1423:                 }
 1424:                 if ($entries{$fields{'username'}}=~/\W/) {
 1425:                     $r->print('<p><b>Unacceptable username: '.
 1426:                               $entries{$fields{'username'}}.' for user '.
 1427:                               $fname.' '.$mname.' '.$lname.' '.$gen.'</b><p>');
 1428:                 } else {
 1429:                     # determine section number
 1430:                     my $sec='';
 1431:                     my $username=$entries{$fields{'username'}};
 1432:                     if (defined($fields{'sec'})) {
 1433:                         if (defined($entries{$fields{'sec'}})) {
 1434:                             $sec=$entries{$fields{'sec'}};
 1435:                         }
 1436:                     }
 1437:                     # determine student id number
 1438:                     my $id='';
 1439:                     if (defined($fields{'id'})) {
 1440:                         if (defined($entries{$fields{'id'}})) {
 1441:                             $id=$entries{$fields{'id'}};
 1442:                         }
 1443:                         $id=~tr/A-Z/a-z/;
 1444:                     }
 1445:                     # determine student password
 1446:                     my $password='';
 1447:                     if ($genpwd) { 
 1448:                         $password=$genpwd; 
 1449:                     } else {
 1450:                         if (defined($fields{'ipwd'})) {
 1451:                             if ($entries{$fields{'ipwd'}}) {
 1452:                                 $password=$entries{$fields{'ipwd'}};
 1453:                             }
 1454:                         }
 1455:                     }
 1456:                     # Clean up whitespace
 1457:                     foreach (\$domain,\$username,\$id,\$fname,\$mname,
 1458:                              \$lname,\$gen,\$sec) {
 1459:                         $$_ =~ s/(\s+$|^\s+)//g;
 1460:                     }
 1461:                     if ($password) {
 1462:                         &modifystudent($domain,$username,$cid,$sec,
 1463:                                        $desiredhost);
 1464:                         my $reply=&Apache::lonnet::modifystudent
 1465:                             ($domain,$username,$id,$amode,$password,
 1466:                              $fname,$mname,$lname,$gen,$sec,$enddate,
 1467:                              $startdate,$ENV{'form.forceid'},$desiredhost);
 1468:                         if ($reply ne 'ok') {
 1469:                             $r->print('<p><b>'.
 1470:                                       'Error enrolling '.$username.': '.
 1471:                                       $reply.'</b></p>');
 1472:          		} else {
 1473:                             $count++; $flushc++;
 1474:                             $student{$username}=1;
 1475:                             $r->print('. ');
 1476:                             if ($flushc>15) {
 1477: 				$r->rflush;
 1478:                                 $flushc=0;
 1479:                             }
 1480:                         }
 1481:                     } else {
 1482:                         $r->print("<p><b>No password for $username</b><p>");
 1483:                     }
 1484:                 }
 1485:             }
 1486:         } # end of foreach (@studentdata)
 1487:         $r->print('<p>Processed Students: '.$count.'</p>');
 1488:         $r->print("<p>If active, the new role will be available when the ".
 1489:                   "students next log in to LON-CAPA.</p>");
 1490:         #####################################
 1491:         #           Drop students           #
 1492:         #####################################
 1493:         if ($ENV{'form.fullup'} eq 'yes') {
 1494:             $r->print('<h3>Dropping Students</h3>');
 1495:             #  Get current classlist
 1496:             my ($classlist,$keylist)=&Apache::loncoursedata::get_classlist();
 1497:             if (! defined($classlist)) {
 1498:                 $r->print("There are no students currently enrolled.\n");
 1499:             } else {
 1500:                 # Remove the students we just added from the list of students.
 1501:                 foreach (@studentdata) {
 1502:                     my %entries=&Apache::loncommon::record_sep($_);
 1503:                     unless (($entries{$fields{'username'}} eq '') ||
 1504:                             (!defined($entries{$fields{'username'}}))) {
 1505:                         delete($classlist->{$entries{$fields{'username'}}.
 1506:                                                 ':'.$domain});
 1507:                     }
 1508:                 }
 1509:                 # Print out list of dropped students.
 1510:                 &show_drop_list($r,$classlist,$keylist,'nosort');
 1511:             }
 1512:         }
 1513:     } # end of unless
 1514: }
 1515: 
 1516: # ================================================================== Phase four
 1517: sub drop_student_list {
 1518:     my $r=shift;
 1519:     my $count=0;
 1520:     my @droplist;
 1521:     if (ref($ENV{'form.droplist'})) {
 1522:         @droplist = @{$ENV{'form.droplist'}};
 1523:     } else {
 1524:         @droplist = ($ENV{'form.droplist'});
 1525:     }
 1526:     foreach (@droplist) {
 1527:         my ($uname,$udom)=split(/\:/,$_);
 1528:         # drop student
 1529:         my $result = &modifystudent($udom,$uname,$ENV{'request.course.id'});
 1530:         if ($result eq 'ok' || $result eq 'ok:') {
 1531:             $r->print('Dropped '.$uname.' @ '.$udom.'<br>');
 1532:             $count++;
 1533:         } else {
 1534:             $r->print('Error dropping '.$uname.' @ '.$udom.': '.$result.
 1535:                       '<br />');
 1536:         }
 1537:     }
 1538:     $r->print('<p><b>Dropped '.$count.' student(s).</b>');
 1539:     $r->print('<p>Re-enrollment will re-activate data.') if ($count);
 1540: }
 1541: 
 1542: ###################################################################
 1543: ###################################################################
 1544: 
 1545: =pod
 1546: 
 1547: =item &handler
 1548: 
 1549: The typical handler you see in all these modules.  Takes $r, the
 1550: http request, as an argument.  
 1551: 
 1552: The response to the request is governed by two form variables
 1553: 
 1554:  form.action      form.state     response
 1555:  ---------------------------------------------------
 1556:  undefined        undefined      print main menu
 1557:  upload           undefined      print courselist upload menu
 1558:  upload           got_file       deal with uploaded file,
 1559:                                  print the upload managing menu
 1560:  upload           enrolling      enroll students based on upload
 1561:  drop             undefined      print the classlist ready to drop
 1562:  drop             done           drop the selected students
 1563:  enrollstudent    undefined      print single student enroll menu
 1564:  enrollstudent    enrolling      enroll student
 1565:  classlist        undefined      print html classlist
 1566:  classlist        csv            print csv classlist
 1567:  modifystudent    undefined      print classlist to select student to modify
 1568:  modifystudent    selected       print modify student menu
 1569:  modifystudent    done           make modifications to student record
 1570: 
 1571: =cut
 1572: 
 1573: ###################################################################
 1574: ###################################################################
 1575: sub handler {
 1576:     my $r=shift;
 1577:     if ($r->header_only) {
 1578:         $r->content_type('text/html');
 1579:         $r->send_http_header;
 1580:         return OK;
 1581:     }
 1582:     &Apache::loncommon::get_unprocessed_cgi($ENV{'QUERY_STRING'},
 1583:                                             ['action','state']);
 1584:     #  Needs to be in a course
 1585:     if (! (($ENV{'request.course.fn'}) &&
 1586:           (&Apache::lonnet::allowed('cst',$ENV{'request.course.id'})))) {
 1587:         # Not in a course, or not allowed to modify parms
 1588:         $ENV{'user.error.msg'}=
 1589:             "/adm/dropadd:cst:0:0:Cannot drop or add students";
 1590:         return HTTP_NOT_ACCEPTABLE; 
 1591:     }
 1592:     #
 1593:     # Only output the header information if they did not request csv format
 1594:     #
 1595:     if (exists($ENV{'form.state'}) && ($ENV{'form.state'} eq 'csv')) {
 1596:         $r->content_type('text/csv');
 1597:     } else {
 1598:         # Start page
 1599:         $r->content_type('text/html');
 1600:         $r->send_http_header;
 1601:         $r->print(&header());
 1602:     }
 1603:     #
 1604:     # Main switch on form.action and form.state, as appropriate
 1605:     if (! exists($ENV{'form.action'})) {
 1606:         &print_main_menu($r);
 1607:     } elsif ($ENV{'form.action'} eq 'upload') {
 1608:         if (! exists($ENV{'form.state'})) {
 1609:             &print_first_courselist_upload_form($r);            
 1610:         } elsif ($ENV{'form.state'} eq 'got_file') {
 1611:             &print_upload_manager_form($r);
 1612:         } elsif ($ENV{'form.state'} eq 'enrolling') {
 1613:             if ($ENV{'form.datatoken'}) {
 1614:                 &upfile_drop_add($r);
 1615:             } else {
 1616:                 # Hmmm, this is an error
 1617:             }
 1618:         } else {
 1619:             &print_first_courselist_upload_form($r);            
 1620:         }
 1621:     } elsif ($ENV{'form.action'} eq 'drop') {
 1622:         if (! exists($ENV{'form.state'})) {
 1623:             &print_drop_menu($r);
 1624:         } elsif ($ENV{'form.state'} eq 'done') {
 1625:             &drop_student_list($r);
 1626:         } else {
 1627:             &print_drop_menu($r);
 1628:         }
 1629:     } elsif ($ENV{'form.action'} eq 'enrollstudent') {
 1630:         if (! exists($ENV{'form.state'})) {
 1631:             &print_enroll_single_student_form($r);
 1632:         } elsif ($ENV{'form.state'} eq 'enrolling') {
 1633:             &enroll_single_student($r);
 1634:         } else {
 1635:             &print_enroll_single_student_form($r);
 1636:         }
 1637:     } elsif ($ENV{'form.action'} eq 'classlist') {
 1638:         if (! exists($ENV{'form.state'})) {
 1639:             &print_html_classlist($r);
 1640:         } elsif ($ENV{'form.state'} eq 'csv') {
 1641:             &print_csv_classlist($r);
 1642:         } else {
 1643:             &print_html_classlist($r);
 1644:         }
 1645:     } elsif ($ENV{'form.action'} eq 'modifystudent') {
 1646:         if (! exists($ENV{'form.state'})) {
 1647:             &print_html_classlist($r);
 1648:         } elsif ($ENV{'form.state'} eq 'selected') {
 1649:             &print_modify_student_form($r);
 1650:         } elsif ($ENV{'form.state'} eq 'done') {
 1651:             &modify_single_student($r);
 1652:         } else {
 1653:             &print_html_classlist($r);
 1654:         }        
 1655:     } else {
 1656:         # We should not end up here, but I guess it is possible
 1657:         &Apache::lonnet::logthis("Undetermined state in londropadd.pm.  ".
 1658:                                  "form.action = ".$ENV{'form.action'}.
 1659:                                  "Someone should fix this.");
 1660:         &print_main_menu($r);
 1661:     }
 1662:     #
 1663:     # Finish up
 1664:     if (exists($ENV{'form.state'}) && ($ENV{'form.state'} eq 'csv')) {
 1665:         $r->print("\n");
 1666:     } else {
 1667:         $r->print('</form></body></html>');
 1668:     }
 1669:     return OK;
 1670: }
 1671: 
 1672: ###################################################################
 1673: ###################################################################
 1674: 
 1675: 1;
 1676: __END__
 1677: 
 1678: 

FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>