 |
|
<?php
include("chk_user_login_pass.php");
include("dbconnect.php");
class DB{
function query($query){
$QID = mysql_query($query);
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");
mysql_query("collation_connection = utf8_unicode_fi");
mysql_query("collation_database = utf8_unicode_fi");
mysql_query("collation_server = utf8_unicode_fi");
if(!$QID){
echo "<br><br><b><font face='MS Sans Serif' size='1' color='#000099'>Query : \"$query\" </font><br>
<font face='MS Sans Serif' size='1' color='#FF0000'>Error : \"".mysql_error()."\"</font></b>
<br>";
exit;
return $QID;
}else{
return $QID;
}
}
}
$db = new DB;
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<style type="text/css">
<!--
.style1 {
font-size: 16px
}
.style2 {font-size: 14px; }
.style10 {font-size: 12px; font-weight: bold; font-family: "MS Sans Serif", Tahoma, sans-serif; }
.style11 {font-size: 16px; font-weight: bold; }
.style13 {font-size: 18px}
-->
</style>
</head>
<body>
<form name="form1" method="post" action="index.php?case_i=1" method="get" target="_blank">
<?
$department = $_GET['department'];
$status = $_GET['status'];
$condition = " where member.department_id = $department and jobhelpdesk.status = $status ";
if (empty($offset) || $offset < 0) {
$offset=0;
}
if(!$limit){
$limit = 20;
}
$sql = "
SELECT
jobhelpdesk.job_id,
jobhelpdesk.mem_id,
jobhelpdesk.type_id,
jobhelpdesk.work_id,
jobhelpdesk.job_number,
jobhelpdesk.job_detail,
jobhelpdesk.job_date,
jobhelpdesk.job_time,
jobhelpdesk.job_update,
jobhelpdesk.job_uptime,
jobhelpdesk.status_id,
jobhelpdesk.job_ans,
jobhelpdesk.ansn_id,
jobhelpdesk.job_remark,
member.mem_id,
member.fname,
member.lname,
member.email,
member.department_id,
member.groups,
member.rooms,
member.phone,
member.mobile,
`type`.type_id,
`type`.type_name,
work.work_id,
work.work_name,
`status`.status_id,
`status`.status_name,
support_mem.ansn_id,
support_mem.s_fname,
support_mem.s_lname,
support_mem.s_email,
support_mem.s_typeid,
support_mem.s_phone,
support_mem.s_mobile,
s_type.s_typeid,
s_type.s_typename,
department.department_id,
department.department_name
FROM
jobhelpdesk
INNER JOIN member ON (jobhelpdesk.mem_id = member.mem_id)
INNER JOIN `type` ON (jobhelpdesk.type_id = `type`.type_id)
INNER JOIN work ON (jobhelpdesk.work_id = work.work_id)
INNER JOIN `status` ON (jobhelpdesk.status_id = `status`.status_id)
INNER JOIN support_mem ON (jobhelpdesk.ansn_id = support_mem.ansn_id)
INNER JOIN s_type ON (support_mem.s_typeid = s_type.s_typeid)
INNER JOIN department ON (member.department_id = department.department_id)
$condition ";
$query_data = $db->query($sql);
$rows = mysql_num_rows($query_data);
$begin =($offset+1);
$end = ($begin+($limit-1));
if ($end > $totalrows) {
$end = $totalrows;
}
$Show = $sql." ORDER BY job_date desc LIMIT $offset, $limit";
$query_data = $db->query($Show);
?>
<table width="100%" border="0" align="center" cellpadding="1" cellspacing="1">
<tr bgcolor="#CCFFCC">
<td colspan="8"><div align="center" class="style11">การแจ้งซ่อม
<?= $rows;?> งาน</div>
<div align="center" class="style1 style2"></div></td>
</tr>
<tr bgcolor="#FFFFCC">
<td width="5%"> <div align="center" class="style10">ลำดับ</div></td>
<td width="32%" align="center"><span class="style10">รายละเอียดปัญหา</span></td>
<td width="11%" align="center"><span class="style10">ชื่อผู้แจ้ง</span></td>
<td width="19%" align="center"><span class="style10">หน่วยงานหลัก</span></td>
<td width="10%" align="center"><span class="style10">ชื่อช่างรับแจ้ง</span></td>
<td width="10%" align="center"><span class="style10">วันที่แจ้ง</span></td>
<td width="9%" align="center"><span class="style10">สถานะงาน</span></td>
<td width="4%" align="center"><span class="style10">ดูประวัติ</span></td>
</tr>
<?
if($rows<>0){
$i=1;
while($result_data = mysql_fetch_array($query_data)){
$check=$db->query("
SELECT
jobhelpdesk.job_id,
jobhelpdesk.mem_id,
jobhelpdesk.type_id,
jobhelpdesk.work_id,
jobhelpdesk.job_number,
jobhelpdesk.job_detail,
jobhelpdesk.job_date,
jobhelpdesk.job_time,
jobhelpdesk.job_update,
jobhelpdesk.job_uptime,
jobhelpdesk.status_id,
jobhelpdesk.job_ans,
jobhelpdesk.ansn_id,
jobhelpdesk.job_remark,
member.mem_id,
member.fname,
member.lname,
member.email,
member.department_id,
member.groups,
member.rooms,
member.phone,
member.mobile,
`type`.type_id,
`type`.type_name,
work.work_id,
work.work_name,
`status`.status_id,
`status`.status_name,
support_mem.ansn_id,
support_mem.s_fname,
support_mem.s_lname,
support_mem.s_email,
support_mem.s_typeid,
support_mem.s_phone,
support_mem.s_mobile,
s_type.s_typeid,
s_type.s_typename,
department.department_id,
department.department_name
FROM
jobhelpdesk
INNER JOIN member ON (jobhelpdesk.mem_id = member.mem_id)
INNER JOIN `type` ON (jobhelpdesk.type_id = `type`.type_id)
INNER JOIN work ON (jobhelpdesk.work_id = work.work_id)
INNER JOIN `status` ON (jobhelpdesk.status_id = `status`.status_id)
INNER JOIN support_mem ON (jobhelpdesk.ansn_id = support_mem.ansn_id)
INNER JOIN s_type ON (support_mem.s_typeid = s_type.s_typeid)
INNER JOIN department ON (member.department_id = department.department_id)
$condition ");
$cli=$i%2;
if($cli=="0") {$cli="#AAD2FF" ; } else { $cli="#FFFFFF" ; }
?>
<tr bgcolor="<?php echo "$cli"; ?>" >
<td align="center"> <font size="2" face="MS Sans Serif, Tahoma, sans-serif">
<?=($offset + $i);?>
.</font></td>
<td height="21" ><div align="left"><font size="2" face="MS Sans Serif, Tahoma, sans-serif"><? print $result_data[job_detail];?></font></div></td>
<td><div align="center"><font size="2" face="MS Sans Serif, Tahoma, sans-serif"><? print $result_data[fname];?></font></div></td>
<td><div align="center"><font size="2" face="MS Sans Serif, Tahoma, sans-serif"><? print $result_data[type_name];?></font></div></td>
<td><div align="center"><font size="2" face="MS Sans Serif, Tahoma, sans-serif"><? print $result_data[s_fname];?></font></div></td>
<td><div align="center"><font size="2" face="MS Sans Serif, Tahoma, sans-serif"><? print $result_data[job_date];?></font></div></td>
<td><div align="center"><font size="2" face="MS Sans Serif, Tahoma, sans-serif"><? print $result_data[status_name];?></font></div></td>
<td><div align="center"><a href="view.php?job_id=<?php echo $job_id = $result_data['job_id']; ?>" class="style13">ดู</a></div></td>
</tr>
<?
$i++;
}
}else{
?>
<tr bgcolor="#FFFFFF">
<td colspan="8"><div align="center" class="style2"><strong><font color="#FF0000">ไม่พบข้อมูล</font></strong></div></td>
</tr>
<?
}
?>
</table>
<br><br>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#6699CC"><div align="right"> </div></td>
</tr>
</table>
<? if($rows > 0){ ?>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td><strong>หน้าที่</strong> <?php
if ($offset !=0) {
$prevoffset=$offset-$limit;
echo "<a href='index.php?case_i=1&offset=$prevoffset&txt_search=$txt_search'>
<font color=\"red\"><< ก่อนหน้า</font></a>\n\n";
}
$pages = intval($rows/$limit);
if ($rows%$limit) {
$pages++;
}
for ($i=1;$i<=$pages;$i++) {
if (($offset/$limit) == ($i-1)) {
echo "$i ";
} else {
$newoffset=$limit * ($i-1);
echo "<a href='index.php?case_i=1&offset=$newoffset&txt_search=$txt_search' >
<font color=\"black\">$i</font></a>\n\n";
}
}
if (!((($offset/$limit)+1)==$pages) && $pages!=1) {
$newoffset=$offset+$limit;
echo "<a href='index.php?case_i=1&offset=$newoffset&txt_search=$txt_search'>
<font color=\"red\">ถัดไป>></font></a>\n";
}
?></td>
</tr>
</table>
<?
}
?>
</form>
<?php
mysql_close($connect_db);
?>
<?php //print $sql?>
</body>
</html>
มันerror ง่ะคับ
|
 |
 |
 |
 |
| Date :
2010-05-12 15:24:46 |
By :
pungman99 |
|
 |
 |
 |
 |
|
|
 |
