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 + -
显示快捷键?