<?php
$pdo = new PDO('mysql:host=localhost;dbname=hospital;charset=utf8', 'admin01', 'admin01');
$pdo->query("set names utf8");
 
$title="一般內科";
$depID = "31800";
if (isset($_GET["depID"]))
	$depID = $_GET["depID"];
 
$sql = "SELECT departName FROM `opd` WHERE departID='".$depID."'";
$pdoStatement = $pdo->prepare($sql);
$ret = $pdoStatement->execute();
$row = $pdoStatement->fetch();
$title=$row["departName"];
 
$sql = "SELECT id, dname, vsection, vday FROM schedule WHERE depID='".$depID."'";
$pdoStatement = $pdo->prepare($sql);
$ret = $pdoStatement->execute();
$rowsSchedule = $pdoStatement->fetchAll();
$array_dname = array();//醫生的名字
foreach ($rowsSchedule as $rowS)
{
  $array_dname[$rowS["id"]] = $rowS["dname"];
}
 
$sql = "SELECT id, scheduleID, depID, count, max, visit_date, comment FROM reservation WHERE depID ='".$depID."'";
$pdoStatement = $pdo->prepare($sql);
$ret = $pdoStatement->execute();
$rowsReservation = $pdoStatement->fetchAll();
$array_count = array();
$array_max = array();
$array_reserveID = array();
foreach ($rowsReservation as $rowR)
{
  $array_count[$rowR["scheduleID"]][$rowR["visit_date"]] = $rowR["count"];
  $array_max[$rowR["scheduleID"]][$rowR["visit_date"]] = $rowR["max"];
  $array_reserveID[$rowR["scheduleID"]][$rowR["visit_date"]] = $rowR["id"];
}
//時間處理
$w = array();
$dtVisit = new DateTime();
$dtBegin = new DateTime();
$dtVisit->modify('monday this week');
function markup($enable, $sid, $date, $array_dname, $array_count, $array_max, $array_reserveID)
{
   $dname= $array_dname["$sid"];
   if ($enable)
   {
      $count = $array_count["$sid"]["$date"];
      $max = $array_max["$sid"]["$date"];
      $rid = $array_reserveID["$sid"]["$date"];
      $a='<a href="opd-reserve-form.php?sid='.$sid.'&rid='.$rid.'">'.$dname.'</a>(預約:'.$count.'/'.$max.')<br>';
   }
   else
      $a=$dname.'()<br>';
   return $a;
}
 
?>
<!-- saved from url=(0089)http://www.cmuh.cmu.edu.tw/html/portlet/cmuh/schedule/DymSchedule.jsp?catId=1&depId=31800 -->
<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
	<link rel="stylesheet" type="text/css" href="./DymSchedule_files/schedule.css">
</head>
 
 
<body>
 
