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

📄 add_diary.php

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

<html>
<head>
<title>进度日志</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script src="/inc/js/utility.js"></script>
<script src="/inc/js/attach.js"></script>
<script>
var upload_limit=<?=$UPLOAD_LIMIT?>,limit_type="<?=strtolower($UPLOAD_LIMIT_TYPE)?>";
function delete_diary(DETAIL_ID,PLAN_ID,ATTACHMENT_ID,ATTACHMENT_NAME)
{
   msg='确认要删除该进度日志么？';
   if(window.confirm(msg))
   {
      URL="delete_diary.php?DETAIL_ID=" + DETAIL_ID+"&PLAN_ID=" + PLAN_ID +"&ATTACHMENT_ID=" + ATTACHMENT_ID+"&ATTACHMENT_NAME=" + URLSpecialChars(ATTACHMENT_NAME);
      window.location=URL;
   }
}

function CheckForm()
{
  if(document.form1.PERCENT.value=="")
  {
   	 alert("请估计你的工作进度");
     return (false);
  }
  if(parseInt(document.form1.PERCENT.value) < 0 || parseInt(document.form1.PERCENT.value) > 100)
  {
   	 alert("完成百分比值在0～100之间。");
     return (false);
  }
  if(parseFloat(document.form1.PERCENT.value) < parseFloat(document.form1.PERCENT_MAX.value))
  {
   	 alert("进度百分比数值不能小于上一次的数值");
     return (false);
  }
  document.form1.OP.value="1";
  return (true);
}

function sendForm()
{
  document.form1.FLAG.value="1";
  if(CheckForm())
     document.form1.submit();
}

function upload_attach()
{
  if(CheckForm())
  {
     document.form1.OP.value="0";
     document.form1.FLAG.value="0";
     document.form1.submit();
  }
}

function delete_attach(ATTACHMENT_ID,ATTACHMENT_NAME)
{
  msg="确定要删除文件 '"+ ATTACHMENT_NAME +"' 吗?";
  if(window.confirm(msg))
  {
     URL="delete_attach.php?DETAIL_ID1=<?=$DETAIL_ID1?>&PLAN_ID=<?=$PLAN_ID?>&ATTACHMENT_ID="+ATTACHMENT_ID+"&ATTACHMENT_NAME="+URLSpecialChars(ATTACHMENT_NAME);
     window.location=URL;
  }
}

</script>

</head>

<body class="bodycolor" topmargin="5">
<?
$CUR_DATE=date("Y-m-d",time());

$query = "SELECT * from WORK_PLAN where PLAN_ID='$PLAN_ID'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{

   $NAME=$ROW['NAME'];

   $BEGIN_DATE1=$ROW['BEGIN_DATE'];
   $END_DATE1=$ROW['END_DATE'];
   $MANAGER=$ROW["MANAGER"];
   $PARTICIPATOR=$ROW["PARTICIPATOR"];
   $SUSPEND_FLAG=$ROW["SUSPEND_FLAG"];
   $BEGIN_DATE=$ROW["BEGIN_DATE"];
   $END_DATE=$ROW["END_DATE"];

   $DIARY_WRITER=$MANAGER.$PARTICIPATOR;

   $MY_FLAG=0;
   if($SUSPEND_FLAG==1)
   {
   	  if(compare_date($CUR_DATE,$BEGIN_DATE)<0)
      {
         $STATUS=1;
         $STATUS_DESC="未开始";
      }
      else
      {
         $STATUS=2;
         $STATUS_DESC="<font color='#00AA00'><b>进行中</b></font>";
      }

      if($END_DATE!="0000-00-00")
      {
        if(compare_date($CUR_DATE,$END_DATE)>0)
        {
           $STATUS=3;
           $STATUS_DESC="<font color='#FF0000'><b>已结束</b></font>";
           $MY_FLAG=1;
        }
      }

   }
   else
   {
      $STATUS=2;
      $STATUS_DESC="<font color='#FF0000'><b>暂停</b></font>";
      $MY_FLAG=1;
   }

   if(find_id($DIARY_WRITER,$LOGIN_USER_ID))
      $HINT_FLAG=0;
   else
      $HINT_FLAG=1;
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
 <tr>
  <td class="Big"><img src="/images/menu/work_plan.gif" width="22" height="18" align="absMiddle"><span class="big3"> 进度日志详情(<?=$NAME?> <?=format_date($BEGIN_DATE1)?> - <? if($END_DATE1!="0000-00-00") echo format_date($END_DATE1);?>)</span>
  </td>
 </tr>
