// ÀÛ¼ºÀÚ : ÃÖ»ó¹Î
// ¼öÁ¤ÀÏ : 2002³â 3¿ù 12ÀÏ
// ÆÄÀϸí : diary.html
// ÀϱâÀå
include ("../inc/header.html");
include ("../common/dbConnect.php");
include ("../common/week.php");
include ("../common/common.php");
$toYear = date("Y", time());
$toMonth = date("m", time());
$toDay = date("d", time());
if($year == "")
$year = $toYear;
if($month == "")
$month = $toMonth;
if($day == "")
$day = $toDay;
$week = new week($year, $month, $day);
$start = $week->getStartWeek();
$end = $week->getEndWeek();
$prev = $week->getPrevWeek();
$next = $week->getNextWeek();
function delDiary() {
global $mode, $memberID, $year, $monh, $day, $conn, $no;
}
function viewDiary() {
global $mode, $memberID, $year, $month, $day, $conn, $no;
$flag = true;
if($mode == "view") {
if($no == "") {
alert("ÀÏ±â¹øÈ£°¡ ¾ø½À´Ï´Ù.", 1);
$flag = false;
}
$query = "select * from diary d INNER JOIN member m ON d.id=m.id where no=$no";
$result = $conn->runQuery($query);
$rows = mysql_fetch_array($result);
if($rows[open] == "A") {
if($rows[id] != $memberID)
alert("Àڽſ¡°Ô¸¸ ÀÐÇôÁöµµ·Ï Àá°ÜÁø ÀϱâÀÔ´Ï´Ù.", 2);
}
else if($rows[open] == "M") {
if($memberID == "")
alert("¿¬Àγ¢¸®¸¸ ÀÐÀ» ¼ö ÀÖ½À´Ï´Ù.", 2);
}
// $img = ($rows[attachFile] == "")?"
":"
";
$img = ($rows[attachFile] == "")?"/img/defaultDiary.gif":"./img_data/$rows[attachFile]";
$rows[subject] = htmlspecialchars($rows[subject]);
$rows[subject] = stripslashes($rows[subject]);
$rows[content] = htmlspecialchars($rows[content]);
$rows[content] = stripslashes($rows[content]);
$rows[content] = str_replace("\n", "
", $rows[content]);
$rows[content] = str_replace(" ", " ", $rows[content]);
echo "
|
".substr($rows[writeDate],0,10)." ([³¯¾¾] $rows[weather] | [±âºÐ] $rows[feel]) |
|
$rows[subject] [$rows[name]] |
";
if($rows[id] == $memberID)
echo "
";
echo " |
|
$rows[content]
|
|
";
}
if($mode != "view" || $flag == false) {
echo "
|
|
¢Æ ÀϱâÀå |
|
|
|
ÇÏ·ç¿¡ ÇÑÀåÀÇ ÀϱⰡ,
¾î¼¸é °®Áö ¸øÇÒ ¸¹Àº °¨µ¿À» ÀüÇØÁÝ´Ï´Ù.
±× ¿À·¡µÈ Àϱ⿡´Â ¶Ç ¾î¼¸é,
»õ·Î¿î ÀϱâÀå¿¡µµ ÀÚ¸®ÀâÀ» °¨µ¿ÀÌ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù.
¿À·¡ Àü¿¡ Á¦°¡ Àû¾ú´ø ±× ÇÑÀå¿¡´Â,
¿©ÀüÈ÷ ±×³à°¡ ÀÚ¸®Àâ°í ÀÖ½À´Ï´Ù.
|
|
|
 |
";
}
}
function getTable() {
global $week, $start, $next, $prev, $diaryArray, $member, $toYear, $toMonth, $toDay, $memberID;
$startStamp = mktime(0,0,0,$start[1], $start[2], $start[0]);
$date = array("[ìí]", "[êÅ]", "[ûý]", "[â©]", "[ÙÊ]", "[ÐÝ]", "[÷Ï]");
$member = getMember();
$data = getDiary();
echo "
";
viewDiary();
echo " |
¢¸
¢º
|
|
";
for($i=0 ; $i<7 ; $i++) {
$tmpYear = date("Y", $startStamp + ($i*24*60*60));
$tmpMonth = date("m", $startStamp + ($i*24*60*60));
$tmpDay = date("d", $startStamp + ($i*24*60*60));
$tmpDate = "$tmpMonth/$tmpDay";
echo " ";
// ¿À´Ã ³¯Â¥ ÀÌÀü²¨¸¸ ±Û¾µ¼ö ÀÖÀ½
if(mktime(0,0,0,$tmpMonth, $tmpDay, $tmpYear) <= time())
echo "";
echo "$tmpDate $date[$i]";
// ¿À´Ã ³¯Â¥¿¡ Ç¥½ÃÇØÁÖ±â
if($tmpYear == $toYear && $tmpMonth == $toMonth && $toDay == $tmpDay)
echo " ";
echo " ";
if($data[$member[0][0]][$tmpDate][0] != "") {
echo "
";
// ±ÇÇѺ°·Î ¸µÅ©°É±â -- ¿©ÀÚ
if($data[$member[0][0]][$tmpDate][3] == "A") {
if($data[$member[0][0]][$tmpDate][1] == $memberID)
echo "";
}
else if($data[$member[0][0]][$tmpDate][3] == "M") {
if($memberID != "")
echo "";
}
else if($data[$member[0][0]][$tmpDate][3] == "N")
echo "";
echo strSplit($data[$member[0][0]][$tmpDate][2], 10, "..")."";
}
// ±ÇÇѺ°·Î ¸µÅ©°É±â -- ³²ÀÚ
if($data[$member[1][0]][$tmpDate][0] != "") {
echo "
";
// ±ÇÇѺ°·Î ¸µÅ©°É±â
if($data[$member[1][0]][$tmpDate][3] == "A") {
if($data[$member[1][0]][$tmpDate][3] == $memberID)
echo "";
}
else if($data[$member[1][0]][$tmpDate][3] == "M") {
if($memberID != "")
echo "";
}
else if($data[$member[1][0]][$tmpDate][3] == "N")
echo "";
echo strSplit($data[$member[1][0]][$tmpDate][2], 10, "..")."";
}
echo " | ";
}
echo"
|
";
}
function getDiary() {
global $conn, $start, $end;
$start[1] = (strlen($start[1]) < 2)?"0$start[1]":$start[1];
$start[2] = (strlen($start[2]) < 2)?"0$start[2]":$start[2];
$end[1] = (strlen($end[1]) < 2)?"0$end[1]":$end[1];
$end[2] = (strlen($end[2]) < 2)?"0$end[2]":$end[2];
$startDate = "$start[0]-$start[1]-$start[2]";
$endDate = "$end[0]-$end[1]-$end[2]";
$query = "select no, id, subject,date_format(toDay, '%m/%d') as toDay, open from diary where toDay>='$startDate' and toDay <='$endDate' order by toDay";
$result = $conn->runQuery($query);
while($rows = mysql_fetch_array($result)) {
$diaryArray[$rows[id]][$rows[toDay]][0] = $rows[no];
$diaryArray[$rows[id]][$rows[toDay]][1] = $rows[id];
$diaryArray[$rows[id]][$rows[toDay]][2] = $rows[subject];
$diaryArray[$rows[id]][$rows[toDay]][3] = $rows[open];
}
return $diaryArray;
}
function getMember() {
global $conn;
$query = "select id, name, sex from member order by sex";
$result = $conn->runQuery($query);
$count = 0;
while($rows = mysql_fetch_array($result)) {
$member[$count][0] = $rows[id];
$member[$count][1] = $rows[name];
$member[$count][2] = $rows[sex];
$count++;
}
return $member;
}
getTable();
include ("../inc/footer.html");
?>