submit.php

来自「极限网络智能办公系统 Office Automation V3.0官方100%源」· PHP 代码 · 共 159 行

PHP
159
字号
<?
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 + =
减小字号Ctrl + -
显示快捷键?