department.php

来自「极限OA开源系统」· PHP 代码 · 共 90 行

<?
/********************************************************************************/
/* 极限办公自动化系统 (极限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 == 'del') {
	checkright(91,31,4);
	if(is_array($delete)) {
		$ids = "0";
		foreach($delete as $val) {
			$ids .= ",$val";
		}
		$db->query("DELETE FROM $table_department WHERE id IN ($ids)");
	}elseif($id) {
		$db->query("DELETE FROM $table_department WHERE id='$id'");
	}
	header("Location:system.php?action=department&Status=$Status");
	if($ccid) $cid = $ccid;
}

if($sysaction == 'add') {
	checkright(91,31,2);
	if($name) {
		if($id) {
			checkright(91,31,3);
			$db->query("update $table_department set name='$name',principal='$principal',address='$address',des='$des',fig='$fig' where id='$id'");
			header("Location:system.php?action=department&Status=$Status");
		}else {
			$db->query("insert into $table_department (name,principal,address,des) values ('$name','$principal','$address','$des')");
		}
		header("Location:system.php?action=department");
	}else {
		$pre_s = false;
		if($id) {
			$depar_t = $db->query_fetch("select * from $table_department where id='$id'");
		}
	}
}elseif($sysaction == 'show') {
	$depar_t = $db->query_fetch("select * from $table_department where id='$id'");
	$depar_t[principal] = $depar_t[principal]?$depar_t[principal]:'待定';
	$depar_t[address] = $depar_t[address]?$depar_t[address]:'空';
	$depar_t[des] = $depar_t[des]?$depar_t[des]:'空';
	$depar_t[fig] = $depar_t[fig]?'<font color=blue>可用</font>':'<font color=red>禁用</font>';
	include getData('system_department_show');
	exit;
}


if($pre_s) {
	!isset($Status)?($Status=-1):NULL;
	if($Status == 1) $Status = 1;
	elseif($Status == 0) $Status = 0;
	else $Status = -1;
	unset($condi);
	$Status == -1 ? NULL:($condi=" where fig='$Status'");

	
	$perpage = 20;
	if(!$page) {
		$page = 1;
	}
	$offset = ($page - 1) * $perpage;
	$query = $db->query("SELECT COUNT(*) FROM $table_department$condi");
	$num = $total = $db->result($query, 0);
	$multipage = pages($num, $perpage, $page, "system.php?action=department&Status=$Status");

	$query = $db->query("select * from $table_department$condi order by id ASC LIMIT $offset, $perpage");
	$num = $db->num_rows($query);
	while($list = $db->fetch_array($query)) {
		$list[fig] = $list[fig]?'<font color=blue>可用</font>':'<font color=red>禁用</font>';
		$depart_list[$list[id]] = $list;
	}
}





include getData('system_department');