transaction.class.php

开源MARC数据处理

			$recordSet = $dbconn->Execute($sql);
			return '<b>Material lined up For Renewal!</b>';
			}
		elseif($q=="appre")
			{
			$sql = "DELETE FROM $trans ";
			$sql .= " WHERE $trans_col[id]=$tid";
			$recordSet = $dbconn->Execute($sql);
			return '<b>Return Approved!</b>';
			}
		elseif($q=="delre")
			{
			$sql = "UPDATE $trans ";
			$sql .= " set $trans_col[status]=2";
			$sql .= " WHERE $trans_col[id]=$tid";
			$recordSet = $dbconn->Execute($sql);
			return '<b>Return Denied!</b>';
			}
		elseif($q=="apprenew")
			{
			list($userid,$holdingsid) = $this->SelectVarName($tid,array('userid','holdingsid'));
			$sql = "DELETE FROM $trans ";
			$sql .= " WHERE $trans_col[id]=$tid";
			$recordSet = $dbconn->Execute($sql);
			print $sql;
			$dSql = "SELECT NOW()";
			$drecordSet = $dbconn->Execute($dSql);
			$Fborrow = $drecordSet->fields[0];
			$rSql = "SELECT NOW() + INTERVAL '".$cut_off[1]." HOUR'";
			$rrecordSet = $dbconn->Execute($rSql);
			$Freturn = $rrecordSet->fields[0];
			$transid = $hid;
			$sql = "INSERT INTO  $trans ";
			$sql .= "($trans_col[id], $trans_col[holdingsid], $trans_col[userid], ";
			$sql .= "$trans_col[status], $trans_col[borrowdate], $trans_col[returndate]) ";
			$sql .= " VALUES ($holdingsid, $holdingsid, $userid,0,'$Fborrow','$Freturn')";
			print $sql;
			$recordSet = $dbconn->Execute($sql);
			$id = $dbconn->Insert_ID();
			$this->Update($id);
			return '<b>Renewal Approved!</b>';
			}
		elseif($q=="delrenew")
			{
			$sql = "UPDATE $trans ";
			$sql .= " set $trans_col[status]=2";
			$sql .= " WHERE $trans_col[id]=$tid";
			$recordSet = $dbconn->Execute($sql);
			return '<b>Renewal Denied!</b>';
			}
		return '';
		}
	function ManageTransaction()
		{
		global $user_type;
		global $book_type;
		global $book_status;
		global $select_status;
		global $q;
		if($q=="mya") 
			{
			$div = "usr";
			$acc = "pub";
			$q = "mya";
			}
		else
			{
			$div = "tra";
			$acc = "priv";
			$q = "man";
			}
		if(strlen($select_status)==0) $select_status = 0;
		$uid = $this->pol->SessionGetVar('uid');
		$table = $this->tbl;
		list($dbconn) = $this->dbc;
		$trans = $table['transaction'];
		$trans_col = $table['transaction_column'];
		$ifstatus = '';
		$ifmya = '';
		if($q=="mya") $ifmya = " AND $trans_col[userid]=$uid";
		if($select_status || $select_status=='0') $ifstatus = " WHERE $trans_col[status]=$select_status";
		$sql = "SELECT ";
		$sql .= "$trans_col[id], $trans_col[holdingsid], $trans_col[userid], ";
		$sql .= "$trans_col[status], $trans_col[borrowdate], ";
		$sql .= "$trans_col[returndate],$trans_col[borrowdate] ";
		$sql .= "from $trans $ifstatus $ifmya";
		$recordSet = $dbconn->Execute($sql);
		$total =  $recordSet->RecordCount();
		$i=0;
		while(!$recordSet->EOF)
			{
			$id = $recordSet->fields[0];
			$holdingsid = $recordSet->fields[1];
			$userid = $recordSet->fields[2];
			$status = $recordSet->fields[3];
			$borrowdate = $recordSet->fields[4];
			$returndate = $recordSet->fields[5];
			$rawdate = $recordSet->fields[6];
			list($accessno,$holdingstype,$holdingsid) = $this->hld->SelectVarName($holdingsid, array("accessno","type","holdingsid"));
			list($usertype,$fname,$lname) = $this->usr->SelectVarName($userid, array('type','fname','lname'));
			$nodayscanborrow = $this->pml->NoOfDaysCanBorrow();
			$dateadd = "SELECT  timestamp '$rawdate' + INTERVAL '".$nodayscanborrow." DAY'";
			$dateSet = $dbconn->Execute($dateadd);
			$bibid = $holdingsid;
			$sessid = $this->pol->SecGenAuthKey();
			$tabletitle = "Manage Transaction";
			if($status=='0')
				{
				$approve  = "<a href=\"".$this->pol->GetModuleURL().$this->pol->Med()."div=tra&acc=priv&q=upd&tid=".$id."&bakto=".$bakto."&select_status=".$status."&sessid=".$sessid."\" onclick=\"return confirmLink(this, 'With Accession No. ".$accessno."','Approve this material')\">";
				$approve .= "Aprrove</a>";
				$deny  = "<a href=\"".$this->pol->GetModuleURL().$this->pol->Med()."div=tra&acc=priv&q=del&tid=".$id."&bakto=".$bakto."&select_status=".$status."&sessid=".$sessid."\" onclick=\"return confirmLink(this, 'With Accession No. ".$accessno."','Deny this material')\">";
				$deny .= "Deny</a>";
				$action = "$approve | $deny";
				}
			elseif($status=='2' || $status=='3' || $status=='4') 
				{
				$return  = "<a href=\"".$this->pol->GetModuleURL().$this->pol->Med()."div=tra&acc=priv&q=ret&tid=".$id."&bakto=".$bakto."&select_status=".$status."&sessid=".$sessid."\" onclick=\"return confirmLink(this, 'With Accession No. ".$accessno."','Return this material')\">";
				$return  .= "Return</a>";
				$renew  = "<a href=\"".$this->pol->GetModuleURL().$this->pol->Med()."div=tra&acc=priv&q=ren&tid=".$id."&bakto=".$bakto."&select_status=".$status."&sessid=".$sessid."\" onclick=\"return confirmLink(this, 'With Accession No. ".$accessno."','Renew this material')\">";
				$renew .= "Renew</a>";
				$action = "$return | $renew";
				}
			elseif($status=='5') 
				{
				$approve  = "<a href=\"".$this->pol->GetModuleURL().$this->pol->Med()."div=tra&acc=priv&q=appre&tid=".$id."&bakto=".$bakto."&select_status=".$status."&sessid=".$sessid."\" onclick=\"return confirmLink(this, 'With Accession No. ".$accessno."','Approve this material')\">";
				$approve .= "Aprrove</a>";
				$deny  = "<a href=\"".$this->pol->GetModuleURL().$this->pol->Med()."div=tra&acc=priv&q=delre&tid=".$id."&bakto=".$bakto."&select_status=".$status."&sessid=".$sessid."\" onclick=\"return confirmLink(this, 'With Accession No. ".$accessno."','Deny this material')\">";
				$deny .= "Deny</a>";
				$action = "$approve | $deny";
				}
			elseif($status=='6')
				{
				$approve  = "<a href=\"".$this->pol->GetModuleURL().$this->pol->Med()."div=tra&acc=priv&q=apprenew&tid=".$id."&uid=".$userid."&select_status=".$status."&bakto=".$bakto."&sessid=".$sessid."\" onclick=\"return confirmLink(this, 'With Accession No. ".$accessno."','Approve this material')\">";
				$approve .= "Aprrove</a>";
				$deny  = "<a href=\"".$this->pol->GetModuleURL().$this->pol->Med()."div=tra&acc=priv&q=delrenew&tid=".$id."&uid=".$userid."&select_status=".$status."&bakto=".$bakto."&sessid=".$sessid."\" onclick=\"return confirmLink(this, 'With Accession No. ".$accessno."','Deny this material')\">";
				$deny .= "Deny</a>";
				$action = "$approve | $deny";
				}
			$accessnos  = "<a href=\"".$this->pol->GetModuleURL().$this->pol->Med()."div=tra&acc=priv&q=man&ac=bib&bibid=".$bibid."&accno=".$accessno."&select_status=".$status."&bakto=".$bakto."&select_status=".$status."&sessid=".$sessid."\" >";
			$accessnos .= "$accessno</a>"; 
			$vcontents = "<a href=\"".$this->pol->GetModuleURL().$this->pol->Med()."div=tra&acc=priv&q=man&ac=usv&usvid=".$userid."&select_status=".$status."&bakto=".$bakto."&select_status=".$status."&sessid=".$sessid."\" >";
			$vcontents .= "$lname, $fname</a>";   
			if($q=="mya")
				{
				if($status=='0')
					{
					$action  = "<a href=\"".$this->pol->GetModuleURL().$this->pol->Med()."div=usr&acc=pub&q=mya&ac=canapp&tid=".$id."&bakto=".$bakto."&sessid=".$sessid."\" onclick=\"return confirmLink(this, 'With Accession No. ".$accessno."','Cancel this material')\">";
					$action .= "Cancel</a>"; 
					}
				elseif($status=='2' || $status=='3' || $status=='4') 
					{ 
					$return  = "<a href=\"".$this->pol->GetModuleURL().$this->pol->Med()."div=usr&acc=pub&q=mya&ac=ret&tid=".$id."&bakto=".$bakto."&sessid=".$sessid."\" onclick=\"return confirmLink(this, 'With Accession No. ".$accessno."','Return this material')\">";
					$return .= "Return</a>"; 
					$renew  = "<a href=\"".$this->pol->GetModuleURL().$this->pol->Med()."div=usr&acc=pub&q=mya&ac=ren&tid=".$id."&bakto=".$bakto."&sessid=".$sessid."\" onclick=\"return confirmLink(this, 'With Accession No. ".$accessno."','Renew this material')\">";
					$renew .= "Renew</a>"; 
					$action = "$return | $renew";
					}
				elseif($status=='5' || $status=='6') 
					{
					$action  = "<a href=\"".$this->pol->GetModuleURL().$this->pol->Med()."div=usr&acc=pub&q=mya&ac=canre&tid=".$id."&bakto=".$bakto."&sessid=".$sessid."\" onclick=\"return confirmLink(this, 'With Accession No. ".$accessno."','Cancel this material')\">";
					$action .= "Cancel</a>"; 
					}
				$tabletitle = "My Transaction";
				$accessnos  = "<a href=\"".$this->pol->GetModuleURL().$this->pol->Med()."div=usr&acc=pub&q=mya&ac=bib&bibid=".$bibid."&accno=".$accessno."&select_status=".$status."&bakto=".$bakto."&sessid=".$sessid."\" >";
				$accessnos .= "$accessno</a>";
				$vcontents = "$lname, $fname";
				}
			$accessno = $accessnos;
			$vcontent = $vcontents;
			$result[$i] = array("$vcontent",$accessno,$recordSet->fields[4],$dateSet->fields[0],"$action");
			$i++;
			$recordSet->MoveNext();
			}
		$color = $this->pol->SelectColor();
		$bgcolor1 = $color[1];
		$bgcolor2 = $color[2];
		$bgcolor3 = $color[3];
		$ca = $this->pol->GetBaseURL().'polerio/inc';
		$incl = "<script src=\"$ca/functions.js\" type=\"text/javascript\" language=\"javascript\"></script>";        
		$n=$select_status;
		$select_status = '<b>Select Transaction Status</b>&nbsp;&nbsp;<select name="select_status" onchange="this.form.submit();">';
		$select_status .='';
		for($i=0;$i<count($book_status);$i++)
			{
			if($i!=1)
				{
				if(($i)==$n) $selected="selected"; else $selected="";
				$select_status .= '<option value="'.($i).'" '.$selected.' >'.$book_status[($i)].'</option>'."\n";
				}
			}
		$select_status .='</select>&nbsp;&nbsp;';
		$getmoduleurl = $this->pol->GetModuleURL();
		$varStatic = "table1";
		$varDynamic = "loop";
		$template = polTemplate::LoadTemplate($this->pol->GetModuleURI().'templates/transmanage.html');
		$vars = array("pol::getmoduleurl","pol::js","pol::bgcolor1","pol::bgcolor2","pol::bgcolor3",
				"pol::tabletitle","pol::fpage","pol::prev",
				"pol::next","pol::lpage","pol::bottom",
				"pol::currentlabel","pol::brief","pol::showing",
				"pol::widthl","pol::widthr","pol::top","pol::selectstatus","pol::div","pol::acc","pol::q"
				);
		$vals = array("$getmoduleurl","$incl","$bgcolor1","$bgcolor2","$bgcolor3",
				"$tabletitle","$fpage","$prev",
				"$next","$lpage","$bottom",
				"$_current_label","$brief","$showing",
				"$widthl","$widthr","$top","$select_status","$div","$acc","$q"
				);
		$template = polTemplate::ReplaceStatic($template, $vars, $vals);
		$vars = array("pol::vdborrower","pol::vaccno","pol::vborrow","pol::vreturn","pol::vaction");
		$template = polTemplate::DynamicRows($template, $varStatic, $varDynamic, $vars, $result);
		$template = $template;
		return $template;
		}
	function GetBibID($holdingsid="")
		{
		list($dbconn) = $this->dbc;
		$table = $this->tbl;
		$bib = $table['tblbib'];
		$bib_col = $table['tblbib_column'];
		$sql  = "select $bib_col[id]";
		$sql .= " FROM $bib WHERE $bib_col[accessid]=$holdingsid";
		$recordSet = $dbconn->Execute($sql);
		$id = $recordSet->fields[0];
		return $id;
		}
	}
?>