// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x30da=['merge','map','include','tag','Tags','includeAll','Tag','color','findAll','find','catch','startsWith','CmCustomField','cf_','columnName','alias','body','get','isArray','tags','join','[CmContact][merge]\x20to\x20%s\x20from\x20%s','from','info','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','bulkCreate','each','duplicates','push','ListId','spread','show','params','omit','cf_%d','$and','format','isEmpty','table','cm_contacts','setFields','id\x20=\x20?','toParam','sequelize','text','values','phone','getTags','findOne','rawAttributes','options','setTags','ids','getHoppers','CmHopper','rows','getHopperHistories','CmHopperHistory','ContactId','getHopperFinals','CmHopperFinal','getJscriptySessions','JscriptySessionReport','uploadCsv','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_keys','Incorrect\x20binding\x20parameters\x20passed!','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','server/files/tmp','file','filename','chmodSync','0777','child_process','fork','CompanyId','File\x20uploaded\x20correctly!','pid','upload','meta','No\x20ListId\x20specified','binding','../../components/import/cm/csv2','stringify','message','exit','error\x20child\x20process','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','register','status','count','offset','Content-Range','json','apply','reject','save','update','destroy','then','end','sendStatus','error','name','send','index','CmContact','describe','model','query','dateStart','dateEnd','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','limit','order','sort','where','pick','add','day','filter'];(function(_0x3947c9,_0x4d6c97){var _0x2e7871=function(_0x1236cc){while(--_0x1236cc){_0x3947c9['push'](_0x3947c9['shift']());}};_0x2e7871(++_0x4d6c97);}(_0x30da,0x6f));var _0xa30d=function(_0x4f86b5,_0x32bbeb){_0x4f86b5=_0x4f86b5-0x0;var _0x32d9e7=_0x30da[_0x4f86b5];return _0x32d9e7;};'use strict';var pdf=require(_0xa30d('0x0'));var emlformat=require(_0xa30d('0x1'));var rimraf=require(_0xa30d('0x2'));var zipdir=require(_0xa30d('0x3'));var jsonpatch=require(_0xa30d('0x4'));var rp=require(_0xa30d('0x5'));var moment=require(_0xa30d('0x6'));var BPromise=require(_0xa30d('0x7'));var Mustache=require(_0xa30d('0x8'));var util=require('util');var path=require(_0xa30d('0x9'));var sox=require(_0xa30d('0xa'));var csv=require(_0xa30d('0xb'));var ejs=require(_0xa30d('0xc'));var fs=require('fs');var _=require(_0xa30d('0xd'));var squel=require(_0xa30d('0xe'));var crypto=require(_0xa30d('0xf'));var jsforce=require(_0xa30d('0x10'));var deskjs=require(_0xa30d('0x11'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0xa30d('0x12'));var Redis=require(_0xa30d('0x13'));var qs=require(_0xa30d('0x14'));var logger=require(_0xa30d('0x15'))(_0xa30d('0x16'));var utils=require(_0xa30d('0x17'));var config=require(_0xa30d('0x18'));var db=require(_0xa30d('0x19'))['db'];config[_0xa30d('0x1a')]=_[_0xa30d('0x1b')](config[_0xa30d('0x1a')],{'host':_0xa30d('0x1c'),'port':0x18eb});var socket=require(_0xa30d('0x1d'))(new Redis(config[_0xa30d('0x1a')]));require('./cmContact.socket')[_0xa30d('0x1e')](socket);function respondWithStatusCode(_0x45885d,_0x4d49d8){_0x4d49d8=_0x4d49d8||0xcc;return function(_0x220e7a){if(_0x220e7a){return _0x45885d['sendStatus'](_0x4d49d8);}return _0x45885d[_0xa30d('0x1f')](_0x4d49d8)['end']();};}function respondWithResult(_0x14cbc3,_0x45305e){_0x45305e=_0x45305e||0xc8;return function(_0x1eeccb){if(_0x1eeccb){return _0x14cbc3[_0xa30d('0x1f')](_0x45305e)['json'](_0x1eeccb);}};}function respondWithFilteredResult(_0x4003b7,_0x373cd3){return function(_0x540bca){if(_0x540bca){var _0x4f371d=_0x540bca[_0xa30d('0x20')],_0x56b361=_0x373cd3[_0xa30d('0x21')],_0x229f05=_0x373cd3['offset']+_0x373cd3['limit'],_0x300538;if(_0x229f05>=_0x4f371d){_0x229f05=_0x4f371d;_0x300538=0xc8;}else{_0x300538=0xce;}_0x4003b7[_0xa30d('0x1f')](_0x300538);return _0x4003b7['set'](_0xa30d('0x22'),_0x56b361+'-'+_0x229f05+'/'+_0x4f371d)[_0xa30d('0x23')](_0x540bca);}return null;};}function patchUpdates(_0x2518a4){return function(_0x3c4eb2){try{jsonpatch[_0xa30d('0x24')](_0x3c4eb2,_0x2518a4,!![]);}catch(_0x4ba4fc){return BPromise[_0xa30d('0x25')](_0x4ba4fc);}return _0x3c4eb2[_0xa30d('0x26')]();};}function saveUpdates(_0x490231,_0x35e74b){return function(_0x2d4dc2){if(_0x2d4dc2){return _0x2d4dc2[_0xa30d('0x27')](_0x490231)['then'](function(_0x4c2754){return _0x4c2754;});}return null;};}function removeEntity(_0x788691,_0x2f99d7){return function(_0x54ffa1){if(_0x54ffa1){return _0x54ffa1[_0xa30d('0x28')]()[_0xa30d('0x29')](function(){_0x788691[_0xa30d('0x1f')](0xcc)[_0xa30d('0x2a')]();});}};}function handleEntityNotFound(_0x17d4a9,_0x937573){return function(_0xc3ded3){if(!_0xc3ded3){_0x17d4a9[_0xa30d('0x2b')](0x194);}return _0xc3ded3;};}function handleError(_0x4912b6,_0x356c05){_0x356c05=_0x356c05||0x1f4;return function(_0x76de9a){logger[_0xa30d('0x2c')](_0x76de9a['stack']);if(_0x76de9a[_0xa30d('0x2d')]){delete _0x76de9a[_0xa30d('0x2d')];}_0x4912b6[_0xa30d('0x1f')](_0x356c05)[_0xa30d('0x2e')](_0x76de9a);};}exports[_0xa30d('0x2f')]=function(_0x1c43b5,_0x36358e){var _0x35f1c2={},_0x33c352={},_0x2f5e29={'count':0x0,'rows':[]};return db[_0xa30d('0x30')][_0xa30d('0x31')]()[_0xa30d('0x29')](function(_0x39b01e){_0x33c352[_0xa30d('0x32')]=_['keys'](_0x39b01e);var _0x49f72b={'dateStart':_0x1c43b5[_0xa30d('0x33')][_0xa30d('0x34')],'dateEnd':_0x1c43b5[_0xa30d('0x33')]['dateEnd']};delete _0x1c43b5[_0xa30d('0x33')][_0xa30d('0x34')];delete _0x1c43b5[_0xa30d('0x33')][_0xa30d('0x35')];_0x33c352[_0xa30d('0x33')]=_[_0xa30d('0x36')](_0x1c43b5[_0xa30d('0x33')]);_0x33c352[_0xa30d('0x37')]=_[_0xa30d('0x38')](_0x33c352[_0xa30d('0x32')],_0x33c352[_0xa30d('0x33')]);_0x35f1c2[_0xa30d('0x39')]=_[_0xa30d('0x38')](_0x33c352['model'],qs['fields'](_0x1c43b5[_0xa30d('0x33')][_0xa30d('0x3a')]));_0x35f1c2[_0xa30d('0x39')]=_0x35f1c2[_0xa30d('0x39')][_0xa30d('0x3b')]?_0x35f1c2[_0xa30d('0x39')]:_0x33c352['model'];if(!_0x1c43b5['query'][_0xa30d('0x3c')](_0xa30d('0x3d'))){_0x35f1c2['limit']=qs[_0xa30d('0x3e')](_0x1c43b5[_0xa30d('0x33')][_0xa30d('0x3e')]);_0x35f1c2['offset']=qs[_0xa30d('0x21')](_0x1c43b5[_0xa30d('0x33')]['offset']);}_0x35f1c2[_0xa30d('0x3f')]=qs[_0xa30d('0x40')](_0x1c43b5[_0xa30d('0x33')][_0xa30d('0x40')]);_0x35f1c2[_0xa30d('0x41')]=qs[_0xa30d('0x37')](_[_0xa30d('0x42')](_0x1c43b5[_0xa30d('0x33')],_0x33c352[_0xa30d('0x37')]));if(_0x49f72b[_0xa30d('0x34')]){if(_0x49f72b[_0xa30d('0x35')]){_0x49f72b['dateEnd']=moment(_0x49f72b[_0xa30d('0x35')])[_0xa30d('0x43')](0x1,_0xa30d('0x44'));}else{_0x49f72b[_0xa30d('0x35')]=moment(_0x49f72b[_0xa30d('0x34')])[_0xa30d('0x43')](0x1,_0xa30d('0x44'));}_['merge'](_0x35f1c2[_0xa30d('0x41')],{'createdAt':{'$gte':_0x49f72b[_0xa30d('0x34')],'$lte':_0x49f72b[_0xa30d('0x35')]}});}if(_0x1c43b5[_0xa30d('0x33')][_0xa30d('0x45')]){_0x35f1c2[_0xa30d('0x41')]=_[_0xa30d('0x46')](_0x35f1c2[_0xa30d('0x41')],{'$or':_[_0xa30d('0x47')](_0x35f1c2[_0xa30d('0x39')],function(_0xe0f787){var _0x4393fa={};_0x4393fa[_0xe0f787]={'$like':'%'+_0x1c43b5['query'][_0xa30d('0x45')]+'%'};return _0x4393fa;})});}_0x35f1c2=_['merge']({},_0x35f1c2,_0x1c43b5['options']);var _0x255c2a={'where':_0x35f1c2['where']};_0x255c2a[_0xa30d('0x48')]=[];if(_0x1c43b5['query'][_0xa30d('0x49')]){_0x255c2a['include']['push']({'model':db['Tag'],'as':_0xa30d('0x4a'),'attributes':['id'],'where':{'id':_0x1c43b5[_0xa30d('0x33')]['tag']},'required':!![]});_0x255c2a['distinct']=!![];}return db['CmContact'][_0xa30d('0x20')](_0x255c2a)['then'](function(_0xefb190){_0x2f5e29[_0xa30d('0x20')]=_0xefb190;if(_0x1c43b5[_0xa30d('0x33')][_0xa30d('0x4b')]){_0x35f1c2['include']=[{'model':db[_0xa30d('0x4c')],'as':_0xa30d('0x4a'),'attributes':['id',_0xa30d('0x2d'),'color'],'required':_0x1c43b5[_0xa30d('0x33')][_0xa30d('0x49')]?!![]:![]},{'model':db[_0xa30d('0x4c')],'as':'ThroughTags','attributes':['id','name',_0xa30d('0x4d')],'through':_0x1c43b5[_0xa30d('0x33')][_0xa30d('0x49')]?{'attributes':[],'where':{'TagId':_0x1c43b5[_0xa30d('0x33')]['tag']||undefined}}:{},'required':_0x1c43b5[_0xa30d('0x33')][_0xa30d('0x49')]?!![]:![]}];}return db['CmContact'][_0xa30d('0x4e')](_0x35f1c2);})[_0xa30d('0x29')](function(_0x54b2e9){_0x2f5e29['rows']=_0x54b2e9;return _0x2f5e29;})[_0xa30d('0x29')](respondWithFilteredResult(_0x36358e,_0x35f1c2))['catch'](handleError(_0x36358e,null));});};exports['destroy']=function(_0x479fe1,_0x5997a4){return db[_0xa30d('0x30')][_0xa30d('0x4f')]({'where':{'id':_0x479fe1['params']['id']}})[_0xa30d('0x29')](handleEntityNotFound(_0x5997a4,null))[_0xa30d('0x29')](removeEntity(_0x5997a4,null))[_0xa30d('0x50')](handleError(_0x5997a4,null));};exports[_0xa30d('0x31')]=function(_0x508d19,_0x2bea33){return db[_0xa30d('0x30')][_0xa30d('0x31')]()[_0xa30d('0x29')](function(_0x125878){for(var _0x79b2bc=0x0;_0x79b2bc<Object['keys'](_0x125878)[_0xa30d('0x3b')];_0x79b2bc++){var _0x4d5630=Object['keys'](_0x125878)[_0x79b2bc];if(!_[_0xa30d('0x51')](_0x4d5630,'cf_')){_0x125878[_0x4d5630]['columnName']=_0x4d5630;_0x125878[_0x4d5630]['displayName']=_0x4d5630;}}return _0x125878;})[_0xa30d('0x29')](function(_0x17bc42){var _0x3ad52d={'where':{'$or':[{'ListId':_0x508d19[_0xa30d('0x33')]['id']},{'ListId':null}]},'raw':!![]};return db[_0xa30d('0x52')][_0xa30d('0x4e')](_0x3ad52d)[_0xa30d('0x29')](function(_0x363635){for(var _0x465e8c=0x0;_0x465e8c<_0x363635[_0xa30d('0x3b')];_0x465e8c++){var _0x3c1588=_0xa30d('0x53')+_0x363635[_0x465e8c]['id'];_0x17bc42[_0x3c1588][_0xa30d('0x54')]=_0x3c1588;_0x17bc42[_0x3c1588]['displayName']=_0x363635[_0x465e8c][_0xa30d('0x55')];}for(var _0x465e8c=0x0;_0x465e8c<Object['keys'](_0x17bc42)[_0xa30d('0x3b')];_0x465e8c++){var _0x3c1588=Object[_0xa30d('0x36')](_0x17bc42)[_0x465e8c];if(!_0x17bc42[_0x3c1588][_0xa30d('0x3c')]('columnName')){delete _0x17bc42[_0x3c1588];}}return _0x17bc42;});})[_0xa30d('0x29')](respondWithResult(_0x2bea33,null))[_0xa30d('0x50')](handleError(_0x2bea33,null));};exports['merge']=function(_0x5b8ba9,_0x18455c){var _0x1155d1;var _0x90570d;var _0x3928cc;if(_0x5b8ba9[_0xa30d('0x56')]['id']){delete _0x5b8ba9['body']['id'];}return db['CmContact'][_0xa30d('0x4e')]({'where':{'id':[_0x5b8ba9[_0xa30d('0x56')]['to'],_0x5b8ba9[_0xa30d('0x56')]['from']]}})[_0xa30d('0x29')](function(_0xcbdb57){if(_0xcbdb57){if(_0xcbdb57['length']!==0x2){return null;}_0xcbdb57[0x0]=_0xcbdb57[0x0][_0xa30d('0x57')]({'plain':!![]});_0xcbdb57[0x1]=_0xcbdb57[0x1][_0xa30d('0x57')]({'plain':!![]});delete _0xcbdb57[0x0]['id'];delete _0xcbdb57[0x1]['id'];return _['mergeWith'](_0xcbdb57[0x0],_0xcbdb57[0x1],function(_0x40b22b,_0x79ef39){if(Array[_0xa30d('0x58')](_0x79ef39)&&!_0x79ef39[_0xa30d('0x3b')]){return _0x40b22b;}else if(!_0x79ef39){return _0x40b22b;}});}})['then'](handleEntityNotFound(_0x18455c,null))[_0xa30d('0x29')](function(_0x38a6e3){if(_0x38a6e3){if(_0x38a6e3['tags']&&_[_0xa30d('0x58')](_0x38a6e3['tags'])){_0x38a6e3['tags']=_0x38a6e3[_0xa30d('0x59')][_0xa30d('0x5a')]();}logger['info'](_0xa30d('0x5b'),_0x5b8ba9['body']['to'],_0x5b8ba9['body']['from']);return db['CmHopper']['destroy']({'where':{'ContactId':[_0x5b8ba9[_0xa30d('0x56')]['to'],_0x5b8ba9[_0xa30d('0x56')][_0xa30d('0x5c')]]}})[_0xa30d('0x29')](function(_0x36da03){logger[_0xa30d('0x5d')](_0xa30d('0x5e'),_0x36da03);return db[_0xa30d('0x5f')][_0xa30d('0x28')]({'where':{'ContactId':[_0x5b8ba9[_0xa30d('0x56')]['to'],_0x5b8ba9[_0xa30d('0x56')][_0xa30d('0x5c')]]}})[_0xa30d('0x29')](function(_0x106a07){logger[_0xa30d('0x5d')](_0xa30d('0x60'),_0x106a07);return db[_0xa30d('0x30')][_0xa30d('0x61')](_0x38a6e3);});});}})['then'](function(_0x312ed0){if(_0x312ed0){_0x1155d1=_0x312ed0;_0x90570d={'ContactId':_0x1155d1['id']};_0x3928cc={'where':{'ContactId':[_0x5b8ba9['body']['to'],_0x5b8ba9[_0xa30d('0x56')][_0xa30d('0x5c')]]}};return db[_0xa30d('0x62')][_0xa30d('0x27')](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db[_0xa30d('0x63')]['update'](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db[_0xa30d('0x64')][_0xa30d('0x27')](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db['MailInteraction'][_0xa30d('0x27')](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db[_0xa30d('0x65')][_0xa30d('0x27')](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db['MailInteraction'][_0xa30d('0x27')](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db[_0xa30d('0x65')][_0xa30d('0x27')](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db[_0xa30d('0x66')]['update'](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db[_0xa30d('0x67')][_0xa30d('0x27')](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db[_0xa30d('0x68')]['update'](_0x90570d,_0x3928cc);}})['then'](function(){if(_0x1155d1){return db[_0xa30d('0x69')][_0xa30d('0x27')](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db[_0xa30d('0x6a')][_0xa30d('0x27')](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db[_0xa30d('0x6b')][_0xa30d('0x27')](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db['CmHopperFinal'][_0xa30d('0x27')](_0x90570d,_0x3928cc);}})['then'](function(){if(_0x1155d1){return db['CmHopperHistory'][_0xa30d('0x27')](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db['ReportAgentPreview']['update'](_0x90570d,_0x3928cc);}})['then'](function(){if(_0x1155d1){return db[_0xa30d('0x6c')][_0xa30d('0x27')](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db[_0xa30d('0x6d')]['update'](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db[_0xa30d('0x6e')]['update'](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db[_0xa30d('0x6f')][_0xa30d('0x27')](_0x90570d,_0x3928cc);}})['then'](function(){if(_0x1155d1){return db[_0xa30d('0x70')][_0xa30d('0x27')](_0x90570d,_0x3928cc);}})['then'](function(){if(_0x1155d1){return db[_0xa30d('0x71')][_0xa30d('0x27')](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db['JscriptySessionReport'][_0xa30d('0x27')](_0x90570d,_0x3928cc);}})[_0xa30d('0x29')](function(){if(_0x1155d1){return db[_0xa30d('0x30')][_0xa30d('0x28')]({'where':{'id':[_0x5b8ba9[_0xa30d('0x56')]['to'],_0x5b8ba9[_0xa30d('0x56')][_0xa30d('0x5c')]]}});}})[_0xa30d('0x29')](function(){if(_0x1155d1){return _0x1155d1;}})['then'](respondWithResult(_0x18455c,null))[_0xa30d('0x50')](handleError(_0x18455c,null));};exports[_0xa30d('0x61')]=function(_0x16485e,_0x4eeefe){return db[_0xa30d('0x30')]['describe']()[_0xa30d('0x29')](function(_0x4f215d){if(_0x16485e[_0xa30d('0x56')][_0xa30d('0x59')]&&_[_0xa30d('0x58')](_0x16485e[_0xa30d('0x56')][_0xa30d('0x59')])){if(_0x16485e['body']['tags'][_0xa30d('0x3b')]){_0x16485e[_0xa30d('0x56')][_0xa30d('0x59')]=_0x16485e[_0xa30d('0x56')][_0xa30d('0x59')]['join'](';')+';';}else{_0x16485e[_0xa30d('0x56')][_0xa30d('0x59')]=null;}}else{_0x16485e[_0xa30d('0x56')]['tags']=null;}return db[_0xa30d('0x30')]['create'](_0x16485e[_0xa30d('0x56')],{'fields':_[_0xa30d('0x36')](_0x4f215d),'raw':!![]});})[_0xa30d('0x29')](respondWithResult(_0x4eeefe,0xc9))[_0xa30d('0x50')](handleError(_0x4eeefe,null));};exports[_0xa30d('0x72')]=function(_0x30dbb4,_0x5573ee){var _0xf8b2ab=[];var _0x3b7f8f=0x0;var _0x42ce9f=0x0;var _0x2c6244=0x0;return db[_0xa30d('0x30')][_0xa30d('0x31')]()['then'](function(_0x25ebf6){return BPromise[_0xa30d('0x73')](_0x30dbb4[_0xa30d('0x56')],function(_0x12c6f3){var _0xf1d801={'where':{'$or':[]},'defaults':_0x12c6f3,'fields':_['keys'](_0x25ebf6),'raw':!![]};if(_0x12c6f3['duplicates']){for(var _0x2bb5e3=0x0;_0x2bb5e3<_0x12c6f3['duplicates'][_0xa30d('0x3b')];_0x2bb5e3++){var _0x554b2c={};_0x554b2c[_0x12c6f3[_0xa30d('0x74')][_0x2bb5e3]]=_0x12c6f3[_0x12c6f3[_0xa30d('0x74')][_0x2bb5e3]];_0xf1d801[_0xa30d('0x41')]['$or'][_0xa30d('0x75')](_0x554b2c);}_0xf1d801['where'][_0xa30d('0x76')]=_0x12c6f3[_0xa30d('0x76')];}return db['CmContact']['findOrCreate'](_0xf1d801)[_0xa30d('0x77')](function(_0x52e959,_0x226e1b){if(_0x226e1b){_0x3b7f8f++;}else{_0x2c6244++;}})['catch'](function(_0x36642a){console[_0xa30d('0x2c')](_0x36642a);_0x42ce9f++;});});})[_0xa30d('0x29')](function(_0x34f2a7){if(_0x34f2a7){return{'success':_0x3b7f8f,'failure':_0x42ce9f,'duplicates':_0x2c6244};}})['then'](respondWithResult(_0x5573ee,0xc9))['catch'](handleError(_0x5573ee,null));};exports[_0xa30d('0x78')]=function(_0x3fa479,_0x5da3b6,_0x2db16c){var _0x3a4b56;return db[_0xa30d('0x30')][_0xa30d('0x31')]()[_0xa30d('0x29')](function(_0x37171b){return db['CmContact'][_0xa30d('0x4f')]({'where':{'id':_0x3fa479[_0xa30d('0x79')]['id']},'include':[{'model':db[_0xa30d('0x4c')],'as':_0xa30d('0x4a'),'attributes':['id',_0xa30d('0x2d'),_0xa30d('0x4d')],'required':_0x3fa479['query'][_0xa30d('0x49')]?!![]:![]}],'attributes':_[_0xa30d('0x36')](_0x37171b)});})[_0xa30d('0x29')](function(_0x256154){_0x3a4b56=_0x256154[_0xa30d('0x57')]({'plain':!![]});var _0x136757={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x256154&&_0x256154[_0xa30d('0x76')]){if(_0x256154[_0xa30d('0x76')]){_0x136757['where']['$and'][_0xa30d('0x75')]({'ListId':{'$ne':_0x256154['ListId']}});}}return db[_0xa30d('0x52')][_0xa30d('0x4e')](_0x136757);})[_0xa30d('0x29')](function(_0x132cb5){return _[_0xa30d('0x7a')](_0x3a4b56,_['map'](_0x132cb5,function(_0x3eb3ff){return util['format'](_0xa30d('0x7b'),_0x3eb3ff['id']);}));})['then'](handleEntityNotFound(_0x5da3b6,null))['then'](respondWithResult(_0x5da3b6,null))[_0xa30d('0x50')](handleError(_0x5da3b6,null));};exports['update']=function(_0xff393d,_0x2245c0){var _0x59b22a;if(_0xff393d[_0xa30d('0x56')]['id']){delete _0xff393d[_0xa30d('0x56')]['id'];}return db[_0xa30d('0x30')][_0xa30d('0x4f')]({'where':{'id':_0xff393d[_0xa30d('0x79')]['id']}})['then'](handleEntityNotFound(_0x2245c0,null))['then'](saveUpdates(_0xff393d['body'],null))[_0xa30d('0x29')](function(_0x502d72){_0x59b22a=_0x502d72;var _0x40b1d2={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x502d72&&_0x502d72[_0xa30d('0x76')]){if(_0x502d72[_0xa30d('0x76')]){_0x40b1d2['where'][_0xa30d('0x7c')][_0xa30d('0x75')]({'ListId':{'$ne':_0x502d72[_0xa30d('0x76')]}});}}return db['CmCustomField'][_0xa30d('0x4e')](_0x40b1d2);})[_0xa30d('0x29')](function(_0x576baf){if(_0x576baf){return _[_0xa30d('0x7a')](_['pickBy'](_0xff393d['body'],function(_0x3c1579,_0x9e5bd8){return _[_0xa30d('0x51')](_0x9e5bd8,'cf_');}),_[_0xa30d('0x47')](_0x576baf,function(_0x34d995){return util[_0xa30d('0x7d')](_0xa30d('0x7b'),_0x34d995['id']);}));}})[_0xa30d('0x29')](function(_0x1dbbcf){if(_0x1dbbcf&&!_[_0xa30d('0x7e')](_0x1dbbcf)){var _0x271e9f=squel['update']()[_0xa30d('0x7f')](_0xa30d('0x80'))[_0xa30d('0x81')](_0x1dbbcf)[_0xa30d('0x41')](_0xa30d('0x82'),_0xff393d[_0xa30d('0x79')]['id'])[_0xa30d('0x83')]();return db[_0xa30d('0x84')][_0xa30d('0x33')](_0x271e9f[_0xa30d('0x85')],{'replacements':_0x271e9f[_0xa30d('0x86')]});}})[_0xa30d('0x29')](function(){if(_0xff393d[_0xa30d('0x56')][_0xa30d('0x87')]&&_0x59b22a){return db['CmHopper'][_0xa30d('0x27')]({'phone':_0xff393d[_0xa30d('0x56')][_0xa30d('0x87')]},{'where':{'ContactId':_0x59b22a['id']}});}})['then'](function(){return _0x59b22a;})[_0xa30d('0x29')](respondWithResult(_0x2245c0,null))[_0xa30d('0x50')](handleError(_0x2245c0,null));};exports[_0xa30d('0x88')]=function(_0x571f5a,_0x2dfe5a,_0x25fb4a){var _0x238593={};var _0x40c5da={};var _0x3c4e9b;var _0xb024d0;return db['CmContact'][_0xa30d('0x89')]({'where':{'id':_0x571f5a[_0xa30d('0x79')]['id']}})[_0xa30d('0x29')](handleEntityNotFound(_0x2dfe5a,null))[_0xa30d('0x29')](function(_0x2c21b5){if(_0x2c21b5){_0x3c4e9b=_0x2c21b5;_0x40c5da[_0xa30d('0x32')]=_[_0xa30d('0x36')](db[_0xa30d('0x4c')][_0xa30d('0x8a')]);_0x40c5da[_0xa30d('0x33')]=_[_0xa30d('0x36')](_0x571f5a[_0xa30d('0x33')]);_0x40c5da['filters']=_[_0xa30d('0x38')](_0x40c5da[_0xa30d('0x32')],_0x40c5da[_0xa30d('0x33')]);_0x238593[_0xa30d('0x39')]=_['intersection'](_0x40c5da[_0xa30d('0x32')],qs[_0xa30d('0x3a')](_0x571f5a[_0xa30d('0x33')][_0xa30d('0x3a')]));_0x238593[_0xa30d('0x39')]=_0x238593['attributes'][_0xa30d('0x3b')]?_0x238593[_0xa30d('0x39')]:_0x40c5da['model'];_0x238593[_0xa30d('0x3f')]=qs['sort'](_0x571f5a[_0xa30d('0x33')][_0xa30d('0x40')]);_0x238593[_0xa30d('0x41')]=qs['filters'](_['pick'](_0x571f5a[_0xa30d('0x33')],_0x40c5da[_0xa30d('0x37')]));if(_0x571f5a[_0xa30d('0x33')][_0xa30d('0x45')]){_0x238593[_0xa30d('0x41')]=_[_0xa30d('0x46')](_0x238593[_0xa30d('0x41')],{'$or':_[_0xa30d('0x47')](_0x238593['attributes'],function(_0x795012){var _0x1b55ee={};_0x1b55ee[_0x795012]={'$like':'%'+_0x571f5a[_0xa30d('0x33')][_0xa30d('0x45')]+'%'};return _0x1b55ee;})});}_0x238593=_[_0xa30d('0x46')]({},_0x238593,_0x571f5a[_0xa30d('0x8b')]);return _0x3c4e9b[_0xa30d('0x88')](_0x238593);}})['then'](function(_0x250949){if(_0x250949){_0xb024d0=_0x250949[_0xa30d('0x3b')];if(!_0x571f5a[_0xa30d('0x33')][_0xa30d('0x3c')](_0xa30d('0x3d'))){_0x238593[_0xa30d('0x3e')]=qs[_0xa30d('0x3e')](_0x571f5a['query']['limit']);_0x238593[_0xa30d('0x21')]=qs[_0xa30d('0x21')](_0x571f5a[_0xa30d('0x33')][_0xa30d('0x21')]);}return _0x3c4e9b[_0xa30d('0x88')](_0x238593);}})[_0xa30d('0x29')](function(_0x12e646){if(_0x12e646){return _0x12e646?{'count':_0xb024d0,'rows':_0x12e646}:null;}})[_0xa30d('0x29')](respondWithResult(_0x2dfe5a,null))['catch'](handleError(_0x2dfe5a,null));};exports[_0xa30d('0x8c')]=function(_0x148aac,_0xb529ab,_0x29e685){if(_0x148aac[_0xa30d('0x56')]['id']){delete _0x148aac[_0xa30d('0x56')]['id'];}return db[_0xa30d('0x30')][_0xa30d('0x89')]({'where':{'id':_0x148aac['params']['id']}})['then'](handleEntityNotFound(_0xb529ab,null))['then'](function(_0x40a929){if(_0x40a929){return _0x40a929[_0xa30d('0x8c')](_0x148aac['body'][_0xa30d('0x8d')]||[]);}return null;})[_0xa30d('0x29')](respondWithResult(_0xb529ab,null))[_0xa30d('0x50')](handleError(_0xb529ab,null));};exports[_0xa30d('0x8e')]=function(_0x58aee7,_0x5aa98c,_0x5a8bec){var _0xbb54c4={'raw':![],'where':{}};var _0x451144={};var _0x422db6={'count':0x0,'rows':[]};return db[_0xa30d('0x30')][_0xa30d('0x89')]({'where':{'id':_0x58aee7[_0xa30d('0x79')]['id']}})[_0xa30d('0x29')](handleEntityNotFound(_0x5aa98c,null))[_0xa30d('0x29')](function(_0x59a717){if(_0x59a717){_0x451144[_0xa30d('0x32')]=_[_0xa30d('0x36')](db[_0xa30d('0x8f')][_0xa30d('0x8a')]);_0x451144[_0xa30d('0x33')]=_[_0xa30d('0x36')](_0x58aee7[_0xa30d('0x33')]);_0x451144[_0xa30d('0x37')]=_[_0xa30d('0x38')](_0x451144[_0xa30d('0x32')],_0x451144[_0xa30d('0x33')]);_0xbb54c4[_0xa30d('0x39')]=_[_0xa30d('0x38')](_0x451144[_0xa30d('0x32')],qs[_0xa30d('0x3a')](_0x58aee7['query'][_0xa30d('0x3a')]));_0xbb54c4['attributes']=_0xbb54c4['attributes']['length']?_0xbb54c4['attributes']:_0x451144['model'];if(!_0x58aee7['query']['hasOwnProperty'](_0xa30d('0x3d'))){_0xbb54c4[_0xa30d('0x3e')]=qs[_0xa30d('0x3e')](_0x58aee7[_0xa30d('0x33')]['limit']);_0xbb54c4['offset']=qs[_0xa30d('0x21')](_0x58aee7[_0xa30d('0x33')][_0xa30d('0x21')]);}_0xbb54c4['order']=qs[_0xa30d('0x40')](_0x58aee7['query'][_0xa30d('0x40')]);_0xbb54c4[_0xa30d('0x41')]=qs[_0xa30d('0x37')](_[_0xa30d('0x42')](_0x58aee7[_0xa30d('0x33')],_0x451144[_0xa30d('0x37')]));_0xbb54c4[_0xa30d('0x41')]['ContactId']=_0x59a717['id'];if(_0x58aee7[_0xa30d('0x33')]['filter']){_0xbb54c4['where']=_[_0xa30d('0x46')](_0xbb54c4[_0xa30d('0x41')],{'$or':_[_0xa30d('0x47')](_0xbb54c4['attributes'],function(_0x561a34){var _0x1af4b4={};_0x1af4b4[_0x561a34]={'$like':'%'+_0x58aee7['query'][_0xa30d('0x45')]+'%'};return _0x1af4b4;})});}_0xbb54c4=_[_0xa30d('0x46')]({},_0xbb54c4,_0x58aee7[_0xa30d('0x8b')]);return db[_0xa30d('0x8f')][_0xa30d('0x20')]({'where':_0xbb54c4[_0xa30d('0x41')]})['then'](function(_0x36a599){_0x422db6['count']=_0x36a599;if(_0x58aee7['query'][_0xa30d('0x4b')]){_0xbb54c4[_0xa30d('0x48')]=[{'all':!![]}];}return db[_0xa30d('0x8f')][_0xa30d('0x4e')](_0xbb54c4);})['then'](function(_0x448084){_0x422db6[_0xa30d('0x90')]=_0x448084;return _0x422db6;});}})[_0xa30d('0x29')](respondWithFilteredResult(_0x5aa98c,_0xbb54c4))[_0xa30d('0x50')](handleError(_0x5aa98c,null));};exports[_0xa30d('0x91')]=function(_0x3f1ed6,_0x40818c,_0x2d393b){var _0x5b2ede={'raw':!![],'where':{}};var _0x55f87e={};var _0x5a8d5c={'count':0x0,'rows':[]};return db[_0xa30d('0x30')][_0xa30d('0x89')]({'where':{'id':_0x3f1ed6['params']['id']}})[_0xa30d('0x29')](handleEntityNotFound(_0x40818c,null))[_0xa30d('0x29')](function(_0x2fdbda){if(_0x2fdbda){_0x55f87e[_0xa30d('0x32')]=_[_0xa30d('0x36')](db[_0xa30d('0x92')]['rawAttributes']);_0x55f87e[_0xa30d('0x33')]=_['keys'](_0x3f1ed6[_0xa30d('0x33')]);_0x55f87e[_0xa30d('0x37')]=_['intersection'](_0x55f87e[_0xa30d('0x32')],_0x55f87e['query']);_0x5b2ede[_0xa30d('0x39')]=_[_0xa30d('0x38')](_0x55f87e[_0xa30d('0x32')],qs[_0xa30d('0x3a')](_0x3f1ed6['query'][_0xa30d('0x3a')]));_0x5b2ede['attributes']=_0x5b2ede['attributes']['length']?_0x5b2ede['attributes']:_0x55f87e[_0xa30d('0x32')];if(!_0x3f1ed6[_0xa30d('0x33')][_0xa30d('0x3c')](_0xa30d('0x3d'))){_0x5b2ede[_0xa30d('0x3e')]=qs['limit'](_0x3f1ed6[_0xa30d('0x33')][_0xa30d('0x3e')]);_0x5b2ede['offset']=qs['offset'](_0x3f1ed6['query'][_0xa30d('0x21')]);}_0x5b2ede['order']=qs[_0xa30d('0x40')](_0x3f1ed6[_0xa30d('0x33')][_0xa30d('0x40')]);_0x5b2ede[_0xa30d('0x41')]=qs[_0xa30d('0x37')](_[_0xa30d('0x42')](_0x3f1ed6[_0xa30d('0x33')],_0x55f87e[_0xa30d('0x37')]));_0x5b2ede[_0xa30d('0x41')][_0xa30d('0x93')]=_0x2fdbda['id'];if(_0x3f1ed6[_0xa30d('0x33')][_0xa30d('0x45')]){_0x5b2ede[_0xa30d('0x41')]=_[_0xa30d('0x46')](_0x5b2ede[_0xa30d('0x41')],{'$or':_[_0xa30d('0x47')](_0x5b2ede['attributes'],function(_0x412997){var _0x28d0fd={};_0x28d0fd[_0x412997]={'$like':'%'+_0x3f1ed6['query'][_0xa30d('0x45')]+'%'};return _0x28d0fd;})});}_0x5b2ede=_['merge']({},_0x5b2ede,_0x3f1ed6['options']);return db[_0xa30d('0x92')][_0xa30d('0x20')]({'where':_0x5b2ede['where']})[_0xa30d('0x29')](function(_0x39124c){_0x5a8d5c['count']=_0x39124c;if(_0x3f1ed6[_0xa30d('0x33')][_0xa30d('0x4b')]){_0x5b2ede[_0xa30d('0x48')]=[{'all':!![]}];}return db[_0xa30d('0x92')][_0xa30d('0x4e')](_0x5b2ede);})['then'](function(_0x24db3f){_0x5a8d5c[_0xa30d('0x90')]=_0x24db3f;return _0x5a8d5c;});}})[_0xa30d('0x29')](respondWithFilteredResult(_0x40818c,_0x5b2ede))[_0xa30d('0x50')](handleError(_0x40818c,null));};exports[_0xa30d('0x94')]=function(_0x9e852c,_0x2be958,_0x5dc79a){var _0x2705c1={'raw':!![],'where':{}};var _0xf998ff={};var _0x121bcb={'count':0x0,'rows':[]};return db[_0xa30d('0x30')][_0xa30d('0x89')]({'where':{'id':_0x9e852c[_0xa30d('0x79')]['id']}})[_0xa30d('0x29')](handleEntityNotFound(_0x2be958,null))[_0xa30d('0x29')](function(_0x2fba0b){if(_0x2fba0b){_0xf998ff[_0xa30d('0x32')]=_['keys'](db[_0xa30d('0x95')][_0xa30d('0x8a')]);_0xf998ff[_0xa30d('0x33')]=_[_0xa30d('0x36')](_0x9e852c[_0xa30d('0x33')]);_0xf998ff[_0xa30d('0x37')]=_[_0xa30d('0x38')](_0xf998ff['model'],_0xf998ff['query']);_0x2705c1[_0xa30d('0x39')]=_[_0xa30d('0x38')](_0xf998ff[_0xa30d('0x32')],qs[_0xa30d('0x3a')](_0x9e852c['query']['fields']));_0x2705c1[_0xa30d('0x39')]=_0x2705c1['attributes']['length']?_0x2705c1[_0xa30d('0x39')]:_0xf998ff[_0xa30d('0x32')];if(!_0x9e852c[_0xa30d('0x33')][_0xa30d('0x3c')](_0xa30d('0x3d'))){_0x2705c1[_0xa30d('0x3e')]=qs['limit'](_0x9e852c[_0xa30d('0x33')]['limit']);_0x2705c1[_0xa30d('0x21')]=qs[_0xa30d('0x21')](_0x9e852c[_0xa30d('0x33')][_0xa30d('0x21')]);}_0x2705c1[_0xa30d('0x3f')]=qs[_0xa30d('0x40')](_0x9e852c[_0xa30d('0x33')]['sort']);_0x2705c1['where']=qs[_0xa30d('0x37')](_[_0xa30d('0x42')](_0x9e852c[_0xa30d('0x33')],_0xf998ff[_0xa30d('0x37')]));_0x2705c1['where'][_0xa30d('0x93')]=_0x2fba0b['id'];if(_0x9e852c[_0xa30d('0x33')][_0xa30d('0x45')]){_0x2705c1[_0xa30d('0x41')]=_[_0xa30d('0x46')](_0x2705c1[_0xa30d('0x41')],{'$or':_[_0xa30d('0x47')](_0x2705c1['attributes'],function(_0x3477cf){var _0x2a5cd4={};_0x2a5cd4[_0x3477cf]={'$like':'%'+_0x9e852c[_0xa30d('0x33')]['filter']+'%'};return _0x2a5cd4;})});}_0x2705c1=_[_0xa30d('0x46')]({},_0x2705c1,_0x9e852c[_0xa30d('0x8b')]);return db[_0xa30d('0x95')][_0xa30d('0x20')]({'where':_0x2705c1[_0xa30d('0x41')]})[_0xa30d('0x29')](function(_0x10a6e2){_0x121bcb[_0xa30d('0x20')]=_0x10a6e2;if(_0x9e852c[_0xa30d('0x33')][_0xa30d('0x4b')]){_0x2705c1[_0xa30d('0x48')]=[{'all':!![]}];}return db[_0xa30d('0x95')]['findAll'](_0x2705c1);})[_0xa30d('0x29')](function(_0x20915b){_0x121bcb[_0xa30d('0x90')]=_0x20915b;return _0x121bcb;});}})[_0xa30d('0x29')](respondWithFilteredResult(_0x2be958,_0x2705c1))[_0xa30d('0x50')](handleError(_0x2be958,null));};exports[_0xa30d('0x96')]=function(_0x12d2cb,_0x15e2f6,_0xed75fd){var _0xaf9395={'raw':!![],'where':{}};var _0x4b2349={};var _0x4dc21b={'count':0x0,'rows':[]};return db[_0xa30d('0x30')][_0xa30d('0x89')]({'where':{'id':_0x12d2cb[_0xa30d('0x79')]['id']}})[_0xa30d('0x29')](handleEntityNotFound(_0x15e2f6,null))[_0xa30d('0x29')](function(_0x2f8ee0){if(_0x2f8ee0){_0x4b2349[_0xa30d('0x32')]=_['keys'](db[_0xa30d('0x97')][_0xa30d('0x8a')]);_0x4b2349[_0xa30d('0x33')]=_['keys'](_0x12d2cb[_0xa30d('0x33')]);_0x4b2349['filters']=_[_0xa30d('0x38')](_0x4b2349[_0xa30d('0x32')],_0x4b2349[_0xa30d('0x33')]);_0xaf9395[_0xa30d('0x39')]=_[_0xa30d('0x38')](_0x4b2349['model'],qs[_0xa30d('0x3a')](_0x12d2cb['query'][_0xa30d('0x3a')]));_0xaf9395['attributes']=_0xaf9395[_0xa30d('0x39')]['length']?_0xaf9395[_0xa30d('0x39')]:_0x4b2349[_0xa30d('0x32')];if(!_0x12d2cb[_0xa30d('0x33')][_0xa30d('0x3c')]('nolimit')){_0xaf9395[_0xa30d('0x3e')]=qs[_0xa30d('0x3e')](_0x12d2cb['query'][_0xa30d('0x3e')]);_0xaf9395[_0xa30d('0x21')]=qs['offset'](_0x12d2cb['query'][_0xa30d('0x21')]);}_0xaf9395['order']=qs['sort'](_0x12d2cb[_0xa30d('0x33')]['sort']);_0xaf9395['where']=qs[_0xa30d('0x37')](_['pick'](_0x12d2cb['query'],_0x4b2349[_0xa30d('0x37')]));_0xaf9395[_0xa30d('0x41')][_0xa30d('0x93')]=_0x2f8ee0['id'];if(_0x12d2cb[_0xa30d('0x33')][_0xa30d('0x45')]){_0xaf9395[_0xa30d('0x41')]=_['merge'](_0xaf9395['where'],{'$or':_[_0xa30d('0x47')](_0xaf9395[_0xa30d('0x39')],function(_0x62055b){var _0x4388aa={};_0x4388aa[_0x62055b]={'$like':'%'+_0x12d2cb[_0xa30d('0x33')]['filter']+'%'};return _0x4388aa;})});}_0xaf9395=_[_0xa30d('0x46')]({},_0xaf9395,_0x12d2cb[_0xa30d('0x8b')]);return db[_0xa30d('0x97')][_0xa30d('0x20')]({'where':_0xaf9395[_0xa30d('0x41')]})[_0xa30d('0x29')](function(_0xee4d70){_0x4dc21b[_0xa30d('0x20')]=_0xee4d70;if(_0x12d2cb[_0xa30d('0x33')][_0xa30d('0x4b')]){_0xaf9395[_0xa30d('0x48')]=[{'all':!![]}];}return db[_0xa30d('0x97')]['findAll'](_0xaf9395);})[_0xa30d('0x29')](function(_0x5600e5){_0x4dc21b[_0xa30d('0x90')]=_0x5600e5;return _0x4dc21b;});}})['then'](respondWithFilteredResult(_0x15e2f6,_0xaf9395))[_0xa30d('0x50')](handleError(_0x15e2f6,null));};exports[_0xa30d('0x98')]=function(_0x19c6f0,_0x1d72b9,_0x4cab06){try{if(!_0x19c6f0[_0xa30d('0x56')][_0xa30d('0x76')]){throw new Error('No\x20ListId\x20specified');}if(!_0x19c6f0['body']['binding_keys']){throw new Error('No\x20association\x20keys\x20specified!');}if(!_0x19c6f0[_0xa30d('0x56')][_0xa30d('0x99')]){throw new Error(_0xa30d('0x9a'));}if(!_0x19c6f0[_0xa30d('0x56')][_0xa30d('0x9b')]){throw new Error(_0xa30d('0x9c'));}var _0xaf6d28=_0x19c6f0['body'][_0xa30d('0x9d')]['split'](',');var _0x4f2208=_0x19c6f0[_0xa30d('0x56')]['binding_values']['split'](',');if(!_0xaf6d28['length']||!_0x4f2208['length']||_0xaf6d28['length']!==_0x4f2208[_0xa30d('0x3b')]){throw new Error(_0xa30d('0x9e'));}_0x19c6f0[_0xa30d('0x56')][_0xa30d('0x3a')]=_['zipObject'](_0xaf6d28,_0x4f2208);if(!_0x19c6f0['body'][_0xa30d('0x3a')][_0xa30d('0x87')]){throw new Error(_0xa30d('0x9f'));}if(!_0x19c6f0[_0xa30d('0x56')][_0xa30d('0x3a')][_0xa30d('0xa0')]){throw new Error(_0xa30d('0xa1'));}var _0xecf5a2=path[_0xa30d('0x5a')](config['root'],_0xa30d('0xa2'),_0x19c6f0[_0xa30d('0xa3')][_0xa30d('0xa4')]);fs[_0xa30d('0xa5')](_0xecf5a2,parseInt(_0xa30d('0xa6'),0x8));var _0x1553d2=require(_0xa30d('0xa7'))[_0xa30d('0xa8')](path[_0xa30d('0x5a')](__dirname,'../../components/import/cm/csv'),[_0xecf5a2,_0x19c6f0[_0xa30d('0x56')][_0xa30d('0x9d')],_0x19c6f0[_0xa30d('0x56')][_0xa30d('0x99')],_0x19c6f0[_0xa30d('0x56')][_0xa30d('0x76')],_0x19c6f0[_0xa30d('0x56')][_0xa30d('0xa9')],_0x19c6f0['body'][_0xa30d('0x74')],_0x19c6f0[_0xa30d('0x56')]['socket_timestamp']]);return _0x1d72b9[_0xa30d('0x1f')](0xc8)[_0xa30d('0x23')]({'message':_0xa30d('0xaa'),'pid':_0x1553d2[_0xa30d('0xab')]});}catch(_0x38d451){return _0x1d72b9[_0xa30d('0x1f')](0x1f4)['send'](_0x38d451);}};exports[_0xa30d('0xac')]=function(_0x4f2129,_0x89c5dd,_0x20fb78){var _0x5860d1=fs['createReadStream'](_0x4f2129[_0xa30d('0xa3')][_0xa30d('0x9')]);Papa['parse'](_0x5860d1,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x48e946){return _0x89c5dd[_0xa30d('0x1f')](0xc8)[_0xa30d('0x23')]({'file':_0x4f2129['file'],'fields':_0x48e946[_0xa30d('0xad')][_0xa30d('0x3a')]});}});};exports['import']=function(_0x24e003,_0x2a3a29,_0x4faad6){return db['User'][_0xa30d('0x4e')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0xa30d('0x29')](function(_0x28dd06){var _0x354512=![];if(!_0x24e003[_0xa30d('0x56')][_0xa30d('0x76')]){throw new Error(_0xa30d('0xae'));}if(!_0x24e003[_0xa30d('0x56')][_0xa30d('0xaf')]['phone']){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x24e003[_0xa30d('0x56')][_0xa30d('0xaf')][_0xa30d('0xa0')]){throw new Error(_0xa30d('0xa1'));}if(!_0x24e003[_0xa30d('0x56')][_0xa30d('0x9b')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x425d9b=require(_0xa30d('0xa7'))[_0xa30d('0xa8')](path['join'](__dirname,_0xa30d('0xb0')),[_0x24e003[_0xa30d('0x79')]['id'],JSON[_0xa30d('0xb1')](_0x24e003[_0xa30d('0x56')]),JSON['stringify'](_0x28dd06)]);_0x425d9b['on'](_0xa30d('0xb2'),function(_0x24906f){_0x354512=!![];return _0x2a3a29['status'](0xc8)[_0xa30d('0x23')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x425d9b[_0xa30d('0xab')]});});_0x425d9b['on'](_0xa30d('0xb3'),function(_0x2bd468){if(_0x2bd468&&!_0x354512){return _0x2a3a29[_0xa30d('0x1f')](0x1f4)[_0xa30d('0x23')]({'message':_0xa30d('0xb4'),'pid':_0x425d9b[_0xa30d('0xab')]});}});})[_0xa30d('0x50')](handleError(_0x2a3a29,null));};
\ No newline at end of file
+var _0x7561=['../../config/environment','../../mysqldb','redis','socket.io-emitter','./cmContact.socket','register','sendStatus','status','end','json','offset','set','Content-Range','apply','reject','save','then','destroy','error','stack','name','send','index','CmContact','model','query','dateStart','dateEnd','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','limit','order','sort','where','pick','day','add','merge','filter','map','key','VIRTUAL','field','options','tag','include','push','Tags','distinct','count','includeAll','Tag','color','ThroughTags','findAll','rows','catch','params','describe','startsWith','cf_','displayName','columnName','alias','body','from','get','mergeWith','tags','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','update','ChatOfflineMessage','MailInteraction','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','isArray','create','each','duplicates','$or','ListId','findOrCreate','spread','find','$and','CmCustomField','format','cf_%d','pickBy','isEmpty','id\x20=\x20?','sequelize','text','phone','CmHopper','getTags','rawAttributes','setTags','ids','getHoppers','findOne','ContactId','getHopperHistories','getHopperFinals','getJscriptySessions','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','split','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','join','root','file','filename','chmodSync','child_process','fork','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','pid','upload','createReadStream','path','parse','import','User','agent','binding','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','html-pdf','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','sox','to-csv','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/parsers/qs','api','../../config/utils'];(function(_0x1e500e,_0x2c9d74){var _0x10dc5e=function(_0x354423){while(--_0x354423){_0x1e500e['push'](_0x1e500e['shift']());}};_0x10dc5e(++_0x2c9d74);}(_0x7561,0xa6));var _0x1756=function(_0x47e7cb,_0x4c1b8d){_0x47e7cb=_0x47e7cb-0x0;var _0x2a8874=_0x7561[_0x47e7cb];return _0x2a8874;};'use strict';var pdf=require(_0x1756('0x0'));var emlformat=require(_0x1756('0x1'));var rimraf=require(_0x1756('0x2'));var zipdir=require(_0x1756('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0x1756('0x4'));var moment=require(_0x1756('0x5'));var BPromise=require(_0x1756('0x6'));var Mustache=require(_0x1756('0x7'));var util=require(_0x1756('0x8'));var path=require('path');var sox=require(_0x1756('0x9'));var csv=require(_0x1756('0xa'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x1756('0xb'));var squel=require(_0x1756('0xc'));var crypto=require(_0x1756('0xd'));var jsforce=require(_0x1756('0xe'));var deskjs=require(_0x1756('0xf'));var toCsv=require(_0x1756('0xa'));var querystring=require('querystring');var Papa=require(_0x1756('0x10'));var Redis=require(_0x1756('0x11'));var qs=require(_0x1756('0x12'));var logger=require('../../config/logger')(_0x1756('0x13'));var utils=require(_0x1756('0x14'));var config=require(_0x1756('0x15'));var db=require(_0x1756('0x16'))['db'];config[_0x1756('0x17')]=_['defaults'](config[_0x1756('0x17')],{'host':'localhost','port':0x18eb});var socket=require(_0x1756('0x18'))(new Redis(config[_0x1756('0x17')]));require(_0x1756('0x19'))[_0x1756('0x1a')](socket);function respondWithStatusCode(_0x3b0791,_0x19921b){_0x19921b=_0x19921b||0xcc;return function(_0x4de7d4){if(_0x4de7d4){return _0x3b0791[_0x1756('0x1b')](_0x19921b);}return _0x3b0791[_0x1756('0x1c')](_0x19921b)[_0x1756('0x1d')]();};}function respondWithResult(_0x38fe4e,_0x580220){_0x580220=_0x580220||0xc8;return function(_0x5bf464){if(_0x5bf464){return _0x38fe4e[_0x1756('0x1c')](_0x580220)[_0x1756('0x1e')](_0x5bf464);}};}function respondWithFilteredResult(_0x2646b7,_0x62167d){return function(_0x5720d0){if(_0x5720d0){var _0x3fcf74=_0x5720d0['count'],_0x424901=_0x62167d[_0x1756('0x1f')],_0xa49afe=_0x62167d['offset']+_0x62167d['limit'],_0x1ed4c1;if(_0xa49afe>=_0x3fcf74){_0xa49afe=_0x3fcf74;_0x1ed4c1=0xc8;}else{_0x1ed4c1=0xce;}_0x2646b7[_0x1756('0x1c')](_0x1ed4c1);return _0x2646b7[_0x1756('0x20')](_0x1756('0x21'),_0x424901+'-'+_0xa49afe+'/'+_0x3fcf74)[_0x1756('0x1e')](_0x5720d0);}return null;};}function patchUpdates(_0x4fa8a3){return function(_0x213b28){try{jsonpatch[_0x1756('0x22')](_0x213b28,_0x4fa8a3,!![]);}catch(_0x4024a6){return BPromise[_0x1756('0x23')](_0x4024a6);}return _0x213b28[_0x1756('0x24')]();};}function saveUpdates(_0x11207c,_0x59908f){return function(_0xdb6b10){if(_0xdb6b10){return _0xdb6b10['update'](_0x11207c)[_0x1756('0x25')](function(_0x42a077){return _0x42a077;});}return null;};}function removeEntity(_0x5a1b0a,_0x1df7e7){return function(_0x51a21e){if(_0x51a21e){return _0x51a21e[_0x1756('0x26')]()[_0x1756('0x25')](function(){_0x5a1b0a[_0x1756('0x1c')](0xcc)[_0x1756('0x1d')]();});}};}function handleEntityNotFound(_0x2c28bb,_0x311c1c){return function(_0x40b7fe){if(!_0x40b7fe){_0x2c28bb[_0x1756('0x1b')](0x194);}return _0x40b7fe;};}function handleError(_0x87f4b1,_0x5e069f){_0x5e069f=_0x5e069f||0x1f4;return function(_0x3b15ff){logger[_0x1756('0x27')](_0x3b15ff[_0x1756('0x28')]);if(_0x3b15ff[_0x1756('0x29')]){delete _0x3b15ff[_0x1756('0x29')];}_0x87f4b1[_0x1756('0x1c')](_0x5e069f)[_0x1756('0x2a')](_0x3b15ff);};}exports[_0x1756('0x2b')]=function(_0x150d91,_0x559305){var _0xa60f11={},_0x29acc4={},_0x53569e={'count':0x0,'rows':[]};return db[_0x1756('0x2c')]['describe']()[_0x1756('0x25')](function(_0x551e4c){_0x29acc4[_0x1756('0x2d')]=_['keys'](_0x551e4c);var _0x531251={'dateStart':_0x150d91[_0x1756('0x2e')]['dateStart'],'dateEnd':_0x150d91[_0x1756('0x2e')]['dateEnd']};delete _0x150d91['query'][_0x1756('0x2f')];delete _0x150d91[_0x1756('0x2e')][_0x1756('0x30')];_0x29acc4[_0x1756('0x2e')]=_[_0x1756('0x31')](_0x150d91[_0x1756('0x2e')]);_0x29acc4[_0x1756('0x32')]=_[_0x1756('0x33')](_0x29acc4[_0x1756('0x2d')],_0x29acc4[_0x1756('0x2e')]);_0xa60f11[_0x1756('0x34')]=_[_0x1756('0x33')](_0x29acc4['model'],qs[_0x1756('0x35')](_0x150d91[_0x1756('0x2e')][_0x1756('0x35')]));_0xa60f11[_0x1756('0x34')]=_0xa60f11[_0x1756('0x34')][_0x1756('0x36')]?_0xa60f11['attributes']:_0x29acc4[_0x1756('0x2d')];if(!_0x150d91[_0x1756('0x2e')][_0x1756('0x37')](_0x1756('0x38'))){_0xa60f11[_0x1756('0x39')]=qs[_0x1756('0x39')](_0x150d91[_0x1756('0x2e')][_0x1756('0x39')]);_0xa60f11[_0x1756('0x1f')]=qs[_0x1756('0x1f')](_0x150d91[_0x1756('0x2e')]['offset']);}_0xa60f11[_0x1756('0x3a')]=qs['sort'](_0x150d91[_0x1756('0x2e')][_0x1756('0x3b')]);_0xa60f11[_0x1756('0x3c')]=qs[_0x1756('0x32')](_[_0x1756('0x3d')](_0x150d91['query'],_0x29acc4['filters']));if(_0x531251[_0x1756('0x2f')]){if(_0x531251[_0x1756('0x30')]){_0x531251[_0x1756('0x30')]=moment(_0x531251['dateEnd'])['add'](0x1,_0x1756('0x3e'));}else{_0x531251['dateEnd']=moment(_0x531251[_0x1756('0x2f')])[_0x1756('0x3f')](0x1,_0x1756('0x3e'));}_[_0x1756('0x40')](_0xa60f11[_0x1756('0x3c')],{'createdAt':{'$gte':_0x531251[_0x1756('0x2f')],'$lte':_0x531251[_0x1756('0x30')]}});}if(_0x150d91[_0x1756('0x2e')][_0x1756('0x41')]){_0xa60f11[_0x1756('0x3c')]=_[_0x1756('0x40')](_0xa60f11[_0x1756('0x3c')],{'$or':_[_0x1756('0x42')](_0x551e4c,function(_0x428bef){if(_0x428bef['type'][_0x1756('0x43')]!==_0x1756('0x44')){var _0x568773={};_0x568773[_0x428bef[_0x1756('0x45')]]={'$like':'%'+_0x150d91[_0x1756('0x2e')][_0x1756('0x41')]+'%'};return _0x568773;}})});}_0xa60f11=_[_0x1756('0x40')]({},_0xa60f11,_0x150d91[_0x1756('0x46')]);var _0x477ba9={'where':_0xa60f11[_0x1756('0x3c')]};_0x477ba9['include']=[];if(_0x150d91[_0x1756('0x2e')][_0x1756('0x47')]){_0x477ba9[_0x1756('0x48')][_0x1756('0x49')]({'model':db['Tag'],'as':_0x1756('0x4a'),'attributes':['id'],'where':{'id':_0x150d91[_0x1756('0x2e')][_0x1756('0x47')]},'required':!![]});_0x477ba9[_0x1756('0x4b')]=!![];}return db['CmContact']['count'](_0x477ba9)[_0x1756('0x25')](function(_0x4ac0f1){_0x53569e[_0x1756('0x4c')]=_0x4ac0f1;if(_0x150d91[_0x1756('0x2e')][_0x1756('0x4d')]){_0xa60f11[_0x1756('0x48')]=[{'model':db[_0x1756('0x4e')],'as':_0x1756('0x4a'),'attributes':['id',_0x1756('0x29'),_0x1756('0x4f')],'required':_0x150d91[_0x1756('0x2e')][_0x1756('0x47')]?!![]:![]},{'model':db[_0x1756('0x4e')],'as':_0x1756('0x50'),'attributes':['id',_0x1756('0x29'),'color'],'through':_0x150d91[_0x1756('0x2e')]['tag']?{'attributes':[],'where':{'TagId':_0x150d91[_0x1756('0x2e')][_0x1756('0x47')]||undefined}}:{},'required':_0x150d91[_0x1756('0x2e')][_0x1756('0x47')]?!![]:![]}];}return db['CmContact'][_0x1756('0x51')](_0xa60f11);})[_0x1756('0x25')](function(_0x4463a0){_0x53569e[_0x1756('0x52')]=_0x4463a0;return _0x53569e;})['then'](respondWithFilteredResult(_0x559305,_0xa60f11))[_0x1756('0x53')](handleError(_0x559305,null));});};exports[_0x1756('0x26')]=function(_0x4f0c42,_0x5f3989){return db[_0x1756('0x2c')]['find']({'where':{'id':_0x4f0c42[_0x1756('0x54')]['id']}})[_0x1756('0x25')](handleEntityNotFound(_0x5f3989,null))[_0x1756('0x25')](removeEntity(_0x5f3989,null))['catch'](handleError(_0x5f3989,null));};exports[_0x1756('0x55')]=function(_0x3f5812,_0x5c05f6){return db[_0x1756('0x2c')][_0x1756('0x55')]()[_0x1756('0x25')](function(_0x416781){for(var _0x2ff689=0x0;_0x2ff689<Object[_0x1756('0x31')](_0x416781)[_0x1756('0x36')];_0x2ff689++){var _0x2835b0=Object[_0x1756('0x31')](_0x416781)[_0x2ff689];if(!_[_0x1756('0x56')](_0x2835b0,_0x1756('0x57'))){_0x416781[_0x2835b0]['columnName']=_0x2835b0;_0x416781[_0x2835b0][_0x1756('0x58')]=_0x2835b0;}}return _0x416781;})[_0x1756('0x25')](function(_0x389487){var _0x1e29c3={'where':{'$or':[{'ListId':_0x3f5812[_0x1756('0x2e')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0x1756('0x51')](_0x1e29c3)[_0x1756('0x25')](function(_0x1def08){for(var _0x43ca6a=0x0;_0x43ca6a<_0x1def08['length'];_0x43ca6a++){var _0x2517db='cf_'+_0x1def08[_0x43ca6a]['id'];_0x389487[_0x2517db][_0x1756('0x59')]=_0x2517db;_0x389487[_0x2517db][_0x1756('0x58')]=_0x1def08[_0x43ca6a][_0x1756('0x5a')];}for(var _0x43ca6a=0x0;_0x43ca6a<Object[_0x1756('0x31')](_0x389487)[_0x1756('0x36')];_0x43ca6a++){var _0x2517db=Object[_0x1756('0x31')](_0x389487)[_0x43ca6a];if(!_0x389487[_0x2517db][_0x1756('0x37')](_0x1756('0x59'))){delete _0x389487[_0x2517db];}}return _0x389487;});})[_0x1756('0x25')](respondWithResult(_0x5c05f6,null))[_0x1756('0x53')](handleError(_0x5c05f6,null));};exports[_0x1756('0x40')]=function(_0xca1c88,_0x57d2e9){var _0x10e69f;var _0xe2beb4;var _0x2091d9;if(_0xca1c88[_0x1756('0x5b')]['id']){delete _0xca1c88[_0x1756('0x5b')]['id'];}return db[_0x1756('0x2c')][_0x1756('0x51')]({'where':{'id':[_0xca1c88[_0x1756('0x5b')]['to'],_0xca1c88[_0x1756('0x5b')][_0x1756('0x5c')]]}})['then'](function(_0x3a3889){if(_0x3a3889){if(_0x3a3889[_0x1756('0x36')]!==0x2){return null;}_0x3a3889[0x0]=_0x3a3889[0x0][_0x1756('0x5d')]({'plain':!![]});_0x3a3889[0x1]=_0x3a3889[0x1][_0x1756('0x5d')]({'plain':!![]});delete _0x3a3889[0x0]['id'];delete _0x3a3889[0x1]['id'];return _[_0x1756('0x5e')](_0x3a3889[0x0],_0x3a3889[0x1],function(_0x54e240,_0x1ec48b){if(Array['isArray'](_0x1ec48b)&&!_0x1ec48b['length']){return _0x54e240;}else if(!_0x1ec48b){return _0x54e240;}});}})[_0x1756('0x25')](handleEntityNotFound(_0x57d2e9,null))[_0x1756('0x25')](function(_0x184f68){if(_0x184f68){if(_0x184f68[_0x1756('0x5f')]&&_['isArray'](_0x184f68[_0x1756('0x5f')])){_0x184f68['tags']=_0x184f68['tags']['join']();}logger[_0x1756('0x60')](_0x1756('0x61'),_0xca1c88[_0x1756('0x5b')]['to'],_0xca1c88[_0x1756('0x5b')][_0x1756('0x5c')]);return db['CmHopper']['destroy']({'where':{'ContactId':[_0xca1c88[_0x1756('0x5b')]['to'],_0xca1c88[_0x1756('0x5b')][_0x1756('0x5c')]]}})[_0x1756('0x25')](function(_0x118315){logger[_0x1756('0x60')](_0x1756('0x62'),_0x118315);return db[_0x1756('0x63')]['destroy']({'where':{'ContactId':[_0xca1c88[_0x1756('0x5b')]['to'],_0xca1c88[_0x1756('0x5b')][_0x1756('0x5c')]]}})[_0x1756('0x25')](function(_0xf9c455){logger['info'](_0x1756('0x64'),_0xf9c455);return db[_0x1756('0x2c')]['create'](_0x184f68);});});}})[_0x1756('0x25')](function(_0x54ab39){if(_0x54ab39){_0x10e69f=_0x54ab39;_0xe2beb4={'ContactId':_0x10e69f['id']};_0x2091d9={'where':{'ContactId':[_0xca1c88[_0x1756('0x5b')]['to'],_0xca1c88['body'][_0x1756('0x5c')]]}};return db['ChatInteraction'][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})[_0x1756('0x25')](function(){if(_0x10e69f){return db['ChatMessage'][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})[_0x1756('0x25')](function(){if(_0x10e69f){return db[_0x1756('0x66')]['update'](_0xe2beb4,_0x2091d9);}})[_0x1756('0x25')](function(){if(_0x10e69f){return db[_0x1756('0x67')][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})[_0x1756('0x25')](function(){if(_0x10e69f){return db['MailMessage'][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})[_0x1756('0x25')](function(){if(_0x10e69f){return db[_0x1756('0x67')][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})[_0x1756('0x25')](function(){if(_0x10e69f){return db['MailMessage'][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})[_0x1756('0x25')](function(){if(_0x10e69f){return db[_0x1756('0x68')]['update'](_0xe2beb4,_0x2091d9);}})[_0x1756('0x25')](function(){if(_0x10e69f){return db[_0x1756('0x69')]['update'](_0xe2beb4,_0x2091d9);}})[_0x1756('0x25')](function(){if(_0x10e69f){return db[_0x1756('0x6a')][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})[_0x1756('0x25')](function(){if(_0x10e69f){return db[_0x1756('0x6b')]['update'](_0xe2beb4,_0x2091d9);}})[_0x1756('0x25')](function(){if(_0x10e69f){return db[_0x1756('0x6c')][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})[_0x1756('0x25')](function(){if(_0x10e69f){return db[_0x1756('0x6d')][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})[_0x1756('0x25')](function(){if(_0x10e69f){return db[_0x1756('0x6e')][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})[_0x1756('0x25')](function(){if(_0x10e69f){return db[_0x1756('0x6f')][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})['then'](function(){if(_0x10e69f){return db[_0x1756('0x70')]['update'](_0xe2beb4,_0x2091d9);}})['then'](function(){if(_0x10e69f){return db['VoiceCallReport'][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})[_0x1756('0x25')](function(){if(_0x10e69f){return db[_0x1756('0x71')][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})['then'](function(){if(_0x10e69f){return db[_0x1756('0x72')][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})['then'](function(){if(_0x10e69f){return db[_0x1756('0x73')][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})['then'](function(){if(_0x10e69f){return db[_0x1756('0x74')][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})[_0x1756('0x25')](function(){if(_0x10e69f){return db[_0x1756('0x75')][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})[_0x1756('0x25')](function(){if(_0x10e69f){return db[_0x1756('0x76')][_0x1756('0x65')](_0xe2beb4,_0x2091d9);}})['then'](function(){if(_0x10e69f){return db['CmContact']['destroy']({'where':{'id':[_0xca1c88[_0x1756('0x5b')]['to'],_0xca1c88[_0x1756('0x5b')][_0x1756('0x5c')]]}});}})[_0x1756('0x25')](function(){if(_0x10e69f){return _0x10e69f;}})[_0x1756('0x25')](respondWithResult(_0x57d2e9,null))[_0x1756('0x53')](handleError(_0x57d2e9,null));};exports['create']=function(_0x9ee3aa,_0x2efeee){return db[_0x1756('0x2c')][_0x1756('0x55')]()[_0x1756('0x25')](function(_0x4bc809){if(_0x9ee3aa[_0x1756('0x5b')]['tags']&&_[_0x1756('0x77')](_0x9ee3aa['body'][_0x1756('0x5f')])){if(_0x9ee3aa[_0x1756('0x5b')][_0x1756('0x5f')][_0x1756('0x36')]){_0x9ee3aa[_0x1756('0x5b')][_0x1756('0x5f')]=_0x9ee3aa[_0x1756('0x5b')][_0x1756('0x5f')]['join'](';')+';';}else{_0x9ee3aa['body']['tags']=null;}}else{_0x9ee3aa[_0x1756('0x5b')][_0x1756('0x5f')]=null;}return db[_0x1756('0x2c')][_0x1756('0x78')](_0x9ee3aa[_0x1756('0x5b')],{'fields':_[_0x1756('0x31')](_0x4bc809),'raw':!![]});})[_0x1756('0x25')](respondWithResult(_0x2efeee,0xc9))['catch'](handleError(_0x2efeee,null));};exports['bulkCreate']=function(_0x303a0d,_0x4f6068){var _0x329eff=[];var _0x27d1fd=0x0;var _0x3eed1b=0x0;var _0x275129=0x0;return db[_0x1756('0x2c')][_0x1756('0x55')]()[_0x1756('0x25')](function(_0x2066a5){return BPromise[_0x1756('0x79')](_0x303a0d[_0x1756('0x5b')],function(_0x310cec){var _0x3b6e8e={'where':{'$or':[]},'defaults':_0x310cec,'fields':_[_0x1756('0x31')](_0x2066a5),'raw':!![]};if(_0x310cec['duplicates']){for(var _0x4ca540=0x0;_0x4ca540<_0x310cec[_0x1756('0x7a')][_0x1756('0x36')];_0x4ca540++){var _0x6d9ba6={};_0x6d9ba6[_0x310cec[_0x1756('0x7a')][_0x4ca540]]=_0x310cec[_0x310cec[_0x1756('0x7a')][_0x4ca540]];_0x3b6e8e[_0x1756('0x3c')][_0x1756('0x7b')][_0x1756('0x49')](_0x6d9ba6);}_0x3b6e8e[_0x1756('0x3c')][_0x1756('0x7c')]=_0x310cec[_0x1756('0x7c')];}return db[_0x1756('0x2c')][_0x1756('0x7d')](_0x3b6e8e)[_0x1756('0x7e')](function(_0x5d2d5b,_0x4f5caa){if(_0x4f5caa){_0x27d1fd++;}else{_0x275129++;}})[_0x1756('0x53')](function(_0x4913e){console[_0x1756('0x27')](_0x4913e);_0x3eed1b++;});});})[_0x1756('0x25')](function(_0x3d64ed){if(_0x3d64ed){return{'success':_0x27d1fd,'failure':_0x3eed1b,'duplicates':_0x275129};}})[_0x1756('0x25')](respondWithResult(_0x4f6068,0xc9))[_0x1756('0x53')](handleError(_0x4f6068,null));};exports['show']=function(_0x3d88d9,_0x1f4dd3,_0x34b9dd){var _0x125ee8;return db[_0x1756('0x2c')][_0x1756('0x55')]()[_0x1756('0x25')](function(_0x125f47){return db[_0x1756('0x2c')][_0x1756('0x7f')]({'where':{'id':_0x3d88d9[_0x1756('0x54')]['id']},'include':[{'model':db['Tag'],'as':_0x1756('0x4a'),'attributes':['id',_0x1756('0x29'),_0x1756('0x4f')],'required':_0x3d88d9['query'][_0x1756('0x47')]?!![]:![]}],'attributes':_['keys'](_0x125f47)});})[_0x1756('0x25')](function(_0x43c741){_0x125ee8=_0x43c741['get']({'plain':!![]});var _0x337de5={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x43c741&&_0x43c741['ListId']){if(_0x43c741[_0x1756('0x7c')]){_0x337de5['where'][_0x1756('0x80')][_0x1756('0x49')]({'ListId':{'$ne':_0x43c741[_0x1756('0x7c')]}});}}return db[_0x1756('0x81')][_0x1756('0x51')](_0x337de5);})['then'](function(_0x68a4af){return _['omit'](_0x125ee8,_[_0x1756('0x42')](_0x68a4af,function(_0x585ce8){return util[_0x1756('0x82')](_0x1756('0x83'),_0x585ce8['id']);}));})[_0x1756('0x25')](handleEntityNotFound(_0x1f4dd3,null))[_0x1756('0x25')](respondWithResult(_0x1f4dd3,null))['catch'](handleError(_0x1f4dd3,null));};exports[_0x1756('0x65')]=function(_0x13dcdb,_0x19836f){var _0xa47777;if(_0x13dcdb[_0x1756('0x5b')]['id']){delete _0x13dcdb[_0x1756('0x5b')]['id'];}return db[_0x1756('0x2c')][_0x1756('0x7f')]({'where':{'id':_0x13dcdb['params']['id']}})['then'](handleEntityNotFound(_0x19836f,null))[_0x1756('0x25')](saveUpdates(_0x13dcdb['body'],null))[_0x1756('0x25')](function(_0x1b33c5){_0xa47777=_0x1b33c5;var _0x360d11={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x1b33c5&&_0x1b33c5[_0x1756('0x7c')]){if(_0x1b33c5[_0x1756('0x7c')]){_0x360d11[_0x1756('0x3c')]['$and'][_0x1756('0x49')]({'ListId':{'$ne':_0x1b33c5[_0x1756('0x7c')]}});}}return db[_0x1756('0x81')][_0x1756('0x51')](_0x360d11);})[_0x1756('0x25')](function(_0x35f039){if(_0x35f039){return _['omit'](_[_0x1756('0x84')](_0x13dcdb['body'],function(_0x42f14a,_0x56e072){return _[_0x1756('0x56')](_0x56e072,'cf_');}),_[_0x1756('0x42')](_0x35f039,function(_0x18e495){return util[_0x1756('0x82')](_0x1756('0x83'),_0x18e495['id']);}));}})[_0x1756('0x25')](function(_0x1315bd){if(_0x1315bd&&!_[_0x1756('0x85')](_0x1315bd)){var _0xe9166d=squel['update']()['table']('cm_contacts')['setFields'](_0x1315bd)[_0x1756('0x3c')](_0x1756('0x86'),_0x13dcdb['params']['id'])['toParam']();return db[_0x1756('0x87')][_0x1756('0x2e')](_0xe9166d[_0x1756('0x88')],{'replacements':_0xe9166d['values']});}})[_0x1756('0x25')](function(){if(_0x13dcdb['body'][_0x1756('0x89')]&&_0xa47777){return db[_0x1756('0x8a')][_0x1756('0x65')]({'phone':_0x13dcdb[_0x1756('0x5b')]['phone']},{'where':{'ContactId':_0xa47777['id']}});}})[_0x1756('0x25')](function(){return _0xa47777;})[_0x1756('0x25')](respondWithResult(_0x19836f,null))['catch'](handleError(_0x19836f,null));};exports[_0x1756('0x8b')]=function(_0x36d317,_0x5cb996,_0x16aeff){var _0x1b5e5a={};var _0x3a2dc6={};var _0x27090c;var _0x1224f2;return db[_0x1756('0x2c')]['findOne']({'where':{'id':_0x36d317[_0x1756('0x54')]['id']}})['then'](handleEntityNotFound(_0x5cb996,null))['then'](function(_0x230f5b){if(_0x230f5b){_0x27090c=_0x230f5b;_0x3a2dc6['model']=_[_0x1756('0x31')](db['Tag'][_0x1756('0x8c')]);_0x3a2dc6[_0x1756('0x2e')]=_[_0x1756('0x31')](_0x36d317[_0x1756('0x2e')]);_0x3a2dc6[_0x1756('0x32')]=_[_0x1756('0x33')](_0x3a2dc6['model'],_0x3a2dc6['query']);_0x1b5e5a[_0x1756('0x34')]=_[_0x1756('0x33')](_0x3a2dc6[_0x1756('0x2d')],qs['fields'](_0x36d317[_0x1756('0x2e')][_0x1756('0x35')]));_0x1b5e5a['attributes']=_0x1b5e5a[_0x1756('0x34')][_0x1756('0x36')]?_0x1b5e5a[_0x1756('0x34')]:_0x3a2dc6['model'];_0x1b5e5a[_0x1756('0x3a')]=qs[_0x1756('0x3b')](_0x36d317[_0x1756('0x2e')][_0x1756('0x3b')]);_0x1b5e5a['where']=qs[_0x1756('0x32')](_['pick'](_0x36d317[_0x1756('0x2e')],_0x3a2dc6['filters']));if(_0x36d317[_0x1756('0x2e')][_0x1756('0x41')]){_0x1b5e5a['where']=_['merge'](_0x1b5e5a['where'],{'$or':_[_0x1756('0x42')](_0x1b5e5a['attributes'],function(_0x219843){var _0x1ecaaa={};_0x1ecaaa[_0x219843]={'$like':'%'+_0x36d317[_0x1756('0x2e')]['filter']+'%'};return _0x1ecaaa;})});}_0x1b5e5a=_[_0x1756('0x40')]({},_0x1b5e5a,_0x36d317[_0x1756('0x46')]);return _0x27090c[_0x1756('0x8b')](_0x1b5e5a);}})[_0x1756('0x25')](function(_0x276620){if(_0x276620){_0x1224f2=_0x276620[_0x1756('0x36')];if(!_0x36d317['query'][_0x1756('0x37')](_0x1756('0x38'))){_0x1b5e5a[_0x1756('0x39')]=qs[_0x1756('0x39')](_0x36d317[_0x1756('0x2e')][_0x1756('0x39')]);_0x1b5e5a[_0x1756('0x1f')]=qs[_0x1756('0x1f')](_0x36d317['query'][_0x1756('0x1f')]);}return _0x27090c[_0x1756('0x8b')](_0x1b5e5a);}})[_0x1756('0x25')](function(_0x1c6dfc){if(_0x1c6dfc){return _0x1c6dfc?{'count':_0x1224f2,'rows':_0x1c6dfc}:null;}})[_0x1756('0x25')](respondWithResult(_0x5cb996,null))[_0x1756('0x53')](handleError(_0x5cb996,null));};exports[_0x1756('0x8d')]=function(_0x584fe9,_0x1ef490,_0x29d6e6){if(_0x584fe9['body']['id']){delete _0x584fe9[_0x1756('0x5b')]['id'];}return db[_0x1756('0x2c')]['findOne']({'where':{'id':_0x584fe9['params']['id']}})[_0x1756('0x25')](handleEntityNotFound(_0x1ef490,null))[_0x1756('0x25')](function(_0x174dc7){if(_0x174dc7){return _0x174dc7[_0x1756('0x8d')](_0x584fe9[_0x1756('0x5b')][_0x1756('0x8e')]||[]);}return null;})[_0x1756('0x25')](respondWithResult(_0x1ef490,null))['catch'](handleError(_0x1ef490,null));};exports[_0x1756('0x8f')]=function(_0x92112e,_0x369a7b,_0x55b4c1){var _0x523cdf={'raw':![],'where':{}};var _0x132c6f={};var _0x5c4d19={'count':0x0,'rows':[]};return db[_0x1756('0x2c')][_0x1756('0x90')]({'where':{'id':_0x92112e[_0x1756('0x54')]['id']}})[_0x1756('0x25')](handleEntityNotFound(_0x369a7b,null))[_0x1756('0x25')](function(_0x403fcd){if(_0x403fcd){_0x132c6f[_0x1756('0x2d')]=_[_0x1756('0x31')](db[_0x1756('0x8a')][_0x1756('0x8c')]);_0x132c6f['query']=_[_0x1756('0x31')](_0x92112e[_0x1756('0x2e')]);_0x132c6f[_0x1756('0x32')]=_['intersection'](_0x132c6f[_0x1756('0x2d')],_0x132c6f[_0x1756('0x2e')]);_0x523cdf[_0x1756('0x34')]=_['intersection'](_0x132c6f[_0x1756('0x2d')],qs[_0x1756('0x35')](_0x92112e['query'][_0x1756('0x35')]));_0x523cdf['attributes']=_0x523cdf[_0x1756('0x34')][_0x1756('0x36')]?_0x523cdf[_0x1756('0x34')]:_0x132c6f['model'];if(!_0x92112e[_0x1756('0x2e')][_0x1756('0x37')]('nolimit')){_0x523cdf[_0x1756('0x39')]=qs[_0x1756('0x39')](_0x92112e['query']['limit']);_0x523cdf[_0x1756('0x1f')]=qs['offset'](_0x92112e[_0x1756('0x2e')][_0x1756('0x1f')]);}_0x523cdf[_0x1756('0x3a')]=qs[_0x1756('0x3b')](_0x92112e[_0x1756('0x2e')][_0x1756('0x3b')]);_0x523cdf[_0x1756('0x3c')]=qs[_0x1756('0x32')](_[_0x1756('0x3d')](_0x92112e[_0x1756('0x2e')],_0x132c6f[_0x1756('0x32')]));_0x523cdf['where'][_0x1756('0x91')]=_0x403fcd['id'];if(_0x92112e['query'][_0x1756('0x41')]){_0x523cdf[_0x1756('0x3c')]=_[_0x1756('0x40')](_0x523cdf['where'],{'$or':_[_0x1756('0x42')](_0x523cdf[_0x1756('0x34')],function(_0x57caa8){var _0x24094b={};_0x24094b[_0x57caa8]={'$like':'%'+_0x92112e[_0x1756('0x2e')][_0x1756('0x41')]+'%'};return _0x24094b;})});}_0x523cdf=_[_0x1756('0x40')]({},_0x523cdf,_0x92112e['options']);return db[_0x1756('0x8a')][_0x1756('0x4c')]({'where':_0x523cdf['where']})[_0x1756('0x25')](function(_0x10fd38){_0x5c4d19[_0x1756('0x4c')]=_0x10fd38;if(_0x92112e[_0x1756('0x2e')][_0x1756('0x4d')]){_0x523cdf['include']=[{'all':!![]}];}return db[_0x1756('0x8a')][_0x1756('0x51')](_0x523cdf);})[_0x1756('0x25')](function(_0x142d15){_0x5c4d19['rows']=_0x142d15;return _0x5c4d19;});}})[_0x1756('0x25')](respondWithFilteredResult(_0x369a7b,_0x523cdf))[_0x1756('0x53')](handleError(_0x369a7b,null));};exports[_0x1756('0x92')]=function(_0x28325b,_0x5e8e05,_0x355e2b){var _0x568a63={'raw':!![],'where':{}};var _0x55d3bf={};var _0x2db19f={'count':0x0,'rows':[]};return db[_0x1756('0x2c')]['findOne']({'where':{'id':_0x28325b[_0x1756('0x54')]['id']}})['then'](handleEntityNotFound(_0x5e8e05,null))[_0x1756('0x25')](function(_0x2a5a60){if(_0x2a5a60){_0x55d3bf[_0x1756('0x2d')]=_['keys'](db['CmHopperHistory'][_0x1756('0x8c')]);_0x55d3bf['query']=_[_0x1756('0x31')](_0x28325b[_0x1756('0x2e')]);_0x55d3bf[_0x1756('0x32')]=_['intersection'](_0x55d3bf[_0x1756('0x2d')],_0x55d3bf[_0x1756('0x2e')]);_0x568a63['attributes']=_[_0x1756('0x33')](_0x55d3bf[_0x1756('0x2d')],qs[_0x1756('0x35')](_0x28325b[_0x1756('0x2e')]['fields']));_0x568a63['attributes']=_0x568a63[_0x1756('0x34')][_0x1756('0x36')]?_0x568a63[_0x1756('0x34')]:_0x55d3bf[_0x1756('0x2d')];if(!_0x28325b[_0x1756('0x2e')][_0x1756('0x37')](_0x1756('0x38'))){_0x568a63[_0x1756('0x39')]=qs[_0x1756('0x39')](_0x28325b['query'][_0x1756('0x39')]);_0x568a63[_0x1756('0x1f')]=qs[_0x1756('0x1f')](_0x28325b['query']['offset']);}_0x568a63[_0x1756('0x3a')]=qs[_0x1756('0x3b')](_0x28325b[_0x1756('0x2e')]['sort']);_0x568a63[_0x1756('0x3c')]=qs['filters'](_[_0x1756('0x3d')](_0x28325b[_0x1756('0x2e')],_0x55d3bf[_0x1756('0x32')]));_0x568a63[_0x1756('0x3c')]['ContactId']=_0x2a5a60['id'];if(_0x28325b[_0x1756('0x2e')]['filter']){_0x568a63[_0x1756('0x3c')]=_[_0x1756('0x40')](_0x568a63[_0x1756('0x3c')],{'$or':_[_0x1756('0x42')](_0x568a63[_0x1756('0x34')],function(_0x13dfed){var _0x386066={};_0x386066[_0x13dfed]={'$like':'%'+_0x28325b[_0x1756('0x2e')]['filter']+'%'};return _0x386066;})});}_0x568a63=_[_0x1756('0x40')]({},_0x568a63,_0x28325b[_0x1756('0x46')]);return db[_0x1756('0x6f')][_0x1756('0x4c')]({'where':_0x568a63['where']})[_0x1756('0x25')](function(_0x5851f1){_0x2db19f[_0x1756('0x4c')]=_0x5851f1;if(_0x28325b[_0x1756('0x2e')][_0x1756('0x4d')]){_0x568a63[_0x1756('0x48')]=[{'all':!![]}];}return db['CmHopperHistory']['findAll'](_0x568a63);})[_0x1756('0x25')](function(_0x2c406a){_0x2db19f[_0x1756('0x52')]=_0x2c406a;return _0x2db19f;});}})[_0x1756('0x25')](respondWithFilteredResult(_0x5e8e05,_0x568a63))[_0x1756('0x53')](handleError(_0x5e8e05,null));};exports[_0x1756('0x93')]=function(_0x18c998,_0x577b70,_0x191279){var _0x2ee2f5={'raw':!![],'where':{}};var _0x17aaf6={};var _0x3c1edb={'count':0x0,'rows':[]};return db[_0x1756('0x2c')][_0x1756('0x90')]({'where':{'id':_0x18c998['params']['id']}})[_0x1756('0x25')](handleEntityNotFound(_0x577b70,null))[_0x1756('0x25')](function(_0x3a1f0b){if(_0x3a1f0b){_0x17aaf6[_0x1756('0x2d')]=_['keys'](db[_0x1756('0x6e')]['rawAttributes']);_0x17aaf6[_0x1756('0x2e')]=_[_0x1756('0x31')](_0x18c998[_0x1756('0x2e')]);_0x17aaf6[_0x1756('0x32')]=_[_0x1756('0x33')](_0x17aaf6[_0x1756('0x2d')],_0x17aaf6[_0x1756('0x2e')]);_0x2ee2f5[_0x1756('0x34')]=_[_0x1756('0x33')](_0x17aaf6[_0x1756('0x2d')],qs[_0x1756('0x35')](_0x18c998[_0x1756('0x2e')][_0x1756('0x35')]));_0x2ee2f5[_0x1756('0x34')]=_0x2ee2f5['attributes'][_0x1756('0x36')]?_0x2ee2f5[_0x1756('0x34')]:_0x17aaf6[_0x1756('0x2d')];if(!_0x18c998[_0x1756('0x2e')][_0x1756('0x37')](_0x1756('0x38'))){_0x2ee2f5[_0x1756('0x39')]=qs['limit'](_0x18c998[_0x1756('0x2e')]['limit']);_0x2ee2f5[_0x1756('0x1f')]=qs[_0x1756('0x1f')](_0x18c998[_0x1756('0x2e')][_0x1756('0x1f')]);}_0x2ee2f5[_0x1756('0x3a')]=qs['sort'](_0x18c998['query'][_0x1756('0x3b')]);_0x2ee2f5[_0x1756('0x3c')]=qs[_0x1756('0x32')](_[_0x1756('0x3d')](_0x18c998[_0x1756('0x2e')],_0x17aaf6[_0x1756('0x32')]));_0x2ee2f5[_0x1756('0x3c')][_0x1756('0x91')]=_0x3a1f0b['id'];if(_0x18c998['query'][_0x1756('0x41')]){_0x2ee2f5[_0x1756('0x3c')]=_[_0x1756('0x40')](_0x2ee2f5[_0x1756('0x3c')],{'$or':_['map'](_0x2ee2f5[_0x1756('0x34')],function(_0x426879){var _0x9d08f2={};_0x9d08f2[_0x426879]={'$like':'%'+_0x18c998[_0x1756('0x2e')][_0x1756('0x41')]+'%'};return _0x9d08f2;})});}_0x2ee2f5=_['merge']({},_0x2ee2f5,_0x18c998[_0x1756('0x46')]);return db[_0x1756('0x6e')][_0x1756('0x4c')]({'where':_0x2ee2f5['where']})[_0x1756('0x25')](function(_0x559e14){_0x3c1edb[_0x1756('0x4c')]=_0x559e14;if(_0x18c998['query'][_0x1756('0x4d')]){_0x2ee2f5[_0x1756('0x48')]=[{'all':!![]}];}return db[_0x1756('0x6e')][_0x1756('0x51')](_0x2ee2f5);})[_0x1756('0x25')](function(_0x5da0db){_0x3c1edb[_0x1756('0x52')]=_0x5da0db;return _0x3c1edb;});}})[_0x1756('0x25')](respondWithFilteredResult(_0x577b70,_0x2ee2f5))['catch'](handleError(_0x577b70,null));};exports[_0x1756('0x94')]=function(_0x49d55a,_0x53dbd2,_0x1ef67c){var _0x1c53c4={'raw':!![],'where':{}};var _0x3a1fcf={};var _0xec8f7d={'count':0x0,'rows':[]};return db[_0x1756('0x2c')][_0x1756('0x90')]({'where':{'id':_0x49d55a['params']['id']}})[_0x1756('0x25')](handleEntityNotFound(_0x53dbd2,null))['then'](function(_0x4882ca){if(_0x4882ca){_0x3a1fcf[_0x1756('0x2d')]=_[_0x1756('0x31')](db[_0x1756('0x76')]['rawAttributes']);_0x3a1fcf[_0x1756('0x2e')]=_[_0x1756('0x31')](_0x49d55a[_0x1756('0x2e')]);_0x3a1fcf[_0x1756('0x32')]=_[_0x1756('0x33')](_0x3a1fcf['model'],_0x3a1fcf[_0x1756('0x2e')]);_0x1c53c4[_0x1756('0x34')]=_[_0x1756('0x33')](_0x3a1fcf['model'],qs[_0x1756('0x35')](_0x49d55a['query'][_0x1756('0x35')]));_0x1c53c4['attributes']=_0x1c53c4[_0x1756('0x34')][_0x1756('0x36')]?_0x1c53c4[_0x1756('0x34')]:_0x3a1fcf[_0x1756('0x2d')];if(!_0x49d55a[_0x1756('0x2e')][_0x1756('0x37')](_0x1756('0x38'))){_0x1c53c4[_0x1756('0x39')]=qs[_0x1756('0x39')](_0x49d55a[_0x1756('0x2e')][_0x1756('0x39')]);_0x1c53c4['offset']=qs[_0x1756('0x1f')](_0x49d55a[_0x1756('0x2e')][_0x1756('0x1f')]);}_0x1c53c4[_0x1756('0x3a')]=qs[_0x1756('0x3b')](_0x49d55a[_0x1756('0x2e')][_0x1756('0x3b')]);_0x1c53c4[_0x1756('0x3c')]=qs['filters'](_[_0x1756('0x3d')](_0x49d55a[_0x1756('0x2e')],_0x3a1fcf[_0x1756('0x32')]));_0x1c53c4[_0x1756('0x3c')][_0x1756('0x91')]=_0x4882ca['id'];if(_0x49d55a[_0x1756('0x2e')][_0x1756('0x41')]){_0x1c53c4[_0x1756('0x3c')]=_[_0x1756('0x40')](_0x1c53c4[_0x1756('0x3c')],{'$or':_[_0x1756('0x42')](_0x1c53c4[_0x1756('0x34')],function(_0x2d78fe){var _0x54a964={};_0x54a964[_0x2d78fe]={'$like':'%'+_0x49d55a[_0x1756('0x2e')]['filter']+'%'};return _0x54a964;})});}_0x1c53c4=_[_0x1756('0x40')]({},_0x1c53c4,_0x49d55a['options']);return db[_0x1756('0x76')][_0x1756('0x4c')]({'where':_0x1c53c4[_0x1756('0x3c')]})[_0x1756('0x25')](function(_0x1e1ef2){_0xec8f7d[_0x1756('0x4c')]=_0x1e1ef2;if(_0x49d55a[_0x1756('0x2e')]['includeAll']){_0x1c53c4[_0x1756('0x48')]=[{'all':!![]}];}return db['JscriptySessionReport']['findAll'](_0x1c53c4);})[_0x1756('0x25')](function(_0x3686d4){_0xec8f7d['rows']=_0x3686d4;return _0xec8f7d;});}})[_0x1756('0x25')](respondWithFilteredResult(_0x53dbd2,_0x1c53c4))[_0x1756('0x53')](handleError(_0x53dbd2,null));};exports['uploadCsv']=function(_0xf00866,_0x400d19,_0x12cff3){try{if(!_0xf00866[_0x1756('0x5b')][_0x1756('0x7c')]){throw new Error(_0x1756('0x95'));}if(!_0xf00866[_0x1756('0x5b')][_0x1756('0x96')]){throw new Error(_0x1756('0x97'));}if(!_0xf00866['body'][_0x1756('0x98')]){throw new Error(_0x1756('0x99'));}if(!_0xf00866['body'][_0x1756('0x9a')]){throw new Error(_0x1756('0x9b'));}var _0x5578aa=_0xf00866[_0x1756('0x5b')][_0x1756('0x96')]['split'](',');var _0x2fd93c=_0xf00866[_0x1756('0x5b')][_0x1756('0x98')][_0x1756('0x9c')](',');if(!_0x5578aa[_0x1756('0x36')]||!_0x2fd93c['length']||_0x5578aa[_0x1756('0x36')]!==_0x2fd93c[_0x1756('0x36')]){throw new Error(_0x1756('0x9d'));}_0xf00866[_0x1756('0x5b')]['fields']=_[_0x1756('0x9e')](_0x5578aa,_0x2fd93c);if(!_0xf00866[_0x1756('0x5b')][_0x1756('0x35')][_0x1756('0x89')]){throw new Error(_0x1756('0x9f'));}if(!_0xf00866[_0x1756('0x5b')][_0x1756('0x35')][_0x1756('0xa0')]){throw new Error(_0x1756('0xa1'));}var _0x5692de=path[_0x1756('0xa2')](config[_0x1756('0xa3')],'server/files/tmp',_0xf00866[_0x1756('0xa4')][_0x1756('0xa5')]);fs[_0x1756('0xa6')](_0x5692de,parseInt('0777',0x8));var _0x2aaf8d=require(_0x1756('0xa7'))[_0x1756('0xa8')](path[_0x1756('0xa2')](__dirname,_0x1756('0xa9')),[_0x5692de,_0xf00866[_0x1756('0x5b')][_0x1756('0x96')],_0xf00866[_0x1756('0x5b')][_0x1756('0x98')],_0xf00866[_0x1756('0x5b')][_0x1756('0x7c')],_0xf00866[_0x1756('0x5b')][_0x1756('0xaa')],_0xf00866[_0x1756('0x5b')][_0x1756('0x7a')],_0xf00866['body'][_0x1756('0x9a')]]);return _0x400d19[_0x1756('0x1c')](0xc8)[_0x1756('0x1e')]({'message':_0x1756('0xab'),'pid':_0x2aaf8d[_0x1756('0xac')]});}catch(_0x35ea47){return _0x400d19[_0x1756('0x1c')](0x1f4)[_0x1756('0x2a')](_0x35ea47);}};exports[_0x1756('0xad')]=function(_0x40c494,_0xf7d7e4,_0x5caca2){var _0x323fec=fs[_0x1756('0xae')](_0x40c494[_0x1756('0xa4')][_0x1756('0xaf')]);Papa[_0x1756('0xb0')](_0x323fec,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x5b9f8a){return _0xf7d7e4[_0x1756('0x1c')](0xc8)[_0x1756('0x1e')]({'file':_0x40c494[_0x1756('0xa4')],'fields':_0x5b9f8a['meta'][_0x1756('0x35')]});}});};exports[_0x1756('0xb1')]=function(_0x350c0f,_0x379d51,_0x3237e9){return db[_0x1756('0xb2')][_0x1756('0x51')]({'raw':!![],'attributes':['id'],'where':{'role':_0x1756('0xb3')}})[_0x1756('0x25')](function(_0x11f7fe){var _0x13fb0b=![];if(!_0x350c0f[_0x1756('0x5b')][_0x1756('0x7c')]){throw new Error(_0x1756('0x95'));}if(!_0x350c0f[_0x1756('0x5b')][_0x1756('0xb4')][_0x1756('0x89')]){throw new Error(_0x1756('0x9f'));}if(!_0x350c0f[_0x1756('0x5b')][_0x1756('0xb4')][_0x1756('0xa0')]){throw new Error(_0x1756('0xa1'));}if(!_0x350c0f[_0x1756('0x5b')][_0x1756('0x9a')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x5a0931=require(_0x1756('0xa7'))[_0x1756('0xa8')](path[_0x1756('0xa2')](__dirname,_0x1756('0xb5')),[_0x350c0f[_0x1756('0x54')]['id'],JSON['stringify'](_0x350c0f[_0x1756('0x5b')]),JSON[_0x1756('0xb6')](_0x11f7fe)]);_0x5a0931['on'](_0x1756('0xb7'),function(_0x460934){_0x13fb0b=!![];return _0x379d51[_0x1756('0x1c')](0xc8)['json']({'message':_0x1756('0xb8'),'pid':_0x5a0931[_0x1756('0xac')]});});_0x5a0931['on'](_0x1756('0xb9'),function(_0x354257){if(_0x354257&&!_0x13fb0b){return _0x379d51[_0x1756('0x1c')](0x1f4)[_0x1756('0x1e')]({'message':_0x1756('0xba'),'pid':_0x5a0931[_0x1756('0xac')]});}});})[_0x1756('0x53')](handleError(_0x379d51,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff