Ubilling/api/libs/api.tagcloud.php

<?php

/**
 * User tags cloud rendering
 */
class TagCloud {

    /**
     * Contains all tagged users
     *
     * @var array
     */
    protected $alltags = array();

    /**
     * Contains user tags data as id=>data login/tagid
     *
     * @var array
     */
    protected $usertags = array();

    /**
     * Contains available tagnames as id=>name
     *
     * @var array
     */
    protected $allnames = array();

    /**
     * Contains tags power based on assigns count as id=>power
     *
     * @var array
     */
    protected $tagspower = array();

    /**
     * Contains users with no tags assigned
     *
     * @var array
     */
    protected $notags = array();

    /**
     * Contains users that not have employee tags
     *
     * @var array
     */
    protected $noEmployeeTags = array();

    const URL_ME = '?module=tagcloud';
    const URL_GRID = 'gridview=true';
    const URL_REPORT = 'report=true';
    const NO_TAG = 'notags=true';
    const NO_EMPLOYEE_TAG = 'noemployeetags=true';

    public function __construct() {
        $this->loadTags();
        $this->loadTagNames();
        $this->loadUserTags();
        $this->tagPowerPreprocessing();
        $this->panel();
    }

    /**
     * loads all used tags into private data property
     * 
     * @return void
     */
    protected function loadTags() {
        $this->alltags = $this->getAllTagged();
    }

    /**
     * loads all tag names into private data property
     * 
     * @return void
     */
    protected function loadTagNames() {
        $this->allnames = $this->getAllTagNames();
    }

    /**
     * loads all users tags into private data property
     * 
     * @return void
     */
    protected function loadUserTags() {
        $query = "SELECT `login`,`tagid`,`id` from `tags`";
        $all = simple_queryall($query);
        if (!empty($all)) {
            foreach ($all as $io => $each) {
                $this->usertags[$each['id']]['login'] = $each['login'];
                $this->usertags[$each['id']]['tagid'] = $each['tagid'];
            }
        }
    }

    /**
     * preprocessing of tagspower by alltags private property
     * 
     * @return void
     */
    protected function tagPowerPreprocessing() {
        if (!empty($this->usertags)) {
            foreach ($this->usertags as $io => $each) {
                if (isset($this->tagspower[$each['tagid']])) {
                    $this->tagspower[$each['tagid']] ++;
                } else {
                    $this->tagspower[$each['tagid']] = 1;
                }
            }
        }
    }

    /**
     * Gets all tagged users
     * 
     * @return array
     */
    protected function getAllTagged() {
        $query = 'SELECT DISTINCT `tagid` from `tags` ORDER BY `tagid` ASC';
        $alltags = simple_queryall($query);
        return ($alltags);
    }

    /**
     * Gets some tag power by its ID
     * 
     * @param $tagid - existing tag ID
     * 
     * @return int
     */
    protected function getTagPower($tagid) {
        if (!empty($this->tagspower)) {
            if (isset($this->tagspower[$tagid])) {
                $result = $this->tagspower[$tagid];
            } else {
                $result = 0;
            }
        } else {
            $result = 0;
        }
        return ($result);
    }

    /**
     * Gets all tags names as array tagid=>tagname
     * 
     * @return array
     */
    protected function getAllTagNames() {
        $query = "SELECT `id`,`tagname` from `tagtypes`";
        $result = array();
        $alltags = simple_queryall($query);
        if (!empty($alltags)) {
            foreach ($alltags as $io => $eachtag) {
                $result[$eachtag['id']] = $eachtag['tagname'];
            }
        }
        return($result);
    }

    /**
     * returns control panel for tagcloud
     * 
     * @return string
     */
    protected function panel() {
        $result = wf_Link(self::URL_ME, wf_img('skins/icon_cloud.png') . ' ' . __('Tag cloud'), false, 'ubButton');
        $result .= wf_Link(self::URL_ME . '&' . self::URL_GRID, wf_img('skins/icon_table.png') . ' ' . __('Grid view'), false, 'ubButton');
        $result .= wf_Link(self::URL_ME . '&' . self::URL_REPORT, wf_img('skins/ukv/report.png') . ' ' . __('Report'), false, 'ubButton');
        $result .= wf_Link(self::URL_ME . '&' . self::NO_TAG, wf_img('skins/track_icon.png') . ' ' . __('No tags'), false, 'ubButton');
        $result .= wf_Link(self::URL_ME . '&' . self::NO_EMPLOYEE_TAG, wf_img('skins/menuicons/employee.png') . ' ' . __('No employee tags'), true, 'ubButton');
        $result .= show_window('', $result);
        return ($result);
    }

