search.php

通达OA2007SE源代码 非常好的

    $TO_ID2 = $ROW['TO_ID2'];
    $READ_FLAG = $ROW['READ_FLAG'];
    $SUBJECT = $ROW['SUBJECT'];
    $CONTENT = $ROW['CONTENT'];
    $IMPORTANT = $ROW['IMPORTANT'];
    $SIZE = $ROW['SIZE'];
    $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
    $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
    $SUBJECT = htmlspecialchars ($SUBJECT);
    $SEND_TIME = substr ($ROW['SEND_TIME'], 0, -3);
    $EMAIL_SIZE = ((strlen ($CONTENT) + strlen ($SUBJECT)) + $SIZE);
    if ((0 < floor ((($EMAIL_SIZE / 1024) / 1024))))
    {
      $EMAIL_SIZE = (round ((($EMAIL_SIZE / 1024) / 1024), 1).'M');
    }
    else
    {
      $EMAIL_SIZE = (ceil (($EMAIL_SIZE / 1024)).'K');
    }
    if ((($IMPORTANT == '0') OR ($IMPORTANT == '')))
    {
      $IMPORTANT_DESC = '';
    }
    else
    {
      if (($IMPORTANT == '1'))
      {
        $IMPORTANT_DESC = '<span class="TextColor1">重要</span>';
      }
      else
      {
        if (($IMPORTANT == '2'))
        {
          $IMPORTANT_DESC = '<span class="TextColor2">非常重要</span>';
        }
      }
    }
    $GROUP_COUNT = 1;
    if ((($BOX_ID == 0) AND ($BOX == 3)))
    {
      $EMAIL_ID_STR = '';
      $query = ((''.'select EMAIL_ID from EMAIL where BODY_ID=').$BODY_ID);
      $cursor1 = exequery ($connection, $query);
      $GROUP_COUNT = mysql_num_rows ($cursor1);
      while ($ROW1 = mysql_fetch_array ($cursor1))
      {
        ($EMAIL_ID_STR .= ($ROW1['EMAIL_ID'].','));
      }
      $EMAIL_ID_STR = substr ($EMAIL_ID_STR, 0, -1);
    }
    else
    {
      $EMAIL_ID_STR = $EMAIL_ID;
    }
    if (($BOX == 1))
    {
      $query1 = (((''.'SELECT USER_NAME,DEPT_ID from USER where USER_ID=\'').$FROM_ID).'\'');
    }
    else
    {
      $query1 = (((''.'SELECT USER_NAME,DEPT_ID from USER where USER_ID=\'').$TO_ID).'\'');
    }
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $FROM_TO_NAME = $ROW['USER_NAME'];
      $DEPT_ID = $ROW['DEPT_ID'];
      $DEPT_NAME = dept_long_name ($DEPT_ID);
    }
    else
    {
      $FROM_TO_NAME = $FROM_ID;
      $AVATAR = '';
      $DEPT_NAME = '用户已删除';
    }
    if (($BOX == 2))
    {
      $FROM_TO_NAME = '';
      $query1 = (((''.'SELECT USER_NAME from USER where find_in_set(USER_ID,\'').$TO_ID).'\')');
      $cursor1 = exequery ($connection, $query1);
      while ($ROW = mysql_fetch_array ($cursor1))
      {
        ($FROM_TO_NAME .= ($ROW['USER_NAME'].','));
      }
    }
    if ((($LETER_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '    <tr class="';
    echo $TableLine;
    echo '">
      <td>&nbsp;<input type="checkbox" name="email_select" value="';
    echo $EMAIL_ID_STR;
    echo '" onClick="check_one(self);"></td>
      <td nowrap align="center">
';
    if ((1 < $GROUP_COUNT))
    {
      echo '       <a href="javascript:read_status(\'';
      echo $EMAIL_ID;
      echo '\');">查看</a>
';
    }
    else
    {
      if (($BOX != 2))
      {
        echo '      <u title="部门：';
        echo $DEPT_NAME;
        echo '" style="cursor:hand">';
        echo $FROM_TO_NAME;
        echo '</u>
';
      }
      else
      {
        echo '      ';
        echo $FROM_TO_NAME;
      }
    }
    echo '      </td>
      <td><a href="';
    echo $BOX_URL;
    echo '?EMAIL_ID=';
    echo $EMAIL_ID;
    echo '&BOX_ID=';
    echo $BOX_ID;
    echo '&QUERY=1">';
    echo $SUBJECT;
    echo '</a> ';
    echo $IMPORTANT_DESC;
    echo '</td>
      <td>';
    echo attach_link ($ATTACHMENT_ID, $ATTACHMENT_NAME, 0, (($READ_FLAG OR ($BOX == 2)) OR ($BOX == 3)), 1);
    echo '</td>
      </td>
      <td nowrap align="center">';
    echo $SEND_TIME;
    echo '</td>
      <td nowrap align="center">';
    echo $EMAIL_SIZE;
    echo '</td>
      <td nowrap align="center">
';
    if (($GROUP_COUNT == 1))
    {
      if ((($BOX_ID == 0) AND ($BOX == 3)))
      {
        if (($READ_FLAG == '0'))
        {
          echo '      <a href="';
          echo $BOX_URL1;
          echo 'edit_email.php?PAGE_START=';
          echo $PAGE_START;
          echo '&EMAIL_ID=';
          echo $EMAIL_ID;
          echo '"> 编辑</a>&nbsp;
';
        }
        echo '      <a href="';
        echo $BOX_URL1;
        echo 'resend.php?EMAIL_ID=';
        echo $EMAIL_ID;
        echo '"> 再次发送</a>&nbsp;
';
      }
    }
    echo '      </td>
    </tr>
';
  }
  if ((0 < $LETER_COUNT))
  {
    echo '<tr class="TableControl">
<td colspan="10">
      <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();"> &nbsp;
      <input type="button"  value="导出Excel" class="SmallButton" onClick="export_mail();" title="批量导出"> &nbsp;
      <input ty';
    echo 'pe="button"  value="导出eml" class="SmallButton" onClick="export_eml();" title="单独导出"> &nbsp;
</td>
</tr>
  </table>
';
  }
  else
  {
    message ('', '<br>未找到符合条件的邮件');
  }
  echo '
<br>
<div align="center">
 <input type="button"  value="返回" class="BigButton" onClick="location=\'index.php\';">
</div>
';
  echo '<S';
  echo 'CRIPT>
function export_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;
  }
  window.open(\'../export_bat.php?DELETE_STR=\'+ delete_str);
}
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 + ",";
';
  echo '
      }
  }
  if(i==0)
  {
      el=document.all("email_select");
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }
  if(delete_str=="")
  {
     alert("要删除邮件，请至少选择其中一封。");
     return;
  }
  msg=\'确认要删除所选邮件么？\';
  if(window.confirm(msg))
  {
    url="';
  echo $BOX_URL1;
  echo 'delete.php?BOX_ID=';
  echo $BOX_ID;
  echo '&DELETE_STR="+ delete_str +"&PAGE_START=';
  echo $PAGE_START;
  echo '";
    location=url;
  }
}
function export_eml()
{
  count=0;
  for(i=0;i<document.all("email_select").length;i++)
  {
      el=document.all("email_select").item(i);
      if(el.checked)
      {  email_id=el.value;
         count++;
      }
  }
  if(i==0)
  {
      el=document.all("email_select");
      if(el.checked)
      {  email_id=el.value;
         count++;
      }
  }';
  echo '
  if(count>1)
  {
     alert("每次只能导出一封。");
     return;
  }
  if(count==0)
  {
     alert("要导出邮件，请至少选择其中一封");
     return;
  }
  window.location=\'../export.php?EMAIL_ID=\'+ email_id;
}
</SCRIPT>
</body>
</html>
';
?>