// This is Free Software under GNU Affero General Public License v >= 3.0
// without warranty, see README.md and license for details.
//
// SPDX-License-Identifier: AGPL-3.0-or-later
// License-Filename: LICENSES/AGPL-3.0.txt
//
// Copyright (C) 2018 by via donau
//   – Österreichische Wasserstraßen-Gesellschaft mbH
// Software engineering by Intevation GmbH
//
// Author(s):
//  * Sascha L. Teichmann <sascha.teichmann@intevation.de>

package controllers

import (
	"database/sql"
	"net/http"
	"time"

	"gemma.intevation.de/gemma/pkg/models"
)

const (
	listPrintTemplatesSQL = `
SELECT
  template_name,
  date_info
FROM
  users.templates
ORDER BY date_info DESC`
)

func listPrintTemplates(
	_ interface{},
	req *http.Request,
	conn *sql.Conn,
) (jr JSONResult, err error) {

	type template struct {
		Name string      `json:"name"`
		Time models.Time `json:"time"`
	}

	var rows *sql.Rows
	if rows, err = conn.QueryContext(req.Context(), listPrintTemplatesSQL); err != nil {
		return
	}
	defer rows.Close()

	templates := []*template{}

	for rows.Next() {
		var tmpl template
		var w time.Time
		if err = rows.Scan(&tmpl.Name, &w); err != nil {
			return
		}
		tmpl.Time = models.Time{w}
		templates = append(templates, &tmpl)
	}

	jr = JSONResult{Result: templates}
	return
}

func fetchPrintTemplate(
	_ interface{},
	req *http.Request,
	conn *sql.Conn,
) (jr JSONResult, err error) {
	// TODO: Implement me!
	return
}

func createPrintTemplate(
	_ interface{},
	req *http.Request,
	conn *sql.Conn,
) (jr JSONResult, err error) {
	// TODO: Implement me!
	return
}

func deletePrintTemplate(
	_ interface{},
	req *http.Request,
	conn *sql.Conn,
) (jr JSONResult, err error) {
	// TODO: Implement me!
	return
}

func updatePrintTemplate(
	_ interface{},
	req *http.Request,
	conn *sql.Conn,
) (jr JSONResult, err error) {
	// TODO: Implement me!
	return
}