SELECT * FROM voice_compaign_summary WHERE compaign_id='38760' LIMIT 1
before elastic get data
12-May-2025 12:56:21 pm
after elastic get data
12-May-2025 12:56:21 pm
before elastic new get data
12-May-2025 12:56:21 pmloop : 0
total records 32
process records 32below is user whitelist data
Array
(
[9772000088] => 9772000088
[9251000170] => 9251000170
[9214001400] => 9214001400
[9251001304] => 9251001304
[9251003340] => 9251003340
[9251003342] => 9251003342
[9251005002] => 9251005002
[9251006002] => 9251006002
[9251006003] => 9251006003
[9251002637] => 9251002637
[9251003343] => 9251003343
[9251003385] => 9251003385
[9251004006] => 9251004006
[9251004843] => 9251004843
[9251006126] => 9251006126
[9251000418] => 9251000418
[9251001302] => 9251001302
[9251003341] => 9251003341
[9251003381] => 9251003381
[9251003383] => 9251003383
[9251003384] => 9251003384
[9251003386] => 9251003386
[9251008146] => 9251008146
[9251008149] => 9251008149
[9251008156] => 9251008156
[9251008161] => 9251008161
[9251008162] => 9251008162
[9251008150] => 9251008150
[9251008164] => 9251008164
[8804040008] => 8804040008
[7037321216] => 7037321216
[8449641744] => 8449641744
)
after elastic new get data
after elastic get data
12-May-2025 12:56:22 pmCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"140"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 140
)
)
gateway_id_arrs
Array
(
[0] => 140
)
before elastic get data
12-May-2025 12:56:22 pm
after elastic get data
12-May-2025 12:56:22 pm
before elastic get data
12-May-2025 12:56:22 pm
after elastic get data
12-May-2025 12:56:22 pm
before elastic get data
12-May-2025 12:56:22 pm
after elastic get data
12-May-2025 12:56:22 pm
SELECT * FROM `contacts_temp_group_36016` where group_id in(36016) group by mobile_number order by contact_id LIMIT 0,3
DND FILTERING YES
mobile no is dnd8449641744
mobile no is dnd7037321216
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38760` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38760','8804040008', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
12-May-2025 12:56:22 pm
after INSERT DETAIL
12-May-2025 12:56:22 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38760` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38760','7037321216', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
12-May-2025 12:56:22 pm
after INSERT DETAIL
12-May-2025 12:56:22 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38760` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38760','8449641744', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
12-May-2025 12:56:22 pm
after INSERT DETAIL
12-May-2025 12:56:22 pm
before UPDATE SUMMARY
12-May-2025 12:56:22 pm
after before UPDATE SUMMARY
12-May-2025 12:56:22 pm
contact in sec 0
sepration in sec 0
settings in sec 0
whitelist in sec 0
dnd status in sec
elastic dnd get data in sec 0
blacklis in sec 0
whitelist get data sec 1
whitelist get data mic sec 0.76370787620544
blacklist in micro sec 0.001978874206543