(async ()=>{

window.addEventListener('keydown', function(event) {
    // 检查是否按下了 Alt 键和数字 5 键
    if (event.altKey && event.key === '5') {
        // 模拟按钮点击
        console.log('Alt + 5 被按下了!');
        dailynoteAddDatabase();     
    }
});
async function dailynoteAddDatabase() {
    //设置日记自动存放的数据库块id   
    dbBlockId = '20240911002857-lgav146';
    // 获取当前选择笔记本
    boxid = window.siyuan.storage["local-dailynoteid"]
    // 获取日记id
    const create_dailynote_result =await fetchSyncPost('/api/filetree/createDailyNote', {notebook: boxid, app:  siyuan.ws.app.appId})
    const dailynote_ids = [create_dailynote_result.data.id];
    //console.log(dailynote_ids);

    // 添加日记到数据库中
    const db = await getDataBySql(`SELECT * FROM blocks where type ='av' and id='${dbBlockId}'`);
    if (db.length === 0) error("未找到数据库文档块，请检查数据库文档块id是否正确");
    const avId = db.map(av => getDataAvIdFromHtml(av.markdown))[0];


    // 组装文档数据参数
    const srcs = dailynote_ids.map(docId => ({
        "id": docId,
        "isDetached": false,
    }));
    // 获取当前时间
    const nowTime = formatDate(new Date());
    // 插入文档数据到数据库
    // see https://github.com/siyuan-note/siyuan/blob/b244f8aed18e7a41d4b27889d870442154ba1462/app/src/protyle/util/editorCommonEvent.ts#L1043
    const result = await fetchSyncPost('/api/transactions', {
        "session":  siyuan.ws.app.appId,
        "app": siyuan.ws.app.appId,
        "transactions": [{
            "doOperations": [{
                    "action": "insertAttrViewBlock",
                    "avID": avId,
                    "previousID": "",
                    "srcs": srcs,
                    "blockID": dbBlockId
                },
                {
                    "action": "doUpdateUpdated",
                    "id": dbBlockId,
                    "data": nowTime
                }
            ],
            "undoOperations": [{
                    "action": "removeAttrViewBlock",
                    "srcIDs": dailynote_ids,
                    "avID": avId
                },
                {
                    "action": "doUpdateUpdated",
                    "id": dbBlockId,
                    "data": nowTime
                }
            ]
        }],
        "reqId": new Date().getTime()
    });

    // 错误返回
    if (result.code !== 0) {
        await fetchSyncPost('/api/notification/pushErrMsg', { "msg": `日记自动添加数据库失败，错误信息：${result.msg}`, "timeout": 7000 })
    }

    //成功返回结果

    //await fetchSyncPost('/api/notification/pushMsg', { "msg": `日记自动添加数据库成功：${dailynote_path}`, "timeout": 7000 })



    function getDataAvIdFromHtml(htmlString) {
        // 使用正则表达式匹配data-av-id的值
        const match = htmlString.match(/data-av-id="([^"]+)"/);
        if (match && match[1]) {
            return match[1]; // 返回匹配的值
        }
        return ""; // 如果没有找到匹配项，则返回空
    }
    async function getDataBySql(sql) {
        const result = await fetchSyncPost('/api/query/sql', { "stmt": sql });
        if (result.code !== 0) {
            console.error("查询数据库出错", result.msg);
            return [];
        }
        return result.data;
    }
    async function fetchSyncPost(url, data, returnType = 'json') {
        const init = {
            method: "POST",
        };
        if (data) {
            if (data instanceof FormData) {
                init.body = data;
            } else {
                init.body = JSON.stringify(data);
            }
        }
        try {
            const res = await fetch(url, init);
            const res2 = returnType === 'json' ? await res.json() : await res.text();
            return res2;
        } catch (e) {
            console.log(e);
            return returnType === 'json' ? { code: e.code || 1, msg: e.message || "", data: null } : "";
        }
    }

    function formatDate(date) {
        var yy = date.getFullYear().toString();
        var mm = (date.getMonth() + 1).toString(); // 注意月份是从0开始的
        var dd = date.getDate().toString();
        var hh = date.getHours().toString();
        var ii = date.getMinutes().toString();
        var ss = date.getSeconds().toString();
        return yy + (mm[1] ? mm : '0' + mm[0]) + (dd[1] ? dd : '0' + dd[0]) +
            (hh[1] ? hh : '0' + hh[0]) + (ii[1] ? ii : '0' + ii[0]) +
            (ss[1] ? ss : '0' + ss[0]);
    }
}

})();