search.php

来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 483 行 · 第 1/2 页

 if($NO!="")
 {
 	 if($query=="")
       $query.=" where a.NO like '%".$NO."%'";
   else
       $query.=" and a.NO like '%".$NO."%'";
  }
 if($NATION!="")
 {
 	 if($query=="")
       $query.=" where a.NATION like '%".$NATION."%'";
    else
      $query.=" and a.NATION like '%".$NATION."%'";
  }
 if($CARD_NO!="")
   {
 	 if($query=="")
       $query.=" where a.CARD_NO like '%".$CARD_NO."%'";
    else
      $query.=" and a.CARD_NO like '%".$CARD_NO."%'";
  }
 if($NATIVE_PLACE!="")
 {
   if($query=="")
       $query.=" where a.NATIVE_PLACE='$NATIVE_PLACE'";
   else
       $query.=" and a.NATIVE_PLACE='$NATIVE_PLACE'";
 }
  if($CONTRACTTYPE!="")
 {
   if($query=="")
       $query.=" where a.CONTRACTTYPE='$CONTRACTTYPE'";
   else
       $query.=" and a.CONTRACTTYPE='$CONTRACTTYPE'";
 }
 if($HUKOU_PLACE!="")
 {
 	 if($query=="")
       $query.=" where a.HUKOU_PLACE like '%".$HUKOU_PLACE."%'";
    else
      $query.=" and a.HUKOU_PLACE like '%".$HUKOU_PLACE."%'";
  }
 if($SPECIALITY!="")
  {
 	 if($query=="")
       $query.=" where a.SPECIALITY like '%".$SPECIALITY."%'";
    else
      $query.=" and a.SPECIALITY like '%".$SPECIALITY."%'";
  }
 if($SCHOOL!="")
  {
 	 if($query=="")
       $query.=" where a.SCHOOL like '%".$SCHOOL."%'";
    else
      $query.=" and a.SCHOOL like '%".$SCHOOL."%'";
  }
 if($DEPARTMENT!="")
  {
 	 if($query=="")
       $query.=" where a.DEPARTMENT like '%".$DEPARTMENT."%'";
    else
       $query.=" and a.DEPARTMENT like '%".$DEPARTMENT."%'";
  }
 if($POST!="")
 {
 	 if($query=="")
       $query.=" where a.POST like '%".$POST."%'";
    else
       $query.=" and a.POST like '%".$POST."%'";
  }
 if($TECH_POST!="")
 {
   if($query=="")
       $query.=" where a.TECH_POST='$TECH_POST'";
   else
       $query.=" and a.TECH_POST='$TECH_POST'";
  }
$query.=field_where_str("HRMS",$_POST,"a.USER_ID");
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/finance1.gif" width="24" height="24"><span class="big3"> 人事档案统计结果</span><br>
    </td>
  </tr>
