| | |
| | | "github.com/gin-gonic/gin" |
| | | "github.com/shopspring/decimal" |
| | | "github.com/xuri/excelize/v2" |
| | | "google.golang.org/grpc" |
| | | "google.golang.org/grpc/credentials/insecure" |
| | | "gorm.io/gorm" |
| | | "os" |
| | | "sort" |
| | | "strconv" |
| | | "strings" |
| | | "time" |
| | | "wms/conf" |
| | | "wms/constvar" |
| | | "wms/extend/code" |
| | | "wms/extend/util" |
| | |
| | | "wms/pkg/logx" |
| | | "wms/pkg/structx" |
| | | "wms/proto/client" |
| | | "wms/proto/init_client" |
| | | "wms/proto/inventory_order" |
| | | "wms/proto/product_inventory" |
| | | "wms/proto/purchase_wms" |
| | | "wms/proto/supplier" |
| | | "wms/request" |
| | | "wms/service" |
| | | "wms/utils/http" |
| | | "wms/utils/upload" |
| | | ) |
| | |
| | | } |
| | | |
| | | return nil |
| | | } |
| | | |
| | | // GetOperationInfo |
| | | // @Tags 入库/出库 |
| | | // @Summary 入库/出库列表 |
| | | // @Produce application/json |
| | | // |
| | | // @Param id path string true "id" |
| | | // |
| | | // @Success 200 {object} util.Response "成功" |
| | | // @Router /api-wms/v1/operation/getOperationInfo/{id} [get] |
| | | func (slf OperationController) GetOperationInfo(c *gin.Context) { |
| | | number := c.Param("id") |
| | | if number == "" { |
| | | util.ResponseFormat(c, code.RequestParamError, "参数解析失败,参数不能为空") |
| | | return |
| | | } |
| | | id, _ := strconv.Atoi(number) |
| | | operation, err := models.NewOperationSearch().SetID(id).SetPreload(true).First() |
| | | if err != nil { |
| | | util.ResponseFormat(c, code.RequestParamError, err.Error()) |
| | | return |
| | | } |
| | | util.ResponseFormat(c, code.Success, operation) |
| | | } |
| | | |
| | | // List |
| | |
| | | util.ResponseFormat(c, code.RequestError, "该出入库信息无法完成") |
| | | return |
| | | } |
| | | if err := models.WithTransaction(func(tx *gorm.DB) error { |
| | | err = models.WithTransaction(func(tx *gorm.DB) error { |
| | | |
| | | if err := models.NewOperationSearch().SetOrm(tx).SetID(id).Update(&models.Operation{Status: constvar.OperationStatus_Finish, AuditDate: time.Now().Format("2006-01-02 15:04:05")}); err != nil { |
| | | return err |
| | |
| | | return err |
| | | } |
| | | } |
| | | if operation.SourceNumber != "" { |
| | | go UpdatePurchaseStatus(operation.SourceNumber) |
| | | if operation.Source != "" { |
| | | go UpdatePurchaseStatus(operation.Source, operation.SourceNumber) |
| | | } |
| | | |
| | | } |
| | |
| | | } |
| | | locAmount, res := models.NewLocationProductAmountSearch(). |
| | | SetProductId(v.ID). |
| | | SetLocationId(operation.ToLocationID). |
| | | SetLocationId(operation.FromLocationID). |
| | | FirstRes() |
| | | if res.Error != nil { |
| | | return err |
| | | if res.Error == gorm.ErrRecordNotFound { |
| | | return errors.New("当前仓库没有该产品,请先入库") |
| | | } |
| | | return res.Error |
| | | } |
| | | if locAmount.Amount.LessThan(value) { |
| | | return errors.New(fmt.Sprintf("产品:%v,库存:%v,出库:%v,数量不够,无法完成出库操作", v.Name, v.Amount.String(), value.String())) |
| | |
| | | return err |
| | | } |
| | | } |
| | | if operation.SourceNumber != "" { |
| | | go UpdateSalesDetailStatus(operation.SourceNumber) |
| | | if operation.Source != "" { |
| | | go UpdateOutStatus(operation.Source, operation.Number, 4) |
| | | } |
| | | } |
| | | |
| | |
| | | } |
| | | } |
| | | return nil |
| | | }); err != nil { |
| | | }) |
| | | if err != nil { |
| | | util.ResponseFormat(c, code.RequestError, err.Error()) |
| | | return |
| | | } |
| | |
| | | |
| | | func AddMoveHistory(operationList []*models.Operation, db *gorm.DB) error { |
| | | var histories []*models.MoveHistory |
| | | operationMap := make(map[int]*models.Operation, len(operationList)) |
| | | for _, operation := range operationList { |
| | | for _, v := range operation.Details { |
| | | history := &models.MoveHistory{ |
| | |
| | | OperationTypeId: operation.OperationTypeId, |
| | | OperationTypeName: operation.OperationTypeName, |
| | | OperationId: operation.Id, |
| | | ProductId: v.ProductId, |
| | | ProductName: v.Product.Name, |
| | | Amount: v.Amount, |
| | | Unit: v.Product.Unit, |
| | |
| | | } |
| | | histories = append(histories, history) |
| | | } |
| | | operationMap[operation.Id] = operation |
| | | } |
| | | if err := db.Model(&models.MoveHistory{}).Create(&histories).Error; err != nil { |
| | | return err |
| | | } |
| | | for _, history := range histories { |
| | | service.AddNewHistoryReportRecord(history, operationMap[history.OperationId]) |
| | | } |
| | | return nil |
| | | } |
| | | |
| | | var ( |
| | | ProductInventoryServiceConn *grpc.ClientConn |
| | | PurchaseServiceConn *grpc.ClientConn |
| | | ) |
| | | //var ( |
| | | // ProductInventoryServiceConn *grpc.ClientConn |
| | | // PurchaseServiceConn *grpc.ClientConn |
| | | //) |
| | | // |
| | | //func InitProductInventoryServiceConn() { |
| | | // var err error |
| | | // ProductInventoryServiceConn, err = grpc.Dial(conf.GrpcServerConf.CrmAddr, grpc.WithTransportCredentials(insecure.NewCredentials())) |
| | | // if err != nil { |
| | | // logx.Errorf("grpc dial product service error: %v", err.Error()) |
| | | // return |
| | | // } |
| | | // PurchaseServiceConn, err = grpc.Dial(conf.GrpcServerConf.SrmAddr, grpc.WithTransportCredentials(insecure.NewCredentials())) |
| | | // if err != nil { |
| | | // logx.Errorf("grpc dial product service error: %v", err.Error()) |
| | | // return |
| | | // } |
| | | //} |
| | | // |
| | | //func CloseProductInventoryServiceConn() { |
| | | // if ProductInventoryServiceConn != nil { |
| | | // ProductInventoryServiceConn.Close() |
| | | // } |
| | | // if PurchaseServiceConn != nil { |
| | | // PurchaseServiceConn.Close() |
| | | // } |
| | | //} |
| | | |
| | | func InitProductInventoryServiceConn() { |
| | | var err error |
| | | ProductInventoryServiceConn, err = grpc.Dial(conf.GrpcServerConf.CrmAddr, grpc.WithTransportCredentials(insecure.NewCredentials())) |
| | | if err != nil { |
| | | logx.Errorf("grpc dial product service error: %v", err.Error()) |
| | | return |
| | | func UpdateOutStatus(source, number string, status int64) { |
| | | if source == "CRM" { |
| | | cl := product_inventory.NewProductInventoryServiceClient(init_client.CrmConn) |
| | | _, err := cl.UpdateSalesDetailStatus(context.Background(), &product_inventory.UpdateSalesDetailStatusRequest{ |
| | | Number: number, |
| | | SalesDetailStatus: "已出库", |
| | | }) |
| | | if err != nil { |
| | | logx.Errorf("grpc dial UpdateSalesDetailStatus service error: %v", err) |
| | | } |
| | | } |
| | | PurchaseServiceConn, err = grpc.Dial(conf.GrpcServerConf.SrmAddr, grpc.WithTransportCredentials(insecure.NewCredentials())) |
| | | if err != nil { |
| | | logx.Errorf("grpc dial product service error: %v", err.Error()) |
| | | return |
| | | if source == "APS_APPLY_MATERIAL" { |
| | | cl := inventory_order.NewInventoryOrderServiceClient(init_client.ApsConn) |
| | | _, err := cl.UpdateMaterialApplyStatus(context.Background(), &inventory_order.UpdateMaterialApplyStatusRequest{ |
| | | Number: number, |
| | | Status: status, |
| | | }) |
| | | if err != nil { |
| | | logx.Errorf("grpc dial UpdateSalesDetailStatus service error: %v", err) |
| | | } |
| | | } |
| | | } |
| | | |
| | | func CloseProductInventoryServiceConn() { |
| | | if ProductInventoryServiceConn != nil { |
| | | ProductInventoryServiceConn.Close() |
| | | } |
| | | if PurchaseServiceConn != nil { |
| | | PurchaseServiceConn.Close() |
| | | } |
| | | } |
| | | |
| | | func UpdateSalesDetailStatus(number string) { |
| | | client := product_inventory.NewProductInventoryServiceClient(ProductInventoryServiceConn) |
| | | _, err := client.UpdateSalesDetailStatus(context.Background(), &product_inventory.UpdateSalesDetailStatusRequest{ |
| | | Number: number, |
| | | SalesDetailStatus: "已出库", |
| | | }) |
| | | if err != nil { |
| | | logx.Errorf("grpc dial UpdateSalesDetailStatus service error: %v", err) |
| | | } |
| | | } |
| | | |
| | | func UpdatePurchaseStatus(number string) { |
| | | client := purchase_wms.NewPurchaseServiceClient(PurchaseServiceConn) |
| | | _, err := client.UpdatePurchaseStatus(context.Background(), &purchase_wms.UpdatePurchaseStatusRequest{Number: number}) |
| | | if err != nil { |
| | | logx.Errorf("grpc dial UpdatePurchaseStatus service error: %v", err) |
| | | func UpdatePurchaseStatus(source, number string) { |
| | | if source == "SRM_PURCHASE" { |
| | | cl := purchase_wms.NewPurchaseServiceClient(init_client.SrmConn) |
| | | _, err := cl.UpdatePurchaseStatus(context.Background(), &purchase_wms.UpdatePurchaseStatusRequest{Number: number}) |
| | | if err != nil { |
| | | logx.Errorf("grpc dial UpdatePurchaseStatus service error: %v", err) |
| | | } |
| | | } |
| | | } |
| | | |
| | |
| | | if err := models.NewOperationSearch().SetID(operation.Id).Save(operation); err != nil { |
| | | util.ResponseFormat(c, code.SaveFail, err.Error()) |
| | | return |
| | | } |
| | | //更新aps物料申请状态 |
| | | if operation.Source == "APS_APPLY_MATERIAL" { |
| | | go UpdateOutStatus(operation.Source, operation.Number, 3) |
| | | } |
| | | util.ResponseFormat(c, code.Success, "操作成功") |
| | | } |
| | |
| | | // |
| | | // @Router /api-wms/v1/operation/getSupplierList [get] |
| | | func (slf OperationController) GetSupplierList(c *gin.Context) { |
| | | cli := supplier.NewSupplierServiceClient(supplier.SupplierConn) |
| | | cli := supplier.NewSupplierServiceClient(init_client.SrmConn) |
| | | resp, err := cli.GetSupplierList(c, &supplier.SupplierListRequest{Status: 1}) |
| | | if err != nil { |
| | | util.ResponseFormat(c, code.RequestParamError, "grpc调用失败:"+err.Error()) |
| | |
| | | // |
| | | // @Router /api-wms/v1/operation/getClientList [get] |
| | | func (slf OperationController) GetClientList(c *gin.Context) { |
| | | cli := client.NewClientServiceClient(client.ClientConn) |
| | | cli := client.NewClientServiceClient(init_client.CrmConn) |
| | | resp, err := cli.GetClientList(c, &client.ClientListRequest{}) |
| | | if err != nil { |
| | | util.ResponseFormat(c, code.RequestParamError, "grpc调用失败:"+err.Error()) |