supplier-price.go 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342
  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. CreateCRUD(r, "/supplier/mat", &CRUDOption{
  25. Collection: repo.CollectionSupplierMatprice,
  26. NewModel: func(c *gin.Context, apictx *ApiSession) (interface{}, error) {
  27. entity := &model.SupplierPrice{}
  28. c.ShouldBindJSON(entity)
  29. if entity.ProductId == primitive.NilObjectID || entity.SupplierId == primitive.NilObjectID {
  30. return nil, fmt.Errorf("产品ID或供应商Id不能为空")
  31. }
  32. curr := &model.SupplierPrice{}
  33. ok, err := repo.RepoSeachDoc(apictx.CreateRepoCtx(), &repo.DocSearchOptions{
  34. CollectName: repo.CollectionSupplierMatprice,
  35. Query: repo.Map{"productId": entity.ProductId, "supplierId": entity.SupplierId},
  36. Project: []string{"_id"},
  37. }, curr)
  38. if err != nil {
  39. return nil, err
  40. }
  41. if ok {
  42. return nil, fmt.Errorf("该材料已经在供应列表里面了")
  43. }
  44. entity.CreateTime = time.Now()
  45. entity.UpdateTime = time.Now()
  46. return entity, nil
  47. },
  48. EmtyModel: func(c *gin.Context, apictx *ApiSession) interface{} {
  49. return &model.SupplierPrice{}
  50. },
  51. JWT: true,
  52. OnUpdate: func(c *gin.Context, apictx *ApiSession, entity interface{}) {
  53. calc := entity.(*model.SupplierPrice)
  54. calc.UpdateTime = time.Now()
  55. },
  56. SearchFilter: func(c *gin.Context, apictx *ApiSession, query map[string]interface{}) map[string]interface{} {
  57. if query["supplierId"] != nil {
  58. query["supplierId"], _ = primitive.ObjectIDFromHex(query["supplierId"].(string))
  59. }
  60. return query
  61. },
  62. SearchPostProcess: func(page *repo.PageResult, c *gin.Context, apictx *ApiSession, query map[string]interface{}) (interface{}, error) {
  63. //查询材料对应的材料信息
  64. for _, mat := range page.List {
  65. _id, _ := mat["productId"].(primitive.ObjectID)
  66. matInfo := &model.Material{}
  67. repo.RepoSeachDoc(apictx.CreateRepoCtx(), &repo.DocSearchOptions{
  68. CollectName: repo.CollectionMaterial,
  69. Query: repo.Map{"_id": _id},
  70. }, matInfo)
  71. mat["matInfo"] = matInfo
  72. }
  73. return page, nil
  74. },
  75. SearchProject: []string{"price", "supplierId", "productId", "updateTime", "_id"},
  76. })
  77. CreateCRUD(r, "/supplier/craft", &CRUDOption{
  78. Collection: repo.CollectionSupplierCraftprice,
  79. NewModel: func(c *gin.Context, apictx *ApiSession) (interface{}, error) {
  80. entity := &model.SupplierPrice{}
  81. c.ShouldBindJSON(entity)
  82. if entity.ProductId == primitive.NilObjectID || entity.SupplierId == primitive.NilObjectID {
  83. return nil, fmt.Errorf("产品ID或供应商Id不能为空")
  84. }
  85. curr := &model.SupplierPrice{}
  86. ok, err := repo.RepoSeachDoc(apictx.CreateRepoCtx(), &repo.DocSearchOptions{
  87. CollectName: repo.CollectionSupplierCraftprice,
  88. Query: repo.Map{"productId": entity.ProductId, "supplierId": entity.SupplierId},
  89. Project: []string{"_id"},
  90. }, curr)
  91. if err != nil {
  92. return nil, err
  93. }
  94. if ok {
  95. return nil, fmt.Errorf("该工艺已经在供应列表里面了")
  96. }
  97. entity.CreateTime = time.Now()
  98. entity.UpdateTime = time.Now()
  99. return entity, nil
  100. },
  101. EmtyModel: func(c *gin.Context, apictx *ApiSession) interface{} {
  102. return &model.SupplierPrice{}
  103. },
  104. JWT: true,
  105. OnUpdate: func(c *gin.Context, apictx *ApiSession, entity interface{}) {
  106. calc := entity.(*model.SupplierPrice)
  107. calc.UpdateTime = time.Now()
  108. },
  109. SearchFilter: func(c *gin.Context, apictx *ApiSession, query map[string]interface{}) map[string]interface{} {
  110. if query["supplierId"] != nil {
  111. query["supplierId"], _ = primitive.ObjectIDFromHex(query["supplierId"].(string))
  112. }
  113. return query
  114. },
  115. SearchPostProcess: func(page *repo.PageResult, c *gin.Context, apictx *ApiSession, query map[string]interface{}) (interface{}, error) {
  116. //查询材料对应的材料信息
  117. for _, mat := range page.List {
  118. _id, _ := mat["productId"].(primitive.ObjectID)
  119. craft := &model.Craft{}
  120. repo.RepoSeachDoc(apictx.CreateRepoCtx(), &repo.DocSearchOptions{
  121. CollectName: repo.CollectionCraft,
  122. Query: repo.Map{"_id": _id},
  123. }, craft)
  124. mat["craftInfo"] = craft
  125. }
  126. return page, nil
  127. },
  128. SearchProject: []string{"price", "supplierId", "productId", "updateTime", "_id"},
  129. })
  130. CreateCRUD(r, "/supplier/product", &CRUDOption{
  131. Collection: repo.CollectionSupplierProductprice,
  132. NewModel: func(c *gin.Context, apictx *ApiSession) (interface{}, error) {
  133. entity := &model.SupplierPrice{}
  134. c.ShouldBindJSON(entity)
  135. if entity.ProductId == primitive.NilObjectID || entity.SupplierId == primitive.NilObjectID {
  136. return nil, fmt.Errorf("产品ID或供应商Id不能为空")
  137. }
  138. curr := &model.SupplierPrice{}
  139. ok, err := repo.RepoSeachDoc(apictx.CreateRepoCtx(), &repo.DocSearchOptions{
  140. CollectName: repo.CollectionSupplierProductprice,
  141. Query: repo.Map{"productId": entity.ProductId, "supplierId": entity.SupplierId},
  142. Project: []string{"_id"},
  143. }, curr)
  144. if err != nil {
  145. return nil, err
  146. }
  147. if ok {
  148. return nil, fmt.Errorf("该工序已经在供应列表里面了")
  149. }
  150. entity.CreateTime = time.Now()
  151. entity.UpdateTime = time.Now()
  152. return entity, nil
  153. },
  154. EmtyModel: func(c *gin.Context, apictx *ApiSession) interface{} {
  155. return &model.SupplierPrice{}
  156. },
  157. JWT: true,
  158. OnUpdate: func(c *gin.Context, apictx *ApiSession, entity interface{}) {
  159. calc := entity.(*model.SupplierPrice)
  160. calc.UpdateTime = time.Now()
  161. },
  162. SearchFilter: func(c *gin.Context, apictx *ApiSession, query map[string]interface{}) map[string]interface{} {
  163. if query["supplierId"] != nil {
  164. query["supplierId"], _ = primitive.ObjectIDFromHex(query["supplierId"].(string))
  165. }
  166. return query
  167. },
  168. SearchPostProcess: func(page *repo.PageResult, c *gin.Context, apictx *ApiSession, query map[string]interface{}) (interface{}, error) {
  169. //查询材料对应的材料信息
  170. for _, ps := range page.List {
  171. _id, _ := ps["productId"].(primitive.ObjectID)
  172. process := &model.Product{}
  173. repo.RepoSeachDoc(apictx.CreateRepoCtx(), &repo.DocSearchOptions{
  174. CollectName: repo.CollectionProduct,
  175. Query: repo.Map{"_id": _id},
  176. }, process)
  177. ps["processInfo"] = process
  178. }
  179. return page, nil
  180. },
  181. SearchProject: []string{"price", "supplierId", "productId", "updateTime", "_id"},
  182. })
  183. //添加计价方案
  184. SupplierCalcPriceColl := "supplier-calcprice"
  185. CreateCRUD(r, "/supplier/calc", &CRUDOption{
  186. Collection: SupplierCalcPriceColl,
  187. NewModel: func(c *gin.Context, apictx *ApiSession) (interface{}, error) {
  188. entity := &model.SupplierCalcPrice{}
  189. c.ShouldBindJSON(entity)
  190. if entity.SupplierId == primitive.NilObjectID {
  191. return nil, fmt.Errorf("供应商Id不能为空")
  192. }
  193. if entity.Calc == nil || len(entity.Calc.Category) < 1 {
  194. return nil, fmt.Errorf("计价方案参数错误")
  195. }
  196. calc := &model.SupplierCalcPrice{}
  197. ok, err := repo.RepoSeachDoc(apictx.CreateRepoCtx(),
  198. &repo.DocSearchOptions{CollectName: SupplierCalcPriceColl,
  199. Query: repo.Map{"calc.category": entity.Calc.Category, "supplierId": entity.SupplierId}}, calc)
  200. if err != nil {
  201. return nil, err
  202. }
  203. if ok {
  204. return nil, fmt.Errorf("相同的分类计价方案只能有一个")
  205. }
  206. entity.CreateTime = time.Now()
  207. entity.UpdateTime = time.Now()
  208. return entity, nil
  209. },
  210. EmtyModel: func(c *gin.Context, apictx *ApiSession) interface{} {
  211. return &model.SupplierCalcPrice{}
  212. },
  213. JWT: true,
  214. OnUpdate: func(c *gin.Context, apictx *ApiSession, entity interface{}) {
  215. calc := entity.(*model.SupplierCalcPrice)
  216. calc.UpdateTime = time.Now()
  217. },
  218. SearchFilter: func(c *gin.Context, apictx *ApiSession, query map[string]interface{}) map[string]interface{} {
  219. if query["supplierId"] != nil {
  220. query["supplierId"], _ = primitive.ObjectIDFromHex(query["supplierId"].(string))
  221. }
  222. return query
  223. },
  224. SearchProject: []string{"calc", "supplierId", "updateTime", "_id"},
  225. })
  226. }
  227. // 创建供应商价格
  228. func CreateSupplierPrice(c *gin.Context, apictx *ApiSession) (interface{}, error) {
  229. var supplierprice model.SupplierPrice
  230. err := c.ShouldBindJSON(&supplierprice)
  231. if err != nil {
  232. fmt.Println(err)
  233. return nil, errors.New("参数错误!")
  234. }
  235. ctx := apictx.CreateRepoCtx()
  236. if supplierprice.SupplierId.Hex() == "" {
  237. return nil, errors.New("供应商id为空")
  238. }
  239. // if supplierprice.ProductId.Hex() == "" {
  240. // return nil, errors.New("供应产品id为空")
  241. // }
  242. // if supplierprice.PriceStrategy == nil {
  243. // return nil, errors.New("供应商价格策略为空")
  244. // }
  245. supplierprice.CreateTime = time.Now()
  246. supplierprice.UpdateTime = time.Now()
  247. result, err := repo.RepoAddDoc(ctx, repo.CollectionSupplierPrice, &supplierprice)
  248. return result, err
  249. }
  250. // 获取供应商价格信息
  251. func GetSupplierPrice(c *gin.Context, apictx *ApiSession) (interface{}, error) {
  252. supplierpriceId := c.Param("id")
  253. id, err := primitive.ObjectIDFromHex(supplierpriceId)
  254. if err != nil {
  255. return nil, errors.New("非法id")
  256. }
  257. var supplierprice model.SupplierPrice
  258. option := &repo.DocSearchOptions{
  259. CollectName: repo.CollectionSupplierPrice,
  260. Query: repo.Map{"_id": id},
  261. }
  262. found, err := repo.RepoSeachDoc(apictx.CreateRepoCtx(), option, &supplierprice)
  263. if !found || err != nil {
  264. log.Info(err)
  265. return nil, errors.New("数据未找到")
  266. }
  267. return supplierprice, nil
  268. }
  269. // 获取供应商价格列表
  270. func GetSupplierPrices(c *gin.Context, apictx *ApiSession) (interface{}, error) {
  271. page, size, query := UtilQueryPageSize(c)
  272. option := &repo.PageSearchOptions{
  273. CollectName: repo.CollectionSupplierPrice,
  274. Query: query,
  275. Page: page,
  276. Size: size,
  277. Sort: bson.M{"createTime": -1},
  278. }
  279. return repo.RepoPageSearch(apictx.CreateRepoCtx(), option)
  280. }
  281. // 更新供应商价格
  282. func UpdateSupplierPrice(c *gin.Context, apictx *ApiSession) (interface{}, error) {
  283. var supplierprice model.SupplierPrice
  284. err := c.ShouldBindJSON(&supplierprice)
  285. if err != nil {
  286. return nil, errors.New("参数错误")
  287. }
  288. if supplierprice.Id.Hex() == "" {
  289. return nil, errors.New("id的为空")
  290. }
  291. supplierprice.UpdateTime = time.Now()
  292. return repo.RepoUpdateSetDoc(apictx.CreateRepoCtx(), repo.CollectionSupplierPrice, supplierprice.Id.Hex(), &supplierprice)
  293. }
  294. // 删除供应商价格
  295. func DelSupplierPrice(c *gin.Context, apictx *ApiSession) (interface{}, error) {
  296. supplierpriceId := c.Param("id")
  297. if supplierpriceId == "" {
  298. return nil, errors.New("id为空")
  299. }
  300. return repo.RepoDeleteDoc(apictx.CreateRepoCtx(), repo.CollectionSupplierPrice, supplierpriceId)
  301. }