// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xd4bb=['parse','meta','import','binding','No\x20phone\x20column\x20specified','../../components/import/cm/csv2','stringify','message','error\x20child\x20process','eml-format','zip-dir','request-promise','moment','bluebird','mustache','sox','to-csv','ejs','squel','crypto','jsforce','querystring','ioredis','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../mysqldb','redis','localhost','socket.io-emitter','./cmContact.socket','register','status','json','count','offset','limit','set','Content-Range','apply','reject','save','update','then','end','name','send','index','CmContact','length','keys','startsWith','cf_','push','CmCustomField','findOne','trimStart','all','fieldType','type','query','intersection','attributes','model','nolimit','sort','where','pick','filters','select','field','from','cm_contacts','left_join','cm_user_has_contacts','uc.CmContactId\x20=\x20c.id','cm_contact_has_tags','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','c.deletedAt\x20IS\x20NULL','expr','search','parseSearch','sqlOperator','conditions','find','value','split','map','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','User','uc.UserId\x20=\x20?','dateOfBirth','datetime','castTo','buildExpression','text','hasOwnProperty','filter','isNil','Contact','concat','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.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','c.email\x20LIKE\x20?','group','c.id','Sequelize','QueryTypes','SELECT','clone','order','isEmpty','having','resolve','c.ListId\x20IS\x20NULL','c.ListId\x20IN\x20?','sequelize','toString','merge','fields','c.firstName','c.lastName','c.phone','c.mobile','c.fax','c.email','c.ListId','c.deletedAt','TagIds','Tags','rows','catch','describe','tags','columnName','findAll','displayName','alias','values','body','get','mergeWith','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','destroy','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','bulkCreate','each','duplicates','$or','ListId','error','params','cf_%d','$and','omit','pickBy','format','table','setFields','id\x20=\x20?','toParam','phone','getTags','Tag','options','setTags','ids','rawAttributes','ContactId','includeAll','include','getHopperFinals','getJscriptySessions','JscriptySessionReport','uploadCsv','No\x20ListId\x20specified','No\x20association\x20keys\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_values','Incorrect\x20binding\x20parameters\x20passed!','zipObject','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','filename','chmodSync','0777','child_process','fork','../../components/import/cm/csv','binding_keys','File\x20uploaded\x20correctly!','pid','upload','createReadStream','file'];(function(_0x109685,_0x444ba7){var _0x4c8b3c=function(_0x479393){while(--_0x479393){_0x109685['push'](_0x109685['shift']());}};_0x4c8b3c(++_0x444ba7);}(_0xd4bb,0xf5));var _0xbd4b=function(_0x21365c,_0x5403d1){_0x21365c=_0x21365c-0x0;var _0x1ce0a8=_0xd4bb[_0x21365c];return _0x1ce0a8;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xbd4b('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xbd4b('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0xbd4b('0x2'));var moment=require(_0xbd4b('0x3'));var BPromise=require(_0xbd4b('0x4'));var Mustache=require(_0xbd4b('0x5'));var util=require('util');var path=require('path');var sox=require(_0xbd4b('0x6'));var csv=require(_0xbd4b('0x7'));var ejs=require(_0xbd4b('0x8'));var fs=require('fs');var _=require('lodash');var squel=require(_0xbd4b('0x9'));var crypto=require(_0xbd4b('0xa'));var jsforce=require(_0xbd4b('0xb'));var deskjs=require('desk.js');var toCsv=require(_0xbd4b('0x7'));var querystring=require(_0xbd4b('0xc'));var Papa=require('papaparse');var Redis=require(_0xbd4b('0xd'));var authService=require('../../components/auth/service');var qs=require(_0xbd4b('0xe'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0xbd4b('0xf'))(_0xbd4b('0x10'));var utils=require('../../config/utils');var config=require(_0xbd4b('0x11'));var db=require(_0xbd4b('0x12'))['db'];config[_0xbd4b('0x13')]=_['defaults'](config[_0xbd4b('0x13')],{'host':_0xbd4b('0x14'),'port':0x18eb});var socket=require(_0xbd4b('0x15'))(new Redis(config[_0xbd4b('0x13')]));require(_0xbd4b('0x16'))[_0xbd4b('0x17')](socket);function respondWithStatusCode(_0x2485f1,_0x2fb022){_0x2fb022=_0x2fb022||0xcc;return function(_0x4fe294){if(_0x4fe294){return _0x2485f1['sendStatus'](_0x2fb022);}return _0x2485f1[_0xbd4b('0x18')](_0x2fb022)['end']();};}function respondWithResult(_0x1bcb4b,_0x3a436a){_0x3a436a=_0x3a436a||0xc8;return function(_0x2c8923){if(_0x2c8923){return _0x1bcb4b[_0xbd4b('0x18')](_0x3a436a)[_0xbd4b('0x19')](_0x2c8923);}};}function respondWithFilteredResult(_0xd6b84d,_0x4dc53c){return function(_0x18f498){if(_0x18f498){var _0x2611f4=_0x18f498[_0xbd4b('0x1a')],_0x225101=_0x4dc53c[_0xbd4b('0x1b')],_0x27bf3b=_0x4dc53c['offset']+_0x4dc53c[_0xbd4b('0x1c')],_0x53d1bc;if(_0x27bf3b>=_0x2611f4){_0x27bf3b=_0x2611f4;_0x53d1bc=0xc8;}else{_0x53d1bc=0xce;}_0xd6b84d[_0xbd4b('0x18')](_0x53d1bc);return _0xd6b84d[_0xbd4b('0x1d')](_0xbd4b('0x1e'),_0x225101+'-'+_0x27bf3b+'/'+_0x2611f4)['json'](_0x18f498);}return null;};}function patchUpdates(_0x4bf2af){return function(_0x324c8a){try{jsonpatch[_0xbd4b('0x1f')](_0x324c8a,_0x4bf2af,!![]);}catch(_0x37b2a2){return BPromise[_0xbd4b('0x20')](_0x37b2a2);}return _0x324c8a[_0xbd4b('0x21')]();};}function saveUpdates(_0x120212,_0x18e299){return function(_0x1aa0f5){if(_0x1aa0f5){return _0x1aa0f5[_0xbd4b('0x22')](_0x120212)[_0xbd4b('0x23')](function(_0x6ee0d9){return _0x6ee0d9;});}return null;};}function removeEntity(_0x1eb8ad,_0x2fbfe3){return function(_0x5e14cb){if(_0x5e14cb){return _0x5e14cb['destroy']()[_0xbd4b('0x23')](function(){_0x1eb8ad[_0xbd4b('0x18')](0xcc)[_0xbd4b('0x24')]();});}};}function handleEntityNotFound(_0x3e7fc3,_0x256a8b){return function(_0x42af66){if(!_0x42af66){_0x3e7fc3['sendStatus'](0x194);}return _0x42af66;};}function handleError(_0x20ccbb,_0x5237c2){_0x5237c2=_0x5237c2||0x1f4;return function(_0x1f4d53){logger['error'](_0x1f4d53['stack']);if(_0x1f4d53[_0xbd4b('0x25')]){delete _0x1f4d53['name'];}_0x20ccbb[_0xbd4b('0x18')](_0x5237c2)[_0xbd4b('0x26')](_0x1f4d53);};}exports[_0xbd4b('0x27')]=function(_0x42d5bd,_0x5b7d12){var _0x217101={},_0x285796={},_0x5d261a={'count':0x0,'rows':[]};return db[_0xbd4b('0x28')]['describe']()[_0xbd4b('0x23')](function(_0x1cf937){var _0x5c3b3c=[];for(var _0x2c5403=0x0;_0x2c5403<Object['keys'](_0x1cf937)[_0xbd4b('0x29')];_0x2c5403++){var _0x3db5c0=Object[_0xbd4b('0x2a')](_0x1cf937)[_0x2c5403];if(_[_0xbd4b('0x2b')](_0x3db5c0,_0xbd4b('0x2c'))){_0x5c3b3c[_0xbd4b('0x2d')](db[_0xbd4b('0x2e')][_0xbd4b('0x2f')]({'where':{'id':_[_0xbd4b('0x30')](_0x3db5c0,'cf_')},'raw':!![]}));}}return BPromise[_0xbd4b('0x31')](_0x5c3b3c)[_0xbd4b('0x23')](function(_0x53e1c5){for(var _0x1d3f9e=0x0;_0x1d3f9e<_0x53e1c5[_0xbd4b('0x29')];_0x1d3f9e++){if(_0x53e1c5[_0x1d3f9e]){var _0x26c099=_0xbd4b('0x2c')+_0x53e1c5[_0x1d3f9e]['id'];var _0x43a19f=_0x1cf937[_0x26c099];_0x43a19f[_0xbd4b('0x32')]=_0x53e1c5[_0x1d3f9e][_0xbd4b('0x33')];}}return _0x1cf937;});})[_0xbd4b('0x23')](function(_0xb1bce6){_0x285796['model']=_[_0xbd4b('0x2a')](_0xb1bce6);_0x285796['query']=_[_0xbd4b('0x2a')](_0x42d5bd[_0xbd4b('0x34')]);_0x285796['filters']=_[_0xbd4b('0x35')](_0x285796['model'],_0x285796[_0xbd4b('0x34')]);_0x217101[_0xbd4b('0x36')]=_[_0xbd4b('0x35')](_0x285796[_0xbd4b('0x37')],qs['fields'](_0x42d5bd[_0xbd4b('0x34')]['fields']));_0x217101[_0xbd4b('0x36')]=_0x217101['attributes']['length']?_0x217101['attributes']:_0x285796['model'];if(!_0x42d5bd['query']['hasOwnProperty'](_0xbd4b('0x38'))){_0x217101[_0xbd4b('0x1c')]=qs[_0xbd4b('0x1c')](_0x42d5bd[_0xbd4b('0x34')][_0xbd4b('0x1c')]);_0x217101[_0xbd4b('0x1b')]=qs[_0xbd4b('0x1b')](_0x42d5bd[_0xbd4b('0x34')][_0xbd4b('0x1b')]);}_0x217101['order']=qs[_0xbd4b('0x39')](_0x42d5bd['query'][_0xbd4b('0x39')]);_0x217101[_0xbd4b('0x3a')]=qs['filters'](_[_0xbd4b('0x3b')](_0x42d5bd[_0xbd4b('0x34')],_0x285796[_0xbd4b('0x3c')]),_0xb1bce6);var _0x228a0f=[];var _0x373e90=squel[_0xbd4b('0x3d')]()['field']('id')[_0xbd4b('0x3e')]('name')[_0xbd4b('0x3e')]('color')[_0xbd4b('0x3f')]('tools_tags');var _0x3a1da0=squel['select']()[_0xbd4b('0x3f')](_0xbd4b('0x40'),'c')[_0xbd4b('0x41')](_0xbd4b('0x42'),'uc',_0xbd4b('0x43'))['left_join'](_0xbd4b('0x44'),'ct',_0xbd4b('0x45'))['left_join']('tools_tags','t',_0xbd4b('0x46'))[_0xbd4b('0x3a')](_0xbd4b('0x47'));var _0x1ca3b0=squel[_0xbd4b('0x48')]();var _0x398cb1=[];var _0x55b7e0=squel['expr']();var _0x46205e;if(_0x42d5bd[_0xbd4b('0x34')][_0xbd4b('0x49')]){_0x46205e=as[_0xbd4b('0x4a')](_0x42d5bd[_0xbd4b('0x34')][_0xbd4b('0x49')]);var _0x50f2f3=_0x46205e[_0xbd4b('0x4b')];for(var _0x552110=0x0;_0x552110<_0x46205e[_0xbd4b('0x4c')][_0xbd4b('0x29')];_0x552110++){var _0x413bda=_0x46205e[_0xbd4b('0x4c')][_0x552110];var _0x36b6fc='c';var _0x2c0824=_(_0xb1bce6)[_0xbd4b('0x2a')]()[_0xbd4b('0x4d')](function(_0x42462d){return _0x42462d===_0x413bda[_0xbd4b('0x3e')];});if(_0x2c0824)_0x2c0824=_0xb1bce6[_0x413bda[_0xbd4b('0x3e')]];if(!_0x2c0824){if(_0x413bda[_0xbd4b('0x3e')]==='Tag'){var _0x4d9cde=_0x413bda[_0xbd4b('0x4e')][_0xbd4b('0x4f')](',')[_0xbd4b('0x50')](function(_0x4d4ba7){return Number(_0x4d4ba7);});_0x4d9cde[_0xbd4b('0x51')](function(_0x1a17d7){_0x55b7e0['or'](_0xbd4b('0x52'),'%,'+_0x1a17d7+',%');});_0x398cb1=_[_0xbd4b('0x53')](_0x398cb1,_0x4d9cde);}else if(_0x413bda['field']===_0xbd4b('0x54')){_0x1ca3b0['and'](_0xbd4b('0x55'),_0x413bda[_0xbd4b('0x4e')]);}}else{if(_0x413bda[_0xbd4b('0x3e')]===_0xbd4b('0x56')||_0x2c0824[_0xbd4b('0x32')]===_0xbd4b('0x57'))_0x413bda[_0xbd4b('0x58')]='DATE';var _0x19281d=as[_0xbd4b('0x59')](_0x36b6fc,_0x2c0824[_0xbd4b('0x33')],_0x413bda);_0x1ca3b0[_0x50f2f3](_0x19281d[_0xbd4b('0x5a')],_0x19281d[_0xbd4b('0x4e')]['start'],_0x19281d['value'][_0xbd4b('0x24')]);}}}else{var _0x1f1a5f=_(Object[_0xbd4b('0x2a')](_0x42d5bd['query']))['map'](function(_0xa86742){return _0xb1bce6[_0xbd4b('0x5b')](_0xa86742)?_0xa86742:undefined;})[_0xbd4b('0x5c')](function(_0x1a9878){return!_[_0xbd4b('0x5d')](_0x1a9878);})[_0xbd4b('0x4e')]();if(_0x42d5bd[_0xbd4b('0x34')][_0xbd4b('0x5e')])_0x1f1a5f[_0xbd4b('0x2d')]('Contact');if(!_['isEmpty'](_0x1f1a5f)){_0x1f1a5f[_0xbd4b('0x51')](function(_0x176242){if(_0x176242==='ListId'){_0x3a1da0[_0xbd4b('0x3a')]('c.ListId\x20IN\x20?',[][_0xbd4b('0x5f')](_0x42d5bd[_0xbd4b('0x34')][_0x176242]));}else if(_0x176242===_0xbd4b('0x5e')){var _0x497651='%'+_0x42d5bd[_0xbd4b('0x34')][_0x176242]+'%';_0x3a1da0[_0xbd4b('0x3a')](_0xbd4b('0x60'),_0x497651);}else{_0x3a1da0[_0xbd4b('0x3a')]('c.'+_0x176242+_0xbd4b('0x61'),_0x42d5bd[_0xbd4b('0x34')][_0x176242]);}});}if(_0x42d5bd[_0xbd4b('0x34')][_0xbd4b('0x62')]){_0x398cb1=_[_0xbd4b('0x63')](_0x42d5bd[_0xbd4b('0x34')][_0xbd4b('0x62')])?_0x42d5bd[_0xbd4b('0x34')]['tag']:new Array(_0x42d5bd[_0xbd4b('0x34')][_0xbd4b('0x62')]);_0x398cb1[_0xbd4b('0x51')](function(_0x19a39e){_0x55b7e0['or'](_0xbd4b('0x52'),'%,'+_0x19a39e+',%');});}if(_0x42d5bd[_0xbd4b('0x34')][_0xbd4b('0x5c')]){var _0x5c8872=_0x42d5bd[_0xbd4b('0x34')]['filter']['replace']('\x5c','\x5c\x5c')[_0xbd4b('0x64')]('\x27\x27','\x27\x27\x27\x27');if(_0x5c8872[_0xbd4b('0x4f')]('\x20')[_0xbd4b('0x29')]>0x1){_0x1ca3b0['or'](_0xbd4b('0x65'),qs[_0xbd4b('0x66')](_0x5c8872),null);}else{if(qs[_0xbd4b('0x67')](_0x5c8872)){_0x1ca3b0['or']('c.id\x20LIKE\x20?',_0x5c8872+'%');_0x1ca3b0['or']('c.phone\x20LIKE\x20?',_0x5c8872+'%');_0x1ca3b0['or'](_0xbd4b('0x68'),_0x5c8872+'%');_0x1ca3b0['or'](_0xbd4b('0x69'),_0x5c8872+'%');}else if(qs[_0xbd4b('0x6a')](_0x5c8872)){_0x1ca3b0['or']('c.email\x20LIKE\x20?',_0x5c8872+'%');}else{_0x1ca3b0['or'](_0xbd4b('0x6b'),'%'+_0x5c8872+'%');_0x1ca3b0['or'](_0xbd4b('0x6c'),'%'+_0x5c8872+'%');_0x1ca3b0['or'](_0xbd4b('0x6d'),'%'+_0x5c8872+'%');}}}}_0x3a1da0['where'](_0x1ca3b0);_0x3a1da0[_0xbd4b('0x6e')](_0xbd4b('0x6f'));var _0x56d2c9={'type':db[_0xbd4b('0x70')][_0xbd4b('0x71')][_0xbd4b('0x72')],'raw':!![]};var _0xaf4769=_0x3a1da0[_0xbd4b('0x73')]()['field'](_0xbd4b('0x6f'));if(_0x217101[_0xbd4b('0x74')]){_0x217101[_0xbd4b('0x74')]['forEach'](function(_0xc3efb4){_0x3a1da0[_0xbd4b('0x74')]('c.'+_0xc3efb4[0x0],_0xc3efb4[0x1]==='DESC'?![]:!![]);});}if(!_[_0xbd4b('0x75')](_0x398cb1)){_0x3a1da0[_0xbd4b('0x76')](_0x55b7e0);_0xaf4769[_0xbd4b('0x3a')]('t.id\x20IN\x20?',_0x398cb1);}BPromise[_0xbd4b('0x77')]()[_0xbd4b('0x23')](function(){if(_0x46205e&&!_['some'](_0x46205e[_0xbd4b('0x4c')],[_0xbd4b('0x3e'),_0xbd4b('0x54')])){return _0x42d5bd['user']['getLists']({'attributes':['id'],'raw':!![]})[_0xbd4b('0x23')](function(_0x5bec7c){if(_[_0xbd4b('0x75')](_0x5bec7c)){_0xaf4769[_0xbd4b('0x3a')](_0xbd4b('0x78'));_0x3a1da0[_0xbd4b('0x3a')](_0xbd4b('0x78'));}else{_0xaf4769[_0xbd4b('0x3a')](_0xbd4b('0x79'),_[_0xbd4b('0x50')](_0x5bec7c,'id'));_0x3a1da0[_0xbd4b('0x3a')]('c.ListId\x20IN\x20?',_[_0xbd4b('0x50')](_0x5bec7c,'id'));}});}else{return;}})['then'](function(){db[_0xbd4b('0x7a')][_0xbd4b('0x34')](_0xaf4769['toString'](),_0x56d2c9)[_0xbd4b('0x23')](function(_0x14607d){_0x5d261a[_0xbd4b('0x1a')]=_0x14607d[_0xbd4b('0x29')];if(_0x5d261a[_0xbd4b('0x1a')]===0x0)return[];return db['sequelize'][_0xbd4b('0x34')](_0x373e90[_0xbd4b('0x7b')](),_0x56d2c9);})['then'](function(_0x3ccfb7){_0x228a0f=_['keyBy'](_0x3ccfb7,'id');_0x56d2c9=_[_0xbd4b('0x7c')](_0x56d2c9,{'model':db[_0xbd4b('0x28')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x42d5bd[_0xbd4b('0x34')][_0xbd4b('0x7d')]){_0x217101[_0xbd4b('0x36')][_0xbd4b('0x51')](function(_0x242294){_0x3a1da0[_0xbd4b('0x3e')]('c.'+_0x242294);});}else{_0x3a1da0['field'](_0xbd4b('0x6f'));_0x3a1da0[_0xbd4b('0x3e')](_0xbd4b('0x7e'));_0x3a1da0['field'](_0xbd4b('0x7f'));_0x3a1da0[_0xbd4b('0x3e')](_0xbd4b('0x80'));_0x3a1da0[_0xbd4b('0x3e')](_0xbd4b('0x81'));_0x3a1da0[_0xbd4b('0x3e')](_0xbd4b('0x82'));_0x3a1da0[_0xbd4b('0x3e')](_0xbd4b('0x83'));_0x3a1da0[_0xbd4b('0x3e')](_0xbd4b('0x84'));_0x3a1da0[_0xbd4b('0x3e')](_0xbd4b('0x85'));_0x3a1da0[_0xbd4b('0x3e')]('GROUP_CONCAT(DISTINCT\x20t.id)','TagIds');}if(_0x217101[_0xbd4b('0x1c')])_0x3a1da0[_0xbd4b('0x1c')](_0x217101['limit']);if(_0x217101['offset'])_0x3a1da0[_0xbd4b('0x1b')](_0x217101['offset']);return db['sequelize']['query'](_0x3a1da0['toString'](),_0x56d2c9);})[_0xbd4b('0x23')](function(_0x353e45){_0x353e45[_0xbd4b('0x51')](function(_0x17b72e){if(_0x17b72e[_0xbd4b('0x86')]){_0x17b72e[_0xbd4b('0x87')]=[];_0x17b72e[_0xbd4b('0x86')][_0xbd4b('0x4f')](',')['forEach'](function(_0x28d299){_0x17b72e['Tags'][_0xbd4b('0x2d')](_0x228a0f[_0x28d299]);});}delete _0x17b72e[_0xbd4b('0x86')];});_0x5d261a[_0xbd4b('0x88')]=_0x353e45;return _0x5d261a;})[_0xbd4b('0x23')](respondWithFilteredResult(_0x5b7d12,_0x217101));});})[_0xbd4b('0x89')](handleError(_0x5b7d12,null));};exports['destroy']=function(_0x45bf4c,_0x1554bd){return db[_0xbd4b('0x28')][_0xbd4b('0x4d')]({'where':{'id':_0x45bf4c['params']['id']}})[_0xbd4b('0x23')](handleEntityNotFound(_0x1554bd,null))['then'](removeEntity(_0x1554bd,null))[_0xbd4b('0x89')](handleError(_0x1554bd,null));};exports[_0xbd4b('0x8a')]=function(_0x158953,_0x487d66){return db[_0xbd4b('0x28')][_0xbd4b('0x8a')]()[_0xbd4b('0x23')](function(_0x3ff56a){delete _0x3ff56a[_0xbd4b('0x8b')];for(var _0x5c91e2=0x0;_0x5c91e2<Object[_0xbd4b('0x2a')](_0x3ff56a)[_0xbd4b('0x29')];_0x5c91e2++){var _0x4b3298=Object['keys'](_0x3ff56a)[_0x5c91e2];if(!_[_0xbd4b('0x2b')](_0x4b3298,_0xbd4b('0x2c'))){_0x3ff56a[_0x4b3298][_0xbd4b('0x8c')]=_0x4b3298;_0x3ff56a[_0x4b3298]['displayName']=_0x4b3298;}}return _0x3ff56a;})[_0xbd4b('0x23')](function(_0x186d56){var _0x225e6c={'where':{'$or':[{'ListId':_0x158953[_0xbd4b('0x34')]['id']},{'ListId':null}]},'raw':!![]};return db[_0xbd4b('0x2e')][_0xbd4b('0x8d')](_0x225e6c)[_0xbd4b('0x23')](function(_0x3e5364){for(var _0x5b159c=0x0;_0x5b159c<_0x3e5364['length'];_0x5b159c++){var _0x208142=_0xbd4b('0x2c')+_0x3e5364[_0x5b159c]['id'];_0x186d56[_0x208142][_0xbd4b('0x8c')]=_0x208142;_0x186d56[_0x208142][_0xbd4b('0x8e')]=_0x3e5364[_0x5b159c][_0xbd4b('0x8f')];_0x186d56[_0x208142]['custom']={'type':_0x3e5364[_0x5b159c]['type'],'values':_0x3e5364[_0x5b159c][_0xbd4b('0x90')]};}Object[_0xbd4b('0x2a')](_0x186d56)['forEach'](function(_0x4442d3){if(!_0x186d56[_0x4442d3][_0xbd4b('0x5b')](_0xbd4b('0x8c'))){delete _0x186d56[_0x4442d3];}});return _0x186d56;});})['then'](respondWithResult(_0x487d66,null))[_0xbd4b('0x89')](handleError(_0x487d66,null));};exports[_0xbd4b('0x7c')]=function(_0x2d23a3,_0x281756){var _0x4ebe34;var _0x4679d1;var _0x232dfb;if(_0x2d23a3[_0xbd4b('0x91')]['id']){delete _0x2d23a3[_0xbd4b('0x91')]['id'];}return db['CmContact'][_0xbd4b('0x8d')]({'where':{'id':[_0x2d23a3[_0xbd4b('0x91')]['to'],_0x2d23a3['body'][_0xbd4b('0x3f')]]}})[_0xbd4b('0x23')](function(_0x26d51d){if(_0x26d51d){if(_0x26d51d[_0xbd4b('0x29')]!==0x2){return null;}_0x26d51d[0x0]=_0x26d51d[0x0][_0xbd4b('0x92')]({'plain':!![]});_0x26d51d[0x1]=_0x26d51d[0x1][_0xbd4b('0x92')]({'plain':!![]});delete _0x26d51d[0x0]['id'];delete _0x26d51d[0x1]['id'];return _[_0xbd4b('0x93')](_0x26d51d[0x0],_0x26d51d[0x1],function(_0x433c84,_0x1dc240){if(Array[_0xbd4b('0x63')](_0x1dc240)&&!_0x1dc240[_0xbd4b('0x29')]){return _0x433c84;}else if(!_0x1dc240){return _0x433c84;}});}})['then'](handleEntityNotFound(_0x281756,null))['then'](function(_0x68e74a){if(_0x68e74a){if(_0x68e74a[_0xbd4b('0x8b')]&&_[_0xbd4b('0x63')](_0x68e74a[_0xbd4b('0x8b')])){_0x68e74a['tags']=_0x68e74a['tags']['join']();}logger[_0xbd4b('0x94')](_0xbd4b('0x95'),_0x2d23a3[_0xbd4b('0x91')]['to'],_0x2d23a3[_0xbd4b('0x91')]['from']);return db[_0xbd4b('0x96')]['destroy']({'where':{'ContactId':[_0x2d23a3[_0xbd4b('0x91')]['to'],_0x2d23a3['body'][_0xbd4b('0x3f')]]}})[_0xbd4b('0x23')](function(_0x375649){logger[_0xbd4b('0x94')](_0xbd4b('0x97'),_0x375649);return db[_0xbd4b('0x98')][_0xbd4b('0x99')]({'where':{'ContactId':[_0x2d23a3[_0xbd4b('0x91')]['to'],_0x2d23a3[_0xbd4b('0x91')][_0xbd4b('0x3f')]]}})['then'](function(_0xbbb843){logger[_0xbd4b('0x94')](_0xbd4b('0x9a'),_0xbbb843);return db[_0xbd4b('0x28')][_0xbd4b('0x9b')](_0x68e74a);});});}})['then'](function(_0x4e8b15){if(_0x4e8b15){_0x4ebe34=_0x4e8b15;_0x4679d1={'ContactId':_0x4ebe34['id']};_0x232dfb={'where':{'ContactId':[_0x2d23a3['body']['to'],_0x2d23a3[_0xbd4b('0x91')]['from']]}};return db['ChatInteraction']['update'](_0x4679d1,_0x232dfb);}})['then'](function(){if(_0x4ebe34){return db[_0xbd4b('0x9c')]['update'](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db[_0xbd4b('0x9d')]['update'](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db['MailInteraction'][_0xbd4b('0x22')](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db['MailMessage'][_0xbd4b('0x22')](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db[_0xbd4b('0x9e')]['update'](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db[_0xbd4b('0x9f')][_0xbd4b('0x22')](_0x4679d1,_0x232dfb);}})['then'](function(){if(_0x4ebe34){return db[_0xbd4b('0xa0')][_0xbd4b('0x22')](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db[_0xbd4b('0xa1')][_0xbd4b('0x22')](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db[_0xbd4b('0xa2')][_0xbd4b('0x22')](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db['FaxMessage'][_0xbd4b('0x22')](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db[_0xbd4b('0xa3')]['update'](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db[_0xbd4b('0xa4')]['update'](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db[_0xbd4b('0xa5')][_0xbd4b('0x22')](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db[_0xbd4b('0xa6')][_0xbd4b('0x22')](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db[_0xbd4b('0xa7')][_0xbd4b('0x22')](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db[_0xbd4b('0xa8')]['update'](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db[_0xbd4b('0xa9')][_0xbd4b('0x22')](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db[_0xbd4b('0xaa')][_0xbd4b('0x22')](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db[_0xbd4b('0xab')][_0xbd4b('0x22')](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db[_0xbd4b('0xac')]['update'](_0x4679d1,_0x232dfb);}})['then'](function(){if(_0x4ebe34){return db[_0xbd4b('0xad')][_0xbd4b('0x22')](_0x4679d1,_0x232dfb);}})['then'](function(){if(_0x4ebe34){return db['JscriptySessionReport'][_0xbd4b('0x22')](_0x4679d1,_0x232dfb);}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return db['CmContact'][_0xbd4b('0x99')]({'where':{'id':[_0x2d23a3[_0xbd4b('0x91')]['to'],_0x2d23a3[_0xbd4b('0x91')][_0xbd4b('0x3f')]]}});}})[_0xbd4b('0x23')](function(){if(_0x4ebe34){return _0x4ebe34;}})['then'](respondWithResult(_0x281756,null))['catch'](handleError(_0x281756,null));};exports[_0xbd4b('0x9b')]=function(_0x21ff52,_0x10496b){return db[_0xbd4b('0x28')]['describe']()[_0xbd4b('0x23')](function(_0x1d5103){if(_0x21ff52[_0xbd4b('0x91')][_0xbd4b('0x8b')]&&_[_0xbd4b('0x63')](_0x21ff52[_0xbd4b('0x91')]['tags'])){if(_0x21ff52[_0xbd4b('0x91')][_0xbd4b('0x8b')][_0xbd4b('0x29')]){_0x21ff52[_0xbd4b('0x91')][_0xbd4b('0x8b')]=_0x21ff52['body']['tags']['join'](';')+';';}else{_0x21ff52[_0xbd4b('0x91')]['tags']=null;}}else{_0x21ff52[_0xbd4b('0x91')][_0xbd4b('0x8b')]=null;}return db['CmContact']['create'](_0x21ff52[_0xbd4b('0x91')],{'fields':_['keys'](_0x1d5103),'raw':!![]});})['then'](respondWithResult(_0x10496b,0xc9))[_0xbd4b('0x89')](handleError(_0x10496b,null));};exports[_0xbd4b('0xae')]=function(_0x171be3,_0x2d6282){var _0x4a7bfe=[];var _0x5a7ccd=0x0;var _0x53dc68=0x0;var _0x3f2ae7=0x0;return db[_0xbd4b('0x28')][_0xbd4b('0x8a')]()['then'](function(_0x2cfac4){return BPromise[_0xbd4b('0xaf')](_0x171be3[_0xbd4b('0x91')],function(_0x350f94){var _0x3c23f3={'where':{'$or':[]},'defaults':_0x350f94,'fields':_['keys'](_0x2cfac4),'raw':!![]};if(_0x350f94[_0xbd4b('0xb0')]){for(var _0x4ff083=0x0;_0x4ff083<_0x350f94[_0xbd4b('0xb0')]['length'];_0x4ff083++){var _0x1e2186={};_0x1e2186[_0x350f94[_0xbd4b('0xb0')][_0x4ff083]]=_0x350f94[_0x350f94[_0xbd4b('0xb0')][_0x4ff083]];_0x3c23f3['where'][_0xbd4b('0xb1')][_0xbd4b('0x2d')](_0x1e2186);}_0x3c23f3[_0xbd4b('0x3a')][_0xbd4b('0xb2')]=_0x350f94[_0xbd4b('0xb2')];}return db[_0xbd4b('0x28')]['findOrCreate'](_0x3c23f3)['spread'](function(_0x6acbd0,_0x1219f8){if(_0x1219f8){_0x5a7ccd++;}else{_0x3f2ae7++;}})[_0xbd4b('0x89')](function(_0x3e31a0){console[_0xbd4b('0xb3')](_0x3e31a0);_0x53dc68++;});});})['then'](function(_0x7303ea){if(_0x7303ea){return{'success':_0x5a7ccd,'failure':_0x53dc68,'duplicates':_0x3f2ae7};}})['then'](respondWithResult(_0x2d6282,0xc9))[_0xbd4b('0x89')](handleError(_0x2d6282,null));};exports['show']=function(_0x35ec61,_0x2efd97,_0x2b76aa){var _0x113016;return db['CmContact']['describe']()[_0xbd4b('0x23')](function(_0x46052e){return db[_0xbd4b('0x28')]['find']({'where':{'id':_0x35ec61[_0xbd4b('0xb4')]['id']},'include':[{'model':db['Tag'],'as':'Tags','attributes':['id',_0xbd4b('0x25'),'color'],'required':_0x35ec61[_0xbd4b('0x34')][_0xbd4b('0x62')]?!![]:![]}],'attributes':_['keys'](_0x46052e)});})[_0xbd4b('0x23')](function(_0x39898f){_0x113016=_0x39898f[_0xbd4b('0x92')]({'plain':!![]});var _0x38a201={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x39898f&&_0x39898f[_0xbd4b('0xb2')]){if(_0x39898f['ListId']){_0x38a201[_0xbd4b('0x3a')]['$and'][_0xbd4b('0x2d')]({'ListId':{'$ne':_0x39898f[_0xbd4b('0xb2')]}});}}return db[_0xbd4b('0x2e')][_0xbd4b('0x8d')](_0x38a201);})[_0xbd4b('0x23')](function(_0x4462b3){return _['omit'](_0x113016,_[_0xbd4b('0x50')](_0x4462b3,function(_0x552899){return util['format'](_0xbd4b('0xb5'),_0x552899['id']);}));})[_0xbd4b('0x23')](handleEntityNotFound(_0x2efd97,null))[_0xbd4b('0x23')](respondWithResult(_0x2efd97,null))[_0xbd4b('0x89')](handleError(_0x2efd97,null));};exports['update']=function(_0x1905b5,_0x13024e){var _0x3ee1ab;if(_0x1905b5[_0xbd4b('0x91')]['id']){delete _0x1905b5[_0xbd4b('0x91')]['id'];}return db[_0xbd4b('0x28')][_0xbd4b('0x4d')]({'where':{'id':_0x1905b5[_0xbd4b('0xb4')]['id']}})[_0xbd4b('0x23')](handleEntityNotFound(_0x13024e,null))['then'](saveUpdates(_0x1905b5['body'],null))[_0xbd4b('0x23')](function(_0x2a0aee){_0x3ee1ab=_0x2a0aee;var _0xe421fd={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x2a0aee&&_0x2a0aee[_0xbd4b('0xb2')]){if(_0x2a0aee[_0xbd4b('0xb2')]){_0xe421fd[_0xbd4b('0x3a')][_0xbd4b('0xb6')][_0xbd4b('0x2d')]({'ListId':{'$ne':_0x2a0aee[_0xbd4b('0xb2')]}});}}return db[_0xbd4b('0x2e')][_0xbd4b('0x8d')](_0xe421fd);})[_0xbd4b('0x23')](function(_0x2dc41f){if(_0x2dc41f){return _[_0xbd4b('0xb7')](_[_0xbd4b('0xb8')](_0x1905b5['body'],function(_0x39b4ba,_0x395f12){return _[_0xbd4b('0x2b')](_0x395f12,_0xbd4b('0x2c'));}),_['map'](_0x2dc41f,function(_0x5c1cbc){return util[_0xbd4b('0xb9')]('cf_%d',_0x5c1cbc['id']);}));}})['then'](function(_0x20d62c){if(_0x20d62c&&!_[_0xbd4b('0x75')](_0x20d62c)){var _0x14e082=squel[_0xbd4b('0x22')]()[_0xbd4b('0xba')](_0xbd4b('0x40'))[_0xbd4b('0xbb')](_0x20d62c)['where'](_0xbd4b('0xbc'),_0x1905b5['params']['id'])[_0xbd4b('0xbd')]();return db['sequelize'][_0xbd4b('0x34')](_0x14e082[_0xbd4b('0x5a')],{'replacements':_0x14e082[_0xbd4b('0x90')]});}})[_0xbd4b('0x23')](function(){if(_0x1905b5[_0xbd4b('0x91')][_0xbd4b('0xbe')]&&_0x3ee1ab){return db['CmHopper'][_0xbd4b('0x22')]({'phone':_0x1905b5['body'][_0xbd4b('0xbe')]},{'where':{'ContactId':_0x3ee1ab['id']}});}})[_0xbd4b('0x23')](function(){return _0x3ee1ab;})[_0xbd4b('0x23')](respondWithResult(_0x13024e,null))[_0xbd4b('0x89')](handleError(_0x13024e,null));};exports[_0xbd4b('0xbf')]=function(_0x46dcfa,_0x38a060,_0x127ebe){var _0x4a9b16={};var _0xf0edac={};var _0xef12d9;var _0x26ca3b;return db[_0xbd4b('0x28')][_0xbd4b('0x2f')]({'where':{'id':_0x46dcfa['params']['id']}})[_0xbd4b('0x23')](handleEntityNotFound(_0x38a060,null))[_0xbd4b('0x23')](function(_0x31ad4c){if(_0x31ad4c){_0xef12d9=_0x31ad4c;_0xf0edac[_0xbd4b('0x37')]=_['keys'](db[_0xbd4b('0xc0')]['rawAttributes']);_0xf0edac[_0xbd4b('0x34')]=_[_0xbd4b('0x2a')](_0x46dcfa[_0xbd4b('0x34')]);_0xf0edac[_0xbd4b('0x3c')]=_[_0xbd4b('0x35')](_0xf0edac[_0xbd4b('0x37')],_0xf0edac[_0xbd4b('0x34')]);_0x4a9b16[_0xbd4b('0x36')]=_[_0xbd4b('0x35')](_0xf0edac[_0xbd4b('0x37')],qs[_0xbd4b('0x7d')](_0x46dcfa['query']['fields']));_0x4a9b16[_0xbd4b('0x36')]=_0x4a9b16[_0xbd4b('0x36')][_0xbd4b('0x29')]?_0x4a9b16['attributes']:_0xf0edac[_0xbd4b('0x37')];_0x4a9b16[_0xbd4b('0x74')]=qs[_0xbd4b('0x39')](_0x46dcfa['query']['sort']);_0x4a9b16[_0xbd4b('0x3a')]=qs[_0xbd4b('0x3c')](_[_0xbd4b('0x3b')](_0x46dcfa[_0xbd4b('0x34')],_0xf0edac['filters']));if(_0x46dcfa[_0xbd4b('0x34')]['filter']){_0x4a9b16['where']=_['merge'](_0x4a9b16[_0xbd4b('0x3a')],{'$or':_['map'](_0x4a9b16['attributes'],function(_0x412c2a){var _0x217dfe={};_0x217dfe[_0x412c2a]={'$like':'%'+_0x46dcfa[_0xbd4b('0x34')][_0xbd4b('0x5c')]+'%'};return _0x217dfe;})});}_0x4a9b16=_['merge']({},_0x4a9b16,_0x46dcfa[_0xbd4b('0xc1')]);return _0xef12d9[_0xbd4b('0xbf')](_0x4a9b16);}})[_0xbd4b('0x23')](function(_0x28c7fc){if(_0x28c7fc){_0x26ca3b=_0x28c7fc[_0xbd4b('0x29')];if(!_0x46dcfa['query'][_0xbd4b('0x5b')](_0xbd4b('0x38'))){_0x4a9b16[_0xbd4b('0x1c')]=qs[_0xbd4b('0x1c')](_0x46dcfa[_0xbd4b('0x34')][_0xbd4b('0x1c')]);_0x4a9b16[_0xbd4b('0x1b')]=qs[_0xbd4b('0x1b')](_0x46dcfa[_0xbd4b('0x34')]['offset']);}return _0xef12d9[_0xbd4b('0xbf')](_0x4a9b16);}})[_0xbd4b('0x23')](function(_0x36f373){if(_0x36f373){return _0x36f373?{'count':_0x26ca3b,'rows':_0x36f373}:null;}})[_0xbd4b('0x23')](respondWithResult(_0x38a060,null))[_0xbd4b('0x89')](handleError(_0x38a060,null));};exports[_0xbd4b('0xc2')]=function(_0x4e9825,_0x18bc8e,_0x4b5156){if(_0x4e9825[_0xbd4b('0x91')]['id']){delete _0x4e9825[_0xbd4b('0x91')]['id'];}return db[_0xbd4b('0x28')][_0xbd4b('0x2f')]({'where':{'id':_0x4e9825[_0xbd4b('0xb4')]['id']}})['then'](handleEntityNotFound(_0x18bc8e,null))[_0xbd4b('0x23')](function(_0xd162a6){if(_0xd162a6){return _0xd162a6[_0xbd4b('0xc2')](_0x4e9825['body'][_0xbd4b('0xc3')]||[]);}return null;})[_0xbd4b('0x23')](respondWithResult(_0x18bc8e,null))[_0xbd4b('0x89')](handleError(_0x18bc8e,null));};exports['getHoppers']=function(_0x55d94f,_0x3252a7,_0x1c1e80){var _0x14301c={'raw':![],'where':{}};var _0x50e9dd={};var _0x197932={'count':0x0,'rows':[]};return db[_0xbd4b('0x28')][_0xbd4b('0x2f')]({'where':{'id':_0x55d94f[_0xbd4b('0xb4')]['id']}})[_0xbd4b('0x23')](handleEntityNotFound(_0x3252a7,null))[_0xbd4b('0x23')](function(_0x163528){if(_0x163528){_0x50e9dd['model']=_['keys'](db[_0xbd4b('0x96')][_0xbd4b('0xc4')]);_0x50e9dd['query']=_[_0xbd4b('0x2a')](_0x55d94f[_0xbd4b('0x34')]);_0x50e9dd[_0xbd4b('0x3c')]=_[_0xbd4b('0x35')](_0x50e9dd[_0xbd4b('0x37')],_0x50e9dd[_0xbd4b('0x34')]);_0x14301c[_0xbd4b('0x36')]=_[_0xbd4b('0x35')](_0x50e9dd['model'],qs[_0xbd4b('0x7d')](_0x55d94f[_0xbd4b('0x34')][_0xbd4b('0x7d')]));_0x14301c[_0xbd4b('0x36')]=_0x14301c['attributes'][_0xbd4b('0x29')]?_0x14301c[_0xbd4b('0x36')]:_0x50e9dd['model'];if(!_0x55d94f[_0xbd4b('0x34')]['hasOwnProperty'](_0xbd4b('0x38'))){_0x14301c[_0xbd4b('0x1c')]=qs['limit'](_0x55d94f['query'][_0xbd4b('0x1c')]);_0x14301c[_0xbd4b('0x1b')]=qs[_0xbd4b('0x1b')](_0x55d94f[_0xbd4b('0x34')][_0xbd4b('0x1b')]);}_0x14301c[_0xbd4b('0x74')]=qs[_0xbd4b('0x39')](_0x55d94f[_0xbd4b('0x34')][_0xbd4b('0x39')]);_0x14301c[_0xbd4b('0x3a')]=qs['filters'](_[_0xbd4b('0x3b')](_0x55d94f[_0xbd4b('0x34')],_0x50e9dd['filters']));_0x14301c[_0xbd4b('0x3a')][_0xbd4b('0xc5')]=_0x163528['id'];if(_0x55d94f[_0xbd4b('0x34')]['filter']){_0x14301c[_0xbd4b('0x3a')]=_['merge'](_0x14301c[_0xbd4b('0x3a')],{'$or':_[_0xbd4b('0x50')](_0x14301c[_0xbd4b('0x36')],function(_0x4df98d){var _0x207fe1={};_0x207fe1[_0x4df98d]={'$like':'%'+_0x55d94f['query'][_0xbd4b('0x5c')]+'%'};return _0x207fe1;})});}_0x14301c=_[_0xbd4b('0x7c')]({},_0x14301c,_0x55d94f['options']);return db[_0xbd4b('0x96')]['count']({'where':_0x14301c['where']})['then'](function(_0x675b4e){_0x197932['count']=_0x675b4e;if(_0x55d94f['query'][_0xbd4b('0xc6')]){_0x14301c[_0xbd4b('0xc7')]=[{'all':!![]}];}return db['CmHopper'][_0xbd4b('0x8d')](_0x14301c);})['then'](function(_0x4c8cc9){_0x197932[_0xbd4b('0x88')]=_0x4c8cc9;return _0x197932;});}})[_0xbd4b('0x23')](respondWithFilteredResult(_0x3252a7,_0x14301c))[_0xbd4b('0x89')](handleError(_0x3252a7,null));};exports['getHopperHistories']=function(_0x473390,_0xb5a711,_0x20a0d0){var _0x3a2863={'raw':!![],'where':{}};var _0x14aada={};var _0x5d9edf={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x473390[_0xbd4b('0xb4')]['id']}})['then'](handleEntityNotFound(_0xb5a711,null))[_0xbd4b('0x23')](function(_0xed7b01){if(_0xed7b01){_0x14aada['model']=_[_0xbd4b('0x2a')](db[_0xbd4b('0xa6')][_0xbd4b('0xc4')]);_0x14aada[_0xbd4b('0x34')]=_['keys'](_0x473390[_0xbd4b('0x34')]);_0x14aada[_0xbd4b('0x3c')]=_[_0xbd4b('0x35')](_0x14aada[_0xbd4b('0x37')],_0x14aada['query']);_0x3a2863[_0xbd4b('0x36')]=_[_0xbd4b('0x35')](_0x14aada[_0xbd4b('0x37')],qs[_0xbd4b('0x7d')](_0x473390[_0xbd4b('0x34')]['fields']));_0x3a2863[_0xbd4b('0x36')]=_0x3a2863['attributes']['length']?_0x3a2863[_0xbd4b('0x36')]:_0x14aada['model'];if(!_0x473390[_0xbd4b('0x34')]['hasOwnProperty'](_0xbd4b('0x38'))){_0x3a2863[_0xbd4b('0x1c')]=qs[_0xbd4b('0x1c')](_0x473390[_0xbd4b('0x34')][_0xbd4b('0x1c')]);_0x3a2863['offset']=qs[_0xbd4b('0x1b')](_0x473390[_0xbd4b('0x34')][_0xbd4b('0x1b')]);}_0x3a2863['order']=qs['sort'](_0x473390[_0xbd4b('0x34')][_0xbd4b('0x39')]);_0x3a2863[_0xbd4b('0x3a')]=qs[_0xbd4b('0x3c')](_[_0xbd4b('0x3b')](_0x473390[_0xbd4b('0x34')],_0x14aada[_0xbd4b('0x3c')]));_0x3a2863['where']['ContactId']=_0xed7b01['id'];if(_0x473390[_0xbd4b('0x34')]['filter']){_0x3a2863[_0xbd4b('0x3a')]=_['merge'](_0x3a2863[_0xbd4b('0x3a')],{'$or':_[_0xbd4b('0x50')](_0x3a2863[_0xbd4b('0x36')],function(_0x31d212){var _0x1e694b={};_0x1e694b[_0x31d212]={'$like':'%'+_0x473390['query'][_0xbd4b('0x5c')]+'%'};return _0x1e694b;})});}_0x3a2863=_[_0xbd4b('0x7c')]({},_0x3a2863,_0x473390['options']);return db[_0xbd4b('0xa6')][_0xbd4b('0x1a')]({'where':_0x3a2863[_0xbd4b('0x3a')]})[_0xbd4b('0x23')](function(_0x3b3df7){_0x5d9edf[_0xbd4b('0x1a')]=_0x3b3df7;if(_0x473390['query'][_0xbd4b('0xc6')]){_0x3a2863[_0xbd4b('0xc7')]=[{'all':!![]}];}return db['CmHopperHistory'][_0xbd4b('0x8d')](_0x3a2863);})['then'](function(_0x46dc9a){_0x5d9edf[_0xbd4b('0x88')]=_0x46dc9a;return _0x5d9edf;});}})[_0xbd4b('0x23')](respondWithFilteredResult(_0xb5a711,_0x3a2863))['catch'](handleError(_0xb5a711,null));};exports[_0xbd4b('0xc8')]=function(_0x5397f4,_0x543f4b,_0x13a547){var _0x28c2e9={'raw':!![],'where':{}};var _0x1b446f={};var _0x421fea={'count':0x0,'rows':[]};return db[_0xbd4b('0x28')][_0xbd4b('0x2f')]({'where':{'id':_0x5397f4['params']['id']}})['then'](handleEntityNotFound(_0x543f4b,null))[_0xbd4b('0x23')](function(_0x5bb9a1){if(_0x5bb9a1){_0x1b446f[_0xbd4b('0x37')]=_[_0xbd4b('0x2a')](db['CmHopperFinal']['rawAttributes']);_0x1b446f[_0xbd4b('0x34')]=_[_0xbd4b('0x2a')](_0x5397f4['query']);_0x1b446f[_0xbd4b('0x3c')]=_[_0xbd4b('0x35')](_0x1b446f[_0xbd4b('0x37')],_0x1b446f[_0xbd4b('0x34')]);_0x28c2e9['attributes']=_[_0xbd4b('0x35')](_0x1b446f[_0xbd4b('0x37')],qs[_0xbd4b('0x7d')](_0x5397f4[_0xbd4b('0x34')][_0xbd4b('0x7d')]));_0x28c2e9[_0xbd4b('0x36')]=_0x28c2e9[_0xbd4b('0x36')][_0xbd4b('0x29')]?_0x28c2e9['attributes']:_0x1b446f[_0xbd4b('0x37')];if(!_0x5397f4[_0xbd4b('0x34')][_0xbd4b('0x5b')]('nolimit')){_0x28c2e9[_0xbd4b('0x1c')]=qs[_0xbd4b('0x1c')](_0x5397f4['query']['limit']);_0x28c2e9['offset']=qs['offset'](_0x5397f4[_0xbd4b('0x34')][_0xbd4b('0x1b')]);}_0x28c2e9[_0xbd4b('0x74')]=qs[_0xbd4b('0x39')](_0x5397f4[_0xbd4b('0x34')]['sort']);_0x28c2e9['where']=qs[_0xbd4b('0x3c')](_['pick'](_0x5397f4[_0xbd4b('0x34')],_0x1b446f[_0xbd4b('0x3c')]));_0x28c2e9[_0xbd4b('0x3a')]['ContactId']=_0x5bb9a1['id'];if(_0x5397f4[_0xbd4b('0x34')][_0xbd4b('0x5c')]){_0x28c2e9[_0xbd4b('0x3a')]=_[_0xbd4b('0x7c')](_0x28c2e9[_0xbd4b('0x3a')],{'$or':_[_0xbd4b('0x50')](_0x28c2e9[_0xbd4b('0x36')],function(_0x73422a){var _0x288b81={};_0x288b81[_0x73422a]={'$like':'%'+_0x5397f4['query'][_0xbd4b('0x5c')]+'%'};return _0x288b81;})});}_0x28c2e9=_[_0xbd4b('0x7c')]({},_0x28c2e9,_0x5397f4[_0xbd4b('0xc1')]);return db['CmHopperFinal'][_0xbd4b('0x1a')]({'where':_0x28c2e9['where']})[_0xbd4b('0x23')](function(_0x5bbcbd){_0x421fea['count']=_0x5bbcbd;if(_0x5397f4[_0xbd4b('0x34')]['includeAll']){_0x28c2e9[_0xbd4b('0xc7')]=[{'all':!![]}];}return db['CmHopperFinal']['findAll'](_0x28c2e9);})['then'](function(_0x2beed7){_0x421fea[_0xbd4b('0x88')]=_0x2beed7;return _0x421fea;});}})[_0xbd4b('0x23')](respondWithFilteredResult(_0x543f4b,_0x28c2e9))['catch'](handleError(_0x543f4b,null));};exports[_0xbd4b('0xc9')]=function(_0x11a302,_0x533815,_0x59a130){var _0x343328={'raw':!![],'where':{}};var _0x1afa53={};var _0x13cc49={'count':0x0,'rows':[]};return db['CmContact'][_0xbd4b('0x2f')]({'where':{'id':_0x11a302[_0xbd4b('0xb4')]['id']}})['then'](handleEntityNotFound(_0x533815,null))[_0xbd4b('0x23')](function(_0x206737){if(_0x206737){_0x1afa53[_0xbd4b('0x37')]=_[_0xbd4b('0x2a')](db['JscriptySessionReport'][_0xbd4b('0xc4')]);_0x1afa53[_0xbd4b('0x34')]=_[_0xbd4b('0x2a')](_0x11a302[_0xbd4b('0x34')]);_0x1afa53['filters']=_['intersection'](_0x1afa53['model'],_0x1afa53[_0xbd4b('0x34')]);_0x343328['attributes']=_['intersection'](_0x1afa53[_0xbd4b('0x37')],qs[_0xbd4b('0x7d')](_0x11a302[_0xbd4b('0x34')]['fields']));_0x343328[_0xbd4b('0x36')]=_0x343328[_0xbd4b('0x36')][_0xbd4b('0x29')]?_0x343328[_0xbd4b('0x36')]:_0x1afa53[_0xbd4b('0x37')];if(!_0x11a302[_0xbd4b('0x34')][_0xbd4b('0x5b')](_0xbd4b('0x38'))){_0x343328[_0xbd4b('0x1c')]=qs[_0xbd4b('0x1c')](_0x11a302[_0xbd4b('0x34')]['limit']);_0x343328['offset']=qs['offset'](_0x11a302[_0xbd4b('0x34')][_0xbd4b('0x1b')]);}_0x343328[_0xbd4b('0x74')]=qs['sort'](_0x11a302[_0xbd4b('0x34')][_0xbd4b('0x39')]);_0x343328[_0xbd4b('0x3a')]=qs[_0xbd4b('0x3c')](_[_0xbd4b('0x3b')](_0x11a302[_0xbd4b('0x34')],_0x1afa53[_0xbd4b('0x3c')]));_0x343328['where'][_0xbd4b('0xc5')]=_0x206737['id'];if(_0x11a302['query'][_0xbd4b('0x5c')]){_0x343328[_0xbd4b('0x3a')]=_[_0xbd4b('0x7c')](_0x343328[_0xbd4b('0x3a')],{'$or':_[_0xbd4b('0x50')](_0x343328[_0xbd4b('0x36')],function(_0x55f845){var _0x2b4f8d={};_0x2b4f8d[_0x55f845]={'$like':'%'+_0x11a302[_0xbd4b('0x34')][_0xbd4b('0x5c')]+'%'};return _0x2b4f8d;})});}_0x343328=_['merge']({},_0x343328,_0x11a302[_0xbd4b('0xc1')]);return db[_0xbd4b('0xca')]['count']({'where':_0x343328[_0xbd4b('0x3a')]})[_0xbd4b('0x23')](function(_0x374dfe){_0x13cc49[_0xbd4b('0x1a')]=_0x374dfe;if(_0x11a302[_0xbd4b('0x34')][_0xbd4b('0xc6')]){_0x343328[_0xbd4b('0xc7')]=[{'all':!![]}];}return db[_0xbd4b('0xca')][_0xbd4b('0x8d')](_0x343328);})['then'](function(_0x26bed5){_0x13cc49[_0xbd4b('0x88')]=_0x26bed5;return _0x13cc49;});}})[_0xbd4b('0x23')](respondWithFilteredResult(_0x533815,_0x343328))[_0xbd4b('0x89')](handleError(_0x533815,null));};exports[_0xbd4b('0xcb')]=function(_0x3c1b41,_0xd0e262,_0x589cd9){try{if(!_0x3c1b41[_0xbd4b('0x91')]['ListId']){throw new Error(_0xbd4b('0xcc'));}if(!_0x3c1b41['body']['binding_keys']){throw new Error(_0xbd4b('0xcd'));}if(!_0x3c1b41[_0xbd4b('0x91')]['binding_values']){throw new Error('No\x20association\x20values\x20specified!');}if(!_0x3c1b41['body'][_0xbd4b('0xce')]){throw new Error(_0xbd4b('0xcf'));}var _0x1af8e0=_0x3c1b41['body']['binding_keys'][_0xbd4b('0x4f')](',');var _0xaeb04e=_0x3c1b41[_0xbd4b('0x91')][_0xbd4b('0xd0')][_0xbd4b('0x4f')](',');if(!_0x1af8e0[_0xbd4b('0x29')]||!_0xaeb04e[_0xbd4b('0x29')]||_0x1af8e0['length']!==_0xaeb04e['length']){throw new Error(_0xbd4b('0xd1'));}_0x3c1b41[_0xbd4b('0x91')][_0xbd4b('0x7d')]=_[_0xbd4b('0xd2')](_0x1af8e0,_0xaeb04e);if(!_0x3c1b41[_0xbd4b('0x91')]['fields'][_0xbd4b('0xbe')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x3c1b41[_0xbd4b('0x91')][_0xbd4b('0x7d')][_0xbd4b('0xd3')]){throw new Error(_0xbd4b('0xd4'));}var _0x17ad10=path['join'](config[_0xbd4b('0xd5')],_0xbd4b('0xd6'),_0x3c1b41['file'][_0xbd4b('0xd7')]);fs[_0xbd4b('0xd8')](_0x17ad10,parseInt(_0xbd4b('0xd9'),0x8));var _0x3b2872=require(_0xbd4b('0xda'))[_0xbd4b('0xdb')](path['join'](__dirname,_0xbd4b('0xdc')),[_0x17ad10,_0x3c1b41[_0xbd4b('0x91')][_0xbd4b('0xdd')],_0x3c1b41['body'][_0xbd4b('0xd0')],_0x3c1b41['body'][_0xbd4b('0xb2')],_0x3c1b41[_0xbd4b('0x91')]['CompanyId'],_0x3c1b41[_0xbd4b('0x91')][_0xbd4b('0xb0')],_0x3c1b41[_0xbd4b('0x91')][_0xbd4b('0xce')]]);return _0xd0e262['status'](0xc8)[_0xbd4b('0x19')]({'message':_0xbd4b('0xde'),'pid':_0x3b2872[_0xbd4b('0xdf')]});}catch(_0x5675fd){return _0xd0e262[_0xbd4b('0x18')](0x1f4)[_0xbd4b('0x26')](_0x5675fd);}};exports[_0xbd4b('0xe0')]=function(_0x25a286,_0x3defee,_0x5424df){var _0x275950=fs[_0xbd4b('0xe1')](_0x25a286[_0xbd4b('0xe2')]['path']);Papa[_0xbd4b('0xe3')](_0x275950,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x2a4ab2){return _0x3defee[_0xbd4b('0x18')](0xc8)[_0xbd4b('0x19')]({'file':_0x25a286[_0xbd4b('0xe2')],'fields':_0x2a4ab2[_0xbd4b('0xe4')][_0xbd4b('0x7d')]});}});};exports[_0xbd4b('0xe5')]=function(_0x4e47f1,_0x177b4a,_0x55f96f){return db['User'][_0xbd4b('0x8d')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0xbd4b('0x23')](function(_0x16853a){var _0x20d08d=![];if(!_0x4e47f1[_0xbd4b('0x91')]['ListId']){throw new Error(_0xbd4b('0xcc'));}if(!_0x4e47f1[_0xbd4b('0x91')][_0xbd4b('0xe6')]['phone']){throw new Error(_0xbd4b('0xe7'));}if(!_0x4e47f1[_0xbd4b('0x91')][_0xbd4b('0xe6')][_0xbd4b('0xd3')]){throw new Error(_0xbd4b('0xd4'));}if(!_0x4e47f1[_0xbd4b('0x91')][_0xbd4b('0xce')]){throw new Error(_0xbd4b('0xcf'));}var _0x1ab0de=require(_0xbd4b('0xda'))['fork'](path['join'](__dirname,_0xbd4b('0xe8')),[_0x4e47f1['params']['id'],JSON[_0xbd4b('0xe9')](_0x4e47f1['body']),JSON[_0xbd4b('0xe9')](_0x16853a)]);_0x1ab0de['on'](_0xbd4b('0xea'),function(_0x1e4be9){_0x20d08d=!![];return _0x177b4a[_0xbd4b('0x18')](0xc8)[_0xbd4b('0x19')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x1ab0de[_0xbd4b('0xdf')]});});_0x1ab0de['on']('exit',function(_0x18c4fd){if(_0x18c4fd&&!_0x20d08d){return _0x177b4a[_0xbd4b('0x18')](0x1f4)[_0xbd4b('0x19')]({'message':_0xbd4b('0xeb'),'pid':_0x1ab0de['pid']});}});})[_0xbd4b('0x89')](handleError(_0x177b4a,null));};
\ No newline at end of file
+var _0xc4a6=['zip-dir','fast-json-patch','request-promise','moment','util','to-csv','lodash','squel','querystring','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/environment','../../mysqldb','redis','defaults','localhost','./cmContact.socket','register','sendStatus','status','end','json','count','offset','set','Content-Range','reject','save','update','then','destroy','error','stack','name','index','describe','keys','cf_','findOne','trimStart','all','length','fieldType','type','query','filters','intersection','attributes','model','fields','nolimit','limit','order','sort','where','select','field','color','from','cm_user_has_contacts','left_join','tools_tags','expr','parseSearch','search','sqlOperator','conditions','find','Tag','value','forEach','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','union','and','dateOfBirth','datetime','castTo','DATE','text','start','map','filter','Contact','push','ListId','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','isArray','tag','replace','\x27\x27\x27\x27','split','getFullTextValue','isNumeric','c.id\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','group','c.id','Sequelize','QueryTypes','clone','DESC','isEmpty','t.id\x20IN\x20?','resolve','some','user','getLists','c.ListId\x20IS\x20NULL','c.ListId\x20IN\x20?','sequelize','toString','keyBy','merge','c.firstName','c.phone','c.mobile','c.fax','c.email','c.ListId','c.deletedAt','TagIds','Tags','catch','params','CmContact','startsWith','columnName','displayName','findAll','alias','values','hasOwnProperty','body','get','mergeWith','tags','join','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','info','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','FaxMessage','CmHopperFinal','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','bulkCreate','each','duplicates','$or','findOrCreate','show','omit','cf_%d','$and','pickBy','format','table','cm_contacts','setFields','id\x20=\x20?','toParam','phone','getTags','rawAttributes','pick','options','setTags','ids','includeAll','include','rows','getHopperHistories','CmHopperHistory','getHopperFinals','ContactId','getJscriptySessions','JscriptySessionReport','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','filename','chmodSync','child_process','../../components/import/cm/csv','CompanyId','socket_timestamp','File\x20uploaded\x20correctly!','pid','send','createReadStream','path','file','User','binding','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','fork','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','exit','html-pdf','eml-format','rimraf'];(function(_0x4a2841,_0x272a54){var _0x440853=function(_0x10c364){while(--_0x10c364){_0x4a2841['push'](_0x4a2841['shift']());}};_0x440853(++_0x272a54);}(_0xc4a6,0x1c5));var _0x6c4a=function(_0x3ab0ac,_0x1ea9cf){_0x3ab0ac=_0x3ab0ac-0x0;var _0x1f743d=_0xc4a6[_0x3ab0ac];return _0x1f743d;};'use strict';var pdf=require(_0x6c4a('0x0'));var emlformat=require(_0x6c4a('0x1'));var rimraf=require(_0x6c4a('0x2'));var zipdir=require(_0x6c4a('0x3'));var jsonpatch=require(_0x6c4a('0x4'));var rp=require(_0x6c4a('0x5'));var moment=require(_0x6c4a('0x6'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x6c4a('0x7'));var path=require('path');var sox=require('sox');var csv=require(_0x6c4a('0x8'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x6c4a('0x9'));var squel=require(_0x6c4a('0xa'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x6c4a('0x8'));var querystring=require(_0x6c4a('0xb'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x6c4a('0xc'));var qs=require(_0x6c4a('0xd'));var as=require(_0x6c4a('0xe'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')('api');var utils=require('../../config/utils');var config=require(_0x6c4a('0xf'));var db=require(_0x6c4a('0x10'))['db'];config[_0x6c4a('0x11')]=_[_0x6c4a('0x12')](config['redis'],{'host':_0x6c4a('0x13'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x6c4a('0x11')]));require(_0x6c4a('0x14'))[_0x6c4a('0x15')](socket);function respondWithStatusCode(_0x1d2070,_0x31c8b7){_0x31c8b7=_0x31c8b7||0xcc;return function(_0x14ef9e){if(_0x14ef9e){return _0x1d2070[_0x6c4a('0x16')](_0x31c8b7);}return _0x1d2070[_0x6c4a('0x17')](_0x31c8b7)[_0x6c4a('0x18')]();};}function respondWithResult(_0x208f95,_0x3f9207){_0x3f9207=_0x3f9207||0xc8;return function(_0x315a95){if(_0x315a95){return _0x208f95[_0x6c4a('0x17')](_0x3f9207)[_0x6c4a('0x19')](_0x315a95);}};}function respondWithFilteredResult(_0x2932f4,_0x188a5b){return function(_0x398b95){if(_0x398b95){var _0x223790=_0x398b95[_0x6c4a('0x1a')],_0x1a539a=_0x188a5b[_0x6c4a('0x1b')],_0x5c8428=_0x188a5b[_0x6c4a('0x1b')]+_0x188a5b['limit'],_0x2bb0fd;if(_0x5c8428>=_0x223790){_0x5c8428=_0x223790;_0x2bb0fd=0xc8;}else{_0x2bb0fd=0xce;}_0x2932f4[_0x6c4a('0x17')](_0x2bb0fd);return _0x2932f4[_0x6c4a('0x1c')](_0x6c4a('0x1d'),_0x1a539a+'-'+_0x5c8428+'/'+_0x223790)[_0x6c4a('0x19')](_0x398b95);}return null;};}function patchUpdates(_0x59f29e){return function(_0xb26b3d){try{jsonpatch['apply'](_0xb26b3d,_0x59f29e,!![]);}catch(_0x43442f){return BPromise[_0x6c4a('0x1e')](_0x43442f);}return _0xb26b3d[_0x6c4a('0x1f')]();};}function saveUpdates(_0x5902fd,_0x2c472b){return function(_0x4573c8){if(_0x4573c8){return _0x4573c8[_0x6c4a('0x20')](_0x5902fd)[_0x6c4a('0x21')](function(_0x3024c6){return _0x3024c6;});}return null;};}function removeEntity(_0x174847,_0x6f4925){return function(_0x13341c){if(_0x13341c){return _0x13341c[_0x6c4a('0x22')]()[_0x6c4a('0x21')](function(){_0x174847[_0x6c4a('0x17')](0xcc)[_0x6c4a('0x18')]();});}};}function handleEntityNotFound(_0x4d7795,_0x44b8a2){return function(_0x27f7b5){if(!_0x27f7b5){_0x4d7795[_0x6c4a('0x16')](0x194);}return _0x27f7b5;};}function handleError(_0x17b908,_0x59b2ae){_0x59b2ae=_0x59b2ae||0x1f4;return function(_0x254fcf){logger[_0x6c4a('0x23')](_0x254fcf[_0x6c4a('0x24')]);if(_0x254fcf[_0x6c4a('0x25')]){delete _0x254fcf[_0x6c4a('0x25')];}_0x17b908['status'](_0x59b2ae)['send'](_0x254fcf);};}exports[_0x6c4a('0x26')]=function(_0xf00191,_0x4a1374){var _0xa4254f={},_0x22990b={},_0x557b6d={'count':0x0,'rows':[]};return db['CmContact'][_0x6c4a('0x27')]()[_0x6c4a('0x21')](function(_0x13d884){var _0xd98de8=[];for(var _0xe61dad=0x0;_0xe61dad<Object[_0x6c4a('0x28')](_0x13d884)['length'];_0xe61dad++){var _0x1f0d17=Object[_0x6c4a('0x28')](_0x13d884)[_0xe61dad];if(_['startsWith'](_0x1f0d17,_0x6c4a('0x29'))){_0xd98de8['push'](db['CmCustomField'][_0x6c4a('0x2a')]({'where':{'id':_[_0x6c4a('0x2b')](_0x1f0d17,_0x6c4a('0x29'))},'raw':!![]}));}}return BPromise[_0x6c4a('0x2c')](_0xd98de8)[_0x6c4a('0x21')](function(_0x5e30b2){for(var _0x1fea81=0x0;_0x1fea81<_0x5e30b2[_0x6c4a('0x2d')];_0x1fea81++){if(_0x5e30b2[_0x1fea81]){var _0x17839a=_0x6c4a('0x29')+_0x5e30b2[_0x1fea81]['id'];var _0x43fbed=_0x13d884[_0x17839a];_0x43fbed[_0x6c4a('0x2e')]=_0x5e30b2[_0x1fea81][_0x6c4a('0x2f')];}}return _0x13d884;});})[_0x6c4a('0x21')](function(_0x1c2011){_0x22990b['model']=_[_0x6c4a('0x28')](_0x1c2011);_0x22990b[_0x6c4a('0x30')]=_[_0x6c4a('0x28')](_0xf00191[_0x6c4a('0x30')]);_0x22990b[_0x6c4a('0x31')]=_[_0x6c4a('0x32')](_0x22990b['model'],_0x22990b[_0x6c4a('0x30')]);_0xa4254f[_0x6c4a('0x33')]=_['intersection'](_0x22990b[_0x6c4a('0x34')],qs[_0x6c4a('0x35')](_0xf00191[_0x6c4a('0x30')][_0x6c4a('0x35')]));_0xa4254f[_0x6c4a('0x33')]=_0xa4254f[_0x6c4a('0x33')][_0x6c4a('0x2d')]?_0xa4254f[_0x6c4a('0x33')]:_0x22990b[_0x6c4a('0x34')];if(!_0xf00191[_0x6c4a('0x30')]['hasOwnProperty'](_0x6c4a('0x36'))){_0xa4254f[_0x6c4a('0x37')]=qs[_0x6c4a('0x37')](_0xf00191[_0x6c4a('0x30')][_0x6c4a('0x37')]);_0xa4254f['offset']=qs['offset'](_0xf00191['query'][_0x6c4a('0x1b')]);}_0xa4254f[_0x6c4a('0x38')]=qs[_0x6c4a('0x39')](_0xf00191[_0x6c4a('0x30')][_0x6c4a('0x39')]);_0xa4254f[_0x6c4a('0x3a')]=qs['filters'](_['pick'](_0xf00191['query'],_0x22990b['filters']),_0x1c2011);var _0xa336f5=[];var _0x24d18d=squel[_0x6c4a('0x3b')]()[_0x6c4a('0x3c')]('id')[_0x6c4a('0x3c')]('name')[_0x6c4a('0x3c')](_0x6c4a('0x3d'))[_0x6c4a('0x3e')]('tools_tags');var _0x163e62=squel[_0x6c4a('0x3b')]()['from']('cm_contacts','c')['left_join'](_0x6c4a('0x3f'),'uc','uc.CmContactId\x20=\x20c.id')[_0x6c4a('0x40')]('cm_contact_has_tags','ct','ct.CmContactId\x20=\x20c.id')[_0x6c4a('0x40')](_0x6c4a('0x41'),'t','t.id\x20=\x20ct.TagId')[_0x6c4a('0x3a')]('c.deletedAt\x20IS\x20NULL');var _0x58459c=squel[_0x6c4a('0x42')]();var _0x5ba3b8=[];var _0x4ef6a3=squel[_0x6c4a('0x42')]();var _0x5f0a3b;if(_0xf00191[_0x6c4a('0x30')]['search']){_0x5f0a3b=as[_0x6c4a('0x43')](_0xf00191[_0x6c4a('0x30')][_0x6c4a('0x44')]);var _0x40cb6c=_0x5f0a3b[_0x6c4a('0x45')];for(var _0x191e59=0x0;_0x191e59<_0x5f0a3b[_0x6c4a('0x46')][_0x6c4a('0x2d')];_0x191e59++){var _0xd254ec=_0x5f0a3b[_0x6c4a('0x46')][_0x191e59];var _0x4931ee='c';var _0x220ec2=_(_0x1c2011)[_0x6c4a('0x28')]()[_0x6c4a('0x47')](function(_0x3521d6){return _0x3521d6===_0xd254ec['field'];});if(_0x220ec2)_0x220ec2=_0x1c2011[_0xd254ec[_0x6c4a('0x3c')]];if(!_0x220ec2){if(_0xd254ec[_0x6c4a('0x3c')]===_0x6c4a('0x48')){var _0x483077=_0xd254ec[_0x6c4a('0x49')]['split'](',')['map'](function(_0x25cf31){return Number(_0x25cf31);});_0x483077[_0x6c4a('0x4a')](function(_0x26049f){_0x4ef6a3['or'](_0x6c4a('0x4b'),'%,'+_0x26049f+',%');});_0x5ba3b8=_[_0x6c4a('0x4c')](_0x5ba3b8,_0x483077);}else if(_0xd254ec['field']==='User'){_0x58459c[_0x6c4a('0x4d')]('uc.UserId\x20=\x20?',_0xd254ec[_0x6c4a('0x49')]);}}else{if(_0xd254ec[_0x6c4a('0x3c')]===_0x6c4a('0x4e')||_0x220ec2[_0x6c4a('0x2e')]===_0x6c4a('0x4f'))_0xd254ec[_0x6c4a('0x50')]=_0x6c4a('0x51');var _0x589c78=as['buildExpression'](_0x4931ee,_0x220ec2['type'],_0xd254ec);_0x58459c[_0x40cb6c](_0x589c78[_0x6c4a('0x52')],_0x589c78['value'][_0x6c4a('0x53')],_0x589c78[_0x6c4a('0x49')]['end']);}}}else{var _0x3f472a=_(Object[_0x6c4a('0x28')](_0xf00191[_0x6c4a('0x30')]))[_0x6c4a('0x54')](function(_0x13bfd5){return _0x1c2011['hasOwnProperty'](_0x13bfd5)?_0x13bfd5:undefined;})[_0x6c4a('0x55')](function(_0xe288b4){return!_['isNil'](_0xe288b4);})[_0x6c4a('0x49')]();if(_0xf00191['query'][_0x6c4a('0x56')])_0x3f472a[_0x6c4a('0x57')](_0x6c4a('0x56'));if(!_['isEmpty'](_0x3f472a)){_0x3f472a[_0x6c4a('0x4a')](function(_0x239c37){if(_0x239c37===_0x6c4a('0x58')){_0x163e62['where']('c.ListId\x20IN\x20?',[]['concat'](_0xf00191[_0x6c4a('0x30')][_0x239c37]));}else if(_0x239c37==='Contact'){var _0x1a30c6='%'+_0xf00191[_0x6c4a('0x30')][_0x239c37]+'%';_0x163e62[_0x6c4a('0x3a')](_0x6c4a('0x59'),_0x1a30c6);}else{_0x163e62[_0x6c4a('0x3a')]('c.'+_0x239c37+'\x20=\x20?',_0xf00191['query'][_0x239c37]);}});}if(_0xf00191['query']['tag']){_0x5ba3b8=_[_0x6c4a('0x5a')](_0xf00191[_0x6c4a('0x30')][_0x6c4a('0x5b')])?_0xf00191[_0x6c4a('0x30')]['tag']:new Array(_0xf00191[_0x6c4a('0x30')][_0x6c4a('0x5b')]);_0x5ba3b8[_0x6c4a('0x4a')](function(_0x3f375b){_0x4ef6a3['or'](_0x6c4a('0x4b'),'%,'+_0x3f375b+',%');});}if(_0xf00191[_0x6c4a('0x30')][_0x6c4a('0x55')]){var _0x346990=_0xf00191[_0x6c4a('0x30')][_0x6c4a('0x55')][_0x6c4a('0x5c')]('\x5c','\x5c\x5c')[_0x6c4a('0x5c')]('\x27\x27',_0x6c4a('0x5d'));if(_0x346990[_0x6c4a('0x5e')]('\x20')[_0x6c4a('0x2d')]>0x1){_0x58459c['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x6c4a('0x5f')](_0x346990),null);}else{if(qs[_0x6c4a('0x60')](_0x346990)){_0x58459c['or'](_0x6c4a('0x61'),_0x346990+'%');_0x58459c['or']('c.phone\x20LIKE\x20?',_0x346990+'%');_0x58459c['or'](_0x6c4a('0x62'),_0x346990+'%');_0x58459c['or'](_0x6c4a('0x63'),_0x346990+'%');}else if(qs[_0x6c4a('0x64')](_0x346990)){_0x58459c['or']('c.email\x20LIKE\x20?',_0x346990+'%');}else{_0x58459c['or']('c.firstName\x20LIKE\x20?','%'+_0x346990+'%');_0x58459c['or']('c.lastName\x20LIKE\x20?','%'+_0x346990+'%');_0x58459c['or'](_0x6c4a('0x65'),'%'+_0x346990+'%');}}}}_0x163e62['where'](_0x58459c);_0x163e62[_0x6c4a('0x66')](_0x6c4a('0x67'));var _0x63eef8={'type':db[_0x6c4a('0x68')][_0x6c4a('0x69')]['SELECT'],'raw':!![]};var _0x214a61=_0x163e62[_0x6c4a('0x6a')]()[_0x6c4a('0x3c')](_0x6c4a('0x67'));if(_0xa4254f[_0x6c4a('0x38')]){_0xa4254f[_0x6c4a('0x38')][_0x6c4a('0x4a')](function(_0x37c654){_0x163e62[_0x6c4a('0x38')]('c.'+_0x37c654[0x0],_0x37c654[0x1]===_0x6c4a('0x6b')?![]:!![]);});}if(!_[_0x6c4a('0x6c')](_0x5ba3b8)){_0x163e62['having'](_0x4ef6a3);_0x214a61[_0x6c4a('0x3a')](_0x6c4a('0x6d'),_0x5ba3b8);}BPromise[_0x6c4a('0x6e')]()['then'](function(){if(_0x5f0a3b&&!_[_0x6c4a('0x6f')](_0x5f0a3b['conditions'],[_0x6c4a('0x3c'),'User'])){return _0xf00191[_0x6c4a('0x70')][_0x6c4a('0x71')]({'attributes':['id'],'raw':!![]})['then'](function(_0x1c5977){if(_[_0x6c4a('0x6c')](_0x1c5977)){_0x214a61[_0x6c4a('0x3a')](_0x6c4a('0x72'));_0x163e62[_0x6c4a('0x3a')](_0x6c4a('0x72'));}else{_0x214a61[_0x6c4a('0x3a')](_0x6c4a('0x73'),_['map'](_0x1c5977,'id'));_0x163e62[_0x6c4a('0x3a')](_0x6c4a('0x73'),_['map'](_0x1c5977,'id'));}});}else{return;}})[_0x6c4a('0x21')](function(){db[_0x6c4a('0x74')][_0x6c4a('0x30')](_0x214a61[_0x6c4a('0x75')](),_0x63eef8)[_0x6c4a('0x21')](function(_0x24d750){_0x557b6d[_0x6c4a('0x1a')]=_0x24d750['length'];if(_0x557b6d[_0x6c4a('0x1a')]===0x0)return[];return db[_0x6c4a('0x74')][_0x6c4a('0x30')](_0x24d18d[_0x6c4a('0x75')](),_0x63eef8);})['then'](function(_0x146e50){_0xa336f5=_[_0x6c4a('0x76')](_0x146e50,'id');_0x63eef8=_[_0x6c4a('0x77')](_0x63eef8,{'model':db['CmContact'],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0xf00191[_0x6c4a('0x30')]['fields']){_0xa4254f[_0x6c4a('0x33')][_0x6c4a('0x4a')](function(_0xc068c2){_0x163e62[_0x6c4a('0x3c')]('c.'+_0xc068c2);});}else{_0x163e62['field'](_0x6c4a('0x67'));_0x163e62[_0x6c4a('0x3c')](_0x6c4a('0x78'));_0x163e62[_0x6c4a('0x3c')]('c.lastName');_0x163e62['field'](_0x6c4a('0x79'));_0x163e62[_0x6c4a('0x3c')](_0x6c4a('0x7a'));_0x163e62[_0x6c4a('0x3c')](_0x6c4a('0x7b'));_0x163e62[_0x6c4a('0x3c')](_0x6c4a('0x7c'));_0x163e62[_0x6c4a('0x3c')](_0x6c4a('0x7d'));_0x163e62[_0x6c4a('0x3c')](_0x6c4a('0x7e'));_0x163e62[_0x6c4a('0x3c')]('GROUP_CONCAT(DISTINCT\x20t.id)','TagIds');}if(_0xa4254f[_0x6c4a('0x37')])_0x163e62['limit'](_0xa4254f[_0x6c4a('0x37')]);if(_0xa4254f[_0x6c4a('0x1b')])_0x163e62[_0x6c4a('0x1b')](_0xa4254f[_0x6c4a('0x1b')]);return db['sequelize']['query'](_0x163e62[_0x6c4a('0x75')](),_0x63eef8);})[_0x6c4a('0x21')](function(_0x2f7908){_0x2f7908[_0x6c4a('0x4a')](function(_0x4e46cd){if(_0x4e46cd[_0x6c4a('0x7f')]){_0x4e46cd[_0x6c4a('0x80')]=[];_0x4e46cd[_0x6c4a('0x7f')][_0x6c4a('0x5e')](',')[_0x6c4a('0x4a')](function(_0x35a23f){_0x4e46cd[_0x6c4a('0x80')][_0x6c4a('0x57')](_0xa336f5[_0x35a23f]);});}delete _0x4e46cd[_0x6c4a('0x7f')];});_0x557b6d['rows']=_0x2f7908;return _0x557b6d;})[_0x6c4a('0x21')](respondWithFilteredResult(_0x4a1374,_0xa4254f));});})[_0x6c4a('0x81')](handleError(_0x4a1374,null));};exports[_0x6c4a('0x22')]=function(_0x27bdad,_0xd8f0e4){return db['CmContact']['find']({'where':{'id':_0x27bdad[_0x6c4a('0x82')]['id']}})[_0x6c4a('0x21')](handleEntityNotFound(_0xd8f0e4,null))[_0x6c4a('0x21')](removeEntity(_0xd8f0e4,null))[_0x6c4a('0x81')](handleError(_0xd8f0e4,null));};exports[_0x6c4a('0x27')]=function(_0x13c13a,_0x35062d){return db[_0x6c4a('0x83')][_0x6c4a('0x27')]()['then'](function(_0x13e553){delete _0x13e553['tags'];for(var _0x1b6ce4=0x0;_0x1b6ce4<Object[_0x6c4a('0x28')](_0x13e553)[_0x6c4a('0x2d')];_0x1b6ce4++){var _0xda3e48=Object[_0x6c4a('0x28')](_0x13e553)[_0x1b6ce4];if(!_[_0x6c4a('0x84')](_0xda3e48,_0x6c4a('0x29'))){_0x13e553[_0xda3e48][_0x6c4a('0x85')]=_0xda3e48;_0x13e553[_0xda3e48][_0x6c4a('0x86')]=_0xda3e48;}}return _0x13e553;})[_0x6c4a('0x21')](function(_0xab62a){var _0x6e3250={'where':{'$or':[{'ListId':_0x13c13a[_0x6c4a('0x30')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0x6c4a('0x87')](_0x6e3250)[_0x6c4a('0x21')](function(_0x9c7569){for(var _0x5cd715=0x0;_0x5cd715<_0x9c7569[_0x6c4a('0x2d')];_0x5cd715++){var _0x23a4b3=_0x6c4a('0x29')+_0x9c7569[_0x5cd715]['id'];_0xab62a[_0x23a4b3][_0x6c4a('0x85')]=_0x23a4b3;_0xab62a[_0x23a4b3]['displayName']=_0x9c7569[_0x5cd715][_0x6c4a('0x88')];_0xab62a[_0x23a4b3]['custom']={'type':_0x9c7569[_0x5cd715][_0x6c4a('0x2f')],'values':_0x9c7569[_0x5cd715][_0x6c4a('0x89')]};}Object['keys'](_0xab62a)['forEach'](function(_0x359e0b){if(!_0xab62a[_0x359e0b][_0x6c4a('0x8a')](_0x6c4a('0x85'))){delete _0xab62a[_0x359e0b];}});return _0xab62a;});})['then'](respondWithResult(_0x35062d,null))[_0x6c4a('0x81')](handleError(_0x35062d,null));};exports[_0x6c4a('0x77')]=function(_0x228aa4,_0x1e3949){var _0x396b19;var _0x51dffd;var _0x3188e4;if(_0x228aa4[_0x6c4a('0x8b')]['id']){delete _0x228aa4[_0x6c4a('0x8b')]['id'];}return db[_0x6c4a('0x83')][_0x6c4a('0x87')]({'where':{'id':[_0x228aa4[_0x6c4a('0x8b')]['to'],_0x228aa4[_0x6c4a('0x8b')]['from']]}})['then'](function(_0x59518f){if(_0x59518f){if(_0x59518f[_0x6c4a('0x2d')]!==0x2){return null;}_0x59518f[0x0]=_0x59518f[0x0]['get']({'plain':!![]});_0x59518f[0x1]=_0x59518f[0x1][_0x6c4a('0x8c')]({'plain':!![]});delete _0x59518f[0x0]['id'];delete _0x59518f[0x1]['id'];return _[_0x6c4a('0x8d')](_0x59518f[0x0],_0x59518f[0x1],function(_0x23901f,_0x53d5a3){if(Array['isArray'](_0x53d5a3)&&!_0x53d5a3[_0x6c4a('0x2d')]){return _0x23901f;}else if(!_0x53d5a3){return _0x23901f;}});}})[_0x6c4a('0x21')](handleEntityNotFound(_0x1e3949,null))[_0x6c4a('0x21')](function(_0x1db55d){if(_0x1db55d){if(_0x1db55d[_0x6c4a('0x8e')]&&_[_0x6c4a('0x5a')](_0x1db55d[_0x6c4a('0x8e')])){_0x1db55d[_0x6c4a('0x8e')]=_0x1db55d['tags'][_0x6c4a('0x8f')]();}logger['info'](_0x6c4a('0x90'),_0x228aa4[_0x6c4a('0x8b')]['to'],_0x228aa4[_0x6c4a('0x8b')][_0x6c4a('0x3e')]);return db[_0x6c4a('0x91')]['destroy']({'where':{'ContactId':[_0x228aa4[_0x6c4a('0x8b')]['to'],_0x228aa4[_0x6c4a('0x8b')]['from']]}})['then'](function(_0x47c1c6){logger['info'](_0x6c4a('0x92'),_0x47c1c6);return db['CmHopperBlack'][_0x6c4a('0x22')]({'where':{'ContactId':[_0x228aa4[_0x6c4a('0x8b')]['to'],_0x228aa4[_0x6c4a('0x8b')][_0x6c4a('0x3e')]]}})[_0x6c4a('0x21')](function(_0x5cab9e){logger[_0x6c4a('0x93')](_0x6c4a('0x94'),_0x5cab9e);return db['CmContact'][_0x6c4a('0x95')](_0x1db55d);});});}})['then'](function(_0x2e2491){if(_0x2e2491){_0x396b19=_0x2e2491;_0x51dffd={'ContactId':_0x396b19['id']};_0x3188e4={'where':{'ContactId':[_0x228aa4[_0x6c4a('0x8b')]['to'],_0x228aa4['body'][_0x6c4a('0x3e')]]}};return db[_0x6c4a('0x96')][_0x6c4a('0x20')](_0x51dffd,_0x3188e4);}})['then'](function(){if(_0x396b19){return db[_0x6c4a('0x97')]['update'](_0x51dffd,_0x3188e4);}})['then'](function(){if(_0x396b19){return db[_0x6c4a('0x98')][_0x6c4a('0x20')](_0x51dffd,_0x3188e4);}})['then'](function(){if(_0x396b19){return db[_0x6c4a('0x99')]['update'](_0x51dffd,_0x3188e4);}})[_0x6c4a('0x21')](function(){if(_0x396b19){return db[_0x6c4a('0x9a')][_0x6c4a('0x20')](_0x51dffd,_0x3188e4);}})[_0x6c4a('0x21')](function(){if(_0x396b19){return db['MailInteraction'][_0x6c4a('0x20')](_0x51dffd,_0x3188e4);}})['then'](function(){if(_0x396b19){return db['MailMessage'][_0x6c4a('0x20')](_0x51dffd,_0x3188e4);}})[_0x6c4a('0x21')](function(){if(_0x396b19){return db[_0x6c4a('0x9b')][_0x6c4a('0x20')](_0x51dffd,_0x3188e4);}})[_0x6c4a('0x21')](function(){if(_0x396b19){return db['SmsMessage']['update'](_0x51dffd,_0x3188e4);}})[_0x6c4a('0x21')](function(){if(_0x396b19){return db['FaxInteraction'][_0x6c4a('0x20')](_0x51dffd,_0x3188e4);}})['then'](function(){if(_0x396b19){return db[_0x6c4a('0x9c')][_0x6c4a('0x20')](_0x51dffd,_0x3188e4);}})[_0x6c4a('0x21')](function(){if(_0x396b19){return db['OpenchannelInteraction'][_0x6c4a('0x20')](_0x51dffd,_0x3188e4);}})[_0x6c4a('0x21')](function(){if(_0x396b19){return db['OpenchannelMessage'][_0x6c4a('0x20')](_0x51dffd,_0x3188e4);}})[_0x6c4a('0x21')](function(){if(_0x396b19){return db[_0x6c4a('0x9d')]['update'](_0x51dffd,_0x3188e4);}})[_0x6c4a('0x21')](function(){if(_0x396b19){return db['CmHopperHistory'][_0x6c4a('0x20')](_0x51dffd,_0x3188e4);}})['then'](function(){if(_0x396b19){return db['ReportAgentPreview'][_0x6c4a('0x20')](_0x51dffd,_0x3188e4);}})[_0x6c4a('0x21')](function(){if(_0x396b19){return db['VoiceCallReport']['update'](_0x51dffd,_0x3188e4);}})['then'](function(){if(_0x396b19){return db[_0x6c4a('0x9e')][_0x6c4a('0x20')](_0x51dffd,_0x3188e4);}})[_0x6c4a('0x21')](function(){if(_0x396b19){return db[_0x6c4a('0x9f')][_0x6c4a('0x20')](_0x51dffd,_0x3188e4);}})[_0x6c4a('0x21')](function(){if(_0x396b19){return db[_0x6c4a('0xa0')]['update'](_0x51dffd,_0x3188e4);}})[_0x6c4a('0x21')](function(){if(_0x396b19){return db[_0x6c4a('0xa1')][_0x6c4a('0x20')](_0x51dffd,_0x3188e4);}})['then'](function(){if(_0x396b19){return db['SmsQueueReport']['update'](_0x51dffd,_0x3188e4);}})[_0x6c4a('0x21')](function(){if(_0x396b19){return db['JscriptySessionReport'][_0x6c4a('0x20')](_0x51dffd,_0x3188e4);}})[_0x6c4a('0x21')](function(){if(_0x396b19){return db['CmContact']['destroy']({'where':{'id':[_0x228aa4[_0x6c4a('0x8b')]['to'],_0x228aa4[_0x6c4a('0x8b')][_0x6c4a('0x3e')]]}});}})[_0x6c4a('0x21')](function(){if(_0x396b19){return _0x396b19;}})[_0x6c4a('0x21')](respondWithResult(_0x1e3949,null))['catch'](handleError(_0x1e3949,null));};exports['create']=function(_0x5836df,_0x3d8a19){return db[_0x6c4a('0x83')][_0x6c4a('0x27')]()['then'](function(_0x5c6bb9){if(_0x5836df[_0x6c4a('0x8b')][_0x6c4a('0x8e')]&&_['isArray'](_0x5836df[_0x6c4a('0x8b')][_0x6c4a('0x8e')])){if(_0x5836df[_0x6c4a('0x8b')]['tags']['length']){_0x5836df[_0x6c4a('0x8b')][_0x6c4a('0x8e')]=_0x5836df['body'][_0x6c4a('0x8e')][_0x6c4a('0x8f')](';')+';';}else{_0x5836df[_0x6c4a('0x8b')][_0x6c4a('0x8e')]=null;}}else{_0x5836df[_0x6c4a('0x8b')][_0x6c4a('0x8e')]=null;}return db[_0x6c4a('0x83')][_0x6c4a('0x95')](_0x5836df[_0x6c4a('0x8b')],{'fields':_[_0x6c4a('0x28')](_0x5c6bb9),'raw':!![]});})[_0x6c4a('0x21')](respondWithResult(_0x3d8a19,0xc9))[_0x6c4a('0x81')](handleError(_0x3d8a19,null));};exports[_0x6c4a('0xa2')]=function(_0x3bfbc3,_0x1b8265){var _0x567229=[];var _0x525392=0x0;var _0x1dc95d=0x0;var _0x263a62=0x0;return db[_0x6c4a('0x83')][_0x6c4a('0x27')]()[_0x6c4a('0x21')](function(_0x36a7ee){return BPromise[_0x6c4a('0xa3')](_0x3bfbc3[_0x6c4a('0x8b')],function(_0x2f437c){var _0x5a6609={'where':{'$or':[]},'defaults':_0x2f437c,'fields':_[_0x6c4a('0x28')](_0x36a7ee),'raw':!![]};if(_0x2f437c[_0x6c4a('0xa4')]){for(var _0x541a4f=0x0;_0x541a4f<_0x2f437c[_0x6c4a('0xa4')][_0x6c4a('0x2d')];_0x541a4f++){var _0x58aa65={};_0x58aa65[_0x2f437c[_0x6c4a('0xa4')][_0x541a4f]]=_0x2f437c[_0x2f437c[_0x6c4a('0xa4')][_0x541a4f]];_0x5a6609[_0x6c4a('0x3a')][_0x6c4a('0xa5')]['push'](_0x58aa65);}_0x5a6609[_0x6c4a('0x3a')][_0x6c4a('0x58')]=_0x2f437c[_0x6c4a('0x58')];}return db[_0x6c4a('0x83')][_0x6c4a('0xa6')](_0x5a6609)['spread'](function(_0x2656f3,_0x40daf6){if(_0x40daf6){_0x525392++;}else{_0x263a62++;}})['catch'](function(_0x2e9bc4){console[_0x6c4a('0x23')](_0x2e9bc4);_0x1dc95d++;});});})[_0x6c4a('0x21')](function(_0x243b13){if(_0x243b13){return{'success':_0x525392,'failure':_0x1dc95d,'duplicates':_0x263a62};}})[_0x6c4a('0x21')](respondWithResult(_0x1b8265,0xc9))[_0x6c4a('0x81')](handleError(_0x1b8265,null));};exports[_0x6c4a('0xa7')]=function(_0x1df83e,_0x489e8b,_0x7fece4){var _0x1f03c3;return db[_0x6c4a('0x83')][_0x6c4a('0x27')]()[_0x6c4a('0x21')](function(_0xee1379){return db[_0x6c4a('0x83')]['find']({'where':{'id':_0x1df83e['params']['id']},'include':[{'model':db[_0x6c4a('0x48')],'as':_0x6c4a('0x80'),'attributes':['id',_0x6c4a('0x25'),_0x6c4a('0x3d')],'required':_0x1df83e['query'][_0x6c4a('0x5b')]?!![]:![]}],'attributes':_[_0x6c4a('0x28')](_0xee1379)});})[_0x6c4a('0x21')](function(_0x27b595){_0x1f03c3=_0x27b595['get']({'plain':!![]});var _0x2de977={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x27b595&&_0x27b595[_0x6c4a('0x58')]){if(_0x27b595[_0x6c4a('0x58')]){_0x2de977[_0x6c4a('0x3a')]['$and'][_0x6c4a('0x57')]({'ListId':{'$ne':_0x27b595[_0x6c4a('0x58')]}});}}return db['CmCustomField']['findAll'](_0x2de977);})[_0x6c4a('0x21')](function(_0x585114){return _[_0x6c4a('0xa8')](_0x1f03c3,_[_0x6c4a('0x54')](_0x585114,function(_0x51cd61){return util['format'](_0x6c4a('0xa9'),_0x51cd61['id']);}));})[_0x6c4a('0x21')](handleEntityNotFound(_0x489e8b,null))[_0x6c4a('0x21')](respondWithResult(_0x489e8b,null))[_0x6c4a('0x81')](handleError(_0x489e8b,null));};exports[_0x6c4a('0x20')]=function(_0x274c4d,_0x4bdee1){var _0x5c6ab2;if(_0x274c4d[_0x6c4a('0x8b')]['id']){delete _0x274c4d[_0x6c4a('0x8b')]['id'];}return db[_0x6c4a('0x83')]['find']({'where':{'id':_0x274c4d['params']['id']}})[_0x6c4a('0x21')](handleEntityNotFound(_0x4bdee1,null))[_0x6c4a('0x21')](saveUpdates(_0x274c4d[_0x6c4a('0x8b')],null))[_0x6c4a('0x21')](function(_0x53661b){_0x5c6ab2=_0x53661b;var _0x500472={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x53661b&&_0x53661b[_0x6c4a('0x58')]){if(_0x53661b['ListId']){_0x500472['where'][_0x6c4a('0xaa')][_0x6c4a('0x57')]({'ListId':{'$ne':_0x53661b['ListId']}});}}return db['CmCustomField'][_0x6c4a('0x87')](_0x500472);})[_0x6c4a('0x21')](function(_0x5d216e){if(_0x5d216e){return _[_0x6c4a('0xa8')](_[_0x6c4a('0xab')](_0x274c4d[_0x6c4a('0x8b')],function(_0x3fccbf,_0x39b430){return _[_0x6c4a('0x84')](_0x39b430,_0x6c4a('0x29'));}),_[_0x6c4a('0x54')](_0x5d216e,function(_0xd96c6){return util[_0x6c4a('0xac')](_0x6c4a('0xa9'),_0xd96c6['id']);}));}})[_0x6c4a('0x21')](function(_0x37b5d9){if(_0x37b5d9&&!_[_0x6c4a('0x6c')](_0x37b5d9)){var _0x1b46df=squel['update']()[_0x6c4a('0xad')](_0x6c4a('0xae'))[_0x6c4a('0xaf')](_0x37b5d9)[_0x6c4a('0x3a')](_0x6c4a('0xb0'),_0x274c4d[_0x6c4a('0x82')]['id'])[_0x6c4a('0xb1')]();return db[_0x6c4a('0x74')][_0x6c4a('0x30')](_0x1b46df[_0x6c4a('0x52')],{'replacements':_0x1b46df[_0x6c4a('0x89')]});}})['then'](function(){if(_0x274c4d['body'][_0x6c4a('0xb2')]&&_0x5c6ab2){return db['CmHopper'][_0x6c4a('0x20')]({'phone':_0x274c4d[_0x6c4a('0x8b')][_0x6c4a('0xb2')]},{'where':{'ContactId':_0x5c6ab2['id']}});}})[_0x6c4a('0x21')](function(){return _0x5c6ab2;})[_0x6c4a('0x21')](respondWithResult(_0x4bdee1,null))[_0x6c4a('0x81')](handleError(_0x4bdee1,null));};exports[_0x6c4a('0xb3')]=function(_0x376643,_0x3ee71c,_0x9174ab){var _0x39c20a={};var _0x5f76c3={};var _0x4db825;var _0x501c6d;return db[_0x6c4a('0x83')][_0x6c4a('0x2a')]({'where':{'id':_0x376643[_0x6c4a('0x82')]['id']}})[_0x6c4a('0x21')](handleEntityNotFound(_0x3ee71c,null))['then'](function(_0x51734a){if(_0x51734a){_0x4db825=_0x51734a;_0x5f76c3['model']=_['keys'](db[_0x6c4a('0x48')][_0x6c4a('0xb4')]);_0x5f76c3['query']=_[_0x6c4a('0x28')](_0x376643[_0x6c4a('0x30')]);_0x5f76c3[_0x6c4a('0x31')]=_[_0x6c4a('0x32')](_0x5f76c3[_0x6c4a('0x34')],_0x5f76c3['query']);_0x39c20a[_0x6c4a('0x33')]=_['intersection'](_0x5f76c3[_0x6c4a('0x34')],qs[_0x6c4a('0x35')](_0x376643[_0x6c4a('0x30')][_0x6c4a('0x35')]));_0x39c20a[_0x6c4a('0x33')]=_0x39c20a[_0x6c4a('0x33')]['length']?_0x39c20a['attributes']:_0x5f76c3['model'];_0x39c20a[_0x6c4a('0x38')]=qs[_0x6c4a('0x39')](_0x376643[_0x6c4a('0x30')][_0x6c4a('0x39')]);_0x39c20a[_0x6c4a('0x3a')]=qs[_0x6c4a('0x31')](_[_0x6c4a('0xb5')](_0x376643[_0x6c4a('0x30')],_0x5f76c3[_0x6c4a('0x31')]));if(_0x376643[_0x6c4a('0x30')][_0x6c4a('0x55')]){_0x39c20a[_0x6c4a('0x3a')]=_[_0x6c4a('0x77')](_0x39c20a[_0x6c4a('0x3a')],{'$or':_[_0x6c4a('0x54')](_0x39c20a['attributes'],function(_0x4ef20d){var _0x30295c={};_0x30295c[_0x4ef20d]={'$like':'%'+_0x376643['query'][_0x6c4a('0x55')]+'%'};return _0x30295c;})});}_0x39c20a=_[_0x6c4a('0x77')]({},_0x39c20a,_0x376643[_0x6c4a('0xb6')]);return _0x4db825[_0x6c4a('0xb3')](_0x39c20a);}})[_0x6c4a('0x21')](function(_0x5ec473){if(_0x5ec473){_0x501c6d=_0x5ec473[_0x6c4a('0x2d')];if(!_0x376643['query'][_0x6c4a('0x8a')]('nolimit')){_0x39c20a[_0x6c4a('0x37')]=qs[_0x6c4a('0x37')](_0x376643[_0x6c4a('0x30')][_0x6c4a('0x37')]);_0x39c20a[_0x6c4a('0x1b')]=qs[_0x6c4a('0x1b')](_0x376643[_0x6c4a('0x30')][_0x6c4a('0x1b')]);}return _0x4db825[_0x6c4a('0xb3')](_0x39c20a);}})[_0x6c4a('0x21')](function(_0x286fa5){if(_0x286fa5){return _0x286fa5?{'count':_0x501c6d,'rows':_0x286fa5}:null;}})[_0x6c4a('0x21')](respondWithResult(_0x3ee71c,null))['catch'](handleError(_0x3ee71c,null));};exports[_0x6c4a('0xb7')]=function(_0x3d4954,_0x28f915,_0x29e570){if(_0x3d4954[_0x6c4a('0x8b')]['id']){delete _0x3d4954[_0x6c4a('0x8b')]['id'];}return db[_0x6c4a('0x83')]['findOne']({'where':{'id':_0x3d4954[_0x6c4a('0x82')]['id']}})['then'](handleEntityNotFound(_0x28f915,null))[_0x6c4a('0x21')](function(_0x576f10){if(_0x576f10){return _0x576f10['setTags'](_0x3d4954[_0x6c4a('0x8b')][_0x6c4a('0xb8')]||[]);}return null;})[_0x6c4a('0x21')](respondWithResult(_0x28f915,null))[_0x6c4a('0x81')](handleError(_0x28f915,null));};exports['getHoppers']=function(_0x36a0e4,_0x218bcd,_0x27f1cf){var _0x147771={'raw':![],'where':{}};var _0x4293e2={};var _0x5ebe65={'count':0x0,'rows':[]};return db[_0x6c4a('0x83')]['findOne']({'where':{'id':_0x36a0e4[_0x6c4a('0x82')]['id']}})['then'](handleEntityNotFound(_0x218bcd,null))['then'](function(_0x4c7d34){if(_0x4c7d34){_0x4293e2['model']=_[_0x6c4a('0x28')](db[_0x6c4a('0x91')][_0x6c4a('0xb4')]);_0x4293e2[_0x6c4a('0x30')]=_[_0x6c4a('0x28')](_0x36a0e4['query']);_0x4293e2[_0x6c4a('0x31')]=_['intersection'](_0x4293e2[_0x6c4a('0x34')],_0x4293e2[_0x6c4a('0x30')]);_0x147771['attributes']=_[_0x6c4a('0x32')](_0x4293e2[_0x6c4a('0x34')],qs[_0x6c4a('0x35')](_0x36a0e4[_0x6c4a('0x30')][_0x6c4a('0x35')]));_0x147771['attributes']=_0x147771['attributes'][_0x6c4a('0x2d')]?_0x147771[_0x6c4a('0x33')]:_0x4293e2[_0x6c4a('0x34')];if(!_0x36a0e4[_0x6c4a('0x30')]['hasOwnProperty']('nolimit')){_0x147771['limit']=qs['limit'](_0x36a0e4['query'][_0x6c4a('0x37')]);_0x147771[_0x6c4a('0x1b')]=qs[_0x6c4a('0x1b')](_0x36a0e4['query'][_0x6c4a('0x1b')]);}_0x147771[_0x6c4a('0x38')]=qs[_0x6c4a('0x39')](_0x36a0e4[_0x6c4a('0x30')][_0x6c4a('0x39')]);_0x147771[_0x6c4a('0x3a')]=qs[_0x6c4a('0x31')](_[_0x6c4a('0xb5')](_0x36a0e4[_0x6c4a('0x30')],_0x4293e2['filters']));_0x147771[_0x6c4a('0x3a')]['ContactId']=_0x4c7d34['id'];if(_0x36a0e4[_0x6c4a('0x30')][_0x6c4a('0x55')]){_0x147771['where']=_[_0x6c4a('0x77')](_0x147771[_0x6c4a('0x3a')],{'$or':_[_0x6c4a('0x54')](_0x147771[_0x6c4a('0x33')],function(_0x874d71){var _0x3775e1={};_0x3775e1[_0x874d71]={'$like':'%'+_0x36a0e4[_0x6c4a('0x30')][_0x6c4a('0x55')]+'%'};return _0x3775e1;})});}_0x147771=_[_0x6c4a('0x77')]({},_0x147771,_0x36a0e4[_0x6c4a('0xb6')]);return db[_0x6c4a('0x91')][_0x6c4a('0x1a')]({'where':_0x147771[_0x6c4a('0x3a')]})[_0x6c4a('0x21')](function(_0x54e772){_0x5ebe65[_0x6c4a('0x1a')]=_0x54e772;if(_0x36a0e4[_0x6c4a('0x30')][_0x6c4a('0xb9')]){_0x147771[_0x6c4a('0xba')]=[{'all':!![]}];}return db[_0x6c4a('0x91')][_0x6c4a('0x87')](_0x147771);})[_0x6c4a('0x21')](function(_0xacdd92){_0x5ebe65[_0x6c4a('0xbb')]=_0xacdd92;return _0x5ebe65;});}})[_0x6c4a('0x21')](respondWithFilteredResult(_0x218bcd,_0x147771))[_0x6c4a('0x81')](handleError(_0x218bcd,null));};exports[_0x6c4a('0xbc')]=function(_0x37ae4c,_0x2a7624,_0x1d8c91){var _0x228703={'raw':!![],'where':{}};var _0x14be77={};var _0x7bb3f0={'count':0x0,'rows':[]};return db[_0x6c4a('0x83')]['findOne']({'where':{'id':_0x37ae4c[_0x6c4a('0x82')]['id']}})[_0x6c4a('0x21')](handleEntityNotFound(_0x2a7624,null))[_0x6c4a('0x21')](function(_0x5a1652){if(_0x5a1652){_0x14be77[_0x6c4a('0x34')]=_[_0x6c4a('0x28')](db[_0x6c4a('0xbd')][_0x6c4a('0xb4')]);_0x14be77['query']=_[_0x6c4a('0x28')](_0x37ae4c[_0x6c4a('0x30')]);_0x14be77[_0x6c4a('0x31')]=_['intersection'](_0x14be77[_0x6c4a('0x34')],_0x14be77[_0x6c4a('0x30')]);_0x228703[_0x6c4a('0x33')]=_['intersection'](_0x14be77[_0x6c4a('0x34')],qs[_0x6c4a('0x35')](_0x37ae4c[_0x6c4a('0x30')][_0x6c4a('0x35')]));_0x228703[_0x6c4a('0x33')]=_0x228703[_0x6c4a('0x33')][_0x6c4a('0x2d')]?_0x228703['attributes']:_0x14be77[_0x6c4a('0x34')];if(!_0x37ae4c[_0x6c4a('0x30')][_0x6c4a('0x8a')](_0x6c4a('0x36'))){_0x228703['limit']=qs[_0x6c4a('0x37')](_0x37ae4c['query'][_0x6c4a('0x37')]);_0x228703[_0x6c4a('0x1b')]=qs[_0x6c4a('0x1b')](_0x37ae4c[_0x6c4a('0x30')][_0x6c4a('0x1b')]);}_0x228703[_0x6c4a('0x38')]=qs[_0x6c4a('0x39')](_0x37ae4c['query'][_0x6c4a('0x39')]);_0x228703['where']=qs[_0x6c4a('0x31')](_[_0x6c4a('0xb5')](_0x37ae4c['query'],_0x14be77[_0x6c4a('0x31')]));_0x228703['where']['ContactId']=_0x5a1652['id'];if(_0x37ae4c[_0x6c4a('0x30')][_0x6c4a('0x55')]){_0x228703['where']=_[_0x6c4a('0x77')](_0x228703[_0x6c4a('0x3a')],{'$or':_[_0x6c4a('0x54')](_0x228703[_0x6c4a('0x33')],function(_0x331772){var _0x514f09={};_0x514f09[_0x331772]={'$like':'%'+_0x37ae4c[_0x6c4a('0x30')][_0x6c4a('0x55')]+'%'};return _0x514f09;})});}_0x228703=_[_0x6c4a('0x77')]({},_0x228703,_0x37ae4c[_0x6c4a('0xb6')]);return db['CmHopperHistory']['count']({'where':_0x228703[_0x6c4a('0x3a')]})[_0x6c4a('0x21')](function(_0x4ecb81){_0x7bb3f0[_0x6c4a('0x1a')]=_0x4ecb81;if(_0x37ae4c[_0x6c4a('0x30')][_0x6c4a('0xb9')]){_0x228703[_0x6c4a('0xba')]=[{'all':!![]}];}return db['CmHopperHistory'][_0x6c4a('0x87')](_0x228703);})[_0x6c4a('0x21')](function(_0x22676e){_0x7bb3f0['rows']=_0x22676e;return _0x7bb3f0;});}})[_0x6c4a('0x21')](respondWithFilteredResult(_0x2a7624,_0x228703))['catch'](handleError(_0x2a7624,null));};exports[_0x6c4a('0xbe')]=function(_0x5bc838,_0x5e2d0d,_0x48c53f){var _0x280775={'raw':!![],'where':{}};var _0x4a0e05={};var _0x44042a={'count':0x0,'rows':[]};return db[_0x6c4a('0x83')][_0x6c4a('0x2a')]({'where':{'id':_0x5bc838[_0x6c4a('0x82')]['id']}})[_0x6c4a('0x21')](handleEntityNotFound(_0x5e2d0d,null))[_0x6c4a('0x21')](function(_0x38e29c){if(_0x38e29c){_0x4a0e05['model']=_[_0x6c4a('0x28')](db[_0x6c4a('0x9d')][_0x6c4a('0xb4')]);_0x4a0e05[_0x6c4a('0x30')]=_[_0x6c4a('0x28')](_0x5bc838[_0x6c4a('0x30')]);_0x4a0e05[_0x6c4a('0x31')]=_[_0x6c4a('0x32')](_0x4a0e05[_0x6c4a('0x34')],_0x4a0e05['query']);_0x280775[_0x6c4a('0x33')]=_['intersection'](_0x4a0e05[_0x6c4a('0x34')],qs[_0x6c4a('0x35')](_0x5bc838['query'][_0x6c4a('0x35')]));_0x280775[_0x6c4a('0x33')]=_0x280775['attributes'][_0x6c4a('0x2d')]?_0x280775[_0x6c4a('0x33')]:_0x4a0e05['model'];if(!_0x5bc838[_0x6c4a('0x30')][_0x6c4a('0x8a')](_0x6c4a('0x36'))){_0x280775['limit']=qs['limit'](_0x5bc838['query']['limit']);_0x280775[_0x6c4a('0x1b')]=qs['offset'](_0x5bc838[_0x6c4a('0x30')]['offset']);}_0x280775[_0x6c4a('0x38')]=qs['sort'](_0x5bc838[_0x6c4a('0x30')][_0x6c4a('0x39')]);_0x280775['where']=qs['filters'](_[_0x6c4a('0xb5')](_0x5bc838[_0x6c4a('0x30')],_0x4a0e05[_0x6c4a('0x31')]));_0x280775[_0x6c4a('0x3a')][_0x6c4a('0xbf')]=_0x38e29c['id'];if(_0x5bc838[_0x6c4a('0x30')][_0x6c4a('0x55')]){_0x280775['where']=_[_0x6c4a('0x77')](_0x280775[_0x6c4a('0x3a')],{'$or':_[_0x6c4a('0x54')](_0x280775[_0x6c4a('0x33')],function(_0x6676a5){var _0x316816={};_0x316816[_0x6676a5]={'$like':'%'+_0x5bc838[_0x6c4a('0x30')][_0x6c4a('0x55')]+'%'};return _0x316816;})});}_0x280775=_[_0x6c4a('0x77')]({},_0x280775,_0x5bc838[_0x6c4a('0xb6')]);return db[_0x6c4a('0x9d')][_0x6c4a('0x1a')]({'where':_0x280775[_0x6c4a('0x3a')]})['then'](function(_0x3a5492){_0x44042a[_0x6c4a('0x1a')]=_0x3a5492;if(_0x5bc838[_0x6c4a('0x30')][_0x6c4a('0xb9')]){_0x280775[_0x6c4a('0xba')]=[{'all':!![]}];}return db[_0x6c4a('0x9d')]['findAll'](_0x280775);})[_0x6c4a('0x21')](function(_0x1106ec){_0x44042a[_0x6c4a('0xbb')]=_0x1106ec;return _0x44042a;});}})[_0x6c4a('0x21')](respondWithFilteredResult(_0x5e2d0d,_0x280775))[_0x6c4a('0x81')](handleError(_0x5e2d0d,null));};exports[_0x6c4a('0xc0')]=function(_0x19dea7,_0x4521e1,_0x327746){var _0x259bff={'raw':!![],'where':{}};var _0x221227={};var _0x4653e3={'count':0x0,'rows':[]};return db[_0x6c4a('0x83')][_0x6c4a('0x2a')]({'where':{'id':_0x19dea7[_0x6c4a('0x82')]['id']}})[_0x6c4a('0x21')](handleEntityNotFound(_0x4521e1,null))['then'](function(_0x1ad87d){if(_0x1ad87d){_0x221227[_0x6c4a('0x34')]=_['keys'](db[_0x6c4a('0xc1')][_0x6c4a('0xb4')]);_0x221227[_0x6c4a('0x30')]=_[_0x6c4a('0x28')](_0x19dea7[_0x6c4a('0x30')]);_0x221227[_0x6c4a('0x31')]=_[_0x6c4a('0x32')](_0x221227[_0x6c4a('0x34')],_0x221227['query']);_0x259bff['attributes']=_[_0x6c4a('0x32')](_0x221227[_0x6c4a('0x34')],qs['fields'](_0x19dea7[_0x6c4a('0x30')][_0x6c4a('0x35')]));_0x259bff[_0x6c4a('0x33')]=_0x259bff['attributes']['length']?_0x259bff['attributes']:_0x221227[_0x6c4a('0x34')];if(!_0x19dea7['query']['hasOwnProperty'](_0x6c4a('0x36'))){_0x259bff[_0x6c4a('0x37')]=qs[_0x6c4a('0x37')](_0x19dea7[_0x6c4a('0x30')]['limit']);_0x259bff[_0x6c4a('0x1b')]=qs[_0x6c4a('0x1b')](_0x19dea7[_0x6c4a('0x30')][_0x6c4a('0x1b')]);}_0x259bff[_0x6c4a('0x38')]=qs[_0x6c4a('0x39')](_0x19dea7[_0x6c4a('0x30')][_0x6c4a('0x39')]);_0x259bff['where']=qs['filters'](_[_0x6c4a('0xb5')](_0x19dea7['query'],_0x221227['filters']));_0x259bff['where'][_0x6c4a('0xbf')]=_0x1ad87d['id'];if(_0x19dea7['query'][_0x6c4a('0x55')]){_0x259bff[_0x6c4a('0x3a')]=_[_0x6c4a('0x77')](_0x259bff['where'],{'$or':_[_0x6c4a('0x54')](_0x259bff['attributes'],function(_0x4c1b69){var _0x3aa58c={};_0x3aa58c[_0x4c1b69]={'$like':'%'+_0x19dea7[_0x6c4a('0x30')][_0x6c4a('0x55')]+'%'};return _0x3aa58c;})});}_0x259bff=_['merge']({},_0x259bff,_0x19dea7[_0x6c4a('0xb6')]);return db['JscriptySessionReport'][_0x6c4a('0x1a')]({'where':_0x259bff[_0x6c4a('0x3a')]})[_0x6c4a('0x21')](function(_0x38830b){_0x4653e3['count']=_0x38830b;if(_0x19dea7[_0x6c4a('0x30')][_0x6c4a('0xb9')]){_0x259bff['include']=[{'all':!![]}];}return db[_0x6c4a('0xc1')][_0x6c4a('0x87')](_0x259bff);})['then'](function(_0x3829e8){_0x4653e3[_0x6c4a('0xbb')]=_0x3829e8;return _0x4653e3;});}})[_0x6c4a('0x21')](respondWithFilteredResult(_0x4521e1,_0x259bff))[_0x6c4a('0x81')](handleError(_0x4521e1,null));};exports[_0x6c4a('0xc2')]=function(_0x2897b4,_0x55db88,_0x75a011){try{if(!_0x2897b4['body'][_0x6c4a('0x58')]){throw new Error(_0x6c4a('0xc3'));}if(!_0x2897b4[_0x6c4a('0x8b')][_0x6c4a('0xc4')]){throw new Error(_0x6c4a('0xc5'));}if(!_0x2897b4['body'][_0x6c4a('0xc6')]){throw new Error(_0x6c4a('0xc7'));}if(!_0x2897b4[_0x6c4a('0x8b')]['socket_timestamp']){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x1c6a16=_0x2897b4[_0x6c4a('0x8b')][_0x6c4a('0xc4')][_0x6c4a('0x5e')](',');var _0x45f081=_0x2897b4[_0x6c4a('0x8b')][_0x6c4a('0xc6')][_0x6c4a('0x5e')](',');if(!_0x1c6a16['length']||!_0x45f081[_0x6c4a('0x2d')]||_0x1c6a16[_0x6c4a('0x2d')]!==_0x45f081[_0x6c4a('0x2d')]){throw new Error(_0x6c4a('0xc8'));}_0x2897b4['body'][_0x6c4a('0x35')]=_[_0x6c4a('0xc9')](_0x1c6a16,_0x45f081);if(!_0x2897b4[_0x6c4a('0x8b')][_0x6c4a('0x35')]['phone']){throw new Error(_0x6c4a('0xca'));}if(!_0x2897b4[_0x6c4a('0x8b')]['fields'][_0x6c4a('0xcb')]){throw new Error(_0x6c4a('0xcc'));}var _0x2dcc03=path[_0x6c4a('0x8f')](config[_0x6c4a('0xcd')],_0x6c4a('0xce'),_0x2897b4['file'][_0x6c4a('0xcf')]);fs[_0x6c4a('0xd0')](_0x2dcc03,parseInt('0777',0x8));var _0x292b4a=require(_0x6c4a('0xd1'))['fork'](path[_0x6c4a('0x8f')](__dirname,_0x6c4a('0xd2')),[_0x2dcc03,_0x2897b4[_0x6c4a('0x8b')]['binding_keys'],_0x2897b4[_0x6c4a('0x8b')][_0x6c4a('0xc6')],_0x2897b4['body'][_0x6c4a('0x58')],_0x2897b4['body'][_0x6c4a('0xd3')],_0x2897b4['body'][_0x6c4a('0xa4')],_0x2897b4[_0x6c4a('0x8b')][_0x6c4a('0xd4')]]);return _0x55db88[_0x6c4a('0x17')](0xc8)['json']({'message':_0x6c4a('0xd5'),'pid':_0x292b4a[_0x6c4a('0xd6')]});}catch(_0x1170be){return _0x55db88[_0x6c4a('0x17')](0x1f4)[_0x6c4a('0xd7')](_0x1170be);}};exports['upload']=function(_0x43ac18,_0x5dd824,_0x1bf1c0){var _0x2ea947=fs[_0x6c4a('0xd8')](_0x43ac18['file'][_0x6c4a('0xd9')]);Papa['parse'](_0x2ea947,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x5bbff8){return _0x5dd824['status'](0xc8)['json']({'file':_0x43ac18[_0x6c4a('0xda')],'fields':_0x5bbff8['meta']['fields']});}});};exports['import']=function(_0x5e8d5d,_0x391c2a,_0x365a6e){return db[_0x6c4a('0xdb')][_0x6c4a('0x87')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0x6c4a('0x21')](function(_0x26231b){var _0x1a0198=![];if(!_0x5e8d5d['body'][_0x6c4a('0x58')]){throw new Error(_0x6c4a('0xc3'));}if(!_0x5e8d5d[_0x6c4a('0x8b')][_0x6c4a('0xdc')][_0x6c4a('0xb2')]){throw new Error(_0x6c4a('0xca'));}if(!_0x5e8d5d[_0x6c4a('0x8b')][_0x6c4a('0xdc')][_0x6c4a('0xcb')]){throw new Error(_0x6c4a('0xcc'));}if(!_0x5e8d5d[_0x6c4a('0x8b')][_0x6c4a('0xd4')]){throw new Error(_0x6c4a('0xdd'));}var _0x3bda25=require(_0x6c4a('0xd1'))[_0x6c4a('0xde')](path[_0x6c4a('0x8f')](__dirname,_0x6c4a('0xdf')),[_0x5e8d5d['params']['id'],JSON['stringify'](_0x5e8d5d[_0x6c4a('0x8b')]),JSON[_0x6c4a('0xe0')](_0x26231b)]);_0x3bda25['on'](_0x6c4a('0xe1'),function(_0xf9e6d2){_0x1a0198=!![];return _0x391c2a['status'](0xc8)[_0x6c4a('0x19')]({'message':_0x6c4a('0xe2'),'pid':_0x3bda25['pid']});});_0x3bda25['on'](_0x6c4a('0xe3'),function(_0x2f6273){if(_0x2f6273&&!_0x1a0198){return _0x391c2a['status'](0x1f4)[_0x6c4a('0x19')]({'message':'error\x20child\x20process','pid':_0x3bda25['pid']});}});})['catch'](handleError(_0x391c2a,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff