api_user_watch_list.go 1.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677
  1. package route
  2. import (
  3. "database/sql"
  4. "log"
  5. "opennamu/route/tool"
  6. "strconv"
  7. jsoniter "github.com/json-iterator/go"
  8. )
  9. func Api_user_watch_list(call_arg []string) string {
  10. var json = jsoniter.ConfigCompatibleWithStandardLibrary
  11. other_set := map[string]string{}
  12. json.Unmarshal([]byte(call_arg[0]), &other_set)
  13. db := tool.DB_connect()
  14. defer db.Close()
  15. page, _ := strconv.Atoi(other_set["num"])
  16. num := 0
  17. if page*50 > 0 {
  18. num = page*50 - 50
  19. }
  20. ip := other_set["ip"]
  21. name := other_set["name"]
  22. return_data := make(map[string]interface{})
  23. return_data["language"] = map[string]string{
  24. "watchlist": tool.Get_language(db, "watchlist", false),
  25. "star_doc": tool.Get_language(db, "star_doc", false),
  26. }
  27. if ip != name && !tool.Check_acl(db, "", "", "view_user_watchlist", ip) {
  28. return_data["response"] = "require auth"
  29. return_data["data"] = []string{}
  30. } else {
  31. var stmt *sql.Stmt
  32. var err error
  33. if other_set["do_type"] == "star_doc" {
  34. stmt, err = db.Prepare(tool.DB_change("select data from user_set where name = 'star_doc' and id = ? limit ?, 50"))
  35. } else {
  36. stmt, err = db.Prepare(tool.DB_change("select data from user_set where name = 'watchlist' and id = ? limit ?, 50"))
  37. }
  38. if err != nil {
  39. log.Fatal(err)
  40. }
  41. defer stmt.Close()
  42. rows, err := stmt.Query(name, num)
  43. if err != nil {
  44. log.Fatal(err)
  45. }
  46. defer rows.Close()
  47. data_list := []string{}
  48. for rows.Next() {
  49. var title_data string
  50. err := rows.Scan(&title_data)
  51. if err != nil {
  52. log.Fatal(err)
  53. }
  54. data_list = append(data_list, title_data)
  55. }
  56. return_data["response"] = "ok"
  57. return_data["data"] = data_list
  58. }
  59. json_data, _ := json.Marshal(return_data)
  60. return string(json_data)
  61. }