📄 allmaintenance.php
字号:
<?php
include('../admin_global.php');
$query=$db->query("SELECT * FROM device,device_brand,device_type,units,sector where device.device_brand=device_brand.brand_id and device.device_type=device_type.type_id and device.device_units=units.units_id and device.device_sector=sector.sector_id");
$total=$db->num_rows($query);
pageft($total,$page_num);
if ($total>0)
{
$query=$db->query("SELECT * FROM device,device_brand,device_type,units,sector where device.device_brand=device_brand.brand_id and device.device_type=device_type.type_id and device.device_units=units.units_id and device.device_sector=sector.sector_id limit $firstcount,$displaypg ");
while($row=$db->fetch_array($query)) {
$rsdb[]=$row;
}
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<link rel="stylesheet" type="text/css" href="../css/table.css">
<script language="javascript" type="text/javascript">
</script>
<script src="../js/admin.js"></script>
</head>
<body >
<table width="300" height="22" border="0" cellpadding="0" cellspacing="0" align="center"
style="margin-top:25px; color:#000000; font-size:12px" bgcolor="#ffffff">
<!--DWLayoutTable-->
<tr>
<td align="center" valign="middle" ><strong>维修详细情况</strong> </td>
</tr>
</table>
<div id="data">
<form name="frmOrder" action="online_services_jod.php?action=paixu" method="post">
<table border="0" cellpadding="0" cellspacing="0" align="center" bgcolor="#FFFFFF">
<!--DWLayoutTable-->
<tr>
<td width="31" height="29" align="center" valign="middle" bgcolor="e9e9e9">
行号</td>
<td width="100" align="center" valign="middle" bgcolor="e9e9e9"><strong>设备名称</strong></td>
<td width="100" align="center" valign="middle" bgcolor="e9e9e9"><strong>品牌</strong></td>
<td width="100" align="center" valign="middle" bgcolor="e9e9e9"><strong>类型</strong></td>
<td width="100" align="center" valign="middle" bgcolor="e9e9e9"><strong>型号</strong></td>
<td width="100" align="center" valign="middle" bgcolor="e9e9e9"><strong>购买时间</strong></td>
<td width="100" align="center" valign="middle" bgcolor="e9e9e9"><strong>单位</strong></td>
<td width="100" align="center" valign="middle" bgcolor="e9e9e9"><strong>部门</strong></td>
<td width="50" align="center" valign="middle" bgcolor="e9e9e9"><strong>状态</strong></td>
<td align="center" valign="middle" bgcolor="e9e9e9" ><strong>操作</strong></td>
</tr>
<?php
if ($total>0)
{
foreach($rsdb as $rs) {
?>
<tr>
<td height="29" align="center" valign="middle">
<?=$rs[device_id]?>
</td>
<td align="center" valign="middle">
<?php echo $rs['device_name'] ?>
</td>
<td align="center" valign="middle">
<?php echo $rs['brand_name'] ?>
</td>
<td align="center" valign="middle">
<?php echo $rs['type_name'] ?>
</td>
<td align="center" valign="middle">
<?php echo $rs['device_Specification'] ?>
</td>
<td align="center" valign="middle">
<?php echo $rs['device_orderdate'] ?>
</td>
<td align="center" valign="middle">
<?php echo $rs['units_name'] ?>
</td>
<td align="center" valign="middle">
<?php echo $rs['sector_name'] ?>
</td>
<td align="center" valign="middle">
<?php echo $rs['device_state'] ?>
</td>
<td width="45" align="center" valign="middle" >
<a onClick="navigation('viewmaintenance.php?id=<?php echo $rs['device_id'] ?>')" style="color:#000000;cursor:hand; ">查看</a>
</td>
<?php
}
}
?>
</table>
</form>
</div>
<table width="470" height="22" border="0" cellpadding="0" cellspacing="0" align="center"
style="margin-top:12px" >
<!--DWLayoutTable-->
<tr>
<td width="35" height="21" ></td>
<td width="82" align="center" valign="middle" ></td>
<td width="12" valign="top" ></td>
<td width="82" align="center" valign="middle"
></td>
<td width="12" valign="top" ></td>
<td width="82" align="center" valign="middle"
></td>
<td width="150" > </td>
</tr>
</table>
<table width="400" height="25" border="0" cellpadding="0" cellspacing="0" align="center"
style="margin-top:12px; color:#FFFFFF; font-size:12px" bgcolor="#000000">
<!--DWLayoutTable-->
<tr>
<td align="center" valign="middle" >
<?php echo $pagenav ?> </td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -