package route

import (
	"database/sql"
	"log"
	"opennamu/route/tool"

	jsoniter "github.com/json-iterator/go"
)

func Setting_list() map[string]string {
	setting_acl := map[string]string{}

	setting_acl["manage_404_page"] = ""
	setting_acl["manage_404_page_content"] = ""

	setting_acl["bbs_view_acl_all"] = ""
	setting_acl["bbs_acl_all"] = ""
	setting_acl["bbs_edit_acl_all"] = ""
	setting_acl["bbs_comment_acl_all"] = ""

	setting_acl["rankup_condition"] = ""

	return setting_acl
}

func Api_setting(call_arg []string) string {
	var json = jsoniter.ConfigCompatibleWithStandardLibrary

	other_set := map[string]string{}
	json.Unmarshal([]byte(call_arg[0]), &other_set)

	db := tool.DB_connect()
	defer db.Close()

	setting_acl := Setting_list()

	if val, ok := setting_acl[other_set["set_name"]]; ok {
		if val != "" {
			if tool.Check_acl(db, "", "", "owner_auth", other_set["ip"]) {
				return_data := make(map[string]interface{})
				return_data["response"] = "require auth"

				json_data, _ := json.Marshal(return_data)
				return string(json_data)
			}
		}

		data_coverage := ""
		if val, ok := other_set["coverage"]; ok {
			data_coverage = val
		}

		var rows *sql.Rows

		if data_coverage != "" {
			stmt, err := db.Prepare(tool.DB_change("select data, coverage from other where name = ? and coverage = ?"))
			if err != nil {
				log.Fatal(err)
			}

			defer stmt.Close()

			rows, err = stmt.Query(other_set["set_name"], data_coverage)
			if err != nil {
				log.Fatal(err)
			}
		} else {
			stmt, err := db.Prepare(tool.DB_change("select data, coverage from other where name = ?"))
			if err != nil {
				log.Fatal(err)
			}

			defer stmt.Close()

			rows, err = stmt.Query(other_set["set_name"])
			if err != nil {
				log.Fatal(err)
			}
		}
		defer rows.Close()

		data_list := [][]string{}

		for rows.Next() {
			var set_data string
			var set_coverage string

			err := rows.Scan(&set_data, &set_coverage)
			if err != nil {
				log.Fatal(err)
			}

			data_list = append(data_list, []string{set_data, set_coverage})
		}

		return_data := make(map[string]interface{})
		return_data["response"] = "ok"
		return_data["data"] = data_list

		json_data, _ := json.Marshal(return_data)
		return string(json_data)
	} else {
		return_data := make(map[string]interface{})
		return_data["response"] = "not exist"

		json_data, _ := json.Marshal(return_data)
		return string(json_data)
	}
}