addresslist.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 == 'del') {echo 'sssssssss';exit;
	if(is_array($delete)) {
		$ids = "0";
		foreach($delete as $val) {
			$ids .= ",$val";
		}
		$db->query("DELETE FROM $table_addresslist WHERE id IN ($ids)");
	}elseif($id) {
		$db->query("DELETE FROM $table_addresslist WHERE id='$id'");
	}
	header("Location:memassist.php?action=addresslist");
}

if($sysaction == 'add') {
	if($username && $email) {
		if($id) {
			$db->query("update $table_addresslist set username='$username',sex='$sex',birth='$birth',duty='$duty',zip='$zip',fax='$fax',tel='$tel',mobile='$mobile',email='$email',work='$work',address='$address',memo='$memo' where id='$id'");
			header("Location:memassist.php?action=addresslist");
		}else {
			$db->query("insert into $table_addresslist (username,sex,birth,duty,zip,fax,tel,mobile,email,work,address,memo,mid,time) 
			values ('$username','$sex','$birth','$duty','$zip','$fax','$tel','$mobile','$email','$work','$address','$memo','$union_uid','$timestamp')");
		}
		header("Location:memassist.php?action=addresslist");
	}else {
		$pre_s = false;
		if($id) {
			$add_t = $db->query_fetch("select * from $table_addresslist where id='$id'");
			
		}
	}
}elseif($sysaction == 'show') {
	if($addnote == 1) {
		if($time && $stype && $des) {
			$db->query("insert into $table_cli_note (cid,type,des,time) values ('$id','$stype','$des','$time')");
			
			header("Location:memassist.php?action=addresslist&sysaction=show&id=$id");
			exit;
		}
	}

	$add_t = $db->query_fetch("select * from $table_addresslist where id='$id'");
	foreach($add_t as $key=>$val) {
		if(empty($val) || $val=='0000-00-00')
			$add_t[$key] = '空';
	}
	include getData('memassist_addresslist_show');
	exit;
}


if($pre_s) {

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

	$query = $db->query("select * from $table_addresslist$condi order by id ASC LIMIT $offset, $perpage");
	$num = $db->num_rows($query);
	while($list = $db->fetch_array($query)) {
		$list[type] = $type_list[$list[type]][name];
		$list[mid] = $member_list[$list[mid]][realname];
		$add_list[$list[id]] = $list;
	}
}



include getData('memassist_addresslist');