</table>
<br>
<?
 $HRMS_COUNT=0;
 if($TYPENAME_ARRAY[1]=="EDUCATION")
 $query1="select  (CASE ".$TYPENAME_ARRAY[0]." WHEN '1' THEN '小学'
                                              WHEN '2' THEN '初中'
                                              WHEN '3' THEN '高中'
                                              WHEN '4' THEN '中专'
                                              WHEN '5' THEN '大专'
                                              WHEN '6' THEN '大本'
                                              WHEN '7' THEN '硕士'
                                              WHEN '8' THEN '博士'
                                              WHEN '9' THEN '博士后' END) as SUMNAME,
          COUNT(DISTINCT a.USER_ID) as TOTALCOUNT 
          from HRMS a  LEFT OUTER JOIN USER b ON a.USER_ID=b.USER_ID
          LEFT OUTER JOIN DEPARTMENT f ON b.DEPT_ID=f.DEPT_ID
          LEFT OUTER JOIN USER_PRIV  g ON b.USER_PRIV=g.USER_PRIV
          ".$query.field_where_str("HRMS",$_POST,"a.USER_ID").$WHERE_STR." GROUP BY ".$TYPENAME_ARRAY[0];

 if($TYPENAME_ARRAY[1]=="SEX")
 $query1="select  (CASE ".$TYPENAME_ARRAY[0]." WHEN '0' THEN '男'
                                              WHEN '1' THEN '女'  END) as SUMNAME,
          COUNT(DISTINCT a.USER_ID) as TOTALCOUNT 
          from HRMS a  LEFT OUTER JOIN USER b ON a.USER_ID=b.USER_ID
          LEFT OUTER JOIN DEPARTMENT f ON b.DEPT_ID=f.DEPT_ID
          LEFT OUTER JOIN USER_PRIV  g ON b.USER_PRIV=g.USER_PRIV
          ".$query.field_where_str("HRMS",$_POST,"a.USER_ID").$WHERE_STR." GROUP BY ".$TYPENAME_ARRAY[0];

 if($TYPENAME_ARRAY[1]=="POLITICS")
 $query1="select  (CASE ".$TYPENAME_ARRAY[0]." WHEN '1' THEN '群众'
                                              WHEN '2' THEN '团员'
                                              WHEN '3' THEN '党员'
                                              WHEN '4' THEN '预备党员' END) as SUMNAME,
          COUNT(DISTINCT a.USER_ID) as TOTALCOUNT 
          from HRMS a  LEFT OUTER JOIN USER b ON a.USER_ID=b.USER_ID
           LEFT OUTER JOIN DEPARTMENT f ON b.DEPT_ID=f.DEPT_ID
           LEFT OUTER JOIN USER_PRIV  g ON b.USER_PRIV=g.USER_PRIV
          ".$query.field_where_str("HRMS",$_POST,"a.USER_ID").$WHERE_STR." GROUP BY ".$TYPENAME_ARRAY[0];
 if($TYPENAME_ARRAY[1]=="HR_BIRTHDAY")
 {
 	$ARRAY_STATIS=explode(",",$AGE_RANGE);
 	$ARRAY_COUNT=sizeof($ARRAY_STATIS);
 	for ($i=0;$i<$ARRAY_COUNT;$i++)
  {
  	$AGERANG=explode("-",$ARRAY_STATIS[$i]);
    $WHEN_STR="";
    if($AGERANG[1]!="")
    {
     $AGERANG[1]++;
     if($WHEN_STR=="")
         $WHEN_STR.=" WHEN DATE_SUB(CURRENT_DATE(),INTERVAL $AGERANG[1] YEAR)<= a.HR_BIRTHDAY";
     else
         $WHEN_STR.="  and DATE_SUB(CURRENT_DATE(),INTERVAL $AGERANG[1] YEAR)<=a.HR_BIRTHDAY";
    }
    if($AGERANG[0]!="")
    {
     if($WHEN_STR=="")
         $WHEN_STR.=" WHEN a.HR_BIRTHDAY<=DATE_SUB(CURRENT_DATE(),INTERVAL $AGERANG[0]  YEAR) ";
     else
         $WHEN_STR.="  and a.HR_BIRTHDAY<=DATE_SUB(CURRENT_DATE(),INTERVAL $AGERANG[0]  YEAR) ";
    }

    $WHEN_STR=$WHEN_STR." THEN '$ARRAY_STATIS[$i]' ";
   $STRCASE=$STRCASE.$WHEN_STR;
  }

 	$query1="select  (CASE ".$STRCASE."  END) as SUMNAME,
          COUNT(DISTINCT a.USER_ID) as TOTALCOUNT 
          from HRMS a  LEFT OUTER JOIN USER b ON a.USER_ID=b.USER_ID
          LEFT OUTER JOIN DEPARTMENT f ON b.DEPT_ID=f.DEPT_ID
          LEFT OUTER JOIN USER_PRIV  g ON b.USER_PRIV=g.USER_PRIV
          ".$query.field_where_str("HRMS",$_POST,"a.USER_ID").$WHERE_STR."  GROUP BY SUMNAME";
 }

 if($TYPENAME_ARRAY[0]=="a.NATIVE_PLACE" || $TYPENAME_ARRAY[0]=="a.TECH_POST" || $TYPENAME_ARRAY[0]=="a.CONTRACTTYPE")
 {
 	 $query1="select  ".$TYPENAME_ARRAY[1]." as SUMNAME, COUNT(DISTINCT a.USER_ID) as TOTALCOUNT
            from HRMS a
            LEFT OUTER JOIN USER b ON a.USER_ID=b.USER_ID
            LEFT OUTER JOIN SYS_CODE c
            ON a.NATIVE_PLACE = c.CODE_NO AND c.PARENT_NO = 'AREA'
            LEFT OUTER JOIN SYS_CODE d
            ON a.TECH_POST = d.CODE_NO AND d.PARENT_NO = 'TECH_POST'
            LEFT OUTER JOIN SYS_CODE e
            ON a.CONTRACTTYPE = e.CODE_NO AND e.PARENT_NO = 'CONTRACTTYPE'
             LEFT OUTER JOIN DEPARTMENT f ON b.DEPT_ID=f.DEPT_ID
            LEFT OUTER JOIN USER_PRIV  g ON b.USER_PRIV=g.USER_PRIV
            ".$query.field_where_str("HRMS",$_POST,"a.USER_ID").$WHERE_STR." GROUP BY ".$TYPENAME_ARRAY[0];
 }
 if($TYPENAME_ARRAY[0]=="a.JOIN_DATE")
 {
 	 $query1="select  IF (YEAR(".$TYPENAME_ARRAY[1].")=0,'其他',YEAR(".$TYPENAME_ARRAY[1].")) as SUMNAME, COUNT(DISTINCT a.USER_ID) as TOTALCOUNT
            from HRMS a
            LEFT OUTER JOIN USER b ON a.USER_ID=b.USER_ID
            LEFT OUTER JOIN SYS_CODE c
            ON a.NATIVE_PLACE = c.CODE_NO AND c.PARENT_NO = 'AREA'
            LEFT OUTER JOIN SYS_CODE d
            ON a.TECH_POST = d.CODE_NO AND d.PARENT_NO = 'TECH_POST'
            LEFT OUTER JOIN SYS_CODE e
            ON a.CONTRACTTYPE = e.CODE_NO AND e.PARENT_NO = 'CONTRACTTYPE'
             LEFT OUTER JOIN DEPARTMENT f ON b.DEPT_ID=f.DEPT_ID
         LEFT OUTER JOIN USER_PRIV  g ON b.USER_PRIV=g.USER_PRIV
            ".$query.field_where_str("HRMS",$_POST,"a.USER_ID").$WHERE_STR." GROUP BY SUMNAME";
 }
 $cursor= exequery($connection,$query1);
 
 //echo $query1;
 //break;
 
 $TOTAL_SUMSALE=0;
 while($ROW=mysql_fetch_array($cursor))
 {
   $HRMS_COUNT++;
   $SUMNAME=$ROW["SUMNAME"];
   if($SUMNAME=="")$SUMNAME="其他";
   $TOTALCOUNT=$ROW["TOTALCOUNT"];
   $ARRAY_FIELD=$ARRAY_FIELD.$SUMNAME.",";
   $graphValues=$graphValues.$TOTALCOUNT.",";
   $TOTAL_SUMSALE=$TOTAL_SUMSALE+$TOTALCOUNT;
   if($HRMS_COUNT==1)
   {
?>
<table width="100%" class="TableList">
  <tr class="TableHeader">
      <td nowrap align="center"><?=$TYPENAME_ARRAY[2]?></td>
      <td nowrap align="center">人员数</td>
  </tr>
<?
   }
?>
 <tr class="TableData">
      <td nowrap align="center"><?=$SUMNAME?></td>
      <td nowrap align="center" title="点击查看详细"><a href="#" onClick="javascript:LoadWindow1('<?=$TYPENAME_ARRAY[1]?>','<?=$SUMNAME?>','<?=urlencode($query)?>','<?=$TOTALCOUNT?>');"><?=$TOTALCOUNT?></a></td>
 </tr>
<?
}
if($HRMS_COUNT==0)
{
   Message("","无符合条件的人事档案信息");
   Button_Back();
   exit;
}
?>
<tr class="TableHeader">
   <td nowrap align="center">合计：</td>
   <td nowrap align="center"><?=$TOTAL_SUMSALE?></td>
</tr>

<thead class="TableData">
   <td nowrap align="center" colspan="2" width="700" height="400"><img src="cakeimg.php?ARRAY_FIELD1=<?=$ARRAY_FIELD?>&graphValues1=<?=$graphValues?>"></td>
</thead>
</table>
<br><center><input type="button" class="BigButton" value="返回" onClick="location='index.php'"></center>
</body>
</html>