GMWeb/www-admin/lablanca/calculate.php

<?php
	$http_host = $_SERVER['HTTP_HOST'];
	$server = "https://$http_host";
	$default_host = substr($http_host, 0, strpos($http_host, ':'));
	include("../functions.php");
	$con = startdb();
	if (!checkSession($con)){
		exit (-1);
	}
	else{
		//Get year
		$year = date("Y");

		//Get data to calculate
		$section = mysqli_real_escape_string($con, $_GET['section']);

		switch ($section){

			//Calculate header section. Only the progress window is requires
			case 'header':
				echo "<h4>Paso 1: Cabecera de la p&aacute;gina de fiestas</h4>\n";
// 				echo "<div class='entry status' id='status_header'>\n";
				echo "Estado:\n";
				$q = mysqli_query($con, "SELECT * FROM festival WHERE year = $year;");
				if (mysqli_num_rows($q) == 0){
					echo "<span class='status_red'> No se ha definido una cabecera</span>\n";
				}
				else{
					$r = mysqli_fetch_array($q);
					echo "<ul><li>Texto castellano: <span class='status_green'>OK</span></li>\n<li>Traducci&oacute;n ingl&eacute;s: ";
					if ($r['text_en'] == $r['text_es'] || strlen($r['text_en']) == 0){
						echo "<span class='status_yellow'>NO</span>\n";
					}
					else{
						echo "<span class='status_green'>OK</span>\n";
					}
					echo "</li>\n<li>Traducci&oacute;n euskera: ";
					if ($r['text_eu'] == $r['text_es'] || strlen($r['text_eu']) == 0){
						echo "<span class='status_yellow'>NO</span>\n";
					}
					else{
						echo "<span class='status_green'>OK</span>\n";
					}
					echo "</li>\n<li>Cartel: ";
					if (strlen($r['img']) == 0){
						echo "<span class='status_yellow'>NO</span>\n";
					}
					else{
						echo "<span class='status_green'>OK</span>\n";
					}
					echo "</li></ul>\n";
				}
				break;
				
			//Calculate prices progress section.
			case 'pricesprogress':
				echo "Estado:<ul><li>\n";
				$q = mysqli_query($con, "SELECT * FROM festival_day WHERE year(date) = '$year' AND price > 0;");
				if (mysqli_num_rows($q) != 6){
					echo "<span class='status_red'> No se han establecido precios</span>\n";
				}
				else{
					echo "Precios establecidos: <span class='status_green'>OK</span>\n";
				}
				echo "</li><li>\n";
				$prices_wrong = 0;
				while ($r = mysqli_fetch_array($q)){
					if ($r['price'] <= 0 || $r['price'] > 200){
						$prices_wrong ++;
					}
				}
				if ($prices_wrong == 0){
					echo "Precios v&aacute;lidos: <span class='status_green'>" . (6 - $prices_wrong) . "/6</span>\n";
				}
				else{
					echo "Precios v&aacute;lidos: <span class='status_red'>" . (6 - $prices_wrong) . "/6</span>\n";
				}
				echo "</li><li>\n";
				$q = mysqli_query($con, "SELECT id FROM festival_offer WHERE year = $year AND price > 0;");
				if (mysqli_num_rows($q) > 0){
					echo "N&uacute;mero de ofertas: <span class='status_green'>" . mysqli_num_rows($q) . "</span>\n";
				}
				else{
					echo "N&uacute;mero de ofertas: <span class='status_yellow'>" . mysqli_num_rows($q) . "</span>\n";
				}
				echo "</li></ul>\n";
				break;
		
			//Calculate offers window
			case 'pricesoffers':
				echo "<h4>Ofertas:</h4>\n";
				$q_offer = mysqli_query($con, "SELECT * FROM festival_offer WHERE year = $year");
				if (mysqli_num_rows($q_offer) == 0){
					echo "No se han configurado ofertas<br/>\n";
				}
				else{
					echo "<table id='offers'><tr>";
					echo "<th>Castellano</th><th>Ingl&eacute;s</th><th>Euskera</th>";
					echo "<th>D&iacute;as</th><th>Precio</th><th>Acci&oacute;n</th></tr>\n";
					while ($r_offer = mysqli_fetch_array($q_offer)){
						if ($r_offer['name_en'] == $r_offer['name_es']){
							$en = '';
						}
						else{
							$en = $r_offer['name_en'];
						}
						if ($r_offer['name_eu'] == $r_offer['name_es']){
							$eu = '';
						}
						else{
							$eu = $r_offer['name_eu'];
						}
						if ($r_offer['description_en'] == $r_offer['description_es']){
							$den = '';
						}
						else{
							$den = $r_offer['description_en'];
						}
						if ($r_offer['description_eu'] == $r_offer['description_es']){
							$deu = '';
						}
						else{
							$deu = $r_offer['description_eu'];
						}
						echo "<tr><td class='large'><input type='text' value='$r_offer[name_es]' onchange='updateField(\"festival_offer\", \"name_es\", this.value, $r_offer[id], \"text\", false);'/><br/>\n";
						echo "<textarea onchange='updateField(\"festival_offer\", \"description_es\", this.value, $r_offer[id], \"text\", false);'>$r_offer[description_es]</textarea></td>\n"; //TODO onchange
						echo "<td class='large'><input type='text' value='$en' onchange='updateField(\"festival_offer\", \"name_en\", this.value, $r_offer[id]);'/><br/>\n";
						echo "<textarea onchange='updateField(\"festival_offer\", \"description_en\", this.value, $r_offer[id]);'>$den</textarea></td>\n";
						echo "<td class='large'><input type='text' value='$eu' onchange='updateField(\"festival_offer\", \"name_eu\", this.value, $r_offer[id]);'/><br/>\n";
						echo "<textarea onchange='updateField(\"festival_offer\", \"description_eu\", this.value, $r_offer[id]);'>$deu</textarea></td>\n";
						echo "<td class='small'><input type='number' value='$r_offer[days]' onchange='updateField(\"festival_offer\", \"days\", this.value, $r_offer[id], \"number\", false);'/></td>\n";
						echo "<td class='small'><input type='number' value='$r_offer[price]' onchange='updateField(\"festival_offer\", \"price\", this.value, $r_offer[id], \"number\", false);'/>&euro;</td>\n";
						echo "<td class='small'><input type='button' value='Eliminar' onClick='if(confirm(\"Borrar oferta $r_offer[name_es]?\"))deleteOffer($r_offer[id]);'/></td></tr>"; //TODO onclick
					}
					echo "</table>\n";
				}
				echo "<input type='button' value='A&ntilde;adir nuevo' onClick='newOffer();'/>\n";
				break;
      case 'schedule':
        echo("<table>\n");
        $q_day = mysqli_query($con, "SELECT DISTINCT date(date_sub(start, INTERVAL 6 HOUR)) AS day FROM festival_event WHERE gm = 1 AND year(start) = $year;");
        while ($r_day = mysqli_fetch_array($q_day)){
          $q = mysqli_query($con, "SELECT festival_event.id AS id, title_es, title_en, title_eu, description_es, description_en, description_eu, start, end, place, place.name_es AS placename, place.address_es AS address FROM festival_event, place WHERE place = place.id AND date(date_sub(start, INTERVAL 6 HOUR)) = str_to_date('$r_day[day]', '%Y-%m-%d') AND gm = 1");
					while ($r = mysqli_fetch_array($q)){
						$id = $r['id'];
						$title_es = $r['title_es'];
						$title_en = $r['title_en'];
						if ($title_en == $title_es){
							$title_en = "";
						}
						$title_eu = $r['title_eu'];
						if ($title_eu == $title_es){
							$title_eu = "";
						}
						$description_es = $r['description_es'];
						$description_en = $r['description_en'];
						if ($description_en == $description_es){
							$description_en = "";
						}
						$description_eu = $r['description_eu'];
						if ($description_eu == $description_es){
              $description_eu = "";
            }
						$placeid = $r['place'];
						$place = $r['placename'];
						$address = $r['address'];
						$month = substr($r_day['day'], 5, 2);
						$day = substr($r_day['day'], 8, 2);
						$start_h = substr($r['start'], 11, 2);
						$start_m = substr($r['start'], 14, 2);
						$end = $r['end'];
						$end_h = "";
						$end_m = "";
						if (strlen($end) > 0){
							$end_h = substr($r['start'], 11, 2);
							$end_m = substr($r['start'], 14, 2);
						}
?>
						<tr>
							<td>
								<input type="text" value="<?=$day?>" placeholder="d" class="short"/> de 
								<select>
									<option value="07"
<?php
										if ($month == "07"){
											echo("selected");
										}
?>
									>julio</option>
									<option value="08"
<?php
										if ($month == "08"){
											echo("selected");
										}
?>
									>agosto</option>
								</select><br/>
								Empieza:
								<input type="text" placeholder="HH" value="<?=$start_h?>" class="short"/>:<input type="text" placeholder="MM" value="<?=$start_m?>" class="short"/><br/>
								Termina:
								<input type="text" placeholder="HH" value="<?=$end_h?>" class="short" class="short"/>:<input type="text" placeholder="MM" value="<?=$end_m?>" class="short"/>
							</td>
							<td class="name">
								Nombre:<br/>
								<input type="text" value="<?=$title_es?>" placeholder="Castellano"/><br/>
								<input type="text" value="<?=$title_en?>" placeholder="Ingl&eacute;s"/><br/>
								<input type="text" value="<?=$title_eu?>" placeholder="Euskera"/>
							</td>
							<td class="description">
								Description:<br/>
            	  <input type="text" value="<?=$description_es?>" placeholder="Castellano"/><br/>
	              <input type="text" value="<?=$description_en?>" placeholder="Ingl&eacute;s"/><br/>
  	            <input type="text" value="<?=$description_eu?>" placeholder="Euskera"/>
    	        </td>
							<td class="details">
								Lugar:<br/>
								<select>
									<option value='-2'>SELECCIONA...</option>
									<option value='-1'>A&Ntilde;ADIR NUEVO...</option>
<?php
										$q_p = mysqli_query($con, "SELECT * FROM place;");
										while ($r_p = mysqli_fetch_array($q_p)){
											if ($r_p['id'] == $placeid){
												echo("<option value='$r_p[id]' selected='selected'>$r_p[name_es] ($r_p[address_es])</option>\n");
											}
											else{
												echo("<option value='$r_p[id]'>$r_p[name_es] ($r_p[address_es])</option>\n");
											}
										}
?>
								</select><hr/>
								<input type="button" value="Borrar evento"/>
							</td>
						</tr>
<?php
					}
        }
				echo("</table>\n");
				break;
		}
	}
?>