openNAMU__openNAMU/route_go/route/api_list_old_page.go

package route

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

func Api_list_old_page(call_arg []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)
	if db == nil {
		return
	}
	defer db.Close()

	page_int, err := strconv.Atoi(other_set["num"])
	if err != nil {
		log.Fatal(err)
	}

	if page_int > 0 {
		page_int = (page_int * 50) - 50
	} else {
		page_int = 0
	}

	var stmt *sql.Stmt

	if other_set["set_type"] == "old" {
		stmt, err = db.Prepare(tool.DB_change(db_set, "select doc_name, set_data from data_set where set_name = 'last_edit' and doc_rev = '' and (doc_name) in (select doc_name from data_set where set_name = 'doc_type' and set_data = '') order by set_data asc limit ?, 50"))
	} else {
		stmt, err = db.Prepare(tool.DB_change(db_set, "select doc_name, set_data from data_set where set_name = 'last_edit' and doc_rev = '' and (doc_name) in (select doc_name from data_set where set_name = 'doc_type' and set_data = '') order by set_data desc limit ?, 50"))
	}

	if err != nil {
		log.Fatal(err)
	}
	defer stmt.Close()

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

	var data_list [][]string

	for rows.Next() {
		var doc_name string
		var date string

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

		stmt, err = db.Prepare(tool.DB_change(db_set, "select set_data from data_set where doc_name = ? and set_name = 'doc_type'"))
		if err != nil {
			log.Fatal(err)
		}
		defer stmt.Close()

		var doc_type string

		err = stmt.QueryRow(doc_name).Scan(&doc_type)
		if err != nil {
			if err == sql.ErrNoRows {
				doc_type = ""
			} else {
				log.Fatal(err)
			}
		}
		defer rows.Close()

		data_list = append(data_list, []string{doc_name, date, doc_type})
	}

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

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

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