source: trunk/index.php@ 3

<?php

include_once('Database.php');
include_once('Config.php');
include_once('Meet.php');

session_start();

function HumanDate($Time)
{
  return(date('j.n.Y', $Time));
}
 
class Application
{
  function Link($URL)
  {
    if(substr($URL, 0, 1) == '/') return($this->Config['BaseURL'].substr($URL, 1));
      else return($URL);
  }

  function Run()
  {

  }
}

class MyApplication extends Application
{
  var $Database;
  var $Config;

  function __construct()
  {
  }

  function ShowMenu()
  {
    $Output = '<div>'.
      '<a href="'.$this->Link('/tance/').'">Tance</a> '.
      '<a href="'.$this->Link('/skoly/').'">Školy</a> '.
      '<a href="'.$this->Link('/seznamka/').'">Seznamka</a> '.
      '</div>';
    return($Output);
  }

  function ProcessURL()
  {
    if(array_key_exists('REDIRECT_QUERY_STRING', $_SERVER))
      $PathString = $_SERVER['REDIRECT_QUERY_STRING'];
    else $PathString = '';
    if(substr($PathString, -1, 1) == '/') $PathString = substr($PathString, 0, -1);
    $PathItems = explode('/', $PathString);
    if(array_key_exists('REQUEST_URI', $_SERVER) and (strpos($_SERVER['REQUEST_URI'], '?') !== false))
      $_SERVER['QUERY_STRING'] = substr($_SERVER['REQUEST_URI'], strpos($_SERVER['REQUEST_URI'], '?') + 1);
    else $_SERVER['QUERY_STRING'] = '';
    parse_str($_SERVER['QUERY_STRING'], $_GET);
    return($PathItems);
  }

  function ShowDanceList()
  {
    $Output = '<h4 style="text-align: center;">Tance:</h4>';
    $Output .= '<table class="WideTable">';
    $Output .= '<tr><th>Název</th><th>Skupina</th>';
    $DbResult2 = $this->Database->select('ResourceGroup', '*');
    while($ResourceGroup = $DbResult2->fetch_assoc())
    {
      $Output .= '<th>'.$ResourceGroup['Name'].'</th>';
    }
    $Output .= '</tr>';
    $DbResult = $this->Database->select('Dance', '*, (SELECT Name FROM DanceGroup WHERE DanceGroup.Id=Dance.Group) AS GroupName', '1 ORDER BY `Name`');
    while($Dance = $DbResult->fetch_assoc())
    {
      $Output .= '<tr><td>'.$Dance['Name'].'</th><td>'.$Dance['GroupName'].'</td>';
      $DbResult2 = $this->Database->select('ResourceGroup', '*');
      while($ResourceGroup = $DbResult2->fetch_assoc())
      {
        $Output .= '<td>';
        $DbResult3 = $this->Database->select('Resource', '*', '(`Dance`='.$Dance['Id'].') AND (`Group`='.$ResourceGroup['Id'].')');
        while($Resource = $DbResult3->fetch_assoc())
        {
          $Output .= '<a href="'.$Resource['URL'].'">'.$Resource['Name'].'</a> ';
        }
        $Output .= '</td>';
      }
      $Output .= '</tr>';
    }
    $Output .= '</table>';

    return($Output);
  }

  function ShowSchoolList()
  {
    $Output = '<h4 style="text-align: center;">Taneční školy:</h4>';
    $Output .= '<table class="WideTable">';
    $Output .= '<tr><th>Název</th><th>Adresa</th>';
    $Output .= '</tr>';
    $DbResult = $this->Database->select('School', '*', '1 ORDER BY `Name`');
    while($School = $DbResult->fetch_assoc())
    {
      $Output .= '<tr><td><a href="'.$this->Link($School['URL']).'">'.$School['Name'].'</a></th><td>'.$School['Address'].'</td>';
      $Output .= '</tr>';
    }
    $Output .= '</table>';

    return($Output);
  }

  function ShowMeetUpdate()
  {
    $MeetSources = new MeetSources();
    $MeetSources->Database = $this->Database;
    $MeetSources->ParseAll();
  }
  
