// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x4ccc=['info','[CmContact][merge][destroy][CmHopper],\x20%s','[CmContact][merge][destroy][CmHopperBlack],\x20%s','ChatInteraction','ChatMessage','update','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxMessage','OpenchannelInteraction','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','create','bulkCreate','each','duplicates','$or','findOrCreate','spread','show','ListId','$and','omit','map','pickBy','format','cf_%d','isEmpty','table','cm_contacts','id\x20=\x20?','sequelize','text','values','phone','CmHopper','getTags','findOne','rawAttributes','setTags','ids','ContactId','getJscriptySessions','No\x20ListId\x20specified','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_keys','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20firstName\x20column\x20specified','root','file','filename','0777','child_process','fork','CompanyId','File\x20uploaded\x20correctly!','pid','send','upload','createReadStream','parse','meta','import','User','agent','No\x20phone\x20column\x20specified','firstName','stringify','message','start\x20child\x20process\x20correctly!','error\x20child\x20process','html-pdf','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','squel','crypto','jsforce','querystring','papaparse','../../components/auth/service','../../config/license/hardware','../../components/parsers/qs','../../config/logger','api','defaults','localhost','socket.io-emitter','redis','./cmContact.socket','register','sendStatus','status','json','count','offset','Content-Range','reject','save','then','error','stack','name','model','keys','query','filters','intersection','fields','attributes','hasOwnProperty','nolimit','limit','order','sort','where','pick','filter','merge','options','include','tag','push','Tag','distinct','CmContact','includeAll','Tags','ThroughTags','color','findAll','rows','catch','destroy','find','params','describe','length','startsWith','cf_','displayName','CmCustomField','columnName','alias','body','from','get','mergeWith','isArray','tags','join'];(function(_0x45c0ce,_0x299fa9){var _0x16304f=function(_0x45224b){while(--_0x45224b){_0x45c0ce['push'](_0x45c0ce['shift']());}};_0x16304f(++_0x299fa9);}(_0x4ccc,0x107));var _0xc4cc=function(_0x449385,_0x5beeb1){_0x449385=_0x449385-0x0;var _0x2b10d7=_0x4ccc[_0x449385];return _0x2b10d7;};'use strict';var pdf=require(_0xc4cc('0x0'));var emlformat=require(_0xc4cc('0x1'));var rimraf=require(_0xc4cc('0x2'));var zipdir=require(_0xc4cc('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0xc4cc('0x4'));var moment=require(_0xc4cc('0x5'));var BPromise=require(_0xc4cc('0x6'));var Mustache=require(_0xc4cc('0x7'));var util=require(_0xc4cc('0x8'));var path=require(_0xc4cc('0x9'));var sox=require(_0xc4cc('0xa'));var csv=require(_0xc4cc('0xb'));var ejs=require(_0xc4cc('0xc'));var fs=require('fs');var _=require('lodash');var squel=require(_0xc4cc('0xd'));var crypto=require(_0xc4cc('0xe'));var jsforce=require(_0xc4cc('0xf'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0xc4cc('0x10'));var Papa=require(_0xc4cc('0x11'));var authService=require(_0xc4cc('0x12'));var hardwareService=require(_0xc4cc('0x13'));var Redis=require('ioredis');var qs=require(_0xc4cc('0x14'));var logger=require(_0xc4cc('0x15'))(_0xc4cc('0x16'));var utils=require('../../config/utils');var config=require('../../config/environment');var db=require('../../mysqldb')['db'];config['redis']=_[_0xc4cc('0x17')](config['redis'],{'host':_0xc4cc('0x18'),'port':0x18eb});var socket=require(_0xc4cc('0x19'))(new Redis(config[_0xc4cc('0x1a')]));require(_0xc4cc('0x1b'))[_0xc4cc('0x1c')](socket);function respondWithStatusCode(_0x3a52bd,_0x4571b9){_0x4571b9=_0x4571b9||0xcc;return function(_0x19acbd){if(_0x19acbd){return _0x3a52bd[_0xc4cc('0x1d')](_0x4571b9);}return _0x3a52bd[_0xc4cc('0x1e')](_0x4571b9)['end']();};}function respondWithResult(_0x14723c,_0x3c2814){_0x3c2814=_0x3c2814||0xc8;return function(_0x14b249){if(_0x14b249){return _0x14723c['status'](_0x3c2814)[_0xc4cc('0x1f')](_0x14b249);}};}function respondWithFilteredResult(_0x26169c,_0x45782c){return function(_0x39122f){if(_0x39122f){var _0x4b853a=_0x39122f[_0xc4cc('0x20')],_0x552250=_0x45782c['offset'],_0xab9193=_0x45782c[_0xc4cc('0x21')]+_0x45782c['limit'],_0x288fdd;if(_0xab9193>=_0x4b853a){_0xab9193=_0x4b853a;_0x288fdd=0xc8;}else{_0x288fdd=0xce;}_0x26169c[_0xc4cc('0x1e')](_0x288fdd);return _0x26169c['set'](_0xc4cc('0x22'),_0x552250+'-'+_0xab9193+'/'+_0x4b853a)[_0xc4cc('0x1f')](_0x39122f);}return null;};}function patchUpdates(_0x22eff3){return function(_0x4816ae){try{jsonpatch['apply'](_0x4816ae,_0x22eff3,!![]);}catch(_0x2ca72f){return BPromise[_0xc4cc('0x23')](_0x2ca72f);}return _0x4816ae[_0xc4cc('0x24')]();};}function saveUpdates(_0x3a5f29,_0x5a06b6){return function(_0x1e2bf7){if(_0x1e2bf7){return _0x1e2bf7['update'](_0x3a5f29)['then'](function(_0x3bb406){return _0x3bb406;});}return null;};}function removeEntity(_0x142280,_0x2b97c0){return function(_0x33daa5){if(_0x33daa5){return _0x33daa5['destroy']()[_0xc4cc('0x25')](function(){_0x142280[_0xc4cc('0x1e')](0xcc)['end']();});}};}function handleEntityNotFound(_0x11db33,_0xd736b9){return function(_0x186066){if(!_0x186066){_0x11db33['sendStatus'](0x194);}return _0x186066;};}function handleError(_0x9f1d11,_0x39d834){_0x39d834=_0x39d834||0x1f4;return function(_0x2e7372){logger[_0xc4cc('0x26')](_0x2e7372[_0xc4cc('0x27')]);if(_0x2e7372['name']){delete _0x2e7372[_0xc4cc('0x28')];}_0x9f1d11[_0xc4cc('0x1e')](_0x39d834)['send'](_0x2e7372);};}exports['index']=function(_0x7e7aad,_0x23ddb2){var _0x330298={},_0x1dd8eb={},_0x1e529a={'count':0x0,'rows':[]};return db['CmContact']['describe']()['then'](function(_0x565ef2){_0x1dd8eb[_0xc4cc('0x29')]=_[_0xc4cc('0x2a')](_0x565ef2);_0x1dd8eb[_0xc4cc('0x2b')]=_[_0xc4cc('0x2a')](_0x7e7aad[_0xc4cc('0x2b')]);_0x1dd8eb[_0xc4cc('0x2c')]=_[_0xc4cc('0x2d')](_0x1dd8eb['model'],_0x1dd8eb['query']);_0x330298['attributes']=_[_0xc4cc('0x2d')](_0x1dd8eb[_0xc4cc('0x29')],qs[_0xc4cc('0x2e')](_0x7e7aad[_0xc4cc('0x2b')][_0xc4cc('0x2e')]));_0x330298[_0xc4cc('0x2f')]=_0x330298['attributes']['length']?_0x330298['attributes']:_0x1dd8eb[_0xc4cc('0x29')];if(!_0x7e7aad[_0xc4cc('0x2b')][_0xc4cc('0x30')](_0xc4cc('0x31'))){_0x330298[_0xc4cc('0x32')]=qs[_0xc4cc('0x32')](_0x7e7aad[_0xc4cc('0x2b')][_0xc4cc('0x32')]);_0x330298[_0xc4cc('0x21')]=qs[_0xc4cc('0x21')](_0x7e7aad['query'][_0xc4cc('0x21')]);}_0x330298[_0xc4cc('0x33')]=qs['sort'](_0x7e7aad[_0xc4cc('0x2b')][_0xc4cc('0x34')]);_0x330298[_0xc4cc('0x35')]=qs[_0xc4cc('0x2c')](_[_0xc4cc('0x36')](_0x7e7aad[_0xc4cc('0x2b')],_0x1dd8eb[_0xc4cc('0x2c')]));if(_0x7e7aad[_0xc4cc('0x2b')][_0xc4cc('0x37')]){_0x330298[_0xc4cc('0x35')]=_[_0xc4cc('0x38')](_0x330298[_0xc4cc('0x35')],{'$or':_['map'](_0x330298['attributes'],function(_0x4bcaf0){var _0x297dca={};_0x297dca[_0x4bcaf0]={'$like':'%'+_0x7e7aad[_0xc4cc('0x2b')][_0xc4cc('0x37')]+'%'};return _0x297dca;})});}_0x330298=_[_0xc4cc('0x38')]({},_0x330298,_0x7e7aad[_0xc4cc('0x39')]);var _0x4a879b={'where':_0x330298['where']};_0x4a879b[_0xc4cc('0x3a')]=[];if(_0x7e7aad[_0xc4cc('0x2b')][_0xc4cc('0x3b')]){_0x4a879b[_0xc4cc('0x3a')][_0xc4cc('0x3c')]({'model':db[_0xc4cc('0x3d')],'as':'Tags','attributes':['id'],'where':{'id':_0x7e7aad['query'][_0xc4cc('0x3b')]},'required':!![]});_0x4a879b[_0xc4cc('0x3e')]=!![];}return db[_0xc4cc('0x3f')]['count'](_0x4a879b)[_0xc4cc('0x25')](function(_0x4c5a33){_0x1e529a[_0xc4cc('0x20')]=_0x4c5a33;if(_0x7e7aad[_0xc4cc('0x2b')][_0xc4cc('0x40')]){_0x330298['include']=[{'model':db[_0xc4cc('0x3d')],'as':_0xc4cc('0x41'),'attributes':['id','name','color'],'required':_0x7e7aad[_0xc4cc('0x2b')][_0xc4cc('0x3b')]?!![]:![]},{'model':db['Tag'],'as':_0xc4cc('0x42'),'attributes':['id',_0xc4cc('0x28'),_0xc4cc('0x43')],'through':_0x7e7aad[_0xc4cc('0x2b')]['tag']?{'attributes':[],'where':{'TagId':_0x7e7aad[_0xc4cc('0x2b')][_0xc4cc('0x3b')]||undefined}}:{},'required':_0x7e7aad[_0xc4cc('0x2b')][_0xc4cc('0x3b')]?!![]:![]}];}return db[_0xc4cc('0x3f')][_0xc4cc('0x44')](_0x330298);})[_0xc4cc('0x25')](function(_0x4f67b3){_0x1e529a[_0xc4cc('0x45')]=_0x4f67b3;return _0x1e529a;})[_0xc4cc('0x25')](respondWithFilteredResult(_0x23ddb2,_0x330298))[_0xc4cc('0x46')](handleError(_0x23ddb2,null));});};exports[_0xc4cc('0x47')]=function(_0x1b2883,_0x5674cd){return db[_0xc4cc('0x3f')][_0xc4cc('0x48')]({'where':{'id':_0x1b2883[_0xc4cc('0x49')]['id']}})['then'](handleEntityNotFound(_0x5674cd,null))[_0xc4cc('0x25')](removeEntity(_0x5674cd,null))[_0xc4cc('0x46')](handleError(_0x5674cd,null));};exports[_0xc4cc('0x4a')]=function(_0x638b2d,_0x4f1ed9){return db[_0xc4cc('0x3f')][_0xc4cc('0x4a')]()['then'](function(_0x317434){for(var _0x121483=0x0;_0x121483<Object[_0xc4cc('0x2a')](_0x317434)[_0xc4cc('0x4b')];_0x121483++){var _0xeb1569=Object[_0xc4cc('0x2a')](_0x317434)[_0x121483];if(!_[_0xc4cc('0x4c')](_0xeb1569,_0xc4cc('0x4d'))){_0x317434[_0xeb1569]['columnName']=_0xeb1569;_0x317434[_0xeb1569][_0xc4cc('0x4e')]=_0xeb1569;}}return _0x317434;})[_0xc4cc('0x25')](function(_0x1cbcc3){var _0x1f5364={'where':{'$or':[{'ListId':_0x638b2d['query']['id']},{'ListId':null}]},'raw':!![]};return db[_0xc4cc('0x4f')]['findAll'](_0x1f5364)['then'](function(_0x5f405e){for(var _0x42eda4=0x0;_0x42eda4<_0x5f405e[_0xc4cc('0x4b')];_0x42eda4++){var _0x5b990e=_0xc4cc('0x4d')+_0x5f405e[_0x42eda4]['id'];_0x1cbcc3[_0x5b990e][_0xc4cc('0x50')]=_0x5b990e;_0x1cbcc3[_0x5b990e][_0xc4cc('0x4e')]=_0x5f405e[_0x42eda4][_0xc4cc('0x51')];}for(var _0x42eda4=0x0;_0x42eda4<Object[_0xc4cc('0x2a')](_0x1cbcc3)['length'];_0x42eda4++){var _0x5b990e=Object['keys'](_0x1cbcc3)[_0x42eda4];if(!_0x1cbcc3[_0x5b990e]['hasOwnProperty'](_0xc4cc('0x50'))){delete _0x1cbcc3[_0x5b990e];}}return _0x1cbcc3;});})[_0xc4cc('0x25')](respondWithResult(_0x4f1ed9,null))[_0xc4cc('0x46')](handleError(_0x4f1ed9,null));};exports[_0xc4cc('0x38')]=function(_0x5219b1,_0xe9cbab){var _0x1e81f9;var _0x727974;var _0x274ad6;if(_0x5219b1[_0xc4cc('0x52')]['id']){delete _0x5219b1[_0xc4cc('0x52')]['id'];}return db[_0xc4cc('0x3f')][_0xc4cc('0x44')]({'where':{'id':[_0x5219b1['body']['to'],_0x5219b1[_0xc4cc('0x52')][_0xc4cc('0x53')]]}})['then'](function(_0x48a3d2){if(_0x48a3d2){if(_0x48a3d2[_0xc4cc('0x4b')]!==0x2){return null;}_0x48a3d2[0x0]=_0x48a3d2[0x0][_0xc4cc('0x54')]({'plain':!![]});_0x48a3d2[0x1]=_0x48a3d2[0x1][_0xc4cc('0x54')]({'plain':!![]});delete _0x48a3d2[0x0]['id'];delete _0x48a3d2[0x1]['id'];return _[_0xc4cc('0x55')](_0x48a3d2[0x0],_0x48a3d2[0x1],function(_0x350150,_0x869730){if(Array[_0xc4cc('0x56')](_0x869730)&&!_0x869730[_0xc4cc('0x4b')]){return _0x350150;}else if(!_0x869730){return _0x350150;}});}})[_0xc4cc('0x25')](handleEntityNotFound(_0xe9cbab,null))['then'](function(_0x274bfe){if(_0x274bfe){if(_0x274bfe[_0xc4cc('0x57')]&&_[_0xc4cc('0x56')](_0x274bfe[_0xc4cc('0x57')])){_0x274bfe[_0xc4cc('0x57')]=_0x274bfe[_0xc4cc('0x57')][_0xc4cc('0x58')]();}logger[_0xc4cc('0x59')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x5219b1[_0xc4cc('0x52')]['to'],_0x5219b1[_0xc4cc('0x52')][_0xc4cc('0x53')]);return db['CmHopper']['destroy']({'where':{'ContactId':[_0x5219b1[_0xc4cc('0x52')]['to'],_0x5219b1[_0xc4cc('0x52')]['from']]}})[_0xc4cc('0x25')](function(_0x4d3920){logger[_0xc4cc('0x59')](_0xc4cc('0x5a'),_0x4d3920);return db['CmHopperBlack'][_0xc4cc('0x47')]({'where':{'ContactId':[_0x5219b1['body']['to'],_0x5219b1[_0xc4cc('0x52')]['from']]}})['then'](function(_0x3e785c){logger[_0xc4cc('0x59')](_0xc4cc('0x5b'),_0x3e785c);return db[_0xc4cc('0x3f')]['create'](_0x274bfe);});});}})['then'](function(_0x1a1820){if(_0x1a1820){_0x1e81f9=_0x1a1820;_0x727974={'ContactId':_0x1e81f9['id']};_0x274ad6={'where':{'ContactId':[_0x5219b1[_0xc4cc('0x52')]['to'],_0x5219b1[_0xc4cc('0x52')][_0xc4cc('0x53')]]}};return db[_0xc4cc('0x5c')]['update'](_0x727974,_0x274ad6);}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return db[_0xc4cc('0x5d')][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return db[_0xc4cc('0x5f')][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})['then'](function(){if(_0x1e81f9){return db[_0xc4cc('0x60')][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})['then'](function(){if(_0x1e81f9){return db[_0xc4cc('0x61')][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return db['MailInteraction'][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return db['MailMessage'][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})['then'](function(){if(_0x1e81f9){return db[_0xc4cc('0x62')][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return db[_0xc4cc('0x63')][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})['then'](function(){if(_0x1e81f9){return db['FaxInteraction'][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})['then'](function(){if(_0x1e81f9){return db[_0xc4cc('0x64')][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return db[_0xc4cc('0x65')][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return db['OpenchannelMessage'][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return db[_0xc4cc('0x66')][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return db[_0xc4cc('0x67')][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return db[_0xc4cc('0x68')][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return db[_0xc4cc('0x69')][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})['then'](function(){if(_0x1e81f9){return db[_0xc4cc('0x6a')][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return db[_0xc4cc('0x6b')]['update'](_0x727974,_0x274ad6);}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return db[_0xc4cc('0x6c')]['update'](_0x727974,_0x274ad6);}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return db[_0xc4cc('0x6d')][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return db[_0xc4cc('0x6e')][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return db[_0xc4cc('0x6f')][_0xc4cc('0x5e')](_0x727974,_0x274ad6);}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return db[_0xc4cc('0x3f')][_0xc4cc('0x47')]({'where':{'id':[_0x5219b1[_0xc4cc('0x52')]['to'],_0x5219b1[_0xc4cc('0x52')][_0xc4cc('0x53')]]}});}})[_0xc4cc('0x25')](function(){if(_0x1e81f9){return _0x1e81f9;}})[_0xc4cc('0x25')](respondWithResult(_0xe9cbab,null))[_0xc4cc('0x46')](handleError(_0xe9cbab,null));};exports['create']=function(_0x393774,_0x253f19){return db[_0xc4cc('0x3f')][_0xc4cc('0x4a')]()[_0xc4cc('0x25')](function(_0x5628f4){if(_0x393774[_0xc4cc('0x52')][_0xc4cc('0x57')]&&_[_0xc4cc('0x56')](_0x393774[_0xc4cc('0x52')][_0xc4cc('0x57')])){if(_0x393774[_0xc4cc('0x52')][_0xc4cc('0x57')][_0xc4cc('0x4b')]){_0x393774[_0xc4cc('0x52')][_0xc4cc('0x57')]=_0x393774[_0xc4cc('0x52')][_0xc4cc('0x57')][_0xc4cc('0x58')](';')+';';}else{_0x393774[_0xc4cc('0x52')][_0xc4cc('0x57')]=null;}}else{_0x393774[_0xc4cc('0x52')][_0xc4cc('0x57')]=null;}return db[_0xc4cc('0x3f')][_0xc4cc('0x70')](_0x393774[_0xc4cc('0x52')],{'fields':_['keys'](_0x5628f4),'raw':!![]});})[_0xc4cc('0x25')](respondWithResult(_0x253f19,0xc9))['catch'](handleError(_0x253f19,null));};exports[_0xc4cc('0x71')]=function(_0x79011f,_0x151555){var _0x1b221f=[];var _0x22c954=0x0;var _0x190cb7=0x0;var _0x1cdaa7=0x0;return db['CmContact'][_0xc4cc('0x4a')]()[_0xc4cc('0x25')](function(_0x4d066c){return BPromise[_0xc4cc('0x72')](_0x79011f[_0xc4cc('0x52')],function(_0x33147f){var _0x5871f0={'where':{'$or':[]},'defaults':_0x33147f,'fields':_[_0xc4cc('0x2a')](_0x4d066c),'raw':!![]};if(_0x33147f[_0xc4cc('0x73')]){for(var _0x395608=0x0;_0x395608<_0x33147f[_0xc4cc('0x73')][_0xc4cc('0x4b')];_0x395608++){var _0x575ea4={};_0x575ea4[_0x33147f[_0xc4cc('0x73')][_0x395608]]=_0x33147f[_0x33147f['duplicates'][_0x395608]];_0x5871f0['where'][_0xc4cc('0x74')][_0xc4cc('0x3c')](_0x575ea4);}_0x5871f0[_0xc4cc('0x35')]['ListId']=_0x33147f['ListId'];}return db[_0xc4cc('0x3f')][_0xc4cc('0x75')](_0x5871f0)[_0xc4cc('0x76')](function(_0x5e64b0,_0x177725){if(_0x177725){_0x22c954++;}else{_0x1cdaa7++;}})[_0xc4cc('0x46')](function(_0x2eb004){console['error'](_0x2eb004);_0x190cb7++;});});})[_0xc4cc('0x25')](function(_0x4587a5){if(_0x4587a5){return{'success':_0x22c954,'failure':_0x190cb7,'duplicates':_0x1cdaa7};}})[_0xc4cc('0x25')](respondWithResult(_0x151555,0xc9))[_0xc4cc('0x46')](handleError(_0x151555,null));};exports[_0xc4cc('0x77')]=function(_0x494fa8,_0x2045c7,_0x4c4fb8){var _0x14418a;return db[_0xc4cc('0x3f')][_0xc4cc('0x4a')]()[_0xc4cc('0x25')](function(_0x2d66b9){return db['CmContact'][_0xc4cc('0x48')]({'where':{'id':_0x494fa8[_0xc4cc('0x49')]['id']},'include':[{'model':db['Tag'],'as':_0xc4cc('0x41'),'attributes':['id','name',_0xc4cc('0x43')],'required':_0x494fa8['query'][_0xc4cc('0x3b')]?!![]:![]}],'attributes':_[_0xc4cc('0x2a')](_0x2d66b9)});})[_0xc4cc('0x25')](function(_0x56aa65){_0x14418a=_0x56aa65[_0xc4cc('0x54')]({'plain':!![]});var _0x3ff3bb={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x56aa65&&_0x56aa65[_0xc4cc('0x78')]){if(_0x56aa65['ListId']){_0x3ff3bb['where'][_0xc4cc('0x79')][_0xc4cc('0x3c')]({'ListId':{'$ne':_0x56aa65[_0xc4cc('0x78')]}});}}return db[_0xc4cc('0x4f')][_0xc4cc('0x44')](_0x3ff3bb);})[_0xc4cc('0x25')](function(_0x39d194){return _[_0xc4cc('0x7a')](_0x14418a,_[_0xc4cc('0x7b')](_0x39d194,function(_0x2b0e6a){return util['format']('cf_%d',_0x2b0e6a['id']);}));})[_0xc4cc('0x25')](handleEntityNotFound(_0x2045c7,null))[_0xc4cc('0x25')](respondWithResult(_0x2045c7,null))[_0xc4cc('0x46')](handleError(_0x2045c7,null));};exports[_0xc4cc('0x5e')]=function(_0x3e4a1a,_0x7b22c3){var _0x27a49e;if(_0x3e4a1a[_0xc4cc('0x52')]['id']){delete _0x3e4a1a[_0xc4cc('0x52')]['id'];}return db[_0xc4cc('0x3f')]['find']({'where':{'id':_0x3e4a1a['params']['id']}})[_0xc4cc('0x25')](handleEntityNotFound(_0x7b22c3,null))[_0xc4cc('0x25')](saveUpdates(_0x3e4a1a[_0xc4cc('0x52')],null))['then'](function(_0x15908f){_0x27a49e=_0x15908f;var _0x5d1ad8={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x15908f&&_0x15908f[_0xc4cc('0x78')]){if(_0x15908f['ListId']){_0x5d1ad8['where']['$and'][_0xc4cc('0x3c')]({'ListId':{'$ne':_0x15908f[_0xc4cc('0x78')]}});}}return db[_0xc4cc('0x4f')][_0xc4cc('0x44')](_0x5d1ad8);})['then'](function(_0x261bef){if(_0x261bef){return _[_0xc4cc('0x7a')](_[_0xc4cc('0x7c')](_0x3e4a1a['body'],function(_0x54ad36,_0x183236){return _[_0xc4cc('0x4c')](_0x183236,'cf_');}),_[_0xc4cc('0x7b')](_0x261bef,function(_0x36a8c1){return util[_0xc4cc('0x7d')](_0xc4cc('0x7e'),_0x36a8c1['id']);}));}})[_0xc4cc('0x25')](function(_0x1d8e37){if(_0x1d8e37&&!_[_0xc4cc('0x7f')](_0x1d8e37)){var _0x346dc1=squel[_0xc4cc('0x5e')]()[_0xc4cc('0x80')](_0xc4cc('0x81'))['setFields'](_0x1d8e37)[_0xc4cc('0x35')](_0xc4cc('0x82'),_0x3e4a1a[_0xc4cc('0x49')]['id'])['toParam']();return db[_0xc4cc('0x83')][_0xc4cc('0x2b')](_0x346dc1[_0xc4cc('0x84')],{'replacements':_0x346dc1[_0xc4cc('0x85')]});}})[_0xc4cc('0x25')](function(){if(_0x3e4a1a['body'][_0xc4cc('0x86')]&&_0x27a49e){return db[_0xc4cc('0x87')]['update']({'phone':_0x3e4a1a[_0xc4cc('0x52')][_0xc4cc('0x86')]},{'where':{'ContactId':_0x27a49e['id']}});}})[_0xc4cc('0x25')](function(){return _0x27a49e;})[_0xc4cc('0x25')](respondWithResult(_0x7b22c3,null))[_0xc4cc('0x46')](handleError(_0x7b22c3,null));};exports[_0xc4cc('0x88')]=function(_0x2a64a8,_0x252594,_0x445af7){var _0x30e356={};var _0x115861={};var _0x1ce54a;var _0x532fb1;return db[_0xc4cc('0x3f')][_0xc4cc('0x89')]({'where':{'id':_0x2a64a8['params']['id']}})[_0xc4cc('0x25')](handleEntityNotFound(_0x252594,null))[_0xc4cc('0x25')](function(_0x1acf3a){if(_0x1acf3a){_0x1ce54a=_0x1acf3a;_0x115861[_0xc4cc('0x29')]=_['keys'](db[_0xc4cc('0x3d')][_0xc4cc('0x8a')]);_0x115861[_0xc4cc('0x2b')]=_[_0xc4cc('0x2a')](_0x2a64a8[_0xc4cc('0x2b')]);_0x115861['filters']=_[_0xc4cc('0x2d')](_0x115861[_0xc4cc('0x29')],_0x115861['query']);_0x30e356[_0xc4cc('0x2f')]=_[_0xc4cc('0x2d')](_0x115861['model'],qs[_0xc4cc('0x2e')](_0x2a64a8[_0xc4cc('0x2b')][_0xc4cc('0x2e')]));_0x30e356[_0xc4cc('0x2f')]=_0x30e356[_0xc4cc('0x2f')][_0xc4cc('0x4b')]?_0x30e356[_0xc4cc('0x2f')]:_0x115861['model'];_0x30e356['order']=qs[_0xc4cc('0x34')](_0x2a64a8[_0xc4cc('0x2b')][_0xc4cc('0x34')]);_0x30e356[_0xc4cc('0x35')]=qs['filters'](_[_0xc4cc('0x36')](_0x2a64a8[_0xc4cc('0x2b')],_0x115861[_0xc4cc('0x2c')]));if(_0x2a64a8[_0xc4cc('0x2b')][_0xc4cc('0x37')]){_0x30e356[_0xc4cc('0x35')]=_['merge'](_0x30e356['where'],{'$or':_[_0xc4cc('0x7b')](_0x30e356[_0xc4cc('0x2f')],function(_0x225967){var _0x5c47a3={};_0x5c47a3[_0x225967]={'$like':'%'+_0x2a64a8[_0xc4cc('0x2b')][_0xc4cc('0x37')]+'%'};return _0x5c47a3;})});}_0x30e356=_[_0xc4cc('0x38')]({},_0x30e356,_0x2a64a8['options']);return _0x1ce54a['getTags'](_0x30e356);}})[_0xc4cc('0x25')](function(_0x13013d){if(_0x13013d){_0x532fb1=_0x13013d[_0xc4cc('0x4b')];if(!_0x2a64a8[_0xc4cc('0x2b')][_0xc4cc('0x30')](_0xc4cc('0x31'))){_0x30e356[_0xc4cc('0x32')]=qs[_0xc4cc('0x32')](_0x2a64a8[_0xc4cc('0x2b')]['limit']);_0x30e356[_0xc4cc('0x21')]=qs[_0xc4cc('0x21')](_0x2a64a8[_0xc4cc('0x2b')]['offset']);}return _0x1ce54a[_0xc4cc('0x88')](_0x30e356);}})[_0xc4cc('0x25')](function(_0x3a33c7){if(_0x3a33c7){return _0x3a33c7?{'count':_0x532fb1,'rows':_0x3a33c7}:null;}})[_0xc4cc('0x25')](respondWithResult(_0x252594,null))[_0xc4cc('0x46')](handleError(_0x252594,null));};exports['setTags']=function(_0x505d09,_0x4c9024,_0x5ac085){if(_0x505d09['body']['id']){delete _0x505d09['body']['id'];}return db[_0xc4cc('0x3f')]['findOne']({'where':{'id':_0x505d09[_0xc4cc('0x49')]['id']}})[_0xc4cc('0x25')](handleEntityNotFound(_0x4c9024,null))['then'](function(_0x45b6c7){if(_0x45b6c7){return _0x45b6c7[_0xc4cc('0x8b')](_0x505d09[_0xc4cc('0x52')][_0xc4cc('0x8c')]||[]);}return null;})[_0xc4cc('0x25')](respondWithResult(_0x4c9024,null))[_0xc4cc('0x46')](handleError(_0x4c9024,null));};exports['getHoppers']=function(_0x42f1aa,_0x19ea4c,_0x5c7d76){var _0x30e7cc={'raw':![],'where':{}};var _0x232800={};var _0x587b8c={'count':0x0,'rows':[]};return db[_0xc4cc('0x3f')][_0xc4cc('0x89')]({'where':{'id':_0x42f1aa['params']['id']}})[_0xc4cc('0x25')](handleEntityNotFound(_0x19ea4c,null))['then'](function(_0x50381a){if(_0x50381a){_0x232800[_0xc4cc('0x29')]=_['keys'](db[_0xc4cc('0x87')][_0xc4cc('0x8a')]);_0x232800[_0xc4cc('0x2b')]=_['keys'](_0x42f1aa['query']);_0x232800['filters']=_[_0xc4cc('0x2d')](_0x232800['model'],_0x232800[_0xc4cc('0x2b')]);_0x30e7cc[_0xc4cc('0x2f')]=_[_0xc4cc('0x2d')](_0x232800[_0xc4cc('0x29')],qs['fields'](_0x42f1aa['query'][_0xc4cc('0x2e')]));_0x30e7cc['attributes']=_0x30e7cc[_0xc4cc('0x2f')][_0xc4cc('0x4b')]?_0x30e7cc['attributes']:_0x232800['model'];if(!_0x42f1aa[_0xc4cc('0x2b')][_0xc4cc('0x30')](_0xc4cc('0x31'))){_0x30e7cc['limit']=qs['limit'](_0x42f1aa['query']['limit']);_0x30e7cc[_0xc4cc('0x21')]=qs[_0xc4cc('0x21')](_0x42f1aa['query']['offset']);}_0x30e7cc[_0xc4cc('0x33')]=qs[_0xc4cc('0x34')](_0x42f1aa['query'][_0xc4cc('0x34')]);_0x30e7cc[_0xc4cc('0x35')]=qs['filters'](_[_0xc4cc('0x36')](_0x42f1aa[_0xc4cc('0x2b')],_0x232800[_0xc4cc('0x2c')]));_0x30e7cc['where'][_0xc4cc('0x8d')]=_0x50381a['id'];if(_0x42f1aa[_0xc4cc('0x2b')][_0xc4cc('0x37')]){_0x30e7cc[_0xc4cc('0x35')]=_[_0xc4cc('0x38')](_0x30e7cc[_0xc4cc('0x35')],{'$or':_[_0xc4cc('0x7b')](_0x30e7cc[_0xc4cc('0x2f')],function(_0x561537){var _0x1807d9={};_0x1807d9[_0x561537]={'$like':'%'+_0x42f1aa['query']['filter']+'%'};return _0x1807d9;})});}_0x30e7cc=_[_0xc4cc('0x38')]({},_0x30e7cc,_0x42f1aa[_0xc4cc('0x39')]);return db[_0xc4cc('0x87')][_0xc4cc('0x20')]({'where':_0x30e7cc[_0xc4cc('0x35')]})[_0xc4cc('0x25')](function(_0x2fd71e){_0x587b8c[_0xc4cc('0x20')]=_0x2fd71e;if(_0x42f1aa[_0xc4cc('0x2b')][_0xc4cc('0x40')]){_0x30e7cc[_0xc4cc('0x3a')]=[{'all':!![]}];}return db[_0xc4cc('0x87')][_0xc4cc('0x44')](_0x30e7cc);})[_0xc4cc('0x25')](function(_0x388953){_0x587b8c[_0xc4cc('0x45')]=_0x388953;return _0x587b8c;});}})[_0xc4cc('0x25')](respondWithFilteredResult(_0x19ea4c,_0x30e7cc))['catch'](handleError(_0x19ea4c,null));};exports['getHopperHistories']=function(_0x30605f,_0x2e9532,_0x3ccfd0){var _0xf71096={'raw':!![],'where':{}};var _0x2b2389={};var _0x4a8348={'count':0x0,'rows':[]};return db[_0xc4cc('0x3f')][_0xc4cc('0x89')]({'where':{'id':_0x30605f['params']['id']}})[_0xc4cc('0x25')](handleEntityNotFound(_0x2e9532,null))['then'](function(_0x2e421b){if(_0x2e421b){_0x2b2389[_0xc4cc('0x29')]=_[_0xc4cc('0x2a')](db[_0xc4cc('0x67')]['rawAttributes']);_0x2b2389[_0xc4cc('0x2b')]=_[_0xc4cc('0x2a')](_0x30605f[_0xc4cc('0x2b')]);_0x2b2389[_0xc4cc('0x2c')]=_[_0xc4cc('0x2d')](_0x2b2389['model'],_0x2b2389[_0xc4cc('0x2b')]);_0xf71096['attributes']=_[_0xc4cc('0x2d')](_0x2b2389[_0xc4cc('0x29')],qs[_0xc4cc('0x2e')](_0x30605f[_0xc4cc('0x2b')][_0xc4cc('0x2e')]));_0xf71096['attributes']=_0xf71096['attributes'][_0xc4cc('0x4b')]?_0xf71096[_0xc4cc('0x2f')]:_0x2b2389[_0xc4cc('0x29')];if(!_0x30605f[_0xc4cc('0x2b')][_0xc4cc('0x30')]('nolimit')){_0xf71096[_0xc4cc('0x32')]=qs[_0xc4cc('0x32')](_0x30605f['query'][_0xc4cc('0x32')]);_0xf71096[_0xc4cc('0x21')]=qs[_0xc4cc('0x21')](_0x30605f[_0xc4cc('0x2b')][_0xc4cc('0x21')]);}_0xf71096[_0xc4cc('0x33')]=qs['sort'](_0x30605f['query'][_0xc4cc('0x34')]);_0xf71096[_0xc4cc('0x35')]=qs['filters'](_[_0xc4cc('0x36')](_0x30605f[_0xc4cc('0x2b')],_0x2b2389['filters']));_0xf71096[_0xc4cc('0x35')]['ContactId']=_0x2e421b['id'];if(_0x30605f[_0xc4cc('0x2b')][_0xc4cc('0x37')]){_0xf71096['where']=_[_0xc4cc('0x38')](_0xf71096[_0xc4cc('0x35')],{'$or':_[_0xc4cc('0x7b')](_0xf71096[_0xc4cc('0x2f')],function(_0x3cc223){var _0x208a56={};_0x208a56[_0x3cc223]={'$like':'%'+_0x30605f[_0xc4cc('0x2b')]['filter']+'%'};return _0x208a56;})});}_0xf71096=_[_0xc4cc('0x38')]({},_0xf71096,_0x30605f[_0xc4cc('0x39')]);return db['CmHopperHistory']['count']({'where':_0xf71096[_0xc4cc('0x35')]})[_0xc4cc('0x25')](function(_0x29f535){_0x4a8348[_0xc4cc('0x20')]=_0x29f535;if(_0x30605f['query'][_0xc4cc('0x40')]){_0xf71096['include']=[{'all':!![]}];}return db[_0xc4cc('0x67')]['findAll'](_0xf71096);})['then'](function(_0x37bfde){_0x4a8348[_0xc4cc('0x45')]=_0x37bfde;return _0x4a8348;});}})[_0xc4cc('0x25')](respondWithFilteredResult(_0x2e9532,_0xf71096))[_0xc4cc('0x46')](handleError(_0x2e9532,null));};exports['getHopperFinals']=function(_0xcbca4e,_0x2492ad,_0x41b976){var _0x50359c={'raw':!![],'where':{}};var _0x2fba17={};var _0x1537c9={'count':0x0,'rows':[]};return db[_0xc4cc('0x3f')][_0xc4cc('0x89')]({'where':{'id':_0xcbca4e[_0xc4cc('0x49')]['id']}})[_0xc4cc('0x25')](handleEntityNotFound(_0x2492ad,null))[_0xc4cc('0x25')](function(_0x280af2){if(_0x280af2){_0x2fba17[_0xc4cc('0x29')]=_[_0xc4cc('0x2a')](db['CmHopperFinal'][_0xc4cc('0x8a')]);_0x2fba17['query']=_[_0xc4cc('0x2a')](_0xcbca4e[_0xc4cc('0x2b')]);_0x2fba17[_0xc4cc('0x2c')]=_['intersection'](_0x2fba17[_0xc4cc('0x29')],_0x2fba17[_0xc4cc('0x2b')]);_0x50359c[_0xc4cc('0x2f')]=_[_0xc4cc('0x2d')](_0x2fba17[_0xc4cc('0x29')],qs[_0xc4cc('0x2e')](_0xcbca4e['query'][_0xc4cc('0x2e')]));_0x50359c[_0xc4cc('0x2f')]=_0x50359c['attributes'][_0xc4cc('0x4b')]?_0x50359c[_0xc4cc('0x2f')]:_0x2fba17[_0xc4cc('0x29')];if(!_0xcbca4e[_0xc4cc('0x2b')][_0xc4cc('0x30')](_0xc4cc('0x31'))){_0x50359c[_0xc4cc('0x32')]=qs[_0xc4cc('0x32')](_0xcbca4e['query'][_0xc4cc('0x32')]);_0x50359c[_0xc4cc('0x21')]=qs['offset'](_0xcbca4e[_0xc4cc('0x2b')][_0xc4cc('0x21')]);}_0x50359c[_0xc4cc('0x33')]=qs[_0xc4cc('0x34')](_0xcbca4e[_0xc4cc('0x2b')][_0xc4cc('0x34')]);_0x50359c[_0xc4cc('0x35')]=qs['filters'](_[_0xc4cc('0x36')](_0xcbca4e['query'],_0x2fba17[_0xc4cc('0x2c')]));_0x50359c[_0xc4cc('0x35')][_0xc4cc('0x8d')]=_0x280af2['id'];if(_0xcbca4e[_0xc4cc('0x2b')][_0xc4cc('0x37')]){_0x50359c[_0xc4cc('0x35')]=_[_0xc4cc('0x38')](_0x50359c['where'],{'$or':_[_0xc4cc('0x7b')](_0x50359c[_0xc4cc('0x2f')],function(_0x23bfb8){var _0x130208={};_0x130208[_0x23bfb8]={'$like':'%'+_0xcbca4e[_0xc4cc('0x2b')]['filter']+'%'};return _0x130208;})});}_0x50359c=_[_0xc4cc('0x38')]({},_0x50359c,_0xcbca4e[_0xc4cc('0x39')]);return db[_0xc4cc('0x66')][_0xc4cc('0x20')]({'where':_0x50359c[_0xc4cc('0x35')]})['then'](function(_0x1b94da){_0x1537c9[_0xc4cc('0x20')]=_0x1b94da;if(_0xcbca4e[_0xc4cc('0x2b')][_0xc4cc('0x40')]){_0x50359c[_0xc4cc('0x3a')]=[{'all':!![]}];}return db[_0xc4cc('0x66')][_0xc4cc('0x44')](_0x50359c);})['then'](function(_0x5d733e){_0x1537c9[_0xc4cc('0x45')]=_0x5d733e;return _0x1537c9;});}})['then'](respondWithFilteredResult(_0x2492ad,_0x50359c))[_0xc4cc('0x46')](handleError(_0x2492ad,null));};exports[_0xc4cc('0x8e')]=function(_0x5d7d34,_0x536aa0,_0x8b7347){var _0x154880={'raw':!![],'where':{}};var _0x4b3a00={};var _0x13bcae={'count':0x0,'rows':[]};return db[_0xc4cc('0x3f')][_0xc4cc('0x89')]({'where':{'id':_0x5d7d34['params']['id']}})[_0xc4cc('0x25')](handleEntityNotFound(_0x536aa0,null))[_0xc4cc('0x25')](function(_0x58a81d){if(_0x58a81d){_0x4b3a00[_0xc4cc('0x29')]=_['keys'](db[_0xc4cc('0x6f')][_0xc4cc('0x8a')]);_0x4b3a00[_0xc4cc('0x2b')]=_[_0xc4cc('0x2a')](_0x5d7d34['query']);_0x4b3a00[_0xc4cc('0x2c')]=_[_0xc4cc('0x2d')](_0x4b3a00[_0xc4cc('0x29')],_0x4b3a00['query']);_0x154880[_0xc4cc('0x2f')]=_[_0xc4cc('0x2d')](_0x4b3a00[_0xc4cc('0x29')],qs[_0xc4cc('0x2e')](_0x5d7d34[_0xc4cc('0x2b')][_0xc4cc('0x2e')]));_0x154880[_0xc4cc('0x2f')]=_0x154880[_0xc4cc('0x2f')][_0xc4cc('0x4b')]?_0x154880[_0xc4cc('0x2f')]:_0x4b3a00[_0xc4cc('0x29')];if(!_0x5d7d34[_0xc4cc('0x2b')][_0xc4cc('0x30')]('nolimit')){_0x154880[_0xc4cc('0x32')]=qs[_0xc4cc('0x32')](_0x5d7d34['query'][_0xc4cc('0x32')]);_0x154880[_0xc4cc('0x21')]=qs[_0xc4cc('0x21')](_0x5d7d34[_0xc4cc('0x2b')]['offset']);}_0x154880[_0xc4cc('0x33')]=qs[_0xc4cc('0x34')](_0x5d7d34[_0xc4cc('0x2b')][_0xc4cc('0x34')]);_0x154880['where']=qs[_0xc4cc('0x2c')](_[_0xc4cc('0x36')](_0x5d7d34[_0xc4cc('0x2b')],_0x4b3a00[_0xc4cc('0x2c')]));_0x154880[_0xc4cc('0x35')][_0xc4cc('0x8d')]=_0x58a81d['id'];if(_0x5d7d34['query'][_0xc4cc('0x37')]){_0x154880[_0xc4cc('0x35')]=_[_0xc4cc('0x38')](_0x154880[_0xc4cc('0x35')],{'$or':_[_0xc4cc('0x7b')](_0x154880[_0xc4cc('0x2f')],function(_0x1f6760){var _0x3d66ff={};_0x3d66ff[_0x1f6760]={'$like':'%'+_0x5d7d34[_0xc4cc('0x2b')][_0xc4cc('0x37')]+'%'};return _0x3d66ff;})});}_0x154880=_[_0xc4cc('0x38')]({},_0x154880,_0x5d7d34['options']);return db[_0xc4cc('0x6f')][_0xc4cc('0x20')]({'where':_0x154880['where']})[_0xc4cc('0x25')](function(_0x432828){_0x13bcae['count']=_0x432828;if(_0x5d7d34[_0xc4cc('0x2b')]['includeAll']){_0x154880[_0xc4cc('0x3a')]=[{'all':!![]}];}return db[_0xc4cc('0x6f')]['findAll'](_0x154880);})[_0xc4cc('0x25')](function(_0x4e6c3c){_0x13bcae[_0xc4cc('0x45')]=_0x4e6c3c;return _0x13bcae;});}})[_0xc4cc('0x25')](respondWithFilteredResult(_0x536aa0,_0x154880))[_0xc4cc('0x46')](handleError(_0x536aa0,null));};exports['uploadCsv']=function(_0x20178f,_0x3fdc6f,_0x3e796f){try{if(!_0x20178f[_0xc4cc('0x52')]['ListId']){throw new Error(_0xc4cc('0x8f'));}if(!_0x20178f[_0xc4cc('0x52')]['binding_keys']){throw new Error(_0xc4cc('0x90'));}if(!_0x20178f[_0xc4cc('0x52')][_0xc4cc('0x91')]){throw new Error(_0xc4cc('0x92'));}if(!_0x20178f[_0xc4cc('0x52')][_0xc4cc('0x93')]){throw new Error(_0xc4cc('0x94'));}var _0x113e0d=_0x20178f[_0xc4cc('0x52')][_0xc4cc('0x95')]['split'](',');var _0x520a72=_0x20178f[_0xc4cc('0x52')][_0xc4cc('0x91')]['split'](',');if(!_0x113e0d[_0xc4cc('0x4b')]||!_0x520a72['length']||_0x113e0d[_0xc4cc('0x4b')]!==_0x520a72[_0xc4cc('0x4b')]){throw new Error(_0xc4cc('0x96'));}_0x20178f[_0xc4cc('0x52')]['fields']=_[_0xc4cc('0x97')](_0x113e0d,_0x520a72);if(!_0x20178f[_0xc4cc('0x52')][_0xc4cc('0x2e')][_0xc4cc('0x86')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x20178f['body'][_0xc4cc('0x2e')]['firstName']){throw new Error(_0xc4cc('0x98'));}var _0xec1c8b=path[_0xc4cc('0x58')](config[_0xc4cc('0x99')],'server/files/tmp',_0x20178f[_0xc4cc('0x9a')][_0xc4cc('0x9b')]);fs['chmodSync'](_0xec1c8b,parseInt(_0xc4cc('0x9c'),0x8));var _0x44f873=require(_0xc4cc('0x9d'))[_0xc4cc('0x9e')](path['join'](__dirname,'../../components/import/cm/csv'),[_0xec1c8b,_0x20178f[_0xc4cc('0x52')][_0xc4cc('0x95')],_0x20178f['body'][_0xc4cc('0x91')],_0x20178f[_0xc4cc('0x52')][_0xc4cc('0x78')],_0x20178f[_0xc4cc('0x52')][_0xc4cc('0x9f')],_0x20178f[_0xc4cc('0x52')]['duplicates'],_0x20178f[_0xc4cc('0x52')][_0xc4cc('0x93')]]);return _0x3fdc6f['status'](0xc8)[_0xc4cc('0x1f')]({'message':_0xc4cc('0xa0'),'pid':_0x44f873[_0xc4cc('0xa1')]});}catch(_0x30d96d){return _0x3fdc6f['status'](0x1f4)[_0xc4cc('0xa2')](_0x30d96d);}};exports[_0xc4cc('0xa3')]=function(_0x26cce8,_0x55991c,_0x41350f){var _0x2f43e4=fs[_0xc4cc('0xa4')](_0x26cce8[_0xc4cc('0x9a')][_0xc4cc('0x9')]);Papa[_0xc4cc('0xa5')](_0x2f43e4,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x185f3c){return _0x55991c[_0xc4cc('0x1e')](0xc8)[_0xc4cc('0x1f')]({'file':_0x26cce8['file'],'fields':_0x185f3c[_0xc4cc('0xa6')][_0xc4cc('0x2e')]});}});};exports[_0xc4cc('0xa7')]=function(_0x16a6d0,_0x4832e2,_0x740b5d){return db[_0xc4cc('0xa8')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0xc4cc('0xa9')}})[_0xc4cc('0x25')](function(_0x161d5f){var _0x44a021=![];if(!_0x16a6d0[_0xc4cc('0x52')][_0xc4cc('0x78')]){throw new Error(_0xc4cc('0x8f'));}if(!_0x16a6d0['body']['binding'][_0xc4cc('0x86')]){throw new Error(_0xc4cc('0xaa'));}if(!_0x16a6d0[_0xc4cc('0x52')]['binding'][_0xc4cc('0xab')]){throw new Error(_0xc4cc('0x98'));}if(!_0x16a6d0[_0xc4cc('0x52')][_0xc4cc('0x93')]){throw new Error(_0xc4cc('0x94'));}var _0x36e3d5=require(_0xc4cc('0x9d'))[_0xc4cc('0x9e')](path['join'](__dirname,'../../components/import/cm/csv2'),[_0x16a6d0[_0xc4cc('0x49')]['id'],JSON[_0xc4cc('0xac')](_0x16a6d0['body']),JSON[_0xc4cc('0xac')](_0x161d5f)]);_0x36e3d5['on'](_0xc4cc('0xad'),function(_0x41a6c1){_0x44a021=!![];return _0x4832e2[_0xc4cc('0x1e')](0xc8)[_0xc4cc('0x1f')]({'message':_0xc4cc('0xae'),'pid':_0x36e3d5[_0xc4cc('0xa1')]});});_0x36e3d5['on']('exit',function(_0x375258){if(_0x375258&&!_0x44a021){return _0x4832e2[_0xc4cc('0x1e')](0x1f4)[_0xc4cc('0x1f')]({'message':_0xc4cc('0xaf'),'pid':_0x36e3d5['pid']});}});})[_0xc4cc('0x46')](handleError(_0x4832e2,null));};
\ No newline at end of file
+var _0xfd0b=['No\x20firstName\x20column\x20specified','root','server/files/tmp','file','filename','0777','child_process','fork','pid','upload','createReadStream','parse','meta','import','agent','binding','../../components/import/cm/csv2','stringify','start\x20child\x20process\x20correctly!','exit','error\x20child\x20process','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','path','to-csv','ejs','lodash','squel','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../config/license/hardware','ioredis','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','defaults','redis','localhost','socket.io-emitter','./cmContact.socket','status','json','count','offset','limit','set','Content-Range','apply','reject','save','update','then','destroy','sendStatus','error','stack','name','send','index','CmContact','describe','keys','query','intersection','model','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','map','merge','options','include','push','Tags','tag','distinct','includeAll','Tag','ThroughTags','color','findAll','rows','find','params','catch','cf_','columnName','displayName','CmCustomField','alias','body','get','mergeWith','isArray','tags','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','from','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','create','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','bulkCreate','duplicates','$or','ListId','findOrCreate','spread','show','$and','omit','format','pickBy','startsWith','cf_%d','isEmpty','table','cm_contacts','id\x20=\x20?','toParam','sequelize','text','values','phone','getTags','findOne','rawAttributes','setTags','ids','getHoppers','ContactId','getHopperHistories','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','No\x20association\x20keys\x20specified!','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_keys','split','binding_values','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified'];(function(_0x479037,_0x2febe5){var _0x165b74=function(_0x1db197){while(--_0x1db197){_0x479037['push'](_0x479037['shift']());}};_0x165b74(++_0x2febe5);}(_0xfd0b,0xcd));var _0xbfd0=function(_0x5783c1,_0x3716d8){_0x5783c1=_0x5783c1-0x0;var _0xcecf69=_0xfd0b[_0x5783c1];return _0xcecf69;};'use strict';var pdf=require(_0xbfd0('0x0'));var emlformat=require(_0xbfd0('0x1'));var rimraf=require(_0xbfd0('0x2'));var zipdir=require(_0xbfd0('0x3'));var jsonpatch=require(_0xbfd0('0x4'));var rp=require('request-promise');var moment=require(_0xbfd0('0x5'));var BPromise=require(_0xbfd0('0x6'));var Mustache=require(_0xbfd0('0x7'));var util=require('util');var path=require(_0xbfd0('0x8'));var sox=require('sox');var csv=require(_0xbfd0('0x9'));var ejs=require(_0xbfd0('0xa'));var fs=require('fs');var _=require(_0xbfd0('0xb'));var squel=require(_0xbfd0('0xc'));var crypto=require('crypto');var jsforce=require(_0xbfd0('0xd'));var deskjs=require(_0xbfd0('0xe'));var toCsv=require('to-csv');var querystring=require(_0xbfd0('0xf'));var Papa=require(_0xbfd0('0x10'));var authService=require(_0xbfd0('0x11'));var hardwareService=require(_0xbfd0('0x12'));var Redis=require(_0xbfd0('0x13'));var qs=require('../../components/parsers/qs');var logger=require(_0xbfd0('0x14'))(_0xbfd0('0x15'));var utils=require(_0xbfd0('0x16'));var config=require(_0xbfd0('0x17'));var db=require(_0xbfd0('0x18'))['db'];config['redis']=_[_0xbfd0('0x19')](config[_0xbfd0('0x1a')],{'host':_0xbfd0('0x1b'),'port':0x18eb});var socket=require(_0xbfd0('0x1c'))(new Redis(config[_0xbfd0('0x1a')]));require(_0xbfd0('0x1d'))['register'](socket);function respondWithStatusCode(_0x40ec32,_0x180514){_0x180514=_0x180514||0xcc;return function(_0x5b48bc){if(_0x5b48bc){return _0x40ec32['sendStatus'](_0x180514);}return _0x40ec32[_0xbfd0('0x1e')](_0x180514)['end']();};}function respondWithResult(_0x40ba83,_0x473f9d){_0x473f9d=_0x473f9d||0xc8;return function(_0x472bf6){if(_0x472bf6){return _0x40ba83[_0xbfd0('0x1e')](_0x473f9d)[_0xbfd0('0x1f')](_0x472bf6);}};}function respondWithFilteredResult(_0x2bc6ff,_0x164b1b){return function(_0x11281f){if(_0x11281f){var _0x9081ff=_0x11281f[_0xbfd0('0x20')],_0x3ee46f=_0x164b1b[_0xbfd0('0x21')],_0x3a6cc5=_0x164b1b[_0xbfd0('0x21')]+_0x164b1b[_0xbfd0('0x22')],_0x598afa;if(_0x3a6cc5>=_0x9081ff){_0x3a6cc5=_0x9081ff;_0x598afa=0xc8;}else{_0x598afa=0xce;}_0x2bc6ff[_0xbfd0('0x1e')](_0x598afa);return _0x2bc6ff[_0xbfd0('0x23')](_0xbfd0('0x24'),_0x3ee46f+'-'+_0x3a6cc5+'/'+_0x9081ff)[_0xbfd0('0x1f')](_0x11281f);}return null;};}function patchUpdates(_0x5894ed){return function(_0x538272){try{jsonpatch[_0xbfd0('0x25')](_0x538272,_0x5894ed,!![]);}catch(_0x5ed1e5){return BPromise[_0xbfd0('0x26')](_0x5ed1e5);}return _0x538272[_0xbfd0('0x27')]();};}function saveUpdates(_0x1e87d3,_0x42c116){return function(_0xc96985){if(_0xc96985){return _0xc96985[_0xbfd0('0x28')](_0x1e87d3)[_0xbfd0('0x29')](function(_0xf7351f){return _0xf7351f;});}return null;};}function removeEntity(_0x230260,_0x1cabe4){return function(_0x58c6b5){if(_0x58c6b5){return _0x58c6b5[_0xbfd0('0x2a')]()[_0xbfd0('0x29')](function(){_0x230260[_0xbfd0('0x1e')](0xcc)['end']();});}};}function handleEntityNotFound(_0x44054d,_0x5db5b5){return function(_0x4d93f4){if(!_0x4d93f4){_0x44054d[_0xbfd0('0x2b')](0x194);}return _0x4d93f4;};}function handleError(_0x33a0a4,_0x6f0d94){_0x6f0d94=_0x6f0d94||0x1f4;return function(_0x465811){logger[_0xbfd0('0x2c')](_0x465811[_0xbfd0('0x2d')]);if(_0x465811[_0xbfd0('0x2e')]){delete _0x465811[_0xbfd0('0x2e')];}_0x33a0a4[_0xbfd0('0x1e')](_0x6f0d94)[_0xbfd0('0x2f')](_0x465811);};}exports[_0xbfd0('0x30')]=function(_0x435bc2,_0x114f43){var _0x483bc6={},_0x2177b2={},_0x4c320b={'count':0x0,'rows':[]};return db[_0xbfd0('0x31')][_0xbfd0('0x32')]()[_0xbfd0('0x29')](function(_0x521d69){_0x2177b2['model']=_[_0xbfd0('0x33')](_0x521d69);_0x2177b2[_0xbfd0('0x34')]=_[_0xbfd0('0x33')](_0x435bc2['query']);_0x2177b2['filters']=_[_0xbfd0('0x35')](_0x2177b2[_0xbfd0('0x36')],_0x2177b2[_0xbfd0('0x34')]);_0x483bc6['attributes']=_[_0xbfd0('0x35')](_0x2177b2[_0xbfd0('0x36')],qs['fields'](_0x435bc2[_0xbfd0('0x34')][_0xbfd0('0x37')]));_0x483bc6[_0xbfd0('0x38')]=_0x483bc6[_0xbfd0('0x38')][_0xbfd0('0x39')]?_0x483bc6[_0xbfd0('0x38')]:_0x2177b2[_0xbfd0('0x36')];if(!_0x435bc2[_0xbfd0('0x34')][_0xbfd0('0x3a')](_0xbfd0('0x3b'))){_0x483bc6['limit']=qs[_0xbfd0('0x22')](_0x435bc2[_0xbfd0('0x34')][_0xbfd0('0x22')]);_0x483bc6[_0xbfd0('0x21')]=qs[_0xbfd0('0x21')](_0x435bc2[_0xbfd0('0x34')][_0xbfd0('0x21')]);}_0x483bc6[_0xbfd0('0x3c')]=qs[_0xbfd0('0x3d')](_0x435bc2[_0xbfd0('0x34')]['sort']);_0x483bc6[_0xbfd0('0x3e')]=qs[_0xbfd0('0x3f')](_[_0xbfd0('0x40')](_0x435bc2[_0xbfd0('0x34')],_0x2177b2[_0xbfd0('0x3f')]));if(_0x435bc2[_0xbfd0('0x34')][_0xbfd0('0x41')]){_0x483bc6[_0xbfd0('0x3e')]=_['merge'](_0x483bc6[_0xbfd0('0x3e')],{'$or':_[_0xbfd0('0x42')](_0x483bc6[_0xbfd0('0x38')],function(_0x2c7da3){var _0x1ada9b={};_0x1ada9b[_0x2c7da3]={'$like':'%'+_0x435bc2[_0xbfd0('0x34')][_0xbfd0('0x41')]+'%'};return _0x1ada9b;})});}_0x483bc6=_[_0xbfd0('0x43')]({},_0x483bc6,_0x435bc2[_0xbfd0('0x44')]);var _0x40db1f={'where':_0x483bc6['where']};_0x40db1f['include']=[];if(_0x435bc2[_0xbfd0('0x34')]['tag']){_0x40db1f[_0xbfd0('0x45')][_0xbfd0('0x46')]({'model':db['Tag'],'as':_0xbfd0('0x47'),'attributes':['id'],'where':{'id':_0x435bc2[_0xbfd0('0x34')][_0xbfd0('0x48')]},'required':!![]});_0x40db1f[_0xbfd0('0x49')]=!![];}return db['CmContact'][_0xbfd0('0x20')](_0x40db1f)['then'](function(_0xb29845){_0x4c320b[_0xbfd0('0x20')]=_0xb29845;if(_0x435bc2[_0xbfd0('0x34')][_0xbfd0('0x4a')]){_0x483bc6[_0xbfd0('0x45')]=[{'model':db[_0xbfd0('0x4b')],'as':_0xbfd0('0x47'),'attributes':['id',_0xbfd0('0x2e'),'color'],'required':_0x435bc2[_0xbfd0('0x34')][_0xbfd0('0x48')]?!![]:![]},{'model':db[_0xbfd0('0x4b')],'as':_0xbfd0('0x4c'),'attributes':['id',_0xbfd0('0x2e'),_0xbfd0('0x4d')],'through':_0x435bc2[_0xbfd0('0x34')][_0xbfd0('0x48')]?{'attributes':[],'where':{'TagId':_0x435bc2['query'][_0xbfd0('0x48')]||undefined}}:{},'required':_0x435bc2[_0xbfd0('0x34')][_0xbfd0('0x48')]?!![]:![]}];}return db[_0xbfd0('0x31')][_0xbfd0('0x4e')](_0x483bc6);})['then'](function(_0x508a9b){_0x4c320b[_0xbfd0('0x4f')]=_0x508a9b;return _0x4c320b;})[_0xbfd0('0x29')](respondWithFilteredResult(_0x114f43,_0x483bc6))['catch'](handleError(_0x114f43,null));});};exports[_0xbfd0('0x2a')]=function(_0x14bec3,_0x487081){return db[_0xbfd0('0x31')][_0xbfd0('0x50')]({'where':{'id':_0x14bec3[_0xbfd0('0x51')]['id']}})[_0xbfd0('0x29')](handleEntityNotFound(_0x487081,null))[_0xbfd0('0x29')](removeEntity(_0x487081,null))[_0xbfd0('0x52')](handleError(_0x487081,null));};exports[_0xbfd0('0x32')]=function(_0x2e9570,_0x11cfb6){return db[_0xbfd0('0x31')][_0xbfd0('0x32')]()[_0xbfd0('0x29')](function(_0x5181e0){for(var _0x2e0434=0x0;_0x2e0434<Object[_0xbfd0('0x33')](_0x5181e0)[_0xbfd0('0x39')];_0x2e0434++){var _0x341ec4=Object['keys'](_0x5181e0)[_0x2e0434];if(!_['startsWith'](_0x341ec4,_0xbfd0('0x53'))){_0x5181e0[_0x341ec4][_0xbfd0('0x54')]=_0x341ec4;_0x5181e0[_0x341ec4][_0xbfd0('0x55')]=_0x341ec4;}}return _0x5181e0;})[_0xbfd0('0x29')](function(_0x13b559){var _0xf9bcc0={'where':{'$or':[{'ListId':_0x2e9570[_0xbfd0('0x34')]['id']},{'ListId':null}]},'raw':!![]};return db[_0xbfd0('0x56')][_0xbfd0('0x4e')](_0xf9bcc0)['then'](function(_0x403c76){for(var _0x21aaf0=0x0;_0x21aaf0<_0x403c76[_0xbfd0('0x39')];_0x21aaf0++){var _0x1de5b9=_0xbfd0('0x53')+_0x403c76[_0x21aaf0]['id'];_0x13b559[_0x1de5b9][_0xbfd0('0x54')]=_0x1de5b9;_0x13b559[_0x1de5b9][_0xbfd0('0x55')]=_0x403c76[_0x21aaf0][_0xbfd0('0x57')];}for(var _0x21aaf0=0x0;_0x21aaf0<Object[_0xbfd0('0x33')](_0x13b559)['length'];_0x21aaf0++){var _0x1de5b9=Object[_0xbfd0('0x33')](_0x13b559)[_0x21aaf0];if(!_0x13b559[_0x1de5b9]['hasOwnProperty'](_0xbfd0('0x54'))){delete _0x13b559[_0x1de5b9];}}return _0x13b559;});})[_0xbfd0('0x29')](respondWithResult(_0x11cfb6,null))['catch'](handleError(_0x11cfb6,null));};exports[_0xbfd0('0x43')]=function(_0x1ecc6f,_0xce240e){var _0x59f483;var _0x36fd4f;var _0x300130;if(_0x1ecc6f['body']['id']){delete _0x1ecc6f['body']['id'];}return db['CmContact'][_0xbfd0('0x4e')]({'where':{'id':[_0x1ecc6f[_0xbfd0('0x58')]['to'],_0x1ecc6f[_0xbfd0('0x58')]['from']]}})[_0xbfd0('0x29')](function(_0x542806){if(_0x542806){if(_0x542806[_0xbfd0('0x39')]!==0x2){return null;}_0x542806[0x0]=_0x542806[0x0][_0xbfd0('0x59')]({'plain':!![]});_0x542806[0x1]=_0x542806[0x1][_0xbfd0('0x59')]({'plain':!![]});delete _0x542806[0x0]['id'];delete _0x542806[0x1]['id'];return _[_0xbfd0('0x5a')](_0x542806[0x0],_0x542806[0x1],function(_0xd7580c,_0x197c29){if(Array[_0xbfd0('0x5b')](_0x197c29)&&!_0x197c29[_0xbfd0('0x39')]){return _0xd7580c;}else if(!_0x197c29){return _0xd7580c;}});}})[_0xbfd0('0x29')](handleEntityNotFound(_0xce240e,null))[_0xbfd0('0x29')](function(_0x3d74f6){if(_0x3d74f6){if(_0x3d74f6[_0xbfd0('0x5c')]&&_[_0xbfd0('0x5b')](_0x3d74f6[_0xbfd0('0x5c')])){_0x3d74f6['tags']=_0x3d74f6['tags'][_0xbfd0('0x5d')]();}logger[_0xbfd0('0x5e')](_0xbfd0('0x5f'),_0x1ecc6f[_0xbfd0('0x58')]['to'],_0x1ecc6f['body'][_0xbfd0('0x60')]);return db[_0xbfd0('0x61')][_0xbfd0('0x2a')]({'where':{'ContactId':[_0x1ecc6f[_0xbfd0('0x58')]['to'],_0x1ecc6f[_0xbfd0('0x58')][_0xbfd0('0x60')]]}})['then'](function(_0x25730d){logger[_0xbfd0('0x5e')](_0xbfd0('0x62'),_0x25730d);return db['CmHopperBlack'][_0xbfd0('0x2a')]({'where':{'ContactId':[_0x1ecc6f[_0xbfd0('0x58')]['to'],_0x1ecc6f[_0xbfd0('0x58')]['from']]}})[_0xbfd0('0x29')](function(_0x153e14){logger[_0xbfd0('0x5e')]('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x153e14);return db[_0xbfd0('0x31')][_0xbfd0('0x63')](_0x3d74f6);});});}})[_0xbfd0('0x29')](function(_0x5cc15b){if(_0x5cc15b){_0x59f483=_0x5cc15b;_0x36fd4f={'ContactId':_0x59f483['id']};_0x300130={'where':{'ContactId':[_0x1ecc6f['body']['to'],_0x1ecc6f[_0xbfd0('0x58')]['from']]}};return db['ChatInteraction'][_0xbfd0('0x28')](_0x36fd4f,_0x300130);}})[_0xbfd0('0x29')](function(){if(_0x59f483){return db[_0xbfd0('0x64')]['update'](_0x36fd4f,_0x300130);}})[_0xbfd0('0x29')](function(){if(_0x59f483){return db[_0xbfd0('0x65')]['update'](_0x36fd4f,_0x300130);}})[_0xbfd0('0x29')](function(){if(_0x59f483){return db[_0xbfd0('0x66')][_0xbfd0('0x28')](_0x36fd4f,_0x300130);}})['then'](function(){if(_0x59f483){return db[_0xbfd0('0x67')][_0xbfd0('0x28')](_0x36fd4f,_0x300130);}})[_0xbfd0('0x29')](function(){if(_0x59f483){return db[_0xbfd0('0x66')][_0xbfd0('0x28')](_0x36fd4f,_0x300130);}})[_0xbfd0('0x29')](function(){if(_0x59f483){return db[_0xbfd0('0x67')][_0xbfd0('0x28')](_0x36fd4f,_0x300130);}})[_0xbfd0('0x29')](function(){if(_0x59f483){return db[_0xbfd0('0x68')]['update'](_0x36fd4f,_0x300130);}})['then'](function(){if(_0x59f483){return db[_0xbfd0('0x69')][_0xbfd0('0x28')](_0x36fd4f,_0x300130);}})[_0xbfd0('0x29')](function(){if(_0x59f483){return db[_0xbfd0('0x6a')][_0xbfd0('0x28')](_0x36fd4f,_0x300130);}})['then'](function(){if(_0x59f483){return db[_0xbfd0('0x6b')][_0xbfd0('0x28')](_0x36fd4f,_0x300130);}})[_0xbfd0('0x29')](function(){if(_0x59f483){return db[_0xbfd0('0x6c')][_0xbfd0('0x28')](_0x36fd4f,_0x300130);}})[_0xbfd0('0x29')](function(){if(_0x59f483){return db[_0xbfd0('0x6d')][_0xbfd0('0x28')](_0x36fd4f,_0x300130);}})[_0xbfd0('0x29')](function(){if(_0x59f483){return db[_0xbfd0('0x6e')][_0xbfd0('0x28')](_0x36fd4f,_0x300130);}})['then'](function(){if(_0x59f483){return db[_0xbfd0('0x6f')][_0xbfd0('0x28')](_0x36fd4f,_0x300130);}})['then'](function(){if(_0x59f483){return db[_0xbfd0('0x70')]['update'](_0x36fd4f,_0x300130);}})[_0xbfd0('0x29')](function(){if(_0x59f483){return db[_0xbfd0('0x71')][_0xbfd0('0x28')](_0x36fd4f,_0x300130);}})[_0xbfd0('0x29')](function(){if(_0x59f483){return db[_0xbfd0('0x72')][_0xbfd0('0x28')](_0x36fd4f,_0x300130);}})[_0xbfd0('0x29')](function(){if(_0x59f483){return db[_0xbfd0('0x73')]['update'](_0x36fd4f,_0x300130);}})['then'](function(){if(_0x59f483){return db[_0xbfd0('0x74')][_0xbfd0('0x28')](_0x36fd4f,_0x300130);}})['then'](function(){if(_0x59f483){return db[_0xbfd0('0x75')]['update'](_0x36fd4f,_0x300130);}})['then'](function(){if(_0x59f483){return db[_0xbfd0('0x76')][_0xbfd0('0x28')](_0x36fd4f,_0x300130);}})['then'](function(){if(_0x59f483){return db[_0xbfd0('0x77')][_0xbfd0('0x28')](_0x36fd4f,_0x300130);}})[_0xbfd0('0x29')](function(){if(_0x59f483){return db[_0xbfd0('0x31')][_0xbfd0('0x2a')]({'where':{'id':[_0x1ecc6f[_0xbfd0('0x58')]['to'],_0x1ecc6f[_0xbfd0('0x58')][_0xbfd0('0x60')]]}});}})[_0xbfd0('0x29')](function(){if(_0x59f483){return _0x59f483;}})['then'](respondWithResult(_0xce240e,null))[_0xbfd0('0x52')](handleError(_0xce240e,null));};exports[_0xbfd0('0x63')]=function(_0x1e9324,_0xdec2d9){return db[_0xbfd0('0x31')]['describe']()[_0xbfd0('0x29')](function(_0x12b0a5){if(_0x1e9324[_0xbfd0('0x58')][_0xbfd0('0x5c')]&&_[_0xbfd0('0x5b')](_0x1e9324[_0xbfd0('0x58')][_0xbfd0('0x5c')])){if(_0x1e9324['body'][_0xbfd0('0x5c')][_0xbfd0('0x39')]){_0x1e9324[_0xbfd0('0x58')][_0xbfd0('0x5c')]=_0x1e9324['body'][_0xbfd0('0x5c')][_0xbfd0('0x5d')](';')+';';}else{_0x1e9324[_0xbfd0('0x58')]['tags']=null;}}else{_0x1e9324[_0xbfd0('0x58')]['tags']=null;}return db[_0xbfd0('0x31')][_0xbfd0('0x63')](_0x1e9324['body'],{'fields':_[_0xbfd0('0x33')](_0x12b0a5),'raw':!![]});})[_0xbfd0('0x29')](respondWithResult(_0xdec2d9,0xc9))[_0xbfd0('0x52')](handleError(_0xdec2d9,null));};exports[_0xbfd0('0x78')]=function(_0x398405,_0x2659e5){var _0x4ae01d=[];var _0x526969=0x0;var _0x1178c8=0x0;var _0x448d8f=0x0;return db[_0xbfd0('0x31')][_0xbfd0('0x32')]()[_0xbfd0('0x29')](function(_0xc31a4d){return BPromise['each'](_0x398405[_0xbfd0('0x58')],function(_0x4f4f60){var _0xccbee6={'where':{'$or':[]},'defaults':_0x4f4f60,'fields':_[_0xbfd0('0x33')](_0xc31a4d),'raw':!![]};if(_0x4f4f60[_0xbfd0('0x79')]){for(var _0x51bdf9=0x0;_0x51bdf9<_0x4f4f60[_0xbfd0('0x79')][_0xbfd0('0x39')];_0x51bdf9++){var _0x15d483={};_0x15d483[_0x4f4f60[_0xbfd0('0x79')][_0x51bdf9]]=_0x4f4f60[_0x4f4f60[_0xbfd0('0x79')][_0x51bdf9]];_0xccbee6['where'][_0xbfd0('0x7a')]['push'](_0x15d483);}_0xccbee6[_0xbfd0('0x3e')]['ListId']=_0x4f4f60[_0xbfd0('0x7b')];}return db[_0xbfd0('0x31')][_0xbfd0('0x7c')](_0xccbee6)[_0xbfd0('0x7d')](function(_0x38b36e,_0x3bb138){if(_0x3bb138){_0x526969++;}else{_0x448d8f++;}})['catch'](function(_0x59b7e0){console['error'](_0x59b7e0);_0x1178c8++;});});})[_0xbfd0('0x29')](function(_0x11d9c3){if(_0x11d9c3){return{'success':_0x526969,'failure':_0x1178c8,'duplicates':_0x448d8f};}})[_0xbfd0('0x29')](respondWithResult(_0x2659e5,0xc9))['catch'](handleError(_0x2659e5,null));};exports[_0xbfd0('0x7e')]=function(_0x553069,_0x5d3f8e,_0x56cf44){var _0xd078aa;return db[_0xbfd0('0x31')][_0xbfd0('0x32')]()[_0xbfd0('0x29')](function(_0x26c307){return db['CmContact'][_0xbfd0('0x50')]({'where':{'id':_0x553069['params']['id']},'include':[{'model':db['Tag'],'as':_0xbfd0('0x47'),'attributes':['id',_0xbfd0('0x2e'),_0xbfd0('0x4d')],'required':_0x553069[_0xbfd0('0x34')][_0xbfd0('0x48')]?!![]:![]}],'attributes':_[_0xbfd0('0x33')](_0x26c307)});})[_0xbfd0('0x29')](function(_0x30b83b){_0xd078aa=_0x30b83b[_0xbfd0('0x59')]({'plain':!![]});var _0x4ddb2a={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x30b83b&&_0x30b83b[_0xbfd0('0x7b')]){if(_0x30b83b[_0xbfd0('0x7b')]){_0x4ddb2a['where'][_0xbfd0('0x7f')]['push']({'ListId':{'$ne':_0x30b83b[_0xbfd0('0x7b')]}});}}return db['CmCustomField'][_0xbfd0('0x4e')](_0x4ddb2a);})['then'](function(_0x69e8d9){return _[_0xbfd0('0x80')](_0xd078aa,_[_0xbfd0('0x42')](_0x69e8d9,function(_0x413e50){return util[_0xbfd0('0x81')]('cf_%d',_0x413e50['id']);}));})['then'](handleEntityNotFound(_0x5d3f8e,null))[_0xbfd0('0x29')](respondWithResult(_0x5d3f8e,null))[_0xbfd0('0x52')](handleError(_0x5d3f8e,null));};exports[_0xbfd0('0x28')]=function(_0x59b19b,_0x4d5377){var _0x52ed40;if(_0x59b19b[_0xbfd0('0x58')]['id']){delete _0x59b19b['body']['id'];}return db[_0xbfd0('0x31')][_0xbfd0('0x50')]({'where':{'id':_0x59b19b[_0xbfd0('0x51')]['id']}})[_0xbfd0('0x29')](handleEntityNotFound(_0x4d5377,null))[_0xbfd0('0x29')](saveUpdates(_0x59b19b[_0xbfd0('0x58')],null))[_0xbfd0('0x29')](function(_0x421e90){_0x52ed40=_0x421e90;var _0x489878={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x421e90&&_0x421e90[_0xbfd0('0x7b')]){if(_0x421e90[_0xbfd0('0x7b')]){_0x489878[_0xbfd0('0x3e')][_0xbfd0('0x7f')]['push']({'ListId':{'$ne':_0x421e90[_0xbfd0('0x7b')]}});}}return db['CmCustomField'][_0xbfd0('0x4e')](_0x489878);})[_0xbfd0('0x29')](function(_0x50000d){if(_0x50000d){return _[_0xbfd0('0x80')](_[_0xbfd0('0x82')](_0x59b19b[_0xbfd0('0x58')],function(_0x563245,_0xea4ae9){return _[_0xbfd0('0x83')](_0xea4ae9,_0xbfd0('0x53'));}),_[_0xbfd0('0x42')](_0x50000d,function(_0x54bf39){return util['format'](_0xbfd0('0x84'),_0x54bf39['id']);}));}})[_0xbfd0('0x29')](function(_0x383801){if(_0x383801&&!_[_0xbfd0('0x85')](_0x383801)){var _0x24c576=squel[_0xbfd0('0x28')]()[_0xbfd0('0x86')](_0xbfd0('0x87'))['setFields'](_0x383801)[_0xbfd0('0x3e')](_0xbfd0('0x88'),_0x59b19b[_0xbfd0('0x51')]['id'])[_0xbfd0('0x89')]();return db[_0xbfd0('0x8a')][_0xbfd0('0x34')](_0x24c576[_0xbfd0('0x8b')],{'replacements':_0x24c576[_0xbfd0('0x8c')]});}})[_0xbfd0('0x29')](function(){if(_0x59b19b[_0xbfd0('0x58')][_0xbfd0('0x8d')]&&_0x52ed40){return db['CmHopper'][_0xbfd0('0x28')]({'phone':_0x59b19b['body']['phone']},{'where':{'ContactId':_0x52ed40['id']}});}})[_0xbfd0('0x29')](function(){return _0x52ed40;})[_0xbfd0('0x29')](respondWithResult(_0x4d5377,null))['catch'](handleError(_0x4d5377,null));};exports[_0xbfd0('0x8e')]=function(_0x5d2033,_0x3c921b,_0x23c49c){var _0x31a113={};var _0x53a47e={};var _0x303d55;var _0x34a83d;return db[_0xbfd0('0x31')][_0xbfd0('0x8f')]({'where':{'id':_0x5d2033[_0xbfd0('0x51')]['id']}})[_0xbfd0('0x29')](handleEntityNotFound(_0x3c921b,null))[_0xbfd0('0x29')](function(_0x488549){if(_0x488549){_0x303d55=_0x488549;_0x53a47e[_0xbfd0('0x36')]=_[_0xbfd0('0x33')](db[_0xbfd0('0x4b')][_0xbfd0('0x90')]);_0x53a47e['query']=_['keys'](_0x5d2033['query']);_0x53a47e[_0xbfd0('0x3f')]=_[_0xbfd0('0x35')](_0x53a47e['model'],_0x53a47e[_0xbfd0('0x34')]);_0x31a113['attributes']=_[_0xbfd0('0x35')](_0x53a47e[_0xbfd0('0x36')],qs['fields'](_0x5d2033[_0xbfd0('0x34')][_0xbfd0('0x37')]));_0x31a113[_0xbfd0('0x38')]=_0x31a113['attributes'][_0xbfd0('0x39')]?_0x31a113['attributes']:_0x53a47e['model'];_0x31a113[_0xbfd0('0x3c')]=qs['sort'](_0x5d2033[_0xbfd0('0x34')][_0xbfd0('0x3d')]);_0x31a113[_0xbfd0('0x3e')]=qs['filters'](_['pick'](_0x5d2033[_0xbfd0('0x34')],_0x53a47e[_0xbfd0('0x3f')]));if(_0x5d2033[_0xbfd0('0x34')][_0xbfd0('0x41')]){_0x31a113[_0xbfd0('0x3e')]=_[_0xbfd0('0x43')](_0x31a113[_0xbfd0('0x3e')],{'$or':_['map'](_0x31a113[_0xbfd0('0x38')],function(_0x31bc1c){var _0x12a927={};_0x12a927[_0x31bc1c]={'$like':'%'+_0x5d2033[_0xbfd0('0x34')][_0xbfd0('0x41')]+'%'};return _0x12a927;})});}_0x31a113=_['merge']({},_0x31a113,_0x5d2033[_0xbfd0('0x44')]);return _0x303d55[_0xbfd0('0x8e')](_0x31a113);}})[_0xbfd0('0x29')](function(_0x58110f){if(_0x58110f){_0x34a83d=_0x58110f[_0xbfd0('0x39')];if(!_0x5d2033[_0xbfd0('0x34')]['hasOwnProperty']('nolimit')){_0x31a113[_0xbfd0('0x22')]=qs['limit'](_0x5d2033[_0xbfd0('0x34')][_0xbfd0('0x22')]);_0x31a113[_0xbfd0('0x21')]=qs[_0xbfd0('0x21')](_0x5d2033[_0xbfd0('0x34')][_0xbfd0('0x21')]);}return _0x303d55[_0xbfd0('0x8e')](_0x31a113);}})['then'](function(_0x29dcf0){if(_0x29dcf0){return _0x29dcf0?{'count':_0x34a83d,'rows':_0x29dcf0}:null;}})[_0xbfd0('0x29')](respondWithResult(_0x3c921b,null))[_0xbfd0('0x52')](handleError(_0x3c921b,null));};exports[_0xbfd0('0x91')]=function(_0x3f8f42,_0x3d4659,_0x343a1d){if(_0x3f8f42[_0xbfd0('0x58')]['id']){delete _0x3f8f42['body']['id'];}return db['CmContact']['findOne']({'where':{'id':_0x3f8f42[_0xbfd0('0x51')]['id']}})['then'](handleEntityNotFound(_0x3d4659,null))[_0xbfd0('0x29')](function(_0x35f639){if(_0x35f639){return _0x35f639['setTags'](_0x3f8f42[_0xbfd0('0x58')][_0xbfd0('0x92')]||[]);}return null;})['then'](respondWithResult(_0x3d4659,null))[_0xbfd0('0x52')](handleError(_0x3d4659,null));};exports[_0xbfd0('0x93')]=function(_0x1d6806,_0xb227b1,_0x5465b8){var _0x2332c5={'raw':![],'where':{}};var _0xfe507c={};var _0x4e9de3={'count':0x0,'rows':[]};return db[_0xbfd0('0x31')][_0xbfd0('0x8f')]({'where':{'id':_0x1d6806['params']['id']}})[_0xbfd0('0x29')](handleEntityNotFound(_0xb227b1,null))[_0xbfd0('0x29')](function(_0x5e99b2){if(_0x5e99b2){_0xfe507c[_0xbfd0('0x36')]=_['keys'](db[_0xbfd0('0x61')][_0xbfd0('0x90')]);_0xfe507c['query']=_[_0xbfd0('0x33')](_0x1d6806[_0xbfd0('0x34')]);_0xfe507c[_0xbfd0('0x3f')]=_[_0xbfd0('0x35')](_0xfe507c[_0xbfd0('0x36')],_0xfe507c[_0xbfd0('0x34')]);_0x2332c5[_0xbfd0('0x38')]=_[_0xbfd0('0x35')](_0xfe507c[_0xbfd0('0x36')],qs[_0xbfd0('0x37')](_0x1d6806[_0xbfd0('0x34')][_0xbfd0('0x37')]));_0x2332c5[_0xbfd0('0x38')]=_0x2332c5[_0xbfd0('0x38')][_0xbfd0('0x39')]?_0x2332c5[_0xbfd0('0x38')]:_0xfe507c['model'];if(!_0x1d6806['query'][_0xbfd0('0x3a')](_0xbfd0('0x3b'))){_0x2332c5[_0xbfd0('0x22')]=qs[_0xbfd0('0x22')](_0x1d6806[_0xbfd0('0x34')][_0xbfd0('0x22')]);_0x2332c5[_0xbfd0('0x21')]=qs[_0xbfd0('0x21')](_0x1d6806[_0xbfd0('0x34')]['offset']);}_0x2332c5[_0xbfd0('0x3c')]=qs['sort'](_0x1d6806[_0xbfd0('0x34')][_0xbfd0('0x3d')]);_0x2332c5[_0xbfd0('0x3e')]=qs['filters'](_[_0xbfd0('0x40')](_0x1d6806['query'],_0xfe507c[_0xbfd0('0x3f')]));_0x2332c5[_0xbfd0('0x3e')][_0xbfd0('0x94')]=_0x5e99b2['id'];if(_0x1d6806[_0xbfd0('0x34')][_0xbfd0('0x41')]){_0x2332c5[_0xbfd0('0x3e')]=_[_0xbfd0('0x43')](_0x2332c5[_0xbfd0('0x3e')],{'$or':_['map'](_0x2332c5[_0xbfd0('0x38')],function(_0x55b424){var _0x562982={};_0x562982[_0x55b424]={'$like':'%'+_0x1d6806[_0xbfd0('0x34')][_0xbfd0('0x41')]+'%'};return _0x562982;})});}_0x2332c5=_['merge']({},_0x2332c5,_0x1d6806[_0xbfd0('0x44')]);return db[_0xbfd0('0x61')][_0xbfd0('0x20')]({'where':_0x2332c5[_0xbfd0('0x3e')]})['then'](function(_0x34999b){_0x4e9de3[_0xbfd0('0x20')]=_0x34999b;if(_0x1d6806[_0xbfd0('0x34')]['includeAll']){_0x2332c5[_0xbfd0('0x45')]=[{'all':!![]}];}return db['CmHopper'][_0xbfd0('0x4e')](_0x2332c5);})[_0xbfd0('0x29')](function(_0xce60f6){_0x4e9de3[_0xbfd0('0x4f')]=_0xce60f6;return _0x4e9de3;});}})[_0xbfd0('0x29')](respondWithFilteredResult(_0xb227b1,_0x2332c5))['catch'](handleError(_0xb227b1,null));};exports[_0xbfd0('0x95')]=function(_0x141bc2,_0x557e7f,_0x65664c){var _0x1af7a3={'raw':!![],'where':{}};var _0x46a6ab={};var _0x1c39ab={'count':0x0,'rows':[]};return db['CmContact'][_0xbfd0('0x8f')]({'where':{'id':_0x141bc2['params']['id']}})[_0xbfd0('0x29')](handleEntityNotFound(_0x557e7f,null))[_0xbfd0('0x29')](function(_0x5f0e97){if(_0x5f0e97){_0x46a6ab['model']=_[_0xbfd0('0x33')](db[_0xbfd0('0x6f')][_0xbfd0('0x90')]);_0x46a6ab[_0xbfd0('0x34')]=_['keys'](_0x141bc2[_0xbfd0('0x34')]);_0x46a6ab['filters']=_[_0xbfd0('0x35')](_0x46a6ab[_0xbfd0('0x36')],_0x46a6ab['query']);_0x1af7a3[_0xbfd0('0x38')]=_['intersection'](_0x46a6ab['model'],qs[_0xbfd0('0x37')](_0x141bc2[_0xbfd0('0x34')]['fields']));_0x1af7a3[_0xbfd0('0x38')]=_0x1af7a3['attributes']['length']?_0x1af7a3['attributes']:_0x46a6ab[_0xbfd0('0x36')];if(!_0x141bc2[_0xbfd0('0x34')][_0xbfd0('0x3a')](_0xbfd0('0x3b'))){_0x1af7a3[_0xbfd0('0x22')]=qs[_0xbfd0('0x22')](_0x141bc2[_0xbfd0('0x34')][_0xbfd0('0x22')]);_0x1af7a3[_0xbfd0('0x21')]=qs[_0xbfd0('0x21')](_0x141bc2[_0xbfd0('0x34')][_0xbfd0('0x21')]);}_0x1af7a3[_0xbfd0('0x3c')]=qs[_0xbfd0('0x3d')](_0x141bc2[_0xbfd0('0x34')]['sort']);_0x1af7a3[_0xbfd0('0x3e')]=qs[_0xbfd0('0x3f')](_['pick'](_0x141bc2[_0xbfd0('0x34')],_0x46a6ab['filters']));_0x1af7a3[_0xbfd0('0x3e')][_0xbfd0('0x94')]=_0x5f0e97['id'];if(_0x141bc2[_0xbfd0('0x34')][_0xbfd0('0x41')]){_0x1af7a3[_0xbfd0('0x3e')]=_['merge'](_0x1af7a3[_0xbfd0('0x3e')],{'$or':_[_0xbfd0('0x42')](_0x1af7a3[_0xbfd0('0x38')],function(_0x1535eb){var _0x5d19e5={};_0x5d19e5[_0x1535eb]={'$like':'%'+_0x141bc2[_0xbfd0('0x34')]['filter']+'%'};return _0x5d19e5;})});}_0x1af7a3=_['merge']({},_0x1af7a3,_0x141bc2[_0xbfd0('0x44')]);return db[_0xbfd0('0x6f')][_0xbfd0('0x20')]({'where':_0x1af7a3[_0xbfd0('0x3e')]})[_0xbfd0('0x29')](function(_0xb8339e){_0x1c39ab[_0xbfd0('0x20')]=_0xb8339e;if(_0x141bc2[_0xbfd0('0x34')][_0xbfd0('0x4a')]){_0x1af7a3['include']=[{'all':!![]}];}return db[_0xbfd0('0x6f')]['findAll'](_0x1af7a3);})[_0xbfd0('0x29')](function(_0x4cba49){_0x1c39ab[_0xbfd0('0x4f')]=_0x4cba49;return _0x1c39ab;});}})[_0xbfd0('0x29')](respondWithFilteredResult(_0x557e7f,_0x1af7a3))['catch'](handleError(_0x557e7f,null));};exports['getHopperFinals']=function(_0x34a0e0,_0x247093,_0x30fb82){var _0x59c2ad={'raw':!![],'where':{}};var _0x5b9166={};var _0x1de97b={'count':0x0,'rows':[]};return db[_0xbfd0('0x31')][_0xbfd0('0x8f')]({'where':{'id':_0x34a0e0[_0xbfd0('0x51')]['id']}})[_0xbfd0('0x29')](handleEntityNotFound(_0x247093,null))[_0xbfd0('0x29')](function(_0xae5a8b){if(_0xae5a8b){_0x5b9166[_0xbfd0('0x36')]=_[_0xbfd0('0x33')](db['CmHopperFinal'][_0xbfd0('0x90')]);_0x5b9166[_0xbfd0('0x34')]=_[_0xbfd0('0x33')](_0x34a0e0[_0xbfd0('0x34')]);_0x5b9166[_0xbfd0('0x3f')]=_[_0xbfd0('0x35')](_0x5b9166[_0xbfd0('0x36')],_0x5b9166[_0xbfd0('0x34')]);_0x59c2ad[_0xbfd0('0x38')]=_[_0xbfd0('0x35')](_0x5b9166[_0xbfd0('0x36')],qs['fields'](_0x34a0e0[_0xbfd0('0x34')][_0xbfd0('0x37')]));_0x59c2ad['attributes']=_0x59c2ad[_0xbfd0('0x38')][_0xbfd0('0x39')]?_0x59c2ad[_0xbfd0('0x38')]:_0x5b9166[_0xbfd0('0x36')];if(!_0x34a0e0['query'][_0xbfd0('0x3a')](_0xbfd0('0x3b'))){_0x59c2ad[_0xbfd0('0x22')]=qs['limit'](_0x34a0e0['query'][_0xbfd0('0x22')]);_0x59c2ad[_0xbfd0('0x21')]=qs[_0xbfd0('0x21')](_0x34a0e0[_0xbfd0('0x34')][_0xbfd0('0x21')]);}_0x59c2ad[_0xbfd0('0x3c')]=qs[_0xbfd0('0x3d')](_0x34a0e0['query'][_0xbfd0('0x3d')]);_0x59c2ad[_0xbfd0('0x3e')]=qs[_0xbfd0('0x3f')](_['pick'](_0x34a0e0[_0xbfd0('0x34')],_0x5b9166[_0xbfd0('0x3f')]));_0x59c2ad['where'][_0xbfd0('0x94')]=_0xae5a8b['id'];if(_0x34a0e0[_0xbfd0('0x34')][_0xbfd0('0x41')]){_0x59c2ad[_0xbfd0('0x3e')]=_['merge'](_0x59c2ad[_0xbfd0('0x3e')],{'$or':_[_0xbfd0('0x42')](_0x59c2ad['attributes'],function(_0x4fc0c0){var _0x230cd6={};_0x230cd6[_0x4fc0c0]={'$like':'%'+_0x34a0e0['query'][_0xbfd0('0x41')]+'%'};return _0x230cd6;})});}_0x59c2ad=_['merge']({},_0x59c2ad,_0x34a0e0[_0xbfd0('0x44')]);return db[_0xbfd0('0x6e')][_0xbfd0('0x20')]({'where':_0x59c2ad[_0xbfd0('0x3e')]})[_0xbfd0('0x29')](function(_0x343417){_0x1de97b[_0xbfd0('0x20')]=_0x343417;if(_0x34a0e0[_0xbfd0('0x34')]['includeAll']){_0x59c2ad[_0xbfd0('0x45')]=[{'all':!![]}];}return db[_0xbfd0('0x6e')]['findAll'](_0x59c2ad);})[_0xbfd0('0x29')](function(_0x22b8fd){_0x1de97b[_0xbfd0('0x4f')]=_0x22b8fd;return _0x1de97b;});}})[_0xbfd0('0x29')](respondWithFilteredResult(_0x247093,_0x59c2ad))['catch'](handleError(_0x247093,null));};exports[_0xbfd0('0x96')]=function(_0x13914d,_0x73a8be,_0x6c9f89){var _0x303484={'raw':!![],'where':{}};var _0x4cdda2={};var _0x14c071={'count':0x0,'rows':[]};return db[_0xbfd0('0x31')][_0xbfd0('0x8f')]({'where':{'id':_0x13914d['params']['id']}})[_0xbfd0('0x29')](handleEntityNotFound(_0x73a8be,null))[_0xbfd0('0x29')](function(_0x1068a7){if(_0x1068a7){_0x4cdda2[_0xbfd0('0x36')]=_[_0xbfd0('0x33')](db[_0xbfd0('0x77')][_0xbfd0('0x90')]);_0x4cdda2[_0xbfd0('0x34')]=_[_0xbfd0('0x33')](_0x13914d[_0xbfd0('0x34')]);_0x4cdda2[_0xbfd0('0x3f')]=_[_0xbfd0('0x35')](_0x4cdda2[_0xbfd0('0x36')],_0x4cdda2['query']);_0x303484[_0xbfd0('0x38')]=_[_0xbfd0('0x35')](_0x4cdda2[_0xbfd0('0x36')],qs[_0xbfd0('0x37')](_0x13914d[_0xbfd0('0x34')]['fields']));_0x303484['attributes']=_0x303484['attributes'][_0xbfd0('0x39')]?_0x303484['attributes']:_0x4cdda2[_0xbfd0('0x36')];if(!_0x13914d['query'][_0xbfd0('0x3a')](_0xbfd0('0x3b'))){_0x303484[_0xbfd0('0x22')]=qs[_0xbfd0('0x22')](_0x13914d['query'][_0xbfd0('0x22')]);_0x303484['offset']=qs[_0xbfd0('0x21')](_0x13914d[_0xbfd0('0x34')][_0xbfd0('0x21')]);}_0x303484[_0xbfd0('0x3c')]=qs[_0xbfd0('0x3d')](_0x13914d[_0xbfd0('0x34')]['sort']);_0x303484[_0xbfd0('0x3e')]=qs[_0xbfd0('0x3f')](_[_0xbfd0('0x40')](_0x13914d[_0xbfd0('0x34')],_0x4cdda2[_0xbfd0('0x3f')]));_0x303484[_0xbfd0('0x3e')][_0xbfd0('0x94')]=_0x1068a7['id'];if(_0x13914d[_0xbfd0('0x34')][_0xbfd0('0x41')]){_0x303484[_0xbfd0('0x3e')]=_[_0xbfd0('0x43')](_0x303484['where'],{'$or':_[_0xbfd0('0x42')](_0x303484['attributes'],function(_0x41782a){var _0x545e69={};_0x545e69[_0x41782a]={'$like':'%'+_0x13914d[_0xbfd0('0x34')][_0xbfd0('0x41')]+'%'};return _0x545e69;})});}_0x303484=_[_0xbfd0('0x43')]({},_0x303484,_0x13914d[_0xbfd0('0x44')]);return db[_0xbfd0('0x77')][_0xbfd0('0x20')]({'where':_0x303484[_0xbfd0('0x3e')]})[_0xbfd0('0x29')](function(_0x1b1879){_0x14c071[_0xbfd0('0x20')]=_0x1b1879;if(_0x13914d[_0xbfd0('0x34')]['includeAll']){_0x303484[_0xbfd0('0x45')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0xbfd0('0x4e')](_0x303484);})[_0xbfd0('0x29')](function(_0x5283c4){_0x14c071['rows']=_0x5283c4;return _0x14c071;});}})[_0xbfd0('0x29')](respondWithFilteredResult(_0x73a8be,_0x303484))['catch'](handleError(_0x73a8be,null));};exports[_0xbfd0('0x97')]=function(_0x43f46f,_0x459a8d,_0x1830db){try{if(!_0x43f46f[_0xbfd0('0x58')][_0xbfd0('0x7b')]){throw new Error(_0xbfd0('0x98'));}if(!_0x43f46f[_0xbfd0('0x58')]['binding_keys']){throw new Error(_0xbfd0('0x99'));}if(!_0x43f46f['body']['binding_values']){throw new Error(_0xbfd0('0x9a'));}if(!_0x43f46f[_0xbfd0('0x58')][_0xbfd0('0x9b')]){throw new Error(_0xbfd0('0x9c'));}var _0xc3fd81=_0x43f46f[_0xbfd0('0x58')][_0xbfd0('0x9d')][_0xbfd0('0x9e')](',');var _0x61a34d=_0x43f46f[_0xbfd0('0x58')][_0xbfd0('0x9f')][_0xbfd0('0x9e')](',');if(!_0xc3fd81[_0xbfd0('0x39')]||!_0x61a34d['length']||_0xc3fd81['length']!==_0x61a34d['length']){throw new Error(_0xbfd0('0xa0'));}_0x43f46f[_0xbfd0('0x58')][_0xbfd0('0x37')]=_[_0xbfd0('0xa1')](_0xc3fd81,_0x61a34d);if(!_0x43f46f[_0xbfd0('0x58')][_0xbfd0('0x37')]['phone']){throw new Error(_0xbfd0('0xa2'));}if(!_0x43f46f[_0xbfd0('0x58')][_0xbfd0('0x37')]['firstName']){throw new Error(_0xbfd0('0xa3'));}var _0x27d7ed=path[_0xbfd0('0x5d')](config[_0xbfd0('0xa4')],_0xbfd0('0xa5'),_0x43f46f[_0xbfd0('0xa6')][_0xbfd0('0xa7')]);fs['chmodSync'](_0x27d7ed,parseInt(_0xbfd0('0xa8'),0x8));var _0x4df912=require(_0xbfd0('0xa9'))[_0xbfd0('0xaa')](path[_0xbfd0('0x5d')](__dirname,'../../components/import/cm/csv'),[_0x27d7ed,_0x43f46f[_0xbfd0('0x58')][_0xbfd0('0x9d')],_0x43f46f['body'][_0xbfd0('0x9f')],_0x43f46f[_0xbfd0('0x58')][_0xbfd0('0x7b')],_0x43f46f[_0xbfd0('0x58')]['CompanyId'],_0x43f46f[_0xbfd0('0x58')]['duplicates'],_0x43f46f[_0xbfd0('0x58')][_0xbfd0('0x9b')]]);return _0x459a8d[_0xbfd0('0x1e')](0xc8)['json']({'message':'File\x20uploaded\x20correctly!','pid':_0x4df912[_0xbfd0('0xab')]});}catch(_0x4a8f68){return _0x459a8d['status'](0x1f4)[_0xbfd0('0x2f')](_0x4a8f68);}};exports[_0xbfd0('0xac')]=function(_0x2003f2,_0x33b2d8,_0x3d7e3b){var _0x10abcd=fs[_0xbfd0('0xad')](_0x2003f2[_0xbfd0('0xa6')][_0xbfd0('0x8')]);Papa[_0xbfd0('0xae')](_0x10abcd,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x2e7a43){return _0x33b2d8['status'](0xc8)[_0xbfd0('0x1f')]({'file':_0x2003f2['file'],'fields':_0x2e7a43[_0xbfd0('0xaf')]['fields']});}});};exports[_0xbfd0('0xb0')]=function(_0x1e36ed,_0x4186c4,_0x3f3b13){return db['User'][_0xbfd0('0x4e')]({'raw':!![],'attributes':['id'],'where':{'role':_0xbfd0('0xb1')}})[_0xbfd0('0x29')](function(_0xbc1e97){var _0x1e5937=![];if(!_0x1e36ed['body'][_0xbfd0('0x7b')]){throw new Error(_0xbfd0('0x98'));}if(!_0x1e36ed[_0xbfd0('0x58')][_0xbfd0('0xb2')][_0xbfd0('0x8d')]){throw new Error(_0xbfd0('0xa2'));}if(!_0x1e36ed[_0xbfd0('0x58')][_0xbfd0('0xb2')]['firstName']){throw new Error('No\x20firstName\x20column\x20specified');}if(!_0x1e36ed[_0xbfd0('0x58')][_0xbfd0('0x9b')]){throw new Error(_0xbfd0('0x9c'));}var _0xfebcee=require(_0xbfd0('0xa9'))[_0xbfd0('0xaa')](path[_0xbfd0('0x5d')](__dirname,_0xbfd0('0xb3')),[_0x1e36ed[_0xbfd0('0x51')]['id'],JSON['stringify'](_0x1e36ed[_0xbfd0('0x58')]),JSON[_0xbfd0('0xb4')](_0xbc1e97)]);_0xfebcee['on']('message',function(_0x455b46){_0x1e5937=!![];return _0x4186c4[_0xbfd0('0x1e')](0xc8)['json']({'message':_0xbfd0('0xb5'),'pid':_0xfebcee['pid']});});_0xfebcee['on'](_0xbfd0('0xb6'),function(_0x53f471){if(_0x53f471&&!_0x1e5937){return _0x4186c4[_0xbfd0('0x1e')](0x1f4)[_0xbfd0('0x1f')]({'message':_0xbfd0('0xb7'),'pid':_0xfebcee[_0xbfd0('0xab')]});}});})[_0xbfd0('0x52')](handleError(_0x4186c4,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff