customer.py 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868
  1. """CRM 客户 CRUD(客户主表 + 转移/成交/公海池操作)"""
  2. from __future__ import annotations
  3. import math
  4. from datetime import datetime, timedelta, date
  5. from typing import Any, Dict, List, Optional, Tuple
  6. from sqlalchemy import and_, func, or_
  7. from sqlalchemy.orm import Session
  8. from app.core.delete_guard import assert_row_deletable_by_creator
  9. from app.core.utils import generate_uuid
  10. from app.models.crm_models import CrmCustomer
  11. from app.models.models import SysUser
  12. from app.crud.crm.data_scope_helpers import (
  13. apply_crm_create_by_scope,
  14. apply_crm_owner_scope,
  15. ensure_crm_owner_row_in_scope,
  16. )
  17. from app.utils.pinyin_abbr import resolve_name_pinyin_abbr
  18. def _ensure_customer_in_scope(db: Session, customer: CrmCustomer, user_info, tenant_no: str) -> None:
  19. ensure_crm_owner_row_in_scope(db, customer, user_info, tenant_no, message="无权访问该客户")
  20. def total_pages(total: int, page_size: int) -> int:
  21. if page_size <= 0:
  22. return 0
  23. return math.ceil(total / page_size)
  24. _FMT = "%Y-%m-%d %H:%M:%S"
  25. _DATE_FMT = "%Y-%m-%d"
  26. def _parse_optional_date(value: Any) -> Optional[date]:
  27. if value is None:
  28. return None
  29. if isinstance(value, date) and not isinstance(value, datetime):
  30. return value
  31. if isinstance(value, datetime):
  32. return value.date()
  33. text = str(value).strip()
  34. if not text:
  35. return None
  36. for fmt in (_DATE_FMT, _FMT):
  37. try:
  38. return datetime.strptime(text, fmt).date()
  39. except ValueError:
  40. continue
  41. raise ValueError(f"日期格式无效: {text}")
  42. def _parse_optional_datetime(value: Any) -> Optional[datetime]:
  43. if value is None:
  44. return None
  45. if isinstance(value, datetime):
  46. return value
  47. text = str(value).strip()
  48. if not text:
  49. return None
  50. for fmt in (_FMT, _DATE_FMT):
  51. try:
  52. return datetime.strptime(text, fmt)
  53. except ValueError:
  54. continue
  55. raise ValueError(f"日期时间格式无效: {text}")
  56. def _resolve_user_display_name(db: Session, user_id: Optional[str]) -> str:
  57. uid = (user_id or "").strip()
  58. if not uid:
  59. return ""
  60. u = db.query(SysUser).filter(SysUser.id == uid, SysUser.del_flag == 0).first()
  61. if not u:
  62. return ""
  63. return (u.nick_name or u.user_no or "").strip()
  64. def _enrich_user_names(db: Session, rows: List[Dict[str, Any]]) -> None:
  65. field_pairs = (
  66. ("ownerUserId", "ownerUserName"),
  67. ("createBy", "createByName"),
  68. ("updateBy", "updateByName"),
  69. )
  70. need_ids: set[str] = set()
  71. for d in rows:
  72. for id_field, name_field in field_pairs:
  73. uid = str(d.get(id_field) or "").strip()
  74. if uid and not (d.get(name_field) or "").strip():
  75. need_ids.add(uid)
  76. if not need_ids:
  77. return
  78. users = (
  79. db.query(SysUser.id, SysUser.nick_name, SysUser.user_no)
  80. .filter(SysUser.id.in_(need_ids), SysUser.del_flag == 0)
  81. .all()
  82. )
  83. name_map = {u.id: (u.nick_name or u.user_no or "").strip() for u in users}
  84. for d in rows:
  85. for id_field, name_field in field_pairs:
  86. uid = str(d.get(id_field) or "").strip()
  87. if uid and not (d.get(name_field) or "").strip():
  88. d[name_field] = name_map.get(uid, "")
  89. def _row_to_dict(row: CrmCustomer) -> Dict[str, Any]:
  90. return {
  91. "id": row.id,
  92. "customerNo": row.customer_no or "",
  93. "customerName": row.customer_name or "",
  94. "namePinyinAbbr": getattr(row, "name_pinyin_abbr", None) or "",
  95. "shortName": row.short_name or "",
  96. "customerType": row.customer_type or "",
  97. "mobile": row.mobile or "",
  98. "telephone": row.telephone or "",
  99. "email": row.email or "",
  100. "website": row.website or "",
  101. "level": row.level or "",
  102. "source": row.source or "",
  103. "industry": row.industry or "",
  104. "parkArea": row.park_area or "",
  105. "paymentTerms": row.payment_terms or "",
  106. "scale": row.scale or "",
  107. "province": row.province or "",
  108. "city": row.city or "",
  109. "district": row.district or "",
  110. "address": row.address or "",
  111. "status": row.status or "",
  112. "dealStatus": row.deal_status or "",
  113. "ownerUserId": row.owner_user_id or "",
  114. "ownerUserName": row.owner_user_name or "",
  115. "lastTime": row.last_time.strftime(_FMT) if row.last_time else "",
  116. "nextTime": row.next_time.strftime(_FMT) if row.next_time else "",
  117. "followCount": row.follow_count if row.follow_count is not None else 0,
  118. "dealTime": row.deal_time.strftime(_FMT) if row.deal_time else "",
  119. "dealAmount": float(row.deal_amount) if row.deal_amount else 0.0,
  120. "contactCount": row.contact_count if row.contact_count is not None else 0,
  121. "opportunityCount": row.opportunity_count if row.opportunity_count is not None else 0,
  122. "contractCount": row.contract_count if row.contract_count is not None else 0,
  123. "intoPoolTime": row.into_pool_time.strftime(_FMT) if row.into_pool_time else "",
  124. "intoPoolBy": row.into_pool_by or "",
  125. "intoPoolReason": row.into_pool_reason or "",
  126. "claimTime": row.claim_time.strftime(_FMT) if row.claim_time else "",
  127. "assignTime": row.assign_time.strftime(_FMT) if row.assign_time else "",
  128. "assignBy": row.assign_by or "",
  129. "protectTime": row.protect_time.strftime(_FMT) if row.protect_time else "",
  130. "businessLicenseImg": row.business_license_img or "",
  131. "businessLicenseImages": row.business_license_img or "",
  132. "businessPermitImages": row.business_permit_images or "",
  133. "otherCertImages": row.other_cert_images or "",
  134. "clueId": row.clue_id or "",
  135. "orderNum": row.order_num if row.order_num is not None else 0,
  136. "remark": row.remark or "",
  137. "createBy": row.create_by or "",
  138. "createTime": row.create_time.strftime(_FMT) if row.create_time else "",
  139. "updateBy": row.update_by or "",
  140. "updateTime": row.update_time.strftime(_FMT) if row.update_time else "",
  141. }
  142. def list_customer_options(
  143. db: Session,
  144. tenant_no: str,
  145. *,
  146. keyword: str = None,
  147. customer_name: str = None,
  148. limit: int = 50,
  149. ) -> List[Dict[str, Any]]:
  150. """客户下拉选项:租户内只读搜索,不做 owner 数据权限(供地磅/合同等主数据选用)。"""
  151. q = db.query(CrmCustomer).filter(
  152. CrmCustomer.tenant_no == tenant_no,
  153. CrmCustomer.del_flag == 0,
  154. )
  155. kw = (keyword or "").strip()
  156. if kw:
  157. like = f"%{kw}%"
  158. q = q.filter(
  159. or_(
  160. CrmCustomer.customer_name.like(like),
  161. CrmCustomer.customer_no.like(like),
  162. CrmCustomer.short_name.like(like),
  163. func.lower(func.coalesce(CrmCustomer.name_pinyin_abbr, "")).like(
  164. f"%{kw.lower()}%"
  165. ),
  166. )
  167. )
  168. name = (customer_name or "").strip()
  169. if name:
  170. q = q.filter(
  171. or_(
  172. CrmCustomer.customer_name.like(f"%{name}%"),
  173. func.lower(func.coalesce(CrmCustomer.name_pinyin_abbr, "")).like(
  174. f"%{name.lower()}%"
  175. ),
  176. )
  177. )
  178. limit = min(max(1, int(limit or 50)), 200)
  179. rows = q.order_by(CrmCustomer.create_time.desc()).limit(limit).all()
  180. return [
  181. {
  182. "id": r.id,
  183. "customerName": r.customer_name,
  184. "customerNo": r.customer_no,
  185. "label": r.customer_name,
  186. "value": r.id,
  187. }
  188. for r in rows
  189. ]
  190. def list_customers(
  191. db: Session,
  192. tenant_no: str,
  193. user_id: str = None,
  194. *,
  195. page: int = 1,
  196. page_size: int = 10,
  197. keyword: str = None,
  198. view_mode: str = None,
  199. customer_name: str = None,
  200. customer_no: str = None,
  201. status: str = None,
  202. deal_status: str = None,
  203. level: str = None,
  204. source: str = None,
  205. customer_type: str = None,
  206. industry: str = None,
  207. park_area: str = None,
  208. owner_user_id: str = None,
  209. create_time_start: str = None,
  210. create_time_end: str = None,
  211. user_info=None,
  212. skip_data_scope: bool = False,
  213. ) -> Tuple[List[Dict[str, Any]], int]:
  214. q = db.query(CrmCustomer).filter(
  215. CrmCustomer.tenant_no == tenant_no,
  216. CrmCustomer.del_flag == 0,
  217. )
  218. kw = (keyword or "").strip()
  219. if kw:
  220. like = f"%{kw}%"
  221. q = q.filter(
  222. or_(
  223. CrmCustomer.customer_name.like(like),
  224. CrmCustomer.customer_no.like(like),
  225. CrmCustomer.mobile.like(like),
  226. CrmCustomer.short_name.like(like),
  227. func.lower(func.coalesce(CrmCustomer.name_pinyin_abbr, "")).like(
  228. f"%{kw.lower()}%"
  229. ),
  230. )
  231. )
  232. if view_mode == "mine" and user_id:
  233. q = q.filter(CrmCustomer.owner_user_id == user_id)
  234. q = q.filter(CrmCustomer.status == "normal")
  235. elif view_mode == "toFollow":
  236. q = q.filter(CrmCustomer.status == "normal")
  237. q = q.filter(CrmCustomer.next_time.isnot(None))
  238. q = q.filter(CrmCustomer.next_time <= datetime.now())
  239. elif view_mode == "key":
  240. q = q.filter(CrmCustomer.level == "key")
  241. elif view_mode == "pool":
  242. q = q.filter(CrmCustomer.status == "pool")
  243. elif view_mode == "dealed":
  244. q = q.filter(CrmCustomer.deal_status == "dealed")
  245. elif view_mode == "weekNew":
  246. week_ago = datetime.now() - timedelta(days=7)
  247. q = q.filter(CrmCustomer.create_time >= week_ago)
  248. elif view_mode == "longTimeNoFollow":
  249. days_30_ago = datetime.now() - timedelta(days=30)
  250. q = q.filter(
  251. or_(
  252. CrmCustomer.last_time.is_(None),
  253. CrmCustomer.last_time <= days_30_ago,
  254. )
  255. )
  256. if customer_name:
  257. cn = customer_name.strip()
  258. if cn:
  259. q = q.filter(
  260. or_(
  261. CrmCustomer.customer_name.like(f"%{cn}%"),
  262. func.lower(func.coalesce(CrmCustomer.name_pinyin_abbr, "")).like(
  263. f"%{cn.lower()}%"
  264. ),
  265. )
  266. )
  267. if customer_no:
  268. q = q.filter(CrmCustomer.customer_no.like(f"%{customer_no}%"))
  269. if status:
  270. q = q.filter(CrmCustomer.status == status)
  271. if deal_status:
  272. q = q.filter(CrmCustomer.deal_status == deal_status)
  273. if level:
  274. q = q.filter(CrmCustomer.level == level)
  275. if source:
  276. q = q.filter(CrmCustomer.source == source)
  277. if customer_type:
  278. q = q.filter(CrmCustomer.customer_type == customer_type)
  279. if industry:
  280. q = q.filter(CrmCustomer.industry == industry)
  281. if park_area:
  282. q = q.filter(CrmCustomer.park_area == park_area)
  283. if owner_user_id:
  284. q = q.filter(CrmCustomer.owner_user_id == owner_user_id)
  285. if create_time_start:
  286. q = q.filter(CrmCustomer.create_time >= create_time_start)
  287. if create_time_end:
  288. q = q.filter(CrmCustomer.create_time <= create_time_end)
  289. pool_scope_exempt = skip_data_scope or view_mode == "pool" or status == "pool"
  290. if user_info and not pool_scope_exempt:
  291. q = apply_crm_owner_scope(q, CrmCustomer, user_info, db, tenant_no)
  292. total = q.order_by(None).with_entities(func.count(CrmCustomer.id)).scalar() or 0
  293. page = max(1, page)
  294. page_size = min(max(1, page_size), 100)
  295. order_by = CrmCustomer.create_time.desc()
  296. if view_mode == "toFollow":
  297. order_by = CrmCustomer.next_time.asc()
  298. rows = (
  299. q.order_by(order_by)
  300. .offset((page - 1) * page_size)
  301. .limit(page_size)
  302. .all()
  303. )
  304. result = [_row_to_dict(r) for r in rows]
  305. _enrich_user_names(db, result)
  306. return result, int(total)
  307. def list_pool_customers(
  308. db: Session,
  309. tenant_no: str,
  310. *,
  311. page: int = 1,
  312. page_size: int = 10,
  313. keyword: str = None,
  314. level: str = None,
  315. industry: str = None,
  316. park_area: str = None,
  317. user_info=None,
  318. ) -> Tuple[List[Dict[str, Any]], int]:
  319. return list_customers(
  320. db,
  321. tenant_no,
  322. page=page,
  323. page_size=page_size,
  324. keyword=keyword,
  325. status="pool",
  326. level=level,
  327. industry=industry,
  328. park_area=park_area,
  329. user_info=user_info,
  330. skip_data_scope=True,
  331. )
  332. def get_customer(db: Session, customer_id: str) -> Optional[CrmCustomer]:
  333. return (
  334. db.query(CrmCustomer)
  335. .filter(
  336. CrmCustomer.id == customer_id,
  337. CrmCustomer.del_flag == 0,
  338. )
  339. .first()
  340. )
  341. def get_customer_by_no(db: Session, customer_no: str, tenant_no: str) -> Optional[CrmCustomer]:
  342. return (
  343. db.query(CrmCustomer)
  344. .filter(
  345. CrmCustomer.customer_no == customer_no,
  346. CrmCustomer.tenant_no == tenant_no,
  347. CrmCustomer.del_flag == 0,
  348. )
  349. .first()
  350. )
  351. def generate_customer_no(db: Session, tenant_no: str) -> str:
  352. today_str = datetime.now().strftime("%Y%m%d")
  353. prefix = f"C{today_str}"
  354. max_no = (
  355. db.query(CrmCustomer.customer_no)
  356. .filter(
  357. CrmCustomer.customer_no.like(f"{prefix}%"),
  358. CrmCustomer.tenant_no == tenant_no,
  359. )
  360. .order_by(CrmCustomer.customer_no.desc())
  361. .first()
  362. )
  363. if max_no and max_no[0]:
  364. seq_str = max_no[0][len(prefix):]
  365. try:
  366. seq = int(seq_str) + 1
  367. except ValueError:
  368. seq = 1
  369. else:
  370. seq = 1
  371. return f"{prefix}{seq:04d}"
  372. def customer_name_exists(
  373. db: Session, tenant_no: str, name: str, exclude_id: str = None
  374. ) -> bool:
  375. q = db.query(CrmCustomer).filter(
  376. CrmCustomer.customer_name == name,
  377. CrmCustomer.tenant_no == tenant_no,
  378. CrmCustomer.del_flag == 0,
  379. )
  380. if exclude_id:
  381. q = q.filter(CrmCustomer.id != exclude_id)
  382. return q.first() is not None
  383. def check_duplicate_customer(
  384. db: Session,
  385. tenant_no: str,
  386. mobile: str = None,
  387. customer_name: str = None,
  388. exclude_id: str = None,
  389. ) -> list:
  390. conditions = [CrmCustomer.tenant_no == tenant_no, CrmCustomer.del_flag == 0]
  391. if exclude_id:
  392. conditions.append(CrmCustomer.id != exclude_id)
  393. or_clauses = []
  394. if mobile:
  395. or_clauses.append(CrmCustomer.mobile == mobile)
  396. if customer_name:
  397. or_clauses.append(CrmCustomer.customer_name == customer_name)
  398. if not or_clauses:
  399. return []
  400. rows = db.query(CrmCustomer).filter(*conditions).filter(or_(*or_clauses)).all()
  401. return [_row_to_dict(r) for r in rows]
  402. def create_customer(
  403. db: Session,
  404. *,
  405. tenant_no: str,
  406. user_id: str = None,
  407. user_name: str = None,
  408. dept_id: str = "",
  409. **kwargs,
  410. ) -> CrmCustomer:
  411. customer_no = kwargs.get("customer_no")
  412. if not customer_no:
  413. customer_no = generate_customer_no(db, tenant_no)
  414. owner_id = (kwargs.pop("owner_user_id", None) or user_id or "").strip() or None
  415. owner_name = _resolve_user_display_name(db, owner_id) or (user_name or "")
  416. # 拼音首字母:新增始终按提交值解析(空则由客户名称生成);兼容 snake / camel 键
  417. submitted = kwargs.get("name_pinyin_abbr")
  418. if submitted is None and "namePinyinAbbr" in kwargs:
  419. submitted = kwargs.get("namePinyinAbbr")
  420. name_pinyin_abbr = resolve_name_pinyin_abbr(
  421. name=kwargs.get("customer_name"),
  422. submitted=submitted,
  423. submitted_provided=True,
  424. )
  425. obj = CrmCustomer(
  426. id=generate_uuid(),
  427. customer_no=customer_no,
  428. customer_name=kwargs.get("customer_name"),
  429. name_pinyin_abbr=name_pinyin_abbr,
  430. short_name=kwargs.get("short_name"),
  431. customer_type=kwargs.get("customer_type", "company"),
  432. mobile=kwargs.get("mobile"),
  433. telephone=kwargs.get("telephone"),
  434. email=kwargs.get("email"),
  435. website=kwargs.get("website"),
  436. level=kwargs.get("level", "normal"),
  437. source=kwargs.get("source"),
  438. industry=kwargs.get("industry"),
  439. park_area=kwargs.get("park_area"),
  440. payment_terms=kwargs.get("payment_terms"),
  441. scale=kwargs.get("scale"),
  442. province=kwargs.get("province"),
  443. city=kwargs.get("city"),
  444. district=kwargs.get("district"),
  445. address=kwargs.get("address"),
  446. status="normal",
  447. deal_status="not_deal",
  448. owner_user_id=owner_id,
  449. owner_user_name=owner_name,
  450. follow_count=0,
  451. deal_amount=0,
  452. contact_count=0,
  453. opportunity_count=0,
  454. contract_count=0,
  455. business_license_img=kwargs.get("business_license_img"),
  456. business_permit_images=kwargs.get("business_permit_images"),
  457. other_cert_images=kwargs.get("other_cert_images"),
  458. clue_id=kwargs.get("clue_id"),
  459. next_time=_parse_optional_datetime(kwargs.get("next_time")),
  460. tenant_no=tenant_no,
  461. order_num=kwargs.get("order_num"),
  462. remark=kwargs.get("remark"),
  463. create_by=user_id,
  464. create_dept_id=dept_id,
  465. del_flag=0,
  466. )
  467. db.add(obj)
  468. db.commit()
  469. db.refresh(obj)
  470. return obj
  471. def update_customer(
  472. db: Session,
  473. customer_id: str,
  474. *,
  475. user_id: str = None,
  476. user_info=None,
  477. tenant_no: str = None,
  478. **kwargs,
  479. ) -> CrmCustomer:
  480. obj = get_customer(db, customer_id)
  481. if not obj:
  482. raise ValueError("客户不存在")
  483. if tenant_no and obj.tenant_no != tenant_no:
  484. raise ValueError("客户不存在")
  485. _ensure_customer_in_scope(db, obj, user_info, obj.tenant_no)
  486. # name_pinyin_abbr 单独处理,避免双重赋值
  487. _updatable = (
  488. "customer_name", "short_name", "customer_type", "mobile", "telephone",
  489. "email", "website", "level", "source", "industry", "park_area",
  490. "payment_terms", "scale", "province", "city", "district", "address",
  491. "business_license_img",
  492. "business_permit_images", "other_cert_images",
  493. "clue_id", "order_num", "remark",
  494. "next_time",
  495. )
  496. _datetime_fields = {"next_time"}
  497. for field in _updatable:
  498. if field not in kwargs:
  499. continue
  500. val = kwargs[field]
  501. if field in _datetime_fields:
  502. setattr(obj, field, _parse_optional_datetime(val))
  503. elif val is not None:
  504. setattr(obj, field, val)
  505. # 拼音首字母:提交了则用提交值(空则重生);未提交则保留已有,已有空则按名称生成
  506. name_keys = ("name_pinyin_abbr", "namePinyinAbbr")
  507. submitted_provided = any(k in kwargs for k in name_keys)
  508. submitted = kwargs.get("name_pinyin_abbr")
  509. if submitted is None:
  510. submitted = kwargs.get("namePinyinAbbr")
  511. if "customer_name" in kwargs and kwargs.get("customer_name") is not None:
  512. new_name = kwargs.get("customer_name")
  513. else:
  514. new_name = obj.customer_name
  515. obj.name_pinyin_abbr = resolve_name_pinyin_abbr(
  516. name=new_name,
  517. submitted=submitted,
  518. existing=obj.name_pinyin_abbr,
  519. submitted_provided=submitted_provided,
  520. )
  521. if "owner_user_id" in kwargs:
  522. owner_id = (kwargs.pop("owner_user_id") or "").strip() or None
  523. obj.owner_user_id = owner_id
  524. obj.owner_user_name = _resolve_user_display_name(db, owner_id) if owner_id else None
  525. obj.update_by = user_id
  526. obj.update_time = datetime.now()
  527. db.commit()
  528. db.refresh(obj)
  529. return obj
  530. def soft_delete_customer(
  531. db: Session, customer_id: str, user_id: str = None, user_info=None, tenant_no: str = None
  532. ) -> bool:
  533. obj = get_customer(db, customer_id)
  534. if not obj:
  535. raise ValueError("客户不存在")
  536. if tenant_no and obj.tenant_no != tenant_no:
  537. raise ValueError("客户不存在")
  538. _ensure_customer_in_scope(db, obj, user_info, obj.tenant_no)
  539. assert_row_deletable_by_creator(obj, user_info, user_id=user_id)
  540. obj.del_flag = 1
  541. obj.update_by = user_id
  542. obj.update_time = datetime.now()
  543. db.commit()
  544. return True
  545. def transfer_customer(
  546. db: Session,
  547. customer_id: str,
  548. new_owner_id: str,
  549. new_owner_name: str,
  550. user_id: str = None,
  551. user_info=None,
  552. tenant_no: str = None,
  553. ) -> CrmCustomer:
  554. obj = get_customer(db, customer_id)
  555. if not obj:
  556. raise ValueError("客户不存在")
  557. if tenant_no and obj.tenant_no != tenant_no:
  558. raise ValueError("客户不存在")
  559. _ensure_customer_in_scope(db, obj, user_info, obj.tenant_no)
  560. old_owner_id = obj.owner_user_id or ""
  561. old_owner_name = obj.owner_user_name or ""
  562. obj.owner_user_id = new_owner_id
  563. obj.owner_user_name = new_owner_name
  564. obj.update_by = user_id
  565. obj.update_time = datetime.now()
  566. db.commit()
  567. db.refresh(obj)
  568. from app.crud.crm.customer_pool import create_pool_record
  569. create_pool_record(
  570. db,
  571. tenant_no=obj.tenant_no,
  572. user_id=user_id,
  573. customer_id=obj.id,
  574. customer_name=obj.customer_name,
  575. operation_type="assign",
  576. from_user_id=old_owner_id,
  577. from_user_name=old_owner_name,
  578. to_user_id=new_owner_id,
  579. to_user_name=new_owner_name,
  580. )
  581. return obj
  582. def deal_customer(
  583. db: Session,
  584. customer_id: str,
  585. deal_amount: float = 0,
  586. deal_time: str = None,
  587. user_id: str = None,
  588. user_info=None,
  589. tenant_no: str = None,
  590. ) -> CrmCustomer:
  591. obj = get_customer(db, customer_id)
  592. if not obj:
  593. raise ValueError("客户不存在")
  594. if tenant_no and obj.tenant_no != tenant_no:
  595. raise ValueError("客户不存在")
  596. _ensure_customer_in_scope(db, obj, user_info, obj.tenant_no)
  597. obj.deal_status = "dealed"
  598. if deal_amount:
  599. obj.deal_amount = deal_amount
  600. parsed_deal_time = _parse_optional_datetime(deal_time)
  601. obj.deal_time = parsed_deal_time or datetime.now()
  602. obj.update_by = user_id
  603. obj.update_time = datetime.now()
  604. db.commit()
  605. db.refresh(obj)
  606. return obj
  607. def into_pool(
  608. db: Session,
  609. customer_id: str,
  610. reason: str = None,
  611. user_id: str = None,
  612. user_info=None,
  613. tenant_no: str = None,
  614. ) -> CrmCustomer:
  615. obj = get_customer(db, customer_id)
  616. if not obj:
  617. raise ValueError("客户不存在")
  618. if tenant_no and obj.tenant_no != tenant_no:
  619. raise ValueError("客户不存在")
  620. _ensure_customer_in_scope(db, obj, user_info, obj.tenant_no)
  621. old_owner_id = obj.owner_user_id or ""
  622. old_owner_name = obj.owner_user_name or ""
  623. obj.status = "pool"
  624. obj.into_pool_time = datetime.now()
  625. obj.into_pool_by = user_id
  626. obj.into_pool_reason = reason
  627. obj.owner_user_id = None
  628. obj.update_by = user_id
  629. obj.update_time = datetime.now()
  630. db.commit()
  631. db.refresh(obj)
  632. from app.crud.crm.customer_pool import create_pool_record
  633. create_pool_record(
  634. db,
  635. tenant_no=obj.tenant_no,
  636. user_id=user_id,
  637. customer_id=obj.id,
  638. customer_name=obj.customer_name,
  639. operation_type="into",
  640. from_user_id=old_owner_id,
  641. from_user_name=old_owner_name,
  642. reason=reason,
  643. )
  644. return obj
  645. def claim_customer(
  646. db: Session,
  647. customer_id: str,
  648. user_id: str,
  649. user_name: str,
  650. ) -> CrmCustomer:
  651. obj = get_customer(db, customer_id)
  652. if not obj:
  653. raise ValueError("客户不存在")
  654. if obj.status != "pool":
  655. raise ValueError("该客户不在公海池中")
  656. obj.status = "normal"
  657. obj.owner_user_id = user_id
  658. obj.owner_user_name = user_name
  659. obj.claim_time = datetime.now()
  660. obj.into_pool_time = None
  661. obj.into_pool_by = None
  662. obj.into_pool_reason = None
  663. obj.update_by = user_id
  664. obj.update_time = datetime.now()
  665. db.commit()
  666. db.refresh(obj)
  667. from app.crud.crm.customer_pool import create_pool_record
  668. create_pool_record(
  669. db,
  670. tenant_no=obj.tenant_no,
  671. user_id=user_id,
  672. customer_id=obj.id,
  673. customer_name=obj.customer_name,
  674. operation_type="claim",
  675. to_user_id=user_id,
  676. to_user_name=user_name,
  677. )
  678. return obj
  679. def batch_claim_customers(
  680. db: Session,
  681. ids: List[str],
  682. user_id: str,
  683. user_name: str,
  684. ) -> List[CrmCustomer]:
  685. results = []
  686. for cid in ids:
  687. obj = claim_customer(db, cid, user_id, user_name)
  688. results.append(obj)
  689. return results
  690. def assign_customer(
  691. db: Session,
  692. ids: List[str],
  693. owner_user_id: str,
  694. owner_user_name: str,
  695. user_id: str = None,
  696. user_info=None,
  697. tenant_no: str = None,
  698. ) -> List[CrmCustomer]:
  699. results = []
  700. for cid in ids:
  701. obj = get_customer(db, cid)
  702. if not obj:
  703. continue
  704. if tenant_no and obj.tenant_no != tenant_no:
  705. continue
  706. _ensure_customer_in_scope(db, obj, user_info, obj.tenant_no)
  707. old_owner_id = obj.owner_user_id or ""
  708. old_owner_name = obj.owner_user_name or ""
  709. obj.status = "normal"
  710. obj.owner_user_id = owner_user_id
  711. obj.owner_user_name = owner_user_name
  712. obj.assign_time = datetime.now()
  713. obj.assign_by = user_id
  714. obj.into_pool_time = None
  715. obj.into_pool_by = None
  716. obj.into_pool_reason = None
  717. obj.update_by = user_id
  718. obj.update_time = datetime.now()
  719. from app.crud.crm.customer_pool import create_pool_record
  720. create_pool_record(
  721. db,
  722. tenant_no=obj.tenant_no,
  723. user_id=user_id,
  724. customer_id=obj.id,
  725. customer_name=obj.customer_name,
  726. operation_type="assign",
  727. from_user_id=old_owner_id,
  728. from_user_name=old_owner_name,
  729. to_user_id=owner_user_id,
  730. to_user_name=owner_user_name,
  731. )
  732. results.append(obj)
  733. db.commit()
  734. return results
  735. def update_follow_stats(
  736. db: Session,
  737. customer_id: str,
  738. follow_time: datetime = None,
  739. next_time: datetime = None,
  740. ) -> None:
  741. obj = get_customer(db, customer_id)
  742. if not obj:
  743. return
  744. if follow_time:
  745. obj.last_time = follow_time
  746. if next_time:
  747. obj.next_time = next_time
  748. obj.follow_count = (obj.follow_count or 0) + 1
  749. db.commit()
  750. def update_contact_count(db: Session, customer_id: str) -> None:
  751. from app.models.crm_models import CrmContact
  752. count = (
  753. db.query(func.count(CrmContact.id))
  754. .filter(
  755. CrmContact.customer_id == customer_id,
  756. CrmContact.del_flag == 0,
  757. )
  758. .scalar() or 0
  759. )
  760. obj = get_customer(db, customer_id)
  761. if obj:
  762. obj.contact_count = count
  763. db.commit()
  764. def get_park_area_list(db: Session, tenant_no: str) -> list:
  765. return [
  766. r[0]
  767. for r in db.query(CrmCustomer.park_area)
  768. .filter(
  769. CrmCustomer.tenant_no == tenant_no,
  770. CrmCustomer.del_flag == 0,
  771. CrmCustomer.park_area.isnot(None),
  772. CrmCustomer.park_area != "",
  773. )
  774. .distinct()
  775. .order_by(CrmCustomer.park_area)
  776. .all()
  777. ]