</table>
<?
if($DETAIL_ID1=="")
{
   $query1 = "SELECT MAX(PERCENT) AS PERCENT_M from WORK_DETAIL where TYPE_FLAG='0' and WRITER='$LOGIN_USER_ID' and PLAN_ID='$PLAN_ID'";
   $cursor1= exequery($connection,$query1);
   if($ROW1=mysql_fetch_array($cursor1))
      $PERCENT_MAX=$ROW1["PERCENT_M"];
}
else
{
   $query1 = "SELECT MAX(PERCENT) AS PERCENT_M from WORK_DETAIL where TYPE_FLAG='0' and WRITER='$LOGIN_USER_ID' and PLAN_ID='$PLAN_ID'";
   $cursor1= exequery($connection,$query1);
   if($ROW1=mysql_fetch_array($cursor1))
      $PERCENT_M=$ROW1["PERCENT_M"];

   $query1 = "SELECT MAX(PERCENT) AS PERCENT_CM from WORK_DETAIL where TYPE_FLAG='0' and  WRITER='$LOGIN_USER_ID' and PLAN_ID='$PLAN_ID' and PERCENT < '$PERCENT_M'";
   $cursor1= exequery($connection,$query1);
   if($ROW1=mysql_fetch_array($cursor1))
      $PERCENT_MAX=$ROW1["PERCENT_CM"];
}

$query = "SELECT DETAIL_ID,WRITE_TIME,PROGRESS,PERCENT,WRITER,ATTACHMENT_ID,ATTACHMENT_NAME from WORK_DETAIL where TYPE_FLAG='0'and PLAN_ID='$PLAN_ID' order by WRITER,WRITE_TIME asc";
$cursor=exequery($connection,$query);
$DETAIL_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
  $DETAIL_COUNT++;
  $DETAIL_ID=$ROW["DETAIL_ID"];
	$WRITE_TIME1=$ROW["WRITE_TIME"];
	$PROGRESS1=$ROW["PROGRESS"];
	$PERCENT1 =$ROW["PERCENT"];
	$WRITER1=$ROW["WRITER"];

  $ATTACHMENT_ID1=$ROW["ATTACHMENT_ID"];
  $ATTACHMENT_NAME1=$ROW["ATTACHMENT_NAME"];

  $PROGRESS1=str_replace("\n","<br>",$PROGRESS1);
  $query1 = "SELECT * from USER where USER_ID='$WRITER1'";
  $cursor1= exequery($connection,$query1);
  if($ROW1=mysql_fetch_array($cursor1))
     $USER_NAME=$ROW1["USER_NAME"];

  if($DETAIL_COUNT==1)
	{
?>
<table class="TableList" width="95%"  align="center">
   <tr class="TableHeader">
     <td nowrap align="center">作者</td>
     <td nowrap align="center">内容</td>
     <td nowrap align="center">附件</td>
     <td nowrap align="center">日志时间</td>
     <td nowrap align="center">进度百分比</td>
     <td nowrap align="center">操作</td>
   </tr>
<?
  }

  if($DETAIL_COUNT%2==1)
     $TableLine="TableLine1";
  else
     $TableLine="TableLine2";

?>
  <tr class="<?=$TableLine?>">
     <td nowrap align="center"><?=$USER_NAME?></td>
  	 <td align="left" style="word-break: break-all;word-wrap:break-word;"><?=$PROGRESS1?></td>
     <td nowrap align="left"><?=attach_link($ATTACHMENT_ID1,$ATTACHMENT_NAME1,0,1,1)?></td>
     <td nowrap align="center"><?=$WRITE_TIME1?></td>
     <td nowrap align="center"><?=$PERCENT1?>%</td>
     <td nowrap align="center">
<?
if($LOGIN_USER_ID==$WRITER1 or $LOGIN_USER_PRIV==1)
{
?>
     	 <a href="edit_diary.php?DETAIL_ID=<?=$DETAIL_ID?>&PLAN_ID=<?=$PLAN_ID?>"> 修改</a>
       <a href="javascript:delete_diary('<?=$DETAIL_ID?>','<?=$PLAN_ID?>','<?=$ATTACHMENT_ID1?>','<?=$ATTACHMENT_NAME1?>');"> 删除</a>
<?
}
?>
     </td>
  </tr>

<?
} //while

if($DETAIL_COUNT==0)
{
   Message("","无进度日志");
}
else
{
?>
</table>
<?
}

