approval_new.go 15 KB

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