index.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 313 行

PHP
313
字号
<?
  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 check_all()
{
 if(!document.all("email_select"))
    return;
 for (i=0;i<document.all("email_select").length;i++)
 {
   if(document.a';
  echo 'll("allbox").checked)
      document.all("email_select").item(i).checked=true;
   else
      document.all("email_select").item(i).checked=false;
 }
 if(i==0)
 {
   if(document.all("allbox").checked)
      document.all("email_select").checked=true;
   else
      document.all("email_select").checked=false;
 }
}
function check_one(el)
{
   if(!el.checked)
      document.all("allbo';
  echo 'x").checked=false;
}
function delete_mail()
{
  delete_str="";
  for(i=0;i<document.all("email_select").length;i++)
  {
      el=document.all("email_select").item(i);
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }
  if(i==0)
  {
      el=document.all("email_select");
      if(el.checked)
      {  val=el.value;
         delete_str+=val +';
  echo ' ",";
      }
  }
  if(delete_str=="")
  {
     alert("要删除日志,请至少选择其中一条。");
     return;
  }
  msg=\'确认要删除所选日志么?\';
  if(window.confirm(msg))
  {
    url="delete.php?DELETE_STR="+ delete_str +"&PAGE_START=';
  echo $PAGE_START;
  echo '&BOX_ID=';
  echo $BOX_ID;
  echo '";
    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.open(URL,null,"height=180,width=400,status=1,toolbar=no,menubar=no,locatio';
  echo 'n=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/diary.gif" WIDTH="18" HEIGHT="18" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 新建日志</span><br>
    </td>
  </tr>
</table>
<div align="center">
<input type="button" value="新建日志" class="BigButton" onClick="location=\'new\';" title="新建工作日志">
</div>
<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%" cellspaci';
  echo 'ng="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>
';
  $BEGIN_DATE = date ('Y-m-01', time ());
  $CUR_DATE = date ('Y-m-d', time ());
  $query1 = 'SELECT * from SYS_PARA where PARA_NAME=\'LOCK_TIME\'';
  $cursor1 = exequery ($connection, $query1);
  if ($ROW1 = mysql_fetch_array ($cursor1))
  {
    $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]);
  }
  $query = (((''.'SELECT * from DIARY where USER_ID=\'').$LOGIN_USER_ID).'\' order by DIA_DATE desc,DIA_ID desc limit 0,10');
  $cursor = exequery ($connection, $query);
  $DIA_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$DIA_COUNT;
    $DIA_ID = $ROW['DIA_ID'];
    $DIA_DATE = $ROW['DIA_DATE'];
    $DIA_DATE = strtok ($DIA_DATE, ' ');
    $DIA_TYPE = $ROW['DIA_TYPE'];
    $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)) ? '...' : ''));
    }
    $DIA_TYPE_DESC = get_code_name ($DIA_TYPE, 'DIARY_TYPE');
    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';
    }
    $query1 = (((''.'SELECT count(*) from DIARY_COMMENT where DIA_ID=\'').$DIA_ID).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW1 = mysql_fetch_array ($cursor1))
    {
      $COMMENT_COUNT = $ROW1[0];
    }
    echo '    <tr class="';
    echo $TableLine;
    echo '">
      <td nowrap align="center">
';
    if (((($DAYS == 0) OR (date ('Y-m-d', time ()) < date ('Y-m-d', strtotime ((('+'.$DAYS).'day'), strtotime ($DIA_DATE))))) AND ((((($W_START == '') AND ($W_END == '')) OR ((($W_START == '') AND ($W_END != '')) AND (compare_date ($DIA_DATE, $W_END) == 1))) OR ((($W_START != '') AND ($W_END == '')) AND (compare_date ($W_START, $DIA_DATE) == 1))) OR ((($W_START != '') AND ($W_END != '')) AND ((compare_date ($DIA_DATE, $W_END) == 1) OR (compare_date ($W_START, $DIA_DATE) == 1))))))
    {
      echo '          <input type="checkbox" name="email_select" value="';
      echo $DIA_ID;
      echo '" onClick="check_one(self);">
';
    }
    echo '      </td>
      <td nowrap align="center">';
    echo $DIA_DATE;
    echo '</td>
      <td nowrap align="center">';
    echo $DIA_TYPE_DESC;
    echo '</td>
      <td><a href="read.php?DIA_ID=';
    echo $DIA_ID;
    echo '">';
    echo $SUBJECT;
    echo '</a></td>
      <td>';
    echo attach_link ($ATTACHMENT_ID, $ATTACHMENT_NAME, 0, 1, 1);
    echo '</td>
      <td nowrap align="center">
';
    if ((0 < $COMMENT_COUNT))
    {
      echo '        <a href="read.php?DIA_ID=';
      echo $DIA_ID;
      echo '">查看</a>
';
    }
    echo '      </td>
      <td nowrap align="center">
';
    if (((($DAYS == 0) OR (date ('Y-m-d', time ()) < date ('Y-m-d', strtotime ((('+'.$DAYS).'day'), strtotime ($DIA_DATE))))) AND ((((($W_START == '') AND ($W_END == '')) OR ((($W_START == '') AND ($W_END != '')) AND (compare_date ($DIA_DATE, $W_END) == 1))) OR ((($W_START != '') AND ($W_END == '')) AND (compare_date ($W_START, $DIA_DATE) == 1))) OR ((($W_START != '') AND ($W_END != '')) AND ((compare_date ($DIA_DATE, $W_END) == 1) OR (compare_date ($W_START, $DIA_DATE) == 1))))))
    {
      echo '          <a href="edit.php?DIA_ID=';
      echo $DIA_ID;
      echo '">编辑</a>
';
    }
    echo '      </td>
    </tr>
';
  }
  if (($DIA_COUNT == 0))
  {
    message ('', '无日志记录');
    exit ();
  }
  else
  {
    echo '   <thead class="TableHeader">
      <td nowrap align="center" width="40">选择</td>
      <td nowrap align="center" width="80">日期 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
      <td nowrap align="center" width="100">日志类型</td>
      <td nowrap align="center">日志内容</td>
      <td nowrap align="center">附件</td>
      <td nowrap align="center" width="40">点评</td>
    ';
    echo '  <td nowrap align="center" width="40">操作</td>
   </thead>
   <tr class="TableControl">
     <td colspan="7">
       <input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();">
       <label for="allbox_for">全选</label> &nbsp;
       <input type="button"  value="删除" class="SmallButton" onClick="delete_mail();" title="删除所选日志"> &nbsp;
     </td>
   </tr>
 </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">
  <tr>
    <td class="Big"><img src="/images/menu/diary.gif" WIDTH="18" HEIGHT="18" align="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">
  <form action="search.php" name="form1" onsubmit="return CheckForm();">
    <tr>
      <td nowrap class="TableData">起始日期:</td>
      <td class="TableData"><input type="text" name="BEGIN_DATE" size="10" maxlength="10" class';
  echo '="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">
        ';
  echo '<s';
  echo 'elect name="DIA_TYPE" class="BigSelect">
          <option value="0">所有类型</option>
          ';
  echo code_list ('DIARY_TYPE', '');
  echo '        </select>
      </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="KEY1" class="BigInput" size="20"></td>
    </tr>
    <tr>
      <td nowrap class="TableData">

⌨️ 快捷键说明

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