[Refdb-cvs] CVS: refdb/phpweb refdbsearch.php.in,NONE,1.1.2.1

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/refdb/refdb/phpweb
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31614

Added Files:
      Tag: Release_0_9_5_stable
	refdbsearch.php.in 
Log Message:
replaces refdbsearch.php

--- NEW FILE ---
<?
require_once("include.php");

//This function builds the string for the display fields option
//It uses the morefields array to associate the html value with 
//the refdbc identified value
function setSearchFields($_POST, $morefields)
{
	$searchFields = "";
	while( list($key,$val) = each($morefields))
	{
		if(isset($_POST[$key]) )
		{
			$searchFields .= $val;
		}
	}
	if( $searchFields == "" )
	{
		$searchFields = "ALL";
	}
	return $searchFields;
}
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
  <head>
    <title>RefDB query results</title>
    <link href="refdbq.css" type="text/css" rel="stylesheet">
  </head>
  <body>
    <table width="100%" cellspacing="0" border>

      <tbody valign="top">
	<tr>
	  <td class="navbar" width="25%"><h1>RefDB</h1></td>
	  <td class="main"><h1>Query Results</h1></td>
	</tr>
	<tr>
	  <td class="navbar">&nbsp;</td>
	  <td class="main">&nbsp;</td>

	</tr>
	<tr>
	  <td class="navbar">
	    <p><a href="refdbquery.html">Search references</a></p>
	    <p><a href="refdbkajquery.html">Search keywords, authors, journals</a></p>
	    <p><a href="refdbadd.html">Add new references</a></p>
	    <p><a href="refdbdbquery.php">Change database</a></p>
	    <p><a href="refdblogout.php">Logout</a></p>
	  </td>
	  <td class="main">
	      <table border>


<thead><tr><th class="result">Matching References</th></tr>
<tr><td class="result">

 <form action="refdb-prl-del.php" method="post" enctype="multipart/form-data"> 
	<input type="submit" value="Delete selected references" name="deleteref">&nbsp;
	<input type="submit" value="Add selected references to Personal List" name="pickref">&nbsp;
	<input type="submit" value="Remove selected references from Personal List" name="unpickref"></td></tr></thead><tbody>
<?
$database = $_SESSION["database"];
$name = $_SESSION["name"];
$passwd = $_SESSION["passwd"];
$refdbc = $_SESSION["refdbc"];

$cmd = "$refdbc -c stdout -d $database -u $name -w $passwd -F ";

$searchFields = setSearchFields($_POST, $morefields);

$cmd = $cmd.$searchFields." -C getref ";

//Search just the personal reference list
if($scope == "prl")
{
	$cmd = $cmd."-p ";
}

$terms = "";

//The following if sets the query for the Simple Query
//It builds the refdbc query using the fields and ops  arrays
//from include.php 
if( $sendQuery == "Send Simple query")
{
	$first = true;
	if( $simpquery1 != ""  )
	{
		$field1 = $fields[$simpquery1field];
		$equals1 = $equals[$simpquery1equals];
		$terms = $terms.$field1.$equals1.$simpquery1." ";
		$first = false;
	}
	if( $simpquery2 != ""  )
	{
		$field2 = $fields[$simpquery2field];
		$equals2 = $equals[$simpquery2equals];
		if( $first)
		{
			$terms = $terms.$field2.$equals2.$simpquery2." ";
			$first = false;
		}
		else
		{
			$op1 = $ops[$simpquery1op];
			$terms = $terms.$op1." ".$field2.$equals2.$simpquery2." ";
		}
	}
	if( $simpquery3 != ""  )
	{
		$field3 = $fields[$simpquery3field];
		$equals3 = $equals[$simpquery3equals];
		if( $first)
		{
			$terms = $terms.$field3.$equals3.$simpquery3." ";
			$first = false;
		}
		else
		{
			$op2 = $ops[$simpquery2op];
			$terms = $terms.$op2." ".$field3.$equals3.$simpquery3." ";
		}
	}
	if( $simpquery4 != "" )
	{
		$field4 = $fields[$simpquery4field];
		$equals4 = $equals[$simpquery4equals];
		if( $first)
		{
			$terms = $terms.$field4.$equals4.$simpquery4." ";
			$first = false;
		}
		else
		{
			$op3 = $ops[$simpquery3op];
			$terms = $terms.$op3." ".$field4.$equals4.$simpquery4." ";
		}
	}
}
//Build the advance query
else if( $sendQuery == "Send Advanced query" )
{
	$terms = $advquery;
}
//Query terms if you've returned from a search
else if( $sendQuery == "Return to Search Results" )
{
	$terms = $return;
}

