top.php

<?php
use Xmf\Request;
use XoopsModules\Tadtools\Utility;
use XoopsModules\Tad_web\Tools as TadWebTools;
/*-----------引入檔案區--------------*/
require_once __DIR__ . '/header.php';
$GLOBALS['xoopsOption']['template_main'] = 'tad_web_top.tpl';
require_once XOOPS_ROOT_PATH . '/header.php';

/*-----------執行動作判斷區----------*/
$op = Request::getString('op');
$WebID = Request::getInt('WebID');

common_template($WebID, $web_all_config);

switch ($op) {
    //預設動作
    default:
        list_top($WebID);

        break;
}

/*-----------秀出結果區--------------*/
require_once __DIR__ . '/footer.php';
require_once XOOPS_ROOT_PATH . '/footer.php';

/*-----------function區--------------*/

function list_top()
{
    global $xoopsTpl, $xoopsDB;

    define('_DISPLAY_MODE', 'index');
    $web_plugin_enable_arr = TadWebTools::get_web_config('web_plugin_enable_arr', 0);
    if (empty($web_plugin_enable_arr)) {
        $enable_arr = get_dir_plugins();
    } else {
        $enable_arr = explode(',', $web_plugin_enable_arr);
    }
    $i = 0;
    $all_top = $king = $king_rank = $WebNames = $WebTitles = [];
    foreach ($enable_arr as $dirname) {
        if (empty($dirname)) {
            continue;
        }
        $pluginConfig = [];
        if (file_exists("plugins/{$dirname}/config.php")) {
            require_once "plugins/{$dirname}/config.php";
            if ('' == $pluginConfig['top_table']) {
                continue;
            }

            $sql = 'SELECT a.`WebID`, COUNT(*) AS cc, b.`WebName`, b.`WebTitle` FROM `' . $xoopsDB->prefix($pluginConfig['top_table']) . '` AS a LEFT JOIN `' . $xoopsDB->prefix('tad_web') . '` AS b ON a.`WebID` = b.`WebID` WHERE b.`WebEnable` = ? GROUP BY a.`WebID` ORDER BY cc DESC LIMIT 0, 10';
            $result = Utility::query($sql, 's', ['1']) or Utility::web_error($sql, __FILE__, __LINE__);

            $top = [];
            $j = 1;
            while (list($WebID, $count, $WebName, $WebTitle) = $xoopsDB->fetchRow($result)) {
                $top[$j]['count'] = $count;
                $top[$j]['WebName'] = $WebName;
                $top[$j]['WebTitle'] = $WebTitle;
                $top[$j]['WebID'] = $WebID;

                $king_rank[$WebID] += $count * $pluginConfig['top_score'];
                $WebNames[$WebID] = $WebName;
                $WebTitles[$WebID] = $WebTitle;
                $j++;
            }

            $all_top[$i]['pluginName'] = $pluginConfig['name'];
            $all_top[$i]['dirname'] = $dirname;
            $all_top[$i]['top'] = $top;

            $i++;
        }
    }

    //標籤部份
    $sql = 'SELECT a.`WebID`, COUNT(*) AS `cc`, b.`WebName`, b.`WebTitle` FROM `' . $xoopsDB->prefix('tad_web_tags') . '` AS `a` LEFT JOIN `' . $xoopsDB->prefix('tad_web') . '` AS `b` ON `a`.`WebID`=`b`.`WebID` WHERE `b`.`WebEnable`=? GROUP BY `a`.`WebID` ORDER BY `cc` DESC LIMIT 0, 10';
    $result = Utility::query($sql, 's', ['1']) or Utility::web_error($sql, __FILE__, __LINE__);

    $top = [];
    $j = 1;
    while (list($WebID, $count, $WebName, $WebTitle) = $xoopsDB->fetchRow($result)) {
        $top[$j]['count'] = $count;
        $top[$j]['WebName'] = $WebName;
        $top[$j]['WebTitle'] = $WebTitle;
        $top[$j]['WebID'] = $WebID;

        $king_rank[$WebID] += $count;
        $WebNames[$WebID] = $WebName;
        $WebTitles[$WebID] = $WebTitle;
        // $king[$WebID]['WebName'] = $WebName;
        $j++;
    }
    $all_top[$i]['pluginName'] = _MD_TCW_TAG;
    $all_top[$i]['dirname'] = 'tag';
    $all_top[$i]['top'] = $top;

    $i++;

    //點閱數部份
    $sql = 'SELECT `WebID`, `WebCounter`, `WebName`, `WebTitle` FROM `' . $xoopsDB->prefix('tad_web') . '` WHERE `WebEnable`=? GROUP BY `WebID` ORDER BY `WebCounter` DESC LIMIT 0, 10';
    $result = Utility::query($sql, 's', ['1']) or Utility::web_error($sql, __FILE__, __LINE__);

    $top = [];
    $j = 1;
    while (list($WebID, $count, $WebName, $WebTitle) = $xoopsDB->fetchRow($result)) {
        $top[$j]['count'] = $count;
        $top[$j]['WebName'] = $WebName;
        $top[$j]['WebTitle'] = $WebTitle;
        $top[$j]['WebID'] = $WebID;

        $king_rank[$WebID] += round($count / 500, 0);
        $WebNames[$WebID] = $WebName;
        $WebTitles[$WebID] = $WebTitle;
        // $king[$WebID]['WebName'] = $WebName;
        $j++;
    }
    $all_top[$i]['pluginName'] = _MD_TCW_WEB_COUNTER;
    $all_top[$i]['dirname'] = 'index';
    $all_top[$i]['top'] = $top;

    $i++;

    //區塊部份
    $sql = 'SELECT a.`WebID`, COUNT(*) AS `cc`, a.`ShareFrom`, b.`WebName`, b.`WebTitle` FROM `' . $xoopsDB->prefix('tad_web_blocks') . '` AS a LEFT JOIN `' . $xoopsDB->prefix('tad_web') . '` AS b ON a.`WebID`=b.`WebID` WHERE a.`BlockEnable`=? AND a.`BlockPosition`!=? AND a.`plugin`=? AND b.`WebEnable`=? GROUP BY a.`WebID` ORDER BY `cc` DESC LIMIT 0,10';
    $result = Utility::query($sql, 'ssss', ['1', 'uninstall', 'custom', '1']) or Utility::web_error($sql, __FILE__, __LINE__);

    $top = [];
    $j = 1;
    while (list($WebID, $count, $ShareFrom, $WebName, $WebTitle) = $xoopsDB->fetchRow($result)) {
        $top[$j]['count'] = $count;
        $top[$j]['WebName'] = $WebName;
        $top[$j]['WebTitle'] = $WebTitle;
        $top[$j]['WebID'] = $WebID;

        $king_rank[$WebID] += (0 == $ShareFrom) ? $count * 2 : $count;
        $WebNames[$WebID] = $WebName;
        $WebTitles[$WebID] = $WebTitle;
        // $king[$WebID]['WebName'] = $WebName;
        $j++;
    }
    $all_top[$i]['pluginName'] = _MD_TCW_WEB_BLOCK;
    $all_top[$i]['dirname'] = 'index';
    $all_top[$i]['top'] = $top;

    $i++;

    arsort($king_rank);
    // die(var_export($WebNames));
    $xoopsTpl->assign('king_rank', $king_rank);
    $xoopsTpl->assign('WebNames', $WebNames);
    $xoopsTpl->assign('WebTitles', $WebTitles);
    $xoopsTpl->assign('all_top', $all_top);
    $xoopsTpl->assign('plugin_data_total', 10);
}