$CAL_COUNT = 0;
while (!$rs->EOF) {
$CAL_ID = $rs->fields['CAL_ID'];
$CAL_TIME = $rs->fields['CAL_TIME'];
$END_TIME = $rs->fields['END_TIME'];
$CAL_TYPE = $rs->fields['CAL_TYPE'];
$CONTENT = $rs->fields['CONTENT'];
$MANAGER_ID = $rs->fields['MANAGER_ID'];
$OVER_STATUS = $rs->fields['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);
$CONTENT .= "<a href=\"../calendar_newai.php?action=finish&id=" . $CAL_ID . "&OVER_STATUS=1&YEAR={$YEAR}&MONTH={$MONTH}&DAY={$DAY}\"> 完成</a>";
} else {
if ($OVER_STATUS == "" || $OVER_STATUS == "1") {
$CONTENT .= "<a href=\"../calendar_newai.php?action=finish&id=" . $CAL_ID . "&OVER_STATUS=0&YEAR={$YEAR}&MONTH={$MONTH}&DAY={$DAY}\"> 未完成</a>";
}
}
if ($MANAGER_ID == "" || $MANAGER_ID == $LOGIN_USER_ID) {
$CONTENT .= "<a href=\"../calendar_newai.php?action=edit_default&id=" . $CAL_ID . "&OVER_STATUS=1&YEAR={$YEAR}&MONTH={$MONTH}&DAY={$DAY}\"> 修改</a>";
$CONTENT .= "<a href=\"javascript:del_cal(" . $CAL_ID . ");\"> 删除</a>";
}
}
$CONTENT .= "</span></div>";
$CAL_ARRAY[date("j", strtotime($CAL_TIME))] .= $CONTENT;
for ($j = 0; $j < $days; $j++) {
$nextDay = DateAdd("d", $j + 1, $CAL_TIME);
if (compare_time($nextDay, date("Y-m-d", $MONTH_BEGIN)) > 0 && compare_time($nextDay, date("Y-m-d 23:59:59", $MONTH_END)) < 0) {
$CAL_ARRAY[date("j", strtotime($nextDay))] .= $CONTENT;
}
}
}
/*
$I = 1;
for ( ; $I <= date( "t", $DATE ); ++$I )
{
$DAY_I = strtotime( $YEAR."-".$MONTH."-".$I );
$query = "SELECT * from affair where USER_ID='".$_SESSION['LOGIN_USER_ID']."' and BEGIN_TIME<='".date( "Y-m-d", $DAY_I )." 23:59:59' and (TYPE='2' or TYPE='3' and REMIND_DATE='".date( "w", $DAY_I )."' or TYPE='4' and REMIND_DATE='".date( "j", $DAY_I )."' or TYPE='5' and REMIND_DATE='".date( "n-j", $DAY_I )."') order by BEGIN_TIME desc";
$rs=$db->Execute($query);
$rs_b=$rs->GetArray();
for ($j=0;$j<sizeof($rs_b);$j++)
{
$AFF_ID = $rs_b[$j]['AFF_ID'];
