$num = $i;
} else {
$font = "<font class='message'>";
$num = $i;
}
if ($day == $i) {
$style = "style=\"border : 1px solid #FF0000;\"";
} else {
$style = "";
}
if (mysql_num_rows($result) != 0) {
$style .= " class='tumma'";
}
echo " <td align='center' {$style}><a href='{$PHP_SELF}?session={$session}&year={$year}&month={$month}&day={$i}&toim={$toim}'>{$font} {$num}</font></a></td>\n";
// jos kyseessä on sunnuntai, tehdään rivinvaihto..
if (weekday_number($i, $month, $year) == 6) {
// kirjotetaan viikon numero jos seuraava viikko on olemassa
if (days_in_month($month, $year) != $i) {
$weeknro = date("W", mktime(0, 0, 0, $month, $i + 1, $year));
echo "</tr><tr><th>{$weeknro}</th>";
}
}
}
//kirjoitetaan loppuun tyhjiä soluja
for ($i = 0; $i < 6 - weekday_number(days_in_month($month, $year), $month, $year); $i++) {
echo "<td> </td>";
}
echo "</tr>";
echo "<tr><td class='back' align='center' colspan='8'><a href='{$PHP_SELF}?day=1&month={$backmmonth}&year={$backymonth}&toim={$toim}'>" . t("Edellinen") . "</a> - <a href='{$PHP_SELF}?day=1&month={$nextmmonth}&year={$nextymonth}&toim={$toim}'>" . t("Seuraava") . "</a></td></tr>\n";
echo "</table></th></tr></table>";
require "../inc/footer.inc";
$result = pupe_query($query);
while ($row = mysql_fetch_array($result)) {
echo "<tr><td width='35'>{$row['alanimi']}</td><td></td>";
for ($i = 1; $i <= days_in_month($month, $year); $i++) {
$pva = $i;
$query = "SELECT kalenteri.tunnus tunnus, pvmalku, pvmloppu, kalenteri.yhtio, if(kuka.nimi!='', kuka.nimi, kuka.kuka) nimi, replace(kentta01,'\r\n',' ') kentta01,\n date_format(pvmalku,'%H:%i') kello, date_format(pvmloppu,'%H:%i') lkello\n FROM kalenteri, kuka\n WHERE kalenteri.tyyppi = 'varauskalenteri'\n and pvmalku <= '{$year}-{$mymonth}-{$pva} 23:59:00'\n and pvmloppu >= '{$year}-{$mymonth}-{$pva} 00:00:00'\n and kalenteri.tapa = '{$row['alanimi']}'\n and kalenteri.yhtio = kuka.yhtio\n and kalenteri.kuka = kuka.kuka\n {$konsernit2}\n order by pvmalku";
$kresult = pupe_query($query);
$krow = mysql_fetch_array($kresult);
if ($krow["nimi"] == '') {
echo "<td align='center' width='35'><a class='td' href='../varauskalenteri/varauskalenteri.php?lopetus={$lopetus}&tee=SYOTA&year={$year}&month={$month}&day={$pva}&toim={$row['alanimi']}'> </a></td>";
} else {
echo "<div id='div_{$krow['tunnus']}' class='popup' style='width:200px;'>";
if (mysql_num_rows($kresult) > 0) {
mysql_data_seek($kresult, 0);
while ($krow2 = mysql_fetch_array($kresult)) {
echo "{$krow2['kello']}-{$krow2['lkello']} {$krow2['nimi']}<br>{$row['alanimi']}.<br>{$krow2['kentta01']}<br><br>";
}
}
echo "</div>";
echo "<td align='center' width='35' class='tooltip' id='{$krow['tunnus']}'><a class='td' href='../varauskalenteri/varauskalenteri.php?lopetus={$lopetus}&tee=NAYTA&year={$year}&month={$month}&day={$pva}&tunnus={$krow['tunnus']}&toim={$row['alanimi']}'>{$krow['nimi']}</a></td>";
}
if (weekday_number($i, $month, $year) == 6) {
echo "<td class='back'></td>";
}
echo "\n";
}
echo "</tr>";
}
}
echo "</table>";
require "inc/footer.inc";
echo "</td>";
}
$solu++;
}
if (count($ASENTAJA_ARRAY_TARK) < 5 and weekday_number($i, $month, $year) == 6 and $solu > 0) {
// Rivinvaihto jos seuraava viikko on olemassa
if (days_in_month($month, $year) != $i) {
echo "</tr><tr>";
echo "<td class='back' style='vertical-align: bottom;'>\n <table style='width: 100%; height: 100%;'>\n <tr><td class='back' style='height: {$korkeus};'> </td></tr>\n <tr><td class='back' style='height: {$korkeus};'> </td></tr>";
foreach ($AIKA_ARRAY as $a) {
if ($toim == 'TYOMAARAYS_ASENTAJA') {
$a = ' ';
}
echo "<tr><td class='back' style='height: {$korkeus};'>{$a}</td></tr>";
}
echo "</table>";
echo "</td>";
}
}
}
// Kirjotetaan loppuun tyhjiä soluja
if (count($ASENTAJA_ARRAY_TARK) < 5 and weekday_number($i, $month, $year) < count($DAY_ARRAY) and weekday_number($i, $month, $year) > 0) {
for ($a = weekday_number($i, $month, $year); $a <= count($DAY_ARRAY) - 1; $a++) {
echo "<td class='back'> </td>";
}
}
echo "</tr>";
echo "</table>";
echo "</div>";
}
require "inc/footer.inc";
