// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x41bb=['VIRTUAL','options','catch','show','rawAttributes','includeAll','describe','body','uniqueid','find','params','countContactsQueueCampaignHopperFinal','findAll','COUNT','sequelize','literal','`state`\x20=\x200,\x201,\x20null','noSuchContacts','`state`\x20=\x203,\x201,\x20null','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','abandonedContacts','`state`\x20=\x2022,\x201,\x20null','`state`\x20=\x2019,\x201,\x20null','answeringMachine','countContactsIvrCampaignHopperFinal','reCallContacts','moveContactsQueueCampaignHopperFinal','VoiceQueue','insert','into','cm_hopper','scheduledAt','ContactId','ListId','VoiceQueueId','createdAt','updatedAt','select','phone','field','ANY_VALUE(ContactId)','ANY_VALUE(ListId)','NOW()','VoiceQueueId\x20=\x20?','toString','state\x20=\x20?','state','calleridnum\x20IS\x20NOT\x20NULL','calleridnum\x20NOT\x20IN\x20(?)','from','calleridnum','cm_hopper_final','state\x20=\x204','group','moveContactsIvrCampaignHopperFinal','Campaign','fromQuery','ANY_VALUE(calleridnum)','CampaignId\x20=\x20?','checkContactHopper','CmHopper','findOne','CampaignId','html-pdf','eml-format','zip-dir','request-promise','moment','bluebird','mustache','path','sox','to-csv','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','count','offset','limit','apply','reject','update','then','destroy','stack','name','send','map','CmHopperFinal','fieldName','key','keys','filters','intersection','query','attributes','model','fields','length','nolimit','order','sort','where','pick','merge','type'];(function(_0x4ea728,_0x3ba8a8){var _0x290764=function(_0x35f0e0){while(--_0x35f0e0){_0x4ea728['push'](_0x4ea728['shift']());}};_0x290764(++_0x3ba8a8);}(_0x41bb,0xc5));var _0xb41b=function(_0x1a6da5,_0x350982){_0x1a6da5=_0x1a6da5-0x0;var _0xc79889=_0x41bb[_0x1a6da5];return _0xc79889;};'use strict';var pdf=require(_0xb41b('0x0'));var emlformat=require(_0xb41b('0x1'));var rimraf=require('rimraf');var zipdir=require(_0xb41b('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xb41b('0x3'));var moment=require(_0xb41b('0x4'));var BPromise=require(_0xb41b('0x5'));var Mustache=require(_0xb41b('0x6'));var util=require('util');var path=require(_0xb41b('0x7'));var sox=require(_0xb41b('0x8'));var csv=require(_0xb41b('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require('lodash');var squel=require('squel');var crypto=require(_0xb41b('0xa'));var jsforce=require(_0xb41b('0xb'));var deskjs=require('desk.js');var toCsv=require(_0xb41b('0x9'));var querystring=require(_0xb41b('0xc'));var Papa=require(_0xb41b('0xd'));var Redis=require(_0xb41b('0xe'));var authService=require(_0xb41b('0xf'));var qs=require(_0xb41b('0x10'));var as=require(_0xb41b('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xb41b('0x12'))('api');var utils=require(_0xb41b('0x13'));var config=require(_0xb41b('0x14'));var licenseUtil=require(_0xb41b('0x15'));var db=require(_0xb41b('0x16'))['db'];function respondWithStatusCode(_0x2066d5,_0x5f1ea4){_0x5f1ea4=_0x5f1ea4||0xcc;return function(_0x353ba3){if(_0x353ba3){return _0x2066d5[_0xb41b('0x17')](_0x5f1ea4);}return _0x2066d5[_0xb41b('0x18')](_0x5f1ea4)[_0xb41b('0x19')]();};}function respondWithResult(_0x3be1ec,_0x4e8603){_0x4e8603=_0x4e8603||0xc8;return function(_0x4e7f11){if(_0x4e7f11){return _0x3be1ec['status'](_0x4e8603)[_0xb41b('0x1a')](_0x4e7f11);}};}function respondWithFilteredResult(_0xdc5fb0,_0x143a81){return function(_0x338920){if(_0x338920){var _0x29ea51=_0x338920[_0xb41b('0x1b')],_0x54591e=_0x143a81[_0xb41b('0x1c')],_0x2f3673=_0x143a81[_0xb41b('0x1c')]+_0x143a81[_0xb41b('0x1d')],_0xd0b6b5;if(_0x2f3673>=_0x29ea51){_0x2f3673=_0x29ea51;_0xd0b6b5=0xc8;}else{_0xd0b6b5=0xce;}_0xdc5fb0[_0xb41b('0x18')](_0xd0b6b5);return _0xdc5fb0['set']('Content-Range',_0x54591e+'-'+_0x2f3673+'/'+_0x29ea51)['json'](_0x338920);}return null;};}function patchUpdates(_0xf109f8){return function(_0x503e86){try{jsonpatch[_0xb41b('0x1e')](_0x503e86,_0xf109f8,!![]);}catch(_0x1de9ea){return BPromise[_0xb41b('0x1f')](_0x1de9ea);}return _0x503e86['save']();};}function saveUpdates(_0x53bc44,_0x1a1386){return function(_0x3b6ffb){if(_0x3b6ffb){return _0x3b6ffb[_0xb41b('0x20')](_0x53bc44)[_0xb41b('0x21')](function(_0x232ff1){return _0x232ff1;});}return null;};}function removeEntity(_0x42dccb,_0x4c73da){return function(_0x58f149){if(_0x58f149){return _0x58f149[_0xb41b('0x22')]()[_0xb41b('0x21')](function(){_0x42dccb[_0xb41b('0x18')](0xcc)['end']();});}};}function handleEntityNotFound(_0x14e9c8,_0x2441d6){return function(_0x546101){if(!_0x546101){_0x14e9c8[_0xb41b('0x17')](0x194);}return _0x546101;};}function handleError(_0x34f908,_0x5253ed){_0x5253ed=_0x5253ed||0x1f4;return function(_0xed3c7e){logger['error'](_0xed3c7e[_0xb41b('0x23')]);if(_0xed3c7e[_0xb41b('0x24')]){delete _0xed3c7e['name'];}_0x34f908[_0xb41b('0x18')](_0x5253ed)[_0xb41b('0x25')](_0xed3c7e);};}exports['index']=function(_0x4c2e41,_0x2a5286){var _0x46aecf={},_0x6b98aa={},_0x36dda8={'count':0x0,'rows':[]};var _0x2c7e1f=_[_0xb41b('0x26')](db[_0xb41b('0x27')]['rawAttributes'],function(_0x26ef96){return{'name':_0x26ef96[_0xb41b('0x28')],'type':_0x26ef96['type'][_0xb41b('0x29')]};});_0x6b98aa['model']=_[_0xb41b('0x26')](_0x2c7e1f,_0xb41b('0x24'));_0x6b98aa['query']=_[_0xb41b('0x2a')](_0x4c2e41['query']);_0x6b98aa[_0xb41b('0x2b')]=_[_0xb41b('0x2c')](_0x6b98aa['model'],_0x6b98aa[_0xb41b('0x2d')]);_0x46aecf[_0xb41b('0x2e')]=_[_0xb41b('0x2c')](_0x6b98aa[_0xb41b('0x2f')],qs[_0xb41b('0x30')](_0x4c2e41[_0xb41b('0x2d')][_0xb41b('0x30')]));_0x46aecf[_0xb41b('0x2e')]=_0x46aecf[_0xb41b('0x2e')][_0xb41b('0x31')]?_0x46aecf['attributes']:_0x6b98aa[_0xb41b('0x2f')];if(!_0x4c2e41['query']['hasOwnProperty'](_0xb41b('0x32'))){_0x46aecf[_0xb41b('0x1d')]=qs[_0xb41b('0x1d')](_0x4c2e41[_0xb41b('0x2d')][_0xb41b('0x1d')]);_0x46aecf[_0xb41b('0x1c')]=qs[_0xb41b('0x1c')](_0x4c2e41[_0xb41b('0x2d')][_0xb41b('0x1c')]);}_0x46aecf[_0xb41b('0x33')]=qs[_0xb41b('0x34')](_0x4c2e41['query'][_0xb41b('0x34')]);_0x46aecf[_0xb41b('0x35')]=qs[_0xb41b('0x2b')](_[_0xb41b('0x36')](_0x4c2e41[_0xb41b('0x2d')],_0x6b98aa[_0xb41b('0x2b')]),_0x2c7e1f);if(_0x4c2e41['query']['filter']){_0x46aecf[_0xb41b('0x35')]=_[_0xb41b('0x37')](_0x46aecf['where'],{'$or':_[_0xb41b('0x26')](_0x2c7e1f,function(_0x47363e){if(_0x47363e[_0xb41b('0x38')]!==_0xb41b('0x39')){var _0x3a3b3b={};_0x3a3b3b[_0x47363e['name']]={'$like':'%'+_0x4c2e41[_0xb41b('0x2d')]['filter']+'%'};return _0x3a3b3b;}})});}_0x46aecf=_[_0xb41b('0x37')]({},_0x46aecf,_0x4c2e41[_0xb41b('0x3a')]);var _0x799d6={'where':_0x46aecf[_0xb41b('0x35')]};return db[_0xb41b('0x27')][_0xb41b('0x1b')](_0x799d6)[_0xb41b('0x21')](function(_0x321f1b){_0x36dda8[_0xb41b('0x1b')]=_0x321f1b;if(_0x4c2e41['query']['includeAll']){_0x46aecf['include']=[{'all':!![]}];}return db[_0xb41b('0x27')]['findAll'](_0x46aecf);})['then'](function(_0x781302){_0x36dda8['rows']=_0x781302;return _0x36dda8;})[_0xb41b('0x21')](respondWithFilteredResult(_0x2a5286,_0x46aecf))[_0xb41b('0x3b')](handleError(_0x2a5286,null));};exports[_0xb41b('0x3c')]=function(_0x249ffc,_0x4fa390){var _0x25c5b7={'raw':!![],'where':{'id':_0x249ffc['params']['id']}},_0xddb59c={};_0xddb59c[_0xb41b('0x2f')]=_[_0xb41b('0x2a')](db[_0xb41b('0x27')][_0xb41b('0x3d')]);_0xddb59c['query']=_[_0xb41b('0x2a')](_0x249ffc['query']);_0xddb59c[_0xb41b('0x2b')]=_[_0xb41b('0x2c')](_0xddb59c[_0xb41b('0x2f')],_0xddb59c['query']);_0x25c5b7['attributes']=_[_0xb41b('0x2c')](_0xddb59c[_0xb41b('0x2f')],qs[_0xb41b('0x30')](_0x249ffc[_0xb41b('0x2d')][_0xb41b('0x30')]));_0x25c5b7[_0xb41b('0x2e')]=_0x25c5b7[_0xb41b('0x2e')]['length']?_0x25c5b7['attributes']:_0xddb59c[_0xb41b('0x2f')];if(_0x249ffc['query'][_0xb41b('0x3e')]){_0x25c5b7['include']=[{'all':!![]}];}_0x25c5b7=_[_0xb41b('0x37')]({},_0x25c5b7,_0x249ffc['options']);return db[_0xb41b('0x27')]['find'](_0x25c5b7)[_0xb41b('0x21')](handleEntityNotFound(_0x4fa390,null))[_0xb41b('0x21')](respondWithResult(_0x4fa390,null))[_0xb41b('0x3b')](handleError(_0x4fa390,null));};exports[_0xb41b('0x3f')]=function(_0x54454f,_0x2f8442){return db[_0xb41b('0x27')]['describe']()[_0xb41b('0x21')](respondWithResult(_0x2f8442,null))['catch'](handleError(_0x2f8442,null));};exports['update']=function(_0x5733d0,_0x5bea5e){if(_0x5733d0[_0xb41b('0x40')][_0xb41b('0x41')]){delete _0x5733d0[_0xb41b('0x40')][_0xb41b('0x41')];}return db[_0xb41b('0x27')][_0xb41b('0x42')]({'where':{'uniqueid':_0x5733d0[_0xb41b('0x43')]['id']}})[_0xb41b('0x21')](handleEntityNotFound(_0x5bea5e,null))[_0xb41b('0x21')](saveUpdates(_0x5733d0[_0xb41b('0x40')],null))[_0xb41b('0x21')](respondWithResult(_0x5bea5e,null))[_0xb41b('0x3b')](handleError(_0x5bea5e,null));};exports[_0xb41b('0x44')]=function(_0x360856,_0x1b1f81,_0x19893d){return db['CmHopperFinal'][_0xb41b('0x45')]({'raw':![],'where':{'VoiceQueueId':_0x360856['params']['id']},'attributes':[[db['sequelize']['fn'](_0xb41b('0x46'),db[_0xb41b('0x47')]['fn']('IF',db[_0xb41b('0x47')][_0xb41b('0x48')](_0xb41b('0x49')))),_0xb41b('0x4a')],[db[_0xb41b('0x47')]['fn'](_0xb41b('0x46'),db[_0xb41b('0x47')]['fn']('IF',db[_0xb41b('0x47')][_0xb41b('0x48')](_0xb41b('0x4b')))),_0xb41b('0x4c')],[db[_0xb41b('0x47')]['fn'](_0xb41b('0x46'),db[_0xb41b('0x47')]['fn']('IF',db[_0xb41b('0x47')][_0xb41b('0x48')](_0xb41b('0x4d')))),_0xb41b('0x4e')],[db[_0xb41b('0x47')]['fn']('COUNT',db[_0xb41b('0x47')]['fn']('IF',db['sequelize'][_0xb41b('0x48')](_0xb41b('0x4f')))),_0xb41b('0x50')],[db[_0xb41b('0x47')]['fn'](_0xb41b('0x46'),db[_0xb41b('0x47')]['fn']('IF',db[_0xb41b('0x47')]['literal'](_0xb41b('0x51')))),_0xb41b('0x52')],[db[_0xb41b('0x47')]['fn']('COUNT',db[_0xb41b('0x47')]['fn']('IF',db[_0xb41b('0x47')][_0xb41b('0x48')](_0xb41b('0x53')))),_0xb41b('0x54')],[db[_0xb41b('0x47')]['fn'](_0xb41b('0x46'),db['sequelize']['fn']('IF',db['sequelize'][_0xb41b('0x48')](_0xb41b('0x55')))),'reCallContacts'],[db[_0xb41b('0x47')]['fn'](_0xb41b('0x46'),db['sequelize']['fn']('IF',db[_0xb41b('0x47')][_0xb41b('0x48')](_0xb41b('0x56')))),_0xb41b('0x57')]]})[_0xb41b('0x21')](handleEntityNotFound(_0x1b1f81,null))[_0xb41b('0x21')](respondWithResult(_0x1b1f81,null))[_0xb41b('0x3b')](handleError(_0x1b1f81,null));};exports[_0xb41b('0x58')]=function(_0x182b8a,_0x331e98,_0x5c5e0d){return db[_0xb41b('0x27')][_0xb41b('0x45')]({'raw':![],'where':{'CampaignId':_0x182b8a['params']['id']},'attributes':[[db['sequelize']['fn'](_0xb41b('0x46'),db[_0xb41b('0x47')]['fn']('IF',db[_0xb41b('0x47')]['literal'](_0xb41b('0x49')))),_0xb41b('0x4a')],[db[_0xb41b('0x47')]['fn'](_0xb41b('0x46'),db[_0xb41b('0x47')]['fn']('IF',db[_0xb41b('0x47')][_0xb41b('0x48')](_0xb41b('0x4b')))),_0xb41b('0x4c')],[db[_0xb41b('0x47')]['fn']('COUNT',db[_0xb41b('0x47')]['fn']('IF',db[_0xb41b('0x47')]['literal'](_0xb41b('0x4d')))),_0xb41b('0x4e')],[db[_0xb41b('0x47')]['fn']('COUNT',db[_0xb41b('0x47')]['fn']('IF',db[_0xb41b('0x47')][_0xb41b('0x48')](_0xb41b('0x4f')))),_0xb41b('0x50')],[db[_0xb41b('0x47')]['fn'](_0xb41b('0x46'),db[_0xb41b('0x47')]['fn']('IF',db[_0xb41b('0x47')][_0xb41b('0x48')]('`state`\x20=\x2010\x20,\x201,\x20null'))),'dropContacts'],[db['sequelize']['fn']('COUNT',db[_0xb41b('0x47')]['fn']('IF',db[_0xb41b('0x47')][_0xb41b('0x48')](_0xb41b('0x53')))),_0xb41b('0x54')],[db[_0xb41b('0x47')]['fn']('COUNT',db[_0xb41b('0x47')]['fn']('IF',db['sequelize'][_0xb41b('0x48')]('`state`\x20=\x2022,\x201,\x20null'))),_0xb41b('0x59')],[db['sequelize']['fn'](_0xb41b('0x46'),db[_0xb41b('0x47')]['fn']('IF',db['sequelize'][_0xb41b('0x48')](_0xb41b('0x56')))),_0xb41b('0x57')]]})[_0xb41b('0x21')](handleEntityNotFound(_0x331e98,null))[_0xb41b('0x21')](respondWithResult(_0x331e98,null))[_0xb41b('0x3b')](handleError(_0x331e98,null));};exports[_0xb41b('0x5a')]=function(_0x523c72,_0xf3c1bb,_0x5b4d87){return db[_0xb41b('0x5b')][_0xb41b('0x42')]({'where':{'id':_0x523c72[_0xb41b('0x43')]['id']}})['then'](handleEntityNotFound(_0xf3c1bb,null))['then'](function(_0x4d8c97){var _0x571e41;if(_0x4d8c97){_0x571e41=squel[_0xb41b('0x5c')]()[_0xb41b('0x5d')](_0xb41b('0x5e'))['fromQuery'](['phone',_0xb41b('0x5f'),_0xb41b('0x60'),_0xb41b('0x61'),_0xb41b('0x62'),_0xb41b('0x63'),_0xb41b('0x64')],squel[_0xb41b('0x65')]()['field']('ANY_VALUE(calleridnum)',_0xb41b('0x66'))[_0xb41b('0x67')]('NOW()',_0xb41b('0x5f'))['field'](_0xb41b('0x68'),_0xb41b('0x60'))['field'](_0xb41b('0x69'),_0xb41b('0x61'))['field']('ANY_VALUE(VoiceQueueId)',_0xb41b('0x62'))[_0xb41b('0x67')]('NOW()',_0xb41b('0x63'))['field'](_0xb41b('0x6a'),_0xb41b('0x64'))['from']('cm_hopper_final')[_0xb41b('0x35')](_0xb41b('0x6b'),_0x523c72['params']['id'][_0xb41b('0x6c')]())[_0xb41b('0x35')](_0xb41b('0x6d'),_0x523c72['body'][_0xb41b('0x6e')]['toString']())['where'](_0xb41b('0x6f'))[_0xb41b('0x35')](_0xb41b('0x70'),squel[_0xb41b('0x65')]()[_0xb41b('0x67')](_0xb41b('0x66'))[_0xb41b('0x71')](_0xb41b('0x5e'))[_0xb41b('0x35')](_0xb41b('0x6b'),_0x523c72[_0xb41b('0x43')]['id'][_0xb41b('0x6c')]()))[_0xb41b('0x35')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0xb41b('0x65')]()[_0xb41b('0x67')](_0xb41b('0x72'))[_0xb41b('0x71')](_0xb41b('0x73'))[_0xb41b('0x35')](_0xb41b('0x6b'),_0x523c72[_0xb41b('0x43')]['id']['toString']())['where'](_0xb41b('0x74')))[_0xb41b('0x75')](_0xb41b('0x60')))['toString']();return db[_0xb41b('0x47')][_0xb41b('0x2d')](_0x571e41);}return[];})['then'](respondWithResult(_0xf3c1bb,null))[_0xb41b('0x3b')](handleError(_0xf3c1bb,null));};exports[_0xb41b('0x76')]=function(_0x5b17da,_0x2ead5e,_0x3874d9){return db[_0xb41b('0x77')][_0xb41b('0x42')]({'where':{'id':_0x5b17da[_0xb41b('0x43')]['id']}})[_0xb41b('0x21')](handleEntityNotFound(_0x2ead5e,null))[_0xb41b('0x21')](function(_0x24b99d){var _0x214372;if(_0x24b99d){_0x214372=squel['insert']()['into'](_0xb41b('0x5e'))[_0xb41b('0x78')]([_0xb41b('0x66'),_0xb41b('0x5f'),_0xb41b('0x60'),_0xb41b('0x61'),'CampaignId',_0xb41b('0x63'),_0xb41b('0x64')],squel[_0xb41b('0x65')]()[_0xb41b('0x67')](_0xb41b('0x79'),_0xb41b('0x66'))[_0xb41b('0x67')](_0xb41b('0x6a'),_0xb41b('0x5f'))[_0xb41b('0x67')](_0xb41b('0x68'),_0xb41b('0x60'))[_0xb41b('0x67')](_0xb41b('0x69'),_0xb41b('0x61'))[_0xb41b('0x67')]('ANY_VALUE(CampaignId)','CampaignId')['field'](_0xb41b('0x6a'),'createdAt')[_0xb41b('0x67')](_0xb41b('0x6a'),'updatedAt')[_0xb41b('0x71')](_0xb41b('0x73'))[_0xb41b('0x35')](_0xb41b('0x7a'),_0x5b17da[_0xb41b('0x43')]['id']['toString']())[_0xb41b('0x35')](_0xb41b('0x6d'),_0x5b17da['body']['state'][_0xb41b('0x6c')]())[_0xb41b('0x35')]('calleridnum\x20IS\x20NOT\x20NULL')[_0xb41b('0x35')](_0xb41b('0x70'),squel[_0xb41b('0x65')]()['field']('phone')[_0xb41b('0x71')](_0xb41b('0x5e'))['where'](_0xb41b('0x7a'),_0x5b17da[_0xb41b('0x43')]['id'][_0xb41b('0x6c')]()))['where'](_0xb41b('0x70'),squel[_0xb41b('0x65')]()[_0xb41b('0x67')](_0xb41b('0x72'))[_0xb41b('0x71')](_0xb41b('0x73'))[_0xb41b('0x35')](_0xb41b('0x7a'),_0x5b17da[_0xb41b('0x43')]['id']['toString']())[_0xb41b('0x35')](_0xb41b('0x74')))['group'](_0xb41b('0x60')))['toString']();return db[_0xb41b('0x47')]['query'](_0x214372);}return[];})[_0xb41b('0x21')](respondWithResult(_0x2ead5e,null))[_0xb41b('0x3b')](handleError(_0x2ead5e,null));};exports[_0xb41b('0x7b')]=function(_0x24d478,_0x1be1f4,_0x274e97){return db[_0xb41b('0x7c')][_0xb41b('0x7d')]({'where':{'VoiceQueueId':_0x24d478[_0xb41b('0x40')]['VoiceQueueId'],'CampaignId':_0x24d478[_0xb41b('0x40')][_0xb41b('0x7e')],'ContactId':_0x24d478[_0xb41b('0x40')][_0xb41b('0x60')]}})['then'](handleEntityNotFound(_0x1be1f4,null))[_0xb41b('0x21')](function(_0x5e50ca){if(_0x5e50ca){return _0x5e50ca;}return null;})['then'](respondWithResult(_0x1be1f4,null))[_0xb41b('0x3b')](handleError(_0x1be1f4,null));};
\ No newline at end of file
+var _0x0e9f=['scheduledAt','ANY_VALUE(ContactId)','ANY_VALUE(ListId)','ListId','ANY_VALUE(VoiceQueueId)','from','cm_hopper_final','state\x20=\x20?','state','toString','calleridnum\x20IS\x20NOT\x20NULL','calleridnum\x20NOT\x20IN\x20(?)','select','VoiceQueueId\x20=\x20?','state\x20=\x204','group','moveContactsIvrCampaignHopperFinal','Campaign','CampaignId','updatedAt','ANY_VALUE(CampaignId)','CampaignId\x20=\x20?','calleridnum','findOne','html-pdf','eml-format','fast-json-patch','bluebird','path','sox','ejs','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','sendStatus','end','status','json','count','offset','limit','set','apply','save','then','destroy','error','stack','name','index','map','CmHopperFinal','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','VIRTUAL','options','includeAll','params','include','find','catch','describe','update','body','uniqueid','findAll','sequelize','COUNT','`state`\x20=\x200,\x201,\x20null','noAnswerContacts','literal','busyContacts','`state`\x20=\x208,\x201,\x20null','congestionContacts','`state`\x20=\x2010\x20,\x201,\x20null','dropContacts','`state`\x20=\x2011\x20,\x201,\x20null','reCallContacts','`state`\x20=\x2019,\x201,\x20null','answeringMachine','countContactsIvrCampaignHopperFinal','noSuchContacts','`state`\x20=\x203,\x201,\x20null','`state`\x20=\x205,\x201,\x20null','abandonedContacts','`state`\x20=\x2022,\x201,\x20null','moveContactsQueueCampaignHopperFinal','VoiceQueue','insert','into','cm_hopper','fromQuery','phone','ContactId','VoiceQueueId','createdAt','field','ANY_VALUE(calleridnum)','NOW()'];(function(_0x825c1c,_0x9119ef){var _0x1baa74=function(_0x54d220){while(--_0x54d220){_0x825c1c['push'](_0x825c1c['shift']());}};_0x1baa74(++_0x9119ef);}(_0x0e9f,0x116));var _0xf0e9=function(_0x1e5b67,_0x1aacd7){_0x1e5b67=_0x1e5b67-0x0;var _0x1fe947=_0x0e9f[_0x1e5b67];return _0x1fe947;};'use strict';var pdf=require(_0xf0e9('0x0'));var emlformat=require(_0xf0e9('0x1'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xf0e9('0x2'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0xf0e9('0x3'));var Mustache=require('mustache');var util=require('util');var path=require(_0xf0e9('0x4'));var sox=require(_0xf0e9('0x5'));var csv=require('to-csv');var ejs=require(_0xf0e9('0x6'));var fs=require('fs');var _=require('lodash');var squel=require(_0xf0e9('0x7'));var crypto=require(_0xf0e9('0x8'));var jsforce=require(_0xf0e9('0x9'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0xf0e9('0xa'));var Papa=require(_0xf0e9('0xb'));var Redis=require(_0xf0e9('0xc'));var authService=require('../../components/auth/service');var qs=require(_0xf0e9('0xd'));var as=require(_0xf0e9('0xe'));var hardwareService=require(_0xf0e9('0xf'));var logger=require('../../config/logger')(_0xf0e9('0x10'));var utils=require(_0xf0e9('0x11'));var config=require(_0xf0e9('0x12'));var licenseUtil=require(_0xf0e9('0x13'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0xa9d7e3,_0x541cd6){_0x541cd6=_0x541cd6||0xcc;return function(_0x1461af){if(_0x1461af){return _0xa9d7e3[_0xf0e9('0x14')](_0x541cd6);}return _0xa9d7e3['status'](_0x541cd6)[_0xf0e9('0x15')]();};}function respondWithResult(_0x34ebf1,_0x261100){_0x261100=_0x261100||0xc8;return function(_0x1b87cf){if(_0x1b87cf){return _0x34ebf1[_0xf0e9('0x16')](_0x261100)[_0xf0e9('0x17')](_0x1b87cf);}};}function respondWithFilteredResult(_0x5c7787,_0x933fea){return function(_0x1eb36f){if(_0x1eb36f){var _0x4f37b5=_0x1eb36f[_0xf0e9('0x18')],_0x320a29=_0x933fea['offset'],_0xcf4be0=_0x933fea[_0xf0e9('0x19')]+_0x933fea[_0xf0e9('0x1a')],_0x3d0b4d;if(_0xcf4be0>=_0x4f37b5){_0xcf4be0=_0x4f37b5;_0x3d0b4d=0xc8;}else{_0x3d0b4d=0xce;}_0x5c7787[_0xf0e9('0x16')](_0x3d0b4d);return _0x5c7787[_0xf0e9('0x1b')]('Content-Range',_0x320a29+'-'+_0xcf4be0+'/'+_0x4f37b5)['json'](_0x1eb36f);}return null;};}function patchUpdates(_0x360f8b){return function(_0x98bb88){try{jsonpatch[_0xf0e9('0x1c')](_0x98bb88,_0x360f8b,!![]);}catch(_0x49c120){return BPromise['reject'](_0x49c120);}return _0x98bb88[_0xf0e9('0x1d')]();};}function saveUpdates(_0x1ac91f,_0x4992c5){return function(_0x3d6c12){if(_0x3d6c12){return _0x3d6c12['update'](_0x1ac91f)[_0xf0e9('0x1e')](function(_0x1c956d){return _0x1c956d;});}return null;};}function removeEntity(_0x4afcff,_0x5dd652){return function(_0x186fa5){if(_0x186fa5){return _0x186fa5[_0xf0e9('0x1f')]()['then'](function(){_0x4afcff[_0xf0e9('0x16')](0xcc)[_0xf0e9('0x15')]();});}};}function handleEntityNotFound(_0x52612e,_0x2f44ee){return function(_0x2a31fc){if(!_0x2a31fc){_0x52612e['sendStatus'](0x194);}return _0x2a31fc;};}function handleError(_0x297936,_0x423dd1){_0x423dd1=_0x423dd1||0x1f4;return function(_0x9acc21){logger[_0xf0e9('0x20')](_0x9acc21[_0xf0e9('0x21')]);if(_0x9acc21[_0xf0e9('0x22')]){delete _0x9acc21[_0xf0e9('0x22')];}_0x297936['status'](_0x423dd1)['send'](_0x9acc21);};}exports[_0xf0e9('0x23')]=function(_0x4f9e96,_0x553788){var _0x5aac7f={},_0x8b5167={},_0x8fd443={'count':0x0,'rows':[]};var _0x5620a5=_[_0xf0e9('0x24')](db[_0xf0e9('0x25')][_0xf0e9('0x26')],function(_0x480b7d){return{'name':_0x480b7d[_0xf0e9('0x27')],'type':_0x480b7d[_0xf0e9('0x28')][_0xf0e9('0x29')]};});_0x8b5167[_0xf0e9('0x2a')]=_[_0xf0e9('0x24')](_0x5620a5,_0xf0e9('0x22'));_0x8b5167[_0xf0e9('0x2b')]=_[_0xf0e9('0x2c')](_0x4f9e96['query']);_0x8b5167[_0xf0e9('0x2d')]=_[_0xf0e9('0x2e')](_0x8b5167['model'],_0x8b5167['query']);_0x5aac7f[_0xf0e9('0x2f')]=_[_0xf0e9('0x2e')](_0x8b5167['model'],qs[_0xf0e9('0x30')](_0x4f9e96[_0xf0e9('0x2b')][_0xf0e9('0x30')]));_0x5aac7f[_0xf0e9('0x2f')]=_0x5aac7f[_0xf0e9('0x2f')][_0xf0e9('0x31')]?_0x5aac7f[_0xf0e9('0x2f')]:_0x8b5167[_0xf0e9('0x2a')];if(!_0x4f9e96['query'][_0xf0e9('0x32')](_0xf0e9('0x33'))){_0x5aac7f['limit']=qs[_0xf0e9('0x1a')](_0x4f9e96['query'][_0xf0e9('0x1a')]);_0x5aac7f['offset']=qs['offset'](_0x4f9e96[_0xf0e9('0x2b')][_0xf0e9('0x19')]);}_0x5aac7f[_0xf0e9('0x34')]=qs[_0xf0e9('0x35')](_0x4f9e96[_0xf0e9('0x2b')][_0xf0e9('0x35')]);_0x5aac7f['where']=qs[_0xf0e9('0x2d')](_[_0xf0e9('0x36')](_0x4f9e96[_0xf0e9('0x2b')],_0x8b5167['filters']),_0x5620a5);if(_0x4f9e96[_0xf0e9('0x2b')][_0xf0e9('0x37')]){_0x5aac7f[_0xf0e9('0x38')]=_[_0xf0e9('0x39')](_0x5aac7f[_0xf0e9('0x38')],{'$or':_[_0xf0e9('0x24')](_0x5620a5,function(_0xd20a18){if(_0xd20a18[_0xf0e9('0x28')]!==_0xf0e9('0x3a')){var _0x346250={};_0x346250[_0xd20a18['name']]={'$like':'%'+_0x4f9e96[_0xf0e9('0x2b')][_0xf0e9('0x37')]+'%'};return _0x346250;}})});}_0x5aac7f=_['merge']({},_0x5aac7f,_0x4f9e96[_0xf0e9('0x3b')]);var _0x36c0e0={'where':_0x5aac7f[_0xf0e9('0x38')]};return db[_0xf0e9('0x25')][_0xf0e9('0x18')](_0x36c0e0)['then'](function(_0xc5ab58){_0x8fd443[_0xf0e9('0x18')]=_0xc5ab58;if(_0x4f9e96['query'][_0xf0e9('0x3c')]){_0x5aac7f['include']=[{'all':!![]}];}return db[_0xf0e9('0x25')]['findAll'](_0x5aac7f);})[_0xf0e9('0x1e')](function(_0xf7c1b5){_0x8fd443['rows']=_0xf7c1b5;return _0x8fd443;})[_0xf0e9('0x1e')](respondWithFilteredResult(_0x553788,_0x5aac7f))['catch'](handleError(_0x553788,null));};exports['show']=function(_0x4bad5b,_0x3935d8){var _0x36d96e={'raw':!![],'where':{'id':_0x4bad5b[_0xf0e9('0x3d')]['id']}},_0x13975e={};_0x13975e['model']=_[_0xf0e9('0x2c')](db[_0xf0e9('0x25')]['rawAttributes']);_0x13975e['query']=_[_0xf0e9('0x2c')](_0x4bad5b[_0xf0e9('0x2b')]);_0x13975e[_0xf0e9('0x2d')]=_[_0xf0e9('0x2e')](_0x13975e[_0xf0e9('0x2a')],_0x13975e['query']);_0x36d96e[_0xf0e9('0x2f')]=_[_0xf0e9('0x2e')](_0x13975e[_0xf0e9('0x2a')],qs[_0xf0e9('0x30')](_0x4bad5b[_0xf0e9('0x2b')][_0xf0e9('0x30')]));_0x36d96e[_0xf0e9('0x2f')]=_0x36d96e['attributes'][_0xf0e9('0x31')]?_0x36d96e[_0xf0e9('0x2f')]:_0x13975e[_0xf0e9('0x2a')];if(_0x4bad5b[_0xf0e9('0x2b')]['includeAll']){_0x36d96e[_0xf0e9('0x3e')]=[{'all':!![]}];}_0x36d96e=_[_0xf0e9('0x39')]({},_0x36d96e,_0x4bad5b[_0xf0e9('0x3b')]);return db['CmHopperFinal'][_0xf0e9('0x3f')](_0x36d96e)[_0xf0e9('0x1e')](handleEntityNotFound(_0x3935d8,null))[_0xf0e9('0x1e')](respondWithResult(_0x3935d8,null))[_0xf0e9('0x40')](handleError(_0x3935d8,null));};exports[_0xf0e9('0x41')]=function(_0xe3a44f,_0x25f741){return db[_0xf0e9('0x25')][_0xf0e9('0x41')]()[_0xf0e9('0x1e')](respondWithResult(_0x25f741,null))[_0xf0e9('0x40')](handleError(_0x25f741,null));};exports[_0xf0e9('0x42')]=function(_0x317419,_0x26ea90){if(_0x317419[_0xf0e9('0x43')][_0xf0e9('0x44')]){delete _0x317419[_0xf0e9('0x43')][_0xf0e9('0x44')];}return db[_0xf0e9('0x25')][_0xf0e9('0x3f')]({'where':{'uniqueid':_0x317419[_0xf0e9('0x3d')]['id']}})[_0xf0e9('0x1e')](handleEntityNotFound(_0x26ea90,null))[_0xf0e9('0x1e')](saveUpdates(_0x317419[_0xf0e9('0x43')],null))[_0xf0e9('0x1e')](respondWithResult(_0x26ea90,null))[_0xf0e9('0x40')](handleError(_0x26ea90,null));};exports['countContactsQueueCampaignHopperFinal']=function(_0x3b82d8,_0x2ea9e0,_0x4b750e){return db[_0xf0e9('0x25')][_0xf0e9('0x45')]({'raw':![],'where':{'VoiceQueueId':_0x3b82d8[_0xf0e9('0x3d')]['id']},'attributes':[[db[_0xf0e9('0x46')]['fn'](_0xf0e9('0x47'),db['sequelize']['fn']('IF',db[_0xf0e9('0x46')]['literal'](_0xf0e9('0x48')))),'noSuchContacts'],[db[_0xf0e9('0x46')]['fn'](_0xf0e9('0x47'),db[_0xf0e9('0x46')]['fn']('IF',db[_0xf0e9('0x46')]['literal']('`state`\x20=\x203,\x201,\x20null'))),_0xf0e9('0x49')],[db['sequelize']['fn'](_0xf0e9('0x47'),db[_0xf0e9('0x46')]['fn']('IF',db['sequelize'][_0xf0e9('0x4a')]('`state`\x20=\x205,\x201,\x20null'))),_0xf0e9('0x4b')],[db['sequelize']['fn'](_0xf0e9('0x47'),db['sequelize']['fn']('IF',db[_0xf0e9('0x46')][_0xf0e9('0x4a')](_0xf0e9('0x4c')))),_0xf0e9('0x4d')],[db['sequelize']['fn'](_0xf0e9('0x47'),db['sequelize']['fn']('IF',db[_0xf0e9('0x46')]['literal'](_0xf0e9('0x4e')))),_0xf0e9('0x4f')],[db[_0xf0e9('0x46')]['fn'](_0xf0e9('0x47'),db['sequelize']['fn']('IF',db[_0xf0e9('0x46')]['literal'](_0xf0e9('0x50')))),'abandonedContacts'],[db[_0xf0e9('0x46')]['fn'](_0xf0e9('0x47'),db[_0xf0e9('0x46')]['fn']('IF',db[_0xf0e9('0x46')]['literal']('`state`\x20=\x2022,\x201,\x20null'))),_0xf0e9('0x51')],[db[_0xf0e9('0x46')]['fn'](_0xf0e9('0x47'),db[_0xf0e9('0x46')]['fn']('IF',db[_0xf0e9('0x46')][_0xf0e9('0x4a')](_0xf0e9('0x52')))),_0xf0e9('0x53')]]})[_0xf0e9('0x1e')](handleEntityNotFound(_0x2ea9e0,null))[_0xf0e9('0x1e')](respondWithResult(_0x2ea9e0,null))[_0xf0e9('0x40')](handleError(_0x2ea9e0,null));};exports[_0xf0e9('0x54')]=function(_0xd7c77c,_0x1794b6,_0x5d9ebb){return db['CmHopperFinal'][_0xf0e9('0x45')]({'raw':![],'where':{'CampaignId':_0xd7c77c['params']['id']},'attributes':[[db[_0xf0e9('0x46')]['fn'](_0xf0e9('0x47'),db['sequelize']['fn']('IF',db[_0xf0e9('0x46')][_0xf0e9('0x4a')](_0xf0e9('0x48')))),_0xf0e9('0x55')],[db[_0xf0e9('0x46')]['fn'](_0xf0e9('0x47'),db[_0xf0e9('0x46')]['fn']('IF',db[_0xf0e9('0x46')][_0xf0e9('0x4a')](_0xf0e9('0x56')))),'noAnswerContacts'],[db[_0xf0e9('0x46')]['fn']('COUNT',db['sequelize']['fn']('IF',db[_0xf0e9('0x46')][_0xf0e9('0x4a')](_0xf0e9('0x57')))),'busyContacts'],[db[_0xf0e9('0x46')]['fn'](_0xf0e9('0x47'),db['sequelize']['fn']('IF',db['sequelize'][_0xf0e9('0x4a')](_0xf0e9('0x4c')))),_0xf0e9('0x4d')],[db[_0xf0e9('0x46')]['fn'](_0xf0e9('0x47'),db['sequelize']['fn']('IF',db[_0xf0e9('0x46')][_0xf0e9('0x4a')](_0xf0e9('0x4e')))),'dropContacts'],[db[_0xf0e9('0x46')]['fn']('COUNT',db[_0xf0e9('0x46')]['fn']('IF',db[_0xf0e9('0x46')]['literal'](_0xf0e9('0x50')))),_0xf0e9('0x58')],[db[_0xf0e9('0x46')]['fn'](_0xf0e9('0x47'),db[_0xf0e9('0x46')]['fn']('IF',db[_0xf0e9('0x46')][_0xf0e9('0x4a')](_0xf0e9('0x59')))),_0xf0e9('0x51')],[db[_0xf0e9('0x46')]['fn'](_0xf0e9('0x47'),db[_0xf0e9('0x46')]['fn']('IF',db['sequelize'][_0xf0e9('0x4a')]('`state`\x20=\x2019,\x201,\x20null'))),'answeringMachine']]})['then'](handleEntityNotFound(_0x1794b6,null))[_0xf0e9('0x1e')](respondWithResult(_0x1794b6,null))[_0xf0e9('0x40')](handleError(_0x1794b6,null));};exports[_0xf0e9('0x5a')]=function(_0x4955a5,_0x2bfd7e,_0x490260){return db[_0xf0e9('0x5b')][_0xf0e9('0x3f')]({'where':{'id':_0x4955a5[_0xf0e9('0x3d')]['id']}})['then'](handleEntityNotFound(_0x2bfd7e,null))[_0xf0e9('0x1e')](function(_0x134aa7){var _0x13f6f9;if(_0x134aa7){_0x13f6f9=squel[_0xf0e9('0x5c')]()[_0xf0e9('0x5d')](_0xf0e9('0x5e'))[_0xf0e9('0x5f')]([_0xf0e9('0x60'),'scheduledAt',_0xf0e9('0x61'),'ListId',_0xf0e9('0x62'),_0xf0e9('0x63'),'updatedAt'],squel['select']()[_0xf0e9('0x64')](_0xf0e9('0x65'),'phone')['field'](_0xf0e9('0x66'),_0xf0e9('0x67'))[_0xf0e9('0x64')](_0xf0e9('0x68'),_0xf0e9('0x61'))[_0xf0e9('0x64')](_0xf0e9('0x69'),_0xf0e9('0x6a'))[_0xf0e9('0x64')](_0xf0e9('0x6b'),_0xf0e9('0x62'))[_0xf0e9('0x64')]('NOW()','createdAt')[_0xf0e9('0x64')](_0xf0e9('0x66'),'updatedAt')[_0xf0e9('0x6c')](_0xf0e9('0x6d'))[_0xf0e9('0x38')]('VoiceQueueId\x20=\x20?',_0x4955a5['params']['id']['toString']())['where'](_0xf0e9('0x6e'),_0x4955a5[_0xf0e9('0x43')][_0xf0e9('0x6f')][_0xf0e9('0x70')]())[_0xf0e9('0x38')](_0xf0e9('0x71'))['where'](_0xf0e9('0x72'),squel[_0xf0e9('0x73')]()['field'](_0xf0e9('0x60'))[_0xf0e9('0x6c')](_0xf0e9('0x5e'))[_0xf0e9('0x38')](_0xf0e9('0x74'),_0x4955a5[_0xf0e9('0x3d')]['id'][_0xf0e9('0x70')]()))['where'](_0xf0e9('0x72'),squel[_0xf0e9('0x73')]()[_0xf0e9('0x64')]('calleridnum')[_0xf0e9('0x6c')](_0xf0e9('0x6d'))[_0xf0e9('0x38')](_0xf0e9('0x74'),_0x4955a5[_0xf0e9('0x3d')]['id']['toString']())[_0xf0e9('0x38')](_0xf0e9('0x75')))[_0xf0e9('0x76')](_0xf0e9('0x61')))[_0xf0e9('0x70')]();return db[_0xf0e9('0x46')][_0xf0e9('0x2b')](_0x13f6f9);}return[];})['then'](respondWithResult(_0x2bfd7e,null))[_0xf0e9('0x40')](handleError(_0x2bfd7e,null));};exports[_0xf0e9('0x77')]=function(_0x4bd24f,_0x470228,_0x5309cd){return db[_0xf0e9('0x78')][_0xf0e9('0x3f')]({'where':{'id':_0x4bd24f[_0xf0e9('0x3d')]['id']}})[_0xf0e9('0x1e')](handleEntityNotFound(_0x470228,null))['then'](function(_0x5644c0){var _0x3ccc3a;if(_0x5644c0){_0x3ccc3a=squel['insert']()[_0xf0e9('0x5d')](_0xf0e9('0x5e'))[_0xf0e9('0x5f')]([_0xf0e9('0x60'),_0xf0e9('0x67'),_0xf0e9('0x61'),_0xf0e9('0x6a'),_0xf0e9('0x79'),'createdAt',_0xf0e9('0x7a')],squel['select']()[_0xf0e9('0x64')]('ANY_VALUE(calleridnum)',_0xf0e9('0x60'))[_0xf0e9('0x64')](_0xf0e9('0x66'),'scheduledAt')[_0xf0e9('0x64')]('ANY_VALUE(ContactId)',_0xf0e9('0x61'))['field'](_0xf0e9('0x69'),'ListId')[_0xf0e9('0x64')](_0xf0e9('0x7b'),_0xf0e9('0x79'))['field'](_0xf0e9('0x66'),_0xf0e9('0x63'))['field']('NOW()','updatedAt')[_0xf0e9('0x6c')](_0xf0e9('0x6d'))[_0xf0e9('0x38')](_0xf0e9('0x7c'),_0x4bd24f[_0xf0e9('0x3d')]['id']['toString']())[_0xf0e9('0x38')]('state\x20=\x20?',_0x4bd24f['body'][_0xf0e9('0x6f')][_0xf0e9('0x70')]())[_0xf0e9('0x38')](_0xf0e9('0x71'))[_0xf0e9('0x38')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0xf0e9('0x73')]()['field']('phone')['from'](_0xf0e9('0x5e'))['where'](_0xf0e9('0x7c'),_0x4bd24f['params']['id'][_0xf0e9('0x70')]()))[_0xf0e9('0x38')](_0xf0e9('0x72'),squel[_0xf0e9('0x73')]()[_0xf0e9('0x64')](_0xf0e9('0x7d'))['from'](_0xf0e9('0x6d'))[_0xf0e9('0x38')](_0xf0e9('0x7c'),_0x4bd24f[_0xf0e9('0x3d')]['id'][_0xf0e9('0x70')]())['where'](_0xf0e9('0x75')))['group'](_0xf0e9('0x61')))[_0xf0e9('0x70')]();return db[_0xf0e9('0x46')][_0xf0e9('0x2b')](_0x3ccc3a);}return[];})['then'](respondWithResult(_0x470228,null))[_0xf0e9('0x40')](handleError(_0x470228,null));};exports['checkContactHopper']=function(_0x8f83ae,_0x35772b,_0x194baf){return db['CmHopper'][_0xf0e9('0x7e')]({'where':{'VoiceQueueId':_0x8f83ae[_0xf0e9('0x43')][_0xf0e9('0x62')],'CampaignId':_0x8f83ae[_0xf0e9('0x43')][_0xf0e9('0x79')],'ContactId':_0x8f83ae['body']['ContactId']}})[_0xf0e9('0x1e')](handleEntityNotFound(_0x35772b,null))[_0xf0e9('0x1e')](function(_0x223f69){if(_0x223f69){return _0x223f69;}return null;})[_0xf0e9('0x1e')](respondWithResult(_0x35772b,null))['catch'](handleError(_0x35772b,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff