fe1dca0fa889e28e7eb73db334ddb89ca1ab4494
[motion2.git] / server / api / dashboard / dashboard.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 _0x068d=['update','then','destroy','get','CustomDashboards','end','sendStatus','name','map','fieldName','key','model','query','keys','filters','intersection','attributes','fields','nolimit','order','sort','where','pick','filter','VIRTUAL','merge','options','Dashboard','includeAll','include','findAll','rows','catch','show','params','length','find','create','body','user','userProfileId','UserProfileResource','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','createdAt','updatedAt','omit','role','autoAssociation','type','attrs','value','https://','custom','attrPath','attrHourFormat','HH:mm:ss','attrTimezone','0.00','attrFontSize','counter','attrMetric','total','attrVoiceQueues','attrChannel','attrEmailAccounts','attrFaxAccounts','attrOpenchannelAccounts','attrWhatsappAccounts','attrChatWebsites','multibar-chart','attrSerie1','attrSerie2','voice','attrSmsAccounts','attrReport','reportType','attrRefresh','widgetAttributes:\x20%s','addItem','DashboardId','DashboardItem','getItems','findOne','rawAttributes','hasOwnProperty','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','squel','desk.js','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','socket.io-emitter','./dashboard.socket','register','status','json','offset','undefined','count','limit','set','Content-Range','apply','reject','save'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0x068d,0x157));var _0xd068=function(_0x3ae0d0,_0xe5c56d){_0x3ae0d0=_0x3ae0d0-0x0;var _0x2eaf1c=_0x068d[_0x3ae0d0];return _0x2eaf1c;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xd068('0x0'));var zipdir=require(_0xd068('0x1'));var jsonpatch=require(_0xd068('0x2'));var rp=require('request-promise');var moment=require(_0xd068('0x3'));var BPromise=require(_0xd068('0x4'));var Mustache=require(_0xd068('0x5'));var util=require(_0xd068('0x6'));var path=require(_0xd068('0x7'));var sox=require(_0xd068('0x8'));var csv=require(_0xd068('0x9'));var ejs=require(_0xd068('0xa'));var fs=require('fs');var fs_extra=require(_0xd068('0xb'));var _=require('lodash');var squel=require(_0xd068('0xc'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0xd068('0xd'));var toCsv=require(_0xd068('0x9'));var querystring=require('querystring');var Papa=require(_0xd068('0xe'));var Redis=require(_0xd068('0xf'));var authService=require('../../components/auth/service');var qs=require(_0xd068('0x10'));var as=require(_0xd068('0x11'));var hardwareService=require(_0xd068('0x12'));var logger=require(_0xd068('0x13'))(_0xd068('0x14'));var utils=require(_0xd068('0x15'));var config=require(_0xd068('0x16'));var licenseUtil=require(_0xd068('0x17'));var db=require(_0xd068('0x18'))['db'];config[_0xd068('0x19')]=_[_0xd068('0x1a')](config[_0xd068('0x19')],{'host':'localhost','port':0x18eb});var socket=require(_0xd068('0x1b'))(new Redis(config[_0xd068('0x19')]));require(_0xd068('0x1c'))[_0xd068('0x1d')](socket);function respondWithStatusCode(_0x29665a,_0x4b00e8){_0x4b00e8=_0x4b00e8||0xcc;return function(_0x32c8ed){if(_0x32c8ed){return _0x29665a['sendStatus'](_0x4b00e8);}return _0x29665a[_0xd068('0x1e')](_0x4b00e8)['end']();};}function respondWithResult(_0x33a395,_0x1d9a61){_0x1d9a61=_0x1d9a61||0xc8;return function(_0x25d5f5){if(_0x25d5f5){return _0x33a395[_0xd068('0x1e')](_0x1d9a61)[_0xd068('0x1f')](_0x25d5f5);}};}function respondWithFilteredResult(_0x159c06,_0x166138){return function(_0x144dc3){if(_0x144dc3){var _0x10061a=typeof _0x166138[_0xd068('0x20')]===_0xd068('0x21')&&typeof _0x166138['limit']===_0xd068('0x21');var _0x5a9eea=_0x144dc3['count'];var _0x41521d=_0x10061a?0x0:_0x166138[_0xd068('0x20')];var _0x5b09c9=_0x10061a?_0x144dc3[_0xd068('0x22')]:_0x166138['offset']+_0x166138[_0xd068('0x23')];var _0x17d844;if(_0x5b09c9>=_0x5a9eea){_0x5b09c9=_0x5a9eea;_0x17d844=0xc8;}else{_0x17d844=0xce;}_0x159c06[_0xd068('0x1e')](_0x17d844);return _0x159c06[_0xd068('0x24')](_0xd068('0x25'),_0x41521d+'-'+_0x5b09c9+'/'+_0x5a9eea)[_0xd068('0x1f')](_0x144dc3);}return null;};}function patchUpdates(_0x3543e2){return function(_0x472b21){try{jsonpatch[_0xd068('0x26')](_0x472b21,_0x3543e2,!![]);}catch(_0x1cebfb){return BPromise[_0xd068('0x27')](_0x1cebfb);}return _0x472b21[_0xd068('0x28')]();};}function saveUpdates(_0x3a89af,_0x4a4a7f){return function(_0x1e8616){if(_0x1e8616){return _0x1e8616[_0xd068('0x29')](_0x3a89af)[_0xd068('0x2a')](function(_0x298a90){return _0x298a90;});}return null;};}function removeEntity(_0x45d5ca,_0x18b91e){return function(_0x4f4e4e){if(_0x4f4e4e){return _0x4f4e4e[_0xd068('0x2b')]()[_0xd068('0x2a')](function(){var _0x2e70de=_0x4f4e4e[_0xd068('0x2c')]({'plain':!![]});var _0x168c59=_0xd068('0x2d');return db['UserProfileResource']['destroy']({'where':{'type':_0x168c59,'resourceId':_0x2e70de['id']}})[_0xd068('0x2a')](function(){return _0x4f4e4e;});})[_0xd068('0x2a')](function(){_0x45d5ca['status'](0xcc)[_0xd068('0x2e')]();});}};}function handleEntityNotFound(_0x185933,_0x45de25){return function(_0x32d1a3){if(!_0x32d1a3){_0x185933[_0xd068('0x2f')](0x194);}return _0x32d1a3;};}function handleError(_0x42536e,_0x2749e0){_0x2749e0=_0x2749e0||0x1f4;return function(_0x163bcb){logger['error'](_0x163bcb['stack']);if(_0x163bcb[_0xd068('0x30')]){delete _0x163bcb[_0xd068('0x30')];}_0x42536e[_0xd068('0x1e')](_0x2749e0)['send'](_0x163bcb);};}exports['index']=function(_0x5aa7d6,_0x3e1005){var _0x3ccb98={},_0x56ef6c={},_0x4b8a2b={'count':0x0,'rows':[]};var _0x2a3980=_[_0xd068('0x31')](db['Dashboard']['rawAttributes'],function(_0x3b54ab){return{'name':_0x3b54ab[_0xd068('0x32')],'type':_0x3b54ab['type'][_0xd068('0x33')]};});_0x56ef6c[_0xd068('0x34')]=_[_0xd068('0x31')](_0x2a3980,_0xd068('0x30'));_0x56ef6c[_0xd068('0x35')]=_[_0xd068('0x36')](_0x5aa7d6[_0xd068('0x35')]);_0x56ef6c[_0xd068('0x37')]=_[_0xd068('0x38')](_0x56ef6c['model'],_0x56ef6c[_0xd068('0x35')]);_0x3ccb98[_0xd068('0x39')]=_['intersection'](_0x56ef6c[_0xd068('0x34')],qs[_0xd068('0x3a')](_0x5aa7d6[_0xd068('0x35')][_0xd068('0x3a')]));_0x3ccb98[_0xd068('0x39')]=_0x3ccb98[_0xd068('0x39')]['length']?_0x3ccb98[_0xd068('0x39')]:_0x56ef6c[_0xd068('0x34')];if(!_0x5aa7d6[_0xd068('0x35')]['hasOwnProperty'](_0xd068('0x3b'))){_0x3ccb98[_0xd068('0x23')]=qs[_0xd068('0x23')](_0x5aa7d6[_0xd068('0x35')][_0xd068('0x23')]);_0x3ccb98['offset']=qs[_0xd068('0x20')](_0x5aa7d6['query']['offset']);}_0x3ccb98[_0xd068('0x3c')]=qs[_0xd068('0x3d')](_0x5aa7d6[_0xd068('0x35')]['sort']);_0x3ccb98[_0xd068('0x3e')]=qs[_0xd068('0x37')](_[_0xd068('0x3f')](_0x5aa7d6[_0xd068('0x35')],_0x56ef6c[_0xd068('0x37')]),_0x2a3980);if(_0x5aa7d6[_0xd068('0x35')][_0xd068('0x40')]){_0x3ccb98[_0xd068('0x3e')]=_['merge'](_0x3ccb98[_0xd068('0x3e')],{'$or':_['map'](_0x2a3980,function(_0x4c1356){if(_0x4c1356['type']!==_0xd068('0x41')){var _0x4dc30a={};_0x4dc30a[_0x4c1356[_0xd068('0x30')]]={'$like':'%'+_0x5aa7d6[_0xd068('0x35')][_0xd068('0x40')]+'%'};return _0x4dc30a;}})});}_0x3ccb98=_[_0xd068('0x42')]({},_0x3ccb98,_0x5aa7d6[_0xd068('0x43')]);var _0x247685={'where':_0x3ccb98[_0xd068('0x3e')]};return db[_0xd068('0x44')][_0xd068('0x22')](_0x247685)[_0xd068('0x2a')](function(_0x55a435){_0x4b8a2b[_0xd068('0x22')]=_0x55a435;if(_0x5aa7d6[_0xd068('0x35')][_0xd068('0x45')]){_0x3ccb98[_0xd068('0x46')]=[{'all':!![]}];}return db[_0xd068('0x44')][_0xd068('0x47')](_0x3ccb98);})[_0xd068('0x2a')](function(_0x305081){_0x4b8a2b[_0xd068('0x48')]=_0x305081;return _0x4b8a2b;})[_0xd068('0x2a')](respondWithFilteredResult(_0x3e1005,_0x3ccb98))[_0xd068('0x49')](handleError(_0x3e1005,null));};exports[_0xd068('0x4a')]=function(_0x1c27a7,_0x23385b){var _0x57abf1={'raw':![],'where':{'id':_0x1c27a7[_0xd068('0x4b')]['id']}},_0x33fcaf={};_0x33fcaf['model']=_['keys'](db[_0xd068('0x44')]['rawAttributes']);_0x33fcaf[_0xd068('0x35')]=_[_0xd068('0x36')](_0x1c27a7[_0xd068('0x35')]);_0x33fcaf[_0xd068('0x37')]=_[_0xd068('0x38')](_0x33fcaf[_0xd068('0x34')],_0x33fcaf[_0xd068('0x35')]);_0x57abf1['attributes']=_[_0xd068('0x38')](_0x33fcaf[_0xd068('0x34')],qs[_0xd068('0x3a')](_0x1c27a7[_0xd068('0x35')][_0xd068('0x3a')]));_0x57abf1[_0xd068('0x39')]=_0x57abf1[_0xd068('0x39')][_0xd068('0x4c')]?_0x57abf1['attributes']:_0x33fcaf['model'];if(_0x1c27a7[_0xd068('0x35')][_0xd068('0x45')]){_0x57abf1['include']=[{'all':!![]}];}_0x57abf1=_[_0xd068('0x42')]({},_0x57abf1,_0x1c27a7[_0xd068('0x43')]);return db[_0xd068('0x44')][_0xd068('0x4d')](_0x57abf1)[_0xd068('0x2a')](handleEntityNotFound(_0x23385b,null))['then'](respondWithResult(_0x23385b,null))['catch'](handleError(_0x23385b,null));};exports[_0xd068('0x4e')]=function(_0x51c07b,_0x10246c){return db[_0xd068('0x44')]['create'](_0x51c07b[_0xd068('0x4f')],{})['then'](function(_0x164c69){var _0x2fd929=_0x51c07b[_0xd068('0x50')][_0xd068('0x2c')]({'plain':!![]});if(!_0x2fd929)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x2fd929['role']===_0xd068('0x50')){var _0x1dd309=_0x164c69[_0xd068('0x2c')]({'plain':!![]});var _0x53a9f9=_0xd068('0x2d');return db['UserProfileSection'][_0xd068('0x4d')]({'where':{'name':_0x53a9f9,'userProfileId':_0x2fd929[_0xd068('0x51')]},'raw':!![]})['then'](function(_0x168480){if(_0x168480&&_0x168480['autoAssociation']===0x0){return db[_0xd068('0x52')][_0xd068('0x4e')]({'name':_0x1dd309[_0xd068('0x30')],'resourceId':_0x1dd309['id'],'type':_0x168480[_0xd068('0x30')],'sectionId':_0x168480['id']},{})['then'](function(){return _0x164c69;});}else{return _0x164c69;}})[_0xd068('0x49')](function(_0x3422a1){logger[_0xd068('0x53')](_0xd068('0x54'),_0x3422a1);throw _0x3422a1;});}return _0x164c69;})[_0xd068('0x2a')](respondWithResult(_0x10246c,0xc9))[_0xd068('0x49')](handleError(_0x10246c,null));};exports[_0xd068('0x55')]=function(_0x217e8a,_0x29da6e){var _0x4af6fc={'where':{'id':_0x217e8a[_0xd068('0x4b')]['id']}},_0x1cd315={};_0x1cd315[_0xd068('0x34')]=_[_0xd068('0x36')](db[_0xd068('0x44')]['rawAttributes']);_0x4af6fc[_0xd068('0x39')]=_[_0xd068('0x38')](_0x1cd315[_0xd068('0x34')],qs[_0xd068('0x3a')](_0x217e8a[_0xd068('0x35')][_0xd068('0x3a')]));_0x4af6fc[_0xd068('0x39')]=_0x4af6fc[_0xd068('0x39')][_0xd068('0x4c')]?_0x4af6fc[_0xd068('0x39')]:_0x1cd315[_0xd068('0x34')];if(_0x217e8a[_0xd068('0x35')]['includeAll']){_0x4af6fc[_0xd068('0x46')]=[{'all':!![]}];}_0x4af6fc=_[_0xd068('0x42')]({},_0x4af6fc,_0x217e8a['options']);return db[_0xd068('0x44')]['find'](_0x4af6fc)[_0xd068('0x2a')](handleEntityNotFound(_0x29da6e,null))[_0xd068('0x2a')](function(_0xbc7a47){if(_0xbc7a47){var _0xcffa9b=_0xbc7a47[_0xd068('0x2c')]({'plain':!![]});_0xcffa9b=qs['omit'](_0xcffa9b,['id',_0xd068('0x56'),_0xd068('0x57')]);_0x217e8a[_0xd068('0x4f')]=_[_0xd068('0x58')](_0x217e8a[_0xd068('0x4f')],['id',_0xd068('0x56'),_0xd068('0x57')]);return db[_0xd068('0x44')][_0xd068('0x4e')](_[_0xd068('0x42')](_0xcffa9b,_0x217e8a[_0xd068('0x4f')]),{'include':_0x217e8a[_0xd068('0x35')][_0xd068('0x45')]?[{'all':!![]}]:undefined})[_0xd068('0x2a')](function(_0x389f32){var _0x29cd6e=_0x217e8a[_0xd068('0x50')][_0xd068('0x2c')]({'plain':!![]});if(!_0x29cd6e)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x29cd6e[_0xd068('0x59')]===_0xd068('0x50')){var _0x3bb653=_0x389f32[_0xd068('0x2c')]({'plain':!![]});var _0x1e6958='CustomDashboards';return db['UserProfileSection'][_0xd068('0x4d')]({'where':{'name':_0x1e6958,'userProfileId':_0x29cd6e[_0xd068('0x51')]},'raw':!![]})['then'](function(_0x457303){if(_0x457303&&_0x457303[_0xd068('0x5a')]===0x0){return db['UserProfileResource'][_0xd068('0x4e')]({'name':_0x3bb653[_0xd068('0x30')],'resourceId':_0x3bb653['id'],'type':_0x457303['name'],'sectionId':_0x457303['id']},{})['then'](function(){return _0x389f32;});}else{return _0x389f32;}})[_0xd068('0x49')](function(_0x35f41c){logger['error'](_0xd068('0x54'),_0x35f41c);throw _0x35f41c;});}return _0x389f32;});}})['then'](respondWithResult(_0x29da6e,0xc9))[_0xd068('0x49')](handleError(_0x29da6e,null));};exports[_0xd068('0x29')]=function(_0x2f23c1,_0x3a640e){if(_0x2f23c1['body']['id']){delete _0x2f23c1[_0xd068('0x4f')]['id'];}return db[_0xd068('0x44')][_0xd068('0x4d')]({'where':{'id':_0x2f23c1[_0xd068('0x4b')]['id']}})[_0xd068('0x2a')](handleEntityNotFound(_0x3a640e,null))[_0xd068('0x2a')](saveUpdates(_0x2f23c1['body'],null))[_0xd068('0x2a')](respondWithResult(_0x3a640e,null))[_0xd068('0x49')](handleError(_0x3a640e,null));};exports[_0xd068('0x2b')]=function(_0x426e0f,_0x1910f5){return db['Dashboard'][_0xd068('0x4d')]({'where':{'id':_0x426e0f[_0xd068('0x4b')]['id']}})[_0xd068('0x2a')](handleEntityNotFound(_0x1910f5,null))[_0xd068('0x2a')](removeEntity(_0x1910f5,null))['catch'](handleError(_0x1910f5,null));};function widgetAttributes(_0x655ec4){try{switch(_0x655ec4[_0xd068('0x5b')]){case'iframe':return[{'name':'attrUrl','value':_0x655ec4['attrUrl']||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4[_0xd068('0x5c')][0x0]?_0x655ec4[_0xd068('0x5c')][0x0][_0xd068('0x5d')]:undefined)||_0xd068('0x5e')}];case _0xd068('0x5f'):return[{'name':_0xd068('0x60'),'value':_0x655ec4[_0xd068('0x60')]||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4[_0xd068('0x5c')][0x0]?_0x655ec4['attrs'][0x0][_0xd068('0x5d')]:undefined)||''}];case'clock':return[{'name':_0xd068('0x61'),'value':_0x655ec4['attrHourFormat']||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4[_0xd068('0x5c')][0x0]?_0x655ec4[_0xd068('0x5c')][0x0][_0xd068('0x5d')]:undefined)||_0xd068('0x62')},{'name':_0xd068('0x63'),'value':_0x655ec4['attrTimezone']||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4[_0xd068('0x5c')][0x1]?_0x655ec4[_0xd068('0x5c')][0x1][_0xd068('0x5d')]:undefined)||_0xd068('0x64')},{'name':'attrFontSize','value':_0x655ec4[_0xd068('0x65')]||(_0x655ec4['attrs']&&_0x655ec4['attrs'][0x2]?_0x655ec4[_0xd068('0x5c')][0x2][_0xd068('0x5d')]:undefined)||0xc}];case _0xd068('0x66'):return[{'name':_0xd068('0x67'),'value':_0x655ec4[_0xd068('0x67')]||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4[_0xd068('0x5c')][0x0]?_0x655ec4['attrs'][0x0][_0xd068('0x5d')]:undefined)||_0xd068('0x68')},{'name':_0xd068('0x69'),'value':_0x655ec4[_0xd068('0x69')]||(_0x655ec4['attrs']&&_0x655ec4[_0xd068('0x5c')][0x1]?_0x655ec4[_0xd068('0x5c')][0x1][_0xd068('0x5d')]:undefined)||[]},{'name':_0xd068('0x65'),'value':_0x655ec4[_0xd068('0x65')]||(_0x655ec4['attrs']&&_0x655ec4[_0xd068('0x5c')][0x2]?_0x655ec4[_0xd068('0x5c')][0x2][_0xd068('0x5d')]:undefined)||0x14},{'name':_0xd068('0x6a'),'value':_0x655ec4[_0xd068('0x6a')]||(_0x655ec4['attrs']&&_0x655ec4['attrs'][0x3]?_0x655ec4[_0xd068('0x5c')][0x3][_0xd068('0x5d')]:undefined)||'voice'},{'name':'attrEmailAccounts','value':_0x655ec4[_0xd068('0x6b')]||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4[_0xd068('0x5c')][0x4]?_0x655ec4[_0xd068('0x5c')][0x4]['value']:undefined)||''},{'name':_0xd068('0x6c'),'value':_0x655ec4[_0xd068('0x6c')]||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4[_0xd068('0x5c')][0x5]?_0x655ec4[_0xd068('0x5c')][0x5]['value']:undefined)||''},{'name':'attrSmsAccounts','value':_0x655ec4['attrSmsAccounts']||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4[_0xd068('0x5c')][0x6]?_0x655ec4['attrs'][0x6][_0xd068('0x5d')]:undefined)||''},{'name':_0xd068('0x6d'),'value':_0x655ec4[_0xd068('0x6d')]||(_0x655ec4['attrs']&&_0x655ec4[_0xd068('0x5c')][0x7]?_0x655ec4[_0xd068('0x5c')][0x7][_0xd068('0x5d')]:undefined)||''},{'name':_0xd068('0x6e'),'value':_0x655ec4[_0xd068('0x6e')]||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4[_0xd068('0x5c')][0x8]?_0x655ec4[_0xd068('0x5c')][0x8]['value']:undefined)||''},{'name':_0xd068('0x6f'),'value':_0x655ec4[_0xd068('0x6f')]||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4[_0xd068('0x5c')][0x9]?_0x655ec4[_0xd068('0x5c')][0x9]['value']:undefined)||''}];case _0xd068('0x70'):case'pie-chart':return[{'name':_0xd068('0x71'),'value':_0x655ec4['attrSerie1']||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4[_0xd068('0x5c')][0x0]?_0x655ec4[_0xd068('0x5c')][0x0][_0xd068('0x5d')]:undefined)||_0xd068('0x68')},{'name':_0xd068('0x72'),'value':_0x655ec4['attrSerie2']||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4[_0xd068('0x5c')][0x1]?_0x655ec4['attrs'][0x1][_0xd068('0x5d')]:undefined)||null},{'name':'attrSerie3','value':_0x655ec4['attrSerie3']||(_0x655ec4['attrs']&&_0x655ec4['attrs'][0x2]?_0x655ec4[_0xd068('0x5c')][0x2][_0xd068('0x5d')]:undefined)||null},{'name':_0xd068('0x69'),'value':_0x655ec4[_0xd068('0x69')]||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4[_0xd068('0x5c')][0x3]?_0x655ec4[_0xd068('0x5c')][0x3][_0xd068('0x5d')]:undefined)||[]},{'name':_0xd068('0x6a'),'value':_0x655ec4['attrChannel']||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4['attrs'][0x4]?_0x655ec4[_0xd068('0x5c')][0x4][_0xd068('0x5d')]:undefined)||_0xd068('0x73')},{'name':_0xd068('0x6b'),'value':_0x655ec4[_0xd068('0x6b')]||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4[_0xd068('0x5c')][0x5]?_0x655ec4[_0xd068('0x5c')][0x5][_0xd068('0x5d')]:undefined)||''},{'name':_0xd068('0x6c'),'value':_0x655ec4[_0xd068('0x6c')]||(_0x655ec4['attrs']&&_0x655ec4['attrs'][0x6]?_0x655ec4[_0xd068('0x5c')][0x6]['value']:undefined)||''},{'name':_0xd068('0x74'),'value':_0x655ec4[_0xd068('0x74')]||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4[_0xd068('0x5c')][0x7]?_0x655ec4[_0xd068('0x5c')][0x7][_0xd068('0x5d')]:undefined)||''},{'name':_0xd068('0x6d'),'value':_0x655ec4[_0xd068('0x6d')]||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4[_0xd068('0x5c')][0x8]?_0x655ec4['attrs'][0x8]['value']:undefined)||''},{'name':_0xd068('0x6e'),'value':_0x655ec4[_0xd068('0x6e')]||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4['attrs'][0x9]?_0x655ec4[_0xd068('0x5c')][0x9][_0xd068('0x5d')]:undefined)||''},{'name':'attrChatWebsites','value':_0x655ec4[_0xd068('0x6f')]||(_0x655ec4['attrs']&&_0x655ec4[_0xd068('0x5c')][0xa]?_0x655ec4[_0xd068('0x5c')][0xa][_0xd068('0x5d')]:undefined)||''}];case'web-report':return[{'name':_0xd068('0x75'),'type':_0x655ec4[_0xd068('0x76')]||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4[_0xd068('0x5c')][0x0]?_0x655ec4['attrs'][0x0]['type']:undefined)||null,'value':_0x655ec4['attrReport']||(_0x655ec4[_0xd068('0x5c')]&&_0x655ec4['attrs'][0x0]?_0x655ec4[_0xd068('0x5c')][0x0][_0xd068('0x5d')]:undefined)||null},{'name':_0xd068('0x77'),'value':_0x655ec4[_0xd068('0x77')]||(_0x655ec4['attrs']&&_0x655ec4[_0xd068('0x5c')][0x1]?_0x655ec4[_0xd068('0x5c')][0x1]['value']:undefined)||0x0}];default:return[];}}catch(_0xe5d9b6){logger[_0xd068('0x53')](_0xd068('0x78'),JSON['stringify'](_0xe5d9b6));return[];}}exports[_0xd068('0x79')]=function(_0x175919,_0x435a07,_0x1edc6e){if(_0x175919[_0xd068('0x4f')]['id']){delete _0x175919[_0xd068('0x4f')]['id'];}return db[_0xd068('0x44')][_0xd068('0x4d')]({'where':{'id':_0x175919[_0xd068('0x4b')]['id']}})[_0xd068('0x2a')](handleEntityNotFound(_0x435a07,null))[_0xd068('0x2a')](function(_0x2c8657){if(_0x2c8657){_0x175919[_0xd068('0x4f')][_0xd068('0x7a')]=_0x2c8657['id'];_0x175919[_0xd068('0x4f')][_0xd068('0x5c')]=widgetAttributes(_0x175919[_0xd068('0x4f')]);return db[_0xd068('0x7b')]['create'](_0x175919[_0xd068('0x4f')]);}})[_0xd068('0x2a')](respondWithResult(_0x435a07,null))[_0xd068('0x49')](handleError(_0x435a07,null));};exports[_0xd068('0x7c')]=function(_0x13d117,_0x530ff2,_0x32de5d){var _0x15b595={};var _0x6d06bb={};var _0x4454ac;var _0x9a9ef0;return db[_0xd068('0x44')][_0xd068('0x7d')]({'where':{'id':_0x13d117[_0xd068('0x4b')]['id']}})[_0xd068('0x2a')](handleEntityNotFound(_0x530ff2,null))[_0xd068('0x2a')](function(_0x1d37da){if(_0x1d37da){_0x4454ac=_0x1d37da;_0x6d06bb[_0xd068('0x34')]=_[_0xd068('0x36')](db[_0xd068('0x7b')][_0xd068('0x7e')]);_0x6d06bb[_0xd068('0x35')]=_[_0xd068('0x36')](_0x13d117[_0xd068('0x35')]);_0x6d06bb[_0xd068('0x37')]=_['intersection'](_0x6d06bb[_0xd068('0x34')],_0x6d06bb[_0xd068('0x35')]);_0x15b595[_0xd068('0x39')]=_[_0xd068('0x38')](_0x6d06bb[_0xd068('0x34')],qs[_0xd068('0x3a')](_0x13d117[_0xd068('0x35')]['fields']));_0x15b595[_0xd068('0x39')]=_0x15b595[_0xd068('0x39')]['length']?_0x15b595[_0xd068('0x39')]:_0x6d06bb['model'];_0x15b595['order']=qs[_0xd068('0x3d')](_0x13d117['query'][_0xd068('0x3d')]);_0x15b595[_0xd068('0x3e')]=qs[_0xd068('0x37')](_['pick'](_0x13d117[_0xd068('0x35')],_0x6d06bb['filters']));if(_0x13d117['query'][_0xd068('0x40')]){_0x15b595[_0xd068('0x3e')]=_[_0xd068('0x42')](_0x15b595[_0xd068('0x3e')],{'$or':_['map'](_0x15b595[_0xd068('0x39')],function(_0x27e688){var _0x22aa22={};_0x22aa22[_0x27e688]={'$like':'%'+_0x13d117[_0xd068('0x35')]['filter']+'%'};return _0x22aa22;})});}_0x15b595=_[_0xd068('0x42')]({},_0x15b595,_0x13d117[_0xd068('0x43')]);return _0x4454ac[_0xd068('0x7c')](_0x15b595);}})[_0xd068('0x2a')](function(_0x26e31f){if(_0x26e31f){_0x9a9ef0=_0x26e31f[_0xd068('0x4c')];if(!_0x13d117['query'][_0xd068('0x7f')](_0xd068('0x3b'))){_0x15b595[_0xd068('0x23')]=qs[_0xd068('0x23')](_0x13d117[_0xd068('0x35')][_0xd068('0x23')]);_0x15b595[_0xd068('0x20')]=qs['offset'](_0x13d117[_0xd068('0x35')][_0xd068('0x20')]);}return _0x4454ac[_0xd068('0x7c')](_0x15b595);}})['then'](function(_0x3d8a9c){if(_0x3d8a9c){return _0x3d8a9c?{'count':_0x9a9ef0,'rows':_0x3d8a9c}:null;}})[_0xd068('0x2a')](respondWithResult(_0x530ff2,null))[_0xd068('0x49')](handleError(_0x530ff2,null));};