// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x6856=['nolimit','limit','order','sort','where','select','field','from','tools_tags','cm_contacts','cm_user_has_contacts','left_join','cm_contact_has_tags','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','c.deletedAt\x20IS\x20NULL','expr','search','parseSearch','conditions','find','Tag','value','split','map','forEach','union','User','and','uc.UserId\x20=\x20?','fieldType','castTo','DATE','buildExpression','type','text','start','filter','isNil','Contact','ListId','c.ListId\x20IN\x20?','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','isArray','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','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.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','c.email\x20LIKE\x20?','group','c.id','QueryTypes','SELECT','DESC','isEmpty','having','t.id\x20IN\x20?','resolve','some','user','getLists','c.ListId\x20IS\x20NULL','sequelize','toString','keyBy','merge','c.firstName','c.lastName','c.phone','c.fax','c.email','c.ListId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','catch','destroy','CmContact','params','describe','tags','columnName','displayName','findAll','custom','get','mergeWith','join','info','body','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','update','ChatOfflineMessage','MailInteraction','MailMessage','SmsMessage','FaxInteraction','FaxMessage','OpenchannelMessage','CmHopperFinal','CmHopperHistory','VoiceCallReport','ChatQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','bulkCreate','duplicates','$or','findOrCreate','Tags','$and','omit','format','table','setFields','id\x20=\x20?','toParam','values','phone','CmHopper','rawAttributes','getTags','setTags','getHoppers','pick','ContactId','options','includeAll','include','rows','getHopperHistories','getHopperFinals','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','No\x20association\x20values\x20specified!','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_keys','Incorrect\x20binding\x20parameters\x20passed!','firstName','No\x20firstName\x20column\x20specified','root','file','chmodSync','0777','child_process','fork','../../components/import/cm/csv','binding_values','CompanyId','socket_timestamp','pid','send','createReadStream','parse','meta','agent','binding','No\x20phone\x20column\x20specified','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','eml-format','rimraf','zip-dir','request-promise','moment','sox','ejs','lodash','crypto','jsforce','desk.js','to-csv','ioredis','../../components/parsers/qs','../../config/license/hardware','api','../../config/utils','../../mysqldb','redis','localhost','socket.io-emitter','./cmContact.socket','register','sendStatus','status','end','json','count','offset','set','Content-Range','apply','reject','save','then','error','stack','name','keys','length','cf_','push','CmCustomField','findOne','trimStart','query','filters','intersection','model','attributes','fields','hasOwnProperty'];(function(_0x4b043b,_0x598b17){var _0x398f5a=function(_0x59bea2){while(--_0x59bea2){_0x4b043b['push'](_0x4b043b['shift']());}};_0x398f5a(++_0x598b17);}(_0x6856,0xaf));var _0x6685=function(_0x1768ee,_0xe4e350){_0x1768ee=_0x1768ee-0x0;var _0x440826=_0x6856[_0x1768ee];return _0x440826;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x6685('0x0'));var rimraf=require(_0x6685('0x1'));var zipdir=require(_0x6685('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x6685('0x3'));var moment=require(_0x6685('0x4'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require('util');var path=require('path');var sox=require(_0x6685('0x5'));var csv=require('to-csv');var ejs=require(_0x6685('0x6'));var fs=require('fs');var _=require(_0x6685('0x7'));var squel=require('squel');var crypto=require(_0x6685('0x8'));var jsforce=require(_0x6685('0x9'));var deskjs=require(_0x6685('0xa'));var toCsv=require(_0x6685('0xb'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x6685('0xc'));var authService=require('../../components/auth/service');var qs=require(_0x6685('0xd'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x6685('0xe'));var logger=require('../../config/logger')(_0x6685('0xf'));var utils=require(_0x6685('0x10'));var config=require('../../config/environment');var db=require(_0x6685('0x11'))['db'];config[_0x6685('0x12')]=_['defaults'](config['redis'],{'host':_0x6685('0x13'),'port':0x18eb});var socket=require(_0x6685('0x14'))(new Redis(config[_0x6685('0x12')]));require(_0x6685('0x15'))[_0x6685('0x16')](socket);function respondWithStatusCode(_0x3a80cc,_0x7278d){_0x7278d=_0x7278d||0xcc;return function(_0x17d68f){if(_0x17d68f){return _0x3a80cc[_0x6685('0x17')](_0x7278d);}return _0x3a80cc[_0x6685('0x18')](_0x7278d)[_0x6685('0x19')]();};}function respondWithResult(_0x340535,_0x4d52dd){_0x4d52dd=_0x4d52dd||0xc8;return function(_0x3f8e2b){if(_0x3f8e2b){return _0x340535[_0x6685('0x18')](_0x4d52dd)[_0x6685('0x1a')](_0x3f8e2b);}};}function respondWithFilteredResult(_0x2da3bd,_0x231580){return function(_0x222393){if(_0x222393){var _0x153614=_0x222393[_0x6685('0x1b')],_0x3a88a4=_0x231580['offset'],_0x569860=_0x231580[_0x6685('0x1c')]+_0x231580['limit'],_0x309c69;if(_0x569860>=_0x153614){_0x569860=_0x153614;_0x309c69=0xc8;}else{_0x309c69=0xce;}_0x2da3bd['status'](_0x309c69);return _0x2da3bd[_0x6685('0x1d')](_0x6685('0x1e'),_0x3a88a4+'-'+_0x569860+'/'+_0x153614)[_0x6685('0x1a')](_0x222393);}return null;};}function patchUpdates(_0x3d3928){return function(_0x33d817){try{jsonpatch[_0x6685('0x1f')](_0x33d817,_0x3d3928,!![]);}catch(_0x45e2b9){return BPromise[_0x6685('0x20')](_0x45e2b9);}return _0x33d817[_0x6685('0x21')]();};}function saveUpdates(_0x457282,_0x20db55){return function(_0x32f47b){if(_0x32f47b){return _0x32f47b['update'](_0x457282)[_0x6685('0x22')](function(_0x1ac5e9){return _0x1ac5e9;});}return null;};}function removeEntity(_0x5bcf13,_0x302dc5){return function(_0x28559c){if(_0x28559c){return _0x28559c['destroy']()['then'](function(){_0x5bcf13[_0x6685('0x18')](0xcc)[_0x6685('0x19')]();});}};}function handleEntityNotFound(_0x15d0de,_0x3124a0){return function(_0x34623e){if(!_0x34623e){_0x15d0de[_0x6685('0x17')](0x194);}return _0x34623e;};}function handleError(_0x4919ba,_0x4e9347){_0x4e9347=_0x4e9347||0x1f4;return function(_0x4886f0){logger[_0x6685('0x23')](_0x4886f0[_0x6685('0x24')]);if(_0x4886f0[_0x6685('0x25')]){delete _0x4886f0[_0x6685('0x25')];}_0x4919ba[_0x6685('0x18')](_0x4e9347)['send'](_0x4886f0);};}exports['index']=function(_0x4b562e,_0x56f455){var _0x59d609={},_0xeb0b64={},_0x1c3062={'count':0x0,'rows':[]};return db['CmContact']['describe']()[_0x6685('0x22')](function(_0x4fa680){var _0x11b47d=[];for(var _0x1ba75e=0x0;_0x1ba75e<Object[_0x6685('0x26')](_0x4fa680)[_0x6685('0x27')];_0x1ba75e++){var _0x2bdfd2=Object['keys'](_0x4fa680)[_0x1ba75e];if(_['startsWith'](_0x2bdfd2,_0x6685('0x28'))){_0x11b47d[_0x6685('0x29')](db[_0x6685('0x2a')][_0x6685('0x2b')]({'where':{'id':_[_0x6685('0x2c')](_0x2bdfd2,_0x6685('0x28'))},'raw':!![]}));}}return BPromise['all'](_0x11b47d)[_0x6685('0x22')](function(_0x3731b9){for(var _0x1b7cbd=0x0;_0x1b7cbd<_0x3731b9[_0x6685('0x27')];_0x1b7cbd++){if(_0x3731b9[_0x1b7cbd]){var _0x2c7793=_0x6685('0x28')+_0x3731b9[_0x1b7cbd]['id'];var _0x371f8e=_0x4fa680[_0x2c7793];_0x371f8e['fieldType']=_0x3731b9[_0x1b7cbd]['type'];}}return _0x4fa680;});})[_0x6685('0x22')](function(_0xc9a62f){_0xeb0b64['model']=_[_0x6685('0x26')](_0xc9a62f);_0xeb0b64[_0x6685('0x2d')]=_[_0x6685('0x26')](_0x4b562e['query']);_0xeb0b64[_0x6685('0x2e')]=_[_0x6685('0x2f')](_0xeb0b64[_0x6685('0x30')],_0xeb0b64[_0x6685('0x2d')]);_0x59d609[_0x6685('0x31')]=_[_0x6685('0x2f')](_0xeb0b64['model'],qs[_0x6685('0x32')](_0x4b562e['query'][_0x6685('0x32')]));_0x59d609['attributes']=_0x59d609[_0x6685('0x31')][_0x6685('0x27')]?_0x59d609[_0x6685('0x31')]:_0xeb0b64['model'];if(!_0x4b562e[_0x6685('0x2d')][_0x6685('0x33')](_0x6685('0x34'))){_0x59d609[_0x6685('0x35')]=qs[_0x6685('0x35')](_0x4b562e[_0x6685('0x2d')][_0x6685('0x35')]);_0x59d609[_0x6685('0x1c')]=qs[_0x6685('0x1c')](_0x4b562e[_0x6685('0x2d')][_0x6685('0x1c')]);}_0x59d609[_0x6685('0x36')]=qs[_0x6685('0x37')](_0x4b562e[_0x6685('0x2d')][_0x6685('0x37')]);_0x59d609[_0x6685('0x38')]=qs[_0x6685('0x2e')](_['pick'](_0x4b562e[_0x6685('0x2d')],_0xeb0b64[_0x6685('0x2e')]),_0xc9a62f);var _0x1b84f9=[];var _0x577f24=squel[_0x6685('0x39')]()[_0x6685('0x3a')]('id')['field']('name')[_0x6685('0x3a')]('color')[_0x6685('0x3b')](_0x6685('0x3c'));var _0x15115c=squel['select']()[_0x6685('0x3b')](_0x6685('0x3d'),'c')['left_join'](_0x6685('0x3e'),'uc','uc.CmContactId\x20=\x20c.id')[_0x6685('0x3f')](_0x6685('0x40'),'ct',_0x6685('0x41'))[_0x6685('0x3f')](_0x6685('0x3c'),'t',_0x6685('0x42'))[_0x6685('0x38')](_0x6685('0x43'));var _0x538579=squel[_0x6685('0x44')]();var _0x538c87=[];var _0x138614=squel[_0x6685('0x44')]();var _0x59a8fa;if(_0x4b562e[_0x6685('0x2d')][_0x6685('0x45')]){_0x59a8fa=as[_0x6685('0x46')](_0x4b562e['query'][_0x6685('0x45')]);var _0x179543=_0x59a8fa['sqlOperator'];for(var _0x230629=0x0;_0x230629<_0x59a8fa[_0x6685('0x47')][_0x6685('0x27')];_0x230629++){var _0x35ffaa=_0x59a8fa[_0x6685('0x47')][_0x230629];var _0x5e5854='c';var _0x135d36=_(_0xc9a62f)[_0x6685('0x26')]()[_0x6685('0x48')](function(_0x4c2eab){return _0x4c2eab===_0x35ffaa['field'];});if(_0x135d36)_0x135d36=_0xc9a62f[_0x35ffaa['field']];if(!_0x135d36){if(_0x35ffaa[_0x6685('0x3a')]===_0x6685('0x49')){var _0x5110cf=_0x35ffaa[_0x6685('0x4a')][_0x6685('0x4b')](',')[_0x6685('0x4c')](function(_0x159035){return Number(_0x159035);});_0x5110cf[_0x6685('0x4d')](function(_0x41dfee){_0x138614['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x41dfee+',%');});_0x538c87=_[_0x6685('0x4e')](_0x538c87,_0x5110cf);}else if(_0x35ffaa[_0x6685('0x3a')]===_0x6685('0x4f')){_0x538579[_0x6685('0x50')](_0x6685('0x51'),_0x35ffaa[_0x6685('0x4a')]);}}else{if(_0x35ffaa['field']==='dateOfBirth'||_0x135d36[_0x6685('0x52')]==='datetime')_0x35ffaa[_0x6685('0x53')]=_0x6685('0x54');var _0x9ae419=as[_0x6685('0x55')](_0x5e5854,_0x135d36[_0x6685('0x56')],_0x35ffaa);_0x538579[_0x179543](_0x9ae419[_0x6685('0x57')],_0x9ae419['value'][_0x6685('0x58')],_0x9ae419[_0x6685('0x4a')][_0x6685('0x19')]);}}}else{var _0x5d3e6d=_(Object[_0x6685('0x26')](_0x4b562e['query']))[_0x6685('0x4c')](function(_0x16dca3){return _0xc9a62f['hasOwnProperty'](_0x16dca3)?_0x16dca3:undefined;})[_0x6685('0x59')](function(_0x27d918){return!_[_0x6685('0x5a')](_0x27d918);})['value']();if(_0x4b562e[_0x6685('0x2d')]['Contact'])_0x5d3e6d[_0x6685('0x29')](_0x6685('0x5b'));if(!_['isEmpty'](_0x5d3e6d)){_0x5d3e6d['forEach'](function(_0x5abfa3){if(_0x5abfa3===_0x6685('0x5c')){_0x15115c[_0x6685('0x38')](_0x6685('0x5d'),[][_0x6685('0x5e')](_0x4b562e['query'][_0x5abfa3]));}else if(_0x5abfa3===_0x6685('0x5b')){var _0xc5893='%'+_0x4b562e[_0x6685('0x2d')][_0x5abfa3]+'%';_0x15115c[_0x6685('0x38')](_0x6685('0x5f'),_0xc5893);}else{_0x15115c[_0x6685('0x38')]('c.'+_0x5abfa3+_0x6685('0x60'),_0x4b562e[_0x6685('0x2d')][_0x5abfa3]);}});}if(_0x4b562e['query'][_0x6685('0x61')]){_0x538c87=_[_0x6685('0x62')](_0x4b562e[_0x6685('0x2d')][_0x6685('0x61')])?_0x4b562e['query'][_0x6685('0x61')]:new Array(_0x4b562e[_0x6685('0x2d')][_0x6685('0x61')]);_0x538c87[_0x6685('0x4d')](function(_0x5766d6){_0x138614['or'](_0x6685('0x63'),'%,'+_0x5766d6+',%');});}if(_0x4b562e[_0x6685('0x2d')][_0x6685('0x59')]){var _0x55e278=_0x4b562e['query'][_0x6685('0x59')][_0x6685('0x64')]('\x5c','\x5c\x5c')[_0x6685('0x64')]('\x27\x27',_0x6685('0x65'));if(_0x55e278[_0x6685('0x4b')]('\x20')[_0x6685('0x27')]>0x1){_0x538579['or'](_0x6685('0x66'),qs[_0x6685('0x67')](_0x55e278),null);}else{if(qs[_0x6685('0x68')](_0x55e278)){_0x538579['or'](_0x6685('0x69'),_0x55e278+'%');_0x538579['or'](_0x6685('0x6a'),_0x55e278+'%');_0x538579['or']('c.mobile\x20LIKE\x20?',_0x55e278+'%');_0x538579['or']('c.fax\x20LIKE\x20?',_0x55e278+'%');}else if(qs['isEmail'](_0x55e278)){_0x538579['or']('c.email\x20LIKE\x20?',_0x55e278+'%');}else{_0x538579['or'](_0x6685('0x6b'),'%'+_0x55e278+'%');_0x538579['or'](_0x6685('0x6c'),'%'+_0x55e278+'%');_0x538579['or'](_0x6685('0x6d'),'%'+_0x55e278+'%');}}}}_0x15115c[_0x6685('0x38')](_0x538579);_0x15115c[_0x6685('0x6e')](_0x6685('0x6f'));var _0x5a02c4={'type':db['Sequelize'][_0x6685('0x70')][_0x6685('0x71')],'raw':!![]};var _0x46f465=_0x15115c['clone']()[_0x6685('0x3a')](_0x6685('0x6f'));if(_0x59d609[_0x6685('0x36')]){_0x59d609[_0x6685('0x36')][_0x6685('0x4d')](function(_0x4504d4){_0x15115c[_0x6685('0x36')]('c.'+_0x4504d4[0x0],_0x4504d4[0x1]===_0x6685('0x72')?![]:!![]);});}if(!_[_0x6685('0x73')](_0x538c87)){_0x15115c[_0x6685('0x74')](_0x138614);_0x46f465['where'](_0x6685('0x75'),_0x538c87);}BPromise[_0x6685('0x76')]()[_0x6685('0x22')](function(){if(_0x59a8fa&&!_[_0x6685('0x77')](_0x59a8fa[_0x6685('0x47')],[_0x6685('0x3a'),'User'])){return _0x4b562e[_0x6685('0x78')][_0x6685('0x79')]({'attributes':['id'],'raw':!![]})[_0x6685('0x22')](function(_0x27f8d8){if(_[_0x6685('0x73')](_0x27f8d8)){_0x46f465[_0x6685('0x38')](_0x6685('0x7a'));_0x15115c['where']('c.ListId\x20IS\x20NULL');}else{_0x46f465[_0x6685('0x38')](_0x6685('0x5d'),_[_0x6685('0x4c')](_0x27f8d8,'id'));_0x15115c[_0x6685('0x38')](_0x6685('0x5d'),_[_0x6685('0x4c')](_0x27f8d8,'id'));}});}else{return;}})['then'](function(){db[_0x6685('0x7b')][_0x6685('0x2d')](_0x46f465['toString'](),_0x5a02c4)[_0x6685('0x22')](function(_0x1cec02){_0x1c3062['count']=_0x1cec02[_0x6685('0x27')];if(_0x1c3062[_0x6685('0x1b')]===0x0)return[];return db['sequelize'][_0x6685('0x2d')](_0x577f24[_0x6685('0x7c')](),_0x5a02c4);})['then'](function(_0x5e234d){_0x1b84f9=_[_0x6685('0x7d')](_0x5e234d,'id');_0x5a02c4=_[_0x6685('0x7e')](_0x5a02c4,{'model':db['CmContact'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x4b562e[_0x6685('0x2d')][_0x6685('0x32')]){_0x59d609[_0x6685('0x31')][_0x6685('0x4d')](function(_0x3cdd56){_0x15115c['field']('c.'+_0x3cdd56);});}else{_0x15115c[_0x6685('0x3a')](_0x6685('0x6f'));_0x15115c['field'](_0x6685('0x7f'));_0x15115c[_0x6685('0x3a')](_0x6685('0x80'));_0x15115c['field'](_0x6685('0x81'));_0x15115c[_0x6685('0x3a')]('c.mobile');_0x15115c[_0x6685('0x3a')](_0x6685('0x82'));_0x15115c[_0x6685('0x3a')](_0x6685('0x83'));_0x15115c['field'](_0x6685('0x84'));_0x15115c['field']('c.deletedAt');_0x15115c[_0x6685('0x3a')](_0x6685('0x85'),_0x6685('0x86'));}if(_0x59d609[_0x6685('0x35')])_0x15115c[_0x6685('0x35')](_0x59d609[_0x6685('0x35')]);if(_0x59d609[_0x6685('0x1c')])_0x15115c[_0x6685('0x1c')](_0x59d609[_0x6685('0x1c')]);return db['sequelize'][_0x6685('0x2d')](_0x15115c['toString'](),_0x5a02c4);})['then'](function(_0x5bc8b9){_0x5bc8b9[_0x6685('0x4d')](function(_0x3ff576){if(_0x3ff576['TagIds']){_0x3ff576['Tags']=[];_0x3ff576[_0x6685('0x86')][_0x6685('0x4b')](',')[_0x6685('0x4d')](function(_0x457899){_0x3ff576['Tags'][_0x6685('0x29')](_0x1b84f9[_0x457899]);});}delete _0x3ff576[_0x6685('0x86')];});_0x1c3062['rows']=_0x5bc8b9;return _0x1c3062;})[_0x6685('0x22')](respondWithFilteredResult(_0x56f455,_0x59d609));});})[_0x6685('0x87')](handleError(_0x56f455,null));};exports[_0x6685('0x88')]=function(_0x79632b,_0x3cdea4){return db[_0x6685('0x89')][_0x6685('0x48')]({'where':{'id':_0x79632b[_0x6685('0x8a')]['id']}})[_0x6685('0x22')](handleEntityNotFound(_0x3cdea4,null))[_0x6685('0x22')](removeEntity(_0x3cdea4,null))[_0x6685('0x87')](handleError(_0x3cdea4,null));};exports['describe']=function(_0x5b85f3,_0x322436){return db[_0x6685('0x89')][_0x6685('0x8b')]()[_0x6685('0x22')](function(_0x233d92){delete _0x233d92[_0x6685('0x8c')];for(var _0xa16358=0x0;_0xa16358<Object[_0x6685('0x26')](_0x233d92)[_0x6685('0x27')];_0xa16358++){var _0x59c512=Object['keys'](_0x233d92)[_0xa16358];if(!_['startsWith'](_0x59c512,_0x6685('0x28'))){_0x233d92[_0x59c512][_0x6685('0x8d')]=_0x59c512;_0x233d92[_0x59c512][_0x6685('0x8e')]=_0x59c512;}}return _0x233d92;})[_0x6685('0x22')](function(_0x67cedf){var _0x4cdbce={'where':{'$or':[{'ListId':_0x5b85f3[_0x6685('0x2d')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x6685('0x2a')][_0x6685('0x8f')](_0x4cdbce)['then'](function(_0x49d8e7){for(var _0x20217f=0x0;_0x20217f<_0x49d8e7[_0x6685('0x27')];_0x20217f++){var _0x1b5ace='cf_'+_0x49d8e7[_0x20217f]['id'];_0x67cedf[_0x1b5ace][_0x6685('0x8d')]=_0x1b5ace;_0x67cedf[_0x1b5ace][_0x6685('0x8e')]=_0x49d8e7[_0x20217f]['alias'];_0x67cedf[_0x1b5ace][_0x6685('0x90')]={'type':_0x49d8e7[_0x20217f][_0x6685('0x56')],'values':_0x49d8e7[_0x20217f]['values']};}Object[_0x6685('0x26')](_0x67cedf)[_0x6685('0x4d')](function(_0x309827){if(!_0x67cedf[_0x309827][_0x6685('0x33')](_0x6685('0x8d'))){delete _0x67cedf[_0x309827];}});return _0x67cedf;});})[_0x6685('0x22')](respondWithResult(_0x322436,null))[_0x6685('0x87')](handleError(_0x322436,null));};exports[_0x6685('0x7e')]=function(_0x298329,_0xb6e27e){var _0xa90cb7;var _0x4c1708;var _0x1f3f8e;if(_0x298329['body']['id']){delete _0x298329['body']['id'];}return db[_0x6685('0x89')][_0x6685('0x8f')]({'where':{'id':[_0x298329['body']['to'],_0x298329['body'][_0x6685('0x3b')]]}})[_0x6685('0x22')](function(_0x58a8e0){if(_0x58a8e0){if(_0x58a8e0[_0x6685('0x27')]!==0x2){return null;}_0x58a8e0[0x0]=_0x58a8e0[0x0][_0x6685('0x91')]({'plain':!![]});_0x58a8e0[0x1]=_0x58a8e0[0x1]['get']({'plain':!![]});delete _0x58a8e0[0x0]['id'];delete _0x58a8e0[0x1]['id'];return _[_0x6685('0x92')](_0x58a8e0[0x0],_0x58a8e0[0x1],function(_0x53a7b4,_0x568b2b){if(Array[_0x6685('0x62')](_0x568b2b)&&!_0x568b2b[_0x6685('0x27')]){return _0x53a7b4;}else if(!_0x568b2b){return _0x53a7b4;}});}})[_0x6685('0x22')](handleEntityNotFound(_0xb6e27e,null))[_0x6685('0x22')](function(_0x30dc7b){if(_0x30dc7b){if(_0x30dc7b['tags']&&_['isArray'](_0x30dc7b[_0x6685('0x8c')])){_0x30dc7b[_0x6685('0x8c')]=_0x30dc7b[_0x6685('0x8c')][_0x6685('0x93')]();}logger[_0x6685('0x94')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x298329[_0x6685('0x95')]['to'],_0x298329['body']['from']);return db['CmHopper'][_0x6685('0x88')]({'where':{'ContactId':[_0x298329['body']['to'],_0x298329[_0x6685('0x95')][_0x6685('0x3b')]]}})[_0x6685('0x22')](function(_0x4293c2){logger[_0x6685('0x94')]('[CmContact][merge][destroy][CmHopper],\x20%s',_0x4293c2);return db[_0x6685('0x96')][_0x6685('0x88')]({'where':{'ContactId':[_0x298329[_0x6685('0x95')]['to'],_0x298329['body']['from']]}})['then'](function(_0x39f650){logger['info'](_0x6685('0x97'),_0x39f650);return db['CmContact'][_0x6685('0x98')](_0x30dc7b);});});}})[_0x6685('0x22')](function(_0x1566a9){if(_0x1566a9){_0xa90cb7=_0x1566a9;_0x4c1708={'ContactId':_0xa90cb7['id']};_0x1f3f8e={'where':{'ContactId':[_0x298329[_0x6685('0x95')]['to'],_0x298329['body'][_0x6685('0x3b')]]}};return db[_0x6685('0x99')]['update'](_0x4c1708,_0x1f3f8e);}})[_0x6685('0x22')](function(){if(_0xa90cb7){return db['ChatMessage'][_0x6685('0x9a')](_0x4c1708,_0x1f3f8e);}})['then'](function(){if(_0xa90cb7){return db[_0x6685('0x9b')][_0x6685('0x9a')](_0x4c1708,_0x1f3f8e);}})[_0x6685('0x22')](function(){if(_0xa90cb7){return db[_0x6685('0x9c')]['update'](_0x4c1708,_0x1f3f8e);}})[_0x6685('0x22')](function(){if(_0xa90cb7){return db[_0x6685('0x9d')]['update'](_0x4c1708,_0x1f3f8e);}})['then'](function(){if(_0xa90cb7){return db[_0x6685('0x9c')][_0x6685('0x9a')](_0x4c1708,_0x1f3f8e);}})[_0x6685('0x22')](function(){if(_0xa90cb7){return db[_0x6685('0x9d')][_0x6685('0x9a')](_0x4c1708,_0x1f3f8e);}})[_0x6685('0x22')](function(){if(_0xa90cb7){return db['SmsInteraction'][_0x6685('0x9a')](_0x4c1708,_0x1f3f8e);}})[_0x6685('0x22')](function(){if(_0xa90cb7){return db[_0x6685('0x9e')][_0x6685('0x9a')](_0x4c1708,_0x1f3f8e);}})[_0x6685('0x22')](function(){if(_0xa90cb7){return db[_0x6685('0x9f')]['update'](_0x4c1708,_0x1f3f8e);}})[_0x6685('0x22')](function(){if(_0xa90cb7){return db[_0x6685('0xa0')][_0x6685('0x9a')](_0x4c1708,_0x1f3f8e);}})[_0x6685('0x22')](function(){if(_0xa90cb7){return db['OpenchannelInteraction'][_0x6685('0x9a')](_0x4c1708,_0x1f3f8e);}})[_0x6685('0x22')](function(){if(_0xa90cb7){return db[_0x6685('0xa1')][_0x6685('0x9a')](_0x4c1708,_0x1f3f8e);}})[_0x6685('0x22')](function(){if(_0xa90cb7){return db[_0x6685('0xa2')][_0x6685('0x9a')](_0x4c1708,_0x1f3f8e);}})[_0x6685('0x22')](function(){if(_0xa90cb7){return db[_0x6685('0xa3')]['update'](_0x4c1708,_0x1f3f8e);}})['then'](function(){if(_0xa90cb7){return db['ReportAgentPreview'][_0x6685('0x9a')](_0x4c1708,_0x1f3f8e);}})[_0x6685('0x22')](function(){if(_0xa90cb7){return db[_0x6685('0xa4')][_0x6685('0x9a')](_0x4c1708,_0x1f3f8e);}})[_0x6685('0x22')](function(){if(_0xa90cb7){return db[_0x6685('0xa5')][_0x6685('0x9a')](_0x4c1708,_0x1f3f8e);}})['then'](function(){if(_0xa90cb7){return db['FaxQueueReport'][_0x6685('0x9a')](_0x4c1708,_0x1f3f8e);}})['then'](function(){if(_0xa90cb7){return db['MailQueueReport'][_0x6685('0x9a')](_0x4c1708,_0x1f3f8e);}})[_0x6685('0x22')](function(){if(_0xa90cb7){return db[_0x6685('0xa6')]['update'](_0x4c1708,_0x1f3f8e);}})[_0x6685('0x22')](function(){if(_0xa90cb7){return db[_0x6685('0xa7')]['update'](_0x4c1708,_0x1f3f8e);}})['then'](function(){if(_0xa90cb7){return db[_0x6685('0xa8')]['update'](_0x4c1708,_0x1f3f8e);}})['then'](function(){if(_0xa90cb7){return db['CmContact'][_0x6685('0x88')]({'where':{'id':[_0x298329[_0x6685('0x95')]['to'],_0x298329[_0x6685('0x95')]['from']]}});}})[_0x6685('0x22')](function(){if(_0xa90cb7){return _0xa90cb7;}})[_0x6685('0x22')](respondWithResult(_0xb6e27e,null))[_0x6685('0x87')](handleError(_0xb6e27e,null));};exports[_0x6685('0x98')]=function(_0x56dca3,_0x51f659){return db[_0x6685('0x89')]['describe']()[_0x6685('0x22')](function(_0x58b6ff){if(_0x56dca3[_0x6685('0x95')]['tags']&&_['isArray'](_0x56dca3['body'][_0x6685('0x8c')])){if(_0x56dca3[_0x6685('0x95')][_0x6685('0x8c')]['length']){_0x56dca3[_0x6685('0x95')]['tags']=_0x56dca3[_0x6685('0x95')]['tags'][_0x6685('0x93')](';')+';';}else{_0x56dca3[_0x6685('0x95')]['tags']=null;}}else{_0x56dca3['body']['tags']=null;}return db['CmContact']['create'](_0x56dca3['body'],{'fields':_['keys'](_0x58b6ff),'raw':!![]});})[_0x6685('0x22')](respondWithResult(_0x51f659,0xc9))[_0x6685('0x87')](handleError(_0x51f659,null));};exports[_0x6685('0xa9')]=function(_0x39f933,_0x4bc512){var _0x1ec6ed=[];var _0x1d06ca=0x0;var _0x541b05=0x0;var _0x25c6d7=0x0;return db['CmContact']['describe']()[_0x6685('0x22')](function(_0x3749e9){return BPromise['each'](_0x39f933[_0x6685('0x95')],function(_0x2eb02){var _0xc4dc36={'where':{'$or':[]},'defaults':_0x2eb02,'fields':_[_0x6685('0x26')](_0x3749e9),'raw':!![]};if(_0x2eb02[_0x6685('0xaa')]){for(var _0x108723=0x0;_0x108723<_0x2eb02['duplicates'][_0x6685('0x27')];_0x108723++){var _0x6de6b3={};_0x6de6b3[_0x2eb02['duplicates'][_0x108723]]=_0x2eb02[_0x2eb02['duplicates'][_0x108723]];_0xc4dc36[_0x6685('0x38')][_0x6685('0xab')][_0x6685('0x29')](_0x6de6b3);}_0xc4dc36[_0x6685('0x38')]['ListId']=_0x2eb02[_0x6685('0x5c')];}return db['CmContact'][_0x6685('0xac')](_0xc4dc36)['spread'](function(_0xa0a8c,_0x1a0f1b){if(_0x1a0f1b){_0x1d06ca++;}else{_0x25c6d7++;}})[_0x6685('0x87')](function(_0x201070){console[_0x6685('0x23')](_0x201070);_0x541b05++;});});})[_0x6685('0x22')](function(_0x418394){if(_0x418394){return{'success':_0x1d06ca,'failure':_0x541b05,'duplicates':_0x25c6d7};}})[_0x6685('0x22')](respondWithResult(_0x4bc512,0xc9))[_0x6685('0x87')](handleError(_0x4bc512,null));};exports['show']=function(_0x123a87,_0x1285c7,_0x12b86b){var _0x357043;return db[_0x6685('0x89')][_0x6685('0x8b')]()[_0x6685('0x22')](function(_0x16916e){return db[_0x6685('0x89')]['find']({'where':{'id':_0x123a87['params']['id']},'include':[{'model':db['Tag'],'as':_0x6685('0xad'),'attributes':['id','name','color'],'required':_0x123a87[_0x6685('0x2d')][_0x6685('0x61')]?!![]:![]}],'attributes':_[_0x6685('0x26')](_0x16916e)});})[_0x6685('0x22')](function(_0x2d4bd1){_0x357043=_0x2d4bd1[_0x6685('0x91')]({'plain':!![]});var _0x5902e3={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x2d4bd1&&_0x2d4bd1['ListId']){if(_0x2d4bd1[_0x6685('0x5c')]){_0x5902e3[_0x6685('0x38')][_0x6685('0xae')][_0x6685('0x29')]({'ListId':{'$ne':_0x2d4bd1[_0x6685('0x5c')]}});}}return db['CmCustomField'][_0x6685('0x8f')](_0x5902e3);})[_0x6685('0x22')](function(_0x1978fd){return _[_0x6685('0xaf')](_0x357043,_[_0x6685('0x4c')](_0x1978fd,function(_0x3db56b){return util[_0x6685('0xb0')]('cf_%d',_0x3db56b['id']);}));})['then'](handleEntityNotFound(_0x1285c7,null))[_0x6685('0x22')](respondWithResult(_0x1285c7,null))[_0x6685('0x87')](handleError(_0x1285c7,null));};exports[_0x6685('0x9a')]=function(_0x142d7d,_0x17075a){var _0x20fe6c;if(_0x142d7d[_0x6685('0x95')]['id']){delete _0x142d7d[_0x6685('0x95')]['id'];}return db['CmContact'][_0x6685('0x48')]({'where':{'id':_0x142d7d['params']['id']}})[_0x6685('0x22')](handleEntityNotFound(_0x17075a,null))[_0x6685('0x22')](saveUpdates(_0x142d7d[_0x6685('0x95')],null))[_0x6685('0x22')](function(_0x1b3bd4){_0x20fe6c=_0x1b3bd4;var _0x2b8190={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x1b3bd4&&_0x1b3bd4['ListId']){if(_0x1b3bd4[_0x6685('0x5c')]){_0x2b8190[_0x6685('0x38')][_0x6685('0xae')][_0x6685('0x29')]({'ListId':{'$ne':_0x1b3bd4['ListId']}});}}return db[_0x6685('0x2a')][_0x6685('0x8f')](_0x2b8190);})['then'](function(_0x5ee8c8){if(_0x5ee8c8){return _[_0x6685('0xaf')](_['pickBy'](_0x142d7d['body'],function(_0x5dd284,_0x45e697){return _['startsWith'](_0x45e697,_0x6685('0x28'));}),_[_0x6685('0x4c')](_0x5ee8c8,function(_0x2b9d86){return util[_0x6685('0xb0')]('cf_%d',_0x2b9d86['id']);}));}})['then'](function(_0x10c30f){if(_0x10c30f&&!_['isEmpty'](_0x10c30f)){var _0x449551=squel[_0x6685('0x9a')]()[_0x6685('0xb1')](_0x6685('0x3d'))[_0x6685('0xb2')](_0x10c30f)[_0x6685('0x38')](_0x6685('0xb3'),_0x142d7d[_0x6685('0x8a')]['id'])[_0x6685('0xb4')]();return db[_0x6685('0x7b')][_0x6685('0x2d')](_0x449551['text'],{'replacements':_0x449551[_0x6685('0xb5')]});}})[_0x6685('0x22')](function(){if(_0x142d7d['body'][_0x6685('0xb6')]&&_0x20fe6c){return db[_0x6685('0xb7')][_0x6685('0x9a')]({'phone':_0x142d7d[_0x6685('0x95')][_0x6685('0xb6')]},{'where':{'ContactId':_0x20fe6c['id']}});}})[_0x6685('0x22')](function(){return _0x20fe6c;})[_0x6685('0x22')](respondWithResult(_0x17075a,null))[_0x6685('0x87')](handleError(_0x17075a,null));};exports['getTags']=function(_0x512f0c,_0x3a963e,_0x1b7de8){var _0x30d77b={};var _0x289c7b={};var _0x1e639c;var _0xf2fc68;return db[_0x6685('0x89')]['findOne']({'where':{'id':_0x512f0c[_0x6685('0x8a')]['id']}})[_0x6685('0x22')](handleEntityNotFound(_0x3a963e,null))[_0x6685('0x22')](function(_0x56c3a3){if(_0x56c3a3){_0x1e639c=_0x56c3a3;_0x289c7b['model']=_[_0x6685('0x26')](db[_0x6685('0x49')][_0x6685('0xb8')]);_0x289c7b[_0x6685('0x2d')]=_['keys'](_0x512f0c[_0x6685('0x2d')]);_0x289c7b[_0x6685('0x2e')]=_[_0x6685('0x2f')](_0x289c7b[_0x6685('0x30')],_0x289c7b['query']);_0x30d77b[_0x6685('0x31')]=_['intersection'](_0x289c7b[_0x6685('0x30')],qs[_0x6685('0x32')](_0x512f0c['query'][_0x6685('0x32')]));_0x30d77b[_0x6685('0x31')]=_0x30d77b[_0x6685('0x31')][_0x6685('0x27')]?_0x30d77b[_0x6685('0x31')]:_0x289c7b[_0x6685('0x30')];_0x30d77b['order']=qs[_0x6685('0x37')](_0x512f0c[_0x6685('0x2d')][_0x6685('0x37')]);_0x30d77b[_0x6685('0x38')]=qs[_0x6685('0x2e')](_['pick'](_0x512f0c[_0x6685('0x2d')],_0x289c7b[_0x6685('0x2e')]));if(_0x512f0c[_0x6685('0x2d')]['filter']){_0x30d77b[_0x6685('0x38')]=_['merge'](_0x30d77b[_0x6685('0x38')],{'$or':_[_0x6685('0x4c')](_0x30d77b[_0x6685('0x31')],function(_0x4894c2){var _0x4f0714={};_0x4f0714[_0x4894c2]={'$like':'%'+_0x512f0c[_0x6685('0x2d')][_0x6685('0x59')]+'%'};return _0x4f0714;})});}_0x30d77b=_['merge']({},_0x30d77b,_0x512f0c['options']);return _0x1e639c['getTags'](_0x30d77b);}})[_0x6685('0x22')](function(_0x482a27){if(_0x482a27){_0xf2fc68=_0x482a27['length'];if(!_0x512f0c[_0x6685('0x2d')][_0x6685('0x33')]('nolimit')){_0x30d77b['limit']=qs['limit'](_0x512f0c['query'][_0x6685('0x35')]);_0x30d77b[_0x6685('0x1c')]=qs[_0x6685('0x1c')](_0x512f0c['query'][_0x6685('0x1c')]);}return _0x1e639c[_0x6685('0xb9')](_0x30d77b);}})[_0x6685('0x22')](function(_0x4157a3){if(_0x4157a3){return _0x4157a3?{'count':_0xf2fc68,'rows':_0x4157a3}:null;}})[_0x6685('0x22')](respondWithResult(_0x3a963e,null))[_0x6685('0x87')](handleError(_0x3a963e,null));};exports[_0x6685('0xba')]=function(_0x5a2ff1,_0x38aad6,_0x261d08){if(_0x5a2ff1[_0x6685('0x95')]['id']){delete _0x5a2ff1[_0x6685('0x95')]['id'];}return db[_0x6685('0x89')]['findOne']({'where':{'id':_0x5a2ff1[_0x6685('0x8a')]['id']}})['then'](handleEntityNotFound(_0x38aad6,null))['then'](function(_0xb3c844){if(_0xb3c844){return _0xb3c844[_0x6685('0xba')](_0x5a2ff1[_0x6685('0x95')]['ids']||[]);}return null;})[_0x6685('0x22')](respondWithResult(_0x38aad6,null))['catch'](handleError(_0x38aad6,null));};exports[_0x6685('0xbb')]=function(_0x32260a,_0x21e919,_0x513b31){var _0x4a5d1c={'raw':![],'where':{}};var _0x58df3d={};var _0x465bf8={'count':0x0,'rows':[]};return db[_0x6685('0x89')]['findOne']({'where':{'id':_0x32260a[_0x6685('0x8a')]['id']}})[_0x6685('0x22')](handleEntityNotFound(_0x21e919,null))['then'](function(_0x2bd1ea){if(_0x2bd1ea){_0x58df3d['model']=_['keys'](db[_0x6685('0xb7')][_0x6685('0xb8')]);_0x58df3d[_0x6685('0x2d')]=_['keys'](_0x32260a['query']);_0x58df3d['filters']=_['intersection'](_0x58df3d['model'],_0x58df3d[_0x6685('0x2d')]);_0x4a5d1c['attributes']=_['intersection'](_0x58df3d['model'],qs[_0x6685('0x32')](_0x32260a[_0x6685('0x2d')][_0x6685('0x32')]));_0x4a5d1c[_0x6685('0x31')]=_0x4a5d1c[_0x6685('0x31')][_0x6685('0x27')]?_0x4a5d1c['attributes']:_0x58df3d[_0x6685('0x30')];if(!_0x32260a[_0x6685('0x2d')][_0x6685('0x33')](_0x6685('0x34'))){_0x4a5d1c['limit']=qs['limit'](_0x32260a[_0x6685('0x2d')][_0x6685('0x35')]);_0x4a5d1c['offset']=qs[_0x6685('0x1c')](_0x32260a[_0x6685('0x2d')][_0x6685('0x1c')]);}_0x4a5d1c[_0x6685('0x36')]=qs[_0x6685('0x37')](_0x32260a['query'][_0x6685('0x37')]);_0x4a5d1c[_0x6685('0x38')]=qs[_0x6685('0x2e')](_[_0x6685('0xbc')](_0x32260a[_0x6685('0x2d')],_0x58df3d[_0x6685('0x2e')]));_0x4a5d1c[_0x6685('0x38')][_0x6685('0xbd')]=_0x2bd1ea['id'];if(_0x32260a[_0x6685('0x2d')]['filter']){_0x4a5d1c[_0x6685('0x38')]=_[_0x6685('0x7e')](_0x4a5d1c['where'],{'$or':_['map'](_0x4a5d1c['attributes'],function(_0x455b8a){var _0xb6eb11={};_0xb6eb11[_0x455b8a]={'$like':'%'+_0x32260a[_0x6685('0x2d')][_0x6685('0x59')]+'%'};return _0xb6eb11;})});}_0x4a5d1c=_[_0x6685('0x7e')]({},_0x4a5d1c,_0x32260a[_0x6685('0xbe')]);return db[_0x6685('0xb7')][_0x6685('0x1b')]({'where':_0x4a5d1c[_0x6685('0x38')]})[_0x6685('0x22')](function(_0x16d4d8){_0x465bf8[_0x6685('0x1b')]=_0x16d4d8;if(_0x32260a[_0x6685('0x2d')][_0x6685('0xbf')]){_0x4a5d1c[_0x6685('0xc0')]=[{'all':!![]}];}return db[_0x6685('0xb7')][_0x6685('0x8f')](_0x4a5d1c);})[_0x6685('0x22')](function(_0x19b641){_0x465bf8[_0x6685('0xc1')]=_0x19b641;return _0x465bf8;});}})[_0x6685('0x22')](respondWithFilteredResult(_0x21e919,_0x4a5d1c))[_0x6685('0x87')](handleError(_0x21e919,null));};exports[_0x6685('0xc2')]=function(_0x4745a9,_0x11b37b,_0x54456c){var _0xa9137f={'raw':!![],'where':{}};var _0x56cf16={};var _0x35628c={'count':0x0,'rows':[]};return db['CmContact'][_0x6685('0x2b')]({'where':{'id':_0x4745a9[_0x6685('0x8a')]['id']}})['then'](handleEntityNotFound(_0x11b37b,null))[_0x6685('0x22')](function(_0x3b74cc){if(_0x3b74cc){_0x56cf16[_0x6685('0x30')]=_['keys'](db['CmHopperHistory'][_0x6685('0xb8')]);_0x56cf16['query']=_['keys'](_0x4745a9[_0x6685('0x2d')]);_0x56cf16[_0x6685('0x2e')]=_['intersection'](_0x56cf16[_0x6685('0x30')],_0x56cf16[_0x6685('0x2d')]);_0xa9137f[_0x6685('0x31')]=_['intersection'](_0x56cf16['model'],qs[_0x6685('0x32')](_0x4745a9[_0x6685('0x2d')]['fields']));_0xa9137f[_0x6685('0x31')]=_0xa9137f[_0x6685('0x31')][_0x6685('0x27')]?_0xa9137f[_0x6685('0x31')]:_0x56cf16[_0x6685('0x30')];if(!_0x4745a9['query']['hasOwnProperty'](_0x6685('0x34'))){_0xa9137f[_0x6685('0x35')]=qs[_0x6685('0x35')](_0x4745a9['query'][_0x6685('0x35')]);_0xa9137f[_0x6685('0x1c')]=qs[_0x6685('0x1c')](_0x4745a9['query'][_0x6685('0x1c')]);}_0xa9137f[_0x6685('0x36')]=qs[_0x6685('0x37')](_0x4745a9[_0x6685('0x2d')][_0x6685('0x37')]);_0xa9137f['where']=qs[_0x6685('0x2e')](_['pick'](_0x4745a9[_0x6685('0x2d')],_0x56cf16['filters']));_0xa9137f['where'][_0x6685('0xbd')]=_0x3b74cc['id'];if(_0x4745a9['query'][_0x6685('0x59')]){_0xa9137f[_0x6685('0x38')]=_[_0x6685('0x7e')](_0xa9137f[_0x6685('0x38')],{'$or':_[_0x6685('0x4c')](_0xa9137f['attributes'],function(_0x22f0fe){var _0x53cfa3={};_0x53cfa3[_0x22f0fe]={'$like':'%'+_0x4745a9['query'][_0x6685('0x59')]+'%'};return _0x53cfa3;})});}_0xa9137f=_[_0x6685('0x7e')]({},_0xa9137f,_0x4745a9[_0x6685('0xbe')]);return db[_0x6685('0xa3')][_0x6685('0x1b')]({'where':_0xa9137f[_0x6685('0x38')]})[_0x6685('0x22')](function(_0x12f686){_0x35628c[_0x6685('0x1b')]=_0x12f686;if(_0x4745a9['query']['includeAll']){_0xa9137f['include']=[{'all':!![]}];}return db['CmHopperHistory'][_0x6685('0x8f')](_0xa9137f);})[_0x6685('0x22')](function(_0x3be91d){_0x35628c[_0x6685('0xc1')]=_0x3be91d;return _0x35628c;});}})['then'](respondWithFilteredResult(_0x11b37b,_0xa9137f))['catch'](handleError(_0x11b37b,null));};exports[_0x6685('0xc3')]=function(_0x46a141,_0x1aac89,_0x4e8aa0){var _0x293f36={'raw':!![],'where':{}};var _0x138db6={};var _0xd2f53={'count':0x0,'rows':[]};return db[_0x6685('0x89')][_0x6685('0x2b')]({'where':{'id':_0x46a141[_0x6685('0x8a')]['id']}})[_0x6685('0x22')](handleEntityNotFound(_0x1aac89,null))[_0x6685('0x22')](function(_0x4153ff){if(_0x4153ff){_0x138db6['model']=_[_0x6685('0x26')](db[_0x6685('0xa2')][_0x6685('0xb8')]);_0x138db6[_0x6685('0x2d')]=_[_0x6685('0x26')](_0x46a141[_0x6685('0x2d')]);_0x138db6['filters']=_['intersection'](_0x138db6[_0x6685('0x30')],_0x138db6[_0x6685('0x2d')]);_0x293f36[_0x6685('0x31')]=_[_0x6685('0x2f')](_0x138db6[_0x6685('0x30')],qs[_0x6685('0x32')](_0x46a141[_0x6685('0x2d')][_0x6685('0x32')]));_0x293f36[_0x6685('0x31')]=_0x293f36[_0x6685('0x31')][_0x6685('0x27')]?_0x293f36[_0x6685('0x31')]:_0x138db6[_0x6685('0x30')];if(!_0x46a141[_0x6685('0x2d')][_0x6685('0x33')](_0x6685('0x34'))){_0x293f36[_0x6685('0x35')]=qs[_0x6685('0x35')](_0x46a141[_0x6685('0x2d')][_0x6685('0x35')]);_0x293f36[_0x6685('0x1c')]=qs[_0x6685('0x1c')](_0x46a141[_0x6685('0x2d')][_0x6685('0x1c')]);}_0x293f36['order']=qs[_0x6685('0x37')](_0x46a141['query'][_0x6685('0x37')]);_0x293f36[_0x6685('0x38')]=qs['filters'](_['pick'](_0x46a141[_0x6685('0x2d')],_0x138db6[_0x6685('0x2e')]));_0x293f36[_0x6685('0x38')][_0x6685('0xbd')]=_0x4153ff['id'];if(_0x46a141['query'][_0x6685('0x59')]){_0x293f36[_0x6685('0x38')]=_['merge'](_0x293f36['where'],{'$or':_[_0x6685('0x4c')](_0x293f36['attributes'],function(_0x1e874a){var _0x5494ac={};_0x5494ac[_0x1e874a]={'$like':'%'+_0x46a141['query'][_0x6685('0x59')]+'%'};return _0x5494ac;})});}_0x293f36=_['merge']({},_0x293f36,_0x46a141[_0x6685('0xbe')]);return db['CmHopperFinal']['count']({'where':_0x293f36['where']})[_0x6685('0x22')](function(_0x2e6785){_0xd2f53[_0x6685('0x1b')]=_0x2e6785;if(_0x46a141['query'][_0x6685('0xbf')]){_0x293f36[_0x6685('0xc0')]=[{'all':!![]}];}return db[_0x6685('0xa2')][_0x6685('0x8f')](_0x293f36);})[_0x6685('0x22')](function(_0x5114a0){_0xd2f53[_0x6685('0xc1')]=_0x5114a0;return _0xd2f53;});}})[_0x6685('0x22')](respondWithFilteredResult(_0x1aac89,_0x293f36))[_0x6685('0x87')](handleError(_0x1aac89,null));};exports[_0x6685('0xc4')]=function(_0x3924dc,_0x2796e5,_0x16d84e){var _0x558ada={'raw':!![],'where':{}};var _0x295df6={};var _0x24322f={'count':0x0,'rows':[]};return db[_0x6685('0x89')]['findOne']({'where':{'id':_0x3924dc['params']['id']}})[_0x6685('0x22')](handleEntityNotFound(_0x2796e5,null))[_0x6685('0x22')](function(_0x54ee70){if(_0x54ee70){_0x295df6[_0x6685('0x30')]=_[_0x6685('0x26')](db[_0x6685('0xa8')]['rawAttributes']);_0x295df6[_0x6685('0x2d')]=_[_0x6685('0x26')](_0x3924dc['query']);_0x295df6[_0x6685('0x2e')]=_['intersection'](_0x295df6[_0x6685('0x30')],_0x295df6['query']);_0x558ada[_0x6685('0x31')]=_['intersection'](_0x295df6[_0x6685('0x30')],qs[_0x6685('0x32')](_0x3924dc[_0x6685('0x2d')][_0x6685('0x32')]));_0x558ada[_0x6685('0x31')]=_0x558ada[_0x6685('0x31')][_0x6685('0x27')]?_0x558ada[_0x6685('0x31')]:_0x295df6['model'];if(!_0x3924dc[_0x6685('0x2d')][_0x6685('0x33')](_0x6685('0x34'))){_0x558ada['limit']=qs[_0x6685('0x35')](_0x3924dc[_0x6685('0x2d')][_0x6685('0x35')]);_0x558ada[_0x6685('0x1c')]=qs[_0x6685('0x1c')](_0x3924dc[_0x6685('0x2d')][_0x6685('0x1c')]);}_0x558ada[_0x6685('0x36')]=qs[_0x6685('0x37')](_0x3924dc['query'][_0x6685('0x37')]);_0x558ada[_0x6685('0x38')]=qs[_0x6685('0x2e')](_['pick'](_0x3924dc[_0x6685('0x2d')],_0x295df6[_0x6685('0x2e')]));_0x558ada[_0x6685('0x38')][_0x6685('0xbd')]=_0x54ee70['id'];if(_0x3924dc[_0x6685('0x2d')][_0x6685('0x59')]){_0x558ada[_0x6685('0x38')]=_['merge'](_0x558ada[_0x6685('0x38')],{'$or':_[_0x6685('0x4c')](_0x558ada[_0x6685('0x31')],function(_0x1d0d72){var _0x1f5d32={};_0x1f5d32[_0x1d0d72]={'$like':'%'+_0x3924dc[_0x6685('0x2d')][_0x6685('0x59')]+'%'};return _0x1f5d32;})});}_0x558ada=_['merge']({},_0x558ada,_0x3924dc['options']);return db[_0x6685('0xa8')]['count']({'where':_0x558ada['where']})['then'](function(_0x361573){_0x24322f[_0x6685('0x1b')]=_0x361573;if(_0x3924dc['query']['includeAll']){_0x558ada[_0x6685('0xc0')]=[{'all':!![]}];}return db[_0x6685('0xa8')][_0x6685('0x8f')](_0x558ada);})[_0x6685('0x22')](function(_0x377197){_0x24322f['rows']=_0x377197;return _0x24322f;});}})[_0x6685('0x22')](respondWithFilteredResult(_0x2796e5,_0x558ada))[_0x6685('0x87')](handleError(_0x2796e5,null));};exports[_0x6685('0xc5')]=function(_0x28d845,_0x46c3cd,_0x19ed14){try{if(!_0x28d845['body'][_0x6685('0x5c')]){throw new Error(_0x6685('0xc6'));}if(!_0x28d845['body']['binding_keys']){throw new Error('No\x20association\x20keys\x20specified!');}if(!_0x28d845[_0x6685('0x95')]['binding_values']){throw new Error(_0x6685('0xc7'));}if(!_0x28d845[_0x6685('0x95')]['socket_timestamp']){throw new Error(_0x6685('0xc8'));}var _0x92ad26=_0x28d845['body'][_0x6685('0xc9')][_0x6685('0x4b')](',');var _0x5c54ef=_0x28d845[_0x6685('0x95')]['binding_values']['split'](',');if(!_0x92ad26[_0x6685('0x27')]||!_0x5c54ef[_0x6685('0x27')]||_0x92ad26[_0x6685('0x27')]!==_0x5c54ef['length']){throw new Error(_0x6685('0xca'));}_0x28d845[_0x6685('0x95')][_0x6685('0x32')]=_['zipObject'](_0x92ad26,_0x5c54ef);if(!_0x28d845[_0x6685('0x95')][_0x6685('0x32')][_0x6685('0xb6')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x28d845['body'][_0x6685('0x32')][_0x6685('0xcb')]){throw new Error(_0x6685('0xcc'));}var _0x195eba=path['join'](config[_0x6685('0xcd')],'server/files/tmp',_0x28d845[_0x6685('0xce')]['filename']);fs[_0x6685('0xcf')](_0x195eba,parseInt(_0x6685('0xd0'),0x8));var _0xb3f79f=require(_0x6685('0xd1'))[_0x6685('0xd2')](path[_0x6685('0x93')](__dirname,_0x6685('0xd3')),[_0x195eba,_0x28d845[_0x6685('0x95')][_0x6685('0xc9')],_0x28d845['body'][_0x6685('0xd4')],_0x28d845['body']['ListId'],_0x28d845[_0x6685('0x95')][_0x6685('0xd5')],_0x28d845[_0x6685('0x95')][_0x6685('0xaa')],_0x28d845[_0x6685('0x95')][_0x6685('0xd6')]]);return _0x46c3cd[_0x6685('0x18')](0xc8)[_0x6685('0x1a')]({'message':'File\x20uploaded\x20correctly!','pid':_0xb3f79f[_0x6685('0xd7')]});}catch(_0x3e5e49){return _0x46c3cd[_0x6685('0x18')](0x1f4)[_0x6685('0xd8')](_0x3e5e49);}};exports['upload']=function(_0x2f86b2,_0x29c0dd,_0x422c77){var _0x2ce82b=fs[_0x6685('0xd9')](_0x2f86b2[_0x6685('0xce')]['path']);Papa[_0x6685('0xda')](_0x2ce82b,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x4286c7){return _0x29c0dd[_0x6685('0x18')](0xc8)['json']({'file':_0x2f86b2['file'],'fields':_0x4286c7[_0x6685('0xdb')][_0x6685('0x32')]});}});};exports['import']=function(_0x48116e,_0x3bbcde,_0x54a569){return db[_0x6685('0x4f')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0x6685('0xdc')}})['then'](function(_0x8be844){var _0x44ecf5=![];if(!_0x48116e[_0x6685('0x95')][_0x6685('0x5c')]){throw new Error(_0x6685('0xc6'));}if(!_0x48116e[_0x6685('0x95')][_0x6685('0xdd')][_0x6685('0xb6')]){throw new Error(_0x6685('0xde'));}if(!_0x48116e[_0x6685('0x95')]['binding']['firstName']){throw new Error(_0x6685('0xcc'));}if(!_0x48116e['body'][_0x6685('0xd6')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x58929a=require(_0x6685('0xd1'))[_0x6685('0xd2')](path[_0x6685('0x93')](__dirname,_0x6685('0xdf')),[_0x48116e[_0x6685('0x8a')]['id'],JSON[_0x6685('0xe0')](_0x48116e[_0x6685('0x95')]),JSON[_0x6685('0xe0')](_0x8be844)]);_0x58929a['on'](_0x6685('0xe1'),function(_0x4e99b2){_0x44ecf5=!![];return _0x3bbcde['status'](0xc8)[_0x6685('0x1a')]({'message':_0x6685('0xe2'),'pid':_0x58929a[_0x6685('0xd7')]});});_0x58929a['on']('exit',function(_0x4216e2){if(_0x4216e2&&!_0x44ecf5){return _0x3bbcde[_0x6685('0x18')](0x1f4)['json']({'message':'error\x20child\x20process','pid':_0x58929a[_0x6685('0xd7')]});}});})['catch'](handleError(_0x3bbcde,null));};
\ No newline at end of file
+var _0x55be=['QueryTypes','clone','c.id','DESC','having','resolve','user','agent','some','getLists','c.ListId\x20IS\x20NULL','role','sequelize','toString','keyBy','merge','fields','c.lastName','c.phone','c.mobile','c.fax','c.ListId','c.createdAt','c.CompanyId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','rows','params','catch','tags','analytics','CmCustomField','columnName','displayName','custom','values','findAll','body','get','mergeWith','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','FaxInteraction','FaxMessage','OpenchannelMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','WhatsappQueueReport','describe','dialTimezone','timezones','utcOffset','create','bulkCreate','each','duplicates','findOrCreate','show','omit','format','$and','pickBy','setFields','id\x20=\x20?','toParam','phone','getTags','rawAttributes','pick','options','setTags','getHoppers','ContactId','includeAll','getHopperHistories','include','getHopperFinals','getJscriptySessions','No\x20ListId\x20specified','binding_values','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','root','file','filename','chmodSync','child_process','fork','File\x20uploaded\x20correctly!','upload','createReadStream','path','parse','meta','import','binding','No\x20firstName\x20column\x20specified','../../components/import/cm/csv2','stringify','message','pid','error\x20child\x20process','mail','sms','fax','whatsapp','channel','includes','toLowerCase','range','isValid','Invalid\x20date\x20for\x20range\x20to\x20filter','voice','uniqueid','source','destination','starttime','duration','note','createdAt','userSecondDisposition','userThirdDisposition','UserId','fullname','alias','findAndCountAll','startCase','closed','disposition','thirdDisposition','Account','key','Owner','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingValue','referer','subject','substatus','openchannel','externalUrl','threadId','Interaction','all','flatten','sortBy','reverse','moment','bluebird','util','lodash','squel','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./cmContact.socket','register','status','json','offset','undefined','count','set','Content-Range','update','then','destroy','end','error','name','send','index','CmContact','keys','length','startsWith','findOne','trimStart','cf_','type','model','query','filters','attributes','intersection','hasOwnProperty','nolimit','limit','order','sort','field','color','from','tools_tags','select','cm_contacts','left_join','cm_user_has_contacts','cm_contact_has_tags','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','where','c.deletedAt\x20IS\x20NULL','expr','search','sqlOperator','conditions','find','Tag','split','map','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','uc.UserId\x20=\x20?','value','dateOfBirth','fieldType','datetime','castTo','DATE','text','start','isNil','Contact','push','isEmpty','forEach','ListId','c.ListId\x20IN\x20?','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','isArray','filter','replace','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.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','c.email\x20LIKE\x20?','c.lastName\x20LIKE\x20?','group'];(function(_0x1eaa83,_0x2c2913){var _0x4dcda5=function(_0x3badb7){while(--_0x3badb7){_0x1eaa83['push'](_0x1eaa83['shift']());}};_0x4dcda5(++_0x2c2913);}(_0x55be,0x1ce));var _0xe55b=function(_0x3ab51d,_0x2fa01d){_0x3ab51d=_0x3ab51d-0x0;var _0x29a04e=_0x55be[_0x3ab51d];return _0x29a04e;};'use strict';var moment=require(_0xe55b('0x0'));var BPromise=require(_0xe55b('0x1'));var util=require(_0xe55b('0x2'));var path=require('path');var fs=require('fs');var _=require(_0xe55b('0x3'));var squel=require(_0xe55b('0x4'));var Papa=require('papaparse');var Redis=require(_0xe55b('0x5'));var qs=require(_0xe55b('0x6'));var as=require(_0xe55b('0x7'));var logger=require(_0xe55b('0x8'))(_0xe55b('0x9'));var config=require(_0xe55b('0xa'));var shared=require('../../config/environment/shared');var db=require(_0xe55b('0xb'))['db'];config[_0xe55b('0xc')]=_[_0xe55b('0xd')](config[_0xe55b('0xc')],{'host':_0xe55b('0xe'),'port':0x18eb});var socket=require(_0xe55b('0xf'))(new Redis(config[_0xe55b('0xc')]));require(_0xe55b('0x10'))[_0xe55b('0x11')](socket);function respondWithResult(_0x457a99,_0x40e866){_0x40e866=_0x40e866||0xc8;return function(_0x4cebc7){if(_0x4cebc7){return _0x457a99[_0xe55b('0x12')](_0x40e866)[_0xe55b('0x13')](_0x4cebc7);}};}function respondWithFilteredResult(_0x23c220,_0x5aa12e){return function(_0x20b967){if(_0x20b967){var _0x59c9c2=typeof _0x5aa12e[_0xe55b('0x14')]===_0xe55b('0x15')&&typeof _0x5aa12e['limit']==='undefined';var _0x3d667d=_0x20b967[_0xe55b('0x16')];var _0x65df4b=_0x59c9c2?0x0:_0x5aa12e[_0xe55b('0x14')];var _0xd2ba87=_0x59c9c2?_0x20b967[_0xe55b('0x16')]:_0x5aa12e['offset']+_0x5aa12e['limit'];var _0x99e91a;if(_0xd2ba87>=_0x3d667d){_0xd2ba87=_0x3d667d;_0x99e91a=0xc8;}else{_0x99e91a=0xce;}_0x23c220[_0xe55b('0x12')](_0x99e91a);return _0x23c220[_0xe55b('0x17')](_0xe55b('0x18'),_0x65df4b+'-'+_0xd2ba87+'/'+_0x3d667d)[_0xe55b('0x13')](_0x20b967);}return null;};}function saveUpdates(_0x43b565){return function(_0x3294d2){if(_0x3294d2){return _0x3294d2[_0xe55b('0x19')](_0x43b565)[_0xe55b('0x1a')](function(_0x28bb41){return _0x28bb41;});}return null;};}function removeEntity(_0x1e1c9f){return function(_0x410f54){if(_0x410f54){return _0x410f54[_0xe55b('0x1b')]()[_0xe55b('0x1a')](function(){_0x1e1c9f[_0xe55b('0x12')](0xcc)[_0xe55b('0x1c')]();});}};}function handleEntityNotFound(_0x551895){return function(_0x28465c){if(!_0x28465c){_0x551895['sendStatus'](0x194);}return _0x28465c;};}function handleError(_0x5660eb,_0x4c639e){_0x4c639e=_0x4c639e||0x1f4;return function(_0x239edd){logger[_0xe55b('0x1d')](_0x239edd['stack']);if(_0x239edd[_0xe55b('0x1e')]){delete _0x239edd[_0xe55b('0x1e')];}_0x5660eb[_0xe55b('0x12')](_0x4c639e)[_0xe55b('0x1f')](_0x239edd);};}exports[_0xe55b('0x20')]=function(_0x5e5fee,_0x3552d1){var _0x134980={},_0x175447={},_0x4c7f84={'count':0x0,'rows':[]};return db[_0xe55b('0x21')]['describe']()[_0xe55b('0x1a')](function(_0x33e635){var _0x51b7cb=[];for(var _0x42e430=0x0;_0x42e430<Object[_0xe55b('0x22')](_0x33e635)[_0xe55b('0x23')];_0x42e430++){var _0x3befd2=Object['keys'](_0x33e635)[_0x42e430];if(_[_0xe55b('0x24')](_0x3befd2,'cf_')){_0x51b7cb['push'](db['CmCustomField'][_0xe55b('0x25')]({'where':{'id':_[_0xe55b('0x26')](_0x3befd2,_0xe55b('0x27'))},'raw':!![]}));}}return BPromise['all'](_0x51b7cb)['then'](function(_0x4dfeaf){for(var _0x125db8=0x0;_0x125db8<_0x4dfeaf[_0xe55b('0x23')];_0x125db8++){if(_0x4dfeaf[_0x125db8]){var _0x22e8c0='cf_'+_0x4dfeaf[_0x125db8]['id'];var _0x349676=_0x33e635[_0x22e8c0];_0x349676['fieldType']=_0x4dfeaf[_0x125db8][_0xe55b('0x28')];}}return _0x33e635;});})[_0xe55b('0x1a')](function(_0x3289c7){_0x175447[_0xe55b('0x29')]=_[_0xe55b('0x22')](_0x3289c7);_0x175447[_0xe55b('0x2a')]=_[_0xe55b('0x22')](_0x5e5fee[_0xe55b('0x2a')]);_0x175447[_0xe55b('0x2b')]=_['intersection'](_0x175447['model'],_0x175447[_0xe55b('0x2a')]);_0x134980[_0xe55b('0x2c')]=_[_0xe55b('0x2d')](_0x175447[_0xe55b('0x29')],qs['fields'](_0x5e5fee[_0xe55b('0x2a')]['fields']));_0x134980['attributes']=_0x134980[_0xe55b('0x2c')][_0xe55b('0x23')]?_0x134980[_0xe55b('0x2c')]:_0x175447[_0xe55b('0x29')];if(!_0x5e5fee[_0xe55b('0x2a')][_0xe55b('0x2e')](_0xe55b('0x2f'))){_0x134980[_0xe55b('0x30')]=qs[_0xe55b('0x30')](_0x5e5fee[_0xe55b('0x2a')][_0xe55b('0x30')]);_0x134980[_0xe55b('0x14')]=qs[_0xe55b('0x14')](_0x5e5fee['query']['offset']);}_0x134980[_0xe55b('0x31')]=qs[_0xe55b('0x32')](_0x5e5fee[_0xe55b('0x2a')][_0xe55b('0x32')]);_0x134980['where']=qs['filters'](_['pick'](_0x5e5fee[_0xe55b('0x2a')],_0x175447[_0xe55b('0x2b')]),_0x3289c7);var _0x5e2893=[];var _0x3d510d=squel['select']()['field']('id')['field'](_0xe55b('0x1e'))[_0xe55b('0x33')](_0xe55b('0x34'))[_0xe55b('0x35')](_0xe55b('0x36'));var _0x5467bd=squel[_0xe55b('0x37')]()[_0xe55b('0x35')](_0xe55b('0x38'),'c')[_0xe55b('0x39')](_0xe55b('0x3a'),'uc','uc.CmContactId\x20=\x20c.id')[_0xe55b('0x39')](_0xe55b('0x3b'),'ct',_0xe55b('0x3c'))[_0xe55b('0x39')](_0xe55b('0x36'),'t',_0xe55b('0x3d'))[_0xe55b('0x3e')](_0xe55b('0x3f'));var _0x51a501=squel[_0xe55b('0x40')]();var _0x29a65b=[];var _0x3321c3=squel[_0xe55b('0x40')]();var _0x3608ec;if(_0x5e5fee[_0xe55b('0x2a')][_0xe55b('0x41')]){_0x3608ec=as['parseSearch'](_0x5e5fee[_0xe55b('0x2a')][_0xe55b('0x41')]);var _0x5ed409=_0x3608ec[_0xe55b('0x42')];for(var _0x4c99db=0x0;_0x4c99db<_0x3608ec[_0xe55b('0x43')][_0xe55b('0x23')];_0x4c99db++){var _0x8878c3=_0x3608ec[_0xe55b('0x43')][_0x4c99db];var _0x4d4b3f='c';var _0x2e4631=_(_0x3289c7)[_0xe55b('0x22')]()[_0xe55b('0x44')](function(_0x2b7195){return _0x2b7195===_0x8878c3['field'];});if(_0x2e4631)_0x2e4631=_0x3289c7[_0x8878c3[_0xe55b('0x33')]];if(!_0x2e4631){if(_0x8878c3['field']===_0xe55b('0x45')){var _0x26e150=_0x8878c3['value'][_0xe55b('0x46')](',')[_0xe55b('0x47')](function(_0x2318c7){return Number(_0x2318c7);});_0x26e150['forEach'](function(_0x21e6b3){_0x3321c3['or'](_0xe55b('0x48'),'%,'+_0x21e6b3+',%');});_0x29a65b=_[_0xe55b('0x49')](_0x29a65b,_0x26e150);}else if(_0x8878c3['field']===_0xe55b('0x4a')){_0x51a501['and'](_0xe55b('0x4b'),_0x8878c3[_0xe55b('0x4c')]);}}else{if(_0x8878c3[_0xe55b('0x33')]===_0xe55b('0x4d')||_0x2e4631[_0xe55b('0x4e')]===_0xe55b('0x4f'))_0x8878c3[_0xe55b('0x50')]=_0xe55b('0x51');var _0x1a0962=as['buildExpression'](_0x4d4b3f,_0x2e4631[_0xe55b('0x28')],_0x8878c3);_0x51a501[_0x5ed409](_0x1a0962[_0xe55b('0x52')],_0x1a0962['value'][_0xe55b('0x53')],_0x1a0962[_0xe55b('0x4c')]['end']);}}}else{var _0x22b190=_(Object[_0xe55b('0x22')](_0x5e5fee[_0xe55b('0x2a')]))['map'](function(_0x56e1c4){return _0x3289c7[_0xe55b('0x2e')](_0x56e1c4)?_0x56e1c4:undefined;})['filter'](function(_0x3ee9e6){return!_[_0xe55b('0x54')](_0x3ee9e6);})[_0xe55b('0x4c')]();if(_0x5e5fee[_0xe55b('0x2a')][_0xe55b('0x55')])_0x22b190[_0xe55b('0x56')](_0xe55b('0x55'));if(!_[_0xe55b('0x57')](_0x22b190)){_0x22b190[_0xe55b('0x58')](function(_0xf1d789){if(_0xf1d789===_0xe55b('0x59')){_0x5467bd['where'](_0xe55b('0x5a'),[][_0xe55b('0x5b')](_0x5e5fee['query'][_0xf1d789]));}else if(_0xf1d789===_0xe55b('0x55')){var _0x104ec1='%'+_0x5e5fee[_0xe55b('0x2a')][_0xf1d789]+'%';_0x5467bd['where'](_0xe55b('0x5c'),_0x104ec1);}else{_0x5467bd[_0xe55b('0x3e')]('c.'+_0xf1d789+_0xe55b('0x5d'),_0x5e5fee['query'][_0xf1d789]);}});}if(_0x5e5fee[_0xe55b('0x2a')][_0xe55b('0x5e')]){_0x29a65b=_[_0xe55b('0x5f')](_0x5e5fee[_0xe55b('0x2a')]['tag'])?_0x5e5fee[_0xe55b('0x2a')][_0xe55b('0x5e')]:new Array(_0x5e5fee['query'][_0xe55b('0x5e')]);_0x29a65b[_0xe55b('0x58')](function(_0x4610b0){_0x3321c3['or'](_0xe55b('0x48'),'%,'+_0x4610b0+',%');});}if(_0x5e5fee[_0xe55b('0x2a')]['filter']){var _0x338ed9=_0x5e5fee[_0xe55b('0x2a')][_0xe55b('0x60')][_0xe55b('0x61')]('\x5c','\x5c\x5c')[_0xe55b('0x61')](/'/g,'\x27\x27');if(_0x338ed9['split']('\x20')[_0xe55b('0x23')]>0x1){_0x51a501['or'](_0xe55b('0x62'),qs[_0xe55b('0x63')](_0x338ed9),null);}else{if(qs[_0xe55b('0x64')](_0x338ed9)){_0x51a501['or'](_0xe55b('0x65'),_0x338ed9+'%');_0x51a501['or'](_0xe55b('0x66'),_0x338ed9+'%');_0x51a501['or'](_0xe55b('0x67'),_0x338ed9+'%');_0x51a501['or'](_0xe55b('0x68'),_0x338ed9+'%');}else if(qs['isEmail'](_0x338ed9)){_0x51a501['or'](_0xe55b('0x69'),_0x338ed9+'%');}else{_0x51a501['or']('c.firstName\x20LIKE\x20?','%'+_0x338ed9+'%');_0x51a501['or'](_0xe55b('0x6a'),'%'+_0x338ed9+'%');_0x51a501['or'](_0xe55b('0x69'),'%'+_0x338ed9+'%');}}}}_0x5467bd['where'](_0x51a501);_0x5467bd[_0xe55b('0x6b')]('c.id');var _0xdf0d1a={'type':db['Sequelize'][_0xe55b('0x6c')]['SELECT'],'raw':!![]};var _0xb6e28c=_0x5467bd[_0xe55b('0x6d')]()[_0xe55b('0x33')](_0xe55b('0x6e'));if(_0x134980[_0xe55b('0x31')]){_0x134980[_0xe55b('0x31')][_0xe55b('0x58')](function(_0x558c9a){_0x5467bd[_0xe55b('0x31')]('c.'+_0x558c9a[0x0],_0x558c9a[0x1]===_0xe55b('0x6f')?![]:!![]);});}if(!_[_0xe55b('0x57')](_0x29a65b)){_0x5467bd[_0xe55b('0x70')](_0x3321c3);_0xb6e28c[_0xe55b('0x3e')]('t.id\x20IN\x20?',_0x29a65b);}BPromise[_0xe55b('0x71')]()[_0xe55b('0x1a')](function(){if(!_0x3608ec)return;if(_0x5e5fee[_0xe55b('0x72')]['role']!==_0xe55b('0x73'))return;if(!_[_0xe55b('0x74')](_0x3608ec[_0xe55b('0x43')],[_0xe55b('0x33'),'User'])){return _0x5e5fee['user'][_0xe55b('0x75')]({'attributes':['id'],'raw':!![]})[_0xe55b('0x1a')](function(_0xb85ace){if(_[_0xe55b('0x57')](_0xb85ace)){_0xb6e28c[_0xe55b('0x3e')](_0xe55b('0x76'));_0x5467bd['where']('c.ListId\x20IS\x20NULL');}else{_0xb6e28c[_0xe55b('0x3e')]('c.ListId\x20IN\x20?',_[_0xe55b('0x47')](_0xb85ace,'id'));_0x5467bd[_0xe55b('0x3e')](_0xe55b('0x5a'),_[_0xe55b('0x47')](_0xb85ace,'id'));}});}})[_0xe55b('0x1a')](function(){if(_0x5e5fee[_0xe55b('0x72')][_0xe55b('0x77')]===_0xe55b('0x73')&&!_0x3608ec&&!_0x5e5fee[_0xe55b('0x2a')]['ListId'])return[];return db[_0xe55b('0x78')][_0xe55b('0x2a')](_0xb6e28c[_0xe55b('0x79')](),_0xdf0d1a);})[_0xe55b('0x1a')](function(_0x4a57d7){_0x4c7f84[_0xe55b('0x16')]=_0x4a57d7['length'];if(_0x4c7f84['count']===0x0)return[];return db['sequelize'][_0xe55b('0x2a')](_0x3d510d['toString'](),_0xdf0d1a)['then'](function(_0xafd2f4){_0x5e2893=_[_0xe55b('0x7a')](_0xafd2f4,'id');_0xdf0d1a=_[_0xe55b('0x7b')](_0xdf0d1a,{'model':db[_0xe55b('0x21')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x5e5fee[_0xe55b('0x2a')][_0xe55b('0x7c')]){_0x134980['attributes'][_0xe55b('0x58')](function(_0xa8ec5f){_0x5467bd['field']('c.'+_0xa8ec5f);});}else{_0x5467bd['field'](_0xe55b('0x6e'));_0x5467bd[_0xe55b('0x33')]('c.firstName');_0x5467bd[_0xe55b('0x33')](_0xe55b('0x7d'));_0x5467bd['field'](_0xe55b('0x7e'));_0x5467bd[_0xe55b('0x33')](_0xe55b('0x7f'));_0x5467bd[_0xe55b('0x33')](_0xe55b('0x80'));_0x5467bd[_0xe55b('0x33')]('c.email');_0x5467bd[_0xe55b('0x33')](_0xe55b('0x81'));_0x5467bd['field'](_0xe55b('0x82'));_0x5467bd['field']('c.deletedAt');_0x5467bd[_0xe55b('0x33')](_0xe55b('0x83'));_0x5467bd[_0xe55b('0x33')](_0xe55b('0x84'),_0xe55b('0x85'));}if(_0x134980[_0xe55b('0x30')])_0x5467bd['limit'](_0x134980[_0xe55b('0x30')]);if(_0x134980['offset'])_0x5467bd[_0xe55b('0x14')](_0x134980[_0xe55b('0x14')]);return db[_0xe55b('0x78')][_0xe55b('0x2a')](_0x5467bd[_0xe55b('0x79')](),_0xdf0d1a);});})[_0xe55b('0x1a')](function(_0x5a3fe9){_0x5a3fe9[_0xe55b('0x58')](function(_0xf264f7){if(_0xf264f7['TagIds']){_0xf264f7[_0xe55b('0x86')]=[];_0xf264f7[_0xe55b('0x85')][_0xe55b('0x46')](',')[_0xe55b('0x58')](function(_0x333748){_0xf264f7[_0xe55b('0x86')][_0xe55b('0x56')](_0x5e2893[_0x333748]);});}delete _0xf264f7[_0xe55b('0x85')];});_0x4c7f84[_0xe55b('0x87')]=_0x5a3fe9;return _0x4c7f84;})[_0xe55b('0x1a')](respondWithFilteredResult(_0x3552d1,_0x134980));})['catch'](handleError(_0x3552d1,null));};exports[_0xe55b('0x1b')]=function(_0x244df3,_0x21a966){return db[_0xe55b('0x21')][_0xe55b('0x44')]({'where':{'id':_0x244df3[_0xe55b('0x88')]['id']}})[_0xe55b('0x1a')](handleEntityNotFound(_0x21a966,null))[_0xe55b('0x1a')](removeEntity(_0x21a966,null))[_0xe55b('0x89')](handleError(_0x21a966,null));};exports['describe']=function(_0x2b6ad0,_0x10519d){return db[_0xe55b('0x21')]['describe']()[_0xe55b('0x1a')](function(_0xaeafb7){delete _0xaeafb7[_0xe55b('0x8a')];for(var _0x444e33=0x0;_0x444e33<Object['keys'](_0xaeafb7)[_0xe55b('0x23')];_0x444e33++){var _0x5358ba=Object[_0xe55b('0x22')](_0xaeafb7)[_0x444e33];if(!_[_0xe55b('0x24')](_0x5358ba,'cf_')){_0xaeafb7[_0x5358ba]['columnName']=_0x5358ba;_0xaeafb7[_0x5358ba]['displayName']=_0x5358ba;}}return _0xaeafb7;})[_0xe55b('0x1a')](function(_0x186474){var _0x54f102={'where':Boolean(_0x2b6ad0[_0xe55b('0x2a')][_0xe55b('0x8b')])===!![]?undefined:{'$or':[{'ListId':_0x2b6ad0[_0xe55b('0x2a')]['id']},{'ListId':null}]},'raw':!![]};return db[_0xe55b('0x8c')]['findAll'](_0x54f102)['then'](function(_0x82023d){for(var _0x6957f2=0x0;_0x6957f2<_0x82023d[_0xe55b('0x23')];_0x6957f2++){var _0x18b49e=_0xe55b('0x27')+_0x82023d[_0x6957f2]['id'];_0x186474[_0x18b49e][_0xe55b('0x8d')]=_0x18b49e;_0x186474[_0x18b49e][_0xe55b('0x8e')]=_0x82023d[_0x6957f2]['alias'];_0x186474[_0x18b49e][_0xe55b('0x8f')]={'type':_0x82023d[_0x6957f2]['type'],'values':_0x82023d[_0x6957f2][_0xe55b('0x90')]};}Object['keys'](_0x186474)[_0xe55b('0x58')](function(_0xf0b274){if(!_0x186474[_0xf0b274][_0xe55b('0x2e')]('columnName')){delete _0x186474[_0xf0b274];}});return _0x186474;});})['then'](respondWithResult(_0x10519d,null))[_0xe55b('0x89')](handleError(_0x10519d,null));};exports[_0xe55b('0x7b')]=function(_0x22450b,_0x2b030c){var _0x1a8e6b;var _0x44653f;var _0x5ebfb2;if(_0x22450b['body']['id']){delete _0x22450b['body']['id'];}return db[_0xe55b('0x21')][_0xe55b('0x91')]({'where':{'id':[_0x22450b[_0xe55b('0x92')]['to'],_0x22450b[_0xe55b('0x92')][_0xe55b('0x35')]]}})[_0xe55b('0x1a')](function(_0x2c1e9b){if(_0x2c1e9b){if(_0x2c1e9b[_0xe55b('0x23')]!==0x2){return null;}_0x2c1e9b[0x0]=_0x2c1e9b[0x0][_0xe55b('0x93')]({'plain':!![]});_0x2c1e9b[0x1]=_0x2c1e9b[0x1][_0xe55b('0x93')]({'plain':!![]});delete _0x2c1e9b[0x0]['id'];delete _0x2c1e9b[0x1]['id'];return _[_0xe55b('0x94')](_0x2c1e9b[0x0],_0x2c1e9b[0x1],function(_0x38de0f,_0x38e2e){if(Array['isArray'](_0x38e2e)&&!_0x38e2e['length']){return _0x38de0f;}else if(!_0x38e2e){return _0x38de0f;}});}})['then'](handleEntityNotFound(_0x2b030c,null))[_0xe55b('0x1a')](function(_0x2fe7bf){if(_0x2fe7bf){if(_0x2fe7bf[_0xe55b('0x8a')]&&_[_0xe55b('0x5f')](_0x2fe7bf['tags'])){_0x2fe7bf[_0xe55b('0x8a')]=_0x2fe7bf[_0xe55b('0x8a')][_0xe55b('0x95')]();}logger[_0xe55b('0x96')](_0xe55b('0x97'),_0x22450b[_0xe55b('0x92')]['to'],_0x22450b[_0xe55b('0x92')][_0xe55b('0x35')]);return db[_0xe55b('0x98')][_0xe55b('0x1b')]({'where':{'ContactId':[_0x22450b[_0xe55b('0x92')]['to'],_0x22450b[_0xe55b('0x92')][_0xe55b('0x35')]]}})[_0xe55b('0x1a')](function(_0x500041){logger[_0xe55b('0x96')](_0xe55b('0x99'),_0x500041);return db[_0xe55b('0x9a')][_0xe55b('0x1b')]({'where':{'ContactId':[_0x22450b[_0xe55b('0x92')]['to'],_0x22450b[_0xe55b('0x92')][_0xe55b('0x35')]]}})[_0xe55b('0x1a')](function(_0x146c75){logger[_0xe55b('0x96')](_0xe55b('0x9b'),_0x146c75);return db['CmContact']['create'](_0x2fe7bf);});});}})['then'](function(_0x581748){if(_0x581748){_0x1a8e6b=_0x581748;_0x44653f={'ContactId':_0x1a8e6b['id']};_0x5ebfb2={'where':{'ContactId':[_0x22450b[_0xe55b('0x92')]['to'],_0x22450b[_0xe55b('0x92')][_0xe55b('0x35')]]}};return db[_0xe55b('0x9c')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db[_0xe55b('0x9d')]['update'](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db[_0xe55b('0x9e')]['update'](_0x44653f,_0x5ebfb2);}})['then'](function(){if(_0x1a8e6b){return db[_0xe55b('0x9f')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db[_0xe55b('0xa0')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db['MailInteraction'][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})['then'](function(){if(_0x1a8e6b){return db[_0xe55b('0xa0')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db[_0xe55b('0xa1')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db['SmsMessage'][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db[_0xe55b('0xa2')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})['then'](function(){if(_0x1a8e6b){return db[_0xe55b('0xa3')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db['OpenchannelInteraction'][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})['then'](function(){if(_0x1a8e6b){return db[_0xe55b('0xa4')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})['then'](function(){if(_0x1a8e6b){return db[_0xe55b('0xa5')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db[_0xe55b('0xa6')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db[_0xe55b('0xa7')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db[_0xe55b('0xa8')]['update'](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db[_0xe55b('0xa9')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db[_0xe55b('0xaa')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})['then'](function(){if(_0x1a8e6b){return db[_0xe55b('0xab')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db[_0xe55b('0xac')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db[_0xe55b('0xad')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db[_0xe55b('0xae')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db[_0xe55b('0xaf')][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})['then'](function(){if(_0x1a8e6b){return db['WhatsappMessage'][_0xe55b('0x19')](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db[_0xe55b('0xb0')]['update'](_0x44653f,_0x5ebfb2);}})[_0xe55b('0x1a')](function(){if(_0x1a8e6b){return db['CmContact'][_0xe55b('0x1b')]({'where':{'id':[_0x22450b[_0xe55b('0x92')]['to'],_0x22450b['body'][_0xe55b('0x35')]]}});}})['then'](function(){if(_0x1a8e6b){return _0x1a8e6b;}})['then'](respondWithResult(_0x2b030c,null))[_0xe55b('0x89')](handleError(_0x2b030c,null));};exports['create']=function(_0x3d0635,_0x1eae87){return db['CmContact'][_0xe55b('0xb1')]()['then'](function(_0x559959){if(_0x3d0635[_0xe55b('0x92')][_0xe55b('0x8a')]&&_['isArray'](_0x3d0635['body'][_0xe55b('0x8a')])){if(_0x3d0635['body'][_0xe55b('0x8a')][_0xe55b('0x23')]){_0x3d0635[_0xe55b('0x92')][_0xe55b('0x8a')]=_0x3d0635['body'][_0xe55b('0x8a')][_0xe55b('0x95')](';')+';';}else{_0x3d0635[_0xe55b('0x92')][_0xe55b('0x8a')]=null;}}else{_0x3d0635['body'][_0xe55b('0x8a')]=null;}if(!_[_0xe55b('0x54')](_0x3d0635[_0xe55b('0x92')][_0xe55b('0xb2')])){var _0x5de317=_0x3d0635[_0xe55b('0x92')]['dialTimezone'];if(!_['isNil'](shared[_0xe55b('0xb3')][_0x5de317]))_0x3d0635['body'][_0xe55b('0xb4')]=shared[_0xe55b('0xb3')][_0x5de317][_0xe55b('0xb4')];}return db['CmContact'][_0xe55b('0xb5')](_0x3d0635[_0xe55b('0x92')],{'fields':_[_0xe55b('0x22')](_0x559959),'raw':!![]});})[_0xe55b('0x1a')](respondWithResult(_0x1eae87,0xc9))[_0xe55b('0x89')](handleError(_0x1eae87,null));};exports[_0xe55b('0xb6')]=function(_0x397da5,_0x20d073){var _0x1c0ec5=0x0;var _0x4c49d7=0x0;var _0x5a6162=0x0;return db[_0xe55b('0x21')][_0xe55b('0xb1')]()[_0xe55b('0x1a')](function(_0x1251b5){return BPromise[_0xe55b('0xb7')](_0x397da5[_0xe55b('0x92')],function(_0x2384f9){var _0x26c6d8={'where':{'$or':[]},'defaults':_0x2384f9,'fields':_['keys'](_0x1251b5),'raw':!![]};if(_0x2384f9[_0xe55b('0xb8')]){for(var _0x482044=0x0;_0x482044<_0x2384f9[_0xe55b('0xb8')][_0xe55b('0x23')];_0x482044++){var _0x35943a={};_0x35943a[_0x2384f9[_0xe55b('0xb8')][_0x482044]]=_0x2384f9[_0x2384f9[_0xe55b('0xb8')][_0x482044]];_0x26c6d8['where']['$or'][_0xe55b('0x56')](_0x35943a);}_0x26c6d8[_0xe55b('0x3e')][_0xe55b('0x59')]=_0x2384f9[_0xe55b('0x59')];}return db['CmContact'][_0xe55b('0xb9')](_0x26c6d8)['spread'](function(_0x37a6db,_0x5e0589){if(_0x5e0589){_0x1c0ec5++;}else{_0x5a6162++;}})[_0xe55b('0x89')](function(){_0x4c49d7++;});});})['then'](function(_0x176a27){if(_0x176a27){return{'success':_0x1c0ec5,'failure':_0x4c49d7,'duplicates':_0x5a6162};}})['then'](respondWithResult(_0x20d073,0xc9))[_0xe55b('0x89')](handleError(_0x20d073,null));};exports[_0xe55b('0xba')]=function(_0x294eb8,_0x3c7db8){var _0x5a01c7;return db[_0xe55b('0x21')][_0xe55b('0xb1')]()[_0xe55b('0x1a')](function(_0x3cf12c){return db[_0xe55b('0x21')][_0xe55b('0x44')]({'where':{'id':_0x294eb8['params']['id']},'include':[{'model':db[_0xe55b('0x45')],'as':_0xe55b('0x86'),'attributes':['id',_0xe55b('0x1e'),_0xe55b('0x34')],'required':_0x294eb8[_0xe55b('0x2a')][_0xe55b('0x5e')]?!![]:![]}],'attributes':_['keys'](_0x3cf12c)});})['then'](function(_0x192c82){if(!_[_0xe55b('0x54')](_0x192c82)){_0x5a01c7=_0x192c82[_0xe55b('0x93')]({'plain':!![]});var _0x5ac5d7={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x192c82&&_0x192c82['ListId']){if(_0x192c82[_0xe55b('0x59')]){_0x5ac5d7[_0xe55b('0x3e')]['$and'][_0xe55b('0x56')]({'ListId':{'$ne':_0x192c82[_0xe55b('0x59')]}});}}return db[_0xe55b('0x8c')][_0xe55b('0x91')](_0x5ac5d7);}})[_0xe55b('0x1a')](function(_0x2d4954){if(!_['isNil'](_0x2d4954)){return _[_0xe55b('0xbb')](_0x5a01c7,_[_0xe55b('0x47')](_0x2d4954,function(_0x2e2f6b){return util[_0xe55b('0xbc')]('cf_%d',_0x2e2f6b['id']);}));}})['then'](handleEntityNotFound(_0x3c7db8,null))[_0xe55b('0x1a')](respondWithResult(_0x3c7db8,null))[_0xe55b('0x89')](handleError(_0x3c7db8,null));};exports['update']=function(_0x15c214,_0x565bf5){var _0x2100ec;if(_0x15c214[_0xe55b('0x92')]['id']){delete _0x15c214[_0xe55b('0x92')]['id'];}if(!_[_0xe55b('0x54')](_0x15c214[_0xe55b('0x92')]['dialTimezone'])){var _0x55989e=_0x15c214[_0xe55b('0x92')]['dialTimezone'];if(!_[_0xe55b('0x54')](shared[_0xe55b('0xb3')][_0x55989e]))_0x15c214[_0xe55b('0x92')][_0xe55b('0xb4')]=shared[_0xe55b('0xb3')][_0x55989e][_0xe55b('0xb4')];}return db[_0xe55b('0x21')]['find']({'where':{'id':_0x15c214[_0xe55b('0x88')]['id']}})[_0xe55b('0x1a')](handleEntityNotFound(_0x565bf5,null))[_0xe55b('0x1a')](saveUpdates(_0x15c214[_0xe55b('0x92')],null))[_0xe55b('0x1a')](function(_0x43690a){_0x2100ec=_0x43690a;var _0x85e8f8={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x43690a&&_0x43690a['ListId']){if(_0x43690a[_0xe55b('0x59')]){_0x85e8f8[_0xe55b('0x3e')][_0xe55b('0xbd')]['push']({'ListId':{'$ne':_0x43690a[_0xe55b('0x59')]}});}}return db[_0xe55b('0x8c')][_0xe55b('0x91')](_0x85e8f8);})['then'](function(_0x52939f){if(_0x52939f){return _[_0xe55b('0xbb')](_[_0xe55b('0xbe')](_0x15c214[_0xe55b('0x92')],function(_0xee1d8b,_0x3fbf7c){return _[_0xe55b('0x24')](_0x3fbf7c,_0xe55b('0x27'));}),_[_0xe55b('0x47')](_0x52939f,function(_0x45a178){return util[_0xe55b('0xbc')]('cf_%d',_0x45a178['id']);}));}})[_0xe55b('0x1a')](function(_0x550714){if(_0x550714&&!_[_0xe55b('0x57')](_0x550714)){var _0x25548c=squel[_0xe55b('0x19')]()['table']('cm_contacts')[_0xe55b('0xbf')](_0x550714)[_0xe55b('0x3e')](_0xe55b('0xc0'),_0x15c214[_0xe55b('0x88')]['id'])[_0xe55b('0xc1')]();return db[_0xe55b('0x78')][_0xe55b('0x2a')](_0x25548c[_0xe55b('0x52')],{'replacements':_0x25548c['values']});}})[_0xe55b('0x1a')](function(){if(_0x15c214[_0xe55b('0x92')]['phone']&&_0x2100ec){return db[_0xe55b('0x98')]['update']({'phone':_0x15c214[_0xe55b('0x92')][_0xe55b('0xc2')]},{'where':{'ContactId':_0x2100ec['id']}});}})[_0xe55b('0x1a')](function(){return _0x2100ec;})[_0xe55b('0x1a')](respondWithResult(_0x565bf5,null))[_0xe55b('0x89')](handleError(_0x565bf5,null));};exports[_0xe55b('0xc3')]=function(_0x1cfd7f,_0x1c3d34){var _0x47466a={};var _0x376fd4={};var _0x5b71d0;var _0x2cc925;return db[_0xe55b('0x21')][_0xe55b('0x25')]({'where':{'id':_0x1cfd7f['params']['id']}})[_0xe55b('0x1a')](handleEntityNotFound(_0x1c3d34,null))[_0xe55b('0x1a')](function(_0x1b265e){if(_0x1b265e){_0x5b71d0=_0x1b265e;_0x376fd4[_0xe55b('0x29')]=_[_0xe55b('0x22')](db[_0xe55b('0x45')][_0xe55b('0xc4')]);_0x376fd4[_0xe55b('0x2a')]=_[_0xe55b('0x22')](_0x1cfd7f[_0xe55b('0x2a')]);_0x376fd4[_0xe55b('0x2b')]=_[_0xe55b('0x2d')](_0x376fd4[_0xe55b('0x29')],_0x376fd4[_0xe55b('0x2a')]);_0x47466a[_0xe55b('0x2c')]=_[_0xe55b('0x2d')](_0x376fd4[_0xe55b('0x29')],qs[_0xe55b('0x7c')](_0x1cfd7f[_0xe55b('0x2a')][_0xe55b('0x7c')]));_0x47466a[_0xe55b('0x2c')]=_0x47466a[_0xe55b('0x2c')][_0xe55b('0x23')]?_0x47466a[_0xe55b('0x2c')]:_0x376fd4[_0xe55b('0x29')];_0x47466a[_0xe55b('0x31')]=qs['sort'](_0x1cfd7f['query'][_0xe55b('0x32')]);_0x47466a['where']=qs[_0xe55b('0x2b')](_[_0xe55b('0xc5')](_0x1cfd7f['query'],_0x376fd4[_0xe55b('0x2b')]));if(_0x1cfd7f['query'][_0xe55b('0x60')]){_0x47466a['where']=_[_0xe55b('0x7b')](_0x47466a[_0xe55b('0x3e')],{'$or':_[_0xe55b('0x47')](_0x47466a[_0xe55b('0x2c')],function(_0x1cabdc){var _0x3b8904={};_0x3b8904[_0x1cabdc]={'$like':'%'+_0x1cfd7f[_0xe55b('0x2a')]['filter']+'%'};return _0x3b8904;})});}_0x47466a=_[_0xe55b('0x7b')]({},_0x47466a,_0x1cfd7f[_0xe55b('0xc6')]);return _0x5b71d0[_0xe55b('0xc3')](_0x47466a);}})['then'](function(_0x66fa6f){if(_0x66fa6f){_0x2cc925=_0x66fa6f[_0xe55b('0x23')];if(!_0x1cfd7f[_0xe55b('0x2a')][_0xe55b('0x2e')](_0xe55b('0x2f'))){_0x47466a[_0xe55b('0x30')]=qs[_0xe55b('0x30')](_0x1cfd7f[_0xe55b('0x2a')][_0xe55b('0x30')]);_0x47466a[_0xe55b('0x14')]=qs[_0xe55b('0x14')](_0x1cfd7f[_0xe55b('0x2a')][_0xe55b('0x14')]);}return _0x5b71d0[_0xe55b('0xc3')](_0x47466a);}})[_0xe55b('0x1a')](function(_0x48ae6f){if(_0x48ae6f){return _0x48ae6f?{'count':_0x2cc925,'rows':_0x48ae6f}:null;}})[_0xe55b('0x1a')](respondWithResult(_0x1c3d34,null))[_0xe55b('0x89')](handleError(_0x1c3d34,null));};exports[_0xe55b('0xc7')]=function(_0x1611a8,_0x4275ec){if(_0x1611a8['body']['id']){delete _0x1611a8['body']['id'];}return db[_0xe55b('0x21')][_0xe55b('0x25')]({'where':{'id':_0x1611a8[_0xe55b('0x88')]['id']}})[_0xe55b('0x1a')](handleEntityNotFound(_0x4275ec,null))[_0xe55b('0x1a')](function(_0x5e53aa){if(_0x5e53aa){return _0x5e53aa[_0xe55b('0xc7')](_0x1611a8['body']['ids']||[]);}return null;})[_0xe55b('0x1a')](respondWithResult(_0x4275ec,null))[_0xe55b('0x89')](handleError(_0x4275ec,null));};exports[_0xe55b('0xc8')]=function(_0x18b3d2,_0x2a72d9){var _0x3f2974={'raw':![],'where':{}};var _0x29d19a={};var _0x1ed211={'count':0x0,'rows':[]};return db[_0xe55b('0x21')][_0xe55b('0x25')]({'where':{'id':_0x18b3d2[_0xe55b('0x88')]['id']}})[_0xe55b('0x1a')](handleEntityNotFound(_0x2a72d9,null))['then'](function(_0x18b6b4){if(_0x18b6b4){_0x29d19a[_0xe55b('0x29')]=_[_0xe55b('0x22')](db[_0xe55b('0x98')][_0xe55b('0xc4')]);_0x29d19a[_0xe55b('0x2a')]=_[_0xe55b('0x22')](_0x18b3d2[_0xe55b('0x2a')]);_0x29d19a['filters']=_[_0xe55b('0x2d')](_0x29d19a[_0xe55b('0x29')],_0x29d19a[_0xe55b('0x2a')]);_0x3f2974[_0xe55b('0x2c')]=_['intersection'](_0x29d19a['model'],qs[_0xe55b('0x7c')](_0x18b3d2[_0xe55b('0x2a')][_0xe55b('0x7c')]));_0x3f2974[_0xe55b('0x2c')]=_0x3f2974['attributes'][_0xe55b('0x23')]?_0x3f2974[_0xe55b('0x2c')]:_0x29d19a[_0xe55b('0x29')];if(!_0x18b3d2['query']['hasOwnProperty'](_0xe55b('0x2f'))){_0x3f2974[_0xe55b('0x30')]=qs[_0xe55b('0x30')](_0x18b3d2[_0xe55b('0x2a')][_0xe55b('0x30')]);_0x3f2974[_0xe55b('0x14')]=qs['offset'](_0x18b3d2[_0xe55b('0x2a')][_0xe55b('0x14')]);}_0x3f2974[_0xe55b('0x31')]=qs[_0xe55b('0x32')](_0x18b3d2[_0xe55b('0x2a')][_0xe55b('0x32')]);_0x3f2974[_0xe55b('0x3e')]=qs[_0xe55b('0x2b')](_[_0xe55b('0xc5')](_0x18b3d2[_0xe55b('0x2a')],_0x29d19a[_0xe55b('0x2b')]));_0x3f2974['where'][_0xe55b('0xc9')]=_0x18b6b4['id'];if(_0x18b3d2['query'][_0xe55b('0x60')]){_0x3f2974[_0xe55b('0x3e')]=_['merge'](_0x3f2974[_0xe55b('0x3e')],{'$or':_['map'](_0x3f2974[_0xe55b('0x2c')],function(_0x516c72){var _0x36673c={};_0x36673c[_0x516c72]={'$like':'%'+_0x18b3d2[_0xe55b('0x2a')][_0xe55b('0x60')]+'%'};return _0x36673c;})});}_0x3f2974=_[_0xe55b('0x7b')]({},_0x3f2974,_0x18b3d2[_0xe55b('0xc6')]);return db[_0xe55b('0x98')][_0xe55b('0x16')]({'where':_0x3f2974[_0xe55b('0x3e')]})[_0xe55b('0x1a')](function(_0x38bfff){_0x1ed211['count']=_0x38bfff;if(_0x18b3d2[_0xe55b('0x2a')][_0xe55b('0xca')]){_0x3f2974['include']=[{'all':!![]}];}return db[_0xe55b('0x98')][_0xe55b('0x91')](_0x3f2974);})[_0xe55b('0x1a')](function(_0x35196d){_0x1ed211[_0xe55b('0x87')]=_0x35196d;return _0x1ed211;});}})[_0xe55b('0x1a')](respondWithFilteredResult(_0x2a72d9,_0x3f2974))['catch'](handleError(_0x2a72d9,null));};exports[_0xe55b('0xcb')]=function(_0xdab9ee,_0x463adc){var _0x4c7a5e={'raw':!![],'where':{}};var _0x30d965={};var _0x196d45={'count':0x0,'rows':[]};return db[_0xe55b('0x21')][_0xe55b('0x25')]({'where':{'id':_0xdab9ee[_0xe55b('0x88')]['id']}})[_0xe55b('0x1a')](handleEntityNotFound(_0x463adc,null))[_0xe55b('0x1a')](function(_0x24938c){if(_0x24938c){_0x30d965['model']=_['keys'](db[_0xe55b('0xa6')][_0xe55b('0xc4')]);_0x30d965[_0xe55b('0x2a')]=_[_0xe55b('0x22')](_0xdab9ee[_0xe55b('0x2a')]);_0x30d965['filters']=_[_0xe55b('0x2d')](_0x30d965['model'],_0x30d965[_0xe55b('0x2a')]);_0x4c7a5e[_0xe55b('0x2c')]=_[_0xe55b('0x2d')](_0x30d965[_0xe55b('0x29')],qs[_0xe55b('0x7c')](_0xdab9ee[_0xe55b('0x2a')][_0xe55b('0x7c')]));_0x4c7a5e['attributes']=_0x4c7a5e[_0xe55b('0x2c')][_0xe55b('0x23')]?_0x4c7a5e[_0xe55b('0x2c')]:_0x30d965[_0xe55b('0x29')];if(!_0xdab9ee[_0xe55b('0x2a')][_0xe55b('0x2e')](_0xe55b('0x2f'))){_0x4c7a5e['limit']=qs[_0xe55b('0x30')](_0xdab9ee[_0xe55b('0x2a')][_0xe55b('0x30')]);_0x4c7a5e['offset']=qs[_0xe55b('0x14')](_0xdab9ee[_0xe55b('0x2a')][_0xe55b('0x14')]);}_0x4c7a5e['order']=qs[_0xe55b('0x32')](_0xdab9ee[_0xe55b('0x2a')][_0xe55b('0x32')]);_0x4c7a5e[_0xe55b('0x3e')]=qs[_0xe55b('0x2b')](_[_0xe55b('0xc5')](_0xdab9ee[_0xe55b('0x2a')],_0x30d965[_0xe55b('0x2b')]));_0x4c7a5e[_0xe55b('0x3e')]['ContactId']=_0x24938c['id'];if(_0xdab9ee[_0xe55b('0x2a')]['filter']){_0x4c7a5e[_0xe55b('0x3e')]=_[_0xe55b('0x7b')](_0x4c7a5e[_0xe55b('0x3e')],{'$or':_[_0xe55b('0x47')](_0x4c7a5e['attributes'],function(_0x59258e){var _0x264ddf={};_0x264ddf[_0x59258e]={'$like':'%'+_0xdab9ee[_0xe55b('0x2a')][_0xe55b('0x60')]+'%'};return _0x264ddf;})});}_0x4c7a5e=_[_0xe55b('0x7b')]({},_0x4c7a5e,_0xdab9ee[_0xe55b('0xc6')]);return db['CmHopperHistory'][_0xe55b('0x16')]({'where':_0x4c7a5e['where']})[_0xe55b('0x1a')](function(_0x6d6cf1){_0x196d45[_0xe55b('0x16')]=_0x6d6cf1;if(_0xdab9ee[_0xe55b('0x2a')]['includeAll']){_0x4c7a5e[_0xe55b('0xcc')]=[{'all':!![]}];}return db[_0xe55b('0xa6')]['findAll'](_0x4c7a5e);})[_0xe55b('0x1a')](function(_0x2c8161){_0x196d45[_0xe55b('0x87')]=_0x2c8161;return _0x196d45;});}})['then'](respondWithFilteredResult(_0x463adc,_0x4c7a5e))[_0xe55b('0x89')](handleError(_0x463adc,null));};exports[_0xe55b('0xcd')]=function(_0x367443,_0x20794e){var _0x488908={'raw':!![],'where':{}};var _0x1cbaa1={};var _0x569521={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x367443[_0xe55b('0x88')]['id']}})[_0xe55b('0x1a')](handleEntityNotFound(_0x20794e,null))[_0xe55b('0x1a')](function(_0x36a3b0){if(_0x36a3b0){_0x1cbaa1['model']=_[_0xe55b('0x22')](db['CmHopperFinal'][_0xe55b('0xc4')]);_0x1cbaa1['query']=_[_0xe55b('0x22')](_0x367443[_0xe55b('0x2a')]);_0x1cbaa1[_0xe55b('0x2b')]=_['intersection'](_0x1cbaa1[_0xe55b('0x29')],_0x1cbaa1[_0xe55b('0x2a')]);_0x488908[_0xe55b('0x2c')]=_[_0xe55b('0x2d')](_0x1cbaa1[_0xe55b('0x29')],qs[_0xe55b('0x7c')](_0x367443[_0xe55b('0x2a')][_0xe55b('0x7c')]));_0x488908[_0xe55b('0x2c')]=_0x488908[_0xe55b('0x2c')][_0xe55b('0x23')]?_0x488908[_0xe55b('0x2c')]:_0x1cbaa1[_0xe55b('0x29')];if(!_0x367443[_0xe55b('0x2a')][_0xe55b('0x2e')]('nolimit')){_0x488908['limit']=qs[_0xe55b('0x30')](_0x367443[_0xe55b('0x2a')][_0xe55b('0x30')]);_0x488908['offset']=qs[_0xe55b('0x14')](_0x367443[_0xe55b('0x2a')][_0xe55b('0x14')]);}_0x488908['order']=qs[_0xe55b('0x32')](_0x367443['query'][_0xe55b('0x32')]);_0x488908['where']=qs[_0xe55b('0x2b')](_[_0xe55b('0xc5')](_0x367443['query'],_0x1cbaa1['filters']));_0x488908[_0xe55b('0x3e')][_0xe55b('0xc9')]=_0x36a3b0['id'];if(_0x367443[_0xe55b('0x2a')]['filter']){_0x488908[_0xe55b('0x3e')]=_[_0xe55b('0x7b')](_0x488908['where'],{'$or':_[_0xe55b('0x47')](_0x488908[_0xe55b('0x2c')],function(_0x1aa945){var _0x552464={};_0x552464[_0x1aa945]={'$like':'%'+_0x367443['query'][_0xe55b('0x60')]+'%'};return _0x552464;})});}_0x488908=_[_0xe55b('0x7b')]({},_0x488908,_0x367443[_0xe55b('0xc6')]);return db[_0xe55b('0xa5')][_0xe55b('0x16')]({'where':_0x488908['where']})[_0xe55b('0x1a')](function(_0x112376){_0x569521[_0xe55b('0x16')]=_0x112376;if(_0x367443[_0xe55b('0x2a')]['includeAll']){_0x488908[_0xe55b('0xcc')]=[{'all':!![]}];}return db[_0xe55b('0xa5')][_0xe55b('0x91')](_0x488908);})[_0xe55b('0x1a')](function(_0x2721a7){_0x569521[_0xe55b('0x87')]=_0x2721a7;return _0x569521;});}})[_0xe55b('0x1a')](respondWithFilteredResult(_0x20794e,_0x488908))[_0xe55b('0x89')](handleError(_0x20794e,null));};exports[_0xe55b('0xce')]=function(_0x11f459,_0x5004de){var _0x5ec89e={'raw':!![],'where':{}};var _0x42f624={};var _0x1a81bf={'count':0x0,'rows':[]};return db['CmContact'][_0xe55b('0x25')]({'where':{'id':_0x11f459[_0xe55b('0x88')]['id']}})[_0xe55b('0x1a')](handleEntityNotFound(_0x5004de,null))[_0xe55b('0x1a')](function(_0x13b1a6){if(_0x13b1a6){_0x42f624[_0xe55b('0x29')]=_[_0xe55b('0x22')](db['JscriptySessionReport']['rawAttributes']);_0x42f624[_0xe55b('0x2a')]=_[_0xe55b('0x22')](_0x11f459[_0xe55b('0x2a')]);_0x42f624[_0xe55b('0x2b')]=_[_0xe55b('0x2d')](_0x42f624[_0xe55b('0x29')],_0x42f624[_0xe55b('0x2a')]);_0x5ec89e[_0xe55b('0x2c')]=_[_0xe55b('0x2d')](_0x42f624[_0xe55b('0x29')],qs['fields'](_0x11f459[_0xe55b('0x2a')][_0xe55b('0x7c')]));_0x5ec89e[_0xe55b('0x2c')]=_0x5ec89e[_0xe55b('0x2c')][_0xe55b('0x23')]?_0x5ec89e[_0xe55b('0x2c')]:_0x42f624[_0xe55b('0x29')];if(!_0x11f459['query'][_0xe55b('0x2e')](_0xe55b('0x2f'))){_0x5ec89e[_0xe55b('0x30')]=qs['limit'](_0x11f459[_0xe55b('0x2a')][_0xe55b('0x30')]);_0x5ec89e[_0xe55b('0x14')]=qs['offset'](_0x11f459[_0xe55b('0x2a')]['offset']);}_0x5ec89e[_0xe55b('0x31')]=qs[_0xe55b('0x32')](_0x11f459['query'][_0xe55b('0x32')]);_0x5ec89e[_0xe55b('0x3e')]=qs[_0xe55b('0x2b')](_[_0xe55b('0xc5')](_0x11f459[_0xe55b('0x2a')],_0x42f624[_0xe55b('0x2b')]));_0x5ec89e[_0xe55b('0x3e')][_0xe55b('0xc9')]=_0x13b1a6['id'];if(_0x11f459[_0xe55b('0x2a')]['filter']){_0x5ec89e['where']=_['merge'](_0x5ec89e[_0xe55b('0x3e')],{'$or':_[_0xe55b('0x47')](_0x5ec89e[_0xe55b('0x2c')],function(_0x24761c){var _0x353f85={};_0x353f85[_0x24761c]={'$like':'%'+_0x11f459[_0xe55b('0x2a')][_0xe55b('0x60')]+'%'};return _0x353f85;})});}_0x5ec89e=_[_0xe55b('0x7b')]({},_0x5ec89e,_0x11f459[_0xe55b('0xc6')]);return db[_0xe55b('0xae')]['count']({'where':_0x5ec89e[_0xe55b('0x3e')]})['then'](function(_0x4dc9bc){_0x1a81bf['count']=_0x4dc9bc;if(_0x11f459[_0xe55b('0x2a')][_0xe55b('0xca')]){_0x5ec89e['include']=[{'all':!![]}];}return db['JscriptySessionReport'][_0xe55b('0x91')](_0x5ec89e);})[_0xe55b('0x1a')](function(_0x514534){_0x1a81bf[_0xe55b('0x87')]=_0x514534;return _0x1a81bf;});}})[_0xe55b('0x1a')](respondWithFilteredResult(_0x5004de,_0x5ec89e))[_0xe55b('0x89')](handleError(_0x5004de,null));};exports['uploadCsv']=function(_0x5d3707,_0x5dd281){try{if(!_0x5d3707['body'][_0xe55b('0x59')]){throw new Error(_0xe55b('0xcf'));}if(!_0x5d3707[_0xe55b('0x92')]['binding_keys']){throw new Error('No\x20association\x20keys\x20specified!');}if(!_0x5d3707[_0xe55b('0x92')][_0xe55b('0xd0')]){throw new Error(_0xe55b('0xd1'));}if(!_0x5d3707[_0xe55b('0x92')][_0xe55b('0xd2')]){throw new Error(_0xe55b('0xd3'));}var _0x1dbf46=_0x5d3707[_0xe55b('0x92')][_0xe55b('0xd4')]['split'](',');var _0x239582=_0x5d3707['body'][_0xe55b('0xd0')][_0xe55b('0x46')](',');if(!_0x1dbf46[_0xe55b('0x23')]||!_0x239582[_0xe55b('0x23')]||_0x1dbf46['length']!==_0x239582[_0xe55b('0x23')]){throw new Error(_0xe55b('0xd5'));}_0x5d3707['body'][_0xe55b('0x7c')]=_[_0xe55b('0xd6')](_0x1dbf46,_0x239582);if(!_0x5d3707[_0xe55b('0x92')][_0xe55b('0x7c')][_0xe55b('0xc2')]){throw new Error(_0xe55b('0xd7'));}if(!_0x5d3707[_0xe55b('0x92')]['fields'][_0xe55b('0xd8')]){throw new Error('No\x20firstName\x20column\x20specified');}var _0x184bdd=path[_0xe55b('0x95')](config[_0xe55b('0xd9')],'server/files/tmp',_0x5d3707[_0xe55b('0xda')][_0xe55b('0xdb')]);fs[_0xe55b('0xdc')](_0x184bdd,parseInt('0777',0x8));var _0x1caeba=require(_0xe55b('0xdd'))[_0xe55b('0xde')](path[_0xe55b('0x95')](__dirname,'../../components/import/cm/csv'),[_0x184bdd,_0x5d3707[_0xe55b('0x92')][_0xe55b('0xd4')],_0x5d3707[_0xe55b('0x92')][_0xe55b('0xd0')],_0x5d3707[_0xe55b('0x92')][_0xe55b('0x59')],_0x5d3707[_0xe55b('0x92')]['CompanyId'],_0x5d3707[_0xe55b('0x92')][_0xe55b('0xb8')],_0x5d3707['body'][_0xe55b('0xd2')]]);return _0x5dd281[_0xe55b('0x12')](0xc8)['json']({'message':_0xe55b('0xdf'),'pid':_0x1caeba['pid']});}catch(_0x594381){return _0x5dd281[_0xe55b('0x12')](0x1f4)[_0xe55b('0x1f')](_0x594381);}};exports[_0xe55b('0xe0')]=function(_0x5dfc60,_0x1aced7){var _0x101f20=fs[_0xe55b('0xe1')](_0x5dfc60[_0xe55b('0xda')][_0xe55b('0xe2')]);Papa[_0xe55b('0xe3')](_0x101f20,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x3941c3){return _0x1aced7[_0xe55b('0x12')](0xc8)[_0xe55b('0x13')]({'file':_0x5dfc60[_0xe55b('0xda')],'fields':_0x3941c3[_0xe55b('0xe4')][_0xe55b('0x7c')]});}});};exports[_0xe55b('0xe5')]=function(_0x42ea59,_0x347749){return db[_0xe55b('0x4a')][_0xe55b('0x91')]({'raw':!![],'attributes':['id'],'where':{'role':_0xe55b('0x73')}})[_0xe55b('0x1a')](function(_0x4874fd){var _0x5938a0=![];if(!_0x42ea59[_0xe55b('0x92')][_0xe55b('0x59')]){throw new Error(_0xe55b('0xcf'));}if(!_0x42ea59['body']['binding'][_0xe55b('0xc2')]){throw new Error(_0xe55b('0xd7'));}if(!_0x42ea59[_0xe55b('0x92')][_0xe55b('0xe6')][_0xe55b('0xd8')]){throw new Error(_0xe55b('0xe7'));}if(!_0x42ea59[_0xe55b('0x92')][_0xe55b('0xd2')]){throw new Error(_0xe55b('0xd3'));}var _0x38d7a2=require(_0xe55b('0xdd'))['fork'](path[_0xe55b('0x95')](__dirname,_0xe55b('0xe8')),[_0x42ea59['params']['id'],JSON[_0xe55b('0xe9')](_0x42ea59[_0xe55b('0x92')]),JSON['stringify'](_0x4874fd)]);_0x38d7a2['on'](_0xe55b('0xea'),function(){_0x5938a0=!![];return _0x347749[_0xe55b('0x12')](0xc8)[_0xe55b('0x13')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x38d7a2[_0xe55b('0xeb')]});});_0x38d7a2['on']('exit',function(_0x47c6a2){if(_0x47c6a2&&!_0x5938a0){return _0x347749[_0xe55b('0x12')](0x1f4)[_0xe55b('0x13')]({'message':_0xe55b('0xec'),'pid':_0x38d7a2[_0xe55b('0xeb')]});}});})[_0xe55b('0x89')](handleError(_0x347749,null));};exports['getJourney']=function(_0x12de97,_0x40823b){var _0x575045=[_0xe55b('0xed'),'chat',_0xe55b('0xee'),'openchannel',_0xe55b('0xef'),_0xe55b('0xf0'),'voice'];var _0x3ef49f={'offset':0x0,'order':qs[_0xe55b('0x32')]('-createdAt')},_0x1370a8={'count':0x0,'rows':[]};Promise[_0xe55b('0x71')]()[_0xe55b('0x1a')](function(){if(_0x12de97[_0xe55b('0x2a')][_0xe55b('0xf1')]){if(!_[_0xe55b('0xf2')](_0x575045,_0x12de97[_0xe55b('0x2a')][_0xe55b('0xf1')]['toLowerCase']())){throw new Error('Invalid\x20channel');}_0x575045=[_0x12de97[_0xe55b('0x2a')][_0xe55b('0xf1')][_0xe55b('0xf3')]()];}if(_0x12de97[_0xe55b('0x2a')][_0xe55b('0xf4')]){try{var _0x2fa29d=JSON[_0xe55b('0xe3')](_0x12de97[_0xe55b('0x2a')]['range']);if(!moment(_0x2fa29d[_0xe55b('0x35')])[_0xe55b('0xf5')]()){throw new Error('Invalid\x20date\x20for\x20range\x20from\x20filter');}if(!moment(_0x2fa29d['to'])[_0xe55b('0xf5')]()){throw new Error(_0xe55b('0xf6'));}}catch(_0x51ffd4){throw new Error('Invalid\x20createdAt\x20filter');}}if(!_0x12de97['query'][_0xe55b('0x2e')](_0xe55b('0x2f'))){_0x3ef49f[_0xe55b('0x30')]=qs[_0xe55b('0x30')](_0x12de97[_0xe55b('0x2a')][_0xe55b('0x30')]||0xa);_0x3ef49f[_0xe55b('0x14')]=qs[_0xe55b('0x14')](_0x12de97[_0xe55b('0x2a')][_0xe55b('0x14')]);}var _0x5b5e1=_0x575045[_0xe55b('0x47')](function(_0x9f17b0){if(_0x9f17b0===_0xe55b('0xf7')){var _0x4c6846={'attributes':['id',_0xe55b('0xf8'),'type',_0xe55b('0xf9'),_0xe55b('0xfa'),'callerid',_0xe55b('0xfb'),'endtime',_0xe55b('0xfc'),_0xe55b('0xfd'),_0xe55b('0xfe'),'userDisposition',_0xe55b('0xff'),_0xe55b('0x100'),_0xe55b('0x101')],'where':{'ContactId':_0x12de97['params']['id']},'include':[{'model':db[_0xe55b('0x4a')],'as':_0xe55b('0x4a'),'attributes':['id',_0xe55b('0x1e'),_0xe55b('0x102'),_0xe55b('0x103')]}],'order':[[_0xe55b('0xfe'),_0xe55b('0x6f')]]};if(_0x12de97[_0xe55b('0x2a')][_0xe55b('0xf4')]){_0x4c6846[_0xe55b('0x3e')][_0xe55b('0xfe')]={'$gte':_0x2fa29d[_0xe55b('0x35')],'$lte':_0x2fa29d['to']};}return db[_0xe55b('0xa8')][_0xe55b('0x104')](_0x4c6846)[_0xe55b('0x1a')](function(_0x21b096){_0x1370a8[_0xe55b('0x16')]+=_0x21b096['count'];return _[_0xe55b('0x47')](_0x21b096[_0xe55b('0x87')],function(_0x54d2cd){var _0x272cfb=_0x54d2cd[_0xe55b('0x93')]({'plain':!![]});_0x272cfb[_0xe55b('0xf1')]=_0x9f17b0;if(_0x272cfb['User']){_0x272cfb[_0xe55b('0x4a')]={'id':_0x272cfb['User']['id'],'name':_0x272cfb[_0xe55b('0x4a')][_0xe55b('0x1e')],'fullname':_0x272cfb[_0xe55b('0x4a')][_0xe55b('0x102')],'alias':_0x272cfb[_0xe55b('0x4a')][_0xe55b('0x103')]};}return _0x272cfb;});});}else{var _0x834132=_[_0xe55b('0x105')](_0x9f17b0)+(_0x9f17b0==='chat'?'Website':'Account');var _0xa673c3={'attributes':['id',_0xe55b('0x106'),'closedAt',_0xe55b('0xfe'),_0xe55b('0xfd'),_0xe55b('0x107'),'secondDisposition',_0xe55b('0x108'),_0xe55b('0x101'),_0x834132+'Id'],'where':{'ContactId':_0x12de97['params']['id']},'include':[{'model':db[_0x834132],'as':_0xe55b('0x109'),'attributes':['id',_0xe55b('0x1e'),_0xe55b('0x10a')]},{'model':db[_0xe55b('0x4a')],'as':_0xe55b('0x10b'),'attributes':['id',_0xe55b('0x1e'),_0xe55b('0x102')]},{'model':db[_0xe55b('0x45')],'as':_0xe55b('0x86'),'attributes':['id',_0xe55b('0x1e'),_0xe55b('0x34')],'through':{'attributes':[]}}],'order':[[_0xe55b('0xfe'),_0xe55b('0x6f')]]};if(_0x12de97[_0xe55b('0x2a')][_0xe55b('0xf4')]){_0xa673c3[_0xe55b('0x3e')][_0xe55b('0xfe')]={'$gte':_0x2fa29d[_0xe55b('0x35')],'$lte':_0x2fa29d['to']};}switch(_0x9f17b0){case'chat':_0xa673c3[_0xe55b('0x2c')][_0xe55b('0x56')]('browserName',_0xe55b('0x10c'),_0xe55b('0x10d'),_0xe55b('0x10e'),_0xe55b('0x10f'),_0xe55b('0x110'),'ratingType',_0xe55b('0x111'),_0xe55b('0x112'));break;case'mail':_0xa673c3[_0xe55b('0x2c')][_0xe55b('0x56')](_0xe55b('0x113'),_0xe55b('0x114'));break;case _0xe55b('0x115'):_0xa673c3[_0xe55b('0x2c')]['push'](_0xe55b('0x116'),_0xe55b('0x117'));break;}return db[_['startCase'](_0x9f17b0)+_0xe55b('0x118')][_0xe55b('0x104')](_0xa673c3)[_0xe55b('0x1a')](function(_0x49b77e){_0x1370a8[_0xe55b('0x16')]+=_0x49b77e[_0xe55b('0x16')];return _[_0xe55b('0x47')](_0x49b77e[_0xe55b('0x87')],function(_0x2c003d){var _0x4c3505=_0x2c003d[_0xe55b('0x93')]({'plain':!![]});_0x4c3505[_0xe55b('0xf1')]=_0x9f17b0;if(_0x4c3505[_0xe55b('0x10b')]){_0x4c3505[_0xe55b('0x10b')]={'id':_0x4c3505[_0xe55b('0x10b')]['id'],'name':_0x4c3505[_0xe55b('0x10b')][_0xe55b('0x1e')],'fullname':_0x4c3505['Owner'][_0xe55b('0x102')]};}return _0x4c3505;});});}});return Promise[_0xe55b('0x119')](_0x5b5e1);})[_0xe55b('0x1a')](function(_0xf6eb47){return _(_0xf6eb47)[_0xe55b('0x11a')]()[_0xe55b('0x11b')]('createdAt')[_0xe55b('0x11c')]()[_0xe55b('0x4c')]();})[_0xe55b('0x1a')](function(_0x5b5952){_0x1370a8[_0xe55b('0x87')]=_0x3ef49f[_0xe55b('0x30')]?_0x5b5952['slice'](_0x3ef49f[_0xe55b('0x14')],_0x3ef49f[_0xe55b('0x14')]+_0x3ef49f[_0xe55b('0x30')]):_0x5b5952;return _0x1370a8;})[_0xe55b('0x1a')](respondWithFilteredResult(_0x40823b,_0x3ef49f))[_0xe55b('0x89')](handleError(_0x40823b,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff