day.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 467 行
PHP
467 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
$CUR_YEAR = date ('Y');
$CUR_MON = date ('m');
$CUR_DAY = date ('d');
if (($BTN_OP != ''))
{
$DATE = strtotime ($BTN_OP, strtotime ((((($YEAR.'-').$MONTH).'-').$DAY)));
$YEAR = date ('Y', $DATE);
$MONTH = date ('m', $DATE);
$DAY = date ('d', $DATE);
}
if (!$YEAR)
{
$YEAR = $CUR_YEAR;
}
if (!$MONTH)
{
$MONTH = $CUR_MON;
}
if (!$DAY)
{
$DAY = $CUR_DAY;
}
if (!checkdate ($MONTH, $DAY, $YEAR))
{
message ('错误', '日期不正确');
exit ();
}
$DATE = strtotime ((((($YEAR.'-').$MONTH).'-').$DAY));
echo '<html>
<head>
<title>日程安排</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript>
function my_affair(AFF_ID)
{
myleft=(screen.availWidth-250)/2;
mytop=(screen.availHeight-200)/2;
window.open("../affair/note.php?AFF_ID="+AFF_ID,"note_win"+AFF_ID,"height=200,width=250,status=0,toolbar=no,menubar=no,location=no,scrollbars=auto,resizable=no,top="+mytop+",left="+myleft);
}
function my_note(CAL_ID)
{
myleft=(screen.availWidth-250)/2;
mytop=(screen.availHe';
echo 'ight-200)/2;
window.open("note.php?CAL_ID="+CAL_ID,"note_win"+CAL_ID,"height=200,width=250,status=0,toolbar=no,menubar=no,location=no,scrollbars=auto,resizable=no,top="+mytop+",left="+myleft);
}
function My_Submit()
{
document.form1.submit();
}
function set_year(op)
{
document.form1.BTN_OP.value=op+" year";
My_Submit();
}
function set_mon(op)
{
document.form1.BTN_OP.v';
echo 'alue=op+" month";
My_Submit();
}
function set_day(op)
{
document.form1.BTN_OP.value=op+" day";
My_Submit();
}
function display_front()
{
var front=document.getElementById("front");
if(!front)
return;
if(front.style.display==\'\')
front.style.display=\'none\';
else
front.style.display=\'\';
}
function init()
{
var elementI=document.getEleme';
echo 'ntsByTagName("DIV");
for(i=0;i<elementI.length;i++)
{
if(elementI[i].id.substr(0,4)!="cal_")
continue;
elementI[i].onmouseover=function() {var op_i=document.getElementById(this.id+"_op");if(op_i) op_i.style.display="";}
elementI[i].onmouseout =function() {var op_i=document.getElementById(this.id+"_op");if(op_i) op_i.style.display="none";}
}
}
functio';
echo 'n set_view()
{
var view=document.form1.VIEW.value;
if(!view) return;
var exp = new Date();
exp.setTime(exp.getTime() + 24*60*60*1000);
document.cookie = "cal_view="+ escape (view) + ";expires=" + exp.toGMTString()+";path=/";
location=view+\'.php?YEAR=';
echo $YEAR;
echo '&MONTH=';
echo $MONTH;
echo '&DAY=';
echo $DAY;
echo '\';
}
function new_cal(CAL_TIME)
{
window.open(\'new?CAL_DATE=';
echo $YEAR;
echo '-';
echo $MONTH;
echo '-';
echo $DAY;
echo '&CAL_TIME=\'+CAL_TIME,\'oa_sub_window\',\'height=350,width=500,status=0,toolbar=no,menubar=no,location=no,left=300,top=200,scrollbars=yes,resizable=yes\');
}
function new_diary()
{
window.open(\'../../diary/new/?CUR_DATE=';
echo $YEAR;
echo '-';
echo $MONTH;
echo '-';
echo $DAY;
echo '\',\'diary_sub_window\',\'height=560,width=650,status=0,toolbar=no,menubar=no,location=no,left=180,top=50,scrollbars=yes,resizable=yes\');
}
</script>
</head>
<body class="bodycolor" topmargin="5" onload="init();">
<form name="form1" action="';
echo $_SERVER['SCRIPT_NAME'];
echo '">
<table width="100%" border="0" cellspacing="0" class="big1" cellpadding="3" align="center">
<tr>
<td>
<input type="button" value="今天" class="SmallButton" title="今天" onclick="location=\'';
echo $_SERVER['SCRIPT_NAME'];
echo '?YEAR=';
echo $CUR_YEAR;
echo '&MONTH=';
echo $CUR_MON;
echo '&DAY=';
echo $CUR_DAY;
echo '\'">
<input type="hidden" value="" name="BTN_OP">
<!-------------- 年 ------------>
<input type="button" value=" < " class="SmallButton" style="font-weight:bold" title="上一年" onclick="set_year(-1);">';
echo '<s';
echo 'elect name="YEAR" class="SmallSelect" style="font-weight:bold" onchange="My_Submit();">
';
for ($I = 2000; ($I <= 2015); ++$I)
{
echo ' <option value="';
echo $I;
echo '" ';
if (($I == $YEAR))
{
echo 'selected';
}
echo '>';
echo $I;
echo '年</option>
';
}
echo ' </select><input type="button" value=" > " class="SmallButton" style="font-weight:bold" title="下一年" onclick="set_year(1);">
<!-------------- 月 ------------>
<input type="button" value=" < " class="SmallButton" style="font-weight:bold" title="上一月" onclick="set_mon(-1);">';
echo '<s';
echo 'elect name="MONTH" class="SmallSelect" style="font-weight:bold" onchange="My_Submit();">
';
for ($I = 1; ($I <= 12); ++$I)
{
if (($I < 10))
{
$I = ('0'.$I);
}
echo ' <option value="';
echo $I;
echo '" ';
if (($I == $MONTH))
{
echo 'selected';
}
echo '>';
echo $I;
echo '月</option>
';
}
echo ' </select><input type="button" value=" > " class="SmallButton" style="font-weight:bold" title="下一月" onclick="set_mon(1);">
<!-------------- 日 ------------>
<input type="button" value=" < " class="SmallButton" style="font-weight:bold" title="上一天" onclick="set_day(-1);">';
echo '<s';
echo 'elect name="DAY" class="SmallSelect" style="font-weight:bold" onchange="My_Submit();">
';
for ($I = 1; ($I <= date ('t', strtotime ((((($YEAR.'-').$MONTH).'-').$DAY)))); ++$I)
{
if (($I < 10))
{
$I = ('0'.$I);
}
echo ' <option value="';
echo $I;
echo '" ';
if (($I == $DAY))
{
echo 'selected';
}
echo '>';
echo $I;
echo '日</option>
';
}
echo ' </select><input type="button" value=" > " class="SmallButton" style="font-weight:bold" title="下一天" onclick="set_day(1);">
</td>
<td align="right">
<input type="button" value="新建事务" class="SmallButton" onClick="new_cal(\'9\')" title="创建新的事务，以便提醒自己">
<input type="button" value="建立日志" class="SmallButton" title="建立日志" onclick="new_diary();">';
echo '
';
echo '<s';
echo 'elect name="VIEW" class="BigSelect" onchange="set_view();">
<option value="day" selected> 日列表</option>
<option value="index"> 周列表</option>
<option value="month"> 月列表</option>
</select>
</td>
</tr>
</table>
';
$CUR_TIME = date ('Y-m-d H:i:s', time ());
$query = (((((((((''.'SELECT * from CALENDAR where USER_ID=\'').$LOGIN_USER_ID).'\' and TO_DAYS(CAL_TIME)=TO_DAYS(\'').$YEAR).'-').$MONTH).'-').$DAY).'\') order by CAL_TIME');
$cursor = exequery ($connection, $query);
$CAL_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
$CAL_ID = $ROW['CAL_ID'];
$CAL_TIME = $ROW['CAL_TIME'];
$END_TIME = $ROW['END_TIME'];
$CAL_TYPE = $ROW['CAL_TYPE'];
$CONTENT = $ROW['CONTENT'];
$MANAGER_ID = $ROW['MANAGER_ID'];
$OVER_STATUS = $ROW['OVER_STATUS'];
$CAL_TYPE_DESC = (get_code_name ($CAL_TYPE, 'CAL_TYPE').'：');
if (($OVER_STATUS == '0'))
{
if ((0 < compare_time ($CUR_TIME, $END_TIME)))
{
$STATUS_COLOR = '#FF0000';
$CAL_TITLE = '状态：已过期';
}
else
{
if ((compare_time ($CUR_TIME, $CAL_TIME) < 0))
{
$STATUS_COLOR = '#0000FF';
$CAL_TITLE = '状态：未至';
}
else
{
$STATUS_COLOR = '#0000FF';
$CAL_TITLE = '状态：进行中';
}
}
}
else
{
$STATUS_COLOR = '#00AA00';
$CAL_TITLE = '状态：已完成';
}
$MANANAMER_NAME = '';
if (($MANAGER_ID != ''))
{
$query = (((''.'SELECT USER_NAME from USER where USER_ID=\'').$MANAGER_ID).'\'');
$cursor1 = exequery ($connection, $query);
if ($ROW1 = mysql_fetch_array ($cursor1))
{
$MANANAMER_NAME = (('(安排人:'.$ROW1['USER_NAME']).')');
}
}
$CONTENT = htmlspecialchars ($CONTENT);
$CONTENT = ((((((((((((((('<div id="cal_'.$CAL_ID).'" title=\'').$CAL_TITLE).'\'>').substr ($CAL_TIME, 11, 5)).'-').substr ($END_TIME, 11, 5)).' ').$CAL_TYPE_DESC).(((''.'<a href=\'javascript:my_note(').$CAL_ID).');\' style=\'color:')).$STATUS_COLOR).';\'>').$CONTENT).'</a> ').$MANANAMER_NAME);
($CONTENT .= (('<span id="cal_'.$CAL_ID).'_op" style="display:none;">'));
if (($OVER_STATUS == '0'))
{
($CONTENT .= (((((((((''.'<a href="status.php?CAL_ID=').$CAL_ID).'&OVER_STATUS=1&YEAR=').$YEAR).'&MONTH=').$MONTH).'&DAY=').$DAY).'"> 完成</a>'));
}
else
{
if ((($OVER_STATUS == '') OR ($OVER_STATUS == '1')))
{
($CONTENT .= (((((((((''.'<a href="status.php?CAL_ID=').$CAL_ID).'&OVER_STATUS=0&YEAR=').$YEAR).'&MONTH=').$MONTH).'&DAY=').$DAY).'"> 未完成</a>'));
}
}
if ((($MANAGER_ID == '') OR ($MANAGER_ID == $LOGIN_USER_ID)))
{
($CONTENT .= (((((((((''.'<a href="modify.php?CAL_ID=').$CAL_ID).'&OVER_STATUS=1&YEAR=').$YEAR).'&MONTH=').$MONTH).'&DAY=').$DAY).'"> 修改</a>'));
($CONTENT .= (((((((((''.'<a href="delete.php?CAL_ID=').$CAL_ID).'&OVER_STATUS=1&YEAR=').$YEAR).'&MONTH=').$MONTH).'&DAY=').$DAY).'"> 删除</a>'));
}
($CONTENT .= '</span></div>');
($CAL_ARRAY[date ('G', strtotime ($CAL_TIME))] .= $CONTENT);
}
$query = (((((((((((''.'SELECT * from AFFAIR where USER_ID=\'').$LOGIN_USER_ID).'\' and BEGIN_TIME<=\'').date ('Y-m-d', $DATE)).' 23:59:59\' and (TYPE=\'2\' or TYPE=\'3\' and REMIND_DATE=\'').date ('w', $DATE)).'\' or TYPE=\'4\' and REMIND_DATE=\'').date ('j', $DATE)).'\' or TYPE=\'5\' and REMIND_DATE=\'').date ('n-j', $DATE)).'\') order by BEGIN_TIME desc');
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$AFF_ID = $ROW['AFF_ID'];
$BEGIN_TIME = $ROW['BEGIN_TIME'];
$REMIND_DATE = $ROW['REMIND_DATE'];
$REMIND_TIME = $ROW['REMIND_TIME'];
$CONTENT = $ROW['CONTENT'];
$TYPE = $ROW['TYPE'];
$LAST_REMIND = $ROW['LAST_REMIND'];
$CONTENT = htmlspecialchars ($CONTENT);
if (($LAST_REMIND == '0000-00-00'))
{
$LAST_REMIND = '';
}
switch ($TYPE)
{
case '2':
{
$TYPE_DESC = '每日';
break;
}
case '3':
{
$TYPE_DESC = '每周';
if (($REMIND_DATE == '1'))
{
$REMIND_DATE = '一';
break;
}
else
{
if (($REMIND_DATE == '2'))
{
$REMIND_DATE = '二';
break;
}
else
{
if (($REMIND_DATE == '3'))
{
$REMIND_DATE = '三';
break;
}
else
{
if (($REMIND_DATE == '4'))
{
$REMIND_DATE = '四';
break;
}
else
{
if (($REMIND_DATE == '5'))
{
$REMIND_DATE = '五';
break;
}
else
{
if (($REMIND_DATE == '6'))
{
$REMIND_DATE = '六';
break;
}
else
{
if (($REMIND_DATE == '0'))
{
$REMIND_DATE = '日';
break;
}
break;
}
break;
}
break;
}
break;
}
break;
}
break;
}
break;
}
case '4':
{
$TYPE_DESC = '每月';
($REMIND_DATE .= '日');
break;
}
case '5':
{
$TYPE_DESC = '每年';
$REMIND_DATE = (str_replace ('-', '月', $REMIND_DATE).'日');
break;
}
}
$AFF_TITLE = (((((((('提醒时间：'.$TYPE_DESC).$REMIND_DATE).' ').substr ($REMIND_TIME, 0, -3)).'
上次提醒：').$LAST_REMIND).'
起始时间：').$BEGIN_TIME);
$CONTENT = (((((substr ($REMIND_TIME, 0, -3).(((''.' <a href=\'javascript:my_affair(').$AFF_ID).');\' title=\'')).$AFF_TITLE).'\'>').$CONTENT).'</a><br>');
$REMIND_HOUR = intval (substr ($REMIND_TIME, 0, strpos ($REMIND_TIME, ':')));
if (($BEGIN_TIME <= ((date ('Y-m-d', $DATE).' ').$REMIND_TIME)))
{
($CAL_ARRAY[$REMIND_HOUR] .= $CONTENT);
continue;
}
}
echo '
<table width="100%" border="0" cellspacing="1" class="small" bgcolor="#000000" cellpadding="3" align="center">
<tr align="center" class="TableHeader">
<td class="TableControl" width="9%"><a href="javascript:display_front();">0-6点</a></td>
<td>内容</td>
</tr>
<tbody id="front" style="display:none;">
';
for ($I = 0; ($I < 7); ++$I)
{
echo ' <tr class="TableData" height="30">
<td align="center" class="TableControl" width="9%"><a href="javascript:new_cal(\'';
echo $I;
echo '\')">';
if (($I < 10))
{
echo '0';
}
echo $I;
echo ':00</a></td>
<td>';
echo $CAL_ARRAY[$I];
echo '</td>
</tr>
';
}
echo ' </tbody>
';
for ($I = 7; ($I < 24); ++$I)
{
echo ' <tr class="TableData" height="30">
<td align="center" class="TableControl" width="9%"><a href="javascript:new_cal(\'';
echo $I;
echo '\')">';
if (($I < 10))
{
echo '0';
}
echo $I;
echo ':00</a></td>
<td>';
echo $CAL_ARRAY[$I];
echo '</td>
</tr>
';
}
echo ' </table>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?