Built motion from commit (unavailable).|2.0.76
[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 _0xd517=['dateEnd','dateStart','filters','intersection','attributes','length','hasOwnProperty','nolimit','offset','order','sort','pick','add','day','merge','where','filter','tag','push','Tag','distinct','includeAll','include','color','ThroughTags','CmContact','findAll','rows','catch','find','describe','body','from','get','mergeWith','isArray','tags','info','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','CmHopperBlack','[CmContact][merge][destroy][CmHopperBlack],\x20%s','create','ChatInteraction','ChatMessage','MailInteraction','MailMessage','SmsInteraction','SmsMessage','FaxInteraction','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','ReportAgentPreview','VoiceCallReport','FaxQueueReport','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','join','duplicates','$or','ListId','findOrCreate','spread','show','params','$and','map','format','cf_%d','CmCustomField','omit','pickBy','startsWith','cf_','isEmpty','table','cm_contacts','toParam','sequelize','text','values','phone','getTags','findOne','fields','options','setTags','ids','getHoppers','rawAttributes','getHopperHistories','CmHopperHistory','ContactId','getHopperFinals','getJscriptySessions','JscriptySessionReport','uploadCsv','No\x20ListId\x20specified','No\x20association\x20keys\x20specified!','No\x20association\x20values\x20specified!','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','binding_keys','split','binding_values','zipObject','firstName','No\x20firstName\x20column\x20specified','root','server/files/tmp','file','filename','0777','child_process','CompanyId','createReadStream','parse','meta','import','User','agent','binding','No\x20phone\x20column\x20specified','socket_timestamp','../../components/import/cm/csv2','stringify','message','start\x20child\x20process\x20correctly!','pid','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','querystring','papaparse','../../components/parsers/qs','../../config/logger','../../config/environment','../../mysqldb','socket.io-emitter','./cmContact.socket','register','sendStatus','status','count','limit','set','json','save','update','then','destroy','end','error','name','send','index','model','keys','query'];(function(_0xc6be3a,_0x540e05){var _0x56a310=function(_0x50a144){while(--_0x50a144){_0xc6be3a['push'](_0xc6be3a['shift']());}};_0x56a310(++_0x540e05);}(_0xd517,0x1dd));var _0x7d51=function(_0x28394f,_0x5ebdd2){_0x28394f=_0x28394f-0x0;var _0x2618d2=_0xd517[_0x28394f];return _0x2618d2;};'use strict';var pdf=require(_0x7d51('0x0'));var emlformat=require(_0x7d51('0x1'));var rimraf=require(_0x7d51('0x2'));var zipdir=require(_0x7d51('0x3'));var jsonpatch=require(_0x7d51('0x4'));var rp=require('request-promise');var moment=require(_0x7d51('0x5'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x7d51('0x6'));var path=require(_0x7d51('0x7'));var sox=require(_0x7d51('0x8'));var csv=require(_0x7d51('0x9'));var ejs=require(_0x7d51('0xa'));var fs=require('fs');var _=require(_0x7d51('0xb'));var squel=require(_0x7d51('0xc'));var crypto=require(_0x7d51('0xd'));var jsforce=require(_0x7d51('0xe'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0x7d51('0xf'));var Papa=require(_0x7d51('0x10'));var qs=require(_0x7d51('0x11'));var logger=require(_0x7d51('0x12'))('api');var utils=require('../../config/utils');var config=require(_0x7d51('0x13'));var db=require(_0x7d51('0x14'))['db'];var socket=require(_0x7d51('0x15'))({'host':'localhost','port':0x18eb});require(_0x7d51('0x16'))[_0x7d51('0x17')](socket);function respondWithStatusCode(_0x5635b3,_0x862d23){_0x862d23=_0x862d23||0xcc;return function(_0x4d2446){if(_0x4d2446){return _0x5635b3[_0x7d51('0x18')](_0x862d23);}return _0x5635b3[_0x7d51('0x19')](_0x862d23)['end']();};}function respondWithResult(_0x5c8f6d,_0xdffda4){_0xdffda4=_0xdffda4||0xc8;return function(_0xe77939){if(_0xe77939){return _0x5c8f6d[_0x7d51('0x19')](_0xdffda4)['json'](_0xe77939);}};}function respondWithFilteredResult(_0x516468,_0x305c26){return function(_0x1ea497){if(_0x1ea497){var _0x31c95c=_0x1ea497[_0x7d51('0x1a')],_0x102eb7=_0x305c26['offset'],_0x5c7122=_0x305c26['offset']+_0x305c26[_0x7d51('0x1b')],_0x5c5bda;if(_0x5c7122>=_0x31c95c){_0x5c7122=_0x31c95c;_0x5c5bda=0xc8;}else{_0x5c5bda=0xce;}_0x516468[_0x7d51('0x19')](_0x5c5bda);return _0x516468[_0x7d51('0x1c')]('Content-Range',_0x102eb7+'-'+_0x5c7122+'/'+_0x31c95c)[_0x7d51('0x1d')](_0x1ea497);}return null;};}function patchUpdates(_0x1f0300){return function(_0x71995c){try{jsonpatch['apply'](_0x71995c,_0x1f0300,!![]);}catch(_0x2f3f44){return BPromise['reject'](_0x2f3f44);}return _0x71995c[_0x7d51('0x1e')]();};}function saveUpdates(_0x5523c1,_0x3401f8){return function(_0x401c96){if(_0x401c96){return _0x401c96[_0x7d51('0x1f')](_0x5523c1)[_0x7d51('0x20')](function(_0x3d889e){return _0x3d889e;});}return null;};}function removeEntity(_0xac560,_0x2ebce3){return function(_0x17463e){if(_0x17463e){return _0x17463e[_0x7d51('0x21')]()[_0x7d51('0x20')](function(){_0xac560[_0x7d51('0x19')](0xcc)[_0x7d51('0x22')]();});}};}function handleEntityNotFound(_0x44f118,_0x1e1f8c){return function(_0x24bf87){if(!_0x24bf87){_0x44f118[_0x7d51('0x18')](0x194);}return _0x24bf87;};}function handleError(_0x1e0201,_0x4efca7){_0x4efca7=_0x4efca7||0x1f4;return function(_0x1e739b){logger[_0x7d51('0x23')](_0x1e739b['stack']);if(_0x1e739b[_0x7d51('0x24')]){delete _0x1e739b[_0x7d51('0x24')];}_0x1e0201[_0x7d51('0x19')](_0x4efca7)[_0x7d51('0x25')](_0x1e739b);};}exports[_0x7d51('0x26')]=function(_0x422c64,_0x3da100){var _0x46942b={},_0x3761cc={},_0x356109={'count':0x0,'rows':[]};return db['CmContact']['describe']()['then'](function(_0x2b5b48){_0x3761cc[_0x7d51('0x27')]=_[_0x7d51('0x28')](_0x2b5b48);var _0x5ae6c6={'dateStart':_0x422c64[_0x7d51('0x29')]['dateStart'],'dateEnd':_0x422c64[_0x7d51('0x29')][_0x7d51('0x2a')]};delete _0x422c64[_0x7d51('0x29')][_0x7d51('0x2b')];delete _0x422c64[_0x7d51('0x29')][_0x7d51('0x2a')];_0x3761cc[_0x7d51('0x29')]=_[_0x7d51('0x28')](_0x422c64[_0x7d51('0x29')]);_0x3761cc[_0x7d51('0x2c')]=_[_0x7d51('0x2d')](_0x3761cc[_0x7d51('0x27')],_0x3761cc[_0x7d51('0x29')]);_0x46942b[_0x7d51('0x2e')]=_[_0x7d51('0x2d')](_0x3761cc['model'],qs['fields'](_0x422c64[_0x7d51('0x29')]['fields']));_0x46942b[_0x7d51('0x2e')]=_0x46942b[_0x7d51('0x2e')][_0x7d51('0x2f')]?_0x46942b['attributes']:_0x3761cc[_0x7d51('0x27')];if(!_0x422c64[_0x7d51('0x29')][_0x7d51('0x30')](_0x7d51('0x31'))){_0x46942b[_0x7d51('0x1b')]=qs[_0x7d51('0x1b')](_0x422c64['query'][_0x7d51('0x1b')]);_0x46942b[_0x7d51('0x32')]=qs[_0x7d51('0x32')](_0x422c64[_0x7d51('0x29')]['offset']);}_0x46942b[_0x7d51('0x33')]=qs[_0x7d51('0x34')](_0x422c64[_0x7d51('0x29')][_0x7d51('0x34')]);_0x46942b['where']=qs[_0x7d51('0x2c')](_[_0x7d51('0x35')](_0x422c64['query'],_0x3761cc['filters']));if(_0x5ae6c6[_0x7d51('0x2b')]){if(_0x5ae6c6[_0x7d51('0x2a')]){_0x5ae6c6[_0x7d51('0x2a')]=moment(_0x5ae6c6[_0x7d51('0x2a')])[_0x7d51('0x36')](0x1,'day');}else{_0x5ae6c6[_0x7d51('0x2a')]=moment(_0x5ae6c6[_0x7d51('0x2b')])['add'](0x1,_0x7d51('0x37'));}_[_0x7d51('0x38')](_0x46942b[_0x7d51('0x39')],{'createdAt':{'$gte':_0x5ae6c6[_0x7d51('0x2b')],'$lte':_0x5ae6c6[_0x7d51('0x2a')]}});}if(_0x422c64[_0x7d51('0x29')][_0x7d51('0x3a')]){_0x46942b['where']=_[_0x7d51('0x38')](_0x46942b[_0x7d51('0x39')],{'$or':_['map'](_0x46942b[_0x7d51('0x2e')],function(_0x3ce886){var _0x49c60d={};_0x49c60d[_0x3ce886]={'$like':'%'+_0x422c64[_0x7d51('0x29')]['filter']+'%'};return _0x49c60d;})});}_0x46942b=_[_0x7d51('0x38')]({},_0x46942b,_0x422c64['options']);var _0x5b87fb={'where':_0x46942b[_0x7d51('0x39')]};_0x5b87fb['include']=[];if(_0x422c64[_0x7d51('0x29')][_0x7d51('0x3b')]){_0x5b87fb['include'][_0x7d51('0x3c')]({'model':db[_0x7d51('0x3d')],'as':'Tags','attributes':['id'],'where':{'id':_0x422c64['query'][_0x7d51('0x3b')]},'required':!![]});_0x5b87fb[_0x7d51('0x3e')]=!![];}return db['CmContact']['count'](_0x5b87fb)[_0x7d51('0x20')](function(_0x20366b){_0x356109[_0x7d51('0x1a')]=_0x20366b;if(_0x422c64['query'][_0x7d51('0x3f')]){_0x46942b[_0x7d51('0x40')]=[{'model':db[_0x7d51('0x3d')],'as':'Tags','attributes':['id',_0x7d51('0x24'),_0x7d51('0x41')],'required':_0x422c64[_0x7d51('0x29')]['tag']?!![]:![]},{'model':db[_0x7d51('0x3d')],'as':_0x7d51('0x42'),'attributes':['id',_0x7d51('0x24'),_0x7d51('0x41')],'through':_0x422c64[_0x7d51('0x29')][_0x7d51('0x3b')]?{'attributes':[],'where':{'TagId':_0x422c64[_0x7d51('0x29')][_0x7d51('0x3b')]||undefined}}:{},'required':_0x422c64[_0x7d51('0x29')][_0x7d51('0x3b')]?!![]:![]}];}return db[_0x7d51('0x43')][_0x7d51('0x44')](_0x46942b);})[_0x7d51('0x20')](function(_0xcea28f){_0x356109[_0x7d51('0x45')]=_0xcea28f;return _0x356109;})[_0x7d51('0x20')](respondWithFilteredResult(_0x3da100,_0x46942b))[_0x7d51('0x46')](handleError(_0x3da100,null));});};exports[_0x7d51('0x21')]=function(_0x124f65,_0x7cf987){return db[_0x7d51('0x43')][_0x7d51('0x47')]({'where':{'id':_0x124f65['params']['id']}})[_0x7d51('0x20')](handleEntityNotFound(_0x7cf987,null))[_0x7d51('0x20')](removeEntity(_0x7cf987,null))[_0x7d51('0x46')](handleError(_0x7cf987,null));};exports[_0x7d51('0x48')]=function(_0x25ee28,_0x2a6d47){return db['CmContact'][_0x7d51('0x48')]()['then'](respondWithResult(_0x2a6d47,null))['catch'](handleError(_0x2a6d47,null));};exports[_0x7d51('0x38')]=function(_0x27669f,_0x56df8e){var _0x4db475;var _0x4388a7;var _0x38424a;if(_0x27669f[_0x7d51('0x49')]['id']){delete _0x27669f[_0x7d51('0x49')]['id'];}return db[_0x7d51('0x43')]['findAll']({'where':{'id':[_0x27669f[_0x7d51('0x49')]['to'],_0x27669f[_0x7d51('0x49')][_0x7d51('0x4a')]]}})[_0x7d51('0x20')](function(_0x36a28c){if(_0x36a28c){if(_0x36a28c[_0x7d51('0x2f')]!==0x2){return null;}_0x36a28c[0x0]=_0x36a28c[0x0]['get']({'plain':!![]});_0x36a28c[0x1]=_0x36a28c[0x1][_0x7d51('0x4b')]({'plain':!![]});delete _0x36a28c[0x0]['id'];delete _0x36a28c[0x1]['id'];return _[_0x7d51('0x4c')](_0x36a28c[0x0],_0x36a28c[0x1],function(_0x5a4e37,_0x510ca1){if(Array[_0x7d51('0x4d')](_0x510ca1)&&!_0x510ca1[_0x7d51('0x2f')]){return _0x5a4e37;}else if(!_0x510ca1){return _0x5a4e37;}});}})[_0x7d51('0x20')](handleEntityNotFound(_0x56df8e,null))[_0x7d51('0x20')](function(_0x1e19fd){if(_0x1e19fd){if(_0x1e19fd['tags']&&_[_0x7d51('0x4d')](_0x1e19fd[_0x7d51('0x4e')])){_0x1e19fd[_0x7d51('0x4e')]=_0x1e19fd[_0x7d51('0x4e')]['join']();}logger[_0x7d51('0x4f')](_0x7d51('0x50'),_0x27669f['body']['to'],_0x27669f[_0x7d51('0x49')][_0x7d51('0x4a')]);return db[_0x7d51('0x51')][_0x7d51('0x21')]({'where':{'ContactId':[_0x27669f[_0x7d51('0x49')]['to'],_0x27669f[_0x7d51('0x49')][_0x7d51('0x4a')]]}})['then'](function(_0x9634a4){logger['info'](_0x7d51('0x52'),_0x9634a4);return db[_0x7d51('0x53')][_0x7d51('0x21')]({'where':{'ContactId':[_0x27669f[_0x7d51('0x49')]['to'],_0x27669f[_0x7d51('0x49')][_0x7d51('0x4a')]]}})[_0x7d51('0x20')](function(_0x2bec21){logger[_0x7d51('0x4f')](_0x7d51('0x54'),_0x2bec21);return db[_0x7d51('0x43')][_0x7d51('0x55')](_0x1e19fd);});});}})[_0x7d51('0x20')](function(_0x2033f8){if(_0x2033f8){_0x4db475=_0x2033f8;_0x4388a7={'ContactId':_0x4db475['id']};_0x38424a={'where':{'ContactId':[_0x27669f[_0x7d51('0x49')]['to'],_0x27669f['body'][_0x7d51('0x4a')]]}};return db[_0x7d51('0x56')][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db[_0x7d51('0x57')][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db['ChatOfflineMessage']['update'](_0x4388a7,_0x38424a);}})['then'](function(){if(_0x4db475){return db[_0x7d51('0x58')][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db[_0x7d51('0x59')][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db[_0x7d51('0x58')][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db[_0x7d51('0x59')][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db[_0x7d51('0x5a')][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db[_0x7d51('0x5b')]['update'](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db[_0x7d51('0x5c')][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db['FaxMessage'][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db[_0x7d51('0x5d')]['update'](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db[_0x7d51('0x5e')][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db[_0x7d51('0x5f')][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db['CmHopperHistory']['update'](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db[_0x7d51('0x60')][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db[_0x7d51('0x61')][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db['ChatQueueReport'][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db[_0x7d51('0x62')]['update'](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db[_0x7d51('0x63')][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db[_0x7d51('0x64')][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db[_0x7d51('0x65')][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db['JscriptySessionReport'][_0x7d51('0x1f')](_0x4388a7,_0x38424a);}})[_0x7d51('0x20')](function(){if(_0x4db475){return db[_0x7d51('0x43')][_0x7d51('0x21')]({'where':{'id':[_0x27669f[_0x7d51('0x49')]['to'],_0x27669f[_0x7d51('0x49')][_0x7d51('0x4a')]]}});}})[_0x7d51('0x20')](function(){if(_0x4db475){return _0x4db475;}})['then'](respondWithResult(_0x56df8e,null))[_0x7d51('0x46')](handleError(_0x56df8e,null));};exports[_0x7d51('0x55')]=function(_0x3fe11e,_0x31cf65){return db[_0x7d51('0x43')]['describe']()[_0x7d51('0x20')](function(_0x354f90){if(_0x3fe11e[_0x7d51('0x49')][_0x7d51('0x4e')]&&_['isArray'](_0x3fe11e[_0x7d51('0x49')][_0x7d51('0x4e')])){if(_0x3fe11e['body'][_0x7d51('0x4e')][_0x7d51('0x2f')]){_0x3fe11e['body'][_0x7d51('0x4e')]=_0x3fe11e[_0x7d51('0x49')][_0x7d51('0x4e')][_0x7d51('0x66')](';')+';';}else{_0x3fe11e[_0x7d51('0x49')][_0x7d51('0x4e')]=null;}}else{_0x3fe11e['body'][_0x7d51('0x4e')]=null;}return db[_0x7d51('0x43')]['create'](_0x3fe11e[_0x7d51('0x49')],{'fields':_[_0x7d51('0x28')](_0x354f90),'raw':!![]});})[_0x7d51('0x20')](respondWithResult(_0x31cf65,0xc9))[_0x7d51('0x46')](handleError(_0x31cf65,null));};exports['bulkCreate']=function(_0x926724,_0x46608e){var _0xea6a1c=[];var _0x25b3b5=0x0;var _0x489265=0x0;var _0x3aa11f=0x0;return db[_0x7d51('0x43')][_0x7d51('0x48')]()[_0x7d51('0x20')](function(_0x1af356){return BPromise['each'](_0x926724['body'],function(_0x1be2bf){var _0x415271={'where':{'$or':[]},'defaults':_0x1be2bf,'fields':_[_0x7d51('0x28')](_0x1af356),'raw':!![]};if(_0x1be2bf[_0x7d51('0x67')]){for(var _0x2b422f=0x0;_0x2b422f<_0x1be2bf[_0x7d51('0x67')][_0x7d51('0x2f')];_0x2b422f++){var _0x4703f8={};_0x4703f8[_0x1be2bf[_0x7d51('0x67')][_0x2b422f]]=_0x1be2bf[_0x1be2bf[_0x7d51('0x67')][_0x2b422f]];_0x415271['where'][_0x7d51('0x68')]['push'](_0x4703f8);}_0x415271[_0x7d51('0x39')][_0x7d51('0x69')]=_0x1be2bf['ListId'];}return db[_0x7d51('0x43')][_0x7d51('0x6a')](_0x415271)[_0x7d51('0x6b')](function(_0x7c22b5,_0x55ffa9){if(_0x55ffa9){_0x25b3b5++;}else{_0x3aa11f++;}})[_0x7d51('0x46')](function(_0x30ab96){console[_0x7d51('0x23')](_0x30ab96);_0x489265++;});});})[_0x7d51('0x20')](function(_0x16f0d7){if(_0x16f0d7){return{'success':_0x25b3b5,'failure':_0x489265,'duplicates':_0x3aa11f};}})[_0x7d51('0x20')](respondWithResult(_0x46608e,0xc9))[_0x7d51('0x46')](handleError(_0x46608e,null));};exports[_0x7d51('0x6c')]=function(_0x383734,_0xa1e1cb,_0x426548){var _0x57cb9;return db[_0x7d51('0x43')][_0x7d51('0x48')]()[_0x7d51('0x20')](function(_0x1680b){return db[_0x7d51('0x43')][_0x7d51('0x47')]({'where':{'id':_0x383734[_0x7d51('0x6d')]['id']},'include':[{'model':db[_0x7d51('0x3d')],'as':'Tags','attributes':['id',_0x7d51('0x24'),_0x7d51('0x41')],'required':_0x383734['query'][_0x7d51('0x3b')]?!![]:![]}],'attributes':_[_0x7d51('0x28')](_0x1680b)});})[_0x7d51('0x20')](function(_0x548a7b){_0x57cb9=_0x548a7b[_0x7d51('0x4b')]({'plain':!![]});var _0x559eda={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x548a7b&&_0x548a7b['ListId']){if(_0x548a7b[_0x7d51('0x69')]){_0x559eda[_0x7d51('0x39')][_0x7d51('0x6e')][_0x7d51('0x3c')]({'ListId':{'$ne':_0x548a7b[_0x7d51('0x69')]}});}}return db['CmCustomField'][_0x7d51('0x44')](_0x559eda);})[_0x7d51('0x20')](function(_0x2d8a4d){return _['omit'](_0x57cb9,_[_0x7d51('0x6f')](_0x2d8a4d,function(_0x15f800){return util[_0x7d51('0x70')](_0x7d51('0x71'),_0x15f800['id']);}));})[_0x7d51('0x20')](handleEntityNotFound(_0xa1e1cb,null))['then'](respondWithResult(_0xa1e1cb,null))[_0x7d51('0x46')](handleError(_0xa1e1cb,null));};exports[_0x7d51('0x1f')]=function(_0xacef67,_0xf53e46){var _0x320ee7;if(_0xacef67[_0x7d51('0x49')]['id']){delete _0xacef67[_0x7d51('0x49')]['id'];}return db[_0x7d51('0x43')]['find']({'where':{'id':_0xacef67[_0x7d51('0x6d')]['id']}})[_0x7d51('0x20')](handleEntityNotFound(_0xf53e46,null))[_0x7d51('0x20')](saveUpdates(_0xacef67[_0x7d51('0x49')],null))[_0x7d51('0x20')](function(_0x1e0207){_0x320ee7=_0x1e0207;var _0x482e38={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x1e0207&&_0x1e0207[_0x7d51('0x69')]){if(_0x1e0207['ListId']){_0x482e38['where'][_0x7d51('0x6e')][_0x7d51('0x3c')]({'ListId':{'$ne':_0x1e0207[_0x7d51('0x69')]}});}}return db[_0x7d51('0x72')][_0x7d51('0x44')](_0x482e38);})[_0x7d51('0x20')](function(_0x22459f){if(_0x22459f){return _[_0x7d51('0x73')](_[_0x7d51('0x74')](_0xacef67['body'],function(_0x472746,_0x1a7524){return _[_0x7d51('0x75')](_0x1a7524,_0x7d51('0x76'));}),_[_0x7d51('0x6f')](_0x22459f,function(_0x3946f9){return util[_0x7d51('0x70')](_0x7d51('0x71'),_0x3946f9['id']);}));}})[_0x7d51('0x20')](function(_0x1652b2){if(_0x1652b2&&!_[_0x7d51('0x77')](_0x1652b2)){var _0x1377e3=squel['update']()[_0x7d51('0x78')](_0x7d51('0x79'))['setFields'](_0x1652b2)[_0x7d51('0x39')]('id\x20=\x20?',_0xacef67[_0x7d51('0x6d')]['id'])[_0x7d51('0x7a')]();return db[_0x7d51('0x7b')][_0x7d51('0x29')](_0x1377e3[_0x7d51('0x7c')],{'replacements':_0x1377e3[_0x7d51('0x7d')]});}})[_0x7d51('0x20')](function(){if(_0xacef67['body'][_0x7d51('0x7e')]&&_0x320ee7){return db[_0x7d51('0x51')][_0x7d51('0x1f')]({'phone':_0xacef67[_0x7d51('0x49')][_0x7d51('0x7e')]},{'where':{'ContactId':_0x320ee7['id']}});}})['then'](function(){return _0x320ee7;})[_0x7d51('0x20')](respondWithResult(_0xf53e46,null))[_0x7d51('0x46')](handleError(_0xf53e46,null));};exports[_0x7d51('0x7f')]=function(_0x559c25,_0xf9278d,_0x297432){var _0x6f917={};var _0x1c6c90={};var _0x2a9173;var _0x44e3e7;return db[_0x7d51('0x43')][_0x7d51('0x80')]({'where':{'id':_0x559c25[_0x7d51('0x6d')]['id']}})[_0x7d51('0x20')](handleEntityNotFound(_0xf9278d,null))['then'](function(_0x1fc47c){if(_0x1fc47c){_0x2a9173=_0x1fc47c;_0x1c6c90[_0x7d51('0x27')]=_[_0x7d51('0x28')](db['Tag']['rawAttributes']);_0x1c6c90['query']=_[_0x7d51('0x28')](_0x559c25['query']);_0x1c6c90[_0x7d51('0x2c')]=_[_0x7d51('0x2d')](_0x1c6c90['model'],_0x1c6c90[_0x7d51('0x29')]);_0x6f917['attributes']=_[_0x7d51('0x2d')](_0x1c6c90['model'],qs[_0x7d51('0x81')](_0x559c25[_0x7d51('0x29')][_0x7d51('0x81')]));_0x6f917['attributes']=_0x6f917[_0x7d51('0x2e')]['length']?_0x6f917[_0x7d51('0x2e')]:_0x1c6c90['model'];_0x6f917[_0x7d51('0x33')]=qs[_0x7d51('0x34')](_0x559c25[_0x7d51('0x29')][_0x7d51('0x34')]);_0x6f917[_0x7d51('0x39')]=qs['filters'](_['pick'](_0x559c25['query'],_0x1c6c90[_0x7d51('0x2c')]));if(_0x559c25[_0x7d51('0x29')][_0x7d51('0x3a')]){_0x6f917[_0x7d51('0x39')]=_['merge'](_0x6f917[_0x7d51('0x39')],{'$or':_[_0x7d51('0x6f')](_0x6f917[_0x7d51('0x2e')],function(_0x4ea05d){var _0x4759ad={};_0x4759ad[_0x4ea05d]={'$like':'%'+_0x559c25[_0x7d51('0x29')]['filter']+'%'};return _0x4759ad;})});}_0x6f917=_[_0x7d51('0x38')]({},_0x6f917,_0x559c25[_0x7d51('0x82')]);return _0x2a9173[_0x7d51('0x7f')](_0x6f917);}})[_0x7d51('0x20')](function(_0xedf662){if(_0xedf662){_0x44e3e7=_0xedf662['length'];if(!_0x559c25[_0x7d51('0x29')]['hasOwnProperty']('nolimit')){_0x6f917['limit']=qs[_0x7d51('0x1b')](_0x559c25['query'][_0x7d51('0x1b')]);_0x6f917[_0x7d51('0x32')]=qs[_0x7d51('0x32')](_0x559c25[_0x7d51('0x29')][_0x7d51('0x32')]);}return _0x2a9173[_0x7d51('0x7f')](_0x6f917);}})[_0x7d51('0x20')](function(_0x46d9b8){if(_0x46d9b8){return _0x46d9b8?{'count':_0x44e3e7,'rows':_0x46d9b8}:null;}})[_0x7d51('0x20')](respondWithResult(_0xf9278d,null))['catch'](handleError(_0xf9278d,null));};exports[_0x7d51('0x83')]=function(_0x19a4eb,_0xd7944f,_0xa21a0c){if(_0x19a4eb[_0x7d51('0x49')]['id']){delete _0x19a4eb[_0x7d51('0x49')]['id'];}return db[_0x7d51('0x43')][_0x7d51('0x80')]({'where':{'id':_0x19a4eb[_0x7d51('0x6d')]['id']}})[_0x7d51('0x20')](handleEntityNotFound(_0xd7944f,null))['then'](function(_0x52cfa8){if(_0x52cfa8){return _0x52cfa8[_0x7d51('0x83')](_0x19a4eb[_0x7d51('0x49')][_0x7d51('0x84')]||[]);}return null;})[_0x7d51('0x20')](respondWithResult(_0xd7944f,null))[_0x7d51('0x46')](handleError(_0xd7944f,null));};exports[_0x7d51('0x85')]=function(_0x2289c8,_0x419a9c,_0x2b4d20){var _0x4f09aa={'raw':![],'where':{}};var _0xa78ea4={};var _0x674e51={'count':0x0,'rows':[]};return db[_0x7d51('0x43')][_0x7d51('0x80')]({'where':{'id':_0x2289c8[_0x7d51('0x6d')]['id']}})[_0x7d51('0x20')](handleEntityNotFound(_0x419a9c,null))['then'](function(_0x1e9db4){if(_0x1e9db4){_0xa78ea4['model']=_[_0x7d51('0x28')](db[_0x7d51('0x51')][_0x7d51('0x86')]);_0xa78ea4[_0x7d51('0x29')]=_['keys'](_0x2289c8[_0x7d51('0x29')]);_0xa78ea4[_0x7d51('0x2c')]=_[_0x7d51('0x2d')](_0xa78ea4['model'],_0xa78ea4[_0x7d51('0x29')]);_0x4f09aa[_0x7d51('0x2e')]=_[_0x7d51('0x2d')](_0xa78ea4['model'],qs[_0x7d51('0x81')](_0x2289c8['query'][_0x7d51('0x81')]));_0x4f09aa[_0x7d51('0x2e')]=_0x4f09aa['attributes']['length']?_0x4f09aa[_0x7d51('0x2e')]:_0xa78ea4['model'];if(!_0x2289c8[_0x7d51('0x29')][_0x7d51('0x30')]('nolimit')){_0x4f09aa[_0x7d51('0x1b')]=qs[_0x7d51('0x1b')](_0x2289c8[_0x7d51('0x29')]['limit']);_0x4f09aa[_0x7d51('0x32')]=qs[_0x7d51('0x32')](_0x2289c8['query'][_0x7d51('0x32')]);}_0x4f09aa[_0x7d51('0x33')]=qs[_0x7d51('0x34')](_0x2289c8[_0x7d51('0x29')]['sort']);_0x4f09aa[_0x7d51('0x39')]=qs['filters'](_[_0x7d51('0x35')](_0x2289c8[_0x7d51('0x29')],_0xa78ea4[_0x7d51('0x2c')]));_0x4f09aa[_0x7d51('0x39')]['ContactId']=_0x1e9db4['id'];if(_0x2289c8['query'][_0x7d51('0x3a')]){_0x4f09aa[_0x7d51('0x39')]=_[_0x7d51('0x38')](_0x4f09aa[_0x7d51('0x39')],{'$or':_['map'](_0x4f09aa[_0x7d51('0x2e')],function(_0x102055){var _0x3d58a9={};_0x3d58a9[_0x102055]={'$like':'%'+_0x2289c8[_0x7d51('0x29')][_0x7d51('0x3a')]+'%'};return _0x3d58a9;})});}_0x4f09aa=_[_0x7d51('0x38')]({},_0x4f09aa,_0x2289c8[_0x7d51('0x82')]);return db[_0x7d51('0x51')][_0x7d51('0x1a')]({'where':_0x4f09aa['where']})[_0x7d51('0x20')](function(_0x5f05e0){_0x674e51[_0x7d51('0x1a')]=_0x5f05e0;if(_0x2289c8[_0x7d51('0x29')][_0x7d51('0x3f')]){_0x4f09aa['include']=[{'all':!![]}];}return db[_0x7d51('0x51')][_0x7d51('0x44')](_0x4f09aa);})[_0x7d51('0x20')](function(_0x40a2a2){_0x674e51[_0x7d51('0x45')]=_0x40a2a2;return _0x674e51;});}})['then'](respondWithFilteredResult(_0x419a9c,_0x4f09aa))[_0x7d51('0x46')](handleError(_0x419a9c,null));};exports[_0x7d51('0x87')]=function(_0x5e038b,_0x5e0edf,_0x2359a6){var _0x4341d2={'raw':!![],'where':{}};var _0x152934={};var _0x49ce31={'count':0x0,'rows':[]};return db[_0x7d51('0x43')][_0x7d51('0x80')]({'where':{'id':_0x5e038b[_0x7d51('0x6d')]['id']}})[_0x7d51('0x20')](handleEntityNotFound(_0x5e0edf,null))[_0x7d51('0x20')](function(_0x2bb982){if(_0x2bb982){_0x152934[_0x7d51('0x27')]=_['keys'](db[_0x7d51('0x88')][_0x7d51('0x86')]);_0x152934['query']=_[_0x7d51('0x28')](_0x5e038b['query']);_0x152934['filters']=_[_0x7d51('0x2d')](_0x152934['model'],_0x152934[_0x7d51('0x29')]);_0x4341d2['attributes']=_['intersection'](_0x152934[_0x7d51('0x27')],qs[_0x7d51('0x81')](_0x5e038b[_0x7d51('0x29')][_0x7d51('0x81')]));_0x4341d2[_0x7d51('0x2e')]=_0x4341d2[_0x7d51('0x2e')][_0x7d51('0x2f')]?_0x4341d2['attributes']:_0x152934[_0x7d51('0x27')];if(!_0x5e038b[_0x7d51('0x29')][_0x7d51('0x30')]('nolimit')){_0x4341d2[_0x7d51('0x1b')]=qs[_0x7d51('0x1b')](_0x5e038b[_0x7d51('0x29')][_0x7d51('0x1b')]);_0x4341d2['offset']=qs[_0x7d51('0x32')](_0x5e038b[_0x7d51('0x29')]['offset']);}_0x4341d2[_0x7d51('0x33')]=qs[_0x7d51('0x34')](_0x5e038b[_0x7d51('0x29')][_0x7d51('0x34')]);_0x4341d2[_0x7d51('0x39')]=qs[_0x7d51('0x2c')](_[_0x7d51('0x35')](_0x5e038b['query'],_0x152934['filters']));_0x4341d2['where'][_0x7d51('0x89')]=_0x2bb982['id'];if(_0x5e038b[_0x7d51('0x29')][_0x7d51('0x3a')]){_0x4341d2[_0x7d51('0x39')]=_['merge'](_0x4341d2['where'],{'$or':_[_0x7d51('0x6f')](_0x4341d2['attributes'],function(_0x57046d){var _0x1fe265={};_0x1fe265[_0x57046d]={'$like':'%'+_0x5e038b[_0x7d51('0x29')][_0x7d51('0x3a')]+'%'};return _0x1fe265;})});}_0x4341d2=_[_0x7d51('0x38')]({},_0x4341d2,_0x5e038b[_0x7d51('0x82')]);return db[_0x7d51('0x88')][_0x7d51('0x1a')]({'where':_0x4341d2[_0x7d51('0x39')]})['then'](function(_0x52a259){_0x49ce31['count']=_0x52a259;if(_0x5e038b[_0x7d51('0x29')][_0x7d51('0x3f')]){_0x4341d2['include']=[{'all':!![]}];}return db[_0x7d51('0x88')][_0x7d51('0x44')](_0x4341d2);})['then'](function(_0x47ea57){_0x49ce31[_0x7d51('0x45')]=_0x47ea57;return _0x49ce31;});}})['then'](respondWithFilteredResult(_0x5e0edf,_0x4341d2))[_0x7d51('0x46')](handleError(_0x5e0edf,null));};exports[_0x7d51('0x8a')]=function(_0x5bfa7d,_0x1aa315,_0x1aa518){var _0x290675={'raw':!![],'where':{}};var _0x3cc7dc={};var _0x2ff45b={'count':0x0,'rows':[]};return db['CmContact']['findOne']({'where':{'id':_0x5bfa7d[_0x7d51('0x6d')]['id']}})['then'](handleEntityNotFound(_0x1aa315,null))[_0x7d51('0x20')](function(_0x4cfcae){if(_0x4cfcae){_0x3cc7dc[_0x7d51('0x27')]=_[_0x7d51('0x28')](db[_0x7d51('0x5f')][_0x7d51('0x86')]);_0x3cc7dc[_0x7d51('0x29')]=_[_0x7d51('0x28')](_0x5bfa7d[_0x7d51('0x29')]);_0x3cc7dc[_0x7d51('0x2c')]=_[_0x7d51('0x2d')](_0x3cc7dc[_0x7d51('0x27')],_0x3cc7dc[_0x7d51('0x29')]);_0x290675[_0x7d51('0x2e')]=_[_0x7d51('0x2d')](_0x3cc7dc[_0x7d51('0x27')],qs[_0x7d51('0x81')](_0x5bfa7d[_0x7d51('0x29')][_0x7d51('0x81')]));_0x290675[_0x7d51('0x2e')]=_0x290675[_0x7d51('0x2e')][_0x7d51('0x2f')]?_0x290675['attributes']:_0x3cc7dc[_0x7d51('0x27')];if(!_0x5bfa7d[_0x7d51('0x29')][_0x7d51('0x30')](_0x7d51('0x31'))){_0x290675[_0x7d51('0x1b')]=qs[_0x7d51('0x1b')](_0x5bfa7d[_0x7d51('0x29')][_0x7d51('0x1b')]);_0x290675[_0x7d51('0x32')]=qs[_0x7d51('0x32')](_0x5bfa7d[_0x7d51('0x29')]['offset']);}_0x290675[_0x7d51('0x33')]=qs[_0x7d51('0x34')](_0x5bfa7d[_0x7d51('0x29')][_0x7d51('0x34')]);_0x290675['where']=qs[_0x7d51('0x2c')](_[_0x7d51('0x35')](_0x5bfa7d[_0x7d51('0x29')],_0x3cc7dc['filters']));_0x290675[_0x7d51('0x39')]['ContactId']=_0x4cfcae['id'];if(_0x5bfa7d['query'][_0x7d51('0x3a')]){_0x290675[_0x7d51('0x39')]=_[_0x7d51('0x38')](_0x290675['where'],{'$or':_['map'](_0x290675['attributes'],function(_0x33c2dc){var _0x474b21={};_0x474b21[_0x33c2dc]={'$like':'%'+_0x5bfa7d[_0x7d51('0x29')][_0x7d51('0x3a')]+'%'};return _0x474b21;})});}_0x290675=_[_0x7d51('0x38')]({},_0x290675,_0x5bfa7d[_0x7d51('0x82')]);return db['CmHopperFinal'][_0x7d51('0x1a')]({'where':_0x290675[_0x7d51('0x39')]})['then'](function(_0x2b98c2){_0x2ff45b['count']=_0x2b98c2;if(_0x5bfa7d['query'][_0x7d51('0x3f')]){_0x290675[_0x7d51('0x40')]=[{'all':!![]}];}return db[_0x7d51('0x5f')][_0x7d51('0x44')](_0x290675);})['then'](function(_0x161d3f){_0x2ff45b['rows']=_0x161d3f;return _0x2ff45b;});}})['then'](respondWithFilteredResult(_0x1aa315,_0x290675))[_0x7d51('0x46')](handleError(_0x1aa315,null));};exports[_0x7d51('0x8b')]=function(_0x73af88,_0x29a1e4,_0x45b227){var _0x579de6={'raw':!![],'where':{}};var _0x2d12b7={};var _0x4d6be5={'count':0x0,'rows':[]};return db['CmContact'][_0x7d51('0x80')]({'where':{'id':_0x73af88[_0x7d51('0x6d')]['id']}})[_0x7d51('0x20')](handleEntityNotFound(_0x29a1e4,null))[_0x7d51('0x20')](function(_0x173a12){if(_0x173a12){_0x2d12b7[_0x7d51('0x27')]=_['keys'](db[_0x7d51('0x8c')][_0x7d51('0x86')]);_0x2d12b7['query']=_['keys'](_0x73af88['query']);_0x2d12b7[_0x7d51('0x2c')]=_['intersection'](_0x2d12b7[_0x7d51('0x27')],_0x2d12b7[_0x7d51('0x29')]);_0x579de6[_0x7d51('0x2e')]=_[_0x7d51('0x2d')](_0x2d12b7[_0x7d51('0x27')],qs[_0x7d51('0x81')](_0x73af88[_0x7d51('0x29')][_0x7d51('0x81')]));_0x579de6[_0x7d51('0x2e')]=_0x579de6[_0x7d51('0x2e')][_0x7d51('0x2f')]?_0x579de6[_0x7d51('0x2e')]:_0x2d12b7[_0x7d51('0x27')];if(!_0x73af88[_0x7d51('0x29')][_0x7d51('0x30')](_0x7d51('0x31'))){_0x579de6[_0x7d51('0x1b')]=qs[_0x7d51('0x1b')](_0x73af88[_0x7d51('0x29')]['limit']);_0x579de6['offset']=qs['offset'](_0x73af88[_0x7d51('0x29')][_0x7d51('0x32')]);}_0x579de6['order']=qs['sort'](_0x73af88[_0x7d51('0x29')][_0x7d51('0x34')]);_0x579de6['where']=qs['filters'](_[_0x7d51('0x35')](_0x73af88[_0x7d51('0x29')],_0x2d12b7['filters']));_0x579de6[_0x7d51('0x39')][_0x7d51('0x89')]=_0x173a12['id'];if(_0x73af88[_0x7d51('0x29')][_0x7d51('0x3a')]){_0x579de6[_0x7d51('0x39')]=_[_0x7d51('0x38')](_0x579de6[_0x7d51('0x39')],{'$or':_[_0x7d51('0x6f')](_0x579de6['attributes'],function(_0x3658d4){var _0x3614b4={};_0x3614b4[_0x3658d4]={'$like':'%'+_0x73af88[_0x7d51('0x29')][_0x7d51('0x3a')]+'%'};return _0x3614b4;})});}_0x579de6=_[_0x7d51('0x38')]({},_0x579de6,_0x73af88['options']);return db[_0x7d51('0x8c')][_0x7d51('0x1a')]({'where':_0x579de6[_0x7d51('0x39')]})[_0x7d51('0x20')](function(_0x3618df){_0x4d6be5[_0x7d51('0x1a')]=_0x3618df;if(_0x73af88[_0x7d51('0x29')][_0x7d51('0x3f')]){_0x579de6[_0x7d51('0x40')]=[{'all':!![]}];}return db[_0x7d51('0x8c')][_0x7d51('0x44')](_0x579de6);})['then'](function(_0x4d28bc){_0x4d6be5[_0x7d51('0x45')]=_0x4d28bc;return _0x4d6be5;});}})['then'](respondWithFilteredResult(_0x29a1e4,_0x579de6))[_0x7d51('0x46')](handleError(_0x29a1e4,null));};exports[_0x7d51('0x8d')]=function(_0x3e8c12,_0x41641c,_0x3ffb74){try{if(!_0x3e8c12[_0x7d51('0x49')][_0x7d51('0x69')]){throw new Error(_0x7d51('0x8e'));}if(!_0x3e8c12[_0x7d51('0x49')]['binding_keys']){throw new Error(_0x7d51('0x8f'));}if(!_0x3e8c12['body']['binding_values']){throw new Error(_0x7d51('0x90'));}if(!_0x3e8c12[_0x7d51('0x49')]['socket_timestamp']){throw new Error(_0x7d51('0x91'));}var _0x4ba7c3=_0x3e8c12[_0x7d51('0x49')][_0x7d51('0x92')][_0x7d51('0x93')](',');var _0x4c0c81=_0x3e8c12[_0x7d51('0x49')][_0x7d51('0x94')][_0x7d51('0x93')](',');if(!_0x4ba7c3['length']||!_0x4c0c81['length']||_0x4ba7c3[_0x7d51('0x2f')]!==_0x4c0c81[_0x7d51('0x2f')]){throw new Error('Incorrect\x20binding\x20parameters\x20passed!');}_0x3e8c12[_0x7d51('0x49')][_0x7d51('0x81')]=_[_0x7d51('0x95')](_0x4ba7c3,_0x4c0c81);if(!_0x3e8c12['body'][_0x7d51('0x81')][_0x7d51('0x7e')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x3e8c12[_0x7d51('0x49')][_0x7d51('0x81')][_0x7d51('0x96')]){throw new Error(_0x7d51('0x97'));}var _0x3b2aef=path['join'](config[_0x7d51('0x98')],_0x7d51('0x99'),_0x3e8c12[_0x7d51('0x9a')][_0x7d51('0x9b')]);fs['chmodSync'](_0x3b2aef,parseInt(_0x7d51('0x9c'),0x8));var _0x1b5c97=require(_0x7d51('0x9d'))['fork'](path[_0x7d51('0x66')](__dirname,'../../components/import/cm/csv'),[_0x3b2aef,_0x3e8c12[_0x7d51('0x49')][_0x7d51('0x92')],_0x3e8c12[_0x7d51('0x49')][_0x7d51('0x94')],_0x3e8c12[_0x7d51('0x49')][_0x7d51('0x69')],_0x3e8c12[_0x7d51('0x49')][_0x7d51('0x9e')],_0x3e8c12['body'][_0x7d51('0x67')],_0x3e8c12[_0x7d51('0x49')]['socket_timestamp']]);return _0x41641c[_0x7d51('0x19')](0xc8)['json']({'message':'File\x20uploaded\x20correctly!','pid':_0x1b5c97['pid']});}catch(_0x307bfa){return _0x41641c['status'](0x1f4)['send'](_0x307bfa);}};exports['upload']=function(_0xe24736,_0x5dd495,_0x541f50){var _0x3f75eb=fs[_0x7d51('0x9f')](_0xe24736[_0x7d51('0x9a')][_0x7d51('0x7')]);Papa[_0x7d51('0xa0')](_0x3f75eb,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x3fbd9f){return _0x5dd495['status'](0xc8)[_0x7d51('0x1d')]({'file':_0xe24736[_0x7d51('0x9a')],'fields':_0x3fbd9f[_0x7d51('0xa1')][_0x7d51('0x81')]});}});};exports[_0x7d51('0xa2')]=function(_0x5a277a,_0x35a4ac,_0x237d7a){return db[_0x7d51('0xa3')][_0x7d51('0x44')]({'raw':!![],'attributes':['id'],'where':{'role':_0x7d51('0xa4')}})[_0x7d51('0x20')](function(_0x2e142a){var _0xaf8dd3=![];if(!_0x5a277a['body'][_0x7d51('0x69')]){throw new Error(_0x7d51('0x8e'));}if(!_0x5a277a[_0x7d51('0x49')][_0x7d51('0xa5')][_0x7d51('0x7e')]){throw new Error(_0x7d51('0xa6'));}if(!_0x5a277a[_0x7d51('0x49')][_0x7d51('0xa5')][_0x7d51('0x96')]){throw new Error(_0x7d51('0x97'));}if(!_0x5a277a[_0x7d51('0x49')][_0x7d51('0xa7')]){throw new Error(_0x7d51('0x91'));}var _0x44f1fd=require(_0x7d51('0x9d'))['fork'](path[_0x7d51('0x66')](__dirname,_0x7d51('0xa8')),[_0x5a277a['params']['id'],JSON[_0x7d51('0xa9')](_0x5a277a[_0x7d51('0x49')]),JSON[_0x7d51('0xa9')](_0x2e142a)]);_0x44f1fd['on'](_0x7d51('0xaa'),function(_0x382063){_0xaf8dd3=!![];return _0x35a4ac[_0x7d51('0x19')](0xc8)[_0x7d51('0x1d')]({'message':_0x7d51('0xab'),'pid':_0x44f1fd[_0x7d51('0xac')]});});_0x44f1fd['on']('exit',function(_0x1e2eca){if(_0x1e2eca&&!_0xaf8dd3){return _0x35a4ac[_0x7d51('0x19')](0x1f4)['json']({'message':'error\x20child\x20process','pid':_0x44f1fd[_0x7d51('0xac')]});}});})[_0x7d51('0x46')](handleError(_0x35a4ac,null));};