month.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 330 行
PHP
330 行
<?
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 (!$DEPT_ID)
{
$DEPT_ID = $LOGIN_DEPT_ID;
}
if (!checkdate ($MONTH, $DAY, $YEAR))
{
message ('错误', '日期不正确');
exit ();
}
$DATE = strtotime ((((($YEAR.'-').$MONTH).'-').$DAY));
$WEEK_BEGIN = strtotime ((('-'.date ('w', $DATE)).'days'), $DATE);
$WEEK_END = strtotime ('+6 days', $WEEK_BEGIN);
echo '<html>
<head>
<title>日程安排查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
';
echo '<s';
echo 'cript>
function my_note(CAL_ID)
{
myleft=(screen.availWidth-250)/2;
mytop=(screen.availHeight-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';
echo '+" year";
My_Submit();
}
function set_mon(op)
{
document.form1.BTN_OP.value=op+" month";
My_Submit();
}
function set_day(op)
{
document.form1.BTN_OP.value=op+" day";
My_Submit();
}
function set_view(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_info_view="+ escap';
echo 'e (view) + ";expires=" + exp.toGMTString()+";path=/";
location=view+\'.php?YEAR=';
echo $YEAR;
echo '&MONTH=';
echo $MONTH;
echo '&DAY=';
echo $DAY;
echo '&DEPT_ID=';
echo $DEPT_ID;
echo '\';
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<form name="form1" action="';
echo $_SERVER['SCRIPT_NAME'];
echo '">
<table width="98%" 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 '&DEPT_ID=';
echo $DEPT_ID;
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">
';
echo '<s';
echo 'elect name="VIEW" class="BigSelect" onchange="set_view();">
<option value="day"> 日列表</option>
<option value="index"> 周列表</option>
<option value="month" selected> 月列表</option>
</select>
</td>
</tr>
<tr>
<td colspan="2">
';
echo '<s';
echo 'elect name="DEPT_ID" class="BigSelect" onchange="form1.USER_ID.value=\'\';My_Submit();">
';
echo my_dept_tree (0, $DEPT_ID, 1);
echo ' </select>
';
echo '<s';
echo 'elect name="USER_ID" class="BigSelect" onchange="My_Submit();">
';
$query = ((''.'SELECT PRIV_NO from USER_PRIV where USER_PRIV=').$LOGIN_USER_PRIV);
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$PRIV_NO = $ROW['PRIV_NO'];
}
$COUNT = 0;
if (($LOGIN_USER_PRIV == '1'))
{
$query = (((''.'SELECT USER_ID,USER_NAME from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV and DEPT_ID=').$DEPT_ID).' and NOT_LOGIN!=\'1\' order by PRIV_NO,USER_NO,USER_NAME');
}
else
{
$query = (((((''.'SELECT USER_ID,USER_NAME from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV and DEPT_ID=').$DEPT_ID).' AND USER_PRIV.PRIV_NO>').$PRIV_NO).' and NOT_LOGIN!=\'1\' order by PRIV_NO,USER_NO,USER_NAME');
}
$cursor1 = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor1))
{
++$COUNT;
$USER_ID1 = $ROW['USER_ID'];
$USER_NAME = $ROW['USER_NAME'];
echo ' <option value="';
echo $USER_ID1;
echo '"';
if (($USER_ID1 == $USER_ID))
{
echo 'selected';
}
echo '>';
echo $USER_NAME;
echo '</option>
';
if ((!$USER_ID AND ($COUNT == 1)))
{
$USER_ID = $USER_ID1;
continue;
}
}
echo ' </select>
</td>
</tr>
</table>
';
if (!$USER_ID)
{
message ('', '请选择用户');
exit ();
}
$CUR_TIME = date ('Y-m-d H:i:s', time ());
$query = (((((((''.'SELECT * from CALENDAR where USER_ID=\'').$USER_ID).'\' and year(CAL_TIME)=').$YEAR).' and month(CAL_TIME)=').$MONTH).' order by CAL_TIME');
$cursor = exequery ($connection, $query);
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_TITLE = (('类型：'.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 .= '状态：已完成');
}
if (($MANAGER_ID != ''))
{
$query = (((''.'SELECT * from USER where USER_ID=\'').$MANAGER_ID).'\'');
$cursor1 = exequery ($connection, $query);
if ($ROW1 = mysql_fetch_array ($cursor1))
{
($CAL_TITLE .= ('
安排人：'.$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)).(((''.'<br><a href=\'javascript:my_note(').$CAL_ID).');\' style=\'color:')).$STATUS_COLOR).';\'>').$CONTENT).'</a>');
($CONTENT .= (('<br><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 ('j', strtotime ($CAL_TIME))] .= $CONTENT);
}
echo ' <table width="98%" border="0" cellspacing="1" class="small" bgcolor="#000000" cellpadding="3" align="center">
<tr align="center" class="TableHeader" height="20">
<td width="14%"><b>周日</b></td>
<td width="14%"><b>周一</b></td>
<td width="14%"><b>周二</b></td>
<td width="14%"><b>周三</b></td>
<td width="14%"><b>周四</b></td>
<td width="14%"><b>周五</b></td>
<td width="14%"><b>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?