    /**
     * loads users that no have employee tags
     * 
     * @return void
     */
    protected function loadNoEmployeeTagss() {
        $this->noEmployeeTags = $this->getNoEmployeeTagged();
    }

    /**
     * loads no tag user names into private data property
     * 
     * @return void
     */
    protected function loadNoTagUsers() {
        $this->notags = $this->getNoTagged();
    }

    /**
     * Returns array of users without tags
     * 
     * @return array
     */
    protected function getNoTagged() {
        $query = 'SELECT `users`.`login`,`tags`.`id` FROM `users` LEFT JOIN `tags` ON `users`.`login`=`tags`.`login` WHERE `tags`.`id` IS NULL ORDER BY `tags`.`id` ASC';
        $notags = simple_queryall($query);
        return ($notags);
    }

    /**
     * Returns array of users that no have employee tags
     * 
     * @return array
     */
    protected function getNoEmployeeTagged() {
        $result = array();
        $query = 'SELECT login,employee.id FROM `tags` LEFT JOIN (SELECT `id`,`tagid`,`name` FROM `employee` WHERE `tagid` IS NOT NUll) as employee USING (`tagid`) GROUP by login';
        $resultQuery = simple_queryall($query);
        if (!empty($resultQuery)) {
            foreach ($resultQuery as $key => $raw) {
                if (empty($raw['id'])) {
                    $result[] = $raw['login'];
                }
            }
        }
        return ($result);
    }

    /**
     * Renders tag grid for users that no tagged
     * 
     * @return void
     */
    public function renderNoEmployeeTags() {
        $result = '';
        $userArr = array();
        //usage of this in constructor significantly reduces performance
        $this->loadNoEmployeeTagss();
        if (!empty($this->noEmployeeTags)) {
            foreach ($this->noEmployeeTags as $key => $user) {
                $userArr[] = $user;
            }
        }
        $result .= web_UserArrayShower($userArr);
        show_window(__('No employee tags'), $result);
    }

    /**
     * Renders tag grid for users that no tagged
     * 
     * @return void
     */
    public function renderNoTagGrid() {
        $result = '';
        $userArr = array();
        //usage of this in constructor significantly reduces performance
        $this->loadNoTagUsers();
        if (!empty($this->notags)) {
            foreach ($this->notags as $key => $user) {
                $userArr[] = $user['login'];
            }
        }
        $result .= web_UserArrayShower($userArr);
        show_window(__('No tags'), $result);
    }

    /**
     * Renders tag grid for tagged users
     * 
     * @return void
     */
    public function renderTagGrid() {
        $cells = wf_TableCell(__('ID'));
        $cells .= wf_TableCell(__('Tags'));
        $cells .= wf_TableCell(__('Users'));
        $rows = wf_TableRow($cells, 'row1');

        if (!empty($this->alltags)) {
            foreach ($this->alltags as $key => $eachtag) {
                if (isset($this->allnames[$eachtag['tagid']])) {
                    $userCount = $this->getTagPower($eachtag['tagid']);
                    $cells = wf_TableCell($eachtag['tagid']);
                    $cells .= wf_TableCell(wf_Link('?module=tagcloud&gridview=true&tagid=' . $eachtag['tagid'], $this->allnames[$eachtag['tagid']], false));
                    $cells .= wf_TableCell($userCount);
                    $rows .= wf_TableRow($cells, 'row3');
                }
            }
        }

        $result = wf_TableBody($rows, '100%', '0', 'sortable');
        show_window(__('Tags'), $result);
    }

    /**
     * Renders tag cloud for tagged users
     * 
     * @return void
     */
    public function renderTagCloud() {
        $result = wf_tag('center');

        if (!empty($this->alltags)) {
            foreach ($this->alltags as $key => $eachtag) {
                $power = $this->getTagPower($eachtag['tagid']);
                $fsize = $power / 2;
                if (isset($this->allnames[$eachtag['tagid']])) {
                    $sup = wf_tag('sup') . $power . wf_tag('sup', true);
                    $result .= wf_tag('font', false, '', 'size="' . $fsize . '"');
                    $result .= wf_Link(self::URL_ME . '&tagid=' . $eachtag['tagid'], $this->allnames[$eachtag['tagid']] . $sup, false);
                    $result .= wf_tag('font', true);
                }
            }
        }
        $result .= wf_tag('center', true);
        show_window(__('Tags'), $result);
    }

