get_block_event.php

<?php
use Xmf\Request;
use XoopsModules\Tadtools\Utility;
use XoopsModules\Tad_cal\Tools;

require_once __DIR__ . '/header.php';

/* 連資料庫檢查 */
$op = Request::getString('op');
$start = Request::getString('start');
$end = Request::getString('end');

header('HTTP/1.1 200 OK');
$xoopsLogger->activated = false;

if ('title' === $op) {
    echo get_event_title($start);
} else {
    echo get_event_num();
}

//取得事件
function get_event_num()
{
    global $xoopsDB;

    //取得目前使用者可讀的群組
    $ok_cate_arr = Tools::chk_tad_cal_cate_power('enable_group');
    $all_ok_cate = implode(',', $ok_cate_arr);
    $and_ok_cate = empty($all_ok_cate) ? "and cate_sn='0'" : "and cate_sn in($all_ok_cate)";
    $and_ok_cate2 = empty($all_ok_cate) ? "and a.sn='0'" : "and b.cate_sn in($all_ok_cate)";

    $even_start = date('Y-m-d H:i:s');
    $even_end = date('Y-m-t H:i:s');
    //抓出事件
    $sql = 'select * from ' . $xoopsDB->prefix('tad_cal_event') . " where (`start` >= '$even_start' or `end` <= '$even_end')  or (`start` <= '$even_end' and `end` > '$even_end') or (`start` <= '$even_start' and `end` > '$even_start') $and_ok_cate order by `start` , `sequence`";
    $result = $xoopsDB->query($sql) or Utility::web_error($sql, __FILE__, __LINE__);

    while (false !== ($all = $xoopsDB->fetchArray($result))) {
        foreach ($all as $k => $v) {
            $$k = $v;
        }
        if (!empty($recurrence)) {
            continue;
        }

        $startTime = strtotime($start);
        $key = date('Y-m-d', $startTime);

        $event_arr[$key]++;
        $Time_arr[$key] = userTimeToServerTime($startTime);
    }

    //抓出重複事件
    $sql = 'select a.*,b.title,b.cate_sn from ' . $xoopsDB->prefix('tad_cal_repeat') . ' as a join ' . $xoopsDB->prefix('tad_cal_event') . " as b on a.sn=b.sn where a.`start` >= '$even_start' and a.`end` <= '$even_end' $and_ok_cate2 order by a.`start`";
    $result = $xoopsDB->queryF($sql) or Utility::web_error($sql, __FILE__, __LINE__);
    while (false !== ($all = $xoopsDB->fetchArray($result))) {
        foreach ($all as $k => $v) {
            $$k = $v;
        }

        $startTime = strtotime($start);
        $key = date('Y-m-d', $startTime);

        $event_arr[$key]++;
        $Time_arr[$key] = userTimeToServerTime($startTime);
    }

    $i = 0;
    foreach ($event_arr as $start => $title) {
        $myEvents[$i]['id'] = $i;
        $myEvents[$i]['title'] = $title;
        $myEvents[$i]['start'] = date('c', $Time_arr[$start]);
        $myEvents[$i]['allDay'] = true;
        $myEvents[$i]['className'] = 'blockevent';
        $myEvents[$i]['show_date'] = date('Y-m-d', $Time_arr[$start]);
        $i++;
    }
    Utility::dd($myEvents);

}

//取得事件標題即連結
function get_event_title($start = '')
{
    global $xoopsDB, $xoopsUser, $xoopsConfig;

    //取得目前使用者可讀的群組
    $ok_cate_arr = Tools::chk_tad_cal_cate_power('enable_group');
    $all_ok_cate = implode(',', $ok_cate_arr);
    $and_ok_cate = empty($all_ok_cate) ? "and cate_sn='0'" : "and cate_sn in($all_ok_cate)";
    $and_ok_cate2 = empty($all_ok_cate) ? "and a.sn='0'" : "and b.cate_sn in($all_ok_cate)";

    setTimezoneByOffset($xoopsConfig['default_TZ']);

    $even_start = date('Y-m-d 00:00:00', strtotime($start));
    $even_end = date('Y-m-d 23:59:59', strtotime($start));

    //抓出事件
    $sql = 'select * from ' . $xoopsDB->prefix('tad_cal_event') . " where ((`start` >= '$even_start' and `start` <= '$even_end') or (`end` > '$even_start' and `end` <= '$even_end')) $and_ok_cate order by `start` , `sequence`";
    //die($sql);

    $result = $xoopsDB->query($sql) or Utility::web_error($sql, __FILE__, __LINE__);

    while (false !== ($all = $xoopsDB->fetchArray($result))) {
        //以下會產生這些變數： $sn , $title , $start , $end , $recurrence , $location , $kind , $details , $etag , $id , $sequence , $uid , $cate_sn
        foreach ($all as $k => $v) {
            $$k = $v;
        }
        if (!empty($recurrence)) {
            continue;
        }

        $title_arr[$sn] = $title;
    }

    //抓出重複事件
    $sql = 'select a.*,b.title,b.cate_sn from ' . $xoopsDB->prefix('tad_cal_repeat') . ' as a join ' . $xoopsDB->prefix('tad_cal_event') . " as b on a.sn=b.sn where ((a.`start` >= '$even_start' and a.`start` <= '$even_end') or (a.`end` > '$even_start' and a.`end` <= '$even_end')) $and_ok_cate2 order by a.`start`";
    //die($sql);
    $result = $xoopsDB->queryF($sql) or Utility::web_error($sql, __FILE__, __LINE__);
    while (false !== ($all = $xoopsDB->fetchArray($result))) {
        //以下會產生這些變數： $sn , $title , $start , $end , $recurrence , $location , $kind , $details , $etag , $id , $sequence , $uid , $cate_sn
        foreach ($all as $k => $v) {
            $$k = $v;
        }

        $title_arr[$sn] = $title;
    }

    $all = "
    <ul style='font-size: 0.875rem; line-height:1.5;'>";
    foreach ($title_arr as $sn => $title) {
        $all .= "<li><a href='" . XOOPS_URL . "/modules/tad_cal/event.php?sn=$sn' style='text-decoration:none;color:#202020;'>{$title}</a></li>";
    }
    $all .= '</ul>';

    return $all;
}