📄 add_diary.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  include_once 'inc/check_type.php';
  echo '
<html>
<head>
<title>进度日志</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
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=" + ATTACHMENT_NAME;
      window.location=URL;
   }
}
function CheckForm()
{
  if(document.form1.PERCENT.value==';
  echo '"")
  { 
   	 alert("请估计你的工作进度");
     return (false);
  }
  if(parseFloat(document.form1.PERCENT.value) <= parseFloat(document.form1.PERCENT_MAX.value))
  { 
   	 alert("进度百分比数值不能小于等于上一次的数值");
     return (false);
  }
  if(document.form1.ATTACHMENT.value!="")
  {
     var file_temp=document.form1.ATTACHMENT.value,file_name;
     var Pos;
     Pos=file_temp';
  echo '.lastIndexOf("\\\\");
     file_name=file_temp.substring(Pos+1,file_temp.length);
     document.form1.ATTACHMENT_NAME.value=file_name;
  }
  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.valu';
  echo 'e="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=';
  echo $DETAIL_ID1;
  echo '&PLAN_ID=';
  echo $PLAN_ID;
  echo '&ATTACHMENT_ID="+ATTACHMENT_ID+"&ATTACHMENT_NAME="+ATTACHMENT_NAME;
     window.location=URL;
  }
}
function SaveFile(ATTACHMENT_ID,ATTACHMENT_NAME)
{
  URL="/module/save_file?ATTACHMENT_ID="+ATTACHMENT_ID+"&ATTACHMENT_NAME="+ATTACHMENT_NAME+"&A=1";
  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
  loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
  window';
  echo '.open(URL,null,"height=180,width=400,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top="+loc_y+",left="+loc_x+",resizable=yes");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<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">';
  echo '<s';
  echo 'pan class="big3"> 进度日志详情</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 * 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 ('
', '<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))
    {
      echo '<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3" 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';
      echo '>
   </tr>
';
    }
    if ((($DETAIL_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '  <tr class="';
    echo $TableLine;
    echo '">
     <td nowrap align="center">';
    echo $USER_NAME;
    echo '</td>
  	 <td nowrap align="left">';
    echo $PROGRESS1;
    echo '</td>
     <td nowrap align="left">';
    echo attach_link ($ATTACHMENT_ID1, $ATTACHMENT_NAME1, 0, 1, 0);
    echo '</td>        	 
     <td nowrap align="center">';
    echo $WRITE_TIME1;
    echo '</td>  	 
     <td nowrap align="center">';
    echo $PERCENT1;
    echo '%</td>     
     <td nowrap align="center">
';
    if ((($LOGIN_USER_ID == $WRITER) OR ($LOGIN_USER_PRIV == 1)))
    {
      echo '     	 <a href="edit_diary.php?DETAIL_ID=';
      echo $DETAIL_ID;
      echo '&PLAN_ID=';
      echo $PLAN_ID;
      echo '"> 修改</a>
       <a href="javascript:delete_diary(\'';
      echo $DETAIL_ID;
      echo '\',\'';
      echo $PLAN_ID;
      echo '\',\'';
      echo $ATTACHMENT_ID1;
      echo '\',\'';
      echo $ATTACHMENT_NAME1;
      echo '\');"> 删除</a>
';
    }
    echo '     </td> 
  </tr>
';
  }
  if (($DETAIL_COUNT == 0))
  {
    message ('', '无进度日志');
  }
  else
  {
    echo '</table>
';
  }
  echo '
<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">';
  echo '<s';
  echo 'pan 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'];
    }
  }
  echo '<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3" align="center" >
  <form action="add.php"  method="post" name="form1" enctype="multipart/form-data">  
   <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="';
  echo $CUR_TIME;
  echo '">       
    </td>
   </tr>
   <tr>
     <td nowrap class="TableContent"> 完成百分比：</td>
     <td class="TableData" colspan="1">
       <input type="text" name="PERCENT" size="2" class="BigInput" value="';
  echo $PERCENT;
  echo '"><font size="3"> %</font>  上次进度值：';
  if (($PERCENT_MAX == ''))
  {
    echo 0;
  }
  echo '   （注：估计完成量与总量的百分比）
     </td>
   </tr> 
   <tr>
     <td nowrap class="TableContent"> 进度详情：</td>
     <td class="TableData" colspan="1">
       <textarea name="PROGRESS" class="BigInput" cols="55" rows="5">';
  echo $PROGRESS;
  echo '</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);
  }
  echo '      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent">';
  echo '<s';
  echo 'pan id="ATTACH_LABEL">附件上传：</span></td>
      <td class="TableData">
        <input type="file" name="ATTACHMENT" size="27" class="BigInput" title="选择附件文件">
        <input type="button" class="BigButton" value="上传文件" onclick="upload_attach();">
        <input type="hidden" name="ATTACHMENT_ID_OLD" value="';
  echo $ATTACHMENT_ID;
  echo '">
        <input type="hidden" name="ATTACHMENT_NAME_OLD" value="';
  echo $ATTACHMENT_NAME;
  echo '">
      </td>
    </tr> 
    <tr>
      <td nowrap class="TableContent"> 提醒：</td>
      <td class="TableData">
';
  echo sms_remind (12);
  echo '      </td>
    </tr>           
   <tr>
    <td nowrap  class="TableControl" colspan="2" align="center">
      <input type="hidden" value="';
  echo $PLAN_ID;
  echo '" name="PLAN_ID">
      <input type="hidden" name="OP" value=""> 
      <input type="hidden" name="FLAG" value="">
      <input type="hidden" name="PERCENT_MAX" value="';
  echo $PERCENT_MAX;
  echo '">                 	
      <input type="hidden" name="ATTACHMENT_NAME" value="">      	
      <input type="hidden" value="';
  echo $DETAIL_ID1;
  echo '" name="DETAIL_ID1">      
      <input type="button" value="确定" class="BigButton" onclick="sendForm();">&nbsp;&nbsp;
      <input type="button" class="BigButton" value="关闭" onClick="window.close();" title="关闭窗口">
    </td>
  </form>
</table>
</body>
</html>';
?>
⌨️ 快捷键说明

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