|
 |
| |
รบกวนพี่ๆ ช่วยทีครับ เรื่องการแบ่งหน้า ของแผนการดำเนินงาน |
| |
 |
|
|
 |
 |
|
|
 |
 |
 |
 |
| Date :
2012-07-24 14:50:21 |
By :
เอกชัย |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
Code (PHP)
<?
session_start();
if(!isset($_SESSION['StaffID'])){
//session_destroy();
echo '<script>alert("Please Enter Code!");</script>';
echo '<meta http-equiv= "refresh" content="0; url=LoginPage.php"/>';
exit();
}
include($path_cla."connect.php");
include_once("libaries/default.php");
include_once($path_cla."globals.php");
$monthnum = array("มกราคม"=>1,"กุมภาพันธ์"=>2,"มีนาคม"=>3,"เมษายน"=>4,"พฤษภาคม"=>5,"มิถุนายน"=>6,"กรกฏาคม"=>7,"สิงหาคม"=>8,"กันยายน"=>9,"ตุลาคม"=>10,"พฤศจิกายน"=>11,"ธันวาคม"=>12);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>ทดสอบการใช้งานระบบ</title>
<!--
<link rel="stylesheet" href="./javascript/jquery.mobile-1.1.0/jquery.mobile-1.1.0.min.css" />
<script src="http://code.jquery.com/jquery-1.7.1.min.js"></script>
<script src="./javascript/jquery.mobile-1.1.0/jquery.mobile-1.1.0.min.js"></script>
-->
<link rel="stylesheet" href="http://code.jquery.com/mobile/1.1.0/jquery.mobile-1.1.0.min.css" />
<script src="http://code.jquery.com/jquery-1.7.1.min.js"></script>
<script src="http://code.jquery.com/mobile/1.1.0/jquery.mobile-1.1.0.min.js"></script>
<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0, minimum-scale=1.0, maximum-scale=1.0">
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="apple-mobile-web-app-status-bar-style" content="black-translucent">
<link rel="apple-touch-icon" href="images/touch-icon-iphone.png">
<link rel="apple-touch-icon" sizes="72x72" href="images/touch-icon-ipad.png">
<link rel="apple-touch-icon" sizes="114x114" href="images/touch-icon-iphone4.png">
<style type='text/css' media="all">@import url("sources/add2home.css");</style>
<script type="text/javascript">var addToHomeConfig={animationIn:'bubble',animationOut:'drop',lifespan:10000,expire:2,touchIcon:true,message:'Install <strong>PJ</strong> on your %device: tap %icon and then <strong>Add to Home Screen</strong>.'};</script>
<script type="application/javascript" src="javascript/add2home.js"></script>
<style type="text/css">
body,td,th {
font-size: 14px;
}
</style>
</head>
<body>
<table width="999" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="999"><table width="999" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="999" colspan="12" align="center"><table width="999" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="999" align="center" ><a href="index.php" data-role="button" data-inline="true">ตารางแสดงผลการดำเนินงานโครงการ</a></td>
</tr>
<tr>
<td><table width="1000" border="1" cellpadding="1" cellspacing="0" bordercolor="#999999">
<tr>
<td height="12" colspan="12" align="center" bgcolor="#FFFF99">2012</td>
</tr>
<tr id="12">
<td width="76" height="23" align="center" bgcolor="#FFFF99">มกราคม</td>
<td width="76" height="23" align="center" bgcolor="#FFFF99">กุมภาพันธ์</td>
<td width="76" height="23" align="center" bgcolor="#FFFF99">มีนาคม</td>
<td width="76" height="23" align="center" bgcolor="#FFFF99">เมษายน</td>
<td width="76" height="23" align="center" bgcolor="#FFFF99">พฤษภาคม</td>
<td width="76" height="23" align="center" bgcolor="#FFFF99">มิถุนายน</td>
<td width="76" height="23" align="center" bgcolor="#FFFF99">กรกฎาคม</td>
<td width="76" height="23" align="center" bgcolor="#FFFF99">สิงหาคม</td>
<td width="76" height="23" align="center" bgcolor="#FFFF99">กันยายน</td>
<td width="76" height="23" align="center" bgcolor="#FFFF99">ตุลาคม</td>
<td width="76" height="23" align="center" bgcolor="#FFFF99">พฤศจิกายน</td>
<td width="76" height="23" align="center" bgcolor="#FFFF99">ธันวาคม</td>
</tr>
<?php
mysql_query("SET NAMES UTF8");
$strSQL = "select * from stproject group by ProjectID order by PRID,ProjectID ASC";
$objQuery = mysql_query($strSQL);
while($objResult = mysql_fetch_array($objQuery)){
$b=0;
echo "<tr>";
$ProjectID = $objResult["ProjectID"];
//echo $GroupPRID;
$strSQL2 = "select * from stproject,projectname where stproject.ProjectID = projectname.ProjectID and stproject.ProjectID='$ProjectID' order by stproject.PRID";
$objQuery2 = mysql_query($strSQL2);
while($objResult2 = mysql_fetch_array($objQuery2)){
$b++;
$ProjectID2 = $objResult2["ProjectID"];
$PRStart = $objResult["PRPeriod"];
$numMonth = 0;
$numMonth = $monthnum[$objResult2["PRStart"]]-1;
//echo $GroupPRID2;
//echo $numMonth;
if($b==1)
{
if($numMonth != 0){
?>
<td align="center" colspan="<? echo $numMonth?>" style="background-color:#FFF" > </td>
<?
}
?>
<td colspan="<? echo $objResult2["PRPeriod"]?>" align="left" valign="top" style="background-color:#8C8468; color: #FFF;" onclick="window.open('DetailPage.php?PRID=<?=$objResult2['PRID'];?>','_parent')" >
<div style="background-color:#40D5D6; width:<? echo $objResult2["PRSuccess"]?>%; float:left; font-size: 13px; display: block; height:50px;"><a href="DetailPage.php?PRID=<?=$objResult2['PRID'];?>" data-role="button" data-inline="true"><? echo $objResult2["PRSuccess"]?> %</a><div style="position:relative; top:-33px; left:85px; color:#000;font-size:16px;"><? echo $objResult2["ProjectName"]?></div></div>
</td>
<?
}else { ?>
<td colspan="<? echo $objResult2["PRPeriod"]?>" align="left" valign="top" style="background-color:#8C8468; color: #FFF;" onclick="window.open('DetailPage.php?PRID=<?=$objResult2['PRID'];?>','_parent')" >
<div style="background-color:#40D5D6; width:<? echo $objResult2["PRSuccess"]?>%; float:left; font-size: 13px; display: block; height:50px;"><a href="DetailPage.php?PRID=<?=$objResult2['PRID'];?>" data-role="button" data-inline="true"><? echo $objResult2["PRSuccess"]?> %</a></div>
</td>
<?
}
}
?>
<?
echo "</tr>";
}
?>
</table></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td align="center" ></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<blockquote> </blockquote>
</body>
</html>
|
| |
|
|
| |
| Date :
2012-07-24 17:28:15 |
By :
เอกชัย |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 05
|
