File:  [LON-CAPA] / loncom / interface / groupsort.pm
Revision 1.33: download - view: text, annotated - select for diffs
Thu Jun 9 22:06:09 2005 UTC (18 years, 11 months ago) by www
Branches: MAIN
CVS tags: HEAD
Cleanup - stuffing all db-file reading into subroutine

    1: # The LearningOnline Network with CAPA
    2: # The LON-CAPA group sort handler
    3: # Allows for sorting prior to import into RAT.
    4: #
    5: # $Id: groupsort.pm,v 1.33 2005/06/09 22:06:09 www Exp $
    6: # 
    7: # Copyright Michigan State University Board of Trustees
    8: #
    9: # This file is part of the LearningOnline Network with CAPA (LON-CAPA).
   10: #
   11: # LON-CAPA is free software; you can redistribute it and/or modify
   12: # it under the terms of the GNU General Public License as published by
   13: # the Free Software Foundation; either version 2 of the License, or
   14: # (at your option) any later version.
   15: #
   16: # LON-CAPA is distributed in the hope that it will be useful,
   17: # but WITHOUT ANY WARRANTY; without even the implied warranty of
   18: # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   19: # GNU General Public License for more details.
   20: #
   21: # You should have received a copy of the GNU General Public License
   22: # along with LON-CAPA; if not, write to the Free Software
   23: # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
   24: #
   25: # /home/httpd/html/adm/gpl.txt
   26: #
   27: # http://www.lon-capa.org/
   28: #
   29: ###
   30: 
   31: package Apache::groupsort;
   32: 
   33: use strict;
   34: 
   35: use Apache::Constants qw(:common);
   36: use GDBM_File;
   37: use Apache::loncommon;
   38: use Apache::lonlocal;
   39: use Apache::lonnet;
   40: 
   41: my $iconpath; # variable to be accessible to multiple subroutines
   42: my %hash; # variable to tie to user specific database
   43: 
   44: 
   45: sub readfromdb {
   46:     my ($r,$shash,$thash)=@_;
   47: 
   48:     my $diropendb;
   49: # ------------------------------ which file do we open? Easy if explictly given
   50:     if ($env{'form.catalogmode'} eq 'groupsearch') {
   51: 	$diropendb = 
   52: 	    "/home/httpd/perl/tmp/$env{'user.domain'}_$env{'user.name'}_searchcat.db";
   53:     } elsif ($env{'form.catalogmode'} eq 'groupimport') {
   54: 	$diropendb = 
   55: 	    "/home/httpd/perl/tmp/$env{'user.domain'}_$env{'user.name'}_indexer.db";
   56:     } elsif ($env{'form.catalogmode'} eq 'groupsec') {
   57: 	$diropendb = 
   58: 	    "/home/httpd/perl/tmp/$env{'user.domain'}_$env{'user.name'}_groupsec.db";
   59:     } else {
   60: # --------------------- not explicitly given, choose the one most recently used
   61:         my @dbfn;
   62:         my @dbst;
   63: 
   64: 	$dbfn[0] =
   65: 	    "/home/httpd/perl/tmp/$env{'user.domain'}_$env{'user.name'}_searchcat.db";
   66:         $dbst[0]=-1;
   67: 	if (-e $dbfn[0]) {
   68: 	    $dbst[0]=(stat($dbfn[0]))[9];
   69: 	}
   70: 	$dbfn[1] =
   71:             "/home/httpd/perl/tmp/$env{'user.domain'}_$env{'user.name'}_indexer.db";
   72:         $dbst[1]=-1;
   73: 	if (-e $dbfn[1]) {
   74:             $dbst[1]=(stat($dbfn[1]))[9];
   75:         }
   76: 	$dbfn[2] =
   77:             "/home/httpd/perl/tmp/$env{'user.domain'}_$env{'user.name'}_groupsec.db";
   78:         $dbst[2]=-1;
   79: 	if (-e $dbfn[2]) {
   80:             $dbst[2]=(stat($dbfn[2]))[9];
   81:         }
   82: # Expand here for more modes
   83: # ....
   84: 
   85: # Okay, find most recent existing
   86: 
   87:         my $newest=0;
   88:         $diropendb='';
   89:         for (my $i=0; $i<=$#dbfn; $i++) {
   90: 	    if ($dbst[$i]>$newest) {
   91: 		$newest=$dbst[$i];
   92:                 $diropendb=$dbfn[$i];
   93:             }
   94:         }
   95: 
   96:     }
   97: # ----------------------------- diropendb is now the filename of the db to open
   98:     if (tie(%hash,'GDBM_File',$diropendb,&GDBM_WRCREAT(),0640)) {
   99: 	my $acts = $env{'form.acts'};
  100: 	my @Acts = split(/b/,$acts);
  101: 	my %ahash;
  102: 	my %achash;
  103: 	my $ac = 0;
  104: 	foreach (@Acts) {
  105: 	    my ($state,$ref) = split(/a/);
  106: 	    $ahash{$ref} = $state;
  107: 	    $achash{$ref} = $ac;
  108: 	    $ac++;
  109: 	}
  110: 	foreach (sort {$achash{$a} <=> $achash{$b}} (keys %ahash)) {
  111: 	    my $key = $_;
  112: 	    if ($ahash{$key} eq '1') {
  113: #		my $keyz=join("<br />",keys %hash);
  114: #		print "<br />$key<br />$keyz".$hash{'pre_'.$key.'_link'}."<br />\n";
  115: 		$hash{'store_'.$hash{'pre_'.$key.'_link'}} =
  116: 		    $hash{'pre_'.$key.'_title'};
  117: 		$hash{'storectr_'.$hash{'pre_'.$key.'_link'}} =
  118: 		    $hash{'storectr'}+0;
  119: 		$hash{'storectr'}++;
  120: 	    }
  121: 	    if ($ahash{$key} eq '0') {
  122: 		if ($hash{'store_'.$hash{'pre_'.$key.'_link'}}) {
  123: 		    delete $hash{'store_'.$hash{'pre_'.$key.'_link'}};
  124: 		}
  125: 	    }
  126: 	}
  127: 	foreach (keys %hash) {
  128: 	    if ($_ =~ /^store_/) {
  129: 		my $key = $_;
  130: 		$key =~ s/^store_//;
  131: 		$$shash{$key} = $hash{'storectr_'.$key};
  132: 		if (&Apache::lonnet::gettitle($key) eq '') {
  133: 		    $$thash{$key} = $hash{'store_'.$key};
  134: 		} else {
  135: 		    $$thash{$key} = &Apache::lonnet::gettitle($key);
  136: 		}
  137: 	    }
  138: 	}
  139: 	if ($env{'form.oldval'}) {
  140: 	    my $newctr = 0;
  141: 	    my %chash;
  142: 	    foreach (sort {$$shash{$a} <=> $$shash{$b}} (keys %{$shash})) {
  143: 		my $key = $_;
  144: 		$newctr++;
  145: 		$$shash{$key} = $newctr;
  146: 		$hash{'storectr_'.$key} = $newctr;
  147: 		$chash{$newctr} = $key;
  148: 	    }
  149: 	    my $oldval = $env{'form.oldval'};
  150: 	    my $newval = $env{'form.newval'};
  151: 	    if ($oldval != $newval) {
  152: 		# when newval==0, then push down and delete
  153: 		if ($newval!=0) {
  154: 		    $$shash{$chash{$oldval}} = $newval;
  155: 		    $hash{'storectr_'.$chash{$oldval}} = $newval;
  156: 		} else {
  157: 		    $$shash{$chash{$oldval}} = $newctr;
  158: 		    $hash{'storectr_'.$chash{$oldval}} = $newctr;
  159: 		}
  160: 		if ($newval==0) { # push down
  161: 		    my $newval2=$newctr;
  162: 		    for my $idx ($oldval..($newval2-1)) {
  163: 			$$shash{$chash{$idx+1}} = $idx;
  164: 			$hash{'storectr_'.$chash{$idx+1}} = $idx;
  165: 		    }
  166: 		    delete $$shash{$chash{$oldval}};
  167: 		    delete $hash{'storectr_'.$chash{$oldval}};
  168: 		    delete $hash{'store_'.$chash{$oldval}};
  169: 		} elsif ($oldval < $newval) { # push down
  170: 		    for my $idx ($oldval..($newval-1)) {
  171: 			$$shash{$chash{$idx+1}} = $idx;
  172: 			$hash{'storectr_'.$chash{$idx+1}} = $idx;
  173: 		    }
  174: 		} elsif ($oldval > $newval) { # push up
  175: 		    for my $idx (reverse($newval..($oldval-1))) {
  176: 			$$shash{$chash{$idx}} = $idx+1;
  177: 			$hash{'storectr_'.$chash{$idx}} = $idx+1;
  178: 		    }
  179: 		}
  180: 	    }
  181: 	}
  182:     } else {
  183: 	$r->print('Unable to tie hash to db file</body></html>');
  184: 	return OK;
  185:     }
  186:     untie %hash;
  187:     return ($shash,$thash);
  188: }
  189: 
  190: 
  191: 
  192: sub cleanup {
  193:     if (tied(%hash)){
  194: 	&Apache::lonnet::logthis('Cleanup groupsort: hash');
  195:         unless (untie(%hash)) {
  196: 	    &Apache::lonnet::logthis('Failed cleanup groupsort: hash');
  197:         }
  198:     }
  199: }
  200: 
  201: # ---------------------------------------------------------------- Main Handler
  202: sub handler {
  203:     my $r = shift;
  204:  
  205:    &Apache::loncommon::get_unprocessed_cgi($ENV{'QUERY_STRING'},
  206:                                            ['acts','catalogmode','mode']);
  207:     # color scheme
  208:     my $fileclr = '#ffffe6';
  209:     my $titleclr = '#ddffff';
  210: 
  211:     &Apache::loncommon::content_type($r,'text/html');
  212:     $r->send_http_header;
  213:     return OK if $r->header_only;
  214: 
  215: # finish_import looks different for graphical or "simple" RAT
  216:     my $finishimport='';
  217:     if ($env{'form.mode'} eq 'simple' || $env{'form.mode'} eq '') {
  218:         $finishimport=(<<ENDSMP);
  219: function finish_import() {
  220:     opener.document.forms.simpleedit.importdetail.value='';
  221:     for (var num=0; num<document.forms.groupsort.fnum.value; num++) {
  222: 	opener.document.forms.simpleedit.importdetail.value+='&'+
  223:               escape(eval("document.forms.groupsort.title"+num+".value"))+'='+
  224: 	      escape(eval("document.forms.groupsort.filelink"+num+".value"));
  225:     }
  226:     opener.document.forms.simpleedit.submit();
  227:     self.close();
  228: }
  229: ENDSMP
  230:     } else {
  231:         $finishimport=(<<ENDADV);
  232: function finish_import() {
  233:     var linkflag=false;
  234:     for (var num=0; num<document.forms.groupsort.fnum.value; num++) {
  235: 	insertRowInLastRow();
  236: 	placeResourceInLastRow(
  237: 	       eval("document.forms.groupsort.title"+num+".value"),
  238:  	       eval("document.forms.groupsort.filelink"+num+".value"),
  239: 	       linkflag
  240: 	);
  241:         linkflag=true;
  242:     }
  243:     opener.editmode=0;
  244:     opener.notclear=0;
  245:     opener.linkmode=0;
  246:     opener.draw();
  247:     self.close();
  248: }
  249: ENDADV
  250:     }
  251: 
  252: # output start of web page
  253:     my $html=&Apache::lonxml::xmlbegin();
  254:     $r->print(<<END);
  255: $html
  256: <head>
  257: <title>The LearningOnline Network With CAPA Group Sorter</title>
  258: <script language='javascript'>
  259: function insertRowInLastRow() {
  260:     opener.insertrow(opener.maxrow);
  261:     opener.addobj(opener.maxrow,'e&2');
  262: }
  263: function placeResourceInLastRow (title,url,linkflag) {
  264:     opener.mostrecent=opener.newresource(opener.maxrow,2,opener.escape(title),
  265: 		       opener.escape(url),'false','normal');
  266:     opener.save();
  267:     if (linkflag) {
  268: 	opener.joinres(opener.linkmode,opener.mostrecent,0);
  269:     }
  270:     opener.linkmode=opener.mostrecent;
  271: }
  272: $finishimport
  273: function selectchange(val) {
  274:     var newval=0+eval("document.forms.groupsort.alt"+val+".selectedIndex");
  275:     orderchange(val,newval);
  276: }
  277: function move(val,newval) {
  278:     orderchange(val,newval);
  279: }
  280: function orderchange(val,newval) {
  281:     document.forms.groupsort.oldval.value=val;
  282:     document.forms.groupsort.newval.value=newval;
  283:     document.forms.groupsort.submit();
  284: }
  285: </script>
  286: </head>
  287: END
  288:     # read pertinent machine configuration
  289:     my $domain  = $r->dir_config('lonDefDomain');
  290:     $iconpath = $r->dir_config('lonIconsURL') . "/";
  291: 
  292:     my %shash; # sort order (key is resource location, value is sort order)
  293:     my %thash; # title (key is resource location, value is title)
  294: 
  295:     &readfromdb($r,\%shash,\%thash);
  296: 
  297:     my $ctr = 0;
  298:     my $clen = scalar(keys %shash);
  299:     if ($clen > 1) {
  300: 	my %lt=&Apache::lonlocal::texthash(
  301: 		'fin'=> 'Finalize order of resources',
  302: 		'gb' => 'Go Back',
  303: 		'ns' => 'New Search',
  304: 		'fi' => 'Finish Import',
  305: 		'ca' => 'Cancel',
  306: 		'co' => 'Change Order',
  307: 		'ti' => 'Title',
  308: 		'pa' => 'Path'
  309: 		);
  310: 	$r->print(&Apache::loncommon::bodytag('Sort Imported Resources'));
  311: 	$r->print(<<END);
  312: <b><font color="#888888">$lt{'fin'}</font></b>
  313: <form method='post' action='/adm/groupsort' name='groupsort'
  314:       enctype='application/x-www-form-urlencoded'>
  315: <input type="hidden" name="fnum" value="$clen" />
  316: <input type="hidden" name="oldval" value="" />
  317: <input type="hidden" name="newval" value="" />
  318: <input type="hidden" name="mode" value="$env{'form.mode'}" />
  319: END
  320: 
  321:         # --- Expand here if "GO BACK" button desired
  322:         if ($env{'form.catalogmode'} eq 'groupimport') {
  323:             my $resurl = &Apache::loncommon::lastresurl();
  324: 	    $r->print(<<END);
  325: <input type="button" name="alter" value="$lt{'gb'}"
  326:  onClick="window.location='$resurl?catalogmode=groupimport'" />&nbsp;
  327: END
  328:         }
  329: 	if ($env{'form.catalogmode'} eq 'groupsearch') {
  330: 	    $r->print(<<END);
  331: <input type="button" name="alter" value="$lt{'ns'}"
  332:  onClick="window.location='/adm/searchcat?catalogmode=groupsearch&cleargroupsort=1'" />&nbsp;
  333: END
  334:         }
  335:         # ---
  336: 
  337: 	$r->print(<<END);
  338: <input type="button" name="alter" value="$lt{'fi'}"
  339:  onClick="finish_import()" />&nbsp;
  340: <input type="button" name="alter" value="$lt{'ca'}" onClick="self.close()" />
  341: END
  342:         $r->print("<table border='0'><tr><td bgcolor='#eeeeee'>");
  343: 	$r->print("<table border=0><tr>\n");
  344: 	$r->print("<td colspan='2' bgcolor='$titleclr'><b>$lt{'co'}</b></td>\n");
  345: 	$r->print("<td colspan='2' bgcolor='$titleclr'><b>$lt{'ti'}</b></td>\n");
  346: 	$r->print("<td bgcolor='$titleclr'><b>$lt{'pa'}</b></td></tr>\n");
  347:     } else {
  348: 	$r->print(<<END);
  349: <body>
  350: <form method='post' action='/adm/groupsort' name='groupsort'
  351:       enctype='application/x-www-form-urlencoded'>
  352: <input type="hidden" name="fnum" value="$clen" />
  353: <input type="hidden" name="oldval" value="" />
  354: <input type="hidden" name="newval" value="" />
  355: <input type="hidden" name="mode" value="$env{'form.mode'}" />
  356: END
  357:     }
  358:     foreach (sort {$shash{$a}<=>$shash{$b}} (keys %shash)) {
  359: 	my $key=$_;
  360: 	$ctr++;
  361: 	my $iconname=&Apache::loncommon::icon($key);
  362: 	if ($clen > 1) {
  363: 	    $r->print("<tr><td bgcolor='$fileclr'>");
  364: 	    $r->print(&movers($clen,$ctr));
  365: 	}
  366: 	$r->print(&hidden($ctr-1,$thash{$key},$key));
  367: 	if ($clen > 1) {
  368: 	    $r->print("</td><td bgcolor='$fileclr'>");
  369: 	    $r->print(&select_box($clen,$ctr));
  370: 	    $r->print("</td><td bgcolor='$fileclr'>");
  371: 	    $r->print("<img src='$iconname' />");
  372: 	    $r->print("</td><td bgcolor='$fileclr'>");
  373: 	    $r->print("$thash{$key}</td><td bgcolor='$fileclr'>\n");
  374: 	    $r->print("$key</td></tr>\n");
  375: 	} 
  376:     }
  377:     if ($clen > 1) {
  378: 	$r->print("</table></td></tr></table></form>");
  379:     } else {
  380: 	$r->print(<<END);
  381: <script type="text/javascript">
  382:     finish_import();
  383: </script>
  384: END
  385:     }
  386:     $r->print(<<END);
  387: </body>
  388: </html>
  389: END
  390: 
  391:     return OK;
  392: }
  393: 
  394: # --------------------------------------- Hidden values (returns scalar string)
  395: sub hidden {
  396:     my ($sel,$title,$filelink) = @_;
  397:     my $string = '<input type="hidden" name="title'.$sel.'" value="'.$title.
  398: 	'" />';
  399:     $string .= '<input type="hidden" name="filelink'.$sel.'" value="'.
  400: 	$filelink.'" />';
  401:     return $string;
  402: }
  403: 
  404: # --------------------------------------- Moving arrows (returns scalar string)
  405: sub movers {
  406:     my ($total,$sel) = @_;
  407:     my $dsel = $sel-1;
  408:     my $usel = $sel+1;
  409:     $usel = 1 if $usel > $total;
  410:     $dsel = $total if $dsel < 1;
  411:     my $string;
  412:     $string = (<<END);
  413: <table border='0' cellspacing='0' cellpadding='0'>
  414: <tr><td><a href='javascript:move($sel,$dsel)'>
  415: <img src="${iconpath}move_up.gif" alt='UP' border='0' /></a></td></tr>
  416: <tr><td><a href='javascript:move($sel,$usel)'>
  417: <img src="${iconpath}move_down.gif" alt='DOWN' border='0' /></a></td></tr>
  418: </table>
  419: END
  420:     return $string;
  421: }
  422: 
  423: # ------------------------------------------ Select box (returns scalar string)
  424: sub select_box {
  425:     my ($total,$sel) = @_;
  426:     my $string;
  427:     $string = '<select name="alt'.$sel.'"';
  428:     $string .= " onChange='selectchange($sel)'>";
  429:     $string .= "<option name='o0' value='0'>remove</option>";
  430:     for my $cur (1..$total) {
  431: 	$string .= "<option name='o$cur' value='$cur'";
  432: 	if ($cur == $sel) {
  433: 	    $string .= "selected";
  434: 	}
  435: 	$string .= ">$cur</option>";
  436:     }
  437:     $string .= "</select>\n";
  438:     return $string;
  439: }
  440: 
  441: 1;
  442: 
  443: __END__

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