package work import ( "fmt" "zhiyuan/models" "zhiyuan/pkg/app" "zhiyuan/pkg/db" "zhiyuan/pkg/utils" "github.com/gin-gonic/gin" ) func WorkSiteProblemList(c *gin.Context) { var post map[string]interface{} var model models.MyWorkSiteProblem if err := c.ShouldBindJSON(&post); err != nil { //app.ErrorMsg(c, err.Error(), nil) //return } s := db.ModelQuery(db.Type(model), post, false) if utils.ToInt(c.Query("my")) != 0 { adminID := s.Param(c.GetInt("adminID")) s.Where = append(s.Where, fmt.Sprintf("(`worksite`.`manager_id`=%s OR `worksite`.`designer_id`=%s OR `worksite`.`salesman_id`=%s OR `worksite`.`project_manager_id`=%s OR `worksite`.`project_leader_id`=%s OR `worksite`.`servicer_id`=%s OR `worksite`.`quality_id`=%s OR `worksite`.`assistant_id`=%s OR `worksite`.`created_id`=%s OR FIND_IN_SET(%s, `worksite`.`admin_ids`))", adminID, adminID, adminID, adminID, adminID, adminID, adminID, adminID, adminID, adminID)) } deleted := model.DeletedField() if deleted != "" { s.Where = append(s.Where, fmt.Sprintf("`%s`.`%s` = 0", model.TableName(), deleted)) } if !model.ListPrivilege(c, post, &s) { app.ErrorMsg(c, "没有权限", nil) return } query, params := s.Query() list, err := db.QueryMap(query, params, nil) if err != nil { app.ErrorMsg(c, err.Error(), nil) return } if list == nil { list = make([]map[string]interface{}, 0) } data := gin.H{ "list": list, } if model.Count() { count, err := db.GetCount(s, nil) if err != nil { app.ErrorMsg(c, err.Error(), nil) return } data["count"] = count } app.Success(c, data) }