audit.php

BBWPS 宾馆管理系统 php+mysql

<?
/*
[BBWPS!] (C)2006-2010 小蜜蜂版权所有.
This is NOT a freeware, use is subject to license terms
时间：2007年12月
描述：审核酒店
*/
require("../../class/template_class.php");
require("../../config.php");
require("../../class/mysql_class.php");
require("../../function/fun.php");
require("../../function/language.php");
require("../../function/checkModuleSession.php");
$p=new Template("../template");
$DB=new DB($hostname,$username , $password ,$database,true);
$_BBWPSSESSION=isLogin("../../session/");
if($_BBWPSSESSION){
	$pagesizes= $DB->fetch_array($DB->query("select ppage from `".$prefix."control`",false));
	$pagesize=$pagesizes['ppage'];
	include("../../function/fenye.php");
  $sql="select count(*) from `".$prefix."basic` where application=1 and avaliable=0";
  $rs=$DB->query($sql,false);
  $myrow =$DB->fetch_array($rs);
  $total=$myrow['count(*)'];
	if($_GET['m']==2){
		$HID=$_POST['HID'];
		$Uname=$_POST['Uname'];
		$Hname=$_POST['Hname'];
		$email=$_POST['email'];
		$phone=$_POST['phone'];
		$QQ=$_POST['QQ'];
		$query0 = "update `".$prefix."basic` set Uname='".$Uname."',Hname='".$Hname."',email='".$email."',phone='".$phone."',QQ='".$QQ."' where HID='".$HID."'";
 		$result0=$DB->query($query0,false);
	}
	if($_GET['HID']){
		$query1="select* from `".$prefix."basic` where HID=".$_GET['HID']."";
		$result1=$DB->query($query1,false);
		$row1=$DB->fetch_array($result1);
		$p->set_file("application_handle","application.html");
		$p->set_var(array("HID"=> $row1['HID'],"Uname"=> $row1['Uname'],"Hname"=> $row1['Hname'],"email"=> $row1['email'],"phone"=> $row1['phone'],"QQ"=> $row1['QQ']));
		$p->parse("output","application_handle",true);
	}
	else{
		$p->set_file("audit_handle","audit.html");
  	$query = "SELECT HID,Hname FROM `".$prefix."basic` where application=1 and avaliable=0 limit $start,$pagesize";
		$result=$DB->query($query,false);
		$p->set_block("audit_handle","op","r");
		$p->set_var("r","");
		while($row=$DB->fetch_array($result)){
	 		$p->set_var(array("HID"=> $row['HID'],"Hname"=> $row['Hname'],"state"=> "申请加入作者"));
	 		$p->parse("r","op",true);
		}
		$p->set_var("page",showpage($total,$pagesize,$page,$query));
		$p->parse("output","audit_handle",true);
	}
	$p->p("output");
}
?>