// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xd3dd=['ListId','c.ListId\x20IN\x20?','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','isArray','replace','\x27\x27\x27\x27','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','group','c.id','Sequelize','order','DESC','having','resolve','some','user','getLists','c.ListId\x20IS\x20NULL','toString','keyBy','c.phone','c.mobile','c.fax','c.email','c.ListId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','sequelize','Tags','catch','params','columnName','findAll','displayName','alias','values','merge','body','mergeWith','tags','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailMessage','MailInteraction','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','CmHopperFinal','CmHopperHistory','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','JscriptySessionReport','bulkCreate','each','duplicates','$or','show','Tag','get','$and','omit','cf_%d','pickBy','format','cm_contacts','id\x20=\x20?','toParam','phone','rawAttributes','filter','options','getTags','setTags','ids','getHoppers','includeAll','include','rows','getHopperHistories','ContactId','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','zipObject','No\x20firstName\x20column\x20specified','root','server/files/tmp','file','filename','chmodSync','0777','child_process','../../components/import/cm/csv','CompanyId','socket_timestamp','File\x20uploaded\x20correctly!','pid','createReadStream','parse','meta','import','No\x20phone\x20column\x20specified','binding','fork','../../components/import/cm/csv2','stringify','message','exit','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','register','sendStatus','status','end','json','count','offset','limit','set','apply','reject','save','update','then','destroy','error','stack','name','send','index','CmContact','describe','keys','length','startsWith','cf_','push','CmCustomField','findOne','trimStart','type','model','query','intersection','fields','attributes','nolimit','sort','where','filters','pick','select','field','color','from','tools_tags','left_join','uc.CmContactId\x20=\x20c.id','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','expr','search','parseSearch','conditions','find','value','split','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','and','uc.UserId\x20=\x20?','fieldType','castTo','DATE','buildExpression','text','start','hasOwnProperty','isNil','Contact','isEmpty'];(function(_0x3e5086,_0x48f4a2){var _0xfeb102=function(_0x5a945f){while(--_0x5a945f){_0x3e5086['push'](_0x3e5086['shift']());}};_0xfeb102(++_0x48f4a2);}(_0xd3dd,0x89));var _0xdd3d=function(_0x5231c7,_0x5325f7){_0x5231c7=_0x5231c7-0x0;var _0x85f5e5=_0xd3dd[_0x5231c7];return _0x85f5e5;};'use strict';var pdf=require(_0xdd3d('0x0'));var emlformat=require('eml-format');var rimraf=require(_0xdd3d('0x1'));var zipdir=require(_0xdd3d('0x2'));var jsonpatch=require(_0xdd3d('0x3'));var rp=require(_0xdd3d('0x4'));var moment=require('moment');var BPromise=require(_0xdd3d('0x5'));var Mustache=require(_0xdd3d('0x6'));var util=require(_0xdd3d('0x7'));var path=require(_0xdd3d('0x8'));var sox=require(_0xdd3d('0x9'));var csv=require(_0xdd3d('0xa'));var ejs=require(_0xdd3d('0xb'));var fs=require('fs');var _=require(_0xdd3d('0xc'));var squel=require(_0xdd3d('0xd'));var crypto=require('crypto');var jsforce=require(_0xdd3d('0xe'));var deskjs=require(_0xdd3d('0xf'));var toCsv=require(_0xdd3d('0xa'));var querystring=require(_0xdd3d('0x10'));var Papa=require(_0xdd3d('0x11'));var Redis=require(_0xdd3d('0x12'));var authService=require(_0xdd3d('0x13'));var qs=require(_0xdd3d('0x14'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xdd3d('0x15'));var logger=require(_0xdd3d('0x16'))(_0xdd3d('0x17'));var utils=require(_0xdd3d('0x18'));var config=require(_0xdd3d('0x19'));var db=require(_0xdd3d('0x1a'))['db'];config[_0xdd3d('0x1b')]=_[_0xdd3d('0x1c')](config[_0xdd3d('0x1b')],{'host':_0xdd3d('0x1d'),'port':0x18eb});var socket=require(_0xdd3d('0x1e'))(new Redis(config[_0xdd3d('0x1b')]));require('./cmContact.socket')[_0xdd3d('0x1f')](socket);function respondWithStatusCode(_0x3f5c1a,_0x1476b4){_0x1476b4=_0x1476b4||0xcc;return function(_0x2c7d12){if(_0x2c7d12){return _0x3f5c1a[_0xdd3d('0x20')](_0x1476b4);}return _0x3f5c1a[_0xdd3d('0x21')](_0x1476b4)[_0xdd3d('0x22')]();};}function respondWithResult(_0x43bfd6,_0x5587f7){_0x5587f7=_0x5587f7||0xc8;return function(_0x1644b3){if(_0x1644b3){return _0x43bfd6[_0xdd3d('0x21')](_0x5587f7)[_0xdd3d('0x23')](_0x1644b3);}};}function respondWithFilteredResult(_0x15efd4,_0x34f903){return function(_0x298ac9){if(_0x298ac9){var _0x4379b5=_0x298ac9[_0xdd3d('0x24')],_0x801fe9=_0x34f903[_0xdd3d('0x25')],_0x5d5b15=_0x34f903[_0xdd3d('0x25')]+_0x34f903[_0xdd3d('0x26')],_0x2c6c72;if(_0x5d5b15>=_0x4379b5){_0x5d5b15=_0x4379b5;_0x2c6c72=0xc8;}else{_0x2c6c72=0xce;}_0x15efd4[_0xdd3d('0x21')](_0x2c6c72);return _0x15efd4[_0xdd3d('0x27')]('Content-Range',_0x801fe9+'-'+_0x5d5b15+'/'+_0x4379b5)[_0xdd3d('0x23')](_0x298ac9);}return null;};}function patchUpdates(_0x4e0101){return function(_0x56d647){try{jsonpatch[_0xdd3d('0x28')](_0x56d647,_0x4e0101,!![]);}catch(_0x58fba1){return BPromise[_0xdd3d('0x29')](_0x58fba1);}return _0x56d647[_0xdd3d('0x2a')]();};}function saveUpdates(_0x237f46,_0x1f3104){return function(_0x45b5cf){if(_0x45b5cf){return _0x45b5cf[_0xdd3d('0x2b')](_0x237f46)[_0xdd3d('0x2c')](function(_0x30c08c){return _0x30c08c;});}return null;};}function removeEntity(_0x301527,_0x5838e6){return function(_0x29c68d){if(_0x29c68d){return _0x29c68d[_0xdd3d('0x2d')]()['then'](function(){_0x301527[_0xdd3d('0x21')](0xcc)[_0xdd3d('0x22')]();});}};}function handleEntityNotFound(_0x38b99e,_0x16ae4f){return function(_0x44df9d){if(!_0x44df9d){_0x38b99e[_0xdd3d('0x20')](0x194);}return _0x44df9d;};}function handleError(_0x133641,_0x1605c4){_0x1605c4=_0x1605c4||0x1f4;return function(_0x157456){logger[_0xdd3d('0x2e')](_0x157456[_0xdd3d('0x2f')]);if(_0x157456[_0xdd3d('0x30')]){delete _0x157456['name'];}_0x133641[_0xdd3d('0x21')](_0x1605c4)[_0xdd3d('0x31')](_0x157456);};}exports[_0xdd3d('0x32')]=function(_0x592521,_0x589b40){var _0x20a989={},_0x232c10={},_0x1fe84c={'count':0x0,'rows':[]};return db[_0xdd3d('0x33')][_0xdd3d('0x34')]()[_0xdd3d('0x2c')](function(_0x26e5af){var _0xe0550c=[];for(var _0x1ddd87=0x0;_0x1ddd87<Object[_0xdd3d('0x35')](_0x26e5af)[_0xdd3d('0x36')];_0x1ddd87++){var _0x452ec3=Object['keys'](_0x26e5af)[_0x1ddd87];if(_[_0xdd3d('0x37')](_0x452ec3,_0xdd3d('0x38'))){_0xe0550c[_0xdd3d('0x39')](db[_0xdd3d('0x3a')][_0xdd3d('0x3b')]({'where':{'id':_[_0xdd3d('0x3c')](_0x452ec3,'cf_')},'raw':!![]}));}}return BPromise['all'](_0xe0550c)[_0xdd3d('0x2c')](function(_0x2e46f9){for(var _0x19fea1=0x0;_0x19fea1<_0x2e46f9[_0xdd3d('0x36')];_0x19fea1++){if(_0x2e46f9[_0x19fea1]){var _0x4c6ab9=_0xdd3d('0x38')+_0x2e46f9[_0x19fea1]['id'];var _0x14efbc=_0x26e5af[_0x4c6ab9];_0x14efbc['fieldType']=_0x2e46f9[_0x19fea1][_0xdd3d('0x3d')];}}return _0x26e5af;});})['then'](function(_0x428860){_0x232c10[_0xdd3d('0x3e')]=_[_0xdd3d('0x35')](_0x428860);_0x232c10['query']=_[_0xdd3d('0x35')](_0x592521['query']);_0x232c10['filters']=_['intersection'](_0x232c10[_0xdd3d('0x3e')],_0x232c10[_0xdd3d('0x3f')]);_0x20a989['attributes']=_[_0xdd3d('0x40')](_0x232c10[_0xdd3d('0x3e')],qs[_0xdd3d('0x41')](_0x592521[_0xdd3d('0x3f')][_0xdd3d('0x41')]));_0x20a989['attributes']=_0x20a989['attributes'][_0xdd3d('0x36')]?_0x20a989[_0xdd3d('0x42')]:_0x232c10[_0xdd3d('0x3e')];if(!_0x592521[_0xdd3d('0x3f')]['hasOwnProperty'](_0xdd3d('0x43'))){_0x20a989['limit']=qs[_0xdd3d('0x26')](_0x592521[_0xdd3d('0x3f')][_0xdd3d('0x26')]);_0x20a989[_0xdd3d('0x25')]=qs[_0xdd3d('0x25')](_0x592521[_0xdd3d('0x3f')][_0xdd3d('0x25')]);}_0x20a989['order']=qs['sort'](_0x592521[_0xdd3d('0x3f')][_0xdd3d('0x44')]);_0x20a989[_0xdd3d('0x45')]=qs[_0xdd3d('0x46')](_[_0xdd3d('0x47')](_0x592521[_0xdd3d('0x3f')],_0x232c10[_0xdd3d('0x46')]),_0x428860);var _0x30726e=[];var _0x33abac=squel[_0xdd3d('0x48')]()[_0xdd3d('0x49')]('id')[_0xdd3d('0x49')](_0xdd3d('0x30'))[_0xdd3d('0x49')](_0xdd3d('0x4a'))[_0xdd3d('0x4b')](_0xdd3d('0x4c'));var _0x308e21=squel[_0xdd3d('0x48')]()[_0xdd3d('0x4b')]('cm_contacts','c')[_0xdd3d('0x4d')]('cm_user_has_contacts','uc',_0xdd3d('0x4e'))[_0xdd3d('0x4d')]('cm_contact_has_tags','ct',_0xdd3d('0x4f'))[_0xdd3d('0x4d')](_0xdd3d('0x4c'),'t',_0xdd3d('0x50'))[_0xdd3d('0x45')]('c.deletedAt\x20IS\x20NULL');var _0x5e251c=squel[_0xdd3d('0x51')]();var _0x28a2d4=[];var _0x15d12f=squel[_0xdd3d('0x51')]();var _0x5caff2;if(_0x592521[_0xdd3d('0x3f')][_0xdd3d('0x52')]){_0x5caff2=as[_0xdd3d('0x53')](_0x592521['query'][_0xdd3d('0x52')]);var _0x32e94b=_0x5caff2['sqlOperator'];for(var _0x119731=0x0;_0x119731<_0x5caff2[_0xdd3d('0x54')]['length'];_0x119731++){var _0x3da1ca=_0x5caff2['conditions'][_0x119731];var _0x2fad0f='c';var _0x242e76=_(_0x428860)[_0xdd3d('0x35')]()[_0xdd3d('0x55')](function(_0x3bef5b){return _0x3bef5b===_0x3da1ca[_0xdd3d('0x49')];});if(_0x242e76)_0x242e76=_0x428860[_0x3da1ca['field']];if(!_0x242e76){if(_0x3da1ca[_0xdd3d('0x49')]==='Tag'){var _0x34453d=_0x3da1ca[_0xdd3d('0x56')][_0xdd3d('0x57')](',')[_0xdd3d('0x58')](function(_0x409c7d){return Number(_0x409c7d);});_0x34453d[_0xdd3d('0x59')](function(_0x5cce7d){_0x15d12f['or'](_0xdd3d('0x5a'),'%,'+_0x5cce7d+',%');});_0x28a2d4=_[_0xdd3d('0x5b')](_0x28a2d4,_0x34453d);}else if(_0x3da1ca[_0xdd3d('0x49')]===_0xdd3d('0x5c')){_0x5e251c[_0xdd3d('0x5d')](_0xdd3d('0x5e'),_0x3da1ca[_0xdd3d('0x56')]);}}else{if(_0x3da1ca[_0xdd3d('0x49')]==='dateOfBirth'||_0x242e76[_0xdd3d('0x5f')]==='datetime')_0x3da1ca[_0xdd3d('0x60')]=_0xdd3d('0x61');var _0x47f7a0=as[_0xdd3d('0x62')](_0x2fad0f,_0x242e76['type'],_0x3da1ca);_0x5e251c[_0x32e94b](_0x47f7a0[_0xdd3d('0x63')],_0x47f7a0['value'][_0xdd3d('0x64')],_0x47f7a0[_0xdd3d('0x56')][_0xdd3d('0x22')]);}}}else{var _0x2417f3=_(Object[_0xdd3d('0x35')](_0x592521[_0xdd3d('0x3f')]))[_0xdd3d('0x58')](function(_0x3b511b){return _0x428860[_0xdd3d('0x65')](_0x3b511b)?_0x3b511b:undefined;})['filter'](function(_0x2b0439){return!_[_0xdd3d('0x66')](_0x2b0439);})[_0xdd3d('0x56')]();if(_0x592521[_0xdd3d('0x3f')][_0xdd3d('0x67')])_0x2417f3['push'](_0xdd3d('0x67'));if(!_[_0xdd3d('0x68')](_0x2417f3)){_0x2417f3[_0xdd3d('0x59')](function(_0x57eae5){if(_0x57eae5===_0xdd3d('0x69')){_0x308e21[_0xdd3d('0x45')](_0xdd3d('0x6a'),[][_0xdd3d('0x6b')](_0x592521[_0xdd3d('0x3f')][_0x57eae5]));}else if(_0x57eae5===_0xdd3d('0x67')){var _0x353413='%'+_0x592521[_0xdd3d('0x3f')][_0x57eae5]+'%';_0x308e21['where'](_0xdd3d('0x6c'),_0x353413);}else{_0x308e21[_0xdd3d('0x45')]('c.'+_0x57eae5+_0xdd3d('0x6d'),_0x592521[_0xdd3d('0x3f')][_0x57eae5]);}});}if(_0x592521['query'][_0xdd3d('0x6e')]){_0x28a2d4=_[_0xdd3d('0x6f')](_0x592521[_0xdd3d('0x3f')][_0xdd3d('0x6e')])?_0x592521[_0xdd3d('0x3f')][_0xdd3d('0x6e')]:new Array(_0x592521[_0xdd3d('0x3f')][_0xdd3d('0x6e')]);_0x28a2d4[_0xdd3d('0x59')](function(_0x3dd5e2){_0x15d12f['or'](_0xdd3d('0x5a'),'%,'+_0x3dd5e2+',%');});}if(_0x592521[_0xdd3d('0x3f')]['filter']){var _0x2e7459=_0x592521[_0xdd3d('0x3f')]['filter'][_0xdd3d('0x70')]('\x5c','\x5c\x5c')[_0xdd3d('0x70')]('\x27\x27',_0xdd3d('0x71'));if(_0x2e7459[_0xdd3d('0x57')]('\x20')['length']>0x1){_0x5e251c['or'](_0xdd3d('0x72'),qs[_0xdd3d('0x73')](_0x2e7459),null);}else{if(qs['isNumeric'](_0x2e7459)){_0x5e251c['or'](_0xdd3d('0x74'),_0x2e7459+'%');_0x5e251c['or'](_0xdd3d('0x75'),_0x2e7459+'%');_0x5e251c['or'](_0xdd3d('0x76'),_0x2e7459+'%');_0x5e251c['or'](_0xdd3d('0x77'),_0x2e7459+'%');}else if(qs[_0xdd3d('0x78')](_0x2e7459)){_0x5e251c['or'](_0xdd3d('0x79'),_0x2e7459+'%');}else{_0x5e251c['or'](_0xdd3d('0x7a'),'%'+_0x2e7459+'%');_0x5e251c['or'](_0xdd3d('0x7b'),'%'+_0x2e7459+'%');_0x5e251c['or'](_0xdd3d('0x79'),'%'+_0x2e7459+'%');}}}}_0x308e21['where'](_0x5e251c);_0x308e21[_0xdd3d('0x7c')](_0xdd3d('0x7d'));var _0xdef8db={'type':db[_0xdd3d('0x7e')]['QueryTypes']['SELECT'],'raw':!![]};var _0x1939be=_0x308e21['clone']()[_0xdd3d('0x49')](_0xdd3d('0x7d'));if(_0x20a989[_0xdd3d('0x7f')]){_0x20a989[_0xdd3d('0x7f')][_0xdd3d('0x59')](function(_0x304d4f){_0x308e21[_0xdd3d('0x7f')]('c.'+_0x304d4f[0x0],_0x304d4f[0x1]===_0xdd3d('0x80')?![]:!![]);});}if(!_[_0xdd3d('0x68')](_0x28a2d4)){_0x308e21[_0xdd3d('0x81')](_0x15d12f);_0x1939be['where']('t.id\x20IN\x20?',_0x28a2d4);}BPromise[_0xdd3d('0x82')]()[_0xdd3d('0x2c')](function(){if(_0x5caff2&&!_[_0xdd3d('0x83')](_0x5caff2[_0xdd3d('0x54')],[_0xdd3d('0x49'),_0xdd3d('0x5c')])){return _0x592521[_0xdd3d('0x84')][_0xdd3d('0x85')]({'attributes':['id'],'raw':!![]})[_0xdd3d('0x2c')](function(_0x587d1d){if(_[_0xdd3d('0x68')](_0x587d1d)){_0x1939be[_0xdd3d('0x45')](_0xdd3d('0x86'));_0x308e21[_0xdd3d('0x45')](_0xdd3d('0x86'));}else{_0x1939be[_0xdd3d('0x45')](_0xdd3d('0x6a'),_[_0xdd3d('0x58')](_0x587d1d,'id'));_0x308e21[_0xdd3d('0x45')](_0xdd3d('0x6a'),_[_0xdd3d('0x58')](_0x587d1d,'id'));}});}else{return;}})[_0xdd3d('0x2c')](function(){db['sequelize'][_0xdd3d('0x3f')](_0x1939be[_0xdd3d('0x87')](),_0xdef8db)[_0xdd3d('0x2c')](function(_0x430638){_0x1fe84c['count']=_0x430638[_0xdd3d('0x36')];if(_0x1fe84c[_0xdd3d('0x24')]===0x0)return[];return db['sequelize'][_0xdd3d('0x3f')](_0x33abac[_0xdd3d('0x87')](),_0xdef8db);})[_0xdd3d('0x2c')](function(_0x217d0d){_0x30726e=_[_0xdd3d('0x88')](_0x217d0d,'id');_0xdef8db=_['merge'](_0xdef8db,{'model':db['CmContact'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x592521[_0xdd3d('0x3f')][_0xdd3d('0x41')]){_0x20a989[_0xdd3d('0x42')][_0xdd3d('0x59')](function(_0x7f56cf){_0x308e21[_0xdd3d('0x49')]('c.'+_0x7f56cf);});}else{_0x308e21['field'](_0xdd3d('0x7d'));_0x308e21[_0xdd3d('0x49')]('c.firstName');_0x308e21[_0xdd3d('0x49')]('c.lastName');_0x308e21[_0xdd3d('0x49')](_0xdd3d('0x89'));_0x308e21['field'](_0xdd3d('0x8a'));_0x308e21['field'](_0xdd3d('0x8b'));_0x308e21[_0xdd3d('0x49')](_0xdd3d('0x8c'));_0x308e21[_0xdd3d('0x49')](_0xdd3d('0x8d'));_0x308e21[_0xdd3d('0x49')]('c.deletedAt');_0x308e21[_0xdd3d('0x49')](_0xdd3d('0x8e'),_0xdd3d('0x8f'));}if(_0x20a989[_0xdd3d('0x26')])_0x308e21['limit'](_0x20a989[_0xdd3d('0x26')]);if(_0x20a989['offset'])_0x308e21[_0xdd3d('0x25')](_0x20a989[_0xdd3d('0x25')]);return db[_0xdd3d('0x90')][_0xdd3d('0x3f')](_0x308e21[_0xdd3d('0x87')](),_0xdef8db);})[_0xdd3d('0x2c')](function(_0x7d6d0d){_0x7d6d0d['forEach'](function(_0x5ade0c){if(_0x5ade0c[_0xdd3d('0x8f')]){_0x5ade0c[_0xdd3d('0x91')]=[];_0x5ade0c[_0xdd3d('0x8f')]['split'](',')['forEach'](function(_0x4f6c59){_0x5ade0c[_0xdd3d('0x91')][_0xdd3d('0x39')](_0x30726e[_0x4f6c59]);});}delete _0x5ade0c[_0xdd3d('0x8f')];});_0x1fe84c['rows']=_0x7d6d0d;return _0x1fe84c;})[_0xdd3d('0x2c')](respondWithFilteredResult(_0x589b40,_0x20a989));});})[_0xdd3d('0x92')](handleError(_0x589b40,null));};exports[_0xdd3d('0x2d')]=function(_0x5b468e,_0x4f5600){return db['CmContact']['find']({'where':{'id':_0x5b468e[_0xdd3d('0x93')]['id']}})[_0xdd3d('0x2c')](handleEntityNotFound(_0x4f5600,null))[_0xdd3d('0x2c')](removeEntity(_0x4f5600,null))[_0xdd3d('0x92')](handleError(_0x4f5600,null));};exports[_0xdd3d('0x34')]=function(_0x471bd5,_0x4839db){return db['CmContact'][_0xdd3d('0x34')]()[_0xdd3d('0x2c')](function(_0x108a7a){delete _0x108a7a['tags'];for(var _0x3a7fc9=0x0;_0x3a7fc9<Object[_0xdd3d('0x35')](_0x108a7a)[_0xdd3d('0x36')];_0x3a7fc9++){var _0x19e362=Object['keys'](_0x108a7a)[_0x3a7fc9];if(!_[_0xdd3d('0x37')](_0x19e362,'cf_')){_0x108a7a[_0x19e362][_0xdd3d('0x94')]=_0x19e362;_0x108a7a[_0x19e362]['displayName']=_0x19e362;}}return _0x108a7a;})[_0xdd3d('0x2c')](function(_0x46fc9c){var _0x3500b6={'where':{'$or':[{'ListId':_0x471bd5[_0xdd3d('0x3f')]['id']},{'ListId':null}]},'raw':!![]};return db[_0xdd3d('0x3a')][_0xdd3d('0x95')](_0x3500b6)[_0xdd3d('0x2c')](function(_0x2af730){for(var _0x57f330=0x0;_0x57f330<_0x2af730[_0xdd3d('0x36')];_0x57f330++){var _0x3f1213=_0xdd3d('0x38')+_0x2af730[_0x57f330]['id'];_0x46fc9c[_0x3f1213]['columnName']=_0x3f1213;_0x46fc9c[_0x3f1213][_0xdd3d('0x96')]=_0x2af730[_0x57f330][_0xdd3d('0x97')];_0x46fc9c[_0x3f1213]['custom']={'type':_0x2af730[_0x57f330][_0xdd3d('0x3d')],'values':_0x2af730[_0x57f330][_0xdd3d('0x98')]};}Object[_0xdd3d('0x35')](_0x46fc9c)[_0xdd3d('0x59')](function(_0x3958cb){if(!_0x46fc9c[_0x3958cb]['hasOwnProperty']('columnName')){delete _0x46fc9c[_0x3958cb];}});return _0x46fc9c;});})[_0xdd3d('0x2c')](respondWithResult(_0x4839db,null))[_0xdd3d('0x92')](handleError(_0x4839db,null));};exports[_0xdd3d('0x99')]=function(_0xe782ef,_0x3666b4){var _0x13fd70;var _0x2bb2b3;var _0x4e0e44;if(_0xe782ef[_0xdd3d('0x9a')]['id']){delete _0xe782ef[_0xdd3d('0x9a')]['id'];}return db[_0xdd3d('0x33')]['findAll']({'where':{'id':[_0xe782ef[_0xdd3d('0x9a')]['to'],_0xe782ef[_0xdd3d('0x9a')][_0xdd3d('0x4b')]]}})[_0xdd3d('0x2c')](function(_0x96af5b){if(_0x96af5b){if(_0x96af5b[_0xdd3d('0x36')]!==0x2){return null;}_0x96af5b[0x0]=_0x96af5b[0x0]['get']({'plain':!![]});_0x96af5b[0x1]=_0x96af5b[0x1]['get']({'plain':!![]});delete _0x96af5b[0x0]['id'];delete _0x96af5b[0x1]['id'];return _[_0xdd3d('0x9b')](_0x96af5b[0x0],_0x96af5b[0x1],function(_0x4a660f,_0x189e8b){if(Array[_0xdd3d('0x6f')](_0x189e8b)&&!_0x189e8b[_0xdd3d('0x36')]){return _0x4a660f;}else if(!_0x189e8b){return _0x4a660f;}});}})['then'](handleEntityNotFound(_0x3666b4,null))['then'](function(_0x642961){if(_0x642961){if(_0x642961['tags']&&_['isArray'](_0x642961[_0xdd3d('0x9c')])){_0x642961[_0xdd3d('0x9c')]=_0x642961[_0xdd3d('0x9c')][_0xdd3d('0x9d')]();}logger[_0xdd3d('0x9e')](_0xdd3d('0x9f'),_0xe782ef[_0xdd3d('0x9a')]['to'],_0xe782ef[_0xdd3d('0x9a')]['from']);return db[_0xdd3d('0xa0')][_0xdd3d('0x2d')]({'where':{'ContactId':[_0xe782ef[_0xdd3d('0x9a')]['to'],_0xe782ef[_0xdd3d('0x9a')]['from']]}})[_0xdd3d('0x2c')](function(_0x4088c){logger[_0xdd3d('0x9e')]('[CmContact][merge][destroy][CmHopper],\x20%s',_0x4088c);return db[_0xdd3d('0xa1')]['destroy']({'where':{'ContactId':[_0xe782ef[_0xdd3d('0x9a')]['to'],_0xe782ef[_0xdd3d('0x9a')][_0xdd3d('0x4b')]]}})[_0xdd3d('0x2c')](function(_0xfc8594){logger['info'](_0xdd3d('0xa2'),_0xfc8594);return db[_0xdd3d('0x33')][_0xdd3d('0xa3')](_0x642961);});});}})[_0xdd3d('0x2c')](function(_0xdcd960){if(_0xdcd960){_0x13fd70=_0xdcd960;_0x2bb2b3={'ContactId':_0x13fd70['id']};_0x4e0e44={'where':{'ContactId':[_0xe782ef[_0xdd3d('0x9a')]['to'],_0xe782ef[_0xdd3d('0x9a')][_0xdd3d('0x4b')]]}};return db[_0xdd3d('0xa4')][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db[_0xdd3d('0xa5')][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})['then'](function(){if(_0x13fd70){return db[_0xdd3d('0xa6')][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})['then'](function(){if(_0x13fd70){return db['MailInteraction'][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db[_0xdd3d('0xa7')][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db[_0xdd3d('0xa8')][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db[_0xdd3d('0xa7')][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db[_0xdd3d('0xa9')]['update'](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db[_0xdd3d('0xaa')][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db[_0xdd3d('0xab')][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})['then'](function(){if(_0x13fd70){return db[_0xdd3d('0xac')][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db[_0xdd3d('0xad')][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db['OpenchannelMessage'][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db[_0xdd3d('0xae')][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db[_0xdd3d('0xaf')]['update'](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db['ReportAgentPreview'][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db['VoiceCallReport'][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db[_0xdd3d('0xb0')][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db[_0xdd3d('0xb1')][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db[_0xdd3d('0xb2')]['update'](_0x2bb2b3,_0x4e0e44);}})['then'](function(){if(_0x13fd70){return db[_0xdd3d('0xb3')][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db['SmsQueueReport'][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db[_0xdd3d('0xb4')][_0xdd3d('0x2b')](_0x2bb2b3,_0x4e0e44);}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return db['CmContact'][_0xdd3d('0x2d')]({'where':{'id':[_0xe782ef['body']['to'],_0xe782ef[_0xdd3d('0x9a')][_0xdd3d('0x4b')]]}});}})[_0xdd3d('0x2c')](function(){if(_0x13fd70){return _0x13fd70;}})[_0xdd3d('0x2c')](respondWithResult(_0x3666b4,null))[_0xdd3d('0x92')](handleError(_0x3666b4,null));};exports[_0xdd3d('0xa3')]=function(_0x3180da,_0x381148){return db[_0xdd3d('0x33')][_0xdd3d('0x34')]()[_0xdd3d('0x2c')](function(_0x4be6ef){if(_0x3180da[_0xdd3d('0x9a')][_0xdd3d('0x9c')]&&_[_0xdd3d('0x6f')](_0x3180da[_0xdd3d('0x9a')][_0xdd3d('0x9c')])){if(_0x3180da[_0xdd3d('0x9a')][_0xdd3d('0x9c')][_0xdd3d('0x36')]){_0x3180da[_0xdd3d('0x9a')][_0xdd3d('0x9c')]=_0x3180da[_0xdd3d('0x9a')]['tags'][_0xdd3d('0x9d')](';')+';';}else{_0x3180da['body'][_0xdd3d('0x9c')]=null;}}else{_0x3180da['body'][_0xdd3d('0x9c')]=null;}return db[_0xdd3d('0x33')][_0xdd3d('0xa3')](_0x3180da['body'],{'fields':_['keys'](_0x4be6ef),'raw':!![]});})[_0xdd3d('0x2c')](respondWithResult(_0x381148,0xc9))[_0xdd3d('0x92')](handleError(_0x381148,null));};exports[_0xdd3d('0xb5')]=function(_0x5b2ec4,_0x20c53d){var _0x1e0218=[];var _0x172ae3=0x0;var _0x5e48b6=0x0;var _0x10373e=0x0;return db[_0xdd3d('0x33')]['describe']()[_0xdd3d('0x2c')](function(_0x1664cf){return BPromise[_0xdd3d('0xb6')](_0x5b2ec4['body'],function(_0x355661){var _0x4b344e={'where':{'$or':[]},'defaults':_0x355661,'fields':_[_0xdd3d('0x35')](_0x1664cf),'raw':!![]};if(_0x355661[_0xdd3d('0xb7')]){for(var _0x308944=0x0;_0x308944<_0x355661['duplicates'][_0xdd3d('0x36')];_0x308944++){var _0x46f9a5={};_0x46f9a5[_0x355661[_0xdd3d('0xb7')][_0x308944]]=_0x355661[_0x355661[_0xdd3d('0xb7')][_0x308944]];_0x4b344e[_0xdd3d('0x45')][_0xdd3d('0xb8')][_0xdd3d('0x39')](_0x46f9a5);}_0x4b344e['where']['ListId']=_0x355661[_0xdd3d('0x69')];}return db[_0xdd3d('0x33')]['findOrCreate'](_0x4b344e)['spread'](function(_0xea2ad3,_0x182745){if(_0x182745){_0x172ae3++;}else{_0x10373e++;}})[_0xdd3d('0x92')](function(_0x1feb99){console[_0xdd3d('0x2e')](_0x1feb99);_0x5e48b6++;});});})[_0xdd3d('0x2c')](function(_0x5008ba){if(_0x5008ba){return{'success':_0x172ae3,'failure':_0x5e48b6,'duplicates':_0x10373e};}})[_0xdd3d('0x2c')](respondWithResult(_0x20c53d,0xc9))[_0xdd3d('0x92')](handleError(_0x20c53d,null));};exports[_0xdd3d('0xb9')]=function(_0x3d3043,_0x24ec10,_0x1b6f77){var _0x135019;return db[_0xdd3d('0x33')][_0xdd3d('0x34')]()[_0xdd3d('0x2c')](function(_0x3d999d){return db[_0xdd3d('0x33')]['find']({'where':{'id':_0x3d3043['params']['id']},'include':[{'model':db[_0xdd3d('0xba')],'as':_0xdd3d('0x91'),'attributes':['id',_0xdd3d('0x30'),_0xdd3d('0x4a')],'required':_0x3d3043[_0xdd3d('0x3f')][_0xdd3d('0x6e')]?!![]:![]}],'attributes':_[_0xdd3d('0x35')](_0x3d999d)});})[_0xdd3d('0x2c')](function(_0xb562d0){_0x135019=_0xb562d0[_0xdd3d('0xbb')]({'plain':!![]});var _0x53f100={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0xb562d0&&_0xb562d0[_0xdd3d('0x69')]){if(_0xb562d0[_0xdd3d('0x69')]){_0x53f100['where'][_0xdd3d('0xbc')]['push']({'ListId':{'$ne':_0xb562d0[_0xdd3d('0x69')]}});}}return db[_0xdd3d('0x3a')][_0xdd3d('0x95')](_0x53f100);})[_0xdd3d('0x2c')](function(_0x34a9d7){return _[_0xdd3d('0xbd')](_0x135019,_[_0xdd3d('0x58')](_0x34a9d7,function(_0x19a516){return util['format'](_0xdd3d('0xbe'),_0x19a516['id']);}));})[_0xdd3d('0x2c')](handleEntityNotFound(_0x24ec10,null))[_0xdd3d('0x2c')](respondWithResult(_0x24ec10,null))[_0xdd3d('0x92')](handleError(_0x24ec10,null));};exports['update']=function(_0x2dc7cb,_0x438600){var _0x3e3341;if(_0x2dc7cb[_0xdd3d('0x9a')]['id']){delete _0x2dc7cb['body']['id'];}return db[_0xdd3d('0x33')][_0xdd3d('0x55')]({'where':{'id':_0x2dc7cb['params']['id']}})[_0xdd3d('0x2c')](handleEntityNotFound(_0x438600,null))[_0xdd3d('0x2c')](saveUpdates(_0x2dc7cb['body'],null))[_0xdd3d('0x2c')](function(_0x115d9e){_0x3e3341=_0x115d9e;var _0x116be5={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x115d9e&&_0x115d9e['ListId']){if(_0x115d9e[_0xdd3d('0x69')]){_0x116be5[_0xdd3d('0x45')][_0xdd3d('0xbc')][_0xdd3d('0x39')]({'ListId':{'$ne':_0x115d9e['ListId']}});}}return db['CmCustomField']['findAll'](_0x116be5);})['then'](function(_0x1f3819){if(_0x1f3819){return _[_0xdd3d('0xbd')](_[_0xdd3d('0xbf')](_0x2dc7cb[_0xdd3d('0x9a')],function(_0x5ce647,_0x2daced){return _[_0xdd3d('0x37')](_0x2daced,_0xdd3d('0x38'));}),_[_0xdd3d('0x58')](_0x1f3819,function(_0x54fb02){return util[_0xdd3d('0xc0')](_0xdd3d('0xbe'),_0x54fb02['id']);}));}})[_0xdd3d('0x2c')](function(_0x531a83){if(_0x531a83&&!_[_0xdd3d('0x68')](_0x531a83)){var _0x186705=squel[_0xdd3d('0x2b')]()['table'](_0xdd3d('0xc1'))['setFields'](_0x531a83)[_0xdd3d('0x45')](_0xdd3d('0xc2'),_0x2dc7cb[_0xdd3d('0x93')]['id'])[_0xdd3d('0xc3')]();return db['sequelize'][_0xdd3d('0x3f')](_0x186705[_0xdd3d('0x63')],{'replacements':_0x186705[_0xdd3d('0x98')]});}})['then'](function(){if(_0x2dc7cb[_0xdd3d('0x9a')]['phone']&&_0x3e3341){return db[_0xdd3d('0xa0')][_0xdd3d('0x2b')]({'phone':_0x2dc7cb[_0xdd3d('0x9a')][_0xdd3d('0xc4')]},{'where':{'ContactId':_0x3e3341['id']}});}})[_0xdd3d('0x2c')](function(){return _0x3e3341;})[_0xdd3d('0x2c')](respondWithResult(_0x438600,null))[_0xdd3d('0x92')](handleError(_0x438600,null));};exports['getTags']=function(_0x4d9010,_0x6d7421,_0x2dc098){var _0x44fe62={};var _0xc7f20b={};var _0x16ec6b;var _0x928eee;return db[_0xdd3d('0x33')][_0xdd3d('0x3b')]({'where':{'id':_0x4d9010['params']['id']}})[_0xdd3d('0x2c')](handleEntityNotFound(_0x6d7421,null))[_0xdd3d('0x2c')](function(_0x198231){if(_0x198231){_0x16ec6b=_0x198231;_0xc7f20b[_0xdd3d('0x3e')]=_['keys'](db['Tag'][_0xdd3d('0xc5')]);_0xc7f20b['query']=_[_0xdd3d('0x35')](_0x4d9010['query']);_0xc7f20b[_0xdd3d('0x46')]=_['intersection'](_0xc7f20b[_0xdd3d('0x3e')],_0xc7f20b[_0xdd3d('0x3f')]);_0x44fe62[_0xdd3d('0x42')]=_[_0xdd3d('0x40')](_0xc7f20b['model'],qs['fields'](_0x4d9010['query'][_0xdd3d('0x41')]));_0x44fe62[_0xdd3d('0x42')]=_0x44fe62[_0xdd3d('0x42')][_0xdd3d('0x36')]?_0x44fe62[_0xdd3d('0x42')]:_0xc7f20b[_0xdd3d('0x3e')];_0x44fe62[_0xdd3d('0x7f')]=qs[_0xdd3d('0x44')](_0x4d9010[_0xdd3d('0x3f')][_0xdd3d('0x44')]);_0x44fe62[_0xdd3d('0x45')]=qs[_0xdd3d('0x46')](_[_0xdd3d('0x47')](_0x4d9010['query'],_0xc7f20b['filters']));if(_0x4d9010[_0xdd3d('0x3f')][_0xdd3d('0xc6')]){_0x44fe62[_0xdd3d('0x45')]=_[_0xdd3d('0x99')](_0x44fe62[_0xdd3d('0x45')],{'$or':_[_0xdd3d('0x58')](_0x44fe62[_0xdd3d('0x42')],function(_0x5ca416){var _0x5b2759={};_0x5b2759[_0x5ca416]={'$like':'%'+_0x4d9010[_0xdd3d('0x3f')]['filter']+'%'};return _0x5b2759;})});}_0x44fe62=_[_0xdd3d('0x99')]({},_0x44fe62,_0x4d9010[_0xdd3d('0xc7')]);return _0x16ec6b[_0xdd3d('0xc8')](_0x44fe62);}})[_0xdd3d('0x2c')](function(_0x2d3c07){if(_0x2d3c07){_0x928eee=_0x2d3c07[_0xdd3d('0x36')];if(!_0x4d9010[_0xdd3d('0x3f')][_0xdd3d('0x65')](_0xdd3d('0x43'))){_0x44fe62['limit']=qs[_0xdd3d('0x26')](_0x4d9010['query'][_0xdd3d('0x26')]);_0x44fe62['offset']=qs[_0xdd3d('0x25')](_0x4d9010[_0xdd3d('0x3f')][_0xdd3d('0x25')]);}return _0x16ec6b['getTags'](_0x44fe62);}})['then'](function(_0x23af3c){if(_0x23af3c){return _0x23af3c?{'count':_0x928eee,'rows':_0x23af3c}:null;}})['then'](respondWithResult(_0x6d7421,null))['catch'](handleError(_0x6d7421,null));};exports[_0xdd3d('0xc9')]=function(_0x457def,_0x359639,_0x2ff4ff){if(_0x457def[_0xdd3d('0x9a')]['id']){delete _0x457def[_0xdd3d('0x9a')]['id'];}return db[_0xdd3d('0x33')][_0xdd3d('0x3b')]({'where':{'id':_0x457def[_0xdd3d('0x93')]['id']}})[_0xdd3d('0x2c')](handleEntityNotFound(_0x359639,null))[_0xdd3d('0x2c')](function(_0x249dad){if(_0x249dad){return _0x249dad[_0xdd3d('0xc9')](_0x457def[_0xdd3d('0x9a')][_0xdd3d('0xca')]||[]);}return null;})[_0xdd3d('0x2c')](respondWithResult(_0x359639,null))[_0xdd3d('0x92')](handleError(_0x359639,null));};exports[_0xdd3d('0xcb')]=function(_0x2eed09,_0x25cc59,_0x514009){var _0x4942f5={'raw':![],'where':{}};var _0x53df9={};var _0x1d7e80={'count':0x0,'rows':[]};return db['CmContact'][_0xdd3d('0x3b')]({'where':{'id':_0x2eed09[_0xdd3d('0x93')]['id']}})[_0xdd3d('0x2c')](handleEntityNotFound(_0x25cc59,null))[_0xdd3d('0x2c')](function(_0x3a6f2a){if(_0x3a6f2a){_0x53df9[_0xdd3d('0x3e')]=_[_0xdd3d('0x35')](db[_0xdd3d('0xa0')][_0xdd3d('0xc5')]);_0x53df9['query']=_[_0xdd3d('0x35')](_0x2eed09[_0xdd3d('0x3f')]);_0x53df9[_0xdd3d('0x46')]=_[_0xdd3d('0x40')](_0x53df9['model'],_0x53df9['query']);_0x4942f5[_0xdd3d('0x42')]=_[_0xdd3d('0x40')](_0x53df9[_0xdd3d('0x3e')],qs['fields'](_0x2eed09[_0xdd3d('0x3f')][_0xdd3d('0x41')]));_0x4942f5[_0xdd3d('0x42')]=_0x4942f5[_0xdd3d('0x42')][_0xdd3d('0x36')]?_0x4942f5['attributes']:_0x53df9[_0xdd3d('0x3e')];if(!_0x2eed09[_0xdd3d('0x3f')]['hasOwnProperty'](_0xdd3d('0x43'))){_0x4942f5['limit']=qs[_0xdd3d('0x26')](_0x2eed09[_0xdd3d('0x3f')][_0xdd3d('0x26')]);_0x4942f5[_0xdd3d('0x25')]=qs[_0xdd3d('0x25')](_0x2eed09[_0xdd3d('0x3f')][_0xdd3d('0x25')]);}_0x4942f5[_0xdd3d('0x7f')]=qs[_0xdd3d('0x44')](_0x2eed09[_0xdd3d('0x3f')][_0xdd3d('0x44')]);_0x4942f5[_0xdd3d('0x45')]=qs[_0xdd3d('0x46')](_['pick'](_0x2eed09[_0xdd3d('0x3f')],_0x53df9[_0xdd3d('0x46')]));_0x4942f5['where']['ContactId']=_0x3a6f2a['id'];if(_0x2eed09['query'][_0xdd3d('0xc6')]){_0x4942f5[_0xdd3d('0x45')]=_['merge'](_0x4942f5[_0xdd3d('0x45')],{'$or':_[_0xdd3d('0x58')](_0x4942f5[_0xdd3d('0x42')],function(_0x4446a8){var _0x5acb6c={};_0x5acb6c[_0x4446a8]={'$like':'%'+_0x2eed09[_0xdd3d('0x3f')][_0xdd3d('0xc6')]+'%'};return _0x5acb6c;})});}_0x4942f5=_[_0xdd3d('0x99')]({},_0x4942f5,_0x2eed09[_0xdd3d('0xc7')]);return db[_0xdd3d('0xa0')][_0xdd3d('0x24')]({'where':_0x4942f5['where']})[_0xdd3d('0x2c')](function(_0x23b3da){_0x1d7e80[_0xdd3d('0x24')]=_0x23b3da;if(_0x2eed09[_0xdd3d('0x3f')][_0xdd3d('0xcc')]){_0x4942f5[_0xdd3d('0xcd')]=[{'all':!![]}];}return db[_0xdd3d('0xa0')][_0xdd3d('0x95')](_0x4942f5);})['then'](function(_0x4b39c2){_0x1d7e80[_0xdd3d('0xce')]=_0x4b39c2;return _0x1d7e80;});}})[_0xdd3d('0x2c')](respondWithFilteredResult(_0x25cc59,_0x4942f5))[_0xdd3d('0x92')](handleError(_0x25cc59,null));};exports[_0xdd3d('0xcf')]=function(_0x4399d0,_0x3737d6,_0x32b767){var _0x506cf6={'raw':!![],'where':{}};var _0x4635fa={};var _0x119dea={'count':0x0,'rows':[]};return db[_0xdd3d('0x33')][_0xdd3d('0x3b')]({'where':{'id':_0x4399d0['params']['id']}})[_0xdd3d('0x2c')](handleEntityNotFound(_0x3737d6,null))[_0xdd3d('0x2c')](function(_0x517cf7){if(_0x517cf7){_0x4635fa[_0xdd3d('0x3e')]=_[_0xdd3d('0x35')](db[_0xdd3d('0xaf')][_0xdd3d('0xc5')]);_0x4635fa[_0xdd3d('0x3f')]=_[_0xdd3d('0x35')](_0x4399d0['query']);_0x4635fa[_0xdd3d('0x46')]=_['intersection'](_0x4635fa['model'],_0x4635fa[_0xdd3d('0x3f')]);_0x506cf6['attributes']=_[_0xdd3d('0x40')](_0x4635fa[_0xdd3d('0x3e')],qs[_0xdd3d('0x41')](_0x4399d0[_0xdd3d('0x3f')][_0xdd3d('0x41')]));_0x506cf6[_0xdd3d('0x42')]=_0x506cf6[_0xdd3d('0x42')][_0xdd3d('0x36')]?_0x506cf6[_0xdd3d('0x42')]:_0x4635fa[_0xdd3d('0x3e')];if(!_0x4399d0[_0xdd3d('0x3f')][_0xdd3d('0x65')](_0xdd3d('0x43'))){_0x506cf6[_0xdd3d('0x26')]=qs['limit'](_0x4399d0[_0xdd3d('0x3f')]['limit']);_0x506cf6[_0xdd3d('0x25')]=qs[_0xdd3d('0x25')](_0x4399d0[_0xdd3d('0x3f')][_0xdd3d('0x25')]);}_0x506cf6['order']=qs[_0xdd3d('0x44')](_0x4399d0[_0xdd3d('0x3f')][_0xdd3d('0x44')]);_0x506cf6[_0xdd3d('0x45')]=qs['filters'](_[_0xdd3d('0x47')](_0x4399d0[_0xdd3d('0x3f')],_0x4635fa['filters']));_0x506cf6[_0xdd3d('0x45')][_0xdd3d('0xd0')]=_0x517cf7['id'];if(_0x4399d0['query'][_0xdd3d('0xc6')]){_0x506cf6[_0xdd3d('0x45')]=_['merge'](_0x506cf6['where'],{'$or':_[_0xdd3d('0x58')](_0x506cf6['attributes'],function(_0x11f731){var _0x4dc7f7={};_0x4dc7f7[_0x11f731]={'$like':'%'+_0x4399d0[_0xdd3d('0x3f')][_0xdd3d('0xc6')]+'%'};return _0x4dc7f7;})});}_0x506cf6=_[_0xdd3d('0x99')]({},_0x506cf6,_0x4399d0[_0xdd3d('0xc7')]);return db[_0xdd3d('0xaf')][_0xdd3d('0x24')]({'where':_0x506cf6[_0xdd3d('0x45')]})[_0xdd3d('0x2c')](function(_0x28a99e){_0x119dea[_0xdd3d('0x24')]=_0x28a99e;if(_0x4399d0['query'][_0xdd3d('0xcc')]){_0x506cf6[_0xdd3d('0xcd')]=[{'all':!![]}];}return db['CmHopperHistory'][_0xdd3d('0x95')](_0x506cf6);})[_0xdd3d('0x2c')](function(_0x205eef){_0x119dea['rows']=_0x205eef;return _0x119dea;});}})['then'](respondWithFilteredResult(_0x3737d6,_0x506cf6))[_0xdd3d('0x92')](handleError(_0x3737d6,null));};exports['getHopperFinals']=function(_0x3b37fc,_0x1a6382,_0x6da841){var _0x25f389={'raw':!![],'where':{}};var _0x3ce9dc={};var _0x44ccca={'count':0x0,'rows':[]};return db[_0xdd3d('0x33')][_0xdd3d('0x3b')]({'where':{'id':_0x3b37fc[_0xdd3d('0x93')]['id']}})[_0xdd3d('0x2c')](handleEntityNotFound(_0x1a6382,null))[_0xdd3d('0x2c')](function(_0x2e92e7){if(_0x2e92e7){_0x3ce9dc[_0xdd3d('0x3e')]=_[_0xdd3d('0x35')](db[_0xdd3d('0xae')][_0xdd3d('0xc5')]);_0x3ce9dc[_0xdd3d('0x3f')]=_['keys'](_0x3b37fc[_0xdd3d('0x3f')]);_0x3ce9dc[_0xdd3d('0x46')]=_[_0xdd3d('0x40')](_0x3ce9dc[_0xdd3d('0x3e')],_0x3ce9dc[_0xdd3d('0x3f')]);_0x25f389['attributes']=_[_0xdd3d('0x40')](_0x3ce9dc[_0xdd3d('0x3e')],qs[_0xdd3d('0x41')](_0x3b37fc[_0xdd3d('0x3f')][_0xdd3d('0x41')]));_0x25f389['attributes']=_0x25f389[_0xdd3d('0x42')][_0xdd3d('0x36')]?_0x25f389['attributes']:_0x3ce9dc['model'];if(!_0x3b37fc[_0xdd3d('0x3f')]['hasOwnProperty'](_0xdd3d('0x43'))){_0x25f389[_0xdd3d('0x26')]=qs[_0xdd3d('0x26')](_0x3b37fc[_0xdd3d('0x3f')][_0xdd3d('0x26')]);_0x25f389[_0xdd3d('0x25')]=qs[_0xdd3d('0x25')](_0x3b37fc['query'][_0xdd3d('0x25')]);}_0x25f389['order']=qs[_0xdd3d('0x44')](_0x3b37fc[_0xdd3d('0x3f')][_0xdd3d('0x44')]);_0x25f389['where']=qs[_0xdd3d('0x46')](_[_0xdd3d('0x47')](_0x3b37fc[_0xdd3d('0x3f')],_0x3ce9dc['filters']));_0x25f389[_0xdd3d('0x45')][_0xdd3d('0xd0')]=_0x2e92e7['id'];if(_0x3b37fc[_0xdd3d('0x3f')]['filter']){_0x25f389[_0xdd3d('0x45')]=_[_0xdd3d('0x99')](_0x25f389[_0xdd3d('0x45')],{'$or':_[_0xdd3d('0x58')](_0x25f389[_0xdd3d('0x42')],function(_0x3cce3f){var _0x34489d={};_0x34489d[_0x3cce3f]={'$like':'%'+_0x3b37fc[_0xdd3d('0x3f')][_0xdd3d('0xc6')]+'%'};return _0x34489d;})});}_0x25f389=_[_0xdd3d('0x99')]({},_0x25f389,_0x3b37fc['options']);return db[_0xdd3d('0xae')][_0xdd3d('0x24')]({'where':_0x25f389[_0xdd3d('0x45')]})['then'](function(_0x2073c1){_0x44ccca[_0xdd3d('0x24')]=_0x2073c1;if(_0x3b37fc[_0xdd3d('0x3f')]['includeAll']){_0x25f389[_0xdd3d('0xcd')]=[{'all':!![]}];}return db[_0xdd3d('0xae')][_0xdd3d('0x95')](_0x25f389);})[_0xdd3d('0x2c')](function(_0x41f40e){_0x44ccca[_0xdd3d('0xce')]=_0x41f40e;return _0x44ccca;});}})[_0xdd3d('0x2c')](respondWithFilteredResult(_0x1a6382,_0x25f389))[_0xdd3d('0x92')](handleError(_0x1a6382,null));};exports[_0xdd3d('0xd1')]=function(_0x2f6e8d,_0x12db36,_0x5e096d){var _0x8af6c7={'raw':!![],'where':{}};var _0x33a07c={};var _0x459c5b={'count':0x0,'rows':[]};return db[_0xdd3d('0x33')][_0xdd3d('0x3b')]({'where':{'id':_0x2f6e8d['params']['id']}})[_0xdd3d('0x2c')](handleEntityNotFound(_0x12db36,null))[_0xdd3d('0x2c')](function(_0x38fb67){if(_0x38fb67){_0x33a07c[_0xdd3d('0x3e')]=_['keys'](db[_0xdd3d('0xb4')][_0xdd3d('0xc5')]);_0x33a07c[_0xdd3d('0x3f')]=_['keys'](_0x2f6e8d[_0xdd3d('0x3f')]);_0x33a07c[_0xdd3d('0x46')]=_[_0xdd3d('0x40')](_0x33a07c[_0xdd3d('0x3e')],_0x33a07c['query']);_0x8af6c7['attributes']=_['intersection'](_0x33a07c[_0xdd3d('0x3e')],qs[_0xdd3d('0x41')](_0x2f6e8d[_0xdd3d('0x3f')][_0xdd3d('0x41')]));_0x8af6c7['attributes']=_0x8af6c7[_0xdd3d('0x42')][_0xdd3d('0x36')]?_0x8af6c7[_0xdd3d('0x42')]:_0x33a07c[_0xdd3d('0x3e')];if(!_0x2f6e8d[_0xdd3d('0x3f')][_0xdd3d('0x65')]('nolimit')){_0x8af6c7[_0xdd3d('0x26')]=qs[_0xdd3d('0x26')](_0x2f6e8d[_0xdd3d('0x3f')][_0xdd3d('0x26')]);_0x8af6c7[_0xdd3d('0x25')]=qs[_0xdd3d('0x25')](_0x2f6e8d[_0xdd3d('0x3f')][_0xdd3d('0x25')]);}_0x8af6c7[_0xdd3d('0x7f')]=qs[_0xdd3d('0x44')](_0x2f6e8d[_0xdd3d('0x3f')][_0xdd3d('0x44')]);_0x8af6c7['where']=qs[_0xdd3d('0x46')](_['pick'](_0x2f6e8d[_0xdd3d('0x3f')],_0x33a07c[_0xdd3d('0x46')]));_0x8af6c7[_0xdd3d('0x45')][_0xdd3d('0xd0')]=_0x38fb67['id'];if(_0x2f6e8d[_0xdd3d('0x3f')][_0xdd3d('0xc6')]){_0x8af6c7[_0xdd3d('0x45')]=_[_0xdd3d('0x99')](_0x8af6c7[_0xdd3d('0x45')],{'$or':_[_0xdd3d('0x58')](_0x8af6c7['attributes'],function(_0x4e64d0){var _0x3304a9={};_0x3304a9[_0x4e64d0]={'$like':'%'+_0x2f6e8d[_0xdd3d('0x3f')]['filter']+'%'};return _0x3304a9;})});}_0x8af6c7=_[_0xdd3d('0x99')]({},_0x8af6c7,_0x2f6e8d[_0xdd3d('0xc7')]);return db[_0xdd3d('0xb4')][_0xdd3d('0x24')]({'where':_0x8af6c7[_0xdd3d('0x45')]})[_0xdd3d('0x2c')](function(_0x3200da){_0x459c5b[_0xdd3d('0x24')]=_0x3200da;if(_0x2f6e8d[_0xdd3d('0x3f')]['includeAll']){_0x8af6c7[_0xdd3d('0xcd')]=[{'all':!![]}];}return db[_0xdd3d('0xb4')][_0xdd3d('0x95')](_0x8af6c7);})[_0xdd3d('0x2c')](function(_0x463796){_0x459c5b['rows']=_0x463796;return _0x459c5b;});}})['then'](respondWithFilteredResult(_0x12db36,_0x8af6c7))[_0xdd3d('0x92')](handleError(_0x12db36,null));};exports[_0xdd3d('0xd2')]=function(_0x35ca37,_0x497b3c,_0x55db7b){try{if(!_0x35ca37[_0xdd3d('0x9a')][_0xdd3d('0x69')]){throw new Error(_0xdd3d('0xd3'));}if(!_0x35ca37[_0xdd3d('0x9a')][_0xdd3d('0xd4')]){throw new Error(_0xdd3d('0xd5'));}if(!_0x35ca37[_0xdd3d('0x9a')][_0xdd3d('0xd6')]){throw new Error(_0xdd3d('0xd7'));}if(!_0x35ca37[_0xdd3d('0x9a')]['socket_timestamp']){throw new Error(_0xdd3d('0xd8'));}var _0x50809f=_0x35ca37[_0xdd3d('0x9a')]['binding_keys'][_0xdd3d('0x57')](',');var _0x3483fc=_0x35ca37['body']['binding_values'][_0xdd3d('0x57')](',');if(!_0x50809f[_0xdd3d('0x36')]||!_0x3483fc[_0xdd3d('0x36')]||_0x50809f['length']!==_0x3483fc[_0xdd3d('0x36')]){throw new Error('Incorrect\x20binding\x20parameters\x20passed!');}_0x35ca37[_0xdd3d('0x9a')][_0xdd3d('0x41')]=_[_0xdd3d('0xd9')](_0x50809f,_0x3483fc);if(!_0x35ca37['body'][_0xdd3d('0x41')][_0xdd3d('0xc4')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x35ca37[_0xdd3d('0x9a')][_0xdd3d('0x41')]['firstName']){throw new Error(_0xdd3d('0xda'));}var _0x5a51c7=path[_0xdd3d('0x9d')](config[_0xdd3d('0xdb')],_0xdd3d('0xdc'),_0x35ca37[_0xdd3d('0xdd')][_0xdd3d('0xde')]);fs[_0xdd3d('0xdf')](_0x5a51c7,parseInt(_0xdd3d('0xe0'),0x8));var _0x5143d5=require(_0xdd3d('0xe1'))['fork'](path[_0xdd3d('0x9d')](__dirname,_0xdd3d('0xe2')),[_0x5a51c7,_0x35ca37[_0xdd3d('0x9a')][_0xdd3d('0xd4')],_0x35ca37[_0xdd3d('0x9a')][_0xdd3d('0xd6')],_0x35ca37[_0xdd3d('0x9a')][_0xdd3d('0x69')],_0x35ca37[_0xdd3d('0x9a')][_0xdd3d('0xe3')],_0x35ca37['body'][_0xdd3d('0xb7')],_0x35ca37['body'][_0xdd3d('0xe4')]]);return _0x497b3c[_0xdd3d('0x21')](0xc8)[_0xdd3d('0x23')]({'message':_0xdd3d('0xe5'),'pid':_0x5143d5[_0xdd3d('0xe6')]});}catch(_0x5ab3f4){return _0x497b3c['status'](0x1f4)[_0xdd3d('0x31')](_0x5ab3f4);}};exports['upload']=function(_0x300bd1,_0x5a65ac,_0x2e95ba){var _0x57a06a=fs[_0xdd3d('0xe7')](_0x300bd1[_0xdd3d('0xdd')][_0xdd3d('0x8')]);Papa[_0xdd3d('0xe8')](_0x57a06a,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x3aef58){return _0x5a65ac[_0xdd3d('0x21')](0xc8)[_0xdd3d('0x23')]({'file':_0x300bd1[_0xdd3d('0xdd')],'fields':_0x3aef58[_0xdd3d('0xe9')][_0xdd3d('0x41')]});}});};exports[_0xdd3d('0xea')]=function(_0x226d5c,_0x2828c4,_0x585fa4){return db['User'][_0xdd3d('0x95')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0xdd3d('0x2c')](function(_0x34f4d0){var _0x2cdce0=![];if(!_0x226d5c['body'][_0xdd3d('0x69')]){throw new Error(_0xdd3d('0xd3'));}if(!_0x226d5c[_0xdd3d('0x9a')]['binding'][_0xdd3d('0xc4')]){throw new Error(_0xdd3d('0xeb'));}if(!_0x226d5c[_0xdd3d('0x9a')][_0xdd3d('0xec')]['firstName']){throw new Error(_0xdd3d('0xda'));}if(!_0x226d5c[_0xdd3d('0x9a')][_0xdd3d('0xe4')]){throw new Error(_0xdd3d('0xd8'));}var _0x143f06=require(_0xdd3d('0xe1'))[_0xdd3d('0xed')](path['join'](__dirname,_0xdd3d('0xee')),[_0x226d5c[_0xdd3d('0x93')]['id'],JSON[_0xdd3d('0xef')](_0x226d5c[_0xdd3d('0x9a')]),JSON[_0xdd3d('0xef')](_0x34f4d0)]);_0x143f06['on'](_0xdd3d('0xf0'),function(_0x8aab43){_0x2cdce0=!![];return _0x2828c4[_0xdd3d('0x21')](0xc8)[_0xdd3d('0x23')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x143f06[_0xdd3d('0xe6')]});});_0x143f06['on'](_0xdd3d('0xf1'),function(_0x14b493){if(_0x14b493&&!_0x2cdce0){return _0x2828c4[_0xdd3d('0x21')](0x1f4)[_0xdd3d('0x23')]({'message':'error\x20child\x20process','pid':_0x143f06[_0xdd3d('0xe6')]});}});})[_0xdd3d('0x92')](handleError(_0x2828c4,null));};
\ No newline at end of file
+var _0xa63b=['No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_keys','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','root','filename','0777','child_process','fork','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','pid','upload','file','parse','meta','import','User','agent','binding','stringify','start\x20child\x20process\x20correctly!','exit','eml-format','rimraf','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','to-csv','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../mysqldb','defaults','redis','localhost','socket.io-emitter','register','sendStatus','end','status','json','count','offset','limit','set','Content-Range','apply','reject','stack','name','send','index','CmContact','then','keys','length','startsWith','cf_','push','CmCustomField','findOne','trimStart','all','fieldType','type','model','query','filters','intersection','attributes','nolimit','order','sort','select','field','color','from','tools_tags','cm_contacts','cm_user_has_contacts','left_join','cm_contact_has_tags','where','c.deletedAt\x20IS\x20NULL','search','parseSearch','sqlOperator','conditions','find','Tag','value','split','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','uc.UserId\x20=\x20?','datetime','castTo','DATE','text','start','hasOwnProperty','isNil','Contact','isEmpty','ListId','c.ListId\x20IN\x20?','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','isArray','tag','filter','replace','\x27\x27\x27\x27','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','isNumeric','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.id','clone','DESC','having','t.id\x20IN\x20?','resolve','some','user','getLists','sequelize','toString','merge','fields','c.firstName','c.lastName','c.email','c.deletedAt','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','rows','destroy','params','catch','describe','tags','columnName','displayName','findAll','alias','custom','values','body','get','mergeWith','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','update','MailMessage','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','JscriptySessionReport','bulkCreate','each','duplicates','spread','show','omit','format','cf_%d','$and','pickBy','setFields','toParam','phone','getTags','rawAttributes','pick','options','setTags','ids','getHoppers','includeAll','include','getHopperHistories','ContactId','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_values'];(function(_0x196666,_0x3c1e32){var _0x59afb2=function(_0xd36ecf){while(--_0xd36ecf){_0x196666['push'](_0x196666['shift']());}};_0x59afb2(++_0x3c1e32);}(_0xa63b,0x107));var _0xba63=function(_0x2c91e9,_0x2fb965){_0x2c91e9=_0x2c91e9-0x0;var _0x13f0ff=_0xa63b[_0x2c91e9];return _0x13f0ff;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xba63('0x0'));var rimraf=require(_0xba63('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xba63('0x2'));var rp=require(_0xba63('0x3'));var moment=require('moment');var BPromise=require(_0xba63('0x4'));var Mustache=require(_0xba63('0x5'));var util=require(_0xba63('0x6'));var path=require(_0xba63('0x7'));var sox=require(_0xba63('0x8'));var csv=require(_0xba63('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require(_0xba63('0xa'));var squel=require('squel');var crypto=require(_0xba63('0xb'));var jsforce=require(_0xba63('0xc'));var deskjs=require(_0xba63('0xd'));var toCsv=require('to-csv');var querystring=require(_0xba63('0xe'));var Papa=require(_0xba63('0xf'));var Redis=require(_0xba63('0x10'));var authService=require(_0xba63('0x11'));var qs=require(_0xba63('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xba63('0x13'));var logger=require(_0xba63('0x14'))(_0xba63('0x15'));var utils=require('../../config/utils');var config=require('../../config/environment');var db=require(_0xba63('0x16'))['db'];config['redis']=_[_0xba63('0x17')](config[_0xba63('0x18')],{'host':_0xba63('0x19'),'port':0x18eb});var socket=require(_0xba63('0x1a'))(new Redis(config[_0xba63('0x18')]));require('./cmContact.socket')[_0xba63('0x1b')](socket);function respondWithStatusCode(_0x47dffe,_0x364f89){_0x364f89=_0x364f89||0xcc;return function(_0x2f26c3){if(_0x2f26c3){return _0x47dffe[_0xba63('0x1c')](_0x364f89);}return _0x47dffe['status'](_0x364f89)[_0xba63('0x1d')]();};}function respondWithResult(_0x1f80af,_0x1da7d0){_0x1da7d0=_0x1da7d0||0xc8;return function(_0x208a8d){if(_0x208a8d){return _0x1f80af[_0xba63('0x1e')](_0x1da7d0)[_0xba63('0x1f')](_0x208a8d);}};}function respondWithFilteredResult(_0x31f8b1,_0x4fbea2){return function(_0x30000e){if(_0x30000e){var _0x41a7ec=_0x30000e[_0xba63('0x20')],_0x375078=_0x4fbea2[_0xba63('0x21')],_0x2b3bfc=_0x4fbea2['offset']+_0x4fbea2[_0xba63('0x22')],_0x22eb87;if(_0x2b3bfc>=_0x41a7ec){_0x2b3bfc=_0x41a7ec;_0x22eb87=0xc8;}else{_0x22eb87=0xce;}_0x31f8b1[_0xba63('0x1e')](_0x22eb87);return _0x31f8b1[_0xba63('0x23')](_0xba63('0x24'),_0x375078+'-'+_0x2b3bfc+'/'+_0x41a7ec)[_0xba63('0x1f')](_0x30000e);}return null;};}function patchUpdates(_0x586ef7){return function(_0x2b54c8){try{jsonpatch[_0xba63('0x25')](_0x2b54c8,_0x586ef7,!![]);}catch(_0x21301c){return BPromise[_0xba63('0x26')](_0x21301c);}return _0x2b54c8['save']();};}function saveUpdates(_0x4969bc,_0x412727){return function(_0x51fa27){if(_0x51fa27){return _0x51fa27['update'](_0x4969bc)['then'](function(_0x4e8c8e){return _0x4e8c8e;});}return null;};}function removeEntity(_0x2dd920,_0x13e7fd){return function(_0x195ddd){if(_0x195ddd){return _0x195ddd['destroy']()['then'](function(){_0x2dd920[_0xba63('0x1e')](0xcc)[_0xba63('0x1d')]();});}};}function handleEntityNotFound(_0x4c8412,_0x336175){return function(_0x3c14d4){if(!_0x3c14d4){_0x4c8412[_0xba63('0x1c')](0x194);}return _0x3c14d4;};}function handleError(_0xf61081,_0x32bbee){_0x32bbee=_0x32bbee||0x1f4;return function(_0x304991){logger['error'](_0x304991[_0xba63('0x27')]);if(_0x304991[_0xba63('0x28')]){delete _0x304991[_0xba63('0x28')];}_0xf61081['status'](_0x32bbee)[_0xba63('0x29')](_0x304991);};}exports[_0xba63('0x2a')]=function(_0x164ef9,_0x4bbb29){var _0x23e094={},_0x2dfccb={},_0x2d7281={'count':0x0,'rows':[]};return db[_0xba63('0x2b')]['describe']()[_0xba63('0x2c')](function(_0x3f3fd7){var _0x1c7bc1=[];for(var _0x24e65c=0x0;_0x24e65c<Object[_0xba63('0x2d')](_0x3f3fd7)[_0xba63('0x2e')];_0x24e65c++){var _0x3f3e4d=Object[_0xba63('0x2d')](_0x3f3fd7)[_0x24e65c];if(_[_0xba63('0x2f')](_0x3f3e4d,_0xba63('0x30'))){_0x1c7bc1[_0xba63('0x31')](db[_0xba63('0x32')][_0xba63('0x33')]({'where':{'id':_[_0xba63('0x34')](_0x3f3e4d,_0xba63('0x30'))},'raw':!![]}));}}return BPromise[_0xba63('0x35')](_0x1c7bc1)[_0xba63('0x2c')](function(_0x34b76b){for(var _0xfce2bb=0x0;_0xfce2bb<_0x34b76b[_0xba63('0x2e')];_0xfce2bb++){if(_0x34b76b[_0xfce2bb]){var _0x5df69b=_0xba63('0x30')+_0x34b76b[_0xfce2bb]['id'];var _0x47bee4=_0x3f3fd7[_0x5df69b];_0x47bee4[_0xba63('0x36')]=_0x34b76b[_0xfce2bb][_0xba63('0x37')];}}return _0x3f3fd7;});})[_0xba63('0x2c')](function(_0xf1fcf6){_0x2dfccb[_0xba63('0x38')]=_[_0xba63('0x2d')](_0xf1fcf6);_0x2dfccb[_0xba63('0x39')]=_['keys'](_0x164ef9[_0xba63('0x39')]);_0x2dfccb[_0xba63('0x3a')]=_[_0xba63('0x3b')](_0x2dfccb[_0xba63('0x38')],_0x2dfccb[_0xba63('0x39')]);_0x23e094[_0xba63('0x3c')]=_[_0xba63('0x3b')](_0x2dfccb[_0xba63('0x38')],qs['fields'](_0x164ef9[_0xba63('0x39')]['fields']));_0x23e094[_0xba63('0x3c')]=_0x23e094[_0xba63('0x3c')][_0xba63('0x2e')]?_0x23e094['attributes']:_0x2dfccb[_0xba63('0x38')];if(!_0x164ef9['query']['hasOwnProperty'](_0xba63('0x3d'))){_0x23e094['limit']=qs[_0xba63('0x22')](_0x164ef9['query'][_0xba63('0x22')]);_0x23e094[_0xba63('0x21')]=qs[_0xba63('0x21')](_0x164ef9['query'][_0xba63('0x21')]);}_0x23e094[_0xba63('0x3e')]=qs[_0xba63('0x3f')](_0x164ef9['query'][_0xba63('0x3f')]);_0x23e094['where']=qs['filters'](_['pick'](_0x164ef9[_0xba63('0x39')],_0x2dfccb['filters']),_0xf1fcf6);var _0x367a60=[];var _0x30354f=squel[_0xba63('0x40')]()[_0xba63('0x41')]('id')[_0xba63('0x41')](_0xba63('0x28'))[_0xba63('0x41')](_0xba63('0x42'))[_0xba63('0x43')](_0xba63('0x44'));var _0x15ed05=squel[_0xba63('0x40')]()[_0xba63('0x43')](_0xba63('0x45'),'c')['left_join'](_0xba63('0x46'),'uc','uc.CmContactId\x20=\x20c.id')[_0xba63('0x47')](_0xba63('0x48'),'ct','ct.CmContactId\x20=\x20c.id')[_0xba63('0x47')](_0xba63('0x44'),'t','t.id\x20=\x20ct.TagId')[_0xba63('0x49')](_0xba63('0x4a'));var _0x45baf0=squel['expr']();var _0x21f124=[];var _0x1c7866=squel['expr']();var _0x43e8fb;if(_0x164ef9['query'][_0xba63('0x4b')]){_0x43e8fb=as[_0xba63('0x4c')](_0x164ef9['query'][_0xba63('0x4b')]);var _0x51587a=_0x43e8fb[_0xba63('0x4d')];for(var _0x4c6622=0x0;_0x4c6622<_0x43e8fb[_0xba63('0x4e')][_0xba63('0x2e')];_0x4c6622++){var _0x1ae7b4=_0x43e8fb['conditions'][_0x4c6622];var _0x37a425='c';var _0x5588fa=_(_0xf1fcf6)['keys']()[_0xba63('0x4f')](function(_0x58b645){return _0x58b645===_0x1ae7b4[_0xba63('0x41')];});if(_0x5588fa)_0x5588fa=_0xf1fcf6[_0x1ae7b4[_0xba63('0x41')]];if(!_0x5588fa){if(_0x1ae7b4[_0xba63('0x41')]===_0xba63('0x50')){var _0xb588ed=_0x1ae7b4[_0xba63('0x51')][_0xba63('0x52')](',')[_0xba63('0x53')](function(_0x4d607d){return Number(_0x4d607d);});_0xb588ed[_0xba63('0x54')](function(_0x263c6c){_0x1c7866['or'](_0xba63('0x55'),'%,'+_0x263c6c+',%');});_0x21f124=_[_0xba63('0x56')](_0x21f124,_0xb588ed);}else if(_0x1ae7b4['field']==='User'){_0x45baf0['and'](_0xba63('0x57'),_0x1ae7b4[_0xba63('0x51')]);}}else{if(_0x1ae7b4[_0xba63('0x41')]==='dateOfBirth'||_0x5588fa[_0xba63('0x36')]===_0xba63('0x58'))_0x1ae7b4[_0xba63('0x59')]=_0xba63('0x5a');var _0xef0066=as['buildExpression'](_0x37a425,_0x5588fa[_0xba63('0x37')],_0x1ae7b4);_0x45baf0[_0x51587a](_0xef0066[_0xba63('0x5b')],_0xef0066[_0xba63('0x51')][_0xba63('0x5c')],_0xef0066[_0xba63('0x51')]['end']);}}}else{var _0x288f3c=_(Object[_0xba63('0x2d')](_0x164ef9[_0xba63('0x39')]))[_0xba63('0x53')](function(_0x16bde4){return _0xf1fcf6[_0xba63('0x5d')](_0x16bde4)?_0x16bde4:undefined;})['filter'](function(_0x3acac3){return!_[_0xba63('0x5e')](_0x3acac3);})[_0xba63('0x51')]();if(_0x164ef9[_0xba63('0x39')]['Contact'])_0x288f3c[_0xba63('0x31')](_0xba63('0x5f'));if(!_[_0xba63('0x60')](_0x288f3c)){_0x288f3c[_0xba63('0x54')](function(_0x31da1b){if(_0x31da1b===_0xba63('0x61')){_0x15ed05[_0xba63('0x49')](_0xba63('0x62'),[]['concat'](_0x164ef9[_0xba63('0x39')][_0x31da1b]));}else if(_0x31da1b===_0xba63('0x5f')){var _0x21fe93='%'+_0x164ef9[_0xba63('0x39')][_0x31da1b]+'%';_0x15ed05[_0xba63('0x49')](_0xba63('0x63'),_0x21fe93);}else{_0x15ed05['where']('c.'+_0x31da1b+_0xba63('0x64'),_0x164ef9[_0xba63('0x39')][_0x31da1b]);}});}if(_0x164ef9[_0xba63('0x39')]['tag']){_0x21f124=_[_0xba63('0x65')](_0x164ef9[_0xba63('0x39')][_0xba63('0x66')])?_0x164ef9[_0xba63('0x39')][_0xba63('0x66')]:new Array(_0x164ef9[_0xba63('0x39')]['tag']);_0x21f124[_0xba63('0x54')](function(_0x388175){_0x1c7866['or'](_0xba63('0x55'),'%,'+_0x388175+',%');});}if(_0x164ef9[_0xba63('0x39')][_0xba63('0x67')]){var _0x4e7c47=_0x164ef9['query']['filter'][_0xba63('0x68')]('\x5c','\x5c\x5c')[_0xba63('0x68')]('\x27\x27',_0xba63('0x69'));if(_0x4e7c47[_0xba63('0x52')]('\x20')[_0xba63('0x2e')]>0x1){_0x45baf0['or'](_0xba63('0x6a'),qs[_0xba63('0x6b')](_0x4e7c47),null);}else{if(qs[_0xba63('0x6c')](_0x4e7c47)){_0x45baf0['or'](_0xba63('0x6d'),_0x4e7c47+'%');_0x45baf0['or'](_0xba63('0x6e'),_0x4e7c47+'%');_0x45baf0['or']('c.mobile\x20LIKE\x20?',_0x4e7c47+'%');_0x45baf0['or'](_0xba63('0x6f'),_0x4e7c47+'%');}else if(qs[_0xba63('0x70')](_0x4e7c47)){_0x45baf0['or'](_0xba63('0x71'),_0x4e7c47+'%');}else{_0x45baf0['or'](_0xba63('0x72'),'%'+_0x4e7c47+'%');_0x45baf0['or']('c.lastName\x20LIKE\x20?','%'+_0x4e7c47+'%');_0x45baf0['or'](_0xba63('0x71'),'%'+_0x4e7c47+'%');}}}}_0x15ed05['where'](_0x45baf0);_0x15ed05['group'](_0xba63('0x73'));var _0xc59203={'type':db['Sequelize']['QueryTypes']['SELECT'],'raw':!![]};var _0x16ca4a=_0x15ed05[_0xba63('0x74')]()[_0xba63('0x41')]('c.id');if(_0x23e094[_0xba63('0x3e')]){_0x23e094['order'][_0xba63('0x54')](function(_0x4c90e2){_0x15ed05[_0xba63('0x3e')]('c.'+_0x4c90e2[0x0],_0x4c90e2[0x1]===_0xba63('0x75')?![]:!![]);});}if(!_['isEmpty'](_0x21f124)){_0x15ed05[_0xba63('0x76')](_0x1c7866);_0x16ca4a[_0xba63('0x49')](_0xba63('0x77'),_0x21f124);}BPromise[_0xba63('0x78')]()[_0xba63('0x2c')](function(){if(_0x43e8fb&&!_[_0xba63('0x79')](_0x43e8fb['conditions'],[_0xba63('0x41'),'User'])){return _0x164ef9[_0xba63('0x7a')][_0xba63('0x7b')]({'attributes':['id'],'raw':!![]})[_0xba63('0x2c')](function(_0x537c4b){if(_['isEmpty'](_0x537c4b)){_0x16ca4a['where']('c.ListId\x20IS\x20NULL');_0x15ed05[_0xba63('0x49')]('c.ListId\x20IS\x20NULL');}else{_0x16ca4a['where'](_0xba63('0x62'),_[_0xba63('0x53')](_0x537c4b,'id'));_0x15ed05[_0xba63('0x49')](_0xba63('0x62'),_[_0xba63('0x53')](_0x537c4b,'id'));}});}else{return;}})[_0xba63('0x2c')](function(){db[_0xba63('0x7c')][_0xba63('0x39')](_0x16ca4a[_0xba63('0x7d')](),_0xc59203)['then'](function(_0x11f9fb){_0x2d7281[_0xba63('0x20')]=_0x11f9fb[_0xba63('0x2e')];if(_0x2d7281[_0xba63('0x20')]===0x0)return[];return db['sequelize'][_0xba63('0x39')](_0x30354f['toString'](),_0xc59203);})[_0xba63('0x2c')](function(_0xabea96){_0x367a60=_['keyBy'](_0xabea96,'id');_0xc59203=_[_0xba63('0x7e')](_0xc59203,{'model':db[_0xba63('0x2b')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x164ef9[_0xba63('0x39')][_0xba63('0x7f')]){_0x23e094[_0xba63('0x3c')][_0xba63('0x54')](function(_0x52f465){_0x15ed05['field']('c.'+_0x52f465);});}else{_0x15ed05[_0xba63('0x41')]('c.id');_0x15ed05[_0xba63('0x41')](_0xba63('0x80'));_0x15ed05['field'](_0xba63('0x81'));_0x15ed05[_0xba63('0x41')]('c.phone');_0x15ed05[_0xba63('0x41')]('c.mobile');_0x15ed05[_0xba63('0x41')]('c.fax');_0x15ed05[_0xba63('0x41')](_0xba63('0x82'));_0x15ed05['field']('c.ListId');_0x15ed05['field'](_0xba63('0x83'));_0x15ed05['field'](_0xba63('0x84'),_0xba63('0x85'));}if(_0x23e094['limit'])_0x15ed05[_0xba63('0x22')](_0x23e094[_0xba63('0x22')]);if(_0x23e094[_0xba63('0x21')])_0x15ed05['offset'](_0x23e094[_0xba63('0x21')]);return db[_0xba63('0x7c')][_0xba63('0x39')](_0x15ed05['toString'](),_0xc59203);})['then'](function(_0x4f9120){_0x4f9120['forEach'](function(_0x5b42b6){if(_0x5b42b6[_0xba63('0x85')]){_0x5b42b6[_0xba63('0x86')]=[];_0x5b42b6['TagIds'][_0xba63('0x52')](',')['forEach'](function(_0xd1f01b){_0x5b42b6['Tags'][_0xba63('0x31')](_0x367a60[_0xd1f01b]);});}delete _0x5b42b6[_0xba63('0x85')];});_0x2d7281[_0xba63('0x87')]=_0x4f9120;return _0x2d7281;})[_0xba63('0x2c')](respondWithFilteredResult(_0x4bbb29,_0x23e094));});})['catch'](handleError(_0x4bbb29,null));};exports[_0xba63('0x88')]=function(_0x4c609e,_0x28be1e){return db[_0xba63('0x2b')][_0xba63('0x4f')]({'where':{'id':_0x4c609e[_0xba63('0x89')]['id']}})[_0xba63('0x2c')](handleEntityNotFound(_0x28be1e,null))[_0xba63('0x2c')](removeEntity(_0x28be1e,null))[_0xba63('0x8a')](handleError(_0x28be1e,null));};exports[_0xba63('0x8b')]=function(_0x15cf47,_0x291cd2){return db[_0xba63('0x2b')][_0xba63('0x8b')]()['then'](function(_0x223363){delete _0x223363[_0xba63('0x8c')];for(var _0x56af68=0x0;_0x56af68<Object[_0xba63('0x2d')](_0x223363)[_0xba63('0x2e')];_0x56af68++){var _0x5e0b31=Object[_0xba63('0x2d')](_0x223363)[_0x56af68];if(!_[_0xba63('0x2f')](_0x5e0b31,_0xba63('0x30'))){_0x223363[_0x5e0b31][_0xba63('0x8d')]=_0x5e0b31;_0x223363[_0x5e0b31][_0xba63('0x8e')]=_0x5e0b31;}}return _0x223363;})[_0xba63('0x2c')](function(_0x18b671){var _0x271d1e={'where':{'$or':[{'ListId':_0x15cf47['query']['id']},{'ListId':null}]},'raw':!![]};return db[_0xba63('0x32')][_0xba63('0x8f')](_0x271d1e)[_0xba63('0x2c')](function(_0x12c07d){for(var _0x4e59a0=0x0;_0x4e59a0<_0x12c07d[_0xba63('0x2e')];_0x4e59a0++){var _0x3c898c='cf_'+_0x12c07d[_0x4e59a0]['id'];_0x18b671[_0x3c898c][_0xba63('0x8d')]=_0x3c898c;_0x18b671[_0x3c898c]['displayName']=_0x12c07d[_0x4e59a0][_0xba63('0x90')];_0x18b671[_0x3c898c][_0xba63('0x91')]={'type':_0x12c07d[_0x4e59a0]['type'],'values':_0x12c07d[_0x4e59a0][_0xba63('0x92')]};}Object[_0xba63('0x2d')](_0x18b671)[_0xba63('0x54')](function(_0x7b7e84){if(!_0x18b671[_0x7b7e84][_0xba63('0x5d')]('columnName')){delete _0x18b671[_0x7b7e84];}});return _0x18b671;});})[_0xba63('0x2c')](respondWithResult(_0x291cd2,null))[_0xba63('0x8a')](handleError(_0x291cd2,null));};exports['merge']=function(_0x369cfd,_0x5a5a46){var _0x1e57b9;var _0x5c8e75;var _0x3dadfe;if(_0x369cfd[_0xba63('0x93')]['id']){delete _0x369cfd[_0xba63('0x93')]['id'];}return db['CmContact'][_0xba63('0x8f')]({'where':{'id':[_0x369cfd[_0xba63('0x93')]['to'],_0x369cfd['body'][_0xba63('0x43')]]}})[_0xba63('0x2c')](function(_0x46fcc4){if(_0x46fcc4){if(_0x46fcc4[_0xba63('0x2e')]!==0x2){return null;}_0x46fcc4[0x0]=_0x46fcc4[0x0][_0xba63('0x94')]({'plain':!![]});_0x46fcc4[0x1]=_0x46fcc4[0x1]['get']({'plain':!![]});delete _0x46fcc4[0x0]['id'];delete _0x46fcc4[0x1]['id'];return _[_0xba63('0x95')](_0x46fcc4[0x0],_0x46fcc4[0x1],function(_0x4df775,_0x4fdfc2){if(Array[_0xba63('0x65')](_0x4fdfc2)&&!_0x4fdfc2[_0xba63('0x2e')]){return _0x4df775;}else if(!_0x4fdfc2){return _0x4df775;}});}})['then'](handleEntityNotFound(_0x5a5a46,null))['then'](function(_0x419639){if(_0x419639){if(_0x419639[_0xba63('0x8c')]&&_[_0xba63('0x65')](_0x419639[_0xba63('0x8c')])){_0x419639[_0xba63('0x8c')]=_0x419639[_0xba63('0x8c')][_0xba63('0x96')]();}logger[_0xba63('0x97')](_0xba63('0x98'),_0x369cfd[_0xba63('0x93')]['to'],_0x369cfd[_0xba63('0x93')][_0xba63('0x43')]);return db[_0xba63('0x99')][_0xba63('0x88')]({'where':{'ContactId':[_0x369cfd[_0xba63('0x93')]['to'],_0x369cfd[_0xba63('0x93')][_0xba63('0x43')]]}})[_0xba63('0x2c')](function(_0x2f6942){logger['info']('[CmContact][merge][destroy][CmHopper],\x20%s',_0x2f6942);return db[_0xba63('0x9a')][_0xba63('0x88')]({'where':{'ContactId':[_0x369cfd['body']['to'],_0x369cfd[_0xba63('0x93')]['from']]}})[_0xba63('0x2c')](function(_0x30fe8c){logger['info'](_0xba63('0x9b'),_0x30fe8c);return db['CmContact'][_0xba63('0x9c')](_0x419639);});});}})['then'](function(_0x46a980){if(_0x46a980){_0x1e57b9=_0x46a980;_0x5c8e75={'ContactId':_0x1e57b9['id']};_0x3dadfe={'where':{'ContactId':[_0x369cfd[_0xba63('0x93')]['to'],_0x369cfd['body'][_0xba63('0x43')]]}};return db[_0xba63('0x9d')]['update'](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db[_0xba63('0x9e')]['update'](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db[_0xba63('0x9f')]['update'](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db[_0xba63('0xa0')][_0xba63('0xa1')](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db[_0xba63('0xa2')][_0xba63('0xa1')](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db['MailInteraction'][_0xba63('0xa1')](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db['MailMessage'][_0xba63('0xa1')](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db['SmsInteraction']['update'](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db[_0xba63('0xa3')][_0xba63('0xa1')](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db[_0xba63('0xa4')][_0xba63('0xa1')](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db[_0xba63('0xa5')]['update'](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db[_0xba63('0xa6')]['update'](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db[_0xba63('0xa7')][_0xba63('0xa1')](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db[_0xba63('0xa8')][_0xba63('0xa1')](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db[_0xba63('0xa9')][_0xba63('0xa1')](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db[_0xba63('0xaa')]['update'](_0x5c8e75,_0x3dadfe);}})['then'](function(){if(_0x1e57b9){return db[_0xba63('0xab')]['update'](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db[_0xba63('0xac')][_0xba63('0xa1')](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db[_0xba63('0xad')][_0xba63('0xa1')](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db[_0xba63('0xae')][_0xba63('0xa1')](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db[_0xba63('0xaf')][_0xba63('0xa1')](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db['SmsQueueReport'][_0xba63('0xa1')](_0x5c8e75,_0x3dadfe);}})['then'](function(){if(_0x1e57b9){return db[_0xba63('0xb0')]['update'](_0x5c8e75,_0x3dadfe);}})[_0xba63('0x2c')](function(){if(_0x1e57b9){return db[_0xba63('0x2b')][_0xba63('0x88')]({'where':{'id':[_0x369cfd['body']['to'],_0x369cfd[_0xba63('0x93')]['from']]}});}})['then'](function(){if(_0x1e57b9){return _0x1e57b9;}})['then'](respondWithResult(_0x5a5a46,null))[_0xba63('0x8a')](handleError(_0x5a5a46,null));};exports[_0xba63('0x9c')]=function(_0x23b82d,_0xc6e84){return db[_0xba63('0x2b')][_0xba63('0x8b')]()['then'](function(_0x1c6c17){if(_0x23b82d[_0xba63('0x93')][_0xba63('0x8c')]&&_[_0xba63('0x65')](_0x23b82d['body'][_0xba63('0x8c')])){if(_0x23b82d['body']['tags']['length']){_0x23b82d[_0xba63('0x93')][_0xba63('0x8c')]=_0x23b82d['body'][_0xba63('0x8c')][_0xba63('0x96')](';')+';';}else{_0x23b82d[_0xba63('0x93')][_0xba63('0x8c')]=null;}}else{_0x23b82d['body'][_0xba63('0x8c')]=null;}return db[_0xba63('0x2b')][_0xba63('0x9c')](_0x23b82d['body'],{'fields':_[_0xba63('0x2d')](_0x1c6c17),'raw':!![]});})['then'](respondWithResult(_0xc6e84,0xc9))[_0xba63('0x8a')](handleError(_0xc6e84,null));};exports[_0xba63('0xb1')]=function(_0x460e96,_0x542022){var _0x1d2cc5=[];var _0x4c4410=0x0;var _0x42b9f3=0x0;var _0x4c05db=0x0;return db[_0xba63('0x2b')][_0xba63('0x8b')]()[_0xba63('0x2c')](function(_0x400b23){return BPromise[_0xba63('0xb2')](_0x460e96[_0xba63('0x93')],function(_0x522f9b){var _0x3ea115={'where':{'$or':[]},'defaults':_0x522f9b,'fields':_[_0xba63('0x2d')](_0x400b23),'raw':!![]};if(_0x522f9b[_0xba63('0xb3')]){for(var _0x1d4e09=0x0;_0x1d4e09<_0x522f9b[_0xba63('0xb3')][_0xba63('0x2e')];_0x1d4e09++){var _0x4b7bff={};_0x4b7bff[_0x522f9b[_0xba63('0xb3')][_0x1d4e09]]=_0x522f9b[_0x522f9b[_0xba63('0xb3')][_0x1d4e09]];_0x3ea115['where']['$or']['push'](_0x4b7bff);}_0x3ea115[_0xba63('0x49')][_0xba63('0x61')]=_0x522f9b[_0xba63('0x61')];}return db['CmContact']['findOrCreate'](_0x3ea115)[_0xba63('0xb4')](function(_0x1dc9f1,_0x222ee3){if(_0x222ee3){_0x4c4410++;}else{_0x4c05db++;}})[_0xba63('0x8a')](function(_0x28772b){console['error'](_0x28772b);_0x42b9f3++;});});})['then'](function(_0x430a1c){if(_0x430a1c){return{'success':_0x4c4410,'failure':_0x42b9f3,'duplicates':_0x4c05db};}})['then'](respondWithResult(_0x542022,0xc9))[_0xba63('0x8a')](handleError(_0x542022,null));};exports[_0xba63('0xb5')]=function(_0x5b0879,_0x3f9c91,_0x180925){var _0x51a3d1;return db['CmContact'][_0xba63('0x8b')]()[_0xba63('0x2c')](function(_0x15708b){return db[_0xba63('0x2b')][_0xba63('0x4f')]({'where':{'id':_0x5b0879[_0xba63('0x89')]['id']},'include':[{'model':db[_0xba63('0x50')],'as':_0xba63('0x86'),'attributes':['id',_0xba63('0x28'),_0xba63('0x42')],'required':_0x5b0879[_0xba63('0x39')][_0xba63('0x66')]?!![]:![]}],'attributes':_['keys'](_0x15708b)});})[_0xba63('0x2c')](function(_0x3bdc9e){_0x51a3d1=_0x3bdc9e[_0xba63('0x94')]({'plain':!![]});var _0x42bb1e={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x3bdc9e&&_0x3bdc9e[_0xba63('0x61')]){if(_0x3bdc9e['ListId']){_0x42bb1e[_0xba63('0x49')]['$and'][_0xba63('0x31')]({'ListId':{'$ne':_0x3bdc9e[_0xba63('0x61')]}});}}return db[_0xba63('0x32')]['findAll'](_0x42bb1e);})['then'](function(_0x1ff9a3){return _[_0xba63('0xb6')](_0x51a3d1,_[_0xba63('0x53')](_0x1ff9a3,function(_0x16cdea){return util[_0xba63('0xb7')](_0xba63('0xb8'),_0x16cdea['id']);}));})[_0xba63('0x2c')](handleEntityNotFound(_0x3f9c91,null))[_0xba63('0x2c')](respondWithResult(_0x3f9c91,null))[_0xba63('0x8a')](handleError(_0x3f9c91,null));};exports['update']=function(_0x5aee57,_0x5c2a9b){var _0x1c1df1;if(_0x5aee57[_0xba63('0x93')]['id']){delete _0x5aee57[_0xba63('0x93')]['id'];}return db[_0xba63('0x2b')][_0xba63('0x4f')]({'where':{'id':_0x5aee57['params']['id']}})[_0xba63('0x2c')](handleEntityNotFound(_0x5c2a9b,null))[_0xba63('0x2c')](saveUpdates(_0x5aee57['body'],null))[_0xba63('0x2c')](function(_0x655737){_0x1c1df1=_0x655737;var _0x158557={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x655737&&_0x655737[_0xba63('0x61')]){if(_0x655737[_0xba63('0x61')]){_0x158557[_0xba63('0x49')][_0xba63('0xb9')][_0xba63('0x31')]({'ListId':{'$ne':_0x655737[_0xba63('0x61')]}});}}return db[_0xba63('0x32')]['findAll'](_0x158557);})['then'](function(_0xc43d9){if(_0xc43d9){return _['omit'](_[_0xba63('0xba')](_0x5aee57[_0xba63('0x93')],function(_0x480a0d,_0x1b32a8){return _[_0xba63('0x2f')](_0x1b32a8,_0xba63('0x30'));}),_[_0xba63('0x53')](_0xc43d9,function(_0x40b20b){return util[_0xba63('0xb7')](_0xba63('0xb8'),_0x40b20b['id']);}));}})[_0xba63('0x2c')](function(_0x27b2ef){if(_0x27b2ef&&!_['isEmpty'](_0x27b2ef)){var _0x150c1c=squel['update']()['table'](_0xba63('0x45'))[_0xba63('0xbb')](_0x27b2ef)['where']('id\x20=\x20?',_0x5aee57[_0xba63('0x89')]['id'])[_0xba63('0xbc')]();return db['sequelize'][_0xba63('0x39')](_0x150c1c['text'],{'replacements':_0x150c1c[_0xba63('0x92')]});}})[_0xba63('0x2c')](function(){if(_0x5aee57[_0xba63('0x93')][_0xba63('0xbd')]&&_0x1c1df1){return db['CmHopper'][_0xba63('0xa1')]({'phone':_0x5aee57[_0xba63('0x93')][_0xba63('0xbd')]},{'where':{'ContactId':_0x1c1df1['id']}});}})[_0xba63('0x2c')](function(){return _0x1c1df1;})[_0xba63('0x2c')](respondWithResult(_0x5c2a9b,null))['catch'](handleError(_0x5c2a9b,null));};exports[_0xba63('0xbe')]=function(_0x3947a1,_0x3c2810,_0x52644d){var _0xe03264={};var _0x263c60={};var _0x3fab62;var _0x112711;return db['CmContact'][_0xba63('0x33')]({'where':{'id':_0x3947a1[_0xba63('0x89')]['id']}})['then'](handleEntityNotFound(_0x3c2810,null))[_0xba63('0x2c')](function(_0x2c3ceb){if(_0x2c3ceb){_0x3fab62=_0x2c3ceb;_0x263c60[_0xba63('0x38')]=_[_0xba63('0x2d')](db[_0xba63('0x50')][_0xba63('0xbf')]);_0x263c60[_0xba63('0x39')]=_[_0xba63('0x2d')](_0x3947a1[_0xba63('0x39')]);_0x263c60[_0xba63('0x3a')]=_['intersection'](_0x263c60[_0xba63('0x38')],_0x263c60[_0xba63('0x39')]);_0xe03264[_0xba63('0x3c')]=_[_0xba63('0x3b')](_0x263c60[_0xba63('0x38')],qs[_0xba63('0x7f')](_0x3947a1['query'][_0xba63('0x7f')]));_0xe03264[_0xba63('0x3c')]=_0xe03264[_0xba63('0x3c')][_0xba63('0x2e')]?_0xe03264[_0xba63('0x3c')]:_0x263c60['model'];_0xe03264['order']=qs[_0xba63('0x3f')](_0x3947a1['query']['sort']);_0xe03264['where']=qs[_0xba63('0x3a')](_[_0xba63('0xc0')](_0x3947a1[_0xba63('0x39')],_0x263c60[_0xba63('0x3a')]));if(_0x3947a1[_0xba63('0x39')][_0xba63('0x67')]){_0xe03264[_0xba63('0x49')]=_['merge'](_0xe03264['where'],{'$or':_[_0xba63('0x53')](_0xe03264[_0xba63('0x3c')],function(_0x30b366){var _0x1e30dc={};_0x1e30dc[_0x30b366]={'$like':'%'+_0x3947a1[_0xba63('0x39')]['filter']+'%'};return _0x1e30dc;})});}_0xe03264=_[_0xba63('0x7e')]({},_0xe03264,_0x3947a1[_0xba63('0xc1')]);return _0x3fab62[_0xba63('0xbe')](_0xe03264);}})[_0xba63('0x2c')](function(_0x7daf8e){if(_0x7daf8e){_0x112711=_0x7daf8e['length'];if(!_0x3947a1['query']['hasOwnProperty']('nolimit')){_0xe03264[_0xba63('0x22')]=qs[_0xba63('0x22')](_0x3947a1[_0xba63('0x39')][_0xba63('0x22')]);_0xe03264[_0xba63('0x21')]=qs[_0xba63('0x21')](_0x3947a1['query']['offset']);}return _0x3fab62[_0xba63('0xbe')](_0xe03264);}})[_0xba63('0x2c')](function(_0x1a2c6f){if(_0x1a2c6f){return _0x1a2c6f?{'count':_0x112711,'rows':_0x1a2c6f}:null;}})['then'](respondWithResult(_0x3c2810,null))[_0xba63('0x8a')](handleError(_0x3c2810,null));};exports[_0xba63('0xc2')]=function(_0x470782,_0x1832be,_0x41e3d3){if(_0x470782[_0xba63('0x93')]['id']){delete _0x470782['body']['id'];}return db['CmContact'][_0xba63('0x33')]({'where':{'id':_0x470782[_0xba63('0x89')]['id']}})['then'](handleEntityNotFound(_0x1832be,null))[_0xba63('0x2c')](function(_0x19981f){if(_0x19981f){return _0x19981f[_0xba63('0xc2')](_0x470782[_0xba63('0x93')][_0xba63('0xc3')]||[]);}return null;})[_0xba63('0x2c')](respondWithResult(_0x1832be,null))[_0xba63('0x8a')](handleError(_0x1832be,null));};exports[_0xba63('0xc4')]=function(_0x839ef9,_0x2ffd78,_0x20b709){var _0x222d58={'raw':![],'where':{}};var _0x3561e9={};var _0x4c3f15={'count':0x0,'rows':[]};return db[_0xba63('0x2b')][_0xba63('0x33')]({'where':{'id':_0x839ef9[_0xba63('0x89')]['id']}})[_0xba63('0x2c')](handleEntityNotFound(_0x2ffd78,null))[_0xba63('0x2c')](function(_0x59059b){if(_0x59059b){_0x3561e9[_0xba63('0x38')]=_['keys'](db[_0xba63('0x99')][_0xba63('0xbf')]);_0x3561e9[_0xba63('0x39')]=_['keys'](_0x839ef9[_0xba63('0x39')]);_0x3561e9['filters']=_[_0xba63('0x3b')](_0x3561e9[_0xba63('0x38')],_0x3561e9[_0xba63('0x39')]);_0x222d58['attributes']=_[_0xba63('0x3b')](_0x3561e9[_0xba63('0x38')],qs[_0xba63('0x7f')](_0x839ef9[_0xba63('0x39')]['fields']));_0x222d58['attributes']=_0x222d58[_0xba63('0x3c')][_0xba63('0x2e')]?_0x222d58['attributes']:_0x3561e9['model'];if(!_0x839ef9[_0xba63('0x39')][_0xba63('0x5d')]('nolimit')){_0x222d58[_0xba63('0x22')]=qs[_0xba63('0x22')](_0x839ef9['query'][_0xba63('0x22')]);_0x222d58[_0xba63('0x21')]=qs[_0xba63('0x21')](_0x839ef9[_0xba63('0x39')][_0xba63('0x21')]);}_0x222d58[_0xba63('0x3e')]=qs[_0xba63('0x3f')](_0x839ef9[_0xba63('0x39')][_0xba63('0x3f')]);_0x222d58[_0xba63('0x49')]=qs[_0xba63('0x3a')](_['pick'](_0x839ef9[_0xba63('0x39')],_0x3561e9[_0xba63('0x3a')]));_0x222d58[_0xba63('0x49')]['ContactId']=_0x59059b['id'];if(_0x839ef9[_0xba63('0x39')]['filter']){_0x222d58[_0xba63('0x49')]=_[_0xba63('0x7e')](_0x222d58[_0xba63('0x49')],{'$or':_[_0xba63('0x53')](_0x222d58[_0xba63('0x3c')],function(_0x5a6570){var _0x4acee6={};_0x4acee6[_0x5a6570]={'$like':'%'+_0x839ef9[_0xba63('0x39')][_0xba63('0x67')]+'%'};return _0x4acee6;})});}_0x222d58=_[_0xba63('0x7e')]({},_0x222d58,_0x839ef9[_0xba63('0xc1')]);return db[_0xba63('0x99')][_0xba63('0x20')]({'where':_0x222d58[_0xba63('0x49')]})[_0xba63('0x2c')](function(_0x327063){_0x4c3f15['count']=_0x327063;if(_0x839ef9['query'][_0xba63('0xc5')]){_0x222d58[_0xba63('0xc6')]=[{'all':!![]}];}return db[_0xba63('0x99')][_0xba63('0x8f')](_0x222d58);})[_0xba63('0x2c')](function(_0x54363a){_0x4c3f15[_0xba63('0x87')]=_0x54363a;return _0x4c3f15;});}})[_0xba63('0x2c')](respondWithFilteredResult(_0x2ffd78,_0x222d58))[_0xba63('0x8a')](handleError(_0x2ffd78,null));};exports[_0xba63('0xc7')]=function(_0x292089,_0x19fd2f,_0x5706c4){var _0x19b732={'raw':!![],'where':{}};var _0x5e381c={};var _0x5672cd={'count':0x0,'rows':[]};return db[_0xba63('0x2b')][_0xba63('0x33')]({'where':{'id':_0x292089[_0xba63('0x89')]['id']}})[_0xba63('0x2c')](handleEntityNotFound(_0x19fd2f,null))[_0xba63('0x2c')](function(_0x584311){if(_0x584311){_0x5e381c[_0xba63('0x38')]=_[_0xba63('0x2d')](db[_0xba63('0xa9')][_0xba63('0xbf')]);_0x5e381c[_0xba63('0x39')]=_[_0xba63('0x2d')](_0x292089['query']);_0x5e381c['filters']=_[_0xba63('0x3b')](_0x5e381c['model'],_0x5e381c['query']);_0x19b732[_0xba63('0x3c')]=_[_0xba63('0x3b')](_0x5e381c[_0xba63('0x38')],qs['fields'](_0x292089[_0xba63('0x39')][_0xba63('0x7f')]));_0x19b732[_0xba63('0x3c')]=_0x19b732[_0xba63('0x3c')][_0xba63('0x2e')]?_0x19b732[_0xba63('0x3c')]:_0x5e381c['model'];if(!_0x292089[_0xba63('0x39')][_0xba63('0x5d')](_0xba63('0x3d'))){_0x19b732['limit']=qs[_0xba63('0x22')](_0x292089[_0xba63('0x39')]['limit']);_0x19b732[_0xba63('0x21')]=qs[_0xba63('0x21')](_0x292089[_0xba63('0x39')][_0xba63('0x21')]);}_0x19b732[_0xba63('0x3e')]=qs[_0xba63('0x3f')](_0x292089['query'][_0xba63('0x3f')]);_0x19b732[_0xba63('0x49')]=qs['filters'](_['pick'](_0x292089[_0xba63('0x39')],_0x5e381c['filters']));_0x19b732[_0xba63('0x49')][_0xba63('0xc8')]=_0x584311['id'];if(_0x292089[_0xba63('0x39')][_0xba63('0x67')]){_0x19b732[_0xba63('0x49')]=_[_0xba63('0x7e')](_0x19b732[_0xba63('0x49')],{'$or':_[_0xba63('0x53')](_0x19b732[_0xba63('0x3c')],function(_0x3f8a54){var _0x2fa0ac={};_0x2fa0ac[_0x3f8a54]={'$like':'%'+_0x292089['query']['filter']+'%'};return _0x2fa0ac;})});}_0x19b732=_['merge']({},_0x19b732,_0x292089[_0xba63('0xc1')]);return db[_0xba63('0xa9')]['count']({'where':_0x19b732['where']})['then'](function(_0x512688){_0x5672cd[_0xba63('0x20')]=_0x512688;if(_0x292089[_0xba63('0x39')][_0xba63('0xc5')]){_0x19b732[_0xba63('0xc6')]=[{'all':!![]}];}return db['CmHopperHistory'][_0xba63('0x8f')](_0x19b732);})[_0xba63('0x2c')](function(_0xefdc52){_0x5672cd[_0xba63('0x87')]=_0xefdc52;return _0x5672cd;});}})[_0xba63('0x2c')](respondWithFilteredResult(_0x19fd2f,_0x19b732))['catch'](handleError(_0x19fd2f,null));};exports['getHopperFinals']=function(_0x2f3c3e,_0x400931,_0x13df92){var _0x4c346b={'raw':!![],'where':{}};var _0x1b1688={};var _0x1c7e7a={'count':0x0,'rows':[]};return db[_0xba63('0x2b')][_0xba63('0x33')]({'where':{'id':_0x2f3c3e[_0xba63('0x89')]['id']}})[_0xba63('0x2c')](handleEntityNotFound(_0x400931,null))['then'](function(_0x2fab0b){if(_0x2fab0b){_0x1b1688['model']=_['keys'](db['CmHopperFinal'][_0xba63('0xbf')]);_0x1b1688[_0xba63('0x39')]=_[_0xba63('0x2d')](_0x2f3c3e[_0xba63('0x39')]);_0x1b1688['filters']=_['intersection'](_0x1b1688[_0xba63('0x38')],_0x1b1688['query']);_0x4c346b['attributes']=_['intersection'](_0x1b1688[_0xba63('0x38')],qs['fields'](_0x2f3c3e['query'][_0xba63('0x7f')]));_0x4c346b[_0xba63('0x3c')]=_0x4c346b[_0xba63('0x3c')][_0xba63('0x2e')]?_0x4c346b[_0xba63('0x3c')]:_0x1b1688[_0xba63('0x38')];if(!_0x2f3c3e[_0xba63('0x39')][_0xba63('0x5d')]('nolimit')){_0x4c346b[_0xba63('0x22')]=qs[_0xba63('0x22')](_0x2f3c3e[_0xba63('0x39')][_0xba63('0x22')]);_0x4c346b['offset']=qs[_0xba63('0x21')](_0x2f3c3e[_0xba63('0x39')][_0xba63('0x21')]);}_0x4c346b[_0xba63('0x3e')]=qs[_0xba63('0x3f')](_0x2f3c3e[_0xba63('0x39')][_0xba63('0x3f')]);_0x4c346b['where']=qs['filters'](_[_0xba63('0xc0')](_0x2f3c3e[_0xba63('0x39')],_0x1b1688[_0xba63('0x3a')]));_0x4c346b[_0xba63('0x49')][_0xba63('0xc8')]=_0x2fab0b['id'];if(_0x2f3c3e[_0xba63('0x39')][_0xba63('0x67')]){_0x4c346b[_0xba63('0x49')]=_[_0xba63('0x7e')](_0x4c346b[_0xba63('0x49')],{'$or':_[_0xba63('0x53')](_0x4c346b[_0xba63('0x3c')],function(_0x25d79a){var _0x4ebf7a={};_0x4ebf7a[_0x25d79a]={'$like':'%'+_0x2f3c3e[_0xba63('0x39')][_0xba63('0x67')]+'%'};return _0x4ebf7a;})});}_0x4c346b=_[_0xba63('0x7e')]({},_0x4c346b,_0x2f3c3e['options']);return db[_0xba63('0xa8')][_0xba63('0x20')]({'where':_0x4c346b[_0xba63('0x49')]})[_0xba63('0x2c')](function(_0x56bb07){_0x1c7e7a[_0xba63('0x20')]=_0x56bb07;if(_0x2f3c3e['query'][_0xba63('0xc5')]){_0x4c346b[_0xba63('0xc6')]=[{'all':!![]}];}return db[_0xba63('0xa8')][_0xba63('0x8f')](_0x4c346b);})[_0xba63('0x2c')](function(_0x189775){_0x1c7e7a[_0xba63('0x87')]=_0x189775;return _0x1c7e7a;});}})[_0xba63('0x2c')](respondWithFilteredResult(_0x400931,_0x4c346b))['catch'](handleError(_0x400931,null));};exports[_0xba63('0xc9')]=function(_0x119d49,_0x33a12f,_0x300575){var _0x3dae76={'raw':!![],'where':{}};var _0x28c808={};var _0x2ca54f={'count':0x0,'rows':[]};return db[_0xba63('0x2b')][_0xba63('0x33')]({'where':{'id':_0x119d49[_0xba63('0x89')]['id']}})[_0xba63('0x2c')](handleEntityNotFound(_0x33a12f,null))['then'](function(_0x777f8a){if(_0x777f8a){_0x28c808[_0xba63('0x38')]=_[_0xba63('0x2d')](db['JscriptySessionReport'][_0xba63('0xbf')]);_0x28c808['query']=_['keys'](_0x119d49[_0xba63('0x39')]);_0x28c808['filters']=_['intersection'](_0x28c808[_0xba63('0x38')],_0x28c808[_0xba63('0x39')]);_0x3dae76[_0xba63('0x3c')]=_['intersection'](_0x28c808['model'],qs['fields'](_0x119d49[_0xba63('0x39')][_0xba63('0x7f')]));_0x3dae76[_0xba63('0x3c')]=_0x3dae76[_0xba63('0x3c')]['length']?_0x3dae76[_0xba63('0x3c')]:_0x28c808[_0xba63('0x38')];if(!_0x119d49['query'][_0xba63('0x5d')]('nolimit')){_0x3dae76[_0xba63('0x22')]=qs[_0xba63('0x22')](_0x119d49[_0xba63('0x39')][_0xba63('0x22')]);_0x3dae76[_0xba63('0x21')]=qs['offset'](_0x119d49[_0xba63('0x39')][_0xba63('0x21')]);}_0x3dae76[_0xba63('0x3e')]=qs[_0xba63('0x3f')](_0x119d49['query'][_0xba63('0x3f')]);_0x3dae76[_0xba63('0x49')]=qs[_0xba63('0x3a')](_[_0xba63('0xc0')](_0x119d49[_0xba63('0x39')],_0x28c808[_0xba63('0x3a')]));_0x3dae76[_0xba63('0x49')]['ContactId']=_0x777f8a['id'];if(_0x119d49['query'][_0xba63('0x67')]){_0x3dae76['where']=_[_0xba63('0x7e')](_0x3dae76[_0xba63('0x49')],{'$or':_[_0xba63('0x53')](_0x3dae76[_0xba63('0x3c')],function(_0x11bd1c){var _0x411795={};_0x411795[_0x11bd1c]={'$like':'%'+_0x119d49[_0xba63('0x39')]['filter']+'%'};return _0x411795;})});}_0x3dae76=_[_0xba63('0x7e')]({},_0x3dae76,_0x119d49[_0xba63('0xc1')]);return db[_0xba63('0xb0')]['count']({'where':_0x3dae76[_0xba63('0x49')]})[_0xba63('0x2c')](function(_0x1f2770){_0x2ca54f[_0xba63('0x20')]=_0x1f2770;if(_0x119d49['query'][_0xba63('0xc5')]){_0x3dae76[_0xba63('0xc6')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0xba63('0x8f')](_0x3dae76);})[_0xba63('0x2c')](function(_0x3765d0){_0x2ca54f[_0xba63('0x87')]=_0x3765d0;return _0x2ca54f;});}})[_0xba63('0x2c')](respondWithFilteredResult(_0x33a12f,_0x3dae76))[_0xba63('0x8a')](handleError(_0x33a12f,null));};exports[_0xba63('0xca')]=function(_0x34cc95,_0x54061d,_0x1dfaab){try{if(!_0x34cc95[_0xba63('0x93')][_0xba63('0x61')]){throw new Error(_0xba63('0xcb'));}if(!_0x34cc95[_0xba63('0x93')]['binding_keys']){throw new Error('No\x20association\x20keys\x20specified!');}if(!_0x34cc95['body'][_0xba63('0xcc')]){throw new Error(_0xba63('0xcd'));}if(!_0x34cc95['body'][_0xba63('0xce')]){throw new Error(_0xba63('0xcf'));}var _0x3d1245=_0x34cc95[_0xba63('0x93')][_0xba63('0xd0')][_0xba63('0x52')](',');var _0x3bdfc0=_0x34cc95[_0xba63('0x93')][_0xba63('0xcc')][_0xba63('0x52')](',');if(!_0x3d1245[_0xba63('0x2e')]||!_0x3bdfc0[_0xba63('0x2e')]||_0x3d1245['length']!==_0x3bdfc0['length']){throw new Error(_0xba63('0xd1'));}_0x34cc95[_0xba63('0x93')]['fields']=_[_0xba63('0xd2')](_0x3d1245,_0x3bdfc0);if(!_0x34cc95[_0xba63('0x93')][_0xba63('0x7f')]['phone']){throw new Error(_0xba63('0xd3'));}if(!_0x34cc95[_0xba63('0x93')][_0xba63('0x7f')][_0xba63('0xd4')]){throw new Error(_0xba63('0xd5'));}var _0x5a603d=path[_0xba63('0x96')](config[_0xba63('0xd6')],'server/files/tmp',_0x34cc95['file'][_0xba63('0xd7')]);fs['chmodSync'](_0x5a603d,parseInt(_0xba63('0xd8'),0x8));var _0x506382=require(_0xba63('0xd9'))[_0xba63('0xda')](path[_0xba63('0x96')](__dirname,_0xba63('0xdb')),[_0x5a603d,_0x34cc95[_0xba63('0x93')][_0xba63('0xd0')],_0x34cc95[_0xba63('0x93')]['binding_values'],_0x34cc95[_0xba63('0x93')]['ListId'],_0x34cc95[_0xba63('0x93')][_0xba63('0xdc')],_0x34cc95[_0xba63('0x93')][_0xba63('0xb3')],_0x34cc95[_0xba63('0x93')][_0xba63('0xce')]]);return _0x54061d[_0xba63('0x1e')](0xc8)[_0xba63('0x1f')]({'message':_0xba63('0xdd'),'pid':_0x506382[_0xba63('0xde')]});}catch(_0x4abb73){return _0x54061d[_0xba63('0x1e')](0x1f4)[_0xba63('0x29')](_0x4abb73);}};exports[_0xba63('0xdf')]=function(_0x3fced4,_0xe9a932,_0x2dcc7c){var _0x1b4f19=fs['createReadStream'](_0x3fced4[_0xba63('0xe0')][_0xba63('0x7')]);Papa[_0xba63('0xe1')](_0x1b4f19,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x2609f5){return _0xe9a932[_0xba63('0x1e')](0xc8)['json']({'file':_0x3fced4[_0xba63('0xe0')],'fields':_0x2609f5[_0xba63('0xe2')]['fields']});}});};exports[_0xba63('0xe3')]=function(_0x4294de,_0x4af3d3,_0x1740bc){return db[_0xba63('0xe4')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0xba63('0xe5')}})[_0xba63('0x2c')](function(_0xbf0643){var _0x5cb633=![];if(!_0x4294de[_0xba63('0x93')][_0xba63('0x61')]){throw new Error(_0xba63('0xcb'));}if(!_0x4294de[_0xba63('0x93')][_0xba63('0xe6')][_0xba63('0xbd')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x4294de['body']['binding'][_0xba63('0xd4')]){throw new Error(_0xba63('0xd5'));}if(!_0x4294de[_0xba63('0x93')][_0xba63('0xce')]){throw new Error(_0xba63('0xcf'));}var _0x145adc=require(_0xba63('0xd9'))['fork'](path[_0xba63('0x96')](__dirname,'../../components/import/cm/csv2'),[_0x4294de[_0xba63('0x89')]['id'],JSON[_0xba63('0xe7')](_0x4294de[_0xba63('0x93')]),JSON['stringify'](_0xbf0643)]);_0x145adc['on']('message',function(_0x177741){_0x5cb633=!![];return _0x4af3d3[_0xba63('0x1e')](0xc8)[_0xba63('0x1f')]({'message':_0xba63('0xe8'),'pid':_0x145adc[_0xba63('0xde')]});});_0x145adc['on'](_0xba63('0xe9'),function(_0x2cbb5){if(_0x2cbb5&&!_0x5cb633){return _0x4af3d3[_0xba63('0x1e')](0x1f4)[_0xba63('0x1f')]({'message':'error\x20child\x20process','pid':_0x145adc[_0xba63('0xde')]});}});})[_0xba63('0x8a')](handleError(_0x4af3d3,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff