Built motion from commit (unavailable).|2.3.4
[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 _0x9b3a=['isArray','tags','join','[CmContact][merge]\x20to\x20%s\x20from\x20%s','from','CmHopper','info','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','FaxMessage','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','VoiceCallReport','FaxQueueReport','OpenchannelQueueReport','SmsQueueReport','bulkCreate','each','duplicates','$or','ListId','findOrCreate','$and','CmCustomField','omit','format','cf_%d','isEmpty','table','cm_contacts','setFields','toParam','values','phone','getTags','rawAttributes','fields','sort','setTags','findOne','ids','getHoppers','ContactId','getHopperHistories','getHopperFinals','getJscriptySessions','JscriptySessionReport','uploadCsv','No\x20association\x20keys\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_keys','split','binding_values','zipObject','No\x20phone\x20column\x20specified','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','filename','chmodSync','0777','../../components/import/cm/csv','CompanyId','File\x20uploaded\x20correctly!','pid','upload','createReadStream','meta','import','User','No\x20ListId\x20specified','binding','child_process','../../components/import/cm/csv2','stringify','exit','error\x20child\x20process','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','util','path','sox','to-csv','ejs','jsforce','desk.js','papaparse','../../components/auth/service','ioredis','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','redis','defaults','localhost','./cmContact.socket','register','sendStatus','end','status','json','offset','set','reject','save','update','destroy','then','error','stack','name','send','index','CmContact','describe','keys','query','filters','model','attributes','intersection','length','nolimit','limit','order','pick','filter','where','merge','map','options','include','tag','push','distinct','count','includeAll','Tag','color','ThroughTags','findAll','rows','catch','find','params','startsWith','cf_','columnName','displayName','hasOwnProperty','body','get','mergeWith'];(function(_0x11ef05,_0x586f50){var _0x2fa5a5=function(_0x14d324){while(--_0x14d324){_0x11ef05['push'](_0x11ef05['shift']());}};_0x2fa5a5(++_0x586f50);}(_0x9b3a,0x1b7));var _0xa9b3=function(_0x283c8c,_0x213a62){_0x283c8c=_0x283c8c-0x0;var _0x91f202=_0x9b3a[_0x283c8c];return _0x91f202;};'use strict';var pdf=require(_0xa9b3('0x0'));var emlformat=require(_0xa9b3('0x1'));var rimraf=require(_0xa9b3('0x2'));var zipdir=require(_0xa9b3('0x3'));var jsonpatch=require(_0xa9b3('0x4'));var rp=require(_0xa9b3('0x5'));var moment=require('moment');var BPromise=require(_0xa9b3('0x6'));var Mustache=require('mustache');var util=require(_0xa9b3('0x7'));var path=require(_0xa9b3('0x8'));var sox=require(_0xa9b3('0x9'));var csv=require(_0xa9b3('0xa'));var ejs=require(_0xa9b3('0xb'));var fs=require('fs');var _=require('lodash');var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xa9b3('0xc'));var deskjs=require(_0xa9b3('0xd'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0xa9b3('0xe'));var authService=require(_0xa9b3('0xf'));var hardwareService=require('../../config/license/hardware');var Redis=require(_0xa9b3('0x10'));var qs=require(_0xa9b3('0x11'));var logger=require(_0xa9b3('0x12'))(_0xa9b3('0x13'));var utils=require(_0xa9b3('0x14'));var config=require(_0xa9b3('0x15'));var db=require('../../mysqldb')['db'];config[_0xa9b3('0x16')]=_[_0xa9b3('0x17')](config[_0xa9b3('0x16')],{'host':_0xa9b3('0x18'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0xa9b3('0x16')]));require(_0xa9b3('0x19'))[_0xa9b3('0x1a')](socket);function respondWithStatusCode(_0x3175be,_0x11a85d){_0x11a85d=_0x11a85d||0xcc;return function(_0xa2eb9d){if(_0xa2eb9d){return _0x3175be[_0xa9b3('0x1b')](_0x11a85d);}return _0x3175be['status'](_0x11a85d)[_0xa9b3('0x1c')]();};}function respondWithResult(_0x2f4ad7,_0x400484){_0x400484=_0x400484||0xc8;return function(_0xd3752a){if(_0xd3752a){return _0x2f4ad7[_0xa9b3('0x1d')](_0x400484)[_0xa9b3('0x1e')](_0xd3752a);}};}function respondWithFilteredResult(_0x22b233,_0xdd8c79){return function(_0x4dfec9){if(_0x4dfec9){var _0x308fc1=_0x4dfec9['count'],_0x5d84bb=_0xdd8c79[_0xa9b3('0x1f')],_0x377dc6=_0xdd8c79['offset']+_0xdd8c79['limit'],_0x2247a0;if(_0x377dc6>=_0x308fc1){_0x377dc6=_0x308fc1;_0x2247a0=0xc8;}else{_0x2247a0=0xce;}_0x22b233[_0xa9b3('0x1d')](_0x2247a0);return _0x22b233[_0xa9b3('0x20')]('Content-Range',_0x5d84bb+'-'+_0x377dc6+'/'+_0x308fc1)[_0xa9b3('0x1e')](_0x4dfec9);}return null;};}function patchUpdates(_0x40daf2){return function(_0x18883e){try{jsonpatch['apply'](_0x18883e,_0x40daf2,!![]);}catch(_0x484e85){return BPromise[_0xa9b3('0x21')](_0x484e85);}return _0x18883e[_0xa9b3('0x22')]();};}function saveUpdates(_0x15b3b5,_0x29f4a5){return function(_0x36ff76){if(_0x36ff76){return _0x36ff76[_0xa9b3('0x23')](_0x15b3b5)['then'](function(_0x594106){return _0x594106;});}return null;};}function removeEntity(_0x556585,_0x1d840e){return function(_0x2ed3eb){if(_0x2ed3eb){return _0x2ed3eb[_0xa9b3('0x24')]()[_0xa9b3('0x25')](function(){_0x556585[_0xa9b3('0x1d')](0xcc)[_0xa9b3('0x1c')]();});}};}function handleEntityNotFound(_0x239430,_0x2a9fe4){return function(_0x338160){if(!_0x338160){_0x239430[_0xa9b3('0x1b')](0x194);}return _0x338160;};}function handleError(_0x556e7a,_0x35db5d){_0x35db5d=_0x35db5d||0x1f4;return function(_0x5009e7){logger[_0xa9b3('0x26')](_0x5009e7[_0xa9b3('0x27')]);if(_0x5009e7[_0xa9b3('0x28')]){delete _0x5009e7['name'];}_0x556e7a[_0xa9b3('0x1d')](_0x35db5d)[_0xa9b3('0x29')](_0x5009e7);};}exports[_0xa9b3('0x2a')]=function(_0x21864f,_0x1c55ed){var _0x22e30d={},_0x415ffd={},_0x56f505={'count':0x0,'rows':[]};return db[_0xa9b3('0x2b')][_0xa9b3('0x2c')]()[_0xa9b3('0x25')](function(_0x37463e){_0x415ffd['model']=_[_0xa9b3('0x2d')](_0x37463e);_0x415ffd[_0xa9b3('0x2e')]=_[_0xa9b3('0x2d')](_0x21864f['query']);_0x415ffd[_0xa9b3('0x2f')]=_['intersection'](_0x415ffd[_0xa9b3('0x30')],_0x415ffd[_0xa9b3('0x2e')]);_0x22e30d[_0xa9b3('0x31')]=_[_0xa9b3('0x32')](_0x415ffd['model'],qs['fields'](_0x21864f['query']['fields']));_0x22e30d['attributes']=_0x22e30d[_0xa9b3('0x31')][_0xa9b3('0x33')]?_0x22e30d[_0xa9b3('0x31')]:_0x415ffd[_0xa9b3('0x30')];if(!_0x21864f[_0xa9b3('0x2e')]['hasOwnProperty'](_0xa9b3('0x34'))){_0x22e30d[_0xa9b3('0x35')]=qs[_0xa9b3('0x35')](_0x21864f['query'][_0xa9b3('0x35')]);_0x22e30d['offset']=qs[_0xa9b3('0x1f')](_0x21864f['query']['offset']);}_0x22e30d[_0xa9b3('0x36')]=qs['sort'](_0x21864f[_0xa9b3('0x2e')]['sort']);_0x22e30d['where']=qs[_0xa9b3('0x2f')](_[_0xa9b3('0x37')](_0x21864f[_0xa9b3('0x2e')],_0x415ffd[_0xa9b3('0x2f')]));if(_0x21864f[_0xa9b3('0x2e')][_0xa9b3('0x38')]){_0x22e30d[_0xa9b3('0x39')]=_[_0xa9b3('0x3a')](_0x22e30d[_0xa9b3('0x39')],{'$or':_[_0xa9b3('0x3b')](_0x22e30d['attributes'],function(_0x26e11e){var _0x22c609={};_0x22c609[_0x26e11e]={'$like':'%'+_0x21864f[_0xa9b3('0x2e')]['filter']+'%'};return _0x22c609;})});}_0x22e30d=_[_0xa9b3('0x3a')]({},_0x22e30d,_0x21864f[_0xa9b3('0x3c')]);var _0xb92eb1={'where':_0x22e30d['where']};_0xb92eb1[_0xa9b3('0x3d')]=[];if(_0x21864f[_0xa9b3('0x2e')][_0xa9b3('0x3e')]){_0xb92eb1[_0xa9b3('0x3d')][_0xa9b3('0x3f')]({'model':db['Tag'],'as':'Tags','attributes':['id'],'where':{'id':_0x21864f[_0xa9b3('0x2e')]['tag']},'required':!![]});_0xb92eb1[_0xa9b3('0x40')]=!![];}return db[_0xa9b3('0x2b')][_0xa9b3('0x41')](_0xb92eb1)[_0xa9b3('0x25')](function(_0x4f149c){_0x56f505[_0xa9b3('0x41')]=_0x4f149c;if(_0x21864f['query'][_0xa9b3('0x42')]){_0x22e30d[_0xa9b3('0x3d')]=[{'model':db[_0xa9b3('0x43')],'as':'Tags','attributes':['id',_0xa9b3('0x28'),_0xa9b3('0x44')],'required':_0x21864f['query'][_0xa9b3('0x3e')]?!![]:![]},{'model':db[_0xa9b3('0x43')],'as':_0xa9b3('0x45'),'attributes':['id',_0xa9b3('0x28'),_0xa9b3('0x44')],'through':_0x21864f[_0xa9b3('0x2e')][_0xa9b3('0x3e')]?{'attributes':[],'where':{'TagId':_0x21864f['query'][_0xa9b3('0x3e')]||undefined}}:{},'required':_0x21864f['query'][_0xa9b3('0x3e')]?!![]:![]}];}return db['CmContact'][_0xa9b3('0x46')](_0x22e30d);})[_0xa9b3('0x25')](function(_0x1f5372){_0x56f505[_0xa9b3('0x47')]=_0x1f5372;return _0x56f505;})[_0xa9b3('0x25')](respondWithFilteredResult(_0x1c55ed,_0x22e30d))[_0xa9b3('0x48')](handleError(_0x1c55ed,null));});};exports[_0xa9b3('0x24')]=function(_0x1d153a,_0x5e48be){return db['CmContact'][_0xa9b3('0x49')]({'where':{'id':_0x1d153a[_0xa9b3('0x4a')]['id']}})[_0xa9b3('0x25')](handleEntityNotFound(_0x5e48be,null))['then'](removeEntity(_0x5e48be,null))[_0xa9b3('0x48')](handleError(_0x5e48be,null));};exports[_0xa9b3('0x2c')]=function(_0x318b14,_0x564658){return db[_0xa9b3('0x2b')]['describe']()[_0xa9b3('0x25')](function(_0x48367c){for(var _0x16efb8=0x0;_0x16efb8<Object[_0xa9b3('0x2d')](_0x48367c)[_0xa9b3('0x33')];_0x16efb8++){var _0x420c50=Object[_0xa9b3('0x2d')](_0x48367c)[_0x16efb8];if(!_[_0xa9b3('0x4b')](_0x420c50,_0xa9b3('0x4c'))){_0x48367c[_0x420c50]['columnName']=_0x420c50;_0x48367c[_0x420c50]['displayName']=_0x420c50;}}return _0x48367c;})[_0xa9b3('0x25')](function(_0x693672){var _0x3efda0={'where':{'$or':[{'ListId':_0x318b14[_0xa9b3('0x2e')]['id']},{'ListId':null}]},'raw':!![]};return db['CmCustomField'][_0xa9b3('0x46')](_0x3efda0)[_0xa9b3('0x25')](function(_0x4dbcf2){for(var _0x149085=0x0;_0x149085<_0x4dbcf2[_0xa9b3('0x33')];_0x149085++){var _0x27b333=_0xa9b3('0x4c')+_0x4dbcf2[_0x149085]['id'];_0x693672[_0x27b333][_0xa9b3('0x4d')]=_0x27b333;_0x693672[_0x27b333][_0xa9b3('0x4e')]=_0x4dbcf2[_0x149085]['alias'];}for(var _0x149085=0x0;_0x149085<Object['keys'](_0x693672)[_0xa9b3('0x33')];_0x149085++){var _0x27b333=Object[_0xa9b3('0x2d')](_0x693672)[_0x149085];if(!_0x693672[_0x27b333][_0xa9b3('0x4f')](_0xa9b3('0x4d'))){delete _0x693672[_0x27b333];}}return _0x693672;});})['then'](respondWithResult(_0x564658,null))[_0xa9b3('0x48')](handleError(_0x564658,null));};exports['merge']=function(_0x3f37c4,_0x1c11b9){var _0x116084;var _0x401140;var _0x2b8031;if(_0x3f37c4[_0xa9b3('0x50')]['id']){delete _0x3f37c4[_0xa9b3('0x50')]['id'];}return db[_0xa9b3('0x2b')]['findAll']({'where':{'id':[_0x3f37c4[_0xa9b3('0x50')]['to'],_0x3f37c4[_0xa9b3('0x50')]['from']]}})[_0xa9b3('0x25')](function(_0x127129){if(_0x127129){if(_0x127129[_0xa9b3('0x33')]!==0x2){return null;}_0x127129[0x0]=_0x127129[0x0][_0xa9b3('0x51')]({'plain':!![]});_0x127129[0x1]=_0x127129[0x1][_0xa9b3('0x51')]({'plain':!![]});delete _0x127129[0x0]['id'];delete _0x127129[0x1]['id'];return _[_0xa9b3('0x52')](_0x127129[0x0],_0x127129[0x1],function(_0x5ab015,_0x709f29){if(Array[_0xa9b3('0x53')](_0x709f29)&&!_0x709f29[_0xa9b3('0x33')]){return _0x5ab015;}else if(!_0x709f29){return _0x5ab015;}});}})[_0xa9b3('0x25')](handleEntityNotFound(_0x1c11b9,null))['then'](function(_0x14ed35){if(_0x14ed35){if(_0x14ed35[_0xa9b3('0x54')]&&_[_0xa9b3('0x53')](_0x14ed35[_0xa9b3('0x54')])){_0x14ed35[_0xa9b3('0x54')]=_0x14ed35[_0xa9b3('0x54')][_0xa9b3('0x55')]();}logger['info'](_0xa9b3('0x56'),_0x3f37c4[_0xa9b3('0x50')]['to'],_0x3f37c4['body'][_0xa9b3('0x57')]);return db[_0xa9b3('0x58')]['destroy']({'where':{'ContactId':[_0x3f37c4[_0xa9b3('0x50')]['to'],_0x3f37c4['body'][_0xa9b3('0x57')]]}})[_0xa9b3('0x25')](function(_0x405ddc){logger[_0xa9b3('0x59')](_0xa9b3('0x5a'),_0x405ddc);return db[_0xa9b3('0x5b')]['destroy']({'where':{'ContactId':[_0x3f37c4[_0xa9b3('0x50')]['to'],_0x3f37c4[_0xa9b3('0x50')][_0xa9b3('0x57')]]}})[_0xa9b3('0x25')](function(_0x567158){logger[_0xa9b3('0x59')](_0xa9b3('0x5c'),_0x567158);return db[_0xa9b3('0x2b')][_0xa9b3('0x5d')](_0x14ed35);});});}})[_0xa9b3('0x25')](function(_0x418741){if(_0x418741){_0x116084=_0x418741;_0x401140={'ContactId':_0x116084['id']};_0x2b8031={'where':{'ContactId':[_0x3f37c4['body']['to'],_0x3f37c4['body'][_0xa9b3('0x57')]]}};return db[_0xa9b3('0x5e')]['update'](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x5f')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})['then'](function(){if(_0x116084){return db[_0xa9b3('0x60')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db['MailInteraction'][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x61')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db['MailInteraction'][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})['then'](function(){if(_0x116084){return db['MailMessage'][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})['then'](function(){if(_0x116084){return db[_0xa9b3('0x62')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x63')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x64')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x65')]['update'](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x66')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x67')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x68')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})['then'](function(){if(_0x116084){return db[_0xa9b3('0x69')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x6a')]['update'](_0x401140,_0x2b8031);}})['then'](function(){if(_0x116084){return db[_0xa9b3('0x6b')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db['ChatQueueReport'][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x6c')]['update'](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db['MailQueueReport'][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x6d')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x6e')][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db['JscriptySessionReport'][_0xa9b3('0x23')](_0x401140,_0x2b8031);}})[_0xa9b3('0x25')](function(){if(_0x116084){return db[_0xa9b3('0x2b')][_0xa9b3('0x24')]({'where':{'id':[_0x3f37c4[_0xa9b3('0x50')]['to'],_0x3f37c4[_0xa9b3('0x50')][_0xa9b3('0x57')]]}});}})['then'](function(){if(_0x116084){return _0x116084;}})[_0xa9b3('0x25')](respondWithResult(_0x1c11b9,null))['catch'](handleError(_0x1c11b9,null));};exports[_0xa9b3('0x5d')]=function(_0x2230e9,_0x45a76a){return db[_0xa9b3('0x2b')][_0xa9b3('0x2c')]()[_0xa9b3('0x25')](function(_0x3e24e5){if(_0x2230e9['body'][_0xa9b3('0x54')]&&_[_0xa9b3('0x53')](_0x2230e9[_0xa9b3('0x50')][_0xa9b3('0x54')])){if(_0x2230e9[_0xa9b3('0x50')][_0xa9b3('0x54')][_0xa9b3('0x33')]){_0x2230e9[_0xa9b3('0x50')]['tags']=_0x2230e9[_0xa9b3('0x50')][_0xa9b3('0x54')][_0xa9b3('0x55')](';')+';';}else{_0x2230e9[_0xa9b3('0x50')][_0xa9b3('0x54')]=null;}}else{_0x2230e9[_0xa9b3('0x50')]['tags']=null;}return db[_0xa9b3('0x2b')][_0xa9b3('0x5d')](_0x2230e9['body'],{'fields':_['keys'](_0x3e24e5),'raw':!![]});})['then'](respondWithResult(_0x45a76a,0xc9))[_0xa9b3('0x48')](handleError(_0x45a76a,null));};exports[_0xa9b3('0x6f')]=function(_0x336ef8,_0x13e35e){var _0x16cae7=[];var _0x5740be=0x0;var _0x156639=0x0;var _0xc3aaf9=0x0;return db[_0xa9b3('0x2b')]['describe']()['then'](function(_0x46ffcb){return BPromise[_0xa9b3('0x70')](_0x336ef8[_0xa9b3('0x50')],function(_0x4566ed){var _0x130cf6={'where':{'$or':[]},'defaults':_0x4566ed,'fields':_[_0xa9b3('0x2d')](_0x46ffcb),'raw':!![]};if(_0x4566ed[_0xa9b3('0x71')]){for(var _0x21e8d7=0x0;_0x21e8d7<_0x4566ed[_0xa9b3('0x71')][_0xa9b3('0x33')];_0x21e8d7++){var _0x25fb49={};_0x25fb49[_0x4566ed['duplicates'][_0x21e8d7]]=_0x4566ed[_0x4566ed['duplicates'][_0x21e8d7]];_0x130cf6[_0xa9b3('0x39')][_0xa9b3('0x72')][_0xa9b3('0x3f')](_0x25fb49);}_0x130cf6[_0xa9b3('0x39')][_0xa9b3('0x73')]=_0x4566ed[_0xa9b3('0x73')];}return db[_0xa9b3('0x2b')][_0xa9b3('0x74')](_0x130cf6)['spread'](function(_0x11a09d,_0x2ed341){if(_0x2ed341){_0x5740be++;}else{_0xc3aaf9++;}})[_0xa9b3('0x48')](function(_0x95e92e){console[_0xa9b3('0x26')](_0x95e92e);_0x156639++;});});})[_0xa9b3('0x25')](function(_0xa66624){if(_0xa66624){return{'success':_0x5740be,'failure':_0x156639,'duplicates':_0xc3aaf9};}})[_0xa9b3('0x25')](respondWithResult(_0x13e35e,0xc9))[_0xa9b3('0x48')](handleError(_0x13e35e,null));};exports['show']=function(_0xe1b740,_0x191192,_0x457b18){var _0x347590;return db[_0xa9b3('0x2b')][_0xa9b3('0x2c')]()['then'](function(_0x19e4d7){return db[_0xa9b3('0x2b')][_0xa9b3('0x49')]({'where':{'id':_0xe1b740['params']['id']},'include':[{'model':db[_0xa9b3('0x43')],'as':'Tags','attributes':['id',_0xa9b3('0x28'),'color'],'required':_0xe1b740['query']['tag']?!![]:![]}],'attributes':_[_0xa9b3('0x2d')](_0x19e4d7)});})[_0xa9b3('0x25')](function(_0x444a9a){_0x347590=_0x444a9a[_0xa9b3('0x51')]({'plain':!![]});var _0xc571a1={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x444a9a&&_0x444a9a[_0xa9b3('0x73')]){if(_0x444a9a['ListId']){_0xc571a1[_0xa9b3('0x39')][_0xa9b3('0x75')][_0xa9b3('0x3f')]({'ListId':{'$ne':_0x444a9a[_0xa9b3('0x73')]}});}}return db[_0xa9b3('0x76')][_0xa9b3('0x46')](_0xc571a1);})[_0xa9b3('0x25')](function(_0x498bb1){return _[_0xa9b3('0x77')](_0x347590,_[_0xa9b3('0x3b')](_0x498bb1,function(_0x314bb5){return util[_0xa9b3('0x78')](_0xa9b3('0x79'),_0x314bb5['id']);}));})[_0xa9b3('0x25')](handleEntityNotFound(_0x191192,null))[_0xa9b3('0x25')](respondWithResult(_0x191192,null))[_0xa9b3('0x48')](handleError(_0x191192,null));};exports[_0xa9b3('0x23')]=function(_0x576943,_0x1fbafe){var _0x3cdf43;if(_0x576943[_0xa9b3('0x50')]['id']){delete _0x576943['body']['id'];}return db[_0xa9b3('0x2b')][_0xa9b3('0x49')]({'where':{'id':_0x576943[_0xa9b3('0x4a')]['id']}})[_0xa9b3('0x25')](handleEntityNotFound(_0x1fbafe,null))[_0xa9b3('0x25')](saveUpdates(_0x576943['body'],null))[_0xa9b3('0x25')](function(_0x75ad90){_0x3cdf43=_0x75ad90;var _0x572cd3={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x75ad90&&_0x75ad90[_0xa9b3('0x73')]){if(_0x75ad90[_0xa9b3('0x73')]){_0x572cd3[_0xa9b3('0x39')][_0xa9b3('0x75')][_0xa9b3('0x3f')]({'ListId':{'$ne':_0x75ad90['ListId']}});}}return db['CmCustomField'][_0xa9b3('0x46')](_0x572cd3);})['then'](function(_0x376bae){if(_0x376bae){return _[_0xa9b3('0x77')](_['pickBy'](_0x576943['body'],function(_0x22968b,_0x2c1ab7){return _[_0xa9b3('0x4b')](_0x2c1ab7,_0xa9b3('0x4c'));}),_[_0xa9b3('0x3b')](_0x376bae,function(_0x337ce3){return util[_0xa9b3('0x78')](_0xa9b3('0x79'),_0x337ce3['id']);}));}})[_0xa9b3('0x25')](function(_0x25596c){if(_0x25596c&&!_[_0xa9b3('0x7a')](_0x25596c)){var _0x5a7f52=squel[_0xa9b3('0x23')]()[_0xa9b3('0x7b')](_0xa9b3('0x7c'))[_0xa9b3('0x7d')](_0x25596c)['where']('id\x20=\x20?',_0x576943[_0xa9b3('0x4a')]['id'])[_0xa9b3('0x7e')]();return db['sequelize'][_0xa9b3('0x2e')](_0x5a7f52['text'],{'replacements':_0x5a7f52[_0xa9b3('0x7f')]});}})['then'](function(){if(_0x576943[_0xa9b3('0x50')]['phone']&&_0x3cdf43){return db['CmHopper'][_0xa9b3('0x23')]({'phone':_0x576943[_0xa9b3('0x50')][_0xa9b3('0x80')]},{'where':{'ContactId':_0x3cdf43['id']}});}})[_0xa9b3('0x25')](function(){return _0x3cdf43;})[_0xa9b3('0x25')](respondWithResult(_0x1fbafe,null))[_0xa9b3('0x48')](handleError(_0x1fbafe,null));};exports[_0xa9b3('0x81')]=function(_0x5c5ea3,_0xbd10b5,_0x2d40bb){var _0x17cc33={};var _0x53e547={};var _0x5acd75;var _0x143d1b;return db[_0xa9b3('0x2b')]['findOne']({'where':{'id':_0x5c5ea3[_0xa9b3('0x4a')]['id']}})[_0xa9b3('0x25')](handleEntityNotFound(_0xbd10b5,null))[_0xa9b3('0x25')](function(_0x51d665){if(_0x51d665){_0x5acd75=_0x51d665;_0x53e547['model']=_['keys'](db[_0xa9b3('0x43')][_0xa9b3('0x82')]);_0x53e547[_0xa9b3('0x2e')]=_[_0xa9b3('0x2d')](_0x5c5ea3[_0xa9b3('0x2e')]);_0x53e547[_0xa9b3('0x2f')]=_['intersection'](_0x53e547['model'],_0x53e547[_0xa9b3('0x2e')]);_0x17cc33[_0xa9b3('0x31')]=_[_0xa9b3('0x32')](_0x53e547[_0xa9b3('0x30')],qs[_0xa9b3('0x83')](_0x5c5ea3[_0xa9b3('0x2e')][_0xa9b3('0x83')]));_0x17cc33[_0xa9b3('0x31')]=_0x17cc33['attributes'][_0xa9b3('0x33')]?_0x17cc33['attributes']:_0x53e547[_0xa9b3('0x30')];_0x17cc33[_0xa9b3('0x36')]=qs[_0xa9b3('0x84')](_0x5c5ea3[_0xa9b3('0x2e')][_0xa9b3('0x84')]);_0x17cc33[_0xa9b3('0x39')]=qs['filters'](_[_0xa9b3('0x37')](_0x5c5ea3[_0xa9b3('0x2e')],_0x53e547['filters']));if(_0x5c5ea3['query']['filter']){_0x17cc33[_0xa9b3('0x39')]=_[_0xa9b3('0x3a')](_0x17cc33['where'],{'$or':_[_0xa9b3('0x3b')](_0x17cc33[_0xa9b3('0x31')],function(_0x3b3d01){var _0x55f386={};_0x55f386[_0x3b3d01]={'$like':'%'+_0x5c5ea3['query'][_0xa9b3('0x38')]+'%'};return _0x55f386;})});}_0x17cc33=_['merge']({},_0x17cc33,_0x5c5ea3[_0xa9b3('0x3c')]);return _0x5acd75['getTags'](_0x17cc33);}})[_0xa9b3('0x25')](function(_0x59eedb){if(_0x59eedb){_0x143d1b=_0x59eedb[_0xa9b3('0x33')];if(!_0x5c5ea3[_0xa9b3('0x2e')][_0xa9b3('0x4f')](_0xa9b3('0x34'))){_0x17cc33[_0xa9b3('0x35')]=qs['limit'](_0x5c5ea3['query'][_0xa9b3('0x35')]);_0x17cc33[_0xa9b3('0x1f')]=qs[_0xa9b3('0x1f')](_0x5c5ea3['query'][_0xa9b3('0x1f')]);}return _0x5acd75[_0xa9b3('0x81')](_0x17cc33);}})[_0xa9b3('0x25')](function(_0x21580b){if(_0x21580b){return _0x21580b?{'count':_0x143d1b,'rows':_0x21580b}:null;}})[_0xa9b3('0x25')](respondWithResult(_0xbd10b5,null))[_0xa9b3('0x48')](handleError(_0xbd10b5,null));};exports[_0xa9b3('0x85')]=function(_0x11de18,_0x5d6d75,_0x16a9c9){if(_0x11de18['body']['id']){delete _0x11de18[_0xa9b3('0x50')]['id'];}return db[_0xa9b3('0x2b')][_0xa9b3('0x86')]({'where':{'id':_0x11de18[_0xa9b3('0x4a')]['id']}})['then'](handleEntityNotFound(_0x5d6d75,null))['then'](function(_0x4816d6){if(_0x4816d6){return _0x4816d6[_0xa9b3('0x85')](_0x11de18[_0xa9b3('0x50')][_0xa9b3('0x87')]||[]);}return null;})[_0xa9b3('0x25')](respondWithResult(_0x5d6d75,null))[_0xa9b3('0x48')](handleError(_0x5d6d75,null));};exports[_0xa9b3('0x88')]=function(_0xb507,_0xcce6f,_0x47d9a8){var _0xa6b81d={'raw':![],'where':{}};var _0x5e0e9a={};var _0x5ce31d={'count':0x0,'rows':[]};return db[_0xa9b3('0x2b')][_0xa9b3('0x86')]({'where':{'id':_0xb507[_0xa9b3('0x4a')]['id']}})['then'](handleEntityNotFound(_0xcce6f,null))[_0xa9b3('0x25')](function(_0x32f02c){if(_0x32f02c){_0x5e0e9a[_0xa9b3('0x30')]=_[_0xa9b3('0x2d')](db[_0xa9b3('0x58')][_0xa9b3('0x82')]);_0x5e0e9a['query']=_[_0xa9b3('0x2d')](_0xb507[_0xa9b3('0x2e')]);_0x5e0e9a['filters']=_[_0xa9b3('0x32')](_0x5e0e9a['model'],_0x5e0e9a[_0xa9b3('0x2e')]);_0xa6b81d[_0xa9b3('0x31')]=_[_0xa9b3('0x32')](_0x5e0e9a[_0xa9b3('0x30')],qs['fields'](_0xb507[_0xa9b3('0x2e')][_0xa9b3('0x83')]));_0xa6b81d[_0xa9b3('0x31')]=_0xa6b81d['attributes'][_0xa9b3('0x33')]?_0xa6b81d['attributes']:_0x5e0e9a[_0xa9b3('0x30')];if(!_0xb507[_0xa9b3('0x2e')][_0xa9b3('0x4f')]('nolimit')){_0xa6b81d[_0xa9b3('0x35')]=qs[_0xa9b3('0x35')](_0xb507[_0xa9b3('0x2e')]['limit']);_0xa6b81d['offset']=qs[_0xa9b3('0x1f')](_0xb507[_0xa9b3('0x2e')][_0xa9b3('0x1f')]);}_0xa6b81d[_0xa9b3('0x36')]=qs[_0xa9b3('0x84')](_0xb507[_0xa9b3('0x2e')]['sort']);_0xa6b81d[_0xa9b3('0x39')]=qs[_0xa9b3('0x2f')](_[_0xa9b3('0x37')](_0xb507[_0xa9b3('0x2e')],_0x5e0e9a[_0xa9b3('0x2f')]));_0xa6b81d[_0xa9b3('0x39')][_0xa9b3('0x89')]=_0x32f02c['id'];if(_0xb507[_0xa9b3('0x2e')]['filter']){_0xa6b81d['where']=_['merge'](_0xa6b81d[_0xa9b3('0x39')],{'$or':_[_0xa9b3('0x3b')](_0xa6b81d[_0xa9b3('0x31')],function(_0x3c7921){var _0x53f8c1={};_0x53f8c1[_0x3c7921]={'$like':'%'+_0xb507[_0xa9b3('0x2e')][_0xa9b3('0x38')]+'%'};return _0x53f8c1;})});}_0xa6b81d=_[_0xa9b3('0x3a')]({},_0xa6b81d,_0xb507[_0xa9b3('0x3c')]);return db[_0xa9b3('0x58')]['count']({'where':_0xa6b81d['where']})[_0xa9b3('0x25')](function(_0x3a2b03){_0x5ce31d['count']=_0x3a2b03;if(_0xb507[_0xa9b3('0x2e')][_0xa9b3('0x42')]){_0xa6b81d[_0xa9b3('0x3d')]=[{'all':!![]}];}return db[_0xa9b3('0x58')][_0xa9b3('0x46')](_0xa6b81d);})[_0xa9b3('0x25')](function(_0x4c4d1d){_0x5ce31d[_0xa9b3('0x47')]=_0x4c4d1d;return _0x5ce31d;});}})[_0xa9b3('0x25')](respondWithFilteredResult(_0xcce6f,_0xa6b81d))['catch'](handleError(_0xcce6f,null));};exports[_0xa9b3('0x8a')]=function(_0x4babd2,_0x2e54e3,_0x4e1d71){var _0x1b1cd3={'raw':!![],'where':{}};var _0xd2a0e7={};var _0x4e7fce={'count':0x0,'rows':[]};return db[_0xa9b3('0x2b')][_0xa9b3('0x86')]({'where':{'id':_0x4babd2[_0xa9b3('0x4a')]['id']}})[_0xa9b3('0x25')](handleEntityNotFound(_0x2e54e3,null))['then'](function(_0x5f5a10){if(_0x5f5a10){_0xd2a0e7[_0xa9b3('0x30')]=_[_0xa9b3('0x2d')](db[_0xa9b3('0x69')][_0xa9b3('0x82')]);_0xd2a0e7[_0xa9b3('0x2e')]=_[_0xa9b3('0x2d')](_0x4babd2[_0xa9b3('0x2e')]);_0xd2a0e7[_0xa9b3('0x2f')]=_[_0xa9b3('0x32')](_0xd2a0e7['model'],_0xd2a0e7['query']);_0x1b1cd3[_0xa9b3('0x31')]=_[_0xa9b3('0x32')](_0xd2a0e7[_0xa9b3('0x30')],qs[_0xa9b3('0x83')](_0x4babd2[_0xa9b3('0x2e')][_0xa9b3('0x83')]));_0x1b1cd3[_0xa9b3('0x31')]=_0x1b1cd3[_0xa9b3('0x31')][_0xa9b3('0x33')]?_0x1b1cd3['attributes']:_0xd2a0e7[_0xa9b3('0x30')];if(!_0x4babd2[_0xa9b3('0x2e')][_0xa9b3('0x4f')](_0xa9b3('0x34'))){_0x1b1cd3[_0xa9b3('0x35')]=qs[_0xa9b3('0x35')](_0x4babd2[_0xa9b3('0x2e')][_0xa9b3('0x35')]);_0x1b1cd3['offset']=qs['offset'](_0x4babd2[_0xa9b3('0x2e')][_0xa9b3('0x1f')]);}_0x1b1cd3[_0xa9b3('0x36')]=qs[_0xa9b3('0x84')](_0x4babd2[_0xa9b3('0x2e')][_0xa9b3('0x84')]);_0x1b1cd3['where']=qs['filters'](_[_0xa9b3('0x37')](_0x4babd2[_0xa9b3('0x2e')],_0xd2a0e7[_0xa9b3('0x2f')]));_0x1b1cd3['where']['ContactId']=_0x5f5a10['id'];if(_0x4babd2['query'][_0xa9b3('0x38')]){_0x1b1cd3['where']=_['merge'](_0x1b1cd3['where'],{'$or':_[_0xa9b3('0x3b')](_0x1b1cd3[_0xa9b3('0x31')],function(_0x34f051){var _0x35d17d={};_0x35d17d[_0x34f051]={'$like':'%'+_0x4babd2[_0xa9b3('0x2e')][_0xa9b3('0x38')]+'%'};return _0x35d17d;})});}_0x1b1cd3=_[_0xa9b3('0x3a')]({},_0x1b1cd3,_0x4babd2[_0xa9b3('0x3c')]);return db[_0xa9b3('0x69')][_0xa9b3('0x41')]({'where':_0x1b1cd3[_0xa9b3('0x39')]})[_0xa9b3('0x25')](function(_0x2a3b39){_0x4e7fce['count']=_0x2a3b39;if(_0x4babd2['query'][_0xa9b3('0x42')]){_0x1b1cd3[_0xa9b3('0x3d')]=[{'all':!![]}];}return db[_0xa9b3('0x69')][_0xa9b3('0x46')](_0x1b1cd3);})[_0xa9b3('0x25')](function(_0x447e41){_0x4e7fce[_0xa9b3('0x47')]=_0x447e41;return _0x4e7fce;});}})[_0xa9b3('0x25')](respondWithFilteredResult(_0x2e54e3,_0x1b1cd3))[_0xa9b3('0x48')](handleError(_0x2e54e3,null));};exports[_0xa9b3('0x8b')]=function(_0x48c331,_0x37ae15,_0x517545){var _0x800385={'raw':!![],'where':{}};var _0x1b7772={};var _0x1e9c9f={'count':0x0,'rows':[]};return db['CmContact'][_0xa9b3('0x86')]({'where':{'id':_0x48c331[_0xa9b3('0x4a')]['id']}})[_0xa9b3('0x25')](handleEntityNotFound(_0x37ae15,null))['then'](function(_0xd8fc5d){if(_0xd8fc5d){_0x1b7772[_0xa9b3('0x30')]=_[_0xa9b3('0x2d')](db[_0xa9b3('0x68')][_0xa9b3('0x82')]);_0x1b7772[_0xa9b3('0x2e')]=_[_0xa9b3('0x2d')](_0x48c331[_0xa9b3('0x2e')]);_0x1b7772[_0xa9b3('0x2f')]=_[_0xa9b3('0x32')](_0x1b7772['model'],_0x1b7772[_0xa9b3('0x2e')]);_0x800385[_0xa9b3('0x31')]=_[_0xa9b3('0x32')](_0x1b7772['model'],qs[_0xa9b3('0x83')](_0x48c331[_0xa9b3('0x2e')][_0xa9b3('0x83')]));_0x800385['attributes']=_0x800385[_0xa9b3('0x31')]['length']?_0x800385[_0xa9b3('0x31')]:_0x1b7772[_0xa9b3('0x30')];if(!_0x48c331[_0xa9b3('0x2e')][_0xa9b3('0x4f')]('nolimit')){_0x800385[_0xa9b3('0x35')]=qs['limit'](_0x48c331[_0xa9b3('0x2e')][_0xa9b3('0x35')]);_0x800385[_0xa9b3('0x1f')]=qs['offset'](_0x48c331[_0xa9b3('0x2e')][_0xa9b3('0x1f')]);}_0x800385['order']=qs[_0xa9b3('0x84')](_0x48c331[_0xa9b3('0x2e')][_0xa9b3('0x84')]);_0x800385['where']=qs[_0xa9b3('0x2f')](_[_0xa9b3('0x37')](_0x48c331[_0xa9b3('0x2e')],_0x1b7772[_0xa9b3('0x2f')]));_0x800385[_0xa9b3('0x39')][_0xa9b3('0x89')]=_0xd8fc5d['id'];if(_0x48c331['query'][_0xa9b3('0x38')]){_0x800385[_0xa9b3('0x39')]=_[_0xa9b3('0x3a')](_0x800385['where'],{'$or':_['map'](_0x800385[_0xa9b3('0x31')],function(_0x5ee05a){var _0x398073={};_0x398073[_0x5ee05a]={'$like':'%'+_0x48c331[_0xa9b3('0x2e')][_0xa9b3('0x38')]+'%'};return _0x398073;})});}_0x800385=_[_0xa9b3('0x3a')]({},_0x800385,_0x48c331['options']);return db[_0xa9b3('0x68')][_0xa9b3('0x41')]({'where':_0x800385[_0xa9b3('0x39')]})[_0xa9b3('0x25')](function(_0x536b54){_0x1e9c9f[_0xa9b3('0x41')]=_0x536b54;if(_0x48c331[_0xa9b3('0x2e')]['includeAll']){_0x800385[_0xa9b3('0x3d')]=[{'all':!![]}];}return db[_0xa9b3('0x68')][_0xa9b3('0x46')](_0x800385);})[_0xa9b3('0x25')](function(_0x40e005){_0x1e9c9f[_0xa9b3('0x47')]=_0x40e005;return _0x1e9c9f;});}})[_0xa9b3('0x25')](respondWithFilteredResult(_0x37ae15,_0x800385))['catch'](handleError(_0x37ae15,null));};exports[_0xa9b3('0x8c')]=function(_0x41c98e,_0x1c3925,_0x318aaa){var _0x5b79e6={'raw':!![],'where':{}};var _0xbec09d={};var _0x480d24={'count':0x0,'rows':[]};return db[_0xa9b3('0x2b')]['findOne']({'where':{'id':_0x41c98e[_0xa9b3('0x4a')]['id']}})[_0xa9b3('0x25')](handleEntityNotFound(_0x1c3925,null))[_0xa9b3('0x25')](function(_0x20a93e){if(_0x20a93e){_0xbec09d[_0xa9b3('0x30')]=_[_0xa9b3('0x2d')](db['JscriptySessionReport'][_0xa9b3('0x82')]);_0xbec09d[_0xa9b3('0x2e')]=_[_0xa9b3('0x2d')](_0x41c98e[_0xa9b3('0x2e')]);_0xbec09d[_0xa9b3('0x2f')]=_[_0xa9b3('0x32')](_0xbec09d['model'],_0xbec09d[_0xa9b3('0x2e')]);_0x5b79e6['attributes']=_[_0xa9b3('0x32')](_0xbec09d[_0xa9b3('0x30')],qs[_0xa9b3('0x83')](_0x41c98e['query'][_0xa9b3('0x83')]));_0x5b79e6['attributes']=_0x5b79e6[_0xa9b3('0x31')]['length']?_0x5b79e6[_0xa9b3('0x31')]:_0xbec09d[_0xa9b3('0x30')];if(!_0x41c98e['query'][_0xa9b3('0x4f')](_0xa9b3('0x34'))){_0x5b79e6[_0xa9b3('0x35')]=qs[_0xa9b3('0x35')](_0x41c98e[_0xa9b3('0x2e')]['limit']);_0x5b79e6[_0xa9b3('0x1f')]=qs['offset'](_0x41c98e[_0xa9b3('0x2e')][_0xa9b3('0x1f')]);}_0x5b79e6[_0xa9b3('0x36')]=qs[_0xa9b3('0x84')](_0x41c98e['query']['sort']);_0x5b79e6[_0xa9b3('0x39')]=qs[_0xa9b3('0x2f')](_['pick'](_0x41c98e[_0xa9b3('0x2e')],_0xbec09d[_0xa9b3('0x2f')]));_0x5b79e6[_0xa9b3('0x39')][_0xa9b3('0x89')]=_0x20a93e['id'];if(_0x41c98e[_0xa9b3('0x2e')][_0xa9b3('0x38')]){_0x5b79e6[_0xa9b3('0x39')]=_[_0xa9b3('0x3a')](_0x5b79e6['where'],{'$or':_[_0xa9b3('0x3b')](_0x5b79e6['attributes'],function(_0x5f1d28){var _0x51d2e6={};_0x51d2e6[_0x5f1d28]={'$like':'%'+_0x41c98e[_0xa9b3('0x2e')][_0xa9b3('0x38')]+'%'};return _0x51d2e6;})});}_0x5b79e6=_[_0xa9b3('0x3a')]({},_0x5b79e6,_0x41c98e[_0xa9b3('0x3c')]);return db[_0xa9b3('0x8d')][_0xa9b3('0x41')]({'where':_0x5b79e6[_0xa9b3('0x39')]})[_0xa9b3('0x25')](function(_0x3c52bb){_0x480d24['count']=_0x3c52bb;if(_0x41c98e[_0xa9b3('0x2e')]['includeAll']){_0x5b79e6['include']=[{'all':!![]}];}return db[_0xa9b3('0x8d')][_0xa9b3('0x46')](_0x5b79e6);})[_0xa9b3('0x25')](function(_0x2175e5){_0x480d24[_0xa9b3('0x47')]=_0x2175e5;return _0x480d24;});}})[_0xa9b3('0x25')](respondWithFilteredResult(_0x1c3925,_0x5b79e6))[_0xa9b3('0x48')](handleError(_0x1c3925,null));};exports[_0xa9b3('0x8e')]=function(_0x515d1c,_0x1a8cf7,_0x17a5b4){try{if(!_0x515d1c['body']['ListId']){throw new Error('No\x20ListId\x20specified');}if(!_0x515d1c[_0xa9b3('0x50')]['binding_keys']){throw new Error(_0xa9b3('0x8f'));}if(!_0x515d1c['body']['binding_values']){throw new Error('No\x20association\x20values\x20specified!');}if(!_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x90')]){throw new Error(_0xa9b3('0x91'));}var _0x2747f3=_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x92')][_0xa9b3('0x93')](',');var _0x202a1f=_0x515d1c['body'][_0xa9b3('0x94')][_0xa9b3('0x93')](',');if(!_0x2747f3['length']||!_0x202a1f[_0xa9b3('0x33')]||_0x2747f3['length']!==_0x202a1f['length']){throw new Error('Incorrect\x20binding\x20parameters\x20passed!');}_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x83')]=_[_0xa9b3('0x95')](_0x2747f3,_0x202a1f);if(!_0x515d1c['body'][_0xa9b3('0x83')][_0xa9b3('0x80')]){throw new Error(_0xa9b3('0x96'));}if(!_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x83')][_0xa9b3('0x97')]){throw new Error(_0xa9b3('0x98'));}var _0x18dafc=path['join'](config[_0xa9b3('0x99')],_0xa9b3('0x9a'),_0x515d1c['file'][_0xa9b3('0x9b')]);fs[_0xa9b3('0x9c')](_0x18dafc,parseInt(_0xa9b3('0x9d'),0x8));var _0x5c16ff=require('child_process')['fork'](path[_0xa9b3('0x55')](__dirname,_0xa9b3('0x9e')),[_0x18dafc,_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x92')],_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x94')],_0x515d1c['body'][_0xa9b3('0x73')],_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x9f')],_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x71')],_0x515d1c[_0xa9b3('0x50')][_0xa9b3('0x90')]]);return _0x1a8cf7[_0xa9b3('0x1d')](0xc8)[_0xa9b3('0x1e')]({'message':_0xa9b3('0xa0'),'pid':_0x5c16ff[_0xa9b3('0xa1')]});}catch(_0x491d33){return _0x1a8cf7['status'](0x1f4)['send'](_0x491d33);}};exports[_0xa9b3('0xa2')]=function(_0x425762,_0x38709e,_0x1f7a1c){var _0x384c81=fs[_0xa9b3('0xa3')](_0x425762['file'][_0xa9b3('0x8')]);Papa['parse'](_0x384c81,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x5d1273){return _0x38709e[_0xa9b3('0x1d')](0xc8)[_0xa9b3('0x1e')]({'file':_0x425762['file'],'fields':_0x5d1273[_0xa9b3('0xa4')]['fields']});}});};exports[_0xa9b3('0xa5')]=function(_0x35f62c,_0x205556,_0x1b3f26){return db[_0xa9b3('0xa6')][_0xa9b3('0x46')]({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0xa9b3('0x25')](function(_0x31c6d6){var _0x101921=![];if(!_0x35f62c['body'][_0xa9b3('0x73')]){throw new Error(_0xa9b3('0xa7'));}if(!_0x35f62c[_0xa9b3('0x50')][_0xa9b3('0xa8')][_0xa9b3('0x80')]){throw new Error(_0xa9b3('0x96'));}if(!_0x35f62c[_0xa9b3('0x50')]['binding'][_0xa9b3('0x97')]){throw new Error(_0xa9b3('0x98'));}if(!_0x35f62c[_0xa9b3('0x50')][_0xa9b3('0x90')]){throw new Error(_0xa9b3('0x91'));}var _0x58b0e6=require(_0xa9b3('0xa9'))['fork'](path[_0xa9b3('0x55')](__dirname,_0xa9b3('0xaa')),[_0x35f62c[_0xa9b3('0x4a')]['id'],JSON[_0xa9b3('0xab')](_0x35f62c[_0xa9b3('0x50')]),JSON[_0xa9b3('0xab')](_0x31c6d6)]);_0x58b0e6['on']('message',function(_0x2defbb){_0x101921=!![];return _0x205556[_0xa9b3('0x1d')](0xc8)[_0xa9b3('0x1e')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x58b0e6['pid']});});_0x58b0e6['on'](_0xa9b3('0xac'),function(_0x35c2bb){if(_0x35c2bb&&!_0x101921){return _0x205556['status'](0x1f4)['json']({'message':_0xa9b3('0xad'),'pid':_0x58b0e6[_0xa9b3('0xa1')]});}});})[_0xa9b3('0x48')](handleError(_0x205556,null));};