include "./lib/header.php";
include "./lib/mysql.php";
$nYear = date("Y");
$nMon = date("n");
$sYear = (!$sYear) ? $nYear : $sYear;
$sMon = (!$sMon) ? $nMon : $sMon;
$query = "SELECT id, subject, DATE_FORMAT(startdate,'%e') as snum, DATE_FORMAT(startdate,'%c') as smon, DATE_FORMAT(enddate,'%e') as enum, DATE_FORMAT(enddate,'%c') as emon FROM schedule_project WHERE DATE_FORMAT(startdate,'%Y-%m') = '$sYear-".substr("0".$sMon,strlen($sMon) -1,2)."' OR DATE_FORMAT(enddate,'%Y-%m') = '$sYear-".substr("0".$sMon,strlen($sMon) -1,2)."'";
$rs = mysql_query($query,$connect);
while($row = mysql_fetch_array($rs))
{
$tasktype[$row[id]] = stripslashes($row[subject]);
if ($row[smon] == $row[emon]) // ÇÑ´Þ¿¡ ¸ðµÎ Æ÷ÇÔ
{
for ($i=$row[snum]; $i <= $row[enum]; $i++)
{
switch($i)
{
case ($row[snum]):
${"task".$row[id]}[$i] = "l";
break;
case ($row[enum]):
${"task".$row[id]}[$i] = "r";
break;
default:
${"task".$row[id]}[$i] = "m";
break;
}
}
}
elseif ($row[smon] != $row[emon])
{
if ($row[smon] == $sMon) // ÀÌ´Þ ¸»±îÁö Ãâ·Â
{
for ($i=$row[snum]; $i <= date("t",mktime(0,0,0,$sMon,1,$sYear)); $i++)
{
switch($i)
{
case ($row[snum]):
${"task".$row[id]}[$i] = "l";
break;
case (date("t",mktime(0,0,0,$sMon,1,$sYear))):
${"task".$row[id]}[$i] = "r";
break;
default:
${"task".$row[id]}[$i] = "m";
break;
}
}
}
elseif ($row[emon] == $sMon) // ÀÌ´Þ ÃʺÎÅÍ Ãâ·Â
{
for ($i=1; $i <= $row[enum]; $i++)
{
switch($i)
{
case (1):
${"task".$row[id]}[$i] = "l";
break;
case ($row[enum]):
${"task".$row[id]}[$i] = "r";
break;
default:
${"task".$row[id]}[$i] = "m";
break;
}
}
}
}
}
$query = "SELECT subject, recordtype, DATE_FORMAT(rtime,'%e') as rdate FROM schedule WHERE DATE_FORMAT(rtime,'%Y-%m') = '$sYear-".substr("0".$sMon,strlen($sMon) -1,2)."'";
$rs = mysql_query($query,$connect);
while ($row = mysql_fetch_array($rs))
{
switch ($row[recordtype])
{
case "0":
$m[$row[rdate]] = true;
$mdoc[$row[rdate]] .= stripslashes($row[subject])."\n";
break;
case "1":
$a[$row[rdate]] = true;
$adoc[$row[rdate]] .= stripslashes($row[subject])."\n";
break;
case "2":
$c[$row[rdate]] = true;
$cdoc[$row[rdate]] .= stripslashes($row[subject])."\n";
break;
}
}
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$startnum = date("w", mktime(0,0,0,$sMon,1,$sYear));
$endnum = date("t", mktime(0,0,0,$sMon,1,$sYear) );
for ($i = 0; $i < $startnum; $i++)
{
echo " | ";
echo " | ";
}
for ($j = 1; $j <= $endnum; $j++)
{
if (!date("w", mktime(0,0,0,$sMon,$j,$sYear)) && !($j == 1 && $startnum ==0))
{
echo " | ";
echo "
";
echo "";
echo " | ";
echo "
";
echo "";
$cellrow = 0;
}
echo " | ";
echo "";
echo "$j | ";
echo "";
echo ($m[$j]) ? "" : "";
echo ($a[$j]) ? "" : "";
echo ($c[$j]) ? "" : "";
echo " | ";
// Task0 Ãâ·Â
if ($task0[$j])
{
echo "";
}
elseif ($task0[$j] == "r")
{
echo " align=right>";
}
else
{
echo ">";
}
echo " | ";
if ($task0[$j] == "l")
{
echo "$tasktype[0] | ";
}
else
{
echo " | ";
}
}
else
{
echo " | ";
}
// Task1 Ãâ·Â
if ($task1[$j])
{
echo "";
}
elseif ($task1[$j] == "r")
{
echo " align=right>";
}
else
{
echo ">";
}
echo " | ";
if ($task1[$j] == "l")
{
echo "$tasktype[1] | ";
}
else
{
echo " | ";
}
}
else
{
echo " | ";
}
// Task2 Ãâ·Â
if ($task2[$j])
{
echo "";
}
elseif ($task2[$j] == "r")
{
echo " align=right>";
}
else
{
echo ">";
}
echo " | ";
if ($task2[$j] == "l")
{
echo "$tasktype[2] | ";
}
else
{
echo " | ";
}
}
else
{
echo " | ";
}
echo " | ";
$cellrow++;
}
for ($i = $cellrow; $i < 7; $i++)
{
echo " | ";
echo " | ";
}
?>
|
|
|
include "./lib/footer.php";
?>