<? 
/* _______________________________________________________________________________ 
  | Autor: Guilherme Buozzi Pachella ICQ: 127049217 e-mail: gui_pachela@uol.com.br| 
  | Este script foi totalmente reestruturado por mim, s� peguei pronta a parte de | 
  | montar o calend�rio, implementei as consultas no banco para ver os dias de    | 
  | festa, converti o idioma e coloquei em destaque o dia atual.                  | 
  |                       FAVOR MANTER ESTES CR�DITOS                             | 
  | 
  |                             ALTERADO POR 
  |                   joseaugustomoraes@hotmail.com 
  |_______________________________________________________________________________ 
*/ 

?>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<?
include "config.php"; 
$SQL="select * from calendario order by id desc";  
$result = mysql_db_query($DB,$SQL,$link); 
$linha=mysql_num_rows($result);
if (isset($show_month)) {
if ($show_month==">") {
  if($month==12) {
     $month=1;
     $year++;
     } else {
     $month++;
     }
     }
if ($show_month=="<") {
  if($month==1) {
     $month=12;
     $year--;
     } else {
     $month--;
     }
     }
}
if (isset($day)) {
if ($day<="9"&ereg("(^[1-9]{1})",$day)) {
  $day="0".$day;
  }
}
if (isset($month)) {
if ($month<="9"&ereg("(^[1-9]{1})",$month)) {
  $month="0".$month;
  }
}
if (!isset($year)) {
  $year=date("Y",mktime());
  }
if (!isset($month)) {
  $month=date("m",mktime());
  }
if (!isset($day)) {
  $day=date("d",mktime());
  }
$thisday="$year-$month-$day";
$day_name=array("Seg","Ter","Qua","Qui","Sex","S�b"	,"<font color=\"#FF0000\">Dom</font>");

$month_abbr=array("","Janeiro","Fevereiro","Mar�o","Abril","Maio","Junho","Julho","Agosto","Setembro","Outubro","Novembro","Dezembro");

$y=date("Y");
   switch ($month) {
    case 1:  $month_name = "Jan";	break;
    case 2:  $month_name = "Fevereiro";	break;
    case 3:  $month_name = "Mar�o";	break;
    case 4:  $month_name = "Abril";	break;
    case 5:  $month_name = "Maio";	break;
    case 6:  $month_name = "Junho";	break;
    case 7:  $month_name = "Julho";	break;
    case 8:  $month_name = "Agosto";	break;
    case 9:  $month_name = "Setembro";	break;
    case 10: $month_name = "Outubro";	break;
    case 11: $month_name = "Novembro";	break;
    case 12: $month_name = "Dezembro";	break;
   }
if (empty($month)) {
$month = date("m");
$year = date("Y");
}

$next = mktime(0,0,0,$month + 1,1,$year);
$nextano = date("Y",$next);
$nextmonth = date("m",$next);

$prev = mktime(0,0,0,$month - 1,1,$year);
$prevano = date("Y",$prev);
$prevmonth = date("m",$prev);

?>
<link href="colegio.css" rel="stylesheet" type="text/css" />


