Built motion from commit 3c2ce842.|2.6.31
[motion2.git] / server / api / userProfile / userProfile.model.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 _0x0923=['length','push','UserProfileSection','find','params','all','ignore','union','autoAssociation','rawAttributes','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','limit','offset','sort','where','pick','merge','key','VIRTUAL','foreignKey','forEach','options','includeAll','include','reportType','DefaultReports','CustomReports','rows','ids','customSorting','order','extraQueryConditions','count','Tags','tag','ThroughTags','color','openTabs','true','chat','dataValues','fax','mail','lodash','./userProfile.attributes','squel','exports','models','filter','findAll','map','field','value','model','then','UserProfileResource','associatedResources','AnalyticExtractedReport','resourceId','type','toLowerCase','squareprojects','odbc','childModel','SquareOdbc','squarerecordings','SquareRecording','parentSections','SquareProjects','name','projectName','JscriptyProject','contacts','CmContact','ListId','lists','CmList','companies','globalcustomfields','CmCustomField','faxqueues','FaxQueue','faxaccounts','inboundroutes','internalroutes','outboundroutes','VoiceExtension','contexts','voicemails','VoiceMail','voicerecordings','VoiceRecording','Agents','User','agent','role','telephone','queue','outbound','musiconholds','VoiceChanSpy','voiceprefixes','VoicePrefix','ivrcampaigns','Campaign','MailQueue','mailaccounts','MailSubstatus','openchannelqueues','openchannelaccounts','OpenchannelAccount','smsaccounts','SmsAccount','whatsappqueues','WhatsappQueue','whatsappaccounts','WhatsappAccount','Team','voicequeues','VoiceQueue','QueueCampaigns','agents','Users','admin','user','Telephones','salesforceaccounts','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','SugarcrmAccount','deskaccounts','DeskAccount','ZohoAccount','vtigeraccounts','cannedanswers','CannedAnswer','dispositions','Disposition','customdashboards','Dashboard','Interval','pauses','Pause','scheduler','Schedule','Sound','tags','Tag','Template','triggers','Trigger','trunks','Trunk','variables','Variable','plugins','extractedreports','Reports','reportId','metrics','AnalyticMetric','Sequelize','QueryTypes','SELECT','select','ui.','InteractionId','ui.createdAt','from','user_has_','_interactions','ui.UserId\x20=\x20?','sequelize','UserProfile','user_profiles','../../components/parsers/qs','query','raw','section','mergeResources','Invalid\x20section\x20\x27','isEmpty'];(function(_0x3a9203,_0x12bf8e){var _0x4498f4=function(_0x415cab){while(--_0x415cab){_0x3a9203['push'](_0x3a9203['shift']());}};_0x4498f4(++_0x12bf8e);}(_0x0923,0x1ab));var _0x3092=function(_0x45a8da,_0x4f2bf7){_0x45a8da=_0x45a8da-0x0;var _0x7c91a7=_0x0923[_0x45a8da];return _0x7c91a7;};'use strict';var _=require(_0x3092('0x0'));var attributes=require(_0x3092('0x1'));var squel=require(_0x3092('0x2'));module[_0x3092('0x3')]=function(_0x5b7779){var _0x44a165=_0x5b7779[_0x3092('0x4')];function _0x3ebddc(_0x538a04,_0x1bfa71){return new Promise(function(_0x330ef4,_0x595d5d){if(!_0x1bfa71)return _0x330ef4(null);var _0x3ef334=_0x1bfa71[_0x3092('0x5')]?{[_0x1bfa71[_0x3092('0x5')]['field']]:_0x1bfa71[_0x3092('0x5')]['value']}:undefined;return _0x44a165[_0x538a04][_0x3092('0x6')]({'where':_0x3ef334,'raw':!![]})['then'](function(_0x123b17){_0x1bfa71['associatedResources']=_[_0x3092('0x7')](_0x123b17,'id');_0x330ef4(_0x1bfa71);})['catch'](function(_0x426be6){_0x595d5d(_0x426be6);});});}function _0x5d4565(_0x1eeec9,_0x5b20ea){return new Promise(function(_0xba11fa,_0x467188){var _0x207fd7=_0x1eeec9[_0x3092('0x5')]?{[_0x1eeec9[_0x3092('0x5')][_0x3092('0x8')]]:_0x1eeec9['filter'][_0x3092('0x9')]}:undefined;return _0x44a165[_0x1eeec9[_0x3092('0xa')]][_0x3092('0x6')]({'where':_0x207fd7,'raw':!![]})[_0x3092('0xb')](function(_0x1378b5){_0x5b20ea['associatedResources']=_['map'](_0x1378b5,function(_0x465259){return _0x465259['name'];});_0xba11fa(_0x5b20ea);})['catch'](function(_0x3052f6){_0x467188(_0x3052f6);});});}function _0x24a511(_0xc5d16e,_0x30a6e3,_0x48e529){if(!_0x30a6e3)return Promise['resolve'](null);return new Promise(function(_0x3c0697,_0x2fdf9a){return _0x44a165[_0x3092('0xc')][_0x3092('0x6')]({'where':{'sectionId':_0x30a6e3['id']},'raw':!![]})[_0x3092('0xb')](function(_0x132f09){if(_0xc5d16e[_0x3092('0x8')]&&_0xc5d16e[_0x3092('0x8')]!=='id'){_0x30a6e3[_0x3092('0xd')]=_[_0x3092('0x7')](_0x132f09,function(_0x4bad76){return _0x4bad76[_0xc5d16e[_0x3092('0x8')]];});}else{if(_0x48e529===_0x3092('0xe')){_0x30a6e3['associatedResources']=_[_0x3092('0x7')](_0x132f09,function(_0x2bfe7d){return{'id':_0x2bfe7d[_0x3092('0xf')],'type':_0x2bfe7d[_0x3092('0x10')]};});}else{_0x30a6e3[_0x3092('0xd')]=_['map'](_0x132f09,function(_0x106c67){return _0x106c67[_0x3092('0xf')];});}}_0x3c0697(_0x30a6e3);})['catch'](function(_0x3a1eab){_0x2fdf9a(_0x3a1eab);});});}function _0x1bf399(_0x3b0039,_0x1c1116){var _0xa5f581={'parentSections':[]};switch(_0x3b0039[_0x3092('0x11')]()){case _0x3092('0x12'):_0xa5f581['childModel']='SquareProject';break;case _0x3092('0x13'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x15');break;case _0x3092('0x16'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x17');_0xa5f581[_0x3092('0x18')]=[{'name':_0x3092('0x19'),'field':_0x3092('0x1a'),'foreignKey':_0x3092('0x1b')}];break;case'projects':_0xa5f581[_0x3092('0x14')]=_0x3092('0x1c');break;case _0x3092('0x1d'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x1e');_0xa5f581[_0x3092('0x18')]=[{'name':'Lists','field':'id','foreignKey':_0x3092('0x1f')}];break;case _0x3092('0x20'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x21');break;case _0x3092('0x22'):_0xa5f581[_0x3092('0x14')]='CmCompany';break;case _0x3092('0x23'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x24');break;case'chatqueues':_0xa5f581[_0x3092('0x14')]='ChatQueue';break;case'chatwebsites':_0xa5f581[_0x3092('0x14')]='ChatWebsite';break;case _0x3092('0x25'):_0xa5f581['childModel']=_0x3092('0x26');break;case _0x3092('0x27'):_0xa5f581['childModel']='FaxAccount';break;case _0x3092('0x28'):case _0x3092('0x29'):case _0x3092('0x2a'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x2b');break;case _0x3092('0x2c'):_0xa5f581['childModel']='VoiceContext';break;case _0x3092('0x2d'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x2e');break;case _0x3092('0x2f'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x30');_0xa5f581[_0x3092('0x18')]=[{'name':_0x3092('0x31'),'field':'name','foreignKey':'membername','model':_0x3092('0x32'),'filter':{'field':'role','value':[_0x3092('0x33')]}},{'name':'Telephones','field':_0x3092('0x1a'),'foreignKey':'membername','model':'User','filter':{'field':_0x3092('0x34'),'value':[_0x3092('0x35')]}},{'name':'VoiceQueues','field':_0x3092('0x1a'),'foreignKey':'queue','model':'VoiceQueue','filter':{'field':'type','value':['inbound']}},{'name':'QueueCampaigns','field':_0x3092('0x1a'),'foreignKey':_0x3092('0x36'),'model':'VoiceQueue','filter':{'field':_0x3092('0x10'),'value':[_0x3092('0x37')]}}];break;case _0x3092('0x38'):_0xa5f581[_0x3092('0x14')]='VoiceMusicOnHold';break;case'chanspies':_0xa5f581[_0x3092('0x14')]=_0x3092('0x39');break;case _0x3092('0x3a'):_0xa5f581['childModel']=_0x3092('0x3b');break;case _0x3092('0x3c'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x3d');break;case'mailqueues':_0xa5f581[_0x3092('0x14')]=_0x3092('0x3e');break;case _0x3092('0x3f'):_0xa5f581[_0x3092('0x14')]='MailAccount';break;case'mailsubstatuses':_0xa5f581['childModel']=_0x3092('0x40');break;case _0x3092('0x41'):_0xa5f581[_0x3092('0x14')]='OpenchannelQueue';break;case _0x3092('0x42'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x43');break;case'smsqueues':_0xa5f581[_0x3092('0x14')]='SmsQueue';break;case _0x3092('0x44'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x45');break;case _0x3092('0x46'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x47');break;case _0x3092('0x48'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x49');break;case'teams':_0xa5f581[_0x3092('0x14')]=_0x3092('0x4a');break;case _0x3092('0x4b'):case'queuecampaigns':_0xa5f581[_0x3092('0x14')]=_0x3092('0x4c');if(_0x1c1116){_0xa5f581[_0x3092('0x18')]=[{'name':'VoiceQueues'},{'name':_0x3092('0x4d')}];}break;case'users':case _0x3092('0x4e'):case'telephones':_0xa5f581[_0x3092('0x14')]='User';if(_0x1c1116){_0xa5f581[_0x3092('0x18')]=[{'name':_0x3092('0x4f'),'filter':{'field':_0x3092('0x34'),'value':[_0x3092('0x50'),_0x3092('0x51')]},'ignore':!![]},{'name':'Agents'},{'name':_0x3092('0x52')}];}break;case'zendeskaccounts':_0xa5f581[_0x3092('0x14')]='ZendeskAccount';break;case _0x3092('0x53'):_0xa5f581[_0x3092('0x14')]='SalesforceAccount';break;case _0x3092('0x54'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x55');break;case _0x3092('0x56'):_0xa5f581['childModel']=_0x3092('0x57');break;case _0x3092('0x58'):_0xa5f581['childModel']=_0x3092('0x59');break;case'zohoaccounts':_0xa5f581[_0x3092('0x14')]=_0x3092('0x5a');break;case _0x3092('0x5b'):_0xa5f581[_0x3092('0x14')]='User';break;case _0x3092('0x5c'):_0xa5f581['childModel']=_0x3092('0x5d');break;case _0x3092('0x5e'):_0xa5f581['childModel']=_0x3092('0x5f');break;case _0x3092('0x60'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x61');break;case'intervals':_0xa5f581[_0x3092('0x14')]=_0x3092('0x62');break;case _0x3092('0x63'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x64');break;case _0x3092('0x65'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x66');break;case'sounds':_0xa5f581[_0x3092('0x14')]=_0x3092('0x67');break;case _0x3092('0x68'):_0xa5f581['childModel']=_0x3092('0x69');break;case'templates':_0xa5f581[_0x3092('0x14')]=_0x3092('0x6a');break;case _0x3092('0x6b'):_0xa5f581['childModel']=_0x3092('0x6c');break;case _0x3092('0x6d'):_0xa5f581['childModel']=_0x3092('0x6e');break;case _0x3092('0x6f'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x70');break;case _0x3092('0x71'):_0xa5f581[_0x3092('0x14')]='Plugin';break;case _0x3092('0x72'):_0xa5f581[_0x3092('0x14')]=_0x3092('0xe');_0xa5f581[_0x3092('0x18')]=[{'name':_0x3092('0x73'),'field':'id','foreignKey':_0x3092('0x74')}];break;case _0x3092('0x75'):_0xa5f581[_0x3092('0x14')]=_0x3092('0x76');break;}return _0xa5f581;}function _0xf30aab(_0x5da164,_0x40f488){var _0x2b28fb=_0x5da164['charAt'](0x0)['toUpperCase']()+_0x5da164['slice'](0x1);var _0x3051f3={'type':_0x44a165[_0x3092('0x77')][_0x3092('0x78')][_0x3092('0x79')],'raw':!![]};return new Promise(function(_0x1436d3,_0x2dad7c){var _0x2b2624=squel[_0x3092('0x7a')]()[_0x3092('0x8')](_0x3092('0x7b')+_0x2b28fb+_0x3092('0x7c'),'id')[_0x3092('0x8')](_0x3092('0x7d'))[_0x3092('0x7e')](_0x3092('0x7f')+_0x5da164+_0x3092('0x80'),'ui')['where'](_0x3092('0x81'),_0x40f488['id']);return _0x44a165[_0x3092('0x82')]['query'](_0x2b2624['toString'](),_0x3051f3)['then'](function(_0x2519d2){_0x40f488[_0x2b28fb+'OpenTabs']=_0x2519d2;_0x1436d3(_0x2519d2);})['catch'](function(_0x10c25b){_0x2dad7c(_0x10c25b);});});}return _0x5b7779['define'](_0x3092('0x83'),attributes,{'tableName':_0x3092('0x84'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x429e62){var _0x591ab7=require(_0x3092('0x85'));var _0x598456={'raw':_0x429e62[_0x3092('0x86')][_0x3092('0x87')],'where':{}};var _0x50c7cf={};var _0x4422d6={'count':0x0,'rows':[]};var _0x2e7b72=_0x429e62[_0x3092('0x86')][_0x3092('0x88')];var _0x1a79c6=_0x429e62['query'][_0x3092('0x89')]||![];var _0x38a07b=_0x1bf399(_0x2e7b72,_0x1a79c6);if(!_0x38a07b[_0x3092('0x14')])throw new Error(_0x3092('0x8a')+_0x2e7b72+'\x27');var _0x4a395f=[{'name':_0x2e7b72}];if(!_[_0x3092('0x8b')](_0x38a07b[_0x3092('0x18')]))_0x4a395f=_0x38a07b[_0x3092('0x18')];var _0x157af5=[];for(var _0x3a540b=0x0;_0x3a540b<_0x4a395f[_0x3092('0x8c')];_0x3a540b++){_0x157af5[_0x3092('0x8d')](_0x44a165[_0x3092('0x8e')][_0x3092('0x8f')]({'where':{'userProfileId':_0x429e62[_0x3092('0x90')]['id'],'name':_0x4a395f[_0x3a540b]['name']},'raw':!![]}));}return Promise[_0x3092('0x91')](_0x157af5)['then'](function(_0x200fe1){var _0x4d4490=_['filter'](_0x200fe1,function(_0x3ffd09){return _0x3ffd09?_0x3ffd09:undefined;});var _0x53d9b4=_[_0x3092('0x5')](_0x4a395f,[_0x3092('0x92'),!![]]);var _0x59973c=_['isEmpty'](_0x4d4490)&&_['isEmpty'](_0x53d9b4)?null:_[_0x3092('0x93')](_0x53d9b4,_0x4d4490);if(!_0x59973c)return null;var _0x2e1993=[];for(var _0x10b71b=0x0;_0x10b71b<_0x59973c['length'];_0x10b71b++){var _0x1a7949=_[_0x3092('0x8f')](_0x4a395f,function(_0x8a6e30){return _0x59973c[_0x10b71b]?_0x8a6e30[_0x3092('0x1a')]===_0x59973c[_0x10b71b][_0x3092('0x1a')]:null;});if(_0x1a7949){if(_0x59973c[_0x10b71b][_0x3092('0x92')]){_0x2e1993[_0x3092('0x8d')](_0x3ebddc(_0x38a07b[_0x3092('0x14')],_0x59973c[_0x10b71b]));}else{if(!_0x59973c[_0x10b71b][_0x3092('0x94')]){_0x2e1993[_0x3092('0x8d')](_0x24a511(_0x1a7949,_0x59973c[_0x10b71b],_0x38a07b['childModel']));}else{if(_0x1a7949[_0x3092('0xa')]){_0x2e1993[_0x3092('0x8d')](_0x5d4565(_0x1a7949,_0x59973c[_0x10b71b]));}}}}}return Promise[_0x3092('0x91')](_0x2e1993);})[_0x3092('0xb')](function(_0x3dc04e){var _0x537a6e=_0x3dc04e;var _0x54c16d=null;if(_0x537a6e){_0x54c16d=_0x537a6e[_0x3092('0x8c')]===0x1?_0x537a6e[0x0]:null;}if(!_0x54c16d&&!_0x537a6e)return _0x4422d6;var _0x52e823=_0x44a165[_0x38a07b[_0x3092('0x14')]][_0x3092('0x95')];_0x50c7cf[_0x3092('0xa')]=_['keys'](_0x52e823);_0x50c7cf['query']=_[_0x3092('0x96')](_0x429e62[_0x3092('0x86')]);_0x50c7cf[_0x3092('0x97')]=_[_0x3092('0x98')](_0x50c7cf[_0x3092('0xa')],_0x50c7cf[_0x3092('0x86')]);_0x598456[_0x3092('0x99')]=_[_0x3092('0x98')](_0x50c7cf['model'],_0x591ab7['fields'](_0x429e62[_0x3092('0x86')][_0x3092('0x9a')]));_0x598456[_0x3092('0x99')]=_0x598456['attributes']['length']?_0x598456[_0x3092('0x99')]:_0x50c7cf[_0x3092('0xa')];if(!_0x429e62['query'][_0x3092('0x9b')](_0x3092('0x9c'))){_0x598456['limit']=_0x591ab7[_0x3092('0x9d')](_0x429e62['query']['limit']);_0x598456['offset']=_0x591ab7[_0x3092('0x9e')](_0x429e62[_0x3092('0x86')][_0x3092('0x9e')]);}_0x598456['order']=_0x591ab7[_0x3092('0x9f')](_0x429e62[_0x3092('0x86')][_0x3092('0x9f')]);_0x598456[_0x3092('0xa0')]=_0x591ab7[_0x3092('0x97')](_[_0x3092('0xa1')](_0x429e62[_0x3092('0x86')],_0x50c7cf[_0x3092('0x97')]));if(_0x429e62[_0x3092('0x86')][_0x3092('0x5')]){_0x598456[_0x3092('0xa0')]=_[_0x3092('0xa2')](_0x598456['where'],{'$or':_[_0x3092('0x7')](_0x52e823,function(_0x19fe80){if(_0x19fe80[_0x3092('0x10')][_0x3092('0xa3')]!==_0x3092('0xa4')){var _0x373a7e={};_0x373a7e[_0x19fe80[_0x3092('0x8')]]={'$like':'%'+_0x429e62[_0x3092('0x86')]['filter']+'%'};return _0x373a7e;}})});}var _0xa0b492=[];var _0x23ccf8=null;var _0x2b5a06={};if(_0x54c16d){_0x23ccf8=_[_0x3092('0x8f')](_0x4a395f,[_0x3092('0x1a'),_0x54c16d['name']]);if(_0x23ccf8['field']){_0x2b5a06={};if(_0x38a07b[_0x3092('0x14')]===_0x3092('0xe')){_0x2b5a06[_0x23ccf8[_0x3092('0xa5')]]=_[_0x3092('0x7')](_0x54c16d['associatedResources'],'id');}else{_0x2b5a06[_0x23ccf8[_0x3092('0xa5')]]=_0x54c16d['associatedResources'];}_0xa0b492[_0x3092('0x8d')](_0x2b5a06);}else{_0x598456[_0x3092('0xa0')]['id']=_0x54c16d[_0x3092('0xd')];}}else{for(var _0x239f61=0x0;_0x239f61<_0x537a6e[_0x3092('0x8c')];_0x239f61++){_0x23ccf8=_[_0x3092('0x8f')](_0x4a395f,[_0x3092('0x1a'),_0x537a6e[_0x239f61][_0x3092('0x1a')]]);if(_0x23ccf8[_0x3092('0x8')]){_0x2b5a06={};_0x2b5a06[_0x23ccf8['foreignKey']]=_0x537a6e[_0x239f61][_0x3092('0xd')];_0xa0b492['push'](_0x2b5a06);}else{if(!_0x598456['where']['id'])_0x598456[_0x3092('0xa0')]['id']=[];_0x537a6e[_0x239f61][_0x3092('0xd')][_0x3092('0xa6')](function(_0x306a8d){_0x598456[_0x3092('0xa0')]['id'][_0x3092('0x8d')](_0x306a8d);});}}}if(!_[_0x3092('0x8b')](_0xa0b492)){_0x598456[_0x3092('0xa0')]=_[_0x3092('0xa2')](_0x598456['where'],{'$and':{'$or':_0xa0b492}});}_0x598456=_[_0x3092('0xa2')]({},_0x598456,_0x429e62[_0x3092('0xa7')]);if(_0x54c16d&&!_0x54c16d[_0x3092('0x94')]&&_0x38a07b[_0x3092('0x14')]===_0x3092('0xe')){if(_0x429e62['query'][_0x3092('0xa8')]){_0x598456[_0x3092('0xa9')]=[{'all':!![]}];}return _0x44a165[_0x38a07b[_0x3092('0x14')]]['findAll'](_0x598456)[_0x3092('0xb')](function(_0x56d408){var _0x4ae4c2=[];_0x56d408[_0x3092('0xa6')](function(_0x1c3abb){var _0x41518d;switch(_0x1c3abb[_0x3092('0xaa')]){case'default':_0x41518d=_['find'](_0x54c16d[_0x3092('0xd')],function(_0x33e418){return _0x33e418['id']===_0x1c3abb[_0x3092('0x74')]&&_0x33e418[_0x3092('0x10')]===_0x3092('0xab');});break;case'custom':_0x41518d=_[_0x3092('0x8f')](_0x54c16d['associatedResources'],function(_0x5c559c){return _0x5c559c['id']===_0x1c3abb[_0x3092('0x74')]&&_0x5c559c[_0x3092('0x10')]===_0x3092('0xac');});break;}if(_0x41518d)_0x4ae4c2[_0x3092('0x8d')](_0x1c3abb);});_0x4422d6['count']=_0x4ae4c2['length'];_0x4422d6[_0x3092('0xad')]=_0x4ae4c2;return _0x4422d6;});}else{if(!_['isEmpty'](_0x429e62[_0x3092('0x86')][_0x3092('0xae')])){_0x598456[_0x3092('0xa0')]['id']=_0x598456[_0x3092('0xa0')]['id']?_['intersection'](_0x598456['where']['id'],_0x429e62[_0x3092('0x86')][_0x3092('0xae')]):_0x429e62['query'][_0x3092('0xae')];if(_0x429e62[_0x3092('0x86')][_0x3092('0xaf')]){_0x598456[_0x3092('0xb0')]=_0x429e62[_0x3092('0x86')]['customSorting'];}}if(_0x429e62[_0x3092('0x86')][_0x3092('0xb1')]){_0x598456['where']=_[_0x3092('0xa2')](_0x598456[_0x3092('0xa0')],{'$and':_0x429e62[_0x3092('0x86')][_0x3092('0xb1')]});}return _0x44a165[_0x38a07b[_0x3092('0x14')]][_0x3092('0xb2')]({'where':_0x598456[_0x3092('0xa0')]})[_0x3092('0xb')](function(_0xab745c){_0x4422d6[_0x3092('0xb2')]=_0xab745c;if(_0x429e62['query']['includeAll']){if(_0x38a07b[_0x3092('0x14')]===_0x3092('0x1e')){_0x598456['include']=[{'model':_0x44a165[_0x3092('0x69')],'as':_0x3092('0xb3'),'attributes':['id','name','color'],'required':_0x429e62[_0x3092('0x86')][_0x3092('0xb4')]?!![]:![]},{'model':_0x44a165[_0x3092('0x69')],'as':_0x3092('0xb5'),'attributes':['id','name',_0x3092('0xb6')],'through':_0x429e62[_0x3092('0x86')][_0x3092('0xb4')]?{'attributes':[],'where':{'TagId':_0x429e62[_0x3092('0x86')][_0x3092('0xb4')]||undefined}}:{},'required':_0x429e62['query'][_0x3092('0xb4')]?!![]:![]}];}else{_0x598456[_0x3092('0xa9')]=[{'all':!![]}];}}return _0x44a165[_0x38a07b['childModel']][_0x3092('0x6')](_0x598456);})[_0x3092('0xb')](function(_0x3ada31){_0x4422d6[_0x3092('0xad')]=_0x3ada31;if(_0x2e7b72===_0x3092('0x31')&&_0x429e62[_0x3092('0x86')][_0x3092('0xb7')]===_0x3092('0xb8')){var _0x192edc=[];for(var _0x58af55=0x0;_0x58af55<_0x4422d6[_0x3092('0xad')][_0x3092('0x8c')];_0x58af55++){_0x192edc[_0x3092('0x8d')](_0xf30aab(_0x3092('0xb9'),_0x4422d6[_0x3092('0xad')][_0x58af55][_0x3092('0xba')]));_0x192edc[_0x3092('0x8d')](_0xf30aab('sms',_0x4422d6[_0x3092('0xad')][_0x58af55][_0x3092('0xba')]));_0x192edc[_0x3092('0x8d')](_0xf30aab(_0x3092('0xbb'),_0x4422d6['rows'][_0x58af55][_0x3092('0xba')]));_0x192edc['push'](_0xf30aab(_0x3092('0xbc'),_0x4422d6['rows'][_0x58af55][_0x3092('0xba')]));_0x192edc[_0x3092('0x8d')](_0xf30aab('openchannel',_0x4422d6[_0x3092('0xad')][_0x58af55]['dataValues']));_0x192edc[_0x3092('0x8d')](_0xf30aab('whatsapp',_0x4422d6['rows'][_0x58af55][_0x3092('0xba')]));}return Promise['all'](_0x192edc)[_0x3092('0xb')](function(){return _0x4422d6;});}return _0x4422d6;});}});}}});};