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

	if ($G_username != "expense")
	{
		echo "沒有權(quán)限！";
		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;
	}
?>
<?
	/////////////////////////////////////////////////////
	// 添加（包括復(fù)制）
	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;
	}
?>