management.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("../../function/fun.php");
require("../../class/mysql_class.php");
require("../../function/checkModuleSession.php");
require("../../function/func_global.php");
$DB=new DB($hostname,$username , $password ,$database,true);
$_BBWPSSESSION=isLogin("../../session/");
$p=new Template("../template");
if($_BBWPSSESSION){
	$array0=array("Uname","Hname","email","phone","QQ","address","Check_in","generalize");
	if($_GET['m']==2){
		$HID=$_POST['HID'];
		$province=$_POST['province'];
		$level=$_POST['level'];
		$query="select* from `".$prefix."city` where CID='".$province."'";
		$result=$DB->query($query,1);
		$row=$DB->fetch_array($result);
		$starttime=$_POST['starttime'];
		foreach($array0 as $value){
			${$value}=$_POST["$value"];
		}
		$query0="update `".$prefix."basic` set starttime='".strtotime($starttime)."'";
		foreach($array0 as $key){
			$query0.=",$key='".${$key}."'";
		}
		$query0.=",level='".$level."'";
		if($row['cparent']=='-1'){
			$query0.=",province='".$province."',city=''";
		}
		else{
			$query0.=",province='".$row['cparent']."',city='".$row['CID']."'";
		}
		$query0.=" 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("manage_handle","management1.html");
		$query="select* from `".$prefix."city` where csort='1'";
		$result=$DB->query($query,1);
		$p->set_block("manage_handle","op","r");
		while($row=$DB->fetch_array($result)){
			$p->set_var(array("CID"=> $row['CID'],"cname"=> $row['cname']));
			$p->parse("r","op",true);
			$qy="select* from `".$prefix."city` where cparent='".$row['CID']."'";
			$rlt=$DB->query($qy,1);
			while($r=$DB->fetch_array($rlt)){
				$p->set_var(array("CID"=> $r['CID'],"cname"=> " |-".$r['cname']));
				$p->parse("r","op",true);
			}
		}
 		foreach($array0 as $value){
			$p->set_var("$value",$row1["$value"]);
		}
		$p->set_var("HID",$_GET['HID']);
		$p->set_var("level",$row1['level']);
		$p->set_var("selected".$row1['level'],"selected");
		$p->set_var("select".$row1['city'],"selected");
		$p->set_var("starttime",date("Y-m-d",$row1["starttime"]));
	}
	else{
		//**********删除************
		if($_GET['m']==1){
			$checkbox=$_POST['checkbox'];
			if(!$checkbox){
				MsgError("至少选中一条");
			}
			for($i=0;$i< count($checkbox);$i++){
				$query = "delete from `".$prefix."basic` where HID='".$checkbox["$i"]."'";
				$result=$DB->query($query,false);
			}
		}
		//**********模板解析**************
		$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 avaliable=1";
  	$rs=$DB->query($sql,false);
  	$myrow =$DB->fetch_array($rs);
  	$total=$myrow['count(*)'];	
		$query1= "SELECT HID,Hname,phone,QQ,email,starttime FROM `".$prefix."basic` where avaliable=1 limit $start,$pagesize";
		$result1=$DB->query($query1,false);
		$p->set_file("manage_handle","management.html");
		$p->set_block("manage_handle","op","r");
		while($row1=$DB->fetch_array($result1)){
		 	$p->set_var(array("HID"=> $row1['HID'],"Hname"=> $row1['Hname'],"phone"=> $row1['phone'],"email"=> $row1['email'],"QQ"=> $row1['QQ'],"starttime"=> date("Y-m-d",$row1['starttime'])));
	 		$p->parse("r","op",true);
		}
		$p->set_var("page",showpage($total,$pagesize,$page,$query));
	}
	$p->parse("output","manage_handle",true);
	$p->p("output");
}
?>