transfer.py 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347
  1. # -*- coding: utf-8 -*-
  2. from enum import Enum
  3. from typing import Dict, List
  4. import arrow
  5. import numpy as np
  6. import pandas as pd
  7. from httpx import AsyncClient, URL
  8. from loguru import logger
  9. from app.core.config import settings
  10. from app.services.service import Service
  11. from app.utils.date import get_time_str, TIME_FMT
  12. from app.utils.math import round_half_up
  13. class Season(str, Enum):
  14. cooling = "Cooling"
  15. heating = "Warm"
  16. transition = "Transition"
  17. class SpaceInfoService(Service):
  18. def __init__(
  19. self,
  20. client: AsyncClient,
  21. project_id: str,
  22. space_id: str,
  23. server_settings=settings,
  24. ) -> None:
  25. super(SpaceInfoService, self).__init__(client)
  26. self._project_id = project_id
  27. self._space_id = space_id
  28. self._base_url = URL(server_settings.TRANSFER_HOST)
  29. self._now_time = get_time_str()
  30. def _common_parameters(self) -> Dict:
  31. return {"projectId": self._project_id, "spaceId": self._space_id}
  32. async def is_customized(self) -> bool:
  33. url = self._base_url.join("duoduo-service/custom-service/custom/timetarget")
  34. time_str = arrow.get(
  35. arrow.get(self._now_time, TIME_FMT).shift(minutes=15).timestamp()
  36. // 900
  37. * 900
  38. ).strftime("%Y%m%d%H%M%S")
  39. params = {
  40. "projectId": self._project_id,
  41. "objectId": self._space_id,
  42. "timepoint": time_str,
  43. }
  44. raw_info = await self._get(url, params)
  45. flag = False
  46. if raw_info.get("data"):
  47. flag = True
  48. return flag
  49. async def is_temporary(self) -> bool:
  50. url = self._base_url.join("duoduo-service/transfer/environment/temp/target")
  51. params = self._common_parameters()
  52. params.update({"time": self._now_time})
  53. raw_info = await self._get(url, params)
  54. flag = False
  55. if raw_info.get("flag") == 1:
  56. flag = True
  57. return flag
  58. async def get_feedback(self, wechat_time: str) -> Dict:
  59. url = self._base_url.join("duoduo-service/transfer/environment/feedbackCount")
  60. params = self._common_parameters()
  61. params.update({"time": wechat_time})
  62. raw_info = await self._get(url, params)
  63. meaning_dict = {
  64. "Id1": "a little cold",
  65. "Id2": "so cold",
  66. "Id3": "a little hot",
  67. "Id4": "so hot",
  68. "Id5": "noisy or blowy",
  69. "Id6": "so stuffy",
  70. "Id7": "more sunshine",
  71. "Id8": "less sunshine",
  72. "Id9": "send a repairman",
  73. "Id10": "switch off",
  74. "Id11": "nice",
  75. "Id12": "switch on",
  76. }
  77. feedback_dic = {
  78. meaning_dict.get(k): v for k, v in raw_info.items() if k != "result"
  79. }
  80. return feedback_dic
  81. async def get_custom_target(self) -> Dict[str, pd.DataFrame]:
  82. url = self._base_url.join(
  83. "duoduo-service/transfer/environment/normalAndPreDayTarget"
  84. )
  85. params = self._common_parameters()
  86. params.update(
  87. {"date": arrow.get(self._now_time, TIME_FMT).date().strftime("%Y%m%d")}
  88. )
  89. raw_info = await self._get(url, params)
  90. try:
  91. pre_target_df = pd.DataFrame(raw_info.get("preTargets"))
  92. pre_target_df.set_index("time", inplace=True)
  93. except (KeyError, TypeError):
  94. pre_target_df = pd.DataFrame()
  95. try:
  96. normal_target_df = pd.DataFrame(raw_info.get("normalTargets"))
  97. normal_target_df.set_index("time", inplace=True)
  98. except (KeyError, TypeError):
  99. normal_target_df = pd.DataFrame()
  100. return {"pre_targets": pre_target_df, "normal_targets": normal_target_df}
  101. async def get_current_temperature_target(self) -> float:
  102. targets = await self.get_custom_target()
  103. if len(targets.get("pre_targets")) > 0:
  104. current_targets = targets.get("pre_targets").append(
  105. targets.get("normal_targets")
  106. )
  107. else:
  108. current_targets = targets.get("normal_targets")
  109. temp = (
  110. arrow.get(self._now_time, TIME_FMT).shift(minutes=15).timestamp()
  111. // (15 * 60)
  112. * (15 * 60)
  113. )
  114. next_quarter_minutes = arrow.get(temp).time().strftime("%H%M%S")
  115. try:
  116. current_lower_target = current_targets["temperatureMin"].loc[
  117. next_quarter_minutes
  118. ]
  119. current_upper_target = current_targets["temperatureMax"].loc[
  120. next_quarter_minutes
  121. ]
  122. except KeyError:
  123. current_lower_target, current_upper_target = np.NAN, np.NAN
  124. return round_half_up((current_lower_target + current_upper_target) / 2, 2)
  125. async def env_database_set(self, form: str, value: float) -> None:
  126. url = self._base_url.join("duoduo-service/transfer/environment/hispoint/set")
  127. params = self._common_parameters()
  128. time_str = arrow.get(
  129. arrow.get(self._now_time, TIME_FMT).timestamp() // 900 * 900
  130. ).strftime("%Y%m%d%H%M%S")
  131. params.update({"time": time_str, "type": form, "value": value})
  132. await self._get(url, params)
  133. async def env_database_get(self) -> Dict[str, pd.DataFrame]:
  134. url = self._base_url.join("duoduo-service/transfer/environment/hispoint/get")
  135. params = self._common_parameters()
  136. params.update(
  137. {"date": arrow.get(self._now_time, TIME_FMT).date().strftime("%Y%m%d")}
  138. )
  139. raw_info = await self._get(url, params)
  140. result = {}
  141. if raw_info.get("result") == "success":
  142. for k, v in raw_info.items():
  143. if k != "result":
  144. if len(v) > 0:
  145. temp = {}
  146. data = np.array(v)
  147. temp.update({"timestamp": data[:, 0]})
  148. temp.update({"value": data[:, 1].astype(np.float)})
  149. result.update({k: pd.DataFrame(temp)})
  150. else:
  151. result.update({k: pd.DataFrame()})
  152. return result
  153. async def set_custom_target(
  154. self, form: str, target_value: Dict[str, List[float]], flag: str = "1"
  155. ) -> None:
  156. url = self._base_url.join("duoduo-service/transfer/environment/target/setting")
  157. params = {
  158. "projectId": self._project_id,
  159. "spaceId": self._space_id,
  160. "timepoint": self._now_time,
  161. "type": form,
  162. "flag": flag,
  163. }
  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