?? expense_man.php
字號:
<?
########################################
#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;
}
?>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -