I. Batch screen number: 1. Input: Case Batch number output: All phone numbers for the batch (not valid status), batch screen number, the unknown status of the number marked as valid and invalid. 2.table:call_filter_task = (Id, Step, Status, BatchId, CateGoryId, TaskType, Totalnum, Creator, Createtime, Runbeginti Me, Runendtime)
Call_filter_send_batch = (Id, Status, filter_task_id, Order, Totalnum, Creator, Createtime) call_filter_send_batch_log = (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)
call_filter_send_queryres= (Id,filter_send_batch_id,nid,phone,call_status,billsec,call_start_time, answer_time, &NBSP ; call_end_time,wait_time,uniqueid,fail_call_times,success_call_times,ivr_key, Agent,agent_bills Ec,agent_answer_time,agent_end_time,createtime) 3. Operation Flow STEP1: The user in the screen number interface, enter a "lot number: BatchId", and then click the button "Query Phone", Displays a summary record "Call_filter_task"  STEP2: File job, query the Call_filter_task record with a call_filter_task status of "0: Create task 0", perform the file job task; Generate file data: "Call_filter_send_batch Records" and "Call_filter_send_detail Records" and "Call_filter_send_detail files", The maximum number of pens per batch file is 1000 (configuration can be modified).  STEP3: Send job, Query Call_filter_send_batch record, and determine if "log exists" or "Query task is sent successfully", then execute Send API interface; Generate Logging "Call_filter_send_batch_log" and modify Call_filter_send_batch_Log has a status of "Send_fromflag=0->1 | Send_recvflag=0->1 or-1 " step4: Query Job, query" Call_filter_send_batch_log record ", according to" Send status is send_recvflag=1 and Query_ Fromflag=0 "and then execute the Query API interface; Update logging" Call_filter_send_batch_log "with a status of" query_fromflag=0- >1 | Query_recvflag=0->1 or-1 "; Save the result as" JSON message file and corresponding user's Excel file "and update the result to the status of the phone record" Active phone | Invalid Phone "
after several weekend development, finally development completed as follows:
Part 1: Foreground settings: The data dictionary configures the working status of the "Sieve number task", "batch file", such as:
Part 2: Background services: The system background has three scheduled tasks, every 5 minutes to check the related Task table and log table of the specific status of records, according to conditional matching to schedule the following job in real time:
JOB1: Create Batch Schedule task, JOB2: Send Batch Schedule task, JOB3: Query Batch Schedule Task
Code diagram:
Perform the effect as follows:
JOB1: Create Batch Schedule Task: Real-time processing of "screen number request" from the user's front end (partition field: Creation time is the date of the day),
This generates the relevant "call center Bulk outbound JSON instruction file and the xlsx file for user lookup", and the data and status are first closed according to the progress update.
Log tracking for generating batches:
JOB2: Send Batch Scheduled task: real-time processing from the system background status of "generated" batch file (partition field: the creation time is today's data), and thus read the local file ("Call center batch outgoing JSON instruction file"), save the database query and construction time, And the data and status are closed according to the progress update.
Log tracking for sending batches:
JOB3: Query Batch Schedule Task: Real-time processing from the system background status of "Sent" "Batch file log Data" (Partition field: the creation time is between yesterday and today's data), and thus constructs "call center query Bulk Outbound call result JSON instruction file", and update the data and status according to the progress; Finally, according to the outgoing results, update the "valid status of the phone", and realize the "Function of batch screen number".
Log tracking for query batches:
the meaning of the module:
The implementation of a large number of invalid and expired number of business systems filtering, reducing the business operations of the daily waste of the invalid number of working time, improve the efficiency of the use of the system and staff enthusiasm for work. If you think this article is good or something, you may want to click on the bottom right corner (
recommended)button because your support is the biggest motivation for me to continue writing and sharing!
Business Systems-Call center two development (completed)
