update.php
来自「极限网络智能办公系统 - Office Automation 2008 官方10」· PHP 代码 · 共 88 行
PHP
88 行
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.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";
$CUR_DATE = date( "Y-m-d", time( ) );
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$ATTACHMENT_ID .= copy_sel_attach( $ATTACH_NAME, $ATTACH_DIR, $DISK_ID );
$ATTACHMENT_NAME .= $ATTACH_NAME;
if ( $DIA_DATE == "" )
{
$DIA_DATE = $CUR_DATE;
}
$query = "SELECT * from SYS_PARA where PARA_NAME='LOCK_TIME'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PARA_VALUE = $ROW['PARA_VALUE'];
}
if ( $PARA_VALUE != "" )
{
$W_START = substr( $PARA_VALUE, 0, strpos( $PARA_VALUE, "," ) );
$W_END = substr( $PARA_VALUE, strpos( $PARA_VALUE, "," ) + 1 );
}
$query = "SELECT * from SYS_PARA where PARA_NAME='LOCK_DATE_DAY'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$LOCK_DATE_DAY = $ROW['PARA_VALUE'];
}
$CUR_YEAR = date( "Y" );
$CUR_MON = date( "m" );
$CUR_DAY = date( "d" );
$LOCK_DATE_DAY = intval( $LOCK_DATE_DAY );
if ( 0 < $LOCK_DATE_DAY )
{
$DATE = strtotime( $CUR_YEAR."-".$CUR_MON."-".$CUR_DAY );
$DAY_END = strtotime( "-".$LOCK_DATE_DAY." days", $DATE );
$W_END = date( "Y-m-d", $DAY_END )." 23:59";
}
if ( $W_START == "" && $W_END != "" && compare_date( $DIA_DATE, $W_END ) <= 0 )
{
message( "提示", "所填的日志日期在锁定范围内!" );
button_back( );
exit( );
}
if ( $W_START != "" && $W_END == "" && 0 <= compare_date( $DIA_DATE, $W_START ) )
{
message( "提示", "所填的日志日期在锁定范围内!" );
button_back( );
exit( );
}
if ( $W_START != "" && $W_END != "" && compare_date( $DIA_DATE, $W_END ) <= 0 && 0 <= compare_date( $DIA_DATE, $W_START ) )
{
message( "提示", "所填的日志日期在锁定范围内!" );
button_back( );
exit( );
}
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
if ( $ATTACHMENT_NAME != "" )
{
$ATTACHMENT_ID = upload( $ATTACHMENT, $ATTACHMENT_NAME );
$ATTACHMENT_ID = $ATTACHMENT_ID_OLD.$ATTACHMENT_ID.",";
$ATTACHMENT_NAME = $ATTACHMENT_NAME_OLD.$ATTACHMENT_NAME."*";
}
else
{
$ATTACHMENT_ID = $ATTACHMENT_ID_OLD;
$ATTACHMENT_NAME = $ATTACHMENT_NAME_OLD;
}
if ( $DIA_DATE == "" )
{
$DIA_DATE = date( "Y-m-d", time( ) );
}
$query = "update DIARY set ATTACHMENT_ID='".$ATTACHMENT_ID."',ATTACHMENT_NAME='{$ATTACHMENT_NAME}',DIA_TYPE='{$DIA_TYPE}',DIA_DATE='{$DIA_DATE}',DIA_TIME='{$CUR_TIME}',SUBJECT='{$SUBJECT}',CONTENT='{$CONTENT}' where DIA_ID={$DIA_ID}";
exequery( $connection, $query );
if ( $OP == 0 )
{
header( "location:./edit.php?DIA_ID=".$DIA_ID );
}
else
{
header( "location: index1.php" );
}
echo "\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?