Built motion from commit (unavailable).|2.3.1
[motion2.git] / server / api / cmContact / cmContact.controller.js
1 // *************************************************************************
2 // *                                                                       *
3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
5 // *                                                                       *
6 // *************************************************************************
7 // *                                                                       *
8 // * Email: info@xcally.com                                                *
9 // * Website: https://www.xcally.com                                       *
10 // *                                                                       *
11 // *************************************************************************
12 // *                                                                       *
13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
14 // * copyright treaties, as well as other intellectual property laws and   *
15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
16 // *                                                                       *
17 // *************************************************************************
18 var _0x8e3e=['child_process','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','error\x20child\x20process','pid','html-pdf','eml-format','rimraf','zip-dir','request-promise','bluebird','util','path','to-csv','ejs','lodash','squel','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../config/license/hardware','ioredis','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./cmContact.socket','register','sendStatus','status','end','json','offset','apply','reject','update','destroy','error','stack','name','send','index','then','model','keys','query','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','limit','order','sort','where','pick','filter','merge','map','tag','include','push','Tag','Tags','CmContact','count','color','ThroughTags','rows','catch','find','params','describe','startsWith','cf_','columnName','displayName','findAll','body','get','mergeWith','tags','join','info','from','CmHopper','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','ChatQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','isArray','bulkCreate','each','duplicates','$or','ListId','findOrCreate','spread','$and','CmCustomField','format','omit','pickBy','cf_%d','isEmpty','table','setFields','id\x20=\x20?','sequelize','text','values','phone','getTags','findOne','rawAttributes','setTags','ids','getHoppers','options','includeAll','getHopperHistories','ContactId','getHopperFinals','JscriptySessionReport','uploadCsv','No\x20ListId\x20specified','binding_values','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_keys','split','Incorrect\x20binding\x20parameters\x20passed!','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','file','chmodSync','0777','fork','CompanyId','File\x20uploaded\x20correctly!','upload','createReadStream','parse','meta','User','agent','binding'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0x8e3e,0x163));var _0xe8e3=function(_0x7aac81,_0x1dd377){_0x7aac81=_0x7aac81-0x0;var _0x144d35=_0x8e3e[_0x7aac81];return _0x144d35;};'use strict';var pdf=require(_0xe8e3('0x0'));var emlformat=require(_0xe8e3('0x1'));var rimraf=require(_0xe8e3('0x2'));var zipdir=require(_0xe8e3('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0xe8e3('0x4'));var moment=require('moment');var BPromise=require(_0xe8e3('0x5'));var Mustache=require('mustache');var util=require(_0xe8e3('0x6'));var path=require(_0xe8e3('0x7'));var sox=require('sox');var csv=require(_0xe8e3('0x8'));var ejs=require(_0xe8e3('0x9'));var fs=require('fs');var _=require(_0xe8e3('0xa'));var squel=require(_0xe8e3('0xb'));var crypto=require('crypto');var jsforce=require(_0xe8e3('0xc'));var deskjs=require(_0xe8e3('0xd'));var toCsv=require(_0xe8e3('0x8'));var querystring=require(_0xe8e3('0xe'));var Papa=require(_0xe8e3('0xf'));var authService=require(_0xe8e3('0x10'));var hardwareService=require(_0xe8e3('0x11'));var Redis=require(_0xe8e3('0x12'));var qs=require(_0xe8e3('0x13'));var logger=require(_0xe8e3('0x14'))(_0xe8e3('0x15'));var utils=require('../../config/utils');var config=require(_0xe8e3('0x16'));var db=require(_0xe8e3('0x17'))['db'];config[_0xe8e3('0x18')]=_[_0xe8e3('0x19')](config[_0xe8e3('0x18')],{'host':_0xe8e3('0x1a'),'port':0x18eb});var socket=require(_0xe8e3('0x1b'))(new Redis(config[_0xe8e3('0x18')]));require(_0xe8e3('0x1c'))[_0xe8e3('0x1d')](socket);function respondWithStatusCode(_0x518a71,_0x3161c3){_0x3161c3=_0x3161c3||0xcc;return function(_0x1bf6fa){if(_0x1bf6fa){return _0x518a71[_0xe8e3('0x1e')](_0x3161c3);}return _0x518a71[_0xe8e3('0x1f')](_0x3161c3)[_0xe8e3('0x20')]();};}function respondWithResult(_0x13f5b1,_0xc24cc4){_0xc24cc4=_0xc24cc4||0xc8;return function(_0x121f62){if(_0x121f62){return _0x13f5b1[_0xe8e3('0x1f')](_0xc24cc4)[_0xe8e3('0x21')](_0x121f62);}};}function respondWithFilteredResult(_0x1fa618,_0x4091ae){return function(_0x3c0c73){if(_0x3c0c73){var _0x2cc2b1=_0x3c0c73['count'],_0x575b92=_0x4091ae[_0xe8e3('0x22')],_0x422b39=_0x4091ae['offset']+_0x4091ae['limit'],_0x525602;if(_0x422b39>=_0x2cc2b1){_0x422b39=_0x2cc2b1;_0x525602=0xc8;}else{_0x525602=0xce;}_0x1fa618[_0xe8e3('0x1f')](_0x525602);return _0x1fa618['set']('Content-Range',_0x575b92+'-'+_0x422b39+'/'+_0x2cc2b1)[_0xe8e3('0x21')](_0x3c0c73);}return null;};}function patchUpdates(_0x4a9a97){return function(_0xf158ec){try{jsonpatch[_0xe8e3('0x23')](_0xf158ec,_0x4a9a97,!![]);}catch(_0x65744e){return BPromise[_0xe8e3('0x24')](_0x65744e);}return _0xf158ec['save']();};}function saveUpdates(_0xeee8de,_0x5982cf){return function(_0x24c4b7){if(_0x24c4b7){return _0x24c4b7[_0xe8e3('0x25')](_0xeee8de)['then'](function(_0x47bbb9){return _0x47bbb9;});}return null;};}function removeEntity(_0x452106,_0x1ddf35){return function(_0x58451f){if(_0x58451f){return _0x58451f[_0xe8e3('0x26')]()['then'](function(){_0x452106['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x1d199a,_0x8e207b){return function(_0xe3680f){if(!_0xe3680f){_0x1d199a['sendStatus'](0x194);}return _0xe3680f;};}function handleError(_0x2f1319,_0x370e53){_0x370e53=_0x370e53||0x1f4;return function(_0x31de59){logger[_0xe8e3('0x27')](_0x31de59[_0xe8e3('0x28')]);if(_0x31de59[_0xe8e3('0x29')]){delete _0x31de59[_0xe8e3('0x29')];}_0x2f1319[_0xe8e3('0x1f')](_0x370e53)[_0xe8e3('0x2a')](_0x31de59);};}exports[_0xe8e3('0x2b')]=function(_0x4e8d2a,_0x355f1b){var _0x56e355={},_0x37c6df={},_0x416dc6={'count':0x0,'rows':[]};return db['CmContact']['describe']()[_0xe8e3('0x2c')](function(_0x2f1744){_0x37c6df[_0xe8e3('0x2d')]=_[_0xe8e3('0x2e')](_0x2f1744);_0x37c6df[_0xe8e3('0x2f')]=_[_0xe8e3('0x2e')](_0x4e8d2a['query']);_0x37c6df[_0xe8e3('0x30')]=_[_0xe8e3('0x31')](_0x37c6df[_0xe8e3('0x2d')],_0x37c6df[_0xe8e3('0x2f')]);_0x56e355['attributes']=_['intersection'](_0x37c6df[_0xe8e3('0x2d')],qs['fields'](_0x4e8d2a[_0xe8e3('0x2f')][_0xe8e3('0x32')]));_0x56e355[_0xe8e3('0x33')]=_0x56e355[_0xe8e3('0x33')][_0xe8e3('0x34')]?_0x56e355[_0xe8e3('0x33')]:_0x37c6df['model'];if(!_0x4e8d2a[_0xe8e3('0x2f')][_0xe8e3('0x35')](_0xe8e3('0x36'))){_0x56e355['limit']=qs[_0xe8e3('0x37')](_0x4e8d2a['query'][_0xe8e3('0x37')]);_0x56e355['offset']=qs[_0xe8e3('0x22')](_0x4e8d2a[_0xe8e3('0x2f')][_0xe8e3('0x22')]);}_0x56e355[_0xe8e3('0x38')]=qs['sort'](_0x4e8d2a[_0xe8e3('0x2f')][_0xe8e3('0x39')]);_0x56e355[_0xe8e3('0x3a')]=qs['filters'](_[_0xe8e3('0x3b')](_0x4e8d2a['query'],_0x37c6df[_0xe8e3('0x30')]));if(_0x4e8d2a['query'][_0xe8e3('0x3c')]){_0x56e355[_0xe8e3('0x3a')]=_[_0xe8e3('0x3d')](_0x56e355[_0xe8e3('0x3a')],{'$or':_[_0xe8e3('0x3e')](_0x56e355[_0xe8e3('0x33')],function(_0x558307){var _0x2eeff6={};_0x2eeff6[_0x558307]={'$like':'%'+_0x4e8d2a[_0xe8e3('0x2f')][_0xe8e3('0x3c')]+'%'};return _0x2eeff6;})});}_0x56e355=_['merge']({},_0x56e355,_0x4e8d2a['options']);var _0x4b74d3={'where':_0x56e355['where']};_0x4b74d3['include']=[];if(_0x4e8d2a[_0xe8e3('0x2f')][_0xe8e3('0x3f')]){_0x4b74d3[_0xe8e3('0x40')][_0xe8e3('0x41')]({'model':db[_0xe8e3('0x42')],'as':_0xe8e3('0x43'),'attributes':['id'],'where':{'id':_0x4e8d2a[_0xe8e3('0x2f')]['tag']},'required':!![]});_0x4b74d3['distinct']=!![];}return db[_0xe8e3('0x44')][_0xe8e3('0x45')](_0x4b74d3)[_0xe8e3('0x2c')](function(_0x73cdaf){_0x416dc6[_0xe8e3('0x45')]=_0x73cdaf;if(_0x4e8d2a[_0xe8e3('0x2f')]['includeAll']){_0x56e355[_0xe8e3('0x40')]=[{'model':db[_0xe8e3('0x42')],'as':_0xe8e3('0x43'),'attributes':['id',_0xe8e3('0x29'),_0xe8e3('0x46')],'required':_0x4e8d2a[_0xe8e3('0x2f')][_0xe8e3('0x3f')]?!![]:![]},{'model':db[_0xe8e3('0x42')],'as':_0xe8e3('0x47'),'attributes':['id',_0xe8e3('0x29'),_0xe8e3('0x46')],'through':_0x4e8d2a[_0xe8e3('0x2f')][_0xe8e3('0x3f')]?{'attributes':[],'where':{'TagId':_0x4e8d2a['query'][_0xe8e3('0x3f')]||undefined}}:{},'required':_0x4e8d2a[_0xe8e3('0x2f')][_0xe8e3('0x3f')]?!![]:![]}];}return db[_0xe8e3('0x44')]['findAll'](_0x56e355);})[_0xe8e3('0x2c')](function(_0x18f5b1){_0x416dc6[_0xe8e3('0x48')]=_0x18f5b1;return _0x416dc6;})[_0xe8e3('0x2c')](respondWithFilteredResult(_0x355f1b,_0x56e355))[_0xe8e3('0x49')](handleError(_0x355f1b,null));});};exports[_0xe8e3('0x26')]=function(_0x107878,_0x4a55ea){return db[_0xe8e3('0x44')][_0xe8e3('0x4a')]({'where':{'id':_0x107878[_0xe8e3('0x4b')]['id']}})[_0xe8e3('0x2c')](handleEntityNotFound(_0x4a55ea,null))['then'](removeEntity(_0x4a55ea,null))[_0xe8e3('0x49')](handleError(_0x4a55ea,null));};exports[_0xe8e3('0x4c')]=function(_0x5c9770,_0x315160){return db[_0xe8e3('0x44')][_0xe8e3('0x4c')]()[_0xe8e3('0x2c')](function(_0x103964){for(var _0x3bd5f8=0x0;_0x3bd5f8<Object[_0xe8e3('0x2e')](_0x103964)['length'];_0x3bd5f8++){var _0x38d110=Object['keys'](_0x103964)[_0x3bd5f8];if(!_[_0xe8e3('0x4d')](_0x38d110,_0xe8e3('0x4e'))){_0x103964[_0x38d110][_0xe8e3('0x4f')]=_0x38d110;_0x103964[_0x38d110][_0xe8e3('0x50')]=_0x38d110;}}return _0x103964;})['then'](function(_0x2f8750){var _0x13e852={'where':{'$or':[{'ListId':_0x5c9770[_0xe8e3('0x2f')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0xe8e3('0x51')](_0x13e852)['then'](function(_0x19ba4b){for(var _0x29338c=0x0;_0x29338c<_0x19ba4b[_0xe8e3('0x34')];_0x29338c++){var _0x2e4352=_0xe8e3('0x4e')+_0x19ba4b[_0x29338c]['id'];_0x2f8750[_0x2e4352][_0xe8e3('0x4f')]=_0x2e4352;_0x2f8750[_0x2e4352][_0xe8e3('0x50')]=_0x19ba4b[_0x29338c]['alias'];}for(var _0x29338c=0x0;_0x29338c<Object[_0xe8e3('0x2e')](_0x2f8750)[_0xe8e3('0x34')];_0x29338c++){var _0x2e4352=Object[_0xe8e3('0x2e')](_0x2f8750)[_0x29338c];if(!_0x2f8750[_0x2e4352][_0xe8e3('0x35')]('columnName')){delete _0x2f8750[_0x2e4352];}}return _0x2f8750;});})['then'](respondWithResult(_0x315160,null))[_0xe8e3('0x49')](handleError(_0x315160,null));};exports[_0xe8e3('0x3d')]=function(_0x1f5e18,_0x227764){var _0x2a2e72;var _0x206792;var _0x309083;if(_0x1f5e18[_0xe8e3('0x52')]['id']){delete _0x1f5e18[_0xe8e3('0x52')]['id'];}return db[_0xe8e3('0x44')][_0xe8e3('0x51')]({'where':{'id':[_0x1f5e18[_0xe8e3('0x52')]['to'],_0x1f5e18['body']['from']]}})[_0xe8e3('0x2c')](function(_0x13c106){if(_0x13c106){if(_0x13c106['length']!==0x2){return null;}_0x13c106[0x0]=_0x13c106[0x0][_0xe8e3('0x53')]({'plain':!![]});_0x13c106[0x1]=_0x13c106[0x1][_0xe8e3('0x53')]({'plain':!![]});delete _0x13c106[0x0]['id'];delete _0x13c106[0x1]['id'];return _[_0xe8e3('0x54')](_0x13c106[0x0],_0x13c106[0x1],function(_0x14cd2a,_0x45bad7){if(Array['isArray'](_0x45bad7)&&!_0x45bad7['length']){return _0x14cd2a;}else if(!_0x45bad7){return _0x14cd2a;}});}})[_0xe8e3('0x2c')](handleEntityNotFound(_0x227764,null))[_0xe8e3('0x2c')](function(_0x2f9752){if(_0x2f9752){if(_0x2f9752[_0xe8e3('0x55')]&&_['isArray'](_0x2f9752[_0xe8e3('0x55')])){_0x2f9752[_0xe8e3('0x55')]=_0x2f9752[_0xe8e3('0x55')][_0xe8e3('0x56')]();}logger[_0xe8e3('0x57')]('[CmContact][merge]\x20to\x20%s\x20from\x20%s',_0x1f5e18[_0xe8e3('0x52')]['to'],_0x1f5e18[_0xe8e3('0x52')][_0xe8e3('0x58')]);return db[_0xe8e3('0x59')][_0xe8e3('0x26')]({'where':{'ContactId':[_0x1f5e18[_0xe8e3('0x52')]['to'],_0x1f5e18[_0xe8e3('0x52')][_0xe8e3('0x58')]]}})[_0xe8e3('0x2c')](function(_0x49e8b7){logger[_0xe8e3('0x57')]('[CmContact][merge][destroy][CmHopper],\x20%s',_0x49e8b7);return db['CmHopperBlack'][_0xe8e3('0x26')]({'where':{'ContactId':[_0x1f5e18[_0xe8e3('0x52')]['to'],_0x1f5e18[_0xe8e3('0x52')][_0xe8e3('0x58')]]}})[_0xe8e3('0x2c')](function(_0x350fbd){logger['info'](_0xe8e3('0x5a'),_0x350fbd);return db[_0xe8e3('0x44')][_0xe8e3('0x5b')](_0x2f9752);});});}})[_0xe8e3('0x2c')](function(_0x19ed89){if(_0x19ed89){_0x2a2e72=_0x19ed89;_0x206792={'ContactId':_0x2a2e72['id']};_0x309083={'where':{'ContactId':[_0x1f5e18[_0xe8e3('0x52')]['to'],_0x1f5e18[_0xe8e3('0x52')][_0xe8e3('0x58')]]}};return db['ChatInteraction'][_0xe8e3('0x25')](_0x206792,_0x309083);}})[_0xe8e3('0x2c')](function(){if(_0x2a2e72){return db[_0xe8e3('0x5c')][_0xe8e3('0x25')](_0x206792,_0x309083);}})[_0xe8e3('0x2c')](function(){if(_0x2a2e72){return db['ChatOfflineMessage']['update'](_0x206792,_0x309083);}})['then'](function(){if(_0x2a2e72){return db[_0xe8e3('0x5d')]['update'](_0x206792,_0x309083);}})['then'](function(){if(_0x2a2e72){return db['MailMessage']['update'](_0x206792,_0x309083);}})['then'](function(){if(_0x2a2e72){return db[_0xe8e3('0x5d')][_0xe8e3('0x25')](_0x206792,_0x309083);}})[_0xe8e3('0x2c')](function(){if(_0x2a2e72){return db[_0xe8e3('0x5e')][_0xe8e3('0x25')](_0x206792,_0x309083);}})[_0xe8e3('0x2c')](function(){if(_0x2a2e72){return db[_0xe8e3('0x5f')][_0xe8e3('0x25')](_0x206792,_0x309083);}})['then'](function(){if(_0x2a2e72){return db[_0xe8e3('0x60')][_0xe8e3('0x25')](_0x206792,_0x309083);}})[_0xe8e3('0x2c')](function(){if(_0x2a2e72){return db['FaxInteraction'][_0xe8e3('0x25')](_0x206792,_0x309083);}})[_0xe8e3('0x2c')](function(){if(_0x2a2e72){return db[_0xe8e3('0x61')]['update'](_0x206792,_0x309083);}})['then'](function(){if(_0x2a2e72){return db[_0xe8e3('0x62')][_0xe8e3('0x25')](_0x206792,_0x309083);}})['then'](function(){if(_0x2a2e72){return db[_0xe8e3('0x63')][_0xe8e3('0x25')](_0x206792,_0x309083);}})['then'](function(){if(_0x2a2e72){return db[_0xe8e3('0x64')][_0xe8e3('0x25')](_0x206792,_0x309083);}})[_0xe8e3('0x2c')](function(){if(_0x2a2e72){return db[_0xe8e3('0x65')][_0xe8e3('0x25')](_0x206792,_0x309083);}})[_0xe8e3('0x2c')](function(){if(_0x2a2e72){return db[_0xe8e3('0x66')][_0xe8e3('0x25')](_0x206792,_0x309083);}})['then'](function(){if(_0x2a2e72){return db[_0xe8e3('0x67')][_0xe8e3('0x25')](_0x206792,_0x309083);}})[_0xe8e3('0x2c')](function(){if(_0x2a2e72){return db[_0xe8e3('0x68')][_0xe8e3('0x25')](_0x206792,_0x309083);}})[_0xe8e3('0x2c')](function(){if(_0x2a2e72){return db['FaxQueueReport'][_0xe8e3('0x25')](_0x206792,_0x309083);}})[_0xe8e3('0x2c')](function(){if(_0x2a2e72){return db[_0xe8e3('0x69')][_0xe8e3('0x25')](_0x206792,_0x309083);}})[_0xe8e3('0x2c')](function(){if(_0x2a2e72){return db[_0xe8e3('0x6a')]['update'](_0x206792,_0x309083);}})[_0xe8e3('0x2c')](function(){if(_0x2a2e72){return db[_0xe8e3('0x6b')][_0xe8e3('0x25')](_0x206792,_0x309083);}})[_0xe8e3('0x2c')](function(){if(_0x2a2e72){return db['JscriptySessionReport'][_0xe8e3('0x25')](_0x206792,_0x309083);}})[_0xe8e3('0x2c')](function(){if(_0x2a2e72){return db[_0xe8e3('0x44')]['destroy']({'where':{'id':[_0x1f5e18[_0xe8e3('0x52')]['to'],_0x1f5e18[_0xe8e3('0x52')]['from']]}});}})[_0xe8e3('0x2c')](function(){if(_0x2a2e72){return _0x2a2e72;}})['then'](respondWithResult(_0x227764,null))['catch'](handleError(_0x227764,null));};exports[_0xe8e3('0x5b')]=function(_0x12cd3f,_0x38bb2b){return db[_0xe8e3('0x44')][_0xe8e3('0x4c')]()[_0xe8e3('0x2c')](function(_0x55e9c6){if(_0x12cd3f[_0xe8e3('0x52')][_0xe8e3('0x55')]&&_[_0xe8e3('0x6c')](_0x12cd3f['body'][_0xe8e3('0x55')])){if(_0x12cd3f['body'][_0xe8e3('0x55')][_0xe8e3('0x34')]){_0x12cd3f['body'][_0xe8e3('0x55')]=_0x12cd3f['body'][_0xe8e3('0x55')][_0xe8e3('0x56')](';')+';';}else{_0x12cd3f['body'][_0xe8e3('0x55')]=null;}}else{_0x12cd3f[_0xe8e3('0x52')]['tags']=null;}return db['CmContact']['create'](_0x12cd3f['body'],{'fields':_[_0xe8e3('0x2e')](_0x55e9c6),'raw':!![]});})[_0xe8e3('0x2c')](respondWithResult(_0x38bb2b,0xc9))[_0xe8e3('0x49')](handleError(_0x38bb2b,null));};exports[_0xe8e3('0x6d')]=function(_0x28991b,_0x26f720){var _0xc3a96f=[];var _0x397fcc=0x0;var _0x4e7cf5=0x0;var _0x5885fb=0x0;return db['CmContact'][_0xe8e3('0x4c')]()[_0xe8e3('0x2c')](function(_0x3647c4){return BPromise[_0xe8e3('0x6e')](_0x28991b[_0xe8e3('0x52')],function(_0x2193a5){var _0x19aa33={'where':{'$or':[]},'defaults':_0x2193a5,'fields':_['keys'](_0x3647c4),'raw':!![]};if(_0x2193a5[_0xe8e3('0x6f')]){for(var _0x5e6ac9=0x0;_0x5e6ac9<_0x2193a5['duplicates']['length'];_0x5e6ac9++){var _0x47722b={};_0x47722b[_0x2193a5[_0xe8e3('0x6f')][_0x5e6ac9]]=_0x2193a5[_0x2193a5[_0xe8e3('0x6f')][_0x5e6ac9]];_0x19aa33[_0xe8e3('0x3a')][_0xe8e3('0x70')]['push'](_0x47722b);}_0x19aa33[_0xe8e3('0x3a')][_0xe8e3('0x71')]=_0x2193a5[_0xe8e3('0x71')];}return db[_0xe8e3('0x44')][_0xe8e3('0x72')](_0x19aa33)[_0xe8e3('0x73')](function(_0x4c78c6,_0x431924){if(_0x431924){_0x397fcc++;}else{_0x5885fb++;}})[_0xe8e3('0x49')](function(_0x530a2f){console[_0xe8e3('0x27')](_0x530a2f);_0x4e7cf5++;});});})[_0xe8e3('0x2c')](function(_0x297528){if(_0x297528){return{'success':_0x397fcc,'failure':_0x4e7cf5,'duplicates':_0x5885fb};}})[_0xe8e3('0x2c')](respondWithResult(_0x26f720,0xc9))['catch'](handleError(_0x26f720,null));};exports['show']=function(_0x551e3a,_0x308211,_0x5c6a64){var _0x5e6778;return db[_0xe8e3('0x44')][_0xe8e3('0x4c')]()[_0xe8e3('0x2c')](function(_0x5ef8b3){return db['CmContact'][_0xe8e3('0x4a')]({'where':{'id':_0x551e3a[_0xe8e3('0x4b')]['id']},'include':[{'model':db[_0xe8e3('0x42')],'as':_0xe8e3('0x43'),'attributes':['id',_0xe8e3('0x29'),_0xe8e3('0x46')],'required':_0x551e3a[_0xe8e3('0x2f')][_0xe8e3('0x3f')]?!![]:![]}],'attributes':_[_0xe8e3('0x2e')](_0x5ef8b3)});})['then'](function(_0x7d0ac6){_0x5e6778=_0x7d0ac6[_0xe8e3('0x53')]({'plain':!![]});var _0x54cda9={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x7d0ac6&&_0x7d0ac6[_0xe8e3('0x71')]){if(_0x7d0ac6[_0xe8e3('0x71')]){_0x54cda9[_0xe8e3('0x3a')][_0xe8e3('0x74')]['push']({'ListId':{'$ne':_0x7d0ac6[_0xe8e3('0x71')]}});}}return db[_0xe8e3('0x75')][_0xe8e3('0x51')](_0x54cda9);})[_0xe8e3('0x2c')](function(_0xc97f05){return _['omit'](_0x5e6778,_[_0xe8e3('0x3e')](_0xc97f05,function(_0x34af00){return util[_0xe8e3('0x76')]('cf_%d',_0x34af00['id']);}));})[_0xe8e3('0x2c')](handleEntityNotFound(_0x308211,null))[_0xe8e3('0x2c')](respondWithResult(_0x308211,null))[_0xe8e3('0x49')](handleError(_0x308211,null));};exports[_0xe8e3('0x25')]=function(_0x3f94a0,_0x48c3fc){var _0x52f601;if(_0x3f94a0['body']['id']){delete _0x3f94a0[_0xe8e3('0x52')]['id'];}return db[_0xe8e3('0x44')][_0xe8e3('0x4a')]({'where':{'id':_0x3f94a0[_0xe8e3('0x4b')]['id']}})[_0xe8e3('0x2c')](handleEntityNotFound(_0x48c3fc,null))['then'](saveUpdates(_0x3f94a0[_0xe8e3('0x52')],null))[_0xe8e3('0x2c')](function(_0x4e00d8){_0x52f601=_0x4e00d8;var _0x56fd15={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x4e00d8&&_0x4e00d8[_0xe8e3('0x71')]){if(_0x4e00d8['ListId']){_0x56fd15['where']['$and']['push']({'ListId':{'$ne':_0x4e00d8[_0xe8e3('0x71')]}});}}return db[_0xe8e3('0x75')]['findAll'](_0x56fd15);})[_0xe8e3('0x2c')](function(_0x4dc00a){if(_0x4dc00a){return _[_0xe8e3('0x77')](_[_0xe8e3('0x78')](_0x3f94a0[_0xe8e3('0x52')],function(_0x555514,_0x38c97c){return _[_0xe8e3('0x4d')](_0x38c97c,_0xe8e3('0x4e'));}),_[_0xe8e3('0x3e')](_0x4dc00a,function(_0x3090be){return util[_0xe8e3('0x76')](_0xe8e3('0x79'),_0x3090be['id']);}));}})['then'](function(_0x1aa486){if(_0x1aa486&&!_[_0xe8e3('0x7a')](_0x1aa486)){var _0x2e8c39=squel[_0xe8e3('0x25')]()[_0xe8e3('0x7b')]('cm_contacts')[_0xe8e3('0x7c')](_0x1aa486)['where'](_0xe8e3('0x7d'),_0x3f94a0[_0xe8e3('0x4b')]['id'])['toParam']();return db[_0xe8e3('0x7e')][_0xe8e3('0x2f')](_0x2e8c39[_0xe8e3('0x7f')],{'replacements':_0x2e8c39[_0xe8e3('0x80')]});}})[_0xe8e3('0x2c')](function(){if(_0x3f94a0[_0xe8e3('0x52')][_0xe8e3('0x81')]&&_0x52f601){return db['CmHopper'][_0xe8e3('0x25')]({'phone':_0x3f94a0[_0xe8e3('0x52')]['phone']},{'where':{'ContactId':_0x52f601['id']}});}})['then'](function(){return _0x52f601;})['then'](respondWithResult(_0x48c3fc,null))['catch'](handleError(_0x48c3fc,null));};exports[_0xe8e3('0x82')]=function(_0x52a840,_0x2e197c,_0xf95b31){var _0x301d97={};var _0xfbde82={};var _0x84cc1c;var _0x5516f3;return db[_0xe8e3('0x44')][_0xe8e3('0x83')]({'where':{'id':_0x52a840[_0xe8e3('0x4b')]['id']}})[_0xe8e3('0x2c')](handleEntityNotFound(_0x2e197c,null))['then'](function(_0x5767be){if(_0x5767be){_0x84cc1c=_0x5767be;_0xfbde82[_0xe8e3('0x2d')]=_['keys'](db[_0xe8e3('0x42')][_0xe8e3('0x84')]);_0xfbde82[_0xe8e3('0x2f')]=_[_0xe8e3('0x2e')](_0x52a840[_0xe8e3('0x2f')]);_0xfbde82['filters']=_['intersection'](_0xfbde82[_0xe8e3('0x2d')],_0xfbde82[_0xe8e3('0x2f')]);_0x301d97[_0xe8e3('0x33')]=_[_0xe8e3('0x31')](_0xfbde82[_0xe8e3('0x2d')],qs['fields'](_0x52a840[_0xe8e3('0x2f')][_0xe8e3('0x32')]));_0x301d97[_0xe8e3('0x33')]=_0x301d97[_0xe8e3('0x33')][_0xe8e3('0x34')]?_0x301d97[_0xe8e3('0x33')]:_0xfbde82[_0xe8e3('0x2d')];_0x301d97[_0xe8e3('0x38')]=qs[_0xe8e3('0x39')](_0x52a840[_0xe8e3('0x2f')]['sort']);_0x301d97['where']=qs[_0xe8e3('0x30')](_[_0xe8e3('0x3b')](_0x52a840[_0xe8e3('0x2f')],_0xfbde82['filters']));if(_0x52a840[_0xe8e3('0x2f')]['filter']){_0x301d97[_0xe8e3('0x3a')]=_[_0xe8e3('0x3d')](_0x301d97[_0xe8e3('0x3a')],{'$or':_[_0xe8e3('0x3e')](_0x301d97[_0xe8e3('0x33')],function(_0x15b282){var _0x2cf3e6={};_0x2cf3e6[_0x15b282]={'$like':'%'+_0x52a840[_0xe8e3('0x2f')][_0xe8e3('0x3c')]+'%'};return _0x2cf3e6;})});}_0x301d97=_[_0xe8e3('0x3d')]({},_0x301d97,_0x52a840['options']);return _0x84cc1c[_0xe8e3('0x82')](_0x301d97);}})[_0xe8e3('0x2c')](function(_0x1e41ff){if(_0x1e41ff){_0x5516f3=_0x1e41ff['length'];if(!_0x52a840[_0xe8e3('0x2f')][_0xe8e3('0x35')](_0xe8e3('0x36'))){_0x301d97['limit']=qs[_0xe8e3('0x37')](_0x52a840['query'][_0xe8e3('0x37')]);_0x301d97['offset']=qs[_0xe8e3('0x22')](_0x52a840[_0xe8e3('0x2f')][_0xe8e3('0x22')]);}return _0x84cc1c['getTags'](_0x301d97);}})[_0xe8e3('0x2c')](function(_0x1a5f40){if(_0x1a5f40){return _0x1a5f40?{'count':_0x5516f3,'rows':_0x1a5f40}:null;}})[_0xe8e3('0x2c')](respondWithResult(_0x2e197c,null))[_0xe8e3('0x49')](handleError(_0x2e197c,null));};exports[_0xe8e3('0x85')]=function(_0x572ef5,_0x1b43a0,_0x147f47){if(_0x572ef5['body']['id']){delete _0x572ef5[_0xe8e3('0x52')]['id'];}return db['CmContact'][_0xe8e3('0x83')]({'where':{'id':_0x572ef5['params']['id']}})[_0xe8e3('0x2c')](handleEntityNotFound(_0x1b43a0,null))[_0xe8e3('0x2c')](function(_0x26a18d){if(_0x26a18d){return _0x26a18d[_0xe8e3('0x85')](_0x572ef5[_0xe8e3('0x52')][_0xe8e3('0x86')]||[]);}return null;})['then'](respondWithResult(_0x1b43a0,null))[_0xe8e3('0x49')](handleError(_0x1b43a0,null));};exports[_0xe8e3('0x87')]=function(_0x3266cc,_0x497c68,_0x50c4a3){var _0x425575={'raw':![],'where':{}};var _0x1bd5e5={};var _0x22d211={'count':0x0,'rows':[]};return db['CmContact'][_0xe8e3('0x83')]({'where':{'id':_0x3266cc[_0xe8e3('0x4b')]['id']}})['then'](handleEntityNotFound(_0x497c68,null))[_0xe8e3('0x2c')](function(_0x4007e9){if(_0x4007e9){_0x1bd5e5[_0xe8e3('0x2d')]=_[_0xe8e3('0x2e')](db['CmHopper'][_0xe8e3('0x84')]);_0x1bd5e5[_0xe8e3('0x2f')]=_[_0xe8e3('0x2e')](_0x3266cc[_0xe8e3('0x2f')]);_0x1bd5e5['filters']=_[_0xe8e3('0x31')](_0x1bd5e5['model'],_0x1bd5e5[_0xe8e3('0x2f')]);_0x425575['attributes']=_[_0xe8e3('0x31')](_0x1bd5e5[_0xe8e3('0x2d')],qs[_0xe8e3('0x32')](_0x3266cc[_0xe8e3('0x2f')][_0xe8e3('0x32')]));_0x425575[_0xe8e3('0x33')]=_0x425575[_0xe8e3('0x33')][_0xe8e3('0x34')]?_0x425575['attributes']:_0x1bd5e5[_0xe8e3('0x2d')];if(!_0x3266cc['query']['hasOwnProperty']('nolimit')){_0x425575['limit']=qs[_0xe8e3('0x37')](_0x3266cc[_0xe8e3('0x2f')][_0xe8e3('0x37')]);_0x425575[_0xe8e3('0x22')]=qs[_0xe8e3('0x22')](_0x3266cc[_0xe8e3('0x2f')][_0xe8e3('0x22')]);}_0x425575['order']=qs[_0xe8e3('0x39')](_0x3266cc['query'][_0xe8e3('0x39')]);_0x425575[_0xe8e3('0x3a')]=qs[_0xe8e3('0x30')](_[_0xe8e3('0x3b')](_0x3266cc[_0xe8e3('0x2f')],_0x1bd5e5[_0xe8e3('0x30')]));_0x425575['where']['ContactId']=_0x4007e9['id'];if(_0x3266cc['query'][_0xe8e3('0x3c')]){_0x425575['where']=_[_0xe8e3('0x3d')](_0x425575['where'],{'$or':_[_0xe8e3('0x3e')](_0x425575[_0xe8e3('0x33')],function(_0x3d017a){var _0x38a700={};_0x38a700[_0x3d017a]={'$like':'%'+_0x3266cc[_0xe8e3('0x2f')][_0xe8e3('0x3c')]+'%'};return _0x38a700;})});}_0x425575=_[_0xe8e3('0x3d')]({},_0x425575,_0x3266cc[_0xe8e3('0x88')]);return db[_0xe8e3('0x59')][_0xe8e3('0x45')]({'where':_0x425575[_0xe8e3('0x3a')]})[_0xe8e3('0x2c')](function(_0x7a107b){_0x22d211[_0xe8e3('0x45')]=_0x7a107b;if(_0x3266cc['query'][_0xe8e3('0x89')]){_0x425575[_0xe8e3('0x40')]=[{'all':!![]}];}return db[_0xe8e3('0x59')]['findAll'](_0x425575);})['then'](function(_0x4e9af6){_0x22d211[_0xe8e3('0x48')]=_0x4e9af6;return _0x22d211;});}})[_0xe8e3('0x2c')](respondWithFilteredResult(_0x497c68,_0x425575))[_0xe8e3('0x49')](handleError(_0x497c68,null));};exports[_0xe8e3('0x8a')]=function(_0x3fdd60,_0x2d978f,_0x3cab3f){var _0x3a0f9d={'raw':!![],'where':{}};var _0x593016={};var _0x5822e0={'count':0x0,'rows':[]};return db[_0xe8e3('0x44')][_0xe8e3('0x83')]({'where':{'id':_0x3fdd60[_0xe8e3('0x4b')]['id']}})[_0xe8e3('0x2c')](handleEntityNotFound(_0x2d978f,null))[_0xe8e3('0x2c')](function(_0x3b20db){if(_0x3b20db){_0x593016[_0xe8e3('0x2d')]=_[_0xe8e3('0x2e')](db[_0xe8e3('0x65')]['rawAttributes']);_0x593016[_0xe8e3('0x2f')]=_['keys'](_0x3fdd60[_0xe8e3('0x2f')]);_0x593016['filters']=_[_0xe8e3('0x31')](_0x593016[_0xe8e3('0x2d')],_0x593016[_0xe8e3('0x2f')]);_0x3a0f9d[_0xe8e3('0x33')]=_['intersection'](_0x593016[_0xe8e3('0x2d')],qs[_0xe8e3('0x32')](_0x3fdd60[_0xe8e3('0x2f')][_0xe8e3('0x32')]));_0x3a0f9d['attributes']=_0x3a0f9d[_0xe8e3('0x33')][_0xe8e3('0x34')]?_0x3a0f9d[_0xe8e3('0x33')]:_0x593016[_0xe8e3('0x2d')];if(!_0x3fdd60[_0xe8e3('0x2f')][_0xe8e3('0x35')](_0xe8e3('0x36'))){_0x3a0f9d[_0xe8e3('0x37')]=qs['limit'](_0x3fdd60[_0xe8e3('0x2f')]['limit']);_0x3a0f9d['offset']=qs['offset'](_0x3fdd60['query'][_0xe8e3('0x22')]);}_0x3a0f9d[_0xe8e3('0x38')]=qs['sort'](_0x3fdd60['query'][_0xe8e3('0x39')]);_0x3a0f9d[_0xe8e3('0x3a')]=qs[_0xe8e3('0x30')](_[_0xe8e3('0x3b')](_0x3fdd60['query'],_0x593016[_0xe8e3('0x30')]));_0x3a0f9d[_0xe8e3('0x3a')][_0xe8e3('0x8b')]=_0x3b20db['id'];if(_0x3fdd60[_0xe8e3('0x2f')][_0xe8e3('0x3c')]){_0x3a0f9d[_0xe8e3('0x3a')]=_[_0xe8e3('0x3d')](_0x3a0f9d[_0xe8e3('0x3a')],{'$or':_['map'](_0x3a0f9d[_0xe8e3('0x33')],function(_0x1afc99){var _0x439a63={};_0x439a63[_0x1afc99]={'$like':'%'+_0x3fdd60[_0xe8e3('0x2f')][_0xe8e3('0x3c')]+'%'};return _0x439a63;})});}_0x3a0f9d=_[_0xe8e3('0x3d')]({},_0x3a0f9d,_0x3fdd60[_0xe8e3('0x88')]);return db[_0xe8e3('0x65')]['count']({'where':_0x3a0f9d[_0xe8e3('0x3a')]})[_0xe8e3('0x2c')](function(_0x440d9a){_0x5822e0['count']=_0x440d9a;if(_0x3fdd60['query'][_0xe8e3('0x89')]){_0x3a0f9d['include']=[{'all':!![]}];}return db[_0xe8e3('0x65')]['findAll'](_0x3a0f9d);})[_0xe8e3('0x2c')](function(_0x4dae95){_0x5822e0[_0xe8e3('0x48')]=_0x4dae95;return _0x5822e0;});}})[_0xe8e3('0x2c')](respondWithFilteredResult(_0x2d978f,_0x3a0f9d))[_0xe8e3('0x49')](handleError(_0x2d978f,null));};exports[_0xe8e3('0x8c')]=function(_0x1b8213,_0x1f26e7,_0x12be1b){var _0x4316dd={'raw':!![],'where':{}};var _0x2dd9e1={};var _0xd40bca={'count':0x0,'rows':[]};return db[_0xe8e3('0x44')][_0xe8e3('0x83')]({'where':{'id':_0x1b8213[_0xe8e3('0x4b')]['id']}})[_0xe8e3('0x2c')](handleEntityNotFound(_0x1f26e7,null))['then'](function(_0x3b7019){if(_0x3b7019){_0x2dd9e1[_0xe8e3('0x2d')]=_['keys'](db[_0xe8e3('0x64')]['rawAttributes']);_0x2dd9e1['query']=_[_0xe8e3('0x2e')](_0x1b8213[_0xe8e3('0x2f')]);_0x2dd9e1['filters']=_[_0xe8e3('0x31')](_0x2dd9e1[_0xe8e3('0x2d')],_0x2dd9e1[_0xe8e3('0x2f')]);_0x4316dd[_0xe8e3('0x33')]=_['intersection'](_0x2dd9e1[_0xe8e3('0x2d')],qs['fields'](_0x1b8213[_0xe8e3('0x2f')][_0xe8e3('0x32')]));_0x4316dd[_0xe8e3('0x33')]=_0x4316dd[_0xe8e3('0x33')]['length']?_0x4316dd[_0xe8e3('0x33')]:_0x2dd9e1[_0xe8e3('0x2d')];if(!_0x1b8213[_0xe8e3('0x2f')][_0xe8e3('0x35')](_0xe8e3('0x36'))){_0x4316dd[_0xe8e3('0x37')]=qs[_0xe8e3('0x37')](_0x1b8213[_0xe8e3('0x2f')][_0xe8e3('0x37')]);_0x4316dd[_0xe8e3('0x22')]=qs[_0xe8e3('0x22')](_0x1b8213[_0xe8e3('0x2f')][_0xe8e3('0x22')]);}_0x4316dd[_0xe8e3('0x38')]=qs[_0xe8e3('0x39')](_0x1b8213['query'][_0xe8e3('0x39')]);_0x4316dd['where']=qs['filters'](_['pick'](_0x1b8213[_0xe8e3('0x2f')],_0x2dd9e1['filters']));_0x4316dd[_0xe8e3('0x3a')][_0xe8e3('0x8b')]=_0x3b7019['id'];if(_0x1b8213[_0xe8e3('0x2f')][_0xe8e3('0x3c')]){_0x4316dd[_0xe8e3('0x3a')]=_[_0xe8e3('0x3d')](_0x4316dd['where'],{'$or':_['map'](_0x4316dd[_0xe8e3('0x33')],function(_0xe01d7e){var _0x3be239={};_0x3be239[_0xe01d7e]={'$like':'%'+_0x1b8213[_0xe8e3('0x2f')][_0xe8e3('0x3c')]+'%'};return _0x3be239;})});}_0x4316dd=_[_0xe8e3('0x3d')]({},_0x4316dd,_0x1b8213[_0xe8e3('0x88')]);return db[_0xe8e3('0x64')]['count']({'where':_0x4316dd[_0xe8e3('0x3a')]})[_0xe8e3('0x2c')](function(_0x16670a){_0xd40bca['count']=_0x16670a;if(_0x1b8213['query'][_0xe8e3('0x89')]){_0x4316dd['include']=[{'all':!![]}];}return db[_0xe8e3('0x64')]['findAll'](_0x4316dd);})[_0xe8e3('0x2c')](function(_0x30a038){_0xd40bca[_0xe8e3('0x48')]=_0x30a038;return _0xd40bca;});}})[_0xe8e3('0x2c')](respondWithFilteredResult(_0x1f26e7,_0x4316dd))[_0xe8e3('0x49')](handleError(_0x1f26e7,null));};exports['getJscriptySessions']=function(_0x57cc91,_0x15f353,_0x225ee8){var _0x53b5b3={'raw':!![],'where':{}};var _0x4b38e3={};var _0x3b2af2={'count':0x0,'rows':[]};return db[_0xe8e3('0x44')][_0xe8e3('0x83')]({'where':{'id':_0x57cc91[_0xe8e3('0x4b')]['id']}})[_0xe8e3('0x2c')](handleEntityNotFound(_0x15f353,null))[_0xe8e3('0x2c')](function(_0x58459e){if(_0x58459e){_0x4b38e3[_0xe8e3('0x2d')]=_['keys'](db[_0xe8e3('0x8d')][_0xe8e3('0x84')]);_0x4b38e3[_0xe8e3('0x2f')]=_[_0xe8e3('0x2e')](_0x57cc91[_0xe8e3('0x2f')]);_0x4b38e3[_0xe8e3('0x30')]=_[_0xe8e3('0x31')](_0x4b38e3[_0xe8e3('0x2d')],_0x4b38e3[_0xe8e3('0x2f')]);_0x53b5b3[_0xe8e3('0x33')]=_[_0xe8e3('0x31')](_0x4b38e3[_0xe8e3('0x2d')],qs[_0xe8e3('0x32')](_0x57cc91[_0xe8e3('0x2f')][_0xe8e3('0x32')]));_0x53b5b3[_0xe8e3('0x33')]=_0x53b5b3['attributes'][_0xe8e3('0x34')]?_0x53b5b3['attributes']:_0x4b38e3[_0xe8e3('0x2d')];if(!_0x57cc91['query'][_0xe8e3('0x35')](_0xe8e3('0x36'))){_0x53b5b3[_0xe8e3('0x37')]=qs['limit'](_0x57cc91['query'][_0xe8e3('0x37')]);_0x53b5b3[_0xe8e3('0x22')]=qs[_0xe8e3('0x22')](_0x57cc91[_0xe8e3('0x2f')][_0xe8e3('0x22')]);}_0x53b5b3[_0xe8e3('0x38')]=qs['sort'](_0x57cc91[_0xe8e3('0x2f')][_0xe8e3('0x39')]);_0x53b5b3[_0xe8e3('0x3a')]=qs[_0xe8e3('0x30')](_[_0xe8e3('0x3b')](_0x57cc91['query'],_0x4b38e3[_0xe8e3('0x30')]));_0x53b5b3['where'][_0xe8e3('0x8b')]=_0x58459e['id'];if(_0x57cc91[_0xe8e3('0x2f')][_0xe8e3('0x3c')]){_0x53b5b3[_0xe8e3('0x3a')]=_[_0xe8e3('0x3d')](_0x53b5b3[_0xe8e3('0x3a')],{'$or':_[_0xe8e3('0x3e')](_0x53b5b3[_0xe8e3('0x33')],function(_0x2ed0db){var _0xd0db9f={};_0xd0db9f[_0x2ed0db]={'$like':'%'+_0x57cc91['query']['filter']+'%'};return _0xd0db9f;})});}_0x53b5b3=_[_0xe8e3('0x3d')]({},_0x53b5b3,_0x57cc91[_0xe8e3('0x88')]);return db[_0xe8e3('0x8d')][_0xe8e3('0x45')]({'where':_0x53b5b3['where']})[_0xe8e3('0x2c')](function(_0x2b3a2b){_0x3b2af2[_0xe8e3('0x45')]=_0x2b3a2b;if(_0x57cc91[_0xe8e3('0x2f')][_0xe8e3('0x89')]){_0x53b5b3[_0xe8e3('0x40')]=[{'all':!![]}];}return db[_0xe8e3('0x8d')][_0xe8e3('0x51')](_0x53b5b3);})[_0xe8e3('0x2c')](function(_0x405d80){_0x3b2af2[_0xe8e3('0x48')]=_0x405d80;return _0x3b2af2;});}})['then'](respondWithFilteredResult(_0x15f353,_0x53b5b3))[_0xe8e3('0x49')](handleError(_0x15f353,null));};exports[_0xe8e3('0x8e')]=function(_0x2deaa0,_0xee14d7,_0x177f7d){try{if(!_0x2deaa0[_0xe8e3('0x52')][_0xe8e3('0x71')]){throw new Error(_0xe8e3('0x8f'));}if(!_0x2deaa0['body']['binding_keys']){throw new Error('No\x20association\x20keys\x20specified!');}if(!_0x2deaa0[_0xe8e3('0x52')][_0xe8e3('0x90')]){throw new Error('No\x20association\x20values\x20specified!');}if(!_0x2deaa0['body'][_0xe8e3('0x91')]){throw new Error(_0xe8e3('0x92'));}var _0x32aebe=_0x2deaa0['body'][_0xe8e3('0x93')][_0xe8e3('0x94')](',');var _0x31c47b=_0x2deaa0[_0xe8e3('0x52')]['binding_values'][_0xe8e3('0x94')](',');if(!_0x32aebe[_0xe8e3('0x34')]||!_0x31c47b['length']||_0x32aebe['length']!==_0x31c47b[_0xe8e3('0x34')]){throw new Error(_0xe8e3('0x95'));}_0x2deaa0[_0xe8e3('0x52')][_0xe8e3('0x32')]=_[_0xe8e3('0x96')](_0x32aebe,_0x31c47b);if(!_0x2deaa0[_0xe8e3('0x52')]['fields']['phone']){throw new Error(_0xe8e3('0x97'));}if(!_0x2deaa0[_0xe8e3('0x52')]['fields'][_0xe8e3('0x98')]){throw new Error(_0xe8e3('0x99'));}var _0x1ac255=path['join'](config['root'],'server/files/tmp',_0x2deaa0[_0xe8e3('0x9a')]['filename']);fs[_0xe8e3('0x9b')](_0x1ac255,parseInt(_0xe8e3('0x9c'),0x8));var _0x1ff278=require('child_process')[_0xe8e3('0x9d')](path[_0xe8e3('0x56')](__dirname,'../../components/import/cm/csv'),[_0x1ac255,_0x2deaa0[_0xe8e3('0x52')]['binding_keys'],_0x2deaa0[_0xe8e3('0x52')][_0xe8e3('0x90')],_0x2deaa0[_0xe8e3('0x52')]['ListId'],_0x2deaa0['body'][_0xe8e3('0x9e')],_0x2deaa0[_0xe8e3('0x52')][_0xe8e3('0x6f')],_0x2deaa0['body'][_0xe8e3('0x91')]]);return _0xee14d7[_0xe8e3('0x1f')](0xc8)[_0xe8e3('0x21')]({'message':_0xe8e3('0x9f'),'pid':_0x1ff278['pid']});}catch(_0x35cc6d){return _0xee14d7[_0xe8e3('0x1f')](0x1f4)['send'](_0x35cc6d);}};exports[_0xe8e3('0xa0')]=function(_0x35328b,_0xa905e6,_0xfdc362){var _0x37d407=fs[_0xe8e3('0xa1')](_0x35328b[_0xe8e3('0x9a')][_0xe8e3('0x7')]);Papa[_0xe8e3('0xa2')](_0x37d407,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x38e28e){return _0xa905e6[_0xe8e3('0x1f')](0xc8)[_0xe8e3('0x21')]({'file':_0x35328b[_0xe8e3('0x9a')],'fields':_0x38e28e[_0xe8e3('0xa3')][_0xe8e3('0x32')]});}});};exports['import']=function(_0x4152ac,_0x1b4377,_0x3d384e){return db[_0xe8e3('0xa4')][_0xe8e3('0x51')]({'raw':!![],'attributes':['id'],'where':{'role':_0xe8e3('0xa5')}})[_0xe8e3('0x2c')](function(_0x4db55e){var _0x323fa7=![];if(!_0x4152ac['body'][_0xe8e3('0x71')]){throw new Error('No\x20ListId\x20specified');}if(!_0x4152ac[_0xe8e3('0x52')]['binding'][_0xe8e3('0x81')]){throw new Error(_0xe8e3('0x97'));}if(!_0x4152ac['body'][_0xe8e3('0xa6')][_0xe8e3('0x98')]){throw new Error(_0xe8e3('0x99'));}if(!_0x4152ac['body'][_0xe8e3('0x91')]){throw new Error('Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed');}var _0x85e707=require(_0xe8e3('0xa7'))[_0xe8e3('0x9d')](path['join'](__dirname,_0xe8e3('0xa8')),[_0x4152ac[_0xe8e3('0x4b')]['id'],JSON[_0xe8e3('0xa9')](_0x4152ac[_0xe8e3('0x52')]),JSON['stringify'](_0x4db55e)]);_0x85e707['on'](_0xe8e3('0xaa'),function(_0x28e1eb){_0x323fa7=!![];return _0x1b4377['status'](0xc8)['json']({'message':_0xe8e3('0xab'),'pid':_0x85e707['pid']});});_0x85e707['on']('exit',function(_0x185674){if(_0x185674&&!_0x323fa7){return _0x1b4377[_0xe8e3('0x1f')](0x1f4)[_0xe8e3('0x21')]({'message':_0xe8e3('0xac'),'pid':_0x85e707[_0xe8e3('0xad')]});}});})[_0xe8e3('0x49')](handleError(_0x1b4377,null));};