approval_new.go 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429
  1. package controllers
  2. import (
  3. "encoding/json"
  4. "github.com/rdlucklib/rdluck_tools/paging"
  5. approval2 "hongze/hongze_mobile_admin/models/request/approval"
  6. approvalResp "hongze/hongze_mobile_admin/models/response/approval"
  7. "hongze/hongze_mobile_admin/models/tables/company_approval"
  8. "hongze/hongze_mobile_admin/models/tables/company_delay_permission"
  9. "hongze/hongze_mobile_admin/models/tables/company_product"
  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. company_apply "hongze/hongze_mobile_admin/services/company_approval"
  15. contractService "hongze/hongze_mobile_admin/services/contract"
  16. "hongze/hongze_mobile_admin/utils"
  17. "strconv"
  18. "strings"
  19. "time"
  20. )
  21. // ListV2
  22. // @Title 获取审批列表接口
  23. // @Description 获取审批列表接口
  24. // @Param PageSize query int true "每页数据条数"
  25. // @Param CurrentIndex query int true "当前页页码,从1开始"
  26. // @Param Status query string true "状态:'待审批','已审批','驳回','已撤回'"
  27. // @Param KeyWord query string true "搜索关键词"
  28. // @Param Keyword query string true "搜索关键词"
  29. // @Param KeywordEq query string true "搜索关键词(全等)"
  30. // @Success 200 {object} approval.CompanyApprovalListResp
  31. // @router /list [get]
  32. func (c *ApprovalCommon) ListV2() {
  33. sysUser := c.AdminWx
  34. pageSize, _ := c.GetInt("PageSize")
  35. currentIndex, _ := c.GetInt("CurrentIndex")
  36. status := c.GetString("Status")
  37. keyword := c.GetString("Keyword")
  38. keywordEq := c.GetString("KeywordEq")
  39. condition := ""
  40. pars := make([]interface{}, 0)
  41. ////如果不是超管或者合规,那么只能查看自己的合同
  42. //join表字段
  43. //归属
  44. if status == "待审批" {
  45. condition += ` AND ( (((c.apply_user_id = ? and a.start_node_id = a.curr_node_id) OR (f.approve_user_id = ? and a.curr_node_id=f.node_id ) ) and c.approve_status="待审批") or (f.approve_user_id = ? and a.curr_node_id > f.node_id and f.node_type="cc") )`
  46. pars = append(pars, sysUser.AdminId, sysUser.AdminId, sysUser.AdminId)
  47. } else {
  48. condition += ` AND (c.apply_user_id = ? or (f.approve_user_id = ? and f.node_id <= a.curr_node_id) )`
  49. pars = append(pars, sysUser.AdminId, sysUser.AdminId)
  50. }
  51. //审批状态
  52. if status != "" {
  53. if status == "已审批" {
  54. condition += ` AND c.approve_status in ("已审批","驳回") `
  55. } else {
  56. condition += ` AND c.approve_status = ? `
  57. if status == "处理中" {
  58. pars = append(pars, "待审批")
  59. } else {
  60. pars = append(pars, status)
  61. }
  62. }
  63. } else {
  64. condition += ` AND c.approve_status != "已撤回" `
  65. }
  66. //关键字
  67. if keyword != "" {
  68. condition += ` AND ( e.company_name LIKE '%` + keyword + `%' OR e.credit_code LIKE '%` + keyword + `%' ) `
  69. }
  70. //关键字(全等)
  71. if keywordEq != "" {
  72. condition += ` AND e.company_name =? `
  73. pars = append(pars, keywordEq)
  74. }
  75. var startSize int
  76. if pageSize <= 0 {
  77. pageSize = utils.PageSize20
  78. }
  79. if currentIndex <= 0 {
  80. currentIndex = 1
  81. }
  82. startSize = paging.StartIndex(currentIndex, pageSize)
  83. total, err := contract_approval.GetCompanyApprovalCount(condition, pars)
  84. if err != nil {
  85. c.FailWithMessage("获取失败", "获取数据总数失败,Err:"+err.Error())
  86. return
  87. }
  88. list, err := contract_approval.GetCompanyApprovalList(condition, pars, startSize, pageSize)
  89. if err != nil {
  90. c.FailWithMessage("获取审批列表失败!", "获取审批列表失败,Err:"+err.Error())
  91. return
  92. }
  93. respList := make([]*company_approval.CompanyApprovalList, 0)
  94. listLen := len(list)
  95. if listLen > 0 {
  96. contractApprovalIdSlice := make([]string, 0)
  97. for i := 0; i < len(list); i++ {
  98. contractApprovalIdSlice = append(contractApprovalIdSlice, strconv.Itoa(list[i].ContractApprovalId))
  99. }
  100. contractApprovalIdStr := strings.Join(contractApprovalIdSlice, ",")
  101. //获取审批流列表数据
  102. contractApprovalRecordList, err := contract_approval_record.GetContractApprovalRecordList(contractApprovalIdStr, sysUser.AdminId)
  103. if err != nil {
  104. c.FailWithMessage("获取审批流列表失败!", "获取审批流列表失败,Err:"+err.Error())
  105. return
  106. }
  107. contractApprovalRecordMap := make(map[int]*contract_approval_record.ContractApprovalRecord)
  108. for i := 0; i < len(contractApprovalRecordList); i++ {
  109. contractApprovalRecordMap[contractApprovalRecordList[i].ContractApprovalId] = contractApprovalRecordList[i]
  110. }
  111. for i := 0; i < len(list); i++ {
  112. item := list[i]
  113. list[i].StartDateStr = item.StartDate.Format(utils.FormatDate)
  114. list[i].EndDateStr = item.EndDate.Format(utils.FormatDate)
  115. list[i].CreateTimeStr = item.CreateTime.Format(utils.FormatDateTime)
  116. list[i].ModifyTimeStr = item.ModifyTime.Format(utils.FormatDateTime)
  117. list[i].ApproveTimeStr = item.ApproveTime.Format(utils.FormatDateTime)
  118. //合同审批权限
  119. ApprovalButton := false
  120. var contractDetail contract.ContractDetail
  121. jsonErr := json.Unmarshal([]byte(list[i].ContractDetail), &contractDetail)
  122. if jsonErr != nil {
  123. c.FailWithMessage("审批合同数据转换失败!", "审批合同数据转换失败,Err:"+jsonErr.Error())
  124. return
  125. }
  126. list[i].ContractInfo = contractDetail
  127. //校验最新审批流数据
  128. if contractApprovalRecord, has := contractApprovalRecordMap[item.ContractApprovalId]; has {
  129. //审批流id
  130. list[i].ContractApprovalRecordId = contractApprovalRecord.ContractApprovalRecordId
  131. //审批时间
  132. list[i].ApproveTime = contractApprovalRecord.ApproveTime
  133. list[i].ApproveTimeStr = contractApprovalRecord.ApproveTime.Format(utils.FormatDateTime)
  134. //判断是否有操作权限
  135. list[i].Status = contractApprovalRecord.Status
  136. //判断是否处于待审批状态
  137. if contractApprovalRecord.Status == "待审批" {
  138. //如果不是审批者,那么不能审批操作
  139. if contractApprovalRecord.NodeType != "check" {
  140. continue
  141. }
  142. //如果没有指定审批人的话
  143. if contractApprovalRecord.ApproveUserId <= 0 {
  144. //判断是否与审批角色一致,如果一致,那么允许操作审批
  145. if contractApprovalRecord.ApproveRoleTypeCode == sysUser.RoleTypeCode {
  146. ApprovalButton = true
  147. }
  148. } else if contractApprovalRecord.ApproveUserId == sysUser.AdminId {
  149. //如果指定审批人就是自己的话,那么操作审批
  150. ApprovalButton = true
  151. }
  152. }
  153. }
  154. //撤销权限(本人才有,然后没有审核操作过的才允许撤销)
  155. //if item.Status == "待审批" && item.StartNodeId == item.CurrNodeId && item.ApplyUserId == sysUser.AdminId {
  156. // opButton.Cancel = true
  157. //}
  158. respTmp := &company_approval.CompanyApprovalList{
  159. CompanyId: item.CompanyId,
  160. ProductId: item.ProductId,
  161. CompanyName: item.CompanyName,
  162. CreditCode: item.CreditCode,
  163. CompanyType: item.CompanyType,
  164. IndustryName: item.IndustryName,
  165. SellerName: item.SellerName,
  166. CreateTime: item.CreateTimeStr,
  167. ApprovalTime: item.CreateTime.Format(utils.FormatDateTime),
  168. ApproveTime: item.ApproveTimeStr,
  169. Status: item.CompanyProductStatus,
  170. ApproveContent: item.ApplyContent,
  171. ApproveStatus: item.ApproveStatus,
  172. ApplyMethod: item.ApplyMethod,
  173. ApplyReasons: item.ApplyReasons,
  174. FreezeStartDate: item.FreezeStartDate,
  175. FreezeEndDate: item.FreezeEndDate,
  176. FreezeExpireDays: item.FreezeExpireDays,
  177. Address: item.Address,
  178. Source: item.Source,
  179. ApproveRemark: item.ApproveRemark,
  180. StartDate: item.StartDate.Format(utils.FormatDate),
  181. EndDate: item.EndDate.Format(utils.FormatDate),
  182. ExpireDay: item.ExpireDay,
  183. CompanyApprovalId: item.CompanyApprovalId,
  184. //ApprovalCount int `description:"已延期审批次数"`
  185. CompanyContractId: item.CompanyContractId,
  186. //DelayPermission :
  187. ApplyRealName: item.ApplyRealName,
  188. ApplyUserId: item.ApplyUserId,
  189. OpButton: ApprovalButton,
  190. }
  191. if respTmp.FreezeStartDate != "" && respTmp.FreezeEndDate != "" && respTmp.Status == utils.COMPANY_STATUS_FREEZE {
  192. freezeEndDate, _ := time.Parse(utils.FormatDate, item.FreezeEndDate)
  193. if time.Now().Before(freezeEndDate) {
  194. expireDays := freezeEndDate.Sub(time.Now()).Hours() / 24
  195. respTmp.FreezeExpireDays = int(expireDays)
  196. }
  197. }
  198. if respTmp.StartDate != "" && respTmp.EndDate != "" {
  199. endDate, _ := time.Parse(utils.FormatDate, respTmp.EndDate)
  200. if time.Now().Before(endDate) {
  201. expireDays := endDate.Sub(time.Now()).Hours() / 24
  202. list[i].ExpireDay = int(expireDays)
  203. }
  204. }
  205. switch item.ApplyMethod {
  206. case 2:
  207. //客户冻结转试用次数
  208. approvalCount, err := company_approval.GetFreezeToTryCompanyApprovalCount(respTmp.CompanyId, respTmp.ProductId, respTmp.ApplyUserId)
  209. if err != nil && err.Error() != utils.ErrNoRow() {
  210. c.FailWithMessage("获取失败", "获取冻结转试用审批次数失败,Err:"+err.Error())
  211. return
  212. }
  213. respTmp.ApprovalCount = approvalCount
  214. case 3:
  215. delayPermission, err := company_delay_permission.GetApplyDelayPermission(respTmp.CompanyApprovalId)
  216. if err != nil && err.Error() != utils.ErrNoRow() {
  217. c.FailWithMessage("获取失败", "获取延期审批权限失败,Err:"+err.Error())
  218. return
  219. }
  220. respTmp.DelayPermission = delayPermission
  221. //客户审批试用延期次数
  222. approvalCount, err := company_approval.GetCompanyTryDelayApprovalCount(respTmp.CompanyId, respTmp.ProductId)
  223. if err != nil && err.Error() != utils.ErrNoRow() {
  224. c.FailWithMessage("获取失败", "获取延期审批次数失败,Err:"+err.Error())
  225. return
  226. }
  227. respTmp.ApprovalCount = approvalCount
  228. }
  229. respList = append(respList, respTmp)
  230. }
  231. }
  232. page := paging.GetPaging(currentIndex, pageSize, total)
  233. c.OkDetailed(approvalResp.CompanyApprovalListResp{
  234. List: respList,
  235. Paging: page,
  236. }, "获取成功")
  237. }
  238. // @Title 获取审批单详情接口
  239. // @Description 获取审批单详情接口
  240. // @Param ApprovalId query int true "审批单id"
  241. // @Success 200 {object} approval.CompanyApprovalDetailResp
  242. // @router /detail [get]
  243. func (c *ApprovalCommon) Detail() {
  244. companyApprovalId, _ := c.GetInt("ApprovalId")
  245. //if roleTypeCode == utils.ROLE_TYPE_CODE_FICC_ADMIN || roleTypeCode == utils.ROLE_TYPE_CODE_RAI_ADMIN { //审批
  246. // condition += ` AND c.approve_role_type_code=? `
  247. // pars = append(pars, roleTypeCode)
  248. //} else if roleTypeCode == utils.ROLE_TYPE_CODE_FICC_SELLER || roleTypeCode == utils.ROLE_TYPE_CODE_RAI_SELLER { //销售
  249. // condition += ` AND c.apply_user_id=? `
  250. // pars = append(pars, sysUser.AdminId)
  251. //}
  252. item, flowNodeListResp, err := company_apply.GetApprovalDetailByCompanyApprovalId(companyApprovalId, c.AdminWx)
  253. if err != nil {
  254. c.FailWithMessage("获取失败", "获取数据失败,Err:"+err.Error())
  255. return
  256. }
  257. resp := approvalResp.CompanyApprovalDetailResp{
  258. CompanyApprovalDetail: item,
  259. FlowNodeList: flowNodeListResp,
  260. }
  261. //获取权限列表
  262. //子权限切片集合
  263. var permissionClassifyArr []string
  264. if item.ProductId == 1 {
  265. for _, v := range utils.PermissionFiccClassifyArr {
  266. permissionClassifyArr = append(permissionClassifyArr, v)
  267. }
  268. } else {
  269. permissionClassifyArr = append(permissionClassifyArr, "权益")
  270. }
  271. //获取需要审批的权限
  272. delayPermissionList, err := company_delay_permission.GetDelayPermissionItems(item.CompanyId, item.CompanyApprovalId)
  273. if err != nil && err.Error() != utils.ErrNoRow() {
  274. c.FailWithMessage("获取失败", "获取审批权限失败,Err:"+err.Error())
  275. return
  276. }
  277. delayPermissionIdMap := make(map[int]int)
  278. for _, delayPermission := range delayPermissionList {
  279. delayPermissionIdMap[delayPermission.ChartPermissionId] = 0
  280. }
  281. //遍历获取
  282. for _, v := range permissionClassifyArr {
  283. checkList := make([]int, 0)
  284. plist := new(company_report_permission.PermissionLookList)
  285. items, err := company_report_permission.GetPermissionLookItems(item.ProductId, v)
  286. if err != nil {
  287. c.FailWithMessage("获取失败", "获取权限信息失败,Err:"+err.Error())
  288. return
  289. }
  290. // 权益主客观均选择的情况下进行合并
  291. //equityPermissionNameCount := make(map[string]int, 0)
  292. for _, n := range items {
  293. if _, ok := delayPermissionIdMap[n.ChartPermissionId]; ok {
  294. checkList = append(checkList, n.ChartPermissionId)
  295. }
  296. //equityPermissionNameCount[n.PermissionName] += 1
  297. }
  298. //newItems := make([]*company_report_permission.PermissionLookItem, 0)
  299. //mergedMap := make(map[string]bool, 0)
  300. //for _, n := range items {
  301. // if equityPermissionNameCount[n.PermissionName] == 2 && !mergedMap[n.PermissionName] {
  302. // newItems = append(newItems, n)
  303. // mergedMap[n.PermissionName] = true
  304. // }
  305. // if equityPermissionNameCount[n.PermissionName] == 1 {
  306. // n.PermissionName = n.Remark
  307. // newItems = append(newItems, n)
  308. // }
  309. //}
  310. //plist.Items = newItems
  311. plist.Items = items
  312. plist.ClassifyName = v
  313. plist.CheckList = checkList
  314. if item.ProductId == 1 {
  315. resp.FiccPermissionList = append(resp.FiccPermissionList, plist)
  316. } else {
  317. // CRM8.8-权限主客观合并
  318. rp := make([]*company_report_permission.PermissionLookList, 0)
  319. rp = append(rp, plist)
  320. newPermissionLookList := contractService.HandleEquityPermissionLookList(rp)
  321. //resp.PermissionList = append(resp.PermissionList, plist)
  322. resp.PermissionList = newPermissionLookList
  323. }
  324. }
  325. c.OkDetailed(resp, "获取成功")
  326. }
  327. // ApplyApprove
  328. // @Title 审批
  329. // @Description 审批接口
  330. // @Param request body approval.CompanyApplyApproveReq true "type json string"
  331. // @Success Ret=200 审批成功
  332. // @router /approve [post]
  333. func (c *ApprovalCommon) ApplyApprove() {
  334. sysUser := c.AdminWx
  335. var req approval2.CompanyApplyApproveReq
  336. err := json.Unmarshal(c.Ctx.Input.RequestBody, &req)
  337. if err != nil {
  338. c.FailWithMessage("参数解析异常!", "参数解析失败,Err:"+err.Error())
  339. return
  340. }
  341. //roleTypeCode := sysUser.RoleTypeCode
  342. //productId := services.GetProductId(roleTypeCode)
  343. //if productId == 0 {
  344. // c.FailWithMessage("参数错误", "参数解析失败,Err:"+"客户类型为:"+roleTypeCode)
  345. // return
  346. //}
  347. if req.CompanyId <= 0 {
  348. c.FailWithMessage("参数错误", "客户Id小于等于0")
  349. return
  350. }
  351. var condition string
  352. var pars []interface{}
  353. approvalItem, err := company_approval.GetApprovalInfoByApprovalId(condition, pars, req.CompanyApprovalId)
  354. if err != nil {
  355. c.FailWithMessage("获取审批信息失败", "获取信息失败,Err:"+err.Error())
  356. }
  357. if req.Status != 1 && req.Status != 2 {
  358. c.FailWithMessage("参数错误", "审批状态Id小于等于0")
  359. return
  360. }
  361. companyProduct, err := company_product.GetCompanyProductByCompanyIdAndProductId(req.CompanyId, approvalItem.ProductId)
  362. if err != nil {
  363. c.FailWithMessage("获取信息失败", "获取信息失败,Err:"+err.Error())
  364. return
  365. }
  366. if companyProduct == nil {
  367. c.FailWithMessage("获取审批信息失败", "获取信息失败,companyProduct is null")
  368. return
  369. }
  370. //CompanyApprovalId
  371. //数据校验(校验是否具有审批权限)
  372. _, _, approvalRecord, err := company_apply.CheckApproveAuth(req.CompanyId, approvalItem.ProductId, sysUser)
  373. if err != nil {
  374. c.FailWithMessage("审核失败!", "审核失败,Err:"+err.Error())
  375. return
  376. }
  377. //真实审核操作
  378. if req.Status == 1 {
  379. err = company_apply.Approved(approvalRecord, sysUser, req.Remark)
  380. if err != nil {
  381. c.FailWithMessage("审核失败!", "审核失败,Err:"+err.Error())
  382. return
  383. }
  384. } else {
  385. err = company_apply.Reject(approvalRecord, sysUser, req.Remark)
  386. if err != nil {
  387. c.FailWithMessage("审核失败!", "审核失败,Err:"+err.Error())
  388. return
  389. }
  390. }
  391. c.OkWithMessage("审批操作成功")
  392. }