$cmd = $cmd.$terms;

exec($cmd, $lines);

?><tr><td><div><?
$checkboxNumber = 0;

//If the search generates no results
if( count($lines) <=1 )
{
	print "<br>Your Search for <b>$terms</b> generated no results<br><br>\n";
}
//Your search generated results display them
else
{
  $lineNumber = 1;
  foreach( $lines as $line )
  {
  	//If this is the first line of a new reference it will contain the ID field
	if( substr($line,0,2) == "ID" )
	{
		$lineNumber = 1;
		print "</div></td></tr>\n";
		print "<tr><td class='result'>\n";
		
		//strip the ID number out of the reference
		$colon = strpos($line, ':');
		$space = strpos($line, " ");
		$id = substr($line,$colon+1,$space-$colon-1);
		
		++$checkboxNumber;
		print "<input type='checkbox' name='checkbox$checkboxNumber' value='$id'>&nbsp;\n";
		print "<input type='submit' value='Edit' name='editid$id'>\n";
		print "<div class='record'>\n";
		print "<h2 class='ID'>$line</h2>\n";
		$lineNumber++;
	}
	elseif( substr($line,0,3) == "Key" )
	{
		print "<p class='citekey'>$line</p>\n";
		$lineNumber++;
	}
	elseif($lineNumber == 3)
	{
		print "<p class='authors'>Authors: $line</p>\n";
		$lineNumber++;
	}
	elseif($lineNumber == 4)
	{
		print "<p class='title'>$line</p>\n";
		$lineNumber++;
	}
	elseif($lineNumber == 5)
	{
		print "<p><em class='periodical'>$line</em></p>\n";
		$lineNumber++;
	}
	elseif( substr($line,0,8) == "ABSTRACT")
	{
		print "<p class='abstract'>$line</p>\n";
	}
	elseif( substr($line,0,7) == "REPRINT" )
	{
		print "<p class='reprint'>$line</p>\n";
	}
	elseif( substr($line,0,4) == "ISSN")
	{
		print "<p class='issn'>$line</p>\n";
	}
	elseif( substr($line,0,4) == "CITY")
	{
		print "<p class='city'>$line</p>\n";
	}
	elseif( substr($line,0,5) == "NOTES" )
	{
		print "<p class='notes'>$line</p>\n";
	}
	elseif( substr($line,0,3) == "URL" )
	{
		$len = strlen($line);
		$url = substr($line, 4,$len);
		print "<p class='url'><a href='$url'>$line</a></p>\n";
	}
	elseif( substr($line,0,9) == "PUBLISHER")
	{
		print "<p class='publisher'>$line</p>\n";
	}
	else
	{
		print "<p>$line</p>\n";
	}
  }
}
print "<input type='hidden' name='terms' value='$terms'>\n";
print "<input type='hidden' name='scope' value='$scope'>\n";
print "<input type='hidden' name='numberOfCheckBoxes' value='$checkboxNumber'>\n";
?>
</tbody>
</table>
</form>
</td>
</tr>
<tr>
	<td class="navbar"><p><a href="refdbadmin.php">Admin Interface</a></p></td>
	<td class="footer"><p><a href="http://refdb.sourceforge.net">RefDB</a> reference manager and bibliography tool V. <!--VERSION-->Version<!--/VERSION--></p></td>
</tr>
</tbody>
</table>
</body>

</html>