employee.php

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

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

	if($ccid) $cid = $ccid;
}

if($sysaction == 'add') {
	checkright(91,21,2);
	if($username && $email && $depart && $duty && $postdate) {
		if($id) {
			checkright(91,21,3);
			$db->query("update $table_employees set username='$username',sex='$sex',birth='$birth',idcard='$idcard',native='$native',nation='$nation',culture='$culture',polity='$polity',address='$address',zip='$zip',homephone='$homephone',telphone='$telphone',mobile='$mobile',email='$email',depart='$depart',duty='$duty',employtype='$employtype',postdate='$postdate',leftdate='$leftdate',memo='$memo' where id='$id'");
			header("Location:system.php?action=employee");
		}else {
			$db->query("insert into $table_employees (username,sex,birth,idcard,native,nation,culture,polity,address,zip,homephone,telphone,mobile,email,depart,duty,employtype,postdate,leftdate,memo) 
			values ('$username','$sex','$birth','$idcard','$native','$nation','$culture','$polity','$address','$zip','$homephone','$telphone','$mobile','$email','$depart','$duty','$employtype','$postdate','$leftdate','$memo')");
		}
		header("Location:system.php?action=employee");
	}else {
		$pre_s = false;
		$sel_arr = array();
		if($id) {
			$emp_t = $db->query_fetch("select * from $table_employees where id='$id'");			
			$emp_t[nation]>0? ($sel_arr[]=$emp_t[nation]) : NULL;
			$emp_t[culture]>0? ($sel_arr[]=$emp_t[culture]) : NULL;
			$emp_t[polity]>0? ($sel_arr[]=$emp_t[polity]) : NULL;
			$emp_t[duty]>0? ($sel_arr[]=$emp_t[duty]) : NULL;
		}

		$query = $db->query("select * from $table_dict order by id ASC");
		$num = $db->num_rows($query);
		while($list = $db->fetch_array($query)) {
			if(in_array($list[id],$sel_arr)) $list[sel] = ' selected';
			else $list[sel] = '';
			$dict_list[$list[id]] = $list;
		}

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

	}
}elseif($sysaction == 'show') {
	$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)) {
		$depart_list[$list[id]] = $list;
	}

	$emp_t = $db->query_fetch("select * from $table_employees where id='$id'");
	$emp_t[nation] = $emp_t[nation]?$dict_list[$emp_t[nation]][name]:'空';
	$emp_t[culture] = $emp_t[culture]?$dict_list[$emp_t[culture]][name]:'空';
	$emp_t[polity] = $emp_t[polity]?$dict_list[$emp_t[polity]][name]:'空';
	$emp_t[duty] = $emp_t[duty]?$dict_list[$emp_t[duty]][name]:'空';
	$emp_t[depart] = $emp_t[depart]?$depart_list[$emp_t[depart]][name]:'空';
	$emp_t[employtype] = $emp_t[employtype]?'正式':'实习';
	foreach($emp_t as $key=>$val) {
		if(empty($val) || $val=='0000-00-00')
			$emp_t[$key] = '空';
	}
	include getData('system_employee_show');
	exit;
}


if($pre_s) {
	$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 = '';

	$cid = $cid?intval($cid):1;
	
	$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");

	$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];
		$employee_list[$list[id]] = $list;
	}
}



include getData('system_employee');