  function ShowMeetList()
  {
    if (array_key_exists('lvm', $_GET) and ($_GET['lvm'] == 'seznam'))
    {
      $this->NoFullPage = true;
      if (array_key_exists('vekod', $_GET) ) $_SESSION['vekod'] = $_GET['vekod'];
      if (array_key_exists('vekdo', $_GET) ) $_SESSION['vekdo'] = $_GET['vekdo'];
      if (array_key_exists('vyskaod', $_GET) ) $_SESSION['vyskaod'] = $_GET['vyskaod'];
      if (array_key_exists('vyskado', $_GET) ) $_SESSION['vyskado'] = $_GET['vyskado'];
    } else {
    $Output = '';
    $Output .= '<script>function reloadlist(){ $(\'#meetlist\').load(document.URL + \' #meetlist\');}'.
      ' var load_timer = 100;
   var ltimer = null;
   
   function checkOut(kc,obj){
      if(kc==13) $(obj).blur(); 
   }
   function initLTimer(tm){
      if(ltimer) clearTimeout(ltimer);
      ltimer = setTimeout("freloader()",tm);
   }
   function stopLTimer(){
      if(ltimer) clearTimeout(ltimer);
      ltimer = null;
   }
           
   var cf = {pohlavi:\'2\'};

   function setupc(key,val){
      //console.log(\'setup-control-\'+key+\' = \'+val);
      if(key==\'vekod\' || key==\'vekdo\' || key==\'vyskaod\' || key==\'vyskado\' || key==\'vahaod\' || key==\'vahado\') {
         var ccv = $(\'#\'+key).val();
         if(ccv!=val) $(\'#\'+key).val(val==0?\'\':val);
      }
   }

   function upf(key,val,lonreload){
      if(key!=\'first\') cf[\'first\']=0; else st();
      setupc(key,val);
      cf[key]=val;
      if(lonreload) initLTimer(1000); else initLTimer(100);
   }
   
   function freloader(){
      ltimer = null;
      var qp = jQuery.param( cf );
      $(\'#list_content\').html(\'\'); $(\'#list_loading\').show();
      $.get(\'\\seznamka?lvm=seznam&\'+qp,function(data){$(\'#list_loading\').hide();$(\'#list_content\').html(data);htip()})
   }'.
      '</script>';
    $Output .= '<div class="filter-num-box">'.
      '<div class="label-box">Věk</div>'.
      '<input value="" onkeyup="if(event.keyCode!=9) upf(\'vekod\',$(this).val(),(event.keyCode==13?0:1)); '.
      '" id="vekod" autocomplete="off" type="text">'.
      '<div class="label-box">-</div>'.
      '<input value="" onkeyup="'.
      'if(event.keyCode!=9) upf(\'vekdo\',$(this).val(),(event.keyCode==13?0:1));" '.
      'id="vekdo" autocomplete="off" type="text"><div class="label-box">let</div></div>'.
      '</div> '.
      '<div class="filter-num-box">'.
      '<div class="label-box">Výška</div>'.
      '<input value="" onkeyup="if(event.keyCode!=9) upf(\'vyskaod\',$(this).val(),(event.keyCode==13?0:1)); '.
      '" id="vyskaod" autocomplete="off" type="text">'.
      '<div class="label-box">-</div>'.
      '<input value="" onkeyup="'.
      'if(event.keyCode!=9) upf(\'vyskado\',$(this).val(),(event.keyCode==13?0:1));" '.
      'id="vyskado" autocomplete="off" type="text"><div class="label-box">cm</div></div>'.
      '</div>';
      $Output .= '<h4 style="text-align: center;">Inzeráty:</h4>';
    }
    
    $Gender = array('', 'Muž', 'Žena');
    $Output .= '<div id="list_content">'.
      '<table class="WideTable">';
    $Output .= '<tr>'.
      '<th>Datum</th>'.
      '<th>Jméno</th>'.
      '<th>Výška</th>'.
      '<th>Věk</th>'.
      '<th>Váha</th>'.
      //'<th>Email</th>'.
      //'<th>Telefon</th>'.
      '<th>Pohlaví</th>'.
      '<th>Zpráva</th>'.
      '<th>Zdroj</th>';
    $Output .= '</tr>';
    $Where = '';    
    if (array_key_exists('vekod', $_SESSION) and ($_SESSION['vekod'] != '')) $Where .= ' AND (Age >= '.$_SESSION['vekod'].')';
    if (array_key_exists('vekdo', $_SESSION) and ($_SESSION['vekdo'] != '')) $Where .= ' AND (Age <= '.$_SESSION['vekdo'].')';
    if (array_key_exists('vyskaod', $_SESSION) and ($_SESSION['vyskaod'] != '')) $Where .= ' AND (Height >= '.$_SESSION['vyskaod'].')';
    if (array_key_exists('vyskado', $_SESSION) and ($_SESSION['vyskado'] != '')) $Where .= ' AND (Height <= '.$_SESSION['vyskado'].')';
    if (substr($Where, 0, 4) == ' AND') $Where = substr($Where, 4);
    if ($Where == '') $Where = '1';
    $DbResult = $this->Database->select('MeetItem', '*, (SELECT MeetSource.Name FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceName, '.
      '(SELECT MeetSource.URL FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceURL', $Where.' ORDER BY `Date` DESC');
    while($MeetItem = $DbResult->fetch_assoc())
    {
      $Output .= '<tr>'.
        '<td>'.HumanDate(MysqlDateToTime($MeetItem['Date'])).'</td>'.
        '<td>'.$MeetItem['Name'].'</td>'.
        '<td>'.$MeetItem['Height'].'</td>'.
        '<td>'.$MeetItem['Age'].'</td>'.
        '<td>'.$MeetItem['Weight'].'</td>'.
        //'<td>'.$MeetItem['Email'].'</td>'.
        //'<td>'.$MeetItem['Phone'].'</td>'.
        '<td>'.$Gender[$MeetItem['Gender']].'</td>'.
        '<td>'.$MeetItem['Message'].'</td>'.
        '<td><a href="'.$this->Link($MeetItem['SourceURL']).'">'.$MeetItem['SourceName'].'</a></td>';      
      $Output .= '</tr>';
    }
    $Output .= '</table></div>';

    return($Output);
  }

  function ShowPage($Content)
  {
    $Output = '<?xml version="1.0" encoding="'.$this->Config['Encoding'].'"?>'."\n".
      '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">'.
      '<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="cs" lang="cs">'.
      '<head>'.
      '<link rel="stylesheet" href="'.$this->Link('/style.css').'" type="text/css" media="all" />'.
      '<meta http-equiv="content-type" content="application/xhtml+xml; charset='.$this->Config['Encoding'].'" />'.
      '<script src="jquery.js"></script>'.
      '<title>Tance</title>'.
      '</head><body>';
    $Output .= $Content;
    $Output .= '</body></html>';
    return($Output);
  }

  function Run()
  {
    global $Config;

    $this->Config = $Config;
    $this->Database = new Database();
    $this->Database->Connect($this->Config['Database']['Host'], $this->Config['Database']['User'],
      $this->Config['Database']['Password'], $this->Config['Database']['Database']);
    $this->Database->Prefix = $this->Config['Database']['Prefix'];
    $this->Database->charset($this->Config['Database']['Charset']);
    $this->PathItems = $this->ProcessURL();

    $Output = '';    

    if(count($this->PathItems) > 0) {
      if($this->PathItems[0] == 'skoly') $Output .= $this->ShowSchoolList();
      else if($this->PathItems[0] == 'tance') $Output .= $this->ShowDanceList();
      else if($this->PathItems[0] == 'seznamka') $Output .= $this->ShowMeetList();
      else if($this->PathItems[0] == 'seznamka-aktualizace') $Output .= $this->ShowMeetUpdate();
      else $Output .= $this->ShowDanceList();
    } else $Output .= $this->ShowDanceList();
    if (!$this->NoFullPage) {
      $Output = $this->ShowMenu().$Output;
      echo($this->ShowPage($Output));
    } else echo($Output);
  }
}

$Application = new MyApplication();
$Application->Run();