GasteizkoMargolariak
/
GMWeb


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285
							<?php
    include("../functions.php");
    $con = startdb();
    if (!checkSession($con)){
        header("Location: /index.php");
        exit (-1);
    }
    else{
        $id = mysqli_real_escape_string($con, $_GET["m"]);
        $q = mysqli_query($con, "SELECT * FROM member WHERE id = $id;");
        if (mysqli_num_rows($q) == 0){
            header("Location: /miembros/");
            exit (-1);
        }
        else{
            $r = mysqli_fetch_array($q);
?>
<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>Miembros - Administracion</title>
        <!-- CSS files -->
        <link rel='stylesheet' type='text/css' href='/css/ui.css'/>
        <link rel='stylesheet' type='text/css' href='/css/miembros.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/miembros.css'/>
        <!-- Script files -->
        <script type='text/javascript' src='script.js'></script>
        <script type='text/javascript' src='/script/ui.js'></script>
    </head>
    <body style='text-align:center;'>
<?php
        include("../toolbar.php");
?>
        <div id='content'>
            <div class='section'>
                <h3><?=$r["name"]?> <span style='font-style:italic;'><?=$r["alias"]?></span><?=$r["lname"]?>></h3>
                <table id='member'>
                    <tr>
                        <td class='entry''>
                            <h3>Datos personales</h4>
                            <p>
                                <span style='font-weight:bold;'>Nombre: </span><?=$r["name"]?>
                            </p>
                            <p>
                                <span style='font-weight:bold;'>Primer apellido: </span><?=$r["lname"]?>
                            </p>
                            <p>
                                <span style='font-weight:bold;'>Segundo apellido: </span><?=$r["lname2"]?>
                            </p>
                            <p>
                                <span style='font-weight:bold;'>Alias: </span><?=$r["alias"]?>
                            </p>
                            <br/>
                            <p>
                                <span style='font-weight:bold;'>Fecha de nacimiento: </span>
<?php
                                $date = formatDate($r['bdate'], 'es');
                                $date = substr($date, 0, strlen($date) - 12);
                                $dStart = new DateTime($r['bdate']);
                                $dEnd  = new DateTime();
                                $dDiff = $dStart->diff($dEnd);
                                $age =  floor(($dDiff->days) / 365);
                                if ($age < 18)
                                    $date = "$date (<span style='color:#aa0000'>$age a&ntilde;os - Menor de edad</span>)";
                                else
                                    $date = "$date ($age a&ntilde;os)";
?>
                                <?=$date?>
                            </p>
                            <p>
                                <span style='font-weight:bold;'>DNI: </span>
                                <?=$r["dni"]?>
                            </p>
                            <p>
                                <span style='font-weight:bold;'>Direccion: </span>
                                <?=$r["address"]?>
                            </p>
                        </td>
                        <td class="entry">
                            <h3>En la cuadrilla</h3>
                            <p>
                                <span style="font-weight:bold;">Socio: </span>
                                #<?=$r["id"]?>
                            <p>
                                <span style="font-weight:bold;">Fecha de alta: </span>
<?php
                                $date = formatDate($r['jdate'], 'es');
                                $date = substr($date, 0, strlen($date) - 12);
?>
                                <?=$date?>
                            </p>
                            <p>
                                <span style="font-weight:bold;">Formulario: </span>
<?php
                                switch ($r['joined']){
                                    case 'origin':
?>
                                        Socio inicial
<?php
                                        break;
                                    case 'phone':
?>
                                        V&iacute;a m&oacute;vil
<?php
                                        break;
                                    case 'oldweb':
?>
                                        V&iacute;a web antigua
<?php
                                        break;
                                    case 'web':
?>
                                        V&iacute;a web
<?php
                                        break;
                                    default:
?>
                                        V&iacute;a hoja de inscripci&oacute;n
<?php
                                }
?>
                            </p>
                            <p>
                                <span style="font-weight:bold;">Junta directiva: </span>
<?php
                                if ($r['board'] == 1)}
?>
                                        S&iacute;
<?php
                                }
                                else{
?>
                                        No
<?php
                                }
?>
                            </p>
                        </td>
                    </tr>
                    <tr>
                        <td class="entry">
                            <h3>Actividades</h3>
                            <ul id="member_list_days">
