Weblabor

<?php
	$honap = $kev.'-'.$khonap.'-';

	require_once("require.php");

	if ($_SERVER['REQUEST_METHOD']=="POST") {

		if (!$_POST['cim_id']) $crash[] = "HIÁNYZIK a PARTNER!";

		if (count($crash)==0)	{


			$comm = "SELECT * FROM jos_szobak ORDER BY emelet, megnev";
			$result = mysql_query($comm) or mysql_crash($comm);
			while ($row=mysql_fetch_array($result))		{
					if (is_array(${'szobade'.$row[szoba_id]})) {
							foreach( ${'szobade'.$row[szoba_id]} as $ertek ) {
									$honap = $kev.'-'.$khonap.'-';
									if ($ertek>31) {
											$honap = getnextdatum($kev, $khonap);
											$ertek = $ertek - 31;
									}
									$comm = "DELETE FROM jos_foglalas WHERE cim_id='".$_POST['cim_id']."' AND szoba_id='".$row[szoba_id]."' AND fdatum='".$honap.$ertek."' AND allapot=1";
									$resultal = mysql_query($comm) or mysql_crash($comm);
									$comm = "INSERT INTO jos_foglalas SET cim_id='".$_POST['cim_id']."', szoba_id='".$row[szoba_id]."', fdatum='".$honap.$ertek."', allapot=1";
									$resultal = mysql_query($comm) or mysql_crash($comm);
							}
					}
					if (is_array(${'szobadu'.$row[szoba_id]})) {
							foreach( ${'szobadu'.$row[szoba_id]} as $ertek ) {
									$honap = $kev.'-'.$khonap.'-';
									if ($ertek>31) {
											$honap = getnextdatum($kev, $khonap);
											$ertek = $ertek - 31;
									}
									$comm = "DELETE FROM jos_foglalas WHERE cim_id='".$_POST['cim_id']."' AND szoba_id='".$row[szoba_id]."' AND fdatum='".$honap.$ertek."' AND allapot=2";
									$resultal = mysql_query($comm) or mysql_crash($comm);
									$comm = "INSERT INTO jos_foglalas SET cim_id='".$_POST['cim_id']."', szoba_id='".$row[szoba_id]."', fdatum='".$honap.$ertek."', allapot=2";
									$resultal = mysql_query($comm) or mysql_crash($comm);
							}
					}
			}
		}



	}

	require("inc/head.php");

	if (count($bless)==0)	{
		if ($_POST) extract ($_POST, EXTR_OVERWRITE);



	$yesorno = array(0=>"nem",1=>"igen");
	$tipusA = array(1=>"2 fő",2=>"3 fő", 3=>"4 fő", 4=>"5 fő", 5=>"7 fő", 6=>"2+1 fő", 7=>"2+2 fő");


function makedayline() {
    global $kev, $khonap;
?>
	<tr>
		<td style="border: 1px solid #808070; background: #CFE6CF;">
			<strong>Szobák</strong>
		</td>
<?php
	$honap = $kev.'-'.$khonap.'-';
	for ($ii=1; $ii<=41; $ii++) {
		$i = $ii;

		if ($ii > 31) {
				 $honap = getnextdatum($kev, $khonap);
				 $i = $ii - 31;
		}

		if (!checkstrdate($honap.$i)) {
				continue;
		}

?>
		<td style="border: 1px solid #808070; background: #CFE6CF;">
			<strong><?=$i?></strong>
		</td>
		<?php
		if (issunday($honap.$i)) {
		?>
		<td style="border: 0px solid #808070; background: #CFE6CF;">
			<strong>&nbsp;</strong>
		</td>
		<?php
		}
}
?>
	</tr>
		<?php
}

?>


<div id="path">

<a href="#">Foglalás</a>
&nbsp;>&nbsp;
<a href="#">Szobatérkép</a>

</div>

<h2>Szobatérkép</h2>

<form method="post" action="">
		  <input type="hidden" name="cim_id" value="<?=$cim_id; ?>">
<table cellpadding="7" cellspacing="7" border="0" width="100%">
<?php
		$honap = $kev.'-'.$khonap.'-';
    if ($honap == '--') $honap = date("Y-m-");
		$kev = substr($honap, 0, 4);
    $khonap = substr($honap, 5, 2);
?>    <tr> 
      <td align="right">Év/hónap</td>
      <td> 
        <select name="kev" class="in22">
          <?php
      $cev = date("Y");
      if (empty($kev)) {
          $kev = $cev;
      }
      for ($i=2007; $i<$cev+5; $i++) {
          if ($kev == $i) {
            echo "<option selected>$i</option>";
          }
          else {
            echo "<option>$i</option>";              
          }
      }
    ?>
        </select>
        <?php
      if (empty($khonap)) {
          $khonap=date("m");
      }
    ?>
        <select name="khonap" class="in2">
          <option value="01" <? if ($khonap=='01') { echo "selected"; } ?> >január</option>
          <option value="02" <? if ($khonap=='02') { echo "selected"; } ?> >február</option>
          <option value="03" <? if ($khonap=='03') { echo "selected"; } ?> >március</option>
          <option value="04" <? if ($khonap=='04') { echo "selected"; } ?> >április</option>
          <option value="05" <? if ($khonap=='05') { echo "selected"; } ?> >május</option>
          <option value="06" <? if ($khonap=='06') { echo "selected"; } ?> >jĂşnius</option>
          <option value="07" <? if ($khonap=='07') { echo "selected"; } ?> >jĂşlius</option>
          <option value="08" <? if ($khonap=='08') { echo "selected"; } ?> >augusztus</option>
          <option value="09" <? if ($khonap=='09') { echo "selected"; } ?> >szeptember</option>
          <option value="10" <? if ($khonap=='10') { echo "selected"; } ?> >oktĂłber</option>
          <option value="11" <? if ($khonap=='11') { echo "selected"; } ?> >november</option>
          <option value="12" <? if ($khonap=='12') { echo "selected"; } ?> >december</option>
        </select>
      </td>
    </tr>

<tr>
	<td align="right">Partner</td>
	<td>
		<select name="cim_id" class="in2">
			<option value="0">-- Válasszon egy partnert --</option>
	<?php
		$comm = "SELECT * FROM jos_cimjegyzek ORDER BY nev";
		$result2 = mysql_query($comm) or mysql_crash($comm);
		while ($row2=mysql_fetch_array($result2))		{
			if ($row2[cim_id] == $cim_id) $sel = "selected"; else $sel = '';
	?>
			<option value="<?=$row2[cim_id]?>" <?=$sel?>><?=$row2[nev]?></option>
	<?php
		}
	?>

		</select> &nbsp; <input type="submit" value="   OK   " class="in3">
	</td>
	</tr>
</table>

<p>&nbsp;</p>
<table cellpadding="5" cellspacing="0" border="0" align="center" style="background: #EEEEEE; text-align: left; vertical-align: middle; color: #404030; font-weight: bold;">
	<tr>
		<td style="border: 1px solid #808070; background: #CFE6CF;">
			<strong>Szobák</strong>
		</td>
<?php
	$honap = $kev.'-'.$khonap.'-';
	for ($ii=1; $ii<=41; $ii++) {
		$i = $ii;

		if ($ii > 31) {
				 $honap = getnextdatum($kev, $khonap);
				 $i = $ii - 31;
		}

		if (!checkstrdate($honap.$i)) {
				continue;
		}
?>
		<td style="border: 1px solid #808070; background: #CFE6CF;">
			<strong><?=$i?></strong>
		</td>
		<?php
		if (issunday($honap.$i)) {
		?>
		<td style="border: 0px solid #808070; background: #CFE6CF;">
			<strong>&nbsp;</strong>
		</td>
		<?php
		}
		?>
<?php
}
?>
	</tr>

	<?php

		$comm = "SELECT * FROM jos_szobak ORDER BY emelet, megnev";
		$result = mysql_query($comm) or mysql_crash($comm);
    	$countszoba = 0;
		while ($row=mysql_fetch_array($result))		{
        $countszoba++;
	?>
	<tr>
		<td style="border: 1px solid #808070; width: 200px; font-size: 70%">
			<strong><?= $row['megnev']; ?></strong><br>(<?=$tipusA[$row[tipus]]?>)
		</td>
				<?php
				$honap = $kev.'-'.$khonap.'-';
				for ($ii=1; $ii<=41; $ii++) {
						$i = $ii;

						if ($ii > 31) {
								 $honap = getnextdatum($kev, $khonap);
								 $i = $ii - 31;
						}

						if (!checkstrdate($honap.$i)) {
								continue;
						}

						$comm = "SELECT * FROM jos_foglalas WHERE allapot=1 AND fdatum='$honap$i' AND szoba_id=".$row[szoba_id];
						$resultal = mysql_query($comm) or mysql_crash($comm);
						if (mysql_num_rows($resultal)) $szin = 'red'; else $szin = 'green';
				?>
		<td style="border: 1px solid #FFFF99; width: 200px; font-size: 70%">
		<table cellpadding="1" cellspacing="0" border="0" align="center" style="background: #EEEEEE; text-align: left; vertical-align: middle; color: #404030; font-weight: bold;">
		<tr>
		<td style="border: 0px solid #FFFF99; width: 16px; height: 18px; background-color:<?=$szin?>; text-align: center;">
					<?php if ($szin == 'green') {		?>
						<input type="checkbox" name="szobade<?= $row['szoba_id']; ?>[]" value="<?=$ii?>"><br>
						<?php } else { ?>
							&nbsp;&nbsp;&nbsp;&nbsp;
					<?php }		?>
		</td>
		</tr>
		<tr>
				<?php
						$comm = "SELECT * FROM jos_foglalas WHERE allapot=2 AND fdatum='$honap$i' AND szoba_id=".$row[szoba_id];
						$resultal = mysql_query($comm) or mysql_crash($comm);
						if (mysql_num_rows($resultal)) $szin = 'red'; else $szin = 'green';
				?>
		<td style="border: 0px solid #FFFF99; width: 16px; height: 18px; background-color:<?=$szin?>; text-align: center;">
					<?php if ($szin == 'green') {		?>
						<input type="checkbox" name="szobadu<?= $row['szoba_id']; ?>[]" value="<?=$ii?>">
					<?php } else { ?>
							&nbsp;&nbsp;&nbsp;&nbsp;
					<?php }		?>
		</td>
		</tr>
		</table>
		</td>
		
								<?php
								if (issunday($honap.$i)) {
								?>
								<td style="border: 0px solid #808070; background: #FFFF99;">
								<strong></strong>
								</td>
								<?php
								}
								?>
				<?php
				}
				?>
	</tr>
<?php
        if ($countszoba % 5 == 0) makedayline();
		}
	?>
</table>
<table cellpadding="7" cellspacing="7" border="0" width="100%">
<tr>
	<td align="right">&nbsp;</td>
	<td>&nbsp;</td>
</tr>
<tr>
	<td align="right"></td>
	<td><input type="submit" value="   OK   " class="in3">&nbsp;<input type="reset" value="Alaphelyzet" class="in3"></td>
</tr>

</table>


</form>

<p>&nbsp;</p>
<p>&nbsp;</p>


<?php
	}
