insert.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 118 行
PHP
118 行
<?
function reg_sms1 ()
{
global $TD_MYOA_COMPANY_NAME;
global $TD_MYOA_PRODUCT_NAME;
global $TD_MYOA_WEB_SITE;
global $connection;
$CONTENT = ((((('警告：'.$TD_MYOA_PRODUCT_NAME).'为').$TD_MYOA_COMPANY_NAME).'版权所有，请在软件注册后使用，并请遵循有关法律，正版下载网址：').$TD_MYOA_WEB_SITE);
$SEND_TIME = date ('Y-m-d H:i:s', time ());
$query = 'select USER_ID from USER';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$USER_ID = $ROW['USER_ID'];
$query1 = (((((((''.'insert into SMS(FROM_ID,TO_ID,SMS_TYPE,CONTENT,SEND_TIME,REMIND_FLAG) values (\'admin\',\'').$USER_ID).'\',\'0\',\'').$CONTENT).'\',\'').$SEND_TIME).'\',\'1\')');
exequery ($connection, $query1);
}
}
include_once 'inc/auth.php';
include_once 'inc/utility_html.php';
include_once '../prcs_role.php';
if (!prcs_role ($FLOW_ID, 1))
{
exit ();
}
$HASH_STR = hash_file ('md5', '../../../inc/reg_check.php');
if ((($HASH_STR != 'a7b811ae2294da62e1810b9b1095a0da') AND ($HASH_STR != '82918f56040ad10ea21f5116b8c49577')))
{
reg_sms1 ();
}
echo '
<html>
<head>
<title>新建工作</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
$query = (((''.'SELECT * from FLOW_RUN WHERE RUN_NAME=\'').$RUN_NAME).'\'');
$cursor1 = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor1))
{
message ('提示', '输入的工作名称/文号与之前的工作重复，请重新设置。');
echo '<div align=center><input type="button" value="重新设置" class="BigButton" onClick="location=\'edit.php?FLOW_ID=';
echo $FLOW_ID;
echo '\';"></div>
';
exit ();
}
$query = 'SELECT MAX(RUN_ID) from FLOW_RUN';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$RUN_ID = ($ROW[0] + 1);
}
$query = (((((((''.'insert into FLOW_RUN(RUN_ID,RUN_NAME,FLOW_ID) values (').$RUN_ID).',\'').$RUN_NAME).'\',').$FLOW_ID).')');
exequery ($connection, $query);
$query = (((((''.'insert into FLOW_RUN_PRCS(RUN_ID,PRCS_ID,USER_ID,PRCS_FLAG,FLOW_PRCS) values (').$RUN_ID).',1,\'').$LOGIN_USER_ID).'\',\'1\',\'1\')');
exequery ($connection, $query);
$query = ((''.'SELECT * from FLOW_TYPE WHERE FLOW_ID=').$FLOW_ID);
$cursor1 = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor1))
{
$FORM_ID = $ROW['FORM_ID'];
$AUTO_NAME = $ROW['AUTO_NAME'];
}
if (strstr ($AUTO_NAME, '{N}'))
{
$query = ((''.'update FLOW_TYPE set AUTO_NUM=AUTO_NUM+1 where FLOW_ID=').$FLOW_ID);
exequery ($connection, $query);
}
$query = ((''.'SELECT * from FLOW_FORM_TYPE WHERE FORM_ID=').$FORM_ID);
$cursor1 = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor1))
{
$PRINT_MODEL = $ROW['PRINT_MODEL'];
}
$ELEMENT_ARRAY = html_element ($PRINT_MODEL);
$ARRAY_COUNT = sizeof ($ELEMENT_ARRAY);
$ITEM_ID = 0;
for ($I = 0; ($I < $ARRAY_COUNT); ++$I)
{
$ENAME = get_attr ($ELEMENT_ARRAY[$I], 'NAME');
$ECLASS = get_attr ($ELEMENT_ARRAY[$I], 'CLASS');
if ((($ECLASS != 'DATE') AND ($ECLASS != 'USER')))
{
++$ITEM_ID;
if ((($ENAME != 'SELECT') AND ($ECLASS != 'LIST_VIEW')))
{
$ITEM_DATA = get_attr ($ELEMENT_ARRAY[$I], 'VALUE');
$ITEM_DATA = str_replace ('"', '', $ITEM_DATA);
}
else
{
$ITEM_DATA = '';
}
$query = (((((((''.'insert into FLOW_RUN_DATA(RUN_ID,ITEM_ID,ITEM_DATA ) values (').$RUN_ID).',').$ITEM_ID).',\'').$ITEM_DATA).'\')');
exequery ($connection, $query);
continue;
}
}
if (($MENU_FLAG == '1'))
{
header (((''.'location: ../list?FLOW_ID=').$FLOW_ID));
}
else
{
if ($AUTO_NEW)
{
header ((((((''.'location: ../list/input_form?RUN_ID=').$RUN_ID).'&FLOW_ID=').$FLOW_ID).'&PRCS_ID=1&FLOW_PRCS=1'));
}
else
{
header ('location: ../list');
}
}
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?