phpmylibrary.class.php

开源MARC数据处理

<?php
/*

apr-04-2004
	[] pythoning

*/
Class Phpmylibrary
{
	var $offset="";
	function PhpMyLibrary()
		{
		$this->offset = "";
		}
	function HeaderOpen()
		{
		$Header = "<table border=\"1\" width=\"\" border cellspacing=\"0\"  bordercolordark=\"white\" bordercolorlight=\"black\">
		<tr bgcolor=\"$bgcolor2\" align=\"left\"><td align=\"left\"><b>&nbsp;Pi</b></td></tr>";
		}
	function Login()
		{
		$login ='
		<form action="'.Polerio::GetBaseURL().'user.php" method="post">
		<font class="pn-title"><b>User login</b></font><br>
		<table border="0"><tr><td>
		<font class="pn-normal"><b>Username: </b></font></td><td><input type="text" name="uname" size="21" maxlength="25"></td></tr>
		<tr><td><font class="pn-normal"><b>Password: </b></font></td><td><input type="password" name="pass" size="21" maxlength="20"></td></tr>
		<tr><td><font class="pn-normal">Remember me:</font></td><td><input type="checkbox" name="rememberme"></td></tr>
		</table>
		<input type="hidden" NAME="_a" value="3">
		<input type="submit" VALUE="Login">
		</form>
		<br />';
		return $login;
		}
	function print_menu()
		{
		global $PHP_SELF;
		global $SITE_URL;
		global $ADMIN_MODE;
		global $HOME_URL;
		global $HOUR;
		global $MINUTE;
		global $conf;
		$polerio_base_url = $conf['main']['polerio_base_url'];
		$phpmylibrary_url = $polerio_base_url."/phpmylibrary";
		$GetModuleURL = Polerio::GetModuleURL();
		$Med = Polerio::Med();
		$_import = $GetModuleURL;
		$_import .= $Med;
		$_import .= "_a=1";
		$_webpac = $GetModuleURL;
		$_cataloging = $GetModuleURL;
		$_cataloging .= $Med;
		$_cataloging .= "_a=2";
		if(Phpmylibrary::IsLoggedIn()!=1) 
			{
			$_login  = $GetModuleURL;
			$_login .= $Med;
			$_login .= "_a=3&_aa=2";
			$loginmsg = "Log-in";
			} else {
			$_login  = $GetModuleURL;
			$_login .= $Med;
			$_login .= "_a=3&_aa=1";
			$loginmsg = "Log-out";
			}
		$bcolor1 = $conf['table']['bcolor1']; 
		$bcolor2 = $conf['table']['bcolor2'];
		$bcolor3 = $conf['table']['bcolor3'];
		$year = date("y");
		$mon = date("m");
		$day = date("D");
		$hour = date("h");
		$min = date("i");
		$orgdate = date("l F dS, Y h:i A",gmmktime($hour+8,$min+10,$sec,$mon,$day,$year));
		$orgdate = date("M d y h:i a",gmmktime($hour+$HOUR,$min+$MINUTE));
		print"
		<table><tr><td nowrap>
		<font face=\"Verdana\" size=\"2\" color=\"#00FF00\">
		&nbsp;&nbsp;&nbsp;<a STYLE=\"color:#FFFFFF;text-decoration:none;\" href=\"$_webpac\"><FONT COLOR=\"#00FF00\" ONMOUSEOVER=\"this.style.color='#FF0000';\" ONMOUSEOUT=\"this.style.color='#00FF00';\">PhpMyLibrary 1.0.4b</FONT></A>
		<ul>
		<li><a STYLE=\"color:#FFFFFF;text-decoration:none;\" href=\"$_webpac\"><FONT COLOR=\"#00FF00\" ONMOUSEOVER=\"this.style.color='#FF0000';\" ONMOUSEOUT=\"this.style.color='#00FF00';\">WebPAC</FONT></A>";
		if(Phpmylibrary::IsLoggedIn()==1) print"<li><a STYLE=\"color:#FFFFFF;text-decoration:none;\" href=\"$_import\"><FONT COLOR=\"#00FF00\" ONMOUSEOVER=\"this.style.color='#FF0000';\" ONMOUSEOUT=\"this.style.color='#00FF00';\">Import MARC</FONT></A>";
		if(Phpmylibrary::IsLoggedIn()==1) print"<li><a STYLE=\"color:#FFFFFF;text-decoration:none;\" href=\"$_cataloging\"><FONT COLOR=\"#00FF00\" ONMOUSEOVER=\"this.style.color='#FF0000';\" ONMOUSEOUT=\"this.style.color='#00FF00';\">Cataloging</FONT></A>";
		print"<li><a STYLE=\"color:#FFFFFF;text-decoration:none;\" href=\"$_login\"><FONT COLOR=\"#00FF00\" ONMOUSEOVER=\"this.style.color='#FF0000';\" ONMOUSEOUT=\"this.style.color='#00FF00';\">$loginmsg</FONT></A>
		</ul>
		</font>
		</td></tr></table> 
		";
		return;
		}
	function print_query($file="")
		{
		global $pmlconfig;
		if($pmlconfig['PnThOver']!=0) 
			{
			$pmlbgcolor3 = $pmlconfig['bgcolor3'];
			$pmlbgcolor2 = $pmlconfig['bgcolor2'];
			$pmlbgcolor1 = $pmlconfig['bgcolor1'];
			}
		else 
			{
			global $bgcolor1,$bgcolor2,$bgcolor3;
			$pmlbgcolor3 = $bgcolor3;
			$pmlbgcolor2 = $bgcolor2;
			$pmlbgcolor1 = $bgcolor1;
			}
		$getmoduleurl = Polerio::GetModuleURL();
		$pmlsearchquery = _PMLSEARCHQUERY;
		$pmlany = _PMLANY;
		$pmlauthor = _PMLAUTHOR;
		$pmltitle = _PMLTITLE;
		$pmlsubject = _PMLSUBJECT;
		$pmlpublisher = _PMLPUBLISHER;
		$pmlnotes = _PMLNOTES;
		$pmlsearch = _PMLSEARCH;
		$pmlsearchfor = _PMLSEARCHFOR;
		$pmlclearsearch = _PMLCLEARSEARCH;
		$pmlmediatype = _PMLMEDIATYPE;
		$pmlbooks = _PMLBOOKS;
		$pmlserials = _PMLSERIALS;
		$pmlmaps = _PMLMAPS;
		$pmlmusic = _PMLMUSIC;
		$pmlvisualmaterial = _PMLVISUALMATERIAL;
		$pmlcomputerfiles = _PMLCOMPUTERFILES;
		$pmlmixedmaterial = _PMLMIXEDMATERIAL;
		$pmlthesis = _PMLTHESIS;
		$pmllogical = _PMLLOGICAL;
		$pmland = _PMLAND;
		$pmlor = _PMLOR;
		$pmlnot = _PMLNOT;
		$pmllimit = _PMLLIMIT;
		$authid = Polerio::SecGenAuthKey();
		$template = polTemplate::LoadTemplate(Polerio::GetModuleURI().'templates/search.html');
		$vars = array(	"pol::getmoduleurl","pol::pmlsearchquery","pol::pmlany","pol::pmlauthor",
				"pol::pmltitle","pol::pmlsubject","pol::pmlpublisher","pol::pmlnotes",
				"pol::pmlsearch","pol::pmlsearchfor","pol::pmlsearchfor","pol::pmlclearsearch",
				"pol::pmlbooks","pol::pmlserials","pol::pmlmaps","pol::pmlmusic", 
				"pol::pmlvisualmaterial","pol::pmlcomputerfiles","pol::pmlmixedmaterial","pol::pmlthesis",
				"pol::pmlmediatype","pol::pmllogical","pol::pmland","pol::pmlor","pol::pmlnot","pol::pmllimit",
				"pol::pmlbgcolor1","pol::pmlbgcolor2","pol::pmlbgcolor3","pol::authid"
				);
		$vals = array("	$getmoduleurl","$pmlsearchquery","$pmlany","$pmlauthor",
				"$pmltitle","$pmlsubject","$pmlpublisher","$pmlnotes",
				"$pmlsearch","$pmlsearchfor","$pmlsearchfor","$pmlclearsearch",
				"$pmlbooks","$pmlserials","$pmlmaps","$pmlmusic", 
				"$pmlvisualmaterial","$pmlcomputerfiles ","$pmlmixedmaterial","$pmlthesis",
				"$pmlmediatype","$pmllogical","$pmland","$pmlor","$pmlnot","$pmllimit",
				"$pmlbgcolor1","$pmlbgcolor2","$pmlbgcolor3","$authid"
				);
		$template = polTemplate::ReplaceStatic($template, $vars, $vals);
		return $template;
		}
	function Marc($selected_tbl="")
		{
		$table = Polerio::DBGetTables();
		list($dbconn) = Polerio::DBGetConn();
		$tblbib = $table['tblbib'];
		$tblbib_col = $table['tblbib_column'];
		$i=0;
		$zipmarc = "";
		while($i <= (count($selected_tbl)-1))
			{
			$query = "SELECT * FROM $tblbib WHERE $tblbib_col[id]=$selected_tbl[$i]";
			$recordSet = $dbconn->Execute($query);
			$row = $recordSet->fields;
			$zipmarc .= $row[1].chr(29);
			$i++;
			}
		return $zipmarc;
		}
	function View($selected_tbl="")
		{
		$table = Polerio::DBGetTables();
		list($dbconn) = Polerio::DBGetConn();
		$tblbib = $table['tblbib'];
		$tblbib_col = $table['tblbib_column'];
		include_once Polerio::GetModuleURI().'/lib/marcdefs.php';
		$total = count($selected_tbl);
		$j=0;
		$viewmarc = "";
		$row = array();	
		while($j <= (count($selected_tbl)-1))
			{
			$query = "SELECT * FROM $tblbib WHERE $tblbib_col[id]=$selected_tbl[$j]";
			$recordSet = $dbconn->Execute($query);
			list($id, $content, $catid, $approved  ) = $recordSet->fields;
			$marc_field_explode = explode(chr(30),$content);
			$marc_field_explode_count = count($marc_field_explode);
			$i = 1;
			$tags_i = 1;
			$marc_fields_count = ((strlen($marc_field_explode[0])-24)/12);
			$rj = 0;
			$_j = 0;
			while ( $i <= $marc_fields_count)
				{
				$tags = substr($marc_field_explode[0],23,strlen($marc_field_explode[0]));
				$tags = substr($tags,$tags_i,3);
				$tag_value = $marc_field_explode[$i];
				$tag_value = ereg_replace(31,"$",$tag_value);
				$tags_i = $tags_i + 12;
				$ktag[$rj] = $tags;
				$tag_names[$i] = @$tag_name[$ktag[$rj]];
				$tag_content[$i] = Phpmylibrary::convertit($tag_value);
				$tag_name_marc[$i] = $tags;
				$tag_content_marc[$i] = $tag_value;
				$i++;
				}
			$_j = $_j+1;
			$viewmarc .= ""._PMLRECORDNO.". $_j "._PMLOF." $total<br>";
			$viewmarc .= '<table border=1 width=100% cellspacing=0  bordercolordark=white bordercolorlight=black>';
			$total_fields = count($tag_names);
			$i=1;
			while($i <= $total_fields)
				{
				$bcolor = "ffffff";
				if($tag_names[$i]) $viewmarc .= "<tr align=\"right\" valign=\"top\"><td width=\"20%\" valign=\"top\" align=\"right\" bgcolor=\"$bcolor\"><b><b>$tag_names[$i]&nbsp;&nbsp;</b></b></td><td align=\"left\" bgcolor=\"$bcolor\" width=\"80%\" valign=\"top\" >&nbsp;&nbsp;$tag_content[$i]</td></tr>";
				$i++;
				}
			$viewmarc .= "</td></tr></table><br><br>";
			$j++;
			}
		return $viewmarc;
		}
	function Viewnohtml($selected_tbl="")
		{
		$table = Polerio::DBGetTables();
		$tblbib = $table['tblbib'];
		$tblbib_col = $table['tblbib_column'];
		include_once Polerio::GetModuleURI().'/lib/marcdefs.php';
		list($dbconn) = Polerio::DBGetConn();
		$total = count($selected_tbl);
		$j=0;
		$viewmarc .= "\r\n";
		$viewmarc .= "PhpMyLibrary http://phpmylibrary.sourceforge.net\r\n"; 
		$viewmarc .= "Copyleft 2004 PhpMyLibrary GNU/GPL License\r\n"; 
		$viewmarc .= "\r\n";
		$viewmarc .= "--------------------------------------";
		$viewmarc .= "--------------------------------------";
		$viewmarc .= "\r\n";
		$viewmarc .= "\r\n";
		while($j <= (count($selected_tbl)-1))
			{
			$query = "SELECT * FROM $tblbib WHERE $tblbib_col[id]=$selected_tbl[$j]";
			$recordSet = $dbconn->Execute($query);
			$row = $recordSet->fields;
			$id = $row[0];
			$content = $row[1];
			$catid = $row[2];
			$approved = $row[3];
			$marc_field_explode = explode(chr(30),$content);
			$marc_field_explode_count = count($marc_field_explode);