📄 submit.php
字号:
<?
/* King DeZender(http://www.dezend.org) 2006-03-01 */
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">
';
if ($OP == '2')
{
if (substr ($EXPORT_PATH, 0, -1) != '\\')
{
$EXPORT_PATH .= '\\';
}
$EXPORT_PATH = str_replace ('\\\\', '\\', $EXPORT_PATH);
}
$query = 'SELECT * from FLOW_RUN,FLOW_RUN_PRCS where FLOW_RUN.RUN_ID=FLOW_RUN_PRCS.RUN_ID and FLOW_ID=' . $FLOW_ID . ' and PRCS_ID=1 ';
if ($BEGIN_DATE != '')
{
$query .= ' and PRCS_TIME>=\'' . $BEGIN_DATE . ' 00:00:00\'';
}
if ($END_DATE != '')
{
$query .= ' and PRCS_TIME<=\'' . $END_DATE . ' 23:59:59\'';
}
$COUNT = 0;
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
++$COUNT;
$RUN_ID = $ROW['RUN_ID'];
$PRCS_TIME = $ROW['PRCS_TIME'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
if ($OP == 1)
{
if ($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; ++$I)
{
if ($ATTACHMENT_ID_ARRAY[$I] != '')
{
delete_attach ($ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I]);
continue;
}
}
}
$query1 = 'select * from FLOW_RUN_FEEDBACK where RUN_ID=' . $RUN_ID;
$cursor1 = exequery ($connection, $query1);
$ATTACHMENT_NAME = '';
while ($ROW = mysql_fetch_array ($cursor1))
{
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
if ($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; ++$I)
{
if ($ATTACHMENT_ID_ARRAY[$I] != '')
{
delete_attach ($ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I]);
continue;
}
}
continue;
}
}
$query = 'delete from FLOW_RUN_FEEDBACK where RUN_ID=' . $RUN_ID;
exequery ($connection, $query);
$query = 'delete from FLOW_RUN_DATA where RUN_ID=' . $RUN_ID;
exequery ($connection, $query);
$query = 'delete from FLOW_RUN_PRCS where RUN_ID=' . $RUN_ID;
exequery ($connection, $query);
$query = 'delete from FLOW_RUN where RUN_ID=' . $RUN_ID;
exequery ($connection, $query);
continue;
}
else
{
$PRCS_TIME = str_replace (':', '.', $PRCS_TIME);
$PRCS_TIME = str_replace (' ', '~', $PRCS_TIME);
$OUT_PATH = $EXPORT_PATH . $PRCS_TIME;
$ATTACH_PATH = str_replace ('/', '\\', $ATTACH_PATH);
if ($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; ++$I)
{
if ($ATTACHMENT_ID_ARRAY[$I] != '')
{
$PATH = $ATTACH_PATH . $ATTACHMENT_ID_ARRAY[$I];
$EXOPORT_STR .= 'xcopy /y ' . $PATH . ' ' . $OUT_PATH . '\\公共附件\\
';
continue;
}
}
}
$query1 = 'select * from FLOW_RUN_FEEDBACK where RUN_ID=' . $RUN_ID;
$cursor1 = exequery ($connection, $query1);
$ATTACHMENT_NAME = '';
while ($ROW = mysql_fetch_array ($cursor1))
{
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
if ($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; ++$I)
{
if ($ATTACHMENT_ID_ARRAY[$I] != '')
{
$PATH = $ATTACH_PATH . $ATTACHMENT_ID_ARRAY[$I];
$EXOPORT_STR .= 'xcopy /y ' . $PATH . ' ' . $OUT_PATH . '\\会签附件\\
';
continue;
}
}
continue;
}
}
continue;
}
}
if ($OP == 1)
{
message ('提示', '共删除 ' . $COUNT . ' 项工作的数据');
button_back ();
return 1;
}
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';
return 1;
}
echo '@echo 无符合条件的工作流附件
pause';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -