package route

import (
	"database/sql"
	"encoding/json"
	"log"
	"opennamu/route/tool"
	"strconv"
)

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

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

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

	var rows []*sql.Rows
	if other_set["bbs_num"] == "" {
		var err error

		row, err := db.Query(tool.DB_change(db_set, "select set_code, set_id, '0' from bbs_data where set_name = 'date' order by set_data desc limit 50"))
		if err != nil {
			log.Fatal(err)
		}

		rows = append(rows, row)
	} else {
		page, _ := strconv.Atoi(other_set["page"])
		num := 0
		if page*50 > 0 {
			num = page*50 - 50
		}

		stmt, err := db.Prepare(tool.DB_change(db_set, "select set_code, set_id, '1' from bbs_data where set_name = 'pinned' and set_id like ? order by set_data desc"))
		if err != nil {
			log.Fatal(err)
		}
		defer stmt.Close()

		row, err := stmt.Query(other_set["bbs_num"])
		if err != nil {
			log.Fatal(err)
		}

		rows = append(rows, row)

		stmt, err = db.Prepare(tool.DB_change(db_set, "select set_code, set_id, '0' from bbs_data where set_name = 'title' and set_id like ? order by set_code + 0 desc limit ?, 50"))
		if err != nil {
			log.Fatal(err)
		}
		defer stmt.Close()

		row, err = stmt.Query(other_set["bbs_num"], num)
		if err != nil {
			log.Fatal(err)
		}

		rows = append(rows, row)
	}

	var data_list []map[string]string
	ip_parser_temp := map[string][]string{}

	for for_a := 0; for_a < len(rows); for_a++ {
		defer rows[for_a].Close()

		for rows[for_a].Next() {
			temp_data := make(map[string]string)

			var set_code string
			var set_id string
			var pinned string

			err := rows[for_a].Scan(&set_code, &set_id, &pinned)
			if err != nil {
				log.Fatal(err)
			}

			temp_data["set_code"] = set_code
			temp_data["set_id"] = set_id
			temp_data["pinned"] = pinned

			stmt, err := db.Prepare(tool.DB_change(db_set, "select set_name, set_data, set_code, set_id from bbs_data where set_code = ? and set_id = ?"))
			if err != nil {
				log.Fatal(err)
			}
			defer stmt.Close()

			rows, err := stmt.Query(set_code, set_id)
			if err != nil {
				log.Fatal(err)
			}
			defer rows.Close()

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

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

				if set_name == "user_id" {
					var ip_pre string
					var ip_render string

					if _, ok := ip_parser_temp[set_data]; ok {
						ip_pre = ip_parser_temp[set_data][0]
						ip_render = ip_parser_temp[set_data][1]
					} else {
						ip_pre = tool.IP_preprocess(db, db_set, set_data, other_set["ip"])[0]
						ip_render = tool.IP_parser(db, db_set, set_data, other_set["ip"])

						ip_parser_temp[set_data] = []string{ip_pre, ip_render}
					}

					set_data = ip_pre
					temp_data["user_id_render"] = ip_render
				}

				if set_name != "data" && set_name != "pinned" {
					temp_data[set_name] = set_data
				}
			}

			data_list = append(data_list, temp_data)
		}
	}

	return_data := make(map[string]interface{})
	return_data["language"] = map[string]string{}

	if len(data_list) == 0 {
		return_data["data"] = map[string]string{}
	} else {
		return_data["data"] = data_list
	}

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