// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x3cae=['state\x20=\x20?','state','toString','calleridnum\x20IS\x20NOT\x20NULL','calleridnum\x20NOT\x20IN\x20(?)','VoiceQueueId\x20=\x20?','state\x20=\x204','group','moveContactsIvrCampaignHopperFinal','Campaign','insert','CampaignId','ANY_VALUE(calleridnum)','ANY_VALUE(CampaignId)','CampaignId\x20=\x20?','calleridnum','checkContactHopper','CmHopper','findOne','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','sox','ejs','lodash','squel','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/parsers/qs','api','../../config/environment','../../mysqldb','end','json','offset','limit','status','set','Content-Range','apply','then','sendStatus','error','stack','name','send','CmHopperFinal','rawAttributes','model','query','dateStart','dateEnd','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','add','merge','map','type','key','VIRTUAL','field','filter','options','count','includeAll','include','findAll','rows','catch','show','params','keys','find','describe','update','body','countContactsQueueCampaignHopperFinal','sequelize','COUNT','noSuchContacts','literal','`state`\x20=\x203,\x201,\x20null','`state`\x20=\x205,\x201,\x20null','busyContacts','`state`\x20=\x208,\x201,\x20null','congestionContacts','`state`\x20=\x2010\x20,\x201,\x20null','`state`\x20=\x2011\x20,\x201,\x20null','abandonedContacts','`state`\x20=\x2022,\x201,\x20null','reCallContacts','countContactsIvrCampaignHopperFinal','`state`\x20=\x200,\x201,\x20null','noAnswerContacts','dropContacts','moveContactsQueueCampaignHopperFinal','into','cm_hopper','fromQuery','scheduledAt','ContactId','VoiceQueueId','createdAt','updatedAt','select','phone','ListId','ANY_VALUE(VoiceQueueId)','NOW()','from','cm_hopper_final'];(function(_0x5ac6cc,_0x2d124b){var _0x83dab7=function(_0x1effa9){while(--_0x1effa9){_0x5ac6cc['push'](_0x5ac6cc['shift']());}};_0x83dab7(++_0x2d124b);}(_0x3cae,0x117));var _0xe3ca=function(_0x1b828b,_0x344400){_0x1b828b=_0x1b828b-0x0;var _0x98da1a=_0x3cae[_0x1b828b];return _0x98da1a;};'use strict';var pdf=require(_0xe3ca('0x0'));var emlformat=require(_0xe3ca('0x1'));var rimraf=require(_0xe3ca('0x2'));var zipdir=require(_0xe3ca('0x3'));var jsonpatch=require(_0xe3ca('0x4'));var rp=require(_0xe3ca('0x5'));var moment=require(_0xe3ca('0x6'));var BPromise=require('bluebird');var Mustache=require(_0xe3ca('0x7'));var util=require(_0xe3ca('0x8'));var path=require('path');var sox=require(_0xe3ca('0x9'));var csv=require('to-csv');var ejs=require(_0xe3ca('0xa'));var fs=require('fs');var _=require(_0xe3ca('0xb'));var squel=require(_0xe3ca('0xc'));var crypto=require('crypto');var jsforce=require(_0xe3ca('0xd'));var deskjs=require(_0xe3ca('0xe'));var toCsv=require(_0xe3ca('0xf'));var querystring=require(_0xe3ca('0x10'));var Papa=require(_0xe3ca('0x11'));var Redis=require(_0xe3ca('0x12'));var qs=require(_0xe3ca('0x13'));var logger=require('../../config/logger')(_0xe3ca('0x14'));var utils=require('../../config/utils');var config=require(_0xe3ca('0x15'));var db=require(_0xe3ca('0x16'))['db'];function respondWithStatusCode(_0x219866,_0x2ea64d){_0x2ea64d=_0x2ea64d||0xcc;return function(_0x74ebf){if(_0x74ebf){return _0x219866['sendStatus'](_0x2ea64d);}return _0x219866['status'](_0x2ea64d)[_0xe3ca('0x17')]();};}function respondWithResult(_0x5f1c02,_0x35b0f1){_0x35b0f1=_0x35b0f1||0xc8;return function(_0xb3af46){if(_0xb3af46){return _0x5f1c02['status'](_0x35b0f1)[_0xe3ca('0x18')](_0xb3af46);}};}function respondWithFilteredResult(_0x3a9455,_0x210c69){return function(_0x6a8907){if(_0x6a8907){var _0x9ef773=_0x6a8907['count'],_0x292251=_0x210c69['offset'],_0x884795=_0x210c69[_0xe3ca('0x19')]+_0x210c69[_0xe3ca('0x1a')],_0x337b6c;if(_0x884795>=_0x9ef773){_0x884795=_0x9ef773;_0x337b6c=0xc8;}else{_0x337b6c=0xce;}_0x3a9455[_0xe3ca('0x1b')](_0x337b6c);return _0x3a9455[_0xe3ca('0x1c')](_0xe3ca('0x1d'),_0x292251+'-'+_0x884795+'/'+_0x9ef773)[_0xe3ca('0x18')](_0x6a8907);}return null;};}function patchUpdates(_0x5bb8d8){return function(_0x2eafde){try{jsonpatch[_0xe3ca('0x1e')](_0x2eafde,_0x5bb8d8,!![]);}catch(_0x180699){return BPromise['reject'](_0x180699);}return _0x2eafde['save']();};}function saveUpdates(_0x47f3fb,_0x21c516){return function(_0x593fd1){if(_0x593fd1){return _0x593fd1['update'](_0x47f3fb)[_0xe3ca('0x1f')](function(_0x1822e4){return _0x1822e4;});}return null;};}function removeEntity(_0xcc7add,_0x149291){return function(_0x2e26aa){if(_0x2e26aa){return _0x2e26aa['destroy']()[_0xe3ca('0x1f')](function(){_0xcc7add[_0xe3ca('0x1b')](0xcc)['end']();});}};}function handleEntityNotFound(_0x3f4740,_0x2d732f){return function(_0x33dc04){if(!_0x33dc04){_0x3f4740[_0xe3ca('0x20')](0x194);}return _0x33dc04;};}function handleError(_0xaf5191,_0x392bdb){_0x392bdb=_0x392bdb||0x1f4;return function(_0x2b571f){logger[_0xe3ca('0x21')](_0x2b571f[_0xe3ca('0x22')]);if(_0x2b571f[_0xe3ca('0x23')]){delete _0x2b571f[_0xe3ca('0x23')];}_0xaf5191['status'](_0x392bdb)[_0xe3ca('0x24')](_0x2b571f);};}exports['index']=function(_0x11ec88,_0x2fffe4){var _0x3de0ef={},_0x452096={},_0x576491={'count':0x0,'rows':[]};var _0x4c01c8=db[_0xe3ca('0x25')][_0xe3ca('0x26')];_0x452096[_0xe3ca('0x27')]=_['keys'](_0x4c01c8);var _0x1dbd98={'dateStart':_0x11ec88[_0xe3ca('0x28')][_0xe3ca('0x29')],'dateEnd':_0x11ec88[_0xe3ca('0x28')]['dateEnd']};delete _0x11ec88['query'][_0xe3ca('0x29')];delete _0x11ec88['query'][_0xe3ca('0x2a')];_0x452096['query']=_['keys'](_0x11ec88[_0xe3ca('0x28')]);_0x452096[_0xe3ca('0x2b')]=_[_0xe3ca('0x2c')](_0x452096[_0xe3ca('0x27')],_0x452096[_0xe3ca('0x28')]);_0x3de0ef['attributes']=_[_0xe3ca('0x2c')](_0x452096['model'],qs['fields'](_0x11ec88[_0xe3ca('0x28')][_0xe3ca('0x2d')]));_0x3de0ef[_0xe3ca('0x2e')]=_0x3de0ef[_0xe3ca('0x2e')][_0xe3ca('0x2f')]?_0x3de0ef[_0xe3ca('0x2e')]:_0x452096[_0xe3ca('0x27')];if(!_0x11ec88[_0xe3ca('0x28')][_0xe3ca('0x30')](_0xe3ca('0x31'))){_0x3de0ef[_0xe3ca('0x1a')]=qs[_0xe3ca('0x1a')](_0x11ec88['query'][_0xe3ca('0x1a')]);_0x3de0ef[_0xe3ca('0x19')]=qs[_0xe3ca('0x19')](_0x11ec88[_0xe3ca('0x28')][_0xe3ca('0x19')]);}_0x3de0ef[_0xe3ca('0x32')]=qs['sort'](_0x11ec88[_0xe3ca('0x28')][_0xe3ca('0x33')]);_0x3de0ef[_0xe3ca('0x34')]=qs[_0xe3ca('0x2b')](_[_0xe3ca('0x35')](_0x11ec88[_0xe3ca('0x28')],_0x452096[_0xe3ca('0x2b')]));if(_0x1dbd98[_0xe3ca('0x29')]){if(_0x1dbd98[_0xe3ca('0x2a')]){_0x1dbd98['dateEnd']=moment(_0x1dbd98[_0xe3ca('0x2a')])[_0xe3ca('0x36')](0x1,'day');}else{_0x1dbd98[_0xe3ca('0x2a')]=moment(_0x1dbd98[_0xe3ca('0x29')])[_0xe3ca('0x36')](0x1,'day');}_[_0xe3ca('0x37')](_0x3de0ef[_0xe3ca('0x34')],{'createdAt':{'$gte':_0x1dbd98['dateStart'],'$lte':_0x1dbd98[_0xe3ca('0x2a')]}});}if(_0x11ec88['query']['filter']){_0x3de0ef[_0xe3ca('0x34')]=_[_0xe3ca('0x37')](_0x3de0ef['where'],{'$or':_[_0xe3ca('0x38')](_0x4c01c8,function(_0x2037d8){if(_0x2037d8[_0xe3ca('0x39')][_0xe3ca('0x3a')]!==_0xe3ca('0x3b')){var _0x2f1dcb={};_0x2f1dcb[_0x2037d8[_0xe3ca('0x3c')]]={'$like':'%'+_0x11ec88[_0xe3ca('0x28')][_0xe3ca('0x3d')]+'%'};return _0x2f1dcb;}})});}_0x3de0ef=_['merge']({},_0x3de0ef,_0x11ec88[_0xe3ca('0x3e')]);var _0x13781d={'where':_0x3de0ef[_0xe3ca('0x34')]};return db[_0xe3ca('0x25')][_0xe3ca('0x3f')](_0x13781d)[_0xe3ca('0x1f')](function(_0x2a0290){_0x576491[_0xe3ca('0x3f')]=_0x2a0290;if(_0x11ec88[_0xe3ca('0x28')][_0xe3ca('0x40')]){_0x3de0ef[_0xe3ca('0x41')]=[{'all':!![]}];}return db[_0xe3ca('0x25')][_0xe3ca('0x42')](_0x3de0ef);})['then'](function(_0x275010){_0x576491[_0xe3ca('0x43')]=_0x275010;return _0x576491;})['then'](respondWithFilteredResult(_0x2fffe4,_0x3de0ef))[_0xe3ca('0x44')](handleError(_0x2fffe4,null));};exports[_0xe3ca('0x45')]=function(_0x8f004d,_0x4df55d){var _0x294797={'raw':!![],'where':{'id':_0x8f004d[_0xe3ca('0x46')]['id']}},_0x1c4706={};_0x1c4706[_0xe3ca('0x27')]=_[_0xe3ca('0x47')](db[_0xe3ca('0x25')][_0xe3ca('0x26')]);_0x1c4706['query']=_[_0xe3ca('0x47')](_0x8f004d[_0xe3ca('0x28')]);_0x1c4706['filters']=_['intersection'](_0x1c4706[_0xe3ca('0x27')],_0x1c4706[_0xe3ca('0x28')]);_0x294797['attributes']=_[_0xe3ca('0x2c')](_0x1c4706[_0xe3ca('0x27')],qs['fields'](_0x8f004d['query'][_0xe3ca('0x2d')]));_0x294797[_0xe3ca('0x2e')]=_0x294797[_0xe3ca('0x2e')][_0xe3ca('0x2f')]?_0x294797[_0xe3ca('0x2e')]:_0x1c4706['model'];if(_0x8f004d[_0xe3ca('0x28')][_0xe3ca('0x40')]){_0x294797[_0xe3ca('0x41')]=[{'all':!![]}];}_0x294797=_[_0xe3ca('0x37')]({},_0x294797,_0x8f004d[_0xe3ca('0x3e')]);return db[_0xe3ca('0x25')][_0xe3ca('0x48')](_0x294797)[_0xe3ca('0x1f')](handleEntityNotFound(_0x4df55d,null))[_0xe3ca('0x1f')](respondWithResult(_0x4df55d,null))['catch'](handleError(_0x4df55d,null));};exports['describe']=function(_0x539d5f,_0x542dfb){return db[_0xe3ca('0x25')][_0xe3ca('0x49')]()['then'](respondWithResult(_0x542dfb,null))['catch'](handleError(_0x542dfb,null));};exports[_0xe3ca('0x4a')]=function(_0x85e897,_0x468a60){if(_0x85e897['body']['uniqueid']){delete _0x85e897[_0xe3ca('0x4b')]['uniqueid'];}return db[_0xe3ca('0x25')][_0xe3ca('0x48')]({'where':{'uniqueid':_0x85e897[_0xe3ca('0x46')]['id']}})[_0xe3ca('0x1f')](handleEntityNotFound(_0x468a60,null))[_0xe3ca('0x1f')](saveUpdates(_0x85e897[_0xe3ca('0x4b')],null))[_0xe3ca('0x1f')](respondWithResult(_0x468a60,null))[_0xe3ca('0x44')](handleError(_0x468a60,null));};exports[_0xe3ca('0x4c')]=function(_0x7cf9dd,_0x187220,_0x51d29f){return db[_0xe3ca('0x25')][_0xe3ca('0x42')]({'raw':![],'where':{'VoiceQueueId':_0x7cf9dd['params']['id']},'attributes':[[db[_0xe3ca('0x4d')]['fn'](_0xe3ca('0x4e'),db[_0xe3ca('0x4d')]['fn']('IF',db[_0xe3ca('0x4d')]['literal']('`state`\x20=\x200,\x201,\x20null'))),_0xe3ca('0x4f')],[db[_0xe3ca('0x4d')]['fn'](_0xe3ca('0x4e'),db['sequelize']['fn']('IF',db[_0xe3ca('0x4d')][_0xe3ca('0x50')](_0xe3ca('0x51')))),'noAnswerContacts'],[db[_0xe3ca('0x4d')]['fn'](_0xe3ca('0x4e'),db[_0xe3ca('0x4d')]['fn']('IF',db[_0xe3ca('0x4d')][_0xe3ca('0x50')](_0xe3ca('0x52')))),_0xe3ca('0x53')],[db[_0xe3ca('0x4d')]['fn'](_0xe3ca('0x4e'),db['sequelize']['fn']('IF',db[_0xe3ca('0x4d')][_0xe3ca('0x50')](_0xe3ca('0x54')))),_0xe3ca('0x55')],[db[_0xe3ca('0x4d')]['fn'](_0xe3ca('0x4e'),db[_0xe3ca('0x4d')]['fn']('IF',db['sequelize'][_0xe3ca('0x50')](_0xe3ca('0x56')))),'dropContacts'],[db[_0xe3ca('0x4d')]['fn'](_0xe3ca('0x4e'),db['sequelize']['fn']('IF',db['sequelize'][_0xe3ca('0x50')](_0xe3ca('0x57')))),_0xe3ca('0x58')],[db['sequelize']['fn']('COUNT',db[_0xe3ca('0x4d')]['fn']('IF',db['sequelize'][_0xe3ca('0x50')](_0xe3ca('0x59')))),_0xe3ca('0x5a')]]})[_0xe3ca('0x1f')](handleEntityNotFound(_0x187220,null))[_0xe3ca('0x1f')](respondWithResult(_0x187220,null))[_0xe3ca('0x44')](handleError(_0x187220,null));};exports[_0xe3ca('0x5b')]=function(_0x44a898,_0x1c2856,_0x706d5a){return db['CmHopperFinal'][_0xe3ca('0x42')]({'raw':![],'where':{'CampaignId':_0x44a898[_0xe3ca('0x46')]['id']},'attributes':[[db[_0xe3ca('0x4d')]['fn'](_0xe3ca('0x4e'),db[_0xe3ca('0x4d')]['fn']('IF',db['sequelize'][_0xe3ca('0x50')](_0xe3ca('0x5c')))),_0xe3ca('0x4f')],[db[_0xe3ca('0x4d')]['fn'](_0xe3ca('0x4e'),db[_0xe3ca('0x4d')]['fn']('IF',db[_0xe3ca('0x4d')][_0xe3ca('0x50')](_0xe3ca('0x51')))),_0xe3ca('0x5d')],[db[_0xe3ca('0x4d')]['fn']('COUNT',db['sequelize']['fn']('IF',db[_0xe3ca('0x4d')]['literal'](_0xe3ca('0x52')))),_0xe3ca('0x53')],[db[_0xe3ca('0x4d')]['fn'](_0xe3ca('0x4e'),db['sequelize']['fn']('IF',db[_0xe3ca('0x4d')][_0xe3ca('0x50')]('`state`\x20=\x208,\x201,\x20null'))),'congestionContacts'],[db[_0xe3ca('0x4d')]['fn'](_0xe3ca('0x4e'),db[_0xe3ca('0x4d')]['fn']('IF',db[_0xe3ca('0x4d')][_0xe3ca('0x50')](_0xe3ca('0x56')))),_0xe3ca('0x5e')],[db['sequelize']['fn'](_0xe3ca('0x4e'),db[_0xe3ca('0x4d')]['fn']('IF',db[_0xe3ca('0x4d')][_0xe3ca('0x50')]('`state`\x20=\x2011\x20,\x201,\x20null'))),'abandonedContacts'],[db[_0xe3ca('0x4d')]['fn'](_0xe3ca('0x4e'),db[_0xe3ca('0x4d')]['fn']('IF',db[_0xe3ca('0x4d')][_0xe3ca('0x50')]('`state`\x20=\x2022,\x201,\x20null'))),_0xe3ca('0x5a')]]})[_0xe3ca('0x1f')](handleEntityNotFound(_0x1c2856,null))[_0xe3ca('0x1f')](respondWithResult(_0x1c2856,null))[_0xe3ca('0x44')](handleError(_0x1c2856,null));};exports[_0xe3ca('0x5f')]=function(_0x395b3b,_0x2fa297,_0x7c1f3a){return db['VoiceQueue'][_0xe3ca('0x48')]({'where':{'id':_0x395b3b[_0xe3ca('0x46')]['id']}})[_0xe3ca('0x1f')](handleEntityNotFound(_0x2fa297,null))[_0xe3ca('0x1f')](function(_0x3eb265){var _0x31aee4;if(_0x3eb265){_0x31aee4=squel['insert']()[_0xe3ca('0x60')](_0xe3ca('0x61'))[_0xe3ca('0x62')](['phone',_0xe3ca('0x63'),_0xe3ca('0x64'),'ListId',_0xe3ca('0x65'),_0xe3ca('0x66'),_0xe3ca('0x67')],squel[_0xe3ca('0x68')]()[_0xe3ca('0x3c')]('ANY_VALUE(calleridnum)',_0xe3ca('0x69'))[_0xe3ca('0x3c')]('NOW()',_0xe3ca('0x63'))[_0xe3ca('0x3c')]('ANY_VALUE(ContactId)',_0xe3ca('0x64'))[_0xe3ca('0x3c')]('ANY_VALUE(ListId)',_0xe3ca('0x6a'))[_0xe3ca('0x3c')](_0xe3ca('0x6b'),_0xe3ca('0x65'))[_0xe3ca('0x3c')](_0xe3ca('0x6c'),_0xe3ca('0x66'))['field']('NOW()',_0xe3ca('0x67'))[_0xe3ca('0x6d')](_0xe3ca('0x6e'))[_0xe3ca('0x34')]('VoiceQueueId\x20=\x20?',_0x395b3b[_0xe3ca('0x46')]['id']['toString']())[_0xe3ca('0x34')](_0xe3ca('0x6f'),_0x395b3b[_0xe3ca('0x4b')][_0xe3ca('0x70')][_0xe3ca('0x71')]())[_0xe3ca('0x34')](_0xe3ca('0x72'))[_0xe3ca('0x34')](_0xe3ca('0x73'),squel['select']()['field']('phone')[_0xe3ca('0x6d')]('cm_hopper')[_0xe3ca('0x34')]('VoiceQueueId\x20=\x20?',_0x395b3b[_0xe3ca('0x46')]['id']['toString']()))[_0xe3ca('0x34')](_0xe3ca('0x73'),squel[_0xe3ca('0x68')]()[_0xe3ca('0x3c')]('calleridnum')['from'](_0xe3ca('0x6e'))[_0xe3ca('0x34')](_0xe3ca('0x74'),_0x395b3b[_0xe3ca('0x46')]['id'][_0xe3ca('0x71')]())[_0xe3ca('0x34')](_0xe3ca('0x75')))[_0xe3ca('0x76')](_0xe3ca('0x64')))[_0xe3ca('0x71')]();return db['sequelize'][_0xe3ca('0x28')](_0x31aee4);}return[];})[_0xe3ca('0x1f')](respondWithResult(_0x2fa297,null))[_0xe3ca('0x44')](handleError(_0x2fa297,null));};exports[_0xe3ca('0x77')]=function(_0x7aad69,_0x5df0ab,_0x22685d){return db[_0xe3ca('0x78')][_0xe3ca('0x48')]({'where':{'id':_0x7aad69[_0xe3ca('0x46')]['id']}})[_0xe3ca('0x1f')](handleEntityNotFound(_0x5df0ab,null))['then'](function(_0x52ae61){var _0x102169;if(_0x52ae61){_0x102169=squel[_0xe3ca('0x79')]()[_0xe3ca('0x60')](_0xe3ca('0x61'))[_0xe3ca('0x62')](['phone',_0xe3ca('0x63'),_0xe3ca('0x64'),_0xe3ca('0x6a'),_0xe3ca('0x7a'),'createdAt',_0xe3ca('0x67')],squel[_0xe3ca('0x68')]()['field'](_0xe3ca('0x7b'),_0xe3ca('0x69'))[_0xe3ca('0x3c')](_0xe3ca('0x6c'),'scheduledAt')[_0xe3ca('0x3c')]('ANY_VALUE(ContactId)','ContactId')['field']('ANY_VALUE(ListId)','ListId')['field'](_0xe3ca('0x7c'),'CampaignId')[_0xe3ca('0x3c')](_0xe3ca('0x6c'),_0xe3ca('0x66'))[_0xe3ca('0x3c')](_0xe3ca('0x6c'),_0xe3ca('0x67'))[_0xe3ca('0x6d')](_0xe3ca('0x6e'))[_0xe3ca('0x34')]('CampaignId\x20=\x20?',_0x7aad69['params']['id'][_0xe3ca('0x71')]())[_0xe3ca('0x34')](_0xe3ca('0x6f'),_0x7aad69[_0xe3ca('0x4b')][_0xe3ca('0x70')][_0xe3ca('0x71')]())[_0xe3ca('0x34')](_0xe3ca('0x72'))[_0xe3ca('0x34')](_0xe3ca('0x73'),squel['select']()['field'](_0xe3ca('0x69'))[_0xe3ca('0x6d')](_0xe3ca('0x61'))[_0xe3ca('0x34')](_0xe3ca('0x7d'),_0x7aad69[_0xe3ca('0x46')]['id'][_0xe3ca('0x71')]()))['where'](_0xe3ca('0x73'),squel[_0xe3ca('0x68')]()['field'](_0xe3ca('0x7e'))[_0xe3ca('0x6d')](_0xe3ca('0x6e'))[_0xe3ca('0x34')](_0xe3ca('0x7d'),_0x7aad69['params']['id'][_0xe3ca('0x71')]())[_0xe3ca('0x34')]('state\x20=\x204'))[_0xe3ca('0x76')](_0xe3ca('0x64')))[_0xe3ca('0x71')]();return db['sequelize'][_0xe3ca('0x28')](_0x102169);}return[];})[_0xe3ca('0x1f')](respondWithResult(_0x5df0ab,null))[_0xe3ca('0x44')](handleError(_0x5df0ab,null));};exports[_0xe3ca('0x7f')]=function(_0xba752e,_0x4cbae5,_0x57fb60){return db[_0xe3ca('0x80')][_0xe3ca('0x81')]({'where':{'VoiceQueueId':_0xba752e[_0xe3ca('0x4b')][_0xe3ca('0x65')],'CampaignId':_0xba752e[_0xe3ca('0x4b')][_0xe3ca('0x7a')],'ContactId':_0xba752e[_0xe3ca('0x4b')]['ContactId']}})['then'](handleEntityNotFound(_0x4cbae5,null))['then'](function(_0x42bdba){if(_0x42bdba){return _0x42bdba;}return null;})[_0xe3ca('0x1f')](respondWithResult(_0x4cbae5,null))['catch'](handleError(_0x4cbae5,null));};
\ No newline at end of file
+var _0x4028=['api','../../config/utils','../../mysqldb','sendStatus','status','end','json','count','offset','set','Content-Range','apply','reject','save','update','then','destroy','error','name','CmHopperFinal','rawAttributes','model','keys','query','filters','attributes','intersection','fields','length','hasOwnProperty','nolimit','limit','order','sort','where','pick','merge','map','VIRTUAL','filter','options','includeAll','findAll','catch','include','find','describe','body','uniqueid','params','sequelize','COUNT','literal','`state`\x20=\x200,\x201,\x20null','noSuchContacts','`state`\x20=\x203,\x201,\x20null','noAnswerContacts','busyContacts','`state`\x20=\x208,\x201,\x20null','congestionContacts','`state`\x20=\x2010\x20,\x201,\x20null','`state`\x20=\x2011\x20,\x201,\x20null','abandonedContacts','`state`\x20=\x2022,\x201,\x20null','reCallContacts','moveContactsQueueCampaignHopperFinal','VoiceQueue','insert','into','cm_hopper','fromQuery','phone','ContactId','createdAt','updatedAt','select','field','scheduledAt','ANY_VALUE(ContactId)','ANY_VALUE(ListId)','ListId','ANY_VALUE(VoiceQueueId)','VoiceQueueId','NOW()','from','cm_hopper_final','VoiceQueueId\x20=\x20?','toString','state','calleridnum\x20IS\x20NOT\x20NULL','calleridnum\x20NOT\x20IN\x20(?)','calleridnum','state\x20=\x204','group','Campaign','CampaignId','ANY_VALUE(calleridnum)','ANY_VALUE(CampaignId)','CampaignId\x20=\x20?','state\x20=\x20?','CmHopper','findOne','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../config/logger'];(function(_0x2ea024,_0x14ce3b){var _0x327778=function(_0x2385bb){while(--_0x2385bb){_0x2ea024['push'](_0x2ea024['shift']());}};_0x327778(++_0x14ce3b);}(_0x4028,0x15a));var _0x8402=function(_0x37b9da,_0x443696){_0x37b9da=_0x37b9da-0x0;var _0x507c06=_0x4028[_0x37b9da];return _0x507c06;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x8402('0x0'));var rimraf=require(_0x8402('0x1'));var zipdir=require(_0x8402('0x2'));var jsonpatch=require(_0x8402('0x3'));var rp=require('request-promise');var moment=require(_0x8402('0x4'));var BPromise=require(_0x8402('0x5'));var Mustache=require(_0x8402('0x6'));var util=require(_0x8402('0x7'));var path=require(_0x8402('0x8'));var sox=require(_0x8402('0x9'));var csv=require(_0x8402('0xa'));var ejs=require('ejs');var fs=require('fs');var _=require('lodash');var squel=require(_0x8402('0xb'));var crypto=require(_0x8402('0xc'));var jsforce=require(_0x8402('0xd'));var deskjs=require(_0x8402('0xe'));var toCsv=require(_0x8402('0xa'));var querystring=require(_0x8402('0xf'));var Papa=require(_0x8402('0x10'));var Redis=require(_0x8402('0x11'));var qs=require(_0x8402('0x12'));var logger=require(_0x8402('0x13'))(_0x8402('0x14'));var utils=require(_0x8402('0x15'));var config=require('../../config/environment');var db=require(_0x8402('0x16'))['db'];function respondWithStatusCode(_0x22ff46,_0x20081e){_0x20081e=_0x20081e||0xcc;return function(_0x43b2d9){if(_0x43b2d9){return _0x22ff46[_0x8402('0x17')](_0x20081e);}return _0x22ff46[_0x8402('0x18')](_0x20081e)[_0x8402('0x19')]();};}function respondWithResult(_0x2509de,_0x29d239){_0x29d239=_0x29d239||0xc8;return function(_0x425aa8){if(_0x425aa8){return _0x2509de[_0x8402('0x18')](_0x29d239)[_0x8402('0x1a')](_0x425aa8);}};}function respondWithFilteredResult(_0x10163f,_0xb10a65){return function(_0x4ca85b){if(_0x4ca85b){var _0xbf057b=_0x4ca85b[_0x8402('0x1b')],_0x193ad4=_0xb10a65[_0x8402('0x1c')],_0x42b0b8=_0xb10a65[_0x8402('0x1c')]+_0xb10a65['limit'],_0x5c5bdc;if(_0x42b0b8>=_0xbf057b){_0x42b0b8=_0xbf057b;_0x5c5bdc=0xc8;}else{_0x5c5bdc=0xce;}_0x10163f[_0x8402('0x18')](_0x5c5bdc);return _0x10163f[_0x8402('0x1d')](_0x8402('0x1e'),_0x193ad4+'-'+_0x42b0b8+'/'+_0xbf057b)[_0x8402('0x1a')](_0x4ca85b);}return null;};}function patchUpdates(_0x3740ba){return function(_0x58576d){try{jsonpatch[_0x8402('0x1f')](_0x58576d,_0x3740ba,!![]);}catch(_0x4f68d6){return BPromise[_0x8402('0x20')](_0x4f68d6);}return _0x58576d[_0x8402('0x21')]();};}function saveUpdates(_0x19bf27,_0x729ec1){return function(_0x17abc2){if(_0x17abc2){return _0x17abc2[_0x8402('0x22')](_0x19bf27)[_0x8402('0x23')](function(_0x57cef7){return _0x57cef7;});}return null;};}function removeEntity(_0x2c4413,_0x8f68ae){return function(_0x4d79ba){if(_0x4d79ba){return _0x4d79ba[_0x8402('0x24')]()[_0x8402('0x23')](function(){_0x2c4413['status'](0xcc)[_0x8402('0x19')]();});}};}function handleEntityNotFound(_0x131249,_0x933235){return function(_0x4ac43a){if(!_0x4ac43a){_0x131249[_0x8402('0x17')](0x194);}return _0x4ac43a;};}function handleError(_0xe76fb4,_0x465815){_0x465815=_0x465815||0x1f4;return function(_0x5c684c){logger[_0x8402('0x25')](_0x5c684c['stack']);if(_0x5c684c[_0x8402('0x26')]){delete _0x5c684c[_0x8402('0x26')];}_0xe76fb4[_0x8402('0x18')](_0x465815)['send'](_0x5c684c);};}exports['index']=function(_0x14bfcd,_0x346d01){var _0x28d4fa={},_0x86229e={},_0x1fb808={'count':0x0,'rows':[]};var _0x2884e9=db[_0x8402('0x27')][_0x8402('0x28')];_0x86229e[_0x8402('0x29')]=_[_0x8402('0x2a')](_0x2884e9);_0x86229e[_0x8402('0x2b')]=_[_0x8402('0x2a')](_0x14bfcd[_0x8402('0x2b')]);_0x86229e[_0x8402('0x2c')]=_['intersection'](_0x86229e[_0x8402('0x29')],_0x86229e[_0x8402('0x2b')]);_0x28d4fa[_0x8402('0x2d')]=_[_0x8402('0x2e')](_0x86229e[_0x8402('0x29')],qs[_0x8402('0x2f')](_0x14bfcd[_0x8402('0x2b')][_0x8402('0x2f')]));_0x28d4fa[_0x8402('0x2d')]=_0x28d4fa['attributes'][_0x8402('0x30')]?_0x28d4fa['attributes']:_0x86229e[_0x8402('0x29')];if(!_0x14bfcd['query'][_0x8402('0x31')](_0x8402('0x32'))){_0x28d4fa[_0x8402('0x33')]=qs[_0x8402('0x33')](_0x14bfcd['query'][_0x8402('0x33')]);_0x28d4fa['offset']=qs['offset'](_0x14bfcd['query'][_0x8402('0x1c')]);}_0x28d4fa[_0x8402('0x34')]=qs['sort'](_0x14bfcd['query'][_0x8402('0x35')]);_0x28d4fa[_0x8402('0x36')]=qs['filters'](_[_0x8402('0x37')](_0x14bfcd[_0x8402('0x2b')],_0x86229e['filters']));if(_0x14bfcd[_0x8402('0x2b')]['filter']){_0x28d4fa[_0x8402('0x36')]=_[_0x8402('0x38')](_0x28d4fa[_0x8402('0x36')],{'$or':_[_0x8402('0x39')](_0x2884e9,function(_0x19b685){if(_0x19b685['type']['key']!==_0x8402('0x3a')){var _0x31cd89={};_0x31cd89[_0x19b685['field']]={'$like':'%'+_0x14bfcd['query'][_0x8402('0x3b')]+'%'};return _0x31cd89;}})});}_0x28d4fa=_[_0x8402('0x38')]({},_0x28d4fa,_0x14bfcd[_0x8402('0x3c')]);var _0x2804={'where':_0x28d4fa[_0x8402('0x36')]};return db[_0x8402('0x27')]['count'](_0x2804)[_0x8402('0x23')](function(_0x3132dd){_0x1fb808[_0x8402('0x1b')]=_0x3132dd;if(_0x14bfcd[_0x8402('0x2b')][_0x8402('0x3d')]){_0x28d4fa['include']=[{'all':!![]}];}return db['CmHopperFinal'][_0x8402('0x3e')](_0x28d4fa);})[_0x8402('0x23')](function(_0x1fc8b6){_0x1fb808['rows']=_0x1fc8b6;return _0x1fb808;})[_0x8402('0x23')](respondWithFilteredResult(_0x346d01,_0x28d4fa))[_0x8402('0x3f')](handleError(_0x346d01,null));};exports['show']=function(_0x3eceb3,_0xc4c278){var _0x34fe37={'raw':!![],'where':{'id':_0x3eceb3['params']['id']}},_0x131bd0={};_0x131bd0[_0x8402('0x29')]=_[_0x8402('0x2a')](db[_0x8402('0x27')]['rawAttributes']);_0x131bd0[_0x8402('0x2b')]=_[_0x8402('0x2a')](_0x3eceb3['query']);_0x131bd0[_0x8402('0x2c')]=_['intersection'](_0x131bd0['model'],_0x131bd0[_0x8402('0x2b')]);_0x34fe37[_0x8402('0x2d')]=_[_0x8402('0x2e')](_0x131bd0[_0x8402('0x29')],qs[_0x8402('0x2f')](_0x3eceb3['query'][_0x8402('0x2f')]));_0x34fe37[_0x8402('0x2d')]=_0x34fe37[_0x8402('0x2d')][_0x8402('0x30')]?_0x34fe37[_0x8402('0x2d')]:_0x131bd0['model'];if(_0x3eceb3[_0x8402('0x2b')][_0x8402('0x3d')]){_0x34fe37[_0x8402('0x40')]=[{'all':!![]}];}_0x34fe37=_['merge']({},_0x34fe37,_0x3eceb3['options']);return db[_0x8402('0x27')][_0x8402('0x41')](_0x34fe37)[_0x8402('0x23')](handleEntityNotFound(_0xc4c278,null))['then'](respondWithResult(_0xc4c278,null))[_0x8402('0x3f')](handleError(_0xc4c278,null));};exports['describe']=function(_0x4e0a6b,_0x1fe5b8){return db[_0x8402('0x27')][_0x8402('0x42')]()[_0x8402('0x23')](respondWithResult(_0x1fe5b8,null))[_0x8402('0x3f')](handleError(_0x1fe5b8,null));};exports['update']=function(_0x15fabb,_0x514cf0){if(_0x15fabb[_0x8402('0x43')][_0x8402('0x44')]){delete _0x15fabb[_0x8402('0x43')][_0x8402('0x44')];}return db[_0x8402('0x27')][_0x8402('0x41')]({'where':{'uniqueid':_0x15fabb['params']['id']}})[_0x8402('0x23')](handleEntityNotFound(_0x514cf0,null))['then'](saveUpdates(_0x15fabb[_0x8402('0x43')],null))['then'](respondWithResult(_0x514cf0,null))[_0x8402('0x3f')](handleError(_0x514cf0,null));};exports['countContactsQueueCampaignHopperFinal']=function(_0x486785,_0x5440bf,_0x1c7b65){return db['CmHopperFinal'][_0x8402('0x3e')]({'raw':![],'where':{'VoiceQueueId':_0x486785[_0x8402('0x45')]['id']},'attributes':[[db[_0x8402('0x46')]['fn'](_0x8402('0x47'),db[_0x8402('0x46')]['fn']('IF',db[_0x8402('0x46')][_0x8402('0x48')](_0x8402('0x49')))),_0x8402('0x4a')],[db['sequelize']['fn'](_0x8402('0x47'),db[_0x8402('0x46')]['fn']('IF',db[_0x8402('0x46')][_0x8402('0x48')](_0x8402('0x4b')))),_0x8402('0x4c')],[db[_0x8402('0x46')]['fn']('COUNT',db[_0x8402('0x46')]['fn']('IF',db['sequelize'][_0x8402('0x48')]('`state`\x20=\x205,\x201,\x20null'))),_0x8402('0x4d')],[db[_0x8402('0x46')]['fn'](_0x8402('0x47'),db['sequelize']['fn']('IF',db['sequelize']['literal'](_0x8402('0x4e')))),_0x8402('0x4f')],[db['sequelize']['fn'](_0x8402('0x47'),db[_0x8402('0x46')]['fn']('IF',db[_0x8402('0x46')][_0x8402('0x48')](_0x8402('0x50')))),'dropContacts'],[db[_0x8402('0x46')]['fn'](_0x8402('0x47'),db[_0x8402('0x46')]['fn']('IF',db['sequelize'][_0x8402('0x48')](_0x8402('0x51')))),_0x8402('0x52')],[db[_0x8402('0x46')]['fn']('COUNT',db[_0x8402('0x46')]['fn']('IF',db['sequelize'][_0x8402('0x48')](_0x8402('0x53')))),_0x8402('0x54')]]})[_0x8402('0x23')](handleEntityNotFound(_0x5440bf,null))[_0x8402('0x23')](respondWithResult(_0x5440bf,null))[_0x8402('0x3f')](handleError(_0x5440bf,null));};exports['countContactsIvrCampaignHopperFinal']=function(_0x2b281f,_0x218a0d,_0xd196fb){return db[_0x8402('0x27')][_0x8402('0x3e')]({'raw':![],'where':{'CampaignId':_0x2b281f['params']['id']},'attributes':[[db[_0x8402('0x46')]['fn'](_0x8402('0x47'),db[_0x8402('0x46')]['fn']('IF',db[_0x8402('0x46')][_0x8402('0x48')](_0x8402('0x49')))),'noSuchContacts'],[db[_0x8402('0x46')]['fn'](_0x8402('0x47'),db[_0x8402('0x46')]['fn']('IF',db[_0x8402('0x46')][_0x8402('0x48')]('`state`\x20=\x203,\x201,\x20null'))),'noAnswerContacts'],[db[_0x8402('0x46')]['fn']('COUNT',db['sequelize']['fn']('IF',db[_0x8402('0x46')][_0x8402('0x48')]('`state`\x20=\x205,\x201,\x20null'))),_0x8402('0x4d')],[db[_0x8402('0x46')]['fn']('COUNT',db[_0x8402('0x46')]['fn']('IF',db[_0x8402('0x46')][_0x8402('0x48')](_0x8402('0x4e')))),_0x8402('0x4f')],[db['sequelize']['fn']('COUNT',db[_0x8402('0x46')]['fn']('IF',db[_0x8402('0x46')][_0x8402('0x48')](_0x8402('0x50')))),'dropContacts'],[db[_0x8402('0x46')]['fn'](_0x8402('0x47'),db['sequelize']['fn']('IF',db['sequelize'][_0x8402('0x48')](_0x8402('0x51')))),_0x8402('0x52')],[db[_0x8402('0x46')]['fn'](_0x8402('0x47'),db['sequelize']['fn']('IF',db[_0x8402('0x46')][_0x8402('0x48')]('`state`\x20=\x2022,\x201,\x20null'))),_0x8402('0x54')]]})[_0x8402('0x23')](handleEntityNotFound(_0x218a0d,null))[_0x8402('0x23')](respondWithResult(_0x218a0d,null))['catch'](handleError(_0x218a0d,null));};exports[_0x8402('0x55')]=function(_0x211a2f,_0x28c03e,_0x181fa6){return db[_0x8402('0x56')]['find']({'where':{'id':_0x211a2f[_0x8402('0x45')]['id']}})[_0x8402('0x23')](handleEntityNotFound(_0x28c03e,null))[_0x8402('0x23')](function(_0x621b75){var _0x5135b7;if(_0x621b75){_0x5135b7=squel[_0x8402('0x57')]()[_0x8402('0x58')](_0x8402('0x59'))[_0x8402('0x5a')]([_0x8402('0x5b'),'scheduledAt',_0x8402('0x5c'),'ListId','VoiceQueueId',_0x8402('0x5d'),_0x8402('0x5e')],squel[_0x8402('0x5f')]()[_0x8402('0x60')]('ANY_VALUE(calleridnum)',_0x8402('0x5b'))[_0x8402('0x60')]('NOW()',_0x8402('0x61'))[_0x8402('0x60')](_0x8402('0x62'),_0x8402('0x5c'))['field'](_0x8402('0x63'),_0x8402('0x64'))[_0x8402('0x60')](_0x8402('0x65'),_0x8402('0x66'))[_0x8402('0x60')](_0x8402('0x67'),_0x8402('0x5d'))[_0x8402('0x60')](_0x8402('0x67'),'updatedAt')[_0x8402('0x68')](_0x8402('0x69'))[_0x8402('0x36')](_0x8402('0x6a'),_0x211a2f['params']['id'][_0x8402('0x6b')]())['where']('state\x20=\x20?',_0x211a2f[_0x8402('0x43')][_0x8402('0x6c')][_0x8402('0x6b')]())[_0x8402('0x36')](_0x8402('0x6d'))[_0x8402('0x36')](_0x8402('0x6e'),squel[_0x8402('0x5f')]()[_0x8402('0x60')](_0x8402('0x5b'))[_0x8402('0x68')](_0x8402('0x59'))[_0x8402('0x36')](_0x8402('0x6a'),_0x211a2f[_0x8402('0x45')]['id'][_0x8402('0x6b')]()))[_0x8402('0x36')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0x8402('0x5f')]()['field'](_0x8402('0x6f'))[_0x8402('0x68')](_0x8402('0x69'))[_0x8402('0x36')](_0x8402('0x6a'),_0x211a2f['params']['id'][_0x8402('0x6b')]())['where'](_0x8402('0x70')))[_0x8402('0x71')](_0x8402('0x5c')))[_0x8402('0x6b')]();return db[_0x8402('0x46')][_0x8402('0x2b')](_0x5135b7);}return[];})[_0x8402('0x23')](respondWithResult(_0x28c03e,null))[_0x8402('0x3f')](handleError(_0x28c03e,null));};exports['moveContactsIvrCampaignHopperFinal']=function(_0x3e4baf,_0x4f164c,_0x5114bf){return db[_0x8402('0x72')][_0x8402('0x41')]({'where':{'id':_0x3e4baf[_0x8402('0x45')]['id']}})[_0x8402('0x23')](handleEntityNotFound(_0x4f164c,null))['then'](function(_0x121412){var _0x7a18af;if(_0x121412){_0x7a18af=squel['insert']()[_0x8402('0x58')](_0x8402('0x59'))[_0x8402('0x5a')]([_0x8402('0x5b'),_0x8402('0x61'),_0x8402('0x5c'),_0x8402('0x64'),_0x8402('0x73'),_0x8402('0x5d'),_0x8402('0x5e')],squel['select']()[_0x8402('0x60')](_0x8402('0x74'),_0x8402('0x5b'))[_0x8402('0x60')](_0x8402('0x67'),_0x8402('0x61'))[_0x8402('0x60')]('ANY_VALUE(ContactId)','ContactId')[_0x8402('0x60')](_0x8402('0x63'),'ListId')['field'](_0x8402('0x75'),_0x8402('0x73'))[_0x8402('0x60')](_0x8402('0x67'),_0x8402('0x5d'))[_0x8402('0x60')](_0x8402('0x67'),_0x8402('0x5e'))['from'](_0x8402('0x69'))[_0x8402('0x36')](_0x8402('0x76'),_0x3e4baf['params']['id'][_0x8402('0x6b')]())[_0x8402('0x36')](_0x8402('0x77'),_0x3e4baf[_0x8402('0x43')][_0x8402('0x6c')][_0x8402('0x6b')]())['where'](_0x8402('0x6d'))[_0x8402('0x36')](_0x8402('0x6e'),squel[_0x8402('0x5f')]()[_0x8402('0x60')](_0x8402('0x5b'))[_0x8402('0x68')](_0x8402('0x59'))[_0x8402('0x36')](_0x8402('0x76'),_0x3e4baf['params']['id'][_0x8402('0x6b')]()))[_0x8402('0x36')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0x8402('0x5f')]()[_0x8402('0x60')](_0x8402('0x6f'))[_0x8402('0x68')](_0x8402('0x69'))['where'](_0x8402('0x76'),_0x3e4baf['params']['id'][_0x8402('0x6b')]())['where']('state\x20=\x204'))[_0x8402('0x71')]('ContactId'))[_0x8402('0x6b')]();return db[_0x8402('0x46')]['query'](_0x7a18af);}return[];})[_0x8402('0x23')](respondWithResult(_0x4f164c,null))['catch'](handleError(_0x4f164c,null));};exports['checkContactHopper']=function(_0x397689,_0x3b2d54,_0x2d4e4e){return db[_0x8402('0x78')][_0x8402('0x79')]({'where':{'VoiceQueueId':_0x397689['body'][_0x8402('0x66')],'CampaignId':_0x397689[_0x8402('0x43')]['CampaignId'],'ContactId':_0x397689[_0x8402('0x43')][_0x8402('0x5c')]}})[_0x8402('0x23')](handleEntityNotFound(_0x3b2d54,null))[_0x8402('0x23')](function(_0x2b4cfb){if(_0x2b4cfb){return _0x2b4cfb;}return null;})[_0x8402('0x23')](respondWithResult(_0x3b2d54,null))[_0x8402('0x3f')](handleError(_0x3b2d54,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff