suggest.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"]){
		$HID=$_POST['arr'];
		if(!$HID){
			MsgError("至少选中一条");
		}
		if($_POST['sure']=="开启推荐"){
			for($i=0;$i< count($HID);$i++){
				$query = "UPDATE `".$prefix."basic` SET commend=1 where HID='".$HID[$i]."'";
				$result=$DB->query($query,1);
			}
		}
		elseif($_POST['sure']=="锁定推荐"){
			for($i=0;$i< count($HID);$i++){
				$query = "UPDATE `".$prefix."basic` SET commend=0 where HID='".$HID[$i]."'";
				$result=$DB->query($query,1);
			}
		}
		ExeSuccess("提交成功","suggest.php");
	}
	else{
		$pagesizes= $DB->fetch_array($DB->query("select ppage from `".$prefix."control`",false));
		$pagesize=$pagesizes['ppage'];
		include("../../function/fenye.php");
		$query="select count(*) from `".$prefix."basic`";
		$rs=$DB->query($query,1);
		$myrow =$DB->fetch_array($rs);
		$total=$myrow['count(*)'];
		$query = "SELECT HID,Hname,commend FROM `".$prefix."basic` limit $start,$pagesize";
		$result=$DB->query($query,1);
		while($row=$DB->fetch_array($result)){
			$p->set_file("hd1","proposal.html");
			$p->set_var(array("HID"=> $row['HID'],"Hname"=> $row['Hname']));
			if($row['commend']==0){
				$p->set_var("state","未推荐");
			}
			elseif($row['commend']==1){
				$p->set_var("state","已推荐");
			}
			$p->parse("hotel","hd1",true);
		}

		$p->set_file("suggest_handle","suggest.html");
		$p->set_var("page",showpage($total,$pagesize,$page,$query));
		$p->parse("output","suggest_handle",true);
		$p->p("output");
	}
}
?>