From ea5df990ee13cf2ca03b0ee757f2f67c789cb93c Mon Sep 17 00:00:00 2001
From: liuxiaolong <736321739@qq.com>
Date: 星期三, 21 八月 2019 13:14:48 +0800
Subject: [PATCH] tagList get from sqlite

---
 controllers/taglist.go |   88 +++++++++++++-------------------------------
 1 files changed, 26 insertions(+), 62 deletions(-)

diff --git a/controllers/taglist.go b/controllers/taglist.go
index 802b018..107532e 100644
--- a/controllers/taglist.go
+++ b/controllers/taglist.go
@@ -2,81 +2,45 @@
 
 import (
 	"basic.com/dbapi.git"
-	"encoding/json"
-	"fmt"
+	"webserver/extend/code"
+	"webserver/extend/util"
 
 	"github.com/gin-gonic/gin"
-	"webserver/extend/code"
-	"webserver/extend/config"
-	"webserver/extend/esutil"
-	"webserver/extend/util"
 )
 
-//鏍囩鍒楄〃
-//浠诲姟鍒楄〃
 // @Summary 鏍囩鍒楄〃
 // @Description 杩斿洖搴曞簱鏍囩
 // @Accept  json
 // @Produce json
 // @Tags es
-// @Success 200 {string} json "{"code":200, msg:"鐩綍缁撴瀯鏁版嵁", success:true}"
-// @Failure 500 {string} json "{"code":500,  msg:"杩斿洖閿欒淇℃伅", success:false}"
+// @Success 200 {string} json "{"code":200, msg:"", success:true}"
+// @Failure 500 {string} json "{"code":500, msg:"", success:false}"
 // @Router /data/api-v/es/taskList [POST]
 func (sc *EsSearchController) PostEsTagList(c *gin.Context) {
 
-	url := "http://" + config.EsInfo.Masterip + ":" + config.EsInfo.Httpport +
-		"/" + config.EsInfo.EsIndex.DbTables.IndexName + "/_search"
-	var setApi dbapi.SysSetApi
-	_, sysconf := setApi.GetServerInfo()
-	prama := "{\"query\":{\"bool\":{\"filter\":[{\"terms\":{\"analyServerId\":[\"\",\"" + sysconf.ServerId + "\"]}}]}},\"size\":1000}"
-	tokenRes := esutil.GetEsDataReq(url, prama, true)
-	sources := make([]map[string]interface{}, 0)
-	for _, value := range tokenRes["datalist"].([]interface{}) {
-		tokenRes := make(map[string]interface{})
-		tr := value.(map[string]interface{})
-		key := tr["id"].(string)
-		tokenRes["key"] = key
-		tokenRes["title"] = tr["tableName"].(string)
-		tokenRes["value"] = tr["id"].(string)
-		status := int(tr["isDelete"].(float64))
-		tokenRes["status"] = status
-		if status == 1 {
-			if GetTotalFromDb(key) == false {
-				continue
+	var dtApi dbapi.DbTableApi
+	var dbpApi dbapi.DbPersonApi
+	dts, err := dtApi.FindAllDbTablesByCurServer()
+	if err == nil {
+		if dts !=nil {
+			sources := make([]map[string]interface{}, 0)
+			for _, dt := range dts {
+				tokenRes := make(map[string]interface{})
+				tokenRes["key"] = dt.Id
+				tokenRes["title"] = dt.TableName
+				tokenRes["value"] = dt.Id
+				tokenRes["status"] = dt.IsDelete
+				if dt.IsDelete == 1 {
+					personTotal,_ := dbpApi.GetPersonTotal(dt.Id)
+					if personTotal == 0 {
+						continue
+					}
+				}
+				sources = append(sources, tokenRes)
 			}
+			util.ResponseFormat(c, code.Success, sources)
+			return
 		}
-		sources = append(sources, tokenRes)
 	}
-	util.ResponseFormat(c, code.Success, sources)
-}
-
-//鍒ゆ柇搴曞簱鏄惁鏈夋暟鎹�
-func GetTotalFromDb(id string) (flag bool) {
-	flag = false
-	url := "http://" + config.EsInfo.Masterip + ":" + config.EsInfo.Httpport +
-		"/" + config.EsInfo.EsIndex.VideoPersons.IndexName + "/_search"
-	prama := "{\"query\":{\"bool\":{\"filter\":[{\"term\":{\"baseInfo.tableId\":\"" + id + "\"}}]}},\"size\":0}"
-	buf, err := esutil.EsReq("POST", url, []byte(prama))
-	if err != nil {
-		fmt.Println("http request info is err!")
-		return
-	}
-	var info interface{}
-	json.Unmarshal(buf, &info)
-	out, ok := info.(map[string]interface{})
-	if !ok {
-		fmt.Println("http response interface can not change map[string]interface{}")
-		return
-	}
-	middle, ok := out["hits"].(map[string]interface{})
-	if !ok {
-		fmt.Println("first hits change error!")
-		return
-	}
-
-	total := int(middle["total"].(float64))
-	if total > 0 {
-		flag = true
-	}
-	return flag
+	util.ResponseFormat(c,code.ComError,"鏌ヨ搴曞簱鏍囩澶辫触")
 }

--
Gitblit v1.8.0