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 _0x0274=['odbc','SquareOdbc','squarerecordings','SquareRecording','parentSections','SquareProjects','projectName','projects','JscriptyProject','contacts','CmContact','Lists','ListId','companies','CmCompany','globalcustomfields','CmCustomField','chatqueues','ChatQueue','chatwebsites','ChatWebsite','faxqueues','FaxQueue','faxaccounts','FaxAccount','inboundroutes','internalroutes','VoiceExtension','contexts','VoiceContext','voicemails','VoiceRecording','Agents','membername','User','role','agent','telephone','VoiceQueues','VoiceQueue','inbound','QueueCampaigns','outbound','musiconholds','VoiceMusicOnHold','chanspies','VoiceChanSpy','voiceprefixes','VoicePrefix','ivrcampaigns','Campaign','mailqueues','MailQueue','mailaccounts','MailAccount','mailsubstatuses','MailSubstatus','smsqueues','SmsQueue','smsaccounts','SmsAccount','whatsappqueues','WhatsappQueue','whatsappaccounts','WhatsappAccount','teams','Team','voicequeues','users','agents','Users','admin','user','Telephones','zendeskaccounts','ZendeskAccount','SalesforceAccount','sugarcrmaccounts','deskaccounts','DeskAccount','vtigeraccounts','cannedanswers','CannedAnswer','dispositions','Dashboard','pauses','Pause','Schedule','sounds','tags','templates','Template','triggers','Trigger','trunks','Trunk','variables','plugins','AnalyticExtractedReport','Reports','reportId','metrics','charAt','toUpperCase','QueryTypes','select','ui.','InteractionId','from','_interactions','where','ui.UserId\x20=\x20?','sequelize','query','toString','OpenTabs','define','UserProfile','user_profiles','mergeResources','isEmpty','length','push','UserProfileSection','params','all','ignore','autoAssociation','rawAttributes','keys','filters','intersection','fields','attributes','nolimit','limit','offset','sort','merge','key','VIRTUAL','find','foreignKey','forEach','options','includeAll','include','reportType','default','DefaultReports','custom','CustomReports','count','rows','ids','order','customSorting','extraQueryConditions','Tag','Tags','color','tag','ThroughTags','openTabs','true','chat','dataValues','sms','mail','openchannel','whatsapp','lodash','./userProfile.attributes','squel','exports','models','filter','field','value','then','associatedResources','map','catch','model','findAll','name','UserProfileResource','resourceId','type','toLowerCase','squareprojects','childModel','SquareProject'];(function(_0x3ab51d,_0x2fa01d){var _0x29a04e=function(_0x7807b0){while(--_0x7807b0){_0x3ab51d['push'](_0x3ab51d['shift']());}};_0x29a04e(++_0x2fa01d);}(_0x0274,0xab));var _0x4027=function(_0x305d00,_0x11ddef){_0x305d00=_0x305d00-0x0;var _0x150f52=_0x0274[_0x305d00];return _0x150f52;};'use strict';var _=require(_0x4027('0x0'));var attributes=require(_0x4027('0x1'));var squel=require(_0x4027('0x2'));module[_0x4027('0x3')]=function(_0x26b0e0){var _0x353184=_0x26b0e0[_0x4027('0x4')];function _0x3842a2(_0x2bb508,_0x28bf38){return new Promise(function(_0x1935d8,_0x5f56f1){if(!_0x28bf38)return _0x1935d8(null);var _0x20ae0f=_0x28bf38[_0x4027('0x5')]?{[_0x28bf38[_0x4027('0x5')][_0x4027('0x6')]]:_0x28bf38['filter'][_0x4027('0x7')]}:undefined;return _0x353184[_0x2bb508]['findAll']({'where':_0x20ae0f,'raw':!![]})[_0x4027('0x8')](function(_0x517081){_0x28bf38[_0x4027('0x9')]=_[_0x4027('0xa')](_0x517081,'id');_0x1935d8(_0x28bf38);})[_0x4027('0xb')](function(_0x4cb3f9){_0x5f56f1(_0x4cb3f9);});});}function _0x4da2ce(_0x1d1ba6,_0x225785){return new Promise(function(_0x2044cd,_0x537c05){var _0x55a8c4=_0x1d1ba6[_0x4027('0x5')]?{[_0x1d1ba6[_0x4027('0x5')][_0x4027('0x6')]]:_0x1d1ba6['filter'][_0x4027('0x7')]}:undefined;return _0x353184[_0x1d1ba6[_0x4027('0xc')]][_0x4027('0xd')]({'where':_0x55a8c4,'raw':!![]})['then'](function(_0x186e1b){_0x225785[_0x4027('0x9')]=_[_0x4027('0xa')](_0x186e1b,function(_0x10a7d2){return _0x10a7d2[_0x4027('0xe')];});_0x2044cd(_0x225785);})['catch'](function(_0xf4f97b){_0x537c05(_0xf4f97b);});});}function _0x20c3b2(_0x1f0f6a,_0x56a8d4,_0x4cb967){if(!_0x56a8d4)return Promise['resolve'](null);return new Promise(function(_0x3a5657,_0x441a1d){return _0x353184[_0x4027('0xf')][_0x4027('0xd')]({'where':{'sectionId':_0x56a8d4['id']},'raw':!![]})[_0x4027('0x8')](function(_0x524fc2){if(_0x1f0f6a[_0x4027('0x6')]&&_0x1f0f6a[_0x4027('0x6')]!=='id'){_0x56a8d4[_0x4027('0x9')]=_['map'](_0x524fc2,function(_0x4bbb2d){return _0x4bbb2d[_0x1f0f6a[_0x4027('0x6')]];});}else{if(_0x4cb967==='AnalyticExtractedReport'){_0x56a8d4[_0x4027('0x9')]=_[_0x4027('0xa')](_0x524fc2,function(_0x3f8d27){return{'id':_0x3f8d27[_0x4027('0x10')],'type':_0x3f8d27[_0x4027('0x11')]};});}else{_0x56a8d4[_0x4027('0x9')]=_[_0x4027('0xa')](_0x524fc2,function(_0x49b632){return _0x49b632[_0x4027('0x10')];});}}_0x3a5657(_0x56a8d4);})[_0x4027('0xb')](function(_0x55efb1){_0x441a1d(_0x55efb1);});});}function _0x456111(_0xfd1661,_0x257324){var _0x307a18={'parentSections':[]};switch(_0xfd1661[_0x4027('0x12')]()){case _0x4027('0x13'):_0x307a18[_0x4027('0x14')]=_0x4027('0x15');break;case _0x4027('0x16'):_0x307a18['childModel']=_0x4027('0x17');break;case _0x4027('0x18'):_0x307a18[_0x4027('0x14')]=_0x4027('0x19');_0x307a18[_0x4027('0x1a')]=[{'name':_0x4027('0x1b'),'field':_0x4027('0xe'),'foreignKey':_0x4027('0x1c')}];break;case _0x4027('0x1d'):_0x307a18[_0x4027('0x14')]=_0x4027('0x1e');break;case _0x4027('0x1f'):_0x307a18[_0x4027('0x14')]=_0x4027('0x20');_0x307a18['parentSections']=[{'name':_0x4027('0x21'),'field':'id','foreignKey':_0x4027('0x22')}];break;case'lists':_0x307a18[_0x4027('0x14')]='CmList';break;case _0x4027('0x23'):_0x307a18['childModel']=_0x4027('0x24');break;case _0x4027('0x25'):_0x307a18['childModel']=_0x4027('0x26');break;case _0x4027('0x27'):_0x307a18['childModel']=_0x4027('0x28');break;case _0x4027('0x29'):_0x307a18['childModel']=_0x4027('0x2a');break;case _0x4027('0x2b'):_0x307a18[_0x4027('0x14')]=_0x4027('0x2c');break;case _0x4027('0x2d'):_0x307a18[_0x4027('0x14')]=_0x4027('0x2e');break;case _0x4027('0x2f'):case _0x4027('0x30'):case'outboundroutes':_0x307a18[_0x4027('0x14')]=_0x4027('0x31');break;case _0x4027('0x32'):_0x307a18['childModel']=_0x4027('0x33');break;case _0x4027('0x34'):_0x307a18[_0x4027('0x14')]='VoiceMail';break;case'voicerecordings':_0x307a18[_0x4027('0x14')]=_0x4027('0x35');_0x307a18[_0x4027('0x1a')]=[{'name':_0x4027('0x36'),'field':_0x4027('0xe'),'foreignKey':_0x4027('0x37'),'model':_0x4027('0x38'),'filter':{'field':_0x4027('0x39'),'value':[_0x4027('0x3a')]}},{'name':'Telephones','field':_0x4027('0xe'),'foreignKey':'membername','model':_0x4027('0x38'),'filter':{'field':_0x4027('0x39'),'value':[_0x4027('0x3b')]}},{'name':_0x4027('0x3c'),'field':_0x4027('0xe'),'foreignKey':'queue','model':_0x4027('0x3d'),'filter':{'field':'type','value':[_0x4027('0x3e')]}},{'name':_0x4027('0x3f'),'field':'name','foreignKey':'queue','model':'VoiceQueue','filter':{'field':_0x4027('0x11'),'value':[_0x4027('0x40')]}}];break;case _0x4027('0x41'):_0x307a18[_0x4027('0x14')]=_0x4027('0x42');break;case _0x4027('0x43'):_0x307a18[_0x4027('0x14')]=_0x4027('0x44');break;case _0x4027('0x45'):_0x307a18[_0x4027('0x14')]=_0x4027('0x46');break;case _0x4027('0x47'):_0x307a18[_0x4027('0x14')]=_0x4027('0x48');break;case _0x4027('0x49'):_0x307a18[_0x4027('0x14')]=_0x4027('0x4a');break;case _0x4027('0x4b'):_0x307a18[_0x4027('0x14')]=_0x4027('0x4c');break;case _0x4027('0x4d'):_0x307a18[_0x4027('0x14')]=_0x4027('0x4e');break;case'openchannelqueues':_0x307a18[_0x4027('0x14')]='OpenchannelQueue';break;case'openchannelaccounts':_0x307a18[_0x4027('0x14')]='OpenchannelAccount';break;case _0x4027('0x4f'):_0x307a18[_0x4027('0x14')]=_0x4027('0x50');break;case _0x4027('0x51'):_0x307a18['childModel']=_0x4027('0x52');break;case _0x4027('0x53'):_0x307a18[_0x4027('0x14')]=_0x4027('0x54');break;case _0x4027('0x55'):_0x307a18['childModel']=_0x4027('0x56');break;case _0x4027('0x57'):_0x307a18[_0x4027('0x14')]=_0x4027('0x58');break;case _0x4027('0x59'):case'queuecampaigns':_0x307a18[_0x4027('0x14')]=_0x4027('0x3d');if(_0x257324){_0x307a18['parentSections']=[{'name':_0x4027('0x3c')},{'name':_0x4027('0x3f')}];}break;case _0x4027('0x5a'):case _0x4027('0x5b'):case'telephones':_0x307a18[_0x4027('0x14')]='User';if(_0x257324){_0x307a18[_0x4027('0x1a')]=[{'name':_0x4027('0x5c'),'filter':{'field':_0x4027('0x39'),'value':[_0x4027('0x5d'),_0x4027('0x5e')]},'ignore':!![]},{'name':_0x4027('0x36')},{'name':_0x4027('0x5f')}];}break;case _0x4027('0x60'):_0x307a18['childModel']=_0x4027('0x61');break;case'salesforceaccounts':_0x307a18[_0x4027('0x14')]=_0x4027('0x62');break;case'freshdeskaccounts':_0x307a18['childModel']='FreshdeskAccount';break;case _0x4027('0x63'):_0x307a18[_0x4027('0x14')]='SugarcrmAccount';break;case _0x4027('0x64'):_0x307a18['childModel']=_0x4027('0x65');break;case'zohoaccounts':_0x307a18[_0x4027('0x14')]='ZohoAccount';break;case _0x4027('0x66'):_0x307a18['childModel']=_0x4027('0x38');break;case _0x4027('0x67'):_0x307a18[_0x4027('0x14')]=_0x4027('0x68');break;case _0x4027('0x69'):_0x307a18[_0x4027('0x14')]='Disposition';break;case'customdashboards':_0x307a18['childModel']=_0x4027('0x6a');break;case'intervals':_0x307a18[_0x4027('0x14')]='Interval';break;case _0x4027('0x6b'):_0x307a18[_0x4027('0x14')]=_0x4027('0x6c');break;case'scheduler':_0x307a18[_0x4027('0x14')]=_0x4027('0x6d');break;case _0x4027('0x6e'):_0x307a18[_0x4027('0x14')]='Sound';break;case _0x4027('0x6f'):_0x307a18[_0x4027('0x14')]='Tag';break;case _0x4027('0x70'):_0x307a18[_0x4027('0x14')]=_0x4027('0x71');break;case _0x4027('0x72'):_0x307a18[_0x4027('0x14')]=_0x4027('0x73');break;case _0x4027('0x74'):_0x307a18[_0x4027('0x14')]=_0x4027('0x75');break;case _0x4027('0x76'):_0x307a18[_0x4027('0x14')]='Variable';break;case _0x4027('0x77'):_0x307a18['childModel']='Plugin';break;case'extractedreports':_0x307a18['childModel']=_0x4027('0x78');_0x307a18[_0x4027('0x1a')]=[{'name':_0x4027('0x79'),'field':'id','foreignKey':_0x4027('0x7a')}];break;case _0x4027('0x7b'):_0x307a18['childModel']='AnalyticMetric';break;}return _0x307a18;}function _0x3b1406(_0x355553,_0x1a242b){var _0x421f17=_0x355553[_0x4027('0x7c')](0x0)[_0x4027('0x7d')]()+_0x355553['slice'](0x1);var _0x4902df={'type':_0x353184['Sequelize'][_0x4027('0x7e')]['SELECT'],'raw':!![]};return new Promise(function(_0x4a8e14,_0x2133f4){var _0x3ad787=squel[_0x4027('0x7f')]()[_0x4027('0x6')](_0x4027('0x80')+_0x421f17+_0x4027('0x81'),'id')[_0x4027('0x6')]('ui.createdAt')[_0x4027('0x82')]('user_has_'+_0x355553+_0x4027('0x83'),'ui')[_0x4027('0x84')](_0x4027('0x85'),_0x1a242b['id']);return _0x353184[_0x4027('0x86')][_0x4027('0x87')](_0x3ad787[_0x4027('0x88')](),_0x4902df)['then'](function(_0xa3c833){_0x1a242b[_0x421f17+_0x4027('0x89')]=_0xa3c833;_0x4a8e14(_0xa3c833);})[_0x4027('0xb')](function(_0x5b5bb8){_0x2133f4(_0x5b5bb8);});});}return _0x26b0e0[_0x4027('0x8a')](_0x4027('0x8b'),attributes,{'tableName':_0x4027('0x8c'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x151bee){var _0x27657b=require('../../components/parsers/qs');var _0x1bce8e={'raw':_0x151bee[_0x4027('0x87')]['raw'],'where':{}};var _0xed54bf={};var _0x3692b7={'count':0x0,'rows':[]};var _0x4c1073=_0x151bee[_0x4027('0x87')]['section'];var _0x2eca4d=_0x151bee[_0x4027('0x87')][_0x4027('0x8d')]||![];var _0x2f233d=_0x456111(_0x4c1073,_0x2eca4d);if(!_0x2f233d['childModel'])throw new Error('Invalid\x20section\x20\x27'+_0x4c1073+'\x27');var _0x58cc05=[{'name':_0x4c1073}];if(!_[_0x4027('0x8e')](_0x2f233d['parentSections']))_0x58cc05=_0x2f233d[_0x4027('0x1a')];var _0x52350a=[];for(var _0x30903f=0x0;_0x30903f<_0x58cc05[_0x4027('0x8f')];_0x30903f++){_0x52350a[_0x4027('0x90')](_0x353184[_0x4027('0x91')]['find']({'where':{'userProfileId':_0x151bee[_0x4027('0x92')]['id'],'name':_0x58cc05[_0x30903f][_0x4027('0xe')]},'raw':!![]}));}return Promise[_0x4027('0x93')](_0x52350a)[_0x4027('0x8')](function(_0x618eaa){var _0x287245=_[_0x4027('0x5')](_0x618eaa,function(_0x5ab617){return _0x5ab617?_0x5ab617:undefined;});var _0x30daa6=_[_0x4027('0x5')](_0x58cc05,[_0x4027('0x94'),!![]]);var _0x24a40b=_[_0x4027('0x8e')](_0x287245)&&_[_0x4027('0x8e')](_0x30daa6)?null:_['union'](_0x30daa6,_0x287245);if(!_0x24a40b)return null;var _0x31ff0b=[];for(var _0x104925=0x0;_0x104925<_0x24a40b[_0x4027('0x8f')];_0x104925++){var _0x56b004=_['find'](_0x58cc05,function(_0x11cd52){return _0x24a40b[_0x104925]?_0x11cd52['name']===_0x24a40b[_0x104925][_0x4027('0xe')]:null;});if(_0x56b004){if(_0x24a40b[_0x104925]['ignore']){_0x31ff0b[_0x4027('0x90')](_0x3842a2(_0x2f233d['childModel'],_0x24a40b[_0x104925]));}else{if(!_0x24a40b[_0x104925][_0x4027('0x95')]){_0x31ff0b['push'](_0x20c3b2(_0x56b004,_0x24a40b[_0x104925],_0x2f233d[_0x4027('0x14')]));}else{if(_0x56b004[_0x4027('0xc')]){_0x31ff0b[_0x4027('0x90')](_0x4da2ce(_0x56b004,_0x24a40b[_0x104925]));}}}}}return Promise[_0x4027('0x93')](_0x31ff0b);})[_0x4027('0x8')](function(_0x3131e7){var _0x2483d6=_0x3131e7;var _0x30880a=null;if(_0x2483d6){_0x30880a=_0x2483d6[_0x4027('0x8f')]===0x1?_0x2483d6[0x0]:null;}if(!_0x30880a&&!_0x2483d6)return _0x3692b7;var _0x227596=_0x353184[_0x2f233d[_0x4027('0x14')]][_0x4027('0x96')];_0xed54bf['model']=_[_0x4027('0x97')](_0x227596);_0xed54bf[_0x4027('0x87')]=_[_0x4027('0x97')](_0x151bee[_0x4027('0x87')]);_0xed54bf[_0x4027('0x98')]=_[_0x4027('0x99')](_0xed54bf[_0x4027('0xc')],_0xed54bf[_0x4027('0x87')]);_0x1bce8e['attributes']=_['intersection'](_0xed54bf['model'],_0x27657b['fields'](_0x151bee[_0x4027('0x87')][_0x4027('0x9a')]));_0x1bce8e[_0x4027('0x9b')]=_0x1bce8e[_0x4027('0x9b')]['length']?_0x1bce8e['attributes']:_0xed54bf[_0x4027('0xc')];if(!_0x151bee[_0x4027('0x87')]['hasOwnProperty'](_0x4027('0x9c'))){_0x1bce8e[_0x4027('0x9d')]=_0x27657b[_0x4027('0x9d')](_0x151bee[_0x4027('0x87')][_0x4027('0x9d')]);_0x1bce8e[_0x4027('0x9e')]=_0x27657b[_0x4027('0x9e')](_0x151bee[_0x4027('0x87')]['offset']);}_0x1bce8e['order']=_0x27657b[_0x4027('0x9f')](_0x151bee[_0x4027('0x87')][_0x4027('0x9f')]);_0x1bce8e[_0x4027('0x84')]=_0x27657b[_0x4027('0x98')](_['pick'](_0x151bee['query'],_0xed54bf[_0x4027('0x98')]));if(_0x151bee[_0x4027('0x87')][_0x4027('0x5')]){_0x1bce8e[_0x4027('0x84')]=_[_0x4027('0xa0')](_0x1bce8e['where'],{'$or':_[_0x4027('0xa')](_0x227596,function(_0x198ab5){if(_0x198ab5[_0x4027('0x11')][_0x4027('0xa1')]!==_0x4027('0xa2')){var _0xb9b5e5={};_0xb9b5e5[_0x198ab5[_0x4027('0x6')]]={'$like':'%'+_0x151bee['query'][_0x4027('0x5')]+'%'};return _0xb9b5e5;}})});}var _0x475bcb=[];var _0x2458c9=null;var _0x6e07b6={};if(_0x30880a){_0x2458c9=_[_0x4027('0xa3')](_0x58cc05,['name',_0x30880a[_0x4027('0xe')]]);if(_0x2458c9[_0x4027('0x6')]){_0x6e07b6={};if(_0x2f233d['childModel']==='AnalyticExtractedReport'){_0x6e07b6[_0x2458c9['foreignKey']]=_[_0x4027('0xa')](_0x30880a[_0x4027('0x9')],'id');}else{_0x6e07b6[_0x2458c9[_0x4027('0xa4')]]=_0x30880a[_0x4027('0x9')];}_0x475bcb[_0x4027('0x90')](_0x6e07b6);}else{_0x1bce8e['where']['id']=_0x30880a['associatedResources'];}}else{for(var _0x14a93=0x0;_0x14a93<_0x2483d6[_0x4027('0x8f')];_0x14a93++){_0x2458c9=_[_0x4027('0xa3')](_0x58cc05,[_0x4027('0xe'),_0x2483d6[_0x14a93][_0x4027('0xe')]]);if(_0x2458c9['field']){_0x6e07b6={};_0x6e07b6[_0x2458c9[_0x4027('0xa4')]]=_0x2483d6[_0x14a93][_0x4027('0x9')];_0x475bcb[_0x4027('0x90')](_0x6e07b6);}else{if(!_0x1bce8e[_0x4027('0x84')]['id'])_0x1bce8e[_0x4027('0x84')]['id']=[];_0x2483d6[_0x14a93]['associatedResources'][_0x4027('0xa5')](function(_0x310083){_0x1bce8e[_0x4027('0x84')]['id'][_0x4027('0x90')](_0x310083);});}}}if(!_['isEmpty'](_0x475bcb)){_0x1bce8e[_0x4027('0x84')]=_[_0x4027('0xa0')](_0x1bce8e[_0x4027('0x84')],{'$and':{'$or':_0x475bcb}});}_0x1bce8e=_[_0x4027('0xa0')]({},_0x1bce8e,_0x151bee[_0x4027('0xa6')]);if(_0x30880a&&!_0x30880a[_0x4027('0x95')]&&_0x2f233d[_0x4027('0x14')]===_0x4027('0x78')){if(_0x151bee[_0x4027('0x87')][_0x4027('0xa7')]){_0x1bce8e[_0x4027('0xa8')]=[{'all':!![]}];}return _0x353184[_0x2f233d['childModel']][_0x4027('0xd')](_0x1bce8e)['then'](function(_0x1c4eb2){var _0x8dff22=[];_0x1c4eb2[_0x4027('0xa5')](function(_0x1bf861){var _0x283104;switch(_0x1bf861[_0x4027('0xa9')]){case _0x4027('0xaa'):_0x283104=_['find'](_0x30880a[_0x4027('0x9')],function(_0x30f12b){return _0x30f12b['id']===_0x1bf861[_0x4027('0x7a')]&&_0x30f12b['type']===_0x4027('0xab');});break;case _0x4027('0xac'):_0x283104=_[_0x4027('0xa3')](_0x30880a['associatedResources'],function(_0x2a746d){return _0x2a746d['id']===_0x1bf861[_0x4027('0x7a')]&&_0x2a746d[_0x4027('0x11')]===_0x4027('0xad');});break;}if(_0x283104)_0x8dff22[_0x4027('0x90')](_0x1bf861);});_0x3692b7[_0x4027('0xae')]=_0x8dff22[_0x4027('0x8f')];_0x3692b7[_0x4027('0xaf')]=_0x8dff22;return _0x3692b7;});}else{if(!_['isEmpty'](_0x151bee['query'][_0x4027('0xb0')])){_0x1bce8e['where']['id']=_0x1bce8e[_0x4027('0x84')]['id']?_[_0x4027('0x99')](_0x1bce8e[_0x4027('0x84')]['id'],_0x151bee['query'][_0x4027('0xb0')]):_0x151bee['query'][_0x4027('0xb0')];if(_0x151bee[_0x4027('0x87')]['customSorting']){_0x1bce8e[_0x4027('0xb1')]=_0x151bee[_0x4027('0x87')][_0x4027('0xb2')];}}if(_0x151bee[_0x4027('0x87')][_0x4027('0xb3')]){_0x1bce8e[_0x4027('0x84')]=_[_0x4027('0xa0')](_0x1bce8e[_0x4027('0x84')],{'$and':_0x151bee[_0x4027('0x87')][_0x4027('0xb3')]});}return _0x353184[_0x2f233d[_0x4027('0x14')]]['count']({'where':_0x1bce8e[_0x4027('0x84')]})[_0x4027('0x8')](function(_0x4a40e5){_0x3692b7['count']=_0x4a40e5;if(_0x151bee['query'][_0x4027('0xa7')]){if(_0x2f233d[_0x4027('0x14')]===_0x4027('0x20')){_0x1bce8e[_0x4027('0xa8')]=[{'model':_0x353184[_0x4027('0xb4')],'as':_0x4027('0xb5'),'attributes':['id','name',_0x4027('0xb6')],'required':_0x151bee[_0x4027('0x87')][_0x4027('0xb7')]?!![]:![]},{'model':_0x353184[_0x4027('0xb4')],'as':_0x4027('0xb8'),'attributes':['id',_0x4027('0xe'),_0x4027('0xb6')],'through':_0x151bee[_0x4027('0x87')][_0x4027('0xb7')]?{'attributes':[],'where':{'TagId':_0x151bee[_0x4027('0x87')][_0x4027('0xb7')]||undefined}}:{},'required':_0x151bee[_0x4027('0x87')][_0x4027('0xb7')]?!![]:![]}];}else{_0x1bce8e[_0x4027('0xa8')]=[{'all':!![]}];}}return _0x353184[_0x2f233d[_0x4027('0x14')]][_0x4027('0xd')](_0x1bce8e);})['then'](function(_0x5ebf98){_0x3692b7[_0x4027('0xaf')]=_0x5ebf98;if(_0x4c1073===_0x4027('0x36')&&_0x151bee[_0x4027('0x87')][_0x4027('0xb9')]===_0x4027('0xba')){var _0x42d888=[];for(var _0x41d769=0x0;_0x41d769<_0x3692b7['rows'][_0x4027('0x8f')];_0x41d769++){_0x42d888[_0x4027('0x90')](_0x3b1406(_0x4027('0xbb'),_0x3692b7[_0x4027('0xaf')][_0x41d769][_0x4027('0xbc')]));_0x42d888[_0x4027('0x90')](_0x3b1406(_0x4027('0xbd'),_0x3692b7['rows'][_0x41d769][_0x4027('0xbc')]));_0x42d888[_0x4027('0x90')](_0x3b1406('fax',_0x3692b7[_0x4027('0xaf')][_0x41d769]['dataValues']));_0x42d888['push'](_0x3b1406(_0x4027('0xbe'),_0x3692b7[_0x4027('0xaf')][_0x41d769]['dataValues']));_0x42d888[_0x4027('0x90')](_0x3b1406(_0x4027('0xbf'),_0x3692b7['rows'][_0x41d769][_0x4027('0xbc')]));_0x42d888['push'](_0x3b1406(_0x4027('0xc0'),_0x3692b7[_0x4027('0xaf')][_0x41d769][_0x4027('0xbc')]));}return Promise[_0x4027('0x93')](_0x42d888)[_0x4027('0x8')](function(){return _0x3692b7;});}return _0x3692b7;});}});}}});};