Business System-call center Secondary Development (completed) and call center Secondary Development

Business System-call center Secondary Development (completed) and call center Secondary Development
I. batch sieve number: 1. input: case No. Output: All phone numbers in this batch (not in valid status) are screened in batches, and numbers in unknown status are marked as valid and invalid. 2. Table: Call_Filter_Task = (Id, Step, Status, BatchId, CateGoryId, TaskType, TotalNum, Creator, CreateTime, RunBeginTime, RunEndTime)
Latency = (Id, Status, Filter_Task_Id, Order, TotalNum, Creator, CreateTime) latency = (Id, Filter_Task_Id, Order, TotalNum, Task_Id, Creator, CreateTime, RunBeginTime, RunEndTime | Send_FromFlag, send_RecvFlag, Send_BeginTime, Send_RecvTime, Send_Res_SumInfo | Query_FromFlag, Query_RecvFlag, Query_BeginTime, Query_RecvTime, Query_Res_SumInfo)
Call_Filter_Send_Detail = (Id, Filter_Send_Batch_Id, TelId, TelNo, Call_Info, Record_Id, Creator, CreateTime)
Latency = (Id, latency, Nid, Phone, Call_Status, BillSec, Call_Start_Time, Answer_Time, Call_End_Time, Wait_Time, Uniqueid, Fail_Call_Times, latency, Ivr_Key, Agent, Agent_Billsec, latency, latency, createTime); 3. step 1: On the screen number page, enter a "batch number: batchId" and click "query phone number" to display a summary record "Call_Filter_Task" Step 2: file JOB, query the Call_Filter_Task record whose status is "0: Create task 0 ". File data: "Call_Filter_Send_Batch record", "Call_Filter_Send_Detail record", and "Call_Filter_Send_Detail File". The maximum number of files in each batch is 1000 (configuration can be modified ). Step 3: Send a JOB, query the Call_Filter_Send_Batch record, and determine whether "Log exists" or "Whether the Query Task is successfully sent", then run the send API interface, and generate the Log record "Call_Filter_Send_Batch_Log ", modify the Call_Filter_Send_Batch_Log status to "Send_FromFlag = 0-> 1 | Send_RecvFlag = 0-> 1 or-1" Step 4: query the JOB and query "Call_Filter_Send_Batch_Log ", query the API Based on the log records with the sending status Send_RecvFlag = 1 and Query_FromFlag = 0; the status of the updated log record "Call_Filter_Send_Batch_Log" is "Query_FromFlag = 0-> 1 | Query_RecvFlag = 0-> 1 or-1 "; save the result as "JSON message file and corresponding user Excel file" and update the result to the phone record Status "valid phone number | invalid phone number"


After several weeks of development, the development is completed as follows:

 Part 1: foreground settings: Configure the working status of the "Screening Task" and "batch files" in the data dictionary, for example:
 





 Part 2: background services: The system has three scheduled tasks in the background, which check the records of specific statuses in the related task table and log table every 5 minutes. The following JOB is scheduled in real time based on condition matching:
Job1: Create a batch scheduler task, Job2: Send a batch scheduler task, Job3: query a batch scheduler task

Code diagram:


The execution result is as follows:
 
Job1: Create a batch of scheduled tasks: process the "screening number application" submitted by the user's front-end in real time (partition field: data created on the Day ),
In addition, the "json command file for batch calls from the call center and xlsx file for users to view" are generated, and the data and status are updated according to the progress.
 




Generate batch log tracing:


Job2: Send a batch scheduled task: process the "batch file" in the "generated" status in the system background in real time (partition field: data created at today's time ), the local file ("json command file for batch outbound calls from the call center") is read to save the database query and construction time, and the data and status are updated according to the progress.


Send batch log tracing:


Job3: Query batch scheduled tasks: Process "batch file Log Data" (partition field: the creation time is the data between yesterday and today), and the "json command file for querying batch outbound call results of the call center" is constructed, and the data and status are updated according to the progress; finally, based on the outbound call results, update the "valid phone status" to implement the "batch screening" function ".



Query batch log tracing:




Significance of this module:
Filtering of a large number of invalid and expired numbers in the business system reduces the waste of business operation dollars every day on invalid numbers, and improves the efficiency of the system and the enthusiasm of employees. If you think this article is good or rewarding, click (Recommended)Button, because your support is the biggest motivation for me to continue writing and share!