// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xe634=['fork','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','pid','send','upload','createReadStream','parse','import','User','binding','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','../../components/import/cm/csv2','start\x20child\x20process\x20correctly!','exit','html-pdf','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','lodash','squel','crypto','jsforce','desk.js','to-csv','papaparse','ioredis','api','../../config/utils','../../config/environment','redis','defaults','socket.io-emitter','./cmContact.socket','register','sendStatus','status','end','json','count','offset','limit','set','Content-Range','reject','update','then','error','stack','name','index','CmContact','describe','model','query','filters','intersection','fields','attributes','length','hasOwnProperty','order','sort','where','filter','map','merge','options','include','push','Tag','tag','distinct','includeAll','Tags','color','ThroughTags','findAll','rows','catch','keys','startsWith','cf_','displayName','CmCustomField','alias','columnName','body','from','get','mergeWith','tags','isArray','join','info','CmHopper','destroy','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','ReportAgentPreview','VoiceCallReport','ChatQueueReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','create','bulkCreate','each','duplicates','$or','ListId','findOrCreate','find','$and','cf_%d','omit','pickBy','format','isEmpty','table','cm_contacts','setFields','id\x20=\x20?','params','toParam','sequelize','text','values','phone','getTags','pick','setTags','findOne','rawAttributes','nolimit','CmHopperHistory','ContactId','getHopperFinals','getJscriptySessions','No\x20ListId\x20specified','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','binding_keys','split','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','server/files/tmp','file','filename','chmodSync','0777','child_process'];(function(_0x1655bb,_0x5a82ae){var _0x5e2020=function(_0x1ccfb4){while(--_0x1ccfb4){_0x1655bb['push'](_0x1655bb['shift']());}};_0x5e2020(++_0x5a82ae);}(_0xe634,0x178));var _0x4e63=function(_0x1d6ccb,_0x3d9e5e){_0x1d6ccb=_0x1d6ccb-0x0;var _0x3b2b1=_0xe634[_0x1d6ccb];return _0x3b2b1;};'use strict';var pdf=require(_0x4e63('0x0'));var emlformat=require(_0x4e63('0x1'));var rimraf=require(_0x4e63('0x2'));var zipdir=require(_0x4e63('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0x4e63('0x4'));var moment=require(_0x4e63('0x5'));var BPromise=require(_0x4e63('0x6'));var Mustache=require(_0x4e63('0x7'));var util=require(_0x4e63('0x8'));var path=require(_0x4e63('0x9'));var sox=require(_0x4e63('0xa'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var _=require(_0x4e63('0xb'));var squel=require(_0x4e63('0xc'));var crypto=require(_0x4e63('0xd'));var jsforce=require(_0x4e63('0xe'));var deskjs=require(_0x4e63('0xf'));var toCsv=require(_0x4e63('0x10'));var querystring=require('querystring');var Papa=require(_0x4e63('0x11'));var authService=require('../../components/auth/service');var hardwareService=require('../../config/license/hardware');var Redis=require(_0x4e63('0x12'));var qs=require('../../components/parsers/qs');var logger=require('../../config/logger')(_0x4e63('0x13'));var utils=require(_0x4e63('0x14'));var config=require(_0x4e63('0x15'));var db=require('../../mysqldb')['db'];config[_0x4e63('0x16')]=_[_0x4e63('0x17')](config[_0x4e63('0x16')],{'host':'localhost','port':0x18eb});var socket=require(_0x4e63('0x18'))(new Redis(config[_0x4e63('0x16')]));require(_0x4e63('0x19'))[_0x4e63('0x1a')](socket);function respondWithStatusCode(_0x5e2c3a,_0x4c699c){_0x4c699c=_0x4c699c||0xcc;return function(_0x2e8f2f){if(_0x2e8f2f){return _0x5e2c3a[_0x4e63('0x1b')](_0x4c699c);}return _0x5e2c3a[_0x4e63('0x1c')](_0x4c699c)[_0x4e63('0x1d')]();};}function respondWithResult(_0x1d18d9,_0x5d1df4){_0x5d1df4=_0x5d1df4||0xc8;return function(_0x2969e1){if(_0x2969e1){return _0x1d18d9[_0x4e63('0x1c')](_0x5d1df4)[_0x4e63('0x1e')](_0x2969e1);}};}function respondWithFilteredResult(_0x226bb7,_0x3e9a3a){return function(_0x25c9ed){if(_0x25c9ed){var _0x5d1ca3=_0x25c9ed[_0x4e63('0x1f')],_0x3bb062=_0x3e9a3a[_0x4e63('0x20')],_0x50dd9a=_0x3e9a3a[_0x4e63('0x20')]+_0x3e9a3a[_0x4e63('0x21')],_0x2b605d;if(_0x50dd9a>=_0x5d1ca3){_0x50dd9a=_0x5d1ca3;_0x2b605d=0xc8;}else{_0x2b605d=0xce;}_0x226bb7[_0x4e63('0x1c')](_0x2b605d);return _0x226bb7[_0x4e63('0x22')](_0x4e63('0x23'),_0x3bb062+'-'+_0x50dd9a+'/'+_0x5d1ca3)['json'](_0x25c9ed);}return null;};}function patchUpdates(_0x3bfee3){return function(_0x2fb51d){try{jsonpatch['apply'](_0x2fb51d,_0x3bfee3,!![]);}catch(_0x4fc3c0){return BPromise[_0x4e63('0x24')](_0x4fc3c0);}return _0x2fb51d['save']();};}function saveUpdates(_0x52deea,_0x388e9e){return function(_0x5b4204){if(_0x5b4204){return _0x5b4204[_0x4e63('0x25')](_0x52deea)[_0x4e63('0x26')](function(_0x1cd9f3){return _0x1cd9f3;});}return null;};}function removeEntity(_0x70abcc,_0x25d562){return function(_0x24e5d8){if(_0x24e5d8){return _0x24e5d8['destroy']()[_0x4e63('0x26')](function(){_0x70abcc[_0x4e63('0x1c')](0xcc)[_0x4e63('0x1d')]();});}};}function handleEntityNotFound(_0x49ebf2,_0x115ce3){return function(_0x1df272){if(!_0x1df272){_0x49ebf2[_0x4e63('0x1b')](0x194);}return _0x1df272;};}function handleError(_0x4a025c,_0x6af107){_0x6af107=_0x6af107||0x1f4;return function(_0x5977f9){logger[_0x4e63('0x27')](_0x5977f9[_0x4e63('0x28')]);if(_0x5977f9['name']){delete _0x5977f9[_0x4e63('0x29')];}_0x4a025c[_0x4e63('0x1c')](_0x6af107)['send'](_0x5977f9);};}exports[_0x4e63('0x2a')]=function(_0x9cc316,_0x92f141){var _0x34affe={},_0x4deca9={},_0x2c2eba={'count':0x0,'rows':[]};return db[_0x4e63('0x2b')][_0x4e63('0x2c')]()[_0x4e63('0x26')](function(_0x48f6a5){_0x4deca9[_0x4e63('0x2d')]=_['keys'](_0x48f6a5);_0x4deca9['query']=_['keys'](_0x9cc316[_0x4e63('0x2e')]);_0x4deca9[_0x4e63('0x2f')]=_[_0x4e63('0x30')](_0x4deca9[_0x4e63('0x2d')],_0x4deca9['query']);_0x34affe['attributes']=_[_0x4e63('0x30')](_0x4deca9[_0x4e63('0x2d')],qs[_0x4e63('0x31')](_0x9cc316[_0x4e63('0x2e')]['fields']));_0x34affe[_0x4e63('0x32')]=_0x34affe[_0x4e63('0x32')][_0x4e63('0x33')]?_0x34affe[_0x4e63('0x32')]:_0x4deca9[_0x4e63('0x2d')];if(!_0x9cc316['query'][_0x4e63('0x34')]('nolimit')){_0x34affe[_0x4e63('0x21')]=qs[_0x4e63('0x21')](_0x9cc316[_0x4e63('0x2e')][_0x4e63('0x21')]);_0x34affe[_0x4e63('0x20')]=qs[_0x4e63('0x20')](_0x9cc316[_0x4e63('0x2e')]['offset']);}_0x34affe[_0x4e63('0x35')]=qs[_0x4e63('0x36')](_0x9cc316[_0x4e63('0x2e')]['sort']);_0x34affe[_0x4e63('0x37')]=qs[_0x4e63('0x2f')](_['pick'](_0x9cc316[_0x4e63('0x2e')],_0x4deca9[_0x4e63('0x2f')]));if(_0x9cc316[_0x4e63('0x2e')][_0x4e63('0x38')]){_0x34affe[_0x4e63('0x37')]=_['merge'](_0x34affe[_0x4e63('0x37')],{'$or':_[_0x4e63('0x39')](_0x34affe[_0x4e63('0x32')],function(_0x325d82){var _0x110e54={};_0x110e54[_0x325d82]={'$like':'%'+_0x9cc316[_0x4e63('0x2e')][_0x4e63('0x38')]+'%'};return _0x110e54;})});}_0x34affe=_[_0x4e63('0x3a')]({},_0x34affe,_0x9cc316[_0x4e63('0x3b')]);var _0x2132a4={'where':_0x34affe[_0x4e63('0x37')]};_0x2132a4[_0x4e63('0x3c')]=[];if(_0x9cc316[_0x4e63('0x2e')]['tag']){_0x2132a4['include'][_0x4e63('0x3d')]({'model':db[_0x4e63('0x3e')],'as':'Tags','attributes':['id'],'where':{'id':_0x9cc316[_0x4e63('0x2e')][_0x4e63('0x3f')]},'required':!![]});_0x2132a4[_0x4e63('0x40')]=!![];}return db[_0x4e63('0x2b')][_0x4e63('0x1f')](_0x2132a4)[_0x4e63('0x26')](function(_0x4603ae){_0x2c2eba[_0x4e63('0x1f')]=_0x4603ae;if(_0x9cc316['query'][_0x4e63('0x41')]){_0x34affe[_0x4e63('0x3c')]=[{'model':db['Tag'],'as':_0x4e63('0x42'),'attributes':['id',_0x4e63('0x29'),_0x4e63('0x43')],'required':_0x9cc316[_0x4e63('0x2e')][_0x4e63('0x3f')]?!![]:![]},{'model':db[_0x4e63('0x3e')],'as':_0x4e63('0x44'),'attributes':['id','name',_0x4e63('0x43')],'through':_0x9cc316[_0x4e63('0x2e')][_0x4e63('0x3f')]?{'attributes':[],'where':{'TagId':_0x9cc316[_0x4e63('0x2e')][_0x4e63('0x3f')]||undefined}}:{},'required':_0x9cc316[_0x4e63('0x2e')]['tag']?!![]:![]}];}return db['CmContact'][_0x4e63('0x45')](_0x34affe);})[_0x4e63('0x26')](function(_0x46c684){_0x2c2eba[_0x4e63('0x46')]=_0x46c684;return _0x2c2eba;})[_0x4e63('0x26')](respondWithFilteredResult(_0x92f141,_0x34affe))[_0x4e63('0x47')](handleError(_0x92f141,null));});};exports['destroy']=function(_0x2bd080,_0x14e9fe){return db[_0x4e63('0x2b')]['find']({'where':{'id':_0x2bd080['params']['id']}})[_0x4e63('0x26')](handleEntityNotFound(_0x14e9fe,null))[_0x4e63('0x26')](removeEntity(_0x14e9fe,null))[_0x4e63('0x47')](handleError(_0x14e9fe,null));};exports[_0x4e63('0x2c')]=function(_0x3f41ca,_0x38500e){return db[_0x4e63('0x2b')][_0x4e63('0x2c')]()['then'](function(_0x491ad5){for(var _0x143dc7=0x0;_0x143dc7<Object['keys'](_0x491ad5)[_0x4e63('0x33')];_0x143dc7++){var _0x93474b=Object[_0x4e63('0x48')](_0x491ad5)[_0x143dc7];if(!_[_0x4e63('0x49')](_0x93474b,_0x4e63('0x4a'))){_0x491ad5[_0x93474b]['columnName']=_0x93474b;_0x491ad5[_0x93474b][_0x4e63('0x4b')]=_0x93474b;}}return _0x491ad5;})['then'](function(_0x204b28){var _0x1853b3={'where':{'$or':[{'ListId':_0x3f41ca['query']['id']},{'ListId':null}]},'raw':!![]};return db[_0x4e63('0x4c')]['findAll'](_0x1853b3)['then'](function(_0x27b362){for(var _0x4dcb52=0x0;_0x4dcb52<_0x27b362[_0x4e63('0x33')];_0x4dcb52++){var _0x40cae1=_0x4e63('0x4a')+_0x27b362[_0x4dcb52]['id'];_0x204b28[_0x40cae1]['columnName']=_0x40cae1;_0x204b28[_0x40cae1][_0x4e63('0x4b')]=_0x27b362[_0x4dcb52][_0x4e63('0x4d')];}for(var _0x4dcb52=0x0;_0x4dcb52<Object[_0x4e63('0x48')](_0x204b28)[_0x4e63('0x33')];_0x4dcb52++){var _0x40cae1=Object[_0x4e63('0x48')](_0x204b28)[_0x4dcb52];if(!_0x204b28[_0x40cae1]['hasOwnProperty'](_0x4e63('0x4e'))){delete _0x204b28[_0x40cae1];}}return _0x204b28;});})[_0x4e63('0x26')](respondWithResult(_0x38500e,null))[_0x4e63('0x47')](handleError(_0x38500e,null));};exports[_0x4e63('0x3a')]=function(_0x33a38d,_0x202d3d){var _0x154171;var _0x3990be;var _0xd1fb73;if(_0x33a38d[_0x4e63('0x4f')]['id']){delete _0x33a38d[_0x4e63('0x4f')]['id'];}return db[_0x4e63('0x2b')][_0x4e63('0x45')]({'where':{'id':[_0x33a38d[_0x4e63('0x4f')]['to'],_0x33a38d[_0x4e63('0x4f')][_0x4e63('0x50')]]}})[_0x4e63('0x26')](function(_0x1768de){if(_0x1768de){if(_0x1768de[_0x4e63('0x33')]!==0x2){return null;}_0x1768de[0x0]=_0x1768de[0x0][_0x4e63('0x51')]({'plain':!![]});_0x1768de[0x1]=_0x1768de[0x1]['get']({'plain':!![]});delete _0x1768de[0x0]['id'];delete _0x1768de[0x1]['id'];return _[_0x4e63('0x52')](_0x1768de[0x0],_0x1768de[0x1],function(_0x428e44,_0x228096){if(Array['isArray'](_0x228096)&&!_0x228096[_0x4e63('0x33')]){return _0x428e44;}else if(!_0x228096){return _0x428e44;}});}})[_0x4e63('0x26')](handleEntityNotFound(_0x202d3d,null))[_0x4e63('0x26')](function(_0xf8bbf2){if(_0xf8bbf2){if(_0xf8bbf2[_0x4e63('0x53')]&&_[_0x4e63('0x54')](_0xf8bbf2[_0x4e63('0x53')])){_0xf8bbf2['tags']=_0xf8bbf2['tags'][_0x4e63('0x55')]();}logger[_0x4e63('0x56')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x33a38d[_0x4e63('0x4f')]['to'],_0x33a38d['body'][_0x4e63('0x50')]);return db[_0x4e63('0x57')][_0x4e63('0x58')]({'where':{'ContactId':[_0x33a38d['body']['to'],_0x33a38d[_0x4e63('0x4f')][_0x4e63('0x50')]]}})['then'](function(_0x37384e){logger[_0x4e63('0x56')](_0x4e63('0x59'),_0x37384e);return db[_0x4e63('0x5a')][_0x4e63('0x58')]({'where':{'ContactId':[_0x33a38d['body']['to'],_0x33a38d['body'][_0x4e63('0x50')]]}})[_0x4e63('0x26')](function(_0x4f0dbf){logger[_0x4e63('0x56')](_0x4e63('0x5b'),_0x4f0dbf);return db['CmContact']['create'](_0xf8bbf2);});});}})[_0x4e63('0x26')](function(_0x400a50){if(_0x400a50){_0x154171=_0x400a50;_0x3990be={'ContactId':_0x154171['id']};_0xd1fb73={'where':{'ContactId':[_0x33a38d[_0x4e63('0x4f')]['to'],_0x33a38d[_0x4e63('0x4f')][_0x4e63('0x50')]]}};return db[_0x4e63('0x5c')][_0x4e63('0x25')](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x5d')][_0x4e63('0x25')](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x5e')]['update'](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x5f')][_0x4e63('0x25')](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x60')]['update'](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x5f')]['update'](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x60')][_0x4e63('0x25')](_0x3990be,_0xd1fb73);}})['then'](function(){if(_0x154171){return db[_0x4e63('0x61')]['update'](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x62')][_0x4e63('0x25')](_0x3990be,_0xd1fb73);}})['then'](function(){if(_0x154171){return db[_0x4e63('0x63')][_0x4e63('0x25')](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x64')][_0x4e63('0x25')](_0x3990be,_0xd1fb73);}})['then'](function(){if(_0x154171){return db[_0x4e63('0x65')][_0x4e63('0x25')](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x66')][_0x4e63('0x25')](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x67')]['update'](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db['CmHopperHistory']['update'](_0x3990be,_0xd1fb73);}})['then'](function(){if(_0x154171){return db[_0x4e63('0x68')][_0x4e63('0x25')](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x69')][_0x4e63('0x25')](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x6a')][_0x4e63('0x25')](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x6b')][_0x4e63('0x25')](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x6c')][_0x4e63('0x25')](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x6d')][_0x4e63('0x25')](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x6e')][_0x4e63('0x25')](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x6f')]['update'](_0x3990be,_0xd1fb73);}})[_0x4e63('0x26')](function(){if(_0x154171){return db[_0x4e63('0x2b')][_0x4e63('0x58')]({'where':{'id':[_0x33a38d['body']['to'],_0x33a38d['body'][_0x4e63('0x50')]]}});}})[_0x4e63('0x26')](function(){if(_0x154171){return _0x154171;}})['then'](respondWithResult(_0x202d3d,null))[_0x4e63('0x47')](handleError(_0x202d3d,null));};exports[_0x4e63('0x70')]=function(_0x30efb1,_0x1c40cd){return db[_0x4e63('0x2b')][_0x4e63('0x2c')]()['then'](function(_0x8ef38c){if(_0x30efb1[_0x4e63('0x4f')][_0x4e63('0x53')]&&_['isArray'](_0x30efb1['body'][_0x4e63('0x53')])){if(_0x30efb1['body']['tags']['length']){_0x30efb1[_0x4e63('0x4f')][_0x4e63('0x53')]=_0x30efb1['body'][_0x4e63('0x53')]['join'](';')+';';}else{_0x30efb1['body'][_0x4e63('0x53')]=null;}}else{_0x30efb1['body'][_0x4e63('0x53')]=null;}return db[_0x4e63('0x2b')][_0x4e63('0x70')](_0x30efb1[_0x4e63('0x4f')],{'fields':_['keys'](_0x8ef38c),'raw':!![]});})[_0x4e63('0x26')](respondWithResult(_0x1c40cd,0xc9))[_0x4e63('0x47')](handleError(_0x1c40cd,null));};exports[_0x4e63('0x71')]=function(_0x354469,_0x140e02){var _0x14ae97=[];var _0xfeef0a=0x0;var _0x4c2a39=0x0;var _0x1abfe2=0x0;return db[_0x4e63('0x2b')]['describe']()[_0x4e63('0x26')](function(_0x1598f5){return BPromise[_0x4e63('0x72')](_0x354469[_0x4e63('0x4f')],function(_0x57b1cd){var _0x39b8b9={'where':{'$or':[]},'defaults':_0x57b1cd,'fields':_[_0x4e63('0x48')](_0x1598f5),'raw':!![]};if(_0x57b1cd[_0x4e63('0x73')]){for(var _0x16f57d=0x0;_0x16f57d<_0x57b1cd[_0x4e63('0x73')][_0x4e63('0x33')];_0x16f57d++){var _0x11705e={};_0x11705e[_0x57b1cd[_0x4e63('0x73')][_0x16f57d]]=_0x57b1cd[_0x57b1cd[_0x4e63('0x73')][_0x16f57d]];_0x39b8b9[_0x4e63('0x37')][_0x4e63('0x74')][_0x4e63('0x3d')](_0x11705e);}_0x39b8b9[_0x4e63('0x37')]['ListId']=_0x57b1cd[_0x4e63('0x75')];}return db[_0x4e63('0x2b')][_0x4e63('0x76')](_0x39b8b9)['spread'](function(_0x49a4ef,_0x3bc565){if(_0x3bc565){_0xfeef0a++;}else{_0x1abfe2++;}})[_0x4e63('0x47')](function(_0x1a1f90){console['error'](_0x1a1f90);_0x4c2a39++;});});})[_0x4e63('0x26')](function(_0x1cda83){if(_0x1cda83){return{'success':_0xfeef0a,'failure':_0x4c2a39,'duplicates':_0x1abfe2};}})[_0x4e63('0x26')](respondWithResult(_0x140e02,0xc9))[_0x4e63('0x47')](handleError(_0x140e02,null));};exports['show']=function(_0x59636f,_0x17f356,_0xe36a4a){var _0x342e04;return db['CmContact'][_0x4e63('0x2c')]()['then'](function(_0x777147){return db['CmContact'][_0x4e63('0x77')]({'where':{'id':_0x59636f['params']['id']},'include':[{'model':db[_0x4e63('0x3e')],'as':_0x4e63('0x42'),'attributes':['id','name',_0x4e63('0x43')],'required':_0x59636f[_0x4e63('0x2e')]['tag']?!![]:![]}],'attributes':_['keys'](_0x777147)});})[_0x4e63('0x26')](function(_0x393317){_0x342e04=_0x393317[_0x4e63('0x51')]({'plain':!![]});var _0x765dfa={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x393317&&_0x393317[_0x4e63('0x75')]){if(_0x393317[_0x4e63('0x75')]){_0x765dfa['where'][_0x4e63('0x78')]['push']({'ListId':{'$ne':_0x393317['ListId']}});}}return db[_0x4e63('0x4c')]['findAll'](_0x765dfa);})[_0x4e63('0x26')](function(_0x300a7b){return _['omit'](_0x342e04,_[_0x4e63('0x39')](_0x300a7b,function(_0x268a6e){return util['format'](_0x4e63('0x79'),_0x268a6e['id']);}));})['then'](handleEntityNotFound(_0x17f356,null))[_0x4e63('0x26')](respondWithResult(_0x17f356,null))[_0x4e63('0x47')](handleError(_0x17f356,null));};exports[_0x4e63('0x25')]=function(_0x502d0a,_0x240312){var _0x2750bf;if(_0x502d0a[_0x4e63('0x4f')]['id']){delete _0x502d0a[_0x4e63('0x4f')]['id'];}return db[_0x4e63('0x2b')][_0x4e63('0x77')]({'where':{'id':_0x502d0a['params']['id']}})['then'](handleEntityNotFound(_0x240312,null))[_0x4e63('0x26')](saveUpdates(_0x502d0a[_0x4e63('0x4f')],null))[_0x4e63('0x26')](function(_0x487106){_0x2750bf=_0x487106;var _0x24b193={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x487106&&_0x487106[_0x4e63('0x75')]){if(_0x487106[_0x4e63('0x75')]){_0x24b193['where']['$and'][_0x4e63('0x3d')]({'ListId':{'$ne':_0x487106['ListId']}});}}return db[_0x4e63('0x4c')][_0x4e63('0x45')](_0x24b193);})[_0x4e63('0x26')](function(_0xcb6610){if(_0xcb6610){return _[_0x4e63('0x7a')](_[_0x4e63('0x7b')](_0x502d0a['body'],function(_0x598408,_0x493aa7){return _[_0x4e63('0x49')](_0x493aa7,'cf_');}),_[_0x4e63('0x39')](_0xcb6610,function(_0x15303e){return util[_0x4e63('0x7c')](_0x4e63('0x79'),_0x15303e['id']);}));}})['then'](function(_0x31e9e5){if(_0x31e9e5&&!_[_0x4e63('0x7d')](_0x31e9e5)){var _0x4fa9cc=squel[_0x4e63('0x25')]()[_0x4e63('0x7e')](_0x4e63('0x7f'))[_0x4e63('0x80')](_0x31e9e5)[_0x4e63('0x37')](_0x4e63('0x81'),_0x502d0a[_0x4e63('0x82')]['id'])[_0x4e63('0x83')]();return db[_0x4e63('0x84')]['query'](_0x4fa9cc[_0x4e63('0x85')],{'replacements':_0x4fa9cc[_0x4e63('0x86')]});}})['then'](function(){if(_0x502d0a[_0x4e63('0x4f')][_0x4e63('0x87')]&&_0x2750bf){return db[_0x4e63('0x57')][_0x4e63('0x25')]({'phone':_0x502d0a[_0x4e63('0x4f')][_0x4e63('0x87')]},{'where':{'ContactId':_0x2750bf['id']}});}})[_0x4e63('0x26')](function(){return _0x2750bf;})[_0x4e63('0x26')](respondWithResult(_0x240312,null))[_0x4e63('0x47')](handleError(_0x240312,null));};exports[_0x4e63('0x88')]=function(_0x2094c6,_0x25b888,_0x2734ea){var _0x5711b0={};var _0x1006b1={};var _0x3d034e;var _0x451ec3;return db[_0x4e63('0x2b')]['findOne']({'where':{'id':_0x2094c6[_0x4e63('0x82')]['id']}})[_0x4e63('0x26')](handleEntityNotFound(_0x25b888,null))[_0x4e63('0x26')](function(_0x56e491){if(_0x56e491){_0x3d034e=_0x56e491;_0x1006b1[_0x4e63('0x2d')]=_[_0x4e63('0x48')](db['Tag']['rawAttributes']);_0x1006b1['query']=_[_0x4e63('0x48')](_0x2094c6[_0x4e63('0x2e')]);_0x1006b1[_0x4e63('0x2f')]=_[_0x4e63('0x30')](_0x1006b1[_0x4e63('0x2d')],_0x1006b1[_0x4e63('0x2e')]);_0x5711b0[_0x4e63('0x32')]=_[_0x4e63('0x30')](_0x1006b1['model'],qs[_0x4e63('0x31')](_0x2094c6[_0x4e63('0x2e')]['fields']));_0x5711b0[_0x4e63('0x32')]=_0x5711b0[_0x4e63('0x32')][_0x4e63('0x33')]?_0x5711b0[_0x4e63('0x32')]:_0x1006b1['model'];_0x5711b0['order']=qs[_0x4e63('0x36')](_0x2094c6[_0x4e63('0x2e')][_0x4e63('0x36')]);_0x5711b0[_0x4e63('0x37')]=qs[_0x4e63('0x2f')](_[_0x4e63('0x89')](_0x2094c6['query'],_0x1006b1['filters']));if(_0x2094c6[_0x4e63('0x2e')][_0x4e63('0x38')]){_0x5711b0[_0x4e63('0x37')]=_['merge'](_0x5711b0['where'],{'$or':_[_0x4e63('0x39')](_0x5711b0[_0x4e63('0x32')],function(_0x50cd0c){var _0x2b638d={};_0x2b638d[_0x50cd0c]={'$like':'%'+_0x2094c6[_0x4e63('0x2e')][_0x4e63('0x38')]+'%'};return _0x2b638d;})});}_0x5711b0=_[_0x4e63('0x3a')]({},_0x5711b0,_0x2094c6[_0x4e63('0x3b')]);return _0x3d034e[_0x4e63('0x88')](_0x5711b0);}})[_0x4e63('0x26')](function(_0x49ecd3){if(_0x49ecd3){_0x451ec3=_0x49ecd3[_0x4e63('0x33')];if(!_0x2094c6[_0x4e63('0x2e')][_0x4e63('0x34')]('nolimit')){_0x5711b0[_0x4e63('0x21')]=qs[_0x4e63('0x21')](_0x2094c6[_0x4e63('0x2e')][_0x4e63('0x21')]);_0x5711b0[_0x4e63('0x20')]=qs[_0x4e63('0x20')](_0x2094c6[_0x4e63('0x2e')]['offset']);}return _0x3d034e[_0x4e63('0x88')](_0x5711b0);}})['then'](function(_0x4f0e99){if(_0x4f0e99){return _0x4f0e99?{'count':_0x451ec3,'rows':_0x4f0e99}:null;}})[_0x4e63('0x26')](respondWithResult(_0x25b888,null))[_0x4e63('0x47')](handleError(_0x25b888,null));};exports[_0x4e63('0x8a')]=function(_0x5c62d2,_0x1c88a0,_0x1df8c3){if(_0x5c62d2[_0x4e63('0x4f')]['id']){delete _0x5c62d2['body']['id'];}return db[_0x4e63('0x2b')]['findOne']({'where':{'id':_0x5c62d2[_0x4e63('0x82')]['id']}})[_0x4e63('0x26')](handleEntityNotFound(_0x1c88a0,null))[_0x4e63('0x26')](function(_0x376906){if(_0x376906){return _0x376906[_0x4e63('0x8a')](_0x5c62d2[_0x4e63('0x4f')]['ids']||[]);}return null;})[_0x4e63('0x26')](respondWithResult(_0x1c88a0,null))[_0x4e63('0x47')](handleError(_0x1c88a0,null));};exports['getHoppers']=function(_0x27ca68,_0x29884d,_0x447bfd){var _0x29ac3b={'raw':![],'where':{}};var _0x41b322={};var _0x17f3d9={'count':0x0,'rows':[]};return db[_0x4e63('0x2b')][_0x4e63('0x8b')]({'where':{'id':_0x27ca68['params']['id']}})[_0x4e63('0x26')](handleEntityNotFound(_0x29884d,null))[_0x4e63('0x26')](function(_0x4c6945){if(_0x4c6945){_0x41b322[_0x4e63('0x2d')]=_[_0x4e63('0x48')](db['CmHopper'][_0x4e63('0x8c')]);_0x41b322['query']=_[_0x4e63('0x48')](_0x27ca68[_0x4e63('0x2e')]);_0x41b322['filters']=_[_0x4e63('0x30')](_0x41b322['model'],_0x41b322[_0x4e63('0x2e')]);_0x29ac3b[_0x4e63('0x32')]=_['intersection'](_0x41b322[_0x4e63('0x2d')],qs[_0x4e63('0x31')](_0x27ca68[_0x4e63('0x2e')][_0x4e63('0x31')]));_0x29ac3b['attributes']=_0x29ac3b['attributes']['length']?_0x29ac3b[_0x4e63('0x32')]:_0x41b322['model'];if(!_0x27ca68[_0x4e63('0x2e')][_0x4e63('0x34')](_0x4e63('0x8d'))){_0x29ac3b[_0x4e63('0x21')]=qs[_0x4e63('0x21')](_0x27ca68[_0x4e63('0x2e')][_0x4e63('0x21')]);_0x29ac3b['offset']=qs[_0x4e63('0x20')](_0x27ca68[_0x4e63('0x2e')][_0x4e63('0x20')]);}_0x29ac3b[_0x4e63('0x35')]=qs['sort'](_0x27ca68[_0x4e63('0x2e')][_0x4e63('0x36')]);_0x29ac3b[_0x4e63('0x37')]=qs[_0x4e63('0x2f')](_[_0x4e63('0x89')](_0x27ca68['query'],_0x41b322[_0x4e63('0x2f')]));_0x29ac3b[_0x4e63('0x37')]['ContactId']=_0x4c6945['id'];if(_0x27ca68['query']['filter']){_0x29ac3b[_0x4e63('0x37')]=_['merge'](_0x29ac3b[_0x4e63('0x37')],{'$or':_[_0x4e63('0x39')](_0x29ac3b[_0x4e63('0x32')],function(_0x5ee945){var _0x356358={};_0x356358[_0x5ee945]={'$like':'%'+_0x27ca68[_0x4e63('0x2e')][_0x4e63('0x38')]+'%'};return _0x356358;})});}_0x29ac3b=_['merge']({},_0x29ac3b,_0x27ca68[_0x4e63('0x3b')]);return db[_0x4e63('0x57')][_0x4e63('0x1f')]({'where':_0x29ac3b[_0x4e63('0x37')]})[_0x4e63('0x26')](function(_0x2c3c31){_0x17f3d9[_0x4e63('0x1f')]=_0x2c3c31;if(_0x27ca68[_0x4e63('0x2e')][_0x4e63('0x41')]){_0x29ac3b['include']=[{'all':!![]}];}return db[_0x4e63('0x57')][_0x4e63('0x45')](_0x29ac3b);})[_0x4e63('0x26')](function(_0x55ba65){_0x17f3d9[_0x4e63('0x46')]=_0x55ba65;return _0x17f3d9;});}})[_0x4e63('0x26')](respondWithFilteredResult(_0x29884d,_0x29ac3b))['catch'](handleError(_0x29884d,null));};exports['getHopperHistories']=function(_0x218e37,_0x4d4a6e,_0x3c6d5e){var _0x213e92={'raw':!![],'where':{}};var _0x257a68={};var _0x498d66={'count':0x0,'rows':[]};return db[_0x4e63('0x2b')][_0x4e63('0x8b')]({'where':{'id':_0x218e37[_0x4e63('0x82')]['id']}})[_0x4e63('0x26')](handleEntityNotFound(_0x4d4a6e,null))[_0x4e63('0x26')](function(_0x1ad21e){if(_0x1ad21e){_0x257a68[_0x4e63('0x2d')]=_[_0x4e63('0x48')](db[_0x4e63('0x8e')][_0x4e63('0x8c')]);_0x257a68[_0x4e63('0x2e')]=_[_0x4e63('0x48')](_0x218e37[_0x4e63('0x2e')]);_0x257a68[_0x4e63('0x2f')]=_['intersection'](_0x257a68['model'],_0x257a68['query']);_0x213e92[_0x4e63('0x32')]=_['intersection'](_0x257a68[_0x4e63('0x2d')],qs[_0x4e63('0x31')](_0x218e37[_0x4e63('0x2e')][_0x4e63('0x31')]));_0x213e92[_0x4e63('0x32')]=_0x213e92[_0x4e63('0x32')]['length']?_0x213e92['attributes']:_0x257a68[_0x4e63('0x2d')];if(!_0x218e37[_0x4e63('0x2e')][_0x4e63('0x34')](_0x4e63('0x8d'))){_0x213e92['limit']=qs[_0x4e63('0x21')](_0x218e37[_0x4e63('0x2e')]['limit']);_0x213e92['offset']=qs[_0x4e63('0x20')](_0x218e37[_0x4e63('0x2e')][_0x4e63('0x20')]);}_0x213e92['order']=qs[_0x4e63('0x36')](_0x218e37['query']['sort']);_0x213e92[_0x4e63('0x37')]=qs[_0x4e63('0x2f')](_[_0x4e63('0x89')](_0x218e37[_0x4e63('0x2e')],_0x257a68['filters']));_0x213e92[_0x4e63('0x37')][_0x4e63('0x8f')]=_0x1ad21e['id'];if(_0x218e37[_0x4e63('0x2e')]['filter']){_0x213e92['where']=_['merge'](_0x213e92[_0x4e63('0x37')],{'$or':_[_0x4e63('0x39')](_0x213e92[_0x4e63('0x32')],function(_0x42d292){var _0x492801={};_0x492801[_0x42d292]={'$like':'%'+_0x218e37[_0x4e63('0x2e')]['filter']+'%'};return _0x492801;})});}_0x213e92=_['merge']({},_0x213e92,_0x218e37[_0x4e63('0x3b')]);return db[_0x4e63('0x8e')][_0x4e63('0x1f')]({'where':_0x213e92[_0x4e63('0x37')]})['then'](function(_0x90d8e3){_0x498d66[_0x4e63('0x1f')]=_0x90d8e3;if(_0x218e37[_0x4e63('0x2e')][_0x4e63('0x41')]){_0x213e92[_0x4e63('0x3c')]=[{'all':!![]}];}return db[_0x4e63('0x8e')]['findAll'](_0x213e92);})[_0x4e63('0x26')](function(_0x526457){_0x498d66[_0x4e63('0x46')]=_0x526457;return _0x498d66;});}})[_0x4e63('0x26')](respondWithFilteredResult(_0x4d4a6e,_0x213e92))[_0x4e63('0x47')](handleError(_0x4d4a6e,null));};exports[_0x4e63('0x90')]=function(_0x2e5a77,_0x3431e9,_0x274a2d){var _0x25edec={'raw':!![],'where':{}};var _0x2fabf1={};var _0x491006={'count':0x0,'rows':[]};return db[_0x4e63('0x2b')][_0x4e63('0x8b')]({'where':{'id':_0x2e5a77[_0x4e63('0x82')]['id']}})['then'](handleEntityNotFound(_0x3431e9,null))[_0x4e63('0x26')](function(_0x3a61b1){if(_0x3a61b1){_0x2fabf1[_0x4e63('0x2d')]=_['keys'](db['CmHopperFinal'][_0x4e63('0x8c')]);_0x2fabf1[_0x4e63('0x2e')]=_[_0x4e63('0x48')](_0x2e5a77[_0x4e63('0x2e')]);_0x2fabf1['filters']=_['intersection'](_0x2fabf1[_0x4e63('0x2d')],_0x2fabf1[_0x4e63('0x2e')]);_0x25edec[_0x4e63('0x32')]=_[_0x4e63('0x30')](_0x2fabf1[_0x4e63('0x2d')],qs[_0x4e63('0x31')](_0x2e5a77[_0x4e63('0x2e')][_0x4e63('0x31')]));_0x25edec['attributes']=_0x25edec[_0x4e63('0x32')][_0x4e63('0x33')]?_0x25edec[_0x4e63('0x32')]:_0x2fabf1[_0x4e63('0x2d')];if(!_0x2e5a77[_0x4e63('0x2e')][_0x4e63('0x34')]('nolimit')){_0x25edec[_0x4e63('0x21')]=qs[_0x4e63('0x21')](_0x2e5a77['query']['limit']);_0x25edec[_0x4e63('0x20')]=qs['offset'](_0x2e5a77[_0x4e63('0x2e')][_0x4e63('0x20')]);}_0x25edec[_0x4e63('0x35')]=qs[_0x4e63('0x36')](_0x2e5a77[_0x4e63('0x2e')][_0x4e63('0x36')]);_0x25edec[_0x4e63('0x37')]=qs['filters'](_[_0x4e63('0x89')](_0x2e5a77['query'],_0x2fabf1[_0x4e63('0x2f')]));_0x25edec[_0x4e63('0x37')]['ContactId']=_0x3a61b1['id'];if(_0x2e5a77[_0x4e63('0x2e')][_0x4e63('0x38')]){_0x25edec[_0x4e63('0x37')]=_['merge'](_0x25edec[_0x4e63('0x37')],{'$or':_['map'](_0x25edec[_0x4e63('0x32')],function(_0x40a61f){var _0x52d2a4={};_0x52d2a4[_0x40a61f]={'$like':'%'+_0x2e5a77['query'][_0x4e63('0x38')]+'%'};return _0x52d2a4;})});}_0x25edec=_[_0x4e63('0x3a')]({},_0x25edec,_0x2e5a77[_0x4e63('0x3b')]);return db[_0x4e63('0x67')][_0x4e63('0x1f')]({'where':_0x25edec[_0x4e63('0x37')]})['then'](function(_0xe012e4){_0x491006[_0x4e63('0x1f')]=_0xe012e4;if(_0x2e5a77['query'][_0x4e63('0x41')]){_0x25edec[_0x4e63('0x3c')]=[{'all':!![]}];}return db[_0x4e63('0x67')]['findAll'](_0x25edec);})[_0x4e63('0x26')](function(_0x587980){_0x491006[_0x4e63('0x46')]=_0x587980;return _0x491006;});}})[_0x4e63('0x26')](respondWithFilteredResult(_0x3431e9,_0x25edec))[_0x4e63('0x47')](handleError(_0x3431e9,null));};exports[_0x4e63('0x91')]=function(_0x26eec6,_0x5a21e3,_0x2cf9e8){var _0x5408dd={'raw':!![],'where':{}};var _0x145fd1={};var _0x4beb03={'count':0x0,'rows':[]};return db[_0x4e63('0x2b')][_0x4e63('0x8b')]({'where':{'id':_0x26eec6[_0x4e63('0x82')]['id']}})['then'](handleEntityNotFound(_0x5a21e3,null))[_0x4e63('0x26')](function(_0x31cd72){if(_0x31cd72){_0x145fd1[_0x4e63('0x2d')]=_[_0x4e63('0x48')](db[_0x4e63('0x6f')][_0x4e63('0x8c')]);_0x145fd1[_0x4e63('0x2e')]=_[_0x4e63('0x48')](_0x26eec6[_0x4e63('0x2e')]);_0x145fd1[_0x4e63('0x2f')]=_[_0x4e63('0x30')](_0x145fd1[_0x4e63('0x2d')],_0x145fd1['query']);_0x5408dd[_0x4e63('0x32')]=_[_0x4e63('0x30')](_0x145fd1[_0x4e63('0x2d')],qs[_0x4e63('0x31')](_0x26eec6['query'][_0x4e63('0x31')]));_0x5408dd[_0x4e63('0x32')]=_0x5408dd[_0x4e63('0x32')][_0x4e63('0x33')]?_0x5408dd[_0x4e63('0x32')]:_0x145fd1['model'];if(!_0x26eec6[_0x4e63('0x2e')][_0x4e63('0x34')](_0x4e63('0x8d'))){_0x5408dd['limit']=qs['limit'](_0x26eec6[_0x4e63('0x2e')][_0x4e63('0x21')]);_0x5408dd[_0x4e63('0x20')]=qs[_0x4e63('0x20')](_0x26eec6[_0x4e63('0x2e')][_0x4e63('0x20')]);}_0x5408dd[_0x4e63('0x35')]=qs[_0x4e63('0x36')](_0x26eec6['query'][_0x4e63('0x36')]);_0x5408dd[_0x4e63('0x37')]=qs[_0x4e63('0x2f')](_[_0x4e63('0x89')](_0x26eec6[_0x4e63('0x2e')],_0x145fd1[_0x4e63('0x2f')]));_0x5408dd[_0x4e63('0x37')][_0x4e63('0x8f')]=_0x31cd72['id'];if(_0x26eec6[_0x4e63('0x2e')][_0x4e63('0x38')]){_0x5408dd[_0x4e63('0x37')]=_[_0x4e63('0x3a')](_0x5408dd[_0x4e63('0x37')],{'$or':_[_0x4e63('0x39')](_0x5408dd[_0x4e63('0x32')],function(_0x2a5742){var _0x594a86={};_0x594a86[_0x2a5742]={'$like':'%'+_0x26eec6[_0x4e63('0x2e')][_0x4e63('0x38')]+'%'};return _0x594a86;})});}_0x5408dd=_[_0x4e63('0x3a')]({},_0x5408dd,_0x26eec6[_0x4e63('0x3b')]);return db[_0x4e63('0x6f')][_0x4e63('0x1f')]({'where':_0x5408dd[_0x4e63('0x37')]})[_0x4e63('0x26')](function(_0x2b58c1){_0x4beb03[_0x4e63('0x1f')]=_0x2b58c1;if(_0x26eec6[_0x4e63('0x2e')][_0x4e63('0x41')]){_0x5408dd[_0x4e63('0x3c')]=[{'all':!![]}];}return db[_0x4e63('0x6f')]['findAll'](_0x5408dd);})[_0x4e63('0x26')](function(_0x3710ea){_0x4beb03[_0x4e63('0x46')]=_0x3710ea;return _0x4beb03;});}})[_0x4e63('0x26')](respondWithFilteredResult(_0x5a21e3,_0x5408dd))[_0x4e63('0x47')](handleError(_0x5a21e3,null));};exports['uploadCsv']=function(_0x19a5d7,_0x502361,_0x26b094){try{if(!_0x19a5d7[_0x4e63('0x4f')][_0x4e63('0x75')]){throw new Error(_0x4e63('0x92'));}if(!_0x19a5d7[_0x4e63('0x4f')]['binding_keys']){throw new Error(_0x4e63('0x93'));}if(!_0x19a5d7[_0x4e63('0x4f')][_0x4e63('0x94')]){throw new Error(_0x4e63('0x95'));}if(!_0x19a5d7['body'][_0x4e63('0x96')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x26d9df=_0x19a5d7[_0x4e63('0x4f')][_0x4e63('0x97')][_0x4e63('0x98')](',');var _0x404021=_0x19a5d7['body'][_0x4e63('0x94')][_0x4e63('0x98')](',');if(!_0x26d9df['length']||!_0x404021[_0x4e63('0x33')]||_0x26d9df[_0x4e63('0x33')]!==_0x404021[_0x4e63('0x33')]){throw new Error(_0x4e63('0x99'));}_0x19a5d7[_0x4e63('0x4f')][_0x4e63('0x31')]=_[_0x4e63('0x9a')](_0x26d9df,_0x404021);if(!_0x19a5d7['body']['fields'][_0x4e63('0x87')]){throw new Error(_0x4e63('0x9b'));}if(!_0x19a5d7[_0x4e63('0x4f')][_0x4e63('0x31')][_0x4e63('0x9c')]){throw new Error(_0x4e63('0x9d'));}var _0x4524fa=path[_0x4e63('0x55')](config['root'],_0x4e63('0x9e'),_0x19a5d7[_0x4e63('0x9f')][_0x4e63('0xa0')]);fs[_0x4e63('0xa1')](_0x4524fa,parseInt(_0x4e63('0xa2'),0x8));var _0x429374=require(_0x4e63('0xa3'))[_0x4e63('0xa4')](path[_0x4e63('0x55')](__dirname,_0x4e63('0xa5')),[_0x4524fa,_0x19a5d7['body'][_0x4e63('0x97')],_0x19a5d7[_0x4e63('0x4f')][_0x4e63('0x94')],_0x19a5d7['body'][_0x4e63('0x75')],_0x19a5d7[_0x4e63('0x4f')][_0x4e63('0xa6')],_0x19a5d7[_0x4e63('0x4f')]['duplicates'],_0x19a5d7['body'][_0x4e63('0x96')]]);return _0x502361['status'](0xc8)[_0x4e63('0x1e')]({'message':_0x4e63('0xa7'),'pid':_0x429374[_0x4e63('0xa8')]});}catch(_0x48ee7c){return _0x502361[_0x4e63('0x1c')](0x1f4)[_0x4e63('0xa9')](_0x48ee7c);}};exports[_0x4e63('0xaa')]=function(_0x1e5d9b,_0x4bdaf8,_0x56cd53){var _0x578f44=fs[_0x4e63('0xab')](_0x1e5d9b[_0x4e63('0x9f')]['path']);Papa[_0x4e63('0xac')](_0x578f44,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x3a7af2){return _0x4bdaf8['status'](0xc8)[_0x4e63('0x1e')]({'file':_0x1e5d9b[_0x4e63('0x9f')],'fields':_0x3a7af2['meta'][_0x4e63('0x31')]});}});};exports[_0x4e63('0xad')]=function(_0x18db66,_0x281257,_0x11bb4d){return db[_0x4e63('0xae')]['findAll']({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0x4e63('0x26')](function(_0x69b60e){var _0x56d52c=![];if(!_0x18db66['body'][_0x4e63('0x75')]){throw new Error(_0x4e63('0x92'));}if(!_0x18db66[_0x4e63('0x4f')][_0x4e63('0xaf')][_0x4e63('0x87')]){throw new Error(_0x4e63('0x9b'));}if(!_0x18db66[_0x4e63('0x4f')]['binding']['firstName']){throw new Error(_0x4e63('0x9d'));}if(!_0x18db66[_0x4e63('0x4f')]['socket_timestamp']){throw new Error(_0x4e63('0xb0'));}var _0x387b4c=require('child_process')[_0x4e63('0xa4')](path[_0x4e63('0x55')](__dirname,_0x4e63('0xb1')),[_0x18db66[_0x4e63('0x82')]['id'],JSON['stringify'](_0x18db66['body']),JSON['stringify'](_0x69b60e)]);_0x387b4c['on']('message',function(_0xb08bf4){_0x56d52c=!![];return _0x281257[_0x4e63('0x1c')](0xc8)[_0x4e63('0x1e')]({'message':_0x4e63('0xb2'),'pid':_0x387b4c[_0x4e63('0xa8')]});});_0x387b4c['on'](_0x4e63('0xb3'),function(_0x3b9824){if(_0x3b9824&&!_0x56d52c){return _0x281257['status'](0x1f4)[_0x4e63('0x1e')]({'message':'error\x20child\x20process','pid':_0x387b4c[_0x4e63('0xa8')]});}});})[_0x4e63('0x47')](handleError(_0x281257,null));};
\ No newline at end of file
+var _0x9b3a=['isArray','tags','join','[CmContact][merge]\x20to\x20%s\x20from\x20%s','from','CmHopper','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','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','FaxQueueReport','OpenchannelQueueReport','SmsQueueReport','bulkCreate','each','duplicates','$or','ListId','findOrCreate','$and','CmCustomField','omit','format','cf_%d','isEmpty','table','cm_contacts','setFields','toParam','values','phone','getTags','rawAttributes','fields','sort','setTags','findOne','ids','getHoppers','ContactId','getHopperHistories','getHopperFinals','getJscriptySessions','JscriptySessionReport','uploadCsv','No\x20association\x20keys\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_keys','split','binding_values','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','filename','chmodSync','0777','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','pid','upload','createReadStream','meta','import','User','No\x20ListId\x20specified','binding','child_process','../../components/import/cm/csv2','stringify','exit','error\x20child\x20process','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','util','path','sox','to-csv','ejs','jsforce','desk.js','papaparse','../../components/auth/service','ioredis','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','redis','defaults','localhost','./cmContact.socket','register','sendStatus','end','status','json','offset','set','reject','save','update','destroy','then','error','stack','name','send','index','CmContact','describe','keys','query','filters','model','attributes','intersection','length','nolimit','limit','order','pick','filter','where','merge','map','options','include','tag','push','distinct','count','includeAll','Tag','color','ThroughTags','findAll','rows','catch','find','params','startsWith','cf_','columnName','displayName','hasOwnProperty','body','get','mergeWith'];(function(_0x11ef05,_0x586f50){var _0x2fa5a5=function(_0x14d324){while(--_0x14d324){_0x11ef05['push'](_0x11ef05['shift']());}};_0x2fa5a5(++_0x586f50);}(_0x9b3a,0x1b7));var _0xa9b3=function(_0x283c8c,_0x213a62){_0x283c8c=_0x283c8c-0x0;var _0x91f202=_0x9b3a[_0x283c8c];return _0x91f202;};'use strict';var pdf=require(_0xa9b3('0x0'));var emlformat=require(_0xa9b3('0x1'));var rimraf=require(_0xa9b3('0x2'));var zipdir=require(_0xa9b3('0x3'));var jsonpatch=require(_0xa9b3('0x4'));var rp=require(_0xa9b3('0x5'));var moment=require('moment');var BPromise=require(_0xa9b3('0x6'));var Mustache=require('mustache');var util=require(_0xa9b3('0x7'));var path=require(_0xa9b3('0x8'));var sox=require(_0xa9b3('0x9'));var csv=require(_0xa9b3('0xa'));var ejs=require(_0xa9b3('0xb'));var fs=require('fs');var _=require('lodash');var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xa9b3('0xc'));var deskjs=require(_0xa9b3('0xd'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0xa9b3('0xe'));var authService=require(_0xa9b3('0xf'));var hardwareService=require('../../config/license/hardware');var Redis=require(_0xa9b3('0x10'));var qs=require(_0xa9b3('0x11'));var logger=require(_0xa9b3('0x12'))(_0xa9b3('0x13'));var utils=require(_0xa9b3('0x14'));var config=require(_0xa9b3('0x15'));var db=require('../../mysqldb')['db'];config[_0xa9b3('0x16')]=_[_0xa9b3('0x17')](config[_0xa9b3('0x16')],{'host':_0xa9b3('0x18'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0xa9b3('0x16')]));require(_0xa9b3('0x19'))[_0xa9b3('0x1a')](socket);function respondWithStatusCode(_0x3175be,_0x11a85d){_0x11a85d=_0x11a85d||0xcc;return function(_0xa2eb9d){if(_0xa2eb9d){return _0x3175be[_0xa9b3('0x1b')](_0x11a85d);}return _0x3175be['status'](_0x11a85d)[_0xa9b3('0x1c')]();};}function respondWithResult(_0x2f4ad7,_0x400484){_0x400484=_0x400484||0xc8;return function(_0xd3752a){if(_0xd3752a){return _0x2f4ad7[_0xa9b3('0x1d')](_0x400484)[_0xa9b3('0x1e')](_0xd3752a);}};}function respondWithFilteredResult(_0x22b233,_0xdd8c79){return function(_0x4dfec9){if(_0x4dfec9){var _0x308fc1=_0x4dfec9['count'],_0x5d84bb=_0xdd8c79[_0xa9b3('0x1f')],_0x377dc6=_0xdd8c79['offset']+_0xdd8c79['limit'],_0x2247a0;if(_0x377dc6>=_0x308fc1){_0x377dc6=_0x308fc1;_0x2247a0=0xc8;}else{_0x2247a0=0xce;}_0x22b233[_0xa9b3('0x1d')](_0x2247a0);return _0x22b233[_0xa9b3('0x20')]('Content-Range',_0x5d84bb+'-'+_0x377dc6+'/'+_0x308fc1)[_0xa9b3('0x1e')](_0x4dfec9);}return null;};}function patchUpdates(_0x40daf2){return function(_0x18883e){try{jsonpatch['apply'](_0x18883e,_0x40daf2,!![]);}catch(_0x484e85){return BPromise[_0xa9b3('0x21')](_0x484e85);}return _0x18883e[_0xa9b3('0x22')]();};}function saveUpdates(_0x15b3b5,_0x29f4a5){return function(_0x36ff76){if(_0x36ff76){return _0x36ff76[_0xa9b3('0x23')](_0x15b3b5)['then'](function(_0x594106){return _0x594106;});}return null;};}function removeEntity(_0x556585,_0x1d840e){return function(_0x2ed3eb){if(_0x2ed3eb){return _0x2ed3eb[_0xa9b3('0x24')]()[_0xa9b3('0x25')](function(){_0x556585[_0xa9b3('0x1d')](0xcc)[_0xa9b3('0x1c')]();});}};}function handleEntityNotFound(_0x239430,_0x2a9fe4){return function(_0x338160){if(!_0x338160){_0x239430[_0xa9b3('0x1b')](0x194);}return _0x338160;};}function handleError(_0x556e7a,_0x35db5d){_0x35db5d=_0x35db5d||0x1f4;return function(_0x5009e7){logger[_0xa9b3('0x26')](_0x5009e7[_0xa9b3('0x27')]);if(_0x5009e7[_0xa9b3('0x28')]){delete _0x5009e7['name'];}_0x556e7a[_0xa9b3('0x1d')](_0x35db5d)[_0xa9b3('0x29')](_0x5009e7);};}exports[_0xa9b3('0x2a')]=function(_0x21864f,_0x1c55ed){var _0x22e30d={},_0x415ffd={},_0x56f505={'count':0x0,'rows':[]};return db[_0xa9b3('0x2b')][_0xa9b3('0x2c')]()[_0xa9b3('0x25')](function(_0x37463e){_0x415ffd['model']=_[_0xa9b3('0x2d')](_0x37463e);_0x415ffd[_0xa9b3('0x2e')]=_[_0xa9b3('0x2d')](_0x21864f['query']);_0x415ffd[_0xa9b3('0x2f')]=_['intersection'](_0x415ffd[_0xa9b3('0x30')],_0x415ffd[_0xa9b3('0x2e')]);_0x22e30d[_0xa9b3('0x31')]=_[_0xa9b3('0x32')](_0x415ffd['model'],qs['fields'](_0x21864f['query']['fields']));_0x22e30d['attributes']=_0x22e30d[_0xa9b3('0x31')][_0xa9b3('0x33')]?_0x22e30d[_0xa9b3('0x31')]:_0x415ffd[_0xa9b3('0x30')];if(!_0x21864f[_0xa9b3('0x2e')]['hasOwnProperty'](_0xa9b3('0x34'))){_0x22e30d[_0xa9b3('0x35')]=qs[_0xa9b3('0x35')](_0x21864f['query'][_0xa9b3('0x35')]);_0x22e30d['offset']=qs[_0xa9b3('0x1f')](_0x21864f['query']['offset']);}_0x22e30d[_0xa9b3('0x36')]=qs['sort'](_0x21864f[_0xa9b3('0x2e')]['sort']);_0x22e30d['where']=qs[_0xa9b3('0x2f')](_[_0xa9b3('0x37')](_0x21864f[_0xa9b3('0x2e')],_0x415ffd[_0xa9b3('0x2f')]));if(_0x21864f[_0xa9b3('0x2e')][_0xa9b3('0x38')]){_0x22e30d[_0xa9b3('0x39')]=_[_0xa9b3('0x3a')](_0x22e30d[_0xa9b3('0x39')],{'$or':_[_0xa9b3('0x3b')](_0x22e30d['attributes'],function(_0x26e11e){var _0x22c609={};_0x22c609[_0x26e11e]={'$like':'%'+_0x21864f[_0xa9b3('0x2e')]['filter']+'%'};return _0x22c609;})});}_0x22e30d=_[_0xa9b3('0x3a')]({},_0x22e30d,_0x21864f[_0xa9b3('0x3c')]);var _0xb92eb1={'where':_0x22e30d['where']};_0xb92eb1[_0xa9b3('0x3d')]=[];if(_0x21864f[_0xa9b3('0x2e')][_0xa9b3('0x3e')]){_0xb92eb1[_0xa9b3('0x3d')][_0xa9b3('0x3f')]({'model':db['Tag'],'as':'Tags','attributes':['id'],'where':{'id':_0x21864f[_0xa9b3('0x2e')]['tag']},'required':!![]});_0xb92eb1[_0xa9b3('0x40')]=!![];}return db[_0xa9b3('0x2b')][_0xa9b3('0x41')](_0xb92eb1)[_0xa9b3('0x25')](function(_0x4f149c){_0x56f505[_0xa9b3('0x41')]=_0x4f149c;if(_0x21864f['query'][_0xa9b3('0x42')]){_0x22e30d[_0xa9b3('0x3d')]=[{'model':db[_0xa9b3('0x43')],'as':'Tags','attributes':['id',_0xa9b3('0x28'),_0xa9b3('0x44')],'required':_0x21864f['query'][_0xa9b3('0x3e')]?!![]:![]},{'model':db[_0xa9b3('0x43')],'as':_0xa9b3('0x45'),'attributes':['id',_0xa9b3('0x28'),_0xa9b3('0x44')],'through':_0x21864f[_0xa9b3('0x2e')][_0xa9b3('0x3e')]?{'attributes':[],'where':{'TagId':_0x21864f['query'][_0xa9b3('0x3e')]||undefined}}:{},'required':_0x21864f['query'][_0xa9b3('0x3e')]?!![]:![]}];}return db['CmContact'][_0xa9b3('0x46')](_0x22e30d);})[_0xa9b3('0x25')](function(_0x1f5372){_0x56f505[_0xa9b3('0x47')]=_0x1f5372;return _0x56f505;})[_0xa9b3('0x25')](respondWithFilteredResult(_0x1c55ed,_0x22e30d))[_0xa9b3('0x48')](handleError(_0x1c55ed,null));});};exports[_0xa9b3('0x24')]=function(_0x1d153a,_0x5e48be){return db['CmContact'][_0xa9b3('0x49')]({'where':{'id':_0x1d153a[_0xa9b3('0x4a')]['id']}})[_0xa9b3('0x25')](handleEntityNotFound(_0x5e48be,null))['then'](removeEntity(_0x5e48be,null))[_0xa9b3('0x48')](handleError(_0x5e48be,null));};exports[_0xa9b3('0x2c')]=function(_0x318b14,_0x564658){return db[_0xa9b3('0x2b')]['describe']()[_0xa9b3('0x25')](function(_0x48367c){for(var _0x16efb8=0x0;_0x16efb8<Object[_0xa9b3('0x2d')](_0x48367c)[_0xa9b3('0x33')];_0x16efb8++){var _0x420c50=Object[_0xa9b3('0x2d')](_0x48367c)[_0x16efb8];if(!_[_0xa9b3('0x4b')](_0x420c50,_0xa9b3('0x4c'))){_0x48367c[_0x420c50]['columnName']=_0x420c50;_0x48367c[_0x420c50]['displayName']=_0x420c50;}}return _0x48367c;})[_0xa9b3('0x25')](function(_0x693672){var _0x3efda0={'where':{'$or':[{'ListId':_0x318b14[_0xa9b3('0x2e')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0xa9b3('0x46')](_0x3efda0)[_0xa9b3('0x25')](function(_0x4dbcf2){for(var _0x149085=0x0;_0x149085<_0x4dbcf2[_0xa9b3('0x33')];_0x149085++){var _0x27b333=_0xa9b3('0x4c')+_0x4dbcf2[_0x149085]['id'];_0x693672[_0x27b333][_0xa9b3('0x4d')]=_0x27b333;_0x693672[_0x27b333][_0xa9b3('0x4e')]=_0x4dbcf2[_0x149085]['alias'];}for(var _0x149085=0x0;_0x149085<Object['keys'](_0x693672)[_0xa9b3('0x33')];_0x149085++){var _0x27b333=Object[_0xa9b3('0x2d')](_0x693672)[_0x149085];if(!_0x693672[_0x27b333][_0xa9b3('0x4f')](_0xa9b3('0x4d'))){delete _0x693672[_0x27b333];}}return _0x693672;});})['then'](respondWithResult(_0x564658,null))[_0xa9b3('0x48')](handleError(_0x564658,null));};exports['merge']=function(_0x3f37c4,_0x1c11b9){var _0x116084;var _0x401140;var _0x2b8031;if(_0x3f37c4[_0xa9b3('0x50')]['id']){delete _0x3f37c4[_0xa9b3('0x50')]['id'];}return db[_0xa9b3('0x2b')]['findAll']({'where':{'id':[_0x3f37c4[_0xa9b3('0x50')]['to'],_0x3f37c4[_0xa9b3('0x50')]['from']]}})[_0xa9b3('0x25')](function(_0x127129){if(_0x127129){if(_0x127129[_0xa9b3('0x33')]!==0x2){return null;}_0x127129[0x0]=_0x127129[0x0][_0xa9b3('0x51')]({'plain':!![]});_0x127129[0x1]=_0x127129[0x1][_0xa9b3('0x51')]({'plain':!![]});delete _0x127129[0x0]['id'];delete _0x127129[0x1]['id'];return _[_0xa9b3('0x52')](_0x127129[0x0],_0x127129[0x1],function(_0x5ab015,_0x709f29){if(Array[_0xa9b3('0x53')](_0x709f29)&&!_0x709f29[_0xa9b3('0x33')]){return _0x5ab015;}else if(!_0x709f29){return _0x5ab015;}});}})[_0xa9b3('0x25')](handleEntityNotFound(_0x1c11b9,null))['then'](function(_0x14ed35){if(_0x14ed35){if(_0x14ed35[_0xa9b3('0x54')]&&_[_0xa9b3('0x53')](_0x14ed35[_0xa9b3('0x54')])){_0x14ed35[_0xa9b3('0x54')]=_0x14ed35[_0xa9b3('0x54')][_0xa9b3('0x55')]();}logger['info'](_0xa9b3('0x56'),_0x3f37c4[_0xa9b3('0x50')]['to'],_0x3f37c4['body'][_0xa9b3('0x57')]);return db[_0xa9b3('0x58')]['destroy']({'where':{'ContactId':[_0x3f37c4[_0xa9b3('0x50')]['to'],_0x3f37c4['body'][_0xa9b3('0x57')]]}})[_0xa9b3('0x25')](function(_0x405ddc){logger[_0xa9b3('0x59')](_0xa9b3('0x5a'),_0x405ddc);return db[_0xa9b3('0x5b')]['destroy']({'where':{'ContactId':[_0x3f37c4[_0xa9b3('0x50')]['to'],_0x3f37c4[_0xa9b3('0x50')][_0xa9b3('0x57')]]}})[_0xa9b3('0x25')](function(_0x567158){logger[_0xa9b3('0x59')](_0xa9b3('0x5c'),_0x567158);return db[_0xa9b3('0x2b')][_0xa9b3('0x5d')](_0x14ed35);});});}})[_0xa9b3('0x25')](function(_0x418741){if(_0x418741){_0x116084=_0x418741;_0x401140={'ContactId':_0x116084['id']};_0x2b8031={'where':{'ContactId':[_0x3f37c4['body']['to'],_0x3f37c4['body'][_0xa9b3('0x57')]]}};return db[_0xa9b3('0x5e')]['update'](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x5f')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})['then'](function(){if(_0x116084){return db[_0xa9b3('0x60')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db['MailInteraction'][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x61')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db['MailInteraction'][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})['then'](function(){if(_0x116084){return db['MailMessage'][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})['then'](function(){if(_0x116084){return db[_0xa9b3('0x62')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x63')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x64')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x65')]['update'](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x66')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x67')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x68')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})['then'](function(){if(_0x116084){return db[_0xa9b3('0x69')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x6a')]['update'](_0x401140,_0x2b8031);}})['then'](function(){if(_0x116084){return db[_0xa9b3('0x6b')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db['ChatQueueReport'][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x6c')]['update'](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db['MailQueueReport'][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x6d')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x6e')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db['JscriptySessionReport'][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x2b')][_0xa9b3('0x24')]({'where':{'id':[_0x3f37c4[_0xa9b3('0x50')]['to'],_0x3f37c4[_0xa9b3('0x50')][_0xa9b3('0x57')]]}});}})['then'](function(){if(_0x116084){return _0x116084;}})[_0xa9b3('0x25')](respondWithResult(_0x1c11b9,null))['catch'](handleError(_0x1c11b9,null));};exports[_0xa9b3('0x5d')]=function(_0x2230e9,_0x45a76a){return db[_0xa9b3('0x2b')][_0xa9b3('0x2c')]()[_0xa9b3('0x25')](function(_0x3e24e5){if(_0x2230e9['body'][_0xa9b3('0x54')]&&_[_0xa9b3('0x53')](_0x2230e9[_0xa9b3('0x50')][_0xa9b3('0x54')])){if(_0x2230e9[_0xa9b3('0x50')][_0xa9b3('0x54')][_0xa9b3('0x33')]){_0x2230e9[_0xa9b3('0x50')]['tags']=_0x2230e9[_0xa9b3('0x50')][_0xa9b3('0x54')][_0xa9b3('0x55')](';')+';';}else{_0x2230e9[_0xa9b3('0x50')][_0xa9b3('0x54')]=null;}}else{_0x2230e9[_0xa9b3('0x50')]['tags']=null;}return db[_0xa9b3('0x2b')][_0xa9b3('0x5d')](_0x2230e9['body'],{'fields':_['keys'](_0x3e24e5),'raw':!![]});})['then'](respondWithResult(_0x45a76a,0xc9))[_0xa9b3('0x48')](handleError(_0x45a76a,null));};exports[_0xa9b3('0x6f')]=function(_0x336ef8,_0x13e35e){var _0x16cae7=[];var _0x5740be=0x0;var _0x156639=0x0;var _0xc3aaf9=0x0;return db[_0xa9b3('0x2b')]['describe']()['then'](function(_0x46ffcb){return BPromise[_0xa9b3('0x70')](_0x336ef8[_0xa9b3('0x50')],function(_0x4566ed){var _0x130cf6={'where':{'$or':[]},'defaults':_0x4566ed,'fields':_[_0xa9b3('0x2d')](_0x46ffcb),'raw':!![]};if(_0x4566ed[_0xa9b3('0x71')]){for(var _0x21e8d7=0x0;_0x21e8d7<_0x4566ed[_0xa9b3('0x71')][_0xa9b3('0x33')];_0x21e8d7++){var _0x25fb49={};_0x25fb49[_0x4566ed['duplicates'][_0x21e8d7]]=_0x4566ed[_0x4566ed['duplicates'][_0x21e8d7]];_0x130cf6[_0xa9b3('0x39')][_0xa9b3('0x72')][_0xa9b3('0x3f')](_0x25fb49);}_0x130cf6[_0xa9b3('0x39')][_0xa9b3('0x73')]=_0x4566ed[_0xa9b3('0x73')];}return db[_0xa9b3('0x2b')][_0xa9b3('0x74')](_0x130cf6)['spread'](function(_0x11a09d,_0x2ed341){if(_0x2ed341){_0x5740be++;}else{_0xc3aaf9++;}})[_0xa9b3('0x48')](function(_0x95e92e){console[_0xa9b3('0x26')](_0x95e92e);_0x156639++;});});})[_0xa9b3('0x25')](function(_0xa66624){if(_0xa66624){return{'success':_0x5740be,'failure':_0x156639,'duplicates':_0xc3aaf9};}})[_0xa9b3('0x25')](respondWithResult(_0x13e35e,0xc9))[_0xa9b3('0x48')](handleError(_0x13e35e,null));};exports['show']=function(_0xe1b740,_0x191192,_0x457b18){var _0x347590;return db[_0xa9b3('0x2b')][_0xa9b3('0x2c')]()['then'](function(_0x19e4d7){return db[_0xa9b3('0x2b')][_0xa9b3('0x49')]({'where':{'id':_0xe1b740['params']['id']},'include':[{'model':db[_0xa9b3('0x43')],'as':'Tags','attributes':['id',_0xa9b3('0x28'),'color'],'required':_0xe1b740['query']['tag']?!![]:![]}],'attributes':_[_0xa9b3('0x2d')](_0x19e4d7)});})[_0xa9b3('0x25')](function(_0x444a9a){_0x347590=_0x444a9a[_0xa9b3('0x51')]({'plain':!![]});var _0xc571a1={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x444a9a&&_0x444a9a[_0xa9b3('0x73')]){if(_0x444a9a['ListId']){_0xc571a1[_0xa9b3('0x39')][_0xa9b3('0x75')][_0xa9b3('0x3f')]({'ListId':{'$ne':_0x444a9a[_0xa9b3('0x73')]}});}}return db[_0xa9b3('0x76')][_0xa9b3('0x46')](_0xc571a1);})[_0xa9b3('0x25')](function(_0x498bb1){return _[_0xa9b3('0x77')](_0x347590,_[_0xa9b3('0x3b')](_0x498bb1,function(_0x314bb5){return util[_0xa9b3('0x78')](_0xa9b3('0x79'),_0x314bb5['id']);}));})[_0xa9b3('0x25')](handleEntityNotFound(_0x191192,null))[_0xa9b3('0x25')](respondWithResult(_0x191192,null))[_0xa9b3('0x48')](handleError(_0x191192,null));};exports[_0xa9b3('0x23')]=function(_0x576943,_0x1fbafe){var _0x3cdf43;if(_0x576943[_0xa9b3('0x50')]['id']){delete _0x576943['body']['id'];}return db[_0xa9b3('0x2b')][_0xa9b3('0x49')]({'where':{'id':_0x576943[_0xa9b3('0x4a')]['id']}})[_0xa9b3('0x25')](handleEntityNotFound(_0x1fbafe,null))[_0xa9b3('0x25')](saveUpdates(_0x576943['body'],null))[_0xa9b3('0x25')](function(_0x75ad90){_0x3cdf43=_0x75ad90;var _0x572cd3={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x75ad90&&_0x75ad90[_0xa9b3('0x73')]){if(_0x75ad90[_0xa9b3('0x73')]){_0x572cd3[_0xa9b3('0x39')][_0xa9b3('0x75')][_0xa9b3('0x3f')]({'ListId':{'$ne':_0x75ad90['ListId']}});}}return db['CmCustomField'][_0xa9b3('0x46')](_0x572cd3);})['then'](function(_0x376bae){if(_0x376bae){return _[_0xa9b3('0x77')](_['pickBy'](_0x576943['body'],function(_0x22968b,_0x2c1ab7){return _[_0xa9b3('0x4b')](_0x2c1ab7,_0xa9b3('0x4c'));}),_[_0xa9b3('0x3b')](_0x376bae,function(_0x337ce3){return util[_0xa9b3('0x78')](_0xa9b3('0x79'),_0x337ce3['id']);}));}})[_0xa9b3('0x25')](function(_0x25596c){if(_0x25596c&&!_[_0xa9b3('0x7a')](_0x25596c)){var _0x5a7f52=squel[_0xa9b3('0x23')]()[_0xa9b3('0x7b')](_0xa9b3('0x7c'))[_0xa9b3('0x7d')](_0x25596c)['where']('id\x20=\x20?',_0x576943[_0xa9b3('0x4a')]['id'])[_0xa9b3('0x7e')]();return db['sequelize'][_0xa9b3('0x2e')](_0x5a7f52['text'],{'replacements':_0x5a7f52[_0xa9b3('0x7f')]});}})['then'](function(){if(_0x576943[_0xa9b3('0x50')]['phone']&&_0x3cdf43){return db['CmHopper'][_0xa9b3('0x23')]({'phone':_0x576943[_0xa9b3('0x50')][_0xa9b3('0x80')]},{'where':{'ContactId':_0x3cdf43['id']}});}})[_0xa9b3('0x25')](function(){return _0x3cdf43;})[_0xa9b3('0x25')](respondWithResult(_0x1fbafe,null))[_0xa9b3('0x48')](handleError(_0x1fbafe,null));};exports[_0xa9b3('0x81')]=function(_0x5c5ea3,_0xbd10b5,_0x2d40bb){var _0x17cc33={};var _0x53e547={};var _0x5acd75;var _0x143d1b;return db[_0xa9b3('0x2b')]['findOne']({'where':{'id':_0x5c5ea3[_0xa9b3('0x4a')]['id']}})[_0xa9b3('0x25')](handleEntityNotFound(_0xbd10b5,null))[_0xa9b3('0x25')](function(_0x51d665){if(_0x51d665){_0x5acd75=_0x51d665;_0x53e547['model']=_['keys'](db[_0xa9b3('0x43')][_0xa9b3('0x82')]);_0x53e547[_0xa9b3('0x2e')]=_[_0xa9b3('0x2d')](_0x5c5ea3[_0xa9b3('0x2e')]);_0x53e547[_0xa9b3('0x2f')]=_['intersection'](_0x53e547['model'],_0x53e547[_0xa9b3('0x2e')]);_0x17cc33[_0xa9b3('0x31')]=_[_0xa9b3('0x32')](_0x53e547[_0xa9b3('0x30')],qs[_0xa9b3('0x83')](_0x5c5ea3[_0xa9b3('0x2e')][_0xa9b3('0x83')]));_0x17cc33[_0xa9b3('0x31')]=_0x17cc33['attributes'][_0xa9b3('0x33')]?_0x17cc33['attributes']:_0x53e547[_0xa9b3('0x30')];_0x17cc33[_0xa9b3('0x36')]=qs[_0xa9b3('0x84')](_0x5c5ea3[_0xa9b3('0x2e')][_0xa9b3('0x84')]);_0x17cc33[_0xa9b3('0x39')]=qs['filters'](_[_0xa9b3('0x37')](_0x5c5ea3[_0xa9b3('0x2e')],_0x53e547['filters']));if(_0x5c5ea3['query']['filter']){_0x17cc33[_0xa9b3('0x39')]=_[_0xa9b3('0x3a')](_0x17cc33['where'],{'$or':_[_0xa9b3('0x3b')](_0x17cc33[_0xa9b3('0x31')],function(_0x3b3d01){var _0x55f386={};_0x55f386[_0x3b3d01]={'$like':'%'+_0x5c5ea3['query'][_0xa9b3('0x38')]+'%'};return _0x55f386;})});}_0x17cc33=_['merge']({},_0x17cc33,_0x5c5ea3[_0xa9b3('0x3c')]);return _0x5acd75['getTags'](_0x17cc33);}})[_0xa9b3('0x25')](function(_0x59eedb){if(_0x59eedb){_0x143d1b=_0x59eedb[_0xa9b3('0x33')];if(!_0x5c5ea3[_0xa9b3('0x2e')][_0xa9b3('0x4f')](_0xa9b3('0x34'))){_0x17cc33[_0xa9b3('0x35')]=qs['limit'](_0x5c5ea3['query'][_0xa9b3('0x35')]);_0x17cc33[_0xa9b3('0x1f')]=qs[_0xa9b3('0x1f')](_0x5c5ea3['query'][_0xa9b3('0x1f')]);}return _0x5acd75[_0xa9b3('0x81')](_0x17cc33);}})[_0xa9b3('0x25')](function(_0x21580b){if(_0x21580b){return _0x21580b?{'count':_0x143d1b,'rows':_0x21580b}:null;}})[_0xa9b3('0x25')](respondWithResult(_0xbd10b5,null))[_0xa9b3('0x48')](handleError(_0xbd10b5,null));};exports[_0xa9b3('0x85')]=function(_0x11de18,_0x5d6d75,_0x16a9c9){if(_0x11de18['body']['id']){delete _0x11de18[_0xa9b3('0x50')]['id'];}return db[_0xa9b3('0x2b')][_0xa9b3('0x86')]({'where':{'id':_0x11de18[_0xa9b3('0x4a')]['id']}})['then'](handleEntityNotFound(_0x5d6d75,null))['then'](function(_0x4816d6){if(_0x4816d6){return _0x4816d6[_0xa9b3('0x85')](_0x11de18[_0xa9b3('0x50')][_0xa9b3('0x87')]||[]);}return null;})[_0xa9b3('0x25')](respondWithResult(_0x5d6d75,null))[_0xa9b3('0x48')](handleError(_0x5d6d75,null));};exports[_0xa9b3('0x88')]=function(_0xb507,_0xcce6f,_0x47d9a8){var _0xa6b81d={'raw':![],'where':{}};var _0x5e0e9a={};var _0x5ce31d={'count':0x0,'rows':[]};return db[_0xa9b3('0x2b')][_0xa9b3('0x86')]({'where':{'id':_0xb507[_0xa9b3('0x4a')]['id']}})['then'](handleEntityNotFound(_0xcce6f,null))[_0xa9b3('0x25')](function(_0x32f02c){if(_0x32f02c){_0x5e0e9a[_0xa9b3('0x30')]=_[_0xa9b3('0x2d')](db[_0xa9b3('0x58')][_0xa9b3('0x82')]);_0x5e0e9a['query']=_[_0xa9b3('0x2d')](_0xb507[_0xa9b3('0x2e')]);_0x5e0e9a['filters']=_[_0xa9b3('0x32')](_0x5e0e9a['model'],_0x5e0e9a[_0xa9b3('0x2e')]);_0xa6b81d[_0xa9b3('0x31')]=_[_0xa9b3('0x32')](_0x5e0e9a[_0xa9b3('0x30')],qs['fields'](_0xb507[_0xa9b3('0x2e')][_0xa9b3('0x83')]));_0xa6b81d[_0xa9b3('0x31')]=_0xa6b81d['attributes'][_0xa9b3('0x33')]?_0xa6b81d['attributes']:_0x5e0e9a[_0xa9b3('0x30')];if(!_0xb507[_0xa9b3('0x2e')][_0xa9b3('0x4f')]('nolimit')){_0xa6b81d[_0xa9b3('0x35')]=qs[_0xa9b3('0x35')](_0xb507[_0xa9b3('0x2e')]['limit']);_0xa6b81d['offset']=qs[_0xa9b3('0x1f')](_0xb507[_0xa9b3('0x2e')][_0xa9b3('0x1f')]);}_0xa6b81d[_0xa9b3('0x36')]=qs[_0xa9b3('0x84')](_0xb507[_0xa9b3('0x2e')]['sort']);_0xa6b81d[_0xa9b3('0x39')]=qs[_0xa9b3('0x2f')](_[_0xa9b3('0x37')](_0xb507[_0xa9b3('0x2e')],_0x5e0e9a[_0xa9b3('0x2f')]));_0xa6b81d[_0xa9b3('0x39')][_0xa9b3('0x89')]=_0x32f02c['id'];if(_0xb507[_0xa9b3('0x2e')]['filter']){_0xa6b81d['where']=_['merge'](_0xa6b81d[_0xa9b3('0x39')],{'$or':_[_0xa9b3('0x3b')](_0xa6b81d[_0xa9b3('0x31')],function(_0x3c7921){var _0x53f8c1={};_0x53f8c1[_0x3c7921]={'$like':'%'+_0xb507[_0xa9b3('0x2e')][_0xa9b3('0x38')]+'%'};return _0x53f8c1;})});}_0xa6b81d=_[_0xa9b3('0x3a')]({},_0xa6b81d,_0xb507[_0xa9b3('0x3c')]);return db[_0xa9b3('0x58')]['count']({'where':_0xa6b81d['where']})[_0xa9b3('0x25')](function(_0x3a2b03){_0x5ce31d['count']=_0x3a2b03;if(_0xb507[_0xa9b3('0x2e')][_0xa9b3('0x42')]){_0xa6b81d[_0xa9b3('0x3d')]=[{'all':!![]}];}return db[_0xa9b3('0x58')][_0xa9b3('0x46')](_0xa6b81d);})[_0xa9b3('0x25')](function(_0x4c4d1d){_0x5ce31d[_0xa9b3('0x47')]=_0x4c4d1d;return _0x5ce31d;});}})[_0xa9b3('0x25')](respondWithFilteredResult(_0xcce6f,_0xa6b81d))['catch'](handleError(_0xcce6f,null));};exports[_0xa9b3('0x8a')]=function(_0x4babd2,_0x2e54e3,_0x4e1d71){var _0x1b1cd3={'raw':!![],'where':{}};var _0xd2a0e7={};var _0x4e7fce={'count':0x0,'rows':[]};return db[_0xa9b3('0x2b')][_0xa9b3('0x86')]({'where':{'id':_0x4babd2[_0xa9b3('0x4a')]['id']}})[_0xa9b3('0x25')](handleEntityNotFound(_0x2e54e3,null))['then'](function(_0x5f5a10){if(_0x5f5a10){_0xd2a0e7[_0xa9b3('0x30')]=_[_0xa9b3('0x2d')](db[_0xa9b3('0x69')][_0xa9b3('0x82')]);_0xd2a0e7[_0xa9b3('0x2e')]=_[_0xa9b3('0x2d')](_0x4babd2[_0xa9b3('0x2e')]);_0xd2a0e7[_0xa9b3('0x2f')]=_[_0xa9b3('0x32')](_0xd2a0e7['model'],_0xd2a0e7['query']);_0x1b1cd3[_0xa9b3('0x31')]=_[_0xa9b3('0x32')](_0xd2a0e7[_0xa9b3('0x30')],qs[_0xa9b3('0x83')](_0x4babd2[_0xa9b3('0x2e')][_0xa9b3('0x83')]));_0x1b1cd3[_0xa9b3('0x31')]=_0x1b1cd3[_0xa9b3('0x31')][_0xa9b3('0x33')]?_0x1b1cd3['attributes']:_0xd2a0e7[_0xa9b3('0x30')];if(!_0x4babd2[_0xa9b3('0x2e')][_0xa9b3('0x4f')](_0xa9b3('0x34'))){_0x1b1cd3[_0xa9b3('0x35')]=qs[_0xa9b3('0x35')](_0x4babd2[_0xa9b3('0x2e')][_0xa9b3('0x35')]);_0x1b1cd3['offset']=qs['offset'](_0x4babd2[_0xa9b3('0x2e')][_0xa9b3('0x1f')]);}_0x1b1cd3[_0xa9b3('0x36')]=qs[_0xa9b3('0x84')](_0x4babd2[_0xa9b3('0x2e')][_0xa9b3('0x84')]);_0x1b1cd3['where']=qs['filters'](_[_0xa9b3('0x37')](_0x4babd2[_0xa9b3('0x2e')],_0xd2a0e7[_0xa9b3('0x2f')]));_0x1b1cd3['where']['ContactId']=_0x5f5a10['id'];if(_0x4babd2['query'][_0xa9b3('0x38')]){_0x1b1cd3['where']=_['merge'](_0x1b1cd3['where'],{'$or':_[_0xa9b3('0x3b')](_0x1b1cd3[_0xa9b3('0x31')],function(_0x34f051){var _0x35d17d={};_0x35d17d[_0x34f051]={'$like':'%'+_0x4babd2[_0xa9b3('0x2e')][_0xa9b3('0x38')]+'%'};return _0x35d17d;})});}_0x1b1cd3=_[_0xa9b3('0x3a')]({},_0x1b1cd3,_0x4babd2[_0xa9b3('0x3c')]);return db[_0xa9b3('0x69')][_0xa9b3('0x41')]({'where':_0x1b1cd3[_0xa9b3('0x39')]})[_0xa9b3('0x25')](function(_0x2a3b39){_0x4e7fce['count']=_0x2a3b39;if(_0x4babd2['query'][_0xa9b3('0x42')]){_0x1b1cd3[_0xa9b3('0x3d')]=[{'all':!![]}];}return db[_0xa9b3('0x69')][_0xa9b3('0x46')](_0x1b1cd3);})[_0xa9b3('0x25')](function(_0x447e41){_0x4e7fce[_0xa9b3('0x47')]=_0x447e41;return _0x4e7fce;});}})[_0xa9b3('0x25')](respondWithFilteredResult(_0x2e54e3,_0x1b1cd3))[_0xa9b3('0x48')](handleError(_0x2e54e3,null));};exports[_0xa9b3('0x8b')]=function(_0x48c331,_0x37ae15,_0x517545){var _0x800385={'raw':!![],'where':{}};var _0x1b7772={};var _0x1e9c9f={'count':0x0,'rows':[]};return db['CmContact'][_0xa9b3('0x86')]({'where':{'id':_0x48c331[_0xa9b3('0x4a')]['id']}})[_0xa9b3('0x25')](handleEntityNotFound(_0x37ae15,null))['then'](function(_0xd8fc5d){if(_0xd8fc5d){_0x1b7772[_0xa9b3('0x30')]=_[_0xa9b3('0x2d')](db[_0xa9b3('0x68')][_0xa9b3('0x82')]);_0x1b7772[_0xa9b3('0x2e')]=_[_0xa9b3('0x2d')](_0x48c331[_0xa9b3('0x2e')]);_0x1b7772[_0xa9b3('0x2f')]=_[_0xa9b3('0x32')](_0x1b7772['model'],_0x1b7772[_0xa9b3('0x2e')]);_0x800385[_0xa9b3('0x31')]=_[_0xa9b3('0x32')](_0x1b7772['model'],qs[_0xa9b3('0x83')](_0x48c331[_0xa9b3('0x2e')][_0xa9b3('0x83')]));_0x800385['attributes']=_0x800385[_0xa9b3('0x31')]['length']?_0x800385[_0xa9b3('0x31')]:_0x1b7772[_0xa9b3('0x30')];if(!_0x48c331[_0xa9b3('0x2e')][_0xa9b3('0x4f')]('nolimit')){_0x800385[_0xa9b3('0x35')]=qs['limit'](_0x48c331[_0xa9b3('0x2e')][_0xa9b3('0x35')]);_0x800385[_0xa9b3('0x1f')]=qs['offset'](_0x48c331[_0xa9b3('0x2e')][_0xa9b3('0x1f')]);}_0x800385['order']=qs[_0xa9b3('0x84')](_0x48c331[_0xa9b3('0x2e')][_0xa9b3('0x84')]);_0x800385['where']=qs[_0xa9b3('0x2f')](_[_0xa9b3('0x37')](_0x48c331[_0xa9b3('0x2e')],_0x1b7772[_0xa9b3('0x2f')]));_0x800385[_0xa9b3('0x39')][_0xa9b3('0x89')]=_0xd8fc5d['id'];if(_0x48c331['query'][_0xa9b3('0x38')]){_0x800385[_0xa9b3('0x39')]=_[_0xa9b3('0x3a')](_0x800385['where'],{'$or':_['map'](_0x800385[_0xa9b3('0x31')],function(_0x5ee05a){var _0x398073={};_0x398073[_0x5ee05a]={'$like':'%'+_0x48c331[_0xa9b3('0x2e')][_0xa9b3('0x38')]+'%'};return _0x398073;})});}_0x800385=_[_0xa9b3('0x3a')]({},_0x800385,_0x48c331['options']);return db[_0xa9b3('0x68')][_0xa9b3('0x41')]({'where':_0x800385[_0xa9b3('0x39')]})[_0xa9b3('0x25')](function(_0x536b54){_0x1e9c9f[_0xa9b3('0x41')]=_0x536b54;if(_0x48c331[_0xa9b3('0x2e')]['includeAll']){_0x800385[_0xa9b3('0x3d')]=[{'all':!![]}];}return db[_0xa9b3('0x68')][_0xa9b3('0x46')](_0x800385);})[_0xa9b3('0x25')](function(_0x40e005){_0x1e9c9f[_0xa9b3('0x47')]=_0x40e005;return _0x1e9c9f;});}})[_0xa9b3('0x25')](respondWithFilteredResult(_0x37ae15,_0x800385))['catch'](handleError(_0x37ae15,null));};exports[_0xa9b3('0x8c')]=function(_0x41c98e,_0x1c3925,_0x318aaa){var _0x5b79e6={'raw':!![],'where':{}};var _0xbec09d={};var _0x480d24={'count':0x0,'rows':[]};return db[_0xa9b3('0x2b')]['findOne']({'where':{'id':_0x41c98e[_0xa9b3('0x4a')]['id']}})[_0xa9b3('0x25')](handleEntityNotFound(_0x1c3925,null))[_0xa9b3('0x25')](function(_0x20a93e){if(_0x20a93e){_0xbec09d[_0xa9b3('0x30')]=_[_0xa9b3('0x2d')](db['JscriptySessionReport'][_0xa9b3('0x82')]);_0xbec09d[_0xa9b3('0x2e')]=_[_0xa9b3('0x2d')](_0x41c98e[_0xa9b3('0x2e')]);_0xbec09d[_0xa9b3('0x2f')]=_[_0xa9b3('0x32')](_0xbec09d['model'],_0xbec09d[_0xa9b3('0x2e')]);_0x5b79e6['attributes']=_[_0xa9b3('0x32')](_0xbec09d[_0xa9b3('0x30')],qs[_0xa9b3('0x83')](_0x41c98e['query'][_0xa9b3('0x83')]));_0x5b79e6['attributes']=_0x5b79e6[_0xa9b3('0x31')]['length']?_0x5b79e6[_0xa9b3('0x31')]:_0xbec09d[_0xa9b3('0x30')];if(!_0x41c98e['query'][_0xa9b3('0x4f')](_0xa9b3('0x34'))){_0x5b79e6[_0xa9b3('0x35')]=qs[_0xa9b3('0x35')](_0x41c98e[_0xa9b3('0x2e')]['limit']);_0x5b79e6[_0xa9b3('0x1f')]=qs['offset'](_0x41c98e[_0xa9b3('0x2e')][_0xa9b3('0x1f')]);}_0x5b79e6[_0xa9b3('0x36')]=qs[_0xa9b3('0x84')](_0x41c98e['query']['sort']);_0x5b79e6[_0xa9b3('0x39')]=qs[_0xa9b3('0x2f')](_['pick'](_0x41c98e[_0xa9b3('0x2e')],_0xbec09d[_0xa9b3('0x2f')]));_0x5b79e6[_0xa9b3('0x39')][_0xa9b3('0x89')]=_0x20a93e['id'];if(_0x41c98e[_0xa9b3('0x2e')][_0xa9b3('0x38')]){_0x5b79e6[_0xa9b3('0x39')]=_[_0xa9b3('0x3a')](_0x5b79e6['where'],{'$or':_[_0xa9b3('0x3b')](_0x5b79e6['attributes'],function(_0x5f1d28){var _0x51d2e6={};_0x51d2e6[_0x5f1d28]={'$like':'%'+_0x41c98e[_0xa9b3('0x2e')][_0xa9b3('0x38')]+'%'};return _0x51d2e6;})});}_0x5b79e6=_[_0xa9b3('0x3a')]({},_0x5b79e6,_0x41c98e[_0xa9b3('0x3c')]);return db[_0xa9b3('0x8d')][_0xa9b3('0x41')]({'where':_0x5b79e6[_0xa9b3('0x39')]})[_0xa9b3('0x25')](function(_0x3c52bb){_0x480d24['count']=_0x3c52bb;if(_0x41c98e[_0xa9b3('0x2e')]['includeAll']){_0x5b79e6['include']=[{'all':!![]}];}return db[_0xa9b3('0x8d')][_0xa9b3('0x46')](_0x5b79e6);})[_0xa9b3('0x25')](function(_0x2175e5){_0x480d24[_0xa9b3('0x47')]=_0x2175e5;return _0x480d24;});}})[_0xa9b3('0x25')](respondWithFilteredResult(_0x1c3925,_0x5b79e6))[_0xa9b3('0x48')](handleError(_0x1c3925,null));};exports[_0xa9b3('0x8e')]=function(_0x515d1c,_0x1a8cf7,_0x17a5b4){try{if(!_0x515d1c['body']['ListId']){throw new Error('No\x20ListId\x20specified');}if(!_0x515d1c[_0xa9b3('0x50')]['binding_keys']){throw new Error(_0xa9b3('0x8f'));}if(!_0x515d1c['body']['binding_values']){throw new Error('No\x20association\x20values\x20specified!');}if(!_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x90')]){throw new Error(_0xa9b3('0x91'));}var _0x2747f3=_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x92')][_0xa9b3('0x93')](',');var _0x202a1f=_0x515d1c['body'][_0xa9b3('0x94')][_0xa9b3('0x93')](',');if(!_0x2747f3['length']||!_0x202a1f[_0xa9b3('0x33')]||_0x2747f3['length']!==_0x202a1f['length']){throw new Error('Incorrect\x20binding\x20parameters\x20passed!');}_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x83')]=_[_0xa9b3('0x95')](_0x2747f3,_0x202a1f);if(!_0x515d1c['body'][_0xa9b3('0x83')][_0xa9b3('0x80')]){throw new Error(_0xa9b3('0x96'));}if(!_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x83')][_0xa9b3('0x97')]){throw new Error(_0xa9b3('0x98'));}var _0x18dafc=path['join'](config[_0xa9b3('0x99')],_0xa9b3('0x9a'),_0x515d1c['file'][_0xa9b3('0x9b')]);fs[_0xa9b3('0x9c')](_0x18dafc,parseInt(_0xa9b3('0x9d'),0x8));var _0x5c16ff=require('child_process')['fork'](path[_0xa9b3('0x55')](__dirname,_0xa9b3('0x9e')),[_0x18dafc,_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x92')],_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x94')],_0x515d1c['body'][_0xa9b3('0x73')],_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x9f')],_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x71')],_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x90')]]);return _0x1a8cf7[_0xa9b3('0x1d')](0xc8)[_0xa9b3('0x1e')]({'message':_0xa9b3('0xa0'),'pid':_0x5c16ff[_0xa9b3('0xa1')]});}catch(_0x491d33){return _0x1a8cf7['status'](0x1f4)['send'](_0x491d33);}};exports[_0xa9b3('0xa2')]=function(_0x425762,_0x38709e,_0x1f7a1c){var _0x384c81=fs[_0xa9b3('0xa3')](_0x425762['file'][_0xa9b3('0x8')]);Papa['parse'](_0x384c81,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x5d1273){return _0x38709e[_0xa9b3('0x1d')](0xc8)[_0xa9b3('0x1e')]({'file':_0x425762['file'],'fields':_0x5d1273[_0xa9b3('0xa4')]['fields']});}});};exports[_0xa9b3('0xa5')]=function(_0x35f62c,_0x205556,_0x1b3f26){return db[_0xa9b3('0xa6')][_0xa9b3('0x46')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0xa9b3('0x25')](function(_0x31c6d6){var _0x101921=![];if(!_0x35f62c['body'][_0xa9b3('0x73')]){throw new Error(_0xa9b3('0xa7'));}if(!_0x35f62c[_0xa9b3('0x50')][_0xa9b3('0xa8')][_0xa9b3('0x80')]){throw new Error(_0xa9b3('0x96'));}if(!_0x35f62c[_0xa9b3('0x50')]['binding'][_0xa9b3('0x97')]){throw new Error(_0xa9b3('0x98'));}if(!_0x35f62c[_0xa9b3('0x50')][_0xa9b3('0x90')]){throw new Error(_0xa9b3('0x91'));}var _0x58b0e6=require(_0xa9b3('0xa9'))['fork'](path[_0xa9b3('0x55')](__dirname,_0xa9b3('0xaa')),[_0x35f62c[_0xa9b3('0x4a')]['id'],JSON[_0xa9b3('0xab')](_0x35f62c[_0xa9b3('0x50')]),JSON[_0xa9b3('0xab')](_0x31c6d6)]);_0x58b0e6['on']('message',function(_0x2defbb){_0x101921=!![];return _0x205556[_0xa9b3('0x1d')](0xc8)[_0xa9b3('0x1e')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x58b0e6['pid']});});_0x58b0e6['on'](_0xa9b3('0xac'),function(_0x35c2bb){if(_0x35c2bb&&!_0x101921){return _0x205556['status'](0x1f4)['json']({'message':_0xa9b3('0xad'),'pid':_0x58b0e6[_0xa9b3('0xa1')]});}});})[_0xa9b3('0x48')](handleError(_0x205556,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff