?? main.php
字號:
<?
include_once 'auth.php';
$query = 'SELECT * from INTERFACE';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$IE_TITLE = $ROW['IE_TITLE'];
}
echo '
<html>
<head>
<title>';
echo $IE_TITLE;
echo '</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language=JavaScript>
window.setTimeout("this.location.reload();",80000);
</script>
</head>
';
$query = '' . 'SELECT * from USER where USER_ID=\'' . $LOGIN_USER_ID . '\'';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$USER_NAME = $ROW['USER_NAME'];
}
$CUR_TIME = date ('Y-m-d H:i:s', time ());
$CUR_DATE = date ('Y-m-d', time ());
$query = '' . 'SELECT count(*) from SMS where TO_ID=\'' . $LOGIN_USER_ID . '\' and SEND_TIME<=\'' . $CUR_TIME . '\' and REMIND_FLAG=1';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$NEW_SMS_COUNT = $ROW[0];
}
/* $query = '' . 'SELECT count(*) from EMAIL where BOX_ID=0 and TO_ID=\'' . $LOGIN_USER_ID . '\' and SEND_FLAG=\'1\' and READ_FLAG=\'0\' and DELETE_FLAG!=\'1\'';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$NEW_EMAIL_COUNT = $ROW[0];
}
*/
$query = "SELECT count(*) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID=0 and TO_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and READ_FLAG='0' and (DELETE_FLAG='0' or DELETE_FLAG='2')";
$cursor= exequery($connection,$query);
$NEW_EMAIL_COUNT=0;
if($ROW=mysql_fetch_array($cursor))
$NEW_EMAIL_COUNT=$ROW[0];
$query = '' . 'SELECT count(*) from NOTIFY where (TO_ID=\'ALL_DEPT\' or find_in_set(\'' . $LOGIN_DEPT_ID . '\',TO_ID) or find_in_set(\'' . $LOGIN_USER_PRIV . '\',PRIV_ID) or find_in_set(\'' . $LOGIN_USER_ID . '\',USER_ID)) and begin_date<=\'' . $CUR_DATE . '\' and (end_date>=\'' . $CUR_DATE . '\' or end_date is null) and PUBLISH=\'1\' and READERS not like \'%,' . $LOGIN_USER_ID . ',%\' and READERS not like \'' . $LOGIN_USER_ID . ',%\'';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$NEW_NOTIFY_COUNT = $ROW[0];
}
$query = '' . 'SELECT count(*) from CALENDAR where USER_ID=\'' . $LOGIN_USER_ID . '\' and to_days(CAL_TIME)=to_days(\'' . $CUR_DATE . '\')';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$CALENDAR_COUNT1 = $ROW[0];
}
$query = '' . 'SELECT * from AFFAIR where USER_ID=\'' . $LOGIN_USER_ID . '\' and BEGIN_TIME<=\'' . $CUR_TIME . '\' order by REMIND_TIME';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$TYPE = $ROW['TYPE'];
$REMIND_DATE = $ROW['REMIND_DATE'];
$REMIND_TIME = $ROW['REMIND_TIME'];
$FLAG = 0;
if ($TYPE == '2')
{
$FLAG = 1;
}
else
{
if (($TYPE == '3' AND date ('w', time ()) == $REMIND_DATE))
{
$FLAG = 1;
}
else
{
if (($TYPE == '4' AND date ('j', time ()) == $REMIND_DATE))
{
$FLAG = 1;
}
else
{
if ($TYPE == '5')
{
$REMIND_ARR = explode ('-', $REMIND_DATE);
$REMIND_DATE_MON = $REMIND_ARR[0];
$REMIND_DATE_DAY = $REMIND_ARR[1];
if ((date ('n', time ()) == $REMIND_DATE_MON AND date ('j', time ()) == $REMIND_DATE_DAY))
{
$FLAG = 1;
}
}
}
}
}
if ($FLAG == 1)
{
++$CALENDAR_COUNT2;
continue;
}
}
$query = 'SELECT count(*) from NEWS where PUBLISH=\'1\' and ' . time () . '-UNIX_TIMESTAMP(NEWS_TIME)<=172800';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$NEW_NEWS_COUNT = $ROW[0];
}
$query = '' . 'SELECT count(*) from DIARY where USER_ID=\'' . $LOGIN_USER_ID . '\' and to_days(DIA_DATE)=to_days(\'' . $CUR_DATE . '\')';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$DIARY_COUNT = $ROW[0];
}
$query = '' . 'SELECT count(*) from FILE_CONTENT where SORT_ID=0 and USER_ID=\'' . $LOGIN_USER_ID . '\'';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$FILE_COUNT = $ROW[0];
}
$query = 'SELECT count(*) from USER where DEPT_ID!=0';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$USER_COUNT = $ROW[0];
}
$query = '' . 'SELECT count(*) from ADDRESS where USER_ID=\'' . $LOGIN_USER_ID . '\'';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$ADD_COUNT = $ROW[0];
}
$query = '' . 'SELECT count(*) from FLOW_RUN_PRCS,FLOW_RUN,FLOW_TYPE WHERE FLOW_RUN_PRCS.RUN_ID=FLOW_RUN.RUN_ID and FLOW_RUN.FLOW_ID=FLOW_TYPE.FLOW_ID and USER_ID=\'' . $LOGIN_USER_ID . '\' and PRCS_FLAG<\'3\' and not (TOP_FLAG=\'1\' and PRCS_FLAG=1)';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$FLOW_COUNT = $ROW[0];
}
$CUR_TIME = date ('Y-m-d H:i:s', time ());
$ONLINE_REF_NORMAL = $ONLINE_REF_SEC - 5;
$query = '' . 'SELECT UNIX_TIMESTAMP(LAST_VISIT_TIME) from USER where USER_ID=\'' . $LOGIN_USER_ID . '\'';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$LAST_VISIT_TIME = $ROW[0];
}
if ($ONLINE_REF_NORMAL < time () - $LAST_VISIT_TIME)
{
$query = '' . 'update USER set ONLINE=ONLINE+' . $ONLINE_REF_SEC . ',LAST_VISIT_TIME=\'' . $CUR_TIME . '\' where USER_ID=\'' . $LOGIN_USER_ID . '\'';
exequery ($connection, $query);
}
$ONLINE_LIMIT = $ONLINE_REF_SEC + 5;
$USER_ONLINE = 1;
$query = '' . 'SELECT count(*) from USER where UNIX_TIMESTAMP(\'' . $CUR_TIME . '\')-UNIX_TIMESTAMP(LAST_VISIT_TIME)<' . $ONLINE_LIMIT;
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$USER_ONLINE = $ROW[0];
}
ob_end_clean ();
echo '
<body>
<font color=blue><b>';
echo $IE_TITLE;
echo '</b></font><br>
<b>用戶</b>：';
echo $USER_NAME;
echo '<br><br>
<a href="sms?P=';
echo $P;
echo '">內部短信</a> [';
echo $NEW_SMS_COUNT;
echo ']
<a href="email?P=';
echo $P;
echo '">內部郵件</a> [';
echo $NEW_EMAIL_COUNT;
echo ']
<br>
<a href="notify?P=';
echo $P;
echo '">公告通知</a> [';
echo $NEW_NOTIFY_COUNT;
echo ']
<a href="news?P=';
echo $P;
echo '">內部新聞</a> [';
echo $NEW_NEWS_COUNT;
echo ']
<br>
<a href="calendar?P=';
echo $P;
echo '">今日日程</a> [';
echo $CALENDAR_COUNT1 + $CALENDAR_COUNT2;
echo ']
<a href="diary?P=';
echo $P;
echo '">工作日志</a> [';
echo $DIARY_COUNT;
echo ']
<br>
<a href="file_folder?P=';
echo $P;
echo '">我的文件</a> [';
echo $FILE_COUNT;
echo ']
<a href="workflow?P=';
echo $P;
echo '">工作流</a> [';
echo $FLOW_COUNT;
echo ']
<br>
<a href="user_info?P=';
echo $P;
echo '">人員查詢</a> [';
echo $USER_COUNT;
echo ']
<a href="address?P=';
echo $P;
echo '">通訊簿</a> [';
echo $ADD_COUNT;
echo ']
<br>
<a href="user_info/online.php?P=';
echo $P;
echo '">在線人員[';
echo $USER_ONLINE;
echo ']</a>
<a href="tel_no?P=';
echo $P;
echo '">區號郵編</a> <br>
<a href="index.php">重新登錄</a>
<br>';
$CUR_TIME=date("Y-m-d H:i:s",time());
echo $CUR_TIME;
echo '
</body>
</html>
';
?>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -