place.php

来自「phpcms网站管理系统 很不错的 有需要的就下载看看八 」· PHP 代码 · 共 200 行

<?php
/**
* 广告位管理
* @version phpcms 3.0.0 build 20060424
* @package phpcms
* @subpackage ads
* @link http://dev.phpcms.cn phpcms模块开发网站
* @license http://www.phpcms.cn/license.html phpcms版权声明
* @copyright (C) 2005 - 2006 Phpcms Group
*/
defined('IN_PHPCMS') or exit(FORBIDDEN);

$submenu = array
(
	array("添加广告", "?mod=".$mod."&file=ads&action=add"),
	array("广告管理", "?mod=".$mod."&file=ads&action=manage"),
	array("广告订单管理", "?mod=".$mod."&file=ads&action=signlist"),
	array("添加广告位", "?mod=".$mod."&file=place&action=add"),
	array("广告位管理", "?mod=".$mod."&file=place&action=manage"),
	array("广告模板管理", "?mod=phpcms&file=template&action=manage&module=".$mod),
	array("广告模板类型", "?mod=phpcms&file=templatetype&action=manage&module=".$mod),
);

$menu = adminmenu("广告管理",$submenu);
$action = $action?$action:"manage";

switch($action)
{
    case 'add':    
    if ($submit) {      
  		if(strlen($place[placename])<2 || strlen($place[placename])>30){
  			showmessage("名称不能为空且不得少于2个字符或超过30个字符！请返回！");
  		}
  
  		$badwords=array("\\",'&',"'",'"','/','*','<','>',"\r","\t","\n",'#');
  		foreach ($badwords as $value) {
  			if(strpos($place[placename],$value)!==false) { 
  				showmessage('名称中不得包含非法字符！请返回！'); 
  			}
  		}
  
  		foreach ($badwords as $value) {
  			if(strpos($place[introduce],$value)!==false) { 
  				showmessage('说明中不得包含非法字符！请返回！'); 
  			}
  		}
      
      $templateids = get_template($mod,"ads");
  		if(!isset($templateids[$templateid][templatename])){
  			showmessage("请输入广告位模版！请返回！");
  		}
      
  		if(!is_numeric($place[price])){
  			showmessage("请输入广告位价格！请返回！");
  		}
      
  		if(!is_numeric($place[height]) && !is_numeric($place[weight])){
  			showmessage("请确认输入广告位高度和宽度格式为数值！请返回！");
  		}
      
      $sql = "INSERT INTO ".TABLE_ADS_PLACE." SET placename='$place[placename]',introduce='$place[introduce]',templateid='$templateid',price='$place[price]',channelid='$place[channelid]',passed=".($place[passed]?1:0).",width='$place[width]',height='$place[height]'";

  		$result=$db->query($sql);
  		if($db->affected_rows()>0) {
  			showmessage('操作完成！',"?mod=$mod&file=$file&action=manage");
  		} else {
  			showmessage('操作失败！意外错误，请确认输入内容。');
  		}      
      
    }
    
		$template_select = showtpl($mod,"ads","templateid");
		include admintpl("place_add");
		break;

		case 'loadjs':
			include admintpl("place_loadjs");
			break;		

		case 'view':
			include admintpl("place_view");
			break;		
        
    case 'edit':
			if ($submit) {      
				if(strlen($place[placename])<2 || strlen($place[placename])>30){
					showmessage("名称不能为空且不得少于2个字符或超过30个字符！请返回！");
				}
		
				$badwords=array("\\",'&',"'",'"','/','*','<','>',"\r","\t","\n",'#');
				foreach ($badwords as $value) {
					if(strpos($place[placename],$value)!==false) { 
						showmessage('名称中不得包含非法字符！请返回！'); 
					}
				}
		
				foreach ($badwords as $value) {
					if(strpos($place[introduce],$value)!==false) { 
						showmessage('说明中不得包含非法字符！请返回！'); 
					}
				}
				
				$templateids = get_template($mod,"ads");
				if(!isset($templateids[$templateid][templatename])){
					showmessage("请输入广告位模版！请返回！");
				}
				
				if(!is_numeric($place[price])){
					showmessage("请输入广告位价格！请返回！");
				}
				
				if(!is_numeric($place[height]) && !is_numeric($place[weight])){
					showmessage("请确认输入广告位高度和宽度格式为数值！请返回！");
				}
				
				$sql = "update ".TABLE_ADS_PLACE." SET placename='$place[placename]',introduce='$place[introduce]',templateid='$templateid',price='$place[price]',channelid='$place[channelid]',passed=".($place[passed]?1:0).",width='$place[width]',height='$place[height]' where placeid=".$place[placeid]." limit 1";

				$result=$db->query($sql);
				if($db->affected_rows()>0) {
					showmessage('操作完成！',"?mod=$mod&file=$file");
				} else {
					showmessage('操作失败！意外错误，请确认输入内容。');
				}      
				
			}
		
			$place = $db->get_one("SELECT * FROM ".TABLE_ADS_PLACE." where placeid = $placeid limit 1");
			if (count($place)<1) showmessage("未能查询到需要的记录，已返回。","?mod=ads&file=place");

			$template_select = showtpl($mod,"ads","templateid",$place[templateid]);
			include admintpl("place_edit");

		break;

		case 'lock':
			if (is_numeric($placeid) && is_numeric($val)) {
				$db->query("update ".TABLE_ADS_PLACE." set passed = $val where placeid=$placeid limit 1");
			} elseif (is_array($placeid)) {
				$placeids = implode(",",$placeid);
				$db->query("update ".TABLE_ADS_PLACE." set passed = $val where placeid in ($placeids)");
			}

			if ($db->affected_rows()>0) {
				showmessage('操作成功！',"?mod=ads&file=place");
			} else {
				showmessage('操作完成！未能查询到符合的记录，已返回。',"?mod=ads&file=place");
			}

			showmessage("错误参数！请返回！");
		break;

    case 'delete':
		if(is_numeric($placeid)){
	  	$db->query("delete from ".TABLE_ADS." where placeid=".$placeid);
	  	$db->query("delete from ".TABLE_ADS_PLACE." where placeid=".$placeid." limit 1");
		} elseif (is_array($placeid)) {
			$placeids = implode(",",$placeid);
	  	$db->query("delete from ".TABLE_ADS." where placeid in ($placeids)");
			$db->query("delete from ".TABLE_ADS_PLACE." where placeid in ($placeids)");
		}

		if($db->affected_rows()>0) {
			showmessage('操作成功！',"?mod=".$mod."&file=place");
		} else {
			showmessage("操作完成！未能查询到符合的记录，已返回。","?mod=ads&file=place");
		}

		showmessage("错误参数！请返回！");
    break;
    
    default :
			$templateids = get_template($mod,"ads");
			
			$page = intval($page)>0 ? $page : 1;
			$offset=($page-1)*$_PHPCMS['pagesize'];
			$result=$db->query("SELECT count(*) as num FROM ".TABLE_ADS_PLACE);
			$r=$db->fetch_array($result);
			$number=$r["num"];
			$url='?mod='.$mod.'file=ads&action='.$action;
			$pages = phppages($number,$page,$_PHPCMS['pagesize'],$url);

			$result=$db->query("SELECT * FROM ".TABLE_ADS_PLACE." order by placeid desc limit $offset,$_PHPCMS[pagesize] ");
			
			while($r=$db->fetch_array($result)){
				$places[]=$r;
			}

			reset($places);
			$today = time(date("Y-m-d"));
			while ($place = current($places)) {
				$result=$db->get_one("SELECT * FROM ".TABLE_ADS." where placeid=$place[placeid] AND passed=1 and fromdate<='$today' and todate>='$today' limit 1");
				$places[key($places)][todate] = $result[todate]?date("Y-m-d",$result[todate]):"-";
				$places[key($places)][username] = $result[username]?$result[username]:"-";
				next($places);
			}

			include admintpl("place_list");
}

?>