bulletin.php

极限OA开源系统

<?
/********************************************************************************/
/* 极限办公自动化系统 (极限OA)													*/
/* ========================      												*/
/* 欢迎使用 极限OA,在您开始使用之前,请务必完整阅读本软件附带的全部说明档				*/
/********************************************************************************/
/* Welcome to http://www.xsp.cn & http://oa.xsp.cn								*/
/* 技术支持论坛 http://www.1119.net												*/
/********************************************************************************/
/* 商业购买请联系 临海市极限网络有限公司											*/
/* 联系电话: [phone]	邮件: [e-mail]	QQ: 562873							*/
/********************************************************************************/
if(!defined('KIN_UNION')){die("Hacking attempt");}
$pre_s = true;


if($sysaction == 'show') {
	checkright(21,11,0);
	$bul_t = $db->query_fetch("select * from $table_bulletin where id='$id'");
	$bul_t[state] = $bul_t[state]?$bul_t[state]:'未开始';
	foreach($bul_t as $key=>$val) {
		if(empty($val) && $val != 0)
			$bul_t[$key] = '空';
	}
	if($bul_t[scope] == 0)
		$bul_t[scope] = '所有部门';
	else {
		$ps32 = $db->query_fetch("select name from $table_department where id='$bul_t[scope]'");
		$bul_t[scope] = $ps32[name];
	}
	$bul_t[time] = date('Y-m-d H:i:s',$bul_t[time]);
	//$dia_t[content] = nl2br($dia_t[content]);
	include getData('communion_bulletin_show');
	exit;
}elseif($sysaction == 'query') {
	checkright(21,11,1);
	if($q_admin || $q_title || $q_keyword || $q_stime || $q_etime || $s_state) {
		if($q_admin) {
			$condi .= " && admin='$q_admin'";
		}
		if($q_title) {
			$condi .= " && title like '%$q_title%'";
		}
		if($q_keyword) {
			$condi .= " && keyword like '%$q_keyword%'";
		}
		if($q_stime) {
			$condi .= " && tdate>='$q_stime'";
		}
		if($q_etime) {
			$condi .= " && tdate<='$q_etime'";
		}
		if($q_state) {
			if($q_state == 1) {
				$condi .= " && time>'$timestamp'";
			}elseif($q_state == 2) {
				$condi .= " && ( time <= '$timestamp' && (time + 3600*24* daynum > '$timestamp') )";
			}else
				$condi .= " && ( time <= '$timestamp' && (time + 3600*24* daynum < '$timestamp') )";
		}
		$pre_s = true;
		
	}
}


if($pre_s) {
	$mem_list = array();
	$query = $db->query("select * from $table_members");
	while($list = $db->fetch_array($query)) {
		$mem_list[] = $list;
	}

	$tmp_part = $union_departid?$union_departid:0;

	$perpage = 15;
	if(!$page) {
		$page = 1;
	}
	$offset = ($page - 1) * $perpage;
	$query = $db->query("SELECT COUNT(*) FROM $table_bulletin$condi");
	$num = $total = $db->result($query, 0);
	$multipage = pages($num, $perpage, $page, "communion.php?action=bulletin&sysaction=$sysaction&q_admin=$q_admin&q_title=$q_title&q_keyword=$q_keyword&q_stime=$q_stime&q_etime=$q_etime&s_state=$s_state");

	$query = $db->query("select * from $table_bulletin where scope='$tmp_part' && time2>'$timestamp'$condi order by time DESC LIMIT $offset, $perpage");
	while($list = $db->fetch_array($query)) {
		$list[title] = wordscut($list[title],30,'');
		$bul_list[$list['id']] = $list;
	}
	if($num < $perpage) {
		for($ji=1;$ji<=($perpage-$num);$ji++) {
			$jii = -1000 + $ji;
			$bul_list[$jii] = array('blank'=>1);
		}
	}
}



include getData('communion_bulletin');