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

📄 search.php

📁 通达OA官方提供的30源代码,感觉很实在
💻 PHP
字号:
🔍 
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
include_once("inc/utility_file.php");
?>

<html>
<head>
<title>工作计划</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<script src="/inc/js/attach.js"></script>
<script>
function plan_detail(PLAN_ID)
{
  URL="../show/plan_detail.php?PLAN_ID="+PLAN_ID;
  myleft=(screen.availWidth-500)/2;
  window.open(URL,"read_work_plan","height=500,width=600,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=120,left="+myleft+",resizable=yes");
}
</script>

</head>
<body class="bodycolor" topmargin="5">
<?
$MANAGER=$SECRET_TO_ID;
$PARTICIPATOR=$COPY_TO_ID;

//----------- 合法性校验 ---------
if($BEGIN_DATE!="")
{
   $TIME_OK=is_date($BEGIN_DATE);
 
   if(!$TIME_OK)
   {
     Message("错误","起始日期格式不对，应形如 1999-1-2");
     Button_Back();
     exit;
   }
}

if($END_DATE!="")
{
   $TIME_OK=is_date($END_DATE);
 
   if(!$TIME_OK)
   {
     Message("错误","截止日期格式不对，应形如 1999-1-2");
     Button_Back();
     exit;
   }
}
//------------------------ 生成条件字符串 ------------------
$CONDITION_STR="";
if($NAME!="")
   $CONDITION_STR.="NAME like '%".$NAME."%'";
if($CONTENT!="")
{
   if($CONDITION_STR!="")
      $CONDITION_STR.=" and ";
   $CONDITION_STR.="CONTENT like '%".$CONTENT."%'";
}

if($BEGIN_DATE!="")
{
   if($CONDITION_STR!="")
      $CONDITION_STR.=" and ";
   $CONDITION_STR.="BEGIN_DATE>='".$BEGIN_DATE."'";
}

if($END_DATE!="")
{
   if($CONDITION_STR!="")
      $CONDITION_STR.=" and ";
   $CONDITION_STR.="END_DATE<='".$END_DATE."'";
}

if($TYPE!="ALL_TYPE")
{
   if($CONDITION_STR!="")
      $CONDITION_STR.=" and ";
   $CONDITION_STR.="TYPE like '%".$TYPE."%'";
}
if($TO_ID!="")
{
   if($CONDITION_STR!="")
      $CONDITION_STR.=" and ";
   $CONDITION_STR.="TO_ID like '%".$TO_ID."%'";
}
if($TO_ID3!="")
{
   if($CONDITION_STR!="")
      $CONDITION_STR.=" and ";
   $CONDITION_STR.="TO_PERSON_ID like '%".$TO_ID3."%'";
}
if($MANAGER!="")
{
   if($CONDITION_STR!="")
      $CONDITION_STR.=" and ";
   $CONDITION_STR.="MANAGER like '%".$MANAGER."%'";
}
if($PARTICIPATOR!="")
{
   if($CONDITION_STR!="")
      $CONDITION_STR.=" and ";
   $CONDITION_STR.="PARTICIPATOR like '%".$PARTICIPATOR."%'";
}
if($REMARK!="")
{
   if($CONDITION_STR!="")
      $CONDITION_STR.=" and ";
   $CONDITION_STR.="REMARK like '%".$REMARK."%'";
}

//------------------------------------------------------------------------------
if($LOGIN_USER_PRIV=="1")
{
   if($CONDITION_STR!="")
      $CONDITION_STR1=" where ".$CONDITION_STR;
}
else
{
   $CONDITION_STR1=" where (CREATOR='$LOGIN_USER_ID' or find_in_set('$LOGIN_USER_ID',MANAGER))";
   if($CONDITION_STR!="")
      $CONDITION_STR1.=" and $CONDITION_STR";
}

$query = "SELECT count(*) from WORK_PLAN".$CONDITION_STR1;
$cursor= exequery($connection,$query);
$WORK_PLAN_COUNT=0;
if($ROW=mysql_fetch_array($cursor))
   $WORK_PLAN_COUNT=$ROW[0];

