ChWsbProfilesCalendar.php

Go to the documentation of this file.

<?php
 
ch_import ('ChTemplCalendar');
 
class ChWsbProfilesCalendar extends ChTemplCalendar
{
    var $sMode = 'dor';
 
    function __construct ($iYear, $iMonth)
    {
        parent::__construct($iYear, $iMonth);
    }
 
    function setMode($sMode)
    {
        $this->sMode = $sMode;
    }
 
    function getData ()
    {
        switch($this->sMode) {
            case 'dor':
                return db_res_assoc_arr ("
                    SELECT `Profiles`.*, DAYOFMONTH(`Profiles`.`DateReg`) AS `Day`
                    FROM `Profiles`
                    WHERE
                        UNIX_TIMESTAMP(`Profiles`.`DateReg`) >= UNIX_TIMESTAMP('{$this->iYear}-{$this->iMonth}-1')
                        AND UNIX_TIMESTAMP(`Profiles`.`DateReg`) < UNIX_TIMESTAMP('{$this->iNextYear}-{$this->iNextMonth}-1')
                        AND `Profiles`.`Status` = 'Active'
                ");
            case 'dob':
                $aWhere[] = "MONTH(`DateOfBirth`) = MONTH(CURDATE()) AND DAY(`DateOfBirth`) = DAY(CURDATE())";
                return db_res_assoc_arr ("
                    SELECT `Profiles`.*, DAYOFMONTH(`DateOfBirth`) AS `Day`
                    FROM `Profiles`
                    WHERE
                        MONTH(`DateOfBirth`) = MONTH('{$this->iYear}-{$this->iMonth}-1') AND
                        `Profiles`.`Status` = 'Active'
                ");
        }
 
    }
 
    function getUnit(&$aData)
    {
        //global $oFunctions;
 
        $iProfileID = (int)$aData['ID'];
 
        $sName = getNickName($iProfileID);
        $sUrl = getProfileLink($iProfileID);
 
        return <<<EOF
<div style="width:95%;">
    <a title="{$sName}" href="{$sUrl}">{$sName}</a>
</div>
EOF;
    }
 
    function getBaseUri ()
    {
        $sPossibleMode = (isset($_REQUEST['mode']) && $_REQUEST['mode']!='') ? '&mode=' . $_REQUEST['mode'] : '';
        return CH_WSB_URL_ROOT . "calendar.php?{$sPossibleMode}&date=";
    }
 
    function getBrowseUri ()
    {
        return CH_WSB_URL_ROOT .  "calendar.php?action=browse&date=";
    }
 
    function getEntriesNames ()
    {
        return array(_t('_sys_profile'), _t('_sys_profiles'));
    }
}