审查视图

pkg/application/orderinfo/service/order_info.go 33.5 KB
tangxvhui authored
1 2 3 4 5
package service

import (
	"fmt"
唐旭辉 authored
6 7
	"github.com/astaxie/beego/logs"
8
	"gitlab.fjmaimaimai.com/mmm-go/partnermg/pkg/application/event/subscriber"
tangxvhui authored
9 10 11 12
	"gitlab.fjmaimaimai.com/mmm-go/partnermg/pkg/application/factory"
	"gitlab.fjmaimaimai.com/mmm-go/partnermg/pkg/application/orderinfo/command"
	"gitlab.fjmaimaimai.com/mmm-go/partnermg/pkg/application/orderinfo/query"
	"gitlab.fjmaimaimai.com/mmm-go/partnermg/pkg/domain"
13
	domainService "gitlab.fjmaimaimai.com/mmm-go/partnermg/pkg/domain/service"
14
	"gitlab.fjmaimaimai.com/mmm-go/partnermg/pkg/infrastructure/dao"
唐旭辉 authored
15
	"gitlab.fjmaimaimai.com/mmm-go/partnermg/pkg/infrastructure/pg/models"
16
	"gitlab.fjmaimaimai.com/mmm-go/partnermg/pkg/infrastructure/pg/transaction"
tangxvhui authored
17 18 19
	"gitlab.fjmaimaimai.com/mmm-go/partnermg/pkg/lib"
)
唐旭辉 authored
20
//OrderService 自建订单,意向单,实发订单
tangxvhui authored
21 22 23 24 25 26 27 28 29
type OrderInfoService struct {
}

func NewOrderInfoService(option map[string]interface{}) *OrderInfoService {
	newAdminUserService := new(OrderInfoService)
	return newAdminUserService
}

