copy_sort.php

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

PHP
161
字号
<?
  function copy_sort ($SORT_PARENT, $SORT_PARENT_NEW, $USER_ID, $MANAGE_USER, $DOWN_USER, $NEW_USER)
  {
    global $connection;
    global $LOGIN_USER_ID;
    $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'];
      $SORT_NAME = $ROW['SORT_NAME'];
      $SORT_NO = $ROW['SORT_NO'];
      $SORT_TYPE = $ROW['SORT_TYPE'];
      $DEPT_ID = $ROW['DEPT_ID'];
      $query = (((((((((((((((((((((''.'insert into FILE_SORT(SORT_TYPE,DEPT_ID,SORT_NO,SORT_PARENT,SORT_NAME,USER_ID,MANAGE_USER,DOWN_USER,NEW_USER,SHARE_USER) values (\'').$SORT_TYPE).'\',\'').$DEPT_ID).'\',\'').$SORT_NO).'\',\'').$SORT_PARENT_NEW).'\',\'').$SORT_NAME).'\',\'').$USER_ID).'\',\'').$MANAGE_USER).'\',\'').$DOWN_USER).'\',\'').$NEW_USER).'\',\'').$SHARE_USER).'\')');
      exequery ($connection, $query);
      $SORT_PARENT_NEW1 = mysql_insert_id ();
      $query = ((''.'SELECT * from FILE_CONTENT where SORT_ID=').$SORT_ID);
      $cursor1 = exequery ($connection, $query);
      while ($ROW = mysql_fetch_array ($cursor1))
      {
        $SUBJECT = $ROW['SUBJECT'];
        $CONTENT = $ROW['CONTENT'];
        $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
        $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
        $ATTACHMENT_DESC = $ROW['ATTACHMENT_DESC'];
        $CONTENT_NO = $ROW['CONTENT_NO'];
        $SEND_TIME = date ('Y-m-d H:i:s', time ());
        if ((($ATTACHMENT_ID != '') AND ($ATTACHMENT_NAME != '')))
        {
          $ATTACHMENT_ID = (copy_attach ($ATTACHMENT_ID, $ATTACHMENT_NAME).',');
        }
        $query = (((((((((((((((((((''.'insert into FILE_CONTENT(SORT_ID,SUBJECT,CONTENT,SEND_TIME,ATTACHMENT_ID,ATTACHMENT_NAME,ATTACHMENT_DESC,USER_ID,CONTENT_NO) values (').$SORT_PARENT_NEW1).',\'').$SUBJECT).'\',\'').$CONTENT).'\',\'').$SEND_TIME).'\',\'').$ATTACHMENT_ID).'\',\'').$ATTACHMENT_NAME).'\',\'').$ATTACHMENT_DESC).'\',\'').$USER_ID).'\',\'').$CONTENT_NO).'\')');
        exequery ($connection, $query);
      }
      copy_sort ($SORT_ID, $SORT_PARENT_NEW1, $USER_ID, $MANAGE_USER, $DOWN_USER, $NEW_USER);
    }
  }
  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">
