//show the detail record
if ($total==0 and isset($id)){
echo " 职员信息 >>返回一览<< ";
//sql
$sql = "select * from t_user_new";
if (isset($id)){
$sql = $sql." where empid=".$id;
}
//sql exec
$query=@mysql_query($sql,$connect);
$i=0;
//data not found
if (!$query)
{
echo "Data get Error(c1001). ";
echo " ";
}
else
{
// read recorders
//rows
if ($array=mysql_fetch_array($query))
{
?>
if ($array[photo]!="") {
echo " | ";
}else{
echo "No photo exists.";
}
?>
|
■
|
|
switch ($array[city]){
case "sh":
echo "通用电脑上海事务所";
break;
case "cs":
echo "通用电脑湖南有限公司";
break;
case "os":
echo "大阪本社";
break;
case "tk":
echo "东京本社";
break;
}
?>
|
|
switch ($array[responsibility]){
case "1":
$res_name="部门经理";
break;
case "2":
$res_name="部门副经理";
break;
case "3":
$res_name="项目经理";
break;
case "4":
$res_name="项目副经理";
break;
case "5":
$res_name="项目主管";
break;
case "6":
$res_name="一般员工";
break;
}
echo $res_name;
?>
switch ($array[department]){
case "1":
$dep_name = "开发一课";
break;
case "2":
$dep_name = "开发二课";
break;
case "3":
$dep_name = "开发三课";
break;
case "4":
$dep_name = "管理部门";
break;
case "5":
$dep_name = "总务行政部门";
break;
case "6":
$dep_name = "其他部门";
break;
}
echo $dep_name;
?>
|
| |
|
|
| 性别 |
: |
if ($array[gender]=="1"){
echo "男";
}else{
echo "女";
}
?>
|
| 年龄 |
: |
if ($array[birthday]!=""){
echo date(Y)-substr($array[birthday],0,4);
}
?>
|
| 籍贯 |
: |
|
| 入社 |
: |
if ($array[hire_date]!=""){
echo date_format($array[hire_date]);
}?>
|
| |
|
|
| 公司电话 |
: |
|
| 住所电话 |
: |
|
| 移动电话 |
: |
|
| MSN |
: |
|
| OICQ |
: |
|
| e-Mail |
: |
|
| LAN IP |
: |
|
■ 目前所在项目
|
|
}else{
echo "No data found you want";
}
}
}elseif ($total=1 or !isset($total)){
//sql made
$sql = "select * from t_user_new order by city, emp_num ";
//sql exec
$query=@mysql_query($sql,$connect);
//data not found
if (!$query)
{
echo "Data get Error. ";
}else{
// read recorders
//rows
$i=0;
?>
| 社员编号 |
姓名 |
勤务地 |
职务 |
详情 |
while ($array=@mysql_fetch_array($query))
{
?>
|
echo $array[emp_num];
?> |
echo $array[name];
?> |
switch ($array[city]){
case "sh":
echo "上海事务所";
break;
case "cs":
echo "湖南有限公司";
break;
case "os":
echo "大阪本社";
break;
case "tk":
echo "东京本社";
break;
}?> |
switch ($array[responsibility]){
case "1":
$res_name="部门经理";
break;
case "2":
$res_name="部门副经理";
break;
case "3":
$res_name="项目经理";
break;
case "4":
$res_name="项目副经理";
break;
case "5":
$res_name="项目主管";
break;
case "6":
$res_name="一般员工";
break;
}
echo $res_name;
?> |
 |
|
$i++;
}
?>
|
if ($i==0){
echo " No data found";
}
}
}
?>
|