Built motion from commit b0a9a629.|2.6.33
[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 _0x5168=['user_has_','_interactions','where','ui.UserId\x20=\x20?','sequelize','query','toString','OpenTabs','define','raw','section','mergeResources','push','UserProfileSection','find','params','all','ignore','isEmpty','union','length','rawAttributes','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','limit','offset','order','pick','merge','key','VIRTUAL','foreignKey','forEach','options','include','reportType','default','DefaultReports','custom','CustomReports','ids','customSorting','extraQueryConditions','count','includeAll','Tags','tag','color','rows','openTabs','chat','dataValues','fax','mail','openchannel','lodash','./userProfile.attributes','exports','models','filter','field','findAll','then','map','catch','value','model','name','UserProfileResource','associatedResources','AnalyticExtractedReport','resourceId','toLowerCase','squareprojects','childModel','SquareProject','SquareOdbc','squarerecordings','SquareRecording','parentSections','SquareProjects','projectName','contacts','CmContact','ListId','lists','companies','CmCompany','CmCustomField','chatqueues','ChatQueue','chatwebsites','ChatWebsite','faxqueues','FaxQueue','faxaccounts','FaxAccount','inboundroutes','contexts','VoiceContext','voicemails','VoiceMail','Agents','membername','Telephones','role','telephone','VoiceQueues','queue','VoiceQueue','type','inbound','QueueCampaigns','musiconholds','VoiceMusicOnHold','chanspies','VoiceChanSpy','voiceprefixes','VoicePrefix','ivrcampaigns','mailqueues','MailQueue','mailaccounts','MailAccount','mailsubstatuses','MailSubstatus','openchannelqueues','OpenchannelQueue','openchannelaccounts','OpenchannelAccount','SmsQueue','smsaccounts','SmsAccount','WhatsappQueue','whatsappaccounts','teams','voicequeues','queuecampaigns','User','Users','admin','user','zendeskaccounts','ZendeskAccount','salesforceaccounts','SalesforceAccount','freshdeskaccounts','sugarcrmaccounts','SugarcrmAccount','deskaccounts','ZohoAccount','vtigeraccounts','cannedanswers','CannedAnswer','dispositions','customdashboards','intervals','Pause','scheduler','Schedule','Sound','tags','Tag','templates','triggers','Trigger','trunks','Trunk','plugins','Plugin','extractedreports','Reports','reportId','metrics','charAt','slice','SELECT','select','InteractionId','ui.createdAt','from'];(function(_0x453dd5,_0x106140){var _0x28b34e=function(_0x587a7f){while(--_0x587a7f){_0x453dd5['push'](_0x453dd5['shift']());}};_0x28b34e(++_0x106140);}(_0x5168,0xf6));var _0x8516=function(_0x5cc8f6,_0x10ade0){_0x5cc8f6=_0x5cc8f6-0x0;var _0x1986e8=_0x5168[_0x5cc8f6];return _0x1986e8;};'use strict';var _=require(_0x8516('0x0'));var attributes=require(_0x8516('0x1'));var squel=require('squel');module[_0x8516('0x2')]=function(_0x3d3810){var _0x5b97b7=_0x3d3810[_0x8516('0x3')];function _0x5b9b47(_0x7ee731,_0x3424d6){return new Promise(function(_0x531d64,_0x5af281){if(!_0x3424d6)return _0x531d64(null);var _0x2cf71f=_0x3424d6[_0x8516('0x4')]?{[_0x3424d6['filter'][_0x8516('0x5')]]:_0x3424d6[_0x8516('0x4')]['value']}:undefined;return _0x5b97b7[_0x7ee731][_0x8516('0x6')]({'where':_0x2cf71f,'raw':!![]})[_0x8516('0x7')](function(_0x381bb0){_0x3424d6['associatedResources']=_[_0x8516('0x8')](_0x381bb0,'id');_0x531d64(_0x3424d6);})[_0x8516('0x9')](function(_0x55e619){_0x5af281(_0x55e619);});});}function _0x5c48a2(_0x4e8b91,_0x27dac0){return new Promise(function(_0x3f0dac,_0x362362){var _0x32ea29=_0x4e8b91[_0x8516('0x4')]?{[_0x4e8b91[_0x8516('0x4')]['field']]:_0x4e8b91[_0x8516('0x4')][_0x8516('0xa')]}:undefined;return _0x5b97b7[_0x4e8b91[_0x8516('0xb')]][_0x8516('0x6')]({'where':_0x32ea29,'raw':!![]})['then'](function(_0x1e17ac){_0x27dac0['associatedResources']=_[_0x8516('0x8')](_0x1e17ac,function(_0x162e72){return _0x162e72[_0x8516('0xc')];});_0x3f0dac(_0x27dac0);})[_0x8516('0x9')](function(_0x494ec4){_0x362362(_0x494ec4);});});}function _0x2310a2(_0xa373fe,_0x481713,_0x4623bd){if(!_0x481713)return Promise['resolve'](null);return new Promise(function(_0x3c15d0,_0x5217ee){return _0x5b97b7[_0x8516('0xd')][_0x8516('0x6')]({'where':{'sectionId':_0x481713['id']},'raw':!![]})[_0x8516('0x7')](function(_0x109f67){if(_0xa373fe[_0x8516('0x5')]&&_0xa373fe['field']!=='id'){_0x481713[_0x8516('0xe')]=_[_0x8516('0x8')](_0x109f67,function(_0x174344){return _0x174344[_0xa373fe[_0x8516('0x5')]];});}else{if(_0x4623bd===_0x8516('0xf')){_0x481713[_0x8516('0xe')]=_['map'](_0x109f67,function(_0x4345e5){return{'id':_0x4345e5[_0x8516('0x10')],'type':_0x4345e5['type']};});}else{_0x481713[_0x8516('0xe')]=_[_0x8516('0x8')](_0x109f67,function(_0x38db2f){return _0x38db2f[_0x8516('0x10')];});}}_0x3c15d0(_0x481713);})['catch'](function(_0x2da355){_0x5217ee(_0x2da355);});});}function _0x2966dc(_0x1353e,_0x5bad41){var _0x48625c={'parentSections':[]};switch(_0x1353e[_0x8516('0x11')]()){case _0x8516('0x12'):_0x48625c[_0x8516('0x13')]=_0x8516('0x14');break;case'odbc':_0x48625c['childModel']=_0x8516('0x15');break;case _0x8516('0x16'):_0x48625c[_0x8516('0x13')]=_0x8516('0x17');_0x48625c[_0x8516('0x18')]=[{'name':_0x8516('0x19'),'field':'name','foreignKey':_0x8516('0x1a')}];break;case'projects':_0x48625c['childModel']='JscriptyProject';break;case _0x8516('0x1b'):_0x48625c[_0x8516('0x13')]=_0x8516('0x1c');_0x48625c['parentSections']=[{'name':'Lists','field':'id','foreignKey':_0x8516('0x1d')}];break;case _0x8516('0x1e'):_0x48625c[_0x8516('0x13')]='CmList';break;case _0x8516('0x1f'):_0x48625c[_0x8516('0x13')]=_0x8516('0x20');break;case'globalcustomfields':_0x48625c['childModel']=_0x8516('0x21');break;case _0x8516('0x22'):_0x48625c[_0x8516('0x13')]=_0x8516('0x23');break;case _0x8516('0x24'):_0x48625c['childModel']=_0x8516('0x25');break;case _0x8516('0x26'):_0x48625c[_0x8516('0x13')]=_0x8516('0x27');break;case _0x8516('0x28'):_0x48625c['childModel']=_0x8516('0x29');break;case _0x8516('0x2a'):case'internalroutes':case'outboundroutes':_0x48625c[_0x8516('0x13')]='VoiceExtension';break;case _0x8516('0x2b'):_0x48625c[_0x8516('0x13')]=_0x8516('0x2c');break;case _0x8516('0x2d'):_0x48625c[_0x8516('0x13')]=_0x8516('0x2e');break;case'voicerecordings':_0x48625c[_0x8516('0x13')]='VoiceRecording';_0x48625c[_0x8516('0x18')]=[{'name':_0x8516('0x2f'),'field':_0x8516('0xc'),'foreignKey':_0x8516('0x30'),'model':'User','filter':{'field':'role','value':['agent']}},{'name':_0x8516('0x31'),'field':_0x8516('0xc'),'foreignKey':_0x8516('0x30'),'model':'User','filter':{'field':_0x8516('0x32'),'value':[_0x8516('0x33')]}},{'name':_0x8516('0x34'),'field':_0x8516('0xc'),'foreignKey':_0x8516('0x35'),'model':_0x8516('0x36'),'filter':{'field':_0x8516('0x37'),'value':[_0x8516('0x38')]}},{'name':_0x8516('0x39'),'field':_0x8516('0xc'),'foreignKey':_0x8516('0x35'),'model':'VoiceQueue','filter':{'field':_0x8516('0x37'),'value':['outbound']}}];break;case _0x8516('0x3a'):_0x48625c[_0x8516('0x13')]=_0x8516('0x3b');break;case _0x8516('0x3c'):_0x48625c['childModel']=_0x8516('0x3d');break;case _0x8516('0x3e'):_0x48625c[_0x8516('0x13')]=_0x8516('0x3f');break;case _0x8516('0x40'):_0x48625c['childModel']='Campaign';break;case _0x8516('0x41'):_0x48625c[_0x8516('0x13')]=_0x8516('0x42');break;case _0x8516('0x43'):_0x48625c['childModel']=_0x8516('0x44');break;case _0x8516('0x45'):_0x48625c[_0x8516('0x13')]=_0x8516('0x46');break;case _0x8516('0x47'):_0x48625c[_0x8516('0x13')]=_0x8516('0x48');break;case _0x8516('0x49'):_0x48625c[_0x8516('0x13')]=_0x8516('0x4a');break;case'smsqueues':_0x48625c['childModel']=_0x8516('0x4b');break;case _0x8516('0x4c'):_0x48625c[_0x8516('0x13')]=_0x8516('0x4d');break;case'whatsappqueues':_0x48625c[_0x8516('0x13')]=_0x8516('0x4e');break;case _0x8516('0x4f'):_0x48625c[_0x8516('0x13')]='WhatsappAccount';break;case _0x8516('0x50'):_0x48625c['childModel']='Team';break;case _0x8516('0x51'):case _0x8516('0x52'):_0x48625c[_0x8516('0x13')]='VoiceQueue';if(_0x5bad41){_0x48625c[_0x8516('0x18')]=[{'name':_0x8516('0x34')},{'name':_0x8516('0x39')}];}break;case'users':case'agents':case'telephones':_0x48625c[_0x8516('0x13')]=_0x8516('0x53');if(_0x5bad41){_0x48625c[_0x8516('0x18')]=[{'name':_0x8516('0x54'),'filter':{'field':_0x8516('0x32'),'value':[_0x8516('0x55'),_0x8516('0x56')]},'ignore':!![]},{'name':_0x8516('0x2f')},{'name':_0x8516('0x31')}];}break;case _0x8516('0x57'):_0x48625c[_0x8516('0x13')]=_0x8516('0x58');break;case _0x8516('0x59'):_0x48625c['childModel']=_0x8516('0x5a');break;case _0x8516('0x5b'):_0x48625c[_0x8516('0x13')]='FreshdeskAccount';break;case _0x8516('0x5c'):_0x48625c['childModel']=_0x8516('0x5d');break;case _0x8516('0x5e'):_0x48625c[_0x8516('0x13')]='DeskAccount';break;case'zohoaccounts':_0x48625c['childModel']=_0x8516('0x5f');break;case _0x8516('0x60'):_0x48625c['childModel']=_0x8516('0x53');break;case _0x8516('0x61'):_0x48625c['childModel']=_0x8516('0x62');break;case _0x8516('0x63'):_0x48625c[_0x8516('0x13')]='Disposition';break;case _0x8516('0x64'):_0x48625c[_0x8516('0x13')]='Dashboard';break;case _0x8516('0x65'):_0x48625c[_0x8516('0x13')]='Interval';break;case'pauses':_0x48625c[_0x8516('0x13')]=_0x8516('0x66');break;case _0x8516('0x67'):_0x48625c[_0x8516('0x13')]=_0x8516('0x68');break;case'sounds':_0x48625c[_0x8516('0x13')]=_0x8516('0x69');break;case _0x8516('0x6a'):_0x48625c[_0x8516('0x13')]=_0x8516('0x6b');break;case _0x8516('0x6c'):_0x48625c[_0x8516('0x13')]='Template';break;case _0x8516('0x6d'):_0x48625c[_0x8516('0x13')]=_0x8516('0x6e');break;case _0x8516('0x6f'):_0x48625c['childModel']=_0x8516('0x70');break;case'variables':_0x48625c['childModel']='Variable';break;case _0x8516('0x71'):_0x48625c[_0x8516('0x13')]=_0x8516('0x72');break;case _0x8516('0x73'):_0x48625c['childModel']=_0x8516('0xf');_0x48625c[_0x8516('0x18')]=[{'name':_0x8516('0x74'),'field':'id','foreignKey':_0x8516('0x75')}];break;case _0x8516('0x76'):_0x48625c[_0x8516('0x13')]='AnalyticMetric';break;}return _0x48625c;}function _0x67013d(_0x5ca186,_0x46fc41){var _0xc2109c=_0x5ca186[_0x8516('0x77')](0x0)['toUpperCase']()+_0x5ca186[_0x8516('0x78')](0x1);var _0x185aff={'type':_0x5b97b7['Sequelize']['QueryTypes'][_0x8516('0x79')],'raw':!![]};return new Promise(function(_0x182240,_0x10b4b5){var _0x52ee5=squel[_0x8516('0x7a')]()[_0x8516('0x5')]('ui.'+_0xc2109c+_0x8516('0x7b'),'id')[_0x8516('0x5')](_0x8516('0x7c'))[_0x8516('0x7d')](_0x8516('0x7e')+_0x5ca186+_0x8516('0x7f'),'ui')[_0x8516('0x80')](_0x8516('0x81'),_0x46fc41['id']);return _0x5b97b7[_0x8516('0x82')][_0x8516('0x83')](_0x52ee5[_0x8516('0x84')](),_0x185aff)[_0x8516('0x7')](function(_0x4153bb){_0x46fc41[_0xc2109c+_0x8516('0x85')]=_0x4153bb;_0x182240(_0x4153bb);})['catch'](function(_0x842eac){_0x10b4b5(_0x842eac);});});}return _0x3d3810[_0x8516('0x86')]('UserProfile',attributes,{'tableName':'user_profiles','paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x563246){var _0x518a59=require('../../components/parsers/qs');var _0x58a6b1={'raw':_0x563246[_0x8516('0x83')][_0x8516('0x87')],'where':{}};var _0x4a859a={};var _0x1262f5={'count':0x0,'rows':[]};var _0x28647c=_0x563246[_0x8516('0x83')][_0x8516('0x88')];var _0x57ecea=_0x563246[_0x8516('0x83')][_0x8516('0x89')]||![];var _0x17f6eb=_0x2966dc(_0x28647c,_0x57ecea);if(!_0x17f6eb['childModel'])throw new Error('Invalid\x20section\x20\x27'+_0x28647c+'\x27');var _0x21fde2=[{'name':_0x28647c}];if(!_['isEmpty'](_0x17f6eb['parentSections']))_0x21fde2=_0x17f6eb[_0x8516('0x18')];var _0x15241e=[];for(var _0x3d3460=0x0;_0x3d3460<_0x21fde2['length'];_0x3d3460++){_0x15241e[_0x8516('0x8a')](_0x5b97b7[_0x8516('0x8b')][_0x8516('0x8c')]({'where':{'userProfileId':_0x563246[_0x8516('0x8d')]['id'],'name':_0x21fde2[_0x3d3460][_0x8516('0xc')]},'raw':!![]}));}return Promise[_0x8516('0x8e')](_0x15241e)[_0x8516('0x7')](function(_0x1719f5){var _0x576046=_['filter'](_0x1719f5,function(_0x53d5e4){return _0x53d5e4?_0x53d5e4:undefined;});var _0x1431bc=_[_0x8516('0x4')](_0x21fde2,[_0x8516('0x8f'),!![]]);var _0x2cfa32=_[_0x8516('0x90')](_0x576046)&&_[_0x8516('0x90')](_0x1431bc)?null:_[_0x8516('0x91')](_0x1431bc,_0x576046);if(!_0x2cfa32)return null;var _0x5a1669=[];for(var _0xb92d9a=0x0;_0xb92d9a<_0x2cfa32[_0x8516('0x92')];_0xb92d9a++){var _0x22071d=_[_0x8516('0x8c')](_0x21fde2,function(_0x3525ac){return _0x2cfa32[_0xb92d9a]?_0x3525ac[_0x8516('0xc')]===_0x2cfa32[_0xb92d9a][_0x8516('0xc')]:null;});if(_0x22071d){if(_0x2cfa32[_0xb92d9a]['ignore']){_0x5a1669[_0x8516('0x8a')](_0x5b9b47(_0x17f6eb[_0x8516('0x13')],_0x2cfa32[_0xb92d9a]));}else{if(!_0x2cfa32[_0xb92d9a]['autoAssociation']){_0x5a1669['push'](_0x2310a2(_0x22071d,_0x2cfa32[_0xb92d9a],_0x17f6eb[_0x8516('0x13')]));}else{if(_0x22071d[_0x8516('0xb')]){_0x5a1669[_0x8516('0x8a')](_0x5c48a2(_0x22071d,_0x2cfa32[_0xb92d9a]));}}}}}return Promise['all'](_0x5a1669);})[_0x8516('0x7')](function(_0x188941){var _0x5dc0c0=_0x188941;var _0x32b16d=null;if(_0x5dc0c0){_0x32b16d=_0x5dc0c0['length']===0x1?_0x5dc0c0[0x0]:null;}if(!_0x32b16d&&!_0x5dc0c0)return _0x1262f5;var _0xe5a53=_0x5b97b7[_0x17f6eb['childModel']][_0x8516('0x93')];_0x4a859a['model']=_[_0x8516('0x94')](_0xe5a53);_0x4a859a[_0x8516('0x83')]=_[_0x8516('0x94')](_0x563246[_0x8516('0x83')]);_0x4a859a[_0x8516('0x95')]=_[_0x8516('0x96')](_0x4a859a['model'],_0x4a859a[_0x8516('0x83')]);_0x58a6b1[_0x8516('0x97')]=_[_0x8516('0x96')](_0x4a859a[_0x8516('0xb')],_0x518a59[_0x8516('0x98')](_0x563246[_0x8516('0x83')][_0x8516('0x98')]));_0x58a6b1[_0x8516('0x97')]=_0x58a6b1[_0x8516('0x97')][_0x8516('0x92')]?_0x58a6b1['attributes']:_0x4a859a[_0x8516('0xb')];if(!_0x563246[_0x8516('0x83')][_0x8516('0x99')](_0x8516('0x9a'))){_0x58a6b1[_0x8516('0x9b')]=_0x518a59[_0x8516('0x9b')](_0x563246['query'][_0x8516('0x9b')]);_0x58a6b1[_0x8516('0x9c')]=_0x518a59[_0x8516('0x9c')](_0x563246[_0x8516('0x83')]['offset']);}_0x58a6b1[_0x8516('0x9d')]=_0x518a59['sort'](_0x563246[_0x8516('0x83')]['sort']);_0x58a6b1[_0x8516('0x80')]=_0x518a59['filters'](_[_0x8516('0x9e')](_0x563246[_0x8516('0x83')],_0x4a859a[_0x8516('0x95')]));if(_0x563246[_0x8516('0x83')][_0x8516('0x4')]){_0x58a6b1[_0x8516('0x80')]=_[_0x8516('0x9f')](_0x58a6b1['where'],{'$or':_[_0x8516('0x8')](_0xe5a53,function(_0x39fcfe){if(_0x39fcfe[_0x8516('0x37')][_0x8516('0xa0')]!==_0x8516('0xa1')){var _0x42a175={};_0x42a175[_0x39fcfe['field']]={'$like':'%'+_0x563246[_0x8516('0x83')]['filter']+'%'};return _0x42a175;}})});}var _0x3fa53e=[];var _0x464b1d=null;var _0x50e12a={};if(_0x32b16d){_0x464b1d=_[_0x8516('0x8c')](_0x21fde2,[_0x8516('0xc'),_0x32b16d[_0x8516('0xc')]]);if(_0x464b1d[_0x8516('0x5')]){_0x50e12a={};if(_0x17f6eb[_0x8516('0x13')]==='AnalyticExtractedReport'){_0x50e12a[_0x464b1d[_0x8516('0xa2')]]=_[_0x8516('0x8')](_0x32b16d[_0x8516('0xe')],'id');}else{_0x50e12a[_0x464b1d[_0x8516('0xa2')]]=_0x32b16d['associatedResources'];}_0x3fa53e[_0x8516('0x8a')](_0x50e12a);}else{_0x58a6b1['where']['id']=_0x32b16d[_0x8516('0xe')];}}else{for(var _0x21b5aa=0x0;_0x21b5aa<_0x5dc0c0[_0x8516('0x92')];_0x21b5aa++){_0x464b1d=_[_0x8516('0x8c')](_0x21fde2,[_0x8516('0xc'),_0x5dc0c0[_0x21b5aa][_0x8516('0xc')]]);if(_0x464b1d['field']){_0x50e12a={};_0x50e12a[_0x464b1d[_0x8516('0xa2')]]=_0x5dc0c0[_0x21b5aa][_0x8516('0xe')];_0x3fa53e[_0x8516('0x8a')](_0x50e12a);}else{if(!_0x58a6b1['where']['id'])_0x58a6b1[_0x8516('0x80')]['id']=[];_0x5dc0c0[_0x21b5aa]['associatedResources'][_0x8516('0xa3')](function(_0x42e5bc){_0x58a6b1[_0x8516('0x80')]['id'][_0x8516('0x8a')](_0x42e5bc);});}}}if(!_[_0x8516('0x90')](_0x3fa53e)){_0x58a6b1[_0x8516('0x80')]=_[_0x8516('0x9f')](_0x58a6b1[_0x8516('0x80')],{'$and':{'$or':_0x3fa53e}});}_0x58a6b1=_[_0x8516('0x9f')]({},_0x58a6b1,_0x563246[_0x8516('0xa4')]);if(_0x32b16d&&!_0x32b16d['autoAssociation']&&_0x17f6eb['childModel']===_0x8516('0xf')){if(_0x563246[_0x8516('0x83')]['includeAll']){_0x58a6b1[_0x8516('0xa5')]=[{'all':!![]}];}return _0x5b97b7[_0x17f6eb[_0x8516('0x13')]][_0x8516('0x6')](_0x58a6b1)['then'](function(_0x363504){var _0x4b0e58=[];_0x363504[_0x8516('0xa3')](function(_0x2bed02){var _0x1758bb;switch(_0x2bed02[_0x8516('0xa6')]){case _0x8516('0xa7'):_0x1758bb=_[_0x8516('0x8c')](_0x32b16d[_0x8516('0xe')],function(_0x18c825){return _0x18c825['id']===_0x2bed02['reportId']&&_0x18c825[_0x8516('0x37')]===_0x8516('0xa8');});break;case _0x8516('0xa9'):_0x1758bb=_['find'](_0x32b16d[_0x8516('0xe')],function(_0x38e60f){return _0x38e60f['id']===_0x2bed02[_0x8516('0x75')]&&_0x38e60f['type']===_0x8516('0xaa');});break;}if(_0x1758bb)_0x4b0e58[_0x8516('0x8a')](_0x2bed02);});_0x1262f5['count']=_0x4b0e58[_0x8516('0x92')];_0x1262f5['rows']=_0x4b0e58;return _0x1262f5;});}else{if(!_[_0x8516('0x90')](_0x563246[_0x8516('0x83')][_0x8516('0xab')])){_0x58a6b1[_0x8516('0x80')]['id']=_0x58a6b1['where']['id']?_[_0x8516('0x96')](_0x58a6b1[_0x8516('0x80')]['id'],_0x563246['query']['ids']):_0x563246[_0x8516('0x83')][_0x8516('0xab')];if(_0x563246['query'][_0x8516('0xac')]){_0x58a6b1['order']=_0x563246[_0x8516('0x83')]['customSorting'];}}if(_0x563246[_0x8516('0x83')][_0x8516('0xad')]){_0x58a6b1[_0x8516('0x80')]=_['merge'](_0x58a6b1[_0x8516('0x80')],{'$and':_0x563246[_0x8516('0x83')][_0x8516('0xad')]});}return _0x5b97b7[_0x17f6eb[_0x8516('0x13')]]['count']({'where':_0x58a6b1[_0x8516('0x80')]})[_0x8516('0x7')](function(_0x5101aa){_0x1262f5[_0x8516('0xae')]=_0x5101aa;if(_0x563246['query'][_0x8516('0xaf')]){if(_0x17f6eb['childModel']===_0x8516('0x1c')){_0x58a6b1[_0x8516('0xa5')]=[{'model':_0x5b97b7['Tag'],'as':_0x8516('0xb0'),'attributes':['id',_0x8516('0xc'),'color'],'required':_0x563246[_0x8516('0x83')][_0x8516('0xb1')]?!![]:![]},{'model':_0x5b97b7['Tag'],'as':'ThroughTags','attributes':['id','name',_0x8516('0xb2')],'through':_0x563246[_0x8516('0x83')]['tag']?{'attributes':[],'where':{'TagId':_0x563246[_0x8516('0x83')]['tag']||undefined}}:{},'required':_0x563246[_0x8516('0x83')][_0x8516('0xb1')]?!![]:![]}];}else{_0x58a6b1[_0x8516('0xa5')]=[{'all':!![]}];}}return _0x5b97b7[_0x17f6eb[_0x8516('0x13')]][_0x8516('0x6')](_0x58a6b1);})[_0x8516('0x7')](function(_0xe4bab0){_0x1262f5[_0x8516('0xb3')]=_0xe4bab0;if(_0x28647c===_0x8516('0x2f')&&_0x563246[_0x8516('0x83')][_0x8516('0xb4')]==='true'){var _0x17418d=[];for(var _0x40893c=0x0;_0x40893c<_0x1262f5[_0x8516('0xb3')][_0x8516('0x92')];_0x40893c++){_0x17418d[_0x8516('0x8a')](_0x67013d(_0x8516('0xb5'),_0x1262f5[_0x8516('0xb3')][_0x40893c]['dataValues']));_0x17418d[_0x8516('0x8a')](_0x67013d('sms',_0x1262f5[_0x8516('0xb3')][_0x40893c][_0x8516('0xb6')]));_0x17418d[_0x8516('0x8a')](_0x67013d(_0x8516('0xb7'),_0x1262f5['rows'][_0x40893c]['dataValues']));_0x17418d[_0x8516('0x8a')](_0x67013d(_0x8516('0xb8'),_0x1262f5['rows'][_0x40893c][_0x8516('0xb6')]));_0x17418d[_0x8516('0x8a')](_0x67013d(_0x8516('0xb9'),_0x1262f5[_0x8516('0xb3')][_0x40893c][_0x8516('0xb6')]));_0x17418d[_0x8516('0x8a')](_0x67013d('whatsapp',_0x1262f5[_0x8516('0xb3')][_0x40893c]['dataValues']));}return Promise[_0x8516('0x8e')](_0x17418d)[_0x8516('0x7')](function(){return _0x1262f5;});}return _0x1262f5;});}});}}});};