</head>
<body class="bodycolor" topmargin="5" onload="">
';
  if (!stristr ($HTTP_REFERER, '/general/file_folder/index.php'))
  {
    exit ();
  }
  if (($SORT == 0))
  {
    $query = (((''.'SELECT * from FILE_CONTENT where find_in_set(CONTENT_ID,\'').$FILE_STR).'\')');
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $SUBJECT = $ROW['SUBJECT'];
      $CONTENT = $ROW['CONTENT'];
      $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
      $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
      $ATTACHMENT_DESC = $ROW['ATTACHMENT_DESC'];
      $USER_ID = $ROW['USER_ID'];
      $CONTENT_NO = $ROW['CONTENT_NO'];
      $SEND_TIME = date ('Y-m-d H:i:s', time ());
      if (($SORT_PARENT == 0))
      {
        $USER_ID = $LOGIN_USER_ID;
      }
      if ((($ATTACHMENT_ID != '') AND ($ATTACHMENT_NAME != '')))
      {
        $ATTACHMENT_ID = (copy_attach ($ATTACHMENT_ID, $ATTACHMENT_NAME).',');
      }
      $query = (((((((((((((((((((''.'insert into FILE_CONTENT(SORT_ID,SUBJECT,CONTENT,SEND_TIME,ATTACHMENT_ID,ATTACHMENT_NAME,ATTACHMENT_DESC,USER_ID,CONTENT_NO) values (\'').$SORT_PARENT).'\',\'').$SUBJECT).'\',\'').$CONTENT).'\',\'').$SEND_TIME).'\',\'').$ATTACHMENT_ID).'\',\'').$ATTACHMENT_NAME).'\',\'').$ATTACHMENT_DESC).'\',\'').$USER_ID).'\',\'').$CONTENT_NO).'\')');
      exequery ($connection, $query);
    }
  }
  else
  {
    if (($SORT == 1))
    {
      $query = (((''.'SELECT * from FILE_SORT where SORT_ID=\'').$SORT_ID).'\'');
      $cursor = exequery ($connection, $query);
      if ($ROW = mysql_fetch_array ($cursor))
      {
        $SORT_NAME = $ROW['SORT_NAME'];
        $SORT_NO = $ROW['SORT_NO'];
        $SORT_TYPE = $ROW['SORT_TYPE'];
        $DEPT_ID = $ROW['DEPT_ID'];
        $USER_ID_PARENT = $ROW['USER_ID'];
        $MANAGE_USER_PARENT = $ROW['MANAGE_USER'];
        $DOWN_USER_PARENT = $ROW['DOWN_USER'];
        $NEW_USER_PARENT = $ROW['NEW_USER'];
        if (($SORT_PARENT == 0))
        {
          $USER_ID_PARENT = $LOGIN_USER_ID;
          $SORT_TYPE = 4;
        }
        else
        {
          $query = (((''.'SELECT * from FILE_SORT where SORT_ID=\'').$SORT_PARENT).'\'');
          $cursor = exequery ($connection, $query);
          if ($ROW = mysql_fetch_array ($cursor))
          {
            $USER_ID_PARENT = $ROW['USER_ID'];
            $MANAGE_USER_PARENT = $ROW['MANAGE_USER'];
            $DOWN_USER_PARENT = $ROW['DOWN_USER'];
            $NEW_USER_PARENT = $ROW['NEW_USER'];
          }
        }
        $query = (((((((((((((((((((((''.'insert into FILE_SORT(SORT_TYPE,DEPT_ID,SORT_NO,SORT_PARENT,SORT_NAME,USER_ID,MANAGE_USER,DOWN_USER,NEW_USER,SHARE_USER) values (\'').$SORT_TYPE).'\',\'').$DEPT_ID).'\',\'').$SORT_NO).'\',\'').$SORT_PARENT).'\',\'').$SORT_NAME).'\',\'').$USER_ID_PARENT).'\',\'').$MANAGE_USER_PARENT).'\',\'').$DOWN_USER_PARENT).'\',\'').$NEW_USER_PARENT).'\',\'').$SHARE_USER).'\')');
        exequery ($connection, $query);
        $SORT_PARENT_NEW = mysql_insert_id ();
        $query = ((''.'SELECT * from FILE_CONTENT where SORT_ID=').$SORT_ID);
        $cursor1 = exequery ($connection, $query);
        while ($ROW = mysql_fetch_array ($cursor1))
        {
          $SUBJECT = $ROW['SUBJECT'];
          $CONTENT = $ROW['CONTENT'];
          $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
          $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
          $ATTACHMENT_DESC = $ROW['ATTACHMENT_DESC'];
          $CONTENT_NO = $ROW['CONTENT_NO'];
          $SEND_TIME = date ('Y-m-d H:i:s', time ());
          if (($SORT_PARENT == 0))
          {
            $USER_ID = $LOGIN_USER_ID;
          }
          if ((($ATTACHMENT_ID != '') AND ($ATTACHMENT_NAME != '')))
          {
            $ATTACHMENT_ID = (copy_attach ($ATTACHMENT_ID, $ATTACHMENT_NAME).',');
          }
          $query = (((((((((((((((((((''.'insert into FILE_CONTENT(SORT_ID,SUBJECT,CONTENT,SEND_TIME,ATTACHMENT_ID,ATTACHMENT_NAME,ATTACHMENT_DESC,USER_ID,CONTENT_NO) values (').$SORT_PARENT_NEW).',\'').$SUBJECT).'\',\'').$CONTENT).'\',\'').$SEND_TIME).'\',\'').$ATTACHMENT_ID).'\',\'').$ATTACHMENT_NAME).'\',\'').$ATTACHMENT_DESC).'\',\'').$USER_ID).'\',\'').$CONTENT_NO).'\')');
          exequery ($connection, $query);
        }
        copy_sort ($SORT_ID, $SORT_PARENT_NEW, $USER_ID_PARENT, $MANAGE_USER_PARENT, $DOWN_USER_PARENT, $NEW_USER_PARENT);
      }
    }
  }
  echo '<s';
  echo 'cript Language="JavaScript">
';
  if (($SORT == 1))
  {
    echo '   parent.file_tree.location.reload();
';
  }
  echo '   window.location="folder.php?SORT_ID=';
  echo $SORT_ID;
  echo '&FILE_SORT=';
  echo $FILE_SORT;
  echo '&start=';
  echo $start;
  echo '";
</script>
</body>
</html>
';
?>

⌨️ 快捷键说明

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