18 var _0x24bd=['MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','OpenchannelInteraction','VoiceCallReport','ChatQueueReport','MailQueueReport','OpenchannelQueueReport','JscriptySessionReport','bulkCreate','each','duplicates','$or','ListId','findOrCreate','show','color','$and','omit','format','cf_%d','pickBy','table','setFields','id\x20=\x20?','toParam','phone','rawAttributes','options','getTags','setTags','ids','getHoppers','ContactId','includeAll','include','getHopperHistories','CmHopperHistory','getHopperFinals','CmHopperFinal','uploadCsv','No\x20ListId\x20specified','binding_keys','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','Incorrect\x20binding\x20parameters\x20passed!','No\x20phone\x20column\x20specified','No\x20firstName\x20column\x20specified','server/files/tmp','file','filename','chmodSync','0777','child_process','../../components/import/cm/csv','CompanyId','upload','createReadStream','path','parse','meta','import','agent','binding','fork','../../components/import/cm/csv2','stringify','message','pid','exit','error\x20child\x20process','html-pdf','rimraf','zip-dir','fast-json-patch','util','sox','to-csv','ejs','squel','crypto','jsforce','desk.js','querystring','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','redis','defaults','localhost','socket.io-emitter','register','sendStatus','end','status','json','count','offset','set','reject','save','update','destroy','then','error','stack','name','send','index','CmContact','describe','keys','length','startsWith','cf_','CmCustomField','findOne','all','fieldType','model','query','filters','intersection','attributes','fields','hasOwnProperty','nolimit','limit','order','sort','where','pick','select','field','tools_tags','from','left_join','cm_user_has_contacts','uc.CmContactId\x20=\x20c.id','ct.CmContactId\x20=\x20c.id','t.id\x20=\x20ct.TagId','expr','search','parseSearch','sqlOperator','conditions','find','Tag','value','split','map','forEach','union','User','and','datetime','DATE','type','text','start','filter','isNil','Contact','isEmpty','c.ListId\x20IN\x20?','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','tag','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','replace','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','isNumeric','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','isEmail','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','c.email\x20LIKE\x20?','group','c.id','Sequelize','QueryTypes','SELECT','clone','DESC','having','t.id\x20IN\x20?','resolve','some','getLists','c.ListId\x20IS\x20NULL','sequelize','toString','c.firstName','c.phone','c.mobile','c.fax','c.email','c.ListId','c.deletedAt','TagIds','Tags','push','rows','catch','params','tags','columnName','displayName','findAll','alias','custom','values','merge','body','get','isArray','join','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatOfflineMessage'];(function(_0x4fd764,_0x512d40){var _0x4d936b=function(_0x13057d){while(--_0x13057d){_0x4fd764['push'](_0x4fd764['shift']());}};_0x4d936b(++_0x512d40);}(_0x24bd,0x137));var _0xd24b=function(_0x47b58b,_0x41a189){_0x47b58b=_0x47b58b-0x0;var _0x46bebe=_0x24bd[_0x47b58b];return _0x46bebe;};'use strict';var pdf=require(_0xd24b('0x0'));var emlformat=require('eml-format');var rimraf=require(_0xd24b('0x1'));var zipdir=require(_0xd24b('0x2'));var jsonpatch=require(_0xd24b('0x3'));var rp=require('request-promise');var moment=require('moment');var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0xd24b('0x4'));var path=require('path');var sox=require(_0xd24b('0x5'));var csv=require(_0xd24b('0x6'));var ejs=require(_0xd24b('0x7'));var fs=require('fs');var _=require('lodash');var squel=require(_0xd24b('0x8'));var crypto=require(_0xd24b('0x9'));var jsforce=require(_0xd24b('0xa'));var deskjs=require(_0xd24b('0xb'));var toCsv=require(_0xd24b('0x6'));var querystring=require(_0xd24b('0xc'));var Papa=require('papaparse');var Redis=require(_0xd24b('0xd'));var authService=require('../../components/auth/service');var qs=require(_0xd24b('0xe'));var as=require(_0xd24b('0xf'));var hardwareService=require(_0xd24b('0x10'));var logger=require(_0xd24b('0x11'))(_0xd24b('0x12'));var utils=require(_0xd24b('0x13'));var config=require('../../config/environment');var db=require('../../mysqldb')['db'];config[_0xd24b('0x14')]=_[_0xd24b('0x15')](config[_0xd24b('0x14')],{'host':_0xd24b('0x16'),'port':0x18eb});var socket=require(_0xd24b('0x17'))(new Redis(config[_0xd24b('0x14')]));require('./cmContact.socket')[_0xd24b('0x18')](socket);function respondWithStatusCode(_0x27f8aa,_0x399da9){_0x399da9=_0x399da9||0xcc;return function(_0x20e9fe){if(_0x20e9fe){return _0x27f8aa[_0xd24b('0x19')](_0x399da9);}return _0x27f8aa['status'](_0x399da9)[_0xd24b('0x1a')]();};}function respondWithResult(_0x319ebf,_0x2403e3){_0x2403e3=_0x2403e3||0xc8;return function(_0x37d2df){if(_0x37d2df){return _0x319ebf[_0xd24b('0x1b')](_0x2403e3)[_0xd24b('0x1c')](_0x37d2df);}};}function respondWithFilteredResult(_0x251b22,_0x5d4edc){return function(_0x1d9f93){if(_0x1d9f93){var _0xe5452e=_0x1d9f93[_0xd24b('0x1d')],_0x1ac514=_0x5d4edc[_0xd24b('0x1e')],_0x4e5433=_0x5d4edc[_0xd24b('0x1e')]+_0x5d4edc['limit'],_0xdc8c6e;if(_0x4e5433>=_0xe5452e){_0x4e5433=_0xe5452e;_0xdc8c6e=0xc8;}else{_0xdc8c6e=0xce;}_0x251b22[_0xd24b('0x1b')](_0xdc8c6e);return _0x251b22[_0xd24b('0x1f')]('Content-Range',_0x1ac514+'-'+_0x4e5433+'/'+_0xe5452e)[_0xd24b('0x1c')](_0x1d9f93);}return null;};}function patchUpdates(_0x5e42d6){return function(_0x5d3d46){try{jsonpatch['apply'](_0x5d3d46,_0x5e42d6,!![]);}catch(_0x153010){return BPromise[_0xd24b('0x20')](_0x153010);}return _0x5d3d46[_0xd24b('0x21')]();};}function saveUpdates(_0x17335b,_0x4ff6f5){return function(_0x168df8){if(_0x168df8){return _0x168df8[_0xd24b('0x22')](_0x17335b)['then'](function(_0x2d599c){return _0x2d599c;});}return null;};}function removeEntity(_0x27f37c,_0xe6f87d){return function(_0x535c3e){if(_0x535c3e){return _0x535c3e[_0xd24b('0x23')]()[_0xd24b('0x24')](function(){_0x27f37c[_0xd24b('0x1b')](0xcc)[_0xd24b('0x1a')]();});}};}function handleEntityNotFound(_0x3cdfd8,_0x5925de){return function(_0x4baf07){if(!_0x4baf07){_0x3cdfd8['sendStatus'](0x194);}return _0x4baf07;};}function handleError(_0x239590,_0x13222c){_0x13222c=_0x13222c||0x1f4;return function(_0x3ecbed){logger[_0xd24b('0x25')](_0x3ecbed[_0xd24b('0x26')]);if(_0x3ecbed[_0xd24b('0x27')]){delete _0x3ecbed['name'];}_0x239590[_0xd24b('0x1b')](_0x13222c)[_0xd24b('0x28')](_0x3ecbed);};}exports[_0xd24b('0x29')]=function(_0x251f97,_0x2d0aa2){var _0x12f78e={},_0x37c0e3={},_0x388152={'count':0x0,'rows':[]};return db[_0xd24b('0x2a')][_0xd24b('0x2b')]()[_0xd24b('0x24')](function(_0xc08afa){var _0x171e6a=[];for(var _0x15c471=0x0;_0x15c471<Object[_0xd24b('0x2c')](_0xc08afa)[_0xd24b('0x2d')];_0x15c471++){var _0x3ef7c9=Object[_0xd24b('0x2c')](_0xc08afa)[_0x15c471];if(_[_0xd24b('0x2e')](_0x3ef7c9,_0xd24b('0x2f'))){_0x171e6a['push'](db[_0xd24b('0x30')][_0xd24b('0x31')]({'where':{'id':_['trimStart'](_0x3ef7c9,_0xd24b('0x2f'))},'raw':!![]}));}}return BPromise[_0xd24b('0x32')](_0x171e6a)['then'](function(_0x3785f6){for(var _0x11ecf3=0x0;_0x11ecf3<_0x3785f6['length'];_0x11ecf3++){if(_0x3785f6[_0x11ecf3]){var _0x3a7986=_0xd24b('0x2f')+_0x3785f6[_0x11ecf3]['id'];var _0x95fc8b=_0xc08afa[_0x3a7986];_0x95fc8b[_0xd24b('0x33')]=_0x3785f6[_0x11ecf3]['type'];}}return _0xc08afa;});})[_0xd24b('0x24')](function(_0x65a9a2){_0x37c0e3[_0xd24b('0x34')]=_[_0xd24b('0x2c')](_0x65a9a2);_0x37c0e3[_0xd24b('0x35')]=_[_0xd24b('0x2c')](_0x251f97[_0xd24b('0x35')]);_0x37c0e3[_0xd24b('0x36')]=_[_0xd24b('0x37')](_0x37c0e3[_0xd24b('0x34')],_0x37c0e3[_0xd24b('0x35')]);_0x12f78e[_0xd24b('0x38')]=_[_0xd24b('0x37')](_0x37c0e3[_0xd24b('0x34')],qs[_0xd24b('0x39')](_0x251f97[_0xd24b('0x35')]['fields']));_0x12f78e['attributes']=_0x12f78e[_0xd24b('0x38')][_0xd24b('0x2d')]?_0x12f78e[_0xd24b('0x38')]:_0x37c0e3[_0xd24b('0x34')];if(!_0x251f97['query'][_0xd24b('0x3a')](_0xd24b('0x3b'))){_0x12f78e['limit']=qs[_0xd24b('0x3c')](_0x251f97['query'][_0xd24b('0x3c')]);_0x12f78e[_0xd24b('0x1e')]=qs['offset'](_0x251f97[_0xd24b('0x35')][_0xd24b('0x1e')]);}_0x12f78e[_0xd24b('0x3d')]=qs[_0xd24b('0x3e')](_0x251f97[_0xd24b('0x35')][_0xd24b('0x3e')]);_0x12f78e[_0xd24b('0x3f')]=qs[_0xd24b('0x36')](_[_0xd24b('0x40')](_0x251f97['query'],_0x37c0e3[_0xd24b('0x36')]),_0x65a9a2);var _0x15cdb3=[];var _0x5ef9ab=squel[_0xd24b('0x41')]()[_0xd24b('0x42')]('id')[_0xd24b('0x42')](_0xd24b('0x27'))[_0xd24b('0x42')]('color')['from'](_0xd24b('0x43'));var _0x5cd0d0=squel[_0xd24b('0x41')]()[_0xd24b('0x44')]('cm_contacts','c')[_0xd24b('0x45')](_0xd24b('0x46'),'uc',_0xd24b('0x47'))[_0xd24b('0x45')]('cm_contact_has_tags','ct',_0xd24b('0x48'))[_0xd24b('0x45')]('tools_tags','t',_0xd24b('0x49'))[_0xd24b('0x3f')]('c.deletedAt\x20IS\x20NULL');var _0x5473ad=squel['expr']();var _0x3cc94a=[];var _0x248eb9=squel[_0xd24b('0x4a')]();var _0x84f59e;if(_0x251f97[_0xd24b('0x35')][_0xd24b('0x4b')]){_0x84f59e=as[_0xd24b('0x4c')](_0x251f97[_0xd24b('0x35')][_0xd24b('0x4b')]);var _0x2366cb=_0x84f59e[_0xd24b('0x4d')];for(var _0x3b1a66=0x0;_0x3b1a66<_0x84f59e[_0xd24b('0x4e')]['length'];_0x3b1a66++){var _0x347bc0=_0x84f59e['conditions'][_0x3b1a66];var _0x5f4201='c';var _0x62ddfe=_(_0x65a9a2)[_0xd24b('0x2c')]()[_0xd24b('0x4f')](function(_0x3b8753){return _0x3b8753===_0x347bc0[_0xd24b('0x42')];});if(_0x62ddfe)_0x62ddfe=_0x65a9a2[_0x347bc0[_0xd24b('0x42')]];if(!_0x62ddfe){if(_0x347bc0['field']===_0xd24b('0x50')){var _0x134862=_0x347bc0[_0xd24b('0x51')][_0xd24b('0x52')](',')[_0xd24b('0x53')](function(_0x434364){return Number(_0x434364);});_0x134862[_0xd24b('0x54')](function(_0x4a38b8){_0x248eb9['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x4a38b8+',%');});_0x3cc94a=_[_0xd24b('0x55')](_0x3cc94a,_0x134862);}else if(_0x347bc0[_0xd24b('0x42')]===_0xd24b('0x56')){_0x5473ad[_0xd24b('0x57')]('uc.UserId\x20=\x20?',_0x347bc0[_0xd24b('0x51')]);}}else{if(_0x347bc0[_0xd24b('0x42')]==='dateOfBirth'||_0x62ddfe[_0xd24b('0x33')]===_0xd24b('0x58'))_0x347bc0['castTo']=_0xd24b('0x59');var _0x21875e=as['buildExpression'](_0x5f4201,_0x62ddfe[_0xd24b('0x5a')],_0x347bc0);_0x5473ad[_0x2366cb](_0x21875e[_0xd24b('0x5b')],_0x21875e[_0xd24b('0x51')][_0xd24b('0x5c')],_0x21875e['value']['end']);}}}else{var _0x3e70bb=_(Object[_0xd24b('0x2c')](_0x251f97[_0xd24b('0x35')]))[_0xd24b('0x53')](function(_0x490eee){return _0x65a9a2[_0xd24b('0x3a')](_0x490eee)?_0x490eee:undefined;})[_0xd24b('0x5d')](function(_0xd24595){return!_[_0xd24b('0x5e')](_0xd24595);})[_0xd24b('0x51')]();if(_0x251f97[_0xd24b('0x35')]['Contact'])_0x3e70bb['push'](_0xd24b('0x5f'));if(!_[_0xd24b('0x60')](_0x3e70bb)){_0x3e70bb[_0xd24b('0x54')](function(_0x41e366){if(_0x41e366==='ListId'){_0x5cd0d0[_0xd24b('0x3f')](_0xd24b('0x61'),[][_0xd24b('0x62')](_0x251f97['query'][_0x41e366]));}else if(_0x41e366===_0xd24b('0x5f')){var _0x4af824='%'+_0x251f97['query'][_0x41e366]+'%';_0x5cd0d0[_0xd24b('0x3f')](_0xd24b('0x63'),_0x4af824);}else{_0x5cd0d0[_0xd24b('0x3f')]('c.'+_0x41e366+_0xd24b('0x64'),_0x251f97[_0xd24b('0x35')][_0x41e366]);}});}if(_0x251f97[_0xd24b('0x35')][_0xd24b('0x65')]){_0x3cc94a=_['isArray'](_0x251f97[_0xd24b('0x35')][_0xd24b('0x65')])?_0x251f97[_0xd24b('0x35')][_0xd24b('0x65')]:new Array(_0x251f97['query']['tag']);_0x3cc94a[_0xd24b('0x54')](function(_0x1a7094){_0x248eb9['or'](_0xd24b('0x66'),'%,'+_0x1a7094+',%');});}if(_0x251f97[_0xd24b('0x35')]['filter']){var _0x345fcc=_0x251f97['query']['filter'][_0xd24b('0x67')]('\x5c','\x5c\x5c')[_0xd24b('0x67')]('\x27\x27','\x27\x27\x27\x27');if(_0x345fcc[_0xd24b('0x52')]('\x20')[_0xd24b('0x2d')]>0x1){_0x5473ad['or'](_0xd24b('0x68'),qs[_0xd24b('0x69')](_0x345fcc),null);}else{if(qs[_0xd24b('0x6a')](_0x345fcc)){_0x5473ad['or'](_0xd24b('0x6b'),_0x345fcc+'%');_0x5473ad['or'](_0xd24b('0x6c'),_0x345fcc+'%');_0x5473ad['or']('c.mobile\x20LIKE\x20?',_0x345fcc+'%');_0x5473ad['or']('c.fax\x20LIKE\x20?',_0x345fcc+'%');}else if(qs[_0xd24b('0x6d')](_0x345fcc)){_0x5473ad['or']('c.email\x20LIKE\x20?',_0x345fcc+'%');}else{_0x5473ad['or'](_0xd24b('0x6e'),'%'+_0x345fcc+'%');_0x5473ad['or'](_0xd24b('0x6f'),'%'+_0x345fcc+'%');_0x5473ad['or'](_0xd24b('0x70'),'%'+_0x345fcc+'%');}}}}_0x5cd0d0[_0xd24b('0x3f')](_0x5473ad);_0x5cd0d0[_0xd24b('0x71')](_0xd24b('0x72'));var _0x302775={'type':db[_0xd24b('0x73')][_0xd24b('0x74')][_0xd24b('0x75')],'raw':!![]};var _0x53ada1=_0x5cd0d0[_0xd24b('0x76')]()[_0xd24b('0x42')](_0xd24b('0x72'));if(_0x12f78e[_0xd24b('0x3d')]){_0x12f78e['order']['forEach'](function(_0x33dd49){_0x5cd0d0['order']('c.'+_0x33dd49[0x0],_0x33dd49[0x1]===_0xd24b('0x77')?![]:!![]);});}if(!_['isEmpty'](_0x3cc94a)){_0x5cd0d0[_0xd24b('0x78')](_0x248eb9);_0x53ada1[_0xd24b('0x3f')](_0xd24b('0x79'),_0x3cc94a);}BPromise[_0xd24b('0x7a')]()['then'](function(){if(_0x84f59e&&!_[_0xd24b('0x7b')](_0x84f59e['conditions'],[_0xd24b('0x42'),_0xd24b('0x56')])){return _0x251f97['user'][_0xd24b('0x7c')]({'attributes':['id'],'raw':!![]})[_0xd24b('0x24')](function(_0x4c43b9){if(_[_0xd24b('0x60')](_0x4c43b9)){_0x53ada1[_0xd24b('0x3f')](_0xd24b('0x7d'));_0x5cd0d0[_0xd24b('0x3f')](_0xd24b('0x7d'));}else{_0x53ada1[_0xd24b('0x3f')](_0xd24b('0x61'),_[_0xd24b('0x53')](_0x4c43b9,'id'));_0x5cd0d0['where'](_0xd24b('0x61'),_[_0xd24b('0x53')](_0x4c43b9,'id'));}});}else{return;}})[_0xd24b('0x24')](function(){db[_0xd24b('0x7e')]['query'](_0x53ada1[_0xd24b('0x7f')](),_0x302775)['then'](function(_0x2ecae3){_0x388152[_0xd24b('0x1d')]=_0x2ecae3['length'];if(_0x388152[_0xd24b('0x1d')]===0x0)return[];return db[_0xd24b('0x7e')]['query'](_0x5ef9ab[_0xd24b('0x7f')](),_0x302775);})[_0xd24b('0x24')](function(_0x4d4d16){_0x15cdb3=_['keyBy'](_0x4d4d16,'id');_0x302775=_['merge'](_0x302775,{'model':db[_0xd24b('0x2a')],'mapToModel':!![],'raw':!![],'nest':!![]});if(_0x251f97['query'][_0xd24b('0x39')]){_0x12f78e[_0xd24b('0x38')][_0xd24b('0x54')](function(_0x560a1f){_0x5cd0d0['field']('c.'+_0x560a1f);});}else{_0x5cd0d0[_0xd24b('0x42')](_0xd24b('0x72'));_0x5cd0d0[_0xd24b('0x42')](_0xd24b('0x80'));_0x5cd0d0['field']('c.lastName');_0x5cd0d0['field'](_0xd24b('0x81'));_0x5cd0d0[_0xd24b('0x42')](_0xd24b('0x82'));_0x5cd0d0[_0xd24b('0x42')](_0xd24b('0x83'));_0x5cd0d0[_0xd24b('0x42')](_0xd24b('0x84'));_0x5cd0d0[_0xd24b('0x42')](_0xd24b('0x85'));_0x5cd0d0['field'](_0xd24b('0x86'));_0x5cd0d0[_0xd24b('0x42')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0xd24b('0x87'));}if(_0x12f78e[_0xd24b('0x3c')])_0x5cd0d0[_0xd24b('0x3c')](_0x12f78e[_0xd24b('0x3c')]);if(_0x12f78e['offset'])_0x5cd0d0[_0xd24b('0x1e')](_0x12f78e['offset']);return db[_0xd24b('0x7e')][_0xd24b('0x35')](_0x5cd0d0[_0xd24b('0x7f')](),_0x302775);})[_0xd24b('0x24')](function(_0x3260c3){_0x3260c3[_0xd24b('0x54')](function(_0x303676){if(_0x303676['TagIds']){_0x303676[_0xd24b('0x88')]=[];_0x303676['TagIds'][_0xd24b('0x52')](',')['forEach'](function(_0x503abf){_0x303676['Tags'][_0xd24b('0x89')](_0x15cdb3[_0x503abf]);});}delete _0x303676[_0xd24b('0x87')];});_0x388152[_0xd24b('0x8a')]=_0x3260c3;return _0x388152;})[_0xd24b('0x24')](respondWithFilteredResult(_0x2d0aa2,_0x12f78e));});})[_0xd24b('0x8b')](handleError(_0x2d0aa2,null));};exports[_0xd24b('0x23')]=function(_0xc99c2c,_0x278c7d){return db[_0xd24b('0x2a')][_0xd24b('0x4f')]({'where':{'id':_0xc99c2c[_0xd24b('0x8c')]['id']}})['then'](handleEntityNotFound(_0x278c7d,null))[_0xd24b('0x24')](removeEntity(_0x278c7d,null))[_0xd24b('0x8b')](handleError(_0x278c7d,null));};exports['describe']=function(_0x1d7cbd,_0x58dbe1){return db[_0xd24b('0x2a')][_0xd24b('0x2b')]()[_0xd24b('0x24')](function(_0x15082f){delete _0x15082f[_0xd24b('0x8d')];for(var _0x386b62=0x0;_0x386b62<Object['keys'](_0x15082f)[_0xd24b('0x2d')];_0x386b62++){var _0x3c819f=Object[_0xd24b('0x2c')](_0x15082f)[_0x386b62];if(!_[_0xd24b('0x2e')](_0x3c819f,_0xd24b('0x2f'))){_0x15082f[_0x3c819f][_0xd24b('0x8e')]=_0x3c819f;_0x15082f[_0x3c819f][_0xd24b('0x8f')]=_0x3c819f;}}return _0x15082f;})[_0xd24b('0x24')](function(_0x14143b){var _0x2e58a9={'where':{'$or':[{'ListId':_0x1d7cbd[_0xd24b('0x35')]['id']},{'ListId':null}]},'raw':!![]};return db[_0xd24b('0x30')][_0xd24b('0x90')](_0x2e58a9)[_0xd24b('0x24')](function(_0x564c4a){for(var _0x3a0f39=0x0;_0x3a0f39<_0x564c4a[_0xd24b('0x2d')];_0x3a0f39++){var _0x4fd095='cf_'+_0x564c4a[_0x3a0f39]['id'];_0x14143b[_0x4fd095]['columnName']=_0x4fd095;_0x14143b[_0x4fd095][_0xd24b('0x8f')]=_0x564c4a[_0x3a0f39][_0xd24b('0x91')];_0x14143b[_0x4fd095][_0xd24b('0x92')]={'type':_0x564c4a[_0x3a0f39]['type'],'values':_0x564c4a[_0x3a0f39][_0xd24b('0x93')]};}Object['keys'](_0x14143b)[_0xd24b('0x54')](function(_0x5eb2c5){if(!_0x14143b[_0x5eb2c5]['hasOwnProperty'](_0xd24b('0x8e'))){delete _0x14143b[_0x5eb2c5];}});return _0x14143b;});})['then'](respondWithResult(_0x58dbe1,null))[_0xd24b('0x8b')](handleError(_0x58dbe1,null));};exports[_0xd24b('0x94')]=function(_0x3cf96f,_0x766b55){var _0x427e97;var _0x3adfdd;var _0x35a54f;if(_0x3cf96f[_0xd24b('0x95')]['id']){delete _0x3cf96f[_0xd24b('0x95')]['id'];}return db[_0xd24b('0x2a')][_0xd24b('0x90')]({'where':{'id':[_0x3cf96f[_0xd24b('0x95')]['to'],_0x3cf96f[_0xd24b('0x95')][_0xd24b('0x44')]]}})['then'](function(_0x324af4){if(_0x324af4){if(_0x324af4[_0xd24b('0x2d')]!==0x2){return null;}_0x324af4[0x0]=_0x324af4[0x0][_0xd24b('0x96')]({'plain':!![]});_0x324af4[0x1]=_0x324af4[0x1][_0xd24b('0x96')]({'plain':!![]});delete _0x324af4[0x0]['id'];delete _0x324af4[0x1]['id'];return _['mergeWith'](_0x324af4[0x0],_0x324af4[0x1],function(_0x250f7d,_0x399e5f){if(Array['isArray'](_0x399e5f)&&!_0x399e5f[_0xd24b('0x2d')]){return _0x250f7d;}else if(!_0x399e5f){return _0x250f7d;}});}})[_0xd24b('0x24')](handleEntityNotFound(_0x766b55,null))['then'](function(_0x5bc34c){if(_0x5bc34c){if(_0x5bc34c[_0xd24b('0x8d')]&&_[_0xd24b('0x97')](_0x5bc34c[_0xd24b('0x8d')])){_0x5bc34c[_0xd24b('0x8d')]=_0x5bc34c[_0xd24b('0x8d')][_0xd24b('0x98')]();}logger[_0xd24b('0x99')](_0xd24b('0x9a'),_0x3cf96f['body']['to'],_0x3cf96f[_0xd24b('0x95')][_0xd24b('0x44')]);return db[_0xd24b('0x9b')][_0xd24b('0x23')]({'where':{'ContactId':[_0x3cf96f[_0xd24b('0x95')]['to'],_0x3cf96f[_0xd24b('0x95')][_0xd24b('0x44')]]}})[_0xd24b('0x24')](function(_0x493d3c){logger[_0xd24b('0x99')]('[CmContact][merge][destroy][CmHopper],\x20%s',_0x493d3c);return db[_0xd24b('0x9c')][_0xd24b('0x23')]({'where':{'ContactId':[_0x3cf96f[_0xd24b('0x95')]['to'],_0x3cf96f[_0xd24b('0x95')][_0xd24b('0x44')]]}})[_0xd24b('0x24')](function(_0x48a907){logger['info'](_0xd24b('0x9d'),_0x48a907);return db[_0xd24b('0x2a')][_0xd24b('0x9e')](_0x5bc34c);});});}})[_0xd24b('0x24')](function(_0x47b47d){if(_0x47b47d){_0x427e97=_0x47b47d;_0x3adfdd={'ContactId':_0x427e97['id']};_0x35a54f={'where':{'ContactId':[_0x3cf96f[_0xd24b('0x95')]['to'],_0x3cf96f[_0xd24b('0x95')][_0xd24b('0x44')]]}};return db[_0xd24b('0x9f')][_0xd24b('0x22')](_0x3adfdd,_0x35a54f);}})['then'](function(){if(_0x427e97){return db['ChatMessage']['update'](_0x3adfdd,_0x35a54f);}})[_0xd24b('0x24')](function(){if(_0x427e97){return db[_0xd24b('0xa0')][_0xd24b('0x22')](_0x3adfdd,_0x35a54f);}})['then'](function(){if(_0x427e97){return db[_0xd24b('0xa1')][_0xd24b('0x22')](_0x3adfdd,_0x35a54f);}})[_0xd24b('0x24')](function(){if(_0x427e97){return db[_0xd24b('0xa2')]['update'](_0x3adfdd,_0x35a54f);}})[_0xd24b('0x24')](function(){if(_0x427e97){return db[_0xd24b('0xa1')][_0xd24b('0x22')](_0x3adfdd,_0x35a54f);}})[_0xd24b('0x24')](function(){if(_0x427e97){return db['MailMessage'][_0xd24b('0x22')](_0x3adfdd,_0x35a54f);}})[_0xd24b('0x24')](function(){if(_0x427e97){return db[_0xd24b('0xa3')][_0xd24b('0x22')](_0x3adfdd,_0x35a54f);}})[_0xd24b('0x24')](function(){if(_0x427e97){return db[_0xd24b('0xa4')]['update'](_0x3adfdd,_0x35a54f);}})['then'](function(){if(_0x427e97){return db[_0xd24b('0xa5')][_0xd24b('0x22')](_0x3adfdd,_0x35a54f);}})['then'](function(){if(_0x427e97){return db['FaxMessage']['update'](_0x3adfdd,_0x35a54f);}})[_0xd24b('0x24')](function(){if(_0x427e97){return db[_0xd24b('0xa6')]['update'](_0x3adfdd,_0x35a54f);}})['then'](function(){if(_0x427e97){return db['OpenchannelMessage'][_0xd24b('0x22')](_0x3adfdd,_0x35a54f);}})[_0xd24b('0x24')](function(){if(_0x427e97){return db['CmHopperFinal']['update'](_0x3adfdd,_0x35a54f);}})[_0xd24b('0x24')](function(){if(_0x427e97){return db['CmHopperHistory'][_0xd24b('0x22')](_0x3adfdd,_0x35a54f);}})['then'](function(){if(_0x427e97){return db['ReportAgentPreview'][_0xd24b('0x22')](_0x3adfdd,_0x35a54f);}})['then'](function(){if(_0x427e97){return db[_0xd24b('0xa7')][_0xd24b('0x22')](_0x3adfdd,_0x35a54f);}})['then'](function(){if(_0x427e97){return db[_0xd24b('0xa8')][_0xd24b('0x22')](_0x3adfdd,_0x35a54f);}})[_0xd24b('0x24')](function(){if(_0x427e97){return db['FaxQueueReport'][_0xd24b('0x22')](_0x3adfdd,_0x35a54f);}})[_0xd24b('0x24')](function(){if(_0x427e97){return db[_0xd24b('0xa9')][_0xd24b('0x22')](_0x3adfdd,_0x35a54f);}})[_0xd24b('0x24')](function(){if(_0x427e97){return db[_0xd24b('0xaa')]['update'](_0x3adfdd,_0x35a54f);}})[_0xd24b('0x24')](function(){if(_0x427e97){return db['SmsQueueReport']['update'](_0x3adfdd,_0x35a54f);}})[_0xd24b('0x24')](function(){if(_0x427e97){return db[_0xd24b('0xab')][_0xd24b('0x22')](_0x3adfdd,_0x35a54f);}})[_0xd24b('0x24')](function(){if(_0x427e97){return db['CmContact']['destroy']({'where':{'id':[_0x3cf96f['body']['to'],_0x3cf96f['body'][_0xd24b('0x44')]]}});}})[_0xd24b('0x24')](function(){if(_0x427e97){return _0x427e97;}})[_0xd24b('0x24')](respondWithResult(_0x766b55,null))[_0xd24b('0x8b')](handleError(_0x766b55,null));};exports[_0xd24b('0x9e')]=function(_0x479cca,_0x6c1879){return db[_0xd24b('0x2a')][_0xd24b('0x2b')]()['then'](function(_0x52cd72){if(_0x479cca[_0xd24b('0x95')][_0xd24b('0x8d')]&&_['isArray'](_0x479cca[_0xd24b('0x95')][_0xd24b('0x8d')])){if(_0x479cca['body'][_0xd24b('0x8d')]['length']){_0x479cca['body']['tags']=_0x479cca['body'][_0xd24b('0x8d')][_0xd24b('0x98')](';')+';';}else{_0x479cca[_0xd24b('0x95')][_0xd24b('0x8d')]=null;}}else{_0x479cca[_0xd24b('0x95')][_0xd24b('0x8d')]=null;}return db[_0xd24b('0x2a')][_0xd24b('0x9e')](_0x479cca[_0xd24b('0x95')],{'fields':_[_0xd24b('0x2c')](_0x52cd72),'raw':!![]});})[_0xd24b('0x24')](respondWithResult(_0x6c1879,0xc9))[_0xd24b('0x8b')](handleError(_0x6c1879,null));};exports[_0xd24b('0xac')]=function(_0x29bea4,_0x260e57){var _0x5a2bc6=[];var _0x330ac7=0x0;var _0x142d7b=0x0;var _0x3b656c=0x0;return db[_0xd24b('0x2a')]['describe']()['then'](function(_0x57a97c){return BPromise[_0xd24b('0xad')](_0x29bea4[_0xd24b('0x95')],function(_0x4ea288){var _0x1835cb={'where':{'$or':[]},'defaults':_0x4ea288,'fields':_['keys'](_0x57a97c),'raw':!![]};if(_0x4ea288['duplicates']){for(var _0x435faa=0x0;_0x435faa<_0x4ea288[_0xd24b('0xae')][_0xd24b('0x2d')];_0x435faa++){var _0x24032a={};_0x24032a[_0x4ea288[_0xd24b('0xae')][_0x435faa]]=_0x4ea288[_0x4ea288[_0xd24b('0xae')][_0x435faa]];_0x1835cb[_0xd24b('0x3f')][_0xd24b('0xaf')]['push'](_0x24032a);}_0x1835cb[_0xd24b('0x3f')][_0xd24b('0xb0')]=_0x4ea288['ListId'];}return db[_0xd24b('0x2a')][_0xd24b('0xb1')](_0x1835cb)['spread'](function(_0xf43e4f,_0x399b11){if(_0x399b11){_0x330ac7++;}else{_0x3b656c++;}})[_0xd24b('0x8b')](function(_0x57a94b){console['error'](_0x57a94b);_0x142d7b++;});});})[_0xd24b('0x24')](function(_0x898198){if(_0x898198){return{'success':_0x330ac7,'failure':_0x142d7b,'duplicates':_0x3b656c};}})['then'](respondWithResult(_0x260e57,0xc9))[_0xd24b('0x8b')](handleError(_0x260e57,null));};exports[_0xd24b('0xb2')]=function(_0x1611dd,_0x96496e,_0x1b4e37){var _0x1cdc90;return db[_0xd24b('0x2a')][_0xd24b('0x2b')]()[_0xd24b('0x24')](function(_0x8891a9){return db['CmContact']['find']({'where':{'id':_0x1611dd[_0xd24b('0x8c')]['id']},'include':[{'model':db[_0xd24b('0x50')],'as':'Tags','attributes':['id','name',_0xd24b('0xb3')],'required':_0x1611dd['query'][_0xd24b('0x65')]?!![]:![]}],'attributes':_['keys'](_0x8891a9)});})[_0xd24b('0x24')](function(_0x5d66e7){_0x1cdc90=_0x5d66e7[_0xd24b('0x96')]({'plain':!![]});var _0x473812={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x5d66e7&&_0x5d66e7[_0xd24b('0xb0')]){if(_0x5d66e7[_0xd24b('0xb0')]){_0x473812['where'][_0xd24b('0xb4')][_0xd24b('0x89')]({'ListId':{'$ne':_0x5d66e7['ListId']}});}}return db[_0xd24b('0x30')][_0xd24b('0x90')](_0x473812);})[_0xd24b('0x24')](function(_0x5639b3){return _[_0xd24b('0xb5')](_0x1cdc90,_[_0xd24b('0x53')](_0x5639b3,function(_0x2c5e40){return util[_0xd24b('0xb6')](_0xd24b('0xb7'),_0x2c5e40['id']);}));})[_0xd24b('0x24')](handleEntityNotFound(_0x96496e,null))['then'](respondWithResult(_0x96496e,null))[_0xd24b('0x8b')](handleError(_0x96496e,null));};exports[_0xd24b('0x22')]=function(_0x410c50,_0x5375a2){var _0x10ccb9;if(_0x410c50[_0xd24b('0x95')]['id']){delete _0x410c50[_0xd24b('0x95')]['id'];}return db[_0xd24b('0x2a')][_0xd24b('0x4f')]({'where':{'id':_0x410c50[_0xd24b('0x8c')]['id']}})[_0xd24b('0x24')](handleEntityNotFound(_0x5375a2,null))[_0xd24b('0x24')](saveUpdates(_0x410c50[_0xd24b('0x95')],null))[_0xd24b('0x24')](function(_0x4edbe1){_0x10ccb9=_0x4edbe1;var _0x3cfe98={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x4edbe1&&_0x4edbe1[_0xd24b('0xb0')]){if(_0x4edbe1[_0xd24b('0xb0')]){_0x3cfe98['where']['$and'][_0xd24b('0x89')]({'ListId':{'$ne':_0x4edbe1[_0xd24b('0xb0')]}});}}return db[_0xd24b('0x30')]['findAll'](_0x3cfe98);})[_0xd24b('0x24')](function(_0x18e453){if(_0x18e453){return _[_0xd24b('0xb5')](_[_0xd24b('0xb8')](_0x410c50[_0xd24b('0x95')],function(_0x50e4b4,_0x19d1f1){return _[_0xd24b('0x2e')](_0x19d1f1,'cf_');}),_[_0xd24b('0x53')](_0x18e453,function(_0x8af5ed){return util[_0xd24b('0xb6')](_0xd24b('0xb7'),_0x8af5ed['id']);}));}})['then'](function(_0x1effac){if(_0x1effac&&!_[_0xd24b('0x60')](_0x1effac)){var _0x1ecd02=squel[_0xd24b('0x22')]()[_0xd24b('0xb9')]('cm_contacts')[_0xd24b('0xba')](_0x1effac)[_0xd24b('0x3f')](_0xd24b('0xbb'),_0x410c50[_0xd24b('0x8c')]['id'])[_0xd24b('0xbc')]();return db['sequelize'][_0xd24b('0x35')](_0x1ecd02[_0xd24b('0x5b')],{'replacements':_0x1ecd02['values']});}})[_0xd24b('0x24')](function(){if(_0x410c50[_0xd24b('0x95')][_0xd24b('0xbd')]&&_0x10ccb9){return db[_0xd24b('0x9b')][_0xd24b('0x22')]({'phone':_0x410c50[_0xd24b('0x95')]['phone']},{'where':{'ContactId':_0x10ccb9['id']}});}})[_0xd24b('0x24')](function(){return _0x10ccb9;})['then'](respondWithResult(_0x5375a2,null))['catch'](handleError(_0x5375a2,null));};exports['getTags']=function(_0x18a6b9,_0x36b400,_0x54d7ee){var _0x8df17a={};var _0x35ec15={};var _0x2578fe;var _0x1abe00;return db[_0xd24b('0x2a')][_0xd24b('0x31')]({'where':{'id':_0x18a6b9[_0xd24b('0x8c')]['id']}})[_0xd24b('0x24')](handleEntityNotFound(_0x36b400,null))[_0xd24b('0x24')](function(_0x5b44f5){if(_0x5b44f5){_0x2578fe=_0x5b44f5;_0x35ec15[_0xd24b('0x34')]=_[_0xd24b('0x2c')](db[_0xd24b('0x50')][_0xd24b('0xbe')]);_0x35ec15[_0xd24b('0x35')]=_['keys'](_0x18a6b9[_0xd24b('0x35')]);_0x35ec15[_0xd24b('0x36')]=_[_0xd24b('0x37')](_0x35ec15[_0xd24b('0x34')],_0x35ec15['query']);_0x8df17a[_0xd24b('0x38')]=_[_0xd24b('0x37')](_0x35ec15[_0xd24b('0x34')],qs['fields'](_0x18a6b9[_0xd24b('0x35')][_0xd24b('0x39')]));_0x8df17a[_0xd24b('0x38')]=_0x8df17a[_0xd24b('0x38')]['length']?_0x8df17a['attributes']:_0x35ec15[_0xd24b('0x34')];_0x8df17a['order']=qs['sort'](_0x18a6b9[_0xd24b('0x35')][_0xd24b('0x3e')]);_0x8df17a['where']=qs['filters'](_['pick'](_0x18a6b9['query'],_0x35ec15[_0xd24b('0x36')]));if(_0x18a6b9[_0xd24b('0x35')][_0xd24b('0x5d')]){_0x8df17a['where']=_[_0xd24b('0x94')](_0x8df17a[_0xd24b('0x3f')],{'$or':_['map'](_0x8df17a[_0xd24b('0x38')],function(_0x621fc6){var _0x9b8451={};_0x9b8451[_0x621fc6]={'$like':'%'+_0x18a6b9[_0xd24b('0x35')]['filter']+'%'};return _0x9b8451;})});}_0x8df17a=_[_0xd24b('0x94')]({},_0x8df17a,_0x18a6b9[_0xd24b('0xbf')]);return _0x2578fe[_0xd24b('0xc0')](_0x8df17a);}})[_0xd24b('0x24')](function(_0x1cd4e1){if(_0x1cd4e1){_0x1abe00=_0x1cd4e1[_0xd24b('0x2d')];if(!_0x18a6b9[_0xd24b('0x35')][_0xd24b('0x3a')](_0xd24b('0x3b'))){_0x8df17a[_0xd24b('0x3c')]=qs[_0xd24b('0x3c')](_0x18a6b9[_0xd24b('0x35')][_0xd24b('0x3c')]);_0x8df17a[_0xd24b('0x1e')]=qs[_0xd24b('0x1e')](_0x18a6b9[_0xd24b('0x35')][_0xd24b('0x1e')]);}return _0x2578fe['getTags'](_0x8df17a);}})[_0xd24b('0x24')](function(_0x47a35b){if(_0x47a35b){return _0x47a35b?{'count':_0x1abe00,'rows':_0x47a35b}:null;}})[_0xd24b('0x24')](respondWithResult(_0x36b400,null))[_0xd24b('0x8b')](handleError(_0x36b400,null));};exports[_0xd24b('0xc1')]=function(_0x2ca425,_0x4e338b,_0x11f07b){if(_0x2ca425[_0xd24b('0x95')]['id']){delete _0x2ca425['body']['id'];}return db[_0xd24b('0x2a')][_0xd24b('0x31')]({'where':{'id':_0x2ca425[_0xd24b('0x8c')]['id']}})[_0xd24b('0x24')](handleEntityNotFound(_0x4e338b,null))[_0xd24b('0x24')](function(_0x2f7ee7){if(_0x2f7ee7){return _0x2f7ee7[_0xd24b('0xc1')](_0x2ca425[_0xd24b('0x95')][_0xd24b('0xc2')]||[]);}return null;})[_0xd24b('0x24')](respondWithResult(_0x4e338b,null))['catch'](handleError(_0x4e338b,null));};exports[_0xd24b('0xc3')]=function(_0x8f1a80,_0x523c1b,_0x3eaaae){var _0x4165eb={'raw':![],'where':{}};var _0x2819c={};var _0x36953b={'count':0x0,'rows':[]};return db[_0xd24b('0x2a')]['findOne']({'where':{'id':_0x8f1a80[_0xd24b('0x8c')]['id']}})[_0xd24b('0x24')](handleEntityNotFound(_0x523c1b,null))[_0xd24b('0x24')](function(_0x24ef92){if(_0x24ef92){_0x2819c[_0xd24b('0x34')]=_[_0xd24b('0x2c')](db[_0xd24b('0x9b')]['rawAttributes']);_0x2819c[_0xd24b('0x35')]=_[_0xd24b('0x2c')](_0x8f1a80[_0xd24b('0x35')]);_0x2819c[_0xd24b('0x36')]=_[_0xd24b('0x37')](_0x2819c[_0xd24b('0x34')],_0x2819c[_0xd24b('0x35')]);_0x4165eb[_0xd24b('0x38')]=_['intersection'](_0x2819c[_0xd24b('0x34')],qs[_0xd24b('0x39')](_0x8f1a80['query']['fields']));_0x4165eb[_0xd24b('0x38')]=_0x4165eb[_0xd24b('0x38')]['length']?_0x4165eb[_0xd24b('0x38')]:_0x2819c[_0xd24b('0x34')];if(!_0x8f1a80['query']['hasOwnProperty']('nolimit')){_0x4165eb[_0xd24b('0x3c')]=qs['limit'](_0x8f1a80[_0xd24b('0x35')][_0xd24b('0x3c')]);_0x4165eb['offset']=qs[_0xd24b('0x1e')](_0x8f1a80['query'][_0xd24b('0x1e')]);}_0x4165eb[_0xd24b('0x3d')]=qs[_0xd24b('0x3e')](_0x8f1a80[_0xd24b('0x35')][_0xd24b('0x3e')]);_0x4165eb[_0xd24b('0x3f')]=qs[_0xd24b('0x36')](_[_0xd24b('0x40')](_0x8f1a80[_0xd24b('0x35')],_0x2819c[_0xd24b('0x36')]));_0x4165eb[_0xd24b('0x3f')][_0xd24b('0xc4')]=_0x24ef92['id'];if(_0x8f1a80[_0xd24b('0x35')]['filter']){_0x4165eb['where']=_['merge'](_0x4165eb[_0xd24b('0x3f')],{'$or':_[_0xd24b('0x53')](_0x4165eb[_0xd24b('0x38')],function(_0x30a31e){var _0x2ca914={};_0x2ca914[_0x30a31e]={'$like':'%'+_0x8f1a80[_0xd24b('0x35')][_0xd24b('0x5d')]+'%'};return _0x2ca914;})});}_0x4165eb=_[_0xd24b('0x94')]({},_0x4165eb,_0x8f1a80[_0xd24b('0xbf')]);return db[_0xd24b('0x9b')][_0xd24b('0x1d')]({'where':_0x4165eb['where']})['then'](function(_0x47d7f9){_0x36953b['count']=_0x47d7f9;if(_0x8f1a80[_0xd24b('0x35')][_0xd24b('0xc5')]){_0x4165eb[_0xd24b('0xc6')]=[{'all':!![]}];}return db[_0xd24b('0x9b')][_0xd24b('0x90')](_0x4165eb);})['then'](function(_0x3cb5e4){_0x36953b[_0xd24b('0x8a')]=_0x3cb5e4;return _0x36953b;});}})[_0xd24b('0x24')](respondWithFilteredResult(_0x523c1b,_0x4165eb))[_0xd24b('0x8b')](handleError(_0x523c1b,null));};exports[_0xd24b('0xc7')]=function(_0x45c969,_0x64f761,_0x52f462){var _0x16ea5f={'raw':!![],'where':{}};var _0x55ef05={};var _0x15f644={'count':0x0,'rows':[]};return db[_0xd24b('0x2a')][_0xd24b('0x31')]({'where':{'id':_0x45c969[_0xd24b('0x8c')]['id']}})['then'](handleEntityNotFound(_0x64f761,null))['then'](function(_0x37a75c){if(_0x37a75c){_0x55ef05[_0xd24b('0x34')]=_['keys'](db[_0xd24b('0xc8')][_0xd24b('0xbe')]);_0x55ef05[_0xd24b('0x35')]=_[_0xd24b('0x2c')](_0x45c969[_0xd24b('0x35')]);_0x55ef05[_0xd24b('0x36')]=_[_0xd24b('0x37')](_0x55ef05[_0xd24b('0x34')],_0x55ef05['query']);_0x16ea5f[_0xd24b('0x38')]=_[_0xd24b('0x37')](_0x55ef05['model'],qs['fields'](_0x45c969[_0xd24b('0x35')][_0xd24b('0x39')]));_0x16ea5f[_0xd24b('0x38')]=_0x16ea5f['attributes'][_0xd24b('0x2d')]?_0x16ea5f[_0xd24b('0x38')]:_0x55ef05['model'];if(!_0x45c969[_0xd24b('0x35')]['hasOwnProperty'](_0xd24b('0x3b'))){_0x16ea5f[_0xd24b('0x3c')]=qs[_0xd24b('0x3c')](_0x45c969[_0xd24b('0x35')][_0xd24b('0x3c')]);_0x16ea5f[_0xd24b('0x1e')]=qs[_0xd24b('0x1e')](_0x45c969[_0xd24b('0x35')][_0xd24b('0x1e')]);}_0x16ea5f[_0xd24b('0x3d')]=qs[_0xd24b('0x3e')](_0x45c969[_0xd24b('0x35')][_0xd24b('0x3e')]);_0x16ea5f[_0xd24b('0x3f')]=qs[_0xd24b('0x36')](_['pick'](_0x45c969[_0xd24b('0x35')],_0x55ef05[_0xd24b('0x36')]));_0x16ea5f[_0xd24b('0x3f')][_0xd24b('0xc4')]=_0x37a75c['id'];if(_0x45c969[_0xd24b('0x35')][_0xd24b('0x5d')]){_0x16ea5f['where']=_[_0xd24b('0x94')](_0x16ea5f[_0xd24b('0x3f')],{'$or':_[_0xd24b('0x53')](_0x16ea5f[_0xd24b('0x38')],function(_0x25c5e2){var _0x510d0e={};_0x510d0e[_0x25c5e2]={'$like':'%'+_0x45c969[_0xd24b('0x35')][_0xd24b('0x5d')]+'%'};return _0x510d0e;})});}_0x16ea5f=_[_0xd24b('0x94')]({},_0x16ea5f,_0x45c969[_0xd24b('0xbf')]);return db['CmHopperHistory'][_0xd24b('0x1d')]({'where':_0x16ea5f['where']})[_0xd24b('0x24')](function(_0x5af023){_0x15f644[_0xd24b('0x1d')]=_0x5af023;if(_0x45c969['query']['includeAll']){_0x16ea5f[_0xd24b('0xc6')]=[{'all':!![]}];}return db['CmHopperHistory'][_0xd24b('0x90')](_0x16ea5f);})[_0xd24b('0x24')](function(_0xfb265){_0x15f644[_0xd24b('0x8a')]=_0xfb265;return _0x15f644;});}})[_0xd24b('0x24')](respondWithFilteredResult(_0x64f761,_0x16ea5f))[_0xd24b('0x8b')](handleError(_0x64f761,null));};exports[_0xd24b('0xc9')]=function(_0x440f38,_0x303655,_0x238c28){var _0x4dce15={'raw':!![],'where':{}};var _0x17fc26={};var _0x250941={'count':0x0,'rows':[]};return db[_0xd24b('0x2a')][_0xd24b('0x31')]({'where':{'id':_0x440f38[_0xd24b('0x8c')]['id']}})[_0xd24b('0x24')](handleEntityNotFound(_0x303655,null))[_0xd24b('0x24')](function(_0x1f6f24){if(_0x1f6f24){_0x17fc26[_0xd24b('0x34')]=_[_0xd24b('0x2c')](db['CmHopperFinal'][_0xd24b('0xbe')]);_0x17fc26['query']=_[_0xd24b('0x2c')](_0x440f38['query']);_0x17fc26['filters']=_[_0xd24b('0x37')](_0x17fc26['model'],_0x17fc26['query']);_0x4dce15['attributes']=_[_0xd24b('0x37')](_0x17fc26['model'],qs[_0xd24b('0x39')](_0x440f38[_0xd24b('0x35')][_0xd24b('0x39')]));_0x4dce15[_0xd24b('0x38')]=_0x4dce15[_0xd24b('0x38')][_0xd24b('0x2d')]?_0x4dce15[_0xd24b('0x38')]:_0x17fc26['model'];if(!_0x440f38['query']['hasOwnProperty'](_0xd24b('0x3b'))){_0x4dce15[_0xd24b('0x3c')]=qs[_0xd24b('0x3c')](_0x440f38[_0xd24b('0x35')]['limit']);_0x4dce15[_0xd24b('0x1e')]=qs[_0xd24b('0x1e')](_0x440f38[_0xd24b('0x35')][_0xd24b('0x1e')]);}_0x4dce15[_0xd24b('0x3d')]=qs['sort'](_0x440f38[_0xd24b('0x35')]['sort']);_0x4dce15['where']=qs[_0xd24b('0x36')](_[_0xd24b('0x40')](_0x440f38[_0xd24b('0x35')],_0x17fc26[_0xd24b('0x36')]));_0x4dce15[_0xd24b('0x3f')][_0xd24b('0xc4')]=_0x1f6f24['id'];if(_0x440f38[_0xd24b('0x35')][_0xd24b('0x5d')]){_0x4dce15[_0xd24b('0x3f')]=_[_0xd24b('0x94')](_0x4dce15[_0xd24b('0x3f')],{'$or':_['map'](_0x4dce15['attributes'],function(_0xe3a6b5){var _0x127537={};_0x127537[_0xe3a6b5]={'$like':'%'+_0x440f38[_0xd24b('0x35')][_0xd24b('0x5d')]+'%'};return _0x127537;})});}_0x4dce15=_['merge']({},_0x4dce15,_0x440f38['options']);return db[_0xd24b('0xca')][_0xd24b('0x1d')]({'where':_0x4dce15[_0xd24b('0x3f')]})[_0xd24b('0x24')](function(_0x32e271){_0x250941['count']=_0x32e271;if(_0x440f38[_0xd24b('0x35')][_0xd24b('0xc5')]){_0x4dce15[_0xd24b('0xc6')]=[{'all':!![]}];}return db['CmHopperFinal']['findAll'](_0x4dce15);})[_0xd24b('0x24')](function(_0x217a19){_0x250941[_0xd24b('0x8a')]=_0x217a19;return _0x250941;});}})[_0xd24b('0x24')](respondWithFilteredResult(_0x303655,_0x4dce15))[_0xd24b('0x8b')](handleError(_0x303655,null));};exports['getJscriptySessions']=function(_0x4ac0ff,_0x55a632,_0x1b86b7){var _0x3b8218={'raw':!![],'where':{}};var _0x1ddc73={};var _0x1084d1={'count':0x0,'rows':[]};return db[_0xd24b('0x2a')][_0xd24b('0x31')]({'where':{'id':_0x4ac0ff[_0xd24b('0x8c')]['id']}})['then'](handleEntityNotFound(_0x55a632,null))['then'](function(_0x2903a8){if(_0x2903a8){_0x1ddc73[_0xd24b('0x34')]=_[_0xd24b('0x2c')](db[_0xd24b('0xab')][_0xd24b('0xbe')]);_0x1ddc73[_0xd24b('0x35')]=_[_0xd24b('0x2c')](_0x4ac0ff[_0xd24b('0x35')]);_0x1ddc73[_0xd24b('0x36')]=_['intersection'](_0x1ddc73['model'],_0x1ddc73[_0xd24b('0x35')]);_0x3b8218[_0xd24b('0x38')]=_[_0xd24b('0x37')](_0x1ddc73[_0xd24b('0x34')],qs[_0xd24b('0x39')](_0x4ac0ff[_0xd24b('0x35')][_0xd24b('0x39')]));_0x3b8218['attributes']=_0x3b8218[_0xd24b('0x38')][_0xd24b('0x2d')]?_0x3b8218[_0xd24b('0x38')]:_0x1ddc73[_0xd24b('0x34')];if(!_0x4ac0ff['query'][_0xd24b('0x3a')](_0xd24b('0x3b'))){_0x3b8218[_0xd24b('0x3c')]=qs[_0xd24b('0x3c')](_0x4ac0ff[_0xd24b('0x35')][_0xd24b('0x3c')]);_0x3b8218['offset']=qs[_0xd24b('0x1e')](_0x4ac0ff[_0xd24b('0x35')][_0xd24b('0x1e')]);}_0x3b8218['order']=qs[_0xd24b('0x3e')](_0x4ac0ff[_0xd24b('0x35')][_0xd24b('0x3e')]);_0x3b8218[_0xd24b('0x3f')]=qs[_0xd24b('0x36')](_[_0xd24b('0x40')](_0x4ac0ff['query'],_0x1ddc73[_0xd24b('0x36')]));_0x3b8218[_0xd24b('0x3f')][_0xd24b('0xc4')]=_0x2903a8['id'];if(_0x4ac0ff[_0xd24b('0x35')][_0xd24b('0x5d')]){_0x3b8218['where']=_[_0xd24b('0x94')](_0x3b8218[_0xd24b('0x3f')],{'$or':_[_0xd24b('0x53')](_0x3b8218[_0xd24b('0x38')],function(_0x5ea739){var _0x21a7f9={};_0x21a7f9[_0x5ea739]={'$like':'%'+_0x4ac0ff[_0xd24b('0x35')][_0xd24b('0x5d')]+'%'};return _0x21a7f9;})});}_0x3b8218=_[_0xd24b('0x94')]({},_0x3b8218,_0x4ac0ff[_0xd24b('0xbf')]);return db['JscriptySessionReport'][_0xd24b('0x1d')]({'where':_0x3b8218[_0xd24b('0x3f')]})[_0xd24b('0x24')](function(_0x4c5ed4){_0x1084d1['count']=_0x4c5ed4;if(_0x4ac0ff['query']['includeAll']){_0x3b8218[_0xd24b('0xc6')]=[{'all':!![]}];}return db[_0xd24b('0xab')][_0xd24b('0x90')](_0x3b8218);})[_0xd24b('0x24')](function(_0x4dbf50){_0x1084d1[_0xd24b('0x8a')]=_0x4dbf50;return _0x1084d1;});}})[_0xd24b('0x24')](respondWithFilteredResult(_0x55a632,_0x3b8218))['catch'](handleError(_0x55a632,null));};exports[_0xd24b('0xcb')]=function(_0x5af320,_0x422a99,_0x412689){try{if(!_0x5af320['body'][_0xd24b('0xb0')]){throw new Error(_0xd24b('0xcc'));}if(!_0x5af320['body'][_0xd24b('0xcd')]){throw new Error('No\x20association\x20keys\x20specified!');}if(!_0x5af320[_0xd24b('0x95')][_0xd24b('0xce')]){throw new Error(_0xd24b('0xcf'));}if(!_0x5af320[_0xd24b('0x95')][_0xd24b('0xd0')]){throw new Error(_0xd24b('0xd1'));}var _0x2c794f=_0x5af320['body'][_0xd24b('0xcd')][_0xd24b('0x52')](',');var _0x41e969=_0x5af320[_0xd24b('0x95')][_0xd24b('0xce')][_0xd24b('0x52')](',');if(!_0x2c794f['length']||!_0x41e969[_0xd24b('0x2d')]||_0x2c794f['length']!==_0x41e969[_0xd24b('0x2d')]){throw new Error(_0xd24b('0xd2'));}_0x5af320[_0xd24b('0x95')][_0xd24b('0x39')]=_['zipObject'](_0x2c794f,_0x41e969);if(!_0x5af320[_0xd24b('0x95')]['fields']['phone']){throw new Error(_0xd24b('0xd3'));}if(!_0x5af320['body'][_0xd24b('0x39')]['firstName']){throw new Error(_0xd24b('0xd4'));}var _0x478799=path[_0xd24b('0x98')](config['root'],_0xd24b('0xd5'),_0x5af320[_0xd24b('0xd6')][_0xd24b('0xd7')]);fs[_0xd24b('0xd8')](_0x478799,parseInt(_0xd24b('0xd9'),0x8));var _0x54d052=require(_0xd24b('0xda'))['fork'](path[_0xd24b('0x98')](__dirname,_0xd24b('0xdb')),[_0x478799,_0x5af320[_0xd24b('0x95')]['binding_keys'],_0x5af320[_0xd24b('0x95')][_0xd24b('0xce')],_0x5af320['body'][_0xd24b('0xb0')],_0x5af320['body'][_0xd24b('0xdc')],_0x5af320[_0xd24b('0x95')]['duplicates'],_0x5af320[_0xd24b('0x95')][_0xd24b('0xd0')]]);return _0x422a99[_0xd24b('0x1b')](0xc8)['json']({'message':'File\x20uploaded\x20correctly!','pid':_0x54d052['pid']});}catch(_0x2b4b2b){return _0x422a99[_0xd24b('0x1b')](0x1f4)[_0xd24b('0x28')](_0x2b4b2b);}};exports[_0xd24b('0xdd')]=function(_0x1c50f6,_0x247b5e,_0x4be549){var _0x50ed54=fs[_0xd24b('0xde')](_0x1c50f6['file'][_0xd24b('0xdf')]);Papa[_0xd24b('0xe0')](_0x50ed54,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x3a4f91){return _0x247b5e['status'](0xc8)[_0xd24b('0x1c')]({'file':_0x1c50f6[_0xd24b('0xd6')],'fields':_0x3a4f91[_0xd24b('0xe1')]['fields']});}});};exports[_0xd24b('0xe2')]=function(_0x38b18e,_0x45ba94,_0x16038d){return db['User'][_0xd24b('0x90')]({'raw':!![],'attributes':['id'],'where':{'role':_0xd24b('0xe3')}})[_0xd24b('0x24')](function(_0x15affd){var _0x102ece=![];if(!_0x38b18e['body']['ListId']){throw new Error(_0xd24b('0xcc'));}if(!_0x38b18e[_0xd24b('0x95')]['binding'][_0xd24b('0xbd')]){throw new Error(_0xd24b('0xd3'));}if(!_0x38b18e[_0xd24b('0x95')][_0xd24b('0xe4')]['firstName']){throw new Error(_0xd24b('0xd4'));}if(!_0x38b18e[_0xd24b('0x95')][_0xd24b('0xd0')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x31a202=require(_0xd24b('0xda'))[_0xd24b('0xe5')](path[_0xd24b('0x98')](__dirname,_0xd24b('0xe6')),[_0x38b18e[_0xd24b('0x8c')]['id'],JSON['stringify'](_0x38b18e[_0xd24b('0x95')]),JSON[_0xd24b('0xe7')](_0x15affd)]);_0x31a202['on'](_0xd24b('0xe8'),function(_0x28acc1){_0x102ece=!![];return _0x45ba94[_0xd24b('0x1b')](0xc8)[_0xd24b('0x1c')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x31a202[_0xd24b('0xe9')]});});_0x31a202['on'](_0xd24b('0xea'),function(_0x57fd54){if(_0x57fd54&&!_0x102ece){return _0x45ba94[_0xd24b('0x1b')](0x1f4)['json']({'message':_0xd24b('0xeb'),'pid':_0x31a202[_0xd24b('0xe9')]});}});})[_0xd24b('0x8b')](handleError(_0x45ba94,null));};
git://repos.xcallymotion.com / motion2.git / blob