adminfun.inc

图书管理系统

		$result=mysql_query($sql);
		if($myrow=mysql_fetch_row($result))
		{
			echo "<script language=javascript>alert('此图书编号已经使用，请重修改图书信息!');history.go(-1)</script>";
			exit;
			}	

		$query = "update $book set bookid='$tbookid',bookname='$tbookname',author='$tauthor',publish='$tpublish',"
				."pdate='$tpdate',price='$tprice',amount='$tamount',state='$tstate',memo='$tmemo' where id='$tid'";	
		
		$result = mysql_query($query)
			or die("修改出现错误: " . mysql_error());
		$num = mysql_affected_rows();
 		if ($num>0)
    		{
       		echo "修改图书成功！<hr><p>";
       		echo "新修改的图书是：".$tbookname."<p>";
	   		echo "<br><a href='allbook.php'>继续修改</a>";
		 }
		else
		{
	    	echo "修改图书失败！<hr><p>";
         	echo "图书：[".$tbookname."]"; 
         	echo "修改失败！";
		 	echo "<br><a href='allbook.php'>重新修改</a>";
		}
	}

	//删除图书
	function delbook($tid,$tbookname,$book)
	{
		$query = "DELETE FROM $book WHERE id = '$tid'";
		//处理中文乱码
		//mysql_query("set names gb2312");
		$result = mysql_query($query);
		$num = mysql_affected_rows();
		//判断是否删除成功
		if($num>0)
		{
			   echo "图书删除成功！<hr><p>";
			   echo "删除的图书是：".$tbookname."<p>";
			   echo "<br>返回<a href='allbook.php'>进行其他操作</a>";
		 }
		 else
		 {
				 echo "图书删除失败！<hr><p>";
				 echo "当前图书不存在！"; 
				 echo "<br><a href='allbook.php'>进行其他操作！</a>";
		 }	
	}
	
     	//执行借阅操作
	function addloan($tuserid,$tbookid,$tloandate,$tstate,$tmemo,$loan)
	{
		
		if(($tuserid=="") or ($tbookid=="") or ($tloandate=="") or ($tstate=="") )
		{
			echo "<script language=javascript>alert('带＊号的选项必须填写全！');history.go(-1)</script>";
			exit;
		}
		if (!ereg("^[0-9-]",$tloandate))
		{
			echo "<script language=javascript>alert('借阅日期只能用数字，中间加下画线表示');history.go(-1)</script>";
			exit;
		}

		if (!ereg("^[0-9]",$tstate))
		{
			echo "<script language=javascript>alert('当前图书数量只能是数字');history.go(-1)</script>";
			exit;
		}

		$query = "INSERT INTO $loan(userid,bookid,loandate,state,memo)"
			."VALUES('$tuserid','$tbookid','$tloandate','$tstate','$tmemo')";
			
		
		$result = mysql_query($query)
			or die("插入出现错误: " . mysql_error());
		$rowid = mysql_insert_id();
 		if ($rowid>0)
    	{
       		$query2 = "update book set state=amount-$tstate where bookid='$tbookid'";
			mysql_query($query2 )
				or die("更新出现错误: " . mysql_error());
			
			echo "用户[".$tuserid."]借阅成功！<hr><p>";
       		echo "借阅的图书是：".$tbookid."<p>";
	   		echo "<br><a href='loan.php'>继续借书</a>";
		 }
		else
		{
	    	 echo "用户[".$tuserid."]借阅失败！<hr><p>";
         	echo "图书：[".$tbookid."]"; 
         	echo "借阅失败！";
			echo "<br><a href='loan.php'>重新借阅</a>";
		}
	}
	
	//管理进行还书操作
	function gbbook($tuserid,$tbookid,$tgivebackdate,$tstate,$tmemo,$loan)
	{
		$rdm = "";
		$query1 = "";
		$query = "select * from $loan where userid='$tuserid' and bookid='$tbookid'";
		$result = mysql_query($query);
		$num = mysql_num_rows($result);
		if($num>0)
		{
			$row = mysql_fetch_array($result);
			$id = $row['id'];
			$userid = $row['userid'];
			$bookid = $row['bookid'];
			$loandate = $row['loandate'];
			$state = $row['state'];
			$memo = $row['memo'];
			
			if(($givebackdate - $loandate) > $rdate)
			{
				$nday = $givebackdate - $loandate;
				$rdm = $nday * rmenory;
			}
			
			if($tstate == $state)
			{
				$query1 = "delete from $loan where userid='$tuserid' and bookid='$tbookid'";
			}
			elseif($state > $tstate)
			{
				$query1 = "update $loan set state=state-$tstate where userid='$tuserid' and bookid='$tbookid'";
			}
			else
			{
				echo "归还图书数量有误，请修改！";
				echo "<br><a href='giveback.php'>返回修改</a>";
			}
			
			$result = mysql_query($query1)
				or die("删除、更新出现错误: " . mysql_error());
			$rowid = mysql_affected_rows();
			if ($rowid>0)
			{
				
				$query2 = "update book set state=state+$tstate where bookid='$tbookid'";
				mysql_query($query2 )
				
				or die("更新出现错误: " . mysql_error());
				echo "用户[".$userid."]还书成功！<hr><p>";
				echo "归还的图书是：".$tbookid;
				echo "[数量：".$tstate."]<p>";
				echo "[超期罚款：".$rdm."元]<p>";
				echo "<br><a href='giveback.php'>继续还书</a>";
			 }
			else
			{
				 echo "用户[".$userid."]还书失败！<hr><p>";
				echo "图书：[".$tbookid."]"; 
				echo "归还失败！";
			echo "<br><a href='giveback.php'>重新归还</a>";
			}
		}
		else
		{
			echo "没有找到相就的记录!";
		}
	}
	
	//管理员查看所有用户的借阅信息
	function alluserloan()
	{
		echo "<div id='main'>";
		echo "<div class='hr'><hr /></div>";
		echo "<div id='example'>";
		
		require "conn.php";
		// 获取当前页数
		if( isset($_GET['page']) )
		{
		   $page = intval( $_GET['page'] );
		}
		else
		{
		   $page = 1;
		} 
		// 每页数量
		$page_size = $psize; 
		// 获取总数据量
		$sql = "select count(*)  from $loan order by id ";
		$result = mysql_query($sql);
		$row = mysql_fetch_row($result);
		$amount = $row[0]; 
		//echo $amount;
		// 记算总共有多少页
		if($amount)
		{
		   if( $amount < $page_size )
		   { 
			//如果总数据量小于$pagesize，那么只有一页
			$page_count = 1;
		   }
		   //取总数据量除以每页数的余数               
		   if( $amount % $page_size )
		   {                                  
			   //如果有余数，则页数等于总数据量除以每页数的结果取整再加一
			   $page_count = (int)($amount / $page_size) + 1;           
			}
			else
		   {
			   //如果没有余数，则页数等于总数据量除以每页数的结果
			   $page_count = $amount / $page_size;                      
		   }
		}
		else
		{
		   $page_count = 0;
		}
		
					echo "<h2>所 有 用 户 借 阅 信 息</h2>";
					echo "<blockquote>";
					echo "<p>这里将列出所有用户的借阅信息。</p>";
					echo "</blockquote>";
		
					echo "<fieldset>";
					echo "<ul>";
					echo "<li>";
					echo "<label for='lbookid'>用户ID-></label>";
					echo "<label for='lbookid'>图书编号-></label>";
					echo "<label for='lbookid'>借阅日期-></label>";
					echo "<label for='lbookid'>归返日期-></label>";
					echo "<label for='lbookid'>借阅数量-></label>";
					echo "<label for='lbookid'>备注信息</label>";
					echo "</li>";
					echo "</ul>";
					echo "<ol>";
		
		// 获取数据，以二维数组格式返回结果
		if( $amount )
		{
		   $sql = "select * from $loan order by id  limit ". ($page-1)*$page_size .", $page_size";
		   $result = mysql_query($sql);
		   $num = mysql_num_rows($result);
		   //echo $num;
				for ($i=0;$i<$num;$i++)
				{
				 $row = mysql_fetch_array($result);
				 $id = $row['id'];
				 $userid = $row['userid'];
				 $bookid = $row['bookid'];
				 $loandate = $row['loandate'];
				 $givebackdate = $row['givebackdate'];
				 $state = $row['state'];
				 $memo = $row['memo'];
		
					echo "<li>";
					echo "<label for='lbookid'>".$userid."-></label>";
					echo "<label for='lbookid'>".$bookid."-></label>";
					echo "<label for='lbookid'>".$loandate."-></label>";
					echo "<label for='lbookid'>".$givebackdate."-></label>";
					echo "<label for='lbookid'>".$state."-></label>";
					echo "<label for='lbookid'>".$memo."</label>";
					echo "</li>";
		
		
				}
		}
		else
		{
		   echo "没有记录";
		}
		
					echo "</ol>";
					echo "</fieldset>";
		
		// 翻页链接
		$page_string = '';
		if( $page == 1 ){
		   $page_string .= '第一页|上一页|';
		}
		else{
		   $page_string .= '<a href=?page=1>第一页</a>|<a href=?page='.($page-1).'>上一页</a>|';
		} 
		if( ($page == $page_count) || ($page_count == 0) ){
		   $page_string .= '下一页|尾页';
		}
		else{
		   $page_string .= '<a href=?page='.($page+1).'>下一页</a>|<a href=?page='.$page_count.'>尾页</a>';
		}
		
		echo "<br>".$page_string;
		
		echo "</div>";
		echo "</div>";
		echo "<div id='extra'></div>";
		echo "</div>";
	
	}
}
?>