⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 index.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
🔍 
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>

<html>
<head>
<title>日常事务</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
function delete_affair(AFF_ID)
{
 msg='确认要删除该事务么？';
 if(window.confirm(msg))
 {
  URL="delete.php?AFF_ID=" + AFF_ID;
  window.location=URL;
 }
}

function my_note(AFF_ID)
{
  my_left=document.body.scrollLeft+event.clientX-event.offsetX-50;
  my_top=document.body.scrollTop+event.clientY-event.offsetY+150;

  window.open("note.php?AFF_ID="+AFF_ID,"note_win"+AFF_ID,"height=170,width=180,status=0,toolbar=no,menubar=no,location=no,scrollbars=auto,top="+ my_top +",left="+ my_left +",resizable=no");
}

</script>
</head>
<body class="bodycolor" topmargin="5">

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/diary.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 新建日常事务</span><br>
    </td>
  </tr>
</table>

<div align="center">
<input type="button" value="新建日常事务" class="BigButton" onClick="location='new';" title="新建日常事务">
</div>

<br>

<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
 <tr>
   <td background="/images/dian1.gif" width="100%"></td>
 </tr>
</table>

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/diary.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 日常事务管理</span>
    </td>
  </tr>
</table>

<br>

<?
$CUR_DATE=date("Y-m-d",time());
 //============================ 显示日志 =======================================
 $connection=OpenConnection();

 $query = "SELECT * from AFFAIR where USER_ID='$LOGIN_USER_ID' order by BEGIN_TIME desc";
 $cursor= exequery($connection,$query);
 $AFF_COUNT=0;

 while($ROW=mysql_fetch_array($cursor))
 {
    $AFF_COUNT++;

    $AFF_ID=$ROW["AFF_ID"];
    $USER_ID=$ROW["USER_ID"];
    $BEGIN_TIME=$ROW["BEGIN_TIME"];
    $TYPE=$ROW["TYPE"];
    $REMIND_DATE=$ROW["REMIND_DATE"];
    $REMIND_TIME=$ROW["REMIND_TIME"];
    $CONTENT=$ROW["CONTENT"];

    $CONTENT=str_replace("<","&lt",$CONTENT);
    $CONTENT=str_replace(">","&gt",$CONTENT);
    $CONTENT=stripslashes($CONTENT);

    switch($TYPE)
    {
     case "2":
         $TYPE_DESC="按日提醒";
         break;
     case "3":
         $TYPE_DESC="按周提醒";
         if($REMIND_DATE=="1")
            $REMIND_DATE="周一";
         elseif($REMIND_DATE=="2")
            $REMIND_DATE="周二";
         elseif($REMIND_DATE=="3")
            $REMIND_DATE="周三";
         elseif($REMIND_DATE=="4")
            $REMIND_DATE="周四";
         elseif($REMIND_DATE=="5")
            $REMIND_DATE="周五";
         elseif($REMIND_DATE=="6")
            $REMIND_DATE="周六";
         elseif($REMIND_DATE=="0")
            $REMIND_DATE="周日";
         break;
     case "4":
         $TYPE_DESC="按月提醒";
         $REMIND_DATE.="日";
         break;
     case "5":
         $TYPE_DESC="按年提醒";
         $REMIND_DATE=str_replace("-","月",$REMIND_DATE)."日";
         break;
    }

    if($AFF_COUNT==1)
    {
?>

    <table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">

<?
    }
    if($AFF_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";
?>
    <tr class="<?=$TableLine?>">
      <td nowrap align="center"><?=$BEGIN_TIME?></td>
      <td nowrap align="center"><?=$TYPE_DESC?></td>
      <td nowrap align="center"><?=$REMIND_DATE?></td>
      <td nowrap align="center"><?=$REMIND_TIME?></td>
      <td><a href="#" onclick="my_note(<?=$AFF_ID?>);"><?=csubstr(strip_tags($CONTENT),0,20);?> <? if(strlen($CONTENT)>20)echo "...";?></a></td>
      <td nowrap align="center">
          <a href="modify.php?AFF_ID=<?=$AFF_ID?>"> 修改</a>&nbsp;
          <a href="javascript:delete_affair(<?=$AFF_ID?>);"> 删除</a>
      </td>
    </tr>
<?
 }

 if($AFF_COUNT==0)
 {
   Message("","无事务记录");
   exit;
 }
 else
 {
?>
   <thead class="TableHeader">
      <td nowrap align="center" width="150">起始时间 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
      <td nowrap align="center" width="80">提醒类型</td>
      <td nowrap align="center" width="80">提醒日期</td>
      <td nowrap align="center" width="80">提醒时间</td>
      <td nowrap align="center">日志内容</td>
      <td nowrap align="center" width="80">操作</td>
   </thead>
   </table>
<?
 }
?>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -