// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xc381=['Content-Range','json','reject','save','update','then','error','stack','name','send','index','CmHopperFinal','rawAttributes','model','keys','query','dateStart','intersection','fields','attributes','length','nolimit','offset','order','sort','filters','pick','dateEnd','day','where','filter','map','merge','options','includeAll','include','findAll','rows','catch','show','params','find','describe','uniqueid','body','countContactsQueueCampaignHopperFinal','sequelize','literal','`state`\x20=\x200,\x201,\x20null','noSuchContacts','noAnswerContacts','COUNT','`state`\x20=\x205,\x201,\x20null','busyContacts','`state`\x20=\x208,\x201,\x20null','`state`\x20=\x2010\x20,\x201,\x20null','`state`\x20=\x2011\x20,\x201,\x20null','abandonedContacts','`state`\x20=\x2022,\x201,\x20null','reCallContacts','countContactsIvrCampaignHopperFinal','`state`\x20=\x203,\x201,\x20null','congestionContacts','dropContacts','moveContactsQueueCampaignHopperFinal','VoiceQueue','insert','into','cm_hopper','scheduledAt','ContactId','ListId','VoiceQueueId','createdAt','updatedAt','field','ANY_VALUE(calleridnum)','phone','NOW()','ANY_VALUE(ContactId)','ANY_VALUE(VoiceQueueId)','from','cm_hopper_final','VoiceQueueId\x20=\x20?','toString','state\x20=\x20?','state','calleridnum\x20IS\x20NOT\x20NULL','calleridnum\x20NOT\x20IN\x20(?)','select','calleridnum','state\x20=\x204','Campaign','fromQuery','CampaignId','ANY_VALUE(ListId)','ANY_VALUE(CampaignId)','CampaignId\x20=\x20?','group','checkContactHopper','CmHopper','findOne','fast-json-patch','util','path','sox','to-csv','ejs','lodash','squel','jsforce','desk.js','querystring','papaparse','../../components/parsers/qs','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','count','limit','set'];(function(_0xacabb,_0x1fbcd9){var _0x2b4a14=function(_0x3a2353){while(--_0x3a2353){_0xacabb['push'](_0xacabb['shift']());}};_0x2b4a14(++_0x1fbcd9);}(_0xc381,0x1da));var _0x1c38=function(_0x3132b0,_0x1e43ce){_0x3132b0=_0x3132b0-0x0;var _0xea4468=_0xc381[_0x3132b0];return _0xea4468;};'use strict';var jsonpatch=require(_0x1c38('0x0'));var rp=require('request-promise');var moment=require('moment');var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x1c38('0x1'));var path=require(_0x1c38('0x2'));var sox=require(_0x1c38('0x3'));var csv=require(_0x1c38('0x4'));var ejs=require(_0x1c38('0x5'));var fs=require('fs');var _=require(_0x1c38('0x6'));var squel=require(_0x1c38('0x7'));var crypto=require('crypto');var jsforce=require(_0x1c38('0x8'));var deskjs=require(_0x1c38('0x9'));var toCsv=require(_0x1c38('0x4'));var querystring=require(_0x1c38('0xa'));var Papa=require(_0x1c38('0xb'));var qs=require(_0x1c38('0xc'));var logger=require('../../config/logger')('api');var utils=require(_0x1c38('0xd'));var config=require(_0x1c38('0xe'));var db=require(_0x1c38('0xf'))['db'];function respondWithStatusCode(_0x4368be,_0x161bbc){_0x161bbc=_0x161bbc||0xcc;return function(_0x69eea1){if(_0x69eea1){return _0x4368be[_0x1c38('0x10')](_0x161bbc);}return _0x4368be[_0x1c38('0x11')](_0x161bbc)[_0x1c38('0x12')]();};}function respondWithResult(_0x4c58f7,_0x3adb2f){_0x3adb2f=_0x3adb2f||0xc8;return function(_0x4c93b8){if(_0x4c93b8){return _0x4c58f7[_0x1c38('0x11')](_0x3adb2f)['json'](_0x4c93b8);}};}function respondWithFilteredResult(_0x21c5c4,_0x4b1eb7){return function(_0x1b36f1){if(_0x1b36f1){var _0xad6c2d=_0x1b36f1[_0x1c38('0x13')],_0x34316d=_0x4b1eb7['offset'],_0x547100=_0x4b1eb7['offset']+_0x4b1eb7[_0x1c38('0x14')],_0x37a3cf;if(_0x547100>=_0xad6c2d){_0x547100=_0xad6c2d;_0x37a3cf=0xc8;}else{_0x37a3cf=0xce;}_0x21c5c4[_0x1c38('0x11')](_0x37a3cf);return _0x21c5c4[_0x1c38('0x15')](_0x1c38('0x16'),_0x34316d+'-'+_0x547100+'/'+_0xad6c2d)[_0x1c38('0x17')](_0x1b36f1);}return null;};}function patchUpdates(_0x1ec4f5){return function(_0x24ced8){try{jsonpatch['apply'](_0x24ced8,_0x1ec4f5,!![]);}catch(_0x319fad){return BPromise[_0x1c38('0x18')](_0x319fad);}return _0x24ced8[_0x1c38('0x19')]();};}function saveUpdates(_0x4028af,_0x5c7fcb){return function(_0x4e600f){if(_0x4e600f){return _0x4e600f[_0x1c38('0x1a')](_0x4028af)[_0x1c38('0x1b')](function(_0x1426eb){return _0x1426eb;});}return null;};}function removeEntity(_0x459cec,_0x20844e){return function(_0xb7b8cd){if(_0xb7b8cd){return _0xb7b8cd['destroy']()[_0x1c38('0x1b')](function(){_0x459cec[_0x1c38('0x11')](0xcc)[_0x1c38('0x12')]();});}};}function handleEntityNotFound(_0x996345,_0x56f302){return function(_0x4d641b){if(!_0x4d641b){_0x996345[_0x1c38('0x10')](0x194);}return _0x4d641b;};}function handleError(_0x5dd8e4,_0x20e9b3){_0x20e9b3=_0x20e9b3||0x1f4;return function(_0x14c6fc){logger[_0x1c38('0x1c')](_0x14c6fc[_0x1c38('0x1d')]);if(_0x14c6fc[_0x1c38('0x1e')]){delete _0x14c6fc[_0x1c38('0x1e')];}_0x5dd8e4[_0x1c38('0x11')](_0x20e9b3)[_0x1c38('0x1f')](_0x14c6fc);};}exports[_0x1c38('0x20')]=function(_0x1e0fd2,_0x1f3d07){var _0x135f3d={},_0xbe1a85={},_0x52fa34={'count':0x0,'rows':[]};var _0x1da232=db[_0x1c38('0x21')][_0x1c38('0x22')];_0xbe1a85[_0x1c38('0x23')]=_[_0x1c38('0x24')](_0x1da232);var _0x13ca36={'dateStart':_0x1e0fd2[_0x1c38('0x25')][_0x1c38('0x26')],'dateEnd':_0x1e0fd2[_0x1c38('0x25')]['dateEnd']};delete _0x1e0fd2[_0x1c38('0x25')][_0x1c38('0x26')];delete _0x1e0fd2[_0x1c38('0x25')]['dateEnd'];_0xbe1a85[_0x1c38('0x25')]=_[_0x1c38('0x24')](_0x1e0fd2[_0x1c38('0x25')]);_0xbe1a85['filters']=_['intersection'](_0xbe1a85[_0x1c38('0x23')],_0xbe1a85[_0x1c38('0x25')]);_0x135f3d['attributes']=_[_0x1c38('0x27')](_0xbe1a85[_0x1c38('0x23')],qs[_0x1c38('0x28')](_0x1e0fd2[_0x1c38('0x25')][_0x1c38('0x28')]));_0x135f3d[_0x1c38('0x29')]=_0x135f3d[_0x1c38('0x29')][_0x1c38('0x2a')]?_0x135f3d[_0x1c38('0x29')]:_0xbe1a85[_0x1c38('0x23')];if(!_0x1e0fd2['query']['hasOwnProperty'](_0x1c38('0x2b'))){_0x135f3d['limit']=qs[_0x1c38('0x14')](_0x1e0fd2[_0x1c38('0x25')][_0x1c38('0x14')]);_0x135f3d[_0x1c38('0x2c')]=qs[_0x1c38('0x2c')](_0x1e0fd2[_0x1c38('0x25')][_0x1c38('0x2c')]);}_0x135f3d[_0x1c38('0x2d')]=qs[_0x1c38('0x2e')](_0x1e0fd2['query'][_0x1c38('0x2e')]);_0x135f3d['where']=qs[_0x1c38('0x2f')](_[_0x1c38('0x30')](_0x1e0fd2[_0x1c38('0x25')],_0xbe1a85['filters']));if(_0x13ca36[_0x1c38('0x26')]){if(_0x13ca36[_0x1c38('0x31')]){_0x13ca36['dateEnd']=moment(_0x13ca36[_0x1c38('0x31')])['add'](0x1,_0x1c38('0x32'));}else{_0x13ca36[_0x1c38('0x31')]=moment(_0x13ca36['dateStart'])['add'](0x1,'day');}_['merge'](_0x135f3d[_0x1c38('0x33')],{'createdAt':{'$gte':_0x13ca36['dateStart'],'$lte':_0x13ca36['dateEnd']}});}if(_0x1e0fd2[_0x1c38('0x25')][_0x1c38('0x34')]){_0x135f3d['where']=_['merge'](_0x135f3d['where'],{'$or':_[_0x1c38('0x35')](_0x135f3d[_0x1c38('0x29')],function(_0x2b0489){var _0x22612b={};_0x22612b[_0x2b0489]={'$like':'%'+_0x1e0fd2[_0x1c38('0x25')][_0x1c38('0x34')]+'%'};return _0x22612b;})});}_0x135f3d=_[_0x1c38('0x36')]({},_0x135f3d,_0x1e0fd2[_0x1c38('0x37')]);var _0x3c5d76={'where':_0x135f3d[_0x1c38('0x33')]};return db[_0x1c38('0x21')][_0x1c38('0x13')](_0x3c5d76)[_0x1c38('0x1b')](function(_0x40c171){_0x52fa34[_0x1c38('0x13')]=_0x40c171;if(_0x1e0fd2['query'][_0x1c38('0x38')]){_0x135f3d[_0x1c38('0x39')]=[{'all':!![]}];}return db[_0x1c38('0x21')][_0x1c38('0x3a')](_0x135f3d);})[_0x1c38('0x1b')](function(_0x3aaec2){_0x52fa34[_0x1c38('0x3b')]=_0x3aaec2;return _0x52fa34;})[_0x1c38('0x1b')](respondWithFilteredResult(_0x1f3d07,_0x135f3d))[_0x1c38('0x3c')](handleError(_0x1f3d07,null));};exports[_0x1c38('0x3d')]=function(_0x25876f,_0x8e2c30){var _0x1d8efc={'raw':!![],'where':{'id':_0x25876f[_0x1c38('0x3e')]['id']}},_0x44c0af={};_0x44c0af[_0x1c38('0x23')]=_[_0x1c38('0x24')](db[_0x1c38('0x21')]['rawAttributes']);_0x44c0af['query']=_[_0x1c38('0x24')](_0x25876f[_0x1c38('0x25')]);_0x44c0af[_0x1c38('0x2f')]=_[_0x1c38('0x27')](_0x44c0af['model'],_0x44c0af['query']);_0x1d8efc[_0x1c38('0x29')]=_[_0x1c38('0x27')](_0x44c0af[_0x1c38('0x23')],qs[_0x1c38('0x28')](_0x25876f[_0x1c38('0x25')][_0x1c38('0x28')]));_0x1d8efc[_0x1c38('0x29')]=_0x1d8efc['attributes'][_0x1c38('0x2a')]?_0x1d8efc[_0x1c38('0x29')]:_0x44c0af['model'];if(_0x25876f[_0x1c38('0x25')][_0x1c38('0x38')]){_0x1d8efc['include']=[{'all':!![]}];}_0x1d8efc=_[_0x1c38('0x36')]({},_0x1d8efc,_0x25876f[_0x1c38('0x37')]);return db[_0x1c38('0x21')][_0x1c38('0x3f')](_0x1d8efc)[_0x1c38('0x1b')](handleEntityNotFound(_0x8e2c30,null))[_0x1c38('0x1b')](respondWithResult(_0x8e2c30,null))['catch'](handleError(_0x8e2c30,null));};exports['describe']=function(_0x43bd80,_0x95ea0){return db[_0x1c38('0x21')][_0x1c38('0x40')]()[_0x1c38('0x1b')](respondWithResult(_0x95ea0,null))[_0x1c38('0x3c')](handleError(_0x95ea0,null));};exports[_0x1c38('0x1a')]=function(_0x53b733,_0x459f96){if(_0x53b733['body'][_0x1c38('0x41')]){delete _0x53b733[_0x1c38('0x42')][_0x1c38('0x41')];}return db[_0x1c38('0x21')][_0x1c38('0x3f')]({'where':{'uniqueid':_0x53b733['params']['id']}})['then'](handleEntityNotFound(_0x459f96,null))[_0x1c38('0x1b')](saveUpdates(_0x53b733['body'],null))['then'](respondWithResult(_0x459f96,null))['catch'](handleError(_0x459f96,null));};exports[_0x1c38('0x43')]=function(_0x542b22,_0x5cd8cb,_0x3a033d){return db[_0x1c38('0x21')]['findAll']({'raw':![],'where':{'VoiceQueueId':_0x542b22[_0x1c38('0x3e')]['id']},'attributes':[[db[_0x1c38('0x44')]['fn']('COUNT',db[_0x1c38('0x44')]['fn']('IF',db['sequelize'][_0x1c38('0x45')](_0x1c38('0x46')))),_0x1c38('0x47')],[db[_0x1c38('0x44')]['fn']('COUNT',db['sequelize']['fn']('IF',db[_0x1c38('0x44')][_0x1c38('0x45')]('`state`\x20=\x203,\x201,\x20null'))),_0x1c38('0x48')],[db[_0x1c38('0x44')]['fn'](_0x1c38('0x49'),db[_0x1c38('0x44')]['fn']('IF',db[_0x1c38('0x44')][_0x1c38('0x45')](_0x1c38('0x4a')))),_0x1c38('0x4b')],[db[_0x1c38('0x44')]['fn']('COUNT',db[_0x1c38('0x44')]['fn']('IF',db[_0x1c38('0x44')]['literal'](_0x1c38('0x4c')))),'congestionContacts'],[db[_0x1c38('0x44')]['fn']('COUNT',db[_0x1c38('0x44')]['fn']('IF',db[_0x1c38('0x44')][_0x1c38('0x45')](_0x1c38('0x4d')))),'dropContacts'],[db[_0x1c38('0x44')]['fn']('COUNT',db[_0x1c38('0x44')]['fn']('IF',db[_0x1c38('0x44')][_0x1c38('0x45')](_0x1c38('0x4e')))),_0x1c38('0x4f')],[db[_0x1c38('0x44')]['fn'](_0x1c38('0x49'),db[_0x1c38('0x44')]['fn']('IF',db[_0x1c38('0x44')][_0x1c38('0x45')](_0x1c38('0x50')))),_0x1c38('0x51')]]})[_0x1c38('0x1b')](handleEntityNotFound(_0x5cd8cb,null))['then'](respondWithResult(_0x5cd8cb,null))['catch'](handleError(_0x5cd8cb,null));};exports[_0x1c38('0x52')]=function(_0x188aba,_0x42d019,_0x2f0e24){return db['CmHopperFinal']['findAll']({'raw':![],'where':{'CampaignId':_0x188aba[_0x1c38('0x3e')]['id']},'attributes':[[db[_0x1c38('0x44')]['fn'](_0x1c38('0x49'),db[_0x1c38('0x44')]['fn']('IF',db['sequelize'][_0x1c38('0x45')](_0x1c38('0x46')))),'noSuchContacts'],[db[_0x1c38('0x44')]['fn'](_0x1c38('0x49'),db[_0x1c38('0x44')]['fn']('IF',db[_0x1c38('0x44')][_0x1c38('0x45')](_0x1c38('0x53')))),_0x1c38('0x48')],[db[_0x1c38('0x44')]['fn'](_0x1c38('0x49'),db[_0x1c38('0x44')]['fn']('IF',db[_0x1c38('0x44')][_0x1c38('0x45')](_0x1c38('0x4a')))),_0x1c38('0x4b')],[db[_0x1c38('0x44')]['fn'](_0x1c38('0x49'),db[_0x1c38('0x44')]['fn']('IF',db[_0x1c38('0x44')]['literal'](_0x1c38('0x4c')))),_0x1c38('0x54')],[db[_0x1c38('0x44')]['fn'](_0x1c38('0x49'),db[_0x1c38('0x44')]['fn']('IF',db[_0x1c38('0x44')]['literal'](_0x1c38('0x4d')))),_0x1c38('0x55')],[db[_0x1c38('0x44')]['fn'](_0x1c38('0x49'),db[_0x1c38('0x44')]['fn']('IF',db[_0x1c38('0x44')][_0x1c38('0x45')]('`state`\x20=\x2011\x20,\x201,\x20null'))),_0x1c38('0x4f')],[db['sequelize']['fn'](_0x1c38('0x49'),db[_0x1c38('0x44')]['fn']('IF',db[_0x1c38('0x44')][_0x1c38('0x45')]('`state`\x20=\x2022,\x201,\x20null'))),_0x1c38('0x51')]]})[_0x1c38('0x1b')](handleEntityNotFound(_0x42d019,null))[_0x1c38('0x1b')](respondWithResult(_0x42d019,null))['catch'](handleError(_0x42d019,null));};exports[_0x1c38('0x56')]=function(_0x1831b9,_0x24470a,_0x4488b6){return db[_0x1c38('0x57')][_0x1c38('0x3f')]({'where':{'id':_0x1831b9[_0x1c38('0x3e')]['id']}})[_0x1c38('0x1b')](handleEntityNotFound(_0x24470a,null))[_0x1c38('0x1b')](function(_0x3e8526){var _0x52c379;if(_0x3e8526){_0x52c379=squel[_0x1c38('0x58')]()[_0x1c38('0x59')](_0x1c38('0x5a'))['fromQuery'](['phone',_0x1c38('0x5b'),_0x1c38('0x5c'),_0x1c38('0x5d'),_0x1c38('0x5e'),_0x1c38('0x5f'),_0x1c38('0x60')],squel['select']()[_0x1c38('0x61')](_0x1c38('0x62'),_0x1c38('0x63'))['field'](_0x1c38('0x64'),_0x1c38('0x5b'))[_0x1c38('0x61')](_0x1c38('0x65'),_0x1c38('0x5c'))['field']('ANY_VALUE(ListId)','ListId')[_0x1c38('0x61')](_0x1c38('0x66'),'VoiceQueueId')['field']('NOW()',_0x1c38('0x5f'))[_0x1c38('0x61')]('NOW()',_0x1c38('0x60'))[_0x1c38('0x67')](_0x1c38('0x68'))[_0x1c38('0x33')](_0x1c38('0x69'),_0x1831b9[_0x1c38('0x3e')]['id'][_0x1c38('0x6a')]())[_0x1c38('0x33')](_0x1c38('0x6b'),_0x1831b9[_0x1c38('0x42')][_0x1c38('0x6c')][_0x1c38('0x6a')]())[_0x1c38('0x33')](_0x1c38('0x6d'))[_0x1c38('0x33')](_0x1c38('0x6e'),squel[_0x1c38('0x6f')]()[_0x1c38('0x61')]('phone')[_0x1c38('0x67')](_0x1c38('0x5a'))['where'](_0x1c38('0x69'),_0x1831b9[_0x1c38('0x3e')]['id']['toString']()))[_0x1c38('0x33')](_0x1c38('0x6e'),squel[_0x1c38('0x6f')]()[_0x1c38('0x61')](_0x1c38('0x70'))[_0x1c38('0x67')]('cm_hopper_final')[_0x1c38('0x33')](_0x1c38('0x69'),_0x1831b9[_0x1c38('0x3e')]['id'][_0x1c38('0x6a')]())[_0x1c38('0x33')](_0x1c38('0x71')))['group'](_0x1c38('0x5c')))[_0x1c38('0x6a')]();return db['sequelize'][_0x1c38('0x25')](_0x52c379);}return[];})[_0x1c38('0x1b')](respondWithResult(_0x24470a,null))[_0x1c38('0x3c')](handleError(_0x24470a,null));};exports['moveContactsIvrCampaignHopperFinal']=function(_0x1108a3,_0x124439,_0x54b348){return db[_0x1c38('0x72')][_0x1c38('0x3f')]({'where':{'id':_0x1108a3[_0x1c38('0x3e')]['id']}})[_0x1c38('0x1b')](handleEntityNotFound(_0x124439,null))[_0x1c38('0x1b')](function(_0x592c22){var _0x5e8281;if(_0x592c22){_0x5e8281=squel[_0x1c38('0x58')]()[_0x1c38('0x59')](_0x1c38('0x5a'))[_0x1c38('0x73')]([_0x1c38('0x63'),_0x1c38('0x5b'),_0x1c38('0x5c'),_0x1c38('0x5d'),_0x1c38('0x74'),_0x1c38('0x5f'),_0x1c38('0x60')],squel['select']()[_0x1c38('0x61')](_0x1c38('0x62'),'phone')[_0x1c38('0x61')]('NOW()',_0x1c38('0x5b'))[_0x1c38('0x61')](_0x1c38('0x65'),'ContactId')['field'](_0x1c38('0x75'),_0x1c38('0x5d'))['field'](_0x1c38('0x76'),'CampaignId')[_0x1c38('0x61')](_0x1c38('0x64'),'createdAt')[_0x1c38('0x61')]('NOW()',_0x1c38('0x60'))[_0x1c38('0x67')]('cm_hopper_final')[_0x1c38('0x33')](_0x1c38('0x77'),_0x1108a3['params']['id']['toString']())[_0x1c38('0x33')](_0x1c38('0x6b'),_0x1108a3[_0x1c38('0x42')][_0x1c38('0x6c')][_0x1c38('0x6a')]())[_0x1c38('0x33')](_0x1c38('0x6d'))[_0x1c38('0x33')]('calleridnum\x20NOT\x20IN\x20(?)',squel['select']()['field']('phone')[_0x1c38('0x67')]('cm_hopper')[_0x1c38('0x33')](_0x1c38('0x77'),_0x1108a3[_0x1c38('0x3e')]['id']['toString']()))[_0x1c38('0x33')]('calleridnum\x20NOT\x20IN\x20(?)',squel['select']()[_0x1c38('0x61')](_0x1c38('0x70'))[_0x1c38('0x67')](_0x1c38('0x68'))[_0x1c38('0x33')]('CampaignId\x20=\x20?',_0x1108a3[_0x1c38('0x3e')]['id'][_0x1c38('0x6a')]())['where'](_0x1c38('0x71')))[_0x1c38('0x78')]('ContactId'))['toString']();return db['sequelize']['query'](_0x5e8281);}return[];})[_0x1c38('0x1b')](respondWithResult(_0x124439,null))[_0x1c38('0x3c')](handleError(_0x124439,null));};exports[_0x1c38('0x79')]=function(_0x528046,_0xf3de9e,_0x50dd86){return db[_0x1c38('0x7a')][_0x1c38('0x7b')]({'where':{'VoiceQueueId':_0x528046[_0x1c38('0x42')][_0x1c38('0x5e')],'CampaignId':_0x528046[_0x1c38('0x42')]['CampaignId'],'ContactId':_0x528046[_0x1c38('0x42')][_0x1c38('0x5c')]}})['then'](handleEntityNotFound(_0xf3de9e,null))['then'](function(_0x76c2a8){if(_0x76c2a8){return _0x76c2a8;}return null;})[_0x1c38('0x1b')](respondWithResult(_0xf3de9e,null))[_0x1c38('0x3c')](handleError(_0xf3de9e,null));};
\ No newline at end of file
+var _0x37ef=['field','ANY_VALUE(calleridnum)','NOW()','scheduledAt','ContactId','ANY_VALUE(ListId)','ANY_VALUE(VoiceQueueId)','updatedAt','cm_hopper_final','VoiceQueueId\x20=\x20?','toString','state\x20=\x20?','body','state','calleridnum\x20IS\x20NOT\x20NULL','calleridnum\x20NOT\x20IN\x20(?)','phone','calleridnum','state\x20=\x204','group','moveContactsIvrCampaignHopperFinal','Campaign','insert','ANY_VALUE(ContactId)','ANY_VALUE(CampaignId)','CampaignId','from','CampaignId\x20=\x20?','checkContactHopper','CmHopper','findOne','eml-format','zip-dir','moment','bluebird','mustache','util','ejs','lodash','crypto','desk.js','to-csv','querystring','papaparse','../../components/parsers/qs','api','../../config/utils','../../config/environment','sendStatus','status','count','offset','limit','set','Content-Range','json','apply','save','then','destroy','end','error','stack','name','send','index','CmHopperFinal','model','keys','query','dateStart','dateEnd','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','add','day','merge','filter','map','options','includeAll','include','rows','catch','show','params','rawAttributes','find','describe','update','uniqueid','findAll','sequelize','COUNT','`state`\x20=\x200,\x201,\x20null','noSuchContacts','literal','`state`\x20=\x203,\x201,\x20null','`state`\x20=\x205,\x201,\x20null','busyContacts','congestionContacts','`state`\x20=\x2011\x20,\x201,\x20null','`state`\x20=\x2022,\x201,\x20null','reCallContacts','countContactsIvrCampaignHopperFinal','noAnswerContacts','`state`\x20=\x208,\x201,\x20null','`state`\x20=\x2010\x20,\x201,\x20null','dropContacts','abandonedContacts','VoiceQueue','into','cm_hopper','fromQuery','ListId','VoiceQueueId','createdAt','select'];(function(_0x1d81f2,_0x1b12ee){var _0x25e516=function(_0x5b0b94){while(--_0x5b0b94){_0x1d81f2['push'](_0x1d81f2['shift']());}};_0x25e516(++_0x1b12ee);}(_0x37ef,0x9d));var _0xf37e=function(_0x4269ba,_0x648fa9){_0x4269ba=_0x4269ba-0x0;var _0xae6f6=_0x37ef[_0x4269ba];return _0xae6f6;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xf37e('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xf37e('0x1'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0xf37e('0x2'));var BPromise=require(_0xf37e('0x3'));var Mustache=require(_0xf37e('0x4'));var util=require(_0xf37e('0x5'));var path=require('path');var sox=require('sox');var csv=require('to-csv');var ejs=require(_0xf37e('0x6'));var fs=require('fs');var _=require(_0xf37e('0x7'));var squel=require('squel');var crypto=require(_0xf37e('0x8'));var jsforce=require('jsforce');var deskjs=require(_0xf37e('0x9'));var toCsv=require(_0xf37e('0xa'));var querystring=require(_0xf37e('0xb'));var Papa=require(_0xf37e('0xc'));var qs=require(_0xf37e('0xd'));var logger=require('../../config/logger')(_0xf37e('0xe'));var utils=require(_0xf37e('0xf'));var config=require(_0xf37e('0x10'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x5c87e0,_0x34b049){_0x34b049=_0x34b049||0xcc;return function(_0x200703){if(_0x200703){return _0x5c87e0[_0xf37e('0x11')](_0x34b049);}return _0x5c87e0[_0xf37e('0x12')](_0x34b049)['end']();};}function respondWithResult(_0x4cbbb2,_0x2dfd93){_0x2dfd93=_0x2dfd93||0xc8;return function(_0x1590db){if(_0x1590db){return _0x4cbbb2['status'](_0x2dfd93)['json'](_0x1590db);}};}function respondWithFilteredResult(_0xa705d,_0x19b401){return function(_0x229ce6){if(_0x229ce6){var _0x386b1a=_0x229ce6[_0xf37e('0x13')],_0x1aaf32=_0x19b401[_0xf37e('0x14')],_0x1c7747=_0x19b401[_0xf37e('0x14')]+_0x19b401[_0xf37e('0x15')],_0x306c1d;if(_0x1c7747>=_0x386b1a){_0x1c7747=_0x386b1a;_0x306c1d=0xc8;}else{_0x306c1d=0xce;}_0xa705d['status'](_0x306c1d);return _0xa705d[_0xf37e('0x16')](_0xf37e('0x17'),_0x1aaf32+'-'+_0x1c7747+'/'+_0x386b1a)[_0xf37e('0x18')](_0x229ce6);}return null;};}function patchUpdates(_0x9a8b8b){return function(_0x190938){try{jsonpatch[_0xf37e('0x19')](_0x190938,_0x9a8b8b,!![]);}catch(_0xa249fa){return BPromise['reject'](_0xa249fa);}return _0x190938[_0xf37e('0x1a')]();};}function saveUpdates(_0x497a96,_0x240a07){return function(_0x89d19a){if(_0x89d19a){return _0x89d19a['update'](_0x497a96)[_0xf37e('0x1b')](function(_0x4f1bd4){return _0x4f1bd4;});}return null;};}function removeEntity(_0x23c8aa,_0x290f0b){return function(_0x178e6f){if(_0x178e6f){return _0x178e6f[_0xf37e('0x1c')]()['then'](function(){_0x23c8aa[_0xf37e('0x12')](0xcc)[_0xf37e('0x1d')]();});}};}function handleEntityNotFound(_0x58d4aa,_0x5e6635){return function(_0x33650e){if(!_0x33650e){_0x58d4aa[_0xf37e('0x11')](0x194);}return _0x33650e;};}function handleError(_0x1101f7,_0x262e1a){_0x262e1a=_0x262e1a||0x1f4;return function(_0x31d4a2){logger[_0xf37e('0x1e')](_0x31d4a2[_0xf37e('0x1f')]);if(_0x31d4a2[_0xf37e('0x20')]){delete _0x31d4a2[_0xf37e('0x20')];}_0x1101f7[_0xf37e('0x12')](_0x262e1a)[_0xf37e('0x21')](_0x31d4a2);};}exports[_0xf37e('0x22')]=function(_0x31917a,_0x181b10){var _0x2669f9={},_0x48e411={},_0x529e2b={'count':0x0,'rows':[]};var _0x1c9107=db[_0xf37e('0x23')]['rawAttributes'];_0x48e411[_0xf37e('0x24')]=_[_0xf37e('0x25')](_0x1c9107);var _0x43b67e={'dateStart':_0x31917a[_0xf37e('0x26')][_0xf37e('0x27')],'dateEnd':_0x31917a[_0xf37e('0x26')][_0xf37e('0x28')]};delete _0x31917a['query'][_0xf37e('0x27')];delete _0x31917a['query'][_0xf37e('0x28')];_0x48e411[_0xf37e('0x26')]=_[_0xf37e('0x25')](_0x31917a['query']);_0x48e411[_0xf37e('0x29')]=_[_0xf37e('0x2a')](_0x48e411[_0xf37e('0x24')],_0x48e411['query']);_0x2669f9[_0xf37e('0x2b')]=_[_0xf37e('0x2a')](_0x48e411[_0xf37e('0x24')],qs['fields'](_0x31917a[_0xf37e('0x26')][_0xf37e('0x2c')]));_0x2669f9[_0xf37e('0x2b')]=_0x2669f9[_0xf37e('0x2b')][_0xf37e('0x2d')]?_0x2669f9[_0xf37e('0x2b')]:_0x48e411['model'];if(!_0x31917a[_0xf37e('0x26')][_0xf37e('0x2e')](_0xf37e('0x2f'))){_0x2669f9[_0xf37e('0x15')]=qs[_0xf37e('0x15')](_0x31917a[_0xf37e('0x26')][_0xf37e('0x15')]);_0x2669f9[_0xf37e('0x14')]=qs[_0xf37e('0x14')](_0x31917a['query'][_0xf37e('0x14')]);}_0x2669f9[_0xf37e('0x30')]=qs[_0xf37e('0x31')](_0x31917a['query'][_0xf37e('0x31')]);_0x2669f9[_0xf37e('0x32')]=qs['filters'](_['pick'](_0x31917a[_0xf37e('0x26')],_0x48e411['filters']));if(_0x43b67e[_0xf37e('0x27')]){if(_0x43b67e['dateEnd']){_0x43b67e[_0xf37e('0x28')]=moment(_0x43b67e[_0xf37e('0x28')])[_0xf37e('0x33')](0x1,_0xf37e('0x34'));}else{_0x43b67e[_0xf37e('0x28')]=moment(_0x43b67e['dateStart'])[_0xf37e('0x33')](0x1,_0xf37e('0x34'));}_[_0xf37e('0x35')](_0x2669f9['where'],{'createdAt':{'$gte':_0x43b67e[_0xf37e('0x27')],'$lte':_0x43b67e[_0xf37e('0x28')]}});}if(_0x31917a[_0xf37e('0x26')][_0xf37e('0x36')]){_0x2669f9[_0xf37e('0x32')]=_[_0xf37e('0x35')](_0x2669f9['where'],{'$or':_[_0xf37e('0x37')](_0x2669f9[_0xf37e('0x2b')],function(_0x284c24){var _0x5994b6={};_0x5994b6[_0x284c24]={'$like':'%'+_0x31917a[_0xf37e('0x26')][_0xf37e('0x36')]+'%'};return _0x5994b6;})});}_0x2669f9=_['merge']({},_0x2669f9,_0x31917a[_0xf37e('0x38')]);var _0x4d3dec={'where':_0x2669f9['where']};return db[_0xf37e('0x23')][_0xf37e('0x13')](_0x4d3dec)[_0xf37e('0x1b')](function(_0x4dcdd2){_0x529e2b[_0xf37e('0x13')]=_0x4dcdd2;if(_0x31917a['query'][_0xf37e('0x39')]){_0x2669f9[_0xf37e('0x3a')]=[{'all':!![]}];}return db[_0xf37e('0x23')]['findAll'](_0x2669f9);})[_0xf37e('0x1b')](function(_0x306010){_0x529e2b[_0xf37e('0x3b')]=_0x306010;return _0x529e2b;})[_0xf37e('0x1b')](respondWithFilteredResult(_0x181b10,_0x2669f9))[_0xf37e('0x3c')](handleError(_0x181b10,null));};exports[_0xf37e('0x3d')]=function(_0x5961ed,_0x3841e7){var _0x1b5ecc={'raw':!![],'where':{'id':_0x5961ed[_0xf37e('0x3e')]['id']}},_0x40f1bc={};_0x40f1bc[_0xf37e('0x24')]=_['keys'](db[_0xf37e('0x23')][_0xf37e('0x3f')]);_0x40f1bc[_0xf37e('0x26')]=_[_0xf37e('0x25')](_0x5961ed[_0xf37e('0x26')]);_0x40f1bc['filters']=_[_0xf37e('0x2a')](_0x40f1bc['model'],_0x40f1bc['query']);_0x1b5ecc[_0xf37e('0x2b')]=_[_0xf37e('0x2a')](_0x40f1bc[_0xf37e('0x24')],qs[_0xf37e('0x2c')](_0x5961ed[_0xf37e('0x26')][_0xf37e('0x2c')]));_0x1b5ecc[_0xf37e('0x2b')]=_0x1b5ecc[_0xf37e('0x2b')][_0xf37e('0x2d')]?_0x1b5ecc[_0xf37e('0x2b')]:_0x40f1bc[_0xf37e('0x24')];if(_0x5961ed['query'][_0xf37e('0x39')]){_0x1b5ecc['include']=[{'all':!![]}];}_0x1b5ecc=_[_0xf37e('0x35')]({},_0x1b5ecc,_0x5961ed[_0xf37e('0x38')]);return db[_0xf37e('0x23')][_0xf37e('0x40')](_0x1b5ecc)[_0xf37e('0x1b')](handleEntityNotFound(_0x3841e7,null))['then'](respondWithResult(_0x3841e7,null))[_0xf37e('0x3c')](handleError(_0x3841e7,null));};exports['describe']=function(_0x347739,_0x223477){return db['CmHopperFinal'][_0xf37e('0x41')]()[_0xf37e('0x1b')](respondWithResult(_0x223477,null))['catch'](handleError(_0x223477,null));};exports[_0xf37e('0x42')]=function(_0x5c9c4c,_0x2ed043){if(_0x5c9c4c['body'][_0xf37e('0x43')]){delete _0x5c9c4c['body'][_0xf37e('0x43')];}return db[_0xf37e('0x23')]['find']({'where':{'uniqueid':_0x5c9c4c[_0xf37e('0x3e')]['id']}})[_0xf37e('0x1b')](handleEntityNotFound(_0x2ed043,null))[_0xf37e('0x1b')](saveUpdates(_0x5c9c4c['body'],null))[_0xf37e('0x1b')](respondWithResult(_0x2ed043,null))['catch'](handleError(_0x2ed043,null));};exports['countContactsQueueCampaignHopperFinal']=function(_0x4b2e67,_0x150550,_0x430dda){return db['CmHopperFinal'][_0xf37e('0x44')]({'raw':![],'where':{'VoiceQueueId':_0x4b2e67[_0xf37e('0x3e')]['id']},'attributes':[[db[_0xf37e('0x45')]['fn'](_0xf37e('0x46'),db[_0xf37e('0x45')]['fn']('IF',db[_0xf37e('0x45')]['literal'](_0xf37e('0x47')))),_0xf37e('0x48')],[db[_0xf37e('0x45')]['fn'](_0xf37e('0x46'),db[_0xf37e('0x45')]['fn']('IF',db[_0xf37e('0x45')][_0xf37e('0x49')](_0xf37e('0x4a')))),'noAnswerContacts'],[db['sequelize']['fn'](_0xf37e('0x46'),db['sequelize']['fn']('IF',db[_0xf37e('0x45')]['literal'](_0xf37e('0x4b')))),_0xf37e('0x4c')],[db[_0xf37e('0x45')]['fn']('COUNT',db[_0xf37e('0x45')]['fn']('IF',db[_0xf37e('0x45')]['literal']('`state`\x20=\x208,\x201,\x20null'))),_0xf37e('0x4d')],[db['sequelize']['fn'](_0xf37e('0x46'),db['sequelize']['fn']('IF',db['sequelize']['literal']('`state`\x20=\x2010\x20,\x201,\x20null'))),'dropContacts'],[db[_0xf37e('0x45')]['fn'](_0xf37e('0x46'),db[_0xf37e('0x45')]['fn']('IF',db[_0xf37e('0x45')][_0xf37e('0x49')](_0xf37e('0x4e')))),'abandonedContacts'],[db[_0xf37e('0x45')]['fn']('COUNT',db[_0xf37e('0x45')]['fn']('IF',db['sequelize']['literal'](_0xf37e('0x4f')))),_0xf37e('0x50')]]})[_0xf37e('0x1b')](handleEntityNotFound(_0x150550,null))[_0xf37e('0x1b')](respondWithResult(_0x150550,null))[_0xf37e('0x3c')](handleError(_0x150550,null));};exports[_0xf37e('0x51')]=function(_0x547cc8,_0x44074f,_0x5c7d93){return db[_0xf37e('0x23')]['findAll']({'raw':![],'where':{'CampaignId':_0x547cc8[_0xf37e('0x3e')]['id']},'attributes':[[db['sequelize']['fn']('COUNT',db[_0xf37e('0x45')]['fn']('IF',db['sequelize'][_0xf37e('0x49')](_0xf37e('0x47')))),_0xf37e('0x48')],[db['sequelize']['fn'](_0xf37e('0x46'),db[_0xf37e('0x45')]['fn']('IF',db[_0xf37e('0x45')]['literal']('`state`\x20=\x203,\x201,\x20null'))),_0xf37e('0x52')],[db[_0xf37e('0x45')]['fn'](_0xf37e('0x46'),db[_0xf37e('0x45')]['fn']('IF',db[_0xf37e('0x45')][_0xf37e('0x49')](_0xf37e('0x4b')))),_0xf37e('0x4c')],[db[_0xf37e('0x45')]['fn']('COUNT',db['sequelize']['fn']('IF',db[_0xf37e('0x45')][_0xf37e('0x49')](_0xf37e('0x53')))),_0xf37e('0x4d')],[db[_0xf37e('0x45')]['fn'](_0xf37e('0x46'),db[_0xf37e('0x45')]['fn']('IF',db[_0xf37e('0x45')][_0xf37e('0x49')](_0xf37e('0x54')))),_0xf37e('0x55')],[db[_0xf37e('0x45')]['fn'](_0xf37e('0x46'),db[_0xf37e('0x45')]['fn']('IF',db['sequelize']['literal'](_0xf37e('0x4e')))),_0xf37e('0x56')],[db[_0xf37e('0x45')]['fn'](_0xf37e('0x46'),db[_0xf37e('0x45')]['fn']('IF',db['sequelize']['literal'](_0xf37e('0x4f')))),_0xf37e('0x50')]]})[_0xf37e('0x1b')](handleEntityNotFound(_0x44074f,null))[_0xf37e('0x1b')](respondWithResult(_0x44074f,null))['catch'](handleError(_0x44074f,null));};exports['moveContactsQueueCampaignHopperFinal']=function(_0x3a86eb,_0x149300,_0x2d7a79){return db[_0xf37e('0x57')][_0xf37e('0x40')]({'where':{'id':_0x3a86eb[_0xf37e('0x3e')]['id']}})[_0xf37e('0x1b')](handleEntityNotFound(_0x149300,null))[_0xf37e('0x1b')](function(_0x1036fa){var _0x1d1775;if(_0x1036fa){_0x1d1775=squel['insert']()[_0xf37e('0x58')](_0xf37e('0x59'))[_0xf37e('0x5a')](['phone','scheduledAt','ContactId',_0xf37e('0x5b'),_0xf37e('0x5c'),_0xf37e('0x5d'),'updatedAt'],squel[_0xf37e('0x5e')]()[_0xf37e('0x5f')](_0xf37e('0x60'),'phone')[_0xf37e('0x5f')](_0xf37e('0x61'),_0xf37e('0x62'))['field']('ANY_VALUE(ContactId)',_0xf37e('0x63'))[_0xf37e('0x5f')](_0xf37e('0x64'),_0xf37e('0x5b'))['field'](_0xf37e('0x65'),_0xf37e('0x5c'))['field'](_0xf37e('0x61'),_0xf37e('0x5d'))[_0xf37e('0x5f')]('NOW()',_0xf37e('0x66'))['from'](_0xf37e('0x67'))[_0xf37e('0x32')](_0xf37e('0x68'),_0x3a86eb[_0xf37e('0x3e')]['id'][_0xf37e('0x69')]())[_0xf37e('0x32')](_0xf37e('0x6a'),_0x3a86eb[_0xf37e('0x6b')][_0xf37e('0x6c')]['toString']())[_0xf37e('0x32')](_0xf37e('0x6d'))[_0xf37e('0x32')](_0xf37e('0x6e'),squel[_0xf37e('0x5e')]()[_0xf37e('0x5f')](_0xf37e('0x6f'))['from']('cm_hopper')['where']('VoiceQueueId\x20=\x20?',_0x3a86eb[_0xf37e('0x3e')]['id'][_0xf37e('0x69')]()))[_0xf37e('0x32')](_0xf37e('0x6e'),squel['select']()['field'](_0xf37e('0x70'))['from'](_0xf37e('0x67'))['where'](_0xf37e('0x68'),_0x3a86eb[_0xf37e('0x3e')]['id']['toString']())['where'](_0xf37e('0x71')))[_0xf37e('0x72')](_0xf37e('0x63')))[_0xf37e('0x69')]();return db['sequelize']['query'](_0x1d1775);}return[];})[_0xf37e('0x1b')](respondWithResult(_0x149300,null))[_0xf37e('0x3c')](handleError(_0x149300,null));};exports[_0xf37e('0x73')]=function(_0x52e859,_0xc5ffa3,_0x567e87){return db[_0xf37e('0x74')]['find']({'where':{'id':_0x52e859[_0xf37e('0x3e')]['id']}})[_0xf37e('0x1b')](handleEntityNotFound(_0xc5ffa3,null))['then'](function(_0x10ed82){var _0x16e06a;if(_0x10ed82){_0x16e06a=squel[_0xf37e('0x75')]()['into']('cm_hopper')[_0xf37e('0x5a')]([_0xf37e('0x6f'),_0xf37e('0x62'),_0xf37e('0x63'),_0xf37e('0x5b'),'CampaignId','createdAt',_0xf37e('0x66')],squel[_0xf37e('0x5e')]()['field'](_0xf37e('0x60'),_0xf37e('0x6f'))['field'](_0xf37e('0x61'),'scheduledAt')['field'](_0xf37e('0x76'),_0xf37e('0x63'))[_0xf37e('0x5f')]('ANY_VALUE(ListId)','ListId')[_0xf37e('0x5f')](_0xf37e('0x77'),_0xf37e('0x78'))[_0xf37e('0x5f')](_0xf37e('0x61'),_0xf37e('0x5d'))[_0xf37e('0x5f')](_0xf37e('0x61'),_0xf37e('0x66'))[_0xf37e('0x79')](_0xf37e('0x67'))[_0xf37e('0x32')](_0xf37e('0x7a'),_0x52e859[_0xf37e('0x3e')]['id'][_0xf37e('0x69')]())[_0xf37e('0x32')](_0xf37e('0x6a'),_0x52e859[_0xf37e('0x6b')]['state'][_0xf37e('0x69')]())[_0xf37e('0x32')]('calleridnum\x20IS\x20NOT\x20NULL')['where'](_0xf37e('0x6e'),squel[_0xf37e('0x5e')]()[_0xf37e('0x5f')](_0xf37e('0x6f'))[_0xf37e('0x79')](_0xf37e('0x59'))[_0xf37e('0x32')](_0xf37e('0x7a'),_0x52e859[_0xf37e('0x3e')]['id'][_0xf37e('0x69')]()))[_0xf37e('0x32')](_0xf37e('0x6e'),squel['select']()[_0xf37e('0x5f')]('calleridnum')[_0xf37e('0x79')](_0xf37e('0x67'))[_0xf37e('0x32')](_0xf37e('0x7a'),_0x52e859['params']['id'][_0xf37e('0x69')]())['where']('state\x20=\x204'))[_0xf37e('0x72')](_0xf37e('0x63')))[_0xf37e('0x69')]();return db['sequelize'][_0xf37e('0x26')](_0x16e06a);}return[];})[_0xf37e('0x1b')](respondWithResult(_0xc5ffa3,null))[_0xf37e('0x3c')](handleError(_0xc5ffa3,null));};exports[_0xf37e('0x7b')]=function(_0x162a38,_0x2b3ac7,_0x1f619f){return db[_0xf37e('0x7c')][_0xf37e('0x7d')]({'where':{'VoiceQueueId':_0x162a38[_0xf37e('0x6b')][_0xf37e('0x5c')],'CampaignId':_0x162a38[_0xf37e('0x6b')]['CampaignId'],'ContactId':_0x162a38[_0xf37e('0x6b')][_0xf37e('0x63')]}})['then'](handleEntityNotFound(_0x2b3ac7,null))['then'](function(_0xbeb151){if(_0xbeb151){return _0xbeb151;}return null;})[_0xf37e('0x1b')](respondWithResult(_0x2b3ac7,null))[_0xf37e('0x3c')](handleError(_0x2b3ac7,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff