X-Git-Url: https://git.jankratochvil.net/?p=kewensis.git;a=blobdiff_plain;f=index.php;h=5516faa25802a5cf9817194d25757348382d2fea;hp=14f1ff38267d800fd8428aa1d2cf8429ae45d370;hb=refs%2Fheads%2Fmaster;hpb=cc9a120fa1095fe32c186606799e005456fccb54

diff --git a/index.php b/index.php
index 14f1ff3..5516faa 100644
--- a/index.php
+++ b/index.php
@@ -2,73 +2,328 @@
 
 	include("energie/common.php");
 
-	heading(false/*title*/);
+	$head_css="
+.name { font-weight: bold; }
+.PublAuthor { font-variant: small-caps; }
+.Publication { }
+";
+	no_cache();
+
+	$buttonre=".+";
+	prepvar("find"     ,".*"     ,false /* require */);
+	if (isset($find))
+		$find=trim($find);
+	prepvar("confirm"  ,$buttonre,false /* require */);
+	prepvar("delete"   ,$buttonre,false /* require */);
+	prepvar("isolate"  ,$buttonre,false /* require */);
+	prepvar("edit"     ,$buttonre,false /* require */);
+	prepvar("update"   ,$buttonre,false /* require */);
+	prepvar("move"     ,$buttonre,false /* require */);
+	prepvar("reorder"  ,$buttonre,false /* require */);
+	
+	prepvar("move_src","[-0-9 ,]+"    ,isset($move   ) /* require */);
+	prepvar("move_dst","[-0-9]+"      ,isset($move   ) /* require */);
+	prepvar("confirming","[a-z]+"     ,isset($confirm) /* require */);
+	prepvar("reorder_by","[+-]?[0-9]+",isset($reorder) /* require */);
+
+	prepvar("id"     ,"[-0-9]+",(isset($update) || isset($confirm) || isset($delete) || isset($isolate) || isset($edit)) || isset($reorder) /* require */);
+	prepvar("winclose" ,"1",false /* require */);
+
+	// Database fields:
+	prepvar("name"       ,".*"     ,false /* require */);
+	prepvar("PublAuthor" ,".*"     ,false /* require */);
+	prepvar("Publication",".*"     ,false /* require */);
+	prepvar("html"       ,".*"     ,false /* require */);
+
+	// "find" dump limits:
+	prepvar("limit_from","[0-9]*",false /* require */);
+	if (!isset($limit_from))
+		$limit_from=0;
+	prepvar("limit_max" ,"[0-9]*",false /* require */);
+	if (!isset($limit_max))
+		$limit_max=$limit_max_default;
+
+	$permanents_array=array("find","limit_from","limit_max","winclose");
+
+	if (isset($update)) {
+
+function fieldupdate($field)
+{
+	global $cmd,$cmdargnum;
+
+	$cmd.=(!$cmdargnum?" ":",")."$field=";
+	if ($GLOBALS[$field]!="")
+		$cmd.="\"".mysql_escape_string($GLOBALS[$field])."\"";
+	else
+		$cmd.="NULL";
+	$cmdargnum++;
+}
+
+		$cmd="update $tb_tree set";
+		$cmdargnum=0;
+		fieldupdate("name");
+		fieldupdate("PublAuthor");
+		fieldupdate("Publication");
+		fieldupdate("html");
+		$cmd.=" where id=\"".mysql_escape_string($id)."\"";
+		if ($cmdargnum)
+			db_query($cmd);
+		// PASSTHRU redirect
+		}
+	if (isset($delete)) {
+		db_query("delete from $tb_tree where id=\"".mysql_escape_string($id)."\"");
+		// PASSTHRU redirect
+		}
+	if (isset($isolate)) {
+		$family_id=db_item("select family_id from $tb_tree where id=\"".mysql_escape_string($id)."\"");
+		if ($id!=$family_id)
+			db_query("update $tb_tree set family_id=id where id=\"".mysql_escape_string($id)."\"");
+		else {
+			$where="where family_id=\"".mysql_escape_string($family_id)."\" and family_id<>id";
+			$other_id=db_item("select id from $tb_tree $where limit 1");
+			db_query("update $tb_tree set family_id=\"".mysql_escape_string($other_id)."\" $where");
+			}
+		// PASSTHRU redirect
+		}
+	if (isset($move)) {
+		$order=db_item("select max(family_order) from $tb_tree where family_id=\"".mysql_escape_string($move_dst)."\"");
+		foreach(preg_split('/[ ,]/',$move_src,-1,PREG_SPLIT_NO_EMPTY) as $src) {
+			// UGLY but how to do sequential setting of increasing family_order?
+			$result=db_query("select id from $tb_tree where family_id=\"".mysql_escape_string($src)."\" order by family_order");
+			while (($row=mysql_fetch_array($result)))
+				db_query("update $tb_tree set family_order=\"".(++$order)."\",family_id=\"".mysql_escape_string($move_dst)."\""
+						." where id=\"".mysql_escape_string($row["id"])."\"");
+			}
+		// PASSTHRU redirect
+		}
+	if (isset($reorder)) {
+		$row=db_array("select family_id,family_order from $tb_tree where id=\"".mysql_escape_string($id)."\"");
+		$other_order=db_item("select family_order from $tb_tree where family_id=\"".mysql_escape_string($row["family_id"])."\""
+				." and family_order".($reorder_by<0 ? "<" : ">").$row["family_order"]
+				." order by family_order ".($reorder_by<0 ? "desc" : "asc")." limit 1");
+		db_query("update $tb_tree set family_order=family_order".($reorder_by>=0 ? "+" : "").$reorder_by
+				." where family_id=\"".mysql_escape_string($row["family_id"])."\""
+				." and family_order".($reorder_by<0 ? "<" : ">").$other_order);
+		db_query("update $tb_tree set family_order=".($other_order+$reorder_by)." where id=\"".mysql_escape_string($id)."\"");
+		// PASSTHRU redirect
+		}
 
