18 var _0xada1=['sequelize','COUNT','literal','`state`\x20=\x200,\x201,\x20null','noSuchContacts','noAnswerContacts','`state`\x20=\x205,\x201,\x20null','busyContacts','`state`\x20=\x208,\x201,\x20null','congestionContacts','`state`\x20=\x2010\x20,\x201,\x20null','dropContacts','`state`\x20=\x2011\x20,\x201,\x20null','`state`\x20=\x2022,\x201,\x20null','abandonedContacts','reCallContacts','`state`\x20=\x2019,\x201,\x20null','answeringMachine','moveContactsQueueCampaignHopperFinal','VoiceQueue','insert','fromQuery','scheduledAt','ContactId','VoiceQueueId','ANY_VALUE(calleridnum)','field','NOW()','ANY_VALUE(ContactId)','ANY_VALUE(ListId)','ListId','ANY_VALUE(VoiceQueueId)','createdAt','updatedAt','from','cm_hopper_final','toString','state\x20=\x20?','state','calleridnum\x20IS\x20NOT\x20NULL','select','phone','cm_hopper','VoiceQueueId\x20=\x20?','calleridnum\x20NOT\x20IN\x20(?)','calleridnum','state\x20=\x204','group','moveContactsIvrCampaignHopperFinal','Campaign','into','ANY_VALUE(CampaignId)','CampaignId','CampaignId\x20=\x20?','checkContactHopper','findOne','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','path','sox','ejs','fs-extra','squel','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../config/license/hardware','api','../../config/utils','../../config/license/util','../../mysqldb','status','end','json','offset','undefined','limit','count','Content-Range','apply','reject','save','then','destroy','sendStatus','error','stack','name','send','index','map','CmHopperFinal','rawAttributes','fieldName','type','model','query','keys','filters','intersection','fields','attributes','length','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','findAll','rows','catch','show','params','include','find','describe','update','body','uniqueid','countContactsQueueCampaignHopperFinal'];(function(_0x1203f,_0x554bbc){var _0x365f0a=function(_0x3531d0){while(--_0x3531d0){_0x1203f['push'](_0x1203f['shift']());}};_0x365f0a(++_0x554bbc);}(_0xada1,0x1c4));var _0x1ada=function(_0x2dadb9,_0x42cfe6){_0x2dadb9=_0x2dadb9-0x0;var _0x2f0097=_0xada1[_0x2dadb9];return _0x2f0097;};'use strict';var emlformat=require(_0x1ada('0x0'));var rimraf=require(_0x1ada('0x1'));var zipdir=require(_0x1ada('0x2'));var jsonpatch=require(_0x1ada('0x3'));var rp=require('request-promise');var moment=require(_0x1ada('0x4'));var BPromise=require(_0x1ada('0x5'));var Mustache=require(_0x1ada('0x6'));var util=require('util');var path=require(_0x1ada('0x7'));var sox=require(_0x1ada('0x8'));var csv=require('to-csv');var ejs=require(_0x1ada('0x9'));var fs=require('fs');var fs_extra=require(_0x1ada('0xa'));var _=require('lodash');var squel=require(_0x1ada('0xb'));var crypto=require('crypto');var jsforce=require(_0x1ada('0xc'));var deskjs=require(_0x1ada('0xd'));var toCsv=require('to-csv');var querystring=require(_0x1ada('0xe'));var Papa=require(_0x1ada('0xf'));var Redis=require('ioredis');var authService=require(_0x1ada('0x10'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x1ada('0x11'));var logger=require('../../config/logger')(_0x1ada('0x12'));var utils=require(_0x1ada('0x13'));var config=require('../../config/environment');var licenseUtil=require(_0x1ada('0x14'));var db=require(_0x1ada('0x15'))['db'];function respondWithStatusCode(_0x365d5e,_0x4aff68){_0x4aff68=_0x4aff68||0xcc;return function(_0x7223df){if(_0x7223df){return _0x365d5e['sendStatus'](_0x4aff68);}return _0x365d5e[_0x1ada('0x16')](_0x4aff68)[_0x1ada('0x17')]();};}function respondWithResult(_0x6652d7,_0x4a0ce6){_0x4a0ce6=_0x4a0ce6||0xc8;return function(_0x2933c2){if(_0x2933c2){return _0x6652d7[_0x1ada('0x16')](_0x4a0ce6)[_0x1ada('0x18')](_0x2933c2);}};}function respondWithFilteredResult(_0x42e946,_0xf672fa){return function(_0x4fdb3f){if(_0x4fdb3f){var _0x5abf7c=typeof _0xf672fa[_0x1ada('0x19')]===_0x1ada('0x1a')&&typeof _0xf672fa[_0x1ada('0x1b')]==='undefined';var _0x2a2532=_0x4fdb3f[_0x1ada('0x1c')];var _0x2a3e1f=_0x5abf7c?0x0:_0xf672fa['offset'];var _0x22e389=_0x5abf7c?_0x4fdb3f[_0x1ada('0x1c')]:_0xf672fa[_0x1ada('0x19')]+_0xf672fa[_0x1ada('0x1b')];var _0x322512;if(_0x22e389>=_0x2a2532){_0x22e389=_0x2a2532;_0x322512=0xc8;}else{_0x322512=0xce;}_0x42e946[_0x1ada('0x16')](_0x322512);return _0x42e946['set'](_0x1ada('0x1d'),_0x2a3e1f+'-'+_0x22e389+'/'+_0x2a2532)['json'](_0x4fdb3f);}return null;};}function patchUpdates(_0xfcf0b7){return function(_0x3d7d40){try{jsonpatch[_0x1ada('0x1e')](_0x3d7d40,_0xfcf0b7,!![]);}catch(_0x5cf1e5){return BPromise[_0x1ada('0x1f')](_0x5cf1e5);}return _0x3d7d40[_0x1ada('0x20')]();};}function saveUpdates(_0x344cc6,_0x3ab50c){return function(_0x120581){if(_0x120581){return _0x120581['update'](_0x344cc6)[_0x1ada('0x21')](function(_0x2910cf){return _0x2910cf;});}return null;};}function removeEntity(_0x2a29bd,_0x2b6b40){return function(_0x547270){if(_0x547270){return _0x547270[_0x1ada('0x22')]()[_0x1ada('0x21')](function(){_0x2a29bd[_0x1ada('0x16')](0xcc)['end']();});}};}function handleEntityNotFound(_0x23877f,_0x28856c){return function(_0x22d374){if(!_0x22d374){_0x23877f[_0x1ada('0x23')](0x194);}return _0x22d374;};}function handleError(_0x1a821c,_0x18d299){_0x18d299=_0x18d299||0x1f4;return function(_0x39d7da){logger[_0x1ada('0x24')](_0x39d7da[_0x1ada('0x25')]);if(_0x39d7da[_0x1ada('0x26')]){delete _0x39d7da[_0x1ada('0x26')];}_0x1a821c['status'](_0x18d299)[_0x1ada('0x27')](_0x39d7da);};}exports[_0x1ada('0x28')]=function(_0x33188b,_0x2984d1){var _0x3bc5f4={},_0x29268b={},_0x505f53={'count':0x0,'rows':[]};var _0x3261cb=_[_0x1ada('0x29')](db[_0x1ada('0x2a')][_0x1ada('0x2b')],function(_0x482b2e){return{'name':_0x482b2e[_0x1ada('0x2c')],'type':_0x482b2e[_0x1ada('0x2d')]['key']};});_0x29268b[_0x1ada('0x2e')]=_['map'](_0x3261cb,_0x1ada('0x26'));_0x29268b[_0x1ada('0x2f')]=_[_0x1ada('0x30')](_0x33188b[_0x1ada('0x2f')]);_0x29268b[_0x1ada('0x31')]=_[_0x1ada('0x32')](_0x29268b[_0x1ada('0x2e')],_0x29268b[_0x1ada('0x2f')]);_0x3bc5f4['attributes']=_['intersection'](_0x29268b[_0x1ada('0x2e')],qs[_0x1ada('0x33')](_0x33188b[_0x1ada('0x2f')][_0x1ada('0x33')]));_0x3bc5f4[_0x1ada('0x34')]=_0x3bc5f4[_0x1ada('0x34')][_0x1ada('0x35')]?_0x3bc5f4[_0x1ada('0x34')]:_0x29268b[_0x1ada('0x2e')];if(!_0x33188b[_0x1ada('0x2f')]['hasOwnProperty'](_0x1ada('0x36'))){_0x3bc5f4[_0x1ada('0x1b')]=qs['limit'](_0x33188b[_0x1ada('0x2f')][_0x1ada('0x1b')]);_0x3bc5f4['offset']=qs[_0x1ada('0x19')](_0x33188b['query']['offset']);}_0x3bc5f4[_0x1ada('0x37')]=qs[_0x1ada('0x38')](_0x33188b[_0x1ada('0x2f')]['sort']);_0x3bc5f4[_0x1ada('0x39')]=qs[_0x1ada('0x31')](_[_0x1ada('0x3a')](_0x33188b['query'],_0x29268b[_0x1ada('0x31')]),_0x3261cb);if(_0x33188b['query'][_0x1ada('0x3b')]){_0x3bc5f4['where']=_[_0x1ada('0x3c')](_0x3bc5f4[_0x1ada('0x39')],{'$or':_[_0x1ada('0x29')](_0x3261cb,function(_0x2df976){if(_0x2df976[_0x1ada('0x2d')]!==_0x1ada('0x3d')){var _0x41e89a={};_0x41e89a[_0x2df976[_0x1ada('0x26')]]={'$like':'%'+_0x33188b[_0x1ada('0x2f')][_0x1ada('0x3b')]+'%'};return _0x41e89a;}})});}_0x3bc5f4=_[_0x1ada('0x3c')]({},_0x3bc5f4,_0x33188b[_0x1ada('0x3e')]);var _0x1c364c={'where':_0x3bc5f4['where']};return db[_0x1ada('0x2a')][_0x1ada('0x1c')](_0x1c364c)[_0x1ada('0x21')](function(_0x2fe5a3){_0x505f53[_0x1ada('0x1c')]=_0x2fe5a3;if(_0x33188b[_0x1ada('0x2f')][_0x1ada('0x3f')]){_0x3bc5f4['include']=[{'all':!![]}];}return db[_0x1ada('0x2a')][_0x1ada('0x40')](_0x3bc5f4);})[_0x1ada('0x21')](function(_0x5aca52){_0x505f53[_0x1ada('0x41')]=_0x5aca52;return _0x505f53;})[_0x1ada('0x21')](respondWithFilteredResult(_0x2984d1,_0x3bc5f4))[_0x1ada('0x42')](handleError(_0x2984d1,null));};exports[_0x1ada('0x43')]=function(_0x19d459,_0x4e2aa7){var _0x38285a={'raw':!![],'where':{'id':_0x19d459[_0x1ada('0x44')]['id']}},_0x32d19f={};_0x32d19f[_0x1ada('0x2e')]=_['keys'](db[_0x1ada('0x2a')][_0x1ada('0x2b')]);_0x32d19f[_0x1ada('0x2f')]=_[_0x1ada('0x30')](_0x19d459['query']);_0x32d19f[_0x1ada('0x31')]=_['intersection'](_0x32d19f[_0x1ada('0x2e')],_0x32d19f[_0x1ada('0x2f')]);_0x38285a['attributes']=_[_0x1ada('0x32')](_0x32d19f['model'],qs['fields'](_0x19d459[_0x1ada('0x2f')]['fields']));_0x38285a[_0x1ada('0x34')]=_0x38285a[_0x1ada('0x34')]['length']?_0x38285a[_0x1ada('0x34')]:_0x32d19f['model'];if(_0x19d459['query'][_0x1ada('0x3f')]){_0x38285a[_0x1ada('0x45')]=[{'all':!![]}];}_0x38285a=_['merge']({},_0x38285a,_0x19d459['options']);return db[_0x1ada('0x2a')][_0x1ada('0x46')](_0x38285a)[_0x1ada('0x21')](handleEntityNotFound(_0x4e2aa7,null))[_0x1ada('0x21')](respondWithResult(_0x4e2aa7,null))[_0x1ada('0x42')](handleError(_0x4e2aa7,null));};exports[_0x1ada('0x47')]=function(_0x317e42,_0xae099){return db[_0x1ada('0x2a')][_0x1ada('0x47')]()[_0x1ada('0x21')](respondWithResult(_0xae099,null))[_0x1ada('0x42')](handleError(_0xae099,null));};exports[_0x1ada('0x48')]=function(_0x49352f,_0x2aeee4){if(_0x49352f[_0x1ada('0x49')][_0x1ada('0x4a')]){delete _0x49352f[_0x1ada('0x49')]['uniqueid'];}return db['CmHopperFinal'][_0x1ada('0x46')]({'where':{'uniqueid':_0x49352f[_0x1ada('0x44')]['id']}})['then'](handleEntityNotFound(_0x2aeee4,null))['then'](saveUpdates(_0x49352f[_0x1ada('0x49')],null))[_0x1ada('0x21')](respondWithResult(_0x2aeee4,null))[_0x1ada('0x42')](handleError(_0x2aeee4,null));};exports[_0x1ada('0x4b')]=function(_0x1324b1,_0xa7a1b6,_0x5cd1a1){return db[_0x1ada('0x2a')][_0x1ada('0x40')]({'raw':![],'where':{'VoiceQueueId':_0x1324b1[_0x1ada('0x44')]['id']},'attributes':[[db[_0x1ada('0x4c')]['fn'](_0x1ada('0x4d'),db['sequelize']['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x4f')))),_0x1ada('0x50')],[db[_0x1ada('0x4c')]['fn'](_0x1ada('0x4d'),db[_0x1ada('0x4c')]['fn']('IF',db['sequelize'][_0x1ada('0x4e')]('`state`\x20=\x203,\x201,\x20null'))),_0x1ada('0x51')],[db['sequelize']['fn'](_0x1ada('0x4d'),db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x52')))),_0x1ada('0x53')],[db[_0x1ada('0x4c')]['fn'](_0x1ada('0x4d'),db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x54')))),_0x1ada('0x55')],[db[_0x1ada('0x4c')]['fn']('COUNT',db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x56')))),_0x1ada('0x57')],[db[_0x1ada('0x4c')]['fn']('COUNT',db[_0x1ada('0x4c')]['fn']('IF',db['sequelize'][_0x1ada('0x4e')](_0x1ada('0x58')))),'abandonedContacts'],[db[_0x1ada('0x4c')]['fn'](_0x1ada('0x4d'),db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x59')))),'reCallContacts'],[db[_0x1ada('0x4c')]['fn'](_0x1ada('0x4d'),db['sequelize']['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')]('`state`\x20=\x2019,\x201,\x20null'))),'answeringMachine']]})[_0x1ada('0x21')](handleEntityNotFound(_0xa7a1b6,null))['then'](respondWithResult(_0xa7a1b6,null))[_0x1ada('0x42')](handleError(_0xa7a1b6,null));};exports['countContactsIvrCampaignHopperFinal']=function(_0x31ba82,_0x52ad01,_0x3be9f4){return db['CmHopperFinal']['findAll']({'raw':![],'where':{'CampaignId':_0x31ba82[_0x1ada('0x44')]['id']},'attributes':[[db[_0x1ada('0x4c')]['fn'](_0x1ada('0x4d'),db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')]['literal'](_0x1ada('0x4f')))),_0x1ada('0x50')],[db[_0x1ada('0x4c')]['fn']('COUNT',db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')]('`state`\x20=\x203,\x201,\x20null'))),_0x1ada('0x51')],[db[_0x1ada('0x4c')]['fn']('COUNT',db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')]['literal'](_0x1ada('0x52')))),_0x1ada('0x53')],[db[_0x1ada('0x4c')]['fn'](_0x1ada('0x4d'),db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x54')))),'congestionContacts'],[db['sequelize']['fn'](_0x1ada('0x4d'),db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x56')))),_0x1ada('0x57')],[db['sequelize']['fn']('COUNT',db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x58')))),_0x1ada('0x5a')],[db[_0x1ada('0x4c')]['fn']('COUNT',db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x59')))),_0x1ada('0x5b')],[db[_0x1ada('0x4c')]['fn'](_0x1ada('0x4d'),db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x5c')))),_0x1ada('0x5d')]]})[_0x1ada('0x21')](handleEntityNotFound(_0x52ad01,null))[_0x1ada('0x21')](respondWithResult(_0x52ad01,null))['catch'](handleError(_0x52ad01,null));};exports[_0x1ada('0x5e')]=function(_0x5e063b,_0x4a4369,_0x3b5b6b){return db[_0x1ada('0x5f')][_0x1ada('0x46')]({'where':{'id':_0x5e063b[_0x1ada('0x44')]['id']}})[_0x1ada('0x21')](handleEntityNotFound(_0x4a4369,null))[_0x1ada('0x21')](function(_0x34f099){var _0x8ffaec;if(_0x34f099){_0x8ffaec=squel[_0x1ada('0x60')]()['into']('cm_hopper')[_0x1ada('0x61')](['phone',_0x1ada('0x62'),_0x1ada('0x63'),'ListId',_0x1ada('0x64'),'createdAt','updatedAt'],squel['select']()['field'](_0x1ada('0x65'),'phone')[_0x1ada('0x66')](_0x1ada('0x67'),_0x1ada('0x62'))[_0x1ada('0x66')](_0x1ada('0x68'),_0x1ada('0x63'))[_0x1ada('0x66')](_0x1ada('0x69'),_0x1ada('0x6a'))['field'](_0x1ada('0x6b'),_0x1ada('0x64'))[_0x1ada('0x66')](_0x1ada('0x67'),_0x1ada('0x6c'))[_0x1ada('0x66')](_0x1ada('0x67'),_0x1ada('0x6d'))[_0x1ada('0x6e')](_0x1ada('0x6f'))[_0x1ada('0x39')]('VoiceQueueId\x20=\x20?',_0x5e063b['params']['id'][_0x1ada('0x70')]())[_0x1ada('0x39')](_0x1ada('0x71'),_0x5e063b[_0x1ada('0x49')][_0x1ada('0x72')]['toString']())[_0x1ada('0x39')](_0x1ada('0x73'))[_0x1ada('0x39')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0x1ada('0x74')]()[_0x1ada('0x66')](_0x1ada('0x75'))[_0x1ada('0x6e')](_0x1ada('0x76'))['where'](_0x1ada('0x77'),_0x5e063b[_0x1ada('0x44')]['id'][_0x1ada('0x70')]()))['where'](_0x1ada('0x78'),squel['select']()[_0x1ada('0x66')](_0x1ada('0x79'))[_0x1ada('0x6e')](_0x1ada('0x6f'))[_0x1ada('0x39')]('VoiceQueueId\x20=\x20?',_0x5e063b[_0x1ada('0x44')]['id'][_0x1ada('0x70')]())[_0x1ada('0x39')](_0x1ada('0x7a')))[_0x1ada('0x7b')](_0x1ada('0x63')))['toString']();return db[_0x1ada('0x4c')]['query'](_0x8ffaec);}return[];})[_0x1ada('0x21')](respondWithResult(_0x4a4369,null))[_0x1ada('0x42')](handleError(_0x4a4369,null));};exports[_0x1ada('0x7c')]=function(_0x14611c,_0x36363e,_0x28326d){return db[_0x1ada('0x7d')][_0x1ada('0x46')]({'where':{'id':_0x14611c[_0x1ada('0x44')]['id']}})['then'](handleEntityNotFound(_0x36363e,null))['then'](function(_0x59214f){var _0x5bad0b;if(_0x59214f){_0x5bad0b=squel[_0x1ada('0x60')]()[_0x1ada('0x7e')](_0x1ada('0x76'))[_0x1ada('0x61')]([_0x1ada('0x75'),'scheduledAt',_0x1ada('0x63'),'ListId','CampaignId',_0x1ada('0x6c'),_0x1ada('0x6d')],squel[_0x1ada('0x74')]()['field'](_0x1ada('0x65'),_0x1ada('0x75'))[_0x1ada('0x66')](_0x1ada('0x67'),_0x1ada('0x62'))[_0x1ada('0x66')]('ANY_VALUE(ContactId)','ContactId')['field'](_0x1ada('0x69'),'ListId')[_0x1ada('0x66')](_0x1ada('0x7f'),_0x1ada('0x80'))['field'](_0x1ada('0x67'),_0x1ada('0x6c'))[_0x1ada('0x66')]('NOW()',_0x1ada('0x6d'))['from']('cm_hopper_final')['where'](_0x1ada('0x81'),_0x14611c[_0x1ada('0x44')]['id'][_0x1ada('0x70')]())[_0x1ada('0x39')](_0x1ada('0x71'),_0x14611c[_0x1ada('0x49')][_0x1ada('0x72')][_0x1ada('0x70')]())['where'](_0x1ada('0x73'))['where'](_0x1ada('0x78'),squel['select']()[_0x1ada('0x66')](_0x1ada('0x75'))['from']('cm_hopper')[_0x1ada('0x39')]('CampaignId\x20=\x20?',_0x14611c[_0x1ada('0x44')]['id'][_0x1ada('0x70')]()))['where'](_0x1ada('0x78'),squel['select']()[_0x1ada('0x66')](_0x1ada('0x79'))[_0x1ada('0x6e')](_0x1ada('0x6f'))[_0x1ada('0x39')](_0x1ada('0x81'),_0x14611c[_0x1ada('0x44')]['id'][_0x1ada('0x70')]())[_0x1ada('0x39')](_0x1ada('0x7a')))['group'](_0x1ada('0x63')))[_0x1ada('0x70')]();return db[_0x1ada('0x4c')]['query'](_0x5bad0b);}return[];})[_0x1ada('0x21')](respondWithResult(_0x36363e,null))['catch'](handleError(_0x36363e,null));};exports[_0x1ada('0x82')]=function(_0x36a957,_0x183650,_0x49da38){return db['CmHopper'][_0x1ada('0x83')]({'where':{'VoiceQueueId':_0x36a957[_0x1ada('0x49')][_0x1ada('0x64')],'CampaignId':_0x36a957[_0x1ada('0x49')][_0x1ada('0x80')],'ContactId':_0x36a957[_0x1ada('0x49')][_0x1ada('0x63')]}})['then'](handleEntityNotFound(_0x183650,null))[_0x1ada('0x21')](function(_0xfe073e){if(_0xfe073e){return _0xfe073e;}return null;})[_0x1ada('0x21')](respondWithResult(_0x183650,null))[_0x1ada('0x42')](handleError(_0x183650,null));};
git://repos.xcallymotion.com / motion2.git / blob