GasteizkoMargolariak
/
GMWeb


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260
							<?php
    $http_host = $_SERVER['HTTP_HOST'];
    $default_host = substr($http_host, 0, strpos($http_host, ':'));
    include("../functions.php");
    $con = startdb();
    if (!checkSession($con)){
        header("Location: /index.php");
        exit (-1);
    }
    else{
    //Get year
    $year = date("Y");
?>
<html>
    <head>
        <meta content="text/html; charset=windows-1252" http-equiv="content-type"/>
        <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, minimum-scale=1">
        <title>Preparar las fiestas de <?php echo $year; ?> - Administracion</title>
        <!-- CSS files -->
        <link rel="stylesheet" type="text/css" href="/css/ui.css"/>
        <link rel="stylesheet" type="text/css" href="/css/lablanca.css"/>
        <!-- CSS for mobile version -->
        <link rel="stylesheet" type="text/css" media="(max-width : 990px)" href="/css/m/ui.css"/>
        <link rel="stylesheet" type="text/css" media="(max-width : 990px)" href="/css/m/lablanca.css"/>
        <!-- Script files -->
        <script type="text/javascript" src="script.js"></script>
        <script type="text/javascript" src="/script/ui.js"></script>
        <script src="../ckeditor/ckeditor.js"></script>
    </head>
    <body onLoad='calculate("all");'>
        <?php include('../toolbar.php'); ?>
        <div id='content'>
            <div class='section' id='section_header'>
                <h3 class='section_title'>Paso 1: Cabecera de la p&aacute;gina de fiestas</h3>
                <div class='entry status' id='status_header'>
                    ...calculando...
                </div>
                <div class='entry' id='entry_header'>
                    <div id="lang_tabs">
                        <table>
                                <tr>
                                    <td class="pointer lang_tabs_active" id="lang_tab_es" onclick="showLanguage('es');">
                                        Castellano
                                    </td>
                                    <td class="pointer" id="lang_tab_eu" onclick="showLanguage('eu');">
                                        Euskera
                                    </td>
                                    <td class="pointer" id="lang_tab_en" onclick="showLanguage('en');">
                                        Ingl&eacute;s
                                    </td>
                                </tr>
                        </table>
                    </div>
                    <div id="content_lang_es" class="festival_add_language">
                        <?php
                            $q = mysqli_query($con, "SELECT * FROM festival WHERE year = $year;");
                            $r = mysqli_fetch_array($q);
                            echo "<textarea id='text_es' onChange='updateField(\"festival\", \"text_es\", this.value, $r[id], \"text\", false);calculate(\"header\");'>$r[text_es]</textarea>\n";
                        ?>
                        <script>
                            CKEDITOR.replace('text_es');
                        </script>
                    </div>
                    <div id="content_lang_en" class="festival_add_language" style="display:none;">
                        <?php
                            echo "<textarea id='text_en' onChange='updateField(\"festival\", \"text_en\", this.value, $r[id]);calculate(\"header\");'>$r[text_en]</textarea>\n";
                        ?>
                        <script>
                            CKEDITOR.replace('text_en');
                        </script>
                    </div>
                    <div id="content_lang_eu" class="festival_add_language" style="display:none;">
                        <?php
                            echo "<textarea id='text_eu' onChange='updateField(\"festival\", \"text_eu\", this.value, $r[id]);calculate(\"header\");'>$r[text_eu]</textarea>\n";
                        ?>
                        <script>
                            CKEDITOR.replace('text_eu');
                        </script>
                    </div>
                    <div id='header_image'>
                        Cartel:<br/>
                        <?php
                            if (mysqli_num_rows($q) > 0){
                                if (strlen($r['img']) == 0){
                                    echo "<img id='header_img' src='/img/lablanca/header-null.png'/><br/>\n";
                                }
                                else{
                                    echo "<img id='header_img' src='http://$default_host/img/fiestas/miniature/$r[img]'/><br/>\n";
                                }
                            }
                            else{
                                echo "<img id='header_img' src='http://$default_host/img/fiestas/miniature/$r[img]'/><br/>\n";
                            }
                            echo "<input type='file' id='header_img_selector' onChange='uploadHeaderImage(event, $r[id]);calculate(\"header\");'/>\n";
                        ?>
                    </div>
                </div>
            </div>
            <br/><br/>
            <div class='section' id='section_prices'>
                <h3 class="section_title">Paso 2: Seleccionar precios:</h4>
                <div class='entry status' id='status_prices'>
                    ...calculando...
                </div>
                <div class='entry' id='entry_prices'>
                    <?php
                        $q = mysqli_query($con, "SELECT * FROM festival_day WHERE year(date) = '$year' AND price > 0;");
                        if (mysqli_num_rows($q) != 6){
                            echo "<input type='button' value='A&ntilde;adir precios'/>\n"; //TODO onclick
                            echo "<input type='button' value='Utilzar precios del a&ntilde;o pasado'/>\n"; //TODO onclick
                        }
                        else{
                            echo "<h4>D&iacute;as sueltos:</h4>";
                            echo "<table id='prices'><tr><th>Fecha</th>";
                            echo "<th>Nombres</th>";
                            echo "<th>Precio</th></tr>\n";
                            $dates = ["25 Jul", "5 Ago", "6 Ago", "7 Ago", "8 Ago", "9 Ago"];
                            $i = 0;
                            while ($r = mysqli_fetch_array($q)){
                                echo "<tr><td>" . $dates[$i];
                                if ($r['name_en'] == $r['name_es']){
                                    $en = '';
                                }
                                else{
                                    $en = $r['name_en'];
                                }
                                if ($r['name_eu'] == $r['name_es']){
                                    $eu = '';
                                }
                                else{
                                    $eu = $r['name_eu'];
                                }
                                echo "</td><td>\n";
                                echo("<table>\n");
                                echo("<tr><td>Castellano:</td><td><input type='text' value='$r[name_es]' onchange='updateField(\"festival_day\", \"name_es\", this.value, $r[id]);'/></td></tr>\n");
                                echo("<tr><td>Euskera:</td><td><input type='text' value='$r[name_en]' onchange='updateField(\"festival_day\", \"name_en\", this.value, $r[id]);'/></td></tr>\n");
                                echo("<tr><td>Ingl&eacute;s:</td><td><input type='text' value='$r[name_eu]' onchange='updateField(\"festival_day\", \"name_eu\", this.value, $r[id]);'/></td></tr>\n");
                                echo("</table>\n");
                                echo "</td>\n<td>\n<input type='number' value='$r[price]' onchange='updateField(\"festival_day\", \"price\", this.value, $r[id], \"number\", false);'/>&euro;</td></tr>";
                                $i = $i + 1;
                            }
                            echo "</table>\n";
                            echo "<div id='prices_offers'>\n";
                            echo "...calculando...\n";
                            echo "</div>\n";
                        }
                    ?>
                </div>
            </div>
            <br/><br/>
            <div class='section' id='section_schedule'>
                <h3 class='section_title'>Paso 3: Establecer programa:</h4>
                <div class='entry status' id='status_schedule'>
                    ...calculando...
                </div>
                <div class='entry entry_schedule' id='entry_schedule_25'>
                    <h3><img src='/img/misc/slid-right.png' onClick='expandSchedule(25);'/>25 de julio</h4>
                    <div id='list_schedule_25' class='list_schedule'>
                    </div>
                    Nuevo:
                    <table class='new_event'>
                        <tr class='title'>
                            <th>Castellano</th>
                            <th>Euskera</th>
                            <th>Ingl&eacute;s</th>
                        </tr>
                        <tr>
                            <td>
                                <input type='text' id='new_event_25_name_es' placeholder='Nombre'/><br/>
                                <textarea id='new_event_25_description_es' placeholder='Descripcion'></textarea>
                            </td>
                            <td>
                                <input type='text' id='new_event_25_name_en' placeholder='Nombre'/><br/>
                                <textarea id='new_event_25_description_en' placeholder='Descripcion'></textarea>
                            </td>
                            <td>
                                <input type='text' id='new_event_25_name_eu' placeholder='Nombre'/><br/>
                                <textarea id='new_event_25_description_eu' placeholder='Descripcion'></textarea>
                            </td>
                        </tr>
                        <tr class='title'>
                            <th>Inicio - Fin</th>
                            <th>Organiza</th>
                            <th>Lugar</th>
                        </tr>
                        <tr>
                            <td>
                                <input type='number' value='00' id='new_event_25_start_h'/>:
                                <input type='number' value='00' id='new_event_25_start_m'/> --
                                <input type='number' id='new_event_25_end_h'/>:
                                <input type='number' id='new_event_25_end_m'/>
                            </td>
                            <td>
                                <select id='new_event_25_host' class='new_event_host'>
                                    <option value='-2' selected='selected'>SELECCIONA...</option>
                                    <option value='-1'>A&Ntilde;ADIR NUEVO...</option>
                                    <?php
                                        $q = mysqli_query($con, "SELECT * FROM people;");
                                        while ($r = mysqli_fetch_array($q)){
                                            echo "<option value='$r[id]'>$r[name_es]</option>\n";
                                        }
                                    ?>
                                </select>
                            </td>
                            <td>
                                <select id='new_event_25_host' class='new_event_host'>
                                    <option value='-2' selected='selected'>SELECCIONA...</option>
                                    <option value='-1'>A&Ntilde;ADIR NUEVO...</option>
                                    <?php
                                        $q = mysqli_query($con, "SELECT * FROM place;");
                                        while ($r = mysqli_fetch_array($q)){
                                            echo "<option value='$r[id]'>$r[name_es] ($r[address_es])</option>\n";
                                        }
                                    ?>
                                </select>
                            </td>
                        </tr>
                    </table>
                </div>
            </div>
            <br/><br/>
        </div>
        <div id='screen_cover'></div>
        <div id='form_new_offer' class='section'>
            <h3>A&ntilde;adir oferta</h3>
            <div class='entry'>
                <table>
                    <tr>
                        <th>Castellano</th><th>Ingl&eacute;s</th><th>Euskera</th><th>D&iacute;as</th><th>Precio</th>
                    </tr>
                    <tr>
                        <td>
                            <input type='text' id='new_offer_title_es'/><br/>
                            <textarea id='new_offer_text_es'></textarea>
                        </td>
                        <td class='large'>
                            <input type='text' id='new_offer_title_en'/><br/>
                            <textarea id='new_offer_text_en'></textarea>
                        </td>
                        <td/>
                            <input type='text' id='new_offer_title_eu'/><br/>
                            <textarea id='new_offer_text_eu'></textarea>
                        </td>
                        <td class='small'>
                            <input type='number' value='1'  id='new_offer_days'/>
                        </td>
                        <td class='small'>
                            <input type='number' value='0'  id='new_offer_price'/>&euro;
                        </td>
                    </tr>
                </table>
                <div id='controls'>
                    <input type='button' value='Guardar' onClick='saveNewOffer(<?php echo $year;?>);'/>
                    <input type='button' value='Cancelar' onClick='cancelNewOffer();'/>
                </div>
            </div>
        </div>
    </body>
</html>
<?php } ?>