-	prepvar("find",".+",false /* require */);
+function hiddens($array,$doinputs)
+{
+	global $permanents_array;
+	$r="";
+	foreach ($permanents_array as $key)
+		if (!isset($key,$array) && isset($GLOBALS[$key]))
+			$array[$key]=$GLOBALS[$key];
+	foreach ($array as $key=>$val) {
+		if ($doinputs)
+			$r.="<input type=\"hidden\" name=\"".htmlspecialchars($key)."\" value=\"".htmlspecialchars($val)."\" />\n";
+		else
+			$r.=($r==""?"?":"&").addpercents($key)."=".addpercents($val);
+		}
+	if (!$doinputs && $r=="")
+		$r="?_dummy=1";
+	return($r);
+}
 
-	if (!isset($find)) {
-		?>
-<form action="index.php" method="post">
-<input type="text" name="find" size="30" />
-<input type="submit" value="Vyhledat" />
-</form>
+	if (isset($delete) || isset($update) || isset($move) || isset($isolate) || isset($reorder)) {
+		if (isset($winclose)) {
+			header("Content-type: text/html");
+			?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="cs">
+<head><title>Window close</title></head>
+<body onload="window.close();">
+<p>Window close</p>
+</body></html>
 <?php
-		footer(true /* delimit */);
+			}
+		else {
+			// OK: Redirect will NOT keep the request type "POST"!
+			$redir="http://".$HTTP_SERVER_VARS["HTTP_HOST"].$HTTP_SERVER_VARS["REQUEST_URI"].hiddens(array(),false/*doinputs*/);
+			header("Location: $redir");
+			}
 		exit();
 		}
-	$families=db_query("select distinct family_id from $tb_tree"
-			." where name like \"".quotemeta($find)."%\""
-			." order by family_id");
 
-function fieldquote($prefix,$field,$class)
+	heading(false/*title*/);
+
+function fieldedit($field,$size,$append="")
 {
 	global $row;
+	return("<input type=\"text\" name=\"".htmlspecialchars($field)."\" size=\"$size\" value=\""
+			.(!isset($row[$field]) ? "" : htmlspecialchars($row[$field]))."\"$append />");
+}
+
+function formconvert($id,$name,$text,$readonly,$anchor,$hiddens=array())
+{
+	global $tb_tree,$row,$winclose;
+	$readonly=(!$readonly ? "" : " readonly=\"readonly\"");
+	if ($winclose)
+		$text.=" (closes window)";
+	$row=db_array("select name,PublAuthor,Publication,html from $tb_tree"
+			." where id=\"".mysql_escape_string($id)."\"");
+	$hiddens["id"]=$id;
+	print("<!-- ID=$id -->"
+			."<form action=\"index.php$anchor\" method=\"POST\">\n"
+			."<table border=\"0\" width=\"100%\"><tr><td align=\"center\"><table border=\"0\"><tr><td>\n"
+			.fieldedit("name",50,$readonly)
+			."\n".fieldedit("PublAuthor",50,$readonly)
+			."<br />\n".fieldedit("Publication",100,$readonly)
+			."<br /><textarea name=\"html\" rows=\"20\" cols=\"80\">"
+					.(!isset($row["html"]) ? "" : htmlspecialchars($row["html"]))
+					."</textarea>\n"
+			."</td></tr></table><p>&nbsp;</p>\n"
+			."<input type=\"submit\" name=\"".htmlspecialchars($name)."\" value=\"".htmlspecialchars($text)."\" />\n"
+			.hiddens($hiddens,true/*doinputs*/)
+			."</td></tr></table></form>");
+	footer(true /* delimit */);
+}
+
+	if (isset($edit))
+		formconvert($id,"update","Update entry",false/*readonly*/,"#id_$id");
+	if (isset($confirm) && $confirming=="delete")
+		formconvert($id,$confirming,"Really delete entry?",true/*readonly*/,
+				"#family_".db_item("select family_id from $tb_tree where id=\"".mysql_escape_string($id)."\""));
+	if (isset($confirm) && $confirming=="isolate")
+		formconvert($id,$confirming,"Really isolate entry?",true/*readonly*/,"#id_$id");
+
+	$reset_from_script="this.form.elements['limit_from'].value=0;";
+	print('<form action="index.php" method="GET">'."\n"
+			.'<h1 align="center">'
+			.'<input type="text" name="find" size="40" '
+					.(!isset($find)?"":" value=\"".htmlspecialchars($find)."\"")
+					." onkeyup=\"$reset_from_script\" onchange=\"$reset_from_script\" onfocus=\"$reset_from_script\""
+					.' />'."\n"
+			.'&nbsp;<input type="submit" value="Search" />'."\n"
+			.'</h1><h2 align="center">'."\n"
+			.'First Group: <input type="text" name="limit_from" size="6" value="'.$limit_from.'" />'."\n"
+			.'&nbsp;&nbsp;&nbsp;'
+			.'Max Groups: '.'<input type="text" name="limit_max"  size="6" value="'.$limit_max .'" />'."\n"
+			.'</h2></form>'."\n");
+	if (!isset($find))
+		footer(true /* delimit */);
+	
+	print("<hr />\n");
+
+function fieldquote($prefix,$field,$suffix="")
+{
+	global $row,$fieldquote_tot;
 	if (!isset($row[$field]))
-		return "";
-	return $prefix."<span class=\"$class\">".htmlspecialchars($row[$field])."</span>";
+		return("");
+	return($prefix."<span class=\"$field\">".htmlspecialchars($row[$field])."</span>".$suffix);
+}
+
+function formbutton($name,$text,$method="GET",$hidden=array(),$newwin=false,$anchor="")
+{
+	$r="";
+	if ($newwin) {
+		$r.="<table border=\"0\"><tr><td>".formbutton($name,$text,$method,$hidden,false/*newwin*/)."</td><td>";
+		$hidden["winclose"]=1;
+		}
+	$r.=""
+			."<form action=\"index.php".($anchor=="" ? "" : "#$anchor")."\" method=\"$method\""
+					.(!$newwin ? "" : " target=\"_blank\"").">"
+			."<input type=\"submit\" "
+					.($name=="" ? "" : " name=\"".htmlspecialchars($name)."\"")
+					." value=\"".htmlspecialchars($newwin ? "(in window)" : $text)."\" />"
+			.hiddens($hidden,true/*doinputs*/)
+			."</form>";
+
+	if ($newwin)
+		$r.="</td></tr></table>";
+	return($r);
 }
 
-	$family_num=0;
+	$families=db_query("select distinct family_id from $tb_tree"
+			." where name like \"".mysql_escape_string($find)."%\""
+			." order by name limit $limit_from,".($limit_max+1));
+
+	$arrows="<table border=\"0\" width=\"100%\"><tr><td align=\"center\">\n"
+			."<table border=\"0\" width=\"80%\"><tr><td align=\"left\">";
+	if ($limit_from>0)
+		$arrows.=formbutton("","Previous","GET",array("limit_from"=>max(0,$limit_from-$limit_max)));
+	$arrows.="</td><td align=\"right\">";
+	if (mysql_num_rows($families)>$limit_max)
+		$arrows.=formbutton("","Next","GET",array("limit_from"=>$limit_from+$limit_max));
+	$arrows.="</td></tr></table></td></tr></table>";
+
+	print "$arrows<hr />\n";
+	$family_tot=0;
 	while (($family_row=mysql_fetch_array($families))) {
-		if ($family_num)
+		if ($family_tot)
 			print "<hr />\n";
 		$family_id=$family_row["family_id"];
-		$result=db_query("select id,name,Publication,Notes,html from $tb_tree"
+		print("<table border=\"0\" width=\"90%\"><tr><td align=\"right\"><a name=\"family_$family_id\">"
+				."<form action=\"index.php#family_$family_id\" method=\"POST\">" // WARNING: <form> will break the line!
+				."Group&nbsp;#&nbsp;<input type=\"text\" size=\"10\" readonly=\"readonly\" value=\"$family_id\" />"
+				."<br /><br />"
+						."Join to this group: <input type=\"text\" name=\"move_src\" size=\"21\" value=\"\" />"
+						."&nbsp;<input type=\"submit\" name=\"move\" value=\"Join\" />\n"
+						.hiddens(array("move_dst"=>$family_id),true/*doinputs*/)
+						."</form>\n"
+				."</td></tr></table>\n");
+		$result=db_query("select id,family_order,name,PublAuthor,Publication,html from $tb_tree"
 				." where family_id=\"$family_id\""
-				." order by family_id,family_order");
+				." order by family_order");
 		$order=0;
 		while (($row=mysql_fetch_array($result))) {
-			if ($order==0)
-				print "<p>";
-			elseif ($order==1)
-				print "<ul>";
 			if ($order>=1)
-				print "<li>";
+				print "<blockquote>";
 
-			print(fieldquote("","name","name")
-					.fieldquote("\n","Publ. Author","author")
-					.fieldquote("<br />\n","Publication","publication")
-					.fieldquote("<br />\n","Notes","notes")
-					);
+			print("<a name=\"id_".$row["id"]."\"><!-- family_order=".$row["family_order"]." --><table border=\"0\" width=\"90%\">");
+
+			print("<tr><td align=\"left\" valign=\"center\"><table border=\"0\"><tr>");
+			if ($order>=1) {
+				print "<td>&bull;</td>";
+				$tabpfx="<td></td>";
+				}
+			else
+				$tabpfx="";
+			print("<td>".fieldquote("","name","\n")
+					.fieldquote("","PublAuthor")."</td></tr>");
+			print(fieldquote("<tr>$tabpfx<td>","Publication","</td></tr>"));
 			if (isset($row["html"])) {
 				$import="import: [".$row["id"]."]";
-				$html=eregi_replace("< */? *a( [^>]*)?>","",$row["html"]);
-				print("<br />\n<blockquote><!-- BEGIN $import -->\n".$html."\n<!-- END $import --></blockquote>");
+				$html=$row["html"];
+				$html=eregi_replace("< *"."/? *a( [^>]*)?>","",$html);
+				print("<tr>$tabpfx<td><blockquote><!-- BEGIN $import -->\n".$html."\n<!-- END $import --></blockquote></td></tr>");
 				}
-			print("\n");
+			print("</table></td><td align=\"right\" valign=\"center\"><table border=\"0\">");
+			$l="<tr><td align=\"center\">";
+			$r="</td></tr>";
+			print(""
+					.($order <= 0 ? "" :
+							$l.formbutton("reorder","^^^ up ^^^","POST",
+									array("id"=>$row["id"],"reorder_by"=>-1),false/*newwin*/,"family_$family_id").$r)
+					.$l.formbutton("confirm","Delete entry","GET",
+							array("id"=>$row["id"],"confirming"=>"delete"),true/*newwin*/).$r
+					.$l.formbutton("edit"   ,"Edit entry"  ,"GET",
+							array("id"=>$row["id"]),true/*newwin*/).$r
+					.(mysql_num_rows($result)<=1 ? "" :
+							$l.formbutton("confirm","Isolate entry","GET",
+									array("id"=>$row["id"],"confirming"=>"isolate"),true/*newwin*/).$r)
+					.($order+1 >= mysql_num_rows($result) ? "" :
+							$l.formbutton("reorder","vvv down vvv"  ,"POST",
+									array("id"=>$row["id"],"reorder_by"=>+1),false/*newwin*/,"family_$family_id").$r)
+					."</table></td></tr></table></a>\n"
+					);
 
-			if ($order==0)
-				print "</p>";
-			else
-				print "</li>";
+			if ($order>=1)
+				print "</blockquote>";
 			print "\n";
 			$order++;
 			}
+		mysql_free_result($result);
 		if ($order>=2)
 			print "</ul>\n";
-		$family_num++;
+		print "</a>\n"; // <a name="family_X"
+		$family_tot++;
+		if ($family_tot >= $limit_max)
+			break;
 		}
-	mysql_free_result($result);
+	mysql_free_result($families);
+	print "<hr />$arrows\n";
 
 	footer(false /* delimit */);
 ?>