18 var _0x1740=['No\x20association\x20values\x20specified!','Incorrect\x20binding\x20parameters\x20passed!','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','file','filename','0777','child_process','fork','../../components/import/cm/csv','File\x20uploaded\x20correctly!','pid','send','upload','createReadStream','path','meta','import','agent','binding','socket_timestamp','stringify','start\x20child\x20process\x20correctly!','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','sox','to-csv','lodash','squel','jsforce','desk.js','querystring','ioredis','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','redis','defaults','localhost','./cmContact.socket','register','sendStatus','end','status','json','count','offset','limit','set','Content-Range','apply','reject','save','then','destroy','error','stack','name','CmContact','keys','query','intersection','model','attributes','fields','length','hasOwnProperty','order','sort','where','filters','pick','field','from','select','cm_contacts','c.deletedAt\x20IS\x20NULL','advancedFilter','parse','forEach','condition','isArray','value','and','tableAlias','\x20IN\x20?','\x20=\x20?','\x20LIKE\x20?','\x20>\x20?','\x20<\x20?','map','filter','isNil','isEmpty','ListId','c.ListId\x20IN\x20?','replace','\x27\x27\x27\x27','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','c.id','Sequelize','QueryTypes','SELECT','clone','COUNT(*)','tag','expr','CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','having','left_join','cm_contact_has_tags','ct.CmContactId\x20=\x20c.id','t.id\x20IN\x20?','toString','sequelize','merge','c.*','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','tools_tags','t.id\x20=\x20ct.TagId','split','Tags','push','rows','catch','find','params','describe','startsWith','columnName','displayName','findAll','cf_','alias','values','Error\x20customFields:\x20filed\x20%s\x20not\x20present\x20in\x20table\x20cm_contact','body','get','tags','join','info','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatMessage','update','ChatOfflineMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','VoiceCallReport','FaxQueueReport','MailQueueReport','SmsQueueReport','JscriptySessionReport','each','duplicates','spread','show','Tag','color','$and','format','cf_%d','CmCustomField','omit','pickBy','table','setFields','toParam','text','phone','findOne','getTags','nolimit','setTags','options','includeAll','include','getHopperHistories','CmHopperHistory','rawAttributes','ContactId','getJscriptySessions','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values'];(function(_0x57b54c,_0x54ce0d){var _0x59cc19=function(_0xa33bc6){while(--_0xa33bc6){_0x57b54c['push'](_0x57b54c['shift']());}};_0x59cc19(++_0x54ce0d);}(_0x1740,0x1c6));var _0x0174=function(_0x401134,_0x35d034){_0x401134=_0x401134-0x0;var _0x519255=_0x1740[_0x401134];return _0x519255;};'use strict';var pdf=require(_0x0174('0x0'));var emlformat=require(_0x0174('0x1'));var rimraf=require(_0x0174('0x2'));var zipdir=require(_0x0174('0x3'));var jsonpatch=require(_0x0174('0x4'));var rp=require(_0x0174('0x5'));var moment=require('moment');var BPromise=require(_0x0174('0x6'));var Mustache=require(_0x0174('0x7'));var util=require('util');var path=require('path');var sox=require(_0x0174('0x8'));var csv=require(_0x0174('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x0174('0xa'));var squel=require(_0x0174('0xb'));var crypto=require('crypto');var jsforce=require(_0x0174('0xc'));var deskjs=require(_0x0174('0xd'));var toCsv=require(_0x0174('0x9'));var querystring=require(_0x0174('0xe'));var Papa=require('papaparse');var Redis=require(_0x0174('0xf'));var authService=require('../../components/auth/service');var qs=require(_0x0174('0x10'));var hardwareService=require(_0x0174('0x11'));var logger=require(_0x0174('0x12'))(_0x0174('0x13'));var utils=require(_0x0174('0x14'));var config=require('../../config/environment');var db=require('../../mysqldb')['db'];config[_0x0174('0x15')]=_[_0x0174('0x16')](config[_0x0174('0x15')],{'host':_0x0174('0x17'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));require(_0x0174('0x18'))[_0x0174('0x19')](socket);function respondWithStatusCode(_0x179842,_0x10dcc8){_0x10dcc8=_0x10dcc8||0xcc;return function(_0x5951a7){if(_0x5951a7){return _0x179842[_0x0174('0x1a')](_0x10dcc8);}return _0x179842['status'](_0x10dcc8)[_0x0174('0x1b')]();};}function respondWithResult(_0x261b0e,_0xf08fce){_0xf08fce=_0xf08fce||0xc8;return function(_0x59f22a){if(_0x59f22a){return _0x261b0e[_0x0174('0x1c')](_0xf08fce)[_0x0174('0x1d')](_0x59f22a);}};}function respondWithFilteredResult(_0x2f1c34,_0x3618ba){return function(_0x8130e){if(_0x8130e){var _0x495cd3=_0x8130e[_0x0174('0x1e')],_0x12ef40=_0x3618ba[_0x0174('0x1f')],_0x34674d=_0x3618ba[_0x0174('0x1f')]+_0x3618ba[_0x0174('0x20')],_0x44927d;if(_0x34674d>=_0x495cd3){_0x34674d=_0x495cd3;_0x44927d=0xc8;}else{_0x44927d=0xce;}_0x2f1c34['status'](_0x44927d);return _0x2f1c34[_0x0174('0x21')](_0x0174('0x22'),_0x12ef40+'-'+_0x34674d+'/'+_0x495cd3)[_0x0174('0x1d')](_0x8130e);}return null;};}function patchUpdates(_0x39098b){return function(_0x183136){try{jsonpatch[_0x0174('0x23')](_0x183136,_0x39098b,!![]);}catch(_0x57d296){return BPromise[_0x0174('0x24')](_0x57d296);}return _0x183136[_0x0174('0x25')]();};}function saveUpdates(_0xe64fef,_0x36aec5){return function(_0xc5bab9){if(_0xc5bab9){return _0xc5bab9['update'](_0xe64fef)[_0x0174('0x26')](function(_0x563afe){return _0x563afe;});}return null;};}function removeEntity(_0x23022b,_0x33a187){return function(_0x207622){if(_0x207622){return _0x207622[_0x0174('0x27')]()[_0x0174('0x26')](function(){_0x23022b[_0x0174('0x1c')](0xcc)[_0x0174('0x1b')]();});}};}function handleEntityNotFound(_0x3866fd,_0x196c70){return function(_0x3282f4){if(!_0x3282f4){_0x3866fd[_0x0174('0x1a')](0x194);}return _0x3282f4;};}function handleError(_0x29ab29,_0x36c13c){_0x36c13c=_0x36c13c||0x1f4;return function(_0x4aa08e){logger[_0x0174('0x28')](_0x4aa08e[_0x0174('0x29')]);if(_0x4aa08e['name']){delete _0x4aa08e[_0x0174('0x2a')];}_0x29ab29[_0x0174('0x1c')](_0x36c13c)['send'](_0x4aa08e);};}exports['index']=function(_0x3f20b7,_0x10c22a){var _0x33675f={},_0x5094e7={},_0x56968e={'count':0x0,'rows':[]};return db[_0x0174('0x2b')]['describe']()[_0x0174('0x26')](function(_0x4a9501){_0x5094e7['model']=_[_0x0174('0x2c')](_0x4a9501);_0x5094e7['query']=_[_0x0174('0x2c')](_0x3f20b7[_0x0174('0x2d')]);_0x5094e7['filters']=_[_0x0174('0x2e')](_0x5094e7[_0x0174('0x2f')],_0x5094e7['query']);_0x33675f[_0x0174('0x30')]=_[_0x0174('0x2e')](_0x5094e7[_0x0174('0x2f')],qs['fields'](_0x3f20b7[_0x0174('0x2d')][_0x0174('0x31')]));_0x33675f[_0x0174('0x30')]=_0x33675f['attributes'][_0x0174('0x32')]?_0x33675f['attributes']:_0x5094e7[_0x0174('0x2f')];if(!_0x3f20b7[_0x0174('0x2d')][_0x0174('0x33')]('nolimit')){_0x33675f[_0x0174('0x20')]=qs[_0x0174('0x20')](_0x3f20b7['query'][_0x0174('0x20')]);_0x33675f[_0x0174('0x1f')]=qs[_0x0174('0x1f')](_0x3f20b7['query'][_0x0174('0x1f')]);}_0x33675f[_0x0174('0x34')]=qs[_0x0174('0x35')](_0x3f20b7[_0x0174('0x2d')][_0x0174('0x35')]);_0x33675f[_0x0174('0x36')]=qs[_0x0174('0x37')](_[_0x0174('0x38')](_0x3f20b7[_0x0174('0x2d')],_0x5094e7[_0x0174('0x37')]));var _0x299de0=[];var _0x18c4c9=squel['select']()[_0x0174('0x39')]('id')[_0x0174('0x39')](_0x0174('0x2a'))[_0x0174('0x39')]('color')[_0x0174('0x3a')]('tools_tags');var _0xc0fe04=squel[_0x0174('0x3b')]()[_0x0174('0x3a')](_0x0174('0x3c'),'c')[_0x0174('0x36')](_0x0174('0x3d'));var _0x2d7c58=squel['expr']();if(_0x3f20b7['query'][_0x0174('0x3e')]){var _0x576d19=JSON[_0x0174('0x3f')](_0x3f20b7[_0x0174('0x2d')][_0x0174('0x3e')]);_['keys'](_0x576d19)[_0x0174('0x40')](function(_0x533b66){var _0x1c246b=_0x576d19[_0x533b66];switch(_0x1c246b[_0x0174('0x41')]){case'IS':if(_[_0x0174('0x42')](_0x1c246b['value'])&&_0x1c246b[_0x0174('0x43')][_0x0174('0x32')]>0x1){_0x2d7c58[_0x0174('0x44')](_0x1c246b[_0x0174('0x45')]+'.'+_0x533b66+_0x0174('0x46'),_0x1c246b[_0x0174('0x43')]);}else{_0x2d7c58['and'](_0x1c246b[_0x0174('0x45')]+'.'+_0x533b66+'\x20=\x20?',_0x1c246b[_0x0174('0x43')][0x0]);}break;case'=':_0x2d7c58['and'](_0x1c246b['tableAlias']+'.'+_0x533b66+_0x0174('0x47'),_0x1c246b[_0x0174('0x43')]);break;case'LIKE':_0x2d7c58[_0x0174('0x44')](_0x1c246b[_0x0174('0x45')]+'.'+_0x533b66+_0x0174('0x48'),'%'+_0x1c246b[_0x0174('0x43')]+'%');break;case'>':_0x2d7c58[_0x0174('0x44')](_0x1c246b['tableAlias']+'.'+_0x533b66+_0x0174('0x49'),_0x1c246b[_0x0174('0x43')]);break;case'<':_0x2d7c58[_0x0174('0x44')](_0x1c246b[_0x0174('0x45')]+'.'+_0x533b66+_0x0174('0x4a'),_0x1c246b['value']);break;}});}else{var _0x25ef42=_(Object['keys'](_0x3f20b7[_0x0174('0x2d')]))[_0x0174('0x4b')](function(_0x4999ff){return _0x4a9501['hasOwnProperty'](_0x4999ff)?_0x4999ff:undefined;})[_0x0174('0x4c')](function(_0x11105f){return!_[_0x0174('0x4d')](_0x11105f);})[_0x0174('0x43')]();if(!_[_0x0174('0x4e')](_0x25ef42)){_0x25ef42[_0x0174('0x40')](function(_0x954cf4){if(_0x954cf4===_0x0174('0x4f')){_0xc0fe04[_0x0174('0x36')](_0x0174('0x50'),[]['concat'](_0x3f20b7[_0x0174('0x2d')][_0x954cf4]));}else{_0xc0fe04[_0x0174('0x36')]('c.'+_0x954cf4+_0x0174('0x47'),_0x3f20b7[_0x0174('0x2d')][_0x954cf4]);}});}if(_0x3f20b7[_0x0174('0x2d')]['filter']){var _0x3f64a4=_0x3f20b7[_0x0174('0x2d')]['filter'][_0x0174('0x51')]('\x5c','\x5c\x5c')[_0x0174('0x51')]('\x27\x27',_0x0174('0x52'));if(qs['isNumeric'](_0x3f64a4)){_0x2d7c58['or'](_0x0174('0x53'),_0x3f64a4+'%');_0x2d7c58['or'](_0x0174('0x54'),_0x3f64a4+'%');_0x2d7c58['or'](_0x0174('0x55'),_0x3f64a4+'%');_0x2d7c58['or']('c.fax\x20LIKE\x20?',_0x3f64a4+'%');}else if(qs[_0x0174('0x56')](_0x3f64a4)){_0x2d7c58['or'](_0x0174('0x57'),_0x3f64a4+'%');}else{_0x2d7c58['or']('c.email\x20LIKE\x20?',_0x3f64a4+'%');_0x2d7c58['or'](_0x0174('0x58'),_0x3f64a4+'%');_0x2d7c58['or'](_0x0174('0x59'),_0x3f64a4+'%');}}}_0xc0fe04[_0x0174('0x36')](_0x2d7c58);if(_0x33675f['order']){_0x33675f[_0x0174('0x34')][_0x0174('0x40')](function(_0x165e89){_0xc0fe04[_0x0174('0x34')]('c.'+_0x165e89[0x0],_0x165e89[0x1]==='DESC'?![]:!![]);});}_0xc0fe04['group'](_0x0174('0x5a'));var _0x36a189={'type':db[_0x0174('0x5b')][_0x0174('0x5c')][_0x0174('0x5d')],'raw':!![]};var _0x3e6249=_0xc0fe04[_0x0174('0x5e')]()[_0x0174('0x39')](_0x0174('0x5f'));if(!_0x3f20b7[_0x0174('0x2d')][_0x0174('0x3e')]){if(_0x3f20b7[_0x0174('0x2d')]['tag']){var _0x20aa70=_[_0x0174('0x42')](_0x3f20b7[_0x0174('0x2d')]['tag'])?_0x3f20b7['query'][_0x0174('0x60')]:new Array(_0x3f20b7[_0x0174('0x2d')]['tag']);var _0x3007ba=squel[_0x0174('0x61')]();_0x20aa70['forEach'](function(_0x1302e8){_0x3007ba['or'](_0x0174('0x62'),'%,'+_0x1302e8+',%');});_0xc0fe04[_0x0174('0x63')](_0x3007ba);_0x3e6249[_0x0174('0x64')](_0x0174('0x65'),'ct',_0x0174('0x66'));_0x3e6249[_0x0174('0x64')]('tools_tags','t','t.id\x20=\x20ct.TagId');_0x3e6249[_0x0174('0x36')](_0x0174('0x67'),_0x20aa70);}}db['sequelize'][_0x0174('0x2d')](_0x18c4c9[_0x0174('0x68')](),_0x36a189)['then'](function(_0xfe5e16){_0x299de0=_['keyBy'](_0xfe5e16,'id');return db[_0x0174('0x69')]['query'](_0x3e6249['toString'](),_0x36a189);})[_0x0174('0x26')](function(_0x35157d){_0x56968e[_0x0174('0x1e')]=_0x35157d[_0x0174('0x32')];_0x36a189=_[_0x0174('0x6a')](_0x36a189,{'model':db[_0x0174('0x2b')],'mapToModel':!![],'raw':!![],'nest':!![]});_0xc0fe04[_0x0174('0x39')](_0x0174('0x6b'));_0xc0fe04[_0x0174('0x39')](_0x0174('0x6c'),_0x0174('0x6d'));_0xc0fe04['left_join']('cm_contact_has_tags','ct',_0x0174('0x66'));_0xc0fe04[_0x0174('0x64')](_0x0174('0x6e'),'t',_0x0174('0x6f'));if(_0x33675f[_0x0174('0x20')]){_0xc0fe04[_0x0174('0x20')](_0x33675f[_0x0174('0x20')]);}if(_0x33675f[_0x0174('0x1f')]){_0xc0fe04[_0x0174('0x1f')](_0x33675f[_0x0174('0x1f')]);}db[_0x0174('0x69')][_0x0174('0x2d')](_0xc0fe04['toString'](),_0x36a189)[_0x0174('0x26')](function(_0x157eb1){_0x157eb1[_0x0174('0x40')](function(_0x380078){if(_0x380078['TagIds']){_0x380078['Tags']=[];_0x380078['TagIds'][_0x0174('0x70')](',')['forEach'](function(_0x2d1fab){_0x380078[_0x0174('0x71')][_0x0174('0x72')](_0x299de0[_0x2d1fab]);});}delete _0x380078['TagIds'];});_0x56968e[_0x0174('0x73')]=_0x157eb1;return _0x56968e;})[_0x0174('0x26')](respondWithFilteredResult(_0x10c22a,_0x33675f))[_0x0174('0x74')](handleError(_0x10c22a,null));});});};exports['destroy']=function(_0x148555,_0x44cbb0){return db[_0x0174('0x2b')][_0x0174('0x75')]({'where':{'id':_0x148555[_0x0174('0x76')]['id']}})[_0x0174('0x26')](handleEntityNotFound(_0x44cbb0,null))[_0x0174('0x26')](removeEntity(_0x44cbb0,null))[_0x0174('0x74')](handleError(_0x44cbb0,null));};exports[_0x0174('0x77')]=function(_0x524f7e,_0x3b4060){return db[_0x0174('0x2b')][_0x0174('0x77')]()[_0x0174('0x26')](function(_0x358b61){for(var _0x14df88=0x0;_0x14df88<Object['keys'](_0x358b61)[_0x0174('0x32')];_0x14df88++){var _0x2a09d7=Object[_0x0174('0x2c')](_0x358b61)[_0x14df88];if(!_[_0x0174('0x78')](_0x2a09d7,'cf_')){_0x358b61[_0x2a09d7][_0x0174('0x79')]=_0x2a09d7;_0x358b61[_0x2a09d7][_0x0174('0x7a')]=_0x2a09d7;}}return _0x358b61;})[_0x0174('0x26')](function(_0xf391e6){var _0x3f7d33={'where':{'$or':[{'ListId':_0x524f7e[_0x0174('0x2d')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0x0174('0x7b')](_0x3f7d33)[_0x0174('0x26')](function(_0x49cde3){for(var _0x304c04=0x0;_0x304c04<_0x49cde3[_0x0174('0x32')];_0x304c04++){var _0x380d69=_0x0174('0x7c')+_0x49cde3[_0x304c04]['id'];if(_0xf391e6[_0x380d69]){_0xf391e6[_0x380d69][_0x0174('0x79')]=_0x380d69;_0xf391e6[_0x380d69][_0x0174('0x7a')]=_0x49cde3[_0x304c04][_0x0174('0x7d')];_0xf391e6[_0x380d69]['custom']={'type':_0x49cde3[_0x304c04]['type'],'values':_0x49cde3[_0x304c04][_0x0174('0x7e')]};}else{logger[_0x0174('0x28')](_0x0174('0x7f'),_0x380d69);}}Object['keys'](_0xf391e6)[_0x0174('0x40')](function(_0x1c2c69){if(!_0xf391e6[_0x1c2c69][_0x0174('0x33')]('columnName')){delete _0xf391e6[_0x1c2c69];}});return _0xf391e6;});})['then'](respondWithResult(_0x3b4060,null))[_0x0174('0x74')](handleError(_0x3b4060,null));};exports[_0x0174('0x6a')]=function(_0x554b77,_0x5d8698){var _0x4366f3;var _0x3263a9;var _0x281f4f;if(_0x554b77[_0x0174('0x80')]['id']){delete _0x554b77[_0x0174('0x80')]['id'];}return db[_0x0174('0x2b')]['findAll']({'where':{'id':[_0x554b77[_0x0174('0x80')]['to'],_0x554b77['body'][_0x0174('0x3a')]]}})[_0x0174('0x26')](function(_0x24ab3b){if(_0x24ab3b){if(_0x24ab3b['length']!==0x2){return null;}_0x24ab3b[0x0]=_0x24ab3b[0x0][_0x0174('0x81')]({'plain':!![]});_0x24ab3b[0x1]=_0x24ab3b[0x1][_0x0174('0x81')]({'plain':!![]});delete _0x24ab3b[0x0]['id'];delete _0x24ab3b[0x1]['id'];return _['mergeWith'](_0x24ab3b[0x0],_0x24ab3b[0x1],function(_0x15990b,_0xf74f34){if(Array['isArray'](_0xf74f34)&&!_0xf74f34[_0x0174('0x32')]){return _0x15990b;}else if(!_0xf74f34){return _0x15990b;}});}})[_0x0174('0x26')](handleEntityNotFound(_0x5d8698,null))[_0x0174('0x26')](function(_0x1d7966){if(_0x1d7966){if(_0x1d7966[_0x0174('0x82')]&&_[_0x0174('0x42')](_0x1d7966[_0x0174('0x82')])){_0x1d7966[_0x0174('0x82')]=_0x1d7966[_0x0174('0x82')][_0x0174('0x83')]();}logger[_0x0174('0x84')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x554b77[_0x0174('0x80')]['to'],_0x554b77['body'][_0x0174('0x3a')]);return db[_0x0174('0x85')][_0x0174('0x27')]({'where':{'ContactId':[_0x554b77[_0x0174('0x80')]['to'],_0x554b77[_0x0174('0x80')][_0x0174('0x3a')]]}})[_0x0174('0x26')](function(_0x3a1450){logger['info'](_0x0174('0x86'),_0x3a1450);return db[_0x0174('0x87')][_0x0174('0x27')]({'where':{'ContactId':[_0x554b77[_0x0174('0x80')]['to'],_0x554b77['body'][_0x0174('0x3a')]]}})[_0x0174('0x26')](function(_0x7b9faf){logger[_0x0174('0x84')](_0x0174('0x88'),_0x7b9faf);return db[_0x0174('0x2b')][_0x0174('0x89')](_0x1d7966);});});}})[_0x0174('0x26')](function(_0x5bdb9b){if(_0x5bdb9b){_0x4366f3=_0x5bdb9b;_0x3263a9={'ContactId':_0x4366f3['id']};_0x281f4f={'where':{'ContactId':[_0x554b77[_0x0174('0x80')]['to'],_0x554b77[_0x0174('0x80')][_0x0174('0x3a')]]}};return db['ChatInteraction']['update'](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x8a')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x8c')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x8d')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x8e')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db['MailInteraction'][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x8e')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x8f')]['update'](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x90')]['update'](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x91')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x92')]['update'](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x93')]['update'](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x94')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x95')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})['then'](function(){if(_0x4366f3){return db['CmHopperHistory'][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db['ReportAgentPreview'][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x96')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db['ChatQueueReport'][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x97')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})['then'](function(){if(_0x4366f3){return db[_0x0174('0x98')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db['OpenchannelQueueReport'][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})['then'](function(){if(_0x4366f3){return db[_0x0174('0x99')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x9a')][_0x0174('0x8b')](_0x3263a9,_0x281f4f);}})[_0x0174('0x26')](function(){if(_0x4366f3){return db[_0x0174('0x2b')][_0x0174('0x27')]({'where':{'id':[_0x554b77['body']['to'],_0x554b77['body'][_0x0174('0x3a')]]}});}})[_0x0174('0x26')](function(){if(_0x4366f3){return _0x4366f3;}})[_0x0174('0x26')](respondWithResult(_0x5d8698,null))[_0x0174('0x74')](handleError(_0x5d8698,null));};exports['create']=function(_0x1c7f08,_0x362cf9){return db[_0x0174('0x2b')]['describe']()[_0x0174('0x26')](function(_0x5ee35b){if(_0x1c7f08[_0x0174('0x80')][_0x0174('0x82')]&&_[_0x0174('0x42')](_0x1c7f08[_0x0174('0x80')][_0x0174('0x82')])){if(_0x1c7f08[_0x0174('0x80')][_0x0174('0x82')][_0x0174('0x32')]){_0x1c7f08['body'][_0x0174('0x82')]=_0x1c7f08[_0x0174('0x80')][_0x0174('0x82')][_0x0174('0x83')](';')+';';}else{_0x1c7f08[_0x0174('0x80')]['tags']=null;}}else{_0x1c7f08['body'][_0x0174('0x82')]=null;}return db[_0x0174('0x2b')][_0x0174('0x89')](_0x1c7f08[_0x0174('0x80')],{'fields':_[_0x0174('0x2c')](_0x5ee35b),'raw':!![]});})['then'](respondWithResult(_0x362cf9,0xc9))['catch'](handleError(_0x362cf9,null));};exports['bulkCreate']=function(_0x4f60a3,_0x48533e){var _0x16a5c2=[];var _0x498bfa=0x0;var _0x3964c3=0x0;var _0x4094e0=0x0;return db[_0x0174('0x2b')][_0x0174('0x77')]()[_0x0174('0x26')](function(_0x18c683){return BPromise[_0x0174('0x9b')](_0x4f60a3['body'],function(_0x1b0b93){var _0x14f40c={'where':{'$or':[]},'defaults':_0x1b0b93,'fields':_[_0x0174('0x2c')](_0x18c683),'raw':!![]};if(_0x1b0b93['duplicates']){for(var _0x49227b=0x0;_0x49227b<_0x1b0b93[_0x0174('0x9c')]['length'];_0x49227b++){var _0x498ab7={};_0x498ab7[_0x1b0b93[_0x0174('0x9c')][_0x49227b]]=_0x1b0b93[_0x1b0b93[_0x0174('0x9c')][_0x49227b]];_0x14f40c[_0x0174('0x36')]['$or'][_0x0174('0x72')](_0x498ab7);}_0x14f40c[_0x0174('0x36')][_0x0174('0x4f')]=_0x1b0b93['ListId'];}return db[_0x0174('0x2b')]['findOrCreate'](_0x14f40c)[_0x0174('0x9d')](function(_0x88580f,_0x192aac){if(_0x192aac){_0x498bfa++;}else{_0x4094e0++;}})['catch'](function(_0x44a2f4){console['error'](_0x44a2f4);_0x3964c3++;});});})[_0x0174('0x26')](function(_0x245915){if(_0x245915){return{'success':_0x498bfa,'failure':_0x3964c3,'duplicates':_0x4094e0};}})[_0x0174('0x26')](respondWithResult(_0x48533e,0xc9))[_0x0174('0x74')](handleError(_0x48533e,null));};exports[_0x0174('0x9e')]=function(_0x2de536,_0xb58536,_0x25133f){var _0x3812cf;return db[_0x0174('0x2b')][_0x0174('0x77')]()[_0x0174('0x26')](function(_0x5d5a60){return db['CmContact'][_0x0174('0x75')]({'where':{'id':_0x2de536[_0x0174('0x76')]['id']},'include':[{'model':db[_0x0174('0x9f')],'as':_0x0174('0x71'),'attributes':['id',_0x0174('0x2a'),_0x0174('0xa0')],'required':_0x2de536['query']['tag']?!![]:![]}],'attributes':_[_0x0174('0x2c')](_0x5d5a60)});})['then'](function(_0x4f5706){_0x3812cf=_0x4f5706[_0x0174('0x81')]({'plain':!![]});var _0x300f0b={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x4f5706&&_0x4f5706[_0x0174('0x4f')]){if(_0x4f5706[_0x0174('0x4f')]){_0x300f0b[_0x0174('0x36')][_0x0174('0xa1')][_0x0174('0x72')]({'ListId':{'$ne':_0x4f5706[_0x0174('0x4f')]}});}}return db['CmCustomField'][_0x0174('0x7b')](_0x300f0b);})['then'](function(_0x5c8581){return _['omit'](_0x3812cf,_[_0x0174('0x4b')](_0x5c8581,function(_0x164ef4){return util[_0x0174('0xa2')](_0x0174('0xa3'),_0x164ef4['id']);}));})['then'](handleEntityNotFound(_0xb58536,null))['then'](respondWithResult(_0xb58536,null))[_0x0174('0x74')](handleError(_0xb58536,null));};exports[_0x0174('0x8b')]=function(_0x195883,_0x4fac9a){var _0x2d05da;if(_0x195883[_0x0174('0x80')]['id']){delete _0x195883['body']['id'];}return db[_0x0174('0x2b')]['find']({'where':{'id':_0x195883[_0x0174('0x76')]['id']}})['then'](handleEntityNotFound(_0x4fac9a,null))[_0x0174('0x26')](saveUpdates(_0x195883[_0x0174('0x80')],null))[_0x0174('0x26')](function(_0x31b6fe){_0x2d05da=_0x31b6fe;var _0xca4802={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x31b6fe&&_0x31b6fe[_0x0174('0x4f')]){if(_0x31b6fe[_0x0174('0x4f')]){_0xca4802[_0x0174('0x36')]['$and']['push']({'ListId':{'$ne':_0x31b6fe[_0x0174('0x4f')]}});}}return db[_0x0174('0xa4')][_0x0174('0x7b')](_0xca4802);})[_0x0174('0x26')](function(_0x20b5b0){if(_0x20b5b0){return _[_0x0174('0xa5')](_[_0x0174('0xa6')](_0x195883[_0x0174('0x80')],function(_0x2aee67,_0x40d3cd){return _['startsWith'](_0x40d3cd,_0x0174('0x7c'));}),_[_0x0174('0x4b')](_0x20b5b0,function(_0x586bf0){return util[_0x0174('0xa2')](_0x0174('0xa3'),_0x586bf0['id']);}));}})[_0x0174('0x26')](function(_0x59c9a6){if(_0x59c9a6&&!_[_0x0174('0x4e')](_0x59c9a6)){var _0x5e85ba=squel[_0x0174('0x8b')]()[_0x0174('0xa7')](_0x0174('0x3c'))[_0x0174('0xa8')](_0x59c9a6)[_0x0174('0x36')]('id\x20=\x20?',_0x195883[_0x0174('0x76')]['id'])[_0x0174('0xa9')]();return db['sequelize'][_0x0174('0x2d')](_0x5e85ba[_0x0174('0xaa')],{'replacements':_0x5e85ba[_0x0174('0x7e')]});}})[_0x0174('0x26')](function(){if(_0x195883['body'][_0x0174('0xab')]&&_0x2d05da){return db[_0x0174('0x85')][_0x0174('0x8b')]({'phone':_0x195883[_0x0174('0x80')]['phone']},{'where':{'ContactId':_0x2d05da['id']}});}})['then'](function(){return _0x2d05da;})[_0x0174('0x26')](respondWithResult(_0x4fac9a,null))['catch'](handleError(_0x4fac9a,null));};exports['getTags']=function(_0xe76a5a,_0xc472db,_0x435858){var _0x11ccbe={};var _0x41c433={};var _0x160653;var _0x3b98d7;return db[_0x0174('0x2b')][_0x0174('0xac')]({'where':{'id':_0xe76a5a['params']['id']}})[_0x0174('0x26')](handleEntityNotFound(_0xc472db,null))[_0x0174('0x26')](function(_0x21c9c2){if(_0x21c9c2){_0x160653=_0x21c9c2;_0x41c433['model']=_[_0x0174('0x2c')](db['Tag']['rawAttributes']);_0x41c433[_0x0174('0x2d')]=_[_0x0174('0x2c')](_0xe76a5a['query']);_0x41c433[_0x0174('0x37')]=_[_0x0174('0x2e')](_0x41c433[_0x0174('0x2f')],_0x41c433['query']);_0x11ccbe[_0x0174('0x30')]=_[_0x0174('0x2e')](_0x41c433[_0x0174('0x2f')],qs[_0x0174('0x31')](_0xe76a5a[_0x0174('0x2d')][_0x0174('0x31')]));_0x11ccbe['attributes']=_0x11ccbe[_0x0174('0x30')][_0x0174('0x32')]?_0x11ccbe[_0x0174('0x30')]:_0x41c433[_0x0174('0x2f')];_0x11ccbe[_0x0174('0x34')]=qs[_0x0174('0x35')](_0xe76a5a['query']['sort']);_0x11ccbe[_0x0174('0x36')]=qs[_0x0174('0x37')](_[_0x0174('0x38')](_0xe76a5a[_0x0174('0x2d')],_0x41c433['filters']));if(_0xe76a5a['query'][_0x0174('0x4c')]){_0x11ccbe[_0x0174('0x36')]=_[_0x0174('0x6a')](_0x11ccbe[_0x0174('0x36')],{'$or':_[_0x0174('0x4b')](_0x11ccbe[_0x0174('0x30')],function(_0x24ad56){var _0x220938={};_0x220938[_0x24ad56]={'$like':'%'+_0xe76a5a[_0x0174('0x2d')][_0x0174('0x4c')]+'%'};return _0x220938;})});}_0x11ccbe=_[_0x0174('0x6a')]({},_0x11ccbe,_0xe76a5a['options']);return _0x160653[_0x0174('0xad')](_0x11ccbe);}})[_0x0174('0x26')](function(_0x14f7c5){if(_0x14f7c5){_0x3b98d7=_0x14f7c5['length'];if(!_0xe76a5a['query']['hasOwnProperty'](_0x0174('0xae'))){_0x11ccbe[_0x0174('0x20')]=qs['limit'](_0xe76a5a['query'][_0x0174('0x20')]);_0x11ccbe[_0x0174('0x1f')]=qs[_0x0174('0x1f')](_0xe76a5a['query'][_0x0174('0x1f')]);}return _0x160653[_0x0174('0xad')](_0x11ccbe);}})[_0x0174('0x26')](function(_0x441207){if(_0x441207){return _0x441207?{'count':_0x3b98d7,'rows':_0x441207}:null;}})['then'](respondWithResult(_0xc472db,null))[_0x0174('0x74')](handleError(_0xc472db,null));};exports[_0x0174('0xaf')]=function(_0x5bac31,_0x20cf3a,_0x5d15b1){if(_0x5bac31[_0x0174('0x80')]['id']){delete _0x5bac31[_0x0174('0x80')]['id'];}return db['CmContact'][_0x0174('0xac')]({'where':{'id':_0x5bac31[_0x0174('0x76')]['id']}})['then'](handleEntityNotFound(_0x20cf3a,null))['then'](function(_0x2a3159){if(_0x2a3159){return _0x2a3159[_0x0174('0xaf')](_0x5bac31['body']['ids']||[]);}return null;})[_0x0174('0x26')](respondWithResult(_0x20cf3a,null))[_0x0174('0x74')](handleError(_0x20cf3a,null));};exports['getHoppers']=function(_0x4e3aa4,_0x3e40e8,_0x5dd2d7){var _0x48722f={'raw':![],'where':{}};var _0x18a419={};var _0x1bdc73={'count':0x0,'rows':[]};return db[_0x0174('0x2b')]['findOne']({'where':{'id':_0x4e3aa4[_0x0174('0x76')]['id']}})[_0x0174('0x26')](handleEntityNotFound(_0x3e40e8,null))[_0x0174('0x26')](function(_0x545e09){if(_0x545e09){_0x18a419['model']=_[_0x0174('0x2c')](db['CmHopper']['rawAttributes']);_0x18a419[_0x0174('0x2d')]=_[_0x0174('0x2c')](_0x4e3aa4['query']);_0x18a419[_0x0174('0x37')]=_['intersection'](_0x18a419[_0x0174('0x2f')],_0x18a419[_0x0174('0x2d')]);_0x48722f[_0x0174('0x30')]=_[_0x0174('0x2e')](_0x18a419[_0x0174('0x2f')],qs['fields'](_0x4e3aa4[_0x0174('0x2d')][_0x0174('0x31')]));_0x48722f[_0x0174('0x30')]=_0x48722f[_0x0174('0x30')][_0x0174('0x32')]?_0x48722f[_0x0174('0x30')]:_0x18a419[_0x0174('0x2f')];if(!_0x4e3aa4[_0x0174('0x2d')][_0x0174('0x33')]('nolimit')){_0x48722f[_0x0174('0x20')]=qs[_0x0174('0x20')](_0x4e3aa4[_0x0174('0x2d')][_0x0174('0x20')]);_0x48722f[_0x0174('0x1f')]=qs[_0x0174('0x1f')](_0x4e3aa4[_0x0174('0x2d')][_0x0174('0x1f')]);}_0x48722f[_0x0174('0x34')]=qs[_0x0174('0x35')](_0x4e3aa4[_0x0174('0x2d')][_0x0174('0x35')]);_0x48722f[_0x0174('0x36')]=qs[_0x0174('0x37')](_[_0x0174('0x38')](_0x4e3aa4[_0x0174('0x2d')],_0x18a419[_0x0174('0x37')]));_0x48722f[_0x0174('0x36')]['ContactId']=_0x545e09['id'];if(_0x4e3aa4[_0x0174('0x2d')][_0x0174('0x4c')]){_0x48722f[_0x0174('0x36')]=_[_0x0174('0x6a')](_0x48722f[_0x0174('0x36')],{'$or':_['map'](_0x48722f['attributes'],function(_0x206146){var _0x2850ec={};_0x2850ec[_0x206146]={'$like':'%'+_0x4e3aa4[_0x0174('0x2d')][_0x0174('0x4c')]+'%'};return _0x2850ec;})});}_0x48722f=_[_0x0174('0x6a')]({},_0x48722f,_0x4e3aa4[_0x0174('0xb0')]);return db['CmHopper'][_0x0174('0x1e')]({'where':_0x48722f[_0x0174('0x36')]})[_0x0174('0x26')](function(_0x1264f4){_0x1bdc73[_0x0174('0x1e')]=_0x1264f4;if(_0x4e3aa4[_0x0174('0x2d')][_0x0174('0xb1')]){_0x48722f[_0x0174('0xb2')]=[{'all':!![]}];}return db[_0x0174('0x85')]['findAll'](_0x48722f);})['then'](function(_0x254661){_0x1bdc73[_0x0174('0x73')]=_0x254661;return _0x1bdc73;});}})['then'](respondWithFilteredResult(_0x3e40e8,_0x48722f))[_0x0174('0x74')](handleError(_0x3e40e8,null));};exports[_0x0174('0xb3')]=function(_0x1a514d,_0x41ff3c,_0x407460){var _0x2e352e={'raw':!![],'where':{}};var _0x43f10c={};var _0x12002a={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x1a514d[_0x0174('0x76')]['id']}})[_0x0174('0x26')](handleEntityNotFound(_0x41ff3c,null))['then'](function(_0x20abf7){if(_0x20abf7){_0x43f10c[_0x0174('0x2f')]=_[_0x0174('0x2c')](db[_0x0174('0xb4')][_0x0174('0xb5')]);_0x43f10c[_0x0174('0x2d')]=_['keys'](_0x1a514d[_0x0174('0x2d')]);_0x43f10c[_0x0174('0x37')]=_[_0x0174('0x2e')](_0x43f10c[_0x0174('0x2f')],_0x43f10c[_0x0174('0x2d')]);_0x2e352e['attributes']=_[_0x0174('0x2e')](_0x43f10c[_0x0174('0x2f')],qs['fields'](_0x1a514d[_0x0174('0x2d')][_0x0174('0x31')]));_0x2e352e['attributes']=_0x2e352e['attributes'][_0x0174('0x32')]?_0x2e352e['attributes']:_0x43f10c['model'];if(!_0x1a514d[_0x0174('0x2d')][_0x0174('0x33')](_0x0174('0xae'))){_0x2e352e[_0x0174('0x20')]=qs[_0x0174('0x20')](_0x1a514d['query'][_0x0174('0x20')]);_0x2e352e[_0x0174('0x1f')]=qs[_0x0174('0x1f')](_0x1a514d[_0x0174('0x2d')][_0x0174('0x1f')]);}_0x2e352e[_0x0174('0x34')]=qs[_0x0174('0x35')](_0x1a514d[_0x0174('0x2d')]['sort']);_0x2e352e['where']=qs[_0x0174('0x37')](_[_0x0174('0x38')](_0x1a514d['query'],_0x43f10c[_0x0174('0x37')]));_0x2e352e[_0x0174('0x36')][_0x0174('0xb6')]=_0x20abf7['id'];if(_0x1a514d[_0x0174('0x2d')][_0x0174('0x4c')]){_0x2e352e['where']=_[_0x0174('0x6a')](_0x2e352e[_0x0174('0x36')],{'$or':_[_0x0174('0x4b')](_0x2e352e[_0x0174('0x30')],function(_0x4da667){var _0x2b5e2d={};_0x2b5e2d[_0x4da667]={'$like':'%'+_0x1a514d[_0x0174('0x2d')][_0x0174('0x4c')]+'%'};return _0x2b5e2d;})});}_0x2e352e=_['merge']({},_0x2e352e,_0x1a514d[_0x0174('0xb0')]);return db[_0x0174('0xb4')][_0x0174('0x1e')]({'where':_0x2e352e[_0x0174('0x36')]})[_0x0174('0x26')](function(_0x4a07d6){_0x12002a[_0x0174('0x1e')]=_0x4a07d6;if(_0x1a514d[_0x0174('0x2d')][_0x0174('0xb1')]){_0x2e352e[_0x0174('0xb2')]=[{'all':!![]}];}return db[_0x0174('0xb4')][_0x0174('0x7b')](_0x2e352e);})['then'](function(_0x25c0e8){_0x12002a[_0x0174('0x73')]=_0x25c0e8;return _0x12002a;});}})[_0x0174('0x26')](respondWithFilteredResult(_0x41ff3c,_0x2e352e))[_0x0174('0x74')](handleError(_0x41ff3c,null));};exports['getHopperFinals']=function(_0x16c3a7,_0xf58ea1,_0x1a5651){var _0x50865b={'raw':!![],'where':{}};var _0x34e433={};var _0xde945a={'count':0x0,'rows':[]};return db[_0x0174('0x2b')][_0x0174('0xac')]({'where':{'id':_0x16c3a7[_0x0174('0x76')]['id']}})['then'](handleEntityNotFound(_0xf58ea1,null))[_0x0174('0x26')](function(_0x5e4e40){if(_0x5e4e40){_0x34e433['model']=_[_0x0174('0x2c')](db['CmHopperFinal'][_0x0174('0xb5')]);_0x34e433['query']=_['keys'](_0x16c3a7[_0x0174('0x2d')]);_0x34e433[_0x0174('0x37')]=_['intersection'](_0x34e433[_0x0174('0x2f')],_0x34e433['query']);_0x50865b[_0x0174('0x30')]=_['intersection'](_0x34e433[_0x0174('0x2f')],qs['fields'](_0x16c3a7['query'][_0x0174('0x31')]));_0x50865b['attributes']=_0x50865b[_0x0174('0x30')][_0x0174('0x32')]?_0x50865b[_0x0174('0x30')]:_0x34e433['model'];if(!_0x16c3a7['query'][_0x0174('0x33')](_0x0174('0xae'))){_0x50865b['limit']=qs[_0x0174('0x20')](_0x16c3a7[_0x0174('0x2d')]['limit']);_0x50865b[_0x0174('0x1f')]=qs[_0x0174('0x1f')](_0x16c3a7[_0x0174('0x2d')][_0x0174('0x1f')]);}_0x50865b[_0x0174('0x34')]=qs[_0x0174('0x35')](_0x16c3a7[_0x0174('0x2d')][_0x0174('0x35')]);_0x50865b[_0x0174('0x36')]=qs[_0x0174('0x37')](_[_0x0174('0x38')](_0x16c3a7[_0x0174('0x2d')],_0x34e433[_0x0174('0x37')]));_0x50865b[_0x0174('0x36')][_0x0174('0xb6')]=_0x5e4e40['id'];if(_0x16c3a7[_0x0174('0x2d')][_0x0174('0x4c')]){_0x50865b[_0x0174('0x36')]=_['merge'](_0x50865b[_0x0174('0x36')],{'$or':_[_0x0174('0x4b')](_0x50865b[_0x0174('0x30')],function(_0x27eb1e){var _0x4d4751={};_0x4d4751[_0x27eb1e]={'$like':'%'+_0x16c3a7[_0x0174('0x2d')][_0x0174('0x4c')]+'%'};return _0x4d4751;})});}_0x50865b=_[_0x0174('0x6a')]({},_0x50865b,_0x16c3a7['options']);return db[_0x0174('0x95')][_0x0174('0x1e')]({'where':_0x50865b[_0x0174('0x36')]})[_0x0174('0x26')](function(_0x123239){_0xde945a['count']=_0x123239;if(_0x16c3a7[_0x0174('0x2d')][_0x0174('0xb1')]){_0x50865b[_0x0174('0xb2')]=[{'all':!![]}];}return db[_0x0174('0x95')][_0x0174('0x7b')](_0x50865b);})['then'](function(_0x56efb0){_0xde945a[_0x0174('0x73')]=_0x56efb0;return _0xde945a;});}})[_0x0174('0x26')](respondWithFilteredResult(_0xf58ea1,_0x50865b))['catch'](handleError(_0xf58ea1,null));};exports[_0x0174('0xb7')]=function(_0x577cdb,_0x4bdc6a,_0x3518fb){var _0xa7570c={'raw':!![],'where':{}};var _0x28575b={};var _0x176133={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x577cdb[_0x0174('0x76')]['id']}})[_0x0174('0x26')](handleEntityNotFound(_0x4bdc6a,null))[_0x0174('0x26')](function(_0x486d54){if(_0x486d54){_0x28575b['model']=_[_0x0174('0x2c')](db['JscriptySessionReport'][_0x0174('0xb5')]);_0x28575b[_0x0174('0x2d')]=_[_0x0174('0x2c')](_0x577cdb['query']);_0x28575b[_0x0174('0x37')]=_[_0x0174('0x2e')](_0x28575b[_0x0174('0x2f')],_0x28575b['query']);_0xa7570c[_0x0174('0x30')]=_['intersection'](_0x28575b[_0x0174('0x2f')],qs[_0x0174('0x31')](_0x577cdb[_0x0174('0x2d')]['fields']));_0xa7570c['attributes']=_0xa7570c[_0x0174('0x30')][_0x0174('0x32')]?_0xa7570c[_0x0174('0x30')]:_0x28575b[_0x0174('0x2f')];if(!_0x577cdb['query'][_0x0174('0x33')]('nolimit')){_0xa7570c['limit']=qs[_0x0174('0x20')](_0x577cdb[_0x0174('0x2d')][_0x0174('0x20')]);_0xa7570c[_0x0174('0x1f')]=qs['offset'](_0x577cdb[_0x0174('0x2d')][_0x0174('0x1f')]);}_0xa7570c[_0x0174('0x34')]=qs[_0x0174('0x35')](_0x577cdb['query'][_0x0174('0x35')]);_0xa7570c[_0x0174('0x36')]=qs[_0x0174('0x37')](_[_0x0174('0x38')](_0x577cdb['query'],_0x28575b[_0x0174('0x37')]));_0xa7570c['where']['ContactId']=_0x486d54['id'];if(_0x577cdb[_0x0174('0x2d')][_0x0174('0x4c')]){_0xa7570c[_0x0174('0x36')]=_[_0x0174('0x6a')](_0xa7570c[_0x0174('0x36')],{'$or':_[_0x0174('0x4b')](_0xa7570c[_0x0174('0x30')],function(_0x95f60a){var _0x214843={};_0x214843[_0x95f60a]={'$like':'%'+_0x577cdb[_0x0174('0x2d')][_0x0174('0x4c')]+'%'};return _0x214843;})});}_0xa7570c=_[_0x0174('0x6a')]({},_0xa7570c,_0x577cdb[_0x0174('0xb0')]);return db[_0x0174('0x9a')][_0x0174('0x1e')]({'where':_0xa7570c[_0x0174('0x36')]})[_0x0174('0x26')](function(_0x1b3593){_0x176133['count']=_0x1b3593;if(_0x577cdb[_0x0174('0x2d')][_0x0174('0xb1')]){_0xa7570c[_0x0174('0xb2')]=[{'all':!![]}];}return db['JscriptySessionReport']['findAll'](_0xa7570c);})[_0x0174('0x26')](function(_0x358367){_0x176133[_0x0174('0x73')]=_0x358367;return _0x176133;});}})[_0x0174('0x26')](respondWithFilteredResult(_0x4bdc6a,_0xa7570c))[_0x0174('0x74')](handleError(_0x4bdc6a,null));};exports['uploadCsv']=function(_0x18193b,_0x1d446a,_0x1e2e6e){try{if(!_0x18193b['body']['ListId']){throw new Error(_0x0174('0xb8'));}if(!_0x18193b[_0x0174('0x80')][_0x0174('0xb9')]){throw new Error(_0x0174('0xba'));}if(!_0x18193b[_0x0174('0x80')][_0x0174('0xbb')]){throw new Error(_0x0174('0xbc'));}if(!_0x18193b[_0x0174('0x80')]['socket_timestamp']){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x415efe=_0x18193b['body'][_0x0174('0xb9')][_0x0174('0x70')](',');var _0x3ed79c=_0x18193b[_0x0174('0x80')][_0x0174('0xbb')][_0x0174('0x70')](',');if(!_0x415efe['length']||!_0x3ed79c[_0x0174('0x32')]||_0x415efe[_0x0174('0x32')]!==_0x3ed79c[_0x0174('0x32')]){throw new Error(_0x0174('0xbd'));}_0x18193b[_0x0174('0x80')][_0x0174('0x31')]=_['zipObject'](_0x415efe,_0x3ed79c);if(!_0x18193b[_0x0174('0x80')][_0x0174('0x31')][_0x0174('0xab')]){throw new Error(_0x0174('0xbe'));}if(!_0x18193b[_0x0174('0x80')][_0x0174('0x31')][_0x0174('0xbf')]){throw new Error(_0x0174('0xc0'));}var _0x304a65=path[_0x0174('0x83')](config[_0x0174('0xc1')],_0x0174('0xc2'),_0x18193b[_0x0174('0xc3')][_0x0174('0xc4')]);fs['chmodSync'](_0x304a65,parseInt(_0x0174('0xc5'),0x8));var _0x2ef3c0=require(_0x0174('0xc6'))[_0x0174('0xc7')](path['join'](__dirname,_0x0174('0xc8')),[_0x304a65,_0x18193b[_0x0174('0x80')][_0x0174('0xb9')],_0x18193b['body'][_0x0174('0xbb')],_0x18193b['body'][_0x0174('0x4f')],_0x18193b[_0x0174('0x80')]['CompanyId'],_0x18193b[_0x0174('0x80')][_0x0174('0x9c')],_0x18193b['body']['socket_timestamp']]);return _0x1d446a[_0x0174('0x1c')](0xc8)[_0x0174('0x1d')]({'message':_0x0174('0xc9'),'pid':_0x2ef3c0[_0x0174('0xca')]});}catch(_0x4f2015){return _0x1d446a['status'](0x1f4)[_0x0174('0xcb')](_0x4f2015);}};exports[_0x0174('0xcc')]=function(_0x1edafe,_0x3f553c,_0x3b981a){var _0x5e2b96=fs[_0x0174('0xcd')](_0x1edafe['file'][_0x0174('0xce')]);Papa['parse'](_0x5e2b96,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x5359aa){return _0x3f553c[_0x0174('0x1c')](0xc8)[_0x0174('0x1d')]({'file':_0x1edafe[_0x0174('0xc3')],'fields':_0x5359aa[_0x0174('0xcf')][_0x0174('0x31')]});}});};exports[_0x0174('0xd0')]=function(_0x1c7de1,_0xe11d4b,_0x5a0375){return db['User']['findAll']({'raw':!![],'attributes':['id'],'where':{'role':_0x0174('0xd1')}})['then'](function(_0x3019e7){var _0x4f8733=![];if(!_0x1c7de1['body']['ListId']){throw new Error('No\x20ListId\x20specified');}if(!_0x1c7de1[_0x0174('0x80')][_0x0174('0xd2')][_0x0174('0xab')]){throw new Error(_0x0174('0xbe'));}if(!_0x1c7de1[_0x0174('0x80')][_0x0174('0xd2')][_0x0174('0xbf')]){throw new Error(_0x0174('0xc0'));}if(!_0x1c7de1[_0x0174('0x80')][_0x0174('0xd3')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x8fa868=require(_0x0174('0xc6'))['fork'](path[_0x0174('0x83')](__dirname,'../../components/import/cm/csv2'),[_0x1c7de1['params']['id'],JSON[_0x0174('0xd4')](_0x1c7de1[_0x0174('0x80')]),JSON['stringify'](_0x3019e7)]);_0x8fa868['on']('message',function(_0x16f551){_0x4f8733=!![];return _0xe11d4b[_0x0174('0x1c')](0xc8)[_0x0174('0x1d')]({'message':_0x0174('0xd5'),'pid':_0x8fa868['pid']});});_0x8fa868['on']('exit',function(_0x13062a){if(_0x13062a&&!_0x4f8733){return _0xe11d4b[_0x0174('0x1c')](0x1f4)['json']({'message':'error\x20child\x20process','pid':_0x8fa868[_0x0174('0xca')]});}});})[_0x0174('0x74')](handleError(_0xe11d4b,null));};
git://repos.xcallymotion.com / motion2.git / blob