64ec2ec7a1cd89fff1408d83f1a369195b93c44b
[motion2.git] / server / api / analyticExtractedReport / analyticExtractedReport.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 _0xc4b2=['../../components/parsers/advancedSearch','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','end','status','json','undefined','limit','count','offset','set','apply','save','update','then','destroy','ExtractedReports','UserProfileResource','error','stack','name','send','map','AnalyticExtractedReport','rawAttributes','type','key','model','query','filters','attributes','fields','length','hasOwnProperty','nolimit','order','sort','pick','where','merge','filter','options','findAll','rows','catch','show','keys','intersection','includeAll','include','find','create','body','user','get','UserProfileSection','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','download','basename','savename','existsSync','join','root','server/files/reports','Sequelize','ValidationError','Report\x20not\x20found\x20or\x20empty','exists','%s.%s','output','toLowerCase','eml-format','zip-dir','request-promise','moment','bluebird','mustache','path','sox','to-csv','lodash','squel','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs'];(function(_0x41b796,_0x73452f){var _0x2f96bf=function(_0x5a9a67){while(--_0x5a9a67){_0x41b796['push'](_0x41b796['shift']());}};_0x2f96bf(++_0x73452f);}(_0xc4b2,0x1b2));var _0x2c4b=function(_0x1d5714,_0x2fa5f4){_0x1d5714=_0x1d5714-0x0;var _0x1b620e=_0xc4b2[_0x1d5714];return _0x1b620e;};'use strict';var emlformat=require(_0x2c4b('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x2c4b('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0x2c4b('0x2'));var moment=require(_0x2c4b('0x3'));var BPromise=require(_0x2c4b('0x4'));var Mustache=require(_0x2c4b('0x5'));var util=require('util');var path=require(_0x2c4b('0x6'));var sox=require(_0x2c4b('0x7'));var csv=require(_0x2c4b('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x2c4b('0x9'));var squel=require(_0x2c4b('0xa'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x2c4b('0xb'));var toCsv=require('to-csv');var querystring=require(_0x2c4b('0xc'));var Papa=require(_0x2c4b('0xd'));var Redis=require('ioredis');var authService=require(_0x2c4b('0xe'));var qs=require(_0x2c4b('0xf'));var as=require(_0x2c4b('0x10'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')('api');var utils=require(_0x2c4b('0x11'));var config=require('../../config/environment');var licenseUtil=require(_0x2c4b('0x12'));var db=require(_0x2c4b('0x13'))['db'];function respondWithStatusCode(_0x4f58d8,_0x1d6f0a){_0x1d6f0a=_0x1d6f0a||0xcc;return function(_0x1492d8){if(_0x1492d8){return _0x4f58d8[_0x2c4b('0x14')](_0x1d6f0a);}return _0x4f58d8['status'](_0x1d6f0a)[_0x2c4b('0x15')]();};}function respondWithResult(_0xa72bb1,_0x2981c6){_0x2981c6=_0x2981c6||0xc8;return function(_0x186aa5){if(_0x186aa5){return _0xa72bb1[_0x2c4b('0x16')](_0x2981c6)[_0x2c4b('0x17')](_0x186aa5);}};}function respondWithFilteredResult(_0x59cfdb,_0x793c4){return function(_0x30b9cb){if(_0x30b9cb){var _0x50447e=typeof _0x793c4['offset']===_0x2c4b('0x18')&&typeof _0x793c4[_0x2c4b('0x19')]===_0x2c4b('0x18');var _0x28fe87=_0x30b9cb[_0x2c4b('0x1a')];var _0x1bb1d6=_0x50447e?0x0:_0x793c4[_0x2c4b('0x1b')];var _0x5bebde=_0x50447e?_0x30b9cb[_0x2c4b('0x1a')]:_0x793c4[_0x2c4b('0x1b')]+_0x793c4[_0x2c4b('0x19')];var _0x2f0d06;if(_0x5bebde>=_0x28fe87){_0x5bebde=_0x28fe87;_0x2f0d06=0xc8;}else{_0x2f0d06=0xce;}_0x59cfdb['status'](_0x2f0d06);return _0x59cfdb[_0x2c4b('0x1c')]('Content-Range',_0x1bb1d6+'-'+_0x5bebde+'/'+_0x28fe87)['json'](_0x30b9cb);}return null;};}function patchUpdates(_0x49e850){return function(_0x52a6a2){try{jsonpatch[_0x2c4b('0x1d')](_0x52a6a2,_0x49e850,!![]);}catch(_0x223dc3){return BPromise['reject'](_0x223dc3);}return _0x52a6a2[_0x2c4b('0x1e')]();};}function saveUpdates(_0x541bce,_0x16e128){return function(_0x1351c3){if(_0x1351c3){return _0x1351c3[_0x2c4b('0x1f')](_0x541bce)[_0x2c4b('0x20')](function(_0x1d5875){return _0x1d5875;});}return null;};}function removeEntity(_0x66da48,_0x5f798d){return function(_0x20a835){if(_0x20a835){return _0x20a835[_0x2c4b('0x21')]()[_0x2c4b('0x20')](function(){var _0xd72f80=_0x20a835['get']({'plain':!![]});var _0x499f88=_0x2c4b('0x22');return db[_0x2c4b('0x23')][_0x2c4b('0x21')]({'where':{'type':_0x499f88,'resourceId':_0xd72f80['id']}})[_0x2c4b('0x20')](function(){return _0x20a835;});})[_0x2c4b('0x20')](function(){_0x66da48[_0x2c4b('0x16')](0xcc)[_0x2c4b('0x15')]();});}};}function handleEntityNotFound(_0x39fb95,_0x42da41){return function(_0x1624a4){if(!_0x1624a4){_0x39fb95['sendStatus'](0x194);}return _0x1624a4;};}function handleError(_0x31f46e,_0xf79c43){_0xf79c43=_0xf79c43||0x1f4;return function(_0x3d4232){logger[_0x2c4b('0x24')](_0x3d4232[_0x2c4b('0x25')]);if(_0x3d4232[_0x2c4b('0x26')]){delete _0x3d4232[_0x2c4b('0x26')];}_0x31f46e[_0x2c4b('0x16')](_0xf79c43)[_0x2c4b('0x27')](_0x3d4232);};}exports['index']=function(_0x153cd3,_0x1f97d8){var _0x4273a8={},_0x25b024={},_0x51eea1={'count':0x0,'rows':[]};var _0x4d7448=_[_0x2c4b('0x28')](db[_0x2c4b('0x29')][_0x2c4b('0x2a')],function(_0x167e4b){return{'name':_0x167e4b['fieldName'],'type':_0x167e4b[_0x2c4b('0x2b')][_0x2c4b('0x2c')]};});_0x25b024[_0x2c4b('0x2d')]=_[_0x2c4b('0x28')](_0x4d7448,'name');_0x25b024[_0x2c4b('0x2e')]=_['keys'](_0x153cd3[_0x2c4b('0x2e')]);_0x25b024[_0x2c4b('0x2f')]=_['intersection'](_0x25b024[_0x2c4b('0x2d')],_0x25b024[_0x2c4b('0x2e')]);_0x4273a8[_0x2c4b('0x30')]=_['intersection'](_0x25b024[_0x2c4b('0x2d')],qs[_0x2c4b('0x31')](_0x153cd3[_0x2c4b('0x2e')][_0x2c4b('0x31')]));_0x4273a8[_0x2c4b('0x30')]=_0x4273a8[_0x2c4b('0x30')][_0x2c4b('0x32')]?_0x4273a8['attributes']:_0x25b024['model'];if(!_0x153cd3['query'][_0x2c4b('0x33')](_0x2c4b('0x34'))){_0x4273a8['limit']=qs['limit'](_0x153cd3[_0x2c4b('0x2e')]['limit']);_0x4273a8[_0x2c4b('0x1b')]=qs[_0x2c4b('0x1b')](_0x153cd3[_0x2c4b('0x2e')][_0x2c4b('0x1b')]);}_0x4273a8[_0x2c4b('0x35')]=qs[_0x2c4b('0x36')](_0x153cd3[_0x2c4b('0x2e')]['sort']);_0x4273a8['where']=qs[_0x2c4b('0x2f')](_[_0x2c4b('0x37')](_0x153cd3['query'],_0x25b024[_0x2c4b('0x2f')]),_0x4d7448);if(_0x153cd3[_0x2c4b('0x2e')]['filter']){_0x4273a8[_0x2c4b('0x38')]=_[_0x2c4b('0x39')](_0x4273a8['where'],{'$or':_[_0x2c4b('0x28')](_0x4d7448,function(_0x378fd7){if(_0x378fd7[_0x2c4b('0x2b')]!=='VIRTUAL'){var _0x4f0dc5={};_0x4f0dc5[_0x378fd7[_0x2c4b('0x26')]]={'$like':'%'+_0x153cd3[_0x2c4b('0x2e')][_0x2c4b('0x3a')]+'%'};return _0x4f0dc5;}})});}_0x4273a8=_['merge']({},_0x4273a8,_0x153cd3[_0x2c4b('0x3b')]);var _0x119d3a={'where':_0x4273a8[_0x2c4b('0x38')]};return db[_0x2c4b('0x29')]['count'](_0x119d3a)[_0x2c4b('0x20')](function(_0x23e964){_0x51eea1[_0x2c4b('0x1a')]=_0x23e964;if(_0x153cd3[_0x2c4b('0x2e')]['includeAll']){_0x4273a8['include']=[{'all':!![]}];}return db[_0x2c4b('0x29')][_0x2c4b('0x3c')](_0x4273a8);})[_0x2c4b('0x20')](function(_0x301b28){_0x51eea1[_0x2c4b('0x3d')]=_0x301b28;return _0x51eea1;})[_0x2c4b('0x20')](respondWithFilteredResult(_0x1f97d8,_0x4273a8))[_0x2c4b('0x3e')](handleError(_0x1f97d8,null));};exports[_0x2c4b('0x3f')]=function(_0x2ac3fb,_0x51190e){var _0x2af070={'raw':!![],'where':{'id':_0x2ac3fb['params']['id']}},_0x28e7a2={};_0x28e7a2[_0x2c4b('0x2d')]=_[_0x2c4b('0x40')](db['AnalyticExtractedReport'][_0x2c4b('0x2a')]);_0x28e7a2['query']=_['keys'](_0x2ac3fb[_0x2c4b('0x2e')]);_0x28e7a2[_0x2c4b('0x2f')]=_[_0x2c4b('0x41')](_0x28e7a2[_0x2c4b('0x2d')],_0x28e7a2[_0x2c4b('0x2e')]);_0x2af070['attributes']=_[_0x2c4b('0x41')](_0x28e7a2[_0x2c4b('0x2d')],qs[_0x2c4b('0x31')](_0x2ac3fb[_0x2c4b('0x2e')][_0x2c4b('0x31')]));_0x2af070['attributes']=_0x2af070[_0x2c4b('0x30')][_0x2c4b('0x32')]?_0x2af070[_0x2c4b('0x30')]:_0x28e7a2['model'];if(_0x2ac3fb[_0x2c4b('0x2e')][_0x2c4b('0x42')]){_0x2af070[_0x2c4b('0x43')]=[{'all':!![]}];}_0x2af070=_[_0x2c4b('0x39')]({},_0x2af070,_0x2ac3fb[_0x2c4b('0x3b')]);return db[_0x2c4b('0x29')][_0x2c4b('0x44')](_0x2af070)['then'](handleEntityNotFound(_0x51190e,null))[_0x2c4b('0x20')](respondWithResult(_0x51190e,null))['catch'](handleError(_0x51190e,null));};exports[_0x2c4b('0x45')]=function(_0x4f538b,_0x5f5588){return db[_0x2c4b('0x29')]['create'](_0x4f538b[_0x2c4b('0x46')],{})[_0x2c4b('0x20')](function(_0x23a00e){var _0x1fc5ca=_0x4f538b[_0x2c4b('0x47')][_0x2c4b('0x48')]({'plain':!![]});if(!_0x1fc5ca)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x1fc5ca['role']===_0x2c4b('0x47')){var _0x227e39=_0x23a00e['get']({'plain':!![]});var _0x1fc464=_0x2c4b('0x22');return db[_0x2c4b('0x49')][_0x2c4b('0x44')]({'where':{'name':_0x1fc464,'userProfileId':_0x1fc5ca['userProfileId']},'raw':!![]})['then'](function(_0x1588f2){if(_0x1588f2&&_0x1588f2['autoAssociation']===0x0){return db[_0x2c4b('0x23')][_0x2c4b('0x45')]({'name':_0x227e39['name'],'resourceId':_0x227e39['id'],'type':_0x1588f2['name'],'sectionId':_0x1588f2['id']},{})[_0x2c4b('0x20')](function(){return _0x23a00e;});}else{return _0x23a00e;}})['catch'](function(_0xcd2a09){logger[_0x2c4b('0x24')](_0x2c4b('0x4a'),_0xcd2a09);throw _0xcd2a09;});}return _0x23a00e;})[_0x2c4b('0x20')](respondWithResult(_0x5f5588,0xc9))[_0x2c4b('0x3e')](handleError(_0x5f5588,null));};exports[_0x2c4b('0x1f')]=function(_0x111673,_0x242873){if(_0x111673[_0x2c4b('0x46')]['id']){delete _0x111673['body']['id'];}return db[_0x2c4b('0x29')][_0x2c4b('0x44')]({'where':{'id':_0x111673[_0x2c4b('0x4b')]['id']}})[_0x2c4b('0x20')](handleEntityNotFound(_0x242873,null))['then'](saveUpdates(_0x111673[_0x2c4b('0x46')],null))['then'](respondWithResult(_0x242873,null))[_0x2c4b('0x3e')](handleError(_0x242873,null));};exports[_0x2c4b('0x21')]=function(_0x42f2de,_0x524236){return db['AnalyticExtractedReport'][_0x2c4b('0x44')]({'where':{'id':_0x42f2de[_0x2c4b('0x4b')]['id']}})[_0x2c4b('0x20')](handleEntityNotFound(_0x524236,null))['then'](removeEntity(_0x524236,null))[_0x2c4b('0x3e')](handleError(_0x524236,null));};exports[_0x2c4b('0x4c')]=function(_0x4d1b42,_0xbfb66f,_0x6b6f96){return db[_0x2c4b('0x29')]['find']({'where':{'id':_0x4d1b42[_0x2c4b('0x4b')]['id']},'attributes':['name',_0x2c4b('0x4d'),_0x2c4b('0x4e'),'output'],'raw':!![]})[_0x2c4b('0x20')](handleEntityNotFound(_0xbfb66f,null))[_0x2c4b('0x20')](function(_0x28a652){if(_0x28a652){if(!fs[_0x2c4b('0x4f')](path[_0x2c4b('0x50')](config[_0x2c4b('0x51')],_0x2c4b('0x52'),_0x28a652[_0x2c4b('0x4e')]))){throw new db[(_0x2c4b('0x53'))][(_0x2c4b('0x54'))](_0x2c4b('0x55'));}if(_0x4d1b42[_0x2c4b('0x2e')][_0x2c4b('0x56')]){return _0xbfb66f[_0x2c4b('0x14')](0xc8);}return _0xbfb66f[_0x2c4b('0x4c')](path[_0x2c4b('0x50')](config[_0x2c4b('0x51')],_0x2c4b('0x52'),_0x28a652[_0x2c4b('0x4e')]),util['format'](_0x2c4b('0x57'),_0x28a652['basename']||_0x28a652['name'],_0x28a652[_0x2c4b('0x58')][_0x2c4b('0x59')]()));}})['catch'](handleError(_0xbfb66f,null));};