bat_user_res.php

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

<?
  function delete_children ($SORT_PARENT)
  {
    global $connection;
    global $EXOPORT_STR;
    global $ATTACH_PATH;
    global $EXPORT_PATH;
    $query = (((''.'select * from FILE_CONTENT where SORT_ID=').$SORT_PARENT).' and ATTACHMENT_ID!=\'\'');
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
      $ATTACHMENT_NAME = $ROW['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)
      {
        if (($ATTACHMENT_ID_ARRAY[$I] == ''))
        {
          continue;
        }
        else
        {
          if (strstr ($ATTACHMENT_ID_ARRAY[$I], '_'))
          {
            $FILE_SRC = (('"'.str_replace ('/', '\\', attach_real_path ($ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I], 'file_folder'))).'"');
            $FILE_DES = ((($EXPORT_PATH.'email\\').substr ($ATTACHMENT_ID_ARRAY[$I], 0, strpos ($ATTACHMENT_ID_ARRAY[$I], '_'))).'\\');
          }
          else
          {
            $FILE_SRC = (str_replace ('/', '\\', $ATTACH_PATH).$ATTACHMENT_ID_ARRAY[$I]);
            $FILE_DES = (($EXPORT_PATH.$ATTACHMENT_ID_ARRAY[$I]).'\\');
          }
          ($EXOPORT_STR .= (((('xcopy /Q/R/Y '.$FILE_SRC).' ').$FILE_DES).'
'));
          continue;
        }
      }
    }
    $query = ((''.'select * from FILE_SORT where SORT_PARENT=').$SORT_PARENT);
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $SORT_ID = $ROW['SORT_ID'];
      delete_children ($SORT_ID);
    }
  }
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  $USER_ID_STR = substr ($TO_ID, 0, -1);
  if ((substr ($EXPORT_PATH, -1) != '\\'))
  {
    ($EXPORT_PATH .= '\\');
  }
  $EXPORT_PATH = str_replace ('\\\\', '\\', $EXPORT_PATH);
  if (($EMAIL == 'on'))
  {
    $query = (((((''.'select * from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and ATTACHMENT_ID!=\'\' and FIND_IN_SET(FROM_ID, \'').$USER_ID_STR).'\') or FIND_IN_SET(TO_ID, \'').$USER_ID_STR).'\') group by EMAIL.BODY_ID');
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
      $ATTACHMENT_NAME = $ROW['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)
      {
        if (($ATTACHMENT_ID_ARRAY[$I] == ''))
        {
          continue;
        }
        else
        {
          if (strstr ($ATTACHMENT_ID_ARRAY[$I], '_'))
          {
            $FILE_SRC = (('"'.str_replace ('/', '\\', attach_real_path ($ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I], 'email'))).'"');
            $FILE_DES = ((($EXPORT_PATH.'email\\').substr ($ATTACHMENT_ID_ARRAY[$I], 0, strpos ($ATTACHMENT_ID_ARRAY[$I], '_'))).'\\');
          }
          else
          {
            $FILE_SRC = (str_replace ('/', '\\', $ATTACH_PATH).$ATTACHMENT_ID_ARRAY[$I]);
            $FILE_DES = (($EXPORT_PATH.$ATTACHMENT_ID_ARRAY[$I]).'\\');
          }
          ($EXOPORT_STR .= (((('xcopy /Q/R/Y '.$FILE_SRC).' ').$FILE_DES).'
'));
          continue;
        }
      }
    }
  }
  if (($FOLDER == 'on'))
  {
    $query = (((''.'select * from FILE_SORT where SORT_TYPE=\'4\' and SORT_PARENT=0 and FIND_IN_SET(USER_ID, \'').$USER_ID_STR).'\')');
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $SORT_ID = $ROW['SORT_ID'];
      delete_children ($SORT_ID);
    }
    $query = (((''.'select * from FILE_CONTENT where SORT_ID=0 and ATTACHMENT_ID!=\'\' and FIND_IN_SET(USER_ID, \'').$USER_ID_STR).'\')');
    $cursor = exequery ($connection, $query);
    while ($ROW1 = mysql_fetch_array ($cursor))
    {
      $ATTACHMENT_ID = $ROW1['ATTACHMENT_ID'];
      $ATTACHMENT_NAME = $ROW1['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)
      {
        if (($ATTACHMENT_ID_ARRAY[$I] == ''))
        {
          continue;
        }
        else
        {
          if (strstr ($ATTACHMENT_ID_ARRAY[$I], '_'))
          {
            $FILE_SRC = (('"'.str_replace ('/', '\\', attach_real_path ($ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I], 'file_folder'))).'"');
            $FILE_DES = ((($EXPORT_PATH.'email\\').substr ($ATTACHMENT_ID_ARRAY[$I], 0, strpos ($ATTACHMENT_ID_ARRAY[$I], '_'))).'\\');
          }
          else
          {
            $FILE_SRC = (str_replace ('/', '\\', $ATTACH_PATH).$ATTACHMENT_ID_ARRAY[$I]);
            $FILE_DES = (($EXPORT_PATH.$ATTACHMENT_ID_ARRAY[$I]).'\\');
          }
          ($EXOPORT_STR .= (((('xcopy /Q/R/Y '.$FILE_SRC).' ').$FILE_DES).'
'));
          continue;
        }
      }
    }
  }
  if (($DIARY == 'on'))
  {
    $query = (((''.'select * from DIARY where FIND_IN_SET(USER_ID, \'').$USER_ID_STR).'\')');
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
      $ATTACHMENT_NAME = $ROW['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)
      {
        if (($ATTACHMENT_ID_ARRAY[$I] == ''))
        {
          continue;
        }
        else
        {
          if (strstr ($ATTACHMENT_ID_ARRAY[$I], '_'))
          {
            $FILE_SRC = (('"'.str_replace ('/', '\\', attach_real_path ($ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I], 'diary'))).'"');
            $FILE_DES = ((($EXPORT_PATH.'email\\').substr ($ATTACHMENT_ID_ARRAY[$I], 0, strpos ($ATTACHMENT_ID_ARRAY[$I], '_'))).'\\');
          }
          else
          {
            $FILE_SRC = (str_replace ('/', '\\', $ATTACH_PATH).$ATTACHMENT_ID_ARRAY[$I]);
            $FILE_DES = (($EXPORT_PATH.$ATTACHMENT_ID_ARRAY[$I]).'\\');
          }
          ($EXOPORT_STR .= (((('xcopy /Q/R/Y '.$FILE_SRC).' ').$FILE_DES).'
'));
          continue;
        }
      }
    }
  }
  ob_end_clean ();
  header ('Cache-control: private');
  header ('Content-type: application/octet-stream');
  header ('Accept-Ranges: bytes');
  header ('Content-Disposition: attachment; filename=指定用户.bat');
  if (($EXOPORT_STR != ''))
  {
    echo (('@echo 正在导出指定用户附件...
'.$EXOPORT_STR).'
@echo 指定用户附件导出完毕!
pause');
  }
  else
  {
    echo '@echo 无符合条件的指定用户附件
pause';
  }
?>