<!--#Include file
="../include/db.inc"-->
<html>
<head>
<title>各区必修课数据查询</title>
<style>
.t_i{width:1520px; height:auto; float:
center; border-right:0px solid #000; border-top:1px solid #000}
.t_i_h{width:100%; overflow-x:hidden; background:buttonface;}
.t_i_h table{width:1500px;}
.t_i_h table td{border-right:1px solid #000; border-bottom:1px solid #000; height:20px; text-
align:
center}
.cc{width:100%; height:625px; border-bottom:1px solid #000; border-right:1px solid #000; background:#fff; overflow:auto;}
.cc table{width:1500px; }
.cc table td{height:25px; border-bottom:1px solid #000; border-right:1px solid #000; text-
align:
center}
</style>
<script>
function aa(){
var a
=document.getElementById("cc").scrollTop;
var b
=document.getElementById("cc").scrollLeft;
document.getElementById("hh").scrollLeft
=b;
}
</script>
<link href
="../images/cssexamin.css" rel
="stylesheet" type
="text/css">
<script src
="laydate/laydate.js"></script>
</head>
<body class
="banquan" background
="../images/11-08.gif">
<table border
="0"
align="
center" width
="100%" cellpadding
='0'
valign="top">
<tr>
<td
align="
center" width
="100%">
<img src
="../images/pic.jpg">
</td>
</tr>
</table>
<br><br>
<form action
="" name
="form1" method
="post">
<table width
="750" border
="0"
align="
center" cellpadding
="2" cellspacing
="1" class
="banquan">
<tr>
<td width
="8%"><font face
="Arial">Emp.NO:</font></td>
<td width
="6%"
align="
center">
<input name
="EmpNo" type
="text" id
="EmpNo" size
="15">
</td>
<td> </td>
<td width
="11%"><font face
="Arial">Section:</font></td>
<td width
="10%"
align="
center">
<font size
="2" face
="Arial">
<select name
="Section">
<option value
=""></option>
<option value
="TF1">TF1</option>
<option value
="TF2">TF2</option>
<option value
="CMP1">CMP1</option>
<option value
="CVD1">CVD1</option>
<option value
="PVD1">PVD1</option>
<option value
="CMP2">CMP2</option>
<option value
="CVD2">CVD2</option>
<option value
="PVD2">PVD2</option>
<option value
="4F">4F</option>
<option value
="CMP3">CMP3</option>
<option value
="TF3">TF3</option>
<option value
="DIFF1">DIFF1</option>
<option value
="IMP1">IMP1</option>
<option value
="DIFF2">DIFF2</option>
<option value
="IMP2">IMP2</option>
<option value
="
MIDDLE">
MIDDLE</option>
<option value
="ETCH3">ETCH3</option>
<option value
="LITHO3">LITHO3</option>
<option value
="ETCH1">ETCH1</option>
<option value
="ETCH2">ETCH2</option>
<option value
="LITHO1">LITHO1</option>
<option value
="SCAN">SCAN</option>
<option value
="LITHO2">LITHO2</option>
<option value
="WFS(AL)">WFS(AL)</option>
<option value
="WFS(CU)">WFS(CU)</option>
<option value
="WAT">WAT</option>
<option value
="OQI">OQI</option>
<option value
="Transfer Team">Transfer Team</option>
<option value
="ALL">ALL</option>
</select>
</font>
</td>
<td> </td>
<td width
="10%"
align="
center"><font face
="Arial">Shift:</font></td>
<td width
="10%"
align="
center">
<font size
="2" face
="Arial">
<select name
="Shift">
<option value
=""></option>
<option value
="DA">DA</option>
<option value
="DB">DB</option>
<option value
="NA">NA</option>
<option value
="NB">NB</option>
<option value
="Nor">Nor</option>
</select>
</font>
</td>
<td> </td>
<td width
="10%"
align="
center"><font face
="Arial">报道日期:</font></td>
<td width
="6%"
align="
center">
<input name
="Onboard" type
="text" id
="Onboard" size
="15">
</td>
<td> </td>
<td width
="8%"
align="
center">
<input type
="submit" name
="btnEnter" value
="Query">
</td>
</tr>
</table>
</form>
<%
EmpNo
=trim(request("EmpNo"))
Section
=trim(request("Section"))
Shift
=trim(request("Shift"))
Onboard
=trim(request("Onboard"))
' response.write "Onboard
=" & Onboard & "<br>"
%>
<!--table-->
<div class
="t_i" style
="position:absolute;left:200px">
<div class
="t_i_h" id
="hh">
<div class
="ee">
<table cellpadding
="0" cellspacing
="0" border
="0">
<tr bgcolor
="#336666">
<td width
="7%"
align="
center" rowspan
="2"><font color
="#FFFFFF" size
="2" face
="Arial">Emp.NO</font></td>
<td width
="6.5%"
align="
center" rowspan
="2"><font color
="#FFFFFF" size
="2" face
="Arial">Name</font></td>
<td width
="6.5%"
align="
center" rowspan
="2"><font color
="#FFFFFF" size
="2" face
="Arial">Section</font></td>
<td width
="8%"
align="
center" rowspan
="2"><font color
="#FFFFFF" size
="2" face
="Arial">Report day</font></td>
<!-- <td width
="18%"
align="
center" colspan
="3"><font color
="#FFFFFF" size
="2" face
="Arial">新人训</font></td> -->
<td width
="18%"
align="
center" colspan
="3"><font color
="#FFFFFF" size
="2" face
="Arial">必修</font></td>
<!-- <td width
="18%"
align="
center" colspan
="3"><font color
="#FFFFFF" size
="2" face
="Arial">当前工作岗位</font></td>
<td width
="18%"
align="
center" colspan
="3"><font color
="#FFFFFF" size
="2" face
="Arial">跨岗位</font></td> -->
</tr>
<tr bgcolor
="#336666">
<td width
="6%"
align="
center"><font color
="#FFFFFF" size
="2" face
="Arial">应完成</font></td>
<td width
="6%"
align="
center"><font color
="#FFFFFF" size
="2" face
="Arial">实际完成</font></td>
<td width
="6%"
align="
center"><font color
="#FFFFFF" size
="2" face
="Arial">完成Ratio</font></td>
<!-- <td width
="6%"
align="
center"><font color
="#FFFFFF" size
="2" face
="Arial">应完成</font></td>
<td width
="6%"
align="
center"><font color
="#FFFFFF" size
="2" face
="Arial">实际完成</font></td>
<td width
="6%"
align="
center"><font color
="#FFFFFF" size
="2" face
="Arial">完成Ratio</font></td> -->
<!-- <td width
="6%"
align="
center"><font color
="#FFFFFF" size
="2" face
="Arial">应完成</font></td>
<td width
="6%"
align="
center"><font color
="#FFFFFF" size
="2" face
="Arial">实际完成</font></td>
<td width
="6%"
align="
center"><font color
="#FFFFFF" size
="2" face
="Arial">完成Ratio</font></td>
<td width
="6%"
align="
center"><font color
="#FFFFFF" size
="2" face
="Arial">应完成</font></td>
<td width
="6%"
align="
center"><font color
="#FFFFFF" size
="2" face
="Arial">实际完成</font></td>
<td width
="6%"
align="
center"><font color
="#FFFFFF" size
="2" face
="Arial">完成Ratio</font></td> -->
</tr>
</table>
</div>
</div>
<div class
="cc" id
="cc" onscroll
="aa()">
<table cellpadding
="0" cellspacing
="0" border
="0">
<%
if Section
= "" then
Condition1
= ""
elseif Section
= "CMP1" then
Condition1
= " AND sect
='CMP1' "
elseif Section
= "CVD1" then
Condition1
= " AND sect
='CVD1' "
elseif Section
= "PVD1" then
Condition1
= " AND sect
='PVD1' "
elseif Section
= "CMP2" then
Condition1
= " AND sect
='CMP2' "
elseif Section
= "CVD2" then
Condition1
= " AND sect
='CVD2' "
elseif Section
= "PVD2" then
Condition1
= " AND sect
='PVD2' "
elseif Section
= "4F" then
Condition1
= " AND sect
='4F' "
elseif Section
= "CMP3" then
Condition1
= " AND sect
='CMP3' "
elseif Section
= "TF3" then
Condition1
= " AND sect
='TF3' "
elseif Section
= "DIFF1" then
Condition1
= " AND sect
='DIFF1' "
elseif Section
= "IMP1" then
Condition1
= " AND sect
='IMP1' "
elseif Section
= "DIFF2" then
Condition1
= " AND sect
='DIFF2' "
elseif Section
= "IMP2" then
Condition1
= " AND sect
='IMP2' "
elseif Section
= "
MIDDLE" then
Condition1
= " AND sect
='
MIDDLE' "
elseif Section
= "ETCH3" then
Condition1
= " AND sect
='ETCH3' "
elseif Section
= "LITHO3" then
Condition1
= " AND sect
='LITHO3' "
elseif Section
= "ETCH1" then
Condition1
= " AND sect
='ETCH1' "
elseif Section
= "ETCH2" then
Condition1
= " AND sect
='ETCH2' "
elseif Section
= "LITHO1" then
Condition1
= " AND sect
='LITHO1' "
elseif Section
= "SCAN" then
Condition1
= " AND sect
='SCAN' "
elseif Section
= "LITHO2" then
Condition1
= " AND sect
='LITHO2' "
elseif Section
= "WFS(AL)" then
Condition1
= " AND sect
='WFS(AL)' "
elseif Section
= "WFS(CU)" then
Condition1
= " AND sect
='WFS(CU)' "
elseif Section
= "WAT" then
Condition1
= " AND sect
='WAT' "
elseif Section
= "OQI" then
Condition1
= " AND sect
='OQI' "
elseif Section
= "Transfer Team" then
Condition1
= " AND sect
='Transfer Team' "
elseif Section
= "TF1" then
Condition1
= " AND sect
='TF1' "
elseif Section
= "TF2" then
Condition1
= " AND sect
='TF2' "
end if
if EmpNo
="" then
Condition2
=""
else
Condition2
=" AND employee_no
='"&EmpNo&"' "
end if
if Shift
="" then
Condition3
=""
else
Condition3
=" AND Shift
='"&Shift&"' "
end if
if Onboard
="" then
Condition4
=""
else
Condition4
=" AND edittime LIKE '"&Onboard&"%' "
end if
' response.write"Condition1
="&Condition1&"<br>"
n
=0
sql
= " SELECT employee_no, name, sect, substr(edittime, 1, 4) || '-' || substr(edittime, 5, 2) || '-' || substr(edittime, 7, 2) AS edittime, safe_ttl, safe_completed, DECODE(safe_ttl, 0, 0, ROUND(safe_completed / safe_ttl * 100, 0)) AS saferatio FROM( SELECT employee_no, name, sect, edittime, COUNT(CASE WHEN group_name
= 'Safe' THEN course_id END) AS safe_ttl, COUNT(CASE WHEN group_name
= 'Safe' AND wr_certify
= 1 THEN course_id END) AS safe_completed FROM MFG_TB_TRAINING_USER A JOIN mfg_tb_newtraining_final_result B ON A.employee_no
= B.empno WHERE status
= 'A' AND employee_no LIKE 'E068772' GROUP BY employee_no, name, sect, edittime) ORDER BY employee_no "
'response.write"Condition1
="&sql&"<br>"
set rs
=conn.execute(sql)
while not rs.eof
if not rs.eof then
EMPLOYEE_NO
=rs("employee_no")
NAME
=rs("name")
SECT
=rs("sect")
EDITTIME
=rs("edittime")
BASICTTL
=rs("SAFE_TTL")
BASIC
=rs("SAFE_COMPLETED")
BASICRATIO
=rs("SAFERATIO")
n
=n+1
%>
<tr bgcolor
="#FFFFFF">
<td width
="7%"
align="
center"><font color
="#4091c4" size
="2" face
="Arial"><%
=EMPLOYEE_NO%></font></td>
<td width
="6.5%"
align="
center"><font color
="#4091c4" size
="2" face
="Arial"><%
=NAME%></font></td>
<td width
="6.5%"
align="
center"><font color
="#4091c4" size
="2" face
="Arial"><%
=SECT%></font></td>
<td width
="8%"
align="
center"><font color
="#4091c4" size
="2" face
="Arial"><%
=EDITTIME%></font></td>
<td width
="6%"
align="
center"><a href
="reportdata.asp?EMPLOYEE_NO
=<%
=EMPLOYEE_NO%>&GROUP_NAME
=Basic&CERTIFYGROUP_TYPE
=NULL"><font color
="#4091c4" size
="2" face
="Arial"><%
=BASICTTL%></font></td>
<td width
="6%"
align="
center"><font color
="#4091c4" size
="2" face
="Arial"><%
=BASIC%></font></td>
<td width
="6%"
align="
center"><font color
="#4091c4" size
="2" face
="Arial"><%
=BASICRATIO%>%</font></td>
</tr>
<%
end if
rs.MoveNext
wend
if n<>"0" then
if CDbl(round(ratioList/n,2))>0 and CDbl(round(ratioList/n,2))<1 then
i
="0" & round(ratioList/n,2) & "%"
else
i
=round(ratioList/n,2) & "%"
end if
if CDbl(round(ratioList1/n,2))>0 and CDbl(round(ratioList1/n,2))<1 then
j
="0" & round(ratioList1/n,2) & "%"
else
j
=round(ratioList1/n,2) & "%"
end if
else
i
=0
j
=0
end if
%>
</table>
</div>
<table cellpadding
="0" cellspacing
="0" border
="0">
<tr bgcolor
="#FFFFFF">
<td colspan
="16"
align="left" width
="1520" >
</td>
</tr>
<tr bgcolor
="#FFFFFF">
<td colspan
="16"
align="left">
<font size
="3" face
="Arial" color
="#0000FF"><b> 当前显示记录:</b></font>
<font face
="Arial" size
="3" color
="red">
<b><%
=n%></b>
</font>
<font size
="3" face
="Arial" color
="#0000FF"><b>; 当前工作岗位Ratio:</b></font>
<font face
="Arial" size
="3" color
="red">
<b><%
=i%></b>
</font>
<font size
="3" face
="Arial" color
="#0000FF"><b>; 跨岗位Ratio:</b></font>
<font face
="Arial" size
="3" color
="red">
<b><%
=j%></b>
</font>
</td>
</tr>
</table>
<table border
="0" width
="100%">
<td> </td>
<tr>
<td width
="100%"
align="
center">
<a href
="setup.asp">--返 回--</a>
</td>
</tr>
<tr>
<td width
="100%"
align="
center" class
='banquan'>
<font color
="#666666">©Copyright Semiconductor Manufacturing International (Shanghai) Corp. <font color
="#018ec6">2025 版权所有 ™</font> v1.0</font>
</td>
</tr>
</table>
</div>
</table>
<script>
!function(){
laydate.skin('dahong');//切换皮肤，请查看skins下面皮肤库
laydate({elem: '#demo'});//绑定元素
}();
//日期范围限制
var start
= {
elem: '#start',
format: 'YYYY-MM-DD',
festival: true, //显示节日
max: '2099-06-16', //最大日期
istime: true,
istoday: true,
choose: function(datas){
end.min
= datas; //开始日选好后，重置结束日的最小日期
end.start
= datas //将结束日的初始值设定为开始日
}
};
var end
= {
elem: '#end',
format: 'YYYY-MM-DD',
festival: true, //显示节日
max: '2099-06-16',
istime: true,
istoday: true,
choose: function(datas){
start.max
= datas; //结束日选好后，充值开始日的最大日期
}
};
laydate(start);
laydate(end);
</script>
</body>
</html> 是这个 代码 你不要改变原有的代码功能
本文详细介绍了HTML表格中元素的垂直（上下）和水平（左右）对齐方式，包括如何使用valign属性进行垂直对齐，如top、middle、bottom，以及如何使用align属性进行水平对齐，如LEFT、CENTER、RIGHT。
扫一扫
1702
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
