| | |
| | | type DbTableController struct { |
| | | } |
| | | |
| | | // @Security ApiKeyAuth |
| | | // @Summary 显示底库列表 |
| | | // @Description 显示同步或本地库列表 |
| | | // @Accept x-www-form-urlencoded |
| | | // @Produce json |
| | | // @Tags dbtable |
| | | // @Param isSync path string true "是否同步库 1 同步库 2本地库 qita 全部库" |
| | | // @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/dbtable/queryDbTables/{isSync} [POST] |
| | | func (dbt DbTableController) QueryDbTables(c *gin.Context) { |
| | | isSync := c.Params.ByName("isSync") |
| | |
| | | b, data := tApi.QueryDbTables(isSync) |
| | | if b{ |
| | | util.ResponseFormat(c, code.Success, data) |
| | | } else { |
| | | util.ResponseFormat(c,code.ComError,[]interface{}{}) |
| | | } |
| | | } |
| | | |
| | | // @Security ApiKeyAuth |
| | | // @Summary 查询本机所有底库列表 |
| | | // @Description 查询本机所有底库列表 |
| | | // @Accept x-www-form-urlencoded |
| | | // @Produce json |
| | | // @Tags dbtable |
| | | // @Param isDelete query string true "0:查未删除,1:查已删除,其他:查所有" |
| | | // @Success 200 {string} json "{"code":200, msg:"", success:true}" |
| | | // @Failure 500 {string} json "{"code":500, msg:"", success:false}" |
| | | // @Router /data/api-v/dbtable/findAllDbTablesByCurServer [GET] |
| | | func (dbt DbTableController) FindAllDbTablesByCurServer(c *gin.Context) { |
| | | var api dbapi.DbTableApi |
| | | isDeleteStr := c.Query("isDelete") |
| | | if isDeleteStr == "" { |
| | | isDeleteStr = "0" |
| | | } |
| | | arr,e := api.FindAllDbTablesByCurServer(isDeleteStr) |
| | | if e == nil { |
| | | util.ResponseFormat(c,code.Success, arr) |
| | | } else { |
| | | util.ResponseFormat(c,code.ComError,[]interface{}{}) |
| | | } |
| | |
| | | return data |
| | | } |
| | | |
| | | // @Security ApiKeyAuth |
| | | // @Summary 修改底库 |
| | | // @Description 修改同步或本地库 |
| | | // @Accept json |
| | |
| | | func (dbt DbTableController) UpdateDbTables(c *gin.Context) { |
| | | dbtable := new(models.Dbtables) |
| | | err := c.BindJSON(&dbtable) |
| | | if err !=nil || dbtable.Id == "" || dbtable.TableName == "" { |
| | | if err !=nil || dbtable.Id == "" || dbtable.TableName == "" || (dbtable.Enable !=0 && dbtable.Enable !=1) { |
| | | util.ResponseFormat(c,code.RequestParamError,"参数有误") |
| | | return |
| | | } |
| | | |
| | | paramBody := util.Struct2Map(dbtable) |
| | | var tApi dbapi.DbTableApi |
| | | b, data := tApi.UpdateDbTables(paramBody) |
| | |
| | | //} else { |
| | | // util.ResponseFormat(c, code.ServiceInsideError, result["data"]) |
| | | //} |
| | | } |
| | | |
| | | type DbTStatusVo struct { |
| | | Id string `json:"id"` |
| | | Enable int `json:"enable"` |
| | | } |
| | | |
| | | // @Security ApiKeyAuth |
| | | // @Summary 修改底库状态 |
| | | // @Description 修改同步或本地库底库状态 |
| | | // @Accept json |
| | | // @Produce json |
| | | // @Tags dbtable |
| | | // @Param obj body controllers.DbTStatusVo true "底库状态修改参数" |
| | | // @Success 200 {string} json "{"code":200, msg:"目录结构数据", success:true}" |
| | | // @Failure 500 {string} json "{"code":500, msg:"返回错误信息", success:false}" |
| | | // @Router /data/api-v/dbtable/updateDbTableStatus [POST] |
| | | func (dbt DbTableController) UpdateDbTableStatus(c *gin.Context) { |
| | | var ds DbTStatusVo |
| | | err := c.BindJSON(&ds) |
| | | if err !=nil || ds.Id == "" || (ds.Enable !=0 && ds.Enable !=1) { |
| | | util.ResponseFormat(c,code.RequestParamError,"参数有误") |
| | | return |
| | | } |
| | | |
| | | var dtApi dbapi.DbTableApi |
| | | dts, err := dtApi.DbtablesById([]string{ds.Id}) |
| | | if err !=nil || dts == nil { |
| | | util.ResponseFormat(c,code.RequestParamError,"底库不存在") |
| | | return |
| | | } |
| | | if ds.Enable == 1 { |
| | | str := dts[0].StartTime |
| | | etr := dts[0].EndTime |
| | | ct := time.Now() |
| | | st, _ := time.ParseInLocation("2006-01-02 15:04:05", str, time.Local) |
| | | b := false |
| | | if etr != "" { |
| | | et,_ := time.ParseInLocation("2006-01-02 15:04:05", etr, time.Local) |
| | | if et.After(ct) && st.Before(ct) { |
| | | b = true |
| | | } |
| | | } else { |
| | | if st.Before(ct) { |
| | | b = true |
| | | } |
| | | } |
| | | //b 为true才允许开启 |
| | | if !b { |
| | | util.ResponseFormat(c,code.UpdateFail,"当前不允许启用") |
| | | return |
| | | } |
| | | } |
| | | |
| | | b,_ := dtApi.UpdateDbTableStatus(ds.Id, ds.Enable) |
| | | if b { |
| | | util.ResponseFormat(c,code.UpdateSuccess,"更新成功") |
| | | } else { |
| | | util.ResponseFormat(c,code.ComError,"更新失败") |
| | | } |
| | | } |
| | | |
| | | func UpdateEndTime(id string) (flag bool) { |
| | |
| | | return flag |
| | | } |
| | | |
| | | // @Security ApiKeyAuth |
| | | // @Summary 添加底库 |
| | | // @Description 添加同步或本地库 |
| | | // @Accept json |
| | |
| | | } else { |
| | | dbtable.Enable = 0 |
| | | } |
| | | } else if st.Before(currentTime) && endTime == "" { |
| | | } else { |
| | | if st.Before(currentTime) { |
| | | dbtable.Enable = 1 |
| | | } else { |
| | | dbtable.Enable = 0 |
| | | } |
| | | } |
| | | |
| | | logger.Debug("AddDbTableInfo dbtable.Enable:",dbtable.Enable,",startTime:",startTime,",endTime:",endTime,",st:",st,",curTime:",currentTime) |
| | | |
| | | paramBody := util.Struct2Map(dbtable) |
| | | var tApi dbapi.DbTableApi |
| | |
| | | if b { |
| | | util.ResponseFormat(c,code.AddSuccess, data) |
| | | } else { |
| | | util.ResponseFormat(c,code.ComError,"新增失败") |
| | | util.ResponseFormat(c,code.ComError, data) |
| | | } |
| | | } |
| | | |
| | | // @Security ApiKeyAuth |
| | | // @Summary 删除底库 |
| | | // @Description 删除同步或本地库 |
| | | // @Accept x-www-form-urlencoded |