sign.php

一个简单的网站管理系统,他能实现你所需要的功能,是个值得一看的系统

<?php
/*
*######################################
* PHPCMS v2.00 - Advanced Content Manage System.
* Copyright (c) 2004-2005 phpcms.cn
*
* For further information go to http://www.phpcms.cn/
* This copyright notice MUST stay intact for use.
*######################################
*/

if(!defined('IN_PHPCMS')) {
        exit('Access Denied');
}

$action = $action ? $action : 'manage' ;

switch($action){
case 'add':
     if($submit){
	   if(strpos($fromtime, "-")) {
		$time = explode("-", $fromtime);
		$starttime = gmmktime(0, 0, 0, $time[1], $time[2], $time[0]);
	   }else{
		$starttime = 0;
	   }
	   if(strpos($totime, "-")) {
		$time = explode("-", $totime);
		$endtime = gmmktime(0, 0, 0, $time[1], $time[2], $time[0]) - $timeoffset * 3600;
	   }else{
		$endtime = 0;
	   }

	   if(!$starttime) {
		showmessage('您必须输入起始时间，请返回修改。'.$starttime);
	   }elseif(!trim($subject) || !trim($content)) {
		showmessage('您必须输入公告标题和内容，请返回修改。');
	   }else{
		$db->query("INSERT INTO $table_sign_subject(subject, content, starttime, endtime, inputer,addtime,passed) VALUES ('$subject', '$content', '$starttime', '$endtime','$_SESSION[phpcms_username]','$timestamp','$passed')");
		showmessage('操作成功！',$referer);
	   }
     }else{
           $starttime=date("Y-m-d",$timestamp-86400);
           include template('sign_add',1);
     }
     break;

case 'edit':
     if($submit){
	   $subject = dhtmlspecialchars($subject);
	   if(strpos($fromtime, "-")) {
		 $time = explode("-", $fromtime);
	         $starttime = gmmktime(0, 0, 0, $time[1], $time[2], $time[0]) - $timeoffset * 3600;
	   }else{
		 $starttime = 0;
	   }
	   if(strpos($totime, "-")) {
		 $time = explode("-", $totime);
		 $endtime = gmmktime(0, 0, 0, $time[1], $time[2], $time[0]) - $timeoffset * 3600;
	   }else{
		 $endtime = 0;
	   }

	   if(!$starttime) {
		 showmessage('您必须输入起始时间，请返回修改。');
	   }elseif(!trim($subject) || !trim($content)){
		 showmessage('您必须输入公告标题和内容，请返回修改。');
	   }else{
		 $db->query("UPDATE $table_sign_subject SET subject='$subject', starttime='$starttime', endtime='$endtime', content='$content' WHERE signid='$signid'");
                 $referer='?dir=plugin&file=sign&page='.$page;
		 showmessage('操作成功！',$referer);
	   }
     }else{
           $query="select * from $table_sign_subject where signid='$signid'";
           $result=$db->query($query);
           $sign=$db->fetch_array($result);
           $sign[starttime]=date('Y-m-d',$sign[starttime]);
           $sign[endtime]=$sign[endtime] ? date('Y-m-d',$sign[endtime]) : '';
           include template('sign_edit',1);
     }
     break;

case 'pass':
      if(empty($signid)){
          showmessage('非法参数！请返回！');
      }
      $signids=is_array($signid) ? implode(',',$signid) : $signid;
      $db->query("UPDATE $table_sign_subject SET passed=1 WHERE signid IN ($signids)");
      $referer='?dir=plugin&file=sign&page='.$page;
      showmessage('操作成功！',$referer);
      break;

case 'close':
      if(empty($signid)){
          showmessage('非法参数！请返回！');
      }
      $signids=is_array($signid) ? implode(',',$signid) : $signid;
      $db->query("UPDATE $table_sign_subject SET passed=0 WHERE signid IN ($signids)");
      $referer='?dir=plugin&file=sign&page='.$page;
      showmessage('操作成功！',$referer);
      break;

case 'manage':

     if(!$page){
          $page=1;
          $offset=0;
     }else{
          $offset=($page-1)*$pagesize;
     }

     $result=$db->query("select count(*) as num from $table_sign_subject");
     $r=$db->fetch_array($result);
     $number=$r["num"];
     $url="?dir=plugin&file=sign&action=manage";
     $pages=showpage($number,$page,$pagesize,$url);

     $signs = '';
     $query = $db->query("SELECT * FROM $table_sign_subject ORDER BY signid DESC limit $offset,$pagesize");
     while($sign=$db->fetch_array($query)){
           $sign[starttime]=date("Y-m-d",$sign[starttime]);
           $sign[endtime]=date("Y-m-d",$sign[endtime]);
           $sign[addtime]=date('Y/md',$sign[addtime]);
           $signs[]=$sign;
     }

     include template('sign_manage',1);
     break;

case 'delete':
      if(empty($signid)){
          showmessage('非法参数！请返回！');
      }
      $signids=is_array($signid) ? implode(',',$signid) : $signid;
      $db->query("DELETE FROM $table_sign_subject WHERE signid IN ($signids)");
      $referer='?dir=plugin&file=sign&page='.$page;
      showmessage('操作成功！',$referer);
      break;

case 'detail':
      $query="select * from $table_sign_subject where signid='$signid'";
      $result=$db->query($query);
      $sign=$db->fetch_array($result);
      $sign[starttime]=date('Y-m-d',$sign[starttime]);
      $sign[endtime]=$sign[endtime] ? date('Y-m-d',$sign[endtime]) : '';

      if(!$page){
          $page=1;
          $offset=0;
      }else{
          $offset=($page-1)*$pagesize;
      }

      $result=$db->query("select count(*) as num from $table_sign_content");
      $r=$db->fetch_array($result);
      $number=$r["num"];
      $url="?dir=plugin&file=sign&action=detail";
      $pages=showpage($number,$page,$pagesize,$url);

      $signdetails = '';
      $query = $db->query("SELECT * FROM $table_sign_content ORDER BY signnameid DESC limit $offset,$pagesize");
      while($signdetail=$db->fetch_array($query)){
           $signdetail[addtime]=date('Y-m-d',$signdetail[addtime]);
           $signdetails[]=$signdetail;
      }
      include template('sign_detail',1);
      break;

case 'signpass':
      if(empty($signnameid)){
          showmessage('非法参数！请返回！');
      }
      $signnameids=is_array($signnameid) ? implode(',',$signnameid) : $signnameid;
      $db->query("UPDATE $table_sign_content SET passed=1 WHERE signnameid IN ($signnameids)");
      $referer='?dir=plugin&file=sign&action=detail&signid='.$signid.'&page='.$page;
      showmessage('操作成功！',$referer);
      break;

case 'signclose':
      if(empty($signnameid)){
          showmessage('非法参数！请返回！');
      }
      $signnameids=is_array($signnameid) ? implode(',',$signnameid) : $signnameid;
      $db->query("UPDATE $table_sign_content SET passed=0 WHERE signnameid IN ($signnameids)");
      $referer='?dir=plugin&file=sign&action=detail&signid='.$signid.'&page='.$page;
      showmessage('操作成功！',$referer);
      break;

case 'signdelete':
      if(empty($signnameid)){
          showmessage('非法参数！请返回！');
      }
      $signnameids=is_array($signnameid) ? implode(',',$signnameid) : $signnameid;
      $db->query("DELETE FROM $table_sign_content WHERE signnameid IN ($signnameids)");
      $referer='?dir=plugin&file=sign&action=detail&signid='.$signid.'&page='.$page;
      showmessage('操作成功！',$referer);
      break;
}
?>