⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 submit.php

📁 通达OA官方提供的30源代码,感觉很实在
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
include_once("inc/utility_file.php");
?>

<html>
<head>
<title>今日日志</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body class="bodycolor" topmargin="5">

<?
//------------------锁定检测----------------------
$CUR_DATE=date("Y-m-d",time());
$CUR_TIME=date("Y-m-d H:i:s",time());
if($DIA_DATE=="")
   $DIA_DATE=$CUR_DATE;

$query = "SELECT PARA_VALUE from SYS_PARA where PARA_NAME='LOCK_TIME'";
$cursor= exequery($connection,$query);
if($ROW1=mysql_fetch_array($cursor))
{
   $PARA_VALUE=$ROW1["PARA_VALUE"];

	 $PARA_VALUE=explode(",",$PARA_VALUE);
   $W_START=$PARA_VALUE[0];
   $W_END=$PARA_VALUE[1];
   $DAYS=intval($PARA_VALUE[2]);
}

if($DAYS!=0 && date("Y-m-d",strtotime("+".$DAYS."day",strtotime($DIA_DATE)))<=$CUR_DATE)
{
	Message("提示","所填的日志日期在锁定范围内!");
   Button_Back();
   exit;
}
if($W_START=="" && $W_END!="" && compare_date($DIA_DATE,$W_END)<=0)
{
	Message("提示","所填的日志日期在锁定范围内!");
   Button_Back();
   exit;
}
elseif($W_START!="" && $W_END=="" && compare_date($DIA_DATE,$W_START)>=0)
{
	Message("提示","所填的日志日期在锁定范围内!");
   Button_Back();
   exit;
}
elseif($W_START!="" && $W_END!="" && (compare_date($DIA_DATE,$W_END)<=0 && compare_date($DIA_DATE,$W_START)>=0))
{
	Message("提示","所填的日志日期在锁定范围内!");
   Button_Back();
   exit;
}

//--------- 上传附件 ----------
if(count($_FILES)>1)
{
   $ATTACHMENTS=upload();
   $CONTENT=ReplaceImageSrc($CONTENT, $ATTACHMENTS);

   $ATTACHMENT_ID=$ATTACHMENTS["ID"];
   $ATTACHMENT_NAME=$ATTACHMENTS["NAME"];
}

$ATTACHMENT_ID.=copy_sel_attach($ATTACH_NAME,$ATTACH_DIR,$DISK_ID);
$ATTACHMENT_NAME.=$ATTACH_NAME;

//------------------- 保存 -----------------------
if($SUBJECT =="")
   $SUBJECT = $CUR_DATE."日志";

if($FROM=="calender")
{
	 $query = "SELECT DIA_ID,CONTENT from DIARY where to_days(DIA_DATE)=to_days('$DIA_DATE') and DIA_TYPE='$DIA_TYPE' and USER_ID='$LOGIN_USER_ID' order by DIA_TIME desc limit 0,1";
   $cursor= exequery($connection,$query);
   if($ROW=mysql_fetch_array($cursor))
	 {
	 	  $DIA_ID = $ROW["DIA_ID"];
	 	  $CONTENT_OLD = $ROW["CONTENT"];
	 	  
	 	  $CONTENT = $CONTENT_OLD."<br><br>".$SUBJECT."<br>".$CONTENT;
	 	  $query="update DIARY set CONTENT='$CONTENT' where DIA_ID='$DIA_ID'";
      exequery($connection,$query);
	 }else{	 	   
      $query="insert into DIARY(USER_ID,DIA_DATE,DIA_TIME,DIA_TYPE,SUBJECT,CONTENT,ATTACHMENT_ID,ATTACHMENT_NAME,TO_ID) values ('$LOGIN_USER_ID','$DIA_DATE','$CUR_TIME','$DIA_TYPE','$SUBJECT','$CONTENT','$ATTACHMENT_ID','$ATTACHMENT_NAME','$TO_ID')";
      exequery($connection,$query);
   }	
}else{
  $query="insert into DIARY(USER_ID,DIA_DATE,DIA_TIME,DIA_TYPE,SUBJECT,CONTENT,ATTACHMENT_ID,ATTACHMENT_NAME,TO_ID) values ('$LOGIN_USER_ID','$DIA_DATE','$CUR_TIME','$DIA_TYPE','$SUBJECT','$CONTENT','$ATTACHMENT_ID','$ATTACHMENT_NAME','$TO_ID')";
  exequery($connection,$query);
  $DIA_ID=mysql_insert_id();	
}

if($OP=="0")
   header("location: ../edit.php?DIA_ID=$DIA_ID");
else
   header("location: ../diary_body.php");
?>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -