// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x4bc3=['chat','openchannel','fax','whatsapp','voice','-createdAt','channel','includes','Invalid\x20channel','toLowerCase','range','isValid','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','uniqueid','source','starttime','duration','createdAt','userDisposition','userThirdDisposition','UserId','fullname','DESC','VoiceCallReport','findAndCountAll','Website','Account','closed','closedAt','note','disposition','secondDisposition','thirdDisposition','key','Owner','browserName','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingType','subject','substatus','externalUrl','threadId','Interaction','flatten','sortBy','html-pdf','eml-format','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','fs-extra','crypto','jsforce','desk.js','querystring','papaparse','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/environment','../../config/license/util','../../mysqldb','defaults','localhost','socket.io-emitter','redis','sendStatus','status','end','offset','set','Content-Range','json','reject','save','update','then','destroy','error','stack','name','send','index','CmContact','describe','keys','cf_','push','CmCustomField','findOne','trimStart','all','length','fieldType','type','model','query','filters','intersection','attributes','fields','hasOwnProperty','nolimit','limit','order','where','pick','field','color','from','tools_tags','select','cm_contacts','left_join','cm_user_has_contacts','uc.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','c.deletedAt\x20IS\x20NULL','expr','parseSearch','search','sqlOperator','conditions','value','split','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','and','uc.UserId\x20=\x20?','datetime','castTo','DATE','buildExpression','text','map','filter','Contact','isEmpty','ListId','c.ListId\x20IN\x20?','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','isArray','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?','isEmail','c.email\x20LIKE\x20?','c.lastName\x20LIKE\x20?','c.id','Sequelize','QueryTypes','clone','having','t.id\x20IN\x20?','resolve','user','role','agent','some','User','c.ListId\x20IS\x20NULL','toString','count','keyBy','merge','c.firstName','c.lastName','c.phone','c.mobile','c.fax','c.email','c.ListId','c.createdAt','c.deletedAt','c.CompanyId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','catch','find','params','tags','columnName','displayName','findAll','alias','values','body','get','mergeWith','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatOfflineMessage','MailInteraction','MailMessage','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmContactHasItem','CmHopperFinal','ReportAgentPreview','ChatQueueReport','FaxQueueReport','MailQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappMessage','WhatsappQueueReport','join','bulkCreate','each','duplicates','$or','spread','show','Tag','Phones','ItemType','sequelize','literal','log','$and','omit','pickBy','format','cf_%d','setFields','phone','getTags','rawAttributes','sort','setTags','items','item_types','undefined','contact\x20phone\x20exists','CmHopperAdditionalPhone','PHONE','ContactItemType','OrderBy','item','`ItemType`.OrderBy','duplicateAdditionalPhones','fromContactId','CmContactId','toContactId','rescheduleAdditionalPhones','hopperId','getHoppers','includeAll','CmHopperHistory','ContactId','options','include','rows','getHopperFinals','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','Incorrect\x20binding\x20parameters\x20passed!','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','file','filename','chmodSync','0777','child_process','fork','../../components/import/cm/csv','File\x20uploaded\x20correctly!','pid','upload','createReadStream','parse','meta','binding','stringify','message','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','importUpdates','mail'];(function(_0x1b54f5,_0x83ee6a){var _0x3b9975=function(_0x20762a){while(--_0x20762a){_0x1b54f5['push'](_0x1b54f5['shift']());}};_0x3b9975(++_0x83ee6a);}(_0x4bc3,0x16e));var _0x34bc=function(_0x176329,_0x568c84){_0x176329=_0x176329-0x0;var _0x31997c=_0x4bc3[_0x176329];return _0x31997c;};'use strict';var pdf=require(_0x34bc('0x0'));var emlformat=require(_0x34bc('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x34bc('0x2'));var jsonpatch=require(_0x34bc('0x3'));var rp=require('request-promise');var moment=require(_0x34bc('0x4'));var BPromise=require(_0x34bc('0x5'));var Mustache=require(_0x34bc('0x6'));var util=require(_0x34bc('0x7'));var path=require(_0x34bc('0x8'));var sox=require(_0x34bc('0x9'));var csv=require(_0x34bc('0xa'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x34bc('0xb'));var _=require('lodash');var squel=require('squel');var crypto=require(_0x34bc('0xc'));var jsforce=require(_0x34bc('0xd'));var deskjs=require(_0x34bc('0xe'));var toCsv=require(_0x34bc('0xa'));var querystring=require(_0x34bc('0xf'));var Papa=require(_0x34bc('0x10'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x34bc('0x11'));var as=require(_0x34bc('0x12'));var hardwareService=require(_0x34bc('0x13'));var logger=require('../../config/logger')(_0x34bc('0x14'));var utils=require('../../config/utils');var config=require(_0x34bc('0x15'));var licenseUtil=require(_0x34bc('0x16'));var db=require(_0x34bc('0x17'))['db'];config['redis']=_[_0x34bc('0x18')](config['redis'],{'host':_0x34bc('0x19'),'port':0x18eb});var socket=require(_0x34bc('0x1a'))(new Redis(config[_0x34bc('0x1b')]));require('./cmContact.socket')['register'](socket);function respondWithStatusCode(_0x354868,_0x5e691b){_0x5e691b=_0x5e691b||0xcc;return function(_0x3e93bf){if(_0x3e93bf){return _0x354868[_0x34bc('0x1c')](_0x5e691b);}return _0x354868[_0x34bc('0x1d')](_0x5e691b)[_0x34bc('0x1e')]();};}function respondWithResult(_0x2db2dd,_0x69542f){_0x69542f=_0x69542f||0xc8;return function(_0x5e132d){if(_0x5e132d){return _0x2db2dd['status'](_0x69542f)['json'](_0x5e132d);}};}function respondWithFilteredResult(_0x4205eb,_0x3eaedf){return function(_0x30282b){if(_0x30282b){var _0x239e6c=_0x30282b['count'],_0x567eee=_0x3eaedf[_0x34bc('0x1f')],_0x46aa24=_0x3eaedf[_0x34bc('0x1f')]+_0x3eaedf['limit'],_0x3ca9e8;if(_0x46aa24>=_0x239e6c){_0x46aa24=_0x239e6c;_0x3ca9e8=0xc8;}else{_0x3ca9e8=0xce;}_0x4205eb[_0x34bc('0x1d')](_0x3ca9e8);return _0x4205eb[_0x34bc('0x20')](_0x34bc('0x21'),_0x567eee+'-'+_0x46aa24+'/'+_0x239e6c)[_0x34bc('0x22')](_0x30282b);}return null;};}function patchUpdates(_0x1f993b){return function(_0x42c814){try{jsonpatch['apply'](_0x42c814,_0x1f993b,!![]);}catch(_0x40e128){return BPromise[_0x34bc('0x23')](_0x40e128);}return _0x42c814[_0x34bc('0x24')]();};}function saveUpdates(_0x48eb94,_0x4c4b9a){return function(_0x358d51){if(_0x358d51){return _0x358d51[_0x34bc('0x25')](_0x48eb94)[_0x34bc('0x26')](function(_0x410800){return _0x410800;});}return null;};}function removeEntity(_0x13094a,_0x2e22e3){return function(_0x3f3653){if(_0x3f3653){return _0x3f3653[_0x34bc('0x27')]()[_0x34bc('0x26')](function(){_0x13094a[_0x34bc('0x1d')](0xcc)[_0x34bc('0x1e')]();});}};}function handleEntityNotFound(_0x1edcb0,_0x4fd589){return function(_0x43e527){if(!_0x43e527){_0x1edcb0['sendStatus'](0x194);}return _0x43e527;};}function handleError(_0x4b76c7,_0x3da96b){_0x3da96b=_0x3da96b||0x1f4;return function(_0x5332c8){logger[_0x34bc('0x28')](_0x5332c8[_0x34bc('0x29')]);if(_0x5332c8[_0x34bc('0x2a')]){delete _0x5332c8['name'];}_0x4b76c7[_0x34bc('0x1d')](_0x3da96b)[_0x34bc('0x2b')](_0x5332c8);};}exports[_0x34bc('0x2c')]=function(_0x1a83f7,_0x2bb874){var _0x33bf46={},_0x520fd4={},_0xff07bd={'count':0x0,'rows':[]};return db[_0x34bc('0x2d')][_0x34bc('0x2e')]()[_0x34bc('0x26')](function(_0x2241b4){var _0xd92957=[];for(var _0x5b37de=0x0;_0x5b37de<Object[_0x34bc('0x2f')](_0x2241b4)['length'];_0x5b37de++){var _0x530748=Object[_0x34bc('0x2f')](_0x2241b4)[_0x5b37de];if(_['startsWith'](_0x530748,_0x34bc('0x30'))){_0xd92957[_0x34bc('0x31')](db[_0x34bc('0x32')][_0x34bc('0x33')]({'where':{'id':_[_0x34bc('0x34')](_0x530748,_0x34bc('0x30'))},'raw':!![]}));}}return BPromise[_0x34bc('0x35')](_0xd92957)['then'](function(_0xbd59f9){for(var _0x3a5a74=0x0;_0x3a5a74<_0xbd59f9[_0x34bc('0x36')];_0x3a5a74++){if(_0xbd59f9[_0x3a5a74]){var _0x3224c7=_0x34bc('0x30')+_0xbd59f9[_0x3a5a74]['id'];var _0x5c7e56=_0x2241b4[_0x3224c7];_0x5c7e56[_0x34bc('0x37')]=_0xbd59f9[_0x3a5a74][_0x34bc('0x38')];}}return _0x2241b4;});})[_0x34bc('0x26')](function(_0x493835){_0x520fd4[_0x34bc('0x39')]=_['keys'](_0x493835);_0x520fd4['query']=_[_0x34bc('0x2f')](_0x1a83f7[_0x34bc('0x3a')]);_0x520fd4[_0x34bc('0x3b')]=_[_0x34bc('0x3c')](_0x520fd4['model'],_0x520fd4[_0x34bc('0x3a')]);_0x33bf46[_0x34bc('0x3d')]=_[_0x34bc('0x3c')](_0x520fd4['model'],qs[_0x34bc('0x3e')](_0x1a83f7[_0x34bc('0x3a')][_0x34bc('0x3e')]));_0x33bf46[_0x34bc('0x3d')]=_0x33bf46['attributes'][_0x34bc('0x36')]?_0x33bf46[_0x34bc('0x3d')]:_0x520fd4[_0x34bc('0x39')];if(!_0x1a83f7['query'][_0x34bc('0x3f')](_0x34bc('0x40'))){_0x33bf46[_0x34bc('0x41')]=qs[_0x34bc('0x41')](_0x1a83f7[_0x34bc('0x3a')]['limit']);_0x33bf46[_0x34bc('0x1f')]=qs[_0x34bc('0x1f')](_0x1a83f7[_0x34bc('0x3a')][_0x34bc('0x1f')]);}_0x33bf46[_0x34bc('0x42')]=qs['sort'](_0x1a83f7[_0x34bc('0x3a')]['sort']);_0x33bf46[_0x34bc('0x43')]=qs[_0x34bc('0x3b')](_[_0x34bc('0x44')](_0x1a83f7[_0x34bc('0x3a')],_0x520fd4['filters']),_0x493835);var _0x11ab9c=[];var _0x2d98ad=squel['select']()[_0x34bc('0x45')]('id')[_0x34bc('0x45')](_0x34bc('0x2a'))['field'](_0x34bc('0x46'))[_0x34bc('0x47')](_0x34bc('0x48'));var _0x3444ea=squel[_0x34bc('0x49')]()[_0x34bc('0x47')](_0x34bc('0x4a'),'c')[_0x34bc('0x4b')](_0x34bc('0x4c'),'uc',_0x34bc('0x4d'))[_0x34bc('0x4b')]('cm_contact_has_tags','ct','ct.CmContactId\x20=\x20c.id')[_0x34bc('0x4b')](_0x34bc('0x48'),'t',_0x34bc('0x4e'))[_0x34bc('0x43')](_0x34bc('0x4f'));var _0x2db155=squel['expr']();var _0x3c25a3=[];var _0x4f912a=squel[_0x34bc('0x50')]();var _0x2a21b4;if(_0x1a83f7[_0x34bc('0x3a')]['search']){_0x2a21b4=as[_0x34bc('0x51')](_0x1a83f7[_0x34bc('0x3a')][_0x34bc('0x52')]);var _0x1c6480=_0x2a21b4[_0x34bc('0x53')];for(var _0x26924c=0x0;_0x26924c<_0x2a21b4[_0x34bc('0x54')][_0x34bc('0x36')];_0x26924c++){var _0x32b9c7=_0x2a21b4[_0x34bc('0x54')][_0x26924c];var _0x100c70='c';var _0xe12bd=_(_0x493835)['keys']()['find'](function(_0x5d1efa){return _0x5d1efa===_0x32b9c7[_0x34bc('0x45')];});if(_0xe12bd)_0xe12bd=_0x493835[_0x32b9c7[_0x34bc('0x45')]];if(!_0xe12bd){if(_0x32b9c7['field']==='Tag'){var _0x898cf8=_0x32b9c7[_0x34bc('0x55')][_0x34bc('0x56')](',')['map'](function(_0x43bfb7){return Number(_0x43bfb7);});_0x898cf8[_0x34bc('0x57')](function(_0x49286b){_0x4f912a['or'](_0x34bc('0x58'),'%,'+_0x49286b+',%');});_0x3c25a3=_['union'](_0x3c25a3,_0x898cf8);}else if(_0x32b9c7[_0x34bc('0x45')]==='User'){_0x2db155[_0x34bc('0x59')](_0x34bc('0x5a'),_0x32b9c7[_0x34bc('0x55')]);}}else{if(_0x32b9c7[_0x34bc('0x45')]==='dateOfBirth'||_0xe12bd[_0x34bc('0x37')]===_0x34bc('0x5b'))_0x32b9c7[_0x34bc('0x5c')]=_0x34bc('0x5d');var _0x13ce50=as[_0x34bc('0x5e')](_0x100c70,_0xe12bd[_0x34bc('0x38')],_0x32b9c7);_0x2db155[_0x1c6480](_0x13ce50[_0x34bc('0x5f')],_0x13ce50['value']['start'],_0x13ce50['value'][_0x34bc('0x1e')]);}}}else{var _0x1ed088=_(Object['keys'](_0x1a83f7[_0x34bc('0x3a')]))[_0x34bc('0x60')](function(_0x2a38c3){return _0x493835[_0x34bc('0x3f')](_0x2a38c3)?_0x2a38c3:undefined;})[_0x34bc('0x61')](function(_0x5c82c2){return!_['isNil'](_0x5c82c2);})['value']();if(_0x1a83f7[_0x34bc('0x3a')][_0x34bc('0x62')])_0x1ed088[_0x34bc('0x31')](_0x34bc('0x62'));if(!_[_0x34bc('0x63')](_0x1ed088)){_0x1ed088['forEach'](function(_0xdfe006){if(_0xdfe006===_0x34bc('0x64')){_0x3444ea[_0x34bc('0x43')](_0x34bc('0x65'),[]['concat'](_0x1a83f7[_0x34bc('0x3a')][_0xdfe006]));}else if(_0xdfe006===_0x34bc('0x62')){var _0x29d7df='%'+_0x1a83f7[_0x34bc('0x3a')][_0xdfe006]+'%';_0x3444ea[_0x34bc('0x43')](_0x34bc('0x66'),_0x29d7df);}else{_0x3444ea[_0x34bc('0x43')]('c.'+_0xdfe006+_0x34bc('0x67'),_0x1a83f7[_0x34bc('0x3a')][_0xdfe006]);}});}if(_0x1a83f7[_0x34bc('0x3a')][_0x34bc('0x68')]){_0x3c25a3=_[_0x34bc('0x69')](_0x1a83f7[_0x34bc('0x3a')]['tag'])?_0x1a83f7[_0x34bc('0x3a')][_0x34bc('0x68')]:new Array(_0x1a83f7[_0x34bc('0x3a')][_0x34bc('0x68')]);_0x3c25a3[_0x34bc('0x57')](function(_0x1b3704){_0x4f912a['or'](_0x34bc('0x58'),'%,'+_0x1b3704+',%');});}if(_0x1a83f7[_0x34bc('0x3a')][_0x34bc('0x61')]){var _0x6b42f7=_0x1a83f7[_0x34bc('0x3a')][_0x34bc('0x61')][_0x34bc('0x6a')]('\x5c','\x5c\x5c')[_0x34bc('0x6a')](/'/g,'\x27\x27');if(_0x6b42f7['split']('\x20')[_0x34bc('0x36')]>0x1){_0x2db155['or'](_0x34bc('0x6b'),qs[_0x34bc('0x6c')](_0x6b42f7),null);}else{if(qs[_0x34bc('0x6d')](_0x6b42f7)){_0x2db155['or'](_0x34bc('0x6e'),_0x6b42f7+'%');_0x2db155['or'](_0x34bc('0x6f'),_0x6b42f7+'%');_0x2db155['or'](_0x34bc('0x70'),_0x6b42f7+'%');_0x2db155['or'](_0x34bc('0x71'),_0x6b42f7+'%');}else if(qs[_0x34bc('0x72')](_0x6b42f7)){_0x2db155['or'](_0x34bc('0x73'),_0x6b42f7+'%');}else{_0x2db155['or']('c.firstName\x20LIKE\x20?','%'+_0x6b42f7+'%');_0x2db155['or'](_0x34bc('0x74'),'%'+_0x6b42f7+'%');_0x2db155['or'](_0x34bc('0x73'),'%'+_0x6b42f7+'%');}}}}_0x3444ea[_0x34bc('0x43')](_0x2db155);_0x3444ea['group'](_0x34bc('0x75'));var _0x295420={'type':db[_0x34bc('0x76')][_0x34bc('0x77')]['SELECT'],'raw':!![]};var _0x375aff=_0x3444ea[_0x34bc('0x78')]()[_0x34bc('0x45')](_0x34bc('0x75'));if(_0x33bf46[_0x34bc('0x42')]){_0x33bf46[_0x34bc('0x42')][_0x34bc('0x57')](function(_0x3b8f72){_0x3444ea['order']('c.'+_0x3b8f72[0x0],_0x3b8f72[0x1]==='DESC'?![]:!![]);});}if(!_[_0x34bc('0x63')](_0x3c25a3)){_0x3444ea[_0x34bc('0x79')](_0x4f912a);_0x375aff[_0x34bc('0x43')](_0x34bc('0x7a'),_0x3c25a3);}BPromise[_0x34bc('0x7b')]()[_0x34bc('0x26')](function(){if(!_0x2a21b4)return;if(_0x1a83f7[_0x34bc('0x7c')][_0x34bc('0x7d')]!==_0x34bc('0x7e'))return;if(!_[_0x34bc('0x7f')](_0x2a21b4[_0x34bc('0x54')],[_0x34bc('0x45'),_0x34bc('0x80')])){return _0x1a83f7[_0x34bc('0x7c')]['getLists']({'attributes':['id'],'raw':!![]})[_0x34bc('0x26')](function(_0x2dc1df){if(_[_0x34bc('0x63')](_0x2dc1df)){_0x375aff['where'](_0x34bc('0x81'));_0x3444ea[_0x34bc('0x43')](_0x34bc('0x81'));}else{_0x375aff[_0x34bc('0x43')]('c.ListId\x20IN\x20?',_[_0x34bc('0x60')](_0x2dc1df,'id'));_0x3444ea[_0x34bc('0x43')](_0x34bc('0x65'),_[_0x34bc('0x60')](_0x2dc1df,'id'));}});}})[_0x34bc('0x26')](function(){if(_0x1a83f7['user'][_0x34bc('0x7d')]===_0x34bc('0x7e')&&!_0x2a21b4&&!_0x1a83f7[_0x34bc('0x3a')][_0x34bc('0x64')])return[];return db['sequelize'][_0x34bc('0x3a')](_0x375aff[_0x34bc('0x82')](),_0x295420);})[_0x34bc('0x26')](function(_0x2915ec){_0xff07bd[_0x34bc('0x83')]=_0x2915ec[_0x34bc('0x36')];if(_0xff07bd['count']===0x0)return[];return db['sequelize'][_0x34bc('0x3a')](_0x2d98ad[_0x34bc('0x82')](),_0x295420)['then'](function(_0x348002){_0x11ab9c=_[_0x34bc('0x84')](_0x348002,'id');_0x295420=_[_0x34bc('0x85')](_0x295420,{'model':db[_0x34bc('0x2d')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x1a83f7['query']['fields']){_0x33bf46[_0x34bc('0x3d')][_0x34bc('0x57')](function(_0x1892b1){_0x3444ea[_0x34bc('0x45')]('c.'+_0x1892b1);});}else{_0x3444ea[_0x34bc('0x45')](_0x34bc('0x75'));_0x3444ea[_0x34bc('0x45')](_0x34bc('0x86'));_0x3444ea[_0x34bc('0x45')](_0x34bc('0x87'));_0x3444ea[_0x34bc('0x45')](_0x34bc('0x88'));_0x3444ea[_0x34bc('0x45')](_0x34bc('0x89'));_0x3444ea[_0x34bc('0x45')](_0x34bc('0x8a'));_0x3444ea['field'](_0x34bc('0x8b'));_0x3444ea[_0x34bc('0x45')](_0x34bc('0x8c'));_0x3444ea[_0x34bc('0x45')](_0x34bc('0x8d'));_0x3444ea['field'](_0x34bc('0x8e'));_0x3444ea[_0x34bc('0x45')](_0x34bc('0x8f'));_0x3444ea[_0x34bc('0x45')](_0x34bc('0x90'),'TagIds');}if(_0x33bf46[_0x34bc('0x41')])_0x3444ea[_0x34bc('0x41')](_0x33bf46[_0x34bc('0x41')]);if(_0x33bf46[_0x34bc('0x1f')])_0x3444ea[_0x34bc('0x1f')](_0x33bf46[_0x34bc('0x1f')]);return db['sequelize'][_0x34bc('0x3a')](_0x3444ea[_0x34bc('0x82')](),_0x295420);});})['then'](function(_0x345aa1){_0x345aa1[_0x34bc('0x57')](function(_0xd0213e){if(_0xd0213e['TagIds']){_0xd0213e['Tags']=[];_0xd0213e[_0x34bc('0x91')]['split'](',')['forEach'](function(_0x55055d){_0xd0213e[_0x34bc('0x92')][_0x34bc('0x31')](_0x11ab9c[_0x55055d]);});}delete _0xd0213e[_0x34bc('0x91')];});_0xff07bd['rows']=_0x345aa1;return _0xff07bd;})[_0x34bc('0x26')](respondWithFilteredResult(_0x2bb874,_0x33bf46));})[_0x34bc('0x93')](handleError(_0x2bb874,null));};exports[_0x34bc('0x27')]=function(_0xc3bd23,_0x142231){return db[_0x34bc('0x2d')][_0x34bc('0x94')]({'where':{'id':_0xc3bd23[_0x34bc('0x95')]['id']}})[_0x34bc('0x26')](handleEntityNotFound(_0x142231,null))[_0x34bc('0x26')](removeEntity(_0x142231,null))[_0x34bc('0x93')](handleError(_0x142231,null));};exports[_0x34bc('0x2e')]=function(_0x5a37a3,_0x5d9b43){return db[_0x34bc('0x2d')][_0x34bc('0x2e')]()[_0x34bc('0x26')](function(_0x2423a3){delete _0x2423a3[_0x34bc('0x96')];for(var _0x16d942=0x0;_0x16d942<Object[_0x34bc('0x2f')](_0x2423a3)[_0x34bc('0x36')];_0x16d942++){var _0x2a5455=Object[_0x34bc('0x2f')](_0x2423a3)[_0x16d942];if(!_['startsWith'](_0x2a5455,_0x34bc('0x30'))){_0x2423a3[_0x2a5455][_0x34bc('0x97')]=_0x2a5455;_0x2423a3[_0x2a5455][_0x34bc('0x98')]=_0x2a5455;}}return _0x2423a3;})[_0x34bc('0x26')](function(_0xe77c37){var _0x21261a={'where':{'$or':[{'ListId':_0x5a37a3[_0x34bc('0x3a')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x34bc('0x32')][_0x34bc('0x99')](_0x21261a)['then'](function(_0x46989a){for(var _0x4b5a08=0x0;_0x4b5a08<_0x46989a['length'];_0x4b5a08++){var _0x21a70a='cf_'+_0x46989a[_0x4b5a08]['id'];_0xe77c37[_0x21a70a]['columnName']=_0x21a70a;_0xe77c37[_0x21a70a][_0x34bc('0x98')]=_0x46989a[_0x4b5a08][_0x34bc('0x9a')];_0xe77c37[_0x21a70a]['custom']={'type':_0x46989a[_0x4b5a08][_0x34bc('0x38')],'values':_0x46989a[_0x4b5a08][_0x34bc('0x9b')]};}Object[_0x34bc('0x2f')](_0xe77c37)[_0x34bc('0x57')](function(_0x4eea4e){if(!_0xe77c37[_0x4eea4e][_0x34bc('0x3f')](_0x34bc('0x97'))){delete _0xe77c37[_0x4eea4e];}});return _0xe77c37;});})['then'](respondWithResult(_0x5d9b43,null))['catch'](handleError(_0x5d9b43,null));};exports['merge']=function(_0x18c493,_0xeec6d){var _0x1d9ca2;var _0xc5a4df;var _0x1bcfc9;if(_0x18c493[_0x34bc('0x9c')]['id']){delete _0x18c493[_0x34bc('0x9c')]['id'];}return db[_0x34bc('0x2d')][_0x34bc('0x99')]({'where':{'id':[_0x18c493['body']['to'],_0x18c493[_0x34bc('0x9c')][_0x34bc('0x47')]]}})[_0x34bc('0x26')](function(_0x2431c9){if(_0x2431c9){if(_0x2431c9[_0x34bc('0x36')]!==0x2){return null;}_0x2431c9[0x0]=_0x2431c9[0x0][_0x34bc('0x9d')]({'plain':!![]});_0x2431c9[0x1]=_0x2431c9[0x1]['get']({'plain':!![]});delete _0x2431c9[0x0]['id'];delete _0x2431c9[0x1]['id'];return _[_0x34bc('0x9e')](_0x2431c9[0x0],_0x2431c9[0x1],function(_0x326e54,_0x2ccc1d){if(Array[_0x34bc('0x69')](_0x2ccc1d)&&!_0x2ccc1d[_0x34bc('0x36')]){return _0x326e54;}else if(!_0x2ccc1d){return _0x326e54;}});}})[_0x34bc('0x26')](handleEntityNotFound(_0xeec6d,null))[_0x34bc('0x26')](function(_0xd7bbb1){if(_0xd7bbb1){if(_0xd7bbb1['tags']&&_[_0x34bc('0x69')](_0xd7bbb1[_0x34bc('0x96')])){_0xd7bbb1[_0x34bc('0x96')]=_0xd7bbb1['tags']['join']();}logger[_0x34bc('0x9f')](_0x34bc('0xa0'),_0x18c493[_0x34bc('0x9c')]['to'],_0x18c493[_0x34bc('0x9c')]['from']);return db[_0x34bc('0xa1')][_0x34bc('0x27')]({'where':{'ContactId':[_0x18c493[_0x34bc('0x9c')]['to'],_0x18c493[_0x34bc('0x9c')]['from']]}})[_0x34bc('0x26')](function(_0x29cd84){logger[_0x34bc('0x9f')](_0x34bc('0xa2'),_0x29cd84);return db[_0x34bc('0xa3')][_0x34bc('0x27')]({'where':{'ContactId':[_0x18c493['body']['to'],_0x18c493[_0x34bc('0x9c')][_0x34bc('0x47')]]}})[_0x34bc('0x26')](function(_0x3acf5e){logger['info'](_0x34bc('0xa4'),_0x3acf5e);return db[_0x34bc('0x2d')][_0x34bc('0xa5')](_0xd7bbb1);});});}})['then'](function(_0x449e07){if(_0x449e07){_0x1d9ca2=_0x449e07;_0xc5a4df={'ContactId':_0x1d9ca2['id']};_0x1bcfc9={'where':{'ContactId':[_0x18c493[_0x34bc('0x9c')]['to'],_0x18c493[_0x34bc('0x9c')][_0x34bc('0x47')]]}};return db['ChatInteraction'][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})['then'](function(){if(_0x1d9ca2){return db['ChatMessage'][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})['then'](function(){if(_0x1d9ca2){return db[_0x34bc('0xa6')][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db[_0x34bc('0xa7')]['update'](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db['MailMessage'][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db['MailInteraction'][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db[_0x34bc('0xa8')]['update'](_0xc5a4df,_0x1bcfc9);}})['then'](function(){if(_0x1d9ca2){return db['SmsInteraction']['update'](_0xc5a4df,_0x1bcfc9);}})['then'](function(){if(_0x1d9ca2){return db[_0x34bc('0xa9')][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db[_0x34bc('0xaa')]['update'](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db[_0x34bc('0xab')][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db[_0x34bc('0xac')][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db[_0x34bc('0xad')][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db[_0x34bc('0xae')][_0x34bc('0x25')]({'CmContactId':_0x1d9ca2['id']},{'where':{'CmContactId':[_0x18c493[_0x34bc('0x9c')]['to'],_0x18c493[_0x34bc('0x9c')][_0x34bc('0x47')]]}});}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db[_0x34bc('0xaf')][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})['then'](function(){if(_0x1d9ca2){return db['CmHopperHistory']['update'](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db[_0x34bc('0xb0')][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db['VoiceCallReport'][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db[_0x34bc('0xb1')][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})['then'](function(){if(_0x1d9ca2){return db[_0x34bc('0xb2')]['update'](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db[_0x34bc('0xb3')]['update'](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db['OpenchannelQueueReport'][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db[_0x34bc('0xb4')][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})['then'](function(){if(_0x1d9ca2){return db[_0x34bc('0xb5')][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db['WhatsappInteraction'][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db[_0x34bc('0xb6')][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db[_0x34bc('0xb7')][_0x34bc('0x25')](_0xc5a4df,_0x1bcfc9);}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return db[_0x34bc('0x2d')][_0x34bc('0x27')]({'where':{'id':[_0x18c493['body']['to'],_0x18c493[_0x34bc('0x9c')][_0x34bc('0x47')]]}});}})[_0x34bc('0x26')](function(){if(_0x1d9ca2){return _0x1d9ca2;}})[_0x34bc('0x26')](respondWithResult(_0xeec6d,null))[_0x34bc('0x93')](handleError(_0xeec6d,null));};exports[_0x34bc('0xa5')]=function(_0x414b0f,_0x3dd171){return db[_0x34bc('0x2d')][_0x34bc('0x2e')]()['then'](function(_0x375c45){if(_0x414b0f[_0x34bc('0x9c')][_0x34bc('0x96')]&&_[_0x34bc('0x69')](_0x414b0f[_0x34bc('0x9c')][_0x34bc('0x96')])){if(_0x414b0f[_0x34bc('0x9c')][_0x34bc('0x96')][_0x34bc('0x36')]){_0x414b0f[_0x34bc('0x9c')][_0x34bc('0x96')]=_0x414b0f[_0x34bc('0x9c')][_0x34bc('0x96')][_0x34bc('0xb8')](';')+';';}else{_0x414b0f['body'][_0x34bc('0x96')]=null;}}else{_0x414b0f[_0x34bc('0x9c')][_0x34bc('0x96')]=null;}return db['CmContact']['create'](_0x414b0f['body'],{'fields':_[_0x34bc('0x2f')](_0x375c45),'raw':!![]});})['then'](respondWithResult(_0x3dd171,0xc9))[_0x34bc('0x93')](handleError(_0x3dd171,null));};exports[_0x34bc('0xb9')]=function(_0x55576d,_0x56fbb7){var _0x67e4a0=[];var _0x249764=0x0;var _0x4e3361=0x0;var _0x33022b=0x0;return db['CmContact'][_0x34bc('0x2e')]()[_0x34bc('0x26')](function(_0x3dbf98){return BPromise[_0x34bc('0xba')](_0x55576d['body'],function(_0x386b66){var _0x301f8b={'where':{'$or':[]},'defaults':_0x386b66,'fields':_[_0x34bc('0x2f')](_0x3dbf98),'raw':!![]};if(_0x386b66[_0x34bc('0xbb')]){for(var _0x3bdd19=0x0;_0x3bdd19<_0x386b66[_0x34bc('0xbb')][_0x34bc('0x36')];_0x3bdd19++){var _0x52b208={};_0x52b208[_0x386b66['duplicates'][_0x3bdd19]]=_0x386b66[_0x386b66[_0x34bc('0xbb')][_0x3bdd19]];_0x301f8b[_0x34bc('0x43')][_0x34bc('0xbc')]['push'](_0x52b208);}_0x301f8b[_0x34bc('0x43')][_0x34bc('0x64')]=_0x386b66[_0x34bc('0x64')];}return db[_0x34bc('0x2d')]['findOrCreate'](_0x301f8b)[_0x34bc('0xbd')](function(_0x4252f6,_0x4035ce){if(_0x4035ce){_0x249764++;}else{_0x33022b++;}})[_0x34bc('0x93')](function(_0xe1e40){console[_0x34bc('0x28')](_0xe1e40);_0x4e3361++;});});})[_0x34bc('0x26')](function(_0x1b179f){if(_0x1b179f){return{'success':_0x249764,'failure':_0x4e3361,'duplicates':_0x33022b};}})[_0x34bc('0x26')](respondWithResult(_0x56fbb7,0xc9))[_0x34bc('0x93')](handleError(_0x56fbb7,null));};exports[_0x34bc('0xbe')]=function(_0x28079b,_0x2c0bc6,_0x33ff4e){var _0x554e5f;return db[_0x34bc('0x2d')][_0x34bc('0x2e')]()['then'](function(_0x446f1b){return db[_0x34bc('0x2d')][_0x34bc('0x94')]({'where':{'id':_0x28079b[_0x34bc('0x95')]['id']},'include':[{'model':db[_0x34bc('0xbf')],'as':_0x34bc('0x92'),'attributes':['id','name',_0x34bc('0x46')],'required':_0x28079b['query'][_0x34bc('0x68')]?!![]:![]},{'model':db['CmContactHasItem'],'as':_0x34bc('0xc0'),'where':{'CmContactId':_0x28079b[_0x34bc('0x95')]['id']},'required':![],'include':[{'model':db['ContactItemType'],'as':_0x34bc('0xc1')}]}],'order':[db[_0x34bc('0xc2')][_0x34bc('0xc3')]('`Phones.ItemType`.OrderBy')],'logging':console[_0x34bc('0xc4')],'attributes':_[_0x34bc('0x2f')](_0x446f1b)});})[_0x34bc('0x26')](function(_0x1aba80){_0x554e5f=_0x1aba80[_0x34bc('0x9d')]({'plain':!![]});var _0x386a24={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x1aba80&&_0x1aba80['ListId']){if(_0x1aba80[_0x34bc('0x64')]){_0x386a24[_0x34bc('0x43')]['$and'][_0x34bc('0x31')]({'ListId':{'$ne':_0x1aba80[_0x34bc('0x64')]}});}}return db['CmCustomField'][_0x34bc('0x99')](_0x386a24);})[_0x34bc('0x26')](function(_0x363a7c){return _['omit'](_0x554e5f,_[_0x34bc('0x60')](_0x363a7c,function(_0x5be778){return util['format']('cf_%d',_0x5be778['id']);}));})[_0x34bc('0x26')](handleEntityNotFound(_0x2c0bc6,null))['then'](respondWithResult(_0x2c0bc6,null))[_0x34bc('0x93')](handleError(_0x2c0bc6,null));};exports['update']=function(_0x4abde3,_0x44de58){var _0x570be3;if(_0x4abde3['body']['id']){delete _0x4abde3[_0x34bc('0x9c')]['id'];}return db['CmContact'][_0x34bc('0x94')]({'where':{'id':_0x4abde3[_0x34bc('0x95')]['id']}})[_0x34bc('0x26')](handleEntityNotFound(_0x44de58,null))[_0x34bc('0x26')](saveUpdates(_0x4abde3['body'],null))[_0x34bc('0x26')](function(_0x4054b4){_0x570be3=_0x4054b4;var _0x22ac51={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x4054b4&&_0x4054b4[_0x34bc('0x64')]){if(_0x4054b4['ListId']){_0x22ac51[_0x34bc('0x43')][_0x34bc('0xc5')][_0x34bc('0x31')]({'ListId':{'$ne':_0x4054b4[_0x34bc('0x64')]}});}}return db[_0x34bc('0x32')][_0x34bc('0x99')](_0x22ac51);})[_0x34bc('0x26')](function(_0x2033a6){if(_0x2033a6){return _[_0x34bc('0xc6')](_[_0x34bc('0xc7')](_0x4abde3[_0x34bc('0x9c')],function(_0x596197,_0x4c7317){return _['startsWith'](_0x4c7317,_0x34bc('0x30'));}),_[_0x34bc('0x60')](_0x2033a6,function(_0x59cdc9){return util[_0x34bc('0xc8')](_0x34bc('0xc9'),_0x59cdc9['id']);}));}})['then'](function(_0x4808e8){if(_0x4808e8&&!_[_0x34bc('0x63')](_0x4808e8)){var _0x39fcc2=squel['update']()['table'](_0x34bc('0x4a'))[_0x34bc('0xca')](_0x4808e8)[_0x34bc('0x43')]('id\x20=\x20?',_0x4abde3['params']['id'])['toParam']();return db[_0x34bc('0xc2')]['query'](_0x39fcc2[_0x34bc('0x5f')],{'replacements':_0x39fcc2['values']});}})['then'](function(){if(_0x4abde3[_0x34bc('0x9c')][_0x34bc('0xcb')]&&_0x570be3){return db[_0x34bc('0xa1')][_0x34bc('0x25')]({'phone':_0x4abde3[_0x34bc('0x9c')][_0x34bc('0xcb')]},{'where':{'ContactId':_0x570be3['id']}});}})[_0x34bc('0x26')](function(){return _0x570be3;})[_0x34bc('0x26')](respondWithResult(_0x44de58,null))[_0x34bc('0x93')](handleError(_0x44de58,null));};exports[_0x34bc('0xcc')]=function(_0x37451f,_0x47d405,_0x2b558d){var _0x1782bd={};var _0x21c64b={};var _0x33afa3;var _0x22cd32;return db['CmContact'][_0x34bc('0x33')]({'where':{'id':_0x37451f['params']['id']}})[_0x34bc('0x26')](handleEntityNotFound(_0x47d405,null))['then'](function(_0x4afd5f){if(_0x4afd5f){_0x33afa3=_0x4afd5f;_0x21c64b[_0x34bc('0x39')]=_[_0x34bc('0x2f')](db[_0x34bc('0xbf')][_0x34bc('0xcd')]);_0x21c64b[_0x34bc('0x3a')]=_['keys'](_0x37451f['query']);_0x21c64b[_0x34bc('0x3b')]=_[_0x34bc('0x3c')](_0x21c64b[_0x34bc('0x39')],_0x21c64b[_0x34bc('0x3a')]);_0x1782bd[_0x34bc('0x3d')]=_[_0x34bc('0x3c')](_0x21c64b[_0x34bc('0x39')],qs['fields'](_0x37451f['query'][_0x34bc('0x3e')]));_0x1782bd[_0x34bc('0x3d')]=_0x1782bd['attributes'][_0x34bc('0x36')]?_0x1782bd[_0x34bc('0x3d')]:_0x21c64b[_0x34bc('0x39')];_0x1782bd[_0x34bc('0x42')]=qs['sort'](_0x37451f[_0x34bc('0x3a')][_0x34bc('0xce')]);_0x1782bd[_0x34bc('0x43')]=qs[_0x34bc('0x3b')](_[_0x34bc('0x44')](_0x37451f[_0x34bc('0x3a')],_0x21c64b['filters']));if(_0x37451f[_0x34bc('0x3a')][_0x34bc('0x61')]){_0x1782bd[_0x34bc('0x43')]=_['merge'](_0x1782bd[_0x34bc('0x43')],{'$or':_[_0x34bc('0x60')](_0x1782bd[_0x34bc('0x3d')],function(_0x1c508a){var _0x12dc1c={};_0x12dc1c[_0x1c508a]={'$like':'%'+_0x37451f[_0x34bc('0x3a')][_0x34bc('0x61')]+'%'};return _0x12dc1c;})});}_0x1782bd=_[_0x34bc('0x85')]({},_0x1782bd,_0x37451f['options']);return _0x33afa3[_0x34bc('0xcc')](_0x1782bd);}})[_0x34bc('0x26')](function(_0x2c46c){if(_0x2c46c){_0x22cd32=_0x2c46c['length'];if(!_0x37451f[_0x34bc('0x3a')]['hasOwnProperty']('nolimit')){_0x1782bd['limit']=qs[_0x34bc('0x41')](_0x37451f['query']['limit']);_0x1782bd['offset']=qs['offset'](_0x37451f[_0x34bc('0x3a')][_0x34bc('0x1f')]);}return _0x33afa3[_0x34bc('0xcc')](_0x1782bd);}})[_0x34bc('0x26')](function(_0x1f6812){if(_0x1f6812){return _0x1f6812?{'count':_0x22cd32,'rows':_0x1f6812}:null;}})[_0x34bc('0x26')](respondWithResult(_0x47d405,null))[_0x34bc('0x93')](handleError(_0x47d405,null));};exports[_0x34bc('0xcf')]=function(_0x357c4c,_0x553355,_0x4e8810){if(_0x357c4c[_0x34bc('0x9c')]['id']){delete _0x357c4c[_0x34bc('0x9c')]['id'];}return db[_0x34bc('0x2d')][_0x34bc('0x33')]({'where':{'id':_0x357c4c[_0x34bc('0x95')]['id']}})[_0x34bc('0x26')](handleEntityNotFound(_0x553355,null))[_0x34bc('0x26')](function(_0x43c4d8){if(_0x43c4d8){return _0x43c4d8['setTags'](_0x357c4c[_0x34bc('0x9c')]['ids']||[]);}return null;})['then'](respondWithResult(_0x553355,null))[_0x34bc('0x93')](handleError(_0x553355,null));};exports['setAdditionalPhones']=function(_0x1e8fa2,_0x5b9a25){var _0x4e3022=[];_0x4e3022[_0x34bc('0x31')](addAdditionalPhones(_0x1e8fa2['body']));Promise[_0x34bc('0x35')](_0x4e3022)[_0x34bc('0x26')](function(){_0x4e3022=[];_0x4e3022['push'](deleteCmHopperPhones(_0x1e8fa2[_0x34bc('0x9c')]['id']));_0x4e3022[_0x34bc('0x31')](addCmHopperPhones(_0x1e8fa2[_0x34bc('0x9c')]['id']));Promise[_0x34bc('0x35')](_0x4e3022)[_0x34bc('0x26')](function(){return[0x1];})[_0x34bc('0x26')](respondWithResult(_0x5b9a25,null));});};function addAdditionalPhones(_0x2244c6){return new Promise(function(_0x23542f,_0x361d7e){return db[_0x34bc('0xae')][_0x34bc('0x27')]({'where':{'CmContactId':_0x2244c6['id']}})[_0x34bc('0x26')](function(){var _0x20d435=[];for(var _0x493eb5=0x0;_0x493eb5<_0x2244c6[_0x34bc('0xd0')][_0x34bc('0x36')];_0x493eb5++){_0x20d435[_0x34bc('0x31')](addAdditionalPhone(_0x2244c6['id'],_0x2244c6[_0x34bc('0xd0')][_0x493eb5][_0x34bc('0xcb')],_0x2244c6[_0x34bc('0xd1')][_0x493eb5]===_0x34bc('0xd2')?null:_0x2244c6['item_types'][_0x493eb5],_0x493eb5));}Promise[_0x34bc('0x35')](_0x20d435)[_0x34bc('0x26')](function(){_0x23542f(0x1);});});});}function addAdditionalPhone(_0xa667dc,_0xde06c5,_0x333aa5,_0x51c712){return db['CmContactHasItem']['find']({'where':{'CmContactId':_0xa667dc,'item':_0xde06c5}})[_0x34bc('0x26')](function(_0x1497a2){if(_0x1497a2)logger['info'](_0x34bc('0xd3'),_0x1497a2);else{db['CmContactHasItem'][_0x34bc('0xa5')]({'CmContactId':_0xa667dc,'item':_0xde06c5,'ItemTypeId':_0x333aa5,'OrderBy':_0x51c712,'ItemClass':'PHONE'});}});}function deletePhones(_0x4e53a3){return db['CmContactHasItem'][_0x34bc('0x27')]({'where':{'CmContactId':_0x4e53a3}});}function deleteCmHopperPhones(_0x4566d5){return new Promise(function(_0x1a1cf8,_0x44f16d){return db[_0x34bc('0xa1')][_0x34bc('0x99')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x4566d5}})['then'](function(_0x33b39f){db[_0x34bc('0xd4')][_0x34bc('0x27')]({'where':{'CmHopperId':{'$in':_[_0x34bc('0x60')](_0x33b39f,'id')}}});})[_0x34bc('0x26')](function(){_0x1a1cf8(0x1);});});}function addCmHopperPhones(_0x329907){return new Promise(function(_0x4e2cbb,_0x3622c2){return db[_0x34bc('0xa1')][_0x34bc('0x99')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x329907}})[_0x34bc('0x26')](function(_0x3a58bf){var _0x411711=[];_[_0x34bc('0x60')](_0x3a58bf,function(_0x164a6e){_0x411711[_0x34bc('0x31')](createCmHopperPhone(_0x329907,_0x164a6e['id']));});Promise[_0x34bc('0x35')](_0x411711)['then'](function(){_0x4e2cbb(0x1);});});});}function createCmHopperPhone(_0x5379fa,_0x4339b9){return new Promise(function(_0x4604aa,_0x1a0926){db['CmContactHasItem'][_0x34bc('0x99')]({'raw':!![],'attributes':['item'],'where':{'CmContactId':_0x5379fa,'ItemClass':_0x34bc('0xd5')},'include':[{'model':db[_0x34bc('0xd6')],'attributes':[_0x34bc('0xd7')],'as':_0x34bc('0xc1')}],'order':[db['sequelize'][_0x34bc('0xc3')]('`ItemType`.OrderBy')]})[_0x34bc('0x26')](function(_0xbf34b1){var _0x5e8034=_[_0x34bc('0x60')](_0xbf34b1,function(_0x2263a3){_0x2263a3['CmHopperId']=_0x4339b9;_0x2263a3['phone']=_0x2263a3[_0x34bc('0xd8')];_0x2263a3[_0x34bc('0xd7')]=_0x2263a3['ItemType.OrderBy'];delete _0x2263a3['ItemType.OrderBy'];return _0x2263a3;});return db[_0x34bc('0xd4')][_0x34bc('0xb9')](_0x5e8034,{});})[_0x34bc('0x26')](function(){_0x4604aa(0x1);});});}exports['getAdditionalPhones']=function(_0x16458f,_0x40b723){return db['CmContactHasItem'][_0x34bc('0x99')]({'raw':!![],'where':{'CmContactId':_0x16458f['params']['id'],'ItemClass':_0x34bc('0xd5')},'include':[{'model':db[_0x34bc('0xd6')],'as':_0x34bc('0xc1')}],'order':[db[_0x34bc('0xc2')][_0x34bc('0xc3')](_0x34bc('0xd9'))]})['then'](function(_0x545578){return _0x545578;})[_0x34bc('0x26')](respondWithResult(_0x40b723,null))['catch'](handleError(_0x40b723,null));};exports[_0x34bc('0xda')]=function(_0x183f20,_0x47ffa7){return db[_0x34bc('0xae')][_0x34bc('0x99')]({'raw':!![],'where':{'CmContactId':_0x183f20[_0x34bc('0x9c')][_0x34bc('0xdb')]}})[_0x34bc('0x26')](function(_0x4b52dc){var _0x235700=_[_0x34bc('0x60')](_0x4b52dc,function(_0x179229){_0x179229[_0x34bc('0xdc')]=_0x183f20[_0x34bc('0x9c')][_0x34bc('0xdd')];return _0x179229;});return db[_0x34bc('0xae')]['bulkCreate'](_0x235700,{});})[_0x34bc('0x26')](function(_0x40b3ce){return addCmHopperPhones(_0x183f20[_0x34bc('0x9c')][_0x34bc('0xdd')]);})[_0x34bc('0x26')](function(_0x23fd84){return['ok'];})['then'](respondWithResult(_0x47ffa7,null))[_0x34bc('0x93')](handleError(_0x47ffa7,null));};exports[_0x34bc('0xde')]=function(_0x19bf93,_0x16c056){var _0x4d48c0=[];_0x4d48c0[_0x34bc('0x31')](createCmHopperPhone(_0x19bf93['body']['id'],_0x19bf93[_0x34bc('0x9c')][_0x34bc('0xdf')]));Promise[_0x34bc('0x35')](_0x4d48c0)[_0x34bc('0x26')](function(){return[0x1];})[_0x34bc('0x26')](respondWithResult(_0x16c056,null));};exports[_0x34bc('0xe0')]=function(_0x20ec72,_0x4a9ad1,_0x522c6d){var _0x4587b7={'raw':![],'where':{}};var _0x26c245={};var _0x1a4c77={'count':0x0,'rows':[]};return db[_0x34bc('0x2d')][_0x34bc('0x33')]({'where':{'id':_0x20ec72[_0x34bc('0x95')]['id']}})['then'](handleEntityNotFound(_0x4a9ad1,null))[_0x34bc('0x26')](function(_0x10b53a){if(_0x10b53a){_0x26c245['model']=_[_0x34bc('0x2f')](db[_0x34bc('0xa1')]['rawAttributes']);_0x26c245['query']=_[_0x34bc('0x2f')](_0x20ec72[_0x34bc('0x3a')]);_0x26c245[_0x34bc('0x3b')]=_[_0x34bc('0x3c')](_0x26c245[_0x34bc('0x39')],_0x26c245[_0x34bc('0x3a')]);_0x4587b7[_0x34bc('0x3d')]=_[_0x34bc('0x3c')](_0x26c245[_0x34bc('0x39')],qs[_0x34bc('0x3e')](_0x20ec72[_0x34bc('0x3a')]['fields']));_0x4587b7[_0x34bc('0x3d')]=_0x4587b7[_0x34bc('0x3d')][_0x34bc('0x36')]?_0x4587b7[_0x34bc('0x3d')]:_0x26c245[_0x34bc('0x39')];if(!_0x20ec72[_0x34bc('0x3a')]['hasOwnProperty'](_0x34bc('0x40'))){_0x4587b7['limit']=qs[_0x34bc('0x41')](_0x20ec72['query']['limit']);_0x4587b7[_0x34bc('0x1f')]=qs[_0x34bc('0x1f')](_0x20ec72[_0x34bc('0x3a')]['offset']);}_0x4587b7[_0x34bc('0x42')]=qs['sort'](_0x20ec72[_0x34bc('0x3a')]['sort']);_0x4587b7[_0x34bc('0x43')]=qs[_0x34bc('0x3b')](_[_0x34bc('0x44')](_0x20ec72['query'],_0x26c245['filters']));_0x4587b7[_0x34bc('0x43')]['ContactId']=_0x10b53a['id'];if(_0x20ec72['query'][_0x34bc('0x61')]){_0x4587b7[_0x34bc('0x43')]=_[_0x34bc('0x85')](_0x4587b7[_0x34bc('0x43')],{'$or':_[_0x34bc('0x60')](_0x4587b7[_0x34bc('0x3d')],function(_0x128104){var _0x4ba6e3={};_0x4ba6e3[_0x128104]={'$like':'%'+_0x20ec72['query'][_0x34bc('0x61')]+'%'};return _0x4ba6e3;})});}_0x4587b7=_[_0x34bc('0x85')]({},_0x4587b7,_0x20ec72['options']);return db[_0x34bc('0xa1')]['count']({'where':_0x4587b7[_0x34bc('0x43')]})[_0x34bc('0x26')](function(_0x37d0bd){_0x1a4c77[_0x34bc('0x83')]=_0x37d0bd;if(_0x20ec72[_0x34bc('0x3a')][_0x34bc('0xe1')]){_0x4587b7['include']=[{'all':!![]}];}return db['CmHopper'][_0x34bc('0x99')](_0x4587b7);})[_0x34bc('0x26')](function(_0x1ae016){_0x1a4c77['rows']=_0x1ae016;return _0x1a4c77;});}})['then'](respondWithFilteredResult(_0x4a9ad1,_0x4587b7))[_0x34bc('0x93')](handleError(_0x4a9ad1,null));};exports['getHopperHistories']=function(_0x5b3bcb,_0x46c999,_0x1e057e){var _0x31db08={'raw':!![],'where':{}};var _0x32750b={};var _0x2070d6={'count':0x0,'rows':[]};return db[_0x34bc('0x2d')][_0x34bc('0x33')]({'where':{'id':_0x5b3bcb['params']['id']}})[_0x34bc('0x26')](handleEntityNotFound(_0x46c999,null))['then'](function(_0x32df09){if(_0x32df09){_0x32750b[_0x34bc('0x39')]=_['keys'](db[_0x34bc('0xe2')]['rawAttributes']);_0x32750b[_0x34bc('0x3a')]=_['keys'](_0x5b3bcb['query']);_0x32750b[_0x34bc('0x3b')]=_[_0x34bc('0x3c')](_0x32750b['model'],_0x32750b['query']);_0x31db08[_0x34bc('0x3d')]=_['intersection'](_0x32750b['model'],qs[_0x34bc('0x3e')](_0x5b3bcb[_0x34bc('0x3a')][_0x34bc('0x3e')]));_0x31db08['attributes']=_0x31db08[_0x34bc('0x3d')][_0x34bc('0x36')]?_0x31db08['attributes']:_0x32750b[_0x34bc('0x39')];if(!_0x5b3bcb[_0x34bc('0x3a')]['hasOwnProperty'](_0x34bc('0x40'))){_0x31db08['limit']=qs[_0x34bc('0x41')](_0x5b3bcb[_0x34bc('0x3a')]['limit']);_0x31db08['offset']=qs[_0x34bc('0x1f')](_0x5b3bcb['query'][_0x34bc('0x1f')]);}_0x31db08[_0x34bc('0x42')]=qs['sort'](_0x5b3bcb[_0x34bc('0x3a')][_0x34bc('0xce')]);_0x31db08[_0x34bc('0x43')]=qs['filters'](_[_0x34bc('0x44')](_0x5b3bcb[_0x34bc('0x3a')],_0x32750b[_0x34bc('0x3b')]));_0x31db08[_0x34bc('0x43')][_0x34bc('0xe3')]=_0x32df09['id'];if(_0x5b3bcb[_0x34bc('0x3a')][_0x34bc('0x61')]){_0x31db08[_0x34bc('0x43')]=_[_0x34bc('0x85')](_0x31db08['where'],{'$or':_[_0x34bc('0x60')](_0x31db08[_0x34bc('0x3d')],function(_0x33b390){var _0x29332b={};_0x29332b[_0x33b390]={'$like':'%'+_0x5b3bcb[_0x34bc('0x3a')][_0x34bc('0x61')]+'%'};return _0x29332b;})});}_0x31db08=_[_0x34bc('0x85')]({},_0x31db08,_0x5b3bcb[_0x34bc('0xe4')]);return db[_0x34bc('0xe2')][_0x34bc('0x83')]({'where':_0x31db08['where']})['then'](function(_0x588c14){_0x2070d6[_0x34bc('0x83')]=_0x588c14;if(_0x5b3bcb[_0x34bc('0x3a')][_0x34bc('0xe1')]){_0x31db08[_0x34bc('0xe5')]=[{'all':!![]}];}return db[_0x34bc('0xe2')][_0x34bc('0x99')](_0x31db08);})[_0x34bc('0x26')](function(_0x332229){_0x2070d6[_0x34bc('0xe6')]=_0x332229;return _0x2070d6;});}})['then'](respondWithFilteredResult(_0x46c999,_0x31db08))[_0x34bc('0x93')](handleError(_0x46c999,null));};exports[_0x34bc('0xe7')]=function(_0x3edefb,_0x2fb10d,_0x534db9){var _0x583111={'raw':!![],'where':{}};var _0x2aae4c={};var _0x2155b2={'count':0x0,'rows':[]};return db[_0x34bc('0x2d')][_0x34bc('0x33')]({'where':{'id':_0x3edefb[_0x34bc('0x95')]['id']}})[_0x34bc('0x26')](handleEntityNotFound(_0x2fb10d,null))['then'](function(_0xa7a017){if(_0xa7a017){_0x2aae4c['model']=_[_0x34bc('0x2f')](db[_0x34bc('0xaf')][_0x34bc('0xcd')]);_0x2aae4c['query']=_[_0x34bc('0x2f')](_0x3edefb[_0x34bc('0x3a')]);_0x2aae4c[_0x34bc('0x3b')]=_[_0x34bc('0x3c')](_0x2aae4c[_0x34bc('0x39')],_0x2aae4c['query']);_0x583111[_0x34bc('0x3d')]=_[_0x34bc('0x3c')](_0x2aae4c[_0x34bc('0x39')],qs[_0x34bc('0x3e')](_0x3edefb[_0x34bc('0x3a')][_0x34bc('0x3e')]));_0x583111[_0x34bc('0x3d')]=_0x583111[_0x34bc('0x3d')][_0x34bc('0x36')]?_0x583111[_0x34bc('0x3d')]:_0x2aae4c['model'];if(!_0x3edefb[_0x34bc('0x3a')][_0x34bc('0x3f')]('nolimit')){_0x583111[_0x34bc('0x41')]=qs[_0x34bc('0x41')](_0x3edefb[_0x34bc('0x3a')][_0x34bc('0x41')]);_0x583111[_0x34bc('0x1f')]=qs[_0x34bc('0x1f')](_0x3edefb[_0x34bc('0x3a')]['offset']);}_0x583111[_0x34bc('0x42')]=qs[_0x34bc('0xce')](_0x3edefb[_0x34bc('0x3a')][_0x34bc('0xce')]);_0x583111[_0x34bc('0x43')]=qs[_0x34bc('0x3b')](_[_0x34bc('0x44')](_0x3edefb[_0x34bc('0x3a')],_0x2aae4c['filters']));_0x583111[_0x34bc('0x43')][_0x34bc('0xe3')]=_0xa7a017['id'];if(_0x3edefb[_0x34bc('0x3a')][_0x34bc('0x61')]){_0x583111[_0x34bc('0x43')]=_['merge'](_0x583111[_0x34bc('0x43')],{'$or':_[_0x34bc('0x60')](_0x583111[_0x34bc('0x3d')],function(_0x22f242){var _0x5a1893={};_0x5a1893[_0x22f242]={'$like':'%'+_0x3edefb[_0x34bc('0x3a')][_0x34bc('0x61')]+'%'};return _0x5a1893;})});}_0x583111=_[_0x34bc('0x85')]({},_0x583111,_0x3edefb[_0x34bc('0xe4')]);return db[_0x34bc('0xaf')][_0x34bc('0x83')]({'where':_0x583111['where']})['then'](function(_0x120339){_0x2155b2[_0x34bc('0x83')]=_0x120339;if(_0x3edefb[_0x34bc('0x3a')][_0x34bc('0xe1')]){_0x583111['include']=[{'all':!![]}];}return db[_0x34bc('0xaf')][_0x34bc('0x99')](_0x583111);})[_0x34bc('0x26')](function(_0x15cac4){_0x2155b2['rows']=_0x15cac4;return _0x2155b2;});}})['then'](respondWithFilteredResult(_0x2fb10d,_0x583111))[_0x34bc('0x93')](handleError(_0x2fb10d,null));};exports[_0x34bc('0xe8')]=function(_0x2a8310,_0x1cffc8,_0x508728){var _0xce3ce1={'raw':!![],'where':{}};var _0x49cca6={};var _0x1ffc65={'count':0x0,'rows':[]};return db[_0x34bc('0x2d')][_0x34bc('0x33')]({'where':{'id':_0x2a8310['params']['id']}})[_0x34bc('0x26')](handleEntityNotFound(_0x1cffc8,null))[_0x34bc('0x26')](function(_0x9b5394){if(_0x9b5394){_0x49cca6[_0x34bc('0x39')]=_[_0x34bc('0x2f')](db[_0x34bc('0xb5')][_0x34bc('0xcd')]);_0x49cca6['query']=_['keys'](_0x2a8310[_0x34bc('0x3a')]);_0x49cca6[_0x34bc('0x3b')]=_[_0x34bc('0x3c')](_0x49cca6[_0x34bc('0x39')],_0x49cca6['query']);_0xce3ce1[_0x34bc('0x3d')]=_[_0x34bc('0x3c')](_0x49cca6[_0x34bc('0x39')],qs[_0x34bc('0x3e')](_0x2a8310[_0x34bc('0x3a')][_0x34bc('0x3e')]));_0xce3ce1['attributes']=_0xce3ce1[_0x34bc('0x3d')][_0x34bc('0x36')]?_0xce3ce1[_0x34bc('0x3d')]:_0x49cca6[_0x34bc('0x39')];if(!_0x2a8310[_0x34bc('0x3a')][_0x34bc('0x3f')](_0x34bc('0x40'))){_0xce3ce1[_0x34bc('0x41')]=qs[_0x34bc('0x41')](_0x2a8310[_0x34bc('0x3a')][_0x34bc('0x41')]);_0xce3ce1[_0x34bc('0x1f')]=qs[_0x34bc('0x1f')](_0x2a8310[_0x34bc('0x3a')][_0x34bc('0x1f')]);}_0xce3ce1[_0x34bc('0x42')]=qs[_0x34bc('0xce')](_0x2a8310['query'][_0x34bc('0xce')]);_0xce3ce1[_0x34bc('0x43')]=qs['filters'](_[_0x34bc('0x44')](_0x2a8310[_0x34bc('0x3a')],_0x49cca6[_0x34bc('0x3b')]));_0xce3ce1[_0x34bc('0x43')][_0x34bc('0xe3')]=_0x9b5394['id'];if(_0x2a8310['query'][_0x34bc('0x61')]){_0xce3ce1[_0x34bc('0x43')]=_[_0x34bc('0x85')](_0xce3ce1[_0x34bc('0x43')],{'$or':_[_0x34bc('0x60')](_0xce3ce1[_0x34bc('0x3d')],function(_0x2d280c){var _0x4b8496={};_0x4b8496[_0x2d280c]={'$like':'%'+_0x2a8310[_0x34bc('0x3a')][_0x34bc('0x61')]+'%'};return _0x4b8496;})});}_0xce3ce1=_[_0x34bc('0x85')]({},_0xce3ce1,_0x2a8310[_0x34bc('0xe4')]);return db[_0x34bc('0xb5')]['count']({'where':_0xce3ce1[_0x34bc('0x43')]})[_0x34bc('0x26')](function(_0xace405){_0x1ffc65['count']=_0xace405;if(_0x2a8310[_0x34bc('0x3a')]['includeAll']){_0xce3ce1[_0x34bc('0xe5')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0x34bc('0x99')](_0xce3ce1);})[_0x34bc('0x26')](function(_0x472306){_0x1ffc65[_0x34bc('0xe6')]=_0x472306;return _0x1ffc65;});}})[_0x34bc('0x26')](respondWithFilteredResult(_0x1cffc8,_0xce3ce1))[_0x34bc('0x93')](handleError(_0x1cffc8,null));};exports[_0x34bc('0xe9')]=function(_0x2e8fb6,_0x352b09,_0x5e13fe){try{if(!_0x2e8fb6[_0x34bc('0x9c')][_0x34bc('0x64')]){throw new Error(_0x34bc('0xea'));}if(!_0x2e8fb6[_0x34bc('0x9c')][_0x34bc('0xeb')]){throw new Error(_0x34bc('0xec'));}if(!_0x2e8fb6[_0x34bc('0x9c')][_0x34bc('0xed')]){throw new Error(_0x34bc('0xee'));}if(!_0x2e8fb6[_0x34bc('0x9c')][_0x34bc('0xef')]){throw new Error(_0x34bc('0xf0'));}var _0x5e7780=_0x2e8fb6[_0x34bc('0x9c')][_0x34bc('0xeb')][_0x34bc('0x56')](',');var _0x33c515=_0x2e8fb6[_0x34bc('0x9c')][_0x34bc('0xed')][_0x34bc('0x56')](',');if(!_0x5e7780[_0x34bc('0x36')]||!_0x33c515[_0x34bc('0x36')]||_0x5e7780['length']!==_0x33c515[_0x34bc('0x36')]){throw new Error(_0x34bc('0xf1'));}_0x2e8fb6[_0x34bc('0x9c')][_0x34bc('0x3e')]=_['zipObject'](_0x5e7780,_0x33c515);if(!_0x2e8fb6[_0x34bc('0x9c')][_0x34bc('0x3e')][_0x34bc('0xcb')]){throw new Error(_0x34bc('0xf2'));}if(!_0x2e8fb6[_0x34bc('0x9c')][_0x34bc('0x3e')][_0x34bc('0xf3')]){throw new Error(_0x34bc('0xf4'));}var _0x56e9cc=path['join'](config['root'],'server/files/tmp',_0x2e8fb6[_0x34bc('0xf5')][_0x34bc('0xf6')]);fs[_0x34bc('0xf7')](_0x56e9cc,parseInt(_0x34bc('0xf8'),0x8));var _0x109f7d=require(_0x34bc('0xf9'))[_0x34bc('0xfa')](path[_0x34bc('0xb8')](__dirname,_0x34bc('0xfb')),[_0x56e9cc,_0x2e8fb6['body'][_0x34bc('0xeb')],_0x2e8fb6['body'][_0x34bc('0xed')],_0x2e8fb6['body'][_0x34bc('0x64')],_0x2e8fb6[_0x34bc('0x9c')]['CompanyId'],_0x2e8fb6[_0x34bc('0x9c')][_0x34bc('0xbb')],_0x2e8fb6[_0x34bc('0x9c')]['socket_timestamp']]);return _0x352b09[_0x34bc('0x1d')](0xc8)[_0x34bc('0x22')]({'message':_0x34bc('0xfc'),'pid':_0x109f7d[_0x34bc('0xfd')]});}catch(_0x3b3959){return _0x352b09[_0x34bc('0x1d')](0x1f4)[_0x34bc('0x2b')](_0x3b3959);}};exports[_0x34bc('0xfe')]=function(_0x1ddd33,_0x440f67,_0x318956){var _0x361166=fs[_0x34bc('0xff')](_0x1ddd33[_0x34bc('0xf5')][_0x34bc('0x8')]);Papa[_0x34bc('0x100')](_0x361166,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x310085){return _0x440f67[_0x34bc('0x1d')](0xc8)['json']({'file':_0x1ddd33[_0x34bc('0xf5')],'fields':_0x310085[_0x34bc('0x101')]['fields']});}});};exports['import']=function(_0x2e49ac,_0x12d882,_0xf9d11){return db[_0x34bc('0x80')][_0x34bc('0x99')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})['then'](function(_0x1aa497){var _0x1eb34d=![];if(!_0x2e49ac[_0x34bc('0x9c')][_0x34bc('0x64')]){throw new Error('No\x20ListId\x20specified');}if(!_0x2e49ac[_0x34bc('0x9c')][_0x34bc('0x102')][_0x34bc('0xcb')]){throw new Error(_0x34bc('0xf2'));}if(!_0x2e49ac[_0x34bc('0x9c')][_0x34bc('0x102')][_0x34bc('0xf3')]){throw new Error(_0x34bc('0xf4'));}if(!_0x2e49ac[_0x34bc('0x9c')][_0x34bc('0xef')]){throw new Error(_0x34bc('0xf0'));}var _0x4776a7=require('child_process')['fork'](path[_0x34bc('0xb8')](__dirname,'../../components/import/cm/csv2'),[_0x2e49ac['params']['id'],JSON[_0x34bc('0x103')](_0x2e49ac[_0x34bc('0x9c')]),JSON[_0x34bc('0x103')](_0x1aa497)]);_0x4776a7['on'](_0x34bc('0x104'),function(_0xefbb67){_0x1eb34d=!![];return _0x12d882['status'](0xc8)[_0x34bc('0x22')]({'message':_0x34bc('0x105'),'pid':_0x4776a7[_0x34bc('0xfd')]});});_0x4776a7['on'](_0x34bc('0x106'),function(_0xc04b57){if(_0xc04b57&&!_0x1eb34d){return _0x12d882[_0x34bc('0x1d')](0x1f4)[_0x34bc('0x22')]({'message':_0x34bc('0x107'),'pid':_0x4776a7[_0x34bc('0xfd')]});}});})[_0x34bc('0x93')](handleError(_0x12d882,null));};exports[_0x34bc('0x108')]=function(_0x2ec84f,_0x336110,_0x4d2097){return db[_0x34bc('0x80')][_0x34bc('0x99')]({'raw':!![],'attributes':['id'],'where':{'role':_0x34bc('0x7e')}})[_0x34bc('0x26')](function(_0x53cb6f){var _0x567c6f=![];if(!_0x2ec84f['body'][_0x34bc('0x64')]){throw new Error(_0x34bc('0xea'));}if(!_0x2ec84f[_0x34bc('0x9c')][_0x34bc('0x102')][_0x34bc('0xcb')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x2ec84f[_0x34bc('0x9c')][_0x34bc('0x102')][_0x34bc('0xf3')]){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x2ec84f['body'][_0x34bc('0xef')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0xf7aef2=require('child_process')[_0x34bc('0xfa')](path['join'](__dirname,'../../components/import/cm/csvUpdates'),[_0x2ec84f[_0x34bc('0x95')]['id'],JSON[_0x34bc('0x103')](_0x2ec84f[_0x34bc('0x9c')]),JSON[_0x34bc('0x103')](_0x53cb6f)]);_0xf7aef2['on']('message',function(_0x1e4ee5){_0x567c6f=!![];return _0x336110['status'](0xc8)['json']({'message':'start\x20child\x20process\x20correctly!','pid':_0xf7aef2[_0x34bc('0xfd')]});});_0xf7aef2['on'](_0x34bc('0x106'),function(_0x30c161){if(_0x30c161&&!_0x567c6f){return _0x336110['status'](0x1f4)[_0x34bc('0x22')]({'message':'error\x20child\x20process','pid':_0xf7aef2[_0x34bc('0xfd')]});}});})[_0x34bc('0x93')](handleError(_0x336110,null));};exports['getJourney']=function(_0x5eb024,_0x1e75a1){var _0x46456f=[_0x34bc('0x109'),_0x34bc('0x10a'),'sms',_0x34bc('0x10b'),_0x34bc('0x10c'),_0x34bc('0x10d'),_0x34bc('0x10e')];var _0x6d29de={'offset':0x0,'order':qs[_0x34bc('0xce')](_0x34bc('0x10f'))},_0x2c5389={'count':0x0,'rows':[]};Promise[_0x34bc('0x7b')]()[_0x34bc('0x26')](function(){if(_0x5eb024['query'][_0x34bc('0x110')]){if(!_[_0x34bc('0x111')](_0x46456f,_0x5eb024[_0x34bc('0x3a')][_0x34bc('0x110')]['toLowerCase']())){throw new Error(_0x34bc('0x112'));}_0x46456f=[_0x5eb024[_0x34bc('0x3a')][_0x34bc('0x110')][_0x34bc('0x113')]()];}if(_0x5eb024[_0x34bc('0x3a')][_0x34bc('0x114')]){try{var _0x515c75=JSON[_0x34bc('0x100')](_0x5eb024['query'][_0x34bc('0x114')]);if(!moment(_0x515c75[_0x34bc('0x47')])[_0x34bc('0x115')]()){throw new Error('Invalid\x20date\x20for\x20range\x20from\x20filter');}if(!moment(_0x515c75['to'])[_0x34bc('0x115')]()){throw new Error(_0x34bc('0x116'));}}catch(_0xedf340){throw new Error(_0x34bc('0x117'));}}if(!_0x5eb024[_0x34bc('0x3a')][_0x34bc('0x3f')]('nolimit')){_0x6d29de[_0x34bc('0x41')]=qs[_0x34bc('0x41')](_0x5eb024[_0x34bc('0x3a')][_0x34bc('0x41')]||0xa);_0x6d29de[_0x34bc('0x1f')]=qs[_0x34bc('0x1f')](_0x5eb024[_0x34bc('0x3a')][_0x34bc('0x1f')]);}var _0x3febee=_0x46456f[_0x34bc('0x60')](function(_0x2f4378){if(_0x2f4378===_0x34bc('0x10e')){var _0x2f61f0={'attributes':['id',_0x34bc('0x118'),_0x34bc('0x38'),_0x34bc('0x119'),'destination','callerid',_0x34bc('0x11a'),'endtime',_0x34bc('0x11b'),'note',_0x34bc('0x11c'),_0x34bc('0x11d'),'userSecondDisposition',_0x34bc('0x11e'),_0x34bc('0x11f')],'where':{'ContactId':_0x5eb024[_0x34bc('0x95')]['id']},'include':[{'model':db[_0x34bc('0x80')],'as':'User','attributes':['id','name',_0x34bc('0x120'),_0x34bc('0x9a')]}],'order':[['createdAt',_0x34bc('0x121')]]};if(_0x5eb024['query'][_0x34bc('0x114')]){_0x2f61f0[_0x34bc('0x43')][_0x34bc('0x11c')]={'$gte':_0x515c75['from'],'$lte':_0x515c75['to']};}return db[_0x34bc('0x122')][_0x34bc('0x123')](_0x2f61f0)[_0x34bc('0x26')](function(_0x30be37){_0x2c5389[_0x34bc('0x83')]+=_0x30be37[_0x34bc('0x83')];return _[_0x34bc('0x60')](_0x30be37['rows'],function(_0x3b8379){var _0x138923=_0x3b8379[_0x34bc('0x9d')]({'plain':!![]});_0x138923['channel']=_0x2f4378;if(_0x138923[_0x34bc('0x80')]){_0x138923[_0x34bc('0x80')]={'id':_0x138923['User']['id'],'name':_0x138923[_0x34bc('0x80')][_0x34bc('0x2a')],'fullname':_0x138923['User'][_0x34bc('0x120')],'alias':_0x138923[_0x34bc('0x80')][_0x34bc('0x9a')]};}return _0x138923;});});}else{var _0x18f882=_['startCase'](_0x2f4378)+(_0x2f4378==='chat'?_0x34bc('0x124'):_0x34bc('0x125'));var _0x5cb344={'attributes':['id',_0x34bc('0x126'),_0x34bc('0x127'),_0x34bc('0x11c'),_0x34bc('0x128'),_0x34bc('0x129'),_0x34bc('0x12a'),_0x34bc('0x12b'),'UserId',_0x18f882+'Id'],'where':{'ContactId':_0x5eb024[_0x34bc('0x95')]['id']},'include':[{'model':db[_0x18f882],'as':'Account','attributes':['id',_0x34bc('0x2a'),_0x34bc('0x12c')]},{'model':db[_0x34bc('0x80')],'as':_0x34bc('0x12d'),'attributes':['id','name',_0x34bc('0x120')]},{'model':db['Tag'],'as':_0x34bc('0x92'),'attributes':['id',_0x34bc('0x2a'),_0x34bc('0x46')],'through':{'attributes':[]}}],'order':[[_0x34bc('0x11c'),_0x34bc('0x121')]]};if(_0x5eb024[_0x34bc('0x3a')]['range']){_0x5cb344[_0x34bc('0x43')][_0x34bc('0x11c')]={'$gte':_0x515c75['from'],'$lte':_0x515c75['to']};}switch(_0x2f4378){case _0x34bc('0x10a'):_0x5cb344[_0x34bc('0x3d')]['push'](_0x34bc('0x12e'),_0x34bc('0x12f'),_0x34bc('0x130'),_0x34bc('0x131'),_0x34bc('0x132'),_0x34bc('0x133'),_0x34bc('0x134'),'ratingValue','referer');break;case _0x34bc('0x109'):_0x5cb344[_0x34bc('0x3d')][_0x34bc('0x31')](_0x34bc('0x135'),_0x34bc('0x136'));break;case'openchannel':_0x5cb344[_0x34bc('0x3d')][_0x34bc('0x31')](_0x34bc('0x137'),_0x34bc('0x138'));break;}return db[_['startCase'](_0x2f4378)+_0x34bc('0x139')][_0x34bc('0x123')](_0x5cb344)[_0x34bc('0x26')](function(_0x542d41){_0x2c5389[_0x34bc('0x83')]+=_0x542d41[_0x34bc('0x83')];return _[_0x34bc('0x60')](_0x542d41[_0x34bc('0xe6')],function(_0x1fbca2){var _0x42ba3c=_0x1fbca2[_0x34bc('0x9d')]({'plain':!![]});_0x42ba3c[_0x34bc('0x110')]=_0x2f4378;if(_0x42ba3c[_0x34bc('0x12d')]){_0x42ba3c[_0x34bc('0x12d')]={'id':_0x42ba3c[_0x34bc('0x12d')]['id'],'name':_0x42ba3c[_0x34bc('0x12d')][_0x34bc('0x2a')],'fullname':_0x42ba3c[_0x34bc('0x12d')][_0x34bc('0x120')]};}return _0x42ba3c;});});}});return Promise['all'](_0x3febee);})[_0x34bc('0x26')](function(_0xcf972b){return _(_0xcf972b)[_0x34bc('0x13a')]()[_0x34bc('0x13b')]('createdAt')['reverse']()[_0x34bc('0x55')]();})[_0x34bc('0x26')](function(_0x1812ee){_0x2c5389[_0x34bc('0xe6')]=_0x6d29de[_0x34bc('0x41')]?_0x1812ee['slice'](_0x6d29de[_0x34bc('0x1f')],_0x6d29de[_0x34bc('0x1f')]+_0x6d29de[_0x34bc('0x41')]):_0x1812ee;return _0x2c5389;})['then'](respondWithFilteredResult(_0x1e75a1,_0x6d29de))[_0x34bc('0x93')](handleError(_0x1e75a1,null));};
\ No newline at end of file
+var _0xc997=['all','items','undefined','item_types','contact\x20phone\x20exists','PHONE','CmHopper','CmHopperAdditionalPhone','item','OrderBy','CmHopperId','ItemType.OrderBy','getAdditionalPhones','`ItemType`.OrderBy','CmContactId','toContactId','hopperId','getHoppers','ContactId','includeAll','getHopperHistories','include','getHopperFinals','getJscriptySessions','JscriptySessionReport','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','socket_timestamp','Incorrect\x20binding\x20parameters\x20passed!','firstName','No\x20firstName\x20column\x20specified','file','filename','chmodSync','0777','fork','../../components/import/cm/csv','CompanyId','json','pid','createReadStream','parse','import','No\x20phone\x20column\x20specified','child_process','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','error\x20child\x20process','importUpdates','binding','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','getJourney','mail','openchannel','fax','whatsapp','voice','channel','includes','toLowerCase','Invalid\x20channel','range','isValid','Invalid\x20date\x20for\x20range\x20to\x20filter','uniqueid','source','destination','endtime','duration','note','createdAt','userDisposition','userSecondDisposition','userThirdDisposition','UserId','alias','fullname','startCase','chat','Website','Account','closedAt','secondDisposition','Owner','browserName','customerIp','customerPort','deviceModel','osName','ratingMessage','ratingType','ratingValue','referer','subject','substatus','externalUrl','threadId','Interaction','findAndCountAll','flatten','sortBy','slice','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','querystring','ioredis','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./cmContact.socket','register','sendStatus','status','end','count','offset','set','Content-Range','reject','save','update','then','destroy','error','name','send','index','CmContact','describe','keys','length','startsWith','cf_','push','findOne','fieldType','type','model','query','filters','intersection','fields','attributes','hasOwnProperty','nolimit','limit','order','sort','pick','select','field','color','from','tools_tags','cm_contacts','left_join','cm_user_has_contacts','uc.CmContactId\x20=\x20c.id','cm_contact_has_tags','t.id\x20=\x20ct.TagId','c.deletedAt\x20IS\x20NULL','expr','search','parseSearch','conditions','find','Tag','value','split','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','uc.UserId\x20=\x20?','dateOfBirth','castTo','buildExpression','text','start','filter','Contact','where','c.ListId\x20IN\x20?','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','isArray','replace','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?','group','c.id','QueryTypes','SELECT','clone','DESC','isEmpty','having','t.id\x20IN\x20?','resolve','user','role','agent','some','getLists','c.ListId\x20IS\x20NULL','ListId','sequelize','toString','merge','c.firstName','c.lastName','c.phone','c.fax','c.email','c.ListId','c.createdAt','c.deletedAt','c.CompanyId','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','Tags','rows','tags','columnName','displayName','CmCustomField','findAll','custom','values','catch','body','get','join','[CmContact][merge]\x20to\x20%s\x20from\x20%s','info','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','create','ChatInteraction','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','OpenchannelQueueReport','WhatsappInteraction','WhatsappMessage','WhatsappQueueReport','bulkCreate','duplicates','$or','findOrCreate','spread','show','CmContactHasItem','Phones','ContactItemType','ItemType','literal','$and','omit','format','cf_%d','pickBy','table','setFields','id\x20=\x20?','params','toParam','phone','getTags','rawAttributes','options','setTags','ids','setAdditionalPhones'];(function(_0x2fc012,_0x503e5b){var _0x2891f9=function(_0x295f5e){while(--_0x295f5e){_0x2fc012['push'](_0x2fc012['shift']());}};_0x2891f9(++_0x503e5b);}(_0xc997,0x1ac));var _0x7c99=function(_0x145757,_0x2d0b70){_0x145757=_0x145757-0x0;var _0x5d1255=_0xc997[_0x145757];return _0x5d1255;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x7c99('0x0'));var rimraf=require(_0x7c99('0x1'));var zipdir=require(_0x7c99('0x2'));var jsonpatch=require(_0x7c99('0x3'));var rp=require(_0x7c99('0x4'));var moment=require('moment');var BPromise=require(_0x7c99('0x5'));var Mustache=require(_0x7c99('0x6'));var util=require(_0x7c99('0x7'));var path=require(_0x7c99('0x8'));var sox=require(_0x7c99('0x9'));var csv=require(_0x7c99('0xa'));var ejs=require(_0x7c99('0xb'));var fs=require('fs');var fs_extra=require(_0x7c99('0xc'));var _=require('lodash');var squel=require(_0x7c99('0xd'));var crypto=require(_0x7c99('0xe'));var jsforce=require(_0x7c99('0xf'));var deskjs=require('desk.js');var toCsv=require(_0x7c99('0xa'));var querystring=require(_0x7c99('0x10'));var Papa=require('papaparse');var Redis=require(_0x7c99('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x7c99('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x7c99('0x13'))(_0x7c99('0x14'));var utils=require(_0x7c99('0x15'));var config=require(_0x7c99('0x16'));var licenseUtil=require(_0x7c99('0x17'));var db=require(_0x7c99('0x18'))['db'];config[_0x7c99('0x19')]=_[_0x7c99('0x1a')](config[_0x7c99('0x19')],{'host':_0x7c99('0x1b'),'port':0x18eb});var socket=require(_0x7c99('0x1c'))(new Redis(config[_0x7c99('0x19')]));require(_0x7c99('0x1d'))[_0x7c99('0x1e')](socket);function respondWithStatusCode(_0x368db4,_0x2758a4){_0x2758a4=_0x2758a4||0xcc;return function(_0x1bfc54){if(_0x1bfc54){return _0x368db4[_0x7c99('0x1f')](_0x2758a4);}return _0x368db4[_0x7c99('0x20')](_0x2758a4)[_0x7c99('0x21')]();};}function respondWithResult(_0x330aaf,_0x4ed8d9){_0x4ed8d9=_0x4ed8d9||0xc8;return function(_0x2d80d4){if(_0x2d80d4){return _0x330aaf['status'](_0x4ed8d9)['json'](_0x2d80d4);}};}function respondWithFilteredResult(_0x6bebf4,_0x133e96){return function(_0x7baa0b){if(_0x7baa0b){var _0x210669=_0x7baa0b[_0x7c99('0x22')],_0x32306b=_0x133e96[_0x7c99('0x23')],_0x246b67=_0x133e96[_0x7c99('0x23')]+_0x133e96['limit'],_0x379a43;if(_0x246b67>=_0x210669){_0x246b67=_0x210669;_0x379a43=0xc8;}else{_0x379a43=0xce;}_0x6bebf4[_0x7c99('0x20')](_0x379a43);return _0x6bebf4[_0x7c99('0x24')](_0x7c99('0x25'),_0x32306b+'-'+_0x246b67+'/'+_0x210669)['json'](_0x7baa0b);}return null;};}function patchUpdates(_0x53ec6b){return function(_0x4878ea){try{jsonpatch['apply'](_0x4878ea,_0x53ec6b,!![]);}catch(_0x598a89){return BPromise[_0x7c99('0x26')](_0x598a89);}return _0x4878ea[_0x7c99('0x27')]();};}function saveUpdates(_0x5e37d0,_0xbe266d){return function(_0x117e0b){if(_0x117e0b){return _0x117e0b[_0x7c99('0x28')](_0x5e37d0)[_0x7c99('0x29')](function(_0x5dceaf){return _0x5dceaf;});}return null;};}function removeEntity(_0x178e99,_0x3d2c44){return function(_0x43474b){if(_0x43474b){return _0x43474b[_0x7c99('0x2a')]()[_0x7c99('0x29')](function(){_0x178e99[_0x7c99('0x20')](0xcc)[_0x7c99('0x21')]();});}};}function handleEntityNotFound(_0xbd1712,_0x80857d){return function(_0xdbe0e8){if(!_0xdbe0e8){_0xbd1712[_0x7c99('0x1f')](0x194);}return _0xdbe0e8;};}function handleError(_0x35be2a,_0x57349a){_0x57349a=_0x57349a||0x1f4;return function(_0x48519c){logger[_0x7c99('0x2b')](_0x48519c['stack']);if(_0x48519c[_0x7c99('0x2c')]){delete _0x48519c[_0x7c99('0x2c')];}_0x35be2a[_0x7c99('0x20')](_0x57349a)[_0x7c99('0x2d')](_0x48519c);};}exports[_0x7c99('0x2e')]=function(_0x395494,_0x98ab97){var _0x4d084e={},_0x5e975e={},_0x58b20f={'count':0x0,'rows':[]};return db[_0x7c99('0x2f')][_0x7c99('0x30')]()[_0x7c99('0x29')](function(_0x1321cf){var _0x361c99=[];for(var _0x1f894a=0x0;_0x1f894a<Object[_0x7c99('0x31')](_0x1321cf)[_0x7c99('0x32')];_0x1f894a++){var _0x2ae2a7=Object[_0x7c99('0x31')](_0x1321cf)[_0x1f894a];if(_[_0x7c99('0x33')](_0x2ae2a7,_0x7c99('0x34'))){_0x361c99[_0x7c99('0x35')](db['CmCustomField'][_0x7c99('0x36')]({'where':{'id':_['trimStart'](_0x2ae2a7,_0x7c99('0x34'))},'raw':!![]}));}}return BPromise['all'](_0x361c99)[_0x7c99('0x29')](function(_0x3cd43e){for(var _0x5c22e2=0x0;_0x5c22e2<_0x3cd43e[_0x7c99('0x32')];_0x5c22e2++){if(_0x3cd43e[_0x5c22e2]){var _0x187681='cf_'+_0x3cd43e[_0x5c22e2]['id'];var _0x29c8a0=_0x1321cf[_0x187681];_0x29c8a0[_0x7c99('0x37')]=_0x3cd43e[_0x5c22e2][_0x7c99('0x38')];}}return _0x1321cf;});})[_0x7c99('0x29')](function(_0x3baf31){_0x5e975e[_0x7c99('0x39')]=_[_0x7c99('0x31')](_0x3baf31);_0x5e975e[_0x7c99('0x3a')]=_[_0x7c99('0x31')](_0x395494[_0x7c99('0x3a')]);_0x5e975e[_0x7c99('0x3b')]=_[_0x7c99('0x3c')](_0x5e975e[_0x7c99('0x39')],_0x5e975e['query']);_0x4d084e['attributes']=_['intersection'](_0x5e975e[_0x7c99('0x39')],qs[_0x7c99('0x3d')](_0x395494[_0x7c99('0x3a')][_0x7c99('0x3d')]));_0x4d084e[_0x7c99('0x3e')]=_0x4d084e['attributes'][_0x7c99('0x32')]?_0x4d084e['attributes']:_0x5e975e[_0x7c99('0x39')];if(!_0x395494['query'][_0x7c99('0x3f')](_0x7c99('0x40'))){_0x4d084e['limit']=qs[_0x7c99('0x41')](_0x395494[_0x7c99('0x3a')]['limit']);_0x4d084e[_0x7c99('0x23')]=qs['offset'](_0x395494[_0x7c99('0x3a')][_0x7c99('0x23')]);}_0x4d084e[_0x7c99('0x42')]=qs[_0x7c99('0x43')](_0x395494[_0x7c99('0x3a')][_0x7c99('0x43')]);_0x4d084e['where']=qs['filters'](_[_0x7c99('0x44')](_0x395494[_0x7c99('0x3a')],_0x5e975e['filters']),_0x3baf31);var _0x35c815=[];var _0x552fb3=squel[_0x7c99('0x45')]()[_0x7c99('0x46')]('id')[_0x7c99('0x46')](_0x7c99('0x2c'))[_0x7c99('0x46')](_0x7c99('0x47'))[_0x7c99('0x48')](_0x7c99('0x49'));var _0x3fb326=squel[_0x7c99('0x45')]()[_0x7c99('0x48')](_0x7c99('0x4a'),'c')[_0x7c99('0x4b')](_0x7c99('0x4c'),'uc',_0x7c99('0x4d'))['left_join'](_0x7c99('0x4e'),'ct','ct.CmContactId\x20=\x20c.id')[_0x7c99('0x4b')](_0x7c99('0x49'),'t',_0x7c99('0x4f'))['where'](_0x7c99('0x50'));var _0x206931=squel[_0x7c99('0x51')]();var _0x550623=[];var _0x2c6c11=squel[_0x7c99('0x51')]();var _0x59e246;if(_0x395494[_0x7c99('0x3a')][_0x7c99('0x52')]){_0x59e246=as[_0x7c99('0x53')](_0x395494[_0x7c99('0x3a')]['search']);var _0x3432c7=_0x59e246['sqlOperator'];for(var _0x34f14a=0x0;_0x34f14a<_0x59e246['conditions'][_0x7c99('0x32')];_0x34f14a++){var _0x4aa7fd=_0x59e246[_0x7c99('0x54')][_0x34f14a];var _0xbae110='c';var _0x1ecc3f=_(_0x3baf31)['keys']()[_0x7c99('0x55')](function(_0x2635e5){return _0x2635e5===_0x4aa7fd[_0x7c99('0x46')];});if(_0x1ecc3f)_0x1ecc3f=_0x3baf31[_0x4aa7fd[_0x7c99('0x46')]];if(!_0x1ecc3f){if(_0x4aa7fd['field']===_0x7c99('0x56')){var _0x187548=_0x4aa7fd[_0x7c99('0x57')][_0x7c99('0x58')](',')[_0x7c99('0x59')](function(_0x12e542){return Number(_0x12e542);});_0x187548[_0x7c99('0x5a')](function(_0xa3ca69){_0x2c6c11['or'](_0x7c99('0x5b'),'%,'+_0xa3ca69+',%');});_0x550623=_[_0x7c99('0x5c')](_0x550623,_0x187548);}else if(_0x4aa7fd[_0x7c99('0x46')]===_0x7c99('0x5d')){_0x206931['and'](_0x7c99('0x5e'),_0x4aa7fd[_0x7c99('0x57')]);}}else{if(_0x4aa7fd['field']===_0x7c99('0x5f')||_0x1ecc3f['fieldType']==='datetime')_0x4aa7fd[_0x7c99('0x60')]='DATE';var _0x50d8de=as[_0x7c99('0x61')](_0xbae110,_0x1ecc3f[_0x7c99('0x38')],_0x4aa7fd);_0x206931[_0x3432c7](_0x50d8de[_0x7c99('0x62')],_0x50d8de[_0x7c99('0x57')][_0x7c99('0x63')],_0x50d8de[_0x7c99('0x57')]['end']);}}}else{var _0x3329a4=_(Object[_0x7c99('0x31')](_0x395494[_0x7c99('0x3a')]))[_0x7c99('0x59')](function(_0x5ba9a9){return _0x3baf31[_0x7c99('0x3f')](_0x5ba9a9)?_0x5ba9a9:undefined;})[_0x7c99('0x64')](function(_0x3fabb6){return!_['isNil'](_0x3fabb6);})[_0x7c99('0x57')]();if(_0x395494[_0x7c99('0x3a')]['Contact'])_0x3329a4[_0x7c99('0x35')](_0x7c99('0x65'));if(!_['isEmpty'](_0x3329a4)){_0x3329a4['forEach'](function(_0xce0257){if(_0xce0257==='ListId'){_0x3fb326[_0x7c99('0x66')](_0x7c99('0x67'),[][_0x7c99('0x68')](_0x395494[_0x7c99('0x3a')][_0xce0257]));}else if(_0xce0257===_0x7c99('0x65')){var _0x55fa3d='%'+_0x395494[_0x7c99('0x3a')][_0xce0257]+'%';_0x3fb326[_0x7c99('0x66')](_0x7c99('0x69'),_0x55fa3d);}else{_0x3fb326[_0x7c99('0x66')]('c.'+_0xce0257+_0x7c99('0x6a'),_0x395494[_0x7c99('0x3a')][_0xce0257]);}});}if(_0x395494[_0x7c99('0x3a')][_0x7c99('0x6b')]){_0x550623=_[_0x7c99('0x6c')](_0x395494['query'][_0x7c99('0x6b')])?_0x395494[_0x7c99('0x3a')]['tag']:new Array(_0x395494[_0x7c99('0x3a')][_0x7c99('0x6b')]);_0x550623['forEach'](function(_0x446249){_0x2c6c11['or'](_0x7c99('0x5b'),'%,'+_0x446249+',%');});}if(_0x395494[_0x7c99('0x3a')]['filter']){var _0x3d48fa=_0x395494[_0x7c99('0x3a')][_0x7c99('0x64')][_0x7c99('0x6d')]('\x5c','\x5c\x5c')[_0x7c99('0x6d')](/'/g,'\x27\x27');if(_0x3d48fa[_0x7c99('0x58')]('\x20')['length']>0x1){_0x206931['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x7c99('0x6e')](_0x3d48fa),null);}else{if(qs['isNumeric'](_0x3d48fa)){_0x206931['or'](_0x7c99('0x6f'),_0x3d48fa+'%');_0x206931['or'](_0x7c99('0x70'),_0x3d48fa+'%');_0x206931['or'](_0x7c99('0x71'),_0x3d48fa+'%');_0x206931['or'](_0x7c99('0x72'),_0x3d48fa+'%');}else if(qs[_0x7c99('0x73')](_0x3d48fa)){_0x206931['or'](_0x7c99('0x74'),_0x3d48fa+'%');}else{_0x206931['or'](_0x7c99('0x75'),'%'+_0x3d48fa+'%');_0x206931['or']('c.lastName\x20LIKE\x20?','%'+_0x3d48fa+'%');_0x206931['or'](_0x7c99('0x74'),'%'+_0x3d48fa+'%');}}}}_0x3fb326['where'](_0x206931);_0x3fb326[_0x7c99('0x76')](_0x7c99('0x77'));var _0x31b2eb={'type':db['Sequelize'][_0x7c99('0x78')][_0x7c99('0x79')],'raw':!![]};var _0x28982e=_0x3fb326[_0x7c99('0x7a')]()[_0x7c99('0x46')](_0x7c99('0x77'));if(_0x4d084e['order']){_0x4d084e['order']['forEach'](function(_0x168d04){_0x3fb326['order']('c.'+_0x168d04[0x0],_0x168d04[0x1]===_0x7c99('0x7b')?![]:!![]);});}if(!_[_0x7c99('0x7c')](_0x550623)){_0x3fb326[_0x7c99('0x7d')](_0x2c6c11);_0x28982e[_0x7c99('0x66')](_0x7c99('0x7e'),_0x550623);}BPromise[_0x7c99('0x7f')]()[_0x7c99('0x29')](function(){if(!_0x59e246)return;if(_0x395494[_0x7c99('0x80')][_0x7c99('0x81')]!==_0x7c99('0x82'))return;if(!_[_0x7c99('0x83')](_0x59e246[_0x7c99('0x54')],[_0x7c99('0x46'),_0x7c99('0x5d')])){return _0x395494['user'][_0x7c99('0x84')]({'attributes':['id'],'raw':!![]})[_0x7c99('0x29')](function(_0x42ad18){if(_[_0x7c99('0x7c')](_0x42ad18)){_0x28982e[_0x7c99('0x66')](_0x7c99('0x85'));_0x3fb326[_0x7c99('0x66')]('c.ListId\x20IS\x20NULL');}else{_0x28982e[_0x7c99('0x66')](_0x7c99('0x67'),_[_0x7c99('0x59')](_0x42ad18,'id'));_0x3fb326[_0x7c99('0x66')](_0x7c99('0x67'),_[_0x7c99('0x59')](_0x42ad18,'id'));}});}})[_0x7c99('0x29')](function(){if(_0x395494[_0x7c99('0x80')][_0x7c99('0x81')]===_0x7c99('0x82')&&!_0x59e246&&!_0x395494[_0x7c99('0x3a')][_0x7c99('0x86')])return[];return db[_0x7c99('0x87')][_0x7c99('0x3a')](_0x28982e[_0x7c99('0x88')](),_0x31b2eb);})[_0x7c99('0x29')](function(_0x1d388c){_0x58b20f[_0x7c99('0x22')]=_0x1d388c[_0x7c99('0x32')];if(_0x58b20f['count']===0x0)return[];return db[_0x7c99('0x87')][_0x7c99('0x3a')](_0x552fb3['toString'](),_0x31b2eb)[_0x7c99('0x29')](function(_0x1e7620){_0x35c815=_['keyBy'](_0x1e7620,'id');_0x31b2eb=_[_0x7c99('0x89')](_0x31b2eb,{'model':db[_0x7c99('0x2f')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x395494[_0x7c99('0x3a')][_0x7c99('0x3d')]){_0x4d084e[_0x7c99('0x3e')]['forEach'](function(_0x2acc7c){_0x3fb326[_0x7c99('0x46')]('c.'+_0x2acc7c);});}else{_0x3fb326[_0x7c99('0x46')]('c.id');_0x3fb326['field'](_0x7c99('0x8a'));_0x3fb326[_0x7c99('0x46')](_0x7c99('0x8b'));_0x3fb326['field'](_0x7c99('0x8c'));_0x3fb326['field']('c.mobile');_0x3fb326[_0x7c99('0x46')](_0x7c99('0x8d'));_0x3fb326['field'](_0x7c99('0x8e'));_0x3fb326[_0x7c99('0x46')](_0x7c99('0x8f'));_0x3fb326[_0x7c99('0x46')](_0x7c99('0x90'));_0x3fb326['field'](_0x7c99('0x91'));_0x3fb326[_0x7c99('0x46')](_0x7c99('0x92'));_0x3fb326['field'](_0x7c99('0x93'),_0x7c99('0x94'));}if(_0x4d084e[_0x7c99('0x41')])_0x3fb326[_0x7c99('0x41')](_0x4d084e[_0x7c99('0x41')]);if(_0x4d084e[_0x7c99('0x23')])_0x3fb326[_0x7c99('0x23')](_0x4d084e[_0x7c99('0x23')]);return db[_0x7c99('0x87')][_0x7c99('0x3a')](_0x3fb326[_0x7c99('0x88')](),_0x31b2eb);});})['then'](function(_0xb74d68){_0xb74d68[_0x7c99('0x5a')](function(_0x4ecf30){if(_0x4ecf30[_0x7c99('0x94')]){_0x4ecf30[_0x7c99('0x95')]=[];_0x4ecf30[_0x7c99('0x94')]['split'](',')[_0x7c99('0x5a')](function(_0x48dcf7){_0x4ecf30['Tags'][_0x7c99('0x35')](_0x35c815[_0x48dcf7]);});}delete _0x4ecf30['TagIds'];});_0x58b20f[_0x7c99('0x96')]=_0xb74d68;return _0x58b20f;})['then'](respondWithFilteredResult(_0x98ab97,_0x4d084e));})['catch'](handleError(_0x98ab97,null));};exports[_0x7c99('0x2a')]=function(_0x5549dc,_0x322e17){return db[_0x7c99('0x2f')][_0x7c99('0x55')]({'where':{'id':_0x5549dc['params']['id']}})[_0x7c99('0x29')](handleEntityNotFound(_0x322e17,null))[_0x7c99('0x29')](removeEntity(_0x322e17,null))['catch'](handleError(_0x322e17,null));};exports[_0x7c99('0x30')]=function(_0x341f78,_0x281077){return db['CmContact'][_0x7c99('0x30')]()[_0x7c99('0x29')](function(_0x15a294){delete _0x15a294[_0x7c99('0x97')];for(var _0x523efe=0x0;_0x523efe<Object[_0x7c99('0x31')](_0x15a294)[_0x7c99('0x32')];_0x523efe++){var _0x50bc2e=Object['keys'](_0x15a294)[_0x523efe];if(!_[_0x7c99('0x33')](_0x50bc2e,_0x7c99('0x34'))){_0x15a294[_0x50bc2e][_0x7c99('0x98')]=_0x50bc2e;_0x15a294[_0x50bc2e][_0x7c99('0x99')]=_0x50bc2e;}}return _0x15a294;})[_0x7c99('0x29')](function(_0x294a5a){var _0x1e51c8={'where':{'$or':[{'ListId':_0x341f78[_0x7c99('0x3a')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x7c99('0x9a')][_0x7c99('0x9b')](_0x1e51c8)[_0x7c99('0x29')](function(_0x457cef){for(var _0x5b6ca1=0x0;_0x5b6ca1<_0x457cef[_0x7c99('0x32')];_0x5b6ca1++){var _0x467371=_0x7c99('0x34')+_0x457cef[_0x5b6ca1]['id'];_0x294a5a[_0x467371][_0x7c99('0x98')]=_0x467371;_0x294a5a[_0x467371][_0x7c99('0x99')]=_0x457cef[_0x5b6ca1]['alias'];_0x294a5a[_0x467371][_0x7c99('0x9c')]={'type':_0x457cef[_0x5b6ca1][_0x7c99('0x38')],'values':_0x457cef[_0x5b6ca1][_0x7c99('0x9d')]};}Object[_0x7c99('0x31')](_0x294a5a)[_0x7c99('0x5a')](function(_0x5cdbb3){if(!_0x294a5a[_0x5cdbb3]['hasOwnProperty'](_0x7c99('0x98'))){delete _0x294a5a[_0x5cdbb3];}});return _0x294a5a;});})[_0x7c99('0x29')](respondWithResult(_0x281077,null))[_0x7c99('0x9e')](handleError(_0x281077,null));};exports[_0x7c99('0x89')]=function(_0x1a493c,_0x380a3a){var _0x509b16;var _0x21302a;var _0x974645;if(_0x1a493c[_0x7c99('0x9f')]['id']){delete _0x1a493c[_0x7c99('0x9f')]['id'];}return db[_0x7c99('0x2f')][_0x7c99('0x9b')]({'where':{'id':[_0x1a493c[_0x7c99('0x9f')]['to'],_0x1a493c[_0x7c99('0x9f')]['from']]}})[_0x7c99('0x29')](function(_0x1e1223){if(_0x1e1223){if(_0x1e1223[_0x7c99('0x32')]!==0x2){return null;}_0x1e1223[0x0]=_0x1e1223[0x0][_0x7c99('0xa0')]({'plain':!![]});_0x1e1223[0x1]=_0x1e1223[0x1]['get']({'plain':!![]});delete _0x1e1223[0x0]['id'];delete _0x1e1223[0x1]['id'];return _['mergeWith'](_0x1e1223[0x0],_0x1e1223[0x1],function(_0x4c4f27,_0x2e13d6){if(Array['isArray'](_0x2e13d6)&&!_0x2e13d6['length']){return _0x4c4f27;}else if(!_0x2e13d6){return _0x4c4f27;}});}})[_0x7c99('0x29')](handleEntityNotFound(_0x380a3a,null))['then'](function(_0x5a2c1d){if(_0x5a2c1d){if(_0x5a2c1d[_0x7c99('0x97')]&&_[_0x7c99('0x6c')](_0x5a2c1d[_0x7c99('0x97')])){_0x5a2c1d['tags']=_0x5a2c1d[_0x7c99('0x97')][_0x7c99('0xa1')]();}logger['info'](_0x7c99('0xa2'),_0x1a493c[_0x7c99('0x9f')]['to'],_0x1a493c[_0x7c99('0x9f')][_0x7c99('0x48')]);return db['CmHopper'][_0x7c99('0x2a')]({'where':{'ContactId':[_0x1a493c[_0x7c99('0x9f')]['to'],_0x1a493c['body']['from']]}})['then'](function(_0x4e203f){logger[_0x7c99('0xa3')](_0x7c99('0xa4'),_0x4e203f);return db[_0x7c99('0xa5')][_0x7c99('0x2a')]({'where':{'ContactId':[_0x1a493c[_0x7c99('0x9f')]['to'],_0x1a493c['body'][_0x7c99('0x48')]]}})[_0x7c99('0x29')](function(_0x490b4d){logger[_0x7c99('0xa3')]('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x490b4d);return db[_0x7c99('0x2f')][_0x7c99('0xa6')](_0x5a2c1d);});});}})[_0x7c99('0x29')](function(_0x1da0a0){if(_0x1da0a0){_0x509b16=_0x1da0a0;_0x21302a={'ContactId':_0x509b16['id']};_0x974645={'where':{'ContactId':[_0x1a493c['body']['to'],_0x1a493c[_0x7c99('0x9f')][_0x7c99('0x48')]]}};return db[_0x7c99('0xa7')]['update'](_0x21302a,_0x974645);}})[_0x7c99('0x29')](function(){if(_0x509b16){return db['ChatMessage'][_0x7c99('0x28')](_0x21302a,_0x974645);}})[_0x7c99('0x29')](function(){if(_0x509b16){return db[_0x7c99('0xa8')][_0x7c99('0x28')](_0x21302a,_0x974645);}})[_0x7c99('0x29')](function(){if(_0x509b16){return db[_0x7c99('0xa9')][_0x7c99('0x28')](_0x21302a,_0x974645);}})[_0x7c99('0x29')](function(){if(_0x509b16){return db[_0x7c99('0xaa')][_0x7c99('0x28')](_0x21302a,_0x974645);}})['then'](function(){if(_0x509b16){return db[_0x7c99('0xa9')][_0x7c99('0x28')](_0x21302a,_0x974645);}})[_0x7c99('0x29')](function(){if(_0x509b16){return db[_0x7c99('0xaa')][_0x7c99('0x28')](_0x21302a,_0x974645);}})['then'](function(){if(_0x509b16){return db[_0x7c99('0xab')][_0x7c99('0x28')](_0x21302a,_0x974645);}})[_0x7c99('0x29')](function(){if(_0x509b16){return db[_0x7c99('0xac')]['update'](_0x21302a,_0x974645);}})['then'](function(){if(_0x509b16){return db[_0x7c99('0xad')][_0x7c99('0x28')](_0x21302a,_0x974645);}})['then'](function(){if(_0x509b16){return db['FaxMessage'][_0x7c99('0x28')](_0x21302a,_0x974645);}})['then'](function(){if(_0x509b16){return db[_0x7c99('0xae')][_0x7c99('0x28')](_0x21302a,_0x974645);}})[_0x7c99('0x29')](function(){if(_0x509b16){return db[_0x7c99('0xaf')][_0x7c99('0x28')](_0x21302a,_0x974645);}})[_0x7c99('0x29')](function(){if(_0x509b16){return db['CmContactHasItem']['update']({'CmContactId':_0x509b16['id']},{'where':{'CmContactId':[_0x1a493c[_0x7c99('0x9f')]['to'],_0x1a493c[_0x7c99('0x9f')]['from']]}});}})[_0x7c99('0x29')](function(){if(_0x509b16){return db[_0x7c99('0xb0')]['update'](_0x21302a,_0x974645);}})[_0x7c99('0x29')](function(){if(_0x509b16){return db[_0x7c99('0xb1')][_0x7c99('0x28')](_0x21302a,_0x974645);}})[_0x7c99('0x29')](function(){if(_0x509b16){return db[_0x7c99('0xb2')][_0x7c99('0x28')](_0x21302a,_0x974645);}})['then'](function(){if(_0x509b16){return db[_0x7c99('0xb3')][_0x7c99('0x28')](_0x21302a,_0x974645);}})[_0x7c99('0x29')](function(){if(_0x509b16){return db[_0x7c99('0xb4')][_0x7c99('0x28')](_0x21302a,_0x974645);}})[_0x7c99('0x29')](function(){if(_0x509b16){return db[_0x7c99('0xb5')]['update'](_0x21302a,_0x974645);}})[_0x7c99('0x29')](function(){if(_0x509b16){return db['MailQueueReport'][_0x7c99('0x28')](_0x21302a,_0x974645);}})[_0x7c99('0x29')](function(){if(_0x509b16){return db[_0x7c99('0xb6')][_0x7c99('0x28')](_0x21302a,_0x974645);}})['then'](function(){if(_0x509b16){return db['SmsQueueReport'][_0x7c99('0x28')](_0x21302a,_0x974645);}})['then'](function(){if(_0x509b16){return db['JscriptySessionReport'][_0x7c99('0x28')](_0x21302a,_0x974645);}})['then'](function(){if(_0x509b16){return db[_0x7c99('0xb7')][_0x7c99('0x28')](_0x21302a,_0x974645);}})[_0x7c99('0x29')](function(){if(_0x509b16){return db[_0x7c99('0xb8')]['update'](_0x21302a,_0x974645);}})['then'](function(){if(_0x509b16){return db[_0x7c99('0xb9')][_0x7c99('0x28')](_0x21302a,_0x974645);}})[_0x7c99('0x29')](function(){if(_0x509b16){return db[_0x7c99('0x2f')][_0x7c99('0x2a')]({'where':{'id':[_0x1a493c[_0x7c99('0x9f')]['to'],_0x1a493c[_0x7c99('0x9f')][_0x7c99('0x48')]]}});}})[_0x7c99('0x29')](function(){if(_0x509b16){return _0x509b16;}})['then'](respondWithResult(_0x380a3a,null))['catch'](handleError(_0x380a3a,null));};exports[_0x7c99('0xa6')]=function(_0x44037a,_0x450201){return db[_0x7c99('0x2f')]['describe']()[_0x7c99('0x29')](function(_0x2ac4f3){if(_0x44037a['body'][_0x7c99('0x97')]&&_[_0x7c99('0x6c')](_0x44037a[_0x7c99('0x9f')][_0x7c99('0x97')])){if(_0x44037a[_0x7c99('0x9f')][_0x7c99('0x97')]['length']){_0x44037a[_0x7c99('0x9f')][_0x7c99('0x97')]=_0x44037a[_0x7c99('0x9f')]['tags'][_0x7c99('0xa1')](';')+';';}else{_0x44037a[_0x7c99('0x9f')][_0x7c99('0x97')]=null;}}else{_0x44037a[_0x7c99('0x9f')]['tags']=null;}return db[_0x7c99('0x2f')][_0x7c99('0xa6')](_0x44037a[_0x7c99('0x9f')],{'fields':_[_0x7c99('0x31')](_0x2ac4f3),'raw':!![]});})['then'](respondWithResult(_0x450201,0xc9))['catch'](handleError(_0x450201,null));};exports[_0x7c99('0xba')]=function(_0x4c00c5,_0x3e21b4){var _0x1ef44e=[];var _0x387146=0x0;var _0x557a60=0x0;var _0xb8eba=0x0;return db[_0x7c99('0x2f')][_0x7c99('0x30')]()[_0x7c99('0x29')](function(_0x1b5036){return BPromise['each'](_0x4c00c5[_0x7c99('0x9f')],function(_0x3a05bb){var _0x4e252c={'where':{'$or':[]},'defaults':_0x3a05bb,'fields':_['keys'](_0x1b5036),'raw':!![]};if(_0x3a05bb[_0x7c99('0xbb')]){for(var _0x3e3da2=0x0;_0x3e3da2<_0x3a05bb[_0x7c99('0xbb')][_0x7c99('0x32')];_0x3e3da2++){var _0x13559a={};_0x13559a[_0x3a05bb[_0x7c99('0xbb')][_0x3e3da2]]=_0x3a05bb[_0x3a05bb[_0x7c99('0xbb')][_0x3e3da2]];_0x4e252c[_0x7c99('0x66')][_0x7c99('0xbc')][_0x7c99('0x35')](_0x13559a);}_0x4e252c[_0x7c99('0x66')][_0x7c99('0x86')]=_0x3a05bb[_0x7c99('0x86')];}return db[_0x7c99('0x2f')][_0x7c99('0xbd')](_0x4e252c)[_0x7c99('0xbe')](function(_0x521e63,_0xd0d6cd){if(_0xd0d6cd){_0x387146++;}else{_0xb8eba++;}})[_0x7c99('0x9e')](function(_0x432c5d){console['error'](_0x432c5d);_0x557a60++;});});})[_0x7c99('0x29')](function(_0x2b96b9){if(_0x2b96b9){return{'success':_0x387146,'failure':_0x557a60,'duplicates':_0xb8eba};}})['then'](respondWithResult(_0x3e21b4,0xc9))['catch'](handleError(_0x3e21b4,null));};exports[_0x7c99('0xbf')]=function(_0x190a4f,_0x1bf9df,_0x5a7156){var _0x556478;return db[_0x7c99('0x2f')][_0x7c99('0x30')]()[_0x7c99('0x29')](function(_0x3274bc){return db[_0x7c99('0x2f')][_0x7c99('0x55')]({'where':{'id':_0x190a4f['params']['id']},'include':[{'model':db['Tag'],'as':_0x7c99('0x95'),'attributes':['id',_0x7c99('0x2c'),_0x7c99('0x47')],'required':_0x190a4f[_0x7c99('0x3a')][_0x7c99('0x6b')]?!![]:![]},{'model':db[_0x7c99('0xc0')],'as':_0x7c99('0xc1'),'where':{'CmContactId':_0x190a4f['params']['id']},'required':![],'include':[{'model':db[_0x7c99('0xc2')],'as':_0x7c99('0xc3')}]}],'order':[db[_0x7c99('0x87')][_0x7c99('0xc4')]('`Phones.ItemType`.OrderBy')],'logging':console['log'],'attributes':_[_0x7c99('0x31')](_0x3274bc)});})['then'](function(_0x47894c){_0x556478=_0x47894c[_0x7c99('0xa0')]({'plain':!![]});var _0x459f67={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x47894c&&_0x47894c[_0x7c99('0x86')]){if(_0x47894c[_0x7c99('0x86')]){_0x459f67[_0x7c99('0x66')][_0x7c99('0xc5')][_0x7c99('0x35')]({'ListId':{'$ne':_0x47894c[_0x7c99('0x86')]}});}}return db[_0x7c99('0x9a')][_0x7c99('0x9b')](_0x459f67);})[_0x7c99('0x29')](function(_0x26cf7b){return _[_0x7c99('0xc6')](_0x556478,_[_0x7c99('0x59')](_0x26cf7b,function(_0x1d922d){return util[_0x7c99('0xc7')](_0x7c99('0xc8'),_0x1d922d['id']);}));})[_0x7c99('0x29')](handleEntityNotFound(_0x1bf9df,null))[_0x7c99('0x29')](respondWithResult(_0x1bf9df,null))[_0x7c99('0x9e')](handleError(_0x1bf9df,null));};exports[_0x7c99('0x28')]=function(_0x57eeaf,_0x512683){var _0x2bb765;if(_0x57eeaf['body']['id']){delete _0x57eeaf[_0x7c99('0x9f')]['id'];}return db['CmContact'][_0x7c99('0x55')]({'where':{'id':_0x57eeaf['params']['id']}})[_0x7c99('0x29')](handleEntityNotFound(_0x512683,null))['then'](saveUpdates(_0x57eeaf[_0x7c99('0x9f')],null))[_0x7c99('0x29')](function(_0x21c9fd){_0x2bb765=_0x21c9fd;var _0x1c9ece={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x21c9fd&&_0x21c9fd[_0x7c99('0x86')]){if(_0x21c9fd[_0x7c99('0x86')]){_0x1c9ece['where']['$and'][_0x7c99('0x35')]({'ListId':{'$ne':_0x21c9fd[_0x7c99('0x86')]}});}}return db[_0x7c99('0x9a')]['findAll'](_0x1c9ece);})[_0x7c99('0x29')](function(_0x5a9cf4){if(_0x5a9cf4){return _[_0x7c99('0xc6')](_[_0x7c99('0xc9')](_0x57eeaf[_0x7c99('0x9f')],function(_0x14579a,_0x2cd24a){return _['startsWith'](_0x2cd24a,_0x7c99('0x34'));}),_[_0x7c99('0x59')](_0x5a9cf4,function(_0x4598d1){return util['format'](_0x7c99('0xc8'),_0x4598d1['id']);}));}})[_0x7c99('0x29')](function(_0x5355f0){if(_0x5355f0&&!_['isEmpty'](_0x5355f0)){var _0x4feae2=squel['update']()[_0x7c99('0xca')](_0x7c99('0x4a'))[_0x7c99('0xcb')](_0x5355f0)[_0x7c99('0x66')](_0x7c99('0xcc'),_0x57eeaf[_0x7c99('0xcd')]['id'])[_0x7c99('0xce')]();return db['sequelize'][_0x7c99('0x3a')](_0x4feae2[_0x7c99('0x62')],{'replacements':_0x4feae2[_0x7c99('0x9d')]});}})[_0x7c99('0x29')](function(){if(_0x57eeaf[_0x7c99('0x9f')]['phone']&&_0x2bb765){return db['CmHopper'][_0x7c99('0x28')]({'phone':_0x57eeaf[_0x7c99('0x9f')][_0x7c99('0xcf')]},{'where':{'ContactId':_0x2bb765['id']}});}})[_0x7c99('0x29')](function(){return _0x2bb765;})[_0x7c99('0x29')](respondWithResult(_0x512683,null))['catch'](handleError(_0x512683,null));};exports[_0x7c99('0xd0')]=function(_0x53ed53,_0x10a5ff,_0x4394bd){var _0x41e6ab={};var _0x52b09b={};var _0x433a64;var _0x14aad8;return db['CmContact'][_0x7c99('0x36')]({'where':{'id':_0x53ed53[_0x7c99('0xcd')]['id']}})['then'](handleEntityNotFound(_0x10a5ff,null))[_0x7c99('0x29')](function(_0x166ad7){if(_0x166ad7){_0x433a64=_0x166ad7;_0x52b09b[_0x7c99('0x39')]=_[_0x7c99('0x31')](db[_0x7c99('0x56')][_0x7c99('0xd1')]);_0x52b09b['query']=_['keys'](_0x53ed53[_0x7c99('0x3a')]);_0x52b09b['filters']=_['intersection'](_0x52b09b[_0x7c99('0x39')],_0x52b09b[_0x7c99('0x3a')]);_0x41e6ab[_0x7c99('0x3e')]=_[_0x7c99('0x3c')](_0x52b09b[_0x7c99('0x39')],qs[_0x7c99('0x3d')](_0x53ed53['query']['fields']));_0x41e6ab[_0x7c99('0x3e')]=_0x41e6ab[_0x7c99('0x3e')][_0x7c99('0x32')]?_0x41e6ab[_0x7c99('0x3e')]:_0x52b09b[_0x7c99('0x39')];_0x41e6ab[_0x7c99('0x42')]=qs['sort'](_0x53ed53[_0x7c99('0x3a')][_0x7c99('0x43')]);_0x41e6ab['where']=qs[_0x7c99('0x3b')](_[_0x7c99('0x44')](_0x53ed53[_0x7c99('0x3a')],_0x52b09b[_0x7c99('0x3b')]));if(_0x53ed53[_0x7c99('0x3a')][_0x7c99('0x64')]){_0x41e6ab[_0x7c99('0x66')]=_['merge'](_0x41e6ab['where'],{'$or':_[_0x7c99('0x59')](_0x41e6ab[_0x7c99('0x3e')],function(_0x158f94){var _0x466136={};_0x466136[_0x158f94]={'$like':'%'+_0x53ed53['query'][_0x7c99('0x64')]+'%'};return _0x466136;})});}_0x41e6ab=_[_0x7c99('0x89')]({},_0x41e6ab,_0x53ed53[_0x7c99('0xd2')]);return _0x433a64['getTags'](_0x41e6ab);}})[_0x7c99('0x29')](function(_0x5c025c){if(_0x5c025c){_0x14aad8=_0x5c025c[_0x7c99('0x32')];if(!_0x53ed53[_0x7c99('0x3a')]['hasOwnProperty'](_0x7c99('0x40'))){_0x41e6ab[_0x7c99('0x41')]=qs['limit'](_0x53ed53[_0x7c99('0x3a')][_0x7c99('0x41')]);_0x41e6ab[_0x7c99('0x23')]=qs[_0x7c99('0x23')](_0x53ed53['query'][_0x7c99('0x23')]);}return _0x433a64['getTags'](_0x41e6ab);}})[_0x7c99('0x29')](function(_0x13bc2c){if(_0x13bc2c){return _0x13bc2c?{'count':_0x14aad8,'rows':_0x13bc2c}:null;}})[_0x7c99('0x29')](respondWithResult(_0x10a5ff,null))[_0x7c99('0x9e')](handleError(_0x10a5ff,null));};exports[_0x7c99('0xd3')]=function(_0x39aca6,_0x2d82b0,_0x587a0f){if(_0x39aca6['body']['id']){delete _0x39aca6[_0x7c99('0x9f')]['id'];}return db[_0x7c99('0x2f')]['findOne']({'where':{'id':_0x39aca6[_0x7c99('0xcd')]['id']}})[_0x7c99('0x29')](handleEntityNotFound(_0x2d82b0,null))['then'](function(_0x209bbc){if(_0x209bbc){return _0x209bbc['setTags'](_0x39aca6['body'][_0x7c99('0xd4')]||[]);}return null;})['then'](respondWithResult(_0x2d82b0,null))[_0x7c99('0x9e')](handleError(_0x2d82b0,null));};exports[_0x7c99('0xd5')]=function(_0x57878c,_0x2ef617){var _0x2f9e3b=[];_0x2f9e3b[_0x7c99('0x35')](addAdditionalPhones(_0x57878c['body']));Promise[_0x7c99('0xd6')](_0x2f9e3b)[_0x7c99('0x29')](function(){_0x2f9e3b=[];_0x2f9e3b[_0x7c99('0x35')](deleteCmHopperPhones(_0x57878c[_0x7c99('0x9f')]['id']));_0x2f9e3b['push'](addCmHopperPhones(_0x57878c[_0x7c99('0x9f')]['id']));Promise[_0x7c99('0xd6')](_0x2f9e3b)['then'](function(){return[0x1];})[_0x7c99('0x29')](respondWithResult(_0x2ef617,null));});};function addAdditionalPhones(_0x4f9525){return new Promise(function(_0x2a4f03,_0x13e0eb){return db[_0x7c99('0xc0')][_0x7c99('0x2a')]({'where':{'CmContactId':_0x4f9525['id']}})[_0x7c99('0x29')](function(){var _0x408205=[];for(var _0x5c93df=0x0;_0x5c93df<_0x4f9525[_0x7c99('0xd7')][_0x7c99('0x32')];_0x5c93df++){_0x408205[_0x7c99('0x35')](addAdditionalPhone(_0x4f9525['id'],_0x4f9525['items'][_0x5c93df][_0x7c99('0xcf')],_0x4f9525['item_types'][_0x5c93df]===_0x7c99('0xd8')?null:_0x4f9525[_0x7c99('0xd9')][_0x5c93df],_0x5c93df));}Promise[_0x7c99('0xd6')](_0x408205)[_0x7c99('0x29')](function(){_0x2a4f03(0x1);});});});}function addAdditionalPhone(_0x2591a1,_0xa134d2,_0x4154ac,_0x35512d){return db[_0x7c99('0xc0')][_0x7c99('0x55')]({'where':{'CmContactId':_0x2591a1,'item':_0xa134d2}})[_0x7c99('0x29')](function(_0x4addda){if(_0x4addda)logger[_0x7c99('0xa3')](_0x7c99('0xda'),_0x4addda);else{db[_0x7c99('0xc0')]['create']({'CmContactId':_0x2591a1,'item':_0xa134d2,'ItemTypeId':_0x4154ac,'OrderBy':_0x35512d,'ItemClass':_0x7c99('0xdb')});}});}function deletePhones(_0x33ad27){return db['CmContactHasItem'][_0x7c99('0x2a')]({'where':{'CmContactId':_0x33ad27}});}function deleteCmHopperPhones(_0x4d5130){return new Promise(function(_0x1c4e4e,_0x3cd6a6){return db[_0x7c99('0xdc')][_0x7c99('0x9b')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x4d5130}})['then'](function(_0x110c16){db[_0x7c99('0xdd')][_0x7c99('0x2a')]({'where':{'CmHopperId':{'$in':_['map'](_0x110c16,'id')}}});})[_0x7c99('0x29')](function(){_0x1c4e4e(0x1);});});}function addCmHopperPhones(_0x1971a4){return new Promise(function(_0x51ffb0,_0xb5112f){return db[_0x7c99('0xdc')][_0x7c99('0x9b')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x1971a4}})[_0x7c99('0x29')](function(_0x255163){var _0x2805dd=[];_[_0x7c99('0x59')](_0x255163,function(_0x2ef39e){_0x2805dd[_0x7c99('0x35')](createCmHopperPhone(_0x1971a4,_0x2ef39e['id']));});Promise[_0x7c99('0xd6')](_0x2805dd)['then'](function(){_0x51ffb0(0x1);});});});}function createCmHopperPhone(_0x4ed848,_0x5bf7de){return new Promise(function(_0x26e9c4,_0x36ffa7){db[_0x7c99('0xc0')][_0x7c99('0x9b')]({'raw':!![],'attributes':[_0x7c99('0xde')],'where':{'CmContactId':_0x4ed848,'ItemClass':'PHONE'},'include':[{'model':db[_0x7c99('0xc2')],'attributes':[_0x7c99('0xdf')],'as':_0x7c99('0xc3')}],'order':[db[_0x7c99('0x87')][_0x7c99('0xc4')]('`ItemType`.OrderBy')]})[_0x7c99('0x29')](function(_0x416a89){var _0x4be0cb=_[_0x7c99('0x59')](_0x416a89,function(_0x1f932c){_0x1f932c[_0x7c99('0xe0')]=_0x5bf7de;_0x1f932c[_0x7c99('0xcf')]=_0x1f932c[_0x7c99('0xde')];_0x1f932c['OrderBy']=_0x1f932c[_0x7c99('0xe1')];delete _0x1f932c[_0x7c99('0xe1')];return _0x1f932c;});return db[_0x7c99('0xdd')][_0x7c99('0xba')](_0x4be0cb,{});})[_0x7c99('0x29')](function(){_0x26e9c4(0x1);});});}exports[_0x7c99('0xe2')]=function(_0x36b9f0,_0x51fa59){return db[_0x7c99('0xc0')][_0x7c99('0x9b')]({'raw':!![],'where':{'CmContactId':_0x36b9f0[_0x7c99('0xcd')]['id'],'ItemClass':'PHONE'},'include':[{'model':db[_0x7c99('0xc2')],'as':_0x7c99('0xc3')}],'order':[db['sequelize'][_0x7c99('0xc4')](_0x7c99('0xe3'))]})[_0x7c99('0x29')](function(_0x1626d9){return _0x1626d9;})['then'](respondWithResult(_0x51fa59,null))[_0x7c99('0x9e')](handleError(_0x51fa59,null));};exports['duplicateAdditionalPhones']=function(_0x7b0e08,_0x472756){return db[_0x7c99('0xc0')]['findAll']({'raw':!![],'where':{'CmContactId':_0x7b0e08[_0x7c99('0x9f')]['fromContactId']}})[_0x7c99('0x29')](function(_0x340687){var _0x26ae12=_[_0x7c99('0x59')](_0x340687,function(_0x3f5396){_0x3f5396[_0x7c99('0xe4')]=_0x7b0e08[_0x7c99('0x9f')][_0x7c99('0xe5')];return _0x3f5396;});return db[_0x7c99('0xc0')]['bulkCreate'](_0x26ae12,{});})[_0x7c99('0x29')](function(_0x3aaf11){return addCmHopperPhones(_0x7b0e08[_0x7c99('0x9f')][_0x7c99('0xe5')]);})[_0x7c99('0x29')](function(_0x3f0ac3){return['ok'];})[_0x7c99('0x29')](respondWithResult(_0x472756,null))['catch'](handleError(_0x472756,null));};exports['rescheduleAdditionalPhones']=function(_0x459433,_0x44ce7b){var _0x53e8d7=[];_0x53e8d7[_0x7c99('0x35')](createCmHopperPhone(_0x459433[_0x7c99('0x9f')]['id'],_0x459433[_0x7c99('0x9f')][_0x7c99('0xe6')]));Promise['all'](_0x53e8d7)['then'](function(){return[0x1];})[_0x7c99('0x29')](respondWithResult(_0x44ce7b,null));};exports[_0x7c99('0xe7')]=function(_0x3a05a8,_0x39ff30,_0x4ce972){var _0x3ccdfd={'raw':![],'where':{}};var _0x3f67c0={};var _0x539ba5={'count':0x0,'rows':[]};return db['CmContact'][_0x7c99('0x36')]({'where':{'id':_0x3a05a8[_0x7c99('0xcd')]['id']}})['then'](handleEntityNotFound(_0x39ff30,null))[_0x7c99('0x29')](function(_0x5d2712){if(_0x5d2712){_0x3f67c0[_0x7c99('0x39')]=_[_0x7c99('0x31')](db['CmHopper'][_0x7c99('0xd1')]);_0x3f67c0[_0x7c99('0x3a')]=_[_0x7c99('0x31')](_0x3a05a8[_0x7c99('0x3a')]);_0x3f67c0[_0x7c99('0x3b')]=_['intersection'](_0x3f67c0[_0x7c99('0x39')],_0x3f67c0['query']);_0x3ccdfd[_0x7c99('0x3e')]=_[_0x7c99('0x3c')](_0x3f67c0[_0x7c99('0x39')],qs[_0x7c99('0x3d')](_0x3a05a8[_0x7c99('0x3a')]['fields']));_0x3ccdfd[_0x7c99('0x3e')]=_0x3ccdfd[_0x7c99('0x3e')]['length']?_0x3ccdfd[_0x7c99('0x3e')]:_0x3f67c0[_0x7c99('0x39')];if(!_0x3a05a8['query'][_0x7c99('0x3f')](_0x7c99('0x40'))){_0x3ccdfd[_0x7c99('0x41')]=qs[_0x7c99('0x41')](_0x3a05a8['query'][_0x7c99('0x41')]);_0x3ccdfd[_0x7c99('0x23')]=qs['offset'](_0x3a05a8[_0x7c99('0x3a')][_0x7c99('0x23')]);}_0x3ccdfd[_0x7c99('0x42')]=qs[_0x7c99('0x43')](_0x3a05a8['query']['sort']);_0x3ccdfd[_0x7c99('0x66')]=qs[_0x7c99('0x3b')](_[_0x7c99('0x44')](_0x3a05a8[_0x7c99('0x3a')],_0x3f67c0[_0x7c99('0x3b')]));_0x3ccdfd[_0x7c99('0x66')][_0x7c99('0xe8')]=_0x5d2712['id'];if(_0x3a05a8[_0x7c99('0x3a')][_0x7c99('0x64')]){_0x3ccdfd[_0x7c99('0x66')]=_[_0x7c99('0x89')](_0x3ccdfd[_0x7c99('0x66')],{'$or':_[_0x7c99('0x59')](_0x3ccdfd[_0x7c99('0x3e')],function(_0x4cc0fc){var _0x571037={};_0x571037[_0x4cc0fc]={'$like':'%'+_0x3a05a8[_0x7c99('0x3a')][_0x7c99('0x64')]+'%'};return _0x571037;})});}_0x3ccdfd=_[_0x7c99('0x89')]({},_0x3ccdfd,_0x3a05a8[_0x7c99('0xd2')]);return db[_0x7c99('0xdc')][_0x7c99('0x22')]({'where':_0x3ccdfd['where']})[_0x7c99('0x29')](function(_0xd52b31){_0x539ba5[_0x7c99('0x22')]=_0xd52b31;if(_0x3a05a8[_0x7c99('0x3a')][_0x7c99('0xe9')]){_0x3ccdfd['include']=[{'all':!![]}];}return db[_0x7c99('0xdc')][_0x7c99('0x9b')](_0x3ccdfd);})[_0x7c99('0x29')](function(_0x3a1097){_0x539ba5[_0x7c99('0x96')]=_0x3a1097;return _0x539ba5;});}})['then'](respondWithFilteredResult(_0x39ff30,_0x3ccdfd))[_0x7c99('0x9e')](handleError(_0x39ff30,null));};exports[_0x7c99('0xea')]=function(_0x3dd674,_0x7475ea,_0x1950cc){var _0x3d4804={'raw':!![],'where':{}};var _0x5838c7={};var _0x2dd0ac={'count':0x0,'rows':[]};return db[_0x7c99('0x2f')][_0x7c99('0x36')]({'where':{'id':_0x3dd674[_0x7c99('0xcd')]['id']}})['then'](handleEntityNotFound(_0x7475ea,null))['then'](function(_0x563ab8){if(_0x563ab8){_0x5838c7[_0x7c99('0x39')]=_['keys'](db[_0x7c99('0xb1')][_0x7c99('0xd1')]);_0x5838c7[_0x7c99('0x3a')]=_[_0x7c99('0x31')](_0x3dd674['query']);_0x5838c7[_0x7c99('0x3b')]=_[_0x7c99('0x3c')](_0x5838c7[_0x7c99('0x39')],_0x5838c7['query']);_0x3d4804[_0x7c99('0x3e')]=_[_0x7c99('0x3c')](_0x5838c7[_0x7c99('0x39')],qs[_0x7c99('0x3d')](_0x3dd674[_0x7c99('0x3a')][_0x7c99('0x3d')]));_0x3d4804[_0x7c99('0x3e')]=_0x3d4804[_0x7c99('0x3e')]['length']?_0x3d4804[_0x7c99('0x3e')]:_0x5838c7['model'];if(!_0x3dd674[_0x7c99('0x3a')][_0x7c99('0x3f')]('nolimit')){_0x3d4804['limit']=qs[_0x7c99('0x41')](_0x3dd674[_0x7c99('0x3a')][_0x7c99('0x41')]);_0x3d4804[_0x7c99('0x23')]=qs[_0x7c99('0x23')](_0x3dd674[_0x7c99('0x3a')][_0x7c99('0x23')]);}_0x3d4804[_0x7c99('0x42')]=qs[_0x7c99('0x43')](_0x3dd674[_0x7c99('0x3a')][_0x7c99('0x43')]);_0x3d4804[_0x7c99('0x66')]=qs['filters'](_[_0x7c99('0x44')](_0x3dd674['query'],_0x5838c7[_0x7c99('0x3b')]));_0x3d4804[_0x7c99('0x66')]['ContactId']=_0x563ab8['id'];if(_0x3dd674[_0x7c99('0x3a')][_0x7c99('0x64')]){_0x3d4804[_0x7c99('0x66')]=_[_0x7c99('0x89')](_0x3d4804[_0x7c99('0x66')],{'$or':_[_0x7c99('0x59')](_0x3d4804[_0x7c99('0x3e')],function(_0x1e93fb){var _0x184b40={};_0x184b40[_0x1e93fb]={'$like':'%'+_0x3dd674[_0x7c99('0x3a')][_0x7c99('0x64')]+'%'};return _0x184b40;})});}_0x3d4804=_[_0x7c99('0x89')]({},_0x3d4804,_0x3dd674['options']);return db[_0x7c99('0xb1')][_0x7c99('0x22')]({'where':_0x3d4804[_0x7c99('0x66')]})[_0x7c99('0x29')](function(_0x30e27c){_0x2dd0ac['count']=_0x30e27c;if(_0x3dd674['query'][_0x7c99('0xe9')]){_0x3d4804[_0x7c99('0xeb')]=[{'all':!![]}];}return db[_0x7c99('0xb1')][_0x7c99('0x9b')](_0x3d4804);})[_0x7c99('0x29')](function(_0x38cfa4){_0x2dd0ac[_0x7c99('0x96')]=_0x38cfa4;return _0x2dd0ac;});}})[_0x7c99('0x29')](respondWithFilteredResult(_0x7475ea,_0x3d4804))['catch'](handleError(_0x7475ea,null));};exports[_0x7c99('0xec')]=function(_0x32cfe0,_0x7ebb1,_0x36d442){var _0x4d0360={'raw':!![],'where':{}};var _0x4d7198={};var _0x12a665={'count':0x0,'rows':[]};return db[_0x7c99('0x2f')][_0x7c99('0x36')]({'where':{'id':_0x32cfe0[_0x7c99('0xcd')]['id']}})['then'](handleEntityNotFound(_0x7ebb1,null))[_0x7c99('0x29')](function(_0x51b222){if(_0x51b222){_0x4d7198[_0x7c99('0x39')]=_['keys'](db[_0x7c99('0xb0')][_0x7c99('0xd1')]);_0x4d7198['query']=_[_0x7c99('0x31')](_0x32cfe0[_0x7c99('0x3a')]);_0x4d7198['filters']=_['intersection'](_0x4d7198[_0x7c99('0x39')],_0x4d7198[_0x7c99('0x3a')]);_0x4d0360[_0x7c99('0x3e')]=_['intersection'](_0x4d7198[_0x7c99('0x39')],qs[_0x7c99('0x3d')](_0x32cfe0['query']['fields']));_0x4d0360[_0x7c99('0x3e')]=_0x4d0360['attributes'][_0x7c99('0x32')]?_0x4d0360[_0x7c99('0x3e')]:_0x4d7198[_0x7c99('0x39')];if(!_0x32cfe0['query'][_0x7c99('0x3f')](_0x7c99('0x40'))){_0x4d0360['limit']=qs[_0x7c99('0x41')](_0x32cfe0[_0x7c99('0x3a')][_0x7c99('0x41')]);_0x4d0360[_0x7c99('0x23')]=qs['offset'](_0x32cfe0[_0x7c99('0x3a')][_0x7c99('0x23')]);}_0x4d0360[_0x7c99('0x42')]=qs[_0x7c99('0x43')](_0x32cfe0['query'][_0x7c99('0x43')]);_0x4d0360[_0x7c99('0x66')]=qs[_0x7c99('0x3b')](_['pick'](_0x32cfe0[_0x7c99('0x3a')],_0x4d7198[_0x7c99('0x3b')]));_0x4d0360[_0x7c99('0x66')][_0x7c99('0xe8')]=_0x51b222['id'];if(_0x32cfe0[_0x7c99('0x3a')][_0x7c99('0x64')]){_0x4d0360['where']=_[_0x7c99('0x89')](_0x4d0360[_0x7c99('0x66')],{'$or':_[_0x7c99('0x59')](_0x4d0360[_0x7c99('0x3e')],function(_0x3fdf3c){var _0x4d1d42={};_0x4d1d42[_0x3fdf3c]={'$like':'%'+_0x32cfe0['query'][_0x7c99('0x64')]+'%'};return _0x4d1d42;})});}_0x4d0360=_[_0x7c99('0x89')]({},_0x4d0360,_0x32cfe0['options']);return db[_0x7c99('0xb0')][_0x7c99('0x22')]({'where':_0x4d0360[_0x7c99('0x66')]})[_0x7c99('0x29')](function(_0x29f17b){_0x12a665[_0x7c99('0x22')]=_0x29f17b;if(_0x32cfe0[_0x7c99('0x3a')][_0x7c99('0xe9')]){_0x4d0360[_0x7c99('0xeb')]=[{'all':!![]}];}return db[_0x7c99('0xb0')][_0x7c99('0x9b')](_0x4d0360);})[_0x7c99('0x29')](function(_0x5c923c){_0x12a665[_0x7c99('0x96')]=_0x5c923c;return _0x12a665;});}})[_0x7c99('0x29')](respondWithFilteredResult(_0x7ebb1,_0x4d0360))['catch'](handleError(_0x7ebb1,null));};exports[_0x7c99('0xed')]=function(_0x3afbc2,_0x1f38e7,_0x52514a){var _0x66b02f={'raw':!![],'where':{}};var _0x4fcef9={};var _0x73de3f={'count':0x0,'rows':[]};return db[_0x7c99('0x2f')]['findOne']({'where':{'id':_0x3afbc2[_0x7c99('0xcd')]['id']}})[_0x7c99('0x29')](handleEntityNotFound(_0x1f38e7,null))[_0x7c99('0x29')](function(_0x475c05){if(_0x475c05){_0x4fcef9[_0x7c99('0x39')]=_[_0x7c99('0x31')](db[_0x7c99('0xee')][_0x7c99('0xd1')]);_0x4fcef9[_0x7c99('0x3a')]=_[_0x7c99('0x31')](_0x3afbc2[_0x7c99('0x3a')]);_0x4fcef9[_0x7c99('0x3b')]=_['intersection'](_0x4fcef9[_0x7c99('0x39')],_0x4fcef9['query']);_0x66b02f['attributes']=_[_0x7c99('0x3c')](_0x4fcef9['model'],qs[_0x7c99('0x3d')](_0x3afbc2['query'][_0x7c99('0x3d')]));_0x66b02f[_0x7c99('0x3e')]=_0x66b02f[_0x7c99('0x3e')][_0x7c99('0x32')]?_0x66b02f[_0x7c99('0x3e')]:_0x4fcef9[_0x7c99('0x39')];if(!_0x3afbc2[_0x7c99('0x3a')][_0x7c99('0x3f')](_0x7c99('0x40'))){_0x66b02f['limit']=qs[_0x7c99('0x41')](_0x3afbc2[_0x7c99('0x3a')]['limit']);_0x66b02f[_0x7c99('0x23')]=qs[_0x7c99('0x23')](_0x3afbc2['query'][_0x7c99('0x23')]);}_0x66b02f[_0x7c99('0x42')]=qs['sort'](_0x3afbc2[_0x7c99('0x3a')][_0x7c99('0x43')]);_0x66b02f[_0x7c99('0x66')]=qs['filters'](_[_0x7c99('0x44')](_0x3afbc2[_0x7c99('0x3a')],_0x4fcef9['filters']));_0x66b02f[_0x7c99('0x66')][_0x7c99('0xe8')]=_0x475c05['id'];if(_0x3afbc2[_0x7c99('0x3a')][_0x7c99('0x64')]){_0x66b02f[_0x7c99('0x66')]=_['merge'](_0x66b02f['where'],{'$or':_['map'](_0x66b02f[_0x7c99('0x3e')],function(_0x13b5bd){var _0x14e051={};_0x14e051[_0x13b5bd]={'$like':'%'+_0x3afbc2[_0x7c99('0x3a')]['filter']+'%'};return _0x14e051;})});}_0x66b02f=_[_0x7c99('0x89')]({},_0x66b02f,_0x3afbc2[_0x7c99('0xd2')]);return db[_0x7c99('0xee')][_0x7c99('0x22')]({'where':_0x66b02f[_0x7c99('0x66')]})[_0x7c99('0x29')](function(_0x37ea2a){_0x73de3f[_0x7c99('0x22')]=_0x37ea2a;if(_0x3afbc2[_0x7c99('0x3a')][_0x7c99('0xe9')]){_0x66b02f[_0x7c99('0xeb')]=[{'all':!![]}];}return db[_0x7c99('0xee')][_0x7c99('0x9b')](_0x66b02f);})[_0x7c99('0x29')](function(_0x533f60){_0x73de3f[_0x7c99('0x96')]=_0x533f60;return _0x73de3f;});}})[_0x7c99('0x29')](respondWithFilteredResult(_0x1f38e7,_0x66b02f))[_0x7c99('0x9e')](handleError(_0x1f38e7,null));};exports[_0x7c99('0xef')]=function(_0x24cd7d,_0xdc90f8,_0xe0ae48){try{if(!_0x24cd7d[_0x7c99('0x9f')][_0x7c99('0x86')]){throw new Error(_0x7c99('0xf0'));}if(!_0x24cd7d['body'][_0x7c99('0xf1')]){throw new Error(_0x7c99('0xf2'));}if(!_0x24cd7d[_0x7c99('0x9f')][_0x7c99('0xf3')]){throw new Error('No\x20association\x20values\x20specified!');}if(!_0x24cd7d[_0x7c99('0x9f')][_0x7c99('0xf4')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x10b47e=_0x24cd7d['body'][_0x7c99('0xf1')][_0x7c99('0x58')](',');var _0xc64c75=_0x24cd7d[_0x7c99('0x9f')]['binding_values']['split'](',');if(!_0x10b47e['length']||!_0xc64c75[_0x7c99('0x32')]||_0x10b47e[_0x7c99('0x32')]!==_0xc64c75[_0x7c99('0x32')]){throw new Error(_0x7c99('0xf5'));}_0x24cd7d[_0x7c99('0x9f')]['fields']=_['zipObject'](_0x10b47e,_0xc64c75);if(!_0x24cd7d[_0x7c99('0x9f')][_0x7c99('0x3d')][_0x7c99('0xcf')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x24cd7d[_0x7c99('0x9f')][_0x7c99('0x3d')][_0x7c99('0xf6')]){throw new Error(_0x7c99('0xf7'));}var _0x50e878=path[_0x7c99('0xa1')](config['root'],'server/files/tmp',_0x24cd7d[_0x7c99('0xf8')][_0x7c99('0xf9')]);fs[_0x7c99('0xfa')](_0x50e878,parseInt(_0x7c99('0xfb'),0x8));var _0x17dedf=require('child_process')[_0x7c99('0xfc')](path[_0x7c99('0xa1')](__dirname,_0x7c99('0xfd')),[_0x50e878,_0x24cd7d[_0x7c99('0x9f')][_0x7c99('0xf1')],_0x24cd7d['body'][_0x7c99('0xf3')],_0x24cd7d[_0x7c99('0x9f')][_0x7c99('0x86')],_0x24cd7d['body'][_0x7c99('0xfe')],_0x24cd7d['body']['duplicates'],_0x24cd7d[_0x7c99('0x9f')][_0x7c99('0xf4')]]);return _0xdc90f8[_0x7c99('0x20')](0xc8)[_0x7c99('0xff')]({'message':'File\x20uploaded\x20correctly!','pid':_0x17dedf[_0x7c99('0x100')]});}catch(_0x2c3bd5){return _0xdc90f8[_0x7c99('0x20')](0x1f4)[_0x7c99('0x2d')](_0x2c3bd5);}};exports['upload']=function(_0x3e9c5f,_0x48f5a7,_0x11b5c7){var _0x48cc44=fs[_0x7c99('0x101')](_0x3e9c5f[_0x7c99('0xf8')]['path']);Papa[_0x7c99('0x102')](_0x48cc44,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x4907d7){return _0x48f5a7['status'](0xc8)[_0x7c99('0xff')]({'file':_0x3e9c5f['file'],'fields':_0x4907d7['meta']['fields']});}});};exports[_0x7c99('0x103')]=function(_0x7c59d5,_0x126a6b,_0x1d1b5f){return db[_0x7c99('0x5d')][_0x7c99('0x9b')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0x7c99('0x29')](function(_0x331db1){var _0x5715a0=![];if(!_0x7c59d5[_0x7c99('0x9f')][_0x7c99('0x86')]){throw new Error('No\x20ListId\x20specified');}if(!_0x7c59d5['body']['binding'][_0x7c99('0xcf')]){throw new Error(_0x7c99('0x104'));}if(!_0x7c59d5[_0x7c99('0x9f')]['binding']['firstName']){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x7c59d5['body'][_0x7c99('0xf4')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x124de5=require(_0x7c99('0x105'))[_0x7c99('0xfc')](path[_0x7c99('0xa1')](__dirname,_0x7c99('0x106')),[_0x7c59d5[_0x7c99('0xcd')]['id'],JSON[_0x7c99('0x107')](_0x7c59d5[_0x7c99('0x9f')]),JSON[_0x7c99('0x107')](_0x331db1)]);_0x124de5['on'](_0x7c99('0x108'),function(_0xc2e797){_0x5715a0=!![];return _0x126a6b['status'](0xc8)[_0x7c99('0xff')]({'message':_0x7c99('0x109'),'pid':_0x124de5[_0x7c99('0x100')]});});_0x124de5['on']('exit',function(_0x241ae7){if(_0x241ae7&&!_0x5715a0){return _0x126a6b[_0x7c99('0x20')](0x1f4)[_0x7c99('0xff')]({'message':_0x7c99('0x10a'),'pid':_0x124de5[_0x7c99('0x100')]});}});})['catch'](handleError(_0x126a6b,null));};exports[_0x7c99('0x10b')]=function(_0xbeac21,_0x8dd07c,_0x55aa35){return db[_0x7c99('0x5d')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0x7c99('0x82')}})['then'](function(_0x2a6bd0){var _0x4e3e73=![];if(!_0xbeac21['body']['ListId']){throw new Error(_0x7c99('0xf0'));}if(!_0xbeac21[_0x7c99('0x9f')]['binding']['phone']){throw new Error('No\x20phone\x20column\x20specified');}if(!_0xbeac21['body'][_0x7c99('0x10c')][_0x7c99('0xf6')]){throw new Error(_0x7c99('0xf7'));}if(!_0xbeac21['body'][_0x7c99('0xf4')]){throw new Error(_0x7c99('0x10d'));}var _0x451f78=require(_0x7c99('0x105'))[_0x7c99('0xfc')](path[_0x7c99('0xa1')](__dirname,'../../components/import/cm/csvUpdates'),[_0xbeac21[_0x7c99('0xcd')]['id'],JSON[_0x7c99('0x107')](_0xbeac21[_0x7c99('0x9f')]),JSON['stringify'](_0x2a6bd0)]);_0x451f78['on']('message',function(_0x4c5931){_0x4e3e73=!![];return _0x8dd07c[_0x7c99('0x20')](0xc8)[_0x7c99('0xff')]({'message':_0x7c99('0x109'),'pid':_0x451f78[_0x7c99('0x100')]});});_0x451f78['on']('exit',function(_0x31ca2e){if(_0x31ca2e&&!_0x4e3e73){return _0x8dd07c[_0x7c99('0x20')](0x1f4)[_0x7c99('0xff')]({'message':'error\x20child\x20process','pid':_0x451f78[_0x7c99('0x100')]});}});})[_0x7c99('0x9e')](handleError(_0x8dd07c,null));};exports[_0x7c99('0x10e')]=function(_0x212f1a,_0x34a4d2){var _0x3e2965=[_0x7c99('0x10f'),'chat','sms',_0x7c99('0x110'),_0x7c99('0x111'),_0x7c99('0x112'),_0x7c99('0x113')];var _0x186de7={'offset':0x0,'order':qs['sort']('-createdAt')},_0x47d3e4={'count':0x0,'rows':[]};Promise[_0x7c99('0x7f')]()['then'](function(){if(_0x212f1a[_0x7c99('0x3a')][_0x7c99('0x114')]){if(!_[_0x7c99('0x115')](_0x3e2965,_0x212f1a[_0x7c99('0x3a')][_0x7c99('0x114')][_0x7c99('0x116')]())){throw new Error(_0x7c99('0x117'));}_0x3e2965=[_0x212f1a[_0x7c99('0x3a')][_0x7c99('0x114')][_0x7c99('0x116')]()];}if(_0x212f1a[_0x7c99('0x3a')][_0x7c99('0x118')]){try{var _0x59f566=JSON['parse'](_0x212f1a['query'][_0x7c99('0x118')]);if(!moment(_0x59f566[_0x7c99('0x48')])[_0x7c99('0x119')]()){throw new Error('Invalid\x20date\x20for\x20range\x20from\x20filter');}if(!moment(_0x59f566['to'])[_0x7c99('0x119')]()){throw new Error(_0x7c99('0x11a'));}}catch(_0xaa774f){throw new Error('Invalid\x20createdAt\x20filter');}}if(!_0x212f1a['query'][_0x7c99('0x3f')]('nolimit')){_0x186de7[_0x7c99('0x41')]=qs[_0x7c99('0x41')](_0x212f1a[_0x7c99('0x3a')]['limit']||0xa);_0x186de7[_0x7c99('0x23')]=qs[_0x7c99('0x23')](_0x212f1a['query'][_0x7c99('0x23')]);}var _0x1393b9=_0x3e2965[_0x7c99('0x59')](function(_0x21f7d4){if(_0x21f7d4===_0x7c99('0x113')){var _0x53134e={'attributes':['id',_0x7c99('0x11b'),_0x7c99('0x38'),_0x7c99('0x11c'),_0x7c99('0x11d'),'callerid','starttime',_0x7c99('0x11e'),_0x7c99('0x11f'),_0x7c99('0x120'),_0x7c99('0x121'),_0x7c99('0x122'),_0x7c99('0x123'),_0x7c99('0x124'),_0x7c99('0x125')],'where':{'ContactId':_0x212f1a[_0x7c99('0xcd')]['id']},'include':[{'model':db[_0x7c99('0x5d')],'as':_0x7c99('0x5d'),'attributes':['id',_0x7c99('0x2c'),'fullname',_0x7c99('0x126')]}],'order':[[_0x7c99('0x121'),_0x7c99('0x7b')]]};if(_0x212f1a['query'][_0x7c99('0x118')]){_0x53134e['where'][_0x7c99('0x121')]={'$gte':_0x59f566[_0x7c99('0x48')],'$lte':_0x59f566['to']};}return db[_0x7c99('0xb3')]['findAndCountAll'](_0x53134e)[_0x7c99('0x29')](function(_0x18c70b){_0x47d3e4[_0x7c99('0x22')]+=_0x18c70b[_0x7c99('0x22')];return _[_0x7c99('0x59')](_0x18c70b[_0x7c99('0x96')],function(_0x26edf7){var _0x2cfe02=_0x26edf7[_0x7c99('0xa0')]({'plain':!![]});_0x2cfe02[_0x7c99('0x114')]=_0x21f7d4;if(_0x2cfe02['User']){_0x2cfe02['User']={'id':_0x2cfe02[_0x7c99('0x5d')]['id'],'name':_0x2cfe02[_0x7c99('0x5d')][_0x7c99('0x2c')],'fullname':_0x2cfe02[_0x7c99('0x5d')][_0x7c99('0x127')],'alias':_0x2cfe02['User']['alias']};}return _0x2cfe02;});});}else{var _0x1baeae=_[_0x7c99('0x128')](_0x21f7d4)+(_0x21f7d4===_0x7c99('0x129')?_0x7c99('0x12a'):_0x7c99('0x12b'));var _0x339d13={'attributes':['id','closed',_0x7c99('0x12c'),_0x7c99('0x121'),'note','disposition',_0x7c99('0x12d'),'thirdDisposition','UserId',_0x1baeae+'Id'],'where':{'ContactId':_0x212f1a[_0x7c99('0xcd')]['id']},'include':[{'model':db[_0x1baeae],'as':_0x7c99('0x12b'),'attributes':['id',_0x7c99('0x2c'),'key']},{'model':db[_0x7c99('0x5d')],'as':_0x7c99('0x12e'),'attributes':['id',_0x7c99('0x2c'),_0x7c99('0x127')]},{'model':db[_0x7c99('0x56')],'as':_0x7c99('0x95'),'attributes':['id',_0x7c99('0x2c'),_0x7c99('0x47')],'through':{'attributes':[]}}],'order':[[_0x7c99('0x121'),_0x7c99('0x7b')]]};if(_0x212f1a[_0x7c99('0x3a')]['range']){_0x339d13[_0x7c99('0x66')]['createdAt']={'$gte':_0x59f566[_0x7c99('0x48')],'$lte':_0x59f566['to']};}switch(_0x21f7d4){case'chat':_0x339d13[_0x7c99('0x3e')][_0x7c99('0x35')](_0x7c99('0x12f'),_0x7c99('0x130'),_0x7c99('0x131'),_0x7c99('0x132'),_0x7c99('0x133'),_0x7c99('0x134'),_0x7c99('0x135'),_0x7c99('0x136'),_0x7c99('0x137'));break;case _0x7c99('0x10f'):_0x339d13[_0x7c99('0x3e')][_0x7c99('0x35')](_0x7c99('0x138'),_0x7c99('0x139'));break;case _0x7c99('0x110'):_0x339d13[_0x7c99('0x3e')][_0x7c99('0x35')](_0x7c99('0x13a'),_0x7c99('0x13b'));break;}return db[_[_0x7c99('0x128')](_0x21f7d4)+_0x7c99('0x13c')][_0x7c99('0x13d')](_0x339d13)['then'](function(_0x382137){_0x47d3e4[_0x7c99('0x22')]+=_0x382137['count'];return _[_0x7c99('0x59')](_0x382137['rows'],function(_0x1c4558){var _0x564087=_0x1c4558['get']({'plain':!![]});_0x564087[_0x7c99('0x114')]=_0x21f7d4;if(_0x564087[_0x7c99('0x12e')]){_0x564087[_0x7c99('0x12e')]={'id':_0x564087[_0x7c99('0x12e')]['id'],'name':_0x564087[_0x7c99('0x12e')]['name'],'fullname':_0x564087[_0x7c99('0x12e')][_0x7c99('0x127')]};}return _0x564087;});});}});return Promise[_0x7c99('0xd6')](_0x1393b9);})['then'](function(_0x54c35c){return _(_0x54c35c)[_0x7c99('0x13e')]()[_0x7c99('0x13f')](_0x7c99('0x121'))['reverse']()[_0x7c99('0x57')]();})[_0x7c99('0x29')](function(_0x4daa40){_0x47d3e4['rows']=_0x186de7[_0x7c99('0x41')]?_0x4daa40[_0x7c99('0x140')](_0x186de7[_0x7c99('0x23')],_0x186de7['offset']+_0x186de7[_0x7c99('0x41')]):_0x4daa40;return _0x47d3e4;})[_0x7c99('0x29')](respondWithFilteredResult(_0x34a4d2,_0x186de7))[_0x7c99('0x9e')](handleError(_0x34a4d2,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff