transfer.py 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347
  1. # -*- coding: utf-8 -*-
  2. from enum import Enum
  3. import arrow
  4. import httpx
  5. import numpy as np
  6. import pandas as pd
  7. from httpx import AsyncClient, URL
  8. from app.core.config import settings
  9. from app.services.service import Service
  10. from app.utils.date import get_time_str, TIME_FMT
  11. from app.utils.math import round_half_up
  12. class Season(str, Enum):
  13. cooling = "Cooling"
  14. heating = "Warm"
  15. transition = "Transition"
  16. class SpaceInfoService(Service):
  17. def __init__(
  18. self,
  19. client: AsyncClient,
  20. project_id: str,
  21. space_id: str,
  22. server_settings=settings,
  23. ) -> None:
  24. super(SpaceInfoService, self).__init__(client)
  25. self._project_id = project_id
  26. self._space_id = space_id
  27. self._base_url = URL(server_settings.TRANSFER_HOST)
  28. self._now_time = get_time_str()
  29. def _common_parameters(self) -> dict:
  30. return {"projectId": self._project_id, "spaceId": self._space_id}
  31. async def is_customized(self) -> bool:
  32. url = self._base_url.join("duoduo-service/custom-service/custom/timetarget")
  33. time_str = arrow.get(
  34. arrow.get(self._now_time, TIME_FMT).shift(minutes=15).timestamp()
  35. // 900
  36. * 900
  37. ).strftime("%Y%m%d%H%M%S")
  38. params = {
  39. "projectId": self._project_id,
  40. "objectId": self._space_id,
  41. "timepoint": time_str,
  42. }
  43. raw_info = await self._get(url, params)
  44. flag = False
  45. if raw_info.get("data"):
  46. flag = True
  47. return flag
  48. async def is_temporary(self) -> bool:
  49. url = self._base_url.join("duoduo-service/transfer/environment/temp/target")
  50. params = self._common_parameters()
  51. params.update({"time": self._now_time})
  52. raw_info = await self._get(url, params)
  53. flag = False
  54. if raw_info.get("flag") == 1:
  55. flag = True
  56. return flag
  57. async def get_feedback(self, wechat_time: str) -> dict:
  58. url = self._base_url.join("duoduo-service/transfer/environment/feedbackCount")
  59. params = self._common_parameters()
  60. params.update({"time": wechat_time})
  61. raw_info = await self._get(url, params)
  62. meaning_dict = {
  63. "Id1": "a little cold",
  64. "Id2": "so cold",
  65. "Id3": "a little hot",
  66. "Id4": "so hot",
  67. "Id5": "noisy or blowy",
  68. "Id6": "so stuffy",
  69. "Id7": "more sunshine",
  70. "Id8": "less sunshine",
  71. "Id9": "send a repairman",
  72. "Id10": "switch off",
  73. "Id11": "nice",
  74. "Id12": "switch on",
  75. }
  76. feedback_dic = {
  77. meaning_dict.get(k): v for k, v in raw_info.items() if k != "result"
  78. }
  79. return feedback_dic
  80. async def get_custom_target(self) -> dict[str, pd.DataFrame]:
  81. url = self._base_url.join(
  82. "duoduo-service/transfer/environment/normalAndPreDayTarget"
  83. )
  84. params = self._common_parameters()
  85. params.update(
  86. {"date": arrow.get(self._now_time, TIME_FMT).date().strftime("%Y%m%d")}
  87. )
  88. raw_info = await self._get(url, params)
  89. try:
  90. pre_target_df = pd.DataFrame(raw_info.get("preTargets"))
  91. pre_target_df.set_index("time", inplace=True)
  92. except (KeyError, TypeError):
  93. pre_target_df = pd.DataFrame()
  94. try:
  95. normal_target_df = pd.DataFrame(raw_info.get("normalTargets"))
  96. normal_target_df.set_index("time", inplace=True)
  97. except (KeyError, TypeError):
  98. normal_target_df = pd.DataFrame()
  99. return {"pre_targets": pre_target_df, "normal_targets": normal_target_df}
  100. async def get_current_temperature_target(self) -> float:
  101. targets = await self.get_custom_target()
  102. if len(targets.get("pre_targets")) > 0:
  103. current_targets = targets.get("pre_targets").append(
  104. targets.get("normal_targets")
  105. )
  106. else:
  107. current_targets = targets.get("normal_targets")
  108. temp = (
  109. arrow.get(self._now_time, TIME_FMT).shift(minutes=15).timestamp()
  110. // (15 * 60)
  111. * (15 * 60)
  112. )
  113. next_quarter_minutes = arrow.get(temp).time().strftime("%H%M%S")
  114. try:
  115. current_lower_target = current_targets["temperatureMin"].loc[
  116. next_quarter_minutes
  117. ]
  118. current_upper_target = current_targets["temperatureMax"].loc[
  119. next_quarter_minutes
  120. ]
  121. except KeyError:
  122. current_lower_target, current_upper_target = np.NAN, np.NAN
  123. return round_half_up((current_lower_target + current_upper_target) / 2, 2)
  124. async def env_database_set(self, form: str, value: float) -> None:
  125. url = self._base_url.join("duoduo-service/transfer/environment/hispoint/set")
  126. params = self._common_parameters()
  127. time_str = arrow.get(
  128. arrow.get(self._now_time, TIME_FMT).timestamp() // 900 * 900
  129. ).strftime("%Y%m%d%H%M%S")
  130. params.update({"time": time_str, "type": form, "value": value})
  131. await self._get(url, params)
  132. async def env_database_get(self) -> dict[str, pd.DataFrame]:
  133. url = self._base_url.join("duoduo-service/transfer/environment/hispoint/get")
  134. params = self._common_parameters()
  135. params.update(
  136. {"date": arrow.get(self._now_time, TIME_FMT).date().strftime("%Y%m%d")}
  137. )
  138. raw_info = await self._get(url, params)
  139. result = {}
  140. if raw_info.get("result") == "success":
  141. for k, v in raw_info.items():
  142. if k != "result":
  143. if len(v) > 0:
  144. temp = {}
  145. data = np.array(v)
  146. temp.update({"timestamp": data[:, 0]})
  147. temp.update({"value": data[:, 1].astype(np.float)})
  148. result.update({k: pd.DataFrame(temp)})
  149. else:
  150. result.update({k: pd.DataFrame()})
  151. return result
  152. def set_custom_target(
  153. self, form: str, target_value: dict[str, list[float]], flag: str = "1"
  154. ) -> None:
  155. url = self._base_url.join("duoduo-service/transfer/environment/target/setting")
  156. params = {
  157. "projectId": self._project_id,
  158. "spaceId": self._space_id,
  159. "timepoint": self._now_time,
  160. "type": form,
  161. "flag": flag,
  162. }
  163. httpx.post(url, params=params, json=target_value)
  164. # await self._post(url, params=params, payload=target_value)
  165. async def set_temporary_custom(self) -> None:
  166. url = self._base_url.join("duoduo-service/transfer/environment/setServiceFlag")
  167. params = self._common_parameters()
  168. params.update({"time": self._now_time})
  169. await self._get(url, params)
  170. async def get_equipment(self) -> list[dict]:
  171. url = self._base_url.join(
  172. "duoduo-service/object-service/object/equipment/findForServe"
  173. )
  174. params = self._common_parameters()
  175. raw_info = await self._post(url, params)
  176. result = []
  177. for eq in raw_info.get("data"):
  178. result.append({"id": eq.get("id"), "category": eq.get("equipmentCategory")})
  179. return result
  180. class Duoduo(Service):
  181. def __init__(self, client: AsyncClient, project_id: str, server_settings=settings):
  182. super(Duoduo, self).__init__(client)
  183. self._project_id = project_id
  184. self._base_url = URL(server_settings.TRANSFER_HOST)
  185. self._now_time = get_time_str()
  186. async def get_season(self) -> Season:
  187. url = self._base_url.join("duoduo-service/transfer/environment/getSeasonType")
  188. params = {
  189. "projectId": self._project_id,
  190. "date": self._now_time,
  191. }
  192. raw_info = await self._get(url, params)
  193. return Season(raw_info.get("data"))
  194. async def get_fill_count(self) -> dict:
  195. url = self._base_url.join(
  196. "duoduo-service/review-service/space/report/quarter/query"
  197. )
  198. payload = {
  199. "criteria": {
  200. "projectId": self._project_id,
  201. "date": arrow.get(self._now_time, TIME_FMT).date().strftime("%Y%m%d"),
  202. },
  203. "orders": [{"column": "time", "asc": False}],
  204. "page": 1,
  205. "size": 1,
  206. }
  207. raw_info = await self._post(url, payload=payload)
  208. try:
  209. result = raw_info.get("content")[-1]
  210. except (IndexError, TypeError):
  211. result = {}
  212. return result
  213. async def get_space_by_equipment(self, equipment_id: str) -> list[dict]:
  214. url = self._base_url.join(
  215. "duoduo-service/object-service/object/space/findForServe"
  216. )
  217. params = {"projectId": self._project_id, "objectId": equipment_id}
  218. raw_info = await self._post(url, params)
  219. result = []
  220. for sp in raw_info.get("data"):
  221. if sp.get("isControlled"):
  222. result.append({"id": sp.get("id")})
  223. return result
  224. async def get_system_by_equipment(self, equipment_id: str) -> list:
  225. url = self._base_url.join(
  226. "duoduo-service/object-service/object/system/findForCompose"
  227. )
  228. params = {"projectId": self._project_id, "equipmentId": equipment_id}
  229. raw_info = await self._post(url, params)
  230. system_list = []
  231. for sy in raw_info.get("data"):
  232. system_list.append({"id": sy.get("id")})
  233. return system_list
  234. async def get_day_type(self) -> dict:
  235. url = self._base_url.join("duoduo-service/custom-service/custom/getDateInfo")
  236. params = {
  237. "projectId": self._project_id,
  238. "date": arrow.get(self._now_time, TIME_FMT).date().strftime("%Y%m%d"),
  239. }
  240. raw_info = await self._get(url, params)
  241. result = {
  242. "day_type": raw_info.get("dayType"),
  243. "season": raw_info.get("seasonType"),
  244. }
  245. return result
  246. async def query_device_virtual_data(self, device_id: str, info_code: str) -> float:
  247. url = self._base_url.join("duoduo-service/review-service/equipment/order/query")
  248. payload = {
  249. "criteria": {
  250. "projectId": self._project_id,
  251. "objectId": device_id,
  252. "date": arrow.get(self._now_time, TIME_FMT).date().strftime("%Y%m%d"),
  253. "funcId": info_code,
  254. }
  255. }
  256. raw_info = await self._post(url, payload=payload)
  257. try:
  258. latest_data = raw_info.get("data")[-1].get("value")
  259. latest_time = raw_info.get("data")[-1].get("realTime")
  260. if arrow.get(latest_time, TIME_FMT).shift(minutes=15) < arrow.get(
  261. self._now_time, TIME_FMT
  262. ):
  263. value = np.NAN
  264. else:
  265. value = latest_data
  266. except (KeyError, TypeError, IndexError):
  267. value = np.NAN
  268. return value
  269. async def query_fill_rate_by_device(self, device_id: str) -> [float, float]:
  270. url = self._base_url.join(
  271. "duoduo-service/review-service/space/quarter/getQueryByCategory"
  272. )
  273. payload = {
  274. "criteria": {
  275. "projectId": self._project_id,
  276. "date": arrow.get(self._now_time, TIME_FMT).date().strftime("%Y%m%d"),
  277. "eqId": device_id,
  278. }
  279. }
  280. raw_info = await self._post(url, payload=payload)
  281. try:
  282. value_info = raw_info["content"][-1]
  283. hot_count = value_info["hotSpaceNum"]
  284. cold_count = value_info["coldSpaceNum"]
  285. total = value_info["spaceNum"]
  286. hot_rate = hot_count / total
  287. cold_rate = cold_count / total
  288. except (KeyError, IndexError, ZeroDivisionError):
  289. hot_rate, cold_rate = np.NAN, np.NAN
  290. return hot_rate, cold_rate