qryErmcp3Report.go 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501
  1. /**
  2. * @Author: zou.yingbin
  3. * @Create : 2021/4/16 18:40
  4. * @Modify : 2021/4/16 18:40
  5. */
  6. package ermcp3
  7. import (
  8. "github.com/gin-gonic/gin"
  9. "mtp2_if/global/app"
  10. "mtp2_if/global/e"
  11. "mtp2_if/logger"
  12. "mtp2_if/models"
  13. "mtp2_if/mtpcache"
  14. "net/http"
  15. "strconv"
  16. )
  17. // 查询日期
  18. type QueryDate string
  19. // IsNumberic 判断是否为数字, queryType 1:8位日期 2:6位日期
  20. func (v QueryDate) IsNumberic(queryType int32) bool {
  21. if queryType == 1 {
  22. // 日报表 日期长度YYYYMMDD
  23. if len(v) != 8 {
  24. return false
  25. }
  26. } else if queryType == 2 {
  27. // 月报表 日期长度YYYYMM
  28. if len(v) != 6 {
  29. return false
  30. }
  31. }
  32. // 判断是否为数字
  33. if _, err := strconv.ParseInt(string(v), 10, 32); err != nil {
  34. return false
  35. }
  36. return true
  37. }
  38. // 检查周期类型、周期时间
  39. type CycleTypeCheck struct {
  40. CYCLETYPE int32 `json:"cycletype" xorm:"'cycletype'"` // 周期类型 - 1:月 2:季 3:年 4:周 5:全报表【原值】
  41. CYCLETIME string `json:"cycletime" xorm:"'cycletime'"` // 周期时间 月(YYYYMM) 季(YYYYQ) 年(YYYY) 周(YYYYMMDD周内任意一天) 全(0)【原值】
  42. }
  43. func (r *CycleTypeCheck) Check() bool {
  44. if r.CYCLETYPE < 1 || r.CYCLETYPE > 5 {
  45. return false
  46. }
  47. nLen := len(r.CYCLETIME)
  48. // 判断是否为数字
  49. if _, err := strconv.ParseInt(r.CYCLETIME, 10, 32); err != nil {
  50. return false
  51. }
  52. // 判断长度
  53. switch r.CYCLETYPE {
  54. case 1:
  55. if nLen != 6 {
  56. return false
  57. }
  58. case 2:
  59. if nLen != 5 {
  60. return false
  61. }
  62. case 3:
  63. if nLen != 4 {
  64. return false
  65. }
  66. case 4:
  67. if nLen != 6 {
  68. return false
  69. }
  70. case 5:
  71. if r.CYCLETIME != "0" {
  72. return false
  73. }
  74. }
  75. return true
  76. }
  77. // QryReportReq 查报表请求
  78. // @Param userid query int true "用户ID"
  79. // @Param querytype query int true "查询类型 1-日报表 2-周期报表 3-日报表(指定时间段[开始交易日,结束交易日]) 4-日报表明细 5-周期报表明细"
  80. // @Param tradedate query string false "交易日(格式yyyymmdd)"
  81. // @Param cycletype query int false "周期类型 - 1:月 2:季 3:年 4:周 5:全报表【原值】"
  82. // @Param cycletime query string false "周期时间 月(YYYYMM) 季(YYYYQ) 年(YYYY) 周(YYYYMMDD周内任意一天) 全(0)【原值】"
  83. // @Param begindate query string false "开始交易日(格式yyyymmdd)"
  84. // @Param enddate query string false "结束交易日(格式yyyymmdd)"
  85. type QryReportReq struct {
  86. USERID int64 `form:"userid" binding:"required"` // 用户id
  87. QUERYTYPE int32 `form:"querytype" binding:"required"` // 查询类型
  88. TRADEDATE string `form:"tradedate"` // 交易日
  89. CYCLETYPE int32 `form:"cycletype"` // 周期类型 - 1:月 2:季 3:年 4:周 5:全报表【原值】
  90. CYCLETIME string `form:"cycletime"` // 周期时间 月(YYYYMM) 季(YYYYQ) 年(YYYY) 周(YYYYMMDD周内任意一天) 全(0)【原值】
  91. BEGINDATE string `form:"begindate"` // 开始交易日
  92. ENDDATE string `form:"enddate"` // 结束交易日
  93. }
  94. // Check 参数检查
  95. func (r *QryReportReq) Check() bool {
  96. // 参数检查
  97. switch r.QUERYTYPE {
  98. case 1, 4:
  99. return QueryDate(r.TRADEDATE).IsNumberic(1)
  100. case 2:
  101. switch r.CYCLETYPE {
  102. case 1, 2, 3, 5:
  103. p := CycleTypeCheck{CYCLETYPE: r.CYCLETYPE, CYCLETIME: r.CYCLETIME}
  104. return p.Check()
  105. case 4:
  106. return QueryDate(r.CYCLETIME).IsNumberic(1)
  107. default:
  108. return false
  109. }
  110. case 3:
  111. return QueryDate(r.BEGINDATE).IsNumberic(1) && QueryDate(r.ENDDATE).IsNumberic(1)
  112. }
  113. return true
  114. }
  115. // CovertRequest 转换查询请求, 日期格式等
  116. func (r *QryReportReq) CovertRequest() {
  117. // 周期报表明细, 转换为查日报表
  118. if r.QUERYTYPE == 5 {
  119. r.QUERYTYPE = 3
  120. switch r.CYCLETYPE {
  121. case 1: // 月
  122. r.BEGINDATE = r.CYCLETIME + "01"
  123. r.ENDDATE = r.CYCLETIME + "31"
  124. case 2: // 季, 暂不实现
  125. case 3: // 年, 暂不实现
  126. case 4: // 周
  127. if w, ok := mtpcache.GetWeekInfo(r.CYCLETIME); ok {
  128. r.BEGINDATE = w.BeginDate
  129. r.ENDDATE = w.EndDate
  130. } else {
  131. // 转换失败 : 一般来说不会转换失败
  132. logger.GetLogger().Errorf("covert cycletime to week fail:", r.CYCLETIME)
  133. }
  134. }
  135. } else {
  136. // 周报表查询, 转换时间格式
  137. if r.CYCLETYPE == 4 {
  138. r.CYCLETIME = mtpcache.GetWeekIW(r.CYCLETIME)
  139. }
  140. }
  141. }
  142. // QryReportDaySpotDetail 查询现货日报表详情(菜单:报表查询/现货报表/现货日报表详情) - 作废
  143. func QryReportDaySpotDetail(c *gin.Context) {
  144. a := app.GinUtils{Gin: app.Gin{C: c}}
  145. req := struct {
  146. USERID int64 `form:"userid" binding:"required"` // 用户id
  147. TRADEDATE string `form:"tradedate" binding:"required"` // 交易日
  148. DELIVERYGOODSID int32 `form:"deliverygoodsid" binding:"required"` // 现货商品id
  149. SPOTGOODSBRANDID int32 `form:"spotgoodsbrandid"` // 品牌id
  150. WRSTANDARDID int32 `form:"wrstandardid"` // 品类id
  151. }{}
  152. a.DoBindReq(&req)
  153. m := models.Ermcp3ReportOPLog{USERID: req.USERID, DELIVERYGOODSID: req.DELIVERYGOODSID,
  154. TRADEDATE: req.TRADEDATE, SPOTGOODSBRANDID: req.SPOTGOODSBRANDID, WRSTANDARDID: req.WRSTANDARDID,
  155. LogTypeFilter: "2,3,24,25,26,27"}
  156. a.DoGetDataI(&m)
  157. }
  158. // QryReportDayFinanceKx 查询财务日报表款项(菜单:报表查询/财务报表/日报表/款项) - 作废
  159. func QryReportDayFinanceKx(c *gin.Context) {
  160. a := app.GinUtils{Gin: app.Gin{C: c}}
  161. req := struct {
  162. USERID int64 `form:"userid" binding:"required"` // 用户id
  163. TRADEDATE string `form:"tradedate" binding:"required"` // 交易日
  164. }{}
  165. a.DoBindReq(&req)
  166. m := models.Ermcp3ReportOPLog{USERID: req.USERID, TRADEDATE: req.TRADEDATE, LogTypeFilter: "8,9,10"}
  167. a.DoGetDataI(&m)
  168. }
  169. // QryReportDayFinanceFp 查询财务日报表发票(菜单:报表查询/财务报表/日报表/发票) - 作废
  170. func QryReportDayFinanceFp(c *gin.Context) {
  171. a := app.GinUtils{Gin: app.Gin{C: c}}
  172. req := struct {
  173. USERID int64 `form:"userid" binding:"required"` // 用户id
  174. TRADEDATE string `form:"tradedate" binding:"required"` // 交易日
  175. }{}
  176. a.DoBindReq(&req)
  177. m := models.Ermcp3ReportOPLog{USERID: req.USERID, TRADEDATE: req.TRADEDATE, LogTypeFilter: "11, 12"}
  178. a.DoGetDataI(&m)
  179. }
  180. // QryReportDaySpot 查询现货日报表(菜单:报表查询/现货报表/现货日报表) - 作废
  181. func QryReportDaySpot(c *gin.Context) {
  182. a := app.GinUtils{Gin: app.Gin{C: c}}
  183. m := models.Ermcp3ReckonAreaSpotSub{}
  184. a.DoBindReq(&m)
  185. a.DoGetDataI(&m)
  186. }
  187. // QryReportMonthSpot 查询现货月报表(菜单:报表查询/现货报表/现货月报表) - 作废
  188. func QryReportMonthSpot(c *gin.Context) {
  189. a := app.GinUtils{Gin: app.Gin{C: c}}
  190. m := models.Ermcp3ReportAreaSpotSub{}
  191. a.DoBindReq(&m)
  192. a.DoGetDataI(&m)
  193. }
  194. // QryReportMonthSpotDetail 查询现货月报表详情(菜单:报表查询/现货月报表/现货月报表详情) - 作废
  195. func QryReportMonthSpotDetail(c *gin.Context) {
  196. a := app.GinUtils{Gin: app.Gin{C: c}}
  197. req := models.Ermcp3ReportAreaSpotSub{}
  198. a.DoBindReq(&req)
  199. if req.CYCLETYPE != 1 || len(req.CYCLETIME) != 6 {
  200. // 目前仅支持月报表明细, 月报表的日期应是6位,如 202101
  201. a.Response(http.StatusBadRequest, e.INVALID_PARAMS, nil)
  202. return
  203. }
  204. t1 := req.CYCLETIME + "01"
  205. t2 := req.CYCLETIME + "31"
  206. // 月报表明细 = 01~31 日报表
  207. m := models.Ermcp3ReckonAreaSpotSub{
  208. AREAUSERID: req.AREAUSERID, DELIVERYGOODSID: req.DELIVERYGOODSID, ACCOUNTID: req.ACCOUNTID,
  209. WRSTANDARDID: req.WRSTANDARDID, SPOTGOODSBRANDID: req.SPOTGOODSBRANDID, BeginDate: t1, EndDate: t2}
  210. a.DoGetDataI(&m)
  211. }
  212. // QryAreaExpourseReport
  213. // @Summary 查询敞口报表
  214. // @Produce json
  215. // @Security ApiKeyAuth
  216. // @Param userid query int true "用户ID"
  217. // @Param querytype query int true "查询类型 1-日报表 2-周期报表 3-日报表(指定时间段[开始交易日,结束交易日]) 4-日报表明细 5-周期报表明细"
  218. // @Param tradedate query string false "交易日(格式yyyymmdd)"
  219. // @Param cycletype query int false "周期类型 - 1:月 2:季 3:年 4:周 5:全报表【原值】"
  220. // @Param cycletime query string false "周期时间 月(YYYYMM) 季(YYYYQ) 年(YYYY) 周(YYYYMMDD周内任意一天) 全(0)【原值】"
  221. // @Param begindate query string false "开始交易日(格式yyyymmdd)"
  222. // @Param enddate query string false "结束交易日(格式yyyymmdd)"
  223. // @Success 200 {array} models.Ermcp3ExpourseReport
  224. // @Failure 500 {object} app.Response
  225. // @Router /Ermcp3/QryAreaExpourseReport [get]
  226. // @Tags 企业风险管理v3(app)
  227. func QryAreaExpourseReport(c *gin.Context) {
  228. a := app.GinUtils{Gin: app.Gin{C: c}}
  229. req := QryReportReq{}
  230. a.DoBindReq(&req)
  231. a.CheckParam(&req)
  232. req.CovertRequest()
  233. m := models.Ermcp3ExpourseReport{AREAUSERID: req.USERID, QueryType: req.QUERYTYPE,
  234. CYCLETYPE: req.CYCLETYPE, CYCLETIME: req.CYCLETIME, BeginDate: req.BEGINDATE, EndDate: req.ENDDATE}
  235. a.DoGetDataI(&m)
  236. }
  237. // QryAreaExpourseContractDetail
  238. // @Summary 查询敞口合同明细(敞口报表/现货合同明细)
  239. // @Produce json
  240. // @Security ApiKeyAuth
  241. // @Param userid query int true "用户ID"
  242. // @Param middlegoodsid query int true "套保商品id"
  243. // @Param tradedate query string true "交易日(格式yyyymmdd)"
  244. // @Success 200 {array} models.Ermcp3ExposureContractDetail
  245. // @Failure 500 {object} app.Response
  246. // @Router /Ermcp3/QryAreaExpourseContractDetail [get]
  247. // @Tags 企业风险管理v3(app)
  248. func QryAreaExpourseContractDetail(c *gin.Context) {
  249. a := app.GinUtils{Gin: app.Gin{C: c}}
  250. req := struct {
  251. USERID int64 `form:"userid" binding:"required"` // 用户id
  252. MIDDLEGOODSID int32 `form:"middlegoodsid" binding:"required"` // 套保商品id
  253. TRADEDATE string `form:"tradedate" binding:"required"` // 交易日(格式yyyymmdd)
  254. }{}
  255. a.DoBindReq(&req)
  256. m := models.Ermcp3ExposureContractDetail{USERID: req.USERID,
  257. MIDDLEGOODSID: req.MIDDLEGOODSID, TRADEDATE: req.TRADEDATE}
  258. a.DoGetDataI(&m)
  259. }
  260. // QryAreaExpourseHedgeplanDetail
  261. // @Summary 查询敞口套保计划明细(敞口报表/套保计划明细)
  262. // @Produce json
  263. // @Security ApiKeyAuth
  264. // @Param userid query int true "用户ID"
  265. // @Param middlegoodsid query int true "套保商品id"
  266. // @Param tradedate query string true "交易日(格式yyyymmdd)"
  267. // @Success 200 {array} models.Ermcp3ExposureHedgeplanDetail
  268. // @Failure 500 {object} app.Response
  269. // @Router /Ermcp3/QryAreaExpourseHedgeplanDetail [get]
  270. // @Tags 企业风险管理v3(app)
  271. func QryAreaExpourseHedgeplanDetail(c *gin.Context) {
  272. a := app.GinUtils{Gin: app.Gin{C: c}}
  273. req := struct {
  274. USERID int64 `form:"userid" binding:"required"` // 用户id
  275. MIDDLEGOODSID int32 `form:"middlegoodsid" binding:"required"` // 套保商品id
  276. TRADEDATE string `form:"tradedate" binding:"required"` // 交易日(格式yyyymmdd)
  277. }{}
  278. a.DoBindReq(&req)
  279. m := models.Ermcp3ExposureHedgeplanDetail{USERID: req.USERID,
  280. MIDDLEGOODSID: req.MIDDLEGOODSID, TRADEDATE: req.TRADEDATE}
  281. a.DoGetDataI(&m)
  282. }
  283. // QryAreaSpotplReport
  284. // @Summary 查询现货报表
  285. // @Produce json
  286. // @Security ApiKeyAuth
  287. // @Param userid query int true "用户ID"
  288. // @Param querytype query int true "查询类型 1-日报表 2-周期报表 3-日报表(指定时间段[开始交易日,结束交易日]) 4-日报表明细 5-周期报表明细"
  289. // @Param tradedate query string false "交易日(格式yyyymmdd)"
  290. // @Param cycletype query int false "周期类型 - 1:月 2:季 3:年 4:周 5:全报表【原值】"
  291. // @Param cycletime query string false "周期时间 月(YYYYMM) 季(YYYYQ) 年(YYYY) 周(YYYYMMDD周内任意一天) 全(0)【原值】"
  292. // @Param begindate query string false "开始交易日(格式yyyymmdd)"
  293. // @Param enddate query string false "结束交易日(格式yyyymmdd)"
  294. // @Param deliverygoodsid query int false "现货品种id"
  295. // @Param wrstandardid query int false "品类id"
  296. // @Param currencyid query int false "币种id"
  297. // @Success 200 {array} models.Ermcp3AreaSpotPLReport
  298. // @Failure 500 {object} app.Response
  299. // @Router /Ermcp3/QryAreaSpotplReport [get]
  300. // @Tags 企业风险管理v3(app)
  301. func QryAreaSpotplReport(c *gin.Context) {
  302. a := app.GinUtils{Gin: app.Gin{C: c}}
  303. req := QryReportReq{}
  304. a.DoBindReq(&req)
  305. a.CheckParam(&req)
  306. req2 := struct {
  307. DELIVERYGOODSID int64 `form:"deliverygoodsid"` // 品种
  308. WRSTANDARDID int64 `form:"wrstandardid"` // 品类
  309. CURRENCYID int32 `form:"currencyid"` // 币种
  310. }{}
  311. if req.QUERYTYPE == 4 {
  312. a.DoBindReq(&req2)
  313. a.CheckParamF(func() bool {
  314. if req2.DELIVERYGOODSID <= 0 || req2.WRSTANDARDID <= 0 || req2.CURRENCYID <= 0 {
  315. return false
  316. }
  317. return true
  318. })
  319. }
  320. req.CovertRequest()
  321. m := models.Ermcp3AreaSpotPLReport{AREAUSERID: req.USERID, QueryType: req.QUERYTYPE, RECKONDATE: req.TRADEDATE,
  322. CYCLETYPE: req.CYCLETYPE, CYCLETIME: req.CYCLETIME, BeginDate: req.BEGINDATE, EndDate: req.ENDDATE,
  323. DELIVERYGOODSID: req2.DELIVERYGOODSID, WRSTANDARDID: req2.WRSTANDARDID, CURRENCYID: req2.CURRENCYID}
  324. a.DoGetDataI(&m)
  325. }
  326. // QryFinanceReport
  327. // @Summary 查询财务报表
  328. // @Produce json
  329. // @Security ApiKeyAuth
  330. // @Param userid query int true "用户ID"
  331. // @Param querytype query int true "查询类型 1-日报表 2-周期报表 3-日报表(指定时间段[开始交易日,结束交易日]) 4-日报表明细 5-周期报表明细"
  332. // @Param tradedate query string false "交易日(格式yyyymmdd)"
  333. // @Param cycletype query int false "周期类型 - 1:月 2:季 3:年 4:周 5:全报表【原值】"
  334. // @Param cycletime query string false "周期时间 月(YYYYMM) 季(YYYYQ) 年(YYYY) 周(YYYYMMDD周内任意一天) 全(0)【原值】"
  335. // @Param begindate query string false "开始交易日(格式yyyymmdd)"
  336. // @Param enddate query string false "结束交易日(格式yyyymmdd)"
  337. // @Param currencyid query int false "币种id(日报表明细)"
  338. // @Success 200 {array} models.Ermcp3FinanceReport
  339. // @Failure 500 {object} app.Response
  340. // @Router /Ermcp3/QryFinanceReport [get]
  341. // @Tags 企业风险管理v3(app)
  342. func QryFinanceReport(c *gin.Context) {
  343. a := app.GinUtils{Gin: app.Gin{C: c}}
  344. req := QryReportReq{}
  345. a.DoBindReq(&req)
  346. a.CheckParam(&req)
  347. req2 := struct {
  348. CURRENCYID int32 `form:"currencyid"` // 币种id
  349. }{}
  350. a.DoBindReq(&req2)
  351. a.CheckParamF(func() bool {
  352. if req.QUERYTYPE == 4 {
  353. return req2.CURRENCYID > 0
  354. }
  355. return true
  356. })
  357. req.CovertRequest()
  358. m := models.Ermcp3FinanceReport{AREAUSERID: req.USERID, QueryType: req.QUERYTYPE, RECKONDATE: req.TRADEDATE,
  359. CYCLETYPE: req.CYCLETYPE, CYCLETIME: req.CYCLETIME, BeginDate: req.BEGINDATE, EndDate: req.ENDDATE, CURRENCYID: req2.CURRENCYID}
  360. a.DoGetDataI(&m)
  361. }
  362. // QryAreaStockReport
  363. // @Summary 查询库存报表
  364. // @Produce json
  365. // @Security ApiKeyAuth
  366. // @Param userid query int true "用户ID"
  367. // @Param querytype query int true "查询类型 1-日报表 2-周期报表 3-日报表(指定时间段[开始交易日,结束交易日]) 4-日报表明细 5-周期报表明细"
  368. // @Param tradedate query string false "交易日(格式yyyymmdd)"
  369. // @Param cycletype query int false "周期类型 - 1:月 2:季 3:年 4:周 5:全报表【原值】"
  370. // @Param cycletime query string false "周期时间 月(YYYYMM) 季(YYYYQ) 年(YYYY) 周(YYYYMMDD周内任意一天) 全(0)【原值】"
  371. // @Param begindate query string false "开始交易日(格式yyyymmdd)"
  372. // @Param enddate query string false "结束交易日(格式yyyymmdd)"
  373. // @Param deliverygoodsid query int false "现货商品ID"
  374. // @Param wrstandardid query int false "品类ID"
  375. // @Param spotgoodsbrandid query int false "品牌ID"
  376. // @Success 200 {array} models.Ermcp3AreaStockReport
  377. // @Failure 500 {object} app.Response
  378. // @Router /Ermcp3/QryAreaStockReport [get]
  379. // @Tags 企业风险管理v3(app)
  380. func QryAreaStockReport(c *gin.Context) {
  381. a := app.GinUtils{Gin: app.Gin{C: c}}
  382. req := QryReportReq{}
  383. req2 := struct {
  384. DELIVERYGOODSID int32 `form:"deliverygoodsid"` // 现货品种id
  385. WRSTANDARDID int32 `form:"wrstandardid"` // 品类ID
  386. SPOTGOODSBRANDID int32 `form:"spotgoodsbrandid"` // 品牌id
  387. }{}
  388. a.DoBindReq(&req)
  389. a.CheckParam(&req)
  390. a.DoBindReq(&req2)
  391. if req.QUERYTYPE == 4 {
  392. a.CheckParamF(func() bool {
  393. if req2.DELIVERYGOODSID <= 0 || req2.WRSTANDARDID <= 0 || req2.SPOTGOODSBRANDID <= 0 {
  394. return false
  395. }
  396. return true
  397. })
  398. }
  399. req.CovertRequest()
  400. m := models.Ermcp3AreaStockReport{USERID: req.USERID, QueryType: req.QUERYTYPE, RECKONDATE: req.TRADEDATE,
  401. CYCLETYPE: req.CYCLETYPE, CYCLETIME: req.CYCLETIME, BeginDate: req.BEGINDATE, EndDate: req.ENDDATE,
  402. DELIVERYGOODSID: req2.DELIVERYGOODSID, WRSTANDARDID: req2.WRSTANDARDID, SPOTGOODSBRANDID: req2.SPOTGOODSBRANDID}
  403. a.DoGetDataI(&m)
  404. }
  405. // QueryAreaStockReportDetail
  406. // 查询库存报表明细 - 作废
  407. func QueryAreaStockReportDetail(c *gin.Context) {
  408. a := app.GinUtils{Gin: app.Gin{C: c}}
  409. req := struct {
  410. USERID int64 `form:"userid" binding:"required"` // 机构ID
  411. DELIVERYGOODSID int32 `form:"deliverygoodsid"` // 现货品种id
  412. WRSTANDARDID int32 `form:"wrstandardid"` // 品类ID
  413. SPOTGOODSBRANDID int32 `form:"spotgoodsbrandid"` // 品牌id
  414. WAREHOUSEINFOID string `form:"warehouseinfoid"` // 现货仓库ID
  415. QUERYTYPE int32 `form:"querytype" binding:"required"` // 查询类型
  416. QUERYDATE string `form:"querydate" binding:"required"` // 查询日期
  417. DETAILTYPE int32 `form:"detailtype" binding:"required"` // 明细类型
  418. }{}
  419. a.DoBindReq(&req)
  420. if QueryDate(req.QUERYDATE).IsNumberic(req.QUERYTYPE) {
  421. var beginDate, endDate string
  422. if req.QUERYTYPE == 1 {
  423. beginDate = req.QUERYDATE
  424. endDate = beginDate
  425. } else if req.QUERYTYPE == 2 {
  426. beginDate = req.QUERYDATE + "01"
  427. endDate = req.QUERYDATE + "31"
  428. }
  429. m := models.Ermcp3AreaStockApply{USERID: req.USERID, WRSTANDARDID: req.WRSTANDARDID,
  430. SPOTGOODSBRANDID: req.SPOTGOODSBRANDID, DELIVERYGOODSID: req.DELIVERYGOODSID,
  431. WAREHOUSEINFOID: req.WAREHOUSEINFOID, BeginDate: beginDate, EndDate: endDate, APPLYSTATUS: 2}
  432. // 出入库类型(可多项,逗号隔开) 1:采购入库 2:销售出库 3:生产入库 4:生产出库"
  433. if req.DETAILTYPE == 1 {
  434. m.FilterType = "1,3"
  435. } else if req.DETAILTYPE == 2 {
  436. m.FilterType = "2,4"
  437. }
  438. a.DoGetDataI(&m)
  439. } else {
  440. a.Gin.Response(http.StatusBadRequest, e.INVALID_PARAMS, nil)
  441. }
  442. }
  443. // QryAreaSumPL
  444. // @Summary 查询汇总损益表
  445. // @Produce json
  446. // @Security ApiKeyAuth
  447. // @Param userid query int true "用户ID"
  448. // @Param querytype query int true "查询类型 1-日报表 2-周期报表 3-日报表(指定时间段[开始交易日,结束交易日]) 4-日报表明细 5-周期报表明细"
  449. // @Param tradedate query string false "交易日(格式yyyymmdd)"
  450. // @Param cycletype query int false "周期类型 - 1:月 2:季 3:年 4:周 5:全报表【原值】"
  451. // @Param cycletime query string false "周期时间 月(YYYYMM) 季(YYYYQ) 年(YYYY) 周(YYYYMMDD周内任意一天) 全(0)【原值】"
  452. // @Param begindate query string false "开始交易日(格式yyyymmdd)"
  453. // @Param enddate query string false "结束交易日(格式yyyymmdd)"
  454. // @Param currencyid query int false "币种id(日报表明细)"
  455. // @Success 200 {array} models.Ermcp3ArealSumPL
  456. // @Failure 500 {object} app.Response
  457. // @Router /Ermcp3/QryAreaSumPL [get]
  458. // @Tags 企业风险管理v3(app)
  459. func QryAreaSumPL(c *gin.Context) {
  460. a := app.GinUtils{Gin: app.Gin{C: c}}
  461. req := QryReportReq{}
  462. a.DoBindReq(&req)
  463. a.CheckParam(&req)
  464. req2 := struct {
  465. CURRENCYID int32 `form:"currencyid"` // 币种id
  466. }{}
  467. a.DoBindReq(&req2)
  468. a.CheckParamF(func() bool {
  469. if req.QUERYTYPE == 4 {
  470. return req2.CURRENCYID > 0
  471. }
  472. return true
  473. })
  474. req.CovertRequest()
  475. m := models.Ermcp3ArealSumPL{AREAUSERID: req.USERID, QueryType: req.QUERYTYPE, RECKONDATE: req.TRADEDATE,
  476. CYCLETYPE: req.CYCLETYPE, CYCLETIME: req.CYCLETIME, BeginDate: req.BEGINDATE, EndDate: req.ENDDATE, CURRENCYID: req2.CURRENCYID}
  477. a.DoGetDataI(&m)
  478. }