    /**
     * Renders tagged users by tag ID
     * 
     * @param $tagid - existing tag ID
     * 
     * @return void
     */
    public function renderTagUsers($tagid) {
        $userarr = array();
        if (!empty($this->usertags)) {
            foreach ($this->usertags as $io => $each) {
                if ($each['tagid'] == $tagid) {
                    $userarr[] = $each['login'];
                }
            }
        }
        $result = web_UserArrayShower($userarr);
        show_window(__('Tag') . ': ' . @$this->allnames[$tagid], $result);
    }

    /**
     * Renders tags assign report
     * 
     * @return void
     */
    public function renderReport() {
        $result = '';
        $resultUsers = '';
        $messages = new UbillingMessageHelper();
        $months = months_array_localized();
        $reportTmp = array();
        $loginsTmp = array();
        $totalCount = 0;
        if (!empty($this->allnames)) {
            $result .= wf_tag('br');
            $curYear = (wf_CheckPost(array('reportyear'))) ? vf($_POST['reportyear'], 3) : curyear();
            $inputs = wf_YearSelectorPreset('reportyear', __('Year'), false, $curYear) . ' ';
            $curTagid = (wf_CheckPost(array('reporttagid'))) ? vf($_POST['reporttagid'], 3) : '';
            $inputs .= wf_Selector('reporttagid', $this->allnames, __('Tag'), $curTagid, false) . ' ';
            $inputs .= wf_CheckInput('renderusers', __('Users'), false, ubRouting::checkPost('renderusers')) . ' ';
            $inputs .= wf_Submit(__('Show'));
            $result .= wf_Form('', 'POST', $inputs, 'glamour');
        } else {
            $result .= $messages->getStyledMessage(__('Nothing found'), 'info');
        }

        if (wf_CheckPost(array('reportyear', 'reporttagid'))) {
            $tagid = vf($_POST['reporttagid'], 3);
            $year = vf($_POST['reportyear'], 3);
            $datemask = $year . '-%';
            $query = "SELECT * from `weblogs` WHERE `date` LIKE '" . $datemask . "' AND `event` LIKE 'TAGADD (%TAGID%'";
            $raw = simple_queryall($query);


            if (!empty($raw)) {
                foreach ($raw as $io => $each) {
                    $eventtagid = preg_match("/\[[^\]]*\]/", $each['event'], $matches);
                    $eventLogin = preg_match('!\((.*?)\)!si', $each['event'], $tmpLoginMatches);
                    @$eventtagid = ubRouting::filters($matches[0], 'int');
                    @$eventLogin = $tmpLoginMatches[1];
                    if (!empty($eventtagid)) {
                        if ($eventtagid == $tagid) {
                            $eventTime = strtotime($each['date']);
                            $eventMonth = date("m", $eventTime);
                            if (!isset($reportTmp[$eventMonth])) {
                                $reportTmp[$eventMonth] = 1;
                            } else {
                                $reportTmp[$eventMonth] ++;
                            }
                            $totalCount++;
                            //login stats
                            if (!empty($eventLogin)) {
                                $loginsTmp[$eventMonth][$eventLogin] = $eventLogin;
                            }
                        }
                    }
                }
            }


            $cells = wf_TableCell($year);
            $cells .= wf_TableCell(__('Month'));
            $cells .= wf_TableCell($this->allnames[$tagid]);
            $cells .= wf_TableCell(__('Visual'));
            $rows = wf_TableRow($cells, 'row1');

            foreach ($months as $monthNumber => $monthName) {
                $cells = wf_TableCell($monthNumber);
                $cells .= wf_TableCell($monthName);
                $monthData = (isset($reportTmp[$monthNumber])) ? $reportTmp[$monthNumber] : 0;
                $cells .= wf_TableCell($monthData);
                $cells .= wf_TableCell(web_bar($monthData, $totalCount), '', '', 'sorttable_customkey="' . $monthData . '"');
                $rows .= wf_TableRow($cells, 'row3');
            }

            $result .= wf_TableBody($rows, '100%', '0', 'sortable');
            $result .= wf_tag('b') . __('Total') . ':' . wf_tag('b', true) . ' ' . $totalCount;
        }

        show_window(__('Tags'), $result);
        //optional users rendering
        if (ubRouting::checkPost('renderusers')) {
            if (!empty($loginsTmp)) {
                foreach ($loginsTmp as $io => $each) {
                    show_window($months[$io], web_UserArrayShower($each));
                }
            }
        }
    }

}

?>