if($WORK_PLAN_COUNT==0)
{
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/work_plan.gif" width="22" height="20" align="absmiddle"><span class="big3"> 查询结果</span><br>
    </td>
  </tr>
</table>
<br>

<?
  Message("","无符合条件的工作计划");
?>
   <P align="center"><input type="button"  value="返回" class="BigButton" onClick="location='query.php'"></P>
<?
  exit;
}
?>

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/work_plan.gif" width="22" height="20" align="absmiddle"><span class="big3"> 查询结果</span><br>
    </td>

    <td valign="bottom" class="small1">共<span class="big4">&nbsp;<?=$WORK_PLAN_COUNT?></span>&nbsp;条符合条件的工作计划
    </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">参与人</td>
    <td nowrap align="center">附件</td>
    <td nowrap align="center">状态</td>
    <td nowrap align="center">操作</td>
  </tr>
<?
//============================ 显示查询结果 =======================================
$CUR_DATE=date("Y-m-d",time());
$query = "SELECT PLAN_ID,NAME,BEGIN_DATE,END_DATE,TYPE,MANAGER,PARTICIPATOR,ATTACHMENT_ID,ATTACHMENT_NAME,TO_PERSON_ID,SUSPEND_FLAG from WORK_PLAN".$CONDITION_STR1." order by CREATE_DATE desc";
$cursor= exequery($connection,$query);
$WORK_PLAN_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
   $WORK_PLAN_COUNT++;

   $PLAN_ID=$ROW["PLAN_ID"];
   $PLAN_NAME=$ROW["NAME"];
   $BEGIN_DATE1=$ROW["BEGIN_DATE"];
   $END_DATE1=$ROW["END_DATE"];
   $TYPE1=$ROW["TYPE"];
   $MANAGER1=$ROW["MANAGER"];
   $PARTICIPATOR1=$ROW["PARTICIPATOR"];   
   $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
   $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
   $TO_PERSON_ID=$ROW["TO_PERSON_ID"];
   $SUSPEND_FLAG=$ROW["SUSPEND_FLAG"];

   $query = "SELECT TYPE_NAME from PLAN_TYPE where TYPE_ID='$TYPE1'";
   $cursor1= exequery($connection,$query);
   if($ROW1=mysql_fetch_array($cursor1))
      $TYPE_DESC=$ROW1["TYPE_NAME"];
   else
      $TYPE_DESC="";
      
   $MANAGE_NAME="";
   $TOK=strtok($MANAGER1,",");
   while($TOK!="")
   {
     $query1="select DEPT_ID,USER_NAME from USER where USER_ID='$TOK'";
     $cursor1= exequery($connection,$query1);
     if($ROW1=mysql_fetch_array($cursor1))
     {
        $DEPT_ID=$ROW1["DEPT_ID"];
        $DEPT_NAME=dept_long_name($DEPT_ID);
        $MANAGE_NAME.="<u title=\"部门：".$DEPT_NAME."\" style=\"cursor:hand\">".$ROW1["USER_NAME"]."</u>"."，";
     }
     $TOK=strtok(",");
   }
   $MANAGE_NAME=substr($MANAGE_NAME,0,-2);

    $PARTICIPATOR_NAME="";
    $TOK=strtok($PARTICIPATOR1,",");
    while($TOK!="")
    {
      $query1="select DEPT_ID,USER_NAME from USER where USER_ID='$TOK'";
      $cursor1= exequery($connection,$query1);
      if($ROW2=mysql_fetch_array($cursor1))
      {
         $DEPT_ID=$ROW2["DEPT_ID"];
         $DEPT_NAME=dept_long_name($DEPT_ID);
         $PARTICIPATOR_NAME.="<u title=\"部门：".$DEPT_NAME."\" style=\"cursor:hand\">".$ROW2["USER_NAME"]."</u>"."，";
      }
      $TOK=strtok(",");
    }
    $PARTICIPATOR_NAME=substr($PARTICIPATOR_NAME,0,-2);

   if($SUSPEND_FLAG==1)
   {
   	  if(compare_date($CUR_DATE,$BEGIN_DATE1)<0)
      {
         $STATUS=1;
         $STATUS_DESC="未开始";
      }
      else
      {
         $STATUS=2;
         $STATUS_DESC="<font color='#00AA00'><b>进行中</b></font>";
      }
   
      if($END_DATE1!="0000-00-00")
      {
        if(compare_date($CUR_DATE,$END_DATE1)>0)
        {
           $STATUS=3;
           $STATUS_DESC="<font color='#FF0000'><b>已结束</b></font>";
        }
      }

   }
   else
   {
      $STATUS=2;
      $STATUS_DESC="<font color='#FF0000'><b>暂停</b></font>";
   } 

   if($WORK_PLAN_COUNT%2==1)
      $TableLine="TableLine1";
   else
      $TableLine="TableLine2";

   if($END_DATE1=="0000-00-00")
      $END_DATE1="";
