BiQueryCallsDto.cs 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657
  1. using Hotline.Share.Enums.CallCenter;
  2. using Hotline.Share.Requests;
  3. using Hotline.Share.Tools;
  4. using System.ComponentModel.DataAnnotations;
  5. using XF.Utility.EnumExtensions;
  6. namespace Hotline.Share.Dtos.CallCenter;
  7. public record BiQueryCallsDto : ReportRequiredPagedRequest
  8. {
  9. /// <summary>
  10. /// 线路
  11. /// </summary>
  12. public string? Line { get; set; }
  13. /// <summary>
  14. /// 查询类型 1:呼入总量明细;2:接通总量明细
  15. /// </summary>
  16. public string? TypeCode { get; set; } = "1";
  17. }
  18. public record QueryCallListDto : PagedRequest
  19. {
  20. public DateTime StartTime { get; set; }
  21. public DateTime EndTime { get; set; }
  22. public string Type { get; set; }
  23. public string Source { get; set; }
  24. public TimeSpan? StartHourTo { get; set; }
  25. }
  26. public class BiQueryHourCallDto : StartEndTimeDto
  27. {
  28. public string Source { get; set; }
  29. }
  30. public class BiQueryGateWayDto : StartEndTimeDto
  31. {
  32. public string Gateway { get; set; }
  33. }
  34. public class StartEndTimeDto
  35. {
  36. [Required]
  37. public DateTime StartTime { get; set; }
  38. [Required]
  39. public DateTime EndTime { get; set; }
  40. }
  41. public record PagedStartEndTimeDto : PagedRequest
  42. {
  43. [Required]
  44. public DateTime StartTime { get; set; }
  45. [Required]
  46. public DateTime EndTime { get; set; }
  47. }
  48. public class TotalList<T>
  49. {
  50. public TotalList()
  51. {
  52. }
  53. public TotalList(List<T> list, T total)
  54. {
  55. List = list;
  56. Total = total;
  57. }
  58. public T Total { get; set; }
  59. public List<T> List { get; set; }
  60. }
  61. public class TotalData<T>
  62. {
  63. public TotalData()
  64. {
  65. }
  66. public TotalData(List<T> list, int total)
  67. {
  68. Data = list;
  69. Total = total;
  70. }
  71. public int Total { get; set; }
  72. public List<T> Data { get; set; }
  73. }
  74. public record QueryCallsStatisticsDetailInDto : PagedStartEndTimeDto
  75. {
  76. /// <summary>
  77. /// 工单编号
  78. /// </summary>
  79. public string? OrderNo { get; set; }
  80. /// <summary>
  81. /// 主叫
  82. /// </summary>
  83. public string? FromNo { get; set; }
  84. /// <summary>
  85. /// 被叫
  86. /// </summary>
  87. public string? ToNo { get; set; }
  88. /// <summary>
  89. /// 分机号码
  90. /// </summary>
  91. public string? TelNo { get; set; }
  92. /// <summary>
  93. /// 挂断方
  94. /// </summary>
  95. public EEndBy? EndBy { get; set; }
  96. /// <summary>
  97. /// 上一个页面点击的字段名称
  98. /// </summary>
  99. public string? FieldName { get; set; }
  100. }
  101. public class QueryCallsStatisticsDetailOutDto
  102. {
  103. public string Id { get; set; }
  104. public string? OrderId { get; set; }
  105. /// <summary>
  106. /// 工单号
  107. /// </summary>
  108. public string? OrderNo { get; set; }
  109. /// <summary>
  110. /// 工单标题
  111. /// </summary>
  112. public string? OrderTitle { get; set; }
  113. /// <summary>
  114. /// 主叫
  115. /// </summary>
  116. public string FromNo { get; set; }
  117. /// <summary>
  118. /// 被叫
  119. /// </summary>
  120. public string ToNo { get; set; }
  121. /// <summary>
  122. /// 响应分机号
  123. /// </summary>
  124. public string TelNo { get; set; }
  125. /// <summary>
  126. /// 挂断方
  127. /// </summary>
  128. public EEndBy? EndBy { get; set; }
  129. public string EndByTxt => EndBy.GetDescription();
  130. /// <summary>
  131. /// 话务员姓名
  132. /// </summary>
  133. public string UserName { get; set; }
  134. /// <summary>
  135. /// 分机组id(技能组Id)
  136. /// </summary>
  137. public string? GroupId { get; set; }
  138. /// <summary>
  139. /// IVR开始时间
  140. /// </summary>
  141. public DateTime? BeginIvrTime { get; set; }
  142. /// <summary>
  143. /// 接听时间
  144. /// </summary>
  145. public DateTime? AnsweredTime { get; set; }
  146. /// <summary>
  147. /// 挂机时间
  148. /// </summary>
  149. public DateTime EndTime { get; set; }
  150. /// <summary>
  151. /// 通话时长(秒)
  152. /// </summary>
  153. public int Duration { get; set; }
  154. /// <summary>
  155. /// 语音文件路径
  156. /// </summary>
  157. public string AudioFile { get; set; }
  158. }
  159. #region 宜宾新话务报表
  160. public class QueryCallDateStatisticsDetailDto
  161. {
  162. public DateTime? StartTime { get; set; }
  163. public DateTime? EndTime { get; set; }
  164. }
  165. public class QueryCallDateStatisticsDetailResp
  166. {
  167. /// <summary>
  168. /// 日期
  169. /// </summary>
  170. public string Date { get; set; }
  171. /// <summary>
  172. /// 呼入总量(计算所得)
  173. /// </summary>
  174. public int CallInTotal => IvrCallInTotal + PersonCallInCount + EnterpriseCallInCount + AiCallInCount;
  175. /// <summary>
  176. /// IVR呼入总量
  177. /// </summary>
  178. public int IvrCallInTotal { get; set; }
  179. /// <summary>
  180. /// 个人服务呼入总量
  181. /// </summary>
  182. public int PersonCallInCount { get; set; }
  183. /// <summary>
  184. /// 企业服务呼入总量
  185. /// </summary>
  186. public int EnterpriseCallInCount { get; set; }
  187. /// <summary>
  188. /// 智能应答呼入总量
  189. /// </summary>
  190. public int AiCallInCount { get; set; }
  191. /// <summary>
  192. /// 接通总量(计算所得)
  193. /// </summary>
  194. public int PutthroughCount => PersonCallInPutthroughCount+ EnterpriseCallInPutthroughCount + AiCallInPutthroughCount;
  195. /// <summary>
  196. /// 个人服务接通量
  197. /// </summary>
  198. public int PersonCallInPutthroughCount { get; set; }
  199. /// <summary>
  200. /// 企业服务接通量
  201. /// </summary>
  202. public int EnterpriseCallInPutthroughCount { get; set; }
  203. /// <summary>
  204. /// 智能应答呼入总量
  205. /// </summary>
  206. public int AiCallInPutthroughCount { get; set; }
  207. /// <summary>
  208. /// 挂断总量
  209. /// </summary>
  210. public int RingOffCount => PersonRingOffCount + EnterpriseRingOffCount + IvrRingOffCount;
  211. /// <summary>
  212. /// 个人服务挂断总量
  213. /// </summary>
  214. public int PersonRingOffCount { get; set; }
  215. /// <summary>
  216. /// 企业服务挂断总量
  217. /// </summary>
  218. public int EnterpriseRingOffCount { get; set; }
  219. /// <summary>
  220. /// IVR挂断总量
  221. /// </summary>
  222. public int IvrRingOffCount { get; set; }
  223. /// <summary>
  224. /// 总体接通率
  225. /// </summary>
  226. public double TotalPutthroughRate => PutthroughCount == 0 ? 0 : Math.Round(((double)PutthroughCount / CallInTotal)*100,2);
  227. /// <summary>
  228. /// 总体接通率(文本)
  229. /// </summary>
  230. public string TotalPutthroughRateText => TotalPutthroughRate + "%";
  231. /// <summary>
  232. /// 服务接通率
  233. /// </summary>
  234. public double ServicePutthorughRate => (PersonCallInPutthroughCount + EnterpriseCallInPutthroughCount + AiCallInPutthroughCount) == 0 ? 0 : Math.Round(((double)PutthroughCount / (PersonCallInPutthroughCount + EnterpriseCallInPutthroughCount + AiCallInPutthroughCount)) * 100, 2);
  235. /// <summary>
  236. /// 服务接通率(文本)
  237. /// </summary>
  238. public string ServicePutthorughRateText => ServicePutthorughRate + "%";
  239. /// <summary>
  240. /// 话务接通率
  241. /// </summary>
  242. public double CallPutthorughRate => (PersonCallInPutthroughCount + EnterpriseCallInPutthroughCount) == 0 ? 0 : Math.Round(((double)(PersonCallInPutthroughCount + EnterpriseCallInPutthroughCount)) / (PersonCallInCount + EnterpriseCallInCount) * 100, 2);
  243. /// <summary>
  244. /// 话务接通率(文本)
  245. /// </summary>
  246. public string CallPutthorughRateText => CallPutthorughRate + "%";
  247. }
  248. public class QueryPersonCallDateStatisticsDetailResp
  249. {
  250. /// <summary>
  251. /// 日期
  252. /// </summary>
  253. public string Date { get; set; }
  254. /// <summary>
  255. /// 个人服务呼入总量
  256. /// </summary>
  257. public int PersonCallInCount { get; set; }
  258. /// <summary>
  259. /// 个人服务接通量
  260. /// </summary>
  261. public int PersonCallInPutthroughCount { get; set; }
  262. /// <summary>
  263. /// 个人服务挂断总量
  264. /// </summary>
  265. public int PersonRingOffCount => PersonQueueOffCount + PersonWaitOffCount;
  266. /// <summary>
  267. /// 个人服务队列挂断
  268. /// </summary>
  269. public int PersonQueueOffCount { get; set; }
  270. /// <summary>
  271. /// 个人服务等待挂断
  272. /// </summary>
  273. public int PersonWaitOffCount { get; set; }
  274. /// <summary>
  275. /// 个人服务接通率
  276. /// </summary>
  277. public double PersonCallPutthorughRate => PersonCallInPutthroughCount == 0 ? 0 : Math.Round(((double)(PersonCallInPutthroughCount)) / (PersonCallInCount) * 100, 2);
  278. /// <summary>
  279. /// 个人服务接通率
  280. /// </summary>
  281. public string PersonCallPutthorughRateText => PersonCallPutthorughRate + "%";
  282. }
  283. public class QueryEnterpriseCallDateStatisticsDetailResp
  284. {
  285. /// <summary>
  286. /// 日期
  287. /// </summary>
  288. public string Date { get; set; }
  289. /// <summary>
  290. /// 企业服务呼入总量
  291. /// </summary>
  292. public int EnterpriseCallInCount { get; set; }
  293. /// <summary>
  294. /// 企业服务接通量
  295. /// </summary>
  296. public int EnterpriseCallInPutthroughCount { get; set; }
  297. /// <summary>
  298. /// 企业服务挂断总量
  299. /// </summary>
  300. public int EnterpriseRingOffCount => EnterpriseQueueOffCount + EnterpriseWaitOffCount;
  301. /// <summary>
  302. /// 企业服务队列挂断
  303. /// </summary>
  304. public int EnterpriseQueueOffCount { get; set; }
  305. /// <summary>
  306. /// 企业服务等待挂断
  307. /// </summary>
  308. public int EnterpriseWaitOffCount { get; set; }
  309. /// <summary>
  310. /// 企业服务接通率
  311. /// </summary>
  312. public double EnterpriseCallPutthorughRate => EnterpriseCallInPutthroughCount == 0 ? 0 : Math.Round(((double)(EnterpriseCallInPutthroughCount)) / (EnterpriseCallInCount) * 100, 2);
  313. /// <summary>
  314. /// 个人服务接通率
  315. /// </summary>
  316. public string EnterpriseCallPutthorughRateText => EnterpriseCallPutthorughRate + "%";
  317. }
  318. public class QueryCallOutDateStatisticsDetailResp
  319. {
  320. /// <summary>
  321. /// 日期
  322. /// </summary>
  323. public string Date { get; set; }
  324. /// <summary>
  325. /// 呼出总量
  326. /// </summary>
  327. public int CallOutTotal => PersonCallOutCount + EnterpriseCallOutCount + AiVisitCallOutCount + AiCallOutCount;
  328. /// <summary>
  329. /// 个人服务呼出总量
  330. /// </summary>
  331. public int PersonCallOutCount { get; set; }
  332. /// <summary>
  333. /// 企业服务呼出总量
  334. /// </summary>
  335. public int EnterpriseCallOutCount { get; set; }
  336. /// <summary>
  337. /// 智能回访呼出总量
  338. /// </summary>
  339. public int AiVisitCallOutCount { get; set; }
  340. /// <summary>
  341. /// 智能外呼呼出总量
  342. /// </summary>
  343. public int AiCallOutCount { get; set; }
  344. /// <summary>
  345. /// 呼出接通数
  346. /// </summary>
  347. public int CallOutPutthroughCount => PersonCallOutPutthroughCount + EnterpriseCallOutPutthroughCount + AiVisitCallOutPutthroughCount + AiCallOutPutthroughCount;
  348. /// <summary>
  349. /// 个人服务呼出接通数
  350. /// </summary>
  351. public int PersonCallOutPutthroughCount { get; set; }
  352. /// <summary>
  353. /// 企业服务呼出接通数
  354. /// </summary>
  355. public int EnterpriseCallOutPutthroughCount { get; set; }
  356. /// <summary>
  357. /// 智能回访呼出接通数
  358. /// </summary>
  359. public int AiVisitCallOutPutthroughCount { get; set; }
  360. /// <summary>
  361. /// 智能外呼呼出接通数
  362. /// </summary>
  363. public int AiCallOutPutthroughCount { get; set; }
  364. /// <summary>
  365. /// 呼出接通率
  366. /// </summary>
  367. public double CallOutPutthroughRate => CallOutTotal == 0 ? 0 : Math.Round(((double)CallOutPutthroughCount / CallOutTotal) * 100, 2);
  368. public string CallOutPutthroughRateText => CallOutPutthroughRate + "%";
  369. /// <summary>
  370. /// 个人服务呼出接通率
  371. /// </summary>
  372. public double PersonCallOutPutthroughRate => PersonCallOutCount == 0 ? 0 : Math.Round(((double)PersonCallOutPutthroughCount / PersonCallOutCount) * 100, 2);
  373. public string PersonCallOutPutthroughRateText => PersonCallOutPutthroughRate + "%";
  374. /// <summary>
  375. /// 企业服务呼出接通率
  376. /// </summary>
  377. public double EnterpriseCallOutPutthroughRate => EnterpriseCallOutCount == 0 ? 0 : Math.Round(((double)EnterpriseCallOutPutthroughCount / EnterpriseCallOutCount) * 100, 2);
  378. public string EnterpriseCallOutPutthroughRateText => EnterpriseCallOutPutthroughRate + "%";
  379. /// <summary>
  380. /// 智能回访呼出接通率
  381. /// </summary>
  382. public double AiVisitCallOutPutthroughRate => AiVisitCallOutCount == 0 ? 0 : Math.Round(((double)AiVisitCallOutPutthroughCount / AiVisitCallOutCount) * 100, 2);
  383. public string AiVisitCallOutPutthroughRatetext => AiVisitCallOutPutthroughRate + "%";
  384. /// <summary>
  385. /// 智能外呼呼出接通率
  386. /// </summary>
  387. public double AiCallOutPutthroughRate => AiCallOutCount == 0 ? 0 : Math.Round(((double)AiCallOutPutthroughCount / AiCallOutCount) * 100, 2);
  388. public string AiCallOutPutthroughRateText => AiCallOutPutthroughRate + "%";
  389. }
  390. public class QuerySeatMonthCallResp
  391. {
  392. /// <summary>
  393. /// 坐席姓名
  394. /// </summary>
  395. public string Name { get; set; }
  396. /// <summary>
  397. /// 用户ID
  398. /// </summary>
  399. public string UserId { get; set; }
  400. /// <summary>
  401. /// 呼入总量
  402. /// </summary>
  403. public int InTotal => InAnswered + InHanguped;
  404. /// <summary>
  405. /// 呼入接通量
  406. /// </summary>
  407. public int InAnswered { get; set; }
  408. /// <summary>
  409. /// 有效接通量
  410. /// </summary>
  411. public int InAvailableAnswer { get; set; }
  412. /// <summary>
  413. /// 呼入接通秒挂
  414. /// </summary>
  415. public int InHangupImmediateWhenAnswered { get; set; }
  416. /// <summary>
  417. /// 超时接通量
  418. /// </summary>
  419. public int OverTimeImmediate { get; set; }
  420. /// <summary>
  421. /// 按时接通量
  422. /// </summary>
  423. public int InTimeImmediate { get; set; }
  424. /// <summary>
  425. /// 呼入未接通总量
  426. /// </summary>
  427. public int InHanguped { get; set; }
  428. /// <summary>
  429. /// 未接通秒挂量
  430. /// </summary>
  431. public int InHangupImmediate { get; set; }
  432. /// <summary>
  433. /// 超时未接通量
  434. /// </summary>
  435. public int OverTimeInHanguped { get; set; }
  436. /// <summary>
  437. /// 呼入接通率
  438. /// </summary>
  439. public double InAnsweredRate => InTotal > 0 ? Math.Round(((double)InAnswered / (double)InTotal) * 100, digits: 2) : 0;
  440. /// <summary>
  441. /// 呼入接通率(显示)
  442. /// </summary>
  443. public string InAnsweredRateString => this.InAnsweredRate + "%";
  444. }
  445. public class QuerySeatMonthCallRequest
  446. {
  447. /// <summary>
  448. /// 振铃开始时间开始
  449. /// </summary>
  450. public DateTime? StartTime { get; set; }
  451. /// <summary>
  452. /// 振铃开始时间结束
  453. /// </summary>
  454. public DateTime? EndTime { get; set; }
  455. /// <summary>
  456. /// 员工ID
  457. /// </summary>
  458. public string? EmpId { get; set; }
  459. }
  460. public record QuerySeatMonthCallDetailRequest:PagedRequest
  461. {
  462. /// <summary>
  463. /// 坐席ID
  464. /// </summary>
  465. public string? EmpId { get; set; }
  466. /// <summary>
  467. /// 主叫
  468. /// </summary>
  469. public string? Cpn { get; set; }
  470. /// <summary>
  471. /// 被叫
  472. /// </summary>
  473. public string? Cdpn { get; set; }
  474. /// <summary>
  475. /// 分机号
  476. /// </summary>
  477. public string? TelNo { get; set; }
  478. /// <summary>
  479. /// 接通时间开始
  480. /// </summary>
  481. public DateTime? AnsweredStartTime { get; set; }
  482. /// <summary>
  483. /// 接通时间结束
  484. /// </summary>
  485. public DateTime? AnsweredEndTime { get; set; }
  486. /// <summary>
  487. /// 振铃时间开始
  488. /// </summary>
  489. public DateTime? RingStartTime { get; set; }
  490. /// <summary>
  491. /// 振铃时间结束
  492. /// </summary>
  493. public DateTime? RingEndTime { get;set; }
  494. }
  495. public class QuerySeatMonthCallDetailResp
  496. {
  497. /// <summary>
  498. /// 主叫
  499. /// </summary>
  500. public string Cpn { get; set; }
  501. /// <summary>
  502. /// 被叫
  503. /// </summary>
  504. public string Cdpn { get; set; }
  505. /// <summary>
  506. /// 振铃开始时间
  507. /// </summary>
  508. public DateTime? RingTimeBegin { get; set; }
  509. /// <summary>
  510. /// 接通时间
  511. /// </summary>
  512. public DateTime? AnsweredTime { get; set; }
  513. /// <summary>
  514. /// 响应分机
  515. /// </summary>
  516. public string? TelNo { get; set; }
  517. /// <summary>
  518. /// 坐席名称
  519. /// </summary>
  520. public string? SeatName { get; set; }
  521. }
  522. #endregion