// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xdd8d=['getHoppers','ContactId','include','rows','getHopperHistories','getHopperFinals','includeAll','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','server/files/tmp','file','filename','chmodSync','0777','child_process','fork','../../components/import/cm/csv','CompanyId','socket_timestamp','File\x20uploaded\x20correctly!','upload','meta','import','User','agent','binding','stringify','message','pid','exit','error\x20child\x20process','html-pdf','eml-format','rimraf','fast-json-patch','request-promise','moment','mustache','util','sox','ejs','lodash','squel','crypto','desk.js','to-csv','../../components/auth/service','api','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./cmContact.socket','register','sendStatus','status','end','json','offset','limit','set','Content-Range','apply','save','update','then','error','stack','name','send','index','CmContact','model','keys','query','filters','attributes','fields','length','nolimit','order','sort','pick','select','field','color','from','tools_tags','where','c.deletedAt\x20IS\x20NULL','expr','advancedFilter','parse','forEach','condition','isArray','value','and','tableAlias','\x20=\x20?','LIKE','\x20>\x20?','\x20<\x20?','map','hasOwnProperty','isNil','isEmpty','ListId','c.ListId\x20IN\x20?','filter','replace','\x27\x27\x27\x27','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','QueryTypes','clone','COUNT(*)','tag','having','left_join','cm_contact_has_tags','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','sequelize','toString','count','merge','GROUP_CONCAT(DISTINCT\x20t.id)','Tags','split','TagIds','catch','destroy','find','params','describe','startsWith','cf_','columnName','CmCustomField','findAll','displayName','alias','custom','type','Error\x20customFields:\x20filed\x20%s\x20not\x20present\x20in\x20table\x20cm_contact','body','get','mergeWith','tags','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','bulkCreate','each','duplicates','$or','push','spread','show','Tag','$and','omit','format','cf_%d','pickBy','table','setFields','toParam','text','values','phone','getTags','rawAttributes','intersection','options','findOne','setTags','ids'];(function(_0x29c3b9,_0x4adaf7){var _0x637286=function(_0x36b4f3){while(--_0x36b4f3){_0x29c3b9['push'](_0x29c3b9['shift']());}};_0x637286(++_0x4adaf7);}(_0xdd8d,0x1e5));var _0xddd8=function(_0x4257b6,_0x2348c7){_0x4257b6=_0x4257b6-0x0;var _0x4ad68c=_0xdd8d[_0x4257b6];return _0x4ad68c;};'use strict';var pdf=require(_0xddd8('0x0'));var emlformat=require(_0xddd8('0x1'));var rimraf=require(_0xddd8('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0xddd8('0x3'));var rp=require(_0xddd8('0x4'));var moment=require(_0xddd8('0x5'));var BPromise=require('bluebird');var Mustache=require(_0xddd8('0x6'));var util=require(_0xddd8('0x7'));var path=require('path');var sox=require(_0xddd8('0x8'));var csv=require('to-csv');var ejs=require(_0xddd8('0x9'));var fs=require('fs');var _=require(_0xddd8('0xa'));var squel=require(_0xddd8('0xb'));var crypto=require(_0xddd8('0xc'));var jsforce=require('jsforce');var deskjs=require(_0xddd8('0xd'));var toCsv=require(_0xddd8('0xe'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0xddd8('0xf'));var qs=require('../../components/parsers/qs');var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0xddd8('0x10'));var utils=require(_0xddd8('0x11'));var config=require(_0xddd8('0x12'));var db=require(_0xddd8('0x13'))['db'];config[_0xddd8('0x14')]=_[_0xddd8('0x15')](config['redis'],{'host':_0xddd8('0x16'),'port':0x18eb});var socket=require(_0xddd8('0x17'))(new Redis(config['redis']));require(_0xddd8('0x18'))[_0xddd8('0x19')](socket);function respondWithStatusCode(_0x46589b,_0x2151a2){_0x2151a2=_0x2151a2||0xcc;return function(_0xc3a50){if(_0xc3a50){return _0x46589b[_0xddd8('0x1a')](_0x2151a2);}return _0x46589b[_0xddd8('0x1b')](_0x2151a2)[_0xddd8('0x1c')]();};}function respondWithResult(_0x57ea63,_0x17faa2){_0x17faa2=_0x17faa2||0xc8;return function(_0x36a632){if(_0x36a632){return _0x57ea63[_0xddd8('0x1b')](_0x17faa2)[_0xddd8('0x1d')](_0x36a632);}};}function respondWithFilteredResult(_0x2f1546,_0x587c57){return function(_0x296fce){if(_0x296fce){var _0x2b4860=_0x296fce['count'],_0x4534f7=_0x587c57[_0xddd8('0x1e')],_0x39b132=_0x587c57[_0xddd8('0x1e')]+_0x587c57[_0xddd8('0x1f')],_0x5d45d0;if(_0x39b132>=_0x2b4860){_0x39b132=_0x2b4860;_0x5d45d0=0xc8;}else{_0x5d45d0=0xce;}_0x2f1546[_0xddd8('0x1b')](_0x5d45d0);return _0x2f1546[_0xddd8('0x20')](_0xddd8('0x21'),_0x4534f7+'-'+_0x39b132+'/'+_0x2b4860)[_0xddd8('0x1d')](_0x296fce);}return null;};}function patchUpdates(_0x33b8c0){return function(_0x2fd953){try{jsonpatch[_0xddd8('0x22')](_0x2fd953,_0x33b8c0,!![]);}catch(_0x2a8b57){return BPromise['reject'](_0x2a8b57);}return _0x2fd953[_0xddd8('0x23')]();};}function saveUpdates(_0x89ee63,_0x5acd5e){return function(_0x49cf1a){if(_0x49cf1a){return _0x49cf1a[_0xddd8('0x24')](_0x89ee63)[_0xddd8('0x25')](function(_0x1a701f){return _0x1a701f;});}return null;};}function removeEntity(_0x55fb7f,_0x8e6d19){return function(_0x3b64de){if(_0x3b64de){return _0x3b64de['destroy']()[_0xddd8('0x25')](function(){_0x55fb7f[_0xddd8('0x1b')](0xcc)['end']();});}};}function handleEntityNotFound(_0x47e2be,_0xe0e982){return function(_0x2fa135){if(!_0x2fa135){_0x47e2be[_0xddd8('0x1a')](0x194);}return _0x2fa135;};}function handleError(_0x474764,_0x3cb821){_0x3cb821=_0x3cb821||0x1f4;return function(_0x3d5289){logger[_0xddd8('0x26')](_0x3d5289[_0xddd8('0x27')]);if(_0x3d5289[_0xddd8('0x28')]){delete _0x3d5289[_0xddd8('0x28')];}_0x474764[_0xddd8('0x1b')](_0x3cb821)[_0xddd8('0x29')](_0x3d5289);};}exports[_0xddd8('0x2a')]=function(_0xbe0d68,_0x48a5f7){var _0x4903b1={},_0xccc1f9={},_0x3de781={'count':0x0,'rows':[]};return db[_0xddd8('0x2b')]['describe']()[_0xddd8('0x25')](function(_0x5d167f){_0xccc1f9[_0xddd8('0x2c')]=_[_0xddd8('0x2d')](_0x5d167f);_0xccc1f9[_0xddd8('0x2e')]=_['keys'](_0xbe0d68['query']);_0xccc1f9[_0xddd8('0x2f')]=_['intersection'](_0xccc1f9['model'],_0xccc1f9['query']);_0x4903b1[_0xddd8('0x30')]=_['intersection'](_0xccc1f9[_0xddd8('0x2c')],qs['fields'](_0xbe0d68[_0xddd8('0x2e')][_0xddd8('0x31')]));_0x4903b1['attributes']=_0x4903b1[_0xddd8('0x30')][_0xddd8('0x32')]?_0x4903b1[_0xddd8('0x30')]:_0xccc1f9[_0xddd8('0x2c')];if(!_0xbe0d68[_0xddd8('0x2e')]['hasOwnProperty'](_0xddd8('0x33'))){_0x4903b1[_0xddd8('0x1f')]=qs[_0xddd8('0x1f')](_0xbe0d68['query'][_0xddd8('0x1f')]);_0x4903b1['offset']=qs[_0xddd8('0x1e')](_0xbe0d68['query'][_0xddd8('0x1e')]);}_0x4903b1[_0xddd8('0x34')]=qs['sort'](_0xbe0d68[_0xddd8('0x2e')][_0xddd8('0x35')]);_0x4903b1['where']=qs[_0xddd8('0x2f')](_[_0xddd8('0x36')](_0xbe0d68[_0xddd8('0x2e')],_0xccc1f9[_0xddd8('0x2f')]));var _0x11e9fd=[];var _0x4c2a0e=squel[_0xddd8('0x37')]()[_0xddd8('0x38')]('id')[_0xddd8('0x38')](_0xddd8('0x28'))[_0xddd8('0x38')](_0xddd8('0x39'))[_0xddd8('0x3a')](_0xddd8('0x3b'));var _0xf16104=squel[_0xddd8('0x37')]()[_0xddd8('0x3a')]('cm_contacts','c')[_0xddd8('0x3c')](_0xddd8('0x3d'));var _0x393ced=squel[_0xddd8('0x3e')]();if(_0xbe0d68[_0xddd8('0x2e')][_0xddd8('0x3f')]){var _0x26648d=JSON[_0xddd8('0x40')](_0xbe0d68[_0xddd8('0x2e')][_0xddd8('0x3f')]);_[_0xddd8('0x2d')](_0x26648d)[_0xddd8('0x41')](function(_0x5dbdc0){var _0x2acdb3=_0x26648d[_0x5dbdc0];switch(_0x2acdb3[_0xddd8('0x42')]){case'IS':if(_[_0xddd8('0x43')](_0x2acdb3[_0xddd8('0x44')])&&_0x2acdb3[_0xddd8('0x44')]['length']>0x1){_0x393ced[_0xddd8('0x45')](_0x2acdb3[_0xddd8('0x46')]+'.'+_0x5dbdc0+'\x20IN\x20?',_0x2acdb3[_0xddd8('0x44')]);}else{_0x393ced[_0xddd8('0x45')](_0x2acdb3[_0xddd8('0x46')]+'.'+_0x5dbdc0+'\x20=\x20?',_0x2acdb3[_0xddd8('0x44')][0x0]);}break;case'=':_0x393ced[_0xddd8('0x45')](_0x2acdb3['tableAlias']+'.'+_0x5dbdc0+_0xddd8('0x47'),_0x2acdb3[_0xddd8('0x44')]);break;case _0xddd8('0x48'):_0x393ced[_0xddd8('0x45')](_0x2acdb3['tableAlias']+'.'+_0x5dbdc0+'\x20LIKE\x20?','%'+_0x2acdb3[_0xddd8('0x44')]+'%');break;case'>':_0x393ced[_0xddd8('0x45')](_0x2acdb3[_0xddd8('0x46')]+'.'+_0x5dbdc0+_0xddd8('0x49'),_0x2acdb3['value']);break;case'<':_0x393ced[_0xddd8('0x45')](_0x2acdb3[_0xddd8('0x46')]+'.'+_0x5dbdc0+_0xddd8('0x4a'),_0x2acdb3[_0xddd8('0x44')]);break;}});}else{var _0x2606d7=_(Object[_0xddd8('0x2d')](_0xbe0d68['query']))[_0xddd8('0x4b')](function(_0x4e7fef){return _0x5d167f[_0xddd8('0x4c')](_0x4e7fef)?_0x4e7fef:undefined;})['filter'](function(_0x15dfc9){return!_[_0xddd8('0x4d')](_0x15dfc9);})[_0xddd8('0x44')]();if(!_[_0xddd8('0x4e')](_0x2606d7)){_0x2606d7[_0xddd8('0x41')](function(_0xa752a8){if(_0xa752a8===_0xddd8('0x4f')){_0xf16104[_0xddd8('0x3c')](_0xddd8('0x50'),[]['concat'](_0xbe0d68[_0xddd8('0x2e')][_0xa752a8]));}else{_0xf16104[_0xddd8('0x3c')]('c.'+_0xa752a8+_0xddd8('0x47'),_0xbe0d68[_0xddd8('0x2e')][_0xa752a8]);}});}if(_0xbe0d68[_0xddd8('0x2e')][_0xddd8('0x51')]){var _0x2f3e89=_0xbe0d68[_0xddd8('0x2e')][_0xddd8('0x51')][_0xddd8('0x52')]('\x5c','\x5c\x5c')[_0xddd8('0x52')]('\x27\x27',_0xddd8('0x53'));if(qs[_0xddd8('0x54')](_0x2f3e89)){_0x393ced['or'](_0xddd8('0x55'),_0x2f3e89+'%');_0x393ced['or'](_0xddd8('0x56'),_0x2f3e89+'%');_0x393ced['or'](_0xddd8('0x57'),_0x2f3e89+'%');_0x393ced['or'](_0xddd8('0x58'),_0x2f3e89+'%');}else if(qs[_0xddd8('0x59')](_0x2f3e89)){_0x393ced['or']('c.email\x20LIKE\x20?',_0x2f3e89+'%');}else{_0x393ced['or'](_0xddd8('0x5a'),_0x2f3e89+'%');_0x393ced['or']('c.firstName\x20LIKE\x20?',_0x2f3e89+'%');_0x393ced['or'](_0xddd8('0x5b'),_0x2f3e89+'%');}}}_0xf16104['where'](_0x393ced);if(_0x4903b1[_0xddd8('0x34')]){_0x4903b1[_0xddd8('0x34')][_0xddd8('0x41')](function(_0x51feb8){_0xf16104[_0xddd8('0x34')]('c.'+_0x51feb8[0x0],_0x51feb8[0x1]==='DESC'?![]:!![]);});}_0xf16104['group'](_0xddd8('0x5c'));var _0x2abd0c={'type':db['Sequelize'][_0xddd8('0x5d')]['SELECT'],'raw':!![]};var _0x4128da=_0xf16104[_0xddd8('0x5e')]()[_0xddd8('0x38')](_0xddd8('0x5f'));if(!_0xbe0d68['query'][_0xddd8('0x3f')]){if(_0xbe0d68['query']['tag']){var _0x2827fe=_['isArray'](_0xbe0d68[_0xddd8('0x2e')]['tag'])?_0xbe0d68['query'][_0xddd8('0x60')]:new Array(_0xbe0d68[_0xddd8('0x2e')][_0xddd8('0x60')]);var _0x5cd899=squel[_0xddd8('0x3e')]();_0x2827fe[_0xddd8('0x41')](function(_0xd57957){_0x5cd899['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0xd57957+',%');});_0xf16104[_0xddd8('0x61')](_0x5cd899);_0x4128da[_0xddd8('0x62')](_0xddd8('0x63'),'ct',_0xddd8('0x64'));_0x4128da[_0xddd8('0x62')]('tools_tags','t',_0xddd8('0x65'));_0x4128da['where']('t.id\x20IN\x20?',_0x2827fe);}}db[_0xddd8('0x66')][_0xddd8('0x2e')](_0x4c2a0e[_0xddd8('0x67')](),_0x2abd0c)[_0xddd8('0x25')](function(_0x4d60b9){_0x11e9fd=_['keyBy'](_0x4d60b9,'id');return db[_0xddd8('0x66')]['query'](_0x4128da[_0xddd8('0x67')](),_0x2abd0c);})[_0xddd8('0x25')](function(_0x3ff6cd){_0x3de781[_0xddd8('0x68')]=_0x3ff6cd[_0xddd8('0x32')];_0x2abd0c=_[_0xddd8('0x69')](_0x2abd0c,{'model':db[_0xddd8('0x2b')],'mapToModel':!![],'raw':!![],'nest':!![]});_0xf16104['field']('c.*');_0xf16104[_0xddd8('0x38')](_0xddd8('0x6a'),'TagIds');_0xf16104[_0xddd8('0x62')]('cm_contact_has_tags','ct','ct.CmContactId\x20=\x20c.id');_0xf16104[_0xddd8('0x62')](_0xddd8('0x3b'),'t','t.id\x20=\x20ct.TagId');if(_0x4903b1[_0xddd8('0x1f')]){_0xf16104[_0xddd8('0x1f')](_0x4903b1['limit']);}if(_0x4903b1['offset']){_0xf16104[_0xddd8('0x1e')](_0x4903b1[_0xddd8('0x1e')]);}db[_0xddd8('0x66')][_0xddd8('0x2e')](_0xf16104[_0xddd8('0x67')](),_0x2abd0c)[_0xddd8('0x25')](function(_0x330666){_0x330666[_0xddd8('0x41')](function(_0x5c379c){if(_0x5c379c['TagIds']){_0x5c379c[_0xddd8('0x6b')]=[];_0x5c379c['TagIds'][_0xddd8('0x6c')](',')[_0xddd8('0x41')](function(_0x59da4d){_0x5c379c['Tags']['push'](_0x11e9fd[_0x59da4d]);});}delete _0x5c379c[_0xddd8('0x6d')];});_0x3de781['rows']=_0x330666;return _0x3de781;})[_0xddd8('0x25')](respondWithFilteredResult(_0x48a5f7,_0x4903b1))[_0xddd8('0x6e')](handleError(_0x48a5f7,null));});});};exports[_0xddd8('0x6f')]=function(_0x48df8d,_0x2248d6){return db[_0xddd8('0x2b')][_0xddd8('0x70')]({'where':{'id':_0x48df8d[_0xddd8('0x71')]['id']}})[_0xddd8('0x25')](handleEntityNotFound(_0x2248d6,null))[_0xddd8('0x25')](removeEntity(_0x2248d6,null))[_0xddd8('0x6e')](handleError(_0x2248d6,null));};exports[_0xddd8('0x72')]=function(_0x322286,_0x3e3802){return db[_0xddd8('0x2b')][_0xddd8('0x72')]()[_0xddd8('0x25')](function(_0x37cbfc){for(var _0x10f293=0x0;_0x10f293<Object[_0xddd8('0x2d')](_0x37cbfc)['length'];_0x10f293++){var _0x437a1d=Object['keys'](_0x37cbfc)[_0x10f293];if(!_[_0xddd8('0x73')](_0x437a1d,_0xddd8('0x74'))){_0x37cbfc[_0x437a1d][_0xddd8('0x75')]=_0x437a1d;_0x37cbfc[_0x437a1d]['displayName']=_0x437a1d;}}return _0x37cbfc;})[_0xddd8('0x25')](function(_0x2d5839){var _0x36c841={'where':{'$or':[{'ListId':_0x322286[_0xddd8('0x2e')]['id']},{'ListId':null}]},'raw':!![]};return db[_0xddd8('0x76')][_0xddd8('0x77')](_0x36c841)['then'](function(_0x3242d2){for(var _0x112197=0x0;_0x112197<_0x3242d2['length'];_0x112197++){var _0x54995f='cf_'+_0x3242d2[_0x112197]['id'];if(_0x2d5839[_0x54995f]){_0x2d5839[_0x54995f]['columnName']=_0x54995f;_0x2d5839[_0x54995f][_0xddd8('0x78')]=_0x3242d2[_0x112197][_0xddd8('0x79')];_0x2d5839[_0x54995f][_0xddd8('0x7a')]={'type':_0x3242d2[_0x112197][_0xddd8('0x7b')],'values':_0x3242d2[_0x112197]['values']};}else{logger['error'](_0xddd8('0x7c'),_0x54995f);}}Object[_0xddd8('0x2d')](_0x2d5839)['forEach'](function(_0x1d16fc){if(!_0x2d5839[_0x1d16fc][_0xddd8('0x4c')](_0xddd8('0x75'))){delete _0x2d5839[_0x1d16fc];}});return _0x2d5839;});})[_0xddd8('0x25')](respondWithResult(_0x3e3802,null))[_0xddd8('0x6e')](handleError(_0x3e3802,null));};exports[_0xddd8('0x69')]=function(_0x89710,_0x1be5cb){var _0x268274;var _0x2e380e;var _0x5860ec;if(_0x89710['body']['id']){delete _0x89710[_0xddd8('0x7d')]['id'];}return db[_0xddd8('0x2b')][_0xddd8('0x77')]({'where':{'id':[_0x89710[_0xddd8('0x7d')]['to'],_0x89710[_0xddd8('0x7d')][_0xddd8('0x3a')]]}})[_0xddd8('0x25')](function(_0x310177){if(_0x310177){if(_0x310177['length']!==0x2){return null;}_0x310177[0x0]=_0x310177[0x0][_0xddd8('0x7e')]({'plain':!![]});_0x310177[0x1]=_0x310177[0x1][_0xddd8('0x7e')]({'plain':!![]});delete _0x310177[0x0]['id'];delete _0x310177[0x1]['id'];return _[_0xddd8('0x7f')](_0x310177[0x0],_0x310177[0x1],function(_0x1a836a,_0x3213c4){if(Array[_0xddd8('0x43')](_0x3213c4)&&!_0x3213c4[_0xddd8('0x32')]){return _0x1a836a;}else if(!_0x3213c4){return _0x1a836a;}});}})['then'](handleEntityNotFound(_0x1be5cb,null))['then'](function(_0x1018c2){if(_0x1018c2){if(_0x1018c2[_0xddd8('0x80')]&&_['isArray'](_0x1018c2[_0xddd8('0x80')])){_0x1018c2[_0xddd8('0x80')]=_0x1018c2[_0xddd8('0x80')][_0xddd8('0x81')]();}logger[_0xddd8('0x82')](_0xddd8('0x83'),_0x89710[_0xddd8('0x7d')]['to'],_0x89710['body'][_0xddd8('0x3a')]);return db[_0xddd8('0x84')][_0xddd8('0x6f')]({'where':{'ContactId':[_0x89710[_0xddd8('0x7d')]['to'],_0x89710[_0xddd8('0x7d')]['from']]}})[_0xddd8('0x25')](function(_0x59b50e){logger[_0xddd8('0x82')](_0xddd8('0x85'),_0x59b50e);return db[_0xddd8('0x86')][_0xddd8('0x6f')]({'where':{'ContactId':[_0x89710['body']['to'],_0x89710['body'][_0xddd8('0x3a')]]}})[_0xddd8('0x25')](function(_0x26336f){logger[_0xddd8('0x82')](_0xddd8('0x87'),_0x26336f);return db[_0xddd8('0x2b')][_0xddd8('0x88')](_0x1018c2);});});}})[_0xddd8('0x25')](function(_0x4407fe){if(_0x4407fe){_0x268274=_0x4407fe;_0x2e380e={'ContactId':_0x268274['id']};_0x5860ec={'where':{'ContactId':[_0x89710['body']['to'],_0x89710[_0xddd8('0x7d')][_0xddd8('0x3a')]]}};return db['ChatInteraction'][_0xddd8('0x24')](_0x2e380e,_0x5860ec);}})['then'](function(){if(_0x268274){return db[_0xddd8('0x89')][_0xddd8('0x24')](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db['ChatOfflineMessage'][_0xddd8('0x24')](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db[_0xddd8('0x8a')][_0xddd8('0x24')](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db[_0xddd8('0x8b')]['update'](_0x2e380e,_0x5860ec);}})['then'](function(){if(_0x268274){return db[_0xddd8('0x8a')][_0xddd8('0x24')](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db[_0xddd8('0x8b')][_0xddd8('0x24')](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db[_0xddd8('0x8c')][_0xddd8('0x24')](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db[_0xddd8('0x8d')][_0xddd8('0x24')](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db[_0xddd8('0x8e')][_0xddd8('0x24')](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db['FaxMessage'][_0xddd8('0x24')](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db[_0xddd8('0x8f')][_0xddd8('0x24')](_0x2e380e,_0x5860ec);}})['then'](function(){if(_0x268274){return db[_0xddd8('0x90')][_0xddd8('0x24')](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db[_0xddd8('0x91')]['update'](_0x2e380e,_0x5860ec);}})['then'](function(){if(_0x268274){return db[_0xddd8('0x92')][_0xddd8('0x24')](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db[_0xddd8('0x93')][_0xddd8('0x24')](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db[_0xddd8('0x94')]['update'](_0x2e380e,_0x5860ec);}})['then'](function(){if(_0x268274){return db[_0xddd8('0x95')]['update'](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db[_0xddd8('0x96')][_0xddd8('0x24')](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db[_0xddd8('0x97')]['update'](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db[_0xddd8('0x98')][_0xddd8('0x24')](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db[_0xddd8('0x99')][_0xddd8('0x24')](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db[_0xddd8('0x9a')]['update'](_0x2e380e,_0x5860ec);}})[_0xddd8('0x25')](function(){if(_0x268274){return db[_0xddd8('0x2b')]['destroy']({'where':{'id':[_0x89710[_0xddd8('0x7d')]['to'],_0x89710['body']['from']]}});}})['then'](function(){if(_0x268274){return _0x268274;}})['then'](respondWithResult(_0x1be5cb,null))[_0xddd8('0x6e')](handleError(_0x1be5cb,null));};exports[_0xddd8('0x88')]=function(_0x4cfe96,_0x3e1740){return db['CmContact']['describe']()['then'](function(_0x4cf190){if(_0x4cfe96['body'][_0xddd8('0x80')]&&_[_0xddd8('0x43')](_0x4cfe96[_0xddd8('0x7d')][_0xddd8('0x80')])){if(_0x4cfe96['body'][_0xddd8('0x80')]['length']){_0x4cfe96[_0xddd8('0x7d')]['tags']=_0x4cfe96[_0xddd8('0x7d')]['tags']['join'](';')+';';}else{_0x4cfe96[_0xddd8('0x7d')][_0xddd8('0x80')]=null;}}else{_0x4cfe96[_0xddd8('0x7d')][_0xddd8('0x80')]=null;}return db[_0xddd8('0x2b')]['create'](_0x4cfe96['body'],{'fields':_['keys'](_0x4cf190),'raw':!![]});})['then'](respondWithResult(_0x3e1740,0xc9))['catch'](handleError(_0x3e1740,null));};exports[_0xddd8('0x9b')]=function(_0x1cb69d,_0x284900){var _0x6fe523=[];var _0x39fcb8=0x0;var _0x399171=0x0;var _0x78916f=0x0;return db[_0xddd8('0x2b')][_0xddd8('0x72')]()[_0xddd8('0x25')](function(_0x37c5c4){return BPromise[_0xddd8('0x9c')](_0x1cb69d['body'],function(_0x52a900){var _0x453dad={'where':{'$or':[]},'defaults':_0x52a900,'fields':_[_0xddd8('0x2d')](_0x37c5c4),'raw':!![]};if(_0x52a900['duplicates']){for(var _0x4cdb78=0x0;_0x4cdb78<_0x52a900[_0xddd8('0x9d')][_0xddd8('0x32')];_0x4cdb78++){var _0x4c14ee={};_0x4c14ee[_0x52a900[_0xddd8('0x9d')][_0x4cdb78]]=_0x52a900[_0x52a900[_0xddd8('0x9d')][_0x4cdb78]];_0x453dad['where'][_0xddd8('0x9e')][_0xddd8('0x9f')](_0x4c14ee);}_0x453dad['where'][_0xddd8('0x4f')]=_0x52a900[_0xddd8('0x4f')];}return db[_0xddd8('0x2b')]['findOrCreate'](_0x453dad)[_0xddd8('0xa0')](function(_0x4f2746,_0x3b373a){if(_0x3b373a){_0x39fcb8++;}else{_0x78916f++;}})['catch'](function(_0x1def51){console['error'](_0x1def51);_0x399171++;});});})['then'](function(_0x49fe5a){if(_0x49fe5a){return{'success':_0x39fcb8,'failure':_0x399171,'duplicates':_0x78916f};}})[_0xddd8('0x25')](respondWithResult(_0x284900,0xc9))[_0xddd8('0x6e')](handleError(_0x284900,null));};exports[_0xddd8('0xa1')]=function(_0x4fdfd7,_0x21446a,_0x532ed0){var _0x22004c;return db[_0xddd8('0x2b')][_0xddd8('0x72')]()[_0xddd8('0x25')](function(_0x5cde34){return db[_0xddd8('0x2b')]['find']({'where':{'id':_0x4fdfd7['params']['id']},'include':[{'model':db[_0xddd8('0xa2')],'as':_0xddd8('0x6b'),'attributes':['id',_0xddd8('0x28'),'color'],'required':_0x4fdfd7[_0xddd8('0x2e')][_0xddd8('0x60')]?!![]:![]}],'attributes':_['keys'](_0x5cde34)});})[_0xddd8('0x25')](function(_0x52f370){_0x22004c=_0x52f370['get']({'plain':!![]});var _0x4f8e51={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x52f370&&_0x52f370[_0xddd8('0x4f')]){if(_0x52f370['ListId']){_0x4f8e51['where'][_0xddd8('0xa3')][_0xddd8('0x9f')]({'ListId':{'$ne':_0x52f370[_0xddd8('0x4f')]}});}}return db[_0xddd8('0x76')][_0xddd8('0x77')](_0x4f8e51);})[_0xddd8('0x25')](function(_0x14de99){return _[_0xddd8('0xa4')](_0x22004c,_[_0xddd8('0x4b')](_0x14de99,function(_0x2292e2){return util[_0xddd8('0xa5')](_0xddd8('0xa6'),_0x2292e2['id']);}));})[_0xddd8('0x25')](handleEntityNotFound(_0x21446a,null))[_0xddd8('0x25')](respondWithResult(_0x21446a,null))[_0xddd8('0x6e')](handleError(_0x21446a,null));};exports['update']=function(_0x4946b1,_0x2afe19){var _0x169b97;if(_0x4946b1['body']['id']){delete _0x4946b1['body']['id'];}return db[_0xddd8('0x2b')]['find']({'where':{'id':_0x4946b1[_0xddd8('0x71')]['id']}})[_0xddd8('0x25')](handleEntityNotFound(_0x2afe19,null))[_0xddd8('0x25')](saveUpdates(_0x4946b1[_0xddd8('0x7d')],null))[_0xddd8('0x25')](function(_0x17ae25){_0x169b97=_0x17ae25;var _0x5c2ec1={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x17ae25&&_0x17ae25[_0xddd8('0x4f')]){if(_0x17ae25[_0xddd8('0x4f')]){_0x5c2ec1[_0xddd8('0x3c')][_0xddd8('0xa3')][_0xddd8('0x9f')]({'ListId':{'$ne':_0x17ae25[_0xddd8('0x4f')]}});}}return db[_0xddd8('0x76')][_0xddd8('0x77')](_0x5c2ec1);})[_0xddd8('0x25')](function(_0x271bbf){if(_0x271bbf){return _[_0xddd8('0xa4')](_[_0xddd8('0xa7')](_0x4946b1[_0xddd8('0x7d')],function(_0x3e31bd,_0x449568){return _[_0xddd8('0x73')](_0x449568,'cf_');}),_[_0xddd8('0x4b')](_0x271bbf,function(_0x85a548){return util[_0xddd8('0xa5')](_0xddd8('0xa6'),_0x85a548['id']);}));}})['then'](function(_0x57517a){if(_0x57517a&&!_['isEmpty'](_0x57517a)){var _0x2de360=squel[_0xddd8('0x24')]()[_0xddd8('0xa8')]('cm_contacts')[_0xddd8('0xa9')](_0x57517a)[_0xddd8('0x3c')]('id\x20=\x20?',_0x4946b1[_0xddd8('0x71')]['id'])[_0xddd8('0xaa')]();return db['sequelize']['query'](_0x2de360[_0xddd8('0xab')],{'replacements':_0x2de360[_0xddd8('0xac')]});}})['then'](function(){if(_0x4946b1[_0xddd8('0x7d')]['phone']&&_0x169b97){return db[_0xddd8('0x84')][_0xddd8('0x24')]({'phone':_0x4946b1[_0xddd8('0x7d')][_0xddd8('0xad')]},{'where':{'ContactId':_0x169b97['id']}});}})[_0xddd8('0x25')](function(){return _0x169b97;})[_0xddd8('0x25')](respondWithResult(_0x2afe19,null))[_0xddd8('0x6e')](handleError(_0x2afe19,null));};exports[_0xddd8('0xae')]=function(_0x5f39a4,_0x483764,_0x37c7dc){var _0x314b08={};var _0x1f5767={};var _0x3fbc45;var _0x596862;return db[_0xddd8('0x2b')]['findOne']({'where':{'id':_0x5f39a4[_0xddd8('0x71')]['id']}})[_0xddd8('0x25')](handleEntityNotFound(_0x483764,null))[_0xddd8('0x25')](function(_0x30f0b1){if(_0x30f0b1){_0x3fbc45=_0x30f0b1;_0x1f5767['model']=_[_0xddd8('0x2d')](db[_0xddd8('0xa2')][_0xddd8('0xaf')]);_0x1f5767[_0xddd8('0x2e')]=_[_0xddd8('0x2d')](_0x5f39a4[_0xddd8('0x2e')]);_0x1f5767['filters']=_[_0xddd8('0xb0')](_0x1f5767['model'],_0x1f5767[_0xddd8('0x2e')]);_0x314b08[_0xddd8('0x30')]=_[_0xddd8('0xb0')](_0x1f5767[_0xddd8('0x2c')],qs[_0xddd8('0x31')](_0x5f39a4[_0xddd8('0x2e')][_0xddd8('0x31')]));_0x314b08[_0xddd8('0x30')]=_0x314b08[_0xddd8('0x30')]['length']?_0x314b08[_0xddd8('0x30')]:_0x1f5767['model'];_0x314b08[_0xddd8('0x34')]=qs[_0xddd8('0x35')](_0x5f39a4['query'][_0xddd8('0x35')]);_0x314b08[_0xddd8('0x3c')]=qs[_0xddd8('0x2f')](_['pick'](_0x5f39a4['query'],_0x1f5767[_0xddd8('0x2f')]));if(_0x5f39a4[_0xddd8('0x2e')]['filter']){_0x314b08[_0xddd8('0x3c')]=_[_0xddd8('0x69')](_0x314b08[_0xddd8('0x3c')],{'$or':_[_0xddd8('0x4b')](_0x314b08[_0xddd8('0x30')],function(_0x36a7bf){var _0x7d377d={};_0x7d377d[_0x36a7bf]={'$like':'%'+_0x5f39a4[_0xddd8('0x2e')][_0xddd8('0x51')]+'%'};return _0x7d377d;})});}_0x314b08=_['merge']({},_0x314b08,_0x5f39a4[_0xddd8('0xb1')]);return _0x3fbc45[_0xddd8('0xae')](_0x314b08);}})[_0xddd8('0x25')](function(_0x8c5146){if(_0x8c5146){_0x596862=_0x8c5146['length'];if(!_0x5f39a4['query'][_0xddd8('0x4c')]('nolimit')){_0x314b08[_0xddd8('0x1f')]=qs[_0xddd8('0x1f')](_0x5f39a4[_0xddd8('0x2e')][_0xddd8('0x1f')]);_0x314b08[_0xddd8('0x1e')]=qs[_0xddd8('0x1e')](_0x5f39a4['query'][_0xddd8('0x1e')]);}return _0x3fbc45[_0xddd8('0xae')](_0x314b08);}})[_0xddd8('0x25')](function(_0x18d02a){if(_0x18d02a){return _0x18d02a?{'count':_0x596862,'rows':_0x18d02a}:null;}})[_0xddd8('0x25')](respondWithResult(_0x483764,null))[_0xddd8('0x6e')](handleError(_0x483764,null));};exports['setTags']=function(_0x2c99d2,_0x4f833d,_0x271188){if(_0x2c99d2['body']['id']){delete _0x2c99d2[_0xddd8('0x7d')]['id'];}return db['CmContact'][_0xddd8('0xb2')]({'where':{'id':_0x2c99d2['params']['id']}})[_0xddd8('0x25')](handleEntityNotFound(_0x4f833d,null))['then'](function(_0x2ceacb){if(_0x2ceacb){return _0x2ceacb[_0xddd8('0xb3')](_0x2c99d2[_0xddd8('0x7d')][_0xddd8('0xb4')]||[]);}return null;})[_0xddd8('0x25')](respondWithResult(_0x4f833d,null))[_0xddd8('0x6e')](handleError(_0x4f833d,null));};exports[_0xddd8('0xb5')]=function(_0x4767f8,_0x5e3e75,_0x4737a5){var _0x1a5400={'raw':![],'where':{}};var _0x42921c={};var _0x4a78dd={'count':0x0,'rows':[]};return db['CmContact'][_0xddd8('0xb2')]({'where':{'id':_0x4767f8[_0xddd8('0x71')]['id']}})[_0xddd8('0x25')](handleEntityNotFound(_0x5e3e75,null))[_0xddd8('0x25')](function(_0x13875e){if(_0x13875e){_0x42921c['model']=_['keys'](db[_0xddd8('0x84')][_0xddd8('0xaf')]);_0x42921c[_0xddd8('0x2e')]=_['keys'](_0x4767f8[_0xddd8('0x2e')]);_0x42921c['filters']=_[_0xddd8('0xb0')](_0x42921c[_0xddd8('0x2c')],_0x42921c[_0xddd8('0x2e')]);_0x1a5400[_0xddd8('0x30')]=_['intersection'](_0x42921c['model'],qs['fields'](_0x4767f8['query'][_0xddd8('0x31')]));_0x1a5400['attributes']=_0x1a5400[_0xddd8('0x30')]['length']?_0x1a5400[_0xddd8('0x30')]:_0x42921c['model'];if(!_0x4767f8[_0xddd8('0x2e')][_0xddd8('0x4c')](_0xddd8('0x33'))){_0x1a5400[_0xddd8('0x1f')]=qs[_0xddd8('0x1f')](_0x4767f8[_0xddd8('0x2e')]['limit']);_0x1a5400[_0xddd8('0x1e')]=qs['offset'](_0x4767f8[_0xddd8('0x2e')]['offset']);}_0x1a5400[_0xddd8('0x34')]=qs[_0xddd8('0x35')](_0x4767f8[_0xddd8('0x2e')][_0xddd8('0x35')]);_0x1a5400[_0xddd8('0x3c')]=qs[_0xddd8('0x2f')](_[_0xddd8('0x36')](_0x4767f8[_0xddd8('0x2e')],_0x42921c[_0xddd8('0x2f')]));_0x1a5400[_0xddd8('0x3c')][_0xddd8('0xb6')]=_0x13875e['id'];if(_0x4767f8[_0xddd8('0x2e')][_0xddd8('0x51')]){_0x1a5400[_0xddd8('0x3c')]=_[_0xddd8('0x69')](_0x1a5400[_0xddd8('0x3c')],{'$or':_[_0xddd8('0x4b')](_0x1a5400[_0xddd8('0x30')],function(_0x8f2259){var _0x5b9204={};_0x5b9204[_0x8f2259]={'$like':'%'+_0x4767f8['query'][_0xddd8('0x51')]+'%'};return _0x5b9204;})});}_0x1a5400=_[_0xddd8('0x69')]({},_0x1a5400,_0x4767f8[_0xddd8('0xb1')]);return db[_0xddd8('0x84')][_0xddd8('0x68')]({'where':_0x1a5400['where']})[_0xddd8('0x25')](function(_0xb802c9){_0x4a78dd[_0xddd8('0x68')]=_0xb802c9;if(_0x4767f8[_0xddd8('0x2e')]['includeAll']){_0x1a5400[_0xddd8('0xb7')]=[{'all':!![]}];}return db[_0xddd8('0x84')][_0xddd8('0x77')](_0x1a5400);})[_0xddd8('0x25')](function(_0x32d1d6){_0x4a78dd[_0xddd8('0xb8')]=_0x32d1d6;return _0x4a78dd;});}})['then'](respondWithFilteredResult(_0x5e3e75,_0x1a5400))[_0xddd8('0x6e')](handleError(_0x5e3e75,null));};exports[_0xddd8('0xb9')]=function(_0x537779,_0x564885,_0x578c39){var _0x307aef={'raw':!![],'where':{}};var _0x2bfe75={};var _0x337595={'count':0x0,'rows':[]};return db[_0xddd8('0x2b')][_0xddd8('0xb2')]({'where':{'id':_0x537779[_0xddd8('0x71')]['id']}})['then'](handleEntityNotFound(_0x564885,null))['then'](function(_0x10eb90){if(_0x10eb90){_0x2bfe75['model']=_[_0xddd8('0x2d')](db[_0xddd8('0x92')][_0xddd8('0xaf')]);_0x2bfe75[_0xddd8('0x2e')]=_[_0xddd8('0x2d')](_0x537779[_0xddd8('0x2e')]);_0x2bfe75[_0xddd8('0x2f')]=_[_0xddd8('0xb0')](_0x2bfe75[_0xddd8('0x2c')],_0x2bfe75[_0xddd8('0x2e')]);_0x307aef[_0xddd8('0x30')]=_[_0xddd8('0xb0')](_0x2bfe75[_0xddd8('0x2c')],qs[_0xddd8('0x31')](_0x537779[_0xddd8('0x2e')]['fields']));_0x307aef[_0xddd8('0x30')]=_0x307aef[_0xddd8('0x30')][_0xddd8('0x32')]?_0x307aef[_0xddd8('0x30')]:_0x2bfe75[_0xddd8('0x2c')];if(!_0x537779[_0xddd8('0x2e')]['hasOwnProperty'](_0xddd8('0x33'))){_0x307aef[_0xddd8('0x1f')]=qs[_0xddd8('0x1f')](_0x537779['query'][_0xddd8('0x1f')]);_0x307aef[_0xddd8('0x1e')]=qs['offset'](_0x537779[_0xddd8('0x2e')]['offset']);}_0x307aef[_0xddd8('0x34')]=qs[_0xddd8('0x35')](_0x537779['query'][_0xddd8('0x35')]);_0x307aef['where']=qs[_0xddd8('0x2f')](_[_0xddd8('0x36')](_0x537779[_0xddd8('0x2e')],_0x2bfe75['filters']));_0x307aef[_0xddd8('0x3c')]['ContactId']=_0x10eb90['id'];if(_0x537779[_0xddd8('0x2e')][_0xddd8('0x51')]){_0x307aef[_0xddd8('0x3c')]=_[_0xddd8('0x69')](_0x307aef[_0xddd8('0x3c')],{'$or':_['map'](_0x307aef[_0xddd8('0x30')],function(_0xbf3a67){var _0x34dccb={};_0x34dccb[_0xbf3a67]={'$like':'%'+_0x537779[_0xddd8('0x2e')][_0xddd8('0x51')]+'%'};return _0x34dccb;})});}_0x307aef=_['merge']({},_0x307aef,_0x537779['options']);return db[_0xddd8('0x92')]['count']({'where':_0x307aef['where']})[_0xddd8('0x25')](function(_0x724030){_0x337595[_0xddd8('0x68')]=_0x724030;if(_0x537779[_0xddd8('0x2e')]['includeAll']){_0x307aef['include']=[{'all':!![]}];}return db['CmHopperHistory'][_0xddd8('0x77')](_0x307aef);})[_0xddd8('0x25')](function(_0x16e676){_0x337595[_0xddd8('0xb8')]=_0x16e676;return _0x337595;});}})[_0xddd8('0x25')](respondWithFilteredResult(_0x564885,_0x307aef))['catch'](handleError(_0x564885,null));};exports[_0xddd8('0xba')]=function(_0xec2230,_0x38a82d,_0x98d051){var _0x5ee055={'raw':!![],'where':{}};var _0x4a3c85={};var _0x43c7c8={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0xec2230['params']['id']}})[_0xddd8('0x25')](handleEntityNotFound(_0x38a82d,null))[_0xddd8('0x25')](function(_0x58880b){if(_0x58880b){_0x4a3c85['model']=_['keys'](db['CmHopperFinal'][_0xddd8('0xaf')]);_0x4a3c85[_0xddd8('0x2e')]=_[_0xddd8('0x2d')](_0xec2230[_0xddd8('0x2e')]);_0x4a3c85['filters']=_[_0xddd8('0xb0')](_0x4a3c85[_0xddd8('0x2c')],_0x4a3c85[_0xddd8('0x2e')]);_0x5ee055['attributes']=_['intersection'](_0x4a3c85['model'],qs[_0xddd8('0x31')](_0xec2230[_0xddd8('0x2e')][_0xddd8('0x31')]));_0x5ee055['attributes']=_0x5ee055[_0xddd8('0x30')]['length']?_0x5ee055[_0xddd8('0x30')]:_0x4a3c85['model'];if(!_0xec2230[_0xddd8('0x2e')][_0xddd8('0x4c')]('nolimit')){_0x5ee055[_0xddd8('0x1f')]=qs[_0xddd8('0x1f')](_0xec2230[_0xddd8('0x2e')][_0xddd8('0x1f')]);_0x5ee055[_0xddd8('0x1e')]=qs[_0xddd8('0x1e')](_0xec2230['query'][_0xddd8('0x1e')]);}_0x5ee055[_0xddd8('0x34')]=qs[_0xddd8('0x35')](_0xec2230[_0xddd8('0x2e')][_0xddd8('0x35')]);_0x5ee055[_0xddd8('0x3c')]=qs['filters'](_[_0xddd8('0x36')](_0xec2230[_0xddd8('0x2e')],_0x4a3c85[_0xddd8('0x2f')]));_0x5ee055[_0xddd8('0x3c')][_0xddd8('0xb6')]=_0x58880b['id'];if(_0xec2230[_0xddd8('0x2e')][_0xddd8('0x51')]){_0x5ee055['where']=_[_0xddd8('0x69')](_0x5ee055[_0xddd8('0x3c')],{'$or':_[_0xddd8('0x4b')](_0x5ee055[_0xddd8('0x30')],function(_0x4df4dc){var _0x26d377={};_0x26d377[_0x4df4dc]={'$like':'%'+_0xec2230[_0xddd8('0x2e')][_0xddd8('0x51')]+'%'};return _0x26d377;})});}_0x5ee055=_['merge']({},_0x5ee055,_0xec2230['options']);return db[_0xddd8('0x91')][_0xddd8('0x68')]({'where':_0x5ee055[_0xddd8('0x3c')]})[_0xddd8('0x25')](function(_0x20a8b2){_0x43c7c8[_0xddd8('0x68')]=_0x20a8b2;if(_0xec2230[_0xddd8('0x2e')][_0xddd8('0xbb')]){_0x5ee055['include']=[{'all':!![]}];}return db['CmHopperFinal'][_0xddd8('0x77')](_0x5ee055);})['then'](function(_0x40cecf){_0x43c7c8[_0xddd8('0xb8')]=_0x40cecf;return _0x43c7c8;});}})[_0xddd8('0x25')](respondWithFilteredResult(_0x38a82d,_0x5ee055))[_0xddd8('0x6e')](handleError(_0x38a82d,null));};exports['getJscriptySessions']=function(_0x4087d3,_0x4ee4c5,_0x3cc1b4){var _0x1c3329={'raw':!![],'where':{}};var _0x1fb92a={};var _0x15c235={'count':0x0,'rows':[]};return db[_0xddd8('0x2b')][_0xddd8('0xb2')]({'where':{'id':_0x4087d3[_0xddd8('0x71')]['id']}})[_0xddd8('0x25')](handleEntityNotFound(_0x4ee4c5,null))[_0xddd8('0x25')](function(_0x3bffab){if(_0x3bffab){_0x1fb92a['model']=_[_0xddd8('0x2d')](db[_0xddd8('0x9a')][_0xddd8('0xaf')]);_0x1fb92a['query']=_[_0xddd8('0x2d')](_0x4087d3['query']);_0x1fb92a[_0xddd8('0x2f')]=_[_0xddd8('0xb0')](_0x1fb92a[_0xddd8('0x2c')],_0x1fb92a[_0xddd8('0x2e')]);_0x1c3329[_0xddd8('0x30')]=_[_0xddd8('0xb0')](_0x1fb92a[_0xddd8('0x2c')],qs['fields'](_0x4087d3[_0xddd8('0x2e')][_0xddd8('0x31')]));_0x1c3329[_0xddd8('0x30')]=_0x1c3329['attributes']['length']?_0x1c3329[_0xddd8('0x30')]:_0x1fb92a[_0xddd8('0x2c')];if(!_0x4087d3['query'][_0xddd8('0x4c')](_0xddd8('0x33'))){_0x1c3329[_0xddd8('0x1f')]=qs[_0xddd8('0x1f')](_0x4087d3[_0xddd8('0x2e')][_0xddd8('0x1f')]);_0x1c3329[_0xddd8('0x1e')]=qs[_0xddd8('0x1e')](_0x4087d3[_0xddd8('0x2e')]['offset']);}_0x1c3329[_0xddd8('0x34')]=qs[_0xddd8('0x35')](_0x4087d3[_0xddd8('0x2e')][_0xddd8('0x35')]);_0x1c3329['where']=qs[_0xddd8('0x2f')](_[_0xddd8('0x36')](_0x4087d3[_0xddd8('0x2e')],_0x1fb92a[_0xddd8('0x2f')]));_0x1c3329[_0xddd8('0x3c')]['ContactId']=_0x3bffab['id'];if(_0x4087d3['query'][_0xddd8('0x51')]){_0x1c3329[_0xddd8('0x3c')]=_[_0xddd8('0x69')](_0x1c3329['where'],{'$or':_[_0xddd8('0x4b')](_0x1c3329[_0xddd8('0x30')],function(_0x17c439){var _0xe868ae={};_0xe868ae[_0x17c439]={'$like':'%'+_0x4087d3[_0xddd8('0x2e')]['filter']+'%'};return _0xe868ae;})});}_0x1c3329=_['merge']({},_0x1c3329,_0x4087d3[_0xddd8('0xb1')]);return db[_0xddd8('0x9a')][_0xddd8('0x68')]({'where':_0x1c3329[_0xddd8('0x3c')]})[_0xddd8('0x25')](function(_0x319242){_0x15c235[_0xddd8('0x68')]=_0x319242;if(_0x4087d3[_0xddd8('0x2e')][_0xddd8('0xbb')]){_0x1c3329[_0xddd8('0xb7')]=[{'all':!![]}];}return db[_0xddd8('0x9a')][_0xddd8('0x77')](_0x1c3329);})[_0xddd8('0x25')](function(_0x138afd){_0x15c235['rows']=_0x138afd;return _0x15c235;});}})[_0xddd8('0x25')](respondWithFilteredResult(_0x4ee4c5,_0x1c3329))[_0xddd8('0x6e')](handleError(_0x4ee4c5,null));};exports[_0xddd8('0xbc')]=function(_0x1ad55a,_0x361c1b,_0x3e20d7){try{if(!_0x1ad55a[_0xddd8('0x7d')][_0xddd8('0x4f')]){throw new Error(_0xddd8('0xbd'));}if(!_0x1ad55a[_0xddd8('0x7d')][_0xddd8('0xbe')]){throw new Error(_0xddd8('0xbf'));}if(!_0x1ad55a[_0xddd8('0x7d')][_0xddd8('0xc0')]){throw new Error(_0xddd8('0xc1'));}if(!_0x1ad55a[_0xddd8('0x7d')]['socket_timestamp']){throw new Error(_0xddd8('0xc2'));}var _0x167200=_0x1ad55a['body']['binding_keys'][_0xddd8('0x6c')](',');var _0x405339=_0x1ad55a[_0xddd8('0x7d')][_0xddd8('0xc0')][_0xddd8('0x6c')](',');if(!_0x167200[_0xddd8('0x32')]||!_0x405339[_0xddd8('0x32')]||_0x167200['length']!==_0x405339[_0xddd8('0x32')]){throw new Error(_0xddd8('0xc3'));}_0x1ad55a[_0xddd8('0x7d')][_0xddd8('0x31')]=_[_0xddd8('0xc4')](_0x167200,_0x405339);if(!_0x1ad55a[_0xddd8('0x7d')][_0xddd8('0x31')][_0xddd8('0xad')]){throw new Error(_0xddd8('0xc5'));}if(!_0x1ad55a[_0xddd8('0x7d')][_0xddd8('0x31')][_0xddd8('0xc6')]){throw new Error(_0xddd8('0xc7'));}var _0x4739c5=path[_0xddd8('0x81')](config['root'],_0xddd8('0xc8'),_0x1ad55a[_0xddd8('0xc9')][_0xddd8('0xca')]);fs[_0xddd8('0xcb')](_0x4739c5,parseInt(_0xddd8('0xcc'),0x8));var _0x3d1bb1=require(_0xddd8('0xcd'))[_0xddd8('0xce')](path[_0xddd8('0x81')](__dirname,_0xddd8('0xcf')),[_0x4739c5,_0x1ad55a[_0xddd8('0x7d')][_0xddd8('0xbe')],_0x1ad55a[_0xddd8('0x7d')]['binding_values'],_0x1ad55a[_0xddd8('0x7d')]['ListId'],_0x1ad55a['body'][_0xddd8('0xd0')],_0x1ad55a[_0xddd8('0x7d')][_0xddd8('0x9d')],_0x1ad55a[_0xddd8('0x7d')][_0xddd8('0xd1')]]);return _0x361c1b[_0xddd8('0x1b')](0xc8)[_0xddd8('0x1d')]({'message':_0xddd8('0xd2'),'pid':_0x3d1bb1['pid']});}catch(_0x314be3){return _0x361c1b[_0xddd8('0x1b')](0x1f4)['send'](_0x314be3);}};exports[_0xddd8('0xd3')]=function(_0x4e6614,_0x56d9c1,_0x5bd857){var _0x2acae5=fs['createReadStream'](_0x4e6614[_0xddd8('0xc9')]['path']);Papa[_0xddd8('0x40')](_0x2acae5,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x17ab61){return _0x56d9c1['status'](0xc8)[_0xddd8('0x1d')]({'file':_0x4e6614[_0xddd8('0xc9')],'fields':_0x17ab61[_0xddd8('0xd4')][_0xddd8('0x31')]});}});};exports[_0xddd8('0xd5')]=function(_0x52fa6f,_0x337dc2,_0x165900){return db[_0xddd8('0xd6')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0xddd8('0xd7')}})[_0xddd8('0x25')](function(_0x5a4176){var _0x343364=![];if(!_0x52fa6f['body'][_0xddd8('0x4f')]){throw new Error(_0xddd8('0xbd'));}if(!_0x52fa6f[_0xddd8('0x7d')][_0xddd8('0xd8')][_0xddd8('0xad')]){throw new Error(_0xddd8('0xc5'));}if(!_0x52fa6f[_0xddd8('0x7d')][_0xddd8('0xd8')][_0xddd8('0xc6')]){throw new Error(_0xddd8('0xc7'));}if(!_0x52fa6f['body'][_0xddd8('0xd1')]){throw new Error(_0xddd8('0xc2'));}var _0x3e8364=require(_0xddd8('0xcd'))[_0xddd8('0xce')](path['join'](__dirname,'../../components/import/cm/csv2'),[_0x52fa6f[_0xddd8('0x71')]['id'],JSON[_0xddd8('0xd9')](_0x52fa6f[_0xddd8('0x7d')]),JSON[_0xddd8('0xd9')](_0x5a4176)]);_0x3e8364['on'](_0xddd8('0xda'),function(_0x5d38b1){_0x343364=!![];return _0x337dc2[_0xddd8('0x1b')](0xc8)['json']({'message':'start\x20child\x20process\x20correctly!','pid':_0x3e8364[_0xddd8('0xdb')]});});_0x3e8364['on'](_0xddd8('0xdc'),function(_0x3e7646){if(_0x3e7646&&!_0x343364){return _0x337dc2[_0xddd8('0x1b')](0x1f4)[_0xddd8('0x1d')]({'message':_0xddd8('0xdd'),'pid':_0x3e8364[_0xddd8('0xdb')]});}});})['catch'](handleError(_0x337dc2,null));};
\ No newline at end of file
+var _0x5699=['rows','destroy','find','catch','startsWith','cf_','CmCustomField','findAll','columnName','displayName','alias','custom','values','error','Error\x20customFields:\x20filed\x20%s\x20not\x20present\x20in\x20table\x20cm_contact','body','from','get','mergeWith','tags','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','update','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','FaxQueueReport','MailQueueReport','JscriptySessionReport','join','bulkCreate','each','duplicates','$or','findOrCreate','show','Tag','Tags','$and','omit','format','cf_%d','pickBy','isEmpty','table','cm_contacts','id\x20=\x20?','params','toParam','text','phone','findOne','rawAttributes','options','getTags','setTags','ids','getHoppers','ContactId','getHopperHistories','includeAll','include','getHopperFinals','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','No\x20association\x20values\x20specified!','socket_timestamp','binding_values','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','root','server/files/tmp','file','chmodSync','0777','fork','../../components/import/cm/csv','CompanyId','pid','upload','createReadStream','meta','import','User','agent','binding','child_process','../../components/import/cm/csv2','stringify','message','exit','error\x20child\x20process','html-pdf','eml-format','rimraf','fast-json-patch','request-promise','moment','util','path','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','redis','localhost','./cmContact.socket','sendStatus','end','status','count','offset','limit','json','reject','save','then','name','send','CmContact','describe','model','keys','query','intersection','fields','attributes','nolimit','order','sort','where','filters','pick','select','field','tools_tags','c.deletedAt\x20IS\x20NULL','advancedFilter','parse','forEach','condition','isArray','value','and','tableAlias','\x20=\x20?','\x20LIKE\x20?','\x20>\x20?','\x20<\x20?','map','hasOwnProperty','filter','isNil','ListId','c.ListId\x20IN\x20?','replace','\x27\x27\x27\x27','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','c.email\x20LIKE\x20?','c.lastName\x20LIKE\x20?','DESC','group','c.id','QueryTypes','SELECT','clone','COUNT(*)','tag','expr','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','having','left_join','cm_contact_has_tags','ct.CmContactId\x20=\x20c.id','sequelize','toString','length','merge','c.*','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','t.id\x20=\x20ct.TagId','split','push'];(function(_0xf59452,_0xe960df){var _0x3ce854=function(_0x47c2e6){while(--_0x47c2e6){_0xf59452['push'](_0xf59452['shift']());}};_0x3ce854(++_0xe960df);}(_0x5699,0x148));var _0x9569=function(_0x6404ef,_0x113b95){_0x6404ef=_0x6404ef-0x0;var _0xceb636=_0x5699[_0x6404ef];return _0xceb636;};'use strict';var pdf=require(_0x9569('0x0'));var emlformat=require(_0x9569('0x1'));var rimraf=require(_0x9569('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x9569('0x3'));var rp=require(_0x9569('0x4'));var moment=require(_0x9569('0x5'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x9569('0x6'));var path=require(_0x9569('0x7'));var sox=require('sox');var csv=require(_0x9569('0x8'));var ejs=require(_0x9569('0x9'));var fs=require('fs');var _=require(_0x9569('0xa'));var squel=require(_0x9569('0xb'));var crypto=require(_0x9569('0xc'));var jsforce=require(_0x9569('0xd'));var deskjs=require(_0x9569('0xe'));var toCsv=require('to-csv');var querystring=require(_0x9569('0xf'));var Papa=require(_0x9569('0x10'));var Redis=require(_0x9569('0x11'));var authService=require(_0x9569('0x12'));var qs=require(_0x9569('0x13'));var hardwareService=require(_0x9569('0x14'));var logger=require(_0x9569('0x15'))('api');var utils=require(_0x9569('0x16'));var config=require(_0x9569('0x17'));var db=require(_0x9569('0x18'))['db'];config[_0x9569('0x19')]=_['defaults'](config[_0x9569('0x19')],{'host':_0x9569('0x1a'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));require(_0x9569('0x1b'))['register'](socket);function respondWithStatusCode(_0x3028bc,_0xa833e9){_0xa833e9=_0xa833e9||0xcc;return function(_0x3d2db6){if(_0x3d2db6){return _0x3028bc[_0x9569('0x1c')](_0xa833e9);}return _0x3028bc['status'](_0xa833e9)[_0x9569('0x1d')]();};}function respondWithResult(_0x52ab91,_0x58934d){_0x58934d=_0x58934d||0xc8;return function(_0x1467df){if(_0x1467df){return _0x52ab91[_0x9569('0x1e')](_0x58934d)['json'](_0x1467df);}};}function respondWithFilteredResult(_0x399032,_0x4a266e){return function(_0x20c6d6){if(_0x20c6d6){var _0x3656ad=_0x20c6d6[_0x9569('0x1f')],_0x37233e=_0x4a266e[_0x9569('0x20')],_0x56dda4=_0x4a266e[_0x9569('0x20')]+_0x4a266e[_0x9569('0x21')],_0xfab502;if(_0x56dda4>=_0x3656ad){_0x56dda4=_0x3656ad;_0xfab502=0xc8;}else{_0xfab502=0xce;}_0x399032[_0x9569('0x1e')](_0xfab502);return _0x399032['set']('Content-Range',_0x37233e+'-'+_0x56dda4+'/'+_0x3656ad)[_0x9569('0x22')](_0x20c6d6);}return null;};}function patchUpdates(_0x822730){return function(_0x493186){try{jsonpatch['apply'](_0x493186,_0x822730,!![]);}catch(_0x7e14aa){return BPromise[_0x9569('0x23')](_0x7e14aa);}return _0x493186[_0x9569('0x24')]();};}function saveUpdates(_0x520e89,_0x56015e){return function(_0x2cf058){if(_0x2cf058){return _0x2cf058['update'](_0x520e89)[_0x9569('0x25')](function(_0x58e34b){return _0x58e34b;});}return null;};}function removeEntity(_0x998b08,_0x1a6ac9){return function(_0x2b5403){if(_0x2b5403){return _0x2b5403['destroy']()['then'](function(){_0x998b08[_0x9569('0x1e')](0xcc)[_0x9569('0x1d')]();});}};}function handleEntityNotFound(_0x5ca833,_0x245847){return function(_0x4e7128){if(!_0x4e7128){_0x5ca833[_0x9569('0x1c')](0x194);}return _0x4e7128;};}function handleError(_0x4103d3,_0x30926d){_0x30926d=_0x30926d||0x1f4;return function(_0x2c495f){logger['error'](_0x2c495f['stack']);if(_0x2c495f[_0x9569('0x26')]){delete _0x2c495f[_0x9569('0x26')];}_0x4103d3[_0x9569('0x1e')](_0x30926d)[_0x9569('0x27')](_0x2c495f);};}exports['index']=function(_0x2aa24c,_0x515e93){var _0x35c3e0={},_0x32d9b2={},_0x267e73={'count':0x0,'rows':[]};return db[_0x9569('0x28')][_0x9569('0x29')]()[_0x9569('0x25')](function(_0x1d07e3){_0x32d9b2[_0x9569('0x2a')]=_['keys'](_0x1d07e3);_0x32d9b2['query']=_[_0x9569('0x2b')](_0x2aa24c[_0x9569('0x2c')]);_0x32d9b2['filters']=_[_0x9569('0x2d')](_0x32d9b2['model'],_0x32d9b2['query']);_0x35c3e0['attributes']=_[_0x9569('0x2d')](_0x32d9b2[_0x9569('0x2a')],qs['fields'](_0x2aa24c[_0x9569('0x2c')][_0x9569('0x2e')]));_0x35c3e0['attributes']=_0x35c3e0[_0x9569('0x2f')]['length']?_0x35c3e0[_0x9569('0x2f')]:_0x32d9b2['model'];if(!_0x2aa24c[_0x9569('0x2c')]['hasOwnProperty'](_0x9569('0x30'))){_0x35c3e0[_0x9569('0x21')]=qs[_0x9569('0x21')](_0x2aa24c[_0x9569('0x2c')]['limit']);_0x35c3e0[_0x9569('0x20')]=qs[_0x9569('0x20')](_0x2aa24c[_0x9569('0x2c')][_0x9569('0x20')]);}_0x35c3e0[_0x9569('0x31')]=qs[_0x9569('0x32')](_0x2aa24c[_0x9569('0x2c')][_0x9569('0x32')]);_0x35c3e0[_0x9569('0x33')]=qs[_0x9569('0x34')](_[_0x9569('0x35')](_0x2aa24c[_0x9569('0x2c')],_0x32d9b2[_0x9569('0x34')]));var _0x2644b2=[];var _0x2b801c=squel[_0x9569('0x36')]()[_0x9569('0x37')]('id')[_0x9569('0x37')]('name')[_0x9569('0x37')]('color')['from'](_0x9569('0x38'));var _0x5aa64e=squel[_0x9569('0x36')]()['from']('cm_contacts','c')['where'](_0x9569('0x39'));var _0x368412=squel['expr']();if(_0x2aa24c[_0x9569('0x2c')][_0x9569('0x3a')]){var _0x49aabf=JSON[_0x9569('0x3b')](_0x2aa24c[_0x9569('0x2c')][_0x9569('0x3a')]);_['keys'](_0x49aabf)[_0x9569('0x3c')](function(_0x49e340){var _0x346f70=_0x49aabf[_0x49e340];switch(_0x346f70[_0x9569('0x3d')]){case'IS':if(_[_0x9569('0x3e')](_0x346f70[_0x9569('0x3f')])&&_0x346f70[_0x9569('0x3f')]['length']>0x1){_0x368412[_0x9569('0x40')](_0x346f70['tableAlias']+'.'+_0x49e340+'\x20IN\x20?',_0x346f70[_0x9569('0x3f')]);}else{_0x368412['and'](_0x346f70[_0x9569('0x41')]+'.'+_0x49e340+_0x9569('0x42'),_0x346f70['value'][0x0]);}break;case'=':_0x368412[_0x9569('0x40')](_0x346f70[_0x9569('0x41')]+'.'+_0x49e340+_0x9569('0x42'),_0x346f70[_0x9569('0x3f')]);break;case'LIKE':_0x368412[_0x9569('0x40')](_0x346f70['tableAlias']+'.'+_0x49e340+_0x9569('0x43'),'%'+_0x346f70[_0x9569('0x3f')]+'%');break;case'>':_0x368412[_0x9569('0x40')](_0x346f70[_0x9569('0x41')]+'.'+_0x49e340+_0x9569('0x44'),_0x346f70['value']);break;case'<':_0x368412['and'](_0x346f70['tableAlias']+'.'+_0x49e340+_0x9569('0x45'),_0x346f70[_0x9569('0x3f')]);break;}});}else{var _0x3fb784=_(Object[_0x9569('0x2b')](_0x2aa24c[_0x9569('0x2c')]))[_0x9569('0x46')](function(_0x4ea02a){return _0x1d07e3[_0x9569('0x47')](_0x4ea02a)?_0x4ea02a:undefined;})[_0x9569('0x48')](function(_0x37b3d4){return!_[_0x9569('0x49')](_0x37b3d4);})[_0x9569('0x3f')]();if(!_['isEmpty'](_0x3fb784)){_0x3fb784[_0x9569('0x3c')](function(_0x18a205){if(_0x18a205===_0x9569('0x4a')){_0x5aa64e[_0x9569('0x33')](_0x9569('0x4b'),[]['concat'](_0x2aa24c[_0x9569('0x2c')][_0x18a205]));}else{_0x5aa64e[_0x9569('0x33')]('c.'+_0x18a205+_0x9569('0x42'),_0x2aa24c[_0x9569('0x2c')][_0x18a205]);}});}if(_0x2aa24c[_0x9569('0x2c')]['filter']){var _0x7062c4=_0x2aa24c[_0x9569('0x2c')]['filter'][_0x9569('0x4c')]('\x5c','\x5c\x5c')[_0x9569('0x4c')]('\x27\x27',_0x9569('0x4d'));if(qs['isNumeric'](_0x7062c4)){_0x368412['or'](_0x9569('0x4e'),_0x7062c4+'%');_0x368412['or'](_0x9569('0x4f'),_0x7062c4+'%');_0x368412['or'](_0x9569('0x50'),_0x7062c4+'%');_0x368412['or'](_0x9569('0x51'),_0x7062c4+'%');}else if(qs['isEmail'](_0x7062c4)){_0x368412['or'](_0x9569('0x52'),_0x7062c4+'%');}else{_0x368412['or'](_0x9569('0x52'),_0x7062c4+'%');_0x368412['or']('c.firstName\x20LIKE\x20?',_0x7062c4+'%');_0x368412['or'](_0x9569('0x53'),_0x7062c4+'%');}}}_0x5aa64e['where'](_0x368412);if(_0x35c3e0['order']){_0x35c3e0[_0x9569('0x31')]['forEach'](function(_0x32fbe1){_0x5aa64e['order']('c.'+_0x32fbe1[0x0],_0x32fbe1[0x1]===_0x9569('0x54')?![]:!![]);});}_0x5aa64e[_0x9569('0x55')](_0x9569('0x56'));var _0x329bdb={'type':db['Sequelize'][_0x9569('0x57')][_0x9569('0x58')],'raw':!![]};var _0x10fccc=_0x5aa64e[_0x9569('0x59')]()['field'](_0x9569('0x5a'));if(!_0x2aa24c[_0x9569('0x2c')][_0x9569('0x3a')]){if(_0x2aa24c['query'][_0x9569('0x5b')]){var _0x59b510=_[_0x9569('0x3e')](_0x2aa24c[_0x9569('0x2c')]['tag'])?_0x2aa24c[_0x9569('0x2c')][_0x9569('0x5b')]:new Array(_0x2aa24c[_0x9569('0x2c')][_0x9569('0x5b')]);var _0x2ce79a=squel[_0x9569('0x5c')]();_0x59b510[_0x9569('0x3c')](function(_0x43ec26){_0x2ce79a['or'](_0x9569('0x5d'),'%,'+_0x43ec26+',%');});_0x5aa64e[_0x9569('0x5e')](_0x2ce79a);_0x10fccc[_0x9569('0x5f')](_0x9569('0x60'),'ct',_0x9569('0x61'));_0x10fccc[_0x9569('0x5f')](_0x9569('0x38'),'t','t.id\x20=\x20ct.TagId');_0x10fccc[_0x9569('0x33')]('t.id\x20IN\x20?',_0x59b510);}}db[_0x9569('0x62')][_0x9569('0x2c')](_0x2b801c[_0x9569('0x63')](),_0x329bdb)[_0x9569('0x25')](function(_0x155a3b){_0x2644b2=_['keyBy'](_0x155a3b,'id');return db[_0x9569('0x62')][_0x9569('0x2c')](_0x10fccc[_0x9569('0x63')](),_0x329bdb);})[_0x9569('0x25')](function(_0x4e1acc){_0x267e73[_0x9569('0x1f')]=_0x4e1acc[_0x9569('0x64')];_0x329bdb=_[_0x9569('0x65')](_0x329bdb,{'model':db[_0x9569('0x28')],'mapToModel':!![],'raw':!![],'nest':!![]});_0x5aa64e[_0x9569('0x37')](_0x9569('0x66'));_0x5aa64e['field'](_0x9569('0x67'),_0x9569('0x68'));_0x5aa64e[_0x9569('0x5f')]('cm_contact_has_tags','ct',_0x9569('0x61'));_0x5aa64e[_0x9569('0x5f')](_0x9569('0x38'),'t',_0x9569('0x69'));if(_0x35c3e0[_0x9569('0x21')]){_0x5aa64e['limit'](_0x35c3e0['limit']);}if(_0x35c3e0['offset']){_0x5aa64e[_0x9569('0x20')](_0x35c3e0[_0x9569('0x20')]);}db[_0x9569('0x62')][_0x9569('0x2c')](_0x5aa64e[_0x9569('0x63')](),_0x329bdb)[_0x9569('0x25')](function(_0x4043c4){_0x4043c4[_0x9569('0x3c')](function(_0x551ff7){if(_0x551ff7[_0x9569('0x68')]){_0x551ff7['Tags']=[];_0x551ff7[_0x9569('0x68')][_0x9569('0x6a')](',')[_0x9569('0x3c')](function(_0xa62ed3){_0x551ff7['Tags'][_0x9569('0x6b')](_0x2644b2[_0xa62ed3]);});}delete _0x551ff7[_0x9569('0x68')];});_0x267e73[_0x9569('0x6c')]=_0x4043c4;return _0x267e73;})[_0x9569('0x25')](respondWithFilteredResult(_0x515e93,_0x35c3e0))['catch'](handleError(_0x515e93,null));});});};exports[_0x9569('0x6d')]=function(_0x219eda,_0x22be74){return db[_0x9569('0x28')][_0x9569('0x6e')]({'where':{'id':_0x219eda['params']['id']}})['then'](handleEntityNotFound(_0x22be74,null))['then'](removeEntity(_0x22be74,null))[_0x9569('0x6f')](handleError(_0x22be74,null));};exports[_0x9569('0x29')]=function(_0x34d0f7,_0x24f280){return db['CmContact'][_0x9569('0x29')]()['then'](function(_0x2bd966){for(var _0x1d27cb=0x0;_0x1d27cb<Object[_0x9569('0x2b')](_0x2bd966)[_0x9569('0x64')];_0x1d27cb++){var _0x43d533=Object[_0x9569('0x2b')](_0x2bd966)[_0x1d27cb];if(!_[_0x9569('0x70')](_0x43d533,_0x9569('0x71'))){_0x2bd966[_0x43d533]['columnName']=_0x43d533;_0x2bd966[_0x43d533]['displayName']=_0x43d533;}}return _0x2bd966;})[_0x9569('0x25')](function(_0x61a397){var _0x20f379={'where':{'$or':[{'ListId':_0x34d0f7[_0x9569('0x2c')]['id']},{'ListId':null}]},'raw':!![]};return db[_0x9569('0x72')][_0x9569('0x73')](_0x20f379)['then'](function(_0x333849){for(var _0x2b9a7b=0x0;_0x2b9a7b<_0x333849[_0x9569('0x64')];_0x2b9a7b++){var _0x48efaf=_0x9569('0x71')+_0x333849[_0x2b9a7b]['id'];if(_0x61a397[_0x48efaf]){_0x61a397[_0x48efaf][_0x9569('0x74')]=_0x48efaf;_0x61a397[_0x48efaf][_0x9569('0x75')]=_0x333849[_0x2b9a7b][_0x9569('0x76')];_0x61a397[_0x48efaf][_0x9569('0x77')]={'type':_0x333849[_0x2b9a7b]['type'],'values':_0x333849[_0x2b9a7b][_0x9569('0x78')]};}else{logger[_0x9569('0x79')](_0x9569('0x7a'),_0x48efaf);}}Object['keys'](_0x61a397)[_0x9569('0x3c')](function(_0x4f93b5){if(!_0x61a397[_0x4f93b5][_0x9569('0x47')](_0x9569('0x74'))){delete _0x61a397[_0x4f93b5];}});return _0x61a397;});})[_0x9569('0x25')](respondWithResult(_0x24f280,null))[_0x9569('0x6f')](handleError(_0x24f280,null));};exports[_0x9569('0x65')]=function(_0x443d72,_0x41c97d){var _0x40989c;var _0x22dd43;var _0x2fdb06;if(_0x443d72[_0x9569('0x7b')]['id']){delete _0x443d72[_0x9569('0x7b')]['id'];}return db[_0x9569('0x28')]['findAll']({'where':{'id':[_0x443d72[_0x9569('0x7b')]['to'],_0x443d72['body'][_0x9569('0x7c')]]}})['then'](function(_0x5b6a4f){if(_0x5b6a4f){if(_0x5b6a4f[_0x9569('0x64')]!==0x2){return null;}_0x5b6a4f[0x0]=_0x5b6a4f[0x0][_0x9569('0x7d')]({'plain':!![]});_0x5b6a4f[0x1]=_0x5b6a4f[0x1][_0x9569('0x7d')]({'plain':!![]});delete _0x5b6a4f[0x0]['id'];delete _0x5b6a4f[0x1]['id'];return _[_0x9569('0x7e')](_0x5b6a4f[0x0],_0x5b6a4f[0x1],function(_0x4d55c8,_0x578760){if(Array[_0x9569('0x3e')](_0x578760)&&!_0x578760[_0x9569('0x64')]){return _0x4d55c8;}else if(!_0x578760){return _0x4d55c8;}});}})[_0x9569('0x25')](handleEntityNotFound(_0x41c97d,null))[_0x9569('0x25')](function(_0x145a92){if(_0x145a92){if(_0x145a92[_0x9569('0x7f')]&&_[_0x9569('0x3e')](_0x145a92['tags'])){_0x145a92['tags']=_0x145a92[_0x9569('0x7f')]['join']();}logger[_0x9569('0x80')](_0x9569('0x81'),_0x443d72[_0x9569('0x7b')]['to'],_0x443d72[_0x9569('0x7b')][_0x9569('0x7c')]);return db[_0x9569('0x82')][_0x9569('0x6d')]({'where':{'ContactId':[_0x443d72[_0x9569('0x7b')]['to'],_0x443d72[_0x9569('0x7b')]['from']]}})[_0x9569('0x25')](function(_0x4217c2){logger['info']('[CmContact][merge][destroy][CmHopper],\x20%s',_0x4217c2);return db[_0x9569('0x83')][_0x9569('0x6d')]({'where':{'ContactId':[_0x443d72[_0x9569('0x7b')]['to'],_0x443d72[_0x9569('0x7b')][_0x9569('0x7c')]]}})[_0x9569('0x25')](function(_0x1663ab){logger[_0x9569('0x80')](_0x9569('0x84'),_0x1663ab);return db[_0x9569('0x28')][_0x9569('0x85')](_0x145a92);});});}})[_0x9569('0x25')](function(_0x1a9b46){if(_0x1a9b46){_0x40989c=_0x1a9b46;_0x22dd43={'ContactId':_0x40989c['id']};_0x2fdb06={'where':{'ContactId':[_0x443d72[_0x9569('0x7b')]['to'],_0x443d72['body'][_0x9569('0x7c')]]}};return db[_0x9569('0x86')][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})[_0x9569('0x25')](function(){if(_0x40989c){return db[_0x9569('0x88')][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})['then'](function(){if(_0x40989c){return db[_0x9569('0x89')][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})[_0x9569('0x25')](function(){if(_0x40989c){return db[_0x9569('0x8a')][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})[_0x9569('0x25')](function(){if(_0x40989c){return db[_0x9569('0x8b')][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})[_0x9569('0x25')](function(){if(_0x40989c){return db[_0x9569('0x8a')][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})['then'](function(){if(_0x40989c){return db[_0x9569('0x8b')][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})[_0x9569('0x25')](function(){if(_0x40989c){return db[_0x9569('0x8c')]['update'](_0x22dd43,_0x2fdb06);}})[_0x9569('0x25')](function(){if(_0x40989c){return db[_0x9569('0x8d')][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})['then'](function(){if(_0x40989c){return db[_0x9569('0x8e')][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})['then'](function(){if(_0x40989c){return db['FaxMessage'][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})[_0x9569('0x25')](function(){if(_0x40989c){return db[_0x9569('0x8f')]['update'](_0x22dd43,_0x2fdb06);}})[_0x9569('0x25')](function(){if(_0x40989c){return db[_0x9569('0x90')][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})[_0x9569('0x25')](function(){if(_0x40989c){return db[_0x9569('0x91')]['update'](_0x22dd43,_0x2fdb06);}})['then'](function(){if(_0x40989c){return db[_0x9569('0x92')][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})['then'](function(){if(_0x40989c){return db['ReportAgentPreview'][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})[_0x9569('0x25')](function(){if(_0x40989c){return db['VoiceCallReport'][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})[_0x9569('0x25')](function(){if(_0x40989c){return db['ChatQueueReport']['update'](_0x22dd43,_0x2fdb06);}})[_0x9569('0x25')](function(){if(_0x40989c){return db[_0x9569('0x93')][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})[_0x9569('0x25')](function(){if(_0x40989c){return db[_0x9569('0x94')][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})[_0x9569('0x25')](function(){if(_0x40989c){return db['OpenchannelQueueReport'][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})[_0x9569('0x25')](function(){if(_0x40989c){return db['SmsQueueReport'][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})[_0x9569('0x25')](function(){if(_0x40989c){return db[_0x9569('0x95')][_0x9569('0x87')](_0x22dd43,_0x2fdb06);}})[_0x9569('0x25')](function(){if(_0x40989c){return db[_0x9569('0x28')]['destroy']({'where':{'id':[_0x443d72[_0x9569('0x7b')]['to'],_0x443d72[_0x9569('0x7b')][_0x9569('0x7c')]]}});}})['then'](function(){if(_0x40989c){return _0x40989c;}})['then'](respondWithResult(_0x41c97d,null))[_0x9569('0x6f')](handleError(_0x41c97d,null));};exports[_0x9569('0x85')]=function(_0x8d2e34,_0x4af433){return db['CmContact'][_0x9569('0x29')]()[_0x9569('0x25')](function(_0x555922){if(_0x8d2e34[_0x9569('0x7b')][_0x9569('0x7f')]&&_[_0x9569('0x3e')](_0x8d2e34[_0x9569('0x7b')]['tags'])){if(_0x8d2e34[_0x9569('0x7b')][_0x9569('0x7f')][_0x9569('0x64')]){_0x8d2e34[_0x9569('0x7b')][_0x9569('0x7f')]=_0x8d2e34[_0x9569('0x7b')]['tags'][_0x9569('0x96')](';')+';';}else{_0x8d2e34[_0x9569('0x7b')]['tags']=null;}}else{_0x8d2e34[_0x9569('0x7b')][_0x9569('0x7f')]=null;}return db[_0x9569('0x28')][_0x9569('0x85')](_0x8d2e34[_0x9569('0x7b')],{'fields':_[_0x9569('0x2b')](_0x555922),'raw':!![]});})[_0x9569('0x25')](respondWithResult(_0x4af433,0xc9))[_0x9569('0x6f')](handleError(_0x4af433,null));};exports[_0x9569('0x97')]=function(_0x20f1ca,_0x415b71){var _0x421002=[];var _0x25f215=0x0;var _0x522385=0x0;var _0x169e89=0x0;return db[_0x9569('0x28')][_0x9569('0x29')]()['then'](function(_0x10f56f){return BPromise[_0x9569('0x98')](_0x20f1ca[_0x9569('0x7b')],function(_0x79352f){var _0x560908={'where':{'$or':[]},'defaults':_0x79352f,'fields':_[_0x9569('0x2b')](_0x10f56f),'raw':!![]};if(_0x79352f[_0x9569('0x99')]){for(var _0x946c40=0x0;_0x946c40<_0x79352f['duplicates']['length'];_0x946c40++){var _0x3ee0ee={};_0x3ee0ee[_0x79352f['duplicates'][_0x946c40]]=_0x79352f[_0x79352f['duplicates'][_0x946c40]];_0x560908[_0x9569('0x33')][_0x9569('0x9a')][_0x9569('0x6b')](_0x3ee0ee);}_0x560908[_0x9569('0x33')][_0x9569('0x4a')]=_0x79352f[_0x9569('0x4a')];}return db[_0x9569('0x28')][_0x9569('0x9b')](_0x560908)['spread'](function(_0x11e512,_0x2bea02){if(_0x2bea02){_0x25f215++;}else{_0x169e89++;}})[_0x9569('0x6f')](function(_0x52fd1a){console['error'](_0x52fd1a);_0x522385++;});});})[_0x9569('0x25')](function(_0x2ffea5){if(_0x2ffea5){return{'success':_0x25f215,'failure':_0x522385,'duplicates':_0x169e89};}})[_0x9569('0x25')](respondWithResult(_0x415b71,0xc9))[_0x9569('0x6f')](handleError(_0x415b71,null));};exports[_0x9569('0x9c')]=function(_0x44f728,_0x545800,_0x5973dc){var _0x273d73;return db['CmContact'][_0x9569('0x29')]()[_0x9569('0x25')](function(_0x4f583c){return db['CmContact'][_0x9569('0x6e')]({'where':{'id':_0x44f728['params']['id']},'include':[{'model':db[_0x9569('0x9d')],'as':_0x9569('0x9e'),'attributes':['id',_0x9569('0x26'),'color'],'required':_0x44f728['query']['tag']?!![]:![]}],'attributes':_[_0x9569('0x2b')](_0x4f583c)});})[_0x9569('0x25')](function(_0x37dbb4){_0x273d73=_0x37dbb4[_0x9569('0x7d')]({'plain':!![]});var _0x221cc5={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x37dbb4&&_0x37dbb4[_0x9569('0x4a')]){if(_0x37dbb4[_0x9569('0x4a')]){_0x221cc5[_0x9569('0x33')][_0x9569('0x9f')][_0x9569('0x6b')]({'ListId':{'$ne':_0x37dbb4[_0x9569('0x4a')]}});}}return db['CmCustomField'][_0x9569('0x73')](_0x221cc5);})[_0x9569('0x25')](function(_0x2f3fb1){return _[_0x9569('0xa0')](_0x273d73,_['map'](_0x2f3fb1,function(_0x4521e7){return util[_0x9569('0xa1')](_0x9569('0xa2'),_0x4521e7['id']);}));})[_0x9569('0x25')](handleEntityNotFound(_0x545800,null))[_0x9569('0x25')](respondWithResult(_0x545800,null))[_0x9569('0x6f')](handleError(_0x545800,null));};exports['update']=function(_0x55c614,_0x2c4d3b){var _0x595787;if(_0x55c614['body']['id']){delete _0x55c614[_0x9569('0x7b')]['id'];}return db['CmContact']['find']({'where':{'id':_0x55c614['params']['id']}})[_0x9569('0x25')](handleEntityNotFound(_0x2c4d3b,null))['then'](saveUpdates(_0x55c614[_0x9569('0x7b')],null))['then'](function(_0x21ed8a){_0x595787=_0x21ed8a;var _0x5f1caa={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x21ed8a&&_0x21ed8a['ListId']){if(_0x21ed8a[_0x9569('0x4a')]){_0x5f1caa['where'][_0x9569('0x9f')][_0x9569('0x6b')]({'ListId':{'$ne':_0x21ed8a['ListId']}});}}return db[_0x9569('0x72')][_0x9569('0x73')](_0x5f1caa);})['then'](function(_0x42974b){if(_0x42974b){return _[_0x9569('0xa0')](_[_0x9569('0xa3')](_0x55c614[_0x9569('0x7b')],function(_0x3e06c9,_0x5476c0){return _[_0x9569('0x70')](_0x5476c0,_0x9569('0x71'));}),_['map'](_0x42974b,function(_0x3e42ed){return util[_0x9569('0xa1')]('cf_%d',_0x3e42ed['id']);}));}})[_0x9569('0x25')](function(_0x2dc656){if(_0x2dc656&&!_[_0x9569('0xa4')](_0x2dc656)){var _0x33c5e9=squel[_0x9569('0x87')]()[_0x9569('0xa5')](_0x9569('0xa6'))['setFields'](_0x2dc656)[_0x9569('0x33')](_0x9569('0xa7'),_0x55c614[_0x9569('0xa8')]['id'])[_0x9569('0xa9')]();return db['sequelize'][_0x9569('0x2c')](_0x33c5e9[_0x9569('0xaa')],{'replacements':_0x33c5e9[_0x9569('0x78')]});}})[_0x9569('0x25')](function(){if(_0x55c614[_0x9569('0x7b')][_0x9569('0xab')]&&_0x595787){return db[_0x9569('0x82')]['update']({'phone':_0x55c614['body'][_0x9569('0xab')]},{'where':{'ContactId':_0x595787['id']}});}})[_0x9569('0x25')](function(){return _0x595787;})[_0x9569('0x25')](respondWithResult(_0x2c4d3b,null))[_0x9569('0x6f')](handleError(_0x2c4d3b,null));};exports['getTags']=function(_0x34925d,_0x4f3442,_0x1c35e0){var _0x67641c={};var _0xfdf451={};var _0x347431;var _0x54ffbb;return db['CmContact'][_0x9569('0xac')]({'where':{'id':_0x34925d['params']['id']}})[_0x9569('0x25')](handleEntityNotFound(_0x4f3442,null))[_0x9569('0x25')](function(_0x444be2){if(_0x444be2){_0x347431=_0x444be2;_0xfdf451[_0x9569('0x2a')]=_[_0x9569('0x2b')](db['Tag'][_0x9569('0xad')]);_0xfdf451['query']=_[_0x9569('0x2b')](_0x34925d[_0x9569('0x2c')]);_0xfdf451['filters']=_['intersection'](_0xfdf451['model'],_0xfdf451[_0x9569('0x2c')]);_0x67641c['attributes']=_[_0x9569('0x2d')](_0xfdf451[_0x9569('0x2a')],qs[_0x9569('0x2e')](_0x34925d[_0x9569('0x2c')][_0x9569('0x2e')]));_0x67641c[_0x9569('0x2f')]=_0x67641c[_0x9569('0x2f')][_0x9569('0x64')]?_0x67641c[_0x9569('0x2f')]:_0xfdf451[_0x9569('0x2a')];_0x67641c['order']=qs['sort'](_0x34925d[_0x9569('0x2c')]['sort']);_0x67641c['where']=qs[_0x9569('0x34')](_['pick'](_0x34925d[_0x9569('0x2c')],_0xfdf451[_0x9569('0x34')]));if(_0x34925d['query']['filter']){_0x67641c['where']=_[_0x9569('0x65')](_0x67641c[_0x9569('0x33')],{'$or':_[_0x9569('0x46')](_0x67641c['attributes'],function(_0x260662){var _0x2b77e5={};_0x2b77e5[_0x260662]={'$like':'%'+_0x34925d[_0x9569('0x2c')][_0x9569('0x48')]+'%'};return _0x2b77e5;})});}_0x67641c=_[_0x9569('0x65')]({},_0x67641c,_0x34925d[_0x9569('0xae')]);return _0x347431['getTags'](_0x67641c);}})[_0x9569('0x25')](function(_0xe22706){if(_0xe22706){_0x54ffbb=_0xe22706['length'];if(!_0x34925d[_0x9569('0x2c')][_0x9569('0x47')]('nolimit')){_0x67641c['limit']=qs['limit'](_0x34925d[_0x9569('0x2c')][_0x9569('0x21')]);_0x67641c[_0x9569('0x20')]=qs[_0x9569('0x20')](_0x34925d[_0x9569('0x2c')]['offset']);}return _0x347431[_0x9569('0xaf')](_0x67641c);}})['then'](function(_0x2304dc){if(_0x2304dc){return _0x2304dc?{'count':_0x54ffbb,'rows':_0x2304dc}:null;}})[_0x9569('0x25')](respondWithResult(_0x4f3442,null))[_0x9569('0x6f')](handleError(_0x4f3442,null));};exports[_0x9569('0xb0')]=function(_0x3c05a6,_0x37eff0,_0xd81e47){if(_0x3c05a6[_0x9569('0x7b')]['id']){delete _0x3c05a6[_0x9569('0x7b')]['id'];}return db['CmContact'][_0x9569('0xac')]({'where':{'id':_0x3c05a6['params']['id']}})['then'](handleEntityNotFound(_0x37eff0,null))['then'](function(_0x1127ca){if(_0x1127ca){return _0x1127ca[_0x9569('0xb0')](_0x3c05a6[_0x9569('0x7b')][_0x9569('0xb1')]||[]);}return null;})[_0x9569('0x25')](respondWithResult(_0x37eff0,null))[_0x9569('0x6f')](handleError(_0x37eff0,null));};exports[_0x9569('0xb2')]=function(_0x7f9520,_0x2b1cc4,_0x1585e7){var _0x2bd23e={'raw':![],'where':{}};var _0x8d092e={};var _0x1bd827={'count':0x0,'rows':[]};return db['CmContact'][_0x9569('0xac')]({'where':{'id':_0x7f9520['params']['id']}})[_0x9569('0x25')](handleEntityNotFound(_0x2b1cc4,null))['then'](function(_0x4053df){if(_0x4053df){_0x8d092e[_0x9569('0x2a')]=_[_0x9569('0x2b')](db[_0x9569('0x82')][_0x9569('0xad')]);_0x8d092e[_0x9569('0x2c')]=_['keys'](_0x7f9520['query']);_0x8d092e[_0x9569('0x34')]=_[_0x9569('0x2d')](_0x8d092e['model'],_0x8d092e[_0x9569('0x2c')]);_0x2bd23e[_0x9569('0x2f')]=_[_0x9569('0x2d')](_0x8d092e['model'],qs[_0x9569('0x2e')](_0x7f9520['query'][_0x9569('0x2e')]));_0x2bd23e['attributes']=_0x2bd23e[_0x9569('0x2f')]['length']?_0x2bd23e[_0x9569('0x2f')]:_0x8d092e[_0x9569('0x2a')];if(!_0x7f9520[_0x9569('0x2c')]['hasOwnProperty']('nolimit')){_0x2bd23e[_0x9569('0x21')]=qs[_0x9569('0x21')](_0x7f9520[_0x9569('0x2c')][_0x9569('0x21')]);_0x2bd23e['offset']=qs[_0x9569('0x20')](_0x7f9520[_0x9569('0x2c')][_0x9569('0x20')]);}_0x2bd23e[_0x9569('0x31')]=qs[_0x9569('0x32')](_0x7f9520[_0x9569('0x2c')][_0x9569('0x32')]);_0x2bd23e['where']=qs[_0x9569('0x34')](_['pick'](_0x7f9520['query'],_0x8d092e[_0x9569('0x34')]));_0x2bd23e[_0x9569('0x33')][_0x9569('0xb3')]=_0x4053df['id'];if(_0x7f9520[_0x9569('0x2c')][_0x9569('0x48')]){_0x2bd23e[_0x9569('0x33')]=_['merge'](_0x2bd23e[_0x9569('0x33')],{'$or':_[_0x9569('0x46')](_0x2bd23e[_0x9569('0x2f')],function(_0x3ed189){var _0x3b0d95={};_0x3b0d95[_0x3ed189]={'$like':'%'+_0x7f9520[_0x9569('0x2c')]['filter']+'%'};return _0x3b0d95;})});}_0x2bd23e=_['merge']({},_0x2bd23e,_0x7f9520[_0x9569('0xae')]);return db['CmHopper']['count']({'where':_0x2bd23e[_0x9569('0x33')]})[_0x9569('0x25')](function(_0x2f093a){_0x1bd827['count']=_0x2f093a;if(_0x7f9520['query']['includeAll']){_0x2bd23e['include']=[{'all':!![]}];}return db[_0x9569('0x82')][_0x9569('0x73')](_0x2bd23e);})['then'](function(_0x5b8786){_0x1bd827[_0x9569('0x6c')]=_0x5b8786;return _0x1bd827;});}})[_0x9569('0x25')](respondWithFilteredResult(_0x2b1cc4,_0x2bd23e))[_0x9569('0x6f')](handleError(_0x2b1cc4,null));};exports[_0x9569('0xb4')]=function(_0xe600bd,_0x396f3c,_0x3cc6b3){var _0x7e9569={'raw':!![],'where':{}};var _0x35a5bc={};var _0x16a2de={'count':0x0,'rows':[]};return db[_0x9569('0x28')][_0x9569('0xac')]({'where':{'id':_0xe600bd['params']['id']}})[_0x9569('0x25')](handleEntityNotFound(_0x396f3c,null))[_0x9569('0x25')](function(_0x32738e){if(_0x32738e){_0x35a5bc[_0x9569('0x2a')]=_[_0x9569('0x2b')](db[_0x9569('0x92')][_0x9569('0xad')]);_0x35a5bc['query']=_[_0x9569('0x2b')](_0xe600bd[_0x9569('0x2c')]);_0x35a5bc[_0x9569('0x34')]=_[_0x9569('0x2d')](_0x35a5bc['model'],_0x35a5bc[_0x9569('0x2c')]);_0x7e9569[_0x9569('0x2f')]=_['intersection'](_0x35a5bc[_0x9569('0x2a')],qs['fields'](_0xe600bd[_0x9569('0x2c')][_0x9569('0x2e')]));_0x7e9569[_0x9569('0x2f')]=_0x7e9569[_0x9569('0x2f')][_0x9569('0x64')]?_0x7e9569[_0x9569('0x2f')]:_0x35a5bc[_0x9569('0x2a')];if(!_0xe600bd['query'][_0x9569('0x47')](_0x9569('0x30'))){_0x7e9569[_0x9569('0x21')]=qs[_0x9569('0x21')](_0xe600bd[_0x9569('0x2c')][_0x9569('0x21')]);_0x7e9569['offset']=qs[_0x9569('0x20')](_0xe600bd[_0x9569('0x2c')][_0x9569('0x20')]);}_0x7e9569[_0x9569('0x31')]=qs[_0x9569('0x32')](_0xe600bd[_0x9569('0x2c')]['sort']);_0x7e9569[_0x9569('0x33')]=qs[_0x9569('0x34')](_['pick'](_0xe600bd[_0x9569('0x2c')],_0x35a5bc['filters']));_0x7e9569[_0x9569('0x33')][_0x9569('0xb3')]=_0x32738e['id'];if(_0xe600bd[_0x9569('0x2c')][_0x9569('0x48')]){_0x7e9569[_0x9569('0x33')]=_[_0x9569('0x65')](_0x7e9569[_0x9569('0x33')],{'$or':_[_0x9569('0x46')](_0x7e9569[_0x9569('0x2f')],function(_0x4503c7){var _0x70c6d8={};_0x70c6d8[_0x4503c7]={'$like':'%'+_0xe600bd[_0x9569('0x2c')][_0x9569('0x48')]+'%'};return _0x70c6d8;})});}_0x7e9569=_[_0x9569('0x65')]({},_0x7e9569,_0xe600bd['options']);return db[_0x9569('0x92')]['count']({'where':_0x7e9569[_0x9569('0x33')]})[_0x9569('0x25')](function(_0x13ebc0){_0x16a2de[_0x9569('0x1f')]=_0x13ebc0;if(_0xe600bd['query'][_0x9569('0xb5')]){_0x7e9569[_0x9569('0xb6')]=[{'all':!![]}];}return db[_0x9569('0x92')][_0x9569('0x73')](_0x7e9569);})[_0x9569('0x25')](function(_0x2cee05){_0x16a2de[_0x9569('0x6c')]=_0x2cee05;return _0x16a2de;});}})[_0x9569('0x25')](respondWithFilteredResult(_0x396f3c,_0x7e9569))[_0x9569('0x6f')](handleError(_0x396f3c,null));};exports[_0x9569('0xb7')]=function(_0x57f4dc,_0x296219,_0x3d5167){var _0x51c520={'raw':!![],'where':{}};var _0xf84cf0={};var _0x22d461={'count':0x0,'rows':[]};return db[_0x9569('0x28')][_0x9569('0xac')]({'where':{'id':_0x57f4dc[_0x9569('0xa8')]['id']}})[_0x9569('0x25')](handleEntityNotFound(_0x296219,null))[_0x9569('0x25')](function(_0x2925f7){if(_0x2925f7){_0xf84cf0[_0x9569('0x2a')]=_[_0x9569('0x2b')](db[_0x9569('0x91')]['rawAttributes']);_0xf84cf0[_0x9569('0x2c')]=_[_0x9569('0x2b')](_0x57f4dc[_0x9569('0x2c')]);_0xf84cf0[_0x9569('0x34')]=_[_0x9569('0x2d')](_0xf84cf0[_0x9569('0x2a')],_0xf84cf0[_0x9569('0x2c')]);_0x51c520[_0x9569('0x2f')]=_[_0x9569('0x2d')](_0xf84cf0[_0x9569('0x2a')],qs[_0x9569('0x2e')](_0x57f4dc['query'][_0x9569('0x2e')]));_0x51c520[_0x9569('0x2f')]=_0x51c520[_0x9569('0x2f')][_0x9569('0x64')]?_0x51c520[_0x9569('0x2f')]:_0xf84cf0[_0x9569('0x2a')];if(!_0x57f4dc[_0x9569('0x2c')][_0x9569('0x47')](_0x9569('0x30'))){_0x51c520[_0x9569('0x21')]=qs[_0x9569('0x21')](_0x57f4dc[_0x9569('0x2c')][_0x9569('0x21')]);_0x51c520['offset']=qs[_0x9569('0x20')](_0x57f4dc[_0x9569('0x2c')][_0x9569('0x20')]);}_0x51c520[_0x9569('0x31')]=qs[_0x9569('0x32')](_0x57f4dc[_0x9569('0x2c')][_0x9569('0x32')]);_0x51c520[_0x9569('0x33')]=qs[_0x9569('0x34')](_['pick'](_0x57f4dc['query'],_0xf84cf0[_0x9569('0x34')]));_0x51c520[_0x9569('0x33')][_0x9569('0xb3')]=_0x2925f7['id'];if(_0x57f4dc[_0x9569('0x2c')][_0x9569('0x48')]){_0x51c520[_0x9569('0x33')]=_[_0x9569('0x65')](_0x51c520[_0x9569('0x33')],{'$or':_[_0x9569('0x46')](_0x51c520[_0x9569('0x2f')],function(_0x4b2f48){var _0x2c602d={};_0x2c602d[_0x4b2f48]={'$like':'%'+_0x57f4dc[_0x9569('0x2c')]['filter']+'%'};return _0x2c602d;})});}_0x51c520=_[_0x9569('0x65')]({},_0x51c520,_0x57f4dc['options']);return db['CmHopperFinal']['count']({'where':_0x51c520[_0x9569('0x33')]})[_0x9569('0x25')](function(_0x5908b){_0x22d461[_0x9569('0x1f')]=_0x5908b;if(_0x57f4dc[_0x9569('0x2c')][_0x9569('0xb5')]){_0x51c520['include']=[{'all':!![]}];}return db['CmHopperFinal'][_0x9569('0x73')](_0x51c520);})[_0x9569('0x25')](function(_0x4c8d18){_0x22d461['rows']=_0x4c8d18;return _0x22d461;});}})['then'](respondWithFilteredResult(_0x296219,_0x51c520))[_0x9569('0x6f')](handleError(_0x296219,null));};exports[_0x9569('0xb8')]=function(_0x14db0f,_0x424147,_0x6c7a15){var _0x48933a={'raw':!![],'where':{}};var _0x13e3f2={};var _0x583e2b={'count':0x0,'rows':[]};return db[_0x9569('0x28')][_0x9569('0xac')]({'where':{'id':_0x14db0f[_0x9569('0xa8')]['id']}})[_0x9569('0x25')](handleEntityNotFound(_0x424147,null))[_0x9569('0x25')](function(_0xb710da){if(_0xb710da){_0x13e3f2[_0x9569('0x2a')]=_[_0x9569('0x2b')](db[_0x9569('0x95')][_0x9569('0xad')]);_0x13e3f2[_0x9569('0x2c')]=_['keys'](_0x14db0f[_0x9569('0x2c')]);_0x13e3f2[_0x9569('0x34')]=_[_0x9569('0x2d')](_0x13e3f2[_0x9569('0x2a')],_0x13e3f2['query']);_0x48933a[_0x9569('0x2f')]=_[_0x9569('0x2d')](_0x13e3f2[_0x9569('0x2a')],qs[_0x9569('0x2e')](_0x14db0f[_0x9569('0x2c')][_0x9569('0x2e')]));_0x48933a[_0x9569('0x2f')]=_0x48933a[_0x9569('0x2f')][_0x9569('0x64')]?_0x48933a['attributes']:_0x13e3f2[_0x9569('0x2a')];if(!_0x14db0f['query']['hasOwnProperty'](_0x9569('0x30'))){_0x48933a[_0x9569('0x21')]=qs[_0x9569('0x21')](_0x14db0f[_0x9569('0x2c')][_0x9569('0x21')]);_0x48933a[_0x9569('0x20')]=qs[_0x9569('0x20')](_0x14db0f[_0x9569('0x2c')][_0x9569('0x20')]);}_0x48933a[_0x9569('0x31')]=qs[_0x9569('0x32')](_0x14db0f[_0x9569('0x2c')][_0x9569('0x32')]);_0x48933a[_0x9569('0x33')]=qs[_0x9569('0x34')](_[_0x9569('0x35')](_0x14db0f['query'],_0x13e3f2[_0x9569('0x34')]));_0x48933a[_0x9569('0x33')]['ContactId']=_0xb710da['id'];if(_0x14db0f[_0x9569('0x2c')][_0x9569('0x48')]){_0x48933a[_0x9569('0x33')]=_['merge'](_0x48933a[_0x9569('0x33')],{'$or':_[_0x9569('0x46')](_0x48933a['attributes'],function(_0x36f1df){var _0x1b64c2={};_0x1b64c2[_0x36f1df]={'$like':'%'+_0x14db0f[_0x9569('0x2c')][_0x9569('0x48')]+'%'};return _0x1b64c2;})});}_0x48933a=_[_0x9569('0x65')]({},_0x48933a,_0x14db0f['options']);return db[_0x9569('0x95')][_0x9569('0x1f')]({'where':_0x48933a['where']})['then'](function(_0x145f54){_0x583e2b['count']=_0x145f54;if(_0x14db0f[_0x9569('0x2c')][_0x9569('0xb5')]){_0x48933a['include']=[{'all':!![]}];}return db[_0x9569('0x95')][_0x9569('0x73')](_0x48933a);})[_0x9569('0x25')](function(_0x9b8197){_0x583e2b[_0x9569('0x6c')]=_0x9b8197;return _0x583e2b;});}})['then'](respondWithFilteredResult(_0x424147,_0x48933a))[_0x9569('0x6f')](handleError(_0x424147,null));};exports[_0x9569('0xb9')]=function(_0xc1f5bf,_0x4b989f,_0x52c45a){try{if(!_0xc1f5bf[_0x9569('0x7b')][_0x9569('0x4a')]){throw new Error(_0x9569('0xba'));}if(!_0xc1f5bf[_0x9569('0x7b')][_0x9569('0xbb')]){throw new Error(_0x9569('0xbc'));}if(!_0xc1f5bf['body']['binding_values']){throw new Error(_0x9569('0xbd'));}if(!_0xc1f5bf[_0x9569('0x7b')][_0x9569('0xbe')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x545006=_0xc1f5bf['body']['binding_keys'][_0x9569('0x6a')](',');var _0x36f38e=_0xc1f5bf['body'][_0x9569('0xbf')]['split'](',');if(!_0x545006['length']||!_0x36f38e['length']||_0x545006[_0x9569('0x64')]!==_0x36f38e[_0x9569('0x64')]){throw new Error(_0x9569('0xc0'));}_0xc1f5bf[_0x9569('0x7b')][_0x9569('0x2e')]=_[_0x9569('0xc1')](_0x545006,_0x36f38e);if(!_0xc1f5bf[_0x9569('0x7b')][_0x9569('0x2e')][_0x9569('0xab')]){throw new Error(_0x9569('0xc2'));}if(!_0xc1f5bf[_0x9569('0x7b')][_0x9569('0x2e')][_0x9569('0xc3')]){throw new Error('No\x20firstName\x20column\x20specified');}var _0x2eff0c=path['join'](config[_0x9569('0xc4')],_0x9569('0xc5'),_0xc1f5bf[_0x9569('0xc6')]['filename']);fs[_0x9569('0xc7')](_0x2eff0c,parseInt(_0x9569('0xc8'),0x8));var _0x20ee3a=require('child_process')[_0x9569('0xc9')](path[_0x9569('0x96')](__dirname,_0x9569('0xca')),[_0x2eff0c,_0xc1f5bf[_0x9569('0x7b')][_0x9569('0xbb')],_0xc1f5bf[_0x9569('0x7b')][_0x9569('0xbf')],_0xc1f5bf[_0x9569('0x7b')][_0x9569('0x4a')],_0xc1f5bf[_0x9569('0x7b')][_0x9569('0xcb')],_0xc1f5bf['body'][_0x9569('0x99')],_0xc1f5bf['body'][_0x9569('0xbe')]]);return _0x4b989f[_0x9569('0x1e')](0xc8)['json']({'message':'File\x20uploaded\x20correctly!','pid':_0x20ee3a[_0x9569('0xcc')]});}catch(_0x44808f){return _0x4b989f['status'](0x1f4)[_0x9569('0x27')](_0x44808f);}};exports[_0x9569('0xcd')]=function(_0x18f166,_0x20ec57,_0x22969b){var _0x62ec23=fs[_0x9569('0xce')](_0x18f166['file'][_0x9569('0x7')]);Papa['parse'](_0x62ec23,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x18814d){return _0x20ec57[_0x9569('0x1e')](0xc8)[_0x9569('0x22')]({'file':_0x18f166[_0x9569('0xc6')],'fields':_0x18814d[_0x9569('0xcf')]['fields']});}});};exports[_0x9569('0xd0')]=function(_0x3c8099,_0x34e215,_0x1cc09d){return db[_0x9569('0xd1')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0x9569('0xd2')}})[_0x9569('0x25')](function(_0x26dd32){var _0x226306=![];if(!_0x3c8099[_0x9569('0x7b')][_0x9569('0x4a')]){throw new Error(_0x9569('0xba'));}if(!_0x3c8099['body'][_0x9569('0xd3')][_0x9569('0xab')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x3c8099[_0x9569('0x7b')][_0x9569('0xd3')][_0x9569('0xc3')]){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x3c8099[_0x9569('0x7b')]['socket_timestamp']){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x461ac3=require(_0x9569('0xd4'))['fork'](path[_0x9569('0x96')](__dirname,_0x9569('0xd5')),[_0x3c8099[_0x9569('0xa8')]['id'],JSON[_0x9569('0xd6')](_0x3c8099['body']),JSON['stringify'](_0x26dd32)]);_0x461ac3['on'](_0x9569('0xd7'),function(_0x99f2af){_0x226306=!![];return _0x34e215['status'](0xc8)['json']({'message':'start\x20child\x20process\x20correctly!','pid':_0x461ac3[_0x9569('0xcc')]});});_0x461ac3['on'](_0x9569('0xd8'),function(_0x83c7d9){if(_0x83c7d9&&!_0x226306){return _0x34e215[_0x9569('0x1e')](0x1f4)[_0x9569('0x22')]({'message':_0x9569('0xd9'),'pid':_0x461ac3[_0x9569('0xcc')]});}});})['catch'](handleError(_0x34e215,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff