contract.go 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349
  1. package contract
  2. import (
  3. "encoding/json"
  4. "errors"
  5. "fmt"
  6. "hongze/hongze_mobile_admin/models/custom"
  7. contractCustom "hongze/hongze_mobile_admin/models/custom/contract"
  8. contractReq "hongze/hongze_mobile_admin/models/request/contract"
  9. contractResp "hongze/hongze_mobile_admin/models/response/contract"
  10. "hongze/hongze_mobile_admin/models/tables/company_report_permission"
  11. "hongze/hongze_mobile_admin/models/tables/contract"
  12. "hongze/hongze_mobile_admin/models/tables/contract_approval"
  13. "hongze/hongze_mobile_admin/models/tables/contract_approval_record"
  14. "hongze/hongze_mobile_admin/models/tables/contract_operation_record"
  15. "hongze/hongze_mobile_admin/models/tables/contract_service_detail"
  16. "hongze/hongze_mobile_admin/utils"
  17. "rdluck_tools/orm"
  18. "reflect"
  19. "strings"
  20. "time"
  21. )
  22. // InvalidContract 作废合同
  23. func InvalidContract(contractId int, opUser *custom.AdminWx) (err error) {
  24. //查询当前合同信息
  25. nowContract, err := contract.GetContractById(contractId)
  26. if err != nil {
  27. if err.Error() == utils.ErrNoRow() {
  28. err = errors.New(fmt.Sprint("根据合同编号:", contractId, " 找不到初始合同"))
  29. }
  30. return
  31. }
  32. if nowContract.SellerId != opUser.AdminId && opUser.RoleTypeCode != utils.ROLE_TYPE_CODE_COMPLIANCE {
  33. err = errors.New("当前账号无操作权限")
  34. return
  35. }
  36. if nowContract.Status != "已审批" {
  37. err = errors.New("合同状态异常,不允许作废,当前合同状态:" + nowContract.Status)
  38. return
  39. }
  40. //如果删除状态 >0,那么代表已经被删除了
  41. if nowContract.IsDelete > 0 {
  42. err = errors.New("该合同已删除")
  43. return
  44. }
  45. //合同作废
  46. err = contract.InvalidContract(nowContract)
  47. if err != nil {
  48. return
  49. }
  50. //添加操作日志
  51. remark := "作废合同模板"
  52. _ = contract_operation_record.AddContractOperationRecord(nowContract.ContractId, opUser.AdminId, 0, "invalid", opUser.RealName, remark)
  53. return
  54. }
  55. // GetContractDetail 根据id获取合同详情(包含服务)
  56. func GetContractDetail(contractId int) (contractDetail *contract.ContractDetail, err error) {
  57. contractDetail, err = contract.GetContractDetailById(contractId)
  58. if err != nil {
  59. if err.Error() == utils.ErrNoRow() {
  60. err = errors.New("找不到该合同")
  61. }
  62. return
  63. }
  64. serviceList, err := contractCustom.GetContractServiceAndDetailList(contractId)
  65. if err != nil {
  66. err = errors.New(fmt.Sprint("查找合同服务异常", err))
  67. return
  68. }
  69. for i := 0; len(serviceList) > i; i++ {
  70. if serviceList[i].HasDetail == "是" {
  71. list, detailErr := contract_service_detail.GetContractServiceDetailListByServiceId(serviceList[i].ContractServiceId)
  72. if detailErr != nil {
  73. err = errors.New(fmt.Sprint("查找合同服务详情异常", detailErr))
  74. return
  75. }
  76. serviceList[i].DetailList = list
  77. }
  78. }
  79. contractDetail.Service = serviceList
  80. return
  81. }
  82. // UploadCheckBackFile 更新上传签回合同附件
  83. func UploadCheckBackFile(contractId int, fileUrl string, opUser *custom.AdminWx) (err error) {
  84. //获取合同信息
  85. contractInfo, err := contract.GetContractById(contractId)
  86. if err != nil {
  87. return
  88. }
  89. //合同状态判断
  90. if contractInfo.Status != "已审批" && contractInfo.Status != "已签回" {
  91. err = errors.New("合同状态异常,不允许上传签回合同附件,当前合同状态:" + contractInfo.Status)
  92. return
  93. }
  94. contractInfo.CheckBackFileUrl = fileUrl
  95. contractInfo.Status = "已签回"
  96. contractInfo.ModifyTime = time.Now()
  97. contractInfo.CheckBackFileTime = time.Now()
  98. err = contractInfo.Update([]string{"CheckBackFileUrl", "Status", "ModifyTime", "CheckBackFileTime"})
  99. if err != nil {
  100. return
  101. }
  102. //同步更新客户那边提交审批的合同
  103. o := orm.NewOrm()
  104. sql := `update company_contract set img_url = ? where contract_code=? and source="系统合同" `
  105. _, err = o.Raw(sql, contractInfo.CheckBackFileUrl, contractInfo.ContractCode).Exec()
  106. //添加操作日志
  107. remark := "上传签回合同附件"
  108. _ = contract_operation_record.AddContractOperationRecord(contractInfo.ContractId, opUser.AdminId, 0, "upload", opUser.RealName, remark)
  109. return
  110. }
  111. // GetOpButton 获取审批流和权限
  112. func GetOpButton(contractInfo *contract.ContractDetail, contractApprovalInfo *contract_approval.ContractApproval, opUser *custom.AdminWx) (contractOpButton contractResp.OpButton, flowNodeListResp [][]contract_approval_record.ContractApprovalRecord, err error) {
  113. //审批流
  114. approvalRecordList, err := contract_approval_record.GetContractApprovalRecordListByContractApprovalId(contractApprovalInfo.ContractApprovalId)
  115. if err != nil {
  116. err = errors.New("获取审批失败,Err:" + err.Error())
  117. return
  118. }
  119. flowNodeMap := make(map[int][]contract_approval_record.ContractApprovalRecord, 0)
  120. keySort := make([]int, 0)
  121. for _, approvalRecord := range approvalRecordList {
  122. //如果当前节点正好是该节点,同时审批单状态是待审批状态,然后当前账号又有权限,该账号也正是审批人,那么允许审批操作
  123. if contractApprovalInfo.CurrNodeId == approvalRecord.NodeId && contractApprovalInfo.Status == "待审批" {
  124. if opUser.AdminId == approvalRecord.ApproveUserId && approvalRecord.NodeType == "check" {
  125. contractOpButton.Approval = true
  126. }
  127. }
  128. if tmpFlowNodeList, ok := flowNodeMap[approvalRecord.NodeId]; ok {
  129. flowNodeMap[approvalRecord.NodeId] = append(tmpFlowNodeList, *approvalRecord)
  130. } else {
  131. tmpFlowNodeList := make([]contract_approval_record.ContractApprovalRecord, 1)
  132. tmpFlowNodeList[0] = *approvalRecord
  133. flowNodeMap[approvalRecord.NodeId] = tmpFlowNodeList
  134. keySort = append(keySort, approvalRecord.NodeId)
  135. }
  136. }
  137. for _, key := range keySort {
  138. flowNodeListResp = append(flowNodeListResp, flowNodeMap[key])
  139. }
  140. //是否具有签回合同权限
  141. uploadStatus := []string{"已审批", "已签回"}
  142. if opUser.RoleTypeCode == utils.ROLE_TYPE_CODE_COMPLIANCE && strings.Contains(strings.Join(uploadStatus, ","), contractInfo.Status) {
  143. contractOpButton.UploadFile = true
  144. }
  145. //作废权限
  146. if (opUser.RoleTypeCode == utils.ROLE_TYPE_CODE_COMPLIANCE || opUser.AdminId == contractInfo.SellerId) && contractInfo.Status == "已审批" {
  147. contractOpButton.Invalid = true
  148. }
  149. return
  150. }
  151. // GetContractDetailByContractId 根据合同获取合同详情
  152. func GetContractDetailByContractId(contractId int, opUser *custom.AdminWx) (contractInfo *contract.ContractDetail, flowNodeListResp [][]contract_approval_record.ContractApprovalRecord, opButton contractResp.OpButton, err error) {
  153. contractInfo, err = GetContractDetail(contractId)
  154. if err != nil {
  155. err = errors.New("获取合同详情失败,ERR:" + err.Error())
  156. return
  157. }
  158. contractInfo.StartDateStr = contractInfo.StartDate.Format(utils.FormatDate)
  159. contractInfo.EndDateStr = contractInfo.EndDate.Format(utils.FormatDate)
  160. contractInfo.ModifyTimeStr = contractInfo.ModifyTime.Format(utils.FormatDateTime)
  161. contractInfo.CreateTimeStr = contractInfo.CreateTime.Format(utils.FormatDateTime)
  162. //合同中包含的产品权限
  163. permissionLookList, _ := GetPermissionByContractService(contractInfo.ProductId, contractInfo.Service)
  164. contractInfo.PermissionLookList = permissionLookList
  165. //查询最近一次审批单信息
  166. lastApprovalInfo, err := contract_approval.GetLastContractApprovalByContractId(contractInfo.ContractId, "contract")
  167. if err != nil {
  168. if err.Error() != utils.ErrNoRow() {
  169. err = errors.New("获取最近一次审批单信息失败,ERR:" + err.Error())
  170. }
  171. err = nil
  172. return
  173. }
  174. if lastApprovalInfo != nil {
  175. //审批操作权限,上传签回文件权限
  176. tmpContractOpButton, tmpFlowNodeListResp, tmpErr := GetOpButton(contractInfo, lastApprovalInfo, opUser)
  177. if tmpErr != nil {
  178. err = errors.New("获取合同按钮权限、审批流程失败,ERR:" + tmpErr.Error())
  179. return
  180. }
  181. opButton = tmpContractOpButton
  182. flowNodeListResp = tmpFlowNodeListResp
  183. }
  184. return
  185. }
  186. // GetProductCelData 获取品种列数据(因为前端可以随意插入列数据,所以需要根据列名来搜索对应的品种列)
  187. func GetProductCelData(detail contract_service_detail.ContractServiceDetail, tableCel *contractReq.AddContractServiceDetailReq) (err error) {
  188. t := reflect.TypeOf(detail)
  189. v := reflect.ValueOf(detail)
  190. for k := 0; k < t.NumField(); k++ {
  191. //获取结构体的参数名
  192. tmpName := t.Field(k).Name
  193. if strings.Contains(tmpName, "Col") {
  194. //获取结构体该参数名的值
  195. tmpValue := v.Field(k).String()
  196. //如果值不为空的话,那么做下json转换
  197. if tmpValue != "" {
  198. tmpErr := json.Unmarshal([]byte(tmpValue), tableCel)
  199. if tmpErr != nil {
  200. err = tmpErr
  201. continue
  202. }
  203. if tableCel.HeadName == "品种" {
  204. err = nil
  205. return
  206. }
  207. }
  208. }
  209. }
  210. return
  211. }
  212. // GetPermissionByContractService 通过合同服务,获取权限集合列表
  213. func GetPermissionByContractService(productId int, serviceList []*contractCustom.ContractServiceAndDetail) (permissionList []*company_report_permission.PermissionLookList, err error) {
  214. //子权限切片集合
  215. var permissionClassifyArr []string
  216. if productId == 1 {
  217. for _, v := range utils.PermissionFiccClassifyArr {
  218. permissionClassifyArr = append(permissionClassifyArr, v)
  219. }
  220. } else {
  221. permissionClassifyArr = append(permissionClassifyArr, "权益")
  222. }
  223. //获取已经勾选的的权限
  224. checkPermissionIdMap, err := GetServicePermissionMap(serviceList)
  225. if err != nil {
  226. return
  227. }
  228. //遍历获取
  229. for _, v := range permissionClassifyArr {
  230. checkList := make([]int, 0)
  231. plist := new(company_report_permission.PermissionLookList)
  232. items, tmpErr := company_report_permission.GetPermissionLookItems(productId, v)
  233. if tmpErr != nil {
  234. err = tmpErr
  235. return
  236. }
  237. for _, n := range items {
  238. if _, ok := checkPermissionIdMap[n.ChartPermissionId]; ok {
  239. checkList = append(checkList, n.ChartPermissionId)
  240. }
  241. }
  242. plist.Items = items
  243. plist.ClassifyName = v
  244. plist.CheckList = checkList
  245. permissionList = append(permissionList, plist)
  246. }
  247. return
  248. }
  249. // GetServicePermissionMap 获取合同服务中的权限id map
  250. func GetServicePermissionMap(serviceList []*contractCustom.ContractServiceAndDetail) (checkPermissionIdMap map[int]int, err error) {
  251. checkPermissionIdMap = make(map[int]int)
  252. //获取已经勾选的的权限
  253. for _, contractService := range serviceList {
  254. //如果是权益,那么研选必要
  255. if contractService.ProductId == 2 {
  256. chartPermissionId := 31 //研 选服务
  257. checkPermissionIdMap[chartPermissionId] = chartPermissionId
  258. }
  259. //看看系统中有没有映射对应的权限,如果有的话,那么直接返回,没有那么可能是特殊服务,需要去遍历
  260. if contractService.ChartPermissionId > 0 {
  261. checkPermissionIdMap[contractService.ChartPermissionId] = contractService.ChartPermissionId
  262. continue
  263. }
  264. switch contractService.ServiceTemplateId {
  265. case 1: //ficc 大套餐
  266. for _, v := range utils.PermissionFiccClassifyArr {
  267. //大套餐中 市场策略暂时不作为勾选项
  268. if v == "市场策略" {
  269. continue
  270. }
  271. items, tmpErr := company_report_permission.GetPermissionLookItems(1, v)
  272. if tmpErr != nil {
  273. err = tmpErr
  274. return
  275. }
  276. for _, n := range items {
  277. checkPermissionIdMap[n.ChartPermissionId] = n.ChartPermissionId
  278. }
  279. }
  280. case 2: //ficc小套餐
  281. permissionValues := []string{
  282. "FICC周报", "商品双周报+线上电话会讨论会<br/>(由弘则的研究员主持线上讨论)", "数据点评",
  283. }
  284. for _, detail := range contractService.DetailList {
  285. var tableCel contractReq.AddContractServiceDetailReq
  286. tmpErr := json.Unmarshal([]byte(detail.Col1), &tableCel)
  287. if tmpErr != nil {
  288. err = tmpErr
  289. return
  290. }
  291. if strings.Contains(strings.Join(permissionValues, ","), tableCel.Value) {
  292. //获取品种列数据
  293. var tableCel2 contractReq.AddContractServiceDetailReq
  294. tmpErr := GetProductCelData(*detail, &tableCel2)
  295. if tmpErr != nil {
  296. err = tmpErr
  297. return
  298. }
  299. for _, serviceId := range tableCel2.ValueId {
  300. checkPermissionIdMap[serviceId] = serviceId
  301. }
  302. }
  303. }
  304. case 4, 5, 6: //权益大套餐
  305. permissionFiccClassifyArr := []string{"权益"}
  306. for _, v := range permissionFiccClassifyArr {
  307. items, tmpErr := company_report_permission.GetPermissionLookItems(2, v)
  308. if tmpErr != nil {
  309. err = tmpErr
  310. return
  311. }
  312. for _, n := range items {
  313. //如果是专家行业,那么 结束当前循环,进入下一循环(产品需求:专家行业不在里面)
  314. if n.ChartPermissionId == 29 {
  315. continue
  316. }
  317. checkPermissionIdMap[n.ChartPermissionId] = n.ChartPermissionId
  318. }
  319. }
  320. }
  321. }
  322. return
  323. }