if($MY_FLAG!=1  && $HINT_FLAG==0)
{
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/edit.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 添加进度日志</span>
    </td>
  </tr>
</table>

<?
$CUR_TIME=date("Y-m-d H:i:s",time());

if($DETAIL_ID1!="")
{
   $query = "SELECT * from WORK_DETAIL where DETAIL_ID='$DETAIL_ID1'";
   $cursor= exequery($connection,$query);
   if($ROW=mysql_fetch_array($cursor))
   {
	    $PROGRESS=$ROW["PROGRESS"];
	    $PERCENT =$ROW["PERCENT"];
	    $WRITER=$ROW["WRITER"];
   	  $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
      $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
   }
}

?>
<form action="add.php"  method="post" name="form1" enctype="multipart/form-data">
<table class="TableBlock"  width="95%" align="center" >
   <tr>
    <td nowrap class="TableContent" width="90">当前时间：</td>
    <td class="TableData">
      <input type="text" name="WRITE_TIME" size="19" readonly maxlength="100" class="BigStatic" value="<?=$CUR_TIME?>">
    </td>
   </tr>
   <tr>
     <td nowrap class="TableContent"> 完成百分比：</td>
     <td class="TableData" colspan="1">
       <input type="text" name="PERCENT" size="2" class="BigInput" value="<?=$PERCENT?>"><font size="3"> %</font>  上次进度值：<?if(is_null($PERCENT_MAX))echo "0";else echo $PERCENT_MAX;?>   （注：估计完成量与总量的百分比）
     </td>
   </tr>
   <tr>
     <td nowrap class="TableContent"> 进度详情：</td>
     <td class="TableData" colspan="1">
       <textarea name="PROGRESS" class="BigInput" cols="55" rows="5"><?=$PROGRESS?></textarea>
     </td>
   </tr>
    <tr>
      <td nowrap class="TableContent">附件文档：</td>
      <td nowrap class="TableData">
<?
      if($ATTACHMENT_ID=="")
         echo "无附件";
      else
         echo attach_link($ATTACHMENT_ID,$ATTACHMENT_NAME,0,1,1,1,1,1,0,0);
?>
      </td>
    </tr>
    <tr height="25">
      <td nowrap class="TableContent">附件选择：</td>
      <td class="TableData">
         <script>ShowAddFile();</script>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent"> 提醒：</td>
      <td class="TableData">
<?=sms_remind(12);?>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent">是否写入工作日志：</td>
      <td class="TableData">
      	<input type="checkbox" name="WRITE_IN_WORK" id="WRITE_IN_WORK">
      	(注意：勾选会将进度详情写入工作日志中)
      	</td>
    </tr>
   <tr>
    <td nowrap  class="TableControl" colspan="2" align="center">
      <input type="hidden" value="<?=$PLAN_ID?>" name="PLAN_ID">
      <input type="hidden" name="OP" value="">
        <input type="hidden" name="ATTACHMENT_ID_OLD" value="<?=$ATTACHMENT_ID?>">
        <input type="hidden" name="ATTACHMENT_NAME_OLD" value="<?=$ATTACHMENT_NAME?>">
      <input type="hidden" name="FLAG" value="">
      <input type="hidden" name="PERCENT_MAX" value="<?=$PERCENT_MAX?>">
      <input type="hidden" value="<?=$DETAIL_ID1?>" name="DETAIL_ID1">
      <input type="button" value="确定" class="BigButton" onclick="sendForm();">&nbsp;&nbsp;
<?
if($BACK_FLAG==1)
{
?>
      <input type="button" value="返回" class="BigButton" onclick="history.back();">&nbsp;&nbsp;
<?
}
?>
      <input type="button" class="BigButton" value="关闭" onClick="window.close();" title="关闭窗口">&nbsp;&nbsp;
      <input type="button" value="进度图" class="BigButton" onClick="window.open('progress_map.php?PLAN_ID=<?=$PLAN_ID?>','','status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=0,top=0,resizable=yes');">
    </td>
</table>
</form>
<?
}
else
{
?>
<br>
<br>
<center>
      <input type="button" class="BigButton" value="关闭" onClick="window.close();" title="关闭窗口">&nbsp;&nbsp;
      <input type="button" value="进度图" class="BigButton" onClick="window.open('progress_map.php?PLAN_ID=<?=$PLAN_ID?>','','status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=0,top=0,resizable=yes');">
</center>
<?
}
?>
</body>
</html>

⌨️ 快捷键说明

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