Built motion from commit (unavailable).|2.5.31
[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 _0xd4a2=['sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','limit','count','set','Content-Range','apply','reject','save','update','destroy','then','get','stack','name','send','index','map','AnalyticExtractedReport','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','where','pick','filter','merge','includeAll','include','findAll','rows','catch','params','rawAttributes','options','find','create','user','role','userProfileId','autoAssociation','UserProfileResource','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','download','basename','savename','output','join','root','Sequelize','ValidationError','Report\x20not\x20found\x20or\x20empty','exists','format','%s.%s','toLowerCase','eml-format','fast-json-patch','moment','mustache','path'];(function(_0x25ff14,_0x384501){var _0x1eef4d=function(_0x6df658){while(--_0x6df658){_0x25ff14['push'](_0x25ff14['shift']());}};_0x1eef4d(++_0x384501);}(_0xd4a2,0x173));var _0x2d4a=function(_0x3113ce,_0x5cf3b6){_0x3113ce=_0x3113ce-0x0;var _0x4f6ca7=_0xd4a2[_0x3113ce];return _0x4f6ca7;};'use strict';var emlformat=require(_0x2d4a('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0x2d4a('0x1'));var rp=require('request-promise');var moment=require(_0x2d4a('0x2'));var BPromise=require('bluebird');var Mustache=require(_0x2d4a('0x3'));var util=require('util');var path=require(_0x2d4a('0x4'));var sox=require(_0x2d4a('0x5'));var csv=require(_0x2d4a('0x6'));var ejs=require(_0x2d4a('0x7'));var fs=require('fs');var fs_extra=require(_0x2d4a('0x8'));var _=require('lodash');var squel=require(_0x2d4a('0x9'));var crypto=require(_0x2d4a('0xa'));var jsforce=require(_0x2d4a('0xb'));var deskjs=require(_0x2d4a('0xc'));var toCsv=require(_0x2d4a('0x6'));var querystring=require(_0x2d4a('0xd'));var Papa=require(_0x2d4a('0xe'));var Redis=require(_0x2d4a('0xf'));var authService=require(_0x2d4a('0x10'));var qs=require(_0x2d4a('0x11'));var as=require(_0x2d4a('0x12'));var hardwareService=require(_0x2d4a('0x13'));var logger=require('../../config/logger')('api');var utils=require(_0x2d4a('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0x2d4a('0x15'));var db=require(_0x2d4a('0x16'))['db'];function respondWithStatusCode(_0x45b9fb,_0x5ac803){_0x5ac803=_0x5ac803||0xcc;return function(_0x2f785f){if(_0x2f785f){return _0x45b9fb[_0x2d4a('0x17')](_0x5ac803);}return _0x45b9fb[_0x2d4a('0x18')](_0x5ac803)[_0x2d4a('0x19')]();};}function respondWithResult(_0x544622,_0x4be8b4){_0x4be8b4=_0x4be8b4||0xc8;return function(_0x2a1d0f){if(_0x2a1d0f){return _0x544622['status'](_0x4be8b4)[_0x2d4a('0x1a')](_0x2a1d0f);}};}function respondWithFilteredResult(_0x175bda,_0x11896d){return function(_0x3a3156){if(_0x3a3156){var _0x4c5287=typeof _0x11896d[_0x2d4a('0x1b')]==='undefined'&&typeof _0x11896d[_0x2d4a('0x1c')]==='undefined';var _0x435687=_0x3a3156[_0x2d4a('0x1d')];var _0x2188b2=_0x4c5287?0x0:_0x11896d[_0x2d4a('0x1b')];var _0x498956=_0x4c5287?_0x3a3156['count']:_0x11896d['offset']+_0x11896d[_0x2d4a('0x1c')];var _0x1966d1;if(_0x498956>=_0x435687){_0x498956=_0x435687;_0x1966d1=0xc8;}else{_0x1966d1=0xce;}_0x175bda[_0x2d4a('0x18')](_0x1966d1);return _0x175bda[_0x2d4a('0x1e')](_0x2d4a('0x1f'),_0x2188b2+'-'+_0x498956+'/'+_0x435687)[_0x2d4a('0x1a')](_0x3a3156);}return null;};}function patchUpdates(_0x56445a){return function(_0x49f378){try{jsonpatch[_0x2d4a('0x20')](_0x49f378,_0x56445a,!![]);}catch(_0x1f3e17){return BPromise[_0x2d4a('0x21')](_0x1f3e17);}return _0x49f378[_0x2d4a('0x22')]();};}function saveUpdates(_0x1a2d20,_0x2e7736){return function(_0x22dd0b){if(_0x22dd0b){return _0x22dd0b[_0x2d4a('0x23')](_0x1a2d20)['then'](function(_0x26e7b8){return _0x26e7b8;});}return null;};}function removeEntity(_0x3240a2,_0x2c3799){return function(_0x42d813){if(_0x42d813){return _0x42d813[_0x2d4a('0x24')]()[_0x2d4a('0x25')](function(){var _0x456d38=_0x42d813[_0x2d4a('0x26')]({'plain':!![]});var _0x54c910='ExtractedReports';return db['UserProfileResource'][_0x2d4a('0x24')]({'where':{'type':_0x54c910,'resourceId':_0x456d38['id']}})['then'](function(){return _0x42d813;});})[_0x2d4a('0x25')](function(){_0x3240a2[_0x2d4a('0x18')](0xcc)[_0x2d4a('0x19')]();});}};}function handleEntityNotFound(_0x1d2fa6,_0x13e769){return function(_0x326c38){if(!_0x326c38){_0x1d2fa6[_0x2d4a('0x17')](0x194);}return _0x326c38;};}function handleError(_0x27b358,_0x4f1fc8){_0x4f1fc8=_0x4f1fc8||0x1f4;return function(_0x436f53){logger['error'](_0x436f53[_0x2d4a('0x27')]);if(_0x436f53[_0x2d4a('0x28')]){delete _0x436f53[_0x2d4a('0x28')];}_0x27b358[_0x2d4a('0x18')](_0x4f1fc8)[_0x2d4a('0x29')](_0x436f53);};}exports[_0x2d4a('0x2a')]=function(_0x25ac5c,_0x2e8063){var _0x51b447={},_0x45a4fa={},_0x3d94b7={'count':0x0,'rows':[]};var _0xda1ef2=_[_0x2d4a('0x2b')](db[_0x2d4a('0x2c')]['rawAttributes'],function(_0x217653){return{'name':_0x217653[_0x2d4a('0x2d')],'type':_0x217653[_0x2d4a('0x2e')][_0x2d4a('0x2f')]};});_0x45a4fa[_0x2d4a('0x30')]=_['map'](_0xda1ef2,_0x2d4a('0x28'));_0x45a4fa[_0x2d4a('0x31')]=_[_0x2d4a('0x32')](_0x25ac5c[_0x2d4a('0x31')]);_0x45a4fa[_0x2d4a('0x33')]=_[_0x2d4a('0x34')](_0x45a4fa['model'],_0x45a4fa[_0x2d4a('0x31')]);_0x51b447[_0x2d4a('0x35')]=_[_0x2d4a('0x34')](_0x45a4fa[_0x2d4a('0x30')],qs[_0x2d4a('0x36')](_0x25ac5c['query'][_0x2d4a('0x36')]));_0x51b447[_0x2d4a('0x35')]=_0x51b447['attributes'][_0x2d4a('0x37')]?_0x51b447[_0x2d4a('0x35')]:_0x45a4fa[_0x2d4a('0x30')];if(!_0x25ac5c[_0x2d4a('0x31')][_0x2d4a('0x38')](_0x2d4a('0x39'))){_0x51b447['limit']=qs[_0x2d4a('0x1c')](_0x25ac5c[_0x2d4a('0x31')][_0x2d4a('0x1c')]);_0x51b447[_0x2d4a('0x1b')]=qs[_0x2d4a('0x1b')](_0x25ac5c[_0x2d4a('0x31')]['offset']);}_0x51b447['order']=qs[_0x2d4a('0x3a')](_0x25ac5c['query'][_0x2d4a('0x3a')]);_0x51b447[_0x2d4a('0x3b')]=qs['filters'](_[_0x2d4a('0x3c')](_0x25ac5c[_0x2d4a('0x31')],_0x45a4fa[_0x2d4a('0x33')]),_0xda1ef2);if(_0x25ac5c[_0x2d4a('0x31')][_0x2d4a('0x3d')]){_0x51b447[_0x2d4a('0x3b')]=_[_0x2d4a('0x3e')](_0x51b447[_0x2d4a('0x3b')],{'$or':_[_0x2d4a('0x2b')](_0xda1ef2,function(_0x2d64b0){if(_0x2d64b0[_0x2d4a('0x2e')]!=='VIRTUAL'){var _0x8bc995={};_0x8bc995[_0x2d64b0[_0x2d4a('0x28')]]={'$like':'%'+_0x25ac5c[_0x2d4a('0x31')][_0x2d4a('0x3d')]+'%'};return _0x8bc995;}})});}_0x51b447=_[_0x2d4a('0x3e')]({},_0x51b447,_0x25ac5c['options']);var _0x50dbc3={'where':_0x51b447['where']};return db['AnalyticExtractedReport'][_0x2d4a('0x1d')](_0x50dbc3)[_0x2d4a('0x25')](function(_0xf39020){_0x3d94b7[_0x2d4a('0x1d')]=_0xf39020;if(_0x25ac5c['query'][_0x2d4a('0x3f')]){_0x51b447[_0x2d4a('0x40')]=[{'all':!![]}];}return db['AnalyticExtractedReport'][_0x2d4a('0x41')](_0x51b447);})[_0x2d4a('0x25')](function(_0x8a9375){_0x3d94b7[_0x2d4a('0x42')]=_0x8a9375;return _0x3d94b7;})[_0x2d4a('0x25')](respondWithFilteredResult(_0x2e8063,_0x51b447))[_0x2d4a('0x43')](handleError(_0x2e8063,null));};exports['show']=function(_0x236fbf,_0x2d6eca){var _0x12c899={'raw':!![],'where':{'id':_0x236fbf[_0x2d4a('0x44')]['id']}},_0x365399={};_0x365399[_0x2d4a('0x30')]=_['keys'](db[_0x2d4a('0x2c')][_0x2d4a('0x45')]);_0x365399[_0x2d4a('0x31')]=_['keys'](_0x236fbf[_0x2d4a('0x31')]);_0x365399['filters']=_[_0x2d4a('0x34')](_0x365399[_0x2d4a('0x30')],_0x365399[_0x2d4a('0x31')]);_0x12c899[_0x2d4a('0x35')]=_[_0x2d4a('0x34')](_0x365399['model'],qs['fields'](_0x236fbf[_0x2d4a('0x31')][_0x2d4a('0x36')]));_0x12c899['attributes']=_0x12c899[_0x2d4a('0x35')]['length']?_0x12c899[_0x2d4a('0x35')]:_0x365399[_0x2d4a('0x30')];if(_0x236fbf[_0x2d4a('0x31')]['includeAll']){_0x12c899[_0x2d4a('0x40')]=[{'all':!![]}];}_0x12c899=_['merge']({},_0x12c899,_0x236fbf[_0x2d4a('0x46')]);return db[_0x2d4a('0x2c')][_0x2d4a('0x47')](_0x12c899)[_0x2d4a('0x25')](handleEntityNotFound(_0x2d6eca,null))[_0x2d4a('0x25')](respondWithResult(_0x2d6eca,null))[_0x2d4a('0x43')](handleError(_0x2d6eca,null));};exports[_0x2d4a('0x48')]=function(_0x2b2f4b,_0x1ffb96){return db[_0x2d4a('0x2c')][_0x2d4a('0x48')](_0x2b2f4b['body'],{})[_0x2d4a('0x25')](function(_0x26a070){var _0x3336b2=_0x2b2f4b[_0x2d4a('0x49')][_0x2d4a('0x26')]({'plain':!![]});if(!_0x3336b2)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x3336b2[_0x2d4a('0x4a')]===_0x2d4a('0x49')){var _0x2123e8=_0x26a070[_0x2d4a('0x26')]({'plain':!![]});var _0x2f038a='ExtractedReports';return db['UserProfileSection'][_0x2d4a('0x47')]({'where':{'name':_0x2f038a,'userProfileId':_0x3336b2[_0x2d4a('0x4b')]},'raw':!![]})['then'](function(_0x15e204){if(_0x15e204&&_0x15e204[_0x2d4a('0x4c')]===0x0){return db[_0x2d4a('0x4d')][_0x2d4a('0x48')]({'name':_0x2123e8['name'],'resourceId':_0x2123e8['id'],'type':_0x15e204[_0x2d4a('0x28')],'sectionId':_0x15e204['id']},{})['then'](function(){return _0x26a070;});}else{return _0x26a070;}})[_0x2d4a('0x43')](function(_0x3fe91b){logger[_0x2d4a('0x4e')](_0x2d4a('0x4f'),_0x3fe91b);throw _0x3fe91b;});}return _0x26a070;})[_0x2d4a('0x25')](respondWithResult(_0x1ffb96,0xc9))[_0x2d4a('0x43')](handleError(_0x1ffb96,null));};exports[_0x2d4a('0x23')]=function(_0x1b088c,_0x5d086a){if(_0x1b088c[_0x2d4a('0x50')]['id']){delete _0x1b088c[_0x2d4a('0x50')]['id'];}return db[_0x2d4a('0x2c')][_0x2d4a('0x47')]({'where':{'id':_0x1b088c[_0x2d4a('0x44')]['id']}})[_0x2d4a('0x25')](handleEntityNotFound(_0x5d086a,null))[_0x2d4a('0x25')](saveUpdates(_0x1b088c[_0x2d4a('0x50')],null))[_0x2d4a('0x25')](respondWithResult(_0x5d086a,null))[_0x2d4a('0x43')](handleError(_0x5d086a,null));};exports[_0x2d4a('0x24')]=function(_0x113bc4,_0x1b4ae7){return db[_0x2d4a('0x2c')][_0x2d4a('0x47')]({'where':{'id':_0x113bc4[_0x2d4a('0x44')]['id']}})[_0x2d4a('0x25')](handleEntityNotFound(_0x1b4ae7,null))['then'](removeEntity(_0x1b4ae7,null))[_0x2d4a('0x43')](handleError(_0x1b4ae7,null));};exports[_0x2d4a('0x51')]=function(_0x5aafa4,_0x477ffd,_0x343f25){return db[_0x2d4a('0x2c')][_0x2d4a('0x47')]({'where':{'id':_0x5aafa4[_0x2d4a('0x44')]['id']},'attributes':[_0x2d4a('0x28'),_0x2d4a('0x52'),_0x2d4a('0x53'),_0x2d4a('0x54')],'raw':!![]})[_0x2d4a('0x25')](handleEntityNotFound(_0x477ffd,null))[_0x2d4a('0x25')](function(_0x302323){if(_0x302323){if(!fs['existsSync'](path[_0x2d4a('0x55')](config[_0x2d4a('0x56')],'server/files/reports',_0x302323[_0x2d4a('0x53')]))){throw new db[(_0x2d4a('0x57'))][(_0x2d4a('0x58'))](_0x2d4a('0x59'));}if(_0x5aafa4[_0x2d4a('0x31')][_0x2d4a('0x5a')]){return _0x477ffd[_0x2d4a('0x17')](0xc8);}return _0x477ffd[_0x2d4a('0x51')](path[_0x2d4a('0x55')](config[_0x2d4a('0x56')],'server/files/reports',_0x302323[_0x2d4a('0x53')]),util[_0x2d4a('0x5b')](_0x2d4a('0x5c'),_0x302323['basename']||_0x302323[_0x2d4a('0x28')],_0x302323[_0x2d4a('0x54')][_0x2d4a('0x5d')]()));}})[_0x2d4a('0x43')](handleError(_0x477ffd,null));};