TelecomObject.py 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426
  1. # -*- encoding: utf-8 -*-
  2. """
  3. @File : TelecomObject.py
  4. @Time : 2024/1/11 10:40
  5. @Author : stephen
  6. @Email : zhangdongming@asj6.wecom.work
  7. @Software: PyCharm
  8. """
  9. import json
  10. import requests
  11. import xmltodict
  12. from Ansjer.config import CT_USER_ID, CT_PASSWORD, CT_SECRET_KEY, LOGGER
  13. from Object.utils import LocalDateTimeUtil
  14. from Object.utils.DesUtils import DesUtils
  15. class TelecomObject:
  16. def __init__(self):
  17. self.user_id = CT_USER_ID
  18. self.password = CT_PASSWORD
  19. self.secret_key = CT_SECRET_KEY
  20. self.key1 = CT_SECRET_KEY[0:3]
  21. self.key2 = CT_SECRET_KEY[3:6]
  22. self.key3 = CT_SECRET_KEY[6:9]
  23. self.url = 'http://api.ct10649.com:9001/m2m_ec/query.do'
  24. self.session = requests.Session()
  25. def get_password_enc(self):
  26. return DesUtils.str_enc(self.password, self.key1, self.key2, self.key3)
  27. def get_sign(self, arr):
  28. return DesUtils.str_enc(DesUtils.natural_ordering(arr), self.key1, self.key2, self.key3)
  29. def get_required_arr(self, iccid, method):
  30. return [iccid, self.user_id, self.password, method]
  31. def get_params_dict_by_iccid(self, method, iccid, arr):
  32. return {'method': method, 'iccid': iccid,
  33. 'user_id': self.user_id,
  34. 'passWord': self.get_password_enc(),
  35. 'sign': self.get_sign(arr)}
  36. def get_params_dict_by_access_number(self, method, access_number, arr):
  37. return {'method': method, 'access_number': access_number,
  38. 'user_id': self.user_id,
  39. 'passWord': self.get_password_enc(),
  40. 'sign': self.get_sign(arr)}
  41. def query_card_main_status(self, iccid):
  42. """
  43. 卡主状态查询接口
  44. :param iccid: 卡的ICCID号。
  45. :return: 包含卡状态的结果字典。
  46. :raises ValueError: 如果响应为空或HTTP请求失败。
  47. """
  48. try:
  49. if not iccid:
  50. raise ValueError("error ICCID不能为空")
  51. method = 'queryCardMainStatus'
  52. arr = self.get_required_arr(iccid, method)
  53. # 密码加密
  54. re_params = self.get_params_dict_by_iccid(method, iccid, arr)
  55. response = self.session.get(self.url, params=re_params)
  56. if response.status_code != 200:
  57. LOGGER(f"*****TelecomObject.query_card_main_status error HTTP请求失败,状态码: {response.status_code}")
  58. return None
  59. result = response.json()
  60. LOGGER.info(f'*****TelecomObject.query_card_main_status****iccid:{iccid},result:{result}')
  61. return result
  62. except Exception as e:
  63. LOGGER.info('***TelecomObject.query_card_main_status:errLine:{}, errMsg:{}'
  64. .format(e.__traceback__.tb_lineno, repr(e)))
  65. return None
  66. def query_total_usage_by_date(self, access_number):
  67. """
  68. 总使用量查询接口(时间段) 不可跨月查询
  69. :param access_number: 11位接入号码
  70. :return: 套餐使用量查询结果
  71. :raises ValueError: 如果响应为空或HTTP请求失败。
  72. """
  73. try:
  74. if not access_number:
  75. raise ValueError("error access_number不能为空")
  76. start_date = LocalDateTimeUtil.get_first_day_of_month()
  77. end_date = LocalDateTimeUtil.get_last_day_of_month()
  78. method = 'queryTotalUsageByDate'
  79. arr = [method, self.user_id, access_number, self.password, start_date, end_date]
  80. re_params = self.get_params_dict_by_access_number(method, access_number, arr)
  81. re_params['startDate'] = start_date
  82. re_params['endDate'] = end_date
  83. response = self.session.get(self.url, params=re_params)
  84. if response.status_code != 200:
  85. LOGGER.info(f"*****TelecomObject.query_total_usage_by_date error HTTP请求失败,状态码: {response.status_code}")
  86. return None
  87. msg = response.text
  88. if not msg:
  89. return None
  90. # 检查响应类型
  91. content_type = response.headers.get('Content-Type', '')
  92. if 'application/xml' in content_type or 'text/xml' in content_type:
  93. result = xmltodict.parse(msg)
  94. elif 'application/json' in content_type or 'text/json' in content_type:
  95. result = json.loads(msg)
  96. LOGGER.info(f"***TelecomObject.query_total_usage_by_date查询流量异常{access_number},error{result}")
  97. return None
  98. else:
  99. return None
  100. return result
  101. except Exception as e:
  102. LOGGER.info('***TelecomObject.query_total_usage_by_date:errLine:{}, errMsg:{}'
  103. .format(e.__traceback__.tb_lineno, repr(e)))
  104. return None
  105. def disabled_number(self, access_number, orderTypeId):
  106. """
  107. 停机保号/复机/测试期去激活
  108. :param access_number: 11位接入号码
  109. :param orderTypeId: 19表示停机保号,20表示停机保号后复机,21表示测试期去激活,22表示测试期去激活后回到测试激活。
  110. :return: 流量总使用量查询(时间段)
  111. :raises ValueError: 如果响应为空或HTTP请求失败。
  112. """
  113. try:
  114. if not access_number:
  115. raise ValueError("*****TelecomObject.disabled_number error****access_number不能为空")
  116. method = 'disabledNumber'
  117. arr = [method, self.user_id, access_number, self.password, orderTypeId, '']
  118. re_params = self.get_params_dict_by_access_number(method, access_number, arr)
  119. re_params['orderTypeId'] = orderTypeId
  120. re_params['acctCd'] = ''
  121. response = self.session.get(self.url, params=re_params)
  122. if response.status_code != 200:
  123. LOGGER.info(f"*****TelecomObject.disabled_number error HTTP请求失败,状态码: {response.status_code}")
  124. return None
  125. msg = response.text
  126. if not msg:
  127. return None
  128. # 检查响应类型
  129. content_type = response.headers.get('Content-Type', '')
  130. if 'application/xml' in content_type or 'text/xml' in content_type:
  131. result = xmltodict.parse(msg)
  132. elif 'application/json' in content_type or 'text/json' in content_type:
  133. result = json.loads(msg)
  134. LOGGER.info(f"***TelecomObject.disabled_number停机/复机异常{access_number},error{result}")
  135. return None
  136. else:
  137. return None
  138. return result
  139. except Exception as e:
  140. LOGGER.info('***TelecomObject.disabled_number:errLine:{}, errMsg:{}'
  141. .format(e.__traceback__.tb_lineno, repr(e)))
  142. return None
  143. def single_cut_net(self, access_number, action):
  144. """
  145. 单独添加/恢复断网接口
  146. :param access_number: 11位接入号码
  147. :param action: ADD:单独添加断网;DEL:单独恢复断网
  148. :return: 单独添加/恢复断网结果
  149. :raises ValueError: 如果响应为空或HTTP请求失败。
  150. """
  151. try:
  152. if not access_number:
  153. raise ValueError("*****TelecomObject.single_cut_net***error:access_number不能为空")
  154. method = 'singleCutNet'
  155. arr = [method, self.user_id, access_number, self.password, action]
  156. re_params = self.get_params_dict_by_access_number(method, access_number, arr)
  157. re_params['action'] = action
  158. response = self.session.get(self.url, params=re_params)
  159. if response.status_code != 200:
  160. LOGGER.info(f"*****TelecomObject.query_card_main_status error HTTP请求失败,状态码: {response.status_code}")
  161. return None
  162. msg = response.text
  163. if not msg:
  164. return None
  165. # 检查响应类型
  166. content_type = response.headers.get('Content-Type', '')
  167. if 'application/xml' in content_type or 'text/xml' in content_type:
  168. result = xmltodict.parse(msg)
  169. elif 'application/json' in content_type or 'text/json' in content_type:
  170. result = json.loads(msg)
  171. LOGGER.info(f"***TelecomObject.query_card_main_status停机/复机异常{access_number},error{result}")
  172. return None
  173. else:
  174. return None
  175. return result
  176. except Exception as e:
  177. LOGGER.info('***TelecomObject.single_cut_net:errLine:{}, errMsg:{}'
  178. .format(e.__traceback__.tb_lineno, repr(e)))
  179. return None
  180. def get_telephone(self, iccid):
  181. """
  182. 接入号码查询接口
  183. :param iccid: 卡的ICCID号。
  184. :return: 接入号码查询结果
  185. :raises ValueError: 如果响应为空或HTTP请求失败。
  186. """
  187. try:
  188. if not iccid:
  189. raise ValueError("*****TelecomObject.get_telephone error****iccid不能为空")
  190. method = 'getTelephone'
  191. arr = [method, self.user_id, iccid, self.password]
  192. re_params = self.get_params_dict_by_iccid(method, iccid, arr)
  193. response = self.session.get(self.url, params=re_params)
  194. if response.status_code != 200:
  195. LOGGER.info(f"*****TelecomObject.get_telephone error HTTP请求失败,状态码: {response.status_code}")
  196. return None
  197. msg = response.text
  198. if not msg:
  199. return None
  200. # 检查响应类型
  201. return json.loads(msg)
  202. except Exception as e:
  203. LOGGER.info('***TelecomObject.get_telephone:errLine:{}, errMsg:{}'
  204. .format(e.__traceback__.tb_lineno, repr(e)))
  205. return None
  206. def query_traffic(self, iccid, need_dtl='0'):
  207. """
  208. 表示流量总使用量查询(当月)
  209. :param iccid: 卡的ICCID号。
  210. :param need_dtl: 0
  211. :return: 表示流量总使用量查询(当月)。
  212. :raises ValueError: 如果响应为空或HTTP请求失败。
  213. """
  214. try:
  215. if not iccid:
  216. raise ValueError("*****TelecomObject.query_traffic error****ICCID不能为空")
  217. method = 'queryTraffic'
  218. arr = [method, self.user_id, iccid, self.password]
  219. re_params = self.get_params_dict_by_iccid(method, iccid, arr)
  220. re_params['needDtl'] = need_dtl
  221. response = self.session.get(self.url, params=re_params)
  222. if response.status_code != 200:
  223. LOGGER.info(
  224. f"*****TelecomObject.query_traffic error HTTP请求失败,状态码: {response.status_code}")
  225. return None
  226. msg = response.text
  227. if not msg:
  228. return None
  229. # 检查响应类型
  230. content_type = response.headers.get('Content-Type', '')
  231. if 'application/xml' in content_type or 'text/xml' in content_type:
  232. result = xmltodict.parse(msg)
  233. elif 'application/json' in content_type or 'text/json' in content_type:
  234. result = json.loads(msg)
  235. LOGGER.info(f"***TelecomObject.query_traffic查询流量异常{iccid},error{result}")
  236. return None
  237. else:
  238. return None
  239. return result
  240. except Exception as e:
  241. LOGGER.info(
  242. '***TelecomObject.query_traffic:errLine:{}, errMsg:{}'.format(e.__traceback__.tb_lineno, repr(e)))
  243. return None
  244. def query_package_batch_flow(self, iccid, month_date):
  245. """
  246. 套餐使用量批量查询接口
  247. :param iccid: 卡的ICCID号。
  248. :param month_date: 例如20160501,表示查询2016年5月份的套餐;如果不填,则为查询实时套餐
  249. :return: 套餐使用量查询结果
  250. :raises ValueError: 如果响应为空或HTTP请求失败。
  251. """
  252. try:
  253. if not iccid:
  254. raise ValueError("*****TelecomObject.query_package_batch_flow error****ICCID不能为空")
  255. method = 'queryPakagePlus'
  256. arr = [method, self.user_id, iccid, self.password]
  257. re_params = self.get_params_dict_by_access_number(method, iccid, arr)
  258. response = self.session.get(self.url, params=re_params)
  259. if response.status_code != 200:
  260. LOGGER.info(f"*****TelecomObject.query_package_batch_flow error HTTP请求失败,状态码: {response.status_code}")
  261. return None
  262. msg = response.text
  263. if not msg:
  264. return None
  265. # 检查响应类型
  266. content_type = response.headers.get('Content-Type', '')
  267. if 'application/xml' in content_type or 'text/xml' in content_type:
  268. result = xmltodict.parse(msg)
  269. elif 'application/json' in content_type or 'text/json' in content_type:
  270. result = json.loads(msg)
  271. LOGGER.info(f"***TelecomObject.query_package_batch_flow查询流量异常{iccid},error{result}")
  272. return None
  273. else:
  274. LOGGER.info("***TelecomObject.query_package_batch_flow无法识别的响应类型: {}".format(content_type))
  275. return None
  276. return result
  277. except Exception as e:
  278. LOGGER.info(
  279. '***TelecomObject.query_package_batch_flow:errLine:{}, errMsg:{}'.format(e.__traceback__.tb_lineno,
  280. repr(e)))
  281. return None
  282. def query_traffic_by_date(self, iccid):
  283. """
  284. 流量总使用量查询(时间段) 会被限流 成功则返回XML
  285. :param iccid: 卡的ICCID号。
  286. :return: 流量总使用量查询(时间段)
  287. :raises ValueError: 如果响应为空或HTTP请求失败。
  288. """
  289. try:
  290. if not iccid:
  291. raise ValueError("*****TelecomObject.query_traffic_by_date error****ICCID不能为空")
  292. method = 'queryTrafficByDate'
  293. arr = [method, self.user_id, iccid, self.password]
  294. re_params = self.get_params_dict_by_iccid(method, iccid, arr)
  295. re_params['startDate'] = '20240101'
  296. re_params['endDate'] = '20240115'
  297. re_params['needDtl'] = '0'
  298. response = self.session.get(self.url, params=re_params)
  299. if response.status_code != 200:
  300. LOGGER.info(f"*****TelecomObject.query_traffic_by_date error HTTP请求失败,状态码: {response.status_code}")
  301. return None
  302. msg = response.text
  303. if not msg:
  304. return None
  305. # 检查响应类型
  306. content_type = response.headers.get('Content-Type', '')
  307. if 'application/xml' in content_type or 'text/xml' in content_type:
  308. result = xmltodict.parse(msg)
  309. elif 'application/json' in content_type or 'text/json' in content_type:
  310. result = json.loads(msg)
  311. LOGGER.info(f"***TelecomObject.query_traffic_by_date 查询流量异常{iccid},error{result}")
  312. return None
  313. else:
  314. LOGGER.info("***TelecomObject.query_traffic_by_date 无法识别的响应类型: {}".format(content_type))
  315. return None
  316. return result
  317. except Exception as e:
  318. LOGGER.info('***TelecomObject.query_traffic_by_date:errLine:{}, errMsg:{}'
  319. .format(e.__traceback__.tb_lineno, repr(e)))
  320. return None
  321. def query_product_information(self, access_number):
  322. """
  323. 产品资料查询接口
  324. :param access_number: 接入号码access_number。
  325. :return: SIM卡的产品资料,包含基础信息、套餐、状态及 断网类型等
  326. :raises ValueError: 如果响应为空或HTTP请求失败。
  327. """
  328. try:
  329. if not access_number:
  330. raise ValueError("*****TelecomObject.query_product_information error****access_number不能为空")
  331. method = 'prodInstQuery'
  332. arr = [method, self.user_id, access_number, self.password]
  333. re_params = self.get_params_dict_by_access_number(method, access_number, arr)
  334. response = self.session.get(self.url, params=re_params)
  335. if response.status_code != 200:
  336. LOGGER.info(f"*****TelecomObject.query_product_information error HTTP请求失败,状态码: {response.status_code}")
  337. return None
  338. msg = response.text
  339. if not msg:
  340. return None
  341. content_type = response.headers.get('Content-Type', '')
  342. if 'application/xml' in content_type or 'text/xml' in content_type:
  343. result = xmltodict.parse(msg)
  344. elif 'application/json' in content_type or 'text/json' in content_type:
  345. result = json.loads(msg)
  346. LOGGER.info(f"***TelecomObject.query_product_information 查询产品资料异常:{access_number},error{result}")
  347. return None
  348. else:
  349. LOGGER.info("***TelecomObject.query_product_information 无法识别的响应类型: {}".format(content_type))
  350. return None
  351. return result
  352. except Exception as e:
  353. LOGGER.info('***TelecomObject.query_product_information:errLine:{}, errMsg:{}'
  354. .format(e.__traceback__.tb_lineno, repr(e)))
  355. return None