savolai

Export Things 3 Tasks and Subtasks to HTML

This SQL script extracts tasks and subtasks (checklist items) from a Things 3 SQLite database.

Features:
	•	Projects grouped with their description
	•	Tasks listed under each project
	•	Completed tasks and subtasks are prepended with X
	•	Creation, due, deadline, and completion dates included in semantic <time> tags
	•	Task notes shown under tasks

savolai

<?php
/**
 * Used to render the navigation items in the simple_nav block
 *
 */
class block_simple_nav_renderer extends plugin_renderer_base {

    public function simple_nav_tree($items) {
        $depth = 0;
        $type = 0;

savolai

/**
* @brief executeQueriesFromFile Read each line from a .sql QFile
* (assumed to not have been opened before this function), and when ; is reached, execute
* the SQL gathered until then on the query object. Then do this until a COMMIT SQL
* statement is found. In other words, this function assumes each file is a single
* SQL transaction, ending with a COMMIT line.
*/

void executeQueriesFromFile(QFile *file, QSqlQuery *query)
{