package controllers import ( "fmt" "github.com/gin-gonic/gin" "wms/constvar" "wms/extend/code" "wms/extend/util" "wms/models" "wms/request" ) type LocationProductAmountController struct { } // List // @Tags 库存盘点 // @Summary 库存盘点列表 // @Produce application/json // @Param object body request.PageInfo true "查询参数" // @Success 200 {object} util.Response "成功" // @Router /api-wms/v1/locationProduct/list [post] func (slf LocationProductAmountController) List(c *gin.Context) { var params request.PageInfo if err := c.BindJSON(¶ms); err != nil { util.ResponseFormat(c, code.RequestParamError, "参数解析失败,数据类型错误:"+err.Error()) return } if params.Check() { util.ResponseFormat(c, code.RequestParamError, "参数异常") return } search := models.NewLocationProductAmountSearch() search.SetPage(params.Page, params.PageSize) search.Orm = search.Orm.Model(&models.LocationProductAmountWithOperation{}).Table("wms_location_product_amount").Select("wms_location_product_amount.*,wms_operation.amount as adjust_amount").InnerJoins("inner join wms_location_product on wms_location_product.id=wms_location_product_amount.location_product_id").InnerJoins("inner join wms_operation_details on wms_operation_details.product_id=wms_location_product.product_id").InnerJoins("inner join wms_operation on wms_operation.id=wms_operation_details.operation_id").Where("wms_operation.base_operation_type=?", constvar.BaseOperationTypeAdjust) var ( records = make([]*models.ResponseDisuseList, 0) total int64 ) if err := search.Orm.Count(&total).Error; err != nil { util.ResponseFormat(c, code.RequestError, fmt.Errorf("find count err: %v", err)) return } search.Orm = search.Orm.Preload("LocationProduct").Preload("LocationProduct.Location").Preload("LocationProduct.Product") if params.Page*params.PageSize > 0 { search.Orm = search.Orm.Offset((params.Page - 1) * params.PageSize).Limit(params.PageSize) } if err := search.Orm.Find(&records).Error; err != nil { util.ResponseFormat(c, code.RequestError, fmt.Errorf("find count err: %v", err)) return } util.ResponseFormatListWithPage(c, code.Success, records, int(total), params.Page, params.PageSize) } // Add // @Tags 库存盘点 // @Summary 添加库存盘点信息 // @Produce application/json // @Param object body request.AddLocationProductAmount true "入库/出库信息" // @Success 200 {object} util.Response "成功" // @Router /api-wms/v1/operation/operation [post] //func (slf LocationProductAmountController) Add(c *gin.Context) { // var reqParams request.AddLocationProductAmount // if err := c.BindJSON(&reqParams); err != nil { // util.ResponseFormat(c, code.RequestParamError, "参数解析失败,数据类型错误") // return // } // if reqParams.LocationProductAmountId==0 { // util.ResponseFormat(c, code.RequestParamError, "参数异常,locationProductAmountId为0") // return // } // locAmount:=models.LocationProductAmount{ // LocationProductId: reqParams.LocationProductAmountId // } // operationType, err := models.NewOperationTypeSearch().SetID(uint(params.OperationTypeId)).First() // if err != nil { // util.ResponseFormat(c, code.RequestParamError, err.Error()) // return // } // ////// // if location, err := models.NewLocationSearch().SetType(int(constvar.LocationTypeCustomer)).First(); err != nil { // return err // } else { // params.ToLocationID = location.Id // } // // // params.Status = constvar.OperationStatus_Ready // params.Number = strconv.FormatInt(time.Now().Unix(), 10) // params.BaseOperationType = operationType.BaseOperationType // if err := models.NewOperationSearch().Create(¶ms); err != nil { // logx.Errorf("Operation create err: %v", err) // util.ResponseFormat(c, code.SaveFail, "添加失败:"+err.Error()) // return // } // util.ResponseFormat(c, code.Success, "添加成功") //}