public.py 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309
  1. """公共接口(Web 登录、刷新 Token、登出;用户模型对齐 docs/sql/shanxia2.0.sql 基线)"""
  2. from typing import Optional
  3. from fastapi import APIRouter, Depends, HTTPException, Request
  4. from sqlalchemy.exc import OperationalError
  5. from sqlalchemy.orm import Session
  6. from app.core.database import get_db
  7. from app.core.security import verify_password
  8. from app.core.auth import (
  9. create_access_token,
  10. create_refresh_token,
  11. decode_token,
  12. get_current_user_by_token,
  13. extend_session,
  14. is_refresh_token_valid,
  15. is_session_valid,
  16. revoke_refresh_token,
  17. revoke_session,
  18. store_refresh_token,
  19. store_session,
  20. )
  21. from app.core.response import success_response, error_response
  22. from app.core.config import settings
  23. from app.models.models import SysUser
  24. from app.crud.user import user_crud
  25. from app.core.utils import generate_uuid
  26. from app.core import login_crypto
  27. from app.services.web_auth_roles import iter_user_menu_perm_codes, resolve_web_role_for_user
  28. from app.crud.crm.quote import view_by_share_code
  29. router = APIRouter(prefix="", tags=["公共接口"])
  30. def _avatar_url_field(user: SysUser) -> Optional[str]:
  31. raw = getattr(user, "avatar", None)
  32. if not raw:
  33. return None
  34. s = str(raw).strip()
  35. return s if s else None
  36. def _build_user_info_payload(user: SysUser, web_role: str) -> dict:
  37. """与 web-admin `userInfo` 字段约定一致。"""
  38. phone = (getattr(user, "phone_no", None) or "").strip() or None
  39. return {
  40. "id": user.id,
  41. "username": user.user_no,
  42. "realName": user.nick_name,
  43. "phone": phone,
  44. "email": (getattr(user, "email", None) or "").strip() or None,
  45. "role": web_role,
  46. "regionId": user.dept_id,
  47. "regionName": None,
  48. "avatarUrl": _avatar_url_field(user),
  49. }
  50. def _jwt_user_payload(user: SysUser, web_role: str) -> dict:
  51. tenant_no = (getattr(user, "tenant_no", None) or "").strip() or settings.DEFAULT_TENANT_NO
  52. return {
  53. "sub": user.id,
  54. "username": user.user_no,
  55. "role": web_role,
  56. "region_id": user.dept_id,
  57. "real_name": user.nick_name,
  58. "tenant_no": tenant_no,
  59. }
  60. @router.get("/web/auth/login-rsa-public-key", response_model=dict)
  61. def web_login_rsa_public_key():
  62. """Web 端登录用 RSA 公钥(PKCS#1 v1.5,与 JSEncrypt 一致)"""
  63. login_crypto.ensure_initialized()
  64. return success_response({"publicKeyPem": login_crypto.get_public_pem()})
  65. @router.post("/web/auth/login", response_model=dict)
  66. def web_login(
  67. request: Request,
  68. body: dict,
  69. db: Session = Depends(get_db),
  70. ):
  71. """Web 端登录:账号为 sys_user.user_no,密码为 sys_user.password(bcrypt)。"""
  72. login_crypto.ensure_initialized()
  73. user_no, password, cred_err = login_crypto.extract_login_credentials(body)
  74. if cred_err:
  75. return error_response(400, cred_err)
  76. user = user_crud.get_by_user_no_for_web_login(db, user_no)
  77. if not user:
  78. return error_response(400, "用户名或密码错误")
  79. pwd_hash = getattr(user, "password", None) or ""
  80. if not verify_password(password, pwd_hash):
  81. return error_response(400, "用户名或密码错误")
  82. if user.status != "1":
  83. return error_response(403, "账号已被停用,请联系管理员")
  84. web_role = resolve_web_role_for_user(db, user.id, user.tenant_no)
  85. session_id = generate_uuid()
  86. access_jti = generate_uuid()
  87. refresh_jti = generate_uuid()
  88. access_token = create_access_token(
  89. data=_jwt_user_payload(user, web_role),
  90. session_id=session_id,
  91. token_jti=access_jti,
  92. )
  93. refresh_token = create_refresh_token(
  94. data={
  95. "sub": user.id,
  96. "username": user.user_no,
  97. "role": web_role,
  98. },
  99. session_id=session_id,
  100. refresh_jti=refresh_jti,
  101. )
  102. store_session(session_id=session_id, user_id=user.id)
  103. store_refresh_token(refresh_jti=refresh_jti, user_id=user.id)
  104. return success_response(
  105. {
  106. "token": access_token,
  107. "refreshToken": refresh_token,
  108. "expiresIn": settings.ACCESS_TOKEN_EXPIRE_MINUTES * 60,
  109. "userInfo": _build_user_info_payload(user, web_role),
  110. }
  111. )
  112. @router.post("/web/auth/refresh-token", response_model=dict)
  113. def refresh_token(body: dict, db: Session = Depends(get_db)):
  114. """刷新 Token"""
  115. refresh_token_val = body.get("refreshToken")
  116. if not refresh_token_val:
  117. return error_response(400, "refreshToken不能为空")
  118. try:
  119. payload = decode_token(refresh_token_val)
  120. if payload.get("type") != "refresh":
  121. return error_response(401, "无效的refreshToken")
  122. session_id = payload.get("sid")
  123. refresh_jti = payload.get("jti")
  124. if not is_session_valid(session_id=session_id):
  125. return error_response(401, "refreshToken已失效,请重新登录")
  126. if not is_refresh_token_valid(refresh_jti=refresh_jti):
  127. return error_response(401, "无效的refreshToken")
  128. user_id = payload.get("sub")
  129. user = user_crud.get(db, user_id)
  130. if not user or user.del_flag != 0 or user.status != "1":
  131. return error_response(401, "用户不存在或已禁用")
  132. web_role = resolve_web_role_for_user(db, user.id, user.tenant_no)
  133. revoke_refresh_token(refresh_jti=refresh_jti)
  134. extend_session(session_id=session_id)
  135. new_access_jti = generate_uuid()
  136. new_refresh_jti = generate_uuid()
  137. new_access_token = create_access_token(
  138. data=_jwt_user_payload(user, web_role),
  139. session_id=session_id,
  140. token_jti=new_access_jti,
  141. )
  142. new_refresh_token = create_refresh_token(
  143. data={
  144. "sub": user.id,
  145. "username": user.user_no,
  146. "role": web_role,
  147. },
  148. session_id=session_id,
  149. refresh_jti=new_refresh_jti,
  150. )
  151. store_refresh_token(refresh_jti=new_refresh_jti, user_id=user.id)
  152. return success_response(
  153. {
  154. "token": new_access_token,
  155. "refreshToken": new_refresh_token,
  156. "expiresIn": settings.ACCESS_TOKEN_EXPIRE_MINUTES * 60,
  157. }
  158. )
  159. except HTTPException:
  160. return error_response(401, "refreshToken已过期")
  161. @router.post("/web/auth/logout", response_model=dict)
  162. def logout(request: Request):
  163. """登出:吊销 Redis 会话(若已配置 REDIS_HOST)。"""
  164. authorization = request.headers.get("Authorization", "")
  165. if not authorization.startswith("Bearer "):
  166. return error_response(401, "未授权")
  167. token = authorization.replace("Bearer ", "")
  168. try:
  169. payload = decode_token(token)
  170. session_id = payload.get("sid")
  171. if session_id:
  172. revoke_session(session_id=session_id)
  173. except HTTPException:
  174. return error_response(401, "Token无效或已过期")
  175. return success_response({"message": "登出成功"})
  176. @router.get("/web/auth/current-user", response_model=dict)
  177. def get_current_user_profile(request: Request, db: Session = Depends(get_db)):
  178. """获取当前用户信息(与 sys_user 字段对应)。"""
  179. authorization = request.headers.get("Authorization", "")
  180. if not authorization.startswith("Bearer "):
  181. return error_response(401, "未授权")
  182. token = authorization.replace("Bearer ", "")
  183. try:
  184. current_user = get_current_user_by_token(token=token, db=db)
  185. au = current_user.get("avatar_url")
  186. avatar_url = str(au).strip() if au else None
  187. return success_response(
  188. {
  189. "id": current_user.get("user_id"),
  190. "username": current_user.get("username"),
  191. "realName": current_user.get("real_name"),
  192. "phone": current_user.get("phone"),
  193. "email": current_user.get("email"),
  194. "role": current_user.get("role"),
  195. "isSuperAdmin": current_user.get("role") == "super_admin",
  196. "regionId": current_user.get("region_id"),
  197. "regionName": None,
  198. "regionIds": [],
  199. "isActive": current_user.get("is_active"),
  200. "avatarUrl": avatar_url if avatar_url else None,
  201. }
  202. )
  203. except HTTPException:
  204. return error_response(401, "Token无效或已过期")
  205. @router.get("/web/auth/menu-codes", response_model=dict)
  206. def get_web_auth_menu_codes(request: Request, db: Session = Depends(get_db)):
  207. """获取当前用户菜单权限标识(sys_menu.perms,经角色继承)。"""
  208. authorization = request.headers.get("Authorization", "")
  209. if not authorization.startswith("Bearer "):
  210. return error_response(401, "未授权")
  211. token = authorization.replace("Bearer ", "")
  212. try:
  213. current_user = get_current_user_by_token(token=token, db=db)
  214. role = current_user.get("role")
  215. if role == "super_admin":
  216. return success_response(
  217. {
  218. "isSuperAdmin": True,
  219. "all": True,
  220. "menuCodes": [],
  221. }
  222. )
  223. try:
  224. codes = iter_user_menu_perm_codes(db, current_user.get("user_id") or "")
  225. menu_codes = sorted(codes)
  226. except OperationalError:
  227. menu_codes = []
  228. return success_response(
  229. {
  230. "isSuperAdmin": False,
  231. "all": False,
  232. "menuCodes": menu_codes,
  233. }
  234. )
  235. except HTTPException:
  236. return error_response(401, "Token无效或已过期")
  237. @router.get("/public/crm/quote/share/{share_code}")
  238. def public_quote_share(
  239. share_code: str,
  240. request: Request,
  241. password: str = "",
  242. db: Session = Depends(get_db),
  243. ):
  244. """公开分享查看报价单 — Java: GET /share/{shareCode}(无 JWT)"""
  245. try:
  246. ip_address = request.client.host if request.client else ""
  247. user_agent = request.headers.get("user-agent", "")
  248. detail = view_by_share_code(
  249. db,
  250. share_code,
  251. password=password or "",
  252. ip_address=ip_address,
  253. user_agent=user_agent,
  254. )
  255. return success_response(detail)
  256. except ValueError as e:
  257. return error_response(400, str(e))
  258. except Exception as e:
  259. return error_response(500, str(e))