contract_pre_register.go 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231
  1. package fms
  2. import (
  3. "hongze/fms_api/global"
  4. "hongze/fms_api/models/base"
  5. "hongze/fms_api/utils"
  6. "time"
  7. )
  8. // PreRegister 合同开票表
  9. type ContractPreRegister struct {
  10. PreRegisterId int `gorm:"primaryKey;column:pre_register_id" json:"pre_register_id" description:"预登记ID"`
  11. ContractRegisterId int `gorm:"column:contract_register_id" json:"contract_register_id" description:"登记ID"`
  12. InvoiceId int `gorm:"column:invoice_id" json:"invoice_id" description:"开票ID"`
  13. ArriveId int `gorm:"column:arrive_id" json:"arrive_id" description:"到款ID"`
  14. CompanyName string `json:"company_name" description:"客户名称"`
  15. Amount float64 `gorm:"column:amount" json:"amount" description:"开票换算后的金额(人民币)"`
  16. OriginAmount float64 `gorm:"column:origin_amount" json:"origin_amount" description:"开票金额"`
  17. CurrencyUnit string `gorm:"column:currency_unit" json:"currency_unit" description:"开票货币国际代码"`
  18. ArriveAmount float64 `gorm:"column:arrive_amount" json:"arrive_amount" description:"到款换算后的金额(人民币)"`
  19. ArriveOriginAmount float64 `gorm:"column:arrive_origin_amount" json:"arrive_origin_amount" description:"到款金额"`
  20. InvoiceType int `gorm:"column:invoice_type" json:"invoice_type" description:"类型: 1-开票登记; 2-到款登记;3-开票预登记;4-到款预登记"`
  21. InvoiceDate time.Time `gorm:"column:invoice_time" json:"invoice_time" description:"开票日"`
  22. ArriveDate time.Time `gorm:"column:arrive_time" json:"arrive_time" description:"到款日"`
  23. SellerId int `gorm:"column:seller_id" json:"seller_id" description:"销售ID"`
  24. SellerName string `gorm:"column:seller_name" json:"seller_name" description:"销售名称"`
  25. SellerGroupId int `gorm:"column:seller_group_id" json:"seller_group_id" description:"销售分组ID"`
  26. SellerGroupName string `gorm:"column:seller_group_name" json:"seller_group_name" description:"销售分组名称"`
  27. SellerTeamId int `gorm:"column:seller_team_id" json:"seller_team_id" description:"销售小组ID"`
  28. SellerTeamName string `gorm:"column:seller_team_name" json:"seller_team_name" description:"销售小组名称"`
  29. AdminId int `gorm:"column:admin_id" json:"admin_id" description:"操作人ID"`
  30. AdminName string `gorm:"column:admin_name" json:"admin_name" description:"操作人姓名"`
  31. Remark string `gorm:"column:remark" json:"remark" description:"备注信息"`
  32. ArriveRemark string `gorm:"column:arrive_remark" json:"arrive_remark" description:"到款备注信息"`
  33. ServiceProductId int `gorm:"column:service_product_id" json:"service_product_id" description:"套餐类型:1ficc套餐,2权益套餐"`
  34. IsPrePay int `gorm:"column:is_pre_pay" json:"is_pre_pay" description:"是否预付款: 0-不是; 1-是"`
  35. StartDate time.Time `gorm:"column:start_date" json:"start_date" description:"约定开始时间"`
  36. EndDate time.Time `gorm:"column:end_date" json:"end_date" description:"约定结束时间"`
  37. PaymentSellerId int `gorm:"column:payment_seller_id;default:0;NOT NULL" json:"payment_seller_id"` // 销售ID
  38. PaymentSellerName string `gorm:"column:payment_seller_name;NOT NULL" json:"payment_seller_name"` // 销售名称
  39. PaymentSellerGroupId int `gorm:"column:payment_seller_group_id;default:0;NOT NULL" json:"payment_seller_group_id"` // 销售分组ID
  40. PaymentSellerGroupName string `gorm:"column:payment_seller_group_name;NOT NULL" json:"payment_seller_group_name"` // 销售分组名称
  41. PaymentSellerTeamId int `gorm:"column:payment_seller_team_id;default:0;NOT NULL" json:"payment_seller_team_id"` // 销售小组ID
  42. PaymentSellerTeamName string `gorm:"column:payment_seller_team_name;NOT NULL" json:"payment_seller_team_name"` // 销售小组名称
  43. base.TimeBase
  44. }
  45. func (c *ContractPreRegister) TableName() string {
  46. return "contract_pre_register"
  47. }
  48. // ContractPreRegisterItem 合同开票/到款
  49. type ContractPreRegisterItem struct {
  50. PreRegisterId int `gorm:"primaryKey;column:pre_register_id" json:"pre_register_id" description:"预登记ID"`
  51. ContractRegisterId int `gorm:"column:contract_register_id" json:"contract_register_id" description:"登记ID"`
  52. InvoiceId int `gorm:"column:invoice_id" json:"invoice_id" description:"开票ID"`
  53. ArriveId int `gorm:"column:arrive_id" json:"arrive_id" description:"到款ID"`
  54. CompanyName string `json:"company_name" description:"客户名称"`
  55. Amount float64 `gorm:"column:amount" json:"amount" description:"开票换算后的金额(人民币)"`
  56. OriginAmount float64 `gorm:"column:origin_amount" json:"origin_amount" description:"开票金额"`
  57. CurrencyUnit string `gorm:"column:currency_unit" json:"currency_unit" description:"开票货币国际代码"`
  58. ArriveAmount float64 `gorm:"column:arrive_amount" json:"arrive_amount" description:"到款换算后的金额(人民币)"`
  59. ArriveOriginAmount float64 `gorm:"column:arrive_origin_amount" json:"arrive_origin_amount" description:"到款金额"`
  60. UnitName string `json:"unit_name" description:"货币单位名称"`
  61. InvoiceType int `gorm:"column:invoice_type" json:"invoice_type" description:"类型: 1-开票登记; 2-到款登记;3-开票预登记;4-到款预登记"`
  62. InvoiceDate string `gorm:"column:invoice_time" json:"invoice_time" description:"开票日"`
  63. ArriveDate string `gorm:"column:arrive_time" json:"arrive_time" description:"到款日"`
  64. SellerId int `gorm:"column:seller_id" json:"seller_id" description:"销售ID"`
  65. SellerName string `gorm:"column:seller_name" json:"seller_name" description:"销售名称"`
  66. PayType int `gorm:"column:pay_type" json:"pay_type" description:"付款方式:0-无;1-年付;2-半年付;3-季付;4-次付;5-异常"`
  67. Remark string `gorm:"column:remark" json:"remark" description:"开票备注信息"`
  68. ArriveRemark string `gorm:"column:arrive_remark" json:"arrive_remark" description:"到款备注信息"`
  69. ServiceProductId int `gorm:"column:service_product_id" json:"service_product_id" description:"套餐类型:1ficc套餐,2权益套餐"`
  70. IsPrePay int `gorm:"column:is_pre_pay" json:"is_pre_pay" description:"是否预付款: 0-不是; 1-是"`
  71. StartDate string `gorm:"column:start_date" json:"start_date" description:"约定开始时间"`
  72. EndDate string `gorm:"column:end_date" json:"end_date" description:"约定结束时间"`
  73. AdminId int `gorm:"column:admin_id" json:"admin_id" description:"操作人ID"`
  74. CreateTime string `gorm:"column:create_time" json:"create_time" description:"创建时间"`
  75. PaymentSellerId int `gorm:"column:payment_seller_id;default:0;NOT NULL" json:"payment_seller_id"` // 销售ID
  76. PaymentSellerName string `gorm:"column:payment_seller_name;NOT NULL" json:"payment_seller_name"` // 销售名称
  77. PaymentSellerGroupId int `gorm:"column:payment_seller_group_id;default:0;NOT NULL" json:"payment_seller_group_id"` // 销售分组ID
  78. PaymentSellerGroupName string `gorm:"column:payment_seller_group_name;NOT NULL" json:"payment_seller_group_name"` // 销售分组名称
  79. PaymentSellerTeamId int `gorm:"column:payment_seller_team_id;default:0;NOT NULL" json:"payment_seller_team_id"` // 销售小组ID
  80. PaymentSellerTeamName string `gorm:"column:payment_seller_team_name;NOT NULL" json:"payment_seller_team_name"` // 销售小组名称
  81. }
  82. // formatContractInvoice2Item 格式化ContractInvoiceItem
  83. func formatContractPreRegister2Item(item *ContractPreRegister) (formatItem *ContractPreRegisterItem) {
  84. formatItem = new(ContractPreRegisterItem)
  85. formatItem.PreRegisterId = item.PreRegisterId
  86. formatItem.ContractRegisterId = item.ContractRegisterId
  87. formatItem.InvoiceId = item.InvoiceId
  88. formatItem.ArriveId = item.ArriveId
  89. formatItem.CompanyName = item.CompanyName
  90. formatItem.Amount = item.Amount
  91. formatItem.OriginAmount = item.OriginAmount
  92. formatItem.CurrencyUnit = item.CurrencyUnit
  93. formatItem.ArriveAmount = item.ArriveAmount
  94. formatItem.ArriveOriginAmount = item.ArriveOriginAmount
  95. formatItem.InvoiceType = item.InvoiceType
  96. formatItem.InvoiceDate = utils.TimeTransferString(utils.FormatDate, item.InvoiceDate)
  97. formatItem.ArriveDate = utils.TimeTransferString(utils.FormatDate, item.ArriveDate)
  98. formatItem.SellerId = item.SellerId
  99. formatItem.SellerName = item.SellerName
  100. formatItem.Remark = item.Remark
  101. formatItem.ArriveRemark = item.ArriveRemark
  102. formatItem.IsPrePay = item.IsPrePay
  103. formatItem.ServiceProductId = item.ServiceProductId
  104. formatItem.AdminId = item.AdminId
  105. formatItem.CreateTime = utils.TimeTransferString(utils.FormatDateTime, item.CreateTime)
  106. formatItem.StartDate = item.StartDate.Format(utils.FormatDate)
  107. formatItem.EndDate = item.EndDate.Format(utils.FormatDate)
  108. formatItem.PaymentSellerId = item.PaymentSellerId
  109. formatItem.PaymentSellerName = item.PaymentSellerName
  110. formatItem.PaymentSellerGroupId = item.PaymentSellerGroupId
  111. formatItem.PaymentSellerGroupName = item.PaymentSellerGroupName
  112. formatItem.PaymentSellerTeamId = item.PaymentSellerTeamId
  113. formatItem.PaymentSellerTeamName = item.PaymentSellerTeamName
  114. return
  115. }
  116. // GetContractInvoiceItemPageList 获取合同开票/到款列表-分页
  117. func GetContractPreRegisterItemPageList(page base.IPage, condition string, pars []interface{}) (count int64, results []*ContractPreRegisterItem, err error) {
  118. list := make([]*ContractPreRegister, 0)
  119. query := global.DEFAULT_MYSQL.Table("contract_pre_register").
  120. Where(condition, pars...)
  121. query.Count(&count)
  122. if len(page.GetOrderItemsString()) > 0 {
  123. query = query.Order(page.GetOrderItemsString())
  124. }
  125. err = query.Limit(int(page.GetPageSize())).Offset(int(page.Offset())).Find(&list).Error
  126. if err != nil {
  127. return
  128. }
  129. for i := range list {
  130. results = append(results, formatContractPreRegister2Item(list[i]))
  131. }
  132. return
  133. }
  134. func (c *ContractPreRegister) Create() (err error) {
  135. err = global.DEFAULT_MYSQL.Create(c).Error
  136. return
  137. }
  138. func (c *ContractPreRegister) Fetch(id int) (item *ContractPreRegister, err error) {
  139. err = global.DEFAULT_MYSQL.Model(c).Where(" pre_register_id = ?", id).First(&item).Error
  140. return
  141. }
  142. func (c *ContractPreRegister) FetchByRegisterId(id int) (items []*ContractPreRegister, err error) {
  143. err = global.DEFAULT_MYSQL.Model(c).Where(" contract_register_id = ?", id).Find(&items).Error
  144. return
  145. }
  146. // 删除
  147. func (c *ContractPreRegister) Delete() (err error) {
  148. err = global.DEFAULT_MYSQL.Delete(c).Error
  149. return
  150. }
  151. func (c *ContractPreRegister) Update(updateCols []string) (err error) {
  152. err = global.DEFAULT_MYSQL.Model(c).Select(updateCols).Updates(c).Error
  153. return
  154. }
  155. // GetContractInvoiceItemList 获取开票到款列表
  156. func GetContractPreRegisterItemList(condition string, pars []interface{}) (itemList []*ContractPreRegisterItem, err error) {
  157. list := make([]*ContractPreRegister, 0)
  158. err = global.DEFAULT_MYSQL.Model(ContractPreRegister{}).
  159. Where("is_deleted = 0").
  160. Where(condition, pars...).
  161. Order("contract_invoice_id ASC").
  162. Find(&list).Error
  163. if err != nil {
  164. return
  165. }
  166. itemList = formatContractPreRegister2ItemList(list)
  167. return
  168. }
  169. // formatContractPreRegister2ItemList 格式化ContractInvoice
  170. func formatContractPreRegister2ItemList(list []*ContractPreRegister) (itemList []*ContractPreRegisterItem) {
  171. itemList = make([]*ContractPreRegisterItem, 0)
  172. for i := range list {
  173. itemList = append(itemList, &ContractPreRegisterItem{
  174. PreRegisterId: list[i].PreRegisterId,
  175. ContractRegisterId: list[i].ContractRegisterId,
  176. Amount: list[i].Amount,
  177. OriginAmount: list[i].OriginAmount,
  178. CurrencyUnit: list[i].CurrencyUnit,
  179. ArriveAmount: list[i].ArriveAmount,
  180. ArriveOriginAmount: list[i].ArriveOriginAmount,
  181. InvoiceType: list[i].InvoiceType,
  182. InvoiceDate: utils.TimeTransferString(utils.FormatDate, list[i].InvoiceDate),
  183. SellerId: list[i].SellerId,
  184. SellerName: list[i].SellerName,
  185. Remark: list[i].Remark,
  186. ServiceProductId: list[i].ServiceProductId,
  187. IsPrePay: list[i].IsPrePay,
  188. StartDate: list[i].StartDate.Format(utils.FormatDate),
  189. EndDate: list[i].StartDate.Format(utils.FormatDate),
  190. CreateTime: utils.TimeTransferString(utils.FormatDateTime, list[i].CreateTime),
  191. })
  192. }
  193. return
  194. }
  195. // ContractPreRegisterList 预登记列表
  196. type ContractPreRegisterList struct {
  197. *ContractPreRegisterItem
  198. ServicesName string `json:"services" description:"套餐名称"`
  199. }
  200. // PreRegisterDetailReq 预登记详情请求体
  201. type PreRegisterDetailReq struct {
  202. ContractRegisterId int `json:"contract_register_id" form:"contract_register_id" binding:"required,gte=1"`
  203. InvoiceType int `gorm:"column:invoice_type" json:"invoice_type" description:"类型: 1-开票登记; 2-到款登记;3-开票预登记;4-到款预登记"`
  204. PreRegisterId int `gorm:"column:pre_register_id" json:"pre_register_id" description:"预登记ID"`
  205. InvoiceId int `gorm:"column:invoice_id" json:"invoice_id" description:"开票ID"`
  206. ArriveId int `gorm:"column:arrive_id" json:"arrive_id" description:"到款ID"`
  207. DetailType int `json:"detail_type" description:"请求类型"`
  208. }
  209. // ContractPreRegisterDetail 预登记详情
  210. type ContractPreRegisterDetail struct {
  211. *ContractRegisterItem
  212. List []*ContractInvoiceDetailItem `json:"list" description:"开票到款列表"`
  213. Services []*ContractServiceAndDetail `json:"services" description:"套餐列表"`
  214. ServiceTemplateIds []int `json:"serviceTemplateIds" description:"小套餐列表"`
  215. }