| Server IP : 134.236.49.22 / Your IP : 216.73.216.114 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/reportservice/2/helpdesk/ |
Upload File : |
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>IT Dep.</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="default.css" rel="stylesheet" type="text/css" />
<meta http-equiv="refresh" content="180;URL=index.php">
<META HTTP-EQUIV="Refresh" CONTENT="60;URL=index.php">
<SCRIPT LANGUAGE='JAVASCRIPT' TYPE='TEXT/JAVASCRIPT'>
<!--
var win=null;
function NewWindow(mypage,myname,w,h,pos,infocus){
if(pos=="random"){myleft=(screen.width)?Math.floor(Math.random()*(screen.width-w)):100;mytop=(screen.height)?Math.floor(Math.random()*((screen.height-h)-75)):100;}
if(pos=="center"){myleft=(screen.width)?(screen.width-w)/2:100;mytop=(screen.height)?(screen.height-h)/2:100;}
else if((pos!='center' && pos!="random") || pos==null){myleft=0;mytop=20}
settings="width=" + w + ",height=" + h + ",top=" + mytop + ",left=" + myleft + ",scrollbars=no,location=no,directories=no,status=no,menubar=no,toolbar=no,resizable=no";win=window.open(mypage,myname,settings);
win.focus();}
// -->
</script>
</head>
<body>
<!-- start header -->
<div id="header">
<div align="right">
<? include "menu.php"; ?>
</div>
<h1><a href="#">helpdesk<span></span></a></h1>
</div>
<div align="right"><a href="add_job.php"><img src="images/img06.jpg" width="24" height="15">New Job</a>
</div>
<div>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" bgcolor="#FFFFFF">
<tr>
<td width="613" height="19" bgcolor="#FFFFFF">
<?
include"connect.php";
$objDB = mysql_select_db("$dbname");
$strSQL="select * from job";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$Num_Rows = mysql_num_rows($objQuery);
$Per_Page =10; // Per Page
$Page = $_GET["Page"];
if(!$_GET["Page"])
{
$Page=1;
}
$Prev_Page = $Page-1;
$Next_Page = $Page+1;
$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{
$Num_Pages =1;
}
else if(($Num_Rows % $Per_Page)==0)
{
$Num_Pages =($Num_Rows/$Per_Page) ;
}
else
{
$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;
}
$strSQL .=" order by job_id desc LIMIT $Page_Start , $Per_Page";
$objQuery = mysql_query($strSQL);
if(empty($Num_Rows)) /* ?????????????????????? */
{
echo"<center></center>";
exit();
}
else
{
?></td>
<td width="615"><div align="right"></div></td>
</tr>
<tr>
<td colspan="2"><table width="100%" border="1" cellpadding="0" cellspacing="0" bgcolor="#999999">
<tr>
<td width="10%"><div align="center">Job.ID</div></td>
<td width="40%"><div align="center">Job.Detail</div></td>
<td width="10%"><div align="center">UserName</div></td>
<td width="10%"><div align="center">Department</div></td>
<td width="10%"><div align="center">Tel</div></td>
<td width="10%"><div align="center">Job_Date</div></td>
<td width="10%"><div align="center">Job_status</div></td>
</tr>
</table>
<?
while($objResult = mysql_fetch_array($objQuery))
{
$job_date = $objResult["job_date"];
$y=substr($job_date,2,2);
$m=substr($job_date,5,2);
$d=substr($job_date,8,2);
$job_id = $objResult["job_id"];
$code=sprintf("$y$m%05d",$job_id);
$job_detail = $objResult["job_detail"];
?>
<table width="100%"style="border-bottom:1px dotted #000000;" cellpadding="0" cellspacing="0">
<tr onMouseOver="this.style.backgroundColor='cccccc';" onMouseOut="this.style.backgroundColor='ffffff';">
<td width="10%"><div align="center"><?=$code;?></div></td>
<?
echo substr("<td><a href=\"javascript:NewWindow('view.php?id_edit=$job_id','acepopup','680','480','center','front');\">$job_detail",0,200)."...</a></td>";
?>
<td width="10%"><div align="center"><?=$objResult["job_fname"];?></div></td>
<td width="10%">
<?
$dep_id = $objResult["ref_dep_id"];
?>
<?
$strSQL3 ="SELECT*FROM dep where dep_id='$dep_id' ";
$objQuery3 = mysql_query($strSQL3);
$Num_Rows3 = mysql_num_rows($objQuery3);
while($objResult3 = mysql_fetch_array($objQuery3))
{
?>
<div align="center"><?=$objResult3["dep_name"];?></div></td>
<?
}
?>
<td width="10%"><div align="center"><?=$objResult["job_tel"];?></div><div align="center"></div></td>
<td width="10%"><div align="center"><?=$objResult["job_date"];?></div><div align="center"></div></td>
<td width="10%"><div align="center"><?=$objResult["job_status"];?></div><div align="center"></div></td>
</tr>
</table>
<?
}
?></td></tr>
<tr>
<td height="55" colspan="2"><div align="center"><span class="style11"><hr>
</span> <br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center"><span class="style11">Total </span>
<?= $Num_Rows;?>
<span class="style11"> Record : </span>
<?=$Num_Pages;?>
<span class="style11">Page :</span>
<?
if($Prev_Page)
{
echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page&startdate=$startdate&enddate=$enddate'></a> ";
}
for($i=1; $i<=$Num_Pages; $i++){
if($i != $Page)
{
echo "[<a href='$_SERVER[SCRIPT_NAME]?Page=$i&startdate=$startdate&enddate=$enddate'>$i</a>]";
}
else
{
echo "<b> $i </b>";
}
//}
if($Page!=$Num_Pages)
{
echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page&startdate=$startdate&enddate=$enddate'></a> ";
}
?>
<?
}
}
mysql_close();
?>
</div></td>
</tr>
</table>
<br>
</div></td>
</tr>
</table>
</div>
<div id="footer">
<p id="legal">©2009 All Rights Reserved. <a href="http://www.itsiam.net/">Thaphat Chutiwatphokin</a></p>
<p id="links"> </p>
</div>
</body>
</html>