supplier-price.go 8.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285
  1. package api
  2. import (
  3. "box-cost/db/model"
  4. "box-cost/db/repo"
  5. "box-cost/log"
  6. "errors"
  7. "fmt"
  8. "time"
  9. "github.com/gin-gonic/gin"
  10. "go.mongodb.org/mongo-driver/bson"
  11. "go.mongodb.org/mongo-driver/bson/primitive"
  12. )
  13. // 供应商价格管理
  14. func SupplierPrice(r *GinRouter) {
  15. // // 创建供应商价格
  16. // r.POST("/supplier/mat/create", CreateSupplierPrice)
  17. // // 获取供应商价格列表
  18. // r.GET("/supplier/mat/list", GetSupplierPrices)
  19. // // 更新供应商价格
  20. // r.POST("/supplier/mat/update", UpdateSupplierPrice)
  21. // // 删除供应商价格
  22. // r.POST("/supplier/mat/delete/:id", DelSupplierPrice)
  23. //材料供应
  24. SupplierMatTable := "supplier-mats"
  25. CreateCRUD(r, "/supplier/mat", &CRUDOption{
  26. Collection: SupplierMatTable,
  27. NewModel: func(c *gin.Context, apictx *ApiSession) (interface{}, error) {
  28. entity := &model.SupplierPrice{}
  29. c.ShouldBindJSON(entity)
  30. if entity.ProductId == primitive.NilObjectID || entity.SupplierId == primitive.NilObjectID {
  31. return nil, fmt.Errorf("产品ID或供应商Id不能为空")
  32. }
  33. curr := &model.SupplierPrice{}
  34. ok, err := repo.RepoSeachDoc(apictx.CreateRepoCtx(), &repo.DocSearchOptions{
  35. CollectName: SupplierMatTable,
  36. Query: repo.Map{"productId": entity.ProductId, "supplierId": entity.SupplierId},
  37. Project: []string{"_id"},
  38. }, curr)
  39. if err != nil {
  40. return nil, err
  41. }
  42. if ok {
  43. return nil, fmt.Errorf("该材料已经在供应列表里面了")
  44. }
  45. entity.CreateTime = time.Now()
  46. entity.UpdateTime = time.Now()
  47. return entity, nil
  48. },
  49. EmtyModel: func(c *gin.Context, apictx *ApiSession) interface{} {
  50. return &model.SupplierPrice{}
  51. },
  52. JWT: true,
  53. OnUpdate: func(c *gin.Context, apictx *ApiSession, entity interface{}) {
  54. calc := entity.(*model.SupplierPrice)
  55. calc.UpdateTime = time.Now()
  56. },
  57. SearchFilter: func(c *gin.Context, apictx *ApiSession, query map[string]interface{}) map[string]interface{} {
  58. if query["supplierId"] != nil {
  59. query["supplierId"], _ = primitive.ObjectIDFromHex(query["supplierId"].(string))
  60. }
  61. return query
  62. },
  63. SearchPostProcess: func(page *repo.PageResult, c *gin.Context, apictx *ApiSession, query map[string]interface{}) (interface{}, error) {
  64. //查询材料对应的材料信息
  65. for _, mat := range page.List {
  66. _id, _ := mat["productId"].(primitive.ObjectID)
  67. matInfo := &model.Material{}
  68. repo.RepoSeachDoc(apictx.CreateRepoCtx(), &repo.DocSearchOptions{
  69. CollectName: repo.CollectionMaterial,
  70. Query: repo.Map{"_id": _id},
  71. }, matInfo)
  72. mat["matInfo"] = matInfo
  73. }
  74. return page, nil
  75. },
  76. SearchProject: []string{"price", "supplierId", "productId", "updateTime", "_id"},
  77. })
  78. SupplierCraftTable := "supplier-crafts"
  79. CreateCRUD(r, "/supplier/craft", &CRUDOption{
  80. Collection: SupplierCraftTable,
  81. NewModel: func(c *gin.Context, apictx *ApiSession) (interface{}, error) {
  82. entity := &model.SupplierPrice{}
  83. c.ShouldBindJSON(entity)
  84. if entity.ProductId == primitive.NilObjectID || entity.SupplierId == primitive.NilObjectID {
  85. return nil, fmt.Errorf("产品ID或供应商Id不能为空")
  86. }
  87. curr := &model.SupplierPrice{}
  88. ok, err := repo.RepoSeachDoc(apictx.CreateRepoCtx(), &repo.DocSearchOptions{
  89. CollectName: SupplierCraftTable,
  90. Query: repo.Map{"productId": entity.ProductId, "supplierId": entity.SupplierId},
  91. Project: []string{"_id"},
  92. }, curr)
  93. if err != nil {
  94. return nil, err
  95. }
  96. if ok {
  97. return nil, fmt.Errorf("该工艺已经在供应列表里面了")
  98. }
  99. entity.CreateTime = time.Now()
  100. entity.UpdateTime = time.Now()
  101. return entity, nil
  102. },
  103. EmtyModel: func(c *gin.Context, apictx *ApiSession) interface{} {
  104. return &model.SupplierPrice{}
  105. },
  106. JWT: true,
  107. OnUpdate: func(c *gin.Context, apictx *ApiSession, entity interface{}) {
  108. calc := entity.(*model.SupplierPrice)
  109. calc.UpdateTime = time.Now()
  110. },
  111. SearchFilter: func(c *gin.Context, apictx *ApiSession, query map[string]interface{}) map[string]interface{} {
  112. if query["supplierId"] != nil {
  113. query["supplierId"], _ = primitive.ObjectIDFromHex(query["supplierId"].(string))
  114. }
  115. return query
  116. },
  117. SearchPostProcess: func(page *repo.PageResult, c *gin.Context, apictx *ApiSession, query map[string]interface{}) (interface{}, error) {
  118. //查询材料对应的材料信息
  119. for _, mat := range page.List {
  120. _id, _ := mat["productId"].(primitive.ObjectID)
  121. craft := &model.Craft{}
  122. repo.RepoSeachDoc(apictx.CreateRepoCtx(), &repo.DocSearchOptions{
  123. CollectName: repo.CollectionCraft,
  124. Query: repo.Map{"_id": _id},
  125. }, craft)
  126. mat["craftInfo"] = craft
  127. }
  128. return page, nil
  129. },
  130. SearchProject: []string{"price", "supplierId", "productId", "updateTime", "_id"},
  131. })
  132. //添加计价方案
  133. SupplierCalcPriceColl := "supplier-calcprice"
  134. CreateCRUD(r, "/supplier/calc", &CRUDOption{
  135. Collection: SupplierCalcPriceColl,
  136. NewModel: func(c *gin.Context, apictx *ApiSession) (interface{}, error) {
  137. entity := &model.SupplierCalcPrice{}
  138. c.ShouldBindJSON(entity)
  139. if entity.SupplierId == primitive.NilObjectID {
  140. return nil, fmt.Errorf("供应商Id不能为空")
  141. }
  142. if entity.Calc == nil || len(entity.Calc.Category) < 1 {
  143. return nil, fmt.Errorf("计价方案参数错误")
  144. }
  145. calc := &model.SupplierCalcPrice{}
  146. ok, err := repo.RepoSeachDoc(apictx.CreateRepoCtx(),
  147. &repo.DocSearchOptions{CollectName: SupplierCalcPriceColl,
  148. Query: repo.Map{"calc.category": entity.Calc.Category}}, calc)
  149. if err != nil {
  150. return nil, err
  151. }
  152. if ok {
  153. return nil, fmt.Errorf("相同的分类计价方案只能有一个")
  154. }
  155. entity.CreateTime = time.Now()
  156. entity.UpdateTime = time.Now()
  157. return entity, nil
  158. },
  159. EmtyModel: func(c *gin.Context, apictx *ApiSession) interface{} {
  160. return &model.SupplierCalcPrice{}
  161. },
  162. JWT: true,
  163. OnUpdate: func(c *gin.Context, apictx *ApiSession, entity interface{}) {
  164. calc := entity.(*model.SupplierCalcPrice)
  165. calc.UpdateTime = time.Now()
  166. },
  167. SearchFilter: func(c *gin.Context, apictx *ApiSession, query map[string]interface{}) map[string]interface{} {
  168. if query["supplierId"] != nil {
  169. query["supplierId"], _ = primitive.ObjectIDFromHex(query["supplierId"].(string))
  170. }
  171. return query
  172. },
  173. SearchProject: []string{"calc", "supplierId", "updateTime", "_id"},
  174. })
  175. }
  176. // 创建供应商价格
  177. func CreateSupplierPrice(c *gin.Context, apictx *ApiSession) (interface{}, error) {
  178. var supplierprice model.SupplierPrice
  179. err := c.ShouldBindJSON(&supplierprice)
  180. if err != nil {
  181. fmt.Println(err)
  182. return nil, errors.New("参数错误!")
  183. }
  184. ctx := apictx.CreateRepoCtx()
  185. if supplierprice.SupplierId.Hex() == "" {
  186. return nil, errors.New("供应商id为空")
  187. }
  188. // if supplierprice.ProductId.Hex() == "" {
  189. // return nil, errors.New("供应产品id为空")
  190. // }
  191. // if supplierprice.PriceStrategy == nil {
  192. // return nil, errors.New("供应商价格策略为空")
  193. // }
  194. supplierprice.CreateTime = time.Now()
  195. supplierprice.UpdateTime = time.Now()
  196. result, err := repo.RepoAddDoc(ctx, repo.CollectionSupplierPrice, &supplierprice)
  197. return result, err
  198. }
  199. // 获取供应商价格信息
  200. func GetSupplierPrice(c *gin.Context, apictx *ApiSession) (interface{}, error) {
  201. supplierpriceId := c.Param("id")
  202. id, err := primitive.ObjectIDFromHex(supplierpriceId)
  203. if err != nil {
  204. return nil, errors.New("非法id")
  205. }
  206. var supplierprice model.SupplierPrice
  207. option := &repo.DocSearchOptions{
  208. CollectName: repo.CollectionSupplierPrice,
  209. Query: repo.Map{"_id": id},
  210. }
  211. found, err := repo.RepoSeachDoc(apictx.CreateRepoCtx(), option, &supplierprice)
  212. if !found || err != nil {
  213. log.Info(err)
  214. return nil, errors.New("数据未找到")
  215. }
  216. return supplierprice, nil
  217. }
  218. // 获取供应商价格列表
  219. func GetSupplierPrices(c *gin.Context, apictx *ApiSession) (interface{}, error) {
  220. page, size, query := UtilQueryPageSize(c)
  221. option := &repo.PageSearchOptions{
  222. CollectName: repo.CollectionSupplierPrice,
  223. Query: query,
  224. Page: page,
  225. Size: size,
  226. Sort: bson.M{"createTime": -1},
  227. }
  228. return repo.RepoPageSearch(apictx.CreateRepoCtx(), option)
  229. }
  230. // 更新供应商价格
  231. func UpdateSupplierPrice(c *gin.Context, apictx *ApiSession) (interface{}, error) {
  232. var supplierprice model.SupplierPrice
  233. err := c.ShouldBindJSON(&supplierprice)
  234. if err != nil {
  235. return nil, errors.New("参数错误")
  236. }
  237. if supplierprice.Id.Hex() == "" {
  238. return nil, errors.New("id的为空")
  239. }
  240. supplierprice.UpdateTime = time.Now()
  241. return repo.RepoUpdateSetDoc(apictx.CreateRepoCtx(), repo.CollectionSupplierPrice, supplierprice.Id.Hex(), &supplierprice)
  242. }
  243. // 删除供应商价格
  244. func DelSupplierPrice(c *gin.Context, apictx *ApiSession) (interface{}, error) {
  245. supplierpriceId := c.Param("id")
  246. if supplierpriceId == "" {
  247. return nil, errors.New("id为空")
  248. }
  249. return repo.RepoDeleteDoc(apictx.CreateRepoCtx(), repo.CollectionSupplierPrice, supplierpriceId)
  250. }