<?php
require_once($_SERVER["DOCUMENT_ROOT"] . '/include/commontvn.php');
require_once($_SERVER["DOCUMENT_ROOT"] . "/include/initialize.php");

if (isset($_GET['id'])) {
    $id = $_GET['id'];
    $tagid = $_GET['tag'];
    // _echo($id);

    $nowymd = date("Ymd");
    $nowtime = date("His");

    // _echo($nowymd . " / " . $nowtime . " / " . $id);

    $cntDB = conDB();

    // dtb04seq取得
    $sql = "SELECT MIN(dtb04_seq + 1) AS dtb04_seq FROM dtb_04aclog WHERE (dtb04_seq + 1) NOT IN (SELECT dtb04_seq FROM dtb_04aclog);";
    // _echo($sql);
    $result = $cntDB->query($sql);

    while ($row = $result->fetch_assoc()) {
        $maxseq = $row["dtb04_seq"];
        if ($maxseq == "") {
            $maxseq = 1;
        }
    }
    // _echo("maxseq->" . $maxseq);

    // insert
    $sql = "INSERT INTO dtb_04aclog	 VALUES (";
    $sql = $sql . $maxseq . ",";
    $sql = $sql . "'" . $nowymd . "',";
    $sql = $sql . "'" . $nowtime  . "',";
    $sql = $sql . "'" . $id . "',";
    $sql = $sql . "'" . $tagid . "'";
    $sql = $sql . ");";
    // _echo($sql);


    $result = $cntDB->query($sql);
    $cntDB->close();

    if ($tagid == "909460998559007889") {
        $url = 'https://nordot.app/' . $id;
    } else {
        $url = 'https://nordot.app/' . $id . "?c=476913576246887521";
    }
    header('Location: ' . $url);

    exit;
} else {
    $url = 'https://naratowa.jp/renewal2021//' . $id;
    header('Location: ' . $url);
    exit;
}