// PageListOrderBase 获取订单列表
唐旭辉 authored
30 31
func (service OrderInfoService) PageListOrderBase(listOrderQuery query.ListOrderBaseQuery) ([]map[string]interface{}, int, error) {
	var err error
tangxvhui authored
32 33 34 35
	transactionContext, err := factory.CreateTransactionContext(nil)
	if err != nil {
		return nil, 0, lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
	}
唐旭辉 authored
36 37 38 39 40 41
	if err = transactionContext.StartTransaction(); err != nil {
		return nil, 0, err
	}
	defer func() {
		transactionContext.RollbackTransaction()
	}()
tangxvhui authored
42
	var (
唐旭辉 authored
43 44 45
		orderDao *dao.OrderBaseDao
		orders   []models.OrderBase
		cnt      int
tangxvhui authored
46
	)
唐旭辉 authored
47
唐旭辉 authored
48
	if orderDao, err = factory.CreateOrderBaseDao(map[string]interface{}{
tangxvhui authored
49 50 51 52
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, 0, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
唐旭辉 authored
53 54 55 56 57
	orders, cnt, err = orderDao.OrderListByCondition(
		listOrderQuery.CompanyId,
		listOrderQuery.OrderType,
		listOrderQuery.PartnerOrCode,
		[2]string{listOrderQuery.UpdateTimeBegin, listOrderQuery.UpdateTimeEnd},
唐旭辉 authored
58
		[2]string{listOrderQuery.CreateTimeBegin, listOrderQuery.CreateTimeEnd},
唐旭辉 authored
59 60 61
		listOrderQuery.PartnerCategory,
		listOrderQuery.Limit, listOrderQuery.Offset,
	)
tangxvhui authored
62 63 64 65 66 67 68 69 70
	if err != nil {
		return nil, 0, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	var PartnerInfoRepository domain.PartnerInfoRepository
	if PartnerInfoRepository, err = factory.CreatePartnerInfoRepository(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, 0, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
唐旭辉 authored
71 72

	orderDataReturn := make([]map[string]interface{}, 0)
73
tangxvhui authored
74
	for i := range orders {
唐旭辉 authored
75
		partnerData := &domain.PartnerInfo{}
tangxvhui authored
76 77 78 79
		partnerData, err = PartnerInfoRepository.FindOne(domain.PartnerFindOneQuery{
			UserId: orders[i].PartnerId,
		})
		if err != nil {
唐旭辉 authored
80 81
			//防崩溃
			partnerData = &domain.PartnerInfo{}
唐旭辉 authored
82
			logs.Error("获取合伙(id=%d)失败%s", orders[i].PartnerId, err)
tangxvhui authored
83
		}
84
		listIndex := listOrderQuery.Offset + (1 + i)
唐旭辉 authored
85
		m := map[string]interface{}{
86
			"index":           listIndex,
唐旭辉 authored
87 88 89
			"createTime":      orders[i].CreateTime.Local().Format("2006-01-02 15:04:05"),
			"updateTime":      orders[i].UpdateTime.Local().Format("2006-01-02 15:04:05"),
			"buyer":           orders[i].Buyer.BuyerName,
90
			"id":              fmt.Sprint(orders[i].Id),
唐旭辉 authored
91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108
			"orderId":         orders[i].OrderCode,
			"shipmentsId":     orders[i].DeliveryCode,
			"partner":         partnerData.Partner.PartnerName,
			"orderNum":        orders[i].PlanOrderCount,
			"orderPrice":      orders[i].PlanOrderAmount,
			"orderDist":       orders[i].RegionInfo.RegionName,
			"quantityControl": "",
			"priceControl":    "",
			"status":          orders[i].IsDisable,
			"partnerCategory": orders[i].PartnerCategory.Name,
		}
		if orders[i].UseOrderCount >= 0 {
			m["quantityControl"] = fmt.Sprint(orders[i].UseOrderCount)
		}
		if orders[i].UseOrderAmount >= 0 {
			m["priceControl"] = fmt.Sprint(orders[i].UseOrderAmount)
		}
		orderDataReturn = append(orderDataReturn, m)
tangxvhui authored
109
	}
唐旭辉 authored
110
	transactionContext.CommitTransaction()
唐旭辉 authored
111
	return orderDataReturn, cnt, nil
tangxvhui authored
112 113 114 115 116 117 118 119 120 121 122
}

//GetOrderDetail 获取订单详情
func (service OrderInfoService) GetOrderDetail(getOrderQuery query.GetOrderQuery) (*domain.OrderBase, error) {
	//实际业务
	transactionContext, err := factory.CreateTransactionContext(nil)
	if err != nil {
		return nil, lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
	}
	var (
		orderBaseRepository   domain.OrderBaseRepository
123
		partnerInfoRepository domain.PartnerInfoRepository
tangxvhui authored
124 125 126 127 128 129 130 131 132
		orderGoodRepository   domain.OrderGoodRepository
		order                 *domain.OrderBase
	)
	if err = transactionContext.StartTransaction(); err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	defer func() {
		transactionContext.RollbackTransaction()
	}()
133
	if orderBaseRepository, err = factory.CreateOrderBaseRepository(map[string]interface{}{
tangxvhui authored
134 135 136 137
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
138
	if partnerInfoRepository, err = factory.CreatePartnerInfoRepository(map[string]interface{}{
tangxvhui authored
139 140 141 142 143 144 145 146 147
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	if orderGoodRepository, err = factory.CreateOrderGoodRepository(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
tangxvhui authored
148
	order, err = orderBaseRepository.FindOne(domain.OrderBaseFindOneQuery{
149 150
		OrderId:   getOrderQuery.OrderId,
		CompanyId: getOrderQuery.CompanyId,
tangxvhui authored
151 152
	})
	if err != nil {
tangxvhui authored
153
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("获取订单数据失败:%s", err))
tangxvhui authored
154 155 156 157 158
	}
	var (
		partnerData *domain.PartnerInfo
		goods       []domain.OrderGood
	)
159
160 161 162 163
	partnerData, err = partnerInfoRepository.FindOne(domain.PartnerFindOneQuery{
		UserId:    order.PartnerId,
		CompanyId: getOrderQuery.CompanyId,
	})
tangxvhui authored
164
	if err != nil {
tangxvhui authored
165
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("检索合伙人数据失败:%s", err))
tangxvhui authored
166 167 168
	}
	order.PartnerInfo = partnerData.Partner
	goods, _, err = orderGoodRepository.Find(domain.OrderGoodFindQuery{
169 170
		OrderId:   order.Id,
		CompanyId: getOrderQuery.CompanyId,
tangxvhui authored
171 172 173 174 175 176 177 178 179 180 181 182
	})
	if err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("获取订单中的商品列表失败:%s", err))
	}
	order.Goods = goods
	err = transactionContext.CommitTransaction()
	if err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	return order, nil
}
唐旭辉 authored
183
//CreateNewOrder 创建订单
tangxvhui authored
184 185 186 187 188 189 190 191 192 193 194 195
func (service OrderInfoService) CreateNewOrder(cmd command.CreateOrderCommand) (*domain.OrderBase, error) {
	var (
		transactionContext, _ = factory.CreateTransactionContext(nil)
		err                   error
	)

	if err = transactionContext.StartTransaction(); err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	defer func() {
		transactionContext.RollbackTransaction()
	}()
tangxvhui authored
196
tangxvhui authored
197 198 199 200 201 202 203 204 205 206 207 208 209 210
	var PartnerInfoRepository domain.PartnerInfoRepository
	if PartnerInfoRepository, err = factory.CreatePartnerInfoRepository(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	var partnerData *domain.PartnerInfo
	partnerData, err = PartnerInfoRepository.FindOne(domain.PartnerFindOneQuery{UserId: cmd.PartnerId})
	if err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("检索合伙人数据失败"))
	}
	var (
		orderBaseRepository domain.OrderBaseRepository
		orderGoodRepository domain.OrderGoodRepository
211
		orderBaseDao        *dao.OrderBaseDao
tangxvhui authored
212 213 214 215 216 217 218 219 220 221 222
	)
	if orderBaseRepository, err = factory.CreateOrderBaseRepository(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	if orderGoodRepository, err = factory.CreateOrderGoodRepository(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
223 224 225 226 227 228
	if orderBaseDao, err = factory.CreateOrderBaseDao(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
	}
	//检查order_code是否重复
229 230 231 232 233
	// if ok, err := orderBaseDao.OrderCodeExist(cmd.OrderCode, cmd.PartnerCategory, cmd.PartnerId); err != nil {
	// 	return nil, lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
	// } else if ok {
	// 	return nil, lib.ThrowError(lib.BUSINESS_ERROR, "订单号已存在")
	// }
234 235
	//检查delivery_code是否重复
	if len(cmd.DeliveryCode) > 0 {
236
		if ok, err := orderBaseDao.DeliveryCodeExist(cmd.DeliveryCode, cmd.CompanyId); err != nil {
237 238 239 240 241
			return nil, lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
		} else if ok {
			return nil, lib.ThrowError(lib.BUSINESS_ERROR, "发货号已存在")
		}
	}
tangxvhui authored
242 243
	newOrder := &domain.OrderBase{
		OrderType: cmd.OrderType, OrderCode: cmd.OrderCode,
tangxvhui authored
244
		DeliveryCode: cmd.DeliveryCode,
唐旭辉 authored
245
		Buyer: domain.Buyer{
tangxvhui authored
246 247
			BuyerName: cmd.BuyerName,
		},
唐旭辉 authored
248
		RegionInfo: domain.RegionInfo{
tangxvhui authored
249 250 251 252 253
			RegionName: cmd.OrderRegion,
		},
		PartnerId:            cmd.PartnerId,
		PartnerInfo:          partnerData.Partner,
		SalesmanBonusPercent: cmd.SalesmanBonusPercent,
254
		CompanyId:            cmd.CompanyId,
tangxvhui authored
255
	}
唐旭辉 authored
256 257 258 259 260 261
	var categoryRepository domain.PartnerCategoryRepository
	if categoryRepository, err = factory.CreatePartnerCategoryRepository(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
唐旭辉 authored
262 263 264
	var cmdPartnerCategoryOk bool
	for _, v := range partnerData.PartnerCategoryInfos {
		if v.Id == cmd.PartnerCategory {
唐旭辉 authored
265 266 267 268 269 270 271 272 273 274 275 276
			_, categorys, err := categoryRepository.Find(domain.PartnerCategoryFindQuery{
				Ids: []int64{v.Id},
			})
			if err != nil {
				e := fmt.Sprintf("获取合伙人分类数据失败:%s", err)
				return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, e)
			}
			if len(categorys) > 0 {
				newOrder.PartnerCategory = categorys[0]
				cmdPartnerCategoryOk = true
			}
			break
唐旭辉 authored
277 278 279 280 281
		}
	}
	if !cmdPartnerCategoryOk {
		return nil, lib.ThrowError(lib.BUSINESS_ERROR, "合伙人类型选择错误")
	}
tangxvhui authored
282 283 284
	var orderGoods []domain.OrderGood
	for _, good := range cmd.Goods {
		m := domain.NewOrderGood()
tangxvhui authored
285
		m.OrderId = 0
tangxvhui authored
286 287 288 289 290
		m.GoodName = good.GoodName
		m.PlanGoodNumber = good.PlanGoodNumber
		m.Price = good.Price
		m.PartnerBonusPercent = good.PartnerBonusPercent
		m.Remark = good.Remark
291
		m.CompanyId = cmd.CompanyId
tangxvhui authored
292 293 294 295
		err = m.Compute()
		if err != nil {
			return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("核算订单中商品的数值失败:%s", err))
		}
tangxvhui authored
296 297 298 299
		err = m.CurrentBonusStatus.WartPayPartnerBonus(&m)
		if err != nil {
			return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("核算订单中商品的分红数值失败:%s", err))
		}
tangxvhui authored
300 301 302 303 304 305 306 307 308 309 310
		orderGoods = append(orderGoods, m)
	}
	newOrder.Goods = orderGoods
	err = newOrder.Compute()
	if err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("核算订单中合计的数值失败:%s", err))
	}
	err = orderBaseRepository.Save(newOrder)
	if err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("保存订单数据失败:%s", err))
	}
tangxvhui authored
311 312 313
	for i := range newOrder.Goods {
		newOrder.Goods[i].OrderId = newOrder.Id
	}
tangxvhui authored
314 315 316 317 318 319 320 321 322 323 324 325 326
	err = orderGoodRepository.Save(orderGoods)
	if err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("保存订单中的商品数据失败:%s", err))
	}
	newOrder.Goods = orderGoods
	err = transactionContext.CommitTransaction()
	if err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	return newOrder, nil
}

