assess.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");
require_once("../../function/func_global.php");
$p=new Template("../template");
$DB=new DB($hostname,$username , $password ,$database,true);
$_BBWPSSESSION=isLogin("../../session/");
if($_BBWPSSESSION){
	if($_REQUEST["action"]){
		$checkbox=$_POST['checkbox'];
		if(!$checkbox){
			MsgError("至少选中一条");
		}
		if($_POST['submit']=="开启评论"){
			for($i=0;$i< count($checkbox);$i++){
				$query2="update `".$prefix."comments` set state=3 where ID='".$checkbox["$i"]."'";
				$result2=$DB->query($query2,false);
			}
		}
		elseif($_POST['submit']=="锁定评论"){
			for($i=0;$i< count($checkbox);$i++){
				$query2="update `".$prefix."comments` set state=0 where ID='".$checkbox["$i"]."'";
				$result2=$DB->query($query2,false);
			}
		}
		elseif($_POST['submit']=="删除评论"){
			for($i=0;$i< count($checkbox);$i++){
				$query2="delete from  `".$prefix."comments` where ID='".$checkbox["$i"]."'";
				$result2=$DB->query($query2,false);
			}
		}
		ExeSuccess("提交成功","assess.php");
	}
	else{
		$pagesizes= $DB->fetch_array($DB->query("select ppage from `".$prefix."control`",false));
		$pagesize=$pagesizes['ppage'];
		include("../../function/fenye.php");
		$query0="select count(*) from `".$prefix."comments` left join `".$prefix."basic` on `".$prefix."comments`.HID=`".$prefix."basic`.HID";
		$result0=$DB->query($query0,1);
		$myrow =$DB->fetch_array($result0);
		$total=$myrow['count(*)'];
		$query1="select `".$prefix."comments`.* ,`".$prefix."basic`.Hname from `".$prefix."comments` left join `".$prefix."basic` on `".$prefix."comments`.HID=`".$prefix."basic`.HID limit $start,$pagesize";
		$result1=$DB->query($query1,false);
		$p->set_file("assess_handle","assess.html");
		$p->set_block("assess_handle","op","r");
		$p->set_var("r","");
		while($row1=$DB->fetch_array($result1)){
			if($row1['username']==""){
				$p->set_var("username","匿名用户");
			}
			else{
				$p->set_var("username", $row1['username']);
			}
			$p->set_var("content",$row1['content']);
			$p->set_var("ID",$row1['ID']);
			$p->set_var("Hname",$row1['Hname']);
			$p->set_var("addtime",date("Y-m-d",$row1['addtime']));
			if($row1['state']> 2){
				$p->set_var("state","开启");
			}
			elseif($row1['state']==0){
				$p->set_var("state","管理员锁定");
			}
			elseif($row1['state']==1){
				$p->set_var("state","酒店锁定");
			}
			elseif($row1['state']==2){
				$p->set_var("state","系统锁定");
			}
			$p->parse("r","op",true);
		}
		$p->set_var("page",showpage($total,$pagesize,$page,$query));
		$p->parse("output","assess_handle");
		$p->p("output");
	}
}
?>