member.php

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

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

if($sysaction == 'add') {
	checkright(91,41,2);
	if($username && $loginname && $email && $s_part) {
		if($id) {
			checkright(91,41,3);
			$pand = $db->query_fetch("select username from $table_members where username='$loginname' && uid!='$id'");
			if($pand[username])
				showmessage("拥有此登录名($pand[username])的用户已经存在,请返回");
			$condi = '';
			if($loginpass) {
				$condi = ",password='".md5($loginpass)."'";
			}
			$fig = empty($fig)?1:0;
			if($employfig) $condi .= ",employ='$employ'";
			$db->query("update $table_members set part='$s_part',realname='$username',username='$loginname',email='$email',des='$des',fig='$fig'$condi where uid='$id'");
			
		}else {
			$pand = $db->query_fetch("select username from $table_members where username='$loginname'");
			if($pand[username])
				showmessage("拥有此登录名($pand[username])的用户已经存在,请返回");
			$pass = md5($loginpass);
			$fig = empty($fig)?1:0;
			$db->query("insert into $table_members (part,realname,username,password,employ,email,des,fig) values ('$s_part','$username','$loginname','$pass','$employ','$email','$des','$fig')");
		}
		header("Location:system.php?action=member");
	}else {
		$pre_s = false;
		if($id) {
			$mem_t = $db->query_fetch("select * from $table_members where uid='$id'");
		}
		$query = $db->query("select * from $table_parts where fig=1");
		while($list = $db->fetch_array($query)) {
			$list[sel] = $list[id] == $mem_t[part] ? ' selected':'';
			$parts_list[$list[id]] = $list;
		}
	}
}elseif($sysaction == 'view') {
	$mem_list = array();
	$query = $db->query("select * from $table_members where employ>0");
	while($list = $db->fetch_array($query)) {
		$mem_list[] = $list[employ];
	}


	$query = $db->query("select * from $table_dict order by id ASC");
	while($list = $db->fetch_array($query)) {
		$dict_list[$list[id]] = $list;
	}

	$query = $db->query("select * from $table_department where fig='1' order by id ASC");
	$num = $db->num_rows($query);
	while($list = $db->fetch_array($query)) {
		if($depart_type == $list[id]) $list[sel] = ' selected';
		else $list[sel] = '';
		$depart_list[$list[id]] = $list;
	}
	if($depart_type) {
		$condi = " where depart='$depart_type'";
	}else
		$condi = '';

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

	$cid = $cid?intval($cid):1;
	$query = $db->query("select * from $table_employees$condi order by id ASC LIMIT $offset, $perpage");
	while($list = $db->fetch_array($query)) {
		$list[depart] = $depart_list[$list[depart]][name];
		$list[duty] = $dict_list[$list[duty]][name];
		if(in_array($list[id],$mem_list)) {
			$list[yesfig] = 1;
		}
		$employee_list[$list[id]] = $list;
	}
	$pre_s = false;
}


if($pre_s) {
	!isset($Status)?($Status=-1):NULL;
	if($Status == 1) $Status = 1;
	elseif($Status == 0) $Status = 0;
	else $Status = -1;

	!isset($userType)?($userType=-1):NULL;
	if($userType == 1) $userType = 1;
	elseif($userType == 0) $userType = 0;
	else $userType = -1;

	unset($condi);
	if($Status == -1 && $userType != -1) {
		$condi = " where employ='$userType'";
	}elseif($Status != -1 && $userType == -1) {
		$condi = " where fig='$Status'";
	}elseif($Status != -1 && $userType != -1) {
		$condi = " where fig='$Status' && employ='$userType'";
	}

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

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





include getData('system_member');