//DeleteOrder 删除订单
327
func (service OrderInfoService) DeleteOrder(orderId int64, companyId int64) error {
tangxvhui authored
328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351
	var (
		transactionContext, _ = factory.CreateTransactionContext(nil)
		err                   error
	)
	if err = transactionContext.StartTransaction(); err != nil {
		return lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	defer func() {
		transactionContext.RollbackTransaction()
	}()
	var (
		orderBaseRepository domain.OrderBaseRepository
		orderGoodRepository domain.OrderGoodRepository
	)
	if orderBaseRepository, err = factory.CreateOrderBaseRepository(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	if orderGoodRepository, err = factory.CreateOrderGoodRepository(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
352
	err = orderBaseRepository.Remove(orderId, companyId)
tangxvhui authored
353 354 355
	if err != nil {
		return lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("删除订单数据失败:%s", err))
	}
356
	err = orderGoodRepository.Remove(orderId, companyId)
tangxvhui authored
357 358 359 360 361 362 363 364 365
	if err != nil {
		return lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("删除订单中商品数据失败:%s", err))
	}
	err = transactionContext.CommitTransaction()
	if err != nil {
		return lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	return nil
}
tangxvhui authored
366
tangxvhui authored
367
//UpdateOrderData 编辑订单
tangxvhui authored
368 369 370 371 372 373 374 375 376 377 378 379
func (service OrderInfoService) UpdateOrderData(cmd command.UpdateOrderCommand) (*domain.OrderBase, error) {
	var (
		transactionContext, _ = factory.CreateTransactionContext(nil)
		err                   error
	)

	if err = transactionContext.StartTransaction(); err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	defer func() {
		transactionContext.RollbackTransaction()
	}()
tangxvhui authored
380
tangxvhui authored
381 382 383 384 385 386 387
	var PartnerInfoRepository domain.PartnerInfoRepository
	if PartnerInfoRepository, err = factory.CreatePartnerInfoRepository(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	var partnerData *domain.PartnerInfo
388 389 390
	partnerData, err = PartnerInfoRepository.FindOne(domain.PartnerFindOneQuery{
		UserId: cmd.PartnerId, CompanyId: cmd.CompanyId,
	})
tangxvhui authored
391 392 393 394 395 396 397 398 399 400
	if err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("检索合伙人数据失败"))
	}
	var (
		orderBaseRepository domain.OrderBaseRepository
		orderGoodRepository domain.OrderGoodRepository
		oldOrderData        *domain.OrderBase
		oldOrderGoods       []domain.OrderGood
		newOrderGoods       []domain.OrderGood
		delGoods            []int64
401
		orderBaseDao        *dao.OrderBaseDao
tangxvhui authored
402 403 404 405 406 407 408 409 410 411 412 413 414
	)
	if orderBaseRepository, err = factory.CreateOrderBaseRepository(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	if orderGoodRepository, err = factory.CreateOrderGoodRepository(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	//获取旧的订单
	oldOrderData, err = orderBaseRepository.FindOne(domain.OrderBaseFindOneQuery{
415 416
		OrderId:   cmd.Id,
		CompanyId: cmd.CompanyId,
tangxvhui authored
417 418 419 420
	})
	if err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("未找到指定的订单:%s", err))
	}
421 422
	//判定要求的更新的订单类型
	if oldOrderData.OrderType != cmd.OrderType {
tangxvhui authored
423
		return nil, lib.ThrowError(lib.BUSINESS_ERROR, fmt.Sprintf("操作失败,待更新的订单的类型已变更"))
424
	}
425 426 427 428 429 430
	if orderBaseDao, err = factory.CreateOrderBaseDao(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
	}
	//检查order_code是否重复
431 432 433 434 435 436 437
	// if oldOrderData.OrderCode != cmd.OrderCode || cmd.PartnerCategory != oldOrderData.PartnerCategory.Id {
	// 	if ok, err := orderBaseDao.OrderCodeExist(cmd.OrderCode, cmd.PartnerCategory, cmd.PartnerId); err != nil {
	// 		return nil, lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
	// 	} else if ok {
	// 		return nil, lib.ThrowError(lib.BUSINESS_ERROR, "订单号已存在")
	// 	}
	// }
438
	//检查delivery_code是否重复
唐旭辉 authored
439
	if cmd.DeliveryCode != oldOrderData.DeliveryCode {
440
		if ok, err := orderBaseDao.DeliveryCodeExist(cmd.DeliveryCode, cmd.CompanyId, cmd.Id); err != nil {
441 442 443 444 445
			return nil, lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
		} else if ok {
			return nil, lib.ThrowError(lib.BUSINESS_ERROR, "发货号已存在")
		}
	}
tangxvhui authored
446 447
	//获取旧的订单中的商品
	oldOrderGoods, _, err = orderGoodRepository.Find(domain.OrderGoodFindQuery{
448 449
		OrderId:   cmd.Id,
		CompanyId: cmd.CompanyId,
tangxvhui authored
450 451 452 453 454 455 456 457 458 459 460 461
	})
	if err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("未找到指定的订单中的商品列表失败:%s", err))
	}
	for _, good := range cmd.Goods {
		m := domain.NewOrderGood()
		m.OrderId = oldOrderData.Id
		m.GoodName = good.GoodName
		m.PlanGoodNumber = good.PlanGoodNumber
		m.Price = good.Price
		m.PartnerBonusPercent = good.PartnerBonusPercent
		m.Remark = good.Remark
462
		m.CompanyId = cmd.CompanyId
tangxvhui authored
463 464 465 466
		err = m.Compute()
		if err != nil {
			return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("核算订单中商品的数值失败:%s", err))
		}
