Built motion from commit 0bd120ac.|2.6.25
[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 _0xdd26=['odbc','squarerecordings','SquareRecording','parentSections','projectName','Lists','ListId','lists','CmList','companies','globalcustomfields','CmCustomField','chatqueues','ChatQueue','chatwebsites','faxqueues','faxaccounts','FaxAccount','inboundroutes','internalroutes','outboundroutes','VoiceExtension','contexts','VoiceRecording','membername','User','role','agent','Telephones','VoiceQueues','VoiceQueue','type','QueueCampaigns','queue','musiconholds','VoiceMusicOnHold','chanspies','VoiceChanSpy','voiceprefixes','VoicePrefix','Campaign','mailqueues','MailQueue','mailaccounts','MailAccount','MailSubstatus','openchannelqueues','OpenchannelQueue','openchannelaccounts','smsqueues','smsaccounts','SmsAccount','whatsappaccounts','WhatsappAccount','teams','Team','voicequeues','queuecampaigns','telephones','Users','admin','user','Agents','zendeskaccounts','ZendeskAccount','salesforceaccounts','SalesforceAccount','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','SugarcrmAccount','DeskAccount','zohoaccounts','cannedanswers','CannedAnswer','Disposition','customdashboards','Dashboard','intervals','Interval','pauses','Pause','scheduler','Sound','tags','Tag','templates','Template','Trigger','trunks','Trunk','plugins','Plugin','Reports','reportId','metrics','AnalyticMetric','charAt','toUpperCase','slice','select','ui.','InteractionId','ui.createdAt','_interactions','sequelize','OpenTabs','define','user_profiles','../../components/parsers/qs','query','section','Invalid\x20section\x20\x27','isEmpty','push','UserProfileSection','params','all','ignore','union','length','find','autoAssociation','rawAttributes','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','limit','offset','sort','where','pick','merge','key','VIRTUAL','includeAll','include','forEach','default','DefaultReports','custom','CustomReports','count','rows','ids','customSorting','order','extraQueryConditions','tag','color','openTabs','true','chat','sms','dataValues','mail','openchannel','whatsapp','./userProfile.attributes','squel','exports','models','filter','value','findAll','associatedResources','map','catch','field','model','name','resolve','UserProfileResource','then','AnalyticExtractedReport','resourceId','toLowerCase','squareprojects','childModel'];(function(_0x3660f6,_0x1a9ad1){var _0xe6b5c6=function(_0x54b9c2){while(--_0x54b9c2){_0x3660f6['push'](_0x3660f6['shift']());}};_0xe6b5c6(++_0x1a9ad1);}(_0xdd26,0xa2));var _0x6dd2=function(_0xedc9c8,_0x3f940b){_0xedc9c8=_0xedc9c8-0x0;var _0x2f120b=_0xdd26[_0xedc9c8];return _0x2f120b;};'use strict';var _=require('lodash');var attributes=require(_0x6dd2('0x0'));var squel=require(_0x6dd2('0x1'));module[_0x6dd2('0x2')]=function(_0x4080de){var _0x55400b=_0x4080de[_0x6dd2('0x3')];function _0x3aaf96(_0x199338,_0x259902){return new Promise(function(_0x37ca40,_0x59bb06){if(!_0x259902)return _0x37ca40(null);var _0x39bcfa=_0x259902[_0x6dd2('0x4')]?{[_0x259902[_0x6dd2('0x4')]['field']]:_0x259902['filter'][_0x6dd2('0x5')]}:undefined;return _0x55400b[_0x199338][_0x6dd2('0x6')]({'where':_0x39bcfa,'raw':!![]})['then'](function(_0x3ccf16){_0x259902[_0x6dd2('0x7')]=_[_0x6dd2('0x8')](_0x3ccf16,'id');_0x37ca40(_0x259902);})[_0x6dd2('0x9')](function(_0x3284d8){_0x59bb06(_0x3284d8);});});}function _0x56f967(_0x396a7f,_0xa3610a){return new Promise(function(_0x5e8de9,_0x267248){var _0x5845c1=_0x396a7f[_0x6dd2('0x4')]?{[_0x396a7f[_0x6dd2('0x4')][_0x6dd2('0xa')]]:_0x396a7f[_0x6dd2('0x4')][_0x6dd2('0x5')]}:undefined;return _0x55400b[_0x396a7f[_0x6dd2('0xb')]][_0x6dd2('0x6')]({'where':_0x5845c1,'raw':!![]})['then'](function(_0x5944bc){_0xa3610a[_0x6dd2('0x7')]=_[_0x6dd2('0x8')](_0x5944bc,function(_0x2d1840){return _0x2d1840[_0x6dd2('0xc')];});_0x5e8de9(_0xa3610a);})['catch'](function(_0x2c607c){_0x267248(_0x2c607c);});});}function _0x3f3deb(_0x1bb86c,_0x1c1133,_0x454231){if(!_0x1c1133)return Promise[_0x6dd2('0xd')](null);return new Promise(function(_0x5f14cf,_0x3f3f8b){return _0x55400b[_0x6dd2('0xe')]['findAll']({'where':{'sectionId':_0x1c1133['id']},'raw':!![]})[_0x6dd2('0xf')](function(_0x4ede64){if(_0x1bb86c['field']&&_0x1bb86c[_0x6dd2('0xa')]!=='id'){_0x1c1133[_0x6dd2('0x7')]=_[_0x6dd2('0x8')](_0x4ede64,function(_0x3d0846){return _0x3d0846[_0x1bb86c['field']];});}else{if(_0x454231===_0x6dd2('0x10')){_0x1c1133['associatedResources']=_[_0x6dd2('0x8')](_0x4ede64,function(_0x24e939){return{'id':_0x24e939[_0x6dd2('0x11')],'type':_0x24e939['type']};});}else{_0x1c1133['associatedResources']=_[_0x6dd2('0x8')](_0x4ede64,function(_0x55a04c){return _0x55a04c[_0x6dd2('0x11')];});}}_0x5f14cf(_0x1c1133);})[_0x6dd2('0x9')](function(_0x4466c2){_0x3f3f8b(_0x4466c2);});});}function _0x57fcc1(_0x2e5e9b,_0x5d542b){var _0x56b8a3={'parentSections':[]};switch(_0x2e5e9b[_0x6dd2('0x12')]()){case _0x6dd2('0x13'):_0x56b8a3[_0x6dd2('0x14')]='SquareProject';break;case _0x6dd2('0x15'):_0x56b8a3[_0x6dd2('0x14')]='SquareOdbc';break;case _0x6dd2('0x16'):_0x56b8a3['childModel']=_0x6dd2('0x17');_0x56b8a3[_0x6dd2('0x18')]=[{'name':'SquareProjects','field':'name','foreignKey':_0x6dd2('0x19')}];break;case'projects':_0x56b8a3[_0x6dd2('0x14')]='JscriptyProject';break;case'contacts':_0x56b8a3[_0x6dd2('0x14')]='CmContact';_0x56b8a3[_0x6dd2('0x18')]=[{'name':_0x6dd2('0x1a'),'field':'id','foreignKey':_0x6dd2('0x1b')}];break;case _0x6dd2('0x1c'):_0x56b8a3['childModel']=_0x6dd2('0x1d');break;case _0x6dd2('0x1e'):_0x56b8a3[_0x6dd2('0x14')]='CmCompany';break;case _0x6dd2('0x1f'):_0x56b8a3['childModel']=_0x6dd2('0x20');break;case _0x6dd2('0x21'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x22');break;case _0x6dd2('0x23'):_0x56b8a3[_0x6dd2('0x14')]='ChatWebsite';break;case _0x6dd2('0x24'):_0x56b8a3['childModel']='FaxQueue';break;case _0x6dd2('0x25'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x26');break;case _0x6dd2('0x27'):case _0x6dd2('0x28'):case _0x6dd2('0x29'):_0x56b8a3['childModel']=_0x6dd2('0x2a');break;case _0x6dd2('0x2b'):_0x56b8a3[_0x6dd2('0x14')]='VoiceContext';break;case'voicemails':_0x56b8a3[_0x6dd2('0x14')]='VoiceMail';break;case'voicerecordings':_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x2c');_0x56b8a3['parentSections']=[{'name':'Agents','field':_0x6dd2('0xc'),'foreignKey':_0x6dd2('0x2d'),'model':_0x6dd2('0x2e'),'filter':{'field':_0x6dd2('0x2f'),'value':[_0x6dd2('0x30')]}},{'name':_0x6dd2('0x31'),'field':_0x6dd2('0xc'),'foreignKey':'membername','model':_0x6dd2('0x2e'),'filter':{'field':_0x6dd2('0x2f'),'value':['telephone']}},{'name':_0x6dd2('0x32'),'field':_0x6dd2('0xc'),'foreignKey':'queue','model':_0x6dd2('0x33'),'filter':{'field':_0x6dd2('0x34'),'value':['inbound']}},{'name':_0x6dd2('0x35'),'field':_0x6dd2('0xc'),'foreignKey':_0x6dd2('0x36'),'model':_0x6dd2('0x33'),'filter':{'field':_0x6dd2('0x34'),'value':['outbound']}}];break;case _0x6dd2('0x37'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x38');break;case _0x6dd2('0x39'):_0x56b8a3['childModel']=_0x6dd2('0x3a');break;case _0x6dd2('0x3b'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x3c');break;case'ivrcampaigns':_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x3d');break;case _0x6dd2('0x3e'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x3f');break;case _0x6dd2('0x40'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x41');break;case'mailsubstatuses':_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x42');break;case _0x6dd2('0x43'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x44');break;case _0x6dd2('0x45'):_0x56b8a3[_0x6dd2('0x14')]='OpenchannelAccount';break;case _0x6dd2('0x46'):_0x56b8a3[_0x6dd2('0x14')]='SmsQueue';break;case _0x6dd2('0x47'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x48');break;case'whatsappqueues':_0x56b8a3[_0x6dd2('0x14')]='WhatsappQueue';break;case _0x6dd2('0x49'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x4a');break;case _0x6dd2('0x4b'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x4c');break;case _0x6dd2('0x4d'):case _0x6dd2('0x4e'):_0x56b8a3[_0x6dd2('0x14')]='VoiceQueue';if(_0x5d542b){_0x56b8a3[_0x6dd2('0x18')]=[{'name':_0x6dd2('0x32')},{'name':'QueueCampaigns'}];}break;case'users':case'agents':case _0x6dd2('0x4f'):_0x56b8a3['childModel']='User';if(_0x5d542b){_0x56b8a3[_0x6dd2('0x18')]=[{'name':_0x6dd2('0x50'),'filter':{'field':_0x6dd2('0x2f'),'value':[_0x6dd2('0x51'),_0x6dd2('0x52')]},'ignore':!![]},{'name':_0x6dd2('0x53')},{'name':_0x6dd2('0x31')}];}break;case _0x6dd2('0x54'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x55');break;case _0x6dd2('0x56'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x57');break;case _0x6dd2('0x58'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x59');break;case _0x6dd2('0x5a'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x5b');break;case'deskaccounts':_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x5c');break;case _0x6dd2('0x5d'):_0x56b8a3[_0x6dd2('0x14')]='ZohoAccount';break;case'vtigeraccounts':_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x2e');break;case _0x6dd2('0x5e'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x5f');break;case'dispositions':_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x60');break;case _0x6dd2('0x61'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x62');break;case _0x6dd2('0x63'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x64');break;case _0x6dd2('0x65'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x66');break;case _0x6dd2('0x67'):_0x56b8a3['childModel']='Schedule';break;case'sounds':_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x68');break;case _0x6dd2('0x69'):_0x56b8a3['childModel']=_0x6dd2('0x6a');break;case _0x6dd2('0x6b'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x6c');break;case'triggers':_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x6d');break;case _0x6dd2('0x6e'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x6f');break;case'variables':_0x56b8a3[_0x6dd2('0x14')]='Variable';break;case _0x6dd2('0x70'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x71');break;case'extractedreports':_0x56b8a3['childModel']=_0x6dd2('0x10');_0x56b8a3[_0x6dd2('0x18')]=[{'name':_0x6dd2('0x72'),'field':'id','foreignKey':_0x6dd2('0x73')}];break;case _0x6dd2('0x74'):_0x56b8a3[_0x6dd2('0x14')]=_0x6dd2('0x75');break;}return _0x56b8a3;}function _0x26ee16(_0x5dc9b,_0x2eed20){var _0x4bfa69=_0x5dc9b[_0x6dd2('0x76')](0x0)[_0x6dd2('0x77')]()+_0x5dc9b[_0x6dd2('0x78')](0x1);var _0xcc7158={'type':_0x55400b['Sequelize']['QueryTypes']['SELECT'],'raw':!![]};return new Promise(function(_0xb7a180,_0x5b9c35){var _0x358fdb=squel[_0x6dd2('0x79')]()[_0x6dd2('0xa')](_0x6dd2('0x7a')+_0x4bfa69+_0x6dd2('0x7b'),'id')['field'](_0x6dd2('0x7c'))['from']('user_has_'+_0x5dc9b+_0x6dd2('0x7d'),'ui')['where']('ui.UserId\x20=\x20?',_0x2eed20['id']);return _0x55400b[_0x6dd2('0x7e')]['query'](_0x358fdb['toString'](),_0xcc7158)['then'](function(_0x5f8d69){_0x2eed20[_0x4bfa69+_0x6dd2('0x7f')]=_0x5f8d69;_0xb7a180(_0x5f8d69);})[_0x6dd2('0x9')](function(_0x369096){_0x5b9c35(_0x369096);});});}return _0x4080de[_0x6dd2('0x80')]('UserProfile',attributes,{'tableName':_0x6dd2('0x81'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x306958){var _0x3bb6e2=require(_0x6dd2('0x82'));var _0x15e935={'raw':_0x306958[_0x6dd2('0x83')]['raw'],'where':{}};var _0x319829={};var _0x4a3752={'count':0x0,'rows':[]};var _0x37e028=_0x306958['query'][_0x6dd2('0x84')];var _0x449598=_0x306958['query']['mergeResources']||![];var _0x342d67=_0x57fcc1(_0x37e028,_0x449598);if(!_0x342d67[_0x6dd2('0x14')])throw new Error(_0x6dd2('0x85')+_0x37e028+'\x27');var _0x51bba7=[{'name':_0x37e028}];if(!_[_0x6dd2('0x86')](_0x342d67[_0x6dd2('0x18')]))_0x51bba7=_0x342d67[_0x6dd2('0x18')];var _0x38d225=[];for(var _0x404023=0x0;_0x404023<_0x51bba7['length'];_0x404023++){_0x38d225[_0x6dd2('0x87')](_0x55400b[_0x6dd2('0x88')]['find']({'where':{'userProfileId':_0x306958[_0x6dd2('0x89')]['id'],'name':_0x51bba7[_0x404023][_0x6dd2('0xc')]},'raw':!![]}));}return Promise[_0x6dd2('0x8a')](_0x38d225)[_0x6dd2('0xf')](function(_0x622a68){var _0x3086bc=_['filter'](_0x622a68,function(_0x3a669c){return _0x3a669c?_0x3a669c:undefined;});var _0x151d1a=_['filter'](_0x51bba7,[_0x6dd2('0x8b'),!![]]);var _0x197f5d=_[_0x6dd2('0x86')](_0x3086bc)&&_['isEmpty'](_0x151d1a)?null:_[_0x6dd2('0x8c')](_0x151d1a,_0x3086bc);if(!_0x197f5d)return null;var _0x3dc319=[];for(var _0x26d7b8=0x0;_0x26d7b8<_0x197f5d[_0x6dd2('0x8d')];_0x26d7b8++){var _0x177642=_[_0x6dd2('0x8e')](_0x51bba7,function(_0x184949){return _0x197f5d[_0x26d7b8]?_0x184949[_0x6dd2('0xc')]===_0x197f5d[_0x26d7b8][_0x6dd2('0xc')]:null;});if(_0x177642){if(_0x197f5d[_0x26d7b8]['ignore']){_0x3dc319[_0x6dd2('0x87')](_0x3aaf96(_0x342d67[_0x6dd2('0x14')],_0x197f5d[_0x26d7b8]));}else{if(!_0x197f5d[_0x26d7b8][_0x6dd2('0x8f')]){_0x3dc319[_0x6dd2('0x87')](_0x3f3deb(_0x177642,_0x197f5d[_0x26d7b8],_0x342d67[_0x6dd2('0x14')]));}else{if(_0x177642[_0x6dd2('0xb')]){_0x3dc319['push'](_0x56f967(_0x177642,_0x197f5d[_0x26d7b8]));}}}}}return Promise[_0x6dd2('0x8a')](_0x3dc319);})[_0x6dd2('0xf')](function(_0x500fa0){var _0x6e71de=_0x500fa0;var _0x182c83=null;if(_0x6e71de){_0x182c83=_0x6e71de[_0x6dd2('0x8d')]===0x1?_0x6e71de[0x0]:null;}if(!_0x182c83&&!_0x6e71de)return _0x4a3752;var _0x53c347=_0x55400b[_0x342d67[_0x6dd2('0x14')]][_0x6dd2('0x90')];_0x319829[_0x6dd2('0xb')]=_['keys'](_0x53c347);_0x319829[_0x6dd2('0x83')]=_[_0x6dd2('0x91')](_0x306958['query']);_0x319829[_0x6dd2('0x92')]=_[_0x6dd2('0x93')](_0x319829[_0x6dd2('0xb')],_0x319829[_0x6dd2('0x83')]);_0x15e935[_0x6dd2('0x94')]=_['intersection'](_0x319829['model'],_0x3bb6e2[_0x6dd2('0x95')](_0x306958[_0x6dd2('0x83')][_0x6dd2('0x95')]));_0x15e935[_0x6dd2('0x94')]=_0x15e935[_0x6dd2('0x94')][_0x6dd2('0x8d')]?_0x15e935[_0x6dd2('0x94')]:_0x319829[_0x6dd2('0xb')];if(!_0x306958[_0x6dd2('0x83')][_0x6dd2('0x96')](_0x6dd2('0x97'))){_0x15e935[_0x6dd2('0x98')]=_0x3bb6e2[_0x6dd2('0x98')](_0x306958[_0x6dd2('0x83')][_0x6dd2('0x98')]);_0x15e935[_0x6dd2('0x99')]=_0x3bb6e2[_0x6dd2('0x99')](_0x306958[_0x6dd2('0x83')]['offset']);}_0x15e935['order']=_0x3bb6e2[_0x6dd2('0x9a')](_0x306958[_0x6dd2('0x83')][_0x6dd2('0x9a')]);_0x15e935[_0x6dd2('0x9b')]=_0x3bb6e2[_0x6dd2('0x92')](_[_0x6dd2('0x9c')](_0x306958['query'],_0x319829[_0x6dd2('0x92')]));if(_0x306958[_0x6dd2('0x83')][_0x6dd2('0x4')]){_0x15e935[_0x6dd2('0x9b')]=_[_0x6dd2('0x9d')](_0x15e935[_0x6dd2('0x9b')],{'$or':_[_0x6dd2('0x8')](_0x53c347,function(_0x228402){if(_0x228402[_0x6dd2('0x34')][_0x6dd2('0x9e')]!==_0x6dd2('0x9f')){var _0x2663df={};_0x2663df[_0x228402['field']]={'$like':'%'+_0x306958[_0x6dd2('0x83')][_0x6dd2('0x4')]+'%'};return _0x2663df;}})});}var _0x2584cb=[];var _0x1bf89b=null;var _0x4dc897={};if(_0x182c83){_0x1bf89b=_['find'](_0x51bba7,[_0x6dd2('0xc'),_0x182c83[_0x6dd2('0xc')]]);if(_0x1bf89b[_0x6dd2('0xa')]){_0x4dc897={};if(_0x342d67[_0x6dd2('0x14')]===_0x6dd2('0x10')){_0x4dc897[_0x1bf89b['foreignKey']]=_[_0x6dd2('0x8')](_0x182c83[_0x6dd2('0x7')],'id');}else{_0x4dc897[_0x1bf89b['foreignKey']]=_0x182c83['associatedResources'];}_0x2584cb[_0x6dd2('0x87')](_0x4dc897);}else{_0x15e935[_0x6dd2('0x9b')]['id']=_0x182c83[_0x6dd2('0x7')];}}else{for(var _0x50e439=0x0;_0x50e439<_0x6e71de[_0x6dd2('0x8d')];_0x50e439++){_0x1bf89b=_['find'](_0x51bba7,[_0x6dd2('0xc'),_0x6e71de[_0x50e439][_0x6dd2('0xc')]]);if(_0x1bf89b[_0x6dd2('0xa')]){_0x4dc897={};_0x4dc897[_0x1bf89b['foreignKey']]=_0x6e71de[_0x50e439][_0x6dd2('0x7')];_0x2584cb[_0x6dd2('0x87')](_0x4dc897);}else{if(!_0x15e935[_0x6dd2('0x9b')]['id'])_0x15e935[_0x6dd2('0x9b')]['id']=[];_0x6e71de[_0x50e439][_0x6dd2('0x7')]['forEach'](function(_0x611e78){_0x15e935[_0x6dd2('0x9b')]['id'][_0x6dd2('0x87')](_0x611e78);});}}}if(!_[_0x6dd2('0x86')](_0x2584cb)){_0x15e935['where']=_[_0x6dd2('0x9d')](_0x15e935[_0x6dd2('0x9b')],{'$and':{'$or':_0x2584cb}});}_0x15e935=_[_0x6dd2('0x9d')]({},_0x15e935,_0x306958['options']);if(_0x182c83&&!_0x182c83[_0x6dd2('0x8f')]&&_0x342d67[_0x6dd2('0x14')]===_0x6dd2('0x10')){if(_0x306958[_0x6dd2('0x83')][_0x6dd2('0xa0')]){_0x15e935[_0x6dd2('0xa1')]=[{'all':!![]}];}return _0x55400b[_0x342d67[_0x6dd2('0x14')]][_0x6dd2('0x6')](_0x15e935)[_0x6dd2('0xf')](function(_0x106c27){var _0x19a767=[];_0x106c27[_0x6dd2('0xa2')](function(_0x5a960d){var _0x3abed3;switch(_0x5a960d['reportType']){case _0x6dd2('0xa3'):_0x3abed3=_[_0x6dd2('0x8e')](_0x182c83[_0x6dd2('0x7')],function(_0x5e19d4){return _0x5e19d4['id']===_0x5a960d['reportId']&&_0x5e19d4[_0x6dd2('0x34')]===_0x6dd2('0xa4');});break;case _0x6dd2('0xa5'):_0x3abed3=_[_0x6dd2('0x8e')](_0x182c83[_0x6dd2('0x7')],function(_0x484b10){return _0x484b10['id']===_0x5a960d['reportId']&&_0x484b10[_0x6dd2('0x34')]===_0x6dd2('0xa6');});break;}if(_0x3abed3)_0x19a767['push'](_0x5a960d);});_0x4a3752[_0x6dd2('0xa7')]=_0x19a767[_0x6dd2('0x8d')];_0x4a3752[_0x6dd2('0xa8')]=_0x19a767;return _0x4a3752;});}else{if(!_['isEmpty'](_0x306958[_0x6dd2('0x83')][_0x6dd2('0xa9')])){_0x15e935[_0x6dd2('0x9b')]['id']=_0x15e935[_0x6dd2('0x9b')]['id']?_['intersection'](_0x15e935[_0x6dd2('0x9b')]['id'],_0x306958[_0x6dd2('0x83')]['ids']):_0x306958['query'][_0x6dd2('0xa9')];if(_0x306958[_0x6dd2('0x83')][_0x6dd2('0xaa')]){_0x15e935[_0x6dd2('0xab')]=_0x306958[_0x6dd2('0x83')]['customSorting'];}}if(_0x306958[_0x6dd2('0x83')][_0x6dd2('0xac')]){_0x15e935[_0x6dd2('0x9b')]=_[_0x6dd2('0x9d')](_0x15e935[_0x6dd2('0x9b')],{'$and':_0x306958[_0x6dd2('0x83')]['extraQueryConditions']});}return _0x55400b[_0x342d67[_0x6dd2('0x14')]]['count']({'where':_0x15e935[_0x6dd2('0x9b')]})['then'](function(_0x4a1dc3){_0x4a3752[_0x6dd2('0xa7')]=_0x4a1dc3;if(_0x306958[_0x6dd2('0x83')]['includeAll']){if(_0x342d67[_0x6dd2('0x14')]==='CmContact'){_0x15e935['include']=[{'model':_0x55400b['Tag'],'as':'Tags','attributes':['id',_0x6dd2('0xc'),'color'],'required':_0x306958[_0x6dd2('0x83')][_0x6dd2('0xad')]?!![]:![]},{'model':_0x55400b[_0x6dd2('0x6a')],'as':'ThroughTags','attributes':['id',_0x6dd2('0xc'),_0x6dd2('0xae')],'through':_0x306958['query']['tag']?{'attributes':[],'where':{'TagId':_0x306958['query'][_0x6dd2('0xad')]||undefined}}:{},'required':_0x306958['query'][_0x6dd2('0xad')]?!![]:![]}];}else{_0x15e935['include']=[{'all':!![]}];}}return _0x55400b[_0x342d67[_0x6dd2('0x14')]][_0x6dd2('0x6')](_0x15e935);})['then'](function(_0xd47f84){_0x4a3752['rows']=_0xd47f84;if(_0x37e028===_0x6dd2('0x53')&&_0x306958[_0x6dd2('0x83')][_0x6dd2('0xaf')]===_0x6dd2('0xb0')){var _0x4d402c=[];for(var _0xf473ec=0x0;_0xf473ec<_0x4a3752[_0x6dd2('0xa8')][_0x6dd2('0x8d')];_0xf473ec++){_0x4d402c[_0x6dd2('0x87')](_0x26ee16(_0x6dd2('0xb1'),_0x4a3752['rows'][_0xf473ec]['dataValues']));_0x4d402c[_0x6dd2('0x87')](_0x26ee16(_0x6dd2('0xb2'),_0x4a3752['rows'][_0xf473ec][_0x6dd2('0xb3')]));_0x4d402c['push'](_0x26ee16('fax',_0x4a3752[_0x6dd2('0xa8')][_0xf473ec]['dataValues']));_0x4d402c[_0x6dd2('0x87')](_0x26ee16(_0x6dd2('0xb4'),_0x4a3752[_0x6dd2('0xa8')][_0xf473ec]['dataValues']));_0x4d402c[_0x6dd2('0x87')](_0x26ee16(_0x6dd2('0xb5'),_0x4a3752[_0x6dd2('0xa8')][_0xf473ec]['dataValues']));_0x4d402c[_0x6dd2('0x87')](_0x26ee16(_0x6dd2('0xb6'),_0x4a3752[_0x6dd2('0xa8')][_0xf473ec][_0x6dd2('0xb3')]));}return Promise[_0x6dd2('0x8a')](_0x4d402c)[_0x6dd2('0xf')](function(){return _0x4a3752;});}return _0x4a3752;});}});}}});};