?>


<?php
	include("inc/end.php");
?>

<?php
	$mindex = 2;
if ($_GET[id]) 	$index = 9; else $index = 10;

	require_once("require.php");

	if ($_SERVER['REQUEST_METHOD']=="POST")
	{
		if (!$_POST['cim_id'])
		{

 			if (!$_POST['nev']) $crash[] = "HIÁNYZIK a partner MEGNEVEZÉSE!";

			if (count($crash)==0)
			{

				$comm = "INSERT jos_cimjegyzek SET nev='".$_POST['nev']."', cim='".$_POST['cim']."', tel='".$_POST['tel']."', email='".$_POST['email']."', megj='".$_POST['megj']."', allapot='".$_POST['allapot']."'   ";
				$result = mysql_query($comm) or mysql_crash($comm);

				if ($_POST['allapot'] == 3) {
						$comm = "INSERT newsletter_user SET azon='".getlastid('jos_cimjegyzek')."', nev='".$_POST['nev']."', email='".$_POST['email']."', allapot=1   ";
						$result = mysql_query($comm) or mysql_crash($comm);
				}

				$bless[] = "Az új cím sikeresen hozzáadva!";
			}
		}

		if ($_POST['cim_id'] && !$_POST['del'])
		{
 			if (!$_POST['nev']) $crash[] = "HIÁNYZIK a partner MEGNEVEZÉSE!";

			if (count($crash)==0)
			{
				$comm = "UPDATE jos_cimjegyzek SET nev='".$_POST['nev']."', cim='".$_POST['cim']."', tel='".$_POST['tel']."', email='".$_POST['email']."', megj='".$_POST['megj']."', allapot='".$_POST['allapot']."'   WHERE cim_id='".$_POST['cim_id']."'";
				$result = mysql_query($comm) or mysql_crash($comm);

				$bless[] = "A cĂ­m sikeresen mĂłdosĂ­tva!";

				if ($_POST['allapot'] != 3) {
						$comm = "DELETE FROM newsletter_user WHERE azon='".$_POST['cim_id']."' ";
						$result = mysql_query($comm) or mysql_crash($comm);
				} else {
						$comm = "DELETE FROM newsletter_user WHERE azon='".$_POST['cim_id']."' ";
						$result = mysql_query($comm) or mysql_crash($comm);
						$comm = "INSERT newsletter_user SET  nev='".$_POST['nev']."', email='".$_POST['email']."', allapot=1, azon='".$_POST['cim_id']."' ";
						$result = mysql_query($comm) or mysql_crash($comm);
				}

			

			}
		}

		if ($_POST['cim_id'] && $_POST['del'])
		{
			$comm = "DELETE FROM jos_cimjegyzek WHERE cim_id='".$_POST['cim_id']."'";
			$result = mysql_query($comm) or mysql_crash($comm);

			$comm = "DELETE FROM newsletter_user WHERE azon='".$_POST['cim_id']."' ";
			$result = mysql_query($comm) or mysql_crash($comm);

			$comm = "DELETE FROM jos_foglalas WHERE cim_id=".$_POST['cim_id'];
			$result = mysql_query($comm) or mysql_crash($comm);


			
			$bless[] = "Cím sikeresen törőlve!";
		}

	}

	require("inc/head.php");

	if (count($bless)==0)	{
		if ($_GET['id'])
		{
			$comm = "SELECT * FROM jos_cimjegyzek WHERE cim_id='".$_GET['id']."'";
			$result = mysql_query($comm) or mysql_crash($comm);
			$row = mysql_fetch_array($result);
			extract ($row, EXTR_OVERWRITE);

		}
		elseif ($_POST) extract ($_POST, EXTR_OVERWRITE);


?>

<div id="path">

<a href="#">Foglalás</a>
&nbsp;>&nbsp;
<a href="#">CĂ­m bevitele</a>

</div>

<h2>Címlista kezelése</h2>

<?php if ($_GET[id]) { ?>
<h3>Cím szerkesztése</h3>
<?php } else { ?>
<h3>Ăšj cĂ­m bevitele</h3>
<?php } ?>

<form method="post" action="">
		  <input type="hidden" name="cim_id" value="<?=$cim_id; ?>">
<table cellpadding="7" cellspacing="7" border="0" width="100%">
<tr>
	<td align="right">Partner neve</td>
	<td><input type="text" name="nev" class="in2" value="<?= $nev; ?>"></td>
</tr>
<tr>
	<td align="right">CĂ­me</td>
	<td><input type="text" name="cim" class="in2" value="<?= $cim; ?>"></td>
</tr>
<tr>
	<td align="right">Tel</td>
	<td><input type="text" name="tel" class="in2" value="<?= $tel; ?>"></td>
</tr>
<tr>
	<td align="right">E-mail</td>
	<td><input type="text" name="email" class="in2" value="<?= $email; ?>"></td>
</tr>
<tr>
	<td align="right" valign="top">Megjegyzés</td>
	<td><textarea name="megj" class="in2" style="width: 400px; height: 200px"><?= $megj; ?></textarea>
	</td>
</tr>

<tr>
	<td align="right">&nbsp;</td>
	<td>&nbsp;</td>
</tr>
	<? if ($_GET['id']) { ?>
	<tr>
		<td align="right">
			<i>Törlés</i>
		</td>
		<td>
			<input type="checkbox" name="del" value="1" onClick="if(!confirm('Biztos?')) {  this.checked = !this.checked; }">
		</td>
	</tr>
	<? } ?>
<tr>
	<td align="right">Állapot</td>
	<td>
		<select name="allapot" class="in2">
			<option value="1" <? if ($allapot==1) echo "selected"; ?>>Engedélyezett</option>
			<option value="3" <? if ($allapot==3) echo "selected"; ?>>Hírlevél </option>
			<option value="2" <? if ($allapot==2) echo "selected"; ?>>Tiltott </option>

		</select>
	</td>
</tr>

<tr>
	<td align="right">&nbsp;</td>
	<td>&nbsp;</td>
</tr>
<tr>
	<td align="right"></td>
	<td><input type="submit" value="Mentés" class="in3">&nbsp;<input type="reset" value="Alaphelyzet" class="in3"></td>
</tr>

</table>
	<p>&nbsp;</p>
		<p>&nbsp;</p>
</form>

<?php
	}
?>


<?php
include("inc/end.php");
?>