일주일 간격으로 한달이 출력되는 소스인데요.
토요일과 일요일은 안나오게 하려고하는데 어떻게 하나요?
<?
$cfg_path = "../";
include_once("$cfg_path/libs/_common.php");
$mb = get_member($USER_UID);
$table_name = "members";
//studio - 강사의 현 studio
$db_studio = explode("|",$mb[m_studio]);
$studio = $db_studio[1];
//오늘날짜
$year = date('Y');
$month = date('n');
$day = date('j');
//echo $year."-".$month."-".$day;
//현재 수정설정 - config_auth
$query = "SELECT * FROM config_auth";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
?>
<meta http-equiv='Content-type' content='text/html;charset=euc-kr'>
<script language="javascript">
<!--
function detailOpen(m_uid) {
newWin("detail_info.php?no="+m_uid,"MemberInfo","50","50","center","center","auto");
}
function lectureList(m_uid) {
newWin("lecture_list.php?m_uid="+m_uid,"MemberInfo","50","50","center","center","auto");
}
function memberModify(m_uid) {
newWin("member_edit.php?m_uid="+m_uid,"MemberInfo","50","50","center","center","auto");
}
function addMember() {
newWin("member_add.php","MemberAdd","50","50","center","center","auto");
}
function memberLeave(m_uid) {
if(confirm("정말 탈퇴처리하시겠습니까?")) {
location.href = "member_leave.php?<?=$link?>&m_uid="+m_uid;
}
}
function go_del(no) {
if(window.confirm('정말로 삭제합니까?')==true) {
location.href='./studio_del_act.php?no='+no;
}
}
//시수 수정
function go_sisu(studio,gyear,gmonth,day) {
<?
if($USER_LEVEL==2) {
?>
var a = window.open('chulcheck_sisu.php?studio='+studio+'&gyear='+gyear+'&gmonth='+gmonth+'&day='+day,'check','width=250,height=130');
a.focus();
<?
} else if($USER_LEVEL==3) { //강사면 오늘날짜것만 수정가능 - 관리자가 풀어주기 전까진 ㅎㅎ
?>
if(gyear == '<?=$year?>' && gmonth == '<?=$month?>' && day == '<?=$day?>') { //해당일에만 수정,입력가능
var a = window.open('chulcheck_sisu.php?studio='+studio+'&gyear='+gyear+'&gmonth='+gmonth+'&day='+day,'check','width=250,height=130');
a.focus();
} else if('<?=$row[gangsa_chul]?>'=='Y') {
var a = window.open('chulcheck_sisu.php?studio='+studio+'&gyear='+gyear+'&gmonth='+gmonth+'&day='+day,'check','width=250,height=130');
a.focus();
} else {
alert('해당일자만 입력,수정가능합니다');
}
<? } ?>
}
//출석시간 수정
function go_check(id,studio,gyear,gmonth,day) {
<?
if($USER_LEVEL==2) {
?>
var a = window.open('chulcheck_day.php?id='+id+'&studio='+studio+'&gyear='+gyear+'&gmonth='+gmonth+'&day='+day,'check','width=250,height=230');
a.focus();
<? } else if($USER_LEVEL==3) { ?>
if(gyear == '<?=$year?>' && gmonth == '<?=$month?>' && day == '<?=$day?>') { //해당일에만 수정,입력가능
var a = window.open('chulcheck_day.php?id='+id+'&studio='+studio+'&gyear='+gyear+'&gmonth='+gmonth+'&day='+day,'check','width=250,height=230');
a.focus();
} else if('<?=$row[gangsa_chul]?>'=='Y') {
var a = window.open('chulcheck_day.php?id='+id+'&studio='+studio+'&gyear='+gyear+'&gmonth='+gmonth+'&day='+day,'check','width=250,height=230');
a.focus();
} else {
alert('해당일자만 입력,수정가능합니다');
}
<? } ?>
}
//-->
</script>
<SCRIPT>
function printDiv () {
if (document.all && window.print) {
window.onbeforeprint = beforeDivs;
window.onafterprint = afterDivs;
window.print();
}
}
function beforeDivs () {
if (document.all) {
objContents.style.display = 'none';
objSelection.innerHTML = document.all['d1'].innerHTML;
}
}
function afterDivs () {
if (document.all) {
objContents.style.display = 'block';
objSelection.innerHTML = "";
}
}
</SCRIPT>
<script language="javascript">
function printWindow() {
factory.printing.header = ""
factory.printing.footer = ""
factory.printing.portrait = true
factory.printing.leftMargin = 10.0
factory.printing.topMargin = 5.0
factory.printing.rightMargin = 10.0
factory.printing.bottomMargin = 5.0
//factory.printing.Print(false, window)
}
</script>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="printWindow();">
<object id=factory style="display:none"
classid="clsid:1663ed61-23eb-11d2-b92f-008048fdd814"
codebase="/ScriptX/smsx.cab#Version=6,1,429,14">
</object>
<link rel="stylesheet" type="text/css" href="../css/styles.css">
<DIV ID="objContents"><span id="d1">
<table width="1100" border="0" cellpadding="0" cellspacing="0">
<?
if($studio) {
$query = "SELECT * FROM studio WHERE no='$studio' ";
// echo $query;
$result = mysql_query($query);
if($result) {
$num = mysql_num_rows($result);
}
if($num>0) {
$row = mysql_fetch_array($result);
}
//넘어온 값이 없다면 디비값가져온다
if(!$gyear && !$gmonth) {
//$gyear = substr($row[syear],0,4);
//$gmonth = (int)substr($row[syear],5,2);
$gyear=date("Y");
$gmonth=date("n");
$gday=date("d"); //오늘
$sd = date("w", mktime(0,0,0,$gmonth,1,$gyear)); //요일 구하기 (num)
$ed = date("t", mktime(0,0,0,$gmonth,1,$gyear)); //마지막날 구하기
$jucnt=ceil(($sd+$ed)/7);
$day=-$sd+1;
} else {
//$gyear=date("Y");
//$gmonth=date("n");
$gday=date("d"); //오늘
$sd = date("w", mktime(0,0,0,$gmonth,1,$gyear)); //요일 구하기 (num)
$ed = date("t", mktime(0,0,0,$gmonth,1,$gyear)); //마지막날 구하기
$jucnt=ceil(($sd+$ed)/7);
$day=-$sd+1;
}
?>
<tr>
<td height="30" style="padding-left:15px;" align="center">(<a href="<?=$PHP_SELF?>?pm=<?=$pm?>&studio=<?=$studio?>&gyear=<?=($gyear-1)?>&gmonth=<?=$gmonth?>&m=030200"><img src=/images/common/attend_title_dot1.gif></a><?=$gyear?>년<a href="<?=$PHP_SELF?>?pm=<?=$pm?>&studio=<?=$studio?>&gyear=<?=($gyear+1)?>&gmonth=<?=$gmonth?>&m=030200"><img src=/images/common/attend_title_dot2.gif></a>
<a href="<?=$PHP_SELF?>?pm=<?=$pm?>&studio=<?=$studio?>&gyear=<?=$gyear?>&gmonth=<?=($gmonth-1)?>&m=030200"><img src=/images/common/attend_title_dot1.gif></a><?=$gmonth?>월<a href="<?=$PHP_SELF?>?pm=<?=$pm?>&studio=<?=$studio?>&gyear=<?=$gyear?>&gmonth=<?=($gmonth+1)?>&m=030200"><img src=/images/common/attend_title_dot2.gif></a>)출석부
</td>
</tr>
<tr>
<td height="30" style="padding-left:10px;"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="20%"><img src=/images/common/attend_menu_01.gif> :
<?=$row[title]?>
</td>
<td width="20%"><img src=/images/common/attend_menu_02.gif> :
<?=$row[grade]?>
학년</td>
<td width="20%"><img src=/images/common/attend_menu_03.gif> :
<?=$row[hakjum]?>
점</td>
<td width="20%"><img src=/images/common/attend_menu_04.gif> :
<?
//members
$query_g = "SELECT * FROM members WHERE m_uid='$row[gangsa]'";
$result_g = mysql_query($query_g);
$row_g = mysql_fetch_array($result_g);
echo $row_g[m_name];
?>
(인)</td>
<td width="20%"><img src=/images/common/attend_menu_05.gif> :
<?
//members
$query_g = "SELECT * FROM members WHERE m_uid='$row[professor]'";
$result_g = mysql_query($query_g);
$row_g = mysql_fetch_array($result_g);
echo $row_g[m_name];
?>
(인)</td>
</tr>
</table></td>
</tr>
<tr>
<td height="30" style="padding-left:10px;"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#666666">
<tr bgcolor="#FFFFFF">
<td width="100" rowspan="4" align="center">
학과</td>
<td width="70" rowspan="4" align="center"> 학번</td>
<td width="60" rowspan="4" align="center"> 성명</td>
<td width="35" align="center">
월</td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"> <?=$gmonth?></td>
<td width="21" align="center"><?=$gmonth?></td>
<td width="21" align="center"><?=$gmonth?></td>
<td width="21" align="center"><?=$gmonth?></td>
<td width="21" align="center"><?=$gmonth?></td>
<td width="21" align="center"><?=$gmonth?></td>
<td width="21" align="center"><?=$gmonth?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="35" align="center">
일</td>
<?
for ( $ju=0 ; $ju < $jucnt ; $ju++ ) {
for ( $i=0 ; $i < 7 ; $i++, $day++ ) {
if ( $day > 0 && $day <= $ed ) { echo "<td width=21 align=center>".$day."</td>"; }
//echo "(".date("w",mktime(0,0,0,3,$day,2008)).")";
}
}
?>
</tr>
<tr bgcolor="#FFFFFF">
<td width="35" align="center">
요일</td>
<?
$day=-$sd+1;
for ( $ju=0 ; $ju < $jucnt ; $ju++ ) {
for ( $i=0 ; $i < 7 ; $i++, $day++ ) {
if ( $day > 0 && $day <= $ed ) {
$yoil = date("w",mktime(0,0,0,$gmonth,$day,$gyear));
if($yoil==0) {
$yoil_han = "일";
} else if($yoil==1) {
$yoil_han = "월";
} else if($yoil==2) {
$yoil_han = "화";
} else if($yoil==3) {
$yoil_han = "수";
} else if($yoil==4) {
$yoil_han = "목";
} else if($yoil==5) {
$yoil_han = "금";
} else if($yoil==6) {
$yoil_han = "토";
}
echo "<td width=21 align=center>".$yoil_han."</td>";
}
}
}
?>
</tr>
<tr bgcolor="#FFFFFF">
<td width="35" align="center">
시수</td>
<?
$day=-$sd+1;
for ( $ju=0 ; $ju < $jucnt ; $ju++ ) {
for ( $i=0 ; $i < 7 ; $i++, $day++ ) {
if ( $day > 0 && $day <= $ed ) {
//시수 - 암꺼나 하나 가져온다
$query1 = "SELECT * FROM chulcheck WHERE studio='$studio' AND year='$gyear' AND month='$gmonth'
AND day='$day' LIMIT 1";
//echo $query1;
$result1 = mysql_query($query1);
$row1 = mysql_fetch_array($result1);
if($row1) {
echo "<td width=21 align=center><a href=javascript:go_sisu(".$studio.",".$gyear.",".$gmonth.",".$day.");>".$row1[sisu]."</a></td>";
} else {
echo "<td width=21 align=center><a href=\"javascript:alert('출석체크 1건입력후 입력가능합니다');\">0</a></td>";
}
}
}
}
?>
</tr>
<?
//members
$db_studio = "|".$studio."|";
$query = "SELECT * FROM members WHERE m_level=9 AND m_studio LIKE '%$db_studio%' AND secede='N' ORDER BY m_uid DESC";
$result = mysql_query($query);
while($mb = mysql_fetch_array($result)) {
//학과
$class = get_class2();
foreach($class as $item => $val)
$class_name = $class[$mb['m_class']];
?>
<tr bgcolor="#FFFFFF">
<td width="100" align="center">
<?=$class_name?>
</td>
<td align="center"><?=$mb[m_id]?></td>
<td align="center"><?=$mb[m_name]?></td>
<td width="35" align="center"></td>
<?
$day=-$sd+1;
for ( $ju=0 ; $ju < $jucnt ; $ju++ ) {
for ( $i=0 ; $i < 7 ; $i++, $day++ ) {
if ( $day > 0 && $day <= $ed ) {
?>
<td width="21" align="center" style="cursor:hand;" onclick="javascript:go_check('<?=$mb[m_id]?>','<?=$studio?>','<?=$gyear?>','<?=$gmonth?>','<?=$day?>');">
<?
//chulcheck
$query1 = "SELECT * FROM chulcheck WHERE id='$mb[m_id]' AND studio='$studio' AND year='$gyear' AND month='$gmonth'
AND day='$day'";
$result1 = mysql_query($query1);
$row1 = mysql_fetch_array($result1);
echo $row1[chulcheck];
?>
</td>
<?
}
}
}
?>
</tr>
<? } ?>
<!-- -->
</table></td>
</tr><? } ?>
</table> <br>
</span>
<a href="javascript:printDiv('d1');"><img src=/images/common/attend_button_01.gif></a><a href="javascript:self.close();"><img src=/images/common/attend_button_02.gif></a>
</div>
<DIV ID="objSelection">
</DIV>
|