<?php
                                $paid = 0;
                                $unpaid = 0;
                                $q_year = mysqli_query($con, "SELECT year(date) AS year FROM member_day, festival_day WHERE member_day.day = festival_day.id AND member = $r[id] GROUP BY year(date) ORDER BY year(date)");
                                while ($r_year = mysqli_fetch_array($q_year)){
?>
                                    <li>Fiestas <?=$r_year["year"]?>:
                                        <ul>
<?php
                                            $q_day = mysqli_query($con, "SELECT day(date) AS dat, price, paid FROM festival_day, member_day WHERE member_day.day = festival_day.id AND year(date) = $r_year[year] AND member = $r[id] ORDER BY date;");
                                            while ($r_day = mysqli_fetch_array($q_day)){
                                                if ($r_day['paid'] == 1){
?>
                                                    <li><?=$r_day["dat"]?></li>
<?php
                                                    $paid = $paid + intval($r_day['price']);
                                                }
                                                else{
?>
                                                    <li><?=$r_day["dat"]?> - <span style='color:#aa0000'>No pagado</span></li>
<?php
                                                    $unpaid = $unpaid + intval($r_day['price']);
                                                }
                                            }
?>
                                        </ul>
                                    </li>
<?php
                                }
?>
                            </ul>
                            <ul id="member_list_activities">
<?php
                                $q_activity = mysqli_query($con, "SELECT title_es, price, year(date) AS year, paid FROM member_activity, activity WHERE member = $r[id] AND activity = activity.id");
                                while ($r_activity = mysqli_fetch_array($q_activity)){
                                    if ($r_activity['paid'] == 1){
?>
                                            <li><?=$r_activity["title_es"]?> (<?=$r_activity["year"]?>)</li>
<?php
                                            $paid = $paid + intval($r_activity['price']);
                                        }
                                        else{
?>
                                            <li><?=$r_activity["title_es"]?> (<?=$r_activity["year"]?>) - <span style='color:#aa0000'>No pagado</span></li>
<?php
                                            $unpaid = $unpaid + intval($r_activity['price']);
                                        }
                                }
?>
                            </ul>
                            <div id="activity_count">
                                <hr/>
                                Dinero aportado: <?=$paid?> &euro;
<?php
                                if ($unpaid > 0){
?>
                                    <br/>
                                    <span style='color:#aa0000'>Debe: $unpaid &euro;</span>
<?php
                                }
?>+
                            </div>
                        </td>
                        <td class="entry">
                            <div>
                                <h3>Redes sociales</h3>
                                <ul>
<?php
                                    if ($r["facebook"] == null){
?>
                                        <li style='text-decoration: line-through;'>Facebook</li>
<?php
                                    }
                                    else{
?>
                                        <li><a href='<?=$r["facebook"]?>'>Facebook</a></li>
<?php
                                    }
                                    if ($r["twitter"] == null){
?>
                                        <li style='text-decoration: line-through;'>Twitter</li>
<?php
                                    }
                                    else{
?>
                                        <li><a href='<?=$r["twitter"]?>'>Twitter</a></li>
<?php
                                    }
                                    if ($r["googleplus"] == null){
?>
                                        <li style='text-decoration: line-through;'>Google+</li>
<?php
                                    }
                                    else{
?>
                                        <li><a href='<?=$r["googleplus"]?>'>Google+</a></li>
<?php
                                    }
?>
                                </ul>
                            </div>
                            <br/><br/><hr/><br/><br/>
                            <div>
                                <h3>Intolerancias alimenticias</h3>
                                <ul>
<?php
                                    $q_intolerance = mysqli_query($con, "SELECT element FROM intolerance WHERE member = $r[id];");
                                    if (mysqli_num_rows($q_intolerance) == 0){
?>
                                        <li>Ninguna</li>
<?php
                                    }
                                    else{
                                        while ($r_intolerance = mysqli_fetch_array($q_intolerance)){
?>
                                            <li><?=$r_intolerance["element"]?></li>
<?php
                                        }
                                    }
?>
                                </ul>
                            </div>
                        </td>
                    </tr>
                </table>
            </div>
            <br/><br/>
            <div class="section" id="member_action">
                <input type="button" value="Editar"/>
                <input type="button" value="Eliminar"/>
                <input type="button" value="Decargar"/>
            </div>
        </div>
    </body>

<?php
        }
    }
?>