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

📄 index1.php

📁 通达OA官方提供的30源代码,感觉很实在
💻 PHP
字号:
🔍 
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
$ITEMS_IN_PAGE=15;
if(!isset($start))
   $start=0;
?>

<html>
<head>
<title>投票管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<script>
function show_reader(VOTE_ID)
{
 URL="show_reader.php?VOTE_ID="+VOTE_ID;
 myleft=(screen.availWidth-780)/2;
 window.open(URL,"read_vote","height=500,width=780,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}

function delete_vote(VOTE_ID,start)
{
 msg='确认要删除该投票么？';
 if(window.confirm(msg))
 {
  URL="delete.php?VOTE_ID=" + VOTE_ID + "&start=" + start;
  window.location=URL;
 }
}


function delete_all()
{
 msg='确认要删除所有投票么？\n删除后将不可恢复，确认删除请输入大写字母“OK”';
 if(window.prompt(msg,"") == "OK")
 {
  URL="delete_all.php";
  window.location=URL;
 }
}

function check_all()
{
 for (i=0;i<document.all("email_select").length;i++)
 {
   if(document.all("allbox").checked)
      document.all("email_select").item(i).checked=true;
   else
      document.all("email_select").item(i).checked=false;
 }

 if(i==0)
 {
   if(document.all("allbox").checked)
      document.all("email_select").checked=true;
   else
      document.all("email_select").checked=false;
 }
}

function check_one(el)
{
   if(!el.checked)
      document.all("allbox").checked=false;
}
function get_checked()
{
  checked_str="";
  for(i=0;i<document.all("email_select").length;i++)
  {

      el=document.all("email_select").item(i);
      if(el.checked)
      {  val=el.value;
         checked_str+=val + ",";
      }
  }

  if(i==0)
  {
      el=document.all("email_select");
      if(el.checked)
      {  val=el.value;
         checked_str+=val + ",";
      }
  }
  return checked_str;
}
function delete_mail()
{
  delete_str=get_checked();

  if(delete_str=="")
  {
     alert("要删除投票，请至少选择其中一条。");
     return;
  }

  msg='确认要删除所选投票么？';
  if(window.confirm(msg))
  {
    url="delete.php?DELETE_STR="+ delete_str +"&start=<?=$start?>";
    location=url;
  }
}
function clear_vote()
{
  delete_str=get_checked();

  if(delete_str=="")
  {
     alert("要清空数据，请至少选择其中一条。");
     return;
  }

  msg='确认要清空所选投票数据么？';
  if(window.confirm(msg))
  {
    location="clear.php?DELETE_STR="+ delete_str +"&start=<?=$start?>";
  }
}
function clone()
{
  delete_str=get_checked();

  if(delete_str=="")
  {
     alert("要复制投票，请至少选择其中一条。");
     return;
  }

  msg='确认要复制所选投票么？';
  if(window.confirm(msg))
  {
    location="clone.php?DELETE_STR="+ delete_str +"&start=<?=$start?>";
  }
}

function release(VOTE_ID,start)
{
   msg='确认要发布该投票么？';
   if(window.confirm(msg))
   {
     url="manage.php?VOTE_ID="+VOTE_ID+"&OPERATION=9&start="+start; 
     location=url;
   }
}
</script>

</head>
<body class="bodycolor" topmargin="5">
<?
 $CUR_TIME=date("Y-m-d H:i:s",time());

 if($LOGIN_USER_PRIV!="1")
    $query = "SELECT * from VOTE_TITLE where PARENT_ID=0 and FROM_ID='$LOGIN_USER_ID' order by BEGIN_DATE,SEND_TIME desc";
 else
    $query = "SELECT * from VOTE_TITLE where PARENT_ID=0 order by SEND_TIME desc";
 $cursor= exequery($connection,$query);
 $VOTE_COUNT=mysql_num_rows($cursor);

 if($VOTE_COUNT==0)
 {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/vote.gif" align="absmiddle"><span class="big3"> 管理已发布的投票</span><br>
    </td>
  </tr>
</table>
<br>

<?
   Message("","无已发布的投票");
   exit;
 }
?>

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/vote.gif" align="absmiddle"><span class="big3"> 管理已发布的投票</span><br>
    </td>
    <td align="right" valign="bottom" class="small1">共<span class="big4">&nbsp;<?=$VOTE_COUNT?></span>&nbsp;条
    </td>
    <td align="right" valign="bottom" class="small1"><?=page_bar($start,$VOTE_COUNT,$ITEMS_IN_PAGE)?></td>
    </tr>
</table>

<table class="TableList" width="100%">
  <tr class="TableHeader">
      <td nowrap align="center">选择</td>
      <td nowrap align="center">发布人</td>
      <td nowrap align="center">发布范围</td>
      <td nowrap align="center">标题</td>
      <td nowrap align="center">类型</td>
      <td nowrap align="center">匿名</td>
      <td nowrap align="center">生效日期 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
      <td nowrap align="center">终止日期</td>
      <td nowrap align="center">状态</td>
      <td nowrap align="center">操作</td>
    </tr>

<?
 //============================ 显示已发布公告 =======================================
 $CUR_DATE=date("Y-m-d",time());

 $VOTE_COUNT=0;
 while($ROW=mysql_fetch_array($cursor))
 {
    $VOTE_COUNT++;

    $VOTE_ID=$ROW["VOTE_ID"];
    $FROM_ID=$ROW["FROM_ID"];
    $TO_ID=$ROW["TO_ID"];
    $PRIV_ID=$ROW["PRIV_ID"];
    $USER_ID=$ROW["USER_ID"];
    $SUBJECT=$ROW["SUBJECT"];
    $TYPE=$ROW["TYPE"];
    $ANONYMITY=$ROW["ANONYMITY"];
    $SEND_TIME=$ROW["SEND_TIME"];
    $BEGIN_DATE=$ROW["BEGIN_DATE"];
    $END_DATE=$ROW["END_DATE"];
    $READERS=$ROW["READERS"];
    $PUBLISH=$ROW["PUBLISH"];

    $SUBJECT=htmlspecialchars($SUBJECT);

    if($TYPE=="0")
       $TYPE_DESC="单选";
    else if($TYPE=="1")
       $TYPE_DESC="多选";
    else
       $TYPE_DESC="文本输入";

    if($PUBLISH=="0")
       $PUBLISH_DESC="<font color='#FF0000'><b>未发布</b></font>";
    else
       $PUBLISH_DESC="<font color='#00AA00'><b>已发布</b></font>";

    if($ANONYMITY=="0")
       $ANONYMITY_DESC="不允许";
    else
       $ANONYMITY_DESC="允许";

    if($END_DATE=="0000-00-00")
       $END_DATE="";

    $query1="select * from USER where USER_ID='$FROM_ID'";
    $cursor1= exequery($connection,$query1);
    if($ROW=mysql_fetch_array($cursor1))
    {
       $FROM_NAME=$ROW["USER_NAME"];
       $DEPT_ID=$ROW["DEPT_ID"];
    }

    $DEPT_NAME=dept_long_name($DEPT_ID);

    if($TO_ID=="ALL_DEPT")
       $TO_NAME="全体部门";
    else
    {
      $TO_NAME="";
      $query1="select DEPT_NAME from DEPARTMENT where find_in_set(DEPT_ID,'$TO_ID')";
      $cursor1= exequery($connection,$query1);
      while($ROW=mysql_fetch_array($cursor1))
        $TO_NAME.=$ROW["DEPT_NAME"]."，";
    }

    $PRIV_NAME="";
    $query1="select * from USER_PRIV where find_in_set(USER_PRIV,'$PRIV_ID')";
    $cursor1= exequery($connection,$query1);
    while($ROW=mysql_fetch_array($cursor1))
       $PRIV_NAME.=$ROW["PRIV_NAME"]."，";

    $USER_NAME="";
    $query1="select * from USER where find_in_set(USER_ID,'$USER_ID')";
    $cursor1= exequery($connection,$query1);
    while($ROW=mysql_fetch_array($cursor1))
       $USER_NAME.=$ROW["USER_NAME"]."，";

    $TO_NAME_STR="";
    $TO_NAME_TITLE="";
    if($TO_NAME!="")
    {
       if(substr($TO_NAME,-2)=="，")
          $TO_NAME=substr($TO_NAME,0,-2);
       $TO_NAME_TITLE.="部门：".$TO_NAME;
       $TO_NAME_STR.="<font color=#0000FF><b>部门：</b></font>".csubstr(strip_tags($TO_NAME),0,20).(strlen($TO_NAME)>20?"...":"")."<br>";
    }
    if($PRIV_NAME!="")
    {
       if(substr($PRIV_NAME,-2)=="，")
          $PRIV_NAME=substr($PRIV_NAME,0,-2);
       if($TO_NAME_TITLE!="")
          $TO_NAME_TITLE.="\n\n";
       $TO_NAME_TITLE.="角色：".$PRIV_NAME;
       $TO_NAME_STR.="<font color=#0000FF><b>角色：</b></font>".csubstr(strip_tags($PRIV_NAME),0,20).(strlen($PRIV_NAME)>20?"...":"")."<br>";
    }
    if($USER_NAME!="")
    {
       if(substr($USER_NAME,-2)=="，")
          $USER_NAME=substr($USER_NAME,0,-2);
       if($TO_NAME_TITLE!="")
          $TO_NAME_TITLE.="\n\n";
       $TO_NAME_TITLE.="人员：".$USER_NAME;
       $TO_NAME_STR.="<font color=#0000FF><b>人员：</b></font>".csubstr(strip_tags($USER_NAME),0,20).(strlen($USER_NAME)>20?"...":"")."<br>";
    }

    if(compare_date($CUR_DATE,$BEGIN_DATE)<0)
    {
       $VOTE_STATUS=1;
       $VOTE_STATUS_STR="待生效";
    }
    else
    {
       $VOTE_STATUS=2;
       $VOTE_STATUS_STR="<font color='#00AA00'><b>生效</b></font>";
    }


    if($END_DATE!="")
    {
      if(compare_date($CUR_DATE,$END_DATE)>0)
      {
         $VOTE_STATUS=3;
         $VOTE_STATUS_STR="<font color='#FF0000'><b>终止</b></font>";
      }
    }

    if($PUBLISH=="0")
       $VOTE_STATUS_STR="";

    if($VOTE_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";
?>
    <tr class="<?=$TableLine?>">
      <td>&nbsp;<input type="checkbox" name="email_select" value="<?=$VOTE_ID?>" onClick="check_one(self);">
      <td nowrap align="center"><u title="部门：<?=$DEPT_NAME?>" style="cursor:hand"><?=$FROM_NAME?></u></td>
      <td title="<?=$TO_NAME_TITLE?>"><?=$TO_NAME_STR?></td>
      <td>
      <a href="javascript:show_reader('<?=$VOTE_ID?>');" title="点击查看投票情况"><?=$SUBJECT?></a>
      </td>
      <td nowrap align="center"><?=$TYPE_DESC?></td>
      <td nowrap align="center"><?=$ANONYMITY_DESC?></td>
      <td nowrap align="center"><?=$BEGIN_DATE?></td>
      <td nowrap align="center"><?=$END_DATE?></td>
      <td nowrap align="center"><?=$VOTE_STATUS_STR==""? $PUBLISH_DESC:$VOTE_STATUS_STR?></td>
      <td align="center" nowrap> 
      <a href="vote.php?PARENT_ID=<?=$VOTE_ID?>&start=<?=$start?>"> 子投票</a>
      <a href="item?VOTE_ID=<?=$VOTE_ID?>&start=<?=$start?>"> 投票项目</a>
      <a href="new.php?VOTE_ID=<?=$VOTE_ID?>&start=<?=$start?>"> 修改</a>
	  <?
      if($VOTE_STATUS==1)
      {
      ?>
      <a href="manage.php?VOTE_ID=<?=$VOTE_ID?>&OPERATION=1&start=<?=$start?>"> 立即生效</a>
      <?
      }
      else if(($VOTE_STATUS==2)&&($PUBLISH!="0"))
      {
      ?>
      <a href="manage.php?VOTE_ID=<?=$VOTE_ID?>&OPERATION=2&start=<?=$start?>"> 立即终止</a>
      <?
      }
      else if($VOTE_STATUS==3)
      {
      ?>
      <a href="manage.php?VOTE_ID=<?=$VOTE_ID?>&OPERATION=3&start=<?=$start?>"> 恢复生效</a>
      <?
      }
      ?>
      <?
	  if($PUBLISH=="0")
	  {
      ?>
	     <a href="#" onClick="javascript:release('<?=$VOTE_ID?>','<?=$start?>');"> 立即发布</a>
      <?
       }
	  ?>
      </td>
    </tr>
<?
 }
?>

<tr class="TableControl">
<td colspan="19">
    <input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();"><label for="allbox_for">全选</label> &nbsp;
    <a href="javascript:delete_mail();" title="删除所选投票"><img src="/images/delete.gif" align="absMiddle">删除</a>&nbsp;
<?
if($LOGIN_USER_PRIV=="1")
{
?>
    <a href="javascript:delete_all();" title="删除所有自己发布的投票"><img src="/images/delete.gif" align="absMiddle">全部删除</a>&nbsp;
<?
}
?>
    <a href="javascript:clear_vote();" title="清空投票数据"><img src="/images/delete.gif" align="absMiddle">清空数据</a>&nbsp;
    <a href="javascript:clone();" title="复制投票，但不复制数据"><img src="/images/copy.gif" align="absMiddle">克隆</a>&nbsp;
</td>
</tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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