expense_man.php

CRM 不仅仅是一个管理名词和管理概念

<?
	########################################
	#OsoonCrm
	#费用操作
	########################################
		
	include "include/db.inc.php";
	include "include/check.inc.php";

	if ($G_username != "expense")
	{
		echo "没有权限！";
		exit;
	}
?>
<?
	///////////////////////////////////////////////////
	// 删除
	if ($action == "delete")
	{
		// 费用表
		$sql = "delete from $tbl_crm_expense where ExpenseId='$eid'";
		mysql_query($sql);
		
		// 返回列表
		echo "<p style=\"font:14.8px\">删除成功！稍候，页面将返回到列表......</p>";
		echo "<meta http-equiv=\"refresh\" content=\"0;URL=expense_list.php\">";
		exit;
	}
?>
<?
	/////////////////////////////////////////////////////
	// 编辑
	if ($action == "edit")
	{
		// 检查输入
		if (!$ExpenseName) {
			echo "请输入费用名！";
			exit;
		}
		if (!$AccountID) {
			echo "请选择所属的客户！";
			exit;
		}
		if (!$ProjectExpenseName) {
			echo "请输入费用种类！";
			exit;
		}

		// 项目表
		$sql = "update $tbl_crm_expense 
				set ExpenseName='$ExpenseName',AccountID='$AccountID',ProjectID='$ProjectID',ShiYou='$ShiYou',RealExpense='$RealExpense',UseTime='$UseTime',ProjectExpenseType='$ProjectExpenseType',ProjectExpenseName='$ProjectExpenseName' 
				where ExpenseId='$eid' and $where_account_view";
		mysql_query($sql);
		
		// 返回费用信息
		echo "<p style=\"font:14.8px\">费用修改成功！稍候，页面将返回到费用信息......</p>";
		echo "<meta http-equiv=\"refresh\" content=\"0;URL=expense_view.php?eid=$eid\">";
		exit;
	}
?>
<?
	/////////////////////////////////////////////////////
	// 添加（包括复制）
	if ($action == "add")
	{
		// 检查输入
		if (!$UserID) {
			echo "请选择报销人！";
			exit;
		}
		if (!$DeptID) {
			echo "请选择报销部门！";
			exit;
		}
		if (!$ExpenseName) {
			echo "请输入项目名！";
			exit;
		}
		if (!$AccountID) {
			echo "请选择所属的客户！";
			exit;
		}
		if (!$ProjectExpenseName) {
			echo "请输入费用种类！";
			exit;
		}
		
		// 费用表
		$sql = "insert into $tbl_crm_expense (ExpenseName,UserID,DeptID,AccountID,ProjectID,ShiYou,RealExpense,ProjectExpenseType,ProjectExpenseName,UseTime)
				values ('$ExpenseName','$UserID','$DeptID','$AccountID','$ProjectID','$ShiYou','$RealExpense','$ProjectExpenseType','$ProjectExpenseName','$UseTime')";
		mysql_query($sql);
		$eid = @mysql_insert_id();
		
		// 返回费用信息
		echo "<p style=\"font:14.8px\">费用添加成功！稍候，页面将返回到费用信息......</p>";
		echo "<meta http-equiv=\"refresh\" content=\"0;URL=expense_view.php?eid=$eid\">";
		exit;
	}
?>