File: /var/www/workweb/taoyuan/index.php
<?php
include "name1.php" ; //通用命名
include "mysqllink.php" ;//資料庫引入檔
$mday = date("w") ; // 今日是星期幾
// 找出本周一的日期
if ($mday > 0){
$fw = $mday-1 ;
$weekstart = date ("Y-m-d",strtotime("- $fw days")) ;
}else {
$weekstart = date ("Y-m-d",strtotime("- 6 days")) ;
}
if ($begdate == "/"){
$begdate = $weekstart ;
$truedate = strtotime($begdate);
}
/*else if ($begdate ==){
$begdate = $weekstart ;
$truedate = strtotime($begdate);
}
*/
else if ($begdate) {
$truedate = strtotime($begdate);
$nmday = date("w",$truedate) ;
if ($nmday > 0){
$fw = $nmday-1 ;
$begdate = date("Y-m-d",strtotime("- $fw days",$truedate)) ;
$truedate = strtotime($begdate);
}else {
$begdate = date ("Y-m-d",strtotime("- 6 days",$truedate)) ;
$truedate = strtotime($begdate);
}
}
//$begday = date ("n-j",strtotime("+ 0 days",$truedate));
$weekend = date("Y-m-d",strtotime("+ 6 days ",$truedate)) ;
$nextweek = date ("Y-m-d",strtotime("+ 7 days ",$truedate)) ; //下周一
$thisweek = date ("Y-m-d");
$prevweek = date ("Y-m-d",strtotime("- 7 days ",$truedate)) ; //前一周
$linknext = basename(__file__)."?begdate=$nextweek" ;
$linktoday =basename(__file__)."?begdate=$thisweek";
$linkprev =basename(__file__)."?begdate=$prevweek" ;
//連結資料庫,並調出資料
$fblink = "select * from $tbname WHERE pDate >= '$begdate' and pDate <= '$weekend'" ;
$freslut = $dblink->query($fblink ) ;
$tblink = "select * from $cbname WHERE pDate >= '$begdate' and pDate <= '$weekend'" ;
$reslut = $dblink->query($tblink ) ;
if ($freslut) {
while ($nb = mysqli_fetch_array ($freslut)){
$md = $nb["pMday"] ;
$food[$md]["text"]= $nb["ptext"];
$food[$md]["food"]= $nb["pFood"];
$food[$md]["day"]= $nb["pDay"];
$food[$md]["menu"]= $nb["pMenu"];
$food[$md]["fruit"]= $nb["pFruit"];
$food[$md]["ps"]= $nb["pPs"];
$food[$md]["ps2"]= $nb["pPs2"];
$food[$md]["ps3"]= $nb["pPs3"];
$food[$md]["ps4"]= $nb["pPs4"];
$food[$md]["ps5"]= $nb["pPs5"];
$food[$md]["ps6"]= $nb["pPs6"];
$food[$md]["ps7"]= $nb["pPs7"];
}
}
if ($reslut) {
while ($nb = mysqli_fetch_array ($reslut)){
$md = $nb["pCarb"] ;
$food[$md]["car"]= $nb["pCar"];
$food[$md]["cara"]= $nb["pCara"];
}
}
?>
<html>
<title><?php echo $title ?>排工版</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
<!--
tr:hover td:first-child,
td:hover {
background-color: rgba(79, 192, 210, 0.7);
color: black;
font-weight: bolder;
transition: all 0.3s ease-in-out;
}
.flex {
font-size: 12pt;
color: #CCFFFF;
background-color: #9999FF;
text-align: center;
}
.day {
font-size: 10pt;
color: #FFFFFF;
background-color: #000000;
text-align: center;
}
td {font-size: 10pt; text-align: left }
.mycaption { font-size: 25pt; color: #FF3333}
.title { font-size: 15pt;}
body,td,th {
font-size: 10pt;
}
thead {
background-color: #f2f2f2; /* 表頭的背景色 */
position: sticky;
top: 0; /* 固定在視窗頂部 */
z-index: 1000; /* 提高層級，以確保在其他元素上面 */
}
-->
</style>
<body bgcolor="#ffffff">
<p align="center" class="title">
<a href="<?php echo $linkprev ?>"><上一周</a>
<span class="mycaption">
亞訊<?php echo $title ;?>排工版
</span>
<a href="<?php echo $linknext ?>">下一周></a>
</p>
<p align="center" class="title">
<?php if ($weekstart==$begdate) echo "本周";?>
<?php echo $begdate ." ~ ~ ~ ". $weekend ?>
<a href = "<?php echo $edit."?begdate=$begdate" ;?>"> [管理]</a>
<a href = "<?php echo $linktoday ;?>"><?php if ($weekstart!=$begdate) echo "[今天]" ?></a>
</p>
<table border="1" cellspacing="0" cellpadding="4" bordercolorlight="#3333FF" bordercolordark="#FFFFFF" align="center" width="100%">
<thead>
<tr class="flex">
<th class="flex">日期</th>
<?php
for ($i=0;$i<$weekdays; $i++) {
echo "<th class=flex>".$begday = date ("m-d",strtotime("+ $i days",$truedate))."星期". $weekdate[$i]. "</th>" ;
}
?>
</tr>
</thead>
<tr>
<td width="5%" class="flex">公務車使用</td>
<?php
for ($md=1 ; $md<=$weekdays ;$md++) {
if ($food[$md]["car"]&&$food[$md]["cara"]) echo "<td>". nl2br($food[$md]['car'])."&".nl2br($food[$md]['cara']) ."</td>" ;
else if ($food[$md]["car"]) echo "<td>".nl2br($food[$md]['car']) ."</td>" ;
else if ($food[$md]["cara"]) echo "<td>".nl2br($food[$md]['cara']) ."</td>" ;
else echo "<td> </td>" ;
}
echo "</tr>";
for ($tn=0;$tn<$nt;$tn++){
echo "<tr>";
echo "<td width=\"5%\" class=\"flex\">".$nfield[$tn]."</td>";
for ($md = 1; $md <= $weekdays; $md++) {
if ($food[$md][$tfield[$tn]]) echo "<td class=\"$tfield[$tn]\">".nl2br($food[$md][$tfield[$tn]]);
else echo "<td class=\"$tfield[$tn]\">";
}
echo "</td>";
}
echo "</tr>";
?>
</table>
</body>
</html>