CMS Made Simple Forums

Code: Select all

{cms_module module=Holidays limit=4 detailpage=home}

Code: Select all

<?php

class Holidays extends CMSModule
{
 const MANAGE_PERM = 'manage_holidays';
 public function GetVersion() { return '0.1'; }
 public function GetFriendlyName() { return $this->Lang('friendlyname'); }
 public function GetAdminDescription() { return $this->Lang('admindescription'); }
 public function IsPluginModule() { return TRUE; }
 public function HasAdmin() { return TRUE; }
 public function VisibleToAdminUser() { return $this->CheckPermission(self::MANAGE_PERM); }
 public function GetAuthor() { return 'Paul'; }
 public function GetAuthorEmail() { return 'asdf@asdf.com'; }
 public function UninstallPreMessage() { return $this->Lang('ask_uninstall'); }

    public function InitializeFrontend() {
        $this->SetParameterType('hid',CLEAN_INT);
        $this->SetParameterType('pagelimit',CLEAN_INT);
        $this->SetParameterType('detailpage',CLEAN_STRING);
    }
    public function InitializeAdmin() {
        $this->CreateParameter('hid',null,$this->Lang('param_hid'));
        $this->CreateParameter('pagelimit',1000,$this->Lang('param_pagelimit'));
        $this->CreateParameter('detailpage',null,$this->Lang('param_detailpage'));
    }

}
?>

Code: Select all

<?php
if( !defined('CMS_VERSION') ) exit;
$limit = (isset($params['limit'])) ? (int) $params['limit'] : 1000;
$limit = max(1,$limit);
$detailpage = $returnid;
if( isset($params['detailpage']) ) {
    $hm = CmsApp::get_instance()->GetHierarchyManager();
    $node = $hm->sureGetNodeByAlias($params['detailpage']);
    if( is_object($node) ) $detailpage = $node->get_tag('id');
}
$query = new HolidayQuery(array('published'=>1,'limit'=>$limit));
$holidays = $query->GetMatches();
$tpl = $smarty->CreateTemplate($this->GetTemplateResource('default.tpl'),null,null,$smarty);
$tpl->assign('holidays',$holidays);
$tpl->assign('detailpage',$detailpage);
$tpl->display();
?>

Code: Select all

<?php
class HolidayQuery extends CmsDbQueryBase
{
public function execute()
{
    if( !is_null($this->_rs) ) return;
    $sql = 'SELECT SQL_CALC_FOUND_ROWS H.* FROM '.CMS_DB_PREFIX.'mod_holidays H';
    if( isset($this->_args['published']) ) {
        // store only draft or published items
        $tmp = $this->_args['published'];
        if( $tmp === 0 ) {
            $sql .= ' WHERE published = 0';
        } else if( $tmp === 1 ) {
            $sql .= ' WHERE published = 1';
        }
    }
    $sql .= ' ORDER BY the_date DESC';
    $db = \cms_utils::get_db();
    $this->_rs = $db->SelectLimit($sql,$this->_limit,$this->_offset);
    IF( $db->ErrorMsg() ) throw new \CmsSQLErrorException($db->sql.' -- '.$db->ErrorMsg());
    $this->_totalmatchingrows = $db->GetOne('SELECT FOUND_ROWS()');
}
    
    
    
    public function &GetObject()
    {
        $obj = new HolidayItem;
        $obj->fill_from_array($this->fields);
        return $obj;
    }
    
    public function __construct($args = '')
    {
        parent::__construct($args);
        if( isset($this->_args['limit']) ) $this->_limit = (int) $this->_args['limit'];
    }
}
?>

Code: Select all

<div class="holidayWrapper">
  {foreach $holidays as $holiday}
    <div class="holiday">
      <div class="row">
        <div class="col-sm-6">
   <a href="{cms_action_url action=detail hid=$holiday->id returnid=$detailpage}">{$holiday->name}</a>
</div>
<div class="col-sm-6 text-right">{$holiday->the_date|date_format:'%x'}</div>
      </div>
    </div>
  {foreachelse}
     <div class="alert alert-danger">{$mod->Lang('sorry_noholidays')}</div>
  {/foreach}
</div>