tangxvhui authored
467 468 469 470
		err = m.CurrentBonusStatus.WartPayPartnerBonus(&m)
		if err != nil {
			return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("核算订单中商品的分红数值失败:%s", err))
		}
tangxvhui authored
471 472
		newOrderGoods = append(newOrderGoods, m)
	}
唐旭辉 authored
473 474 475 476 477 478 479 480 481 482
	var cmdPartnerCategoryOk bool
	for _, v := range partnerData.PartnerCategoryInfos {
		if v.Id == cmd.PartnerCategory {
			oldOrderData.PartnerCategory = v
			cmdPartnerCategoryOk = true
		}
	}
	if !cmdPartnerCategoryOk {
		return nil, lib.ThrowError(lib.BUSINESS_ERROR, "合伙人类型选择错误")
	}
tangxvhui authored
483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506
	oldOrderData.OrderCode = cmd.OrderCode
	oldOrderData.DeliveryCode = cmd.DeliveryCode
	oldOrderData.Buyer.BuyerName = cmd.BuyerName
	oldOrderData.RegionInfo.RegionName = cmd.OrderRegion
	oldOrderData.PartnerId = cmd.PartnerId
	oldOrderData.PartnerInfo = partnerData.Partner
	oldOrderData.SalesmanBonusPercent = cmd.SalesmanBonusPercent
	oldOrderData.Goods = newOrderGoods
	err = oldOrderData.Compute()
	if err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("核算订单中合计的数值失败:%s", err))
	}

	err = orderBaseRepository.Save(oldOrderData)
	if err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("保存订单数据失败:%s", err))
	}
	err = orderGoodRepository.Save(newOrderGoods)
	if err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("保存订单中的商品数据失败:%s", err))
	}
	oldOrderData.Goods = newOrderGoods
	//删不需要的订单总不需要的商品
	delGoods = service.deleteOldOrderGoods(newOrderGoods, oldOrderGoods)
