Sherlock.php

<?php
  include_once("int/fest.php");

  set_ShowYear();
  $Type = ($_REQUEST['t'] ?? 1);
  $Type = Sanitise($Type);


// var_dump($_REQUEST);

  if (strlen($Type) > 25) $Type = 1;


  include_once("int/ProgLib.php");
  include_once("int/DateTime.php");
  global $db,$YEAR,$PLANYEAR,$SHOWYEAR,$YEARDATA,$DayLongList,$Event_Types;

  if (is_numeric($Type)) {
    $Ett = $Type;
    $Type = $Event_Types[$Type]['SN'];
  } else {
    $Ett = -1;
    foreach($Event_Types as $eti=>$et) if ($et['SN'] == $Type) $Ett = $eti;
    if ($Ett < 0) $Ett = 1;
  }

  $ShowAll = 0;
  if (Access('Staff') && isset($_REQUEST['SHOWALL'])) $ShowAll = 1;

  $Vens = Get_Venues(1);

  $Extras = ['Music'=>' OR e.ListMusic=1 ', 'Dance'=>' OR e.ListDance=1 ', 'Comedy'=>' OR e.ListComedy=1 ', 'Workshop'=>' OR e.ListWorkshop=1',
    'Concert'=>' OR e.ListMusic=1', 'Session'=>' OR e.ListSession=1', 'Youth'=>' OR e.ListYouth=1', 'School' =>' OR e.IsSchools=1']; 
  // Need Dance Equiv

