PropertyFamilyService.kt 5.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113
  1. /*
  2. * *********************************************************************************************************************
  3. *
  4. * !!
  5. * .F88X
  6. * X8888Y
  7. * .}888888N;
  8. * i888888N; .:! .I$WI:
  9. * R888888I .'N88~ i8}+8Y&8"l8i$8>8W~'>W8}8]KW+8IIN"8&
  10. * .R888888I .;N8888~ .X8' "8I.!,/8" !%NY8`"8I8~~8>,88I
  11. * +888888N; .8888888Y "&&8Y.}8,
  12. * ./888888N; .R888888Y .'}~ .>}'.`+> i}! "i' +/' .'i~ !11,.:">, .~]! .i}i
  13. * ~888888%: .I888888l .]88~`1/iY88Ii+1'.R$8$8]"888888888> Y8$ W8E X8E W8888'188Il}Y88$*
  14. * 18888888 E8888881 .]W%8$`R8X'&8%++N8i,8N%N8+l8%` .}8N:.R$RE%N88N%N$K$R 188,FE$8%~Y88I
  15. * .E888888I .i8888888' .:$8I;88+`E8R:/8N,.>881.`$8E/1/]N8X.Y8N`"KF&&FK!'88*."88K./$88%RN888+~
  16. * 8888888I .,N888888~ ~88i"8W,!N8*.I88.}888%F,i$88"F88" 888:E8X.>88!i88>`888*.}Fl1]*}1YKi'
  17. * i888888N' I888Y ]88;/EX*IFKFK88X K8R .l8W 88Y ~88}'88E&%8W.X8N``]88!.$8K .:W8I
  18. * .i888888N; I8Y .&8$ .X88! i881.:%888>I88 ;88] +88+.';;;;:.Y88X 18N.,88l .+88/
  19. * .:R888888I
  20. * .&888888I Copyright (c) 2009-2020. 博锐尚格科技股份有限公司
  21. * ~8888'
  22. * .!88~ All rights reserved.
  23. *
  24. * *********************************************************************************************************************
  25. */
  26. package com.persagy.server.service
  27. import com.persagy.database.SPageQueryInfo
  28. import com.persagy.database.SQueryBuilder
  29. import com.persagy.mybatis.SMybatisDao
  30. import com.persagy.server.models.PointPorperty
  31. import com.persagy.server.models.PropertyFamily
  32. import com.persagy.server.service.base.Service
  33. import com.persagy.service.SObjectService
  34. import com.persagy.service.SPageContext
  35. import com.persagy.service.models.enums.SResponseType
  36. import com.persagy.service.models.requests.SQueryRequest
  37. import com.persagy.service.models.responses.SQueryResponse
  38. import org.slf4j.LoggerFactory
  39. /**
  40. * 资产关联设备信息服务
  41. *
  42. * @author 张维新
  43. */
  44. object PropertyFamilyService : Service<PropertyFamily>(SMybatisDao(PropertyFamily::class.java)) {
  45. /** 日志 */
  46. private val logger = LoggerFactory.getLogger(PropertyFamilyService::class.java)
  47. val pointPorpertyService = SObjectService(SMybatisDao(PointPorperty::class.java))
  48. /**
  49. * 查询之前的操作
  50. */
  51. override fun onQueryBefore(queryBuilder: SQueryBuilder<PropertyFamily>) {
  52. val projectId = SPageContext.getHeader("projectId").toString()
  53. queryBuilder.tableName = "f_project_family('$projectId')"
  54. return
  55. } // Function onQueryBefore()
  56. /**
  57. * 查询项目下的设备族分类
  58. *
  59. * @param buildingId 建筑id
  60. * @param floorId 楼层id
  61. * @param startTime 开始时间
  62. * @param endingTime 结束时间
  63. * @param pointId 点位标签id
  64. * @param checked 是否修订
  65. */
  66. fun queryFamily(buildingId: String?, floorId: String?,startTime: String?, endingTime: String?,pointId: String?, checked: String?): SQueryResponse<PropertyFamily> {
  67. val pageQuery: SPageQueryInfo<PropertyFamily>
  68. return try {
  69. var request = SQueryRequest()
  70. val projectId = SPageContext.getHeader("projectId").toString()
  71. val queryBuilder = select(request.filters)
  72. queryBuilder.tableName = "f_project_family('$projectId','$buildingId','$floorId','$startTime','$endingTime','$pointId','$checked')"
  73. pageQuery = queryBuilder.pageQuery(1, 1000)
  74. SQueryResponse(pageQuery)
  75. } catch (e: Exception) {
  76. e.printStackTrace()
  77. SQueryResponse(SResponseType.failure, e.message!!)
  78. }
  79. } // Function queryFamily()
  80. /**
  81. * 查询项目下的设备族分类
  82. *
  83. * @param buildingId 建筑id
  84. * @param floorId 楼层id
  85. * @param startTime 开始时间
  86. * @param endingTime 结束时间
  87. */
  88. fun queryPointPorperty(buildingId: String?, floorId: String?,startTime: String?, endingTime: String?): SQueryResponse<PointPorperty>{
  89. val pageQuery: SPageQueryInfo<PointPorperty>
  90. return try {
  91. var request = SQueryRequest()
  92. val projectId = SPageContext.getHeader("projectId").toString()
  93. val queryBuilder = pointPorpertyService.select(request.filters)
  94. queryBuilder.tableName = "f_point_poroerty('$projectId','$buildingId','$floorId','$startTime','$endingTime')"
  95. pageQuery = queryBuilder.pageQuery(1, 1000)
  96. SQueryResponse(pageQuery)
  97. } catch (e: Exception) {
  98. e.printStackTrace()
  99. SQueryResponse(SResponseType.failure, e.message!!)
  100. }
  101. } // Function queryPointPorperty()
  102. } // Object PropertyService