detailview.php
来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 205 行
PHP
205 行
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_field.php");
?>
<html>
<head>
<title>显示明细</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<?
//echo $type;
//echo "<br>";
//echo $name;
//echo "<br>";
//echo $query;
$query=str_replace("\'","'",$query);
switch ($type)
{
case "EDUCATION":
$Ctype="学历";
switch ($name)
{
case "小学":
$Tname=1;
break;
case "初中":
$Tname=2;
break;
case "高中":
$Tname=3;
break;
case "中专":
$Tname=4;
break;
case "大专":
$Tname=5;
break;
case "大本":
$Tname=6;
break;
case "硕士":
$Tname=7;
break;
case "博士":
$Tname=8;
break;
case "博士后":
$Tname=9;
break;
case "其他":
$Tname="";
break;
}
$query1="select a.USER_ID,b.USER_NAME from HRMS a LEFT OUTER JOIN USER b ON a.USER_ID=b.USER_ID ".$query.field_where_str("HRMS",$_POST,"a.USER_ID")." and a.EDUCATION='$Tname'";
break;
//-------------学历----------------------
case "SEX":
$Ctype="性别";
if ($name!="其他")
{
if ($name=="男")
{
$Tname=0;
}
else
{
$Tname=1;
}
}
else
{
$Tname="";
}
$query1="select a.USER_ID,b.USER_NAME from HRMS a LEFT OUTER JOIN USER b ON a.USER_ID=b.USER_ID ".$query.field_where_str("HRMS",$_POST,"a.USER_ID")." and a.SEX='$Tname'";
break;
//-------------性别----------------------
case "POLITICS":
$Ctype="政治面貌";
switch ($name)
{
case "群众":
$Tname=1;
break;
case "团员":
$Tname=2;
break;
case "党员":
$Tname=3;
break;
case "预备党员":
$Tname=4;
break;
case "其他":
$Tname="";
break;
}
$query1="select a.USER_ID,b.USER_NAME from HRMS a LEFT OUTER JOIN USER b ON a.USER_ID=b.USER_ID ".$query.field_where_str("HRMS",$_POST,"a.USER_ID")." and a.POLITICS='$Tname'";
break;
//-------------政治面貌----------------------
case "HR_BIRTHDAY":
$Ctype="年龄" ;
if ($name=="其他")
{
$query1="select a.USER_ID,b.USER_NAME from HRMS a LEFT OUTER JOIN USER b ON a.USER_ID=b.USER_ID ".$query.field_where_str("HRMS",$_POST,"a.USER_ID")." and a.HR_BIRTHDAY='$Tname'";
}
else
{
$AGERANG=explode("-",$name);
$WHEN_STR="";
if($AGERANG[1]!="")
{
$AGERANG[1]++;
$WHEN_STR.=" and DATE_SUB(CURRENT_DATE(),INTERVAL $AGERANG[1] YEAR)<=a.HR_BIRTHDAY";
}
if($AGERANG[0]!="")
{
$WHEN_STR.=" and a.HR_BIRTHDAY<=DATE_SUB(CURRENT_DATE(),INTERVAL $AGERANG[0] YEAR) ";
}
$query1="select a.USER_ID,b.USER_NAME from HRMS a LEFT OUTER JOIN USER b ON a.USER_ID=b.USER_ID ".$query.field_where_str("HRMS",$_POST,"a.USER_ID").$WHEN_STR;
}
break;
case "c.CODE_NAME":
$Ctype="籍贯";
$Tquery="select CODE_NO from SYS_CODE where CODE_NAME='$name' and PARENT_NO='AREA'";
$Tcursor= exequery($connection,$Tquery);
$TROW=mysql_fetch_array($Tcursor);
$query1="select a.USER_ID,b.USER_NAME from HRMS a LEFT OUTER JOIN USER b ON a.USER_ID=b.USER_ID ".$query.field_where_str("HRMS",$_POST,"a.USER_ID")." and a.NATIVE_PLACE='$TROW[0]'";
break;
case "d.CODE_NAME":
$Ctype="职称";
$Tquery="select CODE_NO from SYS_CODE where CODE_NAME='$name' and PARENT_NO='TECH_POST'";
$Tcursor= exequery($connection,$Tquery);
$TROW=mysql_fetch_array($Tcursor);
$query1="select a.USER_ID,b.USER_NAME from HRMS a LEFT OUTER JOIN USER b ON a.USER_ID=b.USER_ID ".$query.field_where_str("HRMS",$_POST,"a.USER_ID")." and a.TECH_POST='$TROW[0]'";
break;
case "e.CODE_NAME":
$Ctype="员工类型";
$Tquery="select CODE_NO from SYS_CODE where CODE_NAME='$name' and PARENT_NO='CONTRACTTYPE'";
$Tcursor= exequery($connection,$Tquery);
$TROW=mysql_fetch_array($Tcursor);
$query1="select a.USER_ID,b.USER_NAME from HRMS a LEFT OUTER JOIN USER b ON a.USER_ID=b.USER_ID ".$query.field_where_str("HRMS",$_POST,"a.USER_ID")." and a.CONTRACTTYPE='$TROW[0]'";
break;
case "a.JOIN_DATE":
$Ctype="加入本单位时间";
if ($name=="其他")
$Tname="0";
else
$Tname=$name;
$query1="select a.USER_ID,b.USER_NAME from HRMS a LEFT OUTER JOIN USER b ON a.USER_ID=b.USER_ID ".$query.field_where_str("HRMS",$_POST,"a.USER_ID")." and YEAR(a.JOIN_DATE)='$Tname'";
break;
}
//echo $query1;
//break;
?>
</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/infofind.gif"><span class="big3"> <?=$Ctype?>为<?=$name?>的结果：</span><br>
</td>
<td valign="bottom"><span class="small1">共 <span class="big4"><?=$TOTALCOUNT?></span> 条信息</span>
</td>
</tr>
</table>
<div align="center">
<table width="90%" class="TableList">
<tr class="TableHeader">
<td nowrap align="center">编号</td><td nowrap align="center">姓名</td>
</tr>
<?
//$ThisCount=0;
$cursor= exequery($connection,$query1);//echo $query1;
$COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
//$ThisCount++;
$COUNT++;
if($COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$ROW["USER_ID"];?></td>
<td nowrap align="center"><?=$ROW["USER_NAME"];?></td>
</tr>
<?
}
?>
</table>
<br><center><input type="button" value="关闭" class="BigButton" onClick="javascript:window.close();"></center>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?