唐旭辉 authored
507 508 509 510 511
	if len(delGoods) > 0 {
		err = orderGoodRepository.Remove(oldOrderData.Id, cmd.CompanyId, delGoods...)
		if err != nil {
			return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("删除订单中的商品数据失败:%s", err))
		}
tangxvhui authored
512 513 514 515 516 517 518 519
	}
	err = transactionContext.CommitTransaction()
	if err != nil {
		return nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	return oldOrderData, nil
}
tangxvhui authored
520
//deleteOldOrderGoods 新旧商品列表对比
tangxvhui authored
521 522 523 524 525 526 527 528 529 530 531 532 533 534 535
func (service OrderInfoService) deleteOldOrderGoods(newGoods []domain.OrderGood, oldGoods []domain.OrderGood) (goodIds []int64) {
	for _, old := range oldGoods {
		var hasIn bool
		for _, new := range newGoods {
			if old.Id == new.Id {
				hasIn = true
				break
			}
		}
		if !hasIn {
			goodIds = append(goodIds, old.Id)
		}
	}
	return
}
tangxvhui authored
536
tangxvhui authored
537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559
//DisableOrEnable 开启关闭订单
func (service OrderInfoService) DisableOrEnable(cmd command.DisableOrderCommand) error {
	var (
		transactionContext, _ = factory.CreateTransactionContext(nil)
		err                   error
	)
	if err = transactionContext.StartTransaction(); err != nil {
		return lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	defer func() {
		transactionContext.RollbackTransaction()
	}()
	var (
		orderBaseRepository domain.OrderBaseRepository
		oldOrderData        *domain.OrderBase
	)
	if orderBaseRepository, err = factory.CreateOrderBaseRepository(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	//获取旧的订单
	oldOrderData, err = orderBaseRepository.FindOne(domain.OrderBaseFindOneQuery{
560 561
		OrderId:   cmd.OrderId,
		CompanyId: cmd.CompanyId,
tangxvhui authored
562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579
	})
	if err != nil {
		return lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("未找到指定的订单:%s", err))
	}
	if oldOrderData.OrderType != cmd.OrderType {
		return lib.ThrowError(lib.BUSINESS_ERROR, fmt.Sprintf("操作失败,指定的订单的类型发生变更"))
	}
	oldOrderData.IsDisable = cmd.IsDisable
	err = orderBaseRepository.Save(oldOrderData)
	if err != nil {
		return lib.ThrowError(lib.INTERNAL_SERVER_ERROR, fmt.Sprintf("保存订单数据失败:%s", err))
	}
	err = transactionContext.CommitTransaction()
	if err != nil {
		return lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	return nil
}
580
唐旭辉 authored
581
//PageListOrderBouns 获取订单的分红列表
唐旭辉 authored
582
func (service OrderInfoService) PageListOrderBonus(listOrderQuery query.ListOrderBonusQuery) ([]map[string]interface{}, int, error) {
唐旭辉 authored
583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604
	transactionContext, err := factory.CreateTransactionContext(nil)
	if err != nil {
		return nil, 0, lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
	}
	if err = transactionContext.StartTransaction(); err != nil {
		return nil, 0, err
	}
	defer func() {
		transactionContext.RollbackTransaction()
	}()
	var (
		ordersM      []models.OrderBase
		orders       []domain.OrderBase
		cnt          int
		orderBaseDao *dao.OrderBaseDao
	)

	if orderBaseDao, err = factory.CreateOrderBaseDao(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, cnt, lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
	}
唐旭辉 authored
605
	ordersM, cnt, err = orderBaseDao.OrderBonusListByCondition(
唐旭辉 authored
606 607 608
		listOrderQuery.CompanyId,
		listOrderQuery.OrderType,
		listOrderQuery.PartnerOrCode,
唐旭辉 authored
609
		listOrderQuery.PartnerCategory,
唐旭辉 authored
610
		[2]string{listOrderQuery.CreateTimeBegin, listOrderQuery.CreateTimeEnd},
唐旭辉 authored
611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635
		listOrderQuery.Limit,
		listOrderQuery.Offset,
	)
	for _, orderModel := range ordersM {
		order := domain.OrderBase{
			Id: orderModel.Id, OrderType: orderModel.OrderType, OrderCode: orderModel.OrderCode,
			DeliveryCode: orderModel.DeliveryCode, Buyer: orderModel.Buyer, RegionInfo: orderModel.RegionInfo,
			PartnerId: orderModel.PartnerId, SalesmanBonusPercent: orderModel.SalesmanBonusPercent,
			CreateTime: orderModel.CreateTime, DeliveryTime: orderModel.DeliveryTime, UpdateTime: orderModel.UpdateTime,
			IsDisable: orderModel.IsDisable,
			OrderCompute: domain.OrderCompute{
				PlanPartnerBonus: orderModel.PlanPartnerBonus, UsePartnerBonus: orderModel.UsePartnerBonus,
				PartnerBonusHas: orderModel.PartnerBonusHas, PartnerBonusNot: orderModel.PartnerBonusNot,
				PartnerBonusExpense: orderModel.PartnerBonusExpense, SalesmanBonus: orderModel.SalesmanBonus,
				PlanOrderCount: orderModel.PlanOrderCount, PlanOrderAmount: orderModel.PlanOrderAmount,
				UseOrderCount: orderModel.UseOrderCount, UseOrderAmount: orderModel.UseOrderAmount,
			},
			PartnerInfo: domain.Partner{
				Id: orderModel.PartnerId,
			},
			BonusStatus: orderModel.BonusStatus,
			CompanyId:   orderModel.CompanyId,
		}
		orders = append(orders, order)
	}
唐旭辉 authored
636 637 638 639
	var (
		PartnerInfoRepository domain.PartnerInfoRepository
		orderGoodRepository   domain.OrderGoodRepository
	)
唐旭辉 authored
640 641 642 643 644
	if PartnerInfoRepository, err = factory.CreatePartnerInfoRepository(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, 0, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
唐旭辉 authored
645 646 647 648 649
	if orderGoodRepository, err = factory.CreateOrderGoodRepository(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, 0, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
唐旭辉 authored
650
	var resp = []map[string]interface{}{}
唐旭辉 authored
651 652 653 654 655 656 657 658 659 660
	for i := range orders {
		partnerData := &domain.PartnerInfo{}
		partnerData, err = PartnerInfoRepository.FindOne(domain.PartnerFindOneQuery{
			UserId: orders[i].PartnerId,
		})
		if err != nil {
			logs.Error("获取合伙(id=%d)失败%s", orders[i].PartnerId, err)
		} else {
			orders[i].PartnerInfo = partnerData.Partner
		}
唐旭辉 authored
661 662 663 664 665 666
		var (
			goods           []domain.OrderGood
			hasBonusPercent bool
		)
		goods, _, err = orderGoodRepository.Find(domain.OrderGoodFindQuery{OrderId: orders[i].Id})
		for ii := range goods {
唐旭辉 authored
667
			if goods[ii].PartnerBonusPercent >= 0 {
唐旭辉 authored
668 669 670
				hasBonusPercent = true
			}
		}
唐旭辉 authored
671
		listIndex := listOrderQuery.Offset + (1 + i)
唐旭辉 authored
672
		listItem := map[string]interface{}{
唐旭辉 authored
673
			"index":                listIndex,
唐旭辉 authored
674
			"createTime":           orders[i].CreateTime.Local().Format("2006-01-02 15:04:05"),
唐旭辉 authored
675
			"updateTime":           orders[i].UpdateTime.Local().Format("2006-01-02 15:04:05"),
676
			"id":                   fmt.Sprint(orders[i].Id),
唐旭辉 authored
677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694
			"shipmentsId":          orders[i].DeliveryCode,
			"partner":              orders[i].PartnerInfo.PartnerName,
			"dividendsReceivable":  fmt.Sprint(orders[i].GetCurrentPartnerBonus()),
			"dividendSpending":     fmt.Sprint(orders[i].OrderCompute.PartnerBonusExpense),
			"receiveDividends":     fmt.Sprint(orders[i].OrderCompute.PartnerBonusHas),
			"uncollectedDividends": fmt.Sprint(orders[i].OrderCompute.PartnerBonusNot),
			"stateOfPayment":       orders[i].BonusStatus,
			"orderType":            orders[i].OrderType,
			"orderTypeName":        domain.GetOrderBaseTypeName(orders[i].OrderType),
			"orderNumber":          orders[i].OrderCode,
		}
		if !hasBonusPercent {
			listItem["receiveDividends"] = "-"
			listItem["dividendsReceivable"] = "-"
			listItem["dividendSpending"] = "-"
			listItem["uncollectedDividends"] = "-"
		}
		resp = append(resp, listItem)
唐旭辉 authored
695 696 697
	}
	err = transactionContext.CommitTransaction()
	if err != nil {
唐旭辉 authored
698
		return resp, cnt, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
唐旭辉 authored
699
	}
唐旭辉 authored
700
	return resp, cnt, nil
唐旭辉 authored
701 702
}
唐旭辉 authored
703 704
//PayPartnerBonusWithOrderBestshop 支付分红
func (service OrderInfoService) PayPartnerBonus(orderId int64, goodId int64, adminId int64) error {
唐旭辉 authored
705 706 707 708 709
	var (
		transactionContext, _ = factory.CreateTransactionContext(nil)
		err                   error
	)
	if err = transactionContext.StartTransaction(); err != nil {
710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728
		return lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
	}
	defer func() {
		transactionContext.RollbackTransaction()
	}()
	var (
		orderBonuSrv domainService.OrderBonusService
	)
	orderBonuSrv, err = factory.CreateOrderBonusService(map[string]interface{}{
		"transactionContext": transactionContext,
	})
	if err != nil {
		return lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	orderBonuSrv.Subscribe(&subscriber.OrderLogSubscriber{
		TransactionContext: transactionContext.(*transaction.TransactionContext),
	})
	err = orderBonuSrv.PayOrderGoodBonus(orderId, goodId, adminId)
	if err != nil {
唐旭辉 authored
729
		return err
唐旭辉 authored
730
	}
731 732 733 734 735 736 737
	err = transactionContext.CommitTransaction()
	if err != nil {
		return lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	return nil
}
唐旭辉 authored
738
//UpdateOrderRemarkBonus 订单分红详情,更新备注
739 740 741 742 743 744 745 746
func (service OrderInfoService) UpdateOrderRemarkBonus(orderId int64, adminId int64, remark string) error {
	var (
		transactionContext, _ = factory.CreateTransactionContext(nil)
		err                   error
	)
	if err = transactionContext.StartTransaction(); err != nil {
		return lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
	}
唐旭辉 authored
747 748 749
	defer func() {
		transactionContext.RollbackTransaction()
	}()
750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765
	var (
		orderBonuSrv domainService.OrderBonusService
	)
	orderBonuSrv, err = factory.CreateOrderBonusService(map[string]interface{}{
		"transactionContext": transactionContext,
	})
	if err != nil {
		return lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	orderBonuSrv.Subscribe(&subscriber.OrderLogSubscriber{
		TransactionContext: transactionContext.(*transaction.TransactionContext),
	})
	err = orderBonuSrv.UpdateOrderRemarkBonus(orderId, adminId, remark)
	if err != nil {
		return lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
唐旭辉 authored
766 767 768 769 770 771
	err = transactionContext.CommitTransaction()
	if err != nil {
		return lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	return nil
}
唐旭辉 authored
772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816

func (service OrderInfoService) ListOrderBonusForExcel(listOrderQuery query.ListOrderBonusQuery) ([]map[string]string, [][2]string, error) {
	transactionContext, err := factory.CreateTransactionContext(nil)
	if err != nil {
		return nil, nil, lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
	}
	if err = transactionContext.StartTransaction(); err != nil {
		return nil, nil, lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
	}
	defer func() {
		transactionContext.RollbackTransaction()
	}()
	var (
		orderBaseDao *dao.OrderBaseDao
	)

	if orderBaseDao, err = factory.CreateOrderBaseDao(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, nil, lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
	}
	result, err := orderBaseDao.OrderBonusListForExcel(
		listOrderQuery.CompanyId,
		listOrderQuery.OrderType,
		listOrderQuery.PartnerOrCode,
		listOrderQuery.PartnerCategory,
	)
	if err != nil {
		return nil, nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}

	err = transactionContext.CommitTransaction()
	if err != nil {
		return nil, nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	var resultMaps []map[string]string
	for i := range result {
		m := map[string]string{
			"num":                   fmt.Sprint(i + 1),
			"order_type":            domain.GetOrderBaseTypeName(result[i].OrderType),
			"order_code":            result[i].OrderCode,
			"delivery_code":         result[i].DeliveryCode,
			"partner_name":          result[i].PartnerName,
			"bonus_status":          "",
			"update_time":           result[i].UpdateTime,
唐旭辉 authored
817
			"create_time":           result[i].CreateTime,
唐旭辉 authored
818 819 820 821
			"partner_bonus":         fmt.Sprintf("%10.2f", result[i].PartnerBonus),
			"partner_bonus_has":     fmt.Sprintf("%10.2f", result[i].PartnerBonusHas),
			"partner_bonus_not":     fmt.Sprintf("%10.2f", result[i].PartnerBonusNot),
			"partner_bonus_expense": fmt.Sprintf("%10.2f", result[i].PartnerBonusExpense),
唐旭辉 authored
822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840
		}
		if result[i].HasBonusPercent == 0 {
			m["partner_bonus"] = "-"
			m["partner_bonus_has"] = "-"
			m["partner_bonus_not"] = "-"
			m["partner_bonus_expense"] = "-"
		}
		switch result[i].BonusStatus {
		case domain.OrderGoodWaitPay:
			m["bonus_status"] = "等待支付分红"
		case domain.OrderGoodHasPay:
			m["bonus_status"] = "已支付分红"
		}
		resultMaps = append(resultMaps, m)
	}
	column := [][2]string{
		[2]string{"num", "序号"},
		[2]string{"order_type", "订单类型"},
		[2]string{"order_code", "订单号"},
841
		[2]string{"delivery_code", "发货单号"},
唐旭辉 authored
842
		[2]string{"partner_name", "合伙人"},
843
		[2]string{"bonus_status", "支付状态"},
唐旭辉 authored
844
		[2]string{"create_time", "创建时间"},
唐旭辉 authored
845 846 847 848 849 850 851
		[2]string{"partner_bonus", "应收分红"},
		[2]string{"partner_bonus_has", "已收分红"},
		[2]string{"partner_bonus_not", "未收分红"},
		[2]string{"partner_bonus_expense", "分红支出"},
	}
	return resultMaps, column, nil
}
唐旭辉 authored
852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890 891 892 893 894 895 896

func (service OrderInfoService) ListOrderForExcel(listOrderQuery query.ListOrderBaseQuery) ([]map[string]string, [][2]string, error) {
	transactionContext, err := factory.CreateTransactionContext(nil)
	if err != nil {
		return nil, nil, lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
	}
	if err = transactionContext.StartTransaction(); err != nil {
		return nil, nil, lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
	}
	defer func() {
		transactionContext.RollbackTransaction()
	}()
	var (
		orderBaseDao *dao.OrderBaseDao
	)

	if orderBaseDao, err = factory.CreateOrderBaseDao(map[string]interface{}{
		"transactionContext": transactionContext,
	}); err != nil {
		return nil, nil, lib.ThrowError(lib.TRANSACTION_ERROR, err.Error())
	}
	ordersData, err := orderBaseDao.OrderListForExcel(
		listOrderQuery.CompanyId,
		listOrderQuery.PartnerOrCode,
		[2]string{listOrderQuery.UpdateTimeBegin, listOrderQuery.UpdateTimeEnd},
		[2]string{listOrderQuery.CreateTimeBegin, listOrderQuery.UpdateTimeEnd},
		listOrderQuery.PartnerCategory,
	)
	if err != nil {
		return nil, nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	err = transactionContext.CommitTransaction()
	if err != nil {
		return nil, nil, lib.ThrowError(lib.INTERNAL_SERVER_ERROR, err.Error())
	}
	var resultMaps []map[string]string
	for i := range ordersData {
		m := map[string]string{
			"num":               fmt.Sprint(i + 1),
			"order_code":        ordersData[i].OrderCode,
			"delivery_code":     ordersData[i].DeliveryCode,
			"partner_name":      ordersData[i].PartnerName,
			"update_time":       ordersData[i].UpdateTime,
			"create_time":       ordersData[i].CreateTime,
			"plan_order_count":  fmt.Sprint(ordersData[i].PlanOrderCount),
唐旭辉 authored
897
			"use_order_count":   "",
唐旭辉 authored
898
			"region_name":       fmt.Sprint(ordersData[i].RegionName),
唐旭辉 authored
899 900
			"plan_order_amount": fmt.Sprintf("%10.2f", ordersData[i].PlanOrderAmount),
			"use_order_amount":  "",
唐旭辉 authored
901 902 903
			"partner_category":  ordersData[i].PartnerCategory,
			"buyer_name":        ordersData[i].BuyerName,
		}
唐旭辉 authored
904 905 906 907 908 909
		if ordersData[i].UseOrderCount >= 0 {
			m["use_order_count"] = fmt.Sprint(ordersData[i].UseOrderCount)
		}
		if ordersData[i].UseOrderAmount >= 0 {
			m["use_order_amount"] = fmt.Sprintf("%10.2f", ordersData[i].UseOrderAmount)
		}
唐旭辉 authored
910 911 912 913 914 915 916 917 918 919 920 921 922 923 924 925 926 927 928
		resultMaps = append(resultMaps, m)
	}
	column := [][2]string{
		[2]string{"num", "序号"},
		[2]string{"order_code", "订单号"},
		[2]string{"delivery_code", "发货单号"},
		[2]string{"create_time", "创建时间"},
		[2]string{"update_time", "更新时间"},
		[2]string{"plan_order_count", "订单数量"},
		[2]string{"use_order_count", "数量调整"},
		[2]string{"plan_order_amount", "订单金额"},
		[2]string{"use_order_amount", "金额调整"},
		[2]string{"region_name", "订单区域"},
		[2]string{"partner_category", "合伙人类型"},
		[2]string{"buyer_name", "客户"},
		[2]string{"partner_name", "合伙人"},
	}
	return resultMaps, column, nil
}