From 2d911d76bffda47005f8a30eb8f3719316bf43c9 Mon Sep 17 00:00:00 2001 From: zhangqian <zhangqian@123.com> Date: 星期三, 26 六月 2024 16:29:47 +0800 Subject: [PATCH] update doc --- controllers/report_forms_controller.go | 240 ++++++++++++++++++++++++++++++++++++----------------------- 1 files changed, 147 insertions(+), 93 deletions(-) diff --git a/controllers/report_forms_controller.go b/controllers/report_forms_controller.go index 03cc2b0..5f907fa 100644 --- a/controllers/report_forms_controller.go +++ b/controllers/report_forms_controller.go @@ -1,7 +1,6 @@ package controllers import ( - "fmt" "github.com/gin-gonic/gin" "github.com/shopspring/decimal" "net/url" @@ -9,10 +8,8 @@ "wms/constvar" "wms/extend/code" "wms/extend/util" - "wms/models" "wms/pkg/logx" "wms/request" - "wms/response" "wms/service" "wms/task" ) @@ -88,11 +85,6 @@ return } - if err != nil { - util.ResponseFormat(c, code.RequestParamError, "瀵煎嚭澶辫触") - return - } - fileContentDisposition := "attachment;filename=\"" + url.QueryEscape(filename) + "\"" c.Header("Content-Type", "application/xlsx") c.Header("Content-Disposition", fileContentDisposition) @@ -102,10 +94,11 @@ // GetHistory // @Tags 鎶ヨ〃 -// @Summary 鑾峰彇鍘嗗彶淇℃伅 +// @Summary 鑾峰彇鍑哄叆搴撴槑缁� // @Produce application/json +// @Param Authorization header string true "token" // @Param object body request.GetInventoryHistory true "鏌ヨ鍙傛暟" -// @Success 200 {object} util.ResponseList{data=[]response.InventoryHistory} "鎴愬姛" +// @Success 200 {object} util.ResponseList{data=[]models.MoveHistory} "鎴愬姛" // @Router /api-wms/v1/forms/getHistory [post] func (slf ReportFormsController) GetHistory(c *gin.Context) { slf.GetHistoryNew(c) @@ -195,57 +188,69 @@ util.ResponseFormat(c, code.RequestParamError, "鍙傛暟瑙f瀽澶辫触锛屾暟鎹被鍨嬮敊璇�") return } - //鑾峰彇鎿嶄綔璇︽儏 - detailsSearch := models.NewMoveHistorySearch() - var ( - result []*response.InventoryHistory - total uint64 - ids []int - err error - ) - if params.KeyWord != "" { - ids, total, err = service.SearchHistoryReport(params.KeyWord, params.BaseOperationType, params.Page, params.PageSize) - if err != nil { - util.ResponseFormat(c, code.InternalError, err.Error()) - return - } - if len(ids) == 0 { - util.ResponseFormatList(c, code.Success, result, 0) - return - } + + historyFormsService := service.NewHistoryFormsService() + result, err := historyFormsService.Query(params) + if err != nil { + util.ResponseFormat(c, code.InternalError, "鍐呴儴閿欒") + return } - detailsSearch.Orm = detailsSearch.Orm.Model(&models.MoveHistory{}). - Select("number, updated_at as date, product_name as product_name, from_location_id, operation_id,to_location_id, amount, " + - "unit, operator as contacted_name, base_operation_type, weight, product_id, from_location, to_location, operation_type_name, weight").Order("id desc") - if len(ids) > 0 { - detailsSearch.Orm = detailsSearch.Orm.Where("id in ?", ids) - } - if params.BaseOperationType != 0 { - detailsSearch.Orm = detailsSearch.Orm.Where("base_operation_type = ?", params.BaseOperationType) - } - var t int64 - err = detailsSearch.Orm.Count(&t).Error + total, err := historyFormsService.Count(params) if err != nil { - util.ResponseFormat(c, code.RequestParamError, fmt.Errorf("鏌ヨ鎬绘潯鏁板け璐�: %v", err)) + util.ResponseFormat(c, code.InternalError, "鍐呴儴閿欒") return } - total = uint64(t) - if params.Page*params.PageSize > 0 { - detailsSearch.Orm = detailsSearch.Orm.Offset((params.Page - 1) * params.PageSize).Limit(params.PageSize) - } - err = detailsSearch.Orm.Find(&result).Error - if err != nil { - util.ResponseFormat(c, code.RequestParamError, fmt.Errorf("鏌ヨ鎿嶄綔鏄庣粏澶辫触: %v", err)) - return - } + util.ResponseFormatList(c, code.Success, result, int(total)) +} + +// DownloadHistory +// @Tags 鎶ヨ〃 +// @Summary 涓嬭浇鍑哄叆搴撴槑缁嗘姤琛� +// @Produce application/json +// @Param Authorization header string true "token" +// @Param object body request.GetInventoryHistory true "鏌ヨ鍙傛暟" +// @Success 200 {object} util.ResponseList{data=[]models.MoveHistory} "鎴愬姛" +// @Router /api-wms/v1/forms/downloadHistory [post] +func (slf ReportFormsController) DownloadHistory(c *gin.Context) { + var params request.GetInventoryHistory + if err := c.BindJSON(¶ms); err != nil { + util.ResponseFormat(c, code.RequestParamError, "鍙傛暟瑙f瀽澶辫触锛屾暟鎹被鍨嬮敊璇�") + return + } + + if params.BaseOperationType == 0 { + util.ResponseFormat(c, code.RequestParamError, "鍩虹鎿嶄綔绫诲瀷涓嶈兘涓虹┖") + return + } + + historyFormsService := service.NewHistoryFormsService() + list, err := historyFormsService.FetchAll(params) + if err != nil { + logx.Errorf("DownloadHistory FetchAll err:%v", err) + util.ResponseFormat(c, code.InternalError, "鏌ヨ澶辫触") + return + } + filename, err := historyFormsService.Export(list, params) + if err != nil { + logx.Errorf("DownloadHistory Export err:%v", err) + util.ResponseFormat(c, code.InternalError, "瀵煎嚭鏁版嵁鍒版枃浠跺け璐�") + return + } + + fileContentDisposition := "attachment;filename=\"" + url.QueryEscape(filename) + "\"" + c.Header("Content-Type", "application/xlsx") + c.Header("Content-Disposition", fileContentDisposition) + c.File(filename) + defer os.Remove(filename) } // GetLocationForms // @Tags 鎶ヨ〃 // @Summary 鑾峰彇浣嶇疆鎶ヨ〃 // @Produce application/json +// @Param Authorization header string true "token" // @Param object body request.GetLocationForms true "鏌ヨ鍙傛暟" // @Success 200 {object} util.ResponseList{data=[]response.LocationForms} "鎴愬姛" // @Router /api-wms/v1/forms/getLocationForms [post] @@ -255,52 +260,57 @@ util.ResponseFormat(c, code.RequestParamError, "鍙傛暟瑙f瀽澶辫触锛屾暟鎹被鍨嬮敊璇�") return } - ids := make([]int, 0) - if params.LocationId != 0 { - ids = append(ids, params.LocationId) - } else { - //鏌ヨ浣嶇疆 - locations, err := models.NewLocationSearch().SetJointName(params.WareHouseCode).SetType(3).FindAll() - if err != nil { - util.ResponseFormat(c, code.RequestParamError, "鏌ヨ浣嶇疆澶辫触") - return - } - for _, location := range locations { - ids = append(ids, location.Id) - } - } - var ( - amounts []*models.LocationProductAmount - total uint64 - totalInt64 int64 - err error - ) - if params.KeyWord != "" { - amounts, total, err = service.SearchLocationReport(params.KeyWord, params.Page, params.PageSize) - } else { - amounts, totalInt64, err = models.NewLocationProductAmountSearch().SetPage(params.Page, params.PageSize).SetPreload(true).SetKeyword(params.KeyWord).SetProductId(params.ProductId).SetLocationIds(ids).FindByPage() - if err != nil { - util.ResponseFormat(c, code.RequestParamError, "鏌ヨ鏁伴噺澶辫触") - return - } - total = uint64(totalInt64) - } - var result []response.LocationForms - for _, amount := range amounts { - var resp response.LocationForms - resp.Amount = amount.Amount - resp.LocationId = amount.LocationId - resp.LocationName = amount.Location.Name - resp.ProduceId = amount.Product.ID - resp.ProductName = amount.Product.Name - resp.ProductTypeName = amount.ProductCategory.Name - resp.Unit = amount.Product.Unit - resp.Value = resp.Amount.Mul(amount.Product.Cost) - result = append(result, resp) + locationFormsService := service.NewLocationFormsService() + total, err := locationFormsService.Count(params) + if err != nil { + logx.Errorf("GetLocationForms count err:%v", err) + util.ResponseFormat(c, code.InternalError, "鏌ヨ鎬绘暟澶辫触") + return + } + result, err := locationFormsService.Query(params) + if err != nil { + logx.Errorf("GetLocationForms query err:%v", err) + util.ResponseFormat(c, code.InternalError, "鏌ヨ澶辫触") + return } util.ResponseFormatList(c, code.Success, result, int(total)) +} + +// DownloadLocationForms +// @Tags 鎶ヨ〃 +// @Summary 涓嬭浇浣嶇疆鎶ヨ〃 +// @Produce application/json +// @Param Authorization header string true "token" +// @Param object body request.GetLocationForms true "鏌ヨ鍙傛暟" +// @Success 200 {object} util.ResponseList{data=[]response.LocationForms} "鎴愬姛" +// @Router /api-wms/v1/forms/downloadLocationForms [post] +func (slf ReportFormsController) DownloadLocationForms(c *gin.Context) { + var params request.GetLocationForms + if err := c.BindJSON(¶ms); err != nil { + util.ResponseFormat(c, code.RequestParamError, "鍙傛暟瑙f瀽澶辫触锛屾暟鎹被鍨嬮敊璇�") + return + } + locationFormsService := service.NewLocationFormsService() + list, err := locationFormsService.FetchAll(params) + if err != nil { + logx.Errorf("DownloadLocationForms FetchAll err:%v", err) + util.ResponseFormat(c, code.InternalError, "鏌ヨ澶辫触") + return + } + filename, err := locationFormsService.Export(list) + if err != nil { + logx.Errorf("DownloadLocationForms Export err:%v", err) + util.ResponseFormat(c, code.InternalError, "瀵煎嚭鏁版嵁鍒版枃浠跺け璐�") + return + } + + fileContentDisposition := "attachment;filename=\"" + url.QueryEscape(filename) + "\"" + c.Header("Content-Type", "application/xlsx") + c.Header("Content-Disposition", fileContentDisposition) + c.File(filename) + defer os.Remove(filename) } // MonthStats @@ -318,13 +328,57 @@ return } - list, total, err := models.NewMonthStatsSearch().SetPage(params.Page, params.PageSize).SetKeyword(params.Keyword).SetDate(params.Date).Find() + monthFormsService := service.NewMonthFormsService() + total, err := monthFormsService.Count(params) if err != nil { + logx.Errorf("MonthStats count err:%v", err) + util.ResponseFormat(c, code.InternalError, "鏌ヨ鎬绘暟澶辫触") + return + } + result, err := monthFormsService.Query(params) + if err != nil { + logx.Errorf("MonthStats query err:%v", err) util.ResponseFormat(c, code.InternalError, "鏌ヨ澶辫触") return } - util.ResponseFormatList(c, code.Success, list, int(total)) + util.ResponseFormatList(c, code.Success, result, int(total)) +} + +// DownloadMonthStats +// @Tags 鎶ヨ〃 +// @Summary 涓嬭浇鏈堝害缁熻搴撳瓨鎶ヨ〃 +// @Produce application/json +// @Param object body request.GetMonthStats true "鏌ヨ鍙傛暟" +// @Param Authorization header string true "token" +// @Success 200 {object} util.ResponseList{data=[]models.MonthStats} "鎴愬姛" +// @Router /api-wms/v1/forms/downloadMonthStats [post] +func (slf ReportFormsController) DownloadMonthStats(c *gin.Context) { + var params request.GetMonthStats + if err := c.BindJSON(¶ms); err != nil { + util.ResponseFormat(c, code.RequestParamError, "鍙傛暟瑙f瀽澶辫触锛屾暟鎹被鍨嬮敊璇�") + return + } + + monthFormsService := service.NewMonthFormsService() + list, err := monthFormsService.FetchAll(params) + if err != nil { + logx.Errorf("DownloadMonthStats FetchAll err:%v", err) + util.ResponseFormat(c, code.InternalError, "鏌ヨ澶辫触") + return + } + filename, err := monthFormsService.Export(list) + if err != nil { + logx.Errorf("DownloadMonthStats Export err:%v", err) + util.ResponseFormat(c, code.InternalError, "瀵煎嚭鏁版嵁鍒版枃浠跺け璐�") + return + } + + fileContentDisposition := "attachment;filename=\"" + url.QueryEscape(filename) + "\"" + c.Header("Content-Type", "application/xlsx") + c.Header("Content-Disposition", fileContentDisposition) + c.File(filename) + defer os.Remove(filename) } // DoMonthStats -- Gitblit v1.8.0