518971d9b232269c74e1edf4b65075a4fd01be9f
[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 _0x6fa0=['join','format','%s.%s','toLowerCase','zip-dir','request-promise','bluebird','mustache','util','path','to-csv','ejs','lodash','squel','crypto','desk.js','querystring','papaparse','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','undefined','limit','count','offset','set','Content-Range','reject','save','update','then','destroy','get','ExtractedReports','UserProfileResource','error','stack','name','send','index','map','AnalyticExtractedReport','rawAttributes','fieldName','type','key','model','keys','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','findAll','catch','params','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','download','basename','savename','output','existsSync','root','server/files/reports','ValidationError','Report\x20not\x20found\x20or\x20empty','exists'];(function(_0x5adee8,_0x2c4f67){var _0x473002=function(_0xad680d){while(--_0xad680d){_0x5adee8['push'](_0x5adee8['shift']());}};_0x473002(++_0x2c4f67);}(_0x6fa0,0x1ee));var _0x06fa=function(_0x2be8c2,_0x14a4b5){_0x2be8c2=_0x2be8c2-0x0;var _0x97f531=_0x6fa0[_0x2be8c2];return _0x97f531;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0x06fa('0x0'));var jsonpatch=require('fast-json-patch');var rp=require(_0x06fa('0x1'));var moment=require('moment');var BPromise=require(_0x06fa('0x2'));var Mustache=require(_0x06fa('0x3'));var util=require(_0x06fa('0x4'));var path=require(_0x06fa('0x5'));var sox=require('sox');var csv=require(_0x06fa('0x6'));var ejs=require(_0x06fa('0x7'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x06fa('0x8'));var squel=require(_0x06fa('0x9'));var crypto=require(_0x06fa('0xa'));var jsforce=require('jsforce');var deskjs=require(_0x06fa('0xb'));var toCsv=require('to-csv');var querystring=require(_0x06fa('0xc'));var Papa=require(_0x06fa('0xd'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x06fa('0xe'));var as=require(_0x06fa('0xf'));var hardwareService=require(_0x06fa('0x10'));var logger=require(_0x06fa('0x11'))(_0x06fa('0x12'));var utils=require(_0x06fa('0x13'));var config=require(_0x06fa('0x14'));var licenseUtil=require(_0x06fa('0x15'));var db=require(_0x06fa('0x16'))['db'];function respondWithStatusCode(_0xc20a2d,_0x1fb792){_0x1fb792=_0x1fb792||0xcc;return function(_0x3753dd){if(_0x3753dd){return _0xc20a2d[_0x06fa('0x17')](_0x1fb792);}return _0xc20a2d[_0x06fa('0x18')](_0x1fb792)[_0x06fa('0x19')]();};}function respondWithResult(_0xc5b318,_0x520a6f){_0x520a6f=_0x520a6f||0xc8;return function(_0x4ee1de){if(_0x4ee1de){return _0xc5b318[_0x06fa('0x18')](_0x520a6f)[_0x06fa('0x1a')](_0x4ee1de);}};}function respondWithFilteredResult(_0x41c270,_0x3aaf46){return function(_0x24982d){if(_0x24982d){var _0x533cfd=typeof _0x3aaf46['offset']===_0x06fa('0x1b')&&typeof _0x3aaf46[_0x06fa('0x1c')]===_0x06fa('0x1b');var _0x430207=_0x24982d[_0x06fa('0x1d')];var _0x4060ee=_0x533cfd?0x0:_0x3aaf46[_0x06fa('0x1e')];var _0x3d776c=_0x533cfd?_0x24982d[_0x06fa('0x1d')]:_0x3aaf46[_0x06fa('0x1e')]+_0x3aaf46[_0x06fa('0x1c')];var _0x584045;if(_0x3d776c>=_0x430207){_0x3d776c=_0x430207;_0x584045=0xc8;}else{_0x584045=0xce;}_0x41c270[_0x06fa('0x18')](_0x584045);return _0x41c270[_0x06fa('0x1f')](_0x06fa('0x20'),_0x4060ee+'-'+_0x3d776c+'/'+_0x430207)[_0x06fa('0x1a')](_0x24982d);}return null;};}function patchUpdates(_0x16ad82){return function(_0xfd37c8){try{jsonpatch['apply'](_0xfd37c8,_0x16ad82,!![]);}catch(_0x55d183){return BPromise[_0x06fa('0x21')](_0x55d183);}return _0xfd37c8[_0x06fa('0x22')]();};}function saveUpdates(_0x6ae0be,_0x6f70f8){return function(_0x4763f3){if(_0x4763f3){return _0x4763f3[_0x06fa('0x23')](_0x6ae0be)[_0x06fa('0x24')](function(_0x19faab){return _0x19faab;});}return null;};}function removeEntity(_0x1c1237,_0x149535){return function(_0xd66468){if(_0xd66468){return _0xd66468[_0x06fa('0x25')]()['then'](function(){var _0x308e1d=_0xd66468[_0x06fa('0x26')]({'plain':!![]});var _0x1ebfee=_0x06fa('0x27');return db[_0x06fa('0x28')][_0x06fa('0x25')]({'where':{'type':_0x1ebfee,'resourceId':_0x308e1d['id']}})[_0x06fa('0x24')](function(){return _0xd66468;});})['then'](function(){_0x1c1237['status'](0xcc)[_0x06fa('0x19')]();});}};}function handleEntityNotFound(_0x25bb7d,_0x18081d){return function(_0x5ba5a8){if(!_0x5ba5a8){_0x25bb7d[_0x06fa('0x17')](0x194);}return _0x5ba5a8;};}function handleError(_0x28514f,_0x58c3a3){_0x58c3a3=_0x58c3a3||0x1f4;return function(_0x1d4ab7){logger[_0x06fa('0x29')](_0x1d4ab7[_0x06fa('0x2a')]);if(_0x1d4ab7['name']){delete _0x1d4ab7[_0x06fa('0x2b')];}_0x28514f[_0x06fa('0x18')](_0x58c3a3)[_0x06fa('0x2c')](_0x1d4ab7);};}exports[_0x06fa('0x2d')]=function(_0x3f6f3e,_0x111f7d){var _0xaaae98={},_0x7b88a3={},_0x1cecc2={'count':0x0,'rows':[]};var _0x390d82=_[_0x06fa('0x2e')](db[_0x06fa('0x2f')][_0x06fa('0x30')],function(_0x3c45a0){return{'name':_0x3c45a0[_0x06fa('0x31')],'type':_0x3c45a0[_0x06fa('0x32')][_0x06fa('0x33')]};});_0x7b88a3[_0x06fa('0x34')]=_[_0x06fa('0x2e')](_0x390d82,_0x06fa('0x2b'));_0x7b88a3['query']=_[_0x06fa('0x35')](_0x3f6f3e[_0x06fa('0x36')]);_0x7b88a3[_0x06fa('0x37')]=_[_0x06fa('0x38')](_0x7b88a3[_0x06fa('0x34')],_0x7b88a3[_0x06fa('0x36')]);_0xaaae98[_0x06fa('0x39')]=_[_0x06fa('0x38')](_0x7b88a3['model'],qs[_0x06fa('0x3a')](_0x3f6f3e[_0x06fa('0x36')][_0x06fa('0x3a')]));_0xaaae98[_0x06fa('0x39')]=_0xaaae98[_0x06fa('0x39')][_0x06fa('0x3b')]?_0xaaae98[_0x06fa('0x39')]:_0x7b88a3[_0x06fa('0x34')];if(!_0x3f6f3e[_0x06fa('0x36')][_0x06fa('0x3c')](_0x06fa('0x3d'))){_0xaaae98['limit']=qs[_0x06fa('0x1c')](_0x3f6f3e[_0x06fa('0x36')][_0x06fa('0x1c')]);_0xaaae98[_0x06fa('0x1e')]=qs[_0x06fa('0x1e')](_0x3f6f3e[_0x06fa('0x36')][_0x06fa('0x1e')]);}_0xaaae98[_0x06fa('0x3e')]=qs[_0x06fa('0x3f')](_0x3f6f3e[_0x06fa('0x36')][_0x06fa('0x3f')]);_0xaaae98[_0x06fa('0x40')]=qs['filters'](_[_0x06fa('0x41')](_0x3f6f3e['query'],_0x7b88a3[_0x06fa('0x37')]),_0x390d82);if(_0x3f6f3e[_0x06fa('0x36')][_0x06fa('0x42')]){_0xaaae98[_0x06fa('0x40')]=_[_0x06fa('0x43')](_0xaaae98['where'],{'$or':_[_0x06fa('0x2e')](_0x390d82,function(_0x114001){if(_0x114001['type']!==_0x06fa('0x44')){var _0x225ee2={};_0x225ee2[_0x114001[_0x06fa('0x2b')]]={'$like':'%'+_0x3f6f3e[_0x06fa('0x36')][_0x06fa('0x42')]+'%'};return _0x225ee2;}})});}_0xaaae98=_['merge']({},_0xaaae98,_0x3f6f3e[_0x06fa('0x45')]);var _0x32f1b4={'where':_0xaaae98[_0x06fa('0x40')]};return db[_0x06fa('0x2f')][_0x06fa('0x1d')](_0x32f1b4)[_0x06fa('0x24')](function(_0x5ac314){_0x1cecc2[_0x06fa('0x1d')]=_0x5ac314;if(_0x3f6f3e[_0x06fa('0x36')][_0x06fa('0x46')]){_0xaaae98['include']=[{'all':!![]}];}return db['AnalyticExtractedReport'][_0x06fa('0x47')](_0xaaae98);})['then'](function(_0x23158b){_0x1cecc2['rows']=_0x23158b;return _0x1cecc2;})[_0x06fa('0x24')](respondWithFilteredResult(_0x111f7d,_0xaaae98))[_0x06fa('0x48')](handleError(_0x111f7d,null));};exports['show']=function(_0x4d278f,_0x2b4759){var _0x1cc43d={'raw':!![],'where':{'id':_0x4d278f[_0x06fa('0x49')]['id']}},_0x441ba9={};_0x441ba9[_0x06fa('0x34')]=_[_0x06fa('0x35')](db['AnalyticExtractedReport']['rawAttributes']);_0x441ba9[_0x06fa('0x36')]=_['keys'](_0x4d278f[_0x06fa('0x36')]);_0x441ba9[_0x06fa('0x37')]=_[_0x06fa('0x38')](_0x441ba9['model'],_0x441ba9[_0x06fa('0x36')]);_0x1cc43d[_0x06fa('0x39')]=_[_0x06fa('0x38')](_0x441ba9[_0x06fa('0x34')],qs[_0x06fa('0x3a')](_0x4d278f[_0x06fa('0x36')][_0x06fa('0x3a')]));_0x1cc43d[_0x06fa('0x39')]=_0x1cc43d[_0x06fa('0x39')][_0x06fa('0x3b')]?_0x1cc43d['attributes']:_0x441ba9[_0x06fa('0x34')];if(_0x4d278f['query'][_0x06fa('0x46')]){_0x1cc43d['include']=[{'all':!![]}];}_0x1cc43d=_[_0x06fa('0x43')]({},_0x1cc43d,_0x4d278f['options']);return db[_0x06fa('0x2f')][_0x06fa('0x4a')](_0x1cc43d)[_0x06fa('0x24')](handleEntityNotFound(_0x2b4759,null))[_0x06fa('0x24')](respondWithResult(_0x2b4759,null))[_0x06fa('0x48')](handleError(_0x2b4759,null));};exports['create']=function(_0x172a55,_0x43bb87){return db[_0x06fa('0x2f')][_0x06fa('0x4b')](_0x172a55[_0x06fa('0x4c')],{})[_0x06fa('0x24')](function(_0x5d0f03){var _0x328d0a=_0x172a55[_0x06fa('0x4d')][_0x06fa('0x26')]({'plain':!![]});if(!_0x328d0a)throw new Error(_0x06fa('0x4e'));if(_0x328d0a[_0x06fa('0x4f')]===_0x06fa('0x4d')){var _0x4b5096=_0x5d0f03[_0x06fa('0x26')]({'plain':!![]});var _0x17f5af=_0x06fa('0x27');return db[_0x06fa('0x50')][_0x06fa('0x4a')]({'where':{'name':_0x17f5af,'userProfileId':_0x328d0a[_0x06fa('0x51')]},'raw':!![]})['then'](function(_0x3be817){if(_0x3be817&&_0x3be817[_0x06fa('0x52')]===0x0){return db['UserProfileResource'][_0x06fa('0x4b')]({'name':_0x4b5096[_0x06fa('0x2b')],'resourceId':_0x4b5096['id'],'type':_0x3be817['name'],'sectionId':_0x3be817['id']},{})[_0x06fa('0x24')](function(){return _0x5d0f03;});}else{return _0x5d0f03;}})['catch'](function(_0x4ce17e){logger[_0x06fa('0x29')](_0x06fa('0x53'),_0x4ce17e);throw _0x4ce17e;});}return _0x5d0f03;})[_0x06fa('0x24')](respondWithResult(_0x43bb87,0xc9))[_0x06fa('0x48')](handleError(_0x43bb87,null));};exports[_0x06fa('0x23')]=function(_0x185f9f,_0x42dbfd){if(_0x185f9f[_0x06fa('0x4c')]['id']){delete _0x185f9f[_0x06fa('0x4c')]['id'];}return db['AnalyticExtractedReport'][_0x06fa('0x4a')]({'where':{'id':_0x185f9f[_0x06fa('0x49')]['id']}})['then'](handleEntityNotFound(_0x42dbfd,null))['then'](saveUpdates(_0x185f9f['body'],null))['then'](respondWithResult(_0x42dbfd,null))[_0x06fa('0x48')](handleError(_0x42dbfd,null));};exports[_0x06fa('0x25')]=function(_0x243e45,_0x57a430){return db['AnalyticExtractedReport'][_0x06fa('0x4a')]({'where':{'id':_0x243e45['params']['id']}})[_0x06fa('0x24')](handleEntityNotFound(_0x57a430,null))['then'](removeEntity(_0x57a430,null))['catch'](handleError(_0x57a430,null));};exports[_0x06fa('0x54')]=function(_0x2787c4,_0x1f602a,_0x2f7b71){return db[_0x06fa('0x2f')]['find']({'where':{'id':_0x2787c4['params']['id']},'attributes':['name',_0x06fa('0x55'),_0x06fa('0x56'),_0x06fa('0x57')],'raw':!![]})[_0x06fa('0x24')](handleEntityNotFound(_0x1f602a,null))[_0x06fa('0x24')](function(_0x237694){if(_0x237694){if(!fs[_0x06fa('0x58')](path['join'](config[_0x06fa('0x59')],_0x06fa('0x5a'),_0x237694[_0x06fa('0x56')]))){throw new db['Sequelize'][(_0x06fa('0x5b'))](_0x06fa('0x5c'));}if(_0x2787c4[_0x06fa('0x36')][_0x06fa('0x5d')]){return _0x1f602a[_0x06fa('0x17')](0xc8);}return _0x1f602a[_0x06fa('0x54')](path[_0x06fa('0x5e')](config[_0x06fa('0x59')],'server/files/reports',_0x237694[_0x06fa('0x56')]),util[_0x06fa('0x5f')](_0x06fa('0x60'),_0x237694[_0x06fa('0x55')]||_0x237694[_0x06fa('0x2b')],_0x237694['output'][_0x06fa('0x61')]()));}})[_0x06fa('0x48')](handleError(_0x1f602a,null));};