📄 insert.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
字号:
<?php

include_once( "inc/auth.php" );
echo "\r\n<html>\r\n<head>\r\n<title></title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$connection = openconnection( );
if ( 0 < $_REQUEST['FLOW_TEMPLATE_ID'] )
{
	$sql = "SELECT * FROM flow_type WHERE FLOW_ID=".$_REQUEST['FLOW_TEMPLATE_ID'];
	$rs = exequery( $connection, $sql );
	$row = mysql_fetch_array( $rs );
	$FORM_ID = $row['FORM_ID'];
	$FLOW_DOC = $row['FLOW_DOC'];
	$FLOW_TYPE = $row['FLOW_TYPE'];
	$MANAGE_USER = $row['MANAGE_USER'];
	$FLOW_SEQUENCE = $row['FLOW_SEQUENCE'];
	$sql = "\r\n\t\t\tINSERT INTO flow_type (FLOW_TYPE,FLOW_NAME,FORM_ID,FLOW_DOC,FLOW_SORT,MANAGE_USER,FLOW_SEQUENCE)\r\n\t\t\t\tVALUES \r\n\t\t\t\t('".$FLOW_TYPE."','".$_REQUEST['FLOW_NAME']."',".$FORM_ID.",'".$FLOW_DOC."',".$_REQUEST['FORM_SORT'].",'".$MANAGE_USER."','".$FLOW_SEQUENCE."')\r\n\t";
	exequery( $connection, $sql );
	$flow_id = mysql_insert_id( );
	$sql = "SELECT * FROM flow_process WHERE FLOW_ID=".$_REQUEST['FLOW_TEMPLATE_ID'];
	$rs = exequery( $connection, $sql );
	while ( $row = mysql_fetch_array( $rs ) )
	{
		$sqlin = "\r\n\t\t\t\t\tINSERT INTO flow_process (FLOW_ID,PRCS_ID,PRCS_NAME,PRCS_USER,PRCS_ITEM,PRCS_DEPT,PRCS_PRIV,PRCS_TO,PRCS_CONCOURSE,PRCS_OPTYPE,PRCS_DEFAULT_USER,PRCS_DEFAULT_TYPE,PRCS_DEFAULT_MANAGE,PRCS_ITEM_VIEW,PRCS_ITEM_CAPACITY,PRCS_ITEM_AUTO,PRCS_TERM)\r\n\t\t\t\t\tVALUES\r\n\t\t\t\t\t('".$flow_id."','".$row['PRCS_ID']."','".$row['PRCS_NAME']."','".$row['PRCS_USER']."','".$row['PRCS_ITEM']."','".$row['PRCS_DEPT']."','".$row['PRCS_PRIV']."','".$row['PRCS_TO']."','".$row['PRCS_CONCOURSE']."','".$row['PRCS_OPTYPE']."','".$row['PRCS_DEFAULT_USER']."','".$row['PRCS_DEFAULT_TYPE']."','".$row['PRCS_DEFAULT_MANAGE']."','".$row['PRCS_ITEM_VIEW']."','".$row['PRCS_ITEM_CAPACITY']."','".$row['PRCS_ITEM_AUTO']."','".$row['PRCS_TERM']."')\r\n\t\t\r\n\t\t";
		exequery( $connection, $sqlin );
	}
	$sql = "SELECT * FROM flow_others WHERE FLOW_ID=".$_REQUEST['FLOW_TEMPLATE_ID'];
	$rs = exequery( $connection, $sql );
	while ( $row = mysql_fetch_array( $rs ) )
	{
		$sqlin = "\r\n\t\t\t\t\tINSERT INTO flow_others (FLOW_ID,FLOW_SHOW_GRAPH,FLOW_SHOW_TEXT,FLOW_SHOW_STEP,FLOW_SHOW_ATTACH,FLOW_SHOW_FEEDBACK,FLOW_AUTOSAVE,FLOW_AUTOSAVE_TIME)\r\n\t\t\t\t\tVALUES\r\n\t\t\t\t\t(".$flow_id.",".$row['FLOW_SHOW_GRAPH'].",".$row['FLOW_SHOW_TEXT'].",".$row['FLOW_SHOW_STEP'].",".$row['FLOW_SHOW_ATTACH'].",".$row['FLOW_SHOW_FEEDBACK'].",".$row['FLOW_AUTOSAVE'].",'".$row['FLOW_AUTOSAVE_TIME']."')\r\n\t\t\r\n\t\t";
		exequery( $connection, $sqlin );
	}
	$sql = "SELECT * FROM flow_term WHERE FLOW_ID=".$_REQUEST['FLOW_TEMPLATE_ID'];
	$rs = exequery( $connection, $sql );
	while ( $row = mysql_fetch_array( $rs ) )
	{
		$sqlin = "\r\n\t\t\t\t\tINSERT INTO flow_term (FLOW_ID,ID,PRC_PRC,ITEM_NAME,RELATION,EXPRESSION)\r\n\t\t\t\t\tVALUES\r\n\t\t\t\t\t(".$flow_id.",".$row['ID'].",'".$row['PRC_PRC']."','".$row['ITEM_NAME']."','".$row['RELATION']."','".$row['EXPRESSION']."')\r\n\t\t\r\n\t\t";
		exequery( $connection, $sqlin );
		$termid = mysql_insert_id( );
		$sqled = "SELECT ID FROM flow_process WHERE FLOW_ID=".$flow_id." AND PRCS_ID=".substr( $row['PRC_PRC'], 0, 1 );
		$rsed = exequery( $connection, $sqled );
		$rowed = mysql_fetch_array( $rsed );
		$now_p_id = $rowed['ID'];
		$sqlup = "UPDATE flow_term SET ID=".$now_p_id." WHERE TERM_ID=".$termid;
		exequery( $connection, $sqlup );
	}
	$sql = "SELECT * FROM flow_report WHERE FLOW_ID=".$_REQUEST['FLOW_TEMPLATE_ID'];
	$rs = exequery( $connection, $sql );
	while ( $row = mysql_fetch_array( $rs ) )
	{
		$sqlin = "\r\n\t\t\t\t\tINSERT INTO flow_report (FLOW_ID,REPORT_NAME,REPORT_NOTE)\r\n\t\t\t\t\tVALUES\r\n\t\t\t\t\t(".$flow_id.",'".$row['REPORT_NAME']."','".$row['REPORT_NOTE']."')\r\n\t\t\r\n\t\t";
		exequery( $connection, $sqlin );
	}
}
else
{
	$FLOW_SEQUENCE = $_REQUEST['ishave'].";".$_REQUEST['orderlist'].";".$_REQUEST['sequencecontent'];
	$query = "insert into FLOW_TYPE(FLOW_TYPE,FLOW_NAME,FORM_ID,FLOW_DOC,FLOW_SORT,FLOW_SEQUENCE) values ('".$FLOW_TYPE."','".$FLOW_NAME."',".$FORM_ID.",'".$FLOW_DOC."',".$_REQUEST['FORM_SORT'].",'".$FLOW_SEQUENCE."')";
	exequery( $connection, $query );
	$flow_id = mysql_insert_id( );
}
echo "<s";
echo "cript>\r\n\r\n";
if ( $FLOW_TYPE == 2 )
{
	echo "parent.location.replace('flowmain.php?FLOW_ID=";
	echo $flow_id;
	echo "&tagContent=tagContent1&o=1');\r\n";
}
else
{
	echo "parent.location.replace('flowmain.php?FLOW_ID=";
	echo $flow_id;
	echo "&tagContent=tagContent2&o=1');\r\n";
}
echo "\r\n</script>\r\n\r\n\r\n";
exit( );
sleep( 2 );
header( "location: index.php" );
echo "\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明

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