📄 add.php

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

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

<body class="bodycolor" topmargin="5">
<?
$CUR_TIME=date("Y-m-d H:i:s",time());
$CUR_DATE=date("Y-m-d",time());
//--------- 上传附件 ----------
//echo $ATTACHMENT;
if(count($_FILES)>1)
{
   $ATTACHMENTS=upload();

   $ATTACHMENT_ID=$ATTACHMENT_ID_OLD.$ATTACHMENTS["ID"];
   $ATTACHMENT_NAME=$ATTACHMENT_NAME_OLD.$ATTACHMENTS["NAME"];
}
else
{
   $ATTACHMENT_ID=$ATTACHMENT_ID_OLD;
   $ATTACHMENT_NAME=$ATTACHMENT_NAME_OLD;
}

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

if($DETAIL_ID1=="")
   $query="insert into WORK_DETAIL (PLAN_ID,WRITE_TIME,PROGRESS,PERCENT,TYPE_FLAG,WRITER,ATTACHMENT_ID,ATTACHMENT_NAME) values ('$PLAN_ID','$WRITE_TIME','$PROGRESS','$PERCENT','0','$LOGIN_USER_ID','$ATTACHMENT_ID','$ATTACHMENT_NAME')";
else
   $query="update WORK_DETAIL set PLAN_ID='$PLAN_ID',WRITE_TIME='$WRITE_TIME',PROGRESS='$PROGRESS',PERCENT='$PERCENT',TYPE_FLAG='0',WRITER='$LOGIN_USER_ID',ATTACHMENT_ID='$ATTACHMENT_ID',ATTACHMENT_NAME='$ATTACHMENT_NAME' where DETAIL_ID=$DETAIL_ID1";
exequery($connection,$query);

if($OP=="0" && $DETAIL_ID1=="")
   $DETAIL_ID1=mysql_insert_id();
//加入工作日志
if($WRITE_IN_WORK=="on")
{
   $query = "SELECT DIA_ID,CONTENT from DIARY where to_days(DIA_TIME)=to_days('$CUR_TIME') and DIA_TYPE='1' 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 = $ROW["CONTENT"];
	 	  
	 	  $CONTENT .= "<br><br>工作计划进度日志（".$CUR_TIME."）<br>".str_replace("\n","<br>",$PROGRESS);
	 	  $query="update DIARY set CONTENT='$CONTENT' where DIA_ID='$DIA_ID'";
      exequery($connection,$query);
	 }else{	 	   
	 	  $PROGRESS = "工作计划进度日志<br>".str_replace("\n","<br>",$PROGRESS);
      $query="insert into DIARY(USER_ID,DIA_DATE,DIA_TIME,DIA_TYPE,SUBJECT,CONTENT) values ('$LOGIN_USER_ID','$CUR_DATE','$CUR_TIME','1','工作计划进度','$PROGRESS')";
      exequery($connection,$query);
   }
}

//短信提醒
if($OP!="0")
{
   $query = "SELECT * from WORK_PLAN  where PLAN_ID='$PLAN_ID'";
   $cursor= exequery($connection,$query);
   if($ROW=mysql_fetch_array($cursor))
	 {
	    $CREATOR=$ROW["CREATOR"];
	    $MANAGER=$ROW["MANAGER"];
	    $PARTICIPATOR=$ROW["PARTICIPATOR"];


	    $USER_ID_STR=	$CREATOR.",".$MANAGER.",".$PARTICIPATOR;
	  }

  $SMS_CONTENT="有新的工作计划进度日志，请查看。";

  $REMIND_URL="1:work_plan/show/diary_detail.php?PLAN_ID=".$PLAN_ID;
  if($SMS_REMIND=="on")
     send_sms($CUR_TIME,$LOGIN_USER_ID,$USER_ID_STR,12,$SMS_CONTENT,$REMIND_URL);

  if($SMS2_REMIND=="on")
     send_mobile_sms_user($CUR_TIME,$LOGIN_USER_ID,$USER_ID_STR,$SMS_CONTENT,12);
}

if($FLAG==1)
   $DETAIL_ID1="";

if($OP==0)
   header("location: add_diary.php?DETAIL_ID1=$DETAIL_ID1&PLAN_ID=$PLAN_ID");
else
   header("location: add_diary.php?PLAN_ID=$PLAN_ID");
?>
</body>
</html>
⌨️ 快捷键说明

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