today.vue 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439
  1. <template>
  2. <div class="app-container">
  3. <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" v-show="showSearch" label-width="68px">
  4. <el-form-item label="公司名" prop="companyId">
  5. <select-tree
  6. v-model="selectedCompanyList"
  7. :raw-data="deptList"
  8. placeholder="请选择销售"
  9. :parentSelectable="true"
  10. :multiple="true"
  11. component-width="300px"
  12. :max-display-tags="3"
  13. :check-strictly="false"
  14. :return-leaf-only="false"
  15. @change="handleMultiChange"
  16. ></select-tree>
  17. </el-form-item>
  18. <el-form-item label="销售" prop="nickName" v-if="queryParams.companyId">
  19. <el-select v-model="queryParams.companyUserId" remote
  20. placeholder="请选择"
  21. filterable clearable
  22. style="width: 100%;"
  23. @keyup.enter.native="handleQuery"
  24. @change="handleCompanyUserId"
  25. >
  26. <el-option
  27. v-for="dict in companyUserList"
  28. :key="`${dict.nickName} - ${dict.userName}`"
  29. :label="`${dict.nickName} - ${dict.userName}`"
  30. :value="dict.userId">
  31. </el-option>
  32. </el-select>
  33. </el-form-item>
  34. <el-form-item label="时间范围" prop="dateRange">
  35. <el-date-picker
  36. v-model="dateRange"
  37. type="daterange"
  38. range-separator="至"
  39. start-placeholder="开始日期"
  40. end-placeholder="结束日期"
  41. value-format="yyyy-MM-dd"
  42. style="width: 240px"
  43. />
  44. </el-form-item>
  45. <el-form-item label="SOP任务" prop="channel" label-width="70px">
  46. <date-range
  47. v-model="selectedMultipleTasks"
  48. :raw-data="channelList"
  49. placeholder="请选择多个任务"
  50. :parentSelectable="true"
  51. :multiple="true"
  52. component-width="300px"
  53. :max-display-tags="3"
  54. :check-strictly="false"
  55. :return-leaf-only="false"
  56. :show-node-detail="true"
  57. @change="handleMultiChange"
  58. @dateRangeChange="dateRangeChange"
  59. ></date-range>
  60. </el-form-item>
  61. <el-form-item label="包含未发课" label-width="120px">
  62. <el-checkbox v-model="queryParams.includeSend0">
  63. </el-checkbox>
  64. </el-form-item>
  65. <el-form-item>
  66. <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>
  67. <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>
  68. </el-form-item>
  69. </el-form>
  70. <el-row :gutter="10" class="mb8">
  71. <el-col :span="1.5">
  72. <el-button
  73. type="warning"
  74. plain
  75. icon="el-icon-download"
  76. size="mini"
  77. @click="handleExport"
  78. v-hasPermi="['system:stats:export']"
  79. >导出</el-button>
  80. </el-col>
  81. <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar>
  82. </el-row>
  83. <!-- 警告提示 -->
  84. <!-- <el-alert-->
  85. <!-- title="待激活人数依赖进粉时的自动标记和员工手动标记是可变的,相应的目标人数和进线完播率受此影响;为了不受进粉期人数变化影响,第二天新进报名产生的观后数据不做统计;辅助工作台人数不一致可能是受进粉影响,也有可能是员工删除了好友或者取消了客户频道报名。"-->
  86. <!-- type="warning"-->
  87. <!-- :closable="false"-->
  88. <!-- show-icon-->
  89. <!-- class="mb8">-->
  90. <!-- </el-alert>-->
  91. <div style="background-color: #fdf6ec">
  92. <div style="color: #E6A23C;font-size: 14px;display: flex;align-items: center;margin-bottom: 5px">
  93. <i class="el-icon-info"></i>
  94. 查看数据 请先选择 【时间范围】
  95. </div>
  96. <div style="color: #E6A23C;font-size: 14px;display: flex;align-items: center;margin-bottom: 5px">
  97. <i class="el-icon-info"></i>
  98. 待激活人数依赖进粉时的自动标记和员工手动标记是可变的,相应的目标人数和进线完播率受此影响;为了不受进粉期人数变化影响,第二天新进报名产生的观后数据不做统计;辅助工作台人数不一致可能是受进粉影响,也有可能是员工删除了好友或者取消了客户频道报名。
  99. </div>
  100. </div>
  101. <el-table border v-loading="loading" :data="statsList" @selection-change="handleSelectionChange" show-summary :summary-method="getSummaries">
  102. <!-- 未上线部分 -->
  103. <el-table-column prop="dataDate" label="日期" width="180" align="center"/>
  104. <el-table-column prop="trainCampNum" label="营期人数" align="center" />
  105. <el-table-column prop="sendNum" label="发课数" align="center" />
  106. <el-table-column prop="notRegisteredNum" label="待看课" align="center" />
  107. <el-table-column prop="registeredNum" label="上线数" align="center" />
  108. <el-table-column prop="interruptNum" label="看课中断" align="center" />
  109. <el-table-column prop="completedNum" label="已完课" align="center" />
  110. <el-table-column prop="qwRepeatNum" label="企微重粉" align="center" >
  111. <template slot-scope="scope">
  112. <span>{{scope.row.qwRepeatNum || 0}}</span>
  113. </template>
  114. </el-table-column>
  115. <el-table-column prop="userRepeatNum" label="看课重粉(小程序)" align="center" >
  116. <template slot-scope="scope">
  117. <span>{{scope.row.userRepeatNum || 0}}</span>
  118. </template>
  119. </el-table-column>
  120. <el-table-column prop="regRate" label="上线率" align="center">
  121. <template slot-scope="scope">
  122. <span v-if="typeof scope.row.regRate === 'number'">
  123. {{ (scope.row.regRate * 100).toFixed(2) }}%
  124. </span>
  125. <span v-else>
  126. 0.00%
  127. </span>
  128. </template>
  129. </el-table-column>
  130. <el-table-column prop="finishedRate" label="完课率" align="center">
  131. <template slot-scope="scope">
  132. <span v-if="typeof scope.row.finishedRate === 'number'">
  133. {{ (scope.row.finishedRate * 100).toFixed(2) }}%
  134. </span>
  135. <span v-else>
  136. 0.00%
  137. </span>
  138. </template>
  139. </el-table-column>
  140. <!-- 汇总-->
  141. </el-table>
  142. <pagination
  143. v-show="total>0"
  144. :total="total"
  145. :page.sync="queryParams.pageNum"
  146. :limit.sync="queryParams.pageSize"
  147. @pagination="getList"
  148. />
  149. </div>
  150. </template>
  151. <script>
  152. import {
  153. listTodayList,
  154. getEmployeeList,
  155. getChannelList,
  156. exportEmployeeStats,
  157. getSOPTaskData,
  158. getDeptData, exportSellerData, listPeriodList, exportTodayData
  159. } from '@/api/system/employeeStats'
  160. import {getCompanyList} from "@/api/company/company";
  161. import {getUserList} from "@/api/company/companyUser";
  162. import SelectTree from "@/components/TreeSelect/index.vue";
  163. import dateRange from '@/components/TreeSelect/dateRange.vue'
  164. export default {
  165. name: "EmployeeStats",
  166. components: {SelectTree,dateRange},
  167. data() {
  168. return {
  169. // 遮罩层
  170. loading: true,
  171. companys:[],
  172. selectedMultipleTasks: [],
  173. selectedCompanyList: [],
  174. deptList: [],
  175. // 选中数组
  176. ids: [],
  177. // 非单个禁用
  178. single: true,
  179. // 非多个禁用
  180. multiple: true,
  181. // 显示搜索条件
  182. showSearch: true,
  183. // 总条数
  184. total: 0,
  185. // 员工统计表格数据
  186. statsList: [],
  187. // 员工列表
  188. employeeList: [],
  189. companyUserList: [],
  190. // 频道列表
  191. channelList: [],
  192. // 日期范围
  193. dateRange: [],
  194. // 查询参数
  195. queryParams: {
  196. pageNum: 1,
  197. pageSize: 10,
  198. channel: null,
  199. startDate: null,
  200. endDate: null,
  201. companyId: null,
  202. periodList: [],
  203. // 包含未发课数
  204. includeSend0: false
  205. },
  206. // 总体统计
  207. totalStats: {
  208. totalEmployees: 0,
  209. onlineEmployees: 0,
  210. offlineEmployees: 0,
  211. completionRate: '0.00'
  212. }
  213. };
  214. },
  215. created() {
  216. this.getList();
  217. // getCompanyList().then(response => {
  218. // this.companys = response.data;
  219. // });
  220. getSOPTaskData({}).then(response => {
  221. this.channelList = response.data;
  222. });
  223. getDeptData().then(response => {
  224. this.deptList = response.data;
  225. })
  226. },
  227. methods: {
  228. getSummaries(param) {
  229. const { columns, data } = param;
  230. const sums = [];
  231. columns.forEach((column, index) => {
  232. if (index === 0) {
  233. sums[index] = '合计';
  234. return;
  235. }
  236. const values = data.map(item => Number(item[column.property]));
  237. if (['trainCampNum', 'sendNum', 'notRegisteredNum', 'registeredNum', 'interruptNum', 'completedNum', 'qwRepeatNum', 'userRepeatNum'].includes(column.property)) {
  238. if (!values.every(value => isNaN(value))) {
  239. sums[index] = values.reduce((prev, curr) => {
  240. const value = Number(curr);
  241. if (!isNaN(value)) {
  242. return prev + curr;
  243. } else {
  244. return prev;
  245. }
  246. }, 0);
  247. } else {
  248. sums[index] = 'N/A';
  249. }
  250. }
  251. else if (column.property === 'regRate') {
  252. const totalRegistered = data.reduce((sum, item) => sum + (Number(item.registeredNum) || 0), 0);
  253. const totalSendNum = data.reduce((sum, item) => sum + (Number(item.sendNum) || 0), 0);
  254. if (totalSendNum > 0) {
  255. const rate = (totalRegistered / totalSendNum * 100).toFixed(2);
  256. sums[index] = `${rate}%`;
  257. } else {
  258. sums[index] = '0.00%';
  259. }
  260. }
  261. else if (column.property === 'finishedRate') {
  262. const totalCompleted = data.reduce((sum, item) => sum + (Number(item.completedNum) || 0), 0);
  263. const totalSendNum = data.reduce((sum, item) => sum + (Number(item.sendNum) || 0), 0);
  264. if (totalSendNum > 0) {
  265. const rate = (totalCompleted / totalSendNum * 100).toFixed(2);
  266. sums[index] = `${rate}%`;
  267. } else {
  268. sums[index] = '0.00%';
  269. }
  270. }
  271. else {
  272. sums[index] = '';
  273. }
  274. });
  275. return sums;
  276. },
  277. handleCompanyUserId(val){
  278. if(val == null || val === '') {
  279. this.queryParams.companyUserId = null;
  280. this.queryParams.userIds = [];
  281. }
  282. },
  283. handleMultiChange(e){
  284. },
  285. dateRangeChange(e){
  286. getSOPTaskData({
  287. startDate: e[0],
  288. endDate: e[1]
  289. }).then(response => {
  290. this.channelList = response.data;
  291. });
  292. },
  293. handleSeller(){
  294. if(this.queryParams.companyId != null) {
  295. getUserList(this.queryParams.companyId).then(res=>{
  296. if(res.code === 200) {
  297. this.companyUserList = res.data
  298. }
  299. })
  300. } else {
  301. this.queryParams.companyUserId = null;
  302. }
  303. },
  304. /** 查询员工统计列表 */
  305. getList() {
  306. this.loading = true;
  307. if (this.dateRange && this.dateRange.length === 2) {
  308. this.queryParams.startDate = this.dateRange[0];
  309. this.queryParams.endDate = this.dateRange[1];
  310. } else {
  311. this.queryParams.startDate = null;
  312. this.queryParams.endDate = null;
  313. }
  314. if(this.selectedCompanyList != null && this.selectedCompanyList.length > 0) {
  315. this.queryParams.userIds = this.selectedCompanyList;
  316. } else {
  317. this.queryParams.userIds = [];
  318. }
  319. listTodayList(this.queryParams).then(response => {
  320. this.statsList = response.data.list;
  321. this.total = response.data.total;
  322. this.loading = false;
  323. });
  324. },
  325. /** 获取员工列表 */
  326. getEmployeeList() {
  327. getEmployeeList().then(response => {
  328. this.employeeList = response.data || [];
  329. });
  330. },
  331. /** 搜索按钮操作 */
  332. handleQuery() {
  333. this.queryParams.pageNum = 1;
  334. this.queryParams.periodList = this.selectedMultipleTasks;
  335. this.getList();
  336. },
  337. /** 重置按钮操作 */
  338. resetQuery() {
  339. this.dateRange = [];
  340. this.selectedMultipleTasks = [];
  341. this.selectedCompanyList = [];
  342. this.resetForm("queryForm");
  343. this.handleQuery();
  344. },
  345. // 多选框选中数据
  346. handleSelectionChange(selection) {
  347. this.ids = selection.map(item => item.id);
  348. this.single = selection.length !== 1;
  349. this.multiple = !selection.length;
  350. },
  351. /** 导出按钮操作 */
  352. handleExport() {
  353. this.queryParams.periodList = this.selectedMultipleTasks;
  354. if (this.dateRange && this.dateRange.length === 2) {
  355. this.queryParams.startDate = this.dateRange[0];
  356. this.queryParams.endDate = this.dateRange[1];
  357. } else {
  358. this.queryParams.startDate = null;
  359. this.queryParams.endDate = null;
  360. }
  361. if(this.selectedCompanyList != null && this.selectedCompanyList.length > 0) {
  362. this.queryParams.userIds = this.selectedCompanyList;
  363. }else {
  364. this.queryParams.userIds = [];
  365. }
  366. const queryParams = this.queryParams;
  367. this.$confirm('是否确认导出当前查询数据?', "警告", {
  368. confirmButtonText: "确定",
  369. cancelButtonText: "取消",
  370. type: "warning"
  371. }).then(function() {
  372. return exportTodayData(queryParams);
  373. }).then(response => {
  374. this.download(response.msg);
  375. })
  376. }
  377. }
  378. };
  379. </script>
  380. <style lang="scss" scoped>
  381. .stats-card {
  382. text-align: center;
  383. margin-bottom: 16px;
  384. .stats-number {
  385. font-size: 24px;
  386. font-weight: bold;
  387. color: #409EFF;
  388. &.online {
  389. color: #67C23A;
  390. }
  391. &.offline {
  392. color: #F56C6C;
  393. }
  394. &.rate {
  395. color: #E6A23C;
  396. }
  397. }
  398. }
  399. .mb8 {
  400. margin-bottom: 8px;
  401. }
  402. ::v-deep .el-table .el-table__header th {
  403. background-color: #f5f7fa;
  404. }
  405. ::v-deep .el-alert {
  406. margin-bottom: 16px;
  407. }
  408. </style>