?>
    <tr class="<?=$TableLine?>">
      <td align="center"><?=$WORK_PLAN_COUNT?></td>   
      <td align="center"><a href="javascript:plan_detail('<?=$PLAN_ID?>');"><?=$PLAN_NAME?></a>
      <input type="button"  value="进度图" class="SmallButton" onClick="window.open('../show/progress_map.php?PLAN_ID=<?=$PLAN_ID?>','','status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=0,top=0,resizable=yes');" title="查看进度图">
      </td>
      <td nowrap align="center"><?=$BEGIN_DATE1?></td>
      <td nowrap align="center"><?=$END_DATE1?></a></td>
      <td nowrap align="center"><?=$TYPE_DESC?></td>
      <td align="center"><?=$MANAGE_NAME?></td>
      <td align="center"><?=$PARTICIPATOR_NAME?></td>
      <td align="left">
<?
     if($ATTACHMENT_NAME=="")
        echo "无";
     else
        echo attach_link($ATTACHMENT_ID,$ATTACHMENT_NAME,0,1,1,0,0,1,0,0); 
?>
     </td>
     <td nowrap align="center"><?=$STATUS_DESC?></td>
     <td nowrap align="center"> 	
<?
     if($STATUS==1)
     {
?>
     <a href="new?PLAN_ID=<?=$PLAN_ID?>"> 修改</a>  
     <a href="javascript:delete_work_plan('<?=$PLAN_ID?>');"> 删除</a>
<?
     }
     else if($LOGIN_USER_PRIV==1)
     {
?>
     <a href="new?PLAN_ID=<?=$PLAN_ID?>"> 修改</a>  
     <a href="javascript:delete_work_plan('<?=$PLAN_ID?>');"> 删除</a>
<?
     }
?>
     <a href="javascript:;" onClick="window.open('add_opinion.php?PLAN_ID=<?=$PLAN_ID?>','','height=500,width=600,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=200,top=60,resizable=yes');">批注</a><br>
<?
     if($STATUS==1 || $STATUS==3)
     {
?>
     <a href="manage.php?PLAN_ID=<?=$PLAN_ID?>&OPERATION=<?=$STATUS?>&SEARCH_FLAG=1"> 生效</a>
<?
     }
     else if($STATUS==2)
     {
     	  if($SUSPEND_FLAG==1)    	  
           echo "<a href=\"manage.php?PLAN_ID=$PLAN_ID&OPERATION=4&SEARCH_FLAG=1\"> 暂停</a>";       
        else
           echo "<a href=\"manage.php?PLAN_ID=$PLAN_ID&OPERATION=5&SEARCH_FLAG=1\"> 继续</a>";       
?>         
     <a href="manage.php?PLAN_ID=<?=$PLAN_ID?>&OPERATION=2&SEARCH_FLAG=1"> 结束</a>
<?
     }
?>
     </td>
   </tr>
<?
}
?>

<tr class="TableControl">
<td colspan="10" align="center">
	  <input type="button"  value="导出" class="BigButton" onclick="location='export.php?CONDITION_STR1=<?=str_replace("'","`",$CONDITION_STR1)?>'" title="导出工作计划">&nbsp;&nbsp;&nbsp;&nbsp;	
    <input type="button"  value="返回" class="BigButton" onClick="location='query.php'">
</td>
</tr>

</table>
</body>

</html>

⌨️ 快捷键说明

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