<div align="center"> 
  <table width="150" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
    <tr> 
      <td width="100"><div align="center"> 
          <table width="100%" border="0" cellpadding="1" cellspacing="2">
            <tr align="center"> 
              <td colspan="7" align="center" class="ano"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td width="5"><a class="setas" href="calendario.php?month=<? echo $prevmonth; ?>&amp;year=<? echo $prevano; ?>"><img src="img/seta.png" width="19" height="18" border="0" /></a></td>
                  <td align="center" valign="top" background="img/setabg.png"><a class="setas" href="calendario.php?month=<? echo $prevmonth; ?>&amp;year=<? echo $prevano; ?>"></a> <span class="mes"><? echo "$month_name $year";?></span> <a class="setas" href="calendario.php?month=<? echo $nextmonth; ?>&amp;year=<? echo $nextano; ?>"></a></td>
                  <td width="5"><a class="setas" href="calendario.php?month=<? echo $nextmonth; ?>&amp;year=<? echo $nextano; ?>"><img src="img/seta2.png" width="19" height="18" border="0" /></a></td>
                </tr>
              </table></td>
            </tr>
            <tr class="dia" align="center"> 
              <?
  for ($i=0;$i<7;$i++) { ?>
              <td width="39" align="center" bgcolor="#FFFFFF"><? echo "$day_name[$i]"; ?></td>
              <? } ?>
            </tr>
            <tr class="dia" align="center">
              <?
			  
			  // DATA Q VEM ANTES ---------------------------------------------
  if (date("w",mktime(0,0,0,$month,1,$year))==0) {
    $start=7;
  } else {
    $start=date ("w",mktime(0,0,0,$month,1,$year));
    }
  for($a=($start-2);$a>=0;$a--)
     {
      $d=date("t",mktime(0,0,0,$month,0,$year))-$a;
  ?>
              <td bgcolor="#EEEEEE" align="center"> <?=$d?>   </td>
 <? }
 
 			  // DATAS ATUAIS ---------------------------------------------
 
  for($d=1;$d<=date("t",mktime(0,0,0,($month+1),0,$year));$d++)
        {
		global $linha;
	 if($month==date("m") && $year==date("Y") && $d==date("d")) {
      $bg="bgcolor=\"#B0CCE4\"";
	  $linkando="";
	  $fimlink="";
	} else {
      $bg="bgcolor=\"#d4e3f1\"";
	  $linkando="";
	  $fimlink="";
	  }
	for ($i=0;$i<$linha;$i++){
	global $month,$year,$d;
	$dia_sql=mysql_result($result,$i,'dia');
	$mes_sql=mysql_result($result,$i,'mes');
	$ano_sql=mysql_result($result,$i,'ano');
	$id_sql=mysql_result($result,$i,'id');
	$ano = ltrim(rtrim($ano_sql));
	$mes = ltrim(rtrim($mes_sql));
	$dia = ltrim(rtrim($dia_sql));
	$id_cod = ltrim(rtrim($id_sql));
	if($d==$dia&$year==$ano&$month==$mes) {
      $bg="bgcolor=#ffa800";
	  $linkando="<a href=xxxxx.php?id_cod=$id_cod><font color=#ffffff>";
	  $fimlink="</font></a>";
	  		} 	
	  }
  ?>
              <td align="center" <?php echo $bg; ?>>
            
               <? echo $linkando; ?>
               <? echo $d; ?>
               <? echo $fimlink; ?>
               
               </td>
               
  <?
  
			  // DATA Q VEM DEPOIS ---------------------------------------------
  
  
  if(date("w",mktime(0,0,0,$month,$d,$year))==0&date("t",mktime(0,0,0,($month+1),0,$year))>$d)
  {
  ?>
            </tr>
            
            <tr class="dia" align="center"> 
              <?   }}
  $da=$d+1;
  if(date("w",mktime(0,0,0,$month+1,1,$year))<>1)
         {
          $d=1;
          while(date("w",mktime(0,0,0,($month+1),$d,$year))<>1)
                  {
  ?>
              <td bgcolor="#EEEEEE" align="center"> 
                <?=$d?>              </td>
              <?
            $d++;
                  }
        }
  ?>
            </tr>
          </table>
          </div></td>
    </tr>
    <tr>
      <td><table width="100%" border="0" cellpadding="1" cellspacing="2">
        <tr class="dia" align="center">
          <td colspan="2" align="center" bgcolor="#eaeaea"><? $date = date("d / m / Y"); echo "Hoje &eacute; dia $date"; ?>          </td>
        </tr>
      </table>        <font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><?php 
	for ($i=0;$i<$linha;$i++){
	$dia_sql=mysql_result($result,$i,'dia');
	$mes_sql=mysql_result($result,$i,'mes');
	$ano_sql=mysql_result($result,$i,'ano');
	if($mes_sql==date("m") && $ano_sql==date("Y")) {
	$dados_sql=mysql_result($result,$i,'dados');	
	echo "<b>:: $dia_sql"."/"."$mes_sql"."/"."$ano_sql"." :"."</b> $dados_sql<br>";
	}
	}
	?></font></td>
    </tr>
  </table>
</div>