submit.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 163 行
PHP
163 行
<?
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 ();
}
else
{
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';
}
}
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?