//  var_dump($Type);
//  var_dump($Event_Types);
  //  Need check if year < first
  $Types = $Event_Types[$Ett]['Plural'];

  $xtr = (isset($Extras[$Type]))? $Extras[$Type] : '';
  $Evs = array();
  $Complete = 0;
  $BackStop = 2018;

  if (($YEAR == $PLANYEAR) && ($ShowAll == 0)) {
    $restrict = "AND ( e.Public=1 OR (e.Type=t.ETypeNo AND t.State>1 AND e.Public<2 ))";
  } else {
    $restrict = "";
    $Complete = 4;
  }

  $MapFeat = 0;
  $Banner = 1;
  if ($Ett >= 0) {
    $qry = "SELECT DISTINCT e.* FROM Events e, EventTypes t WHERE e.Year='$YEAR' AND ( e.Type=$Ett $xtr ) AND ( e.SubEvent<1 OR e.ShowSubevent=1 ) AND e.Venue!=0 " .
                "$restrict ORDER BY e.Day, e.Start";
//    echo "$qry<p>";
    $ans = $db->query($qry);
    if ($ans) while ($e = $ans->fetch_assoc()) $Evs[] = $e;
    if (count($Evs) > 1) $Types = $Event_Types[$Ett]['Plural'];
    if (($YEAR == $PLANYEAR) && ($ShowAll==0)) $Complete = $Event_Types[$Ett]['State'];
    $BackStop = $Event_Types[$Ett]['FirstYear'];
    if ($Event_Types[$Ett]['Banner']) $Banner = $Event_Types[$Ett]['Banner'];
    if ($Event_Types[$Ett]['MapFeatNum']) $MapFeat = $Event_Types[$Ett]['MapFeatNum'];
  } else { // Handle other Sherlock calls
    switch ($Type) {
      case 'Family':
        $ans = $db->query("SELECT DISTINCT e.* FROM Events e, EventTypes t WHERE e.Year='$YEAR' AND e.Family=1 AND e.SubEvent<1 AND e.Venue!=0 " .
                "$restrict ORDER BY e.Day, e.Start");
        if ($ans) while ($e = $ans->fetch_assoc()) $Evs[] = $e;
        $Types = "Family Event";
        if (count($Evs) != 1) $Types .= "s";
        if ($YEAR == $PLANYEAR) $Complete = $YEARDATA[$Type . 'State'];
        $MapFeat = 7;
        break;
      case 'Special':
        $ans = $db->query("SELECT DISTINCT e.* FROM Events e, EventTypes t WHERE e.Year='$YEAR' AND e.Special=1 AND (e.SubEvent<1 OR e.LongEvent=1) AND e.Venue!=0 " .
                "$restrict ORDER BY e.Day, e.Start");
        if ($ans) while ($e = $ans->fetch_assoc()) $Evs[] = $e;
        $Types = "Special Event";
        if (count($Evs) != 1) $Types .= "s";
        if ($YEAR == $PLANYEAR) $Complete = $YEARDATA[$Type . 'State'];
        // No MapFeat yet
        break;
      default:
        break;
    }
  }


  dohead("Timetable: $Types" . ($ShowAll?' (even if not public)':''),[],$Banner);

  $yr = substr($YEAR,0,4);
  $Titles = array("", // Not used
                "Currently publicised $Types for $yr, there will be more", // Draft
                "Currently publicised $Types for $yr, there will be more", // Partial
                "Currently publicised $Types for $yr, there may be more", // Provisional
                "$Types for $YEAR", // Complete
                );

  $NotAllFree = 0;
  $DaysUsed = [];
  for ($i=-4;$i<10; $i++) $DaysUsed[$i] = 0;
  foreach($Evs as $e) {
    if ($e['Price1'] || $e['SpecPrice'] || $e['SeasonTicketOnly']) $NotAllFree = 1;
    $DaysUsed[$e['Day']] = 1;
  }
  $TotalDays = array_sum($DaysUsed);

  $Header = TnC("Sherlock_$Type");
  if (!empty($Header)) {
    echo $Header;
    echo "<p>";
  }
  if ($Evs && $Complete) {
    if ($Complete <4 || $YEAR!=$SHOWYEAR) echo "<h2>" . $Titles[$Complete] . "</h2>";

    if ($MapFeat>0) {
      include_once("int/MapLib.php");
      echo "<h3 class='DanceMap Fakelink' onclick=$('.DanceMap').toggle()>Show $Type Locations</h3>";
      echo "<h3 class='DanceMap FakeLink' onclick=$('.DanceMap').toggle() hidden>Hide $Type Locations</h3>";
      echo "<div class=DanceMap hidden><div id=MapWrap>";
      echo "<div id=DirPaneWrap><div id=DirPane><div id=DirPaneTop></div><div id=Directions></div></div></div>";
      echo "<div id=map></div></div>";
      Init_Map(-1,0,17,$MapFeat);
      echo "</div>";
    }


//var_dump($TotalDays,$DaysUsed);
    if ($TotalDays > 1) {
      echo "<p>Jump to: ";
      for ($i=-4;$i<10; $i++) {
        if (!$DaysUsed[$i]) continue;
        echo "<a href=#SkipTo" . ($i+10) . " class='DaySkipTo " . DayList($i) . "Tab'>" . $DayLongList[$i] . "</a> ";
      }
    }

    $Extra = TnC("Sherlock$Types");
    if ($Extra) echo $Extra;

    echo "<div class='FullWidth WhenTable'>";

    if ($NotAllFree == 0) echo "All $Types are " . Feature('FreeText','Free') . ".<p>";

    echo "Click on the event name for more information.<p>";


    foreach ($Evs as $i=>$E) {
      $eid = $E['EventId'];
      if (DayTable($E['Day'],$Types,($Complete>2?'':'(More to come)'),'',"style='min-width:801;' id=SkipTo" . ($E['Day']+10) )) {
        echo "<tr><td>When<td>What<td>Where<td>Description" . ($NotAllFree?"<td>Price\n":"\n");
      }

      echo "<tr>";
      echo "<td>";
        echo timecolon($E['Start']) . " to " . timecolon($E['End']);
      echo "<td><strong><a href=/int/EventShow?e=$eid>" . $E['SN'] . "</a></strong>";
      echo "<td>" . Venue_Parents($Vens,$E['Venue']) . "<a href=/int/VenueShow?v=" . $E['Venue'] . ">" . $Vens[$E['Venue']]['SN'] . "</a>";
      if ($E['BigEvent']) {
        $Others = Get_Other_Things_For($eid);
        foreach ($Others as $i=>$o) {
          if (($o['Type'] == 'Venue') && ($o['Identifier']>0)) {
            echo ", " . Venue_Parents($Vens,$E['Venue']) . "<a href=/int/VenueShow?v=" . $o['Identifier'] . ">" . $Vens[$o['Identifier']]['SN'] . "</a>";
          }
        }
      }
      echo "<td>";
      if ($E['Description']) echo $E['Description'] . "<p>";
        if ($E['AgeRange']) echo "<div class=SherlockAge>Aimed at ages: " . $E['AgeRange'] . "</div>";
        if ($E['BigEvent']) {
          echo Get_Other_Participants($Others,0,1,15,1, 'With: ',$E);
        } else {
          echo Get_Event_Participants($eid,0,1,15,1, 'With: ');
        }
      if ($NotAllFree) echo "<td>" . Price_Show($E,1);
      echo "\n";
    }
    echo "</table></div><p>";

  } else {
    echo "<h3>" . Feature('NoEventsPre','Sorry there are currently no announced') . " $Types" . Feature('NoEventsPost', 'please check back later') . "</h3>";
  }

  if ($YEAR > $BackStop) {
    echo "<h3>If you would like to see what we had last time: <a href=Sherlock?T=$Type&Y=" . ($YEAR-1) . "> $Types in " . ($YEAR-1) . "</h3></a>";
  }
  dotail();