<div id="schtab">
<?php
for ($j = 1; $j <= 4; $j++) 
{
$doctors = array (
    "w1"  => array("morning" => "", "afternoon" => "", "night" => ""),
    "w2"  => array("morning" => "", "afternoon" => "", "night" => ""),
	"w3"  => array("morning" => "", "afternoon" => "", "night" => ""),
    "w4"  => array("morning" => "", "afternoon" => "", "night" => ""),
	"w5"  => array("morning" => "", "afternoon" => "", "night" => ""),
    "w6"  => array("morning" => "", "afternoon" => "", "night" => ""),
	"w7"  => array("morning" => "", "afternoon" => "", "night" => "")
);
for ($i = 1; $i <= 7; $i++) 
{
   $enable = true;
   if ($dtVisit < $dtBegin) 
      $enable = false;
 
   $theday = $dtVisit->format('Y-m-d');
   $w[$i]=$theday ;
   foreach ($rowsSchedule as $rowD)
   {
      $sid = $rowD["id"];
      if ($i==1 && $rowD["vday"] == "星期一")
      {
         if ($rowD["vsection"] == "上午")
            $doctors["w1"]["morning"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
         else if ($rowD["vsection"] == "下午")
            $doctors["w1"]["afternoon"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
         else if ($rowD["vsection"] == "晚上")
            $doctors["w1"]["night"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
      }
      else if ($i==2 && $rowD["vday"] == "星期二")
      {
         if ($rowD["vsection"] == "上午")
            $doctors["w2"]["morning"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
         else if ($rowD["vsection"] == "下午")
            $doctors["w2"]["afternoon"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
         else if ($rowD["vsection"] == "晚上")
            $doctors["w2"]["night"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
      }
      else if ($i==3 && $rowD["vday"] == "星期三")
      {
         if ($rowD["vsection"] == "上午")
            $doctors["w3"]["morning"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
         else if ($rowD["vsection"] == "下午")
            $doctors["w3"]["afternoon"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
         else if ($rowD["vsection"] == "晚上")
            $doctors["w3"]["night"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
      }
      else if ($i==4 && $rowD["vday"] == "星期四")
      {
         if ($rowD["vsection"] == "上午")
            $doctors["w4"]["morning"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
         else if ($rowD["vsection"] == "下午")
            $doctors["w4"]["afternoon"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
         else if ($rowD["vsection"] == "晚上")
            $doctors["w4"]["night"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
      }
      else if ($i==5 && $rowD["vday"] == "星期五")
      {
         if ($rowD["vsection"] == "上午")
            $doctors["w5"]["morning"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
         else if ($rowD["vsection"] == "下午")
            $doctors["w5"]["afternoon"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
         else if ($rowD["vsection"] == "晚上")
            $doctors["w5"]["night"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
      }
      else if ($i==6 && $rowD["vday"] == "星期六")
      {
         if ($rowD["vsection"] == "上午")
            $doctors["w6"]["morning"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
         else if ($rowD["vsection"] == "下午")
            $doctors["w6"]["afternoon"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
         else if ($rowD["vsection"] == "晚上")
            $doctors["w6"]["night"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
      }
      else if ($i==7 && $rowD["vday"] == "星期日")
      {
         if ($rowD["vsection"] == "上午")
            $doctors["w7"]["morning"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
         else if ($rowD["vsection"] == "下午")
            $doctors["w7"]["afternoon"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
         else if ($rowD["vsection"] == "晚上")
            $doctors["w7"]["night"] .=markup($enable, $sid, $theday, $array_dname, $array_count, $array_max, $array_reserveID);
      }
   }
 
   $dtVisit->modify('+1 day');
}
print '
	<table class="sch">
			<!-- 抓Tittle -->
			<caption>'.$title .'</caption>
 
		<tbody><tr>	<td class="firstth"></td>
<th class="outertop"><center>星期一('.$w[1].')</center></th><th class="outertop"><center>星期二('.$w[2].')</center></th><th class="outertop"><center>星期三('.$w[3].')</center></th><th class="outertop"><center>星期四('.$w[4].')</center></th><th class="outertop"><center>星期五('.$w[5].')</center></th><th class="outertop"><center>星期六('.$w[6].')</center></th><th class="outertop"><center>星期日('.$w[7].')</center></th>
 
		</tr>
 
 
			<tr>	
<th class="outerleft"><center>上午 <br>08:30<br><div class="outerleft_pic"></div><br>12:00</center></th>
						<td class="inner1">
 
								'.$doctors["w1"]["morning"].'
 
						</td>
 
 
						<td class="inner2">
 
								'.$doctors["w2"]["morning"].'
 
						</td>
 
 
						<td class="inner1">
								'.$doctors["w3"]["morning"].'
						</td>
 
 
						<td class="inner2">
 
								'.$doctors["w4"]["morning"].'
						</td>
 
 
						<td class="inner1">
 
								'.$doctors["w5"]["morning"].'
 
						</td>
 
 
						<td class="inner2">
								'.$doctors["w6"]["morning"].'
						</td>
 
 
						<td class="inner1">
								'.$doctors["w7"]["morning"].'
						</td>
			</tr>
 
 
			<tr>	
<th class="outerleft"><center>下午<br>13:30<br><div class="outerleft_pic"></div><br>17:00</center></th>
						<td class="inner1">
 
								'.$doctors["w1"]["afternoon"].'
 
						</td>
 
 
						<td class="inner2">
 
								'.$doctors["w2"]["afternoon"].'
 
						</td>
 
 
						<td class="inner1">
								'.$doctors["w3"]["afternoon"].'
						</td>
 
 
						<td class="inner2">
 
								'.$doctors["w4"]["afternoon"].'
						</td>
 
 
						<td class="inner1">
 
								'.$doctors["w5"]["afternoon"].'
 
						</td>
 
 
						<td class="inner2">
								'.$doctors["w6"]["afternoon"].'
						</td>
 
 
						<td class="inner1">
								'.$doctors["w7"]["afternoon"].'
						</td>
 
 
			</tr>
 
 
			<tr>	
<th class="outerleft"><center>晚上<br>18:30<br><div class="outerleft_pic"></div><br>21:00</center></th>
						<td class="inner1">
 
								'.$doctors["w1"]["night"].'
 
						</td>
 
 
						<td class="inner2">
 
								'.$doctors["w2"]["night"].'
 
						</td>
 
 
						<td class="inner1">
								'.$doctors["w3"]["night"].'
						</td>
 
 
						<td class="inner2">
 
								'.$doctors["w4"]["night"].'
						</td>
 
 
						<td class="inner1">
 
								'.$doctors["w5"]["night"].'
 
						</td>
 
 
						<td class="inner2">
								'.$doctors["w6"]["night"].'
						</td>
 
 
						<td class="inner1">
								'.$doctors["w7"]["night"].'
						</td>
 
 
			</tr>
 
 
</tbody></table>
';
}
?>
			<p class="schedule_p">
 
			</p>
			<div class="clear"></div>
 
</div>
 
</body></html>

bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark

Tags: ,

This entry was posted on 星期一, 七月 13th, 2015 at 07:20:05 and is filed under 104(暑)程式設計營. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a reply

Name (*)
Mail (will not be published) (*)
URI
Comment