f15f42323074d26b072984678e14fe9ccecacfbb
[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 _0x5d9f=['item_types','ItemTypeId','OrderBy','contact\x20phone\x20exists','PHONE','CmHopperAdditionalPhone','item','ContactItemType','`ItemType`.OrderBy','CmHopperId','ItemType.OrderBy','bulkCreate','getAdditionalPhones','fromContactId','CmContactId','toContactId','rescheduleAdditionalPhones','hopperId','ContactId','includeAll','include','rows','getHopperFinals','options','getJscriptySessions','uploadCsv','No\x20ListId\x20specified','binding_keys','No\x20association\x20keys\x20specified!','binding_values','No\x20association\x20values\x20specified!','socket_timestamp','Unable\x20to\x20synchronize\x20socket,\x20no\x20timestamp\x20passed','split','No\x20phone\x20column\x20specified','root','server/files/tmp','file','filename','chmodSync','0777','child_process','../../components/import/cm/csv','CompanyId','pid','upload','createReadStream','parse','meta','import','binding','No\x20firstName\x20column\x20specified','fork','../../components/import/cm/csv2','stringify','message','error\x20child\x20process','importUpdates','User','agent','firstName','../../components/import/cm/csvUpdates','getJourney','mail','chat','openchannel','fax','whatsapp','voice','resolve','channel','includes','toLowerCase','Invalid\x20channel','range','isValid','Invalid\x20date\x20for\x20range\x20to\x20filter','Invalid\x20createdAt\x20filter','uniqueid','source','destination','callerid','starttime','endtime','duration','note','userSecondDisposition','userThirdDisposition','UserId','createdAt','DESC','VoiceCallReport','findAndCountAll','fullname','startCase','Website','Account','closed','disposition','secondDisposition','thirdDisposition','key','Owner','browserName','customerPort','osName','ratingMessage','ratingType','referer','subject','substatus','threadId','Interaction','flatten','sortBy','value','slice','moment','bluebird','util','path','lodash','squel','papaparse','ioredis','../../components/contacts','../../components/parsers/qs','../../config/logger','../../config/environment','../../config/environment/shared','../../mysqldb','redis','defaults','localhost','./cmContact.socket','register','status','offset','undefined','count','Content-Range','json','update','destroy','sendStatus','error','stack','name','send','describe','then','getOptions','findAll','query','user','catch','CmContact','find','params','tags','keys','length','cf_','columnName','displayName','CmCustomField','alias','custom','type','values','info','forEach','hasOwnProperty','merge','body','from','get','isArray','join','[CmContact][merge]\x20to\x20%s\x20from\x20%s','CmHopper','[CmContact][merge][destroy][CmHopper],\x20%s','create','ChatInteraction','ChatMessage','ChatOfflineMessage','MailInteraction','MailMessage','SmsMessage','FaxInteraction','OpenchannelInteraction','OpenchannelMessage','CmHopperFinal','CmHopperHistory','ReportAgentPreview','MailQueueReport','OpenchannelQueueReport','SmsQueueReport','JscriptySessionReport','WhatsappInteraction','isNil','dialTimezone','timezones','utcOffset','additionalPhones','duplicates','where','$or','push','ListId','findOrCreate','spread','contact','all','show','Tag','color','tag','CmContactHasItem','Phones','ItemType','sequelize','literal','Phones.OrderBy','omit','map','format','cf_%d','$and','pickBy','startsWith','isEmpty','setFields','id\x20=\x20?','text','phone','getTags','findOne','model','rawAttributes','filters','intersection','attributes','fields','order','sort','pick','filter','nolimit','limit','setTags','ids','items'];(function(_0x2fe5f8,_0xf1b694){var _0x4079ac=function(_0x26f1ae){while(--_0x26f1ae){_0x2fe5f8['push'](_0x2fe5f8['shift']());}};_0x4079ac(++_0xf1b694);}(_0x5d9f,0x75));var _0xf5d9=function(_0x10bb95,_0x383cb1){_0x10bb95=_0x10bb95-0x0;var _0x349991=_0x5d9f[_0x10bb95];return _0x349991;};'use strict';var moment=require(_0xf5d9('0x0'));var BPromise=require(_0xf5d9('0x1'));var util=require(_0xf5d9('0x2'));var path=require(_0xf5d9('0x3'));var fs=require('fs');var _=require(_0xf5d9('0x4'));var squel=require(_0xf5d9('0x5'));var Papa=require(_0xf5d9('0x6'));var Redis=require(_0xf5d9('0x7'));var contacts=require(_0xf5d9('0x8'));var qs=require(_0xf5d9('0x9'));var logger=require(_0xf5d9('0xa'))('api');var config=require(_0xf5d9('0xb'));var shared=require(_0xf5d9('0xc'));var db=require(_0xf5d9('0xd'))['db'];config[_0xf5d9('0xe')]=_[_0xf5d9('0xf')](config[_0xf5d9('0xe')],{'host':_0xf5d9('0x10'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));require(_0xf5d9('0x11'))[_0xf5d9('0x12')](socket);function respondWithResult(_0x48b964,_0x40b5fa){_0x40b5fa=_0x40b5fa||0xc8;return function(_0x20cf5b){if(_0x20cf5b){return _0x48b964[_0xf5d9('0x13')](_0x40b5fa)['json'](_0x20cf5b);}};}function respondWithFilteredResult(_0x58e0a3,_0x5acbe5){return function(_0x1b647e){if(_0x1b647e){var _0xf22a6e=typeof _0x5acbe5[_0xf5d9('0x14')]===_0xf5d9('0x15')&&typeof _0x5acbe5['limit']===_0xf5d9('0x15');var _0x403107=_0x1b647e[_0xf5d9('0x16')];var _0x550caf=_0xf22a6e?0x0:_0x5acbe5[_0xf5d9('0x14')];var _0x564d3f=_0xf22a6e?_0x1b647e[_0xf5d9('0x16')]:_0x5acbe5['offset']+_0x5acbe5['limit'];var _0x866153;if(_0x564d3f>=_0x403107){_0x564d3f=_0x403107;_0x866153=0xc8;}else{_0x866153=0xce;}_0x58e0a3['status'](_0x866153);return _0x58e0a3['set'](_0xf5d9('0x17'),_0x550caf+'-'+_0x564d3f+'/'+_0x403107)[_0xf5d9('0x18')](_0x1b647e);}return null;};}function saveUpdates(_0x542989){return function(_0x5bd00c){if(_0x5bd00c){return _0x5bd00c[_0xf5d9('0x19')](_0x542989)['then'](function(_0xb8a35){return _0xb8a35;});}return null;};}function removeEntity(_0x48ac1f){return function(_0x15358f){if(_0x15358f){return _0x15358f[_0xf5d9('0x1a')]()['then'](function(){_0x48ac1f[_0xf5d9('0x13')](0xcc)['end']();});}};}function handleEntityNotFound(_0x4cbc67){return function(_0x31f078){if(!_0x31f078){_0x4cbc67[_0xf5d9('0x1b')](0x194);}return _0x31f078;};}function handleError(_0x1c559f,_0x3ae69a){_0x3ae69a=_0x3ae69a||0x1f4;return function(_0x104dbf){logger[_0xf5d9('0x1c')](_0x104dbf[_0xf5d9('0x1d')]);if(_0x104dbf[_0xf5d9('0x1e')]){delete _0x104dbf[_0xf5d9('0x1e')];}_0x1c559f[_0xf5d9('0x13')](_0x3ae69a)[_0xf5d9('0x1f')](_0x104dbf);};}exports['index']=function(_0xde1bb,_0x27261d){var _0x5c8ea4={};return contacts[_0xf5d9('0x20')]()[_0xf5d9('0x21')](function(_0x256300){_0x5c8ea4=qs[_0xf5d9('0x22')](_0x256300,_0xde1bb);return contacts[_0xf5d9('0x23')](_0xde1bb[_0xf5d9('0x24')],_0xde1bb[_0xf5d9('0x25')],_0x5c8ea4,_0x256300);})[_0xf5d9('0x21')](respondWithFilteredResult(_0x27261d,_0x5c8ea4))[_0xf5d9('0x26')](handleError(_0x27261d,null));};exports[_0xf5d9('0x1a')]=function(_0x39a7cc,_0x26b404){return db[_0xf5d9('0x27')][_0xf5d9('0x28')]({'where':{'id':_0x39a7cc[_0xf5d9('0x29')]['id']}})[_0xf5d9('0x21')](handleEntityNotFound(_0x26b404,null))[_0xf5d9('0x21')](removeEntity(_0x26b404,null))[_0xf5d9('0x26')](handleError(_0x26b404,null));};exports[_0xf5d9('0x20')]=function(_0x48f33a,_0x39129b){return db[_0xf5d9('0x27')][_0xf5d9('0x20')]()[_0xf5d9('0x21')](function(_0x44304f){delete _0x44304f[_0xf5d9('0x2a')];for(var _0x5d9427=0x0;_0x5d9427<Object[_0xf5d9('0x2b')](_0x44304f)[_0xf5d9('0x2c')];_0x5d9427++){var _0x5f3f5a=Object[_0xf5d9('0x2b')](_0x44304f)[_0x5d9427];if(!_['startsWith'](_0x5f3f5a,_0xf5d9('0x2d'))){_0x44304f[_0x5f3f5a][_0xf5d9('0x2e')]=_0x5f3f5a;_0x44304f[_0x5f3f5a][_0xf5d9('0x2f')]=_0x5f3f5a;}}return _0x44304f;})[_0xf5d9('0x21')](function(_0x90aa01){var _0x474b2a={'where':Boolean(_0x48f33a['query']['analytics'])===!![]?undefined:{'$or':[{'ListId':_0x48f33a[_0xf5d9('0x24')]['id']},{'ListId':null}]},'raw':!![]};return db[_0xf5d9('0x30')][_0xf5d9('0x23')](_0x474b2a)[_0xf5d9('0x21')](function(_0x5ede2e){for(var _0x53150d=0x0;_0x53150d<_0x5ede2e[_0xf5d9('0x2c')];_0x53150d++){var _0x242aee=_0xf5d9('0x2d')+_0x5ede2e[_0x53150d]['id'];if(_0x90aa01[_0x242aee]){_0x90aa01[_0x242aee][_0xf5d9('0x2e')]=_0x242aee;_0x90aa01[_0x242aee][_0xf5d9('0x2f')]=_0x5ede2e[_0x53150d][_0xf5d9('0x31')];_0x90aa01[_0x242aee][_0xf5d9('0x32')]={'type':_0x5ede2e[_0x53150d][_0xf5d9('0x33')],'values':_0x5ede2e[_0x53150d][_0xf5d9('0x34')]};}else{logger[_0xf5d9('0x35')]('Custom\x20field\x20%s\x20not\x20found\x20on\x20cm_contacts\x20table',_0x242aee);}}Object[_0xf5d9('0x2b')](_0x90aa01)[_0xf5d9('0x36')](function(_0x303b2c){if(!_0x90aa01[_0x303b2c][_0xf5d9('0x37')](_0xf5d9('0x2e'))){delete _0x90aa01[_0x303b2c];}});return _0x90aa01;});})[_0xf5d9('0x21')](respondWithResult(_0x39129b,null))[_0xf5d9('0x26')](handleError(_0x39129b,null));};exports[_0xf5d9('0x38')]=function(_0x404898,_0x401ed3){var _0x5547d8;var _0x315626;var _0x1022de;if(_0x404898[_0xf5d9('0x39')]['id']){delete _0x404898[_0xf5d9('0x39')]['id'];}return db[_0xf5d9('0x27')][_0xf5d9('0x23')]({'where':{'id':[_0x404898['body']['to'],_0x404898['body'][_0xf5d9('0x3a')]]}})['then'](function(_0x248e19){if(_0x248e19){if(_0x248e19[_0xf5d9('0x2c')]!==0x2){return null;}_0x248e19[0x0]=_0x248e19[0x0][_0xf5d9('0x3b')]({'plain':!![]});_0x248e19[0x1]=_0x248e19[0x1][_0xf5d9('0x3b')]({'plain':!![]});delete _0x248e19[0x0]['id'];delete _0x248e19[0x1]['id'];return _['mergeWith'](_0x248e19[0x0],_0x248e19[0x1],function(_0x18c763,_0x180233){if(Array[_0xf5d9('0x3c')](_0x180233)&&!_0x180233[_0xf5d9('0x2c')]){return _0x18c763;}else if(!_0x180233){return _0x18c763;}});}})[_0xf5d9('0x21')](handleEntityNotFound(_0x401ed3,null))[_0xf5d9('0x21')](function(_0x26949f){if(_0x26949f){if(_0x26949f[_0xf5d9('0x2a')]&&_[_0xf5d9('0x3c')](_0x26949f[_0xf5d9('0x2a')])){_0x26949f['tags']=_0x26949f[_0xf5d9('0x2a')][_0xf5d9('0x3d')]();}logger[_0xf5d9('0x35')](_0xf5d9('0x3e'),_0x404898[_0xf5d9('0x39')]['to'],_0x404898['body'][_0xf5d9('0x3a')]);return db[_0xf5d9('0x3f')][_0xf5d9('0x1a')]({'where':{'ContactId':[_0x404898[_0xf5d9('0x39')]['to'],_0x404898[_0xf5d9('0x39')][_0xf5d9('0x3a')]]}})['then'](function(_0x19caba){logger[_0xf5d9('0x35')](_0xf5d9('0x40'),_0x19caba);return db['CmHopperBlack']['destroy']({'where':{'ContactId':[_0x404898[_0xf5d9('0x39')]['to'],_0x404898[_0xf5d9('0x39')][_0xf5d9('0x3a')]]}})[_0xf5d9('0x21')](function(_0x508d7a){logger['info']('[CmContact][merge][destroy][CmHopperBlack],\x20%s',_0x508d7a);return db[_0xf5d9('0x27')][_0xf5d9('0x41')](_0x26949f);});});}})[_0xf5d9('0x21')](function(_0x29ba5a){if(_0x29ba5a){_0x5547d8=_0x29ba5a;_0x315626={'ContactId':_0x5547d8['id']};_0x1022de={'where':{'ContactId':[_0x404898[_0xf5d9('0x39')]['to'],_0x404898[_0xf5d9('0x39')][_0xf5d9('0x3a')]]}};return db[_0xf5d9('0x42')][_0xf5d9('0x19')](_0x315626,_0x1022de);}})[_0xf5d9('0x21')](function(){if(_0x5547d8){return db[_0xf5d9('0x43')]['update'](_0x315626,_0x1022de);}})['then'](function(){if(_0x5547d8){return db[_0xf5d9('0x44')][_0xf5d9('0x19')](_0x315626,_0x1022de);}})['then'](function(){if(_0x5547d8){return db[_0xf5d9('0x45')][_0xf5d9('0x19')](_0x315626,_0x1022de);}})['then'](function(){if(_0x5547d8){return db['MailMessage']['update'](_0x315626,_0x1022de);}})[_0xf5d9('0x21')](function(){if(_0x5547d8){return db[_0xf5d9('0x45')][_0xf5d9('0x19')](_0x315626,_0x1022de);}})[_0xf5d9('0x21')](function(){if(_0x5547d8){return db[_0xf5d9('0x46')][_0xf5d9('0x19')](_0x315626,_0x1022de);}})[_0xf5d9('0x21')](function(){if(_0x5547d8){return db['SmsInteraction'][_0xf5d9('0x19')](_0x315626,_0x1022de);}})['then'](function(){if(_0x5547d8){return db[_0xf5d9('0x47')][_0xf5d9('0x19')](_0x315626,_0x1022de);}})['then'](function(){if(_0x5547d8){return db[_0xf5d9('0x48')][_0xf5d9('0x19')](_0x315626,_0x1022de);}})[_0xf5d9('0x21')](function(){if(_0x5547d8){return db['FaxMessage'][_0xf5d9('0x19')](_0x315626,_0x1022de);}})[_0xf5d9('0x21')](function(){if(_0x5547d8){return db[_0xf5d9('0x49')][_0xf5d9('0x19')](_0x315626,_0x1022de);}})['then'](function(){if(_0x5547d8){return db[_0xf5d9('0x4a')]['update'](_0x315626,_0x1022de);}})['then'](function(){if(_0x5547d8){return db['CmContactHasItem'][_0xf5d9('0x19')]({'CmContactId':_0x5547d8['id']},{'where':{'CmContactId':[_0x404898[_0xf5d9('0x39')]['to'],_0x404898[_0xf5d9('0x39')][_0xf5d9('0x3a')]]}});}})['then'](function(){if(_0x5547d8){return db[_0xf5d9('0x4b')][_0xf5d9('0x19')](_0x315626,_0x1022de);}})[_0xf5d9('0x21')](function(){if(_0x5547d8){return db[_0xf5d9('0x4c')][_0xf5d9('0x19')](_0x315626,_0x1022de);}})['then'](function(){if(_0x5547d8){return db[_0xf5d9('0x4d')][_0xf5d9('0x19')](_0x315626,_0x1022de);}})[_0xf5d9('0x21')](function(){if(_0x5547d8){return db['VoiceCallReport'][_0xf5d9('0x19')](_0x315626,_0x1022de);}})['then'](function(){if(_0x5547d8){return db['ChatQueueReport'][_0xf5d9('0x19')](_0x315626,_0x1022de);}})['then'](function(){if(_0x5547d8){return db['FaxQueueReport'][_0xf5d9('0x19')](_0x315626,_0x1022de);}})[_0xf5d9('0x21')](function(){if(_0x5547d8){return db[_0xf5d9('0x4e')][_0xf5d9('0x19')](_0x315626,_0x1022de);}})[_0xf5d9('0x21')](function(){if(_0x5547d8){return db[_0xf5d9('0x4f')][_0xf5d9('0x19')](_0x315626,_0x1022de);}})['then'](function(){if(_0x5547d8){return db[_0xf5d9('0x50')][_0xf5d9('0x19')](_0x315626,_0x1022de);}})[_0xf5d9('0x21')](function(){if(_0x5547d8){return db[_0xf5d9('0x51')][_0xf5d9('0x19')](_0x315626,_0x1022de);}})[_0xf5d9('0x21')](function(){if(_0x5547d8){return db[_0xf5d9('0x52')][_0xf5d9('0x19')](_0x315626,_0x1022de);}})[_0xf5d9('0x21')](function(){if(_0x5547d8){return db['WhatsappMessage'][_0xf5d9('0x19')](_0x315626,_0x1022de);}})[_0xf5d9('0x21')](function(){if(_0x5547d8){return db['WhatsappQueueReport'][_0xf5d9('0x19')](_0x315626,_0x1022de);}})['then'](function(){if(_0x5547d8){return db[_0xf5d9('0x27')]['destroy']({'where':{'id':[_0x404898[_0xf5d9('0x39')]['to'],_0x404898[_0xf5d9('0x39')]['from']]}});}})['then'](function(){if(_0x5547d8){return _0x5547d8;}})[_0xf5d9('0x21')](respondWithResult(_0x401ed3,null))[_0xf5d9('0x26')](handleError(_0x401ed3,null));};exports[_0xf5d9('0x41')]=function(_0x356970,_0x29b060){return db[_0xf5d9('0x27')]['describe']()[_0xf5d9('0x21')](function(_0x1ad40c){if(_0x356970[_0xf5d9('0x39')][_0xf5d9('0x2a')]&&_[_0xf5d9('0x3c')](_0x356970[_0xf5d9('0x39')][_0xf5d9('0x2a')])){if(_0x356970['body'][_0xf5d9('0x2a')][_0xf5d9('0x2c')]){_0x356970[_0xf5d9('0x39')][_0xf5d9('0x2a')]=_0x356970['body'][_0xf5d9('0x2a')]['join'](';')+';';}else{_0x356970[_0xf5d9('0x39')][_0xf5d9('0x2a')]=null;}}else{_0x356970[_0xf5d9('0x39')]['tags']=null;}if(!_[_0xf5d9('0x53')](_0x356970[_0xf5d9('0x39')][_0xf5d9('0x54')])){var _0x26d82e=_0x356970[_0xf5d9('0x39')][_0xf5d9('0x54')];if(!_['isNil'](shared[_0xf5d9('0x55')][_0x26d82e]))_0x356970[_0xf5d9('0x39')]['utcOffset']=shared[_0xf5d9('0x55')][_0x26d82e][_0xf5d9('0x56')];}return db[_0xf5d9('0x27')][_0xf5d9('0x41')](_0x356970[_0xf5d9('0x39')],{'fields':_[_0xf5d9('0x2b')](_0x1ad40c),'raw':!![]});})[_0xf5d9('0x21')](function(_0x2a6c34){if(_0x356970['body'][_0xf5d9('0x57')]){return insertAdditionalPhones(_0x2a6c34,_0x356970[_0xf5d9('0x39')][_0xf5d9('0x57')]);}else{return _0x2a6c34;}})['then'](respondWithResult(_0x29b060,0xc9))[_0xf5d9('0x26')](handleError(_0x29b060,null));};exports['bulkCreate']=function(_0x37bea0,_0x43f527){var _0x435c16=0x0;var _0xfd05b2=0x0;var _0x19c978=0x0;var _0xebbb94=[];return db[_0xf5d9('0x27')]['describe']()[_0xf5d9('0x21')](function(_0x1fa2c4){return BPromise['each'](_0x37bea0[_0xf5d9('0x39')],function(_0x4df041){var _0x1570cf={'where':{'$or':[]},'defaults':_0x4df041,'fields':_[_0xf5d9('0x2b')](_0x1fa2c4),'raw':!![]};if(_0x4df041[_0xf5d9('0x58')]){for(var _0x4add29=0x0;_0x4add29<_0x4df041[_0xf5d9('0x58')][_0xf5d9('0x2c')];_0x4add29++){var _0x5d1ac5={};_0x5d1ac5[_0x4df041[_0xf5d9('0x58')][_0x4add29]]=_0x4df041[_0x4df041[_0xf5d9('0x58')][_0x4add29]];_0x1570cf[_0xf5d9('0x59')][_0xf5d9('0x5a')][_0xf5d9('0x5b')](_0x5d1ac5);}_0x1570cf[_0xf5d9('0x59')][_0xf5d9('0x5c')]=_0x4df041['ListId'];}return db['CmContact'][_0xf5d9('0x5d')](_0x1570cf)[_0xf5d9('0x5e')](function(_0x523054,_0x2c90ac){if(_0x2c90ac){if(_0x4df041[_0xf5d9('0x37')](_0xf5d9('0x57'))){_0xebbb94[_0xf5d9('0x5b')]({'contact':_0x523054,'additionalPhones':_0x4df041[_0xf5d9('0x57')]});}_0x435c16++;}else{_0x19c978++;}})['catch'](function(){_0xfd05b2++;});});})[_0xf5d9('0x21')](function(_0x18cbc2){if(_0x18cbc2){if(_0xebbb94['length']>0x0){return new Promise(function(_0x2c4834){var _0x3875de=[];for(var _0x2161e3=0x0;_0x2161e3<_0xebbb94['length'];_0x2161e3++){_0x3875de['push'](insertAdditionalPhones(_0xebbb94[_0x2161e3][_0xf5d9('0x5f')],_0xebbb94[_0x2161e3]['additionalPhones']));}Promise[_0xf5d9('0x60')](_0x3875de)[_0xf5d9('0x21')](function(){_0x2c4834(0x1);});})[_0xf5d9('0x21')](function(){return{'success':_0x435c16,'failure':_0xfd05b2,'duplicates':_0x19c978};});}else{return{'success':_0x435c16,'failure':_0xfd05b2,'duplicates':_0x19c978};}}})['then'](respondWithResult(_0x43f527,0xc9))[_0xf5d9('0x26')](handleError(_0x43f527,null));};exports[_0xf5d9('0x61')]=function(_0x151bd9,_0x5bb9a7){var _0x2d1dd5;return db[_0xf5d9('0x27')][_0xf5d9('0x20')]()[_0xf5d9('0x21')](function(_0x546bfc){return db['CmContact'][_0xf5d9('0x28')]({'where':{'id':_0x151bd9[_0xf5d9('0x29')]['id']},'include':[{'model':db[_0xf5d9('0x62')],'as':'Tags','attributes':['id',_0xf5d9('0x1e'),_0xf5d9('0x63')],'required':_0x151bd9[_0xf5d9('0x24')][_0xf5d9('0x64')]?!![]:![]},{'model':db[_0xf5d9('0x65')],'as':_0xf5d9('0x66'),'where':{'CmContactId':_0x151bd9[_0xf5d9('0x29')]['id']},'required':![],'include':[{'model':db['ContactItemType'],'as':_0xf5d9('0x67')}]}],'order':[db[_0xf5d9('0x68')][_0xf5d9('0x69')](_0xf5d9('0x6a'))],'attributes':_[_0xf5d9('0x2b')](_0x546bfc)});})['then'](function(_0x5e0ef4){if(!_[_0xf5d9('0x53')](_0x5e0ef4)){_0x2d1dd5=_0x5e0ef4['get']({'plain':!![]});var _0x174298={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x5e0ef4&&_0x5e0ef4[_0xf5d9('0x5c')]){if(_0x5e0ef4[_0xf5d9('0x5c')]){_0x174298[_0xf5d9('0x59')]['$and'][_0xf5d9('0x5b')]({'ListId':{'$ne':_0x5e0ef4[_0xf5d9('0x5c')]}});}}return db[_0xf5d9('0x30')][_0xf5d9('0x23')](_0x174298);}})['then'](function(_0x5cbeca){if(!_[_0xf5d9('0x53')](_0x5cbeca)){return _[_0xf5d9('0x6b')](_0x2d1dd5,_[_0xf5d9('0x6c')](_0x5cbeca,function(_0x5de81b){return util[_0xf5d9('0x6d')](_0xf5d9('0x6e'),_0x5de81b['id']);}));}})['then'](handleEntityNotFound(_0x5bb9a7,null))['then'](respondWithResult(_0x5bb9a7,null))['catch'](handleError(_0x5bb9a7,null));};exports[_0xf5d9('0x19')]=function(_0x4bbba0,_0x4b0a3a){var _0x45a102;if(_0x4bbba0[_0xf5d9('0x39')]['id']){delete _0x4bbba0[_0xf5d9('0x39')]['id'];}if(!_['isNil'](_0x4bbba0[_0xf5d9('0x39')]['dialTimezone'])){var _0x2578d1=_0x4bbba0[_0xf5d9('0x39')][_0xf5d9('0x54')];if(!_[_0xf5d9('0x53')](shared['timezones'][_0x2578d1]))_0x4bbba0['body'][_0xf5d9('0x56')]=shared[_0xf5d9('0x55')][_0x2578d1]['utcOffset'];}return db['CmContact'][_0xf5d9('0x28')]({'where':{'id':_0x4bbba0[_0xf5d9('0x29')]['id']}})[_0xf5d9('0x21')](handleEntityNotFound(_0x4b0a3a,null))[_0xf5d9('0x21')](saveUpdates(_0x4bbba0['body'],null))[_0xf5d9('0x21')](function(_0x58116e){_0x45a102=_0x58116e;var _0x1fb995={'where':{'$and':[{'ListId':{'$ne':null}}]}};if(_0x58116e&&_0x58116e[_0xf5d9('0x5c')]){if(_0x58116e[_0xf5d9('0x5c')]){_0x1fb995[_0xf5d9('0x59')][_0xf5d9('0x6f')][_0xf5d9('0x5b')]({'ListId':{'$ne':_0x58116e[_0xf5d9('0x5c')]}});}}return db[_0xf5d9('0x30')][_0xf5d9('0x23')](_0x1fb995);})['then'](function(_0x18be9f){if(_0x18be9f){return _[_0xf5d9('0x6b')](_[_0xf5d9('0x70')](_0x4bbba0[_0xf5d9('0x39')],function(_0x5a46af,_0x18c190){return _[_0xf5d9('0x71')](_0x18c190,_0xf5d9('0x2d'));}),_[_0xf5d9('0x6c')](_0x18be9f,function(_0x491828){return util[_0xf5d9('0x6d')](_0xf5d9('0x6e'),_0x491828['id']);}));}})['then'](function(_0x4e0352){if(_0x4e0352&&!_[_0xf5d9('0x72')](_0x4e0352)){var _0x3262c4=squel[_0xf5d9('0x19')]()['table']('cm_contacts')[_0xf5d9('0x73')](_0x4e0352)['where'](_0xf5d9('0x74'),_0x4bbba0[_0xf5d9('0x29')]['id'])['toParam']();return db[_0xf5d9('0x68')]['query'](_0x3262c4[_0xf5d9('0x75')],{'replacements':_0x3262c4[_0xf5d9('0x34')]});}})[_0xf5d9('0x21')](function(){if(_0x4bbba0[_0xf5d9('0x39')][_0xf5d9('0x76')]&&_0x45a102){return db[_0xf5d9('0x3f')][_0xf5d9('0x19')]({'phone':_0x4bbba0['body'][_0xf5d9('0x76')],'OrderBy':0x0},{'where':{'ContactId':_0x45a102['id']}});}})[_0xf5d9('0x21')](function(){return _0x45a102;})[_0xf5d9('0x21')](respondWithResult(_0x4b0a3a,null))[_0xf5d9('0x26')](handleError(_0x4b0a3a,null));};exports[_0xf5d9('0x77')]=function(_0x18a95e,_0x304319){var _0x29c5a6={};var _0x4735f4={};var _0x24b602;var _0xddf490;return db[_0xf5d9('0x27')][_0xf5d9('0x78')]({'where':{'id':_0x18a95e['params']['id']}})[_0xf5d9('0x21')](handleEntityNotFound(_0x304319,null))[_0xf5d9('0x21')](function(_0x313fd1){if(_0x313fd1){_0x24b602=_0x313fd1;_0x4735f4[_0xf5d9('0x79')]=_[_0xf5d9('0x2b')](db[_0xf5d9('0x62')][_0xf5d9('0x7a')]);_0x4735f4[_0xf5d9('0x24')]=_[_0xf5d9('0x2b')](_0x18a95e[_0xf5d9('0x24')]);_0x4735f4[_0xf5d9('0x7b')]=_[_0xf5d9('0x7c')](_0x4735f4[_0xf5d9('0x79')],_0x4735f4['query']);_0x29c5a6[_0xf5d9('0x7d')]=_[_0xf5d9('0x7c')](_0x4735f4[_0xf5d9('0x79')],qs[_0xf5d9('0x7e')](_0x18a95e['query'][_0xf5d9('0x7e')]));_0x29c5a6[_0xf5d9('0x7d')]=_0x29c5a6[_0xf5d9('0x7d')][_0xf5d9('0x2c')]?_0x29c5a6[_0xf5d9('0x7d')]:_0x4735f4[_0xf5d9('0x79')];_0x29c5a6[_0xf5d9('0x7f')]=qs[_0xf5d9('0x80')](_0x18a95e[_0xf5d9('0x24')][_0xf5d9('0x80')]);_0x29c5a6['where']=qs[_0xf5d9('0x7b')](_[_0xf5d9('0x81')](_0x18a95e[_0xf5d9('0x24')],_0x4735f4['filters']));if(_0x18a95e['query'][_0xf5d9('0x82')]){_0x29c5a6[_0xf5d9('0x59')]=_['merge'](_0x29c5a6[_0xf5d9('0x59')],{'$or':_[_0xf5d9('0x6c')](_0x29c5a6[_0xf5d9('0x7d')],function(_0xc41f83){var _0x1f4ad1={};_0x1f4ad1[_0xc41f83]={'$like':'%'+_0x18a95e[_0xf5d9('0x24')][_0xf5d9('0x82')]+'%'};return _0x1f4ad1;})});}_0x29c5a6=_[_0xf5d9('0x38')]({},_0x29c5a6,_0x18a95e['options']);return _0x24b602[_0xf5d9('0x77')](_0x29c5a6);}})[_0xf5d9('0x21')](function(_0x57df84){if(_0x57df84){_0xddf490=_0x57df84['length'];if(!_0x18a95e[_0xf5d9('0x24')][_0xf5d9('0x37')](_0xf5d9('0x83'))){_0x29c5a6['limit']=qs[_0xf5d9('0x84')](_0x18a95e[_0xf5d9('0x24')]['limit']);_0x29c5a6[_0xf5d9('0x14')]=qs[_0xf5d9('0x14')](_0x18a95e[_0xf5d9('0x24')][_0xf5d9('0x14')]);}return _0x24b602[_0xf5d9('0x77')](_0x29c5a6);}})[_0xf5d9('0x21')](function(_0x3deed3){if(_0x3deed3){return _0x3deed3?{'count':_0xddf490,'rows':_0x3deed3}:null;}})[_0xf5d9('0x21')](respondWithResult(_0x304319,null))['catch'](handleError(_0x304319,null));};exports[_0xf5d9('0x85')]=function(_0xeb7f5e,_0x2b2eb9){if(_0xeb7f5e[_0xf5d9('0x39')]['id']){delete _0xeb7f5e[_0xf5d9('0x39')]['id'];}return db[_0xf5d9('0x27')][_0xf5d9('0x78')]({'where':{'id':_0xeb7f5e[_0xf5d9('0x29')]['id']}})[_0xf5d9('0x21')](handleEntityNotFound(_0x2b2eb9,null))[_0xf5d9('0x21')](function(_0xc7cc20){if(_0xc7cc20){return _0xc7cc20[_0xf5d9('0x85')](_0xeb7f5e[_0xf5d9('0x39')][_0xf5d9('0x86')]||[]);}return null;})['then'](respondWithResult(_0x2b2eb9,null))[_0xf5d9('0x26')](handleError(_0x2b2eb9,null));};exports['setAdditionalPhones']=function(_0x229683,_0x2a7a23){var _0x50c11c=[];_0x50c11c[_0xf5d9('0x5b')](addAdditionalPhones(_0x229683[_0xf5d9('0x39')]));Promise['all'](_0x50c11c)['then'](function(){_0x50c11c=[];_0x50c11c[_0xf5d9('0x5b')](deleteCmHopperPhones(_0x229683[_0xf5d9('0x39')]['id']));_0x50c11c[_0xf5d9('0x5b')](addCmHopperPhones(_0x229683[_0xf5d9('0x39')]['id']));Promise[_0xf5d9('0x60')](_0x50c11c)[_0xf5d9('0x21')](function(){return[0x1];})['then'](respondWithResult(_0x2a7a23,null));});};function addAdditionalPhones(_0x273178){var _0x26632f;return new Promise(function(_0x5450be){return db['CmContactHasItem'][_0xf5d9('0x1a')]({'where':{'CmContactId':_0x273178['id']}})[_0xf5d9('0x21')](function(){db['ContactItemType']['findAll']({'raw':!![],'attributes':['id','OrderBy']})[_0xf5d9('0x21')](function(_0x332fb5){var _0x1505da=[];for(var _0x34ac0f=0x0;_0x34ac0f<_0x273178[_0xf5d9('0x87')][_0xf5d9('0x2c')];_0x34ac0f++){var _0x3f7ac6=_0x273178[_0xf5d9('0x88')]?_[_0xf5d9('0x53')](_0x273178['item_types'][_0x34ac0f])?'':_0x273178['item_types'][_0x34ac0f]:_0x273178[_0xf5d9('0x87')][_0x34ac0f][_0xf5d9('0x89')]?_0x273178[_0xf5d9('0x87')][_0x34ac0f][_0xf5d9('0x89')]:'';var _0xd86fb7=_[_0xf5d9('0x53')](_0x273178[_0xf5d9('0x87')][_0x34ac0f]['description'])?'':_0x273178['items'][_0x34ac0f]['description'];var _0x76bc49=_0x3f7ac6+':'+_0x273178[_0xf5d9('0x87')][_0x34ac0f][_0xf5d9('0x76')]+'ยง'+_0xd86fb7;if(_[_0xf5d9('0x53')](_0x26632f))_0x26632f=_0x76bc49;else _0x26632f+=';'+_0x76bc49;var _0x479a0c=null;var _0x518563=null;if(_0x273178[_0xf5d9('0x88')]){if(!_[_0xf5d9('0x53')](_0x273178[_0xf5d9('0x88')][_0x34ac0f])){_0x518563=_[_0xf5d9('0x28')](_0x332fb5,function(_0x106f4f){return _0x106f4f['id']===_0x273178[_0xf5d9('0x88')][_0x34ac0f];});if(!_[_0xf5d9('0x53')](_0x518563)){_0x479a0c=_0x518563[_0xf5d9('0x8a')];}}}else{if(!_[_0xf5d9('0x53')](_0x273178[_0xf5d9('0x87')][_0x34ac0f])){_0x518563=_[_0xf5d9('0x28')](_0x332fb5,function(_0x181608){return _0x181608['id']===_0x273178[_0xf5d9('0x87')][_0x34ac0f][_0xf5d9('0x89')];});if(!_['isNil'](_0x518563)){_0x479a0c=_0x34ac0f;}}}if(_[_0xf5d9('0x53')](_0x479a0c)){_0x479a0c=0x64;}_0x1505da[_0xf5d9('0x5b')](addAdditionalPhone(_0x273178['id'],_0x273178['items'][_0x34ac0f]['phone'],_0x273178['item_types']?_['isNil'](_0x273178[_0xf5d9('0x88')][_0x34ac0f])?null:_0x273178[_0xf5d9('0x88')][_0x34ac0f]:_0x273178[_0xf5d9('0x87')][_0x34ac0f][_0xf5d9('0x89')]?_0x273178['items'][_0x34ac0f]['ItemTypeId']:null,_0x479a0c,_0xd86fb7));}Promise[_0xf5d9('0x60')](_0x1505da)[_0xf5d9('0x21')](function(){db[_0xf5d9('0x27')][_0xf5d9('0x19')]({'AdditionalPhones':_0x26632f},{'where':{'id':_0x273178['id']}})['then'](function(){_0x5450be(0x1);});});});});});}function addAdditionalPhone(_0x2ec8d7,_0x2aab22,_0x52bc2d,_0x3e16bd,_0x24342){return db[_0xf5d9('0x65')][_0xf5d9('0x28')]({'where':{'CmContactId':_0x2ec8d7,'item':_0x2aab22}})[_0xf5d9('0x21')](function(_0xeee179){if(_0xeee179)logger[_0xf5d9('0x35')](_0xf5d9('0x8b'),_0xeee179);else{db[_0xf5d9('0x65')][_0xf5d9('0x41')]({'CmContactId':_0x2ec8d7,'item':_0x2aab22,'ItemTypeId':_0x52bc2d,'OrderBy':_0x3e16bd,'ItemClass':_0xf5d9('0x8c'),'description':_0x24342});}});}function deleteCmHopperPhones(_0x35f2a8){return new Promise(function(_0x334627){return db[_0xf5d9('0x3f')][_0xf5d9('0x23')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x35f2a8}})['then'](function(_0x82ddaa){db[_0xf5d9('0x8d')][_0xf5d9('0x1a')]({'where':{'CmHopperId':{'$in':_[_0xf5d9('0x6c')](_0x82ddaa,'id')}}});})[_0xf5d9('0x21')](function(){_0x334627(0x1);});});}function addCmHopperPhones(_0x176734){return new Promise(function(_0x51bea9){return db[_0xf5d9('0x3f')][_0xf5d9('0x23')]({'raw':!![],'attributes':['id'],'where':{'ContactId':_0x176734}})[_0xf5d9('0x21')](function(_0x5e62ac){var _0x82a87c=[];_[_0xf5d9('0x6c')](_0x5e62ac,function(_0x98f6){_0x82a87c['push'](createCmHopperPhone(_0x176734,_0x98f6['id']));});Promise['all'](_0x82a87c)[_0xf5d9('0x21')](function(){_0x51bea9(0x1);});});});}function createCmHopperPhone(_0x4783f4,_0x5422f8){return new Promise(function(_0x1f42b9){db[_0xf5d9('0x65')][_0xf5d9('0x23')]({'raw':!![],'attributes':[_0xf5d9('0x8e'),_0xf5d9('0x8a')],'where':{'CmContactId':_0x4783f4,'ItemClass':_0xf5d9('0x8c')},'include':[{'model':db[_0xf5d9('0x8f')],'attributes':[_0xf5d9('0x8a')],'as':'ItemType'}],'order':[_0xf5d9('0x8a'),db[_0xf5d9('0x68')][_0xf5d9('0x69')](_0xf5d9('0x90'))]})[_0xf5d9('0x21')](function(_0x5e3b5c){var _0x6461f3=0x1;var _0x4e28cd=_[_0xf5d9('0x6c')](_0x5e3b5c,function(_0x13841a){_0x13841a[_0xf5d9('0x91')]=_0x5422f8;_0x13841a[_0xf5d9('0x76')]=_0x13841a[_0xf5d9('0x8e')];_0x13841a[_0xf5d9('0x8a')]=_0x6461f3;delete _0x13841a[_0xf5d9('0x92')];_0x6461f3=_0x6461f3+0x1;return _0x13841a;});return db[_0xf5d9('0x8d')][_0xf5d9('0x93')](_0x4e28cd,{});})[_0xf5d9('0x21')](function(){_0x1f42b9(0x1);});});}function insertAdditionalPhones(_0xceb2a2,_0x518640){return new Promise(function(_0x8463fd){var _0x2fb3aa=[];for(var _0x17f580=0x0;_0x17f580<_0x518640[_0xf5d9('0x2c')];_0x17f580++){var _0x2da857=_0x518640[_0x17f580];_0x2fb3aa[_0xf5d9('0x5b')](parseContactItemType(_0x2da857));}Promise[_0xf5d9('0x60')](_0x2fb3aa)[_0xf5d9('0x21')](function(){var _0xee10bc={'id':_0xceb2a2['id'],'items':_0x518640};return addAdditionalPhones(_0xee10bc)[_0xf5d9('0x21')](function(){return addCmHopperPhones(_0xceb2a2['id']);});})[_0xf5d9('0x21')](function(){_0x8463fd(_0xceb2a2);});});}function parseContactItemType(_0x48b278){return new Promise(function(_0x36ed3a){if(_0x48b278['hasOwnProperty']('ItemTypeId')){_0x36ed3a(_0x48b278);}else{return db[_0xf5d9('0x8f')][_0xf5d9('0x28')]({'where':{'name':_0x48b278[_0xf5d9('0x67')]}})[_0xf5d9('0x21')](function(_0x32ea46){if(_[_0xf5d9('0x53')](_0x32ea46))_0x48b278['ItemTypeId']=null;else _0x48b278[_0xf5d9('0x89')]=_0x32ea46['id'];_0x36ed3a(_0x48b278);});}});}exports[_0xf5d9('0x94')]=function(_0x44acc0,_0x588079){return db[_0xf5d9('0x65')]['findAll']({'raw':!![],'where':{'CmContactId':_0x44acc0[_0xf5d9('0x29')]['id'],'ItemClass':_0xf5d9('0x8c')},'include':[{'model':db[_0xf5d9('0x8f')],'as':'ItemType'}],'order':[['OrderBy'],[db[_0xf5d9('0x68')][_0xf5d9('0x69')]('`ItemType`.OrderBy')]]})[_0xf5d9('0x21')](function(_0x164958){return _0x164958;})[_0xf5d9('0x21')](respondWithResult(_0x588079,null))[_0xf5d9('0x26')](handleError(_0x588079,null));};exports['duplicateAdditionalPhones']=function(_0x3f715d,_0x40a2c1){return db[_0xf5d9('0x65')]['findAll']({'raw':!![],'where':{'CmContactId':_0x3f715d[_0xf5d9('0x39')][_0xf5d9('0x95')]}})['then'](function(_0x3ad291){var _0x43984e=_['map'](_0x3ad291,function(_0x38d32b){_0x38d32b[_0xf5d9('0x96')]=_0x3f715d[_0xf5d9('0x39')][_0xf5d9('0x97')];return _0x38d32b;});return db[_0xf5d9('0x65')][_0xf5d9('0x93')](_0x43984e,{});})[_0xf5d9('0x21')](function(){return addCmHopperPhones(_0x3f715d[_0xf5d9('0x39')][_0xf5d9('0x97')]);})['then'](function(){return['ok'];})['then'](respondWithResult(_0x40a2c1,null))[_0xf5d9('0x26')](handleError(_0x40a2c1,null));};exports[_0xf5d9('0x98')]=function(_0x1270e5,_0x4255fe){var _0x44c748=[];_0x44c748[_0xf5d9('0x5b')](createCmHopperPhone(_0x1270e5['body']['id'],_0x1270e5[_0xf5d9('0x39')][_0xf5d9('0x99')]));Promise[_0xf5d9('0x60')](_0x44c748)[_0xf5d9('0x21')](function(){return[0x1];})[_0xf5d9('0x21')](respondWithResult(_0x4255fe,null));};exports['getHoppers']=function(_0x1960b8,_0x56f6d9){var _0x2f45d5={'raw':![],'where':{}};var _0x314219={};var _0x5868dc={'count':0x0,'rows':[]};return db[_0xf5d9('0x27')][_0xf5d9('0x78')]({'where':{'id':_0x1960b8['params']['id']}})[_0xf5d9('0x21')](handleEntityNotFound(_0x56f6d9,null))[_0xf5d9('0x21')](function(_0x20248d){if(_0x20248d){_0x314219[_0xf5d9('0x79')]=_['keys'](db[_0xf5d9('0x3f')][_0xf5d9('0x7a')]);_0x314219['query']=_[_0xf5d9('0x2b')](_0x1960b8[_0xf5d9('0x24')]);_0x314219[_0xf5d9('0x7b')]=_[_0xf5d9('0x7c')](_0x314219['model'],_0x314219[_0xf5d9('0x24')]);_0x2f45d5[_0xf5d9('0x7d')]=_[_0xf5d9('0x7c')](_0x314219['model'],qs[_0xf5d9('0x7e')](_0x1960b8['query'][_0xf5d9('0x7e')]));_0x2f45d5[_0xf5d9('0x7d')]=_0x2f45d5[_0xf5d9('0x7d')][_0xf5d9('0x2c')]?_0x2f45d5[_0xf5d9('0x7d')]:_0x314219[_0xf5d9('0x79')];if(!_0x1960b8[_0xf5d9('0x24')][_0xf5d9('0x37')](_0xf5d9('0x83'))){_0x2f45d5[_0xf5d9('0x84')]=qs[_0xf5d9('0x84')](_0x1960b8[_0xf5d9('0x24')]['limit']);_0x2f45d5['offset']=qs[_0xf5d9('0x14')](_0x1960b8[_0xf5d9('0x24')][_0xf5d9('0x14')]);}_0x2f45d5[_0xf5d9('0x7f')]=qs[_0xf5d9('0x80')](_0x1960b8[_0xf5d9('0x24')][_0xf5d9('0x80')]);_0x2f45d5['where']=qs[_0xf5d9('0x7b')](_[_0xf5d9('0x81')](_0x1960b8[_0xf5d9('0x24')],_0x314219['filters']));_0x2f45d5[_0xf5d9('0x59')][_0xf5d9('0x9a')]=_0x20248d['id'];if(_0x1960b8[_0xf5d9('0x24')][_0xf5d9('0x82')]){_0x2f45d5['where']=_[_0xf5d9('0x38')](_0x2f45d5[_0xf5d9('0x59')],{'$or':_[_0xf5d9('0x6c')](_0x2f45d5[_0xf5d9('0x7d')],function(_0x2d211e){var _0x545abf={};_0x545abf[_0x2d211e]={'$like':'%'+_0x1960b8[_0xf5d9('0x24')][_0xf5d9('0x82')]+'%'};return _0x545abf;})});}_0x2f45d5=_[_0xf5d9('0x38')]({},_0x2f45d5,_0x1960b8['options']);return db[_0xf5d9('0x3f')][_0xf5d9('0x16')]({'where':_0x2f45d5['where']})['then'](function(_0x1b2463){_0x5868dc[_0xf5d9('0x16')]=_0x1b2463;if(_0x1960b8[_0xf5d9('0x24')][_0xf5d9('0x9b')]){_0x2f45d5[_0xf5d9('0x9c')]=[{'all':!![]}];}return db[_0xf5d9('0x3f')]['findAll'](_0x2f45d5);})[_0xf5d9('0x21')](function(_0x5887e9){_0x5868dc[_0xf5d9('0x9d')]=_0x5887e9;return _0x5868dc;});}})[_0xf5d9('0x21')](respondWithFilteredResult(_0x56f6d9,_0x2f45d5))[_0xf5d9('0x26')](handleError(_0x56f6d9,null));};exports['getHopperHistories']=function(_0x6f8e1e,_0x47abd6){var _0x4e4027={'raw':!![],'where':{}};var _0x358561={};var _0x2b5fc8={'count':0x0,'rows':[]};return db['CmContact'][_0xf5d9('0x78')]({'where':{'id':_0x6f8e1e['params']['id']}})[_0xf5d9('0x21')](handleEntityNotFound(_0x47abd6,null))['then'](function(_0x19ae19){if(_0x19ae19){_0x358561[_0xf5d9('0x79')]=_[_0xf5d9('0x2b')](db[_0xf5d9('0x4c')][_0xf5d9('0x7a')]);_0x358561['query']=_[_0xf5d9('0x2b')](_0x6f8e1e['query']);_0x358561[_0xf5d9('0x7b')]=_[_0xf5d9('0x7c')](_0x358561[_0xf5d9('0x79')],_0x358561['query']);_0x4e4027[_0xf5d9('0x7d')]=_[_0xf5d9('0x7c')](_0x358561[_0xf5d9('0x79')],qs[_0xf5d9('0x7e')](_0x6f8e1e[_0xf5d9('0x24')][_0xf5d9('0x7e')]));_0x4e4027[_0xf5d9('0x7d')]=_0x4e4027[_0xf5d9('0x7d')][_0xf5d9('0x2c')]?_0x4e4027[_0xf5d9('0x7d')]:_0x358561[_0xf5d9('0x79')];if(!_0x6f8e1e[_0xf5d9('0x24')][_0xf5d9('0x37')](_0xf5d9('0x83'))){_0x4e4027[_0xf5d9('0x84')]=qs[_0xf5d9('0x84')](_0x6f8e1e[_0xf5d9('0x24')][_0xf5d9('0x84')]);_0x4e4027[_0xf5d9('0x14')]=qs['offset'](_0x6f8e1e[_0xf5d9('0x24')][_0xf5d9('0x14')]);}_0x4e4027[_0xf5d9('0x7f')]=qs[_0xf5d9('0x80')](_0x6f8e1e[_0xf5d9('0x24')][_0xf5d9('0x80')]);_0x4e4027['where']=qs['filters'](_['pick'](_0x6f8e1e[_0xf5d9('0x24')],_0x358561[_0xf5d9('0x7b')]));_0x4e4027[_0xf5d9('0x59')][_0xf5d9('0x9a')]=_0x19ae19['id'];if(_0x6f8e1e[_0xf5d9('0x24')][_0xf5d9('0x82')]){_0x4e4027[_0xf5d9('0x59')]=_['merge'](_0x4e4027[_0xf5d9('0x59')],{'$or':_[_0xf5d9('0x6c')](_0x4e4027[_0xf5d9('0x7d')],function(_0x3033a4){var _0x1c28cd={};_0x1c28cd[_0x3033a4]={'$like':'%'+_0x6f8e1e[_0xf5d9('0x24')][_0xf5d9('0x82')]+'%'};return _0x1c28cd;})});}_0x4e4027=_[_0xf5d9('0x38')]({},_0x4e4027,_0x6f8e1e['options']);return db[_0xf5d9('0x4c')][_0xf5d9('0x16')]({'where':_0x4e4027[_0xf5d9('0x59')]})['then'](function(_0x2f6658){_0x2b5fc8[_0xf5d9('0x16')]=_0x2f6658;if(_0x6f8e1e[_0xf5d9('0x24')]['includeAll']){_0x4e4027[_0xf5d9('0x9c')]=[{'all':!![]}];}return db[_0xf5d9('0x4c')]['findAll'](_0x4e4027);})[_0xf5d9('0x21')](function(_0x37dd24){_0x2b5fc8[_0xf5d9('0x9d')]=_0x37dd24;return _0x2b5fc8;});}})[_0xf5d9('0x21')](respondWithFilteredResult(_0x47abd6,_0x4e4027))[_0xf5d9('0x26')](handleError(_0x47abd6,null));};exports[_0xf5d9('0x9e')]=function(_0x55c9e3,_0x3af08c){var _0x56d37a={'raw':!![],'where':{}};var _0x28000d={};var _0x4d8421={'count':0x0,'rows':[]};return db[_0xf5d9('0x27')]['findOne']({'where':{'id':_0x55c9e3[_0xf5d9('0x29')]['id']}})[_0xf5d9('0x21')](handleEntityNotFound(_0x3af08c,null))['then'](function(_0x553858){if(_0x553858){_0x28000d[_0xf5d9('0x79')]=_[_0xf5d9('0x2b')](db['CmHopperFinal'][_0xf5d9('0x7a')]);_0x28000d[_0xf5d9('0x24')]=_[_0xf5d9('0x2b')](_0x55c9e3[_0xf5d9('0x24')]);_0x28000d[_0xf5d9('0x7b')]=_[_0xf5d9('0x7c')](_0x28000d[_0xf5d9('0x79')],_0x28000d['query']);_0x56d37a['attributes']=_[_0xf5d9('0x7c')](_0x28000d['model'],qs[_0xf5d9('0x7e')](_0x55c9e3[_0xf5d9('0x24')]['fields']));_0x56d37a[_0xf5d9('0x7d')]=_0x56d37a[_0xf5d9('0x7d')][_0xf5d9('0x2c')]?_0x56d37a[_0xf5d9('0x7d')]:_0x28000d[_0xf5d9('0x79')];if(!_0x55c9e3['query'][_0xf5d9('0x37')](_0xf5d9('0x83'))){_0x56d37a[_0xf5d9('0x84')]=qs['limit'](_0x55c9e3[_0xf5d9('0x24')]['limit']);_0x56d37a[_0xf5d9('0x14')]=qs[_0xf5d9('0x14')](_0x55c9e3[_0xf5d9('0x24')][_0xf5d9('0x14')]);}_0x56d37a[_0xf5d9('0x7f')]=qs[_0xf5d9('0x80')](_0x55c9e3[_0xf5d9('0x24')][_0xf5d9('0x80')]);_0x56d37a[_0xf5d9('0x59')]=qs[_0xf5d9('0x7b')](_[_0xf5d9('0x81')](_0x55c9e3['query'],_0x28000d[_0xf5d9('0x7b')]));_0x56d37a[_0xf5d9('0x59')][_0xf5d9('0x9a')]=_0x553858['id'];if(_0x55c9e3[_0xf5d9('0x24')]['filter']){_0x56d37a[_0xf5d9('0x59')]=_[_0xf5d9('0x38')](_0x56d37a[_0xf5d9('0x59')],{'$or':_[_0xf5d9('0x6c')](_0x56d37a[_0xf5d9('0x7d')],function(_0x11c0c0){var _0x3960b7={};_0x3960b7[_0x11c0c0]={'$like':'%'+_0x55c9e3['query'][_0xf5d9('0x82')]+'%'};return _0x3960b7;})});}_0x56d37a=_['merge']({},_0x56d37a,_0x55c9e3[_0xf5d9('0x9f')]);return db[_0xf5d9('0x4b')]['count']({'where':_0x56d37a['where']})[_0xf5d9('0x21')](function(_0x44c935){_0x4d8421[_0xf5d9('0x16')]=_0x44c935;if(_0x55c9e3[_0xf5d9('0x24')][_0xf5d9('0x9b')]){_0x56d37a[_0xf5d9('0x9c')]=[{'all':!![]}];}return db['CmHopperFinal'][_0xf5d9('0x23')](_0x56d37a);})[_0xf5d9('0x21')](function(_0x3624ce){_0x4d8421[_0xf5d9('0x9d')]=_0x3624ce;return _0x4d8421;});}})['then'](respondWithFilteredResult(_0x3af08c,_0x56d37a))['catch'](handleError(_0x3af08c,null));};exports[_0xf5d9('0xa0')]=function(_0x224818,_0x108dc3){var _0x262db8={'raw':!![],'where':{}};var _0x1370b1={};var _0x2b76de={'count':0x0,'rows':[]};return db[_0xf5d9('0x27')][_0xf5d9('0x78')]({'where':{'id':_0x224818['params']['id']}})['then'](handleEntityNotFound(_0x108dc3,null))[_0xf5d9('0x21')](function(_0xaa2b2c){if(_0xaa2b2c){_0x1370b1['model']=_[_0xf5d9('0x2b')](db[_0xf5d9('0x51')]['rawAttributes']);_0x1370b1['query']=_[_0xf5d9('0x2b')](_0x224818[_0xf5d9('0x24')]);_0x1370b1[_0xf5d9('0x7b')]=_[_0xf5d9('0x7c')](_0x1370b1['model'],_0x1370b1[_0xf5d9('0x24')]);_0x262db8[_0xf5d9('0x7d')]=_[_0xf5d9('0x7c')](_0x1370b1[_0xf5d9('0x79')],qs['fields'](_0x224818[_0xf5d9('0x24')]['fields']));_0x262db8[_0xf5d9('0x7d')]=_0x262db8[_0xf5d9('0x7d')][_0xf5d9('0x2c')]?_0x262db8[_0xf5d9('0x7d')]:_0x1370b1[_0xf5d9('0x79')];if(!_0x224818['query'][_0xf5d9('0x37')](_0xf5d9('0x83'))){_0x262db8[_0xf5d9('0x84')]=qs['limit'](_0x224818[_0xf5d9('0x24')]['limit']);_0x262db8['offset']=qs[_0xf5d9('0x14')](_0x224818[_0xf5d9('0x24')]['offset']);}_0x262db8[_0xf5d9('0x7f')]=qs[_0xf5d9('0x80')](_0x224818[_0xf5d9('0x24')][_0xf5d9('0x80')]);_0x262db8['where']=qs['filters'](_[_0xf5d9('0x81')](_0x224818[_0xf5d9('0x24')],_0x1370b1[_0xf5d9('0x7b')]));_0x262db8[_0xf5d9('0x59')][_0xf5d9('0x9a')]=_0xaa2b2c['id'];if(_0x224818[_0xf5d9('0x24')][_0xf5d9('0x82')]){_0x262db8['where']=_[_0xf5d9('0x38')](_0x262db8[_0xf5d9('0x59')],{'$or':_['map'](_0x262db8[_0xf5d9('0x7d')],function(_0x6d2e8e){var _0x4fe142={};_0x4fe142[_0x6d2e8e]={'$like':'%'+_0x224818['query'][_0xf5d9('0x82')]+'%'};return _0x4fe142;})});}_0x262db8=_[_0xf5d9('0x38')]({},_0x262db8,_0x224818[_0xf5d9('0x9f')]);return db[_0xf5d9('0x51')]['count']({'where':_0x262db8[_0xf5d9('0x59')]})[_0xf5d9('0x21')](function(_0x5a218){_0x2b76de['count']=_0x5a218;if(_0x224818[_0xf5d9('0x24')][_0xf5d9('0x9b')]){_0x262db8[_0xf5d9('0x9c')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0xf5d9('0x23')](_0x262db8);})[_0xf5d9('0x21')](function(_0x41557c){_0x2b76de[_0xf5d9('0x9d')]=_0x41557c;return _0x2b76de;});}})[_0xf5d9('0x21')](respondWithFilteredResult(_0x108dc3,_0x262db8))[_0xf5d9('0x26')](handleError(_0x108dc3,null));};exports[_0xf5d9('0xa1')]=function(_0x277739,_0x17b784){try{if(!_0x277739[_0xf5d9('0x39')][_0xf5d9('0x5c')]){throw new Error(_0xf5d9('0xa2'));}if(!_0x277739['body'][_0xf5d9('0xa3')]){throw new Error(_0xf5d9('0xa4'));}if(!_0x277739[_0xf5d9('0x39')][_0xf5d9('0xa5')]){throw new Error(_0xf5d9('0xa6'));}if(!_0x277739['body'][_0xf5d9('0xa7')]){throw new Error(_0xf5d9('0xa8'));}var _0x34f594=_0x277739[_0xf5d9('0x39')][_0xf5d9('0xa3')][_0xf5d9('0xa9')](',');var _0x32fbcd=_0x277739[_0xf5d9('0x39')][_0xf5d9('0xa5')][_0xf5d9('0xa9')](',');if(!_0x34f594[_0xf5d9('0x2c')]||!_0x32fbcd['length']||_0x34f594['length']!==_0x32fbcd[_0xf5d9('0x2c')]){throw new Error('Incorrect\x20binding\x20parameters\x20passed!');}_0x277739['body'][_0xf5d9('0x7e')]=_['zipObject'](_0x34f594,_0x32fbcd);if(!_0x277739['body']['fields'][_0xf5d9('0x76')]){throw new Error(_0xf5d9('0xaa'));}if(!_0x277739[_0xf5d9('0x39')][_0xf5d9('0x7e')]['firstName']){throw new Error('No\x20firstName\x20column\x20specified');}var _0x2b33cc=path[_0xf5d9('0x3d')](config[_0xf5d9('0xab')],_0xf5d9('0xac'),_0x277739[_0xf5d9('0xad')][_0xf5d9('0xae')]);fs[_0xf5d9('0xaf')](_0x2b33cc,parseInt(_0xf5d9('0xb0'),0x8));var _0x4e7b96=require(_0xf5d9('0xb1'))['fork'](path[_0xf5d9('0x3d')](__dirname,_0xf5d9('0xb2')),[_0x2b33cc,_0x277739[_0xf5d9('0x39')]['binding_keys'],_0x277739['body'][_0xf5d9('0xa5')],_0x277739[_0xf5d9('0x39')][_0xf5d9('0x5c')],_0x277739[_0xf5d9('0x39')][_0xf5d9('0xb3')],_0x277739[_0xf5d9('0x39')]['duplicates'],_0x277739[_0xf5d9('0x39')]['socket_timestamp']]);return _0x17b784['status'](0xc8)[_0xf5d9('0x18')]({'message':'File\x20uploaded\x20correctly!','pid':_0x4e7b96[_0xf5d9('0xb4')]});}catch(_0x174b34){return _0x17b784[_0xf5d9('0x13')](0x1f4)[_0xf5d9('0x1f')](_0x174b34);}};exports[_0xf5d9('0xb5')]=function(_0x55dea5,_0xcc2b1d){var _0x3e35a2=fs[_0xf5d9('0xb6')](_0x55dea5[_0xf5d9('0xad')]['path']);Papa[_0xf5d9('0xb7')](_0x3e35a2,{'header':!![],'skipEmptyLines':!![],'preview':0x1,'complete':function(_0x444d4b){return _0xcc2b1d[_0xf5d9('0x13')](0xc8)[_0xf5d9('0x18')]({'file':_0x55dea5[_0xf5d9('0xad')],'fields':_0x444d4b[_0xf5d9('0xb8')]['fields']});}});};exports[_0xf5d9('0xb9')]=function(_0x37780f,_0x140488){return db['User']['findAll']({'raw':!![],'attributes':['id'],'where':{'role':'agent'}})[_0xf5d9('0x21')](function(_0x151ccf){var _0x2af3d4=![];if(!_0x37780f[_0xf5d9('0x39')][_0xf5d9('0x5c')]){throw new Error(_0xf5d9('0xa2'));}if(!_0x37780f[_0xf5d9('0x39')][_0xf5d9('0xba')][_0xf5d9('0x76')]){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x37780f[_0xf5d9('0x39')][_0xf5d9('0xba')]['firstName']){throw new Error(_0xf5d9('0xbb'));}if(!_0x37780f[_0xf5d9('0x39')][_0xf5d9('0xa7')]){throw new Error(_0xf5d9('0xa8'));}var _0x5ba4cc=require(_0xf5d9('0xb1'))[_0xf5d9('0xbc')](path['join'](__dirname,_0xf5d9('0xbd')),[_0x37780f[_0xf5d9('0x29')]['id'],JSON[_0xf5d9('0xbe')](_0x37780f[_0xf5d9('0x39')]),JSON[_0xf5d9('0xbe')](_0x151ccf)]);_0x5ba4cc['on'](_0xf5d9('0xbf'),function(){_0x2af3d4=!![];return _0x140488[_0xf5d9('0x13')](0xc8)[_0xf5d9('0x18')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x5ba4cc['pid']});});_0x5ba4cc['on']('exit',function(_0x1e28f7){if(_0x1e28f7&&!_0x2af3d4){return _0x140488[_0xf5d9('0x13')](0x1f4)[_0xf5d9('0x18')]({'message':_0xf5d9('0xc0'),'pid':_0x5ba4cc['pid']});}});})[_0xf5d9('0x26')](handleError(_0x140488,null));};exports[_0xf5d9('0xc1')]=function(_0x25bfb7,_0x53ff2e){return db[_0xf5d9('0xc2')][_0xf5d9('0x23')]({'raw':!![],'attributes':['id'],'where':{'role':_0xf5d9('0xc3')}})[_0xf5d9('0x21')](function(_0x53a79d){var _0xdae4f6=![];if(!_0x25bfb7[_0xf5d9('0x39')][_0xf5d9('0x5c')]){throw new Error('No\x20ListId\x20specified');}if(!_0x25bfb7['body']['binding']['phone']){throw new Error('No\x20phone\x20column\x20specified');}if(!_0x25bfb7['body']['binding'][_0xf5d9('0xc4')]){throw new Error(_0xf5d9('0xbb'));}if(!_0x25bfb7['body'][_0xf5d9('0xa7')]){throw new Error(_0xf5d9('0xa8'));}var _0x2e844b=require('child_process')[_0xf5d9('0xbc')](path[_0xf5d9('0x3d')](__dirname,_0xf5d9('0xc5')),[_0x25bfb7[_0xf5d9('0x29')]['id'],JSON[_0xf5d9('0xbe')](_0x25bfb7[_0xf5d9('0x39')]),JSON[_0xf5d9('0xbe')](_0x53a79d)]);_0x2e844b['on']('message',function(){_0xdae4f6=!![];return _0x53ff2e[_0xf5d9('0x13')](0xc8)[_0xf5d9('0x18')]({'message':'start\x20child\x20process\x20correctly!','pid':_0x2e844b[_0xf5d9('0xb4')]});});_0x2e844b['on']('exit',function(_0x232d3b){if(_0x232d3b&&!_0xdae4f6){return _0x53ff2e['status'](0x1f4)[_0xf5d9('0x18')]({'message':'error\x20child\x20process','pid':_0x2e844b[_0xf5d9('0xb4')]});}});})['catch'](handleError(_0x53ff2e,null));};exports[_0xf5d9('0xc6')]=function(_0x5e4241,_0x1a2929){var _0x2e9c07=[_0xf5d9('0xc7'),_0xf5d9('0xc8'),'sms',_0xf5d9('0xc9'),_0xf5d9('0xca'),_0xf5d9('0xcb'),_0xf5d9('0xcc')];var _0x52ae38={'offset':0x0,'order':qs[_0xf5d9('0x80')]('-createdAt')},_0x10aca4={'count':0x0,'rows':[]};Promise[_0xf5d9('0xcd')]()[_0xf5d9('0x21')](function(){if(_0x5e4241['query'][_0xf5d9('0xce')]){if(!_[_0xf5d9('0xcf')](_0x2e9c07,_0x5e4241['query'][_0xf5d9('0xce')][_0xf5d9('0xd0')]())){throw new Error(_0xf5d9('0xd1'));}_0x2e9c07=[_0x5e4241[_0xf5d9('0x24')][_0xf5d9('0xce')][_0xf5d9('0xd0')]()];}if(_0x5e4241[_0xf5d9('0x24')][_0xf5d9('0xd2')]){try{var _0xc5872a=JSON['parse'](_0x5e4241[_0xf5d9('0x24')][_0xf5d9('0xd2')]);if(!moment(_0xc5872a[_0xf5d9('0x3a')])[_0xf5d9('0xd3')]()){throw new Error('Invalid\x20date\x20for\x20range\x20from\x20filter');}if(!moment(_0xc5872a['to'])[_0xf5d9('0xd3')]()){throw new Error(_0xf5d9('0xd4'));}}catch(_0x2b9fe1){throw new Error(_0xf5d9('0xd5'));}}if(!_0x5e4241[_0xf5d9('0x24')][_0xf5d9('0x37')](_0xf5d9('0x83'))){_0x52ae38['limit']=qs['limit'](_0x5e4241[_0xf5d9('0x24')][_0xf5d9('0x84')]||0xa);_0x52ae38[_0xf5d9('0x14')]=qs[_0xf5d9('0x14')](_0x5e4241['query'][_0xf5d9('0x14')]);}var _0x698932=_0x2e9c07[_0xf5d9('0x6c')](function(_0xf9f28b){if(_0xf9f28b===_0xf5d9('0xcc')){var _0x343d58={'attributes':['id',_0xf5d9('0xd6'),_0xf5d9('0x33'),_0xf5d9('0xd7'),_0xf5d9('0xd8'),_0xf5d9('0xd9'),_0xf5d9('0xda'),_0xf5d9('0xdb'),_0xf5d9('0xdc'),_0xf5d9('0xdd'),'createdAt','userDisposition',_0xf5d9('0xde'),_0xf5d9('0xdf'),_0xf5d9('0xe0')],'where':{'ContactId':_0x5e4241['params']['id']},'include':[{'model':db[_0xf5d9('0xc2')],'as':_0xf5d9('0xc2'),'attributes':['id','name','fullname',_0xf5d9('0x31')]}],'order':[[_0xf5d9('0xe1'),_0xf5d9('0xe2')]]};if(_0x5e4241[_0xf5d9('0x24')][_0xf5d9('0xd2')]){_0x343d58['where'][_0xf5d9('0xe1')]={'$gte':_0xc5872a[_0xf5d9('0x3a')],'$lte':_0xc5872a['to']};}return db[_0xf5d9('0xe3')][_0xf5d9('0xe4')](_0x343d58)['then'](function(_0x488b0e){_0x10aca4['count']+=_0x488b0e[_0xf5d9('0x16')];return _[_0xf5d9('0x6c')](_0x488b0e[_0xf5d9('0x9d')],function(_0x5e4027){var _0x3f582d=_0x5e4027[_0xf5d9('0x3b')]({'plain':!![]});_0x3f582d[_0xf5d9('0xce')]=_0xf9f28b;if(_0x3f582d[_0xf5d9('0xc2')]){_0x3f582d[_0xf5d9('0xc2')]={'id':_0x3f582d[_0xf5d9('0xc2')]['id'],'name':_0x3f582d[_0xf5d9('0xc2')][_0xf5d9('0x1e')],'fullname':_0x3f582d[_0xf5d9('0xc2')][_0xf5d9('0xe5')],'alias':_0x3f582d[_0xf5d9('0xc2')][_0xf5d9('0x31')]};}return _0x3f582d;});});}else{var _0x1ff75a=_[_0xf5d9('0xe6')](_0xf9f28b)+(_0xf9f28b===_0xf5d9('0xc8')?_0xf5d9('0xe7'):_0xf5d9('0xe8'));var _0x5427d7={'attributes':['id',_0xf5d9('0xe9'),'closedAt',_0xf5d9('0xe1'),_0xf5d9('0xdd'),_0xf5d9('0xea'),_0xf5d9('0xeb'),_0xf5d9('0xec'),_0xf5d9('0xe0'),_0x1ff75a+'Id'],'where':{'ContactId':_0x5e4241[_0xf5d9('0x29')]['id']},'include':[{'model':db[_0x1ff75a],'as':'Account','attributes':['id',_0xf5d9('0x1e'),_0xf5d9('0xed')]},{'model':db[_0xf5d9('0xc2')],'as':_0xf5d9('0xee'),'attributes':['id',_0xf5d9('0x1e'),_0xf5d9('0xe5')]},{'model':db['Tag'],'as':'Tags','attributes':['id',_0xf5d9('0x1e'),_0xf5d9('0x63')],'through':{'attributes':[]}}],'order':[['createdAt',_0xf5d9('0xe2')]]};if(_0x5e4241['query']['range']){_0x5427d7['where'][_0xf5d9('0xe1')]={'$gte':_0xc5872a[_0xf5d9('0x3a')],'$lte':_0xc5872a['to']};}switch(_0xf9f28b){case _0xf5d9('0xc8'):_0x5427d7[_0xf5d9('0x7d')][_0xf5d9('0x5b')](_0xf5d9('0xef'),'customerIp',_0xf5d9('0xf0'),'deviceModel',_0xf5d9('0xf1'),_0xf5d9('0xf2'),_0xf5d9('0xf3'),'ratingValue',_0xf5d9('0xf4'));break;case'mail':_0x5427d7[_0xf5d9('0x7d')][_0xf5d9('0x5b')](_0xf5d9('0xf5'),_0xf5d9('0xf6'));break;case'openchannel':_0x5427d7[_0xf5d9('0x7d')][_0xf5d9('0x5b')]('externalUrl',_0xf5d9('0xf7'));break;}return db[_[_0xf5d9('0xe6')](_0xf9f28b)+_0xf5d9('0xf8')][_0xf5d9('0xe4')](_0x5427d7)['then'](function(_0x140d6c){_0x10aca4[_0xf5d9('0x16')]+=_0x140d6c[_0xf5d9('0x16')];return _[_0xf5d9('0x6c')](_0x140d6c[_0xf5d9('0x9d')],function(_0x4aba03){var _0x4104e0=_0x4aba03[_0xf5d9('0x3b')]({'plain':!![]});_0x4104e0['channel']=_0xf9f28b;if(_0x4104e0['Owner']){_0x4104e0[_0xf5d9('0xee')]={'id':_0x4104e0[_0xf5d9('0xee')]['id'],'name':_0x4104e0[_0xf5d9('0xee')][_0xf5d9('0x1e')],'fullname':_0x4104e0['Owner'][_0xf5d9('0xe5')]};}return _0x4104e0;});});}});return Promise[_0xf5d9('0x60')](_0x698932);})[_0xf5d9('0x21')](function(_0x1d8004){return _(_0x1d8004)[_0xf5d9('0xf9')]()[_0xf5d9('0xfa')]('createdAt')['reverse']()[_0xf5d9('0xfb')]();})[_0xf5d9('0x21')](function(_0x15d1cd){_0x10aca4[_0xf5d9('0x9d')]=_0x52ae38[_0xf5d9('0x84')]?_0x15d1cd[_0xf5d9('0xfc')](_0x52ae38[_0xf5d9('0x14')],_0x52ae38['offset']+_0x52ae38[_0xf5d9('0x84')]):_0x15d1cd;return _0x10aca4;})['then'](respondWithFilteredResult(_0x1a2929,_0x52ae38))[_0xf5d9('0x26')](handleError(_0x1a2929,null));};