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

📄 user_diary.php

📁 通达OA2007SE源代码 非常好的
💻 PHP
字号:
🔍 
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>工作日志查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
function CheckForm()
{
   if(document.form1.BEGIN_DATE.value=="")
   { alert("起始日期不能为空！");
     return (false);
   }
   if(document.form1.END_DATE.value=="")
   { alert("截止日期不能为空！");
     return (false);
   }
   return true;
}
function td_calendar(fieldname)
{
  myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
  mytop=document.body.scro';
  echo 'llTop+event.clientY-event.offsetY+140;
  window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
function SaveFile(ATTACHMENT_ID,ATTACHMENT_NAME)
{
  URL="/module/save_file?ATTACHMENT_ID="+ATTACHMENT_ID+"&ATTACHMENT_NAME="+ATTACHMENT_NAME+"&A=1';
  echo '";
  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
  loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
  window.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">
';
  $BEGIN_DATE = date ('Y-m-01', time ());
  $CUR_DATE = date ('Y-m-d', time ());
  $query = (((''.'SELECT * from USER where USER_ID=\'').$USER_ID).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $USER_NAME = $ROW['USER_NAME'];
  }
  echo '
<div align="center" class="Big1">
<b>[';
  echo $USER_NAME;
  echo ' - 工作日志查询]</b>
</div>
<br>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/diary.gif" WIDTH="18" HEIGHT="18" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 最近的10篇日志</span>
    </td>
  </tr>
</table>
';
  $query = (((''.'SELECT * from DIARY where USER_ID=\'').$USER_ID).'\' and DIA_TYPE!=\'2\' order by DIA_DATE desc');
  $cursor = exequery ($connection, $query);
  $DIA_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$DIA_COUNT;
    if ((10 < $DIA_COUNT))
    {
      break;
    }
    $DIA_ID = $ROW['DIA_ID'];
    $DIA_DATE = $ROW['DIA_DATE'];
    $DIA_DATE = strtok ($DIA_DATE, ' ');
    $SUBJECT = $ROW['SUBJECT'];
    $CONTENT = $ROW['CONTENT'];
    $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
    $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
    if (($SUBJECT == ''))
    {
      $SUBJECT = (csubstr (strip_tags ($CONTENT), 0, 50).((50 < strlen ($CONTENT)) ? '...' : ''));
    }
    if (($DIA_COUNT == 1))
    {
      echo '
   <table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
';
    }
    if ((($DIA_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '   <tr class="';
    echo $TableLine;
    echo '">
     <td nowrap align="center" width="100">';
    echo $DIA_DATE;
    echo '</td>
     <td><a href="read.php?DIA_ID=';
    echo $DIA_ID;
    echo '&USER_NAME=';
    echo $USER_NAME;
    echo '">';
    echo $SUBJECT;
    echo '</a></td>
      <td>
';
    if (($ATTACHMENT_NAME != ''))
    {
      $ATTACHMENT_ID_ARRAY = explode (',', $ATTACHMENT_ID);
      $ATTACHMENT_NAME_ARRAY = explode ('*', $ATTACHMENT_NAME);
      $ARRAY_COUNT = sizeof ($ATTACHMENT_ID_ARRAY);
      for ($I = 0; ($I < ($ARRAY_COUNT - 1)); ++$I)
      {
        $ATTACH_SIZE = attach_size ($ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I]);
        $ATTACH_SIZE = number_format ($ATTACH_SIZE, 0, '.', ',');
        echo '       <img src="/images/email_atta.gif" align="absmiddle"><a href="/inc/attach.php?ATTACHMENT_ID=';
        echo (($ATTACHMENT_ID_ARRAY[$I] * 3) + 2);
        echo '&ATTACHMENT_NAME=';
        echo urlencode ($ATTACHMENT_NAME_ARRAY[$I]);
        echo '">';
        echo $ATTACHMENT_NAME_ARRAY[$I];
        echo '</a>
       (';
        echo $ATTACH_SIZE;
        echo '字节)
     	 <input type="button" value="转存" class="SmallButton" onClick="SaveFile(\'';
        echo (($ATTACHMENT_ID_ARRAY[$I] * 3) + 2);
        echo '\',\'';
        echo urlencode ($ATTACHMENT_NAME_ARRAY[$I]);
        echo '\');">&nbsp;
';
        if (((stristr ($ATTACHMENT_NAME_ARRAY[$I], '.doc') OR stristr ($ATTACHMENT_NAME_ARRAY[$I], '.ppt')) OR stristr ($ATTACHMENT_NAME_ARRAY[$I], '.xls')))
        {
          echo '	<input type="button" value="阅读" class="SmallButton" onClick="window.open(\'/module/OC?ATTACHMENT_ID=';
          echo (($ATTACHMENT_ID_ARRAY[$I] * 3) + 2);
          echo '&ATTACHMENT_NAME=';
          echo urlencode ($ATTACHMENT_NAME_ARRAY[$I]);
          echo '&OP=5&PRINT=1\',\'';
          echo $ATTACHMENT_ID_ARRAY[$I];
          echo '\',\'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1\');">
';
        }
        else
        {
          if (is_media ($ATTACHMENT_NAME_ARRAY[$I]))
          {
            echo '	       <input type="button" value="播放" class="SmallButton" onClick="window.open(\'/module/mediaplayer/index.php?MEDIA_NAME=';
            echo urlencode ($ATTACHMENT_NAME_ARRAY[$I]);
            echo '&MEDIA_URL=';
            echo urlencode (((('/inc/attach.php?ATTACHMENT_ID='.(($ATTACHMENT_ID_ARRAY[$I] * 3) + 2)).'&ATTACHMENT_NAME=').urlencode ($ATTACHMENT_NAME_ARRAY[$I])));
            echo '\',\'media';
            echo $ATTACHMENT_ID_ARRAY[$I];
            echo '\',\'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1\');">&nbsp;
';
          }
        }
        echo '<br>';
      }
    }
    echo '      </td>
     <td nowrap align="center" width="60"><a href="comment.php?DIA_ID=';
    echo $DIA_ID;
    echo '&USER_ID=';
    echo $USER_ID;
    echo '">点评</a></td>
   </tr>
';
  }
  if (($DIA_COUNT == 0))
  {
    message ('', '无日志记录');
    exit ();
  }
  else
  {
    echo '  <thead class="TableHeader">
     <td nowrap align="center">日期 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
     <td nowrap align="center">日志标题</td>
      <td nowrap align="center">附件</td>
     <td nowrap align="center">操作</td>
  </thead>
  </table>
';
  }
  echo '
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
 <tr>
   <td background="/images/dian1.gif" width="100%"></td>
 </tr>
</table>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<form action="search.php" name="form1" onsubmit="return CheckForm();">
  <tr>
    <td class="Big"><img src="/images/menu/diary.gif" WIDTH="18" HEIGHT="18" align=';
  echo '"absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 日志查询</span>
    </td>
  </tr>
</table>
<table border="0" width="400" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
  <tr>
    <td nowrap class="TableData">起始日期：</td>
    <td class="TableData"><input type="text" name="BEGIN_DATE" size="10" maxlength="10" class="BigInput" value="';
  echo $BEGIN_DATE;
  echo '">
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.BEGIN_DATE\');">
    </td>
  </tr>
  <tr>
    <td nowrap class="TableData">截止日期：</td>
    <td class="TableData"><input type="text" name="END_DATE" size="10" maxlength="10" class="BigInput" value="';
  echo $CUR_DATE;
  echo '">
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.END_DATE\');">
    </td>
  </tr>
    <tr>
      <td nowrap class="TableData">标题：</td>
      <td class="TableData"><input type="text" name="SUBJECT" class="BigInput" size="20"></td>
    </tr>
  <tr>
    <td nowrap class="TableData">关键词1：</td>
    <td class="TableData"><input type="text" name=';
  echo '"KEY1" class="BigInput" size="20"></td>
  </tr>
  <tr>
    <td nowrap class="TableData">关键词2：</td>
    <td class="TableData"><input type="text" name="KEY2" class="BigInput" size="20"></td>
  </tr>
  <tr>
    <td nowrap class="TableData">关键词3：</td>
    <td class="TableData"><input type="text" name="KEY3" class="BigInput" size="20"></td>
  </tr>
  <tr >
    <td nowrap class="TableControl" colspan="';
  echo '2" align="center">
        <input type="hidden" name="USER_ID" value="';
  echo $USER_ID;
  echo '">
        <input type="hidden" name="USER_NAME" value="';
  echo $USER_NAME;
  echo '">
        <input type="submit" value="查询" class="BigButton" title="进行查询" name="button">
    </td>
  </tr>
  </form>
</table>
</body>
</html>
';
?>

⌨️ 快捷键说明

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