18 var _0x6bc0=['catch','keys','options','find','describe','update','body','uniqueid','params','countContactsQueueCampaignHopperFinal','sequelize','COUNT','literal','noSuchContacts','`state`\x20=\x203,\x201,\x20null','noAnswerContacts','`state`\x20=\x205,\x201,\x20null','`state`\x20=\x208,\x201,\x20null','congestionContacts','`state`\x20=\x2010\x20,\x201,\x20null','dropContacts','`state`\x20=\x2011\x20,\x201,\x20null','abandonedContacts','`state`\x20=\x2022,\x201,\x20null','reCallContacts','`state`\x20=\x2019,\x201,\x20null','countContactsIvrCampaignHopperFinal','`state`\x20=\x200,\x201,\x20null','busyContacts','answeringMachine','moveContactsQueueCampaignHopperFinal','VoiceQueue','insert','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','ListId','VoiceQueueId','createdAt','updatedAt','select','field','ANY_VALUE(calleridnum)','NOW()','ANY_VALUE(VoiceQueueId)','from','cm_hopper_final','VoiceQueueId\x20=\x20?','toString','state\x20=\x20?','state','calleridnum\x20NOT\x20IN\x20(?)','calleridnum','group','moveContactsIvrCampaignHopperFinal','Campaign','CampaignId','ANY_VALUE(ContactId)','ANY_VALUE(ListId)','ANY_VALUE(CampaignId)','CampaignId\x20=\x20?','calleridnum\x20IS\x20NOT\x20NULL','state\x20=\x204','checkContactHopper','CmHopper','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','lodash','squel','crypto','jsforce','querystring','ioredis','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','offset','limit','Content-Range','json','save','then','destroy','error','name','send','index','CmHopperFinal','rawAttributes','fieldName','type','key','model','map','query','filters','attributes','intersection','fields','length','nolimit','order','sort','where','pick','filter','merge','count','includeAll','include','findAll','rows'];(function(_0xbc5837,_0x22bf80){var _0x5425ea=function(_0x3601a6){while(--_0x3601a6){_0xbc5837['push'](_0xbc5837['shift']());}};_0x5425ea(++_0x22bf80);}(_0x6bc0,0xc7));var _0x06bc=function(_0xf6f050,_0xbe50a3){_0xf6f050=_0xf6f050-0x0;var _0x2b0ae6=_0x6bc0[_0xf6f050];return _0x2b0ae6;};'use strict';var pdf=require(_0x06bc('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x06bc('0x1'));var zipdir=require(_0x06bc('0x2'));var jsonpatch=require(_0x06bc('0x3'));var rp=require(_0x06bc('0x4'));var moment=require(_0x06bc('0x5'));var BPromise=require(_0x06bc('0x6'));var Mustache=require(_0x06bc('0x7'));var util=require(_0x06bc('0x8'));var path=require(_0x06bc('0x9'));var sox=require(_0x06bc('0xa'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var _=require(_0x06bc('0xb'));var squel=require(_0x06bc('0xc'));var crypto=require(_0x06bc('0xd'));var jsforce=require(_0x06bc('0xe'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0x06bc('0xf'));var Papa=require('papaparse');var Redis=require(_0x06bc('0x10'));var authService=require('../../components/auth/service');var qs=require(_0x06bc('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x06bc('0x12'));var logger=require(_0x06bc('0x13'))(_0x06bc('0x14'));var utils=require(_0x06bc('0x15'));var config=require(_0x06bc('0x16'));var db=require(_0x06bc('0x17'))['db'];function respondWithStatusCode(_0x3df551,_0x98f531){_0x98f531=_0x98f531||0xcc;return function(_0x3b34ef){if(_0x3b34ef){return _0x3df551[_0x06bc('0x18')](_0x98f531);}return _0x3df551[_0x06bc('0x19')](_0x98f531)[_0x06bc('0x1a')]();};}function respondWithResult(_0x5398a7,_0xfff92a){_0xfff92a=_0xfff92a||0xc8;return function(_0x5d4fe5){if(_0x5d4fe5){return _0x5398a7[_0x06bc('0x19')](_0xfff92a)['json'](_0x5d4fe5);}};}function respondWithFilteredResult(_0x183d68,_0x427d28){return function(_0x1489dc){if(_0x1489dc){var _0x12be9c=_0x1489dc['count'],_0x53428d=_0x427d28[_0x06bc('0x1b')],_0x578487=_0x427d28[_0x06bc('0x1b')]+_0x427d28[_0x06bc('0x1c')],_0x355b5e;if(_0x578487>=_0x12be9c){_0x578487=_0x12be9c;_0x355b5e=0xc8;}else{_0x355b5e=0xce;}_0x183d68['status'](_0x355b5e);return _0x183d68['set'](_0x06bc('0x1d'),_0x53428d+'-'+_0x578487+'/'+_0x12be9c)[_0x06bc('0x1e')](_0x1489dc);}return null;};}function patchUpdates(_0x21ba59){return function(_0x1c2d1a){try{jsonpatch['apply'](_0x1c2d1a,_0x21ba59,!![]);}catch(_0x1420e5){return BPromise['reject'](_0x1420e5);}return _0x1c2d1a[_0x06bc('0x1f')]();};}function saveUpdates(_0x23dbf3,_0x249b0a){return function(_0x21f9fe){if(_0x21f9fe){return _0x21f9fe['update'](_0x23dbf3)[_0x06bc('0x20')](function(_0x78311){return _0x78311;});}return null;};}function removeEntity(_0x25d141,_0x1a5109){return function(_0x13d942){if(_0x13d942){return _0x13d942[_0x06bc('0x21')]()[_0x06bc('0x20')](function(){_0x25d141[_0x06bc('0x19')](0xcc)[_0x06bc('0x1a')]();});}};}function handleEntityNotFound(_0x1315d8,_0x45df01){return function(_0x298fc5){if(!_0x298fc5){_0x1315d8[_0x06bc('0x18')](0x194);}return _0x298fc5;};}function handleError(_0x296004,_0x49036f){_0x49036f=_0x49036f||0x1f4;return function(_0x25054e){logger[_0x06bc('0x22')](_0x25054e['stack']);if(_0x25054e[_0x06bc('0x23')]){delete _0x25054e[_0x06bc('0x23')];}_0x296004[_0x06bc('0x19')](_0x49036f)[_0x06bc('0x24')](_0x25054e);};}exports[_0x06bc('0x25')]=function(_0x2b92be,_0x109e31){var _0x1b8282={},_0x207ab3={},_0x61f3f={'count':0x0,'rows':[]};var _0x1f344f=_['map'](db[_0x06bc('0x26')][_0x06bc('0x27')],function(_0x305c62){return{'name':_0x305c62[_0x06bc('0x28')],'type':_0x305c62[_0x06bc('0x29')][_0x06bc('0x2a')]};});_0x207ab3[_0x06bc('0x2b')]=_[_0x06bc('0x2c')](_0x1f344f,_0x06bc('0x23'));_0x207ab3[_0x06bc('0x2d')]=_['keys'](_0x2b92be['query']);_0x207ab3[_0x06bc('0x2e')]=_['intersection'](_0x207ab3[_0x06bc('0x2b')],_0x207ab3['query']);_0x1b8282[_0x06bc('0x2f')]=_[_0x06bc('0x30')](_0x207ab3[_0x06bc('0x2b')],qs[_0x06bc('0x31')](_0x2b92be['query'][_0x06bc('0x31')]));_0x1b8282[_0x06bc('0x2f')]=_0x1b8282[_0x06bc('0x2f')][_0x06bc('0x32')]?_0x1b8282[_0x06bc('0x2f')]:_0x207ab3['model'];if(!_0x2b92be[_0x06bc('0x2d')]['hasOwnProperty'](_0x06bc('0x33'))){_0x1b8282['limit']=qs[_0x06bc('0x1c')](_0x2b92be[_0x06bc('0x2d')][_0x06bc('0x1c')]);_0x1b8282[_0x06bc('0x1b')]=qs[_0x06bc('0x1b')](_0x2b92be['query']['offset']);}_0x1b8282[_0x06bc('0x34')]=qs[_0x06bc('0x35')](_0x2b92be[_0x06bc('0x2d')][_0x06bc('0x35')]);_0x1b8282[_0x06bc('0x36')]=qs[_0x06bc('0x2e')](_[_0x06bc('0x37')](_0x2b92be[_0x06bc('0x2d')],_0x207ab3['filters']));if(_0x2b92be[_0x06bc('0x2d')][_0x06bc('0x38')]){_0x1b8282[_0x06bc('0x36')]=_[_0x06bc('0x39')](_0x1b8282[_0x06bc('0x36')],{'$or':_['map'](_0x1f344f,function(_0x500021){if(_0x500021[_0x06bc('0x29')]!=='VIRTUAL'){var _0x53f03f={};_0x53f03f[_0x500021[_0x06bc('0x23')]]={'$like':'%'+_0x2b92be[_0x06bc('0x2d')][_0x06bc('0x38')]+'%'};return _0x53f03f;}})});}_0x1b8282=_[_0x06bc('0x39')]({},_0x1b8282,_0x2b92be['options']);var _0x10dce8={'where':_0x1b8282[_0x06bc('0x36')]};return db[_0x06bc('0x26')][_0x06bc('0x3a')](_0x10dce8)['then'](function(_0x482b85){_0x61f3f[_0x06bc('0x3a')]=_0x482b85;if(_0x2b92be[_0x06bc('0x2d')][_0x06bc('0x3b')]){_0x1b8282[_0x06bc('0x3c')]=[{'all':!![]}];}return db['CmHopperFinal'][_0x06bc('0x3d')](_0x1b8282);})[_0x06bc('0x20')](function(_0x2cc415){_0x61f3f[_0x06bc('0x3e')]=_0x2cc415;return _0x61f3f;})[_0x06bc('0x20')](respondWithFilteredResult(_0x109e31,_0x1b8282))[_0x06bc('0x3f')](handleError(_0x109e31,null));};exports['show']=function(_0x1e4728,_0x5c88f6){var _0x302680={'raw':!![],'where':{'id':_0x1e4728['params']['id']}},_0x2fd9b6={};_0x2fd9b6[_0x06bc('0x2b')]=_[_0x06bc('0x40')](db[_0x06bc('0x26')]['rawAttributes']);_0x2fd9b6[_0x06bc('0x2d')]=_[_0x06bc('0x40')](_0x1e4728[_0x06bc('0x2d')]);_0x2fd9b6[_0x06bc('0x2e')]=_[_0x06bc('0x30')](_0x2fd9b6[_0x06bc('0x2b')],_0x2fd9b6['query']);_0x302680['attributes']=_[_0x06bc('0x30')](_0x2fd9b6['model'],qs[_0x06bc('0x31')](_0x1e4728[_0x06bc('0x2d')][_0x06bc('0x31')]));_0x302680[_0x06bc('0x2f')]=_0x302680[_0x06bc('0x2f')][_0x06bc('0x32')]?_0x302680['attributes']:_0x2fd9b6[_0x06bc('0x2b')];if(_0x1e4728['query'][_0x06bc('0x3b')]){_0x302680[_0x06bc('0x3c')]=[{'all':!![]}];}_0x302680=_[_0x06bc('0x39')]({},_0x302680,_0x1e4728[_0x06bc('0x41')]);return db[_0x06bc('0x26')][_0x06bc('0x42')](_0x302680)[_0x06bc('0x20')](handleEntityNotFound(_0x5c88f6,null))[_0x06bc('0x20')](respondWithResult(_0x5c88f6,null))[_0x06bc('0x3f')](handleError(_0x5c88f6,null));};exports[_0x06bc('0x43')]=function(_0xe4300c,_0x4c19a4){return db[_0x06bc('0x26')][_0x06bc('0x43')]()[_0x06bc('0x20')](respondWithResult(_0x4c19a4,null))[_0x06bc('0x3f')](handleError(_0x4c19a4,null));};exports[_0x06bc('0x44')]=function(_0x25d8ba,_0x89c267){if(_0x25d8ba[_0x06bc('0x45')]['uniqueid']){delete _0x25d8ba[_0x06bc('0x45')][_0x06bc('0x46')];}return db['CmHopperFinal']['find']({'where':{'uniqueid':_0x25d8ba[_0x06bc('0x47')]['id']}})[_0x06bc('0x20')](handleEntityNotFound(_0x89c267,null))[_0x06bc('0x20')](saveUpdates(_0x25d8ba[_0x06bc('0x45')],null))[_0x06bc('0x20')](respondWithResult(_0x89c267,null))['catch'](handleError(_0x89c267,null));};exports[_0x06bc('0x48')]=function(_0x297f07,_0x2c1236,_0x5c2c02){return db[_0x06bc('0x26')][_0x06bc('0x3d')]({'raw':![],'where':{'VoiceQueueId':_0x297f07[_0x06bc('0x47')]['id']},'attributes':[[db[_0x06bc('0x49')]['fn'](_0x06bc('0x4a'),db['sequelize']['fn']('IF',db[_0x06bc('0x49')][_0x06bc('0x4b')]('`state`\x20=\x200,\x201,\x20null'))),_0x06bc('0x4c')],[db[_0x06bc('0x49')]['fn'](_0x06bc('0x4a'),db[_0x06bc('0x49')]['fn']('IF',db[_0x06bc('0x49')][_0x06bc('0x4b')](_0x06bc('0x4d')))),_0x06bc('0x4e')],[db['sequelize']['fn'](_0x06bc('0x4a'),db['sequelize']['fn']('IF',db[_0x06bc('0x49')][_0x06bc('0x4b')](_0x06bc('0x4f')))),'busyContacts'],[db[_0x06bc('0x49')]['fn'](_0x06bc('0x4a'),db[_0x06bc('0x49')]['fn']('IF',db[_0x06bc('0x49')][_0x06bc('0x4b')](_0x06bc('0x50')))),_0x06bc('0x51')],[db['sequelize']['fn'](_0x06bc('0x4a'),db[_0x06bc('0x49')]['fn']('IF',db[_0x06bc('0x49')][_0x06bc('0x4b')](_0x06bc('0x52')))),_0x06bc('0x53')],[db['sequelize']['fn'](_0x06bc('0x4a'),db[_0x06bc('0x49')]['fn']('IF',db[_0x06bc('0x49')][_0x06bc('0x4b')](_0x06bc('0x54')))),_0x06bc('0x55')],[db[_0x06bc('0x49')]['fn'](_0x06bc('0x4a'),db[_0x06bc('0x49')]['fn']('IF',db[_0x06bc('0x49')]['literal'](_0x06bc('0x56')))),_0x06bc('0x57')],[db[_0x06bc('0x49')]['fn'](_0x06bc('0x4a'),db[_0x06bc('0x49')]['fn']('IF',db['sequelize'][_0x06bc('0x4b')](_0x06bc('0x58')))),'answeringMachine']]})[_0x06bc('0x20')](handleEntityNotFound(_0x2c1236,null))[_0x06bc('0x20')](respondWithResult(_0x2c1236,null))[_0x06bc('0x3f')](handleError(_0x2c1236,null));};exports[_0x06bc('0x59')]=function(_0x3a6729,_0x2a4706,_0x1c1401){return db[_0x06bc('0x26')][_0x06bc('0x3d')]({'raw':![],'where':{'CampaignId':_0x3a6729[_0x06bc('0x47')]['id']},'attributes':[[db['sequelize']['fn'](_0x06bc('0x4a'),db[_0x06bc('0x49')]['fn']('IF',db[_0x06bc('0x49')][_0x06bc('0x4b')](_0x06bc('0x5a')))),'noSuchContacts'],[db[_0x06bc('0x49')]['fn'](_0x06bc('0x4a'),db[_0x06bc('0x49')]['fn']('IF',db[_0x06bc('0x49')]['literal'](_0x06bc('0x4d')))),_0x06bc('0x4e')],[db[_0x06bc('0x49')]['fn'](_0x06bc('0x4a'),db[_0x06bc('0x49')]['fn']('IF',db['sequelize'][_0x06bc('0x4b')]('`state`\x20=\x205,\x201,\x20null'))),_0x06bc('0x5b')],[db['sequelize']['fn']('COUNT',db[_0x06bc('0x49')]['fn']('IF',db[_0x06bc('0x49')][_0x06bc('0x4b')](_0x06bc('0x50')))),'congestionContacts'],[db[_0x06bc('0x49')]['fn'](_0x06bc('0x4a'),db['sequelize']['fn']('IF',db[_0x06bc('0x49')][_0x06bc('0x4b')](_0x06bc('0x52')))),'dropContacts'],[db[_0x06bc('0x49')]['fn'](_0x06bc('0x4a'),db[_0x06bc('0x49')]['fn']('IF',db[_0x06bc('0x49')][_0x06bc('0x4b')](_0x06bc('0x54')))),_0x06bc('0x55')],[db[_0x06bc('0x49')]['fn']('COUNT',db[_0x06bc('0x49')]['fn']('IF',db[_0x06bc('0x49')]['literal'](_0x06bc('0x56')))),_0x06bc('0x57')],[db[_0x06bc('0x49')]['fn']('COUNT',db['sequelize']['fn']('IF',db['sequelize']['literal'](_0x06bc('0x58')))),_0x06bc('0x5c')]]})[_0x06bc('0x20')](handleEntityNotFound(_0x2a4706,null))['then'](respondWithResult(_0x2a4706,null))[_0x06bc('0x3f')](handleError(_0x2a4706,null));};exports[_0x06bc('0x5d')]=function(_0x29f844,_0x385d92,_0x1b2aef){return db[_0x06bc('0x5e')][_0x06bc('0x42')]({'where':{'id':_0x29f844[_0x06bc('0x47')]['id']}})['then'](handleEntityNotFound(_0x385d92,null))[_0x06bc('0x20')](function(_0x13d00a){var _0x3b0441;if(_0x13d00a){_0x3b0441=squel[_0x06bc('0x5f')]()[_0x06bc('0x60')](_0x06bc('0x61'))[_0x06bc('0x62')]([_0x06bc('0x63'),_0x06bc('0x64'),_0x06bc('0x65'),_0x06bc('0x66'),_0x06bc('0x67'),_0x06bc('0x68'),_0x06bc('0x69')],squel[_0x06bc('0x6a')]()[_0x06bc('0x6b')](_0x06bc('0x6c'),_0x06bc('0x63'))[_0x06bc('0x6b')](_0x06bc('0x6d'),'scheduledAt')[_0x06bc('0x6b')]('ANY_VALUE(ContactId)','ContactId')[_0x06bc('0x6b')]('ANY_VALUE(ListId)',_0x06bc('0x66'))[_0x06bc('0x6b')](_0x06bc('0x6e'),'VoiceQueueId')[_0x06bc('0x6b')]('NOW()',_0x06bc('0x68'))[_0x06bc('0x6b')](_0x06bc('0x6d'),_0x06bc('0x69'))[_0x06bc('0x6f')](_0x06bc('0x70'))['where'](_0x06bc('0x71'),_0x29f844[_0x06bc('0x47')]['id'][_0x06bc('0x72')]())[_0x06bc('0x36')](_0x06bc('0x73'),_0x29f844[_0x06bc('0x45')][_0x06bc('0x74')][_0x06bc('0x72')]())[_0x06bc('0x36')]('calleridnum\x20IS\x20NOT\x20NULL')[_0x06bc('0x36')](_0x06bc('0x75'),squel['select']()[_0x06bc('0x6b')](_0x06bc('0x63'))['from'](_0x06bc('0x61'))['where'](_0x06bc('0x71'),_0x29f844[_0x06bc('0x47')]['id'][_0x06bc('0x72')]()))[_0x06bc('0x36')](_0x06bc('0x75'),squel[_0x06bc('0x6a')]()[_0x06bc('0x6b')](_0x06bc('0x76'))[_0x06bc('0x6f')]('cm_hopper_final')[_0x06bc('0x36')](_0x06bc('0x71'),_0x29f844[_0x06bc('0x47')]['id'][_0x06bc('0x72')]())[_0x06bc('0x36')]('state\x20=\x204'))[_0x06bc('0x77')](_0x06bc('0x65')))[_0x06bc('0x72')]();return db[_0x06bc('0x49')][_0x06bc('0x2d')](_0x3b0441);}return[];})[_0x06bc('0x20')](respondWithResult(_0x385d92,null))[_0x06bc('0x3f')](handleError(_0x385d92,null));};exports[_0x06bc('0x78')]=function(_0x3e70cd,_0x3cf5fc,_0x52f6dd){return db[_0x06bc('0x79')][_0x06bc('0x42')]({'where':{'id':_0x3e70cd['params']['id']}})[_0x06bc('0x20')](handleEntityNotFound(_0x3cf5fc,null))[_0x06bc('0x20')](function(_0x4cf46e){var _0x24707d;if(_0x4cf46e){_0x24707d=squel[_0x06bc('0x5f')]()[_0x06bc('0x60')](_0x06bc('0x61'))[_0x06bc('0x62')](['phone',_0x06bc('0x64'),'ContactId',_0x06bc('0x66'),_0x06bc('0x7a'),_0x06bc('0x68'),'updatedAt'],squel[_0x06bc('0x6a')]()['field'](_0x06bc('0x6c'),_0x06bc('0x63'))[_0x06bc('0x6b')](_0x06bc('0x6d'),'scheduledAt')[_0x06bc('0x6b')](_0x06bc('0x7b'),_0x06bc('0x65'))[_0x06bc('0x6b')](_0x06bc('0x7c'),_0x06bc('0x66'))[_0x06bc('0x6b')](_0x06bc('0x7d'),_0x06bc('0x7a'))[_0x06bc('0x6b')]('NOW()',_0x06bc('0x68'))[_0x06bc('0x6b')]('NOW()',_0x06bc('0x69'))[_0x06bc('0x6f')](_0x06bc('0x70'))['where'](_0x06bc('0x7e'),_0x3e70cd['params']['id'][_0x06bc('0x72')]())[_0x06bc('0x36')](_0x06bc('0x73'),_0x3e70cd[_0x06bc('0x45')][_0x06bc('0x74')][_0x06bc('0x72')]())[_0x06bc('0x36')](_0x06bc('0x7f'))['where'](_0x06bc('0x75'),squel['select']()[_0x06bc('0x6b')](_0x06bc('0x63'))[_0x06bc('0x6f')](_0x06bc('0x61'))[_0x06bc('0x36')](_0x06bc('0x7e'),_0x3e70cd[_0x06bc('0x47')]['id'][_0x06bc('0x72')]()))[_0x06bc('0x36')](_0x06bc('0x75'),squel[_0x06bc('0x6a')]()[_0x06bc('0x6b')](_0x06bc('0x76'))[_0x06bc('0x6f')]('cm_hopper_final')[_0x06bc('0x36')]('CampaignId\x20=\x20?',_0x3e70cd[_0x06bc('0x47')]['id'][_0x06bc('0x72')]())[_0x06bc('0x36')](_0x06bc('0x80')))[_0x06bc('0x77')]('ContactId'))[_0x06bc('0x72')]();return db[_0x06bc('0x49')]['query'](_0x24707d);}return[];})[_0x06bc('0x20')](respondWithResult(_0x3cf5fc,null))[_0x06bc('0x3f')](handleError(_0x3cf5fc,null));};exports[_0x06bc('0x81')]=function(_0x740fa1,_0x779954,_0x5e44e7){return db[_0x06bc('0x82')]['findOne']({'where':{'VoiceQueueId':_0x740fa1[_0x06bc('0x45')][_0x06bc('0x67')],'CampaignId':_0x740fa1['body'][_0x06bc('0x7a')],'ContactId':_0x740fa1[_0x06bc('0x45')]['ContactId']}})[_0x06bc('0x20')](handleEntityNotFound(_0x779954,null))['then'](function(_0x30ba32){if(_0x30ba32){return _0x30ba32;}return null;})[_0x06bc('0x20')](respondWithResult(_0x779954,null))['catch'](handleError(_0x779954,null));};
git://repos.xcallymotion.com / motion2.git / blob