Files

• Back to main page
• ..
• CalendarSource.php
• Garage.php
• GarageSource.php
• HomeScreen.php
• Img.php
• NetPort.php
• Port.php
• Screen.php
• ScreenManager.php
• Shmu.php
• TestScreen.php
• Weather.php
• WeatherSource.php
• terminal.php

File source

<?php

class CalendarSource{

  function __construct(){

  }

  function getData($count = -1){
    $q = "SELECT * FROM calendar WHERE `date` >= CURDATE() ORDER BY `date` ASC" ;
    if($count > 0){
      $q.=" LIMIT ".intval($count);
    }
    $r = mysql_query($q);
    $o = Array();
    while(($row = mysql_fetch_assoc($r)) !== false){
      $o[] = $row;
    }
    return $o;
  }

  function getRelativeDate($date, $toDate = false){
    if(!$toDate) $toDate = strtotime(Date("Y-m-d"));
    $date = strtotime($date);
    $diff = ($date - $toDate) / 3600;
    if($diff >= 0){
      if($diff < 24){
        return "dnes";
      }else if($diff < 48){
        return "zajtra";
      }else if($diff < 72){
        return "pozajtra";
      }else if($diff < 168){
        return $this->getDayName($date);
      }
    }
    return Date("d.m.", $date);
  }

  function getDayName($date){
    $days = Array("nedeľa", "pondelok", "utorok", "streda", "štvrok", "piatok", "sobota");
    return $days[Date("w", $date)];
  }

  function add($date, $text){
    return mysql_query(sprintf("INSERT INTO calendar SET `date` = '%s', `text` = '%s' ",
      mysql_real_escape_string(Date("Y-m-d", strtotime($date))),
      mysql_real_escape_string($text)
    ));
  }

  function remove($id){
    return mysql_query(sprintf("DELETE FROM calendar WHERE `id` = %d LIMIT 1", $id));
  }

}