?? maintenance.php
字號:
<?php
include('../admin_global.php');
$query=$db->query("SELECT * FROM device,device_brand,device_type,units,sector,device_tomaintenance 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 and device_state='維修' and device_tomaintenance.device_id=device.device_id and device_tomaintenance.isnew=1 ");
$total=$db->num_rows($query);
pageft($total,$page_num);
if ($total>0)
{
$query=$db->query("SELECT * FROM device,device_brand,device_type,units,sector,device_tomaintenance 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 and device_state='維修' and device_tomaintenance.device_id=device.device_id and device_tomaintenance.isnew=1 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('maintenance_setting.php?id=<?php echo $rs['device_id'] ?>&tomaintenanceId=